From 92b286e238439c61b230a07f42b92c2328588d49 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期三, 22 十一月 2023 11:19:16 +0800
Subject: [PATCH] #全局短信验证:目前  规划单、核价、报价已添加

---
 src/main/java/com/zy/crm/manager/controller/PlanController.java |  974 ++++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 920 insertions(+), 54 deletions(-)

diff --git a/src/main/java/com/zy/crm/manager/controller/PlanController.java b/src/main/java/com/zy/crm/manager/controller/PlanController.java
index 39ff7bb..3865da3 100644
--- a/src/main/java/com/zy/crm/manager/controller/PlanController.java
+++ b/src/main/java/com/zy/crm/manager/controller/PlanController.java
@@ -1,22 +1,39 @@
 package com.zy.crm.manager.controller;
 
-import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.baomidou.mybatisplus.mapper.Wrapper;
 import com.baomidou.mybatisplus.plugins.Page;
-import com.core.common.DateUtils;
-import com.zy.crm.manager.entity.Plan;
-import com.zy.crm.manager.service.PlanService;
 import com.core.annotations.ManagerAuth;
-import com.core.common.BaseRes;
-import com.core.common.Cools;
-import com.core.common.R;
+import com.core.common.*;
 import com.core.domain.KeyValueVo;
+import com.core.exception.CoolException;
+import com.zy.crm.common.entity.PhoneCodeTypeParam;
+import com.zy.crm.common.model.SettleDto;
+import com.zy.crm.common.service.OssService;
+import com.zy.crm.common.utils.FileSaveExampleUtil;
 import com.zy.crm.common.web.BaseController;
+import com.zy.crm.manager.controller.result.FollowerTableVo;
+import com.zy.crm.manager.entity.*;
+import com.zy.crm.manager.service.*;
+import com.zy.crm.system.entity.User;
+import com.zy.crm.system.service.DeptService;
+import com.zy.crm.system.service.UserService;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.ss.usermodel.DataFormatter;
+import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
 
+import javax.servlet.http.HttpServletResponse;
+import javax.xml.crypto.Data;
+import java.io.IOException;
+import java.io.InputStream;
 import java.util.*;
 
 @RestController
@@ -24,77 +41,744 @@
 
     @Autowired
     private PlanService planService;
+    @Autowired
+    private PlanTypeService planTypeService;
+    @Autowired
+    private DeptService deptService;
+    @Autowired
+    private OssService ossService;
+    @Autowired
+    private PriOnline2Service priOnline2Service;
+    @Autowired
+    private OrderService orderService;
+    @Autowired
+    private SmsCodeService smsCodeService;
+    @Autowired
+    private ProcessPermissionsService processPermissionsService;
 
