904 lines
43 KiB
PHP
904 lines
43 KiB
PHP
<?php
|
||
|
||
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
||
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
|
||
// закрываем доступ на выполнение запросов
|
||
|
||
if(!$_SESSION['superadmin']) {header("location:/index.php"); die("Доступ запрещён!");}
|
||
|
||
$starttime = microtime(true);
|
||
|
||
$url_params = '';
|
||
$url_params_with_page = '';
|
||
if (isset($_GET['agent'])) {
|
||
$url_params = $url_params."agent=".$_GET['agent'];
|
||
}
|
||
|
||
if (isset($_GET['block'])) {
|
||
if (strlen($url_params) > 0) {
|
||
$url_params = $url_params."&";
|
||
}
|
||
$url_params = $url_params."block=1";
|
||
}
|
||
|
||
if (isset($_GET['active'])) {
|
||
if (strlen($url_params) > 0) {
|
||
$url_params = $url_params."&";
|
||
}
|
||
$url_params = $url_params."active=1";
|
||
}
|
||
|
||
if (isset($_GET['search'])) {
|
||
if (strlen($url_params) > 0) {
|
||
$url_params = $url_params."&";
|
||
}
|
||
$url_params = $url_params."search=".$_GET['search'];
|
||
}
|
||
|
||
$url_params_with_page = $url_params;
|
||
|
||
if (isset($_GET['page'])) {
|
||
if (strlen($url_params) > 0) {
|
||
$url_params_with_page = $url_params_with_page."&";
|
||
}
|
||
$url_params_with_page = $url_params_with_page."page=".$_GET['page'];
|
||
}
|
||
|
||
if($_GET['ok_tarif']) {
|
||
|
||
User::changeTarif();
|
||
|
||
header("location:index.php?".$url_params_with_page);
|
||
}
|
||
|
||
if(isset($_GET['blocked'])) {
|
||
User::set_blocked($_GET['blocked'],$_GET['id_user']);
|
||
|
||
header("location:index.php?".$url_params_with_page);
|
||
|
||
}
|
||
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/templates/header-admin.php");
|
||
|
||
?>
|
||
|
||
<div class="main-title">
|
||
|
||
<h1>Пользователи</h1>
|
||
|
||
</div>
|
||
|
||
<div class="users fr__users">
|
||
|
||
<div class="head-filter__top">
|
||
|
||
<div class="top-line">
|
||
|
||
<div class="head-filter-search">
|
||
|
||
<div class="form-search">
|
||
|
||
<form>
|
||
|
||
<input type="search" name="search" class="text" placeholder="Имя, эл. почта или номер телефона" value="<?php echo $_GET['search']; ?>">
|
||
|
||
<span class="search-icon">
|
||
|
||
<i class="ti-search"></i>
|
||
|
||
</span>
|
||
|
||
</form>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
<div class="switch__filter button-row">
|
||
|
||
<a href="/admin/index.php" class="selector-button button-left <?php if(!$_GET['agent'] && !$_GET['developer'] && !$_GET['search'] && !$_GET['block'] && !$_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Агентства</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(0, false); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?agent=1" class="selector-button button-center <?php if($_GET['agent'] && !$_GET['block'] && !$_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Агенты</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(1, false); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?developer=1" class="selector-button button-center <?php if($_GET['developer'] && !$_GET['block'] && !$_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Застройщики</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountDeveloper(false); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?block=1" class="selector-button button-center <?php if(!$_GET['agent'] && !$_GET['developer'] && $_GET['block']) echo 'selected'; ?>">
|
||
|
||
<span>ЧС агентства</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(0, true); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?agent=1&block=1" class="selector-button button-right <?php if($_GET['agent'] && $_GET['block']) echo 'selected'; ?>">
|
||
|
||
<span>ЧС агенты</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(1, true); ?></i>
|
||
|
||
</a>
|
||
<!--
|
||
<a href="/admin/index.php?developer=1&block=1" class="selector-button button-right <?php if($_GET['developer'] && $_GET['block']) echo 'selected'; ?>">
|
||
|
||
<span>ЧС застройщики</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountDeveloper(true); ?></i>
|
||
|
||
</a> -->
|
||
|
||
<a href="/admin/index.php?active=1" class="selector-button button-center <?php if(!$_GET['agent'] && !$_GET['developer'] && !$_GET['domclick'] && !$_GET['block'] && $_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Актив. агентства</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(0, false, true); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?agent=1&active=1" class="selector-button button-right <?php if($_GET['agent'] && !$_GET['block'] && $_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Актив. агенты</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountAgency(1, false, true); ?></i>
|
||
|
||
</a>
|
||
|
||
<a href="/admin/index.php?developer=1&active=1" class="selector-button button-right <?php if($_GET['developer'] && !$_GET['block'] && $_GET['active']) echo 'selected'; ?>">
|
||
|
||
<span>Актив. застройщики</span>
|
||
|
||
<i class="filter_counter" style="display: block;"><?php echo User::getCountDeveloper(false, true); ?></i>
|
||
|
||
</a>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
<?php
|
||
$num_on_page = 10;
|
||
|
||
if (isset($_GET['page'])) {
|
||
$page = $_GET['page'];
|
||
} else {
|
||
$page = 1;
|
||
}
|
||
|
||
$from = ($page - 1) * $num_on_page;
|
||
|
||
if ($_GET['search']) {
|
||
$count_users = User::countUsers($_GET['agent']);
|
||
$users = [];
|
||
if ($count_users > 0) {
|
||
$users = User::searchUsers($_GET['agent'], $from, $num_on_page);
|
||
}
|
||
}
|
||
else if (isset($_GET['developer']))
|
||
{
|
||
$count_users = User::getCountDeveloper($_GET['block'], $_GET['active']);
|
||
|
||
$users = [];
|
||
if ($count_users > 0)
|
||
{
|
||
$users = User::getAllDeveloper($_GET['block'], $_GET['active'], $from, $num_on_page);
|
||
}
|
||
}
|
||
else {
|
||
$count_users = User::countAllAgency($_GET['agent'], $_GET['block'], $_GET['active']);
|
||
$users = [];
|
||
if ($count_users > 0) {
|
||
$users = User::getAllAgency($_GET['agent'], $_GET['block'], $_GET['active'], $from, $num_on_page);
|
||
}
|
||
}
|
||
|
||
$all_pages = ceil($count_users / $num_on_page);
|
||
|
||
echo '<div class="f-system_pagination" style="padding: 20px 20px 0 20px;"><ul class="pagination">';
|
||
|
||
if($all_pages > 1) {
|
||
|
||
num_of_pages($page, $all_pages, $url_params);
|
||
|
||
}
|
||
|
||
echo '</ul><div class="clear"></div></div>';
|
||
|
||
$getUsersTime = microtime(true);
|
||
|
||
foreach($users as $agent)
|
||
{
|
||
|
||
$agent['moderation_advert'] = 0;
|
||
|
||
$result_frame = mysql_query("SELECT users.id, users.presentation_frame pf FROM users WHERE presentation_frame = 1 AND users.id = $agent_id");
|
||
|
||
|
||
if(mysql_num_rows(mysql_query("SELECT id FROM advert_moderation_agency WHERE agency_id={$agent['id']}")) > 0){
|
||
$agent['moderation_advert'] = 1;
|
||
}
|
||
|
||
if (mysql_num_rows($result_frame) > 0) {
|
||
$agent['presentation_frame'] = 1;
|
||
}
|
||
|
||
if($agent['blocked'])
|
||
{
|
||
$style = "style='background:rgba(247, 220, 220, 0.6);' title='Заблокирован'";
|
||
$word_blocked = "Разблокировать";
|
||
$new_block = 0;
|
||
}
|
||
|
||
else
|
||
{
|
||
$style = "";
|
||
$word_blocked = "Заблокировать";
|
||
$new_block = 1;
|
||
}
|
||
|
||
$online = mysql_fetch_assoc(mysql_query("SELECT DATE_FORMAT(entry,'%d.%m.%Y %H:%i') AS entry FROM online WHERE id_user=$agent[id]"));
|
||
|
||
if ($online)
|
||
{
|
||
$onl = "<div class='status green' title='Время захода'><i>$online[entry]</i></div>";
|
||
}
|
||
else
|
||
{
|
||
$onl = "<div class='status red' title='Последняя авторизация'><i>$agent[last_auth]</i></div>";
|
||
}
|
||
|
||
$role_box = "";
|
||
if ($agent['role_developer'])
|
||
{
|
||
$role_box = "<div class='status border' title='Застройщик'><i>Застройщик</i></div>";
|
||
}
|
||
|
||
if($agent['id_tarif'])
|
||
{
|
||
|
||
$oplata = "Оплачено";
|
||
|
||
$tarif = new Tarif;
|
||
|
||
$tarif->get($agent['id_tarif']);
|
||
|
||
$date_end = $agent['date_tarif'] + $tarif->period * 3600 * 24;
|
||
|
||
$date_end_f = date("d.m.Y H:i",$date_end);
|
||
|
||
$dney = ceil(($date_end - time()) / 24 / 3600);
|
||
|
||
if($dney < 0) {
|
||
$dney = 0; $oplata = "Не оплачено";
|
||
}
|
||
|
||
if ($dney == -0) {
|
||
$dney = 0;
|
||
}
|
||
|
||
$dney = "<a title='$date_end_f' href='#' class='changeTarif' data-id='$agent[id]' data-tarif='$agent[id_tarif]'>$dney ".padezh_day($dney)."</a>";
|
||
|
||
$tarif = "<a title='$date_end_f' href='#' class='changeTarif' data-id='$agent[id]' data-tarif='$agent[id_tarif]'>$agent[tarif]</a>";
|
||
|
||
}
|
||
else
|
||
{
|
||
$dney = "";
|
||
}
|
||
|
||
list($d,$m,$y) = explode(".",$agent['date_reg']);
|
||
|
||
$date_reg = $d." ".getRusMonth($m)." ".$y;
|
||
|
||
if($agent[id_manager])
|
||
{
|
||
$mstr = mysql_fetch_assoc(mysql_query("SELECT agency, manager, agency_name, first_name, last_name, middle_name, id_manager FROM users WHERE id=$agent[id_manager]"));
|
||
|
||
if($mstr['id_manager']) $mstr2 = mysql_fetch_assoc(mysql_query("SELECT agency, manager, agency_name, first_name, last_name, middle_name, id_manager FROM users WHERE id=$mstr[id_manager]"));
|
||
|
||
if($mstr['agency'])
|
||
{
|
||
$master = "Агентство $mstr[agency_name]";
|
||
}
|
||
else if ($mstr['manager'])
|
||
{
|
||
$master = "Менеджер " . trim($mstr['last_name'] . ' ' . $mstr['first_name'] . ' ' . $mstr['middle_name']) . " (" . trim($mstr2['last_name'] . ' ' . $mstr2['first_name'] . ' ' . $mstr2['middle_name']) . ")";
|
||
}
|
||
else
|
||
{
|
||
$master = "Агент " . trim($mstr['last_name'] . ' ' . $mstr['first_name'] . ' ' . $mstr['middle_name']); // хозяином агент быть не может, ну да пускай будет
|
||
}
|
||
}
|
||
else
|
||
{
|
||
$master = 0;
|
||
}
|
||
|
||
?>
|
||
|
||
<div class="user" <?php echo $style; ?>>
|
||
|
||
<div class="top">
|
||
|
||
<div class="date-status">
|
||
|
||
<span>Регистрация: <?php echo $date_reg; ?></span>
|
||
|
||
<div class="status border"><i><?php echo $oplata; ?></i></div>
|
||
|
||
<?php echo $onl; ?>
|
||
<?= $role_box; ?>
|
||
|
||
<?php if($_GET['search'] and $master) echo '<div class="status border"><i><b class="ti-bookmark"></b> '.$master.'</i></div>'; ?>
|
||
|
||
</div>
|
||
|
||
<h2><?php
|
||
if ($agent['agency'] == 1 || $agent['role_developer'] == 1)
|
||
echo $agent['agency_name'];
|
||
else
|
||
echo trim($agent['last_name'] . ' ' . $agent['first_name'] . ' ' . $agent['middle_name']);
|
||
?></h2>
|
||
|
||
<?php if ($agent['agency'] == 0 && $agent['agent'] == 1 && $agent['id_manager'] == 0 && $agent['id'] != 6189 && $agent['id'] != 2683) {
|
||
|
||
$sqlCountZipalPackFeed = "SELECT count(objects.id) FROM objects objects WHERE objects.id in
|
||
(SELECT p.object_id FROM advertising_package_object_publish p WHERE p.active = 1 and
|
||
p.user_id in (SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id]))))";
|
||
|
||
$rezCountZipalPackFeed = mysql_query($sqlCountZipalPackFeed, $mdb);
|
||
$feedZipalPackCount = (int)mysql_result($rezCountZipalPackFeed, 0);
|
||
|
||
$sqlCountZipalFeed = "SELECT count(objects.id)
|
||
FROM objects objects WHERE objects.add_to_zipal = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountZipalFeed = mysql_query($sqlCountZipalFeed, $mdb);
|
||
$feedZipalCount = (int)mysql_result($rezCountZipalFeed, 0) + $feedZipalPackCount;
|
||
|
||
$objectsZipalUrl = "https://joywork.ru/objects-from-feed.php?zipal=1&id_agent=".$agent['id'];
|
||
?>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Размещение на Zipal.ru</b>: <a target="_blank" href="<?php echo $objectsZipalUrl;?>"><?php echo $feedZipalCount; ?></a></div>
|
||
|
||
<?php }?>
|
||
|
||
<?php if (($agent['agency'] == 1 && $agent['agent'] == 1) || ($agent['agency'] == 0 && $agent['id_manager'] == 0 && $agent['manager'] == 0 && $agent['agent'] == 1)) {
|
||
|
||
$sqlCountFeed = "SELECT count(objects.id) FROM objects objects WHERE objects.archive <> 1 and objects.id_add_user > 0 and objects.add_to_yandex_feed = 1
|
||
and objects.id_add_user in (SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountFeed = mysql_query($sqlCountFeed, $mdb);
|
||
$feedCount = mysql_result($rezCountFeed,0);
|
||
|
||
$sqlCountAvitoFeed = "SELECT count(objects.id)
|
||
FROM objects objects
|
||
WHERE objects.archive <> 1
|
||
and objects.add_to_avito_feed = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountAvitoFeed = mysql_query($sqlCountAvitoFeed, $mdb);
|
||
$feedAvitoCount = mysql_result($rezCountAvitoFeed,0);
|
||
|
||
$sqlCountCianFeed = "SELECT count(objects.id)
|
||
FROM objects objects
|
||
WHERE objects.archive <> 1
|
||
and objects.add_to_cian_feed = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountCianFeed = mysql_query($sqlCountCianFeed, $mdb);
|
||
$feedCianCount = mysql_result($rezCountCianFeed,0);
|
||
|
||
$sqlCountDomFeed = "SELECT count(objects.id)
|
||
FROM objects objects
|
||
WHERE objects.archive <> 1
|
||
and objects.add_to_domclick_feed = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountDomFeed = mysql_query($sqlCountDomFeed, $mdb);
|
||
$feedDomCount = mysql_result($rezCountDomFeed,0);
|
||
|
||
$sqlCountEmlsFeed = "SELECT count(objects.id)
|
||
FROM objects objects
|
||
WHERE objects.archive <> 1
|
||
and objects.add_to_emls_feed = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountEmlsFeed = mysql_query($sqlCountEmlsFeed, $mdb);
|
||
$feedEmlsCount = mysql_result($rezCountEmlsFeed,0);
|
||
|
||
$sqlCountBnFeed = "SELECT count(objects.id)
|
||
FROM objects objects
|
||
WHERE objects.archive <> 1
|
||
and objects.add_to_bn_feed = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountBnFeed = mysql_query($sqlCountBnFeed, $mdb);
|
||
$feedBnCount = mysql_result($rezCountBnFeed, 0);
|
||
|
||
$sqlCountZipalPackFeed = "SELECT count(objects.id) FROM objects objects WHERE objects.id in
|
||
(SELECT p.object_id FROM advertising_package_object_publish p WHERE p.active = 1 and
|
||
p.user_id in (SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id]))))";
|
||
|
||
$rezCountZipalPackFeed = mysql_query($sqlCountZipalPackFeed, $mdb);
|
||
$feedZipalPackCount = (int)mysql_result($rezCountZipalPackFeed, 0);
|
||
|
||
$sqlCountZipalFeed = "SELECT count(objects.id)
|
||
FROM objects objects WHERE objects.add_to_zipal = 1 and objects.id_add_user in
|
||
(SELECT id FROM `users` WHERE id=$agent[id] or id_manager=$agent[id] or id_manager in (select id from users where id_manager=$agent[id]) or id_manager in (select id from users where id_manager in (select id from users where id_manager=$agent[id])))";
|
||
|
||
$rezCountZipalFeed = mysql_query($sqlCountZipalFeed, $mdb);
|
||
$feedZipalCount = (int)mysql_result($rezCountZipalFeed, 0) + $feedZipalPackCount;
|
||
|
||
$yandexFeedName = $agent['id'];
|
||
|
||
if ($yandexFeedName == 177) {
|
||
$yandexFeedName = "1ght764cndh";
|
||
}
|
||
|
||
$feedUrl = "https://joywork.ru/feeds/".$yandexFeedName.".xml";
|
||
$avFeedUrl = "https://joywork.ru/av_feeds/".$agent['id'].".xml";
|
||
$cianFeed2Url = "https://joywork.ru/cian_feed_v2/".$agent['id'].".xml";
|
||
$emlsFeed = "https://joywork.ru/cian_feed_jcat/".$agent['id'].".xml";
|
||
$bnYandexFeedUrl = "https://joywork.ru/bn_ya_feeds/".$agent['id'].".xml";
|
||
$domFeedUrl = "https://joywork.ru/dom_feeds/".$agent['id'].".xml";
|
||
$objectsUrl = "https://joywork.ru/objects-from-feed.php?id_agent=".$agent['id'];
|
||
$objectsAvitoUrl = "https://joywork.ru/objects-from-feed.php?avito=1&id_agent=".$agent['id'];
|
||
$objectsCianUrl = "https://joywork.ru/objects-from-feed.php?cian=1&id_agent=".$agent['id'];
|
||
$objectsEmlsUrl = "https://joywork.ru/objects-from-feed.php?emls=1&id_agent=".$agent['id'];
|
||
$objectsBnUrl = "https://joywork.ru/objects-from-feed.php?bn=1&id_agent=".$agent['id'];
|
||
$objectsZipalUrl = "https://joywork.ru/objects-from-feed.php?zipal=1&id_agent=".$agent['id'];
|
||
$objectsDomUrl = "https://joywork.ru/objects-from-feed.php?dom=1&id_agent=".$agent['id'];
|
||
?>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Яндекс</b>: <a target="_blank" href="<?php echo $feedUrl; ?>"><?php echo $feedUrl; ?></a> (<a target="_blank" href="<?php echo $objectsUrl;?>"><?php echo $feedCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Авито</b>: <a target="_blank" href="<?php echo $avFeedUrl; ?>"><?php echo $avFeedUrl; ?></a> (<a target="_blank" href="<?php echo $objectsAvitoUrl;?>"><?php echo $feedAvitoCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид ЦИАН v2</b>: <a target="_blank" href="<?php echo $cianFeed2Url; ?>"><?php echo $cianFeed2Url; ?></a> (<a target="_blank" href="<?php echo $objectsCianUrl;?>"><?php echo $feedCianCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Циан Jcat</b>: <a target="_blank" href="<?php echo $emlsFeed; ?>"><?php echo $emlsFeed; ?></a> (<a target="_blank" href="<?php echo $objectsEmlsUrl;?>"><?php echo $feedEmlsCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид яндекс для BN.ru</b>: <a target="_blank" href="<?php echo $bnYandexFeedUrl; ?>"><?php echo $bnYandexFeedUrl; ?></a> (<a target="_blank" href="<?php echo $objectsBnUrl;?>"><?php echo $feedBnCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Домклик</b>: <a target="_blank" href="<?php echo $domFeedUrl; ?>"><?php echo $domFeedUrl; ?></a> (<a target="_blank" href="<?php echo $objectsDomUrl;?>"><?php echo $feedDomCount; ?></a>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Размещение на Zipal.ru</b>: <a target="_blank" href="<?php echo $objectsZipalUrl;?>"><?php echo $feedZipalCount; ?></a></div>
|
||
<?php } ?>
|
||
|
||
<?php if (($agent['role_developer'] == 1)) {
|
||
$sqlCountCianComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_cian_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountCianComplexFeed = mysql_query($sqlCountCianComplexFeed, $mdb);
|
||
$feedCianComplexCount = (int)mysql_result($rezCountCianComplexFeed, 0);
|
||
|
||
$sqlCountDomComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_domclick_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountDomComplexFeed = mysql_query($sqlCountDomComplexFeed, $mdb);
|
||
$feedDomComplexCount = (int)mysql_result($rezCountDomComplexFeed, 0);
|
||
|
||
$sqlCountYaComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_yandex_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountYaComplexFeed = mysql_query($sqlCountYaComplexFeed, $mdb);
|
||
$feedYaComplexCount = (int)mysql_result($rezCountYaComplexFeed, 0);
|
||
|
||
$sqlCountAvitoComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_avito_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountAvitoComplexFeed = mysql_query($sqlCountAvitoComplexFeed, $mdb);
|
||
$feedAvitoComplexCount = (int)mysql_result($rezCountAvitoComplexFeed, 0);
|
||
|
||
$sqlCountDomRfComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_domrf_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountDomRfComplexFeed = mysql_query($sqlCountDomRfComplexFeed, $mdb);
|
||
$feedDomRfComplexCount = (int)mysql_result($rezCountDomRfComplexFeed, 0);
|
||
|
||
$sqlCountSiteComplexFeed = "SELECT count(complex_rooms.id) FROM complex_rooms
|
||
JOIN complex_floors ON complex_floors.id = complex_rooms.floor_id
|
||
JOIN complex_entrances ON complex_floors.complex_entrance_id = complex_entrances.id
|
||
JOIN complex_houses ON complex_entrances.complex_house_id = complex_houses.id
|
||
JOIN complex_list ON complex_list.id = complex_houses.complex_id
|
||
LEFT JOIN complex_room_advert complex_room_advert ON complex_room_advert.complex_room_id = complex_rooms.id
|
||
WHERE complex_houses.is_archive = 0 and complex_room_advert.add_to_site_feed = 1 AND complex_list.agency_id={$agent['id']}";
|
||
|
||
$rezCountSiteComplexFeed = mysql_query($sqlCountSiteComplexFeed, $mdb);
|
||
$feedSiteComplexCount = (int)mysql_result($rezCountSiteComplexFeed, 0);
|
||
|
||
$avComplexFeedUrl = "https://joywork.ru/av_feeds_complex/".$agent['id'].".xml";
|
||
$domComplexFeedUrl = "https://joywork.ru/dom_feeds_complex/".$agent['id'].".xml";
|
||
$bnYandexComplexFeedUrl = "https://joywork.ru/bn_ya_feeds_complex/".$agent['id'].".xml";
|
||
$cianComplexFeedUrl = "https://joywork.ru/cian_feed_v2_complex/".$agent['id'].".xml";
|
||
$domRfComplexFeedUrl = "https://joywork.ru/dom_rf_feeds_complex/".$agent['id'].".xml";
|
||
$siteComplexFeedUrl = "https://joywork.ru/bn_ya_feeds_complex/".$agent['id']."_site.xml";
|
||
?>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Яндекс</b>: <a target="_blank" href="<?php echo $bnYandexComplexFeedUrl; ?>"><?php echo $bnYandexComplexFeedUrl; ?></a> (<?php echo $feedYaComplexCount; ?>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Авито</b>: <a target="_blank" href="<?php echo $avComplexFeedUrl; ?>"><?php echo $avComplexFeedUrl; ?></a> (<?php echo $feedAvitoComplexCount; ?>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид ЦИАН</b>: <a target="_blank" href="<?php echo $cianComplexFeedUrl; ?>"><?php echo $cianComplexFeedUrl; ?></a> (<?php echo $feedCianComplexCount; ?>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Домклик</b>: <a target="_blank" href="<?php echo $domComplexFeedUrl; ?>"><?php echo $domComplexFeedUrl; ?></a> (<?php echo $feedDomComplexCount; ?>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Дом.рф</b>: <a target="_blank" href="<?php echo $domRfComplexFeedUrl; ?>"><?php echo $domRfComplexFeedUrl; ?></a> (<?php echo $feedDomRfComplexCount; ?>)</div>
|
||
<div style="padding: 7px 35px 15px 35px;"><b>Фид Сайт</b>: <a target="_blank" href="<?php echo $siteComplexFeedUrl; ?>"><?php echo $siteComplexFeedUrl; ?></a> (<?php echo $feedSiteComplexCount; ?>)</div>
|
||
<?php } ?>
|
||
|
||
</div>
|
||
|
||
<div class="center">
|
||
|
||
<div class="user_row row_line">
|
||
|
||
<div class="col tarif">
|
||
|
||
<p class="small">Тариф</p>
|
||
|
||
<p><b class="big pseudo"><?php echo $tarif; ?></b></p>
|
||
|
||
</div>
|
||
|
||
<div class="col days">
|
||
|
||
<p class="small">Осталось</p>
|
||
|
||
<p><b class="big"><?php echo $dney; ?></b></p>
|
||
|
||
</div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
<div class="user_row">
|
||
|
||
<div class="col director">
|
||
|
||
<p class="small">Контактное лицо</p>
|
||
|
||
<p><b class="big"><?php echo trim($agent['last_name'] . ' ' . $agent['first_name'] . ' ' . $agent['middle_name']); ?></b></p>
|
||
|
||
</div>
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Телефон</p>
|
||
|
||
<p><b class="big"><?php echo $agent['phone']; ?></b></p>
|
||
|
||
</div>
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Эл.почта</p>
|
||
|
||
<p><b class="big"><?php echo $agent['email']; ?></b></p>
|
||
|
||
</div>
|
||
<div class="col">
|
||
|
||
<p class="small">Регион</p>
|
||
|
||
<p><b class="big"><?php echo $agent['name'] ?></b></p>
|
||
|
||
</div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
<?php
|
||
|
||
if(!isset($_GET['agent']))
|
||
|
||
{
|
||
|
||
?>
|
||
|
||
<div class="user_row row_line employes">
|
||
|
||
<h3 class="employ">Сотрудники
|
||
|
||
<label class="fl-right hidden">
|
||
|
||
<span class="fr-btn edit-btn steel i-btn very-small tr_agency" data-id='<?php echo $agent['id']; ?>'>
|
||
|
||
Развернуть
|
||
|
||
</span>
|
||
|
||
</label>
|
||
|
||
</h3>
|
||
|
||
<div class="switch__filter filter-changer">
|
||
|
||
<ul>
|
||
|
||
<?php
|
||
$blockUsers = 0;
|
||
$managersCount = User::countAllManagers($agent['id']);
|
||
$usersCount = User::getAllAgents($agent['id']);
|
||
foreach ($usersCount as $key => $value) {
|
||
if($value["blocked"] == 1)
|
||
$blockUsers=$blockUsers+1;
|
||
}
|
||
|
||
?>
|
||
|
||
<li><a href="" class="pseudo show_managers" data-id='<?php echo $agent['id']; ?>'>Менеджеры <span style="color: #4CAF50; font-weight: bold;">(<?php echo $managersCount ?>)</span></a></li>
|
||
|
||
<li><a href="" class="pseudo show_agents" data-id='<?php echo $agent['id']; ?>'>Агенты <span style="color: #4CAF50; font-weight: bold;">(<?php echo count($usersCount); ?>)</span></a></li>
|
||
|
||
<li>Всего <span style="color: #4CAF50; font-weight: bold;"><?php echo (int)count($usersCount) + (int)$managersCount - (int)$blockUsers; ?></span></li>
|
||
|
||
</ul>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
<div id='a<?php echo $agent['id']; ?>' class="hidden">
|
||
|
||
<div class="one-user user_row row_line row_head">
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Имя</p>
|
||
|
||
</div>
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Телефон</p>
|
||
|
||
</div>
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Эл.почта</p>
|
||
|
||
</div>
|
||
|
||
<div class="col">
|
||
|
||
<p class="small">Онлайн</p>
|
||
|
||
</div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
<div id='b<?php echo $agent['id']; ?>'></div>
|
||
|
||
</div>
|
||
|
||
<?php
|
||
|
||
}
|
||
|
||
?>
|
||
|
||
</div>
|
||
|
||
<div class="bottom">
|
||
|
||
<?php if($_SESSION['id'] != $agent['id']) : ?>
|
||
|
||
<span><a href='<?php echo "?$url_params_with_page&blocked=$new_block&id_user=$agent[id]"; ?>' class="fr-btn edit-btn steel i-btn very-small"><?php echo $word_blocked; ?></a></span>
|
||
|
||
<?php endif; ?>
|
||
|
||
<?php if ($agent['agency'] == 1 && $agent['agent'] == 1) {?>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small switch-newbuildings" data-id="<?php echo $agent['id']; ?>"><?php if ($agent['newbuildings_access']) { echo "Выключить новостройки"; } else { echo "Включить новостройки"; }?></a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small switch-wazzap" data-id="<?php echo $agent['id']; ?>"><?php if ($agent['enable_wazzap']) { echo "Выключить Wazzup"; } else { echo "Включить Wazzup"; }?></a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small zipal-settings" data-id="<?php echo $agent['id']; ?>">Настройки Zipal - <?php if ($agent['zipal_login'] || $agent['zipal_password'] || $agent['zipal_balance']) { echo "Заполнено"; } else { echo "Пусто"; }?></a></span>
|
||
<?php } ?>
|
||
|
||
<?php if ($agent['agency'] == 0 && $agent['agent'] == 1) {?>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small zipal-settings" data-id="<?php echo $agent['id']; ?>">Настройки Zipal - <?php if ($agent['zipal_login'] || $agent['zipal_password'] || $agent['zipal_balance']) { echo "Заполнено"; } else { echo "Пусто"; }?></a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small switch-wazzap" data-id="<?php echo $agent['id']; ?>"><?php if ($agent['enable_wazzap']) { echo "Выключить Wazzup"; } else { echo "Включить Wazzup"; }?></a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small presentation-settings" data-id="<?php echo $agent['id']; ?>">Каталог новостроек</a></span>
|
||
<?php } ?>
|
||
|
||
<?php if ($agent['agency'] == 1 || $agent['role_developer'] == 1) {?>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small presentation-settings" data-id="<?php echo $agent['id']; ?>">Каталог новостроек</a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small switch-wazzap" data-id="<?php echo $agent['id']; ?>"><?php if ($agent['enable_wazzap']) { echo "Выключить Wazzup"; } else { echo "Включить Wazzup"; }?></a></span>
|
||
<span><a href="javascript:void(0);" class="fr-btn edit-btn steel i-btn very-small complex-iframe" data-id="<?php echo $agent['id']; ?>">Каталог комплексов</a></span>
|
||
<?php } ?>
|
||
|
||
<div class="admin-comment">
|
||
<div class="admin_comment_modal" id="admin_comment_<?php echo $agent['id']; ?>" style="display: none">
|
||
<textarea id="admin_comment_text_<?php echo $agent['id']; ?>"><?php echo $agent['comment']; ?></textarea>
|
||
<button class="fr-btn edit-btn steel close_admin_comment" data-id="<?php echo $agent['id']; ?>">Сохранить</button>
|
||
</div>
|
||
|
||
<span class="new_comment_btn"><a class="open_admin_comment fr-btn edit-btn steel i-btn very-small" data-id="<?php echo $agent['id']; ?>">Комментарий</a></span>
|
||
</div>
|
||
|
||
<div class="agent-new-password" style="display: inline-block;">
|
||
<div class="agent_pass_change_" id="agent_new_pass_for_<?php echo $agent['id']; ?>">
|
||
<input class="new_password_inp" style="margin-right: 15px; padding: 4px 10px; font-size: 12px;" autocomplete="new-password" placeholder="Введите новый пароль" type="password" id="new_password_for_<?php echo $agent['id']; ?>">
|
||
<button style="margin-right: 20px;" class="fr-btn edit-btn steel close_new_password very-small" data-id="<?php echo $agent['id']; ?>">Сохранить</button>
|
||
</div>
|
||
<span class="new_password_btn">
|
||
<a class="open_agent_new_password fr-btn edit-btn steel i-btn very-small" data-id="<?php echo $agent['id']; ?>">Изменить пароль</a>
|
||
</span>
|
||
</div>
|
||
|
||
<?php if ($agent['agency'] == 1 && $agent['agent'] == 1) {?>
|
||
<div class="checkbox small" style="margin-bottom: 10px; display: inline; width: 196px;">
|
||
<input id="is_moderation_advert_objetcs_<?=$agent['id']?>" class="advert_moderation" type="checkbox" value="1" data-id="<?php echo $agent['id']; ?>" <?=($agent['moderation_advert'] == 1) ? 'checked':''?>>
|
||
<label for="is_moderation_advert_objetcs_<?=$agent['id']?>">Модерация рекламы</label>
|
||
</div>
|
||
<!-- PRESENTATION FRAME -->
|
||
<div class="checkbox small" style="margin-bottom: 10px; display: inline; width: 196px; margin-left: 15px;">
|
||
<input id="presentation_frame_checkbox<?=$agent['id']?>" class="presentation_frame" type="checkbox" value="1" data-id="<?php echo $agent['id']; ?>" <?=($agent['presentation_frame'] == 1) ? 'checked':''?>>
|
||
<label for="presentation_frame_checkbox<?=$agent['id']?>">Презентация по региону</label>
|
||
</div>
|
||
<?php } ?>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
<?php
|
||
|
||
}
|
||
|
||
|
||
echo '<div class="f-system_pagination" style="padding: 20px 20px 0 20px;"><ul class="pagination">';
|
||
|
||
if($all_pages > 1) {
|
||
|
||
num_of_pages($page, $all_pages, $url_params);
|
||
|
||
}
|
||
|
||
echo '</ul><div class="clear"></div></div>';
|
||
|
||
$cycleTime = microtime(true);
|
||
|
||
?>
|
||
|
||
</div>
|
||
|
||
|
||
|
||
<div class="full_modal-bg" id="changeTarif_bg" style="display: none;">
|
||
|
||
<span class="pseudo-link closer" onclick="hidechangeTarif(); return false;"><i class="ti-close"></i></span>
|
||
|
||
<div class="full_modal" id="changeTarif" style="display: none;">
|
||
|
||
<form>
|
||
|
||
<div class="modal-form">
|
||
|
||
<div class="modal-inner">
|
||
|
||
<h2>Тариф</h2>
|
||
|
||
<div class="form-block">
|
||
|
||
<div class="label">Тариф</div>
|
||
|
||
<div class="inputs">
|
||
|
||
<select name="id_tarif">
|
||
|
||
<?php
|
||
|
||
$trfs = Tarif::getAll();
|
||
|
||
foreach ($trfs as $i => $trf) {
|
||
|
||
if($trf['status'] == 1) $st = "style='background:rgba(234, 140, 140, 0.5);'"; else $st = "";
|
||
|
||
echo "<option value='$trf[id]' $st>$trf[nazv]</option>";
|
||
|
||
}
|
||
|
||
?>
|
||
|
||
</select>
|
||
|
||
</div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
<div class="modal-submit">
|
||
|
||
<input type="hidden" name="id_user" value="0">
|
||
<?php
|
||
if (isset($_GET['page'])) {
|
||
?>
|
||
<input type="hidden" name="page" value="<?php echo $_GET['page']?>">
|
||
<?php
|
||
}
|
||
?>
|
||
<?php
|
||
if (isset($_GET['search'])) {
|
||
?>
|
||
<input type="hidden" name="search" value="<?php echo $_GET['search']?>">
|
||
<?php
|
||
}
|
||
?>
|
||
<?php if (isset($_GET['agent'])) {
|
||
?>
|
||
<input type="hidden" name="agent" value="<?php echo $_GET['agent']?>">
|
||
<?php
|
||
}
|
||
?>
|
||
|
||
<button type="submit" name="ok_tarif" value="1">Сохранить</button>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
|
||
</form>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
<script src="/js/admin-edit.js?t=<?php echo ceil(microtime(true)); ?>"></script>
|
||
<?php
|
||
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/templates/footer-admin.php");
|
||
|
||
$endtime = microtime(true);
|
||
|
||
//printf("Users get in %f seconds", $getUsersTime - $starttime );
|
||
//echo '<br/>';
|
||
//printf("Users cycle in %f seconds", $cycleTime - $starttime );
|
||
//echo '<br/>';
|
||
//printf("Page loaded in %f seconds", $endtime - $starttime );
|
||
|
||
?>
|