WholeController.php 191 KB

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