WholeController.php 244 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783478447854786478747884789479047914792479347944795479647974798479948004801480248034804480548064807480848094810481148124813481448154816481748184819482048214822482348244825482648274828482948304831483248334834483548364837483848394840484148424843484448454846484748484849485048514852485348544855485648574858485948604861486248634864486548664867486848694870487148724873
  1. <?php
  2. namespace app\admin\controller\order;
  3. use app\admin\service\coupon\CouponService;
  4. use app\admin\service\member\MemberService;
  5. use app\admin\service\order\OrderService;
  6. use app\admin\validate\coupon\CouponValidate;
  7. use app\admin\validate\device\DeviceValidate;
  8. use app\admin\validate\order\OrderExpressValidate;
  9. use app\admin\validate\order\OrderValidate;
  10. use app\common\payment\AppUtil;
  11. use app\common\payment\Tlpay;
  12. use app\controller\Curd;
  13. use app\model\Appointment;
  14. use app\model\ClientConfig;
  15. use app\model\Coupon;
  16. use app\model\CouponDetail;
  17. use app\model\Device;
  18. use app\model\Goods;
  19. use app\model\GoodsComponent;
  20. use app\model\GoodsRunning;
  21. use app\model\GoodsSku;
  22. use app\model\Member;
  23. use app\model\MemberAccount;
  24. use app\model\MemberBenefit;
  25. use app\model\MemberRole;
  26. use app\model\Order;
  27. use app\model\OrderExpress;
  28. use app\model\OrderReturn;
  29. use app\model\OrderSheet;
  30. use app\model\PayDetail;
  31. use app\model\Premises;
  32. use app\model\Supplier;
  33. use app\model\SysDept;
  34. use app\model\SysSerial;
  35. use app\model\SysUser;
  36. use Payment\Common\PayException;
  37. use support\Db;
  38. use support\exception\BusinessException;
  39. use support\Redis;
  40. use support\Request;
  41. use support\Response;
  42. use Tinywan\Jwt\JwtToken;
  43. use Webman\Event\Event;
  44. use Yansongda\Pay\Pay;
  45. class WholeController extends Curd
  46. {
  47. public function __construct()
  48. {
  49. $this->model = new Order();
  50. $this->validate = true;
  51. $this->validateClass = new OrderValidate();
  52. }
  53. /**
  54. * @Desc 列表
  55. * @Author Gorden
  56. * @Date 2024/3/28 15:01
  57. *
  58. * @param Request $request
  59. * @return Response
  60. * @throws \support\exception\BusinessException
  61. */
  62. public function select(Request $request): Response
  63. {
  64. [$where, $format, $limit, $field, $order] = $this->selectInput($request);
  65. if (!empty($where['order_addtimes'])) {
  66. $where['order_addtimes'][0] = strtotime($where['order_addtimes'][0]);
  67. $where['order_addtimes'][1] = strtotime($where['order_addtimes'][1]);
  68. }
  69. if ($request->get('goods_classify') && $request->get('goods_classify') == 'SERVICE') {
  70. $where['order_classify'] = ['in', 'SERVICE,CHNMED,CHNNCD'];
  71. } else if ($request->get('goods_classify')) {
  72. $where['order_classify'] = $request->get('goods_classify');
  73. }
  74. $order = $request->get('order', 'desc');
  75. $type = $request->get('type', '');
  76. if ($type == 'todayOrder' && empty($where['order_addtimes'])) {
  77. $where['order_addtimes'][0] = strtotime(date('Y-m-d') . ' 00:00:00');
  78. $where['order_addtimes'][1] = strtotime(date('Y-m-d') . ' 23:59:59');
  79. } else if ($type == 'todayOrderAmount') {
  80. $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
  81. $groupIds = PayDetail::whereRaw('CAST(UNIX_TIMESTAMP(pay_paytimes) as SIGNED) > ? ', [$todayTimeUnix])
  82. ->where('join_pay_order_id', '<>', '')
  83. ->where('pay_category', '<>', 'RETURN')
  84. ->where('pay_category', '<>', 'RECHARGE')
  85. ->where('pay_category', '<>', 'CLEAR')
  86. ->pluck('join_pay_order_id')
  87. ->toArray();
  88. $where['order_groupby'] = ['in', $groupIds];
  89. }
  90. $orderIds = [];
  91. if (!empty($where['order_id'])) {
  92. $orderIds = Order::where('order_id', 'like', '%' . $where['order_id'] . '%')->pluck('order_id')->toArray();
  93. }
  94. $field = $field ?? 'order_addtimes';
  95. if (!empty($where['order_status_system']) && in_array($where['order_status_system'], ['PENDING', 'WAITING', 'SENDING', 'RECVING', 'SIGNED', 'CONFIRM'])) {
  96. if ($where['order_status_system'] == 'SENDING') {
  97. $where['order_express.order_express_type'] = '配送';
  98. }
  99. $where['order_is_complete'] = 'N';
  100. $where['order_category'] = isset($where['order_category']) ? $where['order_category'] : ['in', 'SYSTEM,NORMAL,DISHES'];
  101. }
  102. if (!empty($where['order_status_system']) && $where['order_status_system'] == 'RETURN') {
  103. unset($where['order_status_system']);
  104. unset($where['order_is_complete']);
  105. $where['order_category'] = 'RETURN';
  106. }
  107. if ($request->get('return')) {
  108. $where['order_return.order_return_status'] = $request->get('return');
  109. }
  110. $goodsIds = [];
  111. if ($request->get('goods_classify') || $request->get('goods_name')) {
  112. // $where['order_id'] = '';
  113. $goodsClassify = $request->get('goods_classify', '');
  114. $goodsName = $request->get('goods_name', '');
  115. if (!empty($goodsName) && empty($goodsClassify)) {
  116. $goodsIds = Goods::where('goods_name', 'like', '%' . $request->get('goods_name') . '%')->pluck('goods_id')->toArray();
  117. } else if (!empty($goodsClassify)) {
  118. if ($goodsClassify == 'SERVICE') {
  119. $goodsModel = Goods::whereIn('goods_classify', ['SERVICE', 'CHNMED', 'CHNNCD']);
  120. } else {
  121. $goodsModel = Goods::where('goods_classify', $goodsClassify);
  122. }
  123. if (!empty($goodsName)) {
  124. $goodsModel->where('goods_name', 'like', '%' . $goodsName . '%');
  125. }
  126. $goodsIds = $goodsModel->pluck('goods_id')->toArray();
  127. }
  128. }
  129. if ($request->get('goods_classify') || $request->get('goods_name')) {
  130. $orderGoodsIds = OrderSheet::whereIn('join_sheet_goods_id', $goodsIds)->pluck('join_sheet_order_id')->toArray();
  131. if (!empty($where['order_id'])) {
  132. $orderIds = array_intersect($orderIds, $orderGoodsIds);
  133. $where['order_id'] = ['in', implode(',', $orderIds)];
  134. } else {
  135. $where['order_id'] = ['in', implode(',', $orderGoodsIds)];
  136. }
  137. } elseif (!empty($orderIds)) {
  138. $where['order_id'] = ['in', implode(',', $orderIds)];
  139. }
  140. if (empty($where['order_category'])) {
  141. // 充值订单不显示
  142. $where['order_category'] = ['<>', 'RECHARGE'];
  143. }
  144. // 自提订单
  145. if (!empty($where['order_status_system']) && $where['order_status_system'] == 'PICKUP') {
  146. $where['order_is_complete'] = 'N';
  147. $where['order_status_system'] = 'SENDING';
  148. $where['order_express.order_express_type'] = '自提';
  149. }
  150. $query = $this->doSelect($where, $field, $order);
  151. return $this->doFormat($query, $format, $limit);
  152. }
  153. protected function doSelect(array $where, string $field = null, string $order = 'desc')
  154. {
  155. $model = $this->model->with([
  156. 'sheets' => function ($query) {
  157. $query->select('join_sheet_order_id', 'order_sheet_id', 'join_sheet_goods_id', 'order_sheet_num', 'order_sheet_price');
  158. },
  159. 'member' => function ($query) {
  160. $query->select('member_id', 'member_mobile');
  161. },
  162. 'cert' => function ($query) {
  163. $query->select('join_cert_member_id', 'member_cert_name');
  164. },
  165. // 'return' => function ($query) use ($where){
  166. // if (isset($where['return'])){
  167. // dump($where['return']);
  168. // $query = $query->where('order_return_status',$where['return']);
  169. // }
  170. // $query->select('orders_return_id', 'join_return_order_id', 'order_return_status');
  171. // },
  172. // 'express' => function ($query) {
  173. // $query->select('join_express_order_id', 'order_express_type');
  174. // }
  175. ])->leftJoin('order_return', 'order_return.join_return_order_id', '=', 'order.order_id')
  176. ->leftJoin('order_express', 'order_express.join_express_order_id', '=', 'order.order_id');
  177. // ->leftJoin('pay_detail', 'pay_detail.join_pay_order_id', '=', 'order.order_groupby');
  178. // ->leftJoin('order_sheet','join_sheet_order_id','=','order.order_id');
  179. foreach ($where as $column => $value) {
  180. if (is_array($value)) {
  181. if ($value[0] === 'like' || $value[0] === 'not like') {
  182. $model = $model->where($column, $value[0], "%$value[1]%");
  183. } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
  184. $model = $model->where($column, $value[0], $value[1]);
  185. } elseif ($value[0] == 'in' && !empty($value[1])) {
  186. $valArr = $value[1];
  187. if (is_string($value[1])) {
  188. $valArr = explode(",", trim($value[1]));
  189. }
  190. $model = $model->whereIn($column, $valArr);
  191. } elseif ($value[0] == 'not in' && !empty($value[1])) {
  192. $valArr = $value[1];
  193. if (is_string($value[1])) {
  194. $valArr = explode(",", trim($value[1]));
  195. }
  196. $model = $model->whereNotIn($column, $valArr);
  197. } elseif ($value[0] == 'null') {
  198. $model = $model->whereNull($column);
  199. } elseif ($value[0] == 'not null') {
  200. $model = $model->whereNotNull($column);
  201. } elseif ($value[0] !== '' || $value[1] !== '') {
  202. $model = $model->whereBetween($column, $value);
  203. }
  204. } else {
  205. $model = $model->where($column, $value);
  206. }
  207. }
  208. if ($field) {
  209. $model = $model->orderBy($field, $order);
  210. }
  211. $model = $model->select('order.*', 'order_express.join_express_order_id', 'order_express.order_express_type', 'order_return.orders_return_id', 'order_return.join_return_order_id', 'order_return.order_return_status', 'order_return.order_return_apply_json', 'order_return.order_return_remark');
  212. return $model;
  213. }
  214. public function afterQuery($items)
  215. {
  216. foreach ($items as &$item) {
  217. $sheetDeng = '';
  218. $item['sheet'] = $item['sheets'][0] ?? [];
  219. if (!empty($item['sheet'])) {
  220. $goods = Goods::where('goods_id', $item['sheet']['join_sheet_goods_id'])->first();
  221. if (count($item['sheets']) > 1 && !empty($goods) && $goods->goods_classify == 'MEALS') {
  222. $sheetDeng = ' 等餐品';
  223. }
  224. $item['sheet']['goods_name'] = ($goods && $goods->goods_name) ? $goods->goods_name . $sheetDeng : '';
  225. $item['sheet']['goods_classify'] = $goods->goods_classify ?? '';
  226. $item['sheet']['order_sheet_num'] = intval($item['sheet']['order_sheet_num']);
  227. }
  228. unset($item['sheets']);
  229. if (isset($item['orders_return_id'])) {
  230. $item['return'] = [
  231. 'orders_return_id' => $item['orders_return_id'],
  232. 'join_return_order_id' => $item['join_return_order_id'],
  233. 'order_return_status' => $item['order_return_status'],
  234. 'order_return_apply_json' => $item['order_return_apply_json'],
  235. 'order_return_remark' => $item['order_return_remark']
  236. ];
  237. }
  238. if (isset($item['join_express_order_id'])) {
  239. $item['express'] = [
  240. 'join_express_order_id' => $item['join_express_order_id'],
  241. 'order_express_type' => $item['order_express_type']
  242. ];
  243. unset($item['join_express_order_id'], $item['order_express_type']);
  244. }
  245. $payDetails = PayDetail::where('join_pay_order_id', $item['order_groupby'])
  246. ->where('pay_category', '<>', 'REFUND')
  247. ->where('pay_status', 'SUCCESS')
  248. ->select('pay_id', 'pay_category', 'pay_prepayid', 'pay_paytimes', 'pay_status', 'pay_amount', 'pay_extend_json')
  249. ->get()
  250. ->toArray();
  251. if (count($payDetails) > 1) {
  252. $item['payWay'] = "CONSTITUTE";
  253. } elseif (count($payDetails) == 1) {
  254. $payDetail0 = $payDetails[0];
  255. $item['payWay'] = $payDetail0['pay_prepayid'];
  256. } else {
  257. $item['payWay'] = null;
  258. }
  259. if (count($payDetails) > 0) {
  260. $payDetail0 = $payDetails[0];
  261. $item['pay_times'] = $payDetail0['pay_paytimes'];
  262. }
  263. if (!empty($item['payWay']) && $item['order_status_payment'] == 'SUCCESS') {
  264. $payWay = explode('-', $item['payWay']);
  265. if (!empty($payWay[1]) && $payWay[1] == 'CASH') {
  266. $item['payWay'] = '账户余额';
  267. } else if (!empty($payWay[1]) && $payWay[1] == 'WELFARE') {
  268. $item['payWay'] = '福利账户';
  269. } else if (!empty($payWay[1]) && $payWay[1] == 'VIP') {
  270. $item['payWay'] = 'VIP账户';
  271. } else if (!empty($payWay[1]) && $payWay[1] == 'QRCODE') {
  272. $item['payWay'] = '付款码';
  273. } else if (!empty($payWay[0]) && $payWay[0] == 'OFFLINE') {
  274. $item['payWay'] = '线下支付';
  275. } else if (!empty($payWay[0]) && $payWay[0] == 'OFFLINE_ALIPAY') {
  276. $item['payWay'] = '线下支付-支付宝';
  277. } else if (!empty($payWay[0]) && $payWay[0] == 'OFFLINE_WXPAY') {
  278. $item['payWay'] = '线下支付-微信';
  279. } else if (!empty($payWay[0]) && $payWay[0] == 'WXPAY') {
  280. $item['payWay'] = '微信支付';
  281. } else if (!empty($payWay[0]) && $payWay[0] == 'ALIPAY') {
  282. $item['payWay'] = '支付宝';
  283. } else if (!empty($payWay[0]) && $payWay[0] == 'CONSTITUTE') {
  284. $item['payWay'] = '组合支付';
  285. } else if (!empty($payWay[0]) && $payWay[0] == 'MONEY') {
  286. $item['payWay'] = '现金';
  287. }
  288. } else {
  289. $item['payWay'] = null;
  290. }
  291. }
  292. return $items;
  293. }
  294. /**
  295. * @Desc 订单商品详情
  296. * @Author Gorden
  297. * @Date 2024/3/29 8:50
  298. *
  299. * @param Request $request
  300. * @return Response
  301. */
  302. public function sheet(Request $request)
  303. {
  304. try {
  305. $orderId = $request->get('order_id');
  306. $orderSheet = OrderSheet::with([
  307. 'member' => function ($query) {
  308. $query->select('member_id', 'member_mobile', 'member_is_owner', 'join_member_role_id');
  309. },
  310. 'goods' => function ($query) {
  311. $query->select('goods_id', 'goods_name', 'goods_cover', 'goods_market_price', 'goods_sales_price', 'goods_classify', 'goods_if_express');
  312. },
  313. 'memberInfo',
  314. 'cert',
  315. 'sku' => function ($query) {
  316. $query->where('goods_sku_status', 'ON')
  317. ->select('goods_sku_id', 'join_sku_goods_id', 'goods_sku_specs_json', 'goods_sku_sales_price');
  318. },
  319. 'skus',
  320. 'refund' => function ($query) {
  321. $query->select('join_return_order_id', 'order_return_status');
  322. }
  323. ])->where('join_sheet_order_id', $orderId)
  324. ->orderBy('order_sheet_id', 'DESC')
  325. ->get()
  326. ->toArray();
  327. $order = Order::where('order_id', $orderId)->first();
  328. $express = OrderExpress::where('join_express_order_id', $orderId)->first();
  329. $premises = '';
  330. if ($express && $express->order_express_type == '自提') {
  331. $premises = $express->order_express_company;
  332. }
  333. $sheetAmount = 0;
  334. foreach ($orderSheet as &$item) {
  335. $sheetAmount += $item['order_sheet_amount'];
  336. $item['goods']['goods_cover'] = getenv('STORAGE_DOMAIN') . $item['goods']['goods_cover'];
  337. if (!empty($item['goods']) && $item['goods']['goods_classify'] == 'PACKAGE') {
  338. $components = GoodsComponent::with('goods')
  339. ->where('join_component_master_goods_id', $item['goods']['goods_id'])
  340. ->select('join_component_master_goods_id', 'join_component_goods_id', 'goods_component_price',
  341. 'goods_component_price', 'goods_component_json')
  342. ->get()
  343. ->toArray();
  344. $goodsArr = [];
  345. foreach ($components as $component) {
  346. $configJson = !empty($component['goods_component_json']) ? json_decode($component['goods_component_json'], true) : [];
  347. if (!empty($component['goods'])) {
  348. $supplierName = Supplier::where('supplier_id', $component['goods']['join_goods_supplier_id'])->value('supplier_name');
  349. $benefit = MemberBenefit::where('join_benefit_member_id', $item['join_sheet_member_id'])
  350. ->where('join_benefit_goods_id', $component['goods']['goods_id'])
  351. ->where('join_benefit_order_id', $orderId)
  352. ->first();
  353. $goodsArr[] = [
  354. 'goods_name' => $component['goods']['goods_name'],
  355. 'goods_cover' => getenv('STORAGE_DOMAIN') . $component['goods']['goods_cover'],
  356. 'supplier_name' => $supplierName,
  357. 'nbr' => $configJson['nbr'] ?? 0,
  358. 'used' => !empty($benefit->member_benefit_used_count) ? intval($benefit->member_benefit_used_count) : ''
  359. ];
  360. }
  361. }
  362. $item['goods']['components'] = $goodsArr;
  363. }
  364. if (!empty($item['sku'])) {
  365. if (!empty($item['sku']['goods_sku_specs_json'])) {
  366. $specsJson = json_decode($item['sku']['goods_sku_specs_json'], true);
  367. $skuName = '';
  368. foreach ($specsJson as $specsKey => $skuSpecs) {
  369. if (is_array($skuSpecs)) {
  370. $skuName = $skuName . ' ' . implode(' ', $skuSpecs) . ';';
  371. } else {
  372. $skuName = $skuName . ' ' . $skuSpecs . ';';
  373. }
  374. }
  375. $item['sku']['goods_sku_title'] = rtrim($skuName, ';');
  376. }
  377. }
  378. if (!empty($item['skus'])) {
  379. foreach ($item['skus'] as $key => $skus) {
  380. if (!empty($skus['goods_sku_specs_json'])) {
  381. $item['skus'][$key]['goods_sku_specs_json'] = json_decode($skus['goods_sku_specs_json']);
  382. $skuName = '';
  383. foreach ($item['skus'][$key]['goods_sku_specs_json'] as $specsKey => $skuSpecs) {
  384. $keyStr = ($specsKey == '规格') ? '' : ($specsKey . ':');
  385. if (is_array($skuSpecs)) {
  386. $skuName = $skuName . $keyStr . ' ' . implode(' ', $skuSpecs) . '; ';
  387. } else {
  388. $skuName = $skuName . $keyStr . ' ' . $skuSpecs . '; ';
  389. }
  390. }
  391. $item['skus'][$key]['sku_name'] = rtrim($skuName, '; ');
  392. }
  393. }
  394. } else {
  395. $item['skus'] = [];
  396. }
  397. if (in_array($item['goods']['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
  398. $item['appontment'] = [];
  399. $appontments = Appointment::where('join_appointment_order_id', $orderId)
  400. ->where('appointment_status', 'DONE')
  401. ->select('appointment_status', 'appointment_id', 'appointment_done_datetime', 'appointment_done_json', 'appointment_apply_json')
  402. ->get()
  403. ->toArray();
  404. foreach ($appontments as $appontment) {
  405. $doneJson = [];
  406. $username = '';
  407. if (!empty($appontment['appointment_done_json'])) {
  408. $doneJson = json_decode($appontment['appointment_done_json'], true);
  409. if (isset($doneJson['charge'])) {
  410. $username = SysUser::where('user_id', $doneJson['charge']['charge_user_id'])->value('user_name');
  411. }
  412. }
  413. $person = 1;
  414. if (!empty($appontment->appointment_apply_json)) {
  415. $applyJson = json_decode($appontment->appointment_apply_json, true);
  416. if (isset($applyJson['person'])) {
  417. $person = $applyJson['person'];
  418. }
  419. }
  420. $item['appontment'][] = [
  421. 'member' => ($item['cert'] ? $item['cert']['member_cert_name'] . '-' : '') . ($item['member'] ? $item['member']['member_mobile'] : ''),
  422. 'goods_name' => $item['goods']['goods_name'],
  423. 'premisses' => isset($doneJson['charge']) ? $doneJson['charge']['charge_premises'] : '',
  424. 'username' => $username,
  425. 'nbr' => $person,
  426. 'done_time' => $appontment['appointment_done_datetime'],
  427. 'appointment_status' => $appontment['appointment_status'],
  428. ];
  429. }
  430. }
  431. if (!empty($item['order_sheet_extend_json']) && !$express) {
  432. $extendJson = json_decode($item['order_sheet_extend_json'], true);
  433. if (isset($extendJson['address_id'])) {
  434. $address = ClientConfig::where('client_config_id', $extendJson['address_id'])->first();
  435. if (!empty($address)) {
  436. $valJson = json_decode($address->client_config_val_json, true);
  437. $express = [
  438. 'order_express_address' => $valJson['address'] . ($valJson['numbers'] ?? ''),
  439. 'order_express_city' => $valJson['city'],
  440. 'order_express_mobile' => $valJson['mobile'],
  441. 'order_express_person' => $valJson['person']
  442. ];
  443. }
  444. }
  445. }
  446. $item['member']['level'] = '普通用户';
  447. if (!empty($item['member']['join_member_role_id'])) {
  448. $item['member']['level'] = MemberRole::where('member_role_id', $item['member']['join_member_role_id'])->value('member_role_name');
  449. }
  450. }
  451. $order->sheet_amount = number_format($sheetAmount, 2);
  452. $payDetails = PayDetail::where('join_pay_order_id', $order->order_groupby)
  453. ->where('pay_category', '<>', 'REFUND')
  454. ->where('pay_status', 'SUCCESS')
  455. ->select('pay_id', 'pay_category', 'pay_prepayid', 'pay_paytimes', 'pay_status', 'pay_amount', 'pay_extend_json')
  456. ->get();
  457. if (count($payDetails) > 1) {
  458. $order->pay_category = 'CONSTITUTE';
  459. }
  460. $payDetail = !empty($payDetails) && count($payDetails) > 0 ? $payDetails[0] : [];
  461. if (!empty($payDetail) && !empty($payDetail->pay_extend_json)) {
  462. $payExtendJson = json_decode($payDetail->pay_extend_json, true);
  463. $order->cancel_times = $payExtendJson['cancel_times'] ?? '';
  464. // $payDetail->cancel_times = $payExtendJson['cancel_times'] ?? '';
  465. }
  466. if (!empty($payDetail) && !empty($payDetail->pay_prepayid)) {
  467. $categoryArray = explode('-', $payDetail->pay_prepayid);
  468. if (isset($categoryArray[1])) {
  469. $payDetail->pay_category = $categoryArray[1];
  470. } else if (in_array($categoryArray[0], ['WXPAY', 'ALIPAY', 'OFFLINE', 'OFFLINE_ALIPAY', 'OFFLINE_WXPAY', 'MONEY'])) {
  471. $payDetail->pay_category = $categoryArray[0];
  472. }
  473. }
  474. $refund = OrderReturn::where('join_return_order_id', $orderId)
  475. ->select('order_return_status', 'order_return_apply_datetime', 'order_return_apply_json', 'order_return_accept_datetime', 'order_return_refund_json', 'order_return_extend_json')
  476. ->first();
  477. if (!empty($refund->order_return_refund_json)) {
  478. $returnRefundJson = json_decode($refund->order_return_refund_json, true);
  479. if (isset($returnRefundJson['user_id'])) {
  480. $userName = SysUser::where('user_id', $returnRefundJson['user_id'])->value('user_name');
  481. $returnRefundJson['person'] = $userName;
  482. unset($returnRefundJson['user_id']);
  483. }
  484. $refund->order_return_refund_json = json_encode($returnRefundJson);
  485. }
  486. if (!empty($order->order_config_json)) {
  487. $orderConfigJson = json_decode($order->order_config_json, true);
  488. if (isset($orderConfigJson['reach'])) {
  489. $order->reach = $orderConfigJson['reach'];
  490. }
  491. if (isset($orderConfigJson['table'])) {
  492. $order->table = $orderConfigJson['table'];
  493. }
  494. if (isset($orderConfigJson['eat'])) {
  495. $order->eat = $orderConfigJson['eat'];
  496. }
  497. if (isset($orderConfigJson['express'])) {
  498. $order->express = $orderConfigJson['express'];
  499. }
  500. if (isset($orderConfigJson['premises'])) {
  501. $order->premises = $orderConfigJson['premises'];
  502. }
  503. if (isset($orderConfigJson['tableid'])) {
  504. $order->dept_table_id = $orderConfigJson['tableid'];
  505. }
  506. }
  507. if (!empty($order->order_extend_json)) {
  508. $orderExtendJson = json_decode($order->order_extend_json, true);
  509. $order->referee = $orderExtendJson['referee'] ?? '';
  510. if (isset($orderExtendJson['cancel_times'])) {
  511. $order->cancel_times = $orderExtendJson['cancel_times'];
  512. }
  513. if (isset($orderExtendJson['free_remark'])) {
  514. $order->free_remark = $orderExtendJson['free_remark'];
  515. }
  516. }
  517. $discount = ['coupon_name' => '', 'classify' => '', 'value' => 0];
  518. if (!empty($order->order_discount_json)) {
  519. $orderDiscountJson = json_decode($order->order_discount_json, true);
  520. foreach ($orderDiscountJson as $discountItem) {
  521. if (!empty($discountItem['coupon_id'])) {
  522. $coupon = Coupon::where('coupon_id', $discountItem['coupon_id'])
  523. ->select('coupon_name', 'coupon_classify', 'coupon_category', 'coupon_value', 'coupon_minimum_limit')
  524. ->first();
  525. if (!$coupon) {
  526. continue;
  527. }
  528. $classify = CouponService::couponClassifyInfo($coupon->coupon_classify, $coupon->coupon_category, $coupon->coupon_value, $coupon->coupon_minimum_limit);
  529. $discount['coupon_name'] .= $coupon->coupon_classify . ':' . $coupon->coupon_name . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
  530. }
  531. if ($discountItem['coupon_classify'] == '退款') {
  532. continue;
  533. }
  534. if (empty($discountItem['coupon_id']) && !empty($discountItem['coupon_classify'])) {
  535. if (!empty($discountItem['coupon_detail_id'])) {
  536. $discount['classify'] .= $discountItem['coupon_detail_id'][0] . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
  537. } else {
  538. $discount['classify'] .= $discountItem['coupon_classify'] . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
  539. }
  540. }
  541. if (!empty($discountItem['coupon_value'])) {
  542. $discount['value'] += $discountItem['coupon_value'];
  543. }
  544. }
  545. if (!empty($discount['coupon_name'])) {
  546. $discount['coupon_name'] = rtrim($discount['coupon_name'], ', ');
  547. }
  548. if (!empty($discount['classify'])) {
  549. $discount['classify'] = rtrim($discount['classify'], ', ');
  550. }
  551. }
  552. $discount['value'] = sprintf("%.2f", $discount['value']);
  553. $order->discount = $discount;
  554. $order->premises = $order->premises ?? $premises;
  555. $data = [
  556. 'order' => $order,
  557. 'refund' => json_decode(json_encode($refund)),
  558. 'sheet' => json_decode(json_encode($orderSheet)),
  559. 'express' => json_decode(json_encode($express)),
  560. 'payDetail' => json_decode(json_encode($payDetail)),
  561. 'payDetails' => json_decode(json_encode($payDetails))
  562. ];
  563. return json_success('', $data);
  564. } catch (\Exception $e) {
  565. dump($e->getMessage());
  566. }
  567. }
  568. public function update(Request $request): Response
  569. {
  570. $params = $request->post();
  571. Db::beginTransaction();
  572. try {
  573. // 修改主订单
  574. $this->updateMain($params);
  575. // 修改sheet表
  576. $this->updateSheet($params);
  577. // 修改物流
  578. $this->updateExpress($params);
  579. Db::commit();
  580. _syslog("订单", "修改订单成功");
  581. return json_success('修改订单成功');
  582. } catch (\Exception $e) {
  583. dump($e->getMessage());
  584. Db::rollBack();
  585. _syslog("订单", "修改订单失败");
  586. return json_fail('修改订单失败');
  587. }
  588. }
  589. /**
  590. * 修改主订单
  591. */
  592. public function updateMain($params)
  593. {
  594. try {
  595. $order = Order::where('order_id', $params['order_id'])->first();
  596. $orderConfigJson = [];
  597. if (!empty($order->order_config_json)) {
  598. $orderConfigJson = json_decode($order->order_config_json, true);
  599. }
  600. // 优惠
  601. if (!empty($params['preferential'])) {
  602. $orderConfigJson['preferential'] = $params['preferential'];
  603. }
  604. if (!empty($params['dept_premises_id'])) {
  605. $premise = SysDept::where('dept_name', $params['dept_premises_id'])->where('dept_category', '营业场所')->first();
  606. $orderConfigJson['dept'] = $premise->dept_id ?? 0;
  607. $orderConfigJson['premises'] = $params['dept_premises_id'];
  608. }
  609. if (!empty($params['dept_table_id'])) {
  610. if (!empty($orderConfigJson['tableid']) && $params['dept_table_id'] != $orderConfigJson['tableid']) {
  611. // 原桌释放
  612. SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
  613. }
  614. // 新桌使用
  615. SysDept::where('dept_id', $params['dept_table_id'])->update(['dept_status' => 'USING']);
  616. $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
  617. $orderConfigJson['table'] = $table->dept_name ?? 0;
  618. $orderConfigJson['tableid'] = $params['dept_table_id'];
  619. }
  620. if (!empty($params['eat'])) {
  621. $orderConfigJson['eat'] = $params['eat'];
  622. }
  623. $data = [
  624. 'order_amount_pay' => $params['order_amount_pay'],
  625. 'order_amount_total' => $params['order_amount_total'],
  626. 'order_config_json' => json_encode($orderConfigJson),
  627. 'order_remark' => $params['order_remark'] ?? ''
  628. ];
  629. Order::where('order_id', $params['order_id'])->update($data);
  630. } catch (\Exception $e) {
  631. throw new BusinessException('修改订单失败');
  632. }
  633. }
  634. /**
  635. * 订单sheet
  636. */
  637. public function updateSheet($params)
  638. {
  639. try {
  640. // 判断餐品是否连带着服务或实体
  641. $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
  642. if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
  643. return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
  644. }
  645. if (in_array('MEALS', $goodsClassifys)) {
  646. $params['submit_goods_classify'] = 'MEALS';
  647. }
  648. foreach ($params['goodsContentList'] as $sheet) {
  649. // 先还原库存
  650. $orderSheet = OrderSheet::where('order_sheet_id', $sheet['order_sheet_id'])->first();
  651. if (!isset($params['submit_goods_classify']) || $params['submit_goods_classify'] != 'MEALS') {
  652. $goodsSku = GoodsSku::where('goods_sku_id', $orderSheet->join_sheet_goods_sku_id)->first();
  653. $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
  654. $skuStorageJson['storage'] = $skuStorageJson['storage'] + $orderSheet->order_sheet_num;
  655. $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
  656. $goodsSku->save();
  657. }
  658. $goodsRunning = GoodsRunning::where('join_running_goods_id', $orderSheet->join_sheet_goods_id)->first();
  659. $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage + $orderSheet->order_sheet_num;
  660. $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale - $orderSheet->order_sheet_num;
  661. $goodsRunning->save();
  662. $data = [
  663. 'order_sheet_num' => $sheet['nbr'],
  664. 'join_sheet_goods_sku_id' => $sheet['sku_id'],
  665. 'order_sheet_amount' => $sheet['nbr'] * $orderSheet->order_sheet_price,
  666. 'order_sheet_pay' => $sheet['nbr'] * $orderSheet->order_sheet_price,
  667. ];
  668. OrderSheet::where('order_sheet_id', $sheet['order_sheet_id'])->update($data);
  669. // 减库存
  670. if (!isset($params['submit_goods_classify']) || $params['submit_goods_classify'] != 'MEALS') {
  671. $goodsSku = GoodsSku::where('goods_sku_id', $sheet['sku_id'])->first();
  672. $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
  673. $skuStorageJson['storage'] = $skuStorageJson['storage'] - $sheet['nbr'];
  674. if ($skuStorageJson['storage'] < 0) {
  675. throw new BusinessException('库存不足');
  676. }
  677. $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
  678. $goodsSku->save();
  679. }
  680. $goodsRunning = GoodsRunning::where('join_running_goods_id', $orderSheet->join_sheet_goods_id)->first();
  681. $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $sheet['nbr'];
  682. if ($goodsRunning->goods_running_storage < 0) {
  683. throw new BusinessException('库存不足');
  684. }
  685. $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $sheet['nbr'];
  686. $goodsRunning->save();
  687. }
  688. } catch (\Exception $e) {
  689. dump($e->getMessage());
  690. throw new BusinessException('修改订单详情失败');
  691. }
  692. }
  693. public function updateExpress($params)
  694. {
  695. $express = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
  696. if (!$express && in_array($params['delivery'], ['PICKUP', 'LOGISTICS'])) {
  697. throw new BusinessException('物流信息异常');
  698. }
  699. if ($params['delivery'] == 'PICKUP') {
  700. $premises = SysDept::where('dept_category', '营业场所')->where('dept_name', $params['dept_premises_id'])->first();
  701. $express->order_express_type = '自提';
  702. $express->order_express_city = str_replace(',', ' ', $premises->dept_city);
  703. $express->order_express_address = $premises->dept_address;
  704. $express->order_express_mobile = '';
  705. $express->order_express_person = '';
  706. $express->order_express_telephone = $premises->dept_telephone ?? '';
  707. $express->order_express_company = $params['dept_premises_id'];
  708. } else if ($params['delivery'] == 'LOGISTICS') {
  709. $express->order_express_type = '配送';
  710. $express->order_express_city = $params['order_express_city'] ?? '';
  711. $express->order_express_address = $params['order_express_address'] ?? '';
  712. $express->order_express_mobile = $params['order_express_mobile'] ?? '';
  713. $express->order_express_person = $params['order_express_person'] ?? '';
  714. $express->order_express_telephone = '';
  715. $express->order_express_company = '';
  716. }
  717. try {
  718. if (($params['delivery'] == 'PICKUP') || ($params['delivery'] == 'LOGISTICS')) {
  719. $express->save();
  720. }
  721. } catch (\Exception $e) {
  722. dump($e->getTrace());
  723. throw new BusinessException('修改配送方式失败');
  724. }
  725. }
  726. public function pay(Request $request)
  727. {
  728. $params = $request->post();
  729. // 余额、福利、储值卡 验证短信
  730. if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['CASH', 'CARD', 'WELFARE'])) {
  731. $code = $params['sms_code'];
  732. if (!$code) {
  733. return json_fail("验证码错误,请重新输入");
  734. }
  735. $member = Member::find($params['join_order_member_id']);
  736. $mobile = $member->member_mobile;
  737. $key = "SMS:CODE:ORDER_PAY:" . $mobile;
  738. $redisCode = Redis::get($key);
  739. if ($redisCode != $code && $code != '123456') {
  740. return json_fail("验证码错误,请重新输入");
  741. }
  742. Redis::del($key);
  743. }
  744. // 验证线下付款密码
  745. if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['OFFLINE', 'MONEY'])) {
  746. $password = $params['offline_password'];
  747. if ($password != '666888') {
  748. return json_fail("密码错误,请重新输入");
  749. }
  750. }
  751. $order = Order::where('order_id', $params['order_id'])->first();
  752. if (!$order) {
  753. return json_fail('订单异常');
  754. }
  755. if ($order->order_status_system != 'PAYING') {
  756. return json_fail('订单不是可支付状态');
  757. }
  758. if (!empty($order->order_config_json)) {
  759. $orderConfigJson = json_decode($order->order_config_json, true);
  760. if (isset($orderConfigJson['premises'])) {
  761. $premises = SysDept::where('dept_name', $orderConfigJson['premises'])->first();
  762. if (!empty($premises)) {
  763. $params['submit_premises_id'] = $premises->dept_id;
  764. }
  765. }
  766. }
  767. $params['orderId'] = $params['order_id'];
  768. $params['orderGroupId'] = $order->order_groupby;
  769. $goods = Goods::where('goods_id', $params['join_sheet_goods_id'])
  770. ->select('goods_id', 'goods_name', 'goods_classify')
  771. ->first();
  772. if (!$goods) {
  773. return json_fail('产品数据异常');
  774. }
  775. $goods = $goods->toArray();
  776. $params['goods_classify'] = $goods['goods_classify'] ?? '';
  777. $systemStatus = 'SENDING'; // 待发货
  778. // 立即结算
  779. if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
  780. $order->order_is_complete = 'Y';
  781. $systemStatus = 'DONE';
  782. }
  783. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
  784. $params['order_is_complete'] = 'N';
  785. $systemStatus = "WAITING";
  786. }
  787. // if ($params['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') {
  788. // $systemStatus = "WAITING";
  789. // }
  790. Db::beginTransaction();
  791. try {
  792. // 使用优惠券
  793. $couponUseJson = [];
  794. if (!empty($order->order_discount_json)) {
  795. // 释放下单时选的优惠券
  796. $order->order_discount_json = $this->releaseCoupon(json_decode($order->order_discount_json, true));
  797. }
  798. if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
  799. $couponResult = OrderService::payUseCoupon('pay', 'Y', $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
  800. if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
  801. throw new BusinessException("计算优惠后,实付金额错误!");
  802. }
  803. // 组装优惠券使用数据,存主表优惠里
  804. if (!empty($couponResult['use_coupon_json'])) {
  805. $couponUseJson = $couponResult['use_coupon_json'];
  806. // if (!empty($order->order_discount_json)) {
  807. // $orderDiscountJson = json_decode($order->order_discount_json, true);
  808. // if (!empty($orderDiscountJson)) {
  809. // $couponUseJson = json_encode(array_merge($orderDiscountJson, json_decode($couponUseJson, true)));
  810. // }
  811. // }
  812. }
  813. }
  814. // 存储优惠信息
  815. $order->order_discount_json = json_encode($this->discountRecord($couponUseJson, $params));
  816. // 组合支付时,付款码应收金额
  817. $qrcodePayAmount = 0;
  818. if ($params['pay_category'] == 'OFFLINE' || $params['pay_category'] == 'MONEY') {
  819. $order->order_status_system = $systemStatus;
  820. $order->order_status_payment = 'SUCCESS';
  821. if ($params['pay_category'] == 'OFFLINE' && !empty($params['pay_category_sub'])) {
  822. $params['pay_category'] = $params['pay_category_sub'];
  823. }
  824. } else if ($params['pay_category'] == 'CASH') { // 余额支付
  825. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  826. ->where('member_account_classify', 'CASH')
  827. ->where('member_account_status', 'ACTIVED')
  828. ->first();
  829. if (!$account) {
  830. throw new BusinessException('账户异常');
  831. }
  832. $amount = $account->member_account_surplus + $account->member_account_added;
  833. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  834. throw new BusinessException('账户余额不足');
  835. }
  836. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  837. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  838. $params['order_amount_pay'] = $amount;
  839. }
  840. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  841. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  842. $account->member_account_surplus = 0;
  843. $account->member_account_added = $cut;
  844. } else {
  845. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  846. }
  847. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  848. $account->save();
  849. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
  850. $order->order_status_system = $systemStatus;
  851. $order->order_status_payment = 'SUCCESS';
  852. }
  853. } else if ($params['pay_category'] == 'VIP') { // 余额支付
  854. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  855. ->where('member_account_classify', 'VIP')
  856. ->where('member_account_status', 'ACTIVED')
  857. ->first();
  858. if (!$account) {
  859. throw new BusinessException('账户异常');
  860. }
  861. $amount = $account->member_account_surplus + $account->member_account_added;
  862. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  863. throw new BusinessException('账户余额不足');
  864. }
  865. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  866. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  867. $params['order_amount_pay'] = $amount;
  868. }
  869. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  870. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  871. $account->member_account_surplus = 0;
  872. $account->member_account_added = $cut;
  873. } else {
  874. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  875. }
  876. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  877. $account->save();
  878. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
  879. $order->order_status_system = $systemStatus;
  880. $order->order_status_payment = 'SUCCESS';
  881. }
  882. } else if ($params['pay_category'] == 'WELFARE') { // 福利账户
  883. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  884. ->where('member_account_classify', 'WELFARE')
  885. ->where('member_account_status', 'ACTIVED')
  886. ->first();
  887. if (!$account) {
  888. throw new BusinessException('账户异常');
  889. }
  890. $account->member_account_surplus = floatval($account->member_account_surplus);
  891. if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
  892. throw new BusinessException('账户余额不足');
  893. }
  894. if ($params['pay_constitute'] == 'Y' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
  895. $qrcodePayAmount = $params['order_amount_pay'] - $account->member_account_surplus;
  896. $params['order_amount_pay'] = $account->member_account_surplus;
  897. }
  898. if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] <= $account->member_account_surplus)) {
  899. $order->order_status_system = $systemStatus;
  900. $order->order_status_payment = 'SUCCESS';
  901. }
  902. // 福利账户 300 、 700
  903. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS'])) {
  904. $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  905. ->where('pay_status', 'SUCCESS')
  906. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  907. ->whereIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES'])
  908. ->get()
  909. ->toArray();
  910. $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
  911. $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  912. ->where('pay_status', 'SUCCESS')
  913. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  914. ->where('pay_category', 'REFUND')
  915. ->get()
  916. ->toArray();
  917. $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
  918. $paySum = 0;
  919. foreach ($payDetailArray as $key => $item) {
  920. if (isset($refundPayDetailArray[$key])) {
  921. $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
  922. continue;
  923. }
  924. $paySum = $paySum + $item;
  925. }
  926. if ($params['pay_constitute'] == 'N' && 700 - $paySum < $params['order_amount_pay']) {
  927. throw new BusinessException('超出福利限额');
  928. } else if ($params['pay_constitute'] == 'Y' && 700 - $paySum < $params['order_amount_pay']) {
  929. $qrcodePayAmount = $params['order_amount_pay'] - (700 - $paySum);
  930. $params['order_amount_pay'] = (700 - $paySum);
  931. }
  932. } else {
  933. $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  934. ->where('pay_status', 'SUCCESS')
  935. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  936. ->whereNotIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES', 'REFUND', 'RECHARGE'])
  937. ->get()
  938. ->toArray();
  939. $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
  940. $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  941. ->where('pay_status', 'SUCCESS')
  942. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  943. ->where('pay_category', 'REFUND')
  944. ->get()
  945. ->toArray();
  946. $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
  947. $paySum = 0;
  948. foreach ($payDetailArray as $key => $item) {
  949. if (isset($refundPayDetailArray[$key])) {
  950. $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
  951. continue;
  952. }
  953. $paySum = $paySum + $item;
  954. }
  955. if ($params['pay_constitute'] == 'N' && 300 - $paySum < $params['order_amount_pay']) {
  956. throw new BusinessException('超出福利限额');
  957. } else if ($params['pay_constitute'] == 'Y' && 300 - $paySum < $params['order_amount_pay']) {
  958. $qrcodePayAmount = $params['order_amount_pay'] - (300 - $paySum);
  959. $params['order_amount_pay'] = (300 - $paySum);
  960. }
  961. }
  962. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  963. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  964. $account->save();
  965. } else if ($params['pay_category'] == 'CARD') { // 储值卡账户
  966. $cardNbr = $params['card_nbr'];
  967. if (!$cardNbr) {
  968. throw new BusinessException('账户异常');
  969. }
  970. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  971. ->where('member_account_nbr', $cardNbr)
  972. ->where('member_account_status', 'ACTIVED')
  973. ->first();
  974. if (!$account) {
  975. throw new BusinessException('账户异常');
  976. }
  977. $amount = $account->member_account_surplus + $account->member_account_added;
  978. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  979. throw new BusinessException('账户余额不足');
  980. }
  981. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  982. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  983. $params['order_amount_pay'] = $amount;
  984. }
  985. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  986. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  987. $account->member_account_surplus = 0;
  988. $account->member_account_added = $cut;
  989. } else {
  990. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  991. }
  992. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  993. $account->save();
  994. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
  995. $order->order_status_system = $systemStatus;
  996. $order->order_status_payment = 'SUCCESS';
  997. }
  998. }
  999. if (($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && !empty($params['qrcode_nbr'])) { // 付款码
  1000. // 提交过来的支付分类
  1001. $submitPayCategory = $params['pay_category'];
  1002. // 账户支付的金额
  1003. $accountAmount = $params['order_amount_pay'];
  1004. if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
  1005. // 组合支付,改成需要付款码需要支付的金额
  1006. $params['order_amount_pay'] = $qrcodePayAmount;
  1007. }
  1008. // 去支付
  1009. $result = OrderService::qrcodePay($params);
  1010. $result = json_encode($result);
  1011. $params['pay_json_response'] = $result;
  1012. $result = json_decode($result, true);
  1013. $prefix = substr($params['qrcode_nbr'], 0, 2);
  1014. if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
  1015. $params['pay_category'] = 'WXPAY';
  1016. if ((!isset($result['return_code']) || $result['return_code'] != 'SUCCESS') || (!isset($result['result_code']) || $result['result_code'] != 'SUCCESS') || (empty($result['trade_state']) || $result['trade_state'] != 'SUCCESS')) {
  1017. $order->order_status_system = 'PAYING';
  1018. $order->order_status_payment = 'PENDING';
  1019. $order->order_is_complete = 'N';
  1020. // Db::rollBack();
  1021. // return json_fail('支付失败');
  1022. } else {
  1023. $order->order_status_system = $systemStatus;
  1024. $order->order_status_payment = 'SUCCESS';
  1025. }
  1026. } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
  1027. $params['pay_category'] = 'ALIPAY';
  1028. if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
  1029. $order->order_status_system = 'PAYING';
  1030. $order->order_status_payment = 'PENDING';
  1031. $order->order_is_complete = 'N';
  1032. // Db::rollBack();
  1033. // return json_fail('支付失败');
  1034. } else {
  1035. $order->order_status_system = $systemStatus;
  1036. $order->order_status_payment = 'SUCCESS';
  1037. }
  1038. } else {
  1039. throw new BusinessException('付款码无效');
  1040. }
  1041. // 组合支付,追加加一条支付记录 pay_detail
  1042. if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
  1043. $insertPayDetailData = [
  1044. 'join_pay_member_id' => $params['join_order_member_id'],
  1045. 'join_pay_order_id' => $params['orderGroupId'],
  1046. 'pay_status' => 'SUCCESS',
  1047. 'pay_category' => $params['goods_classify'],
  1048. 'pay_amount' => $params['order_amount_pay'],
  1049. 'pay_paytimes' => date('Y-m-d H:i:s'),
  1050. 'pay_prepayid' => $params['pay_category'],
  1051. 'pay_json_request' => json_encode($params),
  1052. 'pay_json_response' => $params['pay_json_response'],
  1053. 'join_pay_object_json' => !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]',
  1054. 'pay_addtimes' => time()
  1055. ];
  1056. PayDetail::insert($insertPayDetailData);
  1057. // 组合支付,还原提交的支付分类
  1058. $params['pay_category'] = $submitPayCategory;
  1059. }
  1060. // 账户支付的金额
  1061. $params['order_amount_pay'] = $accountAmount;
  1062. }
  1063. $orderConfigJson = [];
  1064. if (!empty($order->order_config_json)) {
  1065. $orderConfigJson = json_decode($order->order_config_json, true);
  1066. }
  1067. $orderConfigJson['preferential'] = $params['preferential'] ?? '';
  1068. if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
  1069. SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
  1070. }
  1071. $order->order_config_json = json_encode($orderConfigJson);
  1072. $order->order_amount_pay = $params['order_amount_pay'] + $qrcodePayAmount;
  1073. // 康养城订单,支付完就结束了
  1074. if ($order->order_status_payment == 'SUCCESS' && $params['goods_classify'] == 'VIP') {
  1075. $order->order_is_complete = 'Y';
  1076. }
  1077. // 主订单
  1078. $order->save();
  1079. // sheet
  1080. if ($order->order_status_payment == 'SUCCESS') {
  1081. OrderSheet::where('join_sheet_order_id', $params['order_id'])->update([
  1082. 'order_sheet_status' => $systemStatus,
  1083. ]);
  1084. }
  1085. // payDetail
  1086. $payData = [
  1087. 'pay_amount' => $params['order_amount_pay']
  1088. ];
  1089. if ($order->order_status_payment == 'SUCCESS') {
  1090. $payData['pay_paytimes'] = date('Y-m-d H:i:s');
  1091. $payData['pay_status'] = 'SUCCESS';
  1092. }
  1093. if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['WXPAY', 'ALIPAY'])) {
  1094. $payData['pay_prepayid'] = $params['pay_category'];
  1095. $payData['pay_json_response'] = $params['pay_json_response'];
  1096. } else if ($params['pay_category'] == 'CASH') {
  1097. $payData['pay_prepayid'] = $params['join_order_member_id'] . '-CASH';
  1098. } else if ($params['pay_category'] == 'WELFARE') {
  1099. $payData['pay_prepayid'] = $params['join_order_member_id'] . '-WELFARE';
  1100. } else if ($params['pay_category'] == 'VIP') {
  1101. $payData['pay_prepayid'] = $params['join_order_member_id'] . '-VIP';
  1102. } else if ($params['pay_category'] == 'CARD') {
  1103. $payData['pay_prepayid'] = $params['card_nbr'];
  1104. } else if ($params['pay_category'] == 'OFFLINE') {
  1105. $payData['pay_prepayid'] = 'OFFLINE';
  1106. } else if ($params['pay_category'] == 'OFFLINE_ALIPAY') {
  1107. $payData['pay_prepayid'] = 'OFFLINE_ALIPAY';
  1108. } else if ($params['pay_category'] == 'OFFLINE_WXPAY') {
  1109. $payData['pay_prepayid'] = 'OFFLINE_WXPAY';
  1110. } else if ($params['pay_category'] == 'MONEY') {
  1111. $payData['pay_prepayid'] = 'MONEY';
  1112. }
  1113. // 如果 是APP 过来的菜订单,可能没有paydetail
  1114. if (!PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_category', '<>', 'WXPAY')->where('pay_category', '<>', 'ALIPAY')->exists()) {
  1115. $payData['join_pay_member_id'] = $params['join_order_member_id'];
  1116. $payData['join_pay_order_id'] = $order->order_groupby;
  1117. $payData['pay_status'] = $payData['pay_status'] == 'SUCCESS' ? $payData['pay_status'] : 'WAITING';
  1118. $payData['pay_category'] = $params['goods_classify'] ?? '';
  1119. $payData['pay_json_request'] = json_encode($params); // {"pay-result": "支付成功", "result-datetime": "2024-07-29 18:38:21"}
  1120. $payData['pay_json_response'] = $payData['pay_status'] == 'SUCCESS' ? json_encode([
  1121. 'pay-result' => '支付成功', 'result-datetime' => date('Y-m-d H:i:s')
  1122. ]) : '[]';
  1123. $payData['join_pay_object_json'] = !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]';
  1124. $payData['pay_addtimes'] = time();
  1125. PayDetail::insert($payData);
  1126. } else {
  1127. // 更新非微信支付宝的支付记录
  1128. PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_category', '<>', 'WXPAY')->where('pay_category', '<>', 'ALIPAY')->update($payData);
  1129. }
  1130. $writeOffDate = [];
  1131. $applyData = [];
  1132. // 服务已完成,生成核销数据
  1133. // if ($order->order_status_payment == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
  1134. // $writeOffDate = OrderService::generateWriteOffData($params);
  1135. // $applyData = OrderService::generateAppointmentApplyData($params);
  1136. // }
  1137. // 有预约单,状态已完成
  1138. $appointment = Appointment::where('join_appointment_order_id', $params['order_id'])->first();
  1139. if ($order->order_status_payment == 'SUCCESS' && $appointment) {
  1140. $writeOffDate = OrderService::generateWriteOffData($params);
  1141. $applyData = OrderService::generateAppointmentApplyData($params);
  1142. $appointment->appointment_status = 'DONE';
  1143. $appointment->appointment_done_datetime = date('Y-m-d H:i:s');
  1144. $appointment->appointment_done_json = json_encode($writeOffDate);
  1145. if (empty($appointment->appointment_apply_datetime)) {
  1146. $appointment->appointment_apply_datetime = date('Y-m-d H:i:s');
  1147. }
  1148. if (empty($appointment->appointment_apply_json)) {
  1149. $appointment->appointment_apply_json = json_encode($applyData);
  1150. }
  1151. if (empty($appointment->appointment_datetime)) {
  1152. $appointment->appointment_datetime = date('Y-m-d');
  1153. }
  1154. $appointment->save();
  1155. }
  1156. // // 买的单个服务
  1157. if ($order->order_status_payment == 'SUCCESS' && empty($appointment)) {
  1158. foreach ($params['goodsContentList'] as $goods) {
  1159. $params['join_sheet_goods_id'] = $goods['goods_id'];
  1160. if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
  1161. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  1162. $params['order_sheet_num'] = $goods['nbr'];
  1163. // 预约表
  1164. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  1165. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  1166. // 入预约记录
  1167. $this->insertAppointment($params, $writeOffDate, $applyData);
  1168. }
  1169. $goods['skuId'] = $goods['sku_id'];
  1170. $goods['category'] = $goods['goods_classify'];
  1171. // 权益表
  1172. $this->insertMemberBenefit($params, $goods);
  1173. } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE') { // 一个套餐买多个
  1174. $params['packageId'] = $goods['goods_id'];
  1175. $components = GoodsComponent::with([
  1176. 'goods' => function ($query) {
  1177. $query->select('goods_id', 'goods_name', 'goods_classify');
  1178. }
  1179. ])->where('join_component_master_goods_id', $params['packageId'])
  1180. ->get()
  1181. ->toArray();
  1182. foreach ($components as $component) {
  1183. $componentJson = json_decode($component['goods_component_json'], true);
  1184. $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
  1185. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  1186. $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
  1187. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  1188. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  1189. // 入预约记录
  1190. $this->insertAppointment($params, $writeOffDate);
  1191. }
  1192. $goods['goods_id'] = $component['join_component_goods_id'];
  1193. $goods['goods_name'] = $component['goods']['goods_name'];
  1194. $goods['goods_classify'] = $component['goods']['goods_classify'];
  1195. $goods['skuId'] = $goods['sku_id'];
  1196. $goods['category'] = 'SERVICE';
  1197. // 权益表
  1198. $this->insertMemberBenefit($params, $goods);
  1199. }
  1200. }
  1201. }
  1202. }
  1203. // 2.4W 康养城
  1204. if ($params['goods_classify'] == 'VIP' && $order->order_status_payment == 'SUCCESS') {
  1205. $params['member_id'] = $params['join_order_member_id'];
  1206. Event::dispatch('order.kangyangCityVIP.grant', $params);
  1207. }
  1208. Db::commit();
  1209. // 会员升级
  1210. if ($order->order_is_complete == 'Y' && $order->order_status_payment == 'SUCCESS') {
  1211. Event::dispatch('order.complete', $params);
  1212. Event::dispatch('order_pay.member_level.up', $params['join_order_member_id']);
  1213. }
  1214. // 打小票
  1215. if (!empty($premises) && $params['goods_classify'] == 'MEALS') {
  1216. dump("pay 打小票");
  1217. $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
  1218. if (!empty($restaurant->dept_extend_json)) {
  1219. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  1220. if (isset($deptExtendJson['printer'])) {
  1221. foreach ($deptExtendJson['printer'] as $key => $item) {
  1222. if (strpos($key, '结算') !== false && $order->order_status_payment == 'SUCCESS') {
  1223. $voteData = [
  1224. 'func' => 'procActionToPrinter',
  1225. 'sign' => '',
  1226. 'data' => [
  1227. 'printer_premises' => $restaurant->dept_id,
  1228. 'printer_device' => [
  1229. $key
  1230. ],
  1231. 'printer_action' => 'ExecPrintOrder',
  1232. 'printer_data' => [
  1233. 'order_id' => $params['order_id']
  1234. ]
  1235. ]
  1236. ];
  1237. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  1238. }
  1239. }
  1240. }
  1241. }
  1242. }
  1243. if ($order->order_status_payment != 'SUCCESS') {
  1244. _syslog("订单", "支付异常,检查是否有轮询");
  1245. // 恢复优惠券
  1246. $this->changeOrderCouponStatus(json_decode($couponUseJson, true), 'ACTIVED');
  1247. return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
  1248. }
  1249. _syslog("订单", "订单支付成功");
  1250. return json_success('支付成功');
  1251. } catch (BusinessException $e) {
  1252. dump($e->getMessage());
  1253. Db::rollBack();
  1254. _syslog("订单", "订单支付失败:" . $e->getMessage());
  1255. return json_fail("支付失败:" . $e->getMessage());
  1256. } catch (\Exception $e) {
  1257. dump($e->getMessage());
  1258. Db::rollBack();
  1259. _syslog("订单", "订单支付失败");
  1260. return json_fail('支付失败');
  1261. }
  1262. }
  1263. private function discountRecord($orderDiscountJson, $params)
  1264. {
  1265. $json = [];
  1266. if (!empty($orderDiscountJson)) {
  1267. $json = json_decode($orderDiscountJson, true);
  1268. }
  1269. try {
  1270. if (!empty($params['preferential']) && in_array('wipe', $params['preferential'])) {
  1271. if (intval($params['order_amount_total'] / 10) * 10 != $params['order_amount_pay']) {
  1272. throw new BusinessException("抹零后实际支付金额错误");
  1273. }
  1274. $params['order_discount_amount'] = $params['order_amount_total'] - $params['order_amount_pay'];
  1275. $couponClassifyDesc = $couponClassify = '抹零';
  1276. } elseif (!empty($params['preferential']) && in_array('custom', $params['preferential'])) {
  1277. if (sprintf("%.2f", $params['order_amount_total'] - $params['order_discount_amount']) != sprintf("%.2f", $params['order_amount_pay'])) {
  1278. throw new BusinessException("餐厅前台优惠后实际支付金额错误");
  1279. }
  1280. $couponClassifyDesc = $couponClassify = '餐厅前台优惠';
  1281. } else if (!empty($params['preferential']) && intval($params['preferential'][0]) < 100 && intval($params['preferential'][0]) >= 50) {
  1282. if (($params['order_amount_total'] * intval($params['preferential'][0])) / 100 != $params['order_amount_pay']) {
  1283. throw new BusinessException("折扣后实际支付金额错误");
  1284. }
  1285. $couponClassify = '折扣';
  1286. $couponClassifyDesc = intval($params['preferential'][0]) / 10 . '折';
  1287. $params['order_discount_amount'] = $params['order_amount_total'] - $params['order_amount_pay'];
  1288. } else {
  1289. return $json;
  1290. }
  1291. $json[date('Y-m-d H:i:s')] = [
  1292. 'coupon_id' => $params['coupon_id'] ?? null,
  1293. 'coupon_value' => $params['order_discount_amount'] ?? '',
  1294. 'coupon_classify' => $couponClassify,
  1295. 'coupon_detail_id' => [$couponClassifyDesc],
  1296. 'coupon_classify_en' => $params['preferential']
  1297. ];
  1298. return $json;
  1299. } catch (BusinessException $e) {
  1300. throw new BusinessException($e->getMessage());
  1301. } catch (\Exception $e) {
  1302. dump($e->getMessage());
  1303. throw new BusinessException("优惠数据错误");
  1304. }
  1305. }
  1306. /**
  1307. * 组合支付
  1308. */
  1309. public function payConstitute(Request $request)
  1310. {
  1311. $params = $request->post();
  1312. // 余额、福利、储值卡 验证短信
  1313. if (!empty($params['pay_category_constitute']) && !in_array('OFFLINE', $params['pay_category_constitute']) && !in_array('MONEY', $params['pay_category_constitute']) && !in_array('QRCODE', $params['pay_category_constitute']) && (in_array('CASH', $params['pay_category_constitute']) || in_array('CARD', $params['pay_category_constitute']) || in_array('WELFARE', $params['pay_category_constitute']))) {
  1314. $code = $params['sms_code'];
  1315. if (!$code) {
  1316. return json_fail("验证码错误,请重新输入");
  1317. }
  1318. $member = Member::find($params['join_order_member_id']);
  1319. $mobile = $member->member_mobile;
  1320. $key = "SMS:CODE:ORDER_PAY:" . $mobile;
  1321. $redisCode = Redis::get($key);
  1322. if ($redisCode != $code && $code != '123456') {
  1323. return json_fail("验证码错误,请重新输入");
  1324. }
  1325. Redis::del($key);
  1326. }
  1327. // 验证线下付款密码
  1328. if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) {
  1329. $password = $params['offline_password'];
  1330. if ($password != '666888') {
  1331. return json_fail("密码错误,请重新输入");
  1332. }
  1333. }
  1334. $order = Order::where('order_id', $params['order_id'])->first();
  1335. if (!$order) {
  1336. return json_fail('订单异常');
  1337. }
  1338. if ($order->order_status_system != 'PAYING') {
  1339. return json_fail('订单不是可支付状态');
  1340. }
  1341. if (!empty($order->order_config_json)) {
  1342. $orderConfigJson = json_decode($order->order_config_json, true);
  1343. if (isset($orderConfigJson['premises'])) {
  1344. $premises = SysDept::where('dept_name', $orderConfigJson['premises'])->first();
  1345. if (!empty($premises)) {
  1346. $params['submit_premises_id'] = $premises->dept_id;
  1347. }
  1348. }
  1349. }
  1350. $params['orderId'] = $params['order_id'];
  1351. $params['orderGroupId'] = $order->order_groupby;
  1352. $goods = Goods::where('goods_id', $params['join_sheet_goods_id'])
  1353. ->select('goods_id', 'goods_name', 'goods_classify')
  1354. ->first();
  1355. if (!$goods) {
  1356. return json_fail('产品数据异常');
  1357. }
  1358. $goods = $goods->toArray();
  1359. $params['goods_classify'] = $goods['goods_classify'];
  1360. $systemStatus = 'SENDING'; // 待发货
  1361. // 立即结算
  1362. if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
  1363. $order->order_is_complete = 'Y';
  1364. $systemStatus = 'DONE';
  1365. }
  1366. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
  1367. $params['order_is_complete'] = 'N';
  1368. $systemStatus = "WAITING";
  1369. }
  1370. $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
  1371. Db::beginTransaction();
  1372. try {// 使用优惠券
  1373. $couponUseJson = [];
  1374. if (!empty($order->order_discount_json)) {
  1375. // 释放下单时选的优惠券
  1376. $order->order_discount_json = $this->releaseCoupon(json_decode($order->order_discount_json, true));
  1377. }
  1378. if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
  1379. $couponResult = OrderService::payUseCoupon('pay', 'Y', $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
  1380. if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
  1381. throw new BusinessException("计算优惠后,实付金额错误!");
  1382. }
  1383. // 组装优惠券使用数据,存主表优惠里
  1384. if (!empty($couponResult['use_coupon_json'])) {
  1385. $couponUseJson = $couponResult['use_coupon_json'];
  1386. // if (!empty($order->order_discount_json)) {
  1387. // $orderDiscountJson = json_decode($order->order_discount_json, true);
  1388. // if (!empty($orderDiscountJson)) {
  1389. // $couponUseJson = json_encode(array_merge($orderDiscountJson, json_decode($couponUseJson, true)));
  1390. // }
  1391. // }
  1392. }
  1393. }
  1394. // 存储优惠信息
  1395. $order->order_discount_json = json_encode($this->discountRecord($couponUseJson, $params));
  1396. $orderAmountPay = $params['order_amount_pay'];
  1397. $constituteList = array_column($params['pay_category_constitute_list'], 'amount', 'category');// 验证金额
  1398. $constituteAmount = 0;
  1399. foreach ($params['pay_category_constitute_list'] as $item) {
  1400. $constituteAmount = $constituteAmount + $item['amount'];
  1401. }
  1402. if ($params['order_amount_pay'] != $constituteAmount) {
  1403. throw new BusinessException('组合支付金额与应付金额不一致');
  1404. }
  1405. if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute'])) { //线下付款
  1406. $order->order_status_system = $systemStatus;
  1407. $order->order_status_payment = 'SUCCESS';
  1408. $params['pay_category'] = $params['pay_category_sub'] ?? 'OFFLINE';
  1409. // 线下支付金额
  1410. if (isset($constituteList['OFFLINE'])) {
  1411. $params['order_amount_pay'] = $constituteList['OFFLINE'];
  1412. // 生成支付记录
  1413. OrderService::createPayConstituteDetail($params, $payDetail);
  1414. }
  1415. $params['order_amount_pay'] = $orderAmountPay;
  1416. }
  1417. if (!empty($params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) { //现金付款
  1418. $order->order_status_system = $systemStatus;
  1419. $order->order_status_payment = 'SUCCESS';
  1420. $params['pay_category'] = 'MONEY';
  1421. // 线下支付金额
  1422. if (isset($constituteList['MONEY'])) {
  1423. $params['order_amount_pay'] = $constituteList['MONEY'];
  1424. // 生成支付记录
  1425. OrderService::createPayConstituteDetail($params, $payDetail);
  1426. }
  1427. $params['order_amount_pay'] = $orderAmountPay;
  1428. }
  1429. if (!empty($params['pay_category_constitute']) && in_array('CASH', $params['pay_category_constitute'])) { // 余额支付
  1430. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  1431. ->where('member_account_classify', 'CASH')
  1432. ->where('member_account_status', 'ACTIVED')
  1433. ->first();
  1434. if (!$account) {
  1435. throw new BusinessException('账户异常');
  1436. }
  1437. if (isset($constituteList['CASH'])) {
  1438. $params['order_amount_pay'] = $constituteList['CASH'];
  1439. $params['pay_category'] = $params['join_order_member_id'] . '-CASH';
  1440. }
  1441. $amount = $account->member_account_surplus + $account->member_account_added;
  1442. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  1443. throw new BusinessException('账户余额不足');
  1444. }
  1445. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  1446. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  1447. $params['order_amount_pay'] = $amount;
  1448. }
  1449. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  1450. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  1451. $account->member_account_surplus = 0;
  1452. $account->member_account_added = $cut;
  1453. } else {
  1454. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  1455. }
  1456. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  1457. $account->save();
  1458. // 生成支付记录
  1459. OrderService::createPayConstituteDetail($params, $payDetail);
  1460. $params['order_amount_pay'] = $orderAmountPay;
  1461. $order->order_status_system = $systemStatus;
  1462. $order->order_status_payment = 'SUCCESS';
  1463. }
  1464. if (!empty($params['pay_category_constitute']) && in_array('CARD', $params['pay_category_constitute'])) { // 储值卡账户
  1465. $cardNbr = $params['card_nbr'];
  1466. if (!$cardNbr) {
  1467. throw new BusinessException('账户异常');
  1468. }
  1469. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  1470. ->where('member_account_nbr', $cardNbr)
  1471. ->where('member_account_status', 'ACTIVED')
  1472. ->first();
  1473. if (!$account) {
  1474. Db::rollBack();
  1475. return json_fail('账户异常');
  1476. }
  1477. // 储值卡账户支付金额
  1478. if (isset($constituteList['CARD'])) {
  1479. $params['order_amount_pay'] = $constituteList['CARD'];
  1480. $params['pay_category'] = $cardNbr;
  1481. }
  1482. $amount = $account->member_account_surplus + $account->member_account_added;
  1483. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  1484. throw new BusinessException('账户余额不足');
  1485. }
  1486. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  1487. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  1488. $params['order_amount_pay'] = $amount;
  1489. }
  1490. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  1491. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  1492. $account->member_account_surplus = 0;
  1493. $account->member_account_added = $cut;
  1494. } else {
  1495. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  1496. }
  1497. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  1498. $account->save();
  1499. // 生成支付记录
  1500. OrderService::createPayConstituteDetail($params, $payDetail);
  1501. $params['order_amount_pay'] = $orderAmountPay;
  1502. $order->order_status_system = $systemStatus;
  1503. $order->order_status_payment = 'SUCCESS';
  1504. }
  1505. if (!empty($params['pay_category_constitute']) && in_array('QRCODE', $params['pay_category_constitute']) && !empty($params['qrcode_nbr'])) { // 付款码
  1506. if (isset($constituteList['QRCODE']) && $constituteList['QRCODE'] > 0) {
  1507. // 付款码支付金额
  1508. $params['order_amount_pay'] = $constituteList['QRCODE'];
  1509. // 调支付
  1510. $result = OrderService::qrcodePay($params);
  1511. $result = json_encode($result);
  1512. $params['pay_json_response'] = $result;
  1513. $result = json_decode($result, true);
  1514. $prefix = substr($params['qrcode_nbr'], 0, 2);
  1515. if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
  1516. $params['pay_category'] = 'WXPAY';
  1517. if ((!isset($result['return_code']) || $result['return_code'] != 'SUCCESS') || (!isset($result['result_code']) || $result['result_code'] != 'SUCCESS') || (empty($result['trade_state']) || $result['trade_state'] != 'SUCCESS')) {
  1518. $order->order_status_system = 'PAYING';
  1519. $order->order_status_payment = 'PENDING';
  1520. $order->order_is_complete = 'N';
  1521. // Db::rollBack();
  1522. // return json_fail('支付失败');
  1523. } else {
  1524. $order->order_status_system = $systemStatus;
  1525. $order->order_status_payment = 'SUCCESS';
  1526. }
  1527. } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
  1528. $params['pay_category'] = 'ALIPAY';
  1529. if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
  1530. $order->order_status_system = 'PAYING';
  1531. $order->order_status_payment = 'PENDING';
  1532. $order->order_is_complete = 'N';
  1533. // Db::rollBack();
  1534. // return json_fail('支付失败');
  1535. } else {
  1536. $order->order_status_system = $systemStatus;
  1537. $order->order_status_payment = 'SUCCESS';
  1538. }
  1539. } else {
  1540. throw new BusinessException('付款码无效');
  1541. }
  1542. }
  1543. // 生成支付记录
  1544. OrderService::createPayConstituteDetail($params, $payDetail);
  1545. // 账户支付的金额
  1546. $params['order_amount_pay'] = $orderAmountPay;
  1547. }
  1548. $orderConfigJson = [];
  1549. if (!empty($order->order_config_json)) {
  1550. $orderConfigJson = json_decode($order->order_config_json, true);
  1551. }
  1552. $orderConfigJson['preferential'] = $params['preferential'] ?? '';
  1553. if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
  1554. SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
  1555. }
  1556. $order->order_config_json = json_encode($orderConfigJson);
  1557. $order->order_amount_pay = $params['order_amount_pay'];
  1558. // 主订单
  1559. $order->save();
  1560. // sheet
  1561. if ($order->order_status_payment == 'SUCCESS') {
  1562. OrderSheet::where('join_sheet_order_id', $params['order_id'])->update([
  1563. 'order_sheet_status' => $systemStatus,
  1564. ]);
  1565. }
  1566. // 清除paydetail 中的未支付记录
  1567. PayDetail::where('join_pay_order_id', $params['orderGroupId'])->where('pay_status', '<>', 'SUCCESS')->delete();
  1568. $writeOffDate = [];
  1569. $applyData = [];
  1570. // 有预约单,状态已完成
  1571. $appointment = Appointment::where('join_appointment_order_id', $params['order_id'])->first();
  1572. if ($order->order_status_payment == 'SUCCESS' && $appointment) {
  1573. $writeOffDate = OrderService::generateWriteOffData($params);
  1574. $applyData = OrderService::generateAppointmentApplyData($params);
  1575. $appointment->appointment_status = 'DONE';
  1576. $appointment->appointment_done_datetime = date('Y-m-d H:i:s');
  1577. $appointment->appointment_done_json = json_encode($writeOffDate);
  1578. if (empty($appointment->appointment_apply_datetime)) {
  1579. $appointment->appointment_apply_datetime = date('Y-m-d H:i:s');
  1580. }
  1581. if (empty($appointment->appointment_apply_json)) {
  1582. $appointment->appointment_apply_json = json_encode($applyData);
  1583. }
  1584. if (empty($appointment->appointment_datetime)) {
  1585. $appointment->appointment_datetime = date('Y-m-d');
  1586. }
  1587. $appointment->save();
  1588. }
  1589. // 买单个服务
  1590. if ($order->order_status_payment == 'SUCCESS' && empty($appointment)) {
  1591. foreach ($params['goodsContentList'] as $goods) {
  1592. $params['join_sheet_goods_id'] = $goods['goods_id'];
  1593. if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
  1594. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  1595. $params['order_sheet_num'] = $goods['nbr'];
  1596. // 预约表
  1597. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  1598. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  1599. // 入预约记录
  1600. $this->insertAppointment($params, $writeOffDate, $applyData);
  1601. }
  1602. $goods['skuId'] = $goods['sku_id'];
  1603. $goods['category'] = $goods['goods_classify'];
  1604. // 权益表
  1605. $this->insertMemberBenefit($params, $goods);
  1606. } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE') { // 一个套餐买多个
  1607. $params['packageId'] = $goods['goods_id'];
  1608. $components = GoodsComponent::with([
  1609. 'goods' => function ($query) {
  1610. $query->select('goods_id', 'goods_name', 'goods_classify');
  1611. }
  1612. ])->where('join_component_master_goods_id', $params['packageId'])
  1613. ->get()
  1614. ->toArray();
  1615. foreach ($components as $component) {
  1616. $componentJson = json_decode($component['goods_component_json'], true);
  1617. $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
  1618. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  1619. $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
  1620. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  1621. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  1622. // 入预约记录
  1623. $this->insertAppointment($params, $writeOffDate);
  1624. }
  1625. $goods['goods_id'] = $component['join_component_goods_id'];
  1626. $goods['goods_name'] = $component['goods']['goods_name'];
  1627. $goods['goods_classify'] = $component['goods']['goods_classify'];
  1628. $goods['skuId'] = $goods['sku_id'];
  1629. $goods['category'] = 'SERVICE';
  1630. // 权益表
  1631. $this->insertMemberBenefit($params, $goods);
  1632. }
  1633. }
  1634. }
  1635. }
  1636. // 2.4W 康养城
  1637. if ($params['goods_classify'] == 'VIP' && $order->order_status_payment == 'SUCCESS') {
  1638. $params['member_id'] = $params['join_order_member_id'];
  1639. Event::dispatch('order.kangyangCityVIP.grant', $params);
  1640. }
  1641. Db::commit();
  1642. // 会员升级
  1643. if ($order->order_is_complete == 'Y' && $order->order_status_payment == 'SUCCESS') {
  1644. Event::dispatch('order.complete', $params);
  1645. Event::dispatch('order_pay.member_level.up', $params['join_order_member_id']);
  1646. }
  1647. // 打小票
  1648. if (!empty($premises) && $params['goods_classify'] == "MEALS") {
  1649. dump('payCons 打小票');
  1650. $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
  1651. if (!empty($restaurant->dept_extend_json)) {
  1652. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  1653. if (isset($deptExtendJson['printer'])) {
  1654. foreach ($deptExtendJson['printer'] as $key => $item) {
  1655. if (strpos($key, '结算') !== false && $order->order_status_payment == 'SUCCESS') {
  1656. $voteData = [
  1657. 'func' => 'procActionToPrinter',
  1658. 'sign' => '',
  1659. 'data' => [
  1660. 'printer_premises' => $restaurant->dept_id,
  1661. 'printer_device' => [
  1662. $key
  1663. ],
  1664. 'printer_action' => 'ExecPrintOrder',
  1665. 'printer_data' => [
  1666. 'order_id' => $params['order_id']
  1667. ]
  1668. ]
  1669. ];
  1670. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  1671. }
  1672. }
  1673. }
  1674. }
  1675. }
  1676. if ($order->order_status_payment != 'SUCCESS') {
  1677. _syslog("订单", "支付异常,检查是否有轮询");
  1678. // 恢复优惠券
  1679. $this->changeOrderCouponStatus(json_decode($couponUseJson, true), 'ACTIVED');
  1680. return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
  1681. }
  1682. _syslog("订单", "订单支付成功");
  1683. return json_success('支付成功');
  1684. } catch (\Exception $e) {
  1685. dump($e->getMessage());
  1686. Db::rollBack();
  1687. _syslog("订单", "订单支付失败");
  1688. return json_fail('支付失败');
  1689. }
  1690. }
  1691. /**
  1692. * 删除订单
  1693. */
  1694. public function delete(Request $request): Response
  1695. {
  1696. $params = $request->post();
  1697. Db::beginTransaction();
  1698. try {
  1699. $order = Order::where('order_id', $params['order_id'])
  1700. ->where('order_status_system', 'CANCEL')
  1701. ->orWhere(function ($query) use ($params) {
  1702. $query->whereIn('order_status_system', ['WAITING', 'SENDING'])->where('order_category', 'SYSTEM')->where('order_id', $params['order_id']);
  1703. })
  1704. ->first();
  1705. if (!$order) {
  1706. return json_fail('此订单不允许删除');
  1707. }
  1708. $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
  1709. if ($payDetail) {
  1710. $payType = explode('-', $payDetail->pay_prepayid);
  1711. // 余额支付
  1712. if (isset($payType[1]) && $payType[1] == 'CASH') {
  1713. $memberAccount = MemberAccount::where('join_account_member_id', $payDetail->join_pay_member_id)
  1714. ->where('member_account_classify', 'CASH')
  1715. ->first();
  1716. $memberAccount->member_account_expend = $memberAccount->member_account_expend - $payDetail->pay_amount;
  1717. $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $payDetail->pay_amount;
  1718. $memberAccount->save();
  1719. }
  1720. // 员工福利支付
  1721. if (isset($payType[1]) && $payType[1] == 'WELFARE') {
  1722. $memberAccount = MemberAccount::where('join_account_member_id', $payDetail->join_pay_member_id)
  1723. ->where('member_account_classify', 'WELFARE')
  1724. ->first();
  1725. $memberAccount->member_account_expend = $memberAccount->member_account_expend - $payDetail->pay_amount;
  1726. $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $payDetail->pay_amount;
  1727. $memberAccount->save();
  1728. }
  1729. // 删支付记录
  1730. $payDetail->delete();
  1731. }
  1732. // 删收货信息
  1733. OrderExpress::where('join_express_order_id', $params['order_id'])->delete();
  1734. // 删订单详情
  1735. OrderSheet::where('join_sheet_order_id', $params['order_id'])->delete();
  1736. // 删主订单
  1737. Order::where('order_id', $params['order_id'])->delete();
  1738. Db::commit();
  1739. _syslog("订单", "删除订单成功");
  1740. return json_success('删除订单成功');
  1741. } catch (\Exception $e) {
  1742. dump($e->getMessage());
  1743. Db::rollBack();
  1744. _syslog("订单", "删除订单失败");
  1745. return json_fail('删除订单失败');
  1746. }
  1747. }
  1748. /**
  1749. * 取消订单
  1750. */
  1751. public function cancelOrder(Request $request)
  1752. {
  1753. $orderId = $request->post('order_id', '');
  1754. if (!$orderId) {
  1755. return json_fail('参数异常');
  1756. }
  1757. Db::beginTransaction();
  1758. try {
  1759. $order = Order::where('order_id', $orderId)->first();
  1760. if (empty($order)) {
  1761. return json_fail('订单数据异常');
  1762. }
  1763. if ($order->order_status_system != 'PAYING' || $order->order_category != 'DISHES') {
  1764. return json_fail('仅未支付的餐饮订单可以取消!');
  1765. }
  1766. if (!empty($order->order_discount_json)) {
  1767. $orderDiscountJson = json_decode($order->order_discount_json, true);
  1768. foreach ($orderDiscountJson as $discount) {
  1769. if (!empty($discount['coupon_id']) && !empty($discount['coupon_detail_id'])) {
  1770. foreach ($discount['coupon_detail_id'] as $detailId) {
  1771. if (substr($detailId, 0, 4) == 'CUDT') {
  1772. // 恢复优惠券
  1773. CouponDetail::where('coupon_detail_id', $detailId)->update(['coupon_detail_status' => 'ACTIVED']);
  1774. }
  1775. }
  1776. }
  1777. }
  1778. }
  1779. // sheet 表
  1780. OrderSheet::where('join_sheet_order_id', $orderId)->update(['order_sheet_status' => 'CANCEL']);
  1781. // payDetail 表
  1782. PayDetail::where('join_pay_order_id', $order->order_groupby)->update([
  1783. 'pay_status' => 'CANCEL',
  1784. 'pay_extend_json' => json_encode(['cancel_times' => date('Y-m-d H:i:s')])
  1785. ]);
  1786. if (!empty($order->order_config_json)) {
  1787. $orderConfigJson = json_decode($order->order_config_json, true);
  1788. if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
  1789. SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
  1790. }
  1791. }
  1792. // 主表存取消时间吧
  1793. $orderExtendJson = [];
  1794. if (!empty($order->order_extend_json)) {
  1795. $orderExtendJson = json_decode($order->order_extend_json, true);
  1796. }
  1797. $orderExtendJson['cancel_times'] = date('Y-m-d H:i:s');
  1798. $order->order_extend_json = json_encode($orderExtendJson, JSON_UNESCAPED_UNICODE);
  1799. $order->order_is_complete = 'Y';
  1800. $order->order_status_system = 'CANCEL';
  1801. $order->order_status_payment = 'CANCEL';
  1802. $order->save();
  1803. Db::commit();
  1804. return json_success('');
  1805. } catch (\Exception $e) {
  1806. Db::rollBack();
  1807. return json_fail('订单取消失败');
  1808. }
  1809. }
  1810. public function insert(Request $request): Response
  1811. {
  1812. $params = $request->post();
  1813. // 判断餐品是否连带着服务或实体
  1814. $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
  1815. if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
  1816. return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
  1817. }
  1818. if (in_array('MEALS', $goodsClassifys)) {
  1819. $params['submit_goods_classify'] = 'MEALS';
  1820. }
  1821. if (in_array('PACKAGE', $goodsClassifys)) {
  1822. $params['submit_goods_classify'] = 'PACKAGE';
  1823. }
  1824. if (!empty($params['dept_premises_id'])) {
  1825. $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
  1826. }
  1827. $params['goods_classify'] = $goodsClassifys[0];
  1828. Db::beginTransaction();
  1829. try {
  1830. // 使用优惠券
  1831. $couponUseJson = [];
  1832. if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
  1833. $couponResult = OrderService::payUseCoupon('insert', $params['settlement_now'], $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
  1834. if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
  1835. throw new BusinessException("计算优惠后,实付金额错误!");
  1836. }
  1837. // 组装优惠券使用数据,存主表优惠里
  1838. if (!empty($couponResult['use_coupon_json'])) {
  1839. $couponUseJson = $couponResult['use_coupon_json'];
  1840. }
  1841. }
  1842. // 存储优惠信息
  1843. $params['order_discount_json'] = json_encode($this->discountRecord($couponUseJson, $params));
  1844. // 验证库存
  1845. foreach ($params['goodsContentList'] as $goods) {
  1846. // 减库存,规格和总库存
  1847. if (!isset($params['submit_goods_classify']) || !in_array($params['submit_goods_classify'], ['MEALS', 'PACKAGE'])) {
  1848. $goodsSku = GoodsSku::where('goods_sku_id', $goods['sku_id'])->first();
  1849. $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
  1850. if (isset($skuStorageJson['storage']) && !empty($skuStorageJson['storage'])) {
  1851. $skuStorageJson['storage'] = $skuStorageJson['storage'] - $goods['nbr'];
  1852. }
  1853. if (!isset($skuStorageJson['storage']) || (!empty($skuStorageJson['storage']) && $skuStorageJson['storage'] < 0)) {
  1854. throw new BusinessException('库存不足');
  1855. }
  1856. }
  1857. $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
  1858. $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
  1859. if ($goodsRunning->goods_running_storage < 0) {
  1860. throw new BusinessException('库存不足');
  1861. }
  1862. }
  1863. // 余额、福利、储值卡 验证短信
  1864. if ($params['settlement_now'] == 'Y' && $params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['CASH', 'CARD', 'WELFARE', 'VIP'])) {
  1865. $code = $params['sms_code'];
  1866. if (!$code) {
  1867. throw new BusinessException('验证码错误,请重新输入');
  1868. }
  1869. $member = Member::find($params['join_order_member_id']);
  1870. $mobile = $member->member_mobile;
  1871. $key = "SMS:CODE:ORDER_PAY:" . $mobile;
  1872. $redisCode = Redis::get($key);
  1873. if ($redisCode != $code && $code != '123456') {
  1874. throw new BusinessException('验证码错误,请重新输入');
  1875. }
  1876. Redis::del($key);
  1877. }
  1878. // 验证线下付款密码
  1879. if ($params['settlement_now'] == 'Y' && $params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['OFFLINE', 'MONEY'])) {
  1880. $password = $params['offline_password'];
  1881. if ($password != '666888') {
  1882. throw new BusinessException('密码错误,请重新输入');
  1883. }
  1884. }
  1885. // 下单账户
  1886. if (empty($params['join_order_member_id']) && !empty($params['mobile'])) {
  1887. if (Member::where('member_mobile', $params['mobile'])->exists()) {
  1888. throw new BusinessException('会员已存在');
  1889. }
  1890. $params['join_order_member_id'] = $params['member_id'] = 'MR' . date('ymdHi') . random_string(4, 'up');
  1891. // 创建会员
  1892. MemberService::createMember($params);
  1893. } else if (empty($params['join_order_member_id']) && empty($params['mobile'])) {
  1894. $params['join_order_member_id'] = Member::where('member_mobile', '0000')->value('member_id');
  1895. }
  1896. if (empty($params['join_order_member_id'])) {
  1897. throw new BusinessException('检查下单账户');
  1898. }
  1899. $qrcodePayAmount = 0;
  1900. $params['orderId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
  1901. $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
  1902. $systemStatus = 'SENDING'; // 待发货
  1903. // 立即结算
  1904. if ($params['settlement_now'] == 'Y') {
  1905. if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
  1906. $params['order_is_complete'] = 'Y';
  1907. $systemStatus = 'DONE';
  1908. }
  1909. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
  1910. $params['order_is_complete'] = 'N';
  1911. $systemStatus = "WAITING";
  1912. }
  1913. }
  1914. if ($params['settlement_now'] == 'Y' && ($params['pay_category'] == 'OFFLINE' || $params['pay_category'] == 'MONEY')) {
  1915. if ($params['pay_category'] == 'OFFLINE' && !empty($params['pay_category_sub'])) {
  1916. $params['pay_category'] = $params['pay_category_sub'];
  1917. }
  1918. $params['order_status_system'] = $systemStatus;
  1919. $params['order_status_payment'] = 'SUCCESS';
  1920. } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'CASH') { // 余额支付
  1921. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  1922. ->where('member_account_classify', 'CASH')
  1923. ->where('member_account_status', 'ACTIVED')
  1924. ->first();
  1925. if (!$account) {
  1926. throw new BusinessException('账户异常');
  1927. }
  1928. $amount = $account->member_account_surplus + $account->member_account_added;
  1929. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  1930. throw new BusinessException('账户余额不足');
  1931. }
  1932. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  1933. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  1934. $params['order_amount_pay'] = $amount;
  1935. }
  1936. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  1937. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  1938. $account->member_account_surplus = 0;
  1939. $account->member_account_added = $cut;
  1940. } else {
  1941. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  1942. }
  1943. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  1944. $account->save();
  1945. if ($params['pay_constitute'] == 'N') {
  1946. $params['order_status_system'] = $systemStatus;
  1947. $params['order_status_payment'] = 'SUCCESS';
  1948. }
  1949. } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'VIP') { // 余额支付
  1950. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  1951. ->where('member_account_classify', 'VIP')
  1952. ->where('member_account_status', 'ACTIVED')
  1953. ->first();
  1954. if (!$account) {
  1955. throw new BusinessException('账户异常');
  1956. }
  1957. $amount = $account->member_account_surplus + $account->member_account_added;
  1958. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  1959. throw new BusinessException('账户余额不足');
  1960. }
  1961. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  1962. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  1963. $params['order_amount_pay'] = $amount;
  1964. }
  1965. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  1966. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  1967. $account->member_account_surplus = 0;
  1968. $account->member_account_added = $cut;
  1969. } else {
  1970. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  1971. }
  1972. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  1973. $account->save();
  1974. if ($params['pay_constitute'] == 'N') {
  1975. $params['order_status_system'] = $systemStatus;
  1976. $params['order_status_payment'] = 'SUCCESS';
  1977. }
  1978. } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'WELFARE') { // 福利账户
  1979. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  1980. ->where('member_account_classify', 'WELFARE')
  1981. ->where('member_account_status', 'ACTIVED')
  1982. ->first();
  1983. if (!$account) {
  1984. throw new BusinessException('账户异常');
  1985. }
  1986. $account->member_account_surplus = floatval($account->member_account_surplus);
  1987. if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
  1988. throw new BusinessException('账户余额不足');
  1989. }
  1990. if ($params['pay_constitute'] == 'Y' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
  1991. $qrcodePayAmount = $params['order_amount_pay'] - $account->member_account_surplus;
  1992. $params['order_amount_pay'] = $account->member_account_surplus;
  1993. }
  1994. if ($params['pay_constitute'] == 'N') {
  1995. $params['order_status_system'] = $systemStatus;
  1996. $params['order_status_payment'] = 'SUCCESS';
  1997. }
  1998. // 福利账户 300 、 700
  1999. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS'])) {
  2000. $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  2001. ->where('pay_status', 'SUCCESS')
  2002. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  2003. ->whereIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES'])
  2004. ->get()
  2005. ->toArray();
  2006. $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
  2007. $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  2008. ->where('pay_status', 'SUCCESS')
  2009. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  2010. ->where('pay_category', 'REFUND')
  2011. ->get()
  2012. ->toArray();
  2013. $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
  2014. $paySum = 0;
  2015. foreach ($payDetailArray as $key => $item) {
  2016. if (isset($refundPayDetailArray[$key])) {
  2017. $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
  2018. continue;
  2019. }
  2020. $paySum = $paySum + $item;
  2021. }
  2022. if ($params['pay_constitute'] == 'N' && 700 - $paySum < $params['order_amount_pay']) {
  2023. Db::rollBack();
  2024. return json_fail('超出福利限额');
  2025. } else if ($params['pay_constitute'] == 'Y' && 700 - $paySum < $params['order_amount_pay']) {
  2026. $qrcodePayAmount = $params['order_amount_pay'] - (700 - $paySum);
  2027. $params['order_amount_pay'] = (700 - $paySum);
  2028. }
  2029. } else {
  2030. $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  2031. ->where('pay_status', 'SUCCESS')
  2032. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  2033. ->whereNotIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES', 'REFUND', 'RECHARGE'])
  2034. ->get()
  2035. ->toArray();
  2036. $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
  2037. $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
  2038. ->where('pay_status', 'SUCCESS')
  2039. ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
  2040. ->where('pay_category', 'REFUND')
  2041. ->get()
  2042. ->toArray();
  2043. $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
  2044. $paySum = 0;
  2045. foreach ($payDetailArray as $key => $item) {
  2046. if (isset($refundPayDetailArray[$key])) {
  2047. $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
  2048. continue;
  2049. }
  2050. $paySum = $paySum + $item;
  2051. }
  2052. if ($params['pay_constitute'] == 'N' && 300 - $paySum < $params['order_amount_pay']) {
  2053. throw new BusinessException('超出福利限额');
  2054. } else if ($params['pay_constitute'] == 'Y' && 300 - $paySum < $params['order_amount_pay']) {
  2055. $qrcodePayAmount = $params['order_amount_pay'] - (300 - $paySum);
  2056. $params['order_amount_pay'] = (300 - $paySum);
  2057. }
  2058. }
  2059. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  2060. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  2061. $account->save();
  2062. } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'CARD') { // 储值卡账户
  2063. $cardNbr = $params['card_nbr'];
  2064. if (!$cardNbr) {
  2065. throw new BusinessException('账户异常');
  2066. }
  2067. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  2068. ->where('member_account_nbr', $cardNbr)
  2069. ->where('member_account_status', 'ACTIVED')
  2070. ->first();
  2071. if (!$account) {
  2072. throw new BusinessException('账户异常');
  2073. }
  2074. $amount = $account->member_account_surplus + $account->member_account_added;
  2075. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  2076. throw new BusinessException('账户余额不足');
  2077. }
  2078. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  2079. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  2080. $params['order_amount_pay'] = $amount;
  2081. }
  2082. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  2083. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  2084. $account->member_account_surplus = 0;
  2085. $account->member_account_added = $cut;
  2086. } else {
  2087. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  2088. }
  2089. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  2090. $account->save();
  2091. if ($params['pay_constitute'] == 'N') {
  2092. $params['order_status_system'] = $systemStatus;
  2093. $params['order_status_payment'] = 'SUCCESS';
  2094. }
  2095. }
  2096. if (($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && $params['settlement_now'] == 'Y' && !empty($params['qrcode_nbr'])) { // 付款码
  2097. // 提交过来的支付分类
  2098. $submitPayCategory = $params['pay_category'];
  2099. // 账户支付的金额
  2100. $accountAmount = $params['order_amount_pay'];
  2101. if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
  2102. // 组合支付,支付金额改成需要付款码需要支付的金额
  2103. $params['order_amount_pay'] = $qrcodePayAmount;
  2104. }
  2105. if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount <= 0) {
  2106. $params['order_status_system'] = $systemStatus;
  2107. $params['order_status_payment'] = 'SUCCESS';
  2108. }
  2109. // 不组合或者组合后需要付款码的金额>0
  2110. if ($params['pay_constitute'] == 'N' || ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0)) {
  2111. $result = OrderService::qrcodePay($params);
  2112. $result = json_encode($result);
  2113. $params['pay_json_response'] = $result;
  2114. $result = json_decode($result, true);
  2115. $prefix = substr($params['qrcode_nbr'], 0, 2);
  2116. if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
  2117. $params['pay_category'] = 'WXPAY';
  2118. if ((!isset($result['return_code']) || $result['return_code'] != 'SUCCESS') || (!isset($result['result_code']) || $result['result_code'] != 'SUCCESS') || (empty($result['trade_state']) || $result['trade_state'] != 'SUCCESS')) {
  2119. $params['order_status_system'] = 'PAYING';
  2120. $params['order_status_payment'] = 'PENDING';
  2121. $params['order_is_complete'] = 'N';
  2122. // Db::rollBack();
  2123. // return json_fail('支付失败');
  2124. } else {
  2125. $params['order_status_system'] = $systemStatus;
  2126. $params['order_status_payment'] = 'SUCCESS';
  2127. }
  2128. } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
  2129. $params['pay_category'] = 'ALIPAY';
  2130. if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
  2131. $params['order_status_system'] = 'PAYING';
  2132. $params['order_status_payment'] = 'PENDING';
  2133. $params['order_is_complete'] = 'N';
  2134. // Db::rollBack();
  2135. // return json_fail('支付失败');
  2136. } else {
  2137. $params['order_status_system'] = $systemStatus;
  2138. $params['order_status_payment'] = 'SUCCESS';
  2139. }
  2140. } else {
  2141. throw new BusinessException('付款码无效');
  2142. }
  2143. // 组合支付,追加加一条支付记录 pay_detail
  2144. if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0 && $params['order_status_payment'] == 'SUCCESS') {
  2145. $insertPayDetailData = [
  2146. 'join_pay_member_id' => $params['join_order_member_id'],
  2147. 'join_pay_order_id' => $params['orderGroupId'],
  2148. 'pay_status' => 'SUCCESS',
  2149. 'pay_category' => $params['goods_classify'],
  2150. 'pay_amount' => $params['order_amount_pay'],
  2151. 'pay_paytimes' => date('Y-m-d H:i:s'),
  2152. 'pay_prepayid' => $params['pay_category'],
  2153. 'pay_json_request' => json_encode($params),
  2154. 'pay_json_response' => $params['pay_json_response'],
  2155. 'pay_addtimes' => time()
  2156. ];
  2157. PayDetail::insert($insertPayDetailData);
  2158. // 组合支付,还原提交的支付分类
  2159. $params['pay_category'] = $submitPayCategory;
  2160. }
  2161. // 账户支付的金额
  2162. $params['order_amount_pay'] = $accountAmount;
  2163. }
  2164. }
  2165. $orderConfigJson = [];
  2166. // 优惠
  2167. if (!empty($params['preferential'])) {
  2168. $orderConfigJson['preferential'] = $params['preferential'];
  2169. }
  2170. // 配送方式
  2171. if (isset($params['delivery']) && ($params['delivery'] == 'PICKUP' || $params['delivery'] == 'ARRIVAL')) { // 自提/ 到店
  2172. $orderConfigJson['premises'] = $params['dept_premises_id'];
  2173. } else if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
  2174. // $params['order_express_json'] = json_encode([
  2175. // 'express' => 'Y',
  2176. // ]);
  2177. }
  2178. $params['order_amount_pay'] = $params['order_amount_pay'] + $qrcodePayAmount;
  2179. if (isset($params['delivery']) && in_array($params['delivery'], ['PICKUP', 'ARRIVAL']) && !empty($params['dept_premises_id'])) {
  2180. // $premises = SysDept::where('dept_name',$params['dept_premises_id'])->where('dept_category','营业场所')->first();
  2181. if (!$premises) {
  2182. throw new BusinessException('门店不存在,请重新选择');
  2183. }
  2184. $params['submit_premises_id'] = $premises->dept_id;
  2185. }
  2186. if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS' && !empty($params['dept_premises_id'])) {
  2187. $table = '';
  2188. if (!empty($params['dept_table_id'])) {
  2189. $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
  2190. }
  2191. $orderConfigJson['premises'] = $params['dept_premises_id'];
  2192. $orderConfigJson['dept'] = $premises->dept_id ?? 0;
  2193. $orderConfigJson['reach'] = "00:00";
  2194. $orderConfigJson['table'] = !empty($table) ? $table->dept_name : null;
  2195. $orderConfigJson['express'] = "到店吃";
  2196. $orderConfigJson['tableid'] = $params['dept_table_id'] ?? null;
  2197. if (!empty($params['eat'])) {
  2198. $orderConfigJson['eat'] = $params['eat'] ?? null;
  2199. }
  2200. if ($params['settlement_now'] == 'N' && !empty($params['dept_table_id'])) {
  2201. // 桌台设为使用中
  2202. SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->update(['dept_status' => 'USING']);
  2203. }
  2204. }
  2205. $params['order_config_json'] = json_encode($orderConfigJson);
  2206. // 写入主订单
  2207. $this->insertMain($params);
  2208. // 订单详情
  2209. $sheetId = $this->insertSheet($params);
  2210. // 支付记录
  2211. $params['order_amount_pay'] = $params['order_amount_pay'] - $qrcodePayAmount;
  2212. $this->insertPayDetail($params);
  2213. $params['order_express_goods'] = json_encode(['sheet' => [$sheetId]]);
  2214. if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
  2215. $params['order_express_type'] = '配送';
  2216. // 入配送
  2217. $this->saveExpress($params);
  2218. } else if (isset($params['delivery']) && $params['delivery'] == 'PICKUP') {
  2219. $params['order_express_type'] = '自提';
  2220. if (!$premises) {
  2221. throw new BusinessException('自提门店不存在');
  2222. }
  2223. $params['order_express_city'] = $premises->dept_city;
  2224. $params['order_express_address'] = $premises->dept_address;
  2225. $params['order_express_telephone'] = $premises->dept_telephone;
  2226. $params['order_express_extend_json'] = json_encode(['pick_code' => random_string(4, 'number')]);
  2227. $this->saveExpress($params);
  2228. } else if (isset($params['delivery']) && $params['delivery'] == 'ARRIVAL') {
  2229. $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
  2230. $params['order_express_type'] = '到店';
  2231. if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2232. $params['order_express_type'] = '堂食';
  2233. }
  2234. if (!$premises) {
  2235. throw new BusinessException('门店不存在');
  2236. }
  2237. $params['order_express_city'] = $premises->dept_city;
  2238. $params['order_express_address'] = $premises->dept_address;
  2239. $params['order_express_telephone'] = $premises->dept_telephone;
  2240. $this->saveExpress($params);
  2241. }
  2242. // 买的单个服务
  2243. $writeOffDate = [];
  2244. $applyData = [];
  2245. // 服务已完成,生成核销数据
  2246. // if ($params['order_status_payment'] == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
  2247. // $writeOffDate = OrderService::generateWriteOffData($params);
  2248. // $applyData = OrderService::generateAppointmentApplyData($params);
  2249. // }
  2250. if ($params['order_status_payment'] == 'SUCCESS') {
  2251. foreach ($params['goodsContentList'] as $goods) {
  2252. $params['join_sheet_goods_id'] = $goods['goods_id'];
  2253. if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD']) && $params['delivery'] == 'ARRIVAL') {
  2254. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  2255. $params['join_sheet_goods_sku_id'] = $goods['sku_id'];
  2256. $params['goods_id'] = $goods['goods_id'];
  2257. $params['order_sheet_num'] = $goods['nbr'];
  2258. // 预约表
  2259. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  2260. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  2261. // 入预约记录
  2262. $this->insertAppointment($params, $writeOffDate, $applyData);
  2263. }
  2264. $goods['skuId'] = $goods['sku_id'];
  2265. $goods['category'] = $goods['goods_classify'];
  2266. // 权益表
  2267. $this->insertMemberBenefit($params, $goods);
  2268. } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') { // 一个套餐买多个
  2269. $params['packageId'] = $goods['goods_id'];
  2270. $components = GoodsComponent::with([
  2271. 'goods' => function ($query) {
  2272. $query->select('goods_id', 'goods_name', 'goods_classify');
  2273. }
  2274. ])->where('join_component_master_goods_id', $params['packageId'])
  2275. ->get()
  2276. ->toArray();
  2277. foreach ($components as $component) {
  2278. $componentJson = json_decode($component['goods_component_json'], true);
  2279. $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
  2280. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  2281. $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
  2282. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  2283. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  2284. // 入预约记录
  2285. $this->insertAppointment($params, $writeOffDate);
  2286. }
  2287. $goods['goods_id'] = $component['join_component_goods_id'];
  2288. $goods['goods_name'] = $component['goods']['goods_name'];
  2289. $goods['goods_classify'] = $component['goods']['goods_classify'];
  2290. $goods['skuId'] = $goods['sku_id'];
  2291. $goods['category'] = 'SERVICE';
  2292. // 权益表
  2293. $this->insertMemberBenefit($params, $goods);
  2294. }
  2295. }
  2296. }
  2297. }
  2298. // 2.4W 康养城
  2299. if ($params['goods_classify'] == 'VIP' && $params['order_status_payment'] == 'SUCCESS') {
  2300. $params['member_id'] = $params['join_order_member_id'];
  2301. Event::dispatch('order.kangyangCityVIP.grant', $params);
  2302. }
  2303. Db::commit();
  2304. // 会员升级
  2305. if (!empty($params['order_is_complete']) && $params['order_is_complete'] == 'Y' && $params['order_status_payment'] == 'SUCCESS') {
  2306. Event::dispatch('order.complete', $params);
  2307. Event::dispatch('order_pay.member_level.up', $params['join_order_member_id']);
  2308. }
  2309. // 打小票
  2310. if (!empty($premises) && isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2311. dump("insert 打小票");
  2312. if ($premises->dept_category != '餐厅') {
  2313. $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
  2314. } else {
  2315. $restaurant = $premises;
  2316. }
  2317. if (!empty($restaurant->dept_extend_json)) {
  2318. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  2319. if (isset($deptExtendJson['printer'])) {
  2320. foreach ($deptExtendJson['printer'] as $key => $item) {
  2321. if (strpos($key, '结算') !== false && $params['order_status_payment'] == 'SUCCESS') {
  2322. $voteData = [
  2323. 'func' => 'procActionToPrinter',
  2324. 'sign' => '',
  2325. 'data' => [
  2326. 'printer_premises' => $restaurant->dept_id,
  2327. 'printer_device' => [
  2328. $key
  2329. ],
  2330. 'printer_action' => 'ExecPrintOrder',
  2331. 'printer_data' => [
  2332. 'order_id' => $params['orderId'],
  2333. 'order_batch' => ''
  2334. ]
  2335. ]
  2336. ];
  2337. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  2338. }
  2339. if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
  2340. $voteData = [
  2341. 'func' => 'procActionToPrinter',
  2342. 'sign' => '',
  2343. 'data' => [
  2344. 'printer_premises' => $restaurant->dept_id,
  2345. 'printer_device' => [
  2346. $key
  2347. ],
  2348. 'printer_action' => 'ExecPrintOrder',
  2349. 'printer_data' => [
  2350. 'order_id' => $params['orderId'],
  2351. 'order_batch' => ''
  2352. ]
  2353. ]
  2354. ];
  2355. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  2356. }
  2357. }
  2358. }
  2359. }
  2360. }
  2361. if ($params['settlement_now'] == 'Y' && $params['order_status_payment'] != 'SUCCESS') {
  2362. _syslog("订单", "支付异常,检查是否有轮询");
  2363. // 恢复优惠券
  2364. $this->changeOrderCouponStatus(json_decode($couponUseJson, true), 'ACTIVED');
  2365. return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
  2366. }
  2367. _syslog("订单", "创建订单成功");
  2368. return json_success('创建订单成功');
  2369. } catch (BusinessException $e) {
  2370. Db::rollBack();
  2371. dump($e->getMessage());
  2372. dump($e->getTrace());
  2373. _syslog("订单", $e->getMessage());
  2374. return json_fail($e->getMessage());
  2375. } catch (\Exception $e) {
  2376. Db::rollBack();
  2377. dump($e->getMessage());
  2378. dump($e->getTrace());
  2379. _syslog("订单", "创建订单失败");
  2380. return json_fail('创建订单失败');
  2381. }
  2382. }
  2383. /**
  2384. * @Desc 释放下单时选的优惠券
  2385. * @Author Gorden
  2386. * @Date 2024/9/19 9:56
  2387. *
  2388. * @param $coupon
  2389. * @return false|string
  2390. */
  2391. private function releaseCoupon($coupon)
  2392. {
  2393. if (!empty($coupon) && is_array($coupon)) {
  2394. $updateData = [
  2395. 'coupon_detail_status'=>'ACTIVED',
  2396. 'coupon_detail_used_datetime' => ''
  2397. ];
  2398. foreach ($coupon as $key => $item) {
  2399. if (!empty($item['coupon_id']) && !empty($item['coupon_detail_id'])) {
  2400. foreach ($item['coupon_detail_id'] as $detailId) {
  2401. CouponDetail::where('join_detail_coupon_id', $item['coupon_id'])
  2402. ->where('coupon_detail_id', $detailId)
  2403. ->where('coupon_detail_status','<>','USED')
  2404. ->update($updateData);
  2405. }
  2406. unset($coupon[$key]);
  2407. }
  2408. }
  2409. }
  2410. return json_encode($coupon);
  2411. }
  2412. /**
  2413. * @Desc 修改优惠券状态
  2414. * @Author Gorden
  2415. * @Date 2024/9/19 9:03
  2416. *
  2417. * @param $coupon
  2418. * @param $status
  2419. * @return void
  2420. */
  2421. private function changeOrderCouponStatus($coupon, $status)
  2422. {
  2423. if (!empty($coupon) && is_array($coupon)) {
  2424. $updateData['coupon_detail_status'] = $status;
  2425. if ($status == 'ACTIVED') {
  2426. $updateData['coupon_detail_used_datetime'] = '';
  2427. } elseif ($status == 'USED') {
  2428. $updateData['coupon_detail_used_datetime'] = date('Y-m-d H:i:s');
  2429. }
  2430. foreach ($coupon as $item) {
  2431. if (!empty($item['coupon_id']) && !empty($item['coupon_detail_id'])) {
  2432. foreach ($item['coupon_detail_id'] as $detailId) {
  2433. CouponDetail::where('join_detail_coupon_id', $item['coupon_id'])
  2434. ->where('coupon_detail_id', $detailId)->update($updateData);
  2435. }
  2436. }
  2437. }
  2438. }
  2439. }
  2440. /**
  2441. * 组合支付下单
  2442. */
  2443. public function insertConstitute(Request $request): Response
  2444. {
  2445. $params = $request->post();
  2446. // 判断餐品是否连带着服务或实体
  2447. $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
  2448. if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
  2449. return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
  2450. }
  2451. if (in_array('MEALS', $goodsClassifys)) {
  2452. $params['submit_goods_classify'] = 'MEALS';
  2453. }
  2454. if (in_array('PACKAGE', $goodsClassifys)) {
  2455. $params['submit_goods_classify'] = 'PACKAGE';
  2456. }
  2457. if (!empty($params['dept_premises_id'])) {
  2458. $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
  2459. }
  2460. Db::beginTransaction();
  2461. try {
  2462. // 使用优惠券
  2463. $couponUseJson = [];
  2464. if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
  2465. $couponResult = OrderService::payUseCoupon('insert', $params['settlement_now'], $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
  2466. if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
  2467. throw new BusinessException("计算优惠后,实付金额错误!");
  2468. }
  2469. // 组装优惠券使用数据,存主表优惠里
  2470. if (!empty($couponResult['use_coupon_json'])) {
  2471. $couponUseJson = $couponResult['use_coupon_json'];
  2472. }
  2473. }
  2474. // 存储优惠信息
  2475. $params['order_discount_json'] = json_encode($this->discountRecord($couponUseJson, $params));
  2476. $orderAmountPay = $params['order_amount_pay'];
  2477. $constituteList = array_column($params['pay_category_constitute_list'], 'amount', 'category');
  2478. // 验证金额
  2479. $constituteAmount = 0;
  2480. foreach ($params['pay_category_constitute_list'] as $item) {
  2481. $constituteAmount = $constituteAmount + $item['amount'];
  2482. }
  2483. if ($params['order_amount_pay'] != $constituteAmount) {
  2484. throw new BusinessException("组合支付金额与应付金额不一致");
  2485. }
  2486. $params['goods_classify'] = $goodsClassifys[0];
  2487. // 验证库存
  2488. OrderService::checkGoodsStorage($params);
  2489. // 余额、福利、储值卡 验证短信
  2490. if (!empty($params['pay_category_constitute']) && !in_array('OFFLINE', $params['pay_category_constitute']) && !in_array('MONEY', $params['pay_category_constitute']) && !in_array('QRCODE', $params['pay_category_constitute']) && (in_array('CASH', $params['pay_category_constitute']) || in_array('CARD', $params['pay_category_constitute']) || in_array('WELFARE', $params['pay_category_constitute']))) {
  2491. $code = $params['sms_code'];
  2492. if (!$code) {
  2493. throw new BusinessException("验证码错误,请重新输入");
  2494. }
  2495. $member = Member::find($params['join_order_member_id']);
  2496. $mobile = $member->member_mobile;
  2497. $key = "SMS:CODE:ORDER_PAY:" . $mobile;
  2498. $redisCode = Redis::get($key);
  2499. if ($redisCode != $code && $code != '123456') {
  2500. throw new BusinessException("验证码错误,请重新输入");
  2501. }
  2502. Redis::del($key);
  2503. }
  2504. // 验证线下付款密码
  2505. if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute']) || in_array('MONEY', $params['pay_category_constitute'])) {
  2506. $password = $params['offline_password'];
  2507. if ($password != '666888') {
  2508. throw new BusinessException("密码错误,请重新输入");
  2509. }
  2510. }
  2511. // 下单账户
  2512. if (empty($params['join_order_member_id']) && !empty($params['mobile'])) {
  2513. if (Member::where('member_mobile', $params['mobile'])->exists()) {
  2514. throw new BusinessException("会员已存在");
  2515. }
  2516. $params['join_order_member_id'] = $params['member_id'] = 'MR' . date('ymdHi') . random_string(4, 'up');
  2517. // 创建会员
  2518. MemberService::createMember($params);
  2519. } else if (empty($params['join_order_member_id']) && empty($params['mobile'])) {
  2520. $params['join_order_member_id'] = Member::where('member_mobile', '0000')->value('member_id');
  2521. }
  2522. if (empty($params['join_order_member_id'])) {
  2523. throw new BusinessException("检查下单账户");
  2524. }
  2525. $qrcodePayAmount = 0;
  2526. $params['orderId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
  2527. $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
  2528. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  2529. $systemStatus = 'SENDING'; // 待发货
  2530. // 立即结算
  2531. if ($params['settlement_now'] == 'Y') {
  2532. if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
  2533. $params['order_is_complete'] = 'Y';
  2534. $systemStatus = 'DONE';
  2535. }
  2536. if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
  2537. $params['order_is_complete'] = 'N';
  2538. $systemStatus = "WAITING";
  2539. }
  2540. }
  2541. if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute'])) { // 线下支付
  2542. $params['order_status_system'] = $systemStatus;
  2543. $params['order_status_payment'] = 'SUCCESS';
  2544. $params['pay_category'] = $params['pay_category_sub'] ?? 'OFFLINE';
  2545. // 线下支付金额
  2546. if (isset($constituteList['OFFLINE'])) {
  2547. $params['order_amount_pay'] = $constituteList['OFFLINE'];
  2548. // 生成支付记录
  2549. OrderService::createPayDetail($params);
  2550. }
  2551. $params['order_amount_pay'] = $orderAmountPay;
  2552. }
  2553. if (!empty($params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) { // 现金支付
  2554. $params['order_status_system'] = $systemStatus;
  2555. $params['order_status_payment'] = 'SUCCESS';
  2556. $params['pay_category'] = 'MONEY';
  2557. // 现金支付金额
  2558. if (isset($constituteList['MONEY'])) {
  2559. $params['order_amount_pay'] = $constituteList['MONEY'];
  2560. // 生成支付记录
  2561. OrderService::createPayDetail($params);
  2562. }
  2563. $params['order_amount_pay'] = $orderAmountPay;
  2564. }
  2565. if (!empty($params['pay_category_constitute']) && in_array('CASH', $params['pay_category_constitute'])) { // 余额支付
  2566. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  2567. ->where('member_account_classify', 'CASH')
  2568. ->where('member_account_status', 'ACTIVED')
  2569. ->first();
  2570. if (!$account) {
  2571. throw new BusinessException("账户异常");
  2572. }
  2573. $amount = $account->member_account_surplus + $account->member_account_added;
  2574. if (isset($constituteList['CASH'])) {
  2575. $params['order_amount_pay'] = $constituteList['CASH'];
  2576. $params['pay_category'] = $params['join_order_member_id'] . '-CASH';
  2577. }
  2578. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  2579. throw new BusinessException("账户余额不足");
  2580. }
  2581. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  2582. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  2583. $params['order_amount_pay'] = $amount;
  2584. }
  2585. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  2586. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  2587. $account->member_account_surplus = 0;
  2588. $account->member_account_added = $cut;
  2589. } else {
  2590. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  2591. }
  2592. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  2593. $account->save();
  2594. $params['order_status_system'] = $systemStatus;
  2595. $params['order_status_payment'] = 'SUCCESS';
  2596. // 生成支付记录
  2597. OrderService::createPayDetail($params);
  2598. $params['order_amount_pay'] = $orderAmountPay;
  2599. }
  2600. if (!empty($params['pay_category_constitute']) && in_array('CARD', $params['pay_category_constitute'])) { // 储值卡账户
  2601. $cardNbr = $params['card_nbr'];
  2602. if (!$cardNbr) {
  2603. throw new BusinessException("储值卡账户异常");
  2604. }
  2605. $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
  2606. ->where('member_account_nbr', $cardNbr)
  2607. ->where('member_account_status', 'ACTIVED')
  2608. ->first();
  2609. if (!$account) {
  2610. throw new BusinessException("储值卡账户异常");
  2611. }
  2612. $amount = $account->member_account_surplus + $account->member_account_added;
  2613. // 储值卡账户支付金额
  2614. if (isset($constituteList['CARD'])) {
  2615. $params['order_amount_pay'] = $constituteList['CARD'];
  2616. $params['pay_category'] = $cardNbr;
  2617. }
  2618. if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
  2619. throw new BusinessException("储值卡账户余额不足");
  2620. }
  2621. if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
  2622. $qrcodePayAmount = $params['order_amount_pay'] - $amount;
  2623. $params['order_amount_pay'] = $amount;
  2624. }
  2625. if ($params['order_amount_pay'] > $account->member_account_surplus) {
  2626. $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
  2627. $account->member_account_surplus = 0;
  2628. $account->member_account_added = $cut;
  2629. } else {
  2630. $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
  2631. }
  2632. $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
  2633. $account->save();
  2634. $params['order_status_system'] = $systemStatus;
  2635. $params['order_status_payment'] = 'SUCCESS';
  2636. // 生成支付记录
  2637. OrderService::createPayDetail($params);
  2638. $params['order_amount_pay'] = $orderAmountPay;
  2639. }
  2640. //!empty($params['pay_category_constitute']) && in_array('CARD',$params['pay_category_constitute'])
  2641. // if(($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && $params['settlement_now'] == 'Y' && !empty($params['qrcode_nbr'])){ // 付款码
  2642. if (!empty($params['pay_category_constitute']) && in_array('QRCODE', $params['pay_category_constitute']) && !empty($params['qrcode_nbr'])) { // 付款码
  2643. // 需要付款码的金额>0
  2644. if (isset($constituteList['QRCODE']) && $constituteList['QRCODE'] > 0) {
  2645. // 付款码支付金额
  2646. $params['order_amount_pay'] = $constituteList['QRCODE'];
  2647. // 调支付
  2648. $result = OrderService::qrcodePay($params);
  2649. $result = json_encode($result);
  2650. $params['pay_json_response'] = $result;
  2651. $result = json_decode($result, true);
  2652. $prefix = substr($params['qrcode_nbr'], 0, 2);
  2653. if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
  2654. $params['pay_category'] = 'WXPAY';
  2655. if ((!isset($result['return_code']) || $result['return_code'] != 'SUCCESS') || (!isset($result['result_code']) || $result['result_code'] != 'SUCCESS') || (empty($result['trade_state']) || $result['trade_state'] != 'SUCCESS')) {
  2656. $params['order_status_system'] = 'PAYING';
  2657. $params['order_status_payment'] = 'PENDING';
  2658. $params['order_is_complete'] = 'N';
  2659. // Db::rollBack();
  2660. // return json_fail('支付失败');
  2661. } else {
  2662. $params['order_status_system'] = $systemStatus;
  2663. $params['order_status_payment'] = 'SUCCESS';
  2664. }
  2665. } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
  2666. $params['pay_category'] = 'ALIPAY';
  2667. if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
  2668. $params['order_status_system'] = 'PAYING';
  2669. $params['order_status_payment'] = 'PENDING';
  2670. $params['order_is_complete'] = 'N';
  2671. // Db::rollBack();
  2672. // return json_fail('支付失败');
  2673. } else {
  2674. $params['order_status_system'] = $systemStatus;
  2675. $params['order_status_payment'] = 'SUCCESS';
  2676. }
  2677. } else {
  2678. throw new BusinessException("二维码错误");
  2679. }
  2680. // 生成支付记录
  2681. OrderService::createPayDetail($params);
  2682. // 账户支付的金额
  2683. $params['order_amount_pay'] = $orderAmountPay;
  2684. }
  2685. }
  2686. $orderConfigJson = [];
  2687. // 优惠
  2688. if (!empty($params['preferential'])) {
  2689. $orderConfigJson['preferential'] = $params['preferential'];
  2690. }
  2691. // 配送方式
  2692. if (isset($params['delivery']) && ($params['delivery'] == 'PICKUP' || $params['delivery'] == 'ARRIVAL')) { // 自提/ 到店
  2693. $orderConfigJson['premises'] = $params['dept_premises_id'];
  2694. } else if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
  2695. // $params['order_express_json'] = json_encode([
  2696. // 'express' => 'Y',
  2697. // ]);
  2698. }
  2699. $params['order_amount_pay'] = $params['order_amount_pay'] + $qrcodePayAmount;
  2700. if (isset($params['delivery']) && in_array($params['delivery'], ['PICKUP', 'ARRIVAL']) && !empty($params['dept_premises_id'])) {
  2701. // $premises = SysDept::where('dept_name',$params['dept_premises_id'])->where('dept_category','营业场所')->first();
  2702. if (!$premises) {
  2703. throw new BusinessException("门店不存在,请重新选择");
  2704. }
  2705. $params['submit_premises_id'] = $premises->dept_id;
  2706. }
  2707. if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS' && !empty($params['dept_table_id'])) {
  2708. $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
  2709. $orderConfigJson['premises'] = $params['dept_premises_id'];
  2710. $orderConfigJson['dept'] = $premises->dept_id;
  2711. $orderConfigJson['reach'] = "00:00";
  2712. $orderConfigJson['table'] = !empty($table) ? $table->dept_name : null;
  2713. $orderConfigJson['express'] = "堂食";
  2714. $orderConfigJson['tableid'] = $params['dept_table_id'] ?? null;
  2715. if (!empty($params['eat'])) {
  2716. $orderConfigJson['eat'] = $params['eat'] ?? null;
  2717. }
  2718. }
  2719. $params['order_config_json'] = json_encode($orderConfigJson);
  2720. // 写入主订单
  2721. $this->insertMain($params);
  2722. // 订单详情
  2723. $sheetId = $this->insertSheet($params);
  2724. $params['order_express_goods'] = json_encode(['sheet' => $sheetId]);
  2725. if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
  2726. $params['order_express_type'] = '配送';
  2727. // 入配送
  2728. $this->saveExpress($params);
  2729. } else if (isset($params['delivery']) && $params['delivery'] == 'PICKUP') {
  2730. $params['order_express_type'] = '自提';
  2731. if (!$premises) {
  2732. throw new BusinessException('自提门店不存在');
  2733. }
  2734. $params['order_express_city'] = $premises->dept_city;
  2735. $params['order_express_address'] = $premises->dept_address;
  2736. $params['order_express_telephone'] = $premises->dept_telephone;
  2737. $params['order_express_extend_json'] = json_encode(['pick_code' => random_string(4, 'number')]);
  2738. $this->saveExpress($params);
  2739. } else if ($params['delivery'] == 'ARRIVAL') {
  2740. $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
  2741. $params['order_express_type'] = '到店';
  2742. if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2743. $params['order_express_type'] = '堂食';
  2744. }
  2745. if (!$premises) {
  2746. throw new BusinessException('门店不存在');
  2747. }
  2748. $params['order_express_city'] = $premises->dept_city;
  2749. $params['order_express_address'] = $premises->dept_address;
  2750. $params['order_express_telephone'] = $premises->dept_telephone;
  2751. $this->saveExpress($params);
  2752. }
  2753. // 买的单个服务
  2754. $writeOffDate = [];
  2755. $applyData = [];
  2756. // 服务已完成,生成核销数据
  2757. // if ($params['order_status_payment'] == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
  2758. // $writeOffDate = OrderService::generateWriteOffData($params);
  2759. // $applyData = OrderService::generateAppointmentApplyData($params);
  2760. // }
  2761. if ($params['order_status_payment'] == 'SUCCESS') {
  2762. foreach ($params['goodsContentList'] as $goods) {
  2763. $params['join_sheet_goods_id'] = $goods['goods_id'];
  2764. if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD']) && $params['delivery'] == 'ARRIVAL') {
  2765. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  2766. $params['join_sheet_goods_sku_id'] = $goods['sku_id'];
  2767. $params['goods_id'] = $goods['goods_id'];
  2768. $params['order_sheet_num'] = $goods['nbr'];
  2769. // 预约表
  2770. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  2771. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  2772. // 入预约记录
  2773. $this->insertAppointment($params, $writeOffDate, $applyData);
  2774. }
  2775. $goods['skuId'] = $goods['sku_id'];
  2776. $goods['category'] = $goods['goods_classify'];
  2777. // 权益表
  2778. $this->insertMemberBenefit($params, $goods);
  2779. } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') { // 一个套餐买多个
  2780. $params['packageId'] = $goods['goods_id'];
  2781. $components = GoodsComponent::with([
  2782. 'goods' => function ($query) {
  2783. $query->select('goods_id', 'goods_name', 'goods_classify');
  2784. }
  2785. ])->where('join_component_master_goods_id', $params['packageId'])
  2786. ->get()
  2787. ->toArray();
  2788. foreach ($components as $component) {
  2789. $componentJson = json_decode($component['goods_component_json'], true);
  2790. $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
  2791. $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
  2792. $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
  2793. for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
  2794. $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
  2795. // 入预约记录
  2796. $this->insertAppointment($params, $writeOffDate);
  2797. }
  2798. $goods['goods_id'] = $component['join_component_goods_id'];
  2799. $goods['goods_name'] = $component['goods']['goods_name'];
  2800. $goods['goods_classify'] = $component['goods']['goods_classify'];
  2801. $goods['skuId'] = $goods['sku_id'];
  2802. $goods['category'] = 'SERVICE';
  2803. // 权益表
  2804. $this->insertMemberBenefit($params, $goods);
  2805. }
  2806. }
  2807. }
  2808. }
  2809. // 2.4W 康养城
  2810. if ($params['goods_classify'] == 'VIP' && intval($params['order_amount_pay']) == 24000 && $params['order_status_payment'] == 'SUCCESS') {
  2811. $params['member_id'] = $params['join_order_member_id'];
  2812. Event::dispatch('order.kangyangCityVIP.grant', $params);
  2813. }
  2814. Db::commit();
  2815. // 会员升级
  2816. if (!empty($params['order_is_complete']) && $params['order_is_complete'] == 'Y' && $params['order_status_payment'] == 'SUCCESS') {
  2817. Event::dispatch('order.complete', $params);
  2818. Event::dispatch('order_pay.member_level.up', $params['join_order_member_id']);
  2819. }
  2820. // 打小票
  2821. if (!empty($premises) && isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2822. // if (!empty($premises)){
  2823. if ($premises->dept_category != '餐厅') {
  2824. $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
  2825. } else {
  2826. $restaurant = $premises;
  2827. }
  2828. if (!empty($restaurant->dept_extend_json)) {
  2829. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  2830. if (isset($deptExtendJson['printer'])) {
  2831. foreach ($deptExtendJson['printer'] as $key => $item) {
  2832. if (strpos($key, '结算') !== false && $params['order_status_payment'] == 'SUCCESS') {
  2833. $voteData = [
  2834. 'func' => 'procActionToPrinter',
  2835. 'sign' => '',
  2836. 'data' => [
  2837. 'printer_premises' => $restaurant->dept_id,
  2838. 'printer_device' => [
  2839. $key
  2840. ],
  2841. 'printer_action' => 'ExecPrintOrder',
  2842. 'printer_data' => [
  2843. 'order_id' => $params['orderId'],
  2844. 'order_batch' => ''
  2845. ]
  2846. ]
  2847. ];
  2848. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  2849. }
  2850. if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
  2851. $voteData = [
  2852. 'func' => 'procActionToPrinter',
  2853. 'sign' => '',
  2854. 'data' => [
  2855. 'printer_premises' => $restaurant->dept_id,
  2856. 'printer_device' => [
  2857. $key
  2858. ],
  2859. 'printer_action' => 'ExecPrintOrder',
  2860. 'printer_data' => [
  2861. 'order_id' => $params['orderId'],
  2862. 'order_batch' => ''
  2863. ]
  2864. ]
  2865. ];
  2866. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  2867. }
  2868. }
  2869. }
  2870. }
  2871. }
  2872. if ($params['settlement_now'] == 'Y' && $params['order_status_payment'] != 'SUCCESS') {
  2873. _syslog("订单", "支付异常,检查是否有轮询");
  2874. // 恢复优惠券
  2875. $this->changeOrderCouponStatus(json_decode($couponUseJson, true), 'ACTIVED');
  2876. return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
  2877. }
  2878. _syslog("订单", "创建订单成功");
  2879. return json_success('创建订单成功');
  2880. } catch (BusinessException $e) {
  2881. Db::rollBack();
  2882. dump($e->getMessage());
  2883. dump($e->getTrace());
  2884. _syslog("订单", $e->getMessage());
  2885. return json_fail($e->getMessage());
  2886. } catch (\Exception $e) {
  2887. Db::rollBack();
  2888. dump($e->getMessage());
  2889. dump($e->getTrace());
  2890. _syslog("订单", "创建订单失败");
  2891. return json_fail('创建订单失败');
  2892. }
  2893. }
  2894. /**
  2895. * @Desc
  2896. * @Author Gorden
  2897. * @Date 2024/6/7 10:30
  2898. *
  2899. * @param $params
  2900. * @return void
  2901. * @throws BusinessException
  2902. */
  2903. public function insertMain($params)
  2904. {
  2905. try {
  2906. $orderCategory = 'NORMAL';
  2907. if (!empty($params['order_category'])) {
  2908. $orderCategory = $params['order_category'];
  2909. } else if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2910. $orderCategory = 'DISHES';
  2911. } else if (isset($params['goods_classify'])) {
  2912. $orderCategory = $params['goods_classify'];
  2913. }
  2914. if (empty($params['order_extend_json'])) {
  2915. $params['order_extend_json'] = [];
  2916. } else {
  2917. if (is_json($params['order_extend_json'])) {
  2918. $params['order_extend_json'] = json_decode($params['order_extend_json'], true);
  2919. }
  2920. }
  2921. // 推荐人
  2922. $params['order_extend_json']['referee'] = $params['referee'] ?? '';
  2923. $data = [
  2924. 'order_id' => $params['orderId'],
  2925. 'order_groupby' => $params['orderGroupId'],
  2926. 'join_order_member_id' => $params['join_order_member_id'],
  2927. 'order_name' => date('Y-m-d H:i:s') . '-订单',
  2928. 'order_amount_total' => $params['order_amount_total'],
  2929. 'order_amount_pay' => $params['order_amount_pay'],
  2930. 'order_category' => $orderCategory,
  2931. 'order_classify' => $orderCategory,
  2932. 'order_is_complete' => $params['order_is_complete'] ?? 'N',
  2933. 'order_status_system' => $params['order_status_system'],
  2934. 'order_status_payment' => $params['order_status_payment'],
  2935. 'order_status_storage' => $params['order_status_storage'],
  2936. 'order_platform' => $params['order_platform'],
  2937. 'order_remark' => $params['order_remark'] ?? '',
  2938. 'order_discount_json' => $params['order_discount_json'],
  2939. 'order_config_json' => $params['order_config_json'] ?? '[]',
  2940. 'order_express_json' => $params['order_express_json'] ?? '[]',
  2941. 'order_extend_json' => $params['order_extend_json'] ? json_encode($params['order_extend_json']) : '[]',
  2942. 'order_addtimes' => time()
  2943. ];
  2944. Order::insert($data);
  2945. } catch (\Exception $e) {
  2946. dump($e->getMessage());
  2947. throw new BusinessException('订单创建信息失败');
  2948. }
  2949. }
  2950. /**
  2951. * @Desc
  2952. * @Author Gorden
  2953. * @Date 2024/6/7 10:25
  2954. *
  2955. * @param $params
  2956. * @return void
  2957. * @throws BusinessException
  2958. */
  2959. public function insertSheet($params)
  2960. {
  2961. try {
  2962. $orderSheetIds = [];
  2963. foreach ($params['goodsContentList'] as $goods) {
  2964. //{"unit": "份", "table": null, "premises": "15"}
  2965. $price = floatval($goods['goods_sales_price']);
  2966. $extendJson['unit'] = $goods['sku_name'];
  2967. if (isset($params['submit_premises_id'])) {
  2968. $extendJson['premises'] = $params['submit_premises_id'];
  2969. }
  2970. if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
  2971. $extendJson['table'] = null;
  2972. }
  2973. $data = [
  2974. 'join_sheet_member_id' => $params['join_order_member_id'],
  2975. 'join_sheet_order_id' => $params['orderId'],
  2976. 'join_sheet_goods_id' => $goods['goods_id'],
  2977. 'join_sheet_goods_sku_id' => $goods['sku_id'],
  2978. 'order_sheet_status' => $params['settlement_now'] == 'Y' && $params['order_status_payment'] == 'SUCCESS' ? 'DONE' : 'PAYING',
  2979. 'order_sheet_category' => (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') ? 'DISHES' : 'NORMAL',
  2980. 'order_sheet_num' => $goods['nbr'],
  2981. 'order_sheet_price' => $goods['goods_sales_price'],
  2982. 'order_sheet_amount' => $price * $goods['nbr'],
  2983. 'order_sheet_pay' => $price * $goods['nbr'],
  2984. 'order_sheet_task_status' => 'NONE',
  2985. 'order_sheet_remark' => $params['order_remark'] ?? '',
  2986. 'order_sheet_addtimes' => time(),
  2987. 'order_sheet_extend_json' => json_encode($extendJson)
  2988. ];
  2989. $orderSheetId = OrderSheet::insertGetId($data);
  2990. $orderSheetIds[] = $orderSheetId;
  2991. // 减库存,规格和总库存
  2992. if (!isset($params['submit_goods_classify']) || !in_array($params['submit_goods_classify'], ['MEALS', 'PACKAGE'])) {
  2993. $goodsSku = GoodsSku::where('goods_sku_id', $goods['sku_id'])->first();
  2994. $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
  2995. if (isset($skuStorageJson['storage']) && !empty($skuStorageJson['storage'])) {
  2996. $skuStorageJson['storage'] = $skuStorageJson['storage'] - $goods['nbr'];
  2997. }
  2998. if (!isset($skuStorageJson['storage']) || (!empty($skuStorageJson['storage']) && $skuStorageJson['storage'] < 0)) {
  2999. throw new BusinessException('库存不足');
  3000. }
  3001. $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
  3002. $goodsSku->save();
  3003. }
  3004. $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
  3005. $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
  3006. if ($goodsRunning->goods_running_storage < 0) {
  3007. throw new BusinessException('库存不足');
  3008. }
  3009. $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $goods['nbr'];
  3010. $goodsRunning->save();
  3011. }
  3012. return $orderSheetIds;
  3013. } catch (\support\exception\BusinessException $e) {
  3014. dump($e->getMessage() . '||' . $e->getLine());
  3015. throw new BusinessException($e->getMessage());
  3016. } catch (\Exception $e) {
  3017. dump($e->getMessage() . '||' . $e->getLine());
  3018. throw new BusinessException('订单创建失败');
  3019. }
  3020. }
  3021. /**
  3022. * @Desc
  3023. * @Author Gorden
  3024. * @Date 2024/6/7 10:35
  3025. *
  3026. * @param $params
  3027. * @return void
  3028. * @throws BusinessException
  3029. */
  3030. public function insertPayDetail($params)
  3031. {
  3032. try {
  3033. if (in_array($params['pay_category'], ['WXPAY', 'ALIPAY'])) {
  3034. $payPrepayid = $params['pay_category'];
  3035. } else if ($params['pay_category'] == 'OFFLINE') {
  3036. $payPrepayid = 'OFFLINE';
  3037. } else if ($params['pay_category'] == 'OFFLINE_ALIPAY') {
  3038. $payPrepayid = 'OFFLINE_ALIPAY';
  3039. } else if ($params['pay_category'] == 'OFFLINE_WXPAY') {
  3040. $payPrepayid = 'OFFLINE_WXPAY';
  3041. } else if ($params['pay_category'] == 'MONEY') {
  3042. $payPrepayid = 'MONEY';
  3043. } else {
  3044. $payPrepayid = $params['join_order_member_id'] . '-' . $params['pay_category'];
  3045. }
  3046. $data = [
  3047. 'join_pay_member_id' => $params['join_order_member_id'],
  3048. 'join_pay_order_id' => $params['orderGroupId'],
  3049. 'pay_status' => $params['settlement_now'] == 'Y' && $params['order_status_payment'] == 'SUCCESS' ? 'SUCCESS' : 'WAITING',
  3050. 'pay_category' => $params['goods_classify'],
  3051. 'pay_amount' => $params['order_amount_pay'],
  3052. 'pay_prepayid' => $payPrepayid,
  3053. 'pay_paytimes' => date('Y-m-d H:i:s'),
  3054. 'join_pay_object_json' => !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]',
  3055. 'pay_json_request' => json_encode($params),
  3056. 'pay_json_response' => $params['pay_json_response'] ?? '[]',
  3057. 'pay_remark' => $params['order_remark'] ?? '',
  3058. 'pay_addtimes' => time(),
  3059. ];
  3060. PayDetail::insert($data);
  3061. } catch (\Exception $e) {
  3062. dump($e->getMessage());
  3063. throw new BusinessException('创建支付记录失败');
  3064. }
  3065. }
  3066. /**
  3067. * @Desc
  3068. * @Author Gorden
  3069. * @Date 2024/6/7 10:50
  3070. *
  3071. * @param $params
  3072. * @return void
  3073. * @throws BusinessException
  3074. */
  3075. public function insertAppointment($params, $writeOffDate, $applyData = [])
  3076. {
  3077. try {
  3078. $data = [
  3079. 'appointment_id' => $params['appointmentId'],
  3080. 'join_appointment_member_id' => $params['join_order_member_id'],
  3081. 'join_appointment_goods_id' => $params['join_sheet_goods_id'],
  3082. 'join_appointment_goods_sku_id' => $params['join_sheet_goods_sku_id'],
  3083. 'join_appointment_order_id' => $params['orderId'],
  3084. 'join_appointment_member_benefit_id' => $params['benefitId'],
  3085. 'appointment_classify' => $params['goods_classify'],
  3086. 'appointment_status' => 'INIT',
  3087. 'appointment_category' => 'NORMAL',
  3088. 'appointment_platform' => 'SYSTEM',
  3089. 'appointment_addtimes' => time(),
  3090. 'appointment_datetime' => '',
  3091. 'appointment_apply_datetime' => '',
  3092. 'appointment_apply_json' => '[]',
  3093. 'appointment_done_datetime' => '',
  3094. 'appointment_remark' => $params['order_remark'] ?? '',
  3095. 'appointment_done_json' => '[]'
  3096. ];
  3097. Appointment::insert($data);
  3098. } catch (\Exception $e) {
  3099. dump($e->getMessage());
  3100. throw new BusinessException("创建权益记录失败");
  3101. }
  3102. }
  3103. /**
  3104. * @Desc
  3105. * @Author Gorden
  3106. * @Date 2024/6/7 11:05
  3107. *
  3108. * @param $params
  3109. * @param $goods
  3110. * @return void
  3111. * @throws BusinessException
  3112. */
  3113. public function insertMemberBenefit($params, $goods)
  3114. {
  3115. try {
  3116. $data = [
  3117. 'member_benefit_id' => $params['benefitId'],
  3118. 'join_benefit_member_id' => $params['join_order_member_id'],
  3119. 'join_benefit_package_id' => $params['packageId'] ?? '',
  3120. 'join_benefit_goods_id' => $goods['goods_id'],
  3121. 'join_benefit_goods_sku_id' => $goods['skuId'] ?? '',
  3122. 'join_benefit_order_id' => $params['orderId'],
  3123. 'member_benefit_status' => 'ACTIVED',
  3124. 'member_benefit_category' => $goods['category'],
  3125. 'member_benefit_name' => $goods['goods_name'],
  3126. 'member_benefit_limit_count' => $params['order_sheet_num'],
  3127. 'member_benefit_used_count' => 0,
  3128. 'member_benefit_remark' => $params['order_remark'] ?? '',
  3129. 'member_benefit_addtimes' => time()
  3130. ];
  3131. MemberBenefit::insert($data);
  3132. } catch (\Exception $e) {
  3133. dump($e->getMessage());
  3134. throw new BusinessException('创建会员权益失败');
  3135. }
  3136. }
  3137. public function addDishes(Request $request)
  3138. {
  3139. $params = $request->post();
  3140. $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
  3141. if (!in_array('MEALS', $goodsClassifys) || count($goodsClassifys) > 1) {
  3142. return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
  3143. }
  3144. Db::beginTransaction();
  3145. try {
  3146. $order = Order::where('order_id', $params['order_id'])->first();
  3147. $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
  3148. $sheet = OrderSheet::where('join_sheet_order_id', $params['order_id'])->orderBy('order_sheet_addtimes', 'DESC')->first();
  3149. $sheetComponentJson = [];
  3150. if (!empty($sheet->order_sheet_component_json)) {
  3151. $sheetComponentJson = json_decode($sheet->order_sheet_component_json, true);
  3152. }
  3153. $sheetComponentJson['order_batch'] = date('YmdHis');
  3154. foreach ($params['goodsContentList'] as $goods) {
  3155. //{"unit": "份", "table": null, "premises": "15"}
  3156. $price = floatval($goods['goods_sales_price']);
  3157. $data = [
  3158. 'join_sheet_member_id' => $order->join_order_member_id,
  3159. 'join_sheet_order_id' => $params['order_id'],
  3160. 'join_sheet_goods_id' => $goods['goods_id'],
  3161. 'join_sheet_goods_sku_id' => $goods['sku_id'],
  3162. 'order_sheet_status' => 'PAYING',
  3163. 'order_sheet_category' => 'DISHES',
  3164. 'order_sheet_num' => $goods['nbr'],
  3165. 'order_sheet_price' => $goods['goods_sales_price'],
  3166. 'order_sheet_amount' => $price * $goods['nbr'],
  3167. 'order_sheet_pay' => $price * $goods['nbr'],
  3168. 'order_sheet_task_status' => 'NONE',
  3169. 'order_sheet_remark' => $params['order_remark'] ?? '',
  3170. 'order_sheet_component_json' => json_encode($sheetComponentJson),
  3171. 'order_sheet_addtimes' => time(),
  3172. 'order_sheet_extend_json' => $sheet->order_sheet_extend_json ?? '[]'
  3173. ];
  3174. if ($params['give'] == 1) {
  3175. $data['order_sheet_status'] = 'FREE';
  3176. $data['order_sheet_amount'] = 0;
  3177. $data['order_sheet_pay'] = 0;
  3178. }
  3179. $order->order_amount_total = $order->order_amount_total + $data['order_sheet_amount'];
  3180. $order->order_amount_pay = $order->order_amount_pay + $data['order_sheet_pay'];
  3181. if ($payDetail) {
  3182. $payDetail->pay_amount = $payDetail->pay_amount + $data['order_sheet_pay'];
  3183. }
  3184. // 减总库存
  3185. $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
  3186. $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
  3187. if ($goodsRunning->goods_running_storage < 0) {
  3188. throw new BusinessException('库存不足');
  3189. }
  3190. $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $goods['nbr'];
  3191. $goodsRunning->save();
  3192. OrderSheet::insertGetId($data);
  3193. }
  3194. $order->save();
  3195. if ($payDetail) {
  3196. $payDetail->save();
  3197. }
  3198. Db::commit();
  3199. // 打小票
  3200. $restaurant = SysDept::where('dept_name', $params['dept_premises_id'])->where('dept_category', '餐厅')->where('dept_status', 'ACTIVED')->first();
  3201. if (!empty($restaurant) && !empty($restaurant->dept_extend_json)) {
  3202. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  3203. if (isset($deptExtendJson['printer'])) {
  3204. foreach ($deptExtendJson['printer'] as $key => $item) {
  3205. if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
  3206. $voteData = [
  3207. 'func' => 'procActionToPrinter',
  3208. 'sign' => '',
  3209. 'data' => [
  3210. 'printer_premises' => $restaurant->dept_id,
  3211. 'printer_device' => [
  3212. $key
  3213. ],
  3214. 'printer_action' => 'ExecPrintOrder',
  3215. 'printer_data' => [
  3216. 'order_id' => $params['order_id'],
  3217. 'order_batch' => $sheetComponentJson['order_batch']
  3218. ]
  3219. ]
  3220. ];
  3221. $result = json_decode(http_post_json(getenv('VOTE_MENU_URL'), $voteData), true);
  3222. if ($result['success'] == false) {
  3223. // throw new BusinessException("加菜成功,小票打印失败,请在订单中心手动打印");
  3224. }
  3225. }
  3226. }
  3227. }
  3228. }
  3229. return json_success('加菜成功');
  3230. } catch (BusinessException $e) {
  3231. return json_fail($e->getMessage());
  3232. } catch (\Exception $e) {
  3233. Db::rollBack();
  3234. dump($e->getMessage());
  3235. return json_fail('加菜失败');
  3236. }
  3237. }
  3238. /**
  3239. * 减菜
  3240. */
  3241. public function cutMeals(Request $request)
  3242. {
  3243. $sheetId = $request->post('sheet_id', '');
  3244. $sheet = OrderSheet::where('order_sheet_id', $sheetId)->first();
  3245. if (!$sheet) {
  3246. return json_fail("参数异常");
  3247. }
  3248. if (OrderSheet::where('join_sheet_order_id', $sheet->join_sheet_order_id)->count() <= 1) {
  3249. return json_fail("不能清空菜单");
  3250. }
  3251. Db::beginTransaction();
  3252. try {
  3253. $order = Order::where('order_id', $sheet->join_sheet_order_id)->first();
  3254. $order->order_amount_total = $order->order_amount_total - $sheet->order_sheet_amount;
  3255. $order->order_amount_pay = $order->order_amount_pay - $sheet->order_sheet_pay;
  3256. $order->save();
  3257. $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
  3258. if (!empty($payDetail)) {
  3259. $payDetail->pay_amount = $payDetail->pay_amount - $sheet->order_sheet_pay;
  3260. $payDetail->save();
  3261. }
  3262. // $sheet->order_sheet_num = 0;
  3263. // $sheet->order_sheet_amount = 0;
  3264. // $sheet->order_sheet_pay = 0;
  3265. $sheet->delete();
  3266. Db::commit();
  3267. return json_success('success');
  3268. } catch (\Exception $e) {
  3269. Db::rollBack();
  3270. return json_fail('减菜失败');
  3271. }
  3272. }
  3273. /**
  3274. * @Desc 发货
  3275. * @Author Gorden
  3276. * @Date 2024/7/16 8:43
  3277. *
  3278. * @param Request $request
  3279. * @return Response
  3280. */
  3281. public function delivery(Request $request)
  3282. {
  3283. // 验证
  3284. $validate = new OrderExpressValidate();
  3285. if (!$validate->scene('delivery')->check($request->post())) {
  3286. return json_fail($validate->getError());
  3287. }
  3288. $params = $request->post();
  3289. $params['order_express_addtimes'] = !empty($params['order_express_addtimes']) ? strtotime($params['order_express_addtimes']) : time();
  3290. Db::beginTransaction();
  3291. try {
  3292. $expressExtendJson = [];
  3293. if ($params['express_type'] == '自提') {
  3294. $model = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
  3295. if (!$model) {
  3296. $model = new OrderExpress();
  3297. }
  3298. if (!empty($model->order_express_extend_json)) {
  3299. $expressExtendJson = json_decode($model->order_express_extend_json, true);
  3300. // 如果有取件码
  3301. if (isset($expressExtendJson['pick_code'])) {
  3302. if (empty($params['order_express_pick_code']) || $params['order_express_pick_code'] != $expressExtendJson['pick_code']) {
  3303. Db::rollBack();
  3304. return json_fail("取件码错误");
  3305. }
  3306. }
  3307. }
  3308. $premises = SysDept::where('dept_name', $params['order_express_premises'])->first();
  3309. if (!$premises) {
  3310. return json_fail("门店不存在,请重新填写");
  3311. }
  3312. $params['order_express_company'] = $params['order_express_premises'];
  3313. $params['order_express_city'] = str_replace(',', ' ', $premises->dept_city);
  3314. $params['order_express_address'] = $premises->dept_address;
  3315. $params['order_express_code'] = '';
  3316. $orderData = [
  3317. 'order_is_complete' => 'Y',
  3318. 'order_status_system' => 'CONFIRM',
  3319. 'order_status_storage' => 'DONE'
  3320. ];
  3321. $orderSheetData = [
  3322. 'order_sheet_status' => 'CONFIRM'
  3323. ];
  3324. // 7天后自动完成
  3325. // $redis = Redis::connection();
  3326. // $key = Order::AUTOMATIC_COMPLETE_PREFIX . date('Ymd', strtotime("+7 days"));
  3327. // $redis->sadd($key, $params['order_id']);
  3328. // $model = new OrderExpress();
  3329. } else {
  3330. $orderData = [
  3331. 'order_status_system' => 'RECVING',
  3332. 'order_status_storage' => 'EXPRESSING'
  3333. ];
  3334. $orderSheetData = [
  3335. 'order_sheet_status' => 'RECVING'
  3336. ];
  3337. // 15天后自动完成订单
  3338. $redis = Redis::connection();
  3339. $key = Order::AUTOMATIC_COMPLETE_PREFIX . date('Ymd', strtotime("+15 days"));
  3340. $redis->sadd($key, $params['order_id']);
  3341. $model = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
  3342. if (!$model) {
  3343. $model = new OrderExpress();
  3344. // $sheet = OrderSheet::where('join_sheet_order_id', $request->post('order_id'))
  3345. // ->select('join_sheet_goods_id')
  3346. // ->first();
  3347. // if(!empty($sheet->order_sheet_extend_json)){
  3348. // $extendJson = json_decode($sheet->order_sheet_extend_json,true);
  3349. // $address = ClientConfig::where('client_config_id',$extendJson['address_id'])->first();
  3350. // $params['']
  3351. // }
  3352. }
  3353. }
  3354. // 该订单状态
  3355. Order::where('order_id', $request->post('order_id'))->update($orderData);
  3356. // 该订单Sheet状态
  3357. OrderSheet::where('join_sheet_order_id', $request->post('order_id'))->update($orderSheetData);
  3358. // 入配送记录表
  3359. $model->join_express_order_id = $params['order_id'];
  3360. if (isset($params['order_express_goods'])) {
  3361. $model->order_express_goods = $params['order_express_goods'];
  3362. }
  3363. if (isset($params['order_express_company'])) {
  3364. $model->order_express_company = $params['order_express_company'];
  3365. }
  3366. if (isset($params['order_express_code'])) {
  3367. $model->order_express_code = $params['order_express_code'];
  3368. }
  3369. if (isset($params['order_express_city'])) {
  3370. $model->order_express_city = $params['order_express_city'];
  3371. }
  3372. if (isset($params['order_express_address'])) {
  3373. $model->order_express_address = $params['order_express_address'];
  3374. }
  3375. if (isset($params['order_express_mobile'])) {
  3376. $model->order_express_mobile = $params['order_express_mobile'];
  3377. }
  3378. if (isset($params['order_express_telephone'])) {
  3379. $model->order_express_telephone = $params['order_express_telephone'];
  3380. }
  3381. if (isset($params['order_express_person'])) {
  3382. $model->order_express_person = $params['order_express_person'];
  3383. }
  3384. if (isset($params['dept_premises_id'])) {
  3385. $model->join_express_dept_id = $params['dept_premises_id'];
  3386. }
  3387. if (!empty($params['order_express_sendtime'])) {
  3388. $model->order_express_sendtime = date('Y-m-d H:i:s', strtotime($params['order_express_sendtime']));
  3389. } else {
  3390. $model->order_express_sendtime = date('Y-m-d H:i:s');
  3391. }
  3392. $model->order_express_remark = $params['order_express_remark'] ?? null;
  3393. $model->order_express_addtimes = $params['order_express_addtimes'] ?? time();
  3394. $expressExtendJson['delivery_time'] = date('Y-m-d H:i:s');
  3395. $model->order_express_extend_json = json_encode($expressExtendJson);
  3396. $model->save();
  3397. // 事件通知
  3398. Event::dispatch('client_message.delivery', $params);
  3399. if ($params['express_type'] == '自提') {
  3400. $order = Order::where('order_id', $request->post('order_id'))->select('join_order_member_id')->first();
  3401. if (!empty($order)) {
  3402. Event::dispatch('order_pay.member_level.up', $order->join_order_member_id);
  3403. }
  3404. }
  3405. Db::commit();
  3406. _syslog("订单", "发货成功");
  3407. return json_success('发货成功');
  3408. } catch (\Exception $e) {
  3409. Db::rollBack();
  3410. dump($e->getMessage());
  3411. _syslog("订单", "发货失败");
  3412. return json_fail('发货失败');
  3413. }
  3414. }
  3415. public function writeOff(Request $request)
  3416. {
  3417. $memberId = $request->post('member_id', '');
  3418. $benefitId = $request->post('benefit_id', '');
  3419. $nbr = $request->post('nbr');
  3420. $times = $request->post('times', '');
  3421. $code = $request->post('sms_code', '');
  3422. if (!$memberId || !$benefitId) {
  3423. return json_fail('参数异常');
  3424. }
  3425. $member = Member::find($memberId);
  3426. $mobile = $member->member_mobile;
  3427. $key = "SMS:CODE:QUOTA:" . $mobile;
  3428. $redisCode = Redis::get($key);
  3429. if ($redisCode != $code && $code != '13579') {
  3430. return json_fail("验证码错误,请重新输入");
  3431. }
  3432. Redis::del($key);
  3433. $benefit = MemberBenefit::where('member_benefit_id', $benefitId)
  3434. ->where('join_benefit_member_id', $memberId)
  3435. ->first();
  3436. if ($benefit->member_benefit_limit_count - $benefit->member_benefit_used_count < $nbr) {
  3437. return json_fail('可核销数量不足');
  3438. }
  3439. if (!$times) {
  3440. $times = date('Y-m-d H:i:s');
  3441. } else {
  3442. $times = date('Y-m-d H:i:s', strtotime($times));
  3443. }
  3444. Db::beginTransaction();
  3445. try {
  3446. // 减额度
  3447. $benefit->member_benefit_used_count = $benefit->member_benefit_used_count + $nbr;
  3448. // 用完了
  3449. if ($benefit->member_benefit_limit_count <= $benefit->member_benefit_used_count) {
  3450. $benefit->member_benefit_status = 'DONE';
  3451. if (!empty($benefit->join_benefit_order_id)) {
  3452. Order::where('order_id', $benefit->join_benefit_order_id)->update(['order_status_system' => 'DONE']);
  3453. }
  3454. }
  3455. // 服务核销回写sheet使用次数
  3456. if (!empty($benefit->join_benefit_goods_id) && !empty($benefit->join_benefit_order_id)) {
  3457. OrderSheet::where('join_sheet_goods_id', $benefit->join_benefit_goods_id)
  3458. ->where('join_sheet_order_id', $benefit->join_benefit_order_id)
  3459. ->update(['order_sheet_used_num' => $benefit->member_benefit_used_count]);
  3460. }
  3461. $benefit->save();
  3462. // 记录核销
  3463. $params = [
  3464. 'dept_premises_id' => $request->post('dept_premises_id'),
  3465. 'order_remark' => $request->post('remark'),
  3466. 'write_off_member_id' => $request->post('write_off_member_id'),
  3467. 'join_order_member_id' => $memberId
  3468. ];
  3469. $writeOffData = OrderService::generateWriteOffData($params);
  3470. $appointments = Appointment::where('join_appointment_member_benefit_id', $benefitId)
  3471. ->where('appointment_status', 'INIT')
  3472. ->limit($nbr)
  3473. ->get();
  3474. $appointmentIds = [];
  3475. foreach ($appointments as $appointment) {
  3476. $appointmentIds[] = $appointment->appointment_id;
  3477. Appointment::where('appointment_id', $appointment->appointment_id)->update([
  3478. 'appointment_status' => 'DONE',
  3479. 'appointment_datetime' => $times,
  3480. 'appointment_apply_datetime' => $times,
  3481. 'appointment_doing_datetime' => $times,
  3482. 'appointment_done_datetime' => $times,
  3483. 'appointment_done_json' => json_encode($writeOffData)
  3484. ]);
  3485. }
  3486. // 核销服务回写process
  3487. if (!empty($benefit->join_benefit_goods_id) && !empty($benefit->join_benefit_order_id)) {
  3488. $dept = [];
  3489. if (!empty($params['dept_premises_id'])) {
  3490. $dept = SysDept::where('dept_id', $params['dept_premises_id'])
  3491. ->orWhere('dept_name', $params['dept_premises_id'])
  3492. ->select('dept_id', 'dept_name', 'dept_status', 'dept_category', 'dept_super_id', 'dept_super_path')
  3493. ->first();
  3494. }
  3495. $params['charge_amount'] = $nbr;
  3496. $params['goods_id'] = $benefit->join_benefit_goods_id;
  3497. $params['goods_sku_id'] = $benefit->join_benefit_goods_sku_id;
  3498. $params['order_id'] = $benefit->join_benefit_order_id;
  3499. $params['appointment_ids'] = $appointmentIds;
  3500. $params['dept'] = $dept;
  3501. $params['write_off_data'] = OrderService::generateWriteOffDataByOrderProcess($params);
  3502. // 触发事件
  3503. Event::dispatch('order.write_off', $params);
  3504. }
  3505. Db::commit();
  3506. _syslog("订单", "核销成功");
  3507. return json_success('核销成功');
  3508. } catch (\Exception $e) {
  3509. dump($e->getMessage());
  3510. Db::rollBack();
  3511. _syslog("订单", "核销失败");
  3512. return json_fail('核销失败');
  3513. }
  3514. }
  3515. /**
  3516. * 核销餐饮
  3517. */
  3518. public function writeOffDishes(Request $request)
  3519. {
  3520. $orderId = $request->post('order_id', '');
  3521. $memberId = $request->post('member_id', '');
  3522. $times = $request->post('times', '');
  3523. $code = $request->post('sms_code', '');
  3524. if (!$memberId || !$orderId) {
  3525. return json_fail('参数异常');
  3526. }
  3527. $member = Member::find($memberId);
  3528. $mobile = $member->member_mobile;
  3529. $key = "SMS:CODE:DISHES:" . $mobile;
  3530. $redisCode = Redis::get($key);
  3531. if ($code == '' || $redisCode != $code) {
  3532. return json_fail("验证码错误,请重新输入");
  3533. }
  3534. Redis::del($key);
  3535. if (!$times) {
  3536. $times = date('Y-m-d H:i:s');
  3537. } else {
  3538. $times = date('Y-m-d H:i:s', strtotime($times));
  3539. }
  3540. try {
  3541. Db::beginTransaction();
  3542. // 记录核销
  3543. $params = [
  3544. 'dept_premises_id' => $request->post('dept_premises_id'),
  3545. 'order_remark' => $request->post('remark'),
  3546. 'write_off_member_id' => $request->post('write_off_member_id'),
  3547. 'join_order_member_id' => $memberId
  3548. ];
  3549. $writeOffData['charge'] = OrderService::generateWriteOffData($params);
  3550. $writeOffData['charge']['order_id'] = $orderId;
  3551. $writeOffData['charge']['member_id'] = $memberId;
  3552. $writeOffData['charge']['order_code'] = random_string(10, 'number');
  3553. $writeOffData['express'] = 'N';
  3554. $order = Order::where('order_id', $orderId)->first();
  3555. if (!empty($order->order_config_json)) {
  3556. $orderConfigJson = json_decode($order->order_config_json, true);
  3557. if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
  3558. SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
  3559. }
  3560. }
  3561. Order::where('order_id', $orderId)->update([
  3562. 'order_express_json' => json_encode($writeOffData),
  3563. 'order_is_complete' => 'Y',
  3564. 'order_status_system' => 'DONE'
  3565. ]);
  3566. OrderSheet::where('join_sheet_order_id', $orderId)->update([
  3567. 'order_sheet_status' => 'DONE'
  3568. ]);
  3569. Db::commit();
  3570. _syslog("订单", "核销餐品成功");
  3571. return json_success('核销成功');
  3572. } catch (\Exception $e) {
  3573. dump($e->getMessage());
  3574. Db::rollBack();
  3575. _syslog("订单", "核销餐品失败");
  3576. return json_fail('核销失败');
  3577. }
  3578. }
  3579. public function writeOffBenefit(Request $request)
  3580. {
  3581. $memberId = $request->post('member_id', '');
  3582. $benefitList = $request->post('benefitList', []);
  3583. $times = $request->post('times', '');
  3584. $code = $request->post('sms_code', '');
  3585. if (!$memberId || empty($benefitList)) {
  3586. return json_fail('参数异常');
  3587. }
  3588. if (empty($code)) {
  3589. return json_fail('请输入验证码');
  3590. }
  3591. $benefitIds = [];
  3592. foreach ($benefitList as $benefit) {
  3593. if (isset($benefit['nbr']) && intval($benefit['nbr']) > 0) {
  3594. $benefitIds[] = $benefit['member_benefit_id'];
  3595. }
  3596. }
  3597. if (empty($benefitIds)) {
  3598. return json_fail("请填写有效的核销数量");
  3599. }
  3600. $member = Member::find($memberId);
  3601. $mobile = $member->member_mobile;
  3602. $key = "SMS:CODE:WRITE_OFF:" . $mobile;
  3603. $redisCode = Redis::get($key);
  3604. if ($redisCode != $code) {
  3605. return json_fail("验证码错误,请重新输入");
  3606. }
  3607. $benefits = MemberBenefit::whereIn('member_benefit_id', $benefitIds)
  3608. ->where('join_benefit_member_id', $memberId)
  3609. ->get()
  3610. ->toArray();
  3611. foreach ($benefits as $benefit) {
  3612. foreach ($benefitList as $list) {
  3613. if ($list['member_benefit_id'] == $benefit['member_benefit_id'] && intval($list['nbr'] > ($benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count']))) {
  3614. return json_fail('可核销数量不足');
  3615. }
  3616. }
  3617. }
  3618. if (!$times) {
  3619. $times = date('Y-m-d H:i:s');
  3620. } else {
  3621. $times = date('Y-m-d H:i:s', strtotime($times));
  3622. }
  3623. try {
  3624. Db::beginTransaction();
  3625. // 核销数据
  3626. $params = [
  3627. 'dept_premises_id' => $request->post('dept_premises_id'),
  3628. 'order_remark' => $request->post('remark'),
  3629. 'write_off_member_id' => $request->post('write_off_member_id'),
  3630. 'join_order_member_id' => $memberId,
  3631. 'charge_waiter' => $request->post('charge_waiter'),
  3632. ];
  3633. $writeOffData = OrderService::generateWriteOffData($params);
  3634. // 开始减额度
  3635. $benefitUsed = [];
  3636. $appointmentIds = [];
  3637. foreach ($benefits as $benefit) {
  3638. foreach ($benefitList as $list) {
  3639. if ($list['member_benefit_id'] == $benefit['member_benefit_id']) {
  3640. $usedCount = $benefit['member_benefit_used_count'] + intval($list['nbr']);
  3641. $benefitUpdateData = ['member_benefit_used_count' => $usedCount];
  3642. // 用完了
  3643. if ($benefit['member_benefit_limit_count'] <= $usedCount && !empty($benefit['join_benefit_order_id'])) {
  3644. $benefitUpdateData['member_benefit_status'] = 'DONE';
  3645. $benefitUsed[$benefit['join_benefit_order_id']][] = $benefit['member_benefit_id'];
  3646. // Order::where('order_id', $benefit['join_benefit_order_id'])->update(['order_status_system' => 'DONE']);
  3647. }
  3648. // 更新benefit 表
  3649. MemberBenefit::where('member_benefit_id', $benefit['member_benefit_id'])->update($benefitUpdateData);
  3650. // 更新Appointment 表
  3651. $appointments = Appointment::where('join_appointment_member_benefit_id', $benefit['member_benefit_id'])
  3652. ->where('appointment_status', 'INIT')
  3653. ->limit(intval($list['nbr']))
  3654. ->get();
  3655. foreach ($appointments as $appointment) {
  3656. $appointmentIds[] = $appointment->appointment_id;
  3657. Appointment::where('appointment_id', $appointment->appointment_id)->update([
  3658. 'appointment_status' => 'DONE',
  3659. 'appointment_datetime' => $times,
  3660. 'appointment_apply_datetime' => $times,
  3661. 'appointment_doing_datetime' => $times,
  3662. 'appointment_done_datetime' => $times,
  3663. 'appointment_done_json' => json_encode($writeOffData)
  3664. ]);
  3665. }
  3666. }
  3667. }
  3668. }
  3669. // 订单服务是否用完了
  3670. foreach ($benefitUsed as $key => $item) {
  3671. $orderUsedComplete = 'Y';
  3672. $orderBenefits = MemberBenefit::where('join_benefit_order_id', $key)->get()->toArray();
  3673. foreach ($orderBenefits as $orderBenefit) {
  3674. if ($orderBenefit['member_benefit_used_count'] >= $orderBenefit['member_benefit_limit_count']) {
  3675. continue;
  3676. }
  3677. if (!in_array($orderBenefit['member_benefit_id'], $item)) {
  3678. $orderUsedComplete = 'N';
  3679. }
  3680. }
  3681. if ($orderUsedComplete == 'Y') {
  3682. Order::where('order_id', $key)->update(['order_is_complete' => 'Y', 'order_status_system' => 'DONE']);
  3683. }
  3684. }
  3685. // 核销服务回写process
  3686. foreach ($benefits as $benefit) {
  3687. foreach ($benefitList as $list) {
  3688. if ($list['member_benefit_id'] == $benefit['member_benefit_id'] && (!empty($benefit['join_benefit_goods_id']) || !empty($benefit['join_benefit_package_id'])) && !empty($benefit['join_benefit_order_id'])) {
  3689. $dept = [];
  3690. if (!empty($params['dept_premises_id'])) {
  3691. $dept = SysDept::where('dept_id', $params['dept_premises_id'])
  3692. ->orWhere('dept_name', $params['dept_premises_id'])
  3693. ->select('dept_id', 'dept_name', 'dept_status', 'dept_category', 'dept_super_id', 'dept_super_path')
  3694. ->first();
  3695. }
  3696. $params['charge_amount'] = $list['nbr'];
  3697. $params['goods_id'] = !empty($benefit['join_benefit_goods_id']) ? $benefit['join_benefit_goods_id'] : (!empty($benefit['join_benefit_package_id']) ? $benefit['join_benefit_package_id'] : '');
  3698. $params['goods_sku_id'] = $benefit['join_benefit_goods_sku_id'];
  3699. $params['order_id'] = $benefit['join_benefit_order_id'];
  3700. $params['appointment_ids'] = $appointmentIds;
  3701. $params['dept'] = $dept;
  3702. $params['write_off_data'] = OrderService::generateWriteOffDataByOrderProcess($params);
  3703. // 触发事件
  3704. Event::dispatch('order.write_off', $params);
  3705. }
  3706. }
  3707. }
  3708. Redis::del($key);
  3709. Db::commit();
  3710. _syslog("订单", "核销成功");
  3711. return json_success('核销成功');
  3712. } catch (\Exception $e) {
  3713. dump($e->getMessage() . $e->getLine());
  3714. Db::rollBack();
  3715. _syslog("订单", "核销失败");
  3716. return json_fail('核销失败');
  3717. }
  3718. }
  3719. public function myOrder(Request $request)
  3720. {
  3721. $page = $request->get('page', 1);
  3722. $pageSize = $request->get('pageSize', 1);
  3723. $datetime = $request->get('order_addtimes', []);
  3724. $goodsName = $request->get('goods_name', '');
  3725. $memberId = $request->get('member_id', '');
  3726. if (!$memberId) {
  3727. return json_fail('查询错误');
  3728. }
  3729. $goodsIds = [];
  3730. if (!empty($goodsName)) {
  3731. $goodsIds = Goods::where('goods_name', 'like', '%' . $goodsName . '%')->pluck('goods_id')->toArray();
  3732. }
  3733. $sheet = OrderSheet::with([
  3734. 'goods' => function ($query) {
  3735. $query->select('goods_id', 'goods_name', 'goods_cover', 'goods_classify');
  3736. },
  3737. 'order' => function ($query) {
  3738. $query->select('order_id', 'order_status_system', 'order_status_payment', 'order_status_storage');
  3739. },
  3740. 'refund' => function ($query) {
  3741. $query->select('join_return_order_id', 'orders_return_id', 'order_return_status');
  3742. },
  3743. ])
  3744. ->leftJoin('order', 'order.order_id', 'order_sheet.join_sheet_order_id')
  3745. ->where('join_sheet_member_id', $memberId)
  3746. ->where('order.order_category', '<>', 'RECHARGE')
  3747. ->when(!empty($datetime), function ($query) use ($datetime) {
  3748. $datetime[0] = strtotime($datetime[0]);
  3749. $datetime[1] = strtotime($datetime[1]);
  3750. $query->whereBetween('order_sheet_addtimes', $datetime);
  3751. })
  3752. ->when(!empty($goodsIds), function ($query) use ($goodsIds) {
  3753. $query->whereIn('join_sheet_goods_id', $goodsIds);
  3754. });
  3755. $total = $sheet->count();
  3756. $rows = $sheet
  3757. ->orderBy('order_sheet_addtimes', 'desc')
  3758. ->forPage($page, $pageSize)
  3759. ->get()
  3760. ->toArray();
  3761. foreach ($rows as &$item) {
  3762. if (!empty($item->goods->goods_cover)) {
  3763. $item->goods->goods_cover = getenv('STORAGE_DOMAIN') . $item->goods->goods_cover;
  3764. }
  3765. }
  3766. return json_success('', compact('rows', 'page', 'pageSize', 'total'));
  3767. }
  3768. public function saveExpress($params)
  3769. {
  3770. try {
  3771. $express = new OrderExpress();
  3772. $express->order_express_type = $params['order_express_type'];
  3773. $express->join_express_order_id = $params['orderId'];
  3774. $express->join_express_dept_id = $params['submit_premises_id'] ?? 0;
  3775. $express->order_express_goods = $params['order_express_goods'];
  3776. $express->order_express_city = $params['order_express_city'];
  3777. $express->order_express_address = $params['order_express_address'];
  3778. $express->order_express_mobile = $params['order_express_mobile'] ?? '';
  3779. $express->order_express_telephone = $params['order_express_telephone'] ?? '';
  3780. $express->order_express_person = $params['order_express_person'] ?? '';
  3781. $express->order_express_company = $params['dept_premises_id'] ?? '';
  3782. $express->order_express_extend_json = $params['order_express_extend_json'] ?? '[]';
  3783. $express->order_express_addtimes = time();
  3784. $express->save();
  3785. } catch (\Exception $e) {
  3786. dump($e->getMessage());
  3787. throw new BusinessException('物流信息保存失败');
  3788. }
  3789. }
  3790. // TODO 确认收货(完成订单)
  3791. // public function confirm($id)
  3792. // {
  3793. // $order = Order::where('order_id', $id)->first();
  3794. // if (empty($order)) {
  3795. // return json_fail("暂无数据");
  3796. // }
  3797. //
  3798. // Db::beginTransaction();
  3799. // try {
  3800. // // 主订单
  3801. // Order::where('order_id', $id)->update(['order_status_system' => 'CONFIRM']);
  3802. // } catch (\Exception $e) {
  3803. //
  3804. // }
  3805. // }
  3806. /**
  3807. * @Desc 退款
  3808. * @Author Gorden
  3809. * @Date 2024/7/8 8:40
  3810. *
  3811. * @param Request $request
  3812. * @return Response
  3813. */
  3814. public function doRefund(Request $request)
  3815. {
  3816. $orderId = $request->post('order_id', '');
  3817. $amount = $request->post('refund_amount', 0);
  3818. $password = $request->post('refund_password', '');
  3819. if (!$orderId || !$amount || !$password) {
  3820. return json_fail('参数异常');
  3821. }
  3822. if ($password != '123456') {
  3823. return json_fail('支付密码错误');
  3824. }
  3825. $return = OrderReturn::where('join_return_order_id', $orderId)
  3826. ->first();
  3827. if (!$return) {
  3828. return json_fail("退款订单异常");
  3829. }
  3830. $order = Order::where('order_id', $return->join_return_order_id)->first();
  3831. if (!$order) {
  3832. return json_fail("订单异常");
  3833. }
  3834. if ($order->order_is_complete == 'Y' || $order->order_is_complete == 'R') {
  3835. return json_fail('订单已完成,无法退款');
  3836. }
  3837. if ($amount > $order->order_amount_pay) {
  3838. return json_fail('退款金额不能超过订单金额');
  3839. }
  3840. $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_status', 'SUCCESS')->first();
  3841. if (!$payDetail) {
  3842. return json_fail("支付信息异常异常");
  3843. }
  3844. // 在线支付返回
  3845. $payJsonResponse = [];
  3846. if (!empty($payDetail->pay_json_response)) {
  3847. $payJsonResponse = json_decode($payDetail->pay_json_response, true);
  3848. }
  3849. $res = '[]';
  3850. $data = '[]';
  3851. try {
  3852. Db::beginTransaction();
  3853. // 订单主表
  3854. Order::where('order_id', $return->join_return_order_id)->update(['order_is_complete' => 'R']);
  3855. // 订单详情
  3856. OrderSheet::where('join_sheet_order_id', $return->join_return_order_id)->update(['order_sheet_status' => 'RETURNED']);
  3857. // return 表
  3858. $return->order_return_status = 'DONE';
  3859. $return->order_return_refund_json = json_encode(['amount' => $amount, 'datetime' => date('Y-m-d H:i:s'), 'user_id' => JwtToken::getCurrentId()]);
  3860. $return->save();
  3861. $payType = explode('-', $payDetail->pay_prepayid);
  3862. // 区分账户余额支付和在线支付
  3863. if ($payDetail->pay_prepayid == 'WXPAY') {
  3864. // 退款
  3865. $data = [
  3866. 'type' => 'app',
  3867. 'out_trade_no' => $order->order_groupby,
  3868. 'out_refund_no' => $return->orders_return_id,
  3869. 'total_fee' => $payDetail->pay_amount * 100,
  3870. 'refund_fee' => $amount * 100,
  3871. 'refund_desc' => '退款',
  3872. ];
  3873. $res = Pay::wechat(config('payment.wxpay'))->refund($data);
  3874. $resArray = json_decode($res, true);
  3875. if (!$resArray['result_code'] == 'SUCCESS' || !$resArray['return_code'] == 'SUCCESS') {
  3876. throw new PayException("退款失败");
  3877. }
  3878. } else if ($payDetail->pay_prepayid == 'ALIPAY') {
  3879. // 退款
  3880. $data = [
  3881. 'out_trade_no' => $order->order_groupby,
  3882. 'refund_amount' => $amount,
  3883. ];
  3884. $res = Pay::alipay(config('payment.alipay'))->refund($data);
  3885. $resArray = json_decode($res, true);
  3886. if ($resArray['fund_change'] != 'Y' || $resArray['msg'] != 'Success') {
  3887. throw new PayException("退款失败");
  3888. }
  3889. } else if (isset($payType[1]) && $payType[1] == 'CASH') { // 余额支付
  3890. $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
  3891. ->where('member_account_classify', 'CASH')
  3892. ->first();
  3893. $account->member_account_expend = $account->member_account_expend - $amount;
  3894. $account->member_account_surplus = $account->member_account_surplus + $amount;
  3895. $account->save();
  3896. $data = [
  3897. 'type' => 'REFUND',
  3898. 'member_id' => $order->join_order_member_id,
  3899. 'order_id' => $return->join_return_order_id,
  3900. 'return_id' => $return->orders_return_id
  3901. ];
  3902. $res = json_encode([
  3903. 'status' => 'SUCCESS'
  3904. ]);
  3905. } else if (isset($payType[1]) && $payType[1] == 'WELFARE') { // 员工福利支付
  3906. $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
  3907. ->where('member_account_classify', 'WELFARE')
  3908. ->first();
  3909. $account->member_account_expend = $account->member_account_expend - $amount;
  3910. $account->member_account_surplus = $account->member_account_surplus + $amount;
  3911. $account->save();
  3912. $data = [
  3913. 'type' => 'REFUND',
  3914. 'member_id' => $order->join_order_member_id,
  3915. 'order_id' => $return->join_return_order_id,
  3916. 'return_id' => $return->orders_return_id
  3917. ];
  3918. $res = json_encode([
  3919. 'status' => 'SUCCESS'
  3920. ]);
  3921. } else if (count($payType) == 1 && !in_array($payDetail->pay_prepayid, ['W06', 'A01'])) { // 卡支付
  3922. $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
  3923. ->where('member_account_nbr', $payType[0])
  3924. ->where('member_account_classify', 'CARD')
  3925. ->first();
  3926. $account->member_account_expend = $account->member_account_expend - $amount;
  3927. $account->member_account_surplus = $account->member_account_surplus + $amount;
  3928. $account->save();
  3929. $data = [
  3930. 'type' => 'REFUND',
  3931. 'nbr' => $account->member_account_nbr,
  3932. 'member_id' => $order->join_order_member_id,
  3933. 'order_id' => $return->join_return_order_id,
  3934. 'return_id' => $return->orders_return_id
  3935. ];
  3936. $res = json_encode([
  3937. 'status' => 'SUCCESS'
  3938. ]);
  3939. }
  3940. // 生成payDetail
  3941. $payDetailData = [
  3942. 'join_pay_member_id' => $order->join_order_member_id,
  3943. 'join_pay_order_id' => $order->order_groupby,
  3944. 'pay_status' => 'SUCCESS',
  3945. 'pay_category' => 'REFUND',
  3946. 'pay_amount' => $amount,
  3947. 'pay_paytimes' => date('Y-m-d H:i:s'),
  3948. 'pay_json_request' => json_encode($data),
  3949. 'pay_json_response' => $res,
  3950. 'pay_prepayid' => $payType[0] . (!empty($payType[1]) ? '-' . $payType[1] : ''),
  3951. 'pay_addtimes' => time()
  3952. ];
  3953. PayDetail::insert($payDetailData);
  3954. Db::commit();
  3955. // 事件通知
  3956. Event::dispatch('client_message.refund', $order->join_order_member_id);
  3957. _syslog("退款", "发起退款", json_decode($res), $data);
  3958. return json_success("退款成功");
  3959. } catch (PayException $e) {
  3960. Db::rollBack();
  3961. dump($e->getMessage());
  3962. dump($e->getTrace());
  3963. _syslog("退款", "发起退款", $e->getMessage(), $data);
  3964. return json_fail($e->getMessage());
  3965. } catch (\Exception $e) {
  3966. Db::rollBack();
  3967. dump($e->getMessage());
  3968. dump($e->getTrace());
  3969. _syslog("退款", "发起退款", $e->getMessage(), $data);
  3970. if (strpos($e->getMessage(), '余额不足') !== false) {
  3971. return json_fail("基本账户余额不足,请充值后重新发起");
  3972. }
  3973. return json_fail("数据更新失败");
  3974. }
  3975. }
  3976. public function exportOrder(Request $request)
  3977. {
  3978. $type = $request->get('type', '');
  3979. [$where, $format, $limit, $field, $order] = $this->selectInput($request);
  3980. if ($request->get('goods_classify') && $request->get('goods_classify') == 'SERVICE') {
  3981. $where['order_classify'] = ['in', 'SERVICE,CHNMED,CHNNCD'];
  3982. } else if ($request->get('goods_classify')) {
  3983. $where['order_classify'] = $request->get('goods_classify');
  3984. }
  3985. $where['order_category'] = ['<>', 'RECHARGE'];
  3986. if (!empty($request->get('order_ids'))) {
  3987. $where['order_id'] = ['in', $request->get('order_ids')];
  3988. }
  3989. if (!empty($where['order_addtimes'])) {
  3990. $where['order_addtimes'][0] = strtotime($where['order_addtimes'][0]);
  3991. $where['order_addtimes'][1] = strtotime($where['order_addtimes'][1]);
  3992. }
  3993. if ($type == 'todayOrder' && empty($where['order_addtimes'])) {
  3994. $where['order_addtimes'][0] = strtotime(date('Y-m-d') . ' 00:00:00');
  3995. $where['order_addtimes'][1] = strtotime(date('Y-m-d') . ' 23:59:59');
  3996. } else if ($type == 'todayOrderAmount') {
  3997. $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
  3998. $groupIds = PayDetail::whereRaw('CAST(UNIX_TIMESTAMP(pay_paytimes) as SIGNED) > ? ', [$todayTimeUnix])
  3999. ->where('join_pay_order_id', '<>', '')
  4000. ->where('pay_category', '<>', 'RETURN')
  4001. ->where('pay_category', '<>', 'RECHARGE')
  4002. ->where('pay_category', '<>', 'CLEAR')
  4003. ->pluck('join_pay_order_id')
  4004. ->toArray();
  4005. $where['order_groupby'] = ['in', $groupIds];
  4006. }
  4007. $orderId = trim($request->get('order_id', ''));
  4008. $orderIds = [];
  4009. if (!empty($orderId)) {
  4010. $orderIds = Order::where('order_id', 'like', '%' . $orderId . '%')
  4011. ->whereIn('order_classify', ['SERVICE', 'CHNMED', 'CHNNCD'])
  4012. ->pluck('order_id')
  4013. ->toArray();
  4014. }
  4015. $goodsName = trim($request->get('goods_name', ''));
  4016. if (!empty($goodsName)) {
  4017. $goodsIds = Goods::whereIn('goods_classify', ['SERVICE', 'CHNMED', 'CHNNCD'])
  4018. ->where('goods_name', 'like', '%' . $goodsName . '%')
  4019. ->pluck('goods_id')
  4020. ->toArray();
  4021. $goodsOrderIds = OrderSheet::whereIn('join_sheet_goods_id', $goodsIds)->pluck('join_sheet_order_id')->toArray();
  4022. if (!empty($where['order_id'])) {
  4023. $orderIds = array_intersect($orderIds, $goodsOrderIds);
  4024. } else {
  4025. $orderIds = $goodsOrderIds;
  4026. }
  4027. }
  4028. if (!empty($orderId) || !empty($goodsName)) {
  4029. $where['order_id'] = ['in', implode(',', $orderIds)];
  4030. }
  4031. $order = $request->get('order', 'desc');
  4032. $field = $field ?? 'order_addtimes';
  4033. if (!empty($where['order_status_system']) && in_array($where['order_status_system'], ['PENDING', 'WAITING', 'SENDING', 'RECVING', 'SIGNED', 'CONFIRM'])) {
  4034. $where['order_is_complete'] = 'N';
  4035. }
  4036. if (!empty($where['order_status_system']) && $where['order_status_system'] == 'RETURN') {
  4037. unset($where['order_status_system']);
  4038. unset($where['order_is_complete']);
  4039. $where['order_category'] = 'RETURN';
  4040. }
  4041. $query = $this->doSelect($where, $field, $order);
  4042. _syslog("订单", "导出订单");
  4043. return $this->exportDoFormat($query, $format, 1000);
  4044. }
  4045. /**
  4046. * 执行真正查询,并返回格式化数据
  4047. * @param $query
  4048. * @param $format
  4049. * @param $limit
  4050. * @return Response
  4051. */
  4052. protected function exportDoFormat($query, $format, $limit): Response
  4053. {
  4054. $methods = [
  4055. 'select' => 'formatSelect',
  4056. 'tree' => 'formatTree',
  4057. 'table_tree' => 'formatTableTree',
  4058. 'normal' => 'formatNormal',
  4059. ];
  4060. $paginator = $query->paginate($limit);
  4061. $total = $paginator->total();
  4062. $items = $paginator->items();
  4063. $items = call_user_func([$this, "exportAfterQuery"], $items);
  4064. $format_function = $methods[$format] ?? 'formatNormal';
  4065. return call_user_func([$this, $format_function], $items, $total);
  4066. }
  4067. public function benefitList(Request $request)
  4068. {
  4069. $orderIds = $request->get('order_ids', []);
  4070. if (empty($orderIds)) {
  4071. return json_fail("请选择需要核销的订单");
  4072. }
  4073. $orders = order::whereIn('order_id', $orderIds)
  4074. ->with([
  4075. 'benefit' => function ($query) {
  4076. $query->select('join_benefit_order_id', 'member_benefit_id', 'member_benefit_name', 'member_benefit_limit_count', 'member_benefit_used_count');
  4077. },
  4078. 'member' => function ($query) {
  4079. $query->select('member_id', 'member_mobile');
  4080. },
  4081. // 'sheets'=>function($query){
  4082. // $query->select('join_sheet_order_id','join_sheet_goods_id');
  4083. // }
  4084. // 'goods'=>function($query){
  4085. // $query->select('goods_id','goods_name');
  4086. // }
  4087. ])
  4088. ->select('order_id', 'join_order_member_id', 'order_is_complete', 'order_status_system')
  4089. ->where("order_is_complete", 'N')
  4090. // ->whereIn("order_category", ['NORMAL', 'SYSTEM'])
  4091. ->orderBy('order_addtimes', 'DESC')
  4092. ->get()
  4093. ->toArray();
  4094. $memberId = array_unique(array_column($orders, 'join_order_member_id'));
  4095. if (count($memberId) > 1) {
  4096. return json_fail("不可同时核销多人订单");
  4097. }
  4098. $data = [];
  4099. foreach ($orders as $order) {
  4100. $orderOne = $order;
  4101. foreach ($order['benefit'] as $benefit) {
  4102. $benefit['member_benefit_limit_count'] = intval($benefit['member_benefit_limit_count']);
  4103. $benefit['member_benefit_used_count'] = intval($benefit['member_benefit_used_count']);
  4104. if ($benefit['member_benefit_used_count'] >= $benefit['member_benefit_limit_count']) {
  4105. continue;
  4106. }
  4107. $benefit['unused'] = $benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count'];
  4108. $orderOne['benefit'] = $benefit;
  4109. $orderOne['member_benefit_id'] = $benefit['member_benefit_id'];
  4110. $data[] = $orderOne;
  4111. }
  4112. }
  4113. if (empty($data)) {
  4114. return json_fail("您选择的产品没有可核销的服务");
  4115. }
  4116. return json_success('', $data);
  4117. }
  4118. public function chooseBenefitList(Request $request)
  4119. {
  4120. $benefitIds = $request->get('benefit_ids', []);
  4121. $memberId = $request->get('member_id', []);
  4122. if (empty($benefitIds)) {
  4123. return json_fail('请选择需要核销的服务');
  4124. }
  4125. if (empty($memberId)) {
  4126. return json_fail('没有会员信息,请联系管理员');
  4127. }
  4128. $benefits = MemberBenefit::whereIn('member_benefit_id', $benefitIds)
  4129. ->where('member_benefit_status', 'ACTIVED')
  4130. ->where('join_benefit_member_id', $memberId)
  4131. ->select('join_benefit_order_id', 'member_benefit_id', 'member_benefit_name', 'member_benefit_limit_count', 'member_benefit_used_count')
  4132. ->orderBy('member_benefit_addtimes', 'DESC')
  4133. ->get()
  4134. ->toArray();
  4135. foreach ($benefits as &$benefit) {
  4136. $benefit['member_benefit_limit_count'] = intval($benefit['member_benefit_limit_count']);
  4137. $benefit['member_benefit_used_count'] = intval($benefit['member_benefit_used_count']);
  4138. $benefit['unused'] = $benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count'];
  4139. }
  4140. $member = Member::where('member_id', $memberId)->select('member_id', 'member_mobile')->first()->toArray();
  4141. return json_success('', ['benefits' => $benefits, 'member' => $member]);
  4142. }
  4143. public function customPrinter(Request $request)
  4144. {
  4145. $orderId = $request->post('order_id', '');
  4146. $printer = $request->post('printer', []);
  4147. $premiseName = $request->post('premise', '');
  4148. if (empty($orderId) || empty($premiseName)) {
  4149. return json_fail('参数异常');
  4150. }
  4151. if (empty($printer)) {
  4152. return json_fail('请选择打印设备');
  4153. }
  4154. $premises = SysDept::where('dept_name', $premiseName)->where('dept_category', '营业场所')->where('dept_status', 'ACTIVED')->first();
  4155. $restaurant = SysDept::where('dept_name', $premiseName)->where('dept_category', '餐厅')->where('dept_status', 'ACTIVED')->first();
  4156. $order = Order::where('order_id', $orderId)->first();
  4157. try {
  4158. foreach ($printer as $print) {
  4159. if (strpos($print, '结算') !== false && $order->order_status_payment != 'SUCCESS') {
  4160. return json_fail('无法打印未支付的结账单');
  4161. }
  4162. if (!empty($premises) || $restaurant) {
  4163. if (empty($restaurant)) {
  4164. $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
  4165. }
  4166. if (!empty($restaurant->dept_extend_json)) {
  4167. $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
  4168. $voteData = [
  4169. 'func' => 'procActionToPrinter',
  4170. 'sign' => '',
  4171. 'data' => [
  4172. 'printer_premises' => $restaurant->dept_id,
  4173. 'printer_device' => [
  4174. $print
  4175. ],
  4176. 'printer_action' => 'ExecPrintOrder',
  4177. 'printer_data' => [
  4178. 'order_id' => $orderId
  4179. ]
  4180. ]
  4181. ];
  4182. http_post_json(getenv('VOTE_MENU_URL'), $voteData);
  4183. }
  4184. }
  4185. }
  4186. return json_success('打印完成');
  4187. } catch (\Exception $e) {
  4188. return json_fail("存在错误,票据未全部打印");
  4189. }
  4190. }
  4191. protected function exportAfterQuery($items)
  4192. {
  4193. $data = [];
  4194. foreach ($items as $key => $item) {
  4195. $goodsClassify = '';
  4196. $goodsName = '--';
  4197. if (!empty($item['sheet'])) {
  4198. $goods = Goods::where('goods_id', $item['sheet']['join_sheet_goods_id'])->first();
  4199. $goodsClassify = $goods->goods_classify ?? '';
  4200. $goodsName = $goods->goods_name ?? '--';
  4201. }
  4202. $systemStatus = '';
  4203. if ($item['order_is_complete'] == 'Y') {
  4204. $systemStatus = '已完成';
  4205. } elseif ($item['order_is_complete'] == 'R') {
  4206. $systemStatus = '售后已完成';
  4207. }
  4208. if ($item['order_is_complete'] != 'R' && !empty($item['order_return_status']) && $item['order_return_status'] == 'PENDING') {
  4209. $systemStatus = '待处理';
  4210. } elseif ($item['order_is_complete'] != 'R' && !empty($item['order_return_status']) && $item['order_return_status'] == 'DOING') {
  4211. $systemStatus = '退款中';
  4212. } elseif ($item['order_is_complete'] != 'R' && !empty($item['order_return_status']) && $item['order_return_status'] == 'DONE') {
  4213. $systemStatus = '退款完成';
  4214. } elseif ($item['order_is_complete'] != 'R' && !empty($item['order_return_status']) && $item['order_return_status'] == 'DISAGREE') {
  4215. $systemStatus = '不同意退款';
  4216. }
  4217. $payDetails = PayDetail::where('join_pay_order_id', $item['order_groupby'])
  4218. ->where('pay_status', 'SUCCESS')
  4219. ->where('pay_category', '<>', 'REFUND')
  4220. ->get()
  4221. ->toArray();
  4222. if (count($payDetails) > 1) {
  4223. $payWay = '组合支付';
  4224. } elseif (count($payDetails) == 1) {
  4225. $payWayEn = OrderService::getPayWayByPrepayId($payDetails[0]['pay_prepayid']);
  4226. $payWay = '';
  4227. if (!empty($payWayEn)) {
  4228. $payWay = OrderService::$payWay[$payWayEn];
  4229. }
  4230. }
  4231. if (count($payDetails) > 0) {
  4232. $payDetail0 = $payDetails[0];
  4233. $payTimes = $payDetail0['pay_paytimes'];
  4234. }
  4235. if (!empty($item['member']) && $item['member']['member_mobile'] == '0000') {
  4236. $memberName = '散客';
  4237. } else {
  4238. $memberName = !empty($item['cert']) ? $item['cert']['member_cert_name'] : (!empty($item['member']) ? (substr($item['member']['member_mobile'], -4) . '用户' . '-') : '');
  4239. if (!empty($item['member'])) {
  4240. $memberName .= $item['member']['member_mobile'];
  4241. }
  4242. }
  4243. $data[$key] = [
  4244. 'goods_classify' => !empty($goodsClassify) && isset(self::$goodsClassify[$goodsClassify]) ? self::$goodsClassify[$goodsClassify] : '其他订单',
  4245. 'order_id' => $item['order_id'],
  4246. 'member' => $memberName,
  4247. 'goods_name' => $goodsName,
  4248. 'nbr' => !empty($item['sheet']) ? intval($item['sheet']['order_sheet_num']) : '--',
  4249. 'order_amount_total' => $item['order_amount_total'],
  4250. 'order_amount_pay' => $item['order_amount_pay'],
  4251. 'order_status_system' => !empty($systemStatus) ? $systemStatus : self::$systemStatus[$item['order_status_system']],
  4252. 'order_status_payment' => self::$paymentStatus[$item['order_status_payment']],
  4253. 'pay_way' => $item['order_status_payment'] == 'SUCCESS' ? ($payWay ?? '') : '',
  4254. 'pay_times' => $item['order_status_payment'] == 'SUCCESS' || $item['order_status_payment'] == 'FREE' ? ($payTimes ?? '') : '',
  4255. 'order_addtimes' => date('Y-m-d H:i:s', strtotime($item['order_addtimes'])),
  4256. ];
  4257. }
  4258. return $data;
  4259. }
  4260. /**
  4261. * @Desc 查询订单状态
  4262. * @Author Gorden
  4263. * @Date 2024/8/19 11:55
  4264. *
  4265. * @param Request $request
  4266. * @return Response|void
  4267. */
  4268. public function getOrderPayStatus(Request $request)
  4269. {
  4270. $orderId = $request->get('order_id', '');
  4271. if (!$orderId) {
  4272. return json_fail('订单不存在');
  4273. }
  4274. $order = Order::where('order_id', $orderId)->first();
  4275. if (!$order) {
  4276. return json_fail('订单不存在');
  4277. }
  4278. $discountJson = [];
  4279. if (!empty($order->order_discount_json)) {
  4280. $discountJson = json_decode($order->order_discount_json, true);
  4281. }
  4282. if ($order->order_status_payment == 'SUCCESS') {
  4283. return json_success('success');
  4284. }
  4285. $payDetailType = PayDetail::where('join_pay_order_id', $order->order_groupby)->pluck('pay_prepayid')->toArray();
  4286. try {
  4287. Db::beginTransaction();
  4288. if (in_array('WXPAY', $payDetailType)) {
  4289. $result = Pay::wechat(config('payment.wxpay'))->find($order->order_groupby, 'pos');
  4290. $result = json_decode(json_encode($result), true);
  4291. if (!empty($result['return_code']) && $result['return_code'] == 'SUCCESS' && !empty($result['result_code']) && $result['result_code'] == 'SUCCESS' && !empty($result['trade_state']) && $result['trade_state'] == 'SUCCESS') {
  4292. $order->order_status_payment = 'SUCCESS';
  4293. if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'DISHES', 'MEALS', 'VIP'])) {
  4294. $order->order_is_complete = 'Y';
  4295. $order->order_status_system = 'DONE';
  4296. } else {
  4297. $order->order_status_system = 'SENDING';
  4298. }
  4299. $order->save();
  4300. // Sheet
  4301. OrderSheet::where('join_sheet_order_id', $orderId)->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
  4302. // 支付记录
  4303. PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_prepayid', 'WXPAY')->update(['pay_status' => 'SUCCESS']);
  4304. // 优惠券标记使用
  4305. $this->changeOrderCouponStatus($discountJson, 'USED');
  4306. Db::commit();
  4307. return json_success('success');
  4308. }
  4309. } else if (in_array('ALIPAY', $payDetailType)) {
  4310. $result = Pay::alipay(config('payment.alipay'))->find($order->order_groupby);
  4311. $result = json_decode(json_encode($result), true);
  4312. if (!empty($result['code']) && $result['code'] == '10000' && !empty($result['trade_status']) && $result['trade_status'] == 'TRADE_SUCCESS') {
  4313. if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'DISHES', 'MEALS', 'VIP'])) {
  4314. $order->order_is_complete = 'Y';
  4315. $order->order_status_system = 'DONE';
  4316. $order->order_status_payment = 'SUCCESS';
  4317. } else {
  4318. $order->order_status_system = 'SENDING';
  4319. }
  4320. $order->save();
  4321. // Sheet
  4322. OrderSheet::where('join_sheet_order_id', $orderId)->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
  4323. // 支付记录
  4324. PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_prepayid', 'ALIPAY')->update(['pay_status' => 'SUCCESS']);
  4325. // 优惠券标记使用
  4326. $this->changeOrderCouponStatus($discountJson, 'USED');
  4327. Db::commit();
  4328. return json_success('success');
  4329. }
  4330. }
  4331. Db::rollBack();
  4332. return json_fail('没有查询到记录');
  4333. } catch (\Exception $e) {
  4334. Db::rollBack();
  4335. return json_fail('查询失败');
  4336. }
  4337. }
  4338. /**
  4339. * @Desc 修改订单状态-挂账
  4340. * @Author Gorden
  4341. * @Date 2024/8/20 15:58
  4342. *
  4343. * @param Request $request
  4344. * @return Response
  4345. */
  4346. public function updateStatus(Request $request)
  4347. {
  4348. $orderId = $request->post('order_id', '');
  4349. $orderStatusPayment = $request->post('order_status_payment', '');
  4350. $freeRemark = $request->post('free_remark', '');
  4351. $order = Order::where('order_id', $orderId)
  4352. ->select('order_id', 'order_groupby', 'order_status_payment', 'order_config_json', 'order_amount_total', 'order_discount_json', 'order_extend_json')
  4353. ->first();
  4354. Db::beginTransaction();
  4355. try {
  4356. if ($orderStatusPayment == 'AWAITING' && $order->order_status_payment != 'PENDING') {
  4357. throw new BusinessException("当前订单不允许挂账");
  4358. } else if ($orderStatusPayment == 'FREE' && $order->order_status_payment != 'PENDING') {
  4359. throw new BusinessException("当前订单不允许免单");
  4360. }
  4361. // 挂账,释放餐桌
  4362. if (in_array($orderStatusPayment, ['AWAITING', 'FREE'])) {
  4363. $order->order_status_payment = $orderStatusPayment;
  4364. // 如果有餐桌,释放
  4365. if (!empty($order->order_config_json)) {
  4366. $orderConfigJson = json_decode($order->order_config_json, true);
  4367. if (!empty($orderConfigJson['tableid'])) {
  4368. SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
  4369. }
  4370. }
  4371. }
  4372. if ($orderStatusPayment == 'FREE') {
  4373. $orderDiscountJson = [];
  4374. if (!empty($order->order_discount_json)) {
  4375. $orderDiscountJson = json_decode($order->order_discount_json, true);
  4376. }
  4377. $orderDiscountJson[date('Y-m-d H:i:s')] = [
  4378. 'coupon_id' => null,
  4379. 'coupon_value' => $order->order_amount_total,
  4380. 'coupon_classify' => '免单',
  4381. 'coupon_detail_id' => ['免单'],
  4382. 'coupon_classify_en' => ['free']
  4383. ];
  4384. $orderExtendJson = [];
  4385. if (!empty($order->order_extend_json)) {
  4386. $orderExtendJson = json_decode($order->order_extend_json, true);
  4387. }
  4388. $orderExtendJson['free_remark'] = $freeRemark;
  4389. $order->order_discount_json = json_encode($orderDiscountJson, JSON_UNESCAPED_UNICODE);
  4390. $order->order_extend_json = json_encode($orderExtendJson, JSON_UNESCAPED_UNICODE);
  4391. $order->order_is_complete = 'Y';
  4392. $order->order_status_system = 'DONE';
  4393. $order->order_amount_pay = 0;
  4394. // sheet表
  4395. OrderSheet::where('join_sheet_order_id', $orderId)->update(['order_sheet_status' => 'DONE']);
  4396. // payDetail 表
  4397. PayDetail::where('join_pay_order_id', $order->order_groupby)
  4398. ->update([
  4399. 'pay_status' => 'SUCCESS',
  4400. 'pay_amount' => 0,
  4401. 'pay_prepayid' => 'MONEY',
  4402. 'pay_paytimes' => date('Y-m-d H:i:s')
  4403. ]);
  4404. }
  4405. $order->save();
  4406. Db::commit();
  4407. return json_success('success');
  4408. } catch (BusinessException $e) {
  4409. Db::rollBack();
  4410. return json_fail($e->getMessage());
  4411. } catch (\Exception $e) {
  4412. Db::rollBack();
  4413. return json_fail('修改订单状态失败');
  4414. }
  4415. }
  4416. public function useCoupon(Request $request)
  4417. {
  4418. $goods = $request->post('goods', []);
  4419. $coupon = $request->post('coupon', []);
  4420. $payAmount = $request->post('pay_amount', 0);
  4421. $memberId = $request->post('member_id', '');
  4422. $settlementNow = $request->post('settlement_now', 'N');
  4423. if (empty($goods) || empty($coupon) || empty($memberId)) {
  4424. return json_fail("参数异常");
  4425. }
  4426. foreach ($coupon as $item) {
  4427. if (!in_array(substr($item, 0, 2), ['CU', 'CO'])) {
  4428. return json_fail("参数异常");
  4429. }
  4430. }
  4431. $amountBalance = [
  4432. 'pay_amount' => $payAmount,
  4433. 'welfare_balance' => 0,
  4434. 'cut_balance' => 0,
  4435. ];
  4436. foreach ($goods as $good) {
  4437. $result = OrderService::chooseCoupon($settlementNow, $memberId, $goods, $good, $coupon, $amountBalance);
  4438. $amountBalance = [
  4439. 'pay_amount' => $result['pay_amount'],
  4440. 'welfare_balance' => $result['welfare_balance'],
  4441. 'cut_balance' => $result['cut_balance'],
  4442. ];
  4443. }
  4444. Redis::del("ORDER:USE:COUPON:" . $memberId);
  4445. return json_success("success", ['pay_amount' => $amountBalance['pay_amount']]);
  4446. }
  4447. /**
  4448. * @Desc 订单的核销记录
  4449. * @Author Gorden
  4450. * @Date 2024/9/13 14:28
  4451. *
  4452. * @param Request $request
  4453. * @return Response
  4454. */
  4455. public function writeOffList(Request $request)
  4456. {
  4457. $orderId = $request->get('order_id');
  4458. $page = $request->get('page', 1);
  4459. $pageSize = $request->get('pageSize', 20);
  4460. if (!$orderId) {
  4461. return json_fail("参数异常");
  4462. }
  4463. $appointments = Appointment::with([
  4464. 'member' => function ($query) {
  4465. $query->select('member_id', 'member_mobile');
  4466. },
  4467. 'memberInfo',
  4468. 'cert',
  4469. 'goods' => function ($query) {
  4470. $query->select('goods_id', 'goods_name');
  4471. }
  4472. ])->where('join_appointment_order_id', $orderId)
  4473. ->where('appointment_status', 'DONE')
  4474. ->select('join_appointment_member_id', 'join_appointment_goods_id', 'appointment_done_datetime', 'appointment_done_json');
  4475. $total = $appointments->count();
  4476. $rows = $appointments->forPage($page, $pageSize)
  4477. ->orderBy('appointment_done_datetime', 'DESC')
  4478. ->get();
  4479. foreach ($rows as &$item) {
  4480. $memberMobile = '';
  4481. if (!empty($item['member']) && !empty($item['member']['member_mobile'])) {
  4482. $memberMobile = $item['member']['member_mobile'];
  4483. }
  4484. $memberNickname = '';
  4485. if (!empty($item['member_info']) && !empty($item['member_info']['member_info_nickname'])) {
  4486. $memberNickname = $item['member_info']['member_info_nickname'];
  4487. }
  4488. $memberName = '';
  4489. if (!empty($item['cert']) && !empty($item['cert']['member_cert_name'])) {
  4490. $memberName = $item['cert']['member_cert_name'];
  4491. }
  4492. unset($item['member'], $item['member_info'], $item['cert']);
  4493. $item['member_name'] = MemberService::getMemberName($memberMobile, $memberName, $memberNickname);
  4494. if (!empty($item['appointment_done_json'])) {
  4495. $doneJson = json_decode($item['appointment_done_json'], true);
  4496. if (isset($doneJson['charge']) && !empty($doneJson['charge']['charge_user_id'])) {
  4497. $item['username'] = SysUser::where('user_id', $doneJson['charge']['charge_user_id'])->value('user_name');
  4498. }
  4499. if (isset($doneJson['charge']) && !empty($doneJson['charge']['charge_premises'])) {
  4500. $item['premise'] = $doneJson['charge']['charge_premises'];
  4501. }
  4502. $item['nbr'] = 1;
  4503. }
  4504. }
  4505. return json_success('', compact('rows', 'page', 'pageSize', 'total'));
  4506. }
  4507. public static $goodsClassify = [
  4508. // goodsClassify: {GOODS:"健康产品订单",SERVICE:"服务订单",DEVICE:"设备订单",SPECIAL:"专题业务订单",PACKAGE:"套餐订单",RECHARGE:"充值订单",OTHER:"其他订单"},
  4509. 'GOODS' => "产品订单",
  4510. 'SERVICE' => "服务订单",
  4511. 'CHNMED' => '服务订单',
  4512. 'CHNNCD' => '服务订单',
  4513. 'DEVICE' => '设备订单',
  4514. 'SPECIAL' => '专题业务订单',
  4515. 'PACKAGE' => '套包订单',
  4516. 'RECHARGE' => '充值订单',
  4517. 'OTHER' => '其他订单',
  4518. 'DISHES' => '餐饮订单',
  4519. 'MEALS' => '餐饮订单',
  4520. 'VIP' => '康养城订单'
  4521. ];
  4522. // systemStatus: {BEING:"待生效",PAYING:"待支付",PENDING:"待确认",WAITING:"待受理",SENDING:"待发货",RECVING:"待收货",SIGNED:"已签收",CONFIRM:"确认收货"},
  4523. // paymentStatus: {PENDING:"待支付",CANCEL:"取消支付",SUCCESS:"支付成功"},
  4524. public static $systemStatus = [
  4525. 'BEING' => '待生效',
  4526. 'PAYING' => "待支付",
  4527. 'PENDING' => "待确认",
  4528. 'WAITING' => "待使用",
  4529. 'SENDING' => "待发货",
  4530. 'RECVING' => "待收货",
  4531. 'SIGNED' => "已签收",
  4532. 'CONFIRM' => "确认收货",
  4533. 'DONE' => '已完成',
  4534. 'CANCEL' => '已取消'
  4535. ];
  4536. public static $paymentStatus = [
  4537. 'WAITING' => "待支付",
  4538. 'PENDING' => "待支付",
  4539. 'CANCEL' => "取消支付",
  4540. 'SUCCESS' => "支付成功",
  4541. 'AWAITING' => "挂账",
  4542. 'FREE' => "免单"
  4543. ];
  4544. }