if (isset($_POST['search']) || isset($_SESSION['id_sistema_filtro'])) {
!$WHERE ? $query .= " WHERE p.problema IS NOT NULL" : ($query .= " AND p.problema IS NOT NULL");
if (isset($_SESSION['id_sistema_filtro']) && $_SESSION['id_sistema_filtro'] != '-1') {
$query .= " AND p.prob_area = " . $_SESSION['id_sistema_filtro'];
}
if (isset($_POST['search']) && !empty($_POST['search'])) {
$query .= " AND lower(p.problema) like lower(('%" . noHtml($_POST['search']) . "%')) ";
}
}
}
//------------------------------------------------------------- FIM ALTERACAO --------------------------------------------------------------
$query .= " ORDER BY s.sistema, p.problema";
$resultado = mysql_query($query) or die(TRANS('ERR_QUERY') . "<br>" . $query);
$registros = mysql_num_rows($resultado);
if (isset($_GET['LIMIT'])) {
$PAGE->setLimit($_GET['LIMIT']);
}
$PAGE->setSQL($query, isset($_GET['FULL']) ? $_GET['FULL'] : 0);
if (!isset($_GET['action']) && empty($_POST['submit'])) {
$PAGE->execSQL();
//print "<TR><TD bgcolor='".BODY_COLOR."'><a href='".$_SERVER['PHP_SELF']."?action=incluir&cellStyle=true'>Incluir novo tipo de Problema</a></TD></TR>";
print "<TR><TD><input type='button' class='button' id='idBtIncluir' value='" . TRANS('BT_NEW_RECORD', '', 0) . "' onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=incluir&cellStyle=true');\"></TD></TR>";
print "<tr>" . "<td colspan='4'>" . "<input type='text' class='text' name='search' id='idSearch' value='" . $search . "'> ";
//------------------------------------------------------------- INICIO ALTERACAO --------------------------------------------------------------
if ($OPERADOR_AREA) {
$qryarea = "SELECT sis_id, sistema FROM sistemas WHERE sis_id = " . $_SESSION['s_area'] . " ORDER BY sistema";
} else {
$qryarea = "SELECT sis_id, sistema FROM sistemas ORDER BY sistema";
}
$execarea = mysql_query($qryarea);
print "<SELECT class='select' name='id_sistema' size='1'>";
