78 lines
2.8 KiB
PHP
78 lines
2.8 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
require_once($_SERVER['DOCUMENT_ROOT']."/config_ajax.php");
|
||
|
|
if(isset($_GET['user_id'])) {
|
||
|
|
$user_id = (int)$_GET['user_id'];
|
||
|
|
$result = array();
|
||
|
|
|
||
|
|
$sqlMainRecords = "SELECT * FROM objects_to_send WHERE new_user_id = ".$user_id." AND `accept_state` = 'NEW'";
|
||
|
|
|
||
|
|
$q = mysql_query($sqlMainRecords);
|
||
|
|
while($r = mysql_fetch_assoc($q)){
|
||
|
|
|
||
|
|
$sql_in = "SELECT `agency_name`, `first_name`, `last_name`, `middle_name`, `agency`, `manager` FROM `users` WHERE `id` = '".$r['sended_user_id']."'";
|
||
|
|
$q_in = mysql_query($sql_in);
|
||
|
|
$r_in = mysql_fetch_assoc($q_in);
|
||
|
|
|
||
|
|
$post = "Сотрудник " . trim($r_in['last_name'] . ' ' . $r_in['first_name'] . ' ' . $r_in['middle_name']);
|
||
|
|
if ($r_in['agency'] == 1) {
|
||
|
|
$post = "Агентство " . $r_in['agency_name'];
|
||
|
|
} else {
|
||
|
|
if ($r_in['manager'] == 1) {
|
||
|
|
$post = "Менеджер " . trim($r_in['last_name'] . ' ' . $r_in['first_name'] . ' ' . $r_in['middle_name']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$clientsNum = 0;
|
||
|
|
$clientsString = '';
|
||
|
|
|
||
|
|
$clientObjIds = [];
|
||
|
|
/*$sql_cl_obj = "SELECT client_id FROM client_objects WHERE object_id = {$r['object_id']}";
|
||
|
|
$q_cl_obj = mysql_query($sql_cl_obj);
|
||
|
|
|
||
|
|
|
||
|
|
while($r_cl_obj = mysql_fetch_assoc($q_cl_obj)){
|
||
|
|
$clientObjIds[] = $r_cl_obj['client_id'];
|
||
|
|
}
|
||
|
|
|
||
|
|
$sql_clients = "SELECT `id`, `fio`, `email` FROM `clients` WHERE id in (".implode(',', $clientObjIds).")";
|
||
|
|
$q_client = mysql_query($sql_clients);
|
||
|
|
|
||
|
|
if(mysql_num_rows($q_client) > 0){
|
||
|
|
while($client = mysql_fetch_assoc($q_client)) {
|
||
|
|
$clientsNum++;
|
||
|
|
$clientsString = $clientsString . ($clientsNum > 1 ? ", " : "") . $client['fio'];
|
||
|
|
}
|
||
|
|
}*/
|
||
|
|
|
||
|
|
$sql_obj = "SELECT nazv FROM `objects` WHERE id= $r[object_id]";
|
||
|
|
$q_obj = mysql_query($sql_obj);
|
||
|
|
$r_obj = mysql_fetch_assoc($q_obj);
|
||
|
|
|
||
|
|
$first_line = $post . " передал вам объект " . $r_obj['nazv'];
|
||
|
|
$sec_line = "Взять ";
|
||
|
|
|
||
|
|
if ($clientsNum > 0) {
|
||
|
|
if ($clientsNum > 1) {
|
||
|
|
$first_line = $first_line . " и клиентов " . $clientsString . ".";
|
||
|
|
$sec_line = $sec_line . "объект и клиентов в работу?";
|
||
|
|
} else {
|
||
|
|
$first_line = $first_line . " и клиента " . $clientsString . ".";
|
||
|
|
$sec_line = $sec_line . "объект и клиента в работу?";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$first_line = $first_line . ".";
|
||
|
|
$sec_line = $sec_line . " в работу?";
|
||
|
|
}
|
||
|
|
|
||
|
|
$result[] = array('id' => $r['id'], 'first_line' => $first_line, 'sec_line' => $sec_line);
|
||
|
|
}
|
||
|
|
if(empty($result)) {
|
||
|
|
echo 0;
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
echo json_encode($result);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|