| | |
| | | package com.ruoyi.project.service.impl; |
| | | |
| | | import java.io.File; |
| | | import java.math.BigDecimal; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.ruoyi.project.domain.BaseExpertfeetype; |
| | | import com.ruoyi.project.domain.ServiceFunddetail; |
| | | import com.ruoyi.project.domain.ServiceReimbursement; |
| | | import com.alibaba.fastjson.JSON; |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.ruoyi.common.config.RuoYiConfig; |
| | | import com.ruoyi.common.tax.TaxtUtils; |
| | | import com.ruoyi.common.utils.HttpClientKit; |
| | | import com.ruoyi.common.utils.bean.DtoConversionUtils; |
| | | import com.ruoyi.project.domain.*; |
| | | import com.ruoyi.project.domain.vo.*; |
| | | import com.ruoyi.project.mapper.BaseExpertfeetypeMapper; |
| | | import com.ruoyi.project.mapper.ServiceFunddetailMapper; |
| | | import com.ruoyi.project.mapper.ServiceReimbursementMapper; |
| | | import com.ruoyi.project.mapper.*; |
| | | import com.ruoyi.project.service.IServiceFundSharedService; |
| | | import com.ruoyi.project.service.IServiceFunddetailService; |
| | | import com.ruoyi.project.service.IServiceFunddetailSharedService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.lang3.ObjectUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.project.mapper.ServiceFundMapper; |
| | | import com.ruoyi.project.domain.ServiceFund; |
| | | import com.ruoyi.project.service.IServiceFundService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.CollectionUtils; |
| | | |
| | | /** |
| | | * 费用申请主Service业务层处理 |
| | | * |
| | | * |
| | | * @author ruoyi |
| | | * @date 2022-01-24 |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class ServiceFundServiceImpl extends ServiceImpl<ServiceFundMapper, ServiceFund> implements IServiceFundService |
| | | { |
| | | public class ServiceFundServiceImpl extends ServiceImpl<ServiceFundMapper, ServiceFund> implements IServiceFundService { |
| | | @Autowired |
| | | ServiceFundMapper serviceFundMapper; |
| | | |
| | |
| | | @Autowired |
| | | ServiceReimbursementMapper serviceReimbursementMapper; |
| | | |
| | | @Autowired |
| | | IServiceFundSharedService sharedService; |
| | | |
| | | @Autowired |
| | | ServiceFundSharedMapper serviceFundSharedMapper; |
| | | |
| | | @Autowired |
| | | ServiceFunddetailSharedMapper sharedMapper; |
| | | |
| | | @Autowired |
| | | IServiceFunddetailSharedService detailSharedService; |
| | | |
| | | @Autowired |
| | | private IServiceFunddetailService serviceFunddetailService; |
| | | |
| | | |
| | | /** |
| | | * 查询费用申请主列表 |
| | | * |
| | | * 查询费用申请主列表(包含删除的) |
| | | * |
| | | * @param serviceFund 费用申请主 |
| | | * @return 费用申请主 |
| | | */ |
| | | @Override |
| | | public List<ServiceFund> queryList(ServiceFund serviceFund) { |
| | | LambdaQueryWrapper<ServiceFund> wrappers = Wrappers.lambdaQuery(); |
| | | if (StringUtils.isNotBlank(serviceFund.getDonorno())){ |
| | | wrappers.eq(ServiceFund::getDonorno ,serviceFund.getDonorno()); |
| | | if (StringUtils.isNotBlank(serviceFund.getDonorno())) { |
| | | wrappers.eq(ServiceFund::getDonorno, serviceFund.getDonorno()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceFund.getUserno())){ |
| | | wrappers.eq(ServiceFund::getUserno ,serviceFund.getUserno()); |
| | | if (serviceFund.getId() != null) { |
| | | wrappers.eq(ServiceFund::getId, serviceFund.getId()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceFund.getUsername())){ |
| | | wrappers.like(ServiceFund::getUsername ,serviceFund.getUsername()); |
| | | if (StringUtils.isNotBlank(serviceFund.getUserno())) { |
| | | wrappers.eq(ServiceFund::getUserno, serviceFund.getUserno()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceFund.getApplytype())){ |
| | | wrappers.eq(ServiceFund::getApplytype ,serviceFund.getApplytype()); |
| | | if (StringUtils.isNotBlank(serviceFund.getUsername())) { |
| | | wrappers.like(ServiceFund::getUsername, serviceFund.getUsername()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceFund.getDeptmentname())){ |
| | | wrappers.like(ServiceFund::getDeptmentname ,serviceFund.getDeptmentname()); |
| | | if (StringUtils.isNotBlank(serviceFund.getApplytype())) { |
| | | wrappers.eq(ServiceFund::getApplytype, serviceFund.getApplytype()); |
| | | } |
| | | if (serviceFund.getRecordstatus()!= null){ |
| | | wrappers.eq(ServiceFund::getRecordstatus ,serviceFund.getRecordstatus()); |
| | | if (StringUtils.isNotBlank(serviceFund.getDeptmentname())) { |
| | | wrappers.like(ServiceFund::getDeptmentname, serviceFund.getDeptmentname()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceFund.getUploadflag())){ |
| | | wrappers.eq(ServiceFund::getUploadflag ,serviceFund.getUploadflag()); |
| | | if (serviceFund.getRecordstatus() != null) { |
| | | wrappers.eq(ServiceFund::getRecordstatus, serviceFund.getRecordstatus()); |
| | | } |
| | | if (serviceFund.getUploadtime() != null){ |
| | | wrappers.eq(ServiceFund::getUploadtime ,serviceFund.getUploadtime()); |
| | | if (StringUtils.isNotBlank(serviceFund.getUploadflag())) { |
| | | wrappers.eq(ServiceFund::getUploadflag, serviceFund.getUploadflag()); |
| | | } |
| | | if (serviceFund.getUploadtime() != null) { |
| | | wrappers.eq(ServiceFund::getUploadtime, serviceFund.getUploadtime()); |
| | | } |
| | | if (serviceFund.getFlowlevel() != null) { |
| | | wrappers.eq(ServiceFund::getFlowlevel, serviceFund.getFlowlevel()); |
| | | } |
| | | return this.list(wrappers); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public List<ServiceFund> queryInfoById(ServiceFund serviceFund) { |
| | | LambdaQueryWrapper<ServiceFund> wrappers = Wrappers.lambdaQuery(); |
| | | if (serviceFund.getId() != null) { |
| | | wrappers.eq(ServiceFund::getId, serviceFund.getId()); |
| | | } |
| | | |
| | | wrappers.eq(ServiceFund::getDel_flag, "0"); |
| | | return this.list(wrappers); |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | public Long getFundId(Long infoid) { |
| | | return serviceFundMapper.getFundId(infoid); |
| | | } |
| | | |
| | | @Override |
| | | public List<ServiceFund> selectServiceFundList(ServiceFund serviceFund) { |
| | | return serviceFundMapper.selectServiceFundList(serviceFund); |
| | | @Transactional |
| | | public Boolean addFundSharedInfo(Long id) { |
| | | ServiceFund serviceFund = serviceFundMapper.selectById(id); |
| | | ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class); |
| | | serviceFundShared.setSerfunid(serviceFundShared.getId()); |
| | | serviceFundShared.setId(null); |
| | | log.info("数据都插进去了吗? {}", serviceFundShared); |
| | | sharedService.save(serviceFundShared); |
| | | |
| | | //fundId为主表的ID |
| | | Map<String, Object> columnMap = new HashMap<>(); |
| | | columnMap.put("fundid", id); |
| | | List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.selectByMap(columnMap); |
| | | //将查出的数据放到ServiceFunddetailShared中 |
| | | List<ServiceFunddetailShared> serviceFunddetailShareds = DtoConversionUtils.sourceToTarget(serviceFunddetails, ServiceFunddetailShared.class); |
| | | for (int i = 0; i < serviceFunddetails.size(); i++) { |
| | | serviceFunddetailShareds.get(i).setFdid(serviceFunddetailShareds.get(i).getId()); |
| | | //fundID为service_fund_shared表的主键ID |
| | | serviceFunddetailShareds.get(i).setFundid(serviceFundShared.getId()); |
| | | serviceFunddetailShareds.get(i).setId(null); |
| | | //数据发送给财务 |
| | | uploadOAFileAndUpdateDb(serviceFunddetailShareds.get(i)); |
| | | } |
| | | boolean result = false; |
| | | for (ServiceFunddetailShared serviceFunddetailShared : serviceFunddetailShareds) { |
| | | if (ObjectUtils.isNotEmpty(serviceFunddetailShared)) { |
| | | result = detailSharedService.save(serviceFunddetailShared); |
| | | } else { |
| | | log.info("serviceFunddetailShared为空了!!!"); |
| | | } |
| | | } |
| | | return result; |
| | | } |
| | | |
| | | @Override |
| | | public List<ServiceFunddetail> getFundDetail(Long id) { |
| | | return serviceFunddetailMapper.selectFundDetailListById(id); |
| | | public List<ServiceFund> selectServiceFundList(ServiceFund serviceFund) { |
| | | return serviceFundMapper.selectServiceFundList(serviceFund); |
| | | } |
| | | |
| | | @Override |
| | |
| | | List<ServiceFund> serviceFunds = serviceFundMapper.getInfoByInfoId(infoid); |
| | | |
| | | List<ServiceFunddetail> fd = new ArrayList<>(); |
| | | for(ServiceFund s : serviceFunds){ |
| | | for (ServiceFund s : serviceFunds) { |
| | | List<ServiceFunddetail> l = serviceFunddetailMapper.getAllDetailsByFDIDHZ(s.getId()); |
| | | for(ServiceFunddetail df : l){ |
| | | for (ServiceFunddetail df : l) { |
| | | fd.add(df); |
| | | } |
| | | } |
| | |
| | | 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; |
| | | |
| | | fdvo.setFy1(f1); |
| | | fdvo.setFy2(f2); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<SpFinancialExpensesFundOut> getListBypower(String PAUSERNO, Integer PAFUNDTYPE, String PAAPPLICANT, String PAAPPLICATIONBEGTIME, String PAAPPLICATIONENDTIME, String PADEPARTMENT,Integer CHECKFLAG,Integer APPLYTYPE) { |
| | | return serviceFundMapper.getListBypower(PAUSERNO, PAFUNDTYPE, PAAPPLICANT, PAAPPLICATIONBEGTIME, PAAPPLICATIONENDTIME, PADEPARTMENT,CHECKFLAG,APPLYTYPE); |
| | | public List<SpFinancialExpensesFundOut> getListBypower(String PAUSERNO, Integer PAFUNDTYPE, String PAAPPLICANT, String PAAPPLICATIONBEGTIME, String PAAPPLICATIONENDTIME, String PADEPARTMENT, Integer CHECKFLAG, Integer APPLYTYPE) { |
| | | return serviceFundMapper.getListBypower(PAUSERNO, PAFUNDTYPE, PAAPPLICANT, PAAPPLICATIONBEGTIME, PAAPPLICATIONENDTIME, PADEPARTMENT, CHECKFLAG, APPLYTYPE); |
| | | } |
| | | |
| | | @Override |
| | |
| | | List<ServiceFund> serviceFunds = serviceFundMapper.getInfoByInfoId(infoid); |
| | | |
| | | int count = 0; |
| | | for(ServiceFund s : serviceFunds){ |
| | | for (ServiceFund s : serviceFunds) { |
| | | long fundid = s.getId(); |
| | | int l = serviceFunddetailMapper.countItem(fundid, itemid); |
| | | count += l; |
| | |
| | | return count; |
| | | } |
| | | |
| | | @Override |
| | | @Transactional |
| | | public Long addOrUpdateNew(ServiceFundVO serviceFundVO) { |
| | | Long id = null; |
| | | //将数据保存到fund表 |
| | | if (serviceFundVO.getId() == null) { |
| | | save(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } else { |
| | | updateById(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } |
| | | List<ServiceFunddetailVO> serviceFunddetails = serviceFundVO.getServiceFunddetails(); |
| | | if (CollectionUtils.isEmpty(serviceFunddetails)) { |
| | | System.out.println("serviceFunddetails为空喽"); |
| | | return null; |
| | | } |
| | | // 保存详情数据 |
| | | for (ServiceFunddetailVO serviceFunddetailVO : serviceFunddetails) { |
| | | serviceFunddetailVO.setFundid(id); |
| | | //將附件转成json |
| | | if (!CollectionUtils.isEmpty(serviceFunddetailVO.getAnnexfilesList())) { |
| | | serviceFunddetailVO.setAnnexfiles(JSON.toJSONString(serviceFunddetailVO.getAnnexfilesList())); |
| | | } |
| | | ServiceFunddetail serviceFunddetail = DtoConversionUtils.sourceToTarget(serviceFunddetailVO, ServiceFunddetail.class); |
| | | |
| | | if (serviceFunddetailVO.getId() == null) { |
| | | serviceFunddetailService.save(serviceFunddetail); |
| | | } else { |
| | | serviceFunddetailService.updateById(serviceFunddetail); |
| | | } |
| | | } |
| | | |
| | | return id; |
| | | } |
| | | |
| | | int uploadOAFileAndUpdateDb(ServiceFunddetailShared 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(); |
| | | |
| | | String filePath = RuoYiConfig.getUploadPath(); |
| | | String strFUrl = "http://129.88.242.39:8899/seeyon/rest/attachment?token=" + strRes; |
| | | List<RbDetailFile> parseArray2 = new ArrayList<>(); |
| | | List<RbDetailFile> parseArray = JSON.parseArray(remShare.getAnnexfiles(), RbDetailFile.class); |
| | | log.info("parseArray的值 : {}", parseArray); |
| | | if (!CollectionUtils.isEmpty(parseArray)) { |
| | | for (int i = 0; i < parseArray.size(); i++) { |
| | | RbDetailFile rbDetailFile = parseArray.get(i); |
| | | log.info("filePath的修改:{}", filePath); |
| | | String url = rbDetailFile.getUrl(); |
| | | //file用的是绝对位置 |
| | | String substring = url.substring(url.indexOf("/profile/upload") + "/profile/upload".length()); |
| | | // String strFile = rbDetailFile.getUrl().replace(filePath, "/profile/upload"); |
| | | System.out.println("fund服务的filePath + substring: " + filePath + substring); |
| | | File filetest = new File(filePath + substring); |
| | | |
| | | try { |
| | | String struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); |
| | | log.info("第三方传回的数据: {}", struploadResult); |
| | | if (StringUtils.isEmpty(struploadResult)) { |
| | | log.info("HttpClientKit.sendPostWithFile 请求为空了 filetest:{}, strFUrl:{} ", filetest, strFUrl); |
| | | return 0; |
| | | } |
| | | //获取fileid |
| | | JSONObject jsonR = JSONObject.parseObject(struploadResult); |
| | | JSONArray jsonArr = jsonR.getJSONArray("atts"); |
| | | log.info("第三方传回的数据获取的atts : {}", jsonArr); |
| | | for (int j = 0; j < jsonArr.size(); j++) { |
| | | JSONObject jsonRet = jsonArr.getJSONObject(j); |
| | | rbDetailFile.setFileid(jsonRet.get("fileUrl").toString()); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | parseArray2.add(rbDetailFile); |
| | | } |
| | | remShare.setAnnexfiles(JSON.toJSONString(parseArray2)); |
| | | log.info("ServiceReimbursementdetailShared 是否加上了fileid : {}", remShare); |
| | | } |
| | | 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 = sharedService.updateById(remShare); |
| | | // if (!bRet) return -1; |
| | | // |
| | | // return 0; |
| | | // } |
| | | |
| | | } |