根据共享时间范围将二维数组数据格式化为连字符连续日期范围的字符串

Question

我从 API 获得的数据的格式相当难以使​​用（以必需使用的方式）——我没有能力修改 API。下面是我得到的数据的示例：

$data = array(
    array('day' => 'Monday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Tuesday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Wednesday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Thursday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Friday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Saturday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Sunday', 'start' => 1200, 'end' => 1400)
);

数据可能不包括一周中的所有 7 天，开始和结束在 0000 到 2400 之间变化。我试图想出一种使用以下输出格式化数据的方法：

Monday - Wednesday (1100-1300), Thursday - Saturday (1200-1300), Sunday (1200-1400)

基本上，连续的日期（其开始时间和结束时间相同）由连字符分隔。

我有点试图避免一大堆丑陋的代码。

Answer 1

丑陋是情人眼里出西施。 ；）我认为这没关系，但当然这可能正是您想要避免的。

<?php
$data = array(
    array('day' => 'Monday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Tuesday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Wednesday', 'start' => 1100, 'end' => 1300),
    array('day' => 'Thursday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Friday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Saturday', 'start' => 1200, 'end' => 1300),
    array('day' => 'Sunday', 'start' => 1200, 'end' => 1400)
);

$periods = array();

$start = $end = $i = -1;

foreach ($data as $datum) {
    if ($start != $datum['start'] || $end != $datum['end']) {
        $i++;
        $start = $datum['start'];
        $end   = $datum['end'];

        $periods[$i] = array(
                          'start'    => $start, 
                          'end'      => $end,
                          'startDay' => $datum['day']);
    }
    $periods[$i]['endDay'] = $datum['day'];
}

foreach ($periods as $k => $period) {
    echo ($k) ? ', ' : '';
    if ($period['startDay'] === $period['endDay']) {
        echo $period['startDay'];
    } else {
        echo "{$period['startDay']} - {$period['endDay']}";
    }
    echo " ({$period['start']} - {$period['end']})";
}

会输出：

Monday - Wednesday (1100 - 1300), Thursday - Saturday (1200 - 1300), Sunday (1200 - 1400)

Answer 2

在循环遍历行时，无条件地尝试写入或覆盖与当前星期几相同的小时范围（如果位于字符串）之前的单词。如果替换尝试失败，请将当前日期和时间范围附加到字符串末尾。

该脚本的优点是不需要预先对数据进行分组，然后再次循环以呈现分组的数据。这种方法只是一个注入或串联过程。 Demo

$data = [
    ['day' => 'Monday', 'start' => 1100, 'end' => 1300],
    ['day' => 'Tuesday', 'start' => 1100, 'end' => 1300],
    ['day' => 'Wednesday', 'start' => 1100, 'end' => 1300],
    ['day' => 'Thursday', 'start' => 1200, 'end' => 1300],
    ['day' => 'Friday', 'start' => 1200, 'end' => 1300],
    ['day' => 'Saturday', 'start' => 1200, 'end' => 1300],
    ['day' => 'Sunday', 'start' => 1200, 'end' => 1400],
];

function hyphenateConsecutiveDaysWithDuplicateTimes(array $rows): string {
    $string = '';
    foreach ($rows as $row) {
        $time = "({$row['start']}-{$row['end']})";
        $string = preg_replace(
            "/(?: - [^(]+)?(?= \Q$time\E$)/",
            " - {$row['day']}",
            $string,
            1,
            $count
        );
        if (!$count) {
            $string .= ($string ? ', ' : '') . "{$row['day']} $time";
        }
    }
    return $string;
}

echo hyphenateConsecutiveDaysWithDuplicateTimes($data);

正则表达式模式：

(?:        #start of non-capturing group
    -      #match space, hyphen, space
   [^(]+   #match one or more non-opening-parentheses
)?         #end of non-capture group and allow zero or one of the internal match
(?=        #start of lookahead      
    \Q     #match space, then tell the engine to treat everything literally
   $time   #match the parenthetical time range expression
   \E      #tell the engine to stop treating everything literally
   $       #match the end of the string
)          #end the lookahead

如果上面的脚本不够漂亮或不够直观，也许可以声明更多变量来实现它更具表现力。

function hyphenateConsecutiveDaysWithDuplicateTimes(array $rows): string {
    $string = '';
    $optionalEndDay = '(?: - [^(]+)?';
    foreach ($rows as $row) {
        extract($row);
        $time = "($start-$end)";
        $sameTimeRange = "(?= \Q$time\E$)";
        $string = preg_replace("/$optionalEndDay$sameTimeRange/", " - $day", $string, 1, $count);
        if (!$count) {
            $string .= ($string ? ', ' : '') . "$day $time";
        }
    }
    return $string;
}