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();
$core->load_html();
$core->load_header('', true, false);
$collId = $_SESSION['user']['collections'][0];
$resView = $_SESSION['user']['security'][$collId]['DOC']['view'];
$whereClause = $sec->get_where_clause_from_coll_id($_SESSION['collection_id_choice']);
if (trim($whereClause) == "") {
$whereClause = "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 (".$whereClause.")");
$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 (".$whereClause.") 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 (".$whereClause.") 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 (".$whereClause.") 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 (".$whereClause.") 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($searchCustomerResults, array('folder_id' => $res->folder_id,'folder_name' => $res->folder_name, 'folder_subject' => $res->subject, 'content' => $f_level));
}
//print_r($searchCustomerResults);
//$core->show_array($searchCustomerResults);
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.'
';
}
$core->load_js();
?>