showUnapprovedEvents.php

<?php

require_once('_php/config.php');

session_start();

$_SESSION['faveReturn'] = substr($_SERVER[REQUEST_URI], 1);

if (isset($_SESSION['dateFrom'])) {
    $dateFrom = $_SESSION['dateFrom'];
} else {
    $dateFrom = "2000-00-00 00:00:00";
}

if (isset($_SESSION['dateTo'])) {
    $dateTo = $_SESSION['dateTo'];
} else {
    $dateTo = "2020-12-31 23:59:59";
}

if (isset($_SESSION['selectedTags'])) {
    // Query for events with selected tags
    $selectedTags = implode(',', $_SESSION['selectedTags']);
    $event_query = "
        SELECT *
        FROM event_tags
        LEFT JOIN events ON events.EventID = event_tags.EventID
        AND event_tags.TagID IN ( $selectedTags )
        AND events.Approved IS NULL
        ORDER BY Start ASC";
} else {
    // Query for all events
    $event_query = "
        SELECT *
        FROM events
        WHERE Approved IS NULL
        ORDER BY Start ASC";
}

$result = $connection->query($event_query);

if($result->connect_errno > 0){
    die('Unable to connect to database [' . $result->connect_error . ']');
}

if(!$result){
    echo "no result";
} else if(mysqli_num_rows($result) == 0) {
    echo '<h4>No Events Pending Approval</h4>';
} else {

    echo '<div class = "accordion">';

    while ($row = $result->fetch_assoc()) {
        
        // Format dates
        $start = strtotime($row['Start']);
        $startDate = date('l jS F Y', $start);
        $startTime = date('H:i', $start);
        $end = date_add($start, date_interval_create_from_date_string($row['Duration'] . " hours"));
        $endDate = date('l jS F Y', $end);
        $endTime = date('H:i', $end); 

        /* Event Summary Section */
        echo    '<section class = "eventSummarySection">';
        // Event title
        echo    '<h3>' . $row['Name'] . '</h3>'; 
        // Event image
        echo    '<img src=' . $row['ImageLink'] . ' alt = "Img1" class= "eventImage">'; 


        // Add the approve button here to replace favourites
        echo    '<form id="approveForm" action="_php/handleApprove.php" method="post" class="approvalButtons">';
        echo    '   <input name="EventID" type="hidden" value="' . $row['EventID'] . '"></input>';
        echo    '   <button name="approvalBtn" type="submit" form="approveForm" value="approve" class="eventApprovalButton"><div class = "approvalButtonText">Approve</div></button>';
        echo    '   <button name="approvalBtn" type="submit" form="approveForm" value="reject" class="eventApprovalButton"><div class = "approvalButtonText">Reject</div></button>';
        echo    '</form>';


        // Event summary details
        echo    '<ul class="eventSummaryDetails">';
        echo    '    <li>' . $row['Speaker'] . '</li>';
        echo    '    <li>' . $row['Location'] . '</li>';
        echo    '    <li><div class="address">' . $row['Postcode'] . '</div></li>';
        echo    '    <li>' . $startTime . '</li>';
        echo    '    <li>' . $startDate . '</li>';
        echo    '</ul>';

        echo    '</section>';

        /* Further Details Section */

        $price = ($row['Cost'] == 0) ? 'Free' : '£' . $row['Cost'];
        echo    '<div class="furtherDetails">';
        // Price
        echo    '<p>' . $price . '</p>';
        echo    '<p>' . $row['Description'] . '</p>';
        
        // Tags 
        
        $current_id = $row['EventID'];
        $tag_query = "SELECT * FROM event_tags JOIN tags ON event_tags.TagID = tags.TagID
                        WHERE event_tags.EventID = " . $current_id;
        
        $tag_result = $connection->query($tag_query);
        $tag_names = array();
        foreach ($tag_result as $res) {
            array_push($tag_names, $res['TagName']);
        }
        if (!(sizeof($tag_names) == 0)) {
            $tag_list = "Tags: " .  implode(", ", $tag_names);
        } else {
            $tag_list = "No tags";
        }
        
        echo    '<p>' . $tag_list . '</p>';
        // Link
        echo    '<p>
                 <a href=' . $row['InfoLink'] . ' class="linkToEventSite">More information</a>
                 </p>';
        // Map
        echo    '<div class="map"></div>';
        echo    '</div>';

    }

    echo '</div>';

}

?>