* @author Claire Figueras */ require("test_page.php"); require_once("class_db.php"); require_once("class_search.php"); require_once("class_domains.php"); if(!isset($_SESSION['where'])) { $_SESSION['where'] = array(); } if(!isset($_SESSION['format'])) { $_SESSION['format'] = array(); } $_SESSION['tablechoice'] = ""; $_SESSION['search'] = ""; $func = new functions(); $conn = new dbquery(); $conn->connect(); $search_obj = new search(); // load saved queries for the current user in an array $conn->query("select query_id, query_name from ".$_SESSION['tablename']['saved_queries']." where user_id = '".$_SESSION['user']['UserId']."'"); $queries = array(); while($res = $conn->fetch_object()) { array_push($queries, array('ID'=>$res->query_id, 'LABEL' => $res->query_name)); } $sql_users_list = "select USER_ID, FIRSTNAME, LASTNAME, STATUS from ".$_SESSION['tablename']['users']." where ENABLED = 'Y' AND STATUS <> 'DEL' "; if($_SESSION['config']['show_only_elu_in_mailing_list'] == 'true') $sql_users_list .= " AND ELU = 'Y' "; $sql_users_list .= " order by LASTNAME asc"; $conn->query($sql_users_list); $users_list = array(); while($res = $conn->fetch_object()) { array_push($users_list, array('ID' => $res->USER_ID, 'NOM' => $res->LASTNAME, 'PRENOM' => $res->FIRSTNAME, 'STATUT' => $res->STATUS)); } //Check if web brower is ie_6 or not if (ereg("MSIE 6.0", $_SERVER["HTTP_USER_AGENT"])) { $browser_ie = 'true'; $class_for_form = 'form'; $hr = '

