. */ /** * @brief Contacts list of the current user * * @file my_contacts.php * @author Yves Christian Kpakpo * @date $date$ * @version $Revision$ * @ingroup apps */ require_once "core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"; require_once "apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR ."class".DIRECTORY_SEPARATOR."class_lists.php"; require_once "apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR ."class".DIRECTORY_SEPARATOR."class_contacts_v2.php"; $core_tools = new core_tools(); $request = new request(); $list = new lists(); $contact = new contacts_v2(); $parameters = ''; if (isset($_REQUEST['order']) && !empty($_REQUEST['order'])) $parameters .= '&order='.$_REQUEST['order']; if (isset($_REQUEST['order_field']) && !empty($_REQUEST['order_field'])) $parameters .= '&order_field='.$_REQUEST['order_field']; if (isset($_REQUEST['what']) && !empty($_REQUEST['what'])) $parameters .= '&what='.$_REQUEST['what']; if (isset($_REQUEST['selectedObject']) && !empty($_REQUEST['selectedObject'])) $parameters .= '&selectedObject='.$_REQUEST['selectedObject']; if (isset($_REQUEST['start']) && !empty($_REQUEST['start'])) $parameters .= '&start='.$_REQUEST['start']; if (isset($_REQUEST['mode']) && !empty($_REQUEST['mode'])) $parameters .= '&mode='.$_REQUEST['mode']; $_SESSION['origin']="contacts_list"; unset($_SESSION['fromContactTree']); if (isset($_REQUEST['load'])) { $_SESSION['m_admin'] = array(); if(!$core_tools->test_service('my_contacts', 'apps', false)){ $core_tools->test_service('my_contacts_menu', 'apps'); } /****************Management of the location bar ************/ $init = false; if(isset($_REQUEST['reinit']) && $_REQUEST['reinit'] == "true") { $init = true; } $level = ""; if(isset($_REQUEST['level']) && ($_REQUEST['level'] == 2 || $_REQUEST['level'] == 3 || $_REQUEST['level'] == 4 || $_REQUEST['level'] == 1)) { $level = $_REQUEST['level']; } $page_path = $_SESSION['config']['businessappurl'].'index.php?page=my_contacts&dir=my_contacts&load'; $page_label = _CONTACTS_LIST; $page_id = "my_contacts"; $core_tools->manage_location_bar($page_path, $page_label, $page_id, $init, $level); /***********************************************************/ ?>
loadList($target, true, 'divList', 'false'); echo $listContent; ?>
'search') { $where_tab[] = "(contact_user_id = :userId)"; $arrayPDO = array_merge($arrayPDO, array(":userId" => $_SESSION['user']['UserId'])); } //Filtre alphabetique et champ de recherche $what = $list->getWhatSearch(); if (isset($_REQUEST['selectedObject']) && ! empty($_REQUEST['selectedObject'])) { $where_tab[] = " contact_id = :contactId "; $arrayPDO = array_merge($arrayPDO, array(":contactId" => $_REQUEST['selectedObject'])); } elseif (!empty($what)) { $what = str_replace(" ", "", $_REQUEST['what']); $what_table = explode(" ", $what); foreach($what_table as $key => $what_a){ $sql_lastname[] = " lower(contact_lastname) LIKE lower(:what_".$key.")"; $sql_society[] = " lower(society) LIKE lower(:what_".$key.")"; $arrayPDO = array_merge($arrayPDO, array(":what_".$key => $what_a."%")); } $where_tab[] = " (" . implode(' OR ', $sql_lastname) . " or " . implode(' OR ', $sql_society) . ") "; } //Build where $where = implode(' and ', $where_tab); //Order $order = $order_field = ''; $order = $list->getOrder(); $order_field = $list->getOrderField(); if (!empty($order_field) && !empty($order)) $orderstr = "order by ".$order_field." ".$order; else { $list->setOrder('asc'); $list->setOrderField('contact_lastname'); $orderstr = "order by contact_lastname, society asc"; } //Request $tab=$request->PDOselect($select,$where,$arrayPDO,$orderstr,$_SESSION['config']['databasetype'], "default", false, "", "", "", true, false, true); //Result array for ($i=0;$iget_label_contact($tab[$i][$j]['value'], $_SESSION['tablename']['contact_types']); $tab[$i][$j]["label"]= _CONTACT_TYPE; $tab[$i][$j]["size"]="5"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "contact_type_label"; } if($tab[$i][$j][$value]=="is_corporate_person") { $tab[$i][$j]['value']= ($tab[$i][$j]['value'] == 'Y')? _YES : _NO; $tab[$i][$j]["label"]=_IS_CORPORATE_PERSON; $tab[$i][$j]["size"]="5"; $tab[$i][$j]["label_align"]="center"; $tab[$i][$j]["align"]="center"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "is_corporate_person"; } if($tab[$i][$j][$value]=="society") { $tab[$i][$j]['value']=$request->show_string($tab[$i][$j]['value']); $tab[$i][$j]["society"]=$tab[$i][$j]['value']; $tab[$i][$j]["label"]=_STRUCTURE_ORGANISM; $tab[$i][$j]["size"]="15"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "society"; } if($tab[$i][$j][$value]=="contact_lastname") { $tab[$i][$j]['value']=$request->show_string($tab[$i][$j]['value']); $tab[$i][$j]["contact_lastname"]=$tab[$i][$j]['value']; $tab[$i][$j]["label"]=_LASTNAME; $tab[$i][$j]["size"]="15"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "contact_lastname"; } if($tab[$i][$j][$value]=="contact_firstname") { $tab[$i][$j]["contact_firstname"]= $tab[$i][$j]['value']; $tab[$i][$j]["label"]=_FIRSTNAME; $tab[$i][$j]["size"]="15"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "contact_firstname"; } if($tab[$i][$j][$value]=="contact_user_id") { $tab[$i][$j]["contact_user_id"]= $tab[$i][$j]['value']; $tab[$i][$j]["label"]=_CREATE_BY; $tab[$i][$j]["size"]="15"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]= "contact_user_id"; } } } } //List parameters $paramsTab = array(); $paramsTab['bool_modeReturn'] = false; //Desactivation du mode return (vs echo) $paramsTab['pageTitle'] = _CONTACTS_LIST." : ".count($tab).' '._CONTACTS; //Titre de la page $paramsTab['urlParameters'] = '&dir=my_contacts'; //parametre d'url supplementaire if ($_REQUEST['mode'] == 'search') { $paramsTab['urlParameters'] .= "&mode=search"; } $paramsTab['pagePicto'] = 'users'; //Image (pictogramme) de la page $paramsTab['bool_sortColumn'] = true; //Affichage Tri $paramsTab['bool_showSearchTools'] = true; //Afficle le filtre alphabetique et le champ de recherche $paramsTab['searchBoxAutoCompletionUrl'] = $_SESSION['config']['businessappurl'] ."index.php?display=true&page=contacts_v2_list_by_name"; //Script pour l'autocompletion if ($_REQUEST['mode'] <> 'search') { $paramsTab['searchBoxAutoCompletionUrl'] .= "&my_contact=Y"; } $paramsTab['searchBoxAutoCompletionMinChars'] = 2; //Nombre minimum de caractere pour activer l'autocompletion (1 par defaut) $paramsTab['searchBoxAutoCompletionUpdate'] = true; // $paramsTab['addButtonLink'] = $_SESSION['config']['businessappurl'] // ."index.php?dir=my_contacts&page=my_contact_add"; //Lien sur le bouton nouveau (1) if ($_REQUEST['mode'] <> 'search') { $paramsTab['bool_showAddButton'] = true; //Affichage du bouton Nouveau $paramsTab['addButtonLabel'] = _CONTACT_ADDITION; //Libellé du bouton Nouveau $paramsTab['addButtonScript'] = "window.top.location='".$_SESSION['config']['businessappurl'] ."index.php?dir=my_contacts&page=my_contact_add'"; //Action sur le bouton nouveau (2) } //Action icons array $paramsTab['actionIcons'] = array(); //get start $start = $list->getStart(); if ($_REQUEST['mode'] <> 'search') { $update = array( "script" => "window.top.location='".$_SESSION['config']['businessappurl'] ."index.php?dir=my_contacts&page=my_contact_up&fromMyContactsList&id=@@contact_id@@&what=".$what."&start=".$start."'", "class" => "change", "label" => _MODIFY, "tooltip" => _MODIFY ); $delete = array( "href" => $_SESSION['config']['businessappurl'] ."index.php?dir=my_contacts&page=my_contact_del&what=".$what."&start=".$start, "class" => "delete", "label" => _DELETE, "tooltip" => _DELETE, "alertText" => _REALLY_DELETE.": @@society@@ @@contact_lastname@@ @@contact_firstname@@ ?" ); array_push($paramsTab['actionIcons'], $update); array_push($paramsTab['actionIcons'], $delete); } else { $view = array( "script" => "window.top.location='".$_SESSION['config']['businessappurl'] ."index.php?dir=indexing_searching&page=contacts_view&fromSearchContactsList&id=@@contact_id@@&what=".$what."&start=".$start."'", "class" => "view", "label" => _VIEW, "tooltip" => _VIEW ); array_push($paramsTab['actionIcons'], $view); } //Afficher la liste echo '
'; $list->showList($tab, $paramsTab, 'contact_id'); }