$file = $_REQUEST['file_name']; $hidden_inc = $_REQUEST['hidden_inc']; $edit_id = $_REQUEST['edit_id']; $delete_id = $_REQUEST['delete_id']; switch ($action) { case 'get_add_page': $number = $_REQUEST['number']; $page = GetPage($res = '', $number); $data = array('page' => $page); break; case 'disable': $incom_id = $_REQUEST['id']; mysql_query("\t\t\tUPDATE `incomming_call`\n\t\t\t\t\t\t\t\t\t SET `actived`=0\n\t\t\t\t\t\t\t\t\t\tWHERE `id`={$incom_id} "); break; case 'get_edit_page': $page = GetPage(Getincomming($id)); $data = array('page' => $page); break; case 'get_hint': $hint = $_REQUEST['hint']; $req = mysql_fetch_array(mysql_query("SELECT hint\n \t FROM `tage`\n \t WHERE `name` = '{$hint}';")); $page = '<div id="dialog-form"> <fieldset> <legend>ძირითადი ინფორმაცია</legend> <textarea style="height: 220px;width: 443px;">' . $req[0] . '</textarea> </fieldset> </div>'; $data = array('page' => $page); break; case 'get_list': $count = $_REQUEST['count'];
$template_id = $_REQUEST['template_id']; $priority_id = $_REQUEST['priority_id']; $comment = $_REQUEST['comment']; $hidden_inc = $_REQUEST['hidden_inc']; $edit_id = $_REQUEST['edit_id']; $delete_id = $_REQUEST['delete_id']; // file $rand_file = $_REQUEST['rand_file']; $file = $_REQUEST['file_name']; switch ($action) { case 'get_add_page': $page = GetPage(); $data = array('page' => $page); break; case 'get_edit_page': $page = GetPage(Getincomming($task_id)); $data = array('page' => $page); break; case 'get_list': $count = $_REQUEST['count']; $hidden = $_REQUEST['hidden']; $user_id = $_REQUEST['user_id']; $user = $_SESSION['USERID']; $group = checkgroup($user); $filter = ''; if ($group != 2) { $filter = 'AND outgoing_call.responsible_user_id =' . $user; } $rResult = mysql_query("SELECT \t \t`task`.id,\r\n\t\t\t\t\t\t\t\t\t\t\t`task`.id,\r\n\t\t\t\t\t\t\t\t\t\t\t`site_user`.`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t`site_user`.`pin`,\r\n\t\t\t\t\t\t\t\t\t\t\t`person1`.`name` ,\r\n\t\t\t\t\t\t\t\t\t\t\t`person2`.`name` ,\r\n\t\t\t\t\t\t\t\t\t\t\t`incomming_call`.date,\r\n\t\t\t\t\t\t\t\t\t\t\t`status`.`call_status`\r\n\t\t\t\t\t\t\t\tFROM \t\ttask\t\t\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN \t\tincomming_call ON task.incomming_call_id=incomming_call.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN \tsite_user\t\tON incomming_call.id=site_user.incomming_call_id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tJOIN \t\tusers AS `user1`\t\t\tON task.responsible_user_id=user1.id\r\n\t\t\t\t\t\t\t\tJOIN \t\tpersons AS `person1`\t\tON user1.person_id=person1.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tJOIN \t\tusers AS `user2`\t\t\tON task.user_id=user2.id\r\n\t\t\t\t\t\t\t\tJOIN \t\tpersons AS `person2`\t\tON user2.person_id=person2.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN `status` \tON\ttask.`status`= `status`.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tWHERE \t\ttask.task_type_id=1 AND task.`status`=1"); $data = array("aaData" => array()); while ($aRow = mysql_fetch_array($rResult)) {
$data = ''; // Incomming Call Dialog Strings $hidden_id = $_REQUEST['id']; $person_name = mysql_real_escape_string($_REQUEST['person_name']); $person_surname = mysql_real_escape_string($_REQUEST['person_surname']); $person_posityon = mysql_real_escape_string($_REQUEST['person_posityon']); $person_mobile = mysql_real_escape_string($_REQUEST['person_mobile']); $person_phone = mysql_real_escape_string($_REQUEST['person_phone']); $person_comment = mysql_real_escape_string($_REQUEST['person_comment']); switch ($action) { case 'get_add_page': $page = GetPage('', increment(incomming_call)); $data = array('page' => $page); break; case 'get_edit_page': $page = GetPage(Getincomming($hidden_id)); $data = array('page' => $page); break; case 'disable': $hidden_id = $_REQUEST['id']; mysql_query("\tUPDATE `client_person` \r\n\t\t\t\t\t\tSET \t\r\n\t\t\t\t\t\t\t`actived` = 0 \r\n\t\t\t\t\tWHERE `id`='{$hidden_id}'\r\n\t\t\t\t"); break; case 'save-client_person': $hidden_id = $_REQUEST['hidden_id']; $hidden_client_id = $_REQUEST['hidden_client_id']; if ($hidden_id == '') { Addperson($hidden_client_id, $person_name, $person_surname, $person_posityon, $person_mobile, $person_phone, $person_comment); } else { Saveperson($hidden_id, $person_name, $person_surname, $person_posityon, $person_mobile, $person_phone, $person_comment); } break;
$fact_end_date = $_REQUEST['fact_end_date']; $template_id = $_REQUEST['template_id']; $hidden_inc = $_REQUEST['hidden_inc']; $edit_id = $_REQUEST['edit_id']; $delete_id = $_REQUEST['delete_id']; // file $rand_file = $_REQUEST['rand_file']; $file = $_REQUEST['file_name']; switch ($action) { case 'get_add_page': $number = $_REQUEST['number']; $page = GetPage($res = '', $number); $data = array('page' => $page); break; case 'get_edit_page': $page = GetPage(Getincomming($incom_id), $incom_id); $data = array('page' => $page); break; case 'get_list': $count = $_REQUEST['count']; $hidden = $_REQUEST['hidden']; $user_id = $_SESSION['USERID']; $user = $_SESSION['USERID']; $group = checkgroup($user); $user_dep_id = mysql_fetch_assoc(mysql_query("SELECT \t`users`.`dep_id`\n \t\t FROM \t `users`\n \t\t WHERE \t`users`.`id` = {$user}")); if ($user == 1 || $user == 2 || $user == 42 || $user == 46 || $user == 4) { $user_dep = ""; } else { $user_dep = "AND `task`.department_id = {$user_dep_id['dep_id']}"; } $filter = '';
$task_end_date = $_REQUEST['task_end_date']; $task_departament_id = $_REQUEST['task_departament_id']; $task_recipient_id = $_REQUEST['task_recipient_id']; $task_priority_id = $_REQUEST['task_priority_id']; $task_controler_id = $_REQUEST['task_controler_id']; $task_status_id = $_REQUEST['task_status_id']; $task_description = $_REQUEST['task_description']; $task_note = $_REQUEST['task_note']; $task_send = $_REQUEST['task_send']; switch ($action) { case 'get_add_page': $page = GetPage('', increment(incomming_call)); $data = array('page' => $page); break; case 'get_edit_page': $page = GetPage(Getincomming($hidden_id, $open_number), '', $open_number, $queue); $data = array('page' => $page); break; case 'task_dep': $page = get_task_dep($task_departament_id); $data = array('get_dep_user' => $page); break; case 'get_list': $count = $_REQUEST['count']; $hidden = $_REQUEST['hidden']; $start_date = $_REQUEST['start_date']; $end_date = $_REQUEST['end_date']; $operator_id = $_REQUEST['operator_id']; $tab_id = $_REQUEST['tab_id']; $filter_1 = $_REQUEST['filter_1']; $filter_2 = $_REQUEST['filter_2'];