| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/juridico/horizonte/includes/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 20/05/2015
* Time: 11:47
*/
include("../includes/conexao.php");
include "../fpdf/fpdf.php";
$v_id = $_GET['id'];
mysql_select_db($banco, $conexao);
$rs_ent = mysql_query("select * from prefeituras");
$rs_res = mysql_fetch_array($rs_ent);
$rs_sql = mysql_query("select * from processos where codigo = $v_id");
$resulta = mysql_fetch_array($rs_sql);
//fpdf
$pdf = new FPDF('P', 'cm', 'A4');
$pdf = new FPDF();
$pdf->Open();
$pdf->SetTitle("Ficha Despesas");
//HEADER
$pdf->AddPage();
$pdf->image('../logo/logo.jpg', 10, 10, 40);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(45, 10, utf8_decode(''));
$pdf->Cell(50, 10, utf8_decode('DIGITAL TECNOLOGIA EM DIGITALIZAÇÃO - GEDWEB'));
$pdf->Ln(5);
$pdf->Cell(45, 10, utf8_decode(''));
$pdf->Cell(50, 10, $rs_res['prefeitura']);
$pdf->Ln(5);
$pdf->Cell(45, 10, utf8_decode(''));
$pdf->Cell(10, 10, utf8_decode('Dados do documento de caixa nº: ') . $resulta['num_doc_caixa']);
$pdf->Rect(55, 10, 140, 20, 'D');
//UNIDADE GESTORA
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(20);
$pdf->Cell(40, 10, 'Dados da Unidade Gestora');
$pdf->Rect(10, 48, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(6, 10, utf8_decode('ID:'));
$pdf->Cell(10, 10, $resulta['codigo']);
$pdf->Cell(18, 10, utf8_decode('Cód. Mun.:'));
$pdf->Cell(10, 10, $resulta['cod_mun']);
$pdf->Cell(18, 10, utf8_decode('Cód. Órgão:'));
$pdf->Cell(10, 10, $resulta['codigo_orgao']);
$pdf->Cell(18, 10, utf8_decode('Unid. Orç.:'));
$pdf->Cell(10, 10, $resulta['cod_unid_orc']);
$pdf->Cell(10, 10, utf8_decode('U.G.:'));
$pdf->Cell(10, 10, $resulta['codigo_unid_gestora']);
$pdf->Cell(18, 10, utf8_decode('Sigla U.G.:'));
$pdf->Cell(15, 10, $resulta['sigla_unid_gestora']);
$pdf->Cell(16, 10, utf8_decode('Exercício:'));
$pdf->Cell(10, 10, $resulta['exercicio']);
//DADOS DO PROCESSO
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(14);
$pdf->Cell(40, 10, 'Dados do Processo');
$pdf->Rect(10, 68, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(15, 10, utf8_decode('ID GED:'));
$pdf->Cell(18, 10, $resulta['codigo_processo']);
$pdf->Cell(22, 10, utf8_decode('Nº Doc. caixa:'));
$pdf->Cell(18, 10, $resulta['num_doc_caixa']);
$pdf->Cell(20, 10, utf8_decode('Nº Empenho:'));
$pdf->Cell(18, 10, $resulta['numero_empenho']);
$pdf->Cell(21, 10, utf8_decode('Sub Empenho:'));
$pdf->Cell(21, 10, $resulta['sub_empenho']);
$pdf->Cell(14, 10, utf8_decode('Nº NP:'));
$pdf->Cell(18, 10, $resulta['np_numero_np']);
$pdf->Ln(6);
$pdf->Cell(15, 10, utf8_decode('Data NP:'));
$pdf->Cell(18, 10, $resulta['np_data_ref_doc']);
$pdf->Cell(17, 10, utf8_decode('CPF Resp.:'));
$pdf->Cell(23, 10, $resulta['np_num_cpf_responsavel']);
$pdf->Cell(19, 10, utf8_decode('Nome Resp.:'));
$pdf->Cell(21, 10, $resulta['np_nome_resp_pag']);
$pdf->Ln(6);
$pdf->Cell(16, 10, utf8_decode('Vlr. Emp.:'));
$pdf->Cell(17, 10, $resulta['valor_empenho']);
$pdf->Cell(16, 10, utf8_decode('CPF Ord.:'));
$pdf->Cell(24, 10, $resulta['cpf_ord_despesa']);
$pdf->Cell(16, 10, utf8_decode('Proc. Adm.:'));
$pdf->Cell(21, 10, $resulta['tipo_proc_adm']);
//DADOS DO PROCESSO
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(14);
$pdf->Cell(40, 10, 'Dados do Credor');
$pdf->Rect(10, 100, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(22, 10, utf8_decode('Nome Credor:'));
$pdf->Cell(128, 10, $resulta['nome_credor']);
$pdf->Cell(10, 10, utf8_decode('Doc. nº:'));
$pdf->Cell(50, 10, $resulta['dado_doc_id_credor']);
$pdf->Ln(6);
$pdf->Cell(10, 10, utf8_decode('Telefone:'));
$pdf->Cell(64, 10, $resulta['telefone_credor']);
$pdf->Cell(10, 10, utf8_decode('Endereço:'));
$pdf->Cell(66, 10, $resulta['endereco_credor']);
$pdf->Cell(10, 10, utf8_decode('Município:'));
$pdf->Cell(50, 10, $resulta['municipio_credor']);
//DADOS DO CHEQUE
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(14);
$pdf->Cell(40, 10, 'Dados do cheque de pagamento');
$pdf->Rect(10, 126, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(16, 10, utf8_decode('Nº Banco:'));
$pdf->Cell(12, 10, $resulta['ch_num_banco']);
$pdf->Cell(9, 10, utf8_decode('Ag.:'));
$pdf->Cell(13, 10, $resulta['ch_num_agencia']);
$pdf->Cell(12, 10, utf8_decode('Conta:'));
$pdf->Cell(20, 10, $resulta['ch_num_conta']);
$pdf->Cell(12, 10, utf8_decode('Nº CH:'));
$pdf->Cell(15, 10, $resulta['ch_num_cheque']);
$pdf->Cell(14, 10, utf8_decode('Emissão:'));
$pdf->Cell(18, 10, $resulta['ch_data_emissao']);
$pdf->Cell(12, 10, utf8_decode('Valor:'));
$pdf->Cell(18, 10, number_format($resulta['ch_valor_cheque']), 2, ',', '.');
//DADOS DA NF
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(14);
$pdf->Cell(40, 10, 'Dados da nota fiscal');
$pdf->Rect(10, 146, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(16, 10, utf8_decode('Tipo:'));
$pdf->Cell(12, 10, $resulta['nf_tipo_nf']);
$pdf->Cell(10, 10, utf8_decode('Nº NF:'));
$pdf->Cell(12, 10, $resulta['num_nota_fiscal']);
$pdf->Cell(18, 10, utf8_decode('CGF Emitente:'));
$pdf->Cell(28, 10, $resulta['nf_num_cgf_emitente']);
$pdf->Cell(16, 10, utf8_decode('UF Emitente:'));
$pdf->Cell(12, 10, $resulta['nf_uf_emitente']);
$pdf->Cell(16, 10, utf8_decode('Emissão:'));
$pdf->Cell(10, 10, $resulta['nf_data_emissao_nf']);
$pdf->Cell(15, 10, utf8_decode('Valor:'));
$pdf->Cell(12, 10, $resulta['nf_valor_nf']);
//CONTA EXTRA
$pdf->SetFont('Times', 'B', 12);
$pdf->Ln(14);
$pdf->Cell(40, 10, utf8_decode('Dados da conta extra orçamentária'));
$pdf->Rect(10, 166, 185, 0, 'D');
$pdf->Ln(6);
$pdf->SetFont('Times', '', 10);
$pdf->Cell(16, 10, utf8_decode('Tipo:'));
$pdf->Cell(12, 10, $resulta['xd_tipo_documento']);
$pdf->Cell(16, 10, utf8_decode('Exercício:'));
$pdf->Cell(12, 10, $resulta['xd_exercicio']);
$pdf->Cell(9, 10, utf8_decode('Cód.:'));
$pdf->Cell(17, 10, $resulta['xd_cod_conta_extra']);
$pdf->Cell(12, 10, utf8_decode('Banco:'));
$pdf->Cell(12, 10, $resulta['xd_num_banco']);
$pdf->Cell(12, 10, utf8_decode('Ag.:'));
$pdf->Cell(12, 10, $resulta['xd_num_agencia']);
$pdf->Cell(12, 10, utf8_decode('Conta:'));
$pdf->Cell(12, 10, $resulta['xd_num_conta']);
$pdf->Ln(6);
$pdf->Cell(12, 10, utf8_decode('Cheque:'));
$pdf->Cell(15, 10, $resulta['xd_num_chuque']);
$pdf->Cell(16, 10, utf8_decode('Tipo CH:'));
$pdf->Cell(12, 10, $resulta['xd_tipo_cheque']);
$pdf->Cell(16, 10, utf8_decode('Emissão:'));
$pdf->Cell(12, 10, $resulta['xd_data_referencia']);
$pdf->Cell(13, 10, utf8_decode('Nº Doc.:'));
$pdf->Cell(18, 10, $resulta['xd_num_doc_caixa']);
$pdf->Cell(17, 10, utf8_decode('Data Desp.:'));
$pdf->Cell(16, 10, $resulta['xd_data_despesa']);
$pdf->Cell(14, 10, utf8_decode('Valor:'));
$pdf->Cell(12, 10, $resulta['xd_valor_despesa']);
$pdf->Ln(6);
$pdf->Cell(16, 10, utf8_decode('Vlr. Ded.:'));
$pdf->Cell(12, 10, $resulta['xd_valor_deducao']);
$pdf->Cell(16, 10, utf8_decode('Descrição:'));
$pdf->Cell(12, 10, $resulta['xd_descricao_conta_extra']);
//
ob_clean();
$pdf->Output($resulta['exercicio'] . '-' . $resulta['mes'] . '-' . $resulta['num_doc_caixa'] . '-' . $resulta['nome_credor'], 'I');
exit;