* @version $Id$ * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ include_once(override('../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').''.PHP_EOL; 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){ if($filter == 'LEVEL') { $levels = getLevelChildren($GLOBALS['sql_object']->DBSelect(SQL_getLevelsList()), $search); $search = array_extract($levels, 'level_id', true, 'children'); } $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']; $sep = ' / '; 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); $content = ''; if($bdd_nb_yp > 0) $content .= get_linkin_page($table_link, $bdd_nb_yp, $debut); //$content .='
'.PHP_EOL; $content .= '
'.PHP_EOL; if(is_array($result_yp) && $result_yp > 0) { for($i=0; $iDBSelect(SQL_getLevelsList()); $level = getLevelParent($levels, $result_yp[$i]['level_id'], 0); $link_table= array('rub'=> $GLOBALS['links'][U_L]['directory-detail']['linkvalue'],'id'=>$result_yp[$i]['yellowp_id'], 'name'=>$result_yp[$i]['yellowp_name']); if(is_array($level)) { $link_level = array('rub' => $GLOBALS['links'][U_L]['directory']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['level']['linkvalue'], 'id' => $level['id'], 'name' => $level['name']); } $yp_name=formatText($result_yp[$i]['yellowp_name'], '2HTML'); $yp_activity=formatText(cutText($result_yp[$i]['yellowp_activity'],150), '2HTML'); $yp_level=formatText($result_yp[$i]['level_name'], '2HTML'); $content .= '
'.PHP_EOL; $content.='

'.PHP_EOL; $content.=''.$yp_name.''.PHP_EOL; $content.='

'.PHP_EOL; $content.='

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

'.PHP_EOL; if(is_array($level)) $content .= '

' . $level['label'] . ' : ' . $level['name'] . '

' . PHP_EOL; $content .= '
' . PHP_EOL; //$content.='
'.PHP_EOL; } $content .= '
' . PHP_EOL; } else { $content.='

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

'; } if($bdd_nb_yp > 0) $content .= get_linkin_page($table_link, $bdd_nb_yp, $debut); echo $content; } } /** * 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=''.PHP_EOL; 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, array('P'))); if($data == 0) error_redirect(); $levels = $GLOBALS['sql_object']->DBSelect(SQL_getLevelsList()); $level = getLevelParent($levels, $data[0]['level_id'], 0); if (count($data) != 1) exit; else { $content= ''; if(is_array($level)) { $link_level = array('rub' => $GLOBALS['links'][U_L]['directory']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['level']['linkvalue'], 'id' => $level['id'], 'name' => $level['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_level=formatText($data[0]['level_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.'

'.PHP_EOL; $content.='

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

'.PHP_EOL; $content.='
'.mb_ucfirst(_t('yp','adresse')).' :
'.$yp_street.' '.$yp_postal_code.' '.$yp_city.'
'.PHP_EOL; $content.='
'.mb_ucfirst(_t('yp','phone')).' :
'.empty_nc($yp_phone).'
'.PHP_EOL; $content.='
'.mb_ucfirst(_t('yp','fax')).':
'.empty_nc($yp_fax).'
'.PHP_EOL; $content.='
'.mb_ucfirst(_t('yp','email')).' :
'.$yp_email.'
'.PHP_EOL; if ($data[0]['yellowp_website']<>"") $content.='
'.mb_ucfirst(_t('yp','website')) .' :
'.$yp_website.'
'.PHP_EOL; else $content.='
'.mb_ucfirst(_t('yp','website')).' :
'.empty_nc($yp_website).'
'.PHP_EOL; $content.='
'.mb_ucfirst(_t('yp','activity')).' :
'.$yp_activity.'
'.PHP_EOL; if ($yp_level != 0) { $content.='
'.mb_ucfirst($level['label']).' :
'.$level['name'].''.PHP_EOL; } $content.='
'.PHP_EOL; } echo $content; if(defined('MAP_ENGINE') && MAP_ENGINE == 'leaflet') { echo generateLMap('map', $data, 16) ; } else { echo generateGMap('map', $data, 16) ; } } } /** * generateMap() * generate a Map with Gmaps * @return **/ if(!function_exists('generateLMap')) { function generateLMap($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; if(defined('MAP_TILELAYER')) $tile_layer = MAP_TILELAYER; else $tile_layer = "http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png"; $map ='
'; $map .= ''; return $map; } } /** * generateMap() * generate a Map with Gmaps * @return **/ if(!function_exists('generateGMap')) { function generateGMap($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?v=3&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').''.PHP_EOL; $content.='

'.PHP_EOL; 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_level=''; $form_street=''; $form_postal_code=''; $form_city=''; $form_phone=''; $form_fax=''; $form_email=''; $form_website='http://'; // testing $_POST['yp_name'] and not $_POST['valider'] because of OPERA bug if(isset($_POST['yp_name'])) { $table = array(); $table[0]=$_POST['yp_name']; $table[1]=$_POST['yp_activity']; $table[2]=$_POST['yp_level']; $table[3]=$_POST['yp_street']; $table[4]=$_POST['yp_postal_code']; $table[5]=$_POST['yp_city']; $table[6]=''; $table[7]=str_replace(' ', '', $_POST['yp_phone']); $table[8]=str_replace(' ', '', $_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_level=$_POST['yp_level']; $form_street=formatText($_POST['yp_street'], '2FIELD'); $form_postal_code=$_POST['yp_postal_code']; $form_city=formatText($_POST['yp_city'], '2FIELD'); $form_phone=str_replace(' ', '', $_POST['yp_phone']); $form_fax=str_replace(' ', '', $_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()."

"; } } // select-box des niveaux $data=$GLOBALS['sql_object']->DBSelect(SQL_getLevelsList()); $select_level=LevelSelectBox($data, "yp_level", $form_level); if (!isset($integrity) || is_string($integrity)) { $form ='
'._t('yp','h1_public_add').'
'; $form.='
'.PHP_EOL; $form.='
'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.=$select_level.'

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.=' '.PHP_EOL; $form.='' .mb_ucfirst( _t('security','info2')) .''. mb_ucfirst(_t('security','info2')).''; $form.='

'.PHP_EOL; $form.='

'.PHP_EOL; $form.='

'; $form.=' '; $form.=''.PHP_EOL; $form.='
'.PHP_EOL; $form.='
'.PHP_EOL; if(U_L == 'fr') { footerAddJS('../lib/js/jquery-mask-plugin/dist/jquery.mask.min.js'); footerAddInlineJS(" $( '.phone-format').each(function( index ) { $(this).mask('00 00 00 00 00'); });"); } echo $form; } } } ?>