search-event.php

<?php include 'inc/pre.php' ?>
<?php include 'inc/header.php' ?>
<?php $navTitle = "Search Events"; ?>
<?php include 'inc/nav.php' ?>
<?php
include 'inc/country.php';
if (!isset($_SESSION["SESSION_EMAIL"])) {
    header("Location: index.php");
}

$msg = "";
$search_name = "     ";
$search_zip = "     ";
$sname = "";
$sorg = "";
$szip = "";
$scity = "";
$scountry = "";
$sstartDate = "";
$sendDate = "";

try {
    $res_events = select_events($conn, $sname, $sorg, $szip, $scity, $scountry, $sstartDate, $sendDate);
} catch (\Throwable $th) {
    $msg = "<div class='alert alert-danger'>" . $th->getMessage() . "</div>";
}

if (isset($_POST['submit'])) {
    $sname = mysqli_real_escape_string($conn, $_POST['event']);
    $sorg = mysqli_real_escape_string($conn, $_POST['organization']);
    $szip = mysqli_real_escape_string($conn, $_POST['zip']);
    $scity = mysqli_real_escape_string($conn, $_POST['city']);
    $scountry = mysqli_real_escape_string($conn, $_POST['country']);
    $sstartDate = mysqli_real_escape_string($conn, $_POST['startDate']);
    $sendDate = mysqli_real_escape_string($conn, $_POST['endDate']);
    try {
        $res_events = select_events($conn, $sname, $sorg, $szip, $scity, $scountry, $sstartDate, $sendDate);
    } catch (\Throwable $th) {
        $msg = "<div class='alert alert-danger'>" . $th->getMessage() . "</div>";
    }
}

?>

<section class="container h-100">
    <?php include 'inc/top.php' ?>
    <div class="main-container pt-5">
        <?= $msg ?>
        <div class="border border-1 border-solid pt-4 pb-4 position-relative">
            <button class="btn btn-primary position-absolute" data-bs-toggle="modal" data-bs-target="#addFilterModal"
                style="top: -20px; left: 10px">Filters</button>
            <div class="mt-2 ms-5">
                <?php if ($sname != '') { ?>Name of Event:&nbsp;<?= $sname ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($szip != '') { ?>Zip code:&nbsp;<?= $szip ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($sorg != '') { ?>Organization:&nbsp;<?= $sorg ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($scity != '') { ?>City:&nbsp;<?= $scity ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($scountry != '') { ?>Country:&nbsp;<?= $scountry ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($sstartDate != '') { ?>Start Date:&nbsp;<?= $sstartDate ?>&nbsp;&nbsp;&nbsp;<?php } ?>
                <?php if ($sendDate != '') { ?>End Date:&nbsp;<?= $sendDate ?>&nbsp;&nbsp;&nbsp;<?php } ?>
            </div>
            <div class="mt-3">
                <?php $lop = 0;
                if ($res_events->num_rows > 0) {
                    while ($row = $res_events->fetch_assoc()) {
                        $lop = $lop + 1; ?>
                        <div class="member-container <?= $lop % 2 == 1 ? "bg-primary text-white" : ""; ?> ">
                            <div class="member-image cursor-pointer" onclick="gotoMemberDetail(<?= $row['eventnr'] ?>)"><img src="assets/images/events.png" alt=""></div>
                            <div class="member-info">
                                <div>
                                    <?= $row["fullname"] ?>-
                                </div>
                                <div>
                                    <?= $row["zip"] ?>,
                                </div>
                                <div>
                                    <?= $row["city"] ?>,
                                </div>
                                <div>
                                    <?= strtoupper($row["country"]) ?>,
                                </div>
                                <div>
                                    <?= $row["cellphone"] ?>,
                                </div>
                                <div>
                                    <?= $row["begindate"] ?>,
                                </div>
                                <div>
                                    <?= $row["enddate"] ?>
                                </div>
                            </div>
                        </div>
                    <?php }
                } else { ?>
                <?php } ?>
            </div>
        </div>

        <div class="modal fade" id="addFilterModal" tabindex="-1" aria-labelledby="exampleModalLabel"
            aria-hidden="true">
            <div class="modal-dialog">
                <form action="" method="post">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="exampleModalLabel">Add Filters</h5>
                        </div>
                        <div class="modal-body">
                            <div class="row px-3">
                                <div class="col-sm-4">
                                </div>
                                <div class="col-sm-8">
                                    <input type="text" class="form-control mt-3" name="event" placeholder="Event Name">
                                </div>
                            </div>
                            <div class="row px-3">
                                <div class="col-sm-4"></div>
                                <div class="col-sm-8">
                                    <input type="text" class="form-control mt-3" name="organization"
                                        placeholder="Organization">
                                </div>
                            </div>
                            <div class="row px-3">
                                <div class="col-sm-4">
                                    <input type="text" class="form-control mt-3" name="zip" placeholder="Zip">
                                </div>
                                <div class="col-sm-8">
                                    <input type="text" class="form-control mt-3" name="city" placeholder="City">
                                </div>
                            </div>
                            <div class="row px-3">
                                <div class="col-sm-4"></div>
                                <div class="col-sm-8">
                                    <select type="text" class="form-control mt-3" name="country"
                                        onchange="handle_changeCountry(event)" style="padding: 12px;">
                                        <option value="" disabled selected>Select Country</option>
                                        <?php foreach ($countryNames as $countryName) { ?>
                                            <option value="<?= $countryName ?>">
                                                <?= strtoupper(str_replace("_", " ", $countryName)) ?>
                                            </option>
                                        <?php } ?>
                                    </select>
                                </div>
                            </div>
                            <div class="row px-3">
                                <div class="col-sm-4">
                                    <input type="text" id="from" class="form-control mt-3" name="startDate"
                                        placeholder="Start Date">
                                </div>
                                <div class="col-sm-4">
                                    <input type="text" id="to" class="form-control mt-3" name="endDate"
                                        placeholder="End Date">
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer pt-5">
                            <button type="button" class="btn btn-default px-5" onclick="clearHandle()">Clear</button>
                            <button type="submit" name="submit" class="btn btn-default px-5">Search</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>

    </div>
    <script>
        function gotoMemberDetail(eventnr) {
            window.location.href = '<?= DOMAIN . "/event-detail.php?eventnr=" ?>' + eventnr;
        }
    </script>
</section>
<script>
    $(function () {
        var dateFormat = "mm/dd/yy",
            from = $("#from")
                .datepicker({
                    defaultDate: "+1w",
                    changeMonth: true,
                })
                .on("change", function () {
                    to.datepicker("option", "minDate", getDate(this));
                }),
            to = $("#to").datepicker({
                defaultDate: "+1w",
                changeMonth: true,
            })
                .on("change", function () {
                    from.datepicker("option", "maxDate", getDate(this));
                });

        function getDate(element) {
            var date;
            try {
                date = $.datepicker.parseDate(dateFormat, element.value);
            } catch (error) {
                date = null;
            }

            return date;
        }
    });

    function clearHandle() {
        window.location.href = "<?= DOMAIN ?>/search-event.php"
    }   
</script>


<?php include 'inc/footer.php' ?>