OrderServiceImpl.java 56 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156
  1. package com.kmall.admin.service.impl;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.google.common.collect.ImmutableBiMap;
  4. import com.google.common.collect.Maps;
  5. import com.kmall.admin.dao.*;
  6. import com.kmall.admin.dao.mk.store.MkStorePromOrderRealDao;
  7. import com.kmall.admin.dto.OrderExpressDto;
  8. import com.kmall.admin.entity.*;
  9. import com.kmall.admin.entity.OrderProcessRecordEntity;
  10. import com.kmall.admin.entity.mk.store.MkStorePromOrderRealEntity;
  11. import com.kmall.api.entity.mk.MkStorePromOrderRealVo;
  12. import com.kmall.manager.manager.express.sf.properties.SFPropertiesBuilder;
  13. import com.kmall.manager.manager.express.sf.properties.SFUtil;
  14. import com.kmall.manager.manager.express.sf.entity.SfRouteServiceResponseEntity;
  15. import com.kmall.manager.manager.express.sf.entity.RouteEntity;
  16. import com.kmall.manager.manager.express.sf.entity.RouteResponseEntity;
  17. import com.kmall.manager.manager.print.ticket.TicketPrintUtil;
  18. import com.kmall.manager.manager.wechat.wxglobal.dto.WechatGlobalRefundApiResult;
  19. import com.kmall.admin.service.OrderService;
  20. import com.kmall.admin.utils.ShiroUtils;
  21. import com.kmall.common.constant.Dict;
  22. import com.kmall.manager.manager.merch.OmsMerchPropertiesBuilder;
  23. import com.kmall.api.util.CommonUtil;
  24. import com.kmall.admin.fromcomm.entity.SysUserEntity;
  25. import com.kmall.manager.manager.print.ticket.PrintTicketPropertiesBuilder;
  26. import com.kmall.common.utils.*;
  27. import com.kmall.common.utils.print.ticket.item.*;
  28. import com.kmall.manager.manager.express.kdn.KdniaoUtil;
  29. import com.kmall.common.utils.wechat.WechatRefundApiResult;
  30. import org.springframework.beans.factory.annotation.Autowired;
  31. import org.springframework.stereotype.Service;
  32. import org.springframework.transaction.annotation.Transactional;
  33. import java.math.BigDecimal;
  34. import java.text.SimpleDateFormat;
  35. import java.util.*;
  36. @Service("orderService")
  37. public class OrderServiceImpl implements OrderService {
  38. @Autowired
  39. private OrderDao orderDao;
  40. @Autowired
  41. private ShippingDao shippingDao;
  42. @Autowired
  43. private OrderGoodsDao orderGoodsDao;
  44. @Autowired
  45. private SysPrinterDao printerDao;
  46. @Autowired
  47. private UserDao userDao;
  48. @Autowired
  49. private UserCouponDao userCouponDao;
  50. @Autowired
  51. private ProductStoreRelaDao productStoreRelaDao;
  52. @Autowired
  53. private OrderProcessRecordDao orderProcessRecordDao;
  54. @Autowired
  55. private OrderRefundDao orderRefundDao;
  56. @Autowired
  57. private StoreDao storeDao;
  58. @Autowired
  59. private OfflineCartDao offlineCartDao;
  60. @Autowired
  61. private GoodsDao goodsDao;
  62. @Autowired
  63. private MerchDao merchDao;
  64. @Autowired
  65. private MngChangeDao mngChangeDao;
  66. @Autowired
  67. private StoreMngChangeDao storeMngChangeDao;
  68. @Autowired
  69. private ThirdMerchExpressDao thirdMerchExpressDao;
  70. @Autowired
  71. private MkStorePromOrderRealDao mkStorePromOrderRealDao;
  72. @Override
  73. public OrderEntity queryObject(Long id) {
  74. return orderDao.queryObject(id);
  75. }
  76. @Override
  77. public Double getTotalActualPrice(String merchOrderSn) {
  78. return orderDao.getTotalActualPrice(merchOrderSn);
  79. }
  80. @Override
  81. public List<OrderEntity> queryList(Map<String, Object> map) {
  82. return orderDao.queryList(map);
  83. }
  84. @Override
  85. public int queryTotal(Map<String, Object> map) {
  86. return orderDao.queryTotal(map);
  87. }
  88. @Override
  89. public int save(OrderEntity order) {
  90. return orderDao.save(order);
  91. }
  92. @Override
  93. public int update(OrderEntity order) {
  94. return orderDao.update(order);
  95. }
  96. /**
  97. * 取消订单
  98. *
  99. * @param order
  100. */
  101. @Override
  102. public void cancelOrder(OrderEntity order) {
  103. boolean needUpdateStock = true;
  104. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  105. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_101.getItem()));
  106. }
  107. // 判断是否有优惠券
  108. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  109. if (null != couponVo) {
  110. userCouponDao.cancelOrder(couponVo);
  111. }
  112. orderDao.update(order);
  113. if (!needUpdateStock) {
  114. return;
  115. }
  116. // 更新库存
  117. updateStock(order, "管理后台取消订单");
  118. }
  119. @Override
  120. public int delete(Long id) {
  121. return orderDao.delete(id);
  122. }
  123. @Override
  124. public int deleteBatch(Long[] ids) {
  125. return orderDao.deleteBatch(ids);
  126. }
  127. @Override
  128. public int confirm(Long id) {
  129. OrderEntity orderEntity = queryObject(id);
  130. Integer shippingStatus = orderEntity.getShippingStatus();//发货状态
  131. Integer payStatus = orderEntity.getPayStatus();//付款状态
  132. if (2 != payStatus) {
  133. throw new RRException("此订单未付款,不能确认收货!");
  134. }
  135. if (4 == shippingStatus) {
  136. throw new RRException("此订单处于退货状态,不能确认收货!");
  137. }
  138. if (0 == shippingStatus) {
  139. throw new RRException("此订单未发货,不能确认收货!");
  140. }
  141. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  142. throw new RRException("此订单已完成!");
  143. }
  144. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  145. throw new RRException("此订单待付款!");
  146. }
  147. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_100.getItem())) {
  148. throw new RRException("此订单付款中!");
  149. }
  150. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  151. throw new RRException("此订单已取消!");
  152. }
  153. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  154. throw new RRException("此订单已删除!");
  155. }
  156. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  157. throw new RRException("此订单还未发货!");
  158. }
  159. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem())) {
  160. throw new RRException("此订单已退款!");
  161. }
  162. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  163. throw new RRException("此订单已退款!");
  164. }
  165. orderEntity.setShippingStatus(2);
  166. orderEntity.setOrderStatus(301);
  167. orderEntity.setConfirmTime(new Date());
  168. orderDao.update(orderEntity);
  169. return 0;
  170. }
  171. @Override
  172. public int sendGoods(OrderEntity order) {
  173. Integer payStatus = order.getPayStatus();//付款状态
  174. if (2 != payStatus) {
  175. throw new RRException("此订单未付款!");
  176. }
  177. ShippingEntity shippingEntity = shippingDao.queryObject(order.getShippingId());
  178. if (null != shippingEntity) {
  179. order.setShippingName(shippingEntity.getName());
  180. }
  181. order.setOrderStatus(300);//订单已发货
  182. order.setShippingStatus(1);//已发货
  183. return orderDao.update(order);
  184. }
  185. @Override
  186. public Ticket printMsg(Long id) {
  187. OrderEntity orderEntity = queryInfos(id);
  188. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  189. // 获取门店
  190. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  191. // 获取清关信息
  192. OrderProcessRecordEntity orderProcessRecordEntity =
  193. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  194. // 小票头
  195. TicketHead head = new TicketHead();
  196. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  197. // head.setMemberId(orderEntity.getUserName().toString());
  198. head.setOrderId(orderEntity.getOrderSn());
  199. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  200. // 商品信息
  201. Integer goodsTotal = 0; // 商品总个数
  202. BigDecimal total = Constant.ZERO; // 商品总计
  203. List<Goods> goodsList = new ArrayList<>();
  204. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  205. goodsTotal += orderGoods.getNumber();
  206. total = total.add(orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  207. .setScale(2, BigDecimal.ROUND_HALF_UP);
  208. Goods goods = new Goods(orderGoods.getGoodsName(), orderGoods.getRetailPrice().toString(),
  209. orderGoods.getNumber().toString(),
  210. orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber()))
  211. .setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  212. goodsList.add(goods);
  213. }
  214. // 收银信息
  215. CashInfo cashInfo = new CashInfo();
  216. cashInfo.setGoodsTotal(goodsTotal.toString());
  217. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  218. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  219. cashInfo.setOddChange("0.00");
  220. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  221. cashInfo.setFreight(
  222. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  223. cashInfo.setPaymentMode("微信支付");
  224. // 海关清单
  225. CusListing cusListing = new CusListing();
  226. cusListing.setOrderId(orderEntity.getOrderSn());
  227. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  228. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  229. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  230. cusListing.setConsignee(orderEntity.getConsignee());
  231. cusListing.setConsigneeTel(orderEntity.getMobile());
  232. }
  233. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  234. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  235. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  236. }
  237. /**
  238. * 退款
  239. */
  240. @Transactional
  241. public void refund(OrderEntity order, WechatRefundApiResult result) {
  242. boolean needUpdateStock = true;
  243. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  244. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  245. }
  246. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  247. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  248. }else{
  249. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  250. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  251. OrderRefundEntity orderRefund = new OrderRefundEntity();
  252. orderRefund.setRefundId(result.getRefund_id());
  253. orderRefund.setOutRefundNo(result.getOut_refund_no());
  254. orderRefund
  255. .setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  256. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  257. orderRefund.setModTime(new Date());
  258. if (mallOrderRefund != null) {
  259. orderRefund.setId(mallOrderRefund.getId());
  260. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  261. orderRefundDao.update(orderRefund);
  262. } else {
  263. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  264. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  265. orderRefund.setCreateTime(new Date());
  266. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  267. if(list.size()>1){//多条订单
  268. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  269. }else{
  270. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  271. }
  272. orderRefundDao.save(orderRefund);//退款记录
  273. }
  274. }
  275. orderDao.update(order);//修改为退款中
  276. // 判断是否有优惠券
  277. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  278. if (null != couponVo) {
  279. userCouponDao.cancelOrder(couponVo);
  280. }
  281. if (!needUpdateStock) {
  282. return;
  283. }
  284. // 更新库存
  285. updateStock(order, "管理后台订单退款");
  286. queryStorePromRealUpdateIsScan(order);
  287. }
  288. /**
  289. * 平安退款逻辑处理
  290. * @param order
  291. * @param result
  292. */
  293. @Transactional
  294. public void pinganRefund(OrderEntity order, net.sf.json.JSONObject result, String refundId) {
  295. boolean needUpdateStock = true;
  296. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  297. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  298. }
  299. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  300. OrderRefundEntity orderRefund = new OrderRefundEntity();
  301. orderRefund.setRefundId(refundId);
  302. orderRefund.setOutRefundNo(result.getString("ord_no"));
  303. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  304. orderRefund.setModTime(new Date());
  305. orderRefund.setRefundMoney(BigDecimal.valueOf(result.getInt("trade_amount")).divide(Constant.ONE_HUNDRED));
  306. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  307. if (mallOrderRefund != null) {
  308. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  309. orderRefund.setId(mallOrderRefund.getId());
  310. orderRefundDao.update(orderRefund);
  311. } else {//退款记录不存在
  312. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  313. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  314. orderRefund.setCreateTime(new Date());
  315. orderRefundDao.save(orderRefund);//退款记录
  316. }
  317. orderDao.update(order);//修改为退款中
  318. // 判断是否有优惠券
  319. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  320. if (null != couponVo) {
  321. userCouponDao.cancelOrder(couponVo);
  322. }
  323. if (!needUpdateStock) {
  324. return;
  325. }
  326. // 更新库存
  327. updateStock(order, "管理后台平安退款订单");
  328. queryStorePromRealUpdateIsScan(order);
  329. }
  330. /**
  331. * 微信国际退款逻辑处理
  332. * @param order
  333. * @param result
  334. */
  335. @Transactional
  336. public void globalRefund(OrderEntity order, WechatGlobalRefundApiResult result) {
  337. boolean needUpdateStock = true;
  338. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  339. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  340. }
  341. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  342. OrderRefundEntity orderRefund = new OrderRefundEntity();
  343. orderRefund.setRefundId(result.getRefund_id());
  344. orderRefund.setOutRefundNo(result.getOut_refund_no());
  345. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  346. orderRefund.setModTime(new Date());
  347. orderRefund.setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  348. orderRefund.setRefundFeeType(result.getRefund_fee_type());
  349. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getTotal_fee())) {
  350. orderRefund.setTotalFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getTotal_fee())).divide(Constant.ONE_HUNDRED).toString()));
  351. }
  352. orderRefund.setFeeType(result.getFee_type());
  353. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_fee())) {
  354. orderRefund.setCashFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_fee())).divide(Constant.ONE_HUNDRED).toString()));
  355. }
  356. orderRefund.setCashFeeType(result.getCash_fee_type());
  357. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_refund_fee())) {
  358. orderRefund.setCashRefundFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_refund_fee())).divide(Constant.ONE_HUNDRED).toString()));
  359. }
  360. orderRefund.setCashRefundFeeType(result.getCash_refund_fee_type());
  361. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  362. if (mallOrderRefund != null) {
  363. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  364. orderRefund.setId(mallOrderRefund.getId());
  365. orderRefundDao.update(orderRefund);
  366. } else {//退款记录不存在
  367. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  368. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  369. orderRefund.setCreateTime(new Date());
  370. orderRefundDao.save(orderRefund);//退款记录
  371. }
  372. orderDao.update(order);//修改为退款中
  373. // 判断是否有优惠券
  374. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  375. if (null != couponVo) {
  376. userCouponDao.cancelOrder(couponVo);
  377. }
  378. if (!needUpdateStock) {
  379. return;
  380. }
  381. // 更新库存
  382. updateStock(order, "管理后台微信国际退款订单");
  383. queryStorePromRealUpdateIsScan(order);
  384. }
  385. private void updateStock(OrderEntity order, String changeReason){
  386. Map<String, Object> map = new HashMap<String, Object>();
  387. SysUserEntity user = ShiroUtils.getUserEntity();
  388. map.put("orderId", order.getId());
  389. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryList(map);
  390. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  391. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  392. .queryByStoreIdProductId(Long.valueOf(order.getStoreId()),Long.valueOf(orderGoodsEntity.getProductId()));
  393. if (null == storeRelaEntity || null == storeRelaEntity.getSellVolume()) {
  394. storeRelaEntity.setSellVolume(0);
  395. }
  396. BigDecimal sellVolume = new BigDecimal(storeRelaEntity.getSellVolume() - orderGoodsEntity.getNumber());//销售量
  397. if (sellVolume.compareTo(Constant.ZERO) < 0) {
  398. sellVolume = Constant.ZERO;
  399. }
  400. Integer stockNum = 0;
  401. // TODO: 2019/3/5 普通商品不受共享库存影响,直接取门店配置库存
  402. if(storeRelaEntity.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  403. if (storeRelaEntity.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_1.getItem())) {
  404. //还原商户商品库存
  405. stockNum = storeRelaEntity.getGoodsNumber();
  406. GoodsEntity goodsEntity = goodsDao.queryObject(storeRelaEntity.getGoodsId());
  407. if(goodsEntity!=null){
  408. goodsEntity.setGoodsNumber(stockNum + orderGoodsEntity.getNumber());
  409. // goodsEntity.setSellVolume(Integer.parseInt(goodsSellVolume.toString()));
  410. goodsDao.update(goodsEntity);
  411. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString()));
  412. productStoreRelaDao.update(storeRelaEntity);
  413. MngChangeEntity mngChangeEntity = new MngChangeEntity();
  414. mngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(goodsEntity.getId())));
  415. mngChangeEntity.setThirdPartyMerchCode(goodsEntity.getThirdPartyMerchCode());
  416. mngChangeEntity.setChangeReason(changeReason);
  417. mngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  418. mngChangeEntity.setChangeNum(orderGoodsEntity.getNumber());//变化数
  419. mngChangeEntity.setOriginalNum(stockNum);//原库存数
  420. mngChangeEntity.setValidNum(stockNum + orderGoodsEntity.getNumber());//可用数
  421. mngChangeEntity.setCreateTime(new Date());
  422. mngChangeEntity.setModTime(new Date());
  423. mngChangeEntity.setCreaterSn(user.getUsername());
  424. mngChangeEntity.setModerSn(user.getUsername());
  425. mngChangeEntity.setIsValid(0);
  426. mngChangeEntity.setMerchSn(goodsEntity.getMerchSn());
  427. mngChangeDao.save(mngChangeEntity);
  428. }
  429. }
  430. if (storeRelaEntity.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_0.getItem())) {
  431. //还原门店库存
  432. if (null == storeRelaEntity.getStockNum()) {
  433. stockNum = 0;
  434. }else{
  435. stockNum = storeRelaEntity.getStockNum();
  436. }
  437. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString()));
  438. storeRelaEntity.setStockNum(stockNum + orderGoodsEntity.getNumber());//库存数量
  439. productStoreRelaDao.update(storeRelaEntity);
  440. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  441. storeMngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  442. storeMngChangeEntity.setChangeReason(changeReason);
  443. storeMngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(storeRelaEntity.getGoodsId())));
  444. storeMngChangeEntity.setStoreId(Integer.parseInt(String.valueOf(storeRelaEntity.getStoreId())));
  445. storeMngChangeEntity.setMerchSn(storeRelaEntity.getMerchSn());
  446. storeMngChangeEntity.setCreateTime(new Date());
  447. storeMngChangeEntity.setModTime(new Date());
  448. storeMngChangeEntity.setStoreChangeNum(orderGoodsEntity.getNumber());
  449. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  450. storeMngChangeEntity.setStoreValidNum(stockNum + orderGoodsEntity.getNumber());
  451. storeMngChangeEntity.setCreaterSn(user.getUsername());
  452. storeMngChangeEntity.setModerSn(user.getUsername());
  453. storeMngChangeEntity.setIsValid(0);
  454. storeMngChangeDao.save(storeMngChangeEntity);
  455. }
  456. }else {
  457. //还原门店库存
  458. if (null == storeRelaEntity.getStockNum()) {
  459. stockNum = 0;
  460. }else{
  461. stockNum = storeRelaEntity.getStockNum();
  462. }
  463. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString()));
  464. storeRelaEntity.setStockNum(stockNum + orderGoodsEntity.getNumber());//库存数量
  465. productStoreRelaDao.update(storeRelaEntity);
  466. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  467. storeMngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  468. storeMngChangeEntity.setChangeReason(changeReason);
  469. storeMngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(storeRelaEntity.getGoodsId())));
  470. storeMngChangeEntity.setStoreId(Integer.parseInt(String.valueOf(storeRelaEntity.getStoreId())));
  471. storeMngChangeEntity.setMerchSn(storeRelaEntity.getMerchSn());
  472. storeMngChangeEntity.setStoreChangeNum(orderGoodsEntity.getNumber());
  473. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  474. storeMngChangeEntity.setStoreValidNum(stockNum + orderGoodsEntity.getNumber());
  475. storeMngChangeEntity.setCreateTime(new Date());
  476. storeMngChangeEntity.setModTime(new Date());
  477. storeMngChangeEntity.setCreaterSn(user.getUsername());
  478. storeMngChangeEntity.setModerSn(user.getUsername());
  479. storeMngChangeEntity.setIsValid(0);
  480. storeMngChangeDao.save(storeMngChangeEntity);
  481. }
  482. }
  483. }
  484. /**
  485. * 查询该退款订单编号是否是推广渠道订单,是则修改渠道定时扫描状态
  486. * @param orderInfo
  487. */
  488. private void queryStorePromRealUpdateIsScan(OrderEntity orderInfo){
  489. Map map = new HashMap();
  490. map.put("orderId", orderInfo.getId());
  491. List<MkStorePromOrderRealEntity> list = mkStorePromOrderRealDao.queryPromRealListByMap(map);
  492. if(list.size() > 0) {
  493. for (MkStorePromOrderRealEntity mkStorePromOrderRealEntity : list) {
  494. mkStorePromOrderRealEntity.setIsPromStatScan(Dict.isDistSellScan.item_0.getItem());
  495. mkStorePromOrderRealDao.update(mkStorePromOrderRealEntity);
  496. }
  497. }
  498. }
  499. /**
  500. * 处理用户退款申请
  501. *
  502. * @param orderInfo
  503. */
  504. @Transactional
  505. public void applyRefundDeal(OrderEntity orderInfo, OrderRefundEntity refundEntity) {
  506. refundEntity.setApprovalTime(new Date());
  507. // refundEntity.setApprover(ShiroUtils.getUserId());
  508. // 退积分
  509. try {
  510. Integer integral = 1;
  511. if (orderInfo.getActualPrice().intValue() > 0) {
  512. integral = orderInfo.getActualPrice().intValue();
  513. }
  514. if (refundEntity.getRefundStatus() == 2) {
  515. orderInfo.setOrderStatus(401);
  516. UserEntity entity = userDao.queryObject(orderInfo.getUserId());
  517. } else {
  518. orderInfo.setOrderStatus(201);
  519. }
  520. } catch (Exception e) {
  521. e.printStackTrace();
  522. }
  523. orderRefundDao.update(refundEntity);
  524. orderDao.update(orderInfo);
  525. }
  526. @Override
  527. public OrderRefundEntity queryRefundObject(Long refundId) {
  528. return orderRefundDao.queryObject(refundId);
  529. }
  530. @Override
  531. public List<OrderRefundEntity> queryRefundList(Map<String, Object> map) {
  532. return orderRefundDao.queryList(map);
  533. }
  534. @Override
  535. public int queryRefundTotal(Map<String, Object> map) {
  536. return orderRefundDao.queryTotal(map);
  537. }
  538. @Override
  539. public int getUserOrderInfo(Map<String, Object> map) {
  540. int result = 0;
  541. String type = (String) map.get("type");
  542. if ("yfkOrderUserSum".equals(type)) {
  543. result = orderDao.getYfkOrderUserSum(map);
  544. } else if ("oderUserSum".equals(type)) {
  545. result = orderDao.getOderUserSum(map);
  546. } else if ("todayUserOrder".equals(type)) {
  547. result = orderDao.getTodayUserOrder(map);
  548. } else if ("todayUserSales".equals(type)) {
  549. result = orderDao.getTodayUserSales(map);
  550. } else if ("incomeSum".equals(type)) {
  551. result = orderDao.getIncomeSum(map);
  552. } else if ("payedOrderCount".equals(type)) {
  553. result = orderDao.getPayedOrderCount(map);
  554. }
  555. return result;
  556. }
  557. @Override
  558. public Map getLogistics(Long id) {
  559. OrderEntity orderEntity = queryObject(id);
  560. if (orderEntity == null) {
  561. throw new RRException("此订单不存在!");
  562. }
  563. if (orderEntity.getShippingStatus() == 0) {
  564. if (orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem()) ||
  565. orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())) {
  566. throw new RRException("此订单还未发货!");
  567. } else {
  568. if (StringUtils.isNullOrEmpty(orderEntity.getShippingNo())) {
  569. throw new RRException("此订单还未发货!");
  570. }
  571. }
  572. }
  573. Map logisticsInfo = Maps.newHashMap();
  574. List<WuliuEntity> wuliuEntityList = new ArrayList<>();
  575. OrderProcessRecordEntity orderProcessRecordEntity =
  576. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  577. if (orderProcessRecordEntity != null) {
  578. if (orderEntity.getOrderBizType().equals(Dict.orderBizType.item_10.getItem()) ||
  579. orderEntity.getOrderBizType().equals(Dict.orderBizType.item_02.getItem())) {
  580. WuliuEntity wuliuEntity = new WuliuEntity();
  581. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  582. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  583. wuliuEntity.setAcceptStation(PrintTicketPropertiesBuilder.instance().getAddress() + "送达" +
  584. storeDao.queryObject(orderEntity.getStoreId()).getStoreAddress() +
  585. ";交易完成,用户已提走");
  586. wuliuEntityList.add(wuliuEntity);
  587. }
  588. if (StringUtils.isNotEmpty(orderEntity.getShippingCode()) &&
  589. StringUtils.isNotEmpty(orderEntity.getShippingNo()) &&
  590. orderProcessRecordEntity.getShipmentStartTime() != null) {
  591. if(orderEntity.getShippingCode().equalsIgnoreCase("SF")){
  592. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  593. if(storeEntity == null){
  594. throw new RRException("查询顺丰订单异常,订单的门店信息不存在");
  595. }
  596. ThirdMerchExpressEntity thirdMerchExpressEntity = thirdMerchExpressDao.getThirdMerchExpressByThirdCode(storeEntity.getThirdPartyMerchCode());
  597. if(thirdMerchExpressEntity == null){
  598. throw new RRException("查询顺丰订单异常,缺失商户快递账号信息");
  599. }
  600. SfRouteServiceResponseEntity entity = SFUtil.routeService(orderEntity.getShippingNo(), thirdMerchExpressEntity.getExpressAccount(),
  601. thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());
  602. // SfRouteServiceResponseEntity entity = SFUtil.routeService("254355029325", thirdMerchExpressEntity.getExpressAccount(),
  603. // thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());//444072971585
  604. if(entity.getHead().equalsIgnoreCase("OK")){
  605. if(entity.getBody() == null){
  606. WuliuEntity wuliuEntity = new WuliuEntity();
  607. wuliuEntity.setAcceptStation("暂无物流轨迹");
  608. wuliuEntityList.add(wuliuEntity);
  609. }else{
  610. if(entity.getBody().getRouteResponse() == null){
  611. WuliuEntity wuliuEntity = new WuliuEntity();
  612. wuliuEntity.setAcceptStation("暂无物流轨迹");
  613. wuliuEntityList.add(wuliuEntity);
  614. }else{
  615. RouteResponseEntity routeResponseEntity = entity.getBody().getRouteResponse().get(0);
  616. if(routeResponseEntity != null){
  617. List<RouteEntity> entityList = routeResponseEntity.getRouteResponse();
  618. for (RouteEntity route : entityList) {
  619. WuliuEntity wuliuEntity = new WuliuEntity();
  620. wuliuEntity.setAcceptTime(route.getAccept_time());
  621. wuliuEntity.setAcceptStation(route.getAccept_address() + route.getRemark());
  622. wuliuEntityList.add(wuliuEntity);
  623. }
  624. }
  625. }
  626. }
  627. }else{
  628. throw new RRException("查询顺丰订单异常,"+entity.getErrors());
  629. }
  630. }else{
  631. JSONObject traces =
  632. KdniaoUtil.getOrderTracesByJson(orderEntity.getShippingCode(), orderEntity.getShippingNo());
  633. List<Map> mapList = (List<Map>) traces.get("Traces");
  634. if (mapList != null && mapList.size() > 0) {
  635. for (Map map : mapList) {
  636. WuliuEntity wuliuEntity = new WuliuEntity();
  637. wuliuEntity.setAcceptTime(map.get("AcceptTime").toString());
  638. wuliuEntity.setAcceptStation(map.get("AcceptStation").toString());
  639. wuliuEntityList.add(wuliuEntity);
  640. }
  641. }
  642. String state = traces.get("State") + "";
  643. if (Dict.logisticsStatus.item_0.getItem().equals(state) && traces.getBoolean("Success")) {
  644. String reason = traces.get("Reason") + "";
  645. WuliuEntity wuliuEntity = new WuliuEntity();
  646. wuliuEntity.setAcceptStation(reason);
  647. wuliuEntityList.add(wuliuEntity);
  648. }
  649. }
  650. }
  651. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend()) &&
  652. orderProcessRecordEntity.getShipmentStartTime() != null) {
  653. WuliuEntity wuliuEntity = new WuliuEntity();
  654. wuliuEntity.setAcceptStation("订单已出库");
  655. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  656. .format(orderProcessRecordEntity.getShipmentStartTime()));
  657. wuliuEntityList.add(wuliuEntity);
  658. }
  659. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsCustomsSend())) {
  660. WuliuEntity wuliuEntity = new WuliuEntity();
  661. wuliuEntity.setAcceptStation("订单清关完成,等待仓库发货");
  662. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  663. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  664. wuliuEntityList.add(wuliuEntity);
  665. }
  666. if (Dict.isSend.item_0.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend())) {
  667. WuliuEntity wuliuEntity = new WuliuEntity();
  668. wuliuEntity.setAcceptStation("订单清关失败");
  669. wuliuEntityList.add(wuliuEntity);
  670. }
  671. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsEleOrderSend()) &&
  672. orderProcessRecordEntity.getWaybillSuccTime() != null) {
  673. WuliuEntity wuliuEntity = new WuliuEntity();
  674. wuliuEntity.setAcceptStation("海关三单发送成功");
  675. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  676. .format(orderProcessRecordEntity.getWaybillSuccTime()));
  677. wuliuEntityList.add(wuliuEntity);
  678. }
  679. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsPaymentSend())) {
  680. WuliuEntity wuliuEntity = new WuliuEntity();
  681. wuliuEntity.setAcceptStation("订单支付成功");
  682. wuliuEntity.setAcceptTime(
  683. new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(orderProcessRecordEntity.getPaySuccTime()));
  684. wuliuEntityList.add(wuliuEntity);
  685. }
  686. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsAddOrderSend())) {
  687. WuliuEntity wuliuEntity = new WuliuEntity();
  688. wuliuEntity.setAcceptStation("订单下单成功");
  689. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  690. .format(orderProcessRecordEntity.getAddOrderSuccTime()));
  691. wuliuEntityList.add(wuliuEntity);
  692. }
  693. }
  694. logisticsInfo.put("tracesList", wuliuEntityList);
  695. logisticsInfo.put("logisticCode", orderEntity.getShippingNo());
  696. logisticsInfo.put("shipperCode", orderEntity.getShippingCode());
  697. return logisticsInfo;
  698. }
  699. @Override
  700. public OrderEntity queryInfos(Long id) {
  701. OrderEntity orderEntity = orderDao.queryObject(id);
  702. Map<String, Object> map = new HashMap<String, Object>();
  703. map.put("orderId", id);
  704. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  705. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  706. return orderEntity;
  707. }
  708. /**
  709. * 普货商品生成线下订单
  710. * @param offlineCartList
  711. * @param user
  712. * @return
  713. */
  714. @Transactional
  715. @Override
  716. public Map orderSubmit(List<OfflineCartEntity> offlineCartList, SysUserEntity user) {
  717. Map resultObj = Maps.newHashMap();
  718. try {
  719. if (user == null) {
  720. resultObj.put("errno", 400);
  721. resultObj.put("errmsg", "用户登录超时,请重新登录");
  722. return resultObj;
  723. }
  724. if (!user.getRoleType().equalsIgnoreCase("2")) {
  725. resultObj.put("errno", 400);
  726. resultObj.put("errmsg", "该操作只允许店员账户操作");
  727. return resultObj;
  728. }
  729. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  730. resultObj.put("errno", 400);
  731. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  732. return resultObj;
  733. }
  734. Long userId = user.getUserId();
  735. Integer storeId = user.getStoreId();
  736. //获取要购买的商品
  737. Map param = Maps.newHashMap();
  738. param.put("userId", userId);
  739. param.put("storeId", storeId);
  740. if (null == offlineCartList && offlineCartList.size() == 0) {
  741. resultObj.put("errno", 400);
  742. resultObj.put("errmsg", "购买商品数据为空");
  743. return resultObj;
  744. }
  745. List<OfflineCartEntity> offlineCartEntityList = offlineCartDao.queryOfflineCartByBizType(param);
  746. if (offlineCartEntityList.size() == 0 && offlineCartList.size() > 0) {
  747. resultObj.put("errno", 0);
  748. resultObj.put("errmsg", "该单已下单成功,请重新扫描商品进行购买");
  749. return resultObj;
  750. }
  751. // 检查库存和更新库存
  752. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  753. if (goodsDao.queryObject(cartEntity.getGoodsId()) == null) {
  754. resultObj.put("errno", 400);
  755. resultObj.put("errmsg", "订单提交失败:商品不存在");
  756. return resultObj;
  757. }
  758. //取得规格的信息,判断规格库存
  759. ProductStoreRelaEntity productInfo = productStoreRelaDao
  760. .queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(cartEntity.getGoodsId()));
  761. synchronized (productInfo) {
  762. if (null == productInfo || null == productInfo.getStockNum() ||
  763. productInfo.getStockNum() < cartEntity.getNumber()) {
  764. resultObj.put("errno", 400);
  765. resultObj.put("errmsg", "库存不足,仅剩余" + productInfo.getStockNum());
  766. return resultObj;
  767. } else {
  768. productInfo.setStockNum(productInfo.getStockNum() - cartEntity.getNumber());
  769. productInfo.setStoreId(Long.valueOf(storeId));
  770. productInfo.addSellVolume();
  771. productStoreRelaDao.updateStockNum(productInfo);//修改普通商品库存
  772. }
  773. }
  774. }
  775. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  776. OrderEntity order = setOrderVo(user, offlineCartEntityList, user.getMerchSn());
  777. order.setStoreId(storeId);
  778. order.setMerchOrderSn(merchOrderSn);
  779. //开启事务,插入订单信息和订单商品
  780. if (order != null) {
  781. orderDao.save(order);
  782. if (null == order.getId()) {
  783. resultObj.put("errno", 400);
  784. resultObj.put("errmsg", "订单提交失败");
  785. return resultObj;
  786. }
  787. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  788. OrderGoodsEntity orderGoodsEntity = setOrderGoodsVo(order, cartEntity);
  789. //新增订单详情
  790. orderGoodsDao.save(orderGoodsEntity);
  791. }
  792. //清空预订单商品临时表
  793. offlineCartDao.deleteByUserId(userId);
  794. Map orderInfoMap = Maps.newHashMap();
  795. orderInfoMap.put("orderInfo", order);
  796. resultObj.put("errno", 0);
  797. resultObj.put("errmsg", "订单提交成功");
  798. resultObj.put("data", orderInfoMap);
  799. }
  800. } catch (Exception e) {
  801. e.printStackTrace();
  802. resultObj.put("errno", 400);
  803. resultObj.put("errmsg", "订单异常");
  804. return resultObj;
  805. }
  806. return resultObj;
  807. }
  808. /**
  809. * 设置订单数据
  810. *
  811. * @param loginUser
  812. * @return
  813. */
  814. public OrderEntity setOrderVo(SysUserEntity loginUser, List<OfflineCartEntity> offlineCartEntityList,
  815. String merchSn) {
  816. OrderEntity orderInfo = new OrderEntity();
  817. BigDecimal freightPrice = new BigDecimal(0.00);
  818. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  819. for (OfflineCartEntity offlineCartEntity : offlineCartEntityList) {
  820. goodsTotalPrice = goodsTotalPrice
  821. .add(offlineCartEntity.getRetailPrice().multiply(new BigDecimal(offlineCartEntity.getNumber())));
  822. }
  823. //订单价格计算:订单的总价+运费
  824. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  825. //查询未使用的优惠券
  826. /*String couponName = "";
  827. BigDecimal fullCutCouponDec = Constant.ZERO;
  828. UserCouponVo couponVo = null;*/
  829. BigDecimal couponPrice = new BigDecimal(0.00);
  830. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  831. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  832. //商户(拼音首字母)+业务类型+编号
  833. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  834. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  835. MerchEntity merchEntity = merchDao.findByMerchSn(merchSn);
  836. String merchShortName = "";
  837. if (merchEntity != null) {
  838. merchShortName = merchEntity.getMerchShortName();
  839. }
  840. String orderSn = merchShortName + Dict.orderBizType.item_11.getItem() + CommonUtil.generateOrderNumber();
  841. orderInfo.setOrderSn(orderSn);
  842. orderInfo.setMerchSn(merchSn);
  843. orderInfo.setUserId(Integer.parseInt(loginUser.getUserId() + ""));
  844. orderInfo.setFreightPrice(freightPrice.intValue());
  845. orderInfo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  846. /*orderInfo.setCoupon_id(userCouponId);
  847. orderInfo.setCoupon_name(couponName);*/
  848. // orderInfo.setFullCutPrice(fullCutCouponDec);//使用的优惠券
  849. orderInfo.setCouponPrice(couponPrice);
  850. orderInfo.setPostscript("");//留言
  851. orderInfo.setAddTime(new Date());
  852. orderInfo.setGoodsPrice(goodsTotalPrice);
  853. orderInfo.setOrderPrice(orderTotalPrice);
  854. orderInfo.setActualPrice(actualPrice);
  855. orderInfo.setOrderType("1");
  856. orderInfo.setOrderStatus(0);// 待付款
  857. orderInfo.setShippingStatus(0);
  858. orderInfo.setPayStatus(0);
  859. orderInfo.setShippingId(0L);
  860. orderInfo.setShippingFee(Constant.ZERO);
  861. orderInfo.setIntegral(0);
  862. orderInfo.setIntegralMoney(Constant.ZERO);
  863. orderInfo.setCreateTime(new Date());
  864. orderInfo.setModTime(new Date());
  865. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());//线下购买
  866. /*//标记该订单已使用优惠券
  867. if(couponVo != null){
  868. couponVo.setUsed_time(new Date());
  869. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  870. apiUserCouponMapper.update(couponVo);
  871. }*/
  872. return orderInfo;
  873. }
  874. public OrderGoodsEntity setOrderGoodsVo(OrderEntity orderInfo, OfflineCartEntity goodsItem) {
  875. GoodsEntity goodsVo = goodsDao.queryObject(goodsItem.getGoodsId());
  876. OrderGoodsEntity orderGoodsVo = new OrderGoodsEntity();
  877. orderGoodsVo.setOrderId(Integer.parseInt(orderInfo.getId() + ""));
  878. orderGoodsVo.setGoodsId(goodsItem.getGoodsId());
  879. orderGoodsVo.setGoodsSn(goodsItem.getGoodsSn());
  880. orderGoodsVo.setProductId(goodsItem.getProductId());
  881. orderGoodsVo.setGoodsName(goodsItem.getGoodsName());
  882. orderGoodsVo.setListPicUrl(goodsItem.getListPicUrl());
  883. orderGoodsVo.setMarketPrice(goodsItem.getMarketPrice());
  884. orderGoodsVo.setRetailPrice(goodsItem.getRetailPrice());
  885. orderGoodsVo.setNumber(goodsItem.getNumber());
  886. orderGoodsVo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  887. orderGoodsVo.setCreateTime(new Date());
  888. orderGoodsVo.setModTime(new Date());
  889. orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  890. orderGoodsVo.setSku(goodsVo.getSku());
  891. return orderGoodsVo;
  892. }
  893. @Override
  894. public OrderEntity queryObjectBySysUser(Long id) {
  895. OrderEntity orderEntity = orderDao.queryObjectBySysUser(id);
  896. Map<String, Object> map = new HashMap<String, Object>();
  897. map.put("orderId", id);
  898. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  899. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  900. return orderEntity;
  901. }
  902. @Override
  903. public int confirmPay(Long id, String payFlag,String orderSnWx) {
  904. SysUserEntity user = ShiroUtils.getUserEntity();
  905. if (user == null) {
  906. throw new RRException("用户登录超时,请重新登录");
  907. }
  908. if (!user.getRoleType().equalsIgnoreCase("2")) {
  909. throw new RRException("该操作只允许店员账户操作");
  910. }
  911. OrderEntity orderEntity = queryObject(id);
  912. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  913. throw new RRException("此订单已付款!");
  914. }
  915. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  916. throw new RRException("此订单已完成!");
  917. }
  918. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  919. throw new RRException("此订单已取消!");
  920. }
  921. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  922. throw new RRException("此订单已删除!");
  923. }
  924. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_201.getItem()));
  925. orderEntity.setPayStatus(Integer.parseInt(Dict.payStatus.item_2.getItem()));
  926. orderEntity.setPayFlag(payFlag);
  927. orderEntity.setPayTime(new Date());
  928. if(orderSnWx != null){
  929. orderEntity.setOrderSnWx(orderSnWx);
  930. }
  931. orderDao.update(orderEntity);
  932. return 0;
  933. }
  934. @Override
  935. public List<OrderEntity> queryExportList(Map<String, Object> map) {
  936. List<OrderEntity> list = orderDao.queryExportList(map);
  937. for (OrderEntity order : list) {
  938. OrderProcessRecordEntity orderProcessRecord = orderProcessRecordDao.queryObjectByOrderSn(order.getOrderSn());
  939. order.setOrderProcessRecord(orderProcessRecord);
  940. }
  941. return list;
  942. }
  943. @Override
  944. public List<OrderEntity> queryOffilineOrderList(Map<String, Object> map) {
  945. return orderDao.queryOffilineOrderList(map);
  946. }
  947. @Override
  948. public int uploadExcel(List<OrderExpressDto> orderExpressDtoList) {
  949. SysUserEntity user = ShiroUtils.getUserEntity();
  950. boolean isFail = false;
  951. List<String> failShippingNameList = new ArrayList<>();
  952. List<String> failOrderSnList = new ArrayList<>();
  953. List<String> failShippingCodeList = new ArrayList<>();
  954. List<String> failCodeSnList = new ArrayList<>();
  955. List<String> failNameSnList = new ArrayList<>();
  956. List<String> failStatusOrderSnList = new ArrayList<>();
  957. if (orderExpressDtoList != null && orderExpressDtoList.size() > 0) {
  958. for (int i = 0; i < orderExpressDtoList.size(); i++) {
  959. OrderExpressDto orderExpressDto = orderExpressDtoList.get(i);
  960. OrderEntity orderEntity = new OrderEntity();
  961. Map<String, Object> valideDate = MapBeanUtil.fromObject(orderExpressDto);
  962. ImmutableBiMap.Builder builder = new ImmutableBiMap.Builder();
  963. builder.put("orderSn", "订单编号");
  964. builder.put("shippingNo", "快递单号");
  965. builder.put("shippingName", "快递公司");
  966. builder.put("shippingCode", "快递简写");
  967. R r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  968. if (Integer.valueOf(r.get("code").toString()) != 0) {
  969. throw new RRException(r.get("msg").toString());
  970. } else {
  971. r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  972. if (Integer.valueOf(r.get("code").toString()) != 0) {
  973. throw new RRException(r.get("msg").toString());
  974. }
  975. }
  976. OrderEntity order = orderDao.queryObjectByOrderSn(orderExpressDto.getOrderSn());
  977. if(order == null){
  978. isFail = true;
  979. failOrderSnList.add(orderExpressDto.getOrderSn());
  980. }else{
  981. if(!(order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())
  982. && order.getPayStatus() == Integer.parseInt(Dict.payStatus.item_2.getItem()))){
  983. isFail = true;
  984. failStatusOrderSnList.add(orderExpressDto.getOrderSn());
  985. }
  986. }
  987. ShippingEntity shippingEntity = shippingDao.queryObjectByCode(orderExpressDto.getShippingCode());
  988. if(shippingEntity == null){
  989. isFail = true;
  990. failShippingCodeList.add(orderExpressDto.getShippingCode());
  991. failCodeSnList.add(orderExpressDto.getOrderSn());
  992. }else{
  993. if(!orderExpressDto.getShippingName().equalsIgnoreCase(shippingEntity.getName())){
  994. isFail = true;
  995. failShippingNameList.add(orderExpressDto.getShippingName());
  996. failNameSnList.add(orderExpressDto.getOrderSn());
  997. }
  998. }
  999. if(!isFail){//false则有错误的数据
  1000. if(order != null) {// 修改商品
  1001. // orderEntity.setOrderSn(orderExpressDto.getOrderSn());
  1002. orderEntity.setShippingNo(orderExpressDto.getShippingNo());
  1003. orderEntity.setShippingCode(orderExpressDto.getShippingCode());
  1004. orderEntity.setShippingName(orderExpressDto.getShippingName());
  1005. orderEntity.setShippingStatus(Integer.parseInt(Dict.shippingStatus.item_1.getItem()));
  1006. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_300.getItem()));
  1007. orderEntity.setModerSn(user.getUsername());
  1008. orderEntity.setCreateTime(new Date());
  1009. orderEntity.setModTime(new Date());
  1010. orderEntity.setId(order.getId());
  1011. orderDao.update(orderEntity);
  1012. }
  1013. }
  1014. }
  1015. if(failOrderSnList != null && failOrderSnList.size() > 0){
  1016. throw new RRException("导入数据异常,订单编号不存在,不存在的订单编号【"+failOrderSnList+"】,请删除掉再继续操作");
  1017. }
  1018. if(failStatusOrderSnList != null && failStatusOrderSnList.size() > 0){
  1019. throw new RRException("导入数据异常,修改订单快递功能只支持已付款未发货的订单,以下订单编号无效【"+failStatusOrderSnList+"】,请删除掉再继续操作");
  1020. }
  1021. if(failShippingCodeList != null && failShippingCodeList.size() > 0){
  1022. throw new RRException("导入数据异常,快递简写不在可支持的范围中,简写错误的订单编号【"+failCodeSnList+"】,错误的快递简写【"+failShippingCodeList+"】," +
  1023. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1024. }
  1025. if(failShippingNameList != null && failShippingNameList.size() > 0){
  1026. throw new RRException("导入数据异常,快递简写对应的快递公司不一致,快递公司错误的订单编号【"+failNameSnList+"】,请修改Excel数据中订单编号对应的快递公司错误信息," +
  1027. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1028. }
  1029. // if(failFreightGoodsSnList != null && failFreightGoodsSnList.size() > 0){
  1030. // exportExceptionDataEntity.setExportExceptionData("运费信息请在商城配置》运费模板中维护,运费与商户信息对应,请检查该商品商户信息下的运费是否维护,不存在的商品编码【"+failFreightGoodsSnList+"】,运费【"+failFreightList+"】");
  1031. // exportExceptionDataDao.save(exportExceptionDataEntity);
  1032. // throw new RRException("导入数据异常,异常信息请在商品管理》》商品导入异常数据中查看检查");
  1033. // }
  1034. }else{
  1035. throw new RRException("导入数据为空,或者检查商品编码数据是否为空");
  1036. }
  1037. return 1;
  1038. }
  1039. @Override
  1040. public List<OrderEntity> promOrderList(Map<String, Object> map) {
  1041. Integer[] statusList = {201};
  1042. List<OrderEntity> list = orderDao.promOrderList(map);
  1043. for (OrderEntity orderEntity: list) {
  1044. Map<String, Object> queryMap = new HashMap<>();
  1045. queryMap.put("goodsId", orderEntity.getGoodsId());
  1046. queryMap.put("statusList", statusList);
  1047. queryMap.put("orderId", orderEntity.getId());
  1048. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1049. if(promActualPrice == null){
  1050. promActualPrice = 0d;
  1051. }
  1052. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1053. }
  1054. return list;
  1055. }
  1056. @Override
  1057. public int queryPromOrderTotal(Map<String, Object> map) {
  1058. return orderDao.queryPromOrderTotal(map);
  1059. }
  1060. @Override
  1061. public List<OrderEntity> promOrderListExport(Map<String, Object> map){
  1062. Integer[] statusList = {201};
  1063. List<OrderEntity> list = orderDao.promOrderListExport(map);
  1064. for (OrderEntity orderEntity: list) {
  1065. Map<String, Object> queryMap = new HashMap<>();
  1066. queryMap.put("goodsId", orderEntity.getGoodsId());
  1067. queryMap.put("orderId", orderEntity.getId());
  1068. queryMap.put("statusList", statusList);
  1069. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1070. if(promActualPrice == null){
  1071. promActualPrice = 0d;
  1072. }
  1073. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1074. }
  1075. return list;
  1076. }
  1077. @Override
  1078. public List<OrderEntity> storeTopicOrderList(Map<String, Object> map) {
  1079. List<OrderEntity> list = orderDao.storeTopicOrderList(map);
  1080. return list;
  1081. }
  1082. @Override
  1083. public int queryStoreTopicOrderTotal(Map<String, Object> map) {
  1084. return orderDao.queryStoreTopicOrderTotal(map);
  1085. }
  1086. }