OrderServiceImpl.java 137 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727
  1. package com.kmall.admin.service.impl;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.google.common.collect.ImmutableBiMap;
  4. import com.google.common.collect.Maps;
  5. import com.kmall.admin.dao.*;
  6. import com.kmall.admin.dao.alarm.Mall2LowPriceWarningDao;
  7. import com.kmall.admin.dao.mk.Mk2GoodsTopicPriceDao;
  8. import com.kmall.admin.dao.mk.Mk2MemberBirthdayDao;
  9. import com.kmall.admin.dao.mk.store.MkStorePromOrderRealDao;
  10. import com.kmall.admin.dao.mk.store.MkStorePromTypeDao;
  11. import com.kmall.admin.dao.mk.store.StoreTopicDao;
  12. import com.kmall.admin.dao.vip.Mall2MemberConsumptionRecordsDao;
  13. import com.kmall.admin.dao.vip.Mall2MemberPointsDao;
  14. import com.kmall.admin.dao.vip.Mall2PointsRulesDao;
  15. import com.kmall.admin.dto.OrderExpressDto;
  16. import com.kmall.admin.dto.OrderRecognitionDto;
  17. import com.kmall.admin.entity.*;
  18. import com.kmall.admin.entity.OrderProcessRecordEntity;
  19. import com.kmall.admin.entity.alarm.Mall2LowPriceWarningEntity;
  20. import com.kmall.admin.entity.mk.Mk2GoodsTopicPriceEntity;
  21. import com.kmall.admin.entity.mk.store.*;
  22. import com.kmall.admin.entity.vip.Mall2MemberConsumptionRecordsEntity;
  23. import com.kmall.admin.entity.vip.Mall2MemberPointsEntity;
  24. import com.kmall.admin.entity.vip.Mall2PointsRulesEntity;
  25. import com.kmall.admin.fromcomm.dao.SysConfigDao;
  26. import com.kmall.admin.service.*;
  27. import com.kmall.admin.service.mk.store.MkStoreCampMinusService;
  28. import com.kmall.admin.service.mk.store.MkStoreTicketDiscountService;
  29. import com.kmall.admin.websocket.WebSocketServer;
  30. import com.kmall.api.entity.*;
  31. import com.kmall.api.entity.mk.MkStoreTicketDiscountVo;
  32. import com.kmall.common.utils.ResponseData;
  33. import com.kmall.common.utils.wechat.WechatMicropayApiResult;
  34. import com.kmall.common.utils.wechat.WechatReverseApiResult;
  35. import com.kmall.manager.manager.alipay.AliPayMicropayApiResult;
  36. import com.kmall.manager.manager.alipay.AliPayRequestParams;
  37. import com.kmall.manager.manager.alipay.AliPayUtil;
  38. import com.kmall.manager.manager.express.sf.properties.SFPropertiesBuilder;
  39. import com.kmall.manager.manager.express.sf.properties.SFUtil;
  40. import com.kmall.manager.manager.express.sf.entity.SfRouteServiceResponseEntity;
  41. import com.kmall.manager.manager.express.sf.entity.RouteEntity;
  42. import com.kmall.manager.manager.express.sf.entity.RouteResponseEntity;
  43. import com.kmall.manager.manager.print.ticket.TicketPrintUtil;
  44. import com.kmall.manager.manager.wechat.WechatUtil;
  45. import com.kmall.manager.manager.wechat.wxglobal.dto.WechatGlobalRefundApiResult;
  46. import com.kmall.admin.utils.ShiroUtils;
  47. import com.kmall.common.constant.Dict;
  48. import com.kmall.manager.manager.merch.OmsMerchPropertiesBuilder;
  49. import com.kmall.api.util.CommonUtil;
  50. import com.kmall.admin.fromcomm.entity.SysUserEntity;
  51. import com.kmall.manager.manager.print.ticket.PrintTicketPropertiesBuilder;
  52. import com.kmall.common.utils.*;
  53. import com.kmall.common.utils.print.ticket.item.*;
  54. import com.kmall.manager.manager.express.kdn.KdniaoUtil;
  55. import com.kmall.common.utils.wechat.WechatRefundApiResult;
  56. import com.mysql.cj.util.TimeUtil;
  57. import org.slf4j.Logger;
  58. import org.slf4j.LoggerFactory;
  59. import org.springframework.beans.factory.annotation.Autowired;
  60. import org.springframework.stereotype.Service;
  61. import org.springframework.transaction.annotation.Transactional;
  62. import java.io.IOException;
  63. import java.io.UnsupportedEncodingException;
  64. import java.math.BigDecimal;
  65. import java.math.RoundingMode;
  66. import java.net.URLDecoder;
  67. import java.text.ParseException;
  68. import java.text.SimpleDateFormat;
  69. import java.util.*;
  70. import java.util.concurrent.TimeUnit;
  71. @Service("orderService")
  72. public class OrderServiceImpl implements OrderService {
  73. private final Logger LOGGER = LoggerFactory.getLogger(OrderServiceImpl.class);
  74. @Autowired
  75. private OrderDao orderDao;
  76. @Autowired
  77. private ShippingDao shippingDao;
  78. @Autowired
  79. private OrderGoodsDao orderGoodsDao;
  80. @Autowired
  81. private SysPrinterDao printerDao;
  82. @Autowired
  83. private UserDao userDao;
  84. @Autowired
  85. private UserCouponDao userCouponDao;
  86. @Autowired
  87. private ProductStoreRelaDao productStoreRelaDao;
  88. @Autowired
  89. private OrderProcessRecordDao orderProcessRecordDao;
  90. @Autowired
  91. private OrderRefundDao orderRefundDao;
  92. @Autowired
  93. private StoreDao storeDao;
  94. @Autowired
  95. private OfflineCartDao offlineCartDao;
  96. @Autowired
  97. private GoodsDao goodsDao;
  98. @Autowired
  99. private MerchDao merchDao;
  100. @Autowired
  101. private MngChangeDao mngChangeDao;
  102. @Autowired
  103. private StoreMngChangeDao storeMngChangeDao;
  104. @Autowired
  105. private ThirdMerchExpressDao thirdMerchExpressDao;
  106. @Autowired
  107. private MkStorePromOrderRealDao mkStorePromOrderRealDao;
  108. @Autowired
  109. private UserCampMinusDao userCampMinusDao;
  110. @Autowired
  111. private UserService userService;
  112. @Autowired
  113. private SysConfigDao sysConfigDao;
  114. @Autowired
  115. private ProductDao productDao;
  116. @Autowired
  117. private OrderWXPayRecordService orderWXPayRecordService;
  118. @Autowired
  119. private StoreService storeService;
  120. @Autowired
  121. private PickUpCodeService pickUpCodeService;
  122. @Autowired
  123. private MkStoreCampMinusService mkStoreCampMinusService;
  124. @Autowired
  125. private MkStoreTicketDiscountService mkStoreTicketDiscountService;
  126. @Autowired
  127. private CashierDao cashierDao; // 收银机查询
  128. @Autowired
  129. private CashierLoginRecordDao cashierLoginRecordDao; // 收银员登录记录
  130. @Autowired
  131. private SaleRecordDao saleRecordDao; // 销售记录
  132. @Autowired
  133. private StoreTopicDao storeTopicDao; // 查询是否有门店活动
  134. @Autowired
  135. private Mk2GoodsTopicPriceDao mk2GoodsTopicPriceDao; // 门店商品价格
  136. @Autowired
  137. private Mall2PointsRulesDao pointsRulesDao; // 积分规则
  138. @Autowired
  139. private Mall2MemberPointsDao memberPointsDao; // 用户积分
  140. @Autowired
  141. private Mall2MemberConsumptionRecordsDao memberConsumptionRecordsDao; // 会员消费记录
  142. @Autowired
  143. private MkStorePromTypeDao storePromTypeDao; // 优惠类型
  144. @Autowired
  145. private Mk2MemberBirthdayDao memberBirthdayDao; // 生日优惠
  146. @Autowired
  147. private MerchUserDao merchUserDao;
  148. @Autowired
  149. private Mall2LowPriceWarningDao lowPriceWarningDao;
  150. @Autowired
  151. private MkActivitiesCouponService mkActivitiesCouponService;
  152. @Autowired
  153. private OrderRefundService orderRefundService;
  154. @Autowired
  155. private OrderExceptionRecordService orderExceptionRecordService;
  156. @Override
  157. public OrderEntity queryObject(Long id) {
  158. return orderDao.queryObject(id);
  159. }
  160. @Override
  161. public Double getTotalActualPrice(String merchOrderSn) {
  162. return orderDao.getTotalActualPrice(merchOrderSn);
  163. }
  164. @Override
  165. public List<OrderEntity> queryList(Map<String, Object> map) {
  166. return orderDao.queryList(map);
  167. }
  168. @Override
  169. public int queryTotal(Map<String, Object> map) {
  170. return orderDao.queryTotal(map);
  171. }
  172. @Override
  173. public int save(OrderEntity order) {
  174. return orderDao.save(order);
  175. }
  176. @Override
  177. public int update(OrderEntity order) {
  178. return orderDao.update(order);
  179. }
  180. /**
  181. * 取消订单
  182. *
  183. * @param order
  184. */
  185. @Override
  186. public void cancelOrder(OrderEntity order) {
  187. boolean needUpdateStock = true;
  188. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  189. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_101.getItem()));
  190. }
  191. orderDao.update(order);
  192. if (!needUpdateStock) {
  193. return;
  194. }
  195. // 更新库存
  196. updateStock(order, "管理后台取消订单");
  197. // 释放优惠券
  198. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  199. if (null != couponVo) {
  200. userCouponDao.cancelOrder(couponVo);
  201. }
  202. //释放促销满减券
  203. UserCampMinusEntity userCampMinusVo = userCampMinusDao.queryUserCampByOrderId(order.getId());
  204. if (null != userCampMinusVo) {
  205. userCampMinusDao.cancelUserCampOrder(userCampMinusVo);
  206. }
  207. }
  208. @Override
  209. public int delete(Long id) {
  210. return orderDao.delete(id);
  211. }
  212. @Override
  213. public int deleteBatch(Long[] ids) {
  214. return orderDao.deleteBatch(ids);
  215. }
  216. @Override
  217. public int confirm(Long id) {
  218. OrderEntity orderEntity = queryObject(id);
  219. Integer shippingStatus = orderEntity.getShippingStatus();//发货状态
  220. Integer payStatus = orderEntity.getPayStatus();//付款状态
  221. if (2 != payStatus) {
  222. throw new RRException("此订单未付款,不能确认收货!");
  223. }
  224. if (4 == shippingStatus) {
  225. throw new RRException("此订单处于退货状态,不能确认收货!");
  226. }
  227. if (0 == shippingStatus) {
  228. throw new RRException("此订单未发货,不能确认收货!");
  229. }
  230. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  231. throw new RRException("此订单已完成!");
  232. }
  233. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  234. throw new RRException("此订单待付款!");
  235. }
  236. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_100.getItem())) {
  237. throw new RRException("此订单付款中!");
  238. }
  239. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  240. throw new RRException("此订单已取消!");
  241. }
  242. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  243. throw new RRException("此订单已删除!");
  244. }
  245. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  246. throw new RRException("此订单还未发货!");
  247. }
  248. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem())) {
  249. throw new RRException("此订单已退款!");
  250. }
  251. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  252. throw new RRException("此订单已退款!");
  253. }
  254. orderEntity.setShippingStatus(2);
  255. orderEntity.setOrderStatus(301);
  256. orderEntity.setConfirmTime(new Date());
  257. orderDao.update(orderEntity);
  258. return 0;
  259. }
  260. @Override
  261. public int sendGoods(OrderEntity order) {
  262. Integer payStatus = order.getPayStatus();//付款状态
  263. if (2 != payStatus) {
  264. throw new RRException("此订单未付款!");
  265. }
  266. ShippingEntity shippingEntity = shippingDao.queryObject(order.getShippingId());
  267. if (null != shippingEntity) {
  268. order.setShippingName(shippingEntity.getName());
  269. }
  270. order.setOrderStatus(300);//订单已发货
  271. order.setShippingStatus(1);//已发货
  272. return orderDao.update(order);
  273. }
  274. @Override
  275. public Ticket printMsg(Long id) {
  276. OrderEntity orderEntity = queryInfos(id);
  277. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  278. // 获取门店
  279. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  280. // 获取清关信息
  281. OrderProcessRecordEntity orderProcessRecordEntity =
  282. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  283. // 小票头
  284. TicketHead head = new TicketHead();
  285. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  286. // head.setMemberId(orderEntity.getUserName().toString());
  287. head.setOrderId(orderEntity.getOrderSn());
  288. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  289. // 商品信息
  290. Integer goodsTotal = 0; // 商品总个数
  291. BigDecimal total = Constant.ZERO; // 商品总计
  292. BigDecimal taxTotal = Constant.ZERO; //税费总计
  293. List<Goods> goodsList = new ArrayList<>();
  294. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  295. goodsTotal += orderGoods.getNumber();
  296. total = total.add(orderGoods.getMarketPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  297. .setScale(2, BigDecimal.ROUND_HALF_UP);
  298. taxTotal = taxTotal.add(orderGoods.getGoodsRate().multiply(orderGoods.getMarketPrice()).setScale(2, BigDecimal.ROUND_HALF_UP));
  299. Goods goods = new Goods(orderGoods.getGoodsName(), orderGoods.getMarketPrice().toString(),
  300. orderGoods.getGoodsRate().multiply(orderGoods.getMarketPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString(),
  301. orderGoods.getNumber().toString(),
  302. orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber()))
  303. .setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  304. goodsList.add(goods);
  305. }
  306. // 收银信息
  307. CashInfo cashInfo = new CashInfo();
  308. cashInfo.setGoodsTotal(goodsTotal.toString());
  309. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  310. cashInfo.setTaxTotal(taxTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  311. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  312. cashInfo.setOddChange("0.00");
  313. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  314. cashInfo.setFreight(
  315. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  316. cashInfo.setPaymentMode("微信支付");
  317. // 海关清单
  318. CusListing cusListing = new CusListing();
  319. cusListing.setOrderId(orderEntity.getOrderSn());
  320. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  321. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  322. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  323. cusListing.setConsignee(orderEntity.getConsignee());
  324. cusListing.setConsigneeTel(orderEntity.getMobile());
  325. }
  326. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  327. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  328. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  329. }
  330. @Override
  331. public Ticket printMsg(Long id, String sessionId) {
  332. OrderEntity orderEntity = queryInfos(id);
  333. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  334. // 获取门店
  335. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  336. // 获取清关信息
  337. OrderProcessRecordEntity orderProcessRecordEntity =
  338. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  339. // 小票头
  340. TicketHead head = new TicketHead();
  341. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  342. // head.setMemberId(orderEntity.getUserName().toString());
  343. head.setOrderId(orderEntity.getOrderSn());
  344. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  345. // 商品信息
  346. Integer goodsTotal = 0; // 商品总个数
  347. BigDecimal total = Constant.ZERO; // 商品总计
  348. BigDecimal taxTotal = Constant.ZERO; //税费总计
  349. List<Goods> goodsList = new ArrayList<>();
  350. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  351. goodsTotal += orderGoods.getNumber();
  352. total = total.add(orderGoods.getMarketPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  353. .setScale(2, BigDecimal.ROUND_HALF_UP);
  354. taxTotal = taxTotal.add(orderGoods.getGoodsRate().multiply(orderGoods.getMarketPrice()).setScale(2, BigDecimal.ROUND_HALF_UP));
  355. Goods goods = new Goods(orderGoods.getGoodsName(), orderGoods.getMarketPrice().toString(),
  356. orderGoods.getGoodsRate().multiply(orderGoods.getMarketPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString(),
  357. orderGoods.getNumber().toString(),
  358. orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber()))
  359. .setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  360. goodsList.add(goods);
  361. }
  362. // 收银信息
  363. CashInfo cashInfo = new CashInfo();
  364. cashInfo.setGoodsTotal(goodsTotal.toString());
  365. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  366. cashInfo.setTaxTotal(taxTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  367. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  368. cashInfo.setOddChange("0.00");
  369. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  370. cashInfo.setFreight(
  371. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  372. cashInfo.setPaymentMode("支付宝支付");
  373. // 海关清单
  374. CusListing cusListing = new CusListing();
  375. cusListing.setOrderId(orderEntity.getOrderSn());
  376. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  377. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  378. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  379. cusListing.setConsignee(orderEntity.getConsignee());
  380. cusListing.setConsigneeTel(orderEntity.getMobile());
  381. }
  382. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  383. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  384. // 尝试在取货码表中查询数据,如果有的话就改变状态
  385. String orderSn = orderEntity.getOrderSn();
  386. PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(orderSn);
  387. if(pickUpCodeEntity != null){
  388. pickUpCodeEntity.setPickUpCodeStatus("1");
  389. pickUpCodeService.update(pickUpCodeEntity);
  390. // try {
  391. // WebSocketServer.delete(sessionId,orderEntity.getStoreId(),pickUpCodeEntity);
  392. // } catch (IOException e) {
  393. // e.printStackTrace();
  394. // }
  395. }
  396. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  397. }
  398. /**
  399. * 退款
  400. */
  401. @Transactional
  402. public void refund(OrderEntity order) {
  403. boolean needUpdateStock = true;
  404. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  405. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  406. }
  407. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  408. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  409. }
  410. orderDao.update(order);//修改为退款中
  411. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  412. /*// 判断是否有优惠券
  413. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  414. if (null != couponVo) {
  415. userCouponDao.cancelOrder(couponVo);
  416. }
  417. if (!needUpdateStock) {
  418. return;
  419. }
  420. // 更新库存
  421. updateStock(order, "管理后台订单退款");*/
  422. // updateStock(order, "管理后台订单退款");
  423. queryStorePromRealUpdateIsScan(order);
  424. }
  425. /**
  426. * 退款
  427. */
  428. @Transactional
  429. public void refund(OrderEntity order, WechatRefundApiResult result) {
  430. boolean needUpdateStock = true;
  431. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  432. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  433. }
  434. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  435. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  436. }else{
  437. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  438. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  439. OrderRefundEntity orderRefund = new OrderRefundEntity();
  440. orderRefund.setRefundId(result.getRefund_id());
  441. orderRefund.setOutRefundNo(result.getOut_refund_no());
  442. orderRefund
  443. .setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  444. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  445. orderRefund.setModTime(new Date());
  446. if (mallOrderRefund != null) {
  447. orderRefund.setId(mallOrderRefund.getId());
  448. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  449. orderRefundDao.update(orderRefund);
  450. } else {
  451. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  452. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  453. orderRefund.setCreateTime(new Date());
  454. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  455. if(list.size()>1){//多条订单
  456. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  457. }else{
  458. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  459. }
  460. orderRefundDao.save(orderRefund);//退款记录
  461. }
  462. }
  463. orderDao.update(order);//修改为退款中
  464. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  465. /*// 判断是否有优惠券
  466. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  467. if (null != couponVo) {
  468. userCouponDao.cancelOrder(couponVo);
  469. }
  470. if (!needUpdateStock) {
  471. return;
  472. }
  473. // 更新库存
  474. updateStock(order, "管理后台订单退款");*/
  475. // updateStock(order, "管理后台订单退款");
  476. queryStorePromRealUpdateIsScan(order);
  477. }
  478. @Transactional
  479. public void refund(OrderEntity order, AliPayMicropayApiResult result) {
  480. boolean needUpdateStock = true;
  481. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  482. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  483. }
  484. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  485. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  486. }else{
  487. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  488. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  489. OrderRefundEntity orderRefund = new OrderRefundEntity();
  490. orderRefund.setRefundId(result.getTradeNo());
  491. orderRefund.setOutRefundNo(result.getOutTradeNo());
  492. orderRefund
  493. .setRefundMoney(new BigDecimal(result.getRefundFee()).divide(Constant.ONE_HUNDRED));
  494. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_2.getItem()));//退款处理中
  495. orderRefund.setModTime(new Date());
  496. if (mallOrderRefund != null) {
  497. orderRefund.setId(mallOrderRefund.getId());
  498. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  499. orderRefundDao.update(orderRefund);
  500. } else {
  501. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  502. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  503. orderRefund.setCreateTime(new Date());
  504. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  505. if(list.size()>1){//多条订单
  506. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  507. }else{
  508. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  509. }
  510. orderRefundDao.save(orderRefund);//退款记录
  511. }
  512. }
  513. orderDao.update(order);//修改为退款中
  514. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  515. /*// 判断是否有优惠券
  516. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  517. if (null != couponVo) {
  518. userCouponDao.cancelOrder(couponVo);
  519. }
  520. if (!needUpdateStock) {
  521. return;
  522. }
  523. // 更新库存
  524. updateStock(order, "管理后台订单退款");*/
  525. // updateStock(order, "管理后台订单退款");
  526. // queryStorePromRealUpdateIsScan(order);
  527. }
  528. /**
  529. * 平安退款逻辑处理
  530. * @param order
  531. * @param result
  532. */
  533. @Transactional
  534. public void pinganRefund(OrderEntity order, net.sf.json.JSONObject result, String refundId) {
  535. boolean needUpdateStock = true;
  536. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  537. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  538. }
  539. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  540. OrderRefundEntity orderRefund = new OrderRefundEntity();
  541. orderRefund.setRefundId(refundId);
  542. orderRefund.setOutRefundNo(result.getString("ord_no"));
  543. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  544. orderRefund.setModTime(new Date());
  545. orderRefund.setRefundMoney(BigDecimal.valueOf(result.getInt("trade_amount")).divide(Constant.ONE_HUNDRED));
  546. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  547. if (mallOrderRefund != null) {
  548. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  549. orderRefund.setId(mallOrderRefund.getId());
  550. orderRefundDao.update(orderRefund);
  551. } else {//退款记录不存在
  552. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  553. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  554. orderRefund.setCreateTime(new Date());
  555. orderRefundDao.save(orderRefund);//退款记录
  556. }
  557. orderDao.update(order);//修改为退款中
  558. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  559. /*// 判断是否有优惠券
  560. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  561. if (null != couponVo) {
  562. userCouponDao.cancelOrder(couponVo);
  563. }
  564. if (!needUpdateStock) {
  565. return;
  566. }
  567. // 更新库存
  568. updateStock(order, "管理后台平安退款订单");*/
  569. queryStorePromRealUpdateIsScan(order);
  570. }
  571. /**
  572. * 微信国际退款逻辑处理
  573. * @param order
  574. * @param result
  575. */
  576. @Transactional
  577. public void globalRefund(OrderEntity order, WechatGlobalRefundApiResult result) {
  578. boolean needUpdateStock = true;
  579. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  580. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  581. }
  582. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  583. OrderRefundEntity orderRefund = new OrderRefundEntity();
  584. orderRefund.setRefundId(result.getRefund_id());
  585. orderRefund.setOutRefundNo(result.getOut_refund_no());
  586. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  587. orderRefund.setModTime(new Date());
  588. orderRefund.setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  589. orderRefund.setRefundFeeType(result.getRefund_fee_type());
  590. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getTotal_fee())) {
  591. orderRefund.setTotalFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getTotal_fee())).divide(Constant.ONE_HUNDRED).toString()));
  592. }
  593. orderRefund.setFeeType(result.getFee_type());
  594. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_fee())) {
  595. orderRefund.setCashFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_fee())).divide(Constant.ONE_HUNDRED).toString()));
  596. }
  597. orderRefund.setCashFeeType(result.getCash_fee_type());
  598. if(org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_refund_fee())) {
  599. orderRefund.setCashRefundFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_refund_fee())).divide(Constant.ONE_HUNDRED).toString()));
  600. }
  601. orderRefund.setCashRefundFeeType(result.getCash_refund_fee_type());
  602. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  603. if (mallOrderRefund != null) {
  604. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  605. orderRefund.setId(mallOrderRefund.getId());
  606. orderRefundDao.update(orderRefund);
  607. } else {//退款记录不存在
  608. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  609. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  610. orderRefund.setCreateTime(new Date());
  611. orderRefundDao.save(orderRefund);//退款记录
  612. }
  613. orderDao.update(order);//修改为退款中
  614. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  615. /*// 判断是否有优惠券
  616. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  617. if (null != couponVo) {
  618. userCouponDao.cancelOrder(couponVo);
  619. }
  620. if (!needUpdateStock) {
  621. return;
  622. }
  623. // 更新库存
  624. updateStock(order, "管理后台微信国际退款订单");*/
  625. queryStorePromRealUpdateIsScan(order);
  626. }
  627. private void updateStock(OrderEntity order, String changeReason){
  628. Map<String, Object> map = new HashMap();
  629. SysUserEntity user = ShiroUtils.getUserEntity();
  630. map.put("orderId", order.getId());
  631. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryList(map);
  632. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  633. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  634. .queryByStoreIdProductId(Long.valueOf(order.getStoreId()),Long.valueOf(orderGoodsEntity.getProductId()));
  635. if (null == storeRelaEntity || null == storeRelaEntity.getSellVolume()) {
  636. storeRelaEntity.setSellVolume(0);
  637. }
  638. BigDecimal sellVolume = new BigDecimal(storeRelaEntity.getSellVolume() - orderGoodsEntity.getNumber());//销售量
  639. if (sellVolume.compareTo(Constant.ZERO) < 0) {
  640. sellVolume = Constant.ZERO;
  641. }
  642. Integer stockNum = 0;
  643. GoodsEntity goodsEntity = goodsDao.queryObject(orderGoodsEntity.getGoodsId());
  644. if(goodsEntity != null){
  645. stockNum = goodsEntity.getGoodsNumber();
  646. //还原商户商品库存
  647. resetGoodsStock(stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);
  648. }
  649. if (null != storeRelaEntity.getStockNum()) {
  650. stockNum = storeRelaEntity.getStockNum();
  651. //普通商品不受共享库存影响,直接取门店配置库存
  652. //该商品所属第三方商户不是共享库存
  653. if(goodsEntity.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_0.getItem())) {
  654. resetStoreGoodsStock(stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);//还原门店库存
  655. }else{
  656. //该商品所属第三方商户是共享库存,但商品业务类型不是00保税备货
  657. if(!goodsEntity.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())){
  658. resetStoreGoodsStock(stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);//还原门店库存
  659. }
  660. }
  661. }
  662. //该商品所属第三方商户为共享库存,且是保税备货商品,取消订单时改变
  663. updateGoodsByIsShareStock(goodsEntity);
  664. }
  665. }
  666. /**
  667. * 更新商品库存数量变化后是否已共享为0“未共享”
  668. * @param goodsInfo
  669. */
  670. private void updateGoodsByIsShareStock(GoodsEntity goodsInfo){
  671. //该商品所属第三方商户为共享库存,且是保税备货商品
  672. if(goodsInfo.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_1.getItem())
  673. && goodsInfo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())) {
  674. GoodsEntity goodsVo = new GoodsEntity();
  675. goodsVo.setId(goodsInfo.getId());
  676. //商品库存数量变化后是否已共享,0:否,1:是(下单、退款、取消订单触发)
  677. goodsVo.setIsGoodsShareStock(Dict.isGoodsShareStock.item_0.getItem());
  678. goodsDao.update(goodsVo);
  679. }
  680. }
  681. /**
  682. * 还原商品总库存
  683. * @param stockNum
  684. * @param storeRelaEntity
  685. * @param orderGoodsEntity
  686. * @param sellVolume
  687. * @param changeReason
  688. * @param user
  689. */
  690. private void resetGoodsStock(Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  691. OrderGoodsEntity orderGoodsEntity, BigDecimal sellVolume, String changeReason, SysUserEntity user){
  692. GoodsEntity goodsEntity = goodsDao.queryObject(storeRelaEntity.getGoodsId());
  693. if(goodsEntity!=null){
  694. goodsEntity.setGoodsNumber(stockNum + orderGoodsEntity.getNumber());
  695. // goodsEntity.setSellVolume(Integer.parseInt(goodsSellVolume.toString()));
  696. goodsDao.update(goodsEntity);
  697. // storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString()));
  698. // productStoreRelaDao.update(storeRelaEntity);
  699. MngChangeEntity mngChangeEntity = new MngChangeEntity();
  700. mngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(goodsEntity.getId())));
  701. mngChangeEntity.setThirdPartyMerchCode(goodsEntity.getThirdPartyMerchCode());
  702. mngChangeEntity.setChangeReason(changeReason);
  703. mngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  704. mngChangeEntity.setChangeNum(orderGoodsEntity.getNumber());//变化数
  705. mngChangeEntity.setOriginalNum(stockNum);//原库存数
  706. mngChangeEntity.setValidNum(stockNum + orderGoodsEntity.getNumber());//可用数
  707. mngChangeEntity.setCreateTime(new Date());
  708. mngChangeEntity.setModTime(new Date());
  709. mngChangeEntity.setCreaterSn(user.getUsername());
  710. mngChangeEntity.setModerSn(user.getUsername());
  711. mngChangeEntity.setIsValid(0);
  712. mngChangeEntity.setMerchSn(goodsEntity.getMerchSn());
  713. mngChangeDao.save(mngChangeEntity);
  714. }
  715. }
  716. /**
  717. * 还原门店商品库存
  718. * @param stockNum
  719. * @param storeRelaEntity
  720. * @param orderGoodsEntity
  721. * @param sellVolume
  722. * @param changeReason
  723. * @param user
  724. */
  725. private void resetStoreGoodsStock(Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  726. OrderGoodsEntity orderGoodsEntity, BigDecimal sellVolume, String changeReason, SysUserEntity user){
  727. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString()));
  728. storeRelaEntity.setStockNum(stockNum + orderGoodsEntity.getNumber());//库存数量
  729. productStoreRelaDao.update(storeRelaEntity);
  730. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  731. storeMngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  732. storeMngChangeEntity.setChangeReason(changeReason);
  733. storeMngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(storeRelaEntity.getGoodsId())));
  734. storeMngChangeEntity.setStoreId(Integer.parseInt(String.valueOf(storeRelaEntity.getStoreId())));
  735. storeMngChangeEntity.setMerchSn(storeRelaEntity.getMerchSn());
  736. storeMngChangeEntity.setStoreChangeNum(orderGoodsEntity.getNumber());
  737. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  738. storeMngChangeEntity.setStoreValidNum(stockNum + orderGoodsEntity.getNumber());
  739. storeMngChangeEntity.setCreateTime(new Date());
  740. storeMngChangeEntity.setModTime(new Date());
  741. storeMngChangeEntity.setCreaterSn(user.getUsername());
  742. storeMngChangeEntity.setModerSn(user.getUsername());
  743. storeMngChangeEntity.setIsValid(0);
  744. storeMngChangeDao.save(storeMngChangeEntity);
  745. }
  746. /**
  747. * 查询该退款订单编号是否是推广渠道订单,是则修改渠道定时扫描状态
  748. * @param orderInfo
  749. */
  750. private void queryStorePromRealUpdateIsScan(OrderEntity orderInfo){
  751. Map map = new HashMap();
  752. map.put("orderId", orderInfo.getId());
  753. List<MkStorePromOrderRealEntity> list = mkStorePromOrderRealDao.queryPromRealListByMap(map);
  754. if(list.size() > 0) {
  755. for (MkStorePromOrderRealEntity mkStorePromOrderRealEntity : list) {
  756. mkStorePromOrderRealEntity.setIsPromStatScan(Dict.isDistSellScan.item_0.getItem());
  757. mkStorePromOrderRealDao.update(mkStorePromOrderRealEntity);
  758. }
  759. }
  760. }
  761. /**
  762. * 处理用户退款申请
  763. *
  764. * @param orderInfo
  765. */
  766. @Transactional
  767. public void applyRefundDeal(OrderEntity orderInfo, OrderRefundEntity refundEntity) {
  768. refundEntity.setApprovalTime(new Date());
  769. // refundEntity.setApprover(ShiroUtils.getUserId());
  770. // 退积分
  771. try {
  772. Integer integral = 1;
  773. if (orderInfo.getActualPrice().intValue() > 0) {
  774. integral = orderInfo.getActualPrice().intValue();
  775. }
  776. if (refundEntity.getRefundStatus() == 2) {
  777. orderInfo.setOrderStatus(401);
  778. // UserEntity entity = userDao.queryObject(orderInfo.getUserId());
  779. } else {
  780. orderInfo.setOrderStatus(201);
  781. }
  782. } catch (Exception e) {
  783. e.printStackTrace();
  784. }
  785. orderRefundDao.update(refundEntity);
  786. orderDao.update(orderInfo);
  787. }
  788. @Override
  789. public OrderRefundEntity queryRefundObject(Long refundId) {
  790. return orderRefundDao.queryObject(refundId);
  791. }
  792. @Override
  793. public List<OrderRefundEntity> queryRefundList(Map<String, Object> map) {
  794. return orderRefundDao.queryList(map);
  795. }
  796. @Override
  797. public int queryRefundTotal(Map<String, Object> map) {
  798. return orderRefundDao.queryTotal(map);
  799. }
  800. @Override
  801. public int getUserOrderInfo(Map<String, Object> map) {
  802. int result = 0;
  803. String type = (String) map.get("type");
  804. if ("yfkOrderUserSum".equals(type)) {
  805. result = orderDao.getYfkOrderUserSum(map);
  806. } else if ("oderUserSum".equals(type)) {
  807. result = orderDao.getOderUserSum(map);
  808. } else if ("todayUserOrder".equals(type)) {
  809. result = orderDao.getTodayUserOrder(map);
  810. } else if ("todayUserSales".equals(type)) {
  811. result = orderDao.getTodayUserSales(map);
  812. } else if ("incomeSum".equals(type)) {
  813. result = orderDao.getIncomeSum(map);
  814. } else if ("payedOrderCount".equals(type)) {
  815. result = orderDao.getPayedOrderCount(map);
  816. }
  817. return result;
  818. }
  819. @Override
  820. public Map getLogistics(Long id) {
  821. OrderEntity orderEntity = queryObject(id);
  822. if (orderEntity == null) {
  823. throw new RRException("此订单不存在!");
  824. }
  825. if (orderEntity.getShippingStatus() == 0) {
  826. if (orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem()) ||
  827. orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())) {
  828. throw new RRException("此订单还未发货!");
  829. } else {
  830. if (StringUtils.isNullOrEmpty(orderEntity.getShippingNo())) {
  831. throw new RRException("此订单还未发货!");
  832. }
  833. }
  834. }
  835. Map logisticsInfo = Maps.newHashMap();
  836. List<WuliuEntity> wuliuEntityList = new ArrayList<>();
  837. OrderProcessRecordEntity orderProcessRecordEntity =
  838. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  839. if (orderProcessRecordEntity != null) {
  840. if (orderEntity.getOrderBizType().equals(Dict.orderBizType.item_10.getItem()) ||
  841. orderEntity.getOrderBizType().equals(Dict.orderBizType.item_02.getItem())) {
  842. WuliuEntity wuliuEntity = new WuliuEntity();
  843. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  844. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  845. wuliuEntity.setAcceptStation(PrintTicketPropertiesBuilder.instance().getAddress() + "送达" +
  846. storeDao.queryObject(orderEntity.getStoreId()).getStoreAddress() +
  847. ";交易完成,用户已提走");
  848. wuliuEntityList.add(wuliuEntity);
  849. }
  850. if (StringUtils.isNotEmpty(orderEntity.getShippingCode()) &&
  851. StringUtils.isNotEmpty(orderEntity.getShippingNo()) &&
  852. orderProcessRecordEntity.getShipmentStartTime() != null) {
  853. if(orderEntity.getShippingCode().equalsIgnoreCase("SF")){
  854. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  855. if(storeEntity == null){
  856. throw new RRException("查询顺丰订单异常,订单的门店信息不存在");
  857. }
  858. ThirdMerchExpressEntity thirdMerchExpressEntity = thirdMerchExpressDao.getThirdMerchExpressByThirdCode(storeEntity.getThirdPartyMerchCode());
  859. if(thirdMerchExpressEntity == null){
  860. throw new RRException("查询顺丰订单异常,缺失商户快递账号信息");
  861. }
  862. SfRouteServiceResponseEntity entity = SFUtil.routeService(orderEntity.getShippingNo(), thirdMerchExpressEntity.getExpressAccount(),
  863. thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());
  864. // SfRouteServiceResponseEntity entity = SFUtil.routeService("254355029325", thirdMerchExpressEntity.getExpressAccount(),
  865. // thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());//444072971585
  866. if(entity.getHead().equalsIgnoreCase("OK")){
  867. if(entity.getBody() == null){
  868. WuliuEntity wuliuEntity = new WuliuEntity();
  869. wuliuEntity.setAcceptStation("暂无物流轨迹");
  870. wuliuEntityList.add(wuliuEntity);
  871. }else{
  872. if(entity.getBody().getRouteResponse() == null){
  873. WuliuEntity wuliuEntity = new WuliuEntity();
  874. wuliuEntity.setAcceptStation("暂无物流轨迹");
  875. wuliuEntityList.add(wuliuEntity);
  876. }else{
  877. RouteResponseEntity routeResponseEntity = entity.getBody().getRouteResponse().get(0);
  878. if(routeResponseEntity != null){
  879. List<RouteEntity> entityList = routeResponseEntity.getRouteResponse();
  880. for (RouteEntity route : entityList) {
  881. WuliuEntity wuliuEntity = new WuliuEntity();
  882. wuliuEntity.setAcceptTime(route.getAccept_time());
  883. wuliuEntity.setAcceptStation(route.getAccept_address() + route.getRemark());
  884. wuliuEntityList.add(wuliuEntity);
  885. }
  886. }
  887. }
  888. }
  889. }else{
  890. throw new RRException("查询顺丰订单异常,"+entity.getErrors());
  891. }
  892. }else{
  893. JSONObject traces =
  894. KdniaoUtil.getOrderTracesByJson(orderEntity.getShippingCode(), orderEntity.getShippingNo());
  895. List<Map> mapList = (List<Map>) traces.get("Traces");
  896. if (mapList != null && mapList.size() > 0) {
  897. for (Map map : mapList) {
  898. WuliuEntity wuliuEntity = new WuliuEntity();
  899. wuliuEntity.setAcceptTime(map.get("AcceptTime").toString());
  900. wuliuEntity.setAcceptStation(map.get("AcceptStation").toString());
  901. wuliuEntityList.add(wuliuEntity);
  902. }
  903. }
  904. String state = traces.get("State") + "";
  905. if (Dict.logisticsStatus.item_0.getItem().equals(state) && traces.getBoolean("Success")) {
  906. String reason = traces.get("Reason") + "";
  907. WuliuEntity wuliuEntity = new WuliuEntity();
  908. wuliuEntity.setAcceptStation(reason);
  909. wuliuEntityList.add(wuliuEntity);
  910. }
  911. }
  912. }
  913. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend()) &&
  914. orderProcessRecordEntity.getShipmentStartTime() != null) {
  915. WuliuEntity wuliuEntity = new WuliuEntity();
  916. wuliuEntity.setAcceptStation("订单已出库");
  917. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  918. .format(orderProcessRecordEntity.getShipmentStartTime()));
  919. wuliuEntityList.add(wuliuEntity);
  920. }
  921. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsCustomsSend())) {
  922. WuliuEntity wuliuEntity = new WuliuEntity();
  923. wuliuEntity.setAcceptStation("订单清关完成,等待仓库发货");
  924. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  925. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  926. wuliuEntityList.add(wuliuEntity);
  927. }
  928. if (Dict.isSend.item_0.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend())) {
  929. WuliuEntity wuliuEntity = new WuliuEntity();
  930. wuliuEntity.setAcceptStation("订单清关失败");
  931. wuliuEntityList.add(wuliuEntity);
  932. }
  933. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsEleOrderSend()) &&
  934. orderProcessRecordEntity.getWaybillSuccTime() != null) {
  935. WuliuEntity wuliuEntity = new WuliuEntity();
  936. wuliuEntity.setAcceptStation("海关三单发送成功");
  937. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  938. .format(orderProcessRecordEntity.getWaybillSuccTime()));
  939. wuliuEntityList.add(wuliuEntity);
  940. }
  941. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsPaymentSend())) {
  942. WuliuEntity wuliuEntity = new WuliuEntity();
  943. wuliuEntity.setAcceptStation("订单支付成功");
  944. wuliuEntity.setAcceptTime(
  945. new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(orderProcessRecordEntity.getPaySuccTime()));
  946. wuliuEntityList.add(wuliuEntity);
  947. }
  948. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsAddOrderSend())) {
  949. WuliuEntity wuliuEntity = new WuliuEntity();
  950. wuliuEntity.setAcceptStation("订单下单成功");
  951. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  952. .format(orderProcessRecordEntity.getAddOrderSuccTime()));
  953. wuliuEntityList.add(wuliuEntity);
  954. }
  955. }
  956. logisticsInfo.put("tracesList", wuliuEntityList);
  957. logisticsInfo.put("logisticCode", orderEntity.getShippingNo());
  958. logisticsInfo.put("shipperCode", orderEntity.getShippingCode());
  959. return logisticsInfo;
  960. }
  961. @Override
  962. public OrderEntity queryInfos(Long id) {
  963. OrderEntity orderEntity = orderDao.queryObject(id);
  964. Map<String, Object> map = new HashMap<String, Object>();
  965. map.put("orderId", id);
  966. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  967. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  968. return orderEntity;
  969. }
  970. /**
  971. * 普货商品生成线下订单
  972. * @param offlineCartList
  973. * @param user
  974. * @return
  975. */
  976. @Transactional
  977. @Override
  978. public Map orderSubmit(List<OfflineCartEntity> offlineCartList, SysUserEntity user) {
  979. Map resultObj = Maps.newHashMap();
  980. try {
  981. if (user == null) {
  982. resultObj.put("errno", 400);
  983. resultObj.put("errmsg", "用户登录超时,请重新登录");
  984. return resultObj;
  985. }
  986. if (!user.getRoleType().equalsIgnoreCase("2")) {
  987. resultObj.put("errno", 400);
  988. resultObj.put("errmsg", "该操作只允许店员账户操作");
  989. return resultObj;
  990. }
  991. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  992. resultObj.put("errno", 400);
  993. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  994. return resultObj;
  995. }
  996. Long userId = user.getUserId();
  997. Integer storeId = user.getStoreId();
  998. //获取要购买的商品
  999. Map param = Maps.newHashMap();
  1000. param.put("userId", userId);
  1001. param.put("storeId", storeId);
  1002. if (null == offlineCartList && offlineCartList.size() == 0) {
  1003. resultObj.put("errno", 400);
  1004. resultObj.put("errmsg", "购买商品数据为空");
  1005. return resultObj;
  1006. }
  1007. List<OfflineCartEntity> offlineCartEntityList = offlineCartDao.queryOfflineCartByBizType(param);
  1008. if (offlineCartEntityList.size() == 0 && offlineCartList.size() > 0) {
  1009. resultObj.put("errno", 0);
  1010. resultObj.put("errmsg", "该单已下单成功,请重新扫描商品进行购买");
  1011. return resultObj;
  1012. }
  1013. // 检查库存和更新库存
  1014. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  1015. GoodsEntity goodsEntity = goodsDao.queryObject(cartEntity.getGoodsId());
  1016. if (goodsEntity == null) {
  1017. resultObj.put("errno", 400);
  1018. resultObj.put("errmsg", "订单提交失败:商品不存在");
  1019. return resultObj;
  1020. }
  1021. //取得规格的信息,判断规格库存
  1022. ProductStoreRelaEntity productInfo = productStoreRelaDao
  1023. .queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(cartEntity.getGoodsId()));
  1024. synchronized (productInfo) {
  1025. if (null == productInfo || null == productInfo.getStockNum() ||
  1026. productInfo.getStockNum() < cartEntity.getNumber()) {
  1027. resultObj.put("errno", 400);
  1028. resultObj.put("errmsg", "库存不足,仅剩余" + productInfo.getStockNum());
  1029. return resultObj;
  1030. } else {
  1031. productInfo.setStockNum(productInfo.getStockNum() - cartEntity.getNumber());
  1032. productInfo.setStoreId(Long.valueOf(storeId));
  1033. productInfo.addSellVolume();
  1034. productStoreRelaDao.updateStockNum(productInfo);//修改普通商品库存
  1035. if(goodsEntity != null) {
  1036. goodsEntity.setGoodsNumber(goodsEntity.getGoodsNumber() - cartEntity.getNumber());
  1037. goodsDao.update(goodsEntity);
  1038. }
  1039. }
  1040. }
  1041. }
  1042. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  1043. OrderEntity order = setOrderVo(user, offlineCartEntityList, user.getMerchSn());
  1044. order.setStoreId(storeId);
  1045. order.setMerchOrderSn(merchOrderSn);
  1046. //开启事务,插入订单信息和订单商品
  1047. if (order != null) {
  1048. orderDao.save(order);
  1049. if (null == order.getId()) {
  1050. resultObj.put("errno", 400);
  1051. resultObj.put("errmsg", "订单提交失败");
  1052. return resultObj;
  1053. }
  1054. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  1055. OrderGoodsEntity orderGoodsEntity = setOrderGoodsVo(order, cartEntity);
  1056. //新增订单详情
  1057. orderGoodsDao.save(orderGoodsEntity);
  1058. }
  1059. //清空预订单商品临时表
  1060. offlineCartDao.deleteByUserId(userId);
  1061. Map orderInfoMap = Maps.newHashMap();
  1062. orderInfoMap.put("orderInfo", order);
  1063. resultObj.put("errno", 0);
  1064. resultObj.put("errmsg", "订单提交成功");
  1065. resultObj.put("data", orderInfoMap);
  1066. }
  1067. } catch (Exception e) {
  1068. e.printStackTrace();
  1069. resultObj.put("errno", 400);
  1070. resultObj.put("errmsg", "订单异常");
  1071. return resultObj;
  1072. }
  1073. return resultObj;
  1074. }
  1075. /**
  1076. * 设置订单数据
  1077. *
  1078. * @param loginUser
  1079. * @return
  1080. */
  1081. public OrderEntity setOrderVo(SysUserEntity loginUser, List<OfflineCartEntity> offlineCartEntityList,
  1082. String merchSn) {
  1083. OrderEntity orderInfo = new OrderEntity();
  1084. BigDecimal freightPrice = new BigDecimal(0.00);
  1085. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  1086. for (OfflineCartEntity offlineCartEntity : offlineCartEntityList) {
  1087. goodsTotalPrice = goodsTotalPrice
  1088. .add(offlineCartEntity.getRetailPrice().multiply(new BigDecimal(offlineCartEntity.getNumber())));
  1089. }
  1090. //订单价格计算:订单的总价+运费
  1091. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  1092. //查询未使用的优惠券
  1093. /*String couponName = "";
  1094. BigDecimal fullCutCouponDec = Constant.ZERO;
  1095. UserCouponVo couponVo = null;*/
  1096. BigDecimal couponPrice = new BigDecimal(0.00);
  1097. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  1098. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  1099. //商户(拼音首字母)+业务类型+编号
  1100. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  1101. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  1102. MerchEntity merchEntity = merchDao.findByMerchSn(merchSn);
  1103. String merchShortName = "";
  1104. if (merchEntity != null) {
  1105. merchShortName = merchEntity.getMerchShortName();
  1106. }
  1107. String orderSn = merchShortName + Dict.orderBizType.item_11.getItem() + CommonUtil.generateOrderNumber();
  1108. orderInfo.setOrderSn(orderSn);
  1109. orderInfo.setMerchSn(merchSn);
  1110. orderInfo.setUserId(Integer.parseInt(loginUser.getUserId() + ""));
  1111. orderInfo.setFreightPrice(freightPrice.intValue());
  1112. orderInfo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  1113. /*orderInfo.setCoupon_id(userCouponId);
  1114. orderInfo.setCoupon_name(couponName);*/
  1115. // orderInfo.setFullCutPrice(fullCutCouponDec);//使用的优惠券
  1116. orderInfo.setCouponPrice(couponPrice);
  1117. orderInfo.setPostscript("");//留言
  1118. orderInfo.setAddTime(new Date());
  1119. orderInfo.setGoodsPrice(goodsTotalPrice);
  1120. orderInfo.setOrderPrice(orderTotalPrice);
  1121. orderInfo.setActualPrice(actualPrice);
  1122. orderInfo.setOrderType("1");
  1123. orderInfo.setOrderStatus(0);// 待付款
  1124. orderInfo.setShippingStatus(0);
  1125. orderInfo.setPayStatus(0);
  1126. orderInfo.setShippingId(0L);
  1127. orderInfo.setShippingFee(Constant.ZERO);
  1128. orderInfo.setIntegral(0);
  1129. orderInfo.setIntegralMoney(Constant.ZERO);
  1130. orderInfo.setCreateTime(new Date());
  1131. orderInfo.setModTime(new Date());
  1132. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());//线下购买
  1133. /*//标记该订单已使用优惠券
  1134. if(couponVo != null){
  1135. couponVo.setUsed_time(new Date());
  1136. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  1137. apiUserCouponMapper.update(couponVo);
  1138. }*/
  1139. return orderInfo;
  1140. }
  1141. /**
  1142. * 设置订单数据
  1143. *
  1144. * @param
  1145. * @return
  1146. */
  1147. public OrderEntity setOrder(Integer userId, List<LinkedHashMap> goodsList,
  1148. String merchSn) {
  1149. OrderEntity orderInfo = new OrderEntity();
  1150. BigDecimal freightPrice = new BigDecimal(0.00);
  1151. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  1152. for (LinkedHashMap goods : goodsList) {
  1153. goodsTotalPrice = goodsTotalPrice
  1154. .add(new BigDecimal( goods.get("retailPrice").toString()).multiply(new BigDecimal( goods.get("sellVolume").toString())));
  1155. }
  1156. //订单价格计算:订单的总价+运费
  1157. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  1158. //查询未使用的优惠券
  1159. /*String couponName = "";
  1160. BigDecimal fullCutCouponDec = Constant.ZERO;
  1161. UserCouponVo couponVo = null;*/
  1162. BigDecimal couponPrice = new BigDecimal(0.00);
  1163. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  1164. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  1165. //商户(拼音首字母)+业务类型+编号
  1166. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  1167. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  1168. MerchEntity merchEntity = merchDao.findByMerchSn(merchSn);
  1169. String merchShortName = "";
  1170. if (merchEntity != null) {
  1171. merchShortName = merchEntity.getMerchShortName();
  1172. }
  1173. String orderSn = merchShortName + Dict.orderBizType.item_10.getItem() + CommonUtil.generateOrderNumber();
  1174. orderInfo.setOrderSn(orderSn);
  1175. orderInfo.setMerchSn(merchSn);
  1176. orderInfo.setUserId(userId);
  1177. orderInfo.setFreightPrice(freightPrice.intValue());
  1178. orderInfo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  1179. /*orderInfo.setCoupon_id(userCouponId);
  1180. orderInfo.setCoupon_name(couponName);*/
  1181. // orderInfo.setFullCutPrice(fullCutCouponDec);//使用的优惠券
  1182. orderInfo.setCouponPrice(couponPrice);
  1183. orderInfo.setPostscript("");//留言
  1184. orderInfo.setAddTime(new Date());
  1185. orderInfo.setGoodsPrice(goodsTotalPrice);
  1186. orderInfo.setOrderPrice(orderTotalPrice);
  1187. orderInfo.setActualPrice(actualPrice);
  1188. orderInfo.setOrderType("1");
  1189. orderInfo.setOrderStatus(0);// 待付款
  1190. orderInfo.setShippingStatus(0);
  1191. orderInfo.setPayStatus(0);
  1192. orderInfo.setShippingId(0L);
  1193. orderInfo.setShippingFee(Constant.ZERO);
  1194. orderInfo.setIntegral(0);
  1195. orderInfo.setIntegralMoney(Constant.ZERO);
  1196. orderInfo.setCreateTime(new Date());
  1197. orderInfo.setModTime(new Date());
  1198. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());//线下购买
  1199. // orderInfo.setIsScan("0");//默认未扫描
  1200. /*//标记该订单已使用优惠券
  1201. if(couponVo != null){
  1202. couponVo.setUsed_time(new Date());
  1203. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  1204. apiUserCouponMapper.update(couponVo);
  1205. }*/
  1206. return orderInfo;
  1207. }
  1208. public OrderGoodsEntity setOrderGoodsVo(OrderEntity orderInfo, OfflineCartEntity goodsItem) {
  1209. GoodsEntity goodsVo = goodsDao.queryObject(goodsItem.getGoodsId());
  1210. OrderGoodsEntity orderGoodsVo = new OrderGoodsEntity();
  1211. orderGoodsVo.setOrderId(Integer.parseInt(orderInfo.getId() + ""));
  1212. orderGoodsVo.setGoodsId(goodsItem.getGoodsId());
  1213. orderGoodsVo.setGoodsSn(goodsItem.getGoodsSn());
  1214. orderGoodsVo.setProductId(goodsItem.getProductId());
  1215. orderGoodsVo.setGoodsName(goodsItem.getGoodsName());
  1216. orderGoodsVo.setListPicUrl(goodsItem.getListPicUrl());
  1217. orderGoodsVo.setMarketPrice(goodsItem.getMarketPrice());
  1218. orderGoodsVo.setRetailPrice(goodsItem.getRetailPrice());
  1219. orderGoodsVo.setNumber(goodsItem.getNumber());
  1220. orderGoodsVo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  1221. orderGoodsVo.setCreateTime(new Date());
  1222. orderGoodsVo.setModTime(new Date());
  1223. orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  1224. orderGoodsVo.setSku(goodsVo.getSku());
  1225. return orderGoodsVo;
  1226. }
  1227. // public OrderGoodsEntity setOrderGoods(OrderEntity orderInfo, LinkedHashMap goods) {
  1228. // GoodsEntity goodsVo = goodsDao.queryObject(goods.get("goodsId"));
  1229. // ProductEntity productEntity = productDao.queryObjectByGoodsIdAndStoreId(goodsVo.getId() + "", null);
  1230. // OrderGoodsEntity orderGoodsVo = new OrderGoodsEntity();
  1231. // orderGoodsVo.setOrderId(Integer.parseInt(orderInfo.getId() + ""));
  1232. // orderGoodsVo.setGoodsId(goodsVo.getId().intValue());
  1233. // orderGoodsVo.setGoodsSn(goodsVo.getGoodsSn());
  1234. // orderGoodsVo.setProductId(productEntity.getId().intValue());
  1235. // orderGoodsVo.setGoodsName(goodsVo.getName());
  1236. // orderGoodsVo.setListPicUrl(goodsVo.getListPicUrl());
  1237. //
  1238. //
  1239. // orderGoodsVo.setMarketPrice((BigDecimal) goods.get("storeMarketPrice"));
  1240. // orderGoodsVo.setRetailPrice((BigDecimal) goods.get("storeRetailPrice"));
  1241. // orderGoodsVo.setNumber((Integer) goods.get("sellVolume"));
  1242. // orderGoodsVo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  1243. // orderGoodsVo.setCreateTime(new Date());
  1244. // orderGoodsVo.setModTime(new Date());
  1245. // orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  1246. // orderGoodsVo.setSku(goodsVo.getSku());
  1247. //
  1248. //
  1249. // BigDecimal number = new BigDecimal(Long.valueOf(goodsItem.getNumber()));
  1250. // BigDecimal goodsTotal = goodsItem.getRetail_price().multiply(number);//单商品总价
  1251. // BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(),2, BigDecimal.ROUND_HALF_UP);//当前商品总价/订单总价(不含运费、不含优惠券)
  1252. // BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  1253. // BigDecimal settlePrice = Constant.ZERO;
  1254. // if(orderInfo.getFreight_price() != 0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  1255. // //运费-优惠券
  1256. // BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  1257. // //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 当前商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  1258. // settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  1259. // }else{
  1260. // if(orderInfo.getFreight_price()!=0){
  1261. // //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  1262. // BigDecimal freightRate = rate.multiply(freightPrice);
  1263. // //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  1264. // settlePrice = goodsTotal.add(freightRate);
  1265. // }
  1266. // if(!"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  1267. // //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  1268. // BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  1269. // //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  1270. // settlePrice = goodsTotal.subtract(couponRate);
  1271. // }
  1272. // }
  1273. // if(settlePrice.compareTo(BigDecimal.valueOf(0)) == 0){
  1274. // orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  1275. // }else{
  1276. // orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  1277. // }
  1278. //
  1279. // return orderGoodsVo;
  1280. // }
  1281. @Override
  1282. public OrderEntity queryObjectBySysUser(Long id) {
  1283. OrderEntity orderEntity = orderDao.queryObjectBySysUser(id);
  1284. Map<String, Object> map = new HashMap<String, Object>();
  1285. map.put("orderId", id);
  1286. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  1287. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  1288. return orderEntity;
  1289. }
  1290. @Override
  1291. public int confirmPay(Long id, String payFlag,String orderSnWx) {
  1292. SysUserEntity user = ShiroUtils.getUserEntity();
  1293. if (user == null) {
  1294. throw new RRException("用户登录超时,请重新登录");
  1295. }
  1296. if (!user.getRoleType().equalsIgnoreCase("2")) {
  1297. throw new RRException("该操作只允许店员账户操作");
  1298. }
  1299. OrderEntity orderEntity = queryObject(id);
  1300. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  1301. throw new RRException("此订单已付款!");
  1302. }
  1303. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  1304. throw new RRException("此订单已完成!");
  1305. }
  1306. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  1307. throw new RRException("此订单已取消!");
  1308. }
  1309. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  1310. throw new RRException("此订单已删除!");
  1311. }
  1312. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_201.getItem()));
  1313. orderEntity.setPayStatus(Integer.parseInt(Dict.payStatus.item_2.getItem()));
  1314. orderEntity.setPayFlag(payFlag);
  1315. orderEntity.setPayTime(new Date());
  1316. if(Dict.payFlag.item_alipay.getItem().equalsIgnoreCase(payFlag)){
  1317. orderEntity.setAliTradeNo(orderSnWx);
  1318. }else {
  1319. if (orderSnWx != null) {
  1320. orderEntity.setOrderSnWx(orderSnWx);
  1321. }
  1322. }
  1323. // Date now = new Date();
  1324. // Integer storeId = orderEntity.getStoreId();
  1325. // Map queryParams = new HashMap();
  1326. // queryParams.put("orderId", orderEntity.getId());
  1327. // List<OrderGoodsEntity> orderGoodsList = orderGoodsDao.queryList(queryParams);
  1328. // // 遍历订单下的详情商品,修改商品的最后销售时间
  1329. // if (orderGoodsList!=null && orderGoodsList.size()>0){
  1330. // orderGoodsList.forEach(orderGoods ->{
  1331. // Integer goodsId = orderGoods.getGoodsId();
  1332. // GoodsEntity goodsEntity = goodsDao.queryObject(goodsId);
  1333. // if (Objects.nonNull(goodsEntity)){
  1334. // goodsEntity.setLastSaleTime(now);
  1335. // goodsDao.update(goodsEntity);
  1336. // }
  1337. // if (Objects.nonNull(storeId)){
  1338. // ProductStoreRelaEntity productStoreRelaEntity = productStoreRelaDao.queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(goodsId));
  1339. // if (Objects.nonNull(productStoreRelaEntity)){
  1340. // productStoreRelaEntity.setLastSaleTime(now);
  1341. // productStoreRelaDao.update(productStoreRelaEntity);
  1342. // }
  1343. // }
  1344. // });
  1345. // }
  1346. orderDao.update(orderEntity);
  1347. return 0;
  1348. }
  1349. @Override
  1350. public List<OrderEntity> queryExportList(Map<String, Object> map) {
  1351. List<OrderEntity> list = orderDao.queryExportList(map);
  1352. for (OrderEntity order : list) {
  1353. OrderProcessRecordEntity orderProcessRecord = orderProcessRecordDao.queryObjectByOrderSn(order.getOrderSn());
  1354. order.setOrderProcessRecord(orderProcessRecord);
  1355. // 查询活动价
  1356. BigDecimal topicPrice = orderDao.queryTopicPriceByOrderSnAndSku(order.getOrderSn(),order.getSku());
  1357. order.setTopicPrice(topicPrice);
  1358. }
  1359. return list;
  1360. }
  1361. @Override
  1362. public List<OrderEntity> queryOffilineOrderList(Map<String, Object> map) {
  1363. return orderDao.queryOffilineOrderList(map);
  1364. }
  1365. @Override
  1366. public int uploadExcel(List<OrderExpressDto> orderExpressDtoList) {
  1367. SysUserEntity user = ShiroUtils.getUserEntity();
  1368. boolean isFail = false;
  1369. List<String> failShippingNameList = new ArrayList<>();
  1370. List<String> failOrderSnList = new ArrayList<>();
  1371. List<String> failShippingCodeList = new ArrayList<>();
  1372. List<String> failCodeSnList = new ArrayList<>();
  1373. List<String> failNameSnList = new ArrayList<>();
  1374. List<String> failStatusOrderSnList = new ArrayList<>();
  1375. if (orderExpressDtoList != null && orderExpressDtoList.size() > 0) {
  1376. for (int i = 0; i < orderExpressDtoList.size(); i++) {
  1377. OrderExpressDto orderExpressDto = orderExpressDtoList.get(i);
  1378. OrderEntity orderEntity = new OrderEntity();
  1379. Map<String, Object> valideDate = MapBeanUtil.fromObject(orderExpressDto);
  1380. ImmutableBiMap.Builder builder = new ImmutableBiMap.Builder();
  1381. builder.put("orderSn", "订单编号");
  1382. builder.put("shippingNo", "快递单号");
  1383. builder.put("shippingName", "快递公司");
  1384. builder.put("shippingCode", "快递简写");
  1385. R r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  1386. if (Integer.valueOf(r.get("code").toString()) != 0) {
  1387. throw new RRException(r.get("msg").toString());
  1388. } else {
  1389. r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  1390. if (Integer.valueOf(r.get("code").toString()) != 0) {
  1391. throw new RRException(r.get("msg").toString());
  1392. }
  1393. }
  1394. OrderEntity order = orderDao.queryObjectByOrderSn(orderExpressDto.getOrderSn());
  1395. if(order == null){
  1396. isFail = true;
  1397. failOrderSnList.add(orderExpressDto.getOrderSn());
  1398. }else{
  1399. if(!(order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())
  1400. && order.getPayStatus() == Integer.parseInt(Dict.payStatus.item_2.getItem()))){
  1401. isFail = true;
  1402. failStatusOrderSnList.add(orderExpressDto.getOrderSn());
  1403. }
  1404. }
  1405. ShippingEntity shippingEntity = shippingDao.queryObjectByCode(orderExpressDto.getShippingCode());
  1406. if(shippingEntity == null){
  1407. isFail = true;
  1408. failShippingCodeList.add(orderExpressDto.getShippingCode());
  1409. failCodeSnList.add(orderExpressDto.getOrderSn());
  1410. }else{
  1411. if(!orderExpressDto.getShippingName().equalsIgnoreCase(shippingEntity.getName())){
  1412. isFail = true;
  1413. failShippingNameList.add(orderExpressDto.getShippingName());
  1414. failNameSnList.add(orderExpressDto.getOrderSn());
  1415. }
  1416. }
  1417. if(!isFail){//false则有错误的数据
  1418. if(order != null) {// 修改商品
  1419. // orderEntity.setOrderSn(orderExpressDto.getOrderSn());
  1420. orderEntity.setShippingNo(orderExpressDto.getShippingNo());
  1421. orderEntity.setShippingCode(orderExpressDto.getShippingCode());
  1422. orderEntity.setShippingName(orderExpressDto.getShippingName());
  1423. orderEntity.setShippingStatus(Integer.parseInt(Dict.shippingStatus.item_1.getItem()));
  1424. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_300.getItem()));
  1425. orderEntity.setModerSn(user.getUsername());
  1426. orderEntity.setCreateTime(new Date());
  1427. orderEntity.setModTime(new Date());
  1428. orderEntity.setId(order.getId());
  1429. orderDao.update(orderEntity);
  1430. }
  1431. }
  1432. }
  1433. if(failOrderSnList != null && failOrderSnList.size() > 0){
  1434. throw new RRException("导入数据异常,订单编号不存在,不存在的订单编号【"+failOrderSnList+"】,请删除掉再继续操作");
  1435. }
  1436. if(failStatusOrderSnList != null && failStatusOrderSnList.size() > 0){
  1437. throw new RRException("导入数据异常,修改订单快递功能只支持已付款未发货的订单,以下订单编号无效【"+failStatusOrderSnList+"】,请删除掉再继续操作");
  1438. }
  1439. if(failShippingCodeList != null && failShippingCodeList.size() > 0){
  1440. throw new RRException("导入数据异常,快递简写不在可支持的范围中,简写错误的订单编号【"+failCodeSnList+"】,错误的快递简写【"+failShippingCodeList+"】," +
  1441. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1442. }
  1443. if(failShippingNameList != null && failShippingNameList.size() > 0){
  1444. throw new RRException("导入数据异常,快递简写对应的快递公司不一致,快递公司错误的订单编号【"+failNameSnList+"】,请修改Excel数据中订单编号对应的快递公司错误信息," +
  1445. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1446. }
  1447. // if(failFreightGoodsSnList != null && failFreightGoodsSnList.size() > 0){
  1448. // exportExceptionDataEntity.setExportExceptionData("运费信息请在商城配置》运费模板中维护,运费与商户信息对应,请检查该商品商户信息下的运费是否维护,不存在的商品编码【"+failFreightGoodsSnList+"】,运费【"+failFreightList+"】");
  1449. // exportExceptionDataDao.save(exportExceptionDataEntity);
  1450. // throw new RRException("导入数据异常,异常信息请在商品管理》》商品导入异常数据中查看检查");
  1451. // }
  1452. }else{
  1453. throw new RRException("导入数据为空,或者检查商品编码数据是否为空");
  1454. }
  1455. return 1;
  1456. }
  1457. @Override
  1458. public List<OrderEntity> promOrderList(Map<String, Object> map) {
  1459. Integer[] statusList = {201};
  1460. List<OrderEntity> list = orderDao.promOrderList(map);
  1461. for (OrderEntity orderEntity: list) {
  1462. Map<String, Object> queryMap = new HashMap<>();
  1463. queryMap.put("goodsId", orderEntity.getGoodsId());
  1464. queryMap.put("statusList", statusList);
  1465. queryMap.put("orderId", orderEntity.getId());
  1466. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1467. if(promActualPrice == null){
  1468. promActualPrice = 0d;
  1469. }
  1470. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1471. }
  1472. return list;
  1473. }
  1474. @Override
  1475. public int queryPromOrderTotal(Map<String, Object> map) {
  1476. return orderDao.queryPromOrderTotal(map);
  1477. }
  1478. @Override
  1479. public List<OrderEntity> promOrderListExport(Map<String, Object> map){
  1480. Integer[] statusList = {201};
  1481. List<OrderEntity> list = orderDao.promOrderListExport(map);
  1482. for (OrderEntity orderEntity: list) {
  1483. Map<String, Object> queryMap = new HashMap<>();
  1484. queryMap.put("goodsId", orderEntity.getGoodsId());
  1485. queryMap.put("orderId", orderEntity.getId());
  1486. queryMap.put("statusList", statusList);
  1487. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1488. if(promActualPrice == null){
  1489. promActualPrice = 0d;
  1490. }
  1491. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1492. }
  1493. return list;
  1494. }
  1495. @Override
  1496. public List<OrderEntity> storeTopicOrderList(Map<String, Object> map) {
  1497. List<OrderEntity> list = orderDao.storeTopicOrderList(map);
  1498. return list;
  1499. }
  1500. @Override
  1501. public int queryStoreTopicOrderTotal(Map<String, Object> map) {
  1502. return orderDao.queryStoreTopicOrderTotal(map);
  1503. }
  1504. @Override
  1505. public List<WxOrderEntity> wxOrderResendQueryAllList(Map<String, Object> map){
  1506. // String requestData = JacksonUtil.toJson(map);
  1507. String url = OmsMerchPropertiesBuilder.instance().getWxOrderResendUrl();
  1508. // 同步访问,返回结果字符串
  1509. String response = OkHttpUtils.post(map, url, "SSL");
  1510. ResponseData responseData = JacksonUtils.fromStringJson(response, ResponseData.class);
  1511. if(responseData.getCode().equalsIgnoreCase("0")){
  1512. List<WxOrderEntity> list = responseData.getData().getRows();
  1513. return list;
  1514. }
  1515. return null;
  1516. }
  1517. @Override
  1518. public List<OrderRecognitionDto> queryOrderListByRecognition(Map<String, Object> map){
  1519. String value = sysConfigDao.queryByKey("FACE_COLLECT_FREQUENCY_TIME");
  1520. if(value==null){
  1521. throw new RRException("请联系管理员配系统参数置FACE_COLLECT_FREQUENCY_TIME信息!");
  1522. }
  1523. List<OrderRecognitionDto> list = orderDao.queryOrderListByRecognition(map);
  1524. for (OrderRecognitionDto orderRecognitionDto: list){
  1525. Integer frequencySecondTime = Integer.parseInt(value);
  1526. String lastFaceTime = orderRecognitionDto.getLastFaceTime();
  1527. if(StringUtils.isNotEmpty(lastFaceTime)) {
  1528. Date lastFaceDate = DateUtils.convertStringToDate(lastFaceTime, DateUtils.DATE_TIME_PATTERN);
  1529. Calendar calendar = Calendar.getInstance();
  1530. calendar.setTime(lastFaceDate);
  1531. calendar.add(Calendar.SECOND, frequencySecondTime);
  1532. Date addSecondTime = calendar.getTime();
  1533. Date nowDate = new Date();
  1534. if (addSecondTime.getTime() > nowDate.getTime()) {
  1535. orderRecognitionDto.setAddSecondTime(DateUtils.format(addSecondTime,DateUtils.DATE_TIME_PATTERN));
  1536. orderRecognitionDto.setIsDateLast("false");
  1537. } else {
  1538. //可调用身份验证范围内
  1539. orderRecognitionDto.setIsDateLast("true");
  1540. }
  1541. }else{//可调用身份验证范围内
  1542. orderRecognitionDto.setIsDateLast("true");
  1543. }
  1544. }
  1545. return list;
  1546. }
  1547. @Override
  1548. public int queryOrderListByRecognitionTotal(Map<String, Object> map){
  1549. return orderDao.queryOrderListByRecognitionTotal(map);
  1550. }
  1551. /**
  1552. * 提交订单并付款
  1553. *
  1554. * @param param
  1555. * @param user
  1556. * @return
  1557. */
  1558. @Override
  1559. @Transactional
  1560. public Map offlineRetailSubmit(Map param, SysUserEntity user) {
  1561. // 解析订单数据 List
  1562. List<LinkedHashMap> goodsList = (List<LinkedHashMap>) param.get("goodsList");
  1563. // 解析用户信息 LinkedHashMap
  1564. Map userInfo = (Map) param.get("userInfo");
  1565. // 解析支付码 String
  1566. String parCode = (String) param.get("payCode");
  1567. // 解析sessionId(WebSocket) String
  1568. String sessionId = (String) param.get("sessionId");
  1569. // machineCode
  1570. String machineCode = (String) param.get("machineCode");
  1571. try {
  1572. machineCode = URLDecoder.decode(machineCode,"UTF-8");
  1573. } catch (Exception e) {
  1574. // e.printStackTrace();
  1575. }
  1576. Map resultObj = Maps.newHashMap();
  1577. try {
  1578. if (user == null) {
  1579. resultObj.put("errno", 400);
  1580. resultObj.put("errmsg", "用户登录超时,请重新登录");
  1581. return resultObj;
  1582. }
  1583. if (!user.getRoleType().equalsIgnoreCase("2")) {
  1584. resultObj.put("errno", 400);
  1585. resultObj.put("errmsg", "该操作只允许店员账户操作");
  1586. return resultObj;
  1587. }
  1588. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  1589. resultObj.put("errno", 400);
  1590. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  1591. return resultObj;
  1592. }
  1593. Long userId = user.getUserId();
  1594. Integer storeId = user.getStoreId();
  1595. List<GoodsEntity> goodsEntities = new ArrayList<>();
  1596. BigDecimal totalTax = new BigDecimal(0);
  1597. // 检查库存和更新库存
  1598. for (LinkedHashMap goodsDto : goodsList) {
  1599. //
  1600. GoodsEntity goodsEntity = goodsDao.queryObjectByProdBarcodeAndStore((String) goodsDto.get("prodBarcode"),storeId);
  1601. if (goodsEntity == null) {
  1602. resultObj.put("errno", 400);
  1603. resultObj.put("errmsg", "订单提交失败:商品不存在");
  1604. return resultObj;
  1605. }
  1606. Integer sellVolume = (Integer)goodsDto.get("sellVolume");
  1607. goodsDto.put("goodsId",goodsEntity.getId());
  1608. goodsDto.put("goodsSn",goodsEntity.getGoodsSn());
  1609. goodsDto.put("productId",goodsEntity.getProductId());
  1610. goodsDto.put("storeMarketPrice",goodsEntity.getStoreMarketPrice());
  1611. if(goodsDto.get("actualPaymentAmount") instanceof Double){
  1612. goodsDto.put("storeRetailPrice",new BigDecimal((Double)goodsDto.get("actualPaymentAmount")));
  1613. }else if(goodsDto.get("actualPaymentAmount") instanceof Integer){
  1614. goodsDto.put("storeRetailPrice",new BigDecimal((Integer)goodsDto.get("actualPaymentAmount")));
  1615. }else if(goodsDto.get("actualPaymentAmount") instanceof Float){
  1616. goodsDto.put("storeRetailPrice",new BigDecimal((Float)goodsDto.get("actualPaymentAmount")));
  1617. }
  1618. //取得规格的信息,判断规格库存
  1619. ProductStoreRelaEntity productInfo = productStoreRelaDao
  1620. .queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(goodsEntity.getId()));
  1621. synchronized (productInfo) {
  1622. if (null == productInfo || null == productInfo.getStockNum() ||
  1623. productInfo.getStockNum() < (sellVolume)) {
  1624. resultObj.put("errno", 400);
  1625. resultObj.put("errmsg", "库存不足,仅剩余" + productInfo.getStockNum());
  1626. return resultObj;
  1627. } else {
  1628. // 判断销售价是否低于底线价
  1629. // if(productInfo.getBottomLinePrice() != null){
  1630. // BigDecimal bottomLinePrice = new BigDecimal(productInfo.getBottomLinePrice());
  1631. // if (goodsEntity.getStoreRetailPrice().compareTo(bottomLinePrice) <= -1) {
  1632. // LOGGER.error("销售价格小于底线价格");
  1633. //
  1634. // // 记录该信息,到价格过低日志表中,这里没有活动id
  1635. // Mall2LowPriceWarningEntity lowPriceWarningEntity = new Mall2LowPriceWarningEntity();
  1636. // lowPriceWarningEntity.setSalePrice(goodsEntity.getStoreRetailPrice());
  1637. // lowPriceWarningEntity.setWarningPrice(bottomLinePrice);
  1638. // lowPriceWarningEntity.setSku(goodsEntity.getGoodsSn());
  1639. // lowPriceWarningEntity.setWarningType("00");
  1640. // lowPriceWarningEntity.setStoreId(storeId+"");
  1641. // lowPriceWarningEntity.setCreateTime(new Date());
  1642. //
  1643. // lowPriceWarningDao.save(lowPriceWarningEntity);
  1644. // resultObj.put("errno", 400);
  1645. // resultObj.put("errmsg", "商品"+goodsEntity.getName()+"的销售价格小于底线价格");
  1646. // return resultObj;
  1647. // }
  1648. // }
  1649. productInfo.setStockNum(productInfo.getStockNum() - sellVolume);
  1650. productInfo.setStoreId(Long.valueOf(storeId));
  1651. productInfo.addSellVolume();
  1652. productInfo.setLastSaleTime(new Date());
  1653. productStoreRelaDao.updateStockNum(productInfo);//修改普通商品库存
  1654. if(goodsEntity != null) {
  1655. goodsEntity.setGoodsNumber(goodsEntity.getGoodsNumber() - sellVolume);
  1656. goodsEntity.setLastSaleTime(new Date());
  1657. goodsDao.update(goodsEntity);
  1658. }
  1659. }
  1660. if(goodsDto.get("retailPrice") instanceof Double){
  1661. goodsEntity.setRetailPrice(new BigDecimal((Double)goodsDto.get("retailPrice"))); // 单价
  1662. }else if(goodsDto.get("retailPrice") instanceof Integer){
  1663. goodsEntity.setRetailPrice(new BigDecimal((Integer)goodsDto.get("retailPrice")));
  1664. }else if(goodsDto.get("retailPrice") instanceof Float){
  1665. goodsEntity.setRetailPrice(new BigDecimal((Float)goodsDto.get("retailPrice")));
  1666. }
  1667. if(goodsDto.get("discountedPrice") instanceof Double){
  1668. goodsEntity.setDiscountedPrice(new BigDecimal((Integer)goodsDto.get("discountedPrice"))); // 优惠金额
  1669. }else if(goodsDto.get("discountedPrice") instanceof Integer){
  1670. goodsEntity.setDiscountedPrice(new BigDecimal((Integer)goodsDto.get("discountedPrice")));
  1671. }else if(goodsDto.get("discountedPrice") instanceof Float){
  1672. goodsEntity.setDiscountedPrice(new BigDecimal((Float)goodsDto.get("discountedPrice")));
  1673. }
  1674. if(goodsDto.get("actualPaymentAmount") instanceof Double){
  1675. goodsEntity.setActualPaymentAmount(new BigDecimal((Double)goodsDto.get("actualPaymentAmount"))); // 实际支付价格
  1676. }else if(goodsDto.get("actualPaymentAmount") instanceof Integer){
  1677. goodsEntity.setActualPaymentAmount(new BigDecimal((Integer)goodsDto.get("actualPaymentAmount")));
  1678. }else if(goodsDto.get("actualPaymentAmount") instanceof Float){
  1679. goodsEntity.setActualPaymentAmount(new BigDecimal((Float)goodsDto.get("actualPaymentAmount")));
  1680. }
  1681. Object taxObject = goodsDto.get("goodstaxes");
  1682. BigDecimal tax = new BigDecimal(0);
  1683. if(taxObject instanceof Double){
  1684. tax = new BigDecimal((Double) taxObject);
  1685. }else if(taxObject instanceof Integer){
  1686. tax = new BigDecimal((Integer) taxObject);
  1687. }else if(taxObject instanceof Float){
  1688. tax = new BigDecimal((Float) taxObject);
  1689. }else if(taxObject instanceof String){
  1690. tax = new BigDecimal((String) taxObject) ;
  1691. }
  1692. totalTax = totalTax.add(tax).setScale(2,BigDecimal.ROUND_HALF_DOWN); // 计算总的税额
  1693. if(goodsDto.get("actualPaymentAmount") instanceof Double){
  1694. goodsEntity.setStoreRetailPrice(new BigDecimal((Double)goodsDto.get("actualPaymentAmount")));
  1695. }else if(goodsDto.get("actualPaymentAmount") instanceof Integer){
  1696. goodsEntity.setStoreRetailPrice(new BigDecimal((Integer)goodsDto.get("actualPaymentAmount")));
  1697. }else if(goodsDto.get("actualPaymentAmount") instanceof Float){
  1698. goodsEntity.setStoreRetailPrice(new BigDecimal((Float)goodsDto.get("actualPaymentAmount")));
  1699. }
  1700. // goodsEntity.setStoreRetailPrice(productInfo.getRetailPrice());
  1701. // 借用这个字段来存储购买数
  1702. goodsEntity.setGoodsNumber(sellVolume);
  1703. goodsEntity.setActivity((String) goodsDto.get("activity"));
  1704. goodsEntities.add(goodsEntity);
  1705. }
  1706. }
  1707. UserEntity userEntity = userDao.queryByMobile((String) userInfo.get("customPhone"));
  1708. if(userEntity == null) {
  1709. // 保存用户信息
  1710. userEntity = new UserEntity();
  1711. userEntity.setUsername((String) userInfo.get("customName"));
  1712. userEntity.setPassword("");
  1713. userEntity.setIdNo((String) userInfo.get("customIDCard"));
  1714. userEntity.setMobile((String) userInfo.get("customPhone"));
  1715. userEntity.setGender(1);
  1716. userEntity.setRegisterTime(new Date());
  1717. userEntity.setLastLoginTime(new Date());
  1718. userEntity.setIdNo((String) userInfo.get("customIDCard"));
  1719. userDao.save(userEntity);
  1720. MerchUserEntity merchUserEntity = new MerchUserEntity();
  1721. merchUserEntity.setMerchSn(user.getMerchSn());
  1722. merchUserEntity.setStoreId(storeId);
  1723. merchUserEntity.setUserId(userEntity.getId());
  1724. merchUserEntity.setCreateTime(new Date());
  1725. merchUserEntity.setIsLoadGoods("0");
  1726. merchUserDao.save(merchUserEntity);
  1727. }
  1728. // TODO 查询使用的优惠券,并减扣金额
  1729. String couponSn = (String) userInfo.get("couponSn");
  1730. // 获取当前时间
  1731. String currentTime = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  1732. MkActivitiesCouponEntity couponEntity = mkActivitiesCouponService.queryByCouponSn(couponSn,currentTime);
  1733. // // 优惠金额
  1734. BigDecimal disCountAmount = new BigDecimal(0);
  1735. if(couponEntity != null){
  1736. disCountAmount= couponEntity.getCouponPrice();
  1737. }
  1738. // 判断该用户是否是生日
  1739. Boolean isBirth = false;
  1740. String birthday = "";
  1741. if(userEntity.getIdNo().length() == 15){
  1742. birthday = userEntity.getIdNo().substring(8,10) + "-" + userEntity.getIdNo().substring(10,12);
  1743. }else if(userEntity.getIdNo().length() == 18){
  1744. birthday = userEntity.getIdNo().substring(10,12) + "-" + userEntity.getIdNo().substring(12,14);
  1745. }
  1746. SimpleDateFormat format = new SimpleDateFormat("MM-dd");
  1747. String today = format.format(new Date());
  1748. if(birthday.equalsIgnoreCase(today)){
  1749. isBirth = true;
  1750. }
  1751. // 生成订单
  1752. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  1753. OrderVo order = setOrderVo(goodsEntities, userEntity,storeId.longValue(), user.getMerchSn(),disCountAmount,totalTax);
  1754. order.setStore_id(storeId.longValue());
  1755. // if(storeTopic != null){
  1756. // order.setActivity_id(storeTopic.getId().longValue());
  1757. // }
  1758. order.setMerchOrderSn(merchOrderSn);
  1759. order.setCoupon_name(couponSn); // 借用这个字段来记录是否使用优惠券
  1760. //插入订单信息和订单商品
  1761. orderDao.saveOrderVo(order);
  1762. // TODO 订单流转表
  1763. OrderProcessRecordEntity processRecordEntity = new OrderProcessRecordEntity();
  1764. processRecordEntity.setOrderSn(order.getOrder_sn());
  1765. processRecordEntity.setUserId(Integer.valueOf(userEntity.getId()+""));
  1766. processRecordEntity.setAddOrderStartTime(order.getCreateTime());
  1767. processRecordEntity.setIsAddOrderSend(Dict.isSend.item_1.getItem());
  1768. processRecordEntity.setOrderBizType(Dict.orderBizType.item_10.getItem());
  1769. if (null == order.getId()) {
  1770. resultObj.put("errno", 400);
  1771. resultObj.put("errmsg", "订单提交失败");
  1772. return resultObj;
  1773. }
  1774. for (GoodsEntity goodsDto : goodsEntities) {
  1775. OrderGoodsVo orderGoodsVo = setOrderGoodsVo(order,goodsDto);
  1776. //新增订单详情
  1777. orderGoodsDao.saveOrderGoodsVo(orderGoodsVo);
  1778. }
  1779. //清空预订单商品临时表
  1780. Map orderInfoMap = Maps.newHashMap();
  1781. orderInfoMap.put("orderInfo", order);
  1782. resultObj.put("errno", 0);
  1783. resultObj.put("errmsg", "订单提交成功");
  1784. resultObj.put("data", orderInfoMap);
  1785. //判断支付类型,并支付订单
  1786. R r = null;
  1787. //保存支付记录
  1788. OrderWXPayRecordEntity orderWXPayRecordCurrent = orderWXPayRecordService.saveRecordVo(order);
  1789. StoreEntity store = storeService.queryObject(order.getStore_id().intValue());
  1790. // 设置支付单开始时间
  1791. processRecordEntity.setPaymentStartTime(new Date());
  1792. // 判断是微信的支付码还是支付宝的支付码
  1793. if (parCode.startsWith("28")) {
  1794. // 支付宝支付
  1795. // AliPay(user, parCode , order, processRecordEntity, orderWXPayRecordCurrent, store);
  1796. }else{
  1797. // 微信支付
  1798. // try {
  1799. // wxPay(user, parCode, resultObj, order, processRecordEntity, orderWXPayRecordCurrent, store);
  1800. // } catch (ParseException e) {
  1801. // throw e;
  1802. // }
  1803. }
  1804. OrderEntity orderEntity = queryObject(order.getId());
  1805. // orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_201.getItem()));
  1806. // orderEntity.setPayStatus(Integer.parseInt(Dict.payStatus.item_2.getItem()));
  1807. // orderEntity.setPayFlag(payFlag);
  1808. // orderEntity.setPayTime(new Date());
  1809. orderDao.update(orderEntity);
  1810. resultObj.put("shopName",store.getStoreName()); // 根据门店编号查询
  1811. resultObj.put("userName",user.getUsername());
  1812. // 保存订单流转表
  1813. // 设置下单完成时间
  1814. processRecordEntity.setAddOrderSuccTime(order.getPay_time());
  1815. orderProcessRecordDao.save(processRecordEntity);
  1816. // 生成取票码
  1817. PickUpCodeEntity pickUpCodeEntity = new PickUpCodeEntity();
  1818. pickUpCodeEntity.setOrderSn(order.getOrder_sn());
  1819. pickUpCodeService.save(pickUpCodeEntity);
  1820. // 生成销售记录
  1821. SaleRecordEntity saleRecordEntity = new SaleRecordEntity();
  1822. // 根据收银机机器码,查询收银机
  1823. CashierEntity cashierEntity = cashierDao.queryByMachineCode(machineCode,storeId+"");
  1824. if(cashierEntity != null){
  1825. saleRecordEntity.setCashierSn(cashierEntity.getCashierSn());
  1826. saleRecordEntity.setOrderSn(order.getOrder_sn());
  1827. saleRecordEntity.setSallerId(userId+"");
  1828. saleRecordEntity.setSalesTime(new Date());
  1829. // saleRecordEntity.setDiscountId(topicId + "");
  1830. saleRecordEntity.setCreateTime(new Date());
  1831. saleRecordDao.save(saleRecordEntity);
  1832. }
  1833. // 查询积分规则 ,默认先按消费金额1:1积分
  1834. Mall2PointsRulesEntity pointsRules = null;
  1835. // 增加该会员的积分
  1836. Mall2MemberPointsEntity memberPointsEntity = memberPointsDao.queryByUserId(userEntity.getId());
  1837. if(memberPointsEntity == null){
  1838. memberPointsEntity = new Mall2MemberPointsEntity();
  1839. memberPointsEntity.setUserId(userEntity.getId()+"");
  1840. memberPointsEntity.setPoints(order.getActual_price().intValue());
  1841. memberPointsEntity.setCreaterSn(userId+"");
  1842. memberPointsEntity.setCreateTime(new Date());
  1843. memberPointsDao.save(memberPointsEntity);
  1844. }else{
  1845. memberPointsEntity.setPoints(order.getActual_price().add(new BigDecimal(memberPointsEntity.getPoints())).intValue());
  1846. memberPointsEntity.setModerSn(userId+"");
  1847. memberPointsEntity.setModTime(new Date());
  1848. memberPointsDao.update(memberPointsEntity);
  1849. }
  1850. // 增加该会员的消费记录
  1851. Mall2MemberConsumptionRecordsEntity consumptionRecords = new Mall2MemberConsumptionRecordsEntity();
  1852. consumptionRecords.setUserId(userEntity.getId()+"");
  1853. consumptionRecords.setOrderSn(order.getOrder_sn());
  1854. consumptionRecords.setConsumptionTime(new Date());
  1855. consumptionRecords.setShopSn(storeId+"");
  1856. // TODO 判断是否有使用生日优惠
  1857. if(isBirth){
  1858. consumptionRecords.setIsUseBirthdayOffer("0"); // 使用生日优惠
  1859. }else{
  1860. consumptionRecords.setIsUseBirthdayOffer("1"); // 没使用生日优惠
  1861. }
  1862. consumptionRecords.setCreaterSn(userId+"");
  1863. consumptionRecords.setCreateTime(new Date());
  1864. memberConsumptionRecordsDao.save(consumptionRecords);
  1865. resultObj.put("code",pickUpCodeEntity.getPickUpCodeSn()); // 系统中累加
  1866. resultObj.put("time",new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
  1867. resultObj.put("orderNo",order.getOrder_sn()); //
  1868. // 通知WebSocket
  1869. WebSocketServer.sendMessage(sessionId,order.getOrder_sn(),order.getStore_id()
  1870. +"");
  1871. } catch (Exception e) {
  1872. e.printStackTrace();
  1873. resultObj.put("errno", 400);
  1874. resultObj.put("errmsg", "订单异常------"+e.getMessage());
  1875. throw new RuntimeException(e);
  1876. }
  1877. return resultObj;
  1878. }
  1879. // private BigDecimal getDisCountAmout(List<GoodsEntity> goodsEntities) {
  1880. // BigDecimal disCountAmount;
  1881. // // TODO 生成订单之前,先查询是否有优惠券或者满减
  1882. // // TODO 20200610 要修改成全部商品
  1883. // // 优惠券的集合
  1884. // List<MkStoreTicketDiscountEntity> mkStoreTicketDiscountEntities = new ArrayList<>();
  1885. // // 满减的集合
  1886. // List<MkStoreCampMinusLevelEntity> mkStoreCampMinusEntities = new ArrayList<>();
  1887. // // 存商品跟金额的关系
  1888. // Map<Long,BigDecimal> moneyMap = new HashMap<>();
  1889. // // 商品总价
  1890. // BigDecimal totalPrice = new BigDecimal(0);
  1891. //
  1892. // for(GoodsEntity goodsEntity : goodsEntities){
  1893. // Long goodsId = goodsEntity.getId();
  1894. // // 计算该商品的价格
  1895. // BigDecimal goodsPrice = goodsEntity.getStoreRetailPrice().multiply(new BigDecimal(goodsEntity.getGoodsNumber())).setScale(2, RoundingMode.HALF_UP);
  1896. // moneyMap.put(goodsId,goodsPrice);
  1897. // totalPrice = totalPrice.add(goodsPrice);
  1898. // // 查询该商品id是否有优惠券
  1899. // List<MkStoreTicketDiscountEntity> mkStoreTicketDiscountEntity = mkStoreTicketDiscountService.queryByGoodsId(goodsId);
  1900. // if(mkStoreTicketDiscountEntity != null) {
  1901. // mkStoreTicketDiscountEntities.addAll(mkStoreTicketDiscountEntity);
  1902. // }
  1903. // // 查询该商品id是否有满减
  1904. // List<MkStoreCampMinusLevelEntity> mkStoreCampMinusEntity = mkStoreCampMinusService.queryByGoodsId(goodsId);
  1905. // if(mkStoreCampMinusEntity != null) {
  1906. // mkStoreCampMinusEntities.addAll(mkStoreCampMinusEntity);
  1907. // }
  1908. // }
  1909. //
  1910. // // 满减优惠的金额
  1911. // BigDecimal campDisCountAmount = new BigDecimal(0);
  1912. // if(mkStoreCampMinusEntities.size() > 0){
  1913. // // 上一次所需金额,用于取最大的优惠力度
  1914. // BigDecimal lastAmount = new BigDecimal(0);
  1915. // for (int i = 0 ; i < mkStoreCampMinusEntities.size() ; i++){
  1916. // MkStoreCampMinusLevelEntity mkStoreCampMinusLevelEntity = mkStoreCampMinusEntities.get(i);
  1917. // // TODO 20200610还有满多少件,跟满多少元打折的,逻辑复杂,下次开发
  1918. // BigDecimal discCond = mkStoreCampMinusLevelEntity.getYuanMinusCond();
  1919. // // 判断这次金额是否大于上次金额,如果不大于,直接continue
  1920. // if(discCond.compareTo(lastAmount) > 0){
  1921. // // 如果总金额大于所需金额,则可以使用该优惠券,记录该优惠券的角标,金额跟优惠的钱
  1922. // if(totalPrice.compareTo(discCond) > 0){
  1923. // // 记录上一次金额
  1924. // lastAmount = discCond;
  1925. // campDisCountAmount = mkStoreCampMinusLevelEntity.getYuanMinusPref();
  1926. // }
  1927. // }
  1928. // }
  1929. // }
  1930. //
  1931. // // 优惠券优惠的金额
  1932. // BigDecimal ticketDisCountAmount = new BigDecimal(0);
  1933. // if(mkStoreTicketDiscountEntities.size() > 0){
  1934. // // 上一次所需金额,用于取最大的优惠力度
  1935. // BigDecimal lastAmount = new BigDecimal(0);
  1936. // BigDecimal lastRadio = new BigDecimal(0);
  1937. // for (int i = 0 ; i < mkStoreTicketDiscountEntities.size() ; i++){
  1938. // MkStoreTicketDiscountEntity mkStoreTicketDiscountEntity = mkStoreTicketDiscountEntities.get(i);
  1939. // // 代金券所需金额
  1940. // // TODO 20200610还有折扣券的,逻辑较为复杂,下次在开发
  1941. //
  1942. // if("00".equals(mkStoreTicketDiscountEntity.getApplyType())){
  1943. // BigDecimal discCond = mkStoreTicketDiscountEntity.getVoucherCond();
  1944. // // 判断这次金额是否大于上次金额,如果不大于,直接continue
  1945. // if(discCond.compareTo(lastAmount) > 0){
  1946. // // 如果总金额大于所需金额,则可以使用该优惠券,记录该优惠券的角标,金额跟优惠的钱
  1947. // if(totalPrice.compareTo(discCond) > 0){
  1948. // // 记录上一次金额
  1949. // lastAmount = discCond;
  1950. // ticketDisCountAmount = mkStoreTicketDiscountEntity.getVoucherMoney();
  1951. // }
  1952. // }
  1953. // }else if("01".equals(mkStoreTicketDiscountEntity.getApplyType())){
  1954. // BigDecimal discCond = mkStoreTicketDiscountEntity.getDiscCond();
  1955. // if(totalPrice.compareTo(discCond) > 0){
  1956. // // 打的折扣
  1957. // lastRadio = mkStoreTicketDiscountEntity.getDiscRatio();
  1958. // }
  1959. //
  1960. //
  1961. // }
  1962. //
  1963. //
  1964. // }
  1965. // }
  1966. //
  1967. //
  1968. // disCountAmount = ticketDisCountAmount.compareTo(campDisCountAmount) > 0 ? ticketDisCountAmount : campDisCountAmount;
  1969. // return disCountAmount;
  1970. // }
  1971. private void AliPay(SysUserEntity user, String parCode, OrderVo order, OrderProcessRecordEntity processRecordEntity, OrderWXPayRecordEntity orderWXPayRecordCurrent, StoreEntity store) throws Exception {
  1972. AliPayRequestParams params = new AliPayRequestParams();
  1973. params.setAuthCode(parCode);
  1974. params.setBody(order.getApprovalRemark());
  1975. params.setOutTradeNo(order.getOrder_sn());
  1976. params.setSubject("CW下单");
  1977. params.setStoreId(store.getId()+"");
  1978. params.setTotalAmount(order.getActual_price().setScale(2,BigDecimal.ROUND_HALF_UP)+"");
  1979. LOGGER.info("调用阿里支付接口的请求参数:"+JacksonUtils.toJson(params));
  1980. AliPayMicropayApiResult aliPayMicropayApiResult = AliPayUtil.aliTradePay(params);
  1981. orderWXPayRecordService.updateRecordByAli(orderWXPayRecordCurrent.getId(), aliPayMicropayApiResult);
  1982. LOGGER.info("调用阿里支付接口的同步返回结果:"+JacksonUtils.toJson(aliPayMicropayApiResult));
  1983. // 修改订单状态
  1984. //当支付成功时,修改订单,并把其他支付记录撤销
  1985. if (AliPayUtil.AliPayTradeState.SUCC.getCode().equals(aliPayMicropayApiResult.getCode())) {
  1986. // //查询当前订单所有的支付记录
  1987. // List<OrderWXPayRecordEntity> orderWXPayRecordEntitys =
  1988. // orderWXPayRecordService.getRecordsByOutTradeNo(order.getOrder_sn());
  1989. this.confirmPay(order.getId(), Dict.payFlag.item_alipay.getItem(), aliPayMicropayApiResult.getTradeNo());
  1990. // 设置支付单完成时间
  1991. processRecordEntity.setPaymentSuccTime(aliPayMicropayApiResult.getGmtPayment());
  1992. processRecordEntity.setPayTransactionId(aliPayMicropayApiResult.getTradeNo());
  1993. // 系统繁忙
  1994. } else if(AliPayUtil.AliPayTradeState.SERVER_FAIL.getCode().equals(aliPayMicropayApiResult.getCode())){
  1995. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  1996. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请稍后再试");
  1997. // 支付失败
  1998. }else if(AliPayUtil.AliPayTradeState.BUSINESS_FAIL.getCode().equals(aliPayMicropayApiResult.getCode())){
  1999. // 系统异常
  2000. if(AliPayUtil.BusinessFailState.SYSTEM_ERROR.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2001. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2002. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请稍后再试");
  2003. // 订单总额超过限额
  2004. }else if(AliPayUtil.BusinessFailState.TOTAL_FEE_EXCEED.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2005. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2006. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请告知顾客");
  2007. // 授权码无效
  2008. }else if(AliPayUtil.BusinessFailState.PAYMENT_AUTH_CODE_INVALID.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2009. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2010. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请顾客刷新条码后,重新支付");
  2011. // 交易信息被篡改
  2012. }else if(AliPayUtil.BusinessFailState.CONTEXT_INCONSISTENT.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2013. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2014. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请重试");
  2015. // 余额支付功能关闭
  2016. }else if(AliPayUtil.BusinessFailState.ERROR_BALANCE_PAYMENT_DISABLE.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2017. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2018. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请用户打开余额支付");
  2019. // 交易买家不匹配
  2020. }else if(AliPayUtil.BusinessFailState.TRADE_BUYER_NOT_MATCH.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2021. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2022. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请重试");
  2023. // 买家状态非法
  2024. }else if(AliPayUtil.BusinessFailState.BUYER_ENABLE_STATUS_FORBID.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2025. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2026. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请买家联系支付宝小二,确认为什么非法");
  2027. // 唤起移动收银台失败
  2028. }else if(AliPayUtil.BusinessFailState.PULL_MOBILE_CASHIER_FAIL.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2029. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2030. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请用户刷新条码后,重新支付");
  2031. // 用户的无限支付开关关闭
  2032. }else if(AliPayUtil.BusinessFailState.MOBILE_PAYMENT_SWITCH_OFF.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2033. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2034. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请用户在PC上打开无线支付开关后,在发起支付");
  2035. // 支付失败
  2036. }else if(AliPayUtil.BusinessFailState.PAYMENT_FAIL.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2037. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2038. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请重试");
  2039. // 商户账号被冻结
  2040. }else if(AliPayUtil.BusinessFailState.SELLER_BEEN_BLOCKED.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2041. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2042. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请联系支付宝小二解冻");
  2043. // 买家未通过人行认证
  2044. }else if(AliPayUtil.BusinessFailState.ERROR_BUYER_CERTIFY_LEVEL_LIMIT.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2045. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2046. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请买家联系支付宝小二");
  2047. // 用户当面付付款开关管壁
  2048. }else if(AliPayUtil.BusinessFailState.USER_FACE_PAYMENT_SWITCH_OFF.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())){
  2049. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2050. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+",请买家打开当面付付款开关");
  2051. }else{
  2052. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2053. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg());
  2054. }
  2055. // 其他支付异常状态
  2056. } else {
  2057. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2058. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg()+"...........请联系管理员");
  2059. }
  2060. }
  2061. private void wxPay(SysUserEntity user, String parCode, Map resultObj, OrderVo order, OrderProcessRecordEntity processRecordEntity, OrderWXPayRecordEntity orderWXPayRecordCurrent, StoreEntity store) throws ParseException {
  2062. R r;
  2063. WechatMicropayApiResult wechatMicropayApiResult = WechatUtil
  2064. .wxMicropay(store.getMerchName() + "-" + store.getStoreName(), order.getOrderBizType(), null,
  2065. orderWXPayRecordCurrent.getOutTradeNoWX(), 0.01d/*order.getActual_price().doubleValue()*/,
  2066. "127.0.0.1", parCode);
  2067. orderWXPayRecordService.updateRecord(orderWXPayRecordCurrent.getId(), wechatMicropayApiResult);
  2068. resultObj.put("shopName",store.getStoreName()); // 根据门店编号查询
  2069. resultObj.put("userName",user.getUsername());
  2070. // 修改订单状态
  2071. //当支付成功时,修改订单,并把其他支付记录撤销
  2072. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2073. //查询当前订单所有的支付记录
  2074. List<OrderWXPayRecordEntity> orderWXPayRecordEntitys =
  2075. orderWXPayRecordService.getRecordsByOutTradeNo(order.getOrder_sn());
  2076. for (OrderWXPayRecordEntity orderWXPayRecordTemp : orderWXPayRecordEntitys) {
  2077. //查询出来的记录排除当前已支付成功的记录,对其他记录交易状态为未撤销,未关闭的订单,调用撤销订单
  2078. if (orderWXPayRecordTemp.getId() != orderWXPayRecordCurrent.getId() &&
  2079. (!WechatUtil.WXTradeState.REVOKED.getCode().equals(orderWXPayRecordTemp.getTradeState()) ||
  2080. !WechatUtil.WXTradeState.CLOSED.getCode().equals(orderWXPayRecordTemp.getTradeState()))) {
  2081. WechatReverseApiResult wechatReverseApiResult =
  2082. WechatUtil.wxReverse(orderWXPayRecordTemp.getOutTradeNoWX());
  2083. //撤销订单成功
  2084. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getReturn_code()) &&
  2085. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getResult_code())) {
  2086. //调用订单查询接口
  2087. WechatRefundApiResult wechatRefundApiResult =
  2088. WechatUtil.wxOrderQuery(orderWXPayRecordTemp.getOutTradeNoWX());
  2089. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getReturn_code()) &&
  2090. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getResult_code())) {
  2091. // 修改订单支付记录
  2092. orderWXPayRecordService
  2093. .updateWXPayRecordTradeState(orderWXPayRecordTemp.getId(), wechatRefundApiResult);
  2094. }
  2095. }
  2096. }
  2097. }
  2098. this.confirmPay(order.getId(), Dict.payFlag.item_weixin.getItem(), orderWXPayRecordCurrent.getOutTradeNoWX());
  2099. // 设置支付单完成时间
  2100. processRecordEntity.setPaymentSuccTimeStr(wechatMicropayApiResult.getTime_end());
  2101. processRecordEntity.setPaymentSuccTime(
  2102. new SimpleDateFormat("yyyyMMddHHmmss").parse(wechatMicropayApiResult.getTime_end()));
  2103. processRecordEntity.setPayTransactionId(wechatMicropayApiResult.getTransaction_id());
  2104. //用户支付中
  2105. } else if (WechatUtil.WXTradeState.USERPAYING.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2106. r = R.error(WechatUtil.WXTradeState.USERPAYING.getCodeZn() + ",稍等片刻后请刷新页面重新查看订单状态");
  2107. int times = 0;
  2108. // 查询是否支付了
  2109. while(true){
  2110. boolean flag = orderQuery(order, processRecordEntity);
  2111. if(flag ){
  2112. break;
  2113. }
  2114. try {
  2115. Thread.currentThread().sleep(1000);
  2116. } catch (InterruptedException e) {
  2117. e.printStackTrace();
  2118. }
  2119. if(times >= 30){
  2120. throw new RuntimeException("超过30s未支付,订单下单失败");
  2121. }
  2122. times++;
  2123. }
  2124. //用户支付失败
  2125. } else if (WechatUtil.WXTradeState.PAYERROR.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2126. WechatReverseApiResult wechatReverseApiResult =
  2127. WechatUtil.wxReverse(orderWXPayRecordCurrent.getOutTradeNoWX());
  2128. //撤销订单成功
  2129. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getReturn_code()) &&
  2130. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getResult_code())) {
  2131. //调用订单查询接口
  2132. WechatRefundApiResult wechatRefundApiResult =
  2133. WechatUtil.wxOrderQuery(orderWXPayRecordCurrent.getOutTradeNoWX());
  2134. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getReturn_code()) &&
  2135. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getResult_code())) {
  2136. // 修改订单支付记录
  2137. orderWXPayRecordService
  2138. .updateWXPayRecordTradeState(orderWXPayRecordCurrent.getId(), wechatRefundApiResult);
  2139. }
  2140. r = R.error(orderWXPayRecordCurrent.getErrCodeDes());
  2141. } else {
  2142. r = R.error(wechatReverseApiResult.getErr_code_des());
  2143. }
  2144. }
  2145. }
  2146. private boolean orderQuery(OrderVo order, OrderProcessRecordEntity processRecordEntity) {
  2147. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口调用");
  2148. String merchOrderSn = order.getMerchOrderSn();
  2149. String orderId = order.getId() + "";
  2150. String orderSn = order.getOrder_sn();
  2151. WechatRefundApiResult result = WechatUtil.wxOrderQuery(orderSn);
  2152. if (result.getReturn_code().equalsIgnoreCase(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  2153. if (result.getResult_code().equalsIgnoreCase(WechatUtil.WXTradeState.SUCCESS.getCode()) ){
  2154. if(result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_SUCCESS.getItem())) {
  2155. Date successTime = DateUtils.convertStringToDate(result.getTime_end(),
  2156. DateUtils.DATE_TIME_PATTERN_YYYY_MM_DD_HH_MM_SS);
  2157. Map orderRaram = Maps.newHashMap();
  2158. orderRaram.put("payStatus", Dict.payStatus.item_2.getItem());//已支付
  2159. orderRaram.put("orderStatus", Dict.orderStatus.item_201.getItem());//已支付
  2160. orderRaram.put("payTransactionId", result.getTransaction_id());
  2161. orderRaram.put("payTime", successTime);
  2162. orderRaram.put("orderId", orderId);
  2163. orderRaram.put("payFlag",Dict.payFlag.item_weixin.getItem());
  2164. orderDao.updateOrderInfo(orderRaram);
  2165. Map processParam = Maps.newHashMap();
  2166. processParam.put("payTime", successTime);
  2167. processParam.put("orderSn", orderSn);
  2168. orderDao.updateOrderProcessRecord(processParam);
  2169. // 设置支付单完成时间
  2170. processRecordEntity.setPaymentSuccTimeStr(result.getTime_end());
  2171. processRecordEntity.setPaymentSuccTime(successTime);
  2172. processRecordEntity.setPayTransactionId(result.getTransaction_id());
  2173. return true;
  2174. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_NOTPAY.getItem())) {//订单未支付
  2175. Map orderRaram = Maps.newHashMap();
  2176. orderRaram.put("payStatus", Dict.payStatus.item_0.getItem());//支付状态未支付
  2177. orderRaram.put("orderStatus", Dict.orderStatus.item_0.getItem());//订单状态未支付
  2178. orderRaram.put("orderId", orderId);
  2179. orderDao.updateOrderInfo(orderRaram);
  2180. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_CLOSED.getItem())) {
  2181. Map orderRaram = Maps.newHashMap();
  2182. orderRaram.put("payStatus", Dict.payStatus.item_7.getItem());
  2183. orderRaram.put("orderStatus", Dict.orderStatus.item_500.getItem());
  2184. orderRaram.put("orderId", orderId);
  2185. orderDao.updateOrderInfo(orderRaram);
  2186. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  2187. "】,des【" + result.getTrade_state_desc() + "】");
  2188. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_PAYERROR.getItem())) {
  2189. Map orderRaram = Maps.newHashMap();
  2190. orderRaram.put("payStatus", Dict.payStatus.item_8.getItem());
  2191. orderRaram.put("orderStatus", Dict.orderStatus.item_501.getItem());
  2192. orderRaram.put("orderId", orderId);
  2193. orderDao.updateOrderInfo(orderRaram);
  2194. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  2195. "】,des【" + result.getTrade_state_desc() + "】");
  2196. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_USERPAYING.getItem())) {
  2197. Map orderRaram = Maps.newHashMap();
  2198. orderRaram.put("payStatus", Dict.payStatus.item_1.getItem());
  2199. orderRaram.put("orderStatus", Dict.orderStatus.item_100.getItem());
  2200. orderRaram.put("orderId", orderId);
  2201. orderDao.updateOrderInfo(orderRaram);
  2202. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  2203. "】,des【" + result.getTrade_state_desc() + "】");
  2204. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_REVOKED.getItem())) {
  2205. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  2206. "】,des【" + result.getTrade_state_desc() + "】");
  2207. }
  2208. }else {
  2209. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口返回失败信息:code 【" + result.getErr_code() +
  2210. "】,des【" + result.getErr_code_des() + "】");
  2211. }
  2212. return false;
  2213. } else {
  2214. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口调用失败: " + result.getReturn_msg());
  2215. return false;
  2216. }
  2217. }
  2218. @Override
  2219. public OrderEntity queryObjectByOrderSn(String orderSn) {
  2220. return orderDao.queryObjectByOrderSn(orderSn);
  2221. }
  2222. // TODO 退款的代码
  2223. @Override
  2224. @Transactional
  2225. public R orderRefund(OrderEntity order, String sessionId) throws Exception {
  2226. String payFlag = order.getPayFlag();
  2227. boolean needUpdateStock = true;
  2228. if (Dict.payFlag.item_cash.getItem().equals(payFlag)) {
  2229. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  2230. // TODO 微信的退款代码
  2231. } else if(Dict.payFlag.item_weixin.getItem().equals(payFlag)){
  2232. OrderEntity orderInfo = order;
  2233. if (null == orderInfo) {
  2234. return R.error("订单不存在");
  2235. }
  2236. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem()) ||
  2237. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  2238. return R.error("订单已退款");
  2239. }
  2240. Double totalActualPrice = orderDao.getTotalActualPrice(orderInfo.getMerchOrderSn());
  2241. if (totalActualPrice == null) {
  2242. totalActualPrice = 0d;
  2243. }
  2244. String refundResult = "";
  2245. if (orderInfo.getOrderStatus() != Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  2246. // if (orderInfo.getPayFlag().equalsIgnoreCase(Dict.payFlag.item_wxglobalpay.getItem())) {
  2247. // refundResult = wxGlobalRefund(orderInfo, totalActualPrice);
  2248. // if (org.apache.commons.lang3.StringUtils.isNotBlank(refundResult)) {
  2249. // return R.error(refundResult);
  2250. // }
  2251. // } else if (orderInfo.getPayFlag().equalsIgnoreCase(Dict.payFlag.item_pingan.getItem())) {
  2252. // refundResult = pinganRefund(orderInfo, refundId);
  2253. // if (org.apache.commons.lang3.StringUtils.isNotBlank(refundResult)) {
  2254. // return R.error(refundResult);
  2255. // }
  2256. // } else{
  2257. refundResult = wxRefund(orderInfo,totalActualPrice);
  2258. if(org.apache.commons.lang3.StringUtils.isNotBlank(refundResult)){
  2259. return R.error(refundResult);
  2260. }
  2261. // }
  2262. }
  2263. // 支付宝的退款代码
  2264. } else if(Dict.payFlag.item_alipay.getItem().equals(payFlag)) {
  2265. AliPayMicropayApiResult userRefund = AliPayUtil.aliTradeRefund(order.getOrderSn(), order.getActualPrice().toString(),
  2266. "用户退款", order.getStoreId() + "");
  2267. LOGGER.info(userRefund.getSubMsg());
  2268. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  2269. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  2270. OrderRefundEntity orderRefund = new OrderRefundEntity();
  2271. orderRefund.setRefundId(userRefund.getTradeNo());
  2272. orderRefund.setOutRefundNo(userRefund.getOutTradeNo());
  2273. orderRefund
  2274. .setRefundMoney(new BigDecimal(userRefund.getRefundFee()));
  2275. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_2.getItem()));//退款成功
  2276. orderRefund.setModTime(new Date());
  2277. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  2278. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  2279. orderRefund.setCreateTime(new Date());
  2280. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  2281. if(list.size()>1){//多条订单
  2282. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  2283. }else{
  2284. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  2285. }
  2286. orderRefundDao.save(orderRefund);//退款记录
  2287. }
  2288. orderDao.update(order);//修改为退款成功
  2289. // 修改取货码
  2290. PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(order.getOrderSn());
  2291. pickUpCodeEntity.setPickUpCodeStatus("3");
  2292. pickUpCodeService.update(pickUpCodeEntity);
  2293. // WebSocketServer.delete(sessionId,order.getStoreId(),pickUpCodeEntity);
  2294. updateStock(order, "收银端退款");
  2295. return R.ok("退款成功");
  2296. }
  2297. private String wxRefund(OrderEntity orderInfo,Double totalActualPrice){
  2298. WechatRefundApiResult result = WechatUtil.wxRefund(orderInfo.getOrderSn().toString(), totalActualPrice,
  2299. orderInfo.getActualPrice().doubleValue());
  2300. if (result.getResult_code().equals(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  2301. refund(orderInfo, result);
  2302. } else {
  2303. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  2304. OrderRefundEntity orderRefund = new OrderRefundEntity();
  2305. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  2306. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  2307. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  2308. SysUserEntity user = ShiroUtils.getUserEntity();
  2309. orderRefund.setModerSn(user.getUsername());
  2310. orderRefund.setModTime(new Date());
  2311. // orderRefund.setOutRefundNo(result.getOut_refund_no());
  2312. if (mallOrderRefund != null) {
  2313. orderRefund.setId(mallOrderRefund.getId());
  2314. orderRefundService.update(orderRefund);//退款记录
  2315. }
  2316. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  2317. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  2318. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  2319. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  2320. mallOrderExceptionRecord.setExceptionContent("退款失败" + result.getErr_code_des());
  2321. mallOrderExceptionRecord.setCreateTime(new Date());
  2322. orderExceptionRecordService.save(mallOrderExceptionRecord);
  2323. return result.getErr_code_des();
  2324. }
  2325. return "";
  2326. }
  2327. @Override
  2328. public int queryOffilineOrderTotal(Query query) {
  2329. return orderDao.queryOffilineOrderTotal(query);
  2330. }
  2331. @Override
  2332. public List<PurchaseSalesInStockDetail> purchaseSalesInStockDetailList(Query query) {
  2333. return orderDao.purchaseSalesInStockDetailList(query);
  2334. }
  2335. @Override
  2336. public int purchaseSalesInStockDetailTotal(Query query) {
  2337. return orderDao.purchaseSalesInStockDetailTotal(query);
  2338. }
  2339. @Override
  2340. public List<OrderEntity> queryExportOffilineOrderList(Map<String, Object> params) {
  2341. List<OrderEntity> orderEntityList = orderDao.queryExportOffilineOrderList(params);
  2342. if (orderEntityList!=null && orderEntityList.size()>0){
  2343. for (OrderEntity orderEntity : orderEntityList) {
  2344. // 查询活动价
  2345. BigDecimal topicPrice = orderDao.queryTopicPriceByOrderSnAndSku(orderEntity.getOrderSn(),orderEntity.getSku());
  2346. orderEntity.setTopicPrice(topicPrice);
  2347. }
  2348. }
  2349. return orderEntityList;
  2350. }
  2351. @Override
  2352. public List<OrderEntity> queryMasterExportOffilineOrderList(Map<String, Object> params) {
  2353. return orderDao.queryMasterExportOffilineOrderList(params);
  2354. }
  2355. @Override
  2356. public List<OrderEntity> queryMasterExportList(Map<String, Object> params) {
  2357. return orderDao.queryMasterExportList(params);
  2358. }
  2359. /**
  2360. * 设置订单数据
  2361. * @return
  2362. */
  2363. public OrderVo setOrderVo(List<GoodsEntity> goodsList, UserEntity loginUser, Long storeId, String merchSn, BigDecimal disCountAmount, BigDecimal totalTax){
  2364. OrderVo orderInfo = new OrderVo();
  2365. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  2366. BigDecimal fullCutCouponDec = Constant.ZERO; // 非现金抵扣 = 各种优惠价格 +优惠券的价格 暂时借用这个字段去,为了不改动ccnet系统
  2367. BigDecimal couponPrice = disCountAmount;
  2368. BigDecimal freightPrice = Constant.ZERO;
  2369. BigDecimal actualPrice = Constant.ZERO;
  2370. //订单价格计算:订单的总价+运费
  2371. for (GoodsEntity goodsEntity : goodsList) {
  2372. goodsTotalPrice = goodsTotalPrice
  2373. .add(goodsEntity.getRetailPrice().multiply(new BigDecimal(goodsEntity.getGoodsNumber()))).setScale(2,RoundingMode.HALF_UP);
  2374. fullCutCouponDec = fullCutCouponDec
  2375. .add(goodsEntity.getDiscountedPrice()).setScale(2,RoundingMode.HALF_UP);
  2376. actualPrice = actualPrice
  2377. .add(goodsEntity.getActualPaymentAmount()).setScale(2,RoundingMode.HALF_UP);
  2378. }
  2379. BigDecimal orderTotalPrice = goodsTotalPrice.add(new BigDecimal(0));
  2380. fullCutCouponDec = fullCutCouponDec.add(couponPrice).setScale(2,RoundingMode.HALF_UP);
  2381. // 加上税额
  2382. goodsTotalPrice = goodsTotalPrice.subtract(totalTax).setScale(2,RoundingMode.HALF_UP);
  2383. String orderSn = "ZWCW" + CommonUtil.generateOrderNumber();
  2384. orderInfo.setOrder_sn(orderSn);
  2385. orderInfo.setMerchSn(merchSn);
  2386. orderInfo.setUser_id(loginUser.getId().longValue());
  2387. actualPrice = actualPrice.subtract(couponPrice);
  2388. StoreEntity storeEntity = storeDao.queryObject(storeId);
  2389. //收货地址和运费
  2390. orderInfo.setConsignee(loginUser.getUsername());
  2391. orderInfo.setMobile(loginUser.getMobile());
  2392. orderInfo.setCountry("");
  2393. orderInfo.setProvince(storeEntity.getProvinceName());
  2394. orderInfo.setCity(storeEntity.getCityName());
  2395. orderInfo.setDistrict(storeEntity.getCountyName());
  2396. orderInfo.setAddress(storeEntity.getStoreName());
  2397. orderInfo.setAddress_id(1L);
  2398. orderInfo.setDelivery_date(new Date());
  2399. orderInfo.setDelivery_remark("无");
  2400. orderInfo.setStore_id(storeId);
  2401. orderInfo.setFreight_price(freightPrice.intValue());
  2402. orderInfo.setCoupon_id(Integer.parseInt(String.valueOf(0L)));
  2403. orderInfo.setCoupon_price(couponPrice);
  2404. orderInfo.setCoupon_name("无");
  2405. orderInfo.setActivity_id(0L);
  2406. //使用的促销费用
  2407. orderInfo.setFull_cut_price(fullCutCouponDec);
  2408. orderInfo.setCampMinusId(0);
  2409. orderInfo.setCampName("");
  2410. //留言
  2411. orderInfo.setPostscript("无");
  2412. orderInfo.setAdd_time(new Date());
  2413. orderInfo.setGoods_price(goodsTotalPrice); // 商品总价
  2414. orderInfo.setOrder_price(orderTotalPrice);
  2415. orderInfo.setActual_price(actualPrice); // 实际支付金额
  2416. orderInfo.setOrder_type("1");
  2417. orderInfo.setOrder_status(0);
  2418. orderInfo.setShipping_status(0);
  2419. orderInfo.setPay_status(0);
  2420. orderInfo.setShipping_id(0L);
  2421. orderInfo.setShipping_fee(Constant.ZERO);
  2422. orderInfo.setIntegral(0);
  2423. orderInfo.setIntegral_money(Constant.ZERO);
  2424. orderInfo.setCreateTime(new Date());
  2425. orderInfo.setModTime(new Date());
  2426. orderInfo.setPayMobile(loginUser.getMobile());
  2427. orderInfo.setPayTransactionId("");
  2428. orderInfo.setIsScan("0");//默认未扫描
  2429. orderInfo.setPayMobile(loginUser.getMobile());
  2430. orderInfo.setPay_name(loginUser.getUsername());
  2431. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());
  2432. orderInfo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  2433. return orderInfo;
  2434. }
  2435. public OrderGoodsVo setOrderGoodsVo(OrderVo orderInfo,GoodsEntity goodsDto){
  2436. OrderGoodsVo orderGoodsVo = new OrderGoodsVo();
  2437. orderGoodsVo.setOrder_id(orderInfo.getId());
  2438. orderGoodsVo.setGoods_id(goodsDto.getId());
  2439. orderGoodsVo.setGoods_sn(goodsDto.getGoodsSn());
  2440. orderGoodsVo.setProduct_id(Long.valueOf(goodsDto.getProductId()));
  2441. orderGoodsVo.setGoods_name(goodsDto.getName());
  2442. orderGoodsVo.setList_pic_url(goodsDto.getListPicUrl());
  2443. orderGoodsVo.setMarket_price(goodsDto.getStoreMarketPrice());
  2444. orderGoodsVo.setRetail_price(goodsDto.getStoreRetailPrice());
  2445. orderGoodsVo.setDiscountedPrice(goodsDto.getDiscountedPrice());
  2446. orderGoodsVo.setActualPaymentAmount(goodsDto.getActualPaymentAmount());
  2447. orderGoodsVo.setNumber(goodsDto.getGoodsNumber());
  2448. // orderGoodsVo.setGoods_specification_name_value(goodsDto.get);
  2449. // orderGoodsVo.setGoods_specification_ids(goodsItem.getGoods_specification_ids());
  2450. orderGoodsVo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  2451. orderGoodsVo.setCreateTime(new Date());
  2452. orderGoodsVo.setModTime(new Date());
  2453. orderGoodsVo.setActivity(goodsDto.getActivity());
  2454. orderGoodsVo.setGoodsRate(goodsDto.getGoodsRate());
  2455. orderGoodsVo.setSku(goodsDto.getSku());
  2456. BigDecimal number = new BigDecimal(Long.valueOf(goodsDto.getGoodsNumber()));
  2457. BigDecimal goodsTotal = goodsDto.getRetailPrice().multiply(number);//单商品总价
  2458. BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(),2, BigDecimal.ROUND_HALF_UP);//当前商品总价/订单总价(不含运费、不含优惠券)
  2459. BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  2460. BigDecimal settlePrice = Constant.ZERO; // ccnet 取的这个而价格
  2461. if(orderInfo.getFreight_price() != 0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  2462. //运费-优惠券
  2463. BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  2464. //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 当前商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  2465. settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  2466. }else{
  2467. if(orderInfo.getFreight_price()!=0){
  2468. //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  2469. BigDecimal freightRate = rate.multiply(freightPrice);
  2470. //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  2471. settlePrice = goodsTotal.add(freightRate);
  2472. }
  2473. if(!"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  2474. //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  2475. BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  2476. //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  2477. settlePrice = goodsTotal.subtract(couponRate);
  2478. }
  2479. }
  2480. if(settlePrice.compareTo(BigDecimal.valueOf(0)) == 0){
  2481. orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  2482. }else{
  2483. orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  2484. }
  2485. return orderGoodsVo;
  2486. }
  2487. }