top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $post = $_POST; $areaAdmin = 0; if (isset($_SESSION['s_area_admin']) && $_SESSION['s_area_admin'] == '1' && $_SESSION['s_nivel'] != '1') { $areaAdmin = 1; } $terms = ""; if (isset($post['level']) && $post['level'] == 3) { $terms .= "AND sis_atende = 0 "; } elseif (isset($post['level']) && $post['level'] == 5) { $terms = ""; } else { $terms .= "AND sis_atende = 1 "; } if (isset($post['level']) && $post['level'] == "") { $data['']['sistema'] = TRANS('SEL_LEVEL_FIRST'); echo json_encode($data); return false; } $erro = false; $mensagem = ""; $sql = "SELECT sis_id, sistema FROM sistemas WHERE sis_status = 1 {$terms} "; if ($areaAdmin) { $sql .= " AND sis_id = " . $_SESSION['s_area'] . " "; } $sql .= "ORDER BY sistema"; try { $res = $conn->query($sql); } catch (Exception $e) { // echo 'Erro: ', $e->getMessage(), "
"; $erro = true; $data['']['sistema'] = TRANS('NO_DATA_AVAILABLE'); echo json_encode($data); return false; } foreach ($res->fetchall() as $row) { $data[] = $row; } echo json_encode($data);