*/
include("session.php");
require_once("class_db.php");
require_once("class_letterbox.php");
$func = new functions();
if(isset($_GET['start']))
{
$start = $_GET['start'];
}
else
{
$start = 0;
}
/*if(isset($_GET['action']) && !empty($_GET['action']) )
{
if($_GET['action'] == "RED" && count($_SESSION['chosen_doc']) > 0)
{
?>
0)
{
?>
define_order();
if(empty($orderby))
{
$orderby = " ORDER BY priority ";
}
$table = $_SESSION['current_basket']['table'];
$user = $_SESSION['user']['UserId'];
$db = new dbquery();
$db->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 SOCIETE, DESCRIPTION, RES_ID, AUTHOR, TYPE_ID, date(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE1, STATUS, PRIORITY, DESTINATION from ".$table." where ".$_SESSION['current_basket']['clause'].' '.$orderby." limit ".$start.",".$_SESSION['config']['nblinetoshow']);
//$db->show();
$tab = array();
$db2 = new dbquery();
$db2->connect();
while($line = $db->fetch_object())
{
$db2->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$line->DESTINATION."'");
$res = $db2->fetch_object();
$this_line = array(
"OBJET" => stripslashes($line->DESCRIPTION),
"SOCIETE" => stripslashes($line->SOCIETE),
"ID" => $line->RES_ID,
"TYPE" => $line->TYPE_ID,
"ARRIVEE" => $db->inverse_date($line->DATE1),
"EMETTEUR" => stripslashes($line->AUTHOR." ".$line->CUSTOM_T4),
"STATUS"=> $line->STATUS,
"LIMITE" => $db->inverse_date($line->DATE2),
"PRIORITY" => $line->PRIORITY,
"SERVICE" => stripslashes($res->SERVICE));
$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["DEST"] = $func->show($this_line["DEST"],10);
$this_line["EMETTEUR"] = $func->show($this_line["EMETTEUR"],10);
$this_line["SERVICE"] = $func->show($this_line["SERVICE"],15);
$tab[] = $this_line;
}
if($total == 1)
{
$title = $_SESSION['current_basket']['label']." (".$total." document)";
}
else
{
$title = $_SESSION['current_basket']['label']." (".$total." "._DOCUMENTS.")";
}
$courrier->mail_out($tab, $total, $title, $_SESSION['current_basket']['page']);
?>