'; $size = ''; } elseif(eregi('msie', $_SERVER["HTTP_USER_AGENT"]) && !eregi('opera', $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(); //FULLTEXT START $param['fulltext'] = array('label' => _PLAIN_TEXT, 'type' => 'input_text', 'param' => array('field_label' => _PLAIN_TEXT, 'other' => $size)); //FULLTEXT END if($_SESSION['config']['corporate'] == "false" && $_SESSION['config']['borough'] == "false") { //Address $arr_tmp = array(); for($i=0; $i < count($_SESSION['quartiers']); $i++) { array_push($arr_tmp, array('VALUE' => $_SESSION['quartiers'][$i], 'LABEL' => $_SESSION['quartiers'][$i])); } $arr_tmp3 = array('NUM' => array('LABEL' => _NUM, 'ID' => 'adr_num'), 'ROAD' => array('LABEL' => _ROAD, 'ID' => 'adr_rue'), 'CP' => array('LABEL' => _POSTAL_CODE, 'ID' => 'adr_cp'), 'CITY' => array('LABEL' => _CITY, 'ID' => 'adr_ville'), 'DISTRICTS' => array('LABEL' => _DISTRICTS, 'ID' => 'adr_quartier', 'default_label' =>addslashes( _CHOOSE_DISTRICT), 'options' => $arr_tmp) ); $arr_tmp2 = array('label' => _ADDRESS, 'type' => 'address', 'param' => array('field_label' => _ADDRESS, 'address_data' => $arr_tmp3)); $param['adress'] = $arr_tmp2; } if($_SESSION['config']['borough'] == "true") { //Address $arr_tmp3 = array('NUM' => array('LABEL' => _NUM, 'ID' => 'adr_num'), 'ROAD' => array('LABEL' => _ROAD, 'ID' => 'adr_rue'), 'CP' => array('LABEL' => _POSTAL_CODE, 'ID' => 'adr_cp'), 'COMMUNE' => array('LABEL' => _COMMUNE, 'ID' => 'adr_commune'), 'BOROUGH' => array('LABEL' => _BOROUGH, 'ID' => 'adr_arrondissement'), 'CANTON' => array('LABEL' => _CANTON, 'ID' => 'adr_canton'), 'EPCI' => array('LABEL' => _EPCI, 'ID' => 'adr_epci'), 'EPCI_TYPE' => array('LABEL' => _TYPE, 'ID' => 'epci_type') ); $arr_tmp2 = array('label' => _ADDRESS, 'type' => 'address', 'param' => array('field_label' => _ADDRESS, 'address_data' => $arr_tmp3)); $param['adress'] = $arr_tmp2; } //Courriel $arr_tmp3 = array('TO' => array('LABEL' => _TO, 'ID' => 'to'), 'OBJECT' => array('LABEL' => _OBJECT, 'ID' => 'object'), 'MESSAGE' => array('LABEL' => _MESSAGE, 'ID' => 'message') ); $arr_tmp2 = array('label' => _MAIL, 'type' => 'courriel', 'param' => array('field_label' => _MAIL, 'courriel_data' => $arr_tmp3)); $param['courriel'] = $arr_tmp2; // civility $arr_tmp = array(); for($i=0; $i < count($_SESSION['civilite']); $i++) { array_push($arr_tmp, array('VALUE' => $_SESSION['civilite'][$i], 'LABEL' => stripslashes($_SESSION['civilite'][$i]))); } $arr_tmp2 = array('label' => _CIVILITIES, 'type' => 'select_multiple', 'param' => array('field_label' => _CIVILITY, 'label_title' => _CHOOSE_CIVILITY_SEARCH_TITLE, 'id' => 'civ','options' => $arr_tmp)); $param['civilities'] = $arr_tmp2; //ingoing $arr_tmp = array(array('VALUE'=> 'inout', 'LABEL' =>_INGOING." "._AND." "._ONGOING), array('VALUE'=> 'in', 'LABEL' =>_INGOING), array('VALUE'=> 'out', 'LABEL' =>_ONGOING)); $arr_tmp2 = array('label' => _MAIL2, 'type' => 'select_simple', 'param' => array('field_label' => _MAIL2,'default_label' => '', 'options' => $arr_tmp)); $param['is_ingoing'] = $arr_tmp2; //Coming date $arr_tmp2 = array('label' => _DATE_START, 'type' => 'date_range', 'param' => array('field_label' => _DATE_START, 'id1' => 'date_start_from', 'id2' =>'date_start_to')); $param['date_start'] = $arr_tmp2; //Loaded date $arr_tmp2 = array('label' => _REG_DATE, 'type' => 'date_range', 'param' => array('field_label' => _REG_DATE, 'id1' => 'enr_from', 'id2' =>'enr_to')); $param['enr'] = $arr_tmp2; //Process date $arr_tmp2 = array('label' => _PROCESS_DATE, 'type' => 'date_range', 'param' => array('field_label' => _PROCESS_DATE, 'id1' => 'trait_from', 'id2' =>'trait_to')); $param['trait'] = $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' => 'lim_date_from', 'id2' =>'lim_date_to')); $param['lim_date'] = $arr_tmp2; $arr_tmp = array(); for($i=0; $i < count($users_list); $i++) { array_push($arr_tmp, array('VALUE' => $users_list[$i]['ID'], 'LABEL' => stripslashes($users_list[$i]['NOM'])." ".stripslashes($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; //start : shipper $conn->query("SELECT ID,LASTNAME, FIRSTNAME FROM ".$_SESSION['tablename']['senders']." WHERE TOCONTACT IS NULL ORDER BY LASTNAME"); $arr_tmp = array(); while($res = $conn->fetch_object()) { $arr_tmp[] = array('VALUE' => $res->ID,'LABEL' => stripslashes($res->LASTNAME).",".stripslashes($res->FIRSTNAME)); } $arr_tmp3 = array(); if( $_SESSION['config']['corporate'] == "true" && !($_SESSION['config']['borough'] == "true") ) { $arr_tmp3[] = array('ID' => 'shipper_lastname', 'LABEL' => _LASTNAME); $arr_tmp3[] = array('ID' => 'shipper_firstname', 'LABEL' => _FIRSTNAME); $arr_tmp3[] = array('ID' => 'shipper_civility', 'LABEL' => _FUNCTION); $arr_tmp3[] = array('ID' => 'shipper_society', 'LABEL' => _SOCIETY); } else { //Rajouter Civilite en select $arr_tmp3[] = array('ID' => 'shipper_civility', 'LABEL' => _CIVILITY); $arr_tmp3[] = array('ID' => 'shipper_lastname', 'LABEL' => _LASTNAME); $arr_tmp3[] = array('ID' => 'shipper_firstname', 'LABEL' => _FIRSTNAME); $arr_tmp3[] = array('ID' => 'shipper_society', 'LABEL' => _SOCIETY); $arr_tmp3[] = array('ID' => 'shipper_function', 'LABEL' => _FUNCTION); $arr_tmp3[] = array('ID' => 'shipper_road_num', 'LABEL' => _ROAD_NUM); $arr_tmp3[] = array('ID' => 'shipper_cp', 'LABEL' => _POSTAL_CODE); $arr_tmp3[] = array('ID' => 'shipper_street', 'LABEL' => _ADDRESS); $arr_tmp3[] = array('ID' => 'shipper_town', 'LABEL' => _TOWN); } $arr_tmp2 = array('label' => _SHIPPER, 'type' => 'select_or_other_data', 'param' => array('field_label' => _SHIPPER, 'default_label_select' => _CHOOSE_SHIPPER, 'id' => 'shipper', 'label_define_option' =>_DEFINE_SHIPPER, 'options' => $arr_tmp, 'input_ids' => $arr_tmp3)); $param['shipper'] = $arr_tmp2; // end : shipper //sender $conn->query("SELECT ID, LASTNAME, FIRSTNAME FROM ".$_SESSION['tablename']['senders']." WHERE TOCONTACT = 'EXT' ORDER BY LASTNAME"); $arr_tmp = array(); while($res = $conn->fetch_object()) { $arr_tmp[] = array('VALUE' => $res->ID,'LABEL' => stripslashes($res->LASTNAME).",".stripslashes($res->FIRSTNAME)); } $conn->query("SELECT USER_ID, LASTNAME, FIRSTNAME FROM ".$_SESSION['tablename']['users']." ORDER BY LASTNAME"); while( $res = $conn->fetch_object() ) { $arr_tmp[] = array('VALUE' => $res->USER_ID,'LABEL' => stripslashes($res->LASTNAME).",".stripslashes($res->FIRSTNAME)); } $arr_tmp3 = array(); if( $_SESSION['config']['corporate'] == "true" && !($_SESSION['config']['borough'] == "true") ) { $arr_tmp3[] = array('ID' => 'sender_lastname', 'LABEL' => _LASTNAME); $arr_tmp3[] = array('ID' => 'sender_firstname', 'LABEL' => _FIRSTNAME); $arr_tmp3[] = array('ID' => 'sender_civility', 'LABEL' => _FUNCTION); $arr_tmp3[] = array('ID' => 'sender_society', 'LABEL' => _SOCIETY); } else { $arr_tmp3[] = array('ID' => 'sender_civility', 'LABEL' => _CIVILITY); //Changer Civilite en SELECT $arr_tmp3[] = array('ID' => 'sender_lastname', 'LABEL' => _LASTNAME); $arr_tmp3[] = array('ID' => 'sender_firstname', 'LABEL' => _FIRSTNAME); $arr_tmp3[] = array('ID' => 'sender_society', 'LABEL' => _SOCIETY); $arr_tmp3[] = array('ID' => 'sender_function', 'LABEL' => _FUNCTION); $arr_tmp3[] = array('ID' => 'sender_road_num', 'LABEL' => _ROAD_NUM); $arr_tmp3[] = array('ID' => 'sender_cp', 'LABEL' => _POSTAL_CODE); $arr_tmp3[] = array('ID' => 'sender_street', 'LABEL' => _ADDRESS); $arr_tmp3[] = array('ID' => 'sender_town', 'LABEL' => _TOWN); } $arr_tmp2 = array('label' => _SENDER, 'type' => 'select_or_other_data', 'param' => array('field_label' => _SENDER, 'default_label_select' => _CHOOSE_SENDER, 'id' => 'sender', 'label_define_option' =>_DEFINE_SENDER, 'options' => $arr_tmp, 'input_ids' => $arr_tmp3)); $param['sender'] = $arr_tmp2; //end sender if($_SESSION['config']['corporate'] == "true" && $_SESSION['config']['borough'] == "false") { //Address $arr_tmp = array(); for($i=0; $i < count($_SESSION['quartiers']); $i++) { array_push($arr_tmp, array('VALUE' => $_SESSION['quartiers'][$i], 'LABEL' => $_SESSION['quartiers'][$i])); } $arr_tmp3 = array('NUM' => array('LABEL' => _NUM, 'ID' => 'num'), 'ROAD' => array('LABEL' => _CHRONO_DEP_VALUE, 'ID' => 'rue'), 'CP' => array('LABEL' => _CHRONO_START_VALUE, 'ID' => 'Cp'),'CITY' => array('LABEL' => _START_END_DATE, 'ID' => 'ville')); $arr_tmp2 = array('label' => _COMP_DATA, 'type' => 'address', 'param' => array('field_label' => _COMP_DATA, 'address_data' => $arr_tmp3)); $param['adress'] = $arr_tmp2; } //invoice_type $arr_tmp = array(); for($i=0; $i < count($_SESSION['nature']); $i++) { array_push($arr_tmp, array('VALUE' => $_SESSION['nature'][$i], 'LABEL' => stripslashes($_SESSION['nature'][$i]))); } $arr_tmp2 = array('label' => _INVOICE_TYPE, 'type' => 'select_simple', 'param' => array('field_label' => _INVOICE_TYPE,'default_label' => addslashes(_CHOOSE_INVOICE_TYPE), 'options' => $arr_tmp)); $param['invoice_type'] = $arr_tmp2; //priority $arr_tmp = array(); foreach($_SESSION['priority'] as $k_pt => $d_pt) { if( is_array($d_pt) && !empty($d_pt['label']) ) { $arr_tmp[] = array('VALUE' => 'pri_'.$k_pt,'LABEL' => $d_pt['label']); } } $arr_tmp2 = array('label' => _PRIORITY, 'type' => 'select_multiple', 'param' => array('field_label' => _MAIL_PRIORITY,'label_title' => addslashes(_CHOOSE_PRIORITY), 'id' => 'priority', 'options' => $arr_tmp)); $param['priority'] = $arr_tmp2; //identifier $arr_tmp2 = array('label' => _MAIL_IDENTIFIER, 'type' => 'input_text', 'param' => array('field_label' => _MAIL_IDENTIFIER, 'other' => $size)); $param['numcourrier'] = $arr_tmp2; //annotations $arr_tmp2 = array('label' => _NOTES, 'type' => 'input_text', 'param' => array('field_label' => _NOTES, 'other' => $size)); $param['doc_notes'] = $arr_tmp2; //notes $arr_tmp2 = array('label' => _PROCESS_NOTES, 'type' => 'input_text', 'param' => array('field_label' => _PROCESS_NOTES, 'other' => $size)); $param['process_notes'] = $arr_tmp2; //destination (department) $arr_tmp = array(); $my_services = array(); for($i=0; $i < count($_SESSION['user']['services']); $i++) { array_push($arr_tmp, array('VALUE' => stripslashes($_SESSION['user']['services'][$i]['ID']), 'LABEL' => stripslashes($_SESSION['user']['services'][$i]['LABEL']))); array_push($my_services,$_SESSION['user']['services'][$i]['ID']); } $arr_tmp2 = array('label' => _DESTINATION_SEARCH, 'type' => 'select_multiple', 'param' => array('field_label' => _DESTINATION_SEARCH, 'label_title' => _CHOOSE_ENTITES_SEARCH_TITLE, 'id' => 'services','options' => $arr_tmp)); $param['destination_mu'] = $arr_tmp2; //Themes if ($_SESSION['config']['enable_topics'] == "true") { $arr_tmp = array(); $dom = new domain(); $domains = array(); $domains = $dom->get_domains($my_services); foreach($domains as $key) { foreach($key as $topic) { array_push($arr_tmp, array('VALUE' => $topic['ID'], 'LABEL' => stripslashes($topic['LABEL']))); } } $arr_tmp2 = array('label' => _DOMAIN, 'type' => 'select_multiple', 'param' => array('field_label' => _DOMAIN, 'label_title' => _CHOOSE_DOMAIN_SEARCH_TITLE, 'id' => 'domain','options' => $arr_tmp)); $param['domain'] = $arr_tmp2; } //Motifs de redirection $arr_tmp = array(); foreach($_SESSION['mail_action'] as $key => $value) { if(is_array($_SESSION['mail_action'][$key]) && !empty($value['label']) ) { array_push($arr_tmp, array('VALUE' => $key, 'LABEL' => stripslashes($value['label']))); } } $arr_tmp2 = array('label' => _MAIL_ACTIONS, 'type' => 'select_multiple', 'param' => array('field_label' => _MAIL_ACTIONS, 'label_title' => _CHOOSE_MAIL_ACTIONS_SEARCH_TITLE, 'id' => 'mail_actions','options' => $arr_tmp)); $param['mail_actions'] = $arr_tmp2; //status $arr_tmp = array(array('VALUE'=> 'NEW', 'LABEL' =>_TO_PROCESS), array('VALUE'=> 'COU', 'LABEL' =>_IN_PROGRESS), array('VALUE'=> 'REL1', 'LABEL' =>_FIRST_WARNING), array('VALUE'=> 'REL2', 'LABEL' =>_SECOND_WARNING), array('VALUE'=> 'LATE', 'LABEL' =>_LATE), array('VALUE'=> 'END', 'LABEL' =>_CLOSED)); if ($_SESSION['config']['action_waitingdoc'] == "true") { array_push($arr_tmp, array('VALUE'=> 'WAI', 'LABEL' =>_WAITINGDOC)); } if ($_SESSION['config']['workflow'] == "true") { array_push($arr_tmp, array('VALUE'=> 'FVA', 'LABEL' =>_FVA_WKF)); array_push($arr_tmp, array('VALUE'=> 'RJV', 'LABEL' =>_RJV_WKF)); array_push($arr_tmp, array('VALUE'=> 'RJT', 'LABEL' =>_RJT_WKF)); array_push($arr_tmp, array('VALUE'=> 'RJD', 'LABEL' =>_RJD_WKF)); array_push($arr_tmp, array('VALUE'=> 'MEP', 'LABEL' =>_MEP_WKF)); } $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; //coll if($_SESSION['config']['collectivities'] == "true") { include_once($_SESSION['config']['includedir']."/addon_collectivities.php"); $arr_tmp2 = load_search_form_entity(); $param['coll'] = $arr_tmp2; } //doc_type $conn->query("select type_id, description from ".$_SESSION['tablename']['doctypes']." where enabled = 'Y' order by description asc"); $arr_tmp = array(); while ($res=$conn->fetch_object()) { array_push($arr_tmp, array('VALUE' => $res->type_id, 'LABEL' => stripslashes($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; //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; $tab = $search_obj->send_criteria_data($param); //$conn->show_array($param); //$conn->show_array($tab); // criteria list options $src_tab = $tab[0]; /*echo '

';
print_r($tab);
echo '

'; die;*/ ?>

0) {?>