我正在使用一个为员工带回假期数据的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
)
)