<?php

require_once('../../libreriasphp/html2pdf/_tcpdf_5.9.206/tcpdf.php');

session_start();

require_once ("../../config/Cado.php");
require_once ("../../app/venta/cVenta.php");
$oVenta = new cVenta();
require_once ("../../app/venta/cVentapago.php");
$oVentapago = new cVentapago();
require_once ("../../app/producto/cCatalogo.php");
$oCatalogo = new cCatalogo();

require_once ("../../app/caja/cCaja.php");
$oCaja = new cCaja();
require_once ("../../app/empresa/cEmpresa.php");
$oEmpresa = new cEmpresa();
require_once ("../../app/formatos/numletras.php");
require_once ("../../app/formatos/formato.php");

date_default_timezone_set('America/Lima');
$now =  date('d-m-Y h:i:s a');

$key="@ef38d7sw";

function decrypt($data,$key)
{
    list($encrypted_data, $iv) = explode('::', base64_decode($data), 2);
    return openssl_decrypt($encrypted_data, 'aes-256-cbc', $key, 0, $iv);
}

$cont = strlen($hash);


   $venid = decrypt($_GET['venid'],$key);


	$dtsven= $oVenta->mostrarUno_ticket($venid);
	$dtven= mysqli_fetch_array($dtsven);
	//VENTA
	$ven_numDoc	=$dtven['numdoc'];
	$ven_docNom=$dtven['tb_documento_nom'];
	$ven_docAbr=$dtven['tb_documento_abr'];
	$ven_punVen=$dtven['tb_puntoventa_nom'];	
	$ven_venNom=$dtven['tb_usuario_nom'].' '.$dtven['tb_usuario_ape'];
	$ven_fecReg=$dtven['tb_venta_reg'];
	$ven_fec= mostrarFecha($dtven['tb_venta_fec']);
	$ven_est=$dtven['tb_venta_est'];
	$ven_valven=$dtven['tb_venta_valven'];
	$ven_igv=$dtven['tb_venta_igv'];
	
	$ven_des=$dtven['tb_venta_des'];
	$ven_tot=$dtven['tb_venta_tot'];
	$ven_not=$dtven['tb_venta_not'];
	$ven_pisNom=$dtven['tb_piso_nom'];
	
	$cot_numdoc=$dtven['tb_cotizacion_numdoc'];
	$guia_numdoc=$dtven['tb_guiaremision_numdoc'];
	$guia_fec=mostrarFecha($dtven['tb_guiaremision_fec']);
	
	$ven_rel=$dtven['tb_venta_rel'];
	$ven_gra=$dtven['tb_venta_gra'];
	$ven_ina=$dtven['tb_venta_ina'];
	$ven_exo=$dtven['tb_venta_exo'];
	$ven_grat=$dtven['tb_venta_grat'];
	$ven_isc=$dtven['tb_venta_isc'];
	$ven_otrtri=$dtven['tb_venta_otrtri'];
	$ven_otrcar=$dtven['tb_venta_otrcar'];
	$ven_anti=$dtven['tb_venta_anti'];
	$empid=$dtven['tb_empresa_id'];
	$modpagid=$dtven['tb_formapago_id'];
	$fecven = mostrarFecha($dtven['tb_ventapago_fecven']);
	$ven_nom = $dtven['tb_usuario_use'];
	
	if($modpagid == 1){
		$compag = 'CONTADO';
	}else {
		$compag = $dtven['tb_ventapago_numdia'].' DIAS.';
	}
		
	//CLIENTE
	$ven_pla=$dtven['tb_cliente_pla'];
	$cliNom=$dtven['tb_cliente_nom'];
	
	$vendigval=$dtven['tb_venta_digval'];
	$docabr=$dtven['tb_documento_abr'];
	$cliDoc=$dtven['doc'];
	$cliDir=$dtven['dir'];
	$cliId=$dtven['cliid'];
	
	$monid=$dtven['moneid'];
	
	mysqli_free_result($dtsven);
	
	
	
	if($ven_rel==0){
		
	}else{
		
	$dtsrel= $oVenta->mostrarUno_ticket($ven_rel);
	$dtrel= mysqli_fetch_array($dtsrel);	
	$cot_numdoc=$dtrel['tb_cotizacion_numdoc'];
	$guia_numdoc=$dtrel['tb_guiaremision_numdoc'];
	$guia_fec=mostrarFecha($dtrel['tb_guiaremision_fec']);
	}
	
	
	if($ven_pla==""){
		$vehi = '';
	}else{
		$vehi = ' VEHICULO : '.$ven_pla;
	}
	
	if($monid==1){
		$mon ="S/ ";
		$lblmon="SOLES";
	}else if($monid==2)
	{
		$lblmon="DOLARES AMERICANOS";
		$mon ="US$ ";
	}
	
	if($docabr=="F"){
		$tipodoc = 'FACTURA ELECTRONICA';
		$tipcom="01";
	}else if($docabr=="B"){
		$tipodoc = 'BOLETA ELECTRONICA';
		$tipcom="03";
	}else if($docabr=="T"){
		$tipodoc = 'TICKET INTERNO';
		//$tipcom="03";
	}
	
	
