89 lines
2.2 KiB
PHP
89 lines
2.2 KiB
PHP
<?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");
|
|
} |