Page for permission level 2 (professor) = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = */ if ($loggedInUser->checkPermission(array(2))) { openPage("Seeker/Solver Marketplace vue Professeur"); switch ($_GET['cmd']) { /* Le détail d'une proposition et la boite de réponse */ case "detail": echo "<p>Voici les détails de la proposition sélectionnée.</p>"; afficheDetails($_GET['id'], 'M'); break; default: echo "<p>Les questions de toutes les équipes, vous pouvez en voir le détail en cliquant sur la loupe <img src='images/loupe.png'>.\r\n </p>"; listeMarketPlace("bbuy", "Demander", " {$sortOrder}"); break; } } // fin professeur /* = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Page for permission level 3 (administrator) = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = */ if ($loggedInUser->checkPermission(array(3))) { openPage("Les scores globaux"); if ($result = mysqli_query($mysqli, "SELECT display_name, sum(debit),count(debit), sum(credit), count(credit) \r\n FROM account A, sk_users U WHERE A.account1 = U.id GROUP BY account1")) { echo "<table style='width:100%; border-spacing:0;'>" . "<tr><th>Team</th><th>Débit</th><th>Crédit</th><th width='50%'>Solde</th></tr>"; /* fetch associative array */ while (list($teamName, $debit, $debitTrans, $credit, $creditTrans) = mysqli_fetch_row($result)) {
Page for permission level 2 (professor) = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = */ if ($loggedInUser->checkPermission(array(2))) { openPage("Welcome professor"); switch ($_GET['cmd']) { /* Le détail d'une proposition et la boite de réponse */ case "detail": echo "<p>Voici les détails de la proposition sélectionnée.</p>"; afficheDetails($_GET['id'], 'W'); break; default: echo "<p>Voir la liste des compétences déjà déposées par les équipes, vous pouvez en voir le détail en cliquant sur la loupe <img src='images/loupe.png'>.<br/></p>"; listeMarketPlace("bsell", "Proposer", " {$sortOrder}"); break; } } // fin professeur if ($loggedInUser->checkPermission(array(3))) { //Links for permission level 3 (administrator) openPage("Les scores globaux"); if ($result = mysqli_query($mysqli, "SELECT display_name, sum(debit),count(debit), sum(credit), count(credit) \r\n FROM account A, sk_users U WHERE A.account1 = U.id GROUP BY account1")) { echo "<table style='width:100%; border-spacing:0;'>" . "<tr><th>Team</th><th>Débit</th><th>Crédit</th><th width='50%'>Solde</th></tr>"; /* fetch associative array */ while (list($teamName, $debit, $debitTrans, $credit, $creditTrans) = mysqli_fetch_row($result)) { echo "<tr><td>{$teamName}</td><td>" . number_format($debit) . " ({$debitTrans}) </td><td>" . number_format($credit) . " ({$creditTrans})</td><td>" . number_format($credit - $debit) . "</td></tr>"; } echo "</table>\r\n\t\t<br/>\r\n* * * * End Of Report * * * *"; /* Libération du jeu de résultats */