ExpenseAccountServiceImpl.java 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631
  1. package com.goafanti.expenseAccount.service.impl;
  2. import com.goafanti.admin.bo.AdminListBo;
  3. import com.goafanti.admin.service.DepartmentService;
  4. import com.goafanti.common.bo.AdminNoticeBo;
  5. import com.goafanti.common.bo.EmailBo;
  6. import com.goafanti.common.constant.AFTConstants;
  7. import com.goafanti.common.dao.*;
  8. import com.goafanti.common.enums.NoticeStatus;
  9. import com.goafanti.common.enums.NoticeTypes;
  10. import com.goafanti.common.error.BusinessException;
  11. import com.goafanti.common.model.*;
  12. import com.goafanti.common.utils.AsyncUtils;
  13. import com.goafanti.common.utils.DateUtils;
  14. import com.goafanti.common.utils.WeChatUtils;
  15. import com.goafanti.core.mybatis.BaseMybatisDao;
  16. import com.goafanti.core.shiro.token.TokenManager;
  17. import com.goafanti.expenseAccount.Enums.EAProcessStatus;
  18. import com.goafanti.expenseAccount.bo.*;
  19. import com.goafanti.expenseAccount.service.ExpenseAccountService;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.stereotype.Service;
  22. import java.math.BigDecimal;
  23. import java.util.*;
  24. @Service
  25. public class ExpenseAccountServiceImpl extends BaseMybatisDao<ExpenseAccountMapper> implements ExpenseAccountService {
  26. @Autowired
  27. private AdminMapper adminMapper;
  28. @Autowired
  29. private DepartmentService departmentService;
  30. @Autowired
  31. private ExpenseAccountMapper expenseAccountMapper;
  32. @Autowired
  33. private PublicReleaseMapper publicReleaseMapper;
  34. @Autowired
  35. private ExpenseAccountLogMapper expenseAccountLogMapper;
  36. @Autowired
  37. private AsyncUtils asyncUtils;
  38. @Autowired
  39. private WeChatUtils weChatUtils;
  40. @Autowired
  41. private ExpenseAccountDetailsMapper expenseAccountDetailsMapper;
  42. @Autowired
  43. private ExpenseAccountPrivateMapper expenseAccountPrivateMapper;
  44. @Autowired
  45. private ExpenseAccountExamineMapper expenseAccountExamineMapper;
  46. @Override
  47. public Integer add(InputExpenseAccount in) {
  48. if (in.getAid()!=null){
  49. Admin admin = adminMapper.selectByPrimaryKey(in.getAid());
  50. in.setAname(admin.getName());
  51. in.setApplyDep(admin.getDepartmentId());
  52. in.setPayDep(admin.getDepartmentId());
  53. }
  54. if (in.getPrid()!=null){
  55. PublicRelease pr = publicReleaseMapper.selectByPrimaryKey(in.getPrid());
  56. in.setReleaseStart(pr.getReleaseStart());
  57. in.setReleaseEnd(pr.getReleaseEnd());
  58. in.setDistrictName(pr.getDistrictName());
  59. in.setUserNames(pr.getUserNames());
  60. in.setDuration(pr.getDuration());
  61. }
  62. Integer eaaid = expenseAccountPrivateMapper.selectByaidDefault(in.getAid());
  63. in.setEaaid(eaaid);
  64. if (in.getOrderNo()==null){
  65. in.setTargetType(0);
  66. }else {
  67. in.setTargetType(1);
  68. }
  69. expenseAccountMapper.insertSelective(in);
  70. addExpenseAccountExamine(in.getId());
  71. addExpenseAccountLogAndNoticEmail(in,0,"创建报销");
  72. return in.getId();
  73. }
  74. /**
  75. * 添加审核流程
  76. * @param id
  77. */
  78. private void addExpenseAccountExamine(Integer id) {
  79. List<ExpenseAccountExamine> list=new ArrayList<>();
  80. String aid = TokenManager.getAdminId();
  81. Admin admin = adminMapper.selectByPrimaryKey(aid);
  82. for (int i=1;i<5;i++){
  83. if (i==1){
  84. //新增一级
  85. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  86. AdminNoticeBo a = adminMapper.selectMyAndSuperBySuperId(aid);
  87. if (a.getSuperId()!=null){
  88. eae.setAuditor(a.getSuperId());
  89. eae.setAuditorname(a.getSuperName());
  90. }else {
  91. eae.setAuditor(a.getId());
  92. eae.setAuditorname(a.getName());
  93. }
  94. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  95. else eae.setStatus(0);
  96. list.add(eae);
  97. }else if (i==2){
  98. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  99. Admin admin2 = adminMapper.selectFinanceAdminByAid(aid);
  100. eae.setAuditor(admin2.getId());
  101. eae.setAuditorname(admin2.getName());
  102. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  103. else eae.setStatus(0);
  104. list.add(eae);
  105. }else if (i==3){
  106. List<Admin> admins = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  107. for (Admin e : admins) {
  108. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  109. eae.setAuditor(e.getId());
  110. eae.setAuditorname(e.getName());
  111. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  112. else eae.setStatus(0);
  113. list.add(eae);
  114. }
  115. }else if (i==4){
  116. List<Admin> admins = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  117. for (Admin e : admins) {
  118. ExpenseAccountExamine eae=new ExpenseAccountExamine(id,i);
  119. eae.setAuditor(e.getId());
  120. eae.setAuditorname(e.getName());
  121. if (eae.getAuditor().equals(aid))eae.setStatus(1);
  122. else eae.setStatus(0);
  123. list.add(eae);
  124. }
  125. }
  126. }
  127. expenseAccountExamineMapper.insertBatch(list);
  128. }
  129. /**
  130. *
  131. * @param eaid 报销编号
  132. * @param status 状态 0创建 1发起 2通过 3驳回 4修改
  133. * @param str 备注
  134. */
  135. private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str) {
  136. addExpenseAccountLog(eaid,status,processStatus,aid,str,null);
  137. }
  138. /**
  139. *
  140. * @param eaid 报销编号
  141. * @param status 状态 0创建 1发起 2通过 3驳回 4修改
  142. * @param str 备注
  143. */
  144. private void addExpenseAccountLog(Integer eaid, Integer status,Integer processStatus,String aid, String str,Date date) {
  145. if (aid==null)aid=TokenManager.getAdminId();
  146. ExpenseAccountLog eaLog=new ExpenseAccountLog();
  147. eaLog.setEaid(eaid);
  148. eaLog.setStatus(status);
  149. eaLog.setRemarks(str);
  150. eaLog.setProcessStatus(processStatus);
  151. eaLog.setAuditor(aid);
  152. if (date !=null)eaLog.setCreateTime(date);
  153. expenseAccountLogMapper.insertSelective(eaLog);
  154. }
  155. private void addExpenseAccountLogAndNoticEmail(InputExpenseAccount in, Integer status, String str) {
  156. String aid=TokenManager.getAdminId();
  157. addExpenseAccountLog(in.getId(),status,in.getProcessStatus(),aid,str);
  158. //正常是走入上级审核,但是可能会跳过
  159. if(status>0){
  160. Admin admin = adminMapper.selectByPrimaryKey(aid);
  161. if (admin.getSuperiorId()==null||admin.getId().equals(admin.getSuperiorId())){
  162. String str2=String.format("重复审核人跳过[%s]。",EAProcessStatus.getDesc(in.getProcessStatus()));
  163. Date date=new Date();
  164. date.setTime(date.getTime()+1000L);
  165. addExpenseAccountLog(in.getId(),1,in.getProcessStatus(),aid,str2,date);
  166. in.setProcessStatus(in.getProcessStatus()+1);
  167. }
  168. createExamineByProcess(in);
  169. }
  170. }
  171. private void createExamineByProcess(InputExpenseAccount in) {
  172. //审核流程推送到最新
  173. examineByprocess(in);
  174. List<Admin> aids=new ArrayList<>();
  175. AdminListBo admin = adminMapper.getDeptNameByAid(in.getAid());
  176. if(in.getProcessStatus()== EAProcessStatus.SJSH.getCode()){
  177. //获取上级
  178. Admin superAdmin = adminMapper.selectByPrimaryKey(admin.getSuperiorId());
  179. aids.add(superAdmin);
  180. in.setExamineName(superAdmin.getName());
  181. }else if (in.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  182. //获取财务负责人
  183. Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
  184. aids.add(finaceAdmin);
  185. in.setExamineName(finaceAdmin.getName());
  186. }else if (in.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
  187. //获取部门负责人
  188. List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  189. if (!list.isEmpty())aids.addAll(list);
  190. in.setExamineName(getAdmins(list));
  191. }else if (in.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
  192. //获取总裁、董事长等审核
  193. List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  194. if (!list.isEmpty())aids.addAll(list);
  195. in.setExamineName(getAdmins(list));
  196. }
  197. StringBuffer str=new StringBuffer().append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
  198. addNoticeAndEmail(in, 1,str.toString(), admin.getName(),aids);
  199. }
  200. @Override
  201. public int update(InputExpenseAccount in) {
  202. OutExpenseAccount useEA = expenseAccountMapper.selectByid(in.getId());
  203. if (useEA.getStatus()!=0&&useEA.getStatus()!=3){
  204. throw new BusinessException("不能操作审核中与完成的订单");
  205. }
  206. if (in.getStartTimeStr()!=null&&in.getEndTimeStr()!=null){
  207. in.setReleaseStart(DateUtils.StringToDate(in.getStartTimeStr(), AFTConstants.YYYYMMDDHHMMSS));
  208. in.setReleaseEnd(DateUtils.StringToDate(in.getEndTimeStr(), AFTConstants.YYYYMMDDHHMMSS));
  209. }
  210. if(in.getStatus()==1){
  211. in.setProcessStatus(1);
  212. }
  213. //计算总金额
  214. if (in.getTotalAmount()==null){
  215. in.setTotalAmount(expenseAccountDetailsMapper.selectAmountCountByEAid(in.getId()));
  216. }
  217. if (useEA.getStatus()==0){
  218. addExpenseAccountLogAndNoticEmail(in,1,"发起报销审核");
  219. }else if (useEA.getStatus()==3){
  220. addExpenseAccountLogAndNoticEmail(in,4,"修改并发起审核");
  221. }
  222. if (in.getOrderNo()==null){
  223. in.setTargetType(0);
  224. }else {
  225. in.setTargetType(1);
  226. }
  227. in.setSettlementAmount(useEA.getSettlementAmount());
  228. //计算本单已扣金额
  229. if (in.getDebitId()!=null){
  230. //如果以前没有选择借支,修改报销和借支数据
  231. if (useEA.getDebitId()==null){
  232. pushExpenseAccountDebit(in);
  233. }else if (useEA.getDebitId()!=in.getDebitId()) {
  234. //如果是修改编号
  235. pushExpenseAccountDebit(in);
  236. //并且要处理原编号的问题
  237. pushresettingDebit(in,useEA.getDebitId());
  238. }
  239. }
  240. return expenseAccountMapper.updateByPrimaryKeySelective(in);
  241. }
  242. private void pushresettingDebit(InputExpenseAccount in, Integer debitId) {
  243. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(debitId);
  244. ExpenseAccount newdebit=new ExpenseAccount();
  245. newdebit.setSettlementAmount(debit.getSettlementAmount().subtract(in.getSettlementAmount()));
  246. if (newdebit.getSettlementAmount().compareTo(new BigDecimal(0))==0){
  247. newdebit.setLiquidationStatus(0);
  248. }else {
  249. newdebit.setLiquidationStatus(1);
  250. }
  251. expenseAccountMapper.updateByPrimaryKeySelective(newdebit);
  252. }
  253. private void pushExpenseAccountDebit(InputExpenseAccount in) {
  254. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(in.getDebitId());
  255. ExpenseAccount newDebit=new ExpenseAccount();
  256. newDebit.setId(debit.getId());
  257. //计算剩余需要支付金额
  258. BigDecimal decbitAmount=in.getTotalAmount().subtract(in.getSettlementAmount());
  259. //本次金额大于等于需要抵扣金额,则变成完全抵扣,抵扣金额变成本次已付金额
  260. if (in.getTotalAmount().compareTo(decbitAmount)>0){
  261. in.setSettlementAmount(decbitAmount);
  262. newDebit.setSettlementAmount(debit.getTotalAmount());
  263. newDebit.setLiquidationStatus(2);
  264. }else {
  265. // 本次金额小于需要抵扣,则本次变更全抵扣,借支已付加上本次金额
  266. in.setSettlementAmount(in.getTotalAmount());
  267. newDebit.setSettlementAmount(debit.getSettlementAmount().add(in.getTotalAmount()));
  268. newDebit.setLiquidationStatus(1);
  269. }
  270. expenseAccountMapper.updateByPrimaryKeySelective(newDebit);
  271. }
  272. @Override
  273. public int addDetails(InputExpenseAccountDetails in) {
  274. if (in.getAgreeTimes()!=null){
  275. in.setAgreeTime(DateUtils.StringToDate(in.getAgreeTimes(),AFTConstants.YYYYMMDD));
  276. }
  277. return expenseAccountDetailsMapper.insertSelective(in);
  278. }
  279. @Override
  280. public int deleteDetails(Integer id) {
  281. return expenseAccountDetailsMapper.deleteByPrimaryKey(id);
  282. }
  283. @Override
  284. public List<OutExpenseAccountDetails> detailsList(Integer eaid) {
  285. return expenseAccountDetailsMapper.selectByEAid(eaid);
  286. }
  287. @Override
  288. public Object logList(Integer eaid) {
  289. List<OutExpenseAccountLog> list = expenseAccountLogMapper.selectByEaid(eaid);
  290. int maxProcessStatus=list.get(list.size()-1).getProcessStatus();
  291. List<OutExpenseAccountLog> eaelist = expenseAccountExamineMapper.selectNotExamineByEaidAndProcessStatus(eaid, maxProcessStatus);
  292. list.addAll(eaelist);
  293. return list;
  294. }
  295. @Override
  296. public int updateExamine(InputExpenseAccount in) {
  297. ExpenseAccount useEa = expenseAccountMapper.selectByPrimaryKey(in.getId());
  298. ExpenseAccount newEa=new ExpenseAccount();
  299. newEa.setId(useEa.getId());
  300. //审核通知 获取发送人
  301. addExamineExpenseAccountLog(in, useEa, newEa);
  302. //完成申请
  303. if (in.getStatus()==2){
  304. //如果是借支则订单新增
  305. if (in.getType()!=4){
  306. //不然就看是否挂载借支订单进行抵扣
  307. if (useEa.getDebitId()!=null){
  308. ExpenseAccount useDebit=expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
  309. if (useDebit.getLiquidationStatus()==2){
  310. List<ExpenseAccount> expenseAccounts = expenseAccountMapper.selectByDebit(useDebit.getDebitId());
  311. boolean flag=true;
  312. for (ExpenseAccount expenseAccount : expenseAccounts) {
  313. if(expenseAccount.getStatus()!=2){
  314. flag=flag;
  315. break;
  316. }
  317. }
  318. if (flag){
  319. ExpenseAccount debit=new ExpenseAccount();
  320. debit.setId(useEa.getDebitId());
  321. debit.setLiquidationStatus(3);
  322. expenseAccountMapper.updateByPrimaryKeySelective(debit);
  323. }
  324. }
  325. }
  326. }
  327. }
  328. //审核处理审核表
  329. pushExpenseAccountExamine(in);
  330. expenseAccountMapper.updateByPrimaryKeySelective(newEa);
  331. return 1;
  332. }
  333. private void pushExpenseAccountExamine(InputExpenseAccount in) {
  334. if (in.getStatus()==1){
  335. expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),TokenManager.getAdminId(),1);
  336. }else if (in.getStatus()==3){
  337. expenseAccountExamineMapper.updateStatusByEaidAndAid(in.getId(),null,0);
  338. }
  339. }
  340. private void addExamineExpenseAccountLog(InputExpenseAccount in, ExpenseAccount useEa, ExpenseAccount newEa) {
  341. List<Admin> aids=new ArrayList<>();
  342. StringBuffer str=new StringBuffer();
  343. Integer status=in.getStatus();
  344. AdminListBo admin = adminMapper.getDeptNameByAid(useEa.getAid());
  345. if (status==1){
  346. str=str.append("您有报销需要审核,").append("报销编号[").append(in.getId()).append("]").append(",请查看并审核。");
  347. newEa.setProcessStatus(useEa.getProcessStatus()+1);
  348. pushExamineProcess(newEa);
  349. if (newEa.getProcessStatus()== EAProcessStatus.CWSH.getCode()){
  350. //获取财务负责人
  351. Admin finaceAdmin = adminMapper.selectByPrimaryKey(admin.getDepFinance());
  352. aids.add(finaceAdmin);
  353. newEa.setExamineName(finaceAdmin.getName());
  354. }else if (newEa.getProcessStatus()== EAProcessStatus.ZJLSH.getCode()){
  355. //获取部门负责人
  356. List<Admin> list = adminMapper.listAdminBydepIdAndRoleType(admin.getDepartmentId(), AFTConstants.SALESMAN_ADMIN);
  357. if (!list.isEmpty())aids.addAll(list);
  358. newEa.setExamineName(getAdmins(list));
  359. }else if (newEa.getProcessStatus()== EAProcessStatus.DSZSH.getCode()){
  360. //获取总裁、董事长等审核
  361. List<Admin> list = adminMapper.selectAdminByRoleType(AFTConstants.All_CED_AND_CHAIRMAN);
  362. if (!list.isEmpty())aids.addAll(list);
  363. newEa.setExamineName(getAdmins(list));
  364. }else if (newEa.getProcessStatus()== EAProcessStatus.WCSH.getCode()){
  365. //获取报销申请人
  366. status =2;
  367. aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
  368. newEa.setStatus(status);
  369. newEa.setExamineName("");
  370. str.setLength(0);
  371. str=str.append("您的报销审核已通过,报销编号[").append(in.getId()).append("],请注意查看。");
  372. }
  373. }else {
  374. aids.add(adminMapper.selectByPrimaryKey(admin.getId()));
  375. newEa.setStatus(3);
  376. newEa.setProcessStatus(0);
  377. str.setLength(0);
  378. str=str.append("您的报销审核已驳回,报销编号[").append(in.getId()).append("],请注意查看。");
  379. }
  380. if (newEa.getStatus()==null)newEa.setStatus(1);
  381. addExpenseAccountLog(in.getId(),status,useEa.getProcessStatus(),TokenManager.getAdminId(),in.getReason());
  382. addNoticeAndEmail(in, status,str.toString(),admin.getName(),aids);
  383. }
  384. private void pushExamineProcess( ExpenseAccount newEa) {
  385. //如果到了董事长审核,无需判断了
  386. if (newEa.getProcessStatus()<EAProcessStatus.WCSH.getCode()){
  387. //判断没一个流程是否可以跳过
  388. examineByprocess(newEa);
  389. }
  390. }
  391. private void examineByprocess( ExpenseAccount newEa) {
  392. List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(newEa.getId(), newEa.getProcessStatus());
  393. boolean flag=false;
  394. for (ExpenseAccountExamine e : list) {
  395. if (e.getStatus()==1){
  396. flag=true;
  397. break;
  398. }
  399. }
  400. if (flag){
  401. String str=String.format("重复审核人跳过[%s]。",EAProcessStatus.getDesc(newEa.getProcessStatus()));
  402. Date date=new Date();
  403. date.setTime(date.getTime()+1000l);
  404. addExpenseAccountLog(newEa.getId(),1,newEa.getProcessStatus(),TokenManager.getAdminId(),str,date);
  405. newEa.setProcessStatus(newEa.getProcessStatus()+1);
  406. if (newEa.getProcessStatus()<EAProcessStatus.WCSH.getCode())examineByprocess(newEa);
  407. }
  408. }
  409. private String getAdmins(List<Admin> list) {
  410. StringBuffer str =new StringBuffer();
  411. for (Admin admin : list) {
  412. str=str.append(admin.getName()).append(",");
  413. }
  414. return str.substring(0,str.length()-1);
  415. }
  416. private void addNoticeAndEmail(InputExpenseAccount in, Integer status, String str,String aname, List<Admin> aids) {
  417. Date date= new Date();
  418. Integer noticeStatus=NoticeStatus.EXPENSE_NOTICE.getCode();
  419. if (status==2){
  420. noticeStatus=NoticeStatus.EXPENSE_COMPLETE.getCode();
  421. }
  422. List<Notice> list=new ArrayList<>();
  423. if (aids!=null){
  424. for (Admin a : aids) {
  425. Notice notice=new Notice();
  426. notice.setId(UUID.randomUUID().toString());
  427. notice.setNoticeType(noticeStatus);
  428. notice.setType(NoticeTypes.getType(noticeStatus));
  429. notice.setAid(a.getId());
  430. notice.setCreateTime(date);
  431. notice.setContent(str);
  432. notice.setReaded(0);
  433. list.add(notice);
  434. EmailBo emailBo=new EmailBo(NoticeStatus.getValueByCode(noticeStatus),a.getEmail(),str);
  435. asyncUtils.send(emailBo);
  436. weChatUtils.addExpenseAccountWeChatNotice(a.getExpenseOpenId(),status,in.getId(),date,aname,str);
  437. }
  438. asyncUtils.addNoticeBatch(list);
  439. }
  440. }
  441. @Override
  442. public Object pageList(InputPageListBo in) {
  443. Map<String ,Object> param=new HashMap<>();
  444. addParam(in, param);
  445. return findPage("selectExpenseAccountList", "selectExpenseAccountCount", param, in.getPageNo(), in.getPageSize());
  446. }
  447. @Override
  448. public Object selectByPrid(InputExpenseAccount in) {
  449. Integer id=null;
  450. in.setAid(TokenManager.getAdminId());
  451. OutExpenseAccount useEa = expenseAccountMapper.selectByaidAndPrid(in);
  452. if (useEa!=null&&useEa.getId()!=null)id=useEa.getId();
  453. return id;
  454. }
  455. @Override
  456. public Object selectById(Integer id) {
  457. OutExpenseAccount useEa = expenseAccountMapper.selectByid(id);
  458. List<ExpenseAccountExamine> list = expenseAccountExamineMapper.selectByEaidAndProcessStatus(id, useEa.getProcessStatus());
  459. boolean flag=false;
  460. for (ExpenseAccountExamine e : list) {
  461. if (e.getAuditor().equals(TokenManager.getAdminId())){
  462. flag=true;
  463. break;
  464. }
  465. }
  466. if (flag){
  467. useEa.setExamine(1);
  468. }else {
  469. useEa.setExamine(0);
  470. }
  471. if (useEa.getDebitId()!=null){
  472. ExpenseAccount debit = expenseAccountMapper.selectByPrimaryKey(useEa.getDebitId());
  473. if (debit!=null&&debit.getTotalAmount()!=null){
  474. useEa.setDebitTotalAmount(debit.getTotalAmount().subtract(debit.getSettlementAmount()));
  475. }
  476. }
  477. return useEa;
  478. }
  479. @Override
  480. public Object updateType(InputExpenseAccount in) {
  481. expenseAccountDetailsMapper.deleteByeaid(in.getId());
  482. return expenseAccountMapper.updateByPrimaryKeySelective(in);
  483. }
  484. @Override
  485. public List<OutExpenseAccount> selectDebitOrder(String depId) {
  486. String aid= TokenManager.getAdminId();
  487. return expenseAccountMapper.selectByaidAndType(aid,depId,4);
  488. }
  489. private void addParam(InputPageListBo in, Map<String, Object> param) {
  490. param.put("aid",TokenManager.getAdminId());
  491. if (in.getStartTime()!=null&&in.getEndTime()!=null){
  492. param.put("startTime",in.getStartTime());
  493. param.put("endTime",in.getEndTime()+" 23:59:59");
  494. }
  495. if (in.getStatus()!=null)param.put("status",in.getStatus());
  496. if (in.getProcessStatus()==null){
  497. param.put("processStatus",0);
  498. }else {
  499. param.put("processStatus",in.getProcessStatus());
  500. }
  501. if (in.getExamineStatus()!=null){
  502. param.put("examineStatus",in.getExamineStatus());
  503. }else {
  504. param.put("examineStatus",0);
  505. }
  506. if (in.getContractNo()!=null)param.put("contractNo",in.getContractNo());
  507. if (in.getDepId()!=null)param.put("depId",in.getDepId());
  508. if (in.getUsername()!=null)param.put("username",in.getUsername());
  509. if (in.getApplyDep()!=null)param.put("applyDep",in.getApplyDep());
  510. if (in.getPayDep()!=null)param.put("payDep",in.getPayDep());
  511. if (in.getType()!=null)param.put("type",in.getContractNo());
  512. }
  513. /**
  514. * 检查权限判断是否是总裁、董事长或超级管理员权限
  515. * @return
  516. */
  517. private boolean checkShiroCED() {
  518. if (TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.CED_ASSISTANT)||
  519. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION_ASSISTANT)
  520. ||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){
  521. return true;
  522. }
  523. return false;
  524. }
  525. @Override
  526. public Object statistics(String name,String depId,String startTime,String endTime) {
  527. if (endTime!=null)endTime=endTime+" 23:59:59";
  528. List<OutExpenseAccountStatistics> list = expenseAccountMapper.selectStatistics(name, depId, startTime, endTime);
  529. List<OutExpenseAccountStatistics> results=new ArrayList<>();
  530. Map<String ,Object> map=new HashMap<>();
  531. for (OutExpenseAccountStatistics e : list) {
  532. //如果是报销有选择抵扣预借支则算入抵扣
  533. if (e.getBx()==1){
  534. if (e.getDebitId()!=null){
  535. e.setDk(1);
  536. e.setDkAmount(e.getBxAmout());
  537. }
  538. if (e.getTargetType()==0){
  539. e.setGdfyAmount(e.getBxAmout());
  540. }else if (e.getTargetType()==1){
  541. e.setBxddAmount(e.getBxAmout());
  542. }
  543. }
  544. //如果不存在就新增
  545. if (!map.keySet().contains(e.getAid())){
  546. List<OutExpenseAccountStatistics> list2=new ArrayList<>();
  547. list2.add(e);
  548. map.put(e.getAid(),list2);
  549. }else {
  550. List<OutExpenseAccountStatistics> list2 = (List<OutExpenseAccountStatistics>) map.get(e.getAid());
  551. list2.add(e);
  552. }
  553. }
  554. for (String s : map.keySet()) {
  555. List<OutExpenseAccountStatistics> list3 = (List<OutExpenseAccountStatistics>) map.get(s);
  556. if (!list3.isEmpty()){
  557. OutExpenseAccountStatistics out =new OutExpenseAccountStatistics(s);
  558. for (OutExpenseAccountStatistics e : list3) {
  559. if (out.getAname()==null)out.setAname(e.getAname());
  560. if (e.getBx()!=null)out.setBx(out.getBx()+e.getBx());
  561. if (e.getJz()!=null)out.setJz(out.getJz()+e.getJz());
  562. if (e.getDk()!=null)out.setDk(out.getDk()+e.getDk());
  563. if (e.getBxAmout()!=null)out.setBxAmout(out.getBxAmout().add(e.getBxAmout()));
  564. if (e.getJzAmount()!=null)out.setJzAmount(out.getJzAmount().add(e.getJzAmount()));
  565. if (e.getDkAmount()!=null)out.setDkAmount(out.getDkAmount().add(e.getDkAmount()));
  566. if (e.getGdfyAmount()!=null)out.setGdfyAmount(out.getGdfyAmount().add(e.getGdfyAmount()));
  567. if (e.getBxddAmount()!=null)out.setBxddAmount(out.getBxddAmount().add(e.getBxddAmount()));
  568. if (e.getWshs()!=null)out.setWshs(out.getWshs()+e.getWshs());
  569. if (e.getBhs()!=null)out.setBhs(out.getBhs()+e.getBhs());
  570. }
  571. BigDecimal totalAmount=new BigDecimal(0);
  572. totalAmount=totalAmount.add(out.getBxAmout()).add(out.getJzAmount()).subtract(out.getDkAmount());
  573. out.setTotalAmount(totalAmount);
  574. results.add(out);
  575. }
  576. }
  577. return results;
  578. }
  579. }