<td align="center" valign="top">
<?php
if (!isset($pesquisa_chave)) {
if (isset($campos) == false) {
$campos = "escrito.*";
}
if (isset($chave_q10_inscr) && trim($chave_q10_inscr) != "") {
$sql = $clescrito->sql_query($chave_q10_inscr, $campos, "q10_inscr");
} else {
if (isset($chave_q10_numcgm) && trim($chave_q10_numcgm) != "") {
$sql = $clescrito->sql_query("", $campos, "q10_numcgm", " q10_numcgm like '{$chave_q10_numcgm}%' ");
} else {
$sql = $clescrito->sql_query("", $campos, "q10_inscr", "");
}
}
db_lovrot($sql, 15, "()", "", $funcao_js);
} else {
$result = $clescrito->sql_record($clescrito->sql_query($pesquisa_chave));
if ($clescrito->numrows != 0) {
db_fieldsmemory($result, 0);
echo "<script>" . $funcao_js . "('{$q10_numcgm}',false);</script>";
} else {
echo "<script>" . $funcao_js . "('Chave(" . $pesquisa_chave . ") não Encontrado',true);</script>";
}
}
?>
</td>
</tr>
</table>
</body>
</html>
db_textarea("e60_resumo", 3, 40, "");
?>
</td>
</tr>
<tr>
<td align="right" nowrap title="Valor a Pagar"><strong>A pagar:</strong></td>
<td align="left" nowrap title="<?php
echo $Te60_vlranu;
?>
">
<?php
$e60_apagar = $e60_vlremp - $e60_vlranu - $e60_vlrpag;
db_input("e60_apagar", 8, "", true, "text", 3);
?>
</td>
</tr>
</table>
<div align="center" class="bold2">
LANÇAMENTOS
</div>
<?php
$sql = " select c70_codlan,\n c70_data,\n c53_descr,\n c70_valor,\n c82_reduz,\n c72_complem\n from conlancamemp\n inner join conlancam on c70_codlan = c75_codlan\n left outer join conlancampag on c82_codlan = c70_codlan\n inner join conlancamdoc on c71_codlan = c70_codlan\n inner join conhistdoc on c53_coddoc = c71_coddoc\n left join conlancamcompl on c72_codlan=c70_codlan\n where c75_numemp={$e60_numemp}\n order by c75_data, c75_codlan\n ";
db_lovrot($sql, 15, "", "", "");
?>
</body>
</html>
<script>
parent.form.abertos.disabled = true;
parent.form.todos.disabled = true;
parent.form.imprimir.disabled = true;
</script>
if (!isset($pesquisa_chave)) {
//$campos = "q03_ativid, q03_descr, q12_descr";
if (isset($chave_q03_ativ) && trim($chave_q03_ativ) != "") {
$sql = $clativid->sql_query_cboSimulacao($chave_q03_ativ, $campos, "q03_ativ", "{$where} and q03_ativ = {$chave_q03_ativ}");
} else {
if (isset($chave_q03_descr) && trim($chave_q03_descr) != "") {
$sql = $clativid->sql_query_cboSimulacao("", $campos, "q03_descr", " q03_descr like '{$chave_q03_descr}%' and {$where}");
} else {
if (isset($chave_rh70_estrutural) && trim($chave_rh70_estrutural) != "") {
$sql = $clativid->sql_query_cboSimulacao("", $campos, "rh70_estrutural", " rh70_estrutural like '%{$chave_rh70_estrutural}%' and {$where}");
} else {
$sql = $clativid->sql_query_cboSimulacao("", $campos, "q03_ativ", "{$where}");
}
}
}
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $repassa);
} else {
if ($pesquisa_chave != null && $pesquisa_chave != "") {
$result = $clativid->sql_record($clativid->sql_query($pesquisa_chave, "*", "", "{$where} and {$pesquisa_chave} = q03_ativ"));
if ($clativid->numrows != 0) {
db_fieldsmemory($result, 0);
echo "<script>" . $funcao_js . "('{$q03_descr}',false);</script>";
} else {
echo "<script>" . $funcao_js . "('Chave(" . $pesquisa_chave . ") não Encontrado',true);</script>";
}
} else {
echo "<script>" . $funcao_js . "('',false);</script>";
}
}
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table>
<tr align="center">
<td>
<?php
if ($acao == 'leitura') {
$campos = "\tx21_exerc,\n\t \t\t\t \t\t\tx21_mes,\n\t\t\t\t \t\t\tx17_descr,\n\t\t\t\t \t\t\tx21_dtleitura,\n\t\t\t\t \t\t\tx21_dtinc,\n\t\t\t\t \t\t\tx21_leitura,\n\t\t\t\t \t\t\tx21_consumo as x19_conspadrao,\n\t \t\t\tx21_consumo + x21_excesso as x21_consumo,\n\t\t\t\t \t\t\tx21_excesso\n\t\t\t\t \t\t\t";
db_lovrot($Consulta->GetAguaLeituraSQL(0, $campos), 12, '', '', 'NoMe');
} else {
if ($acao == 'hidrometros') {
db_lovrot($Consulta->GetAguaHidroMatricSQL(), 10, '', '', 'NoMe');
}
}
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center"><input type="button" value="Voltar" class="botao"
onclick="js_voltar();"></td>
</tr>
</table>
</body>
</html>
?>
</style>
</head>
<body bgcolor="<?php
echo $w01_corbody;
?>
" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table align="center" valign="top">
<tr>
<td>
<?php
$sWhere = " ov01_instit = " . db_getsession('DB_instit');
$sWhere .= " and ov09_protprocesso = {$oGet->iCodProcesso} ";
$sWhere .= " and ov22_sequencial is not null ";
$sCampos = "distinct fc_numeroouvidoria(ov01_sequencial) as ov01_numero, ";
$sCampos .= " ov01_requerente, ";
$sCampos .= " ov20_dataretorno,";
$sCampos .= " ov20_horaretorno,";
$sCampos .= " ov22_descricao, ";
$sCampos .= " ov20_informa, ";
$sCampos .= " ov20_resposta, ";
$sCampos .= " case when ov20_confirma is true then 'Sim' else 'Não' end as ov20_confirma";
$sql = $clouvidoriaatendimento->sql_query_retorno("", $sCampos, "ov01_numero", $sWhere);
db_lovrot($sql, 15);
?>
</td>
</tr>
</table>
</body>
</html>
function buscacep($cep = "", $munic = "", $log = "", $numero = "", $funcao_js = "", $domunic = "")
{
if ($domunic != "") {
$result = $this->sql_record('select * from db_config where codigo = ' . db_getsession("DB_instit"));
db_fieldsmemory($result, 0);
$sql = "select j29_cep as cep,j14_nome as endereco,'' as bairro,j14_codigo as codigorua from ruascep inner join ruas on j14_codigo = j29_codigo where j29_cep = '{$cep}'";
$result = $this->sql_record($sql);
$campos = split("\\|", $funcao_js);
if ($this->numrows > 0) {
db_fieldsmemory($result, 0);
echo "<script>" . $campos[0] . "('" . $GLOBALS['cep'] . "','" . $GLOBALS['endereco'] . "','" . $GLOBALS['munic'] . "','" . $GLOBALS['uf'] . "','" . $GLOBALS['bairro'] . "','" . $GLOBALS['codigorua'] . "')</script>";
} else {
$camposql = "db10_cep as cep,'' as endereco,db10_munic as municipio, db12_uf as estado";
$sql = $this->sql_query($cep, $camposql, "", " inner join db_uf on db10_uf = db12_codigo where db10_cep = '{$cep}' ");
$result = $this->sql_record($sql);
if ($this->numrows > 0) {
db_fieldsmemory($result, 0);
echo "<script>" . $campos[0] . "('" . $GLOBALS['cep'] . "','" . $GLOBALS['endereco'] . "','" . $GLOBALS['municipio'] . "','" . $GLOBALS['estado'] . "','','')</script>";
} else {
echo "<script>" . $campos[0] . "('','CEP inválido para o município','','','')</script>";
}
}
exit;
} elseif ($cep != "") {
// die("2");
/* $camposql = "db10_cep as cep,'' as endereco,db10_munic as municipio, db12_uf as estado";
$sql = $this->sql_query($cep,$camposql,""," inner join db_uf on db10_uf = db12_codigo where db10_cep = '$cep' ");
$result = $this->sql_record($sql);
$campos = split("\|",$funcao_js);*/
$sql = "select case when ceplogradouros.cp06_cep is null then ceplocalidades.cp05_cepinicial\t \n\t\t\t\t else ceplogradouros.cp06_cep\n\t\t\t\t\t\tend as cep, \n\t\t\t\t\t\tceplocalidades.cp05_localidades, \n\t\t\t\t ceplocalidades.cp05_sigla,\n\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\ta.cp01_bairro\n\t\t\t\t from ceplocalidades \n\t\t\t\t\t left join ceplogradouros on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade \n\t\t\t\t\t\tleft join cepbairros a on ceplogradouros.cp06_codbairroinicial = a.cp01_codbairro\n\t\t\t\t where ceplogradouros.cp06_cep = '{$cep}'";
//die($sql." sql 1");
$result = $this->sql_record($sql);
if ($this->numrows == 0) {
$sql = "select ceplocalidades.cp05_cepinicial as cep, \n\t\t\t\t\t\t\tceplocalidades.cp05_localidades, \n\t\t\t\t\t ceplocalidades.cp05_sigla\n\t\t\t\t\t from ceplocalidades \n\t\t\t\t\t where ceplocalidades.cp05_cepinicial = '{$cep}'";
$result = $this->sql_record($sql);
//die($sql." sql 2");
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $this->propagar);
exit;
} else {
//die($sql." sql 3");
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $this->propagar);
exit;
}
/*
if($this->numrows>0){
db_fieldsmemory($result,0);
echo "<script>".$campos[0]."('".$GLOBALS['cep']."','".$GLOBALS['endereco']."','".$GLOBALS['municipio']."','".$GLOBALS['estado']."','','')</script>";
exit;
}else{
$sql = ("select db11_cep as cep,db11_logradouro as endereco,x.db10_munic as municipio,y.db12_uf as estado,db11_bairro as bairro from db_ceplog inner join db_cepmunic x on x.db10_codigo = db11_codigo inner join db_uf y on x.db10_uf = y.db12_codigo where db11_cep = '$cep'");
$result = $this->sql_record($sql);
db_fieldsmemory($result,0);
echo "<script>".$campos[0]."('".$GLOBALS['cep']."','".$GLOBALS['endereco']."','".$GLOBALS['municipio']."','".$GLOBALS['estado']."','".$GLOBALS['bairro']."','')</script>";
exit;
}
*/
} elseif ($munic != "") {
if ($log != "") {
if ($numero != "") {
if ($numero % 2) {
$lado = 'I';
} else {
$lado = 'P';
}
$sql = "select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t\t case when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t\t \tend\t \n\t\t\t\t\t\t\t\t\tend \n\t\t\t\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\t\tcepbairros.cp01_bairro,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_sigla\n\t\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t\t\tinner join cepbairros on ceplogradouros.cp06_codbairroinicial = cp01_codbairro\n\t\t\t\t\t\t where ceplocalidades.cp05_localidades ilike '{$munic}%' \n\t\t\t\t\t\t\t\tand \n\t\t\t\t\t\t\t ceplogradouros.cp06_logradouro like '%{$log}%'\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_numinicial <= {$numero}\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_numfinal >= {$numero}\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_lado = '{$lado}'\n\t\t\t\t\t\t UNION\n\t\t\t\t\t\t select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\t\tcase when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t\t end\t\t \n\t\t\t\t\t end\n\t\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\t\tcepbairros.cp01_bairro,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_sigla\n\t\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t\t\tinner join cepbairros on ceplogradouros.cp06_codbairroinicial = cp01_codbairro\n\t\t\t\t\t\t where ceplocalidades.cp05_localidades ilike '{$munic}%' \n\t\t\t\t\t\t\t\tand \n\t\t\t\t\t\t\t ceplogradouros.cp06_logradouro like '%{$log}%'\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_numinicial <= {$numero}\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_numfinal >= {$numero}\n\t\t\t\t\t\t\t\tand ceplogradouros.cp06_lado = 'A'";
} else {
/*$sql = ("select db11_cep as cep,db11_logradouro as endereco,x.db10_munic as municipio,y.db12_uf as estado,db11_bairro as bairro from db_ceplog inner join db_cepmunic x on x.db10_codigo = db11_codigo inner join db_uf y on x.db10_uf = y.db12_codigo where db10_munic like '$munic%' and (db11_logsemacento like '$log%' or db11_logradouro like '$log%') "); */
$sql = "select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t\t ceplogradouros.cp06_logradouro,\t\t\t\t\t\t \n\t\t\t\t\t\t\t\tcase when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t\t end\t\t \n\t\t\t\t\t end\n\t\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\t\tceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\t\tcepbairros.cp01_bairro,\n\t\t\t\t\t\t\t\tceplocalidades.cp05_sigla\n\t\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t\t\tleft join cepbairros on ceplogradouros.cp06_codbairroinicial = cp01_codbairro\n\t\t\t\t\t\t\t\twhere ceplocalidades.cp05_localidades like '{$munic}' \n\t\t\t\t\t\t\t\t and \n\t\t\t\t\t\t\t\t ceplogradouros.cp06_logradouro like '%{$log}%'";
}
$result = $this->sql_record($sql);
//die($sql." sql 4");
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $this->propagar);
exit;
} else {
//$camposql = "db10_cep as cep,'' as endereco,db10_munic as municipio, db12_uf as estado";
//$sql = $this->sql_query($cep,$camposql,""," inner join db_uf on db10_uf = db12_codigo where db10_munic like '$munic%' ");
/* $sql = ("select db11_cep as cep,db11_logradouro as endereco,x.db10_munic as municipio,y.db12_uf as estado,db11_bairro as bairro from db_ceplog inner join db_cepmunic x on x.db10_codigo = db11_codigo inner join db_uf y on x.db10_uf = y.db12_codigo where db10_munic like '$munic%'"); */
$sql = "select case when ceplogradouros.cp06_cep is null then ceplocalidades.cp05_cepinicial\t \n\t\t\t\t\t else ceplogradouros.cp06_cep\n\t\t\t\t\t\t\tend as cep, \n\t\t\t\t\t\t\tceplocalidades.cp05_localidades, \n\t\t\t\t\t ceplocalidades.cp05_sigla,\n\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\ta.cp01_bairro\n\t\t\t\t\t from ceplocalidades \n\t\t\t\t\t\t left join ceplogradouros on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade \n\t\t\t\t\t\t\tleft join cepbairros a on ceplogradouros.cp06_codbairroinicial = a.cp01_codbairro\n\t\t\t\t\t where ceplocalidades.cp05_localidades ilike '{$munic}%'";
//die($sql." sql 5");
$result = $this->sql_record($sql);
// die($sql);
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $this->propagar);
exit;
}
} elseif ($log != "") {
//$sql = ("select db11_cep as cep,db11_logradouro as endereco,x.db10_munic as municipio,y.db12_uf as estado,db11_bairro as bairro from db_ceplog inner join db_cepmunic x on x.db10_codigo = db11_codigo inner join db_uf y on x.db10_uf = y.db12_codigo where db11_logsemacento like '$log%' or db11_logradouro like '$log%' ");
if ($numero != "") {
if ($numero % 2) {
$lado = 'I';
} else {
$lado = 'P';
}
$sql = "select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\tcase when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t\t end\t \n\t\t\t\t end \n\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t\tceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\tceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\tceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\ta.cp01_bairro,\n\t\t\t\t\t\t\tceplocalidades.cp05_sigla\n\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t\tleft join cepbairros a on ceplogradouros.cp06_codbairroinicial = a.cp01_codbairro\n\t\t\t\t\t where ceplogradouros.cp06_logradouro like '%{$log}%' \n\t\t\t\t\t\t and ceplogradouros.cp06_numinicial <= {$numero} \n\t\t\t\t\t\t\t and ceplogradouros.cp06_numfinal >= {$numero}\n\t\t\t\t\t\t and ceplogradouros.cp06_lado = '{$lado}' \n\t\t\t\t\t UNION\n\t\t\t\t\t\t select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\t case when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t end\t\t \n\t\t\t\t end\n\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t\t ceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\t ceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\t ceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\t a.cp01_bairro,\n\t\t\t\t\t\t\t ceplocalidades.cp05_sigla\n\t\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t left join cepbairros a on ceplogradouros.cp06_codbairroinicial = a.cp01_codbairro\n\t\t\t\t\t\t where ceplogradouros.cp06_logradouro like '%{$log}%'\n\t\t\t\t\t\t and ceplogradouros.cp06_numinicial <= {$numero}\n\t\t\t\t\t\t and ceplogradouros.cp06_numfinal >= {$numero}\n\t\t\t\t\t\t and ceplogradouros.cp06_lado = 'A'";
//die($sql." sql 6");
$result = $this->sql_record($sql);
} else {
$sql = "select ceplogradouros.cp06_cep as cep,\n\t\t\t\t\t ceplogradouros.cp06_logradouro,\n\t\t\t\t\t\t\tcase when ceplogradouros.cp06_lado = 'I' then 'Lado Impar'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'P' then 'Lado Par'\n\t\t\t\t else case when ceplogradouros.cp06_lado = 'A' then 'Até o fim'\n\t\t\t\t\t\t\t\t else ''\n\t\t\t\t\t\t\t\t end\t \n\t\t\t\t end\n\t\t\t\t end as cp06_lado,\n\t\t\t\t\t\t\tceplocalidades.cp05_localidades,\n\t\t\t\t\t\t\tceplogradouros.cp06_numinicial,\n\t\t\t\t\t\t\tceplogradouros.cp06_numfinal,\n\t\t\t\t\t\t\ta.cp01_bairro,\n\t\t\t\t\t\t\tceplocalidades.cp05_sigla\n\t\t\t\t\t from ceplogradouros\n\t\t\t\t\t\t inner join ceplocalidades on ceplocalidades.cp05_codlocalidades = ceplogradouros.cp06_codlocalidade\n\t\t\t\t\t\t\tleft join cepbairros a on ceplogradouros.cp06_codbairroinicial = a.cp01_codbairro\n\t\t\t\t\t where ceplogradouros.cp06_logradouro like '%{$log}%'";
//die($sql);
/*$result = $this->sql_record($sql);
db_lovrot($sql,15,"()","",$funcao_js);*/
$result = $this->sql_record($sql);
}
//die($sql." sql 7 ");
db_lovrot($sql, 15, "()", "", $funcao_js, "", "NoMe", $this->propagar);
exit;
}
}
<link rel="stylesheet" type="text/css" href="include/estilodai.css" >
<script language="JavaScript" src="scripts/db_script.js"></script>
<script language="JavaScript" src="scripts/prototype.js"></script>
<style type="text/css">
<?php
db_estilosite();
?>
</style>
</head>
<body bgcolor="<?php
echo $w01_corbody;
?>
" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table align="center" valign="top">
<tr>
<td>
<?php
$sCampos = "p61_dtandam,";
$sCampos .= "p61_hora, ";
$sCampos .= "descrdepto, ";
$sCampos .= "login, ";
$sCampos .= "p61_despacho";
$sSql = $clProcTransferProc->sql_query_andam(null, $oGet->iCodProcesso, $sCampos, "p62_codtran,p61_dtandam,p61_hora");
db_lovrot($sSql, 15);
?>
</td>
</tr>
</table>
</body>
</html>
function mostradotacao($funcao_js = null)
{
db_lovrot($this->dotacoes, 15, "()", "", $funcao_js);
}
if (isset($inscr)) {
$numpres .= " k56_inscr = {$inscr} and ";
} else {
if (isset($numcgm)) {
$numpres .= " k57_numcgm = {$numcgm} and ";
} else {
if (isset($numpre)) {
$numpres .= " notidebitos.k53_notifica = notificacao.k50_notifica and notidebitos.k53_numpre = {$numpre} and ";
} else {
$numpres = "";
}
}
}
}
$sql = $clnotificacao->sql_query("", " distinct k50_notifica,k50_dtemite,k52_hora,k51_descr,k50_obs,db_usuarios.nome,k54_data,k54_hora,k54_assinante::text,k54_obs", " k50_notifica ", $numpres . " k52_id_usuario = db_usuarios.id_usuario");
db_lovrot($sql, 10, "()", "16", "js_recebenotif|0", null, "NoMe", array(), false);
$result = pg_exec("select k03_msg from numpref where k03_anousu = " . db_getsession("DB_anousu"));
if (pg_numrows($result) != 0) {
$str = str_replace("\n", "<br>", pg_result($result, 0, 0));
?>
</td>
</tr>
<tr>
<td align="left" class="fonte"><h3>Mensagem aos Usuários:</h3></td>
</tr>
<tr>
<td class="fonte" align="justify" valign="top">
<?php
echo str_replace(" ", " ", $str);
?>
</td>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onFocus="document.form5.filtro.focus()">
<center>
<table border="0" cellspacing="5" cellpadding="0">
<tr>
<td align="center" nowrap>
<form name="form5" method="post">
<input type="text" name="filtro" value="<?php
echo @$HTTP_POST_VARS['filtro'];
?>
" onBlur="window.focus();">
<input type="hidden" name="arg" value="<?php
echo @$HTTP_POST_VARS['arg'];
?>
">
<input type="submit" name="procurar" value="Procurar">
</form>
</td>
</tr>
<tr>
<td align="center">
<?php
//db_lov($sql,15,"db_db_sysarquivo.php?".base64_encode("campo=$campo"),$HTTP_POST_VARS["filtro"]);
db_lovrot($sql, 15, "()", "", "js_envia|1|2");
?>
</td>
</tr>
</table>
</center>
</body>
</html>