-    @RequestMapping(value = "/plan/{id}/auth")
+    String PZH=" 鈥斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�� ";
+    Integer PBN = 6;
+
+
+    @GetMapping(value = "/plan/{id}/auth")
     @ManagerAuth
     public R get(@PathVariable("id") String id) {
-        return R.ok(planService.selectById(String.valueOf(id)));
-    }
-
-    @RequestMapping(value = "/plan/list/auth")
-    @ManagerAuth
-    public R list(@RequestParam(defaultValue = "1")Integer curr,
-                  @RequestParam(defaultValue = "10")Integer limit,
-                  @RequestParam(required = false)String orderByField,
-                  @RequestParam(required = false)String orderByType,
-                  @RequestParam(required = false)String condition,
-                  @RequestParam Map<String, Object> param){
-        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
-        excludeTrash(param);
-        convert(param, wrapper);
-        allLike(Plan.class, param.keySet(), wrapper, condition);
-        if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
-        return R.ok(planService.selectPage(new Page<>(curr, limit), wrapper));
-    }
-
-    private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){
-        for (Map.Entry<String, Object> entry : map.entrySet()){
-            String val = String.valueOf(entry.getValue());
-            if (val.contains(RANGE_TIME_LINK)){
-                String[] dates = val.split(RANGE_TIME_LINK);
-                wrapper.ge(entry.getKey(), DateUtils.convert(dates[0]));
-                wrapper.le(entry.getKey(), DateUtils.convert(dates[1]));
-            } else {
-                wrapper.like(entry.getKey(), val);
-            }
+        Plan plan = planService.selectById(String.valueOf(id));
+        assert plan != null;
+        JSONObject resultObj = JSON.parseObject(JSON.toJSONString(plan));
+        if (!Cools.isEmpty(plan.getForm())) {
+            JSONObject formObj = JSON.parseObject(plan.getForm());
+            formObj.forEach(resultObj::putIfAbsent);
         }
+        PlanType planType = planTypeService.selectById(plan.getPlanType());
+        if (planType == null) {
+            return R.error("褰撳墠瑙勫垝鍗曠被鍨嬪凡琚鐢�");
+        }
+        resultObj.put("formHtml", planType.getHtml());
+        // 姝ラ鏉$浉鍏�
+        resultObj.put("step", plan.getSettle() == 4 ? 0 : plan.getSettle() + 1);
+
+        return R.ok().add(resultObj);
+    }
+
+    @RequestMapping(value = "/plan/page/auth")
+    @ManagerAuth
+    public R page(@RequestParam(defaultValue = "1") Integer curr,
+                  @RequestParam(defaultValue = "10") Integer limit,
+                  @RequestParam(required = false) String condition,
+                  @RequestParam(required = false, value = "dept_id") Long deptId,
+                  @RequestParam(required = false, value = "user_id") Long userId) {
+        Long director = null;
+        if (deptId==null && userId == null){
+            if (getRole().getId()==3){
+                userId = getUserId();
+            }else if (getRole().getId()==2){
+                deptId = getDeptId();
+                userId = null;
+            }
+            director = getUserId();
+        }
+
+        return R.ok(planService.getPage(new Page<>(curr, limit)
+                , getHostId()
+                , deptId == null ? null : String.valueOf(deptId)
+                , userId
+                , director
+                , condition)
+        );
+    }
+
+    private final List<String> fields = new ArrayList<>();
+
+    {
+        Arrays.asList(Cools.getAllFields(Plan.class)).forEach(item -> {
+            fields.add(item.getName());
+        });
+    }
+
+    @RequestMapping(value = "/plan/assistantPlan/view/auth")
+    @ManagerAuth(memo = "鏌ョ湅鍓鍒掔敵璇峰崟")
+    @Transactional
+    public R assistantPlanView(@RequestParam Long hostPlanId) {
+        Plan plan = planService.selectById(hostPlanId);
+        if (plan.getAssistantHostSign()==1){
+            EntityWrapper<Plan> wrapper = new EntityWrapper<>();
+            wrapper.eq("id",plan.getHostPlanId());
+            Page<Plan> planPage = planService.selectPage(new Page<>(1, 1), wrapper);
+            return R.ok(planPage);
+        }
+        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
+        wrapper.eq("id",plan.getAssistantPlanId());
+        Page<Plan> planPage = planService.selectPage(new Page<>(1, 1), wrapper);
+        return R.ok(planPage);
     }
 
     @RequestMapping(value = "/plan/add/auth")
-    @ManagerAuth
-    public R add(Plan plan) {
-        planService.insert(plan);
+    @ManagerAuth(memo = "娣诲姞瑙勫垝鐢宠鍗�")
+    @Transactional
+    public R add(@RequestParam Map<String, Object> param) {
+        // pre
+        Plan plan = JSON.parseObject(JSON.toJSONString(param), Plan.class);
+        Iterator<Map.Entry<String, Object>> iterator = param.entrySet().iterator();
+        while (iterator.hasNext()) {
+            Map.Entry<String, Object> next = iterator.next();
+            if (this.fields.contains(next.getKey())) {
+                iterator.remove();
+            }
+        }
+        // begin
+        Long hostId = getHostId();
+        if (planService.selectByUuid(hostId, plan.getUuid()) != null) {
+            throw new CoolException("瑙勫垝鍗曞凡瀛樺湪");
+        }
+
+        Order order = orderService.selectById(plan.getOrderId());
+        if (Cools.isEmpty(order)) {
+            throw new CoolException("璺熻釜椤圭洰涓嶅瓨鍦�");
+        }
+
+        if (!order.getDirector().equals(getUserId())){
+            throw new CoolException("鍙厑璁歌窡韪」鐩礋璐d汉娣诲姞鎵�閫夐」鐩鍒掔敵璇峰崟");
+        }
+
+        Date now = new Date();
+        plan.setHostId(hostId);
+        plan.setUuid(planService.getUuid(hostId));  // 瑙勫垝鍗曚唬鍙�
+        plan.setDeptId(getDeptId());               // 鎵�灞為儴闂�
+        plan.setUserId(getUserId());               // 鎵�灞炰汉鍛�
+
+        plan.setAppleTime(now);
+        plan.setCreateBy(getUserId());
+        plan.setCreateTime(now);
+        plan.setUpdateBy(getUserId());
+        plan.setUpdateTime(now);
+        plan.setStatus(0);
+        plan.setStep(1);
+
+        plan.setForm(JSON.toJSONString(param));     // 鑷畾涔夎〃鍗曞唴瀹�
+        plan.setSettle(1);  // 1.寮�濮�
+        User manager = new User();
+        try{
+            manager = userService.getDeptManager(getHostId(), getUser().getDeptId());        // 鑾峰彇閮ㄩ棬棰嗗
+        }catch (Exception e){
+            manager = getUser();
+        }
+        PlanType planType = planTypeService.selectById(plan.getPlanType());
+        if (planType.getType().equals(2)) {
+            plan.setStatus2(0);
+        }else {
+            plan.setStatus2(10);
+        }
+        User planLeader = planTypeService.findPlanLeader(planType);
+        plan.setSettleMsg(JSON.toJSONString(SettleDto.init(plan, manager, planLeader)));
+
+        plan.setDirector(planLeader.getId());
+
+        if (!planService.insert(plan)) {
+            throw new CoolException("淇濇寔澶辫触锛岃閲嶈瘯");
+        }
+
+        // 鑷姩娣诲姞璺熻繘浜�
+        PlanFoll planFoll = new PlanFoll();
+        planFoll.setPlanId(plan.getId());
+        planFoll.setUserId(planLeader.getId());
+        if (!planFollService.insert(planFoll)) {
+            throw new CoolException("淇濇寔澶辫触锛岃閲嶈瘯");
+        }
+
+        if (!smsCodeService.sendSmsCodeText(planLeader.getMobile(), PhoneCodeTypeParam.ALIYUN_M1ABAC630E)) {
+            return R.ok("鍒涘缓鎴愬姛浣嗙煭淇″彂閫佸け璐�!");
+        }
+
         return R.ok();
     }
 
+    @RequestMapping(value = "/plan/assistantPlan/add/auth")
+    @ManagerAuth(memo = "娣诲姞鍓鍒掔敵璇峰崟")
+    @Transactional
+    public R assistantPlanAdd(@RequestParam Long hostPlanId) {
+        Plan hostPlan = planService.selectById(hostPlanId);
+        if (hostPlan.getAssistantHostSign()!=0){
+            return R.error("姝よ鍒掑崟涓嶉渶瑕佸垱寤哄壇娴佺▼");
+        }
+        PlanType planType2 = planTypeService.selectById(hostPlan.getPlanType());
+        if (planType2.getType()!=2){
+            return R.error("姝よ鍒掑崟涓嶉渶瑕佸垱寤哄壇娴佺▼");
+        }
+        if (!Cools.isEmpty(hostPlan.getAssistantPlanId()) && hostPlan.getAssistantPlanId()!=0){
+            return R.error("姝よ鍒掑崟宸插瓨鍦ㄥ壇瑙勫垝鍗曪紝id涓�"+hostPlan.getAssistantPlanId());
+        }
+        // pre
+        Plan plan = new Plan(hostPlan);
+        // begin
+        Long hostId = getHostId();
+        if (planService.selectByUuid(hostId, plan.getUuid()) != null) {
+            throw new CoolException("瑙勫垝鍗曞凡瀛樺湪");
+        }
+
+        Order order = orderService.selectById(plan.getOrderId());
+        if (Cools.isEmpty(order)) {
+            throw new CoolException("璺熻釜椤圭洰涓嶅瓨鍦�");
+        }
+
+        if (!order.getDirector().equals(getUserId())){
+            throw new CoolException("鍙厑璁歌窡韪」鐩礋璐d汉娣诲姞鎵�閫夐」鐩鍒掔敵璇峰崟");
+        }
+
+        Date now = new Date();
+        plan.setHostId(hostId);
+        plan.setUuid(planService.getUuid(hostId));  // 瑙勫垝鍗曚唬鍙�
+        plan.setDeptId(getDeptId());               // 鎵�灞為儴闂�
+        plan.setUserId(getUserId());               // 鎵�灞炰汉鍛�
+
+        plan.setAppleTime(now);
+        plan.setCreateBy(getUserId());
+        plan.setCreateTime(now);
+        plan.setUpdateBy(getUserId());
+        plan.setUpdateTime(now);
+        plan.setStatus(0);
+        plan.setStatus2(0);
+        plan.setStep(1);
+        plan.setSettle(1);  // 1.寮�濮�
+        plan.setAssistantHostSign(1);//鍓鍒掑崟
+
+        User manager = new User();
+        try{
+            manager = userService.getDeptManager(getHostId(), getUser().getDeptId());        // 鑾峰彇閮ㄩ棬棰嗗
+        }catch (Exception e){
+            manager = getUser();
+        }
+        PlanType planType = new PlanType(hostPlan.getHostId(),1);//1:璐ф灦
+        User planLeader = planTypeService.findPlanLeader(planType);
+        plan.setSettleMsg(JSON.toJSONString(SettleDto.init(plan, manager, planLeader)));
+
+        plan.setDirector(planLeader.getId());
+
+        if (!planService.insert(plan)) {
+            throw new CoolException("淇濆瓨澶辫触锛岃閲嶈瘯");
+        }
+        plan.setAssistantPlanId(plan.getId());
+        plan.setHostPlanId(hostPlanId);
+        if (!planService.updateById(plan)) {
+            throw new CoolException("鏇存柊澶辫触锛岃閲嶈瘯");
+        }
+        // 鑷姩娣诲姞璺熻繘浜�
+        PlanFoll planFoll = new PlanFoll();
+        planFoll.setPlanId(plan.getId());
+        planFoll.setUserId(planLeader.getId());
+        if (!planFollService.insert(planFoll)) {
+            throw new CoolException("淇濆瓨澶辫触锛岃閲嶈瘯");
+        }
+
+        hostPlan.setAssistantPlanId(plan.getId());
+        hostPlan.setHostPlanId(hostPlanId);
+        if (!planService.updateById(hostPlan)) {
+            throw new CoolException("鏇存柊澶辫触锛岃閲嶈瘯");
+        }
+        if (!smsCodeService.sendSmsCodeText(planLeader.getMobile(), PhoneCodeTypeParam.ALIYUN_M1ABAC630E)) {
+            return R.ok("鍒涘缓鎴愬姛浣嗙煭淇″彂閫佸け璐�!");
+        }
+        return R.ok("淇濆瓨鎴愬姛");
+    }
+
 	@RequestMapping(value = "/plan/update/auth")
-	@ManagerAuth
-    public R update(Plan plan){
-        if (Cools.isEmpty(plan) || null==plan.getId()){
+	@ManagerAuth(memo = "鏇存柊瑙勫垝鐢宠鍗�")
+    @Transactional
+    public R update(@RequestParam Map<String, Object> param){
+//        String planNeed = null;
+//        Integer id = null;
+//        for (Map.Entry<String, Object> entry : param.entrySet()){
+//            String val = String.valueOf(entry.getValue());
+//            if (Cools.isEmpty(val)){
+//                continue;
+//            }
+//            if (entry.getKey().equals("planNeed")){
+//                planNeed = val;
+//            }
+//            if (entry.getKey().equals("id")){
+//                try{
+//                    id = Integer.parseInt(val);
+//                }catch (Exception e){
+//                    return R.error();
+//                }
+//            }
+//        }
+        if (Cools.isEmpty(param) || Cools.isEmpty(param.get("id"))){
             return R.error();
         }
-        planService.updateById(plan);
+//        List<String> planNeedbs = new ArrayList<>(Arrays.asList(planNeed.split("-")));
+//        if (planNeedbs.get(0).equals("[object Object]")){
+//            planNeedbs.remove(0);
+//            Plan plan1 = planService.selectById(id);
+//            List<String> planNeedas = Arrays.asList(plan1.getPlanNeed().split("-"));
+//            List<String> routeIntersectionString = SetOfUtils.getRouteIntersectionString(planNeedas, planNeedbs, RouteCollectCountType.DEDUPLICATIONUNION);
+//            planNeed="";
+//            for (String planNeedss:routeIntersectionString){
+//                planNeed=planNeed==""? planNeedss:planNeed + "-" + planNeedss;
+//            }
+//        }
+
+
+        // pre
+        Plan plan = JSON.parseObject(JSON.toJSONString(param), Plan.class);
+//        plan.setPlanNeed(planNeed);
+        param.entrySet().removeIf(next -> this.fields.contains(next.getKey()));
+        plan.setUpdateBy(getUserId());
+        plan.setUpdateTime(new Date());
+
+        plan.setForm(JSON.toJSONString(param));     // 鑷畾涔夎〃鍗曞唴瀹�
+
+        if (!planService.updateById(plan)) {
+            throw new CoolException("淇濇寔澶辫触锛岃閲嶈瘯");
+        }
         return R.ok();
     }
 
     @RequestMapping(value = "/plan/delete/auth")
-    @ManagerAuth
+    @ManagerAuth(memo = "鍒犻櫎瑙勫垝鐢宠鍗�")
     public R delete(@RequestParam(value="ids[]") Long[] ids){
          for (Long id : ids){
-            planService.deleteById(id);
+             int priOnline2 = priOnline2Service.selectCount(new EntityWrapper<PriOnline2>().eq("item_id", id));
+             if (priOnline2!=0){
+                 return R.error("瀛樺湪鍏宠仈鐨勬牳浠峰崟锛岀姝㈠垹闄わ紒锛侊紒");
+             }
+             Plan planA = planService.selectById(id);
+             if (planA.getAssistantHostSign()==1){
+                 Plan planB = planService.selectById(planA.getHostPlanId());
+                 planB.setAssistantPlanId(0L);
+                 planB.setHostPlanId(0L);
+                 planB.setStatus2(0);
+                 planService.updateById(planB);
+             }else {
+                 if (!Cools.isEmpty(planA.getAssistantPlanId()) && planA.getAssistantPlanId()!=0){
+                     Plan planB = planService.selectById(planA.getAssistantPlanId());
+                     if (!Cools.isEmpty(planB)){
+                         return R.error("瀛樺湪鍏宠仈鐨勫壇瑙勫垝鍗曪紝绂佹鍒犻櫎锛侊紒锛� 鍓鍒掑崟ID锛�"+planB.getId());
+                     }
+                 }
+             }
+             planService.deleteById(id);
         }
         return R.ok();
     }
 
-    @RequestMapping(value = "/plan/export/auth")
+    @RequestMapping(value = "/plan/insert/file/auth")
+//    @ManagerAuth
+    public R insertFile(@RequestParam("planId") String planId, @RequestParam("filename") String filename, @RequestParam("filesize") Long filesize) {
+        try {
+//            InputStream inputStream = file.getInputStream();
+//            // 鑾峰彇鏂囦欢鐨勫唴瀹圭被鍨�
+//            String contentType = file.getContentType();
+//            String url = ossService.upload(inputStream, file.getOriginalFilename(), contentType);
+////            String url = "http://tjdt.oss-cn-hangzhou.aliyuncs.com/"+file.getOriginalFilename();
+//            String[] names = url.split("com/");
+//            String name= names[1];
+
+
+            String[] split = planId.split("-");
+            int id = Integer.parseInt(split[1]);
+            String url = "http://zhongyang-ftpserver.oss-cn-hangzhou.aliyuncs.com/" + filename;
+            planService.increasePlanUrl(id, url, filename, filesize);
+            return R.ok();
+        } catch (Exception e) {
+            System.out.println(e);
+            return R.error();
+        }
+    }
+
+    private String getFileSuffix(String filename) {
+        int dotIndex = filename.lastIndexOf(".");
+        if (dotIndex > 0 && dotIndex < filename.length() - 1) {
+            return filename.substring(dotIndex + 1);
+        }
+        return "";
+    }
+
+//    @RequestMapping(value = "/plan/delete/file/auth")
+////    @ManagerAuth
+//    public R deleteFile(@RequestParam("planId") String planId,@RequestParam MultipartFile file){
+//        planId="涓婁紶鏂囦欢-20";
+//        String[] split = planId.split("-");
+//        int id = Integer.parseInt(split[1]);
+//        System.out.println("---寮�濮�---");
+//        String savePath = "D:/crm/plan/file/"+id+"/"+file.getName(); // 鎸囧畾淇濆瓨鏂囦欢鐨勮矾寰�
+//        try{
+//            FileSaveExampleUtil.deleteFilesInDirectory(savePath);
+//        }catch (Exception e){
+//            return R.error();
+//        }
+//        return R.ok();
+//    }
+
+    @RequestMapping(value = "/plan/view/file/auth")
+//    @ManagerAuth
+    public R viewFile(@RequestParam("planId") String planId){
+        List<FileSaveExampleUtil.FileDTO> fileDTOS = new ArrayList<>();
+        if (Cools.isEmpty(planId)){
+            return R.ok(fileDTOS);
+        }
+        int id = Integer.parseInt(planId);
+//        String savePath = "D:/crm/plan/file/"+id+"/"; // 鎸囧畾淇濆瓨鏂囦欢鐨勮矾寰�
+        try{
+            List<Integer> ids = planService.selectPlanUrlId(id);
+            for (int id2 : ids){
+                String url = planService.selectPlanUrlPlanIdUrl(id2);
+                String name = planService.selectPlanUrlPlanIdName(id2);
+                Long size = planService.selectPlanUrlPlanIdSize(id2);
+                FileSaveExampleUtil.FileDTO dto = new FileSaveExampleUtil.FileDTO(name,size,url);
+                fileDTOS.add(dto);
+            }
+//            List<FileSaveExampleUtil.FileDTO> fileDTOS = FileSaveExampleUtil.viewFileList(savePath);
+            return R.ok(fileDTOS);
+        }catch (Exception e){
+            return R.error();
+        }
+    }
+
+    @RequestMapping(value = "/plan/download/file/auth")
+//    @ManagerAuth
+    public R downloadFile(@RequestParam("downloadUrl") String downloadUrl,HttpServletResponse response){
+//        System.out.println("---寮�濮�---");
+//        MultipartFile
+        try{
+            String[] names = downloadUrl.split("com/");
+            String name= names[1];
+//            ResponseEntity<Resource> resourceResponseEntity = FileSaveExampleUtil.downloadFile(downloadUrl, response);
+//            return R.ok(resourceResponseEntity);
+            String download = ossService.download(name);
+            return R.ok().add(download);
+        }catch (Exception e){
+
+        }
+        return R.error();
+    }
+
+
+
+    @PostMapping(value = "/plan/approval/auth")
+    @ManagerAuth(memo = "瀹℃壒鐢宠鍗�")
+    public R approval(@RequestParam Long planId,
+                      @RequestParam(required = false) Long plannerId){
+        Plan plan = planService.selectById(planId);
+        assert plan != null;
+
+        switch (plan.getSettle()) {
+//            case 1:
+//                // 鏈粍缁勯暱瀹℃牳
+//                User user = userService.selectById(plan.getUserId());
+//                User manager = new User();
+//                try{
+//                    manager = userService.getDeptManager(getHostId(), getUser().getDeptId());        // 鑾峰彇閮ㄩ棬棰嗗
+//                }catch (Exception e){
+//                    manager = user;
+//                }
+//                if (manager.getId().equals(getUserId())) {
+//
+//                    // 鏌ユ壘瑙勫垝缁勯暱
+//                    PlanType planType = planTypeService.selectById(plan.getPlanType());
+//                    User planLeader = planTypeService.findPlanLeader(planType);
+//                    if (Cools.isEmpty(planLeader)) {
+//                        throw new CoolException("鏈煡鎵惧埌瑙勫垝缁勯暱锛岃鑱旂郴绠$悊鍛�");
+//                    }
+//
+//                    // 淇敼 settle 姝ラ鏁版嵁
+//                    List<SettleDto> list = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
+//                    for (SettleDto dto : list) {
+//                        switch (dto.getStep()) {
+//                            case 1:
+//                                dto.setCurr(Boolean.FALSE);
+//                                break;
+//                            case 2:
+//                                dto.setCurr(Boolean.TRUE);
+//                                dto.setMsg("鏈粍缁勯暱" + manager.getNickname() + "瀹℃壒閫氳繃");
+//                                dto.setTime(DateUtils.convert(new Date()));
+//                                break;
+//                            case 3:
+//                                dto.setUserId(planLeader.getId());
+//                                dto.setUsername(planLeader.getNickname());
+//                                break;
+//                            default:
+//                                break;
+//                        }
+//                    }
+//                    plan.setSettleMsg(JSON.toJSONString(list));
+//
+//                    // 淇敼瑙勫垝鍗曠姸鎬�
+//                    plan.setSettle(2);  // 瑙勫垝缁勯暱寰呭
+//                    plan.setUpdateBy(getUserId());
+//                    plan.setUpdateTime(new Date());
+//
+//                    if (!planService.updateById(plan)) {
+//                        throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+//                    }
+//
+//                    // 娣诲姞瑙勫垝缁勯暱璺熻繘浜�
+//                    PlanFoll planFoll = new PlanFoll();
+//                    planFoll.setPlanId(plan.getId());
+//                    planFoll.setUserId(planLeader.getId());
+//                    if (!planFollService.insert(planFoll)) {
+//                        throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+//                    }
+//
+//                } else {
+//                    return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+//                }
+//                break;
+            case 1:
+                // 鏌ユ壘瑙勫垝缁勯暱
+                User planLeader = userService.selectById(plan.getDirector());
+                if (Cools.isEmpty(planLeader)) {
+                    throw new CoolException("鏈煡鎵惧埌瑙勫垝缁勯暱锛岃鑱旂郴绠$悊鍛�");
+                }
+                if (Cools.isEmpty(planLeader)) {
+                    throw new CoolException("鏈煡鎵惧埌瑙勫垝缁勯暱锛岃鑱旂郴绠$悊鍛�");
+                }
+                if (!getUserId().equals(planLeader.getId())) {
+                    return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+                }
+                if (Cools.isEmpty(plannerId)) {
+                    return R.error("鎸囧畾瑙勫垝鍛樹笉鑳戒负绌�");
+                }
+                plan.setDirector(plannerId);
+                User planner = userService.selectById(plannerId);
+                // 淇敼 settle 姝ラ鏁版嵁
+                List<SettleDto> list = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
+                for (SettleDto dto : list) {
+                    switch (dto.getStep()) {
+                        case 1:
+                            dto.setCurr(Boolean.FALSE);
+                            break;
+                        case 2:
+                            dto.setCurr(Boolean.TRUE);
+                            if (Cools.isEmpty(dto.getMsg())){
+                                dto.setMsg("鍞墠缁勯暱" + planLeader.getNickname() + "瀹℃壒閫氳繃");
+                            }else {
+                                dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(new Date())+" "+"鍞墠缁勯暱" + planLeader.getNickname() + "瀹℃壒閫氳繃");
+                            }
+                            dto.setTime(DateUtils.convert(new Date()));
+                            break;
+                        case 3:
+                            dto.setUserId(planner.getId());
+                            dto.setUsername(planner.getNickname());
+                            break;
+                        default:
+                            break;
+                    }
+                }
+                plan.setSettleMsg(JSON.toJSONString(list));
+                // 淇敼瑙勫垝鍗曠姸鎬�
+                plan.setSettle(2);  // 瑙勫垝鍛樺緟瀹�
+                plan.setPlanner(planner.getId());
+                plan.setUpdateBy(getUserId());
+                plan.setUpdateTime(new Date());
+
+                if (!planService.updateById(plan)) {
+                    throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+                }
+
+                // 娣诲姞瑙勫垝鍛樿窡杩涗汉
+                PlanFoll planFoll = new PlanFoll();
+                planFoll.setPlanId(plan.getId());
+                planFoll.setUserId(planner.getId());
+                if (!planFollService.insert(planFoll)) {
+                    throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+                }
+
+                if (!smsCodeService.sendSmsCodeText(planner.getMobile(), PhoneCodeTypeParam.ALIYUN_M6F3C81FE3)) {
+                    return R.ok("瀹℃牳鎴愬姛浣嗙煭淇″彂閫佸け璐�!");
+                }
+                break;
+            case 2:
+                User plannerUser = userService.selectById(plan.getPlanner());
+                if (Cools.isEmpty(plannerUser)) {
+                    return R.error("鏈壘鍒拌鍒掑憳");
+                }
+                if (!getUserId().equals(plannerUser.getId())) {
+                    return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+                }
+                // 涓氬姟鍛�
+                User salesman = userService.selectById(plan.getUserId());
+                plan.setDirector(salesman.getId());
+
+                // 淇敼 settle 姝ラ鏁版嵁
+                List<SettleDto> list0 = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
+                for (SettleDto dto : list0) {
+                    switch (dto.getStep()) {
+                        case 2:
+                            dto.setCurr(Boolean.FALSE);
+                            break;
+                        case 3:
+                            dto.setCurr(Boolean.TRUE);
+                            if (Cools.isEmpty(dto.getMsg())){
+                                dto.setMsg("瑙勫垝鍛�" + plannerUser.getNickname() + "瀹℃壒閫氳繃");
+                            }else {
+                                dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(new Date())+" "+"瑙勫垝鍛�" + plannerUser.getNickname() + "瀹℃壒閫氳繃");
+                            }
+                            dto.setTime(DateUtils.convert(new Date()));
+                            break;
+                        case 4:
+                            dto.setUserId(salesman.getId());
+                            dto.setUsername(salesman.getNickname());
+                            break;
+                        default:
+                            break;
+                    }
+                }
+                plan.setSettleMsg(JSON.toJSONString(list0));
+                // 淇敼瑙勫垝鍗曠姸鎬�
+                plan.setSettle(3);  // 瀹℃壒閫氳繃
+                plan.setUpdateBy(getUserId());
+                plan.setUpdateTime(new Date());
+
+                if (!planService.updateById(plan)) {
+                    throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+                }
+                if (!smsCodeService.sendSmsCodeText(salesman.getMobile(), PhoneCodeTypeParam.ALIYUN_M1ABAC630E)) {
+                    return R.ok("瀹℃牳鎴愬姛浣嗙煭淇″彂閫佸け璐�!");
+                }
+                break;
+            case 3:
+                // 涓氬姟鍛�
+                User salesman0 = userService.selectById(plan.getUserId());
+                if (!getUserId().equals(salesman0.getId())) {
+                    return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+                }
+                // 淇敼 settle 姝ラ鏁版嵁
+                List<SettleDto> list1 = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
+                for (SettleDto dto : list1) {
+                    switch (dto.getStep()) {
+                        case 3:
+                            dto.setCurr(Boolean.TRUE);
+                            break;
+                        case 4:
+                            dto.setCurr(Boolean.TRUE);
+                            if (Cools.isEmpty(dto.getMsg())){
+                                dto.setMsg("涓氬姟鍛�" + salesman0.getNickname() + "瀹℃壒閫氳繃");
+                            }else {
+                                dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(new Date())+" "+"涓氬姟鍛�" + salesman0.getNickname() + "瀹℃壒閫氳繃");
+                            }
+                            dto.setTime(DateUtils.convert(new Date()));
+                            break;
+                        default:
+                            break;
+                    }
+                }
+                plan.setSettleMsg(JSON.toJSONString(list1));
+                // 淇敼瑙勫垝鍗曠姸鎬�
+                plan.setSettle(4);  // 瀹℃壒閫氳繃
+                plan.setStatus(1);  // 瀹℃壒閫氳繃
+                plan.setUpdateBy(getUserId());
+                plan.setUpdateTime(new Date());
+
+                if (plan.getAssistantHostSign()==1){
+                    Plan planHost = planService.selectById(plan.getHostPlanId());
+                    planHost.setStatus2(1);
+                    planService.updateById(planHost);
+                }
+
+                if (!planService.updateById(plan)) {
+                    throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�");
+                }
+                break;
+            default:
+                return R.error();
+        }
+        return R.ok("瀹℃壒鎴愬姛");
+    }
+
+    @PostMapping(value = "/plan/approvalEnd/auth")
+    @ManagerAuth(memo = "鎷掔粷鐢宠鍗�")
+    public R approvalEnd(@RequestParam Long planId,
+                         @RequestParam(required = false) Long plannerId) {
+        Plan plan = planService.selectById(planId);
+        Date now = new Date();
+        Long directorId = plan.getDirector();
+        User director = userService.selectById(directorId);
+        if (!director.getId().equals(getUserId())){
+            return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+        }
+        List<SettleDto> planDtos = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
+        List<SettleDto> planDtoList = new ArrayList<>();
+        boolean sign = true;
+        for (SettleDto dto : planDtos) {
+            if (dto.getStep().equals(2)){
+                plan.setDirector(dto.getUserId());
+            }
+            if (sign && dto.getUserId().equals(directorId) && plan.getSettle()+1==dto.getStep()){
+                if (Cools.isEmpty(dto.getMsg())){
+                    dto.setMsg(DateUtils.convert(now)+" "+director.getNickname()+"鍥為��瀹℃壒");
+                }else {
+                    dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(now)+" "+director.getNickname()+"鍥為��瀹℃壒");
+                }
+                sign = false;
+            }
+            if (sign){
+                dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(now)+" "+director.getNickname()+"鍥為��瀹℃壒");
+            }
+
+            planDtoList.add(dto);
+        }
+        plan.setStatus(0);
+        plan.setStep(1);
+        plan.setSettle(1);
+        plan.setSettleMsg(JSON.toJSONString(planDtoList));
+        plan.setUpdateBy(getUserId());
+        plan.setUpdateTime(now);
+        planService.updateById(plan);
+        return R.ok("鍥為��鎴愬姛");
+    }
+
+    @PostMapping(value = "/plan/planner/list/auth")
     @ManagerAuth
