* @version $id SVN * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ include_once(themePath('../yellowpages/'.SQL.'.inc.php')); /** * DisplayUrlAddYellowpages() * @return * affichage d'ajout d'un organisation **/ if(!function_exists('DisplayUrlAddYellowpages')) { function DisplayUrlAddYellowpages() { $link_table= array('rub'=> $GLOBALS['links'][U_L]['directory-add']['linkvalue']); $content=''._t('yp','add_public').''.END_LINE; echo $content; } } /** * DisplayListYellowPages() * affichage de l'annuaire * @param $debut * @param unknown $limite * @param integer $filter * @param integer $search * @return **/ if(!function_exists('DisplayListYellowPages')) { function DisplayListYellowPages($debut, $limite = SELECT_LIMIT, $filter= -1, $search= -1){ $result_yp = $GLOBALS['sql_object'] -> DBSelect(SQL_get_Display_ypList($debut, $limite, $filter, $search)); $result_nb_yp = $GLOBALS['sql_object'] -> DBSelect(SQL_get_Display_CountypList($filter, $search)); $bdd_nb_yp=$result_nb_yp[0]['num_rows']; if ($filter==-1) $table_link=array('rub' => $GLOBALS['links'][U_L]['directory']['linkvalue']); else $table_link=array('rub' => $GLOBALS['links'][U_L]['directory']['linkvalue'],'id' => $search, 'filter' => $filter); $bdd_nb_yp_display = $bdd_nb_yp; if($bdd_nb_yp!=0) DisplayAlphaBeta($filter,$search); echo Display_linkin_page($table_link, $bdd_nb_yp, $debut); $content='
'.END_LINE; if($result_yp!=0) { for($i=0; $i $GLOBALS['links'][U_L]['directory-detail']['linkvalue'],'id'=>$result_yp[$i]['yellowp_id'], 'name'=>$result_yp[$i]['yellowp_name']); $link_table2= array('rub'=> $GLOBALS['links'][U_L]['directory']['linkvalue'],'filter'=> $GLOBALS['filters'][U_L]['theme']['linkvalue'],'id'=>$result_yp[$i]['sdtheme_id'], 'name'=>$result_yp[$i]['sdtheme_name']); $yp_name=formatText($result_yp[$i]['yellowp_name'], '2HTML'); $yp_activity=formatText(cutText($result_yp[$i]['yellowp_activity'],150), '2HTML'); $yp_sdtheme=formatText($result_yp[$i]['sdtheme_name'], '2HTML'); $yp_theme=formatText($result_yp[$i]['theme_name'], '2HTML'); $content.='

'.END_LINE; $content.=''.$yp_name.''.END_LINE; $content.='

'.END_LINE; $content.='

'._t('yp','activity').' : '.$yp_activity.'

'.END_LINE; if ($yp_sdtheme<>""){ $content.='

'._t('divers','themeref').' : '.$yp_sdtheme.' '._t('divers','sousthemeref').': '.$yp_theme.'

'.END_LINE; } else { $content.='

'._t('divers','themeref').' : '.empty_nc($yp_sdtheme).' '._t('divers','sousthemeref').': '.empty_nc($yp_sdtheme).'

'.END_LINE; } $content.='
'.END_LINE; } } else { $content.='

'._t('yp','noresult').'

'; } echo $content; echo Display_linkin_page($table_link, $bdd_nb_yp, $debut)."
"; } } /** * DisplayAlphaBeta() * affichage de la liste alphabétique * @param $filter * @param $filter_id * @return **/ if(!function_exists('DisplayAlphaBeta')) { function DisplayAlphaBeta($filter,$filter_id){ $result_alphabetical = $GLOBALS['sql_object'] -> DBSelect(SQL_get_req_alphabetical()); $content=''.END_LINE; echo $content; } } /** * DisplayOneYellowPages() * affichage d'une organisation * @param $yp_id * @return **/ if(!function_exists('DisplayOneYellowPages')) { function DisplayOneYellowPages($yp_id){ $data= $GLOBALS['sql_object'] -> DBSelect(SQL_getdetyp($yp_id)); if($data!=0) { $content= ''; $link_table2= array('rub'=> $GLOBALS['links'][U_L]['directory']['linkvalue'],'filter'=> $GLOBALS['filters'][U_L]['theme']['linkvalue'],'id'=>$data[0]['sdtheme_id'], 'name'=>$data[0]['sdtheme_name']); $link_self= array('rub'=> $GLOBALS['links'][U_L]['directory']['linkvalue'],'id'=> $yp_id); $yp_name=formatText($data[0]['yellowp_name'], '2HTML'); $yp_activity=formatText(cutText($data[0]['yellowp_activity'],150), '2HTML'); $yp_sdtheme=formatText($data[0]['sdtheme_name'], '2HTML'); $yp_theme=formatText($data[0]['theme_name'], '2HTML'); $yp_street=formatText($data[0]['yellowp_street'], '2HTML'); $yp_postal_code=formatText($data[0]['yellowp_postal_code'], '2HTML'); $yp_city=formatText($data[0]['yellowp_city'], '2HTML'); $yp_phone=formatText($data[0]['yellowp_phone'], '2HTML'); $yp_fax=formatText($data[0]['yellowp_fax'], '2HTML'); $yp_email=formatText($data[0]['yellowp_email'], '2HTML'); $yp_website=formatText($data[0]['yellowp_website'], '2HTML'); $yp_lat=$data[0]['yellowp_latitude']; $yp_long=$data[0]['yellowp_longitude']; $content.='

'.$yp_name.'

'.END_LINE; $content.='

'.END_LINE; $content.= formatted_permalink($link_self); $content.='

'.END_LINE; $content.='
'._t('yp','adresse').' :
'.$yp_street.' '.$yp_postal_code.' '.$yp_city.'
'.END_LINE; $content.='
'._t('yp','phone').' :
'.empty_nc($yp_phone).'
'.END_LINE; $content.='
'._t('yp','fax').':
'.empty_nc($yp_fax).'
'.END_LINE; $content.='
'._t('yp','email').' :
'.$yp_email.'
'.END_LINE; if ($data[0]['yellowp_website']<>"") $content.='
'._t('yp','website').' :
'.$yp_website.'
'.END_LINE; else $content.='
'._t('yp','website').' :
'.empty_nc($yp_website).'
'.END_LINE; $content.='
'._t('yp','activity').' :
'.$yp_activity.'
'.END_LINE; if ($yp_sdtheme<>"") { $content.='
'._t('divers','themeref').' :
'.$yp_sdtheme.'
'._t('divers','sousthemeref').':
'.$yp_theme.'
'.END_LINE; } else { $content.='
'._t('divers','themeref').' :
'.empty_nc($yp_sdtheme).'
'._t('divers','sousthemeref').':
'.empty_nc($yp_sdtheme).'
'.END_LINE; } $content.='
'.END_LINE; } else { $content.='

'._t('yp','noresult').'

'; } echo $content; echo generateMap('map', $data, 16) ; } } /** * generateMap() * generate a Map with Gmaps * @return **/ if(!function_exists('generateMap')) { function generateMap($id, $data, $zoom) { $lat = $data[0]['yellowp_latitude']; $long = $data[0]['yellowp_longitude']; $name = formatText($data[0]['yellowp_name'], '2HTML'); $address = formatText($data[0]['yellowp_street'], '2HTML').'
'.formatText($data[0]['yellowp_postal_code'], '2HTML'). ' - '.formatText($data[0]['yellowp_city'], '2HTML'); if($lat==0 || $long==0) return false; footerAddJS('http://maps.googleapis.com/maps/api/js?sensor=false'); $map ='
'; $map .= ''; return $map; } } /** * DisplayConfirmAdd() * affichage confirmation de l'ajout * @return **/ if(!function_exists('DisplayConfirmAdd')) { function DisplayConfirmAdd() { $link_table= array('rub'=> $GLOBALS['links'][U_L]['directory']['linkvalue']); $content='

'._t('yp','confirm_pub').' '._t('yp','confirm_pub2').''.END_LINE; $content.='

'.END_LINE; echo $content; } } /** * DisplayAddYellowPages() * affichage formulaire d'ajout * @param integer $btn * @param $table * @return **/ if(!function_exists('DisplayAddYellowPages')) { function DisplayAddYellowPages() { include_once('../lib/input_helpers.php'); include_once('../class/class.yellowpages.php'); $form_name=''; $form_activity=''; $form_theme=''; $form_street=''; $form_postal_code=''; $form_city=''; $form_phone=''; $form_fax=''; $form_email=''; $form_website='http://'; $data= $GLOBALS['sql_object'] -> DBSelect(SQL_get_req_list_theme()); $select_theme=ThemeSelectBox($data, "yp_theme", $form_theme); // testing $_POST['yp_name'] and not $_POST['valider'] because of OPERA bug if(isset($_POST['yp_name'])) { $table[0]=$_POST['yp_name']; $table[1]=$_POST['yp_activity']; $table[2]=$_POST['yp_theme']; $table[3]=$_POST['yp_street']; $table[4]=$_POST['yp_postal_code']; $table[5]=$_POST['yp_city']; $table[6]=''; $table[7]=$_POST['yp_phone']; $table[8]=$_POST['yp_fax']; $table[9]=$_POST['yp_email']; ($_POST['yp_website'] != 'http://') ? $table[10]=$_POST['yp_website'] : $table[10]=''; $table[11]="D"; $yp_object= new yellowpages; // prevent spam if($_SESSION['securityaction']!=md5($_POST['securitycode'])) { $integrity=_t('security','message'); } if(!isset($integrity)) $integrity=$yp_object->CheckDataIntegrity($table); if (is_string($integrity)) { echo "

".$integrity."

"; $form_name=formatText($_POST['yp_name'], '2FIELD'); $form_activity=formatText($_POST['yp_activity'], '2FIELD'); $form_theme=$_POST['yp_theme']; $form_street=formatText($_POST['yp_street'], '2FIELD'); $form_postal_code=$_POST['yp_postal_code']; $form_city=formatText($_POST['yp_city'], '2FIELD'); $form_phone=$_POST['yp_phone']; $form_fax=$_POST['yp_fax']; $form_email=formatText($_POST['yp_email'], '2FIELD'); $form_website=formatText($_POST['yp_website'], '2FIELD'); } else { $result=$yp_object->AddYellowPages($table, $GLOBALS['sql_object']); $link_confirm=HrefMaker(array('rub'=> $GLOBALS['links'][U_L]['directory']['linkvalue'])); if(is_numeric($result)) DisplayConfirmAdd(); else echo "

".system_error()."

"; } } if (!isset($integrity) || is_string($integrity)) { $form ='
'._t('yp','h1_public_add').'
'; $form.='
'.END_LINE; $form.='
'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.=$select_theme.'

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='

'.END_LINE; $form.='' . _t('security','info2') . ' : '.END_LINE; $form.='' . _t('security','info2') .''; $form.=''.END_LINE; $form.='

'.END_LINE; $form.='

'; $form.=' '; $form.=''.END_LINE; $form.='
'.END_LINE; $form.='
'.END_LINE; echo $form; } } } ?>