gaoyixia/application/operate/controller/Contact.php

<?php
namespace app\operate\controller;
use library\Controller;
use think\Db;
/**
 * 活动
 * Class Activity
 * @package app\operate\controller
 */
class Contact extends Controller
{
    protected $table = 'Contact';

    /**
     * 列表
     * @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 = '列表';
        $where = [];
        $where[] = ['f.is_deleted','=',0];
        if($title = input('name')) $where[] = ['f.name','like','%'.$title.'%'];
        $query = $this->_query($this->table)->alias('f')
            ->field('f.*')
            ->where($where)
            ->order('sort desc,f.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');
    }

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

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


}