foreach imbriqués pour récupération de données

**Supernatural** · 11/08/2017, 15h42

Bonjour,

Je souhaite faire des foreach imbriqués sur un résultat de requêtes mySQL.

Je récupère dans un premier 'foreach' les résultats de ma requête 1, ensuite je voudrais un second 'foreach' qui me récupère les valeurs pour chaque valeurs trouvées dans le premier foreach et mettre 0 comme valeur si rien trouvé...

En gros:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
 
foreach($NumNccUnique as $NumNccUnique){
		echo "name: '".$NumNccUnique['ErrorNumber']."',".'<br>';
 
			foreach(POUR CHAQUE VALEURS $NumNccUnique['ErrorNumber'] JE RECUPERE LES VALEURS ASSOCIEES){
				echo 'ici les valeurs';
	}
	echo "]";
	echo '<br>';
 
 
}

Merci par avance

Invité · 11/08/2017, 17h09

Bonjour,

fais un var_dump($NumNccUnique), et tu sauras ce qu'il contient et comment le traiter.

**sabotage** · 11/08/2017, 21h33

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

$NumNccUnique as $NumNccUnique

C'est normal que tu aies mis deux fois la même variable?

**Supernatural** · 14/08/2017, 06h40

Heu non, c'est une erreur de ma part...

Oui le var_dump j'ai déjà fait...

En fait, je me suis mal exprimé, j'ai cogité ce week-end...

Voici le résultat de ma requête:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
 
