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($this->post['token']) ? trim($this->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']):"";
        if($pid===""){
            return error_show(1002,"父级id不能为空");
        }
        $spid = Db::name('company_item')->where(['pid'=>0,'is_del'=>0])->find();
        $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";
        Db::startTrans();
        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"),

            ];

            $t= Db::name("company_item")->insert($data,true);
            if($t>0){
                $depart_link=$spid['depart_link']."{$t}-";
                $level =explode('-',$depart_link);
                $level = array_filter($level);
                $level= count($level);
                $i=['depart_link'=>$depart_link,'level'=>$level];
                $o=Db::name('company_item')->where(['id'=>$t])->update($i);
                if($o){
                   Db::commit();
                   return error_show(0,"添加成功");
                }
            }
            Db::rollback();

        }catch (\Exception $e){
            Db::rollback();
            return error_show(1003,$e->getMessage());
        }
    }
    public function refresh(){
        $token = isset($this->post['token']) ? trim($this->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,"部门信息不存在");
      }
        $pid = isset($this->post['pid']) && $this->post['pid'] !==""? trim($this->post['pid']):"";
      if($pid==""){
          return error_show(1002,"父级id不能为空");
      }
      $spid = Db::name('company_item')->where(['pid'=>0,'is_del'=>0])->find();
      if(empty($spid)){
          return error_show(1004,"父级id不能为空");
      }
      $weight = isset($this->post['weight']) && $this->post['weight'] !==""? trim($this->post['weight']):"1";
      $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,"部门名称已存在");
        }
        $depart_link=$spid['depart_link']."{$id}-";
        $itemlevel =explode('-',$depart_link);
       $itemlevel = array_filter($itemlevel);
        $itemlevel= count($itemlevel);

        $item=[
        "id"=>$id,
        "name"=>$itemname,
        "updatetime"=>date("Y-m-d H:i:s"),
            "weight"=>$weight,"pid"=>$pid,
            'depart_link'=>$depart_link,
            'level'=>$itemlevel
        ];
      $re = Db::name("company_item")->save($item);
      return $re ? app_show(0,"信息更新成功"): error_show(1003,"信息更新失败");
    }
    public function query(){
        $token = isset($this->post['token']) ? trim($this->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($this->post['token']) ? trim($this->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,"删除失败");
    }
}