ExpenseAccountServiceImpl.java 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860
  1. package com.goafanti.expenseAccount.service.impl;
  2. import com.goafanti.admin.bo.AdminListBo;
  3. import com.goafanti.common.bo.AdminNoticeBo;
  4. import com.goafanti.common.bo.EmailBo;
  5. import com.goafanti.common.constant.AFTConstants;
  6. import com.goafanti.common.dao.*;
  7. import com.goafanti.common.enums.NoticeStatus;
  8. import com.goafanti.common.enums.NoticeTypes;
  9. import com.goafanti.common.error.BusinessException;
  10. import com.goafanti.common.model.*;
  11. import com.goafanti.common.utils.AsyncUtils;
  12. import com.goafanti.common.utils.DateUtils;
  13. import com.goafanti.common.utils.LoggerUtils;
  14. import com.goafanti.common.utils.WeChatUtils;
  15. import com.goafanti.core.mybatis.BaseMybatisDao;
  16. import com.goafanti.core.mybatis.JDBCIdGenerator;
  17. import com.goafanti.core.mybatis.page.Pagination;
  18. import com.goafanti.core.shiro.token.TokenManager;
  19. import com.goafanti.expenseAccount.Enums.EAProcessStatus;
  20. import com.goafanti.expenseAccount.bo.*;
  21. import com.goafanti.expenseAccount.service.ExpenseAccountService;
  22. import org.springframework.beans.factory.annotation.Autowired;
  23. import org.springframework.cache.annotation.CacheEvict;
  24. import org.springframework.cache.annotation.Cacheable;
  25. import org.springframework.stereotype.Service;
  26. import org.springframework.transaction.annotation.Transactional;
  27. import java.math.BigDecimal;
  28. import java.util.*;
  29. @Service
  30. public class ExpenseAccountServiceImpl extends BaseMybatisDao<ExpenseAccountMapper> implements ExpenseAccountService {
  31. @Autowired
  32. private AdminMapper adminMapper;
  33. @Autowired
  34. private ExpenseAccountMapper expenseAccountMapper;
  35. @Autowired
  36. private PublicReleaseMapper publicReleaseMapper;
  37. @Autowired
  38. private ExpenseAccountLogMapper expenseAccountLogMapper;
  39. @Autowired
  40. private AsyncUtils asyncUtils;
  41. @Autowired
  42. private WeChatUtils weChatUtils;
  43. @Autowired
  44. private ExpenseAccountDetailsMapper expenseAccountDetailsMapper;
  45. @Autowired
  46. private ExpenseAccountPrivateMapper expenseAccountPrivateMapper;
  47. @Autowired
  48. private ExpenseAccountExamineMapper expenseAccountExamineMapper;
  49. @Autowired
  50. private JDBCIdGenerator idGenerator;
  51. @Autowired
  52. private FinanceCountMapper financeCountMapper;
  53. @Override
  54. public Integer add(InputExpenseAccount in) {
  55. //设置付款部门和支付部门
  56. in.setCheckNo(idGenerator.getNOgenerateId());
  57. if (in.getAid()!=null){
  58. Admin admin = adminMapper.selectByPrimaryKey(in.getAid());
  59. in.setAname(admin.getName());
  60. in.setApplyDep(admin.getDepartmentId());
  61. in.setPayDep(admin.getDepartmentId());
  62. }
  63. //如果关联公出,获取公出信息
  64. if (in.getPrid()!=null){
  65. PublicRelease pr = publicReleaseMapper.selectByPrimaryKey(in.getPrid());
  66. in.setReleaseStart(pr.getReleaseStart());
  67. in.setReleaseEnd(pr.getReleaseEnd());
  68. in.setDistrictName(pr.getDistrictName());
  69. in.setUserNames(pr.getUserNames());
  70. in.setDuration(pr.getDuration());
  71. }
  72. Integer eaaid = expenseAccountPrivateMapper.selectByaidDefault(in.getAid());
  73. in.setEaaid(eaaid);
  74. //判断报销类型,0=固定费用,1=报销到订单
  75. if (in.getOrderNo()==null){
  76. in.setTargetType(0);
  77. }else {
  78. in.setTargetType(1);
  79. }
  80. expenseAccountMapper.insertSelective(in);
  81. addExpenseAccountExamine(in.getId());
  82. return in.getId();
  83. }
  84. /**
  85. * 新增报销审核流程
  86. * @param id 报销编号
  87. */
  88. private void addExpenseAccountExamine(Integer id) {
  89. List<ExpenseAccountExamine> list=new ArrayList<>();
  90. String aid = TokenManager.getAdminId();
  91. Admin admin = adminMapper.selectByPrimaryKey(aid);
  92. for (int i=1;i<5;i++){
  93. if (i==1){
  94. //新增一级
  95. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  96. AdminNoticeBo a = adminMapper.selectMyAndSuperBySuperId(aid);
  97. if (a.getSuperId()!=null){
  98. eae.setAuditor(a.getSuperId());
  99. eae.setAuditorname(a.getSuperName());
  100. }else {
  101. eae.setAuditor(a.getId());
  102. eae.setAuditorname(a.getName());
  103. }
  104. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  105. else eae.setStatus(0);
  106. list.add(eae);
  107. }else if (i==2){
  108. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  109. Admin admin2 = adminMapper.selectFinanceAdminByAid(aid);
  110. if (admin2==null){
  111. throw new BusinessException("发起人部门财务专员不存在。");
  112. }
  113. eae.setAuditor(admin2.getId());
  114. eae.setAuditorname(admin2.getName());
  115. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  116. else eae.setStatus(0);
  117. list.add(eae);
  118. }else if (i==3){
  119. List<Admin> admins = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  120. if (admins.isEmpty())throw new BusinessException("发起人部门营销管理员不存在。");
  121. for (Admin e : admins) {
  122. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  123. eae.setAuditor(e.getId());
  124. eae.setAuditorname(e.getName());
  125. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  126. else eae.setStatus(0);
  127. list.add(eae);
  128. }
  129. }else if (i==4){
  130. List<Admin> admins = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  131. for (Admin e : admins) {
  132. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  133. eae.setAuditor(e.getId());
  134. eae.setAuditorname(e.getName());
  135. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  136. else eae.setStatus(0);
  137. list.add(eae);
  138. }
  139. }
  140. }
  141. expenseAccountExamineMapper.insertBatch(list);
  142. }
  143. /**
  144. * 新增报销日志
  145. * @param eaid 报销编号
  146. * @param status 状态 0发起 1通过 2完成 3驳回 4修改
  147. * @param str 备注
  148. */
  149. private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str) {
  150. addExpenseAccountLog(eaid,status,processStatus,aid,str,null);
  151. }
  152. /**
  153. * 新增报销日志
  154. * @param eaid 报销编号
  155. * @param status 状态 0发起 1通过 2完成 3驳回 4修改
  156. * @param str 备注
  157. */
  158. private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str,Date date) {
  159. if (aid==null)aid=TokenManager.getAdminId();
  160. ExpenseAccountLog eaLog=new ExpenseAccountLog();
  161. eaLog.setEaid(eaid);
  162. eaLog.setStatus(status);
  163. eaLog.setRemarks(str);
  164. eaLog.setProcessStatus(processStatus);
  165. eaLog.setAuditor(aid);
  166. if (date !=null)eaLog.setCreateTime(date);
  167. expenseAccountLogMapper.insertSelective(eaLog);
  168. }
  169. /**
  170. * 发起、驳回发起流程切换和日志站内信发送
  171. */
  172. private void addExpenseAccountLogAndNoticEmail(InputExpenseAccount in, Integer status, String str) {
  173. String aid=TokenManager.getAdminId();
  174. addExpenseAccountLog(in.getId(),status,in.getProcessStatus(),aid,str);
  175. Admin admin = adminMapper.selectByPrimaryKey(aid);
  176. if(in.getStatus()==1){
  177. in.setProcessStatus(1);
  178. }
  179. if (admin.getSuperiorId()==null||admin.getId().equals(admin.getSuperiorId())){
  180. String str2=String.format("重复审核人跳过[%s]。",EAProcessStatus.getDesc(in.getProcessStatus()));
  181. Date date=new Date();
  182. date.setTime(date.getTime()+1000L);
  183. addExpenseAccountLog(in.getId(),1,in.getProcessStatus(),aid,str2,date);
  184. in.setProcessStatus(in.getProcessStatus()+1);
  185. }
  186. createExamineByProcess(in);
  187. }
  188. /**
  189. * 判断审核流程与发送日志与邮件
  190. */
  191. private void createExamineByProcess(InputExpenseAccount in) {
  192. //审核流程推送到最新
  193. examineByprocess(in);
  194. List<Admin> aids=new ArrayList<>();
  195. AdminListBo admin = adminMapper.getDeptNameByAid(in.getAid());
  196. if(in.getProcessStatus()== EAProcessStatus.SJSH.getCode()){
  197. //获取上级
  198. Admin superAdmin = adminMapper.selectByPrimaryKey(admin.getSuperiorId());
  199. aids.add(superAdmin);
  200. in.setExamineName(superAdmin.getName());
  201. }else if (in.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  202. //获取财务负责人
  203. Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
  204. aids.add(finaceAdmin);
  205. in.setExamineName(finaceAdmin.getName());
  206. }else if (in.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
  207. //获取部门负责人
  208. List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  209. if (!list.isEmpty())aids.addAll(list);
  210. in.setExamineName(getAdmins(list));
  211. }else if (in.getProcessStatus()== EAProcessStatus.DSZSH.getCode()){
  212. //获取总裁、董事长等审核
  213. List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  214. if (!list.isEmpty())aids.addAll(list);
  215. in.setExamineName(getAdmins(list));
  216. }
  217. StringBuffer str=new StringBuffer().append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
  218. addNoticeAndEmail(in, EAProcessStatus.SJSH.getCode(),str.toString(), admin.getName(),aids);
  219. }
  220. @Override
  221. @Transactional
  222. public int update(InputExpenseAccount in) {
  223. OutExpenseAccount useEA = expenseAccountMapper.selectByid(in.getId());
  224. if (useEA.getStatus()!=0&&useEA.getStatus()!=3){
  225. throw new BusinessException("不能操作审核中与完成的订单");
  226. }
  227. if (in.getStartTimeStr()!=null&&in.getEndTimeStr()!=null){
  228. in.setReleaseStart(DateUtils.StringToDate(in.getStartTimeStr(), AFTConstants.YYYYMMDDHHMMSS));
  229. in.setReleaseEnd(DateUtils.StringToDate(in.getEndTimeStr(), AFTConstants.YYYYMMDDHHMMSS));
  230. }
  231. //计算总金额
  232. if (in.getTotalAmount()==null){
  233. in.setTotalAmount(expenseAccountDetailsMapper.selectAmountCountByEAid(in.getId()));
  234. }
  235. in.setProcessStatus(0);
  236. if (useEA.getStatus()==0){
  237. addExpenseAccountLogAndNoticEmail(in,0,"发起报销审核");
  238. }else if (useEA.getStatus()==3){
  239. addExpenseAccountLogAndNoticEmail(in,4,"修改并发起审核");
  240. }
  241. if (in.getOrderNo()==null){
  242. in.setTargetType(0);
  243. }else {
  244. in.setTargetType(1);
  245. }
  246. //计算本单已扣金额 如果有选择借支单,则需要修改借支状态
  247. if (in.getDebitId()!=null){
  248. //如果以前没有选择借支,修改报销和借支数据
  249. if (useEA.getDebitId()==null){
  250. pushExpenseAccountDebit(in);
  251. }else if (useEA.getDebitId()!=in.getDebitId()) {
  252. //如果是修改编号
  253. pushExpenseAccountDebit(in);
  254. //并且要处理原编号的问题
  255. pushresettingDebit(in,useEA.getDebitId());
  256. }
  257. }
  258. return expenseAccountMapper.updateByPrimaryKeySelective(in);
  259. }
  260. private void pushresettingDebit(InputExpenseAccount in, Integer debitId) {
  261. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(debitId);
  262. List<ExpenseAccount> list = expenseAccountMapper.selectByDebitId(debitId);
  263. ExpenseAccount newdebit=new ExpenseAccount();
  264. newdebit.setId(debitId);
  265. //计算除开当前单,已选择抵扣金额
  266. BigDecimal count=new BigDecimal(0);
  267. for (ExpenseAccount e : list) {
  268. if (!in.getId().equals(e.getId())){
  269. count=count.add(e.getSettlementAmount());
  270. }
  271. }
  272. newdebit.setSettlementAmount(count);
  273. if (count.compareTo(new BigDecimal(0))==0){
  274. newdebit.setLiquidationStatus(0);
  275. }else if (count.compareTo(debit.getTotalAmount())<0){
  276. newdebit.setLiquidationStatus(1);
  277. }else if (count.compareTo(debit.getTotalAmount())==0){
  278. newdebit.setLiquidationStatus(2);
  279. }
  280. expenseAccountMapper.updateByPrimaryKeySelective(newdebit);
  281. }
  282. private void pushExpenseAccountDebit(InputExpenseAccount in) {
  283. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(in.getDebitId());
  284. ExpenseAccount newDebit=new ExpenseAccount();
  285. newDebit.setId(debit.getId());
  286. //计算剩余需要支付金额
  287. BigDecimal decbitAmount=debit.getTotalAmount().subtract(debit.getSettlementAmount());
  288. //本次金额大于等于需要抵扣金额,则变成完全抵扣,抵扣金额变成本次已付金额
  289. if (in.getTotalAmount().compareTo(decbitAmount)>=0){
  290. in.setSettlementAmount(decbitAmount);
  291. newDebit.setSettlementAmount(debit.getTotalAmount());
  292. newDebit.setLiquidationStatus(2);
  293. }else {
  294. // 本次金额小于需要抵扣,则本次变更全抵扣,借支已付加上本次金额
  295. in.setSettlementAmount(in.getTotalAmount());
  296. BigDecimal setAmount=new BigDecimal(0).add(debit.getSettlementAmount()).add(in.getTotalAmount());
  297. newDebit.setSettlementAmount(setAmount);
  298. newDebit.setLiquidationStatus(1);
  299. }
  300. expenseAccountMapper.updateByPrimaryKeySelective(newDebit);
  301. }
  302. @Override
  303. public int addDetails(InputExpenseAccountDetails in) {
  304. if (in.getAgreeTimes()!=null){
  305. in.setAgreeTime(DateUtils.StringToDate(in.getAgreeTimes(),AFTConstants.YYYYMMDD));
  306. }
  307. return expenseAccountDetailsMapper.insertSelective(in);
  308. }
  309. @Override
  310. public int deleteDetails(Integer id) {
  311. return expenseAccountDetailsMapper.deleteByPrimaryKey(id);
  312. }
  313. @Override
  314. public List<OutExpenseAccountDetails> detailsList(Integer eaid) {
  315. return expenseAccountDetailsMapper.selectByEAid(eaid);
  316. }
  317. @Override
  318. public Object logList(Integer eaid) {
  319. List<OutExpenseAccountLog> list = expenseAccountLogMapper.selectByEaid(eaid);
  320. int maxProcessStatus=0;
  321. if (!list.isEmpty()){
  322. OutExpenseAccountLog lastout=list.get(list.size()-1);
  323. if (lastout.getStatus()!=3)maxProcessStatus=lastout.getProcessStatus();
  324. }
  325. List<OutExpenseAccountLog> eaelist = expenseAccountExamineMapper.selectNotExamineByEaidAndProcessStatus(eaid, maxProcessStatus);
  326. list.addAll(eaelist);
  327. return list;
  328. }
  329. @Override
  330. public int updateExamine(InputExpenseAccount in) {
  331. ExpenseAccount useEa = expenseAccountMapper.selectByPrimaryKey(in.getId());
  332. ExpenseAccount newEa=new ExpenseAccount();
  333. newEa.setId(useEa.getId());
  334. //审核通知 获取发送人
  335. addExamineExpenseAccountLog(in, useEa, newEa);
  336. //完成申请
  337. if (newEa.getStatus()==2){
  338. //如果是借支则订单新增
  339. if (useEa.getType()!=4){
  340. //不然就看是否挂载借支订单进行抵扣
  341. if (useEa.getDebitId()!=null){
  342. ExpenseAccount useDebit=expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
  343. if (useDebit.getLiquidationStatus()==2){
  344. List<ExpenseAccount> expenseAccounts = expenseAccountMapper.selectByDebitId(useEa.getDebitId());
  345. boolean flag=true;
  346. for (ExpenseAccount expenseAccount : expenseAccounts) {
  347. if(!expenseAccount.getId().equals(in.getId())&&expenseAccount.getStatus()!=2){
  348. flag=false;
  349. break;
  350. }
  351. }
  352. if (flag){
  353. ExpenseAccount debit=new ExpenseAccount();
  354. debit.setId(useEa.getDebitId());
  355. debit.setLiquidationStatus(3);
  356. expenseAccountMapper.updateByPrimaryKeySelective(debit);
  357. }
  358. }
  359. }
  360. }
  361. }
  362. pushExpenseFinaceCount(useEa,newEa);
  363. //审核处理审核表
  364. pushExpenseAccountExamine(in);
  365. expenseAccountMapper.updateByPrimaryKeySelective(newEa);
  366. return 1;
  367. }
  368. private void pushExpenseFinaceCount(ExpenseAccount useEa, ExpenseAccount newEa) {
  369. String startTime=DateUtils.formatDate(newEa.getCreateTime(),AFTConstants.YYYYMMDD);
  370. AdminListBo admin = adminMapper.getDeptNameByAid(useEa.getAid());
  371. FinanceCount financeCount = financeCountMapper.selectByAidAndDates(admin.getDepFinance(), startTime);
  372. //通过
  373. if (newEa.getStatus()==1){
  374. //下一步是财务审核就要加财务统计
  375. if (newEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()||
  376. useEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  377. if (newEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  378. if (financeCount==null){
  379. financeCount=FinanceCount.initialization(admin.getDepFinance(), startTime);
  380. financeCount.setExpenseCount(1);
  381. financeCount.setExpenseUnauditedCount(1);
  382. financeCountMapper.insertSelective(financeCount);
  383. }else {
  384. FinanceCount newFinanceCount =new FinanceCount();
  385. newFinanceCount.setId(financeCount.getId());
  386. newFinanceCount.setExpenseCount(financeCount.getExpenseCount()+1);
  387. newFinanceCount.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()+1);
  388. financeCountMapper.updateByPrimaryKeySelective(newFinanceCount);
  389. }
  390. //如果当前是财务审核通过就要减去未审核
  391. }else if (useEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  392. FinanceCount newFinanceCount =new FinanceCount();
  393. newFinanceCount.setId(financeCount.getId());
  394. newFinanceCount.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount()-1);
  395. financeCountMapper.updateByPrimaryKeySelective(newFinanceCount);
  396. }
  397. }
  398. //驳回
  399. }else if (newEa.getStatus()==3){
  400. if (financeCount!=null) {
  401. FinanceCount newFinanceCount = new FinanceCount();
  402. newFinanceCount.setId(financeCount.getId());
  403. //财务审核时减去未审核与
  404. if (useEa.getProcessStatus() == EAProcessStatus.CWSH.getCode()) {
  405. newFinanceCount.setExpenseCount(financeCount.getExpenseCount() - 1);
  406. newFinanceCount.setExpenseUnauditedCount(financeCount.getExpenseUnauditedCount() - 1);
  407. } else if (useEa.getProcessStatus() > EAProcessStatus.CWSH.getCode()) {
  408. newFinanceCount.setExpenseCount(financeCount.getExpenseCount() - 1);
  409. }
  410. financeCountMapper.updateByPrimaryKeySelective(newFinanceCount);
  411. }
  412. }
  413. }
  414. private void subtractionExpenseFinanceCount(String depFinance, String startTime) {
  415. }
  416. private void addExpenseFinanceCount(String depFinance, String startTime) {
  417. FinanceCount financeCount = financeCountMapper.selectByAidAndDates(depFinance, startTime);
  418. }
  419. private void pushExpenseAccountExamine(InputExpenseAccount in) {
  420. if (in.getStatus()==1){
  421. expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),TokenManager.getAdminId(),1);
  422. }else if (in.getStatus()==3){
  423. expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),null,0);
  424. }
  425. }
  426. private void addExamineExpenseAccountLog(InputExpenseAccount in, ExpenseAccount useEa, ExpenseAccount newEa) {
  427. List<Admin> aids=new ArrayList<>();
  428. StringBuffer str=new StringBuffer();
  429. Integer status=in.getStatus();
  430. AdminListBo admin = adminMapper.getDeptNameByAid(useEa.getAid());
  431. if (status==1){
  432. str=str.append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
  433. //新的流程是当前流程+1
  434. newEa.setProcessStatus(useEa.getProcessStatus()+1);
  435. pushExamineProcess(newEa);
  436. if (newEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  437. //获取财务负责人
  438. Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
  439. aids.add(finaceAdmin);
  440. newEa.setExamineName(finaceAdmin.getName());
  441. }else if (newEa.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
  442. //获取部门负责人
  443. List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  444. if (!list.isEmpty())aids.addAll(list);
  445. newEa.setExamineName(getAdmins(list));
  446. }else if (newEa.getProcessStatus()== EAProcessStatus.DSZSH.getCode()){
  447. //获取总裁、董事长等审核
  448. List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  449. if (!list.isEmpty())aids.addAll(list);
  450. newEa.setExamineName(getAdmins(list));
  451. }else if (newEa.getProcessStatus()== EAProcessStatus.WCSH.getCode()){
  452. //获取报销申请人
  453. status =2;
  454. Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
  455. aids.add(finaceAdmin);
  456. str.setLength(0);
  457. str=str.append("您的报销审核已通过,报销编号[").append(in.getId()).append("],请注意查看。");
  458. addNoticeAndEmail(in, status,str.toString(),admin.getName(),aids);
  459. aids.clear();
  460. aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
  461. newEa.setStatus(status);
  462. newEa.setExamineName("");
  463. }
  464. }else {
  465. aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
  466. newEa.setStatus(3);
  467. newEa.setProcessStatus(0);
  468. str.setLength(0);
  469. str=str.append("您的报销审核已驳回,报销编号[").append(in.getId()).append("],请注意查看。");
  470. }
  471. if (newEa.getStatus()==null)newEa.setStatus(1);
  472. addExpenseAccountLog(in.getId(),status,useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason());
  473. addNoticeAndEmail(in, status,str.toString(),admin.getName(),aids);
  474. }
  475. private void pushExamineProcess( ExpenseAccount newEa) {
  476. //如果到了董事长审核,无需判断了
  477. if (newEa.getProcessStatus()<EAProcessStatus.WCSH.getCode()){
  478. //判断没一个流程是否可以跳过
  479. examineByprocess(newEa);
  480. }
  481. }
  482. /**
  483. * 审核流程推送,只要不是完成状态就继续判断是否跳过
  484. * @param newEa
  485. */
  486. private void examineByprocess( ExpenseAccount newEa) {
  487. //获取当前流程审核人,如果有已审核则跳过当前审核
  488. List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), newEa.getProcessStatus());
  489. boolean flag=false;
  490. String aid="";
  491. for (ExpenseAccountExamine e : list) {
  492. if (e.getStatus()==1){
  493. flag=true;
  494. aid=e.getAuditor();
  495. break;
  496. }
  497. }
  498. if (flag){
  499. String str=String.format("重复审核人跳过[%s]。",EAProcessStatus.getDesc(newEa.getProcessStatus()));
  500. Date date=new Date();
  501. date.setTime(date.getTime()+1000l);
  502. addExpenseAccountLog(newEa.getId(),1,newEa.getProcessStatus(),aid,str,date);
  503. newEa.setProcessStatus(newEa.getProcessStatus()+1);
  504. if (newEa.getProcessStatus()<EAProcessStatus.WCSH.getCode())examineByprocess(newEa);
  505. }
  506. }
  507. private String getAdmins(List<Admin> list) {
  508. StringBuffer str =new StringBuffer();
  509. for (Admin admin : list) {
  510. str=str.append(admin.getName()).append(",");
  511. }
  512. return str.substring(0,str.length()-1);
  513. }
  514. private void addNoticeAndEmail(InputExpenseAccount in, Integer status, String str,String aname, List<Admin> aids) {
  515. Date date= new Date();
  516. Integer noticeStatus=NoticeStatus.EXPENSE_NOTICE.getCode();
  517. if (status==2){
  518. noticeStatus=NoticeStatus.EXPENSE_COMPLETE.getCode();
  519. }
  520. List<Notice> list=new ArrayList<>();
  521. if (aids!=null){
  522. for (Admin a : aids) {
  523. Notice notice=new Notice();
  524. notice.setId(UUID.randomUUID().toString());
  525. notice.setNoticeType(noticeStatus);
  526. notice.setType(NoticeTypes.getType(noticeStatus));
  527. notice.setAid(a.getId());
  528. notice.setCreateTime(date);
  529. notice.setContent(str);
  530. notice.setReaded(0);
  531. list.add(notice);
  532. EmailBo emailBo=new EmailBo(NoticeStatus.getValueByCode(noticeStatus),a.getEmail(),str);
  533. asyncUtils.send(emailBo);
  534. weChatUtils.addExpenseAccountWeChatNotice(a.getExpenseOpenId(),status,in.getId(),date,aname,str);
  535. }
  536. asyncUtils.addNoticeBatch(list);
  537. }
  538. }
  539. @Override
  540. public Object pageList(InputPageListBo in) {
  541. Map<String ,Object> param=new HashMap<>();
  542. addParam(in, param);
  543. Pagination<?> pagePlus = findPagePlus("selectExpenseAccountList",
  544. "selectExpenseAccountCount",
  545. "selectExpenseAccountTotalAmount", param, in.getPageNo(), in.getPageSize());
  546. List<OutExpenseAccountBo> list = (List<OutExpenseAccountBo>) pagePlus.getList();
  547. for (OutExpenseAccountBo e : list) {
  548. e.setExamine(pushExpenseAccountGetExamine(e.getId(), e.getProcessStatus()));
  549. }
  550. return pagePlus;
  551. }
  552. @Override
  553. public Object selectByPrid(InputExpenseAccount in) {
  554. Integer id=null;
  555. in.setAid(TokenManager.getAdminId());
  556. OutExpenseAccount useEa = expenseAccountMapper.selectByaidAndPrid(in);
  557. if (useEa!=null&&useEa.getId()!=null)id=useEa.getId();
  558. return id;
  559. }
  560. @Override
  561. public Object selectById(Integer id) {
  562. OutExpenseAccount useEa = expenseAccountMapper.selectByid(id);
  563. //判断当前角色是否审核
  564. pushExpenseAccountGetExamine(useEa);
  565. if (useEa.getDebitId()!=null){
  566. pushExpenseAccountGetDebitAmount(useEa);
  567. }
  568. return useEa;
  569. }
  570. @Override
  571. public Object selectByCheckNo(String checkNo) {
  572. OutExpenseAccount useEa = expenseAccountMapper.selectByCheckNo(checkNo);
  573. return useEa;
  574. }
  575. /**
  576. * 计算当前报销显示抵扣金额
  577. * @param useEa
  578. */
  579. private void pushExpenseAccountGetDebitAmount(OutExpenseAccount useEa) {
  580. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
  581. List<ExpenseAccount> list1 = expenseAccountMapper.selectByDebitId(useEa.getDebitId());
  582. BigDecimal count =debit.getTotalAmount();
  583. for (ExpenseAccount e : list1) {
  584. if (!e.getId().equals(useEa.getId())){
  585. count=count.subtract(e.getSettlementAmount());
  586. }
  587. }
  588. if (count.compareTo(new BigDecimal(0))<0)count=new BigDecimal(0);
  589. useEa.setDebitTotalAmount(count);
  590. }
  591. /**
  592. * 判断角色是否已经审核
  593. * @param useEa
  594. */
  595. private void pushExpenseAccountGetExamine(OutExpenseAccount useEa) {
  596. List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(useEa.getId(), useEa.getProcessStatus());
  597. boolean flag=false;
  598. for (ExpenseAccountExamine e : list) {
  599. if (e.getAuditor().equals(TokenManager.getAdminId())){
  600. if (e.getStatus()==0){
  601. flag=true;
  602. break;
  603. }
  604. }
  605. }
  606. if (flag){
  607. useEa.setExamine(1);
  608. }else {
  609. useEa.setExamine(0);
  610. }
  611. }
  612. /**
  613. * 判断角色是否已经审核
  614. * @param
  615. */
  616. private Integer pushExpenseAccountGetExamine(Integer id,Integer processStatus) {
  617. List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(id, processStatus);
  618. boolean flag=false;
  619. for (ExpenseAccountExamine e : list) {
  620. if (e.getAuditor().equals(TokenManager.getAdminId())){
  621. if (e.getStatus()==0){
  622. flag=true;
  623. break;
  624. }
  625. }
  626. }
  627. if (flag){
  628. return 1;
  629. }else {
  630. return 0;
  631. }
  632. }
  633. @Override
  634. public Object updateType(InputExpenseAccount in) {
  635. expenseAccountDetailsMapper.deleteByeaid(in.getId());
  636. return expenseAccountMapper.updateByPrimaryKeySelective(in);
  637. }
  638. @Override
  639. public List<OutExpenseAccount> selectDebitOrder(String depId,Integer id) {
  640. String aid= TokenManager.getAdminId();
  641. List<OutExpenseAccount> list = expenseAccountMapper.selectByaidAndType(aid, depId, 4,id);
  642. return list;
  643. }
  644. private void addParam(InputPageListBo in, Map<String, Object> param) {
  645. if (in.getStartTime()!=null&&in.getEndTime()!=null){
  646. param.put("startTime",in.getStartTime());
  647. param.put("endTime",in.getEndTime()+" 23:59:59");
  648. }
  649. if (in.getStatus()!=null)param.put("status",in.getStatus());
  650. //如果前端未传 0自己 1审核的参数,默认自己,在审核列表的时候判断Aid,在
  651. if (in.getProcessStatus()==null) in.setProcessStatus(0);
  652. param.put("processStatus",in.getProcessStatus());
  653. if(in.getProcessStatus()==2){
  654. if (in.getAid()!=null){
  655. param.put("aid",in.getAid());
  656. }
  657. }else if(in.getProcessStatus()==1) {
  658. param.put("auditor",TokenManager.getAdminId());
  659. if (in.getAid()!=null){
  660. param.put("aid",in.getAid());
  661. }
  662. }else {
  663. param.put("aid",TokenManager.getAdminId());
  664. }
  665. if (in.getExamineStatus()!=null){
  666. param.put("examineStatus",in.getExamineStatus());
  667. }else {
  668. param.put("examineStatus",0);
  669. }
  670. if (in.getContractNo()!=null)param.put("contractNo",in.getContractNo());
  671. if (in.getDepId()!=null)param.put("depId",in.getDepId());
  672. if (in.getUsername()!=null)param.put("username",in.getUsername());
  673. if (in.getApplyDep()!=null)param.put("applyDep",in.getApplyDep());
  674. if (in.getPayDep()!=null)param.put("payDep",in.getPayDep());
  675. if (in.getType()!=null)param.put("type",in.getType());
  676. }
  677. /**
  678. * 检查权限判断是否是总裁、董事长或超级管理员权限
  679. * @return
  680. */
  681. private boolean checkShiroCED() {
  682. if (TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.CED_ASSISTANT)||
  683. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION_ASSISTANT)
  684. ||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){
  685. return true;
  686. }
  687. return false;
  688. }
  689. @Override
  690. @Cacheable(value = "expenseAccountStatistics#300", key = "'page:'+#name+',depId'+#depId+',startTime'+#startTime+',endTime'+#endTime")
  691. public List<OutExpenseAccountStatistics> statistics(String name,String depId,String startTime,String endTime) {
  692. if (endTime!=null)endTime=endTime+" 23:59:59";
  693. List<OutMyEAStatistics> list = expenseAccountMapper.selectStatistics(name, depId, startTime, endTime);
  694. List<OutExpenseAccountStatistics> results=new ArrayList<>();
  695. Map<String ,Object> map=new HashMap<>();
  696. for (OutMyEAStatistics e : list) {
  697. OutExpenseAccountStatistics out = new OutExpenseAccountStatistics(e.getAid());
  698. out.setAname(e.getAname());
  699. if (e.getStatus() == 2) {
  700. if (e.getType() < 4) {
  701. out.setBx(1);
  702. out.setBxAmount(e.getTotalAmount());
  703. if (!e.getDebitId().equals(0)) {
  704. out.setDk(1);
  705. out.setDkAmount(e.getBxdkAmount());
  706. }
  707. } else if (e.getType() == 4) {
  708. out.setJz(1);
  709. out.setJzAmount(e.getTotalAmount());
  710. } else if (e.getType() == 5) {
  711. out.setDk(1);
  712. out.setDkAmount(e.getTotalAmount());
  713. }
  714. if (e.getTargetType() == 0) {
  715. out.setGdfyAmount(e.getTotalAmount());
  716. } else if (e.getTargetType() == 1) {
  717. out.setBxddAmount(e.getTotalAmount());
  718. }
  719. } else if (e.getStatus() < 2) {
  720. out.setWshs(1);
  721. } else if (e.getStatus() == 3) {
  722. out.setBhs(1);
  723. }
  724. //如果不存在就新增
  725. if (!map.keySet().contains(out.getAid())){
  726. List<OutExpenseAccountStatistics> list2=new ArrayList<>();
  727. list2.add(out);
  728. map.put(out.getAid(),list2);
  729. }else {
  730. List<OutExpenseAccountStatistics> list2 = (List<OutExpenseAccountStatistics>) map.get(e.getAid());
  731. list2.add(out);
  732. }
  733. }
  734. for (String s : map.keySet()) {
  735. List<OutExpenseAccountStatistics> list3 = (List<OutExpenseAccountStatistics>) map.get(s);
  736. if (!list3.isEmpty()){
  737. OutExpenseAccountStatistics out =new OutExpenseAccountStatistics(s);
  738. for (OutExpenseAccountStatistics e : list3) {
  739. if (out.getAname()==null)out.setAname(e.getAname());
  740. if (e.getBx()!=null)out.setBx(out.getBx()+e.getBx());
  741. if (e.getJz()!=null)out.setJz(out.getJz()+e.getJz());
  742. if (e.getDk()!=null)out.setDk(out.getDk()+e.getDk());
  743. if (e.getBxAmount()!=null)out.setBxAmount(out.getBxAmount().add(e.getBxAmount()));
  744. if (e.getJzAmount()!=null)out.setJzAmount(out.getJzAmount().add(e.getJzAmount()));
  745. if (e.getDkAmount()!=null)out.setDkAmount(out.getDkAmount().add(e.getDkAmount()));
  746. if (e.getGdfyAmount()!=null)out.setGdfyAmount(out.getGdfyAmount().add(e.getGdfyAmount()));
  747. if (e.getBxddAmount()!=null)out.setBxddAmount(out.getBxddAmount().add(e.getBxddAmount()));
  748. if (e.getWshs()!=null)out.setWshs(out.getWshs()+e.getWshs());
  749. if (e.getBhs()!=null)out.setBhs(out.getBhs()+e.getBhs());
  750. }
  751. BigDecimal totalAmount=new BigDecimal(0);
  752. totalAmount=totalAmount.add(out.getBxAmount()).add(out.getJzAmount()).subtract(out.getDkAmount());
  753. out.setTotalAmount(totalAmount);
  754. results.add(out);
  755. }
  756. }
  757. return results;
  758. }
  759. @Override
  760. @CacheEvict(value = "expenseAccountStatistics#300", allEntries = true)
  761. public void statisticsEvict(String name, String depId, String startTime, String endTime) {
  762. LoggerUtils.debug(getClass(), "报销统计缓存清除。");
  763. }
  764. @Override
  765. public Object pushSupplementCheckNo() {
  766. List<ExpenseAccount> list = expenseAccountMapper.selectByCheckNoNot();
  767. if (!list.isEmpty()){
  768. list.forEach(e ->{
  769. ExpenseAccount ea=new ExpenseAccount();
  770. ea.setId(e.getId());
  771. ea.setCheckNo(idGenerator.getNOgenerateId());
  772. expenseAccountMapper.updateByPrimaryKeySelective(ea);
  773. });
  774. return 1;
  775. }
  776. return 0;
  777. }
  778. }