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> '; }
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> '; }