1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011 |
- <?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\SysUser;
- use support\Db;
- use support\exception\BusinessException;
- use support\Redis;
- use support\Request;
- use support\Response;
- use Tinywan\Jwt\JwtToken;
- class MemberRechargeBenefitService
- {
- 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', '');
- 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) {
- dump($goodsCategory);
- $query->where('goods_category', $goodsCategory);
- })
- ->when($classify != '', function ($query) use ($classify) {
- dump($classify);
- $query->where('goods_classify', $classify);
- })->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);
- })
- ->where('goods_status', 'ON')
- ->orderBy('goods_sort', 'DESC')
- ->orderBy('goods_addtimes', 'DESC')
- ->forPage($page, $pageSize)
- ->get()
- ->toArray();
- $total = 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) {
- $query->where('goods_classify', $classify);
- })->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);
- })
- ->where('goods_status', 'ON')
- ->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'));
- }
- 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);
- }
- 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 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');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_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();
- $total = Goods::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)->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'));
- }
- 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');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_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();
- $total = Goods::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)
- ->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'));
- }
- 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');
- }
- ])->select('goods_id', 'join_goods_category_id', 'join_goods_supplier_id', 'creator_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();
- $total = 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);
- })->where('goods_classify', 'PACKAGE')->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['component'])) {
- // $ids = [];
- // $contentList = [];
- // foreach ($row['component'] as $component) {
- // $ids[] = $component['join_component_goods_id'];
- // $configJson = json_decode($component['goods_component_config_json'], true);
- // $contentList[] = [
- // 'goods_name' => $configJson['goods_name'] ?? '',
- // 'goods_sales_price' => $component['goods_component_price'],
- // 'nbr' => $configJson['nbr'] ?? 0
- // ];
- // }
- //
- // $row['join_component_goods_id'] = $ids;
- // $row['goodsContentList'] = $contentList;
- // }
- }
- return json_success('', compact('rows', 'page', 'pageSize', 'total'));
- }
- /**
- * @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', '');
- if (!$categoryIds && !$categorySuperId && !$joinGoodsCategoryId) {
- return json_fail('参数异常');
- }
- $data = [];
- $categorys = [];
- if (!empty($categoryIds)) {
- $categorys = SysCategory::whereIn('category_id', $categoryIds)
- ->where('category_status', 'ACTIVED')
- ->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)
- ->where('category_status', 'ACTIVED')
- ->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'] . '%')
- ->where('category_status', 'ACTIVED')
- ->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');
- $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 = [];
- }
- // 合并数据
- $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 (isset($extendJson['added'])) {
- $data['added_rate'] = floatval($extendJson['added']['nbr']) * 100;
- }
- }
- if (!empty($extendJson['coupon'])) {
- foreach ($extendJson['coupon'] as $key => $coupon) {
- $extendJson['coupon'][$key]['icon'] = getenv('STORAGE_DOMAIN') . $coupon['icon'];
- }
- $data['coupon_list'] = array_values($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("查询错误~");
- }
- }
- /**
- * @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'];
- 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 (\PDOException $e) {
- Db::rollBack();
- dump($e->getMessage());
- return json_fail('数据写入失败~');
- } 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;
- }
- $attributeJson = [
- 'icon' => $model->goods_cover,
- 'date' => $attributeJsonDate,
- 'dates' => $newDates ? array_values($newDates) : [],
- 'times' => $times,
- 'person' => $personTotal
- ];
- if (!empty($params['appointment_label'])) {
- $attributeJson['label'] = $params['appointment_label'];
- }
- $model->goods_attribute_json = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- }
- $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'])) {
- 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['min-count'] = $params['min_count'];
- $model->goods_attribute_json = json_encode($attributeJson);
- }
- 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['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 . '】' : '');
- }
- $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);
- }
- $attributeJson = [];
- if (!empty($row->goods_attribute_json)) {
- $attributeJson = json_decode($row->goods_attribute_json, true);
- }
- if (isset($params['added_rate'])) {
- $attributeJson['added']['nbr'] = round($params['added_rate'] / 100, 2);
- }
- if (!empty($params['chooseCoupons'])) {
- $couponList = [];
- foreach ($params['chooseCoupons'] as $chooseCoupon) {
- $coupon = Coupon::where('coupon_id', $chooseCoupon['coupon_id'])
- ->select('coupon_id', 'coupon_name')
- ->first();
- $couponList[$coupon->coupon_id] = [
- 'coupon_id' => $coupon->coupon_id,
- 'num' => $chooseCoupon['num'],
- 'name' => $coupon->coupon_name,
- 'icon' => str_replace(getenv("STORAGE_DOMAIN"), '', str_replace('/thumb', '', $chooseCoupon['icon'])),
- 'unit' => '张'
- ];
- }
- $attributeJson['coupon'] = $couponList;
- }
- if (!empty($params['attribute_account'])) {
- $attributeJson['account'] = $params['attribute_account'];
- }
- if (!empty($params['attribute_control'])) {
- $attributeJson['control'] = $params['attribute_control'];
- }
- $data['goods_attribute_json'] = json_encode($attributeJson, JSON_UNESCAPED_UNICODE);
- 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,
- ];
- }
|