123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922 |
- <?php
- namespace app\admin\service\goods;
- use app\common\Tree;
- use app\model\Appointment;
- use app\model\Coupon;
- use app\model\Goods;
- use app\model\GoodsComponent;
- use app\model\GoodsDetail;
- use app\model\GoodsLabel;
- use app\model\GoodsRunning;
- use app\model\GoodsSku;
- use app\model\OrderSheet;
- use app\model\Supplier;
- use app\model\SysCategory;
- use app\model\SysDept;
- use app\model\SysSerial;
- use app\model\SysUser;
- use support\Db;
- use support\exception\BusinessException;
- use support\Redis;
- use support\Request;
- use support\Response;
- use Tinywan\Jwt\JwtToken;
- class GoodsService
- {
- public static function selectAll($goodsIds)
- {
- $goods = Goods::where('goods_status', 'ON')
- ->when($goodsIds != '', function ($query) use ($goodsIds) {
- $query->whereIn('goods_id', $goodsIds);
- })
- ->select('goods_id', 'goods_name')
- ->get();
- return json_success('', $goods);
- }
- /**
- * @Desc 产品搜索
- * @Author Gorden
- * @Date 2024/11/8 10:10
- *
- * @param Request $request
- * @return Response
- */
- public static function selectIdNameList(Request $request)
- {
- $keywords = $request->get('keywords');
- if (!$keywords) {
- return json_fail('参数异常');
- }
- $goods = Goods::where('goods_name', 'like', '%' . $keywords . '%')
- ->select('goods_id', 'goods_name')
- ->get()
- ->toArray();
- return json_success('success', $goods);
- }
- public static function selectAllByGoodsName($goodsName)
- {
- $goods = Goods::with('sku')
- ->where('goods_status', 'ON')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where('goods_name', 'like', "%" . $goodsName . '%');
- })
- ->select('goods_id', 'goods_name', 'goods_classify')
- ->get()
- ->toArray();
- foreach ($goods as &$item) {
- if (!empty($item['sku'])) {
- foreach ($item['sku'] as $key => $sku) {
- $specsJson = json_decode($sku['goods_sku_specs_json'], true);
- $skuTitle = '';
- foreach ($specsJson as $item2) {
- if (is_array($item2)) {
- $item2 = implode(',', $item2);
- }
- $skuTitle .= $item2 . '-';
- }
- $item['sku'][$key]['goods_sku_id'] = strval($item['sku'][$key]['goods_sku_id']);
- $item['sku'][$key]['goods_sku_title'] = rtrim($skuTitle, '-');
- }
- }
- }
- return json_success('', $goods);
- }
- public static function selectAllByCategoryForRuleAddComponent($category = "GOODS")
- {
- $categoryIds = [];
- $categorySuperIds = [];
- if ($category == 'GOODS') {
- $categorySuperIds = [5];
- } elseif ($category == 'SERVICE') {
- $categorySuperIds = [31, 154, 42, 65, 30, 66, 72, 70];
- }
- $categorys = SysCategory::whereIn('category_id', $categorySuperIds)->get()->toArray();
- foreach ($categorys as $item) {
- if (empty($item['category_super_path'])) {
- $item['category_super_path'] = '#' . $item['category_id'] . '#';
- } else {
- $item['category_super_path'] = $item['category_super_path'] . '#' . $item['category_id'] . '#';
- }
- $categoryIds = SysCategory::where('category_super_path', 'like', '%' . $item['category_super_path'] . '%')->pluck('category_id');
- $categoryIds = $categoryIds ? $categoryIds->toArray() : [];
- $categorySuperIds = array_merge($categorySuperIds, $categoryIds);
- }
- $categoryIds = array_unique($categorySuperIds);
- $goods = Goods::with('sku')
- // ->where('goods_classify', $category)
- ->when(!empty($categoryIds), function ($query) use ($categoryIds) {
- $query->whereIn('join_goods_category_id', $categoryIds);
- })->when(empty($categoryIds), function ($query) {
- $query->where('goods_classify', '<>', 'RECHARGE');
- })->where('goods_status', 'ON')
- ->select('goods_id', 'goods_name', 'join_goods_category_id')
- ->get()
- ->toArray();
- foreach ($goods as &$good) {
- if (!empty($good['sku'])) {
- foreach ($good['sku'] as $key => $sku) {
- if (!empty($sku['goods_sku_specs_json'])) {
- $specsJson = json_decode($sku['goods_sku_specs_json'], true);
- $skuTitle = '';
- foreach ($specsJson as $item) {
- if (is_array($item)) {
- $item = implode(',', $item);
- }
- $skuTitle .= $item . '-';
- }
- $good['sku'][$key]['goods_sku_id'] = strval($good['sku'][$key]['goods_sku_id']);
- $good['sku'][$key]['goods_sku_title'] = rtrim($skuTitle, '-');
- }
- unset($good['sku'][$key]['goods_sku_specs_json'], $good['sku'][$key]['join_sku_goods_id']);
- }
- } else {
- $good['sku'] = [];
- }
- }
- return json_success('', $goods);
- }
- public static function selectPremisesByGoodsId($goodsId)
- {
- $goods = Goods::where('goods_id', $goodsId)
- ->select('goods_id', 'goods_attribute_json')
- ->first();
- $premisses = [];
- if (!empty($goods->goods_attribute_json)) {
- $attributeJson = json_decode($goods->goods_attribute_json, true);
- if (isset($attributeJson['premisses'])) {
- $premisses = SysDept::whereIn('dept_id', $attributeJson['premisses'])
- ->select('dept_id', 'dept_name')
- ->get()
- ->toArray();
- }
- }
- return json_success('', $premisses);
- }
- public static function select(Request $request, $classify = "GOODS")
- {
- $page = $request->get('page', 1);
- $pageSize = $request->get('pageSize', 20);
- $goodsName = $request->get('goods_name', '');
- $categoryId = $request->get('join_goods_category_id', null);
- $goodsCategory = $request->get('goods_category', null);
- $goodsSupplierId = $request->get('join_goods_supplier_id', null);
- $goodsStatus = $request->get('goods_status', null);
- $type = $request->get('type', '');
- $requestClassify = $request->get('classify');
- if ($categoryId != null) {
- $categoryPath = SysCategory::where('category_id', $categoryId)->value('category_super_path');
- $categoryPath .= '#' . $categoryId . '#';
- $categoryIds = SysCategory::where('category_super_path', 'like', $categoryPath . '%')->pluck('category_id')->toArray();
- $categoryIds[] = intval($categoryId);
- if (!empty($categoryIds)) {
- $categoryId = $categoryIds;
- } else {
- $categoryId = [intval($categoryId)];
- }
- }
- $rows = Goods::with([
- 'category' => function ($query) {
- $query->select('category_id', 'category_name');
- },
- 'running' => function ($query) {
- $query->select('join_running_goods_id', 'goods_running_storage');
- },
- 'supplier' => function ($query) {
- $query->select('supplier_id', 'supplier_name');
- },
- 'user' => function ($query) {
- $query->select('user_id', 'user_name');
- },
- 'updateUser' => function ($query) {
- $query->select('user_id', 'user_name');
- },
- ])->leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_user_id', 'updator_user_id', 'goods_status', 'goods_sales_price', 'goods_category', 'goods_name', 'goods_title', 'goods_cover', 'goods_sort', 'goods_attribute_json', 'goods_addtimes', 'goods_updatetimes')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%');
- // ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->when($categoryId != null, function ($query) use ($categoryId) {
- $query->whereIn('join_goods_category_id', $categoryId);
- })->when($goodsCategory != null, function ($query) use ($goodsCategory) {
- $query->where('goods_category', $goodsCategory);
- })
- ->when($classify != '', function ($query) use ($classify, $categoryId) {
- if ($classify == 'GOODS' && empty($categoryId)) {
- $query->whereIn('join_goods_category_id', ['6', '7', '8', '9', '10', '11', '12', '30']);
- } else if ($classify == 'RECHARGE' && empty($categoryId)) {
- $query->where('goods_status', 'ON');
- $query->where('goods_classify', $classify);
- } else if ($classify != 'GOODS' && empty($categoryId)) {
- $query->where('goods_classify', $classify);
- }
- })->when(!empty($type), function ($query) use ($type) {
- if ($type == 'storageWarning') {
- $query->where('goods_running.goods_running_storage', '<=', 2);
- }
- })->when(!empty($goodsSupplierId), function ($query) use ($goodsSupplierId) {
- $query->where('join_goods_supplier_id', $goodsSupplierId);
- })->when(!empty($goodsStatus), function ($query) use ($goodsStatus) {
- $query->where('goods_status', $goodsStatus);
- })->when(!empty($requestClassify), function ($query) use ($requestClassify) {
- $query->where('goods_classify', $requestClassify);
- })
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- $totalModel = Goods::leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%');
- // ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->when($categoryId != null, function ($query) use ($categoryId) {
- $query->whereIn('join_goods_category_id', $categoryId);
- })->when($goodsCategory != null, function ($query) use ($goodsCategory) {
- $query->where('goods_category', $goodsCategory);
- })->when($classify != '', function ($query) use ($classify, $categoryId) {
- if ($classify == 'GOODS' && empty($categoryId)) {
- $query->whereIn('join_goods_category_id', ['6', '7', '8', '9', '10', '11', '12', '30']);
- } else if ($classify == 'RECHARGE' && empty($categoryId)) {
- $query->where('goods_status', 'ON');
- $query->where('goods_classify', $classify);
- } else if ($classify != 'GOODS' && empty($categoryId)) {
- $query->where('goods_classify', $classify);
- }
- })->when(!empty($type), function ($query) use ($type) {
- if ($type == 'storageWarning') {
- $query->where('goods_running.goods_running_storage', '<=', 2);
- }
- })->when(!empty($goodsSupplierId), function ($query) use ($goodsSupplierId) {
- $query->where('join_goods_supplier_id', $goodsSupplierId);
- })->when(!empty($goodsStatus), function ($query) use ($goodsStatus) {
- $query->where('goods_status', $goodsStatus);
- });
- $goodsOnTotalModel = clone $totalModel;
- $goodsOnTotal = $goodsOnTotalModel->where('goods_status', 'ON')->count();
- $goodsWarningTotalModel = clone $totalModel;
- $goodsWarningTotal = $goodsWarningTotalModel->where('goods_running_storage', '<=', 2)->count();
- $total = $totalModel->count();
- foreach ($rows as &$row) {
- $row['goods_cover'] = getenv('STORAGE_DOMAIN') . $row['goods_cover'];
- if (isset($row['running'])) {
- $row['running']['goods_running_storage'] = intval($row['running']['goods_running_storage']);
- }
- if (!empty($row['goods_attribute_json'])) {
- $row['goods_attribute_json'] = json_decode($row['goods_attribute_json']);
- }
- if (!empty($row['goods_category']) && $row['goods_category'] == 'INDEX') {
- $row['goods_recommend_index'] = 'INDEX';
- }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total', 'goodsOnTotal', 'goodsWarningTotal'));
- }
- public static function selectSpecial(Request $request)
- {
- $page = $request->get('page');
- $pageSize = $request->get('pageSize');
- $goodsName = $request->get('goods_name', '');
- $categoryId = $request->get('join_goods_category_id', null);
- if ($categoryId == null) {
- $categoryId = [65, 43];
- } elseif (is_string($categoryId)) {
- $categoryId = [$categoryId];
- }
- $rows = Goods::with([
- 'category' => function ($query) {
- $query->select('category_id', 'category_name');
- },
- 'running' => function ($query) {
- $query->select('join_running_goods_id', 'goods_running_storage');
- },
- 'supplier' => function ($query) {
- $query->select('supplier_id', 'supplier_name');
- },
- 'user' => function ($query) {
- $query->select('user_id', 'user_name');
- },
- 'updateUser' => function ($query) {
- $query->select('user_id', 'user_name');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_user_id', 'updator_user_id', 'goods_status', 'goods_sales_price', 'goods_category', 'goods_name', 'goods_title', 'goods_cover', 'goods_sort', 'goods_addtimes', 'goods_updatetimes')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%');
- // ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->whereIn('join_goods_category_id', $categoryId)
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- $totalModel = Goods::when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%');
- });
- })->leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->whereIn('join_goods_category_id', $categoryId);
- $goodsOnTotalModel = clone $totalModel;
- $goodsOnTotal = $goodsOnTotalModel->where('goods_status', 'ON')->count();
- $goodsWarningTotalModel = clone $totalModel;
- $goodsWarningTotal = $goodsWarningTotalModel->where('goods_running_storage', '<=', 2)->count();
- $total = $totalModel->count();
- foreach ($rows as &$row) {
- $row['goods_cover'] = getenv('STORAGE_DOMAIN') . $row['goods_cover'];
- if (isset($row['running'])) {
- $row['running']['goods_running_storage'] = intval($row['running']['goods_running_storage']);
- }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total', 'goodsOnTotal', 'goodsWarningTotal'));
- }
- public static function selectPicking(Request $request)
- {
- $page = $request->get('page');
- $pageSize = $request->get('pageSize');
- $goodsName = $request->get('goods_name', '');
- $categorySuperId = $request->get('category_super_id', '');
- $categoryIds = $request->get('join_goods_category_id', []);
- if (!empty($categorySuperId) && is_array($categoryIds)) {
- $category = SysCategory::where('category_id', $categorySuperId)->first();
- if (empty($category->category_super_path)) {
- $category->category_super_path = '#' . $categorySuperId . '#';
- } else {
- $category->category_super_path = $category->category_super_path . '#' . $categorySuperId . '#';
- }
- $categoryIds = SysCategory::where('category_super_path', 'like', '%' . $category->category_super_path)->pluck('category_id');
- $categoryIds = $categoryIds ? $categoryIds->toArray() : [];
- $categoryIds = array_merge($categoryIds, [$categorySuperId]);
- } elseif (!is_array($categoryIds)) {
- $categoryIds = [$categoryIds];
- }
- $rows = Goods::with([
- 'category' => function ($query) {
- $query->select('category_id', 'category_name');
- },
- 'running' => function ($query) {
- $query->select('join_running_goods_id', 'goods_running_storage');
- },
- 'supplier' => function ($query) {
- $query->select('supplier_id', 'supplier_name');
- },
- 'user' => function ($query) {
- $query->select('user_id', 'user_name');
- },
- 'updateUser' => function ($query) {
- $query->select('user_id', 'user_name');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_user_id', 'updator_user_id', 'goods_status', 'goods_sales_price', 'goods_category', 'goods_name', 'goods_title', 'goods_cover', 'goods_sort', 'goods_addtimes', 'goods_updatetimes')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%')
- ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->whereIn('join_goods_category_id', $categoryIds)
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- $totalModel = Goods::when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%')
- ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->whereIn('join_goods_category_id', $categoryIds);
- $goodsOnTotalModel = clone $totalModel;
- $goodsOnTotal = $goodsOnTotalModel->where('goods_status', 'ON')->count();
- $goodsWarningTotalModel = clone $totalModel;
- $goodsWarningTotal = $goodsWarningTotalModel->where('goods_running_storage', '<=', 2)->count();
- $total = $totalModel->count();
- foreach ($rows as &$row) {
- $row['goods_cover'] = getenv('STORAGE_DOMAIN') . $row['goods_cover'];
- if (isset($row['running'])) {
- $row['running']['goods_running_storage'] = intval($row['running']['goods_running_storage']);
- }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total', 'goodsOnTotal', 'goodsWarningTotal'));
- }
- public static function selectPackage(Request $request)
- {
- $page = $request->get('page');
- $pageSize = $request->get('pageSize');
- $goodsName = $request->get('goods_name', '');
- $categoryId = $request->get('join_goods_category_id', null);
- $rows = Goods::with([
- 'category' => function ($query) {
- $query->select('category_id', 'category_name');
- },
- 'running' => function ($query) {
- $query->select('join_running_goods_id', 'goods_running_storage');
- },
- 'supplier' => function ($query) {
- $query->select('supplier_id', 'supplier_name');
- },
- 'user' => function ($query) {
- $query->select('user_id', 'user_name');
- },
- 'updateUser' => function ($query) {
- $query->select('user_id', 'user_name');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_user_id', 'updator_user_id', 'goods_status', 'goods_sales_price', 'goods_category', 'goods_name', 'goods_title', 'goods_cover', 'goods_sort', 'goods_addtimes', 'goods_updatetimes')
- ->when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%')
- ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->when($categoryId != null, function ($query) use ($categoryId) {
- $query->where('join_goods_category_id', $categoryId);
- })
- ->where('goods_classify', 'PACKAGE')
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- $totalModel = Goods::when($goodsName != '', function ($query) use ($goodsName) {
- $query->where(function ($q) use ($goodsName) {
- $q->where('goods_name', 'like', '%' . $goodsName . '%')
- ->OrWhere('goods_title', 'like', '%' . $goodsName . '%');
- });
- })->when($categoryId != null, function ($query) use ($categoryId) {
- $query->where('join_goods_category_id', $categoryId);
- })->leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->where('goods_classify', 'PACKAGE');
- $goodsOnTotalModel = clone $totalModel;
- $goodsOnTotal = $goodsOnTotalModel->where('goods_status', 'ON')->count();
- $goodsWarningTotalModel = clone $totalModel;
- $goodsWarningTotal = $goodsWarningTotalModel->where('goods_running_storage', '<=', 2)->count();
- $total = $totalModel->count();
- foreach ($rows as &$row) {
- $row['goods_cover'] = getenv('STORAGE_DOMAIN') . $row['goods_cover'];
- if (isset($row['running'])) {
- $row['running']['goods_running_storage'] = intval($row['running']['goods_running_storage']);
- }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total', 'goodsOnTotal', 'goodsWarningTotal'));
- }
- /**
- * @Desc 下拉选择服务商品
- * @Author Gorden
- * @Date 2024/4/24 13:32
- *
- * @param Request $request
- * @return Response
- */
- public static function selectList(Request $request, $goodsClassify = "SERVICE")
- {
- $keywords = $request->get('keywords', '');
- $isSupportAppointment = $request->get('is_support_appointment', '');
- // if (!$keywords){
- // return json_success('暂无数据');
- // }
- // $categoryIds = SysCategory::whereIn('category_super_id', [5, 31, 32, 42, 66, 70, 72])->pluck('category_id');
- $goods = Goods::with('sku')
- // ->whereIn('join_goods_category_id', $categoryIds)
- ->when($keywords != '', function ($query) use ($keywords) {
- $query->where('goods_name', 'like', "%" . $keywords . "%");
- })
- ->when($goodsClassify != '', function ($query) use ($goodsClassify) {
- if ($goodsClassify == 'NOPACKAGE') {
- $query->where('goods_classify', '<>', 'PACKAGE');
- } else if ($goodsClassify == 'SERVICE') {
- $query->whereIn('goods_classify', ['SERVICE', 'CHNMED', 'CHNNCD']);
- } else {
- $query->where('goods_classify', $goodsClassify);
- }
- })
- ->when($isSupportAppointment != '', function ($query) use ($isSupportAppointment) {
- $query->where('is_support_appointment', $isSupportAppointment);
- })
- ->select('goods_id', 'goods_name', 'goods_sales_price', 'join_goods_category_id', 'goods_attribute_json')
- ->get()
- ->toArray();
- foreach ($goods as &$good) {
- if (!empty($good['sku'])) {
- foreach ($good['sku'] as $key => $sku) {
- if (!empty($sku['goods_sku_specs_json'])) {
- $good['sku'][$key]['goods_sku_specs_json'] = json_decode($sku['goods_sku_specs_json']);
- $skuName = '';
- foreach ($good['sku'][$key]['goods_sku_specs_json'] as $specsKey => $skuSpecs) {
- if (is_array($skuSpecs)) {
- $skuName = $skuName . ' ' . $specsKey . ':' . implode(' ', $skuSpecs) . ';';
- } else {
- $skuName = $skuName . ' ' . $specsKey . ':' . $skuSpecs . ';';
- }
- }
- $good['sku'][$key]['sku_name'] = $skuName;
- }
- }
- } else {
- $good['sku'] = [];
- }
- $good['premisses'] = [];
- if (!empty($good['goods_attribute_json'])) {
- $attributeJson = json_decode($good['goods_attribute_json'], true);
- if (isset($attributeJson['premisses'])) {
- $premisses = SysDept::when(!empty($attributeJson['premisses']), function ($query) use ($attributeJson) {
- $query->whereIn('dept_id', $attributeJson['premisses']);
- })->where('dept_category', '营业场所')
- ->select('dept_id', 'dept_name')
- ->get();
- $good['premisses'] = $premisses;
- }
- }
- }
- return json_success('', $goods);
- }
- public static function selectCascaderList(Request $request)
- {
- $categoryIds = $request->get('category_id', '');
- $categorySuperId = $request->get('category_super_id', '');
- $joinGoodsCategoryId = $request->get('join_goods_category_id', '');
- $type = $request->get('type', '');
- $classify = $request->get('classify', '');
- if (!$categoryIds && !$categorySuperId && !$joinGoodsCategoryId) {
- return json_fail('参数异常');
- }
- $data = [];
- $categorys = [];
- if (!empty($categoryIds)) {
- $categorys = SysCategory::whereIn('category_id', $categoryIds)
- ->whereIn('category_status', ['ACTIVED', 'UNSHOW'])
- ->select('category_id as id', 'category_name as name', 'category_super_id as pid', 'category_super_path')
- ->orderBy('category_sort', 'DESC')
- ->get()
- ->toArray();
- $data = array_merge($data, $categorys);
- } else if (!empty($categorySuperId)) {
- $categorys = SysCategory::where('category_super_id', $categorySuperId)
- ->whereIn('category_status', ['ACTIVED', 'UNSHOW'])
- ->select('category_id as id', 'category_name as name', 'category_super_id as pid', 'category_super_path')
- ->orderBy('category_sort', 'DESC')
- ->get()
- ->toArray();
- $data = array_merge($data, $categorys);
- }
- foreach ($categorys as $category) {
- // if(empty($category['category_super_path'])){
- $category['category_super_path'] = '#' . $category['id'] . '#';
- // }
- $subCategory = SysCategory::where('category_super_path', 'like', '%' . $category['category_super_path'] . '%')
- ->whereIn('category_status', ['ACTIVED', 'UNSHOW'])
- ->select('category_id as id', 'category_name as name', 'category_super_id as pid', 'category_super_path')
- ->orderBy('category_sort', 'DESC')
- ->get()
- ->toArray();
- $data = array_merge($data, $subCategory);
- }
- if (empty($data) && !empty($joinGoodsCategoryId)) {
- $goodsCategoryIds = $joinGoodsCategoryId;
- } else {
- $goodsCategoryIds = array_column($data, 'id');
- }
- $goods = Goods::with([
- 'sku' => function ($query) {
- $query->where('goods_sku_status', 'ON');
- }
- ])
- ->leftJoin('goods_running', 'goods_running.join_running_goods_id', '=', 'goods.goods_id')
- ->where('goods_running.goods_running_storage', '>', 0)
- ->whereIn('join_goods_category_id', $goodsCategoryIds)
- ->where('goods_status', 'ON')
- ->when(!empty($classify), function ($query) use ($classify) {
- $query->where('goods_classify', $classify);
- });
- if ($type == 'dishes') {
- $uid = JwtToken::getCurrentId();
- $user = SysUser::where('user_id', $uid)->first();
- $restaurant = SysDept::where('dept_category', '餐厅')->where(function ($query) use ($user) {
- $query->where('dept_id', $user->join_user_dept_id)->orWhere('dept_super_id', $user->join_user_dept_id);
- })->first();
- $supplier = Supplier::where('join_supplier_dept_id', $restaurant->dept_id)->first();
- if ($supplier) {
- $goods = $goods->where('join_goods_supplier_id', $supplier->supplier_id);
- }
- }
- $goods = $goods->select('goods_id', 'goods_id as id', 'goods_name as name', 'join_goods_category_id as pid', 'goods_attribute_json', 'goods_classify', 'goods_sales_price', 'goods_cover', 'goods_running.goods_running_storage')
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->get()
- ->toArray();
- foreach ($goods as &$good) {
- $good['goods_cover'] = getenv('STORAGE_DOMAIN') . $good['goods_cover'];
- $good['goods_running_storage'] = intval($good['goods_running_storage']);
- $good['nbr'] = 0;
- if (!empty($good['sku'])) {
- foreach ($good['sku'] as $key => $sku) {
- if (!empty($sku['goods_sku_specs_json'])) {
- $good['sku'][$key]['goods_sku_specs_json'] = json_decode($sku['goods_sku_specs_json']);
- $skuName = '';
- foreach ($good['sku'][$key]['goods_sku_specs_json'] as $specsKey => $skuSpecs) {
- $keyStr = ($specsKey == '规格') ? '' : ($specsKey . ':');
- if (is_array($skuSpecs)) {
- $skuName = $skuName . $keyStr . ' ' . implode(' ', $skuSpecs) . '; ';
- } else {
- $skuName = $skuName . $keyStr . ' ' . $skuSpecs . '; ';
- }
- }
- $good['sku'][$key]['sku_name'] = rtrim($skuName, '; ');
- }
- }
- } else {
- $good['sku'] = [];
- }
- $good['premisses'] = [];
- if (!empty($good['goods_attribute_json'])) {
- $attributeJson = json_decode($good['goods_attribute_json'], true);
- if (isset($attributeJson['premisses'])) {
- $premisses = SysDept::when(!empty($attributeJson['premisses']), function ($query) use ($attributeJson) {
- $query->whereIn('dept_id', $attributeJson['premisses']);
- })->where('dept_category', '营业场所')
- ->select('dept_id', 'dept_name')
- ->get();
- $good['premisses'] = $premisses;
- }
- }
- }
- $data = array_merge($data, $goods);
- $tree = new Tree($data);
- $cascaderData = $tree->getTree();
- foreach ($cascaderData as $key1 => $cascader1) {
- if (isset($cascader1['children'])) {
- foreach ($cascader1['children'] as $key2 => $cascader2) {
- if (isset($cascader2['children'])) {
- foreach ($cascader2['children'] as $key3 => $cascader3) {
- if (isset($cascader3['children'])) {
- foreach ($cascader3['children'] as $key4 => $cascader4) {
- if (!isset($cascader4['goods_id'])) {
- unset($cascaderData[$key1]['children'][$key2]['children'][$key3]['children'][$key4]);
- }
- if (isset($cascader4['goods_id']) && empty($cascader4['sku'])) {
- unset($cascaderData[$key1]['children'][$key2]['children'][$key3]['children'][$key4]);
- }
- }
- } else if (!isset($cascader3['goods_id'])) {
- unset($cascaderData[$key1]['children'][$key2]['children'][$key3]);
- }
- if (isset($cascader3['goods_id']) && empty($cascader3['sku'])) {
- unset($cascaderData[$key1]['children'][$key2]['children'][$key3]);
- continue;
- }
- if (isset($cascader3['children']) && count($cascaderData[$key1]['children'][$key2]['children']) == 0) {
- unset($cascaderData[$key1]['children'][$key2]);
- }
- if (isset($cascader3['children']) && count($cascaderData[$key1]['children'][$key2]['children'][$key3]['children']) > 0) {
- $cascaderData[$key1]['children'][$key2]['children'][$key3]['children'] = array_values($cascaderData[$key1]['children'][$key2]['children'][$key3]['children']);
- }
- }
- } else if (!isset($cascader2['goods_id'])) {
- unset($cascaderData[$key1]['children'][$key2]);
- }
- if (isset($cascader2['goods_id']) && empty($cascader2['sku'])) {
- unset($cascaderData[$key1]['children'][$key2]);
- continue;
- }
- if (isset($cascader2['children']) && count($cascaderData[$key1]['children'][$key2]['children']) == 0) {
- unset($cascaderData[$key1]['children'][$key2]);
- }
- if (isset($cascader2['children']) && isset($cascaderData[$key1]['children'][$key2]) && count($cascaderData[$key1]['children'][$key2]['children']) > 0) {
- $cascaderData[$key1]['children'][$key2]['children'] = array_values($cascaderData[$key1]['children'][$key2]['children']);
- }
- }
- } else if (!isset($cascader1['goods_id'])) {
- unset($cascaderData[$key1]);
- }
- if (isset($cascader1['goods_id']) && empty($cascader1['sku'])) {
- unset($cascaderData[$key1]);
- continue;
- }
- if (isset($cascader1['children']) && count($cascaderData[$key1]['children']) == 0) {
- unset($cascaderData[$key1]);
- }
- if (isset($cascader1['children']) && isset($cascaderData[$key1]) && count($cascaderData[$key1]['children']) > 0) {
- $cascaderData[$key1]['children'] = array_values($cascaderData[$key1]['children']);
- }
- }
- $cascaderData = array_values($cascaderData);
- return json_success('success', $cascaderData);
- }
- /**
- * @Desc 商品详情
- * @Author Gorden
- * @Date 2024/3/28 10:25
- *
- * @param $goodsId
- * @return Response
- */
- public static function info($goodsId)
- {
- try {
- // 商品主表
- $main = Goods::with('category')->where('goods_id', $goodsId)->first();
- if (!empty($main)) {
- $main = $main->toArray();
- $main['goods_sku_json'] = json_decode($main['goods_sku_json'], true);
- $main['specList'] = [];
- foreach ($main['goods_sku_json'] as $key => $sku) {
- $main['specList'][] = [
- 'label' => $key,
- 'tags' => $sku
- ];
- }
- } else {
- $main = [];
- }
- // 详情表
- $detail = GoodsDetail::where('join_detail_goods_id', $goodsId)->first();
- if (!empty($detail)) {
- $detail = $detail->toArray();
- } else {
- $detail = [];
- }
- // 标签表
- $label = GoodsLabel::where('join_label_goods_id', $goodsId)->first();
- if (!empty($label)) {
- $label = $label->toArray();
- } else {
- $label = [];
- }
- // Running表
- $running = GoodsRunning::where('join_running_goods_id', $goodsId)->first();
- if (!empty($running)) {
- $running = $running->toArray();
- if (!empty($running['goods_running_off_json']) && is_json($running['goods_running_off_json'])) {
- $goodsRunningOffJson = json_decode($running['goods_running_off_json'], true);
- $running['goods_off_addtimes'] = isset($goodsRunningOffJson['time']) ? date("Y-m-d H:i", $goodsRunningOffJson['time']) : '';
- }
- $running['goods_running_storage'] = !empty($running['goods_running_storage']) ? intval($running['goods_running_storage']) : '';
- $running['goods_running_sale'] = !empty($running['goods_running_sale']) ? intval($running['goods_running_sale']) : '';
- } else {
- $running = [];
- }
- // Sku表
- $skus = GoodsSku::where('join_sku_goods_id', $goodsId)->where('goods_sku_status', 'ON')->get();
- if (!empty($skus)) {
- $skus = $skus->toArray();
- $submitList = [];
- foreach ($skus as $key => $sku) {
- $skuSpecsJson = json_decode($sku['goods_sku_specs_json'], true);
- $skuSpecs = '';
- $skuNameValue = [];
- $i = 1;
- foreach ($skuSpecsJson as $k => $item) {
- if (is_array($item)) {
- $item = implode(',', $item);
- }
- $skuSpecs = $skuSpecs . $item . ',';
- $skuNameKey = 'skuName' . $i;
- $skuValueKey = 'skuValue' . $i;
- $skuNameValue[$skuNameKey] = $k;
- $skuNameValue[$skuValueKey] = $item;
- $skuNameValue[$k] = $item;
- $i++;
- }
- $storage = json_decode($sku['goods_sku_storage_json'], true);
- $priceStorage = [
- 'sku_id' => $sku['goods_sku_id'],
- 'sku' => rtrim($skuSpecs, ',') ?? '',
- 'stock' => $storage['storage'] ?? '',
- 'price' => $sku['goods_sku_sales_price'] ?? '',
- ];
- $submitList[] = array_merge($skuNameValue, $priceStorage);
- }
- $skus['submitList'] = $submitList;
- } else {
- $skus = [];
- }
- // 供应商表
- $supplier = [];
- if (isset($main['join_goods_supplier_id']) && !empty($main['join_goods_supplier_id'])) {
- $supplierModel = Supplier::where('supplier_id', $main['join_goods_supplier_id'])->select('supplier_id', 'supplier_name')->first();
- if (!empty($supplierModel)) {
- $supplier = $supplierModel->toArray();
- }
- }
- // 合并数据
- $data = array_merge($main, $detail, $label, $running, ['sku' => $skus], ['supplier' => $supplier]);
- $data['goods_sku_json_label'] = [];
- $data['goods_label'] = !empty($data['goods_label']) ? explode(',', $data['goods_label']) : [];
- $data['goods_json'] = $data['goods_json'] ? json_decode($data['goods_json'], true) : [];
- $data['goods_cover'] = getenv('STORAGE_DOMAIN') . $data['goods_cover'];
- if (!empty($data['goods_category']) && $data['goods_category'] == 'INDEX') {
- $data['goods_recommend_index'] = 'INDEX';
- }
- // 创建者
- $data['creator_username'] = '';
- if (!empty($data['creator_user_id'])) {
- $data['creator_username'] = SysUser::where('user_id', $data['creator_user_id'])->value('user_name');
- }
- $data['updator_username'] = '';
- if (!empty($data['updator_user_id'])) {
- $data['updator_username'] = SysUser::where('user_id', $data['updator_user_id'])->value('user_name');
- }
- if (!empty($data['goods_detail_slider_json'])) {
- $data['goods_detail_slider_json'] = json_decode($data['goods_detail_slider_json'], true);
- // ……
- if (isset($data['goods_detail_slider_json']['slider'])) {
- $data['goods_detail_slider_json'] = explode(',', $data['goods_detail_slider_json']['slider']);
- }
- $slider = '';
- foreach ($data['goods_detail_slider_json'] as $item) {
- $slider .= getenv('STORAGE_DOMAIN') . $item . ',';
- }
- $data['goods_detail_slider_json'] = rtrim($slider, ',');
- }
- $extendJson = [];
- if (!empty($data['goods_attribute_json'])) {
- $extendJson = json_decode($data['goods_attribute_json'], true);
- $data['goods_attribute_json'] = $extendJson;
- if (isset($extendJson['premisses'])) {
- $data['goods_premisses'] = $extendJson['premisses'];
- $data['goods_premisses_str'] = SysDept::whereIn('dept_id', $extendJson['premisses'])->pluck('dept_name');
- }
- if (isset($extendJson['bg'])) {
- $data['goods_theme_color'] = $extendJson['bg'];
- }
- if (isset($extendJson['icon'])) {
- $data['goods_theme_icon'] = getenv('STORAGE_DOMAIN') . $extendJson['icon'];
- }
- if (isset($extendJson['service_premises_id'])) {
- $data['goods_service_premises'] = $extendJson['service_premises_id'];
- }
- }
- if (!empty($extendJson['coupon'])) {
- $data['coupon_list'] = $extendJson['coupon'];
- }
- $data['express_json'] = [];
- if (!empty($data['goods_express_json'])) {
- $goodsExpressJson = json_decode($data['goods_express_json'], true);
- if (isset($goodsExpressJson['express']) && $goodsExpressJson['express'] == 'Y') {
- $data['express_json'][] = 'express';
- }
- if (isset($goodsExpressJson['self']) && $goodsExpressJson['self'] == 'Y') {
- $data['express_json'][] = 'self';
- }
- if (isset($goodsExpressJson['arrival']) && $goodsExpressJson['arrival'] == 'Y') {
- $data['express_json'][] = 'arrival';
- }
- }
- $data['appointment_times'] = [];
- if ($data['is_support_appointment'] == 'Y' && isset($extendJson['dates'])) {
- $data['dates'] = $extendJson['dates'] ?? [];
- if (isset($extendJson['times'])) {
- $times = [];
- foreach ($extendJson['times'] as $time) {
- if (!empty($time['duration'])) {
- $startEndTime = explode('-', $time['duration']);
- $times[] = [
- 'person' => $time['person'],
- 'appointmentTimeStart' => $startEndTime[0],
- 'appointmentTimeEnd' => $startEndTime[1],
- ];
- }
- }
- $data['appointment_times'] = $times;
- }
- if (isset($extendJson['time'])) {
- $extendJsonTime = explode('至', $extendJson['time']);
- if (isset($extendJsonTime[0]) && isset($extendJsonTime[1])) {
- $data['work_time'] = [
- date('Y-m-d H:i:s', strtotime(date('Y-m-d ') . $extendJsonTime[0])),
- date('Y-m-d H:i:s', strtotime(date('Y-m-d ') . $extendJsonTime[1])),
- ];
- }
- }
- // if (isset($extendJson['teachers'])){
- // $data['teachers'] = $extendJson['teachers'];
- // }
- // if (isset($extendJson['address'])) {
- // $data['address'] = $extendJson['address'];
- // }
- // if (isset($extendJson['min-count'])){
- // $data['min_count'] = $extendJson['min-count'];
- // }
- // if (isset($extendJson['position'])) {
- // $data['position'] = $extendJson['position'];
- // }
- if (isset($extendJson['label'])) {
- $data['appointment_label'] = $extendJson['label'];
- }
- }
- if (isset($extendJson['month']) && $data['is_support_appointment'] == 'Y') {
- $times = [];
- foreach ($extendJson['month'] as $monKey => $months) {
- foreach ($months as $day => $person) {
- $times[] = [
- 'days' => date('Y-m-d', strtotime($monKey . $day)),
- 'person' => $person
- ];
- }
- }
- $data['appointment_times'] = $times;
- $data['travel_begin'] = $extendJson['travel-begin'];
- $data['travel_day'] = $extendJson['travel-day'];
- $data['travel_night'] = $extendJson['travel-night'];
- $data['travel_trans'] = $extendJson['travel-trans'];
- }
- if (!empty($data['goods_json']) && $data['join_goods_category_id'] == 65) {
- // foreach ($data['goods_json'] as $key => $datum) {
- // $data['goods_json'][$key]['color'] = rgbToHex($datum['color']);
- // }
- } elseif (!empty($data['goods_json']) && $data['join_goods_category_id'] == 43) {
- $goodsJsonNew = [];
- foreach ($data['goods_json'] as $key1 => $item1) {
- $itemsNew = [];
- if (isset($item1['items'])) {
- foreach ($item1['items'] as $key2 => $item2) {
- $itemsNew[] = [
- 'key' => $key2,
- 'params' => $item2
- ];
- }
- }
- $goodsJsonNew[] = [
- 'title' => $key1,
- 'service' => $item1['service'] ?? '',
- 'items' => $itemsNew
- ];
- }
- $data['goods_json'] = $goodsJsonNew;
- }
- if (isset($extendJson['teachers'])) {
- $data['teachers'] = $extendJson['teachers'];
- }
- if (isset($extendJson['address'])) {
- $data['address'] = $extendJson['address'];
- }
- if (isset($extendJson['min-count'])) {
- $data['min_count'] = $extendJson['min-count'];
- }
- if (isset($extendJson['max-limit'])) {
- $data['max_limit'] = $extendJson['max-limit'];
- }
- if (isset($extendJson['position'])) {
- $data['position'] = $extendJson['position'];
- }
- $data['goods_on_addtimes'] = date('Y-m-d\TH:i:s.u\Z', $data['goods_on_addtimes'] - 60 * 60 * 8);
- // 详情表数据
- if (!empty($data['goods_detail_specs_json'])) {
- $specsJson = json_decode($data['goods_detail_specs_json'], true);
- foreach ($specsJson as $itemSpecsJson) {
- if (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '课时') {
- $data['curriculum']['period'] = $itemSpecsJson['val'];
- } elseif (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '群体') {
- $data['curriculum']['group'] = $itemSpecsJson['val'];
- } elseif (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '课程') {
- $data['curriculum']['course'] = $itemSpecsJson['val'];
- }
- }
- }
- return json_success('', $data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- return json_fail("查询错误~");
- }
- }
- /**
- * @Desc 商品详情
- * @Author Gorden
- * @Date 2024/3/28 10:25
- *
- * @param $goodsId
- * @return Response
- */
- public static function newCustomerInfo($goodsId)
- {
- try {
- // 商品主表
- $main = Goods::with('category')->where('goods_id', $goodsId)->first();
- if (!empty($main)) {
- $main = $main->toArray();
- $main['goods_sku_json'] = json_decode($main['goods_sku_json'], true);
- $main['specList'] = [];
- foreach ($main['goods_sku_json'] as $key => $sku) {
- $main['specList'][] = [
- 'label' => $key,
- 'tags' => $sku
- ];
- }
- } else {
- $main = [];
- }
- // 详情表
- $detail = GoodsDetail::where('join_detail_goods_id', $goodsId)->first();
- if (!empty($detail)) {
- $detail = $detail->toArray();
- } else {
- $detail = [];
- }
- // 标签表
- $label = GoodsLabel::where('join_label_goods_id', $goodsId)->first();
- if (!empty($label)) {
- $label = $label->toArray();
- } else {
- $label = [];
- }
- // Running表
- $running = GoodsRunning::where('join_running_goods_id', $goodsId)->first();
- if (!empty($running)) {
- $running = $running->toArray();
- if (!empty($running['goods_running_off_json']) && is_json($running['goods_running_off_json'])) {
- $goodsRunningOffJson = json_decode($running['goods_running_off_json'], true);
- $running['goods_off_addtimes'] = isset($goodsRunningOffJson['time']) ? date("Y-m-d H:i", $goodsRunningOffJson['time']) : '';
- }
- $running['goods_running_storage'] = !empty($running['goods_running_storage']) ? intval($running['goods_running_storage']) : '';
- $running['goods_running_sale'] = !empty($running['goods_running_sale']) ? intval($running['goods_running_sale']) : '';
- } else {
- $running = [];
- }
- // Sku表
- $skus = GoodsSku::where('join_sku_goods_id', $goodsId)->where('goods_sku_status', 'ON')->get();
- if (!empty($skus)) {
- $skus = $skus->toArray();
- $submitList = [];
- foreach ($skus as $key => $sku) {
- $skuSpecsJson = json_decode($sku['goods_sku_specs_json'], true);
- $skuSpecs = '';
- $skuNameValue = [];
- $i = 1;
- foreach ($skuSpecsJson as $k => $item) {
- if (is_array($item)) {
- $item = implode(',', $item);
- }
- $skuSpecs = $skuSpecs . $item . ',';
- $skuNameKey = 'skuName' . $i;
- $skuValueKey = 'skuValue' . $i;
- $skuNameValue[$skuNameKey] = $k;
- $skuNameValue[$skuValueKey] = $item;
- $skuNameValue[$k] = $item;
- $i++;
- }
- $storage = json_decode($sku['goods_sku_storage_json'], true);
- $priceStorage = [
- 'sku_id' => $sku['goods_sku_id'],
- 'sku' => rtrim($skuSpecs, ',') ?? '',
- 'stock' => $storage['storage'] ?? '',
- 'price' => $sku['goods_sku_sales_price'] ?? '',
- ];
- $submitList[] = array_merge($skuNameValue, $priceStorage);
- }
- $skus['submitList'] = $submitList;
- } else {
- $skus = [];
- }
- // 合并数据
- $data = array_merge($main, $detail, $label, $running, ['sku' => $skus]);
- $data['goods_sku_json_label'] = [];
- $data['goods_label'] = !empty($data['goods_label']) ? explode(',', $data['goods_label']) : [];
- $data['goods_json'] = $data['goods_json'] ? json_decode($data['goods_json'], true) : [];
- $data['goods_cover'] = getenv('STORAGE_DOMAIN') . $data['goods_cover'];
- if (!empty($data['goods_category']) && $data['goods_category'] == 'INDEX') {
- $data['goods_recommend_index'] = 'INDEX';
- }
- // 创建者
- $data['creator_username'] = '';
- if (!empty($data['creator_user_id'])) {
- $data['creator_username'] = SysUser::where('user_id', $data['creator_user_id'])->value('user_name');
- }
- if (!empty($data['goods_detail_slider_json'])) {
- $data['goods_detail_slider_json'] = json_decode($data['goods_detail_slider_json'], true);
- // ……
- if (isset($data['goods_detail_slider_json']['slider'])) {
- $data['goods_detail_slider_json'] = explode(',', $data['goods_detail_slider_json']['slider']);
- }
- $slider = '';
- foreach ($data['goods_detail_slider_json'] as $item) {
- $slider .= getenv('STORAGE_DOMAIN') . $item . ',';
- }
- $data['goods_detail_slider_json'] = rtrim($slider, ',');
- }
- $extendJson = [];
- if (!empty($data['goods_attribute_json'])) {
- $extendJson = json_decode($data['goods_attribute_json'], true);
- $data['goods_attribute_json'] = $extendJson;
- }
- if (!empty($extendJson['coupon'])) {
- $data['coupon_list'] = $extendJson['coupon'];
- }
- $data['express_json'] = [];
- if (!empty($data['goods_express_json'])) {
- $goodsExpressJson = json_decode($data['goods_express_json'], true);
- if (isset($goodsExpressJson['express']) && $goodsExpressJson['express'] == 'Y') {
- $data['express_json'][] = 'express';
- }
- if (isset($goodsExpressJson['self']) && $goodsExpressJson['self'] == 'Y') {
- $data['express_json'][] = 'self';
- }
- if (isset($goodsExpressJson['arrival']) && $goodsExpressJson['arrival'] == 'Y') {
- $data['express_json'][] = 'arrival';
- }
- }
- // 详情表数据
- if (!empty($data['goods_detail_specs_json'])) {
- $specsJson = json_decode($data['goods_detail_specs_json'], true);
- foreach ($specsJson as $itemSpecsJson) {
- if (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '课时') {
- $data['curriculum']['period'] = $itemSpecsJson['val'];
- } elseif (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '群体') {
- $data['curriculum']['group'] = $itemSpecsJson['val'];
- } elseif (isset($itemSpecsJson['key']) && $itemSpecsJson['key'] == '课程') {
- $data['curriculum']['course'] = $itemSpecsJson['val'];
- }
- }
- }
- return json_success('', $data);
- } catch (\Exception $e) {
- dump($e->getMessage());
- return json_fail("查询错误~");
- }
- }
- public static function infoPackage($goodsId)
- {
- try {
- // 商品主表
- $main = Goods::with('category')->where('goods_id', $goodsId)->first();
- if (!empty($main)) {
- $main = $main->toArray();
- $main['goods_sku_json'] = json_decode($main['goods_sku_json'], true);
- $main['specList'] = [];
- foreach ($main['goods_sku_json'] as $key => $sku) {
- $main['specList'][] = [
- 'label' => $key,
- 'tags' => $sku
- ];
- }
- } else {
- $main = [];
- }
- // 详情表
- $detail = GoodsDetail::where('join_detail_goods_id', $goodsId)->first();
- if (!empty($detail)) {
- $detail = $detail->toArray();
- } else {
- $detail = [];
- }
- // 标签表
- $label = GoodsLabel::where('join_label_goods_id', $goodsId)->first();
- if (!empty($label)) {
- $label = $label->toArray();
- } else {
- $label = [];
- }
- // Running表
- $running = GoodsRunning::where('join_running_goods_id', $goodsId)->first();
- if (!empty($running)) {
- $running = $running->toArray();
- if (!empty($running['goods_running_off_json']) && is_json($running['goods_running_off_json'])) {
- $goodsRunningOffJson = json_decode($running['goods_running_off_json'], true);
- $running['goods_off_addtimes'] = isset($goodsRunningOffJson['time']) ? date("Y-m-d H:i", $goodsRunningOffJson['time']) : '';
- }
- } else {
- $running = [];
- }
- // 组件表
- $component = GoodsComponent::where('join_component_master_goods_id', $goodsId)->get()->toArray();
- $componentArr['join_component_goods_id'] = [];
- $componentArr['goodsContentList'] = [];
- if ($component) {
- $ids = [];
- $contentList = [];
- foreach ($component as $item) {
- if (empty($item['join_component_goods_id'])) {
- continue;
- }
- $skus = GoodsSku::with([
- 'goods' => function ($query) {
- $query->select('goods_id', 'goods_cover');
- }
- ])->where('join_sku_goods_id', $item['join_component_goods_id'])->where('goods_sku_status', 'ON')
- ->select('goods_sku_id', 'join_sku_goods_id', 'goods_sku_specs_json', 'goods_sku_sales_price')
- ->get()
- ->toArray();
- $goodsCover = '';
- foreach ($skus as $key => $sku2) {
- if (!empty($sku2['goods_sku_specs_json'])) {
- $skus[$key]['goods_sku_specs_json'] = json_decode($sku2['goods_sku_specs_json'], true);
- $skuName = '';
- foreach ($skus[$key]['goods_sku_specs_json'] as $specsKey => $skuSpecs) {
- if (is_array($skuSpecs)) {
- $skuName = $skuName . implode(' ', $skuSpecs) . ',';
- } else {
- $skuName = $skuName . $skuSpecs . ',';
- }
- }
- $skus[$key]['sku_name'] = rtrim($skuName, ',');
- }
- if (!empty($sku2['goods'])) {
- $goodsCover = getenv('STORAGE_DOMAIN') . $sku2['goods']['goods_cover'];
- }
- }
- $ids[] = $item['join_component_goods_id'];
- $configJson = json_decode($item['goods_component_json'], true);
- $contentList[] = [
- 'goods_id' => $item['join_component_goods_id'],
- 'goods_name' => $configJson['goods_name'] ?? '',
- 'goods_sales_price' => $item['goods_component_price'],
- 'nbr' => $configJson['nbr'] ?? 0,
- 'sku_id' => $configJson['sku_id'] ?? '',
- 'sku_name' => !empty($skuName) ? rtrim($skuName, ',') : '',
- 'skus' => $skus,
- 'goods_cover' => $goodsCover
- ];
- }
- $componentArr['join_component_goods_id'] = $ids;
- $componentArr['goodsContentList'] = $contentList;
- }
- // 合并数据
- $data = array_merge($main, $detail, $label, $running, $componentArr);
- $data['goods_sku_json_label'] = [];
- // 创建者
- $data['creator_username'] = '';
- if (!empty($data['creator_user_id'])) {
- $data['creator_username'] = SysUser::where('user_id', $data['creator_user_id'])->value('user_name');
- }
- $data['updator_username'] = '';
- if (!empty($data['updator_user_id'])) {
- $data['updator_username'] = SysUser::where('user_id', $data['updator_user_id'])->value('user_name');
- }
- $data['goods_label'] = !empty($data['goods_label']) ? explode(',', $data['goods_label']) : [];
- $data['goods_cover'] = getenv('STORAGE_DOMAIN') . $data['goods_cover'];
- if (!empty($data['goods_detail_slider_json'])) {
- $data['goods_detail_slider_json'] = json_decode($data['goods_detail_slider_json'], true);
- $slider = '';
- foreach ($data['goods_detail_slider_json'] as $item) {
- $slider .= getenv('STORAGE_DOMAIN') . $item . ',';
- }
- $data['goods_detail_slider_json'] = rtrim($slider, ',');
- }
- if (!empty($data['goods_attribute_json'])) {
- $goodsAttributeJson = json_decode($data['goods_attribute_json'], true);
- $data['goods_attribute_json'] = $goodsAttributeJson;
- if (isset($goodsAttributeJson['premisses'])) {
- $data['goods_premisses'] = $goodsAttributeJson['premisses'];
- $data['goods_premisses_str'] = SysDept::whereIn('dept_id', $goodsAttributeJson['premisses'])->pluck('dept_name');
- }
- // if (!empty($goodsAttributeJson['coupon'])) {
- // $data['coupon_list'] = $goodsAttributeJson['coupon'];
- // }
- $data['couponContentList'] = [];
- $data['coupon_id'] = [];
- if (!empty($goodsAttributeJson['coupon'])) {
- foreach ($goodsAttributeJson['coupon'] as $key => $coupon) {
- $data['coupon_id'][] = $key;
- $data['couponContentList'][] = [
- 'coupon_id' => $key,
- 'coupon_name' => $coupon['name'],
- 'nbr' => $coupon['num']
- ];
- }
- }
- }
- $data['goods_on_addtimes'] = date('Y-m-d\TH:i:s.u\Z', $data['goods_on_addtimes'] - 60 * 60 * 8);
- return json_success('', $data);
- } catch (\Exception $e) {
- dump($e->getTrace());
- return json_fail("查询错误~");
- }
- }
- /**
- * @Desc 添加商品
- * @Author Gorden
- * @Date 2024/3/11 10:20
- *
- * @param $params
- * @return Response
- */
- public static function insert($params): Response
- {
- Db::beginTransaction();
- try {
- $params['goods_id'] = "GD" . date('ymdHi') . random_string(4, 'up');
- // 主表
- self::mainInsert($params);
- // 商品详情表
- self::detailInsert($params);
- // 商品标签表
- self::labelInsert($params);
- // 产品运行控制信息表
- self::goodsRunningInsert($params);
- // sku表
- self::goodsSkuSet($params, 'insert');
- // 待上架状态,上架时间大于当前时间
- if ($params['goods_status'] == 'PENDING' && strtotime($params['goods_on_addtimes']) > time()) {
- $redis = Redis::connection();
- $key = date('YmdHi', strtotime($params['goods_on_addtimes']));
- $redis->sAdd(Goods::LISTING_KEY_PREFIX . $key, $params['goods_id']);
- }
- // 自动下架
- if (!empty($params['goods_running_off_type']) && $params['goods_running_off_type'] == 'T' && !empty($params['goods_off_addtimes'])) {
- $redis = Redis::connection();
- $key = Goods::LISTING_OFF_KEY_PREFIX . date('YmdHi', strtotime($params['goods_off_addtimes']));
- $redis->sAdd($key, $params['goods_id']);
- }
- Db::commit();
- } catch (\PDOException $e) {
- Db::rollBack();
- dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
- return json_fail('数据写入失败~');
- } catch (BusinessException $e) {
- Db::rollBack();
- dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getTrace());
- return json_fail('数据写入失败~');
- }
- _syslog("添加商品", "商品名【" . $params['goods_name'] . "】");
- return json_success('success');
- }
- public static function insertRecharge($params)
- {
- try {
- Db::beginTransaction();
- $goods = new Goods();
- $goods->goods_id = "GD" . date('ymdHi') . random_string(4, 'up');
- $goods->join_goods_category_id = 59;
- $goods->goods_classify = 'RECHARGE';
- $goods->goods_status = $params['goods_status'];
- $goods->goods_sort = $params['goods_sort'];
- $goods->goods_category = $params['goods_category'];
- $goods->goods_name = $params['goods_name'];
- $goods->goods_market_price = $params['goods_sales_price'];
- $goods->goods_sales_price = $params['goods_sales_price'];
- $goods->goods_sku_json = json_encode(['规格' => [$params['goods_sales_price'] . '元']]);
- $goods->goods_attribute_json = json_encode(['added' => ['nbr' => $params['goods_rate'] / 100, 'mode' => 'rate'], 'min-count' => 1]);
- $goods->goods_cover = '/images/app/common/null-service.png';
- $goods->goods_process_json = json_encode(['mode' => 'do_shopping']);
- $goods->goods_addtimes = time();
- $goods->save();
- $sku = new GoodsSku();
- $sku->join_sku_goods_id = $goods->goods_id;
- $sku->goods_sku_status = $params['goods_status'];
- $sku->goods_sku_specs_json = json_encode(['规格' => $params['goods_sales_price'] . '元']);
- $sku->goods_sku_market_price = $params['goods_sales_price'];
- $sku->goods_sku_sales_price = $params['goods_sales_price'];
- $sku->goods_sku_storage_json = json_encode(['storage' => 9999]);
- $sku->save();
- Db::commit();
- return json_success('success');
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail('添加充值产品失败');
- }
- }
- public static function updateRecharge($params)
- {
- try {
- Db::beginTransaction();
- $goods = Goods::where('goods_id', $params['goods_id'])->first();
- if (!$goods) {
- return json_fail("数据异常");
- }
- $goods->goods_market_price = $params['goods_sales_price'];
- $goods->goods_sales_price = $params['goods_sales_price'];
- $goods->goods_status = $params['goods_status'];
- $goods->goods_sku_json = json_encode(['规格' => [$params['goods_sales_price'] . '元']]);
- $goods->goods_sort = $params['goods_sort'];
- $goods->goods_updatetimes = time();
- $goods->updator_user_id = JwtToken::getCurrentId();
- if (!empty($goods->goods_attribute_json)) {
- $attributeJson = json_decode($goods->goods_attribute_json, true);
- $attributeJson['added']['nbr'] = $params['goods_rate'] / 100;
- $goods->goods_attribute_json = json_encode($attributeJson);
- }
- $goods->save();
- $sku = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->where('goods_sku_status', 'ON')->first();
- $sku->goods_sku_status = $params['goods_status'];
- $sku->goods_sku_specs_json = json_encode(['规格' => $params['goods_sales_price'] . '元']);
- $sku->goods_sku_market_price = $params['goods_sales_price'];
- $sku->goods_sku_sales_price = $params['goods_sales_price'];
- $sku->save();
- Db::commit();
- return json_success("success");
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- return json_fail('编辑充值产品失败');
- }
- }
- public static function insertPackage($params): Response
- {
- Db::beginTransaction();
- try {
- $params['goods_id'] = "GD" . date('ymdHi') . random_string(4, 'up');
- // 主表
- self::mainInsert($params);
- // 商品详情表
- self::detailInsert($params);
- // 套包组件表
- self::componentUpdate($params, 'insert');
- // 商品标签表
- self::labelInsert($params);
- // 产品运行控制信息表
- self::goodsRunningInsert($params);
- // sku表
- // self::goodsSkuSet($params, 'insert');
- // 待上架状态,上架时间大于当前时间
- if ($params['goods_status'] == 'PENDING' && strtotime($params['goods_on_addtimes']) > time()) {
- $redis = Redis::connection();
- $key = date('YmdHi', strtotime($params['goods_on_addtimes']));
- $redis->sAdd(Goods::LISTING_KEY_PREFIX . $key, $params['goods_id']);
- }
- Db::commit();
- } catch (BusinessException $e) {
- Db::rollBack();
- dump($e->getMessage());
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getTrace());
- return json_fail('数据写入失败~');
- }
- _syslog("添加套餐", "商品名【" . $params['goods_name'] . "】");
- return json_success('success');
- }
- public static function update($params)
- {
- Db::beginTransaction();
- try {
- // 主表
- self::mainUpdate($params);
- // 商品详情表
- self::detailUpdate($params);
- // 商品标签表
- self::labelUpdate($params);
- // 产品运行控制信息表
- self::goodsRunningUpdate($params);
- // sku表
- self::goodsSkuSet($params, 'update');
- Db::commit();
- } catch (BusinessException $e) {
- Db::rollBack();
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail('数据更新失败~');
- }
- _syslog("编辑商品", "商品名【" . $params['goods_name'] . "】" ?? "商品ID:【" . $params['goods_id'] . "】");
- return json_success('success');
- }
- public static function changeStatus($params)
- {
- try {
- Goods::where('goods_id', $params['goods_id'])->update(['goods_status' => $params['goods_status']]);
- return json_success('修改成功');
- } catch (\Exception $e) {
- return json_fail('修改状态失败');
- }
- }
- public static function updatePackage($params)
- {
- Db::beginTransaction();
- try {
- // 主表
- self::mainUpdate($params);
- // 商品详情表
- self::detailUpdate($params);
- // 套包组件表
- self::componentUpdate($params, 'update');
- // 商品标签表
- self::labelUpdate($params);
- // 产品运行控制信息表
- self::goodsRunningUpdate($params);
- // sku表
- // self::goodsSkuSet($params, 'update');
- Db::commit();
- } catch (BusinessException $e) {
- Db::rollBack();
- return json_fail($e->getMessage());
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getTrace());
- return json_fail('数据更新失败~');
- }
- _syslog("编辑套餐", "商品名【" . $params['goods_name'] . "】" ?? "商品ID:【" . $params['goods_id'] . "】");
- return json_success('success');
- }
- /**
- * @Desc 删除商品
- * @Author Gorden
- * @Date 2024/3/28 13:20
- *
- * @param $ids
- * @return Response
- */
- public static function delete($ids)
- {
- if (!$ids) {
- return json_fail("数据错误~");
- }
- if (!is_array($ids)) {
- $ids = [$ids];
- }
- $goods = Goods::whereIn('goods_id', $ids)->get()->toArray();
- if (!$goods) {
- return json_fail("数据错误~");
- }
- // 是否在套包里
- if (GoodsComponent::whereIn('join_component_goods_id', $ids)->exists()) {
- return json_fail("当前商品存在于套包中,请先在套包中删除");
- }
- // 是否已被购买过
- if (OrderSheet::whereIn('join_sheet_goods_id', $ids)->exists()) {
- return json_fail("当前商品已有购买历史,如不在APP显示,请选择【下架】操作");
- }
- // 是否预约过
- if (Appointment::whereIn('join_appointment_goods_id', $ids)->exists()) {
- return json_fail("当前商品已有预约历史,如不在APP显示,请选择【下架】操作");
- }
- Db::beginTransaction();
- try {
- Goods::whereIn('goods_id', $ids)->delete();
- GoodsDetail::whereIn('join_detail_goods_id', $ids)->delete();
- GoodsLabel::whereIn('join_label_goods_id', $ids)->delete();
- GoodsRunning::whereIn('join_running_goods_id', $ids)->delete();
- GoodsSku::whereIn('join_sku_goods_id', $ids)->delete();
- Db::commit();
- _syslog("删除商品 / 套餐", "ID:【" . implode(',', $ids) . "】", $goods);
- return json_success("商品删除成功");
- } catch (\Exception $e) {
- Db::rollBack();
- return json_fail("商品删除失败~");
- }
- }
- /**
- * @Desc 商品主表
- * @Author Gorden
- * @Date 2024/3/11 11:20
- *
- * @param $params
- * @return mixed|string
- * @throws BusinessException
- */
- public static function mainInsert($params)
- {
- if (!empty($params['goods_cover'])) {
- $params['goods_cover'] = str_replace(getenv('STORAGE_DOMAIN'), '', $params['goods_cover']);
- }
- // 如果产品是待处理状态
- if ($params['goods_status'] == 'PENDING') {
- if (strtotime($params['goods_on_addtimes']) <= time()) {
- $params['goods_status'] = 'ON';
- }
- }
- $category = SysCategory::where('category_id', $params['join_goods_category_id'])->first();
- if (!$category) {
- throw new BusinessException("产品分类不存在~");
- }
- if (empty($params['goods_category'])) {
- $params['goods_category'] = $category->category_classify;
- }
- try {
- $model = new Goods();
- $model->goods_id = $params['goods_id'];
- $model->join_goods_category_id = $params['join_goods_category_id'] ?? 0;
- $model->join_goods_supplier_id = $params['join_goods_supplier_id'] ?? 0;
- $model->goods_classify = $params['goods_classify'] ?? '';
- $model->goods_status = $params['goods_status'] ?? '';
- $model->goods_category = $params['goods_category'] ?? '';
- // $model->goods_prefix = $params['goods_prefix'] ?? 】($category->category_name ? '【' . $category->category_name . '' : '');
- $model->goods_prefix = $params['goods_prefix'] ?? '';
- $model->goods_name = $params['goods_name'];
- $model->goods_market_price = $params['goods_market_price'] ?? 0;
- $model->goods_sales_price = $params['goods_sales_price'] ?? 0;
- $model->goods_sku_json = !empty($params['goods_sku_json_label']) ? json_encode($params['goods_sku_json_label']) : json_encode(['规格' => ['标准']]);
- $model->goods_attribute_json = !empty($params['goods_attribute_json']) ? $params['goods_attribute_json'] : '[]';
- $model->goods_title = $params['goods_title'] ?? '';
- $model->goods_cover = $params['goods_cover'] ?? '';
- $model->goods_on_addtimes = isset($params['goods_on_addtimes']) ? strtotime($params['goods_on_addtimes']) : null;
- $model->goods_sort = $params['goods_sort'] ?? null;
- $model->goods_groupby = $params['goods_groupby'] ?? '';
- $model->goods_remark = $params['goods_remark'] ?? '';
- $model->goods_extend_json = $params['goods_extend_json'] ?? '{}';
- $model->is_support_appointment = $params['is_support_appointment'] ?? 'N';
- $model->creator_user_id = JwtToken::getCurrentId();
- $model->goods_addtimes = time();
- $model->goods_updatetimes = time();
- // {"express":"Y","self":"Y","arrival":"Y"}
- $expressJson = [];
- if (!empty($params['express_json'])) {
- if (in_array('express', $params['express_json'])) {
- $expressJson['express'] = 'Y';
- } else {
- $expressJson['express'] = 'N';
- }
- if (in_array('self', $params['express_json'])) {
- $expressJson['self'] = 'Y';
- } else {
- $expressJson['self'] = 'N';
- }
- if (in_array('arrival', $params['express_json'])) {
- $expressJson['arrival'] = 'Y';
- } else {
- $expressJson['arrival'] = 'N';
- }
- $model->goods_express_json = json_encode($expressJson);
- }
- if (!empty($params['is_support_appointment']) && $params['is_support_appointment'] == 'Y' && !empty($params['appointment_times']) && $params['goods_category'] != 'TRAVEL') {
- $times = [];
- $attributeJsonTimeArr = [];
- $personTotal = 0;
- foreach ($params['appointment_times'] as $time) {
- $attributeJsonTimeArr[] = strtotime(date('Y-m-d ') . $time['appointmentTimeStart']);
- $attributeJsonTimeArr[] = strtotime(date('Y-m-d ') . $time['appointmentTimeEnd']);
- $personTotal += $time['person'];
- $times[$time['appointmentTimeStart']] = [
- 'person' => $time['person'],
- 'duration' => $time['appointmentTimeStart'] . '-' . $time['appointmentTimeEnd']
- ];
- }
- $attributeJsonTime = date('H:i', min($attributeJsonTimeArr)) . '至' . date('H:i', max($attributeJsonTimeArr));
- $newDates = [];
- foreach ($params['dates'] as $date) {
- $key = self::$week[$date];
- $newDates[$key] = $date;
- }
- ksort($newDates);
- $currentDate = current($newDates);
- $lastDate = end($newDates);
- $attributeJsonDate = '';
- if (self::$week[$lastDate] - self::$week[$currentDate] + 1 > count($newDates)) {
- $attributeJsonDate = implode(',', $newDates);
- } else if (self::$week[$lastDate] - self::$week[$currentDate] + 1 == count($newDates)) {
- $attributeJsonDate = $currentDate . '至' . $lastDate;
- }
- // if (isset($params['work_time'])){
- // $workTimeStart = date('H:i',strtotime($params['work_time'][0]));
- // $workTimeEnd = date('H:i',strtotime($params['work_time'][1]));
- // $attributeJsonTime = $workTimeStart.'至'.$workTimeEnd;
- // }
- $attributeJson = [
- 'icon' => $model->goods_cover,
- 'date' => $attributeJsonDate,
- // 'time' => $attributeJsonTime,
- 'dates' => $newDates ? array_values($newDates) : [],
- 'times' => $times,
- 'person' => $personTotal
- ];
- // if(isset($params['address'])){
- // $attributeJson['address'] = $params['address'];
- // }
- // if (isset($params['min_count'])){
- // $attributeJson['min-count'] = $params['min_count'];
- // }else{
- // $attributeJson['min-count'] = 1;
- // }
- // if (isset($params['teachers'])){
- // $attributeJson['teachers'] = $params['teachers'];
- // }
- if (!empty($params['appointment_label'])) {
- $attributeJson['label'] = $params['appointment_label'];
- }
- // if (!empty($params['address'])) {
- // $attributeJson['address'] = $params['address'];
- // }
- // if (!empty($params['position'])){
- // $attributeJson['position'] = $params['position'];
- // }
- // if (isset($params['goods_service_premises'])){
- // $attributeJson['service_premises_id'] = $params['goods_service_premises'];
- // }
- $model->goods_attribute_json = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- // $times = [];
- // foreach ($params['appointment_times'] as $time) {
- // $times[$time['appointmentTimeStart']] = [
- // 'person' => $time['person'],
- // 'duration' => $time['appointmentTimeStart'] . '-' . $time['appointmentTimeEnd']
- // ];
- // }
- // $model->goods_attribute_json = json_encode([
- // 'icon' => '',
- // 'dates' => $params['dates'] ?? [],
- // 'times' => $times
- // ]);
- }
- if (!empty($params['is_support_appointment']) && $params['is_support_appointment'] == 'Y' && !empty($params['appointment_times']) && $params['goods_category'] == 'TRAVEL') {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['travel-day'] = $params['travel_day'];
- $attributeJson['travel-begin'] = $params['travel_begin'];
- $attributeJson['travel-night'] = $params['travel_night'];
- $attributeJson['travel-trans'] = $params['travel_trans'];
- $unixs = [];
- foreach ($params['appointment_times'] as $times) {
- $unix = strtotime($times['days']);
- $unixs[$unix] = $times['person'];
- }
- ksort($unixs);
- $months = [];
- foreach ($unixs as $key => $unix) {
- $month = date('Ym', $key);
- $day = date('d', $key);
- $months[$month][$day] = $unix;
- }
- $attributeJson['month'] = $months;
- $model->goods_attribute_json = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['goods_json']) && $params['join_goods_category_id'] == 65) {
- $goodsJson = json_decode($params['goods_json'], true);
- // foreach ($goodsJson as $key => $item) {
- // $goodsJson[$key]['color'] = hexToRgb($item['color']);
- // }
- //
- $model->goods_json = json_encode($goodsJson);
- } elseif (!empty($params['goods_json']) && $params['join_goods_category_id'] == 43) {
- $goodsJson = json_decode($params['goods_json'], true);
- $newGoodsJson = [];
- foreach ($goodsJson as $item1) {
- if (empty($item1['title'])) {
- continue;
- }
- $newItem1 = [];
- foreach ($item1['items'] as $item2) {
- $newParams = [];
- foreach ($item2['params'] as $param) {
- if (!empty($param[0]) || !empty($param[1])) {
- $newParams[] = $param;
- }
- }
- $newItem1['items'][$item2['key']] = $newParams;
- }
- $newItem1['service'] = $item1['service'] ?? '';
- $newGoodsJson[$item1['title']] = $newItem1;
- }
- $model->goods_json = json_encode($newGoodsJson);
- } else {
- $model->goods_json = '[]';
- }
- if (!empty($params['goods_premisses'])) {
- $attributeJson = [];
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['premisses'] = $params['goods_premisses'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (!empty($params['goods_theme_color']) && !empty($params['goods_theme_icon'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['bg'] = $params['goods_theme_color'];
- $attributeJson['icon'] = str_replace(getenv('STORAGE_DOMAIN'), '', $params['goods_theme_icon']);
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (!empty($params['address'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['address'] = $params['address'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (!empty($params['position'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['position'] = $params['position'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (isset($params['goods_service_premises'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['service_premises_id'] = $params['goods_service_premises'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (isset($params['min_count'])) {
- $attributeJson = [];
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- }
- $attributeJson['min-count'] = $params['min_count'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (isset($params['max_limit'])) {
- $attributeJson = [];
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- }
- $attributeJson['max-limit'] = $params['max_limit'];
- if ($attributeJson['max-limit'] == 0 || $attributeJson['max-limit'] == '') {
- unset($attributeJson['max-limit']);
- }
- }
- if (isset($params['teachers'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $attributeJson['teachers'] = $params['teachers'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (isset($params['work_time'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $workTimeStart = date('H:i', strtotime($params['work_time'][0]));
- $workTimeEnd = date('H:i', strtotime($params['work_time'][1]));
- $attributeJsonTime = $workTimeStart . '至' . $workTimeEnd;
- $attributeJson['time'] = $attributeJsonTime;
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- if (!empty($params['couponContentList'])) {
- $couponList = [];
- foreach ($params['couponContentList'] as $coupon) {
- $couponList[$coupon['coupon_id']] = [
- 'num' => $coupon['nbr'],
- 'name' => $coupon['coupon_name']
- ];
- }
- $attributeJson['coupon'] = $couponList;
- $model->goods_attribute_json = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['coupon_id']) && !empty($params['coupon_nbr'])) {
- if (!empty($model->goods_attribute_json) && !is_array($model->goods_attribute_json)) {
- $attributeJson = json_decode($model->goods_attribute_json, true);
- } elseif (empty($model->goods_attribute_json)) {
- $attributeJson = [];
- }
- $coupons = Coupon::whereIn('coupon_id', $params['coupon_id'])
- ->select('coupon_id', 'coupon_name')
- ->get()
- ->toArray();
- $couponList = [];
- foreach ($coupons as $coupon) {
- if (isset($params['coupon_nbr'][$coupon['coupon_id']])) {
- $couponList[$coupon['coupon_id']] = [
- 'num' => $params['coupon_nbr'][$coupon['coupon_id']],
- 'name' => $coupon['coupon_name']
- ];
- }
- }
- $attributeJson['coupon'] = $couponList;
- $model->goods_attribute_json = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if ($model->save()) {
- return $model->goods_id;
- }
- // 异常
- throw new BusinessException("数据写入失败~");
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException("数据写入失败~");
- }
- }
- /**
- * @Desc 详情表
- * @Author Gorden
- * @Date 2024/3/11 11:19
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function detailInsert($params)
- {
- if (!empty($params['goods_detail_slider_json'])) {
- $params['goods_detail_slider_json'] = str_replace(getenv('STORAGE_DOMAIN'), '', $params['goods_detail_slider_json']);
- $params['goods_detail_slider_json'] = json_encode(['slider' => $params['goods_detail_slider_json']]);
- }
- if (isset($params['curriculum'])) {
- $params['goods_detail_specs_json'] = json_encode([
- [
- 'key' => '课时',
- 'val' => $params['curriculum']['period'] ?? '',
- ],
- [
- 'key' => '群体',
- 'val' => $params['curriculum']['group'] ?? '',
- ],
- [
- 'key' => '课程',
- 'val' => $params['curriculum']['course'] ?? '',
- ],
- ]);
- }
- try {
- $model = new GoodsDetail();
- $model->join_detail_goods_id = $params['goods_id'];
- $model->goods_detail_code_json = $params['goods_detail_code_json'] ?? '{}';
- $model->goods_detail_slider_json = $params['goods_detail_slider_json'] ?? '{}';
- $model->goods_detail_specs_json = $params['goods_detail_specs_json'] ?? '{}';
- $model->goods_detail_content = $params['goods_detail_content'] ?? '';
- if (!$model->save()) {
- // 异常
- throw new BusinessException("轮播图/详情数据写入失败~");
- }
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException("轮播图/详情数据写入失败~");
- }
- }
- public static function componentUpdate($params, $type = 'insert')
- {
- Db::beginTransaction();
- try {
- $goodsSku = '';
- // 有先删除
- if ($type == 'update') {
- GoodsComponent::where('join_component_master_goods_id', $params['goods_id'])->delete();
- $goodsSku = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->first();
- if ($goodsSku) {
- $goodsSku->goods_sku_market_price = $params['goods_market_price'] ?? 0;
- $goodsSku->goods_sku_sales_price = $params['goods_sales_price'] ?? 0;
- $goodsSku->save();
- }
- }
- if ($type == 'insert' || !$goodsSku) {
- Goods::where('goods_id', $params['goods_id'])->update(['goods_sku_json' => '{"规格": ["标准"]}']);
- $skuData = [
- 'join_sku_goods_id' => $params['goods_id'],
- 'goods_sku_status' => 'ON',
- 'goods_sku_specs_json' => '{"规格": "标准"}',
- 'goods_sku_title' => "标准" . $params['goods_name'],
- 'goods_sku_market_price' => $params['goods_market_price'] ?? 0,
- 'goods_sku_sales_price' => $params['goods_sales_price'] ?? 0,
- ];
- GoodsSku::insert($skuData);
- }
- $data = [];
- foreach ($params['goods_content_list'] as $item) {
- if (!in_array($item['goods_id'], $params['join_component_goods_id'])) {
- continue;
- }
- $goods = Goods::where('goods_id', $params['goods_id'])->first();
- if (!$goods) {
- continue;
- }
- $data[] = [
- 'join_component_master_goods_id' => $params['goods_id'],
- 'join_component_goods_id' => $item['goods_id'] ?? '',
- 'join_component_goods_sku_id' => $item['sku_id'] ?? '',
- 'goods_component_price' => $item['goods_sales_price'] ?? '',
- 'goods_component_cover' => $goods->goods_cover,
- 'goods_component_json' => json_encode(['goods_name' => $item['goods_name'], 'nbr' => $item['nbr'], 'sku_id' => $item['sku_id'] ?? '']),
- 'goods_component_addtimes' => time()
- ];
- }
- if ($data) {
- GoodsComponent::insert($data);
- }
- Db::commit();
- } catch (\Exception $e) {
- Db::rollBack();
- dump($e->getMessage());
- throw new BusinessException("数据写入失败~");
- }
- }
- /**
- * @Desc 标签表
- * @Author Gorden
- * @Date 2024/3/11 11:32
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function labelInsert($params)
- {
- $model = new GoodsLabel();
- $model->join_label_goods_id = $params['goods_id'];
- $model->goods_label = $params['goods_label'] ? implode(',', $params['goods_label']) : '';
- $model->goods_label_extend_json = !empty($params['goods_label_extend_json']) ? $params['goods_label_extend_json'] : '{}';
- if (!$model->save()) {
- // 异常
- throw new BusinessException('数据写入失败~');
- }
- }
- /**
- * @Desc 产品运行控制信息表
- * @Author Gorden
- * @Date 2024/3/11 11:38
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function goodsRunningInsert($params)
- {
- try {
- $model = new GoodsRunning();
- $model->join_running_goods_id = $params['goods_id'];
- $model->goods_running_storage = $params['goods_running_storage'] ?? 0;
- $model->goods_running_sale = $params['goods_running_sale'] ?? 0;
- $model->goods_running_off_type = !empty($params['goods_running_off_type']) ? $params['goods_running_off_type'] : '';
- $model->goods_running_off_json = !empty($params['goods_running_off_type']) && $params['goods_running_off_type'] == 'T' && !empty($params['goods_off_addtimes']) ? json_encode(['time' => strtotime($params['goods_off_addtimes'])]) : '[]';
- if (!$model->save()) {
- throw new BusinessException('数据写入失败');
- }
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('数据写入失败');
- }
- }
- /**
- * @Desc SKU
- * @Author Gorden
- * @Date 2024/3/11 12:01
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function skuInsert($params)
- {
- $model = new GoodsSku();
- $model->join_sku_goods_id = $params['goods_id'];
- $model->goods_sku_status = $params['goods_sku_status'];
- $model->goods_sku_specs_json = $params['goods_sku_specs_json'];
- $model->goods_sku_title = $params['goods_sku_title'];
- $model->goods_sku_images_json = $params['goods_sku_images_json'];
- $model->goods_sku_content = $params['goods_sku_content'];
- $model->goods_sku_market_price = $params['goods_sku_market_price'];
- $model->goods_sku_sales_price = $params['goods_sku_sales_price'];
- $model->goods_sku_storage_json = $params['goods_sku_storage_json'];
- $model->goods_sku_service_json = $params['goods_sku_service_json'];
- $model->goods_sku_extend_json = $params['goods_sku_extend_json'];
- if (!$model->save()) {
- throw new BusinessException('规格数据写入失败~');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/3/12 8:44
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function mainUpdate($params)
- {
- try {
- $data = self::inputFilter($params, new Goods());
- if (!empty($data['goods_cover'])) {
- $data['goods_cover'] = str_replace(getenv('STORAGE_DOMAIN'), '', $data['goods_cover']);
- }
- $data['goods_on_addtimes'] = isset($data['goods_on_addtimes']) ? strtotime($data['goods_on_addtimes']) : 0;
- $data['goods_sku_json'] = !empty($params['goods_sku_json_label']) ? json_encode($params['goods_sku_json_label']) : json_encode(['规格' => ['标准']]);
- $row = Goods::find($data['goods_id']);
- if ($row->join_goods_category_id != $data['join_goods_category_id']) {
- $category = SysCategory::where('category_id', $params['join_goods_category_id'])->first();
- if (!$category) {
- throw new BusinessException("产品分类不存在~");
- }
- $data['goods_category'] = $category->category_classify ?? '';
- $data['goods_prefix'] = $data['goods_prefix'] ?? ($category->category_name ? '【' . $category->category_name . '】' : '');
- }
- if (!empty($params['goods_recommend_index'])) {
- $data['goods_category'] = $params['goods_recommend_index'];
- }
- // 上架时间有变动
- if ($data['goods_status'] == 'PENDING' && $row->goods_on_addtimes != $data['goods_on_addtimes']) {
- $redis = Redis::connection();
- // 删掉原来的
- $oldKey = Goods::LISTING_KEY_PREFIX . date('YmdHi', $row->goods_on_addtimes);
- $redis->srem($oldKey, $data['goods_id']);
- // 加入新的
- $newKey = Goods::LISTING_KEY_PREFIX . date('YmdHi', $data['goods_on_addtimes']);
- $redis->sadd($newKey, $data['goods_id']);
- }
- $expressJson = [];
- if (!empty($params['express_json'])) {
- if (in_array('express', $params['express_json'])) {
- $expressJson['express'] = 'Y';
- } else {
- $expressJson['express'] = 'N';
- }
- if (in_array('self', $params['express_json'])) {
- $expressJson['self'] = 'Y';
- } else {
- $expressJson['self'] = 'N';
- }
- if (in_array('arrival', $params['express_json'])) {
- $expressJson['arrival'] = 'Y';
- } else {
- $expressJson['arrival'] = 'N';
- }
- $data['goods_express_json'] = json_encode($expressJson);
- }
- if (!empty($params['is_support_appointment']) && $params['is_support_appointment'] == 'Y' && !empty($params['appointment_times']) && $params['goods_category'] != 'TRAVEL') {
- $attributeJson = [];
- if (!empty($row->goods_attribute_json)) {
- $attributeJson = json_decode($row->goods_attribute_json, true);
- }
- $times = [];
- $attributeJsonTimeArr = [];
- $personTotal = 0;
- foreach ($params['appointment_times'] as $time) {
- $attributeJsonTimeArr[] = strtotime(date('Y-m-d ') . $time['appointmentTimeStart']);
- $attributeJsonTimeArr[] = strtotime(date('Y-m-d ') . $time['appointmentTimeEnd']);
- $personTotal += $time['person'];
- $times[$time['appointmentTimeStart']] = [
- 'person' => $time['person'],
- 'duration' => $time['appointmentTimeStart'] . '-' . $time['appointmentTimeEnd']
- ];
- }
- $attributeJsonTime = date('H:i', min($attributeJsonTimeArr)) . '至' . date('H:i', max($attributeJsonTimeArr));
- $newDates = [];
- foreach ($params['dates'] as $date) {
- $key = self::$week[$date];
- $newDates[$key] = $date;
- }
- ksort($newDates);
- $currentDate = current($newDates);
- $lastDate = end($newDates);
- $attributeJsonDate = '';
- if (self::$week[$lastDate] - self::$week[$currentDate] + 1 > count($newDates)) {
- $attributeJsonDate = implode(',', $newDates);
- } else if (self::$week[$lastDate] - self::$week[$currentDate] + 1 == count($newDates)) {
- $attributeJsonDate = $currentDate . '至' . $lastDate;
- }
- $attributeJson['date'] = $attributeJsonDate;
- $attributeJson['icon'] = $data['goods_cover'] ?? '';
- $attributeJson['time'] = $attributeJsonTime;
- $attributeJson['dates'] = $newDates ? array_values($newDates) : [];
- $attributeJson['times'] = $times;
- $attributeJson['person'] = $personTotal;
- if (!empty($params['appointment_label'])) {
- $attributeJson['label'] = $params['appointment_label'];
- }
- // if (!empty($params['address'])) {
- // $attributeJson['address'] = $params['address'];
- // }
- // if (!empty($params['position'])){
- // $attributeJson['position'] = $params['position'];
- // }
- // if (isset($params['goods_service_premises'])){
- // $attributeJson['service_premises_id'] = $params['goods_service_premises'];
- // }
- // if (isset($params['work_time'])){
- // $workTimeStart = date('H:i',strtotime($params['work_time'][0]));
- // $workTimeEnd = date('H:i',strtotime($params['work_time'][1]));
- // $attributeJson['time'] = $workTimeStart.'至'.$workTimeEnd;
- // }
- // if (isset($params['min_count'])){
- // $attributeJson['min-count'] = $params['min_count'];
- // }else{
- // $attributeJson['min-count'] = 1;
- // }
- // if (isset($params['teachers'])){
- // $attributeJson['teachers'] = $params['teachers'];
- // }
- $data['goods_attribute_json'] = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['is_support_appointment']) && $params['is_support_appointment'] == 'Y' && !empty($params['appointment_times']) && $params['goods_category'] == 'TRAVEL') {
- $attributeJson = [];
- if (!empty($row->goods_attribute_json)) {
- $attributeJson = json_decode($row->goods_attribute_json, true);
- }
- $attributeJson['travel-day'] = $params['travel_day'];
- $attributeJson['travel-begin'] = $params['travel_begin'];
- $attributeJson['travel-night'] = $params['travel_night'];
- $attributeJson['travel-trans'] = $params['travel_trans'];
- $unixs = [];
- foreach ($params['appointment_times'] as $times) {
- $unix = strtotime($times['days']);
- $unixs[$unix] = $times['person'];
- }
- ksort($unixs);
- $months = [];
- foreach ($unixs as $key => $unix) {
- $month = date('Ym', $key);
- $day = date('d', $key);
- $months[$month][$day] = $unix;
- }
- $attributeJson['month'] = $months;
- $data['goods_attribute_json'] = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['couponContentList'])) {
- $attributeJson = [];
- if (!empty($row->goods_attribute_json)) {
- $attributeJson = json_decode($row->goods_attribute_json, true);
- }
- $couponList = [];
- foreach ($params['couponContentList'] as $coupon) {
- $couponList[$coupon['coupon_id']] = [
- 'num' => $coupon['nbr'],
- 'name' => $coupon['coupon_name']
- ];
- }
- $attributeJson['coupon'] = $couponList;
- $data['goods_attribute_json'] = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['coupon_id']) && !empty($params['coupon_nbr'])) {
- $attributeJson = [];
- if (!empty($row->goods_attribute_json)) {
- $attributeJson = json_decode($row->goods_attribute_json, true);
- }
- $coupons = Coupon::whereIn('coupon_id', $params['coupon_id'])
- ->select('coupon_id', 'coupon_name')
- ->get()
- ->toArray();
- $couponList = [];
- foreach ($coupons as $coupon) {
- if (isset($params['coupon_nbr'][$coupon['coupon_id']])) {
- $couponList[$coupon['coupon_id']] = [
- 'num' => $params['coupon_nbr'][$coupon['coupon_id']],
- 'name' => $coupon['coupon_name']
- ];
- }
- }
- $attributeJson['coupon'] = $couponList;
- $data['goods_attribute_json'] = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- if (!empty($params['goods_premisses'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['premisses'] = $params['goods_premisses'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (!empty($data['goods_json']) && $data['join_goods_category_id'] == 65) {
- // $goodsJson = json_decode($data['goods_json'], true);
- // foreach ($goodsJson as $key => $item) {
- // $goodsJson[$key]['color'] = hexToRgb($item['color']);
- // }
- //
- // $data['goods_json'] = json_encode($goodsJson);
- } elseif (!empty($data['goods_json']) && $data['join_goods_category_id'] == 43) {
- $goodsJson = json_decode($data['goods_json'], true);
- $newGoodsJson = [];
- foreach ($goodsJson as $item1) {
- if (empty($item1['title'])) {
- continue;
- }
- $newItem1 = [];
- foreach ($item1['items'] as $item2) {
- $newParams = [];
- foreach ($item2['params'] as $param) {
- if (!empty($param[0]) || !empty($param[1])) {
- $newParams[] = $param;
- }
- }
- $newItem1['items'][$item2['key']] = $newParams;
- }
- $newItem1['service'] = $item1['service'];
- $newGoodsJson[$item1['title']] = $newItem1;
- }
- $data['goods_json'] = json_encode($newGoodsJson);
- } else {
- $data['goods_json'] = '[]';
- }
- if (!empty($params['goods_theme_color']) && !empty($params['goods_theme_icon'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['bg'] = $params['goods_theme_color'];
- $data['goods_attribute_json']['icon'] = str_replace(getenv('STORAGE_DOMAIN'), '', $params['goods_theme_icon']);
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (!empty($params['address'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['address'] = $params['address'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (!empty($params['position'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['position'] = $params['position'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (isset($params['goods_service_premises'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['service_premises_id'] = $params['goods_service_premises'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (isset($params['work_time'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $workTimeStart = date('H:i', strtotime($params['work_time'][0]));
- $workTimeEnd = date('H:i', strtotime($params['work_time'][1]));
- $data['goods_attribute_json']['time'] = $workTimeStart . '至' . $workTimeEnd;
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (isset($params['min_count'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['min-count'] = $params['min_count'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (isset($params['max_limit'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['max-limit'] = $params['max_limit'];
- if ($data['goods_attribute_json']['max-limit'] == 0 || $data['goods_attribute_json']['max-limit'] == '') {
- unset($data['goods_attribute_json']['max-limit']);
- }
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- if (isset($params['teachers'])) {
- if (!empty($data['goods_attribute_json']) && !is_array($data['goods_attribute_json'])) {
- if (is_json($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = json_decode($data['goods_attribute_json'], true);
- } else {
- $data['goods_attribute_json'] = [];
- }
- } elseif (empty($data['goods_attribute_json'])) {
- $data['goods_attribute_json'] = [];
- }
- $data['goods_attribute_json']['teachers'] = $params['teachers'];
- $data['goods_attribute_json'] = json_encode($data['goods_attribute_json']);
- }
- foreach ($data as $key => $val) {
- $row->{$key} = $val;
- }
- $row->goods_updatetimes = time();
- $row->updator_user_id = JwtToken::getCurrentId();
- $row->save();
- } catch (BusinessException $e) {
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getTrace());
- throw new BusinessException('数据更新异常~1');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/3/12 9:57
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function detailUpdate($params)
- {
- try {
- $data = self::inputFilter($params, new GoodsDetail());
- if (!empty($data['goods_detail_slider_json'])) {
- $data['goods_detail_slider_json'] = str_replace(getenv('STORAGE_DOMAIN'), '', $data['goods_detail_slider_json']);
- $data['goods_detail_slider_json'] = json_encode(['slider' => $data['goods_detail_slider_json']]);
- }
- if (isset($params['curriculum'])) {
- $data['goods_detail_specs_json'] = json_encode([
- [
- 'key' => '课时',
- 'val' => $params['curriculum']['period'] ?? '',
- ],
- [
- 'key' => '群体',
- 'val' => $params['curriculum']['group'] ?? '',
- ],
- [
- 'key' => '课程',
- 'val' => $params['curriculum']['course'] ?? '',
- ],
- ]);
- }
- // 根据goods_id 查详情ID
- $detail = GoodsDetail::where('join_detail_goods_id', $params['goods_id'])->first();
- if ($detail) {
- self::doUpdate($detail->join_detail_goods_id, $data, new GoodsDetail());
- } else {
- $data['join_detail_goods_id'] = $params['goods_id'];
- GoodsDetail::insert($data);
- }
- } catch (BusinessException $e) {
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('轮播图/详情数据更新异常~');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/3/12 9:58
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function labelUpdate($params)
- {
- try {
- $data = self::inputFilter($params, new GoodsLabel());
- // 根据goods_id 查详情ID
- $detail = GoodsLabel::where('join_label_goods_id', $params['goods_id'])->first();
- if ($detail) {
- self::doUpdate($detail->goods_label_id, $data, new GoodsLabel());
- } else {
- $data['join_label_goods_id'] = $params['goods_id'];
- GoodsLabel::insert($data);
- }
- } catch (BusinessException $e) {
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('数据更新异常~3');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/3/12 9:59
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function goodsRunningUpdate($params)
- {
- try {
- $data = self::inputFilter($params, new GoodsRunning());
- // 根据goods_id 查详情ID
- $detail = GoodsRunning::where('join_running_goods_id', $params['goods_id'])->first();
- if (!empty($params['goods_running_off_type']) && $params['goods_running_off_type'] == 'T') {
- $redis = Redis::connection();
- if (!empty($detail->goods_running_off_json)) {
- $goodsRunningOffJson = json_decode($detail->goods_running_off_json, true);
- if (isset($goodsRunningOffJson['time'])) {
- $oldKey = Goods::LISTING_OFF_KEY_PREFIX . date('YmdHi', $goodsRunningOffJson['time']);
- $goodsRunningOffJson['time'] = strtotime($params['goods_off_addtimes']);
- $data['goods_running_off_json'] = json_encode($goodsRunningOffJson);
- // 有老的下架时间,删除老的
- $redis->srem($oldKey, $params['goods_id']);
- } else {
- $goodsRunningOffJson['time'] = strtotime($params['goods_off_addtimes']);
- $data['goods_running_off_json'] = json_encode($goodsRunningOffJson);
- }
- } else {
- $data['goods_running_off_json'] = json_encode(['time' => strtotime($params['goods_off_addtimes'])]);
- }
- // 加入自动下架
- $newKey = Goods::LISTING_OFF_KEY_PREFIX . date('YmdHi', strtotime($params['goods_off_addtimes']));
- $redis->sAdd($newKey, $params['goods_id']);
- } else if (!empty($params['goods_running_off_type']) && !empty($detail->goods_running_off_type) && $params['goods_running_off_type'] == 'H' && $detail->goods_running_off_type == 'T') {
- $goodsRunningOffJson = json_decode($detail->goods_running_off_json, true);
- if (isset($goodsRunningOffJson['time'])) {
- $oldKey = Goods::LISTING_OFF_KEY_PREFIX . date('YmdHi', $goodsRunningOffJson['time']);
- $redis = Redis::connection();
- $redis->srem($oldKey, $params['goods_id']);
- }
- }
- if ($detail) {
- self::doUpdate($detail->join_running_goods_id, $data, new GoodsRunning());
- } else {
- // 兼容老数据……
- $data['join_running_goods_id'] = $params['goods_id'];
- GoodsRunning::insert($data);
- }
- } catch (BusinessException $e) {
- throw new BusinessException($e->getMessage());
- } catch (\Exception $e) {
- dump($e->getMessage());
- throw new BusinessException('数据更新异常~');
- }
- }
- /**
- * @Desc sku 设置
- * @Author Gorden
- * @Date 2024/4/10 10:43
- *
- * @param $params
- * @return void
- * @throws BusinessException
- */
- public static function goodsSkuSet($params, $operation = 'insert')
- {
- try {
- Db::beginTransaction();
- $skusOldIds = [];
- if ($operation == 'update') {
- // 查出所有的
- $skusOldIds = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->pluck('goods_sku_id', 'goods_sku_id');
- // 删掉原有的
- // GoodsSku::where('join_sku_goods_id', $params['goods_id'])->delete();
- }
- if (empty($skusOldIds) && empty($params['goods_sku_json_value'])) {
- $skuData = [
- 'join_sku_goods_id' => $params['goods_id'],
- 'goods_sku_status' => 'ON',
- 'goods_sku_specs_json' => '{"规格": "标准"}',
- 'goods_sku_title' => "标准" . $params['goods_name'],
- 'goods_sku_market_price' => $params['goods_market_price'] ?? 0,
- 'goods_sku_sales_price' => $params['goods_sales_price'] ?? 0,
- ];
- GoodsSku::insert($skuData);
- }
- // 入新的
- if (!empty($params['goods_sku_json_value'])) {
- foreach ($params['goods_sku_json_value'] as $item) {
- $skus = explode(',', $item['sku']);
- $skuArr = [];
- for ($i = 1; $i <= count($skus); $i++) {
- $skuName = "skuName" . $i;
- $key = $item[$skuName];
- $skuArr[$key] = $skus[$i - 1];
- }
- $specsJson = json_encode($skuArr);
- $skuTitle = str_replace('-', ',', $item['sku']) . $params['goods_name'];
- if ($operation == 'update' && !empty($item['sku_id'])) {
- $model = GoodsSku::where('goods_sku_id', $item['sku_id'])->where('goods_sku_status', 'ON')->first();
- if (!$model) {
- $model = new GoodsSku();
- } else {
- unset($skusOldIds[$model->goods_sku_id]);
- }
- } else {
- $model = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->where('goods_sku_status', 'ON')->where('goods_sku_title', $skuTitle)->first();
- if (!$model) {
- $model = new GoodsSku();
- } else {
- unset($skusOldIds[$model->goods_sku_id]);
- }
- }
- $model->join_sku_goods_id = $params['goods_id'];
- $model->goods_sku_status = $params['goods_status'];
- $model->goods_sku_specs_json = $specsJson;
- $model->goods_sku_title = $skuTitle;
- $model->goods_sku_market_price = $params['goods_market_price'] ?? 0;
- $model->goods_sku_sales_price = $item['price'];
- $model->goods_sku_storage_json = json_encode(['storage' => $item['stock']]);
- $model->save();
- }
- }
- if ($operation == 'update' && !empty($skusOldIds)) {
- // GoodsSku::whereIn('goods_sku_id', $skusOldIds)->delete();
- GoodsSku::whereIn('goods_sku_id', $skusOldIds)->update(['goods_sku_status' => 'DISABLED']);
- }
- Db::commit();
- } catch (\Exception $e) {
- dump($e->getTrace());
- Db::rollBack();
- throw new BusinessException('规格数据更新异常~');
- }
- }
- /**
- * @Desc
- * @Author Gorden
- * @Date 2024/3/12 8:45
- *
- * @param array $data
- * @param $model
- * @return array
- * @throws BusinessException
- */
- private static function inputFilter(array $data, $model): array
- {
- $table = config('database.connections.mysql.prefix') . $model->getTable();
- $allow_column = $model->getConnection()->select("desc `$table`");
- if (!$allow_column) {
- throw new BusinessException('表不存在', 2);
- }
- $columns = array_column($allow_column, 'Type', 'Field');
- foreach ($data as $col => $item) {
- if (!isset($columns[$col])) {
- unset($data[$col]);
- continue;
- }
- // 非字符串类型传空则为null
- if ($item === '' && strpos(strtolower($columns[$col]), 'varchar') === false && strpos(strtolower($columns[$col]), 'text') === false) {
- $data[$col] = null;
- }
- if (is_array($item)) {
- $data[$col] = implode(',', $item);
- }
- if ($item != '' && (strpos(strtolower($columns[$col]), 'varchar') || strpos(strtolower($columns[$col]), 'text'))) {
- // $data[$col] = htmlspecialchars($item);
- }
- }
- if (empty($data['created_at'])) {
- unset($data['created_at']);
- }
- if (empty($data['updated_at'])) {
- unset($data['updated_at']);
- }
- return $data;
- }
- /**
- * @Desc 执行更新
- * @Author Gorden
- * @Date 2024/3/12 8:43
- *
- * @param $id
- * @param $data
- * @param $model
- * @return void
- */
- private static function doUpdate($id, $data, $model)
- {
- $row = $model->find($id);
- foreach ($data as $key => $val) {
- $row->{$key} = $val;
- }
- $row->save();
- }
- /**
- * @Desc 上架定时
- * @Author Gorden
- * @Date 2024/4/11 15:13
- *
- * @return void
- */
- public static function checkListing()
- {
- $key = Goods::LISTING_KEY_PREFIX . date('YmdHi');
- $redis = Redis::connection();
- if (!$redis->exists($key)) {
- return;
- }
- $goodsIds = $redis->sMembers($key);
- if (Goods::whereIn('goods_id', $goodsIds)->update(['goods_status' => 'ON'])) {
- $redis->del($key);
- }
- }
- /**
- * @Desc 自动下架
- * @Author Gorden
- * @Date 2024/4/26 15:26
- *
- * @return void
- */
- public static function checkOffListing()
- {
- $key = Goods::LISTING_OFF_KEY_PREFIX . date('YmdHi');
- $redis = Redis::connection();
- if (!$redis->exists($key)) {
- return;
- }
- $goodsIds = $redis->sMembers($key);
- if (Goods::whereIn('goods_id', $goodsIds)->update(['goods_status' => 'OFF'])) {
- $redis->del($key);
- }
- }
- public static $week = [
- '周一' => 1,
- '周二' => 2,
- '周三' => 3,
- '周四' => 4,
- '周五' => 5,
- '周六' => 6,
- '周日' => 7,
- ];
- }
|