<?php
ob_Start();

use Glpi\Event;
include ('../inc/includes.php');
Session::checkLoginUser();


function get_decharge($id){
			
		global $DB;	

		$query = "SELECT decharge_entete.id_entete as identete,decharge_entete.id_user ,decharge_entete.titre ,
		                 decharge_entete.fonction,decharge_entete.num , decharge_entete.date, decharge_entete.type,
						decharge_entete.date_creation,decharge_entete.date_modification,decharge_lignes.id ,
						decharge_lignes.id_entete,decharge_lignes.designation,decharge_lignes.quantite,
						decharge_lignes.fiche,decharge_lignes.etat
				  FROM decharge_entete
				  LEFT JOIN decharge_lignes ON decharge_entete.id_entete = decharge_lignes.id_entete
				  WHERE decharge_entete.id_entete = ?
				  ORDER BY decharge_lignes.id ASC";		
		$stmt = $DB->prepare($query);

		$stmt->bind_param("i" , $id);

		$stmt->execute();	  
		$result = $stmt->get_result();
		 
		  if ($result->num_rows > 0) {
				 
			   while($row = $result->fetch_assoc()) {
				  $res[] = $row;
				}
			return $res;	
		   }
		   
		return null;
	} 
	
	function get_user($id){
			
		global $DB;	

		$query = "SELECT concat(glpi_users.realname,' ',glpi_users.firstname) as fullname FROM `glpi_users` WHERE id = ?";		
		$stmt = $DB->prepare($query);

		$stmt->bind_param("i" , $id);

		$stmt->execute();	  
		$result = $stmt->get_result();
		 
		  if ($result->num_rows > 0) {
				 
			   while($row = $result->fetch_assoc()) {
				  $res[] = $row;
				}
			return $res[0];	
		   }
		   
		return null;
	} 

	if(filter_var($_GET['id'], FILTER_VALIDATE_INT) === FALSE) Html::redirect($CFG_GLPI["root_doc"]."/front/decharge.list.php");
	if(isset($_GET['id']) && !empty($_GET['id'])){
				
	
		$res = get_decharge($_GET['id']);

        //supprimer UTF-8-BOM
		for ($i = 0; $i <= 31; ++$i) { 
			$res = str_replace(chr($i), "", $res); 
		}
		$res = str_replace(chr(127), "", $res);  
		
		
		//if (0 === strpos(bin2hex($res), 'efbbbf')) { 
		 //  $res = substr($res, 3);
		//}
		//supprimer UTF-8-BOM
		
        if($res != null){
            $user = get_user($res[0]['id_user']);			
			include ('../lib/tcpdf/templates/decharge.php');
		}
		
	}else{
		Html::redirect($CFG_GLPI["root_doc"]."/front/decharge.list.php");	
	}