From ae9bfd2d66f68a553786ac78b12f4390e65e4e09 Mon Sep 17 00:00:00 2001
From: 44323 <443237572@qq.com>
Date: 星期五, 24 十一月 2023 18:30:18 +0800
Subject: [PATCH] 后台bug修改

---
 cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java |  303 +++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 272 insertions(+), 31 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 d701c3b..6e8911b 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,13 +1,13 @@
 package com.dsh.other.controller;
 
+import cn.hutool.http.HttpRequest;
+import cn.hutool.http.HttpResponse;
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.dsh.other.entity.Site;
-import com.dsh.other.entity.SiteBooking;
-import com.dsh.other.entity.SiteType;
-import com.dsh.other.entity.TSite;
+import com.dsh.other.entity.*;
 import com.dsh.other.feignclient.account.CityManagerClient;
-import com.dsh.other.feignclient.account.model.CityManager;
 import com.dsh.other.feignclient.activity.UserCouponClient;
 import com.dsh.other.feignclient.activity.model.QueryUserCouponByIdAndUserId;
 import com.dsh.other.feignclient.activity.model.UserCoupon;
@@ -16,30 +16,25 @@
 import com.dsh.other.feignclient.model.SiteVo;
 import com.dsh.other.model.*;
 import com.dsh.other.model.dto.siteDto.TSiteDTO;
-import com.dsh.other.model.vo.questionVo.QuestionChangeStateVO;
 import com.dsh.other.model.vo.siteVo.ExpireSiteSearchVO;
 import com.dsh.other.model.vo.siteVo.SiteSearchVO;
-import com.dsh.other.service.ISiteBookingService;
-import com.dsh.other.service.ISiteService;
-import com.dsh.other.service.ISiteTypeService;
-import com.dsh.other.util.PayMoneyUtil;
-import com.dsh.other.util.ResultUtil;
-import com.dsh.other.util.TokenUtil;
+import com.dsh.other.service.*;
+import com.dsh.other.util.*;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
 import io.swagger.annotations.ApiOperation;
-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.*;
+import redis.clients.jedis.Jedis;
 
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 import java.io.PrintWriter;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * @author zhibing.pu
@@ -69,16 +64,28 @@
     @Autowired
     private CityManagerClient cityManagerClient;
 
-
+    /**
+     * 获取所有场地
+     */
+    @RequestMapping("/base/site/getList")
+    @ResponseBody
+    public List<Site> getList(){
+        return siteService.list(new QueryWrapper<Site>().ne("state",3));
+    }
+    /**
+     * 获取场地预约记录
+     */
+    @RequestMapping("/base/site/listAll")
+    public List<SiteBooking> listAll(@RequestBody SiteBookingQuery query){
+        return siteBookingService.listAll(query);
+    }
     /**
      * 获取所有场地
      * @return
      */
     @RequestMapping("/base/site/list")
     public List<TSiteDTO> listAll(@RequestBody SiteSearchVO vo){
-
         return siteTypeService.listAll(vo);
-
     }
     /**
      * 获取场地有效期在两个月内的场地列表
@@ -104,15 +111,43 @@
      * @return
      */
     @RequestMapping("/base/site/addSite")
-    public Object addSite(@RequestBody Site site){
+    public Integer addSite(@RequestBody Site site){
         if(site.getId()!= null ){
-
-            return siteService.updateById(site);
+            siteService.updateById(site);
+            return site.getId();
         }else {
-            return siteService.save(site);
+            boolean save = siteService.save(site);
+            return site.getId();
         }
     }
 
+
+    /**
+     * 添加场地管理
+     * @return
+     */
+    @RequestMapping("/base/site/addSiteBooking")
+    public Object addSiteBooking(@RequestBody SiteBooking siteBooking){
+        if(siteBooking.getId()!= null ){
+
+            return siteBookingService.updateById(siteBooking);
+        }else {
+            return siteBookingService.save(siteBooking);
+        }
+    }
+
+    @RequestMapping("/base/site/listById")
+    public Site listById(@RequestParam("id") Integer id){
+        Site byId = siteService.getById(id);
+        return byId;
+    }
+
+
+    @RequestMapping("/base/site/listBooks")
+    public  List<SiteBooking> listBooks(@RequestParam("id") Integer id){
+        List<SiteBooking> siteId = siteBookingService.list(new QueryWrapper<SiteBooking>().eq("siteId", id));
+        return siteId;
+    }
     @ResponseBody
     @PostMapping("/base/site/querySiteType")
     @ApiOperation(value = "获取场地类型", tags = {"用户—预约场地"})
@@ -146,7 +181,6 @@
 
 
 
-
     @ResponseBody
     @PostMapping("/base/site/querySiteInfo")
     @ApiOperation(value = "获取场地详情", tags = {"用户—预约场地"})
@@ -165,7 +199,8 @@
         }
     }
 
-
+    @Autowired
+    private RedisUtil redisUtil;
 
     @ResponseBody
     @PostMapping("/base/site/querySiteTimes")
@@ -173,16 +208,34 @@
     @ApiImplicitParams({
             @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)
     })
