?>
<h1><?php
echo $media->{'screensaver-events-title'};
?>
</h1>
<?php
}
?>
<ul class="screensaver-events">
<?php
foreach ($json as $item) {
?>
<li>
<span class="event-date"><?php
echo dateToDay($item->Date);
?>
kl. <?php
echo $item->Time;
?>
</span>
<span class="event-name"><?php
echo $item->Name;
?>
</span>
<span class="event-location"><?php
echo $item->Location;
?>
</span>
</li>
<?php
if (empty($creator)) {
header("Location:requestForm.php?msg='Creator cannot be Empty'");
die;
}
if ($_POST['concernedPEmail'] == '') {
$concernedPName = $_POST["creator"];
$concernedPEmail = $_POST["creatorEmail"];
$concernedPPhone = $_POST["creatorPhone"];
}
$eventDays = "";
if (isset($_POST["day"])) {
foreach ($_POST["day"] as $day) {
$eventDays = $eventDays . $day . ",";
}
} else {
$eventDays = (string) ((int) dateToDay($eventStartDate) + 1);
}
$query = "INSERT INTO Requests(reqNo, hash, creator, creatorEmail, creatorPhone, concernedPName, concernedPEmail, concernedPPhone, appStatus, reqGId, reqDate, eventStartDate, eventEndDate, eventStartTime, eventEndTime, eventTitle, eventDesc, eventDays,concernedAdmin, room, reqType) VALUES(\n\t'',\n\t'" . $hash . "',\n\t'" . $creator . "',\n\t'" . $creatorEmail . "',\n\t'" . $creatorPhone . "',\n\t'" . $concernedPName . "',\n\t'" . $concernedPEmail . "',\n\t'" . $concernedPPhone . "',\n\t'" . $appStatus . "',\n\t'" . $reqGId . "',\n\t'" . $reqDate . "',\n\t'" . $eventStartDate . "',\n\t'" . $eventEndDate . "',\n\t'" . $eventStartTime . "',\n\t'" . $eventEndTime . "',\n\t'" . $eventTitle . "',\n\t'" . $eventDesc . "',\n\t'" . $eventDays . "',\n\t'" . $concernedAdmin . "',\n\t'" . $room . "',\n\t'" . $reqType . "'\n);";
$result = instanceClash($eventStartDate, $eventEndDate, $eventStartTime, $eventEndTime, $room);
if ($result) {
echo "Sorry! your request clashes with the following events:";
$table = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$table[] = $row;
}
print_r($table);
} else {
//Adding 2 Requests Table
if (execute($query)) {
echo "Successfull";
$reqNo = getId($hash);
$tabindex = 0;
//Header
get_header();
//Get json stuff
$json = json_decode(file_get_contents('http://www.helsingborg.se/wp-content/plugins/helsingborg-widgets/helsingborg-event/json.php?count=6'));
//Loop
if (!empty($json) && count($json)) {
echo '<div class="event-list">';
foreach ($json as $event) {
$tabindex++;
echo '<a href="#" tabindex="' . $tabindex . '" class="event-item">';
echo '<span class="event-inner">';
//Image
if (isset($event->ImagePath) && $event->ImagePath != '') {
echo '<span class="event-image" style="background-image:url(\'' . $event->ImagePath . '\');"></span>';
} else {
echo '<span class="event-image image-missing" data-missing-image="' . __("Bild saknas") . '"></span>';
}
echo '<span class="index-container">';
echo ' <span class="index-caption"><span>' . $event->Name . '</span></span>';
echo ' <span class="index-description">' . wpautop(strlen($event->Description) > 703 ? substr($event->Description, 0, 700) . '...' : $event->Description, true) . '</span>';
echo ' <span class="index-date">' . dateToDay($event->Date) . ' kl. ' . $event->Time . '</span>';
echo ' <span class="index-place">' . $event->Location . '</span>';
echo '</span>';
echo '</span>';
echo '</a>';
}
echo '</div>';
echo '<div id="event-backdrop" style="display: none;"></div>';
}
get_footer();
function weeklyRequestToInstance($startDate, $endDate, $arrayOfDays)
{
/*
* Foreach arrayOfDays where 1-Sunday and 7-Saturday, call addWeeklyRequest
* with minor adjustments. Adjustments being:
* Find the first Sunday on or after the startDate, and pass its date as the
* startDate to addWeeklyRequest. Repeat for every day of week in arrayOfDays
*/
$events = array();
foreach ($arrayOfDays as $day) {
$day = (int) $day;
//Find the first n-day on or after the start date
$day = ($day - 1) % 7;
//Input convention changed to PHP convention
$day = (string) $day;
$dateForDay = $startDate;
while (dateToDay($dateForDay) != $day) {
$dateForDay = date("Y-m-d", strtotime($dateForDay . "+ 1 day"));
}
// echo "\n\n**".$dateForDay."\n";
$events = array_merge($events, addWeeklyRequest($dateForDay, $endDate));
}
return $events;
}