Line,CSL,Semaine,QtyByNCCcode,CodeNCC
SUV_1,"Xr3_Vz",1,1,1
SUV_1,"Xr3_Vz",1,3,101
SUV_1,"Xr3_Vz",1,4,102
SUV_1,"Xr3_Vz",1,27,104
SUV_1,"Xr3_Vz",1,53,105
SUV_1,"Xr3_Vz",1,18,106
SUV_1,"Xr3_Vz",1,1,107
SUV_1,"Xr3_Vz",1,1,999
SUV_1,"Xr3_Vz",2,2,101
SUV_1,"Xr3_Vz",2,4,102
SUV_1,"Xr3_Vz",2,30,104
SUV_1,"Xr3_Vz",2,20,105
SUV_1,"Xr3_Vz",2,8,106
SUV_1,"Xr3_Vz",2,1,109
SUV_1,"Xr3_Vz",2,3,113
SUV_1,"Xr3_Vz",2,1,3
SUV_1,"Xr3_Vz",2,8,999
SUV_1,"Xr3_Vz",3,7,101
SUV_1,"Xr3_Vz",3,1,102
SUV_1,"Xr3_Vz",3,13,104
SUV_1,"Xr3_Vz",3,21,105
SUV_1,"Xr3_Vz",3,9,106
SUV_1,"Xr3_Vz",3,1,999
SUV_1,"Xr3_Vz",4,14,101
SUV_1,"Xr3_Vz",4,12,104
SUV_1,"Xr3_Vz",4,12,105
SUV_1,"Xr3_Vz",4,3,106
SUV_1,"Xr3_Vz",4,2,110
SUV_1,"Xr3_Vz",4,4,113
SUV_1,"Xr3_Vz",4,1,999
SUV_1,"Xr3_Vz",5,5,101
SUV_1,"Xr3_Vz",5,3,104
SUV_1,"Xr3_Vz",5,7,105
SUV_1,"Xr3_Vz",5,5,106
SUV_1,"Xr3_Vz",5,2,110
SUV_1,"Xr3_Vz",6,2,101
SUV_1,"Xr3_Vz",6,4,102
SUV_1,"Xr3_Vz",6,2,103
SUV_1,"Xr3_Vz",6,4,104
SUV_1,"Xr3_Vz",6,5,105
SUV_1,"Xr3_Vz",6,4,106
SUV_1,"Xr3_Vz",6,1,110
SUV_1,"Xr3_Vz",7,1,1
SUV_1,"Xr3_Vz",7,5,101
SUV_1,"Xr3_Vz",7,1,102
SUV_1,"Xr3_Vz",7,4,104
SUV_1,"Xr3_Vz",7,21,105
SUV_1,"Xr3_Vz",7,6,106
SUV_1,"Xr3_Vz",7,2,110
SUV_1,"Xr3_Vz",7,1,112
SUV_1,"Xr3_Vz",7,1,113
SUV_1,"Xr3_Vz",8,1,101
SUV_1,"Xr3_Vz",8,4,102
SUV_1,"Xr3_Vz",8,1,103
SUV_1,"Xr3_Vz",8,19,104
SUV_1,"Xr3_Vz",8,9,105
SUV_1,"Xr3_Vz",8,11,106
SUV_1,"Xr3_Vz",8,1,109
SUV_1,"Xr3_Vz",8,1,110
SUV_1,"Xr3_Vz",8,5,113
SUV_1,"Xr3_Vz",9,2,101
SUV_1,"Xr3_Vz",9,2,102
SUV_1,"Xr3_Vz",9,1,103
SUV_1,"Xr3_Vz",9,45,104
SUV_1,"Xr3_Vz",9,10,105
SUV_1,"Xr3_Vz",9,2,106
SUV_1,"Xr3_Vz",9,1,109
SUV_1,"Xr3_Vz",9,2,110
SUV_1,"Xr3_Vz",9,2,113
SUV_1,"Xr3_Vz",9,2,999
SUV_1,"Xr3_Vz",10,4,104
SUV_1,"Xr3_Vz",10,6,105
SUV_1,"Xr3_Vz",10,5,106
SUV_1,"Xr3_Vz",10,3,113
SUV_1,"Xr3_Vz",11,1,101
SUV_1,"Xr3_Vz",11,1,102
SUV_1,"Xr3_Vz",11,6,104
SUV_1,"Xr3_Vz",11,22,105
SUV_1,"Xr3_Vz",11,10,106
SUV_1,"Xr3_Vz",11,1,109
SUV_1,"Xr3_Vz",11,1,110
SUV_1,"Xr3_Vz",11,1,112
SUV_1,"Xr3_Vz",11,8,113
SUV_1,"Xr3_Vz",11,4,999
SUV_1,"Xr3_Vz",12,7,101
SUV_1,"Xr3_Vz",12,3,102
SUV_1,"Xr3_Vz",12,1,103
SUV_1,"Xr3_Vz",12,8,104
SUV_1,"Xr3_Vz",12,20,105
SUV_1,"Xr3_Vz",12,4,106
SUV_1,"Xr3_Vz",12,5,113
SUV_1,"Xr3_Vz",12,1,999
SUV_1,"Xr3_Vz",13,2,102
SUV_1,"Xr3_Vz",13,16,104
SUV_1,"Xr3_Vz",13,33,105
SUV_1,"Xr3_Vz",13,1,106
SUV_1,"Xr3_Vz",13,2,107
SUV_1,"Xr3_Vz",13,2,109
SUV_1,"Xr3_Vz",13,1,112
SUV_1,"Xr3_Vz",13,7,113
SUV_1,"Xr3_Vz",13,1,999
SUV_1,"Xr3_Vz",14,4,101
SUV_1,"Xr3_Vz",14,3,102
SUV_1,"Xr3_Vz",14,1,103
SUV_1,"Xr3_Vz",14,3,104
SUV_1,"Xr3_Vz",14,92,105
SUV_1,"Xr3_Vz",14,20,106
SUV_1,"Xr3_Vz",14,1,109
SUV_1,"Xr3_Vz",14,2,113
SUV_1,"Xr3_Vz",14,2,3
SUV_1,"Xr3_Vz",14,1,999
SUV_1,"Xr3_Vz",15,3,102
SUV_1,"Xr3_Vz",15,52,104
SUV_1,"Xr3_Vz",15,48,105
SUV_1,"Xr3_Vz",15,1,106
SUV_1,"Xr3_Vz",15,6,113
SUV_1,"Xr3_Vz",16,2,101
SUV_1,"Xr3_Vz",16,2,102
SUV_1,"Xr3_Vz",16,6,104
SUV_1,"Xr3_Vz",16,70,105
SUV_1,"Xr3_Vz",16,28,106
SUV_1,"Xr3_Vz",16,6,113
SUV_1,"Xr3_Vz",16,2,999
SUV_1,"Xr3_Vz",17,2,101
SUV_1,"Xr3_Vz",17,3,102
SUV_1,"Xr3_Vz",17,23,104
SUV_1,"Xr3_Vz",17,24,105
SUV_1,"Xr3_Vz",17,30,106
SUV_1,"Xr3_Vz",17,3,113
SUV_1,"Xr3_Vz",17,1,999
SUV_1,"Xr3_Vz",18,1,1
SUV_1,"Xr3_Vz",18,2,101
SUV_1,"Xr3_Vz",18,1,102
SUV_1,"Xr3_Vz",18,79,104
SUV_1,"Xr3_Vz",18,15,105
SUV_1,"Xr3_Vz",18,5,106
SUV_1,"Xr3_Vz",18,1,109
SUV_1,"Xr3_Vz",18,2,113
SUV_1,"Xr3_Vz",18,2,999
SUV_1,"Xr3_Vz",19,1,1
SUV_1,"Xr3_Vz",19,4,101
SUV_1,"Xr3_Vz",19,496,104
SUV_1,"Xr3_Vz",19,11,105
SUV_1,"Xr3_Vz",19,4,106
SUV_1,"Xr3_Vz",19,1,109
SUV_1,"Xr3_Vz",19,1,113
SUV_1,"Xr3_Vz",20,2,102
SUV_1,"Xr3_Vz",20,243,104
SUV_1,"Xr3_Vz",20,14,105
SUV_1,"Xr3_Vz",20,5,109
SUV_1,"Xr3_Vz",20,4,112
SUV_1,"Xr3_Vz",20,11,113
SUV_1,"Xr3_Vz",20,1,3
SUV_1,"Xr3_Vz",20,1,999
SUV_1,"Xr3_Vz",21,1,1
SUV_1,"Xr3_Vz",21,1,101
SUV_1,"Xr3_Vz",21,1,104
SUV_1,"Xr3_Vz",21,10,105
SUV_1,"Xr3_Vz",21,1,106
SUV_1,"Xr3_Vz",21,6,109
SUV_1,"Xr3_Vz",21,2,113
SUV_1,"Xr3_Vz",21,2,999
SUV_1,"Xr3_Vz",22,4,101
SUV_1,"Xr3_Vz",22,1,104
SUV_1,"Xr3_Vz",22,8,105
SUV_1,"Xr3_Vz",22,1,106
SUV_1,"Xr3_Vz",22,5,113
SUV_1,"Xr3_Vz",23,1,1
SUV_1,"Xr3_Vz",23,2,101
SUV_1,"Xr3_Vz",23,4,104
SUV_1,"Xr3_Vz",23,14,105
SUV_1,"Xr3_Vz",23,10,106
SUV_1,"Xr3_Vz",23,8,113
SUV_1,"Xr3_Vz",23,8,999
SUV_1,"Xr3_Vz",24,3,101
SUV_1,"Xr3_Vz",24,2,102
SUV_1,"Xr3_Vz",24,3,104
SUV_1,"Xr3_Vz",24,11,105
SUV_1,"Xr3_Vz",24,2,106
SUV_1,"Xr3_Vz",24,1,3
SUV_1,"Xr3_Vz",25,3,101
SUV_1,"Xr3_Vz",25,1,102
SUV_1,"Xr3_Vz",25,1,103
SUV_1,"Xr3_Vz",25,6,104
SUV_1,"Xr3_Vz",25,22,105
SUV_1,"Xr3_Vz",25,6,106
SUV_1,"Xr3_Vz",25,2,109
SUV_1,"Xr3_Vz",25,2,110
SUV_1,"Xr3_Vz",25,1,112
SUV_1,"Xr3_Vz",25,1,113
SUV_1,"Xr3_Vz",25,2,3
SUV_1,"Xr3_Vz",26,2,1
SUV_1,"Xr3_Vz",26,3,101
SUV_1,"Xr3_Vz",26,1,102
SUV_1,"Xr3_Vz",26,2,104
SUV_1,"Xr3_Vz",26,21,105
SUV_1,"Xr3_Vz",26,8,106
SUV_1,"Xr3_Vz",26,1,107
SUV_1,"Xr3_Vz",26,3,110
SUV_1,"Xr3_Vz",26,1,112
SUV_1,"Xr3_Vz",26,3,113
SUV_1,"Xr3_Vz",26,12,999
SUV_1,"Xr3_Vz",27,2,101
SUV_1,"Xr3_Vz",27,1,102
SUV_1,"Xr3_Vz",27,9,105
SUV_1,"Xr3_Vz",27,2,106
SUV_1,"Xr3_Vz",27,2,110
SUV_1,"Xr3_Vz",27,1,113
SUV_1,"Xr3_Vz",28,2,1
SUV_1,"Xr3_Vz",28,6,101
SUV_1,"Xr3_Vz",28,2,102
SUV_1,"Xr3_Vz",28,3,104
SUV_1,"Xr3_Vz",28,29,105
SUV_1,"Xr3_Vz",28,10,106
SUV_1,"Xr3_Vz",28,1,110
SUV_1,"Xr3_Vz",28,2,113
SUV_1,"Xr3_Vz",29,2,1
SUV_1,"Xr3_Vz",29,5,101
SUV_1,"Xr3_Vz",29,2,102
SUV_1,"Xr3_Vz",29,2,104
SUV_1,"Xr3_Vz",29,8,105
SUV_1,"Xr3_Vz",29,11,106
SUV_1,"Xr3_Vz",29,6,113
SUV_1,"Xr3_Vz",29,2,999
SUV_1,"Xr3_Vz",30,2,101
SUV_1,"Xr3_Vz",30,2,104
SUV_1,"Xr3_Vz",30,1,105
SUV_1,"Xr3_Vz",30,1,106
SUV_1,"Xr3_Vz",30,1,112
SUV_1,"Xr3_Vz",30,4,113
SUV_1,"Xr3_Vz",31,1,101
SUV_1,"Xr3_Vz",31,1,104
SUV_1,"Xr3_Vz",31,1,105
SUV_1,"Xr3_Vz",31,1,502
SUV_1,"Xr3_Vz",31,4,999
SUV_1,"Xr3_Vz",32,4,105
SUV_1,"Xr3_Vz",32,1,109
SUV_1,"Xr3_Vz",32,1,112
SUV_1,"Xr3_Vz",32,37,113

