Bonsoir,
je suis entrain d'essayer de faire un systeme de reservations et je rencontre un soucis sur la recuperation de champ date,
j'ai une date de debut et une date de fin (datepicker), j arrive a recuperer les dates de debut mais lorsque je veux recuperer les dates de fin la il ne me la prends pas!!!
auriez vous une petite idee de là ou je me trompe ?
je depose le code ci-dessous:
merci d'avance
Gilles
[code]
<?php
include '/lib/includes.php';
include '/partials/header.php';
/**
- Récuperation liste des agences
*/
}
/**
- Récuperation liste des TYPES
*/
select = $db->query('SELECT types.id, types.name FROM types ORDER BY name ASC'); $types = $select->fetchAll(); $types_list = array(); foreach( types astype){ $types_list[ type->id] = $type->name;
}
$agence='';
$type='';
$conditions = '';
if(!isset(
$select = $db->query("SELECT res.categorie, res.datedepart, agences.name, COUNT(numres) AS compteur
FROM res
LEFT JOIN agences ON res.agencedepart=agences.numeric
GROUP BY datedepart, name, categorie
");
$resas = $select->fetchAll();
}elseif (isset($_POST['numagence'])){
$agence=$db->quote($_POST['numagence']);
$conditions = "WHERE res.agencedepart=$agence";
$select = $db->query("SELECT res.categorie, res.datedepart, COUNT(numres) AS compteur, agences.name
FROM res
LEFT JOIN agences ON res.agencedepart=agences.numeric
$conditions
GROUP BY datedepart, categorie
");
$resas = $select->fetchAll();
$select = $db->query("SELECT agences.name
FROM agences
WHERE agences.numeric=$agence
");
$recupagence = $select->fetch();
}elseif (isset($_POST['type'])){
$type=$db->quote($_POST['type']);
$conditions = "WHERE agences.type_id=$type";
$select = $db->query("SELECT res.categorie, res.datedepart, COUNT(numres) AS compteur, agences.name
FROM res
LEFT JOIN agences ON res.agencedepart=agences.numeric
$conditions
GROUP BY name, datedepart, categorie
");
$resas = $select->fetchAll();
}elseif (isset($_POST['datedebut'])){
$debut=$db->quote($_POST['datedebut']);
$conditions = "WHERE res.datedepart>=$debut";
$select = $db->query("SELECT res.categorie, res.datedepart, COUNT(numres) AS compteur, agences.name
FROM res
LEFT JOIN agences ON res.agencedepart=agences.numeric
$conditions
GROUP BY name, datedepart, categorie
");
$resas = $select->fetchAll();
}elseif (isset($_POST['datefin'])){
$fin=$db->quote($_POST['datefin']);
$conditions = "WHERE res.datedepart<=$fin";
$select = $db->query("SELECT res.categorie, res.datedepart , COUNT(numres) AS compteur, agences.name
FROM res
LEFT JOIN agences ON res.agencedepart=agences.numeric
$conditions
GROUP BY name, datedepart, categorie
");
$resas = $select->fetchAll();
}
?>
<div class="row">
<div class="large-12 columns">
<fieldset>
<form action="#" method="post">
<div class="row">
<div class="large-3 columns">
<label>Agences :</label>
<select name="numagence">
<option value="" disabled selected>Please select an option</option>
<?php foreach(
<h3><?= $recupagence->name; ?></h3>
<?php endif; ?>
<table class="table table-striped">
<thead>
<tr>
<th>Agence</th>
<th>Date résas</th>
<th>Catégorie</th>
<th>Nbre résas</th>
</tr>
</thead>
<tbody>
<?php foreach(
<td><?= (date("d/m/Y",strtotime($resa->datedepart))); ?></td>
<td><?= $resa->categorie; ?></td>
<td><?= $resa->compteur; ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</fieldset>
<br />
</div>
</div>
<?php include '/partials/footer.php'; ?>
[/code]