Cat.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\ActionLog;
  4. use app\admin\model\ChangeLog;
  5. use app\BaseController;
  6. use think\App;
  7. use think\Exception;
  8. use think\facade\Db;
  9. use think\facade\Validate;
  10. //分类
  11. class Cat extends Base
  12. {
  13. //树状列表
  14. public function list()
  15. {
  16. $param = $this->request->only(['pid' => 0, 'cat_name' => ''], 'post', 'trim');
  17. $where = [['is_del', '=', 0], ['pid', '=', $param['pid']]];
  18. if ($param['cat_name'] !== '') $where[] = ['cat_name', 'like', '%' . $param['cat_name'] . '%'];
  19. $data = Db::name('cat')->where($where)->order("id desc")->cursor();
  20. $vmp = [];
  21. foreach ($data as $sts) {
  22. $vmp[] = stro($sts);
  23. }
  24. return app_show(0, '获取成功', $vmp);
  25. }
  26. //列表(含规格和创建人部门)
  27. public function plist()
  28. {
  29. $param = $this->request->only(['page' => 1, 'size' => 10, 'cat_name' => '', 'pid' => '', 'status' => '', 'company_name' => ''], 'post', 'trim');
  30. $where = [['c.is_del', '=', 0]];
  31. if ($param['cat_name'] !== '') $where[] = ['c.cat_name', 'like', '%' . $param['cat_name'] . '%'];
  32. if ($param['pid'] !== '') $where[] = ['c.pid', '=', $param['pid']];
  33. if ($param['status'] !== '') $where[] = ['c.status', '=', $param['status']];
  34. if ($param['company_name'] !== '') $where[] = ['c.createrid', 'in', get_company_item_user_by_name($param['company_name'])];
  35. $count = Db::name('cat')->alias('c')->where($where)->count();
  36. $list = Db::name('cat')
  37. ->alias('c')
  38. ->where($where)
  39. ->page($param['page'], $param['size'])
  40. ->order(['c.id'=>'desc'])
  41. ->select()
  42. ->toArray();
  43. $var = [];
  44. $all_createrid = array_column($list,'createrid');
  45. $item = get_company_name_by_uid($all_createrid);
  46. foreach ($list as $value) {
  47. $temp = Db::name('cat_specs')
  48. ->field('a.specs_id,b.spec_name')
  49. ->alias('a')
  50. ->leftJoin('specs b', 'b.id=a.specs_id')
  51. ->where(['a.cat_id' => $value['id'], 'a.is_del' => 0])
  52. ->select()
  53. ->toArray();
  54. if (empty($temp)) {
  55. $temp = [];
  56. }
  57. $value['im'] = $temp;
  58. $value['company_name'] = $item[$value['createrid']]??'';
  59. $var[] = $value;
  60. }
  61. return app_show(0, '获取成功', ['list' => $var, 'count' => $count]);
  62. }
  63. //查看所有三级分类
  64. public function wlist()
  65. {
  66. $param = $this->request->only(['page' => 1, 'size' => 10, 'cat_name' => '', 'search' => '', 'pid' => '', 'status' => ''], 'post', 'trim');
  67. $where = [['is_del', '=', 0], ['level', '=', 3]];
  68. if ($param['cat_name'] !== '') $where[] = ['cat_name', 'like', '%' . $param['cat_name'] . '%'];
  69. if ($param['search'] !== '') $where[] = ['search', 'like', '%' . $param['search'] . '%'];
  70. if ($param['pid'] !== '') $where[] = ['pid', '=', $param['pid']];
  71. if ($param['status'] !== '') $where[] = ['status', '=', $param['status']];
  72. $count = Db::name('cat')
  73. ->where($where)
  74. ->count();
  75. $list = Db::name('cat')
  76. ->where($where)
  77. ->page($param['page'], $param['size'])
  78. ->select()
  79. ->toArray();
  80. $data = [];
  81. foreach ($list as $value) {
  82. $value['item'] = array_column(made($value['id'] ?? 0), 'id');
  83. $data[] = $value;
  84. }
  85. return app_show(0, '获取成功', ['list' => $data, 'count' => $count]);
  86. }
  87. //列表
  88. public function title()
  89. {
  90. $param = $this->request->only(['cat_name' => '', 'pid' => '', 'status' => '',], 'post', 'trim');
  91. $where = [['is_del', '=', 0]];
  92. if ($param['cat_name'] !== '') $where[] = ['cat_name', 'like', '%' . $param['cat_name'] . '%'];
  93. if ($param['pid'] !== '') $where[] = ['pid', '=', $param['pid']];
  94. if ($param['status'] !== '') $where[] = ['status', '=', $param['status']];
  95. $list = Db::name('cat')
  96. ->where($where)
  97. ->select()
  98. ->toArray();
  99. return app_show(0, '获取成功', $list);
  100. }
  101. //列表
  102. public function tlist()
  103. {
  104. $param = $this->request->only(['page' => 1, 'size' => 10, 'cat_name' => '', 'status' => '', 'creater' => '', 'start' => '', 'end' => '', 'company_name' => ''], 'post', 'trim');
  105. $where = [['c.is_del', '=', 0]];
  106. if ($param['cat_name'] !== '') $where[] = ['c.cat_name', 'like', '%' . $param['cat_name'] . '%'];
  107. if ($param['status'] !== '') $where[] = ['c.status', '=', $param['status']];
  108. if ($param['creater'] !== '') $where[] = ['c.creater', 'like', '%' . $param['creater'] . '%'];
  109. if ($param['start'] !== '') $where[] = ['c.addtime', '>=', $param['start']];
  110. if ($param['end'] !== '') $where[] = ['c.addtime', '<=', $param['end']];
  111. if ($param['company_name'] !== '') $where[] = ['c.createrid', 'in', get_company_item_user_by_name($param['company_name'])];
  112. $count = Db::name('cat')
  113. ->alias('c')
  114. ->leftJoin('depart_user u', 'u.uid=c.createrid AND u.is_del=0')
  115. ->where($where)
  116. ->count();
  117. // $total = ceil($count / $size);
  118. // $page = $page >= $total ? $total : $page;
  119. $list = Db::name('cat')
  120. ->alias('c')
  121. ->where($where)
  122. ->page($param['page'], $param['size'])
  123. ->order("id desc")
  124. ->select()
  125. ->toArray();
  126. $var = [];
  127. $all_createrid = array_column($list,'createrid');
  128. $item = get_company_name_by_uid($all_createrid);
  129. foreach ($list as $value) {
  130. $temp = Db::name('cat_specs')
  131. ->field('a.specs_id,b.spec_name')
  132. ->alias('a')
  133. ->leftJoin('specs b', 'b.id=a.specs_id')
  134. ->where(['a.cat_id' => $value['id'], 'a.is_del' => 0])
  135. ->select()
  136. ->toArray();
  137. $value['im'] = $temp;
  138. $value['company_name'] = $item[$value['createrid']] ?? '';
  139. $var[] = $value;
  140. }
  141. return app_show(0, '获取成功', ['list' => $var, 'count' => $count]);
  142. }
  143. //创建
  144. public function create()
  145. {
  146. $param = $this->request->only(['cat_name', 'pid', 'cat_desc' => '', 'fund_code' => '', 'specs_id', 'weight' => 0, 'status' => 0], 'post', 'trim');
  147. // $cat_name = isset($this->post['cat_name']) && $this->post['cat_name'] !== '' ? trim($this->post['cat_name']) : '';
  148. $val = Validate::rule([
  149. 'cat_name|分类名称' => 'require|max:255',
  150. 'pid|父级id' => 'require|number|egt:0',
  151. 'specs_id' => 'require|array|max:100',
  152. 'weight|权重' => 'number|egt:0',
  153. 'status|状态' => 'number|in:0,1',
  154. ]);
  155. if (!$val->check($param)) return json_show(1004, $val->getError());
  156. // if ($cat_name == '') {
  157. // return error_show(1002, '参数cat_name不能为空');
  158. // }
  159. // $pid = isset($this->post['pid']) && $this->post['pid'] !== '' ? intval($this->post['pid']) : '0';
  160. // if ($pid === '') {
  161. // return error_show(1002, '参数pid不能为空');
  162. // }
  163. // $cat_desc = isset($this->post['cat_desc']) && $this->post['cat_desc'] !== '' ? trim($this->post['cat_desc']) : '';
  164. // $fund_code = isset($this->post['fund_code']) && $this->post['fund_code'] !== '' ? trim($this->post['fund_code']) : '';
  165. $level = 1;
  166. if ($param['pid'] != 0) {
  167. $levl = Db::name('cat')
  168. ->field('id,level,search')
  169. ->where(['id' => $param['pid']])
  170. ->find();
  171. if (empty($levl)) return json_show(1002, '未找到父级数据');
  172. $level = $levl['level'] + 1;
  173. $temp = $levl['search'];
  174. }
  175. if ($level == 1) $search = $param['cat_name'];
  176. else $search = $temp . '-' . $param['cat_name'];
  177. $repeat_name = Db::name('cat')
  178. ->field('id')
  179. ->where(['is_del' => 0, 'cat_name' => $param['cat_name']])
  180. ->find();
  181. $int = isset($repeat_name['id']) && $repeat_name['id'] != 0 ? made($repeat_name['id']) : [];
  182. $im = array_column($int, 'name');
  183. $in = implode('/', $im);
  184. if (!empty($repeat_name)) {
  185. return json_show(1004, "分类名称已在{$in}存在");
  186. }
  187. // $specs_id = isset($this->post['specs_id']) && $this->post['specs_id'] !== '' ? $this->post['specs_id'] : [];
  188. // if (empty($specs_id)) {
  189. // return error_show(1002, '参数specs_id不能为空');
  190. // }
  191. // $token = isset($this->post['token']) && $this->post['token'] != '' ? trim($this->post['token']) : '';
  192. // if ($token == '') {
  193. // return error_show(105, '参数token不能为空');
  194. // }
  195. // $user = GetUserInfo($token);
  196. // if (empty($user) || $user['code'] != 0) {
  197. // return error_show(102, '创建人数据不存在');
  198. // }
  199. $createrid = $this->uid;//isset($user['data']['id']) ? $user['data']['id'] : '';
  200. $creater = $this->uname;//($user['data']['nickname']) ? $user['data']['nickname'] : '';
  201. // $weight = isset($this->post['weight']) && $this->post['weight'] !== '' ? intval($this->post['weight']) : '0';
  202. // $status = isset($this->post['status']) && $this->post['status'] !== '' ? intval($this->post['status']) : '0';
  203. Db::startTrans();
  204. try {
  205. $date = date('Y-m-d H:i:s');
  206. $data = [
  207. 'cat_name' => $param['cat_name'],
  208. 'pid' => $param['pid'],
  209. 'level' => $level,
  210. 'search' => $search,
  211. 'weight' => $param['weight'],
  212. 'status' => $param['status'],
  213. 'cat_desc' => $param['cat_desc'],
  214. 'fund_code' => $param['fund_code'],
  215. 'creater' => $creater,
  216. 'createrid' => $createrid,
  217. 'is_del' => 0,
  218. 'addtime' => $date,
  219. 'updatetime' => $date,
  220. ];
  221. $datainfo = Db::name('cat')->insertGetId($data);
  222. $vat = [];
  223. if ($datainfo > 0) {
  224. $stx = ['order_code' => $param['pid'], 'status' => $param['status'], 'action_remark' => '', 'action_type' => 'create'];
  225. ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], $stx, 'sxd', $param['status'], $stx);
  226. $spc = [];
  227. $spc['cat_id'] = $datainfo;
  228. $spc['exam_status'] = 0;
  229. $spc['status'] = 0;
  230. $spc['creater'] = $creater;
  231. $spc['createrid'] = $createrid;
  232. $spc['is_del'] = 0;
  233. $spc['addtime'] = $date;
  234. $spc['updatetime'] = $date;
  235. $vpn = Db::name('cat_spec')->insertGetId($spc);
  236. if ($vpn == '') throw new Exception('新建失败');
  237. foreach ($param['specs_id'] as $value) {
  238. $item = [];
  239. $item['cat_id'] = $datainfo;
  240. $item['specs_id'] = $value;
  241. $item['is_del'] = 0;
  242. $item['addtime'] = $date;
  243. $vat[] = $item;
  244. }
  245. $vp = Db::name('cat_specs')->insertAll($vat);
  246. if ($vp == 0) throw new Exception('新建失败');
  247. $catinfo = ['cat_id' => $datainfo, 'apply_name' => $creater, 'apply_id' => $createrid, 'fund_code' => $param['fund_code'], 'status' => 0];
  248. $this->addPlat($catinfo);
  249. Db::commit();
  250. return json_show(0, '新建成功');
  251. } else {
  252. Db::rollback();
  253. return json_show(1002, '新建失败');
  254. }
  255. } catch (Exception $exception) {
  256. Db::rollback();
  257. return json_show(1005, $exception->getMessage());
  258. }
  259. }
  260. //编辑
  261. public function edit()
  262. {
  263. $id = isset($this->post['id']) && $this->post['id'] !== '' ? intval($this->post['id']) : '';
  264. $idinfo = Db::name('cat')->where(['id' => $id])->find();
  265. if ($idinfo == '') {
  266. return error_show(1002, '未找到商品数据');
  267. }
  268. $cat_name = isset($this->post['cat_name']) && $this->post['cat_name'] !== '' ? trim($this->post['cat_name']) : '';
  269. if ($cat_name == '') {
  270. return error_show(1002, '参数cat_name不能为空');
  271. }
  272. $pid = isset($this->post['pid']) && $this->post['pid'] !== '' ? intval($this->post['pid']) : '';
  273. if ($pid === '') {
  274. return error_show(1002, '参数pid不能为空');
  275. }
  276. $cat_desc = isset($this->post['cat_desc']) && $this->post['cat_desc'] !== '' ? trim($this->post['cat_desc']) : '';
  277. $fund_code = isset($this->post['fund_code']) && $this->post['fund_code'] !== '' ? trim($this->post['fund_code']) : '';
  278. $specs_id = isset($this->post['specs_id']) && $this->post['specs_id'] !== '' ? $this->post['specs_id'] : [];
  279. if (empty($specs_id)) {
  280. return error_show(1002, '参数specs_id不能为空');
  281. }
  282. // $token = isset($this->post['token']) && $this->post['token'] != '' ? trim($this->post['token']) : '';
  283. // if ($token == '') {
  284. // return error_show(105, '参数token不能为空');
  285. // }
  286. // $user = GetUserInfo($token);
  287. // if (empty($user) || $user['code'] != 0) {
  288. // return error_show(102, '创建人数据不存在');
  289. // }
  290. $level = 1;
  291. if ($pid !== 0) {
  292. $levl = Db::name('cat')->where(['id' => $pid])->find();
  293. if (empty($levl)) {
  294. return error_show(1002, '未找到父级数据');
  295. }
  296. $level = $levl['level'] + 1;
  297. $temp = $levl['search'];
  298. }
  299. if ($level == 1) {
  300. $search = $cat_name;
  301. } else {
  302. $search = $temp . '_' . $cat_name;
  303. }
  304. $createrid = $this->uid;//isset($user['data']['id']) ? $user['data']['id'] : '';
  305. $creater = $this->uname;//isset($user['data']['nickname']) ? $user['data']['nickname'] : '';
  306. //$level = isset($this->post['level']) && $this->post['level'] !=='' ? intval($this->post['level']) :'';
  307. $weight = isset($this->post['weight']) && $this->post['weight'] !== '' ? intval($this->post['weight']) : '0';
  308. $status = isset($this->post['status']) && $this->post['status'] !== '' ? intval($this->post['status']) : '0';
  309. Db::startTrans();
  310. try {
  311. $str = [
  312. 'id' => $id,
  313. 'cat_name' => $cat_name,
  314. 'pid' => $pid,
  315. 'level' => $level,
  316. 'weight' => $weight,
  317. // 'status'=>$status,
  318. 'cat_desc' => $cat_desc,
  319. 'is_del' => 0,
  320. 'fund_code' => $fund_code,
  321. 'updatetime' => date('Y-m-d H:i:s'),
  322. 'search' => $search
  323. ];
  324. $strinfo = Db::name('cat')->where(['id' => $id])->save($str);
  325. $temp = array_diff($str, $idinfo);
  326. $json = json_encode($temp, JSON_UNESCAPED_UNICODE);
  327. $jsp = json_encode($idinfo, JSON_UNESCAPED_UNICODE);
  328. if ($strinfo) {
  329. $order = ['order_code' => $id, 'status' => $status, 'action_remark' => '', 'action_type' => 'edit'];
  330. ActionLog::logAdd(['id'=>$createrid,'nickname'=>$creater], $order, 'sxd', $status, $order);
  331. ChangeLog::logAdd(7, $idinfo['id'], $jsp, $json, ['id'=>$createrid,'nickname'=>$creater]);
  332. $spc = [];
  333. $vp = Db::name('cat_spec')->where(['cat_id' => $idinfo['id'], 'is_del' => 0])->find();
  334. $str = '';
  335. if ($vp != false) {
  336. isset($vp['id']) && $vp['id'] !== '' ? $spc['id'] = $vp['id'] : '';
  337. $spc['cat_id'] = $idinfo['id'];
  338. $spc['exam_status'] = 0;
  339. $spc['status'] = 0;
  340. $spc['is_del'] = 0;
  341. $spc['updatetime'] = date('Y-m_d H:i:s');
  342. $str = $vp['id'];
  343. $vpn = Db::name('cat_spec')->save($spc);
  344. } else {
  345. $spc['cat_id'] = $idinfo['id'];
  346. $spc['exam_status'] = 0;
  347. $spc['status'] = 0;
  348. $spc['creater'] = $creater;
  349. $spc['createrid'] = $createrid;
  350. $spc['is_del'] = 0;
  351. $spc['addtime'] = date('Y-m-d H:i:d');
  352. $spc['updatetime'] = date('Y-m_d H:i:s');
  353. $vpn = Db::name('cat_spec')->insert($spc, true);
  354. $str = $vpn;
  355. }
  356. if ($vpn == false) {
  357. Db::rollback();
  358. return error_show(1002, '更新失败');
  359. }
  360. $db = Db::name('cat_specs')->where(['cat_id' => $idinfo['id'], 'is_del' => 0])->column('specs_id');
  361. if (empty($db)) {
  362. $db = [];
  363. }
  364. $sn = array_diff($specs_id, $db);
  365. $st = array_diff($db, $specs_id);
  366. if (!empty($st)) {
  367. $int['is_del'] = 1;
  368. $dn = Db::name('cat_specs')->where(['cat_id' => $idinfo['id'], 'specs_id' => $st, 'is_del' => 0])->save($int);
  369. if ($dn == false) {
  370. Db::rollback();
  371. return error_show(1002, '编辑失败');
  372. }
  373. }
  374. if (!empty($sn)) {
  375. $vat = [];
  376. foreach ($sn as $value) {
  377. $item = [];
  378. $item['cat_id'] = $idinfo['id'];
  379. $item['specs_id'] = $value;
  380. $item['is_del'] = 0;
  381. $item['addtime'] = date('Y-m-d H:i:s');
  382. $vat[] = $item;
  383. }
  384. $vp = Db::name('cat_specs')->insertAll($vat);
  385. if ($vp == 0) {
  386. Db::rollback();
  387. return error_show(1002, '编辑失败');
  388. }
  389. }
  390. $itn = sear($id);
  391. Db::commit();
  392. return error_show(0, '编辑成功');
  393. } else {
  394. Db::rollback();
  395. return error_show(1002, '编辑失败');
  396. }
  397. } catch (\Exception $e) {
  398. Db::rollback();
  399. return error_show(1005, $e->getMessage());
  400. }
  401. }
  402. //更新分类利率相关
  403. public function ratedit()
  404. {
  405. $id = isset($this->post['id']) && $this->post['id'] !== '' ? intval($this->post['id']) : '';
  406. $idinfo = Db::name('cat')->where(['id' => $id])->find();
  407. if ($idinfo == '') {
  408. return error_show(1002, '未找到商品数据');
  409. }
  410. $rate = isset($this->post['rate']) && $this->post['rate'] !== '' ? floatval($this->post['rate']) : '';
  411. $order_rate = isset($this->post['order_rate']) && $this->post['order_rate'] !== '' ? floatval($this->post['order_rate']) : '';
  412. $sale_rate = isset($this->post['sale_rate']) && $this->post['sale_rate'] !== '' ? floatval($this->post['sale_rate']) : '';
  413. $lower_rate = isset($this->post['lower_rate']) && $this->post['lower_rate'] !== '' ? floatval($this->post['lower_rate']) : '';
  414. $money_rate = isset($this->post['money_rate']) && $this->post['money_rate'] !== '' ? floatval($this->post['money_rate']) : '';
  415. $low_rate = isset($this->post['low_rate']) && $this->post['low_rate'] !== '' ? floatval($this->post['low_rate']) : '';
  416. if ($idinfo['pid'] == 0) {
  417. if ($rate === '') {
  418. return error_show(1003, '参数rate不能为空');
  419. }
  420. if ($order_rate === '') {
  421. return error_show(1003, '参数order_rate不能为空');
  422. }
  423. if ($sale_rate === '') {
  424. return error_show(1003, '参数sale_rate不能为空');
  425. }
  426. if ($lower_rate === '') {
  427. return error_show(1003, '参数lower_rate不能为空');
  428. }
  429. if ($money_rate == '') {
  430. return error_show(1003, '参数money_rate不能为空');
  431. }
  432. if ($low_rate == '') {
  433. return error_show(1003, '参数low_rate不能为空');
  434. }
  435. }
  436. $data = [
  437. 'id' => $id,
  438. 'rate' => $rate,
  439. 'lower_rate' => $lower_rate,
  440. 'order_rate' => $order_rate,
  441. 'sale_rate' => $sale_rate,
  442. 'money_rate' => $money_rate,
  443. 'low_rate' => $low_rate,
  444. 'is_del' => 0,
  445. 'updatetime' => date('Y-m-d H:i:s'),
  446. ];
  447. $strinfo = Db::name('cat')->where(['id' => $id])->save($data);
  448. if ($strinfo) {
  449. return error_show(0, '更新成功');
  450. } else {
  451. return error_show(1002, '更新失败');
  452. }
  453. }
  454. //详情
  455. public function info()
  456. {
  457. // $id = isset($this->post['id']) && $this->post['id'] !== '' ? intval($this->post['id']) : '';
  458. $id = $this->request->post('id/d', 0, 'trim');
  459. // if ($id == '') {
  460. // return error_show(1002, '参数id不能为空');
  461. // }
  462. // $idinfo = Db::name('cat')->where(['id' => $id])->find();
  463. // if ($idinfo == '') {
  464. // return error_show(1002, '未找到数据');
  465. // }
  466. $idinfo = Db::name('cat')
  467. ->where(['id' => $id])
  468. ->append(['spec'])
  469. ->withAttr('spec', function ($val, $da) {
  470. return Db::name('cat_specs')
  471. ->alias('a')
  472. ->leftJoin('specs b', 'b.id=a.specs_id')
  473. ->where(['a.cat_id' => $da['id'], 'a.is_del' => 0])
  474. ->field('a.specs_id id,b.spec_name')
  475. ->select()
  476. ->toArray();
  477. })
  478. ->findOrEmpty();
  479. // $info = Db::name('cat_specs')->where(['cat_id' => $idinfo['id'], 'is_del' => 0])->column('specs_id');
  480. // $temp = Db::name('specs')->where(['id' => $info, 'is_del' => 0])->field('id,spec_name')->select();
  481. //$idinfo['cat_id']=$info['cat_id'];
  482. // $idinfo['spec'] = $temp;
  483. // $idinfo['specs_id']=$info;
  484. return $idinfo ? json_show(0, '获取成功', $idinfo) : json_show(1002, '未找到数据');
  485. }
  486. //启禁用
  487. public function status()
  488. {
  489. $id = isset($this->post['id']) && $this->post['id'] !== '' ? intval($this->post['id']) : '';
  490. if ($id === '') {
  491. return error_show(1002, '参数id不能为空');
  492. }
  493. $stn = Db::name('cat')->where(['id' => $id])->find();
  494. if (empty($stn)) {
  495. return error_show(1002, '未找到商品数据');
  496. }
  497. $status = isset($this->post['status']) && $this->post['status'] !== '' ? intval($this->post['status']) : '';
  498. if ($status === '') {
  499. return error_show(1002, '参数status不能为空');
  500. }
  501. // if ($status == 1) {
  502. // if ($stn['rate'] === '') {
  503. // return error_show(1003, '单品修改下限未设置');
  504. // }
  505. // if ($stn['order_rate'] === '') {
  506. // return error_show(1003, '预算成本利率未设置');
  507. // }
  508. // if ($stn['sale_rate'] === '') {
  509. // return error_show(1003, '分类成本售价利率未设置');
  510. // }
  511. // if ($stn['lower_rate'] === '') {
  512. // return error_show(1003, '分类最低毛利率未设置');
  513. // }
  514. // if($stn['money_rate']==''){
  515. // return error_show(1003,'分类财务利率未设置');
  516. // }
  517. // if($stn['low_rate']==''){
  518. // return error_show(1003,'分类最低毛利未设置');
  519. // }
  520. // if($stn['fund_code']==''){
  521. // return error_show(1003,'分类核算码未设置');
  522. // }
  523. // }
  524. if ($stn['level'] == 3) {
  525. if ($status == 1) {
  526. $can = made($stn['id']);
  527. $cat = array_column($can, 'id');
  528. } else {
  529. $cat = $stn['id'];
  530. }
  531. // return error_show(1002, '所在级别不能启用');
  532. }
  533. if ($stn['level'] == 2 || $stn['level'] == 1) {
  534. if ($status == 1) {
  535. return error_show(1002, '所在等级不能启用');
  536. } else {
  537. $db = Db::name('cat')->where(['pid' => $stn['id'], 'status' => 1, 'is_del' => 0])->count();
  538. if ($db == 0) {
  539. $cat = $stn['id'];
  540. } else {
  541. return error_show(1002, '子级分类未禁用');
  542. }
  543. }
  544. }
  545. // $pd= $stn['status'];
  546. $it = [];
  547. $it['status'] = $status;
  548. $it['updatetime'] = date('Y-m-d H:i:s');
  549. $str = Db::name('cat')->where(['id' => $cat, 'is_del' => 0])->save($it);
  550. if ($str) {
  551. $catinfo = ['cat_id' => $id, 'status' => $status];
  552. $this->addPlat($catinfo);
  553. if (!empty($cat)) {
  554. $catinfo = ['cat_id' => $cat, 'status' => $status];
  555. $this->addPlat($catinfo);
  556. }
  557. return error_show(0, '状态更新成功');
  558. } else {
  559. return error_show(1002, '状态更新失败');
  560. }
  561. }
  562. //删除
  563. public function delete()
  564. {
  565. $id = isset($this->post['id']) && $this->post['id'] !== '' ? intval($this->post['id']) : '';
  566. $info = Db::name('cat')->where(['is_del' => 0, 'id' => $id])->find();
  567. if ($info == false) {
  568. return error_show(1002, '未找到数据');
  569. }
  570. $supp = Db::name('cat')->update(['id' => $id, 'is_del' => 1, 'updatetime' => date('Y-m-d H:i:s')]);
  571. if ($supp) {
  572. return error_show(0, '删除成功');
  573. } else {
  574. return error_show(1002, '删除失败');
  575. }
  576. }
  577. //平台添加分类
  578. private function addPlat($cat)
  579. {
  580. $plat = Db::name('platform')
  581. ->field('id')
  582. ->where(['platform_type' => 1, 'is_del' => 0])
  583. ->select()
  584. ->toArray();
  585. if (empty($plat)) return false;
  586. $date = date('Y-m-d H:i:s');
  587. $isT = Db::name('cat_plat')
  588. ->where(['cat_id' => $cat['cat_id'], 'is_del' => 0])
  589. ->column('id', 'platform_id');
  590. foreach ($plat as $value) {
  591. $cat['platform_id'] = $value['id'];
  592. $cat['addtime'] = $date;
  593. $cat['updatetime'] = $date;
  594. // $isT = Db::name('cat_plat')
  595. // ->where(['cat_id' => $cat['cat_id'], 'platform_id' => $cat['platform_id'], 'is_del' => 0])
  596. // ->column('cat_id');
  597. if (isset($isT[$cat['platform_id']])) {
  598. $data = $cat;
  599. unset($data['cat_id']);
  600. unset($data['addtime']);
  601. Db::name('cat_plat')
  602. ->where('id', $isT[$cat['platform_id']])
  603. ->update($data);
  604. } else Db::name('cat_plat')->save($cat);
  605. }
  606. return true;
  607. }
  608. }