Viljaladu

Auto nr.	Sisenemismass	Väljumismass
789BFK	4	0
3312	3	6
44	45	56
345ASD	55	0
789ZXC	29	23
789ZXC	111	2


<?php
    global $yhendus;

    if (!empty($_SERVER['QUERY_STRING'])) {
        $location_add = implode("&", array_map(fn($el) => implode("=", $el),
            array_filter(array_map(fn($el) => explode("=", $el), explode("&", $_SERVER['QUERY_STRING'])),
            fn($el) => !in_array($el[0], array("sort", "sortby")))
        ));
    }

    $sort = isset($_REQUEST["sort"]) ? $_REQUEST["sort"] : "id";
    $otsi = isset($_REQUEST["otsi"]) ? $_REQUEST["otsi"] : "";
    $sort_by = isset($_REQUEST["sortby"]) ? $_REQUEST["sortby"] : "DESC";

    if (!in_array($sort, array("autonr", "sisenemismass", "lahkumismass")))
        $sort = "id";

    if (!in_array($sort_by, array("ASC", "DESC")))
        $sort_by = "DESC";

    $otsi_esc = $yhendus->real_escape_string($otsi);
    $kask = $yhendus->prepare("SELECT id, autonr, sisenemismass, lahkumismass FROM koormad WHERE autonr LIKE '%$otsi_esc%' ORDER BY $sort $sort_by");
    $kask->bind_result($id, $autonr_, $sisenemismass, $lahkumismass);
    $kask->execute();

    $autod = array();

    while ($kask->fetch()) {
        $auto = new stdClass();
        $auto->id = $id;
        $auto->autonr = htmlspecialchars($autonr_);
        $auto->sisenemismass = $sisenemismass;
        $auto->lahkumismass = $lahkumismass;

        array_push($autod, $auto);
    }

    $sort_str_autonr = $sort == 'autonr' && $sort_by == 'DESC' ? '&sortby=ASC' : '';
    $sort_str_sisene = $sort == 'sisenemismass' && $sort_by == 'DESC' ? '&sortby=ASC' : '';
    $sort_str_lahkum = $sort == 'lahkumismass' && $sort_by == 'DESC' ? '&sortby=ASC' : '';

    $location_add_links = "?" . (!empty($location_add) ? $location_add . "&" : "");
?>

<div class="container-fluid mb-5">
    <h2 class="display-5 mb-5">Viljaladu</h2>
    <div class="row g-2 mb-3">
        <div class="col-auto">
            <button type="button" class="btn btn-info" data-bs-toggle="modal" data-bs-target="#lehti-koodid">
                PHP Koodid
            </button>
            <?php if ($_SESSION["admin"] === true): ?>
                <button type="button" class="btn btn-warning" data-bs-toggle="modal" data-bs-target="#lisa-auto-modal">
                    Lisa auto
                </button>
            <?php endif; ?>
            <a href="index.php" class="btn btn-outline-info">
                Tühista
            </a>
        </div>
    </div>

    <form action="?">
        <div class="row g-3 mb-5 col-sm-3">
            <div class="input-group col col-auto">
                <!--  name="otsisona" aria-label="Otsi" aria-describedby="otsisona" -->
                <input class="form-control" list="otsi" name="otsi" id="otsilist" placeholder="Otsi auto..." aria-label="Otsi" aria-describedby="otsi" <?= ($otsi != "") ? "value='$otsi'" : "" ?>>
                <datalist id="otsi">
                    <?php foreach ($autod as $auto): ?>
                        <option value="<?= $auto->autonr ?>">
                    <?php endforeach; ?>
                </datalist>
                <button type="submit" class="btn btn-primary">Otsi</button>
            </div>
        </div>
    </form>

    <form method="post" action="">
        <table class="table table-striped table-hover table-responsive">
            <tr>
                <th><a class="link-body-emphasis link-offset-2 link-offset-3-hover link-underline link-underline-opacity-0 link-underline-opacity-75-hover" href="<?=$location_add_links?>sort=autonr<?=$sort_str_autonr?>">Auto nr. <i class="fa-solid fa-sort"></i></a></th>
                <th><a class="link-body-emphasis link-offset-2 link-offset-3-hover link-underline link-underline-opacity-0 link-underline-opacity-75-hover" href="<?=$location_add_links?>sort=sisenemismass<?=$sort_str_sisene?>">Sisenemismass <i class="fa-solid fa-sort"></i></a></th>
                <th><a class="link-body-emphasis link-offset-2 link-offset-3-hover link-underline link-underline-opacity-0 link-underline-opacity-75-hover" href="<?=$location_add_links?>sort=lahkumismass<?=$sort_str_lahkum?>">Väljumismass <i class="fa-solid fa-sort"></i></a></th>
                <th></th>
            </tr>
            <?php foreach($autod as &$auto): ?>
                <?php $modal_name = "auto". $auto->id; ?>
                <tr>
                    <td><a class="link-info link-offset-2" href="#<?php echo $modal_name; ?>-modal" data-bs-toggle="modal" data-bs-target="#<?php echo $modal_name; ?>-modal"><?= $auto->autonr ?></a></td>
                    <td><?= $auto->sisenemismass ?></td>
                    <td><?= $auto->lahkumismass ?></td>
                    <?php if ($_SESSION["admin"] === true): ?>
                        <td>
                            <a class="link-primary link-offset-2" href="#lisa-mass-modal" data-bs-toggle="modal" data-bs-target="#lisa-mass-modal" data-bs-auto_id="<?= $auto->id ?>">
                                <i class="fa-solid fa-file-pen"></i> Lisa/Muuda väljumismass
                            </a>
                        </td>
                    <?php else: ?>
                        <td></td>
                    <?php endif; ?>
                </tr>
            <?php endforeach; ?>
        </table>
    </form>
