<?php
ini_set('error_reporting', E_ERROR | E_WARNING | E_PARSE | E_NOTICE | E_STRICT | E_DEPRECATED);
ini_set('display_errors', true);
require_once ("inc/header.php");

date_default_timezone_set('Europe/Copenhagen');
$start = new DateTime($_POST['start-date']);
$end = new DateTime($_POST['end-date']);
$activity = $_POST['activity'];
$duration = $start->diff($end);

$_SESSION['start'] = $start;
$_SESSION['end'] = $end;
$_SESSION['activity'] = $activity;

$result = $dbcon->query("
SELECT DISTINCT
destinations.name AS destination_name
FROM mappings
INNER JOIN packages ON
mappings.packageid = packages.id
INNER JOIN packageimages ON
packages.id = packageimages.packageid
INNER JOIN destinations ON
packages.destinationid = destinations.id
INNER JOIN locals ON
mappings.localid = locals.id
WHERE
packages.activity = '{$activity}' AND
packages.duration > '{$duration->d}'-3 AND
packages.duration < '{$duration->d}'+3
");

if (!$result) {
    $msg = "<div class='alert alert-danger'>The search returned 0 results, try another date range or activity.</div>";
}

$destinationslist = $result->fetch_assoc();

$result->close();

?>

<div class="container" id="results">
    <h1>Search results</h1>
    <div class="row">
        <?php
        if (isset($msg)) {
            echo $msg;
        }
        ?>


            <?php
                foreach ($destinationslist as $destination_name) {
                    echo    "<h2>$destination_name</h2>";
                    echo    "<div class='card-deck-wrapper'>
                                <div class='card-deck'>";
                                    $result = $dbcon->query("
SELECT
packages.name AS package_name,
destinations.name AS destination_name,
locals.firstname AS firstname,
locals.lastname AS lastname,
packages.price AS price,
packages.info AS info,
packageimages.imagepath AS packageimage
FROM mappings
INNER JOIN packages ON
mappings.packageid = packages.id
INNER JOIN packageimages ON
packages.id = packageimages.packageid
INNER JOIN destinations ON
packages.destinationid = destinations.id
INNER JOIN locals ON
mappings.localid = locals.id;");


                    while ($row = $result->fetch_object()){
                    echo "<div class='card'>
                            <img class='card-img-top' src='img/$row->packageimage.png' />
                            <div class='dest-caption'>
                                <h2><span>$row->destination_name</span></h2>
                                <p><span>$row->price DKK</span></p>
                            </div>
                            <div class='card-block'>
                                <h2 class='card-title'>$row->package_name</h2>
                                <p class='card-text'>$row->info</p>
                            </div>
                        </div>";
                        }
                        echo    "</div>
                            </div>";

                }

            ?>

    </div>
</div>

<?php
require_once ("inc/footer.php");
?>