Voici le cod controller.php
=========================
<?php
/**
* @version $Id: header.php 756 2008-12-08 14:24:02Z elkuku $
* @package joomloc
* @subpackage
* @author EasyJoomla {@link
www.easy-joomla.org Easy-Joomla.org}
* @author Nikolai Plath {@link
www.easy-joomla.org}
* @author Created on 26-Feb-2009
*/
// no direct access
defined( '_JEXEC' ) or die( '=

' );
jimport('joomla.application.component.controller');
/**
* joomloc Controller
*
* @package joomloc
* @subpackage Controllers
*/
class joomlocController extends JController
{
/**
* Method to display the view
*
* @access public
*/
function display()
{
parent::display();
}
//--------------ajax functions----------------------
function getconfig()
{
$db =& JFactory::getDBO();
$query = "SELECT * FROM --#__lbresa_config";
$db->setQuery( $query );
$config = $db->loadObject();
return $config;
}
function listepays()
{
global $mainframe;
$continent_id = JRequest::getVar('continent_id');
$model = $this->getModel('sites');
$ps = $model->getPays($continent_id);
$return ='<select name="s_pays" id="s_pays" onchange="ajaxGetRegions(this.value)">';
$return .= "<option value=''>".JText::_( '---SELECTIONNEZ_UN_PAYS---' )."</option>";
foreach ($ps as $pays) {
$return .="<option value='".$pays->id."'>".$pays->nom."</option>";
}
$return .='</select>';
echo $return;
$mainframe->close();
}
function listeregions()
{
global $mainframe;
$pays_id=JRequest::getVar( 'pays_id');
$model = $this->getModel('sites');
$regions = $model->getPays($pays_id);
$return ='<select name="s_region" id="s_region" onchange="ajaxGetDeps(this.value)">';
$return .= "<option value=''>".JText::_( '---SELECTIONNEZ_UNE_REGION---' )."</option>";
if(is_array($regions)) {
foreach ($regions as $region) {
$return .="<option value='".$region->id."'>".$region->nom."</option>";
}
}
$return .= "</select>";
echo $return;
$mainframe->close();
}
function listedeps()
{
global $mainframe;
$region_id=JRequest::getVar( 'region_id');
$model = $this->getModel('sites');
$deps = $model->getDeps($region_id);
$return = '<select name="s_dep" id="s_dep" onchange="ajaxGetVilles(this.value)">';
$return .= "<option value=''>".JText::_( '---SELECTIONNEZ_UN_DEPARTEMENT---' )."</option>";
if(is_array($deps)) {
foreach ($deps as $dep) {
$return .="<option value='".$dep->id."'>".$dep->nom." - ".$dep->cp."</option>";
}
}
$return .= "</select>";
echo $return;
$mainframe->close();
}
function listevilles()
{
global $mainframe;
$dep_id=JRequest::getVar( 'dep_id');
$model = $this->getModel('sites');
$villes = $model->getVilles($dep_id);
$return = '<select name="s_ville" id="s_ville" >';
$return .= "<option value=''>".JText::_( '---SELECTIONNEZ_UNE_VILLE---' )."</option>";
if(is_array($villes)) {
foreach ($villes as $ville) {
$return .="<option value='".$ville->id."'>".$ville->nom." - ".$ville->cpv."</option>";
}
}
$return .= "</select>";
echo $return;
$mainframe->close();
}
function GetBookings()
{
global $mainframe;
$db =& JFactory::getDBO();
$config =& $this->getconfig();
$id_site = JRequest::getVar('id_site');
$month = JRequest::getVar('month');
$year = JRequest::getVar('year');
$del = JRequest::getVar('del');
if($month<13)
{
$d_a = $year."-".$month."-01";
$d_b = $year."-".$month."-31";
}
elseif($month==13)
{
$d_a = $year."-01-01";
$d_b = $year."-12-31";
}
//-----------del resa
if($del!=0)
{
$query = "DELETE FROM --#__lbresa_resas WHERE ref = '$del'";
$db->setQuery( $query );
$db->query();
}
//----------------
$query = "SELECT * FROM --#__lbresa_resas WHERE id_site = '$id_site' and date_debut >= '$d_a' and date_debut <= '$d_b' order by date_debut desc";
$db->setQuery( $query );
$bookings = $db->loadObjectList();
$n_bookings = count($db->loadObjectList());
if($n_bookings > 0)
{
$nob = JHTML::_('date', $d_a, 'Y');
echo "<b>".$n_bookings." ".JText::_( 'RESERVATIONS_POUR:' )." $nob</b><br><hr>";
foreach($bookings as $booking)
{
echo "<a href=\"javascript:openbooking('".$booking->id."','".$booking->ref."');\" title='".JText::_( 'AFFICHER_LE_DETAIL' )."'><b>".JText::_( 'REF_:')."</b> ".$booking->ref." :: <u><b>".JText::_( 'ARRIVEE_LE_:' )."</b></u> ".JHTML::_('date', $booking->date_debut, 'l d-m-Y')." :: <u><b>".JText::_( 'CLIENT_:')."</b></u> ".$booking->nom.", ".$booking->prenom."";
echo "</a><div id='booking_$booking->id' class='detail_booking' style='display:block'></div><bR>";
}
}
else
{
$nob = JHTML::_('date', $d_a, 'F Y');
echo JText::_( 'PAS_DE_RESERVATION_POUR_:' )."<b> $nob</b>";
}
$mainframe->close();
}
function GetBookingDetails()
{
global $mainframe;
$db =& JFactory::getDBO();
$config =& $this->getconfig();
$id = JRequest::getVar('id');
$ref = JRequest::getVar('ref');
$print = JRequest::getVar('print');
$query = "SELECT * FROM --#__lbresa_resas WHERE id= '$id' and ref = '$ref'";
$db->setQuery( $query );
$booking = $db->loadObject();
if($booking->nom_cb) { $cb =1; } else { $cb=""; }
$query = "SELECT * FROM --#__lbresa_sites WHERE id= '$booking->id_site'";
$db->setQuery( $query );
$site = $db->loadObject();
$month = JHTML::_('date', $booking->date_debut, ' m');
$year = JHTML::_('date', $booking->date_debut, 'Y');
echo "<hr>";
if(!$print)
{
echo "<a href=\"javascript:closebooking('".$id."','".$ref."');\"><b>".JText::_( '***_FERMER_LE_DETAIL_***' )."</b></a><bR>";
}
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr><td colspan='2'><h3>$site->s_nom</h3></td><td>";
echo "</td><td>";
if(!$print)
{
echo "<input type='button' class='button' value='".JText::_( 'SUPPRIMER_CETTE_RESERVATION_DEFINITIVEMENT' )."' onclick=\"ajaxGetBookings('".$booking->id_site."','".$month."', '".$year."', '".$ref."' )\">";
}
echo "</td></tr>
<tr>
<td><b>".JText::_( 'REF_RESERVATION_:' )."</b></td><td>$booking->ref";
echo "</td>
<td><b>".JText::_( 'DATE_RESERVATION_:' )."</b></td><td>".JHTML::_('date', $booking->date_resa, 'l d-m-Y')."</td>
</tr>
<tr>
<td><b>".JText::_( 'NOM_:' )."</b></td><td>$booking->nom</td>
<td><b>".JText::_( 'ARRIVEE_LE_:' )."</b></td><td>".JHTML::_('date', $booking->date_debut, 'l d-m-Y')."</td>
</tr>
<tr>
<td><b>".JText::_( 'PRENOM_:' )."</b></td><td>$booking->prenom</td>
<td><b>".JText::_( 'DEPART_LE_:' )."</b></td><td>".JHTML::_('date', $booking->date_fin, 'l d-m-Y')."</td>
</tr>
<tr>
<td><b>".JText::_( 'ADRESSE_:' )."</b></td><td>$booking->adresse</td>
<td></td><td></td>
</tr>
<tr>
<td><b>".JText::_( 'VILLE_:')."</b></td><td>$booking->ville</td>
<td></td><td></td>
</tr>
<tr>
<td><b>".JText::_( 'CODE_POSTAL_:')."</b></td><td>$booking->cp</td>
<td>"; if($cb) { echo JText::_( 'TYPE_CB_:'); } echo "</td><td>"; if($cb) { echo $booking->nom_cb; } echo "</td>
</tr>
<tr>
<td><b>".JText::_( 'PAYS_:')."</b></td><td>$booking->pays</td>
<td>"; if($cb) { echo JText::_( 'NUM._CB_:'); } echo "</td><td>"; if($cb) { echo $booking->num_cb; } echo "</td>
</tr>
<tr>
<td><b>".JText::_( 'TEL_:' )."</b></td><td>$booking->tel</td>
<td>"; if($cb) { echo JText::_( 'DATE_EXPIRATION_:'); } echo "</td><td>"; if($cb) { echo $booking->date_cb; } echo "</td>
</tr>
<tr>
<td><b>".JText::_( 'E-MAIL_:' )."</b></td><td>$booking->mail</td>
<td>"; if($cb) { echo JText::_( 'NOM_DU_PORTEUR_:'); } echo "</td><td>"; if($cb) { echo $booking->owner_cb; } echo "</td>
</tr>
<tr>
<td><b>".JText::_( 'MESSAGE:' )."</b></td><td>$booking->message</td>
<td></td>
</tr>
<tr><td colspan='4'><hr></td></tr>
<tr><td colspan='4' valign='top'>";
$query = "SELECT * FROM --#__lbresa_resas WHERE ref = '$ref' order by id asc";
$db->setQuery( $query );
$rooms = $db->loadObjectList();
$query = "SELECT SUM(pax) FROM --#__lbresa_resas WHERE ref = '$ref'";
$db->setQuery( $query );
$pax = $db->loadResult();
$query = "SELECT SUM(enf) FROM --#__lbresa_resas WHERE ref = '$ref'";
$db->setQuery( $query );
$enf = $db->loadResult();
$query = "SELECT SUM(sup_enf) FROM --#__lbresa_resas WHERE ref = '$ref' and enf>0";
$db->setQuery( $query );
$total_sup_enf = $db->loadResult();
$query = "SELECT SUM(qtte) FROM --#__lbresa_resas WHERE ref = '$ref'";
$db->setQuery( $query );
$qtte = $db->loadResult();
//RECAP
echo "<table width='100%' cellpadding='0' cellspacing='0' border='1'>
<tr>
<th align='center'><b>".JText::_( 'NOMBRE_DE_CHAMBRES' )."</b></th>
<th align='center'><b>".JText::_( 'NOMBRE_PERSONNES' )."</b></th>
<th align='center'><b>".JText::_( 'NOMBRE_D_ENFANTS' )."</b></th>
<th align='center'></th>
</tr>";
echo "
<tr>
<td align='center'><b>$qtte</B></td>
<td align='center'><b>$pax</b></td>
<td align='center'><b>$enf</b></td>
<td align='center'><b></td>
</tr>";
echo "</table>";
echo "<br>";
echo "</td>
</tR>
<tr><td colspan='2' align='center'>";
if(!$print)
{
echo "<a href='index.php?option=com_joomloc&controller=sites&view=sites&layout=print&task=GetBookingDetails&id=$id&ref=$ref&tmpl=component' target='_blank'><img src='images/print_f2.png' border='0'><br>".JText::_( 'IMPRIMER' )."</a>";
}
elseif($print)
{
echo "<input type='button' value='".JText::_( 'IMPRIMER' )."' onclick='window.print()'>";
}
echo "</td><td colspan='2' align='center'></td></tr>
</table><hr>";
$mainframe->close();
}
function Cancelresa()
{
global $mainframe;
$db =& JFactory::getDBO();
$id = JRequest::getVar('id');
$ref = JRequest::getVar('ref');
$query = "UPDATE --#__lbresa_resas SET etat = '3' where ref = '$ref'";
$db->setQuery( $query);
$db->Query();
$mainframe->close();
}
function Validresa()
{
global $mainframe;
$db =& JFactory::getDBO();
$id = JRequest::getVar('id');
$ref = JRequest::getVar('ref');
$query = "UPDATE --#__lbresa_resas SET etat = '2' where ref = '$ref' and nom_cb=''";
$db->setQuery( $query);
$db->Query();
$query = "UPDATE --#__lbresa_resas SET etat = '0' where ref = '$ref' and nom_cb!=''";
$db->setQuery( $query);
$db->Query();
$mainframe->close();
}
}