/** * @desc 表赛报告 */ public function actionGameData() { $gameId = Yii::app()->request->getQuery('game', ''); $teamId = Yii::app()->request->getQuery('team', ''); $tournament = new TournamentModel(); $gameDatas = $tournament->findByObjectId($gameId); $gameData = array(); if (isset($gameDatas[0])) { $gameData = $gameDatas[0]; } $playerScoreModel = new PlayerScoreModel(); $userModel = new UserModel(); //$playerData = $playerScoreModel->findByLeague($leagueId); $teamMembers = array(); $tempData = $gameDatas[0]; $playMembers = $playerScoreModel->findScorePlayer($gameId, $teamId); // print_r($gameData );exit("dafafdas"); //$playerData = $playerScoreModel->findByGameId($teamId); $playerData = $playerScoreModel->findCompetitionTeamPlayerScore($gameId, $teamId); //找到属于该联赛的所有球员 $playerArr = array(); foreach ($playerData as $playerScore) { $playerId = $playerScore->player->objectId; if (!in_array($playerId, $playerArr)) { array_push($playerArr, $playerId); } } //统计球员在某个联赛的进球总数 $playerGoalArr = array(); foreach ($playerArr as $playerId) { $playerGoals = 0; foreach ($playerData as $playerScore) { if ($playerId == $playerScore->player->objectId && isset($playerScore->goals) && is_numeric($playerScore->goals)) { $playerGoals += $playerScore->goals; } } $playerGoalArr[$playerId] = $playerGoals; } arsort($playerGoalArr); //合并球员的一些信息 $playerRangeArr = array(); foreach ($playerGoalArr as $playerRange => $playerGoal) { foreach ($playerData as $playerScore) { if ($playerRange == $playerScore->player->objectId) { if (!isset($playerScore->player->nickname) || empty($playerScore->player->nickname)) { $playerScore->player->nickname = '匿名'; } if (!isset($playerScore->team->name) || empty($playerScore->team->name)) { $playerScore->team->name = '匿名球队'; } $playerRangeArr[$playerRange] = array('totalGoals' => $playerGoal, 'name' => $playerScore->player->nickname, 'team' => $playerScore->team->name); } } } //统计球员在某个联赛的助攻总数 $playerAssistsArr = array(); foreach ($playerArr as $playerId) { $playerAssists = 0; foreach ($playerData as $playerScore) { if ($playerId == $playerScore->player->objectId && isset($playerScore->assists) && is_numeric($playerScore->assists)) { $playerAssists += $playerScore->assists; } } $playerAssistsArr[$playerId] = $playerAssists; } arsort($playerAssistsArr); //合并球员的一些信息 $playerAssistsRangeArr = array(); foreach ($playerAssistsArr as $playerRange => $playerAssists) { foreach ($playerData as $playerScore) { if ($playerRange == $playerScore->player->objectId) { if (!isset($playerScore->player->nickname) || empty($playerScore->player->nickname)) { $playerScore->player->nickname = '匿名'; } if (!isset($playerScore->team->name) || empty($playerScore->team->name)) { $playerScore->team->name = '匿名球队'; } $playerAssistsRangeArr[$playerRange] = array('totalAssists' => $playerAssists, 'name' => $playerScore->player->nickname, 'team' => $playerScore->team->name); } } } $this->render('gameData', array("teamId" => $teamId, 'gameData' => $gameData, 'playMembers' => $playMembers, 'playerRangeArr' => $playerRangeArr, 'playerAssistsRangeArr' => $playerAssistsRangeArr)); }
/** * @desc 编辑赛事结果 */ public function actionResultManage() { $masterId = CommonFunction::getUserId(); $leagueModel = new LeagueModel(); //判断用户是否有管理联赛的权限 $res = $leagueModel->allowEditLeague($masterId); $leagueId = $res[0]->objectId; $teamModel = new TeamModel(); $tournamentModel = new TournamentModel(); $playScoreModel = new PlayerScoreModel(); $groupModel = new GroupModel(); $leagueTeams = $teamModel->findRowsByRelation("teams", "League", $leagueId); //先找到联赛中的组 $groupRows = $groupModel->findByLeagueId($leagueId); //var_dump($gruopRows);exit; $groupTeams = array(); $groupTeamsArr = array(); if (!empty($groupRows)) { foreach ($groupRows as $group) { $groupId = $group->objectId; $groupRelTeams = $teamModel->findRowsByRelation("teams", "Group", $groupId); foreach ($groupRelTeams as $team) { $team->groupName = $group->name; $team->groupObjectId = $group->objectId; foreach ($leagueTeams as $lTeam) { if ($lTeam->objectId == $team->objectId) { $lTeam->selected = 1; } } } $groupTeamsArr = $groupRelTeams; array_push($groupTeams, $groupTeamsArr); } } //var_dump($groupTeams);exit; $games = array(); $games = $tournamentModel->findByLeague($leagueId); $leagueGamesData = $playScoreModel->findByLeague($leagueId); //var_dump($leagueGamesData);exit; foreach ($games as $k => $game) { if (isset($game->start_time->iso)) { $fromStartTime = time() - strtotime($game->start_time->iso); // echo $fromStartTime.'||'.$game->start_time->iso.'||'.date ( "Y-m-d H:i:s" ).'||'.strtotime($game->start_time->iso).'<br/>'; if ($fromStartTime > 7200 && (!isset($game->isVerify) || !$game->isVerify)) { $game->allowResultEdit = true; } else { $game->allowResultEdit = false; } //比赛开始后2小时,认为比赛结束 if ($fromStartTime < 7200) { //echo (time() - strtotime($game->start_time->iso)).'<br/>'.$game->start_time->iso; unset($games[$k]); } else { foreach ($leagueGamesData as $k => $gameData) { if (isset($gameData->competition->objectId) && isset($game->objectId) && isset($gameData->team->objectId) && isset($game->home_court->objectId) && $gameData->competition->objectId == $game->objectId && $gameData->team->objectId == $game->home_court->objectId) { //这场比赛的主队球员进球情况 $game->home_court->playerscore[] = array('player' => empty($gameData->player->nickname) ? '匿名' : $gameData->player->nickname, 'score' => $gameData->goals); } elseif (isset($gameData->competition->objectId) && isset($game->objectId) && isset($gameData->team->objectId) && isset($game->opponent->objectId) && $gameData->competition->objectId == $game->objectId && $gameData->team->objectId == $game->opponent->objectId) { //这场比赛的客队球员进球情况 $game->opponent->playerscore[] = array('player' => empty($gameData->player->nickname) ? '匿名' : $gameData->player->nickname, 'score' => $gameData->goals); } } } } else { unset($games[$k]); } } $this->render('resultManage', array('leagueTeams' => $leagueTeams, 'groupTeams' => $groupTeams, 'games' => $games)); }