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

<?php

namespace app\admin\controller\commission;

use app\common\controller\Backend;
use app\common\model\commission\Apply as ApplyModel;
use app\common\model\commission\Identity as IdentityModel;
use app\common\Service\Commission\AgentApply as AgentApplyService;
use think\Db;
use think\Exception;

class Apply extends Backend
{
    protected $model = null;
    protected $searchFields = 'id,user.nickname,real_name,company_name,status,agent_type,identity.name';
    protected $relationSearch = true;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new ApplyModel();
    }

    /**
     * 查看
     */
    public function index()
    {
        if (!$this->request->isAjax()) {
            return $this->view->fetch();
        }
        
        if ($this->request->request('keyField')) {
            return $this->selectpage();
        }
        
        [$where, $sort, $order, $offset, $limit] = $this->buildparams();
        
        $list = $this->model
            ->with(['user', 'identity', 'province', 'city', 'district', 'admin'])
            ->where($where)
            ->order($sort, $order)
            ->paginate($limit);
        
        // 标识是否是重新审核的申请
        $rows = $list->items();
        
        // 使用IN查询一次性获取所有相关代理商数据，避免N+1查询问题
        $userIds = array_column($rows, 'user_id');
        $existAgents = [];
        if (!empty($userIds)) {
            $existAgents = \app\common\model\commission\Agent::where('user_id', 'in', $userIds)
                ->column('user_id', 'user_id');
        }
        
        foreach ($rows as $row) {
            // 检查用户是否已经是代理商
            $isExist = isset($existAgents[$row['user_id']]);
            $row['is_reaudit'] = $isExist;
            $row['is_reaudit_text'] = $isExist ? '重新审核' : '首次申请';
        }
        
        $result = ['total' => $list->total(), 'rows' => $rows];
        return json($result);
    }

    /**
     * 详情
     */
    public function detail($ids = null)
    {
        $row = $this->model::with(['user', 'identity', 'province', 'city', 'district', 'admin'])
          ->where('id', $ids)
          ->find();
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        $this->view->assign('row', $row);
        return $this->view->fetch();
    }

    /**
     * 审核通过
     */
    public function approve($ids = null)
    {
        if (!$this->request->isPost()) {
            $this->error(__('Invalid parameters'));
        }
        
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        
        if ($row->status != ApplyModel::STATUS_PENDING) {
            $this->error('该申请已经处理过了');
        }
        
        // 检查是否是重新审核（用户已经是代理商）
        $existAgent = \app\common\model\commission\Agent::where('user_id', $row->user_id)->find();
        $isReaudit = $existAgent ? true : false;
        
        Db::transaction(function () use ($row) {
            $service = new AgentApplyService();
            $service->approveApply($row, $this->auth->id);
        });
        
        if ($isReaudit) {
            $this->success('重新审核通过成功，代理商资料已更新');
        } else {
            $this->success('审核通过成功，代理商已创建');
        }
    }

    /**
     * 审核拒绝
     */
    public function reject($ids = null)
    {
        if (!$this->request->isPost()) {
            $this->error(__('Invalid parameters'));
        }
        
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        
        if ($row->status != ApplyModel::STATUS_PENDING) {
            $this->error('该申请已经处理过了');
        }
        
        $reason = $this->request->post('reason', '');
        if (empty($reason)) {
            $this->error('请填写拒绝原因');
        }
        
        $service = new AgentApplyService();
        $service->rejectApply($row, $reason, $this->auth->id);
        
        $this->success('审核拒绝成功');
    }

    /**
     * 删除
     */
    public function del($ids = null)
    {
        if (!$this->request->isPost()) {
            $this->error(__('Invalid parameters'));
        }
        
        if (!$ids) {
            $this->error(__('Parameter %s can not be empty', 'ids'));
        }
        
        $ids = explode(',', $ids);
        $deleteCount = 0;
        
        Db::transaction(function () use ($ids, &$deleteCount) {
            foreach ($ids as $id) {
                $row = $this->model->get($id);
                if ($row) {
                    // 只允许删除待审核和已拒绝的申请
                    //if (in_array($row->status, [ApplyModel::STATUS_PENDING, ApplyModel::STATUS_REJECTED])) {
                        $row->delete();
                        $deleteCount++;
                    //}
                }
            }
        });
        
        if ($deleteCount > 0) {
            $this->success("成功删除 {$deleteCount} 条申请记录");
        } else {
            $this->error('没有可删除的记录（只能删除待审核和已拒绝的申请）');
        }
    }

    /**
     * 批量审核通过
     */
    public function multi($ids = null)
    {
        if (!$this->request->isPost()) {
            $this->error(__('Invalid parameters'));
        }
        
        $action = $this->request->post('action');
        if ($action == 'approve') {
            // 批量审核通过
            if (!$ids) {
                $this->error(__('Parameter %s can not be empty', 'ids'));
            }
            
            $ids = explode(',', $ids);
            $service = new AgentApplyService();
            $successCount = 0;
            $reauditCount = 0;
            
            Db::transaction(function () use ($ids, $service, &$successCount, &$reauditCount) {
                // 获取所有待审核的申请记录
                $rows = $this->model->where('id', 'in', $ids)
                    ->where('status', ApplyModel::STATUS_PENDING)
                    ->select();
                
                if (!$rows->isEmpty()) {
                    // 使用IN查询一次性获取所有相关代理商数据，避免N+1查询问题
                    $userIds = $rows->column('user_id');
                    $existAgents = [];
                    if (!empty($userIds)) {
                        $existAgents = \app\common\model\commission\Agent::where('user_id', 'in', $userIds)
                            ->column('user_id', 'user_id');
                    }
                    
                    foreach ($rows as $row) {
                        // 检查是否是重新审核
                        if (isset($existAgents[$row->user_id])) {
                            $reauditCount++;
                        } else {
                            $successCount++;
                        }
                        
                        $service->approveApply($row, $this->auth->id);
                    }
                }
            });
            
            $message = "批量审核完成";
            if ($successCount > 0) {
                $message .= "，新创建代理商 {$successCount} 个";
            }
            if ($reauditCount > 0) {
                $message .= "，重新审核通过 {$reauditCount} 个";
            }
            
            $this->success($message);
        } elseif ($action == 'del') {
            // 批量删除
            return $this->del($ids);
        } else {
            return parent::multi($ids);
        }
    }
}