OrderServiceImpl.java 139 KB

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