load_lang();
$sec = new security();
$func = new functions();
$db = new dbquery();
$db->connect();
$dbTmp = new dbquery();
$dbTmp->connect();
$db1 = new dbquery();
$db1->connect();
$db2 = new dbquery();
$db2->connect();
$db3 = new dbquery();
$db3->connect();
$db4 = new dbquery();
$db4->connect();
$nb_trees = count($_SESSION['user']['trees']);
$core_tools->load_html();
$core_tools->load_header();
//Définition de la collection en dur
//print_r($_REQUEST);exit;
$res_view = $_SESSION['user']['security'][0]['view'];
$coll_id = $_SESSION['user']['security'][0]['coll_id'];
$where_clause = $sec->get_where_clause_from_coll_id($_SESSION['collection_id_choice']);
if(trim($where_clause) == "")
{
$where_clause = "1=1";
}
?>
'')
{
$_SESSION['chosen_name_folder'] = $folderSystemId;
$dbTmp->query("select distinct folder_id, folder_name, subject, folder_level, folders_system_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$folderSystemId);
//$dbTmp->show();
while($resTmp = $dbTmp->fetch_object())
{
if($resTmp->folder_level == '1')
{
$db->query("select distinct folder_id, folder_name, subject, folder_level, folders_system_id from ".$_SESSION['tablename']['fold_folders']." where parent_id = ".$resTmp->folders_system_id." or folders_system_id = ".$folderSystemId." order by folder_name");
$flagProject = true;
}
else
{
$db->query("select distinct folder_id, folder_name, subject, folder_level, folders_system_id, parent_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$folderSystemId." order by folder_name");
}
}
}
//$actual_custom_result = $db->fetch_object();
//$actual_custom_t1 = $actual_custom_result->folder_id;
if(isset($_SESSION['chosen_name_folder']) && !empty($_SESSION['chosen_name_folder']))
{
?>
fetch_object())
{
$actual_custom_t1 = $res->folder_id;
//echo $actual_custom_t1."
";
if($flagProject)
{
$dbTmp->query("select folder_name, subject from ".$_SESSION['tablename']['fold_folders']." where folder_name = '".$_REQUEST['name_folder']."'");
$resTmp = $dbTmp->fetch_object();
$idProject = $resTmp->folder_name;
$labelProject = $resTmp->subject;
}
else
{
$dbTmp->query("select folder_name, subject from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$res->parent_id."");
$resTmp = $dbTmp->fetch_object();
$idProject = $resTmp->folder_name;
$labelProject = $resTmp->subject;
}
$db4->query("select count(res_id) as cptresult from ".$_SESSION['collections'][0]['view']." where folder_id = '".$actual_custom_t1."' and (".$where_clause.")");
$rescpt4 = $db4->fetch_object();
if($rescpt4->cptresult > 150)
{
$error = "
Passez SVP par la recherche avancée ou la recherche de dossiers, le nombre de documents demandé est trop important (".$rescpt4->cptresult.")
";
break;
}
$f_level = array();
$db1->query("select distinct doctypes_first_level_id, doctypes_first_level_label from ".$_SESSION['collections'][0]['view']." where folder_id = '".$actual_custom_t1."' and (".$where_clause.") order by doctypes_first_level_label asc");
//$db1->show();
while($res1 = $db1->fetch_object())
{
$s_level = array();
$db2->query("select distinct doctypes_second_level_id, doctypes_second_level_label from ".$_SESSION['collections'][0]['view']." where (doctypes_first_level_id = ".$res1->doctypes_first_level_id." and folder_id = '".$actual_custom_t1."') and (".$where_clause.") order by doctypes_second_level_label desc");
//$db2->show();
//echo $res1->doctypes_first_level_label."
";
while($res2 = $db2->fetch_object())
{
$doctypes = array();
//echo " ".$res2->doctypes_second_level_label."
";
$db3->query("select distinct type_id, type_label as description from ".$_SESSION['collections'][0]['view']." where (doctypes_first_level_id = ".$res1->doctypes_first_level_id." and doctypes_second_level_id = ".$res2->doctypes_second_level_id." and folder_id = '".$actual_custom_t1."') and (".$where_clause.") order by type_label desc");
//$db3->show();
while($res3 = $db3->fetch_object())
{
//Dépot des documents
$results = array();
//echo " ".$res3->description."
";
$cptDoc=0;
$db4->query("select res_id, doc_date, folder_name, identifier, subject from ".$_SESSION['collections'][0]['view']." where (type_id = ".$res3->type_id." and folder_id = '".$actual_custom_t1."') and (".$where_clause.") order by doc_date desc");
//$db4->show();
while($res4 = $db4->fetch_object())
{
/*$foundDoc = false;
if($_REQUEST['name_folder'] <> "" && $res4->folder_name == $_REQUEST['name_folder'])
{
//$foundDoc = true;
}
if($foundDoc)
{
$directResId = $res4->res_id;
}*/
array_push($results, array('res_id' => $res4->res_id, 'doc_date' => $res4->doc_date, 'name_folder' => $res4->folder_name, 'num_ref' => $res4->identifier, 'found_doc' => $foundDoc, 'subject' => $func->show_string($res4->subject, true)));
$cptDoc++;
}
if($cptDoc == 0)
{
//array_push($doctypes, array('type_id' => $res3->type_id, 'description' => $func->show_string($res3->description), "results" => $results, "no_doc" => true ));
}
else
{
array_push($doctypes, array('type_id' => $res3->type_id, 'description' => $func->show_string($res3->description, true), "results" => $results, "no_doc" => false ));
}
}
array_push($s_level, array('doctypes_second_level_id' => $res2->doctypes_second_level_id, 'doctypes_second_level_label' => $func->show_string($res2->doctypes_second_level_label, true), 'doctypes' => $doctypes));
}
//$func->show_array($s_level);
array_push($f_level, array('doctypes_first_level_id' => $res1->doctypes_first_level_id, 'doctypes_first_level_label' => $func->show_string($res1->doctypes_first_level_label, true), 'second_level' => $s_level));
}
array_push($search_customer_results, array('folder_id' => $res->folder_id,'folder_name' => $res->folder_name, 'folder_subject' => $res->subject, 'content' => $f_level));
}
//print_r($search_customer_results);
//$core_tools->show_array($search_customer_results);
if($idProject <> "")
{
echo " ".$labelProject." (".$idProject.")";
}
?>
"")
{
?>
'._NO_RESULTS.'
';
echo '
'._TO_SEARCH_DEFINE_A_SEARCH_ADV.'
';
}
if($error <> "")
{
echo $error;
}
}
else
{
echo '
'._TO_SEARCH_DEFINE_A_SEARCH_ADV.'
';
}
?>