<?php
 
$jsonData = file_get_contents('php://stdin');
$jsonData = json_decode($jsonData, true);
 
$SeriesByName = [];
$CategoryDates = [];
 
foreach ($jsonData as $row) {
  $name = $row['nombre'];
  $date = $row['fecha'];
  $SeriesByName[$name][$date] = $row['cantidad'];
  $CategoryDates[$date] = true;
}
 
$Category = array_keys($CategoryDates);
$dateIndexes = array_flip($Category);
 
$Serie = [];
foreach ($SeriesByName as $name => $data) {
  $SeriesData = array_fill(0, count($Category), "0");
  foreach ($data as $date => $quantity) {
    $SeriesData[$dateIndexes[$date]] = $quantity;
  }
  $Serie[] = ['name' => $name, 'data' => $SeriesData];
}
 
echo json_encode([
  'Serie' => $Serie,
  'Category' => $Category,
], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
 

PD9waHAKCiRqc29uRGF0YSA9IGZpbGVfZ2V0X2NvbnRlbnRzKCdwaHA6Ly9zdGRpbicpOwokanNvbkRhdGEgPSBqc29uX2RlY29kZSgkanNvbkRhdGEsIHRydWUpOwoKJFNlcmllc0J5TmFtZSA9IFtdOwokQ2F0ZWdvcnlEYXRlcyA9IFtdOwoKZm9yZWFjaCAoJGpzb25EYXRhIGFzICRyb3cpIHsKICAkbmFtZSA9ICRyb3dbJ25vbWJyZSddOwogICRkYXRlID0gJHJvd1snZmVjaGEnXTsKICAkU2VyaWVzQnlOYW1lWyRuYW1lXVskZGF0ZV0gPSAkcm93WydjYW50aWRhZCddOwogICRDYXRlZ29yeURhdGVzWyRkYXRlXSA9IHRydWU7Cn0KCiRDYXRlZ29yeSA9IGFycmF5X2tleXMoJENhdGVnb3J5RGF0ZXMpOwokZGF0ZUluZGV4ZXMgPSBhcnJheV9mbGlwKCRDYXRlZ29yeSk7CgokU2VyaWUgPSBbXTsKZm9yZWFjaCAoJFNlcmllc0J5TmFtZSBhcyAkbmFtZSA9PiAkZGF0YSkgewogICRTZXJpZXNEYXRhID0gYXJyYXlfZmlsbCgwLCBjb3VudCgkQ2F0ZWdvcnkpLCAiMCIpOwogIGZvcmVhY2ggKCRkYXRhIGFzICRkYXRlID0+ICRxdWFudGl0eSkgewogICAgJFNlcmllc0RhdGFbJGRhdGVJbmRleGVzWyRkYXRlXV0gPSAkcXVhbnRpdHk7CiAgfQogICRTZXJpZVtdID0gWyduYW1lJyA9PiAkbmFtZSwgJ2RhdGEnID0+ICRTZXJpZXNEYXRhXTsKfQoKZWNobyBqc29uX2VuY29kZShbCiAgJ1NlcmllJyA9PiAkU2VyaWUsCiAgJ0NhdGVnb3J5JyA9PiAkQ2F0ZWdvcnksCl0sIEpTT05fUFJFVFRZX1BSSU5UIHwgSlNPTl9VTkVTQ0FQRURfU0xBU0hFUyk7Cg==

WwogIHsKICAgICZxdW90O25vbWJyZSZxdW90OzogJnF1b3Q7VXN1YXJpb18xJnF1b3Q7LAogICAgJnF1b3Q7ZmVjaGEmcXVvdDs6ICZxdW90OzIwMjUtMDEtMDEmcXVvdDssCiAgICAmcXVvdDtjYW50aWRhZCZxdW90OzogJnF1b3Q7MjUmcXVvdDsKICB9LAogIHsKICAgICZxdW90O25vbWJyZSZxdW90OzogJnF1b3Q7VXN1YXJpb18xJnF1b3Q7LAogICAgJnF1b3Q7ZmVjaGEmcXVvdDs6ICZxdW90OzIwMjUtMDEtMDMmcXVvdDssCiAgICAmcXVvdDtjYW50aWRhZCZxdW90OzogJnF1b3Q7MTkmcXVvdDsKICB9LAogIHsKICAgICZxdW90O25vbWJyZSZxdW90OzogJnF1b3Q7VXN1YXJpb18yJnF1b3Q7LAogICAgJnF1b3Q7ZmVjaGEmcXVvdDs6ICZxdW90OzIwMjUtMDEtMDMmcXVvdDssCiAgICAmcXVvdDtjYW50aWRhZCZxdW90OzogJnF1b3Q7MjImcXVvdDsKICB9LAogIHsKICAgICZxdW90O25vbWJyZSZxdW90OzogJnF1b3Q7VXN1YXJpb18xJnF1b3Q7LAogICAgJnF1b3Q7ZmVjaGEmcXVvdDs6ICZxdW90OzIwMjUtMDEtMDUmcXVvdDssCiAgICAmcXVvdDtjYW50aWRhZCZxdW90OzogJnF1b3Q7MTUmcXVvdDsKICB9LAogIHsKICAgICZxdW90O25vbWJyZSZxdW90OzogJnF1b3Q7VXN1YXJpb18yJnF1b3Q7LAogICAgJnF1b3Q7ZmVjaGEmcXVvdDs6ICZxdW90OzIwMjUtMDEtMDUmcXVvdDssCiAgICAmcXVvdDtjYW50aWRhZCZxdW90OzogJnF1b3Q7MzEmcXVvdDsKICB9Cl0K

[
  {
    "nombre": "Usuario_1",
    "fecha": "2025-01-01",
    "cantidad": "25"
  },
  {
    "nombre": "Usuario_1",
    "fecha": "2025-01-03",
    "cantidad": "19"
  },
  {
    "nombre": "Usuario_2",
    "fecha": "2025-01-03",
    "cantidad": "22"
  },
  {
    "nombre": "Usuario_1",
    "fecha": "2025-01-05",
    "cantidad": "15"
  },
  {
    "nombre": "Usuario_2",
    "fecha": "2025-01-05",
    "cantidad": "31"
  }
]