leaderboard.php

<?php

require '../vendor/autoload.php';

include './utils/content.php';
include './utils/requestUtils.php';

session_start();


// postgres
$dbName = getenv('DB_NAME');
$dbUser = getenv('DB_USER');
$dbPassword = getenv('DB_PASSWORD');
$connection = new PDO("pgsql:host=postgres user=$dbUser dbname=$dbName password=$dbPassword");


//repositories
$userRepository = new \User\UserRepository($connection);
$reviewRepository = new \Review\ReviewRepository($connection);
$coupdecoeurRepository = new \CoupDeCoeur\CoupDeCoeurRepository($connection);
$orderRepository = new \Order\OrderRepository($connection);


$listeUser = $userRepository->fetchAll();

if (isset($_SESSION["id_user"])) {
	$listeReviewperso = $reviewRepository->fetchByIdUser($_SESSION["id_user"]);
	$listeCDCperso = $coupdecoeurRepository->fetchByIdUser($_SESSION["id_user"]);
}
else {
	$listeReviewperso = [];
	$listeCDCperso = [];
}


urlHasArgument();

?>


<!DOCTYPE html>
<html>
<?php generateHeader('leaderboard'); ?>
<body onload="startDisplayerMoyReview('NoteLeaderboard', 'NoteLeaderboardDisplayArea'); startDisplayerNbCDC('CDCLeaderboard', 'CDCLeaderboardDisplayArea')" style="text-align: center;
    background-image:url('./ressources/background/test2.jpeg');
     background-repeat: no-repeat; 
     background-attachment: fixed;">
	<!-- génération des bannières -->
	<?php
	generateNavBar('leaderboard');
	?>
	<!-- balises cachées contenant les images par ordre de notation -->
	<div id="NoteLeaderboard" style="display: none">
		<?php
		$test = $orderRepository->fetchAvgNoteOrder();

		foreach ($test as $elem): ?>
			<li><div class="idPhoto"><?php echo $elem->getIdPhoto(); ?></div><div class="moyenne"><?php echo $elem->getNote(); ?></div></li>
		<?php endforeach; ?>
	</div>

	<div id="CDCLeaderboard" style="display: none">
		<?php
		$test = $orderRepository->fetchCDCOrder();

		foreach ($test as $elem): ?>
			<li><div class="idPhoto"><?php echo $elem->getIdPhoto(); ?></div><div class="nbCDC"><?php echo $elem->getNbCDC(); ?></div></li>
		<?php endforeach; ?>
	</div>

	<h1>Note</h1>
	<div id="NoteLeaderboardDisplayArea"></div>
	<br/>

	<h1>CDC</h1>

	<div id="CDCLeaderboardDisplayArea"></div>


	<?php generateFooter(); ?>


</body>
</html>