Je voudrais récupérer chaque valeur unique de la colonne 'CodeNCC', puis pour chaque valeur unique 'CodeNCC' récupérer par semaine les valeurs associées 'QtyByNCCcode' pour pouvoir faire une boucle pour obtenir:

name: 'CodeNCC'
data: 'Valeur QtyByNCCcode',

La quantité de data correspond au nombre de semaine de l'année (ici 32), donc 1 valeur par semaine (bien sûr si pas de valeur, on retourne 0...)

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
series: [{
            name: '113',
            data: [4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,12,123,32,4,0,4,12,123]
 
        }, {
            name: '104',
            data: [2,21,43,43,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,12,123,32,0,4,12,123]
 
        }, {
            name: '101',
            data: [2,43,35,23,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,32,12,123,32,0,4,12,123]
 
        }, {
            name: '102',
            data: [1,0,0,0,4,12,123,32,4,12,123,32,4,12,123,32,4,12,123,324,12,123,32,12,123,32,4,0,4,12,123]
 
        }]

J'arrive à faire la mise en forme mais je ne réussi pas à récupérer les valeurs correctes des data...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
foreach($NumNccUnique as $NumNccUnique2){
		echo "name: '".$NumNccUnique2['ErrorNumber']."',".'<br>';
			echo "data: [";
			foreach($NumQtyNCC as $NumQtyNCC1){
				echo $NumQtyNCC1['QtyByNCCcode'].",";
	}
	echo "]";
	echo '<br>';
}

Pour obtenir:

Merci par avance

**badaze** · 17/08/2017, 22h58

Le code que je propose n'a pas la prétention de faire exactement ce que veux obtenir mais sert à montrer que tu peux faire ce que tu veux faire sans passer par un tableau ayant pour clé le codeNCC mais directement à partir de la base de données triée de la bonne manière.

