SettlementService.java 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. package com.jeeplus.modules.sg.overheadline.service;
  2. import com.jeeplus.common.utils.excel.ImportExcel;
  3. import com.jeeplus.common.utils.sg.ExcelUtil;
  4. import com.jeeplus.modules.sg.overheadline.entity.Settlement;
  5. import com.jeeplus.modules.sg.overheadline.mapper.SettlementMapper;
  6. import com.jeeplus.modules.sg.overheadline.util.BashInfo;
  7. import com.jeeplus.modules.sg.overheadline.util.SettementUtil;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Service;
  10. import org.springframework.transaction.annotation.Transactional;
  11. import org.springframework.web.multipart.MultipartFile;
  12. import java.util.*;
  13. @Service
  14. public class SettlementService {
  15. @Autowired
  16. private SettlementMapper settlementMapper;
  17. /*
  18. 添加结算工程表
  19. */
  20. @Transactional
  21. public void save(Map<String,Object[]> builtMap, double builtTotal, double[] divisiontotal, double wordtotal, double otherTotal, double feescount, String id){
  22. List<Settlement> settlementList = BashInfo.getTotality(builtMap,builtTotal,divisiontotal,wordtotal,otherTotal,feescount,id);
  23. for (Settlement settlement:settlementList){
  24. settlementMapper.sava(settlement);
  25. }
  26. }
  27. /*
  28. 查找结算工程表
  29. */
  30. public List<Settlement> selectSettlementService(String id){
  31. List<Settlement> settlementList = settlementMapper.selectSettlement(id);
  32. Double money;
  33. String theAmout;
  34. String[] amout;
  35. String status;
  36. String reason;
  37. for(Settlement settlement:settlementList){
  38. money=0.0;
  39. reason="";
  40. String key = settlement.getEntryName();
  41. switch (key){
  42. case BashInfo.JS_FBFX:
  43. money = settlement.getMoney();
  44. theAmout = settlement.getTheAmount();
  45. amout = theAmout.split(",");
  46. status = settlement.getStatus();
  47. reason = SettementUtil.RESON_FBFX1.replaceAll("xxx",String.valueOf(money)).replace("yyy",amout[0]);
  48. settlement.setReason(reason);
  49. break;
  50. case BashInfo.JS_CBRF:
  51. money = settlement.getMoney();
  52. theAmout = settlement.getTheAmount();
  53. reason = SettementUtil.RESON_CBRF.replaceAll("xxx",String.valueOf(money)).replace("yyy",theAmout);
  54. settlement.setReason(reason);
  55. break;
  56. case BashInfo.JS_CSXM:
  57. money = settlement.getMoney();
  58. theAmout = settlement.getTheAmount();
  59. reason = SettementUtil.RESON_CSXM.replaceAll("xxx",String.valueOf(money)).replace("yyy",theAmout).replace("zzz","0.0").replace("www",String.valueOf(money));
  60. settlement.setReason(reason);
  61. break;
  62. case BashInfo.JS_QTXM:
  63. money = settlement.getMoney();
  64. theAmout = settlement.getTheAmount();
  65. reason = SettementUtil.RESON_QTXM.replaceAll("xxx",String.valueOf(money)).replace("yyy",theAmout);
  66. settlement.setReason(reason);
  67. break;
  68. case BashInfo.JS_GF:
  69. money = settlement.getMoney();
  70. theAmout = settlement.getTheAmount();
  71. reason = SettementUtil.RESON_GF.replaceAll("xxx",String.valueOf(money)).replace("yyy",theAmout);
  72. settlement.setReason(reason);
  73. break;
  74. case BashInfo.JS_SJ:
  75. reason = SettementUtil.RESON_SJ;
  76. settlement.setReason(reason);
  77. break;
  78. case BashInfo.JS_FBRF:
  79. money = settlement.getMoney();
  80. theAmout = settlement.getTheAmount();
  81. reason = SettementUtil.RESON_FBRF.replaceAll("xxx",String.valueOf(money)).replace("yyy",theAmout);
  82. settlement.setReason(reason);
  83. break;
  84. case BashInfo.JS_JGJS:
  85. money = settlement.getMoney();
  86. theAmout = settlement.getTheAmount();
  87. amout = theAmout.split(",");
  88. reason = SettementUtil.RESON_JGJS.replace("xxx",String.valueOf(money)).replace("yyy",amout[0]).replace("zzz",amout[1]).replace("qqq",amout[2]).replace("www",amout[3]).replace("nnn",amout[4]).replace("eee",amout[5]).replace("rrr",amout[6]).replace("ttt",amout[7]);
  89. settlement.setReason(reason);
  90. break;
  91. case BashInfo.JS_BZZS:
  92. reason = SettementUtil.RESON_BZZS;
  93. settlement.setReason(reason);
  94. break;
  95. case BashInfo.JS_KJJG:
  96. reason = SettementUtil.RESON_KJJG;
  97. settlement.setReason(reason);
  98. break;
  99. case BashInfo.GCJS:
  100. money = settlement.getMoney();
  101. theAmout = settlement.getTheAmount();
  102. amout=theAmout.split(",");
  103. reason = SettementUtil.RESON_GCJS.replace("xxx",String.valueOf(money)).replace("yyy",amout[0]).replace("zzz",amout[1]).replace("www",amout[2]).replace("ddd",amout[3]);
  104. settlement.setReason(reason);
  105. break;
  106. }
  107. }
  108. return settlementList;
  109. }
  110. public void delete(String id){
  111. settlementMapper.delete(id);
  112. }
  113. }