StoreProduct.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776
  1. <?php
  2. namespace app\admin\controller\store;
  3. use app\admin\controller\AuthController;
  4. use app\admin\model\store\{StoreDescription,
  5. StoreProductAttrValue,
  6. StoreProductAttr,
  7. StoreProductAttrResult,
  8. StoreProductCate,
  9. StoreProductProvider as SPP,
  10. StoreProductRelation,
  11. StoreCategory as CategoryModel,
  12. StoreProduct as ProductModel};
  13. use app\admin\model\ump\StoreBargain;
  14. use app\admin\model\ump\StoreCombination;
  15. use app\admin\model\ump\StoreSeckill;
  16. use crmeb\services\{
  17. JsonService, UtilService as Util, JsonService as Json, FormBuilder as Form
  18. };
  19. use crmeb\traits\CurdControllerTrait;
  20. use think\facade\Route as Url;
  21. use app\admin\model\system\{
  22. SystemAttachment, ShippingTemplates
  23. };
  24. use \think\facade\Config;
  25. /**
  26. * 产品管理
  27. * Class StoreProduct
  28. * @package app\admin\controller\store
  29. */
  30. class StoreProduct extends AuthController
  31. {
  32. use CurdControllerTrait;
  33. protected $bindModel = ProductModel::class;
  34. /**
  35. * 显示资源列表
  36. *
  37. * @return \think\Response
  38. */
  39. public function index()
  40. {
  41. $type = $this->request->param('type', 1);
  42. //获取分类
  43. $this->assign('cate', CategoryModel::getTierList(null, 1));
  44. //出售中产品
  45. $onsale = ProductModel::where('is_del', 0)->where('is_show', 1)->count();
  46. //待上架产品
  47. $forsale = ProductModel::where('is_del', 0)->where('is_show', 0)->count();
  48. //仓库中产品
  49. $warehouse = ProductModel::where('is_del', 0)->count();
  50. //已经售馨产品
  51. $outofstock = ProductModel::getModelObject(['type' => 4])->count();
  52. //警戒库存
  53. $policeforce = ProductModel::getModelObject(['type' => 5])->count();
  54. //回收站
  55. $recycle = ProductModel::where('is_del', 1)->count();
  56. $this->assign(compact('type', 'onsale', 'forsale', 'warehouse', 'outofstock', 'policeforce', 'recycle'));
  57. return $this->fetch();
  58. }
  59. /**
  60. * 异步查找产品
  61. *
  62. * @return json
  63. */
  64. public function product_ist()
  65. {
  66. $where = Util::getMore([
  67. ['page', 1],
  68. ['limit', 20],
  69. ['store_name', ''],
  70. ['cate_id', ''],
  71. ['excel', 0],
  72. ['order', ''],
  73. [['type', 'd'], $this->request->param('type/d')]
  74. ]);
  75. return Json::successlayui(ProductModel::ProductList($where));
  76. }
  77. /**
  78. * 设置单个产品上架|下架
  79. *
  80. * @return json
  81. */
  82. public function set_show($is_show = '', $id = '')
  83. {
  84. ($is_show == '' || $id == '') && Json::fail('缺少参数');
  85. $res = ProductModel::where(['id' => $id])->update(['is_show' => (int)$is_show]);
  86. if ($res) {
  87. return Json::successful($is_show == 1 ? '上架成功' : '下架成功');
  88. } else {
  89. return Json::fail($is_show == 1 ? '上架失败' : '下架失败');
  90. }
  91. }
  92. /**
  93. * 快速编辑
  94. *
  95. * @return json
  96. */
  97. public function set_product($field = '', $id = '', $value = '')
  98. {
  99. $field == '' || $id == '' || $value == '' && Json::fail('缺少参数');
  100. if (ProductModel::where(['id' => $id])->update([$field => $value]))
  101. return Json::successful('保存成功');
  102. else
  103. return Json::fail('保存失败');
  104. }
  105. /**
  106. * 设置批量产品上架
  107. *
  108. * @return json
  109. */
  110. public function product_show()
  111. {
  112. $post = Util::postMore([
  113. ['ids', []]
  114. ]);
  115. if (empty($post['ids'])) {
  116. return Json::fail('请选择需要上架的产品');
  117. } else {
  118. $res = ProductModel::where('id', 'in', $post['ids'])->update(['is_show' => 1]);
  119. if ($res)
  120. return Json::successful('上架成功');
  121. else
  122. return Json::fail('上架失败');
  123. }
  124. }
  125. /**
  126. * 显示创建资源表单页.
  127. *
  128. * @return \think\Response
  129. */
  130. public function create($id = 0)
  131. {
  132. $this->assign('id', (int)$id);
  133. $this->assign('lucky_id', Config::get('activity.lucky_cate_id'));
  134. return $this->fetch();
  135. }
  136. /**
  137. * 获取规则属性模板
  138. * @throws \think\db\exception\DataNotFoundException
  139. * @throws \think\db\exception\DbException
  140. * @throws \think\db\exception\ModelNotFoundException
  141. */
  142. public function get_rule()
  143. {
  144. return Json::successful(\app\models\store\StoreProductRule::field(['rule_name', 'rule_value'])->select()->each(function ($item) {
  145. $item['rule_value'] = json_decode($item['rule_value'], true);
  146. })->toArray());
  147. }
  148. /**
  149. * 获取产品详细信息
  150. * @param int $id
  151. * @throws \think\db\exception\DataNotFoundException
  152. * @throws \think\db\exception\DbException
  153. * @throws \think\db\exception\ModelNotFoundException
  154. */
  155. public function get_product_info($id = 0)
  156. {
  157. $list = CategoryModel::getTierList(null, 1);
  158. $menus = [];
  159. foreach ($list as $menu) {
  160. $menus[] = ['value' => $menu['id'], 'label' => $menu['html'] . $menu['cate_name'], 'disabled' => $menu['pid'] == 0 ? 0 : 1];//,'disabled'=>$menu['pid']== 0];
  161. }
  162. $data['tempList'] = ShippingTemplates::order('sort', 'desc')->field(['id', 'name'])->select()->toArray();
  163. $data['providerList'] = SPP::where('status',0)->field(['id', 'name'])->select()->toArray();
  164. $data['cateList'] = $menus;
  165. $data['productInfo'] = [];
  166. if ($id) {
  167. $productInfo = ProductModel::get($id);
  168. if (!$productInfo) {
  169. return Json::fail('修改的产品不存在');
  170. }
  171. $productInfo['cate_id'] = explode(',', $productInfo['cate_id']);
  172. $productInfo['description'] = htmlspecialchars_decode(StoreDescription::getDescription($id));
  173. $productInfo['slider_image'] = is_string($productInfo['slider_image']) ? json_decode($productInfo['slider_image'], true) : [];
  174. if ($productInfo['spec_type'] == 1) {
  175. $result = StoreProductAttrResult::getResult($id, 0);
  176. foreach ($result['value'] as $k => $v) {
  177. $num = 1;
  178. foreach ($v['detail'] as $dv) {
  179. $result['value'][$k]['value' . $num] = $dv;
  180. $num++;
  181. }
  182. }
  183. $productInfo['items'] = $result['attr'];
  184. $productInfo['attrs'] = $result['value'];
  185. $productInfo['attr'] = ['pic' => '', 'price' => 0, 'cost' => 0, 'ot_price' => 0, 'stock' => 0, 'bar_code' => '', 'weight' => 0, 'volume' => 0, 'brokerage' => 0, 'brokerage_two' => 0];
  186. } else {
  187. $result = StoreProductAttrValue::where('product_id', $id)->where('type', 0)->find();
  188. if ($result) {
  189. $single = $result->toArray();
  190. } else {
  191. $single = [];
  192. }
  193. $productInfo['items'] = [];
  194. $productInfo['attrs'] = [];
  195. $productInfo['attr'] = [
  196. 'pic' => $single['image'] ?? '',
  197. 'price' => $single['price'] ?? 0,
  198. 'cost' => $single['cost'] ?? 0,
  199. 'ot_price' => $single['ot_price'] ?? 0,
  200. 'stock' => $single['stock'] ?? 0,
  201. 'bar_code' => $single['bar_code'] ?? '',
  202. 'weight' => $single['weight'] ?? 0,
  203. 'volume' => $single['volume'] ?? 0,
  204. 'brokerage' => $single['brokerage'] ?? 0,
  205. 'brokerage_two' => $single['brokerage_two'] ?? 0,
  206. ];
  207. }
  208. if ($productInfo['activity']) {
  209. $activity = explode(',', $productInfo['activity']);
  210. foreach ($activity as $k => $v) {
  211. if ($v == 1) {
  212. $activity[$k] = '秒杀';
  213. } elseif ($v == 2) {
  214. $activity[$k] = '砍价';
  215. } elseif ($v == 3) {
  216. $activity[$k] = '拼团';
  217. }
  218. }
  219. $productInfo['activity'] = $activity;
  220. } else {
  221. $productInfo['activity'] = ['秒杀', '砍价', '拼团'];
  222. }
  223. $data['productInfo'] = $productInfo;
  224. }
  225. return JsonService::successful($data);
  226. }
  227. /**
  228. * 保存新建的资源
  229. *
  230. *
  231. */
  232. public function save($id)
  233. {
  234. $data = Util::postMore([
  235. ['cate_id', []],
  236. 'store_name',
  237. 'store_info',
  238. 'keyword',
  239. ['unit_name', '件'],
  240. ['image', []],
  241. ['slider_image', []],
  242. ['postage', 0],
  243. ['is_sub', 0],
  244. ['sort', 0],
  245. ['sales', 0],
  246. ['ficti', 100],
  247. ['give_integral', 0],
  248. ['is_show', 0],
  249. ['temp_id', 0],
  250. ['provider_id', 0],
  251. ['is_hot', 0],
  252. ['is_benefit', 0],
  253. ['is_best', 0],
  254. ['is_new', 0],
  255. ['mer_use', 0],
  256. ['is_postage', 0],
  257. ['is_good', 0],
  258. ['description', ''],
  259. ['spec_type', 0],
  260. ['video_link', ''],
  261. ['items', []],
  262. ['attrs', []],
  263. ['activity', []],
  264. ['sources', '']
  265. ]);
  266. foreach ($data['activity'] as $k => $v) {
  267. if ($v == '秒杀') {
  268. $data['activity'][$k] = 1;
  269. } elseif ($v == '砍价') {
  270. $data['activity'][$k] = 2;
  271. } else {
  272. $data['activity'][$k] = 3;
  273. }
  274. }
  275. $data['activity'] = implode(',', $data['activity']);
  276. $detail = $data['attrs'];
  277. $data['price'] = min(array_column($detail, 'price'));
  278. $data['ot_price'] = min(array_column($detail, 'ot_price'));
  279. $data['cost'] = min(array_column($detail, 'cost'));
  280. $attr = $data['items'];
  281. unset($data['items'], $data['video'], $data['attrs']);
  282. if (count($data['cate_id']) < 1) return Json::fail('请选择产品分类');
  283. $cate_id = $data['cate_id'];
  284. $data['cate_id'] = implode(',', $data['cate_id']);
  285. if (!$data['store_name']) return Json::fail('请输入产品名称');
  286. if (count($data['image']) < 1) return Json::fail('请上传产品图片');
  287. if (count($data['slider_image']) < 1) return Json::fail('请上传产品轮播图');
  288. $data['image'] = $data['image'][0];
  289. $data['slider_image'] = json_encode($data['slider_image']);
  290. $data['stock'] = array_sum(array_column($detail, 'stock'));
  291. ProductModel::beginTrans();
  292. foreach ($detail as &$item) {
  293. if (($item['brokerage'] + $item['brokerage_two']) > $item['price']) {
  294. return Json::fail('一二级返佣相加不能大于商品售价');
  295. }
  296. foreach($item as $k=>$v) {
  297. if(is_string($v)) {
  298. $item[$k] = trim($v);
  299. }
  300. }
  301. }
  302. if ($id) {
  303. unset($data['sales']);
  304. ProductModel::edit($data, $id);
  305. $description = $data['description'];
  306. unset($data['description']);
  307. StoreDescription::saveDescription($description, $id);
  308. StoreProductCate::where('product_id', $id)->delete();
  309. $cateData = [];
  310. foreach ($cate_id as $cid) {
  311. $cateData[] = ['product_id' => $id, 'cate_id' => $cid, 'add_time' => time()];
  312. }
  313. StoreProductCate::insertAll($cateData);
  314. if ($data['spec_type'] == 0) {
  315. $attr = [
  316. [
  317. 'value' => '规格',
  318. 'detailValue' => '',
  319. 'attrHidden' => '',
  320. 'detail' => ['默认']
  321. ]
  322. ];
  323. $detail[0]['value1'] = '规格';
  324. $detail[0]['detail'] = ['规格' => '默认'];
  325. } else {
  326. if ($cate_id[0] == Config::get('activity.lucky_cate_id')) {
  327. if (!array_search('幸运', array_column($attr, 'value'))) {
  328. $attr[] = [
  329. 'value' => '幸运',
  330. 'detailValue' => '',
  331. 'attrHidden' => '',
  332. 'detail' => [
  333. 20, 21
  334. ],
  335. ];
  336. }
  337. }
  338. }
  339. $attr_res = StoreProductAttr::createProductAttr($attr, $detail, $id);
  340. if ($attr_res) {
  341. ProductModel::commitTrans();
  342. return Json::success('修改成功!');
  343. } else {
  344. ProductModel::rollbackTrans();
  345. return Json::fail(StoreProductAttr::getErrorInfo());
  346. }
  347. } else {
  348. $data['add_time'] = time();
  349. $data['code_path'] = '';
  350. $res = ProductModel::create($data);
  351. $description = $data['description'];
  352. StoreDescription::saveDescription($description, $res['id']);
  353. $cateData = [];
  354. foreach ($cate_id as $cid) {
  355. $cateData[] = ['product_id' => $res['id'], 'cate_id' => $cid, 'add_time' => time()];
  356. }
  357. StoreProductCate::insertAll($cateData);
  358. if ($data['spec_type'] == 0) {
  359. $attr = [
  360. [
  361. 'value' => '规格',
  362. 'detailValue' => '',
  363. 'attrHidden' => '',
  364. 'detail' => ['默认']
  365. ]
  366. ];
  367. $detail[0]['value1'] = '规格';
  368. $detail[0]['detail'] = ['规格' => '默认'];
  369. } else {
  370. if ($cate_id[0] == Config::get('activity.lucky_cate_id')) {
  371. $attr[] = [
  372. 'value' => '幸运',
  373. 'detailValue' => '',
  374. 'attrHidden' => '',
  375. 'detail' => [
  376. 20, 21
  377. ],
  378. ];
  379. }
  380. }
  381. $attr_res = StoreProductAttr::createProductAttr($attr, $detail, $res['id']);
  382. if ($attr_res) {
  383. ProductModel::commitTrans();
  384. event('AdminAddStoreProduct', ['product'=>$res, 'admin'=>$this->adminInfo]);
  385. return Json::success('添加产品成功!');
  386. } else {
  387. ProductModel::rollbackTrans();
  388. return Json::fail(StoreProductAttr::getErrorInfo());
  389. }
  390. }
  391. }
  392. public function edit_content($id)
  393. {
  394. if (!$id) return $this->failed('数据不存在');
  395. $product = ProductModel::get($id);
  396. if (!$product) return Json::fail('数据不存在!');
  397. $this->assign([
  398. 'content' => $product->description,
  399. 'field' => 'description',
  400. 'action' => Url::buildUrl('change_field', ['id' => $id, 'field' => 'description'])
  401. ]);
  402. return $this->fetch('public/edit_content');
  403. }
  404. /**
  405. * 显示编辑资源表单页.
  406. *
  407. * @param int $id
  408. * @return \think\Response
  409. */
  410. public function edit($id)
  411. {
  412. if (!$id) return $this->failed('数据不存在');
  413. $product = ProductModel::get($id);
  414. if (!$product) return Json::fail('数据不存在!');
  415. $field = [
  416. Form::select('cate_id', '产品分类', explode(',', $product->getData('cate_id')))->setOptions(function () {
  417. $list = CategoryModel::getTierList(null, 1);
  418. $menus = [];
  419. foreach ($list as $menu) {
  420. $menus[] = ['value' => $menu['id'], 'label' => $menu['html'] . $menu['cate_name'], 'disabled' => $menu['pid'] == 0];//,'disabled'=>$menu['pid']== 0];
  421. }
  422. return $menus;
  423. })->filterable(1)->multiple(1),
  424. Form::input('store_name', '产品名称', $product->getData('store_name')),
  425. Form::input('store_info', '产品简介', $product->getData('store_info'))->type('textarea'),
  426. Form::input('keyword', '产品关键字', $product->getData('keyword'))->placeholder('多个用英文状态下的逗号隔开'),
  427. Form::input('unit_name', '产品单位', $product->getData('unit_name'))->col(12),
  428. Form::input('bar_code', '产品条码', $product->getData('bar_code'))->col(12),
  429. Form::frameImageOne('image', '产品主图片(305*305px)', Url::buildUrl('admin/widget.images/index', array('fodder' => 'image')), $product->getData('image'))->icon('image')->width('100%')->height('500px'),
  430. Form::frameImages('slider_image', '产品轮播图(640*640px)', Url::buildUrl('admin/widget.images/index', array('fodder' => 'slider_image')), json_decode($product->getData('slider_image'), 1) ?: [])->maxLength(5)->icon('images')->width('100%')->height('500px'),
  431. Form::number('price', '产品售价', $product->getData('price'))->min(0)->col(8),
  432. Form::number('ot_price', '产品市场价', $product->getData('ot_price'))->min(0)->col(8),
  433. Form::number('give_integral', '赠送积分', $product->getData('give_integral'))->min(0)->col(8),
  434. Form::number('postage', '邮费', $product->getData('postage'))->min(0)->col(8),
  435. Form::number('sales', '销量', $product->getData('sales'))->min(0)->precision(0)->col(8)->readonly(1),
  436. Form::number('ficti', '虚拟销量', $product->getData('ficti'))->min(0)->precision(0)->col(8),
  437. Form::number('stock', '库存', ProductModel::getStock($id) > 0 ? ProductModel::getStock($id) : $product->getData('stock'))->min(0)->precision(0)->col(8),
  438. Form::number('cost', '产品成本价', $product->getData('cost'))->min(0)->col(8),
  439. Form::number('sort', '排序', $product->getData('sort'))->col(8),
  440. Form::radio('is_show', '产品状态', $product->getData('is_show'))->options([['label' => '上架', 'value' => 1], ['label' => '下架', 'value' => 0]])->col(8),
  441. Form::radio('is_hot', '热卖单品', $product->getData('is_hot'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  442. Form::radio('is_benefit', '促销单品', $product->getData('is_benefit'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  443. Form::radio('is_best', '精品推荐', $product->getData('is_best'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  444. Form::radio('is_new', '首发新品', $product->getData('is_new'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  445. Form::radio('is_postage', '是否包邮', $product->getData('is_postage'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  446. Form::radio('is_good', '是否优品推荐', $product->getData('is_good'))->options([['label' => '是', 'value' => 1], ['label' => '否', 'value' => 0]])->col(8),
  447. ];
  448. $form = Form::make_post_form('编辑产品', $field, Url::buildUrl('update', array('id' => $id)), 2);
  449. $this->assign(compact('form'));
  450. return $this->fetch('public/form-builder');
  451. }
  452. /**
  453. * 保存更新的资源
  454. *
  455. * @param $id
  456. */
  457. public function update($id)
  458. {
  459. $data = Util::postMore([
  460. ['cate_id', []],
  461. 'store_name',
  462. 'store_info',
  463. 'keyword',
  464. 'bar_code',
  465. ['unit_name', '件'],
  466. ['image', []],
  467. ['slider_image', []],
  468. ['postage', 0],
  469. ['ot_price', 0],
  470. ['price', 0],
  471. ['sort', 0],
  472. ['stock', 0],
  473. ['temp_id', 0],
  474. ['provider_id', 0],
  475. ['ficti', 100],
  476. ['give_integral', 0],
  477. ['is_show', 0],
  478. ['cost', 0],
  479. ['is_hot', 0],
  480. ['is_benefit', 0],
  481. ['is_best', 0],
  482. ['is_new', 0],
  483. ['mer_use', 0],
  484. ['is_postage', 0],
  485. ['is_good', 0],
  486. ]);
  487. if (count($data['cate_id']) < 1) return Json::fail('请选择产品分类');
  488. $cate_id = $data['cate_id'];
  489. $data['cate_id'] = implode(',', $data['cate_id']);
  490. if (!$data['store_name']) return Json::fail('请输入产品名称');
  491. if (count($data['image']) < 1) return Json::fail('请上传产品图片');
  492. if (count($data['slider_image']) < 1) return Json::fail('请上传产品轮播图');
  493. // if(count($data['slider_image'])>8) return Json::fail('轮播图最多5张图');
  494. if ($data['price'] == '' || $data['price'] < 0) return Json::fail('请输入产品售价');
  495. if ($data['ot_price'] == '' || $data['ot_price'] < 0) return Json::fail('请输入产品市场价');
  496. if ($data['stock'] == '' || $data['stock'] < 0) return Json::fail('请输入库存');
  497. $data['image'] = $data['image'][0];
  498. $data['slider_image'] = json_encode($data['slider_image']);
  499. ProductModel::edit($data, $id);
  500. StoreProductCate::where('product_id', $id)->delete();
  501. foreach ($cate_id as $cid) {
  502. StoreProductCate::insert(['product_id' => $id, 'cate_id' => $cid, 'add_time' => time()]);
  503. }
  504. return Json::successful('修改成功!');
  505. }
  506. public function attr($id)
  507. {
  508. if (!$id) return $this->failed('数据不存在!');
  509. // $result = StoreProductAttrResult::getResult($id);
  510. $result = StoreProductAttrValue::getStoreProductAttrResult($id);
  511. $image = ProductModel::where('id', $id)->value('image');
  512. $this->assign(compact('id', 'result', 'image'));
  513. return $this->fetch();
  514. }
  515. /**
  516. * 生成属性
  517. * @param int $id
  518. */
  519. public function is_format_attr($id = 0, $cate_id= 0, $type = 0)
  520. {
  521. $data = Util::postMore([
  522. ['attrs', []],
  523. ['items', []]
  524. ]);
  525. if (is_array($cate_id)) {
  526. return Json::fail('产品只能属于一个分类');
  527. }
  528. if ($cate_id == Config::get('activity.lucky_cate_id')) {
  529. if (!array_search('幸运', array_column($data['attrs'], 'value'))) {
  530. $data['attrs'][] = [
  531. 'value' => '幸运',
  532. 'detailValue' => '',
  533. 'attrHidden' => '',
  534. 'detail' => [
  535. 20, 21
  536. ],
  537. ];
  538. }
  539. }
  540. $attr = $data['attrs'];
  541. $value = attr_format($attr)[1];
  542. $valueNew = [];
  543. $count = 0;
  544. foreach ($value as $key => $item) {
  545. $detail = $item['detail'];
  546. sort($item['detail'], SORT_STRING);
  547. $suk = implode(',', $item['detail']);
  548. $types = 1;
  549. if ($id) {
  550. $sukValue = StoreProductAttrValue::where('product_id', $id)->where('type', 0)->where('suk', $suk)->column('bar_code,cost,price,ot_price,stock,image as pic,weight,volume,brokerage,brokerage_two', 'suk');
  551. if (!count($sukValue)) {
  552. if ($type == 0) $types = 0; //编辑商品时,将没有规格的数据不生成默认值
  553. $sukValue[$suk]['pic'] = '';
  554. $sukValue[$suk]['price'] = 0;
  555. $sukValue[$suk]['cost'] = 0;
  556. $sukValue[$suk]['ot_price'] = 0;
  557. $sukValue[$suk]['stock'] = 0;
  558. $sukValue[$suk]['bar_code'] = '';
  559. $sukValue[$suk]['weight'] = 0;
  560. $sukValue[$suk]['volume'] = 0;
  561. $sukValue[$suk]['brokerage'] = 0;
  562. $sukValue[$suk]['brokerage_two'] = 0;
  563. }
  564. } else {
  565. $sukValue[$suk]['pic'] = '';
  566. $sukValue[$suk]['price'] = 0;
  567. $sukValue[$suk]['cost'] = 0;
  568. $sukValue[$suk]['ot_price'] = 0;
  569. $sukValue[$suk]['stock'] = 0;
  570. $sukValue[$suk]['bar_code'] = '';
  571. $sukValue[$suk]['weight'] = 0;
  572. $sukValue[$suk]['volume'] = 0;
  573. $sukValue[$suk]['brokerage'] = 0;
  574. $sukValue[$suk]['brokerage_two'] = 0;
  575. }
  576. if ($types) { //编辑商品时,将没有规格的数据不生成默认值
  577. foreach (array_keys($detail) as $k => $title) {
  578. $header[$k]['title'] = $title;
  579. $header[$k]['align'] = 'center';
  580. $header[$k]['minWidth'] = 130;
  581. }
  582. foreach (array_values($detail) as $k => $v) {
  583. $valueNew[$count]['value' . ($k + 1)] = $v;
  584. $header[$k]['key'] = 'value' . ($k + 1);
  585. }
  586. $valueNew[$count]['detail'] = $detail;
  587. $valueNew[$count]['pic'] = $sukValue[$suk]['pic'] ?? '';
  588. $valueNew[$count]['price'] = $sukValue[$suk]['price'] ? floatval($sukValue[$suk]['price']) : 0;
  589. $valueNew[$count]['cost'] = $sukValue[$suk]['cost'] ? floatval($sukValue[$suk]['cost']) : 0;
  590. $valueNew[$count]['ot_price'] = isset($sukValue[$suk]['ot_price']) ? floatval($sukValue[$suk]['ot_price']) : 0;
  591. $valueNew[$count]['stock'] = $sukValue[$suk]['stock'] ? intval($sukValue[$suk]['stock']) : 0;
  592. $valueNew[$count]['bar_code'] = $sukValue[$suk]['bar_code'] ?? '';
  593. $valueNew[$count]['weight'] = $sukValue[$suk]['weight'] ?? 0;
  594. $valueNew[$count]['volume'] = $sukValue[$suk]['volume'] ?? 0;
  595. $valueNew[$count]['brokerage'] = $sukValue[$suk]['brokerage'] ?? 0;
  596. $valueNew[$count]['brokerage_two'] = $sukValue[$suk]['brokerage_two'] ?? 0;
  597. $count++;
  598. }
  599. }
  600. $header[] = ['title' => '图片', 'slot' => 'pic', 'align' => 'center', 'minWidth' => 80];
  601. $header[] = ['title' => '售价', 'slot' => 'price', 'align' => 'center', 'minWidth' => 120];
  602. $header[] = ['title' => '成本价', 'slot' => 'cost', 'align' => 'center', 'minWidth' => 140];
  603. $header[] = ['title' => '原价', 'slot' => 'ot_price', 'align' => 'center', 'minWidth' => 140];
  604. $header[] = ['title' => '库存', 'slot' => 'stock', 'align' => 'center', 'minWidth' => 140];
  605. $header[] = ['title' => '产品编号', 'slot' => 'bar_code', 'align' => 'center', 'minWidth' => 140];
  606. $header[] = ['title' => '重量(KG)', 'slot' => 'weight', 'align' => 'center', 'minWidth' => 140];
  607. $header[] = ['title' => '体积(m³)', 'slot' => 'volume', 'align' => 'center', 'minWidth' => 140];
  608. $header[] = ['title' => '操作', 'slot' => 'action', 'align' => 'center', 'minWidth' => 70];
  609. $info = ['attr' => $attr, 'value' => $valueNew, 'header' => $header];
  610. return Json::successful($info);
  611. }
  612. public function set_attr($id)
  613. {
  614. if (!$id) return $this->failed('产品不存在!');
  615. list($attr, $detail) = Util::postMore([
  616. ['items', []],
  617. ['attrs', []]
  618. ], null, true);
  619. $res = StoreProductAttr::createProductAttr($attr, $detail, $id);
  620. if ($res)
  621. return $this->successful('编辑属性成功!');
  622. else
  623. return $this->failed(StoreProductAttr::getErrorInfo());
  624. }
  625. public function clear_attr($id)
  626. {
  627. if (!$id) return $this->failed('产品不存在!');
  628. if (false !== StoreProductAttr::clearProductAttr($id) && false !== StoreProductAttrResult::clearResult($id))
  629. return $this->successful('清空产品属性成功!');
  630. else
  631. return $this->failed(StoreProductAttr::getErrorInfo('清空产品属性失败!'));
  632. }
  633. /**
  634. * 删除指定资源
  635. *
  636. * @param int $id
  637. * @return \think\Response
  638. */
  639. public function delete($id)
  640. {
  641. if (!$id) return $this->failed('数据不存在');
  642. if (!ProductModel::be(['id' => $id])) return $this->failed('产品数据不存在');
  643. if (ProductModel::be(['id' => $id, 'is_del' => 1])) {
  644. $data['is_del'] = 0;
  645. if (!ProductModel::edit($data, $id))
  646. return Json::fail(ProductModel::getErrorInfo('恢复失败,请稍候再试!'));
  647. else
  648. return Json::successful('成功恢复产品!');
  649. } else {
  650. $res1 = StoreSeckill::where('product_id', $id)->where('is_del', 0)->find();
  651. $res2 = StoreBargain::where('product_id', $id)->where('is_del', 0)->find();
  652. $res3 = StoreCombination::where('product_id', $id)->where('is_del', 0)->find();
  653. if ($res1 || $res2 || $res3) {
  654. return Json::fail(ProductModel::getErrorInfo('该商品已参加活动,无法删除!'));
  655. } else {
  656. $data['is_del'] = 1;
  657. if (!ProductModel::edit($data, $id))
  658. return Json::fail(ProductModel::getErrorInfo('删除失败,请稍候再试!'));
  659. else
  660. return Json::successful('成功移到回收站!');
  661. }
  662. }
  663. }
  664. /**
  665. * 点赞
  666. * @param $id
  667. * @return mixed|\think\response\Json|void
  668. */
  669. public function collect($id)
  670. {
  671. if (!$id) return $this->failed('数据不存在');
  672. $product = ProductModel::get($id);
  673. if (!$product) return Json::fail('数据不存在!');
  674. $this->assign(StoreProductRelation::getCollect($id));
  675. return $this->fetch();
  676. }
  677. /**
  678. * 收藏
  679. * @param $id
  680. * @return mixed|\think\response\Json|void
  681. */
  682. public function like($id)
  683. {
  684. if (!$id) return $this->failed('数据不存在');
  685. $product = ProductModel::get($id);
  686. if (!$product) return Json::fail('数据不存在!');
  687. $this->assign(StoreProductRelation::getLike($id));
  688. return $this->fetch();
  689. }
  690. /**
  691. * 修改产品价格
  692. */
  693. public function edit_product_price()
  694. {
  695. $data = Util::postMore([
  696. ['id', 0],
  697. ['price', 0],
  698. ]);
  699. if (!$data['id']) return Json::fail('参数错误');
  700. $res = ProductModel::edit(['price' => $data['price']], $data['id']);
  701. if ($res) return Json::successful('修改成功');
  702. else return Json::fail('修改失败');
  703. }
  704. /**
  705. * 修改产品库存
  706. *
  707. */
  708. public function edit_product_stock()
  709. {
  710. $data = Util::postMore([
  711. ['id', 0],
  712. ['stock', 0],
  713. ]);
  714. if (!$data['id']) return Json::fail('参数错误');
  715. $res = ProductModel::edit(['stock' => $data['stock']], $data['id']);
  716. if ($res) return Json::successful('修改成功');
  717. else return Json::fail('修改失败');
  718. }
  719. /**
  720. * 检测商品是否开活动
  721. * @param $id
  722. * @throws \think\db\exception\DataNotFoundException
  723. * @throws \think\db\exception\DbException
  724. * @throws \think\db\exception\ModelNotFoundException
  725. */
  726. public function check_activity($id)
  727. {
  728. if ($id != 0) {
  729. $res1 = StoreSeckill::where('product_id', $id)->where('is_del', 0)->find();
  730. $res2 = StoreBargain::where('product_id', $id)->where('is_del', 0)->find();
  731. $res3 = StoreCombination::where('product_id', $id)->where('is_del', 0)->find();
  732. if ($res1 || $res2 || $res3) {
  733. return Json::successful('该商品有活动开启,无法删除属性');
  734. } else {
  735. return Json::fail('删除成功');
  736. }
  737. } else {
  738. return Json::fail('没有参数ID');
  739. }
  740. }
  741. }