phpstock/app/Admin/controller/Newfill.php

<?php

namespace app\Admin\controller;

use app\BaseController;
use think\App;
use think\facade\Db;

class Newfill extends BaseController
{
    public $post = "";



    public function __construct(App $app)
    {
        parent::__construct($app);
        $this->post = $this->request->post();
    }
    public function list()
    {
        $page = isset($this->post['page']) && $this->post['page'] != "" ? intval($this->post['page']) : 1;
        $size = isset($this->post['size']) && $this->post['size'] != "" ? intval($this->post['size']) : 10;
        $condition = ['pid'=>0];
        $count = Db::name("company_item")->where($condition)->count();
        $page >= ceil($count / $size) ? $page = ceil($count / $size) : " ";
        $list = Db::name("company_item")->where($condition)->page($page, $size)->select();
//        $this->carray($this->treelist);
//        var_dump($this->carray($this->treelist));
        $data=[];
        $act=[];
        foreach ($list as $value){
           // crea($value);
       // var_dump($value);
        $data[]=  crea($value);;
        }
       // array_walk($data,function (&$value){
            //$value['child']= array_values($value['child']);
       // });
        return app_show(0,"获取成功",array_values($data));
    }
    public function add(){
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }

        $item_name=isset($this->post['name']) && $this->post['name'] !==""? trim($this->post['name']) :"";
        if($item_name==""){
            return error_show(0,"部门名称不能为空");
        }
        $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$item_name])->find();
        if(!empty($repeat_name)){
            return error_show(1004,"部门名称已存在");
        }
        $pid = isset($this->post['pid']) && $this->post['pid'] !==""? trim($this->post['pid']):"0";
        $level = isset($this->post['level']) && $this->post['level'] !==""? trim($this->post['level']):"1";
        $weight = isset($this->post['weight']) && $this->post['weight'] !==""? trim($this->post['weight']):"1";
        try{

            $data =[
                "name"=>$item_name, "pid"=>$pid, "level"=>$level, "weight"=>$weight,
                "is_del"=>0,
                "addtime"=>date("Y-m-d H:i:s"),
                "updatetime"=>date("Y-m-d H:i:s")
            ];

                Db::name("company_item")->insert($data);
                return error_show(0,"添加成功");

        }catch (\Exception $e){

            return error_show(1003,$e->getMessage());
        }
    }
    public function refresh(){
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
      $id = isset($this->post['id'])?intval($this->post['id']):"";
      $items = Db::name("company_item")->where("id","=",$id)->find();
      if($items==false){
          return error_show(1003,"部门信息不存在");
      }
      $itemname=isset($this->post['name'])? trim($this->post['name']):"";
      if($itemname==""){
          return error_show(1002,"部门名称不能为空");
      }
        $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$itemname])->where('id','<>',$id)->find();
      //echo Db::name("company_item")->getLastSql();
        if(!empty($repeat_name)){
            return error_show(1004,"部门名称已存在");
        }
      $itemlevel = isset($this->post['level'])? intval($this->post['level']):"";
        if($itemlevel==""){
            return error_show(1002,"部门层级不能为空");
        }
        $depart_link = isset($this->post['depart_link']) ? trim($this->post['depart_link']):"";
        if($depart_link==""){
            return error_show(1002,"快速查询不能为空");
        }
        $item=[
        "id"=>$id,
        "name"=>$itemname,
        "level"=>$itemlevel,
        "depart_link"=>$depart_link, "updatetime"=>date("Y-m-d H:i:s")

        ];
      $re = Db::name("company_item")->save($item);
      return $re ? app_show(0,"信息更新成功"): error_show(1003,"信息更新失败");
    }
    public function query(){
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }

        $dati = Db::name("company_item")->where(['pid'=>0,'is_del'=>0])->order("weight desc")->select();
        $k=[];
        foreach ($dati as $key=>$value){
            $temp=[];
            $temp= Db::name("company_item")->where(['pid'=>$value['id'],'is_del'=>0])->order("weight desc")->select();
            $value['child'] =$temp;
            $k[]=$value;
        }
        return app_show(0,"获取成功",$k);
    }

    public function itemdel(){
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $id = isset($this->post['id']) ? intval($this->post['id']):"";
        $items = Db::name("company_item")->where(['is_del'=>0,'id'=>$id])->find();
        if($items==false){
            return error_show(1003,"部门信息不存在");
        }
        $items['is_del']=1;
        $items['updatetime']=date("Y-m-d H:i:s");
        $result = Db::name("company_item")->save($items);
        return $result ? app_show(0,"删除成功"): error_show(1003,"删除失败");
    }

}