*/
include("session.php");
require_once("class_letterbox.php");
require_once("class_workflow.php");
$func = new functions();
//$_SESSION['origin'] = $_SESSION['current_basket']['page'];
if( !isset($_SESSION['reload']) || !$_SESSION['reload'] )
$_SESSION['origin'] = 'basket';
else
unset($_SESSION['reload']);
$courr = new LetterBox();
$orderby = $courr->define_order();
if(isset($_GET['start']))
{
$start = $_GET['start'];
}
else
{
$start = 0;
}
if(isset($_GET['action']) && !empty($_GET['action']) )
{
if($_GET['action'] == "VAL" && count($_SESSION['chosen_doc']) > 0)
{
?>
0)
{
?>
0)
{
?>
0)
{
?>
connect();
$db2 = new dbquery();
$db2->connect();
$db->query("select count(*) as TOTAL from ".$table." where ".$_SESSION['current_basket']['clause'].' '.$orderby);
$line = $db->fetch_object();
$total = $line->TOTAL;
$db->query("select DESCRIPTION, RES_ID, TYPE_ID, STATUS, DEST_USER, IDENTIFIER, date(CREATION_DATE) as DATE1, AUTHOR, CUSTOM_T4, date(CUSTOM_D2) as DATE2, CUSTOM_T3, DESTINATION, SOCIETE from ".$table." where ".$_SESSION['current_basket']['clause']." ".$orderby." limit ".$start.",".$_SESSION['config']['nblinetoshow']);
if ($_SESSION['config']['corporate'] == "true" && $_SESSION['config']['replace_subject_by_society'] == "true")
{
$_SESSION['print_list']['current_request'] = "select date(CREATION_DATE) as DATE1, RES_ID, DESTINATION, SOCIETE, AUTHOR, date(CUSTOM_D2) as DATE2 from ".$table." where ".$_SESSION['current_basket']['clause']." ".$orderby;
}
else
{
$_SESSION['print_list']['current_request'] = "select date(CREATION_DATE) as DATE1, RES_ID, DESTINATION, DESCRIPTION, AUTHOR, date(CUSTOM_D2) as DATE2 from ".$table." where ".$_SESSION['current_basket']['clause']." ".$orderby;
}
$tab = array();
$isreserved = false;
while($line = $db->fetch_object())
{
$isreserved = $courr->test_reserved_time($line->RES_ID, $table);
if($isreserved == null)
{
$user = '';
$reserved = 'N';
}
else
{
$user = '';
$reserved = 'Y';
$db2->query("SELECT FIRSTNAME,LASTNAME from ".$_SESSION['tablename']['users']." WHERE user_id = '".$isreserved."'");
if($db2->nb_result() > 0)
{
$res2 = $db2->fetch_object();
$user = $res2->FIRSTNAME." ".$res2->LASTNAME;
}
}
$db2->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$line->DESTINATION."'");
$res2 = $db2->fetch_object();
$this_line = array(
"OBJET" => stripslashes($line->DESCRIPTION),
"SHIPPER" => stripslashes($line->AUTHOR),
"ID" => $line->RES_ID,
"TYPE" => $line->TYPE_ID,
"IDENTIFIER" => $line->IDENTIFIER,
"ARRIVEE" => $db->inverse_date($line->DATE1),
"CIV" => $line->CUSTOM_T3,
"NOM" => stripslashes($line->AUTHOR),
"PRENOM" => stripslashes($line->CUSTOM_T4),
"SERVICE_ID" => $res2->SERVICE,
"LIMITE" => $db->inverse_date($line->DATE2),
"SOCIETE" => stripslashes($line->SOCIETE),
"STATUS" => $line->STATUS ,
"USER" => $user,
"RESERVED" => $reserved,
"BY_USER_ID" => $isreserved);
$this_line["SOCIETE"] = $func->show($this_line["SOCIETE"],15);
$this_line["OBJET"] = $func->show($this_line["OBJET"],15);
$this_line["TYPE"] = $func->show($this_line["TYPE"],12);
$this_line["PRIORITY"] = $func->show($_SESSION['priority'][$this_line["PRIORITY"]]['label'],8);
$this_line["USER"] = $func->show($this_line["USER"],12);
$this_line["SHIPPER"] = $func->show($this_line["SHIPPER"],10);
$this_line["SERVICE_ID"] = $func->show($this_line["SERVICE_ID"],15);
$tab[] = $this_line;
}
$title = $_SESSION['current_basket']['label']." (".$total." "._DOCUMENTS.")";
$courr->validate_list($tab, $total, $title, $_SESSION['current_basket']['page']);
//$wf = new workflow();
//$wf->load_workflow()
?>