From f8b23a28a212c4946c97f94c0540ed12f89c4e07 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 16 五月 2024 08:55:02 +0800
Subject: [PATCH] zjh 2024/05/16-1

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java |  305 +++++++++++++++-----------------------------------
 1 files changed, 95 insertions(+), 210 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
index d8c96a4..26fafeb 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
@@ -9,6 +9,7 @@
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
 
+import cn.hutool.core.date.DateUnit;
 import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.io.FileUtil;
 import cn.hutool.extra.pinyin.PinyinUtil;
@@ -17,7 +18,9 @@
 import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.google.common.base.Joiner;
+import com.ltkj.common.annotation.RepeatSubmit;
 import com.ltkj.common.excelConfig.ExcelUtils;
+import com.ltkj.common.task.TaskService;
 import com.ltkj.common.utils.SecurityUtils;
 import com.ltkj.common.utils.StringUtils;
 import com.ltkj.framework.config.MatchUtils;
@@ -28,6 +31,7 @@
 import com.ltkj.mall.mallOrderUtils.TjConstants;
 import com.ltkj.web.config.pdfutils.PDFBinaryUtil;
 import com.ltkj.web.config.redis.OrderDelayService;
+import com.ltkj.web.config.task.TjReservationTask;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import io.swagger.annotations.ApiParam;
@@ -76,8 +80,10 @@
     private ITjGroupingProService groupingProService;
     @Resource
     private TjAsyncService asyncService;
-    @Resource
-    private OrderDelayService delayService;
+//    @Resource
+//    private OrderDelayService delayService;
+    @Autowired
+    private TaskService taskService;
     @Resource
     private ITjReportTemplateService reportTemplateService;
 
