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'>";