「從週一到週日只能看到上週一到上週日的數據」——即無論今天是星期幾,都要取得上一個自然週(週一至週日)的起始與結束日期。
<?php
$start = date('Y-m-d', strtotime('-2 week monday'));
$end = date('Y-m-d', strtotime("$start +6 day"));
// 測試
// 今天 2024-01-15 (週一) → $start = 2024-01-01 (正確)
// 今天 2024-01-14 (週日) → $start = 2024-01-01 (正確)
// 今天 2024-01-16 (週二) → $start = 2024-01-08 (錯誤!應為 2024-01-01)
?>
原因:strtotime('-2 week monday') 解析為「兩周前的週一」,而非「上一個週一」。
<?php
$w = date('w'); // 0=Sun, 1=Mon...
$start = date('Y-m-d', strtotime("-" . ($w + 6) . " days")); // 推算上週一
$end = date('Y-m-d', strtotime("$start +6 days"));
// 今天 2024-01-14 (週日, w=0) → $start = 2024-01-01 (正確)
// 今天 2024-01-21 (週日, w=0) → $start = 2024-01-15 (錯誤!應為 2024-01-08)
?>
原因:週日 w=0 導致計算偏移量錯誤,邏輯無法統一處理週日情況。
<?php
function getLastWeekRange(): array {
$today = new DateTimeImmutable('today', new DateTimeZone('Asia/Shanghai'));
$dayOfWeek = (int)$today->format('N'); // 1=Mon ... 7=Sun
// 計算距離「上週一」的天數
// 今天是週一(1) -> 往前 7 天
// 今天是週二(2) -> 往前 8 天
// ...
// 今天是週日(7) -> 往前 13 天
$daysBack = $dayOfWeek + 6;
$monday = $today->sub(new DateInterval("P{$daysBack}D"));
$sunday = $monday->add(new DateInterval('P6D'));
return [
'start' => $monday->format('Y-m-d'),
'end' => $sunday->format('Y-m-d'),
'start_ts' => $monday->getTimestamp(),
'end_ts' => $sunday->setTime(23,59,59)->getTimestamp(),
];
}
// 測試各種日期
$testDates = ['2024-01-15', '2024-01-14', '2024-01-16', '2024-01-21', '2024-01-22'];
foreach ($testDates as $date) {
$dt = new DateTimeImmutable($date);
echo "今天 $date (週" . $dt->format('N') . ") → ";
print_r(getLastWeekRange());
}
?>
<?php
$range = getLastWeekRange();
$pdo = new PDO(...);
$stmt = $pdo->prepare('
SELECT * FROM logs
WHERE created_at >= ? AND created_at <= ?
');
$stmt->execute([$range['start_ts'], $range['end_ts']]);
$logs = $stmt->fetchAll();
// 或用日期字串(含時區風險)
$stmt = $pdo->prepare('
SELECT * FROM logs
WHERE DATE(created_at) BETWEEN ? AND ?
');
$stmt->execute([$range['start'], $range['end']]);
?>
<?php
function getWeekRange(int $offsetWeeks = -1): array {
// $offsetWeeks = -1 上週, 0 本週, 1 下週...
$today = new DateTimeImmutable('today', new DateTimeZone('Asia/Shanghai'));
$dow = (int)$today->format('N'); // 1-7
// 先對齊到「本週一」
$thisMonday = $today->sub(new DateInterval("P" . ($dow - 1) . "D"));
// 再偏移目標週
$targetMonday = $thisMonday->add(new DateInterval("P" . ($offsetWeeks * 7) . "D"));
$targetSunday = $targetMonday->add(new DateInterval('P6D'));
return [
'monday' => $targetMonday->format('Y-m-d'),
'sunday' => $targetSunday->format('Y-m-d'),
];
}
// 用法
echo "上週: " . json_encode(getWeekRange(-1)) . "\n";
echo "本週: " . json_encode(getWeekRange(0)) . "\n";
echo "下週: " . json_encode(getWeekRange(1)) . "\n";
?>
date('w'):0=週日,date('N'):1=週一(ISO-8601),週邊界計算請用 Nstrtotime('monday') 回傳下一個週一(含今天若是週一),strtotime('last monday') 回傳上一個週一(不含今天)DateTimeImmutable 鏈式操作不改變原物件,適合函數式風格