$ser =  substr($ven_numDoc,0,4); 
$corr =  substr($ven_numDoc,5,13); 
	
$cont = strlen($cliDoc);

if($cont==11){
	$tipdoc = '06';
}else if($cont==8){
	$tipdoc = '01';
}


	
$cts = $oCaja->filtro('','',$empid);

$dts=$oEmpresa->mostrarUno($empid);
$dt = mysqli_fetch_array($dts);
	$emp_ruc=$dt['tb_empresa_ruc'];
	$emp_nomcom=$dt['tb_empresa_nomcom'];
	$emp_razsoc=$dt['tb_empresa_razsoc'];
	$emp_dir=$dt['tb_empresa_dir'];
	$emp_dir2=$dt['tb_empresa_dir2'];
	$emp_tel=$dt['tb_empresa_tel'];
	$emp_ema=$dt['tb_empresa_ema'];
	$emp_fir=$dt['tb_empresa_fir'];		
mysqli_free_result($dts);
	
if($docabr=='T'){
		$anular = '
		<tr>
		<td width="50%"></td>
	    <td width="50%" style="text-align: right">
		<strong style="color:red;font-size:10pt;" >NO VALIDA PARA EFECTOS TRIBUTARIOS</strong> 
		</td>
		</tr>
		';
}else{
	$anular = '';
}

	
$title = "Representacion de ".$ven_numDoc;
$nombre_archivo = $emp_ruc.'_'.$ven_numDoc.'_'.$cliDoc.'.pdf';

// $file_name = 'FA-'.$serie.'-'.$numero.'-code.png';
// $path = 'temp/'.$file_name;
// $type = pathinfo($path, PATHINFO_EXTENSION);
// $data = file_POST_contents($path);
// $base64 = 'data:image/' . $type . ';base64,' . base64_encode($data);


class MYPDF extends TCPDF
{

    public function Header() {	
      //$image_file = K_PATH_IMAGES.'logo.jpg';
      //$this->Image($image_file, 20, 10, 71, '', 'JPG', '', 'T', false, 300, '', false, false, 0, false, false, false);
      // Set font
      //$this->SetFont('helvetica', 'B', 20);
      // Title
      //$this->Cell(0, 15, '<< TCPDF Example 003 >>', 0, false, 'C', 0, '', 0, false, 'M', 'M');
    }