</div>

<!-- Modals -->
<form method="post" action="">
    <div class="modal fade" id="lisa-auto-modal" tabindex="-1" aria-labelledby="lisa-auto-modal-label" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h1 class="modal-title fs-5" id="lisa-auto-modal-label">Auto lisamine</h1>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body g-3">
                    <dl>
                        <dd>
                            <div class="input-group col">
                                <span class="input-group-text">Auto number (eg. 789ZXC)</span>
                                <input class="form-control" type="text" maxlength="6" name="autonr" aria-label="Auto number" required />
                            </div>
                        </dd>
                        <dd>
                            <div class="input-group col">
                                <span class="input-group-text">Sisenemismass</span>
                                <input class="form-control" type="number" name="sisenemismass" aria-label="Sisenemismass" required />
                            </div>
                        </dd>
                    </dl>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-primary" name="autolisamine">Lisa</button>
                </div>
            </div>
        </div>
    </div>
</form>

<form method="post" action="">
    <div class="modal fade" id="lisa-mass-modal" tabindex="-1" aria-labelledby="lisa-mass-modal-label" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h1 class="modal-title fs-5" id="lisa-mass-modal-label">Väljumismass lisamine</h1>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" id="auto_id" name="auto_id" />
                    <div class="input-group col">
                        <span class="input-group-text">Väljumismass</span>
                        <input class="form-control" type="number" name="valjumismass" aria-label="Väljumismass" required />
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-primary" name="masslisamine">Lisa</button>
                </div>
            </div>
        </div>
    </div>
</form>


<?php foreach($autod as &$auto): ?>
    <?php $modal_name = "auto". $auto->id; ?>
    <div class="modal fade" id="<?php echo $modal_name; ?>-modal" tabindex="-1" aria-labelledby="<?php echo $modal_name; ?>-modal-label" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h1 class="modal-title fs-5" id="<?php echo $modal_name; ?>-modal-label">Information</h1>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <?php
                        $r = array_filter($autod, function($elem) use($auto) {
                            return $elem->autonr == $auto->autonr;
                        });
                    ?>
                    <div class="container-fluid mx-2">
                        <div class="row">
                            Kokku reisid: <?php echo count($r); ?>
                        </div>
                        <div class="row">
                            Kokku sisenemismass: <?php echo array_sum(array_column($r, 'sisenemismass')); ?>
                        </div>
                        <div class="row">
                            Kokku väljumismass: <?php echo array_sum(array_column($r, 'lahkumismass')); ?>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>
