| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607 |
- package com.goafanti.expenseAccount.service.impl;
- 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.AsyncUtils;
- import com.goafanti.common.utils.DateUtils;
- import com.goafanti.common.utils.WeChatUtils;
- import com.goafanti.core.mybatis.BaseMybatisDao;
- import com.goafanti.core.shiro.token.TokenManager;
- import com.goafanti.expenseAccount.Enums.EAProcessStatus;
- import com.goafanti.expenseAccount.bo.*;
- import com.goafanti.expenseAccount.service.ExpenseAccountService;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- import java.math.BigDecimal;
- import java.util.*;
- @Service
- public class ExpenseAccountServiceImpl extends BaseMybatisDao<ExpenseAccountMapper> implements ExpenseAccountService {
- @Autowired
- private AdminMapper adminMapper;
- @Autowired
- private DepartmentService departmentService;
- @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;
- @Override
- public Integer add(InputExpenseAccount in) {
- if (in.getAid()!=null){
- Admin admin = adminMapper.selectByPrimaryKey(in.getAid());
- in.setAname(admin.getName());
- in.setApplyDep(admin.getDepartmentId());
- in.setPayDep(admin.getDepartmentId());
- }
- 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());
- }
- Integer eaaid = expenseAccountPrivateMapper.selectByaidDefault(in.getAid());
- in.setEaaid(eaaid);
- if (in.getOrderNo()==null){
- in.setTargetType(0);
- }else {
- in.setTargetType(1);
- }
- expenseAccountMapper.insertSelective(in);
- addExpenseAccountExamine(in.getId());
- addExpenseAccountLogAndNoticEmail(in,0,"创建报销");
- return in.getId();
- }
- /**
- * 添加审核流程
- * @param id
- */
- private void addExpenseAccountExamine(Integer id) {
- List<ExpenseAccountExamine> list=new ArrayList<>();
- String aid = TokenManager.getAdminId();
- Admin admin = adminMapper.selectByPrimaryKey(aid);
- for (int i=1;i<5;i++){
- if (i==1){
- //新增一级
- ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
- AdminNoticeBo a = adminMapper.selectMyAndSuperBySuperId(aid);
- if (a.getSuperId()!=null){
- eae.setAuditor(a.getSuperId());
- eae.setAuditorname(a.getSuperName());
- }else {
- eae.setAuditor(a.getId());
- eae.setAuditorname(a.getName());
- }
- if (eae.getAuditor().equals(aid))eae.setStatus(1);
- else eae.setStatus(0);
- list.add(eae);
- }else if (i==2){
- ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
- Admin admin2 = adminMapper.selectFinanceAdminByAid(aid);
- eae.setAuditor(admin2.getId());
- eae.setAuditorname(admin2.getName());
- if (eae.getAuditor().equals(aid))eae.setStatus(1);
- else eae.setStatus(0);
- list.add(eae);
- }else if (i==3){
- List<Admin> admins = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
- for (Admin e : admins) {
- ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
- eae.setAuditor(e.getId());
- eae.setAuditorname(e.getName());
- if (eae.getAuditor().equals(aid))eae.setStatus(1);
- else eae.setStatus(0);
- list.add(eae);
- }
- }else if (i==4){
- List<Admin> admins = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
- for (Admin e : admins) {
- ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
- eae.setAuditor(e.getId());
- eae.setAuditorname(e.getName());
- 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,String aid, String str) {
- if (aid==null)aid=TokenManager.getAdminId();
- ExpenseAccountLog eaLog=new ExpenseAccountLog();
- eaLog.setEaid(eaid);
- eaLog.setStatus(status);
- eaLog.setRemarks(str);
- eaLog.setAuditor(aid);
- expenseAccountLogMapper.insertSelective(eaLog);
- }
- private void addExpenseAccountLogAndNoticEmail(InputExpenseAccount in, Integer status, String str) {
- String aid=TokenManager.getAdminId();
- addExpenseAccountLog(in.getId(),status,aid,str);
- //正常是走入上级审核,但是可能会跳过
- if(status>0){
- createExamineByProcess(in);
- }
- }
- private void createExamineByProcess(InputExpenseAccount in) {
- //审核流程推送到最新
- examineByprocess(in);
- List<Admin> aids=new ArrayList<>();
- AdminListBo admin = adminMapper.getDeptNameByAid(in.getAid());
- if(in.getProcessStatus()== EAProcessStatus.SJSH.getCode()){
- //获取上级
- Admin superAdmin = adminMapper.selectByPrimaryKey(admin.getId());
- aids.add(superAdmin);
- in.setUserNames(superAdmin.getName());
- }else if (in.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
- //获取财务负责人
- Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
- aids.add(finaceAdmin);
- in.setExamineName(finaceAdmin.getName());
- }else if (in.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
- //获取部门负责人
- List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
- if (!list.isEmpty())aids.addAll(list);
- in.setExamineName(getAdmins(list));
- }else if (in.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
- //获取总裁、董事长等审核
- List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
- if (!list.isEmpty())aids.addAll(list);
- in.setExamineName(getAdmins(list));
- }
- StringBuffer str=new StringBuffer().append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
- addLogAndNoticeAndEmail(in, 1,str.toString(), admin.getName(),aids);
- }
- @Override
- 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.getStatus()==1){
- in.setProcessStatus(1);
- }
- //计算总金额
- if (in.getTotalAmount()==null){
- in.setTotalAmount(expenseAccountDetailsMapper.selectAmountCountByEAid(in.getId()));
- }
- if (useEA.getStatus()==0){
- addExpenseAccountLogAndNoticEmail(in,1,"发起报销审核");
- }else if (useEA.getStatus()==3){
- addExpenseAccountLogAndNoticEmail(in,4,"修改并发起审核");
- }
- if (in.getOrderNo()==null){
- in.setTargetType(0);
- }else {
- in.setTargetType(1);
- }
- in.setSettlementAmount(useEA.getSettlementAmount());
- //计算本单已扣金额
- if (in.getDebitId()!=null){
- //如果以前没有选择借支,修改报销和借支数据
- if (useEA.getDebitId()==null){
- pushExpenseAccountDebit(in);
- }else if (useEA.getDebitId()!=in.getDebitId()) {
- //如果是修改编号
- pushExpenseAccountDebit(in);
- //并且要处理原编号的问题
- pushresettingDebit(in,useEA.getDebitId());
- }
- }
- return expenseAccountMapper.updateByPrimaryKeySelective(in);
- }
- private void pushresettingDebit(InputExpenseAccount in, Integer debitId) {
- ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(debitId);
- ExpenseAccount newdebit=new ExpenseAccount();
- newdebit.setSettlementAmount(debit.getSettlementAmount().subtract(in.getSettlementAmount()));
- if (newdebit.getSettlementAmount().compareTo(new BigDecimal(0))==0){
- newdebit.setLiquidationStatus(0);
- }else {
- newdebit.setLiquidationStatus(1);
- }
- expenseAccountMapper.updateByPrimaryKeySelective(newdebit);
- }
- private void pushExpenseAccountDebit(InputExpenseAccount in) {
- ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(in.getDebitId());
- ExpenseAccount newDebit=new ExpenseAccount();
- newDebit.setId(debit.getId());
- //计算剩余需要支付金额
- BigDecimal decbitAmount=in.getTotalAmount().subtract(in.getSettlementAmount());
- //本次金额大于等于需要抵扣金额,则变成完全抵扣,抵扣金额变成本次已付金额
- if (in.getTotalAmount().compareTo(decbitAmount)>0){
- in.setSettlementAmount(decbitAmount);
- newDebit.setSettlementAmount(debit.getTotalAmount());
- newDebit.setLiquidationStatus(2);
- }else {
- // 本次金额小于需要抵扣,则本次变更全抵扣,借支已付加上本次金额
- in.setSettlementAmount(in.getTotalAmount());
- newDebit.setSettlementAmount(debit.getSettlementAmount().add(in.getTotalAmount()));
- newDebit.setLiquidationStatus(1);
- }
- expenseAccountMapper.updateByPrimaryKeySelective(newDebit);
- }
- @Override
- public int addDetails(InputExpenseAccountDetails in) {
- if (in.getAgreeTimes()!=null){
- in.setAgreeTime(DateUtils.StringToDate(in.getAgreeTimes(),AFTConstants.YYYYMMDD));
- }
- return expenseAccountDetailsMapper.insertSelective(in);
- }
- @Override
- public int deleteDetails(Integer id) {
- return expenseAccountDetailsMapper.deleteByPrimaryKey(id);
- }
- @Override
- public List<OutExpenseAccountDetails> detailsList(Integer eaid) {
- return expenseAccountDetailsMapper.selectByEAid(eaid);
- }
- @Override
- public Object logList(Integer eaid) {
- return expenseAccountLogMapper.selectByEaid(eaid);
- }
- @Override
- public ExpenseAccountExamineLog examineLog(Integer eaid) {
- return expenseAccountLogMapper.selectExamineLog(eaid);
- }
- @Override
- public int updateExamine(InputExpenseAccount in) {
- ExpenseAccount useEa = expenseAccountMapper.selectByPrimaryKey(in.getId());
- ExpenseAccount newEa=new ExpenseAccount();
- newEa.setId(useEa.getId());
- if (useEa.getStatus()==0)throw new BusinessException("审核状态错误");
- if (useEa.getProcessStatus()!=in.getProcessStatus())throw new BusinessException(String.format("审核流程错误use=%s",useEa.getProcessStatus()));
- //审核通知 获取发送人
- addExamineExpenseAccountLog(in, useEa, newEa);
- //完成申请
- if (in.getStatus()==2){
- //如果是借支则订单新增
- if (in.getType()!=4){
- //不然就看是否挂载借支订单进行抵扣
- if (useEa.getDebitId()!=null){
- ExpenseAccount useDebit=expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
- if (useDebit.getLiquidationStatus()==2){
- List<ExpenseAccount> expenseAccounts = expenseAccountMapper.selectByDebit(useDebit.getDebitId());
- boolean flag=true;
- for (ExpenseAccount expenseAccount : expenseAccounts) {
- if(expenseAccount.getStatus()!=2){
- flag=flag;
- break;
- }
- }
- if (flag){
- ExpenseAccount debit=new ExpenseAccount();
- debit.setId(useEa.getDebitId());
- debit.setLiquidationStatus(3);
- expenseAccountMapper.updateByPrimaryKeySelective(debit);
- }
- }
- }
- }
- }
- //审核处理审核表
- pushExpenseAccountExamine(in);
- expenseAccountMapper.updateByPrimaryKeySelective(newEa);
- return 1;
- }
- private void pushExpenseAccountExamine(InputExpenseAccount in) {
- if (in.getStatus()==2){
- expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),TokenManager.getAdminId(),1);
- }else if (in.getStatus()==3){
- expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),null,0);
- }
- }
- private void addExamineExpenseAccountLog(InputExpenseAccount in, ExpenseAccount useEa, ExpenseAccount newEa) {
- List<Admin> aids=new ArrayList<>();
- StringBuffer str=new StringBuffer();
- Integer status=in.getStatus();
- AdminListBo admin = adminMapper.getDeptNameByAid(useEa.getAid());
- if (status==1){
- str=str.append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
- pushExamineProcess(newEa);
- if(useEa.getProcessStatus()== EAProcessStatus.FQ.getCode()){
- //获取上级
- Admin superAdmin = adminMapper.selectByPrimaryKey(admin.getSuperiorId());
- aids.add(superAdmin);
- newEa.setProcessStatus(EAProcessStatus.SJSH.getCode());
- newEa.setUserNames(superAdmin.getName());
- }else if (useEa.getProcessStatus()== EAProcessStatus.SJSH.getCode()){
- //获取财务负责人
- Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
- aids.add(finaceAdmin);
- newEa.setProcessStatus(EAProcessStatus.CWSH.getCode());
- newEa.setExamineName(finaceAdmin.getName());
- }else if (useEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
- //获取部门负责人
- List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
- if (!list.isEmpty())aids.addAll(list);
- newEa.setProcessStatus(EAProcessStatus.ZJLSH.getCode());
- newEa.setExamineName(getAdmins(list));
- }else if (useEa.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
- //获取总裁、董事长等审核
- List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
- if (!list.isEmpty())aids.addAll(list);
- newEa.setProcessStatus(EAProcessStatus.DSZSH.getCode());
- newEa.setExamineName(getAdmins(list));
- }else if (useEa.getProcessStatus()== EAProcessStatus.DSZSH.getCode()){
- //获取报销申请人
- status =2;
- aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
- newEa.setStatus(status);
- newEa.setExamineName("");
- str.setLength(0);
- str=str.append("您的报销审核已通过,报销编号[").append(in.getId()).append("],请注意查看。");
- }
- }else {
- aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
- newEa.setStatus(3);
- str.setLength(0);
- str=str.append("您的报销审核已驳回,报销编号[").append(in.getId()).append("],请注意查看。");
- }
- if (newEa.getStatus()==null)newEa.setStatus(1);
- addLogAndNoticeAndEmail(in, status,str.toString(),admin.getName(),aids);
- }
- private void pushExamineProcess( ExpenseAccount newEa) {
- //如果到了董事长审核,无需判断了
- if (newEa.getProcessStatus()<EAProcessStatus.DSZSH.getCode()){
- //判断没一个流程是否可以跳过
- examineByprocess(newEa);
- }
- }
- private void examineByprocess( ExpenseAccount newEa) {
- List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndType(newEa.getId(), newEa.getProcessStatus());
- boolean flag=false;
- for (ExpenseAccountExamine e : list) {
- if (e.getStatus()==1){
- flag=true;
- break;
- }
- }
- if (flag){
- addExpenseAccountLog(newEa.getId(),1,null,"重复审核人跳过当前审核。");
- newEa.setProcessStatus(newEa.getProcessStatus()+1);
- if (newEa.getProcessStatus()<5)examineByprocess(newEa);
- }
- }
- private String getAdmins(List<Admin> list) {
- StringBuffer str =new StringBuffer();
- for (Admin admin : list) {
- str=str.append(admin.getName()).append(",");
- }
- return str.substring(0,str.length()-1);
- }
- private void addLogAndNoticeAndEmail(InputExpenseAccount in, Integer status, String str,String aname, List<Admin> aids) {
- Date date= new Date();
- addExpenseAccountLog(in.getId(),status,null,in.getReason());
- Integer noticeStatus=NoticeStatus.EXPENSE_NOTICE.getCode();
- if (status==2){
- noticeStatus=NoticeStatus.EXPENSE_COMPLETE.getCode();
- }
- 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);
- weChatUtils.addExpenseAccountWeChatNotice(a.getExpenseOpenId(),status,in.getId(),date,aname,str);
- }
- asyncUtils.addNoticeBatch(list);
- }
- }
- @Override
- public Object pageList(InputPageListBo in) {
- Map<String ,Object> param=new HashMap<>();
- addParam(in, param);
- return findPage("selectExpenseAccountList", "selectExpenseAccountCount", param, in.getPageNo(), in.getPageSize());
- }
- @Override
- public Object selectByPrid(InputExpenseAccount in) {
- Integer id=null;
- in.setAid(TokenManager.getAdminId());
- OutExpenseAccount useEa = expenseAccountMapper.selectByaidAndPrid(in);
- if (useEa!=null&&useEa.getId()!=null)id=useEa.getId();
- return id;
- }
- @Override
- public Object selectById(Integer id) {
- OutExpenseAccount useEa = expenseAccountMapper.selectByid(id);
- if (useEa.getDebitId()!=null){
- ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
- if (debit!=null&&debit.getTotalAmount()!=null){
- useEa.setDebitTotalAmount(debit.getTotalAmount().subtract(debit.getSettlementAmount()));
- }
- }
- return useEa;
- }
- @Override
- public Object updateType(InputExpenseAccount in) {
- expenseAccountDetailsMapper.deleteByeaid(in.getId());
- return expenseAccountMapper.updateByPrimaryKeySelective(in);
- }
- @Override
- public List<OutExpenseAccount> selectDebitOrder(String depId) {
- String aid= TokenManager.getAdminId();
- return expenseAccountMapper.selectByaidAndType(aid,depId,4);
- }
- private void addParam(InputPageListBo in, Map<String, Object> param) {
- param.put("aid",TokenManager.getAdminId());
- 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());
- if (in.getProcessStatus()!=null){
- Integer processStatus=in.getProcessStatus();
- //默认自己 设置上级,判断管理员与总裁等顶级审核
- if (TokenManager.hasRole(AFTConstants.SALESMAN_ADMIN)){
- processStatus=3;
- List<String> list = departmentService.selectMyDeps();
- param.put("deps",list);
- }else if (TokenManager.hasRole(AFTConstants.FINANCE)){
- processStatus=2;
- }else if (checkShiroCED()){
- processStatus=4;
- }
- param.put("processStatus",processStatus);
- }else {
- param.put("processStatus",0);
- }
- if (in.getContractNo()!=null)param.put("contractNo",in.getContractNo());
- if (in.getDepId()!=null)param.put("depId",in.getDepId());
- if (in.getUsername()!=null)param.put("username",in.getUsername());
- 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.getContractNo());
- }
- /**
- * 检查权限判断是否是总裁、董事长或超级管理员权限
- * @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
- public Object statistics(String name,String depId,String startTime,String endTime) {
- if (endTime!=null)endTime=endTime+" 23:59:59";
- List<OutExpenseAccountStatistics> list = expenseAccountMapper.selectStatistics(name, depId, startTime, endTime);
- List<OutExpenseAccountStatistics> results=new ArrayList<>();
- Map<String ,Object> map=new HashMap<>();
- for (OutExpenseAccountStatistics e : list) {
- //如果是报销有选择抵扣预借支则算入抵扣
- if (e.getBx()==1){
- if (e.getDebitId()!=null){
- e.setDk(1);
- e.setDkAmount(e.getBxAmout());
- }
- if (e.getTargetType()==0){
- e.setGdfyAmount(e.getBxAmout());
- }else if (e.getTargetType()==1){
- e.setBxddAmount(e.getBxAmout());
- }
- }
- //如果不存在就新增
- if (!map.keySet().contains(e.getAid())){
- List<OutExpenseAccountStatistics> list2=new ArrayList<>();
- list2.add(e);
- map.put(e.getAid(),list2);
- }else {
- List<OutExpenseAccountStatistics> list2 = (List<OutExpenseAccountStatistics>) map.get(e.getAid());
- list2.add(e);
- }
- }
- 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.getBxAmout()!=null)out.setBxAmout(out.getBxAmout().add(e.getBxAmout()));
- 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.getBxAmout()).add(out.getJzAmount()).subtract(out.getDkAmount());
- out.setTotalAmount(totalAmount);
- results.add(out);
- }
- }
- return results;
- }
- }
|