gaoyixia/application/operate/controller/Press.php

<?php
namespace app\operate\controller;
use app\common\model\User;
use library\Controller;
use think\Db;
/**
 * 新闻
 * Class Press
 * @package app\operate\controller
 */
class Press extends Controller
{
    protected $table = 'Press';

    /**
     * 列表
     * @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('title')) $where[] = ['f.title','like','%'.$title.'%'];
        $query = $this->_query($this->table)->alias('f')
            ->field('f.*')
            ->where($where)
            ->order('sort desc,f.id desc')->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
     * @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 reply()
    {
        $this->title = '回复列表';
        $where = [];
        $where[] = ['r.is_deleted','=',0];
        $where[] = ['r.forum_id','=',input('id')];
        if($title = input('content')) $where[] = ['r.content','like','%'.$title.'%'];
        if($name = input('name')) $where[] = ['u.name','like','%'.$name.'%'];
        if($phone = input('phone')) $where[] = ['u.phone','=',$phone];
        $list = $this->_query('forum_reply')
            ->alias('r')
            ->field('r.*,u.name,u.phone,u.headimg')
            ->leftJoin('store_member u','u.id = r.user_id')
            ->where($where)
            ->order('r.id desc')->page();
        $this->assign('list',$list);
        $this->fetch('');
    }


    protected function _form_filter(&$data){
        if($this->request->isPost())
        {
            if(empty($data['title']))$this->error('请输入标题');
            if(empty($data['images']))$this->error('请上传封面');
            if(!empty($data['phone'])) {
                $user_id = User::where('phone|email',$data['phone'])->value('id');
                if(!$user_id) $this->error('账号未注册');
                $data['user_id'] =  $user_id;
            }else{
                $data['user_id'] = '';
            }
        }
    }

    public function del_reply()
    {
        Db::name('forum_reply')->where('id',input('id'))->update(['is_deleted'=>1]);
        $this->success('删除成功');
    }

    protected function _form_result(&$data)
    {
        $this->success('操作成功', 'javascript:history.back()');
    }

}