<?php

define('FPDF_FONTPATH','modules/visa/class/font/');
//above line is import to define, otherwise it gives an error : Could not include font metric file
require('modules/visa/class/fpdf.php');
require('modules/visa/class/fpdi.php');
require('modules/visa/class/php-barcode.php');
include('apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR.'definition_mail_categories.php');


require_once "modules" . DIRECTORY_SEPARATOR . "visa" . DIRECTORY_SEPARATOR
			. "class" . DIRECTORY_SEPARATOR
			. "class_modules_tools.php";
if(isset($argv[1])){
	$res_id = $argv[1];
}
else{
	$res_id = $_REQUEST['res_id'];
}

function bordExists($res_id, $coll_id){
	$db = new dbquery();
    $db->connect();
	$db->query("select filename, path,title,res_id  from res_attachments where res_id_master = " . $res_id . " AND status <> 'DEL' and attachment_type = 'routing' order by creation_date asc");
	if ($db->nb_result() > 0) return true;
	return false;
}

function getInfosUser($user_id){
	$db=new dbquery();
	$db->connect();
	$db->query("SELECT firstname, lastname, group_id, entity_id from users u, usergroup_content uc, users_entities ue where u.user_id = '$user_id' AND uc.user_id = u.user_id AND ue.user_id = u.user_id AND ue.primary_entity='Y' AND uc.primary_group = 'Y' ");
	$user = array();
	$res = $db->fetch_object();
	$user['prenom'] = $res->firstname;
	$user['nom'] = $res->lastname;
	$user['groupe'] = $res->group_id;
	$user['entite'] = $res->entity_id;
	return $user;
}

function getOutputName(){
	require_once "core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php";
	require_once "core".DIRECTORY_SEPARATOR."docservers_tools.php";
	require_once 'core/class/docserver_types_controler.php';

	
	$docserv_control = new docservers_controler();
	$docserverTypeControler = new docserver_types_controler();
	
	$docserv = $docserv_control->getDocserverToInsert("letterbox_coll");
	$docserverTypeObject = $docserverTypeControler->get($docserv->docserver_type_id);
	$storeFolder = $docserv->path_template;
	$pathOnDocserver = Ds_createPathOnDocServer(
            $storeFolder
        );
	$storeFolder = str_replace("//", "/", $pathOnDocserver['destinationDir']);
	$pathondocserver = $storeFolder;
	$fname_tab = $docserv_control->getNextFileNameInDocserver($pathondocserver);	
	$outputFile = array();
	$outputFile['filepath'] = $fname_tab['destinationDir'].$fname_tab['fileDestinationName'].".pdf";
	
	$path_bdd=explode("/",$fname_tab['destinationDir']);
	$outputFile['path'] = $path_bdd[count($path_bdd)-4]."#".$path_bdd[count($path_bdd)-3] . "#" . $path_bdd[count($path_bdd)-2]."#";
	$outputFile['filename'] = $fname_tab['fileDestinationName'].".pdf";
	

	return $outputFile;
}

function ajout_bdd($bordereau, $res_id){
	$db = new dbquery();
	$db->connect();
	$title = "Fiche de circulation du document n°".$res_id;

	
	$fingerprint = hash_file(strtolower("SHA256"), $bordereau['filepath']);
	$filesize = filesize ($bordereau['filepath']);
	$date = date("Y-m-d H:i:s").".000";

	if (!bordExists($res_id, 'letterbox_coll')){
		$req =  "INSERT INTO res_attachments (title, type_id, format, typist, creation_date, identifier, docserver_id, path, filename, fingerprint, filesize, status, coll_id,res_id_master,attachment_type) VALUES ('".$title."', '0', 'pdf', '".$_SESSION['user']['UserId']."', '".$date."', '1', 'FASTHD_MAN', '".$bordereau['path']."', '".$bordereau['filename']."', '".$fingerprint."', '".$filesize."', 'TRA', 'letterbox_coll','".$res_id."','routing');";
	}
	else {
		$req =  "UPDATE res_attachments SET path='".$bordereau['path']."', filename='".$bordereau['filename']."', fingerprint='".$fingerprint."', filesize='".$filesize."' WHERE res_id_master = $res_id and attachment_type='routing' ";
	}
	
	$db->query($req, false, true);
}

class ChargePdf extends FPDI
{
	function LoadData($tab)
	{
		// Lecture des lignes du fichier
		$data = array();
		/*foreach($lines as $line)
			$data[] = explode(';',trim($line));*/
		for ($i = 1; $i <= count($tab); $i++){
			$user = getInfosUser($tab[$i]['user_visa']);
			if ($tab[$i]['consigne'] == "") {
				if ($i == count($tab))
					$tab[$i]['consigne'] = "Pour signature";
				else $tab[$i]['consigne'] = "Pour visa";
			}
			
			if (utf8_decode($tab[$i]['date_visa']) == "") $data[] = array(utf8_decode($user['prenom']).' '.utf8_decode($user['nom']).",\n ".utf8_decode($user['groupe']),utf8_decode($tab[$i]['consigne']),'','');
			else {
				$date_visa = explode(" ",$tab[$i]['date_visa']);
				$date = explode("-",$date_visa[0]);
				
				$data[] = array(utf8_decode($user['prenom']).' '.utf8_decode($user['nom']).",\n ".utf8_decode($user['groupe']),utf8_decode($tab[$i]['consigne']),$date[2]."/".$date[1]."/".$date[0],utf8_decode('Visé'));
			}
		}
		for ($j = 0; $j < 2; $j++){
			$data[] = array('','','','');
		}
		return $data;
	}

	var $widths;
	var $aligns;

	function SetWidths($w)
	{
		$this->widths=$w;
	}

	function SetAligns($a)
	{
		$this->aligns=$a;
	}

	function Row($data)
	{
		//Calcule la hauteur de la ligne
		$nb=0;
		for($i=0;$i<count($data);$i++)
			$nb=max($nb,$this->NbLines($this->widths[$i],$data[$i]));
		$h=5*$nb;
		$this->CheckPageBreak($h);
		for($i=0;$i<count($data);$i++)
		{
			$w=$this->widths[$i];	
			$a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
			$x=$this->GetX();$y=$this->GetY();
			$this->Rect($x,$y,$w,$h);
			$this->MultiCell($w,5,$data[$i],0,$a);
			$this->SetXY($x+$w,$y);
		}
		$this->Ln($h);
	}

	function CheckPageBreak($h)
	{
		if($this->GetY()+$h>$this->PageBreakTrigger)$this->AddPage($this->CurOrientation);
	}

		
	function NbLines($w,$txt)
	{
		$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;
	}
}


$pdf = new ChargePdf();


$data = get_general_data('letterbox_coll', $res_id, 'full');

$pageCount = $pdf->setSourceFile($_SESSION['modules_loaded']['visa']['routing_template']);
$tplIdx = $pdf->importPage(1);
$pdf->addPage();
$pdf->useTemplate($tplIdx);

$db = new dbquery();
$db->connect();
$db->query("select alt_identifier, identifier from res_view_letterbox where res_id = " . $res_id);
$res = $db->fetch_object();
$resChrono = $res->alt_identifier;
$barcode = /*$res->identifier;*/'BORD'.str_replace("/","",$resChrono);
	
	
$pdf->SetY(10);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(0,14,utf8_decode($data['destination']['show_value']), 0, 0, 'C');

$pdf->SetY(36);
$pdf->SetX(43);
$pdf->SetFont('Arial','B',11);
$pdf->Cell(0,12,'BORD_'.str_replace("/","_",$resChrono), 0);

$pdf->SetX(122);
$pdf->SetFont('Arial','B',11);
$pdf->Cell(0,12,date('d/m/Y'), 0);


$pdf->SetY(50);
$pdf->SetX(45);
$pdf->SetFont('Arial','B',11);
$pdf->Cell(0,12,utf8_decode($data['exp_contact_id']['show_value']), 0);


$pdf->SetY(55);
$pdf->SetX(45);
$pdf->SetFont('Arial','B',11);
$pdf->Cell(0,12,utf8_decode($data['subject']['show_value']), 0);


$circuit_visa = new visa();
$workflow = $circuit_visa->getVisaWorkflow($res_id,"letterbox_coll");

$data = $pdf->LoadData($workflow);
$header = array('Nom', 'Consigne', 'Date', 'Visa');
$pdf->SetFont('Arial','B',12);
$pdf->SetY(75);
//$pdf->Table($header, $data);
$pdf->SetWidths(array(60,80,30,15));
$pdf->SetAligns(array('C','C','C','C'));
$pdf->Row(array('Nom', 'Consigne', 'Date', 'Visa'));
$pdf->SetAligns(array('L','L','C','C'));
$pdf->SetFont('Arial','',10);
foreach($data as $d){
	$pdf->Row($d);
}

  
$out = getOutputName();
$pdf->Output($out['filepath'], 'F');

ajout_bdd($out,$res_id);
echo "{status : 1,path:'".$out['filepath']."',code:'".$barcode."'}";
exit();
?>