linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]
Packages:
linea21-core
linea21-externals
linea21-languages
linea21-modules
linea21-utils

Source for file display.php

Documentation is available at display.php

  1. <?php
  2. /**
  3.  * @package linea21.modules
  4.  * @subpackage yellowpages
  5.  * @author linea21 <info@linea21.com>
  6.  * @version $id SVN
  7.  * @access public
  8.  * @license http://opensource.org/licenses/gpl-3.0.html
  9.  */
  10.  
  11. include_once('../yellowpages/'.SQL.'.inc.php');
  12.  
  13. /**
  14.  * DisplayUrlAddYellowpages()
  15.  * @return 
  16.  *  affichage d'ajout d'un organisation
  17.  ***/
  18. function DisplayUrlAddYellowpages() {
  19.  
  20.   $link_table= array('rub'=> $GLOBALS['links'][LANGUAGE]['directory-add']['linkvalue']);
  21.   $content='<div class="nb_sujet_yp"> <a href="'.HrefMaker($link_table).'" title="'.$GLOBALS['lang']['yp']['add_public'].'">'.$GLOBALS['lang']['yp']['add_public'].'</a></div>'.END_LINE;
  22.   echo $content;
  23. }
  24.  
  25. /**
  26.  * DisplayListYellowPages()
  27.  * affichage de l'annuaire
  28.  * @param $debut 
  29.  * @param unknown $limite 
  30.  * @param integer $filter 
  31.  * @param integer $search 
  32.  * @return 
  33.  ***/
  34. function DisplayListYellowPages($debut, $limite = SELECT_LIMIT, $filter= -1, $search= -1){
  35.  
  36.   $result_yp = $GLOBALS['sql_object'] -> DBSelect(SQL_get_Display_ypList($debut, $limite, $filter, $search));
  37.   $result_nb_yp = $GLOBALS['sql_object'] -> DBSelect(SQL_get_Display_CountypList($filter, $search));
  38.  
  39.   $bdd_nb_yp=$result_nb_yp[0]['num_rows'];
  40.  
  41.  
  42.   if ($filter==-1) $table_link=array('rub' => $GLOBALS['links'][LANGUAGE]['directory']['linkvalue']);
  43.   else $table_link=array('rub' => $GLOBALS['links'][LANGUAGE]['directory']['linkvalue'],'id' => $search, 'filter' => $filter);
  44.  
  45.  
  46.   $bdd_nb_yp_display = $bdd_nb_yp;
  47.  
  48.   echo DisplayUrlAddYellowpages();
  49.   echo '<h1>'.$GLOBALS['lang']['yp']['list'].'</h1>'.END_LINE;
  50.   echo '<div class="h1_comment" id="h1_yellowpages">'.$GLOBALS['lang']['yp']['h1_public_comment'].'</div>';
  51.  
  52.   DisplayAlphaBeta($filter,$search);
  53.   echo Display_linkin_page($table_link, $bdd_nb_yp, $debut);
  54.  
  55.   $content='<hr />'.END_LINE;
  56.   if($result_yp!=0)
  57.   {
  58.  
  59.     for($i=0; $i<count($result_yp); $i++) {
  60.       $link_table= array('rub'=> $GLOBALS['links'][LANGUAGE]['directory-detail']['linkvalue'],'id'=>$result_yp[$i]['yellowp_id'], 'name'=>$result_yp[$i]['yellowp_name']);
  61.       $link_table2= array('rub'=> $GLOBALS['links'][LANGUAGE]['directory']['linkvalue'],'filter'=> $GLOBALS['filters'][LANGUAGE]['theme']['linkvalue'],'id'=>$result_yp[$i]['sdtheme_id'], 'name'=>$result_yp[$i]['sdtheme_name']);
  62.       $yp_name=formatText($result_yp[$i]['yellowp_name'], '2HTML');
  63.       $yp_activity=formatText(cutText($result_yp[$i]['yellowp_activity'],150), '2HTML');
  64.       $yp_sdtheme=formatText($result_yp[$i]['sdtheme_name'], '2HTML');
  65.       $yp_theme=formatText($result_yp[$i]['theme_name'], '2HTML');
  66.       $content.='<h2><a href="'.HrefMaker($link_table).'" title="'.formatText($yp_name, '2ATT').'">'.$yp_name.'</a>'.END_LINE;
  67.       $content.='</h2>'.END_LINE;
  68.       $content.='<p> '.$GLOBALS['lang']['yp']['activity'].' : '.$yp_activity.'</p>'.END_LINE;
  69.        
  70.       if ($yp_sdtheme<>""){
  71.         $content.='<p class="filter_info"> '.$GLOBALS['lang']['divers']['themeref'].' : <a href="'.HrefMaker($link_table2).'" title="'.formatText($yp_sdtheme, '2ATT').'" class="filter_info_theme">'.$yp_sdtheme.'</a>
  72.             '.$GLOBALS['lang']['divers']['sousthemeref'].': <span class="filter_info_scale">'.$yp_theme.'</span>
  73.             </p>'.END_LINE;
  74.       }
  75.       else {
  76.         $content.='<p class="filter_info"> '.$GLOBALS['lang']['divers']['themeref'].' : '.empty_nc($yp_sdtheme).' <span>'.$GLOBALS['lang']['divers']['sousthemeref'].': '.empty_nc($yp_sdtheme).'</span> </p>'.END_LINE;
  77.       }
  78.       $content.='<hr />'.END_LINE;
  79.     }
  80.   }
  81.   else
  82.   {
  83.     $content.='<p class="info"> '.$GLOBALS['lang']['yp']['noresult'].'</p>';
  84.   }
  85.   echo $content;
  86.   echo Display_linkin_page($table_link, $bdd_nb_yp, $debut)."<br />";
  87.  
  88. }
  89.  
  90. /**
  91.  * DisplayAlphaBeta()
  92.  * affichage de la liste alphabétique
  93.  * @param $filter 
  94.  * @param $filter_id 
  95.  * @return 
  96.  ***/
  97. function DisplayAlphaBeta($filter,$filter_id){
  98.  
  99.   $result_alphabetical = $GLOBALS['sql_object'] -> DBSelect(SQL_get_req_alphabetical());
  100.  
  101.   $content='<div class="lienliste">'.END_LINE;
  102.   $content.=$GLOBALS['lang']['divers']['trialpha'].' :';
  103.   for($i=0; $i<count($result_alphabetical); $i++)  {
  104.     $link_aff_classic= HrefMaker(array('rub'=>$GLOBALS['links'][LANGUAGE]['directory']['linkvalue'], 'filter'=>"alpha", 'id'=>$result_alphabetical[$i]['first_letter']));
  105.     if ($i==0) $separator="";
  106.     else $separator="-";
  107.     if ($result_alphabetical[$i]['first_letter']==strtoupper($filter_id))
  108.     $content.=$separator.' <span>'.$result_alphabetical[$i]['first_letter'].'</span> '.END_LINE;
  109.     else $content.=$separator.' <a href="'.$link_aff_classic.'" title="'.$result_alphabetical[$i]['first_letter'].'" >'.$result_alphabetical[$i]['first_letter'].'</a> '.END_LINE;
  110.   }
  111.   $content.='</div>'.END_LINE;
  112.   echo  $content;
  113. }
  114.  
  115. /**
  116.  * DisplayOneYellowPages()
  117.  * affichage d'une organisation
  118.  * @param $yp_id 
  119.  * @return 
  120.  ***/
  121. function DisplayOneYellowPages($yp_id){
  122.  
  123.   $data= $GLOBALS['sql_object'] -> DBSelect(SQL_getdetyp($yp_id));
  124.   if($data!=0)
  125.   {
  126.  
  127.     $content= '';
  128.     for($i=0; $i<count($data); $i++) {
  129.       $link_table2= array('rub'=> $GLOBALS['links'][LANGUAGE]['directory']['linkvalue'],'filter'=> $GLOBALS['filters'][LANGUAGE]['theme']['linkvalue'],'id'=>$data[0]['sdtheme_id'], 'name'=>$data[0]['sdtheme_name']);
  130.       $yp_name=formatText($data[$i]['yellowp_name'], '2HTML');
  131.       $yp_activity=formatText(cutText($data[0]['yellowp_activity'],150), '2HTML');
  132.       $yp_sdtheme=formatText($data[0]['sdtheme_name'], '2HTML');
  133.       $yp_theme=formatText($data[0]['theme_name'], '2HTML');
  134.       $yp_street=formatText($data[0]['yellowp_street'], '2HTML');
  135.       $yp_postal_code=formatText($data[0]['yellowp_postal_code'], '2HTML');
  136.       $yp_city=formatText($data[0]['yellowp_city'], '2HTML');
  137.       $yp_phone=formatText($data[0]['yellowp_phone'], '2HTML');
  138.       $yp_fax=formatText($data[0]['yellowp_fax'], '2HTML');
  139.       $yp_email=formatText($data[0]['yellowp_email'], '2HTML');
  140.       $yp_website=formatText($data[0]['yellowp_website'], '2HTML');
  141.        
  142.       $content.='<h1>'.$yp_name.'</h1>'.END_LINE;
  143.       $content.='<dl id="det_yp"><dt> '.$GLOBALS['lang']['yp']['adresse'].' : </dt><dd>'.$yp_street.' '.$yp_postal_code.' '.$yp_city.'</dd>'.END_LINE;
  144.       $content.='<dt> '.$GLOBALS['lang']['yp']['phone'].' : </dt><dd>'.empty_nc($yp_phone).'</dd>'.END_LINE;
  145.       $content.='<dt> '.$GLOBALS['lang']['yp']['fax'].': </dt><dd>'.empty_nc($yp_fax).'</dd>'.END_LINE;
  146.       $content.='<dt> '.$GLOBALS['lang']['yp']['email'].' : </dt><dd><a href="mailto:'.$yp_email.'" title="'.formatText($yp_email, '2ATT').'">'.$yp_email.'</a></dd>'.END_LINE;
  147.       if ($data[0]['yellowp_website']<>"") $content.='<dt> '.$GLOBALS['lang']['yp']['website'].' : </dt><dd><a href="'.$data[0]['yellowp_website'].'" title="'.formatText($yp_website, '2ATT').'">'.$yp_website.'</a></dd>'.END_LINE;
  148.       else $content.='<dt> '.$GLOBALS['lang']['yp']['website'].' : </dt><dd>'.empty_nc($yp_website).'</dd>'.END_LINE;
  149.       $content.='<dt> '.$GLOBALS['lang']['yp']['activity'].' : </dt><dd>'.$yp_activity.'</dd>'.END_LINE;
  150.       if ($yp_sdtheme<>""){
  151.         $content.='<dt> '.$GLOBALS['lang']['divers']['themeref'].' : </dt><dd><a href="'.HrefMaker($link_table2).'" title="'.formatText($yp_sdtheme, '2ATT').'">'.$yp_sdtheme.'</a>
  152.             </dd><dt> '.$GLOBALS['lang']['divers']['sousthemeref'].': </dt><dd>'.$yp_theme.'
  153.             </dd>'.END_LINE;
  154.       }
  155.       else {
  156.         $content.='<dt> '.$GLOBALS['lang']['divers']['themeref'].' : </dt><dd>'.empty_nc($yp_sdtheme).' </dd><dt>'.$GLOBALS['lang']['divers']['sousthemeref'].': </dt><dd>'.empty_nc($yp_sdtheme).'</span> </dd>'.END_LINE;
  157.       }
  158.       $content.='</dl>'.END_LINE;
  159.     }
  160.   }
  161.   else
  162.   {
  163.     $content.='<p class="info">'.$GLOBALS['lang']['yp']['noresult'].'</p>';
  164.   }
  165.   echo $content;
  166.  
  167. }
  168.  
  169.  
  170. /**
  171.  * DisplayConfirmAdd()
  172.  * affichage confirmation de l'ajout
  173.  * @return 
  174.  ***/
  175. function DisplayConfirmAdd() {
  176.   $link_table= array('rub'=> $GLOBALS['links'][LANGUAGE]['directory']['linkvalue']);
  177.   $content='<p class="confirm">'.$GLOBALS['lang']['yp']['confirm_pub'].' <a href="'.HrefMaker($link_table).'" title="'.formatText($GLOBALS['lang']['yp']['confirm_pub2'], '2ATT').'" >'.$GLOBALS['lang']['yp']['confirm_pub2'].'</a>'.END_LINE;
  178.   $content.='</p>'.END_LINE;
  179.   echo $content;
  180. }
  181.  
  182. /**
  183.  * DisplayAddYellowPages()
  184.  * affichage formulaire d'ajout
  185.  * @param integer $btn 
  186.  * @param $table 
  187.  * @return 
  188.  ***/
  189. function DisplayAddYellowPages() {
  190.   include_once('../lib/input_helpers.php');
  191.   include_once('../class/class.yellowpages.php');
  192.   $form_name='';
  193.   $form_activity='';
  194.   $form_theme='';
  195.   $form_street='';
  196.   $form_postal_code='';
  197.   $form_city='';
  198.   $form_phone='';
  199.   $form_fax='';
  200.   $form_email='';
  201.   $form_website='';
  202.   $data= $GLOBALS['sql_object'] -> DBSelect(SQL_get_req_list_theme());
  203.   $select_theme=ThemeSelectBox($data, "yp_theme", $form_theme);
  204.   //  testing $_POST['yp_name'] and not $_POST['valider'] because of OPERA bug
  205.   if(isset($_POST['yp_name'])) {
  206.     $table[0]=$_POST['yp_name'];
  207.     $table[1]=$_POST['yp_activity'];
  208.     $table[2]=$_POST['yp_theme'];
  209.     $table[3]=$_POST['yp_street'];
  210.     $table[4]=$_POST['yp_postal_code'];
  211.     $table[5]=$_POST['yp_city'];
  212.     $table[6]='';
  213.     $table[7]=$_POST['yp_phone'];
  214.     $table[8]=$_POST['yp_fax'];
  215.     $table[9]=$_POST['yp_email'];
  216.     $table[10]=$_POST['yp_website'];
  217.     $table[11]="D";
  218.     $yp_object= new yellowpages;
  219.  
  220.     // prevent spam
  221.     if($_SESSION['securityaction']!=md5($_POST['securitycode'])) {
  222.       $integrity=$GLOBALS['lang']['security']['message'];
  223.     }
  224.     if(!isset($integrity)) $integrity=$yp_object->CheckDataIntegrity($table);
  225.  
  226.     if (is_string($integrity)) {
  227.       echo "<p class=\"error\">".$integrity."</p>";
  228.       $form_name=formatText($_POST['yp_name'], '2FIELD');
  229.       $form_activity=formatText($_POST['yp_activity'], '2FIELD');
  230.       $form_theme=$_POST['yp_theme'];
  231.       $form_street=formatText($_POST['yp_street'], '2FIELD');
  232.       $form_postal_code=$_POST['yp_postal_code'];
  233.       $form_city=formatText($_POST['yp_city'], '2FIELD');
  234.       $form_phone=$_POST['yp_phone'];
  235.       $form_fax=$_POST['yp_fax'];
  236.       $form_email=formatText($_POST['yp_email'], '2FIELD');
  237.       $form_website=formatText($_POST['yp_website'], '2FIELD');
  238.     } else {
  239.       $result=$yp_object->AddYellowPages($table, $GLOBALS['sql_object']);
  240.       $link_confirm=HrefMaker(array('rub'=> $GLOBALS['links'][LANGUAGE]['directory']['linkvalue']));
  241.       if(is_numeric($result)) DisplayConfirmAdd();
  242.       else  echo "<p class=\"error\">".system_error()."</p>";
  243.     }
  244.   }
  245.   if (!isset($integrity) || is_string($integrity)) {
  246.     $form='<h1>'.$GLOBALS['lang']['yp']['add_public'].'</h1>'.END_LINE;
  247.     $form.='<div class="h1_comment" id="h1_yellowpages">'.$GLOBALS['lang']['yp']['h1_public_add'].'</div>';
  248.     $form.='<form action="index.php" method="post">'.END_LINE;
  249.     $form.='<div id="ajout">'.END_LINE;
  250.     $form.='<p><label for="yp_name">'.$GLOBALS['lang']['yp']['name2'].'* : </label>'.END_LINE;
  251.     $form.='<input type="text" maxlength="150"  name="yp_name" id="yp_name" value="'.$form_name.'" class="textfield" /></p>'.END_LINE;
  252.     $form.='<p><label for="yp_activity">'.$GLOBALS['lang']['yp']['activity'].' * : </label>'.END_LINE;
  253.     $form.='<input type="text" maxlength="255"  name="yp_activity" id="yp_activity" value="'.$form_activity.'" class="textfield" /></p>'.END_LINE;
  254.     $form.='<p><label for="yp_theme">'.$GLOBALS['lang']['yp']['theme'].' : </label>'.END_LINE;
  255.     $form.=$select_theme.'</p>'.END_LINE;
  256.     $form.='<p><label for="yp_street">'.$GLOBALS['lang']['yp']['street'].' * : </label>'.END_LINE;
  257.     $form.='<input type="text" maxlength="200" class="textfield" name="yp_street" id="yp_street"  value="'.$form_street.'" /></p>'.END_LINE;
  258.     $form.='<p><label for="yp_postal_code">'.$GLOBALS['lang']['yp']['postal_code'].' * : </label>'.END_LINE;
  259.     $form.='<input type="text" maxlength="6" class="textfield" name="yp_postal_code" id="yp_postal_code" value="'.$form_postal_code.'" /></p>'.END_LINE;
  260.     $form.='<p><label for="yp_city">'.$GLOBALS['lang']['yp']['city'].' * : </label>'.END_LINE;
  261.     $form.='<input type="text" maxlength="100" class="textfield" name="yp_city" id="yp_city" value="'.$form_city.'" /></p>'.END_LINE;
  262.     $form.='<p><label for="yp_phone">'.$GLOBALS['lang']['yp']['phone'].' : </label>'.END_LINE;
  263.     $form.='<input type="text" maxlength="12" class="textfield" name="yp_phone" id="yp_phone" value="'.$form_phone.'" /></p>'.END_LINE;
  264.     $form.='<p><label for="yp_fax">'.$GLOBALS['lang']['yp']['fax'].' : </label>'.END_LINE;
  265.     $form.='<input type="text" maxlength="12" class="textfield" name="yp_fax" id="yp_fax" value="'.$form_fax.'" /></p>'.END_LINE;
  266.     $form.='<p><label for="yp_email">'.$GLOBALS['lang']['yp']['email'].' * : </label>'.END_LINE;
  267.     $form.='<input type="text" maxlength="150" class="textfield" name="yp_email" id="yp_email" value="'.$form_email.'" /></p>'.END_LINE;
  268.     $form.='<p><label for="yp_website">'.$GLOBALS['lang']['yp']['website'].' : </label>'.END_LINE;
  269.     $form.='<input type="text" maxlength="150" class="textfield" name="yp_website" id="yp_website" value="'.$form_website.'" /></p>'.END_LINE;
  270.     $form.='<p>'.END_LINE;
  271.     $form.='<span class="info">' . $GLOBALS['lang']['security']['info2'] . ' : </span>'.END_LINE;
  272.     $form.='<img src="../lib/securitycode.php" alt="' . $GLOBALS['lang']['security']['info2'] .'" id="securityimg"  />';
  273.     $form.='</p">'.END_LINE;
  274.     $form.='<p><label for="securitycode" >' . $GLOBALS['lang']['antispam']['info'] . ' : </label>'.END_LINE;
  275.     $form.='<input type="text" class="shorttextfield" id="securitycode" maxlength="5" name="securitycode" /></p> ';
  276.     $form.='<input type="hidden" id="rub_yp" value="'.$GLOBALS['links'][LANGUAGE]['directory-add']['linkvalue'].'" name="rub" /> ';
  277.     $form.='<input type="image" src="../gfx/' .THEME_PUBLIC. '/images/public/' .LANGUAGE. '/button_valid.gif" value="'.$GLOBALS['lang']['btn']['valid'].'" size="15" name="valider" id="valider" />'.END_LINE;
  278.     $form.='</div>'.END_LINE;
  279.     $form.='</form>'.END_LINE;
  280.  
  281.     echo $form;
  282.   }
  283. }
  284. ?>
Documentation generated on Sat, 08 Nov 2008 14:51:55 +0100 by phpDocumentor 1.4.1