1
0

ApiOrderService.java 52 KB

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