jinai-talents/app/activity/controller/AdminActivitySiteJoinController.php

<?php

namespace app\activity\controller;

use api\activity\model\ActivitySiteJoinModel;
use cmf\controller\AdminBaseController;

class AdminActivitySiteJoinController extends AdminBaseController
{
    /**
     * 列表
     */
    public function index()
    {
        $this->checkSite();

        //搜索条件
        $sessionAdminId = session('ADMIN_ID');
        $where          = [['aj.site_id', '=', $sessionAdminId]];
        $list           = ActivitySiteJoinModel::alias('aj')
            ->leftJoin('user u', 'aj.user_id = u.id')
            ->field('aj.*,u.user_name,u.mobile')
            ->where($where)
            ->order('create_time', 'DESC')
            ->paginate(10);

        $this->assign('list', $list->items());
        $this->assign('page', $list->render());

        return $this->fetch();
    }

    public function export()
    {
        //搜索条件
        $sessionAdminId = session('ADMIN_ID');
        $where          = [['aj.site_id', '=', $sessionAdminId]];
        $list           = ActivitySiteJoinModel::alias('aj')
            ->leftJoin('user u', 'aj.user_id = u.id')
            ->field('aj.*,u.user_name,u.mobile')
            ->where($where)
            ->order('create_time', 'DESC')
            ->select();

        //表头
        $header = [
            'user_id'     => '用户id',
            'user_name'   => '用户姓名',
            'mobile'      => '用户电话',
            'create_time' => '首次报名时间',
        ];

        //表格内容
        foreach ($list as $v) {
            $v['create_time'] = date('Y-m-d H:i', $v['create_time']);
        }

        export_excel_data($header, $list, '往届报名列表', ['mobile', 'create_time']);
    }
}