ApiOrderService.java 31 KB

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