コード例 #1
0
     if ($printPage === TRUE) {
         $pdf->AddPage();
         $printPage = FALSE;
     } else {
         $pdf->ReportHeader();
     }
     $pdf->AddCol('party', '78', 'Party Name', 'L');
     $pdf->AddCol("t{$prevYear}", '13', "{$prevYear}", 'R');
     $pdf->AddCol("t{$year}", '13', "{$year}", 'R');
     $pdf->AddCol("t{$comp}", '13', "% +/-", 'R');
     for ($k = 1; $k <= 4; $k++) {
         $pdf->AddCol("{$k}{$prevYear}", '13', "{$prevYear}", 'R');
         $pdf->AddCol("{$k}{$year}", '13', "{$year}", 'R');
         $pdf->AddCol("{$k}{$comp}", '13', "% +/-", 'R');
     }
     $pdf->Table($d['data'], $prop);
     $totals = $d['totals'];
     $pdf->SetFont('Arial', 'B', 8);
     $pdf->SetX(12);
     $pdf->Cell(78, 6, "Total", 'LBR', 0, 'C', false);
     $pdf->Cell(13, 6, $totals["t{$prevYear}"], 'LBR', 0, 'C', false);
     $pdf->Cell(13, 6, $totals["t{$year}"], 'LBR', 0, 'C', false);
     $pdf->Cell(13, 6, $totals["t{$comp}"], 'LBR', 0, 'C', false);
     for ($k = 1; $k <= 4; $k++) {
         $pdf->Cell(13, 6, $totals["{$k}{$prevYear}"], 'LBR', 0, 'C', false);
         $pdf->Cell(13, 6, $totals["{$k}{$year}"], 'LBR', 0, 'C', false);
         $pdf->Cell(13, 6, $totals["{$k}{$comp}"], 'LBR', 0, 'C', false);
     }
     $pdf->Ln();
 }
 $pdf->Output("sales_comp.pdf", "D");
コード例 #2
0
ファイル: circular.php プロジェクト: kashifnasim/nexexcel
     $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 1, 'formatNumber' => TRUE, 'formatNumberDecimal' => 0, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 10));
     foreach ($data as $vid => $d) {
         $vehicle = $d['vehicle'];
         $pdf->AddPage();
         $pdf->AddCol('cno', '5%', '', 'L');
         if ($vendor == 'TIK') {
             $pdf->AddCol('description', '25%', '', 'L');
             $pdf->AddCol('fix_rate', '15%', '', 'R');
         } else {
             $pdf->AddCol('description', '40%', '', 'L');
         }
         $pdf->AddCol('model', '15%', '', 'L');
         $pdf->AddCol('oem', '15%', '', 'L');
         $pdf->AddCol('rate', '15%', '', 'R');
         $pdf->AddCol('unit', '10%', '', 'L');
         $pdf->Table($d['data'], $prop, TRUE, FALSE);
     }
     $pdf->Output("circular.pdf", "D");
 } else {
     if ($_GET['report'] == 'xls') {
         require_once '../../Classes/PHPExcel.php';
         $padding = 0.71;
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator("*****@*****.**")->setLastModifiedBy("Imran Zahid")->setTitle("MM Circular")->setSubject("MM Circular")->setDescription("MM Circular")->setKeywords("MM Circular")->setCategory("Reports");
         $activeSheet = $objPHPExcel->getActiveSheet();
         $activeSheet->getHeaderFooter()->setOddHeader('&C&18&B' . $_title . '&R&U&D');
         $activeSheet->getHeaderFooter()->setOddFooter('&LPlease consider the environment before printing this report&C&IPage &P/&N&RReport generated by nexexcel.com');
         $activeSheet->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT);
         $activeSheet->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
         $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 3);
         $activeSheet->getColumnDimension('A')->setWidth(12 + $padding);
コード例 #3
0
ファイル: daily_sales.php プロジェクト: kashifnasim/nexexcel
     }
     $pdf = new PDF('L', $unit = 'mm', $format = 'A4');
     $pdf->AliasNbPages();
     $pdf->SetAuthor("*****@*****.**");
     $pdf->SetSubject("Daily Sales");
     $pdf->SetTitle("Daily Sales");
     $pdf->SetCreator("Imran Zahid");
     $prop = array('color1' => array(255, 255, 255), 'color2' => array(255, 255, 255), 'color3' => array(128, 128, 128), 'padding' => 2, 'font' => array('Arial', '', 10), 'thfont' => array('Arial', 'B', 10));
     $pdf->AddPage();
     $pdf->AddCol('party_name', "20%", 'Party', 'L');
     $pdf->AddCol('vendor', "20%", 'Vendor', 'L');
     $pdf->AddCol('cat_name', "20%", 'Category', 'L');
     $pdf->AddCol('description', "20%", 'Item', 'L');
     $pdf->AddCol("cs", "10%", 'CS', 'R');
     $pdf->AddCol("pc", "10%", 'PC', 'R');
     $pdf->Table($data, $prop);
     $_cMargin = $pdf->cMargin;
     $pdf->cMargin = $prop['padding'];
     $pdf->SetFont('Arial', 'B', 10);
     $pdf->Cell(221.59806666667, 6, "Total", 1, 0, 'C');
     $pdf->Cell(27.69975833333, 6, $totals['cs'], 1, 0, 'R');
     $pdf->Cell(27.69975833333, 6, $totals['pc'], 1, 0, 'R');
     $pdf->cMargin = $_cMargin;
     $pdf->Ln();
     $pdf->Output("daily_sales_{$_GET['date_start']}.pdf", "D");
 } else {
     if ($_GET['report'] == 'xls') {
         require_once '../../Classes/PHPExcel.php';
         $padding = 0.71;
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator("*****@*****.**")->setLastModifiedBy("Imran Zahid")->setTitle("Daily Sales")->setSubject("Daily Sales")->setDescription("Daily Sales")->setKeywords("Daily Sales")->setCategory("Reports");
コード例 #4
0
ファイル: najaktivniji1.php プロジェクト: jtrupina/eDostava
        {
            //Title
            $this->SetFont('Arial', '', 18);
            $this->Cell(0, 6, 'Statistika korisnika po broju poslanih paketa', 0, 1, 'C');
            $this->Ln(10);
            //Ensure table header is output
            parent::Header();
        }
    }
    //Connect to database
    mysql_connect('localhost', 'WebDiP2013_086', 'admin_kggK');
    mysql_select_db('WebDiP2013_086');
    $pdf = new PDF();
    $pdf->AddPage();
    //First table: put all columns automatically
    $pdf->Table("SELECT count(*) as 'Broj poslanih paketa',ime_prezime as 'Ime i prezime',korisnicko_ime as 'Korisnicko ime' from zahtjevi z  left join kurirske_sluzbe ks on(z.idkurirske_sluzbe=ks.idkurirske_sluzbe) left join korisnici k on(z.posiljatelj=k.korisnicko_ime) WHERE 1=1 and z.idkurirske_sluzbe={$idkurirske} " . $dodatak . " group by posiljatelj order by count(*) desc");
    $pdf->Output();
}
include "header.php";
include "izbornik.php";
require_once 'baza.class.php';
$baza = new baza();
?>

