ExpenseAccountServiceImpl.java 40 KB

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