function getListaCustomers()
{
$lg = mySx('logado', 0);
if (!$lg) {
return null;
}
$user = mySx('user');
$where = $user['pnu_is_admin'] == 1 ? '' : "WHERE pug_user_id = {$user['id_panel_users']}";
$busca = sqlQuery('main', "\r\n\t SELECT DISTINCT C.*\r\n\t FROM panel_user_groups A\r\n\t JOIN panel_group_customers B ON A.pug_group_id = B.pgc_group_id\r\n\t JOIN customers C ON B.pgc_customer_id = C.id_customers\r\n\t {$where}\r\n\t ");
$lista = array();
foreach ($busca['rows'] as $x) {
$x['cus_name'] = $x['cus_name'];
$lista[] = $x;
}
return $lista;
}
function oQuery($params)
{
$tp = myArray($params, 'tp', 'main');
$st = myArray($params, 'st', '');
$ps = myArray($params, 'ps', array());
$pdo = myArray($params, 'pdo', null);
$logIt = myArray($params, 'logIt', false);
if (!is_array($ps)) {
$ps = array($ps);
}
$code = $st . implode(',', $ps);
$ret = mySx($code, null);
if ($ret) {
return $ret;
}
$ret = sqlQuery($tp, $st, $ps, $logIt, $pdo);
setSx($code, formatSx($ret));
return $ret;
}
SELECT Min(DATE(tkt_open_date)) data_inicio
FROM trouble_tickets
WHERE tkt_customer_id = ?
', $customerID);
$datas = array();
$datas['min'] = date('Y-m-d', strtotime($x['data_inicio']));
$datas['max'] = date('Y-m-d');
// ======================================================
// MENU - CLIENTES
// ======================================================
$customers = mySx('customers');
if (count($customers) > 1) {
$i++;
$gs[$i] = new Sidebar_Group('OUTROS CLIENTES');
foreach ($customers as $x) {
if ($x['id_customers'] != mySx('customerID')) {
$gs[$i]->addLink(new Sidebar_Link($x['cus_name'], 'fa-user', 'customer' . $x['id_customers'], "?ct={$x['id_customers']}"));
}
}
}
// ======================================================
// MENU - FILTROS
// ======================================================
$i++;
$gs[$i] = new Sidebar_Group("<img src='../images/logocivis.png'/> CIVIS: Solicitações");
$gs[$i]->addLink(new Sidebar_Select('sideCategoria', $categorias));
$gs[$i]->addLink(new Sidebar_Select('sideServico', $servicos));
$gs[$i]->addLink(new Sidebar_Select('sideStatus', $status));
$gs[$i]->addLink(new Sidebar_Select('sideData', $datas));
// ======================================================
// MENU - OUTROS
<?php
session_start();
include "includeAll.php";
$ct = myGet('ct', 0);
if ($ct) {
$lista = mySx('customers');
foreach ($lista as $x) {
if ($x['id_customers'] == $ct) {
setSx('customerID', $ct);
}
}
}
$customerID = mySx('customerID');
if ($customerID) {
$profiles = array();
$profiles[1] = array('cat' => 1, 'serv' => 2, 'lat' => 7, 'lng' => 8);
$profiles[2] = array('cat' => 13, 'serv' => 14, 'lat' => 19, 'lng' => 20);
$profile = $profiles[$customerID];
setSx('profile', $profile);
}
<?php
include "../../configRoot.php";
include "../../includes/requestHeader.php";
checkLogged();
$aRet = array();
function getWhere($fieldid, $cat)
{
return "\r\n\t\t\tA.id_trouble_tickets IN (\r\n\t\t\t\tSELECT ttd_ticket_id \r\n\t\t\t\tFROM trouble_ticket_data\r\n\t\t\t\tWHERE ttd_field_id = {$fieldid} AND ttd_string_value = '{$cat}'\r\n\t\t\t)";
}
// pegando o id do customer no session
$customerID = mySx('customerID');
$profile = mySx('profile');
$data = myGet('data');
$aFilters = array();
$aFilters[] = "DATE(A.tkt_open_date) <= '{$data}'";
$aFilters[] = "A.tkt_customer_id = {$customerID}";
$cat = myGet('cat', '');
if ($cat) {
$aFilters[] = getWhere($profile['cat'], $cat);
}
$serv = myGet('serv', '');
if ($serv) {
$aFilters[] = getWhere($profile['serv'], $serv);
}
$stat = myGet('stat', '');
if ($stat) {
$aFilters[] = "A.tkt_status_name = '" . $stat . "'";
} else {
$aFilters[] = "DATE(IFNULL(A.tkt_close_date,NOW())) >= '{$data}'";
}
$bold = array_shift($parts);
$rest = implode(' ', $parts);
$logoClient = "<img src='../images/logocliente{$customerID}.png' style='width:40px'>";
echo "<span style='margin-left:10px'><b>{$bold}</b> {$rest}</span>";
?>
</a>
<!-- Header Navbar: style can be found in header.less -->
<nav class="navbar navbar-static-top" role="navigation">
<a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
<span class="sr-only">Toggle navigation</span>
</a>
<div class='navbar-menu' style='float:left'>
<ul class="nav navbar-nav" style='font-size:20px; color:white'>
<li class='hidden-xs' style='padding:10px'>Painel Operacional</li>
<li class='visible-xs' style='padding:3px 15px'>Painel Operacional</li>
</ul>
</div>
<!-- Navbar Right Menu -->
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<?php
$user = mySx('user');
echo "\r\n\t\t\t\t<li class='user user-menu'>\r\n\t\t\t\t\t<a></a>\r\n\t\t\t\t</li>\r\n\t\t\t\t<li class='dropdown user user-menu'>\r\n\t\t\t\t\t<a href='../session/logout.php'>\r\n\t\t\t\t\t\t<span class='fa fa-user'></span>\r\n\t\t\t\t\t\t<span class='hidden-xs'>{$user['pnu_name']}</span> <span style='margin-left:10px'>(logout)</span>\r\n\t\t\t\t\t</a>\r\n\t\t\t\t</li>\r\n\t\t\t\t";
?>
</ul>
</div>
</nav>
</header>
$login = myPost('login', '');
$password = myPost('password', '');
$ps = array($login, $password);
$busca = sqlQuery('main', '
SELECT *
FROM panel_users
WHERE pnu_username = ? AND pnu_password = ?
', $ps);
$aRet = $busca['ret'];
if ($aRet['status'] == 1) {
if ($busca['count'] == 1) {
$user = $busca['rows'][0];
setSx('uid', $user['id_panel_users']);
setSx('user', $user);
setSx('logado', 1);
$lista = getListaCustomers();
setSx('customers', $lista);
if ($lista) {
setSx('customerID', $lista[0]['id_customers']);
}
} else {
setSx('uid', 0);
setSx('user', null);
setSx('logado', 0);
setSx('customerID', 0);
$aRet['status'] = 0;
$aRet['error'] = $lb->get('session.wrong');
}
}
$aRet['logado'] = mySx('logado', 0);
echo json_encode($aRet);
function request_convertValues($converts)
{
foreach ($converts as $cv) {
$tipoVar = $cv[0];
$nomeVar = $cv[1];
$tipoConvert = isset($cv[2]) ? $cv[2] : '';
$formatCheck = isset($cv[3]) ? $cv[3] : '';
$formatTrue = isset($cv[4]) ? $cv[4] : '';
if ($tipoVar == 'session') {
$valor = mySx($nomeVar);
}
if ($tipoVar == 'post') {
$valor = myPost($nomeVar);
}
if ($tipoConvert == 'date') {
if (date($formatCheck, strtotime($valor)) == $valor) {
$valor = date($formatTrue, strtotime($valor));
} else {
$valor = '';
}
}
if ($tipoVar == 'session') {
$_SESSION[$nomeVar] = $valor;
}
if ($tipoVar == 'post') {
$_POST[$nomeVar] = $valor;
}
}
}
