Ejemplo n.º 1
0
 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);
Ejemplo n.º 4
0
}
$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);