| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Admin/Waldo/ |
Upload File : |
<?
// Admiv/Waldo/waldoUpdate.phpinc
#d_On();
d_Line(basename(__FILE__));
$startdate = formValue('startdate');
$enddate = formValue('enddate');
d_Var('$startdate',$startdate);
d_Var('$enddate',$enddate);
$todayDate = date("Y-m-d");
$preset = array();
for ( $week=1; $week<=2; $week++ ) {
$preset[$week] = array();
foreach ( $days as $dayNumber => $day ) {
$preset[$week][$dayNumber] = array();
$preset[$week][$dayNumber]['location'] = formValue('location_'.$week.'_'.$dayNumber);
$preset[$week][$dayNumber]['note'] = formValue('note_'.$week.'_'.$dayNumber);
}
}
d_Var('$preset',$preset);
// Verify startdate.
if ( $startdate ) {
// Check if date is valid.
d_Var("valid_date($startdate)",valid_date($startdate));
if ( valid_date($startdate) ) {
// Date is valid,
d_Line('startdate is valid.','i');
// Check if date is in semester.
if ( $startdate >= $sessionInfo['sessionStart'] && $startdate <= $sessionInfo['sessionEnd'] ) {
// Verify enddate.
if ( $enddate ) {
// Check if date is valid.
d_Var("valid_date($enddate)",valid_date($enddate));
if ( valid_date($enddate) ) {
// Date is valid,
d_Line('enddate is valid.','i');
// Check if date is in semester.
if ( $enddate >= $sessionInfo['sessionStart'] && $enddate <= $sessionInfo['sessionEnd'] ) {
// Check that the enddate if sfter the startdate.
if ( $enddate >= $startdate ) {
if ( $startdate >= $todayDate ) {
$deleteDate = $startdate;
} else {
$deleteDate = $todayDate;
}
// DELETE any calendar entries in range.
$query = "
DELETE
FROM `calendaruser`
WHERE userId = ".$_SESSION['userId']."
AND userDate >= '".query_safe($deleteDate)."'
AND userDate <= '".query_safe($enddate)."'
";
d_Var('calendaruserDelete',$query,'q');
$calendaruserDelete = query_do($query);
@d_Var('$calendaruserDelete',$calendaruserDelete);
// Load Walso.
$firstweek = date('W', strtotime($startdate));
d_Var('$firstweek',$firstweek);
$currentDate = $startdate;
$endloop = 0;
while ( $endloop < 366 && $currentDate <= $enddate ) {
d_Var('$currentDate',$currentDate,'/');
// Calculate day number from date.
$dayIndex = date('w', strtotime($currentDate));
d_Var('$dayIndex '.date('l', strtotime($currentDate)),$dayIndex);
if ( $currentDate >= $deleteDate ) {
if ( $dayIndex >=1 && $dayIndex <= 5 ) {
// This is M-F.
// Calculate week from date.
$week = date('W', strtotime($currentDate)) - $firstweek; if ( $dayIndex == 0 ) $week++;
d_Var('$week',$week);
#$evenweek = $week % 2;
#d_Var('$evenweek',$evenweek);
#$oddweek = 1 - $evenweek;
#d_Var('$oddweek',$oddweek);
$weekIndex = $week % 2 + 1;
d_Var('$weekIndex',$weekIndex);
if ( $preset[$weekIndex][$dayIndex]['location'] != '' || $preset[$weekIndex][$dayIndex]['note'] != '' ) {
// INSERT date.
$query = "
INSERT
INTO `calendaruser` (
userId,
userYRTR,
userDate,
userLocation,
userNote
) VALUES (
".$_SESSION['userId'].",
'".query_safe($_SESSION['YRTR']['User'])."',
'".query_safe($currentDate)."',
'".query_safe($preset[$weekIndex][$dayIndex]['location'])."',
'".query_safe($preset[$weekIndex][$dayIndex]['note'])."'
)
";
d_Var('calendaruserInsert',$query,'q');
$calendaruserInsert = query_do($query);
@d_Var('$calendaruserInsert',$calendaruserInsert);
}
}
}
$currentDate = date('Y-m-d', strtotime('+1 day', strtotime($currentDate)));
$endloop++;
}
// Display notice.
if ( $startdate == $startdate && $startdate == $startdate ) {
displayNotice('Where\'s Waldo for full semester loaded.');
} else {
displayNotice('Where\'s Waldo from '.$startdate.' to '.$enddate.' loaded.');
}
// Clear form variables.
$startdate = '';
$enddate = '';
unset($preset);
} else {
// enddate is before startdate.
displayError('The end date ('.$enddate.') is before the start date ('.$startdate.').');
}
} else {
// Date out of semester.
displayError('The end date ('.$enddate.') is not in the '.$sessionInfo['sessionName'].'('.$sessionInfo['sessionStart'].' - '.$sessionInfo['sessionEnd'].').');
}
} else {
// Date is not valid.
displayError('The end date ('.$enddate.') is not valid.');
}
} else {
// Date is empty.
displayError('The end date is empty.');
}
} else {
// Date out of semester.
displayError('The start date ('.$startdate.') is not in the '.$sessionInfo['sessionName'].'('.$sessionInfo['sessionStart'].' - '.$sessionInfo['sessionEnd'].').');
}
} else {
// Date is not valid.
displayError('The start date ('.$startdate.') is not valid.');
}
} else {
// Date is empty.
displayError('The start date is empty.');
}
#d_Off();
?>