<?php
namespace app\Nutrition\controller;
use library\Controller;
use library\service\MenuService;
use library\tools\Data;
use think\Db;
use think\db\Where;

/**
 * 分类
 * Class VideoClassify
 * @package app\nutrition\controller
 */
class VideoClassify extends Controller
{

    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'SeriesVideoCate';

    /**
     * 分类列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '分类列表';
        $query = $this->_query($this->table)->where('is_deleted',0)->like('title')
            ->where('pid',0)
            ->order('sort desc,id asc')->page();
    }


    /**
     * 添加分类
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function add()
    {
        $this->title = '添加分类';
        $this->_form($this->table, 'form');
    }


    /**
     * 编辑分类
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edit()
    {
        $this->title = '编辑分类';
        $this->_form($this->table, 'form');
    }

    /**
     * 表单数据处理
     * @param array $vo
     * @throws \ReflectionException
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _form_filter(&$data)
    {
        if($this->request->action() == 'edit') unset($data['pid']);
    }

    /**
     * 启用
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function resume()
    {
        $this->_save($this->table, ['status' => '1']);
    }

    /**
     * 禁用
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function forbid()
    {
        $this->_save($this->table, ['status' => '0']);
    }

    /**
     * 删除
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function remove()
    {
        $this->_save($this->table, ['is_deleted' => 1]);
    }


    /**
     * 二级分类列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function second(){
        $this->title ='二级分类';
        $pid = input('pid');
        $list = $this->_query('SeriesVideoCate')
            ->where(['is_deleted'=>0,'pid'=>$pid])
            ->like('title')
            ->order('id desc')->page();
        $this->assign('list',$list);
        $this->fetch('');
    }


}