Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- require "connection.php";
- $con = connection();
- $imie = $_SESSION['imie'];
- $nazwisko = $_SESSION['nazwisko'];
- if($_SESSION['admin'] == "Yes") {
- $admin = " [Administrator] ";
- } else {
- $admin = "";
- header("Location: //localhost/NewProject/loguj.php");
- }
- if(!isset($_SESSION['sort'])) {
- $_SESSION['sort'] = 1;
- }
- function sortowanie() {
- switch($_SESSION['sort']) {
- case 1:
- return 'SELECT * FROM uzytkownicy';
- case 2:
- return 'SELECT * FROM uzytkownicy ORDER BY punkty DESC';
- case 3:
- return 'SELECT * FROM uzytkownicy ORDER BY punkty';
- case 4:
- return 'SELECT * FROM uzytkownicy ORDER BY imie';
- }
- }
- function select() {
- $_SESSION['sort'] = 3;
- $kwerenda = sortowanie();
- }
- if(isset($_POST['state'])&&$_POST['state'] != 0) {
- $_SESSION['sort'] = $_POST['state'];
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Punktacja</title>
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta charset="utf-8">
- <?php echo '<link rel="stylesheet" href="http://bootswatch.com/lumen/bootstrap.min.css" crossorigin="anonymous">'; ?>
- <link rel="stylesheet" href="style.css">
- <link rel="stylesheet" href="select.css">
- <script type="text/javascript" src="jquery.js"></script>
- <script src="http://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>
- <script src="jquery.min.js"></script>
- <script src="bootstrap.min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.12.2/js/bootstrap-select.min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.12.2/js/i18n/defaults-*.min.js"></script>
- </head>
- <body>
- <nav class="navbar navbar-default">
- <div class="container-fluid">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
- <span class="sr-only">Toggle navigation</span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand" href="index.php">Punktacja</a>
- </div>
- <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
- <ul class="nav navbar-nav">
- <li><a href="index.php"><i class="glyphicon glyphicon-folder-open"></i> Lista Użytkowników <span class="sr-only">(current)</span></a></li>
- <li><a href="dodaj.php"><i class="glyphicon glyphicon-cloud-upload"></i> Zgłoś Odpowiedź </a></li>
- </ul>
- <ul class="nav navbar-nav navbar-right">
- <?php
- if($imie != '')
- {
- echo '<li class="active"><a href="user.php"><i class="glyphicon glyphicon-user"></i> Witaj, <b>'.$nazwisko.' '.$imie.$admin.' </a></b></li>';
- echo '<li><a href="logout.php"><i class="glyphicon glyphicon-log-out"></i> Wyloguj!</a></li>';
- } else {
- echo '<li><a href="loguj.php"><i class="glyphicon glyphicon-user"></i> Logowanie</a></li>';
- }
- ?>
- <li><a href="admin.php"><i class="glyphicon glyphicon-wrench"></i> Panel Administratora</a></li>
- </ul>
- </div>
- </div>
- </nav>
- <?php
- $kwerenda = sortowanie();
- $rezultat = mysqli_query($con, $kwerenda);
- $row = mysqli_fetch_assoc($rezultat);
- $punkty = $row['punkty'];
- $ADDdate = $row['ADDdate'];
- $CHdate = $row['CHdate'];
- $stat = $row['status'];
- $LABoczekujacy = '<span class="label label-default">Oczekuje na ocene</span>';
- $LABadmin = '<span class="label label-warning">Administrator</span>';
- $LABoceniony = '<span class="label label-success">Oceniony!</span>';
- if($stat == 'oczekujacy') {
- $CHdate = $LABoczekujacy;
- $stat = $LABoczekujacy;
- } else {
- }
- ?>
- <div id="container">
- <div class="col-sm-6">
- <div class="form-group">
- <h3><label class="control-label"><font color="black">Witaj, <b><?php echo $nazwisko.' '.$imie; ?> [Administrator]</b></font></label><br></h3>
- <h4><label class="control-label"><font color="black">Panel Administratora</font></label></h4>
- </div>
- <div id="menu">
- <?php
- require_once 'connection.php';
- $con = connection();
- $kwerenda = sortowanie();
- $rezultat = mysqli_query($con, $kwerenda);
- $ile = mysqli_num_rows($rezultat);
- echo '<div id="sorting">';
- echo '<form name="sorts" action="admin.php?id='.$id.'" method="post">';
- echo '<select name="state" onchange="this.form.submit();" class="selectpicker" data-width="fit">';
- echo '<option>Sortowanie</option>';
- echo '<optgroup label="[SORT] Opcje">';
- echo '<option value="1">Wylacz</option>';
- echo '</optgroup><optgroup label="[SORT] Punkty">';
- echo '<option value="2">Malejaco</option>';
- echo '<option value="3">Rosnaco</option>';
- echo '</optgroup><optgroup label="[SORT] Imie">';
- echo '<option value="4">Alfabetycznie</option>';
- echo '</optgroup>';
- echo '</select>';
- echo '</form>';
- echo '</div>';
- ?>
- </div>
- <table id="pag" class='table table-striped table-hover'>
- <tr><th>#</th><th>Nazwisko</th><th>Imię</th><th>Wynik</th><th>Status Oceny</th><th>Akcje</th></tr>
- <?php
- for($i = 1; $i <= $ile; $i++) {
- $row = mysqli_fetch_assoc($rezultat);
- $imie = $row['imie'];
- $punkty = $row['punkty'];
- $nazwisko = $row['nazwisko'];
- $status = $row['status'];
- $idoceny = $row['id'];
- if($status == 'oczekujacy') {
- $status = $LABoczekujacy;
- } else if($status == 'admin'){
- $status = $LABadmin;
- } else if($status == 'oceniony') {
- $status = $LABoceniony;
- }
- if(!empty($imie)) {
- echo "<tr><td>$i</td><td>$nazwisko</td><td>$imie</td><td>$punkty</td><td>$status</td><td><a href='ocena.php?ocen=$idoceny' class='btn btn-default btn-xs'>Ocen</a> <a href='edytuj.php?ocen=$idoceny' class='btn btn-default btn-xs'>Edytuj</a></td></tr>";
- }
- }
- ?>
- </table>
- <script>
- $('#pag').DataTable();
- </script>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement