Tools/application/admin/controller/Column.php

<?php
namespace app\admin\controller;

use think\Request;
use app\admin\model\ColumnModel;

class Column extends Base
{
    

    public function lst()//栏目列表（自己做的）
    {   

        return view(); 
       
         
    }



    public function lst_data(Request $request){//栏目列表json数据动态表格显示（分页）
        $user = new ColumnModel();
        $id = request()->param('id');//接收请求数据id
        if(!empty($id)){//不为空执行搜索条件，为空则跳过判断条件直接显示列表页，
            $where = ['id'=>$id];
            //数据表获取总记录数           
            $count = $user->where($where)->count();
            //获取每页显示的条数
            $limit= $request->param('limit');
            //获取当前页码
            $page= $request->param('page');
            //limit的起始位置
            $start=($page-1)*$limit; 
            $list = $user
                    ->limit("$start,$limit")
                    ->where($where)
                    ->select();
            //返回数据
            return ["code"=>0,"msg"=>"成功","count"=>$count,"data"=>$list];
        }
        //数据表获取总记录数           
        $count = $user->count();
        //获取每页显示的条数
        $limit= $request->param('limit');
        //获取当前页码
        $page= $request->param('page');
        //limit的起始位置
        $start=($page-1)*$limit;
        $list = $user
                ->limit("$start,$limit")
                ->select();
        //返回数据
        return ["code"=>0,"msg"=>"成功","count"=>$count,"data"=>$list];

    }


    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();
        if(request()->isPost()){
            $id = input('id');
            $del=$user->where('id',$id)->delete();
            if($del){
                return 1;//删除成功             
            }else{
                return 2;//删除失败        
            }
        }
        return view();


    } 

    public function pdel(){//批量删除
        $user = new ColumnModel();
        if(request()->isPost()){

            $id = input('post.');//接收前台id
            $ids = implode(',',$id);//将id用逗号进行隔开
            $where = [
                'id'=>['in',$ids],
            ];
            $list = $user->where($where)->delete();
            if($list){
               return 1;//删除成功
              
            }else{
                return 2;//删除失败
                
            }
        }
        return view();

    }

    
        
 


        
}