top.window.location = '../../index.php'"; $_SESSION['session_expired'] = 1; echo ""; exit; } require_once __DIR__ . "/" . "../../includes/include_geral_new.inc.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1); $_SESSION['s_page_home'] = $_SERVER['PHP_SELF']; $isAdmin = $_SESSION['s_nivel'] == 1; $userAreas = explode(',', $_SESSION['s_uareas']); ?> <?= APP_NAME; ?> <?= VERSAO; ?>

 

'; $badges['error'] = ''; $badges['info'] = ''; $badges['success'] = ''; /* Checa avisos expirados */ $sql = "UPDATE avisos SET is_active = 0 WHERE expire_date < '" . date("Y-m-d") . "' "; $conn->exec($sql); $terms = ""; $operator = ""; if (!$isAdmin) { $terms = "(("; foreach ($userAreas as $uarea) { $terms .= " {$operator} (FIND_IN_SET('{$uarea}', a.area) > 0) "; $operator = "OR"; } $terms .= ") OR a.area = -1 OR a.area IS NULL) AND "; } $query = "SELECT a.*, u.*, ar.* FROM usuarios u, avisos a LEFT JOIN sistemas ar ON a.area = ar.sis_id WHERE {$terms} a.origem = u.user_id "; if (isset($_GET['cod'])) { $query .= " AND a.aviso_id = '" . $_GET['cod'] . "'"; } $query .= " ORDER BY u.nome"; try { $resultado = $conn->query($query); } catch (Exception $e) { echo message('danger', 'Ooops!', $e->getMessage() . '
' . $query, ''); return false; } $registros = $resultado->rowCount(); if ((!isset($_GET['action'])) && !isset($_POST['submit'])) { ?>

fetchall() as $row) { // $lstatus = ($row['is_active'] == 0 ? TRANS('INACTIVE') : TRANS('ACTIVE')); $lstatus = ($row['is_active'] == 0 ? "" . TRANS('INACTIVE_O') . "" : "" . TRANS('ACTIVE_O') . ""); if ($row['is_active'] == "") { // $lstatus = TRANS('MSG_NOT_DEFINED'); $lstatus = "" . TRANS('MSG_NOT_DEFINED') . ""; } $recorrent = ($row['is_recurrent'] ? '' : ''); $areaDestiny = (($row['area'] == "-1" or $row['area'] == "") ? TRANS('ALL_TREATERS_AREAS') : ""); if (empty($areaDestiny)) { $sql = "SELECT sistema FROM sistemas WHERE sis_id IN (" . $row['area'] . ") ORDER BY sistema"; try { $res = $conn->query($sql); foreach ($res->fetchall() as $rowArea) { $areaDestiny .= '
  • ' . $rowArea['sistema'] ?? '' . '
  • '; } } catch (Exception $e) { echo 'Erro: ', $e->getMessage(), "
    "; } } $noticeType = TRANS('MSG_NOT_DEFINED'); $badgeType = ""; foreach ($types as $key => $type) { if ($row['status'] == $key) { $noticeType = $type; $badgeType = $badges[$key]; } } ?>
    /> />
    fetch(); ?>
    /> />
    /> />
    /> />