<style>
	@media print
  {
      #popis_info { display: none;}
        #popis_paginate { display: none;}
        #popis_filter { display: none;}
	#forma { display: none; }
コード例 #5
0
    $pdf = new PDF('L');
    $pdf->AliasNbPages();
    $pdf->SetAuthor("*****@*****.**");
    $pdf->SetSubject("Sales Comparision");
    $pdf->SetTitle("Sales Comparision");
    $pdf->SetCreator("Imran Zahid");
    foreach ($regionals as $city => $regional) {
        $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 1, 'formatNumber' => TRUE, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 10));
        $ndata = $regional['data'];
        $totals = $regional['totals'];
        $pdf->AddPage();
        $pdf->AddCol('vendor', '16%', 'Vendor', 'L');
        foreach ($months as $month) {
            $pdf->AddCol($month, '7%', $month, 'R');
        }
        $pdf->Table($ndata, $prop);
        $prop['font'] = array('Arial', 'B', 10);
        $ndata = array();
        $ndata[] = $totals;
        $pdf->AddCol('vendor', '16%', 'Vendor', 'L');
        foreach ($months as $month) {
            $pdf->AddCol($month, '7%', $month, 'R');
        }
        $pdf->Table($ndata, $prop, TRUE, FALSE);
    }
    $pdf->Output("sales_comparision.pdf", "D");
} else {
    if ($_GET['report'] == 'xls') {
        require_once '../../Classes/PHPExcel.php';
        $padding = 0.71;
        $objPHPExcel = new PHPExcel();
コード例 #6
0
ファイル: ex.php プロジェクト: rohmad-st/fpdf
<?php

require 'access.php';
$conn = odbc_connect('COFFEE', '', '');
if (!$conn) {
    die('Connection failed');
}
$pdf = new PDF();
$pdf->AddPage();
$pdf->SetFont('Arial', '', 14);
$sql = 'SELECT COFFEE_NAME, ROAST_TYPE, QUANTITY FROM COFFEE_INVENTORY ORDER BY QUANTITY DESC';
$col = array('COFFEE_NAME' => 50, 'ROAST_TYPE' => 40, 'QUANTITY' => 100);
$pdf->Table($sql, $col);
$pdf->Output();
}
//Connect to database
mysql_connect("{$db_hostname}", "{$db_username}", "{$db_password}");
mysql_select_db('remsdb');
$pdf = new PDF("L", "mm", array(400, 200));
$pdf->AddPage();
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', 'B', 16);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', 'B', 14);
$pdf->SetY(8);
$pdf->SetX(10);
$pdf->Cell(0, 3, $pdfAgencyName, 0, 1, 'L');
$pdf->Ln(5);
$pdf->SetFont('Times', 'B', 12);
$pdf->SetTextColor(131, 130, 139);
$pdf->Cell(0, 3, "Powered by Getchs;", 0, 1, 'L');
$pdf->tdheight = 5;
$pdf->Ln(30);
$pdf->SetFont('Times', 'B', 24);
$pdf->SetTextColor(64, 64, 64);
$pdf->Cell(0, 3, "LIST OF ALL ENDORSED APPLICANT", 0, 1, 'C');
$pdf->Ln(10);
$pdf->AddCol("Name", 80, 'Applicant Name', 'L');
$pdf->AddCol('clientName', 70, 'Client Name', 'L');
$pdf->AddCol('endorsementDate', 60, 'Application Date', 'L');
$pdf->AddCol('endorsementStatus', 50, 'Applicant Status', 'L');
$prop = array('HeaderColor' => array(89, 201, 145), 'color1' => array(224, 235, 255), 'color2' => array(255, 255, 240));
$pdf->SetFont('Times', 'B', 24);
$pdf->Table("SELECT CONCAT (basicLastName , ',' , basicFirstName , ' ', basicMiddleName) AS Name, clientName, endorsementDate, endorsementStatus\n\t\t\tFROM tbl_endorsement a, tbl_applicant b, tbl_basic_info c, tbl_client d, tbl_job_posting e\n\t\t\tWHERE a.applicantId = b.applicantId \n\t\t\t\t\tAND c.basicId = b.basicId\n\t\t\t\t\tAND a.clientId = d.clientId\n\t\t\t\t\tAND a.jobPostingId = e.jobPostingId", $prop);
$pdf->Output();
コード例 #8
0
<?php

include 'view/reportes/CabezaReport.php';
$pdf = new PDF();
if ($resultRep != "") {
    $pdf->Carton = "";
    $pdf->Titulo = "Reporte de Documentos por SubCategorías";
    $pdf->AddPage();
    //$pdf->Header('Reporte de Categorías del Sistema');
    $pdf->AddCol('nombre_subcategorias', 50, utf8_decode('Nombre de SubCategoría'), 'L');
    $pdf->AddCol('lecturas_documentos', 50, utf8_decode('Cantidad de Documentos'), 'C');
    $pdf->AddCol('paginas_documentos', 50, 'Cantidad Hojas', 'C');
    $prop = array('HeaderColor' => array(246, 31, 66), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 210), 'padding' => 2);
    $pdf->SetY(40);
    $format = 1;
    $pdf->Table($resultRep, $prop, $format);
    $pdf->AddCol('totales', 50, utf8_decode(''), 'L');
    $pdf->AddCol('total_documentos', 50, utf8_decode('Total Documentos'), 'C');
    $pdf->AddCol('total_paginas', 50, utf8_decode('Total de Páginas'), 'C');
    $prop2 = array('HeaderColor' => array(246, 31, 66), 'color1' => array(232, 237, 233), 'color2' => array(255, 255, 210), 'padding' => 2);
    //$pdf->SetY(40);
    $format = 0;
    $pdf->Table($resultRep2, $prop2, $format);
}
$pdf->Output();
コード例 #9
0
<?php

