title = '列表'; $where = []; $act_id = input('act_id'); $where[] = ['f.is_deleted','=',0]; $where[] = ['f.act_id','=',$act_id]; if($title = input('phone')) $where[] = ['f.phone','like','%'.$title.'%']; $query = $this->_query($this->table)->alias('f') ->field('f.*,t.title act_title') ->leftJoin('activity t','t.id=f.act_id') ->where($where) ->order('f.id asc')->page(); } public function _index_page_filter(&$data) { foreach ($data as &$v) { $v['detail_url'] = 'https://'.$_SERVER['HTTP_HOST']."/dist/#/activity-detail?id=".$v['act_id'].'&tg='.$v['tg_param']; } } /** * 添加 * @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']); } protected function _form_filter(&$data) { if($this->request->isPost()) { $phone = input('phone'); $user_id = User::where('phone|email',$phone)->value('id'); if(!$user_id)$this->error('用户不存在'); $data['user_id'] = $user_id; $data['qrcode'] = create_qrcode($data['act_id'],$user_id,'activity'); $data['tg_param'] = $data['act_id'].'_'.$user_id; } } }