<?php
namespace app\admin\controller;
use think\Request;
use catetree\Catetree;
use app\admin\model\GoodModel;
use app\admin\model\TagsModel;
class Good extends Base
{
     
    public function lst(){//工具列表
        $user = new GoodModel();
        $list = $user
                ->alias('a')           
                ->field('a.*,b.catename')
                ->join('column b','a.column_id=b.id')
                ->order('sort desc')
                ->paginate(10);
        $this->assign('list',$list);
        return view();

    }

      public function add(){      
        if(request()->isPost()){
            $user = new GoodModel();
            $data = input('post.'); 
            if(empty($data['tags_id'])){//解决复选框值为空的时候
                $data['tags_id']='';//将rules字段的值设置为空
                $data['create_time'] = time();
                if($user->save($data)){
                    return 1;
                }else{
                    return 2;
                }
            }
            $data['tags_id']=implode(',',$data['tags_id']);
            $data['create_time'] = time();
            if($user->save($data)){
                return 1;
            }else{
                return 2;
            }
        }
        $tags = db('tags')->select();
        $column = db('column')->select();
        $this->assign([
            'column'=>$column,
            'tags'=> $tags,//标签列表
        ]);
        return view();

    }

    public function edit(){
        $user = new GoodModel();
        $id = input('id');
        $db = $user->where('id',$id)->find();
        if(request()->isPost()){
            $data = input('post.');  
            if(empty($data['tags_id'])){//解决复选框值为空的时候
                $data['tags_id']='';//将rules字段的值设置为空
                $data['create_time'] = time();
                if($user->where('id',$id)->update($data)){
                    return 1;
                }else{
                    return 2;
                }
            }
            $data['tags_id']=implode(',',$data['tags_id']);
            if($user->where('id',$id)->update($data)){  
                return 1;
            }else{
                return 2;
            }
        }

        $column = db('column')->select();
        $tags = db('tags')->select();
        $this->assign([
            'column'=>$column,//导航栏数据
            'db'=>$db,//工具数据
            'tags'=>$tags,//标签数据
        ]);
        return view();
    }


    public function del(){//删除
        $user = new GoodModel();
        $id = input('id');
        $del=$user->where('id',$id)->delete();
        if($del){
            return ['data'=>200,'msg'=>'删除成功'];
        }else{
            return ['data'=>0,'msg'=>'删除失败'];
        }

    } 


    public function pdel(){//批量删除
        $user = new GoodModel();
        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();

    }


    //更新排序
    public function sort(){
        if(request()->isPOST()){
            $data=input(); //获取ajax提交所有数据
            $table=db('good'); //要更新的表
            $cate=new Catetree;  //实例化拓展类  使用排序方法
            $cate->cateSort($data['sort'],$table);
            return 1;
        }

    }
       

}