require 'mysql_table.php';
class PDF extends PDF_MySQL_Table
{
    function Header()
    {
        //Title
        $this->SetFont('Arial', '', 18);
        $this->Cell(0, 6, 'Mieteruebersicht', 0, 1, 'C');
        $this->Ln(10);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect('mysql.hostinger.de', 'u947198430_user', 'yes123');
mysql_select_db('u947198430_db');
$pdf = new PDF('L');
$pdf->AddPage();
$mieter = 'SELECT * FROM Mieter';
//First table: put all columns automatically
$pdf->Table($mieter);
$pdf->Output($downloadfilename . ".pdf");
header('Location: ' . $downloadfilename . ".pdf");
コード例 #10
0
ファイル: ExportPDF.php プロジェクト: ricmawan/projects
                                $count++;
                            }
                        }
                    } elseif ($width + $wordwidth <= $maxwidth) {
                        $width += $wordwidth + $space;
                        $text .= $word . ' ';
                    } else {
                        $width = $wordwidth + $space;
                        $text = rtrim($text) . "\n" . $word . ' ';
                        $count++;
                    }
                }
                $text = rtrim($text) . "\n";
                $count++;
            }
            $text = rtrim($text);
            return $count;
        }
    }
    $pdf = new PDF('L', 'cm', 'A4');
    $pdf->AliasNbPages();
    $pdf->SetLeftMargin(1);
    $pdf->SetRightMargin(1);
    $pdf->AddPage();
    $pdf->Table();
    $filename = "Laporan Proyek " . $ProjectName . ".pdf";
    $pdf->Output($filename, "D");
}
?>
 
コード例 #11
0
ファイル: rep.php プロジェクト: ksripathi/chemical-engg-iitb
<?php

