jinai-talents/app/businessmanage/controller/AdminBusinessJoinManageController.php

<?php

namespace app\businessmanage\controller;

use app\business\model\BusinessJoinModel;
use cmf\controller\AdminBaseController;

class AdminBusinessJoinManageController extends AdminBaseController
{
    /**
     * 活动列表
     */
    public function index()
    {
        $param = $this->request->param();

        //搜索条件
        $where = [];
        if (!empty($param['start_time'])) {
            $where[] = ['bj.create_time', '>=', strtotime($param['start_time'])];
        }
        if (!empty($param['end_time'])) {
            $where[] = ['bj.create_time', '<=', strtotime($param['end_time'])];
        }
        if (!empty($param['keyword'])) {
            $where[] = ['u.user_name', 'like', "%{$param['keyword']}%"];
        }
        if (!empty($param['business_id'])) {
            $where[] = ['bj.business_id', '=', $param['business_id']];
        }
        if (!empty($param['status'])) {
            $where[] = ['bj.status', '=', $param['status']];
        }
        $list = BusinessJoinModel::alias('bj')
            ->leftJoin('business b', 'bj.business_id = b.id')
            ->leftJoin('user u', 'bj.user_id = u.id')
            ->field('bj.*,b.title,u.user_name,u.mobile')
            ->where($where)
            ->order('create_time', 'DESC')
            ->paginate(10, false, ['query' => $param]);

        $this->assign('start_time', isset($param['start_time']) ? $param['start_time'] : '');
        $this->assign('end_time', isset($param['end_time']) ? $param['end_time'] : '');
        $this->assign('keyword', isset($param['keyword']) ? $param['keyword'] : '');
        $this->assign('business_id', isset($param['business_id']) ? $param['business_id'] : '');
        $this->assign('status', isset($param['status']) ? $param['status'] : '');
        $this->assign('list', $list->items());
        $this->assign('page', $list->render());

        return $this->fetch();
    }

    public function export()
    {
        $param = $this->request->param();

        //搜索条件
        $sessionAdminId = session('ADMIN_ID');
        $where          = [['bj.business_id', '=', $sessionAdminId]];
        if (!empty($param['ids'])) {
            $where[] = ['bj.id', 'in', $param['ids']];
        } else {
            if (!empty($param['start_time'])) {
                $where[] = ['bj.create_time', '>=', strtotime($param['start_time'])];
            }
            if (!empty($param['end_time'])) {
                $where[] = ['bj.create_time', '<=', strtotime($param['end_time'])];
            }
            if (!empty($param['keyword'])) {
                $where[] = ['u.user_name', 'like', "%{$param['keyword']}%"];
            }
            if (!empty($param['business_id'])) {
                $where[] = ['bj.business_id', '=', $param['business_id']];
            }
            if (!empty($param['status'])) {
                $where[] = ['bj.status', '=', $param['status']];
            }
        }

        //获取数据
        $activity = BusinessJoinModel::alias('bj')
            ->leftJoin('business b', 'bj.business_id = b.id')
            ->leftJoin('user u', 'bj.user_id = u.id')
            ->field('bj.*,b.title,u.user_name,u.mobile')
            ->where($where)
            ->order('create_time', 'DESC')
            ->select();

        //表头
        $header = [
            'id'          => 'id',
            'business_id' => '商家id',
            'title'       => '商家',
            'user_id'     => '用户id',
            'user_name'   => '用户姓名',
            'mobile'      => '用户电话',
            'comment'     => '用户备注',
            'status'      => '状态',
            'create_time' => '报名时间',
        ];

        //表格内容
        foreach ($activity as $v) {
            $v['create_time'] = date('Y-m-d H:i', $v['create_time']);
            $v['status']      = $v['status'] == 1 ? '已参加' : '不允许参加';
        }
        export_excel_data($header, $activity, '商家活动参与列表', ['mobile', 'create_time']);
    }
}