安排JSON数据将重复项保存到一行

Question

Good morning guys!

I'm having a hard time trying to figure out how to arrange the following JSON:

{
   "showElement": "1",
   "degrees": [{
       "Name": "Bachelor in Psychology",
       "Number": "53",
       "degree": "Bachelor's Degree"
   }, {
       "Name": "Certificate",
       "Number": "56",
       "degree": "Certificate"
   }, {
       "Name": "High School Diploma",
       "Number": "28",
       "degree": "High School"
   }, {
       "Name": "Bachelor in Sociology",
       "Number": "109",
       "degree": "Bachelor's Degree"
   }]
}

Into this:

{
   "showElement": "1",
   "degrees": [{
       "Name": "Bachelor in Psychology", "Bachelor in Sociology",
       "Number": "53","109",
       "degree": "Bachelor's Degree"
   }, {
       "Name": "Certificate",
       "Number": "56",
       "degree": "Certificate"
   }, {
       "Name": "High School Diploma",
       "Number": "28",
       "degree": "High School"
   }]
}

Basically, put the same degrees in one place and have all the names of said degree separated by a comma

I already have this JSON decoded into a variable:

$data = json_decode($topDegrees[1]["diplomas"],true);

Thanks in advance for your help!

Answer 1

I came up with this

$json = <<<JSON
{
   "showElement": "1",
   "degrees": [{
       "Name": "Bachelor in Psychology",
       "Number": "53",
       "degree": "Bachelor's Degree"
   }, {
       "Name": "Certificate",
       "Number": "56",
       "degree": "Certificate"
   }, {
       "Name": "High School Diploma",
       "Number": "28",
       "degree": "High School"
   }, {
       "Name": "Bachelor in Sociology",
       "Number": "109",
       "degree": "Bachelor's Degree"
   }]
}
JSON;

$data = json_decode( $json, true );

$degrees = $data['degrees'];
$names = array_column($degrees, 'degree');
$count = array_count_values($names);
$duplicates = array_filter($count, function($var) {
  return $var > 1;
});


foreach ( array_flip($duplicates) as $degree ) {

  $filter = array_filter($degrees, function($var) use ($degree) {
    return ( $var['degree'] === $degree );
  });

  $names = [];
  $numers = [];
  foreach ( $filter as $item ) {
    $names[] = $item['Name'];
    $numbers[] = $item['Number'];
  }
  $indices = array_keys($filter);
  $index = array_shift($indices);
  $degrees[$index]['Name'] = $names; // = join(', ', $names);
  $degrees[$index]['Number'] = $numbers; // = join(', ', $numbers);

  while ( count($indices) ) {
    unset($degrees[array_shift($indices)]);
  }
}

$data['degrees'] = $degrees;

print_r(json_encode($data));
// {"showElement":"1","degrees":[{"Name":["Bachelor in Psychology","Bachelor in Sociology"],"Number":["53","109"],"degree":"Bachelor's Degree"},{"Name":"Certificate","Number":"56","degree":"Certificate"},{"Name":"High School Diploma","Number":"28","degree":"High School"}]}

Your wanted json output is not valid, i have made an array structure in its place. If you want comma separated text, just use the join statements I've commented out.