KabeiyiServiceImpl.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492
  1. package com.malk.kabeiyi.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.malk.core.McProject;
  6. import com.malk.kabeiyi.service.KabeiyiService;
  7. import com.malk.kabeiyi.util.RecognizeAllText;
  8. import com.malk.kabeiyi.util.U8Util;
  9. import com.malk.server.aliwork.YDConf;
  10. import com.malk.server.aliwork.YDParam;
  11. import com.malk.server.common.McR;
  12. import com.malk.server.dingtalk.DDConf;
  13. import com.malk.server.dingtalk.DDR;
  14. import com.malk.server.dingtalk.DDR_New;
  15. import com.malk.service.aliwork.YDClient;
  16. import com.malk.service.aliwork.YDService;
  17. import com.malk.service.dingtalk.DDClient;
  18. import com.malk.service.dingtalk.DDClient_Workflow;
  19. import com.malk.utils.PublicUtil;
  20. import com.malk.utils.UtilHttp;
  21. import com.malk.utils.UtilToken;
  22. import lombok.extern.slf4j.Slf4j;
  23. import org.apache.commons.lang3.StringUtils;
  24. import org.apache.commons.lang3.time.DateUtils;
  25. import org.apache.logging.log4j.util.Strings;
  26. import org.slf4j.MDC;
  27. import org.springframework.beans.factory.annotation.Autowired;
  28. import org.springframework.beans.factory.annotation.Value;
  29. import org.springframework.scheduling.annotation.Async;
  30. import org.springframework.stereotype.Service;
  31. import java.util.*;
  32. @Slf4j
  33. @Service
  34. public class KabeiyiServiceImpl implements KabeiyiService {
  35. @Autowired
  36. private DDClient_Workflow ddClient_workflow;
  37. @Autowired
  38. private DDClient ddClient;
  39. @Autowired
  40. private YDService ydService;
  41. @Autowired
  42. private YDClient ydClient;
  43. @Autowired
  44. private DDConf ddConf;
  45. @Value("${tcdingtalk.appKey}")
  46. private String appKey;
  47. @Value("${tcdingtalk.appSecret}")
  48. private String appSecret;
  49. @Value("${aliwork.accessKeyId}")
  50. private String accessKeyId;
  51. @Value("${aliwork.accessKeySecret}")
  52. private String accessKeySecret;
  53. //审批实例url前缀(卡倍亿)
  54. private static final String PROC_INST_PREFIX_URL = "https://aflow.dingtalk.com/dingtalk/web/query/pchomepage.htm?from=oflow&op=true&corpid=dingc3a744cb591a7346f2c783f7214b6d69#/plainapproval?procInstId=";
  55. //宜搭-关联数据(卡倍亿)
  56. private static final String RELATION = "FORM-230C40137ED94524B4D4C94F8B23A8D2F8PF";
  57. //审批实例url前缀(特充)
  58. private static final String PROC_INST_PREFIX_URL2 = "https://aflow.dingtalk.com/dingtalk/web/query/pchomepage.htm?from=oflow&op=true&corpid=ding3ea249a3b5b466d0f2c783f7214b6d69#/plainapproval?procInstId=";
  59. //宜搭-关联数据(特充)
  60. private static final String RELATION2 = "FORM-51E17EFB52C14C9CB9E00168FED2BC18LQ6H";
  61. //问题整改表
  62. private static final String QUESTION = "FORM-89F515967FF94C62A9031F28EF6000B1YV5Q";
  63. //问题整改表流程code
  64. private static final String QUESTION_PROC_CODE = "TPROC--DP5660A1LEXNP1S37P7KU9GCHD5U3HB6C360M5";
  65. //审核表
  66. private static final String CHECK = "FORM-F4ED246EADD8427381BC13C4F0FEF7FDYMKJ";
  67. //审核表流程code
  68. private static final String CHECK_PROC_CODE = "TPROC--4XC66Y61XWWNZNJKBZD4VAB5BQAJ2YANX160M5";
  69. //关联表单(卡倍亿)
  70. private static final Map<String,String> SCHEMA_MAP = new HashMap<>();
  71. static{
  72. SCHEMA_MAP.put("工厂用章流程","1.1、工厂用章流程(除采购营销人事)");
  73. SCHEMA_MAP.put("中心用章流程","1.2、中心用章流程(除采购营销人事)");
  74. SCHEMA_MAP.put("人事专用用章审批流程","1.3、人事专用用章审批流程");
  75. SCHEMA_MAP.put("商务部用章申请流程","1.4、商务部用章申请流程");
  76. SCHEMA_MAP.put("办公用品采购申请流程","4.3、办公用品采购申请流程");
  77. //需传其他值
  78. //对方单位名称 收入或支出 金额 备注
  79. SCHEMA_MAP.put("信息化建设用章流程","1.7、信息化建设用章流程");
  80. //合同说明 采购物品类型
  81. SCHEMA_MAP.put("技术中心请购审批流程","4.10、技术中心请购审批流程");
  82. //合同总金额 合同说明
  83. SCHEMA_MAP.put("设备备品备件采购合同审批流程","4.1b、设备备品备件采购合同审批流程");
  84. SCHEMA_MAP.put("其他物品采购合同流程","4.2b、其他物品采购合同流程");
  85. SCHEMA_MAP.put("设备采购合同审批流程","4.5c、设备采购合同审批流程");
  86. SCHEMA_MAP.put("原材料采购合同审批流程","4.9b、原材料采购合同审批流程");
  87. SCHEMA_MAP.put("墨西哥采购合同审批流程","4.13b、墨西哥采购合同审批流程");
  88. }
  89. //关联表单(特充)
  90. private static final Map<String,String> SCHEMA_MAP2 = new HashMap<>();
  91. static{
  92. //需传其他值
  93. //对方单位名称 收入或支出 金额 备注
  94. SCHEMA_MAP2.put("特充用章流程","1.2、特充用章流程(除采购营销人事)");
  95. //合同总金额 合同说明
  96. SCHEMA_MAP2.put("设备备品备件采购合同审批流程","4.1b、设备备品备件采购合同审批流程");
  97. SCHEMA_MAP2.put("其他物品采购合同流程","4.2b、其他物品采购合同流程");
  98. SCHEMA_MAP2.put("母排设备采购合同审批流程","4.5c、母排设备采购合同审批流程");
  99. SCHEMA_MAP2.put("双铝设备采购合同审批流程","4.6c、双铝设备采购合同审批流程");
  100. //合同总金额
  101. SCHEMA_MAP2.put("原材料采购合同审批流程","4.9b、原材料采购合同审批流程");
  102. //文件类别 对方单位名称 收入或支出 金额 用印文件名称 文件份数 加盖何种印章 备注
  103. SCHEMA_MAP2.put("信息化建设用章流程","1.7、信息化建设用章流程");
  104. }
  105. @Override
  106. public McR addPayment(Map map) {
  107. try {
  108. String tradeid = U8Util.getTradeid();
  109. map.put("tradeid",tradeid);
  110. U8Util.sendPost(map,"https://api.yonyouup.com/api/voucher/add","voucher");
  111. }catch (Exception e) {
  112. return McR.errorUnknown(e.getMessage());
  113. }
  114. return McR.success();
  115. }
  116. @Override
  117. public McR pushProcInstToYD(Map map) {
  118. MDC.put("MDC_KEY_PID","1002");
  119. //审批实例
  120. String procInstId = String.valueOf(map.get("procInstId"));
  121. //获取审批实例信息
  122. Map processInstance = ddClient_workflow.getProcessInstanceId(ddClient.getAccessToken(), procInstId);
  123. if (Objects.nonNull(processInstance)){
  124. Map formData = new HashMap<>();
  125. String title = String.valueOf(processInstance.get("title"));
  126. String type = "";
  127. List<Map> formComponentValues = (List<Map>) processInstance.get("formComponentValues");
  128. for (String key : SCHEMA_MAP.keySet()) {
  129. if (title.contains(key)){
  130. type = SCHEMA_MAP.get(key);
  131. switch (type){
  132. case "1.7、信息化建设用章流程" :
  133. for (Map formComponentValue : formComponentValues) {
  134. String name = String.valueOf(formComponentValue.get("name"));
  135. String value = String.valueOf(formComponentValue.get("value")).equals("null") ? "" : String.valueOf(formComponentValue.get("value"));
  136. switch (name){
  137. case "对方单位名称" : formData.put("textField_lygzlf3j",value);break;
  138. case "收入或支出" : formData.put("textField_lygzlf3k",value);break;
  139. case "金额" : formData.put("textField_lygzlf3l",value);break;
  140. case "备注" : formData.put("textField_lygzlf3m",value);break;
  141. }
  142. }
  143. break;
  144. case "4.1b、设备备品备件采购合同审批流程" :
  145. case "4.2b、其他物品采购合同流程" :
  146. case "4.5c、设备采购合同审批流程" :
  147. case "4.9b、原材料采购合同审批流程" :
  148. case "4.13b、墨西哥采购合同审批流程" :
  149. for (Map formComponentValue : formComponentValues) {
  150. String name = String.valueOf(formComponentValue.get("name"));
  151. switch (name){
  152. case "合同总金额" : formData.put("numberField_lyf81587",formComponentValue.get("value"));break;
  153. case "合同说明" :
  154. if (Objects.nonNull(formComponentValue.get("value"))){
  155. formData.put("textField_lyf81588",formComponentValue.get("value"));
  156. }
  157. break;
  158. }
  159. }
  160. break;
  161. case "4.10、技术中心请购审批流程" :
  162. for (Map formComponentValue : formComponentValues) {
  163. String name = String.valueOf(formComponentValue.get("name"));
  164. switch (name){
  165. case "采购物品类型" : formData.put("textField_lyibvb98",formComponentValue.get("value"));break;
  166. case "合同说明" :
  167. if (Objects.nonNull(formComponentValue.get("value"))){
  168. formData.put("textField_lyf81588",formComponentValue.get("value"));
  169. }
  170. break;
  171. }
  172. }
  173. break;
  174. default:
  175. break;
  176. }
  177. formData.put("textField_lyf8157x",title);
  178. formData.put("selectField_lyf81580",type);
  179. Map condition = new HashMap<>();
  180. condition.put("textField_lyf81581",PROC_INST_PREFIX_URL + procInstId);
  181. //同步到宜搭
  182. ydService.upsertFormData(RELATION,condition,formData,null);
  183. break;
  184. }
  185. }
  186. return McR.success();
  187. }
  188. return McR.errorParam("审批实例不存在!");
  189. }
  190. @Override
  191. public McR pushProcInstToYD2(Map map) {
  192. MDC.put("MDC_KEY_PID","1003");
  193. //审批实例
  194. String procInstId = String.valueOf(map.get("procInstId"));
  195. //获取审批实例信息
  196. Map processInstance = ddClient_workflow.getProcessInstanceId(getTcAccessToken(), procInstId);
  197. if (Objects.nonNull(processInstance)){
  198. Map formData = new HashMap<>();
  199. String title = String.valueOf(processInstance.get("title"));
  200. String type = "";
  201. List<Map> formComponentValues = (List<Map>) processInstance.get("formComponentValues");
  202. for (String key : SCHEMA_MAP2.keySet()) {
  203. if (title.contains(key)){
  204. type = SCHEMA_MAP2.get(key);
  205. switch (type){
  206. case "1.7、信息化建设用章流程" :
  207. for (Map formComponentValue : formComponentValues) {
  208. String name = String.valueOf(formComponentValue.get("name"));
  209. Object value = formComponentValue.get("value");
  210. switch (name){
  211. case "文件类别" : formData.put("textField_lymfq9oa",value);break;
  212. case "对方单位名称" : formData.put("textField_lygzlf3j",value);break;
  213. case "收入或支出" : formData.put("textField_lygzlf3k",value);break;
  214. case "金额(元)" : formData.put("textField_lygzlf3l",value);break;
  215. case "用印文件名称" : formData.put("textField_lymfq9oc",value);break;
  216. case "文件份数" : formData.put("numberField_lymfq9od",value);break;
  217. case "加盖何种印章" : formData.put("textField_lymfq9oe",value);break;
  218. case "备注" : formData.put("textField_lygzlf3m",value);break;
  219. }
  220. }
  221. break;
  222. case "4.1b、设备备品备件采购合同审批流程" :
  223. case "4.2b、其他物品采购合同流程" :
  224. case "4.5c、母排设备采购合同审批流程" :
  225. case "4.6c、双铝设备采购合同审批流程" :
  226. case "4.9b、原材料采购合同审批流程" :
  227. for (Map formComponentValue : formComponentValues) {
  228. String name = String.valueOf(formComponentValue.get("name"));
  229. switch (name){
  230. case "合同总金额(元)":
  231. case "合同总金额" : formData.put("numberField_lyf81587",formComponentValue.get("value"));break;
  232. case "合同说明" :
  233. if (Objects.nonNull(formComponentValue.get("value"))){
  234. formData.put("textField_lyf81588",formComponentValue.get("value"));
  235. }
  236. break;
  237. }
  238. }
  239. break;
  240. case "1.2、特充用章流程(除采购营销人事)" :
  241. for (Map formComponentValue : formComponentValues) {
  242. String name = String.valueOf(formComponentValue.get("name"));
  243. String value = String.valueOf(formComponentValue.get("value")).equals("null") ? "" : String.valueOf(formComponentValue.get("value"));
  244. switch (name){
  245. case "对方单位名称" : formData.put("textField_lygzlf3j",value);break;
  246. case "收入或支出" : formData.put("textField_lygzlf3k",value);break;
  247. case "金额(元)" : formData.put("textField_lygzlf3l",value);break;
  248. case "备注" : formData.put("textField_lygzlf3m",value);break;
  249. }
  250. }
  251. break;
  252. default:
  253. break;
  254. }
  255. formData.put("textField_lyf8157x",title);
  256. formData.put("selectField_lyf81580",type);
  257. Map condition = new HashMap<>();
  258. condition.put("textField_lyf81581",PROC_INST_PREFIX_URL2 + procInstId);
  259. //同步到宜搭
  260. ydService.upsertFormData(RELATION2,condition,formData,null);
  261. break;
  262. }
  263. }
  264. return McR.success();
  265. }
  266. return McR.errorParam("审批实例不存在!");
  267. }
  268. @Override
  269. public McR addQuestionApproval(Map map) {
  270. MDC.put("MDC_KEY_PID","1009");
  271. if (Objects.isNull(map.get("formInstId"))){
  272. return McR.errorParam("formInstId不能为空!");
  273. }
  274. String formInstId = map.get("formInstId").toString();
  275. DDR_New ddrNew = ydClient.queryData(YDParam.builder()
  276. .formInstId(formInstId)
  277. .build(), YDConf.FORM_QUERY.retrieve_id);
  278. Map formData = ddrNew.getFormData();
  279. //审核人
  280. List<String> reviewerUserIds = (List<String>) formData.get("employeeField_m061zye5_id");
  281. List<Map> details = (List<Map>) formData.get("tableField_m0kqtqoy");
  282. String[] yida = McProject.getYida("1009");
  283. for (Map detail : details) {
  284. String result = detail.get("radioField_m0nm3des").toString();
  285. if ("NG".equals(result)){
  286. //发起问题整改审批
  287. Map question = new HashMap();
  288. question.put("textField_m061zye8",detail.get("textField_m0on13ob"));//审核项目
  289. question.put("textareaField_m061zye9",detail.get("textField_m0kqtqoz"));//审核方法和标准
  290. question.put("attachmentField_m061zyep",detail.get("attachmentField_m061zyep"));//问题证据
  291. question.put("textareaField_m063drgz",detail.get("textareaField_m063drgz"));//问题描述
  292. question.put("dateField_m061zyev",detail.get("dateField_m061zyev"));//整改截止时间
  293. //根据userId获取部门id
  294. List<String> rectificationUserIds = (List<String>) detail.get("employeeField_m061zyeq_id");
  295. question.put("employeeField_m061zyeq",rectificationUserIds);//责任整改人
  296. Map body2 = new HashMap<>();
  297. body2.put("userid", rectificationUserIds.get(0));
  298. DDR_New ddrNew1 = (DDR_New) UtilHttp.doPost("https://oapi.dingtalk.com/topapi/v2/department/listparentbyuser", null, ddClient.initTokenParams(), body2, DDR_New.class);
  299. Map result2 = (Map) ddrNew1.getResult();
  300. List<Map> parentList = (List<Map>) result2.get("parent_list");
  301. List<Long> parentDeptIdList = (List<Long>) parentList.get(0).get("parent_dept_id_list");
  302. String deptId = parentDeptIdList.get(0) + "";
  303. question.put("departmentSelectField_m0p0tbyo",new String[]{deptId});//部门
  304. Map<String,Object> body = new HashMap<>();
  305. body.put("appType",yida[0]);
  306. body.put("systemToken",yida[1]);
  307. body.put("userId",reviewerUserIds.get(0));
  308. body.put("formUuid",QUESTION);
  309. body.put("processCode",QUESTION_PROC_CODE);
  310. body.put("formDataJson", JSONObject.toJSONString(question));
  311. UtilHttp.doPost("https://api.dingtalk.com/v1.0/yida/processes/instances/start", ddClient.initTokenHeader(), null, body, DDR_New.class);
  312. }
  313. }
  314. return McR.success();
  315. }
  316. @Override
  317. public McR ocr() {
  318. try {
  319. String content = RecognizeAllText.recognizeText("C:\\Users\\EDY\\Desktop\\3.jpg","Table",accessKeyId,accessKeySecret);
  320. return McR.success(content);
  321. }catch (Exception e){
  322. System.out.println(e.getMessage());
  323. }
  324. return McR.errorUnknown("识别失败!");
  325. }
  326. @Override
  327. public McR addPlanApproval(Map map) {
  328. MDC.put("MDC_KEY_PID","1009");
  329. if (Objects.isNull(map.get("formInstId"))){
  330. return McR.errorParam("formInstId不能为空!");
  331. }
  332. String formInstId = map.get("formInstId").toString();
  333. DDR_New ddrNew = ydClient.queryData(YDParam.builder()
  334. .formInstId(formInstId)
  335. .build(), YDConf.FORM_QUERY.retrieve_id);
  336. //计划制定人
  337. Map originator = ddrNew.getOriginator();
  338. String planUserId = originator.get("userId").toString();
  339. Map formData = ddrNew.getFormData();
  340. //审核人
  341. List<String> reviewerUserIds = (List<String>) formData.get("employeeField_m061zye5_id");
  342. //频次
  343. String frequency = formData.get("selectField_m0koxj7g").toString();
  344. //下次自动发起审核日期
  345. long nextTime = (long) formData.get("dateField_m0nbpasq");
  346. Date nextDate = new Date(nextTime);
  347. //上次自动发起审核日期
  348. Date lastTime = nextDate;
  349. //审核截至日期
  350. Date endDate = new Date();
  351. switch (frequency){
  352. case "每周":
  353. endDate = DateUtils.addDays(nextDate, 6);
  354. nextDate = DateUtils.addDays(nextDate, 7);
  355. break;
  356. case "每两周":
  357. endDate = DateUtils.addDays(nextDate, 13);
  358. nextDate = DateUtils.addDays(nextDate, 14);
  359. break;
  360. case "每月":
  361. endDate = DateUtils.addDays(DateUtils.addMonths(nextDate, 1), -1);
  362. nextDate = DateUtils.addMonths(nextDate, 1);
  363. break;
  364. case "每季度":
  365. endDate = DateUtils.addDays(DateUtils.addMonths(nextDate, 3),-1);
  366. nextDate = DateUtils.addMonths(nextDate, 3);
  367. break;
  368. case "一次":
  369. endDate = new Date((long)formData.get("dateField_m0oqbh48"));
  370. nextDate = null;
  371. break;
  372. default:break;
  373. }
  374. //每个审批人发起审批
  375. for (String reviewerUserId : reviewerUserIds) {
  376. //根据userId获取部门id
  377. Map body = new HashMap<>();
  378. body.put("userid", reviewerUserId);
  379. DDR_New ddrNew1 = (DDR_New) UtilHttp.doPost("https://oapi.dingtalk.com/topapi/v2/department/listparentbyuser", null, ddClient.initTokenParams(), body, DDR_New.class);
  380. Map result = (Map) ddrNew1.getResult();
  381. List<Map> parentList = (List<Map>) result.get("parent_list");
  382. List<Long> parentDeptIdList = (List<Long>) parentList.get(0).get("parent_dept_id_list");
  383. String deptId = parentDeptIdList.get(0) + "";
  384. formData.put("departmentSelectField_m0c3qbjn", new String[]{deptId});
  385. formData.put("dateField_m061zye7", endDate.getTime());
  386. formData.put("employeeField_m061zye5",new String[]{reviewerUserId});
  387. //发起审批
  388. String[] yida = McProject.getYida("1009");
  389. Map<String,Object> body2 = new HashMap<>();
  390. body2.put("appType",yida[0]);
  391. body2.put("systemToken",yida[1]);
  392. body2.put("userId",planUserId);
  393. body2.put("formUuid",CHECK);
  394. body2.put("processCode",CHECK_PROC_CODE);
  395. body2.put("formDataJson", JSONObject.toJSONString(formData));
  396. UtilHttp.doPost("https://api.dingtalk.com/v1.0/yida/processes/instances/start", ddClient.initTokenHeader(), null, body2, DDR_New.class);
  397. }
  398. //更新审核计划下次发起审批时间及上次发起审批时间
  399. formData.put("dateField_m0nbpasw", lastTime);
  400. formData.put("dateField_m0nbpasq", nextDate);
  401. ydClient.operateData(YDParam.builder()
  402. .formInstId(formInstId)
  403. .updateFormDataJson(JSON.toJSONString(formData))
  404. .build(), YDConf.FORM_OPERATION.update);
  405. return McR.success();
  406. }
  407. private String getString(Object obj){
  408. return obj == null ? "" : obj.toString();
  409. }
  410. public String getTcAccessToken() {
  411. String accessToken = UtilToken.get("tc-invalid-token-dingtalk");
  412. if (StringUtils.isNotBlank(accessToken)) {
  413. return accessToken;
  414. } else {
  415. Map param = new HashMap();
  416. param.put("appkey", appKey);
  417. param.put("appsecret", appSecret);
  418. DDR r = (DDR)UtilHttp.doGet("https://oapi.dingtalk.com/gettoken", param, DDR.class);
  419. log.info("特充响应token, {}", r.getAccessToken());
  420. accessToken = r.getAccessToken();
  421. UtilToken.put("tc-invalid-token-dingtalk", accessToken, (long)r.getExpiresIn() * 1000L);
  422. return accessToken;
  423. }
  424. }
  425. }