1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
D.debut_garde,
D.fin_garde,
DT.num_devis,
C.num_client,
C.nom,
C.prenom,
C.adresse1,
C.ville,
C.pays,
C.telephone1,
C.portable1,
A.num_tatou_animal,
A.nom_animal,
A.date_naissance_animal,
A.genre_animal,
A.poids_animal,
A.sex_animal,
A.steriliser_animal,
A.vacciner_animal,
A.observation_animal,
R.nom_race,
P.nom_prest,
(DATEDIFF(D.fin_garde,D.debut_garde)+1) AS nb_jours,
CURRENT_DATE, (YEAR(CURRENT_DATE)-YEAR(A.date_naissance_animal))-(RIGHT(CURRENT_DATE,5)<RIGHT(A.date_naissance_animal,5)) AS age
FROM devis_prest_tab D
JOIN devis_tab DT ON DT.num_devis=D.num_devis
JOIN clients C ON C.num_client=DT.num_client
JOIN animal A ON A.num_client=C.num_client
JOIN liste_race_chien R ON R.ID_race=A.race_animal
JOIN prestation P ON P.ID_prest=D.ID_prest
WHERE (DT.etat_devis=:etat_devis AND D.debut_garde>=:date3 AND D.debut_garde<=:date4) OR DT.num_devis=:num_devis
GROUP BY A.ID_animal
ORDER BY A.genre_animal desc, C.ID_client, D.debut_garde');
try {
$parametres = array(
':etat_devis'=>'valider',
':date3'=>$date3,
':date4'=>$date4,
':num_devis'=>$num_devis
);
$select1->execute($parametres);
} catch(Exception $e) {
echo 'Problème de liaison à la base de données : ', $e->getMessage();exit();
}
$tab_client = $select1->fetchAll(PDO::FETCH_OBJ);
$smarty->assign('client', $tab_client);
$select1->closeCursor(); |
Partager