' />
prefix."ap_events"; $TimeOffSQL = "select * from `$EventTable` where `id` = '$update_id'"; $TimeOff = $wpdb->get_row($TimeOffSQL, OBJECT); ?>
:
allday) echo "checked=checked"; ?> />
:
:
:
">
:
:
repeat == 'N') echo "selected=selected"; ?> >
repeat == 'PD') echo "selected=selected"; ?> >
repeat == 'D') echo "selected=selected"; ?> >
repeat == 'W') echo "selected=selected"; ?> >
repeat == 'BW') echo "selected=selected"; ?> >
repeat == 'M') echo "selected=selected"; ?> >
:
repeat == 'PD' || $TimeOff->repeat == 'D' ) { $diff = ( strtotime($TimeOff->end_date) - strtotime($TimeOff->start_date) ) /60/60/24; $diff = $diff + 1; } if($TimeOff->repeat == 'W') { $diff = ( strtotime($TimeOff->end_date) - strtotime($TimeOff->start_date) ) /60/60/24/7; $diff = $diff + 1; } if($TimeOff->repeat == 'BW') { $diff = ( strtotime($TimeOff->end_date) - strtotime($TimeOff->start_date) ) /60/60/24/7; } if($TimeOff->repeat == 'M') { $diff = ( strtotime($TimeOff->end_date) - strtotime($TimeOff->start_date) ) /60/60/24/31; } ?>
:
:
:
:
:
:
<?php echo $TimeOff->note; ?>
alert("Sorry, your nonce did not verify.");'; return false; } $update_id = $_POST['update_id']; $FromBack = $_POST['fromback']; // all day event if(isset($_POST['allday'])) { $allday = 1; $start_time = '12:00 AM'; $end_time = '11:59 PM'; } else { $allday = 0; $start_time = $_POST['start_time']; $end_time = $_POST['end_time']; } $name = $_POST['name']; $repeat = $_POST['repeat']; $start_date = $_POST['event_date']; $start_date = date("Y-m-d", strtotime($start_date)); //convert format //not repeat if($repeat == 'N') { $end_date = date("Y-m-d", strtotime($start_date)); //convert format } //particular day if($repeat == 'PD') { $start_date = $_POST['start_date']; $start_date = date("Y-m-d", strtotime($start_date)); //convert format $end_date = $_POST['end_date']; $end_date = date("Y-m-d", strtotime($end_date)); //convert format } //daily event will be 90 days if($repeat == 'D') { $repeat_days = $_POST['re_days']; $repeat_days = $repeat_days - 1; $end_date = strtotime($start_date); $end_date = date("Y-m-d", strtotime("+$repeat_days days", $end_date)); //add 3 month } //weekly event add 1 week if($repeat == 'W') { $repeat_weeks = $_POST['re_weeks']; $end_date = strtotime($start_date); $end_date = date("Y-m-d", strtotime("+$repeat_weeks week", $end_date)); //add 1 week } //bi-weekly event multiply 2 if($repeat == 'BW') { $repeat_weeks = $_POST['re_biweeks']; $end_date = strtotime($start_date); $repeat_weeks = $repeat_weeks * 2; $end_date = date("Y-m-d", strtotime("+$repeat_weeks week", $end_date)); //add 1 week } //monthly event add 1 month if($repeat == 'M') { $repeat_months = $_POST['re_months'] + 1; $end_date = strtotime($start_date); $end_date = date("Y-m-d", strtotime("+$repeat_months months", $end_date)); //add 1 month } $note = $_POST['note']; $status = "Up-Coming"; global $wpdb; $EventTable = $wpdb->prefix."ap_events"; $EventUpdateSQL = "UPDATE `$EventTable` SET `name` = '$name', `allday` = '$allday', `start_time` = '$start_time', `end_time` = '$end_time', `repeat` = '$repeat', `start_date` = '$start_date', `end_date` = '$end_date', `note` = '$note', `status`= '$status' WHERE `id` ='$update_id';"; if($wpdb->query($EventUpdateSQL)) { } if($FromBack) { echo ""; echo ""; } else { echo ""; echo ""; } } ?> prefix."ap_events"; $DelId = $_GET['delete-timeoff']; $TimeOffDeleteSQL = "delete from `$EventTable` where `id` = '$DelId'"; if($wpdb->query($TimeOffDeleteSQL)) { echo ""; echo ""; } else { echo ""; } } ?>