1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783478447854786478747884789479047914792479347944795479647974798479948004801480248034804480548064807480848094810481148124813481448154816481748184819482048214822482348244825482648274828482948304831483248334834483548364837483848394840484148424843484448454846484748484849485048514852485348544855485648574858485948604861486248634864486548664867486848694870487148724873487448754876487748784879488048814882488348844885488648874888488948904891489248934894489548964897489848994900490149024903490449054906490749084909491049114912491349144915491649174918491949204921492249234924492549264927492849294930493149324933493449354936493749384939494049414942494349444945494649474948494949504951495249534954495549564957495849594960496149624963496449654966496749684969497049714972497349744975497649774978497949804981498249834984498549864987498849894990499149924993499449954996499749984999500050015002500350045005500650075008500950105011501250135014501550165017501850195020502150225023502450255026502750285029503050315032503350345035503650375038503950405041504250435044504550465047504850495050505150525053505450555056505750585059506050615062506350645065506650675068506950705071507250735074507550765077507850795080508150825083508450855086508750885089509050915092509350945095509650975098509951005101510251035104510551065107510851095110511151125113511451155116511751185119512051215122512351245125512651275128512951305131513251335134513551365137513851395140514151425143514451455146514751485149515051515152515351545155515651575158515951605161516251635164516551665167516851695170517151725173517451755176517751785179518051815182518351845185518651875188518951905191519251935194519551965197519851995200520152025203520452055206520752085209521052115212521352145215521652175218521952205221522252235224522552265227522852295230523152325233523452355236523752385239524052415242524352445245524652475248524952505251525252535254525552565257525852595260526152625263526452655266526752685269527052715272527352745275527652775278527952805281528252835284528552865287528852895290529152925293529452955296529752985299530053015302530353045305530653075308530953105311531253135314531553165317531853195320532153225323532453255326532753285329533053315332533353345335533653375338533953405341534253435344534553465347534853495350535153525353535453555356535753585359536053615362536353645365536653675368536953705371537253735374537553765377537853795380538153825383538453855386538753885389539053915392539353945395539653975398539954005401540254035404540554065407540854095410541154125413541454155416541754185419542054215422542354245425542654275428542954305431543254335434543554365437543854395440544154425443544454455446544754485449545054515452545354545455545654575458545954605461546254635464546554665467546854695470547154725473547454755476547754785479548054815482548354845485548654875488548954905491549254935494549554965497549854995500550155025503550455055506550755085509551055115512551355145515551655175518551955205521552255235524552555265527552855295530553155325533553455355536553755385539554055415542554355445545554655475548554955505551555255535554555555565557555855595560556155625563556455655566556755685569557055715572557355745575557655775578557955805581558255835584558555865587558855895590559155925593559455955596559755985599560056015602560356045605560656075608560956105611561256135614561556165617561856195620 |
- <?php
- namespace app\admin\controller\order;
- use app\admin\service\coupon\CouponDetailService;
- use app\admin\service\coupon\CouponService;
- use app\admin\service\member\MemberService;
- use app\admin\service\order\OrderService;
- use app\admin\service\order\OrderSheetService;
- use app\admin\service\order\PayDetailService;
- use app\admin\validate\coupon\CouponValidate;
- use app\admin\validate\device\DeviceValidate;
- use app\admin\validate\order\OrderExpressValidate;
- use app\admin\validate\order\OrderValidate;
- use app\common\payment\AppUtil;
- use app\common\payment\Tlpay;
- use app\controller\Curd;
- use app\model\Appointment;
- use app\model\ClientConfig;
- use app\model\Coupon;
- use app\model\CouponDetail;
- use app\model\Device;
- use app\model\Goods;
- use app\model\GoodsComponent;
- use app\model\GoodsRunning;
- use app\model\GoodsSku;
- use app\model\Member;
- use app\model\MemberAccount;
- use app\model\MemberBenefit;
- use app\model\MemberRole;
- use app\model\Order;
- use app\model\OrderExpress;
- use app\model\OrderProcess;
- use app\model\OrderReturn;
- use app\model\OrderSheet;
- use app\model\PayDetail;
- use app\model\Premises;
- use app\model\Supplier;
- use app\model\SysDept;
- use app\model\SysSerial;
- use app\model\SysUser;
- use Payment\Common\PayException;
- use support\Db;
- use support\exception\BusinessException;
- use support\Log;
- use support\Redis;
- use support\Request;
- use support\Response;
- use Tinywan\Jwt\JwtToken;
- use Webman\Event\Event;
- use Yansongda\Pay\Pay;
- class WholeController extends Curd
- {
- public function __construct()
- {
- $this->model = new Order();
- $this->validate = true;
- $this->validateClass = new OrderValidate();
- }
- /**
- * @Desc 列表
- * @Author Gorden
- * @Date 2024/3/28 15:01
- *
- * @param Request $request
- * @return Response
- * @throws \support\exception\BusinessException
- */
- public function select(Request $request): Response
- {
- $timeType = $request->get('time_type', 'add');
- [$where, $format, $limit, $field, $order] = $this->selectInput($request);
- if (!empty($where['order_addtimes']) && $timeType == 'add') {
- $where['order_addtimes'][0] = strtotime($where['order_addtimes'][0]);
- $where['order_addtimes'][1] = strtotime($where['order_addtimes'][1]);
- }
- if ($request->get('goods_classify') && $request->get('goods_classify') == 'SERVICE') {
- $where['order_classify'] = ['in', 'SERVICE,CHNMED,CHNNCD'];
- } else if ($request->get('goods_classify')) {
- $where['order_classify'] = $request->get('goods_classify');
- }
- $order = $request->get('order', 'desc');
- $type = $request->get('type', '');
- if ($type == 'todayOrder' && empty($where['order_addtimes'])) {
- $where['order_addtimes'][0] = strtotime(date('Y-m-d') . ' 00:00:00');
- $where['order_addtimes'][1] = strtotime(date('Y-m-d') . ' 23:59:59');
- } else if ($type == 'todayOrderAmount') {
- $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
- $groupIds = PayDetail::whereRaw('CAST(UNIX_TIMESTAMP(pay_paytimes) as SIGNED) > ? ', [$todayTimeUnix])
- ->where('join_pay_order_id', '<>', '')
- ->whereIn('pay_category', ['GOODS', 'SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE', 'MEALS'])
- ->where('pay_status', 'SUCCESS')
- ->pluck('join_pay_order_id')
- ->toArray();
- $where['order_groupby'] = ['in', $groupIds];
- } else if ($type == 'todaySalesOrderAmount') {
- $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
- $groupIds = PayDetail::whereRaw('CAST(UNIX_TIMESTAMP(pay_paytimes) as SIGNED) > ? ', [$todayTimeUnix])
- ->where('join_pay_order_id', '<>', '')
- ->whereIn('pay_prepayid', ['WXPAY', 'ALIPAY', 'OFFLINE_WXPAY', 'OFFLINE_ALIPAY', 'MONEY'])
- ->where('pay_status', 'SUCCESS')
- ->pluck('join_pay_order_id')
- ->toArray();
- $where['order_groupby'] = ['in', $groupIds];
- } else if ($type == 'todayRechargeOrder') {
- $where['order_classify'] = ['in', ['RECHARGE', 'COMBINE', 'PARTNER', 'REFERRER', 'VIP']];
- $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
- $where['order_addtimes'] = ['>', $todayTimeUnix];
- }
- $orderIds = [];
- if (!empty($where['order_id'])) {
- $orderIds = Order::where('order_id', 'like', '%' . $where['order_id'] . '%')->pluck('order_id')->toArray();
- }
- $field = $field ?? 'order_addtimes';
- if (!empty($where['order_status_system']) && in_array($where['order_status_system'], ['PENDING', 'WAITING', 'SENDING', 'RECVING', 'SIGNED', 'CONFIRM'])) {
- if ($where['order_status_system'] == 'SENDING') {
- $where['order_express.order_express_type'] = '配送';
- }
- $where['order_is_complete'] = 'N';
- $where['order_category'] = isset($where['order_category']) ? $where['order_category'] : ['in', 'SYSTEM,NORMAL,DISHES'];
- }
- if (!empty($where['order_status_system']) && $where['order_status_system'] == 'RETURN') {
- unset($where['order_status_system']);
- unset($where['order_is_complete']);
- $where['order_category'] = 'RETURN';
- }
- if ($request->get('return')) {
- $where['order_return.order_return_status'] = $request->get('return');
- }
- $goodsIds = [];
- if ($request->get('goods_classify') || $request->get('goods_name')) {
- // $where['order_id'] = '';
- $goodsClassify = $request->get('goods_classify', '');
- if ($goodsClassify == 'DISHES') {
- $goodsClassify = 'MEALS';
- }
- $goodsName = $request->get('goods_name', '');
- if (!empty($goodsName) && empty($goodsClassify)) {
- $goodsIds = Goods::where('goods_name', 'like', '%' . $request->get('goods_name') . '%')->pluck('goods_id')->toArray();
- } else if (!empty($goodsClassify)) {
- if ($goodsClassify == 'SERVICE') {
- $goodsModel = Goods::whereIn('goods_classify', ['SERVICE', 'CHNMED', 'CHNNCD']);
- } else {
- $goodsModel = Goods::where('goods_classify', $goodsClassify);
- }
- if (!empty($goodsName)) {
- $goodsModel->where('goods_name', 'like', '%' . $goodsName . '%');
- }
- $goodsIds = $goodsModel->pluck('goods_id')->toArray();
- }
- }
- if ($request->get('goods_classify') || $request->get('goods_name')) {
- $orderGoodsIds = OrderSheet::whereIn('join_sheet_goods_id', $goodsIds)->pluck('join_sheet_order_id')->toArray();
- if (!empty($where['order_id'])) {
- $orderIds = array_intersect($orderIds, $orderGoodsIds);
- // $where['order_id'] = ['in', implode(',', $orderIds)];
- } else {
- $orderIds = $orderGoodsIds;
- // $where['order_id'] = ['in', implode(',', $orderGoodsIds)];
- }
- }
- // 付款时间
- $payOrderIds = [];
- if ($timeType == 'pay' && !empty($where['order_addtimes'])) {
- $payTimeStart = strtotime($where['order_addtimes'][0]);
- $payTimeEnd = strtotime($where['order_addtimes'][1]);
- unset($where['order_addtimes']);
- $payOrderIds = PayDetailService::getPayOrderId($payTimeStart, $payTimeEnd);
- }
- if ((!empty($orderId) || !empty($goodsName)) && $timeType == 'pay') {
- $orderIds = array_intersect($orderIds, $payOrderIds);
- $where['order_id'] = ['in', implode(',', $orderIds)];
- } elseif (!empty($orderId) || !empty($goodsName)) {
- $where['order_id'] = ['in', implode(',', $orderIds)];
- } elseif ($timeType == 'pay') {
- $where['order_id'] = ['in', implode(',', $payOrderIds)];
- }
- // 自提订单
- if (!empty($where['order_status_system']) && $where['order_status_system'] == 'PICKUP') {
- $where['order_is_complete'] = 'N';
- $where['order_status_system'] = 'SENDING';
- $where['order_express.order_express_type'] = '自提';
- }
- $query = $this->doSelect($where, $field, $order);
- return $this->doFormat($query, $format, $limit);
- }
- protected function doSelect(array $where, string $field = null, string $order = 'desc')
- {
- $model = $this->model->with([
- 'sheets' => function ($query) {
- $query->select('join_sheet_order_id', 'order_sheet_id', 'join_sheet_goods_id', 'order_sheet_num', 'order_sheet_price');
- },
- 'member' => function ($query) {
- $query->select('member_id', 'member_mobile');
- },
- 'cert' => function ($query) {
- $query->select('join_cert_member_id', 'member_cert_name');
- },
- // 'return' => function ($query) use ($where){
- // if (isset($where['return'])){
- // dump($where['return']);
- // $query = $query->where('order_return_status',$where['return']);
- // }
- // $query->select('orders_return_id', 'join_return_order_id', 'order_return_status');
- // },
- // 'express' => function ($query) {
- // $query->select('join_express_order_id', 'order_express_type');
- // }
- ])->leftJoin('order_return', 'order_return.join_return_order_id', '=', 'order.order_id')
- ->leftJoin('order_express', 'order_express.join_express_order_id', '=', 'order.order_id');
- // ->leftJoin('pay_detail', 'pay_detail.join_pay_order_id', '=', 'order.order_groupby');
- // ->leftJoin('order_sheet','join_sheet_order_id','=','order.order_id');
- foreach ($where as $column => $value) {
- if (is_array($value)) {
- if ($value[0] === 'like' || $value[0] === 'not like') {
- $model = $model->where($column, $value[0], "%$value[1]%");
- } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
- $model = $model->where($column, $value[0], $value[1]);
- } elseif ($value[0] == 'in' && !empty($value[1])) {
- $valArr = $value[1];
- if (is_string($value[1])) {
- $valArr = explode(",", trim($value[1]));
- }
- $model = $model->whereIn($column, $valArr);
- } elseif ($value[0] == 'not in' && !empty($value[1])) {
- $valArr = $value[1];
- if (is_string($value[1])) {
- $valArr = explode(",", trim($value[1]));
- }
- $model = $model->whereNotIn($column, $valArr);
- } elseif ($value[0] == 'null') {
- $model = $model->whereNull($column);
- } elseif ($value[0] == 'not null') {
- $model = $model->whereNotNull($column);
- } elseif ($value[0] !== '' || $value[1] !== '') {
- $model = $model->whereBetween($column, $value);
- }
- } else {
- $model = $model->where($column, $value);
- }
- }
- if ($field) {
- $model = $model->orderBy($field, $order);
- }
- $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_refund_json', 'order_return.order_return_remark');
- return $model;
- }
- public function afterQuery($items)
- {
- foreach ($items as &$item) {
- $sheetDeng = '';
- $item['sheet'] = $item['sheets'][0] ?? [];
- if (!empty($item['sheet'])) {
- $goods = Goods::where('goods_id', $item['sheet']['join_sheet_goods_id'])->first();
- if (count($item['sheets']) > 1 && !empty($goods) && $goods->goods_classify == 'MEALS') {
- $sheetDeng = ' 等餐品';
- }
- $item['sheet']['goods_name'] = ($goods && $goods->goods_name) ? $goods->goods_name . $sheetDeng : '';
- $item['sheet']['goods_classify'] = $goods->goods_classify ?? '';
- $item['sheet']['order_sheet_num'] = intval($item['sheet']['order_sheet_num']);
- }
- unset($item['sheets']);
- $item['order_return_amount'] = 0;
- if (isset($item['orders_return_id'])) {
- $item['return'] = [
- 'orders_return_id' => $item['orders_return_id'],
- 'join_return_order_id' => $item['join_return_order_id'],
- 'order_return_status' => $item['order_return_status'],
- 'order_return_apply_json' => $item['order_return_apply_json'],
- 'order_return_remark' => $item['order_return_remark'],
- ];
- if (!empty($item['order_return_refund_json'])) {
- $refundJson = json_decode($item['order_return_refund_json'], true);
- if (isset($refundJson['amount'])) {
- $item['order_return_amount'] = $refundJson['amount'];
- }
- }
- }
- if (isset($item['join_express_order_id'])) {
- $item['express'] = [
- 'join_express_order_id' => $item['join_express_order_id'],
- 'order_express_type' => $item['order_express_type']
- ];
- unset($item['join_express_order_id'], $item['order_express_type']);
- }
- $item['payDetail'] = PayDetailService::getPayWay($item['order_groupby'], $item['order_id']);
- }
- return $items;
- }
- /**
- * @Desc 订单商品详情
- * @Author Gorden
- * @Date 2024/3/29 8:50
- *
- * @param Request $request
- * @return Response
- */
- public function sheet(Request $request)
- {
- try {
- $orderId = $request->get('order_id');
- $orderSheet = OrderSheet::with([
- 'member' => function ($query) {
- $query->select('member_id', 'member_mobile', 'member_is_owner', 'join_member_role_id', 'member_is_vip', 'member_is_partner', 'member_is_referrer');
- },
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_cover', 'goods_market_price', 'goods_sales_price', 'goods_classify', 'goods_if_express');
- },
- 'memberInfo',
- 'cert',
- 'sku' => function ($query) {
- $query->where('goods_sku_status', 'ON')
- ->select('goods_sku_id', 'join_sku_goods_id', 'goods_sku_specs_json', 'goods_sku_sales_price');
- },
- 'skus',
- 'refund' => function ($query) {
- $query->select('join_return_order_id', 'order_return_status');
- }
- ])->where('join_sheet_order_id', $orderId)
- ->orderBy('order_sheet_id', 'DESC')
- ->get()
- ->toArray();
- $order = Order::where('order_id', $orderId)->first();
- $express = OrderExpress::where('join_express_order_id', $orderId)->first();
- $premises = '';
- if ($express && $express->order_express_type == '自提') {
- $premises = $express->order_express_company;
- }
- $sheetAmount = 0;
- $coupons = [];
- foreach ($orderSheet as &$item) {
- $sheetAmount += $item['order_sheet_amount'];
- $item['goods']['goods_cover'] = getenv('STORAGE_DOMAIN') . $item['goods']['goods_cover'];
- if (!empty($item['goods']) && $item['goods']['goods_classify'] == 'PACKAGE') {
- $components = GoodsComponent::with('goods')
- ->where('join_component_master_goods_id', $item['goods']['goods_id'])
- ->select('join_component_master_goods_id', 'join_component_goods_id', 'goods_component_price',
- 'goods_component_price', 'goods_component_json')
- ->get()
- ->toArray();
- $goodsArr = [];
- foreach ($components as $component) {
- $configJson = !empty($component['goods_component_json']) ? json_decode($component['goods_component_json'], true) : [];
- if (!empty($component['goods'])) {
- $supplierName = Supplier::where('supplier_id', $component['goods']['join_goods_supplier_id'])->value('supplier_name');
- $benefit = MemberBenefit::where('join_benefit_member_id', $item['join_sheet_member_id'])
- ->where('join_benefit_goods_id', $component['goods']['goods_id'])
- ->where('join_benefit_order_id', $orderId)
- ->first();
- $goodsArr[] = [
- 'goods_name' => $component['goods']['goods_name'],
- 'goods_cover' => getenv('STORAGE_DOMAIN') . $component['goods']['goods_cover'],
- 'supplier_name' => $supplierName,
- 'nbr' => $configJson['nbr'] ?? 0,
- 'used' => !empty($benefit->member_benefit_used_count) ? intval($benefit->member_benefit_used_count) : ''
- ];
- }
- }
- $item['goods']['components'] = $goodsArr;
- $goodsModel = Goods::where('goods_id', $item['goods']['goods_id'])->select('goods_attribute_json')->first();
- if (!empty($goodsModel) && !empty($goodsModel->goods_attribute_json)) {
- $goodsAttributeJson = json_decode($goodsModel->goods_attribute_json, true);
- if (!empty($goodsAttributeJson['coupon'])) {
- foreach ($goodsAttributeJson['coupon'] as $key => $coupon) {
- $couponCount = CouponDetail::where('join_detail_coupon_id', $key)
- ->whereJsonContains('coupon_detail_extend_json->order_id', $item['join_sheet_order_id'])
- ->count();
- $couponUsedCount = CouponDetail::where('join_detail_coupon_id', $key)
- ->where('coupon_detail_status', 'USED')
- ->whereJsonContains('coupon_detail_extend_json->order_id', $item['join_sheet_order_id'])
- ->count();
- $couponUnUsedCount = CouponDetail::where('join_detail_coupon_id', $key)
- ->whereIn('coupon_detail_status', ['ACTIVED', 'WAITING'])
- ->whereJsonContains('coupon_detail_extend_json->order_id', $item['join_sheet_order_id'])
- ->count();
- $coupon['total'] = $couponCount;
- $coupon['used'] = $couponUsedCount;
- $coupon['unused'] = $couponUnUsedCount;
- $coupon['invalid'] = $couponCount - $couponUsedCount - $couponUnUsedCount;
- $coupons[] = $coupon;
- }
- }
- }
- }
- if (!empty($item['sku'])) {
- if (!empty($item['sku']['goods_sku_specs_json'])) {
- $specsJson = json_decode($item['sku']['goods_sku_specs_json'], true);
- $skuName = '';
- foreach ($specsJson as $specsKey => $skuSpecs) {
- if (is_array($skuSpecs)) {
- $skuName = $skuName . ' ' . implode(' ', $skuSpecs) . ';';
- } else {
- $skuName = $skuName . ' ' . $skuSpecs . ';';
- }
- }
- $item['sku']['goods_sku_title'] = rtrim($skuName, ';');
- }
- }
- if (!empty($item['skus'])) {
- foreach ($item['skus'] as $key => $skus) {
- if (!empty($skus['goods_sku_specs_json'])) {
- $item['skus'][$key]['goods_sku_specs_json'] = json_decode($skus['goods_sku_specs_json']);
- $skuName = '';
- foreach ($item['skus'][$key]['goods_sku_specs_json'] as $specsKey => $skuSpecs) {
- $keyStr = ($specsKey == '规格') ? '' : ($specsKey . ':');
- if (is_array($skuSpecs)) {
- $skuName = $skuName . $keyStr . ' ' . implode(' ', $skuSpecs) . '; ';
- } else {
- $skuName = $skuName . $keyStr . ' ' . $skuSpecs . '; ';
- }
- }
- $item['skus'][$key]['sku_name'] = rtrim($skuName, '; ');
- }
- }
- } else {
- $item['skus'] = [];
- }
- if (in_array($item['goods']['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
- $item['appontment'] = [];
- $appontments = Appointment::where('join_appointment_order_id', $orderId)
- ->where('appointment_status', 'DONE')
- ->select('appointment_status', 'appointment_id', 'appointment_done_datetime', 'appointment_done_json', 'appointment_apply_json')
- ->get()
- ->toArray();
- foreach ($appontments as $appontment) {
- $doneJson = [];
- $username = '';
- if (!empty($appontment['appointment_done_json'])) {
- $doneJson = json_decode($appontment['appointment_done_json'], true);
- if (isset($doneJson['charge'])) {
- $username = SysUser::where('user_id', $doneJson['charge']['charge_user_id'])->value('user_name');
- }
- }
- $person = 1;
- if (!empty($appontment->appointment_apply_json)) {
- $applyJson = json_decode($appontment->appointment_apply_json, true);
- if (isset($applyJson['person'])) {
- $person = $applyJson['person'];
- }
- }
- $item['appontment'][] = [
- 'member' => ($item['cert'] ? $item['cert']['member_cert_name'] . '-' : '') . ($item['member'] ? $item['member']['member_mobile'] : ''),
- 'goods_name' => $item['goods']['goods_name'],
- 'premisses' => isset($doneJson['charge']) ? $doneJson['charge']['charge_premises'] : '',
- 'username' => $username,
- 'nbr' => $person,
- 'done_time' => $appontment['appointment_done_datetime'],
- 'appointment_status' => $appontment['appointment_status'],
- ];
- }
- }
- if (!empty($item['order_sheet_extend_json']) && !$express) {
- $extendJson = json_decode($item['order_sheet_extend_json'], true);
- if (isset($extendJson['address_id'])) {
- $address = ClientConfig::where('client_config_id', $extendJson['address_id'])->first();
- if (!empty($address)) {
- $valJson = json_decode($address->client_config_val_json, true);
- $express = [
- 'order_express_address' => $valJson['address'] . ($valJson['numbers'] ?? ''),
- 'order_express_city' => $valJson['city'],
- 'order_express_mobile' => $valJson['mobile'],
- 'order_express_person' => $valJson['person']
- ];
- }
- }
- }
- $item['member']['level'] = '普通会员';
- if (!empty($item['member']['join_member_role_id'])) {
- $item['member']['level'] = MemberRole::where('member_role_id', $item['member']['join_member_role_id'])->value('member_role_name');
- }
- $item['member_info']['member_info_nickname'] = MemberService::getNickname(!empty($item['member_info']) ? $item['member_info']['member_info_nickname'] : '', (!empty($item['member']) ? $item['member']['member_mobile'] : ''));
- $item['member_info']['member_info_headimg'] = MemberService::getAvatarUrl(!empty($item['member_info']) && !empty($item['member_info']['member_info_headimg']) ? $item['member_info']['member_info_headimg'] : '');
- }
- $order->sheet_amount = number_format($sheetAmount, 2);
- $payDetails = PayDetail::where('join_pay_order_id', $order->order_groupby)
- ->where(function ($query) use ($orderId) {
- $query->whereJsonContains('join_pay_object_json->order_id', $orderId)->orWhere('join_pay_object_json', '')->orWhereNull('join_pay_object_json');
- })->where('pay_category', '<>', 'REFUND')
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', '<>', '')
- ->select('pay_id', 'pay_category', 'pay_prepayid', 'pay_paytimes', 'pay_status', 'pay_amount', 'pay_extend_json')
- ->get();
- if (count($payDetails) > 1) {
- $order->pay_category = 'CONSTITUTE';
- }
- $payDetail = !empty($payDetails) && count($payDetails) > 0 ? $payDetails[0] : [];
- if (!empty($payDetail) && !empty($payDetail->pay_extend_json)) {
- $payExtendJson = json_decode($payDetail->pay_extend_json, true);
- $order->cancel_times = $payExtendJson['cancel_times'] ?? '';
- }
- if (!empty($payDetail) && !empty($payDetail->pay_prepayid)) {
- $categoryArray = explode('-', $payDetail->pay_prepayid);
- if (isset($categoryArray[1])) {
- $payDetail->pay_category = $categoryArray[1];
- } else if (in_array($categoryArray[0], ['WXPAY', 'ALIPAY', 'OFFLINE', 'OFFLINE_ALIPAY', 'OFFLINE_WXPAY', 'MONEY'])) {
- $payDetail->pay_category = $categoryArray[0];
- }
- }
- $refund = OrderReturn::where('join_return_order_id', $orderId)
- ->select('order_return_status', 'order_return_apply_datetime', 'order_return_apply_json', 'order_return_accept_datetime', 'order_return_refund_json', 'order_return_extend_json')
- ->first();
- if (!empty($refund->order_return_refund_json)) {
- $returnRefundJson = json_decode($refund->order_return_refund_json, true);
- if (isset($returnRefundJson['user_id'])) {
- $userName = SysUser::where('user_id', $returnRefundJson['user_id'])->value('user_name');
- $returnRefundJson['person'] = $userName;
- unset($returnRefundJson['user_id']);
- }
- $refund->order_return_refund_json = json_encode($returnRefundJson);
- }
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (isset($orderConfigJson['reach'])) {
- $order->reach = $orderConfigJson['reach'];
- }
- if (isset($orderConfigJson['table'])) {
- $order->table = $orderConfigJson['table'];
- }
- if (isset($orderConfigJson['eat'])) {
- $order->eat = $orderConfigJson['eat'];
- }
- if (isset($orderConfigJson['express'])) {
- $order->express = $orderConfigJson['express'];
- }
- if (isset($orderConfigJson['premises'])) {
- $order->premises = $orderConfigJson['premises'];
- }
- if (isset($orderConfigJson['tableid'])) {
- $order->dept_table_id = $orderConfigJson['tableid'];
- }
- }
- if (!empty($order->order_extend_json)) {
- $orderExtendJson = json_decode($order->order_extend_json, true);
- $order->referee = $orderExtendJson['referee'] ?? '';
- if (isset($orderExtendJson['cancel_times'])) {
- $order->cancel_times = $orderExtendJson['cancel_times'];
- }
- if (isset($orderExtendJson['free_remark'])) {
- $order->free_remark = $orderExtendJson['free_remark'];
- }
- if ($order->order_status_payment == 'AWAITING' && !empty($orderExtendJson['awaiting_times'])) {
- $order->awaiting_times = $orderExtendJson['awaiting_times'];
- } elseif ($order->order_status_payment == 'AWAITING' && empty($orderExtendJson['awaiting_times'])) {
- $order->awaiting_times = date('Y-m-d H:i:s', strtotime($order->order_addtimes));
- }
- }
- $discount = ['coupon_name' => '', 'classify' => '', 'value' => 0];
- if (!empty($order->order_discount_json)) {
- $orderDiscountJson = json_decode($order->order_discount_json, true);
- foreach ($orderDiscountJson as $discountItem) {
- if (!empty($discountItem['coupon_id'])) {
- $coupon = Coupon::where('coupon_id', $discountItem['coupon_id'])
- ->select('coupon_name', 'coupon_classify', 'coupon_category', 'coupon_value', 'coupon_minimum_limit')
- ->first();
- if (!$coupon) {
- continue;
- }
- $classify = CouponService::couponClassifyInfo($coupon->coupon_classify, $coupon->coupon_category, $coupon->coupon_value, $coupon->coupon_minimum_limit);
- $discount['coupon_name'] .= $coupon->coupon_classify . ':' . $coupon->coupon_name . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
- }
- if ($discountItem['coupon_classify'] == '退款') {
- continue;
- }
- if (empty($discountItem['coupon_id']) && !empty($discountItem['coupon_classify'])) {
- if (!empty($discountItem['coupon_detail_id'])) {
- $discount['classify'] .= $discountItem['coupon_detail_id'][0] . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
- } else {
- $discount['classify'] .= $discountItem['coupon_classify'] . '(优惠¥' . sprintf("%.2f", $discountItem['coupon_value']) . '), ';
- }
- }
- if (!empty($discountItem['coupon_value'])) {
- $discount['value'] += $discountItem['coupon_value'];
- }
- }
- if (!empty($discount['coupon_name'])) {
- $discount['coupon_name'] = rtrim($discount['coupon_name'], ', ');
- }
- if (!empty($discount['classify'])) {
- $discount['classify'] = rtrim($discount['classify'], ', ');
- }
- }
- $discount['value'] = sprintf("%.2f", $discount['value']);
- $order->discount = $discount;
- $order->premises = $order->premises ?? $premises;
- $data = [
- 'coupons' => $coupons,
- 'order' => $order,
- 'refund' => json_decode(json_encode($refund)),
- 'sheet' => json_decode(json_encode($orderSheet)),
- 'express' => json_decode(json_encode($express)),
- 'payDetail' => json_decode(json_encode($payDetail)),
- 'payDetails' => json_decode(json_encode($payDetails))
- ];
- return json_success('', $data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- }
- }
- public function update(Request $request): Response
- {
- $params = $request->post();
- Db::beginTransaction();
- try {
- // 修改主订单
- $this->updateMain($params);
- // 修改sheet表
- $this->updateSheet($params);
- // 修改物流
- $this->updateExpress($params);
- Db::commit();
- _syslog("订单", "修改订单成功");
- return json_success('修改订单成功');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- _syslog("订单", "修改订单失败");
- return json_fail('修改订单失败');
- }
- }
- /**
- * 修改主订单
- */
- public function updateMain($params)
- {
- try {
- $order = Order::where('order_id', $params['order_id'])->first();
- $orderConfigJson = [];
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- }
- // 优惠
- if (!empty($params['preferential'])) {
- $orderConfigJson['preferential'] = $params['preferential'];
- }
- if (!empty($params['dept_premises_id'])) {
- $premise = SysDept::where('dept_name', $params['dept_premises_id'])->where('dept_category', '营业场所')->first();
- $orderConfigJson['dept'] = $premise->dept_id ?? 0;
- $orderConfigJson['premises'] = $params['dept_premises_id'];
- }
- if (!empty($params['dept_table_id'])) {
- if (!empty($orderConfigJson['tableid']) && $params['dept_table_id'] != $orderConfigJson['tableid']) {
- // 原桌释放
- SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
- }
- // 新桌使用
- SysDept::where('dept_id', $params['dept_table_id'])->update(['dept_status' => 'USING']);
- $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
- $orderConfigJson['table'] = $table->dept_name ?? 0;
- $orderConfigJson['tableid'] = $params['dept_table_id'];
- }
- if (!empty($params['eat'])) {
- $orderConfigJson['eat'] = $params['eat'];
- }
- $data = [
- 'order_amount_pay' => $params['order_amount_pay'],
- 'order_amount_total' => $params['order_amount_total'],
- 'order_config_json' => json_encode($orderConfigJson),
- 'order_remark' => $params['order_remark'] ?? ''
- ];
- Order::where('order_id', $params['order_id'])->update($data);
- } catch (\Exception $e) {
- throw new BusinessException('修改订单失败');
- }
- }
- /**
- * 订单sheet
- */
- public function updateSheet($params)
- {
- try {
- // 判断餐品是否连带着服务或实体
- $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
- if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
- return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
- }
- if (in_array('MEALS', $goodsClassifys)) {
- $params['submit_goods_classify'] = 'MEALS';
- }
- foreach ($params['goodsContentList'] as $sheet) {
- // 先还原库存
- $orderSheet = OrderSheet::where('order_sheet_id', $sheet['order_sheet_id'])->first();
- if (!isset($params['submit_goods_classify']) || $params['submit_goods_classify'] != 'MEALS') {
- $goodsSku = GoodsSku::where('goods_sku_id', $orderSheet->join_sheet_goods_sku_id)->first();
- $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
- $skuStorageJson['storage'] = $skuStorageJson['storage'] + $orderSheet->order_sheet_num;
- $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
- $goodsSku->save();
- }
- $goodsRunning = GoodsRunning::where('join_running_goods_id', $orderSheet->join_sheet_goods_id)->first();
- $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage + $orderSheet->order_sheet_num;
- // $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale - $orderSheet->order_sheet_num;
- $goodsRunning->save();
- $data = [
- 'order_sheet_num' => $sheet['nbr'],
- 'join_sheet_goods_sku_id' => $sheet['sku_id'],
- 'order_sheet_amount' => $sheet['nbr'] * $orderSheet->order_sheet_price,
- 'order_sheet_pay' => $sheet['nbr'] * $orderSheet->order_sheet_price,
- ];
- OrderSheet::where('order_sheet_id', $sheet['order_sheet_id'])->update($data);
- // 减库存
- if (!isset($params['submit_goods_classify']) || $params['submit_goods_classify'] != 'MEALS') {
- $goodsSku = GoodsSku::where('goods_sku_id', $sheet['sku_id'])->first();
- $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
- $skuStorageJson['storage'] = $skuStorageJson['storage'] - $sheet['nbr'];
- if ($skuStorageJson['storage'] < 0) {
- throw new BusinessException('库存不足');
- }
- $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
- $goodsSku->save();
- }
- $goodsRunning = GoodsRunning::where('join_running_goods_id', $orderSheet->join_sheet_goods_id)->first();
- // $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $sheet['nbr'];
- if ($goodsRunning->goods_running_storage < 0) {
- throw new BusinessException('库存不足');
- }
- // $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $sheet['nbr'];
- $goodsRunning->save();
- }
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('修改订单详情失败');
- }
- }
- public function updateExpress($params)
- {
- $express = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
- if (!$express && in_array($params['delivery'], ['PICKUP', 'LOGISTICS'])) {
- throw new BusinessException('物流信息异常');
- }
- if ($params['delivery'] == 'PICKUP') {
- $premises = SysDept::where('dept_category', '营业场所')->where('dept_name', $params['dept_premises_id'])->first();
- $express->order_express_type = '自提';
- $express->order_express_city = str_replace(',', ' ', $premises->dept_city);
- $express->order_express_address = $premises->dept_address;
- $express->order_express_mobile = '';
- $express->order_express_person = '';
- $express->order_express_telephone = $premises->dept_telephone ?? '';
- $express->order_express_company = $params['dept_premises_id'];
- } else if ($params['delivery'] == 'LOGISTICS') {
- $express->order_express_type = '配送';
- $express->order_express_city = $params['order_express_city'] ?? '';
- $express->order_express_address = $params['order_express_address'] ?? '';
- $express->order_express_mobile = $params['order_express_mobile'] ?? '';
- $express->order_express_person = $params['order_express_person'] ?? '';
- $express->order_express_telephone = '';
- $express->order_express_company = '';
- }
- try {
- if (($params['delivery'] == 'PICKUP') || ($params['delivery'] == 'LOGISTICS')) {
- $express->save();
- }
- } catch (\Exception $e) {
- dump($e->getTrace());
- throw new BusinessException('修改配送方式失败');
- }
- }
- public function pay(Request $request)
- {
- $params = $request->post();
- // 余额、福利、储值卡 验证短信
- if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['CASH', 'CARD', 'WELFARE'])) {
- $code = $params['sms_code'];
- if (!$code) {
- return json_fail("验证码错误,请重新输入");
- }
- $member = Member::find($params['join_order_member_id']);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:ORDER_PAY:" . $mobile;
- $redisCode = Redis::get($key);
- if ($redisCode != $code && $code != '123456') {
- return json_fail("验证码错误,请重新输入");
- }
- Redis::del($key);
- }
- // 验证线下付款密码
- if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['OFFLINE', 'MONEY'])) {
- $password = $params['offline_password'];
- if ($password != '666888') {
- return json_fail("密码错误,请重新输入");
- }
- }
- $order = Order::where('order_id', $params['order_id'])->first();
- $oldOrderPaymentStatus = $order->order_status_payment;
- $oldOrderSystemStatus = $order->order_status_system;
- if (!$order) {
- return json_fail('订单异常');
- }
- if ($order->order_status_system != 'PAYING') {
- return json_fail('订单不是可支付状态');
- }
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (isset($orderConfigJson['premises'])) {
- $premises = SysDept::where('dept_name', $orderConfigJson['premises'])->first();
- if (!empty($premises)) {
- $params['submit_premises_id'] = $premises->dept_id;
- }
- }
- }
- $params['orderId'] = $params['order_id'];
- $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $order->order_groupby = $params['orderGroupId'];
- // $params['orderGroupId'] = $order->order_groupby;
- $goods = Goods::where('goods_id', $params['join_sheet_goods_id'])
- ->select('goods_id', 'goods_name', 'goods_classify')
- ->first();
- if (!$goods) {
- return json_fail('产品数据异常');
- }
- $goods = $goods->toArray();
- $params['goods_classify'] = $goods['goods_classify'] ?? '';
- $systemStatus = 'SENDING'; // 待发货
- // 立即结算
- if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
- $order->order_is_complete = 'Y';
- $systemStatus = 'DONE';
- }
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
- $params['order_is_complete'] = 'N';
- $systemStatus = "WAITING";
- }
- // if ($params['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') {
- // $systemStatus = "WAITING";
- // }
- Db::beginTransaction();
- try {
- // 使用优惠券
- $couponUseJson = [];
- if (!empty($order->order_discount_json)) {
- // 释放下单时选的优惠券
- $order->order_discount_json = $this->releaseCoupon(json_decode($order->order_discount_json, true));
- }
- if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
- $couponResult = OrderService::payUseCoupon('pay', 'Y', $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
- if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
- throw new BusinessException("计算优惠后,实付金额错误!");
- }
- // 组装优惠券使用数据,存主表优惠里
- if (!empty($couponResult['use_coupon_json'])) {
- $couponUseJson = $couponResult['use_coupon_json'];
- // if (!empty($order->order_discount_json)) {
- // $orderDiscountJson = json_decode($order->order_discount_json, true);
- // if (!empty($orderDiscountJson)) {
- // $couponUseJson = json_encode(array_merge($orderDiscountJson, json_decode($couponUseJson, true)));
- // }
- // }
- }
- }
- // 存储优惠信息
- $order->order_discount_json = json_encode($this->discountRecord($couponUseJson, $params));
- // 组合支付时,付款码应收金额
- $qrcodePayAmount = 0;
- if ($params['pay_category'] == 'OFFLINE' || $params['pay_category'] == 'MONEY') {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- if ($params['pay_category'] == 'OFFLINE' && !empty($params['pay_category_sub'])) {
- $params['pay_category'] = $params['pay_category_sub'];
- }
- } else if ($params['pay_category'] == 'CASH') { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'CASH')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else if ($params['pay_category'] == 'VIP') { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'VIP')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else if ($params['pay_category'] == 'WELFARE') { // 福利账户
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'WELFARE')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $account->member_account_surplus = floatval($account->member_account_surplus);
- if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $account->member_account_surplus;
- $params['order_amount_pay'] = $account->member_account_surplus;
- }
- if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] <= $account->member_account_surplus)) {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- // 福利账户 300 、 700
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS'])) {
- $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->whereIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES'])
- ->get()
- ->toArray();
- $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
- $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->where('pay_category', 'REFUND')
- ->get()
- ->toArray();
- $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
- $paySum = 0;
- foreach ($payDetailArray as $key => $item) {
- if (isset($refundPayDetailArray[$key])) {
- $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
- continue;
- }
- $paySum = $paySum + $item;
- }
- if ($params['pay_constitute'] == 'N' && 700 - $paySum < $params['order_amount_pay']) {
- throw new BusinessException('超出福利限额');
- } else if ($params['pay_constitute'] == 'Y' && 700 - $paySum < $params['order_amount_pay']) {
- $qrcodePayAmount = $params['order_amount_pay'] - (700 - $paySum);
- $params['order_amount_pay'] = (700 - $paySum);
- }
- } else {
- $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->whereNotIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES', 'REFUND', 'RECHARGE'])
- ->get()
- ->toArray();
- $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
- $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->where('pay_category', 'REFUND')
- ->get()
- ->toArray();
- $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
- $paySum = 0;
- foreach ($payDetailArray as $key => $item) {
- if (isset($refundPayDetailArray[$key])) {
- $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
- continue;
- }
- $paySum = $paySum + $item;
- }
- if ($params['pay_constitute'] == 'N' && 300 - $paySum < $params['order_amount_pay']) {
- throw new BusinessException('超出福利限额');
- } else if ($params['pay_constitute'] == 'Y' && 300 - $paySum < $params['order_amount_pay']) {
- $qrcodePayAmount = $params['order_amount_pay'] - (300 - $paySum);
- $params['order_amount_pay'] = (300 - $paySum);
- }
- }
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- } else if ($params['pay_category'] == 'CARD') { // 储值卡账户
- $cardNbr = $params['card_nbr'];
- if (!$cardNbr) {
- throw new BusinessException('账户异常');
- }
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_nbr', $cardNbr)
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] <= $amount)) {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- }
- if (($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && !empty($params['qrcode_nbr'])) { // 付款码
- // 提交过来的支付分类
- $submitPayCategory = $params['pay_category'];
- // 账户支付的金额
- $accountAmount = $params['order_amount_pay'];
- if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
- // 组合支付,改成需要付款码需要支付的金额
- $params['order_amount_pay'] = $qrcodePayAmount;
- }
- // 去支付
- $result = OrderService::qrcodePay($params);
- $result = json_encode($result);
- $params['pay_json_response'] = $result;
- $result = json_decode($result, true);
- $prefix = substr($params['qrcode_nbr'], 0, 2);
- if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
- $params['pay_category'] = 'WXPAY';
- 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')) {
- $order->order_status_system = $oldOrderSystemStatus;
- $order->order_status_payment = 'PENDING';
- $order->order_is_complete = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
- $params['pay_category'] = 'ALIPAY';
- if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
- $order->order_status_system = $oldOrderSystemStatus;
- $order->order_status_payment = 'PENDING';
- $order->order_is_complete = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else {
- throw new BusinessException('付款码无效');
- }
- // 组合支付,追加加一条支付记录 pay_detail
- if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
- $insertPayDetailData = [
- 'join_pay_member_id' => $params['join_order_member_id'],
- 'join_pay_order_id' => $params['orderGroupId'],
- 'pay_status' => 'SUCCESS',
- 'pay_category' => $params['goods_classify'],
- 'pay_amount' => $params['order_amount_pay'],
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_prepayid' => $params['pay_category'],
- 'pay_json_request' => json_encode($params),
- 'pay_json_response' => $params['pay_json_response'],
- 'join_pay_object_json' => !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]',
- 'pay_addtimes' => time()
- ];
- PayDetail::insert($insertPayDetailData);
- // 组合支付,还原提交的支付分类
- $params['pay_category'] = $submitPayCategory;
- }
- // 账户支付的金额
- $params['order_amount_pay'] = $accountAmount;
- }
- $orderConfigJson = [];
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- }
- $orderConfigJson['preferential'] = $params['preferential'] ?? '';
- if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
- SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
- }
- $order->order_config_json = json_encode($orderConfigJson);
- $order->order_amount_pay = $params['order_amount_pay'] + $qrcodePayAmount;
- // 康养城订单,支付完就结束了
- if ($order->order_status_payment == 'SUCCESS' && $params['goods_classify'] == 'VIP') {
- $order->order_is_complete = 'Y';
- }
- // 主订单
- $order->save();
- // sheet
- OrderService::updateSheet($order, $systemStatus);
- // if ($order->order_status_payment == 'SUCCESS') {
- // OrderSheet::where('join_sheet_order_id', $params['order_id'])->update([
- // 'order_sheet_status' => $systemStatus,
- // ]);
- // }
- // payDetail
- $payData = [
- 'pay_amount' => $params['order_amount_pay']
- ];
- if ($order->order_status_payment == 'SUCCESS') {
- $payData['pay_paytimes'] = date('Y-m-d H:i:s');
- $payData['pay_status'] = 'SUCCESS';
- }
- if ($params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['WXPAY', 'ALIPAY'])) {
- $payData['pay_prepayid'] = $params['pay_category'];
- $payData['pay_json_response'] = $params['pay_json_response'];
- } else if ($params['pay_category'] == 'CASH') {
- $payData['pay_prepayid'] = $params['join_order_member_id'] . '-CASH';
- } else if ($params['pay_category'] == 'WELFARE') {
- $payData['pay_prepayid'] = $params['join_order_member_id'] . '-WELFARE';
- } else if ($params['pay_category'] == 'VIP') {
- $payData['pay_prepayid'] = $params['join_order_member_id'] . '-VIP';
- } else if ($params['pay_category'] == 'CARD') {
- $payData['pay_prepayid'] = $params['card_nbr'];
- } else if ($params['pay_category'] == 'OFFLINE') {
- $payData['pay_prepayid'] = 'OFFLINE';
- } else if ($params['pay_category'] == 'OFFLINE_ALIPAY') {
- $payData['pay_prepayid'] = 'OFFLINE_ALIPAY';
- } else if ($params['pay_category'] == 'OFFLINE_WXPAY') {
- $payData['pay_prepayid'] = 'OFFLINE_WXPAY';
- } else if ($params['pay_category'] == 'MONEY') {
- $payData['pay_prepayid'] = 'MONEY';
- }
- // 如果 是APP 过来的菜订单,可能没有paydetail
- if (!PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_category', '<>', 'WXPAY')->where('pay_category', '<>', 'ALIPAY')->exists()) {
- $payData['join_pay_member_id'] = $params['join_order_member_id'];
- $payData['join_pay_order_id'] = $order->order_groupby;
- $payData['pay_status'] = !empty($payData['pay_status']) && $payData['pay_status'] == 'SUCCESS' ? $payData['pay_status'] : 'WAITING';
- $payData['pay_category'] = $params['goods_classify'] ?? '';
- $payData['pay_paytimes'] = date('Y-m-d H:i:s');
- $payData['pay_json_request'] = json_encode($params); // {"pay-result": "支付成功", "result-datetime": "2024-07-29 18:38:21"}
- $payData['pay_json_response'] = $payData['pay_status'] == 'SUCCESS' ? json_encode([
- 'pay-result' => '支付成功', 'result-datetime' => date('Y-m-d H:i:s')
- ]) : '[]';
- $payData['join_pay_object_json'] = !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]';
- $payData['pay_addtimes'] = time();
- PayDetail::insert($payData);
- } else {
- // 更新非微信支付宝的支付记录
- PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_category', '<>', 'WXPAY')->where('pay_category', '<>', 'ALIPAY')->update($payData);
- }
- $writeOffDate = [];
- $applyData = [];
- // 服务已完成,生成核销数据
- // if ($order->order_status_payment == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
- // $writeOffDate = OrderService::generateWriteOffData($params);
- // $applyData = OrderService::generateAppointmentApplyData($params);
- // }
- // 有预约单,状态已完成
- $appointment = Appointment::where('join_appointment_order_id', $params['order_id'])->first();
- if ($order->order_status_payment == 'SUCCESS' && $appointment) {
- $writeOffDate = OrderService::generateWriteOffData($params);
- $applyData = OrderService::generateAppointmentApplyData($params);
- $appointment->appointment_status = 'DONE';
- $appointment->appointment_done_datetime = date('Y-m-d H:i:s');
- $appointment->appointment_done_json = json_encode($writeOffDate);
- if (empty($appointment->appointment_apply_datetime)) {
- $appointment->appointment_apply_datetime = date('Y-m-d H:i:s');
- }
- if (empty($appointment->appointment_apply_json)) {
- $appointment->appointment_apply_json = json_encode($applyData);
- }
- if (empty($appointment->appointment_datetime)) {
- $appointment->appointment_datetime = date('Y-m-d');
- }
- $appointment->save();
- }
- // // 买的单个服务
- if ($order->order_status_payment == 'SUCCESS' && empty($appointment)) {
- foreach ($params['goodsContentList'] as $goods) {
- $params['join_sheet_goods_id'] = $goods['goods_id'];
- if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'];
- // 预约表
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate, $applyData);
- }
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = $goods['goods_classify'];
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE') { // 一个套餐买多个
- $params['packageId'] = $goods['goods_id'];
- $components = GoodsComponent::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_classify');
- }
- ])->where('join_component_master_goods_id', $params['packageId'])
- ->get()
- ->toArray();
- foreach ($components as $component) {
- $componentJson = json_decode($component['goods_component_json'], true);
- $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate);
- }
- $goods['goods_id'] = $component['join_component_goods_id'];
- $goods['goods_name'] = $component['goods']['goods_name'];
- $goods['goods_classify'] = $component['goods']['goods_classify'];
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = 'SERVICE';
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- }
- }
- }
- }
- // 2.4W 康养城
- if ($params['goods_classify'] == 'VIP' && $order->order_status_payment == 'SUCCESS') {
- $params['member_id'] = $params['join_order_member_id'];
- Event::dispatch('order.kangyangCityVIP.grant', $params);
- }
- Db::commit();
- // 触发事件
- if ($order->order_is_complete == 'Y' && $order->order_status_payment == 'SUCCESS') {
- // 加销售量
- OrderSheetService::addGoodsSales($params['orderId']);
- // 完成订单
- Event::dispatch('order.complete', $params);
- // 上级提成
- Event::dispatch('commission.order', $params);
- // 入收支明细表
- $params['inout_category'] = $oldOrderPaymentStatus == 'AWAITING' ? '挂账订单结算' : '餐饮订单';
- Event::dispatch('statistics.inout.in', $params);
- }
- // 打小票
- if (!empty($premises) && $params['goods_classify'] == 'MEALS') {
- dump("pay 打小票");
- $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
- if (!empty($restaurant->dept_extend_json)) {
- $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
- if (isset($deptExtendJson['printer'])) {
- foreach ($deptExtendJson['printer'] as $key => $item) {
- if (strpos($key, '结算') !== false && $order->order_status_payment == 'SUCCESS') {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['order_id']
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- }
- }
- }
- }
- if ($order->order_status_payment != 'SUCCESS') {
- _syslog("订单", "支付异常,检查是否有轮询");
- // 恢复优惠券到已占用
- if (!is_array($couponUseJson)) {
- $couponUseJson = json_decode($couponUseJson, true);
- }
- $this->changeOrderCouponStatus($couponUseJson, 'WAITING');
- return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
- }
- _syslog("订单", "订单支付成功");
- return json_success('支付成功');
- } catch (BusinessException $e) {
- Db::rollBack();
- _syslog("订单", "订单支付失败:" . $e->getMessage());
- Log::error("订单支付失败:" . $e->getMessage());
- return json_fail("支付失败:" . $e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- _syslog("订单", "订单支付失败");
- Log::error("订单支付失败:" . $e->getMessage());
- return json_fail('支付失败');
- }
- }
- private function discountRecord($orderDiscountJson, $params)
- {
- $json = [];
- if (!empty($orderDiscountJson)) {
- $json = json_decode($orderDiscountJson, true);
- }
- try {
- if (!empty($params['preferential']) && in_array('wipe', $params['preferential'])) {
- if (intval($params['order_amount_total'] / 10) * 10 != $params['order_amount_pay']) {
- throw new BusinessException("抹零后实际支付金额错误");
- }
- $params['order_discount_amount'] = $params['order_amount_total'] - $params['order_amount_pay'];
- $couponClassifyDesc = $couponClassify = '抹零';
- } elseif (!empty($params['preferential']) && in_array('custom', $params['preferential'])) {
- if (sprintf("%.2f", $params['order_amount_total'] - $params['order_discount_amount']) != sprintf("%.2f", $params['order_amount_pay'])) {
- throw new BusinessException("餐厅前台优惠后实际支付金额错误");
- }
- $couponClassifyDesc = $couponClassify = '餐厅前台优惠';
- } else if (!empty($params['preferential']) && intval($params['preferential'][0]) < 100 && intval($params['preferential'][0]) >= 50) {
- if (($params['order_amount_total'] * intval($params['preferential'][0])) / 100 != $params['order_amount_pay']) {
- throw new BusinessException("折扣后实际支付金额错误");
- }
- $couponClassify = '折扣';
- $couponClassifyDesc = intval($params['preferential'][0]) / 10 . '折';
- $params['order_discount_amount'] = $params['order_amount_total'] - $params['order_amount_pay'];
- } else {
- return $json;
- }
- $json[date('Y-m-d H:i:s')] = [
- 'coupon_id' => $params['coupon_id'] ?? null,
- 'coupon_value' => $params['order_discount_amount'] ?? '',
- 'coupon_classify' => $couponClassify,
- 'coupon_detail_id' => [$couponClassifyDesc],
- 'coupon_classify_en' => $params['preferential']
- ];
- return $json;
- } catch (BusinessException $e) {
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException("优惠数据错误");
- }
- }
- /**
- * 组合支付
- */
- public function payConstitute(Request $request)
- {
- $params = $request->post();
- // 余额、福利、储值卡 验证短信
- 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']))) {
- $code = $params['sms_code'];
- if (!$code) {
- return json_fail("验证码错误,请重新输入");
- }
- $member = Member::find($params['join_order_member_id']);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:ORDER_PAY:" . $mobile;
- $redisCode = Redis::get($key);
- if ($redisCode != $code && $code != '123456') {
- return json_fail("验证码错误,请重新输入");
- }
- Redis::del($key);
- }
- // 验证线下付款密码
- if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) {
- $password = $params['offline_password'];
- if ($password != '666888') {
- return json_fail("密码错误,请重新输入");
- }
- }
- $order = Order::where('order_id', $params['order_id'])->first();
- $oldOrderPaymentStatus = $order->order_status_payment;
- if (!$order) {
- return json_fail('订单异常');
- }
- if ($order->order_status_system != 'PAYING') {
- return json_fail('订单不是可支付状态');
- }
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (isset($orderConfigJson['premises'])) {
- $premises = SysDept::where('dept_name', $orderConfigJson['premises'])->first();
- if (!empty($premises)) {
- $params['submit_premises_id'] = $premises->dept_id;
- }
- }
- }
- $params['orderId'] = $params['order_id'];
- $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $order->order_groupby = $params['orderGroupId'];
- // $params['orderGroupId'] = $order->order_groupby;
- $goods = Goods::where('goods_id', $params['join_sheet_goods_id'])
- ->select('goods_id', 'goods_name', 'goods_classify')
- ->first();
- if (!$goods) {
- return json_fail('产品数据异常');
- }
- $goods = $goods->toArray();
- $params['goods_classify'] = $goods['goods_classify'];
- $systemStatus = 'SENDING'; // 待发货
- // 立即结算
- if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
- $order->order_is_complete = 'Y';
- $systemStatus = 'DONE';
- }
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
- $params['order_is_complete'] = 'N';
- $systemStatus = "WAITING";
- }
- $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
- Db::beginTransaction();
- try {// 使用优惠券
- $couponUseJson = [];
- if (!empty($order->order_discount_json)) {
- // 释放下单时选的优惠券
- $order->order_discount_json = $this->releaseCoupon(json_decode($order->order_discount_json, true));
- }
- if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
- $couponResult = OrderService::payUseCoupon('pay', 'Y', $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
- if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
- throw new BusinessException("计算优惠后,实付金额错误!");
- }
- // 组装优惠券使用数据,存主表优惠里
- if (!empty($couponResult['use_coupon_json'])) {
- $couponUseJson = $couponResult['use_coupon_json'];
- // if (!empty($order->order_discount_json)) {
- // $orderDiscountJson = json_decode($order->order_discount_json, true);
- // if (!empty($orderDiscountJson)) {
- // $couponUseJson = json_encode(array_merge($orderDiscountJson, json_decode($couponUseJson, true)));
- // }
- // }
- }
- }
- // 存储优惠信息
- $order->order_discount_json = json_encode($this->discountRecord($couponUseJson, $params));
- $orderAmountPay = $params['order_amount_pay'];
- $constituteList = array_column($params['pay_category_constitute_list'], 'amount', 'category');// 验证金额
- $constituteAmount = 0;
- foreach ($params['pay_category_constitute_list'] as $item) {
- $constituteAmount = $constituteAmount + $item['amount'];
- }
- if ($params['order_amount_pay'] != $constituteAmount) {
- throw new BusinessException('组合支付金额与应付金额不一致');
- }
- if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute'])) { //线下付款
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- $params['pay_category'] = $params['pay_category_sub'] ?? 'OFFLINE';
- // 线下支付金额
- if (isset($constituteList['OFFLINE'])) {
- $params['order_amount_pay'] = $constituteList['OFFLINE'];
- // 生成支付记录
- OrderService::createPayConstituteDetail($params, $payDetail);
- }
- $params['order_amount_pay'] = $orderAmountPay;
- }
- if (!empty($params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) { //现金付款
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- $params['pay_category'] = 'MONEY';
- // 线下支付金额
- if (isset($constituteList['MONEY'])) {
- $params['order_amount_pay'] = $constituteList['MONEY'];
- // 生成支付记录
- OrderService::createPayConstituteDetail($params, $payDetail);
- }
- $params['order_amount_pay'] = $orderAmountPay;
- }
- if (!empty($params['pay_category_constitute']) && in_array('CASH', $params['pay_category_constitute'])) { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'CASH')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- if (isset($constituteList['CASH'])) {
- $params['order_amount_pay'] = $constituteList['CASH'];
- $params['pay_category'] = $params['join_order_member_id'] . '-CASH';
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- // 生成支付记录
- OrderService::createPayConstituteDetail($params, $payDetail);
- $params['order_amount_pay'] = $orderAmountPay;
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- if (!empty($params['pay_category_constitute']) && in_array('CARD', $params['pay_category_constitute'])) { // 储值卡账户
- $cardNbr = $params['card_nbr'];
- if (!$cardNbr) {
- throw new BusinessException('账户异常');
- }
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_nbr', $cardNbr)
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- Db::rollBack();
- return json_fail('账户异常');
- }
- // 储值卡账户支付金额
- if (isset($constituteList['CARD'])) {
- $params['order_amount_pay'] = $constituteList['CARD'];
- $params['pay_category'] = $cardNbr;
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- // 生成支付记录
- OrderService::createPayConstituteDetail($params, $payDetail);
- $params['order_amount_pay'] = $orderAmountPay;
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- if (!empty($params['pay_category_constitute']) && in_array('QRCODE', $params['pay_category_constitute']) && !empty($params['qrcode_nbr'])) { // 付款码
- if (isset($constituteList['QRCODE']) && $constituteList['QRCODE'] > 0) {
- // 付款码支付金额
- $params['order_amount_pay'] = $constituteList['QRCODE'];
- // 调支付
- $result = OrderService::qrcodePay($params);
- $result = json_encode($result);
- $params['pay_json_response'] = $result;
- $result = json_decode($result, true);
- $prefix = substr($params['qrcode_nbr'], 0, 2);
- if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
- $params['pay_category'] = 'WXPAY';
- 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')) {
- $order->order_status_system = 'PAYING';
- $order->order_status_payment = 'PENDING';
- $order->order_is_complete = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
- $params['pay_category'] = 'ALIPAY';
- if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
- $order->order_status_system = 'PAYING';
- $order->order_status_payment = 'PENDING';
- $order->order_is_complete = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $order->order_status_system = $systemStatus;
- $order->order_status_payment = 'SUCCESS';
- }
- } else {
- throw new BusinessException('付款码无效');
- }
- }
- // 生成支付记录
- OrderService::createPayConstituteDetail($params, $payDetail);
- // 账户支付的金额
- $params['order_amount_pay'] = $orderAmountPay;
- }
- $orderConfigJson = [];
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- }
- $orderConfigJson['preferential'] = $params['preferential'] ?? '';
- if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
- SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
- }
- $order->order_config_json = json_encode($orderConfigJson);
- $order->order_amount_pay = $params['order_amount_pay'];
- // 主订单
- $order->save();
- // sheet
- if ($order->order_status_payment == 'SUCCESS') {
- OrderService::updateSheet($order, $systemStatus);
- // OrderSheet::where('join_sheet_order_id', $params['order_id'])->update([
- // 'order_sheet_status' => $systemStatus,
- // ]);
- }
- // 清除paydetail 中的未支付记录
- PayDetail::where('join_pay_order_id', $params['orderGroupId'])->where('pay_status', '<>', 'SUCCESS')->delete();
- $writeOffDate = [];
- $applyData = [];
- // 有预约单,状态已完成
- $appointment = Appointment::where('join_appointment_order_id', $params['order_id'])->first();
- if ($order->order_status_payment == 'SUCCESS' && $appointment) {
- $writeOffDate = OrderService::generateWriteOffData($params);
- $applyData = OrderService::generateAppointmentApplyData($params);
- $appointment->appointment_status = 'DONE';
- $appointment->appointment_done_datetime = date('Y-m-d H:i:s');
- $appointment->appointment_done_json = json_encode($writeOffDate);
- if (empty($appointment->appointment_apply_datetime)) {
- $appointment->appointment_apply_datetime = date('Y-m-d H:i:s');
- }
- if (empty($appointment->appointment_apply_json)) {
- $appointment->appointment_apply_json = json_encode($applyData);
- }
- if (empty($appointment->appointment_datetime)) {
- $appointment->appointment_datetime = date('Y-m-d');
- }
- $appointment->save();
- }
- // 买单个服务
- if ($order->order_status_payment == 'SUCCESS' && empty($appointment)) {
- foreach ($params['goodsContentList'] as $goods) {
- $params['join_sheet_goods_id'] = $goods['goods_id'];
- if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'];
- // 预约表
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate, $applyData);
- }
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = $goods['goods_classify'];
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE') { // 一个套餐买多个
- $params['packageId'] = $goods['goods_id'];
- $components = GoodsComponent::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_classify');
- }
- ])->where('join_component_master_goods_id', $params['packageId'])
- ->get()
- ->toArray();
- foreach ($components as $component) {
- $componentJson = json_decode($component['goods_component_json'], true);
- $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate);
- }
- $goods['goods_id'] = $component['join_component_goods_id'];
- $goods['goods_name'] = $component['goods']['goods_name'];
- $goods['goods_classify'] = $component['goods']['goods_classify'];
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = 'SERVICE';
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- }
- }
- }
- }
- // 2.4W 康养城
- if ($params['goods_classify'] == 'VIP' && $order->order_status_payment == 'SUCCESS') {
- $params['member_id'] = $params['join_order_member_id'];
- Event::dispatch('order.kangyangCityVIP.grant', $params);
- }
- Db::commit();
- // 触发事件
- if ($order->order_is_complete == 'Y' && $order->order_status_payment == 'SUCCESS') {
- // 加销售量
- OrderSheetService::addGoodsSales($params['orderId']);
- // 完成订单
- Event::dispatch('order.complete', $params);
- // 上级提成
- Event::dispatch('commission.order', $params);
- // 入收支明细表
- $params['inout_category'] = $oldOrderPaymentStatus == 'AWAITING' ? '挂账订单结算' : '餐饮订单';
- Event::dispatch('statistics.inout.in', $params);
- }
- // 打小票
- if (!empty($premises) && $params['goods_classify'] == "MEALS") {
- dump('payCons 打小票');
- $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
- if (!empty($restaurant->dept_extend_json)) {
- $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
- if (isset($deptExtendJson['printer'])) {
- foreach ($deptExtendJson['printer'] as $key => $item) {
- if (strpos($key, '结算') !== false && $order->order_status_payment == 'SUCCESS') {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['order_id']
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- }
- }
- }
- }
- if ($order->order_status_payment != 'SUCCESS') {
- _syslog("订单", "支付异常,检查是否有轮询");
- // 恢复优惠券到已占用
- if (!is_array($couponUseJson)) {
- $couponUseJson = json_decode($couponUseJson, true);
- }
- $this->changeOrderCouponStatus($couponUseJson, 'WAITING');
- return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
- }
- _syslog("订单", "订单支付成功");
- return json_success('支付成功');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- _syslog("订单", "订单支付失败");
- return json_fail('支付失败');
- }
- }
- /**
- * 删除订单
- */
- public function delete(Request $request): Response
- {
- $params = $request->post();
- Db::beginTransaction();
- try {
- $order = Order::where('order_id', $params['order_id'])
- ->where('order_status_system', 'CANCEL')
- ->orWhere(function ($query) use ($params) {
- $query->whereIn('order_status_system', ['WAITING', 'SENDING'])->where('order_category', 'SYSTEM')->where('order_id', $params['order_id']);
- })
- ->first();
- if (!$order) {
- return json_fail('此订单不允许删除');
- }
- $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
- if ($payDetail) {
- $payType = explode('-', $payDetail->pay_prepayid);
- // 余额支付
- if (isset($payType[1]) && $payType[1] == 'CASH') {
- $memberAccount = MemberAccount::where('join_account_member_id', $payDetail->join_pay_member_id)
- ->where('member_account_classify', 'CASH')
- ->first();
- $memberAccount->member_account_expend = $memberAccount->member_account_expend - $payDetail->pay_amount;
- $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $payDetail->pay_amount;
- $memberAccount->member_account_update_user_id = JwtToken::getCurrentId();
- $memberAccount->member_account_updatetimes = time();
- $memberAccount->save();
- }
- // 员工福利支付
- if (isset($payType[1]) && $payType[1] == 'WELFARE') {
- $memberAccount = MemberAccount::where('join_account_member_id', $payDetail->join_pay_member_id)
- ->where('member_account_classify', 'WELFARE')
- ->first();
- $memberAccount->member_account_expend = $memberAccount->member_account_expend - $payDetail->pay_amount;
- $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $payDetail->pay_amount;
- $memberAccount->member_account_update_user_id = JwtToken::getCurrentId();
- $memberAccount->member_account_updatetimes = time();
- $memberAccount->save();
- }
- // 删支付记录
- $payDetail->delete();
- }
- // 删收货信息
- OrderExpress::where('join_express_order_id', $params['order_id'])->delete();
- // 删订单详情
- OrderSheet::where('join_sheet_order_id', $params['order_id'])->delete();
- // 删主订单
- Order::where('order_id', $params['order_id'])->delete();
- Db::commit();
- _syslog("订单", "删除订单成功");
- return json_success('删除订单成功');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- _syslog("订单", "删除订单失败");
- return json_fail('删除订单失败');
- }
- }
- /**
- * 取消订单
- */
- public function cancelOrder(Request $request)
- {
- $orderId = $request->post('order_id', '');
- if (!$orderId) {
- return json_fail('参数异常');
- }
- Db::beginTransaction();
- try {
- $order = Order::where('order_id', $orderId)->first();
- if (empty($order)) {
- return json_fail('订单数据异常');
- }
- if ($order->order_status_system != 'PAYING') {
- return json_fail('仅未支付的订单可以取消!');
- }
- if (!empty($order->order_discount_json)) {
- $orderDiscountJson = json_decode($order->order_discount_json, true);
- foreach ($orderDiscountJson as $discount) {
- if (!empty($discount['coupon_id']) && !empty($discount['coupon_detail_id'])) {
- foreach ($discount['coupon_detail_id'] as $detailId) {
- if (substr($detailId, 0, 4) == 'CUDT') {
- // 恢复优惠券
- CouponDetail::where('coupon_detail_id', $detailId)->update(['coupon_detail_status' => 'ACTIVED']);
- }
- }
- }
- }
- }
- // sheet 表
- OrderSheet::where('join_sheet_order_id', $orderId)->update(['order_sheet_status' => 'CANCEL']);
- // payDetail 表
- PayDetail::where('join_pay_order_id', $order->order_groupby)->update([
- 'pay_status' => 'CANCEL',
- 'pay_extend_json' => json_encode(['cancel_times' => date('Y-m-d H:i:s')])
- ]);
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
- SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
- }
- }
- // 主表存取消时间吧
- $orderExtendJson = [];
- if (!empty($order->order_extend_json)) {
- $orderExtendJson = json_decode($order->order_extend_json, true);
- }
- $orderExtendJson['cancel_times'] = date('Y-m-d H:i:s');
- $order->order_extend_json = json_encode($orderExtendJson, JSON_UNESCAPED_UNICODE);
- $order->order_is_complete = 'Y';
- $order->order_status_system = 'CANCEL';
- $order->order_status_payment = 'CANCEL';
- $order->save();
- Db::commit();
- return json_success('');
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail('订单取消失败');
- }
- }
- public function insert(Request $request): Response
- {
- $params = $request->post();
- // 判断餐品是否连带着服务或实体
- $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
- if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
- return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
- }
- if (in_array('MEALS', $goodsClassifys)) {
- $params['submit_goods_classify'] = 'MEALS';
- }
- if (in_array('PACKAGE', $goodsClassifys)) {
- $params['submit_goods_classify'] = 'PACKAGE';
- }
- if (!empty($params['dept_premises_id'])) {
- $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
- }
- $params['goods_classify'] = $goodsClassifys[0];
- Db::beginTransaction();
- try {
- // 使用优惠券
- $couponUseJson = [];
- if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
- $couponResult = OrderService::payUseCoupon('insert', $params['settlement_now'], $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
- if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
- throw new BusinessException("计算优惠后,实付金额错误!");
- }
- // 组装优惠券使用数据,存主表优惠里
- if (!empty($couponResult['use_coupon_json'])) {
- $couponUseJson = $couponResult['use_coupon_json'];
- }
- }
- // 存储优惠信息
- $params['order_discount_json'] = json_encode($this->discountRecord($couponUseJson, $params));
- // 验证库存
- foreach ($params['goodsContentList'] as $goods) {
- // 减库存,规格和总库存
- if (!isset($params['submit_goods_classify']) || !in_array($params['submit_goods_classify'], ['MEALS', 'PACKAGE'])) {
- $goodsSku = GoodsSku::where('goods_sku_id', $goods['sku_id'])->first();
- $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
- if (isset($skuStorageJson['storage']) && !empty($skuStorageJson['storage'])) {
- $skuStorageJson['storage'] = $skuStorageJson['storage'] - $goods['nbr'];
- }
- if (!isset($skuStorageJson['storage']) || (!empty($skuStorageJson['storage']) && $skuStorageJson['storage'] < 0)) {
- throw new BusinessException('库存不足');
- }
- }
- $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
- $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
- if ($goodsRunning->goods_running_storage < 0) {
- throw new BusinessException('库存不足');
- }
- }
- // 余额、福利、储值卡 验证短信
- if ($params['settlement_now'] == 'Y' && $params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['CASH', 'CARD', 'WELFARE', 'VIP'])) {
- $code = $params['sms_code'];
- if (!$code) {
- throw new BusinessException('验证码错误,请重新输入');
- }
- $member = Member::find($params['join_order_member_id']);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:ORDER_PAY:" . $mobile;
- $redisCode = Redis::get($key);
- if ($redisCode != $code && $code != '123456') {
- throw new BusinessException('验证码错误,请重新输入');
- }
- Redis::del($key);
- }
- // 验证线下付款密码
- if ($params['settlement_now'] == 'Y' && $params['pay_constitute'] == 'N' && in_array($params['pay_category'], ['OFFLINE', 'MONEY'])) {
- $password = $params['offline_password'];
- if ($password != '666888') {
- throw new BusinessException('密码错误,请重新输入');
- }
- }
- // 下单账户
- if (empty($params['join_order_member_id']) && !empty($params['mobile'])) {
- if (Member::where('member_mobile', $params['mobile'])->exists()) {
- throw new BusinessException('会员已存在');
- }
- $params['join_order_member_id'] = $params['member_id'] = 'MR' . date('ymdHi') . random_string(4, 'up');
- // 创建会员
- MemberService::createMember($params);
- } else if (empty($params['join_order_member_id']) && empty($params['mobile'])) {
- $params['join_order_member_id'] = Member::where('member_mobile', '0000')->value('member_id');
- }
- if (empty($params['join_order_member_id'])) {
- throw new BusinessException('检查下单账户');
- }
- $qrcodePayAmount = 0;
- $params['orderId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $systemStatus = 'SENDING'; // 待发货
- // 立即结算
- if ($params['settlement_now'] == 'Y') {
- if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
- $params['order_is_complete'] = 'Y';
- $systemStatus = 'DONE';
- }
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
- $params['order_is_complete'] = 'N';
- $systemStatus = "WAITING";
- }
- }
- if ($params['settlement_now'] == 'Y' && ($params['pay_category'] == 'OFFLINE' || $params['pay_category'] == 'MONEY')) {
- if ($params['pay_category'] == 'OFFLINE' && !empty($params['pay_category_sub'])) {
- $params['pay_category'] = $params['pay_category_sub'];
- }
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'CASH') { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'CASH')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N') {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'VIP') { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'VIP')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N') {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'WELFARE') { // 福利账户
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'WELFARE')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $account->member_account_surplus = floatval($account->member_account_surplus);
- if ($params['pay_constitute'] == 'N' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && ($params['order_amount_pay'] > $account->member_account_surplus)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $account->member_account_surplus;
- $params['order_amount_pay'] = $account->member_account_surplus;
- }
- if ($params['pay_constitute'] == 'N') {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- // 福利账户 300 、 700
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS'])) {
- $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->whereIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES'])
- ->get()
- ->toArray();
- $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
- $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->where('pay_category', 'REFUND')
- ->get()
- ->toArray();
- $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
- $paySum = 0;
- foreach ($payDetailArray as $key => $item) {
- if (isset($refundPayDetailArray[$key])) {
- $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
- continue;
- }
- $paySum = $paySum + $item;
- }
- if ($params['pay_constitute'] == 'N' && 700 - $paySum < $params['order_amount_pay']) {
- Db::rollBack();
- return json_fail('超出福利限额');
- } else if ($params['pay_constitute'] == 'Y' && 700 - $paySum < $params['order_amount_pay']) {
- $qrcodePayAmount = $params['order_amount_pay'] - (700 - $paySum);
- $params['order_amount_pay'] = (700 - $paySum);
- }
- } else {
- $payDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->whereNotIn('pay_category', ['SERVICE', 'CHNMED', 'CHNNCD', 'MEALS', 'DESHES', 'REFUND', 'RECHARGE'])
- ->get()
- ->toArray();
- $payDetailArray = array_column($payDetails, 'pay_amount', 'join_pay_order_id');
- $refundPayDetails = PayDetail::where('join_pay_member_id', $params['join_order_member_id'])
- ->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', $params['join_order_member_id'] . '-WELFARE')
- ->where('pay_category', 'REFUND')
- ->get()
- ->toArray();
- $refundPayDetailArray = array_column($refundPayDetails, 'pay_amount', 'join_pay_order_id');
- $paySum = 0;
- foreach ($payDetailArray as $key => $item) {
- if (isset($refundPayDetailArray[$key])) {
- $paySum = $paySum + ($item - $refundPayDetailArray[$key]);
- continue;
- }
- $paySum = $paySum + $item;
- }
- if ($params['pay_constitute'] == 'N' && 300 - $paySum < $params['order_amount_pay']) {
- throw new BusinessException('超出福利限额');
- } else if ($params['pay_constitute'] == 'Y' && 300 - $paySum < $params['order_amount_pay']) {
- $qrcodePayAmount = $params['order_amount_pay'] - (300 - $paySum);
- $params['order_amount_pay'] = (300 - $paySum);
- }
- }
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- } else if ($params['settlement_now'] == 'Y' && $params['pay_category'] == 'CARD') { // 储值卡账户
- $cardNbr = $params['card_nbr'];
- if (!$cardNbr) {
- throw new BusinessException('账户异常');
- }
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_nbr', $cardNbr)
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException('账户异常');
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException('账户余额不足');
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- if ($params['pay_constitute'] == 'N') {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- }
- if (($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && $params['settlement_now'] == 'Y' && !empty($params['qrcode_nbr'])) { // 付款码
- // 提交过来的支付分类
- $submitPayCategory = $params['pay_category'];
- // 账户支付的金额
- $accountAmount = $params['order_amount_pay'];
- if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0) {
- // 组合支付,支付金额改成需要付款码需要支付的金额
- $params['order_amount_pay'] = $qrcodePayAmount;
- }
- if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount <= 0) {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- // 不组合或者组合后需要付款码的金额>0
- if ($params['pay_constitute'] == 'N' || ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0)) {
- $result = OrderService::qrcodePay($params);
- $result = json_encode($result);
- $params['pay_json_response'] = $result;
- $result = json_decode($result, true);
- $prefix = substr($params['qrcode_nbr'], 0, 2);
- if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
- $params['pay_category'] = 'WXPAY';
- 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')) {
- $params['order_status_system'] = 'PAYING';
- $params['order_status_payment'] = 'PENDING';
- $params['order_is_complete'] = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
- $params['pay_category'] = 'ALIPAY';
- if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
- $params['order_status_system'] = 'PAYING';
- $params['order_status_payment'] = 'PENDING';
- $params['order_is_complete'] = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else {
- throw new BusinessException('付款码无效');
- }
- // 组合支付,追加加一条支付记录 pay_detail
- if ($params['pay_constitute'] == 'Y' && $qrcodePayAmount > 0 && $params['order_status_payment'] == 'SUCCESS') {
- $insertPayDetailData = [
- 'join_pay_member_id' => $params['join_order_member_id'],
- 'join_pay_order_id' => $params['orderGroupId'],
- 'pay_status' => 'SUCCESS',
- 'pay_category' => $params['goods_classify'],
- 'pay_amount' => $params['order_amount_pay'],
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_prepayid' => $params['pay_category'],
- 'pay_json_request' => json_encode($params),
- 'pay_json_response' => $params['pay_json_response'],
- 'pay_addtimes' => time()
- ];
- PayDetail::insert($insertPayDetailData);
- // 组合支付,还原提交的支付分类
- $params['pay_category'] = $submitPayCategory;
- }
- // 账户支付的金额
- $params['order_amount_pay'] = $accountAmount;
- }
- }
- $orderConfigJson = [];
- // 优惠
- if (!empty($params['preferential'])) {
- $orderConfigJson['preferential'] = $params['preferential'];
- }
- // 配送方式
- if (isset($params['delivery']) && ($params['delivery'] == 'PICKUP' || $params['delivery'] == 'ARRIVAL')) { // 自提/ 到店
- $orderConfigJson['premises'] = $params['dept_premises_id'];
- } else if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
- // $params['order_express_json'] = json_encode([
- // 'express' => 'Y',
- // ]);
- }
- $params['order_amount_pay'] = $params['order_amount_pay'] + $qrcodePayAmount;
- if (isset($params['delivery']) && in_array($params['delivery'], ['PICKUP', 'ARRIVAL']) && !empty($params['dept_premises_id'])) {
- // $premises = SysDept::where('dept_name',$params['dept_premises_id'])->where('dept_category','营业场所')->first();
- if (!$premises) {
- throw new BusinessException('门店不存在,请重新选择');
- }
- $params['submit_premises_id'] = $premises->dept_id;
- }
- if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS' && !empty($params['dept_premises_id'])) {
- $table = '';
- if (!empty($params['dept_table_id'])) {
- $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
- }
- $orderConfigJson['premises'] = $params['dept_premises_id'];
- $orderConfigJson['dept'] = $premises->dept_id ?? 0;
- $orderConfigJson['reach'] = "00:00";
- $orderConfigJson['table'] = !empty($table) ? $table->dept_name : null;
- $orderConfigJson['express'] = "到店吃";
- $orderConfigJson['tableid'] = $params['dept_table_id'] ?? null;
- if (!empty($params['eat'])) {
- $orderConfigJson['eat'] = $params['eat'] ?? null;
- }
- if ($params['settlement_now'] == 'N' && !empty($params['dept_table_id'])) {
- // 桌台设为使用中
- SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->update(['dept_status' => 'USING']);
- }
- }
- $params['order_config_json'] = json_encode($orderConfigJson);
- // 写入主订单
- $this->insertMain($params);
- // 订单详情
- $sheetId = $this->insertSheet($params);
- // 支付记录
- $params['order_amount_pay'] = $params['order_amount_pay'] - $qrcodePayAmount;
- $this->insertPayDetail($params);
- $params['order_express_goods'] = json_encode(['sheet' => [$sheetId]]);
- if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
- $params['order_express_type'] = '配送';
- // 入配送
- $this->saveExpress($params);
- } else if (isset($params['delivery']) && $params['delivery'] == 'PICKUP') {
- $params['order_express_type'] = '自提';
- if (!$premises) {
- throw new BusinessException('自提门店不存在');
- }
- $params['order_express_city'] = $premises->dept_city;
- $params['order_express_address'] = $premises->dept_address;
- $params['order_express_telephone'] = $premises->dept_telephone;
- $params['order_express_extend_json'] = json_encode(['pick_code' => random_string(4, 'number')]);
- $this->saveExpress($params);
- } else if (isset($params['delivery']) && $params['delivery'] == 'ARRIVAL') {
- $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
- $params['order_express_type'] = '到店';
- if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- $params['order_express_type'] = '堂食';
- }
- if (!$premises) {
- throw new BusinessException('门店不存在');
- }
- $params['order_express_city'] = $premises->dept_city;
- $params['order_express_address'] = $premises->dept_address;
- $params['order_express_telephone'] = $premises->dept_telephone;
- $this->saveExpress($params);
- }
- // 买的单个服务
- $writeOffDate = [];
- $applyData = [];
- // 服务已完成,生成核销数据
- // if ($params['order_status_payment'] == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
- // $writeOffDate = OrderService::generateWriteOffData($params);
- // $applyData = OrderService::generateAppointmentApplyData($params);
- // }
- if ($params['order_status_payment'] == 'SUCCESS') {
- foreach ($params['goodsContentList'] as $goods) {
- $params['join_sheet_goods_id'] = $goods['goods_id'];
- if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD']) && $params['delivery'] == 'ARRIVAL') {
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['join_sheet_goods_sku_id'] = $goods['sku_id'];
- $params['goods_id'] = $goods['goods_id'];
- $params['order_sheet_num'] = $goods['nbr'];
- // 预约表
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate, $applyData);
- }
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = $goods['goods_classify'];
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') { // 一个套餐买多个
- $params['packageId'] = $goods['goods_id'];
- $components = GoodsComponent::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_classify');
- }
- ])->where('join_component_master_goods_id', $params['packageId'])
- ->get()
- ->toArray();
- foreach ($components as $component) {
- $componentJson = json_decode($component['goods_component_json'], true);
- $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate);
- }
- $goods['goods_id'] = $component['join_component_goods_id'];
- $goods['goods_name'] = $component['goods']['goods_name'];
- $goods['goods_classify'] = $component['goods']['goods_classify'];
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = 'SERVICE';
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- }
- }
- }
- }
- // 2.4W 康养城
- if ($params['goods_classify'] == 'VIP' && $params['order_status_payment'] == 'SUCCESS') {
- $params['member_id'] = $params['join_order_member_id'];
- Event::dispatch('order.kangyangCityVIP.grant', $params);
- }
- Db::commit();
- // 触发事件
- if (!empty($params['order_is_complete']) && $params['order_is_complete'] == 'Y' && $params['order_status_payment'] == 'SUCCESS') {
- // 订单完成
- Event::dispatch('order.complete', $params);
- // 上级提成
- Event::dispatch('commission.order', $params);
- // 入收支明细表
- $params['inout_category'] = '餐饮订单';
- Event::dispatch('statistics.inout.in', $params);
- }
- // 打小票
- if (!empty($premises) && isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- dump("insert 打小票");
- if ($premises->dept_category != '餐厅') {
- $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
- } else {
- $restaurant = $premises;
- }
- if (!empty($restaurant->dept_extend_json)) {
- $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
- if (isset($deptExtendJson['printer'])) {
- foreach ($deptExtendJson['printer'] as $key => $item) {
- if (strpos($key, '结算') !== false && $params['order_status_payment'] == 'SUCCESS') {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['orderId'],
- 'order_batch' => ''
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['orderId'],
- 'order_batch' => ''
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- }
- }
- }
- }
- if ($params['settlement_now'] == 'Y' && $params['order_status_payment'] != 'SUCCESS') {
- _syslog("订单", "支付异常,检查是否有轮询");
- // 恢复优惠券到已占用
- if (!is_array($couponUseJson)) {
- $couponUseJson = json_decode($couponUseJson, true);
- }
- $this->changeOrderCouponStatus($couponUseJson, 'WAITING');
- return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
- }
- _syslog("订单", "创建订单成功");
- return json_success('创建订单成功');
- } catch (BusinessException $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("订单", $e->getMessage());
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("订单", "创建订单失败");
- return json_fail('创建订单失败');
- }
- }
- /**
- * @Desc 释放下单时选的优惠券
- * @Author Gorden
- * @Date 2024/9/19 9:56
- *
- * @param $coupon
- * @return false|string
- */
- private function releaseCoupon($coupon)
- {
- if (!empty($coupon) && is_array($coupon)) {
- $updateData = [
- 'coupon_detail_status' => 'ACTIVED',
- 'coupon_detail_used_datetime' => ''
- ];
- foreach ($coupon as $key => $item) {
- if (!empty($item['coupon_id']) && !empty($item['coupon_detail_id'])) {
- foreach ($item['coupon_detail_id'] as $detailId) {
- if (substr($detailId, 0, 4) == 'CUDT') {
- CouponDetail::where('join_detail_coupon_id', $item['coupon_id'])
- ->where('coupon_detail_id', $detailId)
- ->where('coupon_detail_status', 'WAITING')
- ->update($updateData);
- }
- }
- unset($coupon[$key]);
- }
- }
- }
- return json_encode($coupon);
- }
- /**
- * @Desc 修改优惠券状态
- * @Author Gorden
- * @Date 2024/9/19 9:03
- *
- * @param $coupon
- * @param $status
- * @return void
- */
- private function changeOrderCouponStatus($coupon, $status)
- {
- if (!empty($coupon) && is_array($coupon)) {
- $updateData['coupon_detail_status'] = $status;
- if ($status == 'ACTIVED' || $status == 'WAITING') {
- $updateData['coupon_detail_used_datetime'] = '';
- } elseif ($status == 'USED') {
- $updateData['coupon_detail_used_datetime'] = date('Y-m-d H:i:s');
- }
- foreach ($coupon as $item) {
- if (!empty($item['coupon_id']) && !empty($item['coupon_detail_id'])) {
- foreach ($item['coupon_detail_id'] as $detailId) {
- CouponDetail::where('join_detail_coupon_id', $item['coupon_id'])
- ->where('coupon_detail_id', $detailId)->update($updateData);
- }
- }
- }
- }
- }
- /**
- * 组合支付下单
- */
- public function insertConstitute(Request $request): Response
- {
- $params = $request->post();
- // 判断餐品是否连带着服务或实体
- $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
- if (in_array('MEALS', $goodsClassifys) && count($goodsClassifys) > 1) {
- return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
- }
- if (in_array('MEALS', $goodsClassifys)) {
- $params['submit_goods_classify'] = 'MEALS';
- }
- if (in_array('PACKAGE', $goodsClassifys)) {
- $params['submit_goods_classify'] = 'PACKAGE';
- }
- if (!empty($params['dept_premises_id'])) {
- $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
- }
- Db::beginTransaction();
- try {
- // 使用优惠券
- $couponUseJson = [];
- if (!empty($params['join_order_member_id']) && !empty($params['preferential'])) {
- $couponResult = OrderService::payUseCoupon('insert', $params['settlement_now'], $params['join_order_member_id'], $params['goodsContentList'], $params['preferential'], $params['order_amount_total']);
- if (!empty($couponResult['pay_amount']) && $couponResult['pay_amount'] != $params['order_amount_pay']) {
- throw new BusinessException("计算优惠后,实付金额错误!");
- }
- // 组装优惠券使用数据,存主表优惠里
- if (!empty($couponResult['use_coupon_json'])) {
- $couponUseJson = $couponResult['use_coupon_json'];
- }
- }
- // 存储优惠信息
- $params['order_discount_json'] = json_encode($this->discountRecord($couponUseJson, $params));
- $orderAmountPay = $params['order_amount_pay'];
- $constituteList = array_column($params['pay_category_constitute_list'], 'amount', 'category');
- // 验证金额
- $constituteAmount = 0;
- foreach ($params['pay_category_constitute_list'] as $item) {
- $constituteAmount = $constituteAmount + $item['amount'];
- }
- if ($params['order_amount_pay'] != $constituteAmount) {
- throw new BusinessException("组合支付金额与应付金额不一致");
- }
- $params['goods_classify'] = $goodsClassifys[0];
- // 验证库存
- OrderService::checkGoodsStorage($params);
- // 余额、福利、储值卡 验证短信
- 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']))) {
- $code = $params['sms_code'];
- if (!$code) {
- throw new BusinessException("验证码错误,请重新输入");
- }
- $member = Member::find($params['join_order_member_id']);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:ORDER_PAY:" . $mobile;
- $redisCode = Redis::get($key);
- if ($redisCode != $code && $code != '123456') {
- throw new BusinessException("验证码错误,请重新输入");
- }
- Redis::del($key);
- }
- // 验证线下付款密码
- if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute']) || in_array('MONEY', $params['pay_category_constitute'])) {
- $password = $params['offline_password'];
- if ($password != '666888') {
- throw new BusinessException("密码错误,请重新输入");
- }
- }
- // 下单账户
- if (empty($params['join_order_member_id']) && !empty($params['mobile'])) {
- if (Member::where('member_mobile', $params['mobile'])->exists()) {
- throw new BusinessException("会员已存在");
- }
- $params['join_order_member_id'] = $params['member_id'] = 'MR' . date('ymdHi') . random_string(4, 'up');
- // 创建会员
- MemberService::createMember($params);
- } else if (empty($params['join_order_member_id']) && empty($params['mobile'])) {
- $params['join_order_member_id'] = Member::where('member_mobile', '0000')->value('member_id');
- }
- if (empty($params['join_order_member_id'])) {
- throw new BusinessException("检查下单账户");
- }
- $qrcodePayAmount = 0;
- $params['orderId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $params['orderGroupId'] = 'OD' . date('ymdHi') . random_string(4, 'up');
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $systemStatus = 'SENDING'; // 待发货
- // 立即结算
- if ($params['settlement_now'] == 'Y') {
- if (in_array($params['goods_classify'], ['MEALS', 'VIP'])) {
- $params['order_is_complete'] = 'Y';
- $systemStatus = 'DONE';
- }
- if (in_array($params['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE']) && $params['delivery'] == 'ARRIVAL') {
- $params['order_is_complete'] = 'N';
- $systemStatus = "WAITING";
- }
- }
- if (!empty($params['pay_category_constitute']) && in_array('OFFLINE', $params['pay_category_constitute'])) { // 线下支付
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- $params['pay_category'] = $params['pay_category_sub'] ?? 'OFFLINE';
- // 线下支付金额
- if (isset($constituteList['OFFLINE'])) {
- $params['order_amount_pay'] = $constituteList['OFFLINE'];
- // 生成支付记录
- OrderService::createPayDetail($params);
- }
- $params['order_amount_pay'] = $orderAmountPay;
- }
- if (!empty($params['pay_category_constitute']) && in_array('MONEY', $params['pay_category_constitute'])) { // 现金支付
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- $params['pay_category'] = 'MONEY';
- // 现金支付金额
- if (isset($constituteList['MONEY'])) {
- $params['order_amount_pay'] = $constituteList['MONEY'];
- // 生成支付记录
- OrderService::createPayDetail($params);
- }
- $params['order_amount_pay'] = $orderAmountPay;
- }
- if (!empty($params['pay_category_constitute']) && in_array('CASH', $params['pay_category_constitute'])) { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_classify', 'CASH')
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException("账户异常");
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- if (isset($constituteList['CASH'])) {
- $params['order_amount_pay'] = $constituteList['CASH'];
- $params['pay_category'] = $params['join_order_member_id'] . '-CASH';
- }
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException("账户余额不足");
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- // 生成支付记录
- OrderService::createPayDetail($params);
- $params['order_amount_pay'] = $orderAmountPay;
- }
- if (!empty($params['pay_category_constitute']) && in_array('CARD', $params['pay_category_constitute'])) { // 储值卡账户
- $cardNbr = $params['card_nbr'];
- if (!$cardNbr) {
- throw new BusinessException("储值卡账户异常");
- }
- $account = MemberAccount::where('join_account_member_id', $params['join_order_member_id'])
- ->where('member_account_nbr', $cardNbr)
- ->where('member_account_status', 'ACTIVED')
- ->first();
- if (!$account) {
- throw new BusinessException("储值卡账户异常");
- }
- $amount = $account->member_account_surplus + $account->member_account_added;
- // 储值卡账户支付金额
- if (isset($constituteList['CARD'])) {
- $params['order_amount_pay'] = $constituteList['CARD'];
- $params['pay_category'] = $cardNbr;
- }
- if ($params['pay_constitute'] == 'N' && (!$account || $params['order_amount_pay'] > $amount)) {
- throw new BusinessException("储值卡账户余额不足");
- }
- if ($params['pay_constitute'] == 'Y' && (!$account || $params['order_amount_pay'] > $amount)) {
- $qrcodePayAmount = $params['order_amount_pay'] - $amount;
- $params['order_amount_pay'] = $amount;
- }
- if ($params['order_amount_pay'] > $account->member_account_surplus) {
- $cut = $account->member_account_added - ($params['order_amount_pay'] - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- $account->member_account_added = $cut;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $params['order_amount_pay'];
- }
- $account->member_account_expend = $account->member_account_expend + $params['order_amount_pay'];
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- // 生成支付记录
- OrderService::createPayDetail($params);
- $params['order_amount_pay'] = $orderAmountPay;
- }
- //!empty($params['pay_category_constitute']) && in_array('CARD',$params['pay_category_constitute'])
- // if(($params['pay_constitute'] == 'Y' || $params['pay_category'] == 'QRCODE') && $params['settlement_now'] == 'Y' && !empty($params['qrcode_nbr'])){ // 付款码
- if (!empty($params['pay_category_constitute']) && in_array('QRCODE', $params['pay_category_constitute']) && !empty($params['qrcode_nbr'])) { // 付款码
- // 需要付款码的金额>0
- if (isset($constituteList['QRCODE']) && $constituteList['QRCODE'] > 0) {
- // 付款码支付金额
- $params['order_amount_pay'] = $constituteList['QRCODE'];
- // 调支付
- $result = OrderService::qrcodePay($params);
- $result = json_encode($result);
- $params['pay_json_response'] = $result;
- $result = json_decode($result, true);
- $prefix = substr($params['qrcode_nbr'], 0, 2);
- if (in_array($prefix, [10, 11, 12, 13, 14, 15])) {
- $params['pay_category'] = 'WXPAY';
- 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')) {
- $params['order_status_system'] = 'PAYING';
- $params['order_status_payment'] = 'PENDING';
- $params['order_is_complete'] = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else if (in_array($prefix, [25, 26, 27, 28, 29, 30])) {
- $params['pay_category'] = 'ALIPAY';
- if ((!isset($result['code']) || $result['code'] != '10000') || (empty($result['trade_status']) || $result['trade_status'] != 'TRADE_SUCCESS')) {
- $params['order_status_system'] = 'PAYING';
- $params['order_status_payment'] = 'PENDING';
- $params['order_is_complete'] = 'N';
- // Db::rollBack();
- // return json_fail('支付失败');
- } else {
- $params['order_status_system'] = $systemStatus;
- $params['order_status_payment'] = 'SUCCESS';
- }
- } else {
- throw new BusinessException("二维码错误");
- }
- // 生成支付记录
- OrderService::createPayDetail($params);
- // 账户支付的金额
- $params['order_amount_pay'] = $orderAmountPay;
- }
- }
- $orderConfigJson = [];
- // 优惠
- if (!empty($params['preferential'])) {
- $orderConfigJson['preferential'] = $params['preferential'];
- }
- // 配送方式
- if (isset($params['delivery']) && ($params['delivery'] == 'PICKUP' || $params['delivery'] == 'ARRIVAL')) { // 自提/ 到店
- $orderConfigJson['premises'] = $params['dept_premises_id'];
- } else if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
- // $params['order_express_json'] = json_encode([
- // 'express' => 'Y',
- // ]);
- }
- $params['order_amount_pay'] = $params['order_amount_pay'] + $qrcodePayAmount;
- if (isset($params['delivery']) && in_array($params['delivery'], ['PICKUP', 'ARRIVAL']) && !empty($params['dept_premises_id'])) {
- // $premises = SysDept::where('dept_name',$params['dept_premises_id'])->where('dept_category','营业场所')->first();
- if (!$premises) {
- throw new BusinessException("门店不存在,请重新选择");
- }
- $params['submit_premises_id'] = $premises->dept_id;
- }
- if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS' && !empty($params['dept_table_id'])) {
- $table = SysDept::where('dept_id', $params['dept_table_id'])->where('dept_category', '桌台')->first();
- $orderConfigJson['premises'] = $params['dept_premises_id'];
- $orderConfigJson['dept'] = $premises->dept_id;
- $orderConfigJson['reach'] = "00:00";
- $orderConfigJson['table'] = !empty($table) ? $table->dept_name : null;
- $orderConfigJson['express'] = "堂食";
- $orderConfigJson['tableid'] = $params['dept_table_id'] ?? null;
- if (!empty($params['eat'])) {
- $orderConfigJson['eat'] = $params['eat'] ?? null;
- }
- }
- $params['order_config_json'] = json_encode($orderConfigJson);
- // 写入主订单
- $this->insertMain($params);
- // 订单详情
- $sheetId = $this->insertSheet($params);
- $params['order_express_goods'] = json_encode(['sheet' => $sheetId]);
- if (isset($params['delivery']) && $params['delivery'] == 'LOGISTICS') {
- $params['order_express_type'] = '配送';
- // 入配送
- $this->saveExpress($params);
- } else if (isset($params['delivery']) && $params['delivery'] == 'PICKUP') {
- $params['order_express_type'] = '自提';
- if (!$premises) {
- throw new BusinessException('自提门店不存在');
- }
- $params['order_express_city'] = $premises->dept_city;
- $params['order_express_address'] = $premises->dept_address;
- $params['order_express_telephone'] = $premises->dept_telephone;
- $params['order_express_extend_json'] = json_encode(['pick_code' => random_string(4, 'number')]);
- $this->saveExpress($params);
- } else if ($params['delivery'] == 'ARRIVAL') {
- $premises = SysDept::where('dept_name', $params['dept_premises_id'])->first();
- $params['order_express_type'] = '到店';
- if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- $params['order_express_type'] = '堂食';
- }
- if (!$premises) {
- throw new BusinessException('门店不存在');
- }
- $params['order_express_city'] = $premises->dept_city;
- $params['order_express_address'] = $premises->dept_address;
- $params['order_express_telephone'] = $premises->dept_telephone;
- $this->saveExpress($params);
- }
- // 买的单个服务
- $writeOffDate = [];
- $applyData = [];
- // 服务已完成,生成核销数据
- // if ($params['order_status_payment'] == 'SUCCESS' && in_array($goods['goods_classify'], ['SERVICE','CHNMED','CHNNCD', 'PACKAGE'])) {
- // $writeOffDate = OrderService::generateWriteOffData($params);
- // $applyData = OrderService::generateAppointmentApplyData($params);
- // }
- if ($params['order_status_payment'] == 'SUCCESS') {
- foreach ($params['goodsContentList'] as $goods) {
- $params['join_sheet_goods_id'] = $goods['goods_id'];
- if (isset($goods['goods_classify']) && in_array($goods['goods_classify'], ['SERVICE', 'CHNMED', 'CHNNCD']) && $params['delivery'] == 'ARRIVAL') {
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['join_sheet_goods_sku_id'] = $goods['sku_id'];
- $params['goods_id'] = $goods['goods_id'];
- $params['order_sheet_num'] = $goods['nbr'];
- // 预约表
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate, $applyData);
- }
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = $goods['goods_classify'];
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- } elseif (isset($goods['goods_classify']) && $goods['goods_classify'] == 'PACKAGE' && $params['delivery'] == 'ARRIVAL') { // 一个套餐买多个
- $params['packageId'] = $goods['goods_id'];
- $components = GoodsComponent::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_classify');
- }
- ])->where('join_component_master_goods_id', $params['packageId'])
- ->get()
- ->toArray();
- foreach ($components as $component) {
- $componentJson = json_decode($component['goods_component_json'], true);
- $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $params['order_sheet_num'] = $goods['nbr'] * $componentJson['nbr'];
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, $writeOffDate);
- }
- $goods['goods_id'] = $component['join_component_goods_id'];
- $goods['goods_name'] = $component['goods']['goods_name'];
- $goods['goods_classify'] = $component['goods']['goods_classify'];
- $goods['skuId'] = $goods['sku_id'];
- $goods['category'] = 'SERVICE';
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- }
- }
- }
- }
- // 2.4W 康养城
- if ($params['goods_classify'] == 'VIP' && intval($params['order_amount_pay']) == 24000 && $params['order_status_payment'] == 'SUCCESS') {
- $params['member_id'] = $params['join_order_member_id'];
- Event::dispatch('order.kangyangCityVIP.grant', $params);
- }
- Db::commit();
- // 触发事件
- if (!empty($params['order_is_complete']) && $params['order_is_complete'] == 'Y' && $params['order_status_payment'] == 'SUCCESS') {
- // 完成订单
- Event::dispatch('order.complete', $params);
- // 上级提成
- Event::dispatch('commission.order', $params);
- // 入收支明细表
- $params['inout_category'] = '餐饮订单';
- Event::dispatch('statistics.inout.in', $params);
- }
- // 打小票
- if (!empty($premises) && isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- // if (!empty($premises)){
- if ($premises->dept_category != '餐厅') {
- $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
- } else {
- $restaurant = $premises;
- }
- if (!empty($restaurant->dept_extend_json)) {
- $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
- if (isset($deptExtendJson['printer'])) {
- foreach ($deptExtendJson['printer'] as $key => $item) {
- if (strpos($key, '结算') !== false && $params['order_status_payment'] == 'SUCCESS') {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['orderId'],
- 'order_batch' => ''
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['orderId'],
- 'order_batch' => ''
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- }
- }
- }
- }
- if ($params['settlement_now'] == 'Y' && $params['order_status_payment'] != 'SUCCESS') {
- _syslog("订单", "支付异常,检查是否有轮询");
- // 恢复优惠券到已占用
- if (!is_array($couponUseJson)) {
- $couponUseJson = json_decode($couponUseJson, true);
- }
- $this->changeOrderCouponStatus($couponUseJson, 'WAITING');
- return json_throw(2001, '支付异常', ['order_id' => $params['orderId']]);
- }
- _syslog("订单", "创建订单成功");
- return json_success('创建订单成功');
- } catch (BusinessException $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("订单", $e->getMessage());
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("订单", "创建订单失败");
- return json_fail('创建订单失败');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/6/7 10:30
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public function insertMain($params)
- {
- try {
- $orderCategory = 'NORMAL';
- if (!empty($params['order_category'])) {
- $orderCategory = $params['order_category'];
- } else if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- $orderCategory = 'DISHES';
- } else if (isset($params['goods_classify'])) {
- $orderCategory = $params['goods_classify'];
- }
- if (empty($params['order_extend_json'])) {
- $params['order_extend_json'] = [];
- } else {
- if (is_json($params['order_extend_json'])) {
- $params['order_extend_json'] = json_decode($params['order_extend_json'], true);
- }
- }
- // 推荐人
- $params['order_extend_json']['referee'] = $params['referee'] ?? '';
- $data = [
- 'order_id' => $params['orderId'],
- 'order_groupby' => $params['orderGroupId'],
- 'join_order_member_id' => $params['join_order_member_id'],
- 'order_name' => date('Y-m-d H:i:s') . '-订单',
- 'order_amount_total' => $params['order_amount_total'],
- 'order_amount_pay' => $params['order_amount_pay'],
- 'order_category' => $orderCategory,
- 'order_classify' => $orderCategory,
- 'order_is_complete' => $params['order_is_complete'] ?? 'N',
- 'order_status_system' => $params['order_status_system'],
- 'order_status_payment' => $params['order_status_payment'],
- 'order_status_storage' => $params['order_status_storage'],
- 'order_platform' => $params['order_platform'],
- 'order_remark' => $params['order_remark'] ?? '',
- 'order_discount_json' => $params['order_discount_json'],
- 'order_config_json' => $params['order_config_json'] ?? '[]',
- 'order_express_json' => $params['order_express_json'] ?? '[]',
- 'order_extend_json' => $params['order_extend_json'] ? json_encode($params['order_extend_json']) : '[]',
- 'order_addtimes' => time(),
- 'order_add_user_id' => JwtToken::getCurrentId()
- ];
- Order::insert($data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('订单创建信息失败');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/6/7 10:25
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public function insertSheet($params)
- {
- try {
- $orderSheetIds = [];
- foreach ($params['goodsContentList'] as $goods) {
- //{"unit": "份", "table": null, "premises": "15"}
- $price = floatval($goods['goods_sales_price']);
- $extendJson['unit'] = $goods['sku_name'];
- if (isset($params['submit_premises_id'])) {
- $extendJson['premises'] = $params['submit_premises_id'];
- }
- if (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') {
- $extendJson['table'] = null;
- }
- $sheetPriceAmount = round(($params['order_amount_pay'] / $params['order_amount_total']) * $goods['goods_sales_price'], 2);
- $data = [
- 'join_sheet_member_id' => $params['join_order_member_id'],
- 'join_sheet_order_id' => $params['orderId'],
- 'join_sheet_goods_id' => $goods['goods_id'],
- 'join_sheet_goods_sku_id' => $goods['sku_id'],
- 'order_sheet_status' => $params['settlement_now'] == 'Y' && $params['order_status_payment'] == 'SUCCESS' ? 'DONE' : 'PAYING',
- 'order_sheet_category' => (isset($params['submit_goods_classify']) && $params['submit_goods_classify'] == 'MEALS') ? 'DISHES' : 'NORMAL',
- 'order_sheet_num' => $goods['nbr'],
- 'order_sheet_price' => $goods['goods_sales_price'],
- 'order_sheet_price_pay' => $sheetPriceAmount,
- 'order_sheet_amount' => $price * $goods['nbr'],
- 'order_sheet_pay' => $sheetPriceAmount * $goods['nbr'],
- 'order_sheet_task_status' => 'NONE',
- 'order_sheet_remark' => $params['order_remark'] ?? '',
- 'order_sheet_addtimes' => time(),
- 'order_sheet_extend_json' => json_encode($extendJson)
- ];
- $orderSheetId = OrderSheet::insertGetId($data);
- $orderSheetIds[] = $orderSheetId;
- // 减库存,规格和总库存
- if (!isset($params['submit_goods_classify']) || !in_array($params['submit_goods_classify'], ['MEALS', 'PACKAGE'])) {
- $goodsSku = GoodsSku::where('goods_sku_id', $goods['sku_id'])->first();
- $skuStorageJson = json_decode($goodsSku->goods_sku_storage_json, true);
- if (isset($skuStorageJson['storage']) && !empty($skuStorageJson['storage'])) {
- $skuStorageJson['storage'] = $skuStorageJson['storage'] - $goods['nbr'];
- }
- if (!isset($skuStorageJson['storage']) || (!empty($skuStorageJson['storage']) && $skuStorageJson['storage'] < 0)) {
- throw new BusinessException('库存不足');
- }
- $goodsSku->goods_sku_storage_json = json_encode($skuStorageJson);
- $goodsSku->save();
- }
- $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
- $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
- if ($goodsRunning->goods_running_storage < 0) {
- throw new BusinessException('库存不足');
- }
- if ($params['order_status_payment'] == 'SUCCESS') {
- $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $goods['nbr'];
- }
- $goodsRunning->save();
- }
- return $orderSheetIds;
- } catch (\support\exception\BusinessException $e) {
- dump($e->getMessage() . '||' . $e->getLine());
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage() . '||' . $e->getLine());
- throw new BusinessException('订单创建失败');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/6/7 10:35
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public function insertPayDetail($params)
- {
- try {
- if (in_array($params['pay_category'], ['WXPAY', 'ALIPAY'])) {
- $payPrepayid = $params['pay_category'];
- } else if ($params['pay_category'] == 'OFFLINE') {
- $payPrepayid = 'OFFLINE';
- } else if ($params['pay_category'] == 'OFFLINE_ALIPAY') {
- $payPrepayid = 'OFFLINE_ALIPAY';
- } else if ($params['pay_category'] == 'OFFLINE_WXPAY') {
- $payPrepayid = 'OFFLINE_WXPAY';
- } else if ($params['pay_category'] == 'MONEY') {
- $payPrepayid = 'MONEY';
- } else {
- $payPrepayid = $params['join_order_member_id'] . '-' . $params['pay_category'];
- }
- $data = [
- 'join_pay_member_id' => $params['join_order_member_id'],
- 'join_pay_order_id' => $params['orderGroupId'],
- 'pay_status' => $params['settlement_now'] == 'Y' && $params['order_status_payment'] == 'SUCCESS' ? 'SUCCESS' : 'WAITING',
- 'pay_category' => $params['goods_classify'],
- 'pay_amount' => $params['order_amount_pay'],
- 'pay_prepayid' => $payPrepayid,
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'join_pay_object_json' => !empty($params['orderId']) ? json_encode(['order_id' => $params['orderId']]) : '[]',
- 'pay_json_request' => json_encode($params),
- 'pay_json_response' => $params['pay_json_response'] ?? '[]',
- 'pay_remark' => $params['order_remark'] ?? '',
- 'pay_addtimes' => time(),
- ];
- PayDetail::insert($data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('创建支付记录失败');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/6/7 10:50
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public function insertAppointment($params, $writeOffDate, $applyData = [])
- {
- try {
- $data = [
- 'appointment_id' => $params['appointmentId'],
- 'join_appointment_member_id' => $params['join_order_member_id'],
- 'join_appointment_goods_id' => $params['join_sheet_goods_id'],
- 'join_appointment_goods_sku_id' => $params['join_sheet_goods_sku_id'],
- 'join_appointment_order_id' => $params['orderId'],
- 'join_appointment_member_benefit_id' => $params['benefitId'],
- 'appointment_classify' => $params['goods_classify'],
- 'appointment_status' => 'INIT',
- 'appointment_category' => 'NORMAL',
- 'appointment_platform' => 'SYSTEM',
- 'appointment_addtimes' => time(),
- 'appointment_datetime' => '',
- 'appointment_apply_datetime' => '',
- 'appointment_apply_json' => '[]',
- 'appointment_done_datetime' => '',
- 'appointment_remark' => $params['order_remark'] ?? '',
- 'appointment_done_json' => '[]'
- ];
- Appointment::insert($data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException("创建权益记录失败");
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/6/7 11:05
- *
- * @param $params
- * @param $goods
- * @return void
- * @throws BusinessException
- */
- public function insertMemberBenefit($params, $goods)
- {
- try {
- $data = [
- 'member_benefit_id' => $params['benefitId'],
- 'join_benefit_member_id' => $params['join_order_member_id'],
- 'join_benefit_package_id' => $params['packageId'] ?? '',
- 'join_benefit_goods_id' => $goods['goods_id'],
- 'join_benefit_goods_sku_id' => $goods['skuId'] ?? '',
- 'join_benefit_order_id' => $params['orderId'],
- 'member_benefit_status' => 'ACTIVED',
- 'member_benefit_category' => $goods['category'] ?? '',
- 'member_benefit_name' => $goods['goods_name'] ?? '',
- 'member_benefit_limit_count' => $params['order_sheet_num'],
- 'member_benefit_used_count' => 0,
- 'member_benefit_remark' => $params['order_remark'] ?? '',
- 'member_benefit_addtimes' => time()
- ];
- MemberBenefit::insert($data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('创建会员权益失败');
- }
- }
- /**
- * @Desc 检测会员是否发生过支付行为
- * @Author Gorden
- * @Date 2024/10/22 10:13
- *
- * @param Request $request
- * @return Response
- */
- public function checkPayMarking(Request $request)
- {
- $groupId = $request->get('group_id');
- if (!$groupId) {
- return json_fail('参数异常');
- }
- $payDetails = PayDetail::where('join_pay_order_id', $groupId)->get()->toArray();
- foreach ($payDetails as $payDetail) {
- if (!empty($payDetail['join_pay_object_json'])) {
- $payObjectJson = json_decode($payDetail['join_pay_object_json'], true);
- if (isset($payObjectJson['pay_marking']) && $payObjectJson['pay_marking'] == 'Y') {
- return json_fail("会员发生过支付行为,确定后再执行操作");
- }
- }
- }
- return json_success('success');
- }
- public function addDishes(Request $request)
- {
- $params = $request->post();
- $goodsClassifys = array_unique(array_column($params['goodsContentList'], 'goods_classify'));
- if (!in_array('MEALS', $goodsClassifys) || count($goodsClassifys) > 1) {
- return json_fail('餐饮餐品不支持和其他类型的产品一起下单');
- }
- Db::beginTransaction();
- try {
- $order = Order::where('order_id', $params['order_id'])->first();
- if ($order->order_status_payment == 'SUCCESS') {
- throw new BusinessException("订单已支付,无法加菜");
- }
- $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
- $sheet = OrderSheet::where('join_sheet_order_id', $params['order_id'])->orderBy('order_sheet_addtimes', 'DESC')->first();
- $sheetComponentJson = [];
- if (!empty($sheet->order_sheet_component_json)) {
- $sheetComponentJson = json_decode($sheet->order_sheet_component_json, true);
- }
- $sheetComponentJson['order_batch'] = date('YmdHis');
- foreach ($params['goodsContentList'] as $goods) {
- //{"unit": "份", "table": null, "premises": "15"}
- $price = floatval($goods['goods_sales_price']);
- $orderSheetPricePay = round(($order->order_amount_pay / $order->order_amount_total) * $price, 2);
- $data = [
- 'join_sheet_member_id' => $order->join_order_member_id,
- 'join_sheet_order_id' => $params['order_id'],
- 'join_sheet_goods_id' => $goods['goods_id'],
- 'join_sheet_goods_sku_id' => $goods['sku_id'],
- 'order_sheet_status' => 'PAYING',
- 'order_sheet_category' => 'DISHES',
- 'order_sheet_num' => $goods['nbr'],
- 'order_sheet_price' => $goods['goods_sales_price'],
- 'order_sheet_price_pay' => $orderSheetPricePay,
- 'order_sheet_amount' => $price * $goods['nbr'],
- 'order_sheet_pay' => $orderSheetPricePay * $goods['nbr'],
- 'order_sheet_task_status' => 'NONE',
- 'order_sheet_remark' => $params['order_remark'] ?? '',
- 'order_sheet_component_json' => json_encode($sheetComponentJson),
- 'order_sheet_addtimes' => time(),
- 'order_sheet_extend_json' => $sheet->order_sheet_extend_json ?? '[]'
- ];
- if ($params['give'] == 1) {
- $data['order_sheet_status'] = 'FREE';
- $data['order_sheet_amount'] = 0;
- $data['order_sheet_pay'] = 0;
- }
- $order->order_amount_total = $order->order_amount_total + $data['order_sheet_amount'];
- $order->order_amount_pay = $order->order_amount_pay + $data['order_sheet_pay'];
- if ($payDetail) {
- $payDetail->pay_amount = $payDetail->pay_amount + $data['order_sheet_pay'];
- }
- // 减总库存
- $goodsRunning = GoodsRunning::where('join_running_goods_id', $goods['goods_id'])->first();
- $goodsRunning->goods_running_storage = $goodsRunning->goods_running_storage - $goods['nbr'];
- if ($goodsRunning->goods_running_storage < 0) {
- throw new BusinessException('库存不足');
- }
- // $goodsRunning->goods_running_sale = $goodsRunning->goods_running_sale + $goods['nbr'];
- $goodsRunning->save();
- OrderSheet::insertGetId($data);
- }
- $order->save();
- if ($payDetail) {
- $payDetail->save();
- }
- Db::commit();
- // 打小票
- $restaurant = SysDept::where('dept_name', $params['dept_premises_id'])->where('dept_category', '餐厅')->where('dept_status', 'ACTIVED')->first();
- if (!empty($restaurant) && !empty($restaurant->dept_extend_json)) {
- $deptExtendJson = json_decode($restaurant->dept_extend_json, true);
- if (isset($deptExtendJson['printer'])) {
- foreach ($deptExtendJson['printer'] as $key => $item) {
- if ((strpos($key, '前台') !== false || strpos($key, '后厨') !== false)) {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $key
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $params['order_id'],
- 'order_batch' => $sheetComponentJson['order_batch']
- ]
- ]
- ];
- $result = json_decode(http_post_json(getenv('VOTE_MENU_URL'), $voteData), true);
- if ($result['success'] == false) {
- // throw new BusinessException("加菜成功,小票打印失败,请在订单中心手动打印");
- }
- }
- }
- }
- }
- return json_success('加菜成功');
- } catch (BusinessException $e) {
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- return json_fail('加菜失败');
- }
- }
- /**
- * 减菜
- */
- public function cutMeals(Request $request)
- {
- $sheetId = $request->post('sheet_id', '');
- $sheet = OrderSheet::where('order_sheet_id', $sheetId)->first();
- if (!$sheet) {
- return json_fail("参数异常");
- }
- if (OrderSheet::where('join_sheet_order_id', $sheet->join_sheet_order_id)->count() <= 1) {
- return json_fail("不能清空菜单");
- }
- Db::beginTransaction();
- try {
- $order = Order::where('order_id', $sheet->join_sheet_order_id)->first();
- $order->order_amount_total = $order->order_amount_total - $sheet->order_sheet_amount;
- $order->order_amount_pay = $order->order_amount_pay - $sheet->order_sheet_pay;
- $order->save();
- $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->first();
- if (!empty($payDetail)) {
- $payDetail->pay_amount = $payDetail->pay_amount - $sheet->order_sheet_pay;
- $payDetail->save();
- }
- // $sheet->order_sheet_num = 0;
- // $sheet->order_sheet_amount = 0;
- // $sheet->order_sheet_pay = 0;
- $sheet->delete();
- Db::commit();
- return json_success('success');
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail('减菜失败');
- }
- }
- /**
- * @Desc 发货
- * @Author Gorden
- * @Date 2024/7/16 8:43
- *
- * @param Request $request
- * @return Response
- */
- public function delivery(Request $request)
- {
- // 验证
- $validate = new OrderExpressValidate();
- if (!$validate->scene('delivery')->check($request->post())) {
- return json_fail($validate->getError());
- }
- $params = $request->post();
- $params['order_express_addtimes'] = !empty($params['order_express_addtimes']) ? strtotime($params['order_express_addtimes']) : time();
- Db::beginTransaction();
- try {
- $expressExtendJson = [];
- if ($params['express_type'] == '自提') {
- $model = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
- if (!$model) {
- $model = new OrderExpress();
- }
- if (!empty($model->order_express_extend_json)) {
- $expressExtendJson = json_decode($model->order_express_extend_json, true);
- // 如果有取件码
- if (isset($expressExtendJson['pick_code'])) {
- if (empty($params['order_express_pick_code']) || $params['order_express_pick_code'] != $expressExtendJson['pick_code']) {
- Db::rollBack();
- return json_fail("取件码错误");
- }
- }
- }
- $premises = SysDept::where('dept_name', $params['order_express_premises'])->first();
- if (!$premises) {
- return json_fail("门店不存在,请重新填写");
- }
- $params['order_express_company'] = $params['order_express_premises'];
- $params['order_express_city'] = str_replace(',', ' ', $premises->dept_city);
- $params['order_express_address'] = $premises->dept_address;
- $params['order_express_code'] = '';
- $orderData = [
- 'order_is_complete' => 'Y',
- 'order_status_system' => 'CONFIRM',
- 'order_status_storage' => 'DONE'
- ];
- $orderSheetData = [
- 'order_sheet_status' => 'CONFIRM'
- ];
- // 7天后自动完成
- // $redis = Redis::connection();
- // $key = Order::AUTOMATIC_COMPLETE_PREFIX . date('Ymd', strtotime("+7 days"));
- // $redis->sadd($key, $params['order_id']);
- // $model = new OrderExpress();
- } else {
- $orderData = [
- 'order_status_system' => 'RECVING',
- 'order_status_storage' => 'EXPRESSING'
- ];
- $orderSheetData = [
- 'order_sheet_status' => 'RECVING'
- ];
- // 15天后自动完成订单
- $redis = Redis::connection();
- $key = Order::AUTOMATIC_COMPLETE_PREFIX . date('Ymd', strtotime("+15 days"));
- $redis->sadd($key, $params['order_id']);
- $model = OrderExpress::where('join_express_order_id', $params['order_id'])->first();
- if (!$model) {
- $model = new OrderExpress();
- // $sheet = OrderSheet::where('join_sheet_order_id', $request->post('order_id'))
- // ->select('join_sheet_goods_id')
- // ->first();
- // if(!empty($sheet->order_sheet_extend_json)){
- // $extendJson = json_decode($sheet->order_sheet_extend_json,true);
- // $address = ClientConfig::where('client_config_id',$extendJson['address_id'])->first();
- // $params['']
- // }
- }
- }
- // 该订单状态
- $orderData['order_update_user_id'] = JwtToken::getCurrentId();
- $orderData['order_updatetimes'] = time();
- Order::where('order_id', $request->post('order_id'))->update($orderData);
- // 该订单Sheet状态
- OrderSheet::where('join_sheet_order_id', $request->post('order_id'))->update($orderSheetData);
- // 入配送记录表
- $model->join_express_order_id = $params['order_id'];
- if (isset($params['order_express_goods'])) {
- $model->order_express_goods = $params['order_express_goods'];
- }
- if (isset($params['order_express_company'])) {
- $model->order_express_company = $params['order_express_company'];
- }
- if (isset($params['order_express_code'])) {
- $model->order_express_code = $params['order_express_code'];
- }
- if (isset($params['order_express_city'])) {
- $model->order_express_city = $params['order_express_city'];
- }
- if (isset($params['order_express_address'])) {
- $model->order_express_address = $params['order_express_address'];
- }
- if (isset($params['order_express_mobile'])) {
- $model->order_express_mobile = $params['order_express_mobile'];
- }
- if (isset($params['order_express_telephone'])) {
- $model->order_express_telephone = $params['order_express_telephone'];
- }
- if (isset($params['order_express_person'])) {
- $model->order_express_person = $params['order_express_person'];
- }
- if (isset($params['dept_premises_id'])) {
- $model->join_express_dept_id = $params['dept_premises_id'];
- }
- if (!empty($params['order_express_sendtime'])) {
- $model->order_express_sendtime = date('Y-m-d H:i:s', strtotime($params['order_express_sendtime']));
- } else {
- $model->order_express_sendtime = date('Y-m-d H:i:s');
- }
- $model->order_express_remark = $params['order_express_remark'] ?? null;
- $model->order_express_addtimes = $params['order_express_addtimes'] ?? time();
- $expressExtendJson['delivery_time'] = date('Y-m-d H:i:s');
- $model->order_express_extend_json = json_encode($expressExtendJson);
- $model->save();
- // 事件通知
- Event::dispatch('client_message.delivery', $params);
- if ($params['express_type'] == '自提') {
- $order = Order::where('order_id', $request->post('order_id'))->select('join_order_member_id')->first();
- if (!empty($order)) {
- // Event::dispatch('order_pay.member_level.up', $order->join_order_member_id);
- }
- }
- Db::commit();
- _syslog("订单", "发货成功");
- return json_success('发货成功');
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- _syslog("订单", "发货失败");
- return json_fail('发货失败');
- }
- }
- public function writeOff(Request $request)
- {
- $memberId = $request->post('member_id', '');
- $benefitId = $request->post('benefit_id', '');
- $nbr = $request->post('nbr');
- $times = $request->post('times', '');
- $code = $request->post('sms_code', '');
- if (!$memberId || !$benefitId) {
- return json_fail('参数异常');
- }
- $member = Member::find($memberId);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:QUOTA:" . $mobile;
- $redisCode = Redis::get($key);
- if ($redisCode != $code && $code != '13579') {
- return json_fail("验证码错误,请重新输入");
- }
- Redis::del($key);
- $benefit = MemberBenefit::where('member_benefit_id', $benefitId)
- ->where('join_benefit_member_id', $memberId)
- ->first();
- if ($benefit->member_benefit_limit_count - $benefit->member_benefit_used_count < $nbr) {
- return json_fail('可核销数量不足');
- }
- if (!$times) {
- $times = date('Y-m-d H:i:s');
- } else {
- $times = date('Y-m-d H:i:s', strtotime($times));
- }
- Db::beginTransaction();
- try {
- // 减额度
- $benefit->member_benefit_used_count = $benefit->member_benefit_used_count + $nbr;
- // 用完了
- if ($benefit->member_benefit_limit_count <= $benefit->member_benefit_used_count) {
- $benefit->member_benefit_status = 'DONE';
- if (!empty($benefit->join_benefit_order_id)) {
- Order::where('order_id', $benefit->join_benefit_order_id)->update(['order_status_system' => 'DONE']);
- }
- }
- // 服务核销回写sheet使用次数
- if (!empty($benefit->join_benefit_goods_id) && !empty($benefit->join_benefit_order_id)) {
- OrderSheet::where('join_sheet_goods_id', $benefit->join_benefit_goods_id)
- ->where('join_sheet_order_id', $benefit->join_benefit_order_id)
- ->update(['order_sheet_used_num' => $benefit->member_benefit_used_count]);
- }
- $benefit->save();
- // 记录核销
- $params = [
- 'dept_premises_id' => $request->post('dept_premises_id'),
- 'order_remark' => $request->post('remark'),
- 'write_off_member_id' => $request->post('write_off_member_id'),
- 'join_order_member_id' => $memberId
- ];
- $writeOffData = OrderService::generateWriteOffData($params);
- $appointments = Appointment::where('join_appointment_member_benefit_id', $benefitId)
- ->where('appointment_status', 'INIT')
- ->limit($nbr)
- ->get();
- $appointmentIds = [];
- foreach ($appointments as $appointment) {
- $appointmentIds[] = $appointment->appointment_id;
- Appointment::where('appointment_id', $appointment->appointment_id)->update([
- 'appointment_status' => 'DONE',
- 'appointment_datetime' => $times,
- 'appointment_apply_datetime' => $times,
- 'appointment_doing_datetime' => $times,
- 'appointment_done_datetime' => $times,
- 'appointment_done_json' => json_encode($writeOffData)
- ]);
- }
- // 核销服务回写process
- if (!empty($benefit->join_benefit_goods_id) && !empty($benefit->join_benefit_order_id)) {
- $dept = [];
- if (!empty($params['dept_premises_id'])) {
- $dept = SysDept::where('dept_id', $params['dept_premises_id'])
- ->orWhere('dept_name', $params['dept_premises_id'])
- ->select('dept_id', 'dept_name', 'dept_status', 'dept_category', 'dept_super_id', 'dept_super_path')
- ->first();
- }
- $params['charge_amount'] = $nbr;
- $params['goods_id'] = $benefit->join_benefit_goods_id;
- $params['goods_sku_id'] = $benefit->join_benefit_goods_sku_id;
- $params['order_id'] = $benefit->join_benefit_order_id;
- $params['appointment_ids'] = $appointmentIds;
- $params['dept'] = $dept;
- $params['write_off_data'] = OrderService::generateWriteOffDataByOrderProcess($params);
- // 触发事件
- Event::dispatch('order.write_off', $params);
- }
- Db::commit();
- _syslog("订单", "核销成功");
- return json_success('核销成功');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- _syslog("订单", "核销失败");
- return json_fail('核销失败');
- }
- }
- /**
- * 核销餐饮
- */
- public function writeOffDishes(Request $request)
- {
- $orderId = $request->post('order_id', '');
- $memberId = $request->post('member_id', '');
- $times = $request->post('times', '');
- $code = $request->post('sms_code', '');
- if (!$memberId || !$orderId) {
- return json_fail('参数异常');
- }
- $member = Member::find($memberId);
- $mobile = $member->member_mobile;
- $key = "SMS:CODE:DISHES:" . $mobile;
- $redisCode = Redis::get($key);
- if ($code == '' || $redisCode != $code) {
- return json_fail("验证码错误,请重新输入");
- }
- Redis::del($key);
- if (!$times) {
- $times = date('Y-m-d H:i:s');
- } else {
- $times = date('Y-m-d H:i:s', strtotime($times));
- }
- try {
- Db::beginTransaction();
- // 记录核销
- $params = [
- 'dept_premises_id' => $request->post('dept_premises_id'),
- 'order_remark' => $request->post('remark'),
- 'write_off_member_id' => $request->post('write_off_member_id'),
- 'join_order_member_id' => $memberId
- ];
- $writeOffData['charge'] = OrderService::generateWriteOffData($params);
- $writeOffData['charge']['order_id'] = $orderId;
- $writeOffData['charge']['member_id'] = $memberId;
- $writeOffData['charge']['order_code'] = random_string(10, 'number');
- $writeOffData['express'] = 'N';
- $order = Order::where('order_id', $orderId)->first();
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (isset($orderConfigJson['tableid']) && !empty($orderConfigJson['tableid'])) {
- SysDept::where('dept_id', $orderConfigJson['tableid'])->where('dept_category', '桌台')->update(['dept_status' => 'ACTIVED']);
- }
- }
- Order::where('order_id', $orderId)->update([
- 'order_express_json' => json_encode($writeOffData),
- 'order_is_complete' => 'Y',
- 'order_status_system' => 'DONE'
- ]);
- OrderSheet::where('join_sheet_order_id', $orderId)->update([
- 'order_sheet_status' => 'DONE'
- ]);
- Db::commit();
- _syslog("订单", "核销餐品成功");
- return json_success('核销成功');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- _syslog("订单", "核销餐品失败");
- return json_fail('核销失败');
- }
- }
- public function writeOffBenefit(Request $request)
- {
- $memberId = $request->post('member_id', '');
- $benefitList = $request->post('benefitList', []);
- $times = $request->post('times', '');
- $code = $request->post('sms_code', '');
- if (!$memberId || empty($benefitList)) {
- return json_fail('参数异常');
- }
- if (empty($code)) {
- return json_fail('请输入验证码');
- }
- $benefitIds = [];
- foreach ($benefitList as $benefit) {
- if (isset($benefit['nbr']) && intval($benefit['nbr']) > 0) {
- $benefitIds[] = $benefit['member_benefit_id'];
- }
- }
- if (empty($benefitIds)) {
- return json_fail("请填写有效的核销数量");
- }
- $member = Member::find($memberId);
- // $mobile = $member->member_mobile;
- // $key = "SMS:CODE:WRITE_OFF:" . $mobile;
- // $redisCode = Redis::get($key);
- // if ($redisCode != $code) {
- // return json_fail("验证码错误,请重新输入");
- // }
- $benefits = MemberBenefit::whereIn('member_benefit_id', $benefitIds)
- ->where('join_benefit_member_id', $memberId)
- ->get()
- ->toArray();
- foreach ($benefits as $benefit) {
- foreach ($benefitList as $list) {
- if ($list['member_benefit_id'] == $benefit['member_benefit_id'] && intval($list['nbr'] > ($benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count']))) {
- return json_fail('可核销数量不足');
- }
- }
- }
- if (!$times) {
- $times = date('Y-m-d H:i:s');
- } else {
- $times = date('Y-m-d H:i:s', strtotime($times));
- }
- try {
- Db::beginTransaction();
- // 核销数据
- $params = [
- 'dept_premises_id' => $request->post('dept_premises_id'),
- 'order_remark' => $request->post('remark'),
- 'write_off_member_id' => $request->post('write_off_member_id'),
- 'join_order_member_id' => $memberId,
- 'charge_waiter' => $request->post('charge_waiter'),
- ];
- $writeOffData = OrderService::generateWriteOffData($params);
- $dept = [];
- if (!empty($params['dept_premises_id'])) {
- $dept = SysDept::where('dept_id', $params['dept_premises_id'])
- ->orWhere('dept_name', $params['dept_premises_id'])
- ->select('dept_id', 'dept_name', 'dept_status', 'dept_category', 'dept_super_id', 'dept_super_path')
- ->first();
- }
- // 开始减额度
- $benefitUsed = [];
- $appointmentIds = [];
- foreach ($benefits as $benefit) {
- foreach ($benefitList as $list) {
- if ($list['member_benefit_id'] == $benefit['member_benefit_id']) {
- $usedCount = $benefit['member_benefit_used_count'] + intval($list['nbr']);
- $benefitUpdateData = ['member_benefit_used_count' => $usedCount];
- // 用完了
- if ($benefit['member_benefit_limit_count'] <= $usedCount && !empty($benefit['join_benefit_order_id'])) {
- $benefitUpdateData['member_benefit_status'] = 'DONE';
- $benefitUsed[$benefit['join_benefit_order_id']][] = $benefit['member_benefit_id'];
- // Order::where('order_id', $benefit['join_benefit_order_id'])->update(['order_status_system' => 'DONE']);
- }
- // 更新benefit 表
- MemberBenefit::where('member_benefit_id', $benefit['member_benefit_id'])->update($benefitUpdateData);
- // 更新Appointment 表
- $appointments = Appointment::where('join_appointment_member_benefit_id', $benefit['member_benefit_id'])
- ->where('appointment_status', 'INIT')
- ->limit(intval($list['nbr']))
- ->get();
- foreach ($appointments as $appointment) {
- $appointmentIds[] = $appointment->appointment_id;
- Appointment::where('appointment_id', $appointment->appointment_id)->update([
- 'appointment_status' => 'DONE',
- 'appointment_datetime' => $times,
- 'appointment_apply_datetime' => $times,
- 'appointment_doing_datetime' => $times,
- 'appointment_done_datetime' => $times,
- 'appointment_done_json' => json_encode($writeOffData)
- ]);
- }
- }
- }
- }
- // 订单服务是否用完了
- foreach ($benefitUsed as $key => $item) {
- $orderUsedComplete = 'Y';
- $orderBenefits = MemberBenefit::where('join_benefit_order_id', $key)->get()->toArray();
- foreach ($orderBenefits as $orderBenefit) {
- if ($orderBenefit['member_benefit_used_count'] >= $orderBenefit['member_benefit_limit_count']) {
- continue;
- }
- if (!in_array($orderBenefit['member_benefit_id'], $item)) {
- $orderUsedComplete = 'N';
- }
- }
- if ($orderUsedComplete == 'Y') {
- Order::where('order_id', $key)->update(['order_is_complete' => 'Y', 'order_status_system' => 'DONE']);
- $processParams = [
- 'join_order_member_id' => $params['join_order_member_id'],
- 'orderId' => $key,
- 'submit_premises_id' => $dept['dept_id'] ?? 0,
- ];
- Event::dispatch('order.complete', $processParams);
- }
- }
- // 核销服务回写process
- foreach ($benefits as $benefit) {
- foreach ($benefitList as $list) {
- 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'])) {
- $params['charge_amount'] = $list['nbr'];
- $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'] : '');
- $params['goods_sku_id'] = $benefit['join_benefit_goods_sku_id'];
- $params['order_id'] = $benefit['join_benefit_order_id'];
- $params['appointment_ids'] = $appointmentIds;
- $params['dept'] = $dept;
- $params['write_off_data'] = OrderService::generateWriteOffDataByOrderProcess($params);
- // 触发事件
- Event::dispatch('order.write_off', $params);
- }
- }
- // 写核销人
- Order::where('order_id', $benefit['join_benefit_order_id'])->update([
- 'order_update_user_id' => JwtToken::getCurrentId(),
- 'order_updatetimes' => time()
- ]);
- }
- // Redis::del($key);
- Db::commit();
- _syslog("订单", "核销成功");
- return json_success('核销成功');
- } catch (\Exception $e) {
- unset($appointmentIds);
- Log::error('核销失败', ['msg' => $e->getMessage()]);
- Db::rollBack();
- _syslog("订单", "核销失败");
- return json_fail('核销失败');
- } finally {
- if (!empty($appointmentIds)) {
- // 打印核销小票
- foreach ($appointmentIds as $id) {
- $this->doPrinterWriterOff($id);
- }
- }
- }
- }
- public function myOrder(Request $request)
- {
- $page = $request->get('page', 1);
- $pageSize = $request->get('pageSize', 1);
- $datetime = $request->get('order_addtimes', []);
- $goodsName = $request->get('goods_name', '');
- $memberId = $request->get('member_id', '');
- if (!$memberId) {
- return json_fail('查询错误');
- }
- $sheetOrderIds = [];
- if (!empty($goodsName)) {
- $goodsIds = Goods::where('goods_name', 'like', '%' . $goodsName . '%')->pluck('goods_id')->toArray();
- $sheetOrderIds = OrderSheet::whereIn('join_sheet_goods_id', $goodsIds)
- ->where('join_sheet_member_id', $memberId)
- ->pluck('join_sheet_order_id')
- ->toArray();
- }
- $order = Order::with([
- 'return' => function ($query) {
- $query->select('join_return_order_id', 'orders_return_id', 'order_return_status');
- },
- 'sheets',
- 'express' => function ($query) {
- $query->select('join_express_order_id', 'order_express_type');
- }
- ])
- ->where('join_order_member_id', $memberId)
- ->where('order_classify', '<>', 'RECHARGE')
- ->when(!empty($datetime), function ($query) use ($datetime) {
- $datetime[0] = strtotime($datetime[0]);
- $datetime[1] = strtotime($datetime[1]);
- $query->whereBetween('order_addtimes', $datetime);
- })
- ->when(!empty($sheetOrderIds), function ($query) use ($sheetOrderIds) {
- $query->whereIn('order_id', $sheetOrderIds);
- });
- $total = $order->count();
- $rows = $order
- ->orderBy('order_addtimes', 'desc')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- foreach ($rows as &$item) {
- $sheetGoodsIds = array_column($item['sheets'], 'join_sheet_goods_id');
- $goods = Goods::whereIn('goods_id', $sheetGoodsIds)->select('goods_id', 'goods_name')->get()->toArray();
- if (count($goods) > 1) {
- $item['goods_name'] = $goods[0]['goods_name'] . ' 等';
- } else {
- $item['goods_name'] = $goods[0]['goods_name'];
- }
- // $item['goods_name'] = !empty($goods->goods_name) ? $goods->goods_name : '';
- // if (!empty($item->goods->goods_cover)) {
- // $item->goods->goods_cover = getenv('STORAGE_DOMAIN') . $item->goods->goods_cover;
- // }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total'));
- }
- public function saveExpress($params)
- {
- try {
- $express = new OrderExpress();
- $express->order_express_type = $params['order_express_type'];
- $express->join_express_order_id = $params['orderId'];
- $express->join_express_dept_id = $params['submit_premises_id'] ?? 0;
- $express->order_express_goods = $params['order_express_goods'];
- $express->order_express_city = $params['order_express_city'];
- $express->order_express_address = $params['order_express_address'];
- $express->order_express_mobile = $params['order_express_mobile'] ?? '';
- $express->order_express_telephone = $params['order_express_telephone'] ?? '';
- $express->order_express_person = $params['order_express_person'] ?? '';
- $express->order_express_company = $params['dept_premises_id'] ?? '';
- $express->order_express_extend_json = $params['order_express_extend_json'] ?? '[]';
- $express->order_express_addtimes = time();
- $express->save();
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('物流信息保存失败');
- }
- }
- // TODO 确认收货(完成订单)
- // public function confirm($id)
- // {
- // $order = Order::where('order_id', $id)->first();
- // if (empty($order)) {
- // return json_fail("暂无数据");
- // }
- //
- // Db::beginTransaction();
- // try {
- // // 主订单
- // Order::where('order_id', $id)->update(['order_status_system' => 'CONFIRM']);
- // } catch (\Exception $e) {
- //
- // }
- // }
- /**
- * @Desc 退款
- * @Author Gorden
- * @Date 2024/7/8 8:40
- *
- * @param Request $request
- * @return Response
- */
- public function doRefund(Request $request)
- {
- $orderId = $request->post('order_id', '');
- $amount = $request->post('refund_amount', 0);
- $password = $request->post('refund_password', '');
- if (!$orderId || !$amount || !$password) {
- return json_fail('参数异常');
- }
- if ($password != '123456') {
- return json_fail('支付密码错误');
- }
- $return = OrderReturn::where('join_return_order_id', $orderId)
- ->first();
- if (!$return) {
- return json_fail("退款订单异常");
- }
- $order = Order::where('order_id', $return->join_return_order_id)->first();
- if (!$order) {
- return json_fail("订单异常");
- }
- if ($order->order_is_complete == 'Y' || $order->order_is_complete == 'R') {
- return json_fail('订单已完成,无法退款');
- }
- if ($amount > $order->order_amount_pay) {
- return json_fail('退款金额不能超过订单金额');
- }
- $payDetail = PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_status', 'SUCCESS')->first();
- if (!$payDetail) {
- return json_fail("支付信息异常异常");
- }
- // 在线支付返回
- $payJsonResponse = [];
- if (!empty($payDetail->pay_json_response)) {
- $payJsonResponse = json_decode($payDetail->pay_json_response, true);
- }
- $res = '[]';
- $data = '[]';
- try {
- Db::beginTransaction();
- // 订单主表
- Order::where('order_id', $return->join_return_order_id)->update(['order_is_complete' => 'R']);
- // 订单详情
- OrderSheet::where('join_sheet_order_id', $return->join_return_order_id)->update(['order_sheet_status' => 'RETURNED']);
- // return 表
- $return->order_return_status = 'DONE';
- $return->order_return_refund_json = json_encode(['amount' => $amount, 'datetime' => date('Y-m-d H:i:s'), 'user_id' => JwtToken::getCurrentId()]);
- $return->save();
- $payType = explode('-', $payDetail->pay_prepayid);
- // 区分账户余额支付和在线支付
- if ($payDetail->pay_prepayid == 'WXPAY') {
- // 退款
- $data = [
- 'type' => 'app',
- 'out_trade_no' => $order->order_groupby,
- 'out_refund_no' => $return->orders_return_id,
- 'total_fee' => $payDetail->pay_amount * 100,
- 'refund_fee' => $amount * 100,
- 'refund_desc' => '退款',
- ];
- $res = Pay::wechat(config('payment.wxpay'))->refund($data);
- $resArray = json_decode($res, true);
- if (!$resArray['result_code'] == 'SUCCESS' || !$resArray['return_code'] == 'SUCCESS') {
- throw new PayException("退款失败");
- }
- } else if ($payDetail->pay_prepayid == 'ALIPAY') {
- // 退款
- $data = [
- 'out_trade_no' => $order->order_groupby,
- 'refund_amount' => $amount,
- ];
- $res = Pay::alipay(config('payment.alipay'))->refund($data);
- $resArray = json_decode($res, true);
- if ($resArray['fund_change'] != 'Y' || $resArray['msg'] != 'Success') {
- throw new PayException("退款失败");
- }
- } else if (isset($payType[1]) && $payType[1] == 'CASH') { // 余额支付
- $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
- ->where('member_account_classify', 'CASH')
- ->first();
- $account->member_account_expend = $account->member_account_expend - $amount;
- $account->member_account_surplus = $account->member_account_surplus + $amount;
- $account->save();
- $data = [
- 'type' => 'REFUND',
- 'member_id' => $order->join_order_member_id,
- 'order_id' => $return->join_return_order_id,
- 'return_id' => $return->orders_return_id
- ];
- $res = json_encode([
- 'status' => 'SUCCESS'
- ]);
- } else if (isset($payType[1]) && $payType[1] == 'WELFARE') { // 员工福利支付
- $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
- ->where('member_account_classify', 'WELFARE')
- ->first();
- $account->member_account_expend = $account->member_account_expend - $amount;
- $account->member_account_surplus = $account->member_account_surplus + $amount;
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- $data = [
- 'type' => 'REFUND',
- 'member_id' => $order->join_order_member_id,
- 'order_id' => $return->join_return_order_id,
- 'return_id' => $return->orders_return_id
- ];
- $res = json_encode([
- 'status' => 'SUCCESS'
- ]);
- } else if (count($payType) == 1 && !in_array($payDetail->pay_prepayid, ['W06', 'A01'])) { // 卡支付
- $account = MemberAccount::where('join_account_member_id', $order->join_order_member_id)
- ->where('member_account_nbr', $payType[0])
- ->where('member_account_classify', 'CARD')
- ->first();
- $account->member_account_expend = $account->member_account_expend - $amount;
- $account->member_account_surplus = $account->member_account_surplus + $amount;
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- $data = [
- 'type' => 'REFUND',
- 'nbr' => $account->member_account_nbr,
- 'member_id' => $order->join_order_member_id,
- 'order_id' => $return->join_return_order_id,
- 'return_id' => $return->orders_return_id
- ];
- $res = json_encode([
- 'status' => 'SUCCESS'
- ]);
- }
- // 生成payDetail
- $payDetailData = [
- 'join_pay_member_id' => $order->join_order_member_id,
- 'join_pay_order_id' => $order->order_groupby,
- 'pay_status' => 'SUCCESS',
- 'pay_category' => 'REFUND',
- 'pay_amount' => $amount,
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_json_request' => json_encode($data),
- 'pay_json_response' => $res,
- 'pay_prepayid' => $payType[0] . (!empty($payType[1]) ? '-' . $payType[1] : ''),
- 'pay_addtimes' => time()
- ];
- PayDetail::insert($payDetailData);
- Db::commit();
- // 事件通知
- Event::dispatch('client_message.refund', $order->join_order_member_id);
- _syslog("退款", "发起退款", json_decode($res), $data);
- return json_success("退款成功");
- } catch (PayException $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("退款", "发起退款", $e->getMessage(), $data);
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- dump($e->getTrace());
- _syslog("退款", "发起退款", $e->getMessage(), $data);
- if (strpos($e->getMessage(), '余额不足') !== false) {
- return json_fail("基本账户余额不足,请充值后重新发起");
- }
- return json_fail("数据更新失败");
- }
- }
- public function exportOrder(Request $request)
- {
- $timeType = $request->get('time_type', 'add');
- $type = $request->get('type', '');
- [$where, $format, $limit, $field, $order] = $this->selectInput($request);
- $orderClassify = [];
- if ($request->get('goods_classify') && $request->get('goods_classify') == 'SERVICE') {
- $orderClassify = ['SERVICE', 'CHNMED', 'CHNNCD'];
- $where['order_classify'] = ['in', 'SERVICE,CHNMED,CHNNCD'];
- } else if ($request->get('goods_classify') && $request->get('goods_classify') == 'DISHES') {
- $orderClassify = ['MEALS'];
- $where['order_classify'] = $request->get('goods_classify');
- } else if ($request->get('goods_classify')) {
- $orderClassify = [$request->get('goods_classify')];
- $where['order_classify'] = $request->get('goods_classify');
- }
- if (!empty($request->get('order_ids'))) {
- $where['order_id'] = ['in', $request->get('order_ids')];
- }
- if (!empty($where['order_addtimes']) && $timeType == 'add') {
- $where['order_addtimes'][0] = strtotime($where['order_addtimes'][0]);
- $where['order_addtimes'][1] = strtotime($where['order_addtimes'][1]);
- }
- if ($type == 'todayOrder' && empty($where['order_addtimes'])) {
- $where['order_addtimes'][0] = strtotime(date('Y-m-d') . ' 00:00:00');
- $where['order_addtimes'][1] = strtotime(date('Y-m-d') . ' 23:59:59');
- } else if ($type == 'todayOrderAmount') {
- $todayTimeUnix = strtotime(date('Y-m-d') . ' 00:00:00');
- $groupIds = PayDetail::whereRaw('CAST(UNIX_TIMESTAMP(pay_paytimes) as SIGNED) > ? ', [$todayTimeUnix])
- ->where('join_pay_order_id', '<>', '')
- ->where('pay_prepayid', '<>', '')
- ->where('pay_category', '<>', 'RETURN')
- ->where('pay_category', '<>', 'RECHARGE')
- ->where('pay_category', '<>', 'CLEAR')
- ->pluck('join_pay_order_id')
- ->toArray();
- $where['order_groupby'] = ['in', $groupIds];
- }
- $orderId = trim($request->get('order_id'));
- $orderIds = [];
- if (!empty($orderId)) {
- $orderIds = Order::where('order_id', 'like', '%' . $orderId . '%')
- ->pluck('order_id')
- ->toArray();
- }
- $goodsName = trim($request->get('goods_name', ''));
- if (!empty($goodsName)) {
- $goodsIds = Goods::where('goods_name', 'like', '%' . $goodsName . '%')
- ->pluck('goods_id')
- ->toArray();
- $goodsOrderIds = OrderSheet::whereIn('join_sheet_goods_id', $goodsIds)->pluck('join_sheet_order_id')->toArray();
- if (!empty($where['order_id'])) {
- $orderIds = array_intersect($orderIds, $goodsOrderIds);
- } else {
- $orderIds = $goodsOrderIds;
- }
- }
- // 付款时间
- if ($timeType == 'pay' && !empty($where['order_addtimes'])) {
- $payTimeStart = strtotime($where['order_addtimes'][0]);
- $payTimeEnd = strtotime($where['order_addtimes'][1]);
- unset($where['order_addtimes']);
- $payOrderIds = PayDetailService::getPayOrderId($payTimeStart, $payTimeEnd, $orderClassify);
- }
- if (!empty($orderId) && !empty($payOrderIds)) {
- $orderIds = array_intersect($orderIds, $payOrderIds);
- $where['order_id'] = ['in', implode(',', $orderIds)];
- } elseif (!empty($orderId)) {
- $where['order_id'] = ['in', implode(',', $orderIds)];
- } elseif (!empty($payOrderIds)) {
- $where['order_id'] = ['in', implode(',', $payOrderIds)];
- }
- $order = $request->get('order', 'desc');
- $field = $field ?? 'order_addtimes';
- if (!empty($where['order_status_system']) && in_array($where['order_status_system'], ['PENDING', 'WAITING', 'SENDING', 'RECVING', 'SIGNED', 'CONFIRM'])) {
- $where['order_is_complete'] = 'N';
- }
- if (!empty($where['order_status_system']) && $where['order_status_system'] == 'RETURN') {
- unset($where['order_status_system']);
- unset($where['order_is_complete']);
- $where['order_category'] = 'RETURN';
- }
- // 自提订单
- if (!empty($where['order_status_system']) && $where['order_status_system'] == 'PICKUP') {
- $where['order_is_complete'] = 'N';
- $where['order_status_system'] = 'SENDING';
- $where['order_express.order_express_type'] = '自提';
- }
- $query = $this->doSelect($where, $field, $order);
- return $this->exportDoFormat($query, $format, 10000);
- }
- /**
- * 执行真正查询,并返回格式化数据
- * @param $query
- * @param $format
- * @param $limit
- * @return Response
- */
- protected function exportDoFormat($query, $format, $limit): Response
- {
- $methods = [
- 'select' => 'formatSelect',
- 'tree' => 'formatTree',
- 'table_tree' => 'formatTableTree',
- 'normal' => 'formatNormal',
- ];
- $paginator = $query->paginate($limit);
- $total = $paginator->total();
- $items = $paginator->items();
- $items = call_user_func([$this, "exportAfterQuery"], $items);
- $format_function = $methods[$format] ?? 'formatNormal';
- return call_user_func([$this, $format_function], $items, $total);
- }
- protected function exportAfterQuery($items)
- {
- $data = [];
- foreach ($items as $key => $item) {
- $goodsClassify = '';
- $goodsName = '--';
- if (!empty($item['sheet'])) {
- $goods = Goods::where('goods_id', $item['sheet']['join_sheet_goods_id'])->first();
- $goodsClassify = $goods->goods_classify ?? '';
- $goodsName = $goods->goods_name ?? '--';
- }
- $systemStatus = '';
- if ($item['order_is_complete'] == 'Y') {
- $systemStatus = '已完成';
- } elseif ($item['order_is_complete'] == 'R') {
- $systemStatus = '售后已完成';
- }
- // order_return_refund_json
- // dump($item);
- if (!empty($item['order_return_status']) && $item['order_return_status'] == 'PENDING') {
- $systemStatus = '售后待处理';
- } elseif (!empty($item['order_return_status']) && $item['order_return_status'] == 'DOING') {
- $systemStatus = '退款中';
- } elseif (!empty($item['order_return_status']) && $item['order_return_status'] == 'DONE') {
- $systemStatus = '退款完成';
- if (!empty($item['order_return_refund_json'])) {
- $refundJson = json_decode($item['order_return_refund_json'], true);
- if (isset($refundJson['amount']) && $refundJson['amount'] >= $item['order_amount_pay']) {
- $systemStatus .= "(全额)";
- } else {
- $systemStatus .= "(部分)";
- }
- }
- } elseif (!empty($item['order_return_status']) && $item['order_return_status'] == 'DISAGREE') {
- $systemStatus = '不同意退款';
- }
- $payDetails = PayDetail::where('join_pay_order_id', $item['order_groupby'])
- ->where(function ($query) use ($item) {
- $query->whereJsonContains('join_pay_object_json->order_id', $item['order_id'])->orWhere('join_pay_object_json', '')->orWhereNull('join_pay_object_json');
- })->where('pay_status', 'SUCCESS')
- ->where('pay_prepayid', '<>', '')
- ->where('pay_category', '<>', 'REFUND')
- ->get()
- ->toArray();
- if (count($payDetails) > 1) {
- $payWay = '组合支付';
- } elseif (count($payDetails) == 1) {
- $payWayEn = OrderService::getPayWayByPrepayId($payDetails[0]['pay_prepayid']);
- $payWay = '';
- if (!empty($payWayEn)) {
- $payWay = OrderService::$payWay[$payWayEn];
- }
- }
- if (count($payDetails) > 0) {
- $payDetail0 = $payDetails[0];
- $payTimes = $payDetail0['pay_paytimes'];
- }
- if (!empty($item['member']) && $item['member']['member_mobile'] == '0000') {
- $memberName = '散客';
- } else {
- $memberName = !empty($item['cert']) ? $item['cert']['member_cert_name'] : (!empty($item['member']) ? (substr($item['member']['member_mobile'], -4) . '会员' . '-') : '');
- if (!empty($item['member'])) {
- $memberName .= $item['member']['member_mobile'];
- }
- }
- if ($item['order_express_type'] == '自提' && $item['order_status_system'] == 'SENDING') {
- $item['order_status_system'] = 'PICKUP';
- }
- $data[$key] = [
- 'goods_classify' => !empty($goodsClassify) && isset(self::$goodsClassify[$goodsClassify]) ? self::$goodsClassify[$goodsClassify] : '其他订单',
- 'order_id' => $item['order_id'],
- 'group_id' => $item['order_groupby'],
- 'member' => $memberName,
- 'goods_name' => $goodsName,
- 'nbr' => !empty($item['sheet']) ? intval($item['sheet']['order_sheet_num']) : '--',
- 'order_amount_total' => $item['order_amount_total'],
- 'order_amount_pay' => $item['order_amount_pay'],
- 'order_status_system' => !empty($systemStatus) ? $systemStatus : self::$systemStatus[$item['order_status_system']],
- 'order_status_payment' => self::$paymentStatus[$item['order_status_payment']],
- 'pay_way' => $item['order_status_payment'] == 'SUCCESS' ? ($payWay ?? '') : '',
- 'pay_times' => $item['order_status_payment'] == 'SUCCESS' || $item['order_status_payment'] == 'FREE' ? ($payTimes ?? '') : '',
- 'order_addtimes' => date('Y-m-d H:i:s', strtotime($item['order_addtimes'])),
- ];
- }
- return $data;
- }
- public function benefitList(Request $request)
- {
- $orderIds = $request->get('order_ids', []);
- if (empty($orderIds)) {
- return json_fail("请选择需要核销的订单");
- }
- $orders = order::whereIn('order_id', $orderIds)
- ->with([
- 'benefit' => function ($query) {
- $query->select('join_benefit_order_id', 'member_benefit_id', 'member_benefit_name', 'member_benefit_limit_count', 'member_benefit_used_count');
- },
- 'member' => function ($query) {
- $query->select('member_id', 'member_mobile');
- },
- // 'sheets'=>function($query){
- // $query->select('join_sheet_order_id','join_sheet_goods_id');
- // }
- // 'goods'=>function($query){
- // $query->select('goods_id','goods_name');
- // }
- ])
- ->select('order_id', 'join_order_member_id', 'order_is_complete', 'order_status_system')
- ->where("order_is_complete", 'N')
- // ->whereIn("order_category", ['NORMAL', 'SYSTEM'])
- ->orderBy('order_addtimes', 'DESC')
- ->get()
- ->toArray();
- $memberId = array_unique(array_column($orders, 'join_order_member_id'));
- if (count($memberId) > 1) {
- return json_fail("不可同时核销多人订单");
- }
- $data = [];
- foreach ($orders as $order) {
- $orderOne = $order;
- foreach ($order['benefit'] as $benefit) {
- $benefit['member_benefit_limit_count'] = intval($benefit['member_benefit_limit_count']);
- $benefit['member_benefit_used_count'] = intval($benefit['member_benefit_used_count']);
- if ($benefit['member_benefit_used_count'] >= $benefit['member_benefit_limit_count']) {
- continue;
- }
- $benefit['unused'] = $benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count'];
- $orderOne['benefit'] = $benefit;
- $orderOne['member_benefit_id'] = $benefit['member_benefit_id'];
- $data[] = $orderOne;
- }
- }
- if (empty($data)) {
- return json_fail("您选择的产品没有可核销的服务");
- }
- return json_success('', $data);
- }
- public function chooseBenefitList(Request $request)
- {
- $benefitIds = $request->get('benefit_ids', []);
- $memberId = $request->get('member_id', []);
- if (empty($benefitIds)) {
- return json_fail('请选择需要核销的服务');
- }
- if (empty($memberId)) {
- return json_fail('没有会员信息,请联系管理员');
- }
- $benefits = MemberBenefit::whereIn('member_benefit_id', $benefitIds)
- ->where('member_benefit_status', 'ACTIVED')
- ->where('join_benefit_member_id', $memberId)
- ->select('join_benefit_order_id', 'member_benefit_id', 'member_benefit_name', 'member_benefit_limit_count', 'member_benefit_used_count')
- ->orderBy('member_benefit_addtimes', 'DESC')
- ->get()
- ->toArray();
- foreach ($benefits as &$benefit) {
- $benefit['member_benefit_limit_count'] = intval($benefit['member_benefit_limit_count']);
- $benefit['member_benefit_used_count'] = intval($benefit['member_benefit_used_count']);
- $benefit['unused'] = $benefit['member_benefit_limit_count'] - $benefit['member_benefit_used_count'];
- }
- $member = Member::where('member_id', $memberId)->select('member_id', 'member_mobile')->first()->toArray();
- return json_success('', ['benefits' => $benefits, 'member' => $member]);
- }
- public function customPrinter(Request $request)
- {
- $orderId = $request->post('order_id', '');
- $printer = $request->post('printer', []);
- $premiseName = $request->post('premise', '');
- if (empty($orderId) || empty($premiseName)) {
- return json_fail('参数异常');
- }
- if (empty($printer)) {
- return json_fail('请选择打印设备1');
- }
- $premises = SysDept::where('dept_name', $premiseName)->where('dept_category', '营业场所')->where('dept_status', 'ACTIVED')->first();
- $restaurant = SysDept::where('dept_name', $premiseName)->where('dept_category', '餐厅')->where('dept_status', 'ACTIVED')->first();
- $order = Order::where('order_id', $orderId)->first();
- try {
- foreach ($printer as $print) {
- if (strpos($print, '结算') !== false && $order->order_status_payment != 'SUCCESS') {
- return json_fail('无法打印未支付的结账单');
- }
- if (strpos($print, '收银') !== false && $order->order_status_payment != 'SUCCESS') {
- return json_fail('无法打印未支付的订单');
- }
- if (strpos($print, '核销') !== false && $order->order_status_payment != 'SUCCESS') {
- return json_fail('无法打印未支付的订单');
- }
- if (!empty($premises) || !empty($restaurant)) {
- if ($order->order_classify == 'DISHES' && empty($restaurant)) {
- $restaurant = SysDept::where('dept_super_id', $premises->dept_id)->where('dept_category', '餐厅')->first();
- } elseif ($order->order_classify != 'DISHES') {
- $restaurant = $premises;
- }
- if (!empty($restaurant->dept_extend_json)) {
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $restaurant->dept_id,
- 'printer_device' => [
- $print
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $orderId,
- 'order_batch' => ''
- ]
- ]
- ];
- if (strpos($print, '核销') !== false) {
- $voteData['data']['printer_data']['order_payoff'] = 'Y';
- }
- Log::info("开始自定义打印", $voteData);
- // dump("打印参数",$voteData);
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- }
- }
- return json_success('打印完成');
- } catch (\Exception $e) {
- dump($e->getMessage());
- return json_fail("存在错误,票据未全部打印");
- }
- }
- /**
- * @Desc 单打一条核销记录
- * @Author Gorden
- * @Date 2024/9/24 10:36
- *
- * @param Request $request
- * @return Response
- */
- public function printerWriterOff(Request $request)
- {
- $id = $request->post('id');
- if (!$id) {
- return json_fail('参数异常');
- }
- return $this->doPrinterWriterOff($id);
- }
- public function doPrinterWriterOff($id)
- {
- $payOff = OrderProcess::where('order_process_key', 'PAYOFF')
- ->where('order_process_json', 'like', '%' . $id . '%')
- ->first();
- if (!$payOff) {
- return json_fail('暂无数据');
- }
- try {
- if (!empty($payOff->order_process_json)) {
- $processJson = json_decode($payOff->order_process_json, true);
- $voteData = [
- 'func' => 'procActionToPrinter',
- 'sign' => '',
- 'data' => [
- 'printer_premises' => $processJson['charge']['charge_premises_info']['dept_id'],
- 'printer_device' => [
- '核销'
- ],
- 'printer_action' => 'ExecPrintOrder',
- 'printer_data' => [
- 'order_id' => $processJson['order_id'],
- 'order_payoff' => 'Y',
- 'order_payoff_id' => $payOff->orders_process_id,
- 'order_batch' => ''
- ]
- ]
- ];
- http_post_json(getenv('VOTE_MENU_URL'), $voteData);
- }
- return json_success('success');
- } catch (\Exception $e) {
- dump($e->getMessage());
- return json_fail('打印请求发送失败');
- }
- }
- /**
- * @Desc 查询订单状态
- * @Author Gorden
- * @Date 2024/8/19 11:55
- *
- * @param Request $request
- * @return Response|void
- */
- public function getOrderPayStatus(Request $request)
- {
- $orderId = $request->get('order_id', '');
- if (!$orderId) {
- return json_fail('订单不存在');
- }
- $order = Order::where('order_id', $orderId)->first();
- $oldOrderPaymentStatus = $order->order_status_payment;
- //order_status_payment
- if (!$order) {
- return json_fail('订单不存在');
- }
- $discountJson = [];
- if (!empty($order->order_discount_json)) {
- $discountJson = json_decode($order->order_discount_json, true);
- }
- if ($order->order_status_payment == 'SUCCESS') {
- return json_success('success');
- }
- $params['orderId'] = $orderId;
- $payDetailType = PayDetail::where('join_pay_order_id', $order->order_groupby)->pluck('pay_prepayid')->toArray();
- try {
- Db::beginTransaction();
- $full = '';
- if (in_array('WXPAY', $payDetailType)) {
- $result = Pay::wechat(config('payment.wxpay'))->find($order->order_groupby, 'pos');
- $result = json_decode(json_encode($result), true);
- // $result = '{"return_code":"SUCCESS","return_msg":"OK","result_code":"SUCCESS","mch_id":"1680393367","appid":"wxc6274da7198e3eb4","openid":"o3JAn6Ii_bAlxS-jbNEC4WnPhdwM","is_subscribe":"N","trade_type":"MICROPAY","trade_state":"SUCCESS","bank_type":"OTHERS","total_fee":"3","fee_type":"CNY","cash_fee":"1000","cash_fee_type":"CNY","transaction_id":"4200067718202409250802875650","out_trade_no":"OD24092518408RV7","attach":[],"time_end":"20240925184009","trade_state_desc":"支付成功","nonce_str":"OeGOkjch4eaV5qIt","sign":"6DCB3BFC594EBC018A2BEE2C3DFEA4E3"}';
- // $result = json_decode($result, true);
- 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') {
- $order->order_status_payment = 'SUCCESS';
- if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE'])) {
- $order->order_status_system = 'WAITING';
- } else if (in_array($order->order_category, ['DISHES', 'MEALS'])) {
- $order->order_is_complete = 'Y';
- $order->order_status_system = 'DONE';
- } else if (in_array($order->order_category, ['VIP', 'PARTNER'])) {
- $order->order_status_payment = 'PENDING';
- $totalFee = $result['total_fee'] / 100;
- $order->order_amount_paid = $order->order_amount_paid + $totalFee;
- $order->order_amount_pay = $order->order_amount_paid;
- if ($order->order_amount_paid >= $order->order_amount_total) {
- $full = '-满额';
- $order->order_status_payment = 'SUCCESS';
- $order->order_status_system = 'DONE';
- $order->order_is_complete = 'Y';
- }
- } else {
- $order->order_status_system = 'SENDING';
- }
- $order->save();
- // Sheet
- if ($order->order_status_payment == 'SUCCESS') {
- OrderSheet::where('join_sheet_order_id', $orderId)->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
- }
- // 支付记录
- PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_prepayid', 'WXPAY')->update([
- 'pay_status' => 'SUCCESS',
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_json_response' => json_encode($result)
- ]);
- // 加销售量
- OrderSheetService::addGoodsSales($params['orderId']);
- // 优惠券标记使用
- $this->changeOrderCouponStatus($discountJson, 'USED');
- Db::commit();
- if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE', 'GOODS', 'DISHES', 'MEALS'])) {
- // 给上级提成
- Event::dispatch('commission.order', $params);
- }
- // 收支明细
- $params['inout_category'] = $oldOrderPaymentStatus == 'AWAITING' ? '挂账订单结算' : ($order->order_classify == 'VIP' ? ('购买康养城VIP套餐包' . $full) : '餐饮订单');
- Event::dispatch('statistics.inout.in', $params);
- return json_success('success');
- }
- } else if (in_array('ALIPAY', $payDetailType)) {
- $result = Pay::alipay(config('payment.alipay'))->find($order->order_groupby);
- $result = json_decode(json_encode($result), true);
- // $result = '{"code":"10000","msg":"Success","buyer_logon_id":"138******93","buyer_pay_amount":"5.87","fund_bill_list":[{"amount":"5.69","fund_channel":"ALIPAYACCOUNT"},{"amount":"0.18","fund_channel":"COUPON"},{"amount":"0.13","fund_channel":"DISCOUNT"}],"invoice_amount":"5.69","out_trade_no":"OD2409251550Q07A","point_amount":"0.00","receipt_amount":"6.00","send_pay_date":"2024-09-25 15:50:22","total_amount":"6.00","trade_no":"2024092523001439431419750998","trade_status":"TRADE_SUCCESS","buyer_open_id":"04309N2aVhSZz4cKwN_DN2DQa7ekM3z5n8kscQHsmIZOJsf"}';
- // $result = json_decode($result, true);
- if (!empty($result['code']) && $result['code'] == '10000' && !empty($result['trade_status']) && $result['trade_status'] == 'TRADE_SUCCESS') {
- $order->order_status_payment = 'SUCCESS';
- if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE'])) {
- $order->order_status_system = 'WAITING';
- } elseif (in_array($order->order_category, ['DISHES', 'MEALS'])) {
- $order->order_is_complete = 'Y';
- $order->order_status_system = 'DONE';
- } else if (in_array($order->order_category, ['VIP', 'PARTNER'])) {
- $order->order_status_payment = 'PENDING';
- $order->order_amount_paid = $order->order_amount_paid + $result['total_amount'];
- $order->order_amount_pay = $order->order_amount_paid;
- if ($order->order_amount_paid >= $order->order_amount_total) {
- $full = '-满额';
- $order->order_status_system = 'DONE';
- $order->order_status_payment = 'SUCCESS';
- $order->order_is_complete = 'Y';
- }
- } else {
- $order->order_status_system = 'SENDING';
- }
- $order->save();
- // Sheet
- if ($order->order_status_payment == 'SUCCESS') {
- OrderSheet::where('join_sheet_order_id', $orderId)->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
- }
- // 支付记录
- PayDetail::where('join_pay_order_id', $order->order_groupby)->where('pay_prepayid', 'ALIPAY')->update([
- 'pay_status' => 'SUCCESS',
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_json_response' => json_encode($result)
- ]);
- // 加销售量
- OrderSheetService::addGoodsSales($params['orderId']);
- // 优惠券标记使用
- $this->changeOrderCouponStatus($discountJson, 'USED');
- Db::commit();
- if (in_array($order->order_category, ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE', 'GOODS', 'DISHES', 'MEALS'])) {
- // 给上级提成
- Event::dispatch('commission.order', $params);
- }
- // 收支明细
- $params['inout_category'] = $oldOrderPaymentStatus == 'AWAITING' ? '挂账订单结算' : ($order->order_classify == 'VIP' ? ('购买康养城VIP套餐包' . $full) : '餐饮订单');
- Event::dispatch('statistics.inout.in', $params);
- return json_success('success');
- }
- }
- Db::rollBack();
- return json_fail('没有查询到记录');
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- return json_fail('查询失败');
- }
- }
- /**
- * @Desc 查询订单状态
- * @Author Gorden
- * @Date 2024/8/19 11:55
- *
- * @param Request $request
- * @return Response|void
- */
- public function getProductOrderPayStatus(Request $request)
- {
- $groupId = $request->get('group_id');
- if (!$groupId) {
- return json_fail('订单不存在');
- }
- $orders = Order::where('order_groupby', $groupId)->get()->toArray();
- if (empty($orders)) {
- return json_fail('订单不存在');
- }
- $params['orderGroupId'] = $groupId;
- $payDetailType = PayDetail::where('join_pay_order_id', $groupId)->pluck('pay_prepayid')->toArray();
- try {
- Db::beginTransaction();
- $payStatus = 'N';
- if (in_array('WXPAY', $payDetailType)) {
- // $result = Pay::wechat(config('payment.wxpay'))->find($groupId, 'pos');
- // $result = json_decode(json_encode($result), true);
- $result = '{"return_code":"SUCCESS","return_msg":"OK","result_code":"SUCCESS","mch_id":"1680393367","appid":"wxc6274da7198e3eb4","openid":"o3JAn6Ii_bAlxS-jbNEC4WnPhdwM","is_subscribe":"N","trade_type":"MICROPAY","trade_state":"SUCCESS","bank_type":"OTHERS","total_fee":"1000","fee_type":"CNY","cash_fee":"1000","cash_fee_type":"CNY","transaction_id":"4200067718202409250802875650","out_trade_no":"OD24092518408RV7","attach":[],"time_end":"20240925184009","trade_state_desc":"支付成功","nonce_str":"OeGOkjch4eaV5qIt","sign":"6DCB3BFC594EBC018A2BEE2C3DFEA4E3"}';
- $result = json_decode($result, true);
- 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') {
- $payStatus = 'Y';
- foreach ($orders as $order) {
- $orderUpdateData = ['order_status_payment' => 'SUCCESS'];
- if (in_array($order['order_category'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE'])) {
- $orderUpdateData['order_status_system'] = 'WAITING';
- } else {
- $orderUpdateData['order_status_system'] = 'SENDING';
- }
- // 主订单
- Order::where('order_groupby', $groupId)->update($orderUpdateData);
- // Sheet
- OrderSheet::where('join_sheet_order_id', $order['order_id'])->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
- // 支付记录
- PayDetail::where('join_pay_order_id', $order['order_groupby'])->where('pay_prepayid', 'WXPAY')->update([
- 'pay_status' => 'SUCCESS',
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_json_response' => json_encode($result)
- ]);
- // 加销售量
- OrderSheetService::addGoodsSales($order['order_id']);
- $discountJson = [];
- if (!empty($orders[0]['order_discount_json'])) {
- $discountJson = json_decode($orders[0]['order_discount_json'], true);
- }
- // 优惠券标记使用
- $this->changeOrderCouponStatus($discountJson, 'USED');
- }
- }
- } else if (in_array('ALIPAY', $payDetailType)) {
- $result = Pay::alipay(config('payment.alipay'))->find($groupId);
- $result = json_decode(json_encode($result), true);
- // $result = '{"code":"10000","msg":"Success","buyer_logon_id":"138******93","buyer_pay_amount":"5.87","fund_bill_list":[{"amount":"5.69","fund_channel":"ALIPAYACCOUNT"},{"amount":"0.18","fund_channel":"COUPON"},{"amount":"0.13","fund_channel":"DISCOUNT"}],"invoice_amount":"5.69","out_trade_no":"OD2409251550Q07A","point_amount":"0.00","receipt_amount":"6.00","send_pay_date":"2024-09-25 15:50:22","total_amount":"6.00","trade_no":"2024092523001439431419750998","trade_status":"TRADE_SUCCESS","buyer_open_id":"04309N2aVhSZz4cKwN_DN2DQa7ekM3z5n8kscQHsmIZOJsf"}';
- // $result = json_decode($result, true);
- if (!empty($result['code']) && $result['code'] == '10000' && !empty($result['trade_status']) && $result['trade_status'] == 'TRADE_SUCCESS') {
- $payStatus = 'Y';
- foreach ($orders as $order) {
- $orderUpdateData = ['order_status_payment' => 'SUCCESS'];
- if (in_array($order['order_category'], ['SERVICE', 'CHNMED', 'CHNNCD', 'PACKAGE'])) {
- $orderUpdateData['order_status_system'] = 'WAITING';
- } else {
- $orderUpdateData['order_status_system'] = 'SENDING';
- }
- // 主订单
- Order::where('order_groupby', $groupId)->update($orderUpdateData);
- // Sheet
- OrderSheet::where('join_sheet_order_id', $order['order_id'])->where('order_sheet_status', 'PAYING')->update(['order_sheet_status' => 'DONE']);
- // 支付记录
- PayDetail::where('join_pay_order_id', $order['order_groupby'])->where('pay_prepayid', 'ALIPAY')->update([
- 'pay_status' => 'SUCCESS',
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_json_response' => json_encode($result)
- ]);
- // 加销售量
- OrderSheetService::addGoodsSales($order['order_id']);
- // 优惠券标记使用
- $discountJson = [];
- if (!empty($orders[0]['order_discount_json'])) {
- $discountJson = json_decode($orders[0]['order_discount_json'], true);
- }
- $this->changeOrderCouponStatus($discountJson, 'USED');
- }
- }
- }
- if ($payStatus == 'Y') {
- // 如果有余额、VIP、福利账户支付
- if (in_array($orders[0]['join_order_member_id'] . '-CASH', $payDetailType)) {
- $cashAmount = PayDetail::where('join_pay_order_id', $groupId)
- ->where('pay_prepayid', $orders[0]['join_order_member_id'] . '-CASH')
- ->sum('pay_amount');
- $this->deductAccountOne($groupId, $orders[0]['join_order_member_id'] . '-CASH', $cashAmount);
- }
- if (in_array($orders[0]['join_order_member_id'] . '-VIP', $payDetailType)) {
- $cashAmount = PayDetail::where('join_pay_order_id', $groupId)
- ->where('pay_prepayid', $orders[0]['join_order_member_id'] . '-VIP')
- ->sum('pay_amount');
- $this->deductAccountOne($groupId, $orders[0]['join_order_member_id'] . '-VIP', $cashAmount);
- }
- if (in_array($orders[0]['join_order_member_id'] . '-WELFARE', $payDetailType)) {
- $cashAmount = PayDetail::where('join_pay_order_id', $groupId)
- ->where('pay_prepayid', $orders[0]['join_order_member_id'] . '-WELFARE')
- ->sum('pay_amount');
- $this->deductAccountOne($groupId, $orders[0]['join_order_member_id'] . 'WELFARE', $cashAmount);
- }
- Db::commit();
- // 服务产生权益
- if (in_array($orders[0]['order_classify'], ['SERVICE', 'CHNMED', 'CHNNCD'])) {
- $this->insertBenefitService($groupId);
- }
- // 产生套包权益
- if (in_array($orders[0]['order_classify'], ['PACKAGE'])) {
- $this->insertBenefitPackage($groupId);
- }
- // 给上级提成-拆单
- OrderService::splitOrderCommission($params);
- // 入收支明细表
- OrderService::splitOrderStatisticsInOut($params);
- return json_success('success');
- }
- Db::rollBack();
- return json_fail('没有查询到记录');
- } catch (BusinessException $e) {
- Db::rollBack();
- _syslog("支付轮询", '订单支付异常:' . $e->getMessage());
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage());
- Db::rollBack();
- return json_fail('查询失败');
- }
- }
- /**
- * @Desc 大额支付轮询中的账户扣款
- * @Author Gorden
- * @Date 2024/9/26 13:36
- *
- * @param $accountNbr
- * @param $amount
- * @return void
- * @throws BusinessException
- */
- public function deductAccountOne($groupId, $accountNbr, $amount)
- {
- try {
- $account = MemberAccount::where('member_account_nbr', $accountNbr)->first();
- $account->member_account_expend = $account->member_account_expend + $amount;
- if ($account->member_account_surplus < $amount && strpos($accountNbr, 'CASH') !== false) {
- $account->member_account_added = $account->member_account_added - ($amount - $account->member_account_surplus);
- $account->member_account_surplus = 0;
- } else {
- $account->member_account_surplus = $account->member_account_surplus - $amount;
- }
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- PayDetail::where('pay_prepayid', $accountNbr)
- ->where('join_pay_order_id', $groupId)
- ->update([
- 'pay_paytimes' => date('Y-m-d H:i:s'),
- 'pay_status' => 'SUCCESS'
- ]);
- } catch (\Exception $e) {
- Log::info("获取大额支付状态:扣除账户金额失败", ['nbr' => $accountNbr, 'amount' => $account]);
- throw new BusinessException("账户金额扣除失败");
- }
- }
- /**
- * @Desc 服务权益设置
- * @Author Gorden
- * @Date 2024/9/26 16:34
- *
- * @param $groupId
- * @return void
- */
- public function insertBenefitService($groupId)
- {
- try {
- $orders = Order::where('order_groupby', $groupId)->select('order_id', 'order_classify')->get()->toArray();
- $orderIds = array_column($orders, 'order_id');
- $sheets = OrderSheet::whereIn('join_sheet_order_id', $orderIds)->get()->toArray();
- foreach ($sheets as $sheet) {
- $params = [];
- foreach ($orders as $order) {
- if ($sheet['join_sheet_order_id'] == $order['order_id']) {
- $params['goods_classify'] = $order['order_classify'];
- }
- }
- $params['join_order_member_id'] = $sheet['join_sheet_member_id'];
- $params['join_sheet_goods_id'] = $sheet['join_sheet_goods_id'];
- $params['join_sheet_goods_sku_id'] = $sheet['join_sheet_goods_sku_id'];
- $params['orderId'] = $sheet['join_sheet_order_id'];
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- for ($i = 0; $i < $sheet['order_sheet_num']; $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- $this->insertAppointment($params, []);
- }
- $goodsModel = Goods::where('goods_id', $sheet['join_sheet_goods_id'])->first();
- $goods = [];
- if (!empty($goodsModel)) {
- $goods['goods_id'] = $sheet['join_sheet_goods_id'];
- $goods['skuId'] = $sheet['join_sheet_goods_sku_id'];
- $goods['category'] = $goodsModel->goods_classify;
- $goods['goods_name'] = $goodsModel->goods_name;
- }
- $params['order_sheet_num'] = $sheet['order_sheet_num'];
- $this->insertMemberBenefit($params, $goods);
- }
- } catch (\Exception $e) {
- _syslog("下单", '权益设置失败');
- }
- }
- /**
- * @Desc 套包权益设置
- * @Author Gorden
- * @Date 2024/9/26 16:34
- *
- * @param $groupId
- * @return void
- */
- public function insertBenefitPackage($groupId)
- {
- try {
- $orders = Order::where('order_groupby', $groupId)->select('order_id', 'order_classify')->get()->toArray();
- $orderIds = array_column($orders, 'order_id');
- $sheets = OrderSheet::whereIn('join_sheet_order_id', $orderIds)->get()->toArray();
- foreach ($sheets as $sheet) {
- $params = [];
- $params['orderId'] = $sheet['join_sheet_order_id'];
- foreach ($orders as $order) {
- if ($sheet['join_sheet_order_id'] == $order['order_id']) {
- $params['goods_classify'] = $order['order_classify'];
- }
- }
- $params['packageId'] = $sheet['join_sheet_goods_id'];;
- $components = GoodsComponent::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name', 'goods_classify');
- }
- ])->where('join_component_master_goods_id', $params['packageId'])
- ->get()
- ->toArray();
- $params['join_order_member_id'] = $sheet['join_sheet_member_id'];
- foreach ($components as $component) {
- $params['benefitId'] = 'BF' . date('ymdHi') . random_string(4, 'up');
- $componentJson = json_decode($component['goods_component_json'], true);
- $params['join_sheet_goods_id'] = $component['join_component_goods_id'];
- $params['order_sheet_num'] = $sheet['order_sheet_num'] * $componentJson['nbr'];
- $params['join_sheet_goods_sku_id'] = $componentJson['sku_id'];
- for ($i = 0; $i < intval($params['order_sheet_num']); $i++) {
- $params['appointmentId'] = 'AP' . date('ymdHi') . random_string(4, 'up');
- // 入预约记录
- $this->insertAppointment($params, []);
- }
- $goods['goods_id'] = $component['join_component_goods_id'];
- $goods['goods_name'] = $component['goods']['goods_name'];
- $goods['goods_classify'] = $component['goods']['goods_classify'];
- $goods['skuId'] = $componentJson['sku_id'];
- $goods['category'] = 'SERVICE';
- // 权益表
- $this->insertMemberBenefit($params, $goods);
- }
- $this->sendCoupon($params, ['goods_id' => $params['packageId']], $params['orderId']);
- }
- } catch (\Exception $e) {
- _syslog("下单", '权益设置失败');
- }
- }
- public function sendCoupon($params, $goods, $orderId)
- {
- try {
- $couponSendParams = [
- 'gettype' => 'PACKAGE',
- 'member_id' => $params['join_order_member_id'],
- 'orderId' => $orderId,
- 'join_sheet_goods_id' => $goods['goods_id']
- ];
- CouponService::autoSendCouponByGoods($couponSendParams);
- } catch (\Exception $e) {
- throw new BusinessException("卡券发放失败");
- }
- }
- public function deductAccount($orderId, $orderGroup, $payWay)
- {
- $payDetails = PayDetail::where('join_pay_order_id', $orderGroup)
- ->where('pay_prepayid', '<>', $payWay)
- ->whereJsonContains('join_pay_object_json->order_id', $orderId)
- ->get()
- ->toArray();
- $pays = [];
- foreach ($payDetails as $payDetail) {
- if (isset($pays[$payDetail['pay_prepayid']])) {
- $pays[$payDetail['pay_prepayid']] += $payDetail['pay_amount'];
- } else {
- $pays[$payDetail['pay_prepayid']] = $payDetail['pay_amount'];
- }
- }
- foreach ($pays as $key => $amount) {
- if (strpos($key, 'CASH') !== false || strpos($key, 'CARD') !== false || strpos($key, 'WELFARE') !== false || strpos($key, 'VIP') !== false) {
- $account = MemberAccount::where('member_account_nbr', $key)->first();
- $account->member_account_expend = $account->member_account_expend + $amount;
- $account->member_account_surplus = $account->member_account_surplus - $amount;
- $account->member_account_update_user_id = JwtToken::getCurrentId();
- $account->member_account_updatetimes = time();
- $account->save();
- }
- }
- PayDetail::where('join_pay_order_id', $orderGroup)
- ->where('pay_prepayid', '<>', $payWay)
- ->whereJsonContains('join_pay_object_json->order_id', $orderId)
- ->update(['pay_status' => 'SUCCESS']);
- }
- /**
- * @Desc 修改订单状态-挂账
- * @Author Gorden
- * @Date 2024/8/20 15:58
- *
- * @param Request $request
- * @return Response
- */
- public function updateStatus(Request $request)
- {
- $orderId = $request->post('order_id', '');
- $orderStatusPayment = $request->post('order_status_payment', '');
- $freeRemark = $request->post('free_remark', '');
- $order = Order::where('order_id', $orderId)
- ->select('order_id', 'order_groupby', 'order_status_payment', 'order_config_json', 'order_amount_total', 'order_discount_json', 'order_extend_json')
- ->first();
- Db::beginTransaction();
- try {
- if ($orderStatusPayment == 'AWAITING' && $order->order_status_payment != 'PENDING') {
- throw new BusinessException("当前订单不允许挂账");
- } else if ($orderStatusPayment == 'FREE' && $order->order_status_payment != 'PENDING') {
- throw new BusinessException("当前订单不允许免单");
- }
- $orderExtendJson = [];
- if (!empty($order->order_extend_json)) {
- $orderExtendJson = json_decode($order->order_extend_json, true);
- }
- // 挂账,释放餐桌
- if (in_array($orderStatusPayment, ['AWAITING', 'FREE'])) {
- $order->order_status_payment = $orderStatusPayment;
- $orderExtendJson['awaiting_times'] = date('Y-m-d H:i:s');
- $order->order_extend_json = json_encode($orderExtendJson, JSON_UNESCAPED_UNICODE);
- // 如果有餐桌,释放
- if (!empty($order->order_config_json)) {
- $orderConfigJson = json_decode($order->order_config_json, true);
- if (!empty($orderConfigJson['tableid'])) {
- SysDept::where('dept_id', $orderConfigJson['tableid'])->update(['dept_status' => 'ACTIVED']);
- }
- }
- }
- if ($orderStatusPayment == 'FREE') {
- $orderDiscountJson = [];
- if (!empty($order->order_discount_json)) {
- $orderDiscountJson = json_decode($order->order_discount_json, true);
- }
- $orderDiscountJson[date('Y-m-d H:i:s')] = [
- 'coupon_id' => null,
- 'coupon_value' => $order->order_amount_total,
- 'coupon_classify' => '免单',
- 'coupon_detail_id' => ['免单'],
- 'coupon_classify_en' => ['free']
- ];
- $orderExtendJson['free_remark'] = $freeRemark;
- $order->order_discount_json = json_encode($orderDiscountJson, JSON_UNESCAPED_UNICODE);
- $order->order_extend_json = json_encode($orderExtendJson, JSON_UNESCAPED_UNICODE);
- $order->order_is_complete = 'Y';
- $order->order_status_system = 'DONE';
- $order->order_amount_pay = 0;
- // sheet表
- OrderSheet::where('join_sheet_order_id', $orderId)->update(['order_sheet_status' => 'DONE']);
- // payDetail 表
- PayDetail::where('join_pay_order_id', $order->order_groupby)
- ->update([
- 'pay_status' => 'SUCCESS',
- 'pay_amount' => 0,
- 'pay_prepayid' => 'MONEY',
- 'pay_paytimes' => date('Y-m-d H:i:s')
- ]);
- }
- $order->save();
- Db::commit();
- return json_success('success');
- } catch (BusinessException $e) {
- Db::rollBack();
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail('修改订单状态失败');
- }
- }
- public function useCoupon(Request $request)
- {
- $goods = $request->post('goods', []);
- $coupon = $request->post('coupon', []);
- $payAmount = $request->post('pay_amount', 0);
- $memberId = $request->post('member_id', '');
- $settlementNow = $request->post('settlement_now', 'N');
- if (empty($goods) || empty($coupon) || empty($memberId)) {
- return json_fail("参数异常");
- }
- foreach ($coupon as $item) {
- if (!in_array(substr($item, 0, 2), ['CU', 'CO'])) {
- return json_fail("参数异常");
- }
- }
- // 是否是推广券
- $promotionCoupon = Coupon::whereIn('coupon_id', $coupon)
- ->where('coupon_category', 'PROMOTION')
- ->select('coupon_id')
- ->first();
- if (!empty($promotionCoupon)) {
- // 是否已有
- $couponDetail = CouponDetail::whereIn('join_detail_coupon_id', $coupon)
- ->where('join_coupon_detail_member_id', $memberId)
- ->whereIn('coupon_detail_status', ['INIT', 'PENDING', 'ACTIVED'])
- ->first();
- if (empty($couponDetail)) {
- $chooseCoupons[] = [
- 'id' => $coupon[0],
- 'nbr' => 1,
- 'gain_datetime' => date('Y-m-d H:i:s')
- ];
- CouponDetailService::customSendService($chooseCoupons, '', [$memberId], '');
- }
- }
- $amountBalance = [
- 'pay_amount' => $payAmount,
- 'welfare_balance' => 0,
- 'cut_balance' => 0,
- ];
- foreach ($goods as $good) {
- $result = OrderService::chooseCoupon($settlementNow, $memberId, $goods, $good, $coupon, $amountBalance);
- $amountBalance = [
- 'pay_amount' => $result['pay_amount'],
- 'welfare_balance' => $result['welfare_balance'],
- 'cut_balance' => $result['cut_balance'],
- ];
- }
- Redis::del("ORDER:USE:COUPON:" . $memberId);
- return json_success("success", ['pay_amount' => $amountBalance['pay_amount']]);
- }
- /**
- * @Desc 订单的核销记录
- * @Author Gorden
- * @Date 2024/9/13 14:28
- *
- * @param Request $request
- * @return Response
- */
- public function writeOffList(Request $request)
- {
- $orderId = $request->get('order_id');
- $page = $request->get('page', 1);
- $pageSize = $request->get('pageSize', 20);
- if (!$orderId) {
- return json_fail("参数异常");
- }
- $appointments = Appointment::with([
- 'member' => function ($query) {
- $query->select('member_id', 'member_mobile');
- },
- 'memberInfo',
- 'cert',
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_name');
- }
- ])->where('join_appointment_order_id', $orderId)
- ->where('appointment_status', 'DONE')
- ->select('appointment_id', 'join_appointment_member_id', 'join_appointment_goods_id', 'appointment_done_datetime', 'appointment_done_json');
- $total = $appointments->count();
- $rows = $appointments->forPage($page, $pageSize)
- ->orderBy('appointment_done_datetime', 'DESC')
- ->get();
- foreach ($rows as &$item) {
- $memberMobile = '';
- if (!empty($item['member']) && !empty($item['member']['member_mobile'])) {
- $memberMobile = $item['member']['member_mobile'];
- }
- $memberNickname = '';
- if (!empty($item['member_info']) && !empty($item['member_info']['member_info_nickname'])) {
- $memberNickname = $item['member_info']['member_info_nickname'];
- }
- $memberName = '';
- if (!empty($item['cert']) && !empty($item['cert']['member_cert_name'])) {
- $memberName = $item['cert']['member_cert_name'];
- }
- unset($item['member'], $item['member_info'], $item['cert']);
- $item['member_name'] = MemberService::getMemberName($memberMobile, $memberName, $memberNickname);
- if (!empty($item['appointment_done_json'])) {
- $doneJson = json_decode($item['appointment_done_json'], true);
- if (isset($doneJson['charge']) && !empty($doneJson['charge']['charge_user_id'])) {
- $item['username'] = SysUser::where('user_id', $doneJson['charge']['charge_user_id'])->value('user_name');
- $item['waiter'] = $doneJson['charge']['charge_waiter'] ?? '';
- }
- if (isset($doneJson['charge']) && !empty($doneJson['charge']['charge_premises'])) {
- $item['premise'] = $doneJson['charge']['charge_premises'];
- }
- $item['nbr'] = 1;
- }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total'));
- }
- // public function getMergeOrder(Request $request)
- // {
- // $orderIds = $request->get('order_ids');
- // if (!$orderIds) {
- // return json_fail('参数异常');
- // }
- //
- // $orders = Order::whereIn('order_id', $orderIds)
- // ->select('order_id', 'order_groupby', 'order_amount_total', 'order_amount_pay')
- // ->get()
- // ->toArray();
- // $groupIds = array_column($orders, 'order_groupby');
- // if (count(array_unique($groupIds)) > 1){
- // return json_fail("请选择同批次下单的记录");
- // }
- //
- // return json_success("");
- // }
- public static $goodsClassify = [
- // goodsClassify: {GOODS:"健康产品订单",SERVICE:"服务订单",DEVICE:"设备订单",SPECIAL:"专题业务订单",PACKAGE:"套餐订单",RECHARGE:"充值订单",OTHER:"其他订单"},
- 'GOODS' => "产品订单",
- 'SERVICE' => "服务订单",
- 'CHNMED' => '服务订单',
- 'CHNNCD' => '服务订单',
- 'DEVICE' => '设备订单',
- 'SPECIAL' => '专题业务订单',
- 'PACKAGE' => '套包订单',
- 'RECHARGE' => '充值订单',
- 'OTHER' => '其他订单',
- 'DISHES' => '餐饮订单',
- 'MEALS' => '餐饮订单',
- 'VIP' => '康养城订单',
- 'COMBINE' => '新客专享订单',
- 'PARTNER' => '会员合伙人订单',
- 'REFERRER' => '康养推荐官订单'
- ];
- // systemStatus: {BEING:"待生效",PAYING:"待支付",PENDING:"待确认",WAITING:"待受理",SENDING:"待发货",RECVING:"待收货",SIGNED:"已签收",CONFIRM:"确认收货"},
- // paymentStatus: {PENDING:"待支付",CANCEL:"取消支付",SUCCESS:"支付成功"},
- public static $systemStatus = [
- 'BEING' => '待生效',
- 'PAYING' => "待支付",
- 'PENDING' => "待确认",
- 'WAITING' => "待使用",
- 'SENDING' => "待发货",
- 'PICKUP' => "待自提",
- 'RECVING' => "待收货",
- 'SIGNED' => "已签收",
- 'CONFIRM' => "确认收货",
- 'DONE' => '已完成',
- 'CANCEL' => '已取消'
- ];
- public static $paymentStatus = [
- 'WAITING' => "待支付",
- 'PENDING' => "待支付",
- 'CANCEL' => "取消支付",
- 'SUCCESS' => "支付成功",
- 'AWAITING' => "挂账",
- 'FREE' => "免单"
- ];
- }
|