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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
| <!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<meta http-equiv="Refresh" content="10" >
<link rel="stylesheet" href="app.css">
</head>
<body>
<br />
<br />
<div class="boite" ><?php echo "Semaine du : " .$debut_fin_semaine[0] . " au " . $debut_fin_semaine [6]; ?></div>
<img class="image1" src="test.png" >
<br />
<br />
<br />
<table id="tableau" border="1" cellspacing="1" cellpadding="36">
<?php
$objDatedebut = date_create();
if ($objDatedebut->format('N') != 1) {
$objDatedebut->modify('last monday');
}
$objDatefin = clone $objDatedebut;
$objDatefin->modify('+ 6 day');
$sth=$pdo->prepare("SELECT SALLE, PRODUITS, JOUR_DEBUT, JOUR_FIN, COULEUR, TECHNICIEN FROM planning WHERE SALLE IN ('MONTAGE_1','MONTAGE_2','MONTAGE_3','MONTAGE_4','MONTAGE_5','MIXAGE','MONTAGE_SON')AND JOUR_DEBUT <=:j_fin AND JOUR_FIN >=:j_debut ");
$sth->execute(array(':j_debut'=>$objDatedebut->format('Y-m-d'),
':j_fin'=>$objDatefin->format('Y-m-d')
));
while ($donnees = $sth->fetch(PDO::FETCH_ASSOC)) {
$objDatedebut_produit = date_create($donnees['JOUR_DEBUT']);
$objDatefin_produit = date_create($donnees['JOUR_FIN']);
if ($objDatefin_produit > $objDatefin) {
$njours = $objDatedebut_produit->diff($objDatefin);
}
else {
$njours = $objDatedebut_produit->diff($objDatefin_produit);
}
$data[$donnees['SALLE']][$objDatedebut_produit->format('Y-m-d')] = array('produit'=>$donnees['PRODUITS'], 'colors'=>$donnees['COULEUR'], 'tech'=>$donnees['TECHNICIEN'], 'njours'=>$njours->format('%a'));
}
?>
<tr>
<td class= "cells" >Salles</td>
<td class= "date" ><?php echo $debut_fin_semaine[0]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[1]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[2]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[3]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[4]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[5]; ?></td>
<td class= "date" ><?php echo $debut_fin_semaine[6]; ?></td>
</tr>
<?php
$tblSalles = array(
'MONTAGE_1' => 'MONTAGE 1',
'MONTAGE_2' => 'MONTAGE 2',
'MONTAGE_3' => 'MONTAGE 3',
'MONTAGE_4' => 'MONTAGE 4',
'MONTAGE_5' => 'MONTAGE 5',
'MIXAGE' => 'MIXAGE',
'MONTAGE_SON' => 'MONTAGE SON'
);
foreach ($tblSalles as $key=>$Salle) {
echo '<tr>
<td class="salle">' . $Salle . '</td>';
for ($date = clone $objDatedebut; $date <= $objDatefin; $date->modify('+1 day')) {
if ($key === 'Salles') {
echo '<th>' . $case = $date->format('d/m/Y') . '</th>';
}else {
if (isset($data[$key][$date->format('Y-m-d')])) {
$values = $data[$key][$date->format('Y-m-d')];
if (isset($data[$Salle])=='MIXAGE' ){
$categories = " Mixage : ";
echo '<td class="back" style="background-color:'. ($values['colors']) .' "" colspan="' . ($values['njours'] + 1). '">' . htmlspecialchars($values['produit']).'<br />' .$categories. tmlspecialchars($values['tech']) .'</td>';
$date->modify('+' . $values['njours'] . ' days');
}
elseif ($values['njours']<= 4) AND ( $data[$Salle])=='MONTAGE_3' ) {
$categories = "Co-Co : ";
echo '<td class="back" style="background-color:'. ($values['colors']) .' "" colspan="' . ($values['njours'] + 1). '">' . htmlspecialchars($values['produit']).'<br />' .$categories. htmlspecialchars($values['tech']) .'</td>';
$date->modify('+' . $values['njours'] . ' days');
}else{
$categories = " Montage : ";
echo '<td class="back" style="background-color:'. ($values['colors']) .' "" colspan="' . ($values['njours'] + 1). '">' . htmlspecialchars($values['produit']).'<br />' .$categories. htmlspecialchars($values['tech']) .'</td>';
$date->modify('+' . $values['njours'] . ' days');
}
} else {
echo '<td></td>';
}
}
}
echo '</tr>';
}
?>
</table>
</body>
</html> |
