drawRoot($fileplanId, $folderId, "view_folders.php?id=".$fileplanId."&", $_REQUEST['idframe']); $folders->buildTreeView($_GET['action'], $fileplanId, $_REQUEST['idframe'], "view_folders.php?id=".$fileplanId, $folderId, $_GET['do'], $folder_parents); ?>

define_order(); if(empty($orderby)) { $orderby = " ORDER BY priority "; } if(isset($_GET['start'])) { $start = $_GET['start']; } else { $start = 0; } $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 ) ); } } if ($folderId !=-1 || isset($_GET['start'])) { ?> 1) { $next_start = 0; $page_list1 = '

'._GO_TO_PAGE.' '; $page_list2 = '

'._GO_TO_PAGE.'

'; /*$page_list1 = "

"._GO_TO_PAGE." "; $page_list2 = "

"._GO_TO_PAGE."

"; */ $lastpage = 0; for($i = 0;$i <> $nb_pages; $i++) { $page_name = $i + 1; $the_line = $i + 1; if($start == $next_start) { $page_list1 .= "".$the_line.""; $page_list2 .= "".$the_line.""; } else { $page_list1 .= "".$the_line.""; $page_list2 .= "".$the_line.""; } $next_start = $next_start + $nb_show; $lastpage = $next_start; } $lastpage = $lastpage - $nb_show; $previous = ""; $next = ""; if($start > 0) { $start_prev = $start - $nb_show; $previous = ""._PREVIOUS.""; //$previous = "< "._PREVIOUS." "; } if($start <> $lastpage) { $start_next = $start + $nb_show; //$next = " "._NEXT." >"; $next = ""._NEXT.""; } $page_list1 = $page_list1."".$previous." ".$next."

"; $page_list2 = $page_list2."".$previous." ".$next."

"; } ?>
0) { echo ''; } $color = 'class="col"'; for($theline = 0; $theline < count($listarr) ; $theline++) { // background color if($color == 'class="col"') { $color = ""; } else { $color = 'class="col"'; } ?> > 0) { echo ''; } echo "

		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']); ?>		?'));">	?'));">

"; echo "
"; ?>