<?
/**
* File : copy_mail.php
*
* Mail in copy basket page
*
* @package Maarch LetterBox 2.3
* @version 1.0
* @since 10/2007
* @license GPL
* @author  Claire Figueras  <dev@maarch.org>
*/
 session_name('LetterBox2');                              
  session_start();

require_once("class_letterbox.php");

$_SESSION['origin'] = $_SESSION['current_basket']['page'];
$courrier = new LetterBox();
$orderby = $courrier->define_order();
if(empty($orderby))
{
	$orderby = " ORDER BY priority ";
}

if(isset($_GET['start']))
{
	$start = $_GET['start'];
}
else
{
	$start = 0;
}
$table = $_SESSION['current_basket']['table'];

$db = new dbquery();
$db->connect();

$db->query("select count(*) as TOTAL from  ".$table." r, ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['current_basket']['clause'].' '.$orderby);
$line = $db->fetch_object();
$total = $line->TOTAL;

$db->query("select r.SOCIETE, r.DESCRIPTION, r.RES_ID, r.TYPE_ID, r.IDENTIFIER, date(r.CREATION_DATE) as DATE1, r.AUTHOR, r.CUSTOM_T4, date(r.CUSTOM_D2) as DATE2, r.CUSTOM_T3, r.DEST_USER, r.DESTINATION, r.STATUS, r.PRIORITY from  ".$table." r , ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['current_basket']['clause']." ".$orderby."  limit ".$start.",".$_SESSION['config']['nblinetoshow']);

$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();
	$service = $res->SERVICE;
	$db2->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$line->DEST_USER."'");
	$res = $db2->fetch_object();
	$dest = $res->FIRSTNAME.' '.$res->LASTNAME;
	array_push($tab, array( "SOCIETE" => $line->SOCIETE, "OBJET" => $line->DESCRIPTION, "ID" => $line->RES_ID, "TYPE" => $line->TYPE_ID, "IDENTIFIER" => $line->IDENTIFIER, "PRIORITY" => $line->PRIORITY,
	 "ARRIVEE" => $db->inverse_date($line->DATE1), "STATUS" => $line->STATUS, "SERVICE_ID" => $line->DESTINATION, "SERVICE" => $service,"DEST" => $dest, "CIV" => $line->CUSTOM_T3, "NOM" => $line->AUTHOR, "PRENOM" => $line->CUSTOM_T4, "LIMITE" => $db->inverse_date($line->DATE2)));
}

$title = $_SESSION['current_basket']['label']." (".$total." "._DOCUMENTS.")";

$courrier->list_copy_mail($tab, $total, $title, $_SESSION['current_basket']['page']);

?>