$cgc = @$aRetorno['cgc'];
$cpf = @$aRetorno['cpf'];
$opcao = @$aRetorno['opcao'];
$id_usuario = @$aRetorno['id_usuario'];
db_postmemory($_POST);
db_postmemory($_GET);
$db_datausu = date("Y-m-d");
$ano = date("Y");
$instit = db_getsession("DB_instit");
$iLogin = db_getsession("DB_login");
$db21_usasisagua = 'f';
$virgula = "";
$sK00_tipo = "";
$cgccpf = "";
$aK00_tipo = array();
$clissbase = new cl_issbase();
$clcgm = new cl_cgm();
$cliptubase = new cl_iptubase();
if (isset($matricula1) && $matricula1 == "") {
    $matricula1 = $matricula;
}
/*
 * consulta se o parâmetro do módulo prefeitura online está habilidado como true
*/
$sqlRetornoConfig = " select *                       ";
$sqlRetornoConfig .= "   from configdbpref            ";
$sqlRetornoConfig .= "  where w13_instit = {$instit}  ";
$rsRetornoConfig = db_query($sqlRetornoConfig);
$sConfig = pg_fetch_assoc($rsRetornoConfig);
$sqlinst = " select codigo as instituicao,  ";
$sqlinst .= "        db21_regracgmiptu,      ";
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
session_start();
if (isset($outro)) {
    setcookie("cookie_codigo_cgm");
    header("location:digitacontribuinte.php");
}
//include("libs/db_conecta.php");
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_cgm_classe.php";
include "classes/db_issbase_classe.php";
$clcgm = new cl_cgm();
$clissbase = new cl_issbase();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
/*$result = db_query("SELECT distinct m_publico,m_arquivo,m_descricao
                       FROM db_menupref 
                       WHERE m_arquivo = 'digitacontribuinte.php'
                       ORDER BY m_descricao
                       ");
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>";
}*/
//mens_help();
$dblink = "index.php";
db_mensagem("contribuinte_cab", "contribuinte_rod");
$db_verificaip = db_verifica_ip();
 *  02111-1307, USA.                                                  
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
require 'fpdf151/pdf1.php';
include "classes/db_listainscr_classe.php";
include "classes/db_listainscrcab_classe.php";
include "classes/db_cgm_classe.php";
include "classes/db_issbase_classe.php";
include "dbforms/db_funcoes.php";
parse_str($HTTP_SERVER_VARS['QUERY_STRING']);
$cllistainscr = new cl_listainscr();
$cllistainscrcab = new cl_listainscrcab();
$clcgm = new cl_cgm();
$clissbase = new cl_issbase();
$clrotulo = new rotulocampo();
$clrotulo->label('nome');
$result = $cllistainscr->sql_record($cllistainscr->sql_query($p12_codigo));
//die($cllistainscr->sql_query($p12_codigo));
$numrows = $cllistainscr->numrows;
$pdf = new PDF1();
$Letra = 'arial';
$pdf->SetFont($Letra, 'B', 8);
$pdf->Open();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFillColor(235);
$sSql = "select * \n            from db_config \n           where codigo = " . db_getsession('DB_instit');
$rsSql = pg_query($sSql);
 *  02111-1307, USA.                                                  
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
require "libs/db_conecta.php";
require "libs/db_stdlib.php";
include "libs/db_utils.php";
include "classes/db_issbase_classe.php";
include "dbforms/db_funcoes.php";
db_postmemory($HTTP_POST_VARS);
parse_str($HTTP_SERVER_VARS["QUERY_STRING"]);
$oGet = db_utils::postMemory($_GET);
$sTipo = $oGet->tipo;
$numcgm = $oGet->z01_numcgm;
$clissbase = new cl_issbase();
$clrotulo = new rotulocampo();
$clrotulo->label("z01_nome");
$clrotulo->label("q02_inscr");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="estilos.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/javascript" src="scripts/db_script.js"></script>
</head>
<style>
td{
  font-size: 12px
  }
