中扬CRM客户关系管理系统
#
whycq
2023-08-21 a3a2772ac1091c933b8c7c07c96ea5ecdae3f3d1
src/main/java/com/zy/crm/manager/controller/PlanController.java
@@ -8,11 +8,17 @@
import com.core.annotations.ManagerAuth;
import com.core.common.BaseRes;
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
import com.core.domain.KeyValueVo;
import com.core.exception.CoolException;
import com.zy.crm.common.entity.RouteCollectCountType;
import com.zy.crm.common.model.SettleDto;
import com.zy.crm.common.utils.FileSaveExampleUtil;
import com.zy.crm.common.utils.SetOfUtils;
import com.zy.crm.common.web.BaseController;
import com.zy.crm.manager.controller.result.FollowerTableVo;
import com.zy.crm.manager.entity.Order;
import com.zy.crm.manager.entity.Plan;
import com.zy.crm.manager.entity.PlanFoll;
import com.zy.crm.manager.entity.PlanType;
@@ -20,6 +26,7 @@
import com.zy.crm.manager.service.PlanService;
import com.zy.crm.manager.service.PlanTypeService;
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;
@@ -30,11 +37,20 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.core.io.Resource;
import org.springframework.core.io.FileSystemResource;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.util.*;
import static java.util.stream.Collectors.toList;
@RestController
public class PlanController extends BaseController {
@@ -43,6 +59,8 @@
    private PlanService planService;
    @Autowired
    private PlanTypeService planTypeService;
    @Autowired
    private DeptService deptService;
    @GetMapping(value = "/plan/{id}/auth")
    @ManagerAuth
@@ -59,6 +77,9 @@
            return R.error("当前规划单类型已被禁用");
        }
        resultObj.put("formHtml", planType.getHtml());
        // 步骤条相关
        resultObj.put("step", plan.getSettle() == 5 ? 0 : plan.getSettle() + 1);
        return R.ok().add(resultObj);
    }
@@ -87,6 +108,7 @@
    @RequestMapping(value = "/plan/add/auth")
    @ManagerAuth
    @Transactional
    public R add(@RequestParam Map<String, Object> param) {
        // pre
        Plan plan = JSON.parseObject(JSON.toJSONString(param), Plan.class);
@@ -115,21 +137,65 @@
        plan.setForm(JSON.toJSONString(param));     // 自定义表单内容
        plan.setSettle(1);  // 1.开始
        User manager = userService.getDeptManager(hostId, getUser().getDeptId());        // 获取部门领导
        plan.setSettleMsg(JSON.toJSONString(SettleDto.init(plan, manager)));
        if (!planService.insert(plan)) {
            throw new CoolException("保持失败,请重试");
        }
        // 自动添加跟进人
        PlanFoll planFoll = new PlanFoll();
        planFoll.setPlanId(plan.getId());
        planFoll.setUserId(manager.getId());
        if (!planFollService.insert(planFoll)) {
            throw new CoolException("保持失败,请重试");
        }
        return R.ok();
    }
   @RequestMapping(value = "/plan/update/auth")
   @ManagerAuth
    @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();
        }
//        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());
@@ -151,11 +217,317 @@
        return R.ok();
    }
    @RequestMapping(value = "/plan/insert/file/auth")