require 'mysql_table.php';
class PDF extends PDF_MySQL_Table
{
    function Header()
    {
        //Title
        $this->SetFont('Arial', '', 18);
        $this->Cell(0, 6, 'World populations', 0, 1, 'C');
        $this->Ln(10);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect('localhost', 'root', 'vlab');
mysql_select_db('cell');
$pdf = new PDF();
$pdf->AddPage();
//First table: put all columns automatically
$pdf->Table('SELECT * FROM vle_data WHERE eid=1881668 AND flag=1');
$pdf->AddPage();
//Second table: specify 3 columns
$pdf->Output();
?>

View the r
コード例 #12
0
ファイル: vouchers.php プロジェクト: kashifnasim/nexexcel
     $pdf->SetTitle("Voucher");
     $pdf->SetCreator("Imran Zahid");
     $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 1, 'formatNumber' => TRUE, 'formatNumberDecimal' => 0, 'printZero' => FALSE, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 8));
     foreach ($ndata as $data) {
         $prop['font'] = array('Arial', '', 8);
         $voucher_id = $data['seq'];
         $voucher_date = $data['voucher_date_fmt'];
         $voucher_type = $data['voucher_type'];
         $voucher_by = $data['voucher_by'];
         $voucher_remarks = $data['voucher_remarks'];
         $pdf->AddPage();
         $pdf->AddCol('account_name', '30%', 'Account Name', 'L');
         $pdf->AddCol('remarks', '40%', 'Remarks', 'L');
         $pdf->AddCol('debit_amount', '15%', 'Debit', 'R');
         $pdf->AddCol('credit_amount', '15%', 'Credit', 'R');
         $pdf->Table($data['data'], $prop);
         $prop['font'] = $prop['thfont'];
         $pdf->AddCol('account_name', '70%', 'Account', 'L');
         $pdf->AddCol('debit_amount', '15%', 'Debit', 'R');
         $pdf->AddCol('credit_amount', '15%', 'Credit', 'R');
         $row = array();
         $row[] = array('account_name' => 'Total', 'debit_amount' => $data['debit'], 'credit_amount' => $data['credit']);
         $pdf->Table($row, $prop, TRUE, FALSE);
     }
     $pdf->Output("voucher.pdf", "D");
 } else {
     if ($_GET['report'] == 'xls') {
         require_once '../../Classes/PHPExcel.php';
         $padding = 0.71;
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator("*****@*****.**")->setLastModifiedBy("Imran Zahid")->setTitle("Voucher")->setSubject("Voucher")->setDescription("Voucher")->setKeywords("Voucher")->setCategory("Reports");
コード例 #13
0
        //$this->Ln(10);
        //Ensure table header is output
        //parent::Header();
    }
}
$pdf = new PDF();
$pdf->AddPage("L", "Letter");
$pdf->SetFont('Arial', '', 18);
$pdf->Image($maindir . 'assets/img/lucen-aspicio.png', 50, 15, 200, 200, 'PNG');
$pdf->Image($maindir . 'assets/img/logo_unah.png', 15, 5, 24, 36, 'PNG');
$pdf->Image($maindir . 'assets/img/logo-cienciasjuridicas.png', 230, 8, 35, 35, 'PNG');
$pdf->Cell(22, 10, '', 0);
$pdf->SetFont('Arial', '', 18);
$pdf->Cell(45, 10, '', 0);
$pdf->Cell(70, 10, utf8_decode('Universidad Nacional Autónoma de Honduras'), 0);
$pdf->Ln(10);
$pdf->SetFont('Arial', 'U', 14);
$pdf->Cell(60, 8, '', 0, 0, "C");
$pdf->Cell(130, 8, 'Reportes de Permisos Personales', 0, 0, "C");
$pdf->Ln(25);
//$pdf->AddCol('N',25,'#Empleado','C');
$pdf->AddCol('Nombre', 70, 'Nombre Completo', 'C');
$pdf->AddCol('nombre_departamento', 70, 'Departamento', 'C');
$pdf->AddCol('mtd', 50, 'Motivo', 'C');
$pdf->AddCol('fecha', 22, 'Fecha', 'C');
$pdf->AddCol('hora_inicio', 20, 'inicio', 'C');
$pdf->AddCol('hora_finalizacion', 20, 'fin', 'C');
$pdf->AddCol('dias_permiso', 10, utf8_decode('Días'), 'C');
$pdf->base($db);
$pdf->Table($consulta4);
$pdf->Output();
コード例 #14
0
ファイル: party_age.php プロジェクト: kashifnasim/nexexcel
 $pdf->SetSubject("Party Age");
 $pdf->SetTitle("Party Age");
 $pdf->SetCreator("Imran Zahid");
 $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 1, 'formatNumber' => true, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 8));
 if ($_GET['format'] == 'compact') {
     $pdf->AddPage();
     $pdf->AddCol('party', '28%', 'Party Name', 'L');
     $pdf->AddCol('payt', '8%', 'Pay Terms', 'R');
     $pdf->AddCol('days', '7%', 'Days', 'R');
     $pdf->AddCol("d0", '9.5%', '0-30', 'R');
     $pdf->AddCol("d30", '9.5%', '31-60', 'R');
     $pdf->AddCol("d60", '9.5%', '61-90', 'R');
     $pdf->AddCol("d90", '9.5%', '91-120', 'R');
     $pdf->AddCol("d120", '9.5%', '>120', 'R');
     $pdf->AddCol('total', '9.5%', 'Total', 'R');
     $pdf->Table($ndata, $prop);
     $prop['font'] = array('Arial', 'B', 8);
     $pdf->AddCol('name', '43%', 'Total', 'C');
     $pdf->AddCol("d0", '9.5%', '0-30', 'R');
     $pdf->AddCol("d30", '9.5%', '31-60', 'R');
     $pdf->AddCol("d60", '9.5%', '61-90', 'R');
     $pdf->AddCol("d90", '9.5%', '91-120', 'R');
     $pdf->AddCol("d120", '9.5%', '>120', 'R');
     $pdf->AddCol('total', '9.5%', 'Total', 'R');
     $pdf->Table($totals, $prop, TRUE, FALSE);
 } else {
     foreach ($ndata as $data) {
         $party = $data['party'];
         $days_limit = $data['days'];
         $pdf->AddPage();
         $pdf->AddCol('seq', '8%', 'Inv #', 'L');
コード例 #15
0
     $pdf->SetAuthor("*****@*****.**");
     $pdf->SetSubject("Cash Movement");
     $pdf->SetTitle("Cash Movement");
     $pdf->SetCreator("Imran Zahid");
     $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 1, 'formatNumber' => TRUE, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 10));
     $title = $_title;
     $pdf->AddPage();
     $col = 100 / $total;
     for ($i = 0; $i < $total; $i++) {
         $align = 'R';
         if ($i % 2 == 0) {
             $align = 'L';
         }
         $pdf->AddCol("{$i}", $col . '%', '', $align);
     }
     $pdf->Table($data, $prop, FALSE, FALSE);
     $pdf->Table($tdata, $prop, TRUE, FALSE);
     $fileName .= ".pdf";
     $pdf->Output($fileName, "D");
 } else {
     if ($_GET['report'] == 'xls') {
         require_once '../../Classes/PHPExcel.php';
         $padding = 0.71;
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator("*****@*****.**")->setLastModifiedBy("Imran Zahid")->setTitle("Godown Stock")->setSubject("Godown Stock")->setDescription("Godown Stock")->setKeywords("Godown Stock")->setCategory("Reports");
         $activeSheet = $objPHPExcel->getActiveSheet();
         $activeSheet->getHeaderFooter()->setOddHeader('&C&18&B' . $_title . '&R&U&D');
         $activeSheet->getHeaderFooter()->setOddFooter('&LPlease consider the environment before printing this report&C&IPage &P/&N&RReport generated by nexexcel.com');
         $activeSheet->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
         $activeSheet->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
         $pad = 0;
    {
        $this->Ln(3);
        $this->SetFont('Times', 'B', 16);
        $this->SetTextColor(0, 0, 0);
        $this->Cell(0, 3, $pdfAgencyName, 0, 1, 'L');
        $this->Ln(5);
        $this->SetFont('Times', 'B', 11);
        $this->SetTextColor(131, 130, 139);
        $this->Cell(0, 3, "Powered by Getchs;", 0, 1, 'L');
        $this->tdheight = 5;
        $this->Ln(30);
        $this->SetFont('Times', 'B', 24);
        $this->SetTextColor(64, 64, 64);
        $this->Cell(0, 3, "LIST OF ALL APPLICANTS", 0, 1, 'C');
        $this->Ln(5);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect("{$db_hostname}", "{$db_username}", "{$db_password}");
mysql_select_db('remsdb');
$pdf = new PDF("L", "mm", array(300, 200));
$pdf->AddPage();
$pdf->SetTextColor(0, 0, 0);
$pdf->AddCol("Name", 55, 'Applicant Name', 'C');
$pdf->AddCol('basicEmail', 80, 'Email Address', 'C');
$prop = array('HeaderColor' => array(89, 201, 145), 'color1' => array(224, 235, 255), 'color2' => array(255, 255, 240));
$pdf->SetFont('Times', 'B', 30);
$pdf->Table("SELECT CONCAT (basicLastName , ',' , basicFirstName , ' ', basicMiddleName) AS Name, basicEmail\n\t\t\tFROM tbl_basic_info a, tbl_applicant b\n\t\t\tWHERE a.basicId = b.applicantId", $prop);
$pdf->Output();
コード例 #17
0
$pdf = new PDF('P', 'mm', 'Letter');
$pdf->Open();
$pdf->AddPage();
//table:
$pdf->SetFont('Arial', 'B', 12);
$pdf->Cell(0, 6, 'Listado de Morosos Ventas', 0, 1, 'C');
$pdf->AddCol('nom', 36, 'Nombres', 'C');
$pdf->AddCol('telefono', 18, 'Teléfono');
$pdf->AddCol('celular', 18, 'Celular');
$pdf->AddCol('giro', 9, 'Giro');
$pdf->AddCol('fechaV', 19, 'Fecha V', 'C');
$pdf->AddCol('monto', 15, 'Monto', 'C');
$pdf->AddCol('productoDes', 40, 'Descripción', 'C');
$pdf->AddCol('', 32, 'Observaciones', 'C');
$prop = array('HeaderColor' => array(210, 210, 210), 'color1' => array(255, 255, 255), 'color2' => array(235, 235, 235), 'padding' => 1);
$pdf->Table("SELECT *, CONCAT(nombres,' ',primerApellido) as nom\r\nFROM datospersonales, detallescliente\r\nWHERE datospersonales.id = detallescliente.id\r\nAND detallescliente.status =0\r\nAND detallescliente.fechaV <= '{$fechaP}'\r\nAND detallescliente.tipo = 1\r\nORDER BY datospersonales.cedula ASC, detallescliente.fechaV DESC, detallescliente.productoDes DESC", $prop);
$pdf->AddPage();
//table2:
$pdf->SetFont('Arial', 'B', 12);
$pdf->Cell(0, 6, 'Listado de Morosos Préstamos', 0, 1, 'C');
$pdf->AddCol('nom', 36, 'Nombres', 'C');
$pdf->AddCol('telefono', 18, 'Teléfono');
$pdf->AddCol('celular', 18, 'Celular');
$pdf->AddCol('giro', 9, 'Giro');
$pdf->AddCol('fechaV', 19, 'Fecha V', 'C');
$pdf->AddCol('monto', 15, 'Monto', 'C');
$pdf->AddCol('productoDes', 40, 'Descripción', 'C');
$pdf->AddCol('', 32, 'Observaciones', 'C');
$prop = array('HeaderColor' => array(210, 210, 210), 'color1' => array(255, 255, 255), 'color2' => array(235, 235, 235), 'padding' => 1);
$pdf->Table("SELECT *, CONCAT(nombres,' ',primerApellido) as nom\r\nFROM datospersonales, detallescliente\r\nWHERE datospersonales.id = detallescliente.id\r\nAND detallescliente.status =0\r\nAND detallescliente.fechaV <= '{$fechaP}'\r\nAND detallescliente.tipo <> 1\r\nORDER BY datospersonales.cedula ASC, detallescliente.fechaV DESC, detallescliente.productoDes DESC", $prop);
$pdf->Output();
コード例 #18
0
ファイル: client_pdf.php プロジェクト: loic04/gestcertif
        parent::Header();
    }
    //Pied de page
    function Footer()
    {
        //Positionnement à 1,5 cm du bas
        $this->SetY(-15);
        //Police Arial italique 8
        $this->SetFont('Arial', 'I', 8);
        //Numéro de page
        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');
    }
}
//Connexion à la base
mysql_connect('localhost', 'root', '');
mysql_select_db('gestcertdkb');
$pdf = new PDF();
$pdf->Open();
$pdf->AddPage();
$pdf->AliasNbPages();
//tableau : définit 6 colonnes
$pdf->AddCol('nom_client', 25, 'Nom');
$pdf->AddCol('prenom_client', 50, 'Prenoms');
$pdf->AddCol('mail_client', 50, 'Mail');
$pdf->AddCol('tel_client', 30, 'Contact');
$pdf->AddCol('certificat_client', 40, 'Certificat');
$prop = array('HeaderColor' => array(1, 254, 248), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 255), 'padding' => 1);
$pdf->Table('SELECT * FROM client', $prop);
$pdf->Output();
?>
 
}
//Connect to database
mysql_connect("{$db_hostname}", "{$db_username}", "{$db_password}");
mysql_select_db('remsdb');
$pdf = new PDF("L", "mm", array(400, 200));
$pdf->AddPage();
$pdf->SetFont('Times', 'B', 16);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', 'B', 14);
$pdf->SetY(8);
$pdf->SetX(10);
$pdf->Cell(0, 3, $pdfAgencyName, 0, 1, 'L');
$pdf->Ln(5);
$pdf->SetFont('Times', 'B', 12);
$pdf->SetTextColor(131, 130, 139);
$pdf->Cell(0, 3, "Powered by Getchs;", 0, 1, 'L');
$pdf->tdheight = 5;
$pdf->Ln(30);
$pdf->SetFont('Times', 'B', 24);
$pdf->SetTextColor(64, 64, 64);
$pdf->Cell(0, 3, "Employee Contract Report From: {$_SESSION['start1']} To: {$_SESSION['end1']}", 0, 1, 'C');
$pdf->Ln(10);
$pdf->AddCol("Name", 100, 'Employee Name', 'L');
$pdf->AddCol('clientName', 70, 'Client Name', 'L');
$pdf->AddCol('jobName', 60, 'Job', 'C');
$pdf->AddCol('contractStartDate', 45, 'Start of Contract', 'C');
$pdf->AddCol('contractEndDate', 45, 'End of Contract', 'C');
$prop = array('HeaderColor' => array(164, 219, 254), 'color2' => array(224, 235, 255), 'color1' => array(255, 255, 255));
$pdf->SetFont('Times', 'B', 24);
$pdf->Table("SELECT CONCAT (basicLastName , ',' , basicFirstName , ' ', basicMiddleName) AS Name, clientName, jobName, contractStartDate, contractEndDate\n\t\t\tFROM tbl_employee a, tbl_applicant b, tbl_basic_info c, tbl_client d, tbl_job_posting e, tbl_contract f \n\t\t\t\t\tWHERE a.applicantId = b.applicantId\n\t\t\t\t\tAND c.basicId = b.basicId\n\t\t\t\t\tAND a.jobPostingId = e.jobPostingId \n\t\t\t\t\tAND d.clientId = e.clientId\n\t\t\t\t\tAND f.employeeId = a.employeeId\n\t\t\tAND contractStartDate >= '{$_SESSION['start1']}' AND contractEndDate <= '{$_SESSION['end1']}' ", $prop);
$pdf->Output();
コード例 #20
0
         $this->Cell(0, 10, 'Report generated by nexexcel.com', 0, 0, 'R');
     }
 }
 $pdf = new PDF('L');
 $pdf->AliasNbPages();
 $pdf->SetAuthor("*****@*****.**");
 $pdf->SetSubject("Active Trial Balance");
 $pdf->SetTitle("Active Trial Balance");
 $pdf->SetCreator("Imran Zahid");
 $pdf->AddPage();
 $pdf->AddCol('rownum', '5%', 'S.No.', 'C');
 $pdf->AddCol('account_name', '45%', 'Account Name', 'L');
 $pdf->AddCol('debit', '25%', 'Debit', 'R');
 $pdf->AddCol('credit', '25%', 'Credit', 'R');
 $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 2, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 10));
 $pdf->Table($ndata, $prop, FALSE, TRUE);
 $width = $pdf->w - $pdf->lMargin - $pdf->rMargin;
 $pdf->SetFont('Arial', 'B', 8);
 $pdf->Cell(50 / 100 * $width, 5, 'Total', 1, 0, 'L', FALSE);
 $pdf->Cell(25 / 100 * $width, 5, number_format($dr, 2), 1, 0, 'R', FALSE);
 $pdf->Cell(25 / 100 * $width, 5, number_format($cr, 2), 1, 0, 'R', FALSE);
 $pdf->Ln();
 $drbal = "";
 $crbal = "";
 $bal = number_format($dr - $cr, 2);
 if ($cr > $dr) {
     $drbal = "({$bal})";
 } else {
     $crbal = $bal;
 }
 $pdf->SetFont('Arial', 'B', 10);