Dans mon script, la table s'appelle table3.

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
<?php
header('Content-type: image/png');
$largeur = 1800;
$hauteur = 800;
$image   = imagecreatetruecolor($largeur, $hauteur);
$fond    = imagecolorallocate($image, 255, 255, 255);
imagefilledrectangle($image,0 , 0, $largeur, $hauteur, $fond);
//---- Paramètres BDD
define('DB_HOST', '127.0.0.1');
define('DB_NAME', 'tests');
define('DB_USER', 'root');
define('DB_PWD' , '');
$pdo    = new PDO("mysql:host=".DB_HOST."; dbname=".DB_NAME,DB_USER,DB_PWD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
//------ DEBUT
$query  = "SELECT Semaine, CodeNCC, QtyByNCCcode FROM table3 where CodeNCC in (101, 102, 104, 113) order by Semaine, CodeNCC desc";
//$query  = "SELECT Semaine, CodeNCC, QtyByNCCcode FROM table3 order by Semaine, CodeNCC desc";
$sth    = $pdo->prepare($query);
$sth->execute();
$arraySemCode        = array();
$arraySemTotal       = array();
$arrayNCCCodeCouleur = array();
while (list($Semaine, $CodeNCC, $QtyByNCCcode) = $sth->fetch(PDO::FETCH_NUM)) 
{
 $arraySemCode[$Semaine][$CodeNCC] = $QtyByNCCcode;
 //---- Total semaine
 if (!isset($arraySemTotal[$Semaine])) {
  $arraySemTotal[$Semaine] = 0;
 }
 $arraySemTotal[$Semaine]       = $arraySemTotal[$Semaine] + $QtyByNCCcode;
 //---- Tableau des codes couleurs
 $arrayNCCCodeCouleur[$CodeNCC] = "";
}
//----- FIN
//---- Affectation des couleurs
$arrayCouleurs = array("FFEBCD","0000FF","8A2BE2","A52A2A","DEB887","5F9EA0","7FFF00","D2691E","FF7F50","6495ED","FFF8DC",
"DC143C","00008B","008B8B","B8860B","A9A9A9","006400","BDB76B","8B008B","556B2F","FF8C00","9932CC",
"8B0000","E9967A","8FBC8F","483D8B","2F4F4F","00CED1","9400D3","FF1493","00BFFF","696969","1E90FF",
"D19275","B22222","FFFAF0","228B22","FF00FF","DCDCDC");
$i = 0;
foreach($arrayNCCCodeCouleur as $keyNCCCodeCouleur => $value)
{
 $arrayNCCCodeCouleur[$keyNCCCodeCouleur] = $arrayCouleurs[$i];
 $i++;
}
//---- Dessin de l'image
$noir           = imagecolorallocate($image, 0, 0, 0);
$margeYBasse    = 20;
$margeYHaute    = 40;
$margeXGauche   = 10;
$largeurHisto   = 25;
$espacement     = 10;
$positionXDebut = 10;
foreach($arraySemTotal as $keySemTotal => $TotalSemaine)
{
 $positionYDebut = $margeYBasse;
 foreach($arraySemCode[$keySemTotal] as $keyNCCCode => $QtyByNCCcode) {
  $rgb      = $arrayNCCCodeCouleur[$keyNCCCode];
  //PRINT $rgb." ";
  $couleur  = imagecolorallocate($image, hexdec(substr($rgb, 0, 2)), hexdec(substr($rgb, 2, 2)), hexdec(substr($rgb, 4, 2)));
  $pourcent = ($QtyByNCCcode / $TotalSemaine);
  $pixels   = ($hauteur - $margeYBasse - $margeYHaute) * $pourcent;
 
  imagefilledrectangle($image,$positionXDebut, $positionYDebut, $positionXDebut+$largeurHisto, $positionYDebut+$pixels, $couleur);  
 
  $positionYDebut = $positionYDebut + $pixels;
 }
 imagestring($image,3, $positionXDebut,$hauteur-$margeYBasse, $keySemTotal, $noir);
 $positionXDebut = $positionXDebut + $espacement+$largeurHisto;
 //break;
}
//---- Envoie le flux de l'image
imagepng($image);
//---- Desalloue la memoire utilisée par l'image
imagedestroy($image);

Donne

Nom : Capture20170817_001.JPG
Affichages : 816
Taille : 90,8 Ko

**Supernatural** · 30/08/2017, 13h13

Merci, mais je préfère rester sur le standard de 'highcharts'.

C'est quand même fou, j'ai beau tourner le problème dans tout les sens, je n'y arrive pas avec les for...

Voici mon code:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
$ParetoNCC = $pdo->query("SELECT Line, CSL, Week(ProcessDate - interval 5 hour, 3) As Semaine, ErrorNumber, COUNT(*) AS QTY FROM nccdetails WHERE LEFT(ProcessDate, 4)='".$sYEAR."' AND Line = '".$Ligne."' AND '".$Cellule."' IN(CSL, 'Cellule') GROUP BY Line, CSL, ErrorNumber, Semaine ORDER BY Semaine;");
$ParetoNCC->execute();
$ParetoNCC=$ParetoNCC->fetchAll();
//var_dump($ParetoNCC);
 
$CodeNCCUnique=array_column($ParetoNCC, 'ErrorNumber');
$CodeNCCUnique=array_unique($CodeNCCUnique);
$CodeNCCUnique=array_values($CodeNCCUnique);
//var_dump($CodeNCCUnique);
 
$WeeksUniqueDB=array_column($ParetoNCC, 'Semaine');
$WeeksUniqueDB=array_unique($WeeksUniqueDB);
$WeeksUniqueDB=array_values($WeeksUniqueDB);
//var_dump($WeeksUniqueDB);
 
$aHighChartsSeries=array();
$sHighChartsSeries='';
 
//	+------+-----+-------+-------------+-----+
//	| Line | CSL | Weeks | ErrorNumber | QTY |
//	+------+-----+-------+-------------+-----+
 
for($a=0; $a<sizeof($CodeNCCUnique); $a++){
	echo "<b>Code NCC: </b>".$CodeNCCUnique[$a].'<br>';
	$sHighChartsSeries=$sHighChartsSeries."{".'<br>';
	$sHighChartsSeries=$sHighChartsSeries."name: '".$CodeNCCUnique[$a]."'".'<br>';
	$sHighChartsSeries=$sHighChartsSeries."data: [";
	for($b=0; $b<sizeof($ParetoNCC); $b++){
		for($c=0; $c<sizeof($WeeksUniqueDB); $c++){
			if($WeeksUniqueDB[$c][0]=$ParetoNCC[$b][2]&&$ParetoNCC[$b][3]=$CodeNCCUnique[$a]){
				echo $CodeNCCUnique[$a].",";
 
			};//FIN if	
												  };//FIN for $c
		                                   };//FIN for $b
 
	$sHighChartsSeries=$sHighChartsSeries."]".'<br>';
	$sHighChartsSeries=$sHighChartsSeries."}, ".'<br>';
 
};//FIN for $a

Ce qui me donne comme résultat (en fonction des valeurs de ma combobox):

PEJ9SzP-1 | 68 - PreProcess | 1 | 999 | 1
PEJ9SzP-1 | 68 - PreProcess | 1 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 3 | 1 | 2
PEJ9SzP-1 | 68 - PreProcess | 3 | 999 | 1
PEJ9SzP-1 | 68 - PreProcess | 4 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 7 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 12 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 12 | 3 | 1
PEJ9SzP-1 | 68 - PreProcess | 14 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 17 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 21 | 3 | 1
PEJ9SzP-1 | 68 - PreProcess | 25 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 26 | 999 | 7
PEJ9SzP-1 | 68 - PreProcess | 27 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 30 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 31 | 1 | 1
PEJ9SzP-1 | 68 - PreProcess | 33 | 1 | 1

Je voudrais trouver une imbrication pour arriver au résultat:

{
name: '999',
data: [1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0]
},{
name: '1',
data: [1,0,2,0,0,0,1,0,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1]
},{
name: '3',
data: [2,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
}

Merci par avance

**badaze** · 30/08/2017, 18h17

J'ai dû mal m'exprimer. Ne regarde pas le résultat mais le moyen d'y arriver.
La requête SQL et le while qui suit. La génération de l'image c'est seulement pour montrer l'exploitation de ce qui est fait avant.

**Supernatural** · 31/08/2017, 08h04

Ok, j'essai mais je ne récupère rien...

Ma requête:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
 
$ParetoNCC = $pdo->query("SELECT Line, CSL, Week(ProcessDate - interval 5 hour, 3) As Semaine, ErrorNumber, COUNT(*) AS QTY FROM nccdetails WHERE LEFT(ProcessDate, 4)='".$sYEAR."' AND Line = '".$Ligne."' AND '".$Cellule."' IN(CSL, 'Cellule') GROUP BY Line, CSL, ErrorNumber, Semaine ORDER BY Semaine;");
$ParetoNCC->execute();
$ParetoNCC=$ParetoNCC->fetchAll();

Mon code (copié/collé):

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
$arraySemCode        = array();
$arraySemTotal       = array();
$arrayNCCCodeCouleur = array();
 
while (list($Line, $CSL, $Semaine, $CodeNCC, $QtyByNCCcode)=each($ParetoNCC));
{
$arraySemCode[$Semaine][$CodeNCC] = $QtyByNCCcode;
 
//---- Total semaine
if (!isset($arraySemTotal[$Semaine])) {
$arraySemTotal[$Semaine] = 0;
}
$arraySemTotal[$Semaine]       = $arraySemTotal[$Semaine] + $QtyByNCCcode; 
}
var_dump($arraySemTotal);

Je ne suis pas sur de:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

while (list($Line, $CSL, $Semaine, $CodeNCC, $QtyByNCCcode)=each($ParetoNCC));

**Supernatural** · 31/08/2017, 10h18

Je reviens, je réussi bien à récupérer les valeurs

Mon var_dump me retourne:
Pièce jointe 307997

J'ai presque réussi... mais... Du coup j'ai pris le problème différemment lol.

Mon code:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
$aResult = array();
//$test=array();
$VarNull="0";
 
while (list($Line, $CSL, $Semaine, $ErrorNumber, $QTY) = $ParetoNCC->fetch(PDO::FETCH_NUM)) 
{
	$sHighChartsSeries=$sHighChartsSeries."{";
	$sHighChartsSeries=$sHighChartsSeries."name: '".$ErrorNumber."', ";
	$sHighChartsSeries=$sHighChartsSeries."data: [";
for($a=0;$a<sizeof($Weeks);$a++){
	//$test[$ErrorNumber][$Semaine]=$QTY;
	if($Weeks[$a][0]==$Semaine){
		$aResult[$ErrorNumber][$Semaine] = $QTY;
		$sHighChartsSeries=$sHighChartsSeries.$QTY.',';
		}
	else{
		//array_push($aResult, $aResult[$ErrorNumber][$Weeks[$a][0]] = $VarNull);
		$aResult[$ErrorNumber][$Weeks[$a][0]] = $VarNull;
		$sHighChartsSeries=$sHighChartsSeries.$VarNull.',';
		};
 
	};
	$sHighChartsSeries=rtrim($sHighChartsSeries, ",");
	$sHighChartsSeries=$sHighChartsSeries."]";
	$sHighChartsSeries=$sHighChartsSeries."},";
 
 
};
 
var_dump($aResult);

Ce qui me retourne:

Mais ça me groupe pas en fonction des codes ncc (exemple le code ncc = 3, je devrais avoir 19, 20, 33, or je n'ai que 33...)

**Supernatural** · 04/09/2017, 14h43

Ça avance... Je suis 'presque' arrivé à mon objectif...

Mon code:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
$aResult = array();
$VarNull="0";
while (list($Line, $CSL, $Semaine, $ErrorNumber, $QTY) = $ParetoNCC->fetch(PDO::FETCH_NUM)) 
{
for($a=0;$a<sizeof($Weeks);$a++){
	if($Weeks[$a][0]==$Semaine){
		$aResult[$ErrorNumber][$Semaine] = $QTY;
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$QTY.',';}
	else{
		$aResult[$ErrorNumber][$Weeks[$a][0]] = $VarNull;
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$VarNull.',';;
	}
}
goto fill;
};
 
fill:
foreach($aResult as $keyNCCCode => $value){
	$sHighChartsSeries=$sHighChartsSeries."{";
	$sHighChartsSeries=$sHighChartsSeries."name: '".$keyNCCCode."', ";
	$sHighChartsSeries=$sHighChartsSeries."data: [";
	for($b=0; $b<sizeof($keyNCCCode);$b++){
		$sHighChartsSeries=$sHighChartsSeries.$sHighChartsSeriesValues;
 
	}
	$sHighChartsSeries=rtrim($sHighChartsSeries, ",");
	$sHighChartsSeries=$sHighChartsSeries."]";
	$sHighChartsSeries=$sHighChartsSeries."},";
};
echo rtrim($sHighChartsSeries, ",");

J'arrive bien au résultat que je désire mais ça ne boucle pas comme je le voudrais, ça ne boucle qu'une fois, à cause du goto je pense...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

series: [{name: '999', data: [0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]}]

Merci par avance.

**Supernatural** · 05/09/2017, 12h58

un p'tit coup de pouce, j'ai juste ce souis pour clore mon projet.

merci par avance

**rawsrc** · 05/09/2017, 13h52

Salut,

bon j'ai regardé rapidement et je n'ai pas tout compris dans ton algo ni tes explications
J'aurais fait beaucoup plus simple en partant de tes données d'exemple cela donnerait (pour ce que j'ai compris) :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
$data = [
    ['SUV_1','Xr3_Vz',1,1,1],
    ['SUV_1','Xr3_Vz',1,3,101],
    ['SUV_1','Xr3_Vz',1,4,102],
    ['SUV_1','Xr3_Vz',1,27,104],
    ['SUV_1','Xr3_Vz',1,53,105],
    ['SUV_1','Xr3_Vz',1,18,106],
    ['SUV_1','Xr3_Vz',1,1,107],
    ['SUV_1','Xr3_Vz',1,1,999],
    ['SUV_1','Xr3_Vz',2,2,101],
    ['SUV_1','Xr3_Vz',2,4,102],
    ['SUV_1','Xr3_Vz',2,30,104],
    ['SUV_1','Xr3_Vz',2,20,105],
    ['SUV_1','Xr3_Vz',2,8,106],
    ['SUV_1','Xr3_Vz',2,1,109],
    ['SUV_1','Xr3_Vz',2,3,113],
    ['SUV_1','Xr3_Vz',2,1,3],
    ['SUV_1','Xr3_Vz',2,8,999],
    ['SUV_1','Xr3_Vz',3,7,101],
    ['SUV_1','Xr3_Vz',3,1,102],
    ['SUV_1','Xr3_Vz',3,13,104],
    ['SUV_1','Xr3_Vz',3,21,105],
    ['SUV_1','Xr3_Vz',3,9,106],
    ['SUV_1','Xr3_Vz',3,1,999],
    ['SUV_1','Xr3_Vz',4,14,101],
    ['SUV_1','Xr3_Vz',4,12,104],
    ['SUV_1','Xr3_Vz',4,12,105],
    ['SUV_1','Xr3_Vz',4,3,106],
    ['SUV_1','Xr3_Vz',4,2,110],
    ['SUV_1','Xr3_Vz',4,4,113],
    ['SUV_1','Xr3_Vz',4,1,999],
    ['SUV_1','Xr3_Vz',5,5,101],
    ['SUV_1','Xr3_Vz',5,3,104],
    ['SUV_1','Xr3_Vz',5,7,105],
    ['SUV_1','Xr3_Vz',5,5,106],
    ['SUV_1','Xr3_Vz',5,2,110],
    ['SUV_1','Xr3_Vz',6,2,101],
    ['SUV_1','Xr3_Vz',6,4,102],
    ['SUV_1','Xr3_Vz',6,2,103],
    ['SUV_1','Xr3_Vz',6,4,104],
    ['SUV_1','Xr3_Vz',6,5,105],
    ['SUV_1','Xr3_Vz',6,4,106],
    ['SUV_1','Xr3_Vz',6,1,110],
    ['SUV_1','Xr3_Vz',7,1,1],
    ['SUV_1','Xr3_Vz',7,5,101],
    ['SUV_1','Xr3_Vz',7,1,102],
    ['SUV_1','Xr3_Vz',7,4,104],
    ['SUV_1','Xr3_Vz',7,21,105],
    ['SUV_1','Xr3_Vz',7,6,106],
    ['SUV_1','Xr3_Vz',7,2,110],
    ['SUV_1','Xr3_Vz',7,1,112],
    ['SUV_1','Xr3_Vz',7,1,113],
    ['SUV_1','Xr3_Vz',8,1,101],
    ['SUV_1','Xr3_Vz',8,4,102],
    ['SUV_1','Xr3_Vz',8,1,103],
    ['SUV_1','Xr3_Vz',8,19,104],
    ['SUV_1','Xr3_Vz',8,9,105],
    ['SUV_1','Xr3_Vz',8,11,106],
    ['SUV_1','Xr3_Vz',8,1,109],
    ['SUV_1','Xr3_Vz',8,1,110],
    ['SUV_1','Xr3_Vz',8,5,113],
    ['SUV_1','Xr3_Vz',9,2,101],
    ['SUV_1','Xr3_Vz',9,2,102],
    ['SUV_1','Xr3_Vz',9,1,103],
    ['SUV_1','Xr3_Vz',9,45,104],
    ['SUV_1','Xr3_Vz',9,10,105],
    ['SUV_1','Xr3_Vz',9,2,106],
    ['SUV_1','Xr3_Vz',9,1,109],
    ['SUV_1','Xr3_Vz',9,2,110],
    ['SUV_1','Xr3_Vz',9,2,113],
    ['SUV_1','Xr3_Vz',9,2,999],
    ['SUV_1','Xr3_Vz',10,4,104],
    ['SUV_1','Xr3_Vz',10,6,105],
    ['SUV_1','Xr3_Vz',10,5,106],
    ['SUV_1','Xr3_Vz',10,3,113],
    ['SUV_1','Xr3_Vz',11,1,101],
    ['SUV_1','Xr3_Vz',11,1,102],
    ['SUV_1','Xr3_Vz',11,6,104],
    ['SUV_1','Xr3_Vz',11,22,105],
    ['SUV_1','Xr3_Vz',11,10,106],
    ['SUV_1','Xr3_Vz',11,1,109],
    ['SUV_1','Xr3_Vz',11,1,110],
    ['SUV_1','Xr3_Vz',11,1,112],
    ['SUV_1','Xr3_Vz',11,8,113],
    ['SUV_1','Xr3_Vz',11,4,999],
    ['SUV_1','Xr3_Vz',12,7,101],
    ['SUV_1','Xr3_Vz',12,3,102],
    ['SUV_1','Xr3_Vz',12,1,103],
    ['SUV_1','Xr3_Vz',12,8,104],
    ['SUV_1','Xr3_Vz',12,20,105],
    ['SUV_1','Xr3_Vz',12,4,106],
    ['SUV_1','Xr3_Vz',12,5,113],
    ['SUV_1','Xr3_Vz',12,1,999],
    ['SUV_1','Xr3_Vz',13,2,102],
    ['SUV_1','Xr3_Vz',13,16,104],
    ['SUV_1','Xr3_Vz',13,33,105],
    ['SUV_1','Xr3_Vz',13,1,106],
    ['SUV_1','Xr3_Vz',13,2,107],
    ['SUV_1','Xr3_Vz',13,2,109],
    ['SUV_1','Xr3_Vz',13,1,112],
    ['SUV_1','Xr3_Vz',13,7,113],
    ['SUV_1','Xr3_Vz',13,1,999],
    ['SUV_1','Xr3_Vz',14,4,101],
    ['SUV_1','Xr3_Vz',14,3,102],
    ['SUV_1','Xr3_Vz',14,1,103],
    ['SUV_1','Xr3_Vz',14,3,104],
    ['SUV_1','Xr3_Vz',14,92,105],
    ['SUV_1','Xr3_Vz',14,20,106],
    ['SUV_1','Xr3_Vz',14,1,109],
    ['SUV_1','Xr3_Vz',14,2,113],
    ['SUV_1','Xr3_Vz',14,2,3],
    ['SUV_1','Xr3_Vz',14,1,999],
    ['SUV_1','Xr3_Vz',15,3,102],
    ['SUV_1','Xr3_Vz',15,52,104],
    ['SUV_1','Xr3_Vz',15,48,105],
    ['SUV_1','Xr3_Vz',15,1,106],
    ['SUV_1','Xr3_Vz',15,6,113],
    ['SUV_1','Xr3_Vz',16,2,101],
    ['SUV_1','Xr3_Vz',16,2,102],
    ['SUV_1','Xr3_Vz',16,6,104],
    ['SUV_1','Xr3_Vz',16,70,105],
    ['SUV_1','Xr3_Vz',16,28,106],
    ['SUV_1','Xr3_Vz',16,6,113],
    ['SUV_1','Xr3_Vz',16,2,999],
    ['SUV_1','Xr3_Vz',17,2,101],
    ['SUV_1','Xr3_Vz',17,3,102],
    ['SUV_1','Xr3_Vz',17,23,104],
    ['SUV_1','Xr3_Vz',17,24,105],
    ['SUV_1','Xr3_Vz',17,30,106],
    ['SUV_1','Xr3_Vz',17,3,113],
    ['SUV_1','Xr3_Vz',17,1,999],
    ['SUV_1','Xr3_Vz',18,1,1],
    ['SUV_1','Xr3_Vz',18,2,101],
    ['SUV_1','Xr3_Vz',18,1,102],
    ['SUV_1','Xr3_Vz',18,79,104],
    ['SUV_1','Xr3_Vz',18,15,105],
    ['SUV_1','Xr3_Vz',18,5,106],
    ['SUV_1','Xr3_Vz',18,1,109],
    ['SUV_1','Xr3_Vz',18,2,113],
    ['SUV_1','Xr3_Vz',18,2,999],
    ['SUV_1','Xr3_Vz',19,1,1],
    ['SUV_1','Xr3_Vz',19,4,101],
    ['SUV_1','Xr3_Vz',19,496,104],
    ['SUV_1','Xr3_Vz',19,11,105],
    ['SUV_1','Xr3_Vz',19,4,106],
    ['SUV_1','Xr3_Vz',19,1,109],
    ['SUV_1','Xr3_Vz',19,1,113],
    ['SUV_1','Xr3_Vz',20,2,102],
    ['SUV_1','Xr3_Vz',20,243,104],
    ['SUV_1','Xr3_Vz',20,14,105],
    ['SUV_1','Xr3_Vz',20,5,109],
    ['SUV_1','Xr3_Vz',20,4,112],
    ['SUV_1','Xr3_Vz',20,11,113],
    ['SUV_1','Xr3_Vz',20,1,3],
    ['SUV_1','Xr3_Vz',20,1,999],
    ['SUV_1','Xr3_Vz',21,1,1],
    ['SUV_1','Xr3_Vz',21,1,101],
    ['SUV_1','Xr3_Vz',21,1,104],
    ['SUV_1','Xr3_Vz',21,10,105],
    ['SUV_1','Xr3_Vz',21,1,106],
    ['SUV_1','Xr3_Vz',21,6,109],
    ['SUV_1','Xr3_Vz',21,2,113],
    ['SUV_1','Xr3_Vz',21,2,999],
    ['SUV_1','Xr3_Vz',22,4,101],
    ['SUV_1','Xr3_Vz',22,1,104],
    ['SUV_1','Xr3_Vz',22,8,105],
    ['SUV_1','Xr3_Vz',22,1,106],
    ['SUV_1','Xr3_Vz',22,5,113],
    ['SUV_1','Xr3_Vz',23,1,1],
    ['SUV_1','Xr3_Vz',23,2,101],
    ['SUV_1','Xr3_Vz',23,4,104],
    ['SUV_1','Xr3_Vz',23,14,105],
    ['SUV_1','Xr3_Vz',23,10,106],
    ['SUV_1','Xr3_Vz',23,8,113],
    ['SUV_1','Xr3_Vz',23,8,999],
    ['SUV_1','Xr3_Vz',24,3,101],
    ['SUV_1','Xr3_Vz',24,2,102],
    ['SUV_1','Xr3_Vz',24,3,104],
    ['SUV_1','Xr3_Vz',24,11,105],
    ['SUV_1','Xr3_Vz',24,2,106],
    ['SUV_1','Xr3_Vz',24,1,3],
    ['SUV_1','Xr3_Vz',25,3,101],
    ['SUV_1','Xr3_Vz',25,1,102],
    ['SUV_1','Xr3_Vz',25,1,103],
    ['SUV_1','Xr3_Vz',25,6,104],
    ['SUV_1','Xr3_Vz',25,22,105],
    ['SUV_1','Xr3_Vz',25,6,106],
    ['SUV_1','Xr3_Vz',25,2,109],
    ['SUV_1','Xr3_Vz',25,2,110],
    ['SUV_1','Xr3_Vz',25,1,112],
    ['SUV_1','Xr3_Vz',25,1,113],
    ['SUV_1','Xr3_Vz',25,2,3],
    ['SUV_1','Xr3_Vz',26,2,1],
    ['SUV_1','Xr3_Vz',26,3,101],
    ['SUV_1','Xr3_Vz',26,1,102],
    ['SUV_1','Xr3_Vz',26,2,104],
    ['SUV_1','Xr3_Vz',26,21,105],
    ['SUV_1','Xr3_Vz',26,8,106],
    ['SUV_1','Xr3_Vz',26,1,107],
    ['SUV_1','Xr3_Vz',26,3,110],
    ['SUV_1','Xr3_Vz',26,1,112],
    ['SUV_1','Xr3_Vz',26,3,113],
    ['SUV_1','Xr3_Vz',26,12,999],
    ['SUV_1','Xr3_Vz',27,2,101],
    ['SUV_1','Xr3_Vz',27,1,102],
    ['SUV_1','Xr3_Vz',27,9,105],
    ['SUV_1','Xr3_Vz',27,2,106],
    ['SUV_1','Xr3_Vz',27,2,110],
    ['SUV_1','Xr3_Vz',27,1,113],
    ['SUV_1','Xr3_Vz',28,2,1],
    ['SUV_1','Xr3_Vz',28,6,101],
    ['SUV_1','Xr3_Vz',28,2,102],
    ['SUV_1','Xr3_Vz',28,3,104],
    ['SUV_1','Xr3_Vz',28,29,105],
    ['SUV_1','Xr3_Vz',28,10,106],
    ['SUV_1','Xr3_Vz',28,1,110],
    ['SUV_1','Xr3_Vz',28,2,113],
    ['SUV_1','Xr3_Vz',29,2,1],
    ['SUV_1','Xr3_Vz',29,5,101],
    ['SUV_1','Xr3_Vz',29,2,102],
    ['SUV_1','Xr3_Vz',29,2,104],
    ['SUV_1','Xr3_Vz',29,8,105],
    ['SUV_1','Xr3_Vz',29,11,106],
    ['SUV_1','Xr3_Vz',29,6,113],
    ['SUV_1','Xr3_Vz',29,2,999],
    ['SUV_1','Xr3_Vz',30,2,101],
    ['SUV_1','Xr3_Vz',30,2,104],
    ['SUV_1','Xr3_Vz',30,1,105],
    ['SUV_1','Xr3_Vz',30,1,106],
    ['SUV_1','Xr3_Vz',30,1,112],
    ['SUV_1','Xr3_Vz',30,4,113],
    ['SUV_1','Xr3_Vz',31,1,101],
    ['SUV_1','Xr3_Vz',31,1,104],
    ['SUV_1','Xr3_Vz',31,1,105],
    ['SUV_1','Xr3_Vz',31,1,502],
    ['SUV_1','Xr3_Vz',31,4,999],
    ['SUV_1','Xr3_Vz',32,4,105],
    ['SUV_1','Xr3_Vz',32,1,109],
    ['SUV_1','Xr3_Vz',32,1,112],
    ['SUV_1','Xr3_Vz',32,37,113]
];
 
$nb_of_weeks = 0;
array_map(function($v) use (&$nb_of_weeks) { $nb_of_weeks += ($v[2] - $nb_of_weeks) ?: 0; }, $data);
 
$charts_model = array_fill(1, $nb_of_weeks, 0);   // zerofill
$charts       = [];
 
foreach ($data as [$line, $csl, $week, $qty, $ncc]) {
    if ( ! isset($charts[$ncc])) {
        $charts[$ncc] = $charts_model;
    }
 
    $charts[$ncc][$week] += $qty;
}
 
print_r($charts);

**Supernatural** · 05/09/2017, 14h43

Nom : 2017-09-05_14h38_58.jpg
Affichages : 793
Taille : 81,4 Ko

Mon code:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
$aResult = array();
$VarNull="0";
 
while (list($Line, $CSL, $Semaine, $ErrorNumber, $QTY) = $ParetoNCC->fetch(PDO::FETCH_NUM)) 
{
for($a=0;$a<sizeof($Weeks);$a++){
	if($Weeks[$a][0]==$Semaine){
		$aResult[$ErrorNumber][$Semaine] = $QTY;
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$QTY.',';}
	else{
		//$aResult[$ErrorNumber][$Weeks[$a][0]]= $VarNull; <- ICI CA NE FONCTIONNE PAS
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$VarNull.',';;
	}
};
};
 
foreach($aResult as $keyNCCCode => $value){
	$sHighChartsSeries=$sHighChartsSeries."{";
	$sHighChartsSeries=$sHighChartsSeries."name: '".$keyNCCCode."', ";
	$sHighChartsSeries=$sHighChartsSeries."data: [";
 
	for($aa=0;$aa<sizeof($Weeks);$aa++){
 
		//if($Weeks[$a][0]==$Semaine){
		//	$sHighChartsSeries=$sHighChartsSeries.$aResult[$keyNCCCode][$Semaine].",";
		//}
		//else{
		$sHighChartsSeries=$sHighChartsSeries.$aResult[$keyNCCCode][$Weeks[$aa][0]].",";
		}
 
	$sHighChartsSeries=rtrim($sHighChartsSeries, ",");
	$sHighChartsSeries=$sHighChartsSeries."]";
	$sHighChartsSeries=$sHighChartsSeries."},";
};

**Supernatural** · 05/09/2017, 15h48

C'et bon j'ai trouvé ^^

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
$aResult = array();
$VarNull="0";
 
while (list($Line, $CSL, $Semaine, $ErrorNumber, $QTY) = $ParetoNCC->fetch(PDO::FETCH_NUM)) 
{
for($a=0;$a<sizeof($Weeks);$a++){
	if($Weeks[$a][0]==$Semaine){
		$aResult[$ErrorNumber][$Semaine] = $QTY;
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$QTY.',';}
	else{
		$sHighChartsSeriesValues=$sHighChartsSeriesValues.$VarNull.',';};
	}
};
 
 
foreach($aResult as $keyNCCCode => $value){
	$sHighChartsSeries=$sHighChartsSeries."{";
	$sHighChartsSeries=$sHighChartsSeries."name: '".$keyNCCCode."', ";
	$sHighChartsSeries=$sHighChartsSeries."data: [";
 
	for($aa=0;$aa<sizeof($Weeks);$aa++){
		if(!isset($aResult[$keyNCCCode][$Weeks[$aa][0]])) {$aResult[$keyNCCCode][$Weeks[$aa][0]]= "0";};
			$sHighChartsSeries=$sHighChartsSeries.$aResult[$keyNCCCode][$Weeks[$aa][0]].",";
		};
 
	$sHighChartsSeries=rtrim($sHighChartsSeries, ",");
	$sHighChartsSeries=$sHighChartsSeries."]";
	$sHighChartsSeries=$sHighChartsSeries."},";
};

**rawsrc** · 06/09/2017, 10h59

Salut,

si tu t'étais inspiré de mon code, tu aurais fait beaucoup plus lisible :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$chart_model = array_fill(1, $Weeks, 0);   // zerofill
$chart_data   = [];
 
while ([$line, $csl, $week, $ncc, $qty] = $ParetoNCC->fetch(PDO::FETCH_NUM)) {
    if ( ! isset($chart_data[$ncc])) {
        $chart_data[$ncc] = $chart_model;
    }
 
    $chart_data[$ncc][$week] += $qty;
}
 
$json = [];
foreach ($chart_data as $ncc => $v) {
    $json[] = "{ name: '{$ncc}', data: [".implode(', ', $v)."]}";
}
 
$chart_datasource = implode(',', $json);

je pense que l'on doit arriver au même résultat, non ?

foreach imbriqués pour récupération de données [MySQL]

PHP & Base de données

Discussions similaires

Partager

Partager