-    public R export(@RequestBody JSONObject param){
-        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
-        List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
-        Map<String, Object> map = excludeTrash(param.getJSONObject("plan"));
-        convert(map, wrapper);
-        List<Plan> list = planService.selectList(wrapper);
-        return R.ok(exportSupport(list, fields));
+    public R plannerList(@RequestParam Long planId){
+        Plan plan = planService.selectById(planId);
+        assert plan != null;
+
+        if (plan.getSettle() != 1) {
+            return R.error();
+        }
+        // 鏌ユ壘瑙勫垝缁勯暱
+        PlanType planType = planTypeService.selectById(plan.getPlanType());
+        if (plan.getAssistantHostSign()==1){
+            planType.setType(1);
+        }
+        User planLeader = planTypeService.findPlanLeader(planType);
+        if (Cools.isEmpty(planLeader)) {
+            throw new CoolException("鏈煡鎵惧埌瑙勫垝缁勯暱锛岃鑱旂郴绠$悊鍛�");
+        }
+        if (!getUserId().equals(planLeader.getId())) {
+            return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�");
+        }
+        // 鑾峰彇褰撴湡瑙勫垝缁勬墍鏈夋垚鍛�
+        List<User> users = userService.selectList(new EntityWrapper<User>().eq("dept_id", planLeader.getDeptId()));
+        List<KeyValueVo> vos = new ArrayList<>();
+        users.forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getNickname()), item.getId())));
+        if (planType.getType().equals(2)){
+            ProcessPermissions processPermissions= processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 101).eq("process", "1-1"));//2锛氭牳浠锋祦绋�
+            User manager = userService.selectById(processPermissions.getUserId());       // 鑾峰彇鏍镐环娴佺▼鑺傜偣1纭浜�
+            vos.add(new KeyValueVo(String.valueOf(manager.getNickname()), manager.getId()));
+        }
+        return R.ok().add(vos);
     }
 
     @RequestMapping(value = "/planQuery/auth")