-    public ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day){
+    public  ResultUtil<List<QuerySiteTimes>> querySiteTimes(Integer id, String day,String halfName,String siteName){
         try {
-            List<QuerySiteTimes> list = siteService.querySiteTimes(id, day);
+            List<QuerySiteTimes> list = siteService.querySiteTimes(id, day,halfName,siteName);
             return ResultUtil.success(list);
         }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("系统繁忙,请稍后再试!");
+//        }
+//
+//    }
+
 
 
     /**
@@ -222,6 +275,22 @@
         }
     }
 
+//        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
@@ -255,7 +324,7 @@
 
 
     /**
-     * 购买课程支付宝回调
+     * 预约场地支付宝回调
      * @param request
      * @param response
      */
@@ -263,6 +332,7 @@
     @PostMapping("/base/site/aliPaymentSiteCallback")
     public void aliPaymentSiteCallback(HttpServletRequest request, HttpServletResponse response){
         try {
+            System.out.println("回调回调回调");
             Map<String, String> map = payMoneyUtil.alipayCallback(request);
             if(null != map){
                 String code = map.get("out_trade_no");
@@ -285,6 +355,60 @@
     }
 
 
+    /**
+     * 启动游戏支付宝回调
+     * @param request
+     * @param response
+     */
+    @ResponseBody
+    @PostMapping("/base/site/gameCallback")
+    public void gameCallback(HttpServletRequest request, HttpServletResponse response){
+        try {
+            System.out.println("回调回调回调");
+            Map<String, String> map = payMoneyUtil.alipayCallback(request);
+            if(null != map){
+
+                String code = map.get("passback_params");
+//                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.setPayTime(new Date());
+//                    siteBooking.setStatus(1);
+//                    siteBooking.setPayOrderNo(trade_no);
+//                    siteBookingService.updateById(siteBooking);
+//                }
+
+                String[] s = code.split("_");
+                Integer i = startGame(Integer.valueOf(s[0]), Integer.valueOf(s[1]), Integer.valueOf(s[2]), Integer.valueOf(s[3]));
+                System.err.println("===========游戏回调游戏回调========="+i);
+                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://try.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))){
+            return 200;
+        }else {
+            return 500;
+        }
+    }
 
 
     @ResponseBody
@@ -309,6 +433,79 @@
             return ResultUtil.runErr();
         }
     }
+    @ResponseBody
+    @PostMapping("/api/site/queryMySiteById")
+    @ApiOperation(value = "获取我的预约场地列表详情2.0", 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){
+        try {
+            HashMap<String, Object> map = new HashMap<>();
+            SiteBooking byId = siteBookingService.getById(id);
+            Integer storeId = byId.getStoreId();
+            Store byId1 = service.getById(storeId);
+            Site site = siteService.getById(byId.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());
+
+            map.put("name",site.getName());
+
+
+
+            List<Integer> ids = getIds(byId.getSiteId());
+            byId.setStorePhone(byId1.getPhone());
+            
+            //拼接开始结束时间
+            Date startTime = byId.getStartTime();
+            Date endTime = byId.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);
+
+
+
+
+            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);
+            return ResultUtil.success(map);
+        }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);
+        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<>();
+        for (Object o : array) {
+            JSONObject jsonObject1 = JSONObject.parseObject(o.toString());
+            Object id = jsonObject1.get("id");
+            Integer integer = Integer.valueOf(id.toString());
+            ids.add(integer);
+        }
+        return ids;
+
+    }
 
 
     @ResponseBody
@@ -324,6 +521,8 @@
             if(null == uid){
                 return ResultUtil.tokenErr();
             }
+
+
             return siteService.cancelMySite(uid, id);
         }catch (Exception e){
             e.printStackTrace();
@@ -445,11 +644,53 @@
 
 
     @ResponseBody
+    @PostMapping("/base/site/queryByCode")
+    public Integer queryByCode(@RequestBody String code){
+
+        return siteBookingService.queryByCode(code);
+    }
+
+
+    @Autowired
+   private StoreService service;
+
+    @Autowired
+    private IOperatorUserService operatorUserService;
+
+
+    @ResponseBody
+    @PostMapping("/base/site/game")
+    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));
+
+    }
+
+    @ResponseBody
+    @PostMapping("/base/site/queryOperator")
+    public OperatorUser queryOperator(@RequestBody List<Integer> stores){
+
+        Store one = service.getOne(new QueryWrapper<Store>().in("id", stores));
+        OperatorUser o = operatorUserService.getById(one.getOperatorId());
+
+        return o;
+    }
+
+
+
+    @ResponseBody
     @PostMapping("/base/site/getNewAddSiteList")
-    public List<SiteVo> getAppUserSiteList(){
+    public List<SiteVo> getAppUserSiteList(@RequestBody Integer storeId){
         List<SiteVo> siteVos = new ArrayList<>();
 
-        List<Site> list = siteService.list(new QueryWrapper<Site>()
+        List<Site> list = siteService.list(new QueryWrapper<Site>().eq("state",1).eq("storeId",storeId)
                 .orderByDesc("insertTime"));
         if (list.size() > 0 ){
             for (Site site : list) {

--
Gitblit v1.7.1