function createPDF($text)
{
if (!isset($GLOBALS["pdf_font"])) {
$GLOBALS["pdf_font"] = 'Arial';
$GLOBALS["pdf_fontsize"] = 12;
}
$pdf = new FPDF();
$pdf->SetCreator("PHPlist version " . VERSION);
$pdf->Open();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont($GLOBALS["pdf_font"], $GLOBALS["pdf_fontstyle"], $GLOBALS["pdf_fontsize"]);
$pdf->Write((int) $GLOBALS["pdf_fontsize"] / 2, $text);
$fname = tempnam($GLOBALS["tmpdir"], "pdf");
$pdf->Output($fname, false);
return $fname;
}
function generate_pdf($prenote)
{
require_once 'fpdf17/fpdf.php';
$pdf = new FPDF();
$length = count($prenote->product);
$pdf->Open();
$pdf->AddPage('P', array(50, 49 + $length * 8));
$pdf->SetFont('Arial', '', 9);
$pdf->Image($prenote->folio . '.png', 3, 2, 35, 15, 'PNG');
$pdf->Text(7, 20, $prenote->folio);
$pdf->Text(5, 24, $prenote->clientName);
$pdf->Text(5, 26, '------------------------------');
$product = $prenote->product;
$c = 0;
for ($i = 0; $i < $length; $i++) {
$pdf->Text(5, 29 + $c, utf8_decode($product[$i]->Description));
$pdf->Text(5, 33 + $c, $product[$i]->scanCode);
$pdf->Text(20, 33 + $c, $product[$i]->Quantity);
$precio_cantidad = $product[$i]->Quantity * $product[$i]->Price;
$pdf->Text(28, 33 + $c, '$' . $precio_cantidad);
$c += 8;
}
$c -= 8;
$pdf->Text(5, 35 + $c, '------------------------------');
$pdf->Text(25, 38 + $c, $prenote->narticles);
$pdf->Text(5, 38 + $c, '$' . $prenote->total);
$pdf->Text(5, 42 + $c, $prenote->id_employee);
$pdf->Text(10, 42 + $c, $prenote->employeeName);
$pdf->Text(5, 46 + $c, $prenote->store_id);
$pdf->Text(10, 46 + $c, $prenote->store_name);
$pdf->Text(5, 50 + $c, $prenote->cotizationNumber);
$pdf->Text(5, 54 + $c, $prenote->date);
$pdf->Output($prenote->folio . '.pdf', 'F');
}
function class_pdf_maker($orientation = 'P', $unit = 'in', $format = 'letter')
{
parent::FPDF($orientation, $unit, $format);
parent::SetMargins(0, 0);
parent::Open();
parent::AddPage();
parent::SetAutoPageBreak(FALSE);
}
function Open($file)
{
if (FPDF_VERSION < '1.53') {
$this->Error('Version 1.53 or above is required by this extension');
}
$this->f = fopen($file, 'wb');
if (!$this->f) {
$this->Error('Unable to create output file: ' . $file);
}
parent::Open();
$this->_putheader();
}
public function Open($file = 'doc.pdf')
{
if (FPDF_VERSION < '1.7') {
$this->Error('Version 1.7 or above is required by this extension');
}
$this->file = fopen($file, 'wb');
if (!$this->file) {
$this->Error("Unable to create output file: {$file}");
}
parent::Open();
$this->_putheader();
}
/**
* Constructor method
* @param $orientation Page orientation
* @param $format Page format
* @author Pablo Dall'Oglio
*/
public function __construct($orientation = 'P', $format = 'a4')
{
parent::__construct($orientation, 'pt', $format);
$this->setLocale();
parent::SetAutoPageBreak(true);
parent::SetMargins(0, 0, 0);
parent::SetCreator('Adianti Studio PDF Designer');
// parent::SetTitle('Letter');
// parent::SetKeywords('www.xyz.com.br');
parent::SetFillColor(255, 255, 255);
parent::Open();
parent::AliasNbPages();
parent::SetX(20);
$this->replaces = array();
$this->href = '';
$this->anchors = array();
$this->orientation = $orientation;
$this->format = $format;
parent::SetFont('Arial', '', 10 * 1.3);
}
function UsersTrafficPeriodPDF()
{
//require('chart.php');
require 'lib/fpdf.php';
global $SAMSConf;
global $DATE;
$DB = new SAMSDB();
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
$size = "";
if (isset($_GET["size"])) {
$size = $_GET["size"];
}
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
define('FPDF_FONTPATH', 'lib/font/');
require 'lib/fpdf.php';
$pdfFile = new FPDF();
$pdfFile->Open();
$pdfFile->AddFont('Nimbus', '', 'Nimbus.php');
$pdfFile->SetAuthor("SQUID Account Management System");
$pdfFile->SetCreator("Created by SAMS2");
$pdfFile->SetTitle("SAMS2 users statistic");
// UsersTrafficPeriodPDF();
$pdfFile->AddPage();
$pdfFile->SetFont('Nimbus', '', 15);
//$pdfFile->SetFont('SUSESerif-Roman','',16);
$pdfFile->SetXY(50, 15);
echo " {$usersbuttom_2_traffic_UsersTrafficPeriod_1}<BR>{$usersbuttom_2_traffic_UsersTrafficPeriod_2}<br>";
$pdfFile->Write(0, " {$usersbuttom_2_traffic_UsersTrafficPeriod_1}<BR>{$usersbuttom_2_traffic_UsersTrafficPeriod_2}");
$pdfFile->Output();
}
public function get_toIDs_handler()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$TRANS = $this->config->get('TRANS_DB') . $dbc->sep();
define('FPDF_FONTPATH', 'font/');
include dirname(__FILE__) . '/../src/fpdf/fpdf.php';
$pdf = new FPDF('P', 'mm', 'Letter');
//start new instance of PDF
$pdf->Open();
//open new PDF Document
$count = 0;
$x = 0;
$y = 0;
$date = date("m/d/Y");
$infoP = $dbc->prepare_statement("SELECT ItemQtty,total,regPrice,p.card_no,description,department,\n CASE WHEN p.card_no=0 THEN o.lastName ELSE c.LastName END as name,\n CASE WHEN p.card_no=0 THEN o.firstName ELSE c.FirstName END as fname,\n CASE WHEN o.phone is NULL THEN m.phone ELSE o.phone END as phone,\n discounttype,quantity,\n p.mixMatch AS vendorName\n FROM {$TRANS}PendingSpecialOrder AS p\n LEFT JOIN custdata AS c ON p.card_no=c.CardNo AND personNum=p.voided\n LEFT JOIN meminfo AS m ON c.CardNo=m.card_no\n LEFT JOIN {$TRANS}SpecialOrders AS o ON o.specialOrderID=p.order_id\n WHERE trans_id=? AND p.order_id=?");
$flagP = $dbc->prepare_statement("UPDATE {$TRANS}PendingSpecialOrder SET charflag='P'\n WHERE trans_id=? AND order_id=?");
$idP = $dbc->prepare_statement("SELECT trans_id FROM {$TRANS}PendingSpecialOrder WHERE\n trans_id > 0 AND order_id=? ORDER BY trans_id");
$signage = new \COREPOS\Fannie\API\item\FannieSignage(array());
foreach ($this->toIDs as $toid) {
if ($count % 4 == 0) {
$pdf->AddPage();
$pdf->SetDrawColor(0, 0, 0);
$pdf->Line(108, 0, 108, 279);
$pdf->Line(0, 135, 215, 135);
}
$x = $count % 2 == 0 ? 5 : 115;
$y = $count / 2 % 2 == 0 ? 10 : 145;
$pdf->SetXY($x, $y);
$tmp = explode(":", $toid);
$tid = $tmp[0];
$oid = $tmp[1];
$r = $dbc->exec_statement($infoP, array($tid, $oid));
$w = $dbc->fetch_row($r);
// flag item as "printed"
$r2 = $dbc->exec_statement($flagP, array($tid, $oid));
$r3 = $dbc->exec_statement($idP, array($oid));
$o_count = 0;
$rel_id = 1;
while ($w3 = $dbc->fetch_row($r3)) {
$o_count++;
if ($w3['trans_id'] == $tid) {
$rel_id = $o_count;
}
}
$pdf->SetFont('Arial', '', '12');
$pdf->Text($x + 85, $y, "{$rel_id} / {$o_count}");
$pdf->SetFont('Arial', 'B', '24');
$pdf->Cell(100, 10, $w['name'], 0, 1, 'C');
$pdf->SetFont('Arial', '', '12');
$pdf->SetX($x);
$pdf->Cell(100, 8, $w['fname'], 0, 1, 'C');
$pdf->SetX($x);
if ($w['card_no'] != 0) {
$pdf->Cell(100, 8, "Owner #" . $w['card_no'], 0, 1, 'C');
$pdf->SetX($x);
}
$pdf->SetFont('Arial', '', '16');
$pdf->Cell(100, 9, $w['description'], 0, 1, 'C');
$pdf->SetX($x);
$pdf->Cell(100, 9, "Cases: " . $w['ItemQtty'] . ' - ' . $w['quantity'], 0, 1, 'C');
$pdf->SetX($x);
$pdf->SetFont('Arial', 'B', '16');
$pdf->Cell(100, 9, sprintf("Total: \$%.2f", $w['total']), 0, 1, 'C');
$pdf->SetFont('Arial', '', '12');
$pdf->SetX($x);
if ($w['discounttype'] == 1 || $w['discounttype'] == 2) {
$pdf->Cell(100, 9, 'Sale Price', 0, 1, 'C');
$pdf->SetX($x);
} elseif ($w['regPrice'] - $w['total'] > 0) {
$percent = round(100 * (($w['regPrice'] - $w['total']) / $w['regPrice']));
$pdf->Cell(100, 9, sprintf("Owner Savings: \$%.2f (%d%%)", $w['regPrice'] - $w['total'], $percent), 0, 1, 'C');
$pdf->SetX($x);
}
$pdf->Cell(100, 6, "Tag Date: " . $date, 0, 1, 'C');
$pdf->SetX($x);
$pdf->Cell(50, 6, "Dept #" . $w['department'], 0, 0, 'R');
$pdf->SetFont('Arial', 'B', '12');
$pdf->SetX($x + 50);
$pdf->Cell(50, 6, $w['vendorName'], 0, 1, 'L');
$pdf->SetFont('Arial', '', '12');
$pdf->SetX($x);
$pdf->Cell(100, 6, "Ph: " . $w['phone'], 0, 1, 'C');
$pdf->SetXY($x, $y + 85);
$pdf->Cell(160, 10, "Notes: _________________________________");
$pdf->SetX($x);
$upc = "454" . str_pad($oid, 6, '0', STR_PAD_LEFT) . str_pad($tid, 2, '0', STR_PAD_LEFT);
$pdf = $signage->drawBarcode($upc, $pdf, $x + 30, $y + 95, array('height' => 14, 'fontsize' => 8));
$count++;
}
$pdf->Output();
return false;
}
function createPDF($text)
{
if (!isset($GLOBALS['pdf_font'])) {
$GLOBALS['pdf_font'] = 'Arial';
$GLOBALS['pdf_fontsize'] = 12;
}
$pdf = new FPDF();
$pdf->SetCreator('PHPlist version ' . VERSION);
$pdf->Open();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont($GLOBALS['pdf_font'], $GLOBALS['pdf_fontstyle'], $GLOBALS['pdf_fontsize']);
$pdf->Write((int) $GLOBALS['pdf_fontsize'] / 2, $text);
$fname = tempnam($GLOBALS['tmpdir'], 'pdf');
$pdf->Output($fname, false);
return $fname;
}
/**
* @Template() *
* @Route("/statistique-participations/", name="statistiqueparticipations")
*/
public function statistiqueParticipationsAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
if (!$this->get('security.authorization_checker')->isGranted('ROLE_SUPER_ADMIN')) {
$user = $this->getUser();
$id = $user->getId();
$activites = $this->get("alb_inscriptions.alb_manager")->getActivitesAdherent($id);
$bureau = $this->get("alb_inscriptions.alb_manager")->isBureau($id, $activites);
if ($bureau) {
$groupes = $this->get("alb_inscriptions.alb_manager")->getGroupesAdherent($id);
$activitesgroupe = $em->getRepository('ALBInscriptionsBundle:Activites')->findByIdgroupes($groupes);
foreach ($activitesgroupe as $activite) {
$activites[] = $activite->getId();
}
}
$activites = $this->get("alb_inscriptions.alb_manager")->getListeActivites($activites);
} else {
$activites = $em->getRepository('ALBInscriptionsBundle:Activites')->findAll();
$groupes = $em->getRepository('ALBInscriptionsBundle:Groupes')->findAll();
}
if ('POST' === $request->getMethod()) {
$activite = $request->get('activite');
$groupe = $request->get('groupe');
if ($activite > 0) {
$nomactivite = $em->getRepository('ALBInscriptionsBundle:Activites')->find($activite)->getActivite();
} elseif ($groupe > 0) {
$nomactivite = $em->getRepository('ALBInscriptionsBundle:groupes')->find($groupe)->getGroupe();
} else {
$nomactivite = 'Toutes';
}
$datedebut = $request->get('datedebut');
$datefin = $request->get('datefin');
$nb = 0;
if ($activite > 0) {
$participants = $this->get("alb_inscriptions.alb_manager")->getListeParticipantsActivite($activite);
} else {
$participants = $this->get("alb_inscriptions.alb_manager")->getListeParticipants($groupe);
}
$nomfichier = 'statistiques/' . $activite . '.pdf';
$pdf = new \FPDF();
$pdf->Open();
$pdf->SetTopMargin(5);
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 14);
$pdf->Cell(0, 5, utf8_decode('Amicale Laïque de Billère'), 0, 1, 'C');
$pdf->ln(2);
$pdf->SetFont('Arial', '', 12);
$pdf->Cell(0, 5, utf8_decode('Liste des présences aux sorties ' . $nomactivite . ' entre le ' . substr($datedebut, 8, 2) . '/' . substr($datedebut, 5, 2) . '/' . substr($datedebut, 0, 4) . ' et le ' . substr($datefin, 8, 2) . '/' . substr($datefin, 5, 2) . '/' . substr($datefin, 0, 4)), 0, 1);
$pdf->ln(2);
$pdf->SetFont('Arial', '', 8);
$pdf->SetFont('Arial', 'B', 8);
$pdf->Cell(5, 4, '', 1, 0, 'C');
$pdf->Cell(50, 4, utf8_decode('Nom Prénom'), 1, 0, 'C');
//$pdf->Cell(20,4,utf8_decode('Activité'),1,0,'C');
$pdf->Cell(30, 4, utf8_decode('Nb de présence'), 1, 1, 'C');
$pdf->SetFont('Arial', '', 8);
$i = 0;
$encadrement = false;
foreach ($participants as $participant) {
if ($participant->getAidemeneur() and !$encadrement) {
$pdf->Cell(55, 4, 'TOTAL', 1, 0, 'R');
$pdf->Cell(30, 4, $nb, 1, 1, 'C');
$nb = 0;
$encadrement = true;
$i = 0;
$pdf->SetFont('Arial', 'B', 8);
$pdf->Cell(85, 5, 'ENCADREMENT', 0, 1, 'C');
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(5, 4, '', 1, 0, 'C');
$pdf->Cell(50, 4, utf8_decode('Nom Prénom'), 1, 0, 'C');
//$pdf->Cell(20,4,utf8_decode('Activité'),1,0,'C');
$pdf->Cell(30, 4, utf8_decode('Nb de présence'), 1, 1, 'C');
}
$i++;
$pdf->Cell(5, 4, $i, 1, 0, 'C');
$pdf->Cell(50, 4, utf8_decode($participant->getIdadherent()->getNom() . ' ' . $participant->getIdadherent()->getPrenom()), 1, 0, '');
$id = $participant->getId();
if ($activite > 0) {
$nbparticipation = $this->get("alb_inscriptions.alb_manager")->getNbParticipationActivite($activite, $id, $datedebut, $datefin);
} else {
$nbparticipation = $this->get("alb_inscriptions.alb_manager")->getNbParticipationGroupe($groupe, $id, $datedebut, $datefin);
}
$pdf->Cell(30, 4, $nbparticipation, 1, 1, 'C');
$nb = $nb + $nbparticipation;
}
$pdf->Cell(55, 4, 'TOTAL', 1, 0, 'R');
$pdf->Cell(30, 4, $nb, 1, 1, 'C');
$pdf->Output($nomfichier, 'F');
$response = new Response();
$response->setContent(file_get_contents($nomfichier));
$response->headers->set('Content-Type', 'application/force-download');
$response->headers->set('Content-disposition', 'filename=' . $nomfichier);
return $response;
}
return array('activites' => $activites, 'groupes' => $groupes);
}
function facturarform($idFactura)
{
global $db, $hoy, $tmIdUsuario, $facturado;
$pdf = new FPDF();
// Manda datos al FPDF.
$pdf->Open();
$pdf->SetMargins(20, 20, 20);
$pdf->AddPage();
$cont = 0;
$row = 100;
// inicio de renglon para los conceptos.
// Moneda
$moneda = getValueTable("moneda", "FT_TMA", "id_factura", $idFactura);
$idCliente = getValueTable("id_cliente", "FT_TMA", "id_factura", $idFactura);
//actualizar flg_proforma para indicar que ya se puede mandar a imprimir la factura
$sql = "update FT_TMA set flg_proforma='1' where id_factura='{$idFactura}'";
$db->query($sql);
// Datos del cliente
$sql = "select * from FT_CLIENTE where id_cliente='{$idCliente}'";
$db->query($sql);
while ($db->next_record()) {
$cliente = $db->f(cliente);
$tel = $db->f(tel);
$rfc = $db->f(rfc);
$calle = $db->f(calle);
$noExt = $db->f(no_ext);
$noInt = $db->f(no_int);
$colonia = $db->f(colonia);
$cp = $db->f(cp);
$ciudad = $db->f(ciudad);
$edo = $db->f(edo);
}
// Encabezado
$pdf->Image('../images/msc.jpg', 8, 16, 13);
$pdf->Image('../images/rfc2.jpg', 5, 235, 25);
$pdf->Image('../images/mscblackF.jpg', 25, 80, 150);
$pdf->SetFont('Arial', 'B', 15);
//$pdf->Text(65,20,"RECIBASE");
$pdf->SetFont('Arial', 'B', 11);
$pdf->Text(25, 23, "MEDITERRANEAN SHIPPING COMPANY MÉXICO, S.A. DE C.V.");
$pdf->SetFont('Arial', 'B', 9);
$pdf->Text(153, 23, "AS AGENTS ONLY");
$pdf->SetFont('Arial', 'B', 6);
//DIRECCION OFICINA MATRIZ
$pdf->Text(5, 30, "OFICINA MATRIZ");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(2, 32, "AV. BENJAMIN FRANKLIN No 204");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(2, 34, "PISO 1 COL ESCANDON C.P. 11800");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(1, 36, "DELEG. MIGUEL HIDALGO, MEXICO DF");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(9, 38, "TEL50917070");
//DIRECCION OFICINA ALTAMIRA
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(35, 29, "SUC. ALTAMIRA");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(35, 31, "AV. RIO TMESI KM0+700");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(30, 33, "EDIF. TORRE MULTIMODAL DESP. 306");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(32, 35, "C.P. 69600 PUERTO INDUSTRIAL");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(38, 37, "ALTAMIRA, TAMPS.");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(37, 39, "TEL: 01 833 260-3200");
//DIRECCION OFICINA GUADALAJARA
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(62, 30, "SUC. GUADALAJARA");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(65, 32, "RUBEN DARIO No 217");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(60, 34, "COL.CIRCUNVALACION VALLARTA");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(62, 36, "C.P. 44680 GUADALAJARA JAL.");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(66, 38, "TEL: 01 33 3630-4460");
//DIRECCION OFICINA MANZANILLO
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(92, 30, "SUC. MANZANILLO");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(90, 32, "CALLE 20 DE NOVIEMBRE No 11");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(92, 34, "COL.BUROCRATA C.P.28250");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(96, 36, "MANZANILLO, COL.");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(95, 38, "TEL: 01 314 332-3055");
//DIRECCION OFICINA MAZATLAN
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(122, 29, "SUC. MANZATLAN");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(118, 31, "AV. EMILIO BARRAGAN No 63 DESP. 102");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(123, 33, "EDIF. CENTRO MARITIMO");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(123, 35, "CO. CENTRO C.P. 82000");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(125, 37, "MAZATLAN SINALOA");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(125, 39, "TEL. 01 569 985-0844");
//DIRECCION OFICINA VERACRUZ
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(152, 29, "SUC. VERACRUZ");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(153, 31, "AV. 5 DE MAYO No 961");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(152, 33, "DEPTO 2 ENTRE JUAREZ");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(153, 35, "Y EMPARAM COL. CENTRO");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(152, 37, "C.P. 91700 VERACRUZ VER");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(152, 39, "TEL. 01 229 931-0416");
//DIRECCION OFICINA MONTERREY
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(182, 29, "SUC. MONTERREY");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(183, 31, "AV. ZARAGOZA No 1000");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(182, 33, "DESP. 1010 COL. CENTRO");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(182, 35, "C.P. 54000 MONTERREY N.L.");
$pdf->SetFont('Arial', 'B', 4);
$pdf->Text(184, 37, "TEL. 01 83 5345-1010");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.2);
$pdf->Line(5, 40, 140, 40);
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(10, 43, "CLIENTE : ");
$pdf->SetFont('Arial', 'B', 10);
// Cliente
$pdf->Text(24, 43, $cliente);
$pdf->Text(24, 49, $calle);
if (!empty($cp)) {
$cpT = "C.P. {$cp}";
} else {
$cpT = "";
}
$dir = "{$noExt} {$noInt} {$colonia} {$cpT}";
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(10, 50, "DIRECCION : ");
$pdf->SetFont('Arial', 'B', 10);
$pdf->Text(24, 52, $dir);
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(10, 58, "TEL : ");
$pdf->Text(60, 58, "R.F.C.");
$pdf->SetFont('Arial', 'B', 10);
$pdf->Text(24, 58, $tel);
$pdf->Text(70, 58, $rfc);
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(10, 61, "CIUDAD : ");
$pdf->SetFont('Arial', 'B', 10);
$pdf->Text(24, 61, $ciudad);
$pdf->Text(60, 64, $edo);
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.2);
$pdf->Line(156, 57, 193, 57);
$pdf->SetLineWidth(0.2);
$pdf->Line(5, 64, 140, 64);
//LINEA VERTICAL
$pdf->SetLineWidth(0.2);
$pdf->Line(5, 40, 5, 64);
$pdf->SetLineWidth(0.2);
//$pdf->Line(140,40,140,64);
$pdf->Line(140, 40, 140, 64);
//VERTICAL FECHA
$pdf->SetLineWidth(0.2);
$pdf->Line(156, 57, 156, 70);
$pdf->SetLineWidth(0.2);
$pdf->Line(193, 57, 193, 70);
$pdf->SetLineWidth(0.2);
$pdf->Line(165, 57, 165, 70);
$pdf->SetLineWidth(0.2);
$pdf->Line(180, 57, 180, 70);
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.2);
$pdf->Line(156, 62, 193, 62);
$pdf->SetLineWidth(0.2);
$pdf->Line(156, 70, 193, 70);
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(158, 60, "DIA");
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(170, 60, "MES");
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(183, 60, "AÑO");
$pdf->SetFont('Arial', 'B', 12);
$pdf->Text(163, 45, "PRO-FORMA");
$pdf->SetFont('Arial', '', 12);
$pdf->Text(168, 52, "{$idFactura}");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.2);
$pdf->Line(3, 84, 205.5, 84);
$pdf->SetLineWidth(0.2);
$pdf->Line(3, 90, 205.5, 90);
$pdf->SetLineWidth(0.2);
$pdf->Line(3, 235, 205, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(45, 283, 190, 283);
$pdf->SetLineWidth(0.2);
$pdf->Line(20, 295, 190, 295);
$pdf->SetFont('Arial', '', 6);
$pdf->Text(4, 88, "CANT.");
$pdf->SetFont('Arial', '', 6);
$pdf->Text(60, 88, "DESCRIPCIÓN");
$pdf->SetFont('Arial', '', 6);
$pdf->Text(140, 88, "P. UNITARIO");
$pdf->SetFont('Arial', '', 6);
$pdf->Text(180, 88, "P. UNITARIO");
//LINEA VERTICAL
$pdf->SetLineWidth(0.2);
$pdf->Line(3, 84, 3, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(205.5, 84, 205.5, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(13, 84, 13, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(123, 84, 123, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(168, 84, 168, 235);
$pdf->SetLineWidth(0.2);
$pdf->Line(20, 283, 20, 295);
$pdf->SetLineWidth(0.2);
$pdf->Line(190, 283, 190, 295);
//$pdf->Image('../images/rfc2.JPG',8,16,13);
$pdf->SetFont('Arial', 'B', 6);
$pdf->Text(21, 283, "IMPORTE CON LETRA");
//Selecciona la fecha emitida
$fecha = getValueTable("femitida", "FT_TMA", "id_factura", $idFactura);
//MESES
//Poner formato de Fecha de Captura
$ano = substr($fecha, 0, 4);
$mes = substr($fecha, 5, 2);
$dia = substr($fecha, 8, 2);
$mesC = date("F", mktime(0, 0, 0, $mes, $dia, $ano));
if ($mesC == "January") {
$mc = "ENERO";
}
if ($mesC == "February") {
$mc = "FEBRERO";
}
if ($mesC == "March") {
$mc = "MARZO";
}
if ($mesC == "April") {
$mc = "ABRIL";
}
if ($mesC == "May") {
$mc = "MAYO";
}
if ($mesC == "June") {
$mc = "JUNIO";
}
if ($mesC == "July") {
$mc = "JULIO";
}
if ($mesC == "August") {
$mc = "AGOSTO";
}
if ($mesC == "September") {
$mc = "SEP";
}
if ($mesC == "October") {
$mc = "OCT";
}
if ($mesC == "November") {
$mc = "NOV";
}
if ($mesC == "December") {
$mc = "DIC";
}
//$fecha_final=$dia."/".$mc."/".$ano;
//$pdf->Text(162,44,$fecha_final);
// Fecha
$pdf->Text(160, 67, $dia);
$pdf->Text(168, 67, $mc);
$pdf->Text(184, 67, $ano);
/*$pdf->Text(24,67,"HONDURAS");
$pdf->Text(66,67,"HONDURAS");
$pdf->Text(120,67,$rfc);*/
//Imprimir Conceptos
$sql = "select id_fac_rel from FT_REL_CONCEPTO_PRO where id_factura='{$idFactura}'";
$db->query($sql);
while ($db->next_record()) {
$idFacRel = $db->f(id_fac_rel);
}
unset($totalG);
if (empty($idFacRel)) {
$sql = "select * from FT_REL_CONCEPTO where id_factura='{$idFactura}'";
} else {
$sql = "select * from FT_REL_CONCEPTO_PRO where id_factura='{$idFactura}'";
}
$db->query($sql);
while ($db->next_record()) {
$idConcepto = $db->f(id_concepto);
$conceptoConta = getValueTable("concepto", "FT_CONCEPTO", "id_concepto", $idConcepto);
$conceptoImp = $db->f(concepto_imp);
$cantidad = $db->f(cantidad);
$precioU = $db->f(preciou);
$iva = $db->f(iva);
$importeT = $db->f(importe);
$descpT = $db->f(descp);
//$long= strlen($importeT);
//$importeU= $importeT;
//$longU= strlen($importeU);
//Imprimir los conceptos
//Cantidad
$pdf->Text(4, $row, $cantidad);
//IDENTIFICAMOS QUE CONCEPTO MANDAMOS A IMPRESION
if (empty($conceptoImp)) {
$concepto = $conceptoConta;
} else {
$concepto = $conceptoImp;
}
//Concepto
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(15, $row, $concepto);
$concepto = "";
$precioU = number_format($precioU, 2);
$longU = strlen($precioU);
//Importe Unitario
switch ($longU) {
case "4":
//$precioU= number_format($precioU,2);
$pdf->Text(136, $row, $precioU);
//0.00
break;
case "5":
//$precioU=number_format($precioU,2);
$pdf->Text(134.8, $row, $precioU);
//136.9 ; 00.00
break;
case "6":
//$precioU=number_format($precioU,2);
$pdf->Text(133.7, $row, $precioU);
//134.7 : 000.00
break;
case "7":
//$precioU=number_format($precioU,2);
$pdf->Text(130.5, $row, $precioU);
//130.5 ; 0000.00
break;
case "8":
//$precioU=number_format($precioU,2);
$pdf->Text(131.9, $row, $precioU);
//128.4 ; 0,000.00
break;
case "9":
//$precioU=number_format($precioU,2);
$pdf->Text(130.9, $row, $precioU);
//128.4 ; 00,000.00
break;
case "10":
//$precioU=number_format($precioU,2);
$pdf->Text(129.5, $row, $precioU);
//128.4 ; 000,000.00
break;
case "12":
//$precioU=number_format($precioU,2);
$pdf->Text(127.7, $row, $precioU);
//128.4 ; 0,000,000.00
break;
}
$totalG = $totalG + $importeT;
//$importeT=number_format($importeT,2);
$long = strlen($importeT);
//Importe Total
switch ($long) {
case "4":
//$importeT=number_format($importeT,2);
$pdf->Text(182.0, $row, $importeT);
//184
break;
case "5":
//$importeT=number_format($importeT,2);
$pdf->Text(180.9, $row, $importeT);
//181.9
break;
case "6":
//$importeT=number_format($importeT,2);
$pdf->Text(179.7, $row, $importeT);
//179.7
break;
case "7":
//$importeT=number_format($importeT,2);
$pdf->Text(175.5, $row, $importeT);
//175.5
break;
case "8":
//$importeT=number_format($importeT,2);
$pdf->Text(178.0, $row, $importeT);
//173.4
break;
case "9":
//$importeT=number_format($importeT,2);
$pdf->Text(176.9, $row, $importeT);
//173.4
break;
case "10":
//$importeT=number_format($importeT,2);
$pdf->Text(175.9, $row, $importeT);
//173.4
break;
case "12":
//$importeT=number_format($importeT,2);
$pdf->Text(173.9, $row, $importeT);
//173.4
break;
}
/*$descp = getValueTable("descp","FT_TMA","id_factura",$idFactura);
if (!empty($descp)) {
//Descripcion
$descpT=$descp;
}*/
if (!empty($descpT)) {
$descp = $descpT;
} else {
$descp = getValueTable("descp", "FT_TMA", "id_factura", $idFactura);
}
$cadena = substr($direccion, 0, 67);
$cadena2 = substr($direccion, 67);
$lenght = strlen($cadena);
if (!$lenght == 67) {
$pdf->Text(28, 54, $cadena);
} else {
$pdf->Text(28, 54, $cadena);
$pdf->Text(28, 57, $cadena2);
}
/*
$cadenax = substr($descp,0,67);
$cadena2x = substr($descp,67);
$lenght = strlen($cadenax);
if(!$lenght == 67){
$pdf->SetFont('Courier','B',8);
$pdf->Text(20,$row+3,$cadenax);
}else{
$pdf->SetFont('Courier','B',8);
$pdf->Text(20,$row+3,$cadenax);
$pdf->Text(20,$row+6,$cadena2x);
} */
$caddes = strlen($descp);
$inid = 0;
$find = 60;
//$posd=175;
//$pos=0;
$row += 3;
while ($caddes > 0) {
$datad[] = substr($descp, $inid, $find);
$inid = $inid + 60;
$find = $find;
$caddes = $caddes - 60;
//$pdf->Text(90,$s,$description);
//$s=$s+3;
foreach ($datad as $line) {
$pdf->SetFont('Courier', 'B', 8);
$pdf->Text(20, $row, $line);
$row = $row + 3;
unset($datad);
}
}
/*if(!empty($descpT)){
$arrT= explode("|",$descpT);
$row+=3;
foreach ($arrT as $tx){
$pdf->Text(30,$row,$tx);
$row+=3;
}
$row+=2;
}
else {
$row+=4;
}*/
//}
//CALCULAR EL IVA Y EL SUBTOTAL MANUALMENTE.
//$totalG=$totalG+$importeT;
$tlIva = $tlIva + $iva;
}
/* //VER IMPRESOS LOS CONTENEDORES CAPTURADOS.
$sql="select f.id_msc_bl_conte as id_msc_bl_conte, f.id_bl_conte as id_bl_conte ";
$sql.="from FT_TMA_BL_CONTE f, BL_CONTE b, EXPO e ";
$sql.="where f.id_bl_conte=b.id_bl_conte and b.id_bl=e.Id_expo and f.id_factura='$idFactura' order by e.Bl ";
$db->query($sql);
while( $db->next_record() ){
$idFBlConte= $db->f(id_msc_bl_conte);
$idBlConte= $db->f(id_bl_conte);
$idBl= getValueTable("id_bl","BL_CONTE","id_bl_conte",$idBlConte);
$idConte= getValueTable("id_contenedor","BL_CONTE","id_bl_conte",$idBlConte);
$idTipo= getValueTable("id_equipo","CONTENEDOR","id_contenedor",$idConte);
$bl = getValueTable("Bl","EXPO","Id_expo",$idBl);
$conte = getValueTable("numero","CONTENEDOR","Id_contenedor",$idConte);
$tipo = getValueTable("equipo","EQUIPO","Id_equipo",$idTipo);
$blConteTipo.="[".$bl."/".$conte."-".$tipo."]";
}
$descp=$blConteTipo;
$caddes = strlen($descp);
$inid=0;
$find=60;
//$posd=175;
//$pos=0;
$row+=4;
while ($caddes > 0) {
$datad[]=substr($descp,$inid,$find);
$inid=$inid+60;
$find=$find;
$caddes=$caddes-60;
//$pdf->Text(90,$s,$description);
//$s=$s+3;
foreach ( $datad as $line ) {
$pdf->SetFont('Courier','B',8);
$pdf->Text(20,$row,$line);
$row=$row+3;
unset($datad);
}
}
//LEYENDA OBLIGATORIA EN LA FACTURA
$pdf->SetFont('Courier','B',10);
$pdf->Text(15,232,"EL PAGO DE ESTA FACTURA SE HACE EN UNA SOLA EXHIBICION");
//VER No CARACTERES Y SEPARAR LA CADENA DE 90 EN 90 PARA DESCRIPTION
/* $descp = getValueTable("descp","FT_TMA","id_factura",$idFactura);
$caddes = strlen($descp);
$inid=0;
$find=90;
//$posd=175;
//$pos=0;
$row+=3;
while ($caddes > 0) {
$datad[]=substr($descp,$inid,$find);
$inid=$inid+90;
$find=$find;
$caddes=$caddes-90;
//$pdf->Text(90,$s,$description);
//$s=$s+3;
foreach ( $datad as $line ) {
$pdf->Text(13,$row,$line);
$row=$row+2;
unset($datad);
}
}*/
//Total,Iva,Subtotal
//$totalG=number_format($totalG,2);
$totalT = $totalG + $tlIva;
//$totalT=number_format($totalT,2);
/*$totalT= getValueTable("total","FT_TMA","id_factura",$idFactura);
$totalG= getValueTable("subtotal","FT_TMA","id_factura",$idFactura);
$tlIva= getValueTable("iva","FT_TMA","id_factura",$idFactura);*/
$totalT2 = str_replace(",", "", $totalT);
if (preg_match("/^(\\d+)\\.{0,2}/", $totalT2, $part)) {
$importeInt = $part[1];
}
$importeLetra = traducirCifra($importeInt);
//( ereg( "\.([0-9]+)", $totalT2, $regs ) )?$centavos=$regs[1]:$centavos="00";
if (preg_match("/\\.([0-9]+)/", $totalT2, $regs)) {
$centavos = $regs[1];
} else {
$centavos = "00";
}
//( ereg( "\.([0-9]+{2})", $totalT2, $regs ) )?$centavos=$regs[1]:$centavos="00";
$nameMoneda = getValueTable("moneda", "INFO", "id_info", 1);
$nameMoneda = strtoupper($nameMoneda);
if ($moneda == "2") {
$txtImporte = "{$importeLetra} {$nameMoneda} {$centavos}/100 M.N.";
} elseif ($moneda == "1") {
$txtImporte = "{$importeLetra} DOLARES {$centavos}/100 CTS";
}
$pdf->SetFont('Arial', 'B', 10);
//Imprimir Total
$longSub = strlen($totalG);
//$pdf->Text(170,215,$longSub);
$rowImp = 245;
switch ($longSub) {
case "1":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(183, $rowImp, $totalG);
break;
case "2":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(186, $rowImp, $totalG);
break;
case "3":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(183, $rowImp, $totalG);
break;
case "4":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(183, $rowImp, $totalG);
//179.9
break;
case "5":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(175.9, $rowImp, $totalG);
break;
case "6":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(181.7, $rowImp, $totalG);
//181.7
break;
case "7":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(182.5, $rowImp, $totalG);
//177.5
break;
case "8":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalG = number_format($totalG, 2);
$pdf->Text(175.4, $rowImp, $totalG);
break;
case "9":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalT = number_format($totalT, 2);
$pdf->Text(171.4, $rowImp, $totalG);
break;
case "10":
$pdf->Text(155, $rowImp, "SUBTOTAL:");
$totalT = number_format($totalT, 2);
$pdf->Text(170.4, $rowImp, $totalG);
break;
}
// Imprimir Iva
$longIva = strlen($tlIva);
$rowImpX = 255;
switch ($longIva) {
case "1":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(184, $rowImpX, $tlIva);
break;
case "2":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(185, $rowImpX, $tlIva);
break;
case "3":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(186, $rowImpX, $tlIva);
break;
case "4":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(186, $rowImpX, $tlIva);
break;
case "5":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(183.9, $rowImpX, $tlIva);
break;
case "6":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(185.7, $rowImpX, $tlIva);
break;
case "7":
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(177.5, $rowImpX, $tlIva);
break;
case "8":
$tlIva = number_format($tlIva, 2);
$pdf->Text(175.4, $rowImpX, $tlIva);
break;
case "9":
//$pdf->Text(155,$row,"TOTAL : ");
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(171.4, $rowImpX, $tlIva);
break;
case "10":
//$pdf->Text(155,$row,"TOTAL : ");
$pdf->Text(155, $rowImpX, "IVA:");
$tlIva = number_format($tlIva, 2);
$pdf->Text(170.4, $rowImpX, $tlIva);
break;
}
//Imprimir Total
$longT = strlen($totalT);
$rowImpY = 265;
switch ($longT) {
case "1":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(183, $rowImpY, $totalT);
break;
case "2":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(183, $rowImpY, $totalT);
break;
case "3":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(183, $rowImpY, $totalT);
break;
case "4":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(183, $rowImpY, $totalT);
//183
break;
case "5":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(183.9, $rowImpY, $totalT);
//180.9
break;
case "6":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(181.7, $rowImpY, $totalT);
//178.7
break;
case "7":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(177.5, $rowImpY, $totalT);
//174.5
break;
case "8":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(175.4, $rowImpY, $totalT);
//172.4
break;
case "9":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(171.4, $rowImpY, $totalT);
//171.4
break;
case "10":
$pdf->Text(155, $rowImpY, "TOTAL : ");
$totalT = number_format($totalT2, 2);
$pdf->Text(171.4, $rowImpY, $totalT);
//170.4
break;
}
$pdf->SetFont('Arial', 'B', 10);
$pdf->Text(25, 290, $txtImporte);
//LEYENDA OBLIGATORIA EN LA FACTURA
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(15, 232, "EL PAGO DE ESTA FACTURA SE HACE EN UNA SOLA EXHIBICION");
//------------------------------------------
//SACAMOS LA INFORMACION DE LOS CONTENEDORES
//------------------------------------------
$numContes = 0;
$sql = "select f.id_msc_bl_conte as id_msc_bl_conte, f.id_bl_conte as id_bl_conte ";
$sql .= "from FT_TMA_BL_CONTE f, BL_CONTE b, EXPO e ";
$sql .= "where f.id_bl_conte=b.id_bl_conte and b.id_bl=e.Id_expo and f.id_factura='{$idFactura}' order by e.Bl ";
$db->query($sql);
while ($db->next_record()) {
//NUMERO DE CONTENEDORES PARA IMPRIMIR
$numContes = $numContes + 1;
$idFBlConte = $db->f(id_msc_bl_conte);
$idBlConte = $db->f(id_bl_conte);
$idBl = getValueTable("id_bl", "BL_CONTE", "id_bl_conte", $idBlConte);
$idConte = getValueTable("id_contenedor", "BL_CONTE", "id_bl_conte", $idBlConte);
$idTipo = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$bl = getValueTable("Bl", "EXPO", "Id_expo", $idBl);
$conte = getValueTable("numero", "CONTENEDOR", "Id_contenedor", $idConte);
$tipo = getValueTable("equipo", "EQUIPO", "Id_equipo", $idTipo);
$blConteTipo .= "[" . $bl . "|" . $conte . "|" . $tipo . "]";
$blsS = $blsS . "," . $bl;
$conteS = $conteS . "," . $conte;
}
$numContesLine = $numContes / 4;
$numLine = $row + $numContesLine;
//----------------------------------------------------
//PREGUNTAMOS SI NO SE REQUIERE UN ARCHIVO ANEXO ENTRA
//----------------------------------------------------
//$anexo=1;
if ($anexo == 0) {
if ($numLine <= 220) {
//$descp=$blConteTipo;
$descp = "Bls: {$blsS} // Conte: {$conteS}";
$caddes = strlen($descp);
$inid = 0;
$find = 72;
//$posd=175;
//$pos=0;
$row += 3;
$rowPdf2 = 10;
$flgPdf2 = 0;
while ($caddes > 0) {
if ($flgPdf2 == 0) {
$datad[] = substr($descp, $inid, $find);
$inid = $inid + 72;
$find = $find;
$caddes = $caddes - 72;
}
}
if (!empty($datad)) {
foreach ($datad as $line) {
$pdf->SetFont('Courier', 'B', 7);
$pdf->Text(15, $row, $line);
$row = $row + 3;
unset($datad);
}
}
} else {
//----------------------------
//CONTENEDORES EN LA HOJA No 2
//----------------------------
// ENCABEZADO
$pdf->SetFont('Courier', 'B', 12);
$row = $row + 10;
$pdf->Text(15, $row, "{$numContes} CONTENEDORES SEGUN RELACION ANEXA");
$pdf->AddPage();
$pdf->Image('../images/msc.jpg', 8, 1, 15);
$pdf->Image('../images/mscblackF.jpg', 25, 80, 150);
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(75, 12, "ANEXO DE CONTENEDORES");
$pdf->SetFont('Arial', 'B', 12);
$pdf->Text(35, 7, "MEDITERRANEAN SHIPPING COMPANY MEXICO, S.A. DE C.V.");
$numFactura = getValueTable("folio", "FT_TMA", "id_factura", $idFactura);
$pdf->SetFont('Arial', 'B', 9);
$pdf->Text(165, 12, "FACTURA : {$numFactura}");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 17, 205, 17);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 205, 2);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 295, 205, 295);
//LINEA VERTICAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 5, 295);
$pdf->SetLineWidth(0.5);
$pdf->Line(205.5, 2, 205.5, 295);
$numeroAnexos = $numeroAnexos - 1;
//-----------------------------
$rowPdf2 = 20;
//MANDAMOS A IMPRESION LOS NUMEROS DE CONTENEDORES EN EL PDF2
//$descp=$blConteTipo;
$desc = "Bls : {$blsS} // Conte: {$conteS}";
$caddes = strlen($descp);
$inid = 0;
$find = 126;
//$posd=175;
//$pos=0;
$row += 4;
//$rowPdf2=10;
//$flgPdf2=0;
while ($caddes > 0) {
$datad[] = substr($descp, $inid, $find);
$inid = $inid + 126;
$find = $find;
$caddes = $caddes - 126;
$linePdf2 = $linePdf2 + 1;
}
//AGREGAR LAS HOJAS QUE SEAN NECESARIAS PARA IMPRIMIR TODOS LOS CONTENEDORES
if (!empty($datad)) {
foreach ($datad as $line) {
$conta = $conta + 1;
$contaLine = $contaLine + 1;
$pdf->SetFont('Courier', 'B', 7);
$pdf->Text(5, $rowPdf2, $contaLine);
$pdf->Text(10, $rowPdf2, $line);
$rowPdf2 = $rowPdf2 + 3;
unset($datad);
if ($conta == 92) {
$conta = "";
// ENCABEZADO
$pdf->AddPage();
$pdf->Image('../images/msc.jpg', 8, 1, 15);
$pdf->Image('../images/mscblackF.jpg', 25, 80, 150);
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(75, 12, "ANEXO DE CONTENEDORES");
$pdf->SetFont('Arial', 'B', 12);
$pdf->Text(35, 7, "MEDITERRANEAN SHIPPING COMPANY MEXICO, S.A. DE C.V.");
$pdf->SetFont('Arial', 'B', 9);
$pdf->Text(165, 12, "FACTURA : {$numFactura}");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 17, 205, 17);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 205, 2);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 295, 205, 295);
//LINEA VERTICAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 5, 295);
$pdf->SetLineWidth(0.5);
$pdf->Line(205.5, 2, 205.5, 295);
$rowPdf2 = 20;
}
}
}
}
} else {
//----------------------------
//CONTENEDORES EN LA HOJA No 2
//----------------------------
// ENCABEZADO
$pdf->SetFont('Courier', 'B', 12);
$row = $row + 10;
$pdf->Text(15, $row, "{$numContes} CONTENEDORES SEGUN RELACION ANEXA");
$pdf->AddPage();
$pdf->Image('../images/msc.jpg', 8, 1, 15);
$pdf->Image('../images/mscblackF.jpg', 25, 80, 150);
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(75, 12, "ANEXO DE CONTENEDORES");
$pdf->SetFont('Arial', 'B', 12);
$pdf->Text(35, 7, "MEDITERRANEAN SHIPPING COMPANY MEXICO, S.A. DE C.V.");
$numFactura = getValueTable("folio", "FT_TMA", "id_factura", $idFactura);
$pdf->SetFont('Arial', 'B', 9);
$pdf->Text(165, 12, "FACTURA : {$numFactura}");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 17, 205, 17);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 205, 2);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 295, 205, 295);
//LINEA VERTICAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 5, 295);
$pdf->SetLineWidth(0.5);
$pdf->Line(205.5, 2, 205.5, 295);
$numeroAnexos = $numeroAnexos - 1;
//-----------------------------
$rowPdf2 = 20;
//MANDAMOS A IMPRESION LOS NUMEROS DE CONTENEDORES EN EL PDF2
$descp = $blConteTipo;
$caddes = strlen($descp);
$inid = 0;
$find = 126;
//$posd=175;
//$pos=0;
$row += 4;
//$rowPdf2=10;
//$flgPdf2=0;
while ($caddes > 0) {
$datad[] = substr($descp, $inid, $find);
$inid = $inid + 126;
$find = $find;
$caddes = $caddes - 126;
$linePdf2 = $linePdf2 + 1;
}
//AGREGAR LAS HOJAS QUE SEAN NECESARIAS PARA IMPRIMIR TODOS LOS CONTENEDORES
foreach ($datad as $line) {
$conta = $conta + 1;
$contaLine = $contaLine + 1;
$pdf->SetFont('Courier', 'B', 7);
$pdf->Text(5, $rowPdf2, $contaLine);
$pdf->Text(10, $rowPdf2, $line);
$rowPdf2 = $rowPdf2 + 3;
unset($datad);
if ($conta == 92) {
$conta = "";
// ENCABEZADO
$pdf->AddPage();
$pdf->Image('../images/msc.jpg', 8, 1, 15);
$pdf->Image('../images/mscblackF.jpg', 25, 80, 150);
$pdf->SetFont('Courier', 'B', 10);
$pdf->Text(75, 12, "ANEXO DE CONTENEDORES");
$pdf->SetFont('Arial', 'B', 12);
$pdf->Text(35, 7, "MEDITERRANEAN SHIPPING COMPANY MEXICO, S.A. DE C.V.");
$pdf->SetFont('Arial', 'B', 9);
$pdf->Text(165, 12, "FACTURA : {$numFactura}");
//LINEA HORIZONTAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 17, 205, 17);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 205, 2);
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 295, 205, 295);
//LINEA VERTICAL
$pdf->SetLineWidth(0.5);
$pdf->Line(5, 2, 5, 295);
$pdf->SetLineWidth(0.5);
$pdf->Line(205.5, 2, 205.5, 295);
$rowPdf2 = 20;
}
}
}
$pdf->Output();
}
$navs = oci_fetch_row($querynav);
$nav_amount = $navs[1];
//{}{}{}{}{}{}{}{}}{}{}{}{}{}{}{}{}}}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{
$comp = "SELECT COMPANY_NAME, TEL, EMAIL,WEBSITE, ADDRESS,FAX from Company";
$QryCompany = oci_parse($conn, $comp);
oci_execute($QryCompany);
while ($Companydet = oci_fetch_row($QryCompany)) {
$compname = $Companydet[0];
$comptel = $Companydet[1];
$compemail = $Companydet[2];
$compweb = $Companydet[3];
$compadd = $Companydet[4];
$compfax = $Companydet[5];
}
//{}{}{}{}{}{}{}{}}{}{}{}{}{}{}{}{}}}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{
$sql = "SELECT * FROM TRANS WHERE ACCOUNT_NO='{$accno}' AND CONFIRMED IS NOT NULL AND DELETED IS NULL AND REVERSED IS NULL order by trans_id, TRANS_DATE asc";
$querytrans = oci_parse($conn, $sql);
oci_execute($querytrans);
}
$statement = new FPDF();
$statement->Open();
$statement->AddPage('L', 'a4');
$statement->Image('../images/logo.png', 10, 8, 80);
$statement->Ln();
$statement->SetFont('Times', '', 10);
$statement->Cell(170);
$statement->Cell(170, 05, 'P.O Box: ' . $compadd, 'R');
$statement->Ln();
$statement->Cell(170);
$statement->Cell(170, 06, 'Fax : ' . $compfax, 'R');
$statement->Ln();
<?php
include "../../libraries/tcpdf/font/times.php";
//fpdf
$this->load->library('fpdf');
//fpdf
$nombre = "";
$fpdf = new FPDF();
ob_end_clean();
//inicializa pagina pdf
$fpdf->Open();
$fpdf->AddPage();
$fpdf->SetAuthor("codigoweblibre.comli.co - codigoweblibre.wordpress.com", true);
$fpdf->SetCreator("codigoweblibre.comli.co - codigoweblibre.wordpress.com", true);
//Cabecera
$fpdf->SetFont('Arial', 'B', 12);
$fpdf->SetTextColor("0", "8", "8");
//rojo
//$fpdf->Image(base_url() . 'img/User.png', 10, 10, -100);
$fpdf->SetFontSize(10);
$fpdf->Image('imagenes/banner.png', 8, 10, 192, 22, 'PNG');
$fpdf->Cell(100, 30, ' ', 0, 1, 'C');
$fpdf->Image('imagenes/bandera2.png', 8, 35, 192, 1, 'PNG');
$fpdf->Cell(0, 6, 'UNIDAD EJECUTORA DE TITULACION', 0, 1, 'C');
$fpdf->Cell(0, 6, 'DEL MINISTERIO DE OBRAS PUBLICAS, SERVICIOS Y VIVIENDA', 0, 1, 'C');
$fpdf->SetFont('Arial', 'BU', 10);
$fpdf->Cell(0, 3, '', 0, 1, 'C');
$fpdf->Cell(0, 6, 'REPORTE DE PERSONAL POR FECHA DE MODIFICACION', 0, 1, 'C');
$fpdf->Ln();
$fpdf->SetFont('Arial', 'B', 10);
$fpdf->Cell(45, 7, "Nombre ", 1);
// Variaveis de Tamanho
$mesq = "5";
// Margem Esquerda (mm)
$mdir = "5";
// Margem Direita (mm)
$msup = "12";
// Margem Superior (mm)
$leti = "72";
// Largura da Etiqueta (mm)
$aeti = "27";
// Altura da Etiqueta (mm)
$ehet = "3,2";
// Espaço horizontal entre as Etiquetas (mm)
$pdf = new FPDF('P', 'mm', 'Letter');
// Cria um arquivo novo tipo carta, na
vertical . $pdf->Open();
// inicia documento
$pdf->AddPage();
// adiciona a primeira pagina
$pdf->SetMargins('5', '12,7');
// Define as margens do documento
$pdf->SetAuthor("Jonas Ferreira");
// Define o autor
$pdf->SetFont('helvetica', '', 7);
// Define a fonte
$pdf->SetDisplayMode($zoom, $layout = 'continuous');
$coluna = 0;
$linha = 0;
//MONTA A ARRAY PARA ETIQUETAS
while ($dados = mysql_fetch_array($busca)) {
$nome = $dados["nomefantasia"];
/**
* @return void
* @param string $numero_processo
*/
public function generateFolhaDespachoProcesso($numero_processo)
{
define("FPDF_FONTPATH", "bibliotecas/fpdf/font/");
include "bibliotecas/fpdf/fpdf.php";
$stmt = Controlador::getInstance()->getConnection()->connection->prepare("SELECT PC.NUMERO_PROCESSO, PC.DT_AUTUACAO AS AUTUACAO, TB_PROCESSOS_INTERESSADOS.INTERESSADO,\n TB_PROCESSOS_INTERESSADOS.CNPJ_CPF as CNPJ_CPF, PA.ASSUNTO\n FROM TB_PROCESSOS_CADASTRO PC INNER JOIN TB_PROCESSOS_ASSUNTO PA ON PA.ID = PC.ASSUNTO\n INNER JOIN TB_PROCESSOS_INTERESSADOS ON TB_PROCESSOS_INTERESSADOS.ID = PC.INTERESSADO\n WHERE PC.NUMERO_PROCESSO = ? LIMIT 1");
$stmt->bindParam(1, $numero_processo, PDO::PARAM_STR);
$stmt->execute();
$processo = $stmt->fetch(PDO::FETCH_ASSOC);
if (empty($processo)) {
print 'Processo não encontrado!';
return;
}
$pdf = new FPDF();
$pdf->Open();
$pdf->AddPage();
$pdf->SetFont("Arial", '', 10);
$pdf->Image("imagens/" . __LOGO_JPG__, 95, 8, 20, 20);
$pdf->Ln(2);
$pdf->Cell(185, 8, "Folha de Despachos", 0, 0, 'R');
$pdf->Ln(20);
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->SetFont("Arial", "B", 10);
$pdf->Cell(180, 5, utf8_decode(__CABECALHO_ORGAO__), 0, 0, 'C');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->Cell(180, 5, '', 0, 0, 'R');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(180, 5, utf8_decode("Informações do Processo"), 0, 0, 'C');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(35, 5, utf8_decode("Número do Processo:"), 0, 0, 'L');
$pdf->SetFont("Arial", '', 9);
$pdf->Cell(90, 5, $numero_processo, 0, 0, 'L');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(30, 5, utf8_decode("Data da Autuação:"), 0, 0, 'L');
$pdf->SetFont("Arial", '', 9);
$pdf->Cell(25, 5, Util::formatDate($processo['AUTUACAO']), 0, 0, 'L');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(20, 5, "Interessado:", 0, 0, 'L');
$pdf->SetFont("Arial", '', 9);
$pdf->Cell(160, 5, utf8_decode($processo['INTERESSADO']), 0, 0, 'L');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->Cell(15, 5, "Assunto:", 0, 0, 'L');
$pdf->SetFont("Arial", '', 9);
$pdf->Cell(165, 5, utf8_decode($processo['ASSUNTO']), 0, 0, 'L');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->SetFont("Arial", "B", 9);
$pdf->Cell(180, 5, "Despachos", 0, 0, 'C');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->Cell(5, 5, '', 0, 0, 'C');
$pdf->Cell(180, 5, '', 0, 0, 'C');
$pdf->Cell(5, 5, '', 0, 1, 'L');
$pdf->SetFont("Arial", '', 7);
$pdf->Cell(5, 64, "1", 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(5, 64, "2", 1, 1, 'C');
$pdf->SetFont("Arial", '', 7);
$pdf->Cell(5, 64, "3", 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(5, 64, "4", 1, 1, 'C');
$pdf->SetFont("Arial", '', 7);
$pdf->Cell(5, 64, "5", 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(90, 64, '', 1, 0, 'C');
$pdf->Cell(5, 64, "6", 1, 1, 'C');
$pdf->Output("bibliotecas/fpdf", "i");
}
public function create5160MailingLabelFile($results, $name = "dummy_")
{
$name .= date("M_d_Y") . ".pdf";
$fpdf = new FPDF();
$fpdf->Open();
$fpdf->AddPage();
$fpdf->SetFont('Arial', 'B', 10);
$fpdf->SetMargins(0, 0);
$fpdf->SetAutoPageBreak(false);
$x = 0;
$y = 0;
// create the array of the ids want to query the database for addresses
foreach ($results as $student) {
$st = new PSUPerson($student['spriden_id'], array('address'));
$LabelText = sprintf("%s\n%s\n%s, %s, %s", $student['spriden_last_name'] . ", " . $student['spriden_first_name'] . " " . $student['spriden_mi'], $st->address['CA'][0]->street_line1, $st->address['CA'][0]->city, $st->address['CA'][0]->stat_code, $st->address['CA'][0]->zip);
$this->Avery5160($x, $y, $fpdf, $LabelText);
$y++;
// next row
if ($y == 10) {
// end of page wrap to next column
$x++;
$y = 0;
if ($x == 3) {
// end of page
$x = 0;
$y = 0;
$fpdf->AddPage();
}
}
$st->destroy();
}
echo $fpdf->Output($name, $destination = 'd');
}
private static function createPDF($text)
{
if (Config::get('pdf_font', false) !== false) {
Config::setRunningConfig('pdf_font', 'Arial');
Config::setRunningConfig('pdf_fontsize', 12);
}
$pdf = new FPDF();
$pdf->SetCreator('PHPlist version ' . PHPLIST_VERSION);
$pdf->Open();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont(Config::get('pdf_font'), Config::get('pdf_fontstyle'), Config::get('pdf_fontsize'));
$pdf->Write((int) Config::get('pdf_fontsize') / 2, $text);
$fname = tempnam(Config::get('tmpdir'), 'pdf');
$pdf->Output($fname, false);
return $fname;
}
<?php
define('FPDF_FONTPATH', '../font/');
require '../fpdf.php';
$pdf = new FPDF();
$pdf->Open();
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 16);
$pdf->Cell(40, 10, 'Hello World!');
$pdf->Output();
function genSalon()
{
global $options;
# paramètres
$mg = 5;
// Marge de gauche => initial 17
$mh = 4;
// Marge du haut => initial 9
$md = 15;
// Marge de droite
$mb = 9;
// Marge du bas
$largeur_etiquette = 42;
// largeur_etiquette => initial 60
$espace_etiquettes = 13;
// => initial 7
$nb_ligne_etiquettes = 4;
$nb_etiquette_ligne = 5;
// Préparation du document PDF.
$pdf = new FPDF('L', 'mm', 'A4');
$pdf->Open();
$pdf->SetLeftMargin($mg);
$pdf->SetTopMargin($mh);
$pdf->SetAutoPageBreak(1, 0);
$pdf->AddPage();
// Gestion des fonts
$pdf->AddFont('code39', '', 'IDAutomation_Code_39.php');
$pdf->SetFont('times', '', 12);
// Préparation des informations.
$nom = strtoupper($this->patient->getNom());
$prenom = strtoupper($this->patient->getPrenom());
$date = new clDate($this->patient->getDateNaissance());
$duree = new clDuree();
$dateN = $date->getDate("d/m/Y");
$dateN .= " (" . $duree->getAge($date->getTimestamp()) . ")";
if ($this->patient->getSexe() == "F") {
$sexe = "Féminin";
$e = "e";
} elseif ($this->patient->getSexe() == "M") {
$sexe = "Masculin";
$e = "";
} else {
$sexe = "Indéterminé";
$e = "";
}
$date->setDate($this->patient->getDateAdmission());
$le = $date->getDate("d/m/Y H:i");
$led = $date->getDate("d/m/Y");
$leh = $date->getDate("H:i");
$ipp = $this->patient->getILP();
$nsej = $this->patient->getNSej();
$uf = $this->patient->getUF();
$sexe = $this->patient->getSexe();
if ($uf == $options->getOption('numUFexec')) {
$loc = '(URGENCES)';
} else {
$loc = '(UHCD)';
}
$tel = $this->patient->getTel();
$adresse = $this->patient->getAdresse();
$cpv = $this->patient->getCodePostal() . " " . $this->patient->getVille();
$prev = $this->patient->getPrevenir();
$medt = $this->patient->getMedecinTraitant();
$modet = $this->patient->getMedecinTraitant();
$adresseur = $this->patient->getAdresseur();
$modeadm = $this->patient->getModeAdmission();
// Grosse étiquette
$pdf->Cell(20, 4, "", 0, 0, L);
// Ligne 1
$pdf->Cell(4 * $largeur_etiquette, 5, "CENTRE HOSPITALIER DE CARPENTRAS", 0, 1, L);
// Ligne 2
$pdf->Cell(11, 5, "Date : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(23, 5, "{$led}", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(13, 5, "Heure : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(27, 5, "{$leh}", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(21, 5, "N° Patient : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(22, 5, "{$ipp}", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(18, 5, "N° URG : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(22, 5, "{$nsej}", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(18, 5, "N° ARCHIVE : ", 0, 1, L);
// Ligne 3
$pdf->Cell(11, 5, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(63, 5, strtoupper($nom), 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(13, 5, "Nom naissance : ", 0, 1, L);
// Ligne 4
$pdf->Cell(16, 5, "Prénom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(58, 5, ucfirst(strtolower($prenom)), 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(12, 5, "Sexe : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(29, 5, "{$sexe}", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(12, 5, "N° S.S : ", 0, 1, L);
// Ligne 5
$pdf->Cell(17, 5, "Né(e) le : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(57, 5, $dateN, 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(12, 5, "A : ", 0, 1, L);
// Ligne 6
$pdf->Cell(17, 4, "Adresse : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(57, 4, $adresse, 0, 1, L);
$pdf->SetFont('times', '', 12);
// Ligne 5
$pdf->Cell(115, 4, "", 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(9, 4, "Tél : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(20, 4, $tel, 0, 1, L);
$pdf->SetFont('times', '', 12);
// Ligne 6
$pdf->Cell(17, 4, "", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(98, 4, $cpv, 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(9, 4, "Pays : ", 0, 1, L);
// Ligne 7
$pdf->Cell(17, 5, "Nom du tuteur : ", 0, 1, L);
// Ligne 8
$pdf->Cell(37, 5, "Personne à prévenir : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(98, 5, $prev, 0, 1, L);
$pdf->SetFont('times', '', 12);
// Ligne 9
$pdf->Cell(23, 5, "Adressé par : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(51, 5, $adresseur, 0, 0, L);
$pdf->SetFont('times', '', 12);
$pdf->Cell(30, 5, "Médecin traitant : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(98, 5, $medt, 0, 1, L);
$pdf->SetFont('times', '', 12);
// Ligne 10
$pdf->Cell(34, 5, "Mode de transport : ", 0, 0, L);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(98, 5, $modeadm, 0, 1, L);
$pdf->SetFont('times', '', 12);
// Saut
$pdf->Cell(1, 5.8, "", 0, 1);
$pdf->SetFont('times', '', 9);
for ($i = 1; $i <= $nb_ligne_etiquettes; $i++) {
// Entrée
$pdf->Cell($largeur_etiquette, 4, "Entrée du : {$led} à {$leh}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Entrée du : {$led} à {$leh}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Entrée du : {$led} à {$leh}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Entrée du : {$led} à {$leh}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Entrée du : {$led} à {$leh}", 0, 1, L);
// D/Nais
$pdf->Cell($largeur_etiquette, 4, "D/nais : {$dateN}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "D/nais : {$dateN}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "D/nais : {$dateN}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "D/nais : {$dateN}", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "D/nais : {$dateN}", 0, 1, L);
// Nom
$pdf->Cell($largeur_etiquette - 30, 4, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 9);
$pdf->Cell(43, 4, strtoupper($nom), 0, 0, L);
$pdf->SetFont('times', '', 9);
$pdf->Cell($largeur_etiquette - 30, 4, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 9);
$pdf->Cell(43, 4, strtoupper($nom), 0, 0, L);
$pdf->SetFont('times', '', 9);
$pdf->Cell($largeur_etiquette - 30, 4, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 9);
$pdf->Cell(43, 4, strtoupper($nom), 0, 0, L);
$pdf->SetFont('times', '', 9);
$pdf->Cell($largeur_etiquette - 30, 4, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 9);
$pdf->Cell(43, 4, strtoupper($nom), 0, 0, L);
$pdf->SetFont('times', '', 9);
$pdf->Cell($largeur_etiquette - 30, 4, "Nom : ", 0, 0, L);
$pdf->SetFont('times', 'B', 9);
$pdf->Cell(43, 4, strtoupper($nom), 0, 1, L);
$pdf->SetFont('times', '', 9);
// Prénom
$pdf->Cell($largeur_etiquette, 4, "Prénom : " . ucfirst(strtolower($prenom)), 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Prénom : " . ucfirst(strtolower($prenom)), 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Prénom : " . ucfirst(strtolower($prenom)), 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Prénom : " . ucfirst(strtolower($prenom)), 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "Prénom : " . ucfirst(strtolower($prenom)), 0, 1, L);
// NJF
$pdf->Cell($largeur_etiquette, 4, "NJF : ", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "NJF : ", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "NJF : ", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "NJF : ", 0, 0, L);
$pdf->Cell($espace_etiquettes, 4, "", 0, 0, L);
$pdf->Cell($largeur_etiquette, 4, "NJF : ", 0, 1, L);
// N° SS
$pdf->Cell(9, 4, "NSej : ", 0, 0, L);
$pdf->Cell(46, 4, "{$nsej}", 0, 0, L);
$pdf->Cell(9, 4, "NSej : ", 0, 0, L);
$pdf->Cell(46, 4, "{$nsej}", 0, 0, L);
$pdf->Cell(9, 4, "NSej : ", 0, 0, L);
$pdf->Cell(46, 4, "{$nsej}", 0, 0, L);
$pdf->Cell(9, 4, "NSej : ", 0, 0, L);
$pdf->Cell(46, 4, "{$nsej}", 0, 0, L);
$pdf->Cell(9, 4, "NSej : ", 0, 0, L);
$pdf->Cell(46, 4, "{$nsej}", 0, 1, L);
// inter _etiquettes
$pdf->Cell(1, 11, "", 0, 1);
}
$pdf->Output();
}
/**
* @param mixed $id The entity id
* @Template() *
* @Route("/etatfinancier", name="etatfinancier")
*/
public function etatFinancierAction()
{
$date = new \DateTime();
$etatfinancier = $this->get("alb_inscriptions.alb_manager")->getEtatFinancierApplication();
$nomfichier = 'tresorerie/EF_' . $date->format('YmdHis') . '.pdf';
$pdf = new \FPDF();
$pdf->Open();
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 20);
$pdf->Cell(0, 8, utf8_decode('Amicale Laïque de Billère'), 0, 1, 'C');
$pdf->ln(4);
$pdf->SetFont('Arial', '', 16);
$pdf->Cell(0, 8, utf8_decode('Etat financier au ' . $date->format('d/m/Y')), 0, 1);
$pdf->ln(4);
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(5, 4, '', 1, 0, 'C');
$pdf->Cell(45, 4, utf8_decode('Nom'), 1, 0, 'C');
$pdf->Cell(31, 4, utf8_decode('Prénom'), 1, 0, 'C');
$pdf->Cell(15, 4, utf8_decode('Montant'), 1, 1, 'C');
$i = 0;
$total = 0;
foreach ($etatfinancier as $etatfinancier0) {
foreach ($etatfinancier0 as $etat) {
if ($etat['montant'] != 0) {
$i++;
$total = $total + $etat['montant'];
$pdf->Cell(5, 4, $i, 1, 0, 'C');
$pdf->Cell(45, 4, utf8_decode($etat['nom']), 1, 0, '');
$pdf->Cell(31, 4, utf8_decode($etat['prenom']), 1, 0, '');
$pdf->Cell(15, 4, number_format($etat['montant'], 2, ',', ' '), 1, 1, 'R');
}
}
}
$pdf->ln(4);
$pdf->SetFont('Arial', '', 9);
$pdf->Cell(45, 6, utf8_decode('Total : '), 0, 0, 'R');
$pdf->Cell(20, 6, number_format($total, 2, ',', ' '), 0, 1, 'R');
$pdf->Output($nomfichier, 'F');
$response = new Response();
$response->setContent(file_get_contents($nomfichier));
$response->headers->set('Content-Type', 'application/force-download');
$response->headers->set('Content-disposition', 'filename=' . $nomfichier);
return $response;
}
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);
$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);
$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);
$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);
if ($entSal == "E") {
$entF = $db->f('fec_ent');
$entH = $db->f('hora');
$entM = $db->f('minuto');
}
if ($entSal == "S") {
$salF = $db->f('sal_f');
$salH = $db->f('sal_h');
$salM = $db->f('sal_m');
}
}
$pdf = new FPDF();
$pdf->Open();
$pdf->SetMargins(20, 20, 20);
$pdf->AddPage();
//$pdf->Image('../images/logoPdf.jpg',75,15,15);
// EIR
$pdf->SetFont('Courier', '', 8);
$pdf->Text(20, 30, "REF. {$entSal} {$idReg}");
// Cliente
$pdf->Text(10, 40, "{$cliente}");
// Conte
$pdf->Text(60, 40, $conteP1);
$pdf->Text(80, 40, $conteP2);
$pdf->Text(120, 40, $equipo);
// Entregado por
$pdf->Text(10, 50, $naviera);
$pdf->Text(60, 50, "{$entF} {$entH}:{$entM}");
$pdf->Text(100, 50, "BKG. {$bkg}");
$pdf->Text(140, 50, "{$salF} {$salH}:{$salM}");
// Transportista
$entSal == "E" ? $pdf->Text(10, 60, $transp) : $pdf->Text(110, 60, $transp);
// Operador y Placas
$entSal == "E" ? $pdf->Text(10, 70, $operador) : $pdf->Text(110, 70, $operador);
$entSal == "E" ? $pdf->Text(50, 70, $placas) : $pdf->Text(160, 70, $placas);
$entSal == "E" ? $pdf->Text(20, 80, "CLASE :{$clase}") : $pdf->Text(120, 80, "CLASE : {$clase}");
$entSal == "E" ? $pdf->Text(50, 80, $damage) : $pdf->Text(160, 80, $damage);
$pdf->Text(130, 90, "NO. DE SELLO : {$sello}");
$nota = str_replace("\n", "\r", $nota);
$pdf->Text(110, 270, $nota);
//$pdf->Ln(70);
//$pdf->MultiCell(100,190,$nota,0,'L');
// finalizar el documento pdf
$pdf->Output();
}
function geraCertificado($Data, $NomeAluno, $Evento, $orador, $CargaHoraria, $organizadorEvento, $caminhoServidor)
{
//CRIA O PDF
$pdf = new FPDF();
$pdf->SetTitle('Certificado de ' . utf8_decode($NomeAluno));
// ABRE O PDF PARA EDIÇÃO
$pdf->Open();
// ADICIONA UMA PÁGINA AO ARQUIVO
$pdf->AddPage('L', 'A4');
$pdf->AddFont('Century', '', 'Century.php');
// ADICIONA IMAGEM (CABEÇALHO)
$pdf->Image('resources/images/header.png', 0, 5);
$pdf->SetY(67);
$pdf->SetX(20);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Century', '', 18);
if ($orador != "") {
$pdf->MultiCell(220, 10, utf8_decode("Certifico para os devidos fins que {$NomeAluno} participou, como ouvinte, do evento \"{$Evento}\" apresentado por \"{$orador}\" organizado pelo(a) {$organizadorEvento}, {$Data} com carga horária de {$CargaHoraria} horas."), 0, "J", false);
} else {
$pdf->MultiCell(220, 10, utf8_decode("Certifico para os devidos fins que {$NomeAluno} participou, como ouvinte, do evento \"{$Evento}\" organizado pelo(a) {$organizadorEvento}, {$Data} com carga horária de {$CargaHoraria} horas."), 0, "J", false);
}
//ADICIONA A ASSINATURA
$pdf->Image('resources/images/assinaturaFulano.gif', 125, 130, 43, 16);
//NOME DO ASSINANTE
$pdf->SetFont('Century', '', 12);
$pdf->SetY(157);
$pdf->SetX(73);
$pdf->Cell(145, 0, 'Sr. Fulano da Silva', 0, 0, 'C');
//TITULO OU FUNCAO DO ASSINANTE
$pdf->ln(7);
$pdf->SetX(73);
$pdf->Cell(145, 0, utf8_decode("Título/Função de Fulano da Silva"), 0, 0, 'C');
//ENDEREÇO DO LOCAL A DESEJAR
$pdf->SetY(175);
$pdf->ln(4);
$pdf->SetX(73);
$pdf->Cell(145, 0, utf8_decode("Avenida Meu Endereço, São Paulo - SP"), 0, 0, 'C');
//RODAPE COM DEMAIS INFORMACOES
$pdf->ln(7);
$pdf->SetX(73);
$pdf->Cell(145, 0, '(11) 5555-5555 - www.seusite.com.br', 0, 0, 'C');
//GERA O ARQUIVO PDF COM O NOME DO ALUNO E SALVA NO SERVIDOR EM PASTA ESPECIFICA DO EVENTO
$NomeAlunoSemAcent = remove_acentuacao($NomeAluno, true);
$EventoSemAcent = remove_acentuacao($Evento, true);
$pdf->Output($caminhoServidor . "/{$EventoSemAcent}/" . $NomeAlunoSemAcent . ".pdf", "F");
}
/**
* valida email
* @param string $email
*/
public function geraProcessosDetran($orgao, $resultado, $anexar, $id_empresa, $id_usuario, $id_pedido, $ordem, $res_oficio)
{
if ($orgao == '') {
$orgao = 'Detran';
}
if ($resultado == '') {
$resultado = 'Nada Constou';
}
// Variaveis de Tamanho
$mesq = "10";
// Margem Esquerda (mm)
$msup = "10";
// Margem Superior (mm) margem mínima dois pois ficou cortando)
/*Uma dica: estes tamanhos você pode verificar com uma régua ou na própria caixa da etiqueta, seja bem preciso e sugiro que faça o teste na impressora que vai ser utilizada, pois pode acontecer de na impressão começar a subir ou descer, portanto, você deverá aumentar ou diminuir a altura da etiqueta.
*/
$m = date(m);
$mes = traduzMes($m);
$anexoDAO = new AnexoDAO();
$impressoDAO = new ImpressoDAO();
$atividadeDAO = new AtividadeDAO();
$res = $impressoDAO->buscaPorId(28);
$imprimir_topo = $res->topo;
$id_impresso = $res->id_impresso;
$imprimir_timbre = $res->timbre;
$imprimir_sub = $res->sub;
$imprimir_linha = $res->linhas;
$frase = '';
#if($anexar!='on'){
$pdf = new FPDF('P', 'cm', 'A4');
//papel personalizado
$pdf->Open();
$pdf->SetMargins(1, 2);
//seta as margens do documento
$pdf->SetAuthor('Softfox 2011');
$pdf->SetFont('times', '', 7);
$pdf->SetDisplayMode(100, 'continuous');
//define o nivel de zoom do documento PDF
$coluna = 0;
$linha = 0;
$posicaoH = 0;
$posicaoV = 0;
#}
$impressao_ordem = '';
$linha = 0;
$frase .= $imprimir_topo;
$bloco = '';
if ($res_oficio->id_pedido != '') {
$linha_bloco = 1;
$orgao_regiao = $res_oficio->certidao_cidade;
$orgao_regiao .= '-' . $res_oficio->certidao_estado;
$impressao_ordem = '#' . $res_oficio->id_pedido . '/' . $res_oficio->ordem . ' ';
$responsavel_endereco = $res_oficio->endereco . ' ' . $res_oficio->numero . ' ' . $res_oficio->complemento;
$data_atual = $res_oficio->cidade . ', ' . date(d) . ' de ' . $mes . ' de 20' . date(y) . '.';
$topo = str_replace('<certidao_nome>', $res_oficio->certidao_nome, $imprimir_topo);
$topo = str_replace('<certidao_cnpj>', $res_oficio->certidao_cnpj, $topo);
$topo = str_replace('<certidao_cpf>', $res_oficio->certidao_cpf, $topo);
$topo = str_replace('<orgao>', $orgao, $topo);
$topo = str_replace("<resultado>", $resultado, $topo);
$topo = str_replace("<orgao_regiao>", $orgao_regiao, $topo);
$topo = str_replace('<responsavel_empresa>', $res_oficio->fantasia, $topo);
$topo = str_replace('<responsavel_endereco>', $responsavel_endereco, $topo);
$topo = str_replace('<responsavel_cidade>', $res_oficio->cidade, $topo);
$topo = str_replace('<responsavel_estado>', $res_oficio->estado, $topo);
$topo = str_replace("<data>", $data_atual, $topo);
$topo = str_replace('<impressao_ordem>', $impressao_ordem, $topo);
$sub = str_replace('<responsavel_empresa>', $res_oficio->fantasia, $imprimir_sub);
$sub = str_replace('<responsavel_endereco>', $responsavel_endereco, $sub);
$sub = str_replace('<responsavel_cidade>', $res_oficio->cidade, $sub);
$sub = str_replace('<responsavel_estado>', $res_oficio->estado, $sub);
$sub = str_replace('<responsavel_cep>', $res_oficio->cep, $sub);
$sub = str_replace('<responsavel_tel>', $res_oficio->tel, $sub);
$sub = str_replace('<responsavel_fax>', $res_oficio->fax, $sub);
$sub = str_replace('<responsavel_email>', $res_oficio->email, $sub);
$pdf->AddPage();
$pdf->Image('../images/header.jpg', '0', '0', '19', '3,04', 'JPG');
$pdf->SetFont('', 'B', 12);
$pdf->Cell('', 2, 'NÃO EMITIMOS E NEM VENDEMOS CERTIDÕES E SIM PRAZOS E SOLUÇÕES', '', 1, 'C');
$pdf->SetFont('', 'B', 14);
$pdf->Cell('', 2, 'Declaração de Busca', '', 1, 'C');
$pdf->SetFont('', '', 12);
$pdf->Write(1, $topo, '');
$pdf->SetFont('', '', 12);
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, '', '', 1, 'C');
$pdf->Cell('', 1, $data_atual, '', 1, 'C');
$pdf->Cell('', 1, $impressao_ordem, '', 1, 'R');
$pdf->ln();
$pdf->ln();
$pdf->ln();
$pdf->ln();
$pdf->Cell('', 1, $res_oficio->fantasia, '', 1, 'C');
$pdf->ln();
$pdf->ln();
$pdf->Write(0.5, $sub, '');
$pdf->Line(1, 25, 20, 25);
$pdf->Ln();
$pdf->Cell('', 0.5, $rodape, '', 1, 'C');
$rodape = $responsavel_endereco . ', ' . $res_oficio->cidade . '-' . $res_oficio->estado . ' CEP: ' . $res_oficio->cep;
$pdf->Cell('', 0.5, $rodape, '', 1, 'C');
$rodape = 'Tel/Fax: ' . $res_oficio->tel . '/' . $res_oficio->fax . ' E-mail:' . $res_oficio->email;
$pdf->Cell('', 0.5, $rodape, '', 1, 'C');
$rodape = 'www.cartoriopostal.com.br';
$pdf->Cell('', 0.5, $rodape, '', 1, 'C');
if ($anexar == 'on' and $res_oficio->id_servico == '16') {
$pdf->Close();
//imprime a saida
$num_a = $anexoDAO->listaAnexoPedidoNome($res_oficio->id_pedido_item, 'Declaração de Busca');
if (COUNT($num_a) == 0) {
$file_path = "../anexosnovos/" . date('m') . '' . date('Y') . '/';
#alterado => "../anexos/"
if (!is_dir($file_path)) {
mkdir($file_path, 0777);
}
#alterado
$arq_anexo = $file_path . 'decla_busca_' . $res_oficio->id_pedido_item . '_' . time() . '.pdf';
$pdf->Output($arq_anexo, 'F');
//imprime a saida
$anexo->anexo = $arq_anexo;
$anexo->anexo_nome = 'Declaração de Busca';
$anexo->id_pedido_item = $res_oficio->id_pedido_item;
$anexo->id_usuario = $id_usuario;
$anexoDAO->inserir($anexo);
$ativ = $atividadeDAO->inserir('209', '', $id_usuario, $res_oficio->id_pedido_item);
return 'Declaração anexada para ' . $impressao_ordem . '<br>';
} else {
return 'Declaração não pode ser anexada para ' . $impressao_ordem . ' porque o anexo já existe<br>';
}
} else {
if ($anexar == 'on' and $res_oficio->id_servico != '16') {
return '<b>Declaração não pode ser anexada para ' . $impressao_ordem . ' porque o serviço não é "Pesquisa Detran</b>"<br>';
}
}
}
if ($anexar != 'on') {
return $pdf->Output();
//imprime a saida
} else {
return 1;
}
}
