提问者:小点点

我想在php中按周分组我的数组


$date = array('01-01-2019','02-01-2019','05-01-2019','22-01-2019','02-02-2019','03-02-2019','24-02-2019');

上面是我的数组,我想将日期按周分组,这样我就可以在报告中正确地显示它们。所以会是这样的:

Array
(
    [31-12-2018/06-01-2019] => Array  // this is based in calendar week
        (
            [0] => 01-01-2019
            [1] => 02-01-2019
            [2] => 05-01-2019
        )

    [21-01-2019/27-01-2019] => Array
        (
            [0] => 22-01-2019
        )

    [28-01-2019/03-02-2019] => Array
        (
            [0] => 02-02-2019
            [1] => 03-02-2019
        )

    [18-02-2019/24-02-2019] =>  Array
    (
        [0] => 24-02-2019
    )
)


共1个答案

匿名用户

这段代码会做你想做的事情。它将每个日期值转换为datetime对象,查找该日期的周开始和周结束,然后将该值推入由周开始和周结束值索引的新数组:

$date = array('01-01-2019','02-01-2019','05-01-2019','22-01-2019','02-02-2019','03-02-2019','24-02-2019');
$dates = array();
foreach ($date as $d) {
    $od = date_create_from_format('d-m-Y', $d);
    // get start and end of this week
    $sow = $od->sub(new DateInterval('P' . ($od->format('N') - 1). 'D'))->format('d-m-Y');
    $eow = $od->add(new DateInterval('P6D'))->format('d-m-Y');
    $dates["$sow/$eow"][] = $d;
}
print_r($dates);

输出:

Array (
    [31-12-2018/06-01-2019] => Array ( 
        [0] => 01-01-2019
        [1] => 02-01-2019
        [2] => 05-01-2019 
    )
    [21-01-2019/27-01-2019] => Array (
        [0] => 22-01-2019
    )
    [28-01-2019/03-02-2019] => Array (
        [0] => 02-02-2019
        [1] => 03-02-2019
    )
    [18-02-2019/24-02-2019] => Array (
        [0] => 24-02-2019
    )
)

3v4L.org上的演示