MLB 2.6 * * @package Maarch LetterBox 2.6 * @version 1.0 * @since 10/2007 * @license GPL * @author Loïc Vinet */ function get_xml_value() // array : return list of entities { $xml_value = array(); $batch_config = simplexml_load_file('xml/collectivities.xml'); if($batch_config) { foreach($batch_config->ELEMENT as $ELEMENT) { $tmp_id = utf8_decode((string) $ELEMENT->ID); $tmp_label = utf8_decode((string) $ELEMENT->LABEL); array_push($xml_value, array("ID"=>$tmp_id, "LABEL"=>$tmp_label)); } return $xml_value; } else { echo "error: unable to open collectivities.xml"; exit(); } } function show_entities_list_in_formservice($entities_list, $selected_entities = false) // @param : $entities_list(array) list of entities // @param : $selected_entities(array) actual list of entities // display list of entities { echo "

"._CO_WHERE_MY_DPT_IS_USED_NOTES." :

"; ?>

query($query); } } function delete_collectivity($department,$object) { // @param : $department(varchar) id of this department // @param : $object(object) db query object // delete a collectivity in table serv_coll $query = ("DELETE FROM `".$_SESSION['tablename']['coll_serv']."` WHERE ID_SERV = '".$department."' "); $object->query($query); } function up_collectivity($request_entities, $department,$object) { // @param : $request_entities(array) list of entities selectionned // @param : $department(varchar) id of this department // @param : $object(object) db query object // up a collectivity in table serv_coll add_collectivity($request_entities, $department,$object); } function get_selected_entities($department, $object) // @param : $department(varchar) id of this department // @param : $object(object) db query object // restore list of entities for this department // #return false if no value { $query = ("SELECT ID_COLL FROM `".$_SESSION['tablename']['coll_serv']."` WHERE ID_SERV = '".$department."' "); $object->query($query); if ($object->nb_result() > 0) { $array = array(); while($list=$object->fetch_array()) { array_push($array, $list[0]); } return($array); } else { return false; } } function get_selected_department($service, $object) // @param : $service(varchar) id of this service // @param : $object(object) db query object // restore list of entities for this department // #return false if no value { $query = ("SELECT ID_SERV FROM `".$_SESSION['tablename']['coll_serv']."` WHERE ID_COLL = '".$service."' "); $object->query($query); if ($object->nb_result() > 0) { $array = array(); while($list=$object->fetch_array()) { array_push($array, $list[0]); } return($array); } else { return false; } } function get_label_collectivity($coll_id) // @param : $coll_id(varchar) id of this entity // @param : $object(object) db query object // return label from entity // #return false if no value { for ($i=0; $i

">

query($query); if ($object->nb_result() > 0) { $array = array(); while($list=$object->fetch_array()) { array_push($array, array("ID"=>$list[0], "LABEL"=>$list[1])); } return($array); } else { return false; } } function get_departments($entity, $object) // @param : $entity(varchar) entity selected // @param : $object(object) db query object // restore list of entities for this department // #return false if no value { $query = ("SELECT c.ID_SERV, s.SERVICE FROM ".$_SESSION['tablename']['coll_serv']." c, ".$_SESSION['tablename']['services']." s WHERE c.ID_SERV = s.ID and ID_COLL = '".$entity."' ORDER BY s.SERVICE"); $object->query($query); if ($object->nb_result() > 0) { $array = array(); while($list=$object->fetch_array()) { for ($l=0; $l$list[0], "LABEL"=>$list[1])); } } } return($array); } else { return false; } } function load_entity_for_user($object) // @param : $object(object) db query object // load in session entities authorized for a user // #return false if no value { if (count($_SESSION['user']['services']) == 0) { return false; } $service_string = ''; for($i=0; $i < count($_SESSION['user']['services']);$i++) { $service_string .= "'". $_SESSION['user']['services'][$i]['ID']."' ,"; } $service_string = substr($service_string, 0, -2); $query= ("SELECT ID_COLL FROM ".$_SESSION['tablename']['coll_serv']." WHERE ID_SERV IN (".$service_string.") GROUP BY ID_COLL"); $object->query($query); $_SESSION['user']['coll'] = array(); $batch_config = simplexml_load_file('xml/collectivities.xml'); if($batch_config) { if ($object->nb_result() == 0) { return false; } while($list=$object->fetch_array()) { $tmp = $list[0]; foreach($batch_config->ELEMENT as $ELEMENT) { if ($tmp == $ELEMENT->ID) { array_push($_SESSION['user']['coll'], array("ID"=>$tmp, "LABEL"=> (string)$ELEMENT->LABEL)); } } } } else { echo "error: unable to open collectivities.xml"; exit(); } } function service_choice_addon() { //récuperer les collectivités accessibles pour l'utilisateur $dbsca = new dbquery(); $dbsca-> connect(); if (count($_SESSION['user']['coll']) == 1) { $_SESSION['courrier']['entity'] = $_SESSION['user']['coll'][0]['ID']; //$departments = get_departments($_SESSION['user']['coll'][0]['ID'], $dbsca); } if ($_SESSION['courrier']['entity']) { $departments = get_departments($_SESSION['courrier']['entity'], $dbsca); } else { unset($departments); } //Trier les services accessibles pour cette collectivité echo ' $_SESSION['user']['coll'][$i]['ID'], 'LABEL' => $_SESSION['user']['coll'][$i]['LABEL'])); } $arr_tmp2 = array('label' => _COLL, 'type' => 'select_multiple', 'param' => array('field_label' => _COLL, 'label_title' => _COLL_CHOOSE_RECIPIENT_SEARCH_TITLE, 'id' => 'coll','options' => $arr_tmp)); return $arr_tmp2; } ?>