1
0

ApiOrderService.java 63 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261
  1. package com.kmall.api.service;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.google.common.collect.Maps;
  5. import com.kmall.api.dao.mk.ApiMkStoreCampMinusMapper;
  6. import com.kmall.api.dao.mk.ApiMkStorePromMapper;
  7. import com.kmall.api.dao.mk.ApiMkStoreTicketDiscountMapper;
  8. import com.kmall.api.dto.CampMinusDto;
  9. import com.kmall.api.dto.CheckOutDto;
  10. import com.kmall.api.entity.mk.MkStoreCampMinusVo;
  11. import com.kmall.api.entity.mk.MkStorePromStatVo;
  12. import com.kmall.api.entity.mk.MkStorePromVo;
  13. import com.kmall.api.entity.mk.MkStoreTicketDiscountVo;
  14. import com.kmall.api.fromcomm.entity.FormIdsEntity;
  15. import com.kmall.api.service.mk.ApiMkStorePromStatService;
  16. import com.kmall.api.service.mk.ApiMkStoreTopicStatService;
  17. import com.kmall.api.util.StockUtil;
  18. import com.kmall.common.utils.*;
  19. import com.kmall.manager.dao.TemplateConfDao;
  20. import com.kmall.manager.entity.pay.TemplateConfVo;
  21. import com.kmall.manager.manager.print.ticket.PrintTicketPropertiesBuilder;
  22. import com.kmall.manager.manager.print.ticket.TicketPrintUtil;
  23. import com.kmall.api.fromcomm.service.FormIdsService;
  24. import com.kmall.common.constant.Dict;
  25. import com.kmall.api.dao.*;
  26. import com.kmall.api.dto.IdCardMsgVo;
  27. import com.kmall.api.entity.*;
  28. import com.kmall.manager.manager.merch.OmsMerchPropertiesBuilder;
  29. import com.kmall.api.util.CommonUtil;
  30. import com.kmall.api.util.IdCardUtil;
  31. import com.kmall.common.utils.print.ticket.item.*;
  32. import com.kmall.manager.manager.wechat.wxtemplate.TemplateData;
  33. import com.kmall.manager.manager.wechat.wxtemplate.WxTemplate;
  34. import org.apache.commons.logging.Log;
  35. import org.apache.commons.logging.LogFactory;
  36. import org.springframework.beans.factory.annotation.Autowired;
  37. import org.springframework.stereotype.Service;
  38. import org.springframework.transaction.annotation.Transactional;
  39. import java.math.BigDecimal;
  40. import java.text.SimpleDateFormat;
  41. import java.util.*;
  42. @Service
  43. public class ApiOrderService {
  44. private Log logger = LogFactory.getLog(ApiOrderService.class);
  45. @Autowired
  46. private ApiProductMapper apiProductMapper;
  47. @Autowired
  48. private ApiCartMapper apiCartMapper;
  49. @Autowired
  50. private ApiOrderMapper apiOrderMapper;
  51. @Autowired
  52. private ApiOrderGoodsMapper apiOrderGoodsMapper;
  53. @Autowired
  54. private ApiUserCouponMapper apiUserCouponMapper;
  55. @Autowired
  56. private TemplateConfDao apiTemplateConfMapper;
  57. @Autowired
  58. private ApiUserMapper apiUserMapper;
  59. @Autowired
  60. private FormIdsService formIdsService;
  61. @Autowired
  62. private ApiGoodsMapper apiGoodsMapper;
  63. @Autowired
  64. private ApiFreightService apiFreightService;
  65. @Autowired
  66. private ApiOrderProcessRecordMapper orderProcessRecordMapper;
  67. @Autowired
  68. private ApiStoreMapper apiStoreMapper;
  69. @Autowired
  70. private ApiMerchMapper apiMerchMapper;
  71. @Autowired
  72. private ApiMngChangeMapper apiMngChangeMapper;
  73. @Autowired
  74. private ApiStoreMngChangeMapper apiStoreMngChangeMapper;
  75. @Autowired
  76. private ApiMkStorePromMapper apiMkStorePromMapper;
  77. @Autowired
  78. private ApiMkStorePromStatService apiMkStorePromStatService;
  79. @Autowired
  80. private ApiMkStoreTicketDiscountMapper apiMkStoreTicketDiscountMapper;
  81. @Autowired
  82. private ApiCartService cartService;
  83. @Autowired
  84. private ApiMkStoreTopicStatService apiMkStoreTopicStatService;
  85. @Autowired
  86. private ApiMkStoreCampMinusMapper apiMkStoreCampMinusMapper;
  87. @Autowired
  88. private ApiUserCampMinusMapper apiUserCampMinusMapper;
  89. public OrderVo queryObject(Long id) {
  90. return apiOrderMapper.queryObject(id);
  91. }
  92. public OrderVo queryObjectByOrderSn(String order_sn) {
  93. return apiOrderMapper.queryObjectByOrderSn(order_sn);
  94. }
  95. public Map queryUcenterMap(Map<String, Object> map) {
  96. return apiOrderMapper.queryUcenterMap(map);
  97. }
  98. public List<OrderVo> queryList(Map<String, Object> map) {
  99. return apiOrderMapper.queryList(map);
  100. }
  101. public int queryTotal(Map<String, Object> map) {
  102. return apiOrderMapper.queryTotal(map);
  103. }
  104. public void save(OrderVo order) {
  105. apiOrderMapper.save(order);
  106. }
  107. @Transactional
  108. public void cancelOrder(Long userId, OrderVo order) {
  109. Map orderGoodsParam = Maps.newHashMap();
  110. orderGoodsParam.put("order_id", order.getId());
  111. String userName = "";
  112. if(userId != null){
  113. UserVo userVo = apiUserMapper.queryObject(userId);
  114. userName = userVo != null ? userVo.getUsername():"";
  115. }
  116. //订单的商品
  117. List<OrderGoodsVo> goodsList = apiOrderGoodsMapper.queryList(orderGoodsParam);
  118. for (OrderGoodsVo orderGoodsVo : goodsList) {
  119. ProductVo productInfo = apiProductMapper.queryByStoreId(orderGoodsVo.getProduct_id(), order.getStore_id());
  120. GoodsVo goodsInfo = apiGoodsMapper.queryObjectByStoreId(orderGoodsVo.getGoods_id(), order.getStore_id());
  121. if (null == goodsInfo || goodsInfo.getIs_delete() == 1 || goodsInfo.getIs_on_sale() == 0) {
  122. throw new RRException("订单提交失败:商品不存在");
  123. }
  124. // Integer stockNum = StockUtil.setStockNumByGoodsVo(goodsInfo);
  125. // String isStockShare = StockUtil.getIsStockShareByGoodsVo(goodsInfo);
  126. // TODO: 2019/3/5 普通商品不受共享库存影响,直接取门店配置库存
  127. //还原门店库存
  128. resetStoreGoodsStock(goodsInfo.getStockNum(), productInfo, goodsInfo, orderGoodsVo, userName);
  129. //还原商户商品库存
  130. resetGoodsStock(goodsInfo.getGoods_number(), productInfo, goodsInfo, orderGoodsVo, userName);
  131. }
  132. update(order);
  133. // 判断是否有优惠券
  134. UserCouponVo couponVo = apiUserCouponMapper.queryByOrderId(order.getId());
  135. if (null != couponVo) {
  136. apiUserCouponMapper.cancelOrder(couponVo);
  137. }
  138. //释放促销满减券
  139. UserCampMinusVo userCampMinusVo = apiUserCampMinusMapper.queryUserCampByOrderId(order.getId());
  140. if (null != userCampMinusVo) {
  141. apiUserCampMinusMapper.cancelUserCampOrder(userCampMinusVo);
  142. }
  143. }
  144. /**
  145. * 还原商户商品总库存
  146. */
  147. private void resetGoodsStock(Integer stockNum, ProductVo productInfo, GoodsVo goodsInfo, OrderGoodsVo orderGoodsVo, String userName){
  148. stockNum = stockNum == null? 0 : stockNum;
  149. goodsInfo.setGoods_number(stockNum + orderGoodsVo.getNumber());
  150. // goodsInfo.setSell_volume(goodsInfo.getGoods_sell_volume() - orderGoodsVo.getNumber());
  151. apiGoodsMapper.updateGoodsStock(goodsInfo);
  152. // productInfo.setSell_volume(productInfo.getSell_volume() - orderGoodsVo.getNumber());
  153. // productInfo.setGoods_id(goodsInfo.getId());
  154. // apiProductMapper.updateStockNum(productInfo);
  155. MngChangeVo mngChangeVo = new MngChangeVo();
  156. mngChangeVo.setGoodsId(Integer.parseInt(String.valueOf(goodsInfo.getId())));
  157. mngChangeVo.setThirdPartyMerchCode(goodsInfo.getThirdPartyMerchCode());
  158. mngChangeVo.setChangeReason("小程序取消订单");
  159. mngChangeVo.setChangeType(Dict.changeType.item_0.getItem());
  160. mngChangeVo.setChangeNum(orderGoodsVo.getNumber());//变化数
  161. mngChangeVo.setOriginalNum(stockNum);//原库存数
  162. mngChangeVo.setValidNum(stockNum + orderGoodsVo.getNumber());//可用数
  163. mngChangeVo.setCreateTime(new Date());
  164. mngChangeVo.setModTime(new Date());
  165. mngChangeVo.setCreaterSn("小程序用户"+userName);
  166. mngChangeVo.setModerSn("小程序用户"+userName);
  167. mngChangeVo.setIsValid(0);
  168. mngChangeVo.setMerchSn(goodsInfo.getMerchSn());
  169. apiMngChangeMapper.save(mngChangeVo);
  170. }
  171. /**
  172. * 还原门店商品库存
  173. */
  174. private void resetStoreGoodsStock(Integer stockNum, ProductVo productInfo, GoodsVo goodsInfo, OrderGoodsVo orderGoodsVo, String userName){
  175. stockNum = stockNum == null? 0 : stockNum;
  176. productInfo.setStock_num(stockNum + orderGoodsVo.getNumber());
  177. productInfo.setGoods_id(goodsInfo.getId());
  178. productInfo.setSell_volume(productInfo.getSell_volume() - orderGoodsVo.getNumber());
  179. apiProductMapper.updateStockNum(productInfo);
  180. StoreMngChangeVo storeMngChangeVo = new StoreMngChangeVo();
  181. storeMngChangeVo.setChangeType(Dict.changeType.item_0.getItem());
  182. storeMngChangeVo.setChangeReason("小程序取消订单");
  183. storeMngChangeVo.setGoodsId(Integer.parseInt(String.valueOf(goodsInfo.getId())));
  184. storeMngChangeVo.setStoreId(Integer.parseInt(String.valueOf(productInfo.getStore_id())));
  185. storeMngChangeVo.setMerchSn(goodsInfo.getMerchSn());
  186. storeMngChangeVo.setStoreChangeNum(orderGoodsVo.getNumber());
  187. storeMngChangeVo.setStoreOriginalNum(stockNum);
  188. storeMngChangeVo.setStoreValidNum(stockNum + orderGoodsVo.getNumber());
  189. storeMngChangeVo.setCreateTime(new Date());
  190. storeMngChangeVo.setModTime(new Date());
  191. storeMngChangeVo.setCreaterSn("小程序用户"+userName);
  192. storeMngChangeVo.setModerSn("小程序用户"+userName);
  193. storeMngChangeVo.setIsValid(0);
  194. apiStoreMngChangeMapper.save(storeMngChangeVo);
  195. }
  196. public void update(OrderVo order) {
  197. order.setIsScan("0");
  198. order.setModTime(new Date());
  199. apiOrderMapper.update(order);
  200. }
  201. public void updateOrderByMerchOrderSn(OrderVo order) {
  202. apiOrderMapper.updateOrderByMerchOrderSn(order);
  203. }
  204. public void updateBatch(List<OrderVo> list) {
  205. for (OrderVo order : list) {
  206. order.setIsScan("0");
  207. order.setModTime(new Date());
  208. }
  209. apiOrderMapper.updateBatch(list);
  210. }
  211. public void delete(Integer id) {
  212. apiOrderMapper.delete(id);
  213. }
  214. public void deleteBatch(Integer[] ids) {
  215. apiOrderMapper.deleteBatch(ids);
  216. }
  217. @Transactional
  218. public Map submit(JSONObject jsonParam, UserVo loginUser, Long storeId) {
  219. Map resultObj = Maps.newHashMap();
  220. AddressVo addressVo = jsonParam.getObject("checkedAddress", AddressVo.class);
  221. if (addressVo == null) {
  222. resultObj.put("errno", 400);
  223. resultObj.put("errmsg", "地址不能为空");
  224. return resultObj;
  225. }
  226. String formId = jsonParam.getString("formId");
  227. String idNo = jsonParam.getString("idNo");
  228. String userName = jsonParam.getString("userName");
  229. String postscript00 = jsonParam.getString("postscript00");
  230. String postscript02 = jsonParam.getString("postscript02");
  231. String postscript10 = jsonParam.getString("postscript10");
  232. String postscript11 = jsonParam.getString("postscript11");//留言备注
  233. String checkCart = jsonParam.getString("checkCart");//业务区分,11为普通商品,00为保税商品
  234. Integer tickDiscId00 = jsonParam.getInteger("tickDiscId00");//优惠券id
  235. Integer tickDiscId02 = jsonParam.getInteger("tickDiscId02");//优惠券id
  236. Integer tickDiscId10 = jsonParam.getInteger("tickDiscId10");//优惠券id
  237. Integer tickDiscId11 = jsonParam.getInteger("tickDiscId11");//优惠券id
  238. Integer campId00 = jsonParam.getInteger("campId00");//促销id
  239. Integer campId02 = jsonParam.getInteger("campId02");//促销id
  240. Integer campId10 = jsonParam.getInteger("campId10");//促销id
  241. Integer campId11 = jsonParam.getInteger("campId11");//促销id
  242. Integer isLoadStatus = jsonParam.getInteger("isLoadStatus");
  243. Integer number = jsonParam.getInteger("number");
  244. Long goodsId = jsonParam.getLong("goodsId");
  245. UserVo user = apiUserMapper.queryObjectByIdNoAndName(idNo, userName);
  246. UserVo userVo = new UserVo();
  247. userVo.setId(loginUser.getId());
  248. userVo.setIdNo(idNo);
  249. userVo.setUsername(userName);
  250. logger.info("param userId:"+ loginUser.getId());
  251. logger.info("param idNo:"+ userVo.getIdNo());
  252. logger.info("param userName:"+ userVo.getUsername());
  253. if(user != null){
  254. logger.info("query userId:"+ user.getId());
  255. if(loginUser.getId().compareTo(user.getId()) != 0){
  256. logger.info("该身份证信息已被绑定,登陆用户:"+ user.getId()+",查询用户:"+ user.getId());
  257. resultObj.put("errno", 400);
  258. resultObj.put("errmsg", "该身份证信息已被绑定");
  259. return resultObj;
  260. }
  261. }
  262. // 实名认证身份证信息,认证成功更新到用户表
  263. String result = IdCardUtil.checkIdCard(userVo.getIdNo(), userVo.getUsername());
  264. IdCardMsgVo vo = JSON.parseObject(result,IdCardMsgVo.class);
  265. if(vo.getRespCode().equalsIgnoreCase("0000")){
  266. apiUserMapper.update(userVo);
  267. }else{
  268. logger.info(vo.getRespMessage());
  269. resultObj.put("errno", 400);
  270. resultObj.put("errmsg", vo.getRespMessage());
  271. return resultObj;
  272. }
  273. CheckOutDto checkOutDto = new CheckOutDto();
  274. checkOutDto.setCheckCart(checkCart);
  275. //商品id不为空,则提交订单是从商品详情页立即购买过来的
  276. if(goodsId != null){
  277. checkOutDto.setGoodsId(goodsId);
  278. checkOutDto.setNumber(number);
  279. }
  280. checkOutDto.setLoginUser(loginUser);
  281. if(tickDiscId00 != null){
  282. checkOutDto.setTickDiscId00(Long.valueOf(tickDiscId00));
  283. }
  284. if(tickDiscId02 != null){
  285. checkOutDto.setTickDiscId02(Long.valueOf(tickDiscId02));
  286. }
  287. if(tickDiscId10 != null){
  288. checkOutDto.setTickDiscId10(Long.valueOf(tickDiscId10));
  289. }
  290. if(tickDiscId11 != null){
  291. checkOutDto.setTickDiscId11(Long.valueOf(tickDiscId11));
  292. }
  293. if(campId00 != null){
  294. checkOutDto.setCampId00(campId00);
  295. }
  296. if(campId02 != null){
  297. checkOutDto.setCampId02(campId02);
  298. }
  299. if(campId10 != null){
  300. checkOutDto.setCampId10(campId10);
  301. }
  302. if(campId11 != null){
  303. checkOutDto.setCampId11(campId11);
  304. }
  305. checkOutDto.setIsLoadStatus(isLoadStatus);
  306. checkOutDto.setStoreId(storeId);
  307. //获取要购买的商品
  308. Map<String, Object> cartData = cartService.getCartMoney(loginUser, checkOutDto, storeId);
  309. List<CartVo> checkedGoodsList = (List<CartVo>) cartData.get("cartList");
  310. // Map param = Maps.newHashMap();
  311. // param.put("user_id", loginUser.getId());
  312. // param.put("store_id", storeId);
  313. // param.put("checked", 1);
  314. // param.put("checkCart", checkCart);
  315. // List<CartVo> checkedGoodsList = apiCartMapper.queryList(param);
  316. if (null == checkedGoodsList) {
  317. resultObj.put("errno", 400);
  318. resultObj.put("errmsg", "请选择商品");
  319. logger.error("请选择商品");
  320. return resultObj;
  321. }
  322. checkOutDto.setCartData(cartData);
  323. Map<String, Object> cartResultObj = cartService.getCheckOut(checkOutDto);
  324. Boolean isBizType00 = (Boolean) cartResultObj.get("isBizType00");
  325. Boolean isBizType02 = (Boolean) cartResultObj.get("isBizType02");
  326. Boolean isBizType10 = (Boolean) cartResultObj.get("isBizType10");
  327. Boolean isBizType11 = (Boolean) cartResultObj.get("isBizType11");
  328. // 检查库存和更新库存
  329. checkStock(checkedGoodsList, storeId, userName);
  330. List<OrderVo> orderInfoList = new ArrayList();
  331. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  332. //订单按业务类型进行分单
  333. if(isBizType00){
  334. OrderVo order00 = setOrderVo(jsonParam, loginUser, storeId, cartResultObj, Dict.orderBizType.item_00.getItem());
  335. order00.setOrderBizType(Dict.orderBizType.item_00.getItem());
  336. order00.setMerchOrderSn(merchOrderSn);
  337. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript00)) {
  338. order00.setPostscript(postscript00);
  339. }
  340. orderInfoList.add(order00);
  341. }
  342. if(isBizType02){
  343. OrderVo order02 = setOrderVo(jsonParam, loginUser, storeId, cartResultObj, Dict.orderBizType.item_02.getItem());
  344. order02.setOrderBizType(Dict.orderBizType.item_02.getItem());
  345. order02.setMerchOrderSn(merchOrderSn);
  346. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript02)) {
  347. order02.setPostscript(postscript02);
  348. }
  349. orderInfoList.add(order02);
  350. }
  351. if(isBizType10){
  352. OrderVo order10 = setOrderVo(jsonParam, loginUser, storeId, cartResultObj, Dict.orderBizType.item_10.getItem());
  353. order10.setOrderBizType(Dict.orderBizType.item_10.getItem());
  354. order10.setMerchOrderSn(merchOrderSn);
  355. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript10)) {
  356. order10.setPostscript(postscript10);
  357. }
  358. orderInfoList.add(order10);
  359. }
  360. if(isBizType11){
  361. OrderVo order11 = setOrderVo(jsonParam, loginUser, storeId, cartResultObj, Dict.orderBizType.item_11.getItem());
  362. order11.setOrderBizType(Dict.orderBizType.item_11.getItem());
  363. order11.setMerchOrderSn(merchOrderSn);
  364. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript11)) {
  365. order11.setPostscript(postscript11);
  366. }
  367. orderInfoList.add(order11);
  368. }
  369. //开启事务,插入订单信息和订单商品
  370. if(orderInfoList != null && orderInfoList.size() > 0) {
  371. apiOrderMapper.saveBatch(orderInfoList);
  372. List<OrderProcessRecordEntity> processRecordEntityList = new ArrayList<>();
  373. for (OrderVo orderInfo : orderInfoList) {
  374. if (null == orderInfo.getId()) {
  375. logger.error("订单提交失败");
  376. throw new RRException("订单提交失败");
  377. }
  378. //新增订单详情
  379. for (CartVo goodsItem : checkedGoodsList) {
  380. //统计商品总价
  381. if (orderInfo.getOrderBizType().equalsIgnoreCase(goodsItem.getGoodsBizType())) {
  382. GoodsVo goodsVo = apiGoodsMapper.queryObjectByStoreId(goodsItem.getGoods_id(), storeId);
  383. if (goodsVo == null) {
  384. logger.error("订单提交失败:商品不存在");
  385. throw new RRException("订单提交失败:商品不存在");
  386. }
  387. OrderGoodsVo orderGoodsVo = setOrderGoodsVo(orderInfo, cartResultObj, goodsItem, goodsVo);
  388. apiOrderGoodsMapper.save(orderGoodsVo);
  389. //购物车id为空,则提交订单是从商品详情页立即购买过来的
  390. if(goodsItem.getId() == null){
  391. MkStorePromVo mkStorePromVo = apiMkStorePromMapper.queryObjectByGoodsIdAndStoreId(Integer.parseInt(String.valueOf(goodsItem.getGoods_id())),
  392. Integer.parseInt(String.valueOf(storeId)));
  393. if(mkStorePromVo != null){
  394. MkStorePromStatVo statVo = apiMkStorePromStatService.queryObjectByPromId(mkStorePromVo.getPromId());
  395. if(statVo != null){
  396. apiMkStorePromStatService.updateStorePromStat(orderGoodsVo, orderInfo, loginUser, statVo);
  397. }
  398. }
  399. }else {
  400. Integer cartId = Integer.parseInt(String.valueOf(goodsItem.getId()));
  401. //更新渠道追踪统计下单量数据
  402. apiMkStorePromStatService.updateMkStorePromStat(orderGoodsVo, orderInfo, loginUser, cartId);
  403. }
  404. }
  405. }
  406. if(orderInfo.getCoupon_id() != 0 && orderInfo.getCoupon_id()!= null) {
  407. //记录优惠券活动营销统计下单量数据
  408. apiMkStoreTopicStatService.saveTicketTopicStatBySubmitData(orderInfo.getCoupon_id());
  409. }
  410. if(orderInfo.getCampMinusId() != 0 && orderInfo.getCampMinusId()!= null) {
  411. //记录促销满减活动营销统计下单量数据
  412. apiMkStoreTopicStatService.saveCampTopicStatBySubmitData(orderInfo.getActivity_id(), orderInfo.getCampMinusId());
  413. }
  414. OrderProcessRecordEntity entity = new OrderProcessRecordEntity();
  415. entity.setOrderSn(orderInfo.getOrder_sn());
  416. entity.setUserId(Integer.valueOf(loginUser.getId()+""));
  417. entity.setAddOrderStartTime(orderInfo.getAdd_time());
  418. entity.setAddOrderSuccTime(orderInfo.getAdd_time());
  419. entity.setIsAddOrderSend(Dict.isSend.item_1.getItem());
  420. entity.setOrderBizType(orderInfo.getOrderBizType());
  421. processRecordEntityList.add(entity);
  422. }
  423. orderProcessRecordMapper.saveBatch(processRecordEntityList);//新增订单流转信息
  424. //商品id不为空,则提交订单是从商品详情页立即购买过来的
  425. if(goodsId == null) {
  426. //清空已购买的商品
  427. apiCartMapper.deleteByCart(loginUser.getId(), storeId, 1, checkCart);
  428. }
  429. if (apiOrderMapper.queryCountByMerchOrderSn(merchOrderSn) > 1) {//不止一笔订单则为拆单订单
  430. OrderVo orderVo = new OrderVo();
  431. orderVo.setIsMergePay("2");//多笔订单单笔支付
  432. orderVo.setMerchOrderSn(merchOrderSn);
  433. apiOrderMapper.updateOrderByMerchOrderSn(orderVo);
  434. }
  435. resultObj.put("errno", 0);
  436. resultObj.put("errmsg", "订单提交成功");
  437. //
  438. Map orderInfoMap = Maps.newHashMap();
  439. orderInfoMap.put("orderInfo", orderInfoList);
  440. resultObj.put("data", orderInfoMap);
  441. // 优惠券标记已用,或促销满减活动保存已用
  442. for (OrderVo orderInfo : orderInfoList) {
  443. if(orderInfo.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  444. updateCoupon(orderInfo);
  445. saveUserCamp(orderInfo);
  446. }
  447. if(orderInfo.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())){
  448. updateCoupon(orderInfo);
  449. saveUserCamp(orderInfo);
  450. }
  451. if(orderInfo.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_10.getItem())){
  452. updateCoupon(orderInfo);
  453. saveUserCamp(orderInfo);
  454. }
  455. if(orderInfo.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())){
  456. updateCoupon(orderInfo);
  457. saveUserCamp(orderInfo);
  458. }
  459. }
  460. }
  461. return resultObj;
  462. }
  463. /**
  464. * 标记优惠券使用的订单id
  465. * @param orderInfo
  466. */
  467. private void updateCoupon(OrderVo orderInfo){
  468. if (null != orderInfo.getCoupon_id() && 0 != orderInfo.getCoupon_id()) {
  469. UserCouponVo userCouponVo = apiUserCouponMapper.queryObject(orderInfo.getCoupon_id());
  470. //如未使用
  471. if (null != userCouponVo && (null == userCouponVo.getOrderId() || 0 == userCouponVo.getOrderId())) {
  472. userCouponVo.setUsedTime(new Date());
  473. userCouponVo.setOrderId(orderInfo.getId());
  474. userCouponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  475. apiUserCouponMapper.update(userCouponVo);
  476. }
  477. }
  478. }
  479. /**
  480. * 订单提交成功后,新增用户促销满减活动信息为已使用
  481. * @param orderInfo
  482. */
  483. private void saveUserCamp(OrderVo orderInfo){
  484. if (null != orderInfo.getActivity_id() && 0 != orderInfo.getActivity_id()) {
  485. UserCampMinusVo campMinusVo = apiUserCampMinusMapper.queryCampByStoreTopicId(orderInfo.getActivity_id());
  486. //如未使用
  487. if (null == campMinusVo) {
  488. UserCampMinusVo userCampMinusVo = new UserCampMinusVo();
  489. userCampMinusVo.setUsedTime(new Date());
  490. userCampMinusVo.setOrderId(Integer.parseInt(String.valueOf(orderInfo.getId())));
  491. userCampMinusVo.setIsUsed(Dict.isUsed.item_1.getItem());
  492. userCampMinusVo.setStoreTopicId(Integer.parseInt(String.valueOf(orderInfo.getActivity_id())));
  493. userCampMinusVo.setCreateTime(new Date());
  494. userCampMinusVo.setUserId(Integer.parseInt(String.valueOf(orderInfo.getUser_id())));
  495. apiUserCampMinusMapper.save(userCampMinusVo);
  496. }else {
  497. campMinusVo.setUsedTime(new Date());
  498. campMinusVo.setOrderId(Integer.parseInt(String.valueOf(orderInfo.getId())));
  499. campMinusVo.setIsUsed(Dict.isUsed.item_1.getItem());
  500. campMinusVo.setUserId(Integer.parseInt(String.valueOf(orderInfo.getUser_id())));
  501. apiUserCampMinusMapper.update(campMinusVo);
  502. }
  503. }
  504. }
  505. /**
  506. * 扣减商户商品总库存
  507. * @param goodsVo
  508. * @param goodsItem
  509. * @param userName
  510. */
  511. private void updateGoodsStock(GoodsVo goodsVo, CartVo goodsItem,String userName){
  512. goodsVo.setGoods_number(goodsVo.getGoods_number() - goodsItem.getNumber());
  513. goodsVo.setId(goodsVo.getId());
  514. apiGoodsMapper.updateGoodsStock(goodsVo);
  515. // //修改门店商品销量
  516. // productInfo.setSell_volume(productInfo.getSell_volume() + goodsItem.getNumber());
  517. // productInfo.setGoods_id(goodsVo.getId());
  518. // apiProductMapper.updateStockNum(productInfo);
  519. MngChangeVo mngChangeVo = new MngChangeVo();
  520. mngChangeVo.setGoodsId(Integer.parseInt(String.valueOf(goodsVo.getId())));
  521. mngChangeVo.setThirdPartyMerchCode(goodsVo.getThirdPartyMerchCode());
  522. mngChangeVo.setChangeReason("小程序购买商品");
  523. mngChangeVo.setChangeType(Dict.changeType.item_1.getItem());
  524. mngChangeVo.setChangeNum(goodsItem.getNumber());//变化数
  525. mngChangeVo.setOriginalNum(goodsVo.getGoods_number());//原库存数
  526. mngChangeVo.setValidNum(goodsVo.getGoods_number() - goodsItem.getNumber());//可用数
  527. mngChangeVo.setCreateTime(new Date());
  528. mngChangeVo.setModTime(new Date());
  529. mngChangeVo.setCreaterSn("小程序用户"+userName);
  530. mngChangeVo.setModerSn("小程序用户"+userName);
  531. mngChangeVo.setIsValid(0);
  532. mngChangeVo.setMerchSn(goodsVo.getMerchSn());
  533. apiMngChangeMapper.save(mngChangeVo);
  534. }
  535. /**
  536. * 扣减商户门店商品库存
  537. * @param productInfo
  538. * @param goodsVo
  539. * @param stockNum
  540. * @param goodsItem
  541. * @param storeId
  542. * @param userName
  543. */
  544. private void updateStock(ProductVo productInfo,GoodsVo goodsVo,Integer stockNum,CartVo goodsItem,Long storeId,String userName){
  545. //修改门店商品库存
  546. productInfo.setStock_num(stockNum - goodsItem.getNumber());
  547. productInfo.setStore_id(storeId);
  548. //修改门店商品销量
  549. productInfo.setSell_volume(productInfo.getSell_volume() + goodsItem.getNumber());
  550. productInfo.setGoods_id(goodsVo.getId());
  551. // productVos.add(productInfo);
  552. apiProductMapper.updateStockNum(productInfo);
  553. StoreMngChangeVo storeMngChangeVo = new StoreMngChangeVo();
  554. storeMngChangeVo.setChangeType(Dict.changeType.item_1.getItem());
  555. storeMngChangeVo.setChangeReason("小程序购买商品");
  556. storeMngChangeVo.setGoodsId(Integer.parseInt(String.valueOf(goodsVo.getId())));
  557. storeMngChangeVo.setStoreId(Integer.parseInt(String.valueOf(storeId)));
  558. storeMngChangeVo.setMerchSn(goodsVo.getMerchSn());
  559. storeMngChangeVo.setStoreChangeNum(goodsItem.getNumber());
  560. storeMngChangeVo.setStoreOriginalNum(stockNum);
  561. storeMngChangeVo.setStoreValidNum(stockNum - goodsItem.getNumber());
  562. storeMngChangeVo.setCreateTime(new Date());
  563. storeMngChangeVo.setModTime(new Date());
  564. storeMngChangeVo.setCreaterSn("小程序用户"+userName);
  565. storeMngChangeVo.setModerSn("小程序用户"+userName);
  566. storeMngChangeVo.setIsValid(0);
  567. apiStoreMngChangeMapper.save(storeMngChangeVo);
  568. }
  569. /**
  570. * 检查库存和更新库存
  571. * @param checkedGoodsList
  572. * @param storeId
  573. * @param userName
  574. */
  575. private void checkStock(List<CartVo> checkedGoodsList,Long storeId,String userName){
  576. for (CartVo goodsItem : checkedGoodsList) {
  577. Integer stockNum = 0;
  578. //取得规格的信息,判断规格库存
  579. GoodsVo goodsInfo = apiGoodsMapper.queryObjectByStoreId(goodsItem.getGoods_id(), storeId);
  580. if (null == goodsInfo || goodsInfo.getIs_delete() == 1 || goodsInfo.getIs_on_sale() == 0) {
  581. logger.error("订单提交失败:商品不存在");
  582. throw new RRException("订单提交失败:商品不存在");
  583. }
  584. ProductVo productInfo = apiProductMapper.queryByStoreId(goodsItem.getProduct_id(), storeId);
  585. synchronized (productInfo){
  586. if (null == productInfo) {
  587. logger.error("订单提交失败:商品已下架");
  588. throw new RRException("订单提交失败:商品已下架");
  589. }
  590. // String isStockShare = StockUtil.getIsStockShareByGoodsVo(goodsInfo);
  591. // TODO: 2019/3/5 普通商品不受共享库存影响,直接取门店配置库存
  592. stockNum = StockUtil.setStockNumByGoodsVo(goodsInfo);
  593. /*if(goodsInfo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  594. if (goodsInfo.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_1.getItem())) {
  595. stockNum = goodsInfo.getGoods_number();
  596. }
  597. if (goodsInfo.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_0.getItem())) {
  598. stockNum = productInfo.getStock_num();
  599. }
  600. }else {
  601. stockNum = productInfo.getStock_num();
  602. }*/
  603. if (null == stockNum || stockNum < goodsItem.getNumber() || stockNum <= 0) {
  604. logger.error("订单提交失败:库存不足,仅剩余" + stockNum);
  605. throw new RRException("订单提交失败:库存不足,仅剩余" + stockNum);
  606. }else{
  607. productInfo.setStore_id(storeId);
  608. //扣减商户商品总库存
  609. updateGoodsStock(goodsInfo, goodsItem, userName);
  610. //扣减门店库存
  611. updateStock(productInfo,goodsInfo,stockNum,goodsItem,storeId,userName);
  612. }
  613. }
  614. }
  615. }
  616. /**
  617. * 设置订单数据
  618. * @param jsonParam
  619. * @param loginUser
  620. * @param storeId
  621. * @param cartResultObj
  622. * @param bizType
  623. * @return
  624. */
  625. public OrderVo setOrderVo(JSONObject jsonParam, UserVo loginUser, Long storeId, Map<String, Object> cartResultObj, String bizType){
  626. OrderVo orderInfo = new OrderVo();
  627. Integer tickDiscId = 0;
  628. Integer campId = 0;
  629. Long couponId = 0L;
  630. Long storeTopicId = 0L;
  631. String campName = "";
  632. BigDecimal fullCutCouponDec = Constant.ZERO;
  633. BigDecimal cond = Constant.ZERO;
  634. BigDecimal money = Constant.ZERO;
  635. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  636. BigDecimal freightPrice = Constant.ZERO;
  637. //实付金额:商品销售价*数量-优惠金额+运费的总和
  638. BigDecimal actualPrice = new BigDecimal(0.00);
  639. CampMinusDto campMinusDto = new CampMinusDto();
  640. Integer tickDiscId00 = jsonParam.getInteger("tickDiscId00");//优惠券id
  641. Integer tickDiscId02 = jsonParam.getInteger("tickDiscId02");//优惠券id
  642. Integer tickDiscId10 = jsonParam.getInteger("tickDiscId10");//优惠券id
  643. Integer tickDiscId11 = jsonParam.getInteger("tickDiscId11");//优惠券id
  644. Integer campId00 = jsonParam.getInteger("campId00");//促销满减id
  645. Integer campId02 = jsonParam.getInteger("campId02");//促销满减id
  646. Integer campId10 = jsonParam.getInteger("campId10");//促销满减id
  647. Integer campId11 = jsonParam.getInteger("campId11");//促销满减id
  648. CampMinusDto campMinusDto00 = (CampMinusDto)cartResultObj.get("campMinusDto00");
  649. CampMinusDto campMinusDto02 = (CampMinusDto)cartResultObj.get("campMinusDto02");
  650. CampMinusDto campMinusDto10 = (CampMinusDto)cartResultObj.get("campMinusDto10");
  651. CampMinusDto campMinusDto11 = (CampMinusDto)cartResultObj.get("campMinusDto11");
  652. String postscript = jsonParam.getString("postscript");
  653. AddressVo addressVo = jsonParam.getObject("checkedAddress", AddressVo.class);
  654. Date delivery_date = jsonParam.getDate("delivery_date");
  655. String merchSn = (String)jsonParam.get("merchSn");
  656. String delivery_remark = jsonParam.getString("delivery_remark");
  657. BigDecimal freightPrice00 = MapUtils.getBigDecimal("freightPrice00", cartResultObj);
  658. BigDecimal freightPrice02 = MapUtils.getBigDecimal("freightPrice02", cartResultObj);
  659. BigDecimal freightPrice10 = MapUtils.getBigDecimal("freightPrice10", cartResultObj);
  660. BigDecimal freightPrice11 = MapUtils.getBigDecimal("freightPrice11", cartResultObj);
  661. BigDecimal goodsTotalPrice00 = MapUtils.getBigDecimal("goodsTotalPrice00", cartResultObj);
  662. BigDecimal goodsTotalPrice02 = MapUtils.getBigDecimal("goodsTotalPrice02", cartResultObj);
  663. BigDecimal goodsTotalPrice10 = MapUtils.getBigDecimal("goodsTotalPrice10", cartResultObj);
  664. BigDecimal goodsTotalPrice11 = MapUtils.getBigDecimal("goodsTotalPrice11", cartResultObj);
  665. //实付金额:商品销售价*数量-优惠金额+运费的总和
  666. BigDecimal actualPrice00 = MapUtils.getBigDecimal("actualPrice00", cartResultObj);
  667. BigDecimal actualPrice02 = MapUtils.getBigDecimal("actualPrice02", cartResultObj);
  668. BigDecimal actualPrice10 = MapUtils.getBigDecimal("actualPrice10", cartResultObj);
  669. BigDecimal actualPrice11 = MapUtils.getBigDecimal("actualPrice11", cartResultObj);
  670. if(bizType.equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  671. tickDiscId = tickDiscId00;
  672. freightPrice = freightPrice00;
  673. goodsTotalPrice = goodsTotalPrice00;
  674. actualPrice = actualPrice00;
  675. campId = campId00;
  676. campMinusDto = campMinusDto00;
  677. }
  678. if(bizType.equalsIgnoreCase(Dict.orderBizType.item_02.getItem())){
  679. tickDiscId = tickDiscId02;
  680. freightPrice = freightPrice02;
  681. goodsTotalPrice = goodsTotalPrice02;
  682. actualPrice = actualPrice02;
  683. campId = campId02;
  684. campMinusDto = campMinusDto02;
  685. }
  686. if(bizType.equalsIgnoreCase(Dict.orderBizType.item_10.getItem())){
  687. tickDiscId = tickDiscId10;
  688. freightPrice = freightPrice10;
  689. goodsTotalPrice = goodsTotalPrice10;
  690. actualPrice = actualPrice10;
  691. campId = campId10;
  692. campMinusDto = campMinusDto10;
  693. }
  694. if(bizType.equalsIgnoreCase(Dict.orderBizType.item_11.getItem())){
  695. tickDiscId = tickDiscId11;
  696. freightPrice = freightPrice11;
  697. goodsTotalPrice = goodsTotalPrice11;
  698. actualPrice = actualPrice11;
  699. campId = campId11;
  700. campMinusDto = campMinusDto11;
  701. }
  702. // goodsTotalPrice = MapUtils.getBigDecimal("goodsTotalPrice", cartResultObj);//整个订单商品总价,不包含运费和优惠金额
  703. MkStoreTicketDiscountVo mkStoreTicketDiscountVo = null;
  704. if (null != tickDiscId && 0 != tickDiscId && campId == 0) {
  705. //校验该订单所选的优惠券
  706. mkStoreTicketDiscountVo = apiMkStoreTicketDiscountMapper.queryObject(tickDiscId);
  707. if(mkStoreTicketDiscountVo != null) {
  708. if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_00.getItem())) {
  709. cond = mkStoreTicketDiscountVo.getVoucherCond();
  710. money = mkStoreTicketDiscountVo.getVoucherMoney();
  711. }
  712. if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_01.getItem())) {
  713. cond = mkStoreTicketDiscountVo.getDiscCond();
  714. money = mkStoreTicketDiscountVo.getDiscRatio();//满多少打几折
  715. }
  716. // TODO: 2019/5/21 代金券暂时无用
  717. /*if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_02.getItem())) {
  718. cond = mkStoreTicketDiscountVo.getExchCond();
  719. money = mkStoreTicketDiscountVo.getExchCond();
  720. }*/
  721. }
  722. }
  723. String couponName = "";
  724. UserCouponVo couponVo = null;
  725. //扣减金额
  726. BigDecimal couponPrice = new BigDecimal(0.00);
  727. if (null != tickDiscId && 0 != tickDiscId && campId == 0) {
  728. //查询未使用且未过期的优惠券
  729. List<UserCouponVo> couponVoList = apiUserCouponMapper.queryObjectByIdAndUsed(tickDiscId, loginUser.getId());
  730. if(couponVoList!= null && couponVoList.size() > 0){
  731. couponVo = couponVoList.get(0);
  732. }
  733. if (null != couponVo && null != couponVo.getTypeMoney()) {
  734. //判断不同业务的订单总金额是否满足优惠条件,满足则标记该订单已使用优惠券
  735. if(goodsTotalPrice.compareTo(cond) >= 0){
  736. //标记该订单已使用优惠券
  737. if(couponVo != null){
  738. couponVo.setUsedTime(new Date());
  739. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  740. apiUserCouponMapper.update(couponVo);
  741. if(mkStoreTicketDiscountVo != null) {
  742. if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_00.getItem())) {
  743. couponPrice = money;
  744. }
  745. if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_01.getItem())) { //折扣
  746. //商品销售价 - 扣减优惠折扣金额后的实付金额 = 订单优惠金额
  747. couponPrice = goodsTotalPrice.subtract(actualPrice);
  748. }
  749. // TODO: 2019/5/21 代金券暂时无用
  750. /*if (mkStoreTicketDiscountVo.getTickDiscType().equalsIgnoreCase(Dict.tickDiscType.item_02.getItem())) {
  751. cond = mkStoreTicketDiscountVo.getExchCond();
  752. money = mkStoreTicketDiscountVo.getExchCond();
  753. }*/
  754. }
  755. couponId = couponVo.getId();
  756. couponName = couponVo.getCouponName();
  757. Map map = apiUserCouponMapper.queryStoreTopicByDictId(tickDiscId);
  758. storeTopicId = MapUtils.getLong("storeTopicId", map);
  759. }
  760. }else{
  761. couponId = 0L;
  762. storeTopicId = 0L;
  763. }
  764. }
  765. }
  766. MkStoreCampMinusVo mkStoreCampMinusVo = null;
  767. if(null != campId && 0 != campId){
  768. mkStoreCampMinusVo = apiMkStoreCampMinusMapper.queryObject(campId);
  769. if(mkStoreCampMinusVo != null) {
  770. storeTopicId = Long.valueOf(mkStoreCampMinusVo.getStoreTopicId());
  771. campName = mkStoreCampMinusVo.getCampName();
  772. if (mkStoreCampMinusVo.getCampMinusType().equalsIgnoreCase(Dict.campMinusType.item_00.getItem()) || mkStoreCampMinusVo.getCampMinusType().equalsIgnoreCase(Dict.campMinusType.item_01.getItem())) {
  773. fullCutCouponDec = campMinusDto.getMoney();
  774. }
  775. if (mkStoreCampMinusVo.getCampMinusType().equalsIgnoreCase(Dict.campMinusType.item_10.getItem()) || mkStoreCampMinusVo.getCampMinusType().equalsIgnoreCase(Dict.campMinusType.item_11.getItem())) {
  776. //商品销售价 - 扣减优惠折扣金额后的实付金额 = 订单优惠金额
  777. fullCutCouponDec = goodsTotalPrice.subtract(actualPrice);
  778. }
  779. }
  780. }
  781. if (null == delivery_date) {
  782. delivery_date = new Date();
  783. }
  784. if (StringUtils.isNullOrEmpty(delivery_remark)) {
  785. delivery_remark = "尽快送达";
  786. }
  787. //订单价格计算:订单的总价+运费
  788. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  789. // BigDecimal orderTotalPrice = MapUtils.getBigDecimal("orderTotalPrice", cartResultObj);
  790. // actualPrice = cartService.mathActualPrice(couponVo, actualPrice);
  791. // BigDecimal actualPrice = orderTotalPrice.subtract(fullCutCouponDec).subtract(couponPrice);
  792. String thirdMerchSn = "";
  793. StoreVo storeVo = apiStoreMapper.queryObject(storeId);
  794. if(storeVo != null){
  795. thirdMerchSn = storeVo.getThirdPartyMerchCode()==null?"":storeVo.getThirdPartyMerchCode();
  796. }
  797. //一级商户 + 三级商户(拼音首字母) + 业务类型 + 编号
  798. String orderSn = "ZW" + thirdMerchSn + bizType + CommonUtil.generateOrderNumber();
  799. orderInfo.setOrder_sn(orderSn);
  800. orderInfo.setMerchSn(merchSn);
  801. orderInfo.setUser_id(loginUser.getId());
  802. //收货地址和运费
  803. orderInfo.setConsignee(addressVo.getUserName());
  804. orderInfo.setMobile(addressVo.getTelNumber());
  805. orderInfo.setCountry(addressVo.getNationalCode());
  806. orderInfo.setProvince(addressVo.getProvinceName());
  807. orderInfo.setCity(addressVo.getCityName());
  808. orderInfo.setDistrict(addressVo.getCountyName());
  809. orderInfo.setAddress(addressVo.getDetailInfo());
  810. orderInfo.setAddress_id(addressVo.getId());
  811. orderInfo.setDelivery_date(delivery_date);
  812. orderInfo.setDelivery_remark(delivery_remark);
  813. orderInfo.setStore_id(storeId);
  814. orderInfo.setFreight_price(freightPrice.intValue());
  815. orderInfo.setCoupon_id(Integer.parseInt(String.valueOf(couponId)));
  816. orderInfo.setCoupon_price(couponPrice);
  817. orderInfo.setCoupon_name(couponName);
  818. orderInfo.setActivity_id(storeTopicId);
  819. //使用的促销费用
  820. orderInfo.setFull_cut_price(fullCutCouponDec);
  821. orderInfo.setCampMinusId(campId);
  822. orderInfo.setCampName(campName);
  823. //留言
  824. orderInfo.setPostscript(postscript);
  825. orderInfo.setAdd_time(new Date());
  826. orderInfo.setGoods_price(goodsTotalPrice);
  827. orderInfo.setOrder_price(orderTotalPrice);
  828. orderInfo.setActual_price(actualPrice);
  829. orderInfo.setOrder_type("1");
  830. // 待付款
  831. orderInfo.setOrder_status(0);
  832. orderInfo.setShipping_status(0);
  833. orderInfo.setPay_status(0);
  834. orderInfo.setShipping_id(0L);
  835. orderInfo.setShipping_fee(Constant.ZERO);
  836. orderInfo.setIntegral(0);
  837. orderInfo.setIntegral_money(Constant.ZERO);
  838. orderInfo.setCreateTime(new Date());
  839. orderInfo.setModTime(new Date());
  840. orderInfo.setPayMobile(loginUser.getMobile());
  841. orderInfo.setPayTransactionId("");
  842. orderInfo.setIsScan("0");//默认未扫描
  843. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  844. orderInfo.setPayMobile(userVo.getMobile());
  845. orderInfo.setPay_name(userVo.getUsername());
  846. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_0.getItem());
  847. return orderInfo;
  848. }
  849. public OrderGoodsVo setOrderGoodsVo(OrderVo orderInfo,Map<String, Object> cartResultObj,CartVo goodsItem,GoodsVo goodsVo){
  850. OrderGoodsVo orderGoodsVo = new OrderGoodsVo();
  851. orderGoodsVo.setOrder_id(orderInfo.getId());
  852. orderGoodsVo.setGoods_id(goodsItem.getGoods_id());
  853. orderGoodsVo.setGoods_sn(goodsItem.getGoods_sn());
  854. orderGoodsVo.setProduct_id(goodsItem.getProduct_id());
  855. orderGoodsVo.setGoods_name(goodsItem.getGoods_name());
  856. orderGoodsVo.setList_pic_url(goodsItem.getList_pic_url());
  857. orderGoodsVo.setMarket_price(goodsItem.getMarket_price());
  858. orderGoodsVo.setRetail_price(goodsItem.getRetail_price());
  859. orderGoodsVo.setNumber(goodsItem.getNumber());
  860. orderGoodsVo.setGoods_specification_name_value(goodsItem.getGoods_specification_name_value());
  861. orderGoodsVo.setGoods_specification_ids(goodsItem.getGoods_specification_ids());
  862. orderGoodsVo.setOrderBizType(goodsItem.getGoodsBizType());
  863. orderGoodsVo.setCreateTime(new Date());
  864. orderGoodsVo.setModTime(new Date());
  865. CampMinusDto campMinusDto = new CampMinusDto();
  866. UserCouponVo userCouponVo = new UserCouponVo();
  867. CampMinusDto campMinusDto00 = (CampMinusDto)cartResultObj.get("campMinusDto00");
  868. CampMinusDto campMinusDto02 = (CampMinusDto)cartResultObj.get("campMinusDto02");
  869. CampMinusDto campMinusDto10 = (CampMinusDto)cartResultObj.get("campMinusDto10");
  870. CampMinusDto campMinusDto11 = (CampMinusDto)cartResultObj.get("campMinusDto11");
  871. UserCouponVo checkedCoupon00 = (UserCouponVo)cartResultObj.get("checkedCoupon00");
  872. UserCouponVo checkedCoupon02 = (UserCouponVo)cartResultObj.get("checkedCoupon02");
  873. UserCouponVo checkedCoupon10 = (UserCouponVo)cartResultObj.get("checkedCoupon10");
  874. UserCouponVo checkedCoupon11 = (UserCouponVo)cartResultObj.get("checkedCoupon11");
  875. if(goodsVo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  876. if(campMinusDto00 != null){
  877. campMinusDto = campMinusDto00;
  878. userCouponVo = checkedCoupon00;
  879. }
  880. }
  881. if(goodsVo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())){
  882. if(campMinusDto02 != null){
  883. campMinusDto = campMinusDto02;
  884. userCouponVo = checkedCoupon02;
  885. }
  886. }
  887. if(goodsVo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_10.getItem())){
  888. if(campMinusDto10 != null){
  889. campMinusDto = campMinusDto10;
  890. userCouponVo = checkedCoupon10;
  891. }
  892. }
  893. if(goodsVo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())){
  894. if(campMinusDto11 != null){
  895. campMinusDto = campMinusDto11;
  896. userCouponVo = checkedCoupon11;
  897. }
  898. }
  899. if(campMinusDto != null){
  900. List<Integer> goodsList = campMinusDto.getGoodsIds();
  901. if(goodsList != null) {
  902. for (Integer goodsId : goodsList) {
  903. if (goodsId == Integer.parseInt(String.valueOf(goodsVo.getId()))) {
  904. orderGoodsVo.setStoreTopicId(Integer.parseInt(String.valueOf(orderInfo.getActivity_id())));
  905. }
  906. }
  907. }
  908. }
  909. if(userCouponVo != null){
  910. List<Integer> goodsList = userCouponVo.getGoodsList();
  911. if(goodsList != null) {
  912. for (Integer goodsId : goodsList) {
  913. if (goodsId == Integer.parseInt(String.valueOf(goodsVo.getId()))) {
  914. orderGoodsVo.setStoreTopicId(Integer.parseInt(String.valueOf(orderInfo.getActivity_id())));
  915. }
  916. }
  917. }
  918. }
  919. orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  920. BigDecimal number = new BigDecimal(Long.valueOf(goodsItem.getNumber()));
  921. BigDecimal goodsTotal = goodsItem.getRetail_price().multiply(number);//单商品总价
  922. BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(),2, BigDecimal.ROUND_HALF_UP);//单商品总价/订单总价(不含运费、不含优惠券)
  923. BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  924. BigDecimal settlePrice = Constant.ZERO;
  925. if(orderInfo.getFreight_price() != 0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  926. //运费-优惠券
  927. BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  928. //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 单商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  929. settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  930. }else{
  931. if(orderInfo.getFreight_price()!=0){
  932. //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  933. BigDecimal freightRate = rate.multiply(freightPrice);
  934. //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  935. settlePrice = goodsTotal.add(freightRate);
  936. }
  937. if(!"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  938. //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  939. BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  940. //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  941. settlePrice = goodsTotal.subtract(couponRate);
  942. }
  943. }
  944. if(settlePrice.compareTo(BigDecimal.valueOf(0)) == 0){
  945. orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  946. }else{
  947. orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  948. }
  949. orderGoodsVo.setSku(goodsVo.getSku());
  950. return orderGoodsVo;
  951. }
  952. /**
  953. * 支付成功通知
  954. */
  955. @Transactional
  956. public void notifyPaySuccess(OrderVo orderInfo) {
  957. WxTemplate tem = new WxTemplate();
  958. FormIdsEntity formIdsEntity = formIdsService.getFormIdsByMerchOrderSn(orderInfo.getMerchOrderSn());
  959. if (null == formIdsEntity || !StringUtils.isNotEmpty(formIdsEntity.getFormId())) {
  960. return;
  961. }
  962. if (orderInfo.getOrder_type().equals("1")) { // 订单类型 1:普通订单 2:团购订单
  963. TemplateConfVo templateConfVo = apiTemplateConfMapper.queryByTypeId(1); // 模板类型 1订单付款成功 2团购成功 3拼团失败通知 4拼团进度 5 6 7订单配送 8订单评价提醒
  964. if (null == templateConfVo) {
  965. return;
  966. }
  967. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  968. tem.setTemplate_id(templateConfVo.getTemplateId());
  969. // tem.setTopcolor("#00DD00");
  970. tem.setTouser(userVo.getWeixin_openid());
  971. tem.setPage("/pages/ucenter/orderDetail/orderDetail?id=" + orderInfo.getId());
  972. tem.setForm_id(formIdsEntity.getFormId());
  973. List<TemplateData> paras = new ArrayList<TemplateData>();
  974. paras.add(new TemplateData("first", templateConfVo.getDesc(), "#000000"));
  975. paras.add(new TemplateData("keyword1", orderInfo.getMerchOrderSn(), "#000000"));
  976. //订单的商品
  977. Map orderGoodsParam = Maps.newHashMap();
  978. orderGoodsParam.put("order_id", orderInfo.getId());
  979. List<OrderGoodsVo> orderGoods = apiOrderGoodsMapper.queryList(orderGoodsParam);
  980. String body = "";
  981. if (null != orderGoods) {
  982. for (OrderGoodsVo goodsVo : orderGoods) {
  983. body = body + goodsVo.getGoods_name() + "、";
  984. }
  985. if (body.length() > 0) {
  986. body = body.substring(0, body.length() - 1);
  987. }
  988. }
  989. paras.add(new TemplateData("keyword2", body, "#000000"));
  990. paras.add(new TemplateData("keyword3", orderInfo.getActual_price().setScale(2, BigDecimal.ROUND_HALF_DOWN).toString(), "#000000"));
  991. paras.add(new TemplateData("keyword4", DateUtils.format(orderInfo.getAdd_time(), DateUtils.DATE_TIME_PATTERN), "#000000"));
  992. tem.setData(paras);
  993. }
  994. // TODO: 2018/10/25 暂时不实现团购订单
  995. /*if (orderInfo.getOrder_type().equals("2")) { // 订单类型 1:普通订单 2:团购订单
  996. TemplateConfVo templateConfVo = apiTemplateConfMapper.queryByTypeId(2); // 模板类型 1订单付款成功 2团购成功 3拼团失败通知 4拼团进度 5 6 7订单配送 8订单评价提醒
  997. if (null == templateConfVo) {
  998. return;
  999. }
  1000. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  1001. // 团购明细
  1002. GoodsGroupOpenDetailVo openDetailVo = apiGoodsGroupOpenDetailMapper.queryObject(orderInfo.getActivity_id());
  1003. // 获取团购
  1004. GoodsGroupOpenVo groupOpenVo = apiGoodsGroupOpenMapper.queryObject(openDetailVo.getOpen_id());
  1005. tem.setTemplate_id(templateConfVo.getTemplateId());
  1006. tem.setTopcolor("#00DD00");
  1007. tem.setTouser(userVo.getWeixin_openid());
  1008. tem.setPage("/pages/ucenter/orderDetail/orderDetail?id=" + orderInfo.getId());
  1009. tem.setForm_id(formIdsEntity.getFormId());
  1010. List<TemplateData> paras = new ArrayList<TemplateData>();
  1011. paras.add(new TemplateData("keyword1", groupOpenVo.getTitle(), "#000000"));
  1012. paras.add(new TemplateData("keyword2", DateUtils.format(groupOpenVo.getOpen_time(), DateUtils.DATE_TIME_PATTERN), "#000000"));
  1013. //订单的商品
  1014. Map orderGoodsParam = Maps.newHashMap();
  1015. orderGoodsParam.put("order_id", orderInfo.getId());
  1016. List<OrderGoodsVo> orderGoods = apiOrderGoodsMapper.queryList(orderGoodsParam);
  1017. String body = "";
  1018. if (null != orderGoods) {
  1019. for (OrderGoodsVo goodsVo : orderGoods) {
  1020. body = body + goodsVo.getGoods_name() + "、";
  1021. }
  1022. if (body.length() > 0) {
  1023. body = body.substring(0, body.length() - 1);
  1024. }
  1025. }
  1026. paras.add(new TemplateData("keyword3", body, "#000000"));
  1027. // 团成员
  1028. Map groupParam = Maps.newHashMap();
  1029. groupParam.put("open_id", orderInfo.getActivity_id());
  1030. List<GoodsGroupOpenDetailVo> openDetailVos = apiGoodsGroupOpenDetailMapper.queryList(groupParam);
  1031. String attendMember = "";
  1032. if (null != openDetailVos) {
  1033. for (GoodsGroupOpenDetailVo detailVo : openDetailVos) {
  1034. attendMember = attendMember + detailVo.getNickname() + "、";
  1035. }
  1036. if (attendMember.length() > 0) {
  1037. attendMember = attendMember.substring(0, attendMember.length() - 1);
  1038. }
  1039. }
  1040. paras.add(new TemplateData("keyword4", attendMember, "#000000"));
  1041. paras.add(new TemplateData("keyword5", orderInfo.getActual_price().setScale(2, BigDecimal.ROUND_HALF_DOWN).toString(), "#000000"));
  1042. paras.add(new TemplateData("keyword5", templateConfVo.getDesc(), "#000000"));
  1043. tem.setData(paras);
  1044. }*/
  1045. try {
  1046. // WxTemplateUtil.sendMessage(tem);
  1047. formIdsService.releaseFormIds(formIdsEntity);
  1048. } catch (Exception e) {
  1049. e.printStackTrace();
  1050. }
  1051. }
  1052. /**
  1053. * 确认收货
  1054. *
  1055. * @param orderId
  1056. */
  1057. @Transactional
  1058. public void confirmOrder(Long orderId) {
  1059. OrderVo orderVo = apiOrderMapper.queryObject(orderId);
  1060. orderVo.setOrder_status(301);
  1061. orderVo.setShipping_status(2);
  1062. orderVo.setConfirm_time(new Date());
  1063. orderVo.setModTime(new Date());
  1064. apiOrderMapper.update(orderVo);
  1065. }
  1066. /*public String printMsgs(Long orderId) {
  1067. OrderVo orderEntity = queryObject(orderId);
  1068. Map<String, Object> map = new HashMap<String, Object>();
  1069. map.put("order_id", orderEntity.getId());
  1070. List<OrderGoodsVo> orderGoodsEntities = apiOrderGoodsMapper.queryList(map);
  1071. UserVo userVo = apiUserMapper.queryObject(orderEntity.getUser_id());
  1072. String content = "<CB>商城超市</CB><BR>";
  1073. content += "名称/商品编码 单价 数量 金额<BR>";
  1074. for (OrderGoodsVo orderGoodsEntity : orderGoodsEntities) {
  1075. content += "--------------------------------<BR>";
  1076. content += orderGoodsEntity.getGoods_name() + "<BR>" + orderGoodsEntity.getGoods_sn() + " " + orderGoodsEntity.getRetail_price() + " " + orderGoodsEntity.getNumber()
  1077. + " " + orderGoodsEntity.getRetail_price().multiply(new BigDecimal(orderGoodsEntity.getNumber())) + "<BR>";
  1078. }
  1079. content += "--------------------------------<BR>";
  1080. content += "备注:" + orderEntity.getPostscript() + "<BR>";
  1081. content += "--------------------------------<BR>";
  1082. content += "订单编号:" + orderEntity.getOrder_sn() + "<BR>";
  1083. content += "配送配用:" + orderEntity.getShipping_fee() + "元<BR>";
  1084. content += "优惠价格:" + orderEntity.getCoupon_price() + "元<BR>";
  1085. content += "合计:" + orderEntity.getOrder_price() + "元<BR>";
  1086. content += "实付:" + orderEntity.getActual_price() + "元<BR>";
  1087. content += "姓名:" + null != userVo.getNickname() ? userVo.getNickname() : "" + "<BR>";
  1088. content += "送货地点:" + orderEntity.getProvince() + orderEntity.getCity() + orderEntity.getDistrict() + orderEntity.getAddress() + "<BR>";
  1089. content += "联系电话:" + orderEntity.getMobile() + "<BR>";
  1090. content += "付款时间:" + DateUtils.format(orderEntity.getPay_time(), DateUtils.DATE_TIME_PATTERN) + "<BR>";
  1091. content += "<QR>" + orderEntity.getId() + "</QR>";
  1092. if ("2".equals(orderEntity.getOrder_type())) {
  1093. content += "<RIGHT><BOLD>【团购】</BOLD></RIGHT>";
  1094. }
  1095. //所属门店
  1096. Long storeId = orderEntity.getStore_id();
  1097. //获取门店的打印机编号,每个门店只有一个打票机
  1098. Map<String, Object> printParams = new HashMap<String, Object>();
  1099. List<SysPrinterVo> printerEntities = apiSysPrinterMapper.queryList(printParams);
  1100. printParams.put("storeId", storeId);
  1101. String sn = "";
  1102. if (printerEntities != null && printerEntities.size() != 0) {
  1103. sn = printerEntities.get(0).getSn();
  1104. }
  1105. return FeiGeUtils.printMsg(sn, content, "1");
  1106. }*/
  1107. public Ticket printMsg(Long orderId) {
  1108. OrderVo orderEntity = queryObject(orderId);
  1109. if(orderEntity != null) {
  1110. if (orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_10.getItem())
  1111. || orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())) {
  1112. Map<String, Object> map = new HashMap<String, Object>();
  1113. map.put("order_id", orderEntity.getId());
  1114. List<OrderGoodsVo> orderGoodsEntityList = apiOrderGoodsMapper.queryList(map);
  1115. // 获取门店
  1116. StoreVo storeEntity = apiStoreMapper.queryObject(orderEntity.getStore_id());
  1117. // 获取清关信息
  1118. OrderProcessRecordEntity orderProcessRecordEntity = orderProcessRecordMapper.queryObjectByOrderSn(orderEntity.getOrder_sn());
  1119. UserVo userVo = apiUserMapper.queryObject(orderEntity.getUser_id());
  1120. // 小票头
  1121. TicketHead head = new TicketHead();
  1122. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  1123. head.setMemberId(userVo.getUsername().toString());
  1124. head.setOrderId(orderEntity.getOrder_sn());
  1125. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  1126. // 商品信息
  1127. Integer goodsTotal = 0; // 商品总个数
  1128. BigDecimal total = Constant.ZERO; // 商品总计
  1129. List<Goods> goodsList = new ArrayList<>();
  1130. for (OrderGoodsVo orderGoods : orderGoodsEntityList) {
  1131. goodsTotal += orderGoods.getNumber();
  1132. total = total.add(orderGoods.getRetail_price().subtract(new BigDecimal(orderGoods.getNumber()))).setScale(2, BigDecimal.ROUND_HALF_UP);
  1133. Goods goods = new Goods(orderGoods.getGoods_name(), orderGoods.getRetail_price().toString(), orderGoods.getNumber().toString()
  1134. ,orderGoods.getRetail_price().multiply(new BigDecimal(orderGoods.getNumber())).setScale(2,BigDecimal.ROUND_HALF_UP).toString());
  1135. goodsList.add(goods);
  1136. }
  1137. // 收银信息
  1138. CashInfo cashInfo = new CashInfo();
  1139. cashInfo.setGoodsTotal(goodsTotal.toString());
  1140. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  1141. cashInfo.setReceipts(orderEntity.getActual_price().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  1142. cashInfo.setOddChange("0.00");
  1143. cashInfo.setCoupon(orderEntity.getCoupon_price().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  1144. cashInfo.setFreight(new BigDecimal(orderEntity.getFreight_price()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  1145. cashInfo.setPaymentMode("微信支付");
  1146. // 海关清单
  1147. CusListing cusListing = new CusListing();
  1148. cusListing.setOrderId(orderEntity.getOrder_sn());
  1149. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  1150. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  1151. cusListing.setConsignee(orderEntity.getConsignee());
  1152. cusListing.setConsigneeTel(orderEntity.getMobile());
  1153. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  1154. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  1155. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  1156. }else{
  1157. return null;
  1158. }
  1159. }else{
  1160. return null;
  1161. }
  1162. }
  1163. public List<OrderVo> queryObjectByIdList(List<Long> orderIdList){
  1164. return apiOrderMapper.queryObjectByIdList(orderIdList);
  1165. }
  1166. public List<OrderVo> queryObjectByMerchOrderSn(String merchOrderSn){
  1167. return apiOrderMapper.queryObjectByMerchOrderSn(merchOrderSn);
  1168. }
  1169. public int queryCountByMerchOrderSn(String merchOrderSn){
  1170. return apiOrderMapper.queryCountByMerchOrderSn(merchOrderSn);
  1171. }
  1172. public int queryCountByPayId(String payId){
  1173. return apiOrderMapper.queryCountByPayId(payId);
  1174. }
  1175. public List<OrderVo> queryOrderByMerchOrderSnAndRefundStatus(String merchOrderSn){
  1176. return apiOrderMapper.queryOrderByMerchOrderSnAndRefundStatus(merchOrderSn);
  1177. }
  1178. }