php - 合并来自单个数据集的关联数据

Question

我接手了一个已经包含大量数据的项目。给定的格式不是最好的并且只包含单个数据集。他们中的大多数属于同一个“事件”。我想合并这些数据集。

给定的数据集采用这种格式:

给定的数据集:

[0] => Array
    (
        [id] => 4
        [title] => Party 1
        [start] => 2017-06-14
        [end] => 2017-06-14
        [className] => Array
            (
                [0] => yyy
                [1] => zzz
            )

        [color] => #26B99A
        [zeit] => xxx
    )

[1] => Array
    (
        [id] => 6
        [title] => Party 2
        [start] => 2017-04-27
        [end] => 2017-04-27
        [className] => Array
            (
                [0] => xxx
                [1] => yyy
            )

        [color] => #26B99A
        [zeit] => zzz
    )

[2] => Array
    (
        [id] => 7
        [title] => Party 2
        [start] => 2017-04-28
        [end] => 2017-04-28
        [className] => Array
            (
                [0] => xxx
                [1] => yyy
            )

        [color] => #26B99A
        [zeit] => zzz
    )

[3] => Array
    (
        [id] => 9
        [title] => Party 2
        [start] => 2017-04-29
        [end] => 2017-04-29
        [className] => Array
            (
                [0] => xxx
                [1] => yyy
            )

        [color] => #26B99A
        [zeit] => zzz
    )

[4] => Array
    (
        [id] => 11
        [title] => Party 3
        [start] => 2017-07-30
        [end] => 2017-07-30
        [className] => Array
            (
                [0] => xxx
                [1] => yyy
            )

        [color] => #26B99A
        [zeit] => zzz
    )

[5] => Array
    (
        [id] => 13
        [title] => Party 3
        [start] => 2017-07-31
        [end] => 2017-07-31
        [className] => Array
            (
                [0] => xxx
                [1] => yyy
            )

        [color] => #26B99A
        [zeit] => zzz
    )......

在这种情况下，将有一个“Party 1”，以及“Party 2”和“Party 3”的组合

因此结果应该是这样的:

预期结果

[0] => Array
(
    [id] => 4
    [title] => Party 1
    [start] => 2017-06-14
    [end] => 2017-06-14
    [className] => Array
        (
            [0] => yyy
            [1] => zzz
        )

    [color] => #26B99A
    [zeit] => xxx
)

[1] => Array
(
    [id] => 6
    [title] => Party 2
    [start] => 2017-04-27
    [end] => 2017-04-29    <---- end date edited
    [className] => Array
        (
            [0] => xxx
            [1] => yyy
        )

    [color] => #26B99A
    [zeit] => zzz
)


[2] => Array
(
    [id] => 11
    [title] => Party 3
    [start] => 2017-07-30
    [end] => 2017-07-31     <---- same
    [className] => Array
        (
            [0] => xxx
            [1] => yyy
        )

    [color] => #26B99A
    [zeit] => zzz
)

因此，我使用了一个 PHP 函数，该函数按事件的标题对其进行格式化:

PHP:

function formateEvents($event_array){
$events = array();

foreach($event_array as $event)
{
    if(!isset($events[$event['title']]))
    {
        $events[$event['title']]['id']           = $event['id'];
        $events[$event['title']]['title']        = $event['title'];
        $events[$event['title']]['start']        = $event['start'];
        $events[$event['title']]['end']          = $event['end'];
        $events[$event['title']]['name']         = $event['title'];
        $events[$event['title']]['className']    = $event['className'];
        $events[$event['title']]['color']        = $event['color'];
        $events[$event['title']]['zeit']         = $event['zeit'];
    }else{


        if(strtotime($event['start']) < strtotime($events[$event['title']]['start']))
        {
            $events[$event['title']]['start']    = $event['start'];
        }

        if(strtotime($event['end']) > strtotime($events[$event['title']]['end']))
        {
            $events[$event['title']]['end']    = $event['end'];
        }
    }
}

return array_values($events);
}

这适用于上述数据集。但是:问题是，我也有多年前的事件数据，这些数据通常具有相同的标题。在这种情况下，事件持续时间超过多年。我想以一种方式防止这种情况发生，即只合并具有相同名称的数据以及连接的日期。

我想到的唯一方法是检查日期是否连续......比如 2018-01-01、2018-01-02、2018-01-03 应该是同一事件...如果中间缺少一天，则应算作另一个事件

Answer 1

我的解决方案比我想要的要复杂得多，但它确实有效。那么，让我解释一下。

首先我按标题映射所有事件。

$eventsIndexedByTitleAndEndDate = array();
foreach ($event_array as $event) {
    $eventTitle = $event['title'];
    $eventEnd = $event['end'];

    $eventsIndexedByTitleAndEndDate[$eventTitle][$eventEnd] = $event;
}    

然后我遍历这些数据以找到我想要使用的日期，然后我将这些日期映射到另一个仍然使用事件标题作为主要索引的数组。

$eventDates = array();
foreach ($eventsIndexedByTitleAndEndDate as $eventTitle => $eventIndexedByTitle) {
    $datesFromIndexedTitle = (array_keys($eventIndexedByTitle));

    $start = $datesFromIndexedTitle[0];
    $end = $datesFromIndexedTitle[0];
    foreach ($datesFromIndexedTitle as $dateFromIndexedTitle) {
        $nextDayFromEnd = date('Y-m-d', strtotime("+1 day", strtotime($end)));
        if ($dateFromIndexedTitle == $nextDayFromEnd) {
            $end = $dateFromIndexedTitle;
        } elseif ($dateFromIndexedTitle > $nextDayFromEnd) {
            $eventDates[$eventTitle][] = [
                'start' => $start,
                'end' => $end,
            ];
            $start = $dateFromIndexedTitle;
            $end = $dateFromIndexedTitle;
        }
    }
    $eventDates[$eventTitle][] = [
        'start' => $start,
        'end' => $end,
    ];
}

我映射了所有日期后，我使用引用遍历此数组，以使用标题索引的数组中的数据更新键，按应有的方式更新开始/结束日期。

foreach ($eventDates as $title => &$eventDate) {
    foreach ($eventDate as &$eachEvent) {
        $start = $eachEvent['start'];
        $end = $eachEvent['end'];

        $eachEvent = $eventsIndexedByTitleAndEndDate[$title][$start];
        $eachEvent['start'] = $start;
        $eachEvent['end'] = $end;
    }
}

我相信可能有更简单的方法来做到这一点，但我现在想不出一个解决方案，尽管这是一个很好的练习。 :)