<?php

$page_name = "exports";
$permission = "all";

include "public/header.php";
include "php/database.php";
?>

<div class="breadcrumb">
    <h1 class="mr-2">Esportazioni</h1>
    <ul>
        <li>Export timbrature, permessi e trasferte</li>
    </ul>
</div>
<div class="separator-breadcrumb border-top"></div>

<div class="row">
    <div class="col-lg-12 col-md-12">
        <div class="card mb-4">
            <div class="card-body">
                <div class="row justify-content-md-center">
                    <div class="col-md-auto form-group mb-3">
                        <label for="picker1">Utente</label>
                        <select class="form-control form-control-rounded" id="user">
                            <?php
                            if ($_SESSION["role"] == "Admin") {
                                echo "<option value='all' selected>Tutti</option>";

                                $sql = "SELECT * FROM users WHERE enable = 1 AND attendance = 1";
                                $result = mysqli_query($con, $sql);
                                while ($row = mysqli_fetch_assoc($result)) {
                                    echo "<option value='" . $row["id"] . "'>" . $row["name"] . " " . $row["surname"] . "</option>";
                                }
                            } else {
                                echo "<option value='" . $_SESSION["id"] . "' selected>" . $_SESSION["name"] . " " . $_SESSION["surname"] . "</option>";
                            }
                            ?>
                        </select>
                    </div>
                    <div class="col-md-auto form-group mb-3">
                        <label for="picker1">Origine</label>
                        <select class="form-control form-control-rounded" id="source">
                            <option value="" selected>-- Seleziona --</option>
                            <option value="timbrature">Timbrature</option>
                            <option value="permessi">Permessi</option>
                            <option value="trasferte">Trasferte</option>
                        </select>
                    </div>
                    <div class="col-md-auto form-group mb-3">
                        <label for="picker3">Data inizio</label>
                        <input type="date" class="form-control form-control-rounded" id="start_date" placeholder="gg/mm/aaaa">
                    </div>
                    <div class="col-md-auto form-group mb-3">
                        <label for="picker3">Data fine</label>
                        <input type="date" class="form-control form-control-rounded" id="end_date" placeholder="gg/mm/aaaa">
                    </div>
                    <div class="col-md-auto">
                        <button class="btn btn-xl btn-primary m-1" type="button" onclick="searchExport()" id="search_button">Cerca</button>
                    </div>
                    <div class="col-md-auto">
                        <div class="spinner spinner-primary mr-3" id="search_loader" style="display: none;"></div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-lg-12 col-md-12">
        <div class="card mb-4" id="search_result_content">

        </div>
    </div>
</div>

<script type="text/javascript">

</script>

<script src="js/exports.js"></script>
<?php include "public/footer.php" ?>