分类模块练习

<?php
/**
 * Created by PhpStorm.
 * User: Admin
 * Date: 2019/4/6
 * Time: 21:42
 */

namespace app\admin\controller;
use app\admin\controller\Common;
use think\Db;
use think\facade\Request;
use think\facade\Session;

class Sort extends Common
{
     public function index()
     {
         $type['title'] = Db::table('sort')->order('id','desc')->paginate(8);
         return $this->fetch('',$type);
     }
     public function add()
     {
         return $this->fetch();
     }
     public function edit()
     {
         $id = Request::param('id');
         $data['type']=Db::table('sort')->where('id',$id)->find();
         return $this->fetch('',$data);
     }
     public function DoAdd()
     {
         $data=Request::param();
         $data['time']=time();
         $data['username']=Session::get('username');
         if(Db::table('sort')->insert($data)){
             return ['res'=>1,'msg'=>'添加成功'];
         }else{
             return ['res'=>0,'mag'=>'添加失败'];
         }
     }
     public function DoEdit()
     {
         $data=Request::param();
         if (Db::table('sort')->data([
             'title'=>$data['title'],
             'username'=>Session::get('username'),
             'time'=>time()
         ])->where('id',$data['id'])->update()){
             return ['res'=>1,'msg'=>'修改成功'];
         }else{
             return ['res'=>0,'mag'=>'修改失败'];
         }
     }
     public function del()
     {
         $id=Request::param('id');
         if(Db::table('sort')->where('id',$id)->delete()){
             return ['res'=>1,'msg'=>'删除成功'];
         }else{
             return ['res'=>0,'mag'=>'删除失败'];
         }
     }

}