$resultref = db_query($sqlref);
$linhasref = pg_num_rows($resultref);
if ($linhasref > 0) {
db_fieldsmemory($resultref, 0);
$matricula1 = $j40_matric;
$matricula = $j40_matric;
}
}
if (isset($inscricao)) {
$q02_inscr = $inscricao;
}
//busca dados para armazemar em cookies
if (@$_COOKIE["cookie_codigo_cgm"] == "") {
// issbase
if (@$inscricaow != "") {
@($result = $clissbase->sql_record($clissbase->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "issbase.q02_inscr = {$inscricaow} and trim(cgm.z01_cgccpf) = '{$cgccpf}'")));
@($linhas1 = $clissbase->numrows);
} else {
if (!empty($codigo_cgm) || !empty($cgc) || !empty($cpf)) {
//CGM
if (!empty($codigo_cgm)) {
$condicao = "cgm.z01_numcgm = {$codigo_cgm}";
} else {
if (!empty($cgccpf)) {
$condicao = "trim(cgm.z01_cgccpf) = '{$cgccpf}'";
}
}
@($result = $clcgm->sql_record($clcgm->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", $condicao)));
@($linhas2 = $clcgm->numrows);
} else {
if (@$matricula1 != "") {
$pdf->Cell(34, 4, "TIPO LANÇAMENTO ", 1, 1, "C", 1);
$pdf->SetFillColor(255);
for ($x = 0; $x < $numrows; $x++) {
$total += $i;
db_fieldsmemory($result, $x);
$sP12_cnpj = convert_CPFCNPJ($p12_cnpj);
if (strlen($sP12_cnpj) >= 14) {
$cgccpf = db_formatar($sP12_cnpj, 'cnpj');
} else {
$cgccpf = db_formatar($sP12_cnpj, 'cpf');
}
$pdf->SetFont($Letra, 'I', 6);
$pdf->Cell(25, 4, "" . $p12_inscr, 1, 0, "C", 1);
$pdf->Cell(35, 4, "" . $cgccpf, 1, 0, "C", 1);
$pdf->Cell(26, 4, "" . $p12_fone, 1, 0, "C", 1);
$result1 = $clissbase->sql_record($clissbase->sql_query("", "z01_nome", "", " issbase.q02_inscr = {$p12_inscr}"));
db_fieldsmemory($result1, 0);
$pdf->Cell(70, 4, "" . $z01_nome, 1, 0, "L", 1);
if (isset($p12_tipolanc) && $p12_tipolanc == 1) {
$pdf->Cell(34, 4, "" . "CLIENTE NOVO", 1, 1, "L", 1);
} else {
$pdf->Cell(34, 4, "" . "EX CLIENTE", 1, 1, "L", 1);
}
if ($pdf->GetY() > 270) {
$pdf->AddPage();
$pdf->SetFillColor(235);
$pdf->Cell(25, 4, "INSCRIÇÃO ", 1, 0, "C", 1);
$pdf->Cell(35, 4, "CNPJ ", 1, 0, "C", 1);
$pdf->Cell(26, 4, "TELEFONE ", 1, 0, "C", 1);
$pdf->Cell(70, 4, "NOME ", 1, 1, "C", 1);
$pdf->Cell(34, 4, "TIPO LANÇAMENTO ", 1, 1, "C", 1);
if (isset($sTipo) && $sTipo == 1) {
$campos = "cgm.z01_nome,cgm.z01_cgccpf ";
$sql = " select {$campos} ";
$sql .= " from issbase ";
$sql .= " inner join cgm on cgm.z01_numcgm = issbase.q02_numcgm ";
$sql .= " left join escrito e on e.q10_inscr = q02_inscr ";
$sql .= " where issbase.q02_inscr = {$pesquisa_chave} ";
$sql .= " \t and q02_dtbaix is null ";
$sql .= "\t and not exists( select p12_inscr ";
$sql .= "\t \t\t\t\t from listainscr ";
$sql .= "\t \t\t\t\t inner join listainscrcab on p11_codigo = p12_codigo ";
$sql .= "\t \t\t\t\t where p11_processado is false ";
$sql .= "\t \t\t\t\t and p12_inscr = q02_inscr limit 1) ";
$sql .= " and ( not exists ( select q10_inscr from escrito where escrito.q10_inscr = q02_inscr limit 1 ) ";
$sql .= " or e.q10_dtfim is not null) ";
$result = $clissbase->sql_record($sql);
if ($clissbase->numrows != 0) {
db_fieldsmemory($result, 0);
echo "<script>" . $funcao_js . "(\"{$z01_nome}\",\"\",false);</script>";
} else {
echo "<script>" . $funcao_js . "('Inscrição " . $pesquisa_chave . " não encontrado ou já está sendo utilizado','',true);</script>";
}
} else {
if (isset($sTipo) && $sTipo == 0) {
$campos = "cgm.z01_nome,cgm.z01_cgccpf,q02_dtbaix";
$sql = " select {$campos} ";
$sql .= " from issbase ";
$sql .= " inner join cgm on cgm.z01_numcgm = issbase.q02_numcgm";
$sql .= " left join escrito on escrito.q10_inscr = q02_inscr";
$sql .= " where issbase.q02_inscr = {$pesquisa_chave} ";
$result = $clissbase->sql_record($sql);
echo"<script>location.href='index.php?".base64_encode('erroscripts=3')."'</script>";
} */
mens_help();
db_mensagem("dae_cab", "dae_rod");
$dblink = "index.php";
$db_verificaip = db_verifica_ip();
if ($db_verificaip == "0") {
$onsubmit = "onsubmit=\"return js_verificaCGCCPF((this.cgc.value==''?'':this.cgc),'');\"";
} else {
$onsubmit = "";
}
//busca dados para armazemar em cookies
if (@$_COOKIE["cookie_codigo_cgm"] == "") {
// issbase
if (@$inscricaow != "") {
$result = $clissbase->sql_record($clissbase->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "issbase.q02_inscr = {$inscricaow}"));
$linhas1 = $clissbase->numrows;
}
// cgm
if (@$codigo_cgm != "") {
$result = $clcgm->sql_record($clcgm->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "cgm.z01_numcgm = {$codigo_cgm}"));
$linhas2 = $clcgm->numrows;
}
// iptu
if (@$matricula1 != "") {
$result = $cliptubase->sql_record($cliptubase->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "iptubase.j01_matric = {$matricula1}"));
$linhas3 = $cliptubase->numrows;
}
db_fieldsmemory($result, 0);
@setcookie("cookie_codigo_cgm", $z01_numcgm);
@setcookie("cookie_nome_cgm", $z01_nome);
}
*/
mens_help();
db_mensagem("aidof_cab", "aidof_rod");
$db_verificaip = db_verifica_ip();
if ($db_verificaip == "0") {
$onsubmit = "onsubmit=\"return js_verificaCGCCPF((this.cgc.value==''?'':this.cgc),'');\"";
} else {
$onsubmit = "";
}
//verifica se está logado
if (@$id_usuario != "" || @$_COOKIE["cookie_codigo_cgm"] != "") {
if (@$id_usuario == "") {
$id_usuario = $_COOKIE["cookie_codigo_cgm"];
}
$result = $clissbase->sql_record($clissbase->sql_query("", "issbase.q02_inscr,z01_nome,z01_cgccpf", "", "q02_numcgm = {$id_usuario}"));
$linhas = $clissbase->numrows;
if ($linhas != 0) {
db_fieldsmemory($result, 0);
//11 14
if (strlen($z01_cgccpf) > 11) {
//armazena em var
$var_cnpj = $z01_cgccpf;
}
}
}
?>
<html>
<head>
<title><?php
echo $w01_titulo;
$sqlconf = "select db21_regracgmiptu, db21_regracgmiss from db_config where codigo = {$instit}";
$resconf = pg_query($sqlconf);
$iconf = pg_num_rows($resconf);
if ($iconf > 0) {
db_fieldsmemory($resconf, 0);
}
$sQueryCndPorNome = "select * from configdbpref where w13_instit = {$instit}";
$resQueryCndPorNome = pg_query($sQueryCndPorNome);
$iQueryCndPorNome = pg_num_rows($resQueryCndPorNome);
if ($iQueryCndPorNome > 0) {
db_fieldsmemory($resQueryCndPorNome, 0);
}
if (isset($id_usuario) and $id_usuario != "") {
$numcgm = $id_usuario;
// issbase
$result1 = $clissbase->sql_record($clissbase->sql_query("", "issbase.q02_inscr", "", "cgm.z01_numcgm = {$numcgm}"));
$linhas1 = $clissbase->numrows;
// iptu
$sqlpromitente = $cliptubase->sqlmatriculas_nome_numero($numcgm, $db21_regracgmiptu);
$result2 = pg_query($sqlpromitente);
$linhas2 = pg_num_rows($result2);
if (isset($linhas1) && $linhas1 > 0) {
db_fieldsmemory($result1, 0);
}
}
if (isset($oPost->pesquisa) && $oPost->pesquisa == "Pesquisa") {
if (isset($oPost->cgc) && $oPost->cgc != "") {
$cgccpf = $oPost->cgc;
}
if (isset($oPost->cpf) && $oPost->cpf != "") {
$cgccpf = $oPost->cpf;
$matricula1 = $j40_matric;
$matricula = $j40_matric;
}
}
if (isset($inscricao)) {
$q02_inscr = $inscricao;
}
//busca dados para armazemar em cookies
if (@$_COOKIE["cookie_codigo_cgm"] == "") {
// issbase
if (@$inscricaow != "") {
$sWhereCPFCNPJ = "";
if ($sConfig["w13_exigecpfcnpjinscricao"] == "t") {
$sWhereCPFCNPJ = "and trim(cgm.z01_cgccpf) = '{$cgccpf}'";
}
@($result = $clissbase->sql_record($clissbase->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "issbase.q02_inscr = {$inscricaow} {$sWhereCPFCNPJ}")));
@($linhas1 = $clissbase->numrows);
} else {
if (!empty($codigo_cgm) || !empty($cgc) || !empty($cpf)) {
//CGM
if (!empty($codigo_cgm)) {
$condicao = "cgm.z01_numcgm = {$codigo_cgm}";
} else {
if (!empty($cgccpf)) {
$condicao = "trim(cgm.z01_cgccpf) = '{$cgccpf}'";
}
}
@($result = $clcgm->sql_record($clcgm->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", $condicao)));
@($linhas2 = $clcgm->numrows);
} else {
if (@$matricula1 != "") {
include "classes/db_issbase_classe.php";
include "classes/db_aidof_classe.php";
$clarreinscr = new cl_arreinscr();
$clissbase = new cl_issbase();
$claidof = new cl_aidof();
$sqlmenu = "SELECT distinct m_publico,m_arquivo,m_descricao\n FROM db_menupref\n WHERE trim(m_arquivo) = 'digitaaidof.php'\n ORDER BY m_descricao\n ";
$result = pg_query($sqlmenu);
db_fieldsmemory($result, 0);
//if($m_publico != 't'){
// if(!session_is_registered("DB_acesso"))
// echo"<script>location.href='index.php?".base64_encode('erroscripts=3')."'</script>";
//}
if (@$_COOKIE["cookie_codigo_cgm"] == "") {
// issbase
if ($inscricaow != "") {
$result = $clissbase->sql_record($clissbase->sql_query("", "cgm.z01_numcgm,cgm.z01_nome", "", "issbase.q02_inscr = {$inscricaow}"));
$linhas1 = $clissbase->numrows;
db_fieldsmemory($result, 0);
setcookie("cookie_codigo_cgm", $z01_numcgm);
setcookie("cookie_nome_cgm", $z01_nome);
}
}
$db_verifica_ip = db_verifica_ip();
//mens_help();
$dblink = "digitaaidof.php";
db_logs("", "", 0, "Digita Aidof.");
postmemory($HTTP_POST_VARS);
$clquery = new cl_query();
$inscricaow != "" ? "" : ($inscricaow = 0);
if (!empty($cgc)) {
$cgccpf = $cgc;
?>
</style>
<link href="config/estilos.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="<?php
echo $w01_corbody;
?>
" onLoad="" <?php
mens_OnHelp();
?>
>
<center>
<?php
//verifica se está logado
if (@$id_usuario != "") {
@($result = $clissbase->sql_record($clissbase->sql_query("", "issbase.q02_inscr,z01_nome,z01_cgccpf", "", "q02_numcgm = {$id_usuario}")));
@($linhas = $clissbase->numrows);
if ($linhas != 0) {
db_fieldsmemory($result, 0);
//11 14
if (strlen($z01_cgccpf) > 11) {
//armazena em var
$var_cnpj = $z01_cgccpf;
}
} else {
$sql_z01_cgccpf = pg_query("SELECT cgm.z01_cgccpf FROM cgm WHERE z01_numcgm = {$id_usuario}");
$rRetorno = pg_fetch_assoc($sql_z01_cgccpf);
$var_cnpj = $rRetorno['z01_cgccpf'];
}
?>
<form name="form1" method="post" action="" enctype="multipart/form-data">
if (pg_numrows($resultpref) != 0) {
db_fieldsmemory($resultpref, 0);
}
$result_aidof = $claidof->sql_record($claidof->sql_query_file($codaidof));
if ($claidof->numrows != 0) {
db_fieldsmemory($result_aidof, 0);
}
$result_notasiss = $clnotasiss->sql_record($clnotasiss->sql_query_file(null, "q09_descr as especie", null, "q09_codigo={$y08_nota}"));
if ($clnotasiss->numrows != 0) {
db_fieldsmemory($result_notasiss, 0);
}
$result_graf = $clcgm->sql_record($clcgm->sql_query_file($y08_numcgm, "z01_nome as nome_graf,z01_ender as ender_graf,z01_numero as num_graf,z01_cgccpf as cgccpf_graf,z01_bairro as bairro_graf,z01_munic as munic_graf"));
if ($clcgm->numrows != 0) {
db_fieldsmemory($result_graf, 0);
}
$result_graf_inscr = $clissbase->sql_record($clissbase->sql_query_file(null, "q02_inscr as inscr_graf", null, "q02_numcgm={$y08_numcgm}"));
if ($clissbase->numrows != 0) {
db_fieldsmemory($result_graf_inscr, 0);
}
$sql_empr = "select q02_inscr as inscr_usu,z01_nome as nome_usu,z01_ender as ender_usu,z01_numero as num_usu,z01_cgccpf as cgccpf_usu,z01_bairro as bairro_usu,z01_munic as munic_usu from empresa where q02_inscr={$y08_inscr}";
$result_empresa = pg_exec($sql_empr);
if (pg_numrows($result_empresa) != 0) {
db_fieldsmemory($result_empresa, 0);
}
//***************************
$mes = date("m");
$ano = date("Y");
$dia = date("d");
$codigo = $y08_codigo;
$ins = $inscr_usu;
$cnpj = $cgccpf_usu;
