request->userInfo; // 获取查询参数 $page = Request::get('page', 1, 'intval'); $limit = Request::get('limit', 10, 'intval'); // 筛选条件 $filters = [ // 时间筛选 'start_time' => Request::get('start_time', date('Y-m-d', strtotime('-7 days')), 'trim'), 'end_time' => Request::get('end_time', date('Y-m-d'), 'trim'), 'game_id' => Request::get('game_id', '', 'trim'), ]; try { // 获取游戏每日数据 $result = GameStatisModel::getGameDailyList( $userInfo['merchant_id'], $page, $limit, $filters, ); // 获取游戏信息信息 $game_ids = array_unique(array_column($result['list'], 'game_id')); $tempGameList = GameModel::where([['merchant_id', '=', $userInfo['merchant_id']], ['game_id', 'in', $game_ids]]) ->field(['game_id','title','image', 'game_platform']) ->select() ->toArray(); $gameList = []; foreach ($tempGameList as $game) { $game_id = $game['game_id']; $gameList[$game_id] = $game; } // 格式化数据 foreach ($result['list'] as &$item) { $game_id = $item['game_id']; $gameInfo = $gameList[$game_id] ?? []; if (!empty($gameInfo)) { $gameImages = CommonUtils::getGameDefaultImage($gameInfo); } $item['game_image_url'] = $gameImages['image_url'] ?? ''; $item['game_title'] = $gameInfo['title'] ?? ''; $item['game_type_text'] = CommonUtils::getGameTypeConfig($gameInfo['game_platform']); $item['game_profit'] = CommonUtils::convertBalance($item['game_profit'], false); $item['bet_amount'] = CommonUtils::convertBalance($item['bet_amount'], false); $item['commission_amount'] = CommonUtils::convertBalance($item['game_profit'] * 0.08, false); $item['platform_fee'] = CommonUtils::convertBalance($item['bet_amount'] * 0.08, false); $item['buy_free_bet'] = 0; } return json_success($result, '获取成功'); } catch (\Exception $e) { return json_error([], '获取游戏每日数据失败:' . $e->getMessage()); } } }