<?php
require 'global/dbConnection.php';
require 'classes/Game.php';
require 'classes/GameMapper.php';
$gameMapper = new GameMapper();
$gameList = $gameMapper->getGames();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Assignment 2</title>
<link rel="stylesheet" href="css/bootstrap.min.css" />
<link type="text/css" rel="stylesheet" href="css/styles.css" />
</head>
<body>
<?php
include 'global/navigation.html';
?>
<div class="container-fluid" id="wrapper">
<div>
<h4>Products</h4>
<hr />
<table>
<thead>
<tr>
<th>Title</th>
<th>Studio</th>
public function retrieveGames()
{
$this->retrievedScheduledGameNefubIds = array();
$aTeams = Team::getAll(array('season_nefub_id' => Season::getInstance()->nefub_id, 'competition_id'));
foreach ($aTeams as $oTeam) {
// scheduled games
$scheduleUrl = NEFUB_API . '/schedule.php?team=' . $oTeam->nefub_id;
$schedule = $this->getNefubContentsParsed($scheduleUrl, MAX_AGE_TEAM_SCHEDULE);
if (isset($schedule->wedstrijden) && is_array($schedule->wedstrijden)) {
foreach ($schedule->wedstrijden as $scheduledGame) {
if (!$this->retrievedScheduledGameNefubIds[$scheduledGame->ID]) {
$oGame = GameMapper::mapFromAPI($scheduledGame);
$this->retrievedScheduledGameNefubIds[$scheduledGame->ID] = true;
}
}
}
// end scheduled games
//Results.. alleen als er nog games sonder retrieved_actions in het verleden zijn
$query = "SELECT COUNT(Game.nefub_id) as countGames\n\t\t\t\t\t\t\tFROM Game\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t(team1_nefub_id = '" . $oTeam->nefub_id . "'\n\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\tteam2_nefub_id = '" . $oTeam->nefub_id . "')\n\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tGame.date <= CURDATE()\n\t\t\t\t\t\t\t\tAND Game.actions_retrieved = 0";
$rows = Database::select_rows_by_query($query);
$gamesToRetrieve = $rows[0]['countGames'];
if ($gamesToRetrieve) {
// scheduled games
$resultUrl = NEFUB_API . '/results.php?team=' . $oTeam->nefub_id;
$result = $this->getNefubContentsParsed($resultUrl, MAX_AGE_TEAM_SCHEDULE);
if (isset($result->wedstrijden) && is_array($result->wedstrijden)) {
foreach ($result->wedstrijden as $resultGame) {
if (!$this->retrievedResultGameNefubIds[$resultGame->ID]) {
$oGame = GameMapper::mapFromAPI($resultGame);
$this->retrievedResultGameNefubIds[$resultGame->ID] = true;
}
}
}
// end result games
}
}
}
