89 lines
2.3 KiB
PHP
89 lines
2.3 KiB
PHP
|
<?php
|
||
|
|
require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");
|
||
|
|
|
||
|
|
$response = [];
|
||
|
|
$response['items'] = array();
|
||
|
|
|
||
|
|
$search = null;
|
||
|
|
|
||
|
|
$page = 1;
|
||
|
|
|
||
|
|
if (isset($_POST['page'])) {
|
||
|
|
$page = $_POST['page'];
|
||
|
|
}
|
||
|
|
|
||
|
|
// Number of records fetch
|
||
|
|
$numberOfRecords = 1000;
|
||
|
|
|
||
|
|
if (isset($_POST['searchTerm'])) {
|
||
|
|
$search = $_POST['searchTerm'];// Search text
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($search == null || strpos("объекты нашей компании", strtolower($search)) !== false) {
|
||
|
|
$response['items'][] = array(
|
||
|
|
"id" => "10000",
|
||
|
|
"text" => "Объекты нашей компании"
|
||
|
|
);
|
||
|
|
$numberOfRecords--;
|
||
|
|
}
|
||
|
|
|
||
|
|
$user = new User;
|
||
|
|
$user->get($_SESSION['id']);
|
||
|
|
|
||
|
|
$blockList = [];
|
||
|
|
|
||
|
|
$sqlWhere = " `user_id` = '".$user->id."' or `manager_id` = '".$user->id."'";
|
||
|
|
if($user->id_manager){
|
||
|
|
$sqlWhere .= " or `manager_id` = '".$user->id_manager."' or `user_id` = '".$user->id_manager."'";
|
||
|
|
}
|
||
|
|
|
||
|
|
if($user -> agencyId){
|
||
|
|
$sqlWhere .= " or `manager_id` = '".$user -> agencyId."' or `user_id` = '".$user -> agencyId."'";
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($search == null) {
|
||
|
|
$sqlCount = "SELECT COUNT(id) FROM `advertising_sources` WHERE $sqlWhere";
|
||
|
|
} else {
|
||
|
|
$sqlCount = "SELECT COUNT(id) FROM `advertising_sources` WHERE ($sqlWhere) and source like '%" . trim($search) . "%'";
|
||
|
|
}
|
||
|
|
$rez = mysql_query($sqlCount);
|
||
|
|
$allCount = mysql_result($rez, 0);
|
||
|
|
|
||
|
|
$all_pages = ceil($allCount / $numberOfRecords);
|
||
|
|
|
||
|
|
$ot = ($page - 1) * $numberOfRecords;
|
||
|
|
|
||
|
|
if ($search == null) {
|
||
|
|
$sql = "SELECT id, source FROM `advertising_sources` where $sqlWhere ORDER BY source, ID LIMIT $ot, $numberOfRecords";
|
||
|
|
$rez = mysql_query($sql);
|
||
|
|
while ($block = mysql_fetch_assoc($rez)) {
|
||
|
|
$blockList[] = $block;
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$sql = "SELECT id, source FROM `advertising_sources` where ($sqlWhere) and source like '%" . trim($search) . "%' ORDER BY source, ID LIMIT $ot, $numberOfRecords";
|
||
|
|
$rez = mysql_query($sql);
|
||
|
|
while ($block = mysql_fetch_assoc($rez)) {
|
||
|
|
$blockList[] = $block;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$response['total_count'] = $allCount;
|
||
|
|
|
||
|
|
// Read Data
|
||
|
|
foreach ($blockList as $block) {
|
||
|
|
$response['items'][] = array(
|
||
|
|
"id" => $block['id'],
|
||
|
|
"text" => $block['source']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($search == null || strpos("источник не выбран", strtolower($search)) !== false) {
|
||
|
|
$response['items'][] = array(
|
||
|
|
"id" => "0",
|
||
|
|
"text" => "Источник не выбран"
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
echo json_encode($response);
|
||
|
|
exit();
|