public function drawPDF()
{
$pdf = new \FPDF('L', 'mm', 'Letter');
$pdf->SetMargins(3.175, 3.175, 3.175);
$pdf->SetAutoPageBreak(false);
if (\COREPOS\Fannie\API\FanniePlugin::isEnabled('CoopDealsSigns')) {
$this->font = 'Gill';
$this->alt_font = 'GillBook';
define('FPDF_FONTPATH', dirname(__FILE__) . '/../../../modules/plugins2.0/CoopDealsSigns/noauto/fonts/');
$pdf->AddFont('Gill', '', 'GillSansMTPro-Medium.php');
}
$pdf->SetFont($this->font, '', 16);
$data = $this->loadItems();
$width = 136.52;
$height = 105;
$top = 90;
$left = 15;
$effective_width = $width - 2 * $left;
foreach ($data as $item) {
$pdf->AddPage();
$column = 1;
// right aligned
$price = $this->printablePrice($item);
$pdf->SetXY($left + $width * $column, $top);
$pdf->SetFontSize($this->SMALL_FONT);
$pdf->Cell($effective_width, 10, $item['brand'], 0, 1, 'C');
$pdf->SetX($left + $width * $column);
$pdf->SetFontSize($this->MED_FONT);
$pdf->MultiCell($effective_width, 12, $item['description'], 0, 'C');
$pdf->SetX($left + $width * $column);
$pdf->SetFontSize($this->BIG_FONT);
$pdf->Cell($effective_width, 25, $price, 0, 1, 'C');
$y_pos = $pdf->GetY();
if ($item['startDate'] != '' && $item['endDate'] != '') {
// intl would be nice
$datestr = $this->getDateString($item['startDate'], $item['endDate']);
$pdf->SetXY($left + $width * $column, $top + ($height - 40));
$pdf->SetFontSize($this->SMALL_FONT);
$pdf->Cell($effective_width, 20, $datestr, 0, 1, 'R');
}
if ($item['originName'] != '') {
$pdf->SetXY($left + $width * $column, $y_pos);
$pdf->SetFontSize($this->SMALL_FONT);
if (strlen($item['originName']) < 50) {
$pdf->Cell($effective_width, 20, $item['originName'], 0, 1, 'L');
} else {
$pdf->Cell($effective_width, 20, $item['originShortName'], 0, 1, 'L');
}
}
}
$pdf->Output('WfcProdSingle.pdf', 'I');
}
/**
* Save PHPExcel to file
*
* @param string $pFileName
* @throws Exception
*/
public function save($pFilename = null) {
// Open file
global $cnf;
$pFilename= $cnf['path']['Temp'] . $pFilename;
$fileHandle = fopen($pFilename, 'w');
if ($fileHandle === false) {
throw new Exception("Could not open file $pFilename for writing.");
}
// Fetch sheets
$sheets = array();
if (is_null($this->_sheetIndex)) {
$sheets = $this->_phpExcel->getAllSheets();
} else {
$sheets[] = $this->_phpExcel->getSheet($this->_sheetIndex);
}
// PDF paper size
$paperSize = 'A4';
// Create PDF
$pdf = new FPDF('P', 'pt', $paperSize);
// Loop all sheets
foreach ($sheets as $sheet) {
// PDF orientation
$orientation = 'P';
if ($sheet->getPageSetup()->getOrientation() == PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE) {
$orientation = 'L';
}
// Start sheet
$pdf->SetAutoPageBreak(true);
$pdf->SetFont('Arial', '', 10);
$pdf->AddPage($orientation);
// Get worksheet dimension
$dimension = explode(':', $sheet->calculateWorksheetDimension());
$dimension[0] = PHPExcel_Cell::coordinateFromString($dimension[0]);
$dimension[0][0] = PHPExcel_Cell::columnIndexFromString($dimension[0][0]) - 1;
$dimension[1] = PHPExcel_Cell::coordinateFromString($dimension[1]);
$dimension[1][0] = PHPExcel_Cell::columnIndexFromString($dimension[1][0]) - 1;
// Calculate column widths
$sheet->calculateColumnWidths();
// Loop trough cells
for ($row = $dimension[0][1]; $row <= $dimension[1][1]; $row++) {
// Line height
$lineHeight = 0;
// Calulate line height
for ($column = $dimension[0][0]; $column <= $dimension[1][0]; $column++) {
$rowDimension = $sheet->getRowDimension($row);
$cellHeight = PHPExcel_Shared_Drawing::pixelsToPoints(
PHPExcel_Shared_Drawing::cellDimensionToPixels($rowDimension->getRowHeight())
);
if ($cellHeight <= 0) {
$cellHeight = PHPExcel_Shared_Drawing::pixelsToPoints(
PHPExcel_Shared_Drawing::cellDimensionToPixels($sheet->getDefaultRowDimension()->getRowHeight())
);
}
if ($cellHeight <= 0) {
$cellHeight = $sheet->getStyleByColumnAndRow($column, $row)->getFont()->getSize();
}
if ($cellHeight > $lineHeight) {
$lineHeight = $cellHeight;
}
}
// Output values
for ($column = $dimension[0][0]; $column <= $dimension[1][0]; $column++) {
// Start with defaults...
$pdf->SetFont('Arial', '', 10);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetDrawColor(100, 100, 100);
$pdf->SetFillColor(255, 255, 255);
// Coordinates
$startX = $pdf->GetX();
$startY = $pdf->GetY();
// Cell exists?
$cellData = '';
if ($sheet->cellExistsByColumnAndRow($column, $row)) {
if ($sheet->getCellByColumnAndRow($column, $row)->getValue() instanceof PHPExcel_RichText) {
$cellData = $sheet->getCellByColumnAndRow($column, $row)->getValue()->getPlainText();
} else {
if ($this->_preCalculateFormulas) {
$cellData = PHPExcel_Style_NumberFormat::ToFormattedString(
$sheet->getCellByColumnAndRow($column, $row)->getCalculatedValue(),
$sheet->getstyle( $sheet->getCellByColumnAndRow($column, $row)->getCoordinate() )->getNumberFormat()->getFormatCode()
);
} else {
$cellData = PHPExcel_Style_NumberFormat::ToFormattedString(
$sheet->getCellByColumnAndRow($column, $row)->getValue(),
$sheet->getstyle( $sheet->getCellByColumnAndRow($column, $row)->getCoordinate() )->getNumberFormat()->getFormatCode()
);
}
}
}
// Style information
$style = $sheet->getStyleByColumnAndRow($column, $row);
// Cell width
$columnDimension = $sheet->getColumnDimensionByColumn($column);
if ($columnDimension->getWidth() == -1) {
$columnDimension->setAutoSize(true);
$sheet->calculateColumnWidths(false);
}
$cellWidth = PHPExcel_Shared_Drawing::pixelsToPoints(
PHPExcel_Shared_Drawing::cellDimensionToPixels($columnDimension->getWidth())
);
// Cell height
$rowDimension = $sheet->getRowDimension($row);
$cellHeight = PHPExcel_Shared_Drawing::pixelsToPoints(
PHPExcel_Shared_Drawing::cellDimensionToPixels($rowDimension->getRowHeight())
);
if ($cellHeight <= 0) {
$cellHeight = $style->getFont()->getSize();
}
// Column span? Rowspan?
$singleCellWidth = $cellWidth;
$singleCellHeight = $cellHeight;
foreach ($sheet->getMergeCells() as $cells) {
if ($sheet->getCellByColumnAndRow($column, $row)->isInRange($cells)) {
list($first, ) = PHPExcel_Cell::splitRange($cells);
if ($first == $sheet->getCellByColumnAndRow($column, $row)->getCoordinate()) {
list($colSpan, $rowSpan) = PHPExcel_Cell::rangeDimension($cells);
$cellWidth = $cellWidth * $colSpan;
$cellHeight = $cellHeight * $rowSpan;
}
break;
}
}
// Cell height OK?
if ($cellHeight < $lineHeight) {
$cellHeight = $lineHeight;
$singleCellHeight = $cellHeight;
}
// Font formatting
$fontStyle = '';
if ($style->getFont()->getBold()) {
$fontStyle .= 'B';
}
if ($style->getFont()->getItalic()) {
$fontStyle .= 'I';
}
if ($style->getFont()->getUnderline() != PHPExcel_Style_Font::UNDERLINE_NONE) {
$fontStyle .= 'U';
}
$pdf->SetFont('Arial', $fontStyle, $style->getFont()->getSize());
// Text alignment
$alignment = 'L';
switch ($style->getAlignment()->getHorizontal()) {
case PHPExcel_Style_Alignment::HORIZONTAL_CENTER:
$alignment = 'C'; break;
case PHPExcel_Style_Alignment::HORIZONTAL_RIGHT:
$alignment = 'R'; break;
case PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY:
$alignment = 'J'; break;
case PHPExcel_Style_Alignment::HORIZONTAL_LEFT:
case PHPExcel_Style_Alignment::HORIZONTAL_GENERAL:
default:
$alignment = 'L'; break;
}
// Text color
$pdf->SetTextColor(
hexdec(substr($style->getFont()->getColor()->getRGB(), 0, 2)),
hexdec(substr($style->getFont()->getColor()->getRGB(), 2, 2)),
hexdec(substr($style->getFont()->getColor()->getRGB(), 4, 2))
);
// Fill color
if ($style->getFill()->getFillType() != PHPExcel_Style_Fill::FILL_NONE) {
$pdf->SetFillColor(
hexdec(substr($style->getFill()->getStartColor()->getRGB(), 0, 2)),
hexdec(substr($style->getFill()->getStartColor()->getRGB(), 2, 2)),
hexdec(substr($style->getFill()->getStartColor()->getRGB(), 4, 2))
);
}
// Border color
$borders = '';
if ($style->getBorders()->getLeft()->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
$borders .= 'L';
$pdf->SetDrawColor(
hexdec(substr($style->getBorders()->getLeft()->getColor()->getRGB(), 0, 2)),
hexdec(substr($style->getBorders()->getLeft()->getColor()->getRGB(), 2, 2)),
hexdec(substr($style->getBorders()->getLeft()->getColor()->getRGB(), 4, 2))
);
}
if ($style->getBorders()->getRight()->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
$borders .= 'R';
$pdf->SetDrawColor(
hexdec(substr($style->getBorders()->getRight()->getColor()->getRGB(), 0, 2)),
hexdec(substr($style->getBorders()->getRight()->getColor()->getRGB(), 2, 2)),
hexdec(substr($style->getBorders()->getRight()->getColor()->getRGB(), 4, 2))
);
}
if ($style->getBorders()->getTop()->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
$borders .= 'T';
$pdf->SetDrawColor(
hexdec(substr($style->getBorders()->getTop()->getColor()->getRGB(), 0, 2)),
hexdec(substr($style->getBorders()->getTop()->getColor()->getRGB(), 2, 2)),
hexdec(substr($style->getBorders()->getTop()->getColor()->getRGB(), 4, 2))
);
}
if ($style->getBorders()->getBottom()->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
$borders .= 'B';
$pdf->SetDrawColor(
hexdec(substr($style->getBorders()->getBottom()->getColor()->getRGB(), 0, 2)),
hexdec(substr($style->getBorders()->getBottom()->getColor()->getRGB(), 2, 2)),
hexdec(substr($style->getBorders()->getBottom()->getColor()->getRGB(), 4, 2))
);
}
if ($borders == '') {
$borders = 0;
}
if ($sheet->getShowGridlines()) {
$borders = 'LTRB';
}
// Image?
$iterator = $sheet->getDrawingCollection()->getIterator();
while ($iterator->valid()) {
if ($iterator->current()->getCoordinates() == PHPExcel_Cell::stringFromColumnIndex($column) . ($row + 1)) {
try {
$pdf->Image(
$iterator->current()->getPath(),
$pdf->GetX(),
$pdf->GetY(),
$iterator->current()->getWidth(),
$iterator->current()->getHeight(),
'',
$this->_tempDir
);
} catch (Exception $ex) { }
}
$iterator->next();
}
// Print cell
$pdf->MultiCell(
$cellWidth,
$cellHeight,
$cellData,
$borders,
$alignment,
($style->getFill()->getFillType() == PHPExcel_Style_Fill::FILL_NONE ? 0 : 1)
);
// Coordinates
$endX = $pdf->GetX();
$endY = $pdf->GetY();
// Revert to original Y location
if ($endY > $startY) {
$pdf->SetY($startY);
if ($lineHeight < $lineHeight + ($endY - $startY)) {
$lineHeight = $lineHeight + ($endY - $startY);
}
}
$pdf->SetX($startX + $singleCellWidth);
// Hyperlink?
if ($sheet->getCellByColumnAndRow($column, $row)->hasHyperlink()) {
if (!$sheet->getCellByColumnAndRow($column, $row)->getHyperlink()->isInternal()) {
$pdf->Link(
$startX,
$startY,
$endX - $startX,
$endY - $startY,
$sheet->getCellByColumnAndRow($column, $row)->getHyperlink()->getUrl()
);
}
}
}
// Garbage collect!
$sheet->garbageCollect();
// Next line...
$pdf->Ln($lineHeight);
}
}
// Document info
$pdf->SetTitle($this->_phpExcel->getProperties()->getTitle());
$pdf->SetAuthor($this->_phpExcel->getProperties()->getCreator());
$pdf->SetSubject($this->_phpExcel->getProperties()->getSubject());
$pdf->SetKeywords($this->_phpExcel->getProperties()->getKeywords());
$pdf->SetCreator($this->_phpExcel->getProperties()->getCreator());
// Write to file
fwrite($fileHandle, $pdf->output($pFilename, 'S'));
// Close file
fclose($fileHandle);
}
public function post_id_handler()
{
if (!is_array($this->id)) {
$this->id = array($this->id);
}
$today = date("F j, Y");
$pdf = new FPDF('L', 'in', array(3.5, 5.0));
$pdf->AddFont('Gill', '', 'GillSansMTPro-Medium.php');
$primary = "";
$pdf->SetAutoPageBreak(true, 0);
$pdf->SetFont("Gill", "", 10);
//Meat of the statement
foreach ($this->id as $card_no) {
$account = \COREPOS\Fannie\API\member\MemberREST::get($card_no);
$pdf->AddPage();
$pdf->SetXY(3.0, 1.45);
foreach ($account['customers'] as $c) {
if ($c['accountHolder']) {
$pdf->Cell(2, 0.25, $c['firstName'] . ' ' . $c['lastName'], "", 1, "L");
break;
}
}
$pdf->SetX(3.0);
$pdf->Cell(2, 0.25, $account['addressFirstLine'], "", 1, "L");
if ($account['addressSecondLine']) {
$pdf->SetX(3.0);
$pdf->Cell(2, 0.25, $account['addressSecondLine'], "", 1, "L");
}
$pdf->SetX(3.0);
$str = $account['city'] . ", " . $account['state'] . " " . $account['zip'];
$pdf->Cell(2, 0.25, $str, "", 1, "L");
}
$pdf->Output('member postcards.pdf', 'D');
return false;
}
$conexion = mysql_connect("localhost", "omorales", "wolf3333");
$basedatos = "sima";
$pdf = new FPDF();
$pdf->AddPage();
function saca_iva($can, $por)
{
$cant = $can;
$can = $can / 100 * $por;
$can += $cant;
return $can;
}
$pdf->SetFont('Arial', '', 8);
//establece el nombre del paciente
$pdf->SetXY(30, 5);
$pdf->Cell(0, 0, $paciente, 0, 0, L);
$pdf->SetX(1);
//numero de paciente
$pdf->Cell(0, 0, $_GET['numeroE'], 0, 0, R);
//cambiar fecha
//$myrow1['fecha1']=cambia_a_normal($myrow1['fecha1']);
$fecha1 = date("d/m/Y");
$pdf->SetY(10);
$pdf->Cell(0, 0, $fecha1, 0, 0, R);
//Imprimo con salto de pagina
$pdf->Ln(15);
//salto de linea
$pdf->SetFont('Arial', '', 8);
$pdf->SetXY(30, 7);
$pdf->Ln(15);
//salto de linea
$sSQL = "SELECT *\r\nFROM\r\ncargosCuentaPaciente\r\nWHERE \r\nnumeroE ='" . $_GET['numeroE'] . "' and nCuenta='" . $_GET['nCuenta'] . "' and\r\nnumeroConfirmacion='" . $_GET['numeroConfirmacion'] . "'\r\n\r\n\r\n ";
// Infos du client calées à droite
$pdf->Text(120, 50, $tClient['nomClient'].' '.$tClient['prenomClient']);
$pdf->Text(120, 55, $tClient['adresseClient']);
$pdf->Text(120, 60, $tClient['cpClient'].' '.$tClient['villeClient']);
// Infos date
$pdf->Text(120, 80, 'Buire, le '.date("d-m-Y", strtotime($tCommande[0]['dateFacture'])));
/* --- Tableau détail commande --- */
// en-tête
$pdf->SetDrawColor(183); // couleur du fond
$pdf->SetFillColor(221); // couleur des filets
$pdf->SetTextColor(0); // couleur du texte
$pdf->SetY(100);
$pdf->SetX(20);
$pdf->Cell(80, 10, 'Description du produit', 1, 0, 'L', 1);
$pdf->SetX(100);
$pdf->Cell(20, 10, 'Quantité', 1, 0, 'C', 1);
$pdf->SetX(120);
$pdf->Cell(35, 10, 'Prix unitaire HT', 1, 0, 'C', 1);
$pdf->SetX(155);
$pdf->Cell(30, 10, 'Montant HT', 1, 0, 'C', 1);
$pdf->Ln(); // retour à la ligne
// détail commande
$positionLigne = 110;
$totalHT = 0;
foreach ($tDetailCommande as $detailCommande) {
$totalHT += $detailCommande['qteProduit'] * $detailCommande['prixUnitaire'];
$column_code9 = $column_code9 . $row9 . "\n";
$column_code10 = $column_code10 . $row10 . "\n";
$column_code11 = $column_code11 . $row11 . "\n";
$column_code12 = $column_code12 . $row12 . "\n";
$number_of_rows = $number_of_rows + 1;
}
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$Y_Label_position = 50;
$Y_Table_Position = 55;
$pdf->SetFont('Arial', 'B', 6);
$pdf->SetY($Y_Label_position);
$pdf->SetX(5);
$pdf->Cell(35, 5, 'NAME OF BUSINESS' . $number_of_rows, 1, 0, 'C');
$pdf->SetX(40);
$pdf->Cell(20, 5, 'PERMIT NUMBER', 1, 0, 'C');
$pdf->SetX(60);
$pdf->Cell(60, 5, 'NAME OF OWNER', 1, 0, 'C');
$pdf->SetX(120);
$pdf->Cell(70, 5, 'BUSINESS ADDRESS', 1, 0, 'C');
$pdf->SetX(190);
$pdf->Cell(20, 5, '1ST QUARTER', 1, 0, 'C');
$pdf->SetX(210);
$pdf->Cell(15, 5, 'OR NUMBER', 1, 0, 'C');
$pdf->SetX(225);
$pdf->Cell(20, 5, '2ND QUARTER', 1, 0, 'C');
$pdf->SetX(245);
$pdf->Cell(15, 5, 'OR NUMBER', 1, 0, 'C');
public function drawPDF()
{
$pdf = new \FPDF('P', 'mm', 'Letter');
if (\COREPOS\Fannie\API\FanniePlugin::isEnabled('CoopDealsSigns')) {
$this->font = 'Gill';
$this->alt_font = 'GillBook';
define('FPDF_FONTPATH', dirname(__FILE__) . '/../../../modules/plugins2.0/CoopDealsSigns/noauto/fonts/');
$pdf->AddFont('Gill', '', 'GillSansMTPro-Medium.php');
$pdf->AddFont('Gill', 'B', 'GillSansMTPro-Heavy.php');
}
$width = 52;
// tag width in mm
$height = 31;
// tag height in mm
$left = 6;
// left margin
$top = 16;
// top margin
$pdf->SetTopMargin($top);
//Set top margin of the page
$pdf->SetLeftMargin($left);
//Set left margin of the page
$pdf->SetRightMargin($left);
//Set the right margin of the page
$pdf->SetAutoPageBreak(False);
// manage page breaks yourself
$data = $this->loadItems();
$num = 0;
// count tags
$x = $left;
$y = $top;
foreach ($data as $item) {
// extract & format data
$price = $item['normal_price'];
$desc = strtoupper(substr($item['posDescription'], 0, 25));
$brand = ucwords(strtolower(substr($item['brand'], 0, 13)));
$pak = $item['units'];
$size = $item['units'] . "-" . $item['size'];
$sku = $item['sku'];
$ppu = $item['pricePerUnit'];
$vendor = substr($item['vendor'], 0, 7);
$upc = $item['upc'];
if ($num % 32 == 0) {
$pdf->AddPage();
$x = $left;
$y = $top;
} else {
if ($num % 4 == 0) {
$x = $left;
$y += $height;
}
}
$pdf->SetFont($this->font, '', 8);
$pdf->SetXY($x, $y);
// try normal wordwrap
// but squeeze into two lines if needed
$wrapped = wordwrap($desc, 12, "\n", true);
if (count(explode("\n", $wrapped)) > 2) {
$wrapped = substr($desc, 0, 12);
if ($wrapped[11] != ' ') {
$wrapped .= '-';
}
$wrapped .= "\n";
$wrapped .= trim(substr($desc, 12));
}
$pdf->MultiCell($width / 2, 3, $wrapped, 0, 'L');
$pdf->SetX($x);
$pdf->Cell($width / 2, 3, date('n/j/y ') . $size, 0, 1, 'L');
$pdf->SetFont($this->font, 'B', 18);
//change font for price
$pdf->SetX($x);
$pdf->Cell($width / 2, 8, $price, 0, 1, 'L');
$args = array('height' => 7, 'align' => 'L', 'fontsize' => 8, 'width' => 0.23, 'font' => $this->font);
$b_y = $pdf->GetY();
$pdf = $this->drawBarcode($upc, $pdf, $x, $b_y, $args);
// move right by tag width
$x += $width;
$num++;
}
$pdf->Output('Tags4x8P.pdf', 'I');
}
$column_code7 = $column_code7 . $row7 . "\n";
$column_code8 = $column_code8 . $row8 . "\n";
$column_code9 = $column_code9 . $row9 . "\n";
$column_code10 = $column_code10 . $row10 . "\n";
$column_code11 = $column_code11 . $row11 . "\n";
}
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$Y_Label_position = 50;
$Y_Table_Position = 55;
$pdf->SetFont('Arial', 'B', 6);
$pdf->SetY($Y_Label_position);
$pdf->SetX(5);
$pdf->Cell(35, 5, 'NAME OF BUSINESS', 1, 0, 'C');
$pdf->SetX(40);
$pdf->Cell(20, 5, 'PERMIT NUMBER', 1, 0, 'C');
$pdf->SetX(60);
$pdf->Cell(60, 5, 'NAME OF OWNER', 1, 0, 'C');
$pdf->SetX(120);
$pdf->Cell(30, 5, 'BUSINESS NATURE', 1, 0, 'C');
$pdf->SetX(150);
$pdf->Cell(60, 5, 'BUSINESS ADDRESS', 1, 0, 'C');
$pdf->SetX(210);
$pdf->Cell(20, 5, '1ST QUARTER', 1, 0, 'C');
$pdf->SetX(230);
$pdf->Cell(15, 5, 'OR NUMBER', 1, 0, 'C');
$pdf->SetX(245);
$pdf->Cell(20, 5, '2ND QUARTER', 1, 0, 'C');
$pdf->Cell(125);
$pdf->Cell(30, 10, 'DATA SURAT MASUK', 0, 0, 'C');
$pdf->Ln();
$pdf->Cell(125);
$pdf->Cell(30, 10, 'KANTOR KESYAHBANDARAN TANJUNG PERAK SURABAYA', 0, 0, 'C');
$pdf->Ln();
}
//Fields Name position
$Y_Fields_Name_position = 30;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(110, 180, 230);
//Bold Font for Field Name
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(25, 8, 'No Agenda', 1, 0, 'C', 1);
$pdf->SetX(30);
$pdf->Cell(30, 8, 'Tanggal Agenda', 1, 0, 'C', 1);
$pdf->SetX(60);
$pdf->Cell(50, 8, 'No Surat', 1, 0, 'C', 1);
$pdf->SetX(110);
$pdf->Cell(25, 8, 'Tanggal Surat', 1, 0, 'C', 1);
$pdf->SetX(135);
$pdf->Cell(60, 8, 'Pengirim', 1, 0, 'C', 1);
$pdf->SetX(195);
$pdf->Cell(95, 8, 'Perihal', 1, 0, 'C', 1);
$pdf->Ln();
//Table position, under Fields Name
$Y_Table_Position = 38;
//Now show the columns
$pdf->Cell(190, 5, $getlgu[0], 0, 2, 'C');
$pdf->SetFont('Arial', 'B', 14);
$pdf->Cell(190, 5, 'Office of the Mayor', 0, 2, 'C');
$pdf->Cell(190, 5, '', 0, 2, 'C');
$pdf->SetFont('Arial', 'BU', 16);
$pdf->Cell(190, 5, 'PEDDLER PERMIT/LICENSE', 0, 1, 'C');
if ($reportpermit == '1') {
$result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),\n\tb.peddlers_business_name, b.for_year, b.application_date, \n\tconcat(a.owner_street, ' ', d.zone_desc, ' ', e.barangay_desc, ' ', f.district_desc, ' ', \n\tg.city_municipality_desc, ' ', h.province_desc, a.owner_zip_code), b.merchandise_sold, b.peddlers_permit_code, b.for_year, b.transaction \n\tfrom ebpls_owner a, ebpls_peddlers_permit b, \n\tebpls_zone d, ebpls_barangay e, ebpls_district f, ebpls_city_municipality g, ebpls_province h \n\twhere a.owner_id=b.owner_id and a.owner_zone_code = d.zone_code and a.owner_barangay_code=e.barangay_code and a.owner_district_code=f.district_code and a.owner_city_code=g.city_municipality_code and a.owner_province_code=h.province_code and b.peddlers_permit_code ='{$permit_num}' or a.owner_last_name = '{$owner_last}' and b.active = '1' order by peddlers_permit_id desc limit 1") or die(mysql_error());
} else {
$result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),\n\tb.peddlers_business_name, b.for_year, b.application_date, \n\tconcat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', \n\tg.city_municipality_desc, ', ', h.province_desc,' ', a.owner_zip_code), b.merchandise_sold, b.for_year, b.transaction \n\tfrom ebpls_owner a, ebpls_peddlers_permit b, \n\tebpls_zone d, ebpls_barangay e, ebpls_district f, ebpls_city_municipality g, ebpls_province h \n\twhere a.owner_id=b.owner_id and a.owner_zone_code = d.zone_code and a.owner_barangay_code=e.barangay_code and a.owner_district_code=f.district_code and a.owner_city_code=g.city_municipality_code and a.owner_province_code=h.province_code and b.peddlers_permit_code ='{$permit_num}' and b.active = '1'") or die(mysql_error());
}
$resulta = mysql_fetch_row($result);
$pdf->Cell(190, 5, '', 0, 1, 'C');
$pdf->Cell(190, 5, '', 0, 1, 'C');
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetX(5);
$pdf->Cell(50, 5, 'TO WHOM IT MAY CONCERN:', 0, 1, 'L');
$pdf->Cell(190, 5, '', 0, 1, 'C');
$pdf->SetFont('Arial', '', 10);
$pdf->SetX(10);
$pdf->Cell(40, 5, 'This is to certify that', 0, 0, 'L');
$pdf->SetX(50);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(150, 5, $resulta[0], 0, 1, 'C');
$pdf->SetX(50);
$pdf->Cell(150, 5, '-----------------------------------------------------------------------------------------------------------------------------', 0, 1, 'C');
$pdf->Cell(200, 5, '', 0, 1, 'C');
$pdf->SetX(10);
$pdf->SetFont('Arial', '', 10);
$pdf->Write(5, 'of ');
$pdf->SetFont('Arial', 'BU', 10);
$pdf->Cell(40, 5, '', 1, 0, 'C');
$pdf->Cell(40, 5, '', 1, 1, 'C');
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(70, 5, 'Others', 1, 0, 'L');
$pdf->SetFont('Arial', '', 10);
$pdf->Cell(40, 5, '', 1, 0, 'C');
$pdf->Cell(40, 5, '', 1, 0, 'C');
$pdf->Cell(40, 5, '', 1, 0, 'C');
$pdf->Cell(40, 5, '', 1, 0, 'C');
$pdf->Cell(40, 5, '', 1, 1, 'C');
//new signatories table
$result = mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
$resulta = mysql_fetch_row($result);
//$Y_Table_Position = $Y_Table_Position + 20;
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->SetY(-18);
$pdf->SetX(5);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(142, 5, 'Recommend Approval:', 1, 0, 'L');
$pdf->Cell(142, 5, 'Approved:', 1, 1, 'L');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->SetX(5);
$pdf->SetFont('Arial', 'BU', 10);
$pdf->Cell(142, 5, '', 1, 0, 'C');
$pdf->Cell(142, 5, $resulta[0], 1, 1, 'C');
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetX(5);
$pdf->Cell(142, 5, '', 1, 0, 'C');
$pdf->Cell(142, 5, $resulta[2], 1, 0, 'C');
$pdf->Output();
<?php
require 'extensions/fpdf.php';
require 'requests/_main.php';
switch ($_GET['id']) {
case '1':
$indexes = getIndexes();
//echo $indexes[0]->getMonth();
//echo "$/m² " . $indexes[0]->getPrice();
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Helvetica', 'B', 20);
$pdf->SetX(90);
$pdf->Cell(10, 25, $indexes[0]->getMonth());
$pdf->Ln();
$pdf->SetX(82);
$pdf->Cell(0, 0, '$/m² ' . $indexes[0]->getPrice());
$pdf->Output();
break;
case '2':
$sliders = getSliders();
$notes = getNotes();
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Helvetica', '', 8);
foreach ($sliders as $slider) {
if ($slider->getTitle() === "Hipótesis de Gestión Económica y Composición del Precio") {
$gallery = getSliderGallery($slider->getIdSlider());
if ($gallery) {
$filename = generateRandomString();
file_put_contents("_temp/" . $filename . getExtension($gallery[0]->getTypeImage()), $gallery[0]->getSliderImage());
$pdf->Cell(80);
$pdf->Cell(30, 10, 'DATA KARYAWAN', 0, 0, 'C');
$pdf->Ln();
$pdf->Cell(80);
$pdf->Cell(30, 10, 'PT. NiqoWeb Cikarang | www.niqoweb.com', 0, 0, 'C');
$pdf->Ln();
}
//Fields Name position
$Y_Fields_Name_position = 30;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(110, 180, 230);
//Bold Font for Field Name
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(25, 8, 'NIK', 1, 0, 'C', 1);
$pdf->SetX(30);
$pdf->Cell(40, 8, 'Nama', 1, 0, 'C', 1);
$pdf->SetX(70);
$pdf->Cell(25, 8, 'Tempat Lahir', 1, 0, 'C', 1);
$pdf->SetX(95);
$pdf->Cell(25, 8, 'Tanggal Lahir', 1, 0, 'C', 1);
$pdf->SetX(120);
$pdf->Cell(50, 8, 'Alamat', 1, 0, 'C', 1);
$pdf->SetX(170);
$pdf->Cell(35, 8, 'No Telepon', 1, 0, 'C', 1);
$pdf->Ln();
//Table position, under Fields Name
$Y_Table_Position = 38;
//Now show the columns
$CantNoContestan = $agenda->CantidadObservaciones($CodAl, $CodigosObservaciones);
$CantNoContestan = array_shift($CantNoContestan);
//Cantidad de Felicitaciones
$Obser = array();
$CodObser = $observaciones->CodObservaciones(7);
foreach ($CodObser as $CodO) {
$Obser[] = $CodO['CodObservacion'];
}
$CodigosObservaciones = implode(",", $Obser);
$CantFelicitacion = $agenda->CantidadObservaciones($CodAl, $CodigosObservaciones);
$CantFelicitacion = array_shift($CantFelicitacion);
$Total = $CantObser['Cantidad'] + $CantFaltas['Cantidad'] + $CantAtrasos['Cantidad'] + $CantLicencias['Cantidad'] + $CantNotificacion['Cantidad'] + $CantNoContestan['Cantidad'] + $CantFelicitacion['Cantidad'];
/********************FIN DE AGENDA****************/
$pdf->SetXY(15, 160);
$pdf->Cell(150, 5, utf8_decode($idioma["EstadisticaAgenda"] . ":"), 0, 1);
$pdf->SetX(15);
$pdf->Cell(30, 5, utf8_decode($idioma["Observaciones"]), 1, 0, "C");
$pdf->Cell(15, 5, utf8_decode($idioma["Faltas"]), 1, 0, "C");
$pdf->Cell(15, 5, utf8_decode($idioma["Atrasos"]), 1, 0, "C");
$pdf->Cell(20, 5, utf8_decode($idioma["Licencias"]), 1, 0, "C");
$pdf->Cell(35, 5, utf8_decode($idioma["NotificacionPadres"]), 1, 0, "C");
$pdf->SetFont("Arial", "", 8);
$pdf->Cell(25, 5, utf8_decode($idioma["NoRespondeTelf"]), 1, 0, "C");
$pdf->SetFont("Arial", "", 11);
$pdf->Cell(30, 5, utf8_decode($idioma["Felicitaciones"]), 1, 0, "C");
$pdf->Cell(15, 5, utf8_decode($idioma["Total"]), 1, 0, "C");
$pdf->Ln();
$pdf->SetX(15);
$pdf->Cell(30, 5, $CantObser['Cantidad'], 1, 0, "C");
$pdf->Cell(15, 5, $CantFaltas['Cantidad'], 1, 0, "C");
$pdf->Cell(15, 5, $CantAtrasos['Cantidad'], 1, 0, "C");
//font declaration des polices !
$courrier->AddFont('SourceSansPro-Regular', '', 'SourceSansPro-Regular.php');
$courrier->AddFont('SourceSansPro-Semibold', '', 'SourceSansPro-Semibold.php');
$courrier->AddFont('SourceSansPro-LightItalic', '', 'SourceSansPro-LightItalic.php');
$courrier->SetFont('SourceSansPro-Regular', '', 12);
$courrier->open();
$courrier->SetAutoPageBreak(1, 15);
$courrier->AddPage();
/* Création bloc emetteur */
$courrier->SetFont('SourceSansPro-Regular', '', 12);
$courrier->Image($logo, 5, 10, 45, 27);
$courrier->Ln(20);
$courrier->SetXY(55, 15);
$courrier->Cell(0, 5, $emetteur['nom'], 0, 2, 'L', false);
//largeur,hauteur,,texte,bodure,suite,alignement,couleur de fond;
$courrier->SetX(55);
$courrier->MultiCell(0, 5, $emetteur['adr'], 0, 'L', false);
//largeur,hauteur,,texte,bodure,suite,alignement,couleur de fond;
$courrier->SetX(55);
$courrier->MultiCell(0, 5, $emetteur['cp'] . " " . $ville, 0, 'L', false);
//largeur,hauteur,,texte,bodure,suite,alignement,couleur de fond;
$courrier->Ln(20);
/* Création bloc destinataire */
$courrier->SetFont('SourceSansPro-Regular', '', 12);
$courrier->SetX(120);
$courrier->Cell(0, 5, $destinataire['nom'], 0, 1, 'L', false);
//largeur,hauteur,,texte,bodure,suite,alignement,couleur de fond;
$courrier->SetX(120);
$courrier->MultiCell(0, 5, $destinataire['adr'], 0, 'L', false);
//largeur,hauteur,,texte,bodure,suite,alignement,couleur de fond;
$courrier->SetX(120);
$pdf->SetXY(10, 10);
//print transparent random text
$pdf->SetTextColor(255, 255, 255);
$pdf->Cell(0, 10, "{$timetext} - {$lastword}", 0, 0, 'C');
$pdf->SetXY($xmargin, 10);
$pdf->SetTextColor(0, 0, 0);
$pdf->Cell(0, 10, "{$org->organization_name} ({$org->companyno})", 0, 0, 'L');
//$pdf->SetFont("Times","",10);
//$pdf->Cell(0,12,"($org->companyno)",0,0,'L');
$pdf->SetXY($xmargin, 18);
//organization contact info block (2)
$orgadd1 = "{$org->street1} {$org->street2} {$org->street3}";
$pdf->SetFont("Times", "", 8);
$pdf->Cell(0, 4, "{$orgadd1} {$org->postcode} {$org->city} {$org->state} {$org->country_name}.", 0, 0, 'L');
$pdf->Ln();
$pdf->SetX($xmargin);
$pdf->Cell(0, 4, "Tel: {$org->tel_1} {$org->tel2} Fax: {$org->fax} Website: {$org->url} Email: {$org->email}", 0, 0, 'L');
//official receipt label block (3)
$pdf->SetXY(160, 8);
$pdf->SetFont("Times", "BU", 14);
$pdf->Cell(0, 12, "Official Receipt", "", 0, 'L');
//paymentvoucher no label block (4)
$pdf->SetXY($xmargin + 145, 13);
$pdf->SetFont("Times", "", 10);
$pdf->Cell(10, 12, "No. :", "", 0, 'L');
$pdf->SetFont("Times", "B", 10);
$pdf->Cell(0, 12, "{$receipt_prefix}{$receipt_no}", "", 0, 'R');
//paymentvoucher Date label block (5)
$pdf->SetXY($xmargin + 145, 18);
$pdf->SetFont("Times", "", 10);
$pdf->Cell(10, 12, "Date :", "", 0, 'L');
$column_code9 = $column_code9 . $row9 . "\n";
$column_code10 = $column_code10 . $row10 . "\n";
$column_code11 = $column_code11 . $row11 . "\n";
$column_code12 = $column_code12 . $row12 . "\n";
$number_of_rows = $number_of_rows + 1;
}
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$Y_Label_position = 50;
$Y_Table_Position = 55;
$pdf->SetFont('Arial', 'B', 6);
$pdf->SetY($Y_Label_position);
$pdf->SetX(5);
$pdf->Cell(35, 5, 'NAME OF BUSINESS', 1, 0, 'C');
$pdf->SetX(40);
$pdf->Cell(30, 5, 'PERMIT NUMBER', 1, 0, 'C');
$pdf->SetX(70);
$pdf->Cell(60, 5, 'NAME OF OWNER', 1, 0, 'C');
$pdf->SetX(130);
$pdf->Cell(70, 5, 'BUSINESS ADDRESS', 1, 0, 'C');
$pdf->SetX(200);
$pdf->Cell(20, 5, '1ST QUARTER', 1, 0, 'C');
$pdf->SetX(220);
$pdf->Cell(15, 5, 'OR NUMBER', 1, 0, 'C');
$pdf->SetX(235);
$pdf->Cell(20, 5, '2ND QUARTER', 1, 0, 'C');
$pdf->SetX(255);
$pdf->Cell(15, 5, 'OR NUMBER', 1, 0, 'C');
$pdf->Cell(80);
$pdf->Cell(30, 10, '', 0, 0, 'C');
$pdf->Ln();
$pdf->Cell(80);
$pdf->Cell(30, 10, 'LAPORAN DENDA', 0, 0, 'C');
$pdf->Ln();
}
//Fields Name position
$Y_Fields_Name_position = 30;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(204, 153, 0);
//Bold Font for Field Name
$pdf->SetFont('Arial', 'B', 8);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
//1 -->5 sebelah kiri
$pdf->Cell(21, 8, 'ID Anggota', 1, 0, 'C', 1);
$pdf->SetX(26);
//2 40 //geser lebar
$pdf->Cell(45, 8, 'Judul', 1, 0, 'C', 1);
//geser judul
$pdf->SetX(69);
//3
$pdf->Cell(30, 8, 'Tanggal Pinjam', 1, 0, 'C', 1);
$pdf->SetX(98);
//4
$pdf->Cell(32, 8, 'Tanggal harus kembali', 1, 0, 'C', 1);
$pdf->SetX(130);
//5
$pdf->Cell(26, 8, 'Tanggal Kembali', 1, 0, 'C', 1);
$pdf->SetFont('Times','',12);
// cell berukuran 20tinggi_awal10 mm, tanpa border, teks berikutnya akan
// diletakkan di bawah teks ini, posisi teks center dalam cell
/*
$pdf->Cell(100,100,"Text inside first column",1,0,'L');
$pdf->SetX($pdf->GetX() - 100);
$pdf->Cell(35,35,'Text inside second column ',1,0,'C');*/
$tinggi_awal = 20;
$tinggi_tengah = 60;
$lebar_awal = 60;
$lebar_total = 180;
$pdf->Cell($lebar_awal,$tinggi_awal,$pdf->Image('assets/img/logoairnav.jpg',13,12,14),1,0,'L');
$pdf->SetX($pdf->GetX() - 40);
$pdf->Cell(40,$tinggi_awal,"Airnav Indonesia",0,0,'L');
$pdf->Cell(120,$tinggi_awal,'Teks 1',1,1,'R');
$pdf->Cell($lebar_total,$tinggi_awal,'Teks 1',1,1,'C');
$pdf->Cell($lebar_awal,$tinggi_tengah,'Teks 1',1,0,'L');
$pdf->Cell(90,$tinggi_tengah,'Teks 1',1,0,'L');
$pdf->Cell(30,$tinggi_tengah,'Teks 1',1,1,'L');
$pdf->Cell($lebar_total,$tinggi_awal,'Teks 1',1,1,'L');
$pdf->Cell($lebar_awal,$tinggi_tengah,'Teks 1',1,0,'L');
$pdf->Cell(($lebar_total-$lebar_awal),$tinggi_tengah,'Teks 1',1,1,'L');
/* cell berukuran 40tinggi_awal10 mm, dengan border, teks berikutnya akan
// diletakkan pada posisi awal baris berikutnya, teks berada di kanan
// dalam cell
$pdf->Cell(40,10,'Teks 2',1,1,'R');
//Create new pdf file
$pdf = new FPDF();
//Open file
//$pdf->Open();
//Disable automatic page break
$pdf->SetAutoPageBreak(false);
//Add first page
$pdf->AddPage();
//set initial y axis position per page
$y_axis_initial = 25;
$y_axis = 31;
//print column titles for the actual page
$pdf->SetFillColor(232, 232, 232);
$pdf->SetFont('TIMES', 'B', 12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Cell(50, 6, 'Intitule', 1, 0, 'L', 1);
$pdf->Cell(30, 6, 'Quantite', 1, 0, 'C', 1);
$pdf->Cell(80, 6, 'Description', 1, 0, 'R', 1);
if (!isset($row_height)) {
$row_height = 0;
}
$y_axis = $y_axis + $row_height;
//Select the Products you want to show in your PDF file
$mail = $_SESSION['Email'];
if ($mail == "") {
$mail = "*****@*****.**";
}
$sqlquery = "SELECT Intitule, Quantite, Description FROM Fourniture WHERE IDClasse = (SELECT IDClasse from Eleve WHERE Mail='{$mail}' )";
//echo($sqlquery);
$result = $conn->query($sqlquery);
$pdf->SetFont("Arial", "B", 32);
$pdf->SetXY(0, 30);
$pdf->Cell(0, 0, "SAMPLE DOC Oumar Exe ", 0, 0, C);
$pdf->SetFont("Arial", "", 12);
$pdf->SetTextColor(130, 0, 0);
$pdf->Text(10, 45, "Title 1 ");
$pdf->SetTextColor(0);
$pdf->SetTextColor(0, 130, 0);
$pdf->Text(20, 50, "Title 2 ");
$pdf->SetTextColor(0);
$pdf->SetTextColor(20, 20, 130);
$pdf->Text(30, 55, "Title 3 ");
$pdf->SetTextColor(0);
$pdf->SetXY(10, 60);
$pdf->Text(10, 60, "BONJOUR COUCOU GRAND Darktsar Oumar Exe TRAORE ");
$cordX = $pdf->SetX($pdf->GetStringWidth("BONJOUR COUCOU GRAND Darktsar Oumar Exe TRAORE "));
$cordX = $pdf->GetX() + 9;
$pdf->SetFont("Arial", "B", 12);
$pdf->Text($cordX, 60, "SAMPLE ");
$pdf->SetFont("Arial", "", 12);
$pdf->SetFont("Arial", "", 12);
$cordX = $pdf->SetX($pdf->GetStringWidth("SAMPLE ")) + 18 + $cordX;
$pdf->Text($cordX, 60, " Fin de texte darktsar");
$pdf->SetXY(10, 65);
$pdf->SetFont("Arial", "I", 12);
$pdf->Text(10, 65, "SAMPLE ");
$pdf->SetFont("Arial", "", 12);
$pdf->SetTextColor(0, 130, 0);
$pdf->Text(20, 70, "Titre super ");
$pdf->SetTextColor(0);
$pdf->SetXY(10, 75);
$obs = "Ex Socio - Renunciado , C/Mora";
} else {
$obs = "Cese, C/Mora";
}
}
}
//==================================
$tot_descontar = $cuota_social + $credito_social + $seguro + $credito2;
$total_descontar = number_format($cuota_social + $credito_social + $seguro + $credito2, 0, ",", ".");
$credito_2_f = number_format($credito2, 0, ",", ".");
$rut_formateado = rut($rut_socio);
$suma = $suma + $cuota_social;
$suma1 = $suma1 + $credito_social;
$suma2 = $suma2 + $seguro;
$suma3 = $suma3 + $tot_descontar;
$pdf->SetX(10);
$pdf->SetFont('Arial', '', 7);
$pdf->Cell(18, 5, "{$rut_formateado}", 1, 0, "L");
$pdf->SetFont('Arial', '', 7);
$pdf->Cell(75, 5, "{$nombre_socio}", 1, 0, "L");
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(20, 5, "{$cuota_social_f}", 1, 0, "R");
$pdf->Cell(20, 5, "{$credito_social_f}", 1, 0, "R");
$pdf->Cell(10, 5, "{$cuotas_cuota}", 1, 0, "R");
$pdf->Cell(23, 5, "{$credito_2_f}", 1, 0, "R");
$pdf->Cell(10, 5, "{$cuotas_cuota2}", 1, 0, "R");
$pdf->Cell(22, 5, "{$seguro_f}", 1, 0, "R");
$pdf->Cell(18, 5, "{$total_descontar}", 1, 0, "R");
$pdf->Cell(16, 5, "", 1, 0, "R");
$pdf->SetFont('Arial', '', 7);
$pdf->Cell(16, 5, "{$tipo_seguro} {$carga}", 1, 0, "L");
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY($x, $y);
$pdf->Write(5, utf8_decode(mb_strtoupper($mitglied['nachname'], 'UTF-8')));
if ($mitglied['fl_dienst_wochentags'] == 'J') {
$pdf->SetFont('Times', 'B', 16);
$pdf->SetTextColor(255, 0, 0);
$pdf->Write(5, utf8_decode('*'));
}
// Schriftfarbe setzen
$pdf->SetTextColor(0, 0, 0);
// Schriftart festlegen
$pdf->SetFont('Times', '', 11);
$pdf->Write(5, utf8_decode(sprintf(', %s', $mitglied['vorname'])));
if ($mitglied['fl_dienst_absprache'] == 'J') {
// neue Position auf der X-Achse
$pdf->SetX(80);
// Schriftart festlegen
$pdf->SetFont('Times', 'B', 11);
$pdf->SetTextColor(255, 0, 0);
$pdf->Write(5, utf8_decode('(n.n.R.)'));
}
// Schriftart festlegen
$pdf->SetFont('Times', '', 11);
$pdf->SetTextColor(0, 0, 0);
$y_alt = $pdf->GetY();
$offset = 0;
if (!empty($mitglied['telefon1'])) {
$pdf->SetX(110);
$pdf->Write(5, utf8_decode(sprintf('%s (privat)', $mitglied['telefon1'])));
$y += 5;
$offset += 5;
$column_code8 = $column_code8.$row8."\n";
$column_code9 = $column_code9.$row9."\n";
$column_code10 = $column_code10.$row10."\n";
$column_code11 = $column_code11.$row11."\n";
} */
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$Y_Label_position = 50;
$Y_Table_Position = 55;
$pdf->SetFont('Arial', 'B', 8);
$pdf->SetY($Y_Label_position);
$pdf->SetX(5);
$pdf->Cell(15, 5, 'AMOUNT PAID', 1, 0, 'C');
$pdf->SetX(20);
$pdf->Cell(50, 5, 'DATE', 1, 0, 'C');
$pdf->SetX(70);
$pdf->Cell(50, 5, 'O.R. NUMBER', 1, 0, 'C');
$pdf->SetX(120);
$pdf->Cell(30, 5, 'STICKER NUMBER', 1, 0, 'C');
$pdf->SetX(150);
$pdf->Cell(60, 5, 'PERMIT NUMBRT', 1, 0, 'C');
$pdf->SetX(210);
$pdf->Cell(30, 5, 'CHASSIS NUMBER', 1, 0, 'C');
$pdf->SetX(240);
$pdf->Cell(30, 5, 'MOTOR NUMBER', 1, 0, 'C');
$pdf->SetX(270);
$pdf->SetFont('Arial', '', 6);
}
/* ENTETE - FIN */
/* ENTETE TITRE - DEBUT */
$pdf->SetFont('DejaVu','B',18);
$pdf->SetXY(85, 10);
$pdf->Cell(120, 6, 'Bilan journalier des absences', 0, 1, 'C');
$pdf->SetFont('DejaVu','',12);
$pdf->SetX(85);
$pdf->Cell(120, 8, 'du '.$date_choisie, 0, 1, 'C');
$pdf->SetX(85);
$pdf->Cell(120, 5, ('année'), 0, 1, 'C');
$pdf->SetX(85);
$pdf->Cell(120, 5, ($annee_scolaire), 0, 1, 'C');
/* ENTETE TITRE - FIN */
/* ENTETE TABLEAU - DEBUT */
//Sélection de la police
}
mysql_close();
//Create a new PDF file
$pdf = new FPDF();
$pdf->AddPage();
//Fields Name position
$Y_Fields_Name_position = 20;
//Table position, under Fields Name
$Y_Table_Position = 26;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232, 232, 232);
//Bold Font for Field Name
$pdf->SetFont('Arial', 'B', 12);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(45);
$pdf->Cell(30, 6, 'StudentID', 1, 0, 'L', 1);
$pdf->SetX(65);
$pdf->Ln();
//Now show the 3 columns
$pdf->SetFont('Arial', '', 12);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(45);
$pdf->MultiCell(30, 6, $column_ID, 1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(65);
//Create lines (boxes) for each ROW (Product)
//If you don't use the following code, you don't create the lines separating each row
$i = 0;
$pdf->SetY($Y_Table_Position);
while ($i < $number_of_products) {
<?php
include 'config.php';
require '../assets/pdf/fpdf.php';
$pdf = new FPDF("L", "cm", "A4");
$pdf->SetMargins(2, 1, 1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', 'B', 11);
$pdf->Image('../logo/malasngoding.png', 1, 1, 2, 2);
$pdf->SetX(4);
$pdf->MultiCell(19.5, 0.5, 'KIOS MALASNGODING', 0, 'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5, 0.5, 'Telpon : 0038XXXXXXX', 0, 'L');
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetX(4);
$pdf->MultiCell(19.5, 0.5, 'JL. KIOS MALASNGODING', 0, 'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5, 0.5, 'website : www.malasngoding.com email : malasngoding@gmail.com', 0, 'L');
$pdf->Line(1, 3.1, 28.5, 3.1);
$pdf->SetLineWidth(0.1);
$pdf->Line(1, 3.2, 28.5, 3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial', 'B', 14);
$pdf->Cell(0, 0.7, 'Laporan Data Penjualan Barang', 0, 0, 'C');
$pdf->ln(1);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(5, 0.7, "Di cetak pada : " . date("D-d/m/Y"), 0, 0, 'C');
$pdf->ln(1);
$pdf->Cell(6, 0.7, "Laporan Penjualan pada : " . $_GET['tanggal'], 0, 0, 'C');
$pdf->Cell(300, 5, 'ACTIVITY LOG', 0, 1, 'C');
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->Cell(270, 5, '', 0, 1, 'C');
$pdf->SetLineWidth(2);
$pdf->Line(0, 45, 360, 45);
$pdf->SetLineWidth(0);
//$pdf->Cell(270,5,'',0,1,'C');
//$pdf->Cell(270,5,'',0,1,'C');
$Y_Label_Position = 50;
$Y_Table_Position = 55;
$pdf->SetFont('Arial', 'B', 6);
$pdf->SetY($Y_Label_Position);
$pdf->SetX(5);
$pdf->Cell(10, 5, 'USER ID', 1, 0, 'C');
$pdf->SetX(15);
$pdf->Cell(30, 5, 'USER LEVEL', 1, 0, 'C');
$pdf->SetX(45);
$pdf->Cell(20, 5, 'USERNAME', 1, 0, 'C');
$pdf->SetX(65);
$pdf->Cell(20, 5, 'REMOTE IP', 1, 0, 'C');
$pdf->SetX(85);
$pdf->Cell(25, 5, 'DATE UPDATED', 1, 0, 'C');
$pdf->SetX(110);
$pdf->Cell(180, 5, 'QUERY STRING', 1, 1, 'C');
$date_from = str_replace("/", "", $date_from);
$idate = strtotime($date_from);
$idate = $idate - 60 * 60 * 24;
$date_from = date('Y-m-d', $idate);
public function pdfcreateAction()
{
require "fpdf/fpdf.php";
$order_id = $_GET['order_id'];
$img_path = $_GET['img_path'];
$count = $_GET['count'];
$customer_email = $_GET['customer_email'];
$customer = Mage::getModel("customer/customer");
$customer->setWebsiteId(Mage::app()->getWebsite()->getId());
$customer->loadByEmail($customer_email);
$orderId = Mage::getModel('sales/order')->loadByIncrementId($order_id)->getEntityId();
$order = Mage::getModel('sales/order')->load($orderId);
$billing_address = $order->getBillingAddress();
//print_r($billing_address->getData());
$model = Mage::getModel('rcredit/rcredit');
$order_details = $model->orderhistory($customer_email, $count);
$customer_info = $model->customercycledetails($customer_email);
//print_r($customer_info);
$date = new DateTime($customer_info[pay_date]);
$pay_date = $date->format('d-m-Y');
$pdf = new FPDF();
$pdf->AddPage();
$linestyle = array('width' => 0.1, 'cap' => 'butt', 'join' => 'miter', 'dash' => '', 'phase' => 10, 'color' => array(255, 0, 0));
$pdf->SetFont('Times', '', 11);
$pdf->Cell(200, 10, 'Corporate Credit Statement', 2, 2, 'C');
$pdf->SetFont('Times', 'B', 8);
$pdf->Line(150, 17, 180, 17, $linestyle);
$pdf->SetX(350);
$pdf->SetY(13);
$pdf->Cell(310, 5, 'Customer Billing Address', 2, 2, 'C');
$pdf->SetFont('Times', '', 8);
$pdf->SetX(150);
$pdf->Cell(342, 5, $billing_address[firstname] . '.' . $billing_address[lastname], 2, 2, 'L');
$pdf->Cell(342, 6, $billing_address[street], 2, 2, 'L');
$pdf->Cell(342, 7, $billing_address[city] . '.' . $billing_address[country_id] . '-' . $billing_address[postcode], 2, 2, 'L');
$pdf->Image($img_path, 10, 10, 31, 20, 'PNG', '', '', false, 300, '', false, false, 0, false, false, false);
$pdf->SetY(20);
$pdf->SetFont('Times', '', 8);
$pdf->Line(5, 35, 200, 35, $linestyle);
// Company Account Numbers
$pdf->SetX(20);
$pdf->SetY(28);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'VAT/TIN : ', 0, 0, 'L');
$pdf->SetX(25);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, ' 29471119182', 0, 0, 'L');
$pdf->SetX(85);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'CST No: ', 0, 0, 'L');
$pdf->SetX(98);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, ' 29471119182', 0, 0, 'L');
$pdf->SetX(150);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'CIN No : ', 0, 0, 'L');
$pdf->SetX(164);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, ' U52100KA2012PTC066880', 0, 0, 'L');
$pdf->Line(5, 40, 200, 40, $linestyle);
//End of company account numbers
// Starting of customer details
$pdf->SetX(20);
$pdf->SetY(33);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'Email : ', 0, 0, 'L');
$pdf->SetX(25);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, $customer_email, 0, 0, 'L');
$pdf->SetX(85);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'Company Name: ', 0, 0, 'L');
$pdf->SetX(110);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, $customer_info[company_name], 0, 0, 'L');
//$pdf->SetX(150);
//$pdf->SetFont('Times','B',8);
//$pdf->Cell(0,20,'Account Manager : ', 0,0,'L');
//$pdf->SetX(164);
//$pdf->SetFont('Times','',8);
//$pdf->Cell(0,20,' AASDV846SV654V', 0,0,'L');
$pdf->Line(5, 45, 200, 45, $linestyle);
//End of customer details
// Starting of customer details
$pdf->SetX(20);
$pdf->SetY(38);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'Payment Due Date : ', 0, 0, 'L');
$pdf->SetX(35);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, $pay_date, 0, 0, 'L');
$pdf->SetX(85);
$pdf->SetFont('Times', 'B', 8);
$pdf->Cell(0, 20, 'Availed Credit: ', 0, 0, 'L');
$pdf->SetX(110);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 20, 'Rs ' . $customer_info[utlized_amt] . '/-', 0, 0, 'L');
$pdf->Line(5, 50, 200, 50, $linestyle);
//End of customer details
$pdf->SetX(30);
$pdf->SetFont('Times', '', 8);
$pdf->Cell(0, 30, 'Dear ' . $firstname . ',', 0, 0, 'L');
//$pdf->SetX(20);
$pdf->SetY(55);
$pdf->Cell(0, 1, 'Thank you for your interest in buying from us. Please find the below details of your selected products', 0, 0, 'L');
$i = 10;
$pdf->SetFont('Times', '', 6);
$pdf->SetX(5);
$pdf->SetY(65);
$pdf->Cell(15, 10, 'Order ID', 1, 0, 'C');
$pdf->Cell(20, 10, 'Order Date', 1, 0, 'C');
$pdf->Cell(20, 10, 'Order Amount', 1, 0, 'C');
$pdf->Cell(20, 10, 'Credit Availed', 1, 0, 'C');
$pdf->Cell(20, 10, 'Order Status', 1, 0, 'C');
$pdf->Cell(20, 10, 'Delivery Date', 1, 0, 'C');
$pdf->Cell(25, 10, 'Payment Status', 1, 0, 'C');
$pdf->Cell(20, 10, 'Payment Date', 1, 0, 'C');
$pdf->Cell(30, 10, 'Payment Details', 1, 0, 'C');
//$pdf->SetX(20);
$pdf->SetX(5);
$pdf->SetY(75);
$pdf->SetX(20);
foreach ($order_details as $details) {
$order_date = explode(" ", $details['order_date']);
$i = $i + 1;
$pdf->SetX(10);
$pdf->Cell(15, $i, $details['order_id'], 1, 0, 'C');
$pdf->Cell(20, $i, $order_date[0], 1, 0, 'C');
$pdf->Cell(20, $i, $details['order_value'], 1, 0, 'C');
$pdf->Cell(20, $i, $details['utlized_amt'], 1, 0, 'C');
$pdf->Cell(20, $i, $details['action'], 1, 0, 'C');
$pdf->Cell(20, $i, $details['order_complete_date'], 1, 0, 'C');
$pdf->Cell(25, $i, $details['pay_status'], 1, 0, 'C');
$pdf->Cell(20, $i, $details['paid_date'], 1, 0, 'C');
$pdf->Cell(30, $i, $details['trans_details'], 1, 1, 'C');
//$pdf->SetX(20);
}
$pdf->SetFont('Times', 'B', 8);
$pdf->SetX(80);
$pdf->Cell(100, 20, 'Total : Rs.' . $details['utlized_amt'] . '/-', 0, 0, 'R');
$pdf->Output('Shopper Credit Invoice.pdf', 'D');
}
public function post_id_upc_terms_handler()
{
$this->id = preg_split('/[^\\d]/', $this->id, 0, PREG_SPLIT_NO_EMPTY);
$pdf = new FPDF('P', 'mm', 'Letter');
$pdf->SetMargins(6.35, 6.35, 6.35);
// quarter-inch margins
$pdf->SetAutoPageBreak(false);
$pdf->AddFont('Gill', '', 'GillSansMTPro-Medium.php');
$pdf->AddFont('Gill', 'B', 'GillSansMTPro-Heavy.php');
$margins = $pdf->GetMargins();
$margins['top'] = 0.0;
$check_left_x = $margins['left'] > 3.175 ? $margins['right'] : 3.175 - $margins['left'];
$real_check_top_y = 183.675 - $margins['top'];
$check_right_x = 203.2 - $margins['left'];
$real_check_bottom_y = 255.112 - $margins['top'];
$line_height = 5;
$envelope_window_tab = 15;
$right_col1 = 130;
$right_col2 = 170;
$my_address = array('610 E 4th St', 'Duluth, MN 55805', 'Tel: 218.728.0884', 'www.wholefoods.coop');
$check_date = date('F j, Y');
$dbc = $this->connection;
$dbc->setDefaultDB($this->config->get('OP_DB'));
$signage = new COREPOS\Fannie\API\item\FannieSignage(array());
foreach ($this->id as $card_no) {
$pdf->AddPage();
$account = \COREPOS\Fannie\API\member\MemberREST::get($card_no);
$primary = array();
foreach ($account['customers'] as $c) {
if ($c['accountHolder']) {
$primary = $c;
break;
}
}
$check_number = rand(100000, 999995);
for ($i = 0; $i < 3; $i++) {
$pdf->SetFont('Gill', '', 10);
$check_top_y = $real_check_top_y - $i * 90;
$check_bottom_y = $real_check_bottom_y - $i * 90;
$pdf->SetXY($check_left_x, $check_top_y);
$pdf->Ln($line_height * 4.25);
foreach ($my_address as $line) {
$pdf->SetX($check_left_x + $envelope_window_tab + 20);
if ($line == 'www.wholefoods.coop') {
$pdf->SetFont('Gill', 'B', 9);
}
$pdf->Cell(0, $line_height, $line, 0, 1);
}
$pdf->SetFont('Gill', 'B', 10);
$pdf->SetXY($check_left_x + $right_col1, $check_top_y);
$pdf->Cell(30, $line_height, 'Check Number:', 0, 0, 'R');
$pdf->SetFont('Gill', '', 10);
$pdf->SetTextColor(0xff, 0x58, 0);
$pdf->SetX($check_left_x + $right_col2);
$pdf->Cell(30, $line_height, $check_number, 0, 0, 'R');
$pdf->SetFont('Gill', 'B', 10);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY($check_left_x + $right_col1, $check_top_y + 1.5 * $line_height);
$pdf->Cell(30, $line_height, 'Date:', 0, 0, 'R');
$pdf->SetFont('Gill', '', 10);
$pdf->SetTextColor(0xff, 0x58, 0);
$pdf->SetX($check_left_x + $right_col2);
$pdf->Cell(30, $line_height, $check_date, 0, 0, 'R');
$pdf->SetXY($check_left_x + $right_col1, $check_top_y + 3 * $line_height);
$pdf->SetFont('Gill', 'B', 10);
$pdf->SetTextColor(0, 0, 0);
$pdf->Cell(30, $line_height, 'Amount:', 0, 0, 'R');
$pdf->SetXY($check_left_x + $right_col1 + 30, $check_top_y + 3 * $line_height);
$pdf->SetFont('Gill', '', 10);
$pdf->SetTextColor(0xff, 0x58, 0);
$pdf->MultiCell(40, $line_height, str_repeat(' ', 2) . $this->terms, 0, 'R');
$pdf->SetTextColor(0, 0, 0);
$their_address = array($primary['firstName'] . ' ' . $primary['lastName']);
$their_address[] = $account['addressFirstLine'];
if ($account['addressSecondLine']) {
$their_address[] = $account['addressSecondLine'];
}
$their_address[] = $account['city'] . ', ' . $account['state'] . ' ' . $account['zip'];
$pdf->SetXY($check_left_x + $envelope_window_tab, $check_top_y + 11 * $line_height);
$pdf->SetFont('Gill', 'B', 10);
foreach ($their_address as $line) {
$pdf->SetX($check_left_x + $envelope_window_tab);
$pdf->Cell(0, $line_height, $line, 0, 1);
}
$pdf->SetFont('Gill', '', 10);
$pdf->SetXY($check_left_x, $check_bottom_y + $line_height - 1);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Gill', 'B', 10);
$pdf->Cell(0, $line_height, 'Redeemable only at Whole Foods Co-op', 0, 0, 'C');
$pdf->SetFont('Gill', '', 10);
$pdf->SetXY($check_left_x + 145, $check_top_y + 6 * $line_height + 1);
$pdf->SetFont('Gill', '', 8);
$pdf->MultiCell(50, $line_height - 2, 'Limit one per day. Cannot be applied to previous purchases. No cash value.');
$pdf->SetFont('Gill', '', 10);
$pdf->SetFillColor(0xcc, 0xcc, 0xcc);
$pdf->Rect($check_left_x + 84, $check_top_y + 28, 39, 15, 'F');
$pdf->SetFillColor(0, 0, 0);
$signage->drawBarcode(ltrim($this->upc, '0'), $pdf, $check_left_x + 87, $check_top_y + 30, array('height' => 11, 'fontsize' => 0));
$pdf->Image('logo.rgb.noalpha.png', $check_left_x + $envelope_window_tab, $check_top_y + 20, 20);
$pdf->SetFont('Gill', 'B', '31');
$pdf->SetXY($check_left_x + $envelope_window_tab, $check_top_y + 0.5 * $line_height);
$pdf->SetTextColor(0xff, 0x58, 0);
$pdf->Cell(0, 3 * $line_height, 'We Appreciate You!');
$pdf->SetFont('Gill', '', '10');
$pdf->SetTextColor(0, 0, 0);
$pdf->Image(dirname(__FILE__) . '/../GiveUsMoneyPlugin/img/sig.png', $check_right_x - 63.5, $check_top_y + 9 * $line_height, 63.5);
$pdf->SetXY($check_right_x - 63.5, $check_top_y + 12 * $line_height);
$pdf->Cell(63.5, $line_height, 'Authorized By Signature', 'T');
$check_number++;
}
}
$pdf->Output();
}
