ApiOrderService.java 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838
  1. package com.kmall.api.service;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.kmall.common.constant.Dict;
  5. import com.kmall.api.dao.*;
  6. import com.kmall.api.dto.IdCardMsgVo;
  7. import com.kmall.api.entity.*;
  8. import com.kmall.api.service.merch.OmsMerchPropertiesBuilder;
  9. import com.kmall.api.util.CommonUtil;
  10. import com.kmall.api.util.IdCardUtil;
  11. import com.kmall.common.dao.TemplateConfDao;
  12. import com.kmall.common.entity.FormIdsEntity;
  13. import com.kmall.common.entity.TemplateConfVo;
  14. import com.kmall.common.service.FormIdsService;
  15. import com.kmall.common.service.print.ticket.PrintTicketPropertiesBuilder;
  16. import com.kmall.common.utils.Constant;
  17. import com.kmall.common.utils.DateUtils;
  18. import com.kmall.common.utils.RRException;
  19. import com.kmall.common.utils.StringUtils;
  20. import com.kmall.common.utils.print.ticket.TicketPrintUtil;
  21. import com.kmall.common.utils.print.ticket.item.*;
  22. import com.kmall.common.utils.wxtemplate.TemplateData;
  23. import com.kmall.common.utils.wxtemplate.WxTemplate;
  24. import org.apache.commons.logging.Log;
  25. import org.apache.commons.logging.LogFactory;
  26. import org.springframework.beans.factory.annotation.Autowired;
  27. import org.springframework.stereotype.Service;
  28. import org.springframework.transaction.annotation.Transactional;
  29. import java.math.BigDecimal;
  30. import java.text.SimpleDateFormat;
  31. import java.util.*;
  32. @Service
  33. public class ApiOrderService {
  34. private Log logger = LogFactory.getLog(ApiOrderService.class);
  35. @Autowired
  36. private ApiSysPrinterMapper apiSysPrinterMapper;
  37. @Autowired
  38. private ApiProductMapper apiProductMapper;
  39. @Autowired
  40. private ApiCartMapper apiCartMapper;
  41. @Autowired
  42. private ApiCouponMapper apiCouponMapper;
  43. @Autowired
  44. private ApiOrderMapper apiOrderMapper;
  45. @Autowired
  46. private ApiOrderGoodsMapper apiOrderGoodsMapper;
  47. @Autowired
  48. private ApiUserCouponMapper apiUserCouponMapper;
  49. @Autowired
  50. private TemplateConfDao apiTemplateConfMapper;
  51. @Autowired
  52. private ApiUserMapper apiUserMapper;
  53. @Autowired
  54. private ApiGoodsGroupOpenMapper apiGoodsGroupOpenMapper;
  55. @Autowired
  56. private ApiGoodsGroupOpenDetailMapper apiGoodsGroupOpenDetailMapper;
  57. @Autowired
  58. private FormIdsService formIdsService;
  59. @Autowired
  60. private ApiGoodsMapper apiGoodsMapper;
  61. @Autowired
  62. private ApiFreightService apiFreightService;
  63. @Autowired
  64. private ApiOrderProcessRecordMapper orderProcessRecordMapper;
  65. @Autowired
  66. private ApiStoreMapper apiStoreMapper;
  67. @Autowired
  68. private ApiMerchMapper apiMerchMapper;
  69. public OrderVo queryObject(Long id) {
  70. return apiOrderMapper.queryObject(id);
  71. }
  72. public OrderVo queryObjectByOrderSn(String order_sn) {
  73. return apiOrderMapper.queryObjectByOrderSn(order_sn);
  74. }
  75. public Map queryUcenterMap(Map<String, Object> map) {
  76. return apiOrderMapper.queryUcenterMap(map);
  77. }
  78. public List<OrderVo> queryList(Map<String, Object> map) {
  79. return apiOrderMapper.queryList(map);
  80. }
  81. public int queryTotal(Map<String, Object> map) {
  82. return apiOrderMapper.queryTotal(map);
  83. }
  84. public void save(OrderVo order) {
  85. apiOrderMapper.save(order);
  86. }
  87. @Transactional
  88. public void cancelOrder(OrderVo order) {
  89. Map orderGoodsParam = new HashMap();
  90. orderGoodsParam.put("order_id", order.getId());
  91. //订单的商品
  92. List<OrderGoodsVo> goodsList = apiOrderGoodsMapper.queryList(orderGoodsParam);
  93. for (OrderGoodsVo orderGoodsVo : goodsList) {
  94. ProductVo productInfo = apiProductMapper.queryByStoreId(orderGoodsVo.getProduct_id(), order.getStore_id());
  95. productInfo.setStock_num(productInfo.getStock_num() + orderGoodsVo.getNumber());
  96. productInfo.minusSellVolume();
  97. apiProductMapper.updateStockNum(productInfo);
  98. }
  99. update(order);
  100. // 判断是否有优惠券
  101. UserCouponVo couponVo = apiUserCouponMapper.queryByOrderId(order.getId());
  102. if (null != couponVo) {
  103. apiUserCouponMapper.cancelOrder(couponVo);
  104. }
  105. }
  106. public void update(OrderVo order) {
  107. order.setIsScan("0");
  108. order.setModTime(new Date());
  109. apiOrderMapper.update(order);
  110. }
  111. public void updateOrderByMerchOrderSn(OrderVo order) {
  112. apiOrderMapper.updateOrderByMerchOrderSn(order);
  113. }
  114. public void updateBatch(List<OrderVo> list) {
  115. for (OrderVo order : list) {
  116. order.setIsScan("0");
  117. order.setModTime(new Date());
  118. }
  119. apiOrderMapper.updateBatch(list);
  120. }
  121. public void delete(Integer id) {
  122. apiOrderMapper.delete(id);
  123. }
  124. public void deleteBatch(Integer[] ids) {
  125. apiOrderMapper.deleteBatch(ids);
  126. }
  127. @Transactional
  128. public Map submit(JSONObject jsonParam, UserVo loginUser, Long storeId) {
  129. Map resultObj = new HashMap();
  130. AddressVo addressVo = jsonParam.getObject("checkedAddress", AddressVo.class);
  131. if (addressVo == null) {
  132. resultObj.put("errno", 400);
  133. resultObj.put("errmsg", "地址不能为空");
  134. return resultObj;
  135. }
  136. String formId = jsonParam.getString("formId");
  137. String idNo = jsonParam.getString("idNo");
  138. String userName = jsonParam.getString("userName");
  139. String postscript00 = jsonParam.getString("postscript00");
  140. String postscript02 = jsonParam.getString("postscript02");
  141. String postscript10 = jsonParam.getString("postscript10");
  142. String postscript11 = jsonParam.getString("postscript11");//留言备注
  143. String checkCart = jsonParam.getString("checkCart");//业务区分,11为普通商品,00为保税商品
  144. UserVo user = apiUserMapper.queryObjectByIdNoAndName(idNo, userName);
  145. UserVo userVo = new UserVo();
  146. userVo.setId(loginUser.getId());
  147. userVo.setIdNo(idNo);
  148. userVo.setUsername(userName);
  149. if(user != null){
  150. if(loginUser.getId() != user.getId()){
  151. resultObj.put("errno", 400);
  152. resultObj.put("errmsg", "该身份证信息已被绑定");
  153. return resultObj;
  154. }
  155. }
  156. // 实名认证身份证信息,认证成功更新到用户表
  157. String result = IdCardUtil.checkIdCard(userVo.getIdNo(), userVo.getUsername());
  158. IdCardMsgVo vo = JSON.parseObject(result,IdCardMsgVo.class);
  159. if(vo.getRespCode().equalsIgnoreCase("0000")){
  160. apiUserMapper.update(userVo);
  161. }else{
  162. resultObj.put("errno", 400);
  163. resultObj.put("errmsg", vo.getRespMessage());
  164. return resultObj;
  165. }
  166. //获取要购买的商品
  167. Map param = new HashMap();
  168. param.put("user_id", loginUser.getId());
  169. param.put("store_id", storeId);
  170. param.put("checked", 1);
  171. param.put("checkCart", checkCart);
  172. List<CartVo> checkedGoodsList = apiCartMapper.queryList(param);
  173. if (null == checkedGoodsList) {
  174. resultObj.put("errno", 400);
  175. resultObj.put("errmsg", "请选择商品");
  176. return resultObj;
  177. }
  178. // 检查库存和更新库存
  179. List<ProductVo> productVos = new ArrayList();
  180. for (CartVo goodsItem : checkedGoodsList) {
  181. //取得规格的信息,判断规格库存
  182. ProductVo productInfo = apiProductMapper.queryByStoreId(goodsItem.getProduct_id(), storeId);
  183. synchronized (productInfo){
  184. if (null == productInfo || null == productInfo.getStock_num() || productInfo.getStock_num() < goodsItem.getNumber()) {
  185. resultObj.put("errno", 400);
  186. resultObj.put("errmsg", "库存不足,仅剩余" + productInfo.getStock_num());
  187. return resultObj;
  188. }else{
  189. productInfo.setStock_num(productInfo.getStock_num() - goodsItem.getNumber());
  190. productInfo.setStore_id(storeId);
  191. productInfo.addSellVolume();
  192. productVos.add(productInfo);
  193. apiProductMapper.updateStockNum(productInfo);
  194. }
  195. }
  196. }
  197. BigDecimal freightPrice00 = new BigDecimal(0.00);
  198. BigDecimal freightPrice02 = new BigDecimal(0.00);
  199. BigDecimal freightPrice10 = new BigDecimal(0.00);
  200. BigDecimal freightPrice11 = new BigDecimal(0.00);
  201. Boolean isBizType00 = false;
  202. Boolean isBizType02 = false;
  203. Boolean isBizType10 = false;
  204. Boolean isBizType11 = false;
  205. //订单按业务类型进行分单
  206. for (CartVo goodsItem : checkedGoodsList) {
  207. //订单业务类型:00:保税备货, 02:保税展示补货,10:保税展示跨境,11:普通商品
  208. if(org.apache.commons.lang.StringUtils.isEmpty(checkCart)){
  209. if(Dict.orderBizType.item_11.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  210. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  211. freightPrice11 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice11) : freightPrice11;//查询商品运费信息
  212. isBizType11 =true;
  213. }
  214. if(Dict.orderBizType.item_00.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  215. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  216. freightPrice00 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice00) : freightPrice00;//查询商品运费信息
  217. isBizType00 =true;
  218. }
  219. if(Dict.orderBizType.item_02.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  220. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  221. freightPrice02 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice02) : freightPrice02;//查询商品运费信息
  222. isBizType02 =true;
  223. }
  224. if(Dict.orderBizType.item_10.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  225. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  226. freightPrice10 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice10) : freightPrice10;//查询商品运费信息
  227. isBizType10 =true;
  228. }
  229. }else{
  230. if(checkCart.equalsIgnoreCase(Dict.orderBizType.item_11.getItem())){
  231. if(Dict.orderBizType.item_11.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  232. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  233. freightPrice11 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice11) : freightPrice11;//查询商品运费信息
  234. isBizType11 =true;
  235. }
  236. }else{
  237. if(Dict.orderBizType.item_00.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  238. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  239. freightPrice00 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice00) : freightPrice00;//查询商品运费信息
  240. isBizType00 =true;
  241. }
  242. if(Dict.orderBizType.item_02.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  243. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  244. freightPrice02 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice02) : freightPrice02;//查询商品运费信息
  245. isBizType02 =true;
  246. }
  247. if(Dict.orderBizType.item_10.getItem().equalsIgnoreCase(goodsItem.getGoodsBizType())){
  248. FreightEntity freightEntity = apiFreightService.queryObjectByGoodsId(goodsItem.getGoods_id());
  249. freightPrice10 = freightEntity!=null ? freightEntity.getDefaultFreight().add(freightPrice10) : freightPrice10;//查询商品运费信息
  250. isBizType10 =true;
  251. }
  252. }
  253. }
  254. }
  255. List<OrderVo> orderInfoList = new ArrayList();
  256. String merchOrderSn = "EMATO"+CommonUtil.generateOrderNumber();
  257. if(isBizType00){
  258. OrderVo order00 = setOrderVo(loginUser,jsonParam,storeId,freightPrice00,checkedGoodsList,Dict.orderBizType.item_00.getItem());
  259. order00.setOrderBizType(Dict.orderBizType.item_00.getItem());
  260. order00.setMerchOrderSn(merchOrderSn);
  261. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript00)) {
  262. order00.setPostscript(postscript00);
  263. }
  264. orderInfoList.add(order00);
  265. }
  266. if(isBizType02){
  267. OrderVo order02 = setOrderVo(loginUser,jsonParam,storeId,freightPrice02,checkedGoodsList,Dict.orderBizType.item_02.getItem());
  268. order02.setOrderBizType(Dict.orderBizType.item_02.getItem());
  269. order02.setMerchOrderSn(merchOrderSn);
  270. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript02)) {
  271. order02.setPostscript(postscript02);
  272. }
  273. orderInfoList.add(order02);
  274. }
  275. if(isBizType10){
  276. OrderVo order10 = setOrderVo(loginUser,jsonParam,storeId,freightPrice10,checkedGoodsList,Dict.orderBizType.item_10.getItem());
  277. order10.setOrderBizType(Dict.orderBizType.item_10.getItem());
  278. order10.setMerchOrderSn(merchOrderSn);
  279. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript10)) {
  280. order10.setPostscript(postscript10);
  281. }
  282. orderInfoList.add(order10);
  283. }
  284. if(isBizType11){
  285. OrderVo order11 = setOrderVo(loginUser,jsonParam,storeId,freightPrice11,checkedGoodsList,Dict.orderBizType.item_11.getItem());
  286. order11.setOrderBizType(Dict.orderBizType.item_11.getItem());
  287. order11.setMerchOrderSn(merchOrderSn);
  288. if(org.apache.commons.lang.StringUtils.isNotEmpty(postscript11)) {
  289. order11.setPostscript(postscript11);
  290. }
  291. orderInfoList.add(order11);
  292. }
  293. //开启事务,插入订单信息和订单商品
  294. if(orderInfoList != null && orderInfoList.size() > 0) {
  295. apiOrderMapper.saveBatch(orderInfoList);
  296. List<OrderProcessRecordEntity> processRecordEntityList = new ArrayList<>();
  297. for (OrderVo orderInfo : orderInfoList) {
  298. if (null == orderInfo.getId()) {
  299. throw new RRException("订单提交失败");
  300. }
  301. //新增订单详情
  302. for (CartVo goodsItem : checkedGoodsList) {
  303. //统计商品总价
  304. if (orderInfo.getOrderBizType().equalsIgnoreCase(goodsItem.getGoodsBizType())) {
  305. GoodsVo goodsVo = apiGoodsMapper.queryObject(goodsItem.getGoods_id());
  306. if(goodsVo==null){
  307. throw new RRException("订单提交失败:商品不存在");
  308. }
  309. OrderGoodsVo orderGoodsVo = setOrderGoodsVo(orderInfo, goodsItem,goodsVo);
  310. apiOrderGoodsMapper.save(orderGoodsVo);
  311. }
  312. }
  313. OrderProcessRecordEntity entity = new OrderProcessRecordEntity();
  314. entity.setOrderSn(orderInfo.getOrder_sn());
  315. entity.setUserId(Integer.valueOf(loginUser.getId()+""));
  316. entity.setAddOrderStartTime(orderInfo.getAdd_time());
  317. entity.setAddOrderSuccTime(orderInfo.getAdd_time());
  318. entity.setIsAddOrderSend(Dict.isSend.item_1.getItem());
  319. entity.setOrderBizType(orderInfo.getOrderBizType());
  320. processRecordEntityList.add(entity);
  321. }
  322. orderProcessRecordMapper.saveBatch(processRecordEntityList);//新增订单流转信息
  323. //清空已购买的商品
  324. apiCartMapper.deleteByCart(loginUser.getId(), storeId, 1, checkCart);
  325. if (apiOrderMapper.queryCountByMerchOrderSn(merchOrderSn) > 1) {//不止一笔订单则为拆单订单
  326. OrderVo orderVo = new OrderVo();
  327. orderVo.setIsMergePay("2");//多笔订单单笔支付
  328. orderVo.setMerchOrderSn(merchOrderSn);
  329. apiOrderMapper.updateOrderByMerchOrderSn(orderVo);
  330. }
  331. resultObj.put("errno", 0);
  332. resultObj.put("errmsg", "订单提交成功");
  333. //
  334. Map orderInfoMap = new HashMap();
  335. orderInfoMap.put("orderInfo", orderInfoList);
  336. resultObj.put("data", orderInfoMap);
  337. // 优惠券标记已用
  338. /*for (OrderVo orderInfo : orderInfoList) {
  339. if (null != userCouponId && 0 != userCouponId) {
  340. UserCouponVo userCouponVo = apiUserCouponMapper.queryObject(userCouponId);
  341. if (null != userCouponVo && (null == userCouponVo.getOrder_id() || 0 == userCouponVo.getOrder_id())) {
  342. userCouponVo.setUsed_time(new Date());
  343. userCouponVo.setOrder_id(orderInfo.getId());
  344. userCouponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  345. apiUserCouponMapper.update(userCouponVo);
  346. }
  347. }
  348. }*/
  349. }
  350. return resultObj;
  351. }
  352. /**
  353. * 设置订单数据
  354. * @param loginUser
  355. * @param jsonParam
  356. * @param storeId
  357. * @param freightPrice
  358. * @param checkedGoodsList
  359. * @return
  360. */
  361. public OrderVo setOrderVo(UserVo loginUser,JSONObject jsonParam,Long storeId,BigDecimal freightPrice,List<CartVo> checkedGoodsList,String bizType){
  362. OrderVo orderInfo = new OrderVo();
  363. Integer userCouponId = jsonParam.getInteger("userCouponId");
  364. String postscript = jsonParam.getString("postscript");
  365. Long fullCutCouponId = jsonParam.getLong("fullCutCouponId");//满减券
  366. AddressVo addressVo = jsonParam.getObject("checkedAddress", AddressVo.class);
  367. Date delivery_date = jsonParam.getDate("delivery_date");
  368. String merchSn = (String)jsonParam.get("merchSn");
  369. if (null == delivery_date) {
  370. delivery_date = new Date();
  371. }
  372. String delivery_remark = jsonParam.getString("delivery_remark");
  373. if (StringUtils.isNullOrEmpty(delivery_remark)) {
  374. delivery_remark = "尽快送达";
  375. }
  376. BigDecimal fullCutCouponDec = Constant.ZERO;
  377. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  378. for (CartVo goodsItem : checkedGoodsList) {
  379. if(bizType.equalsIgnoreCase(goodsItem.getGoodsBizType())){
  380. goodsTotalPrice = goodsTotalPrice.add(goodsItem.getRetail_price().multiply(new BigDecimal(goodsItem.getNumber())));
  381. }
  382. }
  383. //查询未使用的优惠券
  384. String couponName = "";
  385. UserCouponVo couponVo = null;
  386. BigDecimal couponPrice = new BigDecimal(0.00);
  387. if (null != userCouponId && 0 != userCouponId) {
  388. couponVo = apiUserCouponMapper.queryObjectByIdAndUsed(userCouponId);
  389. if (null != couponVo && null != couponVo.getType_money()) {
  390. couponPrice = couponVo.getType_money();
  391. couponName = couponVo.getCoupon_name();
  392. }
  393. }
  394. /*// 获取优惠信息提示
  395. Map couponParam = new HashMap();
  396. couponParam.put("enabled", true);
  397. Integer[] send_types = new Integer[]{7};
  398. couponParam.put("send_types", send_types);
  399. List<CouponVo> couponVos = apiCouponMapper.queryList(couponParam);
  400. if (null != couponVos && couponVos.size() > 0) {
  401. for (CouponVo couponVo : couponVos) {
  402. // 是否免运费
  403. if (couponVo.getSend_type() == 7 && couponVo.getMin_goods_amount().compareTo(goodsTotalPrice) <= 0) {
  404. freightPrice = couponVo.getType_money();
  405. }
  406. }
  407. }
  408. //todo 获取优惠信息 满减,暂时不用
  409. CouponVo fullCutCoupon = apiCouponMapper.queryObject(fullCutCouponId);
  410. if (null != fullCutCoupon) {
  411. fullCutCouponDec = fullCutCoupon.getType_money();
  412. }*/
  413. //订单价格计算:订单的总价+运费
  414. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  415. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  416. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  417. // BigDecimal actualPrice = orderTotalPrice.subtract(fullCutCouponDec).subtract(couponPrice);
  418. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  419. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  420. MerchVo merchVo = apiMerchMapper.queryObjectByMerchSn(merchSn);
  421. // String merchShortName = "";
  422. // if(merchVo != null){
  423. // merchShortName = merchVo.getMerchShortName();
  424. // }
  425. String thirdMerchSn = "";
  426. StoreVo storeVo = apiStoreMapper.queryObject(storeId);
  427. if(storeVo != null){
  428. thirdMerchSn = storeVo.getThirdPartyMerchCode()==null?"":storeVo.getThirdPartyMerchCode();
  429. }
  430. // //一级商户 + 二级商户(拼音首字母)+ 三级商户 + 业务类型 + 编号
  431. // String orderSn = oneMerchName + merchShortName + thirdMerchSn + bizType + CommonUtil.generateOrderNumber();
  432. //一级商户 + 三级商户(拼音首字母) + 业务类型 + 编号
  433. String orderSn = "ZW" + thirdMerchSn + bizType + CommonUtil.generateOrderNumber();
  434. orderInfo.setOrder_sn(orderSn);
  435. orderInfo.setMerchSn(merchSn);
  436. orderInfo.setUser_id(loginUser.getId());
  437. //收货地址和运费
  438. orderInfo.setConsignee(addressVo.getUserName());
  439. orderInfo.setMobile(addressVo.getTelNumber());
  440. orderInfo.setCountry(addressVo.getNationalCode());
  441. orderInfo.setProvince(addressVo.getProvinceName());
  442. orderInfo.setCity(addressVo.getCityName());
  443. orderInfo.setDistrict(addressVo.getCountyName());
  444. orderInfo.setAddress(addressVo.getDetailInfo());
  445. orderInfo.setAddress_id(addressVo.getId());
  446. orderInfo.setDelivery_date(delivery_date);
  447. orderInfo.setDelivery_remark(delivery_remark);
  448. orderInfo.setStore_id(storeId);
  449. //
  450. orderInfo.setFreight_price(freightPrice.intValue());
  451. orderInfo.setCoupon_id(userCouponId);
  452. orderInfo.setCoupon_price(couponPrice);
  453. orderInfo.setCoupon_name(couponName);
  454. //留言
  455. orderInfo.setPostscript(postscript);
  456. //使用的优惠券
  457. orderInfo.setFull_cut_price(fullCutCouponDec);
  458. orderInfo.setAdd_time(new Date());
  459. orderInfo.setGoods_price(goodsTotalPrice);
  460. orderInfo.setOrder_price(orderTotalPrice);
  461. orderInfo.setActual_price(actualPrice);
  462. orderInfo.setOrder_type("1");
  463. // 待付款
  464. orderInfo.setOrder_status(0);
  465. orderInfo.setShipping_status(0);
  466. orderInfo.setPay_status(0);
  467. orderInfo.setShipping_id(0L);
  468. orderInfo.setShipping_fee(Constant.ZERO);
  469. orderInfo.setIntegral(0);
  470. orderInfo.setIntegral_money(Constant.ZERO);
  471. orderInfo.setCreateTime(new Date());
  472. orderInfo.setModTime(new Date());
  473. orderInfo.setPayMobile(loginUser.getMobile());
  474. orderInfo.setPayTransactionId("");
  475. orderInfo.setIsScan("0");//默认未扫描
  476. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  477. orderInfo.setPayMobile(userVo.getMobile());
  478. orderInfo.setPay_name(userVo.getUsername());
  479. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_0.getItem());
  480. //标记该订单已使用优惠券
  481. if(couponVo != null){
  482. couponVo.setUsed_time(new Date());
  483. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  484. apiUserCouponMapper.update(couponVo);
  485. }
  486. return orderInfo;
  487. }
  488. public OrderGoodsVo setOrderGoodsVo(OrderVo orderInfo,CartVo goodsItem,GoodsVo goodsVo){
  489. OrderGoodsVo orderGoodsVo = new OrderGoodsVo();
  490. orderGoodsVo.setOrder_id(orderInfo.getId());
  491. orderGoodsVo.setGoods_id(goodsItem.getGoods_id());
  492. orderGoodsVo.setGoods_sn(goodsItem.getGoods_sn());
  493. orderGoodsVo.setProduct_id(goodsItem.getProduct_id());
  494. orderGoodsVo.setGoods_name(goodsItem.getGoods_name());
  495. orderGoodsVo.setList_pic_url(goodsItem.getList_pic_url());
  496. orderGoodsVo.setMarket_price(goodsItem.getMarket_price());
  497. orderGoodsVo.setRetail_price(goodsItem.getRetail_price());
  498. orderGoodsVo.setNumber(goodsItem.getNumber());
  499. orderGoodsVo.setGoods_specification_name_value(goodsItem.getGoods_specification_name_value());
  500. orderGoodsVo.setGoods_specification_ids(goodsItem.getGoods_specification_ids());
  501. orderGoodsVo.setOrderBizType(goodsItem.getGoodsBizType());
  502. orderGoodsVo.setCreateTime(new Date());
  503. orderGoodsVo.setModTime(new Date());
  504. orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  505. BigDecimal number = new BigDecimal(Long.valueOf(goodsItem.getNumber()));
  506. BigDecimal goodsTotal = goodsItem.getRetail_price().multiply(number);//单商品总价
  507. BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(),2, BigDecimal.ROUND_HALF_UP);//单商品总价/订单总价(不含运费、不含优惠券)
  508. BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  509. BigDecimal settlePrice = Constant.ZERO;
  510. if(orderInfo.getFreight_price()!=0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  511. //运费-优惠券
  512. BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  513. //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 单商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  514. settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  515. }else{
  516. if(orderInfo.getFreight_price()!=0){
  517. //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  518. BigDecimal freightRate = rate.multiply(freightPrice);
  519. //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  520. settlePrice = goodsTotal.add(freightRate);
  521. }
  522. if(!"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  523. //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  524. BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  525. //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  526. settlePrice = goodsTotal.subtract(couponRate);
  527. }
  528. }
  529. if(settlePrice.compareTo(BigDecimal.valueOf(0)) == 0){
  530. orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  531. }else{
  532. orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  533. }
  534. orderGoodsVo.setSku(goodsVo.getSku());
  535. return orderGoodsVo;
  536. }
  537. /**
  538. * 支付成功通知
  539. */
  540. @Transactional
  541. public void notifyPaySuccess(OrderVo orderInfo) {
  542. WxTemplate tem = new WxTemplate();
  543. FormIdsEntity formIdsEntity = formIdsService.getFormIdsByMerchOrderSn(orderInfo.getMerchOrderSn());
  544. if (null == formIdsEntity || !StringUtils.isNotEmpty(formIdsEntity.getFormId())) {
  545. return;
  546. }
  547. if (orderInfo.getOrder_type().equals("1")) { // 订单类型 1:普通订单 2:团购订单
  548. TemplateConfVo templateConfVo = apiTemplateConfMapper.queryByTypeId(1); // 模板类型 1订单付款成功 2团购成功 3拼团失败通知 4拼团进度 5 6 7订单配送 8订单评价提醒
  549. if (null == templateConfVo) {
  550. return;
  551. }
  552. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  553. tem.setTemplate_id(templateConfVo.getTemplateId());
  554. // tem.setTopcolor("#00DD00");
  555. tem.setTouser(userVo.getWeixin_openid());
  556. tem.setPage("/pages/ucenter/orderDetail/orderDetail?id=" + orderInfo.getId());
  557. tem.setForm_id(formIdsEntity.getFormId());
  558. List<TemplateData> paras = new ArrayList<TemplateData>();
  559. paras.add(new TemplateData("first", templateConfVo.getDesc(), "#000000"));
  560. paras.add(new TemplateData("keyword1", orderInfo.getMerchOrderSn(), "#000000"));
  561. //订单的商品
  562. Map orderGoodsParam = new HashMap();
  563. orderGoodsParam.put("order_id", orderInfo.getId());
  564. List<OrderGoodsVo> orderGoods = apiOrderGoodsMapper.queryList(orderGoodsParam);
  565. String body = "";
  566. if (null != orderGoods) {
  567. for (OrderGoodsVo goodsVo : orderGoods) {
  568. body = body + goodsVo.getGoods_name() + "、";
  569. }
  570. if (body.length() > 0) {
  571. body = body.substring(0, body.length() - 1);
  572. }
  573. }
  574. paras.add(new TemplateData("keyword2", body, "#000000"));
  575. paras.add(new TemplateData("keyword3", orderInfo.getActual_price().setScale(2, BigDecimal.ROUND_HALF_DOWN).toString(), "#000000"));
  576. paras.add(new TemplateData("keyword4", DateUtils.format(orderInfo.getAdd_time(), DateUtils.DATE_TIME_PATTERN), "#000000"));
  577. tem.setData(paras);
  578. }
  579. // TODO: 2018/10/25 暂时不实现团购订单
  580. /*if (orderInfo.getOrder_type().equals("2")) { // 订单类型 1:普通订单 2:团购订单
  581. TemplateConfVo templateConfVo = apiTemplateConfMapper.queryByTypeId(2); // 模板类型 1订单付款成功 2团购成功 3拼团失败通知 4拼团进度 5 6 7订单配送 8订单评价提醒
  582. if (null == templateConfVo) {
  583. return;
  584. }
  585. UserVo userVo = apiUserMapper.queryObject(orderInfo.getUser_id());
  586. // 团购明细
  587. GoodsGroupOpenDetailVo openDetailVo = apiGoodsGroupOpenDetailMapper.queryObject(orderInfo.getActivity_id());
  588. // 获取团购
  589. GoodsGroupOpenVo groupOpenVo = apiGoodsGroupOpenMapper.queryObject(openDetailVo.getOpen_id());
  590. tem.setTemplate_id(templateConfVo.getTemplateId());
  591. tem.setTopcolor("#00DD00");
  592. tem.setTouser(userVo.getWeixin_openid());
  593. tem.setPage("/pages/ucenter/orderDetail/orderDetail?id=" + orderInfo.getId());
  594. tem.setForm_id(formIdsEntity.getFormId());
  595. List<TemplateData> paras = new ArrayList<TemplateData>();
  596. paras.add(new TemplateData("keyword1", groupOpenVo.getTitle(), "#000000"));
  597. paras.add(new TemplateData("keyword2", DateUtils.format(groupOpenVo.getOpen_time(), DateUtils.DATE_TIME_PATTERN), "#000000"));
  598. //订单的商品
  599. Map orderGoodsParam = new HashMap();
  600. orderGoodsParam.put("order_id", orderInfo.getId());
  601. List<OrderGoodsVo> orderGoods = apiOrderGoodsMapper.queryList(orderGoodsParam);
  602. String body = "";
  603. if (null != orderGoods) {
  604. for (OrderGoodsVo goodsVo : orderGoods) {
  605. body = body + goodsVo.getGoods_name() + "、";
  606. }
  607. if (body.length() > 0) {
  608. body = body.substring(0, body.length() - 1);
  609. }
  610. }
  611. paras.add(new TemplateData("keyword3", body, "#000000"));
  612. // 团成员
  613. Map groupParam = new HashMap();
  614. groupParam.put("open_id", orderInfo.getActivity_id());
  615. List<GoodsGroupOpenDetailVo> openDetailVos = apiGoodsGroupOpenDetailMapper.queryList(groupParam);
  616. String attendMember = "";
  617. if (null != openDetailVos) {
  618. for (GoodsGroupOpenDetailVo detailVo : openDetailVos) {
  619. attendMember = attendMember + detailVo.getNickname() + "、";
  620. }
  621. if (attendMember.length() > 0) {
  622. attendMember = attendMember.substring(0, attendMember.length() - 1);
  623. }
  624. }
  625. paras.add(new TemplateData("keyword4", attendMember, "#000000"));
  626. paras.add(new TemplateData("keyword5", orderInfo.getActual_price().setScale(2, BigDecimal.ROUND_HALF_DOWN).toString(), "#000000"));
  627. paras.add(new TemplateData("keyword5", templateConfVo.getDesc(), "#000000"));
  628. tem.setData(paras);
  629. }*/
  630. try {
  631. // WxTemplateUtil.sendMessage(tem);
  632. formIdsService.releaseFormIds(formIdsEntity);
  633. } catch (Exception e) {
  634. e.printStackTrace();
  635. }
  636. }
  637. /**
  638. * 确认收货
  639. *
  640. * @param orderId
  641. */
  642. @Transactional
  643. public void confirmOrder(Long orderId) {
  644. OrderVo orderVo = apiOrderMapper.queryObject(orderId);
  645. orderVo.setOrder_status(301);
  646. orderVo.setShipping_status(2);
  647. orderVo.setConfirm_time(new Date());
  648. orderVo.setModTime(new Date());
  649. apiOrderMapper.update(orderVo);
  650. }
  651. /*public String printMsgs(Long orderId) {
  652. OrderVo orderEntity = queryObject(orderId);
  653. Map<String, Object> map = new HashMap<String, Object>();
  654. map.put("order_id", orderEntity.getId());
  655. List<OrderGoodsVo> orderGoodsEntities = apiOrderGoodsMapper.queryList(map);
  656. UserVo userVo = apiUserMapper.queryObject(orderEntity.getUser_id());
  657. String content = "<CB>商城超市</CB><BR>";
  658. content += "名称/商品编码 单价 数量 金额<BR>";
  659. for (OrderGoodsVo orderGoodsEntity : orderGoodsEntities) {
  660. content += "--------------------------------<BR>";
  661. content += orderGoodsEntity.getGoods_name() + "<BR>" + orderGoodsEntity.getGoods_sn() + " " + orderGoodsEntity.getRetail_price() + " " + orderGoodsEntity.getNumber()
  662. + " " + orderGoodsEntity.getRetail_price().multiply(new BigDecimal(orderGoodsEntity.getNumber())) + "<BR>";
  663. }
  664. content += "--------------------------------<BR>";
  665. content += "备注:" + orderEntity.getPostscript() + "<BR>";
  666. content += "--------------------------------<BR>";
  667. content += "订单编号:" + orderEntity.getOrder_sn() + "<BR>";
  668. content += "配送配用:" + orderEntity.getShipping_fee() + "元<BR>";
  669. content += "优惠价格:" + orderEntity.getCoupon_price() + "元<BR>";
  670. content += "合计:" + orderEntity.getOrder_price() + "元<BR>";
  671. content += "实付:" + orderEntity.getActual_price() + "元<BR>";
  672. content += "姓名:" + null != userVo.getNickname() ? userVo.getNickname() : "" + "<BR>";
  673. content += "送货地点:" + orderEntity.getProvince() + orderEntity.getCity() + orderEntity.getDistrict() + orderEntity.getAddress() + "<BR>";
  674. content += "联系电话:" + orderEntity.getMobile() + "<BR>";
  675. content += "付款时间:" + DateUtils.format(orderEntity.getPay_time(), DateUtils.DATE_TIME_PATTERN) + "<BR>";
  676. content += "<QR>" + orderEntity.getId() + "</QR>";
  677. if ("2".equals(orderEntity.getOrder_type())) {
  678. content += "<RIGHT><BOLD>【团购】</BOLD></RIGHT>";
  679. }
  680. //所属门店
  681. Long storeId = orderEntity.getStore_id();
  682. //获取门店的打印机编号,每个门店只有一个打票机
  683. Map<String, Object> printParams = new HashMap<String, Object>();
  684. List<SysPrinterVo> printerEntities = apiSysPrinterMapper.queryList(printParams);
  685. printParams.put("storeId", storeId);
  686. String sn = "";
  687. if (printerEntities != null && printerEntities.size() != 0) {
  688. sn = printerEntities.get(0).getSn();
  689. }
  690. return FeiGeUtils.printMsg(sn, content, "1");
  691. }*/
  692. public Ticket printMsg(Long orderId) {
  693. OrderVo orderEntity = queryObject(orderId);
  694. if(orderEntity != null) {
  695. if (orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_10.getItem())
  696. || orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())) {
  697. Map<String, Object> map = new HashMap<String, Object>();
  698. map.put("order_id", orderEntity.getId());
  699. List<OrderGoodsVo> orderGoodsEntityList = apiOrderGoodsMapper.queryList(map);
  700. // 获取门店
  701. StoreVo storeEntity = apiStoreMapper.queryObject(orderEntity.getStore_id());
  702. // 获取清关信息
  703. OrderProcessRecordEntity orderProcessRecordEntity = orderProcessRecordMapper.queryObjectByOrderSn(orderEntity.getOrder_sn());
  704. UserVo userVo = apiUserMapper.queryObject(orderEntity.getUser_id());
  705. // 小票头
  706. TicketHead head = new TicketHead();
  707. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  708. head.setMemberId(userVo.getUsername().toString());
  709. head.setOrderId(orderEntity.getOrder_sn());
  710. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  711. // 商品信息
  712. Integer goodsTotal = 0; // 商品总个数
  713. BigDecimal total = Constant.ZERO; // 商品总计
  714. List<Goods> goodsList = new ArrayList<>();
  715. for (OrderGoodsVo orderGoods : orderGoodsEntityList) {
  716. goodsTotal += orderGoods.getNumber();
  717. total = total.add(orderGoods.getRetail_price().subtract(new BigDecimal(orderGoods.getNumber()))).setScale(2, BigDecimal.ROUND_HALF_UP);
  718. Goods goods = new Goods(orderGoods.getGoods_name(), orderGoods.getRetail_price().toString(), orderGoods.getNumber().toString()
  719. ,orderGoods.getRetail_price().multiply(new BigDecimal(orderGoods.getNumber())).setScale(2,BigDecimal.ROUND_HALF_UP).toString());
  720. goodsList.add(goods);
  721. }
  722. // 收银信息
  723. CashInfo cashInfo = new CashInfo();
  724. cashInfo.setGoodsTotal(goodsTotal.toString());
  725. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  726. cashInfo.setReceipts(orderEntity.getActual_price().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  727. cashInfo.setOddChange("0.00");
  728. cashInfo.setCoupon(orderEntity.getCoupon_price().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  729. cashInfo.setFreight(new BigDecimal(orderEntity.getFreight_price()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  730. cashInfo.setPaymentMode("微信支付");
  731. // 海关清单
  732. CusListing cusListing = new CusListing();
  733. cusListing.setOrderId(orderEntity.getOrder_sn());
  734. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  735. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  736. cusListing.setConsignee(orderEntity.getConsignee());
  737. cusListing.setConsigneeTel(orderEntity.getMobile());
  738. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  739. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  740. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  741. }else{
  742. return null;
  743. }
  744. }else{
  745. return null;
  746. }
  747. }
  748. public List<OrderVo> queryObjectByIdList(List<Long> orderIdList){
  749. return apiOrderMapper.queryObjectByIdList(orderIdList);
  750. }
  751. public List<OrderVo> queryObjectByMerchOrderSn(String merchOrderSn){
  752. return apiOrderMapper.queryObjectByMerchOrderSn(merchOrderSn);
  753. }
  754. public int queryCountByMerchOrderSn(String merchOrderSn){
  755. return apiOrderMapper.queryCountByMerchOrderSn(merchOrderSn);
  756. }
  757. public int queryCountByPayId(String payId){
  758. return apiOrderMapper.queryCountByPayId(payId);
  759. }
  760. public List<OrderVo> queryOrderByMerchOrderSnAndRefundStatus(String merchOrderSn){
  761. return apiOrderMapper.queryOrderByMerchOrderSnAndRefundStatus(merchOrderSn);
  762. }
  763. }