$incom_id = $_REQUEST['id'];
$phone = $_REQUEST['phone'];
$client_name = $_REQUEST['client_name'];
$call_content = htmlspecialchars($_REQUEST['call_content'], ENT_QUOTES);
$problem_coment = $_REQUEST['problem_coment'];
$comment = htmlspecialchars($_REQUEST['comment'], ENT_QUOTES);
switch ($action) {
case 'get_add_page':
$user = $_SESSION['USERID'];
$number = $_REQUEST['number'];
$key = md5($user . $number);
$data = array('key' => $key, 'user' => $user);
break;
case 'get_edit_page':
$task_id = $_REQUEST['id'];
$page = GetPage(Gettask($task_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$user = $_SESSION['USERID'];
$start = $_REQUEST['start'];
$end = $_REQUEST['end'];
$group = checkgroup($user);
if ($group == 1 || $group == 3) {
$rResult = mysql_query("SELECT IF(ISNULL(task.id), CONCAT('u',ast.id),task.id) AS `id`,\r\n \t\t\t\t ast.call_datetime AS date,\r\n \t\t\t\t IF(ISNULL(task.id), ast.source,task.phone),\r\n\t\t \r\n \t\t\t\t IF(ISNULL(task.id), (SELECT `name`\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM incomming_call\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE phone = ast.source AND NOT ISNULL(`name`)\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t ORDER BY `id` DESC\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t LIMIT 1), task.`name`) AS `name`,\r\n\t\t \r\n (SELECT GROUP_CONCAT(' ',CONCAT(persons.`name`,' ', noansver_users.count, '-ჯერ'))\r\n FROM `noansver_users`\r\n JOIN users ON users.id = noansver_users.noansver_user_id\r\n JOIN persons ON users.person_id = persons.id\r\n WHERE noansver_users.task_id = task.id\r\n GROUP BY noansver_users.task_id\r\n\t LIMIT 1) AS `noansver_users`,\r\n\t\t \r\n \t\t\t\t time_format(SEC_TO_TIME(ast.wait_time), '%i:%s') as time,\r\n \t\t\t\t IF(ISNULL(task.id), 'უპასუხო ზარი',CONCAT('არ უპასუხა', ' ',task.call_caunt, '-ჯერ')) AS task_status\r\n\t\t \r\n FROM asterisk_incomming AS ast\r\n LEFT JOIN task ON ast.id = task.ast_incomming_id\r\n\t\t \r\n WHERE ast.disconnect_cause='ABANDON' \r\n\t\t AND ast.call_datetime BETWEEN '{$start}' AND '{$end}'\r\n\t\t \r\n AND ast.source NOT IN (SELECT asterisk_outgoing.phone \r\n \t\t\t\t\t\t\t\t\t\t\t\t FROM \tasterisk_outgoing\r\n \t\t\t\t\t\t\t\t\t\t\t\t WHERE asterisk_outgoing.call_datetime > ast.call_datetime AND ast.wait_time>=10)\r\n \r\n\t\t AND ast.source NOT IN (SELECT asterisk_incomming.source \r\n \t\t\t\t\t\t\t\t\t\t\t FROM \tasterisk_incomming\r\n \t\t\t\t\t\t\t\t\t\t\t WHERE asterisk_incomming.call_datetime > ast.call_datetime \r\n\t\t AND asterisk_incomming.wait_time>=10\r\n\t\t AND asterisk_incomming.disconnect_cause != 'ABANDON')\r\n\t\t \r\n AND ast.wait_time>=10 AND ast.unansver_status = 0");
}
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
$task_id = $_REQUEST['id'];
$cur_date = $_REQUEST['cur_date'];
$done_start_time = $_REQUEST['done_start_time'];
$done_end_time = $_REQUEST['done_end_time'];
$task_type_id = $_REQUEST['task_type_id'];
$template_id = $_REQUEST['template_id'];
$task_department_id = $_REQUEST['task_department_id'];
$persons_id = $_REQUEST['persons_id'];
$status = $_REQUEST['status'];
switch ($action) {
case 'get_add_page':
$page = GetPage($res = '');
$data = array('page' => $page);
break;
case 'get_task':
$page = Gettask();
$data = array('page' => $page);
break;
case 'set_task':
$set_task_department_id = $_REQUEST['set_task_department_id'];
$set_persons_id = $_REQUEST['set_persons_id'];
$set_priority_id = $_REQUEST['set_priority_id'];
$set_start_time = $_REQUEST['set_start_time'];
$set_done_time = $_REQUEST['set_done_time'];
$set_body = $_REQUEST['set_body'];
$set_task_id = mysql_fetch_assoc(mysql_query("SELECT `task_id` FROM `task_detail` WHERE `id` = '{$task_id}'"));
$tas = $set_task_id[task_id];
GetSetTask($task_id, $tas, $set_task_department_id, $set_persons_id, $set_priority_id, $set_start_time, $set_done_time, $set_body);
break;
case 'get_edit_page':
$page = GetPage(Getincomming($task_id));
/* ******************************
* Request aJax actions
* ******************************
*/
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$log = new log();
$action = $_REQUEST['act'];
$error = '';
$data = '';
//incomming
$incom_id = $_REQUEST['id'];
switch ($action) {
case 'get_edit_page':
$task = $_REQUEST['id'];
$page = GetPage(Gettask($task));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$user_id = $_SESSION['USERID'];
$user = $_SESSION['USERID'];
$group = checkgroup($user);
$start = $_REQUEST['start'];
$end = $_REQUEST['end'];
$filter = '';
$res_row = mysql_fetch_assoc(mysql_query("SELECT users.id as person_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM \t `users`\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE `users`.`id` = {$user_id}"));
$filter = "AND task.responsible_user_id ={$res_row['person_id']}";
$rResult = mysql_query("SELECT task.id,\r\n \t\t\t\t\t\t\t\t\t task.id,\r\n \t\t\t\t\t\t\t\t\t task.date AS date,\r\n\t\t end_date,\r\n\t\t task_type.name,\r\n\t\t priority.name,\r\n\t\t persons1.`name` as gamcemi,\r\n\t\t department.name,\r\n \t\t\t\t\t\t\t\t\t IF(task.incomming_call_id!=0,incomming_call.phone, task.phone),\r\n \t persons.`name`\r\n \t \r\n \t\t\t\t\t\t\tFROM task\r\n \t\t\t\t\t\t\tLEFT JOIN incomming_call ON incomming_call.id=task.incomming_call_id\r\n \t\t\t\t\t\t\tLEFT JOIN users ON task.responsible_user_id=users.id\r\n \t\t\t\t\t\t\tLEFT JOIN users AS users1 ON users1.id = task.user_id\r\n \t\t\t\t\t\t\tLEFT JOIN persons ON persons.id=users.person_id\r\n \t\t\t\t\t\t\tLEFT JOIN persons AS persons1 ON persons1.id=users1.person_id\r\n \t LEFT JOIN department ON department.id=task.department_id\r\n\t\t\t\t\t\t\t\tLEFT JOIN task_type ON task_type.id = task.task_type_id\r\n\t\t LEFT JOIN priority ON priority.id=task.priority_id\r\n \t\t\t\t\t\t\tWHERE task.actived=1 AND ISNULL(task.ast_incomming_id) AND (task.status=2 OR task.status=3) AND task.date >= '{$start}' AND task.date<='{$end}' {$filter}");
$mogvarebuli = mysql_fetch_assoc(mysql_query("SELECT COUNT(*) AS mogvarebuli\r\n \t\t FROM task\r\n \t\t WHERE task.actived=1 AND ISNULL(task.ast_incomming_id) AND (task.status=2 OR task.status=3) AND task.date >= '{$start}' AND task.date<='{$end}' {$filter}"));
