order('sort desc')->paginate(10); $this->assign('list',$list); return view(); } public function add(){//添加 if(request()->isPost()){ $user = new ColumnModel(); $data = input('post.'); $Column = $user->where('catename',$data['catename'])->find(); if(empty($Column)){ $user->save($data); return 1; }else{ return 2; } } return view(); } public function edit(){//修改 $user = new ColumnModel(); $id = input('id'); $list = $user->where('id',$id)->find(); if(request()->isPost()){ $data = input('post.'); if($list['catename']!=$data['catename']){ $user->update($data); return 1; }else{ return 2; } } $this->assign([ 'list'=>$list, ]); return view(); } public function del(){//删除 $user = new ColumnModel(); $id = input('id'); $del=$user->where('id',$id)->delete(); if($del){ return ['data'=>200,'msg'=>'删除成功']; }else{ return ['data'=>0,'msg'=>'删除失败']; } return view(); } //更新排序 public function sort(){ if(request()->isPOST()){ $data=input(); //获取ajax提交所有数据 $table=db('column'); //要更新的表 $cate=new Catetree; //实例化拓展类 使用排序方法 $cate->cateSort($data['sort'],$table); return 1; } } }