    public function Footer() 
    {
      // $style = array(
      //   'position' => 'L',
      //   'align' => 'L',
      //   'stretch' => false,
      //   'fitwidth' => true,
      //   'cellfitalign' => '',
      //   'border' => false,
      //   'padding' => 0,
      //   'fgcolor' => array(0,0,0),
      //   'bgcolor' => false,
      //   'text' => false
      // //     'font' => 'helvetica',
      // //     'fontsize' => 8,
      // //     'stretchtext' => 4
      // );

      // $this -> SetY(-24);
      // // Page number
      // $this->SetFont('helvetica', '', 9);
      // //$this->SetTextColor(0,0,0);
      // $this->Cell(0, 0, 'Página '.$this->getAliasNumPage().' de '.$this->getAliasNbPages(), 'T', 1, 'R', 0, '', 0, false, 'T', 'M');
      
      // $codigo='CAV-'.str_pad($_POST['d1'], 4, "0", STR_PAD_LEFT);
      
      // $this->write1DBarcode($codigo, 'C128', '', 273, '', 6, 0.3, $style, 'N');
      // $this->Cell(0, 0, 'www.prestamosdelnortechiclayo.com', 0, 1, 'C', 0, '', 0, false, 'T', 'M');        
    }
}

// create new PDF document
$pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('https://infosisperu.com.pe');
$pdf->SetTitle($title);

$pdf->SetSubject('https://infosisperu.com.pe');
$pdf->SetKeywords('https://infosisperu.com.pe');

// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

//set margins
$pdf->SetMargins(12,15, 12);// left top right
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
//$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, 15);

//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

//set some language-dependent strings
$pdf->setLanguageArray($l);

// ---------------------------------------------------------

// add a page
$pdf->AddPage('P', 'A4');

//font-family: Consolas, monaco, monospace;
//helvetica, monaco, monospace;

// Introducimos HTML de prueba
$html = '
<!DOCTYPE html>
<html lang="es">
<head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
	 <link rel="shortcut icon" href="../../admin/bootstrap/images/favicon.png">
</head>
<style type="text/css">
    body {
        color: black;
        font-family: Verdana, Arial, Consolas;
        margin: 0px;
        padding-top: 0px;
        font-size: 7.5pt;
    }
    .header_row th {
		font-size:28px;
		background-color:#eee;
        border-bottom: 0.9px solid #010101;
        border-right: 0.9px solid #010101;
        border-left: 0.9px solid #010101;
        border-top: 0.9px solid #010101;
    }
    .odd_row td {
        background-color: transparent;
        border-bottom: 0.9px solid #010101;
        padding-top: 5px;
        padding-bottom: 5px;
    }
    .even_row td {
        padding-top: 5px;
        padding-bottom: 5px;
       border-bottom: 0.9px solid #010101;
    }
    .row td{
        border-right: 0.9px solid #010101;
        border-left: 0.9px solid #010101;
    }
</style>

<style media="print">
    .oculto{
        display: none;
    }

</style>
<body>




<table width="100%" style="" > '.$anular.'
<tr>
	<td width="18%">
	<img src="../../imagenes/logo1.png" alt="" />
	</td>
        <td style="text-align:center;" width="50%">
		<br />
		<br />
            <strong style="font-size:50px">'.$emp_razsoc.'</strong>
			<br>
            '.$emp_dir.'<br />   <strong>Telf.: '.$emp_tel.'  E-mail.: '.$emp_ema.'</strong> 
			<br />       
		</td>   
	   <td width="" style="text-align:center;border:1px solid #010101;">
         <br>
         <br>
       <strong style="font-size: 40px">'.$tipodoc.'<br>
            RUC: '.$emp_ruc.'<br>
            '.$ven_numDoc.'</strong>
			  <br>
        </td>
    </tr>
</table>

<br />
<br />
<br />

