public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 017');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 017', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
$pdf->setLanguageArray($this->langSettings);
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 20);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of independent Multicell() columns', '', 0, 'L', true, 0, false, false, 0);
$pdf->Ln(5);
$pdf->SetFont('times', '', 12);
// create columns content
// create columns content
$left_column = '[LEFT COLUMN] left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column' . "\n";
$right_column = '[RIGHT COLUMN] right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column' . "\n";
// MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0)
// set color for background
$pdf->SetFillColor(255, 255, 200);
// set color for text
$pdf->SetTextColor(0, 63, 127);
// write the first column
$pdf->MultiCell(80, 0, $left_column, 1, 'J', 1, 0, '', '', true, 0, false, true, 0);
// set color for background
$pdf->SetFillColor(215, 235, 255);
// set color for text
$pdf->SetTextColor(127, 31, 0);
// write the second column
$pdf->MultiCell(80, 0, $right_column, 1, 'J', 1, 1, '', '', true, 0, false, true, 0);
// reset pointer to the last page
$pdf->lastPage();
$this->comparePdfs($pdf);
}
function showPdf($idReg = "")
{
global $db;
// Oficina
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 009');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING);
// set header and footer fonts
//$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
// $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// $pdf->SetFooterMargin(3);
$pdf->setPageOrientation('P', '', 1);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
//$pdf->setLanguageArray($l);
// set some language dependent data:
$lg = array();
$lg['a_meta_charset'] = 'ISO-8859-1';
$lg['a_meta_dir'] = 'ltr';
$lg['a_meta_language'] = 'en';
$lg['w_page'] = 'page';
//set some language-dependent strings
$pdf->setLanguageArray($lg);
// -------------------------------
// CONSULTA DE DATOS
// -------------------------------
$sql = "select * from INVENTARIO where id_inventario='{$idReg}'";
$db->query($sql);
while ($db->next_record()) {
$entSal = $db->f('ent_sal');
$eir = $db->f(eir);
//$idCliente = $db->f('id_cliente');
//$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente);
$cliente = $db->f('consig');
$idConte = $db->f('id_contenedor');
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) {
$conteL = $parts[1];
$conteN = $parts[2];
}
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$bkg = $db->f('bkg');
$clase = $db->f('clase');
$clase = "CLASE: {$clase} ";
$damage = $db->f('damage');
$sello = $db->f('sello');
$nota = $db->f('nota');
//$idTrans = $db->f('id_transporte');
//$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans);
$transp = $db->f('transportista');
$conteP1 = substr($conte, 0, 4);
$conteP2 = substr($conte, 4, 10);
if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) {
$conteP2 = $parts[1] . "-" . $parts[2];
}
$idNav = $db->f('id_naviera');
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav);
$placas = $db->f('placas');
// $idOperador = $db->f('id_operador');
//$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador);
$operador = $db->f('operador');
$capFec = $db->f('cap_fec');
if ($entSal == "E") {
$entSalTx = "INVENTARIO";
}
if ($entSal == "S") {
$entSalTx = "SALIDA";
}
$tipoMani = $db->f('tipo_mani');
$noRecibo = $db->f('recibo');
if ($tipoMani == "D") {
$tipoManiTx = "MANIOBRA DE DESCARGA";
}
if ($tipoMani == "C") {
$tipoManiTx = "MANIOBRA DE CARGA";
}
$maniCosto = $db->f('mani_costo');
$montoLetra = traducirCifra($maniCosto);
$capIdUsr = $db->f('cap_id_usr');
$capFec = $db->f('cap_fec');
$capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr);
}
// ------------------------------
// DAÑOS
// ------------------------------
$sql = "select * from REL_NOME ";
$sql .= "where id_inventario='{$idReg}' ";
$dano = "";
$db->query($sql);
while ($db->next_record()) {
$idRelNome = $db->f(id_rel_nome);
$idNome = $db->f(id_nome);
$idUbica = $db->f(id_ubicacion);
$idDime = $db->f(id_dimension);
$nome = getValueTable("nombre", "NOMENCLATURA", "id_nome", $idNome);
$nomeCode = getValueTable("codigo", "NOMENCLATURA", "id_nome", $idNome);
$ubica = getValueTable("ubicacion", "UBICACION", "id_ubicacion", $idUbica);
$dimen = getValueTable("dimension", "DIMENSION", "id_dimension", $idDime);
$dano .= "{$nome} ({$nomeCode}) : {$ubica} : {$dimen}\n";
}
$dano = nl2br($dano);
// ---------------------------------------------------------
// DATOS DEL RECIBO
// ---------------------------------------------------------
if ($noRecibo > 0) {
$datoRecibo = "\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>FECHA</b></td>\n <td><b>No.R.I.E.</b></td> \n <td></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$capFec}</td> \n <td>{$idReg}</td>\n <td></td>\n <td>{$conteL}{$conteN}</td>\n <td>{$equipo}</td>\n </tr> \n <tr>\n <td><b>CONCEPTO</b></td> \n <td><b>TRANSPORTISTA</b></td> \n <td><b>OPERADOR</b></td>\n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td>{$tipoManiTx}</td> \n <td>{$transp}</td>\n <td>{$operador}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>MANIOBRA \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>IVA \$</b></td>\n <td align=\"left\">{$maniIva}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"left\">RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 </td>\n </tr>\n </table> \n ";
}
// -------------------------------------------------------------------
$pdf->AddPage();
// Logo
$pdf->setJPEGQuality(100);
$pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false);
//$pdf->Image('../images/nome.jpg', 15, 140, 185, 96,'','','',false);
// set cell padding
//$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
//$pdf->setCellMargins(1, 1, 1, 1);
// Encabezado
$pdf->SetFillColor(197, 197, 197);
if ($sesIdOficina == 1) {
$txt = "ALMARTCON, S.A. DE C.V.\n\"El Trébol\"";
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true);
$txt = "Direccion, Guatemala \nTels.: 505-2350-0976 Cel. 505-8635-0708";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true);
}
/* elseif( $sesIdOficina==3 ){
$txt = "TRANSPORTES MALEJA, S.A. DE C.V.\n\"El Pino\"";
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true);
$txt="Carretera Querétaro San Luis Potosí Km.28\nCol.Buenavista Santa Rosa Jauregui\nQueretaro, QRO.";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true);
}
*/
$pdf->SetFont('helvetica', '', 12);
$tbl = <<<EOD
<table cellspacing="0" cellpadding="3" border="1" align="center">
<tr bgcolor="#cacaca">
<th>FOLIO</th>
</tr>
<tr> \t
\t<td><font color="red">{$entSal} {$eir}</font></td>
</tr>
</table>
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)";
$pdf->SetFont('helvetica', 'B', 12);
$pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true);
$pdf->SetFont('helvetica', '', 8);
$tbl = <<<EOD
<br><br><br>
<table cellspacing="0" cellpadding="3" border="1" align="center">
<tr>
<th><b>CLIENTE</b></th>
<th><b>MARCA</b></th>
<th><b>NUMERO</b></th>
<th><b>CARACTERISTICAS FISICAS</b></th>
</tr>
<tr> \t
\t<td>{$cliente}</td>
\t<td>{$conteL}</td>
\t<td>{$conteN}</td>
\t<td>{$equipo} / {$damage} </td> \t
</tr>
<tr bgcolor="#cacaca">
\t<th colspan="4"><b>{$entSalTx}</b></th>
</tr>
<tr>
\t<td><b>ENTREGADO POR :</b></td>
\t<td><b>FECHA Y HORA</b></td>
<td><b>BOOKING</b></td>
\t<td><b>ESTADO FISICO</b></td> \t
</tr>
<tr>
\t<td>{$naviera}</td>
\t<td>{$capFec}</td>
<td>{$bkg}</td>
\t<td>{$clase}</td> \t
</tr>
<tr>
\t<td><b>TRANSPORTISTA</b></td>
<td><b>OPERADOR</b></td>
<td><b>PLACAS</b></td>
\t<td><b>SELLO</b></td> \t \t
</tr>\t
<tr>
\t<td>{$transp}</td>
<td>{$operador}</td>
<td>{$placas}</td>
<td>{$sello}</td>
</tr>
<tr>
\t<td colspan="2"><b>OBSERVACIONES</b></td> \t
<td colspan="2"><b>DANOS</b></td>
</tr>
<tr>
<td colspan="2">{$nota}</td>
\t<td colspan="2">{$dano}</td>
</tr>
<tr>
<td colspan="4"><i>Capturo: {$capUsr}<br>Fecha captura: {$capFec} </i></td>
</tr>
</table>
<br><br><br>
{$datoRecibo}
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
$noRecibo > 0 ? $corY = 180 : ($corY = 105);
$txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 15, $corY, true);
$txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(30, 10, $txt, 1, 'C', 0, 0, 55, $corY, true);
$txt = "AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 85, $corY, true);
$txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 125, $corY, true);
$txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(35, 10, $txt, 1, 'C', 0, 0, 165, $corY, true);
//Close and output PDF document
$pdf->Output('example_eir.pdf', 'I');
}
public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 035');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 035', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
$pdf->setLanguageArray($this->langSettings);
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', 'BI', 16);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of SetLineStyle() method', '', 0, 'L', true, 0, false, false, 0);
$pdf->Ln();
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 4, 'color' => array(255, 0, 0)));
$pdf->SetFillColor(255, 255, 128);
$pdf->SetTextColor(0, 0, 128);
$text = "DUMMY";
$pdf->Cell(0, 0, $text, 1, 1, 'L', 1, 0);
$pdf->Ln();
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 255)));
$pdf->SetFillColor(255, 255, 0);
$pdf->SetTextColor(0, 0, 255);
$pdf->MultiCell(60, 4, $text, 1, 'C', 1, 0);
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(255, 255, 0)));
$pdf->SetFillColor(0, 0, 255);
$pdf->SetTextColor(255, 255, 0);
$pdf->MultiCell(60, 4, $text, 'TB', 'C', 1, 0);
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(255, 0, 255)));
$pdf->SetFillColor(0, 255, 0);
$pdf->SetTextColor(255, 0, 255);
$pdf->MultiCell(60, 4, $text, 1, 'C', 1, 1);
$this->comparePdfs($pdf);
}
public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 031');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 031', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
$pdf->setLanguageArray($this->langSettings);
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', 'B', 20);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of PieSector() method.');
$xc = 105;
$yc = 100;
$r = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc, $yc, $r, 20, 120, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc, $yc, $r, 120, 250, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc, $yc, $r, 250, 20, 'FD', false, 0, 2);
// write labels
$pdf->SetTextColor(255, 255, 255);
$pdf->Text(105, 65, 'BLUE');
$pdf->Text(60, 95, 'GREEN');
$pdf->Text(120, 115, 'RED');
$this->comparePdfs($pdf);
}
public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, false, 'ISO-8859-1', false);
// Set document information dictionary in unicode mode
$pdf->SetDocInfoUnicode(true);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni [€]');
$pdf->SetTitle('TCPDF Example 019');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 019', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language dependent data:
$lg = array();
$lg['a_meta_charset'] = 'ISO-8859-1';
$lg['a_meta_dir'] = 'ltr';
$lg['a_meta_language'] = 'en';
$lg['w_page'] = 'page';
// set some language-dependent strings (optional)
$pdf->setLanguageArray($lg);
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 12);
// add a page
$pdf->AddPage();
// set color for background
$pdf->SetFillColor(200, 255, 200);
$txt = 'An alternative configuration file is used on this example.
Check the definition of the K_TCPDF_EXTERNAL_CONFIG constant on the source code.';
// print some text
$pdf->MultiCell(0, 0, $txt . "\n", 1, 'J', 1, 1, '', '', true, 0, false, true, 0);
$this->comparePdfs($pdf);
}
/**
* Sets up a new PDF object with the necessary settings
*
* @return FPDF A new PDF object
*/
protected function initialize_pdf()
{
global $CFG;
require_once $CFG->dirroot . '/local/elisreports/lib/tcpdf/tcpdf.php';
$newpdf = new TCPDF('L', 'in', 'letter');
//prevent the library from automatically outputting
//header or footer bars
$newpdf->SetPrintHeader(false);
$newpdf->SetPrintFooter(false);
$newpdf->setMargins(self::marginx, self::marginy);
$newpdf->SetFont('freesans', '', 9);
$newpdf->AddPage();
$newpdf->SetFont('freesans', '', 16);
$newpdf->MultiCell(0, 0.2, $this->report->title, 0, 'C');
$newpdf->Ln(0.2);
$newpdf->SetFont('freesans', '', 8);
$newpdf->SetFillColor(225, 225, 225);
return $newpdf;
}
/**
* Init the PDF Font
*
* @access public
*/
public function fontSet()
{
$family = strtolower($this->value['font-family']);
$b = $this->value['font-bold'] ? 'B' : '';
$i = $this->value['font-italic'] ? 'I' : '';
$u = $this->value['font-underline'] ? 'U' : '';
$d = $this->value['font-linethrough'] ? 'D' : '';
$o = $this->value['font-overline'] ? 'O' : '';
// font style
$style = $b . $i;
if ($this->_defaultFont) {
if ($family == 'arial') {
$family = 'helvetica';
} elseif ($family == 'symbol' || $family == 'zapfdingbats') {
$style = '';
}
$fontkey = $family . $style;
if (!$this->_pdf->isLoadedFont($fontkey)) {
$family = $this->_defaultFont;
}
}
if ($family == 'arial') {
$family = 'helvetica';
} elseif ($family == 'symbol' || $family == 'zapfdingbats') {
$style = '';
}
// complete style
$style .= $u . $d . $o;
// size : mm => pt
$size = $this->value['font-size'];
$size = 72 * $size / 25.4;
// apply the font
$this->_pdf->SetFont($family, $style, $this->value['mini-size'] * $size);
$this->_pdf->SetTextColorArray($this->value['color']);
if ($this->value['background']['color']) {
$this->_pdf->SetFillColorArray($this->value['background']['color']);
} else {
$this->_pdf->SetFillColor(255);
}
}
function showPdf($idReg = "")
{
global $db;
// -------------------------------
// CONSULTA DE DATOS
// -------------------------------
$sql = "select * from ENTRADA where id_entrada='{$idReg}'";
$db->query($sql);
while ($db->next_record()) {
$entSal = $db->f('ent_sal');
//$idCliente = $db->f('id_cliente');
//$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente);
$cliente = $db->f('consig');
$idConte = $db->f('id_contenedor');
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) {
$conteL = $parts[1];
$conteN = $parts[2];
}
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$bkg = $db->f('bkg');
$clase = $db->f('clase');
$damage = $db->f('damage');
$sello = $db->f('sello');
$nota = $db->f('nota');
//$idTrans = $db->f('id_transporte');
//$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans);
$transp = $db->f('transportista');
$conteP1 = substr($conte, 0, 4);
$conteP2 = substr($conte, 4, 10);
if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) {
$conteP2 = $parts[1] . "-" . $parts[2];
}
$idNav = $db->f('id_naviera');
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav);
$placas = $db->f('placas');
// $idOperador = $db->f('id_operador');
//$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador);
$operador = $db->f('operador');
if ($entSal == "E") {
$entCapFec = $db->f('cap_fec');
$entTrans = $transp;
$entOpera = $operador;
$entPlacas = $placas;
$entClase = "CLASE : {$clase}";
$entDamage = $damage;
$entSello = $sello;
$entNota = $nota;
}
if ($entSal == "S") {
$salCapFec = $db->f('cap_fec');
$salTrans = $transp;
$salOpera = $operador;
$salPlacas = $placas;
$salClase = "CLASE : {$clase}";
$salDamage = $damage;
$salSello = $sello;
$salNota = $nota;
}
}
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', true, 'ISO-8859-1', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 009');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING);
// set header and footer fonts
//$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
// $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// $pdf->SetFooterMargin(3);
$pdf->setPageOrientation('P', '', 1);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// -------------------------------------------------------------------
$pdf->AddPage();
// Logo
$pdf->setJPEGQuality(100);
$pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false);
$pdf->Image('../images/nome.jpg', 15, 140, 185, 96, '', '', '', false);
// set cell padding
//$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
//$pdf->setCellMargins(1, 1, 1, 1);
$pdf->SetFillColor(197, 197, 197);
// set font
$txt = "TRANSPORTES MALEJA, S.A. DE C.V.";
$pdf->SetFont('aefurat', '', 14);
$pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true);
// set font
$txt = "Av. San Pablo s/n esq. Benito Juarez \nCol.San Pablo Xalpa Municipio Tlalnepantla \nC.P. 54090 Edo. de Mexico \nTels.: 5319-9375 5319-9228";
$pdf->SetFont('pdfahelvetica', '', 7);
$pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true);
$pdf->SetFont('pdfahelvetica', '', 12);
$tbl = <<<EOD
<table cellspacing="0" cellpadding="3" border="1" align="center">
<tr bgcolor="#cacaca">
<th>FOLIO</th>
</tr>
<tr> \t
\t<td>{$idReg}</td>
</tr>
</table>
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)";
$pdf->SetFont('helvetica', 'B', 12);
$pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true);
$pdf->SetFont('helvetica', '', 8);
$tbl = <<<EOD
<br><br><br>
<table cellspacing="0" cellpadding="3" border="1" align="center">
<tr>
<th><b>CLIENTE</b></th>
<th><b>MARCA</b></th>
<th><b>NUMERO</b></th>
<th><b>CARACTERISTICAS FISICAS</b></th>
<th><b>LOCALIZACION</b></th>
</tr>
<tr> \t
\t<td>{$cliente}</td>
\t<td>{$conteL}</td>
\t<td>{$conteN}</td>
\t<td>{$equipo}</td>
\t<td>{$localizacion}</td>
</tr>
<tr bgcolor="#cacaca">
\t<th colspan="3"><b>ENTRADA</b></th>
\t<th colspan="2"><b>SALIDA</b></th> \t
</tr>
<tr>
\t<td><b>ENTREGADO POR :</b></td>
\t<td><b>FECHA Y HORA</b></td>
\t<td><b>AUTORIZACION</b></td>
\t<td><b>FECHA Y HORA</b></td>
\t<td><b>DESTINO</b></td>
</tr>
<tr>
\t<td>{$naviera}</td>
\t<td>{$entCapFec}</td>
\t<td>{$bkg}</td>
\t<td>{$salCapFec}</td>
\t<td> </td>
</tr>
<tr>
\t<td><b>TRANSPORTISTA</b></td>
\t<td><b><b>CARTA PORTE</b></b></td>
\t<td><b>-</b></td>
\t<td><b>TRANSPORTISTA</b></td>
\t<td><b>CARTA PORTE</b></td>
</tr>
<tr>
\t<td>{$entTrans}</td>
\t<td>-</td>
\t<td>-</td>
\t<td>{$salTrans}</td>
\t<td>-</td>
</tr>
<tr>
\t<td><b>OPERADOR</b></td>
\t<td><b>PLACAS</b></td> \t
\t<td><b>-</b></td> \t
\t<td><b>OPERADOR</b></td>
\t<td><b>PLACAS</b></td>
</tr>\t
<tr>
\t<td>{$entOpera}</td>
\t<td>{$entPlacas}</td>
\t<td>-</td>
\t<td>{$salOpera}</td>
\t<td>{$salPlacas}</td>
</tr>
<tr>
\t<td><b>ESTADO FISICO</b></td>
\t<td></td>
\t<td></td>
\t<td><b>ESTADO FISICO</b></td>
\t<td></td>
</tr>
<tr>
\t<td>{$entClase}</td>
\t<td>{$entDamage}</td>
\t<td>-</td>
\t \t<td>{$salClase}</td>
\t<td>{$salDamage}</td>
</tr>
<tr>
\t<td colspan="3"><b>NO.SELLO</b></td>
\t<td colspan="2"><b>NO.SELLO</b></td>
</tr>
<tr>
\t<td colspan="3">{$entSello}</td>
\t<td colspan="2">{$salSello}</td>
</tr>
<tr>
\t<td colspan="3"><b>OBSERVACIONES</b></td>
\t<td colspan="2"><b>OBSERVACIONES</b></td>
</tr>
<tr>
\t<td colspan="3">{$entNota}</td>
\t<td colspan="2">{$salNota}</td>
</tr>
</table>
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 15, 255, true);
$txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(30, 10, $txt, 1, 'C', 0, 0, 55, 255, true);
$txt = "AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 85, 255, true);
$txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 125, 255, true);
$txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(35, 10, $txt, 1, 'C', 0, 0, 165, 255, true);
//Close and output PDF document
$pdf->Output('example_eir.pdf', 'I');
}
function generateFacilityInventoryReport($conn)
{
global $gTEXT;
require_once 'tcpdf/tcpdf.php';
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetPrintHeader(false);
$pdf->SetPrintFooter(false);
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
require_once dirname(__FILE__) . '/lang/eng.php';
$pdf->setLanguageArray($l);
}
$pdf->setFontSubsetting(false);
$pdf->AddPage();
$pdf->SetFillColor(255, 255, 255);
//=====================================================Facility Inventory Table=======================================================
$MonthId = $_REQUEST['MonthId'];
$YearId = $_REQUEST['YearId'];
$mosTypeId = $_REQUEST['MosTypeId'];
$countryId = $_REQUEST['CountryId'];
$fLevelId = $_REQUEST['FLevelId'];
$FacilityId = $_REQUEST['FacilityId'];
$ItemGroupId = $_REQUEST['ItemGroupId'];
$regionId = $_REQUEST['RegionId'];
$districtId = $_REQUEST['DistrictId'];
$ownerTypeId = $_REQUEST['OwnerTypeId'];
$region = $_REQUEST['Region'];
$district = $_REQUEST['District'];
$ownerType = $_REQUEST['OwnerType'];
$year = $_REQUEST['Year'];
$CountryName = $_REQUEST['CountryName'];
$monthName = $_REQUEST['MonthName'];
$ItemGroupName = $_REQUEST['ItemGroupName'];
$FacilityName = $_REQUEST['FacilityName'];
$lan = $_REQUEST['lan'];
if ($lan == 'en-GB') {
$SITETITLE = SITETITLEENG;
} else {
$SITETITLE = SITETITLEFRN;
}
$column_name = array();
$sQuery1 = "SELECT\n\t\t\t MosTypeId\n\t\t\t , MosTypeName\n\t\t\t , ColorCode\n\t\t\tFROM\n\t\t\t t_mostype_facility\n\t\t\tWHERE CountryId = {$countryId} AND FLevelId = {$fLevelId} AND (MosTypeId = {$mosTypeId} OR {$mosTypeId} = 0)\n\t\t\tORDER BY MosTypeId;";
$rResult1 = mysql_query($sQuery1);
$output1 = array();
$col = '';
while ($row1 = mysql_fetch_array($rResult1)) {
$output1[] = $row1;
array_push($column_name, $row1['MosTypeName']);
}
$col .= '<tr><th width="180" align="left"><b>' . $gTEXT['Product Name'] . '</b></th>';
$col .= '<th width="60" align="left"><b>' . $gTEXT['Closing Balance'] . '</b></th>';
$col .= '<th width="45" align="left"><b>' . $gTEXT['AMC'] . '</b></th>';
$col .= '<th width="40" align="left"><b>' . $gTEXT['MOS'] . '</b></th>';
$f = 0;
for ($f = 0; $f < count($output1); $f++) {
$col .= '<th width="70" align="right"><b>' . $column_name[$f] . '</b></th>';
}
$col .= '</tr>';
/*
$sQuery = "SELECT p.MosTypeId, ItemName, MOS FROM (SELECT
a.ItemNo
, b.ItemName
, a.MOS
,(SELECT MosTypeId FROM t_mostype_facility x WHERE CountryId = $countryId AND FLevelId = $fLevelId AND (MosTypeId = $mosTypeId OR $mosTypeId = 0) AND a.MOS >= x.MinMos AND a.MOS < x.MaxMos) MosTypeId
FROM t_cfm_stockstatus a, t_itemlist b, t_cfm_masterstockstatus c
WHERE a.itemno = b.itemno AND a.MOS IS NOT NULL AND a.MonthId = " . $_REQUEST['MonthId'] . " AND a.Year = '" . $_REQUEST['YearId'] . "' AND a.CountryId = " . $_REQUEST['CountryId'] . " AND a.FacilityId = " . $_REQUEST['FacilityId'] . " AND a.ItemGroupId = " . $_REQUEST['ItemGroupId'] . " AND a.CFMStockId = c.CFMStockId" . " AND c.StatusId = 5 " . ") p
WHERE (p.MosTypeId = $mosTypeId OR $mosTypeId = 0)
ORDER BY ItemName";
*/
if ($ownerTypeId == 1 || $ownerTypeId == 2) {
$sQuery = "SELECT p.MosTypeId, ItemName, MOS ,ClStock,AMC FROM (SELECT\n\t\t\t\t a.ItemNo, b.ItemName, a.MOS ,a.ClStock,a.AMC\n\t\t\t\t,(SELECT MosTypeId FROM t_mostype_facility x WHERE CountryId = {$countryId} \n AND FLevelId = {$fLevelId} AND (MosTypeId = {$mosTypeId} OR {$mosTypeId} = 0) \n AND a.MOS >= x.MinMos AND a.MOS < x.MaxMos ) MosTypeId\n\t\t\t\tFROM t_cfm_stockstatus a, t_itemlist b, t_cfm_masterstockstatus c, t_facility g\n\t\t\t\tWHERE a.itemno = b.itemno AND a.MOS IS NOT NULL AND a.MonthId = " . $MonthId . " \n AND a.Year = '" . $YearId . "' AND a.CountryId = " . $countryId . " \n AND a.FacilityId = " . $FacilityId . " AND a.ItemGroupId = " . $ItemGroupId . "\n AND a.CFMStockId = c.CFMStockId" . " AND c.StatusId = 5 " . "\n AND a.FacilityId=g.FacilityId \n AND g.OwnerTypeId = {$ownerTypeId} \n AND (g.RegionId = {$regionId} OR {$regionId} = 0)\n AND (g.DistrictId = {$districtId} OR {$districtId} = 0)\n ) p\n \n\t\t\t\tWHERE (p.MosTypeId = {$mosTypeId} OR {$mosTypeId} = 0) \n\t\t\t\tORDER BY ItemName";
} else {
$sQuery = "SELECT p.MosTypeId, ItemName, MOS ,ClStock,AMC FROM (SELECT\n\t\t\t\t a.ItemNo, b.ItemName, a.MOS ,a.ClStock,a.AMC\n\t\t\t\t,(SELECT MosTypeId FROM t_mostype_facility x WHERE CountryId = {$countryId} \n AND FLevelId = {$fLevelId} AND (MosTypeId = {$mosTypeId} OR {$mosTypeId} = 0) \n AND a.MOS >= x.MinMos AND a.MOS < x.MaxMos ) MosTypeId\n\t\t\t\tFROM t_cfm_stockstatus a, t_itemlist b, t_cfm_masterstockstatus c, t_facility g\n\t\t\t\tWHERE a.itemno = b.itemno AND a.MOS IS NOT NULL AND a.MonthId = " . $MonthId . " \n AND a.Year = '" . $YearId . "' AND a.CountryId = " . $countryId . " \n AND a.FacilityId = " . $FacilityId . " AND a.ItemGroupId = " . $ItemGroupId . "\n AND a.CFMStockId = c.CFMStockId" . " AND c.StatusId = 5 " . "\n AND a.FacilityId=g.FacilityId\n AND g.AgentType = {$ownerTypeId} \n AND (g.RegionId = {$regionId} OR {$regionId} = 0)\n AND (g.DistrictId = {$districtId} OR {$districtId} = 0) ) p\n \n\t\t\t\tWHERE (p.MosTypeId = {$mosTypeId} OR {$mosTypeId} = 0) \n\t\t\t\tORDER BY ItemName";
}
//echo $sQuery;
mysql_query("SET character_set_results=utf8");
$rResult = mysql_query($sQuery);
$aData = array();
$total = mysql_num_rows($rResult);
if ($total > 0) {
while ($row = mysql_fetch_array($rResult)) {
$tmpRow = array();
/* foreach ($output1 as $rowMosType) {
if ($rowMosType['MosTypeId'] == $row['MosTypeId']) {
//$tmpRow[] = '<span class="glyphicon glyphicon-ok-circle" style="color:' . $rowMosType['ColorCode'] . ';font-size:2em;"></span>';
$tmpRow[] = '<i class="fa fa-check-circle fa-lg" style="color:' . $rowMosType['ColorCode'] . ';font-size:2.5em;"></i>';
} else
$tmpRow[] = '';
}
array_unshift($tmpRow, $row['ItemName'], number_format($row['MOS'], 1));
$aData[] = $tmpRow;*/
$col .= '<tr style="page-break-inside:avoid;">
<td>' . $row['ItemName'] . '</td>
<td>' . $row['ClStock'] . '</td>
<td>' . $row['AMC'] . '</td>
<td> ' . number_format($row['MOS'], 1) . '</td> ';
foreach ($output1 as $rowMosType) {
if ($rowMosType['MosTypeId'] == $row['MosTypeId']) {
/*$tmpRow[] = '<i class="fa fa-check-circle fa-lg" style="color:' . $rowMosType['ColorCode'] . ';font-size:2.5em;"></i>';
$col.= '<td><span class="fa fa-check-circle fa-lg" style="color:' . $rowMosType['ColorCode'] . ';font-size:2.5em;text-align:center;"></span></td>';
*/
$tmpRow[] = $rowMosType['ColorCode'];
$col .= '<td style="background-color:' . $rowMosType['ColorCode'] . '"></td>';
} else {
$col .= '<td> </td>';
}
}
array_unshift($tmpRow, $row['ItemName'], number_format($row['MOS'], 1));
$aData[] = $tmpRow;
$col .= ' </tr>';
}
$ItemGroupName = $_REQUEST['ItemGroupName'];
$FacilityName = $_REQUEST['FacilityName'];
$html_head = '
<!-- EXAMPLE OF CSS STYLE -->
<style>
p {
line-height: 0.1px;
}
</style>
<body>
<p><h3 style="text-align:center;"><b>' . $SITETITLE . '</b></h3></p></br>
<p><h4 style="text-align:center;"><b>' . $ItemGroupName . ' ' . $gTEXT['Facility Inventory Control Report of '] . ' ' . $CountryName . ' ' . $gTEXT['on'] . ' ' . $monthName . ',' . $year . '</b></h4></p></br>
<p><h4 style="text-align:center;"><b>' . $gTEXT['Region'] . ': ' . $region . ', ' . $gTEXT['District'] . ': ' . $district . ', ' . $gTEXT['Report By'] . ': ' . $ownerType . '</b></h4></p></br>
<p style="text-align:center;"><h4><b>' . $gTEXT['Facility Name'] . ': ' . $FacilityName . '</b><h4></p></br>
</body>';
$pdf->SetFont('dejavusans', '', 10);
$pdf->writeHTMLCell(0, 0, 6, 10, $html_head, '', 0, 0, false, 'C', true);
$html = '<head>
<link rel="stylesheet" href="' . $jBaseUrl . 'templates/protostar/css/template.css" type="text/css" />
<link href="' . $jBaseUrl . 'templates/protostar/endless/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/font-awesome.min.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/pace.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/colorbox/colorbox.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/morris.css" rel="stylesheet"/>
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/endless.min.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/css/endless-skin.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'templates/protostar/endless/bootstrap/css/font-halflings.css" rel="stylesheet">
<link href="' . $jBaseUrl . 'administrator/components/com_jcode/source/css/custom.css" rel="stylesheet"/>
</head>
<!-- EXAMPLE OF CSS STYLE -->
<style>
td{
height: 6px;
line-height:3px;
}
th{
height: 20;
}
</style>
<body>
<table width="600px" border="0.5" style="margin:0 auto;">' . $col . '</table></body>';
$pdf->SetFont('dejavusans', '', 7);
$pdf->writeHTMLCell(0, 0, 5, 45, $html, '', 1, 1, false, 'L', true);
$filePath = SITEDOCUMENT . 'administrator/components/com_jcode/source/report/pdfslice/FacilityInventoryReport.pdf';
if (file_exists($filePath)) {
unlink($filePath);
}
$pdf->Output('pdfslice/FacilityInventoryReport.pdf', 'F');
echo 'FacilityInventoryReport.pdf';
} else {
echo 'Processing Error';
}
}
public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 022');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 022', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
$pdf->setLanguageArray($this->langSettings);
// ---------------------------------------------------------
// check also the following methods:
// SetDrawColorArray()
// SetFillColorArray()
// SetTextColorArray()
// set font
$pdf->SetFont('helvetica', 'B', 18);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of CMYK, RGB and Grayscale colours', '', 0, 'L', true, 0, false, false, 0);
// define style for border
$border_style = array('all' => array('width' => 2, 'cap' => 'square', 'join' => 'miter', 'dash' => 0, 'phase' => 0));
// --- CMYK ------------------------------------------------
$pdf->SetDrawColor(50, 0, 0, 0);
$pdf->SetFillColor(100, 0, 0, 0);
$pdf->SetTextColor(100, 0, 0, 0);
$pdf->Rect(30, 60, 30, 30, 'DF', $border_style);
$pdf->Text(30, 92, 'Cyan');
$pdf->SetDrawColor(0, 50, 0, 0);
$pdf->SetFillColor(0, 100, 0, 0);
$pdf->SetTextColor(0, 100, 0, 0);
$pdf->Rect(70, 60, 30, 30, 'DF', $border_style);
$pdf->Text(70, 92, 'Magenta');
$pdf->SetDrawColor(0, 0, 50, 0);
$pdf->SetFillColor(0, 0, 100, 0);
$pdf->SetTextColor(0, 0, 100, 0);
$pdf->Rect(110, 60, 30, 30, 'DF', $border_style);
$pdf->Text(110, 92, 'Yellow');
$pdf->SetDrawColor(0, 0, 0, 50);
$pdf->SetFillColor(0, 0, 0, 100);
$pdf->SetTextColor(0, 0, 0, 100);
$pdf->Rect(150, 60, 30, 30, 'DF', $border_style);
$pdf->Text(150, 92, 'Black');
// --- RGB -------------------------------------------------
$pdf->SetDrawColor(255, 127, 127);
$pdf->SetFillColor(255, 0, 0);
$pdf->SetTextColor(255, 0, 0);
$pdf->Rect(30, 110, 30, 30, 'DF', $border_style);
$pdf->Text(30, 142, 'Red');
$pdf->SetDrawColor(127, 255, 127);
$pdf->SetFillColor(0, 255, 0);
$pdf->SetTextColor(0, 255, 0);
$pdf->Rect(70, 110, 30, 30, 'DF', $border_style);
$pdf->Text(70, 142, 'Green');
$pdf->SetDrawColor(127, 127, 255);
$pdf->SetFillColor(0, 0, 255);
$pdf->SetTextColor(0, 0, 255);
$pdf->Rect(110, 110, 30, 30, 'DF', $border_style);
$pdf->Text(110, 142, 'Blue');
// --- GRAY ------------------------------------------------
$pdf->SetDrawColor(191);
$pdf->SetFillColor(127);
$pdf->SetTextColor(127);
$pdf->Rect(30, 160, 30, 30, 'DF', $border_style);
$pdf->Text(30, 192, 'Gray');
$this->comparePdfs($pdf);
}
function showPdf($idReg = "")
{
global $db;
// Oficina
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 009');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING);
// set header and footer fonts
//$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
// $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// $pdf->SetFooterMargin(3);
$pdf->setPageOrientation('P', '', 1);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
//$pdf->setLanguageArray($l);
// set some language dependent data:
$lg = array();
$lg['a_meta_charset'] = 'ISO-8859-1';
$lg['a_meta_dir'] = 'ltr';
$lg['a_meta_language'] = 'en';
$lg['w_page'] = 'page';
//set some language-dependent strings
$pdf->setLanguageArray($lg);
// -------------------------------
// CONSULTA DE DATOS
// -------------------------------
$sql = "select * from PENSION where id_pension='{$idReg}'";
$db->query($sql);
while ($db->next_record()) {
$noRecibo = $db->f(id_pension);
$entFec = $db->f(ent_fec);
$salFec = $db->f(sal_fec);
$idConte = $db->f(id_contenedor);
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$concepto = $db->f(concepto);
$operador = $db->f(operador);
$placas = $db->f(placas);
$monto = $db->f(monto);
$montoLetra = traducirCifra($monto);
$idOficina = $db->f(id_oficina);
$transporte = $db->f(transporte);
$metPago = $db->f(met_pago);
}
// ---------------------------------------------------------
// DATOS DEL RECIBO
// ---------------------------------------------------------
$datoRecibo = "\n\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES TMA</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>ENTRADA</b></td>\n <td><b>SALIDA</b></td> \n <td><b>TRANSPORTE</b></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$entFec}</td> \n <td>{$salFec}</td>\n <td>{$transporte}</td>\n <td>{$conte}</td>\n <td>{$equipo}</td>\n </tr> \n <tr> \n <td colspan=\"2\"><b>OPERADOR</b></td> \n <td><b>PLACAS</b></td> \n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td colspan=\"2\">{$operador}</td>\n <td>{$placas}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>{$concepto} \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"center\">\n RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100<br> \n <b>Metodo de pago :</b> {$metPago}<br>\n ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>\n EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO<br>\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.<br>\n Solicitarla al correo: facturacionpatios@demo.com.mx<br>\n </td>\n </tr>\n </table> \n\n <br><br><br><br><br><br>\n <center>---------------------------------- RECIBO PARA VIGILANCIA ---------------------------------- </center> \n <br><br><br><br><br>\n\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>ENTRADA</b></td>\n <td><b>SALIDA</b></td> \n <td><b>TRANSPORTE</b></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$entFec}</td> \n <td>{$salFec}</td>\n <td>{$transporte}</td>\n <td>{$conte}</td>\n <td>{$equipo}</td>\n </tr> \n <tr> \n <td colspan=\"2\"><b>OPERADOR</b></td> \n <td><b>PLACAS</b></td> \n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td colspan=\"2\">{$operador}</td>\n <td>{$placas}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>{$concepto} \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"center\">\n RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 <br>\n <b>Metodo de pago :</b> {$metPago}<br>\n ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>\n EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO<br>\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.<br>\n Solicitarla al correo: facturacionpatios@demo.com.mx<br>\n </td>\n </tr>\n </table> \n\n ";
// -------------------------------------------------------------------
$pdf->AddPage();
// Logo
$pdf->setJPEGQuality(100);
$pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false);
//$pdf->Image('../images/nome.jpg', 15, 140, 185, 96,'','','',false);
// set cell padding
//$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
//$pdf->setCellMargins(1, 1, 1, 1);
// Encabezado
$pdf->SetFillColor(197, 197, 197);
if ($idOficina == 1) {
$txt = "ALMARTCON S.A. DE C.V.\n\"El Trébol\"";
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true);
$txt = "Direccion, Guatemala \\Tel. 505-2350-0976 Cel. 505-8635-0708";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true);
}
/* elseif( $idOficina==2 ){
$txt = "ALMARTCON S.A DE C.V.\n\"El Arbol\"";
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true);
$txt="Av. Refinería Azcapotzalco S/N \nEsq. Ferrocarriles Nacionales.\nMéxico D.F.";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true);
}
elseif( $idOficina==3 ){
$txt = "TRANSPORTES MALEJA S.A DE C.V.\n\"El Pino\"";
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true);
$txt="Carretera Querétaro San Luis Potosí Km.28\nCol.Buenavista Santa Rosa Jauregui\nQueretaro, QRO.";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true);
}
*/
$pdf->SetFont('helvetica', '', 12);
//$tbl = <<<EOD EOD;
//$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "RECIBO";
$pdf->SetFont('helvetica', 'B', 12);
$pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true);
$pdf->SetFont('helvetica', '', 8);
$tbl = <<<EOD
<br><br><br>
{$datoRecibo}
EOD;
//$tbl = "$datoRecibo";
$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.\n Solicitarla al correo: facturacionpatios@demo.com.mx";
$noRecibo > 0 ? $corY = 200 : ($corY = 125);
//$pdf->MultiCell(185, 4,$txt, 1, 'C',0, 0, 16, 109,true);
/*
($noRecibo>0)?$corY=180:$corY=105;
$txt="POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40,10,$txt, 1, 'C',0, 0, 15, $corY,true);
$txt="POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(30, 10,$txt, 1, 'C',0, 0, 55, $corY,true);
$txt="AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10,$txt, 1, 'C',0, 0, 85, $corY,true);
$txt="POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40, 10,$txt, 1, 'C',0, 0, 125, $corY,true);
$txt="POR DEPOSITO\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(35, 10,$txt, 1, 'C',0, 0, 165, $corY,true);
*/
//Close and output PDF document
$pdf->Output('reciboPension.pdf', 'I');
}
$pdf->SetFont('helvetica', '', 10);
$pdf->setCellHeightRatio(1.25);
$pdf->MultiCell(0, 0, $legend, 0, 'L', false, 1, 125, 160, true, 0, false, true, 0, 'T', false);
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// CELL BORDERS
// add a page
$pdf->AddPage();
$pdf->SetFont('helvetica', 'B', 20);
$pdf->Write(0, 'Example of borders for Cell()', '', 0, 'L', true, 0, false, false, 0);
$pdf->SetFont('helvetica', '', 11);
// set border width
$pdf->SetLineWidth(0.508);
// set color for cell border
$pdf->SetDrawColor(0, 128, 255);
// set filling color
$pdf->SetFillColor(255, 255, 128);
// set cell height ratio
$pdf->setCellHeightRatio(3);
$pdf->Cell(30, 0, '1', 1, 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'LTRB', 'LTRB', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'LTR', 'LTR', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'TRB', 'TRB', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'LRB', 'LRB', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'LTB', 'LTB', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->Ln(2);
$pdf->Cell(30, 0, 'LT', 'LT', 1, 'C', 1, '', 0, false, 'T', 'C');
$pdf->setJPEGQuality(75);
// Image method signature:
// Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false)
// set font
$pdf->SetFont(mydeffont, '', 11, '', true);
// set cell padding
$pdf->setCellPaddings(0, 0, 0, 0.5); //$left='', $top='', $right='', $bottom='')
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
// set color for background
$pdf->SetFillColor(255, 255, 255);
// 1. Parameter: sesuaikan dg parameter di Page Selection Bar >> Edit
$cid=gets('token');
$lap_cetak=gets('lap_cetak',0);
$lap_tglcetak=gets('lap_tglcetak',0);
$lap_sum=gets('lap_sum',0);
// 2. Queries: samakan dg Query >> Edit
$t=mysql_query("SELECT * FROM pus_stockhist WHERE replid='$cid'");
$data_so=mysql_fetch_array($t);
$tbl="joshso.".$data_so['tabel'];
if($lap_cetak==0) $fl="";
else if($lap_cetak==1) $fl=" WHERE ".$tbl.".cek='Y'";
else if($lap_cetak==2) $fl=" WHERE ".$tbl.".cek='N'";
else if($lap_cetak==3) $fl=" WHERE ".$tbl.".cek='N' AND ".$tbl.".note<>''";
function pdf($html = null, $logo = null, $nombre = null, $estadistica, $itiniere, $transporte)
{
//$html= utf8_decode($html);
// $html="OOOJHKJHKJH JLH KJH KH KJH";
ob_clean();
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, array(210, 272), true, 'UTF-8', false);
// $pdf = new TCPDF('P', 'IN', array (8.5,11),true, 'UTF-8', false);
// set document information
//$pdf->SetCreator(PDF_CREATOR);
//$pdf->SetAuthor('Nicola Asuni');
//$pdf->SetTitle('TCPDF Example 001');
//$pdf->SetSubject('TCPDF Tutorial');
//$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
//$pdf->SetHeaderData($logo, '20', PDF_HEADER_TITLE.' 001', PDF_HEADER_STRING, array(0,64,255), array(0,64,128));
if (!empty($logo)) {
$pdf->SetHeaderData($logo, '20', '', ' PLAN ESTRATEGICO DE SEGURIDAD VÍAL ' . date('d/m/Y'), array(0, 64, 128), array(0, 64, 128));
}
$pdf->setFooterData(array(0, 64, 0), array(0, 64, 128));
// set header and footer fonts
// $pdf->SetMargins(23, 35, 13);
$pdf->SetMargins(32, 35, 20);
$pdf->SetHeaderMargin(14);
$pdf->SetFooterMargin(21);
$pdf->SetAutoPageBreak(TRUE, 20);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//$pdf->setLanguageArray($l);
$pdf->setFontSubsetting(false);
$pdf->SetFont('dejavusans', '', 10, '', true);
//$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', '6'));
$pdf->AddPage();
$pdf->writeHTML($html, true, false, true, false, '');
// $pdf->AddPage();
$pdf->SetFillColor(0, 0, 0);
$pdf->Write(10, ' ARL');
// echo $estadistica[0]->arlnula;die;
// GRAFICA No 1
$xc = $estadistica[0]->arlnula;
$yc = $estadistica[0]->arlsi;
$r = $estadistica[0]->arlno;
//echo "<pre>";
// var_dump($estadistica);die();
$total = $xc + $yc + $r;
$r1 = $xc * 360 / $total;
$r2 = $yc * 360 / $total;
$r3 = $r * 360 / $total;
$r1 = round($r1);
$r2 = round($r2);
$r3 = round($r3);
$xc1 = 105;
$yc1 = 120;
$r11 = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc1, $yc1, $r11, 0, $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r1, $r2 + $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r2 + $r1, 0, 'FD', false, 0, 2);
$pdf->SetTextColor(0, 0, 255);
$pdf->Text(150, 150, 'NO CONTESTADAS: ' . $xc);
$pdf->SetTextColor(0, 255, 0);
$pdf->Text(150, 155, 'SI: ' . $yc);
$pdf->SetTextColor(255, 0, 0);
$pdf->Text(150, 160, 'NO: ' . $r);
$pdf->AddPage();
//----------------------------------------------------------------
// GRAFICA No 2
$pdf->SetTextColor(0, 0, 0);
$pdf->Write(10, ' PENSION');
$xc = $estadistica[0]->pensionnula;
$yc = $estadistica[0]->pensionsi;
$r = $estadistica[0]->pensionno;
$total = $xc + $yc + $r;
$r1 = $xc * 360 / $total;
$r2 = $yc * 360 / $total;
$r3 = $r * 360 / $total;
$r1 = round($r1);
$r2 = round($r2);
$r3 = round($r3);
$xc1 = 105;
$yc1 = 100;
$r11 = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc1, $yc1, $r11, 0, $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r1, $r2 + $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r2 + $r1, 0, 'FD', false, 0, 2);
$pdf->SetTextColor(0, 0, 255);
$pdf->Text(150, 150, 'NO CONTESTADAS: ' . $xc);
$pdf->SetTextColor(0, 255, 0);
$pdf->Text(150, 155, 'SI: ' . $yc);
$pdf->SetTextColor(255, 0, 0);
$pdf->Text(150, 160, 'NO: ' . $r);
$pdf->AddPage();
//----------------------------------------------------------------
// GRAFICA No 3
$pdf->SetTextColor(0, 0, 0);
$pdf->Write(10, ' EPS');
$xc = $estadistica[0]->epsnula;
$yc = $estadistica[0]->epssi;
$r = $estadistica[0]->epsno;
$total = $xc + $yc + $r;
$r1 = $xc * 360 / $total;
$r2 = $yc * 360 / $total;
$r3 = $r * 360 / $total;
$r1 = round($r1);
$r2 = round($r2);
$r3 = round($r3);
$xc1 = 105;
$yc1 = 100;
$r11 = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc1, $yc1, $r11, 0, $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r1, $r2 + $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r2 + $r1, 0, 'FD', false, 0, 2);
$pdf->SetTextColor(0, 0, 255);
$pdf->Text(150, 150, 'NO CONTESTADAS: ' . $xc);
$pdf->SetTextColor(0, 255, 0);
$pdf->Text(150, 155, 'SI: ' . $yc);
$pdf->SetTextColor(255, 0, 0);
$pdf->Text(150, 160, 'NO: ' . $r);
$pdf->AddPage();
//----------------------------------------------------------------
// GRAFICA No 4
$pdf->SetTextColor(0, 0, 0);
$pdf->Write(10, ' CAJA DE COMPENSACIÓN');
$xc = $estadistica[0]->cajacompensacionnula;
$yc = $estadistica[0]->cajacompensacionsi;
$r = $estadistica[0]->cajacompensacionno;
$total = $xc + $yc + $r;
$r1 = $xc * 360 / $total;
$r2 = $yc * 360 / $total;
$r3 = $r * 360 / $total;
$r1 = round($r1);
$r2 = round($r2);
$r3 = round($r3);
$xc1 = 105;
$yc1 = 100;
$r11 = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc1, $yc1, $r11, 0, $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r1, $r2 + $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r2 + $r1, 0, 'FD', false, 0, 2);
$pdf->SetTextColor(0, 0, 255);
$pdf->Text(150, 150, 'NO CONTESTADAS: ' . $xc);
$pdf->SetTextColor(0, 255, 0);
$pdf->Text(150, 155, 'SI: ' . $yc);
$pdf->SetTextColor(255, 0, 0);
$pdf->Text(150, 160, 'NO: ' . $r);
$pdf->AddPage();
//----------------------------------------------------------------
// GRAFICA No 5
$pdf->SetTextColor(0, 0, 0);
$pdf->Write(10, ' DESPLAZAMIENTO EN MISIÓN');
$xc = $estadistica[0]->usu_desplazamiento_misionnula;
$yc = $estadistica[0]->usu_desplazamiento_misionsi;
$r = $estadistica[0]->usu_desplazamiento_misionno;
$total = $xc + $yc + $r;
$r1 = $xc * 360 / $total;
$r2 = $yc * 360 / $total;
$r3 = $r * 360 / $total;
$r1 = round($r1);
$r2 = round($r2);
$r3 = round($r3);
$xc1 = 105;
$yc1 = 100;
$r11 = 50;
$pdf->SetFillColor(0, 0, 255);
$pdf->PieSector($xc1, $yc1, $r11, 0, $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(0, 255, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r1, $r2 + $r1, 'FD', false, 0, 2);
$pdf->SetFillColor(255, 0, 0);
$pdf->PieSector($xc1, $yc1, $r11, $r2 + $r1, 0, 'FD', false, 0, 2);
$pdf->SetTextColor(0, 0, 255);
$pdf->Text(150, 150, 'NO CONTESTADAS: ' . $xc);
$pdf->SetTextColor(0, 255, 0);
$pdf->Text(150, 155, 'SI: ' . $yc);
$pdf->SetTextColor(255, 0, 0);
$pdf->Text(150, 160, 'NO: ' . $r);
// $pdf->Write(0, 'Example of PieSector() method.');
//$pdf->setTextShadow(array('enabled'=>true, 'depth_w'=>0.2, 'depth_h'=>0.2, 'color'=>array(196,196,196), 'opacity'=>1, 'blend_mode'=>'Normal'));
// $pdf->writeHTMLCell(1, 1, '', '', $html, 0, 1, 0, true, '', true);
$pdf->Output('pesv.pdf', 'I');
}
function writeDetalles(DataSource $dataSource, TCPDF $pdf, $tipo)
{
$blackAll = array('LTRB' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$widthMarginLeft = 1;
$width1 = 20;
$width2 = 85;
$pdf->Ln();
$pdf->SetFontSize(7.5);
$pdf->SetFont('', 'B');
$height = 5;
$pdf->SetFillColor(255, 255, 255, true);
$pdf->setTextColor(0, 0, 0);
if ($tipo == 'adjudicado') {
$pdf->Cell($width2 - $width1 * 2, $height, 'Item', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
} else {
$pdf->Cell($width2, $height, 'Item', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
}
$pdf->Cell($width1, $height, 'Cantidad Ref.', $blackAll, 0, 'L', true, '', 1, false, 'T', 'C');
if ($tipo != 'borrador') {
$pdf->Cell($width1, $height, 'Precio Unitario Ref.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
}
$pdf->Cell($width1, $height, 'Cantidad Ofert.', $blackAll, 0, 'L', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Precio Unitario Ofert.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Total Ofert.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
if ($tipo == 'adjudicado') {
$pdf->Cell($width1, $height, 'Cantidad Adj.', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Total', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
}
$pdf->Ln();
$pdf->SetFontSize(6.5);
foreach ($dataSource->getDataset() as $row) {
$pdf->SetFont('', '');
$xAntesMultiCell = $pdf->getX();
$yAntesMultiCell = $pdf->getY();
//$totalItem
if ($tipo == 'borrador') {
$pdf->MultiCell($width2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
} else {
if ($tipo == 'cotizado') {
$pdf->MultiCell($width2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario_sol'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_coti'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalItem = number_format($row['cantidad_coti'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalItem, 1, 0, 'R', false, '', 1, false, 'T', 'C');
} else {
$pdf->MultiCell($width2 - $width1 * 2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2 - $width1 * 2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario_sol'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_coti'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalItem = number_format($row['cantidad_coti'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalItem, 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_adju'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalAdj = number_format($row['cantidad_adju'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalAdj, 1, 0, 'R', false, '', 1, false, 'T', 'C');
}
}
$pdf->Ln();
}
}
function showPdf($idReg = "")
{
global $db;
// Oficina
//$sesIdOficina = $_SESSION[sesIdOficina];
//$oficina = getValueTable("oficina","OFICINA","id_oficina",$sesIdOficina);
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 009');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING);
// set header and footer fonts
//$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
// $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// $pdf->SetFooterMargin(3);
$pdf->setPageOrientation('P', '', 1);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
//$pdf->setLanguageArray($l);
// set some language dependent data:
$lg = array();
$lg['a_meta_charset'] = 'ISO-8859-1';
$lg['a_meta_dir'] = 'ltr';
$lg['a_meta_language'] = 'es';
$lg['w_page'] = 'page';
//set some language-dependent strings
$pdf->setLanguageArray($lg);
// -------------------------------
// CONSULTA DE DATOS
// -------------------------------
$sql = "select * from SALIDA where id_salida='{$idReg}'";
$db->query($sql);
while ($db->next_record()) {
$docu = $db->f(doc_tipo);
$docuRef = $db->f(doc_ref);
$docTipo = $db->f(doc_tipo);
//$entSal= $db->f('ent_sal');
$idSal = $idReg;
$eir = $db->f(eir);
$idOficina = $db->f(id_oficina);
//$idCliente = $db->f('id_cliente');
//$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente);
$cliente = $db->f('consig');
$idConte = $db->f('id_contenedor');
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) {
$conteL = $parts[1];
$conteN = $parts[2];
}
$maniStPago = $db->f(mani_st_pago);
if ($maniStPago == "M") {
$pagaManiobras = "MERCHANT";
} elseif ($maniStPago == "C") {
$pagaManiobras = "CARRIER";
}
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$bkg = $db->f('bkg');
$clase = $db->f('clase');
$clase = "CLASE: {$clase} ";
$damage = $db->f('damage');
$sello = $db->f('sello');
$nota = $db->f('nota');
//$idTrans = $db->f('id_transporte');
//$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans);
$transp = $db->f('transportista');
$conteP1 = substr($conte, 0, 4);
$conteP2 = substr($conte, 4, 10);
if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) {
$conteP2 = $parts[1] . "-" . $parts[2];
}
$idNav = $db->f('id_naviera');
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav);
$placas = $db->f('placas');
// $idOperador = $db->f('id_operador');
//$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador);
$operador = $db->f('operador');
$capFec = $db->f('cap_fec');
$entSalTx = "SALIDA";
$tipoMani = $db->f('tipo_mani');
$noRecibo = $db->f('recibo');
if ($tipoMani == "D") {
$tipoManiTx = "MANIOBRA DE DESCARGA";
}
if ($tipoMani == "C") {
$tipoManiTx = "MANIOBRA DE CARGA";
}
$maniCosto = $db->f('mani_costo');
$repaCosto = $db->f('repa_costo');
$sumaCpto = $maniCosto + $repaCosto;
$montoLetra = traducirCifra($sumaCpto);
$capIdUsr = $db->f('cap_id_usr');
$capFec = $db->f('cap_fec');
$capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr);
$modFec = $db->f('mod_fec');
$consig = $db->f('consig');
}
// ------------------------------
// DAÑOS
// ------------------------------
$sql = "select * from REL_NOME_SAL_PLUS ";
$sql .= "where id_salida='{$idSal}' ";
$dano = "";
$db->query($sql);
while ($db->next_record()) {
$idRelNome = $db->f(id_rel_nome);
$idNome = $db->f(id_nome);
$idUbica = $db->f(id_ubicacion);
$idDime = $db->f(id_dimension);
$nome = getValueTable("nombre", "NOMENCLATURA", "id_nome", $idNome);
$nomeCode = getValueTable("codigo", "NOMENCLATURA", "id_nome", $idNome);
$ubica = getValueTable("ubicacion", "UBICACION", "id_ubicacion", $idUbica);
$dimen = getValueTable("dimension", "DIMENSION", "id_dimension", $idDime);
$dano .= "{$nome} ({$nomeCode}) : {$ubica} : {$dimen}\n";
}
$dano = nl2br($dano);
// ---------------------------------------------------------
// DATOS DEL RECIBO
// ---------------------------------------------------------
if ($noRecibo > 0) {
$subTotal = $maniCosto + $repaCosto;
$total = $subTotal;
$subTotal = number_format($subTotal, 2);
$total = number_format($total, 2);
$datoRecibo = "\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES OPEMANTRA</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>FECHA</b></td>\n <td><b>No.R.I.E.</b></td> \n <td></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$capFec}</td> \n <td>{$idReg}</td>\n <td></td>\n <td>{$conteL}{$conteN}</td>\n <td>{$equipo}</td>\n </tr> \n <tr>\n <td><b>CONCEPTO</b></td> \n <td><b>TRANSPORTISTA</b></td> \n <td><b>OPERADOR</b></td>\n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td>{$tipoManiTx}</td> \n <td>{$transp}</td>\n <td>{$operador}</td> \n <td colspan=\"2\">{$docu} {$docuRef} / {$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>MANIOBRA \$</b></td>\n <td align=\"right\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>REPARACIONES \$</b></td>\n <td align=\"right\">{$repaCosto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$total}</td>\n </tr>\n </table>\n </td>\n </tr>\n ";
if ($docTipo == "EFECTIVO") {
$datoRecibo .= "\n <tr> \n <td colspan=\"3\" align=\"right\">RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 </td>\n </tr>\n ";
}
$datoRecibo .= "</table>";
}
// -------------------------------------------------------------------
$pdf->AddPage();
// Logo
$pdf->setJPEGQuality(100);
$pdf->Image('../images/logo.jpg', 13, 4, 60, 30, '', '', '', false);
//$pdf->Image('../images/nome.jpg', 15, 145, 185, 120,'','','',false);
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(1, 1, 1, 1);
// Encabezado
$pdf->SetFillColor(197, 197, 197);
// Trebol
$pdf->SetFont('helvetica', '', 14);
$pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true);
//$txt="Av. ";
$pdf->SetFont('helvetica', '', 7);
$pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true);
$pdf->SetFont('helvetica', '', 12);
$tbl = <<<EOD
<table cellspacing="0" cellpadding="3" border="0" align="center">
<tr bgcolor="#cacaca">
<th>FOLIO</th>
</tr>
<tr> \t
\t<td><font color="red">S {$eir}</font></td>
</tr>
</table>
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
$txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)";
$pdf->SetFont('helvetica', 'B', 12);
$pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true);
$pdf->SetFont('helvetica', '', 8);
$tbl = <<<EOD
<br><br><br>
<table cellspacing="0" cellpadding="3" border="0" align="center">
<tr>
<th><b>CONTENEDOR</b></th>
<th><b>CARACTERISTICAS FISICAS</b></th>
<td><b>CLIENTE</b></td>
<td><b>PAGA MANIOBRAS</b></td>
</tr>
<tr>
\t<td>{$conteL}{$conteN}</td>
\t<td>{$equipo} / {$damage} </td>
\t<td>{$consig}</td>
<td>{$pagaManiobras}</td>
</tr>
<tr bgcolor="#cacaca">
\t<th colspan="4"><b>{$entSalTx}</b></th>
</tr>
<tr>
\t<td><b>NAVIERA</b></td>
\t<td><b>FECHA Y HORA</b></td>
<td><b>BOOKING / BL</b></td>
\t<td><b>ESTADO FISICO</b></td> \t
</tr>
<tr>
\t<td>{$naviera}</td>
\t<td>{$capFec}</td>
<td>{$bkg}</td>
\t<td>{$clase}</td> \t
</tr>
<tr>
\t<td><b>TRANSPORTISTA</b></td>
<td><b>OPERADOR</b></td>
<td><b>PLACAS</b></td>
\t<td><b>SELLO</b></td> \t \t
</tr>\t
<tr>
\t<td>{$transp}</td>
<td>{$operador}</td>
<td>{$placas}</td>
<td>{$sello}</td>
</tr>
<tr >
\t<td colspan="2"><b>OBSERVACIONES</b></td> \t
<td colspan="2"><b>DANOS</b></td>
</tr>
<tr >
<td colspan="2">{$nota}</td>
\t<td colspan="2">{$dano}</td>
</tr>
<tr>
<td><b>OPERADOR<br><br><br>Nombre y Firma</b></td>
<td><b>INSPECTOR<br><br><br>Nombre y Firma</b></td>
<td colspan="2">EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.</td>
</tr>
<tr bgcolor="#cacaca">
<td colspan="4"><i>Capturo: {$capUsr}<br>Fecha captura: {$modFec} </i></td>
</tr>
</table>
<br><br><br>
<!-- {$datoRecibo} -->
EOD;
$pdf->writeHTML($tbl, true, false, false, false, '');
/*
($noRecibo>0)?$corY=180:$corY=125;
$txt="OPERADOR\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(40,10,$txt, 0, 'C',0, 0, 15, $corY,true);
$txt="INSPECTOR\n\n\nNOMBRE Y FIRMA";
$pdf->MultiCell(30, 10,$txt, 0, 'C',0, 0, 55, $corY,true);
$txt="EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS. Solicitarla al correo: factu@demo.com.mx";
$pdf->MultiCell(105, 10,$txt, 0, 'L',0, 0, 95, $corY,true);
$txt="EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO
PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.
Solicitarla al correo: facturacionpatios@demo.com.mx";
*/
//($noRecibo>0)?$corY=200:$corY=125;
//$pdf->MultiCell(185, 10,$txt, 1, 'C',0, 0, 15, 200,true);
//Close and output PDF document
$pdf->Output('eirSalida.pdf', 'I');
}
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', '', 10);
// add a page
$pdf->AddPage();
// set color for filler
$pdf->SetFillColor(255, 255, 0);
// Multicell test
$pdf->MultiCell(40, 5, 'A test multicell line 1 test multicell line 2 test multicell line 3', 1, 'L', 1, 0, '', '', true);
$pdf->MultiCell(40, 5, 'B test multicell line 1 test multicell line 2 test multicell line 3', 1, 'R', 0, 1, '', '', true);
$pdf->MultiCell(40, 5, 'C test multicell line 1 test multicell line 2 test multicell line 3', 1, 'C', 0, 0, '', '', true);
$pdf->MultiCell(40, 5, 'D test multicell line 1 test multicell line 2 test multicell line 3' . "\n", 1, 'J', 1, 2, '', '', true);
$pdf->MultiCell(40, 5, 'E test multicell line 1 test multicell line 2 test multicell line 3', 1, 'L', 0, 1, '', '', true);
$pdf->SetFillColor(255, 200, 200);
$pdf->MultiCell(40, 5, 'F test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line test multicell line' . "\n", 1, 'J', 1, 1, '', '', true);
// reset pointer to the last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('example_005.pdf', 'I');
//============================================================+
// END OF FILE
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', 'BI', 16);
// add a page
$pdf->AddPage();
// print a line using Cell()
$pdf->Cell(0, 12, 'Example 035', 1, 1, 'C');
$pdf->Ln();
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 4, 'color' => array(255, 0, 0)));
$pdf->SetFillColor(255, 255, 128);
$pdf->SetTextColor(0, 0, 128);
$text = "DUMMY";
$pdf->Cell(0, 0, $text, 1, 1, 'L', 1, 0);
$pdf->Ln();
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 255)));
$pdf->SetFillColor(255, 255, 0);
$pdf->SetTextColor(0, 0, 255);
$pdf->MultiCell(60, 4, $text, 1, 'C', 1, 0);
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(255, 255, 0)));
$pdf->SetFillColor(0, 0, 255);
$pdf->SetTextColor(255, 255, 0);
$pdf->MultiCell(60, 4, $text, 'TB', 'C', 1, 0);
$pdf->SetLineStyle(array('width' => 0.5, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(255, 0, 255)));
$pdf->SetFillColor(0, 255, 0);
$pdf->SetTextColor(255, 0, 255);
// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
require_once dirname(__FILE__) . '/lang/eng.php';
$pdf->setLanguageArray($l);
}
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', '', 10);
// add a page
$pdf->AddPage();
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(1, 1, 1, 1);
// set color for background
$pdf->SetFillColor(255, 255, 127);
// MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0)
// set some text for example
$txt = 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.';
//$final = $pdf->write2DBarcode('7024736019|3|2104002021751|2015-10-02|30.50|30.50|15451254|0|0|0|0', 'QRCODE,L', '', '', 30, 30, '', 'N');
// Multicell test
$pdf->MultiCell(55, 5, '[LEFT] ' . $txt, 1, 'L', 1, 0, '', '', true);
$pdf->MultiCell(55, 5, '[RIGHT] ' . $txt, 1, 'R', 0, 1, '', '', true);
$pdf->MultiCell(55, 5, '[CENTER] ' . $txt, 1, 'C', 0, 0, '', '', true);
$pdf->MultiCell(55, 5, '[JUSTIFY] ' . $txt . "\n", 1, 'J', 1, 2, '', '', true);
$pdf->MultiCell(55, 5, '[DEFAULT] ' . $txt, 1, '', 0, 1, '', '', true);
$pdf->Ln(4);
// set color for background
$pdf->SetFillColor(220, 255, 220);
// Vertical alignment
$pdf->MultiCell(55, 40, '[VERTICAL ALIGNMENT - TOP] ' . $txt, 1, 'J', 1, 0, '', '', true, 0, false, true, 40, 'T');
}
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 20);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of independent Multicell() columns', '', 0, 'L', true, 0, false, false, 0);
$pdf->Ln(5);
$pdf->SetFont('times', '', 12);
// create columns content
// create columns content
$left_column = '[LEFT COLUMN] left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column' . "\n";
$right_column = '[RIGHT COLUMN] right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column' . "\n";
// MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0)
// set color for background
$pdf->SetFillColor(255, 255, 200);
// set color for text
$pdf->SetTextColor(0, 63, 127);
// write the first column
$pdf->MultiCell(80, 0, $left_column, 1, 'J', 1, 0, '', '', true, 0, false, true, 0);
// set color for background
$pdf->SetFillColor(215, 235, 255);
// set color for text
$pdf->SetTextColor(127, 31, 0);
// write the second column
$pdf->MultiCell(80, 0, $right_column, 1, 'J', 1, 1, '', '', true, 0, false, true, 0);
// reset pointer to the last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('example_017.pdf', 'I');
<tr> <td>1B</td> <td>4E</td> </tr> <tr> <td>1C</td> <td>2C</td> <td>3C</td> <td>4F</td> </tr> </table>'; // output the HTML content $pdf->writeHTML($html, true, false, true, false, ''); // Print some HTML Cells $html = '<span color="red">red</span> <span color="green">green</span> <span color="blue">blue</span><br /><span color="red">red</span> <span color="green">green</span> <span color="blue">blue</span>'; $pdf->SetFillColor(255, 255, 0); $pdf->writeHTMLCell(0, 0, '', '', $html, 'LRTB', 1, 0, true, 'L', true); $pdf->writeHTMLCell(0, 0, '', '', $html, 'LRTB', 1, 1, true, 'C', true); $pdf->writeHTMLCell(0, 0, '', '', $html, 'LRTB', 1, 0, true, 'R', true); // reset pointer to the last page $pdf->lastPage(); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Print a table // add a page $pdf->AddPage(); // create some HTML content $html = '<h1>Image alignments on HTML table</h1> <table cellpadding="1" cellspacing="1" border="1" style="text-align:center;"> <tr><td><img src="../images/logo_example.png" border="0" height="41" width="41" /></td></tr> <tr style="text-align:left;"><td><img src="../images/logo_example.png" border="0" height="41" width="41" align="top" /></td></tr> <tr style="text-align:center;"><td><img src="../images/logo_example.png" border="0" height="41" width="41" align="middle" /></td></tr>
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set default font subsetting mode
$pdf->setFontSubsetting(true);
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 12);
// add a page
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(0, 1, 0, 1);
// set font color
$pdf->SetTextColor(50, 50, 50);
$pdf->SetFillColor(238, 238, 238);
$pdf->AddPage();
// Transparancy Image Stamp
// if(!empty($dx_invoice_stamp_img)){
// $pdf->Image($dx_invoice_stamp_img, 18, 15, 16, '', '', 'http://Dxinvoice.com', '', false, 300);
// }
// Transparancy Image Stamp
if (!empty($dx_invoice_stamp_img)) {
$pdf->Image($dx_invoice_stamp_img, $dx_stamp_position, 130, 30, '', '', '', '', false, 300);
}
//if(!empty($dx_invoice_signature_img))
//$pdf->Image($dx_invoice_signature_img, 174, 241, 20, 10, '', 'http://Dxinvoice.com', '', false, 300);
// output the HTML content
$pdf->writeHTML($html, true, 0, true, 0);
// reset pointer to the last page
$pdf->lastPage();
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
//initialize document
$pdf->AliasNbPages();
// add a page
$pdf->AddPage();
// ---------------------------------------------------------
// set font
$pdf->SetFont('freeserif', '', 12);
// get esternal file content
$utf8text = file_get_contents("../cache/utf8test.txt", false);
// set a background color
$pdf->SetFillColor(230, 240, 255, true);
// write the text
$pdf->Write(5, $utf8text, '', 1);
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('example_008.pdf', 'I');
//============================================================+
// END OF FILE
//============================================================+
'courierI',
'courierBI',
'helvetica',
'helveticaB',
'helveticaI',
'helveticaBI',
'times',
'timesB',
'timesI',
'timesBI',
'symbol',
'zapfdingbats'
);
// set fill color
$pdf->SetFillColor ( 221, 238, 255 );
// create one HTML table for each core font
foreach ( $core_fonts as $font ) {
// add a page
$pdf->AddPage ();
// Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false,
// $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M')
// set font for title
$pdf->SetFont ( 'helvetica', 'B', 16 );
// print font name
$pdf->Cell ( 0, 10, 'FONT: ' . $font, 1, 1, 'C', true, '', 0, false, 'T', 'M' );
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// check also the following methods:
// SetDrawColorArray()
// SetFillColorArray()
// SetTextColorArray()
// set font
$pdf->SetFont('helvetica', 'B', 18);
// add a page
$pdf->AddPage();
$pdf->Write(0, 'Example of CMYK, RGB and Grayscale colours', '', 0, 'L', true, 0, false, false, 0);
// define style for border
$border_style = array('all' => array('width' => 2, 'cap' => 'square', 'join' => 'miter', 'dash' => 0, 'phase' => 0));
// --- CMYK ------------------------------------------------
$pdf->SetDrawColor(50, 0, 0, 0);
$pdf->SetFillColor(100, 0, 0, 0);
$pdf->SetTextColor(100, 0, 0, 0);
$pdf->Rect(30, 60, 30, 30, 'DF', $border_style);
$pdf->Text(30, 92, 'Cyan');
$pdf->SetDrawColor(0, 50, 0, 0);
$pdf->SetFillColor(0, 100, 0, 0);
$pdf->SetTextColor(0, 100, 0, 0);
$pdf->Rect(70, 60, 30, 30, 'DF', $border_style);
$pdf->Text(70, 92, 'Magenta');
$pdf->SetDrawColor(0, 0, 50, 0);
$pdf->SetFillColor(0, 0, 100, 0);
$pdf->SetTextColor(0, 0, 100, 0);
$pdf->Rect(110, 60, 30, 30, 'DF', $border_style);
$pdf->Text(110, 92, 'Yellow');
$pdf->SetDrawColor(0, 0, 0, 50);
$pdf->SetFillColor(0, 0, 0, 100);
function getReportPDF($filterlist = false)
{
require_once 'libraries/tcpdf/tcpdf.php';
$reportData = $this->GenerateReport("PDF", $filterlist);
$arr_val = $reportData['data'];
if (isset($arr_val)) {
foreach ($arr_val as $wkey => $warray_value) {
foreach ($warray_value as $whd => $wvalue) {
if (strlen($wvalue) < strlen($whd)) {
$w_inner_array[] = strlen($whd);
} else {
$w_inner_array[] = strlen($wvalue);
}
}
$warr_val[] = $w_inner_array;
unset($w_inner_array);
}
foreach ($warr_val[0] as $fkey => $fvalue) {
foreach ($warr_val as $wkey => $wvalue) {
$f_inner_array[] = $warr_val[$wkey][$fkey];
}
sort($f_inner_array, 1);
$farr_val[] = $f_inner_array;
unset($f_inner_array);
}
foreach ($farr_val as $skkey => $skvalue) {
if ($skvalue[count($arr_val) - 1] == 1) {
$col_width[] = $skvalue[count($arr_val) - 1] * 50;
} else {
$col_width[] = $skvalue[count($arr_val) - 1] * 10 + 10;
}
}
$count = 0;
foreach ($arr_val[0] as $key => $value) {
$headerHTML .= '<td width="' . $col_width[$count] . '" bgcolor="#DDDDDD"><b>' . $this->getLstringforReportHeaders($key) . '</b></td>';
$count = $count + 1;
}
foreach ($arr_val as $key => $array_value) {
$valueHTML = "";
$count = 0;
foreach ($array_value as $hd => $value) {
$valueHTML .= '<td width="' . $col_width[$count] . '">' . $value . '</td>';
$count = $count + 1;
}
$dataHTML .= '<tr>' . $valueHTML . '</tr>';
}
}
$totalpdf = $this->GenerateReport("PRINT_TOTAL", $filterlist);
$html = '<table border="0.5"><tr>' . $headerHTML . '</tr>' . $dataHTML . '<tr><td>' . $totalpdf . '</td></tr>' . '</table>';
$columnlength = array_sum($col_width);
if ($columnlength > 14400) {
die("<br><br><center>" . $app_strings['LBL_PDF'] . " <a href='javascript:window.history.back()'>" . $app_strings['LBL_GO_BACK'] . ".</a></center>");
}
if ($columnlength <= 420) {
$pdf = new TCPDF('P', 'mm', 'A5', true);
} elseif ($columnlength >= 421 && $columnlength <= 1120) {
$pdf = new TCPDF('L', 'mm', 'A3', true);
} elseif ($columnlength >= 1121 && $columnlength <= 1600) {
$pdf = new TCPDF('L', 'mm', 'A2', true);
} elseif ($columnlength >= 1601 && $columnlength <= 2200) {
$pdf = new TCPDF('L', 'mm', 'A1', true);
} elseif ($columnlength >= 2201 && $columnlength <= 3370) {
$pdf = new TCPDF('L', 'mm', 'A0', true);
} elseif ($columnlength >= 3371 && $columnlength <= 4690) {
$pdf = new TCPDF('L', 'mm', '2A0', true);
} elseif ($columnlength >= 4691 && $columnlength <= 6490) {
$pdf = new TCPDF('L', 'mm', '4A0', true);
} else {
$columnhight = count($arr_val) * 15;
$format = array($columnhight, $columnlength);
$pdf = new TCPDF('L', 'mm', $format, true);
}
$pdf->SetMargins(10, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
$pdf->setLanguageArray($l);
$pdf->AddPage();
$pdf->SetFillColor(224, 235, 255);
$pdf->SetTextColor(0);
$pdf->SetFont('FreeSerif', 'B', 14);
$pdf->Cell($pdf->columnlength * 50, 10, getTranslatedString($oReport->reportname), 0, 0, 'C', 0);
//$pdf->writeHTML($oReport->reportname);
$pdf->Ln();
$pdf->SetFont('FreeSerif', '', 10);
$pdf->writeHTML($html);
return $pdf;
}
$pdf->writeHTMLCell($header_w + $slen, $header_h, $x, $y, $date->format($df) . " " . $AppUI->_('Tasks Due to be Completed By'));
// Line break - Line4
$y = $y + $header_line_gap;
$slen = strlen($pname . "\n") + $str_pad;
$pdf->writeHTMLCell($header_w + $slen, $header_h, $x, $y, $pname);
// Line break - Line5
$y = $y + $header_line_gap;
$y = $y + $header_line_gap;
$y = $y + $header_line_gap;
// Column Header
$pdf->SetFont("", "", 10);
//B= bold , I = Italic , U = Underlined
$w = array(90, 50, 80, 60, 30);
$x_init = $x;
// Color and font restoration
$pdf->SetFillColor(224, 235, 255);
$pdf->SetTextColor(0);
for ($i = 0; $i < count($columns); $i++) {
$pdf->writeHTMLCell($w[$i], $header_h, $x_init, $y, $columns[$i] . "\n", 0, 0, 1);
$x_init = $x_init + $w[$i];
}
// Line break - Line6
$row_height = round($pdf->getLastH());
$y = $y + $row_height;
// Color and font restoration
$pdf->SetFillColor(224, 235, 255);
$pdf->SetTextColor(0);
// Data
$fill = 0;
$x_init = $x;
$pdf->SetXY($x_init, $y);
function writeDetalles(DataSource $dataSource, TCPDF $pdf, $tipo)
{
$blackAll = array('LTRB' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$widthMarginLeft = 1;
$width1 = 20;
$width2 = 130;
$pdf->Ln();
$pdf->SetFontSize(7.5);
$pdf->SetFont('', 'B');
$height = 5;
$pdf->SetFillColor(255, 255, 255, true);
$pdf->setTextColor(0, 0, 0);
$pdf->Cell($width1 - 5, $height, 'Cantidad', $blackAll, 0, 'L', true, '', 1, false, 'T', 'C');
if ($tipo == 'Bien') {
$pdf->Cell($width2, $height, 'Item', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
} else {
if ($tipo == 'Bien - Servicio') {
$pdf->Cell($width2, $height, 'Compra-Servicio', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
} else {
$pdf->Cell($width2, $height, 'Servicio', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
}
}
$pdf->Cell($width1, $height, 'Precio Unitario', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Total Bs.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
$pdf->Ln();
$pdf->SetFontSize(6.5);
$totalOrdenCompra = 0.0;
foreach ($dataSource->getDataset() as $row) {
$pdf->SetFont('', '');
//$totalItem
$pdf->Cell($width1 - 5, $height, $row['cantidad_adju'], 1, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width2, $height, $row['desc_solicitud_det'], 1, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalItem = $row['cantidad_adju'] * $row['precio_unitario'];
$pdf->Cell($width1, $height, number_format($totalItem, 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Ln();
//var_dump($totalItem+$totalOrdenCompra);
$totalOrdenCompra = $totalOrdenCompra + $totalItem;
//var_dump($totalOrdenCompra);
$obj = new Numbers_Words_es_AR();
$numero = explode('.', number_format($totalItem, 2));
$pdf->Cell($width2 + $width1 + $width1 / 2 + $width1 / 4, $height, 'SON: ' . strtoupper(trim($obj->toWords(str_replace(',', '', $numero[0])))) . ' ' . $numero[1] . '/' . '100 ' . strtoupper($this->getDataSource()->getParameter('moneda')), 1, 0, 'L', false, '', 1, false, 'T', 'C');
}
$pdf->Cell($width1, $height, number_format($totalOrdenCompra, 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Ln();
}
function generateShipmentReport($conn)
{
global $gTEXT;
require_once 'tcpdf/tcpdf.php';
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetPrintHeader(false);
$pdf->SetPrintFooter(false);
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
require_once dirname(__FILE__) . '/lang/eng.php';
$pdf->setLanguageArray($l);
}
$pdf->AddPage();
$pdf->SetFillColor(255, 255, 255);
//=====================================================National Inventory Table=======================================================
/* $months = $_POST['MonthNumber'];
$monthIndex = date("n");
$yearIndex = date("Y");
settype($yearIndex, "integer");
if ($monthIndex == 1){
$monthIndex = 12;
$yearIndex = $yearIndex - 1;
}else{
$monthIndex = $monthIndex - 1;
}
$months = $months - 1;
$currentYearMonth = $yearIndex."-0".$monthIndex."-"."01";
$currentYearMonth = date('Y-m-d', strtotime($currentYearMonth));
$lastYearMonth = date("Y-m-d", strtotime(date("Y-m-d", strtotime($currentYearMonth)) . "-".$months." month"));
*/
$StartMonthId = $_POST['StartMonthId'];
$StartYearId = $_POST['StartYearId'];
$EndMonthId = $_POST['EndMonthId'];
$EndYearId = $_POST['EndYearId'];
if ($_POST['MonthNumber'] != 0) {
$months = $_POST['MonthNumber'];
$monthIndex = date("m");
$yearIndex = date("Y");
settype($yearIndex, "integer");
$startDate = $yearIndex . "-" . $monthIndex . "-" . "01";
$startDate = date('Y-m-d', strtotime($startDate));
$months--;
$endDate = date("Y-m-d", strtotime(date("Y-m-d", strtotime($startDate)) . "+" . $months . " month"));
} else {
$startDate = $StartYearId . "-" . $StartMonthId . "-" . "01";
$startDate = date('Y-m-d', strtotime($startDate));
$d = cal_days_in_month(CAL_GREGORIAN, $EndMonthId, $EndYearId);
$endDate = $EndYearId . "-" . $EndMonthId . "-" . $d;
$endDate = date('Y-m-d', strtotime($endDate));
}
$CountryId = $_POST['ACountryId'];
$AFundingSourceId = $_POST['AFundingSourceId'];
$ASStatusId = $_POST['ASStatusId'];
$ItemGroup = $_POST['ItemGroup'];
$OwnerTypeId = $_POST['OwnerType'];
if ($AFundingSourceId) {
$AFundingSourceId = " AND a.FundingSourceId = '" . $AFundingSourceId . "' ";
}
if ($ASStatusId) {
$ASStatusId = " AND a.ShipmentStatusId = '" . $ASStatusId . "' ";
}
if ($ItemGroup) {
$ItemGroup = " AND e.ItemGroupId = '" . $ItemGroup . "' ";
}
if ($OwnerTypeId) {
$OwnerTypeId = " AND f.OwnerTypeId = '" . $OwnerTypeId . "' ";
}
$sLimit = "";
if (isset($_POST['iDisplayStart'])) {
$sLimit = " LIMIT " . mysql_real_escape_string($_POST['iDisplayStart']) . ", " . mysql_real_escape_string($_POST['iDisplayLength']);
}
$sOrder = "";
if (isset($_POST['iSortCol_0'])) {
$sOrder = " ORDER BY ";
for ($i = 0; $i < mysql_real_escape_string($_POST['iSortingCols']); $i++) {
$sOrder .= fnColumnToField_agencyShipment(mysql_real_escape_string($_POST['iSortCol_' . $i])) . "" . mysql_real_escape_string($_POST['sSortDir_' . $i]) . ", ";
}
$sOrder = substr_replace($sOrder, "", -2);
}
$sWhere = "";
if ($_POST['sSearch'] != "") {
$sWhere = " AND (a.ItemNo LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%' OR " . " e.ItemName LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%' OR " . " c.ShipmentStatusDesc LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%') ";
}
$sql = "SELECT SQL_CALC_FOUND_ROWS AgencyShipmentId, a.FundingSourceId, d.FundingSourceName, a.ShipmentStatusId, c.ShipmentStatusDesc, a.CountryId, \n b.CountryName, a.ItemNo, e.ItemName, a.ShipmentDate, a.Qty, a.OwnerTypeId, f.OwnerTypeName \n\t\t\tFROM t_agencyshipment as a\n INNER JOIN t_country b ON a.CountryId = b.CountryId\n INNER JOIN t_shipmentstatus c ON a.ShipmentStatusId = c.ShipmentStatusId\n INNER JOIN t_fundingsource d ON a.FundingSourceId= d.FundingSourceId\n INNER JOIN t_itemlist e ON a.ItemNo = e.ItemNo\n INNER JOIN t_owner_type f ON a.OwnerTypeId = f.OwnerTypeId \n WHERE CAST(a.ShipmentDate AS DATETIME) BETWEEN CAST('{$startDate}' AS DATETIME) AND CAST('{$endDate}' AS DATETIME) \n AND (a.CountryId = " . $CountryId . " OR " . $CountryId . " = 0) \n " . $AFundingSourceId . " " . $ASStatusId . " " . $ItemGroup . " " . $OwnerTypeId . "\n\t\t\t{$sWhere} {$sOrder} {$sLimit} ";
$result = mysql_query($sql, $conn);
$total = mysql_num_rows($result);
$i = 0;
$f = 0;
$GrandtotalQty = 0;
$SubtotalQty = 0;
$OldCountry = ' ';
$NewCountry = ' ';
$serial = 1;
$tblHTML = '';
if ($total > 0) {
/* $data=array();
$f=0;
$tblHTML='';
$tempGroupId='';*/
while ($rec = mysql_fetch_array($result)) {
$ItemName = trim(preg_replace('/\\s+/', ' ', addslashes($rec['ItemName'])));
$date = strtotime($rec['ShipmentDate']);
$newdate = date('d/m/Y', $date);
if ($OldCountry == ' ') {
$OldCountry = addslashes($rec['CountryName']);
}
$NewCountry = addslashes($rec['CountryName']);
if ($OldCountry != $NewCountry) {
$tblHTML .= '<tr >
<td style="background-color:#FE9929;border-radius:2px;align:center; font-size:12px;"colspan="5">Sub Total</td>
<td style="background-color:#FE9929;border-radius:2px;text-align:right; font-size:12px;">' . number_format($SubtotalQty) . '</td>
</tr>';
$tblHTML .= '<tr >
<td style="background-color:#DAEF62;border-radius:2px;align:center; font-size:12px;"colspan="6">' . $NewCountry . '</td>
</tr>';
$tempGroupId = $rec['CountryName'];
$OldCountry = $NewCountry;
$SubtotalQty = $rec['Qty'];
} else {
$SubtotalQty += $rec['Qty'];
}
if ($tempGroupId != $rec['CountryName']) {
$tblHTML .= '<tr >
<td style="background-color:#DAEF62;border-radius:2px; align:center; font-size:12px;" colspan="6">' . $rec['CountryName'] . '</td>
</tr>';
$tempGroupId = $rec['CountryName'];
}
$tblHTML .= '<tr>
<td style="text-align: center;">' . $serial++ . '</td>
<td style="text-align:left;">' . $ItemName . '</td>
<td style="text-align:left;">' . addslashes($rec['FundingSourceName']) . '</td>
<td style="text-align:left;">' . addslashes($rec['ShipmentStatusDesc']) . '</td>
<td style="text-align:right;">' . $newdate . '</td>
<td style="text-align:right;">' . number_format(addslashes($rec['Qty'])) . '</td>
</tr>';
$GrandtotalQty += $rec['Qty'];
$tblHTML .= '';
if ($total == $i + 1) {
$tblHTML .= '<tr >
<td style="background-color:#FE9929;border-radius:2px; align:center; font-size:12px;" colspan="5">Sub Total</td>
<td style="background-color:#FE9929;border-radius:2px; text-align:right; font-size:12px;" ">' . number_format($SubtotalQty) . '</td>
</tr>';
$tblHTML .= '<tr >
<td style="background-color:#FE9929;border-radius:2px; align:center; font-size:12px;" colspan="5">Sub Total</td>
<td style="background-color:#FE9929;border-radius:2px; text-align:right; font-size:12px;" ">' . number_format($SubtotalQty) . '</td>
</tr>';
$tblHTML .= '<tr >
<td style="background-color:#50ABED;border-radius:2px; align:center; font-size:12px;" colspan="5">Grand Total</td>
<td style="background-color:#50ABED;border-radius:2px; text-align:right; font-size:12px;" ">' . number_format($GrandtotalQty) . '</td>
</tr>';
$tblHTML .= '<tr >
<td style="background-color:#50ABED;border-radius:2px; align:center; font-size:12px;" colspan="5">Grand Total</td>
<td style="background-color:#50ABED;border-radius:2px; text-align:right; font-size:12px;" ">' . number_format($GrandtotalQty) . '</td>
</tr>';
}
$i++;
}
//$months = $_POST['MonthNumber'];
$months = $_POST['MonthNumber'];
$CountryName = $_POST['CountryName'];
$FundingSourceName = $_POST['FundingSourceName'];
$ItemGroupName = $_POST['ItemGroupName'];
$ASStatusName = $_POST['ASStatusName'];
$OwnerTypeName = $_POST['OwnerTypeName'];
$html = '
<!-- EXAMPLE OF CSS STYLE -->
<style>
p {
line-height: 0.5px;
}
</style>
<body>
<p style="text-align:center;"><h4 ><b>' . $gTEXT['Shipment Reports'] . ' of ' . $CountryName . ' ' . $gTEXT['from'] . ' ' . date('M,Y', strtotime($startDate)) . ' ' . $gTEXT['to'] . ' ' . date('M,Y', strtotime($endDate)) . '</b></h4></p>
<p style="text-align:center;"><h5><b>' . $FundingSourceName . ' - ' . $ASStatusName . ' - ' . $ItemGroupName . ' - ' . $OwnerTypeName . '</b><h5></p>
</body>';
$pdf->SetFont('dejavusans', '', 10);
$pdf->writeHTMLCell(0, 0, 8, 10, $html, '', 0, 0, false, 'C', true);
//date('M,Y', strtotime($StartYearMonth)), date('M,Y', strtotime($EndYearMonth))
$html = '
<!-- EXAMPLE OF CSS STYLE -->
<style>
td{
height: 6px;
line-height:3px;
}
th{
height:20;
font-size:10px;
}
</style>
<body>
<table width="600px" border="0.5" style="margin:0 auto;">
<tr>
<th width="30" align="center"><b>SL#</b></th>
<th width="250" align="left"><b>' . $gTEXT['Product Name'] . '</b></th>
<th width="100" align="left"><b>' . $gTEXT['Funding Source'] . '</b></th>
<th width="90" align="left"><b>' . $gTEXT['Shipment Status'] . '</b></th>
<th width="100" align="right"><b>' . $gTEXT['Shipment Date'] . '</b></th>
<th width="90" align="right"><b>' . $gTEXT['Quantity'] . '</b></th>
</tr>' . $tblHTML . '</table></body>';
//echo $tblHTML;
$pdf->SetFont('dejavusans', '', 7);
$pdf->writeHTMLCell(0, 0, 10, 40, $html, '', 1, 1, false, 'L', true);
$filePath = SITEDOCUMENT . 'administrator/components/com_jcode/source/report/pdfslice/ShipmentReport.pdf';
if (file_exists($filePath)) {
unlink($filePath);
}
$pdf->Output('pdfslice/ShipmentReport.pdf', 'F');
echo 'ShipmentReport.pdf';
} else {
echo 'Processing Error';
}
}
public function testPdfOutput()
{
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 055');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 055', PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
$pdf->setLanguageArray($this->langSettings);
// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 14);
// array of font names
$core_fonts = array('courier', 'courierB', 'courierI', 'courierBI', 'helvetica', 'helveticaB', 'helveticaI', 'helveticaBI', 'times', 'timesB', 'timesI', 'timesBI', 'symbol', 'zapfdingbats');
// set fill color
$pdf->SetFillColor(221, 238, 255);
// create one HTML table for each core font
foreach ($core_fonts as $font) {
// add a page
$pdf->AddPage();
// Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M')
// set font for title
$pdf->SetFont('helvetica', 'B', 16);
// print font name
$pdf->Cell(0, 10, 'FONT: ' . $font, 1, 1, 'C', true, '', 0, false, 'T', 'M');
// set font for chars
$pdf->SetFont($font, '', 16);
// print each character
for ($i = 0; $i < 256; ++$i) {
if ($i > 0 and $i % 16 == 0) {
$pdf->Ln();
}
$pdf->Cell(11.25, 11.25, TCPDF_FONTS::unichr($i), 1, 0, 'C', false, '', 0, false, 'T', 'M');
}
$pdf->Ln(20);
// print a pangram
$pdf->Cell(0, 0, 'The quick brown fox jumps over the lazy dog', 0, 1, 'C', false, '', 0, false, 'T', 'M');
}
// ---------------------------------------------------------
$this->comparePdfs($pdf);
}
