OrderServiceImpl.java 262 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461446244634464446544664467446844694470447144724473447444754476447744784479448044814482448344844485448644874488448944904491449244934494449544964497449844994500450145024503450445054506450745084509451045114512451345144515451645174518451945204521452245234524452545264527452845294530453145324533453445354536453745384539454045414542454345444545454645474548454945504551455245534554455545564557455845594560456145624563456445654566456745684569457045714572457345744575457645774578457945804581458245834584458545864587458845894590459145924593459445954596459745984599460046014602460346044605460646074608460946104611461246134614461546164617461846194620462146224623462446254626462746284629463046314632463346344635463646374638463946404641464246434644464546464647464846494650465146524653465446554656465746584659466046614662466346644665466646674668466946704671467246734674467546764677467846794680468146824683468446854686468746884689469046914692469346944695469646974698469947004701470247034704470547064707470847094710471147124713471447154716471747184719472047214722472347244725472647274728472947304731473247334734473547364737473847394740474147424743474447454746474747484749475047514752475347544755475647574758475947604761476247634764476547664767476847694770477147724773477447754776477747784779478047814782478347844785478647874788478947904791479247934794479547964797479847994800480148024803480448054806480748084809481048114812481348144815481648174818481948204821482248234824482548264827482848294830483148324833483448354836483748384839484048414842484348444845484648474848484948504851485248534854485548564857485848594860486148624863486448654866486748684869487048714872487348744875487648774878487948804881488248834884488548864887488848894890489148924893489448954896489748984899490049014902490349044905490649074908490949104911491249134914491549164917491849194920492149224923492449254926492749284929493049314932
  1. package com.kmall.admin.service.impl;
  2. import cn.hutool.core.lang.UUID;
  3. import com.alibaba.fastjson.JSON;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.fasterxml.jackson.core.type.TypeReference;
  6. import com.google.common.collect.ImmutableBiMap;
  7. import com.google.common.collect.Maps;
  8. import com.google.gson.Gson;
  9. import com.google.gson.internal.LinkedTreeMap;
  10. import com.kmall.admin.cuspay.biz.ali.AliCusDeclareBiz;
  11. import com.kmall.admin.cuspay.biz.wx.WxCusDeclareBiz;
  12. import com.kmall.admin.dao.*;
  13. import com.kmall.admin.dao.alarm.Mall2LowPriceWarningDao;
  14. import com.kmall.admin.dao.mk.Mk2GoodsTopicPriceDao;
  15. import com.kmall.admin.dao.mk.Mk2MemberBirthdayDao;
  16. import com.kmall.admin.dao.mk.store.MkStorePromOrderRealDao;
  17. import com.kmall.admin.dao.mk.store.MkStorePromTypeDao;
  18. import com.kmall.admin.dao.mk.store.StoreTopicDao;
  19. import com.kmall.admin.dao.vip.Mall2MemberConsumptionRecordsDao;
  20. import com.kmall.admin.dao.vip.Mall2MemberPointsDao;
  21. import com.kmall.admin.dao.vip.Mall2PointsRulesDao;
  22. import com.kmall.admin.dto.*;
  23. import com.kmall.admin.entity.*;
  24. import com.kmall.admin.entity.haikong.HaiKongMemberOrderSyncResendEntity;
  25. import com.kmall.admin.entity.haikong.HaiKongMemberScoreChangeRecordEntity;
  26. import com.kmall.admin.entity.haikong.IntegralGoBackEntity;
  27. import com.kmall.admin.entity.mk.MkActivitiesEntity;
  28. import com.kmall.admin.entity.mk.MkActivitiesScoreEntity;
  29. import com.kmall.admin.entity.mk.store.MkStorePromOrderRealEntity;
  30. import com.kmall.admin.entity.record.NewRetailOrderRestoreStockRecordEntity;
  31. import com.kmall.admin.entity.vip.Mall2MemberConsumptionRecordsEntity;
  32. import com.kmall.admin.entity.vip.Mall2MemberPointsEntity;
  33. import com.kmall.admin.entity.vip.Mall2PointsRulesEntity;
  34. import com.kmall.admin.fromcomm.dao.SysConfigDao;
  35. import com.kmall.admin.fromcomm.entity.SysUserEntity;
  36. import com.kmall.admin.haikong.constant.*;
  37. import com.kmall.admin.haikong.dto.*;
  38. import com.kmall.admin.haikong.utils.ListUtils;
  39. import com.kmall.admin.haikong.vo.CalculateOrderDiscountPriceResponseVO;
  40. import com.kmall.admin.haikong.vo.PointsRulesAndDetailVO;
  41. import com.kmall.admin.haikong.vo.QueryGoodsVO;
  42. import com.kmall.admin.haikong.client.HaiKongMemberTemplate;
  43. import com.kmall.admin.haikong.client.HaiKongWarehouseTemplate;
  44. import com.kmall.admin.haikong.client.VmcShopTemplate;
  45. import com.kmall.admin.haikong.config.HaiKongProperties;
  46. import com.kmall.admin.haikong.utils.Response;
  47. import com.kmall.admin.service.*;
  48. import com.kmall.admin.service.haikong.HaiKongMemberOrderSyncResendService;
  49. import com.kmall.admin.service.haikong.HaiKongMemberScoreChangeRecordService;
  50. import com.kmall.admin.service.mk.MkActivitiesScoreService;
  51. import com.kmall.admin.service.mk.MkActivitiesService;
  52. import com.kmall.admin.service.mk.store.MkStoreCampMinusService;
  53. import com.kmall.admin.service.mk.store.MkStoreTicketDiscountService;
  54. import com.kmall.admin.service.record.NewRetailOrderRestoreStockRecordService;
  55. import com.kmall.admin.service.vip.Mall2PointsRulesService;
  56. import com.kmall.admin.utils.CalculateTax;
  57. import com.kmall.admin.utils.ShiroUtils;
  58. import com.kmall.admin.utils.data.response.ResponseMessage;
  59. import com.kmall.admin.utils.data.response.ResponseMessageData;
  60. import com.kmall.admin.utils.jackson.JacksonUtil;
  61. import com.kmall.admin.utils.oms.OmsSign;
  62. import com.kmall.admin.utils.pdf.BarcodeUtil;
  63. import com.kmall.admin.haikong.vo.CalculateOrderDiscountPriceVO;
  64. import com.kmall.admin.websocket.WebSocketServer;
  65. import com.kmall.api.entity.OrderGoodsRestoreVo;
  66. import com.kmall.api.entity.OrderGoodsVo;
  67. import com.kmall.api.entity.OrderVo;
  68. import com.kmall.api.util.CommonUtil;
  69. import com.kmall.common.constant.Dict;
  70. import com.kmall.common.utils.*;
  71. import com.kmall.common.utils.print.ticket.item.*;
  72. import com.kmall.common.utils.wechat.WechatMicropayApiResult;
  73. import com.kmall.common.utils.wechat.WechatRefundApiResult;
  74. import com.kmall.common.utils.wechat.WechatReverseApiResult;
  75. import com.kmall.manager.manager.alipay.AliPayMicropayApiResult;
  76. import com.kmall.manager.manager.alipay.AliPayRequestParams;
  77. import com.kmall.manager.manager.alipay.AliPayUtil;
  78. import com.kmall.manager.manager.express.kdn.KdniaoUtil;
  79. import com.kmall.manager.manager.express.sf.ServiceException;
  80. import com.kmall.manager.manager.express.sf.entity.RouteEntity;
  81. import com.kmall.manager.manager.express.sf.entity.RouteResponseEntity;
  82. import com.kmall.manager.manager.express.sf.entity.SfRouteServiceResponseEntity;
  83. import com.kmall.manager.manager.express.sf.properties.SFPropertiesBuilder;
  84. import com.kmall.manager.manager.express.sf.properties.SFUtil;
  85. import com.kmall.manager.manager.merch.OmsMerchProperties;
  86. import com.kmall.manager.manager.merch.OmsMerchPropertiesBuilder;
  87. import com.kmall.manager.manager.print.ticket.PrintTicketPropertiesBuilder;
  88. import com.kmall.manager.manager.print.ticket.TicketPrintUtil;
  89. import com.kmall.manager.manager.redis.JedisUtil;
  90. import com.kmall.manager.manager.wechat.WechatUtil;
  91. import com.kmall.manager.manager.wechat.wxglobal.dto.WechatGlobalRefundApiResult;
  92. import okhttp3.Request;
  93. import org.slf4j.Logger;
  94. import org.slf4j.LoggerFactory;
  95. import org.springframework.beans.BeanUtils;
  96. import org.springframework.beans.factory.annotation.Autowired;
  97. import org.springframework.stereotype.Service;
  98. import org.springframework.transaction.annotation.Transactional;
  99. import org.springframework.util.CollectionUtils;
  100. import java.io.IOException;
  101. import java.math.BigDecimal;
  102. import java.math.RoundingMode;
  103. import java.net.InetAddress;
  104. import java.net.URLDecoder;
  105. import java.text.ParseException;
  106. import java.text.SimpleDateFormat;
  107. import java.util.*;
  108. import java.util.concurrent.*;
  109. import java.util.concurrent.atomic.AtomicBoolean;
  110. import java.util.concurrent.atomic.AtomicReference;
  111. import java.util.stream.Collectors;
  112. @Service("orderService")
  113. public class OrderServiceImpl implements OrderService {
  114. private final Logger LOGGER = LoggerFactory.getLogger(OrderServiceImpl.class);
  115. @Autowired
  116. private OmsMerchProperties omsMerchProperties;
  117. @Autowired
  118. private OrderDao orderDao;
  119. @Autowired
  120. private ShippingDao shippingDao;
  121. @Autowired
  122. private OrderGoodsDao orderGoodsDao;
  123. @Autowired
  124. private OrderGoodsService orderGoodsService;
  125. @Autowired
  126. private ProductStoreRelaService productStoreRelaService;
  127. @Autowired
  128. private NewRetailOrderRestoreStockRecordService newRetailOrderRestoreStockRecordService;
  129. @Autowired
  130. private SysPrinterDao printerDao;
  131. @Autowired
  132. private UserDao userDao;
  133. @Autowired
  134. private UserCouponDao userCouponDao;
  135. @Autowired
  136. private ProductStoreRelaDao productStoreRelaDao;
  137. @Autowired
  138. private OrderProcessRecordDao orderProcessRecordDao;
  139. @Autowired
  140. private OrderRefundDao orderRefundDao;
  141. @Autowired
  142. private StoreDao storeDao;
  143. @Autowired
  144. private OfflineCartDao offlineCartDao;
  145. @Autowired
  146. private GoodsDao goodsDao;
  147. @Autowired
  148. private MerchDao merchDao;
  149. @Autowired
  150. private MngChangeDao mngChangeDao;
  151. @Autowired
  152. private StoreMngChangeDao storeMngChangeDao;
  153. @Autowired
  154. private ThirdMerchExpressDao thirdMerchExpressDao;
  155. @Autowired
  156. private MkStorePromOrderRealDao mkStorePromOrderRealDao;
  157. @Autowired
  158. private UserCampMinusDao userCampMinusDao;
  159. @Autowired
  160. private UserService userService;
  161. @Autowired
  162. private SysConfigDao sysConfigDao;
  163. @Autowired
  164. private ProductDao productDao;
  165. @Autowired
  166. private GoodsService goodsService;
  167. @Autowired
  168. private OrderWXPayRecordService orderWXPayRecordService;
  169. @Autowired
  170. private StoreService storeService;
  171. @Autowired
  172. private PickUpCodeService pickUpCodeService;
  173. @Autowired
  174. private MkStoreCampMinusService mkStoreCampMinusService;
  175. @Autowired
  176. private MkStoreTicketDiscountService mkStoreTicketDiscountService;
  177. @Autowired
  178. private CashierDao cashierDao; // 收银机查询
  179. @Autowired
  180. private CashierLoginRecordDao cashierLoginRecordDao; // 收银员登录记录
  181. @Autowired
  182. private SaleRecordDao saleRecordDao; // 销售记录
  183. @Autowired
  184. private StoreTopicDao storeTopicDao; // 查询是否有门店活动
  185. @Autowired
  186. private Mk2GoodsTopicPriceDao mk2GoodsTopicPriceDao; // 门店商品价格
  187. @Autowired
  188. private Mall2PointsRulesDao pointsRulesDao; // 积分规则
  189. @Autowired
  190. private Mall2PointsRulesService mall2PointsRulesService;
  191. @Autowired
  192. private Mall2MemberPointsDao memberPointsDao; // 用户积分
  193. @Autowired
  194. private Mall2MemberConsumptionRecordsDao memberConsumptionRecordsDao; // 会员消费记录
  195. @Autowired
  196. private MkStorePromTypeDao storePromTypeDao; // 优惠类型
  197. @Autowired
  198. private Mk2MemberBirthdayDao memberBirthdayDao; // 生日优惠
  199. @Autowired
  200. private MerchUserDao merchUserDao;
  201. @Autowired
  202. private Mall2LowPriceWarningDao lowPriceWarningDao;
  203. @Autowired
  204. private OrderRefundService orderRefundService;
  205. @Autowired
  206. private OrderExceptionRecordService orderExceptionRecordService;
  207. @Autowired
  208. private AddressInfoService addressInfoService;
  209. @Autowired
  210. private HaiKongMemberTemplate haiKongMemberTemplate;
  211. @Autowired
  212. private HaiKongWarehouseTemplate haiKongWarehouseTemplate;
  213. @Autowired
  214. private HaiKongProperties haiKongProperties;
  215. /**
  216. * 免税mall接口工具类
  217. */
  218. @Autowired
  219. private VmcShopTemplate vmcShopTemplate;
  220. @Autowired
  221. private MkActivitiesService mkActivitiesService;
  222. /**
  223. * 满赠
  224. */
  225. @Autowired
  226. private MkActivitiesFullGiftService mkActivitiesFullGiftService;
  227. /**
  228. * 优惠券
  229. */
  230. @Autowired
  231. private MkActivitiesCouponService mkActivitiesCouponService;
  232. /**
  233. * 限时特价
  234. */
  235. @Autowired
  236. private MkActivitiesPromotionService mkActivitiesPromotionService;
  237. /**
  238. * 日志记录
  239. */
  240. @Autowired
  241. private InterfaceSendLogDao interfaceSendLogDao;
  242. /**
  243. * 同步订单消费信息,重发业务
  244. */
  245. @Autowired
  246. private HaiKongMemberOrderSyncResendService haiKongMemberOrderSyncResendService;
  247. /**
  248. * 会员积分变动业务
  249. */
  250. @Autowired
  251. private HaiKongMemberScoreChangeRecordService haiKongMemberScoreChangeRecordService;
  252. /**
  253. * 接口重发信息
  254. */
  255. @Autowired
  256. private HaiKongResendMsgDao haiKongResendMsgDao;
  257. /**
  258. * 获取发货、收货人地址
  259. */
  260. @Autowired
  261. private AddressDao addressDao;
  262. @Autowired
  263. private MkActivitiesScoreService mkActivitiesScoreService;
  264. /**
  265. * 微信海关申报
  266. */
  267. @Autowired
  268. private WxCusDeclareBiz wxCusDeclareBiz;
  269. /**
  270. * 支付宝海关申报
  271. */
  272. @Autowired
  273. private AliCusDeclareBiz aliCusDeclareBiz;
  274. @Override
  275. public OrderEntity queryObject(Long id) {
  276. return orderDao.queryObject(id);
  277. }
  278. @Override
  279. public Double getTotalActualPrice(String merchOrderSn) {
  280. return orderDao.getTotalActualPrice(merchOrderSn);
  281. }
  282. @Override
  283. public List<OrderEntity> queryList(Map<String, Object> map) {
  284. return orderDao.queryList(map);
  285. }
  286. @Override
  287. public int queryTotal(Map<String, Object> map) {
  288. return orderDao.queryTotal(map);
  289. }
  290. @Override
  291. public int save(OrderEntity order) {
  292. return orderDao.save(order);
  293. }
  294. @Override
  295. public int update(OrderEntity order) {
  296. return orderDao.update(order);
  297. }
  298. /**
  299. * 取消订单
  300. *
  301. * @param order
  302. */
  303. @Override
  304. public void cancelOrder(OrderEntity order) {
  305. boolean needUpdateStock = true;
  306. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  307. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_101.getItem()));
  308. }
  309. orderDao.update(order);
  310. if (!needUpdateStock) {
  311. return;
  312. }
  313. // 更新库存
  314. updateStock(order, "管理后台取消订单");
  315. // 释放优惠券
  316. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  317. if (null != couponVo) {
  318. userCouponDao.cancelOrder(couponVo);
  319. }
  320. //释放促销满减券
  321. UserCampMinusEntity userCampMinusVo = userCampMinusDao.queryUserCampByOrderId(order.getId());
  322. if (null != userCampMinusVo) {
  323. userCampMinusDao.cancelUserCampOrder(userCampMinusVo);
  324. }
  325. }
  326. @Override
  327. public int delete(Long id) {
  328. return orderDao.delete(id);
  329. }
  330. @Override
  331. public int deleteBatch(Long[] ids) {
  332. return orderDao.deleteBatch(ids);
  333. }
  334. @Override
  335. public int confirm(Long id) {
  336. OrderEntity orderEntity = queryObject(id);
  337. Integer shippingStatus = orderEntity.getShippingStatus();//发货状态
  338. Integer payStatus = orderEntity.getPayStatus();//付款状态
  339. if (2 != payStatus) {
  340. throw new RRException("此订单未付款,不能确认收货!");
  341. }
  342. if (4 == shippingStatus) {
  343. throw new RRException("此订单处于退货状态,不能确认收货!");
  344. }
  345. if (0 == shippingStatus) {
  346. throw new RRException("此订单未发货,不能确认收货!");
  347. }
  348. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  349. throw new RRException("此订单已完成!");
  350. }
  351. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  352. throw new RRException("此订单待付款!");
  353. }
  354. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_100.getItem())) {
  355. throw new RRException("此订单付款中!");
  356. }
  357. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  358. throw new RRException("此订单已取消!");
  359. }
  360. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  361. throw new RRException("此订单已删除!");
  362. }
  363. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  364. throw new RRException("此订单还未发货!");
  365. }
  366. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem())) {
  367. throw new RRException("此订单已退款!");
  368. }
  369. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  370. throw new RRException("此订单已退款!");
  371. }
  372. orderEntity.setShippingStatus(2);
  373. orderEntity.setOrderStatus(301);
  374. orderEntity.setConfirmTime(new Date());
  375. orderDao.update(orderEntity);
  376. return 0;
  377. }
  378. @Override
  379. public int sendGoods(OrderEntity order) {
  380. Integer payStatus = order.getPayStatus();//付款状态
  381. if (2 != payStatus) {
  382. throw new RRException("此订单未付款!");
  383. }
  384. ShippingEntity shippingEntity = shippingDao.queryObject(order.getShippingId());
  385. if (null != shippingEntity) {
  386. order.setShippingName(shippingEntity.getName());
  387. }
  388. order.setOrderStatus(300);//订单已发货
  389. order.setShippingStatus(1);//已发货
  390. return orderDao.update(order);
  391. }
  392. @Override
  393. public Ticket printMsg(Long id) {
  394. OrderEntity orderEntity = queryInfos(id);
  395. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  396. // 获取门店
  397. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  398. // 获取清关信息
  399. OrderProcessRecordEntity orderProcessRecordEntity =
  400. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  401. // 小票头
  402. TicketHead head = new TicketHead();
  403. head.setTitle(OmsMerchPropertiesBuilder.instance().getMerchName() + storeEntity.getStoreName());
  404. // head.setMemberId(orderEntity.getUserName().toString());
  405. head.setOrderId(orderEntity.getOrderSn());
  406. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(new Date()));
  407. // 商品信息
  408. Integer goodsTotal = 0; // 商品总个数
  409. BigDecimal total = Constant.ZERO; // 商品总计
  410. BigDecimal taxTotal = Constant.ZERO; //税费总计
  411. List<Goods> goodsList = new ArrayList<>();
  412. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  413. goodsTotal += orderGoods.getNumber();
  414. total = total.add(orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  415. .setScale(2, BigDecimal.ROUND_HALF_UP);
  416. BigDecimal currentTax = orderGoods.getGoodsRate().multiply(orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  417. .setScale(2, BigDecimal.ROUND_HALF_UP);
  418. taxTotal = taxTotal.add(currentTax);
  419. Goods goods = new Goods(orderGoods.getGoodsName(),
  420. orderGoods.getRetailPrice().toString(),
  421. currentTax.toString(),
  422. orderGoods.getNumber().toString(),
  423. new BigDecimal(orderGoods.getNumber()).multiply(orderGoods.getRetailPrice()).setScale(2, RoundingMode.HALF_UP).toString());
  424. goodsList.add(goods);
  425. LOGGER.info(goods.toString());
  426. }
  427. // 收银信息
  428. CashInfo cashInfo = new CashInfo();
  429. cashInfo.setGoodsTotal(goodsTotal.toString());
  430. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  431. cashInfo.setTaxTotal(taxTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  432. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  433. cashInfo.setOddChange("0.00");
  434. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  435. cashInfo.setFreight(
  436. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  437. cashInfo.setPaymentMode("微信支付");
  438. // 海关清单
  439. CusListing cusListing = new CusListing();
  440. cusListing.setOrderId(orderEntity.getOrderSn());
  441. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  442. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  443. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  444. cusListing.setConsignee(orderEntity.getConsignee());
  445. cusListing.setConsigneeTel(orderEntity.getMobile());
  446. }
  447. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  448. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  449. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing);
  450. }
  451. @Override
  452. public Ticket printMsg(Long id, String sessionId) throws Exception {
  453. OrderEntity orderEntity = queryInfos(id);
  454. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  455. // 获取门店
  456. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  457. // 获取清关信息
  458. OrderProcessRecordEntity orderProcessRecordEntity =
  459. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  460. // 小票头
  461. TicketHead head = new TicketHead();
  462. head.setTitle(storeEntity.getStoreName());
  463. //门店地址
  464. head.setStoreAddress(storeEntity.getStoreAddress());
  465. // head.setMemberId(orderEntity.getUserName().toString());
  466. head.setOrderId(orderEntity.getOrderSn());
  467. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(orderEntity.getPayTime()));
  468. // 商品信息
  469. Integer goodsTotal = 0; // 商品总个数
  470. BigDecimal total = Constant.ZERO; // 商品总计
  471. BigDecimal taxTotal = Constant.ZERO; //税费总计
  472. List<Goods> goodsList = new ArrayList<>();
  473. BigDecimal discountedPrice = Constant.ZERO; // 优惠金额
  474. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  475. goodsTotal += orderGoods.getNumber();
  476. total = total.add(orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  477. .setScale(2, BigDecimal.ROUND_HALF_UP);
  478. discountedPrice = discountedPrice.add(orderGoods.getDiscountedPrice());
  479. // 税前价
  480. BigDecimal beforeTaxPrice = orderGoods.getRetailPrice().divide(new BigDecimal(1).add(orderGoods.getGoodsRate()), 2, RoundingMode.HALF_UP);
  481. GoodsEntity goodsEntity = goodsService.queryObject(orderGoods.getGoodsId());
  482. BigDecimal goodsTax = CalculateTax.calculateFinalTax(goodsEntity, orderGoods.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  483. goodsTax = goodsTax.multiply(new BigDecimal(orderGoods.getNumber())).setScale(2, RoundingMode.HALF_UP);
  484. taxTotal = taxTotal.add(goodsTax).setScale(2, RoundingMode.HALF_UP);
  485. Goods goods = new Goods(orderGoods.getGoodsName(),
  486. orderGoods.getRetailPrice().toString(), // 含税价
  487. // beforeTaxPrice.toString(),// 税前价
  488. goodsTax.toString(),
  489. orderGoods.getNumber().toString(),
  490. new BigDecimal(orderGoods.getNumber()).multiply(orderGoods.getRetailPrice()).setScale(2, RoundingMode.HALF_UP).toString(),
  491. orderGoods.getDiscountedPrice().toString());
  492. goodsList.add(goods);
  493. }
  494. // 收银信息
  495. CashInfo cashInfo = new CashInfo();
  496. cashInfo.setGoodsTotal(goodsTotal.toString());
  497. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  498. cashInfo.setTaxTotal(taxTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  499. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  500. cashInfo.setOddChange(discountedPrice.toString());
  501. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  502. cashInfo.setFreight(
  503. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  504. if ("alipay".equals(orderEntity.getPayFlag())) {
  505. cashInfo.setPaymentMode("支付宝支付");
  506. } else {
  507. cashInfo.setPaymentMode("微信支付");
  508. }
  509. // 海关清单
  510. CusListing cusListing = new CusListing();
  511. cusListing.setOrderId(orderEntity.getOrderSn());
  512. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  513. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  514. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo());
  515. cusListing.setConsignee(orderEntity.getConsignee());
  516. // 脱敏设置
  517. if (StringUtils.isNotEmpty(cusListing.getConsignee()) && cusListing.getConsignee().length() > 1) {
  518. cusListing.setConsignee(new StringBuilder(cusListing.getConsignee()).replace(1, 2, "*").toString());
  519. }
  520. cusListing.setConsigneeTel(orderEntity.getMobile());
  521. if (StringUtils.isNotEmpty(cusListing.getConsigneeTel())) {
  522. cusListing.setConsigneeTel(new StringBuilder(cusListing.getConsigneeTel()).replace(3, 7, "****").toString());
  523. // cusListing.setConsigneeTel(cusListing.getConsigneeTel());
  524. }
  525. }
  526. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  527. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  528. // 尝试在取货码表中查询数据,如果有的话就改变状态
  529. String orderSn = orderEntity.getOrderSn();
  530. PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(orderSn);
  531. if (pickUpCodeEntity != null) {
  532. pickUpCodeEntity.setPickUpCodeStatus("1");
  533. pickUpCodeService.update(pickUpCodeEntity);
  534. }
  535. TicketMailInfo mailInfo = new TicketMailInfo();
  536. String exprNo = orderProcessRecordEntity.getLogisticsNo();
  537. // if (StringUtils.isNullOrEmpty(exprNo)) {
  538. // throw new RRException("快递面单为空,请联系客服");
  539. // }
  540. //图片地址
  541. mailInfo.setStoreImgUrl(storeEntity.getStoreImgUrl()==null?"/statics/img/cw_qrcode.png":storeEntity.getStoreImgUrl().trim());
  542. if (!StringUtils.isNullOrEmpty(exprNo)) {
  543. byte[] barCode128 = BarcodeUtil.generateBarCode128(exprNo, 6.0D, null, true, false);
  544. String exprNoBase64Img = new String(Base64.getEncoder().encode(barCode128));
  545. mailInfo.setExprNoBase64Img(exprNoBase64Img);
  546. mailInfo.setExprNo(exprNo);
  547. String logoUrl = "/statics/img/sf_img.jpg";
  548. Map<String, String> logoMap = new HashMap<>();
  549. logoMap.put("yto", "/statics/img/yto_logo.jpg");
  550. logoMap.put("best", "/statics/img/bestex_logo3.png");
  551. logoMap.put("sf", "/statics/img/sf_img.jpg");
  552. if (StringUtils.isNotEmpty(orderEntity.getShippingCode()) && logoMap.containsKey(orderEntity.getShippingCode())) {
  553. logoUrl = logoMap.get(orderEntity.getShippingCode());
  554. }
  555. mailInfo.setExprLogoUrl(logoUrl);
  556. }
  557. mailInfo.setShopTel(storeEntity.getTelephoneNumber());
  558. AddressEntity addressEntity = addressDao.queryStoreAddress(storeEntity.getId(),Dict.addressStatus.item_1.getItem());
  559. // 发货人
  560. mailInfo.setSenderTel(addressEntity.getTelNumber());
  561. mailInfo.setSenderName(addressEntity.getSenderName());
  562. mailInfo.setSenderProvince(addressEntity.getProvinceName());
  563. mailInfo.setSenderCity(addressEntity.getCityName());
  564. mailInfo.setSenderDistrict(addressEntity.getCountyName());
  565. mailInfo.setSenderAddress(addressEntity.getDetailInfo());
  566. // 收货人
  567. mailInfo.setConsigneeMob(new StringBuilder(orderEntity.getMobile()).replace(3, 7, "****").toString());
  568. // mailInfo.setConsigneeMob(orderEntity.getMobile());
  569. mailInfo.setConsigneeName(new StringBuilder(orderEntity.getConsignee()).replace(1, 2, "*").toString());
  570. mailInfo.setConsigneeProvince(orderEntity.getProvince());
  571. mailInfo.setConsigneeCity(orderEntity.getCity());
  572. mailInfo.setConsigneeDistrict(orderEntity.getDistrict());
  573. mailInfo.setConsigneeAddress(orderEntity.getAddress());
  574. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing, mailInfo);
  575. }
  576. /**
  577. * 退款
  578. */
  579. @Override
  580. @Transactional
  581. public void refund(OrderEntity order) {
  582. boolean needUpdateStock = true;
  583. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  584. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  585. }
  586. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  587. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  588. }
  589. orderDao.update(order);//修改为退款中
  590. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  591. /*// 判断是否有优惠券
  592. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  593. if (null != couponVo) {
  594. userCouponDao.cancelOrder(couponVo);
  595. }
  596. if (!needUpdateStock) {
  597. return;
  598. }
  599. // 更新库存
  600. updateStock(order, "管理后台订单退款");*/
  601. // updateStock(order, "管理后台订单退款");
  602. queryStorePromRealUpdateIsScan(order);
  603. }
  604. /**
  605. * 退款
  606. */
  607. @Transactional
  608. public void refund(OrderEntity order, WechatRefundApiResult result) {
  609. boolean needUpdateStock = true;
  610. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  611. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  612. }
  613. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  614. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  615. } else {
  616. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_5.getItem()));
  617. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  618. OrderRefundEntity orderRefund = new OrderRefundEntity();
  619. orderRefund.setRefundId(result.getRefund_id());
  620. try {
  621. orderRefund.setOutRefundNo(result.getOut_trade_no());
  622. } catch (Exception e) {
  623. e.printStackTrace();
  624. }
  625. orderRefund.setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  626. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  627. orderRefund.setModTime(new Date());
  628. if (mallOrderRefund != null) {
  629. orderRefund.setId(mallOrderRefund.getId());
  630. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  631. orderRefundDao.update(orderRefund);
  632. } else {
  633. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  634. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  635. orderRefund.setCreateTime(new Date());
  636. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  637. if (list.size() > 1) {//多条订单
  638. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  639. } else {
  640. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  641. }
  642. orderRefundDao.save(orderRefund);//退款记录
  643. }
  644. }
  645. orderDao.update(order);//
  646. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  647. /*// 判断是否有优惠券
  648. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  649. if (null != couponVo) {
  650. userCouponDao.cancelOrder(couponVo);
  651. }
  652. if (!needUpdateStock) {
  653. return;
  654. }
  655. // 更新库存
  656. updateStock(order, "管理后台订单退款");*/
  657. // updateStock(order, "管理后台订单退款");
  658. queryStorePromRealUpdateIsScan(order);
  659. }
  660. @Transactional
  661. public void refund(OrderEntity order, AliPayMicropayApiResult result) {
  662. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  663. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  664. }
  665. if (Dict.payFlag.item_cash.getItem().equals(order.getPayFlag())) {
  666. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  667. } else {
  668. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_4.getItem()));
  669. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  670. OrderRefundEntity orderRefund = new OrderRefundEntity();
  671. orderRefund.setRefundId(result.getTradeNo());
  672. orderRefund.setOutRefundNo(result.getOutTradeNo());
  673. orderRefund
  674. .setRefundMoney(new BigDecimal(result.getRefundFee()).divide(Constant.ONE_HUNDRED));
  675. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_2.getItem()));//退款处理中
  676. orderRefund.setModTime(new Date());
  677. if (mallOrderRefund != null) {
  678. orderRefund.setId(mallOrderRefund.getId());
  679. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  680. orderRefundDao.update(orderRefund);
  681. } else {
  682. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  683. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  684. orderRefund.setCreateTime(new Date());
  685. List<OrderEntity> list = orderDao.queryObjectByMerchOrderSn(order.getMerchOrderSn());
  686. if (list.size() > 1) {//多条订单
  687. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  688. } else {
  689. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  690. }
  691. orderRefundDao.save(orderRefund);//退款记录
  692. }
  693. }
  694. orderDao.update(order);//修改为退款中
  695. updateStock(order, "收银端退款");
  696. }
  697. /**
  698. * 平安退款逻辑处理
  699. *
  700. * @param order
  701. * @param result
  702. */
  703. @Transactional
  704. public void pinganRefund(OrderEntity order, net.sf.json.JSONObject result, String refundId) {
  705. boolean needUpdateStock = true;
  706. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  707. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  708. }
  709. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  710. OrderRefundEntity orderRefund = new OrderRefundEntity();
  711. orderRefund.setRefundId(refundId);
  712. orderRefund.setOutRefundNo(result.getString("ord_no"));
  713. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  714. orderRefund.setModTime(new Date());
  715. orderRefund.setRefundMoney(BigDecimal.valueOf(result.getInt("trade_amount")).divide(Constant.ONE_HUNDRED));
  716. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  717. if (mallOrderRefund != null) {
  718. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  719. orderRefund.setId(mallOrderRefund.getId());
  720. orderRefundDao.update(orderRefund);
  721. } else {//退款记录不存在
  722. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  723. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  724. orderRefund.setCreateTime(new Date());
  725. orderRefundDao.save(orderRefund);//退款记录
  726. }
  727. orderDao.update(order);//修改为退款中
  728. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  729. /*// 判断是否有优惠券
  730. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  731. if (null != couponVo) {
  732. userCouponDao.cancelOrder(couponVo);
  733. }
  734. if (!needUpdateStock) {
  735. return;
  736. }
  737. // 更新库存
  738. updateStock(order, "管理后台平安退款订单");*/
  739. queryStorePromRealUpdateIsScan(order);
  740. }
  741. /**
  742. * 微信国际退款逻辑处理
  743. *
  744. * @param order
  745. * @param result
  746. */
  747. @Transactional
  748. public void globalRefund(OrderEntity order, WechatGlobalRefundApiResult result) {
  749. boolean needUpdateStock = true;
  750. if (order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  751. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  752. }
  753. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_3.getItem()));
  754. OrderRefundEntity orderRefund = new OrderRefundEntity();
  755. orderRefund.setRefundId(result.getRefund_id());
  756. orderRefund.setOutRefundNo(result.getOut_refund_no());
  757. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_5.getItem()));//退款处理中
  758. orderRefund.setModTime(new Date());
  759. orderRefund.setRefundMoney(BigDecimal.valueOf(Long.valueOf(result.getRefund_fee())).divide(Constant.ONE_HUNDRED));
  760. orderRefund.setRefundFeeType(result.getRefund_fee_type());
  761. if (org.apache.commons.lang3.StringUtils.isNotEmpty(result.getTotal_fee())) {
  762. orderRefund.setTotalFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getTotal_fee())).divide(Constant.ONE_HUNDRED).toString()));
  763. }
  764. orderRefund.setFeeType(result.getFee_type());
  765. if (org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_fee())) {
  766. orderRefund.setCashFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_fee())).divide(Constant.ONE_HUNDRED).toString()));
  767. }
  768. orderRefund.setCashFeeType(result.getCash_fee_type());
  769. if (org.apache.commons.lang3.StringUtils.isNotEmpty(result.getCash_refund_fee())) {
  770. orderRefund.setCashRefundFee(Integer.parseInt(BigDecimal.valueOf(Long.valueOf(result.getCash_refund_fee())).divide(Constant.ONE_HUNDRED).toString()));
  771. }
  772. orderRefund.setCashRefundFeeType(result.getCash_refund_fee_type());
  773. OrderRefundEntity mallOrderRefund = orderRefundDao.queryObjectByOrderId(order.getId());
  774. if (mallOrderRefund != null) {
  775. orderRefund.setRefundType(mallOrderRefund.getRefundType());
  776. orderRefund.setId(mallOrderRefund.getId());
  777. orderRefundDao.update(orderRefund);
  778. } else {//退款记录不存在
  779. orderRefund.setOrderId(Integer.parseInt(order.getId() + ""));
  780. orderRefund.setUserId(Integer.parseInt(order.getUserId() + ""));
  781. orderRefund.setCreateTime(new Date());
  782. orderRefundDao.save(orderRefund);//退款记录
  783. }
  784. orderDao.update(order);//修改为退款中
  785. // TODO: 2019/6/13 定时任务查询退款成功后释放库存、优惠券
  786. /*// 判断是否有优惠券
  787. UserCouponEntity couponVo = userCouponDao.queryByOrderId(order.getId());
  788. if (null != couponVo) {
  789. userCouponDao.cancelOrder(couponVo);
  790. }
  791. if (!needUpdateStock) {
  792. return;
  793. }
  794. // 更新库存
  795. updateStock(order, "管理后台微信国际退款订单");*/
  796. queryStorePromRealUpdateIsScan(order);
  797. }
  798. private synchronized void restoreInventory(OrderEntity order, String changeReason) {
  799. Map<String, Object> map = new HashMap();
  800. SysUserEntity user = ShiroUtils.getUserEntity();
  801. map.put("orderId", order.getId());
  802. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryList(map);
  803. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  804. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  805. .queryByGoodsIdAndStoreId(order.getStoreId().longValue(), orderGoodsEntity.getGoodsId().longValue());
  806. if (null == storeRelaEntity || null == storeRelaEntity.getSellVolume()) {
  807. storeRelaEntity.setSellVolume(0);
  808. }
  809. BigDecimal sellVolume = new BigDecimal(storeRelaEntity.getSellVolume() - orderGoodsEntity.getNumber());//销售量
  810. if (sellVolume.compareTo(Constant.ZERO) < 0) {
  811. sellVolume = Constant.ZERO;
  812. }
  813. // GoodsEntity goodsEntity = goodsDao.queryObject(orderGoodsEntity.getGoodsId());
  814. // if (goodsEntity != null) {
  815. // stockNum = goodsEntity.getGoodsNumber();
  816. // //还原商户商品库存
  817. // resetGoodsStock(stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);
  818. // }
  819. Integer stockNum = 0;
  820. if (null != storeRelaEntity.getStockNum()) {
  821. stockNum = storeRelaEntity.getStockNum();
  822. resetStoreGoodsStock(order.getOrderSn(),stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);//还原门店库存
  823. }
  824. }
  825. }
  826. private synchronized void updateStock(OrderEntity order, String changeReason) {
  827. Map<String, Object> map = new HashMap();
  828. SysUserEntity user = ShiroUtils.getUserEntity();
  829. map.put("orderId", order.getId());
  830. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryList(map);
  831. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  832. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  833. .queryByGoodsIdAndStoreId(order.getStoreId().longValue(), orderGoodsEntity.getGoodsId().longValue());
  834. // .queryByStoreIdProductId(Long.valueOf(order.getStoreId()),Long.valueOf(orderGoodsEntity.getProductId()));
  835. if (null == storeRelaEntity || null == storeRelaEntity.getSellVolume()) {
  836. storeRelaEntity.setSellVolume(0);
  837. }
  838. BigDecimal sellVolume = new BigDecimal(storeRelaEntity.getSellVolume() - orderGoodsEntity.getNumber());//销售量
  839. if (sellVolume.compareTo(Constant.ZERO) < 0) {
  840. sellVolume = Constant.ZERO;
  841. }
  842. Integer stockNum = 0;
  843. GoodsEntity goodsEntity = goodsDao.queryObject(orderGoodsEntity.getGoodsId());
  844. if (goodsEntity != null) {
  845. stockNum = goodsEntity.getGoodsNumber();
  846. //还原商户商品库存
  847. resetGoodsStock(stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);
  848. }
  849. if (null != storeRelaEntity.getStockNum()) {
  850. stockNum = storeRelaEntity.getStockNum();
  851. //普通商品不受共享库存影响,直接取门店配置库存
  852. //该商品所属第三方商户不是共享库存
  853. if (goodsEntity.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_0.getItem())) {
  854. resetStoreGoodsStock(order.getOrderSn(),stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);//还原门店库存
  855. } else {
  856. //该商品所属第三方商户是共享库存,但商品业务类型不是00保税备货
  857. if (!goodsEntity.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())) {
  858. resetStoreGoodsStock(order.getOrderSn(),stockNum, storeRelaEntity, orderGoodsEntity, sellVolume, changeReason, user);//还原门店库存
  859. }
  860. }
  861. }
  862. //该商品所属第三方商户为共享库存,且是保税备货商品,取消订单时改变
  863. updateGoodsByIsShareStock(goodsEntity);
  864. }
  865. }
  866. /**
  867. * 更新商品库存数量变化后是否已共享为0“未共享”
  868. *
  869. * @param goodsInfo
  870. */
  871. private void updateGoodsByIsShareStock(GoodsEntity goodsInfo) {
  872. //该商品所属第三方商户为共享库存,且是保税备货商品
  873. if (goodsInfo.getIsStockShare().equalsIgnoreCase(Dict.isStockShare.item_1.getItem())
  874. && goodsInfo.getGoodsBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem())) {
  875. GoodsEntity goodsVo = new GoodsEntity();
  876. goodsVo.setId(goodsInfo.getId());
  877. //商品库存数量变化后是否已共享,0:否,1:是(下单、退款、取消订单触发)
  878. goodsVo.setIsGoodsShareStock(Dict.isGoodsShareStock.item_0.getItem());
  879. goodsDao.update(goodsVo);
  880. }
  881. }
  882. /**
  883. * 还原商品总库存
  884. *
  885. * @param stockNum
  886. * @param storeRelaEntity
  887. * @param orderGoodsEntity
  888. * @param sellVolume
  889. * @param changeReason
  890. * @param user
  891. */
  892. private void resetGoodsStock(Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  893. OrderGoodsEntity orderGoodsEntity, BigDecimal sellVolume, String changeReason, SysUserEntity user) {
  894. GoodsEntity goodsEntity = goodsDao.queryObject(storeRelaEntity.getGoodsId());
  895. if (goodsEntity != null) {
  896. goodsEntity.setGoodsNumber(stockNum + orderGoodsEntity.getNumber());
  897. // goodsEntity.setSellVolume(Integer.parseInt(goodsSellVolume.toString()));
  898. if ("oms退单成功,恢复库存".equals(changeReason)) {
  899. goodsEntity.setToBeRestored(goodsEntity.getToBeRestored() - orderGoodsEntity.getNumber());
  900. }
  901. goodsDao.update(goodsEntity);
  902. String username = "system";
  903. if (user != null) {
  904. username = user.getUsername();
  905. }
  906. MngChangeEntity mngChangeEntity = new MngChangeEntity();
  907. mngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(goodsEntity.getId())));
  908. mngChangeEntity.setThirdPartyMerchCode(goodsEntity.getThirdPartyMerchCode());
  909. mngChangeEntity.setChangeReason(changeReason);
  910. mngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  911. mngChangeEntity.setChangeNum(orderGoodsEntity.getNumber());//变化数
  912. mngChangeEntity.setOriginalNum(stockNum);//原库存数
  913. mngChangeEntity.setValidNum(stockNum + orderGoodsEntity.getNumber());//可用数
  914. mngChangeEntity.setCreateTime(new Date());
  915. mngChangeEntity.setModTime(new Date());
  916. mngChangeEntity.setCreaterSn(username);
  917. mngChangeEntity.setModerSn(username);
  918. mngChangeEntity.setIsValid(0);
  919. mngChangeEntity.setMerchSn(goodsEntity.getMerchSn());
  920. mngChangeDao.save(mngChangeEntity);
  921. }
  922. }
  923. /**
  924. * 还原商品总库存
  925. * @param stockNum
  926. * @param storeRelaEntity
  927. * @param orderGoodsEntity
  928. * @param user
  929. */
  930. private void resetGoodsStockHkMall(OrderEntity order,Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  931. OrderGoodsEntity orderGoodsEntity,SysUserEntity user) {
  932. GoodsEntity goodsEntity = goodsDao.queryObject(storeRelaEntity.getGoodsId());
  933. if (goodsEntity != null) {
  934. //商品数量 + 待退款数量
  935. goodsEntity.setGoodsNumber(stockNum + orderGoodsEntity.getNumber());
  936. //还原商品总库存
  937. goodsDao.update(goodsEntity);
  938. String username = "system";
  939. if (user != null) {
  940. username = user.getUsername();
  941. }
  942. MngChangeEntity mngChangeEntity = new MngChangeEntity();
  943. mngChangeEntity.setOrderSn(order.getOrderSn());
  944. mngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(goodsEntity.getId())));
  945. mngChangeEntity.setThirdPartyMerchCode(goodsEntity.getThirdPartyMerchCode());
  946. mngChangeEntity.setChangeReason("收银端退款");
  947. mngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  948. mngChangeEntity.setChangeNum(orderGoodsEntity.getNumber());//变化数
  949. mngChangeEntity.setOriginalNum(stockNum);//原库存数
  950. mngChangeEntity.setValidNum(stockNum + orderGoodsEntity.getNumber());//可用数
  951. mngChangeEntity.setCreateTime(new Date());
  952. mngChangeEntity.setModTime(new Date());
  953. mngChangeEntity.setCreaterSn(username);
  954. mngChangeEntity.setModerSn(username);
  955. mngChangeEntity.setIsValid(0);
  956. mngChangeEntity.setMerchSn(goodsEntity.getMerchSn());
  957. mngChangeDao.save(mngChangeEntity);
  958. }
  959. }
  960. /**
  961. * 还原门店商品库存
  962. *
  963. * @param stockNum
  964. * @param storeRelaEntity
  965. * @param orderGoodsEntity
  966. * @param sellVolume
  967. * @param changeReason
  968. * @param user
  969. */
  970. private void resetStoreGoodsStock(String orderSn,Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  971. OrderGoodsEntity orderGoodsEntity, BigDecimal sellVolume, String changeReason, SysUserEntity user) {
  972. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString())); // 减退库存
  973. storeRelaEntity.setStockNum(stockNum + orderGoodsEntity.getNumber());//库存数量
  974. if ("oms退单成功,恢复库存".equals(changeReason)) {
  975. storeRelaEntity.setToBeRestored(storeRelaEntity.getToBeRestored() - orderGoodsEntity.getNumber());
  976. }
  977. productStoreRelaDao.update(storeRelaEntity);
  978. String username = "system";
  979. if (user != null) {
  980. username = user.getUsername();
  981. }
  982. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  983. storeMngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  984. storeMngChangeEntity.setOrderSn(orderSn);
  985. storeMngChangeEntity.setChangeReason(changeReason);
  986. storeMngChangeEntity.setGoodsId(Integer.parseInt(String.valueOf(storeRelaEntity.getGoodsId())));
  987. storeMngChangeEntity.setStoreId(Integer.parseInt(String.valueOf(storeRelaEntity.getStoreId())));
  988. storeMngChangeEntity.setMerchSn(storeRelaEntity.getMerchSn());
  989. storeMngChangeEntity.setStoreChangeNum(orderGoodsEntity.getNumber());
  990. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  991. storeMngChangeEntity.setStoreValidNum(stockNum + orderGoodsEntity.getNumber());
  992. storeMngChangeEntity.setCreateTime(new Date());
  993. storeMngChangeEntity.setModTime(new Date());
  994. storeMngChangeEntity.setCreaterSn(username);
  995. storeMngChangeEntity.setModerSn(username);
  996. storeMngChangeEntity.setIsValid(0);
  997. storeMngChangeDao.save(storeMngChangeEntity);
  998. }
  999. /**
  1000. * 海控还原门店商品库存
  1001. * @param stockNum
  1002. * @param storeRelaEntity
  1003. * @param orderGoodsEntity
  1004. * @param sellVolume
  1005. * @param user
  1006. */
  1007. private void resetStoreGoodsStockMall(OrderEntity order,Integer stockNum, ProductStoreRelaEntity storeRelaEntity,
  1008. OrderGoodsEntity orderGoodsEntity, BigDecimal sellVolume,SysUserEntity user) {
  1009. storeRelaEntity.setSellVolume(Integer.parseInt(sellVolume.toString())); // 减退库存
  1010. //库存数量 + 商品数量
  1011. storeRelaEntity.setStockNum(stockNum + orderGoodsEntity.getNumber());//库存数量
  1012. //待退款数量 - 商品数量
  1013. //storeRelaEntity.setToBeRestored(storeRelaEntity.getToBeRestored() - orderGoodsEntity.getNumber());
  1014. productStoreRelaDao.update(storeRelaEntity);
  1015. String username = "system";
  1016. if (user != null) {
  1017. username = user.getUsername();
  1018. }
  1019. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  1020. storeMngChangeEntity.setOrderSn(order.getOrderSn());
  1021. storeMngChangeEntity.setChangeType(Dict.changeType.item_0.getItem());
  1022. storeMngChangeEntity.setChangeReason("前端退款");
  1023. storeMngChangeEntity.setGoodsId(storeRelaEntity.getGoodsId().intValue());
  1024. storeMngChangeEntity.setStoreId(storeRelaEntity.getStoreId().intValue());
  1025. storeMngChangeEntity.setMerchSn(storeRelaEntity.getMerchSn());
  1026. storeMngChangeEntity.setStoreChangeNum(orderGoodsEntity.getNumber());
  1027. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  1028. storeMngChangeEntity.setStoreValidNum(stockNum + orderGoodsEntity.getNumber());
  1029. storeMngChangeEntity.setCreateTime(new Date());
  1030. storeMngChangeEntity.setModTime(new Date());
  1031. storeMngChangeEntity.setCreaterSn(username);
  1032. storeMngChangeEntity.setModerSn(username);
  1033. storeMngChangeEntity.setIsValid(0);
  1034. storeMngChangeDao.save(storeMngChangeEntity);
  1035. }
  1036. /**
  1037. * 查询该退款订单编号是否是推广渠道订单,是则修改渠道定时扫描状态
  1038. *
  1039. * @param orderInfo
  1040. */
  1041. private void queryStorePromRealUpdateIsScan(OrderEntity orderInfo) {
  1042. Map map = new HashMap();
  1043. map.put("orderId", orderInfo.getId());
  1044. List<MkStorePromOrderRealEntity> list = mkStorePromOrderRealDao.queryPromRealListByMap(map);
  1045. if (list.size() > 0) {
  1046. for (MkStorePromOrderRealEntity mkStorePromOrderRealEntity : list) {
  1047. mkStorePromOrderRealEntity.setIsPromStatScan(Dict.isDistSellScan.item_0.getItem());
  1048. mkStorePromOrderRealDao.update(mkStorePromOrderRealEntity);
  1049. }
  1050. }
  1051. }
  1052. /**
  1053. * 处理用户退款申请
  1054. *
  1055. * @param orderInfo
  1056. */
  1057. @Transactional
  1058. public void applyRefundDeal(OrderEntity orderInfo, OrderRefundEntity refundEntity) {
  1059. refundEntity.setApprovalTime(new Date());
  1060. // refundEntity.setApprover(ShiroUtils.getUserId());
  1061. // 退积分
  1062. try {
  1063. Integer integral = 1;
  1064. if (orderInfo.getActualPrice().intValue() > 0) {
  1065. integral = orderInfo.getActualPrice().intValue();
  1066. }
  1067. if (refundEntity.getRefundStatus() == 2) {
  1068. orderInfo.setOrderStatus(401);
  1069. // UserEntity entity = userDao.queryObject(orderInfo.getUserId());
  1070. } else {
  1071. orderInfo.setOrderStatus(201);
  1072. }
  1073. } catch (Exception e) {
  1074. e.printStackTrace();
  1075. }
  1076. orderRefundDao.update(refundEntity);
  1077. orderDao.update(orderInfo);
  1078. }
  1079. @Override
  1080. public OrderRefundEntity queryRefundObject(Long refundId) {
  1081. return orderRefundDao.queryObject(refundId);
  1082. }
  1083. @Override
  1084. public List<OrderRefundEntity> queryRefundList(Map<String, Object> map) {
  1085. return orderRefundDao.queryList(map);
  1086. }
  1087. @Override
  1088. public int queryRefundTotal(Map<String, Object> map) {
  1089. return orderRefundDao.queryTotal(map);
  1090. }
  1091. @Override
  1092. public int getUserOrderInfo(Map<String, Object> map) {
  1093. int result = 0;
  1094. String type = (String) map.get("type");
  1095. if ("yfkOrderUserSum".equals(type)) {
  1096. result = orderDao.getYfkOrderUserSum(map);
  1097. } else if ("oderUserSum".equals(type)) {
  1098. result = orderDao.getOderUserSum(map);
  1099. } else if ("todayUserOrder".equals(type)) {
  1100. result = orderDao.getTodayUserOrder(map);
  1101. } else if ("todayUserSales".equals(type)) {
  1102. result = orderDao.getTodayUserSales(map);
  1103. } else if ("incomeSum".equals(type)) {
  1104. result = orderDao.getIncomeSum(map);
  1105. } else if ("payedOrderCount".equals(type)) {
  1106. result = orderDao.getPayedOrderCount(map);
  1107. }
  1108. return result;
  1109. }
  1110. @Override
  1111. public Map getLogistics(Long id) {
  1112. OrderEntity orderEntity = queryObject(id);
  1113. if (orderEntity == null) {
  1114. throw new RRException("此订单不存在!");
  1115. }
  1116. if (orderEntity.getShippingStatus() == 0) {
  1117. if (orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_00.getItem()) ||
  1118. orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_02.getItem())) {
  1119. throw new RRException("此订单还未发货!");
  1120. } else {
  1121. if (StringUtils.isNullOrEmpty(orderEntity.getShippingNo())) {
  1122. throw new RRException("此订单还未发货!");
  1123. }
  1124. }
  1125. }
  1126. Map logisticsInfo = Maps.newHashMap();
  1127. List<WuliuEntity> wuliuEntityList = new ArrayList<>();
  1128. OrderProcessRecordEntity orderProcessRecordEntity =
  1129. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  1130. if (orderProcessRecordEntity != null) {
  1131. if (orderEntity.getOrderBizType().equals(Dict.orderBizType.item_10.getItem()) ||
  1132. orderEntity.getOrderBizType().equals(Dict.orderBizType.item_02.getItem())) {
  1133. WuliuEntity wuliuEntity = new WuliuEntity();
  1134. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  1135. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  1136. wuliuEntity.setAcceptStation(PrintTicketPropertiesBuilder.instance().getAddress() + "送达" +
  1137. storeDao.queryObject(orderEntity.getStoreId()).getStoreAddress() +
  1138. ";交易完成,用户已提走");
  1139. wuliuEntityList.add(wuliuEntity);
  1140. }
  1141. if (StringUtils.isNotEmpty(orderEntity.getShippingCode()) &&
  1142. StringUtils.isNotEmpty(orderEntity.getShippingNo()) &&
  1143. orderProcessRecordEntity.getShipmentStartTime() != null) {
  1144. if (orderEntity.getShippingCode().equalsIgnoreCase("SF")) {
  1145. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  1146. if (storeEntity == null) {
  1147. throw new RRException("查询顺丰订单异常,订单的门店信息不存在");
  1148. }
  1149. ThirdMerchExpressEntity thirdMerchExpressEntity = thirdMerchExpressDao.getThirdMerchExpressByThirdCode(storeEntity.getThirdPartyMerchCode());
  1150. if (thirdMerchExpressEntity == null) {
  1151. throw new RRException("查询顺丰订单异常,缺失商户快递账号信息");
  1152. }
  1153. SfRouteServiceResponseEntity entity = SFUtil.routeService(orderEntity.getShippingNo(), thirdMerchExpressEntity.getExpressAccount(),
  1154. thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());
  1155. // SfRouteServiceResponseEntity entity = SFUtil.routeService("254355029325", thirdMerchExpressEntity.getExpressAccount(),
  1156. // thirdMerchExpressEntity.getExpressPwd(), SFPropertiesBuilder.instance().getUrl());//444072971585
  1157. if (entity.getHead().equalsIgnoreCase("OK")) {
  1158. if (entity.getBody() == null) {
  1159. WuliuEntity wuliuEntity = new WuliuEntity();
  1160. wuliuEntity.setAcceptStation("暂无物流轨迹");
  1161. wuliuEntityList.add(wuliuEntity);
  1162. } else {
  1163. if (entity.getBody().getRouteResponse() == null) {
  1164. WuliuEntity wuliuEntity = new WuliuEntity();
  1165. wuliuEntity.setAcceptStation("暂无物流轨迹");
  1166. wuliuEntityList.add(wuliuEntity);
  1167. } else {
  1168. RouteResponseEntity routeResponseEntity = entity.getBody().getRouteResponse().get(0);
  1169. if (routeResponseEntity != null) {
  1170. List<RouteEntity> entityList = routeResponseEntity.getRouteResponse();
  1171. for (RouteEntity route : entityList) {
  1172. WuliuEntity wuliuEntity = new WuliuEntity();
  1173. wuliuEntity.setAcceptTime(route.getAccept_time());
  1174. wuliuEntity.setAcceptStation(route.getAccept_address() + route.getRemark());
  1175. wuliuEntityList.add(wuliuEntity);
  1176. }
  1177. }
  1178. }
  1179. }
  1180. } else {
  1181. throw new RRException("查询顺丰订单异常," + entity.getErrors());
  1182. }
  1183. } else {
  1184. JSONObject traces =
  1185. KdniaoUtil.getOrderTracesByJson(orderEntity.getShippingCode(), orderEntity.getShippingNo());
  1186. List<Map> mapList = (List<Map>) traces.get("Traces");
  1187. if (mapList != null && mapList.size() > 0) {
  1188. for (Map map : mapList) {
  1189. WuliuEntity wuliuEntity = new WuliuEntity();
  1190. wuliuEntity.setAcceptTime(map.get("AcceptTime").toString());
  1191. wuliuEntity.setAcceptStation(map.get("AcceptStation").toString());
  1192. wuliuEntityList.add(wuliuEntity);
  1193. }
  1194. }
  1195. String state = traces.get("State") + "";
  1196. if (Dict.logisticsStatus.item_0.getItem().equals(state) && traces.getBoolean("Success")) {
  1197. String reason = traces.get("Reason") + "";
  1198. WuliuEntity wuliuEntity = new WuliuEntity();
  1199. wuliuEntity.setAcceptStation(reason);
  1200. wuliuEntityList.add(wuliuEntity);
  1201. }
  1202. }
  1203. }
  1204. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend()) &&
  1205. orderProcessRecordEntity.getShipmentStartTime() != null) {
  1206. WuliuEntity wuliuEntity = new WuliuEntity();
  1207. wuliuEntity.setAcceptStation("订单已出库");
  1208. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  1209. .format(orderProcessRecordEntity.getShipmentStartTime()));
  1210. wuliuEntityList.add(wuliuEntity);
  1211. }
  1212. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsCustomsSend())) {
  1213. WuliuEntity wuliuEntity = new WuliuEntity();
  1214. wuliuEntity.setAcceptStation("订单清关完成,等待仓库发货");
  1215. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  1216. .format(orderProcessRecordEntity.getCustomsSuccTime()));
  1217. wuliuEntityList.add(wuliuEntity);
  1218. }
  1219. if (Dict.isSend.item_0.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsCustomsSend())) {
  1220. WuliuEntity wuliuEntity = new WuliuEntity();
  1221. wuliuEntity.setAcceptStation("订单清关失败");
  1222. wuliuEntityList.add(wuliuEntity);
  1223. }
  1224. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsEleOrderSend()) &&
  1225. orderProcessRecordEntity.getWaybillSuccTime() != null) {
  1226. WuliuEntity wuliuEntity = new WuliuEntity();
  1227. wuliuEntity.setAcceptStation("海关三单发送成功");
  1228. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  1229. .format(orderProcessRecordEntity.getWaybillSuccTime()));
  1230. wuliuEntityList.add(wuliuEntity);
  1231. }
  1232. if (Dict.isSend.item_1.getItem().equals(orderProcessRecordEntity.getIsPaymentSend())) {
  1233. WuliuEntity wuliuEntity = new WuliuEntity();
  1234. wuliuEntity.setAcceptStation("订单支付成功");
  1235. wuliuEntity.setAcceptTime(
  1236. new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(orderProcessRecordEntity.getPaySuccTime()));
  1237. wuliuEntityList.add(wuliuEntity);
  1238. }
  1239. if (Dict.isSend.item_1.getItem().equalsIgnoreCase(orderProcessRecordEntity.getIsAddOrderSend())) {
  1240. WuliuEntity wuliuEntity = new WuliuEntity();
  1241. wuliuEntity.setAcceptStation("订单下单成功");
  1242. wuliuEntity.setAcceptTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  1243. .format(orderProcessRecordEntity.getAddOrderSuccTime()));
  1244. wuliuEntityList.add(wuliuEntity);
  1245. }
  1246. }
  1247. logisticsInfo.put("tracesList", wuliuEntityList);
  1248. logisticsInfo.put("logisticCode", orderEntity.getShippingNo());
  1249. logisticsInfo.put("shipperCode", orderEntity.getShippingCode());
  1250. return logisticsInfo;
  1251. }
  1252. @Override
  1253. public OrderEntity queryInfos(Long id) {
  1254. OrderEntity orderEntity = orderDao.queryObject(id);
  1255. Map<String, Object> map = new HashMap<String, Object>();
  1256. map.put("orderId", id);
  1257. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  1258. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  1259. return orderEntity;
  1260. }
  1261. /**
  1262. * 普货商品生成线下订单
  1263. *
  1264. * @param offlineCartList
  1265. * @param user
  1266. * @return
  1267. */
  1268. @Transactional
  1269. @Override
  1270. public Map orderSubmit(List<OfflineCartEntity> offlineCartList, SysUserEntity user) {
  1271. Map resultObj = Maps.newHashMap();
  1272. try {
  1273. if (user == null) {
  1274. resultObj.put("errno", 400);
  1275. resultObj.put("errmsg", "用户登录超时,请重新登录");
  1276. return resultObj;
  1277. }
  1278. if (!user.getRoleType().equalsIgnoreCase("2")) {
  1279. resultObj.put("errno", 400);
  1280. resultObj.put("errmsg", "该操作只允许店员账户操作");
  1281. return resultObj;
  1282. }
  1283. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  1284. resultObj.put("errno", 400);
  1285. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  1286. return resultObj;
  1287. }
  1288. Long userId = user.getUserId();
  1289. Integer storeId = user.getStoreId();
  1290. //获取要购买的商品
  1291. Map param = Maps.newHashMap();
  1292. param.put("userId", userId);
  1293. param.put("storeId", storeId);
  1294. if (null == offlineCartList && offlineCartList.size() == 0) {
  1295. resultObj.put("errno", 400);
  1296. resultObj.put("errmsg", "购买商品数据为空");
  1297. return resultObj;
  1298. }
  1299. List<OfflineCartEntity> offlineCartEntityList = offlineCartDao.queryOfflineCartByBizType(param);
  1300. if (offlineCartEntityList.size() == 0 && offlineCartList.size() > 0) {
  1301. resultObj.put("errno", 0);
  1302. resultObj.put("errmsg", "该单已下单成功,请重新扫描商品进行购买");
  1303. return resultObj;
  1304. }
  1305. // 检查库存和更新库存
  1306. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  1307. GoodsEntity goodsEntity = goodsDao.queryObject(cartEntity.getGoodsId());
  1308. if (goodsEntity == null) {
  1309. resultObj.put("errno", 400);
  1310. resultObj.put("errmsg", "订单提交失败:商品不存在");
  1311. return resultObj;
  1312. }
  1313. //取得规格的信息,判断规格库存
  1314. ProductStoreRelaEntity productInfo = productStoreRelaDao
  1315. .queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(cartEntity.getGoodsId()));
  1316. synchronized (productInfo) {
  1317. if (null == productInfo || null == productInfo.getStockNum() ||
  1318. productInfo.getStockNum() < cartEntity.getNumber()) {
  1319. resultObj.put("errno", 400);
  1320. resultObj.put("errmsg", "库存不足,仅剩余" + productInfo.getStockNum());
  1321. return resultObj;
  1322. } else {
  1323. productInfo.setStockNum(productInfo.getStockNum() - cartEntity.getNumber());
  1324. productInfo.setStoreId(Long.valueOf(storeId));
  1325. productInfo.addSellVolume();
  1326. productStoreRelaDao.updateStockNumByStoreIdAndSku(productInfo);//修改普通商品库存
  1327. if (goodsEntity != null) {
  1328. goodsEntity.setGoodsNumber(goodsEntity.getGoodsNumber() - cartEntity.getNumber());
  1329. goodsDao.update(goodsEntity);
  1330. }
  1331. }
  1332. }
  1333. }
  1334. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  1335. OrderEntity order = setOrderVo(user, offlineCartEntityList, user.getMerchSn());
  1336. order.setStoreId(storeId);
  1337. order.setMerchOrderSn(merchOrderSn);
  1338. //开启事务,插入订单信息和订单商品
  1339. if (order != null) {
  1340. orderDao.save(order);
  1341. if (null == order.getId()) {
  1342. resultObj.put("errno", 400);
  1343. resultObj.put("errmsg", "订单提交失败");
  1344. return resultObj;
  1345. }
  1346. for (OfflineCartEntity cartEntity : offlineCartEntityList) {
  1347. OrderGoodsEntity orderGoodsEntity = setOrderGoodsVo(order, cartEntity);
  1348. //新增订单详情
  1349. orderGoodsDao.save(orderGoodsEntity);
  1350. }
  1351. //清空预订单商品临时表
  1352. offlineCartDao.deleteByUserId(userId);
  1353. Map orderInfoMap = Maps.newHashMap();
  1354. orderInfoMap.put("orderInfo", order);
  1355. resultObj.put("errno", 0);
  1356. resultObj.put("errmsg", "订单提交成功");
  1357. resultObj.put("data", orderInfoMap);
  1358. }
  1359. } catch (Exception e) {
  1360. e.printStackTrace();
  1361. resultObj.put("errno", 400);
  1362. resultObj.put("errmsg", "订单异常");
  1363. return resultObj;
  1364. }
  1365. return resultObj;
  1366. }
  1367. /**
  1368. * 设置订单数据
  1369. *
  1370. * @param loginUser
  1371. * @return
  1372. */
  1373. public OrderEntity setOrderVo(SysUserEntity loginUser, List<OfflineCartEntity> offlineCartEntityList,
  1374. String merchSn) {
  1375. OrderEntity orderInfo = new OrderEntity();
  1376. BigDecimal freightPrice = new BigDecimal(0.00);
  1377. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  1378. for (OfflineCartEntity offlineCartEntity : offlineCartEntityList) {
  1379. goodsTotalPrice = goodsTotalPrice
  1380. .add(offlineCartEntity.getRetailPrice().multiply(new BigDecimal(offlineCartEntity.getNumber())));
  1381. }
  1382. //订单价格计算:订单的总价+运费
  1383. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  1384. //查询未使用的优惠券
  1385. /*String couponName = "";
  1386. BigDecimal fullCutCouponDec = Constant.ZERO;
  1387. UserCouponVo couponVo = null;*/
  1388. BigDecimal couponPrice = new BigDecimal(0.00);
  1389. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  1390. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  1391. //商户(拼音首字母)+业务类型+编号
  1392. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  1393. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  1394. MerchEntity merchEntity = merchDao.findByMerchSn(merchSn);
  1395. String merchShortName = "";
  1396. if (merchEntity != null) {
  1397. merchShortName = merchEntity.getMerchShortName();
  1398. }
  1399. String orderSn = merchShortName + Dict.orderBizType.item_11.getItem() + CommonUtil.generateOrderNumber();
  1400. orderInfo.setOrderSn(orderSn);
  1401. orderInfo.setMerchSn(merchSn);
  1402. orderInfo.setUserId(Integer.parseInt(loginUser.getUserId() + ""));
  1403. orderInfo.setFreightPrice(freightPrice.intValue());
  1404. orderInfo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  1405. /*orderInfo.setCoupon_id(userCouponId);
  1406. orderInfo.setCoupon_name(couponName);*/
  1407. // orderInfo.setFullCutPrice(fullCutCouponDec);//使用的优惠券
  1408. orderInfo.setCouponPrice(couponPrice);
  1409. orderInfo.setPostscript("");//留言
  1410. orderInfo.setAddTime(new Date());
  1411. orderInfo.setGoodsPrice(goodsTotalPrice);
  1412. orderInfo.setOrderPrice(orderTotalPrice);
  1413. orderInfo.setActualPrice(actualPrice);
  1414. orderInfo.setOrderType("1");
  1415. orderInfo.setOrderStatus(0);// 待付款
  1416. orderInfo.setShippingStatus(0);
  1417. orderInfo.setPayStatus(0);
  1418. orderInfo.setShippingId(0L);
  1419. orderInfo.setShippingFee(Constant.ZERO);
  1420. orderInfo.setIntegral(0);
  1421. orderInfo.setIntegralMoney(Constant.ZERO);
  1422. orderInfo.setCreateTime(new Date());
  1423. orderInfo.setModTime(new Date());
  1424. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());//线下购买
  1425. /*//标记该订单已使用优惠券
  1426. if(couponVo != null){
  1427. couponVo.setUsed_time(new Date());
  1428. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  1429. apiUserCouponMapper.update(couponVo);
  1430. }*/
  1431. return orderInfo;
  1432. }
  1433. /**
  1434. * 设置订单数据
  1435. *
  1436. * @param
  1437. * @return
  1438. */
  1439. public OrderEntity setOrder(Integer userId, List<LinkedHashMap> goodsList,
  1440. String merchSn) {
  1441. OrderEntity orderInfo = new OrderEntity();
  1442. BigDecimal freightPrice = new BigDecimal(0.00);
  1443. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  1444. for (LinkedHashMap goods : goodsList) {
  1445. goodsTotalPrice = goodsTotalPrice
  1446. .add(new BigDecimal(goods.get("retailPrice").toString()).multiply(new BigDecimal(goods.get("sellVolume").toString())));
  1447. }
  1448. //订单价格计算:订单的总价+运费
  1449. BigDecimal orderTotalPrice = goodsTotalPrice.add(freightPrice);
  1450. //查询未使用的优惠券
  1451. /*String couponName = "";
  1452. BigDecimal fullCutCouponDec = Constant.ZERO;
  1453. UserCouponVo couponVo = null;*/
  1454. BigDecimal couponPrice = new BigDecimal(0.00);
  1455. //减去其它支付的金额后,要实际支付的金额 订单的总价+运费-优惠券金额
  1456. BigDecimal actualPrice = orderTotalPrice.subtract(couponPrice);
  1457. //商户(拼音首字母)+业务类型+编号
  1458. // String merchSn = OmsMerchPropertiesBuilder.instance().getMerchSn();
  1459. // String merchShortName = OmsMerchPropertiesBuilder.instance().getMerchShortName();
  1460. MerchEntity merchEntity = merchDao.findByMerchSn(merchSn);
  1461. String merchShortName = "";
  1462. if (merchEntity != null) {
  1463. merchShortName = merchEntity.getMerchShortName();
  1464. }
  1465. String orderSn = merchShortName + Dict.orderBizType.item_10.getItem() + CommonUtil.generateOrderNumber();
  1466. orderInfo.setOrderSn(orderSn);
  1467. orderInfo.setMerchSn(merchSn);
  1468. orderInfo.setUserId(userId);
  1469. orderInfo.setFreightPrice(freightPrice.intValue());
  1470. orderInfo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  1471. /*orderInfo.setCoupon_id(userCouponId);
  1472. orderInfo.setCoupon_name(couponName);*/
  1473. // orderInfo.setFullCutPrice(fullCutCouponDec);//使用的优惠券
  1474. orderInfo.setCouponPrice(couponPrice);
  1475. orderInfo.setPostscript("");//留言
  1476. orderInfo.setAddTime(new Date());
  1477. orderInfo.setGoodsPrice(goodsTotalPrice);
  1478. orderInfo.setOrderPrice(orderTotalPrice);
  1479. orderInfo.setActualPrice(actualPrice);
  1480. orderInfo.setOrderType("1");
  1481. orderInfo.setOrderStatus(0);// 待付款
  1482. orderInfo.setShippingStatus(0);
  1483. orderInfo.setPayStatus(0);
  1484. orderInfo.setShippingId(0L);
  1485. orderInfo.setShippingFee(Constant.ZERO);
  1486. orderInfo.setIntegral(0);
  1487. orderInfo.setIntegralMoney(Constant.ZERO);
  1488. orderInfo.setCreateTime(new Date());
  1489. orderInfo.setModTime(new Date());
  1490. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());//线下购买
  1491. // orderInfo.setIsScan("0");//默认未扫描
  1492. /*//标记该订单已使用优惠券
  1493. if(couponVo != null){
  1494. couponVo.setUsed_time(new Date());
  1495. couponVo.setIsUsed(Dict.isUsed.item_1.getItem());
  1496. apiUserCouponMapper.update(couponVo);
  1497. }*/
  1498. return orderInfo;
  1499. }
  1500. public OrderGoodsEntity setOrderGoodsVo(OrderEntity orderInfo, OfflineCartEntity goodsItem) {
  1501. GoodsEntity goodsVo = goodsDao.queryObject(goodsItem.getGoodsId());
  1502. OrderGoodsEntity orderGoodsVo = new OrderGoodsEntity();
  1503. orderGoodsVo.setOrderId(Integer.parseInt(orderInfo.getId() + ""));
  1504. orderGoodsVo.setGoodsId(goodsItem.getGoodsId());
  1505. orderGoodsVo.setGoodsSn(goodsItem.getGoodsSn());
  1506. orderGoodsVo.setProductId(goodsItem.getProductId());
  1507. orderGoodsVo.setGoodsName(goodsItem.getGoodsName());
  1508. orderGoodsVo.setListPicUrl(goodsItem.getListPicUrl());
  1509. orderGoodsVo.setMarketPrice(goodsItem.getMarketPrice());
  1510. orderGoodsVo.setRetailPrice(goodsItem.getRetailPrice());
  1511. orderGoodsVo.setNumber(goodsItem.getNumber());
  1512. orderGoodsVo.setOrderBizType(Dict.orderBizType.item_11.getItem());
  1513. orderGoodsVo.setCreateTime(new Date());
  1514. orderGoodsVo.setModTime(new Date());
  1515. orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  1516. orderGoodsVo.setSku(goodsVo.getSku());
  1517. return orderGoodsVo;
  1518. }
  1519. // public OrderGoodsEntity setOrderGoods(OrderEntity orderInfo, LinkedHashMap goods) {
  1520. // GoodsEntity goodsVo = goodsDao.queryObject(goods.get("goodsId"));
  1521. // ProductEntity productEntity = productDao.queryObjectByGoodsIdAndStoreId(goodsVo.getId() + "", null);
  1522. // OrderGoodsEntity orderGoodsVo = new OrderGoodsEntity();
  1523. // orderGoodsVo.setOrderId(Integer.parseInt(orderInfo.getId() + ""));
  1524. // orderGoodsVo.setGoodsId(goodsVo.getId().intValue());
  1525. // orderGoodsVo.setGoodsSn(goodsVo.getGoodsSn());
  1526. // orderGoodsVo.setProductId(productEntity.getId().intValue());
  1527. // orderGoodsVo.setGoodsName(goodsVo.getName());
  1528. // orderGoodsVo.setListPicUrl(goodsVo.getListPicUrl());
  1529. //
  1530. //
  1531. // orderGoodsVo.setMarketPrice((BigDecimal) goods.get("storeMarketPrice"));
  1532. // orderGoodsVo.setRetailPrice((BigDecimal) goods.get("storeRetailPrice"));
  1533. // orderGoodsVo.setNumber((Integer) goods.get("sellVolume"));
  1534. // orderGoodsVo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  1535. // orderGoodsVo.setCreateTime(new Date());
  1536. // orderGoodsVo.setModTime(new Date());
  1537. // orderGoodsVo.setGoodsRate(goodsVo.getGoodsRate());
  1538. // orderGoodsVo.setSku(goodsVo.getSku());
  1539. //
  1540. //
  1541. // BigDecimal number = new BigDecimal(Long.valueOf(goodsItem.getNumber()));
  1542. // BigDecimal goodsTotal = goodsItem.getRetail_price().multiply(number);//单商品总价
  1543. // BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(),2, BigDecimal.ROUND_HALF_UP);//当前商品总价/订单总价(不含运费、不含优惠券)
  1544. // BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  1545. // BigDecimal settlePrice = Constant.ZERO;
  1546. // if(orderInfo.getFreight_price() != 0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  1547. // //运费-优惠券
  1548. // BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  1549. // //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 当前商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  1550. // settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  1551. // }else{
  1552. // if(orderInfo.getFreight_price()!=0){
  1553. // //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  1554. // BigDecimal freightRate = rate.multiply(freightPrice);
  1555. // //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  1556. // settlePrice = goodsTotal.add(freightRate);
  1557. // }
  1558. // if(!"0".equalsIgnoreCase(orderInfo.getCoupon_price()+"")){
  1559. // //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  1560. // BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  1561. // //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  1562. // settlePrice = goodsTotal.subtract(couponRate);
  1563. // }
  1564. // }
  1565. // if(settlePrice.compareTo(BigDecimal.valueOf(0)) == 0){
  1566. // orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  1567. // }else{
  1568. // orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  1569. // }
  1570. //
  1571. // return orderGoodsVo;
  1572. // }
  1573. @Override
  1574. public OrderEntity queryObjectBySysUser(Long id) {
  1575. OrderEntity orderEntity = orderDao.queryObjectBySysUser(id);
  1576. Map<String, Object> map = new HashMap<String, Object>();
  1577. map.put("orderId", id);
  1578. List<OrderGoodsEntity> orderGoodsEntityList = orderGoodsDao.queryList(map);
  1579. orderEntity.setOrderGoodsEntityList(orderGoodsEntityList);
  1580. return orderEntity;
  1581. }
  1582. @Override
  1583. public int confirmPay(Long id, String payFlag, String orderSnWx) {
  1584. SysUserEntity user = ShiroUtils.getUserEntity();
  1585. if (user == null) {
  1586. throw new RRException("用户登录超时,请重新登录");
  1587. }
  1588. if (!user.getRoleType().equalsIgnoreCase("2")) {
  1589. throw new RRException("该操作只允许店员账户操作");
  1590. }
  1591. OrderEntity orderEntity = queryObject(id);
  1592. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  1593. throw new RRException("此订单已付款!");
  1594. }
  1595. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  1596. throw new RRException("此订单已完成!");
  1597. }
  1598. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  1599. throw new RRException("此订单已取消!");
  1600. }
  1601. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  1602. throw new RRException("此订单已删除!");
  1603. }
  1604. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_201.getItem()));
  1605. orderEntity.setPayStatus(Integer.parseInt(Dict.payStatus.item_2.getItem()));
  1606. orderEntity.setPayFlag(payFlag);
  1607. orderEntity.setPayTime(new Date());
  1608. if (Dict.payFlag.item_alipay.getItem().equalsIgnoreCase(payFlag)) {
  1609. orderEntity.setAliTradeNo(orderSnWx);
  1610. } else {
  1611. if (orderSnWx != null) {
  1612. orderEntity.setOrderSnWx(orderSnWx);
  1613. }
  1614. }
  1615. // Date now = new Date();
  1616. // Integer storeId = orderEntity.getStoreId();
  1617. // Map queryParams = new HashMap();
  1618. // queryParams.put("orderId", orderEntity.getId());
  1619. // List<OrderGoodsEntity> orderGoodsList = orderGoodsDao.queryList(queryParams);
  1620. // // 遍历订单下的详情商品,修改商品的最后销售时间
  1621. // if (orderGoodsList!=null && orderGoodsList.size()>0){
  1622. // orderGoodsList.forEach(orderGoods ->{
  1623. // Integer goodsId = orderGoods.getGoodsId();
  1624. // GoodsEntity goodsEntity = goodsDao.queryObject(goodsId);
  1625. // if (Objects.nonNull(goodsEntity)){
  1626. // goodsEntity.setLastSaleTime(now);
  1627. // goodsDao.update(goodsEntity);
  1628. // }
  1629. // if (Objects.nonNull(storeId)){
  1630. // ProductStoreRelaEntity productStoreRelaEntity = productStoreRelaDao.queryByGoodsIdAndStoreId(Long.valueOf(storeId), Long.valueOf(goodsId));
  1631. // if (Objects.nonNull(productStoreRelaEntity)){
  1632. // productStoreRelaEntity.setLastSaleTime(now);
  1633. // productStoreRelaDao.update(productStoreRelaEntity);
  1634. // }
  1635. // }
  1636. // });
  1637. // }
  1638. orderDao.update(orderEntity);
  1639. return 0;
  1640. }
  1641. @Override
  1642. public List<OrderEntity> queryExportList(Map<String, Object> map) {
  1643. List<OrderEntity> list = orderDao.queryExportList(map);
  1644. for (OrderEntity order : list) {
  1645. OrderProcessRecordEntity orderProcessRecord = orderProcessRecordDao.queryObjectByOrderSn(order.getOrderSn());
  1646. order.setOrderProcessRecord(orderProcessRecord);
  1647. // 查询活动价
  1648. BigDecimal topicPrice = orderDao.queryTopicPriceByOrderSnAndSku(order.getOrderSn(), order.getSku());
  1649. order.setTopicPrice(topicPrice);
  1650. }
  1651. return list;
  1652. }
  1653. @Override
  1654. public List<OrderEntity> queryOffilineOrderList(Map<String, Object> map) {
  1655. return orderDao.queryOffilineOrderList(map);
  1656. }
  1657. /**
  1658. * 还原查验单库存方法
  1659. *
  1660. * @param orderSns 查验单订单编号
  1661. * @return 是否还原成功, true: 成功,false: 失败
  1662. */
  1663. @Override
  1664. @Transactional(rollbackFor = Exception.class)
  1665. public Boolean restore(String orderSns) {
  1666. if (org.springframework.util.StringUtils.isEmpty(orderSns)) {
  1667. LOGGER.error("还原查验单库存,订单编号为空!");
  1668. return false;
  1669. }
  1670. List<String> orderIdStrList = new ArrayList<>();
  1671. if (orderSns.contains(",")) {
  1672. String[] split = orderSns.split(",");
  1673. orderIdStrList.addAll(Arrays.asList(split));
  1674. } else {
  1675. orderIdStrList.add(orderSns);
  1676. }
  1677. List<Integer> orderIdList = orderIdStrList.parallelStream().map(Integer::valueOf).collect(Collectors.toList());
  1678. // 查询订单详细信息
  1679. List<OrderGoodsRestoreVo> orderGoodsRestoreVos = orderGoodsService.queryListByOrderIds(orderIdList);
  1680. List<String> orderSnList = orderGoodsRestoreVos.stream().map(OrderGoodsRestoreVo::getOrderSn).collect(Collectors.toList());
  1681. // 查询记录表, 不能还原多次
  1682. List<String> snList = newRetailOrderRestoreStockRecordService.queryListByOrderSnList(orderSnList);
  1683. // 不为空则说明有订单已经被还原过, 返回失败
  1684. if (!CollectionUtils.isEmpty(snList)) {
  1685. LOGGER.error(String.format("订单【%s】已经还原过库存,不可继续还原!", snList));
  1686. throw new RRException(String.format("订单【%s】已经还原过库存,不可继续还原!", snList));
  1687. }
  1688. // 需要更新门店商品库存(mall_product_store_rela)和园区库存(mall_goods)
  1689. // 园区库存, 无门店概念
  1690. List<GoodsEntity> goodsEntities = new ArrayList<>();
  1691. // 门店商品库存
  1692. List<ProductStoreRelaEntity> productStoreRelaEntities = new ArrayList<>();
  1693. // 组装数据
  1694. orderGoodsRestoreVos.forEach(orderGoodsRestoreVo -> {
  1695. goodsEntities.add(wrapGoods(orderGoodsRestoreVo));
  1696. productStoreRelaEntities.add(wrapProductStoreRela(orderGoodsRestoreVo));
  1697. });
  1698. // 还原园区库存
  1699. goodsService.restoreBatch(goodsEntities);
  1700. // 还原门店库存
  1701. productStoreRelaService.restoreBatch(productStoreRelaEntities);
  1702. LOGGER.info("还原【{}】查验订单库存成功!", orderSnList);
  1703. // 查验完成的单已经转成保税备货,800放行后不会通知到kmall,所以需要将状态修改为已发货
  1704. orderDao.updateOrderStatusByOrderSnList(orderSnList);
  1705. LOGGER.info("更新【{}】查验订单状态为已发货成功!", orderSnList);
  1706. // 添加还原记录
  1707. List<NewRetailOrderRestoreStockRecordEntity> stockRecordEntityList = orderGoodsRestoreVos.stream().map(this::wrapRestoreRecord).collect(Collectors.toList());
  1708. newRetailOrderRestoreStockRecordService.saveBatch(stockRecordEntityList);
  1709. LOGGER.info("新增【{}】查验订单还原记录成功!", orderSnList);
  1710. return true;
  1711. }
  1712. /**
  1713. * 组装查验单库存还原记录实体
  1714. * @param orderGoodsRestoreVo 实体
  1715. * @return 查验单库存还原记录
  1716. */
  1717. private NewRetailOrderRestoreStockRecordEntity wrapRestoreRecord(OrderGoodsRestoreVo orderGoodsRestoreVo){
  1718. NewRetailOrderRestoreStockRecordEntity entity = new NewRetailOrderRestoreStockRecordEntity();
  1719. SysUserEntity user = ShiroUtils.getUserEntity();
  1720. entity.setOrderId(orderGoodsRestoreVo.getOrderId());
  1721. entity.setOrderSn(orderGoodsRestoreVo.getOrderSn());
  1722. entity.setRestoreNum(orderGoodsRestoreVo.getNumber());
  1723. entity.setStoreId(orderGoodsRestoreVo.getStoreId());
  1724. entity.setShopName(orderGoodsRestoreVo.getShopName());
  1725. entity.setSku(orderGoodsRestoreVo.getSku());
  1726. entity.setCreateSn(String.valueOf(user.getUserId()));
  1727. entity.setCreateTime(new Date());
  1728. entity.setUpdateSn(String.valueOf(user.getUserId()));
  1729. entity.setUpdateTime(new Date());
  1730. entity.setStatus(Dict.stockRestoreEnum.SUCCESS.getCode());
  1731. return entity;
  1732. }
  1733. /**
  1734. * 组装成ProductStoreRelaEntity, 还原操作
  1735. * @param orderGoodsRestoreVo 订单详细数据
  1736. * @return 门店库存
  1737. */
  1738. private ProductStoreRelaEntity wrapProductStoreRela(OrderGoodsRestoreVo orderGoodsRestoreVo) {
  1739. ProductStoreRelaEntity productStoreRelaEntity = new ProductStoreRelaEntity();
  1740. productStoreRelaEntity.setStoreId(orderGoodsRestoreVo.getStoreId().longValue());
  1741. productStoreRelaEntity.setSku(orderGoodsRestoreVo.getSku());
  1742. productStoreRelaEntity.setStockNum(orderGoodsRestoreVo.getNumber());
  1743. return productStoreRelaEntity;
  1744. }
  1745. /**
  1746. * 组装成GoodsEntity, 还原操作
  1747. * @param orderGoodsRestoreVo 订单详细数据
  1748. * @return 库存
  1749. */
  1750. private GoodsEntity wrapGoods(OrderGoodsRestoreVo orderGoodsRestoreVo) {
  1751. GoodsEntity goodsEntity = new GoodsEntity();
  1752. goodsEntity.setGoodsNumber(orderGoodsRestoreVo.getNumber());
  1753. goodsEntity.setSku(orderGoodsRestoreVo.getSku());
  1754. return goodsEntity;
  1755. }
  1756. @Override
  1757. public List<OrderEntity> queryPickUpCodeList(Map<String, Object> map) {
  1758. return orderDao.queryPickUpCodeList(map);
  1759. }
  1760. @Override
  1761. public int uploadExcel(List<OrderExpressDto> orderExpressDtoList) {
  1762. SysUserEntity user = ShiroUtils.getUserEntity();
  1763. boolean isFail = false;
  1764. List<String> failShippingNameList = new ArrayList<>();
  1765. List<String> failOrderSnList = new ArrayList<>();
  1766. List<String> failShippingCodeList = new ArrayList<>();
  1767. List<String> failCodeSnList = new ArrayList<>();
  1768. List<String> failNameSnList = new ArrayList<>();
  1769. List<String> failStatusOrderSnList = new ArrayList<>();
  1770. if (orderExpressDtoList != null && orderExpressDtoList.size() > 0) {
  1771. for (int i = 0; i < orderExpressDtoList.size(); i++) {
  1772. OrderExpressDto orderExpressDto = orderExpressDtoList.get(i);
  1773. OrderEntity orderEntity = new OrderEntity();
  1774. Map<String, Object> valideDate = MapBeanUtil.fromObject(orderExpressDto);
  1775. ImmutableBiMap.Builder builder = new ImmutableBiMap.Builder();
  1776. builder.put("orderSn", "订单编号");
  1777. builder.put("shippingNo", "快递单号");
  1778. builder.put("shippingName", "快递公司");
  1779. builder.put("shippingCode", "快递简写");
  1780. R r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  1781. if (Integer.valueOf(r.get("code").toString()) != 0) {
  1782. throw new RRException(r.get("msg").toString());
  1783. } else {
  1784. r = ValidatorUtil.isEmpty(builder.build(), valideDate);
  1785. if (Integer.valueOf(r.get("code").toString()) != 0) {
  1786. throw new RRException(r.get("msg").toString());
  1787. }
  1788. }
  1789. OrderEntity order = orderDao.queryObjectByOrderSn(orderExpressDto.getOrderSn());
  1790. if (order == null) {
  1791. isFail = true;
  1792. failOrderSnList.add(orderExpressDto.getOrderSn());
  1793. } else {
  1794. if (!(order.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())
  1795. && order.getPayStatus() == Integer.parseInt(Dict.payStatus.item_2.getItem()))) {
  1796. isFail = true;
  1797. failStatusOrderSnList.add(orderExpressDto.getOrderSn());
  1798. }
  1799. }
  1800. ShippingEntity shippingEntity = shippingDao.queryObjectByCode(orderExpressDto.getShippingCode());
  1801. if (shippingEntity == null) {
  1802. isFail = true;
  1803. failShippingCodeList.add(orderExpressDto.getShippingCode());
  1804. failCodeSnList.add(orderExpressDto.getOrderSn());
  1805. } else {
  1806. if (!orderExpressDto.getShippingName().equalsIgnoreCase(shippingEntity.getName())) {
  1807. isFail = true;
  1808. failShippingNameList.add(orderExpressDto.getShippingName());
  1809. failNameSnList.add(orderExpressDto.getOrderSn());
  1810. }
  1811. }
  1812. if (!isFail) {//false则有错误的数据
  1813. if (order != null) {// 修改商品
  1814. // orderEntity.setOrderSn(orderExpressDto.getOrderSn());
  1815. orderEntity.setShippingNo(orderExpressDto.getShippingNo());
  1816. orderEntity.setShippingCode(orderExpressDto.getShippingCode());
  1817. orderEntity.setShippingName(orderExpressDto.getShippingName());
  1818. orderEntity.setShippingStatus(Integer.parseInt(Dict.shippingStatus.item_1.getItem()));
  1819. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_300.getItem()));
  1820. orderEntity.setModerSn(user.getUsername());
  1821. orderEntity.setCreateTime(new Date());
  1822. orderEntity.setModTime(new Date());
  1823. orderEntity.setId(order.getId());
  1824. orderDao.update(orderEntity);
  1825. }
  1826. }
  1827. }
  1828. if (failOrderSnList != null && failOrderSnList.size() > 0) {
  1829. throw new RRException("导入数据异常,订单编号不存在,不存在的订单编号【" + failOrderSnList + "】,请删除掉再继续操作");
  1830. }
  1831. if (failStatusOrderSnList != null && failStatusOrderSnList.size() > 0) {
  1832. throw new RRException("导入数据异常,修改订单快递功能只支持已付款未发货的订单,以下订单编号无效【" + failStatusOrderSnList + "】,请删除掉再继续操作");
  1833. }
  1834. if (failShippingCodeList != null && failShippingCodeList.size() > 0) {
  1835. throw new RRException("导入数据异常,快递简写不在可支持的范围中,简写错误的订单编号【" + failCodeSnList + "】,错误的快递简写【" + failShippingCodeList + "】," +
  1836. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1837. }
  1838. if (failShippingNameList != null && failShippingNameList.size() > 0) {
  1839. throw new RRException("导入数据异常,快递简写对应的快递公司不一致,快递公司错误的订单编号【" + failNameSnList + "】,请修改Excel数据中订单编号对应的快递公司错误信息," +
  1840. "正确数据可下载订单页面的快递公司简写Excel中查看");
  1841. }
  1842. // if(failFreightGoodsSnList != null && failFreightGoodsSnList.size() > 0){
  1843. // exportExceptionDataEntity.setExportExceptionData("运费信息请在商城配置》运费模板中维护,运费与商户信息对应,请检查该商品商户信息下的运费是否维护,不存在的商品编码【"+failFreightGoodsSnList+"】,运费【"+failFreightList+"】");
  1844. // exportExceptionDataDao.save(exportExceptionDataEntity);
  1845. // throw new RRException("导入数据异常,异常信息请在商品管理》》商品导入异常数据中查看检查");
  1846. // }
  1847. } else {
  1848. throw new RRException("导入数据为空,或者检查商品编码数据是否为空");
  1849. }
  1850. return 1;
  1851. }
  1852. @Override
  1853. public List<OrderEntity> promOrderList(Map<String, Object> map) {
  1854. Integer[] statusList = {201};
  1855. List<OrderEntity> list = orderDao.promOrderList(map);
  1856. for (OrderEntity orderEntity : list) {
  1857. Map<String, Object> queryMap = new HashMap<>();
  1858. queryMap.put("goodsId", orderEntity.getGoodsId());
  1859. queryMap.put("statusList", statusList);
  1860. queryMap.put("orderId", orderEntity.getId());
  1861. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1862. if (promActualPrice == null) {
  1863. promActualPrice = 0d;
  1864. }
  1865. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1866. }
  1867. return list;
  1868. }
  1869. @Override
  1870. public int queryPromOrderTotal(Map<String, Object> map) {
  1871. return orderDao.queryPromOrderTotal(map);
  1872. }
  1873. @Override
  1874. public List<OrderEntity> promOrderListExport(Map<String, Object> map) {
  1875. Integer[] statusList = {201};
  1876. List<OrderEntity> list = orderDao.promOrderListExport(map);
  1877. for (OrderEntity orderEntity : list) {
  1878. Map<String, Object> queryMap = new HashMap<>();
  1879. queryMap.put("goodsId", orderEntity.getGoodsId());
  1880. queryMap.put("orderId", orderEntity.getId());
  1881. queryMap.put("statusList", statusList);
  1882. Double promActualPrice = orderDao.getActualPriceByOutProm(queryMap);
  1883. if (promActualPrice == null) {
  1884. promActualPrice = 0d;
  1885. }
  1886. orderEntity.setPromActualPrice(BigDecimal.valueOf(promActualPrice));
  1887. }
  1888. return list;
  1889. }
  1890. @Override
  1891. public List<OrderEntity> storeTopicOrderList(Map<String, Object> map) {
  1892. List<OrderEntity> list = orderDao.storeTopicOrderList(map);
  1893. return list;
  1894. }
  1895. @Override
  1896. public int queryStoreTopicOrderTotal(Map<String, Object> map) {
  1897. return orderDao.queryStoreTopicOrderTotal(map);
  1898. }
  1899. @Override
  1900. public List<WxOrderEntity> wxOrderResendQueryAllList(Map<String, Object> map) {
  1901. // String requestData = JacksonUtil.toJson(map);
  1902. String url = OmsMerchPropertiesBuilder.instance().getWxOrderResendUrl();
  1903. // 同步访问,返回结果字符串
  1904. String response = OkHttpUtils.post(map, url, "SSL");
  1905. ResponseData responseData = JacksonUtils.fromStringJson(response, ResponseData.class);
  1906. if (responseData.getCode().equalsIgnoreCase("0")) {
  1907. List<WxOrderEntity> list = responseData.getData().getRows();
  1908. return list;
  1909. }
  1910. return null;
  1911. }
  1912. @Override
  1913. public List<OrderRecognitionDto> queryOrderListByRecognition(Map<String, Object> map) {
  1914. String value = sysConfigDao.queryByKey("FACE_COLLECT_FREQUENCY_TIME");
  1915. if (value == null) {
  1916. throw new RRException("请联系管理员配系统参数置FACE_COLLECT_FREQUENCY_TIME信息!");
  1917. }
  1918. List<OrderRecognitionDto> list = orderDao.queryOrderListByRecognition(map);
  1919. for (OrderRecognitionDto orderRecognitionDto : list) {
  1920. Integer frequencySecondTime = Integer.parseInt(value);
  1921. String lastFaceTime = orderRecognitionDto.getLastFaceTime();
  1922. if (StringUtils.isNotEmpty(lastFaceTime)) {
  1923. Date lastFaceDate = DateUtils.convertStringToDate(lastFaceTime, DateUtils.DATE_TIME_PATTERN);
  1924. Calendar calendar = Calendar.getInstance();
  1925. calendar.setTime(lastFaceDate);
  1926. calendar.add(Calendar.SECOND, frequencySecondTime);
  1927. Date addSecondTime = calendar.getTime();
  1928. Date nowDate = new Date();
  1929. if (addSecondTime.getTime() > nowDate.getTime()) {
  1930. orderRecognitionDto.setAddSecondTime(DateUtils.format(addSecondTime, DateUtils.DATE_TIME_PATTERN));
  1931. orderRecognitionDto.setIsDateLast("false");
  1932. } else {
  1933. //可调用身份验证范围内
  1934. orderRecognitionDto.setIsDateLast("true");
  1935. }
  1936. } else {//可调用身份验证范围内
  1937. orderRecognitionDto.setIsDateLast("true");
  1938. }
  1939. }
  1940. return list;
  1941. }
  1942. @Override
  1943. public int queryOrderListByRecognitionTotal(Map<String, Object> map) {
  1944. return orderDao.queryOrderListByRecognitionTotal(map);
  1945. }
  1946. /**
  1947. * 海控,提交订单并付款
  1948. * @param param 收银端提交的参数
  1949. * @param user 当前收银端用户
  1950. * @return 结果
  1951. */
  1952. @Override
  1953. @Transactional
  1954. @Deprecated
  1955. public synchronized Map offlineRetailSubmitHaiKong(Map param, SysUserEntity user) {
  1956. /*// 解析订单数据 List
  1957. List<LinkedHashMap> goodsList = (List<LinkedHashMap>) param.get("goodsList");
  1958. // 解析用户信息 LinkedHashMap
  1959. Map userInfo = (Map) param.get("userInfo");
  1960. // 解析支付码 String
  1961. String parCode = (String) param.get("payCode");
  1962. // 解析sessionId(WebSocket) String
  1963. String sessionId = (String) param.get("sessionId");
  1964. // machineCode
  1965. String machineCode = (String) param.get("machineCode");
  1966. //选择的方式 1柜取 0邮寄
  1967. int status = Integer.parseInt(param.get("status").toString());
  1968. // 会员码
  1969. String couponBarCode = param.get("couponBarCode").toString();
  1970. Map<String, String> mapAddr = new HashMap<>();
  1971. if (status == 0) {
  1972. //省
  1973. String cmbProvince = (String) param.get("cmbProvince");
  1974. //市
  1975. String cmbCity = (String) param.get("cmbCity");
  1976. //区
  1977. String cmbArea = (String) param.get("cmbArea");
  1978. //详细地址
  1979. String addrUser = (String) param.get("addrUser");
  1980. mapAddr.put("cmbProvince", cmbProvince);
  1981. mapAddr.put("cmbCity", cmbCity);
  1982. mapAddr.put("cmbArea", cmbArea);
  1983. mapAddr.put("addrUser", addrUser);
  1984. }
  1985. try {
  1986. machineCode = URLDecoder.decode(machineCode, "UTF-8");
  1987. } catch (Exception e) {
  1988. LOGGER.error("机器码:", e);
  1989. }
  1990. Map resultObj = Maps.newHashMap();
  1991. if (user == null) {
  1992. resultObj.put("errno", 400);
  1993. resultObj.put("errmsg", "用户登录超时,请重新登录");
  1994. return resultObj;
  1995. }
  1996. if (!user.getRoleType().equalsIgnoreCase("2")) {
  1997. resultObj.put("errno", 400);
  1998. resultObj.put("errmsg", "该操作只允许店员账户操作");
  1999. return resultObj;
  2000. }
  2001. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  2002. resultObj.put("errno", 400);
  2003. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  2004. return resultObj;
  2005. }
  2006. Long userId = user.getUserId();
  2007. Integer storeId = user.getStoreId();
  2008. // TODO 海控需求,下单流程修改,收银端接收会员码,付款码,用户信息,订单数据
  2009. // 1. 校验库存:保税仓库存 + 展销店库存 - 出区数 >= 购买数
  2010. // 获取保税仓库存
  2011. String queryWarehouseStockResponse = haiKongWarehouseTemplate.queryWarehouseStock(null);
  2012. if (org.springframework.util.StringUtils.isEmpty(queryWarehouseStockResponse)) {
  2013. LOGGER.error("调用库存系统接口出现错误!返回结果为空!");
  2014. throw new ServiceException("调用库存系统接口出现错误!");
  2015. }
  2016. WareQueryStockResponseDTO wareQueryStockResponseDTO = JacksonUtil.fromStringJson(queryWarehouseStockResponse, WareQueryStockResponseDTO.class);
  2017. if (Objects.isNull(wareQueryStockResponseDTO)) {
  2018. throw new ServiceException("解析一步达库存系统响应数据出现错误!");
  2019. }
  2020. List<WareQueryStockResponseDTO.WareQueryStockResponseItemDTO> items = wareQueryStockResponseDTO.getItems();
  2021. // 解析xml,组装成map key=>sku value=>库存
  2022. Map<String, Integer> stockMap = new HashMap<>(16);
  2023. items.forEach(item -> {
  2024. String itemCode = item.getItemCode();
  2025. Integer quantity = item.getQuantity();
  2026. if (stockMap.containsKey(itemCode)) {
  2027. // 避免出现sku相同情况
  2028. stockMap.put(itemCode, stockMap.get(itemCode) + quantity);
  2029. } else {
  2030. stockMap.put(itemCode, quantity);
  2031. }
  2032. });
  2033. // 订单总价格(含税价)
  2034. BigDecimal orderPrice = BigDecimal.ZERO;
  2035. // 商品总价格(不含税)
  2036. BigDecimal goodsPrice = BigDecimal.ZERO;
  2037. // 订单所占用的税
  2038. BigDecimal totalTax = BigDecimal.ZERO;
  2039. List<OrderGoodsEntity> orderGoodsEntities = new ArrayList<>();
  2040. List<GoodsEntity> goodsEntities = new ArrayList<>();
  2041. // TODO 根据商品条码、sku、门店id查询相对应的商品信息,并组装成对象
  2042. List<QueryGoodsVO> queryGoodsVOList = new ArrayList<>();
  2043. goodsList.forEach(map -> {
  2044. QueryGoodsVO queryGoodsVo = new QueryGoodsVO();
  2045. queryGoodsVo.setProdBarcode((String) map.get("prodBarcode"));
  2046. queryGoodsVo.setSku((String) map.get("goodsSn"));
  2047. queryGoodsVo.setStoreId(storeId);
  2048. queryGoodsVo.setSellVolume((Integer) map.get("sellVolume"));
  2049. queryGoodsVo.setRetailPrice(new BigDecimal(String.valueOf(map.get("retailPrice"))));
  2050. queryGoodsVo.setGoodsTaxes(new BigDecimal(String.valueOf(map.get("goodstaxes"))));
  2051. queryGoodsVo.setDisCountedPrice(new BigDecimal(String.valueOf(map.get("disCountedPrice"))));
  2052. queryGoodsVOList.add(queryGoodsVo);
  2053. });
  2054. // 将在循环中查询数据库改为一次性查询
  2055. List<GoodsEntity> goodsEntityList = goodsService.queryGoodsStockByQueryGoodsVoList(queryGoodsVOList);
  2056. // 复制集合数据
  2057. ListUtils listUtils = BeanUtils.instantiate(ListUtils.class);
  2058. listUtils.copyList(goodsEntityList, queryGoodsVOList);
  2059. // 用来存储是否达到满赠条件的map
  2060. Map<String, BigDecimal> categoryConditionMap = new HashMap<>();
  2061. Map<String, BigDecimal> brandConditionMap = new HashMap<>();
  2062. for (QueryGoodsVO goodsEntity : queryGoodsVOList) {
  2063. OrderGoodsEntity orderGoodsEntity = new OrderGoodsEntity();
  2064. // 要购买的数量
  2065. Integer sellVolume = goodsEntity.getSellVolume();
  2066. // 条码
  2067. String prodBarcode = goodsEntity.getProdBarcode();
  2068. // 当前sku
  2069. String sku = goodsEntity.getSku();
  2070. // 订单金额(含税价),订单总金额,用户支付的金额
  2071. BigDecimal retailPrice = goodsEntity.getRetailPrice();
  2072. // 商品预估税率
  2073. BigDecimal goodsTaxes = goodsEntity.getGoodsTaxes();
  2074. // 商品优惠金额
  2075. BigDecimal disCountedPrice = goodsEntity.getDisCountedPrice();
  2076. // 商品金额(不包含税的价格),推送海关电子订单需要
  2077. goodsPrice = goodsPrice.add(retailPrice.subtract(goodsTaxes));
  2078. // 累加订单价格(含税价)
  2079. orderPrice = orderPrice.add(retailPrice);
  2080. // 总税款
  2081. totalTax = totalTax.add(goodsTaxes);
  2082. // 当前sku
  2083. String currentSku = goodsEntity.getSku();
  2084. // 仓库库存
  2085. Integer warehouseStock = stockMap.get(currentSku);
  2086. // 门店库存
  2087. Integer stockNum = goodsEntity.getStockNum();
  2088. // 判断库存。。
  2089. if (!stockMap.containsKey(currentSku)) {
  2090. LOGGER.error("库存系统中不包含此sku:【{}】,校验库存出错!下单失败!", currentSku);
  2091. throw new ServiceException(String.format("不包含此sku:【%s】", currentSku));
  2092. } else {
  2093. // 保税仓库存 + 展销店库存 - 出区数 >= 购买数
  2094. // 当前出区数
  2095. Integer exitRegionNumber = goodsEntity.getExitRegionNumber();
  2096. // 保税仓库存 + 门店库存 - 出区数 >= 购买数
  2097. if (!((warehouseStock + stockNum) - exitRegionNumber >= sellVolume)) {
  2098. // 库存不足
  2099. LOGGER.error("sku【{}】库存不足!商品条码:【{}】,门店库存:【{}】,保税仓库存:【{}】,当前出区数:【{}】", currentSku, prodBarcode, stockNum, warehouseStock, exitRegionNumber);
  2100. throw new ServiceException(String.format("sku【%s】库存不足!商品条码:【%s】,门店库存:【%s】,保税仓库存:【%s】,当前出区数:【%s】", currentSku, prodBarcode, stockNum, warehouseStock, exitRegionNumber));
  2101. }
  2102. }
  2103. // 设置订单详情信息
  2104. GoodsEntity entity = new GoodsEntity(goodsEntity);
  2105. wrapOrderGoods(orderGoodsEntity, entity);
  2106. orderGoodsEntities.add(orderGoodsEntity);
  2107. // 设置条件信息,暂不支持门店满赠活动
  2108. String categoryId = String.valueOf(entity.getCategoryId());
  2109. String brandId = String.valueOf(entity.getBrandId());
  2110. if (!categoryConditionMap.containsKey(categoryId)) {
  2111. categoryConditionMap.put(categoryId, retailPrice);
  2112. } else {
  2113. categoryConditionMap.put(categoryId, categoryConditionMap.get(categoryId).add(retailPrice));
  2114. }
  2115. // if (!brandConditionMap.containsKey(brandId)) {
  2116. // brandConditionMap.put(brandId, retailPrice);
  2117. // } else {
  2118. // brandConditionMap.put(brandId, brandConditionMap.get(brandId).add(retailPrice));
  2119. // }
  2120. }
  2121. // 2. 判断购买的商品是否能参与满减活动
  2122. // 2.1 查询当前门店是否有满赠的活动
  2123. List<MkActivitiesEntity> activitiesEntities = mkActivitiesService.queryByNowByMz(String.valueOf(storeId), DateUtils.format(new Date(), "yyyy-MM-dd"));
  2124. if (CollectionUtils.isEmpty(activitiesEntities)) {
  2125. LOGGER.error("----- 该门店【{}】暂无满赠活动! -----", storeId);
  2126. } else {
  2127. // 当前门店的活动编号
  2128. List<Long> activitiesSnList = activitiesEntities.stream().map(MkActivitiesEntity::getMkaId).collect(Collectors.toList());
  2129. // 活动
  2130. List<MkActivitiesFullGiftEntity> mkActivitiesFullGiftEntities = mkActivitiesFullGiftService.queryByMkaIdList(activitiesSnList);
  2131. if (CollectionUtils.isEmpty(mkActivitiesFullGiftEntities)) {
  2132. LOGGER.error("----- 该门店【{}】暂无满赠活动! -----", storeId);
  2133. } else {
  2134. mkActivitiesFullGiftEntities.forEach(mkActivitiesFullGiftEntity -> {
  2135. // 存在品牌满赠活动,暂不支持品牌满赠活动
  2136. // String brandId = String.valueOf(mkActivitiesFullGiftEntity.getBrandId());
  2137. // if (brandConditionMap.containsKey(brandId)) {
  2138. // if (brandConditionMap.get(brandId).compareTo(mkActivitiesFullGiftEntity.getQualifiedAmount()) > 0) {
  2139. // // 该品牌满足满赠条件
  2140. //
  2141. // }
  2142. // }
  2143. // 存在分类满赠活动
  2144. String categoryId = String.valueOf(mkActivitiesFullGiftEntity.getCategoryId());
  2145. if (!CollectionUtils.isEmpty(categoryConditionMap) && categoryConditionMap.containsKey(categoryId)) {
  2146. if (categoryConditionMap.get(categoryId).compareTo(mkActivitiesFullGiftEntity.getQualifiedAmount()) > 0) {
  2147. // 该分类满足满赠条件
  2148. String giftBarcode = mkActivitiesFullGiftEntity.getGiftBarcode();
  2149. String giftGoodsSn = mkActivitiesFullGiftEntity.getGiftGoodsSn();
  2150. String shopSn = mkActivitiesFullGiftEntity.getShopSn();
  2151. GoodsEntity goodsEntity = goodsService.queryGoodsStockByBarcodeAndStoreIdAndSku(giftBarcode, Integer.parseInt(shopSn), giftGoodsSn);
  2152. // 存储赠送数
  2153. goodsEntity.setGoodsNumber(mkActivitiesFullGiftEntity.getGiftNumber());
  2154. OrderGoodsEntity orderGoodsEntity = new OrderGoodsEntity();
  2155. wrapOrderGoods(orderGoodsEntity, goodsEntity);
  2156. orderGoodsEntity.setRetailPrice(BigDecimal.ZERO);
  2157. orderGoodsEntity.setDiscountedPrice(BigDecimal.ZERO);
  2158. orderGoodsEntity.setActualPaymentAmount(BigDecimal.ZERO);
  2159. orderGoodsEntities.add(orderGoodsEntity);
  2160. }
  2161. }
  2162. });
  2163. }
  2164. }
  2165. // 3. 校验是否是会员,调用会员系统查询会员信息,查询接口:
  2166. // 优惠后价格
  2167. BigDecimal afterDiscountPrice;
  2168. if (org.springframework.util.StringUtils.isEmpty(couponBarCode)) {
  2169. // 不是会员,不享受积分抵扣,只能使用门店的优惠券
  2170. afterDiscountPrice = calculatePreferentialPrice(orderPrice, 0, goodsList, storeId, userInfo);
  2171. } else {
  2172. // 会员,计算优惠价
  2173. String queryMemberInfoResponse;
  2174. try {
  2175. // 查询会员信息
  2176. queryMemberInfoResponse = haiKongMemberTemplate.getMemberInfoByCode("{\"code\":\"" + couponBarCode + "\"}");
  2177. Response<MemberInfoDTO> response = JacksonUtil.fromListJson(queryMemberInfoResponse, new TypeReference<Response<MemberInfoDTO>>() {
  2178. });
  2179. if (Objects.nonNull(response) && response.getSuccess()) {
  2180. MemberInfoDTO memberInfoDTO = response.getData();
  2181. Integer score = memberInfoDTO.getScore();
  2182. if (Objects.nonNull(score) && score > 0) {
  2183. // 有积分
  2184. afterDiscountPrice = calculatePreferentialPrice(orderPrice, score, goodsList, storeId, userInfo);
  2185. } else {
  2186. // 无积分
  2187. afterDiscountPrice = calculatePreferentialPrice(orderPrice, 0, goodsList, storeId, userInfo);
  2188. }
  2189. } else {
  2190. LOGGER.error("查询会员信息失败!响应结果:{}", queryMemberInfoResponse);
  2191. throw new ServiceException("查询会员信息失败!请重新下单!");
  2192. }
  2193. } catch (Exception e) {
  2194. LOGGER.error("查询会员信息失败!请重新下单!");
  2195. throw new ServiceException("查询会员信息失败!请重新下单!");
  2196. }
  2197. }
  2198. // 4. 调用付款接口
  2199. // 判断是微信的支付码还是支付宝的支付码
  2200. if (parCode.startsWith("28")) {
  2201. // 支付宝支付
  2202. try {
  2203. // AliPay(user, parCode, order, processRecordEntity, orderWXPayRecordCurrent, store);
  2204. } catch (Exception e) {
  2205. e.printStackTrace();
  2206. throw e;
  2207. }
  2208. } else {
  2209. // 微信支付
  2210. try {
  2211. // wxPay(user, parCode, resultObj, order, processRecordEntity, orderWXPayRecordCurrent, store);
  2212. } catch (Exception e) {
  2213. e.printStackTrace();
  2214. throw e;
  2215. }
  2216. }
  2217. // 5. 扣减库存
  2218. // 6. 订单入库
  2219. return resultObj;*/
  2220. return null;
  2221. }
  2222. /**
  2223. * 提交订单并付款
  2224. *
  2225. * @param param 提交的订单数据、包括用户信息、支付码、会话id、机器码(收银台)、取货方式、收货地址信息、会员码
  2226. * @param user
  2227. * @return
  2228. */
  2229. @Override
  2230. @Transactional(rollbackFor = Exception.class)
  2231. public synchronized Map offlineRetailSubmit(Map param, SysUserEntity user) {
  2232. // 解析订单数据 List
  2233. List<LinkedHashMap> goodsList = (List<LinkedHashMap>) param.get("goodsList");
  2234. // 解析用户信息 LinkedHashMap
  2235. Map userInfo = (Map) param.get("userInfo");
  2236. // 解析支付码 String
  2237. String parCode = (String) param.get("payCode");
  2238. // 解析sessionId(WebSocket) String
  2239. String sessionId = (String) param.get("sessionId");
  2240. // machineCode
  2241. String machineCode = (String) param.get("machineCode");
  2242. //选择的方式 1柜取 0邮寄
  2243. int status = Integer.parseInt(param.get("status").toString());
  2244. Map<String, String> mapAddr = new HashMap<>();
  2245. if (status == 0) {
  2246. //省
  2247. String cmbProvince = (String) param.get("cmbProvince");
  2248. //市
  2249. String cmbCity = (String) param.get("cmbCity");
  2250. //区
  2251. String cmbArea = (String) param.get("cmbArea");
  2252. //详细地址
  2253. String addrUser = (String) param.get("addrUser");
  2254. mapAddr.put("cmbProvince", cmbProvince);
  2255. mapAddr.put("cmbCity", cmbCity);
  2256. mapAddr.put("cmbArea", cmbArea);
  2257. mapAddr.put("addrUser", addrUser);
  2258. }
  2259. try {
  2260. machineCode = URLDecoder.decode(machineCode, "UTF-8");
  2261. } catch (Exception e) {
  2262. // e.printStackTrace();
  2263. LOGGER.error("decode machine code failed! error message : ", e);
  2264. }
  2265. Map resultObj = Maps.newHashMap();
  2266. // 海控需求,下单流程修改,收银端接收会员码,付款码,用户信息,订单数据
  2267. // 1. 校验库存:保税仓库存 + 展销店库存 - 出区数 >= 购买数
  2268. // TODO 获取保税仓库存,测试时注释
  2269. // String queryWarehouseStockResponse = haiKongWarehouseTemplate.queryWarehouseStock(null);
  2270. // if (org.springframework.util.StringUtils.isEmpty(queryWarehouseStockResponse)) {
  2271. // LOGGER.error("调用库存系统接口出现错误!返回结果为空!");
  2272. // throw new ServiceException("调用库存系统接口出现错误!");
  2273. // }
  2274. // WareQueryStockResponseDTO wareQueryStockResponseDTO = JacksonUtil.fromStringJson(queryWarehouseStockResponse, WareQueryStockResponseDTO.class);
  2275. // if (Objects.isNull(wareQueryStockResponseDTO)) {
  2276. // throw new ServiceException("解析一步达库存系统响应数据出现错误!");
  2277. // }
  2278. // List<WareQueryStockResponseDTO.WareQueryStockResponseItemDTO> items = wareQueryStockResponseDTO.getItems();
  2279. // // 解析xml,组装成map key=>sku value=>库存
  2280. // Map<String, Integer> stockMap = new HashMap<>(16);
  2281. // items.forEach(item -> {
  2282. // String itemCode = item.getItemCode();
  2283. // Integer quantity = item.getQuantity();
  2284. // if (stockMap.containsKey(itemCode)) {
  2285. // // 避免出现sku相同情况
  2286. // stockMap.put(itemCode, stockMap.get(itemCode) + quantity);
  2287. // } else {
  2288. // stockMap.put(itemCode, quantity);
  2289. // }
  2290. // });
  2291. // TODO 上生产时注释,模拟仓库系统(sku最大库存为3)返回
  2292. Map<String, Integer> stockMap = new HashMap<>(16);
  2293. goodsList.forEach(goods -> {
  2294. String sku = (String) goods.get("goodsSn");
  2295. if (stockMap.containsKey(sku)) {
  2296. // 避免出现sku相同情况
  2297. stockMap.put(sku, stockMap.get(sku) + 3);
  2298. } else {
  2299. stockMap.put(sku, 3);
  2300. }
  2301. });
  2302. try {
  2303. if (user == null) {
  2304. resultObj.put("errno", 400);
  2305. resultObj.put("errmsg", "用户登录超时,请重新登录");
  2306. return resultObj;
  2307. }
  2308. if (!user.getRoleType().equalsIgnoreCase("2")) {
  2309. resultObj.put("errno", 400);
  2310. resultObj.put("errmsg", "该操作只允许店员账户操作");
  2311. return resultObj;
  2312. }
  2313. if (org.apache.commons.lang3.StringUtils.isEmpty(user.getMerchSn())) {
  2314. resultObj.put("errno", 400);
  2315. resultObj.put("errmsg", "操作用户的商户编号为空,请先维护用户商户编号信息再来操作");
  2316. return resultObj;
  2317. }
  2318. Long userId = user.getUserId();
  2319. Integer storeId = user.getStoreId();
  2320. List<GoodsEntity> goodsEntities = new ArrayList<>();
  2321. BigDecimal totalTax = new BigDecimal(0);
  2322. // 根据商品条码、sku、门店id查询相对应的商品信息,并组装成对象
  2323. List<QueryGoodsVO> queryGoodsVOList = new ArrayList<>();
  2324. goodsList.forEach(map -> {
  2325. QueryGoodsVO queryGoodsVo = new QueryGoodsVO();
  2326. queryGoodsVo.setProdBarcode((String) map.get("prodBarcode"));
  2327. queryGoodsVo.setSku((String) map.get("goodsSn"));
  2328. queryGoodsVo.setStoreId(storeId.longValue());
  2329. queryGoodsVo.setSellVolume((Integer) map.get("sellVolume"));
  2330. queryGoodsVo.setRetailPrice(new BigDecimal(String.valueOf(map.get("retailPrice"))));
  2331. queryGoodsVo.setGoodsTaxes(new BigDecimal(String.valueOf(map.get("goodstaxes"))));
  2332. queryGoodsVo.setDisCountedPrice(new BigDecimal(String.valueOf(map.get("discountedPrice"))));
  2333. queryGoodsVo.setTotalPrice(new BigDecimal(String.valueOf(map.get("actualPaymentAmount"))));
  2334. queryGoodsVo.setActivity((String) map.get("activity"));
  2335. queryGoodsVOList.add(queryGoodsVo);
  2336. });
  2337. // 将在循环中查询数据库改为一次性查询
  2338. List<GoodsEntity> goodsEntityList = goodsService.queryGoodsStockByQueryGoodsVoList(queryGoodsVOList);
  2339. // 复制集合数据
  2340. ListUtils listUtils = BeanUtils.instantiate(ListUtils.class);
  2341. listUtils.copyList(goodsEntityList, queryGoodsVOList);
  2342. // 检查库存和更新库存
  2343. for (QueryGoodsVO goodsDto : queryGoodsVOList) {
  2344. // 要购买的数量
  2345. Integer sellVolume = goodsDto.getSellVolume();
  2346. String prodBarcode = goodsDto.getProdBarcode();
  2347. String sku = goodsDto.getSku();
  2348. // 园区库存
  2349. Integer goodsNumber = goodsDto.getGoodsNumber();
  2350. // 门店库存
  2351. Integer stockNum = goodsDto.getStockNum();
  2352. // 仓库库存可用库存数
  2353. Integer warehouseStock = stockMap.get(sku);
  2354. // 判断库存
  2355. if (stockMap.containsKey(sku)) {
  2356. // 当前出区数
  2357. Integer exitRegionNumber = goodsDto.getExitRegionNumber();
  2358. // 保税仓库存 + 门店库存 - 出区数 > 购买数
  2359. if (!((warehouseStock + stockNum) - exitRegionNumber > sellVolume)) {
  2360. // 库存不足
  2361. LOGGER.error("sku:【{}】库存不足,门店可用库存:【{}】,仓库可用库存:【{}】,购买数量:【{}】", sku, stockNum, warehouseStock, sellVolume);
  2362. throw new ServiceException(String.format("sku:【%s】库存不足,门店可用库存:【%s】,仓库可用库存:【%s】,购买数量:【%s】", sku, stockNum, warehouseStock, sellVolume));
  2363. }
  2364. // TODO 库存变化记录新增字段:订单号、门店编号
  2365. // 门店库存变化记录
  2366. StoreMngChangeEntity storeMngChangeEntity = new StoreMngChangeEntity();
  2367. storeMngChangeEntity.setChangeType(Dict.changeType.item_1.getItem());
  2368. storeMngChangeEntity.setChangeReason("商品销售扣减");
  2369. storeMngChangeEntity.setGoodsId(goodsDto.getId().intValue());
  2370. storeMngChangeEntity.setStoreId(Integer.parseInt(String.valueOf(goodsDto.getStoreId())));
  2371. storeMngChangeEntity.setMerchSn(goodsDto.getMerchSn());
  2372. storeMngChangeEntity.setStoreChangeNum(sellVolume);
  2373. storeMngChangeEntity.setStoreOriginalNum(stockNum);
  2374. storeMngChangeEntity.setStoreValidNum(stockNum - sellVolume);
  2375. storeMngChangeEntity.setCreateTime(new Date());
  2376. storeMngChangeEntity.setModTime(new Date());
  2377. storeMngChangeEntity.setCreaterSn(user.getUsername());
  2378. storeMngChangeEntity.setModerSn(user.getUsername());
  2379. storeMngChangeEntity.setIsValid(0);
  2380. storeMngChangeDao.save(storeMngChangeEntity);
  2381. int validNum = stockNum - sellVolume;
  2382. // 园区库存变化记录,不计销售扣减
  2383. /*MngChangeEntity mngChangeEntity = new MngChangeEntity();
  2384. mngChangeEntity.setThirdPartyMerchCode(goodsDto.getThirdPartyMerchCode());
  2385. mngChangeEntity.setChangeReason("商品销售扣减");
  2386. mngChangeEntity.setCreateTime(new Date());
  2387. mngChangeEntity.setModTime(new Date());
  2388. mngChangeEntity.setCreaterSn(user.getUsername());
  2389. mngChangeEntity.setModerSn(user.getUsername());
  2390. mngChangeEntity.setIsValid(0);
  2391. mngChangeEntity.setMerchSn(goodsDto.getMerchSn());
  2392. mngChangeEntity.setOriginalNum(goodsNumber);//原库存数
  2393. mngChangeEntity.setValidNum(goodsNumber - sellVolume);//可用数
  2394. mngChangeEntity.setChangeNum(sellVolume);//变化数
  2395. mngChangeEntity.setChangeType(Dict.changeType.item_1.getItem());
  2396. mngChangeEntity.setGoodsId(goodsDto.getId().intValue());
  2397. mngChangeDao.save(mngChangeEntity);*/
  2398. // 如果园区库存数量小于等于0, 则不更新园区库存, 园区库存只做参考
  2399. int diff = Math.max(goodsNumber - sellVolume, 0);
  2400. GoodsEntity goodsEntity = new GoodsEntity();
  2401. BeanUtils.copyProperties(goodsDto, goodsEntity);
  2402. goodsEntity.setGoodsNumber(diff);
  2403. goodsEntity.setLastSaleTime(new Date());
  2404. goodsService.updateStockNumberByProductCodeAndSku(goodsEntity);
  2405. // 门店库存
  2406. ProductStoreRelaEntity productStoreRelaEntity = new ProductStoreRelaEntity();
  2407. BeanUtils.copyProperties(goodsDto, productStoreRelaEntity);
  2408. productStoreRelaEntity.setStockNum(validNum);
  2409. productStoreRelaEntity.setStoreId(storeId.longValue());
  2410. productStoreRelaEntity.setSellVolume(sellVolume);
  2411. productStoreRelaEntity.setLastSaleTime(new Date());
  2412. productStoreRelaService.updateStockNumByStoreIdAndSku(productStoreRelaEntity);//修改普通商品库存
  2413. BigDecimal retailPrice = goodsDto.getRetailPrice(); // 单价
  2414. BigDecimal storeRetailPrice = goodsDto.getRetailPrice(); // 单价
  2415. // 优惠价
  2416. BigDecimal disCountedPrice = goodsDto.getDisCountedPrice();
  2417. // 实际支付价
  2418. BigDecimal actualPaymentAmount = goodsDto.getTotalPrice();
  2419. goodsEntity = new GoodsEntity();
  2420. BeanUtils.copyProperties(goodsDto, goodsEntity);
  2421. goodsEntity.setRetailPrice(retailPrice);
  2422. goodsEntity.setStoreRetailPrice(storeRetailPrice);
  2423. goodsEntity.setDiscountedPrice(disCountedPrice);
  2424. goodsEntity.setActualPaymentAmount(goodsDto.getTotalPrice());
  2425. goodsEntity.setSellVolume(goodsDto.getSellVolume());
  2426. goodsEntity.setActivity(goodsDto.getActivity());
  2427. goodsEntities.add(goodsEntity);
  2428. } else {
  2429. // sku不存在
  2430. LOGGER.error("库存系统中不包含此sku:【{}】,校验库存出错!下单失败!", sku);
  2431. throw new ServiceException(String.format("库存系统中不包含此sku:【%s】,下单失败!", sku));
  2432. }
  2433. // 计算该购物车所需要的所有税费
  2434. BigDecimal tax = goodsDto.getGoodsRate();
  2435. totalTax = totalTax.add(tax).setScale(2, BigDecimal.ROUND_HALF_DOWN); // 计算总的税额
  2436. }
  2437. String openId = (String) param.get("openId");
  2438. String memberCode = (String) param.get("memberCode");
  2439. UserEntity userEntity = userDao.queryByMobile((String) userInfo.get("customPhone"));
  2440. if (userEntity == null) {
  2441. // 保存用户信息
  2442. userEntity = new UserEntity();
  2443. userEntity.setUsername((String) userInfo.get("customName"));
  2444. userEntity.setPassword("");
  2445. userEntity.setIdNo((String) userInfo.get("customIDCard"));
  2446. userEntity.setMobile((String) userInfo.get("customPhone"));
  2447. userEntity.setGender(1);
  2448. userEntity.setRegisterTime(new Date());
  2449. userEntity.setLastLoginTime(new Date());
  2450. userEntity.setIdNo((String) userInfo.get("customIDCard"));
  2451. userEntity.setOpenId(openId);
  2452. userEntity.setMemberCode(memberCode);
  2453. userDao.save(userEntity);
  2454. MerchUserEntity merchUserEntity = new MerchUserEntity();
  2455. merchUserEntity.setMerchSn(user.getMerchSn());
  2456. merchUserEntity.setStoreId(storeId);
  2457. merchUserEntity.setUserId(userEntity.getId());
  2458. merchUserEntity.setCreateTime(new Date());
  2459. merchUserEntity.setIsLoadGoods("0");
  2460. merchUserDao.save(merchUserEntity);
  2461. } else {
  2462. userEntity.setUsername((String) userInfo.get("customName"));
  2463. userEntity.setIdNo((String) userInfo.get("customIDCard"));
  2464. userEntity.setMobile((String) userInfo.get("customPhone"));
  2465. if (!org.springframework.util.StringUtils.isEmpty(openId)) {
  2466. userEntity.setOpenId(openId);
  2467. }
  2468. if (!org.springframework.util.StringUtils.isEmpty(memberCode)) {
  2469. userEntity.setMemberCode(memberCode);
  2470. }
  2471. userDao.update(userEntity);
  2472. }
  2473. // 判断该用户是否是生日
  2474. /*Boolean isBirth = false;
  2475. String birthday = "";
  2476. if (userEntity.getIdNo().length() == 15) {
  2477. birthday = userEntity.getIdNo().substring(8, 10) + "-" + userEntity.getIdNo().substring(10, 12);
  2478. } else if (userEntity.getIdNo().length() == 18) {
  2479. birthday = userEntity.getIdNo().substring(10, 12) + "-" + userEntity.getIdNo().substring(12, 14);
  2480. }
  2481. SimpleDateFormat format = new SimpleDateFormat("MM-dd");
  2482. String today = format.format(new Date());
  2483. if (birthday.equalsIgnoreCase(today)) {
  2484. isBirth = true;
  2485. }*/
  2486. // 生成订单
  2487. String merchOrderSn = "EMATO" + CommonUtil.generateOrderNumber();
  2488. // OrderVo order = setOrderVo(goodsEntities, userEntity, storeId.longValue(), user.getMerchSn(), disCountAmount, totalTax, status, mapAddr);
  2489. OrderVo order = setOrderVo(goodsEntities, userEntity, storeId.longValue(), user.getMerchSn(), totalTax, status, mapAddr);
  2490. order.setStore_id(storeId.longValue());
  2491. String couponSn = (String) userInfo.get("couponSn");
  2492. order.setMerchOrderSn(merchOrderSn);
  2493. order.setCoupon_name(couponSn); // 借用这个字段来记录是否使用优惠券
  2494. //插入订单信息和订单商品
  2495. orderDao.saveOrderVo(order);
  2496. // 订单流转表
  2497. OrderProcessRecordEntity processRecordEntity = new OrderProcessRecordEntity();
  2498. processRecordEntity.setOrderSn(order.getOrder_sn());
  2499. processRecordEntity.setUserId(Integer.valueOf(userEntity.getId() + ""));
  2500. processRecordEntity.setAddOrderStartTime(order.getCreateTime());
  2501. processRecordEntity.setIsAddOrderSend(Dict.isSend.item_1.getItem());
  2502. processRecordEntity.setOrderBizType(Dict.orderBizType.item_10.getItem());
  2503. if (null == order.getId()) {
  2504. resultObj.put("errno", 400);
  2505. resultObj.put("errmsg", "订单提交失败");
  2506. return resultObj;
  2507. }
  2508. List<OrderGoodsVo> orderGoodsVoList = goodsEntities.stream().map(goodsEntity -> setOrderGoodsVo(order, goodsEntity)).collect(Collectors.toList());
  2509. // 批量保存订单详情
  2510. orderGoodsService.saveBatchOrderDetail(orderGoodsVoList);
  2511. //清空预订单商品临时表
  2512. Map orderInfoMap = Maps.newHashMap();
  2513. orderInfoMap.put("orderInfo", order);
  2514. resultObj.put("errno", 0);
  2515. resultObj.put("errmsg", "订单提交成功");
  2516. resultObj.put("data", orderInfoMap);
  2517. //判断支付类型,并支付订单
  2518. R r = null;
  2519. //保存支付记录
  2520. OrderWXPayRecordEntity orderWXPayRecordCurrent = orderWXPayRecordService.saveRecordVo(order);
  2521. StoreEntity store = storeService.queryObject(order.getStore_id().intValue());
  2522. processRecordEntity.setPaymentStartTime(new Date());
  2523. // 判断是微信的支付码还是支付宝的支付码
  2524. // if (parCode.startsWith("28")) {
  2525. // // 支付宝支付
  2526. // try {
  2527. // AliPay(user, parCode, order, processRecordEntity, orderWXPayRecordCurrent, store);
  2528. // } catch (Exception e) {
  2529. // LOGGER.error("支付宝支付出现异常!订单号:【{}】", order.getOrder_sn(), e);
  2530. // throw e;
  2531. // }
  2532. // } else {
  2533. // // 微信支付
  2534. // try {
  2535. // wxPay(user, parCode, resultObj, order, processRecordEntity, orderWXPayRecordCurrent, store);
  2536. // } catch (Exception e) {
  2537. // e.printStackTrace();
  2538. // throw e;
  2539. // }
  2540. // }
  2541. processRecordEntity.setPaymentStartTime(new Date());
  2542. // TODO 到时候要注释掉,测试用而已
  2543. OrderEntity orderEntity = queryObject(order.getId());
  2544. orderEntity.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_201.getItem()));
  2545. orderEntity.setPayStatus(Integer.parseInt(Dict.payStatus.item_2.getItem()));
  2546. orderEntity.setPayTime(new Date());
  2547. orderDao.update(orderEntity);
  2548. resultObj.put("shopName", store.getStoreName()); // 根据门店编号查询
  2549. resultObj.put("userName", user.getUsername());
  2550. // 保存订单流转表
  2551. // 设置下单完成时间
  2552. processRecordEntity.setAddOrderSuccTime(order.getPay_time());
  2553. // 设置其他开始时间
  2554. Date date = new Date();
  2555. processRecordEntity.setPaymentStartTime(date);
  2556. processRecordEntity.setEleOrderStartTime(date);
  2557. processRecordEntity.setWaybillStartTime(date);
  2558. orderProcessRecordDao.save(processRecordEntity);
  2559. // 生成销售记录
  2560. SaleRecordEntity saleRecordEntity = new SaleRecordEntity();
  2561. // 根据收银机机器码,查询收银机
  2562. CashierEntity cashierEntity = cashierDao.queryByMachineCode(machineCode, storeId + "");
  2563. if (cashierEntity != null) {
  2564. saleRecordEntity.setCashierSn(cashierEntity.getCashierSn());
  2565. saleRecordEntity.setOrderSn(order.getOrder_sn());
  2566. saleRecordEntity.setSallerId(userId + "");
  2567. saleRecordEntity.setSalesTime(new Date());
  2568. // saleRecordEntity.setDiscountId(topicId + "");
  2569. saleRecordEntity.setCreateTime(new Date());
  2570. saleRecordDao.save(saleRecordEntity);
  2571. }
  2572. // 查询当前时间积分规则以及明细,根据积分生成规则进行增加会员积分
  2573. Integer userEntityId = userEntity.getId();
  2574. // 总的积分:基础积分
  2575. AtomicReference<Integer> memberScore = new AtomicReference<>(0);
  2576. List<PointsRulesAndDetailVO> pointsRulesAndDetailVOList = mall2PointsRulesService.queryListByTime(new Date()).stream().sorted().collect(Collectors.toList());
  2577. // 商品map,key===>sku value===>金额
  2578. Map<String, BigDecimal> goodsMap = goodsEntities.stream().collect(Collectors.toMap(GoodsEntity::getSku, GoodsEntity::getActualPaymentAmount, (k1, k2) -> k2));
  2579. // 订单全部的sku
  2580. Set<String> goodsSkuList = goodsMap.keySet();
  2581. // 保存不在按商品计算积分的sku
  2582. List<String> nonGoodsSkuList = new ArrayList<>();
  2583. // 保存不在按分类计算积分的sku,剩下的就按门店计算,如果门店积分规则没有设置。。。。
  2584. List<String> nonCategorySkuList = new ArrayList<>();
  2585. pointsRulesAndDetailVOList.forEach(pointsRulesAndDetailVO -> {
  2586. Mall2PointsRulesEntity mall2PointsRulesEntity = pointsRulesAndDetailVO.getMall2PointsRulesEntity();
  2587. List<Mall2RulesDto> mall2PointsRulesDetailList = pointsRulesAndDetailVO.getMall2PointsRulesDetailList();
  2588. List<String> skuList = mall2PointsRulesDetailList.stream().map(Mall2RulesDto::getPointsRulesName).collect(Collectors.toList());
  2589. Integer pointsType = mall2PointsRulesEntity.getPointsType();
  2590. // 积分比例
  2591. BigDecimal ratio = mall2PointsRulesEntity.getRatio();
  2592. if (pointsType.equals(Constants.MemberScoreRulesEnum.TWO.getCode())) {
  2593. // 商品,优先级最高,查询
  2594. goodsSkuList.forEach(sku -> {
  2595. if (skuList.contains(sku)) {
  2596. // 商品积分生成规则包含这个sku
  2597. // 订单中该sku的总金额
  2598. BigDecimal money = goodsMap.get(sku);
  2599. if (ratio.compareTo(BigDecimal.ZERO) != 0) {
  2600. // 算出所积的分
  2601. memberScore.set(money.multiply(ratio).add(new BigDecimal(memberScore.get())).intValue());
  2602. } else {
  2603. // 积分比例设置为0,该商品不记积分。
  2604. LOGGER.info("商品SKU:【{}】,积分生成规则设置积分比例为:{},故不产生积分!", sku, ratio);
  2605. }
  2606. } else {
  2607. // 不包含sku,则需要判断是否有其他规则
  2608. nonGoodsSkuList.add(sku);
  2609. }
  2610. });
  2611. }
  2612. if (pointsType.equals(Constants.MemberScoreRulesEnum.ONE.getCode())) {
  2613. // 商品类别
  2614. nonGoodsSkuList.forEach(sku -> {
  2615. if (nonGoodsSkuList.contains(sku)) {
  2616. // 订单中该sku的总金额
  2617. BigDecimal money = goodsMap.get(sku);
  2618. if (ratio.compareTo(BigDecimal.ZERO) != 0) {
  2619. // 算出所积的分
  2620. memberScore.set(money.multiply(ratio).add(new BigDecimal(memberScore.get())).intValue());
  2621. }
  2622. } else {
  2623. nonCategorySkuList.add(sku);
  2624. }
  2625. });
  2626. }
  2627. if (pointsType.equals(Constants.MemberScoreRulesEnum.ZERO.getCode())) {
  2628. // 门店
  2629. nonCategorySkuList.forEach(sku -> {
  2630. if (nonCategorySkuList.contains(sku)) {
  2631. // 订单中该sku的总金额
  2632. BigDecimal money = goodsMap.get(sku);
  2633. if (ratio.compareTo(BigDecimal.ZERO) != 0) {
  2634. // 算出所积的分
  2635. memberScore.set(money.multiply(ratio).multiply(new BigDecimal(memberScore.get())).intValue());
  2636. }
  2637. }
  2638. });
  2639. }
  2640. });
  2641. // 增加该会员的积分
  2642. Mall2MemberPointsEntity memberPointsEntity = memberPointsDao.queryByUserId(userEntityId);
  2643. if (memberPointsEntity == null) {
  2644. memberPointsEntity = new Mall2MemberPointsEntity();
  2645. memberPointsEntity.setUserId(userEntityId + "");
  2646. memberPointsEntity.setPoints(memberScore.get());
  2647. memberPointsEntity.setCreaterSn(userId + "");
  2648. memberPointsEntity.setCreateTime(new Date());
  2649. memberPointsDao.save(memberPointsEntity);
  2650. } else {
  2651. memberPointsEntity.setPoints(memberScore.get() + memberPointsEntity.getPoints());
  2652. memberPointsEntity.setModerSn(userId + "");
  2653. memberPointsEntity.setModTime(new Date());
  2654. memberPointsDao.update(memberPointsEntity);
  2655. }
  2656. // 增加该会员的消费记录
  2657. Mall2MemberConsumptionRecordsEntity consumptionRecords = new Mall2MemberConsumptionRecordsEntity();
  2658. consumptionRecords.setUserId(userEntity.getId() + "");
  2659. consumptionRecords.setOrderSn(order.getOrder_sn());
  2660. consumptionRecords.setConsumptionTime(new Date());
  2661. consumptionRecords.setShopSn(String.valueOf(storeId));
  2662. // 积分消费记录
  2663. String deductionScoreStr = (String) param.get("deductionScore");
  2664. String scoreDeductionPriceStr = (String) param.get("scoreDeductionPrice");
  2665. Integer beforeScoreInteger = (Integer) param.get("beforeScore") ;
  2666. Integer afterScoreStrInteger = (Integer) param.get("afterScore");
  2667. int deductionScore = org.springframework.util.StringUtils.isEmpty(deductionScoreStr) ? 0 : Integer.parseInt(deductionScoreStr);
  2668. String memberPhone = String.valueOf(param.get("memberPhone"));
  2669. BigDecimal scoreDeductionPrice = org.springframework.util.StringUtils.isEmpty(scoreDeductionPriceStr) ? BigDecimal.ZERO : new BigDecimal(scoreDeductionPriceStr);
  2670. consumptionRecords.setBeforeScore(beforeScoreInteger);
  2671. consumptionRecords.setAfterScore(afterScoreStrInteger);
  2672. // TODO 需要新增字段:订单赠送积分
  2673. consumptionRecords.setOrderTotalPrice(order.getActual_price());
  2674. consumptionRecords.setScoreDeductionPrice(scoreDeductionPrice);
  2675. consumptionRecords.setMemberCode(memberCode);
  2676. consumptionRecords.setMemberPhone(memberPhone);
  2677. consumptionRecords.setDeductionScore(deductionScore);
  2678. consumptionRecords.setCreaterSn(userId + "");
  2679. consumptionRecords.setCreateTime(new Date());
  2680. memberConsumptionRecordsDao.save(consumptionRecords);
  2681. // 同步会员订单消费记录
  2682. if (!org.springframework.util.StringUtils.isEmpty(memberCode)) {
  2683. syncMemberConsumeRecord(memberPhone, order, deductionScore);
  2684. }
  2685. // 积分变动接口,下单扣减
  2686. // if (!org.springframework.util.StringUtils.isEmpty(memberCode)) {
  2687. syncMemberScoreChangeRecord(openId, order, deductionScore, "下单扣减", HaiKongMemberScoreChangeEventEnum.SUBTRACT.getEvent());
  2688. // 下单赠送,一元积一分
  2689. Integer score = order.getActual_price().intValue();
  2690. syncMemberScoreChangeRecord(openId, order, score, "下单赠送", HaiKongMemberScoreChangeEventEnum.ADD.getEvent());
  2691. // }
  2692. // 生成取票码
  2693. PickUpCodeEntity pickUpCodeEntity = new PickUpCodeEntity();
  2694. pickUpCodeEntity.setOrderSn(order.getOrder_sn());
  2695. pickUpCodeEntity.setPickUpCodeSn(cashierEntity.getCashierSn());//小票码前段
  2696. pickUpCodeService.save(pickUpCodeEntity);
  2697. resultObj.put("code", pickUpCodeEntity.getPickUpCodeSn()); // 系统中累加
  2698. resultObj.put("time", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
  2699. resultObj.put("orderNo", order.getOrder_sn()); //
  2700. resultObj.put("phone", (String) userInfo.get("customPhone"));
  2701. // 通知WebSocket
  2702. WebSocketServer.sendMessage(sessionId, order.getOrder_sn(), order.getStore_id()
  2703. + "");
  2704. JedisUtil.del(Constants.WAREHOUSE_STOCK_MAP_KEY + "_" + storeId);
  2705. return resultObj;
  2706. } catch (Exception e) {
  2707. e.printStackTrace();
  2708. resultObj.put("errno", 400);
  2709. resultObj.put("errmsg", "订单异常------" + e.getMessage());
  2710. throw new RuntimeException(e);
  2711. }
  2712. }
  2713. private void AliPay(SysUserEntity user, String parCode, OrderVo order, OrderProcessRecordEntity processRecordEntity, OrderWXPayRecordEntity orderWXPayRecordCurrent, StoreEntity store) throws Exception {
  2714. AliPayRequestParams params = new AliPayRequestParams();
  2715. String orderBizTypeZn = "普通货物";
  2716. if ("00".equals(order.getOrderBizType())) {
  2717. orderBizTypeZn = "保税备货";
  2718. } else if ("02".equals(order.getOrderBizType())) {
  2719. orderBizTypeZn = "保税展示补货";
  2720. } else if ("10".equals(order.getOrderBizType())) {
  2721. orderBizTypeZn = "保税展示跨境";
  2722. }
  2723. params.setAuthCode(parCode);
  2724. params.setBody(order.getApprovalRemark());
  2725. params.setOutTradeNo(order.getOrder_sn());
  2726. params.setSubject(store.getMerchName() + "-" + store.getStoreName() + "-" + orderBizTypeZn);
  2727. params.setStoreId(store.getId() + "");
  2728. params.setTotalAmount(order.getActual_price().setScale(2, BigDecimal.ROUND_HALF_UP) + "");
  2729. LOGGER.info("调用阿里支付接口的请求参数:" + JacksonUtils.toJson(params));
  2730. AliPayMicropayApiResult aliPayMicropayApiResult = AliPayUtil.aliTradePay(params);
  2731. orderWXPayRecordService.updateRecordByAli(orderWXPayRecordCurrent.getId(), aliPayMicropayApiResult);
  2732. LOGGER.info("调用阿里支付接口的同步返回结果:" + JacksonUtils.toJson(aliPayMicropayApiResult));
  2733. // 修改订单状态
  2734. //当支付成功时,修改订单,并把其他支付记录撤销
  2735. if (AliPayUtil.AliPayTradeState.SUCC.getCode().equals(aliPayMicropayApiResult.getCode())) {
  2736. // //查询当前订单所有的支付记录
  2737. // List<OrderWXPayRecordEntity> orderWXPayRecordEntitys =
  2738. // orderWXPayRecordService.getRecordsByOutTradeNo(order.getOrder_sn());
  2739. this.confirmPay(order.getId(), Dict.payFlag.item_alipay.getItem(), aliPayMicropayApiResult.getTradeNo());
  2740. // 设置支付单完成时间
  2741. processRecordEntity.setPaymentSuccTime(aliPayMicropayApiResult.getGmtPayment());
  2742. processRecordEntity.setPayTransactionId(aliPayMicropayApiResult.getTradeNo());
  2743. // 组装支付单信息
  2744. Map<String, Object> orderSendCusParams = new HashMap<>();
  2745. orderSendCusParams.put("merchSn", order.getMerchSn());
  2746. orderSendCusParams.put("merchName", order.getMerchName());
  2747. orderSendCusParams.put("thirdPartyMerchCode", store.getThirdPartyMerchCode());
  2748. orderSendCusParams.put("thirdPartyMerchName", store.getThirdPartyMerchName());
  2749. orderSendCusParams.put("tradeNo", order.getAliTradeNo());
  2750. orderSendCusParams.put("amount", order.getActual_price());
  2751. // 将支付单信息发送到当前项目下的 cuspay
  2752. aliCusDeclareBiz.biz(orderSendCusParams);
  2753. // 系统繁忙
  2754. } else if (AliPayUtil.AliPayTradeState.SERVER_FAIL.getCode().equals(aliPayMicropayApiResult.getCode())) {
  2755. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2756. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请稍后再试");
  2757. // 支付失败
  2758. } else if (AliPayUtil.AliPayTradeState.BUSINESS_FAIL.getCode().equals(aliPayMicropayApiResult.getCode())) {
  2759. // 系统异常
  2760. if (AliPayUtil.BusinessFailState.SYSTEM_ERROR.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2761. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2762. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请稍后再试");
  2763. // 订单总额超过限额
  2764. } else if (AliPayUtil.BusinessFailState.TOTAL_FEE_EXCEED.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2765. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2766. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请告知顾客");
  2767. // 授权码无效
  2768. } else if (AliPayUtil.BusinessFailState.PAYMENT_AUTH_CODE_INVALID.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2769. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2770. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请顾客刷新条码后,重新支付");
  2771. // 交易信息被篡改
  2772. } else if (AliPayUtil.BusinessFailState.CONTEXT_INCONSISTENT.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2773. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2774. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请重试");
  2775. // 余额支付功能关闭
  2776. } else if (AliPayUtil.BusinessFailState.ERROR_BALANCE_PAYMENT_DISABLE.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2777. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2778. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请用户打开余额支付");
  2779. // 交易买家不匹配
  2780. } else if (AliPayUtil.BusinessFailState.TRADE_BUYER_NOT_MATCH.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2781. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2782. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请重试");
  2783. // 买家状态非法
  2784. } else if (AliPayUtil.BusinessFailState.BUYER_ENABLE_STATUS_FORBID.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2785. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2786. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请买家联系支付宝小二,确认为什么非法");
  2787. // 唤起移动收银台失败
  2788. } else if (AliPayUtil.BusinessFailState.PULL_MOBILE_CASHIER_FAIL.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2789. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2790. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请用户刷新条码后,重新支付");
  2791. // 用户的无限支付开关关闭
  2792. } else if (AliPayUtil.BusinessFailState.MOBILE_PAYMENT_SWITCH_OFF.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2793. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2794. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请用户在PC上打开无线支付开关后,在发起支付");
  2795. // 支付失败
  2796. } else if (AliPayUtil.BusinessFailState.PAYMENT_FAIL.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2797. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2798. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请重试");
  2799. // 商户账号被冻结
  2800. } else if (AliPayUtil.BusinessFailState.SELLER_BEEN_BLOCKED.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2801. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2802. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请联系支付宝小二解冻");
  2803. // 买家未通过人行认证
  2804. } else if (AliPayUtil.BusinessFailState.ERROR_BUYER_CERTIFY_LEVEL_LIMIT.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2805. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2806. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请买家联系支付宝小二");
  2807. // 用户当面付付款开关管壁
  2808. } else if (AliPayUtil.BusinessFailState.USER_FACE_PAYMENT_SWITCH_OFF.getCode().equalsIgnoreCase(aliPayMicropayApiResult.getSubCode())) {
  2809. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2810. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + ",请买家打开当面付付款开关");
  2811. } else {
  2812. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2813. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg());
  2814. }
  2815. // 其他支付异常状态
  2816. } else {
  2817. LOGGER.info(aliPayMicropayApiResult.getSubMsg());
  2818. throw new RuntimeException(aliPayMicropayApiResult.getSubMsg() + "...........请联系管理员");
  2819. }
  2820. }
  2821. private void wxPay(SysUserEntity user, String parCode, Map resultObj, OrderVo order, OrderProcessRecordEntity processRecordEntity, OrderWXPayRecordEntity orderWXPayRecordCurrent, StoreEntity store) throws ParseException {
  2822. R r;
  2823. String ip = "127.0.0.1";
  2824. try {
  2825. InetAddress ia = InetAddress.getLocalHost();
  2826. // String localname=ia.getHostName();
  2827. ip = ia.getHostAddress();
  2828. } catch (Exception e) {
  2829. e.printStackTrace();
  2830. }
  2831. WechatMicropayApiResult wechatMicropayApiResult = WechatUtil
  2832. .wxMicropay(store.getMerchName() + "-" + store.getStoreName(), order.getOrderBizType(), null,
  2833. orderWXPayRecordCurrent.getOutTradeNoWX(), order.getActual_price().doubleValue(),
  2834. ip, parCode);
  2835. orderWXPayRecordService.updateRecord(orderWXPayRecordCurrent.getId(), wechatMicropayApiResult);
  2836. resultObj.put("shopName", store.getStoreName()); // 根据门店编号查询
  2837. resultObj.put("userName", user.getUsername());
  2838. // 修改订单状态
  2839. //当支付成功时,修改订单,并把其他支付记录撤销
  2840. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2841. //查询当前订单所有的支付记录
  2842. List<OrderWXPayRecordEntity> orderWXPayRecordEntitys =
  2843. orderWXPayRecordService.getRecordsByOutTradeNo(order.getOrder_sn());
  2844. LOGGER.info("wechatMicropayApiResult.getTransaction_id()" + wechatMicropayApiResult.getTransaction_id());
  2845. Map orderRaram = Maps.newHashMap();
  2846. orderRaram.put("payTransactionId", wechatMicropayApiResult.getTransaction_id());
  2847. orderRaram.put("orderId", order.getId());
  2848. orderDao.updateOrderInfo(orderRaram);
  2849. this.confirmPay(order.getId(), Dict.payFlag.item_weixin.getItem(), orderWXPayRecordCurrent.getOutTradeNoWX());
  2850. // 设置支付单完成时间
  2851. processRecordEntity.setPaymentSuccTimeStr(wechatMicropayApiResult.getTime_end());
  2852. processRecordEntity.setPaymentSuccTime(
  2853. new SimpleDateFormat("yyyyMMddHHmmss").parse(wechatMicropayApiResult.getTime_end()));
  2854. processRecordEntity.setPayTransactionId(wechatMicropayApiResult.getTransaction_id());
  2855. // 组装支付单信息
  2856. Map<String, Object> orderSendCusParams = new HashMap<>();
  2857. orderSendCusParams.put("merchSn", order.getMerchSn());
  2858. orderSendCusParams.put("merchName", order.getMerchName());
  2859. orderSendCusParams.put("thirdPartyMerchCode", store.getThirdPartyMerchCode());
  2860. orderSendCusParams.put("thirdPartyMerchName", store.getThirdPartyMerchName());
  2861. orderSendCusParams.put("outTradeNo", order.getMerchOrderSn());
  2862. orderSendCusParams.put("transactionId", order.getPayTransactionId());
  2863. orderSendCusParams.put("subOrderId", ""); // ccnet原逻辑没有对该字段赋值
  2864. orderSendCusParams.put("subOrderNo", order.getOrder_sn());
  2865. // 将支付单信息发送到当前项目下的 cuspay
  2866. wxCusDeclareBiz.biz(orderSendCusParams);
  2867. //用户支付中
  2868. } else if (WechatUtil.WXTradeState.USERPAYING.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2869. r = R.error(WechatUtil.WXTradeState.USERPAYING.getCodeZn() + ",稍等片刻后请刷新页面重新查看订单状态");
  2870. int times = 0;
  2871. // 查询是否支付了
  2872. while (true) {
  2873. boolean flag = orderQuery(order, processRecordEntity);
  2874. if (flag) {
  2875. break;
  2876. }
  2877. try {
  2878. Thread.currentThread().sleep(1000);
  2879. } catch (InterruptedException e) {
  2880. e.printStackTrace();
  2881. }
  2882. if (times >= 60) {
  2883. throw new RuntimeException("超过60s未支付,订单下单失败");
  2884. }
  2885. times++;
  2886. }
  2887. //用户支付失败
  2888. } else if (WechatUtil.WXTradeState.PAYERROR.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  2889. WechatReverseApiResult wechatReverseApiResult =
  2890. WechatUtil.wxReverse(orderWXPayRecordCurrent.getOutTradeNoWX());
  2891. //撤销订单成功
  2892. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getReturn_code()) &&
  2893. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getResult_code())) {
  2894. //调用订单查询接口
  2895. WechatRefundApiResult wechatRefundApiResult =
  2896. WechatUtil.wxOrderQuery(orderWXPayRecordCurrent.getOutTradeNoWX());
  2897. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getReturn_code()) &&
  2898. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getResult_code())) {
  2899. // 修改订单支付记录
  2900. orderWXPayRecordService
  2901. .updateWXPayRecordTradeState(orderWXPayRecordCurrent.getId(), wechatRefundApiResult);
  2902. }
  2903. r = R.error(orderWXPayRecordCurrent.getErrCodeDes());
  2904. } else {
  2905. r = R.error(wechatReverseApiResult.getErr_code_des());
  2906. }
  2907. throw new RuntimeException("订单支付失败");
  2908. } else {
  2909. throw new RuntimeException("未支付或支付失败,请联系管理员");
  2910. }
  2911. }
  2912. /**
  2913. * 同步会员消费记录
  2914. * @param memberPhone 会员手机号
  2915. * @param order 订单信息
  2916. * @param deductionScore 抵扣积分
  2917. */
  2918. private void syncMemberConsumeRecord(String memberPhone, OrderVo order, Integer deductionScore) {
  2919. HaiKongMemberOrderSyncResendEntity haiKongMemberOrderSyncResendEntity = new HaiKongMemberOrderSyncResendEntity();
  2920. MemberOrderInfoSyncDTO memberOrderInfoSyncDTO = new MemberOrderInfoSyncDTO();
  2921. memberOrderInfoSyncDTO.setPhone(memberPhone);
  2922. memberOrderInfoSyncDTO.setOrderNo(order.getOrder_sn());
  2923. memberOrderInfoSyncDTO.setConsumeDate(new Date());
  2924. memberOrderInfoSyncDTO.setOrderAmount(order.getActual_price());
  2925. memberOrderInfoSyncDTO.setOrderScore(deductionScore);
  2926. BeanUtils.copyProperties(memberOrderInfoSyncDTO, haiKongMemberOrderSyncResendEntity);
  2927. Date date = new Date();
  2928. haiKongMemberOrderSyncResendEntity.setCreateTime(date);
  2929. haiKongMemberOrderSyncResendEntity.setLastResendTime(date);
  2930. try {
  2931. String body = JacksonUtil.toJson(memberOrderInfoSyncDTO);
  2932. LOGGER.info("请求会员系统同步消费订单接口!请求体:{}", body);
  2933. // 发送请求
  2934. String memberOrderSyncResponseJson = haiKongMemberTemplate.memberOrderSync(body);
  2935. Response<Long> response = JacksonUtil.fromListJson(memberOrderSyncResponseJson, new TypeReference<Response<Long>>() {});
  2936. if (Objects.nonNull(response) && response.getSuccess()) {
  2937. haiKongMemberOrderSyncResendEntity.setMemberSysOrderId(response.getData());
  2938. haiKongMemberOrderSyncResendEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.NON_RESEND.getStatus());
  2939. } else {
  2940. haiKongMemberOrderSyncResendEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.WAIT_RESEND.getStatus());
  2941. }
  2942. haiKongMemberOrderSyncResendService.save(haiKongMemberOrderSyncResendEntity);
  2943. LOGGER.info("请求会员系统同步消费订单接口成功!响应数据:{}", memberOrderSyncResponseJson);
  2944. } catch (Exception e) {
  2945. LOGGER.error("请求会员系统同步消费订单接口失败!准备新增发送失败记录,等待重发!异常信息:", e);
  2946. // 没有请求成功,写表,重发
  2947. haiKongMemberOrderSyncResendEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.WAIT_RESEND.getStatus());
  2948. haiKongMemberOrderSyncResendService.save(haiKongMemberOrderSyncResendEntity);
  2949. }
  2950. }
  2951. /**
  2952. * 同步会员积分变动记录
  2953. * @param openId 会员openid
  2954. * @param order 订单信息
  2955. * @param score 变动积分
  2956. */
  2957. private void syncMemberScoreChangeRecord(String openId, OrderVo order, Integer score, String changeReason, String changeEvent) {
  2958. HaiKongMemberScoreChangeRecordEntity haiKongMemberScoreChangeRecordEntity = new HaiKongMemberScoreChangeRecordEntity();
  2959. MemberScoreChangeDTO memberScoreChangeDTO = new MemberScoreChangeDTO();
  2960. String changeId = UUID.randomUUID(true).toString();
  2961. memberScoreChangeDTO.setChangeEvent(changeEvent);
  2962. memberScoreChangeDTO.setChangeId(changeId);
  2963. memberScoreChangeDTO.setChangeReason(changeReason);
  2964. memberScoreChangeDTO.setOpenId(openId);
  2965. memberScoreChangeDTO.setOutBizNo(order.getOrder_sn());
  2966. memberScoreChangeDTO.setScore(score);
  2967. BeanUtils.copyProperties(memberScoreChangeDTO, haiKongMemberScoreChangeRecordEntity);
  2968. Date date = new Date();
  2969. haiKongMemberScoreChangeRecordEntity.setCreateTime(date);
  2970. haiKongMemberScoreChangeRecordEntity.setModifyTime(date);
  2971. try {
  2972. String body = JacksonUtil.toJson(memberScoreChangeDTO);
  2973. LOGGER.info("请求会员系统积分变动接口!请求体:{}", body);
  2974. String changeMemberScoreResponseJson = haiKongMemberTemplate.changeMemberScore(body);
  2975. Response<MemberScoreChangeResponseDTO> response = JacksonUtil.fromListJson(changeMemberScoreResponseJson, new TypeReference<Response<MemberScoreChangeResponseDTO>>() {});
  2976. if (Objects.nonNull(response) && response.getSuccess()) {
  2977. MemberScoreChangeResponseDTO responseData = response.getData();
  2978. haiKongMemberScoreChangeRecordEntity.setStatementId(responseData.getStatementId());
  2979. haiKongMemberScoreChangeRecordEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.NON_RESEND.getStatus());
  2980. } else {
  2981. haiKongMemberScoreChangeRecordEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.WAIT_RESEND.getStatus());
  2982. }
  2983. haiKongMemberScoreChangeRecordService.save(haiKongMemberScoreChangeRecordEntity);
  2984. LOGGER.info("请求会员系统积分变动接口成功!响应数据:{}", changeMemberScoreResponseJson);
  2985. } catch (Exception e) {
  2986. // 失败重发
  2987. haiKongMemberScoreChangeRecordEntity.setResendStatus(HaiKongMemberOrderResendStatusEnum.WAIT_RESEND.getStatus());
  2988. haiKongMemberScoreChangeRecordService.save(haiKongMemberScoreChangeRecordEntity);
  2989. }
  2990. }
  2991. private boolean orderQuery(OrderVo order, OrderProcessRecordEntity processRecordEntity) {
  2992. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口调用");
  2993. String merchOrderSn = order.getMerchOrderSn();
  2994. String orderId = order.getId() + "";
  2995. String orderSn = order.getOrder_sn();
  2996. WechatRefundApiResult result = WechatUtil.wxOrderQuery(orderSn);
  2997. if (result.getReturn_code().equalsIgnoreCase(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  2998. if (result.getResult_code().equalsIgnoreCase(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  2999. if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_SUCCESS.getItem())) {
  3000. Date successTime = DateUtils.convertStringToDate(result.getTime_end(),
  3001. DateUtils.DATE_TIME_PATTERN_YYYY_MM_DD_HH_MM_SS);
  3002. Map orderRaram = Maps.newHashMap();
  3003. orderRaram.put("payStatus", Dict.payStatus.item_2.getItem());//已支付
  3004. orderRaram.put("orderStatus", Dict.orderStatus.item_201.getItem());//已支付
  3005. orderRaram.put("payTransactionId", result.getTransaction_id());
  3006. orderRaram.put("payTime", successTime);
  3007. orderRaram.put("orderId", orderId);
  3008. orderRaram.put("payFlag", Dict.payFlag.item_weixin.getItem());
  3009. orderDao.updateOrderInfo(orderRaram);
  3010. Map processParam = Maps.newHashMap();
  3011. processParam.put("payTime", successTime);
  3012. processParam.put("orderSn", orderSn);
  3013. orderDao.updateOrderProcessRecord(processParam);
  3014. // orderWXPayRecordService
  3015. // .updateWXPayRecordTradeState(orderWXPayRecordTemp.getId(), wechatRefundApiResult);
  3016. // 设置支付单完成时间
  3017. processRecordEntity.setPaymentSuccTimeStr(result.getTime_end());
  3018. processRecordEntity.setPaymentSuccTime(successTime);
  3019. processRecordEntity.setPayTransactionId(result.getTransaction_id());
  3020. return true;
  3021. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_NOTPAY.getItem())) {//订单未支付
  3022. Map orderRaram = Maps.newHashMap();
  3023. orderRaram.put("payStatus", Dict.payStatus.item_0.getItem());//支付状态未支付
  3024. orderRaram.put("orderStatus", Dict.orderStatus.item_0.getItem());//订单状态未支付
  3025. orderRaram.put("orderId", orderId);
  3026. orderDao.updateOrderInfo(orderRaram);
  3027. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_CLOSED.getItem())) {
  3028. Map orderRaram = Maps.newHashMap();
  3029. orderRaram.put("payStatus", Dict.payStatus.item_7.getItem());
  3030. orderRaram.put("orderStatus", Dict.orderStatus.item_500.getItem());
  3031. orderRaram.put("orderId", orderId);
  3032. orderDao.updateOrderInfo(orderRaram);
  3033. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  3034. "】,des【" + result.getTrade_state_desc() + "】");
  3035. return false;
  3036. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_PAYERROR.getItem())) {
  3037. Map orderRaram = Maps.newHashMap();
  3038. orderRaram.put("payStatus", Dict.payStatus.item_8.getItem());
  3039. orderRaram.put("orderStatus", Dict.orderStatus.item_501.getItem());
  3040. orderRaram.put("orderId", orderId);
  3041. orderDao.updateOrderInfo(orderRaram);
  3042. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  3043. "】,des【" + result.getTrade_state_desc() + "】");
  3044. return false;
  3045. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_USERPAYING.getItem())) {
  3046. Map orderRaram = Maps.newHashMap();
  3047. orderRaram.put("payStatus", Dict.payStatus.item_1.getItem());
  3048. orderRaram.put("orderStatus", Dict.orderStatus.item_100.getItem());
  3049. orderRaram.put("orderId", orderId);
  3050. orderDao.updateOrderInfo(orderRaram);
  3051. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  3052. "】,des【" + result.getTrade_state_desc() + "】");
  3053. } else if (result.getTrade_state().equalsIgnoreCase(Dict.tradeState.item_REVOKED.getItem())) {
  3054. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderByTransactionIdQueryUpdFail 根据支付单查询微信接口返回信息:state 【" + result.getTrade_state() +
  3055. "】,des【" + result.getTrade_state_desc() + "】");
  3056. return false;
  3057. }
  3058. } else {
  3059. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口返回失败信息:code 【" + result.getErr_code() +
  3060. "】,des【" + result.getErr_code_des() + "】");
  3061. }
  3062. return false;
  3063. } else {
  3064. LOGGER.info(">>>>>>>>>>>>>>>>>>>>wxOrderQuery 微信查询接口调用失败: " + result.getReturn_msg());
  3065. return false;
  3066. }
  3067. }
  3068. @Override
  3069. public OrderEntity queryObjectByOrderSn(String orderSn) {
  3070. return orderDao.queryObjectByOrderSn(orderSn);
  3071. }
  3072. ExecutorService service = Executors.newSingleThreadExecutor();
  3073. // 收银端退款的代码
  3074. @Override
  3075. @Transactional
  3076. public synchronized R orderRefund(OrderEntity order, String sessionId, SysUserEntity user) throws Exception {
  3077. OrderEntity orderInfo = order;
  3078. if (null == orderInfo) {
  3079. return R.error("订单不存在");
  3080. }
  3081. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem()) ||
  3082. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  3083. return R.error("订单已退款");
  3084. }
  3085. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  3086. return R.error("订单正在准备,请稍等!");
  3087. }
  3088. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_100.getItem()) ||
  3089. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())||
  3090. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())
  3091. ) {
  3092. return R.error("订单尚未支付完成,无法进行退款!");
  3093. }
  3094. String payFlag = order.getPayFlag();
  3095. String key = "kmall_order_refund_" + order.getOrderSn();
  3096. if (JedisUtil.exists(key)) {
  3097. return R.error("订单退款操作过快,请等待!");
  3098. }
  3099. JedisUtil.set(key, System.currentTimeMillis() + "", 3);
  3100. if (orderInfo.getPayStatus() == Integer.parseInt(Dict.payStatus.item_3.getItem())) {
  3101. return R.error("订单正在退款中,请勿重复退款");
  3102. }
  3103. // CountDownLatch cdl = new CountDownLatch(1);
  3104. // service.submit(()-> {
  3105. // try {
  3106. orderDao.updateOrderRefunding(order.getId());
  3107. // } finally {
  3108. // cdl.countDown();
  3109. // }
  3110. // });
  3111. // cdl.await();
  3112. if (Dict.payFlag.item_weixin.getItem().equals(payFlag)) {
  3113. Double totalActualPrice = orderDao.getTotalActualPrice(orderInfo.getMerchOrderSn());
  3114. if (totalActualPrice == null) {
  3115. totalActualPrice = 0d;
  3116. }
  3117. if (orderInfo.getOrderStatus() != Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  3118. LOGGER.info("[微信退款开始--------orderRefund]"+order.getOrderSn());
  3119. // WechatRefundApiResult result = WechatUtil.wxRefund(orderInfo.getOrderSn(), totalActualPrice,
  3120. // orderInfo.getActualPrice().doubleValue());
  3121. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_5.getItem()));
  3122. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  3123. //修改为退款成功
  3124. orderDao.update(order);
  3125. // 修改小票码
  3126. PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(order.getOrderSn());
  3127. pickUpCodeEntity.setPickUpCodeStatus("3");
  3128. pickUpCodeService.update(pickUpCodeEntity);
  3129. //新增退款记录
  3130. OrderRefundEntity orderRefund = orderRefundLog("wx453456511","wx453456566","26999",order.getId(),user.getUserId(),order.getMerchOrderSn());
  3131. //OrderRefundEntity orderRefund = orderRefundLog(result.getRefund_id(),result.getOut_trade_no(),result.getRefund_fee(),order.getId(),user.getUserId(),order.getMerchOrderSn());
  3132. orderRefundDao.save(orderRefund);
  3133. //还原库存,调用免税mall接口退款和积分回退接口
  3134. restoreInventoryMsMall(order);
  3135. }
  3136. // 支付宝的退款代码
  3137. } else if (Dict.payFlag.item_alipay.getItem().equals(payFlag)) {
  3138. LOGGER.info("[支付宝退款开始--------orderRefund]"+order.getOrderSn());
  3139. AliPayMicropayApiResult userRefund = AliPayUtil.aliTradeRefund(order.getOrderSn(), order.getActualPrice().toString(),
  3140. "用户退款", order.getStoreId() + "");
  3141. // 是否已退款校验
  3142. try {
  3143. String fundChange = userRefund.getFundChange();
  3144. if ("N".equals(fundChange)) {
  3145. return R.error("资金已退回,请勿重复退款!");
  3146. }
  3147. } catch (Exception e) {
  3148. LOGGER.error("[支付宝退款校验出错]",e.getMessage());
  3149. }
  3150. LOGGER.info(userRefund.getSubMsg());
  3151. order.setPayStatus(Integer.parseInt(Dict.payStatus.item_5.getItem()));
  3152. order.setOrderStatus(Integer.parseInt(Dict.orderStatus.item_401.getItem()));
  3153. //修改为退款成功
  3154. orderDao.update(order);
  3155. // 修改小票码
  3156. PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(order.getOrderSn());
  3157. pickUpCodeEntity.setPickUpCodeStatus("3");
  3158. pickUpCodeService.update(pickUpCodeEntity);
  3159. //新增退款记录
  3160. OrderRefundEntity orderRefund = orderRefundLog(userRefund.getTradeNo(),userRefund.getOutTradeNo(),userRefund.getRefundFee(),order.getId(),user.getUserId(),order.getMerchOrderSn());
  3161. orderRefundDao.save(orderRefund);
  3162. //还原库存,调用免税mall接口退款和积分回退接口
  3163. restoreInventoryMsMall(order);
  3164. }
  3165. //int ss = 1/0;
  3166. return R.ok("退款成功");
  3167. }
  3168. /**
  3169. * 新增退款记录
  3170. * @param refundId
  3171. * @param OutTradeNo
  3172. * @param refundFee
  3173. * @param orderId
  3174. * @param userId
  3175. * @param merchOrderSn
  3176. * @return
  3177. */
  3178. private OrderRefundEntity orderRefundLog(String refundId,String OutTradeNo,String refundFee,Long orderId,Long userId,String merchOrderSn){
  3179. OrderRefundEntity orderRefund = new OrderRefundEntity();
  3180. orderRefund.setRefundId(refundId);
  3181. orderRefund.setOutRefundNo(OutTradeNo);
  3182. orderRefund.setRefundMoney(BigDecimal.valueOf(Long.valueOf(refundFee)).divide(Constant.ONE_HUNDRED));
  3183. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_2.getItem()));//退款处理中
  3184. orderRefund.setModTime(new Date());
  3185. orderRefund.setRefundTime(new Date());
  3186. orderRefund.setOrderId(orderId.intValue());
  3187. orderRefund.setUserId(userId.intValue());
  3188. orderRefund.setRefundId(userId + "");
  3189. orderRefund.setCreateTime(new Date());
  3190. Integer sum = orderDao.queryObjectByMerchOrderSnHkMall(merchOrderSn);
  3191. if (sum > 1) {//多条订单
  3192. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_2.getItem()));//部分退款
  3193. } else {
  3194. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));//用户全额退款
  3195. }
  3196. orderRefund.setRestore(1);
  3197. return orderRefund;
  3198. }
  3199. /**
  3200. * 海控订单退款
  3201. * @param order
  3202. */
  3203. private void restoreInventoryMsMall(OrderEntity order) throws Exception{
  3204. Map<String, Object> map = new HashMap();
  3205. SysUserEntity user = ShiroUtils.getUserEntity();
  3206. map.put("orderId", order.getId());
  3207. //mall_order_goodsd,订单明细
  3208. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryListHkMall(map);
  3209. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  3210. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  3211. .queryByGoodsIdAndStoreIdHkMall(order.getStoreId().longValue(), orderGoodsEntity.getGoodsId().longValue());
  3212. if (null == storeRelaEntity || null == storeRelaEntity.getSellVolume()) {
  3213. storeRelaEntity.setSellVolume(0);
  3214. }
  3215. //销售量 - 商品数量
  3216. BigDecimal sellVolume = new BigDecimal(storeRelaEntity.getSellVolume() - orderGoodsEntity.getNumber());//销售量
  3217. if (sellVolume.compareTo(Constant.ZERO) < 0) {
  3218. sellVolume = Constant.ZERO;
  3219. }
  3220. GoodsEntity goodsEntity = goodsDao.queryObject(orderGoodsEntity.getGoodsId());
  3221. if (goodsEntity != null) {
  3222. //还原商户商品总库存
  3223. resetGoodsStockHkMall(order,goodsEntity.getGoodsNumber(), storeRelaEntity, orderGoodsEntity, user);
  3224. }
  3225. //还原门店库存
  3226. if (null != storeRelaEntity.getStockNum()) {
  3227. resetStoreGoodsStockMall(order,storeRelaEntity.getStockNum(), storeRelaEntity, orderGoodsEntity, sellVolume, user);
  3228. }
  3229. }
  3230. //调用免税mall接口
  3231. vmcShopMall(order);
  3232. //调用会员系统积分全量回退接口
  3233. vipIntegralGoBack(order);
  3234. }
  3235. /**
  3236. * 调用会员系统积分全量回退接口
  3237. * @param order
  3238. * @throws Exception
  3239. */
  3240. private void vipIntegralGoBack(OrderEntity order) throws Exception{
  3241. List<IntegralGoBackEntity> changeRecordEntityList = haiKongMemberScoreChangeRecordService.queryIntegralGoBack(order.getOrderSn());
  3242. for(IntegralGoBackEntity integralGoBackEntity:changeRecordEntityList) {
  3243. String integralGoBackEntityMsg = JSON.toJSONString(integralGoBackEntity);
  3244. Date dateResend = new Date();
  3245. String responseMsg = haiKongMemberTemplate.rollbackMemberScore(integralGoBackEntityMsg);
  3246. Map<String, Object> res = JSON.parseObject(responseMsg, Map.class);
  3247. LOGGER.info("=======> [vipIntegralGoBack-----调用会员系统积分全量回退接口数据]" + responseMsg);
  3248. //解析数据
  3249. if ("true".equals(res.get("success"))) {
  3250. LOGGER.info("=======> [vipIntegralGoBack-----调用会员系统积分全量回退接口数据]" + responseMsg);
  3251. } else {
  3252. LOGGER.error("=======> [vipIntegralGoBack-----调用会员系统积分全量回退接口异常数据]" + responseMsg);
  3253. HaiKongResendMsgEntity haiKongResendMsgEntity = new HaiKongResendMsgEntity();
  3254. haiKongResendMsgEntity.setOpenId(integralGoBackEntity.getOpen_id());
  3255. haiKongResendMsgEntity.setOrderSn(order.getOrderSn());
  3256. haiKongResendMsgEntity.setInterfaceType(HaiKongMemberSystemUrlEnum.ROLLBACK_MEMBER_SCORE.getUrl());
  3257. haiKongResendMsgEntity.setRequestMsg(JSON.toJSONString(integralGoBackEntity));
  3258. haiKongResendMsgEntity.setResponseMsg(responseMsg);
  3259. haiKongResendMsgEntity.setIsValid(1);
  3260. haiKongResendMsgDao.saveResendMsg(haiKongResendMsgEntity);
  3261. }
  3262. }
  3263. }
  3264. /**
  3265. *海控免税mall接口
  3266. * @param order
  3267. */
  3268. private void vmcShopMall(OrderEntity order) {
  3269. LOGGER.info("=======> [vmcShopMall-----调用VMCShop接口开始发送退款订单数据]"+order.getOrderSn());
  3270. String body = JacksonUtil.toJson(order.getOrderSn());
  3271. InterfaceSendLogEntity interfaceSendLogEntity = new InterfaceSendLogEntity();
  3272. interfaceSendLogEntity.setRequestDate(new Date());
  3273. interfaceSendLogEntity.setSysType(Dict.sendLog.item_mall.getItemName());
  3274. String response = vmcShopTemplate.refundOrder(body);
  3275. Date dateResend = new Date();
  3276. //解析响应数据
  3277. LOGGER.info("=======> [vmcShopMall------发送退款订单数据成功,开始处理后续流程]"+response);
  3278. Map<String,String> res = JSON.parseObject(response,Map.class);
  3279. interfaceSendLogEntity.setMsgStatus(res.get("code"));
  3280. LOGGER.info(order.getOrderSn()+"[发送退款订单数据]"+JSON.toJSONString(order));
  3281. }
  3282. @Transactional
  3283. public void toBeRestoreInventory(OrderEntity order) {
  3284. Map<String, Object> map = new HashMap();
  3285. SysUserEntity user = ShiroUtils.getUserEntity();
  3286. map.put("orderId", order.getId());
  3287. List<OrderGoodsEntity> orderGoodsVoList = orderGoodsDao.queryList(map);
  3288. for (OrderGoodsEntity orderGoodsEntity : orderGoodsVoList) {
  3289. // 当前订单商品数量
  3290. Integer restoreNumber = orderGoodsEntity.getNumber();
  3291. ProductStoreRelaEntity storeRelaEntity = productStoreRelaDao
  3292. .queryByGoodsIdAndStoreId(order.getStoreId().longValue(), orderGoodsEntity.getGoodsId().longValue());
  3293. Integer toBeRestored = storeRelaEntity.getToBeRestored();
  3294. if (toBeRestored == null) {
  3295. toBeRestored = 0;
  3296. }
  3297. // 修改门店商品待退款的数量 = 当前订单商品数量 + 门店待退款数量
  3298. storeRelaEntity.setToBeRestored(toBeRestored + restoreNumber);
  3299. GoodsEntity goodsEntity = goodsDao.queryObject(orderGoodsEntity.getGoodsId());
  3300. toBeRestored = goodsEntity.getToBeRestored();
  3301. if (toBeRestored == null) {
  3302. toBeRestored = 0;
  3303. }
  3304. goodsEntity.setToBeRestored(toBeRestored + restoreNumber);
  3305. productStoreRelaDao.update(storeRelaEntity);
  3306. goodsDao.update(goodsEntity);
  3307. }
  3308. }
  3309. /**
  3310. * 查询oms系统是否有该订单
  3311. *
  3312. * @param orderSn
  3313. * @return
  3314. */
  3315. private boolean arrivedOms(String orderSn) {
  3316. Map<String, String> sParaTemp = new TreeMap<String, String>();
  3317. // sParaTemp.put("data","ZWCW2020122749351849");
  3318. sParaTemp.put("data", orderSn);
  3319. sParaTemp.put("merchId", omsMerchProperties.getMerchSn());
  3320. String timestamp = String.valueOf(System.currentTimeMillis() / 1000);
  3321. sParaTemp.put("timestamp", timestamp);
  3322. //生成要请求给oms秘钥
  3323. // String sign = OmsSign.sign(sParaTemp,cus.getWaybill().get("secret-key"));
  3324. LOGGER.info("md5混淆码参数:" + omsMerchProperties.getMd5Salt());
  3325. String sign = OmsSign.sign(sParaTemp, omsMerchProperties.getMd5Salt());
  3326. sParaTemp.put("sign", sign);
  3327. //构建Request
  3328. String url = omsMerchProperties.getQueryInveResponseUrl();
  3329. Request request = com.kmall.admin.utils.oms.OkHttpUtils.buildRequest(url, JSON.toJSONString(sParaTemp));
  3330. LOGGER.info("oms的请求报文:" + request);
  3331. // 同步访问,返回结果字符串
  3332. String responseString = null;
  3333. try {
  3334. responseString = com.kmall.admin.utils.oms.OkHttpUtils.post(request);
  3335. } catch (Exception e) {
  3336. e.printStackTrace();
  3337. }
  3338. LOGGER.info("oms的响应报文" + responseString);
  3339. //解析响应数据
  3340. Gson gson = new Gson();
  3341. ResponseMessage result = gson.fromJson(responseString, ResponseMessage.class);
  3342. if (result == null) {
  3343. String info = "解析响应数据Result失败";
  3344. LOGGER.error("--- {}", info);
  3345. throw new RuntimeException(info);
  3346. }
  3347. if ("oms无该订单".equals(result.getMsg())) {
  3348. return false;
  3349. }
  3350. return true;
  3351. }
  3352. private String wxRefund(OrderEntity orderInfo, Double totalActualPrice) {
  3353. WechatRefundApiResult result = WechatUtil.wxRefund(orderInfo.getOrderSn().toString(), totalActualPrice,
  3354. orderInfo.getActualPrice().doubleValue());
  3355. if (result.getResult_code().equals(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  3356. refund(orderInfo, result);
  3357. } else {
  3358. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  3359. OrderRefundEntity orderRefund = new OrderRefundEntity();
  3360. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  3361. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  3362. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  3363. SysUserEntity user = ShiroUtils.getUserEntity();
  3364. orderRefund.setModerSn(user.getUsername());
  3365. orderRefund.setModTime(new Date());
  3366. // orderRefund.setOutRefundNo(result.getOut_refund_no());
  3367. if (mallOrderRefund != null) {
  3368. orderRefund.setId(mallOrderRefund.getId());
  3369. orderRefundService.update(orderRefund);//退款记录
  3370. }
  3371. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  3372. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  3373. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  3374. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  3375. mallOrderExceptionRecord.setExceptionContent("退款失败" + result.getErr_code_des());
  3376. mallOrderExceptionRecord.setCreateTime(new Date());
  3377. orderExceptionRecordService.save(mallOrderExceptionRecord);
  3378. return result.getErr_code_des();
  3379. }
  3380. return "";
  3381. }
  3382. @Override
  3383. public int queryOffilineOrderTotal(Query query) {
  3384. return orderDao.queryOffilineOrderTotal(query);
  3385. }
  3386. @Override
  3387. public List<PurchaseSalesInStockDetail> purchaseSalesInStockDetailList(Query query) {
  3388. return orderDao.purchaseSalesInStockDetailList(query);
  3389. }
  3390. @Override
  3391. public int purchaseSalesInStockDetailTotal(Query query) {
  3392. return orderDao.purchaseSalesInStockDetailTotal(query);
  3393. }
  3394. @Override
  3395. public List<OrderEntity> queryExportOffilineOrderList(Map<String, Object> params) {
  3396. List<OrderEntity> orderEntityList = orderDao.queryExportOffilineOrderList(params);
  3397. // if (orderEntityList!=null && orderEntityList.size()>0){
  3398. // for (OrderEntity orderEntity : orderEntityList) {
  3399. // // 查询活动价
  3400. // BigDecimal topicPrice = orderDao.queryTopicPriceByOrderSnAndSku(orderEntity.getOrderSn(),orderEntity.getSku());
  3401. // orderEntity.setTopicPrice(topicPrice);
  3402. // }
  3403. // }
  3404. return orderEntityList;
  3405. }
  3406. @Override
  3407. public List<OrderEntity> queryMasterExportOffilineOrderList(Map<String, Object> params) {
  3408. return orderDao.queryMasterExportOffilineOrderList(params);
  3409. }
  3410. @Override
  3411. public List<OrderEntity> queryMasterExportList(Map<String, Object> params) {
  3412. return orderDao.queryMasterExportList(params);
  3413. }
  3414. @Override
  3415. public List<SystemFormatDto> queryExportSystemFormatList(Map<String, Object> params) {
  3416. List<SystemFormatDto> systemFormatList = orderDao.queryExportSystemFormatList(params);
  3417. return systemFormatList;
  3418. }
  3419. @Override
  3420. public List<OrderEntity> queryLastDayOrder(String comparedDate) {
  3421. Map<String, Object> map = new HashMap<>();
  3422. //
  3423. // DateFormat dateFmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//格式化一下时间
  3424. //
  3425. // Date dNow = new Date(); //当前时间
  3426. //
  3427. // Date dBefore = new Date();
  3428. //
  3429. // Calendar calendar = Calendar.getInstance(); //得到日历
  3430. //
  3431. // calendar.setTime(dNow);//把当前时间赋给日历
  3432. //
  3433. // calendar.add(Calendar.DAY_OF_MONTH, -1); //设置为前一天
  3434. //
  3435. // dBefore = calendar.getTime(); //得到前一天的时间
  3436. String defaultStartDate = comparedDate + " 00:00:00";
  3437. String defaultEndDate = comparedDate + " 23:59:59";
  3438. map.put("startTime", defaultStartDate);
  3439. map.put("endTime", defaultEndDate);
  3440. return orderDao.queryOffilineOrderList(map);
  3441. }
  3442. /**
  3443. * 查询CW保税+新零售销售报表第一个sheet
  3444. *
  3445. * @param billDate
  3446. * @param storeId
  3447. * @return
  3448. */
  3449. @Override
  3450. public ExportExcelDto querySumAmount(String billDate, String storeId) {
  3451. ExportExcelDto exportExcelDto = new ExportExcelDto();
  3452. ExportExcelDto totalAmount = orderDao.totalAmount(billDate, storeId);
  3453. ExportExcelDto refundCurrentAmount = orderDao.refundCurrentAmount(billDate, storeId);
  3454. ExportExcelDto refundPreviousAmount = orderDao.refundPreviousAmount(billDate, storeId);
  3455. ExportExcelDto currentTax = orderDao.currentTax(billDate, storeId);
  3456. ExportExcelDto refundPreviousTax = orderDao.refundPreviousTax(billDate, storeId);
  3457. // 以下是直接从数据库中查出来的
  3458. exportExcelDto.setTotalAmount(totalAmount.getTotalAmount()); // 总销售额
  3459. exportExcelDto.setTotalCount(totalAmount.getTotalCount()); // 总销售数
  3460. exportExcelDto.setRefundCurrentAmount(refundCurrentAmount.getRefundCurrentAmount()); // 当期退款额
  3461. exportExcelDto.setRefundCurrentCount(refundCurrentAmount.getRefundCurrentCount()); // 当期退款数
  3462. exportExcelDto.setRefundPreviousAmount(refundPreviousAmount.getRefundPreviousAmount()); // 退前期销售额
  3463. exportExcelDto.setRefundPreviousCount(refundPreviousAmount.getRefundPreviousCount()); // 退前期销售数
  3464. exportExcelDto.setCurrentTax(currentTax.getCurrentTax()); // 当前税额
  3465. exportExcelDto.setPreviousTax(refundPreviousTax.getPreviousTax()); // 前期税额
  3466. // 以下是通过计算的出来的
  3467. // 销售净额
  3468. exportExcelDto.setNetAmount(new BigDecimal(exportExcelDto.getTotalAmount()).subtract(new BigDecimal(exportExcelDto.getRefundPreviousAmount())).setScale(2, RoundingMode.HALF_UP).toString());
  3469. // 总税额
  3470. exportExcelDto.setTotalTax(new BigDecimal(exportExcelDto.getCurrentTax()).add(new BigDecimal(exportExcelDto.getPreviousTax())).setScale(2, RoundingMode.HALF_UP).toString());
  3471. // 税前总额
  3472. exportExcelDto.setPreTaxTotalAmount(new BigDecimal(exportExcelDto.getNetAmount()).subtract(new BigDecimal(exportExcelDto.getTotalTax())).setScale(2, RoundingMode.HALF_UP).toString());
  3473. // 成功单数
  3474. exportExcelDto.setSuccessNumber(new BigDecimal(exportExcelDto.getTotalCount()).subtract(new BigDecimal(exportExcelDto.getRefundPreviousCount())).setScale(2, RoundingMode.HALF_UP).toString());
  3475. // 退款总额
  3476. exportExcelDto.setRefundAmount(new BigDecimal(exportExcelDto.getRefundCurrentAmount()).add(new BigDecimal(exportExcelDto.getRefundPreviousAmount())).setScale(2, RoundingMode.HALF_UP).toString());
  3477. // 退单单数
  3478. exportExcelDto.setRefundCount(new BigDecimal(exportExcelDto.getRefundCurrentCount()).add(new BigDecimal(exportExcelDto.getRefundPreviousCount())).setScale(2, RoundingMode.HALF_UP).toString());
  3479. return exportExcelDto;
  3480. }
  3481. @Override
  3482. public Map<String, List<OrderEntity>> querySaleOrderList(String billDate, String storeId) {
  3483. Map<String, List<OrderEntity>> result = new HashMap<>();
  3484. // 查询当天所有订单
  3485. List<OrderEntity> orderEntityList = orderDao.queryCurrentPreviousOrderList(billDate, storeId);
  3486. result.put("current", orderEntityList);
  3487. // 查询当天退前期订单
  3488. List<OrderEntity> refundPreviousOrderList = orderDao.queryRefundPreviousOrderList(billDate, storeId);
  3489. result.put("previous", refundPreviousOrderList);
  3490. return result;
  3491. }
  3492. @Override
  3493. public Map<String, List<TaxDetailDto>> queryTaxDetailList(String billDate, String storeId) {
  3494. Map<String, List<TaxDetailDto>> result = new HashMap<>();
  3495. // 查询当天所有订单税单
  3496. List<TaxDetailDto> taxDetailList = orderDao.queryCurrentTaxDetailList(billDate, storeId);
  3497. // 计算税前价,增值税,消费税
  3498. BigDecimal discountRate = new BigDecimal(0.7);
  3499. if (taxDetailList != null && taxDetailList.size() != 0) {
  3500. for (TaxDetailDto taxDetailDto : taxDetailList) {
  3501. // 获取实际支付价格
  3502. String postTaxPrice = taxDetailDto.getPostTaxPrice();
  3503. // 获取总税额
  3504. String taxStr = taxDetailDto.getTax();
  3505. // 税前金额
  3506. BigDecimal tax = new BigDecimal(taxStr);
  3507. BigDecimal pretaxPrice = new BigDecimal(postTaxPrice).subtract(tax).setScale(2, RoundingMode.HALF_UP);
  3508. // 计算综合税率
  3509. BigDecimal taxRate = tax.divide(pretaxPrice, 4, RoundingMode.HALF_UP);
  3510. // 消费税率
  3511. BigDecimal saleTaxRate = new BigDecimal(taxDetailDto.getSaleTaxRate()).divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
  3512. // 综合税率
  3513. BigDecimal vatRate = new BigDecimal(taxDetailDto.getVatRate()).divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
  3514. // 消费税 = (明细商品总价 / (1-消费税税率)) * 消费税税率
  3515. // 增值税 = (明细商品总价 + 消费税) * 增值税税率
  3516. // 订单该商品总税费 = (商品消费税 + 商品增值税)* 0.7
  3517. // 如果大于,要算消费税
  3518. BigDecimal saleTax = new BigDecimal(0);
  3519. BigDecimal vat = new BigDecimal(0);
  3520. if (taxRate.compareTo(new BigDecimal("0.23")) > 0) {
  3521. saleTax = pretaxPrice.divide(new BigDecimal(1).subtract(saleTaxRate), 2, RoundingMode.HALF_UP).multiply(saleTaxRate).
  3522. setScale(2, RoundingMode.HALF_UP);
  3523. vat = pretaxPrice.add(saleTax).multiply(vatRate).
  3524. multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3525. saleTax = saleTax.multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3526. } else {
  3527. // 不需要算消费税,增值税计算
  3528. vat = pretaxPrice.multiply(vatRate).multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3529. }
  3530. taxDetailDto.setSaleTax(saleTax.toString());
  3531. taxDetailDto.setVat(vat.toString());
  3532. }
  3533. }
  3534. result.put("current", taxDetailList);
  3535. // 查询当天退前期订单税单
  3536. List<TaxDetailDto> refundPrevioustaxDetailList = orderDao.queryRefundPreviousTaxDetailList(billDate, storeId);
  3537. // 计算税前价,增值税,消费税
  3538. if (refundPrevioustaxDetailList != null && refundPrevioustaxDetailList.size() != 0) {
  3539. for (TaxDetailDto taxDetailDto : refundPrevioustaxDetailList) {
  3540. // 获取实际支付价格
  3541. String postTaxPrice = taxDetailDto.getPostTaxPrice();
  3542. // 获取总税额
  3543. String taxStr = taxDetailDto.getPreTax();
  3544. // 税前金额
  3545. BigDecimal tax = new BigDecimal(taxStr);
  3546. BigDecimal pretaxPrice = new BigDecimal(postTaxPrice).subtract(tax).setScale(2, RoundingMode.HALF_UP);
  3547. // 计算综合税率
  3548. BigDecimal taxRate = tax.divide(pretaxPrice, 4, RoundingMode.HALF_UP);
  3549. // 消费税率
  3550. BigDecimal saleTaxRate = new BigDecimal(taxDetailDto.getPreSaleTax()).divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
  3551. // 综合税率
  3552. BigDecimal vatRate = new BigDecimal(taxDetailDto.getPreVat()).divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
  3553. // 消费税 = (明细商品总价 / (1-消费税税率)) * 消费税税率
  3554. // 增值税 = (明细商品总价 + 消费税) * 增值税税率
  3555. // 订单该商品总税费 = (商品消费税 + 商品增值税)* 0.7
  3556. // 如果大于,要算消费税
  3557. BigDecimal saleTax = new BigDecimal(0);
  3558. BigDecimal vat = new BigDecimal(0);
  3559. if (taxRate.compareTo(new BigDecimal("0.23")) > 0) {
  3560. saleTax = pretaxPrice.divide(new BigDecimal(1).subtract(saleTaxRate), 2, RoundingMode.HALF_UP).multiply(saleTaxRate).
  3561. multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3562. vat = pretaxPrice.add(saleTax).multiply(vatRate).
  3563. multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3564. } else {
  3565. // 不需要算消费税,增值税计算
  3566. vat = pretaxPrice.multiply(vatRate).multiply(discountRate).setScale(2, RoundingMode.HALF_UP);
  3567. }
  3568. taxDetailDto.setPreSaleTax(saleTax.compareTo(BigDecimal.ZERO) == 0 ? saleTax.toString() : "-" + saleTax.toString());
  3569. taxDetailDto.setPreVat(vat.compareTo(BigDecimal.ZERO) == 0 ? vat.toString() : "-" + vat.toString());
  3570. }
  3571. }
  3572. result.put("previous", refundPrevioustaxDetailList);
  3573. return result;
  3574. }
  3575. @Override
  3576. public List<String> queryInveResponse(String orderSn) throws IOException {
  3577. Map<String, String> sParaTemp = new TreeMap<String, String>();
  3578. sParaTemp.put("data", orderSn);
  3579. sParaTemp.put("merchId", omsMerchProperties.getMerchSn());
  3580. String timestamp = String.valueOf(System.currentTimeMillis() / 1000);
  3581. sParaTemp.put("timestamp", timestamp);
  3582. //生成要请求给oms秘钥
  3583. // String sign = OmsSign.sign(sParaTemp,cus.getWaybill().get("secret-key"));
  3584. LOGGER.info("md5混淆码参数:" + omsMerchProperties.getMd5Salt());
  3585. String sign = OmsSign.sign(sParaTemp, omsMerchProperties.getMd5Salt());
  3586. sParaTemp.put("sign", sign);
  3587. //构建Request
  3588. String url = omsMerchProperties.getQueryInveResponseUrl();
  3589. Request request = com.kmall.admin.utils.oms.OkHttpUtils.buildRequest(url, JSON.toJSONString(sParaTemp));
  3590. LOGGER.info("oms的请求报文:" + request);
  3591. // 同步访问,返回结果字符串
  3592. String responseString = null;
  3593. try {
  3594. responseString = com.kmall.admin.utils.oms.OkHttpUtils.post(request);
  3595. } catch (Exception e) {
  3596. e.printStackTrace();
  3597. throw e;
  3598. }
  3599. LOGGER.info("oms的响应报文" + responseString);
  3600. //解析响应数据
  3601. Gson gson = new Gson();
  3602. ResponseMessage result = gson.fromJson(responseString, ResponseMessage.class);
  3603. if (result == null) {
  3604. String info = "解析响应数据Result失败";
  3605. LOGGER.error("--- {}", info);
  3606. throw new RuntimeException(info);
  3607. }
  3608. ResponseMessageData data = result.getData();
  3609. List rows = data.getRows();
  3610. List<String> resultMessage = new LinkedList<>();
  3611. for (Object row : rows) {
  3612. if (row instanceof ArrayList) {
  3613. for (Object o : ((ArrayList<?>) row)) {
  3614. if (o instanceof LinkedTreeMap) {
  3615. String cusReturnInfo = (String) ((LinkedTreeMap<?, ?>) o).get("cusReturnInfo");
  3616. resultMessage.add(cusReturnInfo);
  3617. }
  3618. }
  3619. }
  3620. }
  3621. // cusReturnInfo -> [Code:2600;Desc:放行]
  3622. return resultMessage;
  3623. }
  3624. /**
  3625. * 查询所有状态为201的订单。且下单时间超过5分钟的订单
  3626. *
  3627. * @return
  3628. */
  3629. @Override
  3630. public List<OrderEntity> queryAll201Order() {
  3631. SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
  3632. String date = format.format(new Date());
  3633. return orderDao.queryAll201Order(date);
  3634. }
  3635. /**
  3636. * 恢复kmall退单冻结的库存
  3637. *
  3638. * @param orderSn
  3639. */
  3640. @Override
  3641. @Transactional
  3642. public void toBeRestored(String orderSn) {
  3643. // 查询该订单在库存是否已经释放过,避免重复恢复库存
  3644. OrderEntity orderInfo = orderDao.queryObjectByOrderSn(orderSn);
  3645. OrderRefundEntity orderRefundEntity = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  3646. if (orderRefundEntity == null) {
  3647. LOGGER.error("该订单无退款记录,订单号{}", orderSn);
  3648. throw new RuntimeException("该订单无退款记录,订单号:" + orderSn);
  3649. }
  3650. Integer restore = orderRefundEntity.getRestore();
  3651. if (restore == 1) {
  3652. LOGGER.error("该订单库存记录已恢复过,订单号{}", orderSn);
  3653. throw new RuntimeException("该订单库存记录已恢复过,订单号:" + orderSn);
  3654. }
  3655. restoreInventory(orderInfo, "oms退单成功,恢复库存");
  3656. orderRefundEntity.setRestore(1);
  3657. orderRefundService.update(orderRefundEntity);
  3658. }
  3659. @Override
  3660. public Ticket printMsgEwb(long id, String sessionId) {
  3661. OrderEntity orderEntity = queryInfos(id);
  3662. List<OrderGoodsEntity> orderGoodsEntityList = orderEntity.getOrderGoodsEntityList();
  3663. // 获取门店
  3664. StoreEntity storeEntity = storeDao.queryObject(orderEntity.getStoreId());
  3665. // 获取清关信息
  3666. OrderProcessRecordEntity orderProcessRecordEntity =
  3667. orderProcessRecordDao.queryObjectByOrderSn(orderEntity.getOrderSn());
  3668. // 小票头
  3669. TicketHead head = new TicketHead();
  3670. head.setTitle(storeEntity.getStoreName());
  3671. //门店地址
  3672. head.setStoreAddress(storeEntity.getStoreAddress());
  3673. // head.setMemberId(orderEntity.getUserName().toString());
  3674. head.setOrderId(orderEntity.getOrderSn());
  3675. head.setTradeTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss EEE").format(orderEntity.getPayTime()));
  3676. // 商品信息
  3677. Integer goodsTotal = 0; // 商品总个数
  3678. BigDecimal total = Constant.ZERO; // 商品总计
  3679. BigDecimal taxTotal = Constant.ZERO; //税费总计
  3680. List<Goods> goodsList = new ArrayList<>();
  3681. BigDecimal discountedPrice = Constant.ZERO; // 优惠金额
  3682. for (OrderGoodsEntity orderGoods : orderGoodsEntityList) {
  3683. goodsTotal += orderGoods.getNumber();
  3684. total = total.add(orderGoods.getRetailPrice().multiply(new BigDecimal(orderGoods.getNumber())))
  3685. .setScale(2, BigDecimal.ROUND_HALF_UP);
  3686. discountedPrice = discountedPrice.add(orderGoods.getDiscountedPrice());
  3687. GoodsEntity goodsEntity = goodsService.queryObject(orderGoods.getGoodsId());
  3688. BigDecimal goodsTax = CalculateTax.calculateFinalTax(goodsEntity, orderGoods.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  3689. goodsTax = goodsTax.multiply(new BigDecimal(orderGoods.getNumber())).setScale(2, RoundingMode.HALF_UP);
  3690. taxTotal = taxTotal.add(goodsTax).setScale(2, RoundingMode.HALF_UP);
  3691. Goods goods = new Goods(orderGoods.getGoodsName(),
  3692. orderGoods.getRetailPrice().toString(), // 含税价
  3693. // beforeTaxPrice.toString(),// 税前价
  3694. goodsTax.toString(),
  3695. orderGoods.getNumber().toString(),
  3696. new BigDecimal(orderGoods.getNumber()).multiply(orderGoods.getRetailPrice()).setScale(2, RoundingMode.HALF_UP).toString(),
  3697. orderGoods.getDiscountedPrice().toString());
  3698. goodsList.add(goods);
  3699. }
  3700. // 收银信息
  3701. CashInfo cashInfo = new CashInfo();
  3702. cashInfo.setGoodsTotal(goodsTotal.toString());
  3703. cashInfo.setTotal(total.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  3704. cashInfo.setTaxTotal(taxTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  3705. cashInfo.setReceipts(orderEntity.getActualPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  3706. cashInfo.setOddChange(discountedPrice.toString());
  3707. cashInfo.setCoupon(orderEntity.getCouponPrice().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  3708. cashInfo.setFreight(
  3709. new BigDecimal(orderEntity.getFreightPrice()).setScale(2, BigDecimal.ROUND_HALF_UP).toString());
  3710. if ("alipay".equals(orderEntity.getPayFlag())) {
  3711. cashInfo.setPaymentMode("支付宝支付");
  3712. } else {
  3713. cashInfo.setPaymentMode("微信支付");
  3714. }
  3715. // 海关清单
  3716. CusListing cusListing = new CusListing();
  3717. cusListing.setOrderId(orderEntity.getOrderSn());
  3718. if (!orderEntity.getOrderBizType().equalsIgnoreCase(Dict.orderBizType.item_11.getItem())) {
  3719. cusListing.setWaybillId(orderProcessRecordEntity.getLogisticsNo());
  3720. cusListing.setInvtNo(orderProcessRecordEntity.getInvtNo()==null?"":orderProcessRecordEntity.getInvtNo());
  3721. cusListing.setConsignee(orderEntity.getConsignee());
  3722. // 脱敏设置
  3723. if (StringUtils.isNotEmpty(cusListing.getConsignee()) && cusListing.getConsignee().length() > 1) {
  3724. cusListing.setConsignee(new StringBuilder(cusListing.getConsignee()).replace(1, 2, "*").toString());
  3725. }
  3726. cusListing.setConsigneeTel(orderEntity.getMobile());
  3727. if (StringUtils.isNotEmpty(cusListing.getConsigneeTel())) {
  3728. cusListing.setConsigneeTel(new StringBuilder(cusListing.getConsigneeTel()).replace(3, 7, "****").toString());
  3729. }
  3730. }
  3731. cusListing.setOriginAddress(PrintTicketPropertiesBuilder.instance().getAddress());
  3732. cusListing.setDeliveryAddress(storeEntity.getStoreAddress());
  3733. // 尝试在取货码表中查询数据,如果有的话就改变状态
  3734. // String orderSn = orderEntity.getOrderSn();
  3735. // PickUpCodeEntity pickUpCodeEntity = pickUpCodeService.queryObject(orderSn);
  3736. // if (pickUpCodeEntity != null) {
  3737. // pickUpCodeEntity.setPickUpCodeStatus("0");
  3738. // pickUpCodeService.update(pickUpCodeEntity);
  3739. //
  3740. // }
  3741. TicketMailInfo mailInfo = new TicketMailInfo();
  3742. String exprNo = orderProcessRecordEntity.getLogisticsNo();
  3743. if (StringUtils.isNullOrEmpty(exprNo)) {
  3744. throw new RRException("快递面单为空,请联系客服");
  3745. }
  3746. //图片地址
  3747. mailInfo.setStoreImgUrl(storeEntity.getStoreImgUrl()==null?"/statics/img/cw_qrcode.png":storeEntity.getStoreImgUrl().trim());
  3748. mailInfo.setExprNo(exprNo);
  3749. String logoUrl = "/statics/img/sf_img.jpg";
  3750. Map<String, String> logoMap = new HashMap<>();
  3751. logoMap.put("yto", "/statics/img/yto_logo.jpg");
  3752. logoMap.put("best", "/statics/img/bestex_logo3.png");
  3753. logoMap.put("sf", "/statics/img/sf_img.jpg");
  3754. if (StringUtils.isNotEmpty(orderEntity.getShippingCode()) && logoMap.containsKey(orderEntity.getShippingCode())) {
  3755. logoUrl = logoMap.get(orderEntity.getShippingCode());
  3756. }
  3757. mailInfo.setExprLogoUrl(logoUrl);
  3758. byte[] barCode128 = BarcodeUtil.generateBarCode128(exprNo, 6.0D, null, true, false);
  3759. String exprNoBase64Img = new String(Base64.getEncoder().encode(barCode128));
  3760. mailInfo.setShopTel(storeEntity.getTelephoneNumber());
  3761. AddressEntity addressEntity = addressDao.queryStoreAddress(storeEntity.getId(),Dict.addressStatus.item_1.getItem());
  3762. // 发货人
  3763. mailInfo.setSenderTel(addressEntity.getTelNumber());
  3764. mailInfo.setSenderName("CW澳洲大药房");
  3765. mailInfo.setSenderProvince(addressEntity.getProvinceName());
  3766. mailInfo.setSenderCity(addressEntity.getCityName());
  3767. mailInfo.setSenderDistrict(addressEntity.getCountyName());
  3768. mailInfo.setSenderAddress(addressEntity.getDetailInfo());
  3769. // 收货人
  3770. mailInfo.setConsigneeMob(new StringBuilder(orderEntity.getMobile()).replace(3, 7, "****").toString());
  3771. mailInfo.setConsigneeName(new StringBuilder(orderEntity.getConsignee()).replace(1, 2, "*").toString());
  3772. mailInfo.setConsigneeProvince(orderEntity.getProvince());
  3773. mailInfo.setConsigneeCity(orderEntity.getCity());
  3774. mailInfo.setConsigneeDistrict(orderEntity.getDistrict());
  3775. mailInfo.setConsigneeAddress(orderEntity.getAddress());
  3776. mailInfo.setExprNoBase64Img(exprNoBase64Img);
  3777. return TicketPrintUtil.print(head, goodsList, cashInfo, cusListing, mailInfo);
  3778. }
  3779. /**
  3780. * 计算优惠价格,活动价格
  3781. *
  3782. * @param calculateOrderDiscountPriceVo 请求参数
  3783. * @return 商品集合
  3784. */
  3785. @Override
  3786. public CalculateOrderDiscountPriceResponseVO calculateOrderDiscountPrice(CalculateOrderDiscountPriceVO calculateOrderDiscountPriceVo) {
  3787. if (Objects.isNull(calculateOrderDiscountPriceVo)) {
  3788. LOGGER.error("计算活动优惠价格,请求参数为null!");
  3789. throw new ServiceException("计算活动优惠价格,请求参数为null!");
  3790. }
  3791. CalculateOrderDiscountPriceResponseVO calculateOrderDiscountPriceResponseVO = new CalculateOrderDiscountPriceResponseVO();
  3792. String storeId = calculateOrderDiscountPriceVo.getStoreId();
  3793. String memberCode = calculateOrderDiscountPriceVo.getMemberCode();
  3794. calculateOrderDiscountPriceResponseVO.setMemberCode(memberCode);
  3795. List<GoodsDetailsDto> goodsDetailsDtos = calculateOrderDiscountPriceVo.getGoodsList();
  3796. BigDecimal orderTotalPrice = BigDecimal.ZERO;
  3797. List<QueryGoodsVO> goodsVos = new ArrayList<>();
  3798. for (GoodsDetailsDto good : goodsDetailsDtos) {
  3799. QueryGoodsVO queryGoodsVo = new QueryGoodsVO();
  3800. BeanUtils.copyProperties(good, queryGoodsVo);
  3801. queryGoodsVo.setSku(good.getGoodsSn());
  3802. queryGoodsVo.setStoreId(Long.parseLong(storeId));
  3803. queryGoodsVo.setDisCountedPrice(BigDecimal.ZERO);
  3804. queryGoodsVo.setTotalPrice(good.getActualPaymentAmount());
  3805. orderTotalPrice = orderTotalPrice.add(good.getActualPaymentAmount());
  3806. goodsVos.add(queryGoodsVo);
  3807. }
  3808. calculateOrderDiscountPriceResponseVO.setOrderTotalPrice(orderTotalPrice);
  3809. calculateOrderDiscountPriceResponseVO.setGoodsDetailsDtos(goodsDetailsDtos);
  3810. // 查询商品表
  3811. List<GoodsEntity> goodsEntities = goodsService.queryGoodsStockByQueryGoodsVoList(goodsVos);
  3812. /*
  3813. * 2.查询当前时间,该门店是否有活动,如果有活动,查询开启了哪些营销方式
  3814. * 参数: 当前时间 门店id
  3815. */
  3816. List<MkActivitiesEntity> mkActivitiesEntityList = mkActivitiesService.queryByNow(storeId, DateUtils.format(new Date(), "yyyy-MM-dd"));
  3817. // 活动优先级判定,特价>打折>满减/满赠>优惠券>积分抵扣;
  3818. // List<Constants.ActivityTopicEnum> activityTopicEnums = Arrays.asList(Constants.ActivityTopicEnum.values());
  3819. // for (MkActivitiesEntity mkActivitiesEntity : mkActivitiesEntityList) {
  3820. // for (Constants.ActivityTopicEnum activityTopicEnum : activityTopicEnums) {
  3821. // if (activityTopicEnum.get) {
  3822. //
  3823. // }
  3824. // }
  3825. // }
  3826. /*
  3827. * 活动相关规则:
  3828. * 1. 优先优惠券再去计算积分
  3829. * 2. 满赠的赠品商品在推送订单时零售价为0
  3830. * 3. 任何活动都优先于积分计算
  3831. * 4. 活动之间具有互斥性
  3832. */
  3833. if (CollectionUtils.isEmpty(mkActivitiesEntityList) && org.springframework.util.StringUtils.isEmpty(memberCode)) {
  3834. LOGGER.info("门店【{}】,在当前时间无相关活动信息!", storeId);
  3835. for (GoodsDetailsDto goodsDetailsDto : goodsDetailsDtos) {
  3836. GoodsEntity goodsEntity = new GoodsEntity();
  3837. BeanUtils.copyProperties(goodsDetailsDto, goodsEntity);
  3838. goodsEntity.setGoodsRate(new BigDecimal(goodsDetailsDto.getGoodsRate()));
  3839. // 无活动情况,实际支付价 = 零售价
  3840. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity , goodsEntity.getRetailPrice(), goodsService).setScale(3,RoundingMode.HALF_UP);
  3841. // 预估税
  3842. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  3843. }
  3844. calculateOrderDiscountPriceResponseVO.setGoodsDetailsDtos(goodsDetailsDtos);
  3845. return calculateOrderDiscountPriceResponseVO;
  3846. }
  3847. List<Integer> brandIdList = goodsEntities.stream().map(GoodsEntity::getBrandId).collect(Collectors.toList());
  3848. List<Integer> categoryIdList = goodsEntities.stream().map(GoodsEntity::getCategoryId).collect(Collectors.toList());
  3849. // 活动互斥标识
  3850. AtomicBoolean activityFlag = new AtomicBoolean(true);
  3851. // 限时特价活动标识
  3852. AtomicBoolean promotionActivityFlag = new AtomicBoolean(false);
  3853. // 与积分抵扣互斥的sku
  3854. List<String> promotionSkuList = new ArrayList<>();
  3855. // 判断活动类型并排序,再确定购物栏中商品是否满足活动条件
  3856. mkActivitiesEntityList.stream().sorted().forEach(mkActivitiesEntity -> {
  3857. String mkaStoreId = mkActivitiesEntity.getMkaStoreId();
  3858. Long mkaId = mkActivitiesEntity.getMkaId();
  3859. String mkaTopic = mkActivitiesEntity.getMkaTopic();
  3860. if (org.springframework.util.StringUtils.isEmpty(mkaTopic)) {
  3861. LOGGER.error("活动主题为空!请检查活动设置!");
  3862. throw new ServiceException("价活动主题为空!请检查活动设置!");
  3863. }
  3864. Constants.ActivityTopicEnum activityTopicEnum = Constants.ActivityTopicEnum.valueOf(mkaTopic.toUpperCase());
  3865. // 活动之间的优先级:特价>打折>满减/满赠>优惠券>积分抵扣
  3866. if (activityTopicEnum == Constants.ActivityTopicEnum.LSCX && activityFlag.get()) {
  3867. // 判断商品是否符合限时特价活动要求
  3868. List<MkActivitiesPromotionEntity> mkActivitiesPromotionEntities = mkActivitiesPromotionService.queryListByMkaIdAndStoreId(mkaId.intValue(), storeId);
  3869. if (CollectionUtils.isEmpty(mkActivitiesPromotionEntities)) {
  3870. LOGGER.error("查询临时促销活动信息结果为空!mka_id:{}, store_id:{}", mkaId, storeId);
  3871. }
  3872. // 限时特价,直接替换实际支付价即可,并且拿特价计算税款
  3873. mkActivitiesPromotionEntities.forEach(mkActivitiesPromotionEntity -> {
  3874. String entityBarcode = mkActivitiesPromotionEntity.getBarcode();
  3875. String entityGoodsSn = mkActivitiesPromotionEntity.getSku();
  3876. BigDecimal activityPrice = mkActivitiesPromotionEntity.getActivityPrice();
  3877. String shopSn = mkActivitiesPromotionEntity.getShopSn();
  3878. String rejectScore = mkActivitiesPromotionEntity.getRejectScore();
  3879. // 如果与积分抵扣互斥的,记录sku
  3880. if (!org.springframework.util.StringUtils.isEmpty(rejectScore) && Constants.PromotionActivityRejectEnum.REJECT.getCode().equals(rejectScore)) {
  3881. promotionSkuList.add(entityGoodsSn);
  3882. }
  3883. goodsEntities.forEach(goodsEntity -> {
  3884. String sku = goodsEntity.getSku();
  3885. String prodBarcode = goodsEntity.getProdBarcode();
  3886. String storeId2 = String.valueOf(goodsEntity.getStoreId());
  3887. BigDecimal retailPrice = goodsEntity.getRetailPrice();
  3888. if (entityBarcode.equals(prodBarcode) && entityGoodsSn.equals(sku) && shopSn.equals(storeId2)) {
  3889. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  3890. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, activityPrice, goodsService).setScale(3, RoundingMode.HALF_UP);
  3891. BeanUtils.copyProperties(goodsDetailsDto, goodsEntity);
  3892. goodsDetailsDto.setActualPaymentAmount(activityPrice);
  3893. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  3894. goodsDetailsDto.setActivity("限时促销");
  3895. goodsDetailsDto.setDiscountedPrice(retailPrice.subtract(activityPrice));
  3896. goodsDetailsDtos.add(goodsDetailsDto);
  3897. activityFlag.set(false);
  3898. promotionActivityFlag.set(true);
  3899. }
  3900. });
  3901. });
  3902. } else if (activityTopicEnum == Constants.ActivityTopicEnum.MZ && activityFlag.get()) {
  3903. // 判断商品是否符合满赠活动要求
  3904. MkActivitiesFullGiftEntity mkActivitiesFullGiftEntity = mkActivitiesFullGiftService.queryObjectByMkaIdAndStoreId(mkaId.intValue(), storeId);
  3905. if (Objects.isNull(mkActivitiesFullGiftEntity)) {
  3906. LOGGER.error("查询满赠活动信息结果为空!mka_id:{}, store_id:{}", mkaId, storeId);
  3907. } else {
  3908. Long brandId = mkActivitiesFullGiftEntity.getBrandId();
  3909. Long categoryId = mkActivitiesFullGiftEntity.getCategoryId();
  3910. Constants.ActivityType fullGiftActivityType = Constants.ActivityType.valueOf(mkActivitiesFullGiftEntity.getFullGiftType());
  3911. switch (fullGiftActivityType) {
  3912. case BRAND:
  3913. if (Objects.isNull(brandId)) {
  3914. LOGGER.error("满赠活动品牌编号为空,计算失败!请检查活动设置!活动ID:{}", mkActivitiesFullGiftEntity.getMkaId());
  3915. throw new ServiceException(String.format("满赠活动品牌编号为空,计算失败!请检查活动设置!活动ID:%s", mkActivitiesFullGiftEntity.getMkaId()));
  3916. }
  3917. if (brandIdList.contains(brandId.intValue())) {
  3918. // 活动包含该商品品牌,此次订单该品牌商品
  3919. List<GoodsEntity> goodsEntityList = goodsEntities.stream().filter(goodsEntity -> brandId.intValue() == goodsEntity.getBrandId()).collect(Collectors.toList());
  3920. AtomicReference<BigDecimal> brandTotalPrice = new AtomicReference<>(BigDecimal.ZERO);
  3921. goodsEntityList.forEach(goodsEntity -> {
  3922. brandTotalPrice.set(brandTotalPrice.get().add(goodsEntity.getRetailPrice()));
  3923. });
  3924. if (brandTotalPrice.get().compareTo(mkActivitiesFullGiftEntity.getQualifiedAmount()) >= 0) {
  3925. // 满足满赠条件
  3926. String giftGoodsSn = mkActivitiesFullGiftEntity.getGiftGoodsSn();
  3927. String giftBarcode = mkActivitiesFullGiftEntity.getGiftBarcode();
  3928. GoodsEntity goodsEntity = goodsService.queryGoodsStockByBarcodeAndStoreIdAndSku(giftBarcode, Integer.parseInt(mkaStoreId), giftGoodsSn);
  3929. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  3930. BeanUtils.copyProperties(goodsEntity, goodsDetailsDto);
  3931. // 除了限时促销(需要向海关备案),其它活动都拿海关备案价来算税款
  3932. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, goodsEntity.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  3933. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  3934. goodsDetailsDto.setActualPaymentAmount(BigDecimal.ZERO);
  3935. goodsDetailsDto.setActivity("满赠商品");
  3936. goodsDetailsDto.setGiftNumber(mkActivitiesFullGiftEntity.getGiftNumber());
  3937. goodsDetailsDto.setDiscountedPrice(goodsEntity.getRetailPrice());
  3938. // 添加进商品详情列表
  3939. goodsDetailsDtos.add(goodsDetailsDto);
  3940. activityFlag.set(false);
  3941. }
  3942. }
  3943. break;
  3944. case CATEGORY:
  3945. if (Objects.isNull(categoryId)) {
  3946. LOGGER.error("满赠活动分类编号为空,计算失败!请检查活动设置!活动ID:{}", mkActivitiesFullGiftEntity.getMkaId());
  3947. throw new ServiceException(String.format("满赠活动分类编号为空,计算失败!请检查活动设置!活动ID:%s", mkActivitiesFullGiftEntity.getMkaId()));
  3948. }
  3949. if (categoryIdList.contains(categoryId.intValue())) {
  3950. // 活动包含该商品分类
  3951. List<GoodsEntity> goodsEntityList = goodsEntities.stream().filter(goodsEntity -> brandId.equals(mkActivitiesFullGiftEntity.getCategoryId())).collect(Collectors.toList());
  3952. AtomicReference<BigDecimal> categoryTotalPrice = new AtomicReference<>(BigDecimal.ZERO);
  3953. goodsEntityList.forEach(goodsEntity -> {
  3954. categoryTotalPrice.set(categoryTotalPrice.get().add(goodsEntity.getRetailPrice()));
  3955. });
  3956. if (categoryTotalPrice.get().compareTo(mkActivitiesFullGiftEntity.getQualifiedAmount()) >= 0) {
  3957. // 满足满赠条件
  3958. String giftGoodsSn = mkActivitiesFullGiftEntity.getGiftGoodsSn();
  3959. String giftBarcode = mkActivitiesFullGiftEntity.getGiftBarcode();
  3960. GoodsEntity goodsEntity = goodsService.queryGoodsStockByBarcodeAndStoreIdAndSku(giftBarcode, Integer.parseInt(mkaStoreId), giftGoodsSn);
  3961. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  3962. BeanUtils.copyProperties(goodsEntity, goodsDetailsDto);
  3963. // 除了限时促销(需要向海关备案),其它活动都拿海关备案价来算税款
  3964. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, goodsEntity.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  3965. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  3966. goodsDetailsDto.setActualPaymentAmount(BigDecimal.ZERO);
  3967. goodsDetailsDto.setActivity("满赠商品");
  3968. goodsDetailsDto.setGiftNumber(mkActivitiesFullGiftEntity.getGiftNumber());
  3969. goodsDetailsDto.setDiscountedPrice(goodsEntity.getRetailPrice());
  3970. // 添加进商品详情列表
  3971. goodsDetailsDtos.add(goodsDetailsDto);
  3972. activityFlag.set(false);
  3973. }
  3974. }
  3975. break;
  3976. default:
  3977. LOGGER.error("未知满赠类型【{},{}】!请联系管理员!", fullGiftActivityType.getActivityType(), fullGiftActivityType.getActivityTypeCode());
  3978. throw new ServiceException(String.format("未知满赠类型【%s,%s】!请联系管理员!", fullGiftActivityType.getActivityType(), fullGiftActivityType.getActivityTypeCode()));
  3979. }
  3980. }
  3981. } else if (activityTopicEnum == Constants.ActivityTopicEnum.YHQ && activityFlag.get()) {
  3982. // 判断商品是否符合优惠券活动要求
  3983. List<MkActivitiesCouponEntity> mkActivitiesCouponEntities = mkActivitiesCouponService.queryListByMkaIdAndStoreId(mkaId, storeId);
  3984. if (CollectionUtils.isEmpty(mkActivitiesCouponEntities)) {
  3985. LOGGER.error("查询优惠券活动信息结果为空!活动ID:{}, 门店编号:{}", mkaId, storeId);
  3986. } else {
  3987. MkActivitiesCouponEntity mkActivitiesCouponEntity = mkActivitiesCouponEntities.get(0);
  3988. Integer couponEntityBrandId = mkActivitiesCouponEntity.getBrandId();
  3989. Integer couponEntityCategoryId = mkActivitiesCouponEntity.getCategoryId();
  3990. String shopSn = mkActivitiesCouponEntity.getShopSn();
  3991. if (org.springframework.util.StringUtils.isEmpty(shopSn)) {
  3992. LOGGER.error("优惠券活动门店编号为空,计算失败!请检查活动设置!活动ID:{}", mkActivitiesCouponEntity.getMkaId());
  3993. throw new ServiceException(String.format("优惠券活动门店编号为空,计算失败!请检查活动设置!活动ID:%s", mkActivitiesCouponEntity.getMkaId()));
  3994. }
  3995. Integer couponEntityStoreId = Integer.parseInt(shopSn);
  3996. BigDecimal couponPrice = mkActivitiesCouponEntity.getCouponPrice();
  3997. Constants.ActivityType couponActivityType = Constants.ActivityType.customValueOf(mkActivitiesCouponEntity.getActivityType());
  3998. if (Objects.isNull(couponActivityType)) {
  3999. LOGGER.error("错误的优惠券优惠类型:【{}】,请检查活动设置!活动ID:{}", mkActivitiesCouponEntity.getActivityType(), mkActivitiesCouponEntity.getMkaId());
  4000. throw new ServiceException(String.format("错误的优惠券优惠类型:【%s】,请检查活动设置!活动ID:%s", mkActivitiesCouponEntity.getActivityType(), mkActivitiesCouponEntity.getMkaId()));
  4001. }
  4002. switch (couponActivityType) {
  4003. case BRAND:
  4004. if (Objects.isNull(couponEntityBrandId)) {
  4005. LOGGER.error("优惠券活动品牌编号为空,计算失败!请检查活动设置!活动ID:{}", mkActivitiesCouponEntity.getMkaId());
  4006. throw new ServiceException(String.format("优惠券活动品牌编号为空,计算失败!请检查活动设置!活动ID:%s", mkActivitiesCouponEntity.getMkaId()));
  4007. }
  4008. goodsEntities.forEach(goodsEntity -> {
  4009. if (couponEntityBrandId.equals(goodsEntity.getBrandId())) {
  4010. BigDecimal retailPrice = goodsEntity.getRetailPrice();
  4011. String sku = goodsEntity.getSku();
  4012. String prodBarcode = goodsEntity.getProdBarcode();
  4013. if (couponPrice.compareTo(retailPrice) <= 0) {
  4014. LOGGER.error("优惠券优惠金额【{}】大于或等于商品【条码:{},sku:{}】的零售价【{}】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice);
  4015. throw new ServiceException(String.format("优惠券优惠金额【%s】大于或等于商品【条码:%s,sku:%s】的零售价【%s】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice));
  4016. }
  4017. BigDecimal discountAfterPrice = retailPrice.subtract(couponPrice);
  4018. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  4019. BeanUtils.copyProperties(goodsEntity, goodsDetailsDto);
  4020. // 除了限时促销(需要向海关备案),其它活动都拿海关备案价来算税款
  4021. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, goodsEntity.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  4022. goodsDetailsDto.setActualPaymentAmount(discountAfterPrice);
  4023. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  4024. goodsDetailsDto.setActivity("优惠券活动");
  4025. goodsDetailsDto.setDiscountedPrice(retailPrice.subtract(discountAfterPrice));
  4026. goodsDetailsDtos.add(goodsDetailsDto);
  4027. activityFlag.set(false);
  4028. }
  4029. });
  4030. break;
  4031. case CATEGORY:
  4032. if (Objects.isNull(couponEntityCategoryId)) {
  4033. LOGGER.error("优惠券活动分类编号为空,计算失败!请检查活动设置!活动ID:{}", mkActivitiesCouponEntity.getMkaId());
  4034. throw new ServiceException(String.format("优惠券活动分类编号为空,计算失败!请检查活动设置!活动ID:%s", mkActivitiesCouponEntity.getMkaId()));
  4035. }
  4036. goodsEntities.forEach(goodsEntity -> {
  4037. if (couponEntityCategoryId.equals(goodsEntity.getCategoryId())) {
  4038. BigDecimal retailPrice = goodsEntity.getRetailPrice();
  4039. String sku = goodsEntity.getSku();
  4040. String prodBarcode = goodsEntity.getProdBarcode();
  4041. if (couponPrice.compareTo(retailPrice) <= 0) {
  4042. LOGGER.error("优惠券优惠金额【{}】大于或等于商品【条码:{},sku:{}】的零售价【{}】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice);
  4043. throw new ServiceException(String.format("优惠券优惠金额【%s】大于或等于商品【条码:%s,sku:%s】的零售价【%s】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice));
  4044. }
  4045. BigDecimal discountAfterPrice = retailPrice.subtract(couponPrice);
  4046. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  4047. BeanUtils.copyProperties(goodsEntity, goodsDetailsDto);
  4048. // 除了限时促销(需要向海关备案),其它活动都拿海关备案价来算税款
  4049. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, goodsEntity.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  4050. goodsDetailsDto.setActualPaymentAmount(discountAfterPrice);
  4051. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  4052. goodsDetailsDto.setActivity("优惠券活动");
  4053. goodsDetailsDto.setDiscountedPrice(retailPrice.subtract(discountAfterPrice));
  4054. goodsDetailsDtos.add(goodsDetailsDto);
  4055. activityFlag.set(false);
  4056. }
  4057. });
  4058. break;
  4059. case PRODUCT:
  4060. mkActivitiesCouponEntities.forEach(mkActivitiesCouponEntity1 -> {
  4061. // 单个商品优惠券,有多条记录
  4062. String activityProductBarcode = mkActivitiesCouponEntity1.getBarcode();
  4063. String activitySku = mkActivitiesCouponEntity1.getGoodsSn();
  4064. goodsEntities.forEach(goodsEntity -> {
  4065. String sku = goodsEntity.getSku();
  4066. String prodBarcode = goodsEntity.getProdBarcode();
  4067. // 条码、sku、门店都需一致
  4068. if (activitySku.equals(sku) && activityProductBarcode.equals(prodBarcode) && couponEntityStoreId.equals(goodsEntity.getStoreId())) {
  4069. BigDecimal retailPrice = goodsEntity.getRetailPrice();
  4070. if (couponPrice.compareTo(retailPrice) <= 0) {
  4071. LOGGER.error("优惠券优惠金额【{}】大于或等于商品【条码:{},sku:{}】的零售价【{}】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice);
  4072. throw new ServiceException(String.format("优惠券优惠金额【%s】大于或等于商品【条码:%s,sku:%s】的零售价【%s】,请检查优惠券金额设置!", couponPrice, prodBarcode, sku, retailPrice));
  4073. }
  4074. BigDecimal discountAfterPrice = retailPrice.subtract(couponPrice);
  4075. GoodsDetailsDto goodsDetailsDto = new GoodsDetailsDto();
  4076. BeanUtils.copyProperties(goodsEntity, goodsDetailsDto);
  4077. // 除了限时促销(需要向海关备案),其它活动都拿海关备案价来算税款
  4078. BigDecimal tax = CalculateTax.calculateFinalTax(goodsEntity, goodsEntity.getRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  4079. goodsDetailsDto.setActualPaymentAmount(discountAfterPrice);
  4080. goodsDetailsDto.setGoodstaxes(String.valueOf(tax.multiply(new BigDecimal(goodsDetailsDto.getSellVolume()))));
  4081. goodsDetailsDto.setActivity("优惠券活动");
  4082. goodsDetailsDto.setDiscountedPrice(retailPrice.subtract(discountAfterPrice));
  4083. goodsDetailsDtos.add(goodsDetailsDto);
  4084. activityFlag.set(false);
  4085. }
  4086. });
  4087. });
  4088. break;
  4089. default:
  4090. LOGGER.error("未知的优惠券活动分类类型:【{},{}】,请联系管理员!", activityTopicEnum.getTopicCode(), activityTopicEnum.getTopicName());
  4091. throw new ServiceException(String.format("未知的优惠券活动分类类型:【%s,%s】,请联系管理员!", activityTopicEnum.getTopicCode(), activityTopicEnum.getTopicName()));
  4092. }
  4093. }
  4094. } else {
  4095. LOGGER.error("未知的活动类型:【{},{}】,请检查活动设置!!", activityTopicEnum.getTopicCode(), activityTopicEnum.getTopicName());
  4096. throw new ServiceException(String.format("未知的活动类型:【%s,%s】,请检查活动设置!!", activityTopicEnum.getTopicCode(), activityTopicEnum.getTopicName()));
  4097. }
  4098. });
  4099. // 计算完活动优惠后,计算积分抵扣。(活动与积分抵扣不互斥)
  4100. if (!org.springframework.util.StringUtils.isEmpty(memberCode)) {
  4101. String memberInfoByCodeResponseJson;
  4102. Response<Object> response;
  4103. try {
  4104. // 查询会员信息
  4105. memberInfoByCodeResponseJson = haiKongMemberTemplate.getMemberInfoByPhone("{\"phone\":" + memberCode + "}");
  4106. response = JacksonUtil.fromListJson(memberInfoByCodeResponseJson, new TypeReference<Response<Object>>() {
  4107. });
  4108. if (Objects.isNull(response) || Objects.nonNull(response.getErrorCode())) {
  4109. LOGGER.error("请求会员系统出现异常!error:{}", memberInfoByCodeResponseJson);
  4110. throw new ServiceException(String.format("请求会员系统出现异常!会员码:%s,error:%s", memberCode, memberInfoByCodeResponseJson));
  4111. }
  4112. } catch (Exception e) {
  4113. LOGGER.error("请求会员系统失败或处理响应失败!", e);
  4114. throw new ServiceException(e);
  4115. }
  4116. BigDecimal afterDiscountPrice;
  4117. if (response.getSuccess()) {
  4118. MemberInfoDTO memberInfoDTO = JacksonUtil.fromStringJson(JacksonUtil.toJson(response.getData()), MemberInfoDTO.class);
  4119. assert memberInfoDTO != null : String.format("会员码:【%s】会员信息错误!%s", memberCode, JacksonUtil.toJson(response));
  4120. // 查询会员表
  4121. /*UserEntity userEntity = userService.queryByMobile(memberCode);
  4122. userEntity.setOpenId(memberInfoDTO.getOpenId());
  4123. userEntity.setMemberCode(memberCode);
  4124. userService.update(userEntity);*/
  4125. Integer score = memberInfoDTO.getScore();
  4126. if (Objects.nonNull(score) && score > 0) {
  4127. // 有积分
  4128. afterDiscountPrice = calculatePreferentialPrice(orderTotalPrice, score, storeId, memberCode, calculateOrderDiscountPriceResponseVO, goodsDetailsDtos, promotionActivityFlag, promotionSkuList);
  4129. LOGGER.info("会员【{}】,当前积分:{},积分抵扣后的订单金额:{},积分抵扣前的订单金额:{}", memberCode, score, afterDiscountPrice, orderTotalPrice);
  4130. calculateOrderDiscountPriceResponseVO.setOrderTotalPrice(afterDiscountPrice);
  4131. calculateOrderDiscountPriceResponseVO.setGoodsDetailsDtos(goodsDetailsDtos);
  4132. calculateOrderDiscountPriceResponseVO.setBeforeScore(score);
  4133. calculateOrderDiscountPriceResponseVO.setOpenId(memberInfoDTO.getOpenId());
  4134. calculateOrderDiscountPriceResponseVO.setMemberPhone(memberInfoDTO.getPhone());
  4135. // 订单完成后再添加积分消费记录,以及同步积分信息
  4136. return calculateOrderDiscountPriceResponseVO;
  4137. } else {
  4138. LOGGER.error("会员【{}】积分为0,积分抵扣失败!", memberCode);
  4139. throw new ServiceException(String.format("会员【%s】积分为0,积分抵扣失败!", memberCode));
  4140. }
  4141. } else {
  4142. LOGGER.error("查询会员信息失败!响应结果:{}", memberInfoByCodeResponseJson);
  4143. throw new ServiceException(String.format("会员码:%s,错误码:%s,错误信息:%s", memberCode, response.getErrorCode(), response.getErrorMessage()));
  4144. }
  4145. }
  4146. calculateOrderDiscountPriceResponseVO.setGoodsDetailsDtos(goodsDetailsDtos);
  4147. orderTotalPrice = BigDecimal.ZERO;
  4148. for (GoodsDetailsDto goodsDetailsDto : goodsDetailsDtos) {
  4149. orderTotalPrice = orderTotalPrice.add(goodsDetailsDto.getActualPaymentAmount());
  4150. }
  4151. calculateOrderDiscountPriceResponseVO.setOrderTotalPrice(orderTotalPrice);
  4152. return calculateOrderDiscountPriceResponseVO;
  4153. }
  4154. /**
  4155. * 计算积分抵扣后的订单总金额
  4156. * @param orderTotalPrice 订单商品总价
  4157. * @param score 积分
  4158. * @param storeId 门店id
  4159. * @param memberCode 会员码
  4160. * @param goodsDetailsDtos 订单商品详情
  4161. * @param calculateOrderDiscountPriceResponseVO 响应数据
  4162. * @param promotionActivityFlag 是否参与了积分抵扣活动
  4163. * @param promotionSkuList 参与了限时特价活动并且与积分抵扣互斥的sku集合
  4164. * @return 积分抵扣后的订单总金额
  4165. */
  4166. private BigDecimal calculatePreferentialPrice(BigDecimal orderTotalPrice, Integer score, String storeId, String memberCode, CalculateOrderDiscountPriceResponseVO calculateOrderDiscountPriceResponseVO, List<GoodsDetailsDto> goodsDetailsDtos, AtomicBoolean promotionActivityFlag, List<String> promotionSkuList) {
  4167. // 1. 判断是否有积分,是否需要计算积分抵扣后的价格
  4168. AtomicBoolean isCalculateScorePrice = new AtomicBoolean(false);
  4169. if (Objects.nonNull(score) && score > 0) {
  4170. isCalculateScorePrice.set(true);
  4171. }
  4172. // 参与了积分抵扣的sku集合
  4173. Date date = new Date();
  4174. List<MkActivitiesScoreEntity> mkActivitiesScoreEntities = mkActivitiesScoreService.queryDetailByTime(date);
  4175. if (CollectionUtils.isEmpty(mkActivitiesScoreEntities)) {
  4176. LOGGER.error("当前时间【{}】无积分抵扣活动!", date);
  4177. return orderTotalPrice;
  4178. }
  4179. List<String> scoreDeductionSkuList = mkActivitiesScoreEntities.stream().map(MkActivitiesScoreEntity::getSku).collect(Collectors.toList());
  4180. // 转换成map,保存参与了积分抵扣活动的sku,积分计算比例的数据,key===>sku,value===>比例
  4181. Map<String, BigDecimal> skuScoreLimitMap = mkActivitiesScoreEntities.stream().collect(Collectors.toMap(MkActivitiesScoreEntity::getSku, MkActivitiesScoreEntity::getScoreLimit, (k1, k2) -> k2));
  4182. // 当前订单中参与了积分抵扣活动的sku总支付金额
  4183. BigDecimal skuTotalPrice = BigDecimal.ZERO;
  4184. for (GoodsDetailsDto goodsDetailsDto : goodsDetailsDtos) {
  4185. String sku = goodsDetailsDto.getGoodsSn();
  4186. if (!promotionSkuList.contains(sku)) {
  4187. if (scoreDeductionSkuList.contains(sku)) {
  4188. BigDecimal skuActualPaymentAmount = goodsDetailsDto.getActualPaymentAmount();
  4189. skuTotalPrice = skuTotalPrice.add(skuActualPaymentAmount);
  4190. }
  4191. }
  4192. }
  4193. // 2. 计算积分抵扣后的总价格
  4194. if (isCalculateScorePrice.get()) {
  4195. Integer scoreLimit = haiKongProperties.getMemberScoreLimit();
  4196. if (score < scoreLimit) {
  4197. LOGGER.warn("用户【{}】的积分数量为:{},最低需要30积分才能抵扣!", memberCode, score);
  4198. return orderTotalPrice;
  4199. } else {
  4200. // 积分取整
  4201. int scoreInteger = score % scoreLimit == 0 ? score : score - (score % scoreLimit);
  4202. // 积分的50%
  4203. int scoreIntegerHalf = scoreInteger * scoreLimit / 100;
  4204. // 3-2. 计算出积分能抵扣的价格
  4205. int scoreMayDeductionPrice = (int) (score / scoreLimit);
  4206. BigDecimal scoreMayDeductionPriceDecimal = new BigDecimal(scoreMayDeductionPrice);
  4207. // 过滤掉参与过限时特价并且与积分抵扣互斥的sku
  4208. goodsDetailsDtos = goodsDetailsDtos.stream().filter(goodsDetailsDto -> !promotionSkuList.contains(goodsDetailsDto.getSku())).collect(Collectors.toList());
  4209. // 总分摊积分
  4210. BigDecimal shareScore = BigDecimal.ZERO;
  4211. BigDecimal scoreIntegerDecimal = BigDecimal.valueOf(scoreInteger);
  4212. BigDecimal goodsDetailScoreDeductionPrice = BigDecimal.ZERO;
  4213. int size = goodsDetailsDtos.size();
  4214. for (int i = 0; i < size; i++) {
  4215. GoodsDetailsDto goodsDetailsDto = goodsDetailsDtos.get(i);
  4216. // 抵扣积分分摊
  4217. int index = size - 1;
  4218. String sku = goodsDetailsDto.getGoodsSn();
  4219. BigDecimal scoreLimitDecimal = skuScoreLimitMap.get(sku);
  4220. String prodBarcode = goodsDetailsDto.getProdBarcode();
  4221. BigDecimal actualPaymentAmount = goodsDetailsDto.getActualPaymentAmount();
  4222. // 计算抵扣,当商品不是最后一个商品
  4223. if (i < index) {
  4224. // 商品总价
  4225. // 分摊积分
  4226. BigDecimal shareScoreItem = actualPaymentAmount.divide(scoreIntegerDecimal.multiply(skuTotalPrice), 2, BigDecimal.ROUND_HALF_UP);
  4227. shareScore = shareScore.add(shareScoreItem);
  4228. // 保留两位小数,四舍五入
  4229. BigDecimal discountedPrice = shareScore.divide(scoreLimitDecimal, 2, BigDecimal.ROUND_HALF_UP);
  4230. goodsDetailScoreDeductionPrice = goodsDetailScoreDeductionPrice.add(discountedPrice);
  4231. goodsDetailsDto.setDiscountedPrice(discountedPrice);
  4232. goodsDetailsDto.setDeductionScore(shareScoreItem.intValue());
  4233. goodsDetailsDto.setActualPaymentAmount(actualPaymentAmount.subtract(discountedPrice));
  4234. }
  4235. // 订单商品详情最后一个商品并且详情不止一个商品
  4236. if (i == index && size > 1) {// 商品总价
  4237. // 分摊积分
  4238. BigDecimal shareScoreItem = scoreIntegerDecimal.subtract(shareScore);
  4239. BigDecimal discountedPrice = shareScoreItem.divide(scoreLimitDecimal, 2, BigDecimal.ROUND_HALF_UP);
  4240. goodsDetailScoreDeductionPrice = goodsDetailScoreDeductionPrice.add(discountedPrice);
  4241. goodsDetailsDto.setDiscountedPrice(discountedPrice);
  4242. goodsDetailsDto.setDeductionScore(shareScoreItem.intValue());
  4243. goodsDetailsDto.setActualPaymentAmount(actualPaymentAmount.subtract(discountedPrice));
  4244. }
  4245. // 订单商品详情只有一个商品的情况下
  4246. if (size == 1) {
  4247. BigDecimal shareScoreItem = scoreIntegerDecimal.subtract(shareScore);
  4248. // 3-1. 计算总价的50%,百分比可以进行设置,算出整数(向下取整)
  4249. BigDecimal halfPrice = orderTotalPrice.multiply(scoreLimitDecimal).setScale(0, BigDecimal.ROUND_FLOOR);
  4250. // 3-3. 计算积分抵扣后的价格
  4251. BigDecimal discountedPrice = scoreMayDeductionPriceDecimal;
  4252. if (halfPrice.compareTo(discountedPrice) <= 0) {
  4253. // 积分能抵扣的金额大于订单总额的50%,按50%抵扣
  4254. discountedPrice = halfPrice;
  4255. }
  4256. goodsDetailScoreDeductionPrice = goodsDetailScoreDeductionPrice.add(discountedPrice);
  4257. goodsDetailsDto.setDiscountedPrice(discountedPrice);
  4258. goodsDetailsDto.setDeductionScore(shareScoreItem.intValue());
  4259. goodsDetailsDto.setActualPaymentAmount(actualPaymentAmount.subtract(discountedPrice));
  4260. }
  4261. LOGGER.info("--------------------------------------------------------");
  4262. LOGGER.info("【计算优惠价】sku:【{}】,条码:【{}】积分抵扣{}元,抵扣积分{}分", sku, prodBarcode, goodsDetailsDto.getDiscountedPrice(), shareScore.intValue());
  4263. LOGGER.info("--------------------------------------------------------");
  4264. }
  4265. scoreMayDeductionPriceDecimal = goodsDetailScoreDeductionPrice;
  4266. orderTotalPrice = orderTotalPrice.subtract(scoreMayDeductionPriceDecimal);
  4267. int afterScore = score - scoreIntegerHalf;
  4268. calculateOrderDiscountPriceResponseVO.setAfterScore(afterScore);
  4269. calculateOrderDiscountPriceResponseVO.setScoreLimit(scoreLimit);
  4270. calculateOrderDiscountPriceResponseVO.setDeductionScore(scoreIntegerHalf);
  4271. calculateOrderDiscountPriceResponseVO.setOrderTotalPrice(orderTotalPrice);
  4272. calculateOrderDiscountPriceResponseVO.setScoreDeductionPrice(scoreMayDeductionPriceDecimal);
  4273. LOGGER.info("会员【{}】,当前积分:{},抵扣订单金额后剩余积分:{}", memberCode, score, afterScore);
  4274. }
  4275. } else {
  4276. LOGGER.info("会员【{}】的积分小于积分抵扣最低值,不参加积分抵扣!", memberCode);
  4277. }
  4278. return orderTotalPrice;
  4279. }
  4280. /**
  4281. * 重发订单
  4282. * @param orderSn
  4283. * @return
  4284. */
  4285. @Override
  4286. public R resendOrderHkMall(String orderSn) {
  4287. OrderEntity orderEntity = orderDao.queryObjectByOrderSn(orderSn);
  4288. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_100.getItem())||
  4289. orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())||
  4290. orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_500.getItem())||
  4291. orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem())||
  4292. orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())||
  4293. orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_0.getItem())
  4294. ) {
  4295. return R.error(500,"无法重发订单,请检查订单状态");
  4296. }
  4297. LOGGER.info("=======> [调用VMCShop接口开始发送退款订单数据]"+orderSn);
  4298. Map<String,String> map = new HashMap<>();
  4299. map.put("outer_order_no",orderSn);
  4300. String body = JacksonUtil.toJson(map);
  4301. String response = vmcShopTemplate.resendOrder(body);
  4302. //解析响应数据
  4303. LOGGER.info("=======> [resendOrderHkMall---重发订单数据成功,开始处理后续流程]"+response);
  4304. Map<String,String> res = JSON.parseObject(response,Map.class);
  4305. if("0".equals(res.get("code"))){
  4306. return R.ok();
  4307. }else{
  4308. return R.error(500,"重发订单失败");
  4309. }
  4310. }
  4311. /**
  4312. * 设置订单数据
  4313. *
  4314. * @return
  4315. */
  4316. public OrderVo setOrderVo(List<GoodsEntity> goodsList, UserEntity loginUser, Long storeId, String merchSn, BigDecimal disCountAmount, BigDecimal totalTax) {
  4317. OrderVo orderInfo = new OrderVo();
  4318. BigDecimal goodsTotalPrice = new BigDecimal(0.00);
  4319. BigDecimal fullCutCouponDec = Constant.ZERO; // 非现金抵扣 = 各种优惠价格 +优惠券的价格 暂时借用这个字段去,为了不改动ccnet系统
  4320. BigDecimal couponPrice = disCountAmount;
  4321. BigDecimal freightPrice = Constant.ZERO;
  4322. BigDecimal actualPrice = Constant.ZERO;
  4323. //订单价格计算:订单的总价+运费
  4324. for (GoodsEntity goodsEntity : goodsList) {
  4325. goodsTotalPrice = goodsTotalPrice
  4326. .add(goodsEntity.getRetailPrice().multiply(new BigDecimal(goodsEntity.getGoodsNumber()))).setScale(2, RoundingMode.HALF_UP);
  4327. fullCutCouponDec = fullCutCouponDec
  4328. .add(goodsEntity.getDiscountedPrice()).setScale(2, RoundingMode.HALF_UP);
  4329. actualPrice = actualPrice
  4330. .add(goodsEntity.getActualPaymentAmount()).setScale(2, RoundingMode.HALF_UP);
  4331. }
  4332. BigDecimal orderTotalPrice = goodsTotalPrice.add(new BigDecimal(0));
  4333. fullCutCouponDec = fullCutCouponDec.add(couponPrice).setScale(2, RoundingMode.HALF_UP);
  4334. // 加上税额
  4335. goodsTotalPrice = goodsTotalPrice.subtract(totalTax).setScale(2, RoundingMode.HALF_UP);
  4336. SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
  4337. String orderSn = "ZWCW" + format.format(new Date()) + CommonUtil.generateOrderNumber();
  4338. orderInfo.setOrder_sn(orderSn);
  4339. orderInfo.setMerchSn(merchSn);
  4340. orderInfo.setUser_id(loginUser.getId().longValue());
  4341. actualPrice = actualPrice.subtract(couponPrice);
  4342. StoreEntity storeEntity = storeDao.queryObject(storeId);
  4343. //收货地址和运费
  4344. orderInfo.setConsignee(loginUser.getUsername());
  4345. orderInfo.setMobile(loginUser.getMobile());
  4346. orderInfo.setCountry("");
  4347. orderInfo.setProvince(storeEntity.getProvinceName());
  4348. orderInfo.setCity(storeEntity.getCityName());
  4349. orderInfo.setDistrict(storeEntity.getCountyName());
  4350. orderInfo.setAddress(storeEntity.getStoreAddress());
  4351. orderInfo.setAddress_id(1L);
  4352. orderInfo.setDelivery_date(new Date());
  4353. orderInfo.setDelivery_remark("无");
  4354. orderInfo.setStore_id(storeId);
  4355. orderInfo.setFreight_price(freightPrice.intValue());
  4356. orderInfo.setCoupon_id(Integer.parseInt(String.valueOf(0L)));
  4357. orderInfo.setCoupon_price(couponPrice);
  4358. orderInfo.setCoupon_name("无");
  4359. orderInfo.setActivity_id(0L);
  4360. //使用的促销费用
  4361. orderInfo.setFull_cut_price(fullCutCouponDec);
  4362. orderInfo.setCampMinusId(0);
  4363. orderInfo.setCampName("");
  4364. //留言
  4365. orderInfo.setPostscript("无");
  4366. orderInfo.setAdd_time(new Date());
  4367. orderInfo.setGoods_price(goodsTotalPrice); // 商品总价
  4368. orderInfo.setOrder_price(orderTotalPrice);
  4369. orderInfo.setActual_price(actualPrice); // 实际支付金额
  4370. orderInfo.setOrder_type("1");
  4371. orderInfo.setOrder_status(0);
  4372. orderInfo.setShipping_status(0);
  4373. orderInfo.setPay_status(0);
  4374. orderInfo.setShipping_id(0L);
  4375. orderInfo.setShipping_fee(Constant.ZERO);
  4376. orderInfo.setIntegral(0);
  4377. orderInfo.setIntegral_money(Constant.ZERO);
  4378. orderInfo.setCreateTime(new Date());
  4379. orderInfo.setModTime(new Date());
  4380. orderInfo.setPayMobile(loginUser.getMobile());
  4381. // orderInfo.setPayTransactionId(orderInfo.getOrder_sn());
  4382. orderInfo.setIsScan("0");//默认未扫描
  4383. orderInfo.setPayMobile(loginUser.getMobile());
  4384. orderInfo.setPay_name(loginUser.getUsername());
  4385. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());
  4386. orderInfo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  4387. return orderInfo;
  4388. }
  4389. /**
  4390. * 设置订单数据
  4391. *
  4392. * @return
  4393. */
  4394. public OrderVo setOrderVo(List<GoodsEntity> goodsList, UserEntity loginUser, Long storeId, String merchSn, BigDecimal totalTax, int status, Map mapAddr) {
  4395. OrderVo orderInfo = new OrderVo();
  4396. BigDecimal goodsTotalPrice = BigDecimal.ZERO;
  4397. BigDecimal fullCutCouponDec = Constant.ZERO; // 非现金抵扣 = 各种优惠价格 +优惠券的价格 暂时借用这个字段去,为了不改动ccnet系统
  4398. BigDecimal couponPrice = BigDecimal.ZERO;
  4399. BigDecimal freightPrice = Constant.ZERO;
  4400. BigDecimal actualPrice = Constant.ZERO;
  4401. //订单价格计算:订单的总价+运费
  4402. for (GoodsEntity goodsEntity : goodsList) {
  4403. goodsTotalPrice = goodsTotalPrice
  4404. .add(goodsEntity.getRetailPrice().multiply(new BigDecimal(goodsEntity.getSellVolume()))).setScale(2, RoundingMode.HALF_UP);
  4405. fullCutCouponDec = fullCutCouponDec
  4406. .add(goodsEntity.getDiscountedPrice()).setScale(2, RoundingMode.HALF_UP);
  4407. actualPrice = actualPrice
  4408. .add(goodsEntity.getActualPaymentAmount()).setScale(2, RoundingMode.HALF_UP);
  4409. couponPrice = couponPrice.add(goodsEntity.getDiscountedPrice()).setScale(2, RoundingMode.HALF_UP);
  4410. }
  4411. BigDecimal orderTotalPrice = goodsTotalPrice.add(new BigDecimal(0));
  4412. fullCutCouponDec = fullCutCouponDec.add(couponPrice).setScale(2, RoundingMode.HALF_UP);
  4413. // 加上税额
  4414. goodsTotalPrice = goodsTotalPrice.subtract(totalTax).setScale(2, RoundingMode.HALF_UP);
  4415. SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
  4416. String orderSn = "ZWCW" + format.format(new Date()) + CommonUtil.generateOrderNumber();
  4417. orderInfo.setOrder_sn(orderSn);
  4418. orderInfo.setMerchSn(merchSn);
  4419. orderInfo.setUser_id(loginUser.getId().longValue());
  4420. actualPrice = actualPrice.subtract(couponPrice);
  4421. //StoreEntity storeEntity = storeDao.queryObject(storeId);
  4422. //随机获取收货人地址
  4423. AddressEntity addressEntity = addressDao.queryStoreAddress(storeId,Dict.addressStatus.item_2.getItem());
  4424. if(null==addressEntity){
  4425. LOGGER.error("setOrderVo---门店未配置收货人地址:"+storeId);
  4426. throw new RRException("门店未配置收货人地址");
  4427. }
  4428. //收货地址和运费
  4429. orderInfo.setConsignee(loginUser.getUsername());
  4430. orderInfo.setMobile(loginUser.getMobile());
  4431. orderInfo.setCountry("");
  4432. //根据 前端的选择方式 1 是柜取 0 是 邮寄
  4433. if (status == 0) {
  4434. //省
  4435. // String cmbProvince = (String) mapAddr.get("cmbProvince");
  4436. // //市
  4437. // String cmbCity = (String) mapAddr.get("cmbCity");
  4438. // //区
  4439. // String cmbArea = (String) mapAddr.get("cmbArea");
  4440. // //详细地址
  4441. // String addrUser = (String) mapAddr.get("addrUser");
  4442. // orderInfo.setProvince(cmbProvince);
  4443. // orderInfo.setCity(cmbCity);
  4444. // orderInfo.setDistrict(cmbArea);
  4445. // orderInfo.setAddress(addrUser);
  4446. orderInfo.setProvince(addressEntity.getProvinceName());
  4447. orderInfo.setCity(addressEntity.getCityName());
  4448. orderInfo.setDistrict(addressEntity.getCountyName());
  4449. orderInfo.setAddress(addressEntity.getDetailInfo());
  4450. } else {
  4451. orderInfo.setProvince(addressEntity.getProvinceName());
  4452. orderInfo.setCity(addressEntity.getCityName());
  4453. orderInfo.setDistrict(addressEntity.getCountyName());
  4454. orderInfo.setAddress(addressEntity.getDetailInfo());
  4455. }
  4456. orderInfo.setAddress_id(1L);
  4457. orderInfo.setDelivery_date(new Date());
  4458. orderInfo.setDelivery_remark("无");
  4459. orderInfo.setStore_id(storeId);
  4460. orderInfo.setFreight_price(freightPrice.intValue());
  4461. orderInfo.setCoupon_id(Integer.parseInt(String.valueOf(0L)));
  4462. orderInfo.setCoupon_price(couponPrice);
  4463. orderInfo.setCoupon_name("无");
  4464. orderInfo.setActivity_id(0L);
  4465. //使用的促销费用
  4466. orderInfo.setFull_cut_price(fullCutCouponDec);
  4467. orderInfo.setCampMinusId(0);
  4468. orderInfo.setCampName("");
  4469. //留言
  4470. orderInfo.setPostscript("无");
  4471. orderInfo.setAdd_time(new Date());
  4472. orderInfo.setGoods_price(goodsTotalPrice); // 商品总价
  4473. orderInfo.setOrder_price(orderTotalPrice);
  4474. orderInfo.setActual_price(actualPrice); // 实际支付金额
  4475. orderInfo.setOrder_type("1");
  4476. orderInfo.setOrder_status(0);
  4477. orderInfo.setShipping_status(0);
  4478. orderInfo.setPay_status(0);
  4479. orderInfo.setShipping_id(0L);
  4480. orderInfo.setShipping_fee(Constant.ZERO);
  4481. orderInfo.setIntegral(0);
  4482. orderInfo.setIntegral_money(Constant.ZERO);
  4483. orderInfo.setCreateTime(new Date());
  4484. orderInfo.setModTime(new Date());
  4485. orderInfo.setPayMobile(loginUser.getMobile());
  4486. // orderInfo.setPayTransactionId(orderInfo.getOrder_sn());
  4487. orderInfo.setIsScan("0");//默认未扫描
  4488. orderInfo.setPayMobile(loginUser.getMobile());
  4489. orderInfo.setPay_name(loginUser.getUsername());
  4490. orderInfo.setIsOnfflineOrder(Dict.isOnfflineOrder.item_1.getItem());
  4491. orderInfo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  4492. // 添加快递信息
  4493. try {
  4494. StoreExprActiveDto activeExpr = addressInfoService.queryByStoreId(storeId);
  4495. if (activeExpr == null) {
  4496. throw new RRException("门店未配置快递信息");
  4497. }
  4498. orderInfo.setShipping_id(activeExpr.getExprId());
  4499. orderInfo.setShipping_code(activeExpr.getExprCode());
  4500. orderInfo.setShipping_name(activeExpr.getExprName());
  4501. } catch (Exception e) {
  4502. LOGGER.error("订单写入门店快递配置信息有误:", e);
  4503. }
  4504. return orderInfo;
  4505. }
  4506. public OrderGoodsVo setOrderGoodsVo(OrderVo orderInfo, GoodsEntity goodsDto) {
  4507. OrderGoodsVo orderGoodsVo = new OrderGoodsVo();
  4508. orderGoodsVo.setOrder_id(orderInfo.getId());
  4509. orderGoodsVo.setGoods_id(goodsDto.getId());
  4510. orderGoodsVo.setGoods_sn(goodsDto.getGoodsSn());
  4511. orderGoodsVo.setProduct_id(Long.valueOf(goodsDto.getProductId()));
  4512. orderGoodsVo.setGoods_name(goodsDto.getName());
  4513. orderGoodsVo.setList_pic_url(goodsDto.getListPicUrl());
  4514. orderGoodsVo.setMarket_price(goodsDto.getStoreRetailPrice());
  4515. orderGoodsVo.setRetail_price(goodsDto.getStoreRetailPrice());
  4516. orderGoodsVo.setDiscountedPrice(goodsDto.getDiscountedPrice());
  4517. orderGoodsVo.setActualPaymentAmount(goodsDto.getActualPaymentAmount());
  4518. orderGoodsVo.setNumber(goodsDto.getSellVolume());
  4519. // orderGoodsVo.setGoods_specification_name_value(goodsDto.get);
  4520. // orderGoodsVo.setGoods_specification_ids(goodsItem.getGoods_specification_ids());
  4521. orderGoodsVo.setOrderBizType(Dict.orderBizType.item_10.getItem());
  4522. orderGoodsVo.setCreateTime(new Date());
  4523. orderGoodsVo.setModTime(new Date());
  4524. orderGoodsVo.setActivity(goodsDto.getActivity());
  4525. orderGoodsVo.setGoodsRate(goodsDto.getGoodsRate());
  4526. orderGoodsVo.setSku(goodsDto.getSku());
  4527. BigDecimal number = new BigDecimal(Long.valueOf(goodsDto.getSellVolume()));
  4528. BigDecimal goodsTotal = goodsDto.getRetailPrice().multiply(number);//单商品总价
  4529. BigDecimal rate = goodsTotal.divide(orderInfo.getGoods_price(), 2, BigDecimal.ROUND_HALF_UP);//当前商品总价/订单总价(不含运费、不含优惠券)
  4530. BigDecimal freightPrice = BigDecimal.valueOf(orderInfo.getFreight_price());
  4531. BigDecimal settlePrice = Constant.ZERO; // ccnet 取的这个而价格
  4532. if (orderInfo.getFreight_price() != 0 && !"0".equalsIgnoreCase(orderInfo.getCoupon_price() + "")) {
  4533. //运费-优惠券
  4534. BigDecimal rateTotal = freightPrice.subtract(orderInfo.getCoupon_price());
  4535. //商品结算平摊价格(含优惠券、运费金额) = 单商品总价 + 当前商品总价/订单总价(不含运费、不含优惠券) * 运费与优惠券合计税率
  4536. settlePrice = goodsTotal.add(rate.multiply(rateTotal));
  4537. } else {
  4538. if (orderInfo.getFreight_price() != 0) {
  4539. //运费税率 = 单商品总价/订单总价(不含运费)* 运费金额
  4540. BigDecimal freightRate = rate.multiply(freightPrice);
  4541. //商品结算平摊价格(含运费金额) = 单商品总价+运费税率
  4542. settlePrice = goodsTotal.add(freightRate);
  4543. }
  4544. if (!"0".equalsIgnoreCase(orderInfo.getCoupon_price() + "")) {
  4545. //优惠券税率 = 单商品总价/订单总价(不含优惠券)* 优惠券金额
  4546. BigDecimal couponRate = rate.multiply(orderInfo.getCoupon_price());
  4547. //商品结算平摊价格(含优惠券金额) = 单商品总价-优惠券税率
  4548. settlePrice = goodsTotal.subtract(couponRate);
  4549. }
  4550. }
  4551. if (settlePrice.compareTo(BigDecimal.valueOf(0)) == 0) {
  4552. orderGoodsVo.setSettlePrice(goodsTotal);//商品结算平摊价格
  4553. } else {
  4554. orderGoodsVo.setSettlePrice(settlePrice);//商品结算平摊价格
  4555. }
  4556. // 计算税费
  4557. GoodsEntity goodsEntity = goodsService.queryObject(goodsDto.getId().intValue());
  4558. BigDecimal goodsTax = CalculateTax.calculateFinalTax(goodsEntity, goodsDto.getStoreRetailPrice(), goodsService).setScale(3, RoundingMode.HALF_UP);
  4559. goodsTax = goodsTax.multiply(number).setScale(2, RoundingMode.HALF_UP);
  4560. orderGoodsVo.setTaxPrice(goodsTax);
  4561. return orderGoodsVo;
  4562. }
  4563. }