修改方法名

liusheng

2023-08-07 8b8c655968159a016f9b3b9ca42c5fec2abc2f4b

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java

@@ -1,7 +1,5 @@
package com.ruoyi.web.controller.project;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.annotation.RepeatSubmit;
import com.ruoyi.common.config.RuoYiConfig;
@@ -13,43 +11,55 @@
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.HttpClientKit;
import com.ruoyi.common.tax.TaxtUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.bean.DtoConversionUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.project.domain.*;
import com.ruoyi.project.domain.vo.*;
import com.ruoyi.project.mapper.ServiceFunddetailMapper;
import com.ruoyi.project.service.*;
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Options;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;

import java.io.*;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;

import static com.ruoyi.web.controller.project.ServiceReimbursementController.convert;

/**
 * 费用申请主Controller
 * 
 *
 * @author ruoyi
 * @date 2022-01-24
 */
@Slf4j
@Api("费用申请主")
@RestController
@RequestMapping("/project/fund")
public class ServiceFundController extends BaseController
{
public class ServiceFundController extends BaseController {
    private static Configuration configuration = null;
    @Autowired
    private IServiceFundService serviceFundService;
    @Autowired
    private IServiceFundSharedService fundSharedService;
    @Autowired
    private ServiceFunddetailMapper serviceFunddetailMapper;
    @Autowired
    private IServiceFunddetailService serviceFunddetailService;
    @Autowired
    private IServiceFunddetailSharedService funddetailSharedService;
    @Autowired
    private IServiceFundflowruleService serviceFundflowruleService;
    @Autowired
@@ -78,8 +88,7 @@
    @ApiOperation("查询费用申请主列表")
    //@PreAuthorize("@ss.hasPermi('project:fund:list')")
    @GetMapping("/list")
    public TableDataInfo list(ServiceFund serviceFund)
    {
    public TableDataInfo list(ServiceFund serviceFund) {
        startPage();
        //List<ServiceFund> list = serviceFundService.queryList(serviceFund);
        List<ServiceFund> list = serviceFundService.selectServiceFundList(serviceFund);
@@ -87,7 +96,7 @@
    }

    @GetMapping("/listnew")
    public TableDataInfo listnew(FundVO fundVO){
    public TableDataInfo listnew(FundVO fundVO) {
        startPage();
        List<FundVO> list = serviceFundService.selectVOList(fundVO);
        return getDataTable(list);
@@ -99,65 +108,68 @@
    @ApiOperation("根据权限显示审核列表")
    @Log(title = "根据权限显示审核列表", businessType = BusinessType.OTHER)
    @GetMapping("/listbypower")
    public TableDataInfo getListBypower(SpFinancialExpensesIn spFinancialExpensesIn)
    {
    public TableDataInfo getListBypower(SpFinancialExpensesIn spFinancialExpensesIn) {
        LoginUser loginUser = getLoginUser();

        String APPLICANT=spFinancialExpensesIn.getAPPLICANT();
        String APPLICATIONBEGTIME=spFinancialExpensesIn.getAPPLICATIONBEGTIME();
        String APPLICATIONENDTIME=spFinancialExpensesIn.getAPPLICATIONENDTIME();
        Integer CHECKFLAG=spFinancialExpensesIn.getCHECKFLAG();
        Integer APPLYTYPE=spFinancialExpensesIn.getAPPLYTYPE();
        Integer pageNum=spFinancialExpensesIn.getPageNum();
        Integer pageSize=spFinancialExpensesIn.getPageSize();
        String APPLICANT = spFinancialExpensesIn.getAPPLICANT();
        String APPLICATIONBEGTIME = spFinancialExpensesIn.getAPPLICATIONBEGTIME();
        String APPLICATIONENDTIME = spFinancialExpensesIn.getAPPLICATIONENDTIME();
        Integer CHECKFLAG = spFinancialExpensesIn.getCHECKFLAG();
        Integer APPLYTYPE = spFinancialExpensesIn.getAPPLYTYPE();
        Integer pageNum = spFinancialExpensesIn.getPageNum();
        Integer pageSize = spFinancialExpensesIn.getPageSize();

        if(pageNum==null)
        {
            pageNum=1;
        if (pageNum == null) {
            pageNum = 1;
        }

        if(pageSize==null)
        {
            pageSize=10;
        if (pageSize == null) {
            pageSize = 10;
        }

        if(APPLICANT==null)
        {
            APPLICANT="";
        if (APPLICANT == null) {
            APPLICANT = "";
        }

        if(APPLICATIONBEGTIME==null)
        {
            APPLICATIONBEGTIME="";
        if (APPLICATIONBEGTIME == null) {
            APPLICATIONBEGTIME = "";
        }

        if(APPLICATIONENDTIME==null)
        {
            APPLICATIONENDTIME="";
        if (APPLICATIONENDTIME == null) {
            APPLICATIONENDTIME = "";
        }

        //startPage();
        List<SpFinancialExpensesFundOut> list = serviceFundService.getListBypower(loginUser.getUsername(),2,APPLICANT,APPLICATIONBEGTIME,APPLICATIONENDTIME,loginUser.getDeptId().toString(),CHECKFLAG,APPLYTYPE);
        //return getDataTable(list);
        return getCustomDataTable(list,pageNum,pageSize);
        List<SpFinancialExpensesFundOut> list = serviceFundService.getListBypower(loginUser.getUsername(), 2, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE);
        Collections.sort(list, new Comparator<SpFinancialExpensesFundOut>() {
            @Override
            public int compare(SpFinancialExpensesFundOut o1, SpFinancialExpensesFundOut o2) {
                return o2.getCreateTime().compareTo(o1.getCreateTime());
            }
        });
        return getCustomDataTable(list, pageNum, pageSize);
    }

    @ApiOperation("查询费用申请主列表")
    //@PreAuthorize("@ss.hasPermi('project:fund:list')")
    @GetMapping(value = "/getInfo/{infoid}")
    public AjaxResult getInfoByInfoId(@PathVariable("infoid") Long infoid)
    {
    public AjaxResult getInfoByInfoId(@PathVariable("infoid") Long infoid) {
        return AjaxResult.success(serviceFundService.getInfoByInfoId(infoid));
    }


    @GetMapping("/getFundId/{infoid}")
    public AjaxResult getFundId(@PathVariable("infoid") Long infoid){
    public AjaxResult getFundId(@PathVariable("infoid") Long infoid) {
        return AjaxResult.success(serviceFundService.getFundId(infoid));
    }

    @GetMapping("/addFundSharedInfo/{id}")
    public AjaxResult addFundSharedInfo(@PathVariable("id") Long id) {
        return AjaxResult.success(serviceFundService.addFundSharedInfo(id));
    }

    @GetMapping("/getFundDetail/{id}")
    public AjaxResult getFundDetail(@PathVariable("id") Long id){
    public AjaxResult getFundDetail(@PathVariable("id") Long id) {
        return AjaxResult.success(serviceFundService.getFundDetail(id));
    }

@@ -168,13 +180,11 @@
    //@PreAuthorize("@ss.hasPermi('project:fund:export')")
    @Log(title = "费用申请主", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(ServiceFund serviceFund)
    {
    public AjaxResult export(ServiceFund serviceFund) {
        List<ServiceFund> list = serviceFundService.queryList(serviceFund);
        ExcelUtil<ServiceFund> util = new ExcelUtil<ServiceFund>(ServiceFund.class);
        return util.exportExcel(list, "费用申请主数据");
    }



    /**
@@ -183,8 +193,7 @@
    @ApiOperation("获取费用申请主详细信息")
    //@PreAuthorize("@ss.hasPermi('project:fund:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return AjaxResult.success(serviceFundService.getById(id));
    }

@@ -197,266 +206,239 @@
    @PostMapping
    @RepeatSubmit
    @Options(useGeneratedKeys = true, keyProperty = "id")
    public AjaxResult add(@RequestBody ServiceFund serviceFund)
    {
    public AjaxResult add(@RequestBody ServiceFund serviceFund) {
        boolean b = serviceFundService.save(serviceFund);
        Long id = serviceFund.getId();
        if(b)
        {
            addReiSharedDatd(serviceFund,1);
        }
//        if (b) {
//            addReiSharedDatd(serviceFund, 1);
//        }
        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));
//    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;
//    }


        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);//得到返回的token?

        JSONObject json1 = JSONObject.parseObject(strRes);
        strRes = json1.get("id").toString();

        ///if(strRes.isEmpty() || "" == strRes) return -1;// 为空代表失败

        //下面需求调用文件的接口，调用成功返回后，得到filename和fileid 用这二个值去更新数据

        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;
    }
//    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);//得到返回的token?
//
//        JSONObject json1 = JSONObject.parseObject(strRes);
//        strRes = json1.get("id").toString();
//
//        ///if(strRes.isEmpty() || "" == strRes) return -1;// 为空代表失败
//
//        //下面需求调用文件的接口，调用成功返回后，得到filename和fileid 用这二个值去更新数据
//
//        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;
//    }

    /**
     * 新增费用汇总
     */
    @ApiOperation("新增费用汇总")
    @Log(title = "新增费用汇总", businessType = BusinessType.INSERT)
    @PostMapping("/addnew")
    @PostMapping("/addOrUpdateNew")
    @RepeatSubmit
    @Options(useGeneratedKeys = true, keyProperty = "id")
    public AjaxResult addnew(@RequestBody ServiceFundVO serviceFundVO)
    {
        boolean b = serviceFundService.save(serviceFundVO);
        Long id = serviceFundVO.getId();
        if(b)
        {
            addReiSharedDatd(serviceFundVO,1);
        }
        List<ServiceFunddetail> serviceFunddetails=serviceFundVO.getServiceFunddetails();
        serviceFunddetails.forEach(item->item.setFundid(id));
        serviceFunddetailService.saveBatch(serviceFunddetails);
        return AjaxResult.success(id);
    public AjaxResult addOrUpdateNew(@RequestBody ServiceFundVO serviceFundVO) {

        return AjaxResult.success(serviceFundService.addOrUpdateNew(serviceFundVO));
    }


    /**
     * 审核费用
@@ -464,134 +446,180 @@
    @ApiOperation("审核费用")
    @Log(title = "审核费用", businessType = BusinessType.OTHER)
    @PostMapping("/checkfund")
    public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO)
        {
            ServiceFund serviceFund= serviceFundService.getById(checkFundVO.getFundid());
            if(serviceFund!=null)
            {
                Integer TotalLevel=0;
                LoginUser loginUser = getLoginUser();
                ServiceFundflowrule serviceFundflowrule=new ServiceFundflowrule();
                serviceFundflowrule.setFundtype(2);
                serviceFundflowrule.setApplytype(serviceFund.getApplytype());
                serviceFundflowrule.setCheckuserno(loginUser.getUsername());
                List<ServiceFundflowrule> serviceFundflowrules= serviceFundflowruleService.queryList(serviceFundflowrule);
    public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) {
        logger.info("serviceFundController---checkFund的入参值checkFundVO :{}", checkFundVO);
        ServiceFund serviceFund = serviceFundService.getById(checkFundVO.getFundid());
        if (serviceFund != null) {
            Integer TotalLevel = 0;
            LoginUser loginUser = getLoginUser();
            ServiceFundflowrule serviceFundflowrule = new ServiceFundflowrule();
            serviceFundflowrule.setFundtype(2);
            serviceFundflowrule.setApplytype(serviceFund.getApplytype());
            serviceFundflowrule.setCheckuserno(loginUser.getUsername());
            logger.info("serviceFundController---checkFund---queryList的入参值serviceFundflowrule:{}", serviceFundflowrule);

                if(serviceFundflowrules==null || serviceFundflowrules.stream().count()==0)
                {
                    return AjaxResult.error(HttpStatus.ERROR,"当前人员无此记录审核权限");
                }
            List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule);

                if(serviceFundflowrules.get(0).getFlowlevel()-1!=serviceFund.getFlowlevel())
                {
                    return AjaxResult.error(HttpStatus.ERROR,"当前人员与此记录的审核级别不符");
                }

                if(serviceFundflowrules!=null && serviceFundflowrules.stream().count()>0)
                {
                    TotalLevel=serviceFundflowrules.get(0).getTotallevel();
                }

                Integer CheckFlag=0;
                Integer RecordStatus=serviceFund.getRecordstatus();
                Integer FlowLevel=serviceFund.getFlowlevel();
                Integer OriginalFlowLevel=FlowLevel;
                if(checkFundVO.getFlowconclusion()==1)
                {
                    CheckFlag=1;
                    if(TotalLevel==0)
                    {
                        RecordStatus=99;
                    }
                    else
                    {
                        if(TotalLevel==FlowLevel+1)
                        {
                            RecordStatus=99;
                        }
                        else
                        {
                            RecordStatus = (FlowLevel+1)*2;
                        }
                    }
                    FlowLevel=FlowLevel+1;
                }
                else
                {
                    CheckFlag=2;
                    RecordStatus = (FlowLevel+1)*2 - 1;
                    FlowLevel=(FlowLevel-1);
                    if(FlowLevel<0)
                    {
                        FlowLevel=0;
                    }
                }

                serviceFund.setRecordstatus(RecordStatus);
                serviceFund.setFlowlevel(FlowLevel);

                ServiceFundflow serviceFundflow=new ServiceFundflow();
                SysUser user = loginUser.getUser();
                serviceFundflow.setFundid(serviceFund.getId());
                serviceFundflow.setCheckuserno(user.getUserName());
                serviceFundflow.setCheckusername(user.getNickName());
                serviceFundflow.setFundtype(2);
                serviceFundflow.setApplytype(serviceFund.getApplytype());
                serviceFundflow.setFlowconclusion(CheckFlag);
                serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent());
                serviceFundflow.setFlowlevel(OriginalFlowLevel+1);
                serviceFundflowService.save(serviceFundflow);
                serviceFundService.updateById(serviceFund);

                ServiceSystemmessage serviceSystemmessage=new ServiceSystemmessage();
                serviceSystemmessage.setFundtype(2);
                serviceSystemmessage.setApplytype(serviceFund.getApplytype());
                serviceSystemmessage.setSenduserno(user.getUserName());
                serviceSystemmessage.setSendusername(user.getNickName());
                serviceSystemmessage.setReceiveuserno(serviceFund.getUserno());
                serviceSystemmessage.setReceiveusername(serviceFund.getUsername());
                serviceSystemmessage.setIsread(0);
                serviceSystemmessage.setMessagetype(1);
                serviceSystemmessage.setRelevantno(serviceFund.getId());

                if(CheckFlag==1)
                {
                    //通过
                    serviceSystemmessage.setMessagetitle(""+(OriginalFlowLevel+1)+"级审核通过");
                    serviceSystemmessage.setMessagecontent("您"+new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceFund.getCreateTime())+"提交的关于捐献案例【"+serviceFund.getDonorname()+"】的费用申请已通过"+(OriginalFlowLevel+1)+"级审核");
                }
                else
                {
                    //驳回
                    serviceSystemmessage.setMessagetitle(""+(OriginalFlowLevel+1)+"级审核驳回");
                    serviceSystemmessage.setMessagecontent("您"+new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceFund.getCreateTime())+"提交的关于捐献案例【"+serviceFund.getDonorname()+"】的费用申请已被"+(OriginalFlowLevel+1)+"级审核驳回，原因为"+checkFundVO.getFlowcontent()+"");
                }
                ServiceSystemmessage.save(serviceSystemmessage);
                return AjaxResult.success();
            if (serviceFundflowrules == null || serviceFundflowrules.stream().count() == 0) {
                return AjaxResult.error(HttpStatus.ERROR, "当前人员无此记录审核权限");
            }
            else
            {
                return AjaxResult.error(HttpStatus.NO_CONTENT,"费用编号不正确");

            if (serviceFundflowrules.get(0).getFlowlevel() - 1 != serviceFund.getFlowlevel()) {
                return AjaxResult.error(HttpStatus.ERROR, "当前人员与此记录的审核级别不符");
            }

            if (serviceFundflowrules != null && serviceFundflowrules.stream().count() > 0) {
                TotalLevel = serviceFundflowrules.get(0).getTotallevel();
            }

            Integer CheckFlag = 0;
            Integer RecordStatus = serviceFund.getRecordstatus();
            Integer FlowLevel = serviceFund.getFlowlevel();
            Integer OriginalFlowLevel = FlowLevel;
            if (checkFundVO.getFlowconclusion() == 1) {
                CheckFlag = 1;
                if (TotalLevel == 0) {
                    RecordStatus = 99;
                } else {
                    if (TotalLevel == FlowLevel + 1) {
                        RecordStatus = 99;
                    } else {
                        RecordStatus = (FlowLevel + 1) * 2;
                    }
                }
                FlowLevel = FlowLevel + 1;
            } else {
                CheckFlag = 2;
                if (CheckFlag == 2) {
                    //应医院要求如果出现退回，直接退到发起者
                    FlowLevel = 0;
                } else {
                    RecordStatus = (FlowLevel + 1) * 2 - 1;
                    FlowLevel = (FlowLevel - 1);
                    if (FlowLevel < 0) {
                        FlowLevel = 0;
                    }
                }
            }

            serviceFund.setRecordstatus(RecordStatus);
            serviceFund.setFlowlevel(FlowLevel);

            ServiceFundflow serviceFundflow = new ServiceFundflow();
            SysUser user = loginUser.getUser();
            serviceFundflow.setFundid(serviceFund.getId());
            serviceFundflow.setCheckuserno(user.getUserName());
            serviceFundflow.setCheckusername(user.getNickName());
            serviceFundflow.setFundtype(2);
            serviceFundflow.setApplytype(serviceFund.getApplytype());
            serviceFundflow.setFlowconclusion(CheckFlag);
            serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent());
            serviceFundflow.setFlowlevel(OriginalFlowLevel + 1);
            serviceFundflowService.save(serviceFundflow);
            serviceFundService.updateById(serviceFund);

            ServiceSystemmessage serviceSystemmessage = new ServiceSystemmessage();
            serviceSystemmessage.setFundtype(2);
            serviceSystemmessage.setApplytype(serviceFund.getApplytype());
            serviceSystemmessage.setSenduserno(user.getUserName());
            serviceSystemmessage.setSendusername(user.getNickName());
            serviceSystemmessage.setReceiveuserno(serviceFund.getUserno());
            serviceSystemmessage.setReceiveusername(serviceFund.getUsername());
            serviceSystemmessage.setIsread(0);
            serviceSystemmessage.setMessagetype(1);
            serviceSystemmessage.setRelevantno(serviceFund.getId());

            if (CheckFlag == 1) {
                //通过
                serviceSystemmessage.setMessagetitle("" + (OriginalFlowLevel + 1) + "级审核通过");
                serviceSystemmessage.setMessagecontent("您" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceFund.getCreateTime()) + "提交的关于捐献案例【" + serviceFund.getDonorname() + "】的费用申请已通过" + (OriginalFlowLevel + 1) + "级审核");
                if (TotalLevel == OriginalFlowLevel + 1) {
                    ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class);
                    serviceFundShared.setId(null);
                    serviceFundShared.setSerfunid(serviceFund.getId());
                    serviceFundShared.setAmountrequested(new BigDecimal(serviceFund.getAmountrequested()));
                    serviceFundShared.setPrepaidamount(new BigDecimal(serviceFund.getPrepaidamount()));
                    serviceFundShared.setTotalcost(new BigDecimal(serviceFund.getTotalcost()));
                    serviceFundShared.setProcurementcost(new BigDecimal(serviceFund.getProcurementcost()));
                    serviceFundShared.setExpertcost(new BigDecimal(serviceFund.getExpertcost()));
                    serviceFundShared.setEthicscost(new BigDecimal(serviceFund.getEthicscost()));
                    serviceFundShared.setMedicalcost(new BigDecimal(serviceFund.getMedicalcost()));
                    serviceFundShared.setFamilycost(new BigDecimal(serviceFund.getFamilycost()));
                    serviceFundShared.setAftercarecost(new BigDecimal(serviceFund.getAftercarecost()));
                    fundSharedService.save(serviceFundShared);

                    Map<String, Object> columnMap = new HashMap<>();
                    columnMap.put("fundID", checkFundVO.getFundid());
                    //获取详情数据
                    List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.selectByMap(columnMap);
                    logger.info("serviceFundController---checkFund的返回值serviceFunddetails :{}", serviceFunddetails);
                    List<ServiceFunddetailShared> serviceFunddetailShareds = DtoConversionUtils.sourceToTarget(serviceFunddetails, ServiceFunddetailShared.class);
                    for (int i = 0; i < serviceFunddetails.size(); i++) {
                        serviceFunddetailShareds.get(i).setFundid(serviceFundShared.getId());
                        serviceFunddetailShareds.get(i).setFdid(serviceFunddetails.get(i).getId());
                        serviceFunddetailShareds.get(i).setAmount(new BigDecimal(serviceFunddetails.get(i).getAmount()));
                        serviceFunddetailShareds.get(i).setPrepaidamount(new BigDecimal(serviceFunddetails.get(i).getPrepaidamount()));
                        serviceFunddetailShareds.get(i).setTaxamount(new BigDecimal(serviceFunddetails.get(i).getTaxamount()));
                        serviceFunddetailShareds.get(i).setTaxedamount(new BigDecimal(serviceFunddetails.get(i).getTaxedamount()));
                        serviceFunddetailShareds.get(i).setQuantity(new BigDecimal(serviceFunddetails.get(i).getQuantity()));
                        serviceFunddetailShareds.get(i).setPrice(new BigDecimal(serviceFunddetails.get(i).getPrice()));
                        serviceFunddetailShareds.get(i).setId(null);
                    }
                    funddetailSharedService.saveBatch(serviceFunddetailShareds);

                }

            } else {
                //驳回
                serviceSystemmessage.setMessagetitle("" + (OriginalFlowLevel + 1) + "级审核驳回");
                serviceSystemmessage.setMessagecontent("您" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceFund.getCreateTime()) + "提交的关于捐献案例【" + serviceFund.getDonorname() + "】的费用申请已被" + (OriginalFlowLevel + 1) + "级审核驳回，原因为" + checkFundVO.getFlowcontent() + "");
            }
            ServiceSystemmessage.save(serviceSystemmessage);
            return AjaxResult.success();
        } else {
            return AjaxResult.error(HttpStatus.NO_CONTENT, "费用编号不正确");
        }
    }


    /**
     * 修改费用申请主
     * 修改费用申请
     */
    @ApiOperation("修改费用申请主")
    //@PreAuthorize("@ss.hasPermi('project:fund:edit')")
    @ApiOperation("修改费用申请")
    @Log(title = "费用申请主", businessType = BusinessType.UPDATE)
    @PutMapping
    @RepeatSubmit    
    public AjaxResult edit(@RequestBody ServiceFund serviceFund)
    {
        boolean bret = serviceFundService.updateById(serviceFund);
        if(bret)
        {
            addReiSharedDatd(serviceFund,2);
    @PostMapping("/fundEdit")
    @RepeatSubmit
    public AjaxResult fundEdit(@RequestBody ServiceFund serviceFund) {
        log.info("修改费用申请入参:{}", serviceFund);
        List<ServiceFund> infoByInfoIdList = serviceFundService.queryInfoById(serviceFund);
        log.info("修改费用申请，通过入参查询 serviceFundService.queryInfoById数据为空,入参:{}", infoByInfoIdList.size());
        if (CollectionUtils.isEmpty(infoByInfoIdList)) {
            return toAjax(false);
        }
        return toAjax(bret);
        for (ServiceFund sf : infoByInfoIdList) {
            //如果等于100，说明已经走到医院财务那边了；财务那边取数据是从分享表取，所以，这里直接往分享表里添加数据就行了
            if (sf.getBackflowlevel() == 100 || sf.getBackflowlevel() == 199) {
                ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class);
                serviceFundShared.setId(null);
                serviceFundShared.setDel_flag(0);
                fundSharedService.save(serviceFundShared);

                //将fund表的审核状态改成100
                sf.setBackflowlevel(100);
                serviceFundService.updateById(sf);
                return success();
            } else {
                serviceFund.setFlowlevel(sf.getBackflowlevel());
                boolean bret = serviceFundService.updateById(serviceFund);
                log.info("serviceFundService.updateById返参:{}", bret);
//        if (bret) {
//            addReiSharedDatd(serviceFund, 2);
//        }
                return toAjax(bret);
            }
        }

        return toAjax(false);
    }

    /**
@@ -601,8 +629,7 @@
    //@PreAuthorize("@ss.hasPermi('project:fund:remove')")
    @Log(title = "费用申请主", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(serviceFundService.removeByIds(Arrays.asList(ids)));
    }

@@ -613,28 +640,28 @@
    @GetMapping(value = "/downloadLW/{id}")
    public Map downloadInfoLW(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataLW(dataMap,id);
        getDataLW(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("专家劳务费发放申请单.ftl");
            t = configuration.getTemplate("专家劳务费发放申请单(1).ftl");
        } catch (IOException e) {
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "专家劳务费发放申请单_"+dataMap.get("XM")+"_"+ newTime;
        String name = "专家劳务费发放申请单_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -644,8 +671,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -659,15 +686,16 @@
        String date = formatter.format(dt);
        String time = date.substring(0, 10);

        dataMap.put("TBYYMMDD",time);
        dataMap.put("TBYYMMDD", time);
        dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? "   " : serviceFund.getAttachcount());
        dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname());
        dataMap.put("JSR", serviceFund.getUsername() == null ? "" : serviceFund.getUsername());
        dataMap.put("FYXM1", "支付专家费用，其中税前金额" + serviceFund.getPretaxcost() + "元，税后金额" + serviceFund.getTaxedcost() + "元。");
//        dataMap.put("FYXM1", "支付专家费用，其中税前金额" + serviceFund.getPretaxcost() + "元，税后金额" + serviceFund.getTaxedcost() + "元。");
        dataMap.put("FYXM1", "人体器官捐献专家劳务费:" + serviceFund.getPretaxcost() + "元 (其中税后费用由中心承担税费)。");
        dataMap.put("FYXM2", "");
        dataMap.put("FYXM3", "");
        dataMap.put("JEXS", serviceFund.getAmountrequested());
        dataMap.put("JEDS", convert(serviceFund.getAmountrequested()) + "整");
        dataMap.put("JEXS", serviceFund.getPretaxcost());
        dataMap.put("JEDS", convert(serviceFund.getPretaxcost()) + "整");
        dataMap.put("BXBZ", serviceFund.getRemark() == null ? "" : serviceFund.getRemark());


@@ -680,14 +708,15 @@
        if (fd == null) {
            throw new ServiceException("下载失败，没有对应信息", HttpStatus.NO_CONTENT);
        }
        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double sq = 0;
        double ks = 0;
        double sh = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();


            map.put("XH", f.getItemcode() == null ? "" : f.getItemcode());
            String itemName = f.getItemname() == null ? "" : f.getItemname();
@@ -710,11 +739,72 @@
            newsList.add(map);
        }

        dataMap.put("list",newsList);
        //  专家劳务费统计表
        List<Map<String, Object>> lists = new ArrayList<Map<String, Object>>();

        dataMap.put("SQHJ",sq);
        dataMap.put("KSHJ",ks);
        dataMap.put("SHHJ",sh);
        List<Double> sqljList = new ArrayList<>();
        List<Double> ksljList = new ArrayList<>();
        List<Double> shljList = new ArrayList<>();

        //根据”科目类型名称“，来计算税前总和，税金总和,税后总和
        Map<String, ServiceFunddetailAssort> funddetailMap = new HashMap<>();
        for (ServiceFunddetail serviceFunddetail : fd) {
            boolean b = funddetailMap.containsKey(serviceFunddetail.getSubjecttypename());
            if (b == true) {
                ServiceFunddetailAssort serviceFunddetailAssort = funddetailMap.get(serviceFunddetail.getSubjecttypename());
                serviceFunddetailAssort.setKSXJ(serviceFunddetailAssort.getKSXJ() + serviceFunddetail.getTaxamount());
                serviceFunddetailAssort.setSQXJ(serviceFunddetailAssort.getSQXJ() + serviceFunddetail.getAmount());
                serviceFunddetailAssort.setSHXJ(serviceFunddetailAssort.getSHXJ() + serviceFunddetail.getTaxedamount());
            } else {
                funddetailMap.put(serviceFunddetail.getSubjecttypename(), new ServiceFunddetailAssort());
                ServiceFunddetailAssort serviceFunddetailAssort = funddetailMap.get(serviceFunddetail.getSubjecttypename());
                serviceFunddetailAssort.setKSXJ(serviceFunddetailAssort.getKSXJ() + serviceFunddetail.getTaxamount());
                serviceFunddetailAssort.setSQXJ(serviceFunddetailAssort.getSQXJ() + serviceFunddetail.getAmount());
                serviceFunddetailAssort.setSHXJ(serviceFunddetailAssort.getSHXJ() + serviceFunddetail.getTaxedamount());
            }
        }

        funddetailMap.forEach((FWFL, serviceFunddetailAssort) -> {
            Map<String, Object> map1 = new HashMap<String, Object>();
            map1.put("FWFL", FWFL);
            map1.put("SQXJ", serviceFunddetailAssort.getSQXJ());
            map1.put("KSXJ", serviceFunddetailAssort.getKSXJ());
            map1.put("SHXJ", serviceFunddetailAssort.getSHXJ());
            sqljList.add(serviceFunddetailAssort.getSQXJ());
            ksljList.add(serviceFunddetailAssort.getKSXJ());
            shljList.add(serviceFunddetailAssort.getSHXJ());
            lists.add(map1);
        });

        double sqxj = 0;
        double kslj = 0;
        double shlj = 0;
        for (Double sqx : sqljList) {
            sqxj += sqx;
        }
        for (Double ksl : ksljList) {
            kslj += ksl;
        }
        for (Double shl : shljList) {
            shlj += shl;
        }

        //数据封装
        dataMap.put("list", newsList);
        for (int i = 0; i < lists.size(); i++) {
            Map<String, Object> map = lists.get(i);
            map.put("XH", i + 1);
        }

        dataMap.put("item", lists);

        dataMap.put("SQHJ", sq);
        dataMap.put("KSHJ", ks);
        dataMap.put("SHHJ", sh);

        dataMap.put("SQLJ", sqxj);
        dataMap.put("KSLJ", kslj);
        dataMap.put("SHLJ", shlj);

    }

@@ -726,13 +816,13 @@
    @GetMapping(value = "/downloadSH/{id}")
    public Map downloadInfoSH(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataSH(dataMap,id);
        getDataSH(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("捐献者善后成本表.ftl");
@@ -740,14 +830,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "捐献者善后成本表_"+dataMap.get("XM")+"_"+ newTime;
        String name = "捐献者善后成本表_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -757,8 +847,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -781,14 +871,14 @@
        if (fd == null) {
            throw new ServiceException("下载失败，没有对应信息", HttpStatus.NO_CONTENT);
        }
        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double sq = 0;
        double ks = 0;
        double sh = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();
            count++;
            map.put("XH", count);
            map.put("FWNR", f.getItemname() == null ? "" : f.getItemname());
@@ -808,11 +898,11 @@
            newsList.add(map);
        }

        dataMap.put("list",newsList);
        dataMap.put("list", newsList);

        dataMap.put("SQHJ",sq);
        dataMap.put("KSHJ",ks);
        dataMap.put("SHHJ",sh);
        dataMap.put("SQHJ", sq);
        dataMap.put("KSHJ", ks);
        dataMap.put("SHHJ", sh);

    }

@@ -823,13 +913,13 @@
    @GetMapping(value = "/downloadSS/{id}")
    public Map downloadInfoSS(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataSS(dataMap,id);
        getDataSS(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("捐献者家属交通食宿费用表.ftl");
@@ -837,14 +927,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "捐献者家属交通食宿费用表_"+dataMap.get("XM")+"_"+ newTime;
        String name = "捐献者家属交通食宿费用表_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -854,8 +944,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -878,12 +968,12 @@
        if (fd == null) {
            throw new ServiceException("下载失败，没有对应信息", HttpStatus.NO_CONTENT);
        }
        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double hj = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();
            count++;
            map.put("XH", count);
            map.put("FWNR", f.getItemname() == null ? "" : f.getItemname());
@@ -897,8 +987,8 @@
            newsList.add(map);
        }

        dataMap.put("list",newsList);
        dataMap.put("JEHJ",hj);
        dataMap.put("list", newsList);
        dataMap.put("JEHJ", hj);

    }

@@ -909,13 +999,13 @@
    @GetMapping(value = "/downloadYX/{id}")
    public Map downloadInfoYX(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataYX(dataMap,id);
        getDataYX(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("医学成本费用申请单.ftl");
@@ -923,14 +1013,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "医学成本费用申请单_"+dataMap.get("XM")+"_"+ newTime;
        String name = "医学成本费用申请单_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -940,8 +1030,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -961,17 +1051,17 @@
        String date = formatter.format(dt);
        String time = date.substring(0, 10);

        List<Map<String, Object>> newList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newList = new ArrayList<Map<String, Object>>();
        int seqno = 0;

        dataMap.put("TBYYMMDD",time);
        dataMap.put("TBYYMMDD", time);
        dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? "   " : serviceFund.getAttachcount());
        dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname());
        dataMap.put("JSR", serviceFund.getUsername() == null ? "" : serviceFund.getUsername());

        for(ServiceFunddetail f : fd) {
        for (ServiceFunddetail f : fd) {
            seqno++;
            Map<String, Object> map=new HashMap<String, Object>();
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("seqno", seqno);
            String fyxm = "";
            fyxm += f.getItemname() == null ? "" : f.getItemname();
@@ -996,12 +1086,12 @@
        dataMap.put("ZZ", serviceFund.getManagername() == null ? "" : serviceFund.getManagername());


        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double hj = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();
            count++;
            map.put("XH", count);
            map.put("FWNR", f.getItemname() == null ? "" : f.getItemname());
@@ -1028,13 +1118,13 @@
    @GetMapping(value = "/downloadBX/{id}")
    public Map downloadInfoBX(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataBX(dataMap,id);
        getDataBX(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("费用报销单.ftl");
@@ -1042,14 +1132,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "费用报销单_"+dataMap.get("XM")+"_"+ newTime;
        String name = "费用报销单_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -1059,8 +1149,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -1102,7 +1192,7 @@
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("获取费用支出汇总表.ftl");
@@ -1110,14 +1200,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "获取费用支出汇总表_"+dataMap.get("XM")+"_"+ newTime;
        String name = "获取费用支出汇总表_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -1127,8 +1217,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -1140,9 +1230,9 @@
        dataMap.put("JSR", "");

        List<ServiceFunddetail> fd = new ArrayList<>();
        for(ServiceFund s : serviceFunds){
        for (ServiceFund s : serviceFunds) {
            List<ServiceFunddetail> l = serviceFunddetailService.getAllDetailsByFDIDHZ(s.getId());
            for(ServiceFunddetail df : l){
            for (ServiceFunddetail df : l) {
                fd.add(df);
            }
        }
@@ -1258,226 +1348,224 @@
        double sh52 = 0;
        double shhj = 0;

        for(ServiceReimbursement sr : serviceReimbursements1){
        for (ServiceReimbursement sr : serviceReimbursements1) {
            f28 += sr.getAmountrequested();
            sh28 += sr.getAmountrequested();
        }
        for(ServiceReimbursement sr : serviceReimbursements2){
        for (ServiceReimbursement sr : serviceReimbursements2) {
            f51 += sr.getAmountrequested();
            sh51 += sr.getAmountrequested();
        }

        for(ServiceFunddetail s : fd){
            if(s.getItemid() == 1){
        for (ServiceFunddetail s : fd) {
            if (s.getItemid() == 1) {
                f1 += s.getAmount();
                sh1 += s.getTaxedamount();
            }
            if(s.getItemid() == 2){
            if (s.getItemid() == 2) {
                f2 += s.getAmount();
                sh2 += s.getTaxedamount();
            }
            if(s.getItemid() == 3){
            if (s.getItemid() == 3) {
                f3 += s.getAmount();
                sh3 += s.getTaxedamount();
            }
            if(s.getItemid() == 4){
            if (s.getItemid() == 4) {
                f4 += s.getAmount();
                sh4 += s.getTaxedamount();
            }
            if(s.getItemid() == 5){
            if (s.getItemid() == 5) {
                f5 += s.getAmount();
                sh5 += s.getTaxedamount();
            }
            if(s.getItemid() == 6){
            if (s.getItemid() == 6) {
                f6 += s.getAmount();
                sh6 += s.getTaxedamount();
            }
            if(s.getItemid() == 7){
            if (s.getItemid() == 7) {
                f7 += s.getAmount();
                sh7 += s.getTaxedamount();
            }
            if(s.getItemid() == 8){
            if (s.getItemid() == 8) {
                f8 += s.getAmount();
                sh8 += s.getTaxedamount();
            }
            if(s.getItemid() == 9){
            if (s.getItemid() == 9) {
                f9 += s.getAmount();
                sh9 += s.getTaxedamount();
            }
            if(s.getItemid() == 10){
            if (s.getItemid() == 10) {
                f10 += s.getAmount();
                sh10 += s.getTaxedamount();
            }
            if(s.getItemid() == 11){
            if (s.getItemid() == 11) {
                f11 += s.getAmount();
                sh11 += s.getTaxedamount();
            }
            if(s.getItemid() == 12){
            if (s.getItemid() == 12) {
                f12 += s.getAmount();
                sh12 += s.getTaxedamount();
            }
            if(s.getItemid() == 13){
            if (s.getItemid() == 13) {
                f13 += s.getAmount();
                sh13 += s.getTaxedamount();
            }
            if(s.getItemid() == 14){
            if (s.getItemid() == 14) {
                f14 += s.getAmount();
                sh14 += s.getTaxedamount();
            }
            if(s.getItemid() == 15){
            if (s.getItemid() == 15) {
                f15 += s.getAmount();
                sh15 += s.getTaxedamount();
            }
            if(s.getItemid() == 16){
            if (s.getItemid() == 16) {
                f16 += s.getAmount();
                sh16 += s.getTaxedamount();
            }
            if(s.getItemid() == 17){
            if (s.getItemid() == 17) {
                f17 += s.getAmount();
                sh17 += s.getTaxedamount();
            }
            if(s.getItemid() == 18){
            if (s.getItemid() == 18) {
                f18 += s.getAmount();
                sh18 += s.getTaxedamount();
            }
            if(s.getItemid() == 19){
            if (s.getItemid() == 19) {
                f19 += s.getAmount();
                sh19 += s.getTaxedamount();
            }
            if(s.getItemid() == 20){
            if (s.getItemid() == 20) {
                f20 += s.getAmount();
                sh20 += s.getTaxedamount();
            }
            if(s.getItemid() == 21){
            if (s.getItemid() == 21) {
                f21 += s.getAmount();
                sh21 += s.getTaxedamount();
            }
            if(s.getItemid() == 22){
            if (s.getItemid() == 22) {
                f22 += s.getAmount();
                sh22 += s.getTaxedamount();
            }
            if(s.getItemid() == 23){
            if (s.getItemid() == 23) {
                f23 += s.getAmount();
                sh23 += s.getTaxedamount();
            }
            if(s.getItemid() == 24){
            if (s.getItemid() == 24) {
                f24 += s.getAmount();
                sh24 += s.getTaxedamount();
            }
            if(s.getItemid() == 25){
            if (s.getItemid() == 25) {
                f25 += s.getAmount();
                sh25 += s.getTaxedamount();
            }
            if(s.getItemid() == 26){
            if (s.getItemid() == 26) {
                f26 += s.getAmount();
                sh26 += s.getTaxedamount();
            }
            if(s.getItemid() == 27){
            if (s.getItemid() == 27) {
                f27 += s.getAmount();
                sh27 += s.getTaxedamount();
            }

            if(s.getItemid() == 29){
            if (s.getItemid() == 29) {
                f29 += s.getAmount();
                sh29 += s.getTaxedamount();
            }
            if(s.getItemid() == 30){
            if (s.getItemid() == 30) {
                f30 += s.getAmount();
                sh30 += s.getTaxedamount();
            }
            if(s.getItemid() == 31){
            if (s.getItemid() == 31) {
                f31 += s.getAmount();
                sh31 += s.getTaxedamount();
            }
            if(s.getItemid() == 32){
            if (s.getItemid() == 32) {
                f32 += s.getAmount();
                sh32 += s.getTaxedamount();
            }
            if(s.getItemid() == 33){
            if (s.getItemid() == 33) {
                f33 += s.getAmount();
                sh33 += s.getTaxedamount();
            }
            if(s.getItemid() == 34){
            if (s.getItemid() == 34) {
                f34 += s.getAmount();
                sh34 += s.getTaxedamount();
            }
            if(s.getItemid() == 35){
            if (s.getItemid() == 35) {
                f35 += s.getAmount();
                sh35 += s.getTaxedamount();
            }
            if(s.getItemid() == 36){
            if (s.getItemid() == 36) {
                f36 += s.getAmount();
                sh36 += s.getTaxedamount();
            }
            if(s.getItemid() == 37){
            if (s.getItemid() == 37) {
                f37 += s.getAmount();
                sh37 += s.getTaxedamount();
            }
            if(s.getItemid() == 38){
            if (s.getItemid() == 38) {
                f38 += s.getAmount();
                sh38 += s.getTaxedamount();
            }
            if(s.getItemid() == 39){
            if (s.getItemid() == 39) {
                f39 += s.getAmount();
                sh39 += s.getTaxedamount();
            }
            if(s.getItemid() == 40){
            if (s.getItemid() == 40) {
                f40 += s.getAmount();
                sh40 += s.getTaxedamount();
            }
            if(s.getItemid() == 41){
            if (s.getItemid() == 41) {
                f41 += s.getAmount();
                sh41 += s.getTaxedamount();
            }
            if(s.getItemid() == 42){
            if (s.getItemid() == 42) {
                f42 += s.getAmount();
                sh42 += s.getTaxedamount();
            }
            if(s.getItemid() == 43){
            if (s.getItemid() == 43) {
                f43 += s.getAmount();
                sh43 += s.getTaxedamount();
            }
            if(s.getItemid() == 44){
            if (s.getItemid() == 44) {
                f44 += s.getAmount();
                sh44 += s.getTaxedamount();
            }
            if(s.getItemid() == 45){
            if (s.getItemid() == 45) {
                f45 += s.getAmount();
                sh45 += s.getTaxedamount();
            }
            if(s.getItemid() == 46){
            if (s.getItemid() == 46) {
                f46 += s.getAmount();
                sh46 += s.getTaxedamount();
            }
            if(s.getItemid() == 47){
            if (s.getItemid() == 47) {
                f47 += s.getAmount();
                sh47 += s.getTaxedamount();
            }
            if(s.getItemid() == 48){
            if (s.getItemid() == 48) {
                f48 += s.getAmount();
                sh48 += s.getTaxedamount();
            }
            if(s.getItemid() == 49){
            if (s.getItemid() == 49) {
                f49 += s.getAmount();
                sh49 += s.getTaxedamount();
            }

            if(s.getItemid() == 50){
            if (s.getItemid() == 50) {
                f50 += s.getAmount();
                sh50 += s.getTaxedamount();
            }
            if(s.getItemid() == 52){
            if (s.getItemid() == 52) {
                f52 += s.getAmount();
                sh52 += s.getTaxedamount();
            }

        }

        hj = f1 + f2 + f3 + f4 + f5 + f6 + f7 + f8 + f9 + f10 + f11 + f12 + f13 + f14 + f15 + f16 + f17 + f18 + f19 + f20 + f21 + f22 + f23 + f24 + f25 + f26 + f27 + f28 + f29 + f30 + f31 + f32 + f33 + f34 + f35
                + f36 + f37 + f38 + f39 + f40 + f41 + f42 + f43 + f44 + f45 + f46 + f47 + f48 + f49 + f50 + f51 + f52;
        hj = f1 + f2 + f3 + f4 + f5 + f6 + f7 + f8 + f9 + f10 + f11 + f12 + f13 + f14 + f15 + f16 + f17 + f18 + f19 + f20 + f21 + f22 + f23 + f24 + f25 + f26 + f27 + f28 + f29 + f30 + f31 + f32 + f33 + f34 + f35 + f36 + f37 + f38 + f39 + f40 + f41 + f42 + f43 + f44 + f45 + f46 + f47 + f48 + f49 + f50 + f51 + f52;

        shhj = sh1 + sh2 + sh3 + sh4 + sh5 + sh6 + sh7 + sh8 + sh9 + sh10 + sh11 + sh12 + sh13 + sh14 + sh15 + sh16 + sh17 + sh18 + sh19 + sh20 + sh21 + sh22 + sh23 + sh24 + sh25 + sh26 + sh27 + sh28 + sh29 + sh30 + sh31 + sh32 + sh33 + sh34 + sh35
                + sh36 + sh37 + sh38 + sh39 + sh40 + sh41 + sh42 + sh43 + sh44 + sh45 + sh46 + sh47 + sh48 + sh49 + sh50 + sh51 + sh52;
        shhj = sh1 + sh2 + sh3 + sh4 + sh5 + sh6 + sh7 + sh8 + sh9 + sh10 + sh11 + sh12 + sh13 + sh14 + sh15 + sh16 + sh17 + sh18 + sh19 + sh20 + sh21 + sh22 + sh23 + sh24 + sh25 + sh26 + sh27 + sh28 + sh29 + sh30 + sh31 + sh32 + sh33 + sh34 + sh35 + sh36 + sh37 + sh38 + sh39 + sh40 + sh41 + sh42 + sh43 + sh44 + sh45 + sh46 + sh47 + sh48 + sh49 + sh50 + sh51 + sh52;

        dataMap.put("FY1", f1 == 0 ? "" : f1);
        dataMap.put("FY2", f2 == 0 ? "" : f2);
@@ -1531,7 +1619,7 @@
        dataMap.put("FY50", f50 == 0 ? "" : f50);
        dataMap.put("FY51", f51 == 0 ? "" : f51);
        dataMap.put("FY52", f52 == 0 ? "" : f52);
        dataMap.put("FY53", hj  == 0 ? "" : hj);
        dataMap.put("FY53", hj == 0 ? "" : hj);

        dataMap.put("SH1", sh1 == 0 ? "" : sh1);
        dataMap.put("SH2", sh2 == 0 ? "" : sh2);
@@ -1597,13 +1685,13 @@
    @GetMapping(value = "/downloadLWF/{id}")
    public Map downloadInfoLWF(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataLWF(dataMap,id);
        getDataLWF(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("器官获取专家劳务费统计表.ftl");
@@ -1611,14 +1699,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "器官获取专家劳务费统计表_"+dataMap.get("XM")+"_"+ newTime;
        String name = "器官获取专家劳务费统计表_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -1628,8 +1716,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -1653,12 +1741,12 @@
        if (fd == null) {
            throw new ServiceException("下载失败，没有对应信息", HttpStatus.NO_CONTENT);
        }
        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double hj = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();
            count++;
            map.put("XH", count);
            map.put("FWNR", f.getItemname() == null ? "" : f.getItemname());
@@ -1666,12 +1754,12 @@
            map.put("DW", f.getUnitname() == null ? "" : f.getUnitname());
            map.put("ZW", f.getTitle() == null ? "" : f.getTitle());
            map.put("SFZH", f.getIdcardno() == null ? "" : f.getIdcardno());
            map.put("JE", f.getAmount() == 0  ? "" : f.getAmount());
            map.put("JE", f.getAmount() == 0 ? "" : f.getAmount());
            hj += f.getAmount();
            newsList.add(map);
        }

        dataMap.put("list",newsList);
        dataMap.put("list", newsList);

        dataMap.put("HJ", hj);

@@ -1684,13 +1772,13 @@
    @GetMapping(value = "/downloadLL/{id}")
    public Map downloadInfoLL(@PathVariable("id") Long id) throws IOException {
        Map dataMap = new HashMap();
        getDataLL(dataMap,id);
        getDataLL(dataMap, id);
        String filePath = getClass().getResource("/template/").getPath();
        System.out.println(filePath);
        //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet，classpath，数据库教程装载，
        configuration.setDirectoryForTemplateLoading(new File(filePath));

        Template t=null;
        Template t = null;
        try {
            //捐献表.ftl为要装载的模板
            t = configuration.getTemplate("伦理专家劳务费发放申请单.ftl");
@@ -1698,14 +1786,14 @@
            e.printStackTrace();
        }
        String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis());
        String name = "伦理专家劳务费发放申请单_"+dataMap.get("XM")+"_"+ newTime;
        String name = "伦理专家劳务费发放申请单_" + dataMap.get("XM") + "_" + newTime;

        //输出文档路径及名称
        File outFile = new File(RuoYiConfig.getProfile()+"/download/wordtemplate/"+name+".doc");
        File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc");
        Writer out = null;

        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile),"utf-8"));
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"));

        } catch (FileNotFoundException e1) {
            e1.printStackTrace();
@@ -1715,8 +1803,8 @@
        } catch (TemplateException e) {
            e.printStackTrace();
        }
        Map<String ,Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/"+name+".doc");
        Map<String, Object> map = new HashMap<>();
        map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc");
        return map;
    }

@@ -1730,7 +1818,7 @@
        String date = formatter.format(dt);
        String time = date.substring(0, 10);

        dataMap.put("TBYYMMDD",time);
        dataMap.put("TBYYMMDD", time);
        dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? "   " : serviceFund.getAttachcount());
        dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname());
        dataMap.put("JSR", serviceFund.getUsername() == null ? "" : serviceFund.getUsername());
@@ -1751,14 +1839,14 @@
        if (fd == null) {
            throw new ServiceException("下载失败，没有对应信息", HttpStatus.NO_CONTENT);
        }
        List<Map<String, Object>> newsList = new ArrayList<Map<String,Object>>();
        List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
        int count = 0;
        double sq = 0;
        double ks = 0;
        double sh = 0;

        for(ServiceFunddetail f : fd){
            Map<String, Object> map=new HashMap<String, Object>();
        for (ServiceFunddetail f : fd) {
            Map<String, Object> map = new HashMap<String, Object>();
            count++;
            map.put("XH", count);
            map.put("FWNR", f.getItemname() == null ? "" : f.getItemname());
@@ -1770,7 +1858,7 @@
            map.put("KH", f.getBankcardno() == null ? "" : f.getBankcardno());
            map.put("SQ", f.getAmount() == 0.00 ? "" : String.format("%.2f", f.getAmount()).toString() + "");
            sq += f.getAmount();
            map.put("KS", f.getTaxamount() == 0.00 ? "" : String.format("%.2f",f.getTaxamount()).toString() + "");
            map.put("KS", f.getTaxamount() == 0.00 ? "" : String.format("%.2f", f.getTaxamount()).toString() + "");
            ks += f.getTaxamount();
            map.put("SH", f.getTaxedamount() == 0.00 ? "" : String.format("%.2f", f.getTaxedamount()).toString() + "");
            sh += f.getTaxedamount();
@@ -1778,7 +1866,7 @@
            newsList.add(map);
        }

        dataMap.put("list",newsList);
        dataMap.put("list", newsList);

        dataMap.put("SQHJ", String.format("%.2f", sq).toString() + "");
        dataMap.put("KSHJ", String.format("%.2f", ks).toString() + "");
@@ -1795,7 +1883,7 @@
     */
    @ApiOperation("展示费用细节")
    @GetMapping(value = "/showFundDetailOne/{id}")
    public AjaxResult showFundDetailOne(@PathVariable Long id){
    public AjaxResult showFundDetailOne(@PathVariable Long id) {
        ServiceFund serviceFund = serviceFundService.getById(id);
        return AjaxResult.success(serviceFundService.showFundDetailOne(serviceFund));
    }
@@ -1805,7 +1893,7 @@
     */
    @ApiOperation("展示费用细节")
    @GetMapping(value = "/showFundDetailTwo/{infoid}")
    public AjaxResult showFundDetailTwo(@PathVariable Long infoid){
    public AjaxResult showFundDetailTwo(@PathVariable Long infoid) {

        return AjaxResult.success(serviceFundService.showFundDetailTwo(infoid));

@@ -1816,12 +1904,11 @@
     */
    @ApiOperation("费用类型计数")
    @GetMapping(value = "/countItem/{infoid}/{itemid}")
    public AjaxResult countItem(@PathVariable Long infoid, @PathVariable Long itemid){
    public AjaxResult countItem(@PathVariable Long infoid, @PathVariable Long itemid) {

        return AjaxResult.success(serviceFundService.countItem(infoid, itemid));

    }



}