1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| public function commentairesPeriode($PER_ID, $date_debut, $date_fin)
{
$db = $this->getAdapter();
$stmt = $db->prepare("
SELECT *
FROM COMMENTAIRES C
WHERE C.PER_ID = :PER_ID
AND C.COM_SAI_DATE >= to_date(:date_debut, 'YYYY-MM-DD')
AND C.COM_SAI_DATE <= to_date(:date_fin, 'YYYY-MM-DD')
ORDER BY C.COM_SAI_DATE
");
$stmt->bindParam(':PER_ID', $PER_ID);
$stmt->bindParam(':DATE_DEBUT', "'".$date_debut."'");
$stmt->bindParam(':DATE_FIN', "'".$date_fin."'");
$stmt->execute();
return $stmt->fetchAll(); |