@@ -109,6 +793,89 @@
             map.put("id", plan.getId());
             map.put("value", plan.getName());
             result.add(map);
+        }
+        return R.ok(result);
+    }
+
+    @RequestMapping(value = "/planQueryName/auth")
+    @ManagerAuth
+    public R queryName(String condition) {
+        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
+        wrapper.like("name", condition);
+        Long id = getRole().getId();
+        if (id.equals(1L)) {
+            wrapper.eq("host_id", 1);
+        } else if (id.equals(2L)) {
+            wrapper.eq("dept_id", getDeptId());
+        } else {
+            wrapper.eq("user_id", getUserId());
+        }
+        Page<Plan> page = planService.selectPage(new Page<>(0, 10), wrapper);
+        List<Map<String, Object>> result = new ArrayList<>();
+        for (Plan plan : page.getRecords()){
+            Map<String, Object> map = new HashMap<>();
+            map.put("id", plan.getId());
+//            map.put("value", plan.getName()+"---"+plan.getId());
+            map.put("value", plan.getName());
+            result.add(map);
+        }
+        return R.ok(result);
+    }
+
+    @RequestMapping(value = "/planQueryNameToRob/auth")
+    @ManagerAuth
+    public R planQueryNameToRob(String condition) {
+        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
+        wrapper.like("name", condition);
+        wrapper.eq("status",1);
+        wrapper.eq("assistant_host_sign",0);
+
+        List<ProcessPermissions> processPermissionsList = processPermissionsService.selectList(new EntityWrapper<ProcessPermissions>().eq("process_memo", 4).or().eq("process_memo", 5));//2锛氭牳浠锋祦绋�
+        int type =0;
+        for (ProcessPermissions processPermissions:processPermissionsList){
+            if (getUserId().equals(processPermissions.getUserId())){
+                type=PBN-processPermissions.getProcessMemo();
+                break;
+            }
+        }
+        if (type==0){
+            return R.error("浣犱笉鏄牳浠峰憳,鏃犳潈鎺ヤ换鍔�");
+        }
+
+        List<Long> typeList = new ArrayList<>();
+        List<PlanType> planTypes = planTypeService.selectList(new EntityWrapper<PlanType>().eq("type", type));
+        if (Cools.isEmpty(planTypes) || planTypes.size()==0){
+            return R.ok();
+        }
+        for (PlanType planType : planTypes){
+            typeList.add(planType.getId());
+        }
+        wrapper.in("plan_type",typeList);
+
+//        Page<Plan> page = planService.selectPage(new Page<>(0, 10), wrapper);
+        List<Plan> plans = planService.selectList(wrapper);
+        List<Map<String, Object>> result = new ArrayList<>();
+//        for (Plan plan : page.getRecords()){
+        for (Plan plan : plans){
+            Map<String, Object> map = new HashMap<>();
+            map.put("id", plan.getId());
+//            map.put("value", plan.getName()+"---"+plan.getId());
+            map.put("value", plan.getName());
+            result.add(map);
+        }
+        if (type==1){
+            EntityWrapper<Plan> wrapper2 = new EntityWrapper<>();
+            wrapper2.like("name", condition);
+            wrapper2.eq("status",1);
+            wrapper2.eq("assistant_host_sign",1);
+            List<Plan> plan2s = planService.selectList(wrapper2);
+            for (Plan plan : plan2s){
+                Map<String, Object> map = new HashMap<>();
+                map.put("id", plan.getId());
+//            map.put("value", plan.getName()+"---"+plan.getId());
+                map.put("value", plan.getName());
+                result.add(map);
+            }
         }
         return R.ok(result);
     }
