*/
include("session.php");
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
require_once("fpdf.php");
require_once("class_functions.php");
require_once("class_db.php");
$table = "res_x";
if(isset($_GET['id']) && !empty($_GET['id'])){
$db = new dbquery();
$db->connect();
$db->query("SELECT * FROM ".$_SESSION['tablename']['tickets']." WHERE TICKET_ID = '".$_GET['id']."' ");
if($db->nb_result() == 0)
{
?>
fetch_object();
$PDF = new FPDF();
$position = 'P';
$PDF->AddPage($position);
//Police Arial normal 12
$PDF->SetFont('Arial','B',11);
define('_LINE_HEIGHT', 5);
$PDF->Cell(130, _LINE_HEIGHT, $_SESSION['tycketName'], 0, 0, 'L', false);
$PDF->Cell(120, _LINE_HEIGHT, html_entity_decode(_TICKET_EXERCICE).' : '.$line->EXERCICE, 0, 1, 'L', false);
$PDF->Cell(120, _LINE_HEIGHT, html_entity_decode(_DEPARTMENT).' : '.utf8_decode(stripslashes($_SESSION['user']['department_label'])), 0, 1, 'L', false);
$PDF->Ln(5);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_TICKET_TREAT_BY).' : ', 0, 0, 'R', false);
$PDF->Cell(120, _LINE_HEIGHT, utf8_decode($_SESSION['user']['FirstName']).' '.utf8_decode($_SESSION['user']['LastName']), 0, 1, 'L', false);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_TICKET).' '.html_entity_decode(_NUM).' : ', 0, 0, 'R', false);
$PDF->Cell(120, _LINE_HEIGHT, utf8_decode(stripslashes($line->TICKET_ID)), 0, 1, 'L', false);
$PDF->Ln(8);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_TICKET_MARKET), 0, 0, 'L', false);
$x = $PDF->GetX();
$y = $PDF->GetY();
$PDF->SetFillColor(255,255,255);
$PDF->Rect($x, $y, _LINE_HEIGHT-1, _LINE_HEIGHT-1, 'DF');
$numMarche = '';
if($line->IS_ADAPTED == 'Y' ){
$PDF->SetFillColor(0,0,0);
$PDF->Rect($x+1, $y+1, _LINE_HEIGHT-3, _LINE_HEIGHT-3, 'DF');
$numMarche = $line->MARKET_NUM;
}
$PDF->SetXY($x+_LINE_HEIGHT, $y);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_TICKET_ADAPTED), 0, 0, 'L', false);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_NUM).$numMarche, 0, 1, 'L', false);
$PDF->Ln(2);
$PDF->Cell(50, _LINE_HEIGHT, '', 0, 0, 'L', false);
$x = $PDF->GetX();
$y = $PDF->GetY();
$PDF->SetFillColor(255,255,255);
$PDF->Rect($x, $y, _LINE_HEIGHT-1, _LINE_HEIGHT-1, 'DF');
$numMarche = '';
if($line->IS_FORMALIZED == 'Y' ){
$PDF->SetFillColor(0,0,0);
$PDF->Rect($x+1, $y+1, _LINE_HEIGHT-3, _LINE_HEIGHT-3, 'DF');
$numMarche = $line->MARKET_NUM;
}
$PDF->SetXY($x+_LINE_HEIGHT, $y);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_TICKET_FORMALIZED), 0, 0, 'L', false);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_NUM).$numMarche, 0, 1, 'L', false);
$PDF->Ln(10);
$PDF->SetFillColor(255,255,255);
$PDF->Rect($PDF->GetX(), $PDF->GetY(), 120, _LINE_HEIGHT*5, 'D');
$PDF->SetY($PDF->GetY()+2);
$PDF->Cell(40, _LINE_HEIGHT, html_entity_decode(_TICKET_ACCOUNT_TO_CREDIT).' : ', 0, 0, 'L', false);
$PDF->MultiCell(80, _LINE_HEIGHT, utf8_decode(stripslashes($line->CREDIT_ACCOUNT)), 0, 'L', false);
$PDF->Ln(25);
//$PDF->Rect($PDF->GetX(), $PDF->GetY(), 120, _LINE_HEIGHT, 'D');
$PDF->Cell(120, _LINE_HEIGHT, str_replace('’', "'", html_entity_decode(_TICKET_INVENTORY_IDTIFICATION)), 1, 1, 'L', false);
$PDF->MultiCell(120, _LINE_HEIGHT, utf8_decode(stripslashes($line->INVENTORY_IDENT)), 1, 'L', false);
$PDF->Ln(10);
$y = $PDF->GetY();
$PDF->MultiCell(40, _LINE_HEIGHT*2, html_entity_decode(_TICKET_IMPUTATION), 1, 'C', false);
$x = $PDF->GetX()+40;
$PDF->SetXY($x, $y);
$PDF->MultiCell(60, _LINE_HEIGHT*2, html_entity_decode(_TICKET_MARKET_SUBJECT), 1, 'C', false);
$x += 60;
$PDF->SetXY($x, $y);
$PDF->MultiCell(50, _LINE_HEIGHT*2, html_entity_decode(_TICKET_HOLDER), 1, 'C', false);
$x += 50;
$PDF->SetXY($x, $y);
$PDF->MultiCell(40, _LINE_HEIGHT, html_entity_decode(_TICKET_ACCOUNT_TO_MANDATE), 1, 'C', false);
$y = $PDF->GetY();
$PDF->MultiCell(40, _LINE_HEIGHT*2, utf8_decode(stripslashes($line->IMPUTATION)), 1, 'C', false);
$x = $PDF->GetX()+40;
$PDF->SetXY($x, $y);
$PDF->MultiCell(60, _LINE_HEIGHT*2, utf8_decode(stripslashes($line->MARKET_SUBJECT)), 1, 'C', false);
$x += 60;
$PDF->SetXY($x, $y);
$PDF->MultiCell(50, _LINE_HEIGHT*6, utf8_decode(stripslashes($line->HOLDER)), 1, 'C', false);
$x += 50;
$PDF->SetXY($x, $y);
$PDF->MultiCell(40, _LINE_HEIGHT*6, utf8_decode(stripslashes($line->AMOUNT_TO_MANDATE)), 1, 'C', false);
$y += _LINE_HEIGHT*2;
$PDF->SetY($y);
$PDF->MultiCell(40, _LINE_HEIGHT*2, html_entity_decode(_TICKET_ENGAGEMENT), 1, 'C', false);
$x = $PDF->GetX()+40;
$PDF->SetXY($x, $y);
$PDF->MultiCell(60, _LINE_HEIGHT*2, html_entity_decode(_TICKET_MARKET_ACCOUNT), 1, 'C', false);
$y = $PDF->GetY();
$PDF->MultiCell(40, _LINE_HEIGHT*2, utf8_decode(stripslashes($line->ENGAGEMENT)), 1, 'C', false);
$x = $PDF->GetX()+40;
$PDF->SetXY($x, $y);
$PDF->MultiCell(60, _LINE_HEIGHT*2, utf8_decode(stripslashes($line->TOTAL_MARKET)), 1, 'C', false);
$PDF->Ln(10);
$db2 = new dbquery();
$db2->connect();
$db2->query("SELECT * FROM ".$_SESSION['tablename']['tickets_amounts']." WHERE TICKET_ID = '".$_GET['id']."'");
if($db2->nb_result() > 0){
$PDF->Cell(170, _LINE_HEIGHT, html_entity_decode(_TICKET_HOLD_ACCOUNT), 1, 1, 'C', false);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_NUM.' '._TICKET_OF_ACCOUNT), 1, 0, 'C', false);
$PDF->Cell(80, _LINE_HEIGHT, html_entity_decode(_TICKET_NUM_DATE_OF_MANDATE), 1, 0, 'C', false);
$PDF->Cell(40, _LINE_HEIGHT, html_entity_decode(_TICKET_ACCOUNT), 1, 1, 'C', false);
$PDF->SetFont('Arial','',11);
$montantTotal = 0;
$i = 1;
while($line2 = $db2->fetch_object()){
$montantTotal += floatval($line2->AMOUNT);
$PDF->Cell(50, _LINE_HEIGHT, $i++, 1, 0, 'C', false);
$PDF->Cell(80, _LINE_HEIGHT, $line2->NUM_MANDATE . ' - '.$db2->format_date($line2->DATE_MANDATE), 1, 0, 'C', false);
$PDF->Cell(40, _LINE_HEIGHT, $line2->AMOUNT, 1, 1, 'C', false);
}
$PDF->SetFont('Arial','B',11);
$PDF->Cell(50, _LINE_HEIGHT, '', 1, 0, 'C', false);
$PDF->Cell(80, _LINE_HEIGHT, html_entity_decode(_TICKET_TOTAL), 1, 0, 'R', false);
$PDF->Cell(40, _LINE_HEIGHT, $montantTotal, 1, 1, 'C', false);
$PDF->Ln(10);
}
$PDF->SetFont('Arial','',11);
$PDF->Cell(120, _LINE_HEIGHT, html_entity_decode(_TICKET_JUSTIFICATION_FILES), 0, 0, 'R', false);
$x = $PDF->GetX();
$y = $PDF->GetY();
$PDF->SetFillColor(255,255,255);
$PDF->Rect($x, $y, _LINE_HEIGHT-1, _LINE_HEIGHT-1, 'DF');
if($line->PIECE == 'Y' ){
$PDF->SetFillColor(0,0,0);
$PDF->Rect($x+1, $y+1, _LINE_HEIGHT-3, _LINE_HEIGHT-3, 'DF');
}
$PDF->SetXY($x+_LINE_HEIGHT, $y);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_YES), 0, 0, 'L', false);
$PDF->Ln(5);
$PDF->Cell(120, _LINE_HEIGHT, '', 0, 0, 'L', false);
$x = $PDF->GetX();
$y = $PDF->GetY();
$PDF->SetFillColor(255,255,255);
$PDF->Rect($x, $y, _LINE_HEIGHT-1, _LINE_HEIGHT-1, 'DF');
if($line->PIECE == 'N' ){
$PDF->SetFillColor(0,0,0);
$PDF->Rect($x+1, $y+1, _LINE_HEIGHT-3, _LINE_HEIGHT-3, 'DF');
}
$PDF->SetXY($x+_LINE_HEIGHT, $y);
$PDF->Cell(50, _LINE_HEIGHT, html_entity_decode(_NO), 0, 0, 'L', false);
//$PDF->Output(); die;
$nomFichier = 'Bordereau_'.$line->TICKET_ID.'.pdf';
$tmpPath = 'tmp/'.$nomFichier;
$the_ext = 'pdf';
$PDF->Output($tmpPath);
require("load_extensions.php");
$ext_ok = false;
for($i=0;$i
connect();
$conn->query("SELECT DOCSERVER_ID, PATH_TEMPLATE, SIZE_LIMIT, ACTUAL_SIZE FROM ".$_SESSION['tablename']['docservers']." WHERE IS_READONLY = 'N' AND ENABLED = 'Y' ");
if($conn->nb_result() == 0)
{
?>
fetch_object();
$docserver_id = $info->DOCSERVER_ID;
$tailleFichier = filesize($tmpPath);
$docserver_size = $info->ACTUAL_SIZE + filesize($tmpPath);
if($info->SIZE_LIMIT > 0 && $docserver_size >= $info->SIZE_LIMIT)
{
?>
PATH_TEMPLATE;
require("class_docserver.php");
$docserver = new docserver();
$result = $docserver->store($docserver_id,$path_template,$tmpPath,$the_ext,$tailleFichier);
if( !is_array($result) || count($result) < 2 )
{
?>
query("INSERT INTO ".$table." ( TITLE, RELATION, DESCRIPTION, FORMAT, CREATION_DATE,
DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, STATUS, TYPIST,
TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, SOURCE, GID_ID, ORIGIN )
VALUES
('".addslashes($nomFichier)."', '".$_SESSION['courrier']['res_id']."','".addslashes($_SESSION['courrier']['description'])."', '".strtoupper($the_ext)."', now() , '".$modified_doc_date."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)
."',".$tailleFichier
.",'REP','".$_SESSION['user']['UserId']
."','".$_SESSION['courrier']['type_id']."','".addslashes($_SESSION['courrier']['civ'])."',
'".addslashes($_SESSION['courrier']['prenom'])."', '".addslashes($_SESSION['courrier']['author'])."',
'".$modified_custom_d1."', '".$modified_custom_d2."' ,
'".addslashes($_SESSION['courrier']['service'])."', '".$_SESSION['courrier']['dest']."', 'Local File', 'R".date('Y').$_REQUEST['gid_id']."', '".$_GET['id']."' )");
$conn->query("select res_id from ".$table." where DOCSERVER_ID = '".$docserver_id."' and PATH = '".$destination_rept."' and FILENAME = '".$file_destination_name.".".strtolower($the_ext)."'" );
$res = $conn->fetch_object();
$id_rep = $res->res_id;
$conn->query("update ".$table." set fingerprint = '".$md5."' where res_id = ".$id_rep);
if($_SESSION['history']['resadd'] == "true")
{
require_once("class_history.php");
$users = new history();
$users->add($table, $_SESSION['courrier']['res_id'],"ADD", _TICKET_ADDITION." : ".$_SESSION['courrier']['identifier']." (".$_SESSION['courrier']['type_id'].")");
}
unset($_SESSION['courrier']['reponses']);
$_SESSION['courrier']['reponses'] = array();
$db->query("select RES_ID, TITLE, CREATION_DATE, SOURCE, ORIGIN from ".$table." where RELATION = '".$_SESSION['courrier']['res_id']."' order by CREATION_DATE asc ");
while($line = $db->fetch_object())
{
array_push($_SESSION['courrier']['reponses'], array( "ID" => $line->RES_ID, "TITRE" => stripslashes($line->TITLE), "DATE" => $line->CREATION_DATE, 'SOURCE' => $line->SOURCE, "TICKET" => $line->ORIGIN));
}
}
}
}
}
}
$_SESSION['error'] = '';
?>