如何在数组中同名的情况下进行数组合并


How to array merge in case same name in array

我有多个数组值的数组,我想在现有数组值中形成新数组,如果绘图类型相同,则返回单个数组并计算相同绘图时间的时间。

Actual Array:
    (
        [0] => Array
            (
                [Time] => 00:45
                [PlottingType] => Research
            )
        [1] => Array
            (
                [Time] => 00:45
                [PlottingType] => admin
            )
        [2] => Array
            (
                [Time] => 00:45
                [PlottingType] => admin
            )
        [3] => Array
            (
                [Time] => 00:45
                [PlottingType] => Research
            )
        [4] => Array
            (
                [Time] => 00:30
                [PlottingType] => Research
            )
    )
    Expected Array:
    Array
    (
        [0] => Array
            (
                [Time] => 01:30
                [PlottingType] => Research
            )
        [1] => Array
            (
                [Time] => 01:30
                [PlottingType] => admin
            )

    )

将相同的绘图类型时间计算成单个索引成单个 array.so 请提出适当的解决方案。

$data = array(
  array('Time' => '00:45', 'PlottingType' => 'Research'),
  array('Time' => '00:45', 'PlottingType' => 'admin'),
  array('Time' => '00:45', 'PlottingType' => 'admin'),
  array('Time' => '00:45', 'PlottingType' => 'Research'),
  array('Time' => '00:30', 'PlottingType' => 'Research'),
);
print_r(array_reduce($data, function($result, $item) {
    $key = $item['PlottingType'];
    if (!isset($result[$key]))
       $result[$key] = $item;
    else
    {
       list($h1, $m1) = explode(':', $result[$key]['Time']);
       list($h2, $m2) = explode(':', $item['Time']);
       $time = ($h1 + $h2) * 60 + $m1 + $m2;
       $h = floor($time / 60);
       $m = $time % 60;
       $result[$key]['Time'] = str_pad($h, 2, "0", STR_PAD_LEFT) . ':' . 
                               str_pad($m, 2, "0", STR_PAD_LEFT);
    }
    return $result;
}, array()));

可以玩strtotimedate,但我不想,所以代码稍微长一点。如果要从结果中删除最终键 - 对其应用函数array_values

结果

Array
(
    [Research] => Array
        (
            [Time] => 02:00
            [PlottingType] => Research
        )
    [admin] => Array
        (
            [Time] => 01:30
            [PlottingType] => admin
        )
)

PS:还有另一种方式

print_r(array_reduce($data, function($result, $item) {
    $key = $item['PlottingType'];
    if (!isset($result[$key]))
       $result[$key] = $item;
    else
    {
       $time = strtotime('0:' . $result[$key]['Time']);
       list($h, $m) = explode(':', $item['Time']);
       $time = strtotime('+' . $h . ' minutes', $time);
       $time = strtotime('+' . $m . ' seconds', $time);
       $result[$key]['Time'] = date('i:s', $time);
    }
    return $result;
}, array()));
在这里,我用分钟

作为秒,用小时作为分钟,所以答案可能超过 24 小时,最多 60 小时。

pps:好的,你不能自己把它赋给变量,我帮你写下来

$data = array_values(array_reduce($data, function($result, $item) {
      $key = $item['PlottingType'];
      if (!isset($result[$key]))
         $result[$key] = $item;
      else
      {
         $time = strtotime('0:' . $result[$key]['Time']);
         list($h, $m) = explode(':', $item['Time']);
         $time = strtotime('+' . $h . ' minutes', $time);
         $time = strtotime('+' . $m . ' seconds', $time);
         $result[$key]['Time'] = date('i:s', $time);
      }
      return $result;
}, array()));
$expectedarray = array();
foreach($ar as $yourmainarray)
{
    foreach($u as $expectedarray)
    {
        if($ar['PlottingType'] == $u['PlottingType'])
        {
             $u['Time'] = $u['Time'] + $ar['Time'];
        }
        else
        {
             array_push($ar, $expectedarray);
        }
    }
}

它将给出这样的输出

   [0] => Array
        (
            [Time] => 2:00
            [PlottingType] => Research
        )
    [1] => Array
        (
            [Time] => 01:30
            [PlottingType] => admin
        )

您可以将其检查为

foreach($u as $expectedarray)
{
    print_r($u);
}

看起来您正在尝试删除数组中的重复项。在这种情况下,请使用array_unique()函数。

$expectedarray = array_unique($actualarray);
print_r($expectedarray);

如果要计算值,请使用array_count_values() array_unique()

有关更多信息,请参阅此处:http://php.net/manual/en/function.array-unique.php

好的。我正在删除旧的答案,这是新的工作答案。我希望你能做一些必要的小改动。

function add_minutes($time_1, $time_2) {
    $temp = explode(':', $time_1);
    $hr_1 = $temp[0]; $min_1 = $temp[1];
    $temp = explode(':', $time_2);
    $hr_2 = $temp[0]; $min_2 = $temp[1];
    $min_2 = $min_2+$min_1;
    $min_1 = intval($min_2/60);
    $hr_2 = $hr_2 + $hr_1;
    $hr_2 += $min_1;
    $min_2 = $min_2%60;
    $min_2 = sprintf('%02d', $min_2); $hr_2 = sprintf('%02d', $hr_2);
    return $hr_2.':'.$min_2;
}
$actual_array = array();
$actual_array[] = array('Time' => '01:45', 'PlottingType' => 'Research');
$actual_array[] = array('Time' => '00:45', 'PlottingType' => 'admin');
$actual_array[] = array('Time' => '00:45', 'PlottingType' => 'admin');
$actual_array[] = array('Time' => '00:45', 'PlottingType' => 'Research');
$actual_array[] = array('Time' => '00:45', 'PlottingType' => 'Research');
$single_array = array();
foreach($actual_array as $val) {
    if (key_exists($val['PlottingType'], $single_array)) {
        $single_array[$val['PlottingType']] = add_minutes($val['Time'], $single_array[$val['PlottingType']]);
    } else {
        $single_array[$val['PlottingType']] = $val['Time'];
    }
}
$output_array = array();
foreach ($single_array as $key => $value) {
    $output_array[] = array('PlottingType' => $key, 'Time' => $value);
}
// $output_array this is your answer.
echo '<pre>'; var_dump($output_array);