コード例 #21
0
ファイル: ledger.pdf.php プロジェクト: kashifnasim/nexexcel
        continue;
    }
    $pdf->AddPage();
    $pdf->AddCol('invseq', '9%', 'Invoice #', 'L');
    $pdf->AddCol('voucher_date', '10%', 'Date', 'L');
    $pdf->AddCol('voucher_cheque', '9%', 'Cheque', 'L');
    //if ($ret['account_cate'] != '276') {
    $pdf->AddCol('voucher_remarks', '42%', 'Description', 'L');
    /*} else {
    		$pdf->AddCol('voucher_remarks', '43%', 'Description', 'L');
    		$pdf->AddCol('days',            '5%',  'Days',        'R');
    	}*/
    $pdf->AddCol('debit_amount', '10%', 'Debit', 'R');
    $pdf->AddCol('credit_amount', '10%', 'Credit', 'R');
    $pdf->AddCol('balance', '10%', 'Balance', 'R');
    $pdf->Table($ret['data'], $prop);
    $ac = number_format($ret['aob']);
    if (count($ret['data']) > 0) {
        $ac = $ret['data'][count($ret['data']) - 1]['balance'];
    }
    $pdf->SetFont('Arial', 'B', 10);
    $cellSize = 11 / 100 * $pdf->TableWidth;
    $pdf->SetX($pdf->lMargin);
    $pdf->Cell(67 / 100 * $pdf->TableWidth, 5, 'Total', 0, 0, 'C');
    $pdf->Cell($cellSize, 5, number_format($ret['dr']), 0, 0, 'R');
    $pdf->Cell($cellSize, 5, number_format($ret['cr']), 0, 0, 'R');
    $pdf->Cell($cellSize, 5, $ac, 0, 0, 'R');
}
if (isset($_GET['account_class']) && strlen($_GET['account_class']) > 0) {
    $pdf->Output("ledger_class.pdf", "D");
} else {
コード例 #22
0
    {
        //Title
        $this->SetFont('Arial', '', 18);
        $this->Cell(0, 6, 'Jahresendabrechnung', 0, 1, 'C');
        $this->Ln(10);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect('mysql.hostinger.de', 'u947198430_user', 'yes123');
mysql_select_db('u947198430_db');
$pdf = new PDF('L');
$pdf->AddPage();
$wasser = "SELECT Kategorie, SUM(Betrag) AS Kosten\r\n            FROM Rechnungen\r\n            GROUP BY Kategorie\r\n            ";
$total = "SELECT SUM(Betrag) AS Totalnebenkosten\r\n            FROM Rechnungen\r\n            ";
//First table: put all columns automatically
$pdf->Table($wasser);
$pdf->Table($total);
//$pdf->AddPage();
//Second table: specify 3 columns
//$pdf->AddCol('Kategorie',40,'','C');
//$pdf->AddCol('Betrag',40,'','C');
//$prop=array('HeaderColor'=>array(255,150,100),
//'color1'=>array(210,245,255),
//'color2'=>array(255,255,210),
//'padding'=>2);
//$pdf->Table('SELECT Kategorie, SUM(Betrag) FROM `rechnungen` WHERE Kategorie =\'Wasser\'',$prop);
//$pdf->Output("C:\Users\John\Desktop/somename.pdf",'F');
$pdf->Output($downloadfilename . ".pdf");
header('Location: ' . $downloadfilename . ".pdf");
コード例 #23
0
 foreach ($data as $godown_name => $ndata) {
     $opening_balance = $ndata['opening_balance'];
     $rate = $ndata['rate'];
     if ($firstPage === true) {
         $pdf->AddPage();
         $firstPage = false;
     }
     $pdf->printTitle();
     $pdf->AddCol('sno', '5%', 'S#', 'C');
     $pdf->AddCol('event', '15%', 'Event', 'L');
     $pdf->AddCol('seq', '5%', 'ID', 'L');
     $pdf->AddCol('trans_date', '10%', 'Date', 'L');
     $pdf->AddCol('erate', '10%', 'Rate', 'R');
     $pdf->AddCol('op_qty', '15%', 'Quantity', 'R');
     $pdf->AddCol('p_remarks', '40%', 'Remarks', 'L');
     $pdf->Table($ndata['data'], $prop);
     $_cMargin = $pdf->cMargin;
     $pdf->cMargin = $prop['padding'];
     $pdf->SetFont('Arial', 'B', 10);
     $width = $pdf->w - $pdf->lMargin - $pdf->rMargin;
     $PC5 = 0.05 * $width;
     $pdf->Cell($width - $PC5 * 11, 6, 'Total', 0, 0, 'C', false);
     $pdf->Cell($PC5 * 3, 6, number_format($ndata['total'] + $opening_balance, 2), 0, 1, 'R', false);
     $pdf->Ln();
     $grandTotal += $ndata['total'] + $opening_balance;
 }
 $pdf->SetFont('Arial', 'B', 10);
 $width = $pdf->w - $pdf->lMargin - $pdf->rMargin;
 $PC5 = 0.05 * $width;
 $pdf->Cell($width - $PC5 * 11, 6, 'Grand Total', 0, 0, 'C', false);
 $pdf->Cell($PC5 * 3, 6, number_format($grandTotal, 2), 0, 1, 'R', false);
コード例 #24
0
<?php

require 'mysql_table.php';
class PDF extends PDF_MySQL_Table
{
    function Header()
    {
        //Title
        $this->SetFont('Arial', '', 16);
        $this->Cell(0, 6, 'Clientes', 0, 1, 'C');
        $this->Ln(10);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect('localhost', 'root', '');
mysql_select_db('appMantenimiento');
$pdf = new PDF();
$pdf->AddPage();
//First table: put all columns automatically
$sql_query = "SELECT \n\t\t\t\tid_cliente as Id,\n\t\t\t\tnombre as Nombre,\n\t\t\t\tnom_paterno as Paterno,\n\t\t\t\tnom_materno as Materno\n\t\tFROM clientes";
$pdf->Table($sql_query);
$pdf->AddPage();
header('Content-type: citas/pdf');
$pdf->Output('citas' . ".pdf", 'D');
コード例 #25
0
        $this->Cell(array_sum($w), 0, '', 'T');
    }
    // Pie de página
    function Footer()
    {
        // Posición: a 1,5 cm del final
        $this->SetY(-15);
        // Arial italic 8
        $this->SetFont('Arial', 'I', 8);
        // Número de página
        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '', 0, 0, 'C');
    }
}
$pdf = new PDF('P', 'mm', 'letter');
// Títulos de las columnas
$header = array('Cedula', '1er Nombre', '2do Nombre', '1er Apellido', '2do Apellido', 'Credencial', 'Status');
// Carga de datos
$pdf->SetFont('Arial', '', 12);
$pdf->AddPage();
$sql = "SELECT cedula_per,nombre1_per,nombre2_per,apellido1_per,apellido2_per,credencial_fun,status_fun FROM Persona  INNER JOIN Funcionario ON Persona.codigo_per = Funcionario.cod_per  ORDER BY cedula_per ASC ";
$resultado = mysql_query($sql);
//echo $resultado;
if (!$resultado) {
    echo "<script language='javascript'> alert('Error de Consulta!'); </script>";
} else {
    if (!mysql_num_rows($resultado)) {
        echo "<script language='javascript'> alert('Ningun Funcionario Registrado!'); window.close(); </script>";
    }
}
$pdf->Table($header, $resultado);
$pdf->Output();
コード例 #26
0
     $pdf->SetSubject("Warehouse Transfer");
     $pdf->SetTitle("Warehouse Transfer");
     $pdf->SetCreator("Imran Zahid");
     $prop = array('HeaderColor' => array(0, 0, 0), 'HeaderTextColor' => array(255, 255, 255), 'color1' => array(217, 217, 217), 'color2' => array(255, 255, 255), 'textcolor1' => array(0, 0, 0), 'textcolor2' => array(0, 0, 0), 'padding' => 2, 'font' => array('Arial', '', 8), 'thfont' => array('Arial', 'B', 8));
     foreach ($data as $id => $d) {
         $transDate = $d[0]['trans_date'];
         $billNo = $d[0]['billno'];
         $pdf->AddPage();
         $pdf->AddCol('sno', '5%', 'S#', 'C');
         $pdf->AddCol('cno', '10%', 'Cno', 'L');
         $pdf->AddCol('manufacturer_no', '15%', 'Part No', 'L');
         $pdf->AddCol('item', '35%', 'Description', 'L');
         $pdf->AddCol('cat_name', '20%', 'Model', 'L');
         $pdf->AddCol('qty', '10%', 'Quantity', 'R');
         $pdf->AddCol('unit', '5%', 'Unit', 'C');
         $pdf->Table($d, $prop);
     }
     $pdf->Output("warehouse_transfer.pdf", "D");
 } else {
     if ($_GET['report'] == 'xls') {
         require_once '../../Classes/PHPExcel.php';
         $padding = 0.71;
         $objPHPExcel = new PHPExcel();
         $objPHPExcel->getProperties()->setCreator("*****@*****.**")->setLastModifiedBy("Imran Zahid")->setTitle("Warehouse Transfer")->setSubject("Warehouse Transfer")->setDescription("Warehouse Transfer")->setKeywords("Warehouse Transfer")->setCategory("Reports");
         $activeSheet = $objPHPExcel->getActiveSheet();
         $activeSheet->getHeaderFooter()->setOddHeader('&C&18&B' . $title . '&R&U&D');
         $activeSheet->getHeaderFooter()->setOddFooter('&LPlease consider the environment before printing this report&C&IPage &P/&N&RReport generated by nexexcel.com');
         $activeSheet->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
         $activeSheet->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
         $activeSheet->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 2);
         $activeSheet->getColumnDimension('A')->setWidth(10 + $padding);
コード例 #27
0
ファイル: certificat_pdf.php プロジェクト: loic04/gestcertif
        $this->Cell(0, 6, 'LISTE DES CERTIFICATS', 0, 1, 'C');
        $this->Ln(10);
        //Imprime l'en-tête du tableau si nécessaire
        parent::Header();
    }
    //Pied de page
    function Footer()
    {
        //Positionnement à 1,5 cm du bas
        $this->SetY(-15);
        //Police Arial italique 8
        $this->SetFont('Arial', 'I', 8);
        //Numéro de page
        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');
    }
}
//Connexion à la base
mysql_connect('localhost', 'root', '');
mysql_select_db('gestcertdkb');
$pdf = new PDF();
$pdf->Open();
$pdf->AddPage();
$pdf->AliasNbPages();
//tableau : définit 6 colonnes
$pdf->AddCol('libelle_cert', 50, 'Nom du Certificat');
$pdf->AddCol('prix_cert', 60, 'Prix (CFA)');
$prop = array('HeaderColor' => array(1, 254, 248), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 255), 'padding' => 1);
$pdf->Table('SELECT * FROM certificat', $prop);
$pdf->Output();
?>
 
