From 519886a70d630e3cdd6c0f40f55fcebc6e780dc5 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 19 三月 2024 17:45:11 +0800
Subject: [PATCH] 代码提交
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java | 263 +++++++---------------------------------------------
1 files changed, 37 insertions(+), 226 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
index 01c66f3..d322936 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
@@ -1,8 +1,6 @@
package com.ruoyi.web.controller.project;
-import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
-import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.annotation.NotRepeatCommit;
import com.ruoyi.common.annotation.RepeatSubmit;
@@ -10,14 +8,12 @@
import com.ruoyi.common.constant.HttpStatus;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
-import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.exception.base.BaseException;
-import com.ruoyi.common.tax.TaxtUtils;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.bean.DtoConversionUtils;
@@ -26,7 +22,6 @@
import com.ruoyi.project.domain.vo.*;
import com.ruoyi.project.mapper.ServiceFunddetailMapper;
import com.ruoyi.project.service.*;
-import com.ruoyi.system.service.ISysDeptService;
import com.ruoyi.system.service.ISysPostService;
import com.ruoyi.system.service.ISysUserService;
import freemarker.template.Configuration;
@@ -36,12 +31,14 @@
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Options;
-import org.apache.poi.ss.formula.functions.T;
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.Row;
+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.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
-import org.springframework.transaction.TransactionStatus;
-import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;
@@ -91,19 +88,11 @@
private IServiceSystemmessageService ServiceSystemmessage;
@Autowired
- private IBaseOnlyvalueService baseOnlyvalueService;
-
- @Autowired
private IServiceExternalpersonService externalpersonService;
@Autowired
private ISysPostService postService;
- @Autowired
- private DataSourceTransactionManager transactionManager;
-
- @Autowired
- private TransactionDefinition transactionDefinition;
@Autowired
private DingTalkService dingTalkService;
@@ -202,6 +191,17 @@
return getCustomDataTable(list, pageNum, pageSize);
}
+ /**
+ * 鏍规嵁鏉冮檺鏄剧ず瀹℃牳鍒楄〃
+ */
+ @ApiOperation("鏍规嵁鏉冮檺鏄剧ず瀹℃牳鍒楄〃")
+ @Log(title = "鏍规嵁鏉冮檺鏄剧ず瀹℃牳鍒楄〃", businessType = BusinessType.OTHER)
+ @PostMapping("/getExpertfeeList")
+ public TableDataInfo getExpertfeeList(@RequestBody SpSelectExpertfee spSelectExpertfee) {
+ List<SpFinancialExpensesFundOut> expertfeeList = serviceFundService.getExpertfeeList(spSelectExpertfee);
+ return getCustomDataTable(expertfeeList, spSelectExpertfee.getPageNum(), spSelectExpertfee.getPageSize());
+ }
+
@ApiOperation("鏌ヨ璐圭敤鐢宠涓诲垪琛�")
//@PreAuthorize("@ss.hasPermi('project:fund:list')")
@GetMapping(value = "/getInfo/{infoid}")
@@ -263,216 +263,15 @@
return AjaxResult.success(id);
}
-
-// public int addReiSharedDatd(ServiceFund serviceFund, int nType) {
-// //remShare = ;
-// ServiceFundShared remShare = null;
-// if (nType == 1) {
-// remShare = new ServiceFundShared();
-// remShare.setSerfunid(serviceFund.getId());
-// } else //modify
-// {
-// List<ServiceFundShared> remlist = fundServiceShare.getFundShareInfoById(serviceFund.getId());
-// if (remlist != null) remShare = remlist.get(0);
-// }
-//
-// remShare.setDonorno(serviceFund.getDonorno());
-// remShare.setDonorname(serviceFund.getDonorname());
-// remShare.setUserno(serviceFund.getUserno());
-// remShare.setUsername(serviceFund.getUsername());
-// remShare.setUnitname(serviceFund.getUnitname());
-// remShare.setUnitno(serviceFund.getUnitno());
-// remShare.setUnituserno(serviceFund.getUnituserno());
-// remShare.setPhone(serviceFund.getPhone());
-// remShare.setAnnexbankcard(serviceFund.getAnnexbankcard());
-// remShare.setAnnexregistform(serviceFund.getAnnexregistform());
-// Double nTemp = serviceFund.getPretaxcost();
-// if (nTemp == null) nTemp = 0d;
-// remShare.setPretaxcost(BigDecimal.valueOf(nTemp));
-// //remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles());
-// // remShare.setAmountrequested(BigDecimal.valueOf(serviceReimbursement.getAmountrequested()));
-//
-// nTemp = serviceFund.getTaxedcost();
-// if (nTemp == null) nTemp = 0d;
-// remShare.setTaxedcost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getTotalcost();
-// if (nTemp == null) nTemp = 0d;
-// remShare.setTotalcost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getExpertcost();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setExpertcost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getEthicscost();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setEthicscost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getMedicalcost();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setMedicalcost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getFamilycost();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setFamilycost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getAftercarecost();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setAftercarecost(BigDecimal.valueOf(nTemp));
-//
-// nTemp = serviceFund.getAmountrequested();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setAmountrequested(BigDecimal.valueOf(nTemp));
-//
-//
-// remShare.setApplytype(serviceFund.getApplytype());
-//
-// nTemp = serviceFund.getPrepaidamount();
-// if (nTemp == null) nTemp = 0.0;
-// remShare.setPrepaidamount(BigDecimal.valueOf(nTemp));
-//
-// remShare.setInvoicecount(serviceFund.getInvoicecount());
-// remShare.setAttachcount(serviceFund.getAttachcount());
-// remShare.setManagerno(serviceFund.getManagerno());
-// remShare.setManagername(serviceFund.getManagername());
-// remShare.setDeptmentno(serviceFund.getDeptmentno());
-// remShare.setDeptmentname(serviceFund.getDeptmentname());
-// remShare.setOpochecker(serviceFund.getOpochecker());
-// remShare.setFinvicepresident(serviceFund.getFinvicepresident());
-// remShare.setBusvicepresident(serviceFund.getBusvicepresident());
-// remShare.setOfficedirector(serviceFund.getOfficedirector());
-// remShare.setFinancedirector(serviceFund.getFinancedirector());
-// remShare.setFinancechecher(serviceFund.getFinancechecher());
-// //remShare.setIsdistribute(serviceFund.getIsdistribute());
-// remShare.setRecordstatus(serviceFund.getRecordstatus());
-// remShare.setUploadflag(serviceFund.getUploadflag());
-// remShare.setUploadtime(serviceFund.getUploadtime());
-// long nLevel = serviceFund.getFlowlevel();
-// remShare.setFlowlevel(nLevel);
-//
-// remShare.setInfoid(serviceFund.getInfoid());
-//
-// //remShare.setOaid(serviceReimbursement.getOaid());
-// //remShare.setDonorno(serviceReimbursement.getDonorno());
-//
-// boolean bRet = false;
-// if (nType == 1) {
-// bRet = fundServiceShare.save(remShare);
-// } else {
-// //remShare.setId(serviceReimbursement.);
-// bRet = fundServiceShare.updateById(remShare);
-// }
-//
-// //if(!bRet) return -1;
-// String strMutfileUrl = remShare.getAnnexbankcard();
-// //鏈夐檮浠舵椂鎵嶈皟鐢ㄧ涓夋柟杩涜涓婁紶
-// if (strMutfileUrl == null) return 0;
-// if (strMutfileUrl.isEmpty()) return 0;
-//
-// try {
-// uploadOAFileAndUpdateDb(remShare);
-// } catch (Exception e) {
-// logger.error("璋冪敤绗笁鏂规帴鍙ｅ嚭閿�!");
-// e.printStackTrace();
-// }
-//
-// //姝ゅ淇濆瓨鎴愬姛鍚庤涓婁紶OA锛屼繚瀛樿繑鍥炲��
-//
-// return 0;
-// }
-
-
-// int uploadOAFileAndUpdateDb(ServiceFundShared 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;// 涓虹┖浠ｈ〃澶辫触
-//
-// //涓嬮潰闇�姹傝皟鐢ㄦ枃浠剁殑鎺ュ彛锛岃皟鐢ㄦ垚鍔熻繑鍥炲悗锛屽緱鍒癴ilename鍜宖ileid 鐢ㄨ繖浜屼釜鍊煎幓鏇存柊鏁版嵁
-//
-// String filePath = RuoYiConfig.getUploadPath();
-// String strMutfileUrl = remShare.getAnnexbankcard();//鍙兘瀛樺湪澶氫釜鍦板潃锛屼互,鍒嗗紑
-//
-// 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();
-// }
-//
-//
-// //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 = fundServiceShare.updateById(remShare);
-// if (!bRet) return -1;
-//
-// return 0;
-// }
+ /**
+ * fund琛ㄤ腑锛屼慨鏀筬undTaxId
+ */
+ @ApiOperation("fund琛ㄤ腑锛屼慨鏀筬undTaxId")
+ @PostMapping("/editFundTaxId")
+ public AjaxResult editFundTaxId(@RequestBody ServiceFund serviceFund) {
+ boolean b = serviceFundService.updateFundTaxIdById(serviceFund.getId(), serviceFund.getFundTaxId());
+ return AjaxResult.success(b);
+ }
/**
* 鏂板璐圭敤姹囨��
@@ -2234,4 +2033,16 @@
return AjaxResult.success(dataMap);
}
+
+ /**
+ * 瀵煎嚭涓撳鎶ラ攢璐圭敤姹囨��
+ */
+ @ApiOperation("瀵煎嚭涓撳鎶ラ攢璐圭敤姹囨��")
+ @Log(title = "璐圭敤鐢宠涓�", businessType = BusinessType.EXPORT)
+ @GetMapping("/exportFeeSum/{faxId}")
+ public Map<String, Object> exportFeeSum(@PathVariable Integer faxId) {
+ Map<String, Object> map = serviceFundService.exportFeeSum(faxId);
+ return map;
+ }
+
}
--
Gitblit v1.9.3