<table style="border-collapse: collapse;" >

    <tr  style="border:1px solid #010101" >
        <td style="text-align: left;font-weight:bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%"><strong>SEÑOR(ES)</strong></td>
        <td style="text-align: left;border:1px solid #010101;padding:15%;font-size:30px" width="55%">'.$cliNom.'</td>

        <td style="text-align: left;font-weight:bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%">VENDEDOR</td>
        <td style="text-align: left;border:1px solid #010101;font-size:30px" width="15%">'.$ven_nom.'</td>
    </tr>
	
    <tr  style="border:1px solid #010101" >
        <td style="text-align: left;font-weight:bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%">RUC</td>
        <td style="text-align: left;border:1px solid #010101;font-size:30px" width="55%">'.$cliDoc.'</td>

        <td style="text-align: left;font-weight:bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%">MONEDA</td>
        <td style="text-align: left;border:1px solid #010101;font-size:30px" width="15%">'.$lblmon.'</td>
    </tr>
	
    <tr>
        <td style="text-align: left;border:1px solid #010101;font-weight:bold;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%">DIRECCIÓN</td>
        <td style="text-align: left;border:1px solid #010101;font-size:30px" width="55%">'.$cliDir.'</td>
		
		<td style="text-align: left;border:1px solid #010101;font-weight:bold;background-color:#bdbdbd;padding:10%;font-size:35px;" width="15%">COND. PAGO</td>
        <td style="text-align: left;border:1px solid #010101;font-size:30px" width="15%">'.$compag.'</td>
    </tr>
</table>

<br />
<br />




<table width="100%;" style="border-collapse: collapse;"  >
    <tbody >
        <tr class="" style="font-weight:bold;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:30px;">
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >FECHA EMISION</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >FECHA VCTO</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >N° COTIZACION</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >N° GUIA</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >FECHA GUIA</th>
        </tr>
		
		<tr style="border:1px solid #010101;padding:10%;font-size:30px;">		
		<td style="border:1px solid #010101;padding:10%;text-align:right;" >'.$ven_fec.'</td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" >'.$fecven.'</td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" >'.$cot_numdoc.'</td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" >'.$guia_numdoc.'</td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" >'.$guia_fec.'</td>		
		</tr>
	
	</tbody>
</table>








<br />
<br />
<br />

<table width="100%;" style="border-collapse: collapse;border:0.9px solid #010101;height:400px;"  >
    <tbody >
        <tr class="" style="font-weight:bold;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:30px;">
            <th style="text-align:center; width:8%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >CODIGO</th>
            <th style="text-align:center; width:40%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >DESCRIPCION</th>
            <th style="text-align:center; width:7%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >U.M.</th>
            <th style="text-align:center; width:5%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >CAN</th>
            <th style="text-align:right; width:10%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >PRE. UNI.</th>			
            <th style="text-align:center; width:10%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >DSC. TOT.</th>
            <th style="text-align:right; width:10%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >PRE. TOT.</th>
            <th style="text-align:right; width:10%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >C/DSC.</th>
        </tr>
';

$dtsdetven=$oVenta->mostrar_venta_detalle($venid);
$cont=1;
while($dt1 = mysqli_fetch_array($dtsdetven))
	{
		$dts1=$oCatalogo->mostrarUno($dt1['tb_catalogo_id'],$dt1['tb_marca_id']);
		$dt = mysqli_fetch_array($dts1);
		
		
		$can = $dt1['tb_ventadetalle_can'];
		$pre_uni=$dt1['tb_ventadetalle_preuni'];
			
		$pre_tot = $pre_uni * $can;
		
		$des_tot = $dt1['tb_ventadetalle_des']*$can;
		
		$pre_tot_cdes = $pre_tot - $des_tot;
		
		$html.='
		<tr style="border:1px solid #010101;padding:10%;font-size:30px;">
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;" >'.$dt1['tb_catalogo_cod'].'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;" >'.$dt1["tb_ventadetalle_nom"].'|'.$dt['tb_marca_nom'].'</td>
		
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;" >'.$dt['tb_unidad_abr'].'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;text-align:right;" >'.$dt1["tb_ventadetalle_can"]*1 .'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;text-align:right;" >'.formato_money($pre_uni).'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;" >'.formato_money($des_tot).'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;text-align:right;" >'.formato_money($pre_tot).'</td>
		<td style="border-right: 0.9px solid #010101;border-left: 0.9px solid #010101;text-align:right;" >'.formato_money($pre_tot_cdes).'</td>
		
		</tr>
		
		';				
		
		$cont++;
	}
	mysqli_free_result($dtsdetven);	