</style>
 *                                                                    
 *  Voce deve ter recebido uma copia da Licenca Publica Geral GNU     
 *  junto com este programa; se nao, escreva para a Free Software     
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA          
 *  02111-1307, USA.                                                  
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_escrito_classe.php";
include "classes/db_issbase_classe.php";
$clissbase = new cl_issbase();
$clescrito = new cl_escrito();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
/*$result = pg_exec("SELECT distinct m_publico,m_arquivo,m_descricao
                       FROM db_menupref 
                       WHERE m_arquivo = 'digitadae.php'
                       ORDER BY m_descricao
                       ");
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>";
}   */
mens_help();
db_mensagem("dae_cab", "dae_rod");
$dblink = "index.php";
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
session_start();
if (isset($outro)) {
    setcookie("cookie_codigo_cgm");
    header("location:digitaaidof.php");
}
// digitaaidof -> opcoesaidof -> aidof.php(relatorio)
// obs: tirei fora o pesquisagrafica.php
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_issbase_classe.php";
$clissbase = new cl_issbase();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
$cgm = @$_SESSION["CGM"];
if ($cgm != "") {
    //  se tiver logado
    $sqlgra = "select z01_nome,z01_numcgm from cgm inner join graficas on y20_grafica = z01_numcgm where z01_numcgm={$cgm} order by z01_nome ";
    //die($sqlgra);
    $resultgra = pg_query($sqlgra);
    $linhagra = pg_num_rows($resultgra);
    if ($linhagra > 0) {
        msgbox("é grafica");
        echo "<script> location.href='aidof_grafica.php?cgm={$cgm}';</script>";
    } else {
        msgbox("não é grafica");
    }
}
 *                                licenca/licenca_pt.txt 
 */
session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "libs/db_utils.php";
include "classes/db_confsite_classe.php";
include "classes/db_issbase_classe.php";
include "classes/db_cgm_classe.php";
include "classes/db_iptubase_classe.php";
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
//postmemory($HTTP_POST_VARS,2);
$oPost = db_utils::postMemory($_POST, 0);
$oGet = db_utils::postMemory($_GET, 0);
$clissbase = new cl_issbase();
$cliptubase = new cl_iptubase();
db_mensagem("certidao_cab", "certidao_rod");
$db_verificaip = db_verifica_ip();
$instit = db_getsession("DB_instit");
$bForm = true;
$numcgm = "";
$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);
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
 *  02111-1307, USA.
 *
 *  Copia da licenca no diretorio licenca/licenca_en.txt
 *                                licenca/licenca_pt.txt
 */
session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "libs/db_mens.php";
include "libs/db_utils.php";
include "classes/db_issbase_classe.php";
include "classes/db_cgm_classe.php";
include "classes/db_iptubase_classe.php";
$clissbase = new cl_issbase();
$clcgm = new cl_cgm();
$cliptubase = new cl_iptubase();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
db_postmemory($_POST);
db_postmemory($_GET);
if (!isset($matricula1)) {
    $matricula1 = $matricula;
}
$db_datausu = date("Y-m-d");
/*
 * consulta se o parâmetro do módulo prefeitura online está habilidado como true
*/
$instit = db_getsession("DB_instit");
$db21_usasisagua = 'f';
$rsRetornoConfig = db_query("select * from configdbpref where w13_instit = {$instit}");
 *  junto com este programa; se nao, escreva para a Free Software     
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA          
 *  02111-1307, USA.                                                  
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
session_start();
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "dbforms/db_funcoes.php";
include "classes/db_arreinscr_classe.php";
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);
 *  02111-1307, USA.                                                  
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
session_start();
if (isset($outro)) {
    @setcookie("cookie_codigo_cgm");
    header("location:digitaissqn.php");
}
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_issbase_classe.php";
include "classes/db_escrito_classe.php";
$clescrito = new cl_escrito();
$clissbase = new cl_issbase();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
$result = pg_exec("SELECT distinct m_publico,m_arquivo,m_descricao\n                       FROM db_menupref \n                       WHERE m_arquivo = 'digitaissqn.php'\n                       ORDER BY m_descricao\n                       ");
db_fieldsmemory($result, 0);
$result = pg_exec("select cgc as cgc_pref from db_config where codigo = " . db_getsession("DB_instit"));
db_fieldsmemory($result, 0);
mens_help();
db_mensagem("issqnretencao_cab", "issqnretencao_rod");
?>
<html>
<head>
<title>DBSeller Inform&aacute;tica Ltda - Prefeitura On - Line</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" src="scripts/db_script.js"></script>
<script>
function js_vericampos(){
 *  
 *  Copia da licenca no diretorio licenca/licenca_en.txt 
 *                                licenca/licenca_pt.txt 
 */
require "fpdf151/scpdf.php";
include "fpdf151/impcarne.php";
include "libs/db_sql.php";
//include("libs/db_stdlib.php");
include "classes/db_aidof_classe.php";
include "classes/db_cgm_classe.php";
include "classes/db_issbase_classe.php";
include "classes/db_notasiss_classe.php";
include "classes/db_aidofautenticidade_classe.php";
$claidof = new cl_aidof();
$clcgm = new cl_cgm();
$clissbase = new cl_issbase();
$clnotasiss = new cl_notasiss();
$cl_aidofautenticidade = new cl_aidofautenticidade();
parse_str($HTTP_SERVER_VARS['QUERY_STRING']);
$sqlpref = "select * from db_config where codigo = " . db_getsession("DB_instit");
$resultpref = pg_exec($sqlpref);
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);