TWarehousebillsfeesServiceImpl.java 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190
  1. package com.ruoyi.warehouseBusiness.service.impl;
  2. import com.ruoyi.common.utils.DateUtils;
  3. import com.ruoyi.common.utils.StringUtils;
  4. import com.ruoyi.finance.excel.FleetExcel;
  5. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsfees;
  6. import com.ruoyi.warehouseBusiness.mapper.TWarehousebillsfeesMapper;
  7. import com.ruoyi.warehouseBusiness.service.ITWarehousebillsfeesService;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Service;
  10. import java.math.BigDecimal;
  11. import java.util.ArrayList;
  12. import java.util.List;
  13. import java.util.Map;
  14. /**
  15. * 仓库费用明细Service业务层处理
  16. *
  17. * @author ruoyi
  18. * @date 2020-12-11
  19. */
  20. @Service
  21. public class TWarehousebillsfeesServiceImpl implements ITWarehousebillsfeesService {
  22. @Autowired
  23. private TWarehousebillsfeesMapper tWarehousebillsfeesMapper;
  24. /**
  25. * 查询仓库费用明细
  26. *
  27. * @param fId 仓库费用明细ID
  28. * @return 仓库费用明细
  29. */
  30. @Override
  31. public TWarehousebillsfees selectTWarehousebillsfeesById(Long fId) {
  32. return tWarehousebillsfeesMapper.selectTWarehousebillsfeesById(fId);
  33. }
  34. /**
  35. * 查询仓库费用明细列表
  36. *
  37. * @param tWarehousebillsfees 仓库费用明细
  38. * @return 仓库费用明细
  39. */
  40. @Override
  41. public List<TWarehousebillsfees> selectTWarehousebillsfeesList(TWarehousebillsfees tWarehousebillsfees) {
  42. return tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(tWarehousebillsfees);
  43. }
  44. /**
  45. * 新增仓库费用明细
  46. *
  47. * @param tWarehousebillsfees 仓库费用明细
  48. * @return 结果
  49. */
  50. @Override
  51. public int insertTWarehousebillsfees(TWarehousebillsfees tWarehousebillsfees) {
  52. tWarehousebillsfees.setCreateTime(DateUtils.getNowDate());
  53. return tWarehousebillsfeesMapper.insertTWarehousebillsfees(tWarehousebillsfees);
  54. }
  55. /**
  56. * 修改仓库费用明细
  57. *
  58. * @param tWarehousebillsfees 仓库费用明细
  59. * @return 结果
  60. */
  61. @Override
  62. public int updateTWarehousebillsfees(TWarehousebillsfees tWarehousebillsfees) {
  63. tWarehousebillsfees.setUpdateTime(DateUtils.getNowDate());
  64. return tWarehousebillsfeesMapper.updateTWarehousebillsfees(tWarehousebillsfees);
  65. }
  66. /**
  67. * 批量删除仓库费用明细
  68. *
  69. * @param fIds 需要删除的仓库费用明细ID
  70. * @return 结果
  71. */
  72. @Override
  73. public int deleteTWarehousebillsfeesByIds(Long[] fIds) {
  74. return tWarehousebillsfeesMapper.deleteTWarehousebillsfeesByIds(fIds);
  75. }
  76. /**
  77. * 删除仓库费用明细信息
  78. *
  79. * @param fId 仓库费用明细ID
  80. * @return 结果
  81. */
  82. @Override
  83. public int deleteTWarehousebillsfeesById(Long fId) {
  84. return tWarehousebillsfeesMapper.deleteTWarehousebillsfeesById(fId);
  85. }
  86. /**
  87. * 查询报表
  88. * @param tWarehousebillsfees
  89. * @return
  90. */
  91. @Override
  92. public List<FleetExcel> selectFleetExcelList(TWarehousebillsfees tWarehousebillsfees) {
  93. List<FleetExcel> fleetExcelList = new ArrayList<>();
  94. // 开始月份
  95. int startMonth = 1;
  96. // 结束月份
  97. int endMonth = 1;
  98. if (StringUtils.isNotEmpty(tWarehousebillsfees.getfYears())) {
  99. // 年份
  100. List<String> month = tWarehousebillsfees.getfMonth();
  101. if (StringUtils.isNotEmpty(month.get(0))) {
  102. startMonth = Integer.parseInt(month.get(0));
  103. }
  104. if (StringUtils.isNotEmpty(month.get(1))) {
  105. endMonth = Integer.parseInt(month.get(1));
  106. }
  107. if (endMonth < startMonth) {
  108. return null;
  109. }
  110. for (int i = startMonth; i <= endMonth; i++) {
  111. String firstDay = DateUtils.getFirstDay(Integer.parseInt(tWarehousebillsfees.getfYears()), i);
  112. String lastDay = DateUtils.getLastDay(Integer.parseInt(tWarehousebillsfees.getfYears()), i);
  113. month.set(0, firstDay);
  114. month.set(1, lastDay);
  115. tWarehousebillsfees.setfMonth(month);
  116. List<FleetExcel> fleetExcels = tWarehousebillsfeesMapper.selectFleetExcelList(tWarehousebillsfees);
  117. if (StringUtils.isNotEmpty(fleetExcels)) {
  118. for (FleetExcel e : fleetExcels) {
  119. fleetExcelList.add(e);
  120. }
  121. fleetExcelList.add(tWarehousebillsfeesMapper.selectFleetExcelMonthList(tWarehousebillsfees));
  122. }
  123. }
  124. }
  125. return fleetExcelList;
  126. }
  127. /**
  128. * 查询报表合计
  129. * @param fleetExcelsList
  130. * @return
  131. */
  132. @Override
  133. public List<String> selectFleetExcel(List<FleetExcel> fleetExcelsList) {
  134. List<String> stringList = new ArrayList<>();
  135. if (StringUtils.isEmpty(fleetExcelsList)) {
  136. stringList.add("0");
  137. stringList.add("0");
  138. stringList.add("0");
  139. return stringList;
  140. }
  141. BigDecimal ccf = new BigDecimal(0);
  142. BigDecimal fAmount = new BigDecimal(0);
  143. BigDecimal totalAmount = new BigDecimal(0);
  144. for (FleetExcel f : fleetExcelsList) {
  145. if (StringUtils.isEmpty(f.getUserName())) {
  146. if (StringUtils.isNotEmpty(f.getCcf())) {
  147. ccf = ccf.add(new BigDecimal(f.getCcf()));
  148. } else {
  149. ccf = ccf.add(new BigDecimal(0));
  150. }
  151. if (StringUtils.isNotEmpty(f.getfAmount())) {
  152. fAmount = fAmount.add(new BigDecimal(f.getfAmount()));
  153. } else {
  154. fAmount = fAmount.add(new BigDecimal(0));
  155. }
  156. if (StringUtils.isNotEmpty(f.getTotalAmount())) {
  157. totalAmount = totalAmount.add(new BigDecimal(f.getTotalAmount()));
  158. } else {
  159. totalAmount = totalAmount.add(new BigDecimal(0));
  160. }
  161. }
  162. }
  163. stringList.add(ccf + "");
  164. stringList.add(fAmount + "");
  165. stringList.add(totalAmount + "");
  166. return stringList;
  167. }
  168. @Override
  169. public List<Map<String, Object>> accountsDue() {
  170. return tWarehousebillsfeesMapper.accountsDue();
  171. }
  172. @Override
  173. public List<Map<String, Object>> selectQueryMenuList(TWarehousebillsfees tWarehousebillsfees) {
  174. return tWarehousebillsfeesMapper.selectQueryMenuList(tWarehousebillsfees);
  175. }
  176. }