<?php endforeach; ?>

<div class="modal fade" id="lehti-koodid" tabindex="-1" aria-labelledby="lehti-koodid-label" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h1 class="modal-title fs-5" id="lehti-koodid-label">PHP Koodid</h1>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div class="p-1">
                    <button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#lehti-main-kood" data-bs-page="content/main.php">
                        PHP Kood (main.php)
                    </button>
                </div>
                <div class="p-1">
                    <button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#lehti-index-kood" data-bs-page="index.php">
                        PHP Kood (index.php)
                    </button>  
                </div>
                <div class="p-1">
                    <button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#lehti-func-kood" data-bs-page="libs/func.php">
                        PHP Kood (func.php)
                    </button>
                </div>
                <div class="p-1">
                    <button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#lehti-headers-kood" data-bs-page="libs/headers.php">
                        PHP Kood (headers.php)
                    </button>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="lehti-main-kood" tabindex="-1" aria-labelledby="lehti-main-kood-label" aria-hidden="true">
    <div class="modal-dialog modal-dialog-scrollable modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h1 class="modal-title fs-5" id="lehti-main-kood-label">Lehe PHP Kood</h1>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <?php highlight_file('content/main.php'); ?>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#lehti-koodid">Tagasi</button>
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="lehti-index-kood" tabindex="-1" aria-labelledby="lehti-index-kood-label" aria-hidden="true">
    <div class="modal-dialog modal-dialog-scrollable modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h1 class="modal-title fs-5" id="lehti-index-kood-label">Lehe PHP Kood</h1>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <?php highlight_file('index.php'); ?>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#lehti-koodid">Tagasi</button>
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="lehti-func-kood" tabindex="-1" aria-labelledby="lehti-func-kood-label" aria-hidden="true">
    <div class="modal-dialog modal-dialog-scrollable modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h1 class="modal-title fs-5" id="lehti-func-kood-label">Lehe PHP Kood</h1>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <?php highlight_file('libs/func.php'); ?>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#lehti-koodid">Tagasi</button>
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="lehti-headers-kood" tabindex="-1" aria-labelledby="lehti-headers-kood-label" aria-hidden="true">
    <div class="modal-dialog modal-dialog-scrollable modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h1 class="modal-title fs-5" id="lehti-headers-kood-label">Lehe PHP Kood</h1>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <?php highlight_file('libs/headers.php'); ?>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#lehti-koodid">Tagasi</button>
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<script>
    const lisaMassMadal = document.querySelector('#lisa-mass-modal');
    lisaMassMadal.addEventListener('show.bs.modal', function(event) {
        const button = event.relatedTarget;
        const auto_id = button.getAttribute('data-bs-auto_id');

        document.getElementById('auto_id').value = auto_id;
    });
</script>


<?php
    require('libs/func.php');
    require('libs/conf.php');
    require('libs/headers.php');
?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Viljaladu</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css" integrity="sha512-z3gLpd7yknf1YoNbCzqRKc4qyor8gaKU1qmn+CShxbuBusANI9QpRohGBreCFkKxLhei6S9CQXFEbbKuqLg0DA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <link rel="stylesheet" href="style/style.css">
</head>
<body>
<?php
    include('template/header.php');
    include('template/navigation.php');
?>
<main>
    <?php
        if (isset($_REQUEST['init_ok'])) {
            echo "<h1>Database initialized</h1>";
        }
    ?>
    <?php
        $container_ = !empty($_GET["container"]) ? $_GET["container"] : "content";
        $page_ = !empty($_GET["page"]) ? $_GET["page"] : "main";
        $page_ .= !str_contains($page_, '.php') ? '.php' : '';

        if ($page_ == 'login.php')
            include('template/login.php');
        else if ($page_ == 'ylesanne.php') {
            $filename = !empty($_GET['lang']) && $_GET['lang'] == 'ru' ? 'ulesanne_rus.txt' : 'ulesanne.txt';
            $file = fopen($filename, 'r');

            if ($file == false) {
                echo "<pre>Error in opening file</pre>";
            } else {
                $filesize = filesize($filename);
                $filetext = fread($file, $filesize);
                fclose($file);
            
                echo "<pre>$filetext</pre>";
            }
        } else if (file_exists($container_ . '/' . $page_)) {
            include($container_.'/'.$page_);
        }
    ?>
