结合相同的json值，并使用php / javascript使其成为关键

Question

I have the following JSON

[
   {
      "Date" : "10/7/2014",
      "Data1" : 23
   },
   {
      "Date" : "10/7/2014",
      "Data1" : 23
   },
   {
      "Date" : "10/8/2014",
      "Data1" : 40
   },
    {
      "Date" : "10/8/2014",
      "Data1" : 23
   },
   {
      "Date" : "10/9/2014",
      "Data1" : 55
   },
   {
      "Date" : "10/9/2014",
      "Data1" : 22
   },
]

I want to convert same dates to be an array key with different data's to be an each item something like below

[
  "10/7/2014" : [{
      "Data1" : 23
   },{
      "Data1" : 23
   }],
  "10/8/2014" : [{
      "Data1" : 40
   },{
      "Data1" : 23
   }],
  "10/9/2014" : [{
      "Data1" : 55
   },{
      "Data1" : 22
   }],
]

Is this possible to do using php or javascript?

Thanks for any help.

Answer 1

Just loop through your data and act accordingly. Also, you better change the property name 'Date', because it is a function defined on global scope.

var data = [
   {
      "date" : "10/7/2014",
      "Data1" : 23
   },
   {
      "date" : "10/7/2014",
      "Data1" : 23
   },
   {
      "date" : "10/8/2014",
      "Data1" : 40
   },
    {
      "date" : "10/8/2014",
      "Data1" : 23
   },
   {
      "date" : "10/9/2014",
      "Data1" : 55
   },
   {
      "date" : "10/9/2014",
      "Data1" : 22
   },
]

var results = {}

data.forEach(function(obj){
  if (obj['date'] in results){
     results[obj['date']].push({Data1 : obj['Data1']});
  }else{
     results[obj['date']] = [{Data1 : obj['Data1']}];
  }
});