0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
$i--; $j--;
}
if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1))."/main.inc.php")) {
$res = @include substr($tmp, 0, ($i + 1))."/main.inc.php";
}
if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php")) {
$res = @include dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php";
}
// Try main.inc.php using relative path
if (!$res && file_exists("../main.inc.php")) {
$res = @include "../main.inc.php";
}
if (!$res && file_exists("../../main.inc.php")) {
$res = @include "../../main.inc.php";
}
if (!$res && file_exists("../../../main.inc.php")) {
$res = @include "../../../main.inc.php";
}
if (!$res) {
die("Include of main fails");
}
require_once(DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php');
require_once(DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php');
require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
// Se incluye la libreria FPDF.
dol_include_once("/cfdimx/class/facturacfdimx.class.php");
dol_include_once('/cfdimx/lib/fpdf/fpdf.php');
dol_include_once('/cfdimx/lib/numero_a_letra.php');
dol_include_once('/cfdimx/lib/phpqrcode/qrlib.php');
$id = (GETPOST('id') != "") ? GETPOST('id') : GETPOST('facid');
$route = GETPOST('route');
global $conf, $langs, $db;
$langs->load("bills");
class cfdiPDF extends FPDF
{
var $widths;
var $aligns;
var $data;
var $emisor;
var $receptor;
var $datoscomprobante;
var $pago_id;
var $factura_id;
public function limpiar($cadena){
$cadena = str_replace("á","á",$cadena);
$cadena = str_replace("Á","Á",$cadena);
$cadena = str_replace("é","é",$cadena);
$cadena = str_replace("É","É",$cadena);
$cadena = str_replace("í","í",$cadena);
$cadena = str_replace("Í","Í",$cadena);
$cadena = str_replace("ó","ó",$cadena);
$cadena = str_replace("Ó","Ó",$cadena);
$cadena = str_replace("ú","ú",$cadena);
$cadena = str_replace("Ú","Ú",$cadena);
return $cadena;
}
function SetData($id) {
global $db, $conf, $langs;
$langs->load('main');
// $query = 'SELECT * FROM '.MAIN_DB_PREFIX.'cfdimx WHERE fk_facture='.$id.' AND entity_id='.$conf->entity;
// $resql = $db->query($query);
// if($db->num_rows($resql) > 0){
// while ($obj = $db->fetch_object($resql)) {
$datos["version"] = $conf->global->CFDIMX_VERSION_SAT;
$datos["uuid"] = 'XXXXX-XXXXXX-XXXXXXX-XXXXXX';
$datos["moneda"] = 'XXX';
$datos["cadena"] = '$obj->cadena';
$datos["selloCFD"] = '0000000000000000000';
$datos["selloSAT"] = '0000000000000000000';
$datos["fechaTimbrado"] = 'yyyy-mm-ddT00:00:00';
$datos["certificado"] = '0000000000000000000';
$datos["certEmisor"] = '0000000000000000000';
$datos["u4dig"] = '0000000000000000000';
$datos["fechaEmision"] = 'yyyy-mm-ddT00:00:00';
$datos["coccds"] = "||1.1|".$datos["uuid"]."|".$datos["fechaTimbrado"]."|".$datos["selloCFD"]."|".$datos["certificado"]."||";
#Nuevos Campos para CFDI 4.0
$datos["rfc"] = "";
$datos["usocfdi"] = "";
$datos["nombre"] = "";
$datos["codigopostal"] = "";
$datos["regimenfiscal"] = "";
// }
// }
$this->data = $datos;
//Informacion Emisor
$sql_direccion = 'SELECT rowid, emisor_calle, emisor_noext, emisor_noint, emisor_colonia, emisor_delompio, codigo_postal, pais, estado FROM '.MAIN_DB_PREFIX.'cfdimx_emisor_datacomp WHERE emisor_rfc="'.$conf->global->MAIN_INFO_SIREN.'" AND entity_id = '.$conf->entity;
$res_direccion = $db->query($sql_direccion);
while ($res_dir = $db->fetch_object($res_direccion)) {
$rfc = utf8_decode($conf->global->MAIN_INFO_SIREN);
// $razon_social = utf8_decode($conf->global->MAIN_INFO_SOCIETE_NOM);
$razon_social = mb_strtoupper(utf8_decode($conf->global->CFDIMX_RAZON_SOCIAL));
$regimen = $conf->global->CFDIMX_REGIMEN_FISCAL;
$label_regimen = $this->_obtener_catalogo($regimen, 1);
$cp = $conf->global->MAIN_INFO_SOCIETE_ZIP;
$separa_pais = explode(":",$conf->global->MAIN_INFO_SOCIETE_COUNTRY);
$pais = utf8_decode($separa_pais[2]);
$separa_estado = explode(':', $conf->global->MAIN_INFO_SOCIETE_STATE);
$state_id = $separa_estado[0];
$estado = utf8_decode(($state_id == 1070) ? "Ciudad de ".getState($separa_estado[0], 2) : getState($separa_estado[0], 2));
$municipio = utf8_decode($res_dir->emisor_delompio);
$calle = utf8_decode($res_dir->emisor_calle);
$colonia = utf8_decode($res_dir->emisor_colonia);
$noint = $res_dir->emisor_noint;
$noext = $res_dir->emisor_noext;
$direccion_pdf = "";
$direccion_pdf .= ($calle != '' ? $calle." " : '');
$direccion_pdf .= ($noint != '' ? $noint." " : '');
$direccion_pdf .= ($noext != '' ? $noext." " : '');
$direccion_pdf .= ($colonia != '' ? $colonia." " : '');
if($conf->global->CFDIMX_DIRECCION != ""){
if(is_numeric($conf->global->CFDIMX_DIRECCION)){
}else{
$direccion_pdf = $conf->global->CFDIMX_DIRECCION;
}
}
$direccion_pdf2 = "";
if($municipio != ''){
$direccion_pdf2 .= $municipio;
}
if($estado != ''){
$direccion_pdf2 .= ($direccion_pdf2 != '' ? ", ".$estado : '');
}
if($pais != ''){
$direccion_pdf2 .= ($direccion_pdf2 != '' ? ", ".$pais : '');
}
if($cp != ''){
$direccion_pdf2 .= ($direccion_pdf2 != '' ? ", CP. ".$cp : '');
}
$informacion_emisor = array(
"emisorRFC" => $rfc,
"emisorRegimen" => $regimen,
"emisorRegimenEtiqueta" => $label_regimen,
"nombre" => $razon_social,
"calle" => $calle,
"colonia" => $colonia,
"noExterior" => $noext,
"noInterior" => $noint,
"municipio" => $municipio,
"estado" => $estado,
"pais" => $pais,
"codigoPostal" => $cp,
"direccion_pdf" => $direccion_pdf,
"direccion_pdf2" => $direccion_pdf2
);
}
$this->emisor = $informacion_emisor;
//Informacion Factura
$factura = new Facture($db);
$factura->fetch($id);
$tipoComprobante = "P";
$observaciones = $factura->note_public;
$moneda = $datos["moneda"];
// $forma_pago = "99";
// $label_formapago = $forma_pago." - Por Definir";
// $sql_head_cartaporte = '';
// $sql_head_cartaporte = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_facture_carta_porte WHERE facid = ".$id." AND entity =".$conf->entity;
// $res_head_cartaporte = $db->query($sql_head_cartaporte);
// $num_head_cartaporte = $db->num_rows($res_head_cartaporte);
// if($num_head_cartaporte > 0){
// $obj_head_cartaporte = $db->fetch_object($res_head_cartaporte);
// // $tipoComprobante = ($obj_head_cartaporte->entrada_salida == 'Entrada' ? 'I' : 'T');
// if($tipoComprobante == 'T'){
// $moneda = "XXX";
// $factura->array_options["options_formpagcfdi"] = "";
// $label_formapago = "";
// $factura->mode_reglement_code = "";
// $factura->cond_reglement_code = "";
// }
// }
// print $factura->mode_reglement_code.'
';
// if($factura->mode_reglement_code != ''){
// $forma_pago = $factura->mode_reglement_code;
// // $forma_pago = "01";
// $label_formapago = $this->_obtener_catalogo($forma_pago, 4002);
// }
##Nuevo catalogo de formas pago
// if(isset($factura->array_options["options_formapago"])){
// if($tipoComprobante != 'T'){
// $label_formapago = $this->_obtener_catalogo($factura->array_options["options_formapago"], 4007);
// }
// }
// $label_condicionpago = $this->_obtener_catalogo($factura->cond_reglement_code, 4003);
// $label_metodopago = "";
// if($factura->array_options["options_formpagcfdi"] != ""){
// if($factura->array_options["options_formpagcfdi"] == 'PUE'){
// $label_metodopago = "PUE - Pago en una sola Exhibición";
// }else{
// $label_metodopago = "PPD - Pago en Parcialidades o Diferido";
// }
// }
$label_usocfdi = $this->_obtener_catalogo($conf->global->CFDIMX_USOCFDI_PAGOS, 2);
// $label_cfditiporelacion = $this->_obtener_catalogo($factura->array_options["options_cfdidoctiporelacion"], 4005);
// $tipoCambio = (isset($factura->array_options["options_tipodecambiocfdi"]) ? $factura->array_options["options_tipodecambiocfdi"] : 0);
#Nuevos Campos para CFDI 4.0
$clave_exportacion = "01";
$label_moneda = "";
if($moneda == "MXN" || $moneda == "USD"){
$label_moneda = "$";
}
$datos_comprobante = array(
"tipoDeComprobante" => $tipoComprobante,
// "formaDePago" => $label_formapago,
// "condicionesDePago" => $label_condicionpago,
// "metodoDePago" => $label_metodopago,
"usoCFDI" => $label_usocfdi,
// "tipoRelacion" => $label_cfditiporelacion,
"moneda" => $moneda,
"label_moneda" => $label_moneda,
// "tipoCambio" => $tipoCambio,
"observaciones" => $observaciones,
"clave_exportacion" => $clave_exportacion,
"version_cfdi" => $datos["version"]
);
$this->datoscomprobante = $datos_comprobante;
// print ''; print_r($datos_comprobante); print '
';
// die;
//Informacion Receptor
$cliente = new Societe($db);
$cliente->fetch($factura->socid);
$rfc_receptor = $cliente->idprof1;
$domicilioReceptor = new FacturaCFDI($db);
$objdomicilioRepcetor = $domicilioReceptor->getDomicilioFiscalCliente($factura->socid, 0);
// print ''; print_r($objdomicilioRepcetor); print '
'; die;
#Campos para CFDI 3.3
if(strcmp($conf->global->CFDIMX_VERSION_SAT, "3.3") == 0){
$nombre_receptor = $cliente->nom;
$cp_receptor = $cliente->zip;
$direccion_receptor_pdf = "";
$direccion_receptor_pdf .= ($cliente->address != '' ? $cliente->address." " : '');
$direccion_receptor_pdf2 = "";
if($cliente->state != ''){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", ".$cliente->state : $cliente->state);
}
if($cliente->country != ''){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", ".$cliente->country : $cliente->country);
}
if($cliente->zip != ''){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", CP. ".$cliente->zip : '');
}
$estado_receptor = $cliente->state;
$pais_receptor = $cliente->country;
$regimen_receptor = "";
}else{
$nombre_receptor = $objdomicilioRepcetor["nombre"];
$cp_receptor = $objdomicilioRepcetor["cp"];
$direccion_receptor_pdf = $objdomicilioRepcetor["direccion"];
$direccion_receptor_pdf2 = "";
if($objdomicilioRepcetor["estado"] != ''){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", ".$objdomicilioRepcetor["estado"] : $objdomicilioRepcetor["estado"]);
}
if($objdomicilioRepcetor["pais"] != '' && $objdomicilioRepcetor["pais"] != -1){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", ".$objdomicilioRepcetor["pais"] : $objdomicilioRepcetor["pais"]);
}
if($objdomicilioRepcetor["cp"] != ''){
$direccion_receptor_pdf2 .= ($direccion_receptor_pdf2 != '' ? ", CP. ".$objdomicilioRepcetor["cp"] : "CP. ".$objdomicilioRepcetor["cp"]);
}
$estado_receptor = $objdomicilioRepcetor["estado"];
$pais_receptor = $objdomicilioRepcetor["pais"];
$regimen_receptor = $this->_obtener_catalogo($objdomicilioRepcetor["regimenfiscal"], 1);
$rfc_receptor = $objdomicilioRepcetor["rfc"];
}
$informacion_receptor = array(
"rfc" => $rfc_receptor,
"nombre" => $nombre_receptor,
"email" => $cliente->email,
// "calle" => $cliente->address,
// "noint" => '',
// "noext" => '',
"codigoPostal" => $cp_receptor,
// "cod_municipio" => $cliente->options_cce_codmunicipio,
"estado" => $estado_receptor,
"pais" => $pais_receptor,
"direccion_pdf" => $direccion_receptor_pdf,
"direccion_pdf2" => $direccion_receptor_pdf2,
"ref_client" => $factura->ref_client,
"regimenfiscal" => $regimen_receptor
);
$this->receptor = $informacion_receptor;
}
function SetWidths($w){
//Set the array of column widths
$this->widths=$w;
}
function SetAligns($a){
//Set the array of column alignments
$this->aligns=$a;
}
#Esta sección de código es el algoritmo que se utiliza para la creación y distribución de la tabla de partidas de la factura (Inicio)
function Row($data){
//Calculate the height of the row
$nb=0;
for($i=0;$iNbLines($this->widths[$i],$data[$i]));
$h=5.1*$nb;#el valor de 5.1 es para el height del rectangulo
$y_tmp = (int) $this->GetY() + $h;
if($y_tmp > 255){
$this->AddPage();
$this->SetFont('Arial','B', 8);
$this->Ln(5);
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
//Cabeceras de tabla de partidas
$this->SetTextColor(255,255,255);
$this->Cell(16,7,"Clave",0,0,'C');
$this->Cell(12,7,"Cant.",0,0,'C');
$this->Cell(10,7,"Unidad",0,0,'C');
$this->Cell(64,7,utf8_decode("Descripción"),0,0,'C');
$this->Cell(22,7,"Precio Unitario",0,0,'C');
$this->Cell(22,7,"I.V.A.",0,0,'C');
$this->Cell(22,7,"Dto.",0,0,'C');
$this->Cell(22,7,"Importe",0,0,'C');
$this->Ln();
$this->SetTextColor(0,0,0);
}
$this->SetFont('Arial','', 7);
for($i=0;$iwidths[$i];
$a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
//Save the current position
$x=$this->GetX();
$y=$this->GetY();
//Draw the border
$this->Rect($x,$y,$w,$h);
//Print the text
$this->MultiCell($w,4,$data[$i],0,$a);#el valor de 5 es el interlineado entre renglones del texto
//Put the position to the right of the cell
$this->SetXY($x+$w,$y);
}
//Go to the next line
if ($h >= 100) { #Esta condición no es parte del algoritmo original, fue agregado
$h=$h-20;
}
$this->Ln($h);
}
// function CheckPageBreak($h){
// //If the height h would cause an overflow, add a new page immediately
// if($this->GetY()+$h>$this->PageBreakTrigger)
// $this->AddPage($this->CurOrientation);
// }
function NbLines($w,$txt){
//Computes the number of lines a MultiCell of width w will take
$cw=&$this->CurrentFont['cw'];
if($w==0)
$w=$this->w-$this->rMargin-$this->x;
$wmax=($w-2*$this->cMargin)*1000/$this->FontSize;
$s=str_replace("\r",'',$txt);
$nb=strlen($s);
if($nb>0 and $s[$nb-1]=="\n")
$nb--;
$sep=-1;
$i=0;
$j=0;
$l=0;
$nl=1;
while($i<$nb)
{
$c=$s[$i];
if($c=="\n")
{
$i++;
$sep=-1;
$j=$i;
$l=0;
$nl++;
continue;
}
if($c==' ')
$sep=$i;
$l+=$cw[$c];
if($l>$wmax)
{
if($sep==-1)
{
if($i==$j)
$i++;
}
else
$i=$sep+1;
$sep=-1;
$j=$i;
$l=0;
$nl++;
}
else
$i++;
}
return $nl;
}
#Esta sección de código es el algoritmo que se utiliza para la creación y distribución de la tabla de partidas de la factura (Fin)
#Sección de código que hace las celdas con esquinas redondeadas (Inicio)
function RoundedRect($x, $y, $w, $h, $r, $style = '', $angle = '1234'){
$k = $this->k;
$hp = $this->h;
if($style=='F')
$op='f';
elseif($style=='FD' or $style=='DF')
$op='B';
else
$op='S';
$MyArc = 4/3 * (sqrt(2) - 1);
$this->_out(sprintf('%.2f %.2f m', ($x+$r)*$k, ($hp-$y)*$k ));
$xc = $x+$w-$r;
$yc = $y+$r;
$this->_out(sprintf('%.2f %.2f l', $xc*$k, ($hp-$y)*$k ));
if (strpos($angle, '2')===false)
$this->_out(sprintf('%.2f %.2f l', ($x+$w)*$k, ($hp-$y)*$k ));
else
$this->_Arc($xc + $r*$MyArc, $yc - $r, $xc + $r, $yc - $r*$MyArc, $xc + $r, $yc);
$xc = $x+$w-$r;
$yc = $y+$h-$r;
$this->_out(sprintf('%.2f %.2f l', ($x+$w)*$k, ($hp-$yc)*$k));
if (strpos($angle, '3')===false)
$this->_out(sprintf('%.2f %.2f l', ($x+$w)*$k, ($hp-($y+$h))*$k));
else
$this->_Arc($xc + $r, $yc + $r*$MyArc, $xc + $r*$MyArc, $yc + $r, $xc, $yc + $r);
$xc = $x+$r;
$yc = $y+$h-$r;
$this->_out(sprintf('%.2f %.2f l', $xc*$k, ($hp-($y+$h))*$k));
if (strpos($angle, '4')===false)
$this->_out(sprintf('%.2f %.2f l', ($x)*$k, ($hp-($y+$h))*$k));
else
$this->_Arc($xc - $r*$MyArc, $yc + $r, $xc - $r, $yc + $r*$MyArc, $xc - $r, $yc);
$xc = $x+$r ;
$yc = $y+$r;
$this->_out(sprintf('%.2f %.2f l', ($x)*$k, ($hp-$yc)*$k ));
if (strpos($angle, '1')===false)
{
$this->_out(sprintf('%.2f %.2f l', ($x)*$k, ($hp-$y)*$k ));
$this->_out(sprintf('%.2f %.2f l', ($x+$r)*$k, ($hp-$y)*$k ));
}
else
$this->_Arc($xc - $r, $yc - $r*$MyArc, $xc - $r*$MyArc, $yc - $r, $xc, $yc - $r);
$this->_out($op);
}
function _Arc($x1, $y1, $x2, $y2, $x3, $y3){
$h = $this->h;
$this->_out(sprintf('%.2f %.2f %.2f %.2f %.2f %.2f c ', $x1*$this->k, ($h-$y1)*$this->k, $x2*$this->k, ($h-$y2)*$this->k, $x3*$this->k, ($h-$y3)*$this->k));
}
#Sección de código que hace las celdas con esquinas redondeadas (Fin)
#Funciones de armado de PDF (Inicio)
// Función para mostrar el cuadro de cabecera del comprobante
function Header() {
global $db, $conf, $mysoc, $langs;
$this->SetY(7);
$pagcid = GETPOST("pagcid");
$this->pago_id = $pagcid;
$id = (GETPOST('facid') != "") ? GETPOST('facid') : GETPOST('id');
$sql_pago_head = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos";
$sql_pago_head .= " WHERE fk_paiement = ".$pagcid;
$sql_pago_head .= " AND fk_facture = 0";
$sql_pago_head .= " AND entity = ".$conf->entity;
$res_pago_head = $db->query($sql_pago_head);
$num_pago_head = $db->num_rows($res_pago_head);
if($num_pago_head > 0){
$obj_pago_head = $db->fetch_object($res_pago_head);
$sql_pago = "SELECT fk_facture FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos_relacion_facturas";
$sql_pago .= " WHERE fk_relacion_pagos=".$obj_pago_head->rowid;
$res_pago = $db->query($sql_pago);
$num_pago = $db->num_rows($res_pago);
//print $sql_pago.'
';
// $soc_id = 0;
// $fk_facture = 0;
if($num_pago > 0){
$obj_pago = $db->fetch_object($res_pago);
$id = $obj_pago->fk_facture;
$this->factura_id = $id;
// $id = $fk_facture;
}
}
// $id = (GETPOST('facid') != "") ? GETPOST('facid') : GETPOST('id');
$this->SetData($id);
$object = new Facture($db);
$object->fetch($id);
$logo_valido = 0;
$logo = $conf->mycompany->dir_output.'/logos/'.$mysoc->logo;
if ($mysoc->logo)
{
if (is_readable($logo))
{
$posx = 10;
$posy = 6;
$width = 20;
$height = 17;
$this->Image($logo, $posx, $posy, $width, $height); // width=0 (auto)
$logo_valido = 1;
}
}
// $sql='SELECT IFNULL(tipo_document,NULL) as tipo_document FROM '.MAIN_DB_PREFIX.'cfdimx_type_document WHERE fk_facture='.$id;
// $reset=$db->query($sql);
// $res=$db->fetch_object($reset);
// if($res->tipo_document != NULL){
// if($res->tipo_document==1){
// $tipo_doc = "Factura";
// }
// if($res->tipo_document==2){
// $tipo_doc = "Recibo de Honorarios";
// }
// if($res->tipo_document==3){
// $tipo_doc = "Recibo de Arrendamiento";
// }
// if($res->tipo_document==4){
// $tipo_doc = utf8_decode("Nota de Crédito");
// }
// if($res->tipo_document==5){
// $tipo_doc = "Factura de Fletes";
// }
// if($res->tipo_document==6){
// $tipo_doc = "Factura RIF";
// }
// if($res->tipo_document==7){
// $tipo_doc = "Factura Traslado";
// }
// }else{
// $tipo_doc="Factura";
// }
$tipo_doc = "Complemento de Pagos";
$pago = new Paiement($db);
$pago->fetch($pagcid);
$this->SetFont('Arial','B',7);
$this->SetX(139);
$this->Cell(60,4, $tipo_doc.": ".$pago->ref,"",1,'C');// LRT
$this->SetX(139);
$this->Cell(60,4,"FOLIO FISCAL (UUID)","",1,'C');// LR
$this->SetFont('Arial','',7);
$this->SetX(139);
$this->Cell(60,4, $this->data["uuid"],"",1,'C');// LR
$this->SetFont('Arial','B',7);
$this->SetX(139);
$this->Cell(60,4,"NO. DE SERIE DEL CERTIFICADO DEL SAT","",1,'C');// LR
$this->SetFont('Arial','',7);
$this->SetX(139);
$this->Cell(60,4, $this->data["certificado"],"",1,'C');// LR
$this->SetFont('Arial','B',7);
$this->SetX(139);
$this->Cell(60,4,"NO. DE SERIE DEL CERTIFICADO DEL EMISOR","",1,'C');// LR
$this->SetFont('Arial','',7);
$this->SetX(139);
$this->Cell(60,4, $this->data["certEmisor"],"",1,'C');// LR
$this->SetFont('Arial','B',7);
$this->SetX(139);
$this->Cell(60,4,utf8_decode("FECHA Y HORA DE CERTIFICACION"),"",1,'C');// LR
$this->SetFont('Arial','',7);
$this->SetX(139);
$this->Cell(60,4, $this->data["fechaTimbrado"],"",1,'C');// LR
$this->SetFont('Arial','B',7);
$this->SetX(139);
$this->Cell(60,4,utf8_decode("FECHA Y HORA DE EMISION DEL CFDI"),"",1,'C');// LR
$this->SetFont('Arial','',7);
$this->SetX(139);
$this->Cell(60,4, $this->data["fechaEmision"],"",1,'C');// LRB
$this->SetX(139);
$this->Cell(60,4,"",0,0,'L');
$this->SetDrawColor(16,120,179);
$this->SetFillColor(194,229,243);
$this->RoundedRect(138,$this->GetY()-45,62,45, 5,'D'); //$x,$y,$w,$h
//Inicia Informacion Emisor
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect(10,25,125,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->Ln();
$this->SetFont('Arial','B',9);
$this->SetXY(10, 26);
$this->Cell(75,4," Emisor",0,0,'L');
$this->SetTextColor(0,0,0);
$this->Ln(5);
$this->SetFont('Arial','B',8);
//Datos Emisor
$this->SetXY(10, 31);
$this->Cell(80,4,utf8_decode($this->limpiar($this->emisor["nombre"])),0,0,'L');
$this->SetXY(10, 35);
$this->Cell(80,4,$this->emisor["emisorRFC"],0,0,'L');
if($this->emisor["emisorRegimen"] == 625){
$this->SetFont('Arial','B',7);
}
$this->SetXY(10, 39);
$this->Cell(80,4,utf8_decode($this->limpiar($this->emisor["emisorRegimenEtiqueta"])),0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY(10, 43);
$this->Cell(80,4,utf8_decode($this->limpiar($this->emisor["direccion_pdf"])),0,0,'L');
$this->SetXY(10, 47);
$this->Cell(80,4,utf8_decode($this->limpiar($this->emisor["direccion_pdf2"])),0,0,'L');
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect(10,$this->GetY()-17,125,21,2,'D','1234');
//Termina Informacion Emisor
$this->Ln(3);
}
// Función para mostrar el cuadro de datos del receptor
function _pageReceptor($x, $y) {
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->Ln();
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()-2);
$this->Cell(75,4," Receptor",0,0,'L');
$this->SetTextColor(0,0,0);
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+7);
$this->Cell(80,4,utf8_decode($this->limpiar($this->receptor["nombre"])),0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+11);
$this->Cell(80,4,$this->receptor["rfc"],0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+60, $y+11);
$this->Cell(75,4,"Uso CFDI: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+75, $y+11);
$this->Cell(75,4,utf8_decode($this->limpiar($this->datoscomprobante["usoCFDI"])),0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+135, $y+11);
$this->Cell(75,4,utf8_decode($this->limpiar($this->receptor["ref_client"])),0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x, $y+15);
$this->Cell(80,4,utf8_decode($this->limpiar($this->receptor["regimenfiscal"])),0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x, $y+19);
$this->Cell(80,4,utf8_decode($this->limpiar($this->receptor["direccion_pdf"])),0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x, $y+23);
$this->Cell(80,4,utf8_decode($this->limpiar($this->receptor["direccion_pdf2"])),0,0,'L');
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect(10,$this->GetY()-17,190,22,2,'D','1234');
$this->SetY($this->GetY()+2);
$this->Ln();
}
//Funcion para mostrar el cuadro de la información del Pago
function _infoPago($x, $y){
global $db, $conf;
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->Ln();
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()-2);
$this->Cell(75,4," Pago",0,0,'L');
$this->SetTextColor(0,0,0);
$pago = new Paiement($db);
$pago->fetch($this->pago_id);
$sql_info_pago = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos";
$sql_info_pago .= " WHERE";
$sql_info_pago .= " fk_facture = 0";
$sql_info_pago .= " AND fk_paiement = ".$this->pago_id;
$sql_info_pago .= " AND entity = ".$conf->entity;
$res_info_pago = $db->query($sql_info_pago);
$fecha = "";
$forma_pago = "";
$moneda = "";
$monto = "";
$tipocambio = "";
if($res_info_pago){
$obj_info_pago = $db->fetch_object($res_info_pago);
$fecha = $obj_info_pago->fechaPago;
$forma_pago = $this->_obtener_catalogo($obj_info_pago->formaDePago, 3);
$moneda = $obj_info_pago->monedaP;
$monto = $obj_info_pago->monto;
$tipocambio = $obj_info_pago->TipoCambioP;
}
//Fila 1
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+7);
$this->Cell(75,4,"Tipo Comprobante: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+27, $y+7);
$this->Cell(75,4,$this->datoscomprobante["tipoDeComprobante"],0,0,'L');
$label_etiqueta1 = "";
$valor_etiqueta1 = "";
$label_etiqueta2 = "";
$valor_etiqueta2 = "";
if(strcmp($this->datoscomprobante["version_cfdi"], "4.0") == 0){
$label_etiqueta1 = "Version CFDI: ";
$valor_etiqueta1 = $this->datoscomprobante["version_cfdi"];
$label_etiqueta2 = "Exportacion: ";
$valor_etiqueta2 = $this->datoscomprobante["clave_exportacion"];
}else{
$label_etiqueta1 = "Version CFDI: ";
$valor_etiqueta1 = "3.3";
}
$this->SetFont('Arial','B',8);
$this->SetXY($x+45, $y+7);
$this->Cell(75,4,$label_etiqueta1,0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+65, $y+7);
$this->Cell(75,4,$valor_etiqueta1,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+90, $y+7);
$this->Cell(75,4,$label_etiqueta2,0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+108, $y+7);
$this->Cell(75,4,$valor_etiqueta2,0,0,'L');
##Fila 2
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+11);
$this->Cell(75,4,"Ref: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+7, $y+11);
$this->Cell(75,4,$pago->ref,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+45, $y+11);
$this->Cell(75,4,"Monto: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+55, $y+11);
$this->Cell(75,4,$monto,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+80, $y+11);
$this->Cell(75,4,"Tipo de Cambio: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+103, $y+11);
$this->Cell(75,4,$tipocambio,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+128, $y+11);
$this->Cell(75,4,"Moneda: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+141, $y+11);
$this->Cell(75,4,$moneda,0,0,'L');
##Fila 3
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+15);
$this->Cell(75,4,"Fecha: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+10, $y+15);
$this->Cell(75,4,$fecha,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+45, $y+15);
$this->Cell(75,4,"Forma de Pago: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+67, $y+15);
$this->Cell(75,4,utf8_decode($this->limpiar($forma_pago)),0,0,'L');
$total_retenidos = 0;
$sql_doc_rel = "SELECT sum(importe) AS importe FROM ".MAIN_DB_PREFIX."cfdimx_pagos_impuestos";
$sql_doc_rel .= " WHERE fk_pago = ".$this->pago_id;
$sql_doc_rel .= " AND entity = ".$conf->entity;
$sql_doc_rel .= " AND impuesto = '001'";
$res_doc_rel = $db->query($sql_doc_rel);
if($res_doc_rel){
$obj_retenidos = $db->fetch_object($res_doc_rel);
if(!is_null($obj_retenidos->importe)){
$total_retenidos = $obj_retenidos->importe;
}
}
$total_traslados = 0;
$sql_doc_rel = "SELECT sum(importe) AS importe FROM ".MAIN_DB_PREFIX."cfdimx_pagos_impuestos";
$sql_doc_rel .= " WHERE fk_pago = ".$this->pago_id;
$sql_doc_rel .= " AND entity = ".$conf->entity;
$sql_doc_rel .= " AND impuesto = '002'";
$res_doc_rel = $db->query($sql_doc_rel);
if($res_doc_rel){
$obj_traslados = $db->fetch_object($res_doc_rel);
if(!is_null($obj_traslados->importe)){
$total_traslados = $obj_traslados->importe;
}
}
##Fila 4
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+19);
$this->Cell(75,4,"Total: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+10, $y+19);
$this->Cell(75,4,$pago->amount,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+45, $y+19);
$this->Cell(75,4,"Imp. Ret.: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+60, $y+19);
$this->Cell(75,4,$total_retenidos,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+90, $y+19);
$this->Cell(75,4,"Imp. Tras.: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+105, $y+19);
$this->Cell(75,4,$total_traslados,0,0,'L');
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect(10,$this->GetY()-13,190,18,2,'D','1234');
$this->SetY($this->GetY()+1);
$this->Ln();
}
//Funcion para mostrar el cuadro de la información del Pago
function _docRelacionados($x, $y){
global $db, $conf, $langs;
$langs->load("cfdimx@cfdimx");
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->Ln();
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()-2);
$this->Cell(75,4," Documentos Relacionados",0,0,'L');
$this->SetTextColor(0,0,0);
$pago = new Paiement($db);
$pago->fetch($this->pago_id);
$sql_info_pago = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos";
$sql_info_pago .= " WHERE";
$sql_info_pago .= " fk_facture = 0";
$sql_info_pago .= " AND fk_paiement = ".$this->pago_id;
$sql_info_pago .= " AND entity = ".$conf->entity;
$res_info_pago = $db->query($sql_info_pago);
$total_traslados = 10;
$total_retenidos = 10;
if($res_info_pago){
$obj_info_pago = $db->fetch_object($res_info_pago);
$sql_doc_rel = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos_docto_relacionado";
$sql_doc_rel .= " WHERE fk_recepago = ".$obj_info_pago->rowid;
$sql_doc_rel .= " AND entity = ".$conf->entity;
$sql_doc_rel .= " ORDER BY rowid DESC";
$res_doc_rel = $db->query($sql_doc_rel);
$num_doc_rel = $db->num_rows($res_doc_rel);
if($num_doc_rel > 0){
$y = $this->GetY()+4;
while($obj_doc_rel = $db->fetch_object($res_doc_rel)){
$sql_impuestos_guardados = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_pagos_impuestos";
$sql_impuestos_guardados .= " WHERE";
$sql_impuestos_guardados .= " entity = ".$conf->entity;
$sql_impuestos_guardados .= " AND fk_pago = ".$this->pago_id;
$sql_impuestos_guardados .= " AND uuid_doc_rel = '".$obj_doc_rel->idDocumento."'";
$sql_impuestos_guardados .= " ORDER BY tipo, impuesto ASC";
$res_impuestos_guardados = $db->query($sql_impuestos_guardados);
$num_impuestos_guardados = $db->num_rows($res_impuestos_guardados);
$num_impuestos = 0;
if($num_impuestos_guardados > 0){
$num_impuestos_guardados += 5;
$num_impuestos = $num_impuestos_guardados * 4;
}
$y_tmp = (int)$y + 10;
$y_tmp = $y_tmp + $num_impuestos;
if($y_tmp > 271){
$this->AddPage();
$this->SetY(54);
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->Ln();
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()-2);
$this->Cell(75,4," Documentos Relacionados",0,0,'L');
$this->SetTextColor(0,0,0);
// $x = $this->GetX();
$y = $this->GetY()+4;
}
$ref_doc = "";
if($obj_doc_rel->serie != ""){
$ref_doc .= $obj_doc_rel->serie;
}
if($obj_doc_rel->folio != ""){
if($ref_doc != "")
$ref_doc .= "-";
$ref_doc .= $obj_doc_rel->folio;
}
##Columna 1
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+1);
$this->Cell(75,4,"Ref: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+6, $y+1);
$this->Cell(75,4,$ref_doc,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+35, $y+1);
$this->Cell(75,4,"UUID: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+44, $y+1);
$this->Cell(75,4,$obj_doc_rel->idDocumento,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+105, $y+1);
$this->Cell(75,4,"Moneda: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+118, $y+1);
$this->Cell(75,4,$obj_doc_rel->monedaDR,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+135, $y+1);
$this->Cell(75,4,"Tipo de Cambio: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+158, $y+1);
$this->Cell(75,4,$obj_doc_rel->tipoCambioDR ,0,0,'L');
##Columna 2
$this->SetFont('Arial','B',8);
$this->SetXY($x, $y+5);
$this->Cell(75,4,"No Parcialidad: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+21, $y+5);
$this->Cell(75,4,$obj_doc_rel->numParcialidad,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+30, $y+5);
$this->Cell(75,4,"ImpSaldoAnt: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+49, $y+5);
$this->Cell(75,4,$obj_doc_rel->impSaldoAnt,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+70, $y+5);
$this->Cell(75,4,"ImpPagado: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+87, $y+5);
$this->Cell(75,4,$obj_doc_rel->impPagado,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+110, $y+5);
$this->Cell(75,4,"ImpSaldoInsoluto: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+136, $y+5);
$this->Cell(75,4,$obj_doc_rel->impSaldoInsoluto,0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+155, $y+5);
$this->Cell(75,4,"Equivalencia: ",0,0,'L');
$this->SetFont('Arial','',8);
$this->SetXY($x+174, $y+5);
$this->Cell(75,4,$obj_doc_rel->equivalencia,0,0,'L');
##Inicia desglose de Impuestos
if($num_impuestos_guardados > 0){
//Dibujar recuadro
$this->SetDrawColor(194,229,243);
$this->SetFillColor(194,229,243);
$this->RoundedRect($x+8,$y+13,165,5,3,'DF','');
$this->Ln();
$this->SetFont('Arial','B',8);
$this->SetXY($x+8, $y+14);
$this->Cell(75,4," Impuestos Relacionados",0,0,'L');
$this->SetDrawColor(194,229,243);
$this->SetFillColor(194,229,243);
$this->RoundedRect($x+8,$y+18,165,5,3,'DF','');
$this->SetFont('Arial','B',8);
$this->SetXY($x+8, $y+18);
$this->Cell(75,4,"Tipo",0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+30, $y+18);
$this->Cell(75,4,"Base",0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+60, $y+18);
$this->Cell(75,4,"Impuesto",0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+90, $y+18);
$this->Cell(75,4,"Tipo Factor",0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+120, $y+18);
$this->Cell(75,4,"Tasa O Cuota",0,0,'L');
$this->SetFont('Arial','B',8);
$this->SetXY($x+150, $y+18);
$this->Cell(75,4,"Importe",0,0,'L');
$y2 = $y + 18;
while($obj_imp_g = $db->fetch_object($res_impuestos_guardados)){
$y2 += 5;
$this->SetFont('Arial','',8);
$this->SetXY($x+8, $y2);
$this->Cell(75,4,$langs->trans("TipoImpPDF".$obj_imp_g->tipo),0,0,'L');
$this->SetXY($x+30, $y2);
$this->Cell(75,4,$obj_imp_g->base,0,0,'L');
$this->SetXY($x+60, $y2);
$this->Cell(75,4,$langs->trans("Imp".$obj_imp_g->impuesto),0,0,'L');
$this->SetXY($x+90, $y2);
$this->Cell(75,4,$obj_imp_g->tipo_factor,0,0,'L');
$this->SetXY($x+120, $y2);
$this->Cell(75,4,$obj_imp_g->tasa_o_cuota,0,0,'L');
$this->SetXY($x+150, $y2);
$this->Cell(75,4,$obj_imp_g->importe,0,0,'L');
if(strcmp("001", $obj_imp_g->impuesto) == 0){
$total_retenidos += $obj_imp_g->importe;
}
if(strcmp("002", $obj_imp_g->impuesto) == 0){
$total_traslados += $obj_imp_g->importe;
}
}
}
##Termina desglose de Impuestos
$num_y = 10 + $num_impuestos;
$tamanio = 10 + $num_impuestos;
// Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(194,229,243);
$this->RoundedRect($x,$y,190,$tamanio,2,'D','1234');
$y = $y + $num_y;
// Dibujar recuadro
// $this->SetDrawColor(16,120,179);
// $this->SetFillColor(16,120,179);
// $this->RoundedRect(10,$this->GetY()-5,190,10,2,'D','1234');
// $this->SetY($this->GetY()+1);
}
$this->Ln(5);
// if($total_retenidos > 0){
// #Estilo de recuadros
// $this->SetDrawColor(194,229,243);
// $this->SetFillColor(194,229,243);
// $this->Ln(5);
// #Dibujo de recuadro
// $this->RoundedRect($this->GetX()+125,$this->GetY()+5,65,5,2,'DF','1234');
// $posXrecuadro = $this->GetX(); //Se almacena posición X para utulizarla en los demás recuadros
// #Subtotal
// $this->SetFont('Arial','B',9);
// $this->SetXY($x+130, $y+3);
// $this->Cell(20,7,"Impuestos Retenidos",0,0,'L');
// $this->SetFont('Arial','',9);
// $this->SetXY($x+150, $y+3);
// $this->Cell(30,7, number_format($total_retenidos, 2),0,0,'R');
// $this->Ln(5);
// $y = 8;
// }
// if($total_traslados > 0){
// #Estilo de recuadros
// $this->SetDrawColor(194,229,243);
// $this->SetFillColor(194,229,243);
// $this->Ln(5);
// $y_header = $this->GetY();
// $x_header = $this->GetX() + 125;
// #Dibujo de recuadro
// $this->RoundedRect($x_header, $y_header,65,5,2,'DF','1234');
// $posXrecuadro = $this->GetX(); //Se almacena posición X para utulizarla en los demás recuadros
// #Subtotal
// $this->SetFont('Arial','B',9);
// $this->SetXY($x+130, $y);
// $this->Cell(20,7,"Impuestos Traslados",0,0,'L');
// $this->SetFont('Arial','',9);
// $this->SetXY($x+150, $y);
// $this->Cell(30,7, number_format($total_traslados, 2),0,0,'R');
// $this->Ln(5);
// }
}
}
}
// Función para mostrar el cuadro de observaciones del comprobante
function _pageObservaciones($x, $y) {
$this->SetY($this->GetY()+1);
$antesMulticel = $this->GetY();
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()+2);
$this->Cell(75,4," Observaciones",0,0,'L');
$this->Ln();
$this->SetTextColor(0,0,0);
$this->SetFont('Arial','',8);
$this->MultiCell(190,4,utf8_decode($this->datoscomprobante["observaciones"]),0, "L", false);
$this->Ln();
$despuesMulticel = $this->GetY();
$tam_cuadro = ($despuesMulticel - $antesMulticel)-4;
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(194,229,243);
$this->RoundedRect($this->GetX(),$this->GetY()-$tam_cuadro+2,190,$tam_cuadro,2,'D','1234');
// $this->Ln();
$this->SetY($this->GetY()+3);
}
##CFDIS relacionados
function _pageCFDIRel($x, $y){
global $db, $conf;
$pagcid = GETPOST("pagcid");
// $this->pago_id = $pagcid;
// $id = (GETPOST('facid') != "") ? GETPOST('facid') : GETPOST('id');
$sql_pago_head = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos";
$sql_pago_head .= " WHERE fk_paiement = ".$pagcid;
$sql_pago_head .= " AND fk_facture = 0";
$sql_pago_head .= " AND entity = ".$conf->entity;
$res_pago_head = $db->query($sql_pago_head);
$num_pago_head = $db->num_rows($res_pago_head);
if($num_pago_head > 0){
$obj_head_cfdi_rel = $db->fetch_object($res_pago_head);
$label_tipo_rel = $this->_obtener_catalogo($obj_head_cfdi_rel->tipo_rel, 4);
if(!is_null($obj_head_cfdi_rel->tipo_rel) && $obj_head_cfdi_rel->tipo_rel != -1){
##Se valida que el complemento tenga cfdi relacionados
$sql_valida_cfdi_rel = "SELECT * FROM ".MAIN_DB_PREFIX."cfdimx_cfdi_relacionados_pagos";
$sql_valida_cfdi_rel .= " WHERE fk_pago = " .$pagcid;
$res_valida_cfdi_rel = $db->query($sql_valida_cfdi_rel);
$valida_cfdi_rel = $db->num_rows($res_valida_cfdi_rel);
if($valida_cfdi_rel > 0){
$this->SetY($this->GetY()+2);
$antesMulticel = $this->GetY();
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(16,120,179);
$this->RoundedRect($this->GetX(),$this->GetY()+1,190,5,3,'DF','1234');
$this->SetTextColor(255,255,255);
$this->SetFont('Arial','B',9);
$this->SetXY($x, $this->GetY()+2);
$this->Cell(75,4,utf8_decode($this->limpiar(" CFDIS Relacionados - ".$label_tipo_rel)),0,0,'L');
$this->Ln();
$this->SetTextColor(0,0,0);
$this->SetFont('Arial','',8);
$txt_cfdi_relacionados = "";
$contador = 1;
while($cfdi_rel = $db->fetch_object($res_valida_cfdi_rel)){
if($contador < $valida_cfdi_rel){
$txt_cfdi_relacionados .= $contador.'.- '.$cfdi_rel->uuid."\n";
}else{
$txt_cfdi_relacionados .= $contador.'.- '.$cfdi_rel->uuid;
}
$contador++;
}
$this->MultiCell(190,4,utf8_decode($txt_cfdi_relacionados),0, "L", false);
$this->Ln();
$despuesMulticel = $this->GetY();
$tam_cuadro = ($despuesMulticel - $antesMulticel)-4;
$tam_cuadro2 = ($despuesMulticel - $antesMulticel)-10;
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(194,229,243);
$this->RoundedRect($this->GetX(),$this->GetY()-$tam_cuadro+2,190,$tam_cuadro2,2,'D','1234');
$this->SetY($this->GetY()-3);
}
}
}
}
// Código QR y cadena
function _pageQRCode(){
global $conf, $db;
// $id = (GETPOST('facid') != "") ? GETPOST('facid') : GETPOST('id');
// $object = new Facture($db);
// $object->fetch($id);
$pago_id = $this->pago_id;
$pago=new Paiement($db);
$pago->fetch($pago_id);
if(file_exists($conf->facture->dir_output."/".$pago->ref)){}else{
mkdir($conf->facture->dir_output."/".$pago->ref,0700);
}
// $data_cbb = 'https://verificacfdi.facturaelectronica.sat.gob.mx/default.aspx?id='.$this->data["uuid"].'&re='.$this->data["rfc_emisor"].'&rr='.$this->data["rfc_receptor"].'&tt='.$object->total_ttc.'&fe='.substr($this->data["selloCFD"],-8);
// $data_cbb = 'https://verificacfdi.facturaelectronica.sat.gob.mx/default.aspx?id='.$this->data["uuid"].'&re='.$this->emisor["emisorRFC"].'&rr='.$this->receptor["rfc"].'&tt='.$object->total_ttc.'&fe='.substr($this->data["selloCFD"],-8);
$texto = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.';
$data_cbb = 'https://verificacfdi.facturaelectronica.sat.gob.mx/default.aspx';
QRcode::png($data_cbb,$conf->facture->dir_output."/".$pago->ref."/previo_".$pago->ref.".png");
//$this->CheckPageBreak(20);
if((int)$this->GetY() > 220){
$this->AddPage();
}
$this->Image($conf->facture->dir_output."/".$pago->ref."/previo_".$pago->ref.".png",162, $this->GetY()+9,42);
$this->SetFont('Arial','',6);
$this->SetY($this->GetY()+13);
$this->MultiCell(150,4,"\n".$texto,0, "L", false);
$this->SetY($this->GetY()-16);
$this->SetFont('Arial','B',6);
$this->Cell(20,4,utf8_decode("SELLO DIGITAL DEL EMISOR"),0,0,'L');
$this->SetY($this->GetY()+16);
$this->SetFont('Arial','',6);
$this->MultiCell(150,4,"\n".$texto,0, "L", false);
$this->SetY($this->GetY()-16);
$this->SetFont('Arial','B',6);
$this->Cell(20,4,utf8_decode("SELLO DIGITAL DEL SAT"),0,0,'L');
$this->SetY($this->GetY()+16);
$this->SetFont('Arial','',6);
$this->MultiCell(150,4,"\n".$texto,0, "L", false);
$this->SetY($this->GetY()-16);
$this->SetFont('Arial','B',6);
$this->Cell(20,4,utf8_decode("CADENA ORIGINAL DEL COMPLEMENTO DE CERTIFICACION DIGITAL DEL SAT"),0,0,'L');
$this->SetY($this->GetY()+20);
//Dibujar recuadro
$this->SetDrawColor(16,120,179);
$this->SetFillColor(194,229,243);
$this->RoundedRect($this->GetX(),$this->GetY()-53,150,55,2,'D','1234');
}
function _obtener_catalogo($codigo='', $tipo_catalogo, $tipo_sql = ''){
global $langs, $db;
$langs->load('main');
$out='';
switch ($tipo_catalogo) {
case 1:
$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_cfdimx_regimen_f WHERE code = '".$codigo."'";
break;
case 2:
$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_cfdimx_uso_cfdi WHERE code = '".$codigo."'";
break;
case 3:
$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_cfdimx_formapago WHERE code = '".$codigo."'";
break;
case 4:
$sql = "SELECT * FROM ".MAIN_DB_PREFIX."c_cfdimx_tipo_rel WHERE code = '".$codigo."'";
break;
default:
$sql = "";
break;
}
$res_catalogo_sql = $db->query($sql);
if ($res_catalogo_sql )
{
$num = $db->num_rows($res_catalogo_sql);
$i = 0;
if ($num)
{
while ($obj_catalogo = $db->fetch_object($res_catalogo_sql )) {
$valor = $obj_catalogo->code;
$etiqueta = $valor." - ".$obj_catalogo->label;
if($valor == $codigo){
$out = $etiqueta;
break;
}
}
}
}else{
dol_print_error($db);
}
return $out;
}
// Page footer
function Footer()
{
// Go to 1.5 cm from bottom
$this->SetY(-15);
// Select Arial italic 8
$this->SetFont('Arial','I',6);
// Print current and total page numbers
$this->Cell(0,10,utf8_decode('Este documento es una representación gráfica de un CFDI - Página ').$this->PageNo().'/{nb}',0,0,'C');
}
#Funciones de armado de PDF (Fin)
}
$pagcid = GETPOST("pagcid");
$cfdi_commit = $_GET['cfdi_commit'];
$pdf=new cfdiPDF();
$pdf->AddPage();
$pdf->AliasNbPages();
$pdf->SetFont('Arial','',14);
//Table with n rows and 6 columns add columns PDF
$pdf->SetWidths(array(16,12,10,64,22,22,22,22));
$pdf->SetAligns(array('C','C','C','L','R','R','R','R'));
$pdf->SetFont('arial','B',10);
//$pdf->SetFillColor(0,0,0);//Fondo verde de celda
$pdf->SetTextColor(0, 0, 0); //Letra color negro
$pago = new Paiement($db);
$pago->fetch($pagcid);
// $pdf->SetY($pdf->GetY()+5);
// $pdf->_pageDatosComprobante($pdf->GetX(), $pdf->GetY());
$pdf->SetY($pdf->GetY()+5);
$pdf->_pageReceptor($pdf->GetX(), $pdf->GetY());
// $pdf->SetY($pdf->GetY()+5);
$pdf->_pageCFDIRel($pdf->GetX(), $pdf->GetY());
// if ($object->note_public != "") {
// $pdf->SetY($pdf->GetY()+1);
// $pdf->_pageObservaciones($pdf->GetX(), $pdf->GetY());
// }
$pdf->SetY($pdf->GetY()+2);
$pdf->SetFont('Arial','B', 8);
//Dibujar recuadro
$pdf->SetDrawColor(16,120,179);
$pdf->SetFillColor(16,120,179);
$pdf->RoundedRect($pdf->GetX(),$pdf->GetY()+1,190,5,3,'DF','1234');
//Cabeceras de tabla de partidas
$pdf->SetTextColor(255,255,255);
$pdf->Cell(16,7,"Clave",0,0,'C');
$pdf->Cell(12,7,"Cant.",0,0,'C');
$pdf->Cell(10,7,"Unidad",0,0,'C');
$pdf->Cell(64,7,utf8_decode("Descripción"),0,0,'C');
$pdf->Cell(22,7,"Precio Unitario",0,0,'C');
$pdf->Cell(22,7,"I.V.A.",0,0,'C');
$pdf->Cell(22,7,"Dto.",0,0,'C');
$pdf->Cell(22,7,"Importe",0,0,'C');
$pdf->Ln();
$pdf->SetTextColor(0,0,0);
if(strcmp($conf->global->CFDIMX_VERSION_SAT, "4.0") == 0){
$pdf->Row(
array(
"84111506",
1,
"ACT",
trim("Pago"),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2)
)
);
}else{
$pdf->Row(
array(
"84111506",
1,
"ACT",
trim("Pago"),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2),
$pdf->datoscomprobante["label_moneda"]." ".number_format(0,2)
)
);
}
$pdf->Ln();
$pdf->_infoPago($pdf->GetX(), $pdf->GetY());
$pdf->Ln();
$pdf->_docRelacionados($pdf->GetX(), $pdf->GetY());
$pdf->_pageQRCode();
$pdf->Output($conf->facture->dir_output."/".$pago->ref."/previo_".$pago->ref.".pdf", 'F');
print "";
?>