OrderServiceImpl.java 138 KB

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