//    @ManagerAuth
    public R insertFile(@RequestParam("planId") String planId,@RequestParam MultipartFile file){
        String[] split = planId.split("-");
        int id = Integer.parseInt(split[1]);
        System.out.println("---开始---");
        String savePath = "D:/crm/plan/file/"+id+"/"; // 指定保存文件的路径
        try{
            FileSaveExampleUtil.saveFile(file, savePath);
        }catch (Exception e){
            return R.error();
        }
        return R.ok();
    }
    @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){
        int id = Integer.parseInt(planId);
        String savePath = "D:/crm/plan/file/"+id+"/"; // 指定保存文件的路径
        try{
            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{
            ResponseEntity<Resource> resourceResponseEntity = FileSaveExampleUtil.downloadFile(downloadUrl, response);
            return R.ok(resourceResponseEntity);
        }catch (Exception e){
            return R.error();
        }
    }
    @PostMapping(value = "/plan/approval/auth")
    @ManagerAuth
    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 = userService.getDeptManager(getHostId(), user.getDeptId());
                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 2:
                // 查找规划组长
                PlanType planType = planTypeService.selectById(plan.getPlanType());
                User planLeader = planTypeService.findPlanLeader(planType);
                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("指定规划员不能为空");
                }
                User planner = userService.selectById(plannerId);
                // 修改 settle 步骤数据
                List<SettleDto> list = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
                for (SettleDto dto : list) {
                    switch (dto.getStep()) {
                        case 2:
                            dto.setCurr(Boolean.FALSE);
                            break;
                        case 3:
                            dto.setCurr(Boolean.TRUE);
                            dto.setMsg("售前组长" + planLeader.getNickname() + "审批通过");
                            dto.setTime(DateUtils.convert(new Date()));
                            break;
                        case 4:
                            dto.setUserId(planner.getId());
                            dto.setUsername(planner.getNickname());
                            break;
                        default:
                            break;
                    }
                }
                plan.setSettleMsg(JSON.toJSONString(list));
                // 修改规划单状态
                plan.setSettle(3);  // 规划员待审
                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("审核失败,请联系管理员");
                }
                break;
            case 3:
                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());
                // 修改 settle 步骤数据
                List<SettleDto> list0 = JSON.parseArray(plan.getSettleMsg(), SettleDto.class);
                for (SettleDto dto : list0) {
                    switch (dto.getStep()) {
                        case 3:
                            dto.setCurr(Boolean.FALSE);
                            break;
                        case 4:
                            dto.setCurr(Boolean.TRUE);
                            dto.setMsg("规划员" + plannerUser.getNickname() + "审批通过");
                            dto.setTime(DateUtils.convert(new Date()));
                            break;
                        case 5:
                            dto.setUserId(salesman.getId());
                            dto.setUsername(salesman.getNickname());
                            break;
                        default:
                            break;
                    }
                }
                plan.setSettleMsg(JSON.toJSONString(list0));
                // 修改规划单状态
                plan.setSettle(4);  // 审批通过
                plan.setUpdateBy(getUserId());
                plan.setUpdateTime(new Date());
                if (!planService.updateById(plan)) {
                    throw new CoolException("审核失败,请联系管理员");
                }
                break;
            case 4:
                // 业务员
                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 4:
                            dto.setCurr(Boolean.TRUE);
                            break;
                        case 5:
                            dto.setCurr(Boolean.TRUE);
                            dto.setMsg("业务员" + salesman0.getNickname() + "审批通过");
                            dto.setTime(DateUtils.convert(new Date()));
                            break;
                        default:
                            break;
                    }
                }
                plan.setSettleMsg(JSON.toJSONString(list1));
                // 修改规划单状态
                plan.setSettle(5);  // 审批通过
                plan.setUpdateBy(getUserId());
                plan.setUpdateTime(new Date());
                if (!planService.updateById(plan)) {
                    throw new CoolException("审核失败,请联系管理员");
                }
                break;
            default:
                return R.error();
        }
        return R.ok("审批成功");
    }
    @PostMapping(value = "/plan/planner/list/auth")
    @ManagerAuth
    public R plannerList(@RequestParam Long planId){
        Plan plan = planService.selectById(planId);
        assert plan != null;
        if (plan.getSettle() != 2) {
            return R.error();
        }
        // 查找规划组长
        PlanType planType = planTypeService.selectById(plan.getPlanType());
        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())));
        return R.ok().add(vos);
    }
    @RequestMapping(value = "/planQuery/auth")
    @ManagerAuth
    public R query(String condition) {
        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
        wrapper.like("name", condition);
        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());
            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()){
@@ -238,8 +610,8 @@
    @RequestMapping(value = "/plan/followers/table/auth")
    @ManagerAuth
    public R planFollowersTable(@RequestParam("orderId") Long orderId) {
        List<PlanFoll> planFolls = planFollService.selectList(new EntityWrapper<PlanFoll>().eq("plan_id", orderId).orderBy("id", false));
    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());
@@ -254,15 +626,15 @@
    @RequestMapping(value = "/plan/followers/add/auth")
    @ManagerAuth
    @Transactional
    public R planFollowersAdd(@RequestParam("orderId") Long orderId,
    public R planFollowersAdd(@RequestParam("planId") Long planId,
                               @RequestParam("followerIds[]") Long[] followerIds) {
        if (Cools.isEmpty(orderId, followerIds)) {
        if (Cools.isEmpty(planId, followerIds)) {
            return R.parse(BaseRes.PARAM);
        }
        for (Long userId : followerIds) {
            if (planFollService.selectCount(new EntityWrapper<PlanFoll>().eq("plan_id", orderId).eq("user_id", userId)) == 0) {
            if (planFollService.selectCount(new EntityWrapper<PlanFoll>().eq("plan_id", planId).eq("user_id", userId)) == 0) {
                PlanFoll planFoll = new PlanFoll();
                planFoll.setPlanId(orderId);
                planFoll.setPlanId(planId);
                planFoll.setUserId(userId);
                if (!planFollService.insert(planFoll)) {
                    throw new CoolException("添加失败,请联系管理员");
@@ -274,12 +646,12 @@
    @RequestMapping(value = "/plan/followers/remove/auth")
    @ManagerAuth
    public R planFollowersRemove(@RequestParam("orderId") Long orderId,
    public R planFollowersRemove(@RequestParam("planId") Long planId,
                                  @RequestParam("userId") Long userId) {
        if (Cools.isEmpty(orderId, userId)) {
        if (Cools.isEmpty(planId, userId)) {
            return R.parse(BaseRes.PARAM);
        }
        if (!planFollService.delete(new EntityWrapper<PlanFoll>().eq("plan_id", orderId).eq("user_id", userId))) {
        if (!planFollService.delete(new EntityWrapper<PlanFoll>().eq("plan_id", planId).eq("user_id", userId))) {
            throw new CoolException("删除失败,请联系管理员");
        }
        return R.ok("删除成功");