query("select query_id, query_name from ".$_SESSION['tablename']['saved_queries']." where user_id = '".$_SESSION['user']['UserId']."' order by query_name"); $queries = array(); while($res = $conn->fetch_object()) { array_push($queries, array('ID'=>$res->query_id, 'LABEL' => $res->query_name)); } $conn->query("select user_id, firstname, lastname, status from ".$_SESSION['tablename']['users']." where enabled = 'Y' and status <> 'DEL' order by lastname asc"); $users_list = array(); while($res = $conn->fetch_object()) { array_push($users_list, array('ID' => $conn->show_string($res->user_id), 'NOM' => $conn->show_string($res->lastname), 'PRENOM' => $conn->show_string($res->firstname), 'STATUT' => $res->status)); } $coll_id = 'letterbox_coll'; $view = $sec->retrieve_view_from_coll_id($coll_id); $where = $sec->get_where_clause_from_coll_id($coll_id); if(!empty($where)) { $where = ' where '.$where; } //Check if web brower is ie_6 or not if (preg_match("/MSIE 6.0/", $_SERVER["HTTP_USER_AGENT"])) { $browser_ie = 'true'; $class_for_form = 'form'; $hr = '

'; $size = ''; } elseif(preg_match('/msie/i', $_SERVER["HTTP_USER_AGENT"]) && !preg_match('/opera/i', $HTTP_USER_AGENT) ) { $browser_ie = 'true'; $class_for_form = 'forms'; $hr = ''; $size = ''; } else { $browser_ie = 'false'; $class_for_form = 'forms'; $hr = ''; $size = ''; // $size = 'style="width:40px;"'; } // building of the parameters array used to pre-load the category list and the search elements $param = array(); // Indexes specific to doctype $indexes = $type->get_all_indexes($coll_id); for($i=0;$i '', 'LABEL' => _CHOOSE.'...')); for($j=0; $j $indexes[$i]['values'][$j]['id'], 'LABEL' => $indexes[$i]['values'][$j]['label'])); } $arr_tmp2 = array('label' => $indexes[$i]['label'], 'type' => 'select_simple', 'param' => array('field_label' => $indexes[$i]['label'],'default_label' => '', 'options' => $arr_tmp)); } elseif($indexes[$i]['type'] == 'date') { $arr_tmp2 = array('label' => $indexes[$i]['label'], 'type' => 'date_range', 'param' => array('field_label' => $indexes[$i]['label'], 'id1' => $field.'_from', 'id2' =>$field.'_to')); } else if($indexes[$i]['type'] == 'string') { $arr_tmp2 = array('label' => $indexes[$i]['label'], 'type' => 'input_text', 'param' => array('field_label' => $indexes[$i]['label'], 'other' => $size)); } else // integer or float { $arr_tmp2 = array('label' => $indexes[$i]['label'], 'type' => 'num_range', 'param' => array('field_label' => $indexes[$i]['label'], 'id1' => $field.'_min', 'id2' =>$field.'_max')); } $param[$field] = $arr_tmp2; } //Coming date $arr_tmp2 = array('label' => _DATE_START, 'type' => 'date_range', 'param' => array('field_label' => _DATE_START, 'id1' => 'admission_date_from', 'id2' =>'admission_date_to')); $param['admission_date'] = $arr_tmp2; //Loaded date $arr_tmp2 = array('label' => _REG_DATE, 'type' => 'date_range', 'param' => array('field_label' => _REG_DATE, 'id1' => 'creation_date_from', 'id2' =>'creation_date_to')); $param['creation_date'] = $arr_tmp2; //Closing date $arr_tmp2 = array('label' => _CLOSING_DATE, 'type' => 'date_range', 'param' => array('field_label' => _CLOSING_DATE, 'id1' => 'closing_date_from', 'id2' =>'closing_date_to')); $param['closing_date'] = $arr_tmp2; //Document date $arr_tmp2 = array('label' => _DOC_DATE, 'type' => 'date_range', 'param' => array('field_label' => _DOC_DATE, 'id1' => 'doc_date_from', 'id2' =>'doc_date_to')); $param['doc_date'] = $arr_tmp2; //Process limit date $arr_tmp2 = array('label' => _LIMIT_DATE_PROCESS, 'type' => 'date_range', 'param' => array('field_label' => _LIMIT_DATE_PROCESS, 'id1' => 'process_limit_date_from', 'id2' =>'process_limit_date_to')); $param['process_limit_date'] = $arr_tmp2; //destinataire $arr_tmp = array(); for($i=0; $i < count($users_list); $i++) { array_push($arr_tmp, array('VALUE' => $users_list[$i]['ID'], 'LABEL' => $users_list[$i]['NOM']." ".$users_list[$i]['PRENOM'])); } $arr_tmp2 = array('label' => _PROCESS_RECEIPT, 'type' => 'select_multiple', 'param' => array('field_label' => _PROCESS_RECEIPT, 'label_title' => _CHOOSE_RECIPIENT_SEARCH_TITLE, 'id' => 'destinataire','options' => $arr_tmp)); $param['destinataire'] = $arr_tmp2; //mail_natures $arr_tmp = array(); foreach(array_keys($_SESSION['mail_natures']) as $nature) { array_push($arr_tmp, array('VALUE' => $nature, 'LABEL' => $_SESSION['mail_natures'][$nature])); } $arr_tmp2 = array('label' => _MAIL_NATURE, 'type' => 'select_simple', 'param' => array('field_label' => _MAIL_NATURE,'default_label' => addslashes(_CHOOSE_MAIL_NATURE), 'options' => $arr_tmp)); $param['mail_nature'] = $arr_tmp2; //priority $arr_tmp = array(); foreach(array_keys($_SESSION['mail_priorities']) as $priority) { array_push($arr_tmp, array('VALUE' => $priority, 'LABEL' => $_SESSION['mail_priorities'][$priority])); } $arr_tmp2 = array('label' => _PRIORITY, 'type' => 'select_simple', 'param' => array('field_label' => _MAIL_PRIORITY,'default_label' => addslashes(_CHOOSE_PRIORITY), 'options' => $arr_tmp)); $param['priority'] = $arr_tmp2; // dest /*$arr_tmp2 = array('label' => _DEST, 'type' => 'input_text', 'param' => array('field_label' => _DEST, 'other' => $size)); $param['dest'] = $arr_tmp2; //shipper $arr_tmp2 = array('label' => _SHIPPER, 'type' => 'input_text', 'param' => array('field_label' => _SHIPPER, 'other' => $size)); $param['shipper'] = $arr_tmp2; */ if($_SESSION['features']['search_notes'] == 'true') { //annotations $arr_tmp2 = array('label' => _NOTES, 'type' => 'textarea', 'param' => array('field_label' => _NOTES, 'other' => $size)); $param['doc_notes'] = $arr_tmp2; } //tags if($core_tools->is_module_loaded('tags')) { $arr_tmptag = array(); require_once 'modules/tags/class/TagControler.php' ; require_once 'modules/tags/tags_tables_definition.php'; $tag = new tag_controler; $tag_return_value = $tag -> get_all_tags($coll_id); if ($tag_return_value){ foreach($tag_return_value as $tagelem) { array_push($arr_tmptag, array('VALUE' => $conn->protect_string_db($tagelem['tag_label']), 'LABEL' => $tagelem['tag_label'])); } } else { array_push($arr_tmptag, array('VALUE' => '', 'LABEL' => _TAGNONE)); } $param['tag_mu'] = array('label' => _TAG_SEARCH, 'type' => 'select_multiple', 'param' => array('field_label' => _TAG_SEARCH, 'label_title' => _CHOOSE_TAG, 'id' => 'tags','options' => $arr_tmptag)); } //destination (department) if($core_tools->is_module_loaded('entities')) { $where = $sec->get_where_clause_from_coll_id($coll_id); $table = $sec->retrieve_view_from_coll_id($coll_id); if(empty($table)) { $table = $sec->retrieve_table_from_coll($coll_id); } if(!empty($where)) { $where = ' where '.$where; } //$conn->query("select distinct r.destination from ".$table." r join ".$_SESSION['tablename']['ent_entities']." e on e.entity_id = r.destination ".$where." group by r.destination "); $conn->query("select distinct r.destination, e.short_label from ".$table." r join ".$_SESSION['tablename']['ent_entities']." e on e.entity_id = r.destination ".$where." group by e.short_label, r.destination order by e.short_label"); // $conn->show(); $arr_tmp = array(); while($res = $conn->fetch_object()) { array_push($arr_tmp, array('VALUE' => $res->destination, 'LABEL' => $res->short_label)); } $param['destination_mu'] = array('label' => _DESTINATION_SEARCH, 'type' => 'select_multiple', 'param' => array('field_label' => _DESTINATION_SEARCH, 'label_title' => _CHOOSE_ENTITES_SEARCH_TITLE, 'id' => 'services','options' => $arr_tmp)); } // Folder if($core_tools->is_module_loaded('folder')) { $arr_tmp2 = array('label' => _MARKET, 'type' => 'input_text', 'param' => array('field_label' => _MARKET, 'other' => $size)); $param['market'] = $arr_tmp2; $arr_tmp2 = array('label' => _PROJECT, 'type' => 'input_text', 'param' => array('field_label' => _PROJECT, 'other' => $size)); $param['project'] = $arr_tmp2; } //process notes $arr_tmp2 = array('label' => _PROCESS_NOTES, 'type' => 'textarea', 'param' => array('field_label' => _PROCESS_NOTES, 'other' => $size, 'id' => 'process_notes')); $param['process_notes'] = $arr_tmp2; // chrono $arr_tmp2 = array('label' => _CHRONO_NUMBER, 'type' => 'input_text', 'param' => array('field_label' => _CHRONO_NUMBER, 'other' => $size)); $param['chrono'] = $arr_tmp2; //status $status = $status_obj->get_searchable_status(); $arr_tmp = array(); for($i=0; $i < count($status); $i++) { array_push($arr_tmp, array('VALUE' => $status[$i]['ID'], 'LABEL' => $status[$i]['LABEL'])); } array_push($arr_tmp, array('VALUE'=> 'REL1', 'LABEL' =>_FIRST_WARNING)); array_push($arr_tmp, array('VALUE'=> 'REL2', 'LABEL' =>_SECOND_WARNING)); array_push($arr_tmp, array('VALUE'=> 'LATE', 'LABEL' =>_LATE)); // Sorts the $param['status'] array function cmp_status($a, $b) { return strcmp(strtolower($a["LABEL"]), strtolower($b["LABEL"])); } usort($arr_tmp, "cmp_status"); $arr_tmp2 = array('label' => _STATUS_PLUR, 'type' => 'select_multiple', 'param' => array('field_label' => _STATUS,'label_title' => _CHOOSE_STATUS_SEARCH_TITLE,'id' => 'status', 'options' => $arr_tmp)); $param['status'] = $arr_tmp2; //doc_type $conn->query("select type_id, description from " . $_SESSION['tablename']['doctypes'] . " where enabled = 'Y' and coll_id = '" . $coll_id . "' order by description asc" ); $arr_tmp = array(); while ($res=$conn->fetch_object()) { array_push($arr_tmp, array('VALUE' => $res->type_id, 'LABEL' => $conn->show_string($res->description))); } $arr_tmp2 = array('label' => _DOCTYPES, 'type' => 'select_multiple', 'param' => array('field_label' => _DOCTYPE,'label_title' => _CHOOSE_DOCTYPES_SEARCH_TITLE, 'id' => 'doctypes', 'options' => $arr_tmp)); $param['doctype'] = $arr_tmp2; //category $arr_tmp = array(); array_push($arr_tmp, array('VALUE' => '', 'LABEL' => _CHOOSE_CATEGORY)); foreach (array_keys($_SESSION['coll_categories']['letterbox_coll']) as $cat_id) { if ($cat_id <> 'default_category') { array_push( $arr_tmp, array( 'VALUE' => $cat_id, 'LABEL' => $_SESSION['coll_categories']['letterbox_coll'][$cat_id] ) ); } } $arr_tmp2 = array('label' => _CATEGORY, 'type' => 'select_simple', 'param' => array('field_label' => _CATEGORY,'default_label' => '', 'options' => $arr_tmp)); $param['category'] = $arr_tmp2;//Arbox_id ; for physical_archive if ($core_tools->is_module_loaded('physical_archive') == true) { //arbox_id $conn->query("select arbox_id, title from ".$_SESSION['tablename']['ar_boxes']." where status <> 'DEL' order by description asc"); $arr_tmp = array(); while ($res=$conn->fetch_object()) { array_push($arr_tmp, array('VALUE' => $res->arbox_id, 'LABEL' => $conn->show_string($res->title))); } $arr_tmp2 = array('label' => _ARBOXES, 'type' => 'select_multiple', 'param' => array('field_label' =>_ARBOXES,'label_title' => _CHOOSE_BOXES_SEARCH_TITLE, 'id' => 'arboxes', 'options' => $arr_tmp)); $param['arbox_id'] = $arr_tmp2; $arr_tmp2 = array('label' => _ARBATCHES, 'type' => 'input_text', 'param' => array('field_label' => _ARBATCHES, 'other' => $size)); $param['arbatch_id'] = $arr_tmp2; } //Answers types $arr_tmp = array(array('ID' => 'simple_mail','VALUE'=> 'true', 'LABEL' =>_SIMPLE_MAIL),array('ID' => 'AR','VALUE'=> 'true', 'LABEL' =>_REGISTERED_MAIL),array('ID' => 'fax','VALUE'=> 'true', 'LABEL' =>_FAX),array('ID' => 'courriel','VALUE'=> 'true', 'LABEL' =>_MAIL) ,array('ID' => 'direct','VALUE'=> 'true', 'LABEL' =>_DIRECT_CONTACT),array('ID' => 'autre','VALUE'=> 'true', 'LABEL' =>_OTHER),array('ID' => 'norep','VALUE'=> 'true', 'LABEL' =>_NO_ANSWER)); $arr_tmp2 = array('label' => _ANSWER_TYPE, 'type' => 'checkbox', 'param' => array('field_label' => _ANSWER_TYPE, 'checkbox_data' => $arr_tmp)); $param['answer_type'] = $arr_tmp2; // Sorts the param array function cmp($a, $b) { return strcmp(strtolower($a["label"]), strtolower($b["label"])); } uasort($param, "cmp"); $tab = $search_obj->send_criteria_data($param); //$conn->show_array($param); //$conn->show_array($tab); // criteria list options $src_tab = $tab[0]; $core_tools->load_js(); ?>

0) {?>

" alt="" />

is_module_loaded("basket") == true) { ?> is_module_loaded("cases") == true) { ?>

: />
: />
: />

: />
: />
: />
: />
:
:

" alt="" />

'; if($mode == 'popup') { ?>

'; }