Cate.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: wugg
  5. * Date: 2024/6/28
  6. * Time: 16:03
  7. * description:分类控制器
  8. */
  9. namespace app\admin\controller;
  10. use app\admin\model\CatSpecs;
  11. use app\admin\model\Cat;
  12. use think\App;
  13. use think\facade\Validate;
  14. class Cate extends Base{
  15. public function __construct(App $app) {
  16. parent::__construct($app);
  17. $this->model = new Cat();
  18. }
  19. /**
  20. * @param cat_name 分类名称
  21. * @param pid 父级分类id
  22. * @param status 状态 0正常 1禁用
  23. * 获取分类列表
  24. * @return \think\Response|\think\response\Json
  25. * @throws \think\db\exception\DataNotFoundException
  26. * @throws \think\db\exception\DbException
  27. * @throws \think\db\exception\ModelNotFoundException
  28. */
  29. public function list(){
  30. $param=$this->request->param(["pid"=>0,"cat_name"=>"","status"=>"","level"=>"","search"=>"","page"=>1,"size"=>10],"post","trim");
  31. $where=[["is_del","=",0]];
  32. if($param["pid"]!=="")$where[]=["pid","=",$param["pid"]];
  33. if($param["cat_name"]!=="")$where[]=["cat_name","like","%".$param["cat_name"]."%"];
  34. if($param["status"]!=="")$where[]=["status","=",$param["status"]];
  35. if($param["level"]!=="")$where[]=["level","=",$param["level"]];
  36. if($param["search"]!=="")$where[]=["search","like","%".$param["search"]."%"];
  37. $data=$this->model->where($where)->order("id","desc")->paginate(['page'=>$param['page'],'list_rows'=>$param['size']])
  38. ->each(function(&$item){
  39. $item["im"]=CatSpecs::with(["specs"])->where("cat_id",$item["id"])->field(["specs_id"])->select();
  40. $depart = \app\user\model\AccountItem::with(["ItemName"])->where(["account_id"=>$item["createrid"]])->findOrEmpty();
  41. $item["company_name"]=$depart->depart_name??"";
  42. $search_arr= Cat::GetCatListByChildId($item['id']);
  43. $item['item'] = array_column($search_arr,"id") ;
  44. });
  45. return success("获取成功",["list"=>$data->items(),"count"=>$data->total()]);
  46. }
  47. /**
  48. * @param cat_name 分类名称
  49. * @param pid 父级分类id
  50. * @param cat_desc 分类描述
  51. * @param fund_code 财务代码
  52. * @param specs_id 规格id
  53. * @param weight 权重
  54. * @param status 状态 0正常 1禁用
  55. * @return
  56. *
  57. */
  58. public function create(){
  59. $param=$this->request->param(['cat_name', 'pid', 'cat_desc' => '', 'fund_code' => '', 'is_del' => '0', 'specs_id'=>[], 'weight'
  60. => 0, 'status' => 0],"post","trim");
  61. $valid=Validate::rule([
  62. "cat_name|分类名称"=>"require|max:255|unique:app\admin\model\Cat,cat_name^is_del",
  63. "pid|父级分类"=>"require|integer|egt:0",
  64. "cat_desc|分类描述"=>"max:255",
  65. "fund_code|财务代码"=>"max:255",
  66. "specs_id|规格id"=>"require|array",
  67. "weight|权重"=>"integer",
  68. "status|状态"=>"integer|in:0,1",
  69. ]);
  70. if(!$valid->check($param))return error($valid->getError());
  71. if($param['pid']!=0){
  72. $parent = $this->model->where('id',$param['pid'])->findOrEmpty();
  73. if($parent->isEmpty())return error('父级分类不存在');
  74. }
  75. $this->model->startTrans();
  76. try{
  77. $create=[
  78. "cat_name"=>$param['cat_name'],
  79. "pid"=>$param["pid"],
  80. "level"=>0,
  81. "cat_desc"=>$param["cat_desc"],
  82. "fund_code"=>$param["fund_code"],
  83. "weight"=>$param["weight"],
  84. "status"=>$param["status"],
  85. 'creater' => $this->uname,
  86. 'createrid' =>$this->uid,
  87. ];
  88. $data=$this->model->create($create);
  89. if($data->isEmpty())throw new \Exception("添加失败");
  90. $spec=$data->specs()->saveAll(array_map(function($item)use($data){return ['specs_id'=>$item];},$param['specs_id']));
  91. if(!$spec)throw new \Exception("添加失败");
  92. $this->model->commit();
  93. }catch (\Exception $e){
  94. $this->model->rollback();
  95. return error($e->getMessage());
  96. }
  97. event("PlatCat",["type"=>"add",'info'=>'cat',"data"=>$data]);
  98. return success("添加成功");
  99. }
  100. /**
  101. * @param id 分类id
  102. * @param cat_name 分类名称
  103. * @param pid 父级分类id
  104. * @param cat_desc 分类描述
  105. * @param fund_code 财务代码
  106. * @param specs_id 规格id
  107. * @param weight 权重
  108. * @param status 状态 0正常 1禁用
  109. * @return
  110. */
  111. public function save(){
  112. $param=$this->request->param(['id','cat_name', 'pid', 'cat_desc' => '', 'fund_code' => '', 'is_del' => '0','specs_id'=>[], 'weight'
  113. => 0, 'status' => 0],"post","trim");
  114. $valid=Validate::rule([
  115. "id|分类id"=>"require|integer|egt:1",
  116. "cat_name|分类名称"=>"require|max:255|unique:app\admin\model\Cat,cat_name^is_del",
  117. "pid|父级分类"=>"require|integer|egt:0",
  118. "cat_desc|分类描述"=>"max:255",
  119. "fund_code|财务代码"=>"max:255",
  120. "specs_id|规格id"=>"require|array",
  121. "weight|权重"=>"integer",
  122. "status|状态"=>"integer|in:0,1",
  123. ]);
  124. if(!$valid->check($param))return error($valid->getError());
  125. if($param['pid']!=0){
  126. $parent = $this->model->where("id",$param["pid"])->findOrEmpty();
  127. if($parent->isEmpty())return error("父级分类不存在");
  128. }
  129. $this->model->startTrans();
  130. try{
  131. $data=$this->model->with(["specs"])->findOrEmpty($param["id"]);
  132. if($data->isEmpty())return error("分类不存在");
  133. $data->cat_name=$param["cat_name"];
  134. $data->pid=$param["pid"];
  135. $data->cat_desc=$param["cat_desc"];
  136. $data->fund_code=$param["fund_code"];
  137. $data->weight=$param["weight"];
  138. $data->status=$param["status"];
  139. $save=$data->save();
  140. if(!$save)throw new \Exception("修改失败");
  141. $add=array_diff($param["specs_id"],array_column($data->specs->toArray(),"specs_id"));
  142. $delte=CatSpecs::where([["cat_id","=",$data->id],["specs_id","not in",$param['specs_id']],['is_del','=',0]])->delete();
  143. if($delte===false)throw new \Exception("删除失败");
  144. if(!empty($add)){
  145. $catid= $data->id;
  146. $spec=$data->specs()->saveAll(array_map(function($item)use($catid){return ["specs_id"=>$item,"cat_id"=>$catid];},$add));
  147. if(!$spec)throw new \Exception("添加失败");
  148. }
  149. $this->model->commit();
  150. }catch (\Exception $e){
  151. $this->model->rollback();
  152. return error($e->getMessage());
  153. }
  154. event('PlatCat',['type'=>'add','info'=>'cat','data'=>$data]);
  155. return success("修改成功");
  156. }
  157. /**
  158. * @param id 分类id
  159. * @return
  160. */
  161. public function delete(){
  162. $param=$this->request->param(["id"=>0],"post","trim");
  163. $valid=Validate::rule([
  164. "id|分类id"=>"require|integer|egt:1",
  165. ]);
  166. if(!$valid->check($param))return error($valid->getError());
  167. $data=$this->model->with(["specs"])->findOrEmpty($param["id"]);
  168. if($data->isEmpty())return error("分类不存在");
  169. $data->is_del=1;
  170. if(!$data->save())return error("删除失败");
  171. event("PlatCat",["type"=>"delete",'info'=>'cat',"data"=>$data]);
  172. return success("删除成功");
  173. }
  174. /**
  175. * @param id 分类id
  176. * @param status 状态 0正常 1禁用
  177. * @return
  178. */
  179. public function status(){
  180. $param=$this->request->param(["id"=>0,"status"=>0],"post","trim");
  181. $valid=Validate::rule([
  182. "id|分类id"=>"require|integer|egt:1",
  183. "status|状态"=>"require|integer|in:0,1",
  184. ]);
  185. if(!$valid->check($param))return error($valid->getError());
  186. $data=$this->model->findOrEmpty($param["id"]);
  187. if($data->isEmpty())return error("分类不存在");
  188. if($data->status==$param["status"])return error("状态未改变");
  189. $catIds=[$param['id']];
  190. if($data->level==3){
  191. if($param['status']==1){
  192. $catInfo = Cat::GetCatListByChildId($param['id']);
  193. $catIds=array_map(function($v){
  194. return $v['status']==0?$v['id']:0;
  195. },$catInfo);
  196. }
  197. }else{
  198. if($param['status']==0){
  199. $catInfo = Cat::where(["pid"=>$param['id'],"status"=>1,"is_del"=>0])->findOrEmpty();
  200. if(!$catInfo->isEmpty())return error("该分类下有启用的子分类");
  201. }else return error('所在等级不能启用');
  202. }
  203. $update=$data->whereIn("id",$catIds)->update(["status"=>$param["status"]]);
  204. if(!$update)return error("修改失败");
  205. event("PlatCat",["type"=>"status",'info'=>'cat',"data"=>["id"=>$catIds,"staus"=>$param['status']]]);
  206. return success(Cat::$statusCn[$param['status']]."成功");
  207. }
  208. /** 获取分类列表
  209. * @param cat_name 分类名称
  210. * @param pid 父级分类id
  211. * @param status 状态
  212. * @return \think\Response|\think\response\Json|void
  213. */
  214. public function query(){
  215. $param = $this->request->only(['cat_name' => '', 'pid' => '', 'status' => '',], 'post', 'trim');
  216. $valid = Validate::rule([
  217. "cat_name|分类名称" => "max:255",
  218. "pid|父级分类" => "integer|egt:0",
  219. "status|状态" => "integer|in:0,1",
  220. ]);
  221. if (!$valid->check($param)) return error($valid->getError());
  222. try {
  223. $data = $this->model->with(["specs"])->where(function ($query) use ($param) {
  224. if ($param['cat_name']!=='') $query->where("cat_name", "like", "%{$param['cat_name']}%");
  225. if ($param['pid']!=='') $query->where("pid", $param['pid']);
  226. if ($param['status'] !== '') $query->where("status", $param['status']);
  227. })->order("pid,weight desc,id")->select();
  228. if (!$data->isEmpty()) {
  229. foreach ($data as &$item) {
  230. $item['child'] = Cat::GetCatListByPid($item['id']);
  231. }
  232. }
  233. }catch (\Exception $e) {
  234. return error($e->getMessage());
  235. }
  236. return success("查询成功", $data);
  237. }
  238. }