table)->field('id,pid,name,image,createtime')->where('company_id',$this->auth->company_id)->order('id asc')->select(); /*$tree = Tree::instance()->init($list); $tree->icon = ['','','']; $tree->nbsp = ''; $tree = $tree->getTreeList($tree->getTreeArray(0),'name'); $this->success(1,$tree);*/ $list = list_domain_image($list,['image']); $this->success(1,$list); } public function add(){ $pid = input('pid',0); //找到最顶级id $tid = 0; if($pid != 0){ $tid = Db::name($this->table)->where('id',$pid)->value('tid');//父级的tid if($tid == 0){ //父级就是顶级时 $tid = $pid; //顶级=父级 } } $data = [ 'company_id' => $this->auth->company_id, 'pid' => $pid, 'tid' => $tid, 'name' => input('name',''), 'image' => input('image',''), 'content' => input('content','','htmlspecialchars_decode'), 'ismenu' => input('ismenu',1), 'file' => input('file',''), 'createtime' => time(), 'updatetime' => time(), ]; Db::name($this->table)->insertGetId($data); $this->success(); } public function info(){ $id = input('id',0); $info = Db::name($this->table)->where('id',$id)->where('company_id',$this->auth->company_id)->find(); $info = info_domain_image($info,['file','image']); $this->success(1,$info); } public function edit(){ $id = input('id',0); $info = Db::name($this->table)->where('id',$id)->where('company_id',$this->auth->company_id)->find(); if(empty($info)){ $this->error('没找到该信息,请刷新重试'); } $pid = input('pid',0); //找到最顶级id $tid = 0; if($pid != 0){ $tid = Db::name($this->table)->where('id',$pid)->value('tid');//父级的tid if($tid == 0){ //父级就是顶级时 $tid = $pid; //顶级=父级 } } $data = [ 'pid' => $pid, 'tid' => $tid, 'name' => input('name',''), 'image' => input('image',''), 'content' => input('content','','htmlspecialchars_decode'), 'ismenu' => input('ismenu',1), 'file' => input('file',''), 'updatetime' => time(), ]; Db::name($this->table)->where('id',$id)->update($data); $this->success(); } public function del(){ $ids = input('ids',''); $ids = explode(',',$ids); if (empty($ids)) { $this->error(); } Db::name($this->table)->where('id','IN',$ids)->where('company_id',$this->auth->company_id)->delete(); $this->success(); } }