From 572df690f72ed4a077d934823f261dec39b3cc7d Mon Sep 17 00:00:00 2001
From: 刘帅 <rr.iii@qq.com>
Date: 星期二, 08 九月 2026 17:11:34 +0800
Subject: [PATCH] feat&bug：文档内容修改
---
cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java | 759 ++++++++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 599 insertions(+), 160 deletions(-)
diff --git a/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
index ea1db91..1fe0c96 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
@@ -1,12 +1,19 @@
package com.dsh.other.controller;
+import cn.hutool.core.date.DateUtil;
import cn.hutool.http.HttpRequest;
import cn.hutool.http.HttpResponse;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.dsh.other.entity.*;
+import com.dsh.other.enums.EnableStatusEnum;
+import com.dsh.other.enums.QrLinkTypeEnum;
+import com.dsh.other.enums.SiteBookingStatusEnum;
+import com.dsh.other.mapper.QrLinkMapper;
+import com.dsh.other.feignclient.CourseRecordClient;
import com.dsh.other.feignclient.account.CityManagerClient;
import com.dsh.other.feignclient.activity.UserCouponClient;
import com.dsh.other.feignclient.activity.model.QueryUserCouponByIdAndUserId;
@@ -14,18 +21,20 @@
import com.dsh.other.feignclient.model.BillingDataRequestVo;
import com.dsh.other.feignclient.model.SiteChangeStateVO;
import com.dsh.other.feignclient.model.SiteVo;
+import com.dsh.other.mapper.TOperatorUserMapper;
import com.dsh.other.model.*;
import com.dsh.other.model.dto.siteDto.TSiteDTO;
import com.dsh.other.model.vo.siteVo.ExpireSiteSearchVO;
import com.dsh.other.model.vo.siteVo.SiteSearchVO;
import com.dsh.other.service.*;
-import com.dsh.other.util.PayMoneyUtil;
-import com.dsh.other.util.RedisUtil;
-import com.dsh.other.util.ResultUtil;
-import com.dsh.other.util.TokenUtil;
+import com.dsh.other.util.*;
+import com.dsh.other.util.wx.WxV3PayConfig;
+import com.wechat.pay.contrib.apache.httpclient.util.AesUtil;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.web.bind.annotation.*;
@@ -34,9 +43,15 @@
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+import java.io.BufferedReader;
import java.io.PrintWriter;
+import java.math.BigDecimal;
+import java.nio.charset.StandardCharsets;
import java.text.SimpleDateFormat;
+import java.time.DayOfWeek;
+import java.time.LocalDate;
import java.util.*;
+import java.security.SecureRandom;
import java.util.stream.Collectors;
/**
@@ -45,7 +60,11 @@
*/
@RestController
@RequestMapping("")
+@Slf4j
public class SiteController {
+
+ private static final char[] ENTRY_CODE_CHARS = "23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz".toCharArray();
+ private final SecureRandom entryCodeRandom = new SecureRandom();
@Autowired
private ISiteService siteService;
@@ -63,39 +82,123 @@
private ISiteBookingService siteBookingService;
@Resource
- private UserCouponClient userCouponClient;
- @Autowired
- private CityManagerClient cityManagerClient;
+ private QrLinkMapper qrLinkMapper;
+ @Resource
+ private UserCouponClient userCouponClient;
+
+ @Resource
+ private CityManagerClient cityManagerClient;
+ @Autowired
+ private IOperatorUserService operatorUserService;
+
+ @Autowired
+ private TGameConfigService gameConfigService;
+
+ @Autowired
+ private TGameRecordService gameRecordService;
+
+ @Resource
+ private CourseRecordClient courseRecordClient;
+@Resource
+private StoreService storeService;
+
+ @Autowired
+ private RedisUtil redisUtil;
+
+
+
+
+
+
+
+
+
+
+
+
+ /**
+ * 通过运营商id查询运营商对应的支付宝商户号
+ */
+ @RequestMapping("/base/getSMIDByOperatorId")
+ @ResponseBody
+ public String getSMIDByOperatorId(Integer id) {
+ return siteService.getSMIDByOperatorId(id);
+ }
+ /**
+ * 通过运营商id查询运营商对应的微信商户号
+ */
+ @RequestMapping("/base/getmerchantNumberByOperatorId/{id}")
+ @ResponseBody
+ public String getmerchantNumberByOperatorId(@PathVariable("id")Integer id) {
+ return siteService.getmerchantNumberByOperatorId(id);
+ }
+
+ /**
+ * 通过运营商id 获取支付宝商户号
+ * @param id
+ * @return
+ */
+ @RequestMapping("/base/getmerchantNumberAliByOperatorId/{id}")
+ @ResponseBody
+ public String getmerchantNumberAliByOperatorId(@PathVariable("id")Integer id) {
+ return siteService.getmerchantNumberAliByOperatorId(id);
+ }
+ /**
+ * 根据运营商id获取对应运营商分账比例 返回格式: 微信分账比例,支付宝分账比例
+ */
+ @RequestMapping("/base/getProportionByOperatorId/{id}")
+ @ResponseBody
+ public String getProportionByOperatorId(@PathVariable("id")Integer id) {
+ OperatorUser operatorId = operatorUserService.getOne(
+ new QueryWrapper<OperatorUser>().eq("operatorId",id)
+ );
+ if (operatorId.getWechatProportion() == null){
+ operatorId.setWechatProportion("0");
+ }
+ if (operatorId.getAlipayProportion() == null){
+ operatorId.setAlipayProportion("0");
+ }
+ System.err.println("查询分账比例"+operatorId);
+ return operatorId.getWechatProportion()+","+operatorId.getAlipayProportion();
+ }
/**
* 获取所有场地
*/
@RequestMapping("/base/site/getList")
@ResponseBody
- public List<Site> getList(){
- return siteService.list(new QueryWrapper<Site>().ne("state",3));
+ public List<Site> getList() {
+ return siteService.list(new QueryWrapper<Site>()
+ .ne("state", 3)
+ .orderByDesc("insertTime")
+ .orderByDesc("id"));
}
+
/**
* 获取场地预约记录
*/
@RequestMapping("/base/site/listAll")
- public List<SiteBooking> listAll(@RequestBody SiteBookingQuery query){
+ public List<SiteBooking> listAll(@RequestBody SiteBookingQuery query) {
return siteBookingService.listAll(query);
}
+
/**
* 获取所有场地
+ *
* @return
*/
@RequestMapping("/base/site/list")
- public List<TSiteDTO> listAll(@RequestBody SiteSearchVO vo){
+ public List<TSiteDTO> listAll(@RequestBody SiteSearchVO vo) {
return siteTypeService.listAll(vo);
}
+
/**
* 获取场地有效期在两个月内的场地列表
+ *
* @return
*/
@RequestMapping("/base/site/listExipre")
- public List<TSiteDTO> listExipre(@RequestBody ExpireSiteSearchVO vo){
+ public List<TSiteDTO> listExipre(@RequestBody ExpireSiteSearchVO vo) {
return siteTypeService.listExipre(vo);
@@ -105,83 +208,98 @@
* 上/下架、删除常见问题 type=1为上架 2为下架 3为删除
*/
@RequestMapping("/base/site/changeState")
- public Object changeState(@RequestBody SiteChangeStateVO vo){
+ public Object changeState(@RequestBody SiteChangeStateVO vo) {
return siteService.changeState(vo);
}
+
/**
* 添加场地管理
+ *
* @return
*/
@RequestMapping("/base/site/addSite")
- public Integer addSite(@RequestBody Site site){
- if(site.getId()!= null ){
+ public Integer addSite(@RequestBody Site site) {
+ if (site.getId() != null) {
siteService.updateById(site);
return site.getId();
- }else {
+ } else {
boolean save = siteService.save(site);
return site.getId();
}
}
-
/**
* 添加场地管理
+ *
+ * @return
+ */
+ @RequestMapping("/base/site/addSite1")
+ public Integer addSite1(@RequestBody Site site) {
+ boolean save = siteService.save(site);
+ return site.getId();
+ }
+ /**
+ * 添加场地管理
+ *
* @return
*/
@RequestMapping("/base/site/addSiteBooking")
- public Object addSiteBooking(@RequestBody SiteBooking siteBooking){
- if(siteBooking.getId()!= null ){
+ public Object addSiteBooking(@RequestBody SiteBooking siteBooking) {
+ if (siteBooking.getId() != null) {
return siteBookingService.updateById(siteBooking);
- }else {
+ } else {
return siteBookingService.save(siteBooking);
}
}
@RequestMapping("/base/site/listById")
- public Site listById(@RequestParam("id") Integer id){
+ public Site listById(@RequestBody Integer id) {
Site byId = siteService.getById(id);
return byId;
}
@RequestMapping("/base/site/listBooks")
- public List<SiteBooking> listBooks(@RequestParam("id") Integer id){
+ public List<SiteBooking> listBooks(@RequestBody Integer id) {
List<SiteBooking> siteId = siteBookingService.list(new QueryWrapper<SiteBooking>().eq("siteId", id));
return siteId;
}
+
@ResponseBody
@PostMapping("/base/site/querySiteType")
@ApiOperation(value = "获取场地类型", tags = {"用户—预约场地"})
@ApiImplicitParams({
})
- public ResultUtil<List<BaseVo>> querySiteType(){
+ public ResultUtil<List<BaseVo>> querySiteType() {
try {
List<BaseVo> list = siteTypeService.querySiteType();
return ResultUtil.success(list);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
+ @Autowired
+ private ITSitePriceService sitePriceService;
@ResponseBody
@PostMapping("/base/site/querySiteList")
@ApiOperation(value = "获取场地列表", tags = {"用户—预约场地"})
@ApiImplicitParams({
})
- public ResultUtil<List<QuerySiteListVo>> querySiteList(QuerySiteList querySiteList){
+ public ResultUtil<List<QuerySiteListVo>> querySiteList(QuerySiteList querySiteList) {
try {
+
+
List<QuerySiteListVo> querySiteListVos = siteService.querySiteList(querySiteList);
return ResultUtil.success(querySiteListVos);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
@ResponseBody
@@ -192,18 +310,15 @@
@ApiImplicitParam(value = "经度", name = "lon", dataType = "string", required = false),
@ApiImplicitParam(value = "纬度", name = "lat", dataType = "string", required = false),
})
- public ResultUtil<QuerySiteInfoVo> querySiteInfo(Integer id, String lon, String lat){
+ public ResultUtil<QuerySiteInfoVo> querySiteInfo(Integer id, String lon, String lat) {
try {
QuerySiteInfoVo querySiteInfoVo = siteService.querySiteInfo(id, lon, lat);
return ResultUtil.success(querySiteInfoVo);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
- @Autowired
- private RedisUtil redisUtil;
@ResponseBody
@PostMapping("/base/site/querySiteTimes")
@@ -212,51 +327,55 @@
@ApiImplicitParam(value = "场地id", name = "id", dataType = "int", required = true),
@ApiImplicitParam(value = "日期（2023-01-01）", name = "day", dataType = "string", required = true),
@ApiImplicitParam(value = "半场名称", name = "halfName", dataType = "string", required = false),
- @ApiImplicitParam(value = "选择场地的名称", name = "siteName", dataType = "string", required = false)
+ @ApiImplicitParam(value = "选择场地的名称", name = "siteName", dataType = "string", required = false),
+ @ApiImplicitParam(value = "入场方式 1订场 2散客", name = "targetAudience",defaultValue = "1",dataType = "string", required = true),
})
- public ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day,String halfName,String siteName){
+ public ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day, String halfName, String siteName,Integer targetAudience) {
try {
- List<QuerySiteTimes> list = siteService.querySiteTimes(id, day,halfName,siteName);
+ List<QuerySiteTimes> list = siteService.querySiteTimes(id, day, halfName, siteName,targetAudience);
return ResultUtil.success(list);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-// public ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day, String halfName, String siteName) throws Exception {
-//
-// if (redisUtil.acquireLock(day,day)) {
-// try {
-// List<QuerySiteTimes> list = siteService.querySiteTimes(id, day,halfName,siteName);
-// return ResultUtil.success(list);
-// } finally {
-// redisUtil.releaseLock(day);
-// }
-// } else {
-// return ResultUtil.error("系统繁忙,请稍后再试！");
-// }
-//
-// }
+
/**
* 根据id获取数据
+ *
* @param id
* @return
*/
@ResponseBody
@PostMapping("/site/querySiteById")
- public Site querySiteById(@RequestBody Integer id){
+ public Site querySiteById(@RequestBody Integer id) {
try {
return siteService.getById(id);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return null;
}
}
-
+ /**
+ * 根据id获取数据
+ *
+ * @param ids
+ * @return
+ */
+ @ResponseBody
+ @PostMapping("/site/querySiteByStoreIds")
+ public List<Site> querySiteByStoreIds(@RequestBody String ids) {
+ try {
+ return siteService.lambdaQuery().in(Site::getStoreId,Arrays.asList(ids.split(","))).list();
+ } catch (Exception e) {
+ e.printStackTrace();
+ return null;
+ }
+ }
@ResponseBody
@@ -265,95 +384,245 @@
@ApiImplicitParams({
@ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
})
- public ResultUtil reservationSite(ReservationSite reservationSite){
+ public ResultUtil reservationSite(ReservationSite reservationSite) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
+// Integer uid = 201;
return siteService.reservationSite(uid, reservationSite);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-// public ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day, String halfName, String siteName) throws Exception {
-//
-// if (redisUtil.acquireLock(day,day)) {
-// try {
-// List<QuerySiteTimes> list = siteService.querySiteTimes(id, day,halfName,siteName);
-// return ResultUtil.success(list);
-// } finally {
-// redisUtil.releaseLock(day);
-// }
-// } else {
-// return ResultUtil.error("系统繁忙,请稍后再试！");
-// }
-//
-// }
/**
* 购买课程微信支付回调
+ *
+ * @param request
+ * @param response
+ */
+ @ResponseBody
+ @PostMapping("/base/site/weChatPaymentSiteCallback1")
+ public void weChatPaymentSiteCallback1(HttpServletRequest request, HttpServletResponse response) {
+ try {
+ System.err.println("微信回调");
+ System.err.println("请求" + request);
+ BufferedReader reader = request.getReader();
+ String string1 = reader.toString();
+ System.err.println("请求reader" + string1);
+ StringBuilder requestBody = new StringBuilder();
+ String line;
+ while ((line = reader.readLine()) != null) {
+ requestBody.append(line);
+ }
+ System.err.println("全部请求体" + requestBody);
+ JSONObject jsonObject = JSONObject.parseObject(requestBody.toString());
+ JSONObject resource = jsonObject.getJSONObject("resource");
+
+ AesUtil aesUtil = new AesUtil(WxV3PayConfig.apiV3Key.getBytes(StandardCharsets.UTF_8));
+ String decryptedData = aesUtil.decryptToString(resource.getString("associated_data").getBytes(StandardCharsets.UTF_8), resource.getString("nonce").getBytes(StandardCharsets.UTF_8),
+ resource.getString("ciphertext"));
+ System.err.println("微信解密的字符串信息" + decryptedData);
+ JSONObject jsonInfo = (JSONObject) JSONObject.parse(decryptedData);
+ String code = jsonInfo.getString("out_trade_no");
+ String transaction_id = jsonInfo.getString("transaction_id");
+ String trade_state = jsonInfo.getString("trade_state");
+ if (trade_state.equals("SUCCESS")) {
+ SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("orderNo", code).eq("state", 1));
+ if (siteBooking.getStatus() == 0) {
+ siteBooking.setPayTime(new Date());
+ siteBooking.setStatus(1);
+ siteBooking.setPayOrderNo(transaction_id);
+ siteBookingService.updateById(siteBooking);
+ PrintWriter out = response.getWriter();
+ out.write("SUCCESS");
+ out.flush();
+ out.close();
+ }
+
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+ /**
+ * 购买课程微信支付回调
+ *
* @param request
* @param response
*/
@ResponseBody
@PostMapping("/base/site/weChatPaymentSiteCallback")
- public void weChatPaymentSiteCallback(HttpServletRequest request, HttpServletResponse response){
+ public void weChatPaymentSiteCallback(HttpServletRequest request, HttpServletResponse response) {
try {
+ System.err.println("预约场地回调");
Map<String, String> map = payMoneyUtil.weixinpayCallback(request);
- if(null != map){
+ if (null != map) {
String code = map.get("out_trade_no");
String transaction_id = map.get("transaction_id");
String result = map.get("result");
SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("orderNo", code).eq("state", 1));
- if(siteBooking.getStatus() == 0){
+ if (siteBooking.getStatus() == 0) {
siteBooking.setPayTime(new Date());
siteBooking.setStatus(1);
siteBooking.setPayOrderNo(transaction_id);
siteBookingService.updateById(siteBooking);
+ Store byId = service.getById(siteBooking.getStoreId());
+// if (byId.getOperatorId()!=null && byId.getOperatorId()!=0){
+// System.err.println("预约场地分账");
+// // 休眠两分钟后再调用分账接口 避免提示订单正在处理中
+// Thread.sleep(120000);
+// // 根据运营商id获取对应运营商分账比例 返回格式: 微信分账比例,支付宝分账比例
+// OperatorUser operatorId = operatorUserService.getOne(
+// new QueryWrapper<OperatorUser>().eq("operatorId",byId.getOperatorId())
+// );
+// if (operatorId.getWechatProportion() == null){
+// operatorId.setWechatProportion("0");
+// }
+// if (operatorId.getAlipayProportion() == null){
+// operatorId.setAlipayProportion("0");
+// }
+// String proportion= operatorId.getWechatProportion()+","+operatorId.getAlipayProportion();
+// String[] split = proportion.split(",");
+// String s1 = split[0];
+// if (!s1.equals("未设置")){
+// BigDecimal bigDecimal = new BigDecimal(s1);
+// // 分账比例
+// BigDecimal bigDecimal1 = bigDecimal.divide(new BigDecimal(100)).setScale(2);
+// // 微信商户号
+// String s2 =siteService.getmerchantNumberByOperatorId(byId.getOperatorId());
+// String nonce_str = UUIDUtil.getRandomCode(16);
+// BigDecimal bigDecimal2 = new BigDecimal(siteBooking.getPayMoney());
+// ResultUtil fenzhang = payMoneyUtil.fenzhang(transaction_id, bigDecimal2.multiply(bigDecimal1), s2,nonce_str,"预约场地分账");
+// if (!fenzhang.getCode().equals(200)){
+// System.err.println("分账失败 原因是:"+fenzhang.getMsg());
+// }else{
+// siteBooking.setFenzhangNo(fenzhang.getData().toString());
+// siteBooking.setFenzhangOrderNo(nonce_str);
+// siteBooking.setFenzhangAmount(bigDecimal2.multiply(bigDecimal1));
+// siteBookingService.updateById(siteBooking);
+// }
+// }
+// }
+ PrintWriter out = response.getWriter();
+ out.write(result);
+ out.flush();
+ out.close();
}
- PrintWriter out = response.getWriter();
- out.write(result);
- out.flush();
- out.close();
+
}
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
}
}
-
-
/**
* 预约场地支付宝回调
+ *
* @param request
* @param response
*/
@ResponseBody
@PostMapping("/base/site/aliPaymentSiteCallback")
- public void aliPaymentSiteCallback(HttpServletRequest request, HttpServletResponse response){
+ public void aliPaymentSiteCallback(HttpServletRequest request, HttpServletResponse response) {
try {
- System.out.println("回调回调回调");
+ System.err.println("预约场地回调");
Map<String, String> map = payMoneyUtil.alipayCallback(request);
- if(null != map){
+ System.err.println("map");
+ System.err.println(map);
+ if (null != map) {
String code = map.get("out_trade_no");
String trade_no = map.get("trade_no");
- SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("orderNo", code).eq("state", 1));
- if(siteBooking.getStatus() == 0){
+ SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>()
+ .eq("orderNo", code).eq("state", 1));
+ if (siteBooking == null) {
+ throw new IllegalStateException("未找到支付宝回调对应的场地预约订单：" + code);
+ }
+ if (siteBooking.getStatus() == 0) {
siteBooking.setPayTime(new Date());
siteBooking.setStatus(1);
siteBooking.setPayOrderNo(trade_no);
siteBookingService.updateById(siteBooking);
}
+ // 已处理的重复通知也必须确认 success，避免支付宝持续重试。
PrintWriter out = response.getWriter();
out.write("success");
out.flush();
out.close();
}
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
+ }
+ }
+
+
+
+
+
+ /**
+ * 启动游戏支付宝回调
+ *
+ * @param request
+ * @param response
+ */
+ @ResponseBody
+ @PostMapping("/base/site/gameCallback")
+ public void gameCallback(HttpServletRequest request, HttpServletResponse response) {
+ try {
+ Map<String, String> map = payMoneyUtil.alipayCallback(request);
+ if (null != map) {
+ String code = map.get("passback_params");
+ String trade_no = map.get("trade_no");
+ String[] s = code.split("_");
+ Integer i = startGame(Integer.valueOf(s[0]), Integer.valueOf(s[1]), Integer.valueOf(s[2]), Integer.valueOf(s[3]));
+ List<TGameRecord> list = gameRecordService.list(new QueryWrapper<TGameRecord>().eq("number", s[4]).eq("payType", 2));
+ TGameRecord one = list.get(0);
+ TGameConfig config = gameConfigService.getById(s[5]);
+ for (TGameRecord coursePackagePayment : list) {
+ coursePackagePayment.setStatus(1);
+ coursePackagePayment.setMoney(config.getCash());
+ coursePackagePayment.setOrderNo(trade_no);
+
+ CourseCounsum courseCounsum = new CourseCounsum();
+ courseCounsum.setChangeType(3);
+ courseCounsum.setInsertTime(new Date());
+ courseCounsum.setReason("智慧球场;" + config.getCash());
+ courseCounsum.setAppUserId(Integer.valueOf(s[0]));
+ courseRecordClient.save(courseCounsum);
+ }
+ gameRecordService.updateBatchById(list);
+
+ PrintWriter out = response.getWriter();
+ out.write("success");
+ out.flush();
+ out.close();
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+
+ private static Integer startGame(Integer uid, Integer gameId, Integer spaceId, Integer sutuId) {
+ HashMap<String, String> map = new HashMap<>();
+ map.put("sign", "0DB011836143EEE2C2E072967C9F4E4B");
+ map.put("app_user_id", uid + "");
+ map.put("game_id", gameId + "");
+ map.put("space_id", spaceId + "");
+ map.put("sutu_id", sutuId + "");
+
+ String s = HttpRequestUtil.postRequest("https://port.daowepark.com/v7/user_api/general/gameStart", map);
+ JSONObject jsonObject = JSONObject.parseObject(s);
+ Object code = jsonObject.get("code");
+ if (String.valueOf(code) != null && "200".equals(String.valueOf(code))) {
+ System.err.println("启动了一次游戏");
+ return 200;
+ } else {
+ return 500;
}
}
@@ -367,81 +636,159 @@
@ApiImplicitParam(value = "页条数", name = "pageSize", dataType = "int", required = true),
@ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
})
- public ResultUtil<List<QueryMySiteVo>> queryMySite(Integer status, Integer pageNo, Integer pageSize){
+ public ResultUtil<List<QueryMySiteVo>> queryMySite(Integer status, Integer pageNo, Integer pageSize) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
List<QueryMySiteVo> queryMySiteVos = siteService.queryMySite(uid, status, pageNo, pageSize);
return ResultUtil.success(queryMySiteVos);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
+
@ResponseBody
@PostMapping("/api/site/queryMySiteById")
- @ApiOperation(value = "获取我的预约场地列表详情2.0", tags = {"用户—预约场地"})
+ @ApiOperation(value = "获取我的预约场地列表详情", tags = {"用户—预约场地"})
@ApiImplicitParams({
@ApiImplicitParam(value = "id", name = "id", dataType = "int", required = true),
@ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
})
- public ResultUtil<Map<String,Object>> queryMySiteById(Integer id){
+ public ResultUtil<Map<String, Object>> queryMySiteById(Integer id) {
try {
HashMap<String, Object> map = new HashMap<>();
- SiteBooking byId = siteBookingService.getById(id);
- Integer storeId = byId.getStoreId();
+ System.err.println("预约id"+id);
+ SiteBooking siteBooking = siteBookingService.getById(id);
+ Integer targetAudience = siteBooking.getTargetAudience();
+ System.err.println("预约"+siteBooking);
+ Integer storeId = siteBooking.getStoreId();
Store byId1 = service.getById(storeId);
- Site site = siteService.getById(byId.getSiteId());
-
- map.put("siteName",byId1.getName());
+ Site site = siteService.getById(siteBooking.getSiteId());
+ map.put("siteName", byId1.getName());
SiteType siteType = siteTypeService.getById(site.getSiteTypeId());
- map.put("siteType",siteType.getName());
- map.put("shopName",byId1.getName());
- map.put("shopAddress",byId1.getAddress());
+ System.err.println("预约类型"+siteType);
+ map.put("siteType", siteType.getName());
+ map.put("shopName", byId1.getName());
+ map.put("shopAddress", byId1.getAddress());
+ // 进场二维码新增参数codeType 1=订场 2=散客，3=门票,玩湃惠民卡codeType=4
+ map.put("codeType", targetAudience);
+ map.put("dataId", siteBooking.getId());
+// map.put("siteName", siteBooking.getNextName()==null?"":siteBooking.getNextName());
+// map.put("halfName", siteBooking.getHalfName()==null?"":siteBooking.getHalfName());
+ System.err.println("订场类型:"+targetAudience);
+
+ map.put("name", site.getName());
+ map.put("targetAudience", targetAudience);
- List<Integer> ids = getIds(byId.getSiteId());
- byId.setStorePhone(byId1.getPhone());
-
+ List<Integer> ids = getIds(siteBooking.getSiteId());
+ siteBooking.setStorePhone(byId1.getPhone());
+
//拼接开始结束时间
- Date startTime = byId.getStartTime();
- Date endTime = byId.getEndTime();
+ Date startTime = siteBooking.getStartTime();
+ Date endTime = siteBooking.getEndTime();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
-
String startTimeString = sdf.format(startTime);
String endTimeString = sdf.format(endTime);
-
String result = startTimeString + "-" + endTimeString.substring(11);
- byId.setTimes(result);
+ siteBooking.setTimes(result);
-
-
- byId.setSid(Arrays.asList(storeId));
- List<Site> list = siteService.list(new LambdaQueryWrapper<Site>().eq(Site::getStoreId, storeId).eq(Site::getSign, 1));
- List<Integer> collect = list.stream().map(Site::getId).collect(Collectors.toList());
- byId.setRid(collect);
- map.put("data",byId);
-
-
- map.put("ids",ids);
+ siteBooking.setSid(Arrays.asList(storeId));
+ Integer siteId = siteBooking.getSiteId();
+ ArrayList<Integer> list1 = new ArrayList<>();
+ list1.add(siteId);
+ siteBooking.setRid(list1);
+ SiteBookingVo siteBookingVo = new SiteBookingVo();
+ BeanUtils.copyProperties(siteBooking, siteBookingVo);
+ siteBookingVo.setStartTime(siteBooking.getStartTime().getTime());
+ siteBookingVo.setEndTime(siteBooking.getEndTime().getTime());
+ if (siteBooking.getPayTime()!=null){
+ siteBookingVo.setPayTime(siteBooking.getPayTime().getTime());
+ }
+ map.put("data", siteBookingVo);
+ map.put("ids", ids);
return ResultUtil.success(map);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
- public List<Integer> getIds(Integer siteId) {
- HttpRequest httpRequest = HttpRequest.get("https://try.daowepark.com/v7/user_api/general/get_space_area?space_id=" + siteId);
+ @ResponseBody
+ @GetMapping("/api/site/entryQr")
+ @ApiOperation(value = "获取订场进场二维码", tags = {"用户—预约场地"})
+ @ApiImplicitParams({
+ @ApiImplicitParam(value = "预约数据 id", name = "bookingId", dataType = "int", required = true),
+ @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header")
+ })
+ public ResultUtil<Map<String, Object>> entryQr(Integer bookingId) {
+ try {
+ Integer uid = tokenUtil.getUserIdFormRedis();
+ if (uid == null) return ResultUtil.tokenErr();
+ SiteBooking booking = siteBookingService.getById(bookingId);
+ if (booking == null || !uid.equals(booking.getAppUserId())) return ResultUtil.error("预约记录不存在");
+ if (SiteBookingStatusEnum.EXPIRED.getCode().equals(booking.getStatus())
+ || SiteBookingStatusEnum.CANCELED.getCode().equals(booking.getStatus())) {
+ return ResultUtil.error("当前预约不可使用二维码");
+ }
+ QrLink link = qrLinkMapper.selectOne(new QueryWrapper<QrLink>()
+ .eq("type", QrLinkTypeEnum.BOOKING_ENTRY.getCode())
+ .eq("bookingId", bookingId)
+ .eq("enabled", EnableStatusEnum.ENABLED.getCode())
+ .last("limit 1"));
+ if (link == null || (link.getExpiresAt() != null && link.getExpiresAt().before(new Date()))) {
+ link = createEntryQrLink(booking, bookingId);
+ }
+ Map<String, Object> data = new HashMap<>();
+ data.put("shortCode", link.getShortCode());
+ data.put("url", "https://online.daowepark.com/other/q/" + link.getShortCode());
+ data.put("expiresAt", link.getExpiresAt());
+ return ResultUtil.success(data);
+ } catch (Exception e) {
+ log.error("[SITE_ENTRY_QR] generate failed, bookingId={}", bookingId, e);
+ return ResultUtil.runErr();
+ }
+ }
+
+ /** 创建与预约记录绑定的进场二维码短链。 */
+ private QrLink createEntryQrLink(SiteBooking booking, Integer bookingId) {
+ QrLink link = new QrLink();
+ link.setType(QrLinkTypeEnum.BOOKING_ENTRY.getCode());
+ link.setBookingId(bookingId);
+ link.setStoreId(booking.getStoreId());
+ link.setSiteId(booking.getSiteId());
+ link.setEnabled(EnableStatusEnum.ENABLED.getCode());
+ link.setExpiresAt(booking.getEndTime());
+ link.setShortCode(nextEntryQrCode());
+ qrLinkMapper.insert(link);
+ return link;
+ }
+
+ /** 生成数据库中尚未使用的十位进场二维码短码。 */
+ private String nextEntryQrCode() {
+ String code;
+ do {
+ StringBuilder builder = new StringBuilder(10);
+ for (int index = 0; index < 10; index++) {
+ builder.append(ENTRY_CODE_CHARS[entryCodeRandom.nextInt(ENTRY_CODE_CHARS.length)]);
+ }
+ code = builder.toString();
+ } while (qrLinkMapper.selectCount(new QueryWrapper<QrLink>().eq("shortCode", code)) > 0);
+ return code;
+ }
+
+ public List<Integer> getIds(Integer siteId) {
+ HttpRequest httpRequest = HttpRequest.get("https://port.daowepark.com/v7/user_api/general/get_space_area?space_id=" + siteId);
HttpResponse execute = httpRequest.execute();
String body = execute.body();
JSONObject jsonObject = JSONObject.parseObject(body);
Object data = jsonObject.get("data");
JSONArray array = JSONArray.parseArray(data.toString());
- List<Integer> ids =new ArrayList<>();
+ List<Integer> ids = new ArrayList<>();
for (Object o : array) {
JSONObject jsonObject1 = JSONObject.parseObject(o.toString());
Object id = jsonObject1.get("id");
@@ -460,16 +807,15 @@
@ApiImplicitParam(value = "预约数据id", name = "id", dataType = "int", required = true),
@ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
})
- public ResultUtil cancelMySite(Integer id){
+ public ResultUtil cancelMySite(Integer id) {
try {
+ System.err.println("预约数据id");
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
-
-
return siteService.cancelMySite(uid, id);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
@@ -478,15 +824,16 @@
/**
* 微信退款回调
+ *
* @param request
* @param response
*/
@ResponseBody
@PostMapping("/base/site/cancelMySiteCallback")
- public void cancelMySiteCallback(HttpServletRequest request, HttpServletResponse response){
+ public void cancelMySiteCallback(HttpServletRequest request, HttpServletResponse response) {
try {
Map<String, String> map = payMoneyUtil.wxRefundCallback(request);
- if(null != map){
+ if (null != map) {
String code = map.get("out_refund_no");
String refund_id = map.get("refund_id");
String result = map.get("result");
@@ -496,8 +843,8 @@
siteBooking.setCancelTime(new Date());
siteBooking.setRefundOrderNo(refund_id);
siteBookingService.updateById(siteBooking);
- if(null != siteBooking.getUserCouponId()){
- UserCoupon userCoupon = userCouponClient.queryUserCouponById(new QueryUserCouponByIdAndUserId(siteBooking.getUserCouponId(),siteBooking.getAppUserId()));
+ if (null != siteBooking.getUserCouponId()) {
+ UserCoupon userCoupon = userCouponClient.queryUserCouponById(new QueryUserCouponByIdAndUserId(siteBooking.getUserCouponId(), siteBooking.getAppUserId()));
userCoupon.setStatus(1);
userCouponClient.updateUserCoupon(userCoupon);
}
@@ -506,12 +853,63 @@
out.flush();
out.close();
}
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
}
}
+ /**
+ * 微信退款回调V3服务商版本
+ *
+ * @param request
+ * @param response
+ */
+ @ResponseBody
+ @PostMapping("/base/site/cancelMySiteCallback1")
+ public void cancelMySiteCallback1(HttpServletRequest request, HttpServletResponse response) {
+ try {
+ System.err.println("微信回调");
+ System.err.println("请求" + request);
+ BufferedReader reader = request.getReader();
+ String string1 = reader.toString();
+ System.err.println("请求reader" + string1);
+ StringBuilder requestBody = new StringBuilder();
+ String line;
+ while ((line = reader.readLine()) != null) {
+ requestBody.append(line);
+ }
+ System.err.println("全部请求体" + requestBody);
+ JSONObject jsonObject = JSONObject.parseObject(requestBody.toString());
+ JSONObject resource = jsonObject.getJSONObject("resource");
-
+ AesUtil aesUtil = new AesUtil(WxV3PayConfig.apiV3Key.getBytes(StandardCharsets.UTF_8));
+ String decryptedData = aesUtil.decryptToString(resource.getString("associated_data").getBytes(StandardCharsets.UTF_8), resource.getString("nonce").getBytes(StandardCharsets.UTF_8),
+ resource.getString("ciphertext"));
+ System.err.println("微信解密的字符串信息" + decryptedData);
+ JSONObject jsonInfo = (JSONObject) JSONObject.parse(decryptedData);
+ String code = jsonInfo.getString("out_trade_no");
+ String transaction_id = jsonInfo.getString("transaction_id");
+ String refund_status = jsonInfo.getString("refund_status");
+ String out_refund_no = jsonInfo.getString("out_refund_no");
+ if (refund_status.equals("SUCCESS")) {
+ SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("orderNo", code).eq("state", 1));
+ siteBooking.setStatus(5);
+ siteBooking.setCancelTime(new Date());
+ siteBooking.setRefundOrderNo(out_refund_no);
+ siteBookingService.updateById(siteBooking);
+ if (null != siteBooking.getUserCouponId()) {
+ UserCoupon userCoupon = userCouponClient.queryUserCouponById(new QueryUserCouponByIdAndUserId(siteBooking.getUserCouponId(), siteBooking.getAppUserId()));
+ userCoupon.setStatus(1);
+ userCouponClient.updateUserCoupon(userCoupon);
+ }
+ PrintWriter out = response.getWriter();
+ out.write("SUCCESS");
+ out.flush();
+ out.close();
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
@ResponseBody
@PostMapping("/api/site/continuePaymentMySite")
@@ -521,19 +919,18 @@
@ApiImplicitParam(value = "支付方式（1=微信，2=支付宝，3=玩湃币）", name = "payType", dataType = "int", required = true),
@ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
})
- public ResultUtil continuePaymentMySite(Integer id, Integer payType){
+ public ResultUtil continuePaymentMySite(Integer id, Integer payType) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
return siteService.continuePaymentMySite(uid, id, payType);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
@ResponseBody
@@ -542,10 +939,10 @@
@ApiImplicitParams({
@ApiImplicitParam(value = "预约数据id", name = "id", dataType = "int", required = true),
})
- public ResultUtil<Map<String, Double>> queryContinuePaymentMySitePrice(Integer id){
+ public ResultUtil<Map<String, Double>> queryContinuePaymentMySitePrice(Integer id) {
try {
return siteService.queryContinuePaymentMySitePrice(id);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
@@ -553,15 +950,16 @@
/**
* 查询所有现金支付的预约记录
+ *
* @param requestVo
* @return
*/
@ResponseBody
@PostMapping("/base/site/queryPaymentSiteDetail")
- public RequestOfTypeVo getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo){
+ public RequestOfTypeVo getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo) {
RequestOfTypeVo typeVo = new RequestOfTypeVo();
List<BillingRequestOfType> billingRequestOfTypes = siteBookingService.queryDatas(requestVo.getAppUserId(), requestVo.getMonthStart(), requestVo.getMonthEnd());
- if (billingRequestOfTypes.size() > 0 ){
+ if (billingRequestOfTypes.size() > 0) {
typeVo.setRequest(billingRequestOfTypes);
}
return typeVo;
@@ -569,12 +967,13 @@
/**
* 查询所有玩湃币支付的预约记录
+ *
* @param appUserId
* @return
*/
@ResponseBody
@PostMapping("/base/site/queryPlaypaiGoldSiteDetail")
- public List<SiteBooking> wanpaiGoldSiteBookingList(@RequestBody Integer appUserId){
+ public List<SiteBooking> wanpaiGoldSiteBookingList(@RequestBody Integer appUserId) {
ArrayList<Integer> integers = new ArrayList<>();
integers.add(1);
integers.add(2);
@@ -582,37 +981,54 @@
integers.add(4);
integers.add(5);
return siteBookingService.list(new QueryWrapper<SiteBooking>()
- .in("status",integers)
- .eq("payType",3)
- .eq("appUserId",appUserId));
+ .in("status", integers)
+ .eq("payType", 3)
+ .eq("appUserId", appUserId));
}
@ResponseBody
@PostMapping("/base/site/queryByCode")
- public Integer queryByCode(@RequestBody String code){
+ public Integer queryByCode(@RequestBody String code) {
return siteBookingService.queryByCode(code);
}
@Autowired
- private StoreService service;
-
- @Autowired
- private IOperatorUserService operatorUserService;
-
+ private StoreService service;
@ResponseBody
@PostMapping("/base/site/game")
- public List<Map<String, Object>> game(@RequestBody Integer appUserId){
+ public List<Map<String, Object>> game(@RequestBody Integer appUserId) {
return service.game(appUserId);
+
+ }
+
+
+ @ResponseBody
+ @PostMapping("/base/site/counts")
+ public Integer counts(@RequestBody Integer stuId) {
+ return siteBookingService.count(new QueryWrapper<SiteBooking>().eq("appUserId", stuId));
+
+ }
+
+ @Autowired
+ private IUserService userService;
+
+
+ @ResponseBody
+ @PostMapping("/base/site/queryUserName")
+ public User queryUserName(@RequestBody Integer coachId){
+ User byId = userService.getById(coachId);
+
+ return byId;
}
@ResponseBody
@PostMapping("/base/site/queryOperator")
- public OperatorUser queryOperator(@RequestBody List<Integer> stores){
+ public OperatorUser queryOperator(@RequestBody List<Integer> stores) {
Store one = service.getOne(new QueryWrapper<Store>().in("id", stores));
OperatorUser o = operatorUserService.getById(one.getOperatorId());
@@ -621,23 +1037,45 @@
}
-
@ResponseBody
@PostMapping("/base/site/getNewAddSiteList")
- public List<SiteVo> getAppUserSiteList(@RequestBody Integer storeId){
+ public List<SiteVo> getAppUserSiteList(@RequestBody Integer storeId) {
List<SiteVo> siteVos = new ArrayList<>();
-
- List<Site> list = siteService.list(new QueryWrapper<Site>().eq("state",1).eq("storeId",storeId)
+ DayOfWeek dayOfWeek = LocalDate.now().getDayOfWeek();
+ Map<Integer, List<TSitePrice>> priceMap = sitePriceService.lambdaQuery().eq(TSitePrice::getDayOfWeek, dayOfWeek.getValue())
+ .list()
+ .stream().collect(Collectors.groupingBy(TSitePrice::getSiteId));
+ List<Site> list = siteService.list(new QueryWrapper<Site>().eq("state", 1).eq("storeId", storeId)
.orderByDesc("insertTime"));
- if (list.size() > 0 ){
+ String now = DateUtil.now().substring(11, 19);
+
+ if (list.size() > 0) {
for (Site site : list) {
+ List<TSitePrice> tSitePrices = priceMap.get(site.getId());
+
SiteVo vo = new SiteVo();
+ vo.setIsCanBeBooked(site.getIsCanBeBooked());
vo.setSiteId(site.getId());
vo.setSiteName(site.getName());
- vo.setSiteTime(site.getAppointmentStartTime() + "-" + site.getAppointmentEndTime());
+ vo.setSiteTime("");
+ vo.setPrice(0.0);
+ if (tSitePrices!=null&& !tSitePrices.isEmpty()){
+ BigDecimal bigDecimal = BigDecimal.ZERO;
+ // 遍历 查询最小的价格
+ for (TSitePrice tSitePrice : tSitePrices) {
+ // 当前时间再范围之内
+ if (tSitePrice.getStartTime().compareTo(now) <= 0 && tSitePrice.getEndTime().compareTo(now) >= 0) {
+ if (tSitePrice.getCashPrice().compareTo(bigDecimal) > 0) {
+ bigDecimal = tSitePrice.getCashPrice();
+ }
+ }
+ }
+ vo.setPrice(bigDecimal.doubleValue());
+ vo.setSiteTime(tSitePrices.get(0).getStartTime() + "-" + tSitePrices.get(tSitePrices.size()-1).getEndTime());
+ }
SiteType byId = siteTypeService.getById(site.getSiteTypeId());
vo.setSiteType(byId.getName());
- vo.setPrice(site.getCashPrice());
+
siteVos.add(vo);
}
}
@@ -645,4 +1083,5 @@
}
+
}
--
Gitblit v1.7.1