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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
| function writeBateau($TabBateauxDispos, $dateTimeDebut, $dateTimeFin, $libelleSejour)
{
global $_LANGUE;
static $i = 0;
$numBateau = $TabBateauxDispos["numbateau"];
$dateTimeChoisie = mktime(0, 0, 0, $_SESSION['mois_select'], $_SESSION['jour_select'], $_SESSION['annee_select']);
$reqBateau = mysql_query("SELECT numbateau, numproprietaire, numgroupe, basedefaut, modele, nbpersonnesmax, cabines, lien
FROM bateau
WHERE numbateau=$numBateau");
$resBateau = mysql_fetch_array($reqBateau);
// On va chercher les paramètres du loueur (calcul de convoyage)
$reqParametres = mysql_query("SELECT compterconvoyage, compternbconvoyages
FROM parametres
WHERE numproprietaire=".$resBateau['numproprietaire']);
$resParametres = mysql_fetch_array($reqParametres);
if ($resParametres['compterconvoyage'])
{
print("<SCRIPT LANGUAGE='JavaScript'>
var compterConvoyage = true;
</SCRIPT>");
}
else
{
print("<SCRIPT LANGUAGE='JavaScript'>
var compterConvoyage = false;
</SCRIPT>");
}
// On va chercher une photo
$reqPhoto = mysql_query("SELECT path
FROM photo
WHERE numphoto IN (SELECT numphoto
FROM illustrer
WHERE numbateau=$numBateau
)
ORDER BY RAND()
LIMIT 1");
// On récupère le séjour
$reqSejour = mysql_query("SELECT *
FROM sejour
WHERE libelle='$libelleSejour'
AND numproprietaire=".$resBateau['numproprietaire']);
$resSejour = mysql_fetch_array($reqSejour);
// On récupère toutes les périodes sur lesquelles s'étale le séjour
$reqPeriode = mysql_query("SELECT numperiode, datedebut, datefin
FROM periode
WHERE (('".date("Y-m-d", $dateTimeDebut)."' BETWEEN datedebut AND datefin
OR '".date("Y-m-d", $dateTimeFin)."' BETWEEN datedebut AND datefin)
OR ((datedebut BETWEEN '".date("Y-m-d", $dateTimeDebut)."' AND '".date("Y-m-d", $dateTimeFin)."'
OR datefin BETWEEN '".date("Y-m-d", $dateTimeDebut)."' AND '".date("Y-m-d", $dateTimeFin)."')))
AND numproprietaire=".$resBateau['numproprietaire']."
ORDER BY datedebut ASC");
print("<SCRIPT LANGUAGE='JavaScript'>
TabNumPromoDivers[$numBateau] = new Array();
TabPrixPromoDivers[$numBateau] = new Array();
TabPrixPeriode[$numBateau] = new Array();
</SCRIPT>");
// On parcourt les périodes
$prixLocation = 0;
$promoDuree = 0;
$promoEarlyBooking = 0;
$promoDiversLocation = 0;
$joursComptes = 0;
$dateTimeEnCours = $dateTimeDebut;
$nbJoursAvantDepart = diffDateTime($dateTimeDebut, mktime(0, 0, 0));
$nbJoursSejour = diffDateTime($dateTimeFin, $dateTimeDebut);
// TABLEAUX
// divers
$TabNumPromoDivers = array();
$TabPrixPromoDivers = array();
$numPromoDivers = array();
$prixPromoDivers = array();
// Période
$TabPrixPeriode = array();
while ($resPeriode = mysql_fetch_array($reqPeriode))
{
// Recherche du tarif
$reqTarif = mysql_query("SELECT prix
FROM tarif
WHERE numsejour=".$resSejour['numsejour']."
AND numoffre IN (SELECT numoffre
FROM offre
WHERE numperiode=".$resPeriode['numperiode']."
AND numbateau=$numBateau
)");
$resTarif = mysql_fetch_array($reqTarif); |
