query($qrymsgdefault);
$rowmsgdefault = $execqrydefault->fetch();
$query = "SELECT c.*, a.*
FROM configusercall as c, sistemas as a
WHERE c.conf_opentoarea = a.sis_id and c.conf_cod <> 1"; //codigo 1 é reservado para as definicoes globais
if (isset($_GET['cod'])) {
$query .= " AND c.conf_cod = '" . (int)$_GET['cod'] . "' ";
}
$query .= " ORDER BY conf_name";
$resultado = $conn->query($query);
$registros = $resultado->rowCount();
if ((!isset($_GET['action'])) && !isset($_POST['submit'])) {
?>
= TRANS('REMOVE'); ?>
= TRANS('CONFIRM_REMOVE'); ?> ?
= TRANS('SCREEN_PROFILE_NAME'); ?>
= TRANS('DESTINY_AREA'); ?>
= TRANS('APLIED_TO'); ?>
= TRANS('PROBLEM_TYPES'); ?>
= TRANS('FIELDS_ENABLED'); ?>
= TRANS('BT_EDIT'); ?>
= TRANS('BT_REMOVE'); ?>
fetchall() as $row) {
/* Campos habilitados */
$fieldsInProfile = [];
$customFieldsInProfile = [];
foreach ($fields as $tableField => $label) {
if ($row[$tableField]) {
$fieldsInProfile[] = $label;
}
}
/* Campos personalizados (vinculados ao perfil) não exibidos na tela de abertura */
$customFieldsOnlyEdition = [];
$only_edition_fields_id = [];
if ($row['cfields_only_edition']) {
$only_edition_fields_id = explode(',', $row['cfields_only_edition']);
$custom_fields = getCustomFields($conn, null, 'ocorrencias');
foreach ($custom_fields as $cfield) {
if (in_array($cfield['id'], $only_edition_fields_id)) {
$customFieldsOnlyEdition[] = $cfield['field_label'];
}
}
}
/* Campos personalizados */
if ($row['conf_scr_custom_ids']) {
$fields_id = explode(',', $row['conf_scr_custom_ids']);
$custom_fields = getCustomFields($conn, null, 'ocorrencias');
foreach ($custom_fields as $cfield) {
// if (in_array($cfield['id'], $fields_id)) {
if (in_array($cfield['id'], $fields_id) && !in_array($cfield['id'], $only_edition_fields_id)) {
$customFieldsInProfile[] = $cfield['field_label'];
}
}
}
$listAreasIn = "";
$sqlIn = "SELECT * FROM sistemas where sis_screen='" . $row['conf_cod'] . "' ORDER BY sistema";
$resIn = $conn->query($sqlIn);
foreach ($resIn->fetchall() as $rowIn) {
$listAreasIn .= '
' . $rowIn['sistema'] ?? '' . '
';
}
$listIssuesIn = "";
$sqlIn = "SELECT * FROM problemas WHERE prob_profile_form = '" . $row['conf_cod'] . "' ORDER BY problema";
$resIn = $conn->query($sqlIn);
foreach ($resIn->fetchall() as $rowIn) {
$listIssuesIn .= '
fetch();
/* Recebe os valores de obrigatorieda para cada campo onde se aplica */
$required_fields = getFormRequiredInfo($conn, $row['conf_cod']);
/* Atualizar campos personalizados que foram desativados ou excluídos */
?>