$row[] = $aRow[$i]; } $data['aaData'][] = $row; } break; case 'save_incomming': $incom_id_check = $_REQUEST['id_h']; if ($incom_id_check == '') { Addincomming($c_date, $id_p, $phone, $person_name, $type, $results_id, $information_category_id, $information_sub_category_id, $content_id, $product_id, $forward_id, $connect, $results_comment, $content, $task_type_id, $task_department_id, $persons_id, $comment, $call_vote, $source_id); } else { Saveincomming($c_date, $id_p, $phone, $person_name, $type, $results_id, $information_category_id, $information_sub_category_id, $content_id, $product_id, $forward_id, $connect, $results_comment, $content, $task_type_id, $task_department_id, $persons_id, $comment, $call_vote, $source_id); } break; case 'send_mail': $c_date = $_REQUEST['c_date']; Sendmail($c_date, $phone, $results_id, $results_comment, $content, $product_id, $call_vote); break; case 'get_calls': $data = array('calls' => getCalls()); break; case 'category_change': $information_category_id_check = $_REQUEST['information_category_id_check']; $data = array('cat' => Getinformation_sub_category('', $information_category_id_check)); break; case 'set_task_type': $cat_id = $_REQUEST['cat_id']; $data = array('cat' => Getbank_object($cat_id)); break; case 'get-info': $start1 = $_REQUEST['start']; $end1 = $_REQUEST['end'];
function Cancel($id, $currentcal, $cancelreason, $notifyusers, $cancelall) { /* get appointment info before changing it */ $sqlstring = "select a.*, b.calendar_name, c.project_name from calendar_appointments a left join calendars b on a.appt_calendarid = b.calendar_id left join calendar_projects c on a.appt_projectid = c.project_id where a.appt_id = '{$id}'"; $result = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>{$sqlstring}</i><br>"); $row = mysql_fetch_array($result, MYSQL_ASSOC); $calid = $row['appt_calendarid']; $prjid = $row['appt_projectid']; $startdate = date('M j, Y', strtotime($row['appt_startdate'])); $enddate = date('M j, Y', strtotime($row['appt_enddate'])); $appttitle = $row['appt_title']; $calendar = $row['calendar_name']; $starttime = date('g:i a', strtotime($row['appt_startdate'])); $endtime = date('g:i a', strtotime($row['appt_enddate'])); if ($cancelall) { $sqlstring = "update calendar_appointments set appt_canceldate = now() where appt_groupid = '{$id}'"; } else { $sqlstring = "update calendar_appointments set appt_canceldate = now() where appt_id = '{$id}'"; } echo $sqlstring; $result = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>{$sqlstring}</i><br>"); /* send an email if necessary */ if ($notifyusers != "") { $body = "The appointment titled '{$appttitle}' scheduled from {$starttime}-{$endtime} on {$startdate} has been cancelled from the {$calendar} calendar because {$cancelreason}"; $subject = "{$calendar} cancellation {$startdate}"; /* get a list of users who care about this calendar and send an email */ $sqlstring = "select b.user_email 'email' from calendar_notifications a left join users b on a.not_userid = b.user_id where not_calendarid = {$calid}"; $result = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>{$sqlstring}</i><br>"); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $recipients[] = $row['email']; } Sendmail($body, $recipients, $subject); /* get a list of users who care about this project and send an email */ } ?> <br> Appointment cancelled. Redirecting to calendar. <?php }