package com.goafanti.expenseAccount.service.impl; import com.alibaba.fastjson.JSONObject; import com.goafanti.admin.bo.AdminListBo; import com.goafanti.admin.service.DepartmentService; import com.goafanti.common.bo.AdminNoticeBo; import com.goafanti.common.bo.EmailBo; import com.goafanti.common.constant.AFTConstants; import com.goafanti.common.dao.*; import com.goafanti.common.enums.NoticeStatus; import com.goafanti.common.enums.NoticeTypes; import com.goafanti.common.error.BusinessException; import com.goafanti.common.model.*; import com.goafanti.common.utils.*; import com.goafanti.common.utils.excel.NewExcelUtil; import com.goafanti.core.mybatis.BaseMybatisDao; import com.goafanti.core.mybatis.JDBCIdGenerator; import com.goafanti.core.mybatis.page.Pagination; import com.goafanti.core.shiro.token.TokenManager; import com.goafanti.expenseAccount.Enums.EAProcessStatus; import com.goafanti.expenseAccount.Enums.EATypes; import com.goafanti.expenseAccount.Enums.EAsecondaryTypes; import com.goafanti.expenseAccount.bo.*; import com.goafanti.expenseAccount.service.ExpenseAccountService; import com.goafanti.organization.bo.OrganizationListOut; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.cache.annotation.CacheEvict; import org.springframework.cache.annotation.Cacheable; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.util.*; import java.util.stream.Collectors; @Service public class ExpenseAccountServiceImpl extends BaseMybatisDao implements ExpenseAccountService { @Autowired private AdminMapper adminMapper; @Autowired private ExpenseAccountMapper expenseAccountMapper; @Autowired private PublicReleaseMapper publicReleaseMapper; @Autowired private ExpenseAccountLogMapper expenseAccountLogMapper; @Autowired private AsyncUtils asyncUtils; @Autowired private WeChatUtils weChatUtils; @Autowired private ExpenseAccountDetailsMapper expenseAccountDetailsMapper; @Autowired private ExpenseAccountPrivateMapper expenseAccountPrivateMapper; @Autowired private ExpenseAccountExamineMapper expenseAccountExamineMapper; @Autowired private JDBCIdGenerator idGenerator; @Autowired private FinanceCountMapper financeCountMapper; @Autowired private ExpenseRelationshipMapper expenseRelationshipMapper; @Autowired private DepartmentService departmentService; @Autowired private DepartmentMapper departmentMapper; @Autowired private ExpenseConfigDetailsMapper expenseConfigDetailsMapper; @Value(value = "${upload.path}") private final String uploadPath = null; @Override public Integer add(InputExpenseAccount in) { //如果关联公出,获取公出信息 if (in.getPrid()!=null){ PublicRelease pr = publicReleaseMapper.selectByPrimaryKey(in.getPrid()); in.setReleaseStart(pr.getReleaseStart()); in.setReleaseEnd(pr.getReleaseEnd()); in.setDistrictName(pr.getDistrictName()); in.setUserNames(pr.getUserNames()); in.setDuration(pr.getDuration()); if (in.getOrderNo()==null)in.setOrderNo(pr.getOrderNo()); } //判断报销类型,0=固定费用,1=报销到订单 if (in.getOrderNo()==null){ in.setTargetType(0); }else { in.setTargetType(1); } if (in.getAid()==null)in.setAid(TokenManager.getAdminId()); Admin admin = adminMapper.selectByPrimaryKey(in.getAid()); in.setAname(admin.getName()); in.setApplyDep(admin.getDepartmentId()); in.setPayDep(admin.getDepartmentId()); expenseAccountMapper.insertSelective(in); return in.getId(); } /** * 新增报销审核流程 */ private void addExpenseAccountExamine(Integer id,ExpenseAccount ea) { List list=new ArrayList<>(); expenseAccountExamineMapper.deleteByEaid(ea.getId()); String aid = TokenManager.getAdminId(); OrganizationListOut dep = departmentMapper.selectAllById(ea.getApplyDep()); AdminNoticeBo a = adminMapper.selectMyAndSuperBySuperId(aid); //暂时只发起到财务 for (int i=1;i<4;i++){ ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i); if (i==1){ if (a.getExpenseSuperExamine()==1){ //新增一级 String examineId=null; String examineName=null; //正常用上级,没有的情况下就是自己 if (a.getSuperId()!=null){ examineId=a.getSuperId(); examineName=a.getSuperName(); }else { examineId=a.getId(); examineName=a.getName(); } eae.setAuditor(examineId); eae.setAuditorname(examineName); ea.setExamineName(examineName); } if(a.getExpenseSuperExamine()==1){ eae.setStatus(0); }else { eae.setStatus(1); } }else if (i==2){ if (StringUtils.isBlank(dep.getManagerName())){ throw new BusinessException("报销申请部门[管理员]不存在。"); } eae.setAuditor(dep.getManagerId()); eae.setAuditorname(dep.getManagerName()); }else if (i==3){ if (StringUtils.isBlank(dep.getExpenseFinanceName()))throw new BusinessException("报销部门财务审核人不存在。"); eae.setAuditor(dep.getExpenseFinanceId()); eae.setAuditorname(dep.getExpenseFinanceName()); } if (StringUtils.isNotEmpty(eae.getAuditor())){ if (eae.getAuditor().equals(aid))eae.setStatus(1); else eae.setStatus(0); list.add(eae); } } expenseAccountExamineMapper.insertBatch(list); } /** * 新增报销日志 * @param eaid 报销编号 * @param status 状态 0发起 1通过 2完成 3驳回 4修改 * @param str 备注 */ private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str) { addExpenseAccountLog(eaid,status,processStatus,aid,str,null); } private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str,Date date){ addExpenseAccountLog(eaid,status,processStatus,aid,str,date,null); } /** * 新增报销日志 * @param eaid 报销编号 * @param status 状态 0发起 1通过 2完成 3驳回 4修改 * @param str 备注 */ private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str,Date date,Integer showStatus) { ExpenseAccountLog eaLog=new ExpenseAccountLog(); eaLog.setEaid(eaid); eaLog.setStatus(status); eaLog.setRemarks(str); eaLog.setProcessStatus(processStatus); eaLog.setAuditor(aid); if (showStatus!=null){ eaLog.setShowStatus(showStatus); }else { eaLog.setShowStatus(0); } if (date !=null)eaLog.setCreateTime(date); expenseAccountLogMapper.insertSelective(eaLog); } /** * 发起、驳回发起流程切换和日志站内信发送 */ private void addExpenseAccountLogAndNoticEmail(ExpenseAccount in, Integer status, String str) { String aid=TokenManager.getAdminId(); addExpenseAccountLog(in.getId(),status,in.getProcessStatus(),aid,str); if (status==0)in.setProcessStatus(1); Admin admin = adminMapper.selectByPrimaryKey(aid); if (admin.getExpenseSuperExamine()==0){ String str2=String.format("未设置[%s]审核。",EAProcessStatus.getDesc(in.getProcessStatus())); Date date=new Date(); date.setTime(date.getTime()+1000L); addExpenseAccountLog(in.getId(),1,in.getProcessStatus(),aid,str2,date,2); in.setProcessStatus(in.getProcessStatus()+1); }else { if (admin.getSuperiorId()==null||admin.getId().equals(admin.getSuperiorId())){ String str2=String.format("%s跳过[%s]。",admin.getSuperiorId()==null?"发起人无上级":"发起人与上级同人",EAProcessStatus.getDesc(in.getProcessStatus())); Date date=new Date(); date.setTime(date.getTime()+1000L); addExpenseAccountLog(in.getId(),1,in.getProcessStatus(),aid,str2,date,2); in.setProcessStatus(in.getProcessStatus()+1); } } createExamineByProcess(in); } /** * 判断审核流程与发送日志与邮件 */ private void createExamineByProcess(ExpenseAccount in) { //审核流程推送到最新 AdminListBo admin = adminMapper.getDeptNameByAid(in.getAid()); OrganizationListOut dep = departmentMapper.selectAllById(in.getApplyDep()); List configDetailsList = expenseConfigDetailsMapper.selectByDepId(in.getApplyDep()); if (in.getApproval()==null)in.setApproval(0); examineByprocess(in,admin,dep,configDetailsList); List list=expenseAccountExamineMapper.selectByEaidAndProcessStatus(in.getId(), in.getProcessStatus()); List aids=new ArrayList<>(); StringBuffer aname =new StringBuffer(); for (ExpenseAccountExamine e : list) { if (e.getProcessStatus()==in.getProcessStatus()&&e.getStatus()==0){ Admin ad = adminMapper.selectByPrimaryKey(e.getAuditor()); aids.add(ad); aname=aname.append(ad.getName()).append(","); } } in.setExamineName(aname.substring(0,aname.length()-1)); StringBuffer str=new StringBuffer().append("编号[").append(in.getCheckNo()).append("]需要审核").append(",请查看并审核。"); addNoticeAndEmail(in, EAProcessStatus.SJSH.getCode(),str.toString(), admin.getName(),aids); } @Override @Transactional public int update(InputExpenseAccount in) { OutExpenseAccount useEA = expenseAccountMapper.selectByid(in.getId()); if (useEA.getStatus()!=0&&useEA.getStatus()!=3){ throw new BusinessException("不能操作审核中与完成的订单"); } if (in.getStartTimeStr()!=null&&in.getEndTimeStr()!=null){ in.setReleaseStart(DateUtils.StringToDate(in.getStartTimeStr(), AFTConstants.YYYYMMDDHHMMSS)); in.setReleaseEnd(DateUtils.StringToDate(in.getEndTimeStr(), AFTConstants.YYYYMMDDHHMMSS)); } //计算总金额 if (in.getTotalAmount()==null){ pushExpenseAccountAmount(in); } in.setProcessStatus(0); if (in.getOrderNo()==null){ in.setTargetType(0); }else { in.setTargetType(1); } //计算本单已扣金额 如果有选择借支单,则需要修改借支状态 if (in.getDebitId()!=null){ //如果以前没有选择借支,修改报销和借支数据 if (useEA.getDebitId()==null){ pushExpenseAccountDebit(in); }else if (useEA.getDebitId()!=in.getDebitId()) { //如果是修改编号 pushExpenseAccountDebit(in); //并且要处理原编号的问题 pushResettingDebit(in,useEA.getDebitId()); } } if (in.getSettlementAmount()==null)in.setSettlementAmount(useEA.getSettlementAmount()); in.setStatus(0); return expenseAccountMapper.updateByPrimaryKeySelective(in); } private void pushExpenseAccountAmount(ExpenseAccount in) { OutExpenseAccount useEA = expenseAccountMapper.selectByid(in.getId()); List list = expenseAccountDetailsMapper.selectByEAid(in.getId()); BigDecimal totalAmount = BigDecimal.ZERO; BigDecimal realAmount = BigDecimal.ZERO; for (OutExpenseAccountDetails e : list) { totalAmount=totalAmount.add(e.getAmount()); realAmount=realAmount.add(e.getRealAmount()); } in.setTotalAmount(totalAmount); if (useEA==null||useEA.getSettlementAmount()==null){ in.setAmount(realAmount); }else { in.setAmount(realAmount.subtract(useEA.getSettlementAmount())); } in.setRealAmount(in.getAmount()); } @Override public Object updateDebitId(InputExpenseAccount in) { OutExpenseAccount useEA = expenseAccountMapper.selectByid(in.getId()); if (useEA.getDebitId()!=null)pushResettingDebit(in,useEA.getDebitId()); expenseAccountMapper.updateDeleteDebitId(in.getId()); return 1; } @Override public Object delete(String ids) { String[] split = ids.split(","); for (String s : split) { Integer id=Integer.valueOf(s); ExpenseAccount expenseAccount = expenseAccountMapper.selectByPrimaryKey(id); if (expenseAccount.getStatus()!=0&&expenseAccount.getStatus()!=3){ throw new BusinessException("该费用单状态无法删除"); } List logs = expenseAccountLogMapper.selectByEaid(id); if (logs.isEmpty()){ expenseAccountMapper.deleteByPrimaryKey(id); }else { ExpenseAccount update =new ExpenseAccount(); update.setId(id); update.setStatus(4); expenseAccountMapper.updateByPrimaryKeySelective(update); } } return 1; } @Override public Object pageListExport(InputPageListBo in) { List list = (List) pageList(in).getList(); for (OutExpenseAccountBo e : list) { if (e.getType()!=0){ e.setTypeOther(EATypes.getDescByCode(e.getType())); }else{ e.setTypeOther(String.format("其他(%s)",e.getTypeOther())); } } NewExcelUtil excelUtil=new NewExcelUtil(OutExpenseAccountBo.class); return excelUtil.exportExcel(list,"费用单列表",uploadPath); } @Override public Object detailsListExport(InputDetailsListBo in) { List list = (List) detailsList(in).getList(); for (OutExpenseAccountDetailsList e : list) { if (e.getTargetType()!=null){ if (e.getTargetType()==0){ e.setTargetName("固定费用"); }else { e.setTargetName(e.getContractNo()+"/"+e.getBuyerName()); } } if (e.getType()!=0){ e.setTypeOther(EAsecondaryTypes.getDescByCode(e.getType())); }else{ //如果是其他,又说明显示说明,没有说明显示费用类型 if (StringUtils.isBlank(e.getTypeOther())){ if (e.getSonType()!=0){ e.setTypeOther(EATypes.getDescByCode(e.getSonType())); }else{ e.setTypeOther(String.format("其他(%s)",e.getSonTypeOther())); } }else { e.setTypeOther(String.format("其他(%s)",e.getTypeOther())); } } } NewExcelUtil excelUtil=new NewExcelUtil(OutExpenseAccountDetailsList.class); return excelUtil.exportExcel(list,"费用详细列表",uploadPath); } @Override public Object getDepDetails(Integer id) { OutExpenseAccount outExpenseAccount = expenseAccountMapper.selectByid(id); OrganizationListOut organizationListOut = departmentMapper.selectAllById(outExpenseAccount.getApplyDep()); return organizationListOut; } @Override public Object updateTypeOther(Integer id, String typeOther,String remarks,String orderNo) { ExpenseAccount ea = new ExpenseAccount(); ea.setId(id); if (StringUtils.isNotEmpty(typeOther))ea.setTypeOther(typeOther); if (StringUtils.isNotEmpty(remarks))ea.setRemarks(remarks); if (StringUtils.isNotEmpty(orderNo))ea.setOrderNo(orderNo); expenseAccountMapper.updateByPrimaryKeySelective(ea); if (StringUtils.isNotEmpty(typeOther)){ MainExpenseAccount mainExpenseAccount = expenseAccountMapper.selectbySonId(id); StringBuffer types=new StringBuffer(); for (SonExpenseAccount e : mainExpenseAccount.getSonList()) { if (e.getType()!=0){ types=types.append(EATypes.getDescByCode(e.getType())); }else { types=types.append(e.getTypeOther()); } if (e.getType()==2){ if (e.getSecondaryType()==0){ types=types.append("-").append(e.getSecondaryTypeOther()); }else{ String descByCode = EAsecondaryTypes.getDescByCode(e.getSecondaryType()); types=types.append("-").append(descByCode); } } types=types.append(","); } expenseAccountMapper.updateSonTypeOther(id,types.substring(0,types.length()-1)); } return 1; } private void pushResettingDebit(InputExpenseAccount in, Integer debitId) { ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(debitId); List list = expenseAccountMapper.selectByDebitId(debitId); ExpenseAccount newDebit=new ExpenseAccount(); newDebit.setId(debitId); //计算除开当前单,已选择抵扣金额 BigDecimal count=new BigDecimal(0); for (ExpenseAccount e : list) { if (!in.getId().equals(e.getId())){ count=count.add(e.getSettlementAmount()); } } newDebit.setSettlementAmount(count); if (count.compareTo(new BigDecimal(0))==0){ newDebit.setLiquidationStatus(0); }else if (count.compareTo(debit.getRealAmount())<0){ newDebit.setLiquidationStatus(1); }else if (count.compareTo(debit.getRealAmount())==0){ newDebit.setLiquidationStatus(2); } expenseAccountMapper.updateByPrimaryKeySelective(newDebit); } private void pushExpenseAccountDebit(InputExpenseAccount in) { ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(in.getDebitId()); ExpenseAccount newDebit=new ExpenseAccount(); newDebit.setId(debit.getId()); //计算剩余需要支付金额 BigDecimal decbitAmount=debit.getRealAmount().subtract(debit.getSettlementAmount()); //本次金额大于等于需要抵扣金额,则变成完全抵扣,抵扣金额变成本次已付金额 if (in.getRealAmount().compareTo(decbitAmount)>=0){ in.setSettlementAmount(decbitAmount); newDebit.setSettlementAmount(debit.getRealAmount()); newDebit.setLiquidationStatus(2); }else { // 本次金额小于需要抵扣,则本次变更全抵扣,借支已付加上本次金额 in.setSettlementAmount(in.getRealAmount()); BigDecimal setAmount=new BigDecimal(0).add(debit.getSettlementAmount()).add(in.getRealAmount()); newDebit.setSettlementAmount(setAmount); newDebit.setLiquidationStatus(1); } expenseAccountMapper.updateByPrimaryKeySelective(newDebit); } @Override public int addDetails(InputExpenseAccountDetails in) { if (in.getAgreeTimes()!=null){ in.setAgreeTime(DateUtils.StringToDate(in.getAgreeTimes(),AFTConstants.YYYYMMDD)); } ExpenseAccount expenseAccount = expenseAccountMapper.selectByPrimaryKey(in.getEaid()); if (expenseAccount.getType()==2){ in.setType(expenseAccount.getSecondaryType()); if (in.getType()==0){ in.setTypeOther(expenseAccount.getSecondaryTypeOther()); } } in.setRealAmount(in.getAmount()); expenseAccountDetailsMapper.insertSelective(in); ExpenseAccount ea =new ExpenseAccount(); ea.setId(in.getEaid()); pushExpenseAccountAmount(ea); expenseAccountMapper.updateByPrimaryKeySelective(ea); return 1; } @Override public int deleteDetails(Integer id) { expenseAccountDetailsMapper.deleteByPrimaryKey(id); ExpenseAccount ea =new ExpenseAccount(); ea.setId(id); pushExpenseAccountAmount(ea); expenseAccountMapper.updateByPrimaryKeySelective(ea); return 1; } @Override public List detailsList(Integer eaid) { return expenseAccountDetailsMapper.selectByEAid(eaid); } @Override public Object logList(Integer eaid) { List list = expenseAccountLogMapper.selectByEaid(eaid); if (!list.isEmpty()) { OutExpenseAccountLog lastout = list.get(list.size() - 1); ExpenseAccount expenseAccount = expenseAccountMapper.selectByPrimaryKey(eaid); Integer processStatus = lastout.getProcessStatus(); if (lastout.getStatus() < 2) { if (processStatus <3){ List outExpenseAccountLogs = expenseAccountExamineMapper.selectNotExamineByEaidAndProcessStatus(eaid, processStatus); list.addAll(outExpenseAccountLogs); }else { List expenseAccountExamines = expenseAccountExamineMapper.selectByEaidAndProcessStatus(eaid, processStatus); for (ExpenseAccountExamine e : expenseAccountExamines) { if (e.getStatus()==0){ OutExpenseAccountLog out =new OutExpenseAccountLog(); out.setEaid(eaid); out.setProcessStatus(e.getProcessStatus()); out.setAuditorName(e.getAuditorname()); list.add(out); } } } if (processStatus<8)addDetailsLog(list, expenseAccount,processStatus); } } return list; } private void addDetailsLog(List list, ExpenseAccount expenseAccount,Integer useStatus) { OrganizationListOut dep = departmentMapper.selectAllById(expenseAccount.getApplyDep()); List configDetails = expenseConfigDetailsMapper.selectByDepId(expenseAccount.getApplyDep()); for (int processStatus = useStatus; processStatus < 8; processStatus++) { if (processStatus ==3){ if (dep.getExpenseRetrialFinanceExamine()==1){ List collect = configDetails.stream().filter(e -> e.getType() == 1).collect(Collectors.toList()); for (ExpenseConfigDetails e : collect) { addDetailsTypeLog(list, expenseAccount, e); } } }else if (processStatus ==4){ if (expenseAccount.getApproval()==1&&dep.getCeoExamine()==1){ List collect = configDetails.stream().filter(e -> e.getType() == 2).collect(Collectors.toList()); for (ExpenseConfigDetails e : collect) { addDetailsTypeLog(list, expenseAccount, e); } } }else if (processStatus ==5){ if (dep.getCfoExamine()==1){ List collect = configDetails.stream().filter(e -> e.getType() == 3).collect(Collectors.toList()); for (ExpenseConfigDetails e : collect) { addDetailsTypeLog(list, expenseAccount, e); } } }else if (processStatus ==6){ if (dep.getViceCeoExamine()==1){ List collect = configDetails.stream().filter(e -> e.getType() == 4).collect(Collectors.toList()); for (ExpenseConfigDetails e : collect) { addDetailsTypeLog(list, expenseAccount, e); } } }else if (processStatus ==7){ if (dep.getCashierExamine()==1){ List collect = configDetails.stream().filter(e -> e.getType() == 5).collect(Collectors.toList()); for (ExpenseConfigDetails e : collect) { addDetailsTypeLog(list, expenseAccount, e); } } } } } private static void addDetailsTypeLog(List list, ExpenseAccount expenseAccount, ExpenseConfigDetails e) { OutExpenseAccountLog addLog=new OutExpenseAccountLog(); addLog.setEaid(expenseAccount.getId()); addLog.setAuditor(e.getAid()); addLog.setAuditorName(e.getAdminName()); list.add(addLog); } @Override public int updateExamine(InputExpenseAccount in) { ExpenseAccount useEa = expenseAccountMapper.selectByPrimaryKey(in.getId()); ExpenseAccount newEa=new ExpenseAccount(); newEa.setId(useEa.getId()); newEa.setApproval(in.getApproval()); in.setCheckNo(useEa.getCheckNo()); in.setProcessStatus(useEa.getProcessStatus()); //审核通知 获取发送人 AdminListBo admin = adminMapper.getDeptNameByAid(useEa.getAid()); //项目推送流程及添加日志 addExamineExpenseAccountLog(admin,in, useEa, newEa); //完成申请 if (newEa.getStatus()==2){ //如果是借支则订单新增 List expenseAccounts1 = expenseAccountMapper.selectListByMainId(in.getId()); for (ExpenseAccount e : expenseAccounts1) { if (e.getType()!=4){ //不然就看是否挂载借支订单进行抵扣 if (e.getDebitId()!=null){ ExpenseAccount useDebit=expenseAccountMapper.selectByPrimaryKey(e.getDebitId()); if (useDebit.getLiquidationStatus()==2){ List expenseAccounts = expenseAccountMapper.selectByDebitId(e.getDebitId()); boolean flag=true; for (ExpenseAccount expenseAccount : expenseAccounts) { if(!expenseAccount.getId().equals(in.getId())&&expenseAccount.getStatus()!=2){ flag=false; break; } } if (flag){ ExpenseAccount debit=new ExpenseAccount(); debit.setId(e.getDebitId()); debit.setLiquidationStatus(3); expenseAccountMapper.updateByPrimaryKeySelective(debit); } } } } ExpenseAccount updateSon=new ExpenseAccount(); updateSon.setId(e.getId()); updateSon.setStatus(2); expenseAccountMapper.updateByPrimaryKeySelective(updateSon); } }else if (newEa.getStatus()==1){ if (newEa.getProcessStatus()==EAProcessStatus.BMFZRSH.getCode()){ pushFinanceCount(admin.getDepFinance(),useEa.getCreateTime(),0); //处理金额修改 if(in.getRealList()!=null){ List maps = JSONObject.parseArray(in.getRealList(), Map.class); for (Map map: maps) { Integer type= (Integer) map.get("type"); Integer id= (Integer) map.get("id"); BigDecimal amount= new BigDecimal(map.get("amount").toString()); //type=1总计,type=2报销金额 if(type==1){ ExpenseAccount ea =new ExpenseAccount(); ea.setId(id); ea.setRealAmount(amount); expenseAccountMapper.updateByPrimaryKeySelective(ea); }else if (type==2){ ExpenseAccountDetails ead=new ExpenseAccountDetails(); ead.setId(id); ead.setRealAmount(amount); expenseAccountDetailsMapper.updateByPrimaryKeySelective(ead); } } } }else if (newEa.getProcessStatus()==EAProcessStatus.CWSH.getCode()){ pushFinanceCount(admin.getDepFinance(),useEa.getCreateTime(),1); } }else if (newEa.getStatus()==3){ if (useEa.getProcessStatus()==EAProcessStatus.BMFZRSH.getCode()){ pushFinanceCount(admin.getDepFinance(),useEa.getCreateTime(),2); }else if (newEa.getProcessStatus()>EAProcessStatus.CWSH.getCode()){ pushFinanceCount(admin.getDepFinance(),useEa.getCreateTime(),3); } expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),null,0,0); } expenseAccountMapper.updateByPrimaryKeySelective(newEa); expenseAccountMapper.updateSonByMainId(newEa.getId()); return 1; } private void addFinanceCount(String aid,Date startTime ) { String forDate=DateUtils.formatDate(startTime,AFTConstants.YYYYMMDD); addFinanceCount(aid,forDate); } private void addFinanceCount(String aid,String startTime ) { FinanceCount financeCount = financeCountMapper.selectByAidAndDates(aid, startTime); if (financeCount ==null){ financeCount =FinanceCount.initialization(aid, startTime); financeCount.setExpenseCount(1); financeCount.setExpenseUnauditedCount(1); financeCountMapper.insertSelective(financeCount); }else { FinanceCount newFinanceCount =new FinanceCount(); newFinanceCount.setId(financeCount.getId()); newFinanceCount.setExpenseCount(financeCount.getExpenseCount()+1); newFinanceCount.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()+1); financeCountMapper.updateByPrimaryKeySelective(newFinanceCount); } } private void addExamineExpenseAccountLog(AdminListBo admin,InputExpenseAccount in, ExpenseAccount useEa, ExpenseAccount newEa) { List aids=new ArrayList<>(); StringBuffer str=new StringBuffer(); Integer status=in.getStatus(); if (status==1){ //审核处理审核表 expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),TokenManager.getAdminId(),1,0); str=str.append("编号[").append(in.getCheckNo()).append("]需要审核").append(",请查看并审核。"); newEa.setAid(useEa.getAid()); newEa.setCreateTime(useEa.getCreateTime()); newEa.setApplyDep(useEa.getApplyDep()); //在跳入董事长审核的时候非特批直接跳过,原则上下个流程不可再跳过 OrganizationListOut dep = departmentMapper.selectAllById(newEa.getApplyDep()); List configDetailsList = expenseConfigDetailsMapper.selectByDepId(newEa.getApplyDep()); if(useEa.getProcessStatus()==EAProcessStatus.CNSH.getCode()){ expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),TokenManager.getAdminId(),1,1); boolean expenseExamine = pushExpenseExamine(configDetailsList, newEa, EAProcessStatus.CNSH.getCode()); if (expenseExamine){ //完成后的流程 status =2; aids.add(adminMapper.selectByPrimaryKey(admin.getId())); newEa.setStatus(status); newEa.setExamineName(""); }else { status =1; List list=expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), useEa.getProcessStatus()); StringBuffer aname =new StringBuffer(); for (ExpenseAccountExamine e : list) { if (e.getStatus()==0){ Admin ad=adminMapper.selectByPrimaryKey(e.getAuditor()); aids.add(ad); aname=aname.append(ad.getName()).append(","); } } newEa.setExamineName(aname.substring(0,aname.length()-1)); } addExpenseAccountLog(in.getId(),status,useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason()); }else { addExpenseAccountLog(in.getId(),status,useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason()); newEa.setStatus(1); //小于为固定单审核,大于可能被配置多人审核 if (useEa.getProcessStatus() aids) { List list=expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), newEa.getProcessStatus()); StringBuffer aname =new StringBuffer(); for (ExpenseAccountExamine e : list) { if (e.getProcessStatus()== newEa.getProcessStatus()&&e.getStatus()==0){ Admin ad=adminMapper.selectByPrimaryKey(e.getAuditor()); aids.add(ad); aname=aname.append(ad.getName()).append(","); } } newEa.setExamineName(aname.substring(0,aname.length()-1)); } /** * * @param aid * @param createTime * @param type 0 双新增 1 未审核减一 2双减 3总数减一 */ private void pushFinanceCount(String aid, Date createTime, Integer type) { String startTime= DateUtils.formatDate(createTime,AFTConstants.YYYYMMDD); FinanceCount financeCount = financeCountMapper.selectByAidAndDates(aid, startTime); FinanceCount newFinance=new FinanceCount(); if (financeCount==null){ newFinance=FinanceCount.initialization(aid,createTime); newFinance.setExpenseCount(1); newFinance.setExpenseUnauditedCount(1); financeCountMapper.insertSelective(newFinance); }else { newFinance.setId(financeCount.getId()); if(type==0){ newFinance.setExpenseCount(financeCount.getExpenseCount()+1); newFinance.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()+1); }else if(type==1){ newFinance.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()-1); }else if(type==2){ newFinance.setExpenseCount(financeCount.getExpenseCount()-1); newFinance.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()-1); }else if(type==3){ newFinance.setExpenseCount(financeCount.getExpenseCount()-1); } financeCountMapper.updateByPrimaryKeySelective(newFinance); } } /** * 审核流程推送,只要不是完成状态就继续判断是否跳过 * @param newEa */ private void examineByprocess( ExpenseAccount newEa,AdminListBo admin,OrganizationListOut dep,List list) { List examineList=new ArrayList<>(); //小于财务复审的,走单审核 if (newEa.getProcessStatus()0){ for (ExpenseAccountExamine e : examineList) { if (e.getStatus()==1){ flag=true; aid=e.getAuditor(); break; } } } //如果当前审核人已经审核,则跳过当前审核 if (flag){ String str=String.format("重复审核人跳过[%s]。",EAProcessStatus.getDesc(newEa.getProcessStatus())); Date date=new Date(); date.setTime(date.getTime()+1000l); addExpenseAccountLog(newEa.getId(),1,newEa.getProcessStatus(),aid,str,date,2); if (newEa.getProcessStatus()==EAProcessStatus.BMFZRSH.getCode()){ addFinanceCount(admin.getDepFinance(),newEa.getCreateTime()); } newEa.setProcessStatus(newEa.getProcessStatus()+1); examineByprocess(newEa,admin,dep,list); } }else { //大于等于财务复审的,走多审核 String str=null; //跳过标记 boolean flag2= false; //审核通过标记 boolean flag3= false; Date date2=new Date(); date2.setTime(date2.getTime()+1000l); String tip=null; String aid=null; if (newEa.getProcessStatus()==EAProcessStatus.CWFS.getCode()){ //财务复审财务复审 if (dep.getExpenseRetrialFinanceExamine()==0){ flag2=true; tip=EAProcessStatus.CWFS.getDesc(); }else { boolean expenseExamine = pushExpenseExamine(list, newEa, EAProcessStatus.CWFS.getCode()); if (expenseExamine){ flag3=true; } } }else if (newEa.getProcessStatus()==EAProcessStatus.DSZSH.getCode()){ if (newEa.getApproval()!=1){ flag2=true; tip="特批(财务选择)"; }else { if (dep.getCeoExamine()==1){ boolean expenseExamine = pushExpenseExamine(list, newEa, EAProcessStatus.DSZSH.getCode()); if (expenseExamine){ flag3=true; } }else { flag2=true; tip="特批(部门设置)"; } } }else if (newEa.getProcessStatus()==EAProcessStatus.CWGGLYSH.getCode()){ if (dep.getExpenseRetrialFinanceExamine()==0){ flag2=true; tip=EAProcessStatus.CWGGLYSH.getDesc(); aid=null; }else { boolean expenseExamine = pushExpenseExamine(list, newEa, EAProcessStatus.CWGGLYSH.getCode()); if (expenseExamine){ flag3=true; } } }else if (newEa.getProcessStatus()==EAProcessStatus.GSFSSH.getCode()){ if (dep.getExpenseRetrialFinanceExamine()==0){ flag2=true; tip=EAProcessStatus.GSFSSH.getDesc(); }else { boolean expenseExamine = pushExpenseExamine(list, newEa, EAProcessStatus.GSFSSH.getCode()); if (expenseExamine){ flag3=true; } } }else if (newEa.getProcessStatus()==EAProcessStatus.CNSH.getCode()){ if (dep.getExpenseRetrialFinanceExamine()==0){ flag2=true; tip=EAProcessStatus.CNSH.getDesc(); }else { //财务出纳在审核时不与前置审核做同步 pushExpenseExamine(list, newEa, EAProcessStatus.CNSH.getCode()); } } if (flag2){ if (str==null)str=String.format("未设置[%s]审核,跳过此流程",tip); if (newEa.getProcessStatus() list, ExpenseAccount newEa, Integer status) { int configDetails=0; if (status==EAProcessStatus.CWFS.getCode())configDetails=1; else if (status==EAProcessStatus.DSZSH.getCode())configDetails=2; else if (status==EAProcessStatus.CWGGLYSH.getCode())configDetails=3; else if (status==EAProcessStatus.GSFSSH.getCode())configDetails=4; else if (status==EAProcessStatus.CNSH.getCode())configDetails=5; int finalConfigDetails = configDetails; //查询审核表,如果为空就新增,不然直接判定审核 List expenseAccountExamines = expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), status); int count = 0; int size=10; if (expenseAccountExamines.isEmpty()){ List collect = list.stream().filter(e -> e.getType() == finalConfigDetails).collect(Collectors.toList()); size= collect.size(); for (ExpenseConfigDetails e : collect) { ExpenseAccountExamine eae=new ExpenseAccountExamine(newEa.getId(),status); eae.setAuditor(e.getAid()); eae.setAuditorname(e.getAdminName()); eae.setStatus(0); Integer i = expenseAccountExamineMapper.selectYesByParam(newEa.getId(), e.getAid()); if (status==EAProcessStatus.CNSH.getCode()){ eae.setStatus(0); count++; }else { if (i>0||e.getAid().equals(TokenManager.getAdminId())) { eae.setStatus(1); count++; } } expenseAccountExamineMapper.insertSelective(eae); } }else { size = expenseAccountExamines.size(); for (ExpenseAccountExamine e : expenseAccountExamines) { if (e.getStatus()==1){ count++; } } } if (count==size){ return true; } return false; } private void addNoticeAndEmail(ExpenseAccount in, Integer status, String str,String aname, List aids) { Date date= new Date(); Integer noticeStatus=NoticeStatus.EXPENSE_NOTICE.getCode(); if (status==2){ noticeStatus=NoticeStatus.EXPENSE_COMPLETE.getCode(); str="您提交的费用报销单已通过审核,请及时查看。"; } List list=new ArrayList<>(); if (aids!=null){ for (Admin a : aids) { Notice notice=new Notice(); notice.setId(UUID.randomUUID().toString()); notice.setNoticeType(noticeStatus); notice.setType(NoticeTypes.getType(noticeStatus)); notice.setAid(a.getId()); notice.setCreateTime(date); notice.setContent(str); notice.setReaded(0); list.add(notice); EmailBo emailBo=new EmailBo(NoticeStatus.getValueByCode(noticeStatus),a.getEmail(),str); asyncUtils.send(emailBo); try { weChatUtils.addExpenseAccountWeChatNotice(a.getExpenseOpenId(),status,in.getId(),date,aname,str); }catch (Exception e){ throw new BusinessException("网络通信异常,请稍后再试。"); } } asyncUtils.addNoticeBatch(list); } } @Override public Pagination pageList(InputPageListBo in) { Map param=new HashMap<>(); addParam(in, param); Pagination pagePlus = findPagePlus("selectExpenseAccountList", "selectExpenseAccountCount", "selectExpenseAccountTotalAmount", param, in.getPageNo(), in.getPageSize()); List list = (List) pagePlus.getList(); for (OutExpenseAccountBo e : list) { e.setExamine(pushExpenseAccountGetExamine(e.getId(), e.getProcessStatus())); } return pagePlus; } @Override public Object selectByPrid(InputExpenseAccount in) { in.setAid(TokenManager.getAdminId()); OutExpenseAccount useEa = expenseAccountMapper.selectByaidAndPrid(in); return useEa; } @Override public Object selectById(Integer id) { OutExpenseAccount useEa = expenseAccountMapper.selectByid(id); //判断当前角色是否审核 useEa.setExamine(pushExpenseAccountGetExamine( id, useEa.getProcessStatus()));; if (useEa.getDebitId()!=null){ pushExpenseAccountGetDebitAmount(useEa); } return useEa; } @Override public Object selectByCheckNo(String checkNo) { checkNo=checkNo.trim(); OutExpenseAccount useEa = expenseAccountMapper.selectByCheckNo(checkNo); if (useEa==null){ throw new BusinessException("报销编号不存在,请客对后再查询。"); } if (useEa.getProcessStatus()<3||useEa.getStatus()!=2){ throw new BusinessException("报销单财务未审核,不可以根据编号查看打印。"); } return useEa; } @Override public Object pushMerge(List list) { //设置付款部门和支付部门 InputExpenseAccount in =new InputExpenseAccount(); in.setCheckNo(idGenerator.getNOgenerateId()); if (in.getAid()==null){ in.setAid(TokenManager.getAdminId()); } Admin admin = adminMapper.selectByPrimaryKey(in.getAid()); in.setAname(admin.getName()); in.setApplyDep(admin.getDepartmentId()); in.setPayDep(admin.getDepartmentId()); Integer eaaid = expenseAccountPrivateMapper.selectByaidDefault(TokenManager.getAdminId()); in.setEaaid(eaaid); BigDecimal count = new BigDecimal(0); BigDecimal amount = new BigDecimal(0); BigDecimal realAmount = new BigDecimal(0); List typeList = new ArrayList(); for (ExpenseAccount e : list) { count=count.add(e.getTotalAmount()); amount=amount.add(e.getAmount()); realAmount=realAmount.add(e.getRealAmount()); StringBuffer types=new StringBuffer(); if (e.getType()!=0){ types=types.append(EATypes.getDescByCode(e.getType())); }else { types=types.append(e.getTypeOther()); } if (e.getType()==2){ if (e.getSecondaryType()==0){ types=types.append("-").append(e.getSecondaryTypeOther()); }else{ String descByCode = EAsecondaryTypes.getDescByCode(e.getSecondaryType()); types=types.append("-").append(descByCode); } } if (!typeList.contains(types.toString()))typeList.add(types.toString()); } in.setTotalAmount(count); in.setAmount(amount); in.setRealAmount(realAmount); in.setExpenseMain(1); in.setTypeOther(String.join(",",typeList)); expenseAccountMapper.insertSelective(in); List newLog=new ArrayList<>(); list.stream().forEach(e -> { ExpenseRelationship er=new ExpenseRelationship(); er.setId(in.getId()); er.setEaId(e.getId()); expenseRelationshipMapper.insertSelective(er); List listLog = expenseAccountLogMapper.selectByEaid(e.getId()); for (OutExpenseAccountLog log : listLog) { if (!newLog.contains(log)){ log.setEaid(in.getId()); log.setShowStatus(1); newLog.add(log); } } expenseAccountLogMapper.deleteByeaid(e.getId()); }); if (!newLog.isEmpty())expenseAccountLogMapper.insertBatch(newLog); expenseAccountMapper.updateByIds(list,1); return in.getId(); } @Override public MainExpenseAccount mainExpense(Integer id) { MainExpenseAccount res = expenseAccountMapper.selectByMainId(id); pushData(res); res.setExamine(0); if (res.getAid().equals(TokenManager.getAdminId())){ res.setExamine(2); }else { res.setExamine(pushExpenseAccountGetExamine( id, res.getProcessStatus()));; } return res; } private void pushData(MainExpenseAccount res) { List sonList = res.getSonList(); sonList.stream().forEach(e->{ if (StringUtils.isNotEmpty(e.getUserNames())){ String userNames = e.getUserNames(); String districtName = e.getDistrictName(); int start=userNames.indexOf("["); if (start>0){ userNames = userNames.substring(0,start); districtName=districtName.replace(userNames,""); e.setUserNames(userNames); e.setDistrictName(districtName); }else { districtName=districtName.replace(userNames,""); e.setDistrictName(districtName); } } }); } @Override public Object updateMain(MainExpenseAccount in) { OutExpenseAccount outExpenseAccount = expenseAccountMapper.selectByid(in.getId()); if (outExpenseAccount != null&&outExpenseAccount.getStatus()!=0&&outExpenseAccount.getStatus()!=3) { throw new BusinessException("主项目已发起,不可修改!"); } ExpenseAccount update =new ExpenseAccount(); if (in.getStatus()==null)in.setStatus(1); if (in.getStatus()==1){ if (in.getPayDep()!=null)update.setPayDep(in.getPayDep()); if (in.getApplyDep()!=null)update.setApplyDep(in.getApplyDep()); if (in.getRemarks()!=null)update.setRemarks(in.getRemarks()); if (in.getEaaid()!=null)update.setEaaid(in.getEaaid()); addExpenseAccountExamine(in.getId(),update); if (outExpenseAccount.getStatus()==0){ addExpenseAccountLogAndNoticEmail(outExpenseAccount,outExpenseAccount.getStatus(),"发起报销审核"); }else if (outExpenseAccount.getStatus()==3){ addExpenseAccountLogAndNoticEmail(outExpenseAccount,4,"修改并发起审核"); } update.setStatus(in.getStatus()); update.setProcessStatus(outExpenseAccount.getProcessStatus()); update.setId(in.getId()); update.setExamineName(outExpenseAccount.getExamineName()); expenseAccountMapper.updateByPrimaryKeySelective(update); // expenseAccountMapper.updateByOrderRemarks(in.getId()); }else if (in.getStatus()==4){ expenseAccountMapper.updateByMainId(in.getId(),0); addExpenseAccountLog(in.getId(),4,0,TokenManager.getAdminId(),"撤销报销审核"); List list = expenseRelationshipMapper.selectById(in.getId()); //撤销日志处理,先将日志改在挂子编号上,在新发起的时候再从自编号加到新编号上 if (list.size()==1){ ExpenseRelationship e =list.get(0); expenseAccountLogMapper.updateUseLogByUseId(e.getEaId(),e.getId()); }else { List outExpenseAccountLogs = expenseAccountLogMapper.selectByEaid(in.getId()); for (int i=0;i params = new HashMap<>(); if (in.getStatus()!=null) params.put("status",in.getStatus()); if (in.getCheckNo()!=null) params.put("checkNo",in.getCheckNo()); if (in.getListStatus()!=null) params.put("listStatus",in.getListStatus()); if (in.getUsername() != null)params.put("username",in.getUsername()); if (in.getStartTime()!=null && in.getEndTime() !=null) { params.put("startTime",in.getStartTime()); params.put("endTime",in.getEndTime()+" 23:59:59"); } //1-3s是不同人的审核 if (in.getProcessStatus()!=null&&in.getProcessStatus()==1){ // 财务审核,复审,出纳都是财务与经理 if(TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)){ in.setProcessStatus(6); }else if (TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION_ASSISTANT)){ in.setProcessStatus(5); }else if(TokenManager.hasRole(AFTConstants.VICE_CEO)){ //先不做财务查看权限 in.setProcessStatus(7); }else if (TokenManager.hasRole(AFTConstants.SALESMAN_MANAGER)){ in.setProcessStatus(1); }else if (TokenManager.hasRole(AFTConstants.SALESMAN_ADMIN)){ in.setProcessStatus(2); }else if (TokenManager.hasRole(AFTConstants.FINANCE)||TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)){ in.setProcessStatus(3); } }else { in.setProcessStatus(0); } if (in.getProcessStatus()!=null){ params.put("aid",TokenManager.getAdminId()); params.put("roleType",in.getProcessStatus()); if (in.getProcessStatus()==3){ params.put("deps",departmentService.selectMyDeps()); } } Pagination page = findPage("ExpenseMainList", "ExpenseMainCount", params, in.getPageNo(), in.getPageSize()); List list = (List) page.getList(); if (!list.isEmpty()){ List collect = list.stream().map(MainExpenseAccount::getId).collect(Collectors.toList()); List mainExpenseAccounts = expenseAccountMapper.selectSonByMainIds(collect); for (MainExpenseAccount e : list) { for (MainExpenseAccount me : mainExpenseAccounts) { if (e.getId().equals(me.getId())){ e.setSonList(me.getSonList()); } } } } return page; } @Override public Pagination detailsList(InputDetailsListBo in) { Map params = new HashMap<>(); if(in.getStatus()!=null)params.put("status",in.getStatus()); if(in.getType()!=null)params.put("type",in.getType()); if (in.getDepId()!=null){ ArrayList deps = new ArrayList<>(); deps.add(in.getDepId()); params.put("deps",deps); } if (in.getContractNo()!=null)params.put("contractNo",in.getContractNo()); if (in.getBuyerName()!=null)params.put("buyerName",in.getBuyerName()); if (in.getAid()!=null)params.put("aid",in.getAid()); if (in.getApplyDep()!=null)params.put("applyDep",in.getApplyDep()); if (in.getPayDep() != null)params.put("payDep",in.getPayDep()); if (in.getStartTime()!=null)params.put("startTime",in.getStartTime()); if (in.getEndTime()!=null)params.put("endTime",in.getEndTime()); if (in.getCheckNo()!=null)params.put("checkNo",in.getCheckNo()); //0=自己 1=财务 2=财务经理 3=超管 if (TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)){ params.put("roleType",3); }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)){ params.put("roleType",2); params.put("current",TokenManager.getAdminId()); }else if (TokenManager.hasRole(AFTConstants.FINANCE)){ params.put("roleType",1); params.put("current",TokenManager.getAdminId()); }else{ params.put("roleType",0); } return findPagePlus("ExpenseDetailsList","ExpenseDetailsCount","ExpenseDetailsTotalAmount",params,in.getPageNo(),in.getPageSize()); } @Override public List selectByIds(List list) { return expenseAccountMapper.selectByIds(list); } @Override public int selectCountByIdsAndType(List list, Integer i) { return expenseAccountMapper.selectCountByIdsAndType(list,i); } @Override public Object updateRealAmount(Integer type, Integer id, BigDecimal amount) { ExpenseAccountDetails ea= new ExpenseAccountDetails(); ea.setId(id); ea.setRealAmount(amount); String name=TokenManager.getAdminToken().getName(); Integer eaid = expenseAccountDetailsMapper.selectExpenseAccountById(id); addExpenseAccountLog(eaid,5,3,TokenManager.getAdminId(),String.format("财务[%s]修改实际报销金额为%s。",name,amount)); expenseAccountDetailsMapper.updateByPrimaryKeySelective(ea); expenseAccountMapper.updateSonByDetId(id); expenseAccountMapper.updateMainByDetId(id); return 1; } /** * 计算当前报销显示抵扣金额 * @param useEa */ private void pushExpenseAccountGetDebitAmount(OutExpenseAccount useEa) { ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId()); List list1 = expenseAccountMapper.selectByDebitId(useEa.getDebitId()); BigDecimal count =debit.getRealAmount(); for (ExpenseAccount e : list1) { if (!e.getId().equals(useEa.getId())){ count=count.subtract(e.getSettlementAmount()); } } if (count.compareTo(new BigDecimal(0))<0)count=new BigDecimal(0); useEa.setDebitTotalAmount(count); } /** * 判断角色是否已经审核 * @param id 编号 * @param processStatus 审核状态 * @return 0 无需审核 1 需要审核 */ private Integer pushExpenseAccountGetExamine(Integer id,Integer processStatus) { List list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(id, processStatus); boolean flag=false; for (ExpenseAccountExamine e : list) { if (e.getAuditor().equals(TokenManager.getAdminId())){ if (e.getStatus()==0){ flag=true; break; } } } if (flag){ return 1; }else { return 0; } } @Override public Object updateType(InputExpenseAccount in) { expenseAccountDetailsMapper.deleteByeaid(in.getId()); if (in.getType()!=2)in.setSecondaryType(0); in.setSettlementAmount(new BigDecimal(0)); return expenseAccountMapper.updateByPrimaryKeySelective(in); } @Override public List selectDebitOrder(String depId,Integer id) { String aid= TokenManager.getAdminId(); List list = expenseAccountMapper.selectByaidAndType(aid, depId, 4,id); return list; } private void addParam(InputPageListBo in, Map param) { if (in.getStartTime()!=null&&in.getEndTime()!=null){ param.put("startTime",in.getStartTime()); param.put("endTime",in.getEndTime()+" 23:59:59"); } if (in.getStatus()!=null)param.put("status",in.getStatus()); //如果前端未传 0自己 1审核的参数,默认自己,在审核列表的时候判断Aid,在 if (in.getProcessStatus()==null) in.setProcessStatus(0); if(in.getProcessStatus()==2){ if(TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)){ //财务经理查看权限 in.setProcessStatus(5); }else if(TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.SUPERADMIN)|| TokenManager.hasRole(AFTConstants.VICE_CEO)|| TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){ //财务管理员和超级管理员查看全部 in.setProcessStatus(6); }else if (TokenManager.hasRole(AFTConstants.FINANCE)){ //0 设置为财务查看 param.put("roleType",0); } if (in.getAid()!=null){ param.put("aid",in.getAid()); } param.put("auditor",TokenManager.getAdminId()); }else if(in.getProcessStatus()==1) { param.put("auditor",TokenManager.getAdminId()); if (in.getAid()!=null){ param.put("aid",in.getAid()); } }else { param.put("aid",TokenManager.getAdminId()); } param.put("processStatus",in.getProcessStatus()); if (in.getExamineStatus()!=null){ param.put("examineStatus",in.getExamineStatus()); }else { param.put("examineStatus",0); } if (in.getContractNo()!=null)param.put("contractNo",in.getContractNo()); if (in.getDepId()!=null)param.put("depId",in.getDepId()); if (in.getApplyDep()!=null)param.put("applyDep",in.getApplyDep()); if (in.getPayDep()!=null)param.put("payDep",in.getPayDep()); if (in.getType()!=null)param.put("type",in.getType()); if (in.getUsername()!=null)param.put("username",in.getUsername()); if (in.getCheckNo()!=null)param.put("checkNo",in.getCheckNo()); if (in.getSecondaryType()!=null)param.put("secondaryType",in.getSecondaryType()); //固定传0查看子列表 if (in.getExpenseMain()==null)in.setExpenseMain(0); if (in.getExpenseMain()!=null)param.put("expenseMain",in.getExpenseMain()); } /** * 检查权限判断是否是总裁、董事长或超级管理员权限 * @return */ private boolean checkShiroCED() { if (TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.CED_ASSISTANT)|| TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION_ASSISTANT) ||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){ return true; } return false; } @Override @Cacheable(value = "expenseAccountStatistics#300", key = "'page:'+#name+',depId'+#depId+',startTime'+#startTime+',endTime'+#endTime+'lander'+#lander") public List statistics(String name,String depId,String startTime,String endTime,String lander) { if (endTime != null) endTime = endTime + " 23:59:59"; List list = expenseAccountMapper.selectStatistics(name, depId, startTime, endTime, lander); List results = new ArrayList<>(); Map map = new HashMap<>(); for (OutMyEAStatistics e : list) { OutExpenseAccountStatistics out = new OutExpenseAccountStatistics(e.getAid()); out.setAname(e.getAname()); if (e.getStatus() == 2) { if (e.getType() < 4) { out.setBx(1); out.setBxAmount(e.getTotalAmount()); if (!e.getDebitId().equals(0)) { out.setDk(1); out.setDkAmount(e.getBxdkAmount()); } } else if (e.getType() == 4) { out.setJz(1); out.setJzAmount(e.getTotalAmount()); } else if (e.getType() == 5) { out.setDk(1); out.setDkAmount(e.getTotalAmount()); } if (e.getTargetType() == 0) { out.setGdfyAmount(e.getTotalAmount()); } else if (e.getTargetType() == 1) { out.setBxddAmount(e.getTotalAmount()); } } else if (e.getStatus() == 1) { out.setWshs(1); } else if (e.getStatus() == 3) { out.setBhs(1); } //如果不存在就新增 if (!map.keySet().contains(out.getAid())) { List list2 = new ArrayList<>(); list2.add(out); map.put(out.getAid(), list2); } else { List list2 = (List) map.get(e.getAid()); list2.add(out); } } for (String s : map.keySet()) { List list3 = (List) map.get(s); if (!list3.isEmpty()) { OutExpenseAccountStatistics out = new OutExpenseAccountStatistics(s); for (OutExpenseAccountStatistics e : list3) { if (out.getAname() == null) out.setAname(e.getAname()); if (e.getBx() != null) out.setBx(out.getBx() + e.getBx()); if (e.getJz() != null) out.setJz(out.getJz() + e.getJz()); if (e.getDk() != null) out.setDk(out.getDk() + e.getDk()); if (e.getBxAmount() != null) out.setBxAmount(out.getBxAmount().add(e.getBxAmount())); if (e.getJzAmount() != null) out.setJzAmount(out.getJzAmount().add(e.getJzAmount())); if (e.getDkAmount() != null) out.setDkAmount(out.getDkAmount().add(e.getDkAmount())); if (e.getGdfyAmount() != null) out.setGdfyAmount(out.getGdfyAmount().add(e.getGdfyAmount())); if (e.getBxddAmount() != null) out.setBxddAmount(out.getBxddAmount().add(e.getBxddAmount())); if (e.getWshs() != null) out.setWshs(out.getWshs() + e.getWshs()); if (e.getBhs() != null) out.setBhs(out.getBhs() + e.getBhs()); } BigDecimal totalAmount = new BigDecimal(0); totalAmount = totalAmount.add(out.getBxAmount()).add(out.getJzAmount()).subtract(out.getDkAmount()); out.setTotalAmount(totalAmount); results.add(out); } } return results; } @Override @CacheEvict(value = "expenseAccountStatistics#300", allEntries = true) public void statisticsEvict(String name, String depId, String startTime, String endTime) { LoggerUtils.debug(getClass(), "报销统计缓存清除。"); } @Override public Object pushSupplementCheckNo() { List list = expenseAccountMapper.selectByCheckNoNot(); if (!list.isEmpty()){ list.forEach(e ->{ ExpenseAccount ea=new ExpenseAccount(); ea.setId(e.getId()); ea.setCheckNo(idGenerator.getNOgenerateId()); expenseAccountMapper.updateByPrimaryKeySelective(ea); }); return 1; } return 0; } @Override public void pushAll() { List list = expenseAccountMapper.selectAllMain(); for (ExpenseAccount ea : list) { List expenseAccounts = expenseAccountMapper.selectListByMainId(ea.getId()); List typeList=new ArrayList<>(); for (ExpenseAccount e : expenseAccounts) { StringBuffer types=new StringBuffer(); if (e.getType()!=0){ types=types.append(EATypes.getDescByCode(e.getType())); }else { types=types.append(e.getTypeOther()); } if (e.getType()==2){ if (e.getSecondaryType()==0){ types=types.append("-").append(e.getSecondaryTypeOther()); }else{ String descByCode = EAsecondaryTypes.getDescByCode(e.getSecondaryType()); types=types.append("-").append(descByCode); } } if (!typeList.contains(types.toString()))typeList.add(types.toString()); } String typeStr = String.join(",", typeList); ExpenseAccount update=new ExpenseAccount(); update.setId(ea.getId()); update.setTypeOther(typeStr); expenseAccountMapper.updateByPrimaryKeySelective(update); } } }