GenerateBillProTemplate.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385
  1. package com.java110.job.task.fee;
  2. import com.java110.core.factory.GenerateCodeFactory;
  3. import com.java110.dto.RoomDto;
  4. import com.java110.dto.community.CommunityDto;
  5. import com.java110.dto.fee.*;
  6. import com.java110.dto.owner.OwnerCarDto;
  7. import com.java110.dto.owner.OwnerRoomRelDto;
  8. import com.java110.dto.task.TaskDto;
  9. import com.java110.intf.community.IParkingSpaceInnerServiceSMO;
  10. import com.java110.intf.community.IRoomInnerServiceSMO;
  11. import com.java110.intf.fee.IFeeConfigInnerServiceSMO;
  12. import com.java110.intf.fee.IFeeDetailInnerServiceSMO;
  13. import com.java110.intf.fee.IFeeInnerServiceSMO;
  14. import com.java110.intf.user.IOwnerCarInnerServiceSMO;
  15. import com.java110.intf.user.IOwnerRoomRelInnerServiceSMO;
  16. import com.java110.job.quartz.TaskSystemQuartz;
  17. import com.java110.service.smo.IComputeFeeSMO;
  18. import com.java110.utils.constant.ResponseConstant;
  19. import com.java110.utils.exception.TaskTemplateException;
  20. import com.java110.utils.util.DateUtil;
  21. import com.java110.utils.util.StringUtil;
  22. import org.springframework.beans.factory.annotation.Autowired;
  23. import org.springframework.stereotype.Component;
  24. import java.math.BigDecimal;
  25. import java.util.Calendar;
  26. import java.util.Date;
  27. import java.util.List;
  28. import java.util.Map;
  29. /**
  30. * @ClassName GenerateOwnerBillTemplate
  31. * @Description TODO 房屋费用账单生成
  32. * @Author wuxw
  33. * @Date 2020/6/4 8:33
  34. * @Version 1.0
  35. * add by wuxw 2020/6/4
  36. **/
  37. @Component
  38. public class GenerateBillProTemplate extends TaskSystemQuartz {
  39. private static final String TASK_ATTR_BILL_TYPE = "10002"; // 出账类型
  40. private static final String TASK_ATTR_VALUE_MONTH = "002"; //按月出账
  41. private static final String TASK_ATTR_VALUE_DAY = "003"; //按日出账
  42. private static final String TASK_ATTR_VALUE_YEAR = "001"; //按年出账
  43. private static final String TASK_ATTR_VALUE_ONCE_MONTH = "005"; //一次性按月出账
  44. @Autowired
  45. private IFeeConfigInnerServiceSMO feeConfigInnerServiceSMOImpl;
  46. @Autowired
  47. private IFeeInnerServiceSMO feeInnerServiceSMOImpl;
  48. @Autowired
  49. private IFeeDetailInnerServiceSMO feeDetailInnerServiceSMOImpl;
  50. @Autowired
  51. private IRoomInnerServiceSMO roomInnerServiceSMOImpl;
  52. @Autowired
  53. private IOwnerRoomRelInnerServiceSMO ownerRoomRelInnerServiceSMOImpl;
  54. @Autowired
  55. private IParkingSpaceInnerServiceSMO parkingSpaceInnerServiceSMOImpl;
  56. @Autowired
  57. private IOwnerCarInnerServiceSMO ownerCarInnerServiceSMOImpl;
  58. @Autowired
  59. private IComputeFeeSMO computeFeeSMOImpl;
  60. @Override
  61. protected void process(TaskDto taskDto) throws Exception {
  62. // 获取小区
  63. List<CommunityDto> communityDtos = getAllCommunity();
  64. for (CommunityDto communityDto : communityDtos) {
  65. GenerateBill(taskDto, communityDto);
  66. }
  67. }
  68. /**
  69. * 根据小区生成账单
  70. *
  71. * @param communityDto
  72. */
  73. private void GenerateBill(TaskDto taskDto, CommunityDto communityDto) {
  74. //查询费用项
  75. FeeConfigDto feeConfigDto = new FeeConfigDto();
  76. feeConfigDto.setCommunityId(communityDto.getCommunityId());
  77. feeConfigDto.setBillType(getCurTaskAttr(taskDto, TASK_ATTR_BILL_TYPE).getValue());
  78. if (StringUtil.isEmpty(feeConfigDto.getBillType())) {
  79. throw new IllegalArgumentException("配置错误 未拿到属性值");
  80. }
  81. List<FeeConfigDto> feeConfigDtos = feeConfigInnerServiceSMOImpl.queryFeeConfigs(feeConfigDto);
  82. for (FeeConfigDto tmpFeeConfigDto : feeConfigDtos) {
  83. try {
  84. GenerateBillByFeeConfig(taskDto, tmpFeeConfigDto);
  85. } catch (Exception e) {
  86. logger.error("费用出账失败" + tmpFeeConfigDto.getConfigId(), e);
  87. }
  88. }
  89. }
  90. /**
  91. * 按费用项来出账
  92. *
  93. * @param taskDto
  94. * @param feeConfigDto
  95. */
  96. private void GenerateBillByFeeConfig(TaskDto taskDto, FeeConfigDto feeConfigDto) throws Exception {
  97. //当前费用项是否
  98. BillDto tmpBillDto = new BillDto();
  99. tmpBillDto.setCurBill("T");
  100. tmpBillDto.setConfigId(feeConfigDto.getConfigId());
  101. tmpBillDto.setCommunityId(feeConfigDto.getCommunityId());
  102. Date startTime = getDefaultStartTime(feeConfigDto.getBillType());
  103. tmpBillDto.setCurBillTime(DateUtil.getFormatTimeString(startTime, DateUtil.DATE_FORMATE_STRING_A));
  104. List<BillDto> billDtos = feeInnerServiceSMOImpl.queryBills(tmpBillDto);
  105. //Assert.listOnlyOne(billDtos, "当前存在多个有效账单" + feeConfigDto.getConfigId());
  106. if (billDtos != null && billDtos.size() > 0) {
  107. throw new TaskTemplateException(ResponseConstant.RESULT_CODE_ERROR, "已经出过账了");
  108. }
  109. String billId = GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_billId);
  110. BillDto billDto = new BillDto();
  111. billDto.setBillId(billId);
  112. billDto.setBillName(feeConfigDto.getFeeName() + "-" + DateUtil.getFormatTimeString(new Date(), DateUtil.DATE_FORMATE_STRING_H));
  113. billDto.setBillTime(DateUtil.getFormatTimeString(new Date(), DateUtil.DATE_FORMATE_STRING_A));
  114. billDto.setCommunityId(feeConfigDto.getCommunityId());
  115. billDto.setConfigId(feeConfigDto.getConfigId());
  116. billDto.setCurBill("T");
  117. //查询历史有效账单
  118. tmpBillDto = new BillDto();
  119. tmpBillDto.setCurBill("T");
  120. tmpBillDto.setConfigId(feeConfigDto.getConfigId());
  121. tmpBillDto.setCommunityId(feeConfigDto.getCommunityId());
  122. billDtos = feeInnerServiceSMOImpl.queryBills(tmpBillDto);
  123. startTime = (billDtos == null || billDtos.size() < 1) ? getDefaultStartTime(feeConfigDto.getBillType())
  124. : DateUtil.getDateFromString(billDtos.get(0).getBillTime(), DateUtil.DATE_FORMATE_STRING_A);
  125. FeeDto feeDto = new FeeDto();
  126. feeDto.setConfigId(feeConfigDto.getConfigId());
  127. feeDto.setCommunityId(feeConfigDto.getCommunityId());
  128. List<FeeDto> feeDtos = feeInnerServiceSMOImpl.queryFees(feeDto);
  129. //没有关联费用不做出账
  130. if (feeDto == null || feeDtos.size() < 1) {
  131. return;
  132. }
  133. billDto.setReceivable("0");
  134. billDto.setReceipts("0");
  135. billDto.setCurReceivable("0");
  136. for (FeeDto tmpFeeDto : feeDtos) {
  137. try {
  138. generateFee(startTime, tmpFeeDto, billDto, feeConfigDto);
  139. } catch (Exception e) {
  140. logger.error("生成费用失败", e);
  141. }
  142. }
  143. //生成本次账单
  144. Date billEndTime = DateUtil.getCurrentDate();
  145. billDto.setRemark(DateUtil.getFormatTimeString(startTime, DateUtil.DATE_FORMATE_STRING_A) +
  146. "-" + DateUtil.getFormatTimeString(billEndTime, DateUtil.DATE_FORMATE_STRING_A) + "账单数据");
  147. feeInnerServiceSMOImpl.insertBill(billDto);
  148. }
  149. /**
  150. * 生成 费用
  151. *
  152. * @param feeDto
  153. */
  154. private void generateFee(Date startTime, FeeDto feeDto, BillDto billDto, FeeConfigDto feeConfigDto) {
  155. if (FeeDto.STATE_FINISH.equals(feeDto.getState())) { //判断是否缴费结束
  156. return;
  157. }
  158. // 当前时间 - 开始时间 = 月份
  159. // 月份/ 周期 = 轮数(向上取整)
  160. // 轮数 * 周期 * 30 + 开始时间 = 目标 到期时间
  161. // 到期时间 >= 目标到期时间===>结束
  162. // 目标到期时间 - 到期时间 = 欠费月份
  163. // 月份 * 每月单价 = 欠费金额
  164. Map<String, Object> targetEndDateAndOweMonth = computeFeeSMOImpl.getTargetEndDateAndOweMonth(feeDto);
  165. Date targetEndDate = (Date) targetEndDateAndOweMonth.get("targetEndDate");
  166. double oweMonth = (double) targetEndDateAndOweMonth.get("oweMonth");
  167. //当前时间
  168. Date billEndTime = DateUtil.getCurrentDate();
  169. //缴费周期
  170. long paymentCycle = Long.parseLong(feeConfigDto.getPaymentCycle());
  171. //说明没有欠费
  172. if (oweMonth <= 0.0) {
  173. return;
  174. }
  175. double tmpFeePrice = computeFeeSMOImpl.getFeePrice(feeDto);
  176. feeDto.setFeePrice(tmpFeePrice);
  177. if (feeDto.getFeePrice() <= 0) {
  178. return;//这个没有欠费可算
  179. }
  180. BillOweFeeDto billOweFeeDto = new BillOweFeeDto();
  181. billOweFeeDto.setOweId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_oweId));
  182. billOweFeeDto.setFeeId(feeDto.getFeeId());
  183. billOweFeeDto.setBillId(billDto.getBillId());
  184. BigDecimal curFeePrice = new BigDecimal(feeDto.getFeePrice());
  185. curFeePrice = curFeePrice.multiply(new BigDecimal(paymentCycle));
  186. billOweFeeDto.setAmountOwed(curFeePrice.doubleValue() + "");
  187. BigDecimal feePrice = new BigDecimal(feeDto.getFeePrice());
  188. feePrice = feePrice.multiply(new BigDecimal(oweMonth));
  189. billOweFeeDto.setBillAmountOwed(feePrice.doubleValue() + "");
  190. billOweFeeDto.setFeeEndTime(DateUtil.getFormatTimeString(feeDto.getEndTime(), DateUtil.DATE_FORMATE_STRING_A));
  191. billOweFeeDto.setCommunityId(feeDto.getCommunityId());
  192. billOweFeeDto.setPayerObjType(feeDto.getPayerObjType());
  193. billOweFeeDto.setState("1000");
  194. billOweFeeDto.setDeadlineTime(DateUtil.getFormatTimeString(targetEndDate, DateUtil.DATE_FORMATE_STRING_A));
  195. if (FeeDto.PAYER_OBJ_TYPE_ROOM.equals(feeDto.getPayerObjType())) {
  196. getRoomInfo(billOweFeeDto, feeDto);
  197. } else {
  198. getParkingSpaceInfo(billOweFeeDto, feeDto);
  199. }
  200. feeInnerServiceSMOImpl.insertBillOweFees(billOweFeeDto);
  201. double recFee = StringUtil.isEmpty(billDto.getReceivable()) ? 0.0 : Double.parseDouble(billDto.getReceivable());
  202. BigDecimal recFeeBig = new BigDecimal(recFee);
  203. BigDecimal newRecFee = recFeeBig.add(feePrice);
  204. //应收
  205. billDto.setReceivable(newRecFee.doubleValue() + "");
  206. //当期应收
  207. double curRecFee = StringUtil.isEmpty(billDto.getCurReceivable()) ? 0.0 : Double.parseDouble(billDto.getCurReceivable());
  208. BigDecimal curRecFeeBig = new BigDecimal(curRecFee);
  209. BigDecimal curNewRecFee = curRecFeeBig.add(curFeePrice);
  210. billDto.setCurReceivable(curNewRecFee.doubleValue() + "");
  211. FeeDetailDto feeDetailDto = new FeeDetailDto();
  212. feeDetailDto.setFeeId(feeDto.getFeeId());
  213. feeDetailDto.setCommunityId(feeDto.getCommunityId());
  214. feeDetailDto.setStartTime(startTime);
  215. feeDetailDto.setEndTime(billEndTime);
  216. List<FeeDetailDto> feeDetailDtos = feeDetailInnerServiceSMOImpl.queryFeeDetails(feeDetailDto);
  217. double curReceiptFee = StringUtil.isEmpty(billDto.getReceipts()) ? 0.0 : Double.parseDouble(billDto.getReceipts());
  218. BigDecimal curReceipts = new BigDecimal(curReceiptFee);
  219. if (feeDetailDtos != null && feeDetailDtos.size() > 0) {
  220. for (FeeDetailDto tmpFeeDetailDto : feeDetailDtos) {
  221. BigDecimal recAmount = new BigDecimal(Double.parseDouble(tmpFeeDetailDto.getReceivedAmount()));
  222. curReceipts = recAmount.add(curReceipts);
  223. }
  224. }
  225. billDto.setReceipts(curReceipts.doubleValue() + "");
  226. }
  227. /**
  228. * 查询车位信息
  229. *
  230. * @param billOweFeeDto
  231. * @param feeDto
  232. */
  233. private void getParkingSpaceInfo(BillOweFeeDto billOweFeeDto, FeeDto feeDto) {
  234. OwnerCarDto ownerCarDto = new OwnerCarDto();
  235. ownerCarDto.setWithOwner(true);
  236. ownerCarDto.setCarId(feeDto.getPayerObjId());
  237. ownerCarDto.setCommunityId(feeDto.getCommunityId());
  238. List<OwnerCarDto> ownerCarDtos = ownerCarInnerServiceSMOImpl.queryOwnerCars(ownerCarDto);
  239. if (ownerCarDtos == null || ownerCarDtos.size() < 1) {
  240. //房屋可能被删除了
  241. billOweFeeDto.setOwnerId("1");
  242. billOweFeeDto.setOwnerName("未知");
  243. billOweFeeDto.setOwnerTel("19999999999");
  244. return;
  245. }
  246. billOweFeeDto.setPayerObjName(ownerCarDtos.get(0).getCarNum());
  247. billOweFeeDto.setOwnerId(ownerCarDtos.get(0).getOwnerId());
  248. billOweFeeDto.setOwnerName(ownerCarDtos.get(0).getOwnerName());
  249. billOweFeeDto.setOwnerTel(ownerCarDtos.get(0).getLink());
  250. }
  251. /**
  252. * 查询房屋信息
  253. *
  254. * @param billOweFeeDto
  255. * @param feeDto
  256. */
  257. private void getRoomInfo(BillOweFeeDto billOweFeeDto, FeeDto feeDto) {
  258. RoomDto roomDto = new RoomDto();
  259. roomDto.setRoomId(feeDto.getPayerObjId());
  260. roomDto.setCommunityId(feeDto.getCommunityId());
  261. List<RoomDto> roomDtos = roomInnerServiceSMOImpl.queryRooms(roomDto);
  262. if (roomDtos == null || roomDtos.size() < 1) {
  263. //房屋可能被删除了
  264. billOweFeeDto.setOweId("1");
  265. billOweFeeDto.setOwnerName("未知");
  266. billOweFeeDto.setOwnerTel("19999999999");
  267. billOweFeeDto.setPayerObjName("未知");
  268. return;
  269. }
  270. RoomDto tmpRoomDto = roomDtos.get(0);
  271. billOweFeeDto.setPayerObjName(tmpRoomDto.getFloorNum() + "栋" + tmpRoomDto.getUnitNum() + "单元" + tmpRoomDto.getRoomNum() + "室");
  272. OwnerRoomRelDto ownerRoomRelDto = new OwnerRoomRelDto();
  273. ownerRoomRelDto.setByOwnerInfo(true);
  274. ownerRoomRelDto.setRoomId(tmpRoomDto.getRoomId());
  275. List<OwnerRoomRelDto> ownerRoomRelDtos = ownerRoomRelInnerServiceSMOImpl.queryOwnerRoomRels(ownerRoomRelDto);
  276. if (ownerRoomRelDtos == null || ownerRoomRelDtos.size() < 1) {
  277. //房屋可能被删除了
  278. billOweFeeDto.setOweId("1");
  279. billOweFeeDto.setOwnerName("未知");
  280. billOweFeeDto.setOwnerTel("19999999999");
  281. return;
  282. }
  283. billOweFeeDto.setOwnerId(ownerRoomRelDtos.get(0).getOwnerId());
  284. billOweFeeDto.setOwnerName(ownerRoomRelDtos.get(0).getOwnerName());
  285. billOweFeeDto.setOwnerTel(ownerRoomRelDtos.get(0).getLink());
  286. }
  287. private Date getDefaultStartTime(String billType) {
  288. Calendar calendar = Calendar.getInstance();
  289. calendar.setTime(new Date());
  290. if (billType.equals(TASK_ATTR_VALUE_MONTH)) {
  291. calendar.add(Calendar.MONTH, -1);
  292. return calendar.getTime();
  293. }
  294. if (billType.equals(TASK_ATTR_VALUE_DAY)) {
  295. calendar.add(Calendar.DATE, -1);
  296. return calendar.getTime();
  297. }
  298. if (billType.equals(TASK_ATTR_VALUE_DAY)) {
  299. calendar.add(Calendar.DATE, -1);
  300. return calendar.getTime();
  301. }
  302. if (billType.equals(TASK_ATTR_VALUE_YEAR)) {
  303. calendar.add(Calendar.YEAR, -1);
  304. return calendar.getTime();
  305. }
  306. return calendar.getTime();
  307. }
  308. }