$html.='</tbody>
</table>
<br />
<br />

<table width="100%;" style="border-collapse: collapse;"  >
    <tbody >
        <tr class="" style="font-weight:bold;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;font-size:30px;">
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >OP. INAFECTA</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >OP. EXONERADA</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >OP. GRAVADA</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >TOTAL IGV (18%)</th>
            <th style="text-align:center; width:20%;bold;border:1px solid #010101;background-color:#bdbdbd;padding:10%;" >TOTAL DE VENTA</th>
        </tr>
		
		<tr style="border:1px solid #010101;padding:10%;font-size:30px;">		
		<td style="border:1px solid #010101;padding:10%;text-align:right;" ><strong>'.$mon.' '.'0.00</strong></td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" ><strong>'.$mon.' '.'0.00</strong></td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" ><strong>'.$mon.' '.formato_money($ven_valven).'</strong></td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" ><strong>'.$mon.' '.formato_money($ven_igv).'</strong></td>
		<td style="border:1px solid #010101;padding:10%;text-align:right;" ><strong>'.$mon.' '.formato_money($ven_tot).'</strong></td>		
		</tr>
		
		<tr style="font-size:35px" >
		<td colspan="5" style="border:1px solid #010101;padding:10%;text-align:left;" >SON '.numtoletras($ven_tot).' '.$lblmon.' 
		</td>
		</tr>
	
	</tbody>
</table>

<br />
<br />

<table>
<tr>
<td>NOTA*'.$vehi.'</td>
</tr>
</table>

<br/>
<br/>

';


if($docabr=="T"){

}
else{
$html.=
'
<table width="100%;" style="border-collapse: collapse;"  >


<tr>
<td width="75%;">
<br />
<br />
<br />
<p style="font-size:10pt">
Código de Seguridad (Hash): '.$vendigval.'<br>
Representación Impresa de la '.$tipodoc.'.<br>
Esta puede ser consultada en: <strong>http://e-consulta.sunat.gob.pe/ol-ti-itconsvalicpe/ConsValiCpe.htm</strong><br>
Autorizado mediante Resolucion de Superintendencia SUNAT
</p>
</td>

<td>

';

$style = array(
	'border' => 2,
	'vpadding' => 'auto',
	'hpadding' => 'auto',
	'fgcolor' => array(0,0,0),
	'bgcolor' => false, //array(255,255,255)
	'module_width' => 1, // width of a single module in points
	'module_height' => 1 // height of a single module in points
);

$params = $pdf->serializeTCPDFtagParameters(array($emp_ruc.'|'.$tipcom.'|'.$ser.'|'.$corr.'|'.$ven_igv.'|'.$ven_tot.'|'.$ven_fec.'|'.$tipdoc.'|'.$cliDoc.'|', 'QRCODE,Q', '', '', 40, 40, $style, 'N'));
$html .= '<tcpdf method="write2DBarcode" params="'.$params.'" />
</td>
</tr>
</table>

<br />
<br />';
}



$html.='
</body>
</html>';

$pdf->writeHTML($html, true, 0, true, true);

//$pdf->write2DBarcode($ruc_empresa.'|'.$idcomprobante.'|'.$serie.'|'.$numero.'|'.$toigv.'|'.$importetotal.'|'.fecha_mysql($fecha).'|'.$idtipodni.'|'.$ruc.'|', 'QRCODE,Q', 157, 99, 40, 40, $style, 'N');

$pdf->Output($nombre_archivo, 'I');
