SysUserAccountServiceImpl.java 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576
  1. package com.ydtech.modules.admin.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  5. import com.ydtech.core.page.HttpResult;
  6. import com.ydtech.modules.admin.constants.MoneyAttrConstants;
  7. import com.ydtech.modules.admin.constants.WithdrawTypeConstants;
  8. import com.ydtech.modules.admin.dao.SysUserAccountMapper;
  9. import com.ydtech.modules.admin.model.po.SysAmountAuditingEntity;
  10. import com.ydtech.modules.admin.model.po.SysUserAccount;
  11. import com.ydtech.modules.admin.model.po.SysUserAccountHistory;
  12. import com.ydtech.modules.admin.model.po.SysUserBankCard;
  13. import com.ydtech.modules.admin.model.vo.SysUserAccountVo;
  14. import com.ydtech.modules.admin.service.SysAmountAuditingService;
  15. import com.ydtech.modules.admin.service.SysUserAccountHistoryService;
  16. import com.ydtech.modules.admin.service.SysUserAccountService;
  17. import com.ydtech.modules.admin.service.SysUserBankCardService;
  18. import com.ydtech.modules.base.controller.BaseController;
  19. import com.ydtech.modules.esm.service.EsmUserReferrerService;
  20. import com.ydtech.modules.order.dao.InsOrdersMapper;
  21. import com.ydtech.modules.order.entity.BasePageResult;
  22. import com.ydtech.modules.order.entity.InsOrders;
  23. import com.ydtech.modules.order.entity.vo.OrderVo;
  24. import com.ydtech.modules.order.service.InsAreaCompanyService;
  25. import com.ydtech.modules.protocols.entity.po.InsFeeOrderNew;
  26. import com.ydtech.modules.protocols.service.InsFeeOrderNewService;
  27. import org.apache.commons.lang3.ObjectUtils;
  28. import org.apache.commons.lang3.StringUtils;
  29. import org.springframework.beans.BeanUtils;
  30. import org.springframework.beans.factory.annotation.Autowired;
  31. import org.springframework.stereotype.Service;
  32. import org.springframework.transaction.annotation.Transactional;
  33. import org.springframework.util.CollectionUtils;
  34. import java.math.BigDecimal;
  35. import java.util.ArrayList;
  36. import java.util.Date;
  37. import java.util.HashMap;
  38. import java.util.List;
  39. /**
  40. * @author Administrator
  41. * @description 针对表【sys_user_account(用户账户表)】的数据库操作Service实现
  42. * @createDate 2024-03-05 11:52:30
  43. */
  44. @Service
  45. public class SysUserAccountServiceImpl extends ServiceImpl<SysUserAccountMapper, SysUserAccount> implements SysUserAccountService {
  46. @Autowired
  47. private SysUserAccountHistoryService sysUserAccountHistoryService;
  48. @Autowired
  49. private SysUserAccountService sysUserAccountService;
  50. @Autowired
  51. private EsmUserReferrerService esmUserReferrerService;
  52. @Autowired
  53. private SysAmountAuditingService sysAmountAuditingService;
  54. @Autowired
  55. private SysUserBankCardService sysUserBankCardService;
  56. @Autowired
  57. private InsAreaCompanyService insAreaCompanyService;
  58. @Autowired
  59. private InsFeeOrderNewService insFeeOrderNewService;
  60. @Autowired
  61. private InsOrdersMapper insOrdersMapper;
  62. @Override
  63. @Transactional
  64. public void addOrUpdate(SysUserAccount sysUserAccount) {
  65. SysUserAccount newSysAccount = baseMapper.getById(sysUserAccount.getUserId());
  66. // 初始化
  67. if(sysUserAccount.getHandlingFee()==null){
  68. sysUserAccount.setHandlingFee(BigDecimal.ZERO);
  69. }
  70. if(sysUserAccount.getDocumentary()==null){
  71. sysUserAccount.setDocumentary(BigDecimal.ZERO);
  72. }
  73. if(sysUserAccount.getPromotion()==null){
  74. sysUserAccount.setPromotion(BigDecimal.ZERO);
  75. }
  76. // 如果用户id有值则累加 没有则 新增
  77. String userId = sysUserAccount.getUserId();
  78. SysUserAccount sysUserAccountEntity = super.getById(userId);
  79. SysUserAccount newAccount = new SysUserAccount();
  80. if (ObjectUtils.isNotEmpty(sysUserAccountEntity)) {
  81. sysUserAccountEntity.setHandlingFee(sysUserAccount.getHandlingFee().add(sysUserAccountEntity.getHandlingFee()));
  82. sysUserAccountEntity.setDocumentary(sysUserAccount.getDocumentary().add(sysUserAccountEntity.getDocumentary()));
  83. sysUserAccountEntity.setPromotion(sysUserAccount.getPromotion().add(sysUserAccountEntity.getPromotion()));
  84. if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
  85. sysUserAccountEntity.setDocumentaryStatus(sysUserAccount.getDocumentaryStatus());
  86. }
  87. baseMapper.updateById(sysUserAccountEntity);
  88. } else {
  89. sysUserAccountEntity = new SysUserAccount();
  90. sysUserAccountEntity.setUserId(userId);
  91. sysUserAccountEntity.setDocumentary(sysUserAccount.getDocumentary());
  92. sysUserAccountEntity.setPromotion(sysUserAccount.getPromotion());
  93. sysUserAccountEntity.setHandlingFee(sysUserAccount.getHandlingFee());
  94. if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
  95. sysUserAccountEntity.setDocumentaryStatus(sysUserAccount.getDocumentaryStatus());
  96. }
  97. baseMapper.insert(sysUserAccountEntity);
  98. }
  99. if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
  100. // 判断是否是一级二级三级
  101. SysUserAccountHistory sysUserAccountHistory = new SysUserAccountHistory();
  102. sysUserAccountHistory.setUserId(sysUserAccount.getUserId());
  103. sysUserAccountHistory.setDocumentary(Integer.valueOf(sysUserAccount.getDocumentaryStatus()));
  104. sysUserAccountHistory.setSuborder(sysUserAccount.getSuborderId());
  105. //跟单费
  106. if(sysUserAccount.getDocumentary()!=null && sysUserAccount.getDocumentary().compareTo(BigDecimal.ZERO)!=0){
  107. sysUserAccountHistory.setAmount(sysUserAccount.getDocumentary());
  108. sysUserAccountHistory.setProperty(MoneyAttrConstants.M_2.getCode());
  109. if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入 相加
  110. sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getDocumentary());
  111. }else {
  112. BigDecimal subtract = newSysAccount.getDocumentary().subtract(sysUserAccount.getDocumentary());
  113. sysUserAccountHistory.setSurplusAmount(subtract);
  114. }
  115. sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
  116. }
  117. //手续费
  118. if(sysUserAccount.getHandlingFee()!=null && sysUserAccount.getHandlingFee().compareTo(BigDecimal.ZERO) !=0){
  119. sysUserAccountHistory.setId(null);
  120. sysUserAccountHistory.setAmount(sysUserAccount.getHandlingFee());
  121. sysUserAccountHistory.setProperty(MoneyAttrConstants.M_1.getCode());
  122. if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入 相加
  123. sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getHandlingFee());
  124. }else {
  125. BigDecimal subtract = newSysAccount.getHandlingFee().subtract(sysUserAccount.getHandlingFee());
  126. sysUserAccountHistory.setSurplusAmount(subtract);
  127. }
  128. sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
  129. }
  130. //推广费
  131. if(sysUserAccount.getPromotion() !=null && sysUserAccount.getPromotion().compareTo(BigDecimal.ZERO) !=0){
  132. sysUserAccountHistory.setId(null);
  133. sysUserAccountHistory.setAmount(sysUserAccount.getPromotion());
  134. sysUserAccountHistory.setProperty(MoneyAttrConstants.M_3.getCode());
  135. if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入 相加
  136. sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getPromotion());
  137. }else {
  138. BigDecimal subtract = newSysAccount.getPromotion().subtract(sysUserAccount.getPromotion());
  139. sysUserAccountHistory.setSurplusAmount(subtract);
  140. }
  141. sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
  142. }
  143. }
  144. }
  145. @Override
  146. public BasePageResult<SysUserAccount> queryByVo(SysUserAccountVo sysUserAccountVo) {
  147. Page<SysUserAccount> page = new Page<>(sysUserAccountVo.getPageNum(), sysUserAccountVo.getPageSize());
  148. Page<SysUserAccount> sysUserAccountHistoryPage = baseMapper.queryPageOrder(sysUserAccountVo, page);
  149. return new BasePageResult<>(sysUserAccountVo.getPageNum(), page.getSize(), sysUserAccountHistoryPage.getTotal(), page.getPages(),
  150. sysUserAccountHistoryPage.getRecords());
  151. }
  152. @Override
  153. @Transactional
  154. public HttpResult<Object> inert(SysUserAccountVo sysUserAccountVo) {
  155. String userId = BaseController.getUser().getId();
  156. BigDecimal zero = BigDecimal.ZERO;
  157. BigDecimal beforeAmount;
  158. BigDecimal afterAmount;
  159. // 用户当前金额
  160. BigDecimal amount = sysUserAccountVo.getAmount();
  161. SysUserAccountHistory sysUserAccountHistory = new SysUserAccountHistory(); // 记录
  162. sysUserAccountHistory.setDocumentary(1); // 1提现
  163. sysUserAccountHistory.setUserId(userId);
  164. SysAmountAuditingEntity sysAmountAuditingEntity = new SysAmountAuditingEntity();//审核记录表
  165. sysAmountAuditingEntity.setUserId(userId);
  166. sysAmountAuditingEntity.setAmount(sysUserAccountVo.getAmount());
  167. SysAmountAuditingEntity judge = sysAmountAuditingService.getByUserId(userId,sysUserAccountVo.getAmountStatus());
  168. if(ObjectUtils.isNotEmpty(judge)){
  169. return HttpResult.ok("有未提现审核单据, 请审核完成之后再提现");
  170. }
  171. // 通过银行卡id 查询卡包
  172. Long fromBankCardId = sysUserAccountVo.getFromBankCardId();
  173. if(fromBankCardId!=null){
  174. SysUserBankCard byId = sysUserBankCardService.getById(fromBankCardId);
  175. String bankUserId = byId.getUserId();
  176. if(!userId.equals(bankUserId)){
  177. return HttpResult.ok("非本人提现");
  178. }
  179. byId.setIsDefault(1);
  180. sysAmountAuditingEntity.setBankNumber( byId.getBankNumber());
  181. sysUserAccountHistory.setFromBankCard( byId.getBankNumber());
  182. sysUserBankCardService.updateById(byId);
  183. }
  184. if (StringUtils.isNotEmpty(userId)) {
  185. SysUserAccount sysUserAccount = baseMapper.getById(userId);
  186. if (StringUtils.isNotEmpty(sysUserAccountVo.getAmountStatus())) {
  187. sysUserAccountHistory.setProperty(Integer.valueOf(sysUserAccountVo.getAmountStatus())); //金额类型
  188. if ("1".equals(sysUserAccountVo.getAmountStatus())) {
  189. // 用户当前费用金
  190. beforeAmount = sysUserAccount.getHandlingFee();
  191. afterAmount = beforeAmount.subtract(amount);
  192. sysUserAccount.setHandlingFee(afterAmount);
  193. sysUserAccount.setHandlingAmountPayment(amount);
  194. sysUserAccount.setHandlingAmountWithdrawal(sysUserAccount.getHandlingAmountWithdrawal().add(amount));
  195. } else if ("2".equals(sysUserAccountVo.getAmountStatus())) {
  196. // 用户当前 非跟单佣金
  197. beforeAmount = sysUserAccount.getDocumentary();
  198. afterAmount = beforeAmount.subtract(amount);
  199. sysUserAccount.setDocumentary(afterAmount);
  200. sysUserAccount.setDocumentaryAmountpayment(amount);
  201. sysUserAccount.setDocumentaryAmountWithdrawal(sysUserAccount.getDocumentaryAmountWithdrawal().add(amount));
  202. } else {
  203. beforeAmount = sysUserAccount.getPromotion();
  204. afterAmount = beforeAmount.subtract(amount);
  205. sysUserAccount.setPromotion(afterAmount);
  206. sysUserAccount.setPromotionAmountPayment(amount);
  207. sysUserAccount.setPromotionAmountWithdrawal(sysUserAccount.getPromotionAmountWithdrawal().add(amount));
  208. }
  209. // 用户相差
  210. if (beforeAmount.compareTo(zero) == 0 || afterAmount.compareTo(zero) < 0) {
  211. return HttpResult.ok("余额不足");
  212. }
  213. sysUserAccountHistory.setAmount(amount); // 金额
  214. sysUserAccountHistory.setSurplusAmount(afterAmount); // 剩余金额
  215. sysUserAccountHistory.setUserAmount(beforeAmount); // 用户剩余金额
  216. sysAmountAuditingEntity.setCreateTime(new Date());
  217. sysAmountAuditingEntity.setAuditingStatus("2"); // 2 为待审核 3 审核通过
  218. sysAmountAuditingEntity.setAmountStatus(sysUserAccountVo.getAmountStatus());
  219. // 新增金额记录
  220. sysAmountAuditingService.save(sysAmountAuditingEntity);
  221. sysUserAccountHistory.setAuditiingId(sysAmountAuditingEntity.getId());
  222. sysUserAccountService.updateById(sysUserAccount);
  223. sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
  224. }
  225. }
  226. return HttpResult.ok("提现成功,等待审核");
  227. }
  228. @Override
  229. public SysUserAccount getSysUserAmount(String userid) {
  230. SysUserAccount sysUserAccount = baseMapper.getById(userid);
  231. return sysUserAccount;
  232. }
  233. @Override
  234. public SysUserAccountVo getSysAllAmount(String userId) {
  235. SysUserAccountVo sysUserAccountVo = new SysUserAccountVo();
  236. SysUserAccount sysUserAccount = baseMapper.getById(userId);
  237. BeanUtils.copyProperties(sysUserAccount, sysUserAccountVo);
  238. BigDecimal willHalding=BigDecimal.ZERO; //预收手续费佣金
  239. BigDecimal willDocumentary =BigDecimal.ZERO; //预收 非跟单佣金
  240. BigDecimal willPromotion =BigDecimal.ZERO; //预收 推广
  241. StringBuffer stringBuffer = new StringBuffer();
  242. willPromotion = this.willPromotion(willPromotion,userId); // 佣金
  243. // add by hxl 修改sql 添加承保状态和不在审核表中的条件 begin ===============
  244. //List<InsFeeOrderNew> willList = insFeeOrderNewService.getByUserId(userId);
  245. List<InsFeeOrderNew> willList = insFeeOrderNewService.getByUserIdAndOrderStatusAndNoCheck(userId);
  246. // add by hxl end ==========================
  247. if(!CollectionUtils.isEmpty(willList)){
  248. for (InsFeeOrderNew item : willList){
  249. String quoteno = item.getInsOrderNo();
  250. stringBuffer.append(quoteno).append(",");
  251. if(ObjectUtils.isNotEmpty(item)){
  252. this.willAmount(item,willHalding,willDocumentary,sysUserAccountVo); // 推广 非跟单
  253. }
  254. }
  255. }
  256. // 提现现中
  257. HashMap<String, Object> params = new HashMap<>();
  258. params.put("auditingStatus","2"); // 待审核
  259. params.put("userId",userId);
  260. List<SysAmountAuditingEntity> sysAmountAuditingProgressIng= sysAmountAuditingService.getProgressIng(params);
  261. this.judge(sysAmountAuditingProgressIng,sysUserAccountVo);
  262. params.clear();
  263. params.put("auditingStatus","3"); // 已审核审核
  264. params.put("userId",userId);
  265. List<SysAmountAuditingEntity> sysAmountAuditingApproved= sysAmountAuditingService.getProgressIng(params);
  266. this.judgeSysAmountAuditing(sysAmountAuditingApproved,sysUserAccountVo);
  267. sysUserAccountVo.setWillPromotion(willPromotion);
  268. String ids = stringBuffer.toString();
  269. if (ids.endsWith(",")) {
  270. ids = ids.substring(0, ids.length() - 1); // 去掉末尾的逗号
  271. }
  272. sysUserAccountVo.setIds(ids);
  273. return sysUserAccountVo;
  274. }
  275. @Override
  276. public SysUserAccountVo getInsOrders(SysUserAccountVo sysUserAccountVo) {
  277. ArrayList<InsFeeOrderNew> resultList = new ArrayList<>();
  278. BigDecimal willPromotion = BigDecimal.ZERO;
  279. if(StringUtils.isNotEmpty(sysUserAccountVo.getIds())){
  280. for (String insOrderNo : sysUserAccountVo.getIds().split(",")) {
  281. //add by hxl begin 修改查询时间
  282. //InsAreaCompany byInsOrderNo = insAreaCompanyService.getByInsOrderNoNew(insOrderNo,sysUserAccountVo.getTimeFiltering());
  283. OrderVo byInsOrderNo = insAreaCompanyService.selectEntityByinsOrderNo(insOrderNo, sysUserAccountVo.getTimeFiltering());
  284. if(ObjectUtils.isNotEmpty(byInsOrderNo)){
  285. String id = byInsOrderNo.getId();
  286. InsFeeOrderNew insFeeOrderNew = insFeeOrderNewService.getInsFeeOrderEntity(id);
  287. insFeeOrderNew.setAmountType(sysUserAccountVo.getAmountType());
  288. //add by hxl 添加车牌号
  289. insFeeOrderNew.setLicenseno(byInsOrderNo.getLicenseno());
  290. //预收推广
  291. willPromotion =this.getWillPromotion(insFeeOrderNew,willPromotion);
  292. this.getWillAmount(insFeeOrderNew); // 推广 非跟单
  293. if(StringUtils.isNotEmpty(sysUserAccountVo.getAmountType()) && "3".equals(sysUserAccountVo.getAmountType()) ){
  294. insFeeOrderNew.setWillAmount(willPromotion);
  295. }
  296. resultList.add(insFeeOrderNew);
  297. }
  298. }
  299. }
  300. sysUserAccountVo.setInsFeeOrderNewList(resultList);
  301. return sysUserAccountVo;
  302. }
  303. private void getWillAmount(InsFeeOrderNew insFeeOrderNew) {
  304. if(ObjectUtils.isNotEmpty(insFeeOrderNew)){
  305. //交强手续费出口比例
  306. BigDecimal jqExportProceduresFee = insFeeOrderNew.getJqPremium().multiply(insFeeOrderNew.getJqSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  307. //商业手续费出口比例
  308. BigDecimal syExportProceduresFee = insFeeOrderNew.getSyPremium().multiply(insFeeOrderNew.getSySuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  309. //非车手续费出口比例
  310. BigDecimal noExportProceduresFee = insFeeOrderNew.getNoPremium().multiply(insFeeOrderNew.getNoSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  311. //非车出口比例
  312. //总机构 交强管理比例
  313. BigDecimal sumJqDeptProportion = insFeeOrderNew.getJqDeptProportionLevel1()
  314. .add(insFeeOrderNew.getJqDeptProportionLevel2())
  315. .add(insFeeOrderNew.getJqDeptProportionLevel3())
  316. .add(insFeeOrderNew.getJqDeptProportionLevel4())
  317. .add(insFeeOrderNew.getJqDeptProportionLevel5());
  318. //总机构 商业管理比例
  319. BigDecimal sumSyDeptProportion = insFeeOrderNew.getSyDeptProportionLevel1()
  320. .add(insFeeOrderNew.getSyDeptProportionLevel2())
  321. .add(insFeeOrderNew.getSyDeptProportionLevel3())
  322. .add(insFeeOrderNew.getSyDeptProportionLevel4())
  323. .add(insFeeOrderNew.getSyDeptProportionLevel5());
  324. //总机构 非车管理比例
  325. BigDecimal sumNoDeptProportion = insFeeOrderNew.getNoDeptProportionLevel1()
  326. .add(insFeeOrderNew.getNoDeptProportionLevel2())
  327. .add(insFeeOrderNew.getNoDeptProportionLevel3())
  328. .add(insFeeOrderNew.getNoDeptProportionLevel4())
  329. .add(insFeeOrderNew.getNoDeptProportionLevel5());
  330. BigDecimal noExportProceduresProportion = new BigDecimal(0);
  331. //总分销比例
  332. BigDecimal sumRetail = insFeeOrderNew.getFirstDetailProportion().add(insFeeOrderNew.getSecondDetailProportion()).add(insFeeOrderNew.getThirdDetailProportion());
  333. if(insFeeOrderNew.getNoCostsProportion().compareTo(sumNoDeptProportion.add(sumRetail))>0){
  334. noExportProceduresProportion = insFeeOrderNew.getNoCostsProportion().subtract(sumNoDeptProportion).subtract(sumRetail);
  335. }
  336. //商业出口比例
  337. BigDecimal syExportProceduresProportion = new BigDecimal(0);
  338. if(insFeeOrderNew.getSyCostsProportion().compareTo(sumSyDeptProportion.add(sumRetail))>0){
  339. syExportProceduresProportion = insFeeOrderNew.getSyCostsProportion().subtract(sumSyDeptProportion).subtract(sumRetail);
  340. }
  341. //交强出口比例
  342. BigDecimal jqExportProceduresProportion = new BigDecimal(0);
  343. if(insFeeOrderNew.getJqCostsProportion().compareTo(sumJqDeptProportion.add(sumRetail))>0){
  344. jqExportProceduresProportion = insFeeOrderNew.getJqCostsProportion().subtract(sumJqDeptProportion).subtract(sumRetail);
  345. }
  346. //交强跟单出口费用
  347. BigDecimal jqExportOtherFee = insFeeOrderNew.getJqPremium()
  348. .multiply(jqExportProceduresProportion
  349. .subtract(insFeeOrderNew.getJqSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  350. //商业跟单出口比例
  351. BigDecimal syExportOtherFee = insFeeOrderNew.getSyPremium()
  352. .multiply(syExportProceduresProportion
  353. .subtract(insFeeOrderNew.getSySuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  354. //非车跟单出口比例
  355. BigDecimal noExportOtherFee = insFeeOrderNew.getNoPremium()
  356. .multiply(noExportProceduresProportion
  357. .subtract(insFeeOrderNew.getNoSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  358. if(StringUtils.isNotEmpty(insFeeOrderNew.getAmountType())){
  359. if("1".equals(insFeeOrderNew.getAmountType())){
  360. //用户出口手续费
  361. insFeeOrderNew.setWillAmount(jqExportProceduresFee.add(syExportProceduresFee).add(noExportProceduresFee));
  362. }
  363. if("2".equals(insFeeOrderNew.getAmountType())){
  364. //用户出口跟单费
  365. insFeeOrderNew.setWillAmount(jqExportOtherFee.add(syExportOtherFee).add(noExportOtherFee));
  366. }
  367. }
  368. }
  369. }
  370. private BigDecimal getWillPromotion(InsFeeOrderNew insFeeOrderNew,BigDecimal willPromotion) {
  371. for (int i = 1; i <4 ; i++) {
  372. InsOrders InsOrders = insAreaCompanyService.selectByInFeeOrderNew(insFeeOrderNew,i);
  373. if(ObjectUtils.isNotEmpty(InsOrders)){
  374. BigDecimal willFirstPremiums = InsOrders.getWillFirstPremiums();
  375. BigDecimal willSecondPremiums = InsOrders.getWillSecondPremiums();
  376. BigDecimal willThreePremiums = InsOrders.getWillThreePremiums();
  377. if(ObjectUtils.isNotEmpty(InsOrders)){
  378. if(willFirstPremiums==null){
  379. willFirstPremiums=BigDecimal.ZERO;
  380. }
  381. if(willSecondPremiums==null){
  382. willSecondPremiums=BigDecimal.ZERO;
  383. }
  384. if(willThreePremiums==null){
  385. willThreePremiums=BigDecimal.ZERO;
  386. }
  387. return willPromotion.add(willFirstPremiums).add(willThreePremiums).add(willSecondPremiums);
  388. }
  389. }
  390. }
  391. return null;
  392. }
  393. private void judgeSysAmountAuditing(List<SysAmountAuditingEntity> sysAmountAuditingApproved, SysUserAccountVo sysUserAccountVo) {
  394. if(!CollectionUtils.isEmpty(sysAmountAuditingApproved)){
  395. for (SysAmountAuditingEntity item: sysAmountAuditingApproved){
  396. if("1".equals(item.getAmountStatus())){ //手续费
  397. BigDecimal amount = item.getAmount();
  398. sysUserAccountVo.setApprovedHalding(amount);
  399. }
  400. if("2".equals(item.getAmountStatus())){ //非跟单
  401. BigDecimal amount = item.getAmount();
  402. sysUserAccountVo.setApprovedDocumentary(amount);
  403. }
  404. if("3".equals(item.getAmountStatus())){ //推广费
  405. BigDecimal amount = item.getAmount();
  406. sysUserAccountVo.setApprovedPromotion(amount);
  407. }
  408. }
  409. }
  410. }
  411. private void judge(List<SysAmountAuditingEntity> sysAmountAuditingProgressIng,SysUserAccountVo sysUserAccountVo) {
  412. if(!CollectionUtils.isEmpty(sysAmountAuditingProgressIng)){
  413. for (SysAmountAuditingEntity item: sysAmountAuditingProgressIng){
  414. if("1".equals(item.getAmountStatus())){ //手续费
  415. BigDecimal amount = item.getAmount();
  416. sysUserAccountVo.setWithdrawalHalding(amount);
  417. }
  418. if("2".equals(item.getAmountStatus())){ //非跟单
  419. BigDecimal amount = item.getAmount();
  420. sysUserAccountVo.setWithdrawalDocumentary(amount);
  421. }
  422. if("3".equals(item.getAmountStatus())){ //推广费
  423. BigDecimal amount = item.getAmount();
  424. sysUserAccountVo.setWithdrawalPromotion(amount);
  425. }
  426. }
  427. }
  428. }
  429. private BigDecimal willPromotion(BigDecimal willPromotion, String userId) {
  430. for (int i = 1; i <4 ; i++) {
  431. InsOrders InsOrders = insAreaCompanyService.selectPromotionBy(userId,i);
  432. if(ObjectUtils.isNotEmpty(InsOrders)){
  433. BigDecimal willFirstPremiums = InsOrders.getWillFirstPremiums();
  434. BigDecimal willSecondPremiums = InsOrders.getWillSecondPremiums();
  435. BigDecimal willThreePremiums = InsOrders.getWillThreePremiums();
  436. if(ObjectUtils.isNotEmpty(InsOrders)){
  437. if(willFirstPremiums==null){
  438. willFirstPremiums=BigDecimal.ZERO;
  439. }
  440. if(willSecondPremiums==null){
  441. willSecondPremiums=BigDecimal.ZERO;
  442. }
  443. if(willThreePremiums==null){
  444. willThreePremiums=BigDecimal.ZERO;
  445. }
  446. return willPromotion.add(willFirstPremiums).add(willThreePremiums).add(willSecondPremiums);
  447. }
  448. }
  449. }
  450. return null;
  451. }
  452. private void willAmount(InsFeeOrderNew insFeeOrderNew, BigDecimal willHalding, BigDecimal willDocumentary,SysUserAccountVo sysUserAccountVo) {
  453. if(ObjectUtils.isNotEmpty(insFeeOrderNew)){
  454. //交强手续费出口比例
  455. BigDecimal jqExportProceduresFee = insFeeOrderNew.getJqPremium().multiply(insFeeOrderNew.getJqSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  456. //商业手续费出口比例
  457. BigDecimal syExportProceduresFee = insFeeOrderNew.getSyPremium().multiply(insFeeOrderNew.getSySuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  458. //非车手续费出口比例
  459. BigDecimal noExportProceduresFee = insFeeOrderNew.getNoPremium().multiply(insFeeOrderNew.getNoSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  460. //用户出口手续费
  461. if(sysUserAccountVo.getWillHalding()==null){
  462. sysUserAccountVo.setWillHalding(BigDecimal.ZERO);
  463. }
  464. sysUserAccountVo.setWillHalding(sysUserAccountVo.getWillHalding().add(jqExportProceduresFee).add(syExportProceduresFee).add(noExportProceduresFee));
  465. //非车出口比例
  466. //总机构 交强管理比例
  467. BigDecimal sumJqDeptProportion = insFeeOrderNew.getJqDeptProportionLevel1()
  468. .add(insFeeOrderNew.getJqDeptProportionLevel2())
  469. .add(insFeeOrderNew.getJqDeptProportionLevel3())
  470. .add(insFeeOrderNew.getJqDeptProportionLevel4())
  471. .add(insFeeOrderNew.getJqDeptProportionLevel5());
  472. //总机构 商业管理比例
  473. BigDecimal sumSyDeptProportion = insFeeOrderNew.getSyDeptProportionLevel1()
  474. .add(insFeeOrderNew.getSyDeptProportionLevel2())
  475. .add(insFeeOrderNew.getSyDeptProportionLevel3())
  476. .add(insFeeOrderNew.getSyDeptProportionLevel4())
  477. .add(insFeeOrderNew.getSyDeptProportionLevel5());
  478. //总机构 非车管理比例
  479. BigDecimal sumNoDeptProportion = insFeeOrderNew.getNoDeptProportionLevel1()
  480. .add(insFeeOrderNew.getNoDeptProportionLevel2())
  481. .add(insFeeOrderNew.getNoDeptProportionLevel3())
  482. .add(insFeeOrderNew.getNoDeptProportionLevel4())
  483. .add(insFeeOrderNew.getNoDeptProportionLevel5());
  484. BigDecimal noExportProceduresProportion = new BigDecimal(0);
  485. //总分销比例
  486. BigDecimal sumRetail = insFeeOrderNew.getFirstDetailProportion().add(insFeeOrderNew.getSecondDetailProportion()).add(insFeeOrderNew.getThirdDetailProportion());
  487. if(insFeeOrderNew.getNoCostsProportion().compareTo(sumNoDeptProportion.add(sumRetail))>0){
  488. noExportProceduresProportion = insFeeOrderNew.getNoCostsProportion().subtract(sumNoDeptProportion).subtract(sumRetail);
  489. }
  490. //商业出口比例
  491. BigDecimal syExportProceduresProportion = new BigDecimal(0);
  492. if(insFeeOrderNew.getSyCostsProportion().compareTo(sumSyDeptProportion.add(sumRetail))>0){
  493. syExportProceduresProportion = insFeeOrderNew.getSyCostsProportion().subtract(sumSyDeptProportion).subtract(sumRetail);
  494. }
  495. //交强出口比例
  496. BigDecimal jqExportProceduresProportion = new BigDecimal(0);
  497. if(insFeeOrderNew.getJqCostsProportion().compareTo(sumJqDeptProportion.add(sumRetail))>0){
  498. jqExportProceduresProportion = insFeeOrderNew.getJqCostsProportion().subtract(sumJqDeptProportion).subtract(sumRetail);
  499. }
  500. //交强跟单出口费用
  501. BigDecimal jqExportOtherFee = insFeeOrderNew.getJqPremium()
  502. .multiply(jqExportProceduresProportion
  503. .subtract(insFeeOrderNew.getJqSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  504. //商业跟单出口比例
  505. BigDecimal syExportOtherFee = insFeeOrderNew.getSyPremium()
  506. .multiply(syExportProceduresProportion
  507. .subtract(insFeeOrderNew.getSySuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  508. //非车跟单出口比例
  509. BigDecimal noExportOtherFee = insFeeOrderNew.getNoPremium()
  510. .multiply(noExportProceduresProportion
  511. .subtract(insFeeOrderNew.getNoSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
  512. //用户出口跟单费
  513. if(sysUserAccountVo.getWillDocumentary()==null){
  514. sysUserAccountVo.setWillDocumentary(BigDecimal.ZERO);
  515. }
  516. sysUserAccountVo.setWillDocumentary(sysUserAccountVo.getWillDocumentary().add(jqExportOtherFee).add(syExportOtherFee).add(noExportOtherFee));
  517. }
  518. }
  519. }