dms-api/app/v1/controller/CommonController.php

<?php
namespace app\v1\controller;

use app\v1\logic\advert\AgentListLogic;
use app\v1\logic\advert\AgentSiteLogic;
use app\v1\logic\advert\GamePackageLogic;
use app\v1\logic\advert\MediaListLogic;
use app\v1\logic\center\GameGroupLogic;
use app\v1\logic\center\GameLogic;
use plugin\saiadmin\basic\BaseController;
use app\v1\logic\center\GameMainLogic;
use plugin\saiadmin\app\logic\system\SystemUserLogic;
use plugin\saiadmin\app\model\system\SystemDept;
use support\Request;
use support\Response;
use support\think\Db;

/**
 * 公共接口管理控制器
 */
class CommonController extends BaseController
{
    protected $gameMainLogic;
    protected $gameLogic;
    protected $mediaListLogic;
    protected $agentListLogic;
    protected $systemUserLogic;
    protected $gamePackageLogic;
    protected $agentSiteLogic;
    protected $gameGroupLogic;

    /**
     * 构造函数
     */
    public function __construct()
    {
        parent::__construct();
        $this->gameMainLogic = new GameMainLogic();
        $this->gameLogic = new GameLogic();
        $this->mediaListLogic = new MediaListLogic();
        $this->agentListLogic = new AgentListLogic();
        $this->systemUserLogic = new SystemUserLogic();
        $this->gamePackageLogic = new GamePackageLogic();
        $this->agentSiteLogic = new AgentSiteLogic();
        $this->gameGroupLogic = new GameGroupLogic();
    }



    // /**
    //  * 按照权限获取游戏信息，通过游戏分组
    //  */
    // public function getGameListOptions(Request $request): Response
    // {
    //     $where = $request->get();
    //     $data = $this->gameGroupLogic->getGameListOptions($where);
    //     return $this->success($data);
    // }
    
    /**
     * 获取主游戏options列表
     * @return Response
     */
    public function getMainGameOptions(Request $request): Response
    {
        $data = $this->gameMainLogic->getMainGameOptions();
        return $this->success($data);
    }

    /**
     * 获取子游戏options列表（有权限）
     * @return Response
     */
    public function getGameOptions(Request $request): Response
    {

        $where = $request->get();
        $data = $this->gameLogic->getGameOptions($where);
        return $this->success($data);
    }

    /**
     * 获取子游戏options列表（无权限）
     * @return Response
     */
    public function getGameOptionsNoAuth(Request $request): Response
    {
        $where = $request->get();
        $data = $this->gameLogic->getGameOptionsNoAuth($where);
        return $this->success($data);
    }


    /**
     * 查询媒体列表Options
     */
    public function getMediaOptions(Request $request): Response
    {
        $data = $this->mediaListLogic->getMediaOptions();
        $data = $data->toArray();
        

        return $this->success($data);
    }

    /**
     * 查询渠道列表Options
     */
    public function getAgentOptions(Request $request): Response
    {
        $data = $this->agentListLogic->getAgentOptions();
        return $this->success($data);
    }

    /**
     * 后台归属人列表Options
     */
    public function getAuthOptions(Request $request): Response
    {
        // 获取用户列表
        $data = $this->systemUserLogic->field('id as value, username as label,dept_id')->group('dept_id')->select()->toArray();
        
        // 获取用户部门
        $deptList = SystemDept::where('1=1')->select()->toArray();

        $result = [];
        // 将部门列表转为以id为key的数组，便于查找
        $deptMap = [];
        foreach ($deptList as $dept) {
            $dept['children'] = [];
            $dept['users'] = [];
            $deptMap[$dept['id']] = $dept;
        }

        // 将用户分配到对应部门的users中
        foreach ($data as $user) {
            if (isset($deptMap[$user['dept_id']])) {
                $deptMap[$user['dept_id']]['users'][] = [
                    'value' => $user['value'],
                    'label' => $user['label'],
                ];
            }
        }

        // 构建部门树
        $tree = [];
        foreach ($deptMap as $id => &$dept) {
            if ($dept['parent_id'] && isset($deptMap[$dept['parent_id']])) {
                $deptMap[$dept['parent_id']]['children'][] = &$dept;
            } else {
                $tree[] = &$dept;
            }
        }
        unset($dept);

        // 递归格式化输出
        function formatDeptTree($depts) {
            $result = [];
            foreach ($depts as $dept) {
                $item = [
                    'value' => $dept['id'],
                    'label' => $dept['name'],
                ];
                // 先加用户
                if (!empty($dept['users'])) {
                    $item['children'] = $dept['users'];
                }
                // 再加子部门
                if (!empty($dept['children'])) {
                    $children = formatDeptTree($dept['children']);
                    if (!empty($item['children'])) {
                        $item['children'] = array_merge($item['children'], $children);
                    } else {
                        $item['children'] = $children;
                    }
                }
                $result[] = $item;
            }
            return $result;
        }

        $result = formatDeptTree($tree);
    
        
        return $this->success($result);
    }


    /**
     * 设计归属人列表Options
     */
    public function getDesignAuthOptions(Request $request): Response
    {
        $data = $this->systemUserLogic->field('id as value, username as label')->where('dept_id',11)->select()->toArray();
        return $this->success($data);
    }


    /**
     * 获取母包列表Options
     */
    public function getPackageOptions(Request $request): Response
    {
        $where = $request->get();
        $data = $this->gamePackageLogic->getPackageOptions($where);
        return $this->success($data);
    }

    /**
     * 获取广告位options
     */
    public function getAgentSiteOptions(Request $request): Response
    {
        $data = $this->agentSiteLogic->getAgentSiteOptions();
        return $this->success($data);
    }

    /**
     * 获取充值渠道
     */
    public function getPayChannelOptions(Request $request): Response
    {
        $data = Db::connect('db_center')->table('pay_channel')->where('status',1)->select()->toArray();
        return $this->success($data);
    }

    /**
     * 给游戏分组用的游戏列表
     */
    public function getGameListOptionsByGroup(Request $request): Response
    {
        $where = $request->more([
            ['game_group_id', '']
        ]);
        $data = $this->gameGroupLogic->getGameListOptionsByGroup($where);
        return $this->success($data);
    }


}