".$_SESSION['info']."";
} */
$folders->drawRoot($fileplanId, $folderId, "folders_put.php?fileplan_id=".$fileplanId."&", $idframe);
$folders->buildTreeView($_GET['action'], $fileplanId, $idframe, "folders_put.php?fileplan_id=".$fileplanId, $folderId, $_GET['do'], $folder_parents);
?>
|
-1 )
{
$courr = new LetterBox();
// configure the sql argument order by
$orderby = $courr->define_order();
if(empty($orderby))
{
$orderby = " ORDER BY priority ";
}
if(isset($_GET['start']))
{
$start = $_GET['start'];
}
else
{
$start = 0;
}
$link = "folders_put.php?fileplan_id=".$fileplanId."&action=".$_GET['action']."&folder_id=".$_REQUEST['folder_id'];
//$link = "view_folders.php?id=".$fileplanId."&action=".$_GET['action']."&folder_id=".$folderId;
$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 = '".$folderId."'";
$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
$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 = ' |