\n";
// calculate previous month
$prevMonth = $monthNo - 1;
// if previous month number is 0, reset to 12 and decrement year
if ($prevMonth == 0) {
$prevMonth = 12;
$prevYear = $year - 1;
}
// otherwise, keep same year
else {
$prevYear = $year;
}
// calculate next month
$nextMonth = $monthNo + 1;
// if next month number is 13, reset to 1 and increment year
if ($nextMonth == 13) {
$nextMonth = 1;
$nextYear = $year + 1;
}
// otherwise, keep same year
else {
$nextYear = $year;
}
// print links for previous and next months
if ($showPastEvents == 0 && $year == date("Y") && $monthNo == date("n")) {
echo "
\n";
echo "« | » $monthName $year
\n"; } else { echo "« | » $monthName $year
\n"; } // get buildings $get_buildings = mysqli_query($link, "select * from building order by name"); $building = $get_buildings->fetch_all(MYSQLI_ASSOC); if (count($building) > 0) { $get_building_colors = mysqli_query($link, "select building_id, color from building"); $building_colors = $get_building_colors->fetch_all(MYSQLI_ASSOC); for ($b = 0; $b < count($building_colors); $b++) { $colors[$building_colors[$b]['building_id']] = $building_colors[$b]['color']; } echo "\n"; } echo "\n";
if (isset($_POST['building'])) {
$building_query = " and (";
for ($i = 0; $i < count($_POST['building']); $i++) {
$building_query .= "building_id = " . $_POST['building'][$i];
if ($i != (count($_POST['building']) - 1)) {
$building_query .= " or ";
}
}
$building_query .= ")";
}
if (isset($_POST['room'])) {
$room_query = " and (";
for ($i = 0; $i < count($_POST['room']); $i++) {
$room_query .= "room_id = " . $_POST['room'][$i];
if ($i != (count($_POST['room']) - 1)) {
$room_query .= " or ";
}
}
$room_query .= ")";
}
if (isset($_POST['event_type'])) {
$event_type_query = " and (";
for ($i = 0; $i < count($_POST['event_type']); $i++) {
$event_type_query .= "event_type_id = " . $_POST['event_type'][$i];
if ($i != (count($_POST['event_type']) - 1)) {
$event_type_query .= " or ";
}
}
$event_type_query .= ")";
}
// get events occurring this month
$current_data = mysqli_query($link, "select event_id, date, building_id, room_id, title, time_format(time_begins, '%l:%i %p') as formatted_time, canceled from calendar where month(date) = $monthNo and year(date) = $year $event_type_query $building_query $room_query and public = 'Y' order by date, time_begins");
$events = $current_data->fetch_all(MYSQLI_ASSOC);
// get number of events
$noEvents = count($events);
// print calendar table head
echo "\n";
echo "\n";
echo "
\n";
echo "
\n";
}
//
// PRINT DAILY VIEW
//
if (isset($_GET['view']) && isset($_GET['date'])) {
echo "\n";
echo "| Sunday | \n"; echo "\tMonday | \n"; echo "\tTuesday | \n"; echo "\tWednesday | \n"; echo "\tThursday | \n"; echo "\tFriday | \n"; echo "\tSaturday | \n"; echo "
|---|---|---|---|---|---|---|
| \n"; } } // if today is Sun, start a new week if ($day == "Sun") { echo " | ||||||
| \n"; } elseif ($dateToCheck < $today) { echo "\t | \n"; } else { echo "\t | \n";
}
echo "$i \n"; for ($n = 0; $n < count($keys); $n++) { if ($events[$keys[$n]]['canceled'] == "N") { $css_event_class = "class=\"event_link\""; } else { $css_event_class = "class=\"event_canceled_link\""; } if ($use_room_colors) { echo "⬤ " . $events[$keys[$n]]['formatted_time'] . ": " . $events[$keys[$n]]['title'] . " \n"; } else { echo "⬤ " . $events[$keys[$n]]['formatted_time'] . ": " . $events[$keys[$n]]['title'] . " \n"; } } echo "\t | \n";
}
// otherwise, print an empty table cell
else {
if ($dateToCheck == $today) {
echo "\t$i | \n"; } else { echo "\t$i | \n"; } } // if today is Sat, end this week if ($day == "Sat") { echo "\n"; } // end this week echo "\n"; } } // finish printing table echo " |
\n";
// get project details
$get_projects = mysqli_query($link, "select event_id, title, date, time_format(time_begins, '%l:%i %p') as formatted_time_begins, time_format(time_ends, '%l:%i %p') as formatted_time_ends, calendar.building_id, building.name as building_name, room.name as room_name from calendar inner join building on calendar.building_id = building.building_id inner join room on calendar.room_id = room.room_id where date = '" . $_REQUEST['date'] . "' and public = 'Y' order by time_begins");
$project = $get_projects->fetch_all(MYSQLI_ASSOC);
$date = new DateTime($_REQUEST['date']);
$today = $date->format('D, M j');
$date_parts = explode("-", $_REQUEST['date']);
$date->modify('-1 day');
$previousDate = $date->format('Y-m-d');
$date->modify('+2 days');
$nextDate = $date->format('Y-m-d');
echo "\n";
echo "
\n";
}
echo "
\n";
}
//
// MAIL EVENT INFORMATION
//
if (isset($_POST['mail_event_info'])) {
$get_event = mysqli_query($link, "select *, date, file, submitted_at, submitted_by, event_type_id, calendar.title, description, user.username, date_format(date, '%Y%m%d') as date_url, date_format(date, '%W, %M %e, %Y') as formatted_date, time_format(time_begins, '%l:%i %p') as formatted_time_begins, time_format(time_ends, '%l:%i %p') as formatted_time_ends, user.username as username, user.name as user_name, calendar.building_id, building.name as building_name, calendar.room_id, room.name as room_name from calendar inner join user on calendar.submitted_by = user.user_id inner join building on calendar.building_id = building.building_id inner join room on calendar.room_id = room.room_id where event_id = " . $_REQUEST['event_id'] . " and public = 'Y'");
$event = mysqli_fetch_array($get_event, MYSQLI_ASSOC);
// mail success message to couple
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$get_general_contact = mysqli_query($link, "select name, email from user inner join settings on settings.contact_general = user.user_id where sacrament = 'M'");
$general_contact = mysqli_fetch_array($get_general_contact, MYSQLI_ASSOC);
$from = $general_contact['email'];
// create email headers
$headers .= 'From: '.$from."\r\n".
'Reply-To: '.$from."\r\n" .
'X-Mailer: PHP/' . phpversion();
// compose a simple HTML email message
$message = "\n\n";
$message .= "[ Monthly View ]
\n"; echo "«" . " | » " . $today . "
\n"; if (count($project) == 0) { echo "There are no events today.
\n"; } else { echo "| Start Time | \n"; echo "\tEnd Time | \n"; echo "\tTitle | \n"; echo "\tBuilding | \n"; echo "\tRoom | \n"; echo "
|---|---|---|---|---|
| " . $project[$i]['formatted_time_begins'] . " | \n"; echo "\t" . $project[$i]['formatted_time_ends'] . " | \n"; echo "\t" . $project[$i]['title'] . " | \n"; echo "\t" . $project[$i]['building_name'] . " | \n"; echo "\t" . $project[$i]['room_name'] . " | \n"; echo "
" . $event['title'] . "
\n"; // create email subject if ($_POST['name'] != "") { $message .= "" . $_POST['name'] . " requested that you receive information about this event"; if ($_POST['message'] != "") { $message .= ":
\n"; $message .= "" . $_POST['message'] . "
\n"; } else { $message .= ".\n"; } } $message .= "" . $event['formatted_date'] . "
\n"; $message .= "" . $event['formatted_time_begins'] . " - " . $event['formatted_time_ends'] . "
\n"; $message .= "| Building | \n"; $message .= "\t" . $event['building_name'] . " | \n"; $message .= "
| Room | \n"; $message .= "\t" . $event['room_name'] . " | \n"; $message .= "
| Funeral Information | \n"; $message .= "|
|---|---|
| Decedent | \n"; $message .= "\t" . $funeral['decedent_name'] . " | \n"; $message .= "
Christ the King Church • 200 Windsor Avenue, Haddonfield, NJ 08033 • 856-429-1600
\n"; $message .= "\n"; $to = $_POST['recipient_email']; // create email subject if ($_POST['name'] == "") { $subject = "Check out " . $event['title'] . " at " . $parish_name; } else { $subject = $_POST['recipient_name'] . ", check out " . $event['title'] . " at " . $parish_name; } echo "\n"; echo "\n";
if (mail($to, $subject, $message, $headers)) {
echo "\n";
echo "
\n";
}
//
// ADD EVENT FEEDBACK
//
if (isset($_POST['post_review'])) {
echo "\n";
echo "We emailed $to with information about this event.
\n"; $event_id = $_POST['event_id']; // increment "mail" counter column $increment_views_counter = mysqli_query($link, "update calendar set mail = mail + 1 where event_id = " .$_REQUEST['event_id']); } else { echo "\n"; echo "There was an error emailing $to.
\n"; } echo "\n";
$content = mysqli_real_escape_string($link, $_POST['content']);
$add_review = mysqli_query($link, "insert into review_general (event_id, submitted_at, name, email, content, convenient_time, good_location, preparedness, good_pace, good_use_of_time, will_attend_again, benefits_prayer, benefits_relationship_with_christ) values(" . $_POST['event_id'] . ", now(), '" . $_POST['name'] . "', '" . $_POST['email'] . "', '" . $content . "', '" . $_POST['convenient_time'] . "', '" . $_POST['good_location'] . "', '" . $_POST['preparedness'] . "', '" . $_POST['good_pace'] . "', '" . $_POST['good_use_of_time'] . "', '" . $_POST['will_attend_again'] . "', '" . $_POST['benefits_prayer'] . "', '" . $_POST['benefits_relationship_with_christ'] . "')");
if (!isset($_POST['anonymous']) && ($_POST['name'] == "" || !filter_var($_POST['email'], FILTER_VALIDATE_EMAIL))) {
echo "
\n";
}
//
// LIST DETAILS FOR A SINGLE EVENT
//
if (isset($_GET['view']) && (isset($_REQUEST['event_id']) || isset($event_id))) {
echo "Sorry, we do not allow anonymous feedback. You must provide your name and email address. We will respond to your email in a timely fashion.
\n"; } else { if ($add_review) { echo "\n"; echo "Your feedback has been posted.
\n"; $event_id = $_POST['event_id']; } else { echo "\n"; echo "There was an error posting your feedback.
\n"; } } echo "\n";
require("left.inc");
echo "
\n";
echo "\n";
// get project details
$get_event = mysqli_query($link, "select date, file, submitted_at, submitted_by, event_type_id, calendar.title, description, canceled, date_format(canceled_at, '%l:%i %p on %W, %M %e') as formatted_canceled_date, user.username, date_format(date, '%Y%m%d') as date_url, date_format(date, '%W, %M %e, %Y') as formatted_date, time_format(time_begins, '%l:%i %p') as formatted_time_begins, time_format(time_ends, '%l:%i %p') as formatted_time_ends, time_format(convert_tz(time_begins, 'US/Eastern','UTC'), '%H%i00') as time_begins_url, time_format(convert_tz(time_ends, 'US/Eastern','UTC'), '%H%i00') as time_ends_url, user.username as username, user.name as user_name, calendar.building_id, building.name as building_name, calendar.room_id, room.name as room_name, unix_timestamp(concat(date, ' ', time_begins)) as unix_timestamp from calendar inner join user on calendar.submitted_by = user.user_id inner join building on calendar.building_id = building.building_id inner join room on calendar.room_id = room.room_id where event_id = " . $_REQUEST['event_id'] . " and public = 'Y'");
if ($get_event->num_rows == 0) {
echo "\n";
echo "
\n";
if ($event['description'] != "") {
echo "
\n";
}
//
// PRINT MAIL EVENT INFORMATION FORM
//
if (isset($_REQUEST['mail'])) {
$get_event = mysqli_query($link, "select event_type_id, calendar.title, date_format(date, '%W, %M %e, %Y') as formatted_date, time_format(time_begins, '%l:%i %p') as formatted_time_begins, time_format(time_ends, '%l:%i %p') as formatted_time_ends, building.name as building_name, room.name as room_name from calendar inner join building on calendar.building_id = building.building_id inner join room on calendar.room_id = room.room_id where event_id = " . $_REQUEST['event_id'] . " and public = 'Y'");
$event = $get_event->fetch_assoc();
echo "\n";
echo "Error
\n"; echo "There is no such event.
\n"; } else { $event = $get_event->fetch_assoc(); // increment "views" counter column $increment_views_counter = mysqli_query($link, "update calendar set views = views + 1 where event_id = " . $_REQUEST['event_id']); $date_parts = explode("-", $event['date']); $title_url = urlencode($event['title']); $dates = $event['date_url'] . "T" . $event['time_begins_url'] . "Z%2F" . $event['date_url'] . "T" . $event['time_ends_url'] . "Z"; echo "\n";
echo "![\"Monthly](\"" "\\"Monthly")
\n";
echo "\n";
if ($event['event_type_id'] == 3) {
echo "\n";
}
else {
echo "\n";
}
}
// include "leave feedback" link
else {
echo "\n";
}
echo "
\n";
echo "Calendar
\n"; echo "Event Details
\n"; // include "remind me" link if (time() < $event['unix_timestamp']) { echo "" . $event['title'] . "
\n"; if ($event['canceled'] == "Y") { echo "This event was canceled at " . $event['formatted_canceled_date'] . "
\n"; } echo "" . $event['formatted_date'] . "
\n"; echo "" . $event['formatted_time_begins'] . " - " . $event['formatted_time_ends'] . "
\n"; echo "| Building | \n"; echo "\t" . $event['building_name'] . " | \n"; echo "
| Room | \n"; echo "\t" . $event['room_name'] . " | \n"; echo "
| Flyer (PDF) | \n"; echo "\tView | \n"; echo "
| Funeral Information | \n"; echo "|
|---|---|
| Decedent | \n"; echo "\t" . $funeral['decedent_name'] . " | \n"; echo "
Description
\n"; echo "" . $event['description'] . "
\n"; } if (substr(strrchr($event['file'], '.'),1) == "png" || substr(strrchr($event['file'], '.'),1) == "jpg") { echo "" . $label[$i]['name'] . "
\n"; } } if (time() > $event['unix_timestamp']) { echo "We value feedback. Please share with us about this event!
\n"; } echo "![](\"https://www.google.com/calendar/images/ext/gc_button1_en.gif\")
\n";
echo "\n";
echo "\n";
echo "
\n";
}
//
// PRINT EVENT FEEDBACK FORM
//
if (isset($_REQUEST['feedback'])) {
$get_event = mysqli_query($link, "select event_type_id, calendar.title, date_format(date, '%W, %M %e, %Y') as formatted_date, time_format(time_begins, '%l:%i %p') as formatted_time_begins, time_format(time_ends, '%l:%i %p') as formatted_time_ends, building.name as building_name, room.name as room_name from calendar inner join building on calendar.building_id = building.building_id inner join room on calendar.room_id = room.room_id where event_id = " . $_REQUEST['event_id'] . " and public = 'Y'");
$event = $get_event->fetch_assoc();
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "\n";
echo "
\n";
echo "The location was clean and comfortable.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "The organizer(s) were well prepared.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "The event proceeded at a good pace.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "The event was a good use of my time.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "I will likely attend similar events in the future.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "The event will benefit my prayer life.
\n"; echo $review_table; echo "\t\n";
echo "
\n";
echo "