</main>
<?php
    include('template/footer.php');
?>
<script src="https://code.jquery.com/jquery-3.7.1.slim.min.js" integrity="sha256-kmHvs0B+OpCW5GVHUNjv9rOmY0IvSIRcf7zGUDTDQM8=" crossorigin="anonymous"></script>
<script src="https://unpkg.com/@popperjs/core@2"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-C6RzsynM9kWDrMNeT87bh95OGNyZPhcTNXj1NW7RuBCsyN/o0jlpcV8Qyq46cDfL" crossorigin="anonymous"></script>
</body>
</html>


<?php

global $yhendus;

session_start();

$page_ = isset($_REQUEST['page']) ? $_REQUEST['page'] : "main";
$page_check = !str_contains($page_, '.php') ? $page_ . '.php' : $page_;

$tagasi = (isset($_REQUEST['tagasi']) && !empty($_REQUEST['tagasi'])) ? $_REQUEST['tagasi'] : "main";
$tagasi_check = !str_contains($tagasi, '.php') ? $tagasi . '.php' : $tagasi;

if (!file_exists('content/' . $tagasi_check)) {
    $tagasi = "main";
}

if (!isset($_SESSION["error"])) {
    $_SESSION["error"] = "";
}

if (!isset($_SESSION["admin"])) {
    $_SESSION["admin"] = false;
}

if ($page_check == 'login.php') {
    if (isset($_SESSION['tuvastamine'])) {
        header("Location: $_SERVER[PHP_SELF]?page=$tagasi");
        exit();
    }

    if (!empty($_POST['login']) && !empty($_POST['pass'])) {
        $login = htmlspecialchars(trim($_POST['login']));
        $pass = htmlspecialchars(trim($_POST['pass']));

        $sool = 'taiestisuvalinetekst';
        $krypt = crypt($pass, $sool);
        // kontrollime kas andmebaasis on selline kasutaja

        $kask = $yhendus->prepare("SELECT id, kasutaja, parool, isadmin FROM kasutajad WHERE kasutaja=?");
        $kask->bind_param("s", $login);
        $kask->bind_result($id, $kasutajanimi, $parool, $onadmin);
        $kask->execute();

        if ($kask->fetch() && $krypt == $parool) {
            $_SESSION['kasutaja'] = $login;
            if ($onadmin == 1) {
                $_SESSION['admin'] = true;
            }
            header("Location: index.php");
            exit();
        } else {
            header("Location: $_SERVER[PHP_SELF]?page=$page_&errormsg=1");
            exit();
        }
    }
}

if ($page_check == 'logout.php') {
    session_destroy();
    header("Location: $_SERVER[PHP_SELF]?page=$tagasi");
    exit();
}

if ($page_check == 'main.php') {
    if (isset($_REQUEST["masslisamine"])) {
        if (!empty($_REQUEST["valjumismass"]) && !empty($_REQUEST["auto_id"]) && !preg_match("#[A-z]#", $_REQUEST["valjumismass"])) {
            $kask = $yhendus->prepare("UPDATE koormad SET lahkumismass=? WHERE id=?");
            $kask->bind_param("ii", $_REQUEST["valjumismass"], $_REQUEST["auto_id"]);
            $kask->execute();
        }
    }

    if (isset($_REQUEST["autolisamine"])) {
        if (!empty($_REQUEST["autonr"]) && !empty($_REQUEST["sisenemismass"]) && !preg_match("#[A-z]#", $_REQUEST["sisenemismass"])) {
            $kask = $yhendus->prepare("INSERT INTO koormad (autonr, sisenemismass, lahkumismass) VALUES (?, ?, 0)");
            $kask->bind_param("si", $_REQUEST["autonr"], $_REQUEST["sisenemismass"]);
            $kask->execute();
        }
    }
}