SettlementDocumentaryFeesServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. package com.ydtech.modules.fnc.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  6. import com.github.pagehelper.PageHelper;
  7. import com.github.pagehelper.PageInfo;
  8. import com.google.gson.Gson;
  9. import com.ydtech.core.page.HttpResult;
  10. import com.ydtech.exception.SystemException;
  11. import com.ydtech.modules.base.controller.BaseController;
  12. import com.ydtech.modules.fnc.dao.InsPlyIncomeMapper;
  13. import com.ydtech.modules.fnc.dao.SettlementDocumentaryFeesMapper;
  14. import com.ydtech.modules.fnc.entity.InsPlyIncome;
  15. import com.ydtech.modules.fnc.entity.SettlementDocumentaryFeesEntity;
  16. import com.ydtech.modules.fnc.entity.SettlementDocumentaryLogEntity;
  17. import com.ydtech.modules.fnc.service.IncomeTaskRelationshipService;
  18. import com.ydtech.modules.fnc.service.SettlementDocumentaryFeesService;
  19. import com.ydtech.modules.fnc.service.SettlementDocumentaryLogService;
  20. import com.ydtech.modules.fnc.vo.InsPlyIncomeVo;
  21. import com.ydtech.modules.fnc.vo.SettlementDocumentaryFeesVo;
  22. import com.ydtech.modules.order.entity.BasePageResult;
  23. import com.ydtech.modules.order.entity.InsOrders;
  24. import org.apache.commons.lang3.ObjectUtils;
  25. import org.apache.commons.lang3.StringUtils;
  26. import org.springframework.beans.BeanUtils;
  27. import org.springframework.beans.factory.annotation.Autowired;
  28. import org.springframework.stereotype.Service;
  29. import org.springframework.transaction.annotation.Transactional;
  30. import java.math.BigDecimal;
  31. import java.util.Date;
  32. import java.util.HashMap;
  33. import java.util.List;
  34. @Service
  35. public class SettlementDocumentaryFeesServiceImpl extends ServiceImpl<SettlementDocumentaryFeesMapper, SettlementDocumentaryFeesEntity> implements SettlementDocumentaryFeesService {
  36. @Autowired
  37. private SettlementDocumentaryLogService settlementDocumentaryLogService;
  38. @Autowired
  39. private InsPlyIncomeMapper insPlyIncomeMapper;
  40. @Autowired
  41. private IncomeTaskRelationshipService incomeTaskRelationshipService;
  42. @Override
  43. public HttpResult<BasePageResult<SettlementDocumentaryFeesEntity>> querySettle(SettlementDocumentaryFeesVo settlementDocumentaryFeesVo) {
  44. try {
  45. HashMap<String, Object> params = new HashMap<>();
  46. params.put("pageNum", settlementDocumentaryFeesVo.getPageNum());
  47. params.put("pageSize", settlementDocumentaryFeesVo.getPageSize());
  48. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getHandlingFeesStatus())) {
  49. params.put("handlingFeesStatus", settlementDocumentaryFeesVo.getHandlingFeesStatus());
  50. }
  51. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getAgreementType())) {
  52. params.put("agreementType", settlementDocumentaryFeesVo.getAgreementType());
  53. }
  54. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getIsNotCar())) {
  55. params.put("isNotCar", settlementDocumentaryFeesVo.getIsNotCar());
  56. }
  57. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getPartnerCompaniesId())) {
  58. params.put("partnerCompaniesId", settlementDocumentaryFeesVo.getPartnerCompaniesId());
  59. }
  60. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getParentId())) {
  61. params.put("parentId", settlementDocumentaryFeesVo.getParentId());
  62. }
  63. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getSettlementStatus())) {
  64. params.put("settlementStatus", settlementDocumentaryFeesVo.getSettlementStatus());
  65. }
  66. if (StringUtils.isNotEmpty(settlementDocumentaryFeesVo.getSettlementSumId())) {
  67. params.put("settlementSumId", settlementDocumentaryFeesVo.getSettlementSumId());
  68. }
  69. PageInfo<List<SettlementDocumentaryFeesEntity>> pageHelper = null;
  70. List<SettlementDocumentaryFeesEntity> list = this.baseMapper.querySettle(params);
  71. pageHelper = new PageInfo(list);
  72. BasePageResult<SettlementDocumentaryFeesEntity> pageResult = new BasePageResult<SettlementDocumentaryFeesEntity>(settlementDocumentaryFeesVo.getPageNum(), settlementDocumentaryFeesVo.getPageSize(), pageHelper.getTotal(), pageHelper.getPages(), list);
  73. return HttpResult.ok(pageResult);
  74. } catch (Exception e) {
  75. e.printStackTrace();
  76. return HttpResult.error("查询异常");
  77. }
  78. }
  79. @Override
  80. @Transactional
  81. public HttpResult inertSettle(SettlementDocumentaryFeesVo settlementDocumentaryFeesVo) {
  82. int i = this.compareAmount(settlementDocumentaryFeesVo.getTotalAmount(), settlementDocumentaryFeesVo.getSettlementAmount());
  83. if (i < 0) {
  84. return HttpResult.error("结算金额大于总金额,请重新结算");
  85. }
  86. SettlementDocumentaryFeesEntity settlementDocumentaryFeesEntity = new SettlementDocumentaryFeesEntity();
  87. BeanUtils.copyProperties(settlementDocumentaryFeesVo, settlementDocumentaryFeesEntity);
  88. baseMapper.insert(settlementDocumentaryFeesEntity);
  89. // 生成跟单费结算记录
  90. SettlementDocumentaryLogEntity settlementDocumentaryLogEntity = new SettlementDocumentaryLogEntity();
  91. settlementDocumentaryLogEntity.setAmount(settlementDocumentaryFeesVo.getSettlementAmount()); // 结算金额
  92. settlementDocumentaryLogEntity.setSettlementDocumentaryId(settlementDocumentaryFeesEntity.getId()); // 关联id
  93. settlementDocumentaryLogEntity.setAmountType("2"); //跟单费结算
  94. settlementDocumentaryLogEntity.setCreateTime(new Date());
  95. settlementDocumentaryLogService.save(settlementDocumentaryLogEntity);
  96. return HttpResult.ok("开票成功");
  97. }
  98. @Override
  99. @Transactional
  100. public HttpResult documentarySettle(SettlementDocumentaryFeesVo settlementDocumentaryFeesVo) {
  101. SettlementDocumentaryFeesEntity settlementDocumentaryFeesEntity = baseMapper.selectById(settlementDocumentaryFeesVo.getId());
  102. if (settlementDocumentaryFeesVo.getSettlementAmount() != null && ObjectUtils.isNotEmpty(settlementDocumentaryFeesEntity)) {
  103. int i = this.compareAmount(settlementDocumentaryFeesEntity.getUnsettledAmount(), settlementDocumentaryFeesVo.getSettlementAmount());
  104. if (i < 0) {
  105. return HttpResult.error("结算金额大于未结算金额,请重新结算");
  106. }
  107. settlementDocumentaryFeesEntity.setSettlementAmount(settlementDocumentaryFeesEntity.getSettlementAmount().add(settlementDocumentaryFeesVo.getSettlementAmount()));
  108. settlementDocumentaryFeesEntity.setUnsettledAmount(settlementDocumentaryFeesEntity.getTotalAmount().subtract(settlementDocumentaryFeesEntity.getSettlementAmount())); //未结算金额
  109. baseMapper.updateById(settlementDocumentaryFeesEntity);
  110. // 记录
  111. // 生成跟单费结算记录
  112. SettlementDocumentaryLogEntity settlementDocumentaryLogEntity = new SettlementDocumentaryLogEntity();
  113. settlementDocumentaryLogEntity.setAmount(settlementDocumentaryFeesVo.getSettlementAmount()); // 结算金额
  114. settlementDocumentaryLogEntity.setSettlementDocumentaryId(settlementDocumentaryFeesEntity.getId()); // 关联id
  115. settlementDocumentaryLogEntity.setAmountType("2"); //跟单费结算
  116. settlementDocumentaryLogEntity.setCreateTime(new Date());
  117. settlementDocumentaryLogService.save(settlementDocumentaryLogEntity);
  118. return HttpResult.ok("修改成功");
  119. }
  120. return null;
  121. }
  122. /**
  123. * @param invoiceIds 结算表的id
  124. * @return 返回开票号 开票金额 开票时间
  125. */
  126. @Override
  127. public List<HashMap<String, Object>> getOtherSettldetail(HashMap<String, Object> params) {
  128. return baseMapper.getOtherSettldetail(params);
  129. }
  130. /**
  131. * @param ids 开票ids
  132. * @param invoicingMethod 开票方式 0 保司开票 1 掌柜开票
  133. * @param taxPoints 税点
  134. */
  135. @Override
  136. public void batchByInvoice(String ids, String invoicingMethod, BigDecimal taxPoints, BigDecimal invoicCommissionFeevalue) {
  137. /**
  138. * 跟单开票处新增开票方式:保司开票/掌柜开票
  139. *
  140. * 如果是保司开票,需要填写税点,后续在结算时,税收成本算做支出项,进账金额=开票金额*(1-税点),但统计应收金额
  141. * ,开票金额,已收金额,开票未进账金额均按照不扣税点的金额核算。
  142. *
  143. * 如果是掌柜开票,需要填写税点,但后续结算时,进账金额=开票金额。
  144. *
  145. * */
  146. // 结算金额 收款金额=开票金额*(1-税点)
  147. HashMap<String, Object> params = new HashMap<>();
  148. params.put("ids", ids.split(","));
  149. baseMapper.batchByInvoice(params);
  150. }
  151. @Override
  152. public List<HashMap<String, Object>> getInvoicIds(HashMap<String, Object> params) {
  153. return baseMapper.getInvoicIds(params);
  154. }
  155. @Override
  156. public SettlementDocumentaryFeesEntity getByParentSettlementAmount(HashMap<String, Object> params) {
  157. return baseMapper.getByParentSettlementAmount(params);
  158. }
  159. /**
  160. * 作废开票 settlementStatus 为3表示为作废开票
  161. *
  162. * @param settlementDocumentaryFeesVo
  163. */
  164. @Override
  165. @Transactional
  166. public HttpResult<Object> voidInvoicing(SettlementDocumentaryFeesVo settlementDocumentaryFeesVo) {
  167. SettlementDocumentaryFeesEntity oldSettlementDocumentaryFeesEntity = baseMapper.selectById(settlementDocumentaryFeesVo.getId());
  168. List<SettlementDocumentaryFeesEntity> list = lambdaQuery().eq(SettlementDocumentaryFeesEntity::getParentId, settlementDocumentaryFeesVo.getId())
  169. .eq(SettlementDocumentaryFeesEntity::getSettlementStatus, "2")
  170. .list();
  171. if (!list.isEmpty()) {
  172. throw new SystemException("已经结算该数据不能作废");
  173. }
  174. String taskId = oldSettlementDocumentaryFeesEntity.getTaskId();
  175. HashMap<String, Object> params = new HashMap<>();
  176. params.put("taskId", taskId);
  177. List<InsPlyIncome> insPlyIncomes = insPlyIncomeMapper.queryNew(params);
  178. for (InsPlyIncome item : insPlyIncomes) {
  179. LambdaUpdateWrapper<InsPlyIncome> wrapper = new LambdaUpdateWrapper<>();
  180. wrapper.eq(InsPlyIncome::getId, item.getId());
  181. wrapper.set(InsPlyIncome::getHandlingFeesStatus, "0");
  182. wrapper.set(InsPlyIncome::getTaskId, null);
  183. wrapper.set(InsPlyIncome::getSettlementUserId, null);
  184. wrapper.set(InsPlyIncome::getSettlementTime, null);
  185. insPlyIncomeMapper.update(item, wrapper);
  186. incomeTaskRelationshipService.deleteByIncomeId(item.getId()); //作废后删除关系任务表
  187. }
  188. SettlementDocumentaryFeesEntity settlementDocumentaryFeesEntity = new SettlementDocumentaryFeesEntity();
  189. BeanUtils.copyProperties(settlementDocumentaryFeesVo, settlementDocumentaryFeesEntity);
  190. settlementDocumentaryFeesEntity.setSettlementStatus("3"); // 3 为作废
  191. baseMapper.updateById(settlementDocumentaryFeesEntity);
  192. return HttpResult.ok();
  193. }
  194. @Override
  195. public List<SettlementDocumentaryFeesEntity> queryNew(HashMap<String, Object> params) {
  196. return baseMapper.queryNew(params);
  197. }
  198. @Override
  199. public List<SettlementDocumentaryFeesEntity> querySettleNew(HashMap<String, Object> params) {
  200. return baseMapper.querySettleNew(params);
  201. }
  202. @Override
  203. public HttpResult<List<SettlementDocumentaryFeesEntity>> getRecord(String id) {
  204. List<SettlementDocumentaryFeesEntity> resultList= baseMapper.getRecord(id);
  205. return HttpResult.ok(resultList);
  206. }
  207. @Override
  208. public HttpResult<List<SettlementDocumentaryFeesEntity>> queryRecord(SettlementDocumentaryFeesVo settlementDocumentaryFeesVo) {
  209. List<SettlementDocumentaryFeesEntity> settlementDocumentaryFeesEntities = baseMapper.queryRecord(settlementDocumentaryFeesVo);
  210. return HttpResult.ok(settlementDocumentaryFeesEntities);
  211. }
  212. /**
  213. *
  214. * @param params settlementStatus 2 已结算
  215. * @return 按照月分组 已收款金额
  216. */
  217. @Override
  218. public List<HashMap<String, Object>> bxSumGroupByMonth(HashMap<String, Object> params) {
  219. return baseMapper.bxSumGroupByMonth(params);
  220. }
  221. private int compareAmount(BigDecimal settlementAmount, BigDecimal settlementAmount1) {
  222. return settlementAmount.compareTo(settlementAmount1);
  223. }
  224. }