package com.zy.crm.manager.controller; 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.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.service.OssService; 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; import com.zy.crm.manager.service.PlanFollService; 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; 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 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 { @Autowired private PlanService planService; @Autowired private PlanTypeService planTypeService; @Autowired private DeptService deptService; @Autowired private OssService ossService; @GetMapping(value = "/plan/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { 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() == 5 ? 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) { return R.ok(planService.getPage(new Page<>(curr, limit) , getHostId() , deptId == null ? null : String.valueOf(deptId) , userId == null ? getUserId() : userId , condition) ); } private final List fields = new ArrayList<>(); { Arrays.asList(Cools.getAllFields(Plan.class)).forEach(item -> { fields.add(item.getName()); }); } @RequestMapping(value = "/plan/add/auth") @ManagerAuth @Transactional public R add(@RequestParam Map param) { // pre Plan plan = JSON.parseObject(JSON.toJSONString(param), Plan.class); Iterator> iterator = param.entrySet().iterator(); while (iterator.hasNext()) { Map.Entry 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("规划单已存在"); } plan.setHostId(hostId); plan.setUuid(planService.getUuid(hostId)); // 规划单代号 plan.setDeptId(getDeptId()); // 所属部门 plan.setUserId(getUserId()); // 所属人员 plan.setCreateBy(getUserId()); plan.setCreateTime(new Date()); plan.setUpdateBy(getUserId()); plan.setUpdateTime(new Date()); plan.setStatus(1); 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 param){ // String planNeed = null; // Integer id = null; // for (Map.Entry 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 planNeedbs = new ArrayList<>(Arrays.asList(planNeed.split("-"))); // if (planNeedbs.get(0).equals("[object Object]")){ // planNeedbs.remove(0); // Plan plan1 = planService.selectById(id); // List planNeedas = Arrays.asList(plan1.getPlanNeed().split("-")); // List 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 public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ planService.deleteById(id); } return R.ok(); } @RequestMapping(value = "/plan/insert/file/auth") // @ManagerAuth public R insertFile(@RequestParam("planId") String planId,@RequestParam MultipartFile file){ try{ InputStream inputStream = file.getInputStream(); // 获取文件的内容类型 String contentType = file.getContentType(); String suffix = getFileSuffix(file.getOriginalFilename()); String url = ossService.upload(inputStream, suffix,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]); planService.increasePlanUrl(id,url,name,file.getSize()); /*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(); }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){ int id = Integer.parseInt(planId); // String savePath = "D:/crm/plan/file/"+id+"/"; // 指定保存文件的路径 try{ List ids = planService.selectPlanUrlId(id); List fileDTOS = new ArrayList<>(); 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 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 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 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 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 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 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 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 users = userService.selectList(new EntityWrapper().eq("dept_id", planLeader.getDeptId())); List 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 wrapper = new EntityWrapper<>(); wrapper.like("name", condition); Page page = planService.selectPage(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (Plan plan : page.getRecords()){ Map 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 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 page = planService.selectPage(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (Plan plan : page.getRecords()){ Map map = new HashMap<>(); map.put("id", plan.getId()); map.put("value", plan.getName()+"---"+plan.getId()); result.add(map); } return R.ok(result); } @RequestMapping(value = "/plan/check/column/auth") @ManagerAuth public R query(@RequestBody JSONObject param) { Wrapper wrapper = new EntityWrapper().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val")); if (null != planService.selectOne(wrapper)){ return R.parse(BaseRes.REPEAT).add(getComment(Plan.class, String.valueOf(param.get("key")))); } return R.ok(); } @RequestMapping("/plan/all/get/kv") @ManagerAuth public R getDataKV(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); Wrapper wrapper = new EntityWrapper().andNew().like("name", condition).orderBy("create_time", false); planService.selectPage(new Page<>(1, 30), wrapper).getRecords().forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getName()), item.getId()))); 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 planFolls = planFollService.selectList(new EntityWrapper().eq("plan_id", planId).orderBy("id", false)); List 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().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().eq("plan_id", planId).eq("user_id", userId))) { throw new CoolException("删除失败,请联系管理员"); } return R.ok("删除成功"); } }