忽略多维数组中的重复条目



我正在使用一个为员工带回假期数据的API。数据包含批准的假期请求,以及取消的假期请求。我面临的问题是,取消的假期请求以以下格式显示为重复条目:

stdClass Object
  (
     [leave_requests] => Array
     (
        [0] => stdClass Object
            (
                [employee] => stdClass Object
                    (
                        [id] => 30771
                    )
                [reviewed_by] => stdClass Object
                    (
                        [id] => 22734
                    )
                [reason] => 
                [type] => Holiday
                [deducted] => 1.0
                [cancelled] => 
                [id] => 626214
                [start_date] => 2015-08-20
                [half_start] => 
                [half_start_am_pm] => 
                [end_date] => 2015-08-20
                [half_end] => 
                [half_end_am_pm] => 
                [action] => request
                [status] => approved
                [notes] => 
                [created_at] => 2015-08-06T21:55:12+01:00
                [updated_at] => 2015-08-07T08:26:07+01:00
            )
        [1] => stdClass Object
            (
                [employee] => stdClass Object
                    (
                        [id] => 30771
                    )
                [reviewed_by] => stdClass Object
                    (
                        [id] => 22734
                    )
                [reason] => 
                [type] => Holiday
                [deducted] => 1.0
                [cancelled] => 
                [id] => 632745
                [start_date] => 2015-08-20
                [half_start] => 
                [half_start_am_pm] => 
                [end_date] => 2015-08-20
                [half_end] => 
                [half_end_am_pm] => 
                [action] => cancel
                [status] => approved
                [notes] => 
                [created_at] => 2015-08-12T17:50:32+01:00
                [updated_at] => 2015-08-12T17:53:46+01:00
            )
    )
)

理想情况下,数据将被格式化,以便使用取消的属性,我可以过滤掉它(这是开发人员的要求)。我想做的是删除具有相同start_date和end_date的两个条目。

目前我能够删除重复,通过使用这个函数

function super_unique($array)
    {
        $newArr = array();
        foreach ($array as $val) {
            $newArr[$val['startDate']] = $val;
        }
        $array = array_values($newArr);
        return $array;
    }

这有几个问题,因为我仍然留下一个条目,因为假期请求已被取消,我不希望它们中的任何一个在数据中。过滤数据以排除所有具有'cancel'动作属性的元素,仍然会使我保留原始请求。

另一个问题是,上面的函数只基于start_date进行过滤,而不是同时基于start_date和end_date。

浏览了关于这个SO问题的评论,以及PHP文档页面上关于array_values和array_unique的评论。

我对你现在的代码做了一些轻微的修改,请看代码中的注释:

function super_unique($array)
{
    $newArr = array();
    foreach ($array as $val) {
        // Create a key by combining start/end dates 
        $key = $val['startDate'].$val['endDate'];
        // Have we already seen this start/end date combination?
        if (array_key_exists($key, $newArr)) {
            $val = null; // Clear element value, like "remove this later on"
        }
        $newArr[$key] = $val; // Add to/update key index (actual value or null)
    }
    // Remove all elements with unset (null) values
    $array = array_filter(array_values($newArr));
    return $array;
}
$a = [['startDate' => '2015-08-20', // Exists twice - should be removed
       'endDate'   => '2015-08-22'],
      ['startDate' => '2015-08-20', // Unique start/end combination
       'endDate'   => '2015-08-20'],
      ['startDate' => '2015-08-21', // Unique start/end combination
       'endDate'   => '2015-08-21'],
      ['startDate' => '2015-08-20', // Exists twice - should be removed
       'endDate'   => '2015-08-22'],
      ['startDate' => '2015-08-22', // Unique start/end combination
       'endDate'   => '2015-08-20'],
];
print_r(super_unique($a));
输出:

Array
(
    [1] => Array
        (
            [startDate] => 2015-08-20
            [endDate] => 2015-08-20
        )
    [2] => Array
        (
            [startDate] => 2015-08-21
            [endDate] => 2015-08-21
        )
    [3] => Array
        (
            [startDate] => 2015-08-22
            [endDate] => 2015-08-20
        )
)

相关内容

  • 没有找到相关文章

最新更新