@@ -132,4 +899,103 @@
         return R.ok().add(vos);
     }
 
+    /*************************************** 鏁版嵁鐩稿叧 ***********************************************/
+
+    /**
+     * excel瀵煎叆
+     */
+    @PostMapping(value = "/plan/excel/import/auth")
+    @ManagerAuth(memo = "鐢叉柟鍗曚綅Excel瀵煎叆")
+//    @Transactional
+    public R planExcelImport(MultipartFile file) throws IOException {
+        InputStream inStream = file.getInputStream();
+        String fileMime = file.getContentType();
+        int excelVersion = 2007;
+        if ("application/vnd.ms-excel".equals(fileMime)) {
+            excelVersion = 2003;
+        }
+        Workbook book = null;
+        if (excelVersion == 2003) {
+            book = new HSSFWorkbook(inStream);
+        }
+        else {  // 褰� excel 鏄� 2007 鏃�
+            book = new XSSFWorkbook(inStream);
+        }
+        Sheet sheet = book.getSheetAt(0);
+        int totalRows = sheet.getLastRowNum() + 1;    // 鎬�
+        Long userId = getUserId();
+        Long hostId = getHostId();
+        Long deptId = getDeptId();
+        Date now = new Date();
+        DataFormatter dataFormatter = new DataFormatter();
+        for (int i = 2; i < totalRows; i++) {
+        }
+        return R.ok();
+    }
+
+    /**
+     * excel瀵煎嚭
+     */
+    @PostMapping(value = "/plan/excel/export/auth")
+    @ManagerAuth
+    public void planExcelExport(HttpServletResponse response) throws IOException {
+
+    }
+
+    /******************************** 璺熻繘浜� ***************************************/
+
+    @Autowired
+    private PlanFollService planFollService;
+    @Autowired
+    private UserService userService;
+
+    @RequestMapping(value = "/plan/followers/table/auth")
+    @ManagerAuth
+    public R planFollowersTable(@RequestParam("planId") Long planId) {
+        List<PlanFoll> planFolls = planFollService.selectList(new EntityWrapper<PlanFoll>().eq("plan_id", planId).orderBy("id", false));
+        List<FollowerTableVo> result = new ArrayList<>();
+        for (PlanFoll planFoll : planFolls) {
+            User user = userService.selectById(planFoll.getUserId());
+            FollowerTableVo vo = new FollowerTableVo();
+            vo.setUserId(user.getId());
+            vo.setUserName(user.getNickname());
+            result.add(vo);
+        }
+        return R.ok().add(result);
+    }
+
+    @RequestMapping(value = "/plan/followers/add/auth")
+    @ManagerAuth
+    @Transactional
+    public R planFollowersAdd(@RequestParam("planId") Long planId,
+                               @RequestParam("followerIds[]") Long[] followerIds) {
+        if (Cools.isEmpty(planId, followerIds)) {
+            return R.parse(BaseRes.PARAM);
+        }
+        for (Long userId : followerIds) {
+            if (planFollService.selectCount(new EntityWrapper<PlanFoll>().eq("plan_id", planId).eq("user_id", userId)) == 0) {
+                PlanFoll planFoll = new PlanFoll();
+                planFoll.setPlanId(planId);
+                planFoll.setUserId(userId);
+                if (!planFollService.insert(planFoll)) {
+                    throw new CoolException("娣诲姞澶辫触锛岃鑱旂郴绠$悊鍛�");
+                }
+            }
+        }
+        return R.ok("娣诲姞鎴愬姛");
+    }
+
+    @RequestMapping(value = "/plan/followers/remove/auth")
+    @ManagerAuth
+    public R planFollowersRemove(@RequestParam("planId") Long planId,
+                                  @RequestParam("userId") Long userId) {
+        if (Cools.isEmpty(planId, userId)) {
+            return R.parse(BaseRes.PARAM);
+        }
+        if (!planFollService.delete(new EntityWrapper<PlanFoll>().eq("plan_id", planId).eq("user_id", userId))) {
+            throw new CoolException("鍒犻櫎澶辫触锛岃鑱旂郴绠$悊鍛�");
+        }
+        return R.ok("鍒犻櫎鎴愬姛");
+    }
+
 }

--
Gitblit v1.9.1