70 lines
2.6 KiB
PHP
70 lines
2.6 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
|
|
|
||
|
|
if (!isset($get)) {
|
||
|
|
$get=clearInputData($_GET);
|
||
|
|
}
|
||
|
|
|
||
|
|
if($_SESSION['id'] && $get['objId']) {
|
||
|
|
$db_sphinx = new MysqlPdo(hstsph2, null, null, null, true, '9306');
|
||
|
|
|
||
|
|
$sql3="SELECT objects.*, DATE_FORMAT(objects.date_add,'%d.%m.%Y %H:%i') as date_add
|
||
|
|
FROM objects
|
||
|
|
WHERE objects.id = $get[objId]";
|
||
|
|
|
||
|
|
$rez_obj=mysql_query($sql3);
|
||
|
|
$obj=mysql_fetch_assoc($rez_obj);
|
||
|
|
|
||
|
|
$canUnArchive = false;
|
||
|
|
|
||
|
|
$currentUser = new User;
|
||
|
|
$currentUser->get($_SESSION['id']);
|
||
|
|
if ($obj['id_add_user'] > 0) {
|
||
|
|
|
||
|
|
if ($obj['id_add_user'] == $_SESSION['id']) {
|
||
|
|
$canUnArchive = true;
|
||
|
|
} else {
|
||
|
|
|
||
|
|
|
||
|
|
if ($obj['id_add_user'] != $_SESSION['id'] && ($currentUser->agency == 1 || $currentUser->manager == 1 || $currentUser->users_admin == 1)) {
|
||
|
|
$objectUser = new User;
|
||
|
|
$objectUser->get($obj['id_add_user']);
|
||
|
|
//если добавлено пользователем агентства
|
||
|
|
if (isset($objectUser->agencyId) && $objectUser->agencyId == $currentUser->agencyId) {
|
||
|
|
$canUnArchive = true;
|
||
|
|
} else {
|
||
|
|
// или самим агентством
|
||
|
|
if ($currentUser->agencyId == $obj['id_add_user']) {
|
||
|
|
$canUnArchive = true;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($obj && $canUnArchive) {
|
||
|
|
$newDate = date("Y-m-d H:i:s");
|
||
|
|
$sql = "UPDATE objects SET date_add = '$newDate', archive = 0, is_main = 0 WHERE id=$get[objId] AND id_add_user=$obj[id_add_user]";
|
||
|
|
mysql_query($sql);
|
||
|
|
|
||
|
|
//Запрос к сфинкс
|
||
|
|
$sql = "UPDATE objects SET date_add = ".time().", archive = 0 WHERE id=$get[objId] AND id_add_user=$obj[id_add_user]";
|
||
|
|
//echo $sql;
|
||
|
|
$db_sphinx->query($sql);
|
||
|
|
|
||
|
|
//добавляем коммент в задачи
|
||
|
|
$com = 'Объект возвращен в работу';
|
||
|
|
|
||
|
|
$sql = "INSERT INTO user_object_events(user_id, object_id, create_date, type, address, sum, schedule_date, comment, calendar_view)
|
||
|
|
VALUES('$_SESSION[id]', '$get[objId]', NOW(), 'comment', NULL, NULL, NULL, '$com', '1')";
|
||
|
|
mysql_query($sql);
|
||
|
|
|
||
|
|
if($currentUser->agencyId > 0){
|
||
|
|
$dataWhook = array('action'=>'object_restore', 'object_id'=>$get['objId'], 'section'=>'object', 'user_id'=>$_SESSION['id'], 'agency_id'=>$currentUser->agencyId);
|
||
|
|
$w_in = new WebHookIn(null, $currentUser->agencyId);
|
||
|
|
$w_in->check_send($dataWhook);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|