query("SELECT query_id, query_name FROM ".$_SESSION['tablename']['saved_queries']." WHERE user_id = ? order by query_name", array($_SESSION['user']['UserId'])); $queries = array(); while($res = $stmt->fetchObject()) { array_push($queries, array('ID'=>$res->query_id, 'LABEL' => $res->query_name)); } $stmt = $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 = $stmt->fetchObject()) { array_push($users_list, array('ID' => functions::show_string($res->user_id), 'NOM' => functions::show_string($res->lastname), 'PRENOM' => functions::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; //Creation date pj $arr_tmp2 = array('label' => "("._PJ.") " . _CREATION_DATE, 'type' => 'date_range', 'param' => array('field_label' => "("._PJ.") " . _CREATION_DATE, 'id1' => 'creation_date_pj_from', 'id2' =>'creation_date_pj_to')); $param['creation_date_pj'] = $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; //Type de pièce jointe $arr_tmp = array(); foreach(array_keys($_SESSION['attachment_types']) as $attachment_types) { array_push($arr_tmp, array('VALUE' => $attachment_types, 'LABEL' => $_SESSION['attachment_types'][$attachment_types])); } $arr_tmp2 = array('label' => "("._PJ.") "._ATTACHMENT_TYPES, 'type' => 'select_simple', 'param' => array('field_label' => "("._PJ.") "._ATTACHMENT_TYPES,'default_label' => addslashes(_CHOOSE_ATTACHMENT_TYPE), 'options' => $arr_tmp)); $param['attachment_types'] = $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' => functions::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)); } //thesaurus if($core_tools->is_module_loaded('thesaurus')) { $arr_tmpthesaurus = array(); require_once 'modules/thesaurus/class/class_modules_tools.php' ; $thesaurus = new thesaurus; $thesaurus_list = $thesaurus->getList(); if ($thesaurus_list){ foreach($thesaurus_list as $key=>$value) { array_push($arr_tmpthesaurus, array('VALUE' => functions::protect_string_db($value->thesaurus_id), 'LABEL' => $value->thesaurus_name)); } } else { array_push($arr_tmpthesaurus, array('VALUE' => '', 'LABEL' => _THESAURUSNONE)); } $param['thesaurus_mu'] = array('label' => _THESAURUS, 'type' => 'select_multiple', 'param' => array('field_label' => _THESAURUS, 'label_title' => _CHOOSE_THESAURUS, 'id' => 'thesaurus','options' => $arr_tmpthesaurus)); } //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; } $stmt = $conn->query("SELECT DISTINCT ".$table.".destination, e.short_label FROM ".$table." join ".$_SESSION['tablename']['ent_entities']." e on e.entity_id = ".$table.".destination ".$where." group by e.short_label, ".$table.".destination order by e.short_label"); $arr_tmp = array(); while($res = $stmt->fetchObject()) { 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; // identifier $arr_tmp2 = array('label' => _REFERENCE_MAIL, 'type' => 'input_text', 'param' => array('field_label' => _REFERENCE_MAIL, 'other' => $size)); $param['identifier'] = $arr_tmp2; // description $arr_tmp2 = array('label' => _OTHERS_INFORMATIONS, 'type' => 'input_text', 'param' => array('field_label' => _OTHERS_INFORMATIONS, 'other' => $size)); $param['description'] = $arr_tmp2; // Monitoring number $arr_tmp2 = array('label' => _MONITORING_NUMBER, 'type' => 'input_text', 'param' => array('field_label' => _MONITORING_NUMBER, 'other' => $size)); $param['reference_number'] = $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'])); } /* TO DO : bug a corriger, ne prendre pas en compte les autres statuts selectionnes */ /*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; //confidentifality $arr_tmp = array(); array_push($arr_tmp, array('VALUE'=> 'Y', 'LABEL' =>_YES)); array_push($arr_tmp, array('VALUE'=> 'N', 'LABEL' =>_NO)); $arr_tmp2 = array('label' => _CONFIDENTIALITY, 'type' => 'select_simple', 'param' => array('field_label' => _CONFIDENTIALITY,'id' => 'confidentiality', 'options' => $arr_tmp)); $param['confidentiality'] = $arr_tmp2; //doc_type $stmt = $conn->query("SELECT type_id, description FROM " . $_SESSION['tablename']['doctypes'] . " WHERE enabled = 'Y' and coll_id = ? order by description asc", array($coll_id) ); $arr_tmp = array(); while ($res=$stmt->fetchObject()) { array_push($arr_tmp, array('VALUE' => $res->type_id, 'LABEL' => functions::show_string($res->description))); } $arr_tmp2 = array('label' => _DOCTYPES_MAIL, 'type' => 'select_multiple', 'param' => array('field_label' => _DOCTYPES_MAIL,'label_title' => _CHOOSE_DOCTYPES_MAIL_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; $usergroups_controler = new usergroups_controler(); $array_groups = $usergroups_controler->getAllUsergroups("", false); //signatory group $arr_tmp = array(); for($iGroups=0; $iGroups< count($array_groups);$iGroups++) { array_push($arr_tmp, array('VALUE' => $array_groups[$iGroups]->group_id, 'LABEL' => $array_groups[$iGroups]->group_desc)); } $arr_tmp2 = array('label' => _SIGNATORY_GROUP, 'type' => 'select_simple', 'param' => array('field_label' => _SIGNATORY_GROUP,'default_label' => addslashes(_CHOOSE_GROUP), 'options' => $arr_tmp)); $param['signatory_group'] = $arr_tmp2; // signatory name $arr_tmp2 = array('label' => _SIGNATORY_NAME, 'type' => 'input_text', 'param' => array('field_label' => _SIGNATORY_NAME, 'other' => $size)); $param['signatory_name'] = $arr_tmp2; //Addresses contact externe $arr_tmp2 = array('label' => _ADDRESSES_MAJ, 'type' => 'input_text', 'param' => array('field_label' => _ADDRESSES_MAJ)); $param['addresses_id'] = $arr_tmp2; //contact_type $stmt = $conn->query("SELECT id, label FROM contact_types order by label asc", array()); $arr_tmp = array(); while ($res=$stmt->fetchObject()) { array_push($arr_tmp, array('VALUE' => $res->id, 'LABEL' => functions::show_string($res->label))); } $arr_tmp2 = array('label' => _CONTACT_TYPE, 'type' => 'select_simple', 'param' => array('field_label' => _CONTACT_TYPE,'label_title' => _CONTACT_TYPE, 'id' => 'contact_type', 'options' => $arr_tmp)); $param['contact_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); // criteria list options $src_tab = $tab[0]; //$core_tools->show_array($param); ?>

0) {?>

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

: />
: />
: />

: />
: />

: />
: />
:
:

:

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

'; }