File Source for list.php

<?php
/**
* @package linea21.modules
* @subpackage yellowpages
* @author linea21 <info@linea21.com>
* @version $id SVN
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
//////////// Check Inclusion de pages ////////////
if (!function_exists('AuthenthificationProcess')){
include_once("../lib/lib_common.php");
ReloadIndex('admin');
}
////////////
if(!isset($_GET['statut']) || $_GET['statut']==-1) $statut=-1;
elseif($_GET['statut']!=-1) {
$statut=$_GET['statut'];
$alphabeta=-1;
}
if(!isset($_GET['alphabeta']) || $_GET['alphabeta']==-1) $alphabeta=-1;
elseif($_GET['alphabeta']!=-1) {
$alphabeta=$_GET['alphabeta'];
$statut=-1;
}
if(!isset($_GET['debut'])) $debut=0;
else $debut=$_GET['debut'];
$mask_statut_1='';
$mask_statut_2='';
$mask_statut_3='';
if($statut=='P') $mask_statut_1='selected="selected"';
if($statut=='AA') $mask_statut_2='selected="selected"';
if($statut=='D') $mask_statut_3='selected="selected"';
// Nombre d'enregistrement total dans la bdd
$result_nb_req=$sql_object->DBSelect($req_count_yp);
$bdd_nb_yp=$result_nb_req[0]['num_rows'];
$bdd_nb_yp_display = $bdd_nb_yp." ".$GLOBALS['lang']['yp']['nb_total']."<br />\n";
if($statut!=-1 || $alphabeta!=-1) {
$link_back="<div class=\"filter\"><a href=\"".$rub_link."&todo=list\">".$GLOBALS['lang']['yp']['all']."</a></div>";
if($statut!=-1) {
$req_count_yp=SQL_getCountypList($statut);
$result_nb_req=$sql_object->DBSelect($req_count_yp);
$count_request=$result_nb_req[0]['num_rows'];
$req_list_yp=SQL_getypList($debut, SELECT_LIMIT, $statut);
$result_yp_list=$sql_object->DBSelect($req_list_yp);
}
if($alphabeta!=-1) {
$req_count_yp=SQL_getCountypList('ALPHA', $alphabeta);
$result_nb_req=$sql_object->DBSelect($req_count_yp);
$count_request=$result_nb_req[0]['num_rows'];
$req_list_yp=SQL_getypList($debut, SELECT_LIMIT, 'ALPHA', $alphabeta);
$result_yp_list=$sql_object->DBSelect($req_list_yp);
}
} else {
$link_back='';
$count_request=$bdd_nb_yp;
$req_list_yp=SQL_getypList($debut, SELECT_LIMIT, $statut);
$result_yp_list=$sql_object->DBSelect($req_list_yp);
}
if($count_request<=1) $count_request_display = $GLOBALS['lang']['divers']['query_result']." : ".$count_request." ".$GLOBALS['lang']['divers']['record']."<br />\n";
else $count_request_display = $GLOBALS['lang']['divers']['query_result']." : ".$count_request." ".$GLOBALS['lang']['divers']['records']."<br />\n";
$link_sup=$rub_link."&todo=sup&id=";
$link_mod=$rub_link."&todo=mod&id=";
$link_det=$rub_link."&todo=det&id=";
$link_statut=$rub_link."&todo=list&statut=";
$link_list_alphabetical=$rub_link."&todo=list&alphabeta=";
//&groupe=".$groupe."&alphabeta=".$alphabeta;"
$link_self=$link_statut.$statut."&alphabeta=".$alphabeta;
// Liste des statuts disponible
$select_statut="<select name=\"statut_filter\" id=\"statut_filter\" onchange=\"ChangeLocation(this)\">\n";
$select_statut.="<option value=\"-1\">".$GLOBALS['lang']['divers']['select_choice2']."</option>\n";
$select_statut.="<option value=\"".$link_statut."D\"".$mask_statut_3.">".$GLOBALS['lang']['yp']['preinscription']."</option>\n";
$select_statut.="<option value=\"".$link_statut."P\"".$mask_statut_1.">".display_statut('P')."</option>\n";
$select_statut.="<option value=\"".$link_statut."AA\"".$mask_statut_2.">".display_statut('AA')."</option>\n";
$select_statut.="</select>\n";
// Liste alphabetique
$result_alphabetical=$sql_object->DBSelect($req_alphabetical);
$select_alphabetical="<select name=\"alhpabetical_filter\" id=\"alhpabetical_filter\" onchange=\"ChangeLocation(this)\">\n";
$select_alphabetical.="<option value=\"-1\">".$GLOBALS['lang']['yp']['alphabetical']."</option>\n";
for($i=0; $i<count($result_alphabetical); $i++) {
if($alphabeta==$result_alphabetical[$i]['first_letter']) $mask=" selected=\"selected\""; else $mask='';
$select_alphabetical.="\t<option value=\"".$link_list_alphabetical.$result_alphabetical[$i]['first_letter']."\"".$mask.">".$result_alphabetical[$i]['first_letter']."</option>\n";
}
$select_alphabetical.="</select>\n";
?>
<div id="chemin">
<ul>
<li>
<a href="index.php"><? echo $GLOBALS['lang']['way']['home'] ?></a>
</li>
<li>
<a href="<?php echo $rub_link; ?>"><? echo $GLOBALS['lang']['menu']['yellowpages']?></a>
</li>
<li>
<span><? echo $GLOBALS['lang']['yp']['list'] ?></span>
</li>
</ul>
</div>
<?php
include_once("quickicons.php");
?>
<div class="contentcontainer">
<?php include_once($dir."/menurub.php"); ?>
<div id="content">
<?php
echo $link_back;
?>
<div class="filterselect">
<?php
echo $select_statut;
echo $select_alphabetical;
?>
</div>
<p><?php
echo $bdd_nb_yp_display;
echo $count_request_display;
?>
</p>
<?php
echo linkin_page($link_self, $count_request, $debut);
if($result_yp_list!=0) {
echo "<table cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<thead>\n";
echo "<tr>\n";
echo "<td style=\"width:40%\">".$GLOBALS['lang']['yp']['name2']."</td>\n";;
echo "<td>".$GLOBALS['lang']['divers']['date_crea']."</td>\n";
echo "<td> <span class=\"semnone\">".$GLOBALS['lang']['divers']['actions']."</span></td>\n";
echo "</tr>\n";
echo "</thead>\n";
echo "<tbody>\n";
for($i=0; $i<count($result_yp_list); $i++) {
$yp_title=formatText($result_yp_list[$i]['yellowp_name'], '2HTML');
$yp_title=cutText($yp_title, 35, 1);
echo "<tr>\n";
echo "<td><a href=\"".$link_det.$result_yp_list[$i]['yellowp_id']."\" title=\"".$GLOBALS['lang']['yp']['det']."\">".$yp_title."</a></td>\n";
echo "<td>".$result_yp_list[$i]['yellowp_date_crea_display']."</td>\n";
echo "<td><div class=\"iconetab\"><a href=\"".$link_sup.$result_yp_list[$i]['yellowp_id']."\" title=\"".$GLOBALS['lang']['yp']['sup']."\" class=\"ico_sup\"></a>";
echo "<a href=\"".$link_mod.$result_yp_list[$i]['yellowp_id']."\" title=\"".$GLOBALS['lang']['yp']['mod']."\" class=\"ico_mod\"></a></div></td>\n";
echo "</tr>\n";
}
echo "</tbody>";
echo "</table>";
} else {
echo "<div class=\"info\">".$GLOBALS['lang']['yp']['noresult']."</div>";
}
echo linkin_page($link_self, $count_request, $debut);
?>
</div>
<?php include_once($dir."/help.php"); ?>
</div>

Source for file list.php