hemall.terabimsoft.com.cn/app/backend/modules/balance/controllers/MemberExportController.php

<?php
/****************************************************************
 * Author:  king -- LiBaoJia
 * Date:    1/8/21 9:40 AM
 * Email:   livsyitian@163.com
 * QQ:      995265288
 * IDE:     PhpStorm
 * User:    芸众商城 www.yunzshop.com
 ****************************************************************/


namespace app\backend\modules\balance\controllers;


use app\common\components\BaseController;
use app\common\models\Member;
use app\common\services\ExportService;

class MemberExportController extends BaseController
{
    public function index()
    {
        $exportService = new ExportService($this->exportBuilder(), $this->exportPage());

        $exportData[0] = $this->exportTitle();

        foreach ($exportService->builder_model as $key => $item) {
            $exportData[$key + 1] = [
                date('Y-m-d H:i:s', $item->createtime),
                $item->uid,
                $item->nickname,
                $item->realname,
                $item->mobile,
                $item->credit2,
            ];
        }
        $exportService->export($this->fileName(), $exportData, \Request::query('route'));
    }

    /**
     * 导出数据标题
     *
     * @return array
     */
    private function exportTitle()
    {
        return [
            '时间',
            '会员ID',
            '昵称',
            '姓名',
            '手机号',
            '余额',
        ];
    }

    private function exportBuilder()
    {
        $recordsModels = Member::uniacid();

        if ($search = $this->searchParams()) {
            $recordsModels = $recordsModels->search($search);
        }
        return $recordsModels->orderBy('uid', 'desc')->withoutDeleted();
    }

    /**
     * @return array
     */
    public function searchParams()
    {
        return request()->search ?: [];
    }

    /**
     * 导出页面页面值
     *
     * @return int
     */
    private function exportPage()
    {
        return request()->export_page ?: 1;
    }

    /**
     * 导出文件名称
     *
     * @return string
     */
    private function fileName()
    {
        return date('Y-m-d-h-i-s', time()) . '会员余额导出';
    }
}