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
| <?php
$data = [
["CHAMP1"=>"A","ANNEE"=>"2019-01","QTE"=>"1000"],
["CHAMP1"=>"B","ANNEE"=>"2019-01","QTE"=>"2000"],
["CHAMP1"=>"C","ANNEE"=>"2019-01","QTE"=>"3000"],
["CHAMP1"=>"D","ANNEE"=>"2019-01","QTE"=>"4000"],
["CHAMP1"=>"A","ANNEE"=>"2019-02","QTE"=>"5000"],
["CHAMP1"=>"B","ANNEE"=>"2019-02","QTE"=>"6000"],
["CHAMP1"=>"C","ANNEE"=>"2019-02","QTE"=>"7000"],
["CHAMP1"=>"D","ANNEE"=>"2019-02","QTE"=>"8000"],
];
function formateArray(string $annee, string $currentYearArray = '', array $row, &$arrayFormated = []) : string
{
if(!strpos($currentYearArray, $annee))
$currentYearArray = $annee;
$arrayFormated[$currentYearArray][$row['CHAMP1']] = $row['QTE'];
return $currentYearArray;
}
$dateString = '';
foreach($data as $row)
{
$dateString = formateArray($row['ANNEE'], $dateString, $row, $arrayFormated);
}
$json = json_encode($arrayFormated, true);
var_dump($json); |
Partager