gaoyixia/application/operate/controller/ActivityQrcode.php

<?php
namespace app\operate\controller;
use app\common\model\User;
use library\Controller;
use think\Db;
/**
 * 活动推荐码
 * Class ActivityQrcode
 * @package app\operate\controller
 */
class ActivityQrcode extends Controller
{
    protected $table = 'ActivityQrcode';

    /**
     * 列表
     * @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 = [];
        $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;
        }

    }

}