@@ -88,71 +94,54 @@
     @ApiOperation(value = "瀵煎嚭excel琛ㄦā鏉�")
     public void importTemplate(HttpServletResponse response) {
         //鍘熸潵鐨勪笅杞芥ā鏉胯皟鐢ㄦ帴鍙�
-//        ExcelUtils.exportTemplate(response, "浣撴棰勭害Excel妯℃澘", TjReservation.class);
         String base64String = PDFBinaryUtil.getPDFBinary("D:\\Tjreport\\瑗垮畨璺嘲鏈虹數绉戞妧鏈夐檺鍏徃.xls");
-//        TjReportTemplate tem = new TjReportTemplate();
-//        tem.setName("鍥綋棰勭害Excel妯$増");
-//        tem.setRemark("鍥綋棰勭害Excel妯$増");
-//        tem.setTemplate(base64String);
-//        tem.setFlag("1");
-//        tem.setOpen("0");
-//        reportTemplateService.save(tem);
+        if(null !=base64String){
+            PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + "\\" + "鍥綋棰勭害Excel妯$増.xls");
+            String filePath = value + "\\" + "鍥綋棰勭害Excel妯$増.xls";
+            File f = new File(filePath);
+            BufferedInputStream br = null;
+            OutputStream out = null;
+            FileInputStream fileInputStream = null;
+            try {
+                fileInputStream = new FileInputStream(f);
+                br = new BufferedInputStream(fileInputStream);
+                byte[] bs = new byte[1024];
+                int len = 0;
+                response.reset(); // 闈炲父閲嶈
+                if (true) {
+                    // 鍦ㄧ嚎鎵撳紑鏂瑰紡
+                    URL u = new URL("file:///" + filePath);
+                    //System.out.println(u);
+                    String contentType = u.openConnection().getContentType();
+                    response.setContentType(contentType);
+                    response.setHeader("Content-Disposition", "inline;filename=鍥綋棰勭害Excel妯$増.xls");
+                } else {
+                    // 绾笅杞芥柟寮�
+                    response.setContentType("application/x-msdownload");
+                    response.setContentType("application/pdf;charset=utf-8");
+                    response.setHeader("Content-Disposition", "attachment;filename=鍥綋棰勭害Excel妯$増.xls");
+                }
+                out = response.getOutputStream();
+                while ((len = br.read(bs)) > 0) {
+                    out.write(bs, 0, len);
+                }
+                out.flush();
+                out.close();
+                br.close();
+                fileInputStream.close();
+            } catch (IOException e) {
+                e.printStackTrace();
+                //System.out.println("pdf澶勭悊鏂囦欢寮傚父" + e);
+            } finally {
+                if (out != null) {
+                    try {
+                        out.close();
+                        br.close();
+                        fileInputStream.close();
 
-//        LambdaQueryWrapper<TjReportTemplate> wq = new LambdaQueryWrapper<>();
-//        wq.eq(TjReportTemplate::getFlag, 4);
-//        wq.eq(TjReportTemplate::getName, "");
-//        wq.eq(TjReportTemplate::getOpen, 0);
-//         reportTemplateService.getOne(wq);
-
-        PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + "\\" + "鍥綋棰勭害Excel妯$増.xls");
-        String filePath = value + "\\" + "鍥綋棰勭害Excel妯$増.xls";
-        File f = new File(filePath);
-        if (filePath.isEmpty()) {
-            System.out.println("鏂囦欢涓嶅瓨鍦紒");
-            return;
-        }
-        BufferedInputStream br = null;
-        OutputStream out = null;
-        FileInputStream fileInputStream = null;
-        try {
-            fileInputStream = new FileInputStream(f);
-            br = new BufferedInputStream(fileInputStream);
-            byte[] bs = new byte[1024];
-            int len = 0;
-            response.reset(); // 闈炲父閲嶈
-            if (true) {
-                // 鍦ㄧ嚎鎵撳紑鏂瑰紡
-                URL u = new URL("file:///" + filePath);
-                //System.out.println(u);
-                String contentType = u.openConnection().getContentType();
-                response.setContentType(contentType);
-                response.setHeader("Content-Disposition", "inline;filename=鍥綋棰勭害Excel妯$増.xls");
-            } else {
-                // 绾笅杞芥柟寮�
-                response.setContentType("application/x-msdownload");
-                response.setContentType("application/pdf;charset=utf-8");
-                response.setHeader("Content-Disposition", "attachment;filename=鍥綋棰勭害Excel妯$増.xls");
-            }
-            out = response.getOutputStream();
-            while ((len = br.read(bs)) > 0) {
-                out.write(bs, 0, len);
-            }
-            out.flush();
-            out.close();
-            br.close();
-            fileInputStream.close();
-        } catch (IOException e) {
-            e.printStackTrace();
-            //System.out.println("pdf澶勭悊鏂囦欢寮傚父" + e);
-        } finally {
-            if (out != null) {
-                try {
-                    out.close();
-                    br.close();
-                    fileInputStream.close();
-
-                } catch (IOException e) {
-                    e.printStackTrace();
+                    } catch (IOException e) {
+                        e.printStackTrace();
+                    }
                 }
             }
         }
@@ -214,42 +203,9 @@
     /**
      * 瀵煎叆鍥綋浣撴棰勭害鍒楄〃
      */
-    @PostMapping("/excelImport")
-    @ApiOperation(value = "鍥綋瀵煎叆 (鏃х増鏈�)")
-    public AjaxResult excelImport(@RequestPart(value = "file") @ApiParam(value = "Excel鏂囦欢") MultipartFile file) {
-        List<TjReservation> tjReservations = null;
-        try {
-            tjReservations = ExcelUtils.readMultipartFile(file, TjReservation.class);
-        } catch (Exception e) {
-            return AjaxResult.error("瀵煎叆鏂囦欢鏈夎璇锋鏌ュ鍏ユ枃浠�!");
-        }
-        List<String> wrongList = new ArrayList<>();
-        List<TjReservation> rightList = new ArrayList<>();
-        for (TjReservation tjReservation : tjReservations) {
-            String idCard = tjReservation.getIdCard();
-            String phoe = tjReservation.getPhoe();
-            if (null != idCard && null != phoe) {
-                if (!MatchUtils.isIdCard(idCard) || !MatchUtils.isMobileNO(phoe)) {
-                    wrongList.add(tjReservation.getName());
-                } else {
-                    rightList.add(tjReservation);
-                }
-            } else {
-                wrongList.add(tjReservation.getName());
-            }
-        }
-        if (wrongList.size() > 0) {
-            return AjaxResult.success("鎿嶄綔澶辫触", wrongList);
-        } else {
-            return AjaxResult.success("鎿嶄綔鎴愬姛",rightList);
-        }
-    }
-
-    /**
-     * 瀵煎叆鍥綋浣撴棰勭害鍒楄〃
-     */
     @PostMapping("/newExcelImport")
     @ApiOperation(value = "鍥綋瀵煎叆 (鏂扮増鏈�)")
+    @Transactional
     public AjaxResult newExcelImport(@RequestPart(value = "file") @ApiParam(value = "Excel鏂囦欢") MultipartFile file,
                                      @RequestParam @ApiParam(value = "鍗曚綅id") String dwId,
                                      @RequestParam @ApiParam(value = "鍗曚綅閮ㄩ棬id") String dwDeptId) {
@@ -259,6 +215,12 @@
         } catch (Exception e) {
             return AjaxResult.error("瀵煎叆鏂囦欢鏈夎璇锋鏌ュ鍏ユ枃浠�!");
         }
+        int grouping = dwGroupingService.selectTjDwGroupingByDwDeptId(dwDeptId);
+
+        if(grouping==0){
+            return AjaxResult.error("璇锋鏌ラ儴闂ㄤ腑鏄惁瀛樺湪鍒嗙粍鎴栧垎缁勪腑鏄惁瀛樺湪椤圭洰!");
+        }
+
         List<String> wrongList = new ArrayList<>();
         List<TjReservation> rightList = new ArrayList<>();
         List<TjReservation> yyList = new ArrayList<>();
@@ -357,102 +319,6 @@
     }
 
 
-    @PostMapping("/reservationConfirm")
-    @ApiOperation(value = "鍥綋棰勭害纭鎺ュ彛 (鏃х増鏈�)")
-    public AjaxResult reservationConfirm(@RequestBody Map<String, Object> map) {
-        List<TjReservation> rightLists = (List<TjReservation>) map.get("rightList");
-        String pacId = map.get("pacId").toString();
-        String copeWith = map.get("copeWith").toString();
-        String[] proIds = (String[]) map.get("proIds");
-        Object compId1 = map.get("compId");
-        if (null == compId1 || compId1.equals("")) {
-            return AjaxResult.error("璇烽�夋嫨鍗曚綅淇℃伅");
-        }
-        String compId = map.get("compId").toString();
-        Object reservationTime1 = map.get("reservationTime");
-        if (null == reservationTime1) {
-            return AjaxResult.error("璇烽�夋嫨棰勭害鏃堕棿!");
-        }
-        String reservationTime = map.get("reservationTime").toString();
-        String payType = map.get("payType").toString();
-        String jsonString = JSON.toJSONString(rightLists);
-        List<TjReservation> rightList = JSON.parseArray(jsonString, TjReservation.class);
-
-        if (null != rightList) {
-            if (null != pacId || null != proIds && proIds.length > 0) {
-                String teamNo = PinyinUtil.getFirstLetter(compService.getById(compId).getCnName(), "") + DateUtil.format(new Date(), "yyMMddHHmmss");
-                for (TjReservation reservation : rightList) {
-                    LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
-                    wq.eq(TjReservation::getIdCard, reservation.getIdCard());
-                    wq.eq(TjReservation::getIsExpire, 2);
-                    TjReservation one = tjReservationService.getOne(wq);
-                    if (null != one) {
-                        continue;
-                    }
-                    if (null != pacId) {
-                        reservation.setPacId(pacId);
-                    }
-                    if (null != proIds && proIds.length > 0) {
-                        reservation.setProIds(Joiner.on(",").join(proIds));
-                    }
-                    reservation.setReservationTime(DateUtil.parse(reservationTime, "yyyy-MM-dd"));
-                    reservation.setCompanyId(compId);
-                    reservation.setCompany(compService.getById(compId).getCnName());
-                    reservation.setPayType(Long.valueOf(payType));
-                    reservation.setTjType(String.valueOf(1));
-                    reservation.setTeamNo(teamNo);
-                    tjReservationService.save(reservation);
-                    delayService.reservation(reservation.getId());
-                }
-                LambdaQueryWrapper<TjCompPay> wq0 = new LambdaQueryWrapper<>();
-                wq0.eq(TjCompPay::getCompId, compId);
-                wq0.eq(TjCompPay::getTeamNo, teamNo);
-                TjCompPay one = compPayService.getOne(wq0);
-                if (null != one) {
-                    one.setCopeWith(new BigDecimal(copeWith));
-                    one.setSerialNumber(SecurityUtils.getUsername() + DateUtil.format(new Date(), "yyMMddHHmmssSSS"));
-                    one.setInvoiceNo("FP" + DateUtil.format(new Date(), "yyMMddHHmmssSSS"));
-                    one.setPaidIn(new BigDecimal("0.00"));
-                    compPayService.updateById(one);
-                } else {
-                    TjCompPay tjCompPay = new TjCompPay();
-                    tjCompPay.setCompId(compId);
-                    tjCompPay.setTeamNo(teamNo);
-                    tjCompPay.setCopeWith(new BigDecimal(copeWith));
-                    tjCompPay.setSerialNumber(SecurityUtils.getUsername() + DateUtil.format(new Date(), "yyMMddHHmmssSSS"));
-                    tjCompPay.setInvoiceNo("FP" + DateUtil.format(new Date(), "yyMMddHHmmssSSS"));
-                    tjCompPay.setPaidIn(new BigDecimal("0.00"));
-                    tjCompPay.setDifference(tjCompPay.getCopeWith().subtract(BigDecimal.valueOf(0.00)));
-                    compPayService.save(tjCompPay);
-                }
-                LambdaQueryWrapper<TjTeamSelectRecord> wq = new LambdaQueryWrapper<>();
-                wq.eq(TjTeamSelectRecord::getTeamNo, teamNo);
-                wq.eq(TjTeamSelectRecord::getCompId, compId);
-                TjTeamSelectRecord recordServiceOne = selectRecordService.getOne(wq);
-                if (null != recordServiceOne) {
-                    if (null != pacId) recordServiceOne.setPacId(pacId);
-                    recordServiceOne.setProIds(Joiner.on(";").join(proIds != null ? proIds : new String[0]));
-                    recordServiceOne.setTeamNo(teamNo);
-                    recordServiceOne.setTransactionAmount(new BigDecimal("0.00"));
-                    recordServiceOne.setCount(rightList.size());
-                    selectRecordService.updateById(recordServiceOne);
-                }
-                TjTeamSelectRecord selectRecord = new TjTeamSelectRecord();
-                selectRecord.setCompId(compId);
-                if (null != pacId) selectRecord.setPacId(pacId);
-                selectRecord.setProIds(Joiner.on(";").join(proIds != null ? proIds : new String[0]));
-                selectRecord.setTeamNo(teamNo);
-                selectRecord.setTransactionAmount(new BigDecimal("0.00"));
-                selectRecord.setCount(rightList.size());
-                selectRecordService.save(selectRecord);
-                return AjaxResult.success("棰勭害鎴愬姛");
-            }
-            return AjaxResult.error("璇烽�夋嫨浣撴鍐呭");
-        }
-        return AjaxResult.error("璇烽�夋嫨棰勭害瀵硅薄");
-    }
-
-
     /**
      * 涓汉棰勭害鎺ュ彛
      */
@@ -489,7 +355,9 @@
         tjReservation.setIsExpire(2);
         tjReservation.setTjType(String.valueOf(2));
         if (tjReservationService.save(tjReservation)) {
-            delayService.reservation(tjReservation.getId());
+//            delayService.reservation(tjReservation.getId());
+            taskService.addTask(new TjReservationTask(tjReservation.getId(),
+                    DateUtil.between(new Date(),DateUtil.endOfDay(tjReservation.getReservationTime()), DateUnit.MS)));
             return AjaxResult.success("棰勭害鎴愬姛!!!");
         }
         LambdaQueryWrapper<TbTransition> remove=new LambdaQueryWrapper<>();
@@ -509,7 +377,16 @@
         TjReservation tjReservation = tjReservationService.selectTjReservationById(id);
         if (null != tjReservation) {
             if (null != tjReservation.getPacId()) {
-                tjReservation.setPacName(packageService.getById(tjReservation.getPacId()).getPacName());
+                TjPackage aPackage = packageService.getById(tjReservation.getPacId());
+                if(null !=aPackage){
+                    tjReservation.setPacName(aPackage.getPacName());
+                }
+                TjDwDept dwDept = dwDeptService.getById(tjReservation.getPacId());
+
+                if(null !=dwDept){
+                    tjReservation.setPacName(dwDept.getDwName());
+                }
+
             }
             if (null != tjReservation.getProIds()) {
                 List<String> proNames = new ArrayList<>();
@@ -537,6 +414,7 @@
         if (null != reservation && reservation.getIsExpire() == 2) {
             if (tjReservationService.removeById(id)) {
                 transitionService.remove(new LambdaQueryWrapper<TbTransition>().eq(TbTransition::getCusId, reservation.getIdCard()));
+                taskService.removeTask(new TjReservationTask(id));
                 return AjaxResult.success("鎾ら攢鎴愬姛");
             }
             return AjaxResult.error("鎾ら攢澶辫触");
@@ -557,6 +435,7 @@
                 if (null != reservation && reservation.getIsExpire() == 2) {
                     if (tjReservationService.removeById(id)) {
                         transitionService.remove(new LambdaQueryWrapper<TbTransition>().eq(TbTransition::getCusId, reservation.getIdCard()));
+                        taskService.removeTask(new TjReservationTask(id));
                     }
                 }
             }
@@ -581,6 +460,9 @@
         tjReservation.setPhoe(reservation.getPhoe());
         tjReservation.setName(reservation.getName());
         if (tjReservationService.updateById(tjReservation)) {
+            taskService.removeTask(new TjReservationTask(tjReservation.getId()));
+            taskService.addTask(new TjReservationTask(tjReservation.getId(),
+                    DateUtil.between(new Date(),DateUtil.endOfDay(tjReservation.getReservationTime()), DateUnit.MS)));
             return AjaxResult.success("鎿嶄綔鎴愬姛");
         }
         return AjaxResult.error("鎿嶄綔澶辫触");
@@ -600,7 +482,7 @@
             for (TjGroupingPro groupingPro : proList) {
                 TjProject project = projectService.getById(groupingPro.getProId());
                 if(null !=project){
-                    if (project.getProType().equals("") || project.getProType()==null) {
+                    if (project.getProType()==null || project.getProType().equals("")) {
                         groupingPro.setProType("2");
                     }else {
                         groupingPro.setProType(project.getProType());
@@ -616,11 +498,10 @@
     @PostMapping("/newReservationConfirm")
     @ApiOperation(value = "鍥綋棰勭害纭鎺ュ彛 (鏂扮増鏈�)")
     @Transactional
+    @RepeatSubmit
     public AjaxResult newReservationConfirm(@RequestBody ConfirmDto dto) {
         //棰勭害鐨勬墍鏈変汉
         List<TjReservation> rightList = dto.getReservations();
-
-
 
         //棰勭害鏃堕棿
         String reservationTime = dto.getReservationTime();
@@ -658,19 +539,23 @@
                 reservation.setProIds(Joiner.on(",").join(proIds));
                 reservation.setReservationTime(DateUtil.parse(reservationTime, "yyyy-MM-dd"));
                 reservation.setCompanyId(dwGrouping.getDwId());
-                reservation.setCompany(dwGrouping.getDwName());
+                reservation.setCompany(dwGrouping.getDwDeptName());
                 reservation.setPayType(Long.valueOf(dwGrouping.getPayType()));
                 reservation.setPacId(dwDept.getId());
-                if(dwGrouping.getPayType().equals("1")){
-                    compPay=compPay.add(dwGrouping.getYsPrice());
-                    tramNum+=1;
-                    reservation.setTjType(String.valueOf(1));
-                    reservation.setTeamNo(teamNo);
-                }else {
-                    reservation.setTjType(String.valueOf(2));
-                }
+//                if(dwGrouping.getPayType().equals("1")){
+//                    compPay=compPay.add(dwGrouping.getYsPrice());
+//                    tramNum+=1;
+//                    reservation.setTjType(String.valueOf(1));
+//                    reservation.setTeamNo(teamNo);
+//                }else {
+//                    reservation.setTjType(String.valueOf(2));
+//                }
+                compPay=compPay.add(dwGrouping.getYsPrice());
+                tramNum+=1;
+                reservation.setTjType(String.valueOf(1));
+                reservation.setTeamNo(teamNo);
                 tjReservationService.save(reservation);
-                delayService.reservation(reservation.getId());
+                taskService.addTask(new TjReservationTask(reservation.getId(),DateUtil.between(new Date(),DateUtil.endOfDay(reservation.getReservationTime()), DateUnit.MS)));
             }
             LambdaQueryWrapper<TjCompPay> wq0 = new LambdaQueryWrapper<>();
             wq0.eq(TjCompPay::getCompId, dwDept.getDwId());

--
Gitblit v1.8.0