model = new Cat(); } /** * @param pid=0,cat_name="",status="",page=1,size=10 * 获取分类列表 */ public function list(){ $param=$this->request->param(["pid"=>0,"cat_name"=>"","status"=>"","page"=>1,"size"=>10],"post","trim"); $where=[["is_del","=",0]]; if($param["pid"]!=="")$where[]=["pid","=",$param["pid"]]; if($param["cat_name"]!=="")$where[]=["cat_name","like","%".$param["cat_name"]."%"]; if($param["status"]!=="")$where[]=["status","=",$param["status"]]; $data=$this->model->where($where)->order("id","desc")->paginate(['page'=>$param['page'],'list_rows'=>$param['size']]) ->each(function($item){ return $item["im"]=CatSpecs::with(["specs"])->where("cat_id",$item["id"])->field(["specs_id"])->select(); }); return success("获取成功",$data); } /** * @param cat_name 分类名称 * @param pid 父级分类id * @param cat_desc 分类描述 * @param fund_code 财务代码 * @param specs_id 规格id * @param weight 权重 * @param status 状态 0正常 1禁用 * @return * */ public function create(){ $param=$this->request->param(['cat_name', 'pid', 'cat_desc' => '', 'fund_code' => '', 'specs_id'=>[], 'weight' => 0, 'status' => 0],"post","trim"); $valid=Validate::rule([ "cat_name|分类名称"=>"require|max:255|unique:app\admin\model\Cat,cat_name^is_del", "pid|父级分类"=>"require|integer|egt:0", "cat_desc|分类描述"=>"max:255", "fund_code|财务代码"=>"max:255", "specs_id|规格id"=>"require|array", "weight|权重"=>"integer", "status|状态"=>"integer|in:0,1", ]); if(!$valid->check($param))return error($valid->getError()); if($param['pid']!=0){ $parent = $this->model->where('id',$param['pid'])->findOrEmpty(); if($parent->isEmpty())return error('父级分类不存在'); } if($parent->isEmpty())return error("父级分类不存在"); $this->model->startTrans(); try{ $create=[ "cat_name"=>$param['cat_name'], "pid"=>$param["pid"], "cat_desc"=>$param["cat_desc"], "fund_code"=>$param["fund_code"], "weight"=>$param["weight"], "status"=>$param["status"], 'creater' => $this->uname, 'createrid' =>$this->uid, ]; $data=$this->model->create($create); if($data->isEmpty())return error("添加失败"); $spec=$data->specs()->saveAll($param["specs_id"]); if($spec->isEmpty())return error("添加失败"); $this->model->commit(); }catch (\Exception $e){ $this->model->rollback(); return error($e->getMessage()); } event("PlatCat",["type"=>"add","data"=>$data]); return success("添加成功"); } /** * @param id 分类id * @param cat_name 分类名称 * @param pid 父级分类id * @param cat_desc 分类描述 * @param fund_code 财务代码 * @param specs_id 规格id * @param weight 权重 * @param status 状态 0正常 1禁用 * @return */ public function save(){ $param=$this->request->param(['id','cat_name', 'pid', 'cat_desc' => '', 'fund_code' => '', 'specs_id'=>[], 'weight' => 0, 'status' => 0],"post","trim"); $valid=Validate::rule([ "id|分类id"=>"require|integer|egt:1", "cat_name|分类名称"=>"require|max:255|unique:app\admin\model\Cat,cat_name^is_del", "pid|父级分类"=>"require|integer|egt:0", "cat_desc|分类描述"=>"max:255", "fund_code|财务代码"=>"max:255", "specs_id|规格id"=>"require|array", "weight|权重"=>"integer", "status|状态"=>"integer|in:0,1", ]); if(!$valid->check($param))return error($valid->getError()); if($param['pid']!=0){ $parent = $this->model->where("id",$param["pid"])->findOrEmpty(); if($parent->isEmpty())return error("父级分类不存在"); } $this->model->startTrans(); try{ $data=$this->model->with(["specs"])->findOrEmpty($param["id"]); if($data->isEmpty())return error("分类不存在"); $data->cat_name=$param["cat_name"]; $data->pid=$param["pid"]; $data->cat_desc=$param["cat_desc"]; $data->fund_code=$param["fund_code"]; $data->weight=$param["weight"]; $data->status=$param["status"]; $save=$data->save(); if(!$save)return error("修改失败"); $add=array_diff($param["specs_id"],$data->specs->column("specs_id")); $delte=$data->specs()->whereNotIn("specs_id",$param["specs_id"])->save(["is_del"=>1]); if($delte===false)return error("删除失败"); $spec=$data->specs()->saveAll($add); if($spec->isEmpty())return error("添加失败"); $this->model->commit(); }catch (\Exception $e){ $this->model->rollback(); return error($e->getMessage()); } return success("修改成功"); } /** * @param id 分类id * @return */ public function delete(){ $param=$this->request->param(["id"=>0],"post","trim"); $valid=Validate::rule([ "id|分类id"=>"require|integer|egt:1", ]); if(!$valid->check($param))return error($valid->getError()); $data=$this->model->with(["specs"])->findOrEmpty($param["id"]); if($data->isEmpty())return error("分类不存在"); $data->is_del=1; if(!$data->save())return error("删除失败"); event("PlatCat",["type"=>"delete","data"=>$data]); return success("删除成功"); } public function status(){ $param=$this->request->param(["id"=>0,"status"=>0],"post","trim"); $valid=Validate::rule([ "id|分类id"=>"require|integer|egt:1", "status|状态"=>"require|integer|in:0,1", ]); if(!$valid->check($param))return error($valid->getError()); $data=$this->model->findOrEmpty($param["id"]); if($data->isEmpty())return error("分类不存在"); if($data->status==$param["status"])return error("状态未改变"); if($param["status"]==1){ $parent = $this->model->where("id",$data->pid)->findOrEmpty(); if($parent->isEmpty())return error("父级分类不存在"); if($parent->status!=1)return error("父级分类未启用"); } $data->status=$param['status']; if(!$data->save())return error(Cat::$statusCn[$param['status']]. "失败"); event("PlatCat",["type"=>"status","data"=>$data]); return success(Cat::$statusCn[$param['status']]."成功"); } }