| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915 |
- 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.FileUtils;
- import com.goafanti.common.utils.excel.NewExcelUtil;
- import com.goafanti.common.utils.pdf.PDFUtils;
- 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.order.service.OrderNewService;
- import com.goafanti.organization.bo.OrganizationListOut;
- import com.itextpdf.text.Document;
- import com.itextpdf.text.DocumentException;
- import com.itextpdf.text.Paragraph;
- import com.itextpdf.text.Phrase;
- import com.itextpdf.text.pdf.PdfPCell;
- import com.itextpdf.text.pdf.PdfPRow;
- import com.itextpdf.text.pdf.PdfPTable;
- import com.itextpdf.text.pdf.PdfWriter;
- 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.http.MediaType;
- import org.springframework.stereotype.Service;
- import org.springframework.transaction.annotation.Transactional;
- import javax.servlet.http.HttpServletResponse;
- import java.io.FileOutputStream;
- import java.io.IOException;
- import java.math.BigDecimal;
- import java.util.*;
- import java.util.stream.Collectors;
- @Service
- public class ExpenseAccountServiceImpl extends BaseMybatisDao<ExpenseAccountMapper> 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;
- @Autowired
- private TOrderPublicReleaseCountMapper tOrderPublicReleaseCountMapper;
- @Autowired
- private OrderNewService orderNewService;
- @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<ExpenseAccountExamine> 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<ExpenseConfigDetails> configDetailsList = expenseConfigDetailsMapper.selectByDepId(in.getApplyDep());
- if (in.getApproval()==null)in.setApproval(0);
- examineByprocess(in,admin,dep,configDetailsList);
- List<ExpenseAccountExamine> list=expenseAccountExamineMapper.selectByEaidAndProcessStatus(in.getId(), in.getProcessStatus());
- List<Admin> 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<OutExpenseAccountDetails> 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<OutExpenseAccountLog> 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<OutExpenseAccountBo> list = (List<OutExpenseAccountBo>) 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<OutExpenseAccountDetailsList> list = (List<OutExpenseAccountDetailsList>) 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()));
- }
- }
- if(e.getReleaseStart()!=null&&e.getReleaseEnd()!=null){
- e.setReleaseTimeStr(DateUtils.formatDate(e.getReleaseStart(),AFTConstants.YYYYMMDDHHMM)+"~"+DateUtils.formatDate(e.getReleaseEnd(),AFTConstants.YYYYMMDDHHMM));
- }
- }
- 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);
- expenseAccountMapper.updateByPrimaryKeySelective(ea);
- }
- if (StringUtils.isNotEmpty(remarks)){
- ea.setRemarks(remarks);
- expenseAccountMapper.updateByPrimaryKeySelective(ea);
- }
- if (StringUtils.isBlank(orderNo)){
- ea.setTargetType(0);
- expenseAccountMapper.updateRemoveOrderNo(ea);
- }else {
- ea.setOrderNo(orderNo);
- ea.setTargetType(1);
- 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;
- }
- @Override
- public Object updateDetailsTypeOther(Integer id, String typeOther) {
- ExpenseAccountDetails in =new ExpenseAccountDetails();
- in.setId(id);
- in.setTypeOther(typeOther);
- return expenseAccountDetailsMapper.updateByPrimaryKeySelective(in);
- }
- @Override
- public Object mainExpenseExport(Integer id, HttpServletResponse response) {
- MainExpenseAccount mainExpenseAccount = mainExpense(id);
- pushMainExpenseExport(mainExpenseAccount,response,uploadPath);
- return 1;
- }
- @Override
- public void pushExpenseTotalAmount() {
- List<TOrderNew> tOrderNews = orderNewService.selectGetAll();
- for (TOrderNew e : tOrderNews) {
- orderNewService.pushOrderPublicReleaseCount(e.getOrderNo());
- }
- }
- public void pushMainExpenseExport(MainExpenseAccount mainExpenseAccount,HttpServletResponse response, String uploadPath) {
- String title = "报销明细表";
- String attName = String.format("报销明细表_%s.pdf",new Date().getTime());
- String realFileName = uploadPath+"/tmp/"+new Date().getTime() + ".pdf";
- response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
- Document document=new Document();
- try {
- FileUtils.setAttachmentResponseHeader(response, title,attName);
- FileOutputStream outputStream = new FileOutputStream(realFileName);
- PdfWriter.getInstance(document, outputStream);
- document.open();
- Paragraph paragraph = new Paragraph(title, PDFUtils.getTitleFont());
- paragraph.setAlignment(1);
- document.add(paragraph);
- //默认算60
- PDFUtils.pushExpenseTitle(document,mainExpenseAccount);
- PdfPTable table = new PdfPTable(12);
- table.setWidthPercentage(100);
- ArrayList<PdfPRow> rows = table.getRows();
- float[] columnWidths ={12,24,14,50,50,42,28,18,12,12,50,50};
- table.setWidths(columnWidths);
- table.setSpacingBefore(10f);
- table.setSpacingAfter(10f);
- //填充表格头部
- addTitle(rows);
- //获取填充数据
- List<Map<Integer,String>> mapList = pushMainExpenseAccount(mainExpenseAccount);
- //填充数据写入表格
- pushTable(rows,mapList);
- document.add(table);
- document.close();
- outputStream.close();
- // FileUtils.writeBytes(realFileName, response.getOutputStream());
- // FileUtils.deleteFile(realFileName);
- } catch (DocumentException | IOException e) {
- e.printStackTrace();
- }
- }
- private static void addTitle(ArrayList<PdfPRow> rows) {
- PdfPCell[] cells =new PdfPCell[12];
- PdfPRow row=new PdfPRow(cells);
- cells[0] = new PdfPCell(new Phrase("序号",PDFUtils.getFont(8)));
- cells[1] = new PdfPCell(new Phrase("费用时间",PDFUtils.getFont(8)));
- cells[2] = new PdfPCell(new Phrase("时长",PDFUtils.getFont(8)));
- cells[3] = new PdfPCell(new Phrase("出差地址",PDFUtils.getFont(8)));
- cells[4] = new PdfPCell(new Phrase("出差企业",PDFUtils.getFont(8)));
- cells[5] = new PdfPCell(new Phrase("合同编号",PDFUtils.getFont(8)));
- cells[6] = new PdfPCell(new Phrase("类型",PDFUtils.getFont(8)));
- cells[7] = new PdfPCell(new Phrase("详情",PDFUtils.getFont(8)));
- cells[8] = new PdfPCell(new Phrase("费用",PDFUtils.getFont(8)));
- cells[9] = new PdfPCell(new Phrase("实报",PDFUtils.getFont(8)));
- cells[10] = new PdfPCell(new Phrase("出差事由",PDFUtils.getFont(8)));
- cells[11] = new PdfPCell(new Phrase("报销订单/部门",PDFUtils.getFont(8)));
- rows.add(row);
- }
- private void pushTable(ArrayList<PdfPRow> rows, List<Map<Integer, String>> mapList) {
- for (Map<Integer, String> map : mapList) {
- PdfPCell[] cells =new PdfPCell[12];
- PdfPRow row=new PdfPRow(cells);
- for (int i = 0; i < 12; i++) {
- cells[i] = new PdfPCell(new Phrase(map.get(i),PDFUtils.getFont(8)));
- }
- rows.add(row);
- }
- }
- private List<Map<Integer, String>> pushMainExpenseAccount(MainExpenseAccount mainExpenseAccount) {
- List<Map<Integer,String>> mapList = new ArrayList<>();
- if (mainExpenseAccount.getSonList()!=null){
- int index=0;
- for (SonExpenseAccount e : mainExpenseAccount.getSonList()) {
- List<SonExpenseAccountDetails> detList = e.getDetList();
- //详情计算,详情完成后需要一个统计
- int detIndex = 0;
- for (SonExpenseAccountDetails det : detList) {
- index++;
- detIndex++;
- Map<Integer, String> map = new HashMap<>();
- map.put(0, String.valueOf(index));
- if (detIndex==1){
- if (e.getPublicReleaseType()!=null){
- map.put(1,DateUtils.formatDate(e.getReleaseStart(),AFTConstants.YYYYMMDDHHMM)+"~"+DateUtils.formatDate(e.getReleaseEnd(),AFTConstants.YYYYMMDDHHMM));
- map.put(2,e.getDuration());
- map.put(3,e.getDistrictName());
- map.put(4,e.getUserNames());
- map.put(6,getExpenseType(e));
- }else {
- map.put(1,det.getAgreeTime());
- map.put(2,"");
- map.put(3,"");
- map.put(4,"");
- map.put(6,"");
- }
- }else {
- map.put(1,det.getAgreeTime());
- map.put(2,"");
- map.put(3,"");
- map.put(4,"");
- map.put(6,"");
- }
- map.put(5,e.getContractNo());
- map.put(7,getExpenseSecondaryType(e,det));
- map.put(8,getBigDecimalZeros(det.getAmount()));
- map.put(9,getBigDecimalZeros(det.getRealAmount()));
- map.put(10,e.getPlan());
- if (index==1){
- map.put(11,getOrderNoAndDepartment(e,mainExpenseAccount.getApplyDepName()));
- }else {
- map.put(11,"");
- }
- mapList.add(map);
- if (detIndex==detList.size()){
- index++;
- addCount(e.getAmount(),e.getRealAmount(),mapList,index);
- }
- }
- }
- //循环结束新增合计
- index++;
- addCount(mainExpenseAccount.getAmount(),mainExpenseAccount.getRealAmount(),mapList,index,1);
- }
- return mapList;
- }
- private String getBigDecimalZeros(BigDecimal amount) {
- return amount.stripTrailingZeros().toEngineeringString();
- }
- private void addCount(BigDecimal amount,BigDecimal realAmount,List<Map<Integer, String>> mapList,int index) {
- addCount(amount,realAmount,mapList,index,0);
- }
- private void addCount(BigDecimal amount,BigDecimal realAmount,List<Map<Integer, String>> mapList,int index,int type) {
- String str="小计";
- if (type==1)str="合计";
- Map<Integer, String> map = new HashMap<>();
- for (int i = 0; i < 12; i++){
- if (i==0){
- map.put(i, String.valueOf(index));
- }else if (i==7){
- map.put(i, str);
- }else if (i==8){
- map.put(i, getBigDecimalZeros(amount));
- }else if (i==9){
- map.put(i, getBigDecimalZeros(realAmount));
- }else {
- map.put(i, "");
- }
- }
- mapList.add(map);
- }
- private String getOrderNoAndDepartment(SonExpenseAccount e,String applyDepName) {
- return e.getOrderNo()+"\n"+applyDepName;
- }
- private String getExpenseSecondaryType(SonExpenseAccount e,SonExpenseAccountDetails det) {
- if (e.getType()==1){
- if (det.getType()==1){
- //交通工具待完善
- }
- }
- if (e.getSecondaryType()==0){
- return EAsecondaryTypes.getDescByCode(e.getSecondaryType())+"("+e.getSecondaryTypeOther()+")";
- }
- return EAsecondaryTypes.getDescByCode(e.getSecondaryType());
- }
- private String getExpenseType(SonExpenseAccount e) {
- if (e.getType()==0){
- return EATypes.getDescByCode(e.getType())+"("+e.getTypeOther()+")";
- }
- return EATypes.getDescByCode(e.getType());
- }
- private void pushResettingDebit(InputExpenseAccount in, Integer debitId) {
- ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(debitId);
- List<ExpenseAccount> 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<OutExpenseAccountDetails> detailsList(Integer eaid) {
- return expenseAccountDetailsMapper.selectByEAid(eaid);
- }
- @Override
- public Object logList(Integer eaid) {
- List<OutExpenseAccountLog> 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<OutExpenseAccountLog> outExpenseAccountLogs = expenseAccountExamineMapper.selectNotExamineByEaidAndProcessStatus(eaid, processStatus);
- list.addAll(outExpenseAccountLogs);
- }else {
- List<ExpenseAccountExamine> 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<OutExpenseAccountLog> list, ExpenseAccount expenseAccount,Integer useStatus) {
- OrganizationListOut dep = departmentMapper.selectAllById(expenseAccount.getApplyDep());
- List<ExpenseConfigDetails> configDetails = expenseConfigDetailsMapper.selectByDepId(expenseAccount.getApplyDep());
- for (int processStatus = useStatus; processStatus < 8; processStatus++) {
- if (processStatus ==3){
- if (dep.getExpenseRetrialFinanceExamine()==1){
- List<ExpenseConfigDetails> 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<ExpenseConfigDetails> 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<ExpenseConfigDetails> 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<ExpenseConfigDetails> 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<ExpenseConfigDetails> collect = configDetails.stream().filter(e -> e.getType() == 5).collect(Collectors.toList());
- for (ExpenseConfigDetails e : collect) {
- addDetailsTypeLog(list, expenseAccount, e);
- }
- }
- }
- }
- }
- private static void addDetailsTypeLog(List<OutExpenseAccountLog> 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<ExpenseAccount> 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<ExpenseAccount> 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<Map> 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<Admin> 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<ExpenseConfigDetails> 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<ExpenseAccountExamine> 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 {
- //小于为固定单审核,大于可能被配置多人审核
- if (useEa.getProcessStatus()<EAProcessStatus.CWFS.getCode()){
- boolean flag=false;
- List<ExpenseAccountExamine> list=expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), useEa.getProcessStatus());
- for (ExpenseAccountExamine e : list) {
- if (e.getAuditor().equals(TokenManager.getAdminId())){
- flag=true;
- }
- }
- if (!flag)throw new BusinessException("审核角色错误。请刷新页面");
- newEa.setProcessStatus(useEa.getProcessStatus()+1);
- }else {
- newEa.setProcessStatus(useEa.getProcessStatus());
- }
- addExpenseAccountLog(in.getId(),status,useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason());
- newEa.setStatus(1);
- if (newEa.getApproval()==null)newEa.setApproval(useEa.getApproval());
- //流程的推动
- examineByprocess(newEa,admin,dep,configDetailsList);
- //推动到出纳如果设置无需则完成不设置下个人,否则就要设置
- if (newEa.getProcessStatus()==EAProcessStatus.CNSH.getCode()){
- if(dep.getCashierExamine()==1){
- pushExamineName(newEa, aids);
- }else {
- //完成后的流程
- status =2;
- aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
- newEa.setStatus(status);
- newEa.setExamineName("");
- }
- }else {
- pushExamineName(newEa, aids);
- }
- }
- }else {
- aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
- newEa.setStatus(3);
- newEa.setProcessStatus(0);
- str.setLength(0);
- addExpenseAccountLog(in.getId(),newEa.getStatus(),useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason());
- str=str.append("您的报销审核已驳回,报销编号[").append(in.getCheckNo()).append("],请注意查看。");
- }
- if (newEa.getStatus()==null)newEa.setStatus(1);
- addNoticeAndEmail(in, status,str.toString(),admin.getName(),aids);
- }
- private void pushExamineName(ExpenseAccount newEa, List<Admin> aids) {
- List<ExpenseAccountExamine> 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<ExpenseConfigDetails> list) {
- List<ExpenseAccountExamine> examineList=new ArrayList<>();
- //小于财务复审的,走单审核
- if (newEa.getProcessStatus()<EAProcessStatus.CWFS.getCode()){
- examineList = expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), newEa.getProcessStatus());
- boolean flag=false;
- String aid="";
- if (examineList.size()>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()<EAProcessStatus.CNSH.getCode()){
- date2.setTime(date2.getTime()+100);
- addExpenseAccountLog(newEa.getId(),1,newEa.getProcessStatus(),aid,str,date2,2);
- newEa.setProcessStatus(newEa.getProcessStatus()+1);
- examineByprocess(newEa,admin,dep,list);
- }else {
- date2.setTime(date2.getTime()+100);
- addExpenseAccountLog(newEa.getId(),2,newEa.getProcessStatus(),aid,str,date2,2);
- newEa.setProcessStatus(newEa.getProcessStatus());
- newEa.setStatus(2);
- }
- }else if (flag3){
- newEa.setProcessStatus(newEa.getProcessStatus()+1);
- examineByprocess(newEa,admin,dep,list);
- }
- }
- }
- private boolean pushExpenseExamine(List<ExpenseConfigDetails> 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<ExpenseAccountExamine> expenseAccountExamines = expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), status);
- int count = 0;
- int size=10;
- if (expenseAccountExamines.isEmpty()){
- List<ExpenseConfigDetails> 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<Admin> aids) {
- Date date= new Date();
- Integer noticeStatus=NoticeStatus.EXPENSE_NOTICE.getCode();
- if (status==2){
- noticeStatus=NoticeStatus.EXPENSE_COMPLETE.getCode();
- str="您提交的费用报销单已通过审核,请及时查看。";
- }
- List<Notice> 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<String ,Object> param=new HashMap<>();
- addParam(in, param);
- Pagination<?> pagePlus = findPagePlus("selectExpenseAccountList",
- "selectExpenseAccountCount",
- "selectExpenseAccountTotalAmount", param, in.getPageNo(), in.getPageSize());
- List<OutExpenseAccountBo> list = (List<OutExpenseAccountBo>) 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);
- if (useEa!=null){
- ExpenseRelationship er = expenseRelationshipMapper.selectSonId(useEa.getId());
- if (er!=null){
- throw new BusinessException("公出已经发起报销");
- }
- }
- 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<ExpenseAccount> 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<String> typeList = new ArrayList<String>();
- 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<OutExpenseAccountLog> newLog=new ArrayList<>();
- list.stream().forEach(e -> {
- ExpenseRelationship er=new ExpenseRelationship();
- er.setId(in.getId());
- er.setEaId(e.getId());
- expenseRelationshipMapper.insertSelective(er);
- List<OutExpenseAccountLog> 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<SonExpenseAccount> sonList = res.getSonList();
- for (SonExpenseAccount e : sonList) {
- 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);
- }
- }
- if (e.getOrderNo()!=null){
- List<ExpenseAccount> expenseAccounts = expenseAccountMapper.selectByOrderNo(e.getOrderNo());
- if(!expenseAccounts.isEmpty()){
- TOrderPublicReleaseCount out = tOrderPublicReleaseCountMapper.selectByOrderNo(e.getOrderNo());
- BigDecimal count = BigDecimal.ZERO;
- BigDecimal yxyCount = BigDecimal.ZERO;
- BigDecimal zxsCount = BigDecimal.ZERO;
- BigDecimal qtCount = BigDecimal.ZERO;
- for (ExpenseAccount ea : expenseAccounts) {
- count=count.add(ea.getAmount());
- Admin admin = adminMapper.selectByPrimaryKey(ea.getAid());
- if (admin.getPosition()!=null){
- if (admin.getPosition().equals("1")){
- yxyCount=yxyCount.add(ea.getAmount());
- }else if (admin.getPosition().equals("2")){
- zxsCount=zxsCount.add(ea.getAmount());
- }else {
- qtCount=qtCount.add(ea.getAmount());
- }
- }
- }
- String str = getString(e, out, count, yxyCount, zxsCount,qtCount);
- e.setCountStr(str);
- }
- }
- }
- }
- private String getString(SonExpenseAccount e, TOrderPublicReleaseCount out, BigDecimal count, BigDecimal yxyCount, BigDecimal zxsCount, BigDecimal qtCount) {
- if (out == null){
- return null;
- }
- String maxString=":应公出" + out.getMaxDuration() + "小时";
- String actualString=",超过" + out.getExceedDuration() + "小时,";
- if (out.getMaxDuration().equals(-1d)){
- maxString=":不限制公出小时";
- actualString="";
- }
- StringBuilder expenseString=new StringBuilder().append("报销").append(count.stripTrailingZeros().toPlainString()).append("元");
- if (yxyCount != null || zxsCount != null||qtCount != null){
- expenseString.append("(");
- if (zxsCount != null && zxsCount.compareTo(BigDecimal.ZERO) > 0) {
- expenseString.append("技术").append(zxsCount.stripTrailingZeros().toPlainString()).append("元,");
- }
- if (yxyCount != null && yxyCount.compareTo(BigDecimal.ZERO) > 0){
- expenseString.append("营销").append(yxyCount.stripTrailingZeros().toPlainString()).append("元,");
- }
- if (qtCount != null && qtCount.compareTo(BigDecimal.ZERO) > 0){
- expenseString.append("其他").append(qtCount.stripTrailingZeros().toPlainString()).append("元,");
- }
- expenseString.deleteCharAt(expenseString.length() - 1);
- expenseString.append(")");
- }
- if (out.getActualDuration()<=out.getMaxDuration()){
- actualString="";
- }
- return e.getBuyerName() + e.getContractNo() +
- maxString +
- ",已" + out.getPeopleCount() + "人公出," +
- out.getFrequency() + "次" +
- "," + out.getActualDuration() + "小时" +
- actualString+expenseString;
- }
- @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<ExpenseRelationship> list = expenseRelationshipMapper.selectById(in.getId());
- //撤销日志处理,先将日志改在挂子编号上,在新发起的时候再从自编号加到新编号上
- if (list.size()==1){
- ExpenseRelationship e =list.get(0);
- expenseAccountLogMapper.updateUseLogByUseId(e.getEaId(),e.getId());
- }else {
- List<OutExpenseAccountLog> outExpenseAccountLogs = expenseAccountLogMapper.selectByEaid(in.getId());
- for (int i=0;i<list.size();i++){
- ExpenseRelationship e =list.get(i);
- for (OutExpenseAccountLog eal : outExpenseAccountLogs) {
- eal.setEaid(e.getEaId());
- }
- expenseAccountLogMapper.insertBatch(outExpenseAccountLogs);
- }
- }
- expenseAccountLogMapper.deleteByeaid(in.getId());
- expenseRelationshipMapper.deleteByPrimaryKey(in.getId());
- expenseAccountMapper.deleteByPrimaryKey(in.getId());
- }
- return 1;
- }
- @Override
- public Object mainList(ExpenseMainListInput in) {
- Map<String,Object> 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<MainExpenseAccount> list = (List<MainExpenseAccount>) page.getList();
- if (!list.isEmpty()){
- List<Integer> collect = list.stream().map(MainExpenseAccount::getId).collect(Collectors.toList());
- List<MainExpenseAccount> 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<String,Object> 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<Object> 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());
- params.put("current",TokenManager.getAdminId());
- if (in.getMyType()!=null){
- params.put("myType",in.getMyType());
- }else {
- params.put("myType",0);
- }
- //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);
- }else if (TokenManager.hasRole(AFTConstants.FINANCE)){
- params.put("roleType",1);
- params.put("current",TokenManager.getAdminId());
- }else{
- params.put("roleType",0);
- params.put("aid",TokenManager.getAdminId());
- }
- return findPagePlus("ExpenseDetailsList","ExpenseDetailsCount","ExpenseDetailsTotalAmount",params,in.getPageNo(),in.getPageSize());
- }
- @Override
- public List<ExpenseAccount> selectByIds(List<String> list) {
- return expenseAccountMapper.selectByIds(list);
- }
- @Override
- public int selectCountByIdsAndType(List<String> 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<ExpenseAccount> 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<ExpenseAccountExamine> 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<OutExpenseAccount> selectDebitOrder(String depId,Integer id) {
- String aid= TokenManager.getAdminId();
- List<OutExpenseAccount> list = expenseAccountMapper.selectByaidAndType(aid, depId, 4,id);
- return list;
- }
- private void addParam(InputPageListBo in, Map<String, Object> 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,在
- param.put("auditor",TokenManager.getAdminId());
- if(in.getProcessStatus()==null){
- if(TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)){
- //财务经理查看权限
- in.setProcessStatus(5);
- param.put("auditor",TokenManager.getAdminId());
- }else if(TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.SUPERADMIN)||
- TokenManager.hasRole(AFTConstants.VICE_CEO)|| TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){
- //财务管理员和超级管理员查看全部
- in.setProcessStatus(6);
- param.put("auditor",TokenManager.getAdminId());
- if(StringUtils.isNotBlank(in.getAid()))param.put("aid",in.getAid());
- }else if (TokenManager.hasRole(AFTConstants.FINANCE)){
- //0 设置为财务查看
- param.put("auditor",TokenManager.getAdminId());
- //如果是空设置为
- if (in.getProcessStatus()==null)in.setProcessStatus(2);
- }else {
- in.setProcessStatus(0);
- }
- }
- param.put("processStatus",in.getProcessStatus());
- if (in.getRoleType()==null){
- param.put("roleType",0);
- }else {
- param.put("roleType",in.getRoleType());
- }
- if(in.getProcessStatus()==2||in.getProcessStatus()==1){
- if (in.getAid()!=null){
- param.put("aid",in.getAid());
- }
- }
- 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());
- }
- @Override
- @Cacheable(value = "expenseAccountStatistics#300", key = "'page:'+#name+',depId'+#depId+',startTime'+#startTime+',endTime'+#endTime+'lander'+#lander")
- public List<OutExpenseAccountStatistics> statistics(String name,String depId,String startTime,String endTime,String lander) {
- if (endTime != null) endTime = endTime + " 23:59:59";
- List<OutMyEAStatistics> list = expenseAccountMapper.selectStatistics(name, depId, startTime, endTime, lander);
- List<OutExpenseAccountStatistics> results = new ArrayList<>();
- Map<String, Object> 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<OutExpenseAccountStatistics> list2 = new ArrayList<>();
- list2.add(out);
- map.put(out.getAid(), list2);
- } else {
- List<OutExpenseAccountStatistics> list2 = (List<OutExpenseAccountStatistics>) map.get(e.getAid());
- list2.add(out);
- }
- }
- for (String s : map.keySet()) {
- List<OutExpenseAccountStatistics> list3 = (List<OutExpenseAccountStatistics>) 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<ExpenseAccount> 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<ExpenseAccount> list = expenseAccountMapper.selectAllMain();
- for (ExpenseAccount ea : list) {
- List<ExpenseAccount> expenseAccounts = expenseAccountMapper.selectListByMainId(ea.getId());
- List<String> 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);
- }
- }
- }
|