gaoyixia/application/operate/controller/DemandComment.php

<?php
namespace app\operate\controller;
use library\Controller;
/**
 * 需求评论
 * Class DemandComment
 * @package app\operate\controller
 */
class DemandComment extends Controller
{
    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'DemandComment';
    /**
     * 列表
     * @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 = '列表';
        $this->first_id = input('first_id');
        $sel_where = [];
        $sel_where[] = ['c.is_deleted','in','0,1'];
        $sel_where[] = ['c.first_id','=',$this->first_id];
        if($content = $this->request->get('content'))$sel_where[] = ['c.content','like','%'.$content.'%'];
        if($name = $this->request->get('name'))$sel_where[] = ['u.name','like','%'.$name.'%'];
        $query = $this->_query($this->table)->alias('c')
            ->field('c.*,u.name,u.headimg')
            ->leftJoin("store_member u",'u.id = c.user_id')
            ->where($sel_where)->order('is_top desc,id desc')->page();
    }

    /**
     * 数据列表处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _index_page_filter(&$data)
    {


    }

    // 回复
    public function reply()
    {
        $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 del()
    {
        $this->_save($this->table, ['is_deleted' => 2]);
    }

    /**
     * 删除
     * @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 remove()
    {
        $this->_save($this->table, ['is_deleted' => 2]);
    }

    /**
     * 表单数据处理
     * @auth true
     * @menu true
     * @param array $data
     */
    protected function _form_filter(&$data)
    {
        if($this->request->isGet()) {
            $this->source_id = $data['source_id'] ? $data['source_id'] : $data['id'];
        }
    }

    /**
     * 置顶设置
     * @auth true
     * @menu true
     * @param array $data
     */
    public function stick()
    {
        $this->_save($this->table, ['is_top' => input('is_top')]);
    }


}