top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_geral_new.inc.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $areaAdmin = 0; if (isset($_SESSION['s_area_admin']) && $_SESSION['s_area_admin'] == '1' && $_SESSION['s_nivel'] != '1') { $areaAdmin = 1; } $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 1); $currentUrl = $_SERVER['PHP_SELF']; /* Alterar o basename para ficar compatível com o data-app para marcação no menu lateral */ $dataAppUrl = str_replace(basename($currentUrl), 'types_of_issues.php', $currentUrl); $_SESSION['s_page_admin'] = $dataAppUrl; $enableCostConfig = false; $config = getConfig($conn); if (!empty($config['tickets_cost_field'])) { $enableCostConfig = true; } ?> <?= APP_NAME; ?> <?= VERSAO; ?>

 

query($qry_config); $row_config = $exec_config->fetch(); $query = "SELECT DISTINCT p.prob_id, p.problema, p.prob_sla, p.prob_tipo_1, p.prob_tipo_2, p.prob_tipo_3, p.prob_tipo_4, p.prob_tipo_5, p.prob_tipo_6, p.prob_descricao, p.prob_active, p.prob_profile_form, p.prob_area_default, p.need_authorization, p.card_in_costdash, sl.slas_desc, sl.slas_cod, pt1.probt1_desc, pt2.probt2_desc, pt3.probt3_desc, pt4.probt4_desc, pt5.probt5_desc, pt6.probt6_desc FROM areas_x_issues as ai, problemas as p LEFT JOIN sla_solucao as sl on sl.slas_cod = p.prob_sla LEFT JOIN prob_tipo_1 as pt1 on pt1.probt1_cod = p.prob_tipo_1 LEFT JOIN prob_tipo_2 as pt2 on pt2.probt2_cod = p.prob_tipo_2 LEFT JOIN prob_tipo_3 as pt3 on pt3.probt3_cod = p.prob_tipo_3 LEFT JOIN prob_tipo_4 as pt4 on pt4.probt4_cod = p.prob_tipo_4 LEFT JOIN prob_tipo_5 as pt5 on pt5.probt5_cod = p.prob_tipo_5 LEFT JOIN prob_tipo_6 as pt6 on pt6.probt6_cod = p.prob_tipo_6 WHERE p.prob_id = ai.prob_id "; $COD = (isset($_GET['cod']) && !empty($_GET['cod']) ? noHtml($_GET['cod']) : ''); if (!empty($COD)) { $query .= " AND p.prob_id = '{$COD}' "; } $areaID = (isset($_GET['area']) && !empty($_GET['area']) ? noHtml($_GET['area']) : ''); if (!empty($areaID)) { $query .= " AND (ai.area_id = '{$areaID}' OR ai.area_id IS NULL) "; } $query .= " ORDER BY p.problema"; $resultado = $conn->query($query); $registros = $resultado->rowCount(); $receiverAreas = getAreas($conn, 0, 1, 1); $receiverAreasJs = json_encode($receiverAreas); $area_default = ""; if ((!isset($_GET['action'])) && !isset($_POST['submit'])) { ?>

: 

fetchall() as $row) { $area_default = $row['prob_area_default']; $active = ($row['prob_active'] ? '' : ''); $inactive_class = (empty($active) ? 'table-danger' : ''); $listAreas = ""; $need_authorization_signal = ($row['need_authorization'] ? '' : ''); $card_in_dashboard = ($row['card_in_costdash'] ? '' : ''); if (count($hiddenInAreas = hiddenAreasByIssue($conn, $row['prob_id']))) { $listAreas = '

' . TRANS('EXCEPT') . ':

'; foreach ($hiddenInAreas as $area) { $listAreas .= '
  • ' . $area['area_name'] ?? '' . '
  • '; } } $areasByIssue = getAreasByIssue($conn, $row['prob_id'], TRANS('ALL_A')); $linkedAreas = ""; foreach ($areasByIssue as $areaByIssue) { if ($areaByIssue['sistema'] != TRANS('ALL_A')) { $boldDefaulArea = ""; if ($areaByIssue['sis_id'] == $area_default) { $boldDefaulArea = "font-weight-bold"; } $linkedAreas .= '
  • ' . $areaByIssue['sistema'] ?? '' . '
  • '; } else { $linkedAreas .= '
  • ' . $areaByIssue['sistema'] ?? '' . '
  • '; } } $td_class = (empty($listAreas) ? 'except_areas' : ''); ?>
    ' : $row['probt1_desc']); ?> ' : $row['probt2_desc']); ?> ' : $row['probt3_desc']); ?> ' : $row['probt4_desc']); ?> ' : $row['probt5_desc']); ?> ' : $row['probt6_desc']); ?>
    .
    /> />
    /> />
    fetch(); $area_default = $row['prob_area_default']; ?>
    .
    /> />
    /> />
    /> />