From 96bea93e9591de5bd6e632b7bf9bb1e920f371ed Mon Sep 17 00:00:00 2001 From: LSH Date: 星期五, 10 十一月 2023 15:04:39 +0800 Subject: [PATCH] # --- src/main/java/com/zy/crm/manager/controller/PriQuoteController.java | 279 +++++++++++++++++++++++++------------------------------ 1 files changed, 128 insertions(+), 151 deletions(-) diff --git a/src/main/java/com/zy/crm/manager/controller/PriQuoteController.java b/src/main/java/com/zy/crm/manager/controller/PriQuoteController.java index 45d3c06..5bbb6fa 100644 --- a/src/main/java/com/zy/crm/manager/controller/PriQuoteController.java +++ b/src/main/java/com/zy/crm/manager/controller/PriQuoteController.java @@ -47,10 +47,15 @@ private PriQuoteBudgetService priQuoteBudgetService; @Autowired + private PriOnline2Service priOnline2Service; + + @Autowired private ProcessPermissionsService processPermissionsService; @Autowired private PlanTypeService planTypeService; + + String PZH=" 鈥斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�斺�� "; @RequestMapping(value = "/priQuote/{id}/auth") @ManagerAuth @@ -79,22 +84,26 @@ @RequestParam(required = false)String condition, @RequestParam Map<String, Object> param){ EntityWrapper<PriQuote> wrapper = new EntityWrapper<>(); - wrapper.setSqlSelect("id,title,create_time as createTime,filepath,item_id as itemId,order_num as orderNum,template_name as templateName,sheet_data as sheetData,user_id as userId,dept_id as deptId,settle,settle_msg as settleMsg,form,update_user_id as updateUserId,update_time as updateTime,in_order_num as inOrderNum,member_id as memberId"); - wrapper.in("member_id", getUserRoleBelongsToUserId()); + wrapper.setSqlSelect("id,title,create_time as createTime,plan_id as planId,filepath,item_id as itemId,order_num as orderNum,template_name as templateName,sheet_data as sheetData,user_id as userId,dept_id as deptId,settle,settle_msg as settleMsg,form,update_user_id as updateUserId,update_time as updateTime,in_order_num as inOrderNum,member_id as memberId,template"); +// wrapper.in("member_id", getUserRoleBelongsToUserId()); excludeTrash(param); convert(param, wrapper); allLike(PriQuote.class, param.keySet(), wrapper, condition); + wrapper.or().eq("member_id",getUserId()); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} return R.ok(priQuoteService.selectPage(new Page<>(curr, limit), wrapper)); } private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ - Long deptId = getDeptId(); boolean signUserId = false; boolean signDeptId = false; + boolean signHostId = false; for (Map.Entry<String, Object> entry : map.entrySet()){ if (entry.getKey().equals("dept_id")){ signDeptId = true; + if (String.valueOf(entry.getValue()).equals("19")){ + signHostId = true; + } } } for (Map.Entry<String, Object> entry : map.entrySet()){ @@ -115,46 +124,69 @@ } } if (!signUserId && !signDeptId){ - wrapper.eq("user_id", getUserId()); + if (getRole().getId()==1){ + wrapper.or().eq("host_id",1); + }else if (getRole().getId()==2){ + wrapper.eq("dept_id",getDeptId()); + }else { + wrapper.eq("user_id", getUserId()); + } + } + if (signHostId){ + wrapper.or().eq("host_id",1); } } @RequestMapping(value = "/priQuote/add/auth") - @ManagerAuth + @ManagerAuth(memo = "娣诲姞鎶ヤ环鍗�") public R add(@RequestBody Map<String,Object> map) { - PriQuoteBudget priQuoteBudget = priQuoteBudgetService.selectById(Long.parseLong(map.get("priQuoteBudgetId").toString())); +// PriQuoteBudget priQuoteBudget = priQuoteBudgetService.selectById(Long.parseLong(map.get("priQuoteBudgetId").toString())); + PriOnline2 priOnline2 = priOnline2Service.selectById(Long.parseLong(map.get("priQuoteBudgetId").toString())); PriQuote priQuote = new PriQuote(); priQuote.setCreateTime(new Date()); priQuote.setTitle(map.get("title").toString()); - priQuote.setTemplateName(priQuoteBudget.getTemplateName()); + priQuote.setTemplateName(priOnline2.getTemplateName()); priQuote.setSheetData(map.get("sheetData").toString()); - priQuote.setItemId(priQuoteBudget.getItemId()); - priQuote.setOrderNum(priQuoteBudget.getInOrderNum()); + priQuote.setPriOnlineId(Long.parseLong(map.get("priQuoteBudgetId").toString())); + priQuote.setItemId(priOnline2.getItemId()); + priQuote.setOrderNum(priOnline2.getOrderNum()); SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss"); priQuote.setInOrderNum(format.format(new Date())); - //鍒涘缓浜哄憳 - priQuote.setUserId(getUserId()); + //涓氬姟鍛� + Plan plan = planService.selectById(priQuote.getItemId()); + User userUp = userService.selectById(plan.getUserId()); + + //涓氬姟鍛� + priQuote.setUserId(userUp.getId()); //鏇存柊浜哄憳 priQuote.setUpdateUserId(getUserId()); //鎵�灞為儴闂� - priQuote.setDeptId(getDeptId()); + priQuote.setDeptId(userUp.getDeptId()); //鏇存柊鏃堕棿 priQuote.setUpdateTime(new Date()); + //妯℃澘 + priQuote.setTemplate(map.get("template").toString()); - //涓氬姟鍛� - Plan plan = planService.selectById(priQuote.getItemId()); - priQuote.setMemberId(plan.getUserId()); + priQuote.setPlanId(priOnline2.getPlanId()); + + //璁剧疆椤圭洰娴佺▼ plan.setStep(5); priQuote.setForm(JSON.toJSONString(map)); // 鑷畾涔夎〃鍗曞唴瀹� priQuote.setSettle(1); // 1.寮�濮� - User manager = userService.getDeptManager(getHostId(), getUser().getDeptId()); // 鑾峰彇閮ㄩ棬棰嗗 - ProcessPermissions processPermissions = processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 2).eq("process", 3));//2锛氭姤浠锋祦绋� - User president = userService.selectById(processPermissions.getUserId()); // 鑾峰彇鎶ヤ环娴佺▼鑺傜偣3纭浜� + User manager = new User(); + try{ + manager = userService.getDeptManager(getHostId(), userUp.getDeptId()); // 鑾峰彇閮ㄩ棬棰嗗 + }catch (Exception e){ + manager = userUp; + } + priQuote.setMemberId(manager.getId()); + ProcessPermissions processPermissions = processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 2).eq("process", "3-1"));//2锛氭姤浠锋祦绋� + User president = userService.selectById(processPermissions.getUserId()); // 鑾峰彇鎶ヤ环娴佺▼鑺傜偣3-1纭浜� priQuote.setSettleMsg(JSON.toJSONString(SettleDto.initPriQuote(plan, manager,president,getUser()))); planService.updateById(plan); @@ -164,7 +196,7 @@ } @RequestMapping(value = "/priQuote/addOther/auth") - @ManagerAuth + @ManagerAuth(memo = "鍙﹀瓨鎶ヤ环鍗�") public R addOther(@RequestBody Map<String,Object> map) { PriQuote quote = priQuoteService.selectById(Long.parseLong(map.get("id").toString())); @@ -195,7 +227,7 @@ } @RequestMapping(value = "/priQuote/update/auth") - @ManagerAuth + @ManagerAuth(memo = "鏇存柊鎶ヤ环鍗�") public R update(@RequestBody Map<String,Object> map){ PriQuote priQuote = priQuoteService.selectById(Long.parseLong(map.get("id").toString())); priQuote.setTitle(map.get("title").toString()); @@ -209,7 +241,7 @@ } @RequestMapping(value = "/priQuote/updateForm/auth") - @ManagerAuth + @ManagerAuth(memo = "鏇存柊鎶ヤ环鍗�") public R updateForm(Long id,String templateName,String title){ PriQuote priQuote = priQuoteService.selectById(id); priQuote.setTemplateName(templateName); @@ -223,7 +255,7 @@ } @RequestMapping(value = "/priQuote/delete/auth") - @ManagerAuth + @ManagerAuth(memo = "鍒犻櫎鎶ヤ环鍗�") public R delete(Long[] ids){ if (Cools.isEmpty(ids)){ return R.error(); @@ -248,7 +280,7 @@ public R query(String condition) { EntityWrapper<PriQuote> wrapper = new EntityWrapper<>(); wrapper.like("id", condition); - wrapper.in("member_id", getUserRoleBelongsToUserId()); + wrapper.in("user_id", getUserRoleBelongsToUserId()); Page<PriQuote> page = priQuoteService.selectPage(new Page<>(0, 10), wrapper); List<Map<String, Object>> result = new ArrayList<>(); for (PriQuote priQuote : page.getRecords()){ @@ -286,7 +318,7 @@ String path = ClassUtils.getDefaultClassLoader().getResource("excel").getPath(); String filename = format.format(new Date()) + ".xlsx"; String filepath = path + "/" + filename; - exportLuckySheetXlsx(path,"/" + filename,map.get("exceldata").toString()); + exportLuckySheetXlsx(path, "/" + filename, map.get("exceldata").toString(), map.get("template").toString()); return R.ok("/priQuote/excel/" + filename); } @@ -318,14 +350,14 @@ } } - public void exportLuckySheetXlsx(String newFileDir,String newFileName, String excelData) { + public void exportLuckySheetXlsx(String newFileDir, String newFileName, String excelData, String template) { //瑙f瀽瀵硅薄锛屽彲浠ュ弬鐓у畼鏂规枃妗�:https://mengshukeji.github.io/LuckysheetDocs/zh/guide/#%E6%95%B4%E4%BD%93%E7%BB%93%E6%9E%84 JSONArray jsonArray = (JSONArray) JSONObject.parse(excelData); //濡傛灉鍙湁涓�涓猻heet閭e氨鏄痝et(0),鏈夊涓偅灏卞搴斿彇涓嬫爣 JSONObject jsonObject = (JSONObject) jsonArray.get(0); JSONArray jsonObjectList = jsonObject.getJSONArray("celldata"); //excel妯℃澘璺緞 - String filePath = ClassUtils.getDefaultClassLoader().getResource("excel").getPath() + "/priQuoteTemplate.xlsx"; + String filePath = ClassUtils.getDefaultClassLoader().getResource("excel").getPath() + "/priQuoteTemplate/data" + template +".xlsx"; // String filePath = "/Users/ouyang/Downloads/uploadTestProductFile/鐢熶骇鏃ユ姤琛�.xlsx"; File file = new File(filePath); FileInputStream in = null; @@ -361,7 +393,7 @@ } String value = ""; - if (jsonObjectValue != null && jsonObjectValue.get("v") != null){ + if (jsonObjectValue != null && jsonObjectValue.get("v") != null) { //鑾峰彇鍗曞厓鏍煎�� value = jsonObjectValue.get("v").toString(); } @@ -369,11 +401,11 @@ if (Integer.parseInt(object.get("r").toString()) >= 4 && Integer.parseInt(object.get("r").toString()) <= 9) { if (Integer.parseInt(object.get("c").toString()) == 2 || Integer.parseInt(object.get("c").toString()) == 6) { //濉厖绗簩鍒楁暟鎹� - if (sheet.getRow((int) object.get("r")) !=null && sheet.getRow((int) object.get("r")).getCell((int) object.get("c")) != null){ + if (sheet.getRow((int) object.get("r")) != null && sheet.getRow((int) object.get("r")).getCell((int) object.get("c")) != null) { if (!value.equals("")) { sheet.getRow((int) object.get("r")).getCell((int) object.get("c")).setCellValue(value); } - }else{ + } else { System.out.println("閿欒鐨�=" + index + ">>>" + str_); } } @@ -393,11 +425,11 @@ case 3: case 4: case 5: - if (sheet.getRow((int) object.get("r")) !=null && sheet.getRow((int) object.get("r")).getCell((int) object.get("c")) != null){ + if (sheet.getRow((int) object.get("r")) != null && sheet.getRow((int) object.get("r")).getCell((int) object.get("c")) != null) { if (!value.equals("")) { sheet.getRow((int) object.get("r")).getCell((int) object.get("c")).setCellValue(value); } - }else{ + } else { System.out.println("閿欒鐨�=" + index + ">>>" + str_); } break; @@ -435,7 +467,12 @@ case 1: // 鏈儴闂ㄧ粡鐞嗗鏍� User user = userService.selectById(priQuote.getUserId()); - User manager = userService.getDeptManager(getHostId(), user.getDeptId()); + User manager = new User(); + try{ + manager = userService.getDeptManager(getHostId(), user.getDeptId()); // 鑾峰彇閮ㄩ棬棰嗗 + }catch (Exception e){ + manager = user; + } if (manager.getId().equals(getUserId())) { // 淇敼 settle 姝ラ鏁版嵁 @@ -447,7 +484,11 @@ break; case 2: dto.setCurr(Boolean.TRUE); - dto.setMsg("閮ㄩ棬缁忕悊" + manager.getNickname() + "瀹℃壒閫氳繃"); + if (Cools.isEmpty(dto.getMsg())){ + dto.setMsg("閮ㄩ棬缁忕悊" + manager.getNickname() + "瀹℃壒閫氳繃"); + }else { + dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(new Date())+" "+"閮ㄩ棬缁忕悊" + manager.getNickname() + "瀹℃壒閫氳繃"); + } dto.setTime(DateUtils.convert(new Date())); break; default: @@ -457,7 +498,10 @@ priQuote.setSettleMsg(JSON.toJSONString(list)); // 淇敼瑙勫垝鍗曠姸鎬� + ProcessPermissions processPermissions = processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 2).eq("process", "3-1"));//2锛氭姤浠锋祦绋� + User planLeader = userService.selectById(processPermissions.getUserId()); // 鑾峰彇鎶ヤ环娴佺▼鑺傜偣3纭浜� priQuote.setSettle(2); // 鎬昏鍔炲緟瀹� + priQuote.setMemberId(planLeader.getId()); priQuote.setUpdateUserId(getUserId()); priQuote.setUpdateTime(new Date()); @@ -470,11 +514,10 @@ } break; case 2: - // 鏌ユ壘瑙勫垝缁勯暱 - ProcessPermissions processPermissions = processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 2).eq("process", 3));//2锛氭姤浠锋祦绋� + ProcessPermissions processPermissions = processPermissionsService.selectOne(new EntityWrapper<ProcessPermissions>().eq("process_memo", 2).eq("process", "3-1"));//2锛氭姤浠锋祦绋� User planLeader = userService.selectById(processPermissions.getUserId()); // 鑾峰彇鎶ヤ环娴佺▼鑺傜偣3纭浜� if (Cools.isEmpty(planLeader)) { - throw new CoolException("鏈煡鎵惧埌鎶ヤ环娴佺▼鑺傜偣3纭浜猴紝璇疯仈绯诲湪瀹℃壒鏉冮檺娣诲姞纭浜猴紒"); + throw new CoolException("鏈煡鎵惧埌鎶ヤ环娴佺▼鑺傜偣3-1纭浜猴紝璇疯仈绯诲湪瀹℃壒鏉冮檺娣诲姞纭浜猴紒"); } if (!getUserId().equals(planLeader.getId())) { return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�"); @@ -489,7 +532,11 @@ break; case 3: dto.setCurr(Boolean.TRUE); - dto.setMsg("鎬昏鍔�" + planLeader.getNickname() + "瀹℃壒閫氳繃"); + 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; default: @@ -500,6 +547,7 @@ // 淇敼瑙勫垝鍗曠姸鎬� priQuote.setSettle(3); // 瑙勫垝鍛樺緟瀹� priQuote.setUpdateUserId(getUserId()); + priQuote.setMemberId(priQuote.getUserId()); priQuote.setUpdateTime(new Date()); if (!priQuoteService.updateById(priQuote)) { @@ -521,7 +569,11 @@ break; case 4: dto.setCurr(Boolean.TRUE); - dto.setMsg("涓氬姟鍛�" + salesman0.getNickname() + "瀹℃壒閫氳繃"); + 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: @@ -548,119 +600,44 @@ @ManagerAuth public R refusePriQuote(@RequestParam Long planId, @RequestParam(required = false) Long plannerId){ -// PriQuote priQuote = priQuoteService.selectById(planId); -// assert priQuote != null; -// -// switch (priQuote.getSettle()) { -// case 1: -// // 鏈儴闂ㄧ粡鐞嗗鏍� -// User user = userService.selectById(priQuote.getUserId()); -// User manager = userService.getDeptManager(getHostId(), user.getDeptId()); -// if (manager.getId().equals(getUserId())) { -// -// // 淇敼 settle 姝ラ鏁版嵁 -// List<SettleDto> list = JSON.parseArray(priQuote.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; -// default: -// break; -// } -// } -// priQuote.setSettleMsg(JSON.toJSONString(list)); -// -// // 淇敼瑙勫垝鍗曠姸鎬� -// priQuote.setSettle(2); // 鎬昏鍔炲緟瀹� -// priQuote.setUpdateUserId(getUserId()); -// priQuote.setUpdateTime(new Date()); -// -// if (!priQuoteService.updateById(priQuote)) { -// throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�"); -// } -// -// } else { -// return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�"); -// } -// break; -// case 2: -// // 鏌ユ壘瑙勫垝缁勯暱 -// User planLeader = userService.selectOne(new EntityWrapper<User>().eq("username","鐜嬪紑鏉�")); -// if (Cools.isEmpty(planLeader)) { -// throw new CoolException("鏈煡鎵炬�昏鍔烇紝璇疯仈绯荤鐞嗗憳"); -// } -// if (!getUserId().equals(planLeader.getId())) { -// return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�"); -// } -// User planner = userService.selectById(plannerId); -// // 淇敼 settle 姝ラ鏁版嵁 -// List<SettleDto> list = JSON.parseArray(priQuote.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; -// default: -// break; -// } -// } -// priQuote.setSettleMsg(JSON.toJSONString(list)); -// // 淇敼瑙勫垝鍗曠姸鎬� -// priQuote.setSettle(3); // 瑙勫垝鍛樺緟瀹� -// priQuote.setUpdateUserId(getUserId()); -// priQuote.setUpdateTime(new Date()); -// -// if (!priQuoteService.updateById(priQuote)) { -// throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�"); -// } -// break; -// case 3: -// // 涓氬姟鍛� -// User salesman0 = userService.selectById(priQuote.getUserId()); -// if (!getUserId().equals(salesman0.getId())) { -// return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�"); -// } -// // 淇敼 settle 姝ラ鏁版嵁 -// List<SettleDto> list1 = JSON.parseArray(priQuote.getSettleMsg(), SettleDto.class); -// for (SettleDto dto : list1) { -// switch (dto.getStep()) { -// case 3: -// dto.setCurr(Boolean.TRUE); -// break; -// case 4: -// dto.setCurr(Boolean.TRUE); -// dto.setMsg("涓氬姟鍛�" + salesman0.getNickname() + "瀹℃壒閫氳繃"); -// dto.setTime(DateUtils.convert(new Date())); -// break; -// default: -// break; -// } -// } -// priQuote.setSettleMsg(JSON.toJSONString(list1)); -// // 淇敼瑙勫垝鍗曠姸鎬� -// priQuote.setSettle(4); // 瀹℃壒閫氳繃 -// priQuote.setUpdateUserId(getUserId()); -// priQuote.setUpdateTime(new Date()); -// -// if (!priQuoteService.updateById(priQuote)) { -// throw new CoolException("瀹℃牳澶辫触锛岃鑱旂郴绠$悊鍛�"); -// } -// break; -// default: -// return R.error(); -// } - return R.ok("瀹℃壒鎴愬姛"); + + PriQuote priQuote = priQuoteService.selectById(planId); + + Date now = new Date(); + Long memberId = priQuote.getMemberId(); + User member = userService.selectById(memberId); + if (!member.getId().equals(getUserId())){ + return R.error("鎶辨瓑锛屾偍娌℃湁瀹℃牳鐨勬潈闄�"); + } + List<SettleDto> planDtos = JSON.parseArray(priQuote.getSettleMsg(), SettleDto.class); + List<SettleDto> planDtoList = new ArrayList<>(); + boolean sign = true; + for (SettleDto dto : planDtos) { + if (dto.getStep().equals(2)){ + priQuote.setMemberId(dto.getUserId()); + } + if (sign && dto.getUserId().equals(memberId) && priQuote.getSettle()+1==dto.getStep()){ + if (Cools.isEmpty(dto.getMsg())){ + dto.setMsg(DateUtils.convert(now)+" "+member.getNickname()+"鍥為��瀹℃壒"); + }else { + dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(now)+" "+member.getNickname()+"鍥為��瀹℃壒"); + } + sign = false; + } + if (sign){ + dto.setMsg(dto.getMsg()+PZH+DateUtils.convert(now)+" "+member.getNickname()+"鍥為��瀹℃壒"); + } + + planDtoList.add(dto); + } + + priQuote.setSettle(1); + priQuote.setUpdateUserId(getUserId()); + priQuote.setUpdateTime(now); + + priQuote.setSettleMsg(JSON.toJSONString(planDtoList)); + priQuoteService.updateById(priQuote); + return R.ok("鍥為��鎴愬姛"); } } -- Gitblit v1.9.1