OrderServiceImpl.java 144 KB

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