project/app/admin/controller/Cate.php

<?php
/**
 * Created by PhpStorm.
 * User: wugg
 * Date: 2024/6/28
 * Time: 16:03
 * description:分类控制器
 */

namespace app\admin\controller;


use app\admin\model\CatSpecs;
use app\admin\model\Cat;
use think\App;
use think\facade\Validate;
class Cate extends Base{
    public function __construct(App $app) {
        parent::__construct($app);
        $this->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']]."成功");
    }
}