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;
}
?>
= TRANS('PROBLEM_TYPES'); ?>
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'])) {
?>
= TRANS('CONFIRM_REMOVE'); ?> ?
= TRANS('MANAGE_RELATED_ITENS'); ?>:
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['problema']; ?> |
= toHtml($row['prob_descricao']); ?> |
= $linkedAreas . $listAreas; ?> |
= ($row['slas_desc'] == '' ? TRANS('MSG_NOT_DEFINED') : $row['slas_desc']); ?> |
= ($row['probt1_desc'] == '' ? '' : $row['probt1_desc']); ?> |
= ($row['probt2_desc'] == '' ? '' : $row['probt2_desc']); ?> |
= ($row['probt3_desc'] == '' ? '' : $row['probt3_desc']); ?> |
= ($row['probt4_desc'] == '' ? '' : $row['probt4_desc']); ?> |
= ($row['probt5_desc'] == '' ? '' : $row['probt5_desc']); ?> |
= ($row['probt6_desc'] == '' ? '' : $row['probt6_desc']); ?> |
= $active; ?> |
= $need_authorization_signal; ?> |
= $card_in_dashboard; ?> |
|
|
= TRANS('NEW_RECORD'); ?>
fetch();
$area_default = $row['prob_area_default'];
?>
= TRANS('BT_EDIT'); ?>