Joywork/ajax/getClientLogForEvents.php
2026-06-30 14:25:28 +03:00

201 lines
11 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");
if ($_SESSION['id'] && $_GET['id'] && is_numeric($_GET['id'])) {
$get = clearInputData($_GET);
// обновляем метку у меню календаря
// считаем события объектов
$sql = "SELECT count(id) FROM user_object_events WHERE user_id = $_SESSION[id] and calendar_view = 0
and schedule_date is not null AND DATE_FORMAT(e.schedule_date, '%Y-%m-%d %H:%i:%s') <= '".date("Y-m-d H:i:s")."'";
$rez = mysql_query($sql);
$objectEventCount = mysql_result($rez,0);
// считаем события клиентов
$sql = "SELECT count(id) FROM user_client_events WHERE user_id = $_SESSION[id] AND DATE_FORMAT(e.schedule_date, '%Y-%m-%d %H:%i:%s') and cancel = 0
and schedule_date is not null and DATE(schedule_date) <= '".date("Y-m-d H:i:s")."'";
$rez = mysql_query($sql);
$clientEventCount = mysql_result($rez,0);
// суммарное количество событий по объектам и пользователям
$sumCount = intval($objectEventCount) + intval($clientEventCount);
echo "<script>$('#calendarCounter').html('".$sumCount."');</script>";
$client = new Clients;
$client->get($get['id']);
$dateAdd = date("d.m.Y", strtotime($client->date_add));
list($d, $m, $y) = explode(".", $dateAdd);
if ($y == date("Y")) {
$y = "";
}
$date_add = $d." ".getRusMonth($m)." ".$y;
echo '<div class="chat-date"><span>'.$date_add.'</span></div>';
echo '<div class="chat-status added"><span>Клиент добавлен</span></div>';
$user = new User;
$user->get($_SESSION['id']);
// если смотрит руководитель - показываем все
if ($_SESSION['agency'] || $_SESSION['manager'] or $_SESSION['users_admin']) {
$sql = "SELECT * from user_client_events WHERE client_id = $get[id] ORDER BY create_date ASC";
} else {
$sql = "SELECT * from user_client_events WHERE user_id = $_SESSION[id] and client_id = $get[id] ORDER BY create_date ASC";
}
$rez = mysql_query($sql);
$date = null;
$createDate = null;
while ($event = mysql_fetch_assoc($rez)) {
if ($createDate == null || $createDate != date("d.m.Y", strtotime($event['create_date']))) {
$createDate = date("d.m.Y", strtotime($event['create_date']));
list($d, $m, $y) = explode(".", $createDate);
if ($y == date("Y")) {
$y = "";
}
echo '<div class="chat-date"><span>' . $d . " " . getRusMonth($m) . " " . $y . '</span></div>';
}
if ($event['type'] == 'comment') {
echo '<div class="chat-block"><div class="chat-message comment"><div class="head"><span>Примечание</span></div>';
echo '<div class="message">' . $event['comment'] . '</div>';
echo '<span class="time">' . date("H:i", strtotime($event['create_date'])) . '</span></div><div class="clear"></div></div>';
}
if ($event['type'] == 'call') {
$date = date("d.m.Y", strtotime($event['schedule_date']));
list($d, $m, $y) = explode(".", $date);
echo '<div class="chat-block"><div class="chat-message call"><div class="head"><span>Звонок</span></div><div class="message">';
echo 'Позвонить ' . $d . ' ' . getRusMonth($m) . ' ' . $y . ' в ' . date("H:i", strtotime($event['schedule_date'])) . '</div>';
if ($event['comment']) {
echo '<div class="message"> Комментарий: ' . $event['comment'] . '</div>';
}
echo '<span class="time">' . date("H:i", strtotime($event['create_date'])) . '</span></div><div class="clear"></div></div>';
}
if ($event['type'] == 'meet') {
$date = date("d.m.Y", strtotime($event['schedule_date']));
list($d, $m, $y) = explode(".", $date);
echo '<div class="chat-block"><div class="chat-message meeting"><div class="head"><span>Встреча</span></div><div class="message">';
echo 'Встреча будет ' . $d . ' ' . getRusMonth($m) . ' ' . $y . ' в ' . date("H:i", strtotime($event['schedule_date'])) . '</div>';
if ($event['address']) {
echo '<div class="message"> Адрес: ' . $event['address'] . '</div>';
}
if ($event['comment']) {
echo '<div class="message"> Комментарий: ' . $event['comment'] . '</div>';
}
echo '<span class="time">' . date("H:i", strtotime($event['create_date'])) . '</span></div><div class="clear"></div></div>';
}
if ($event['type'] == 'show') {
$date = date("d.m.Y", strtotime($event['schedule_date']));
list($d, $m, $y) = explode(".", $date);
echo '<div class="chat-block"><div class="chat-message showing"><div class="head"><span>Показ</span></div><div class="message">';
echo 'Показ будет ' . $d . ' ' . getRusMonth($m) . ' ' . $y . ' в ' . date("H:i", strtotime($event['schedule_date'])) . '</div>';
if ($event['address']) {
echo '<div class="message"> Адрес: ' . $event['address'] . '</div>';
}
if ($event['comment']) {
echo '<div class="message"> Комментарий: ' . $event['comment'] . '</div>';
}
echo '<span class="time">' . date("H:i", strtotime($event['create_date'])) . '</span></div><div class="clear"></div></div>';
}
if ($event['type'] == 'deal') {
$date = date("d.m.Y", strtotime($event['schedule_date']));
list($d, $m, $y) = explode(".", $date);
echo '<div class="chat-block"><div class="chat-message deal"><div class="head"><span>Сделка</span></div><div class="message">';
echo 'Запланирована сделка на ' . $d . ' ' . getRusMonth($m) . ' ' . $y . ' в ' . date("H:i", strtotime($event['schedule_date'])) . '</div>';
if ($event['sum']) {
echo '<div class="message">Сумма сделки: ' . $event['sum'] . '<span class="rub">p</span></div>';
}
if ($event['comment']) { ?>
<div class="message">Комментарий: <?=$event['comment']?></div>
<?php } if ($event['document_id']) {
$doc_id = $event['document_id'];
$doc = Docs::getInnerDoc(null, $doc_id);
if (isset($doc['params'])) {
if ($params = json_decode($doc['params'], true)) {
if ($params['client_id'] && $params['object_id']) {
$doc_parties = '';
if (isset($params['client_id'])) {
$sql_cl = "SELECT id, fio, phone, email FROM `clients` WHERE `id` = '$params[client_id]' LIMIT 1";
$rez_cl = mysql_query($sql_cl);
if ($doc_cl = mysql_fetch_assoc($rez_cl)) {
mask_client_contacts_inplace($doc_cl);
$cl_contacts = [];
if ($doc_cl['email'])
$cl_contacts[] = $doc_cl['email'];
if ($doc_cl['phone'])
$cl_contacts[] = $doc_cl['phone'];
$doc_parties .= '<li><a href="javascript:{}" data-id="'.$doc_cl['id'].'" data-object="'.$params['object_id'].'" class="show_client">'.$doc_cl['fio'] . ((!empty($cl_contacts)) ? ' (' . implode(', ', $cl_contacts) . ')' : '') . '</a><li/>';
}
}
if (isset($params['object_id'])) {
$sql_obj = "SELECT id, nazv, adres FROM `objects` WHERE `id` = '$params[object_id]' LIMIT 1";
$rez_obj = mysql_query($sql_obj);
if ($doc_obj = mysql_fetch_assoc($rez_obj)) {
$doc_parties .= '<li><a href="javascript:{}" onclick="openObjectModal('.$doc_obj['id'].', 1)">'.$doc_obj['nazv'].' ('.$doc_obj['adres'].')</a><li/>';
}
}
if (!empty($doc_parties)) { ?>
<div class="message parties">Стороны сделки:<br/><ul><?= $doc_parties; ?></ul></div>
<?php }
}
}
}
if (isset($doc['id']) && isset($doc['name'])) { ?>
<div class="document" data-id="<?= $doc['id']; ?>">
Документ:
<a href="javascript:{}" class="no-border pull-right">
<span class="jw__small-popup ti-more" data-id="document_<?= $doc['id']; ?>"></span>
<div class="jw__popup actions-document" id="popup__document_<?= $doc['id']; ?>">
<div class="actions-document__inner">
<a href="javascript:{}" onclick="previewInnerDoc(<?= $doc['id']; ?>)">Предпросмотр</a>
<a href="javascript:{}" onclick="editInnerDoc(<?= $doc['id']; ?>)">Редактировать</a>
<a href="javascript:{}" onclick="sendInnerDocWin(<?= $doc['id']; ?>)">Отправить</a>
<a href="javascript:{}" onclick="confirmDeleteInnerDoc(<?= $doc['id']; ?>)">Удалить</a>
</div>
</div>
</a><br/>
<ul>
<li>
<a title="Скачать файл" download="" href="/ajax/getInnerDoc.php?id=<?= $doc['id']; ?>&download_pdf=true&t=<?= time(); ?>">
<span class="file-span ti-file"></span>
<span class="file-name" data-id="<?= $doc['id']; ?>"><?= $doc['name']; ?>.pdf</span>
</a>
</li>
</ul>
</div>
<?php }
}
echo '<span class="time">' . date("H:i", strtotime($event['create_date'])) . '</span></div><div class="clear"></div></div>';
}
}
}
?>