<?php /**
* 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>
*/
                               
include("session.php");

require_once("class_letterbox.php");
$func = new functions();

$_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'];
$_SESSION['origin'] = 'basket';
$db = new dbquery();
$db->connect();

$db2 = new dbquery();
$db2->connect();

$db->query("select count(r.RES_ID) as TOTAL from  ".$table." r, ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['current_basket']['clause'].' '.$orderby);
while($line = $db->fetch_object()) {
	$total = $total + $line->TOTAL;
}
$db->query("select r.SOCIETE, r.DESCRIPTION, r.RES_ID as RES_ID, r.TYPE_ID, r.IDENTIFIER, date(r.CUSTOM_D1) 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, date(r.CREATION_DATE) as DATE2, r.IS_INGOING, l.VIEWED  from  ".$table." r , ".$_SESSION['tablename']['listinstance']." l where l.RES_ID = r.RES_ID AND ".$_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 r.PRIORITY, date(r.CUSTOM_D1) as DATE1, r.RES_ID, r.AUTHOR, r.SOCIETE,r.DEST_USER  from  ".$table." r , ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['current_basket']['clause']." ".$orderby; 
}
else
{
	$_SESSION['print_list']['current_request'] = "select r.PRIORITY, date(r.CUSTOM_D1) as DATE1, r.RES_ID, r.AUTHOR, r.DESCRIPTION,r.DEST_USER  from  ".$table." r , ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['current_basket']['clause']." ".$orderby; 
}

$tab = array();

while($line = $db->fetch_object())
{
	$db2->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$line->DESTINATION."'");
	$res = $db2->fetch_object();
	$service = stripslashes($res->SERVICE);
	
	$db2->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$line->DEST_USER."'");
	$res = $db2->fetch_object();
	$dest = stripslashes($res->FIRSTNAME.' '.$res->LASTNAME);
	
	$this_line = array( 
	"SOCIETE" => stripslashes($line->SOCIETE), 
	"OBJET" => stripslashes($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" => stripslashes($line->AUTHOR), 
	"PRENOM" => stripslashes($line->CUSTOM_T4), 
	"LIMITE" => $db->inverse_date($line->DATE2), 
	"CREATION_DATE" => $line->DATE2, 
	"IS_INGOING" => $line->IS_INGOING, 
	"VIEWED" => $line->VIEWED);
	
	$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["NOM"] = $func->show($this_line["NOM"],10);
	$this_line["SERVICE"] = $func->show($this_line["SERVICE"],15);
		
	$tab[] = $this_line;
}


$title = $_SESSION['current_basket']['label']." (".$total." "._DOCUMENTS.")";

$courrier->list_copy_mail($tab, $total, $title, $_SESSION['current_basket']['page']);


?>