public function printHTML()
{
include_once "/Classes/adminHeader.php";
$adminHeader = new adminHeader();
$adminHeader->renderPage();
$this->RenderPage();
}
public function printHTML()
{
include_once "/Classes/adminHeader.php";
$adminHeader = new adminHeader();
$adminHeader->renderPage();
print '
<title>Run2Day - Home</title>
<h1>Home</h1>
<form action="?adminhome&search" method="post">
<div class="row">
<div class="col-lg-6">
<div class="input-group">
<input name="naam" type="text" class="form-control" placeholder="Zoek een deelnemer....">
<span class="input-group-btn">
<button type="submit" class="btn btn-default" type="button"><i class="fa fa-search"></i> Zoek</button>
</span>
</div><!-- /input-group -->
</div><!-- /.col-lg-6 -->
</form>
</div>
<p><a class="btn btn-primary btn-md" href="../excel/leeg.xlsx" role="button"><i class="fa fa-download"></i> Download leeg Excel bestand</a></p>
</div>
';
if (isset($_GET['search'])) {
$this->renderSearch();
}
}
public function renderPage()
{
include_once "/Classes/adminHeader.php";
$adminHeader = new adminHeader();
$adminHeader->renderPage();
print '
<title>Run2Day - Importeer Excel</title>
<div class="container">
<h1><i class="fa fa-download"></i> Excel naar databse (beta)</h1>
<p>Selecteer een wedstrijd om te exporteren naar de database.
<br>Let op! Het importen kan even duren, sluit de pagina niet.</p>
<table class="table">
<tr>
<th>Naam</th>
<th>Datum</th>
<th>Locatie</th>
<th>Importeer</th>
<th>Toon data</th>
<th>Verwijder database</th>
</tr> ';
require_once "/Classes/databaseHandler.class.php";
$Database = new Database();
$Database->query('SELECT wedstrijdID, name, date, location FROM wedstrijden');
$this->wedstrijden = $Database->resultset();
foreach ($this->wedstrijden as $key) {
print '<tr><td>' . $key['name'] . ' </td>';
print '<td>' . $key['date'] . ' </td>';
print '<td>' . $key['location'] . ' </td>';
print ' <td><a class="fa fa-folder-open-o" href="?importexcel&import=' . $key['wedstrijdID'] . '"</td>';
print ' <td><a class="fa fa-folder-open-o" href="?importexcel&show=' . $key['wedstrijdID'] . '"</td>';
print ' <td><a class="fa fa-trash-o" href="?importexcel&removedb=' . $key['wedstrijdID'] . '"</td></tr>';
}
print '
</table>
</div>
</div>
</div>
';
}
<?php
require_once "framework/module/adminHeader.php";
require_once "framework/router/adminSidebar.php";
$adminHeaderModule = new adminHeader($connection);
$adminResult = $adminTable->selectAdmin($sessionAdmin);
$themeName = "light";
$headerStyle = "";
$footerStyle = "";
if (!empty($adminResult)) {
if ($adminResult["headerStyle"] == "0") {
$headerStyle = "header-default";
}
if ($adminResult["footerStyle"] == "1") {
$footerStyle = "footer-fixed";
}
$themeName = $adminResult["theme"];
$adminFullName = $adminResult['adminName'];
$adminImage = $adminResult['image'];
if (!empty($adminImage)) {
$adminImage = PATH . "/assets/snap/snap30/" . $adminImage;
} else {
$adminImage = PATH . "/assets/snap/snap30/user.png";
}
$lessText = $adminResult['text'];
$lessBase = $adminResult['base'];
$lessBadge = $adminResult['badge'];
$lessActive = $adminResult['lessActive'];
}
$adminSideList = $adminHeaderModule->getListModule($sessionAdmin, $adminURL);
$miscTable = new miscTable($connection);
public function printHTML()
{
require_once "/Classes/databaseHandler.class.php";
$Database = new Database();
include_once "/Classes/adminHeader.php";
$adminHeader = new adminHeader();
$adminHeader->renderPage();
if (isset($_GET['delete'])) {
$Database->query('DELETE FROM wedstrijden WHERE wedstrijdID=?');
$Database->bind(1, $_GET["delete"]);
$Database->execute();
}
echo '
<title>Run2Day - Wedstrijdbeheer</title>
<h1>Wedstrijdbeheer</h1>
<table class="table">
<tr>
<th>Naam</th>
<th>Locatie</th>
<th>Datum</th>
<th>Bestandsnaam</th>
<th>Video</th>
<th>Foto</th>
<th>Cert</th>
<th>Stats</th>
<th>Wijzig</th>
<th>Verwijderen</th>
</tr>
';
$Database->query('SELECT wedstrijdID, name, date, location, fileName, video, foto, cert, stats FROM wedstrijden');
$result = $Database->resultset();
foreach ($result as $key) {
print '<tr><td>' . $key['name'] . ' </td>';
print '<td>' . $key['location'] . ' </td>';
print '<td>' . $key['date'] . ' </td>';
print '<td>' . $key['fileName'] . ' </td>';
if (!empty($key['video'])) {
print '<td><i class="fa fa-check"></i></td>';
} else {
print '<td><i class="fa fa-times"></i></td>';
}
if (!empty($key['foto'])) {
print '<td><i class="fa fa-check"></i></td>';
} else {
print '<td><i class="fa fa-times"></i></td>';
}
if (!empty($key['cert'])) {
print '<td><i class="fa fa-check"></i></td>';
} else {
print '<td><i class="fa fa-times"></i></td>';
}
if (!empty($key['stats'])) {
print '<td><i class="fa fa-check"></i></td>';
} else {
print '<td><i class="fa fa-times"></i></td>';
}
print ' <td><a class="fa fa-pencil" href="?dashboard&update=' . $key['wedstrijdID'] . '"</td>';
print ' <td><a class="fa fa-trash-o" href="?dashboard&delete=' . $key['wedstrijdID'] . '"</td></tr>';
}
echo '</table>
<!-=================================================================>';
if (isset($_GET['update'])) {
$this->renderUpdateCam();
}
$this->renderAdd();
}
public function RenderPage()
{
require_once "/Classes/databaseHandler.class.php";
$Database = new Database();
include_once "/Classes/adminHeader.php";
$adminHeader = new adminHeader();
$adminHeader->renderPage();
if (isset($_GET['deletecam'])) {
$Database->query('DELETE FROM cams WHERE camID=?');
$Database->bind(1, $_GET["deletecam"]);
$Database->execute();
}
print '
<title>Run2Day - Camerabeheer</title>
<div class="container">
<h1>Camerabeheer</h1>
<table class="table">
<tr>
<th>Wedstrijd</th>
<th>Lees tijden uit</th>
<th>Camera naam</th>
<th><i class="fa fa-vimeo-square"></i> Vimeo ID</th>
<th>Timing</th>
<th>Tijd eerste loper</th>
<th>Verwijderen</th>
</tr>
';
$Database->query('SELECT camID, fk_wedstrijdID, camName, videoID, videoOffset, first_runner, tijdName FROM cams');
$result = $Database->resultset();
foreach ($result as $key) {
$Database->query('SELECT name FROM wedstrijden WHERE wedstrijdID=?');
$Database->bind(1, $key['fk_wedstrijdID']);
$wedstrijd = $Database->single();
print '<tr><td>' . $wedstrijd['name'] . ' </td>';
print '<td>' . $key['tijdName'] . ' </td>';
print '<td>' . $key['camName'] . ' </td>';
print '<td>' . $key['videoID'] . ' </td>';
print '<td>' . $key['videoOffset'] . ' </td>';
print '<td>' . $key['first_runner'] . ' </td>';
print ' <td><a class="fa fa-trash-o" href="?cammanager&deletecam=' . $key['camID'] . '"</td></tr>';
}
print '
</table>
<div class="col-md-4">
<h3>Nieuwe camera toevoegen</h3>
<form action="../Classes/submitcam.php" method="POST" enctype="multipart/form-data">
<label for="pwd">Toevoegen aan:</label>
<select class="form-control" name="wedstrijd" id="wedstrijd">
';
$Database->query('SELECT name, date, fileName FROM wedstrijden');
$result = $Database->resultset();
foreach ($result as $key) {
print ' <option> ' . $key['name'] . '</option>';
}
print '
</select>
<br>
<div class="form-group">
<label for="pwd">Lees tijden uit:</label>
<select class="form-control" name="leestijden" id="leestijden">
<option value="volvo">Finish</option>
<option value="volvo">cam1</option>
<option value="volvo">cam2</option>
<option value="volvo">cam3</option>
</select>
</div>
<div class="form-group">
<label for="pwd">Vimeo ID:</label>
<input type="text" class="form-control" id="vimeoID" name="vimeoID" requied>
</div>
<div class="form-group">
<label for="pwd">Camera naam:</label>
<input type="text" class="form-control" id="naam" name="naam" requied>
</div>
<div class="form-group">
<label for="pwd">Video timing:</label>
<input type="time" class="form-control" id="videoOffset" name="videoOffset" requied>
<div class="form-group">
<label for="pwd">Tijd eerste loper:</label>
<input type="text" class="form-control" id="first" name="first" requied>
</div>
<input type="submit" value="Opslaan">
<br><br>
</div>
</div>
</form>
';
}
