From c68e3da8e41b171755a99a5c877b5df1d391ddd9 Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期五, 30 六月 2023 11:42:22 +0800 Subject: [PATCH] 将数据分享给财务 --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java | 460 ++++++++++++++++++++++++++++----------------------------- 1 files changed, 224 insertions(+), 236 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java index 5e66e85..af24cf9 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java @@ -195,18 +195,6 @@ } /** - * 寰�service_reimbursement_share,寰�service_reimbursementdetail_share,寰�service_reimbursementpyee_share鏂板澶囦唤鏁版嵁 - * - * @param id - * @return - */ - @GetMapping("/addShareData/{id}") - public AjaxResult addSharedData(@PathVariable("id") Long id) { - - return AjaxResult.success(serviceReimbursementService.addSharedData(id)); - } - - /** * 鏂板鎶ラ攢鐢宠 */ @ApiOperation("鏂板鎶ラ攢鐢宠") @@ -225,229 +213,229 @@ return AjaxResult.success(id); } - public int addReiSharedDatd(ServiceReimbursement serviceReimbursement, int nType) { - //remShare = ; - ServiceReimbursementShared remShare = new ServiceReimbursementShared(); - if (nType == 1) { - // remShare = new ServiceReimbursementShared(); - remShare.setReimid(serviceReimbursement.getId()); - } else //modify - { - List<ServiceReimbursementShared> remlist = serviceReimbursementServiceShare.getRemShareInfoByRemId(serviceReimbursement.getId()); - if (!CollectionUtils.isEmpty(remlist)) remShare = remlist.get(0); - } - - remShare.setUserno(serviceReimbursement.getUserno()); - remShare.setUsername(serviceReimbursement.getUsername()); - remShare.setTravelers(serviceReimbursement.getTravelers()); - remShare.setIdcardtype(serviceReimbursement.getIdcardtype()); - remShare.setIdcardno(serviceReimbursement.getIdcardno()); - remShare.setPhone(serviceReimbursement.getPhone()); - remShare.setDepositbank(serviceReimbursement.getDepositbank()); - remShare.setBankcardno(serviceReimbursement.getBankcardno()); - remShare.setBranchbankname(serviceReimbursement.getBranchbankname()); - remShare.setAnnexbankcard(serviceReimbursement.getAnnexbankcard()); - remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); - //remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); - // remShare.setAmountrequested(BigDecimal.valueOf(serviceReimbursement.getAmountrequested())); - - Double nTemp = serviceReimbursement.getAmountrequested(); - if (nTemp == null) nTemp = 0d; - remShare.setAmountrequested(BigDecimal.valueOf(nTemp)); - - nTemp = serviceReimbursement.getPrepaidamount(); - if (nTemp == null) nTemp = 0.0; - remShare.setPrepaidamount(BigDecimal.valueOf(nTemp)); - - remShare.setInvoicecount(serviceReimbursement.getInvoicecount()); - remShare.setAttachcount(serviceReimbursement.getAttachcount()); - remShare.setManagerno(serviceReimbursement.getManagerno()); - remShare.setManagername(serviceReimbursement.getManagername()); - remShare.setDeptmentno(serviceReimbursement.getDeptmentno()); - remShare.setDeptmentname(serviceReimbursement.getDeptmentname()); - remShare.setOpochecker(serviceReimbursement.getOpochecker()); - remShare.setFinvicepresident(serviceReimbursement.getFinvicepresident()); - remShare.setBusvicepresident(serviceReimbursement.getBusvicepresident()); - remShare.setOfficedirector(serviceReimbursement.getOfficedirector()); - remShare.setFinancedirector(serviceReimbursement.getFinancedirector()); - remShare.setFinancechecher(serviceReimbursement.getFinancechecher()); - remShare.setInfoid(serviceReimbursement.getInfoid()); - remShare.setDonorno(serviceReimbursement.getDonorno()); - - remShare.setDonorname(serviceReimbursement.getDonorname()); - remShare.setReason(serviceReimbursement.getReason()); - remShare.setRecordstatus(serviceReimbursement.getRecordstatus()); - remShare.setUploadflag(serviceReimbursement.getUploadflag()); - remShare.setUploadtime(serviceReimbursement.getUploadtime()); - - nTemp = serviceReimbursement.getTotalamount(); - if (nTemp == null) nTemp = 0.0; - remShare.setTotalamount(BigDecimal.valueOf(nTemp)); - - remShare.setBigstrmoney(serviceReimbursement.getBigstrmoney()); - remShare.setFlowlevel(serviceReimbursement.getFlowlevel()); - remShare.setCosttype(serviceReimbursement.getCosttype()); - remShare.setCosttypename(serviceReimbursement.getCosttypename()); - remShare.setFileurl(serviceReimbursement.getAnnexfiles()); - remShare.setDonorbank(serviceReimbursement.getDonorbank()); - remShare.setDonorbankcard(serviceReimbursement.getDonorbankcard()); - remShare.setDonorremark(serviceReimbursement.getDonorremark()); - - nTemp = serviceReimbursement.getDonoramount(); - if (nTemp == null) nTemp = 0.0; - remShare.setDonoramount(nTemp); - remShare.setDonorrelatives(serviceReimbursement.getDonorrelatives()); - //remShare.setOaid(serviceReimbursement.getOaid()); - //remShare.setDonorno(serviceReimbursement.getDonorno()); - - boolean bRet = false; - if (nType == 1) { - bRet = serviceReimbursementServiceShare.save(remShare); - } else { - //remShare.setId(serviceReimbursement.); - bRet = serviceReimbursementServiceShare.updateById(remShare); - } - - //if(!bRet) return -1; - String strMutfileUrl = remShare.getFileurl(); - //鏈夐檮浠舵椂鎵嶈皟鐢ㄧ涓夋柟杩涜涓婁紶 - if (strMutfileUrl == null) return 0; - if (strMutfileUrl.isEmpty()) return 0; - - try { - uploadOAFileAndUpdateDb(remShare); - } catch (Exception e) { - logger.error("璋冪敤绗笁鏂规帴鍙e嚭閿�!"); - e.printStackTrace(); - } - - //姝ゅ淇濆瓨鎴愬姛鍚庤涓婁紶OA锛屼繚瀛樿繑鍥炲�� - - return 0; - } +// public int addReiSharedDatd(ServiceReimbursement serviceReimbursement, int nType) { +// //remShare = ; +// ServiceReimbursementShared remShare = new ServiceReimbursementShared(); +// if (nType == 1) { +// // remShare = new ServiceReimbursementShared(); +// remShare.setReimid(serviceReimbursement.getId()); +// } else //modify +// { +// List<ServiceReimbursementShared> remlist = serviceReimbursementServiceShare.getRemShareInfoByRemId(serviceReimbursement.getId()); +// if (!CollectionUtils.isEmpty(remlist)) remShare = remlist.get(0); +// } +// +// remShare.setUserno(serviceReimbursement.getUserno()); +// remShare.setUsername(serviceReimbursement.getUsername()); +// remShare.setTravelers(serviceReimbursement.getTravelers()); +// remShare.setIdcardtype(serviceReimbursement.getIdcardtype()); +// remShare.setIdcardno(serviceReimbursement.getIdcardno()); +// remShare.setPhone(serviceReimbursement.getPhone()); +// remShare.setDepositbank(serviceReimbursement.getDepositbank()); +// remShare.setBankcardno(serviceReimbursement.getBankcardno()); +// remShare.setBranchbankname(serviceReimbursement.getBranchbankname()); +// remShare.setAnnexbankcard(serviceReimbursement.getAnnexbankcard()); +// remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); +// //remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); +// // remShare.setAmountrequested(BigDecimal.valueOf(serviceReimbursement.getAmountrequested())); +// +// Double nTemp = serviceReimbursement.getAmountrequested(); +// if (nTemp == null) nTemp = 0d; +// remShare.setAmountrequested(BigDecimal.valueOf(nTemp)); +// +// nTemp = serviceReimbursement.getPrepaidamount(); +// if (nTemp == null) nTemp = 0.0; +// remShare.setPrepaidamount(BigDecimal.valueOf(nTemp)); +// +// remShare.setInvoicecount(serviceReimbursement.getInvoicecount()); +// remShare.setAttachcount(serviceReimbursement.getAttachcount()); +// remShare.setManagerno(serviceReimbursement.getManagerno()); +// remShare.setManagername(serviceReimbursement.getManagername()); +// remShare.setDeptmentno(serviceReimbursement.getDeptmentno()); +// remShare.setDeptmentname(serviceReimbursement.getDeptmentname()); +// remShare.setOpochecker(serviceReimbursement.getOpochecker()); +// remShare.setFinvicepresident(serviceReimbursement.getFinvicepresident()); +// remShare.setBusvicepresident(serviceReimbursement.getBusvicepresident()); +// remShare.setOfficedirector(serviceReimbursement.getOfficedirector()); +// remShare.setFinancedirector(serviceReimbursement.getFinancedirector()); +// remShare.setFinancechecher(serviceReimbursement.getFinancechecher()); +// remShare.setInfoid(serviceReimbursement.getInfoid()); +// remShare.setDonorno(serviceReimbursement.getDonorno()); +// +// remShare.setDonorname(serviceReimbursement.getDonorname()); +// remShare.setReason(serviceReimbursement.getReason()); +// remShare.setRecordstatus(serviceReimbursement.getRecordstatus()); +// remShare.setUploadflag(serviceReimbursement.getUploadflag()); +// remShare.setUploadtime(serviceReimbursement.getUploadtime()); +// +// nTemp = serviceReimbursement.getTotalamount(); +// if (nTemp == null) nTemp = 0.0; +// remShare.setTotalamount(BigDecimal.valueOf(nTemp)); +// +// remShare.setBigstrmoney(serviceReimbursement.getBigstrmoney()); +// remShare.setFlowlevel(serviceReimbursement.getFlowlevel()); +// remShare.setCosttype(serviceReimbursement.getCosttype()); +// remShare.setCosttypename(serviceReimbursement.getCosttypename()); +// remShare.setFileurl(serviceReimbursement.getAnnexfiles()); +// remShare.setDonorbank(serviceReimbursement.getDonorbank()); +// remShare.setDonorbankcard(serviceReimbursement.getDonorbankcard()); +// remShare.setDonorremark(serviceReimbursement.getDonorremark()); +// +// nTemp = serviceReimbursement.getDonoramount(); +// if (nTemp == null) nTemp = 0.0; +// remShare.setDonoramount(nTemp); +// remShare.setDonorrelatives(serviceReimbursement.getDonorrelatives()); +// //remShare.setOaid(serviceReimbursement.getOaid()); +// //remShare.setDonorno(serviceReimbursement.getDonorno()); +// +// boolean bRet = false; +// if (nType == 1) { +// bRet = serviceReimbursementServiceShare.save(remShare); +// } else { +// //remShare.setId(serviceReimbursement.); +// bRet = serviceReimbursementServiceShare.updateById(remShare); +// } +// +// //if(!bRet) return -1; +// String strMutfileUrl = remShare.getFileurl(); +// //鏈夐檮浠舵椂鎵嶈皟鐢ㄧ涓夋柟杩涜涓婁紶 +// if (strMutfileUrl == null) return 0; +// if (strMutfileUrl.isEmpty()) return 0; +// +// try { +// uploadOAFileAndUpdateDb(remShare); +// } catch (Exception e) { +// logger.error("璋冪敤绗笁鏂规帴鍙e嚭閿�!"); +// e.printStackTrace(); +// } +// +// //姝ゅ淇濆瓨鎴愬姛鍚庤涓婁紶OA锛屼繚瀛樿繑鍥炲�� +// +// return 0; +// } - int uploadOAFileAndUpdateDb(ServiceReimbursementShared remShare) { - //涓婁紶OA鏂囦欢 - //String strUrl = "http://129.88.242.39:8899/seeyon/rest/token?userName=opo&password=127814f8-84e8-4304-84a5-a71573567efd&loginName=demo3"; - String strUrl = "http://129.88.242.39:8899/seeyon/rest/token"; - //String strUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/token"; - //涓婁紶鏂囦欢鎴愬姛鍚庯紝鍘绘洿鏂扮浉鍏崇殑鏁版嵁搴� - - - Map<String, Object> map = new HashMap<String, Object>(); - map.put("userName", "opo"); - map.put("password", "4126407a-9821-4874-be41-6568abd6dbe5"); - map.put("loginName", "demo3"); - - JSONObject jsonObj = new JSONObject(map); - - System.out.println("uploadOAFileAndUpdateDb + jsonObject" + jsonObj.toString() + "\r\n" + jsonObj.toJSONString()); - String strRes = HttpClientKit.postOpr(strUrl, jsonObj.toString());// - //String strRes = HttpClientKit.postMsg(strUrl,jsonObj);//寰楀埌杩斿洖鐨則oken? - - JSONObject json1 = JSONObject.parseObject(strRes); - strRes = json1.get("id").toString(); - - ///if(strRes.isEmpty() || "" == strRes) return -1;// 涓虹┖浠h〃澶辫触 - - //涓嬮潰闇�姹傝皟鐢ㄦ枃浠剁殑鎺ュ彛锛岃皟鐢ㄦ垚鍔熻繑鍥炲悗锛屽緱鍒癴ilename鍜宖ileid 鐢ㄨ繖浜屼釜鍊煎幓鏇存柊鏁版嵁 - - String filePath = RuoYiConfig.getUploadPath(); - String strMutfileUrl = remShare.getFileurl();//鍙兘瀛樺湪澶氫釜鍦板潃锛屼互,鍒嗗紑 - - String strFUrl = "http://129.88.242.39:8899/seeyon/rest/attachment?token=" + strRes; - //String strFUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/attachment?token="+strRes; - //strFUrl = String.format(strFUrl, strRes); - - /*File test = null; - File file = new File("E:\\YYJQ\\OPO\\WEB\\Upload\\upload\\2023\\02\\17"); - if (file.exists() && file.isDirectory()) { - // 鑾峰彇鎵�鏈夌洸鐩掓枃浠跺す - File[] ones = file.listFiles(); - for (File one : ones) { - test = one; - } - }*/ - - String filename = ""; - String fileid = ""; - - String[] urlArray = strMutfileUrl.split(","); - for (int i = 0; i < urlArray.length; i++) { - String strOneFileName = urlArray[i]; - String strTemp = strOneFileName.substring(15); - String strFile = filePath + strTemp; - //FileUploadUtils.getAbsoluteFile(filePath,strOneFileName); - String struploadResult = ""; - File filetest = new File(strFile); - try { - struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); - } catch (Exception e) { - e.printStackTrace(); - } - - - /*CloseableHttpClient httpClient = HttpClients.createDefault(); - //鍒涘缓post鏂规硶杩炴帴瀹炰緥锛屽湪post鏂规硶涓紶鍏ュ緟杩炴帴鍦板潃 - HttpPost httpPost = new HttpPost(strFUrl); - CloseableHttpResponse response = null; - - String struploadResult = ""; - try { - //璁剧疆璇锋眰鍙傛暟锛堢被浼糷tml椤甸潰涓璶ame灞炴�э級 - MultipartEntityBuilder entity = MultipartEntityBuilder.create(); - //entity.setMode(HttpMultipartMode.BROWSER_COMPATIBLE); - entity.setCharset(Charset.forName("UTF-8")); - - byte[] fileBytes = Files.readAllBytes(Paths.get(strFile)); - if (fileBytes != null) { - //鍐呭绫诲瀷锛岀敤浜庡畾涔夌綉缁滄枃浠剁殑绫诲瀷鍜岀綉椤电殑缂栫爜锛屽喅瀹氭枃浠舵帴鏀舵柟灏嗕互浠�涔堝舰寮忋�佷粈涔堢紪鐮佽鍙栬繖涓枃浠� - ContentType OCTEC_STREAM = ContentType.create("application/octet-stream", Charset.forName("UTF-8")); - //娣诲姞鏂囦欢 - entity.addBinaryBody("file", fileBytes, OCTEC_STREAM, strTemp); - } - - httpPost.setEntity(entity.build()); - //鍙戣捣璇锋眰锛屽苟杩斿洖璇锋眰鍝嶅簲 - response = httpClient.execute(httpPost); - struploadResult = EntityUtils.toString(response.getEntity(), "utf-8"); - } - catch (Exception e) - { - e.printStackTrace(); - }*/ - - //String strFRes = HttpClientKit.postMsg(strFUrl,jsonFObj); - if (struploadResult == null) return 0; - if (struploadResult.isEmpty()) return 0; - - JSONObject jsonR = JSONObject.parseObject(struploadResult); - - JSONArray jsonArr = jsonR.getJSONArray("atts"); - for (int j = 0; j < jsonArr.size(); j++) { - JSONObject jsonRet = jsonArr.getJSONObject(j); - String name1 = jsonRet.get("filename").toString(); - String id1 = jsonRet.get("fileUrl").toString(); - filename += name1; - fileid += id1; - if (i != urlArray.length - 1) { - filename += ","; - fileid += ","; - } - } - - } - - long nId = remShare.getId(); - remShare.setId(nId); - remShare.setFilename(filename); - remShare.setFileid(fileid); - boolean bRet = serviceReimbursementServiceShare.updateById(remShare); - if (!bRet) return -1; - - return 0; - } +// int uploadOAFileAndUpdateDb(ServiceReimbursementShared remShare) { +// //涓婁紶OA鏂囦欢 +// //String strUrl = "http://129.88.242.39:8899/seeyon/rest/token?userName=opo&password=127814f8-84e8-4304-84a5-a71573567efd&loginName=demo3"; +// String strUrl = "http://129.88.242.39:8899/seeyon/rest/token"; +// //String strUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/token"; +// //涓婁紶鏂囦欢鎴愬姛鍚庯紝鍘绘洿鏂扮浉鍏崇殑鏁版嵁搴� +// +// +// Map<String, Object> map = new HashMap<String, Object>(); +// map.put("userName", "opo"); +// map.put("password", "4126407a-9821-4874-be41-6568abd6dbe5"); +// map.put("loginName", "demo3"); +// +// JSONObject jsonObj = new JSONObject(map); +// +// System.out.println("uploadOAFileAndUpdateDb + jsonObject" + jsonObj.toString() + "\r\n" + jsonObj.toJSONString()); +// String strRes = HttpClientKit.postOpr(strUrl, jsonObj.toString());// +// //String strRes = HttpClientKit.postMsg(strUrl,jsonObj);//寰楀埌杩斿洖鐨則oken? +// +// JSONObject json1 = JSONObject.parseObject(strRes); +// strRes = json1.get("id").toString(); +// +// ///if(strRes.isEmpty() || "" == strRes) return -1;// 涓虹┖浠h〃澶辫触 +// +// //涓嬮潰闇�姹傝皟鐢ㄦ枃浠剁殑鎺ュ彛锛岃皟鐢ㄦ垚鍔熻繑鍥炲悗锛屽緱鍒癴ilename鍜宖ileid 鐢ㄨ繖浜屼釜鍊煎幓鏇存柊鏁版嵁 +// +// String filePath = RuoYiConfig.getUploadPath(); +// String strMutfileUrl = remShare.getFileurl();//鍙兘瀛樺湪澶氫釜鍦板潃锛屼互,鍒嗗紑 +// +// String strFUrl = "http://129.88.242.39:8899/seeyon/rest/attachment?token=" + strRes; +// //String strFUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/attachment?token="+strRes; +// //strFUrl = String.format(strFUrl, strRes); +// +// /*File test = null; +// File file = new File("E:\\YYJQ\\OPO\\WEB\\Upload\\upload\\2023\\02\\17"); +// if (file.exists() && file.isDirectory()) { +// // 鑾峰彇鎵�鏈夌洸鐩掓枃浠跺す +// File[] ones = file.listFiles(); +// for (File one : ones) { +// test = one; +// } +// }*/ +// +// String filename = ""; +// String fileid = ""; +// +// String[] urlArray = strMutfileUrl.split(","); +// for (int i = 0; i < urlArray.length; i++) { +// String strOneFileName = urlArray[i]; +// String strTemp = strOneFileName.substring(15); +// String strFile = filePath + strTemp; +// //FileUploadUtils.getAbsoluteFile(filePath,strOneFileName); +// String struploadResult = ""; +// File filetest = new File(strFile); +// try { +// struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); +// } catch (Exception e) { +// e.printStackTrace(); +// } +// +// +// /*CloseableHttpClient httpClient = HttpClients.createDefault(); +// //鍒涘缓post鏂规硶杩炴帴瀹炰緥锛屽湪post鏂规硶涓紶鍏ュ緟杩炴帴鍦板潃 +// HttpPost httpPost = new HttpPost(strFUrl); +// CloseableHttpResponse response = null; +// +// String struploadResult = ""; +// try { +// //璁剧疆璇锋眰鍙傛暟锛堢被浼糷tml椤甸潰涓璶ame灞炴�э級 +// MultipartEntityBuilder entity = MultipartEntityBuilder.create(); +// //entity.setMode(HttpMultipartMode.BROWSER_COMPATIBLE); +// entity.setCharset(Charset.forName("UTF-8")); +// +// byte[] fileBytes = Files.readAllBytes(Paths.get(strFile)); +// if (fileBytes != null) { +// //鍐呭绫诲瀷锛岀敤浜庡畾涔夌綉缁滄枃浠剁殑绫诲瀷鍜岀綉椤电殑缂栫爜锛屽喅瀹氭枃浠舵帴鏀舵柟灏嗕互浠�涔堝舰寮忋�佷粈涔堢紪鐮佽鍙栬繖涓枃浠� +// ContentType OCTEC_STREAM = ContentType.create("application/octet-stream", Charset.forName("UTF-8")); +// //娣诲姞鏂囦欢 +// entity.addBinaryBody("file", fileBytes, OCTEC_STREAM, strTemp); +// } +// +// httpPost.setEntity(entity.build()); +// //鍙戣捣璇锋眰锛屽苟杩斿洖璇锋眰鍝嶅簲 +// response = httpClient.execute(httpPost); +// struploadResult = EntityUtils.toString(response.getEntity(), "utf-8"); +// } +// catch (Exception e) +// { +// e.printStackTrace(); +// }*/ +// +// //String strFRes = HttpClientKit.postMsg(strFUrl,jsonFObj); +// if (struploadResult == null) return 0; +// if (struploadResult.isEmpty()) return 0; +// +// JSONObject jsonR = JSONObject.parseObject(struploadResult); +// +// JSONArray jsonArr = jsonR.getJSONArray("atts"); +// for (int j = 0; j < jsonArr.size(); j++) { +// JSONObject jsonRet = jsonArr.getJSONObject(j); +// String name1 = jsonRet.get("filename").toString(); +// String id1 = jsonRet.get("fileUrl").toString(); +// filename += name1; +// fileid += id1; +// if (i != urlArray.length - 1) { +// filename += ","; +// fileid += ","; +// } +// } +// +// } +// +//// long nId = remShare.getId(); +//// remShare.setId(nId); +//// remShare.setFilename(filename); +//// remShare.setFileid(fileid); +//// boolean bRet = serviceReimbursementServiceShare.updateById(remShare); +//// if (!bRet) return -1; +// +// return 0; +// } /** * 宸梾璐逛笂鎶� @@ -627,9 +615,9 @@ @RepeatSubmit public AjaxResult edit(@RequestBody ServiceReimbursement serviceReimbursement) { boolean b = serviceReimbursementService.updateById(serviceReimbursement); - if (b) { - addReiSharedDatd(serviceReimbursement, 2); - } +// if (b) { +// addReiSharedDatd(serviceReimbursement, 2); +// } return toAjax(b); } -- Gitblit v1.9.3