function afficherPDF($vpdf) { require 'fpdf/mc_table.php'; $pdf = ob_get_clean(); $pdf = new PDF_MC_Table(); $pdf->AddPage(); $pdf->SetFont('Times', '', 12); $pdf->Image("images/logo.png", 7, 5, 50.9); $pdf->SetXY(9, 15); $pdf->RoundedRect(95, 54, 110, 35, 2, 'D'); $pdf->SetXY(9, 40); $pdf->MultiCell(80, 5, utf8_decode("Siège social : GSB\nPhiladelphie, \nPennsylvanie, Etats-Unis\ngsb_galaxybourdin@gmail.com "), 0, "L", 0); $pdf->SetXY(100, 57); $pdf->MultiCell(100, 7, utf8_decode("Client : " . $vpdf['nom'] . " " . $vpdf['prenom'] . "\nAdresse : " . $vpdf['adresse'] . "\nCode postal : " . $vpdf['cp'] . "\nVille : " . $vpdf['ville']), 0, "L", 0); $pdf->SetXY(9, 100); $pdf->MultiCell(80, 5, utf8_decode("Remboursement du : " . $vpdf['numMois'] . " / " . $vpdf['numAnnee']), 0, "L", 0); $pdf->SetWidths(array(47.5, 47.5, 47.5, 47.5)); srand(microtime() * 1000000); $pdf->SetXY(10, 110); $pdf->MultiCell(190, 7, utf8_decode('Eléments forfaitisés'), 1, "L", 0); $pdf->Row2(array('Frais forfaitaires', utf8_decode('Quantité'), 'Montant unitaire', 'Montant total')); $pdf->Row2(array($vpdf['libelle'][0], utf8_decode($vpdf['quantite'][0]), $vpdf['montant'][0], $vpdf['montantT'][0] . " " . html_entity_decode($vpdf['euros']))); $pdf->Row2(array(utf8_decode($vpdf['libelle'][1]), utf8_decode($vpdf['quantite'][1]), $vpdf['montant'][1], $vpdf['montantT'][1] . " " . html_entity_decode($vpdf['euros']))); $pdf->Row2(array(utf8_decode($vpdf['libelle'][2]), utf8_decode($vpdf['quantite'][2]), $vpdf['montant'][2], $vpdf['montantT'][2] . " " . html_entity_decode($vpdf['euros']))); $pdf->Row2(array(utf8_decode($vpdf['libelle'][3]), utf8_decode($vpdf['quantite'][3]), $vpdf['montant'][3], $vpdf['montantT'][3] . " " . html_entity_decode($vpdf['euros']))); $pdf->SetXY(10, 157); mysql_connect('localhost', 'root', ''); mysql_select_db('gsbv2'); //First table: put all columns automatically $pdf->MultiCell(190, 7, utf8_decode('Eléments hors forfait'), 1, "L", 0); $prop = array('HeaderColor' => array(205, 216, 211), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 250), 'padding' => 2); $pdf->AddCol('date', 35, '', 'Date'); $pdf->AddCol('libelle', 105, 'Libelle'); $pdf->AddCol('montant', 50, 'Montant', 'R'); $pdf->Table("select date,libelle,montant from lignefraishorsforfait lf where lf.mois='" . $vpdf['mois'] . "' and lf.idVisiteur='" . $vpdf['id'] . "' " . "UNION ALL (select date,libelle,montant as idlfr from lignefraishorsforfaitrefuse lfr where lfr.mois='" . $vpdf['mois'] . "' and lfr.idVisiteur='" . $vpdf['id'] . "')", $prop); $pdf->SetXY(10, 200); $pdf->SetXY(130, 230); $pdf->MultiCell(70, 7, "Total du " . $vpdf['numMois'] . " / " . $vpdf['numAnnee'] . " : " . $vpdf['montVal'] . " " . html_entity_decode($vpdf['euros']) . "\nNombre de justificatifs : " . $vpdf['nbJust'] . " fiche(s)" . utf8_decode("\nMontant refusé : ") . $vpdf['montRefuse'] . " " . html_entity_decode($vpdf['euros']) . "\nFait le : " . $vpdf['dateNow'] . "", 1, "R", 0); $pdf->Output(); }
$pdf->AddFont('GillSans', 'LI', 'GillSans_LI.php'); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetLeftMargin(25); //---------------------------------------------- $pdf->SetFont('GillSans', '', 10); $pdf->SetFillColor(249, 250, 252); $pdf->Cell(70, 4, ' Estructura Programática ', 0, 0, 'L', 0); $pdf->Cell(70, 4, 'Ejercicio: 2015 ', 0, 0, 'L', 0); $pdf->Ln(5); $pdf->SetFont('GillSans', 'B', 10); $pdf->Cell(240, 4, 'Catálogo de Programas', 1, 1, 'C', 1); $pdf->SetFont('GillSans', '', 10); $y = $pdf->GetY(); $x = $pdf->GetX(); $pdf->MultiCell(20, 8, 'ID', 1, 'C', 1); $pdf->SetXY($x + 20, $y); $pdf->MultiCell(40, 8, 'Clave', 1, 'C', 1); $pdf->SetXY($x + 60, $y); $pdf->MultiCell(150, 8, 'Descripción', 1, 'C', 1); $pdf->SetXY($x + 210, $y); $pdf->Cell(30, 8, 'Tipo', 1, 0, 'C', 1); $pdf->Cell(0, 4, '', 0, 1, 'C', 0); $pdf->Ln(4); //ciclo $pdf->SetFont('GillSans', 'L', 12); $pdf->SetWidths(array(20, 40, 150, 30)); foreach ($avPrg as $key => $value) { $c1 = $key; $c2 = $value['cve']; $c3 = $value['dsc'];
$db = new PgDB(); //QUERY PARA LOS ESTUDIANTES DEL PERIODO ACTIVO /*$query = "SELECT nombre, apellido, cedula, m01_registrada ::timestamp::date, m02_aceptada ::timestamp::date, m03_numero_asignado ::timestamp::date, m05_entrego_copia ::timestamp::date, m06_entrego_borrador ::timestamp::date, m07_retiro_borrador ::timestamp::date, m08_entrega_final ::timestamp::date, m09_carga_nota ::timestamp::date, aprobada FROM usuario INNER JOIN pasantia ON usuario.id = pasantia.usuario_id AND usuario.tipo = 'estudiante' INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE"; $reco = pg_query($query); $row = pg_fetch_array($reco); */ //QUERY PARA EL PERIDO ACTIVO $queryPer = "SELECT tipo, anio FROM periodo WHERE activo = TRUE"; $recoPer = pg_query($queryPer); $rowPer = pg_fetch_array($recoPer); $pdf->SetFont('Arial', 'B', 12); $pdf->MultiCell(0, 5, utf8_decode("\nRepública Bolivariana de Venezuela\nUniversidad del Zulia\nFacultad Experimental de Ciencias\nDivisión de Programas Especiales\nSistema de Pasantías\n"), 0, "C", 0); $pdf->MultiCell(165, 5, utf8_decode("\n\nReporte General"), 0, "C", 0); $pdf->MultiCell(165, 5, utf8_decode("\n{$rowPer['tipo']} - {$rowPer['anio']}"), 0, "C", 0); $pdf->Ln(); $inscritos = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.m01_registrada IS NOT NULL"); $aprobados = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.aprobada = TRUE"); $reprobados = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.aprobada = FALSE"); $pdf->Image("logotipo.jpg", 20, 12, -280); //GENERAR LA TABLA $pdf->SetXY(57, 70); $pdf->SetFont('Arial', 'B', 12); $pdf->SetWidths(array(30, 30, 30)); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->Row(array("Inscritos", "Aprobados", "Reprobados")); $pdf->SetX(57); $pdf->SetFont('Arial', '', 12);
} $month_rus = array("января", "февраля", "марта", "апреля", "мая", "июня", "июля", "августа", "сентября", "октября", "ноября", "декабря"); define('FPDF_FONTPATH', './font/'); require './mc_table/mc_table.php'; if (isset($_POST['jsonstring'])) { $_SESSION['applydata'] = json_decode($_POST['jsonstring']); } if (isset($_GET['getpdf'])) { $applyData = $_SESSION['applydata']; $pdf = new PDF_MC_Table('P'); $pdf->SetMargins(25, 10, 10); $pdf->AddFont('TimesNewRomanPSMT', '', 'times.php'); $pdf->AddPage(); $pdf->SetFont('TimesNewRomanPSMT', '', 12); $pdf->SetX(110); $pdf->MultiCell(88, 5, sav2_convert("Государственное бюджетное учреждение \n Республики Коми \"Центр по предоставлению \n государственных услуг в сфере \n социальной защиты населения "), 0, 'R'); $pdf->SetX(110); $pdf->SetTextColor(0, 0, 255); $pdf->MultiCell(88, 6, sav2_convert($applyData->{'org-town'} . "\""), 'B', 'R'); $pdf->SetTextColor(0, 0, 0); $pdf->Ln(); $pdf->MultiCell($width, 5, sav2_convert("ЗАЯВЛЕНИЕ \n о признании семьи или одиноко проживающего гражданина \n малоимущими и назначении государственной социальной помощи"), 0, 'C'); $pdf->Ln(); $pdf->Cell(6, 5, sav2_convert('от'), 0); $pdf->SetTextColor(0, 0, 255); $pdf->MultiCell($width, 5, sav2_convert($applyData->{'customer-fio'}), 'B', 'C'); $pdf->SetTextColor(0, 0, 0); $pdf->Cell($width, 5, sav2_convert("(фамилия, имя, отчество)"), 0, 1, 'C'); $pdf->Cell($width, 6, sav2_convert("зарегистрированного(ой) по месту жительства (месту пребывания) по адресу:"), 0, 1, 'L'); $pdf->SetTextColor(0, 0, 255); $pdf->MultiCell($width, 6, sav2_convert($applyData->{'customer-dwelling'}), 'B', 'C');
$width1 = 180; $width2 = $width1 / 2; $width3 = $width1 / 3; $width4 = $width1 / 4; $pdf->SetFillColor(255, 255, 255); $pdf->SetFont('Arial', 'B', 18); $pdf->Cell(180, $high, "Netherhall House", 0, 0, 'C', true); $pdf->Ln(); $pdf->SetFont('Arial', '', 10); //$pdf->SetWidths(array(40,100,40)); //$pdf->SetAligns(array('','C','')); //$pdf->SetBorders(array(0,0,0)); $pdf->SetX = 70; $pdf->SetY = 15; $cabecera = "Nutley Terrace, London NW3 5SA\nTel: 020 7435 8888 (Director); 020 7472 5720 (Residents)\nFax: 020 7472 5721\nE-Mail: director@nh.netherhall.org.uk\nWeb: www.nh.netherhall.org.uk"; $pdf->MultiCell(180, 4, $cabecera, 0, 'C'); //$pdf->Row(array("",$cabecera,"")); $pdf->Ln(); $pdf->SetAligns(array('', '', '')); $pdf->SetBorders(array(1, 1, 1)); $pdf->Image("imgs/shield.gif", 18, 7, 26); if ($arrResident[picture] != "" && file_exists("residentsnh/" . $arrResident[picture])) { $pdf->Image("residentsnh/" . $arrResident[picture], 180, 10, 20); } else { $pdf->Image("imgs/no_picture.png", 180, 10, 20); } $pdf->SetFont('Arial', 'B', 12); $pdf->Cell(180, $high, "APPLICATION FOR ADMISSION", 0, 0, 'C', true); $pdf->Ln(); $pdf->Ln(); $pdf->SetFillColor(255, 255, 255);