*
* Copia da licenca no diretorio licenca/licenca_en.txt
* licenca/licenca_pt.txt
*/
session_start();
if (isset($outro)) {
setcookie("cookie_codigo_cgm");
header("location:digitainscricao.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_empempenho_classe.php";
include "classes/db_issbase_classe.php";
$clcgm = new cl_cgm();
$clissbase = new cl_issbase();
$clempempenho = new cl_empempenho();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
$dblink = "corpoprincipal.php";
db_logs("", "", 0, "Digita Codigo do Fornecedor.");
$db_verificaip = db_verifica_ip();
if ($db_verificaip == "0") {
$onsubmit = "onsubmit=\"return js_verificaCGCCPF((this.cgc.value==''?'':this.cgc),this.cpf);\"";
} else {
$onsubmit = "";
}
?>
<html>
<head>
<title><?php
* 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
*/
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');
$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, ";
$sqlinst .= " db21_usasisagua ";
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="60" align="<?php
echo $DB_align1;
?>
">
<?php
echo $DB_mens1;
?>
</td>
</tr>
<tr>
<td align="center" valign="top">
<?php
$clcgm = new cl_cgm();
$result = $clcgm->sql_record($clcgm->sql_query($z01_numcgm));
//die($clcgm->sql_query($z01_numcgm));
if ($clcgm->numrows > 0) {
db_fieldsmemory($result, 0);
echo "<p><font size='2'><strong>Escritório Contábil</strong> " . @$z01_nome . "</font></p>";
$sqllista = "select * from listainscrcab where p11_numcgm={$z01_numcgm}";
// die($sqllista);
$result = pg_query($sqllista);
$linhas = pg_num_rows($result);
if ($linhas > 0) {
// se existir lista ... verificar se tem lista em aberto
$sql = "select * from listainscrcab where p11_numcgm={$z01_numcgm} and p11_fechado is false and p11_processado is false";
$result = pg_query($sql);
$linhas2 = pg_num_rows($result);
//db_fieldsmemory($result,0);
$outros = "Inscrição: " . $inscr;
$clissbase = new cl_issbase();
$result_inf = pg_exec("select * from empresa where q02_inscr = {$inscr}");
// if($clissbase->numrows!=0){
if (pg_numrows($result_inf) != 0) {
db_fieldsmemory($result_inf, 0);
$z01_numcgm = $q02_numcgm;
} else {
}
} else {
if (!empty($numpre)) {
$result_teste = debitos_numpre($numpre, 0, 0, $DB_DATACALC, $DB_anousu, 0, '', 'k00_tipo,k00_numpre,k00_numpar,k00_receit');
$outros = "Código Arrecadação: " . $numpre;
$result = debitos_numpre($numpre, 0, 0, $DB_DATACALC, $DB_anousu, 0, '', 'k00_tipo,k00_numpre,k00_numpar,k00_receit');
$z01_numcgm = pg_result($result, 0, "k00_numcgm");
$clcgm = new cl_cgm();
$result = $clcgm->sql_record($clcgm->sql_query_file($z01_numcgm, "z01_nome"));
db_fieldsmemory($result, 0);
//$result = debitos_numpre($numpre,0,0,$DB_DATACALC,$DB_anousu,0,'','k00_tipo,k00_numpre,k00_receit,k00_numpar',$desconto);
$result = debitos_numpre($numpre, 0, 0, $DB_DATACALC, $DB_anousu, 0, '', 'k00_tipo,k00_numpre,k00_numpar,k00_receit');
$result = debitos_numpre($numpre, 0, 0, $DB_DATACALC, $DB_anousu, 0, '', 'k00_tipo,k00_numpre,k00_numpar,k00_receit', $where);
}
}
}
}
$pdf = new PDF();
$pdf->Open();
$pdf->AliasNbPages();
//$pdf->AddPage();
$pdf->SetFillColor(235);
//Dados
* 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_db_cgmatualiza_classe.php";
include "classes/db_db_cgmatualizaliga_classe.php";
include "classes/db_cgm_classe.php";
include "libs/smtp.class.php";
$cldb_cgmatualiza = new cl_db_cgmatualiza();
$cldb_cgmatualizaliga = new cl_db_cgmatualizaliga();
$cl_cgm = new cl_cgm();
$cldb_cgmatualiza->rotulo->label();
$db_opcao = "";
db_postmemory($HTTP_POST_VARS);
$result = pg_query("SELECT distinct m_publico,m_arquivo,m_descricao\n FROM db_menupref\n WHERE m_arquivo = 'digitaaidof.php'\n ORDER BY m_descricao\n ");
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>";
}
}
$db_verificaip = db_verifica_ip();
mens_help();
$dblink = "atualizaendereco.php";
db_logs("", "", 0, "Atualiza endereço CGM.");
db_mensagem("endereco_cab", "endereco_rod");
db_fieldsmemory($result2, 0);
$dadosalvaraprovisorio = "Alvará Provisório Válido entre: (" . db_formatar($q07_datain, 'd') . " e " . db_formatar($q07_datafi, 'd') . ")";
}
if (!isset($z01_numcgm)) {
$z01_numcgm = $q02_numcgm;
}
}
}
}
}
}
db_fim_transacao(false);
/**
* GERA PDF
*/
$cl_cgm = new cl_cgm();
if (isset($z01_numcgm) || @$z01_numcgm != null || @$z01_numcgm != '') {
$sSqlIdent = $cl_cgm->sql_query("", "*", "", "z01_numcgm = {$z01_numcgm}");
} else {
$sSqlIdent = $cl_cgm->sql_query("", "*", "", "z01_cgccpf = '{$z01_cgccpf}'");
}
//die($sSqlIdent);
$rsIdent = $cl_cgm->sql_record($sSqlIdent);
if ($cl_cgm->numrows > 0) {
db_fieldsmemory($rsIdent, 0);
}
$z01_cgmpri = $z01_numcgm;
$sqlDbconfig = "select * from db_config where codigo = " . db_getsession('DB_instit');
$rsDbconfig = db_query($sqlDbconfig);
db_fieldsmemory($rsDbconfig, 0);
/**
throw new Exception("Erro durante o armazenamento do calculo de Simulação!\n\nErro: {$oDaoIsssimulacalculoTipoCalculo->erro_msg}");
}
}
$oRetorno->iSimulacao = $oDaoIsssimulacalculo->q130_sequencial;
$oRetorno->oCalculo = $oCalculoSimulacao;
$oRetorno->sMessage = "Calculo de Simulação realizado com Sucesso!";
db_fim_transacao(false);
} catch (Exception $oException) {
$oRetorno->sMessage = $oException->getMessage();
db_fim_transacao(true);
$oRetorno->iStatus = 2;
}
break;
case 'getNome':
require_once 'classes/db_cgm_classe.php';
$oDaoCgm = new cl_cgm();
$aRetornoDados = array();
$iCgcCpf = $oParam->z01_cgccpf;
$sCampos = "z01_nome, ";
$sCampos .= "z01_email ";
$sSqlDados = $oDaoCgm->sql_query_file(null, $sCampos, null, "z01_cgccpf = '{$iCgcCpf}' ");
$rsDados = $oDaoCgm->sql_record($sSqlDados);
if ($oDaoCgm->numrows > 0) {
$oDados = db_utils::fieldsMemory($rsDados, 0);
$oDdosCgm = new stdClass();
$oDdosCgm->z01_nome = $oDados->z01_nome;
$oDdosCgm->z01_email = $oDados->z01_email;
$aRetornoDados[] = $oDdosCgm;
$oRetorno->aDados = $aRetornoDados;
} else {
$oRetorno->iStatus = 2;
* Copia da licenca no diretorio licenca/licenca_en.txt
* licenca/licenca_pt.txt
*/
error_reporting('** Informe Seus Clientes **');
session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_utils.php";
include "libs/db_sql.php";
include "classes/db_cgm_classe.php";
include "classes/db_escrito_classe.php";
include "classes/db_listainscrcab_classe.php";
include "classes/db_listainscr_classe.php";
include "dbforms/db_funcoes.php";
validaUsuarioLogado();
$clcgm = new cl_cgm();
$clescrito = new cl_escrito();
$cllistainscrcab = new cl_listainscrcab();
$cllistainscr = new cl_listainscr();
$oPost = db_utils::postMemory($_POST, 0);
$oGet = db_utils::postMemory($_GET, 0);
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
db_logs("", "", 0, "Informe Seus Clientes.");
$codUsuario = base64_decode($oGet->id);
$numCgm = base64_decode($oGet->cgm);
$usuario = base64_decode($oGet->nome);
$iMostrarMatric = 0;
$id_usuario = $codUsuario;
$cgmlogin = $numCgm;
$nomeusuario = $usuario;
if (isset($oPost->tipodelancamento)) {
* 02111-1307, USA.
*
* 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) {