コード例 #28
0
ファイル: back_order.php プロジェクト: kashifnasim/nexexcel
         $pdf->AddCol('cno', '4%', 'Comp\\nNo', 'L', 10);
         $pdf->AddCol('manufacturer_no', '9%', 'Part\\nNo', 'L', 10);
         $pdf->AddCol('description', '16%', 'Item\\nDescription', 'L', 10);
         $pdf->AddCol('karachi', '6%', 'Karachi\\nGodown', 'R', 10);
         $pdf->AddCol('lahore', '6%', 'Lahore\\nGodown', 'R', 10);
         $pdf->AddCol('stock_total', '6%', 'Total', 'R', 10);
         $pdf->AddCol('cost', '5%', 'Cost', 'R', 10);
         $pdf->AddCol('amt', '6%', 'Amount', 'R', 10);
         $pdf->AddCol('reference', '8%', 'Order\\nNo', 'L', 10);
         $pdf->AddCol('o_date', '6%', 'Order\\nDate', 'L', 10);
         $pdf->AddCol('order', '5%', 'Order', 'R', 10);
         $pdf->AddCol('o_rate', '5%', 'Rate', 'R', 10);
         $pdf->AddCol('rec', '6%', 'Receive\\nQuantity', 'R', 10);
         $pdf->AddCol('bal', '6%', 'Balance\\nQuantity', 'R', 10);
         $pdf->AddCol('bal_amt', '6%', 'Balance\\nAmount', 'R', 10);
         $pdf->Table($d, $prop);
         $prop['font'] = array('Arial', 'B', 10);
         $totals = array();
         $totals[] = array('name' => 'Total', 'blank' => '', 'amt' => (double) 0, 'bal' => (double) 0);
         foreach ($d as $t) {
             $totals[0]['amt'] += $t['amt'];
             $totals[0]['bal'] += $t['bal_amt'];
         }
         $pdf->AddCol('name', '52%', 'Total', 'C');
         $pdf->AddCol('amt', '6%', 'Amount', 'R');
         $pdf->AddCol('blank', '36%', 'Blank', 'C');
         $pdf->AddCol('bal', '6%', 'Balance', 'R');
         $pdf->Table($totals, $prop, TRUE, FALSE);
     }
     $pdf->Output("back_order.pdf", "D");
 } else {
コード例 #29
0
// 	con filtro del motivos y depattamento
if ($depto != '-1' and $motivo != '-1' and ($fechai != "" and $fechaf != "")) {
    $query1 = " \nSelect empleado.No_Empleado, CONCAT(Primer_nombre, ' ', Segundo_nombre, ' ', Primer_apellido, ' ', Segundo_Apellido) as Nombre, departamento_laboral.nombre_departamento,motivos.descripcion, \nCOUNT(permisos.id_Permisos) as Solicitudes, SUM(permisos.dias_permiso) as Inasistencias from permisos\n inner join motivos on permisos.id_motivo=motivos.Motivo_ID \n inner join empleado on empleado.No_Empleado=permisos.No_Empleado \n inner join persona on persona.N_identidad=empleado.N_identidad \n inner join departamento_laboral on departamento_laboral.id_departamento_laboral = permisos.id_departamento \n where  departamento_laboral.nombre_departamento='" . $depto . "' and motivos.descripcion='" . $motivo . "' and \n date_format(permisos.fecha,'%d-%m-%Y') between  date_format('" . $fechai . " ','%d-%m-%Y')and date_format('" . $fechaf . "','%d-%m-%Y')\t\n\tGROUP BY Primer_nombre, Segundo_nombre, Primer_apellido, Segundo_Apellido, departamento_laboral.nombre_departamento,motivos.descripcion ORDER BY Primer_nombre asc";
}
// 	por fechas
if ($depto == '-1' and $motivo != '-1') {
    $query1 = " \nSelect empleado.No_Empleado, CONCAT(Primer_nombre, ' ', Segundo_nombre, ' ', Primer_apellido, ' ', Segundo_Apellido) as Nombre, departamento_laboral.nombre_departamento, motivos.descripcion, \nCOUNT(permisos.id_Permisos) as Solicitudes, SUM(permisos.dias_permiso) as Inasistencias from permisos\n inner join motivos on permisos.id_motivo=motivos.Motivo_ID \n inner join empleado on empleado.No_Empleado=permisos.No_Empleado \n inner join persona on persona.N_identidad=empleado.N_identidad \n inner join departamento_laboral on departamento_laboral.id_departamento_laboral = permisos.id_departamento \n where  motivos.descripcion='" . $motivo . "' and \n date_format(permisos.fecha,'%d-%m-%Y') between  date_format('" . $fechai . " ','%d-%m-%Y')and date_format('" . $fechaf . "','%d-%m-%Y')\t\n\tGROUP BY Primer_nombre, Segundo_nombre, Primer_apellido, Segundo_Apellido, departamento_laboral.nombre_departamento,motivos.descripcion ORDER BY Primer_nombre asc";
}
$pdf = new PDF();
$pdf->AddPage("L", "Letter");
$pdf->SetFont('Arial', '', 18);
$pdf->Image($maindir . 'assets/img/lucen-aspicio.png', 50, 15, 200, 200, 'PNG');
$pdf->Image($maindir . 'assets/img/logo_unah.png', 15, 5, 24, 36, 'PNG');
$pdf->Image($maindir . 'assets/img/logo-cienciasjuridicas.png', 230, 8, 35, 35, 'PNG');
$pdf->Cell(22, 10, '', 0);
$pdf->SetFont('Arial', '', 18);
$pdf->Cell(45, 10, '', 0);
$pdf->Cell(70, 10, utf8_decode('Universidad Nacional Autónoma de Honduras'), 0);
$pdf->Ln(10);
$pdf->SetFont('Arial', 'U', 14);
$pdf->Cell(60, 8, '', 0, 0, "C");
$pdf->Cell(130, 8, 'Reportes de Permisos Personales', 0, 0, "C");
$pdf->Ln(25);
//$pdf->AddCol('N',25,'#Empleado','C');
$pdf->AddCol('Nombre', 70, 'Nombre Completo', 'C');
$pdf->AddCol('nombre_departamento', 40, 'Departamento', 'C');
$pdf->AddCol('descripcion', 40, 'Motivo', 'C');
$pdf->AddCol('Solicitudes', 28, 'Solicitudes', 'R');
$pdf->AddCol('Inasistencias', 30, utf8_decode('Días Faltados'), 'R');
$pdf->Table($query1);
$pdf->Output();
コード例 #30
0
ファイル: GeneraPdf1.php プロジェクト: guillospy92/farm-app
{
    function Header()
    {
        //Title
        $this->SetFont('Arial', '', 18);
        $this->SetTextColor(255, 0, 0);
        $this->Cell(0, 6, 'Reporte  De Salidas', 0, 1, 'C');
        $this->Ln(10);
        //Ensure table header is output
        parent::Header();
    }
}
//Connect to database
mysql_connect('127.0.0.1', 'kmendoza0829', '');
mysql_select_db('u334911797_inven');
$fecha1 = $_POST['Fecha1'];
$fecha2 = $_POST['Fecha2'];
$date1 = date_create($fecha1);
$NFecha1 = date_format($date1, 'Y-m-d');
$date2 = date_create($fecha2);
$NFecha2 = date_format($date2, 'Y-m-d');
$pdf = new PDF();
$pdf->AddPage('L');
//First table: put all columns automatically
$prop = array('HeaderColor' => array(118, 216, 238), 'color1' => array(191, 191, 191), 'color2' => array(255, 255, 255), 'padding' => 2);
$pdf->Table('SELECT usuarios.Nombre, usuarios.Apellidos,salidas.FechaSalida,salidas.Cantidad,salidas.HoraSalida, salidas.Estado, productos.Descripcion
FROM usuarios
INNER JOIN salidas ON usuarios.IdUsu = salidas.IdUsu
INNER JOIN productos ON productos.codigo = salidas.codigo
    WHERE salidas.FechaSalida BETWEEN "' . $NFecha1 . '" AND "' . $NFecha2 . '"', $prop);
$pdf->Output();