define_order();
if(empty($orderby))
{
$orderby = " ORDER BY priority ";
}
if(isset($_GET['start']))
{
$start = $_GET['start'];
}
else
{
$start = 0;
}
$link = "index.php?page=folders&action=".$_GET['action']."&folder_id=".$s_id;
$db = new dbquery();
$db->connect();
$fields .= "
r.SOCIETE,
r.DESCRIPTION,
r.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";
$table = "res_x";
$join = "inner join ".$_SESSION['tablename']['folderres']." f on r.RES_ID = f.RES_ID ";
$where_clause = "f.FOLDER_ID = '".$s_id."'";
$db->query("select r.RES_ID from ".$table." r ".$join."
inner join ".$_SESSION['tablename']['doctypes']." t on r.TYPE_ID = t.TYPE_ID
where ".$where_clause);
$nb_total = $db->nb_result();
$db->query("select ".$fields." from ".$table." r ".$join."
inner join ".$_SESSION['tablename']['doctypes']." t on r.TYPE_ID = t.TYPE_ID
where ".$where_clause.' '.$orderby."
limit ".$start.",".$_SESSION['config']['nblinetoshow']);
//$db->show();
if($db->nb_result() > 0)
{
$listarr = 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 = 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);
array_push($listarr,
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
)
);
}
}
//$listarr, $nb_total, $title,$name
if ($s_id !=-1)
{
$page_list1 = "";
$page_list2 = "";
if(isset($_REQUEST['order']))
{
$order = strip_tags($_REQUEST['order']);
}
else
{
$order = 0;
}
// define the defaults values
$nb_show = $_SESSION['config']['nblinetoshow'];
$nb_pages = ceil($nb_total/$nb_show);
// if they are more 1 page we do pagination with 2 forms
if($nb_pages > 1)
{
$next_start = 0;
$page_list1 = '";
}
?>
";
}
?>
 |
|
|
|
|
|
|
|---|---|---|---|---|---|---|
|
dateformat($listarr[$theline]['CREATION_DATE']); } else { if("0000-00-00" == $listarr[$theline]['ARRIVEE'] || "00-00-0000" == $listarr[$theline]['ARRIVEE']) { echo $func->dateformat($listarr[$theline]['CREATION_DATE']); } else { echo $func->dateformat($listarr[$theline]['ARRIVEE']); } } ?> | show($listarr[$theline]['ID']); ?> | show($listarr[$theline]['NOM']); ?> | show($listarr[$theline]['OBJET']); ?> | show($listarr[$theline]['DEST']); ?> |