$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á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);