fastadmin_tailored/application/admin/controller/commission/Reward.php

<?php

namespace app\admin\controller\commission;

use app\common\controller\Backend;
use app\common\model\commission\Reward as RewardModel;

class Reward extends Backend
{
    protected $model = null;
    
    /**
     * 快速搜索时执行查找的字段
     */
    protected $searchFields = 'id,commission,agent_level';
    
    /**
     * 是否是关联查询
     */
    protected $relationSearch = true;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new RewardModel();
    }
    
    /**
     * 查看
     */
    public function index()
    {
        if (!$this->request->isAjax()) {
            return $this->view->fetch();
        }

        //如果发送的来源是 Selectpage，则转发到 Selectpage
        if ($this->request->request('keyField')) {
            return $this->selectpage();
        }
        
        [$where, $sort, $order, $offset, $limit] = $this->buildparams();
        $list = $this->model
            ->with(['buyer', 'agent', 'order', 'order_item'])
            ->where($where)
            ->order($sort, $order)
            ->paginate($limit);
        
        $result = ['total' => $list->total(), 'rows' => $list->items()];
        return json($result);
    }



    public function export()
    {
        $cellTitles = [
            'reward_id' => 'Id',
            'order_sn' => '订单号',
            'buyer_nickname' => '下单用户',
            'buyer_mobile' => '手机号',
            'agent_nickname' => '分销用户',
            'agent_mobile' => '分销手机号',
            'original_commission' => '原始佣金',
            'commission' => '分销佣金',
            'commission_level' => '执行层级',
            'agent_level' => '执行等级',
            'status_text' => '状态',
            'type_text' => '入账方式',
            'commission_time' => '结算时间'
        ];

        // 数据总条数
        $total = $this->model->sheepFilter()->count();
        if ($total <= 0) {
            $this->error('导出数据为空');
        }

        $export = new \addons\shopro\library\Export();
        $params = [
            'file_name' => '佣金明细列表',
            'cell_titles' => $cellTitles,
            'total' => $total,
            'is_sub_cell' => false,
        ];

        $total_commission = 0;
        $result = $export->export($params, function ($pages) use (&$total_commission, $total) {
            $datas = $this->model->sheepFilter()->with(['buyer', 'agent', 'order', 'order_item'])
            ->limit((($pages['page'] - 1) * $pages['list_rows']), $pages['list_rows'])
            ->select();

            $datas = collection($datas);
            $datas->each(function ($order) {
            })->toArray();

            $newDatas = [];
            foreach ($datas as &$reward) {
                $data = [
                    'reward_id' => $reward['id'],
                    'order_sn' => $reward['order'] ? $reward['order']['order_sn'] : '',
                    'buyer_nickname' => $reward['buyer'] ? $reward['buyer']['nickname'] : '-',
                    'buyer_mobile' => $reward['buyer'] ? $reward['buyer']['mobile'] . ' ' : '-',
                    'agent_nickname' => $reward['agent'] ? $reward['agent']['nickname'] : '-',
                    'agent_mobile' => $reward['agent'] ? $reward['agent']['mobile'] . ' ' : '-',
                    'original_commission' => $reward['original_commission'],
                    'commission' => $reward['commission'],
                    'commission_level' => $reward['commission_level'],
                    'agent_level' => $reward['agent_level'],
                    'status_text' => $reward['status_text'],
                    'type_text' => $reward['type_text'],
                    'commission_time' => $reward['commission_time'],
                ];

                $newDatas[] = $data;
            }

            $total_commission += array_sum(array_column($newDatas, 'commission'));

            if ($pages['is_last_page']) {
                $newDatas[] = ['reward_id' => "总数：" . $total . "；总佣金金额：￥" . $total_commission .  "；"];
            }
            return $newDatas;
        });

        $this->success('导出成功' . (isset($result['file_path']) && $result['file_path'] ? '，请在服务器: “' . $result['file_path'] . '” 查看' : ''), null, $result);
    }
}