PHP中动态获取当前周数据及周边界处理

<?php
// 获取当前周的周一和周日
$this_week_start = date("Y-m-d", strtotime("monday this week"));
$this_week_end = date("Y-m-d", strtotime("sunday this week"));

echo "当前周的周一: " . $this_week_start . PHP_EOL;
echo "当前周的周日: " . $this_week_end . PHP_EOL;
?>

<?php
// 模拟周日午夜前一秒 (例如: 2021-12-19 23:59:59)
// 注意: 这里的Unix时间戳是示例，实际应根据当前时间计算
$midnight_minus1 = strtotime('2021-12-19 23:59:59'); // 假设2021-12-19是周日

echo '在周日午夜前一秒 (' . date('Y-m-d H:i:s', $midnight_minus1) . '):' . PHP_EOL;
$this_week_start_minus1 = date("D - Y-m-d", strtotime("monday this week", $midnight_minus1));
echo "  周一: " . $this_week_start_minus1 . PHP_EOL;
$this_week_end_minus1 = date("D - Y-m-d", strtotime("sunday this week", $midnight_minus1));
echo "  周日: " . $this_week_end_minus1 . PHP_EOL;

echo PHP_EOL;

// 模拟周一午夜零点 (例如: 2021-12-20 00:00:00)
$midnight = strtotime('2021-12-20 00:00:00'); // 假设2021-12-20是周一

echo '在周一午夜零点 (' . date('Y-m-d H:i:s', $midnight) . '):' . PHP_EOL;
$this_week_start_midnight = date("D - Y-m-d", strtotime("monday this week", $midnight));
echo "  周一: " . $this_week_start_midnight . PHP_EOL;
$this_week_end_midnight = date("D - Y-m-d", strtotime("sunday this week", $midnight));
echo "  周日: " . $this_week_end_midnight . PHP_EOL;

echo PHP_EOL;

// 模拟周一午夜后一秒 (例如: 2021-12-20 00:00:01)
$midnight_plus1 = strtotime('2021-12-20 00:00:01');

echo '在周一午夜后一秒 (' . date('Y-m-d H:i:s', $midnight_plus1) . '):' . PHP_EOL;
$this_week_start_plus1 = date("D - Y-m-d", strtotime("monday this week", $midnight_plus1));
echo "  周一: " . $this_week_start_plus1 . PHP_EOL;
$this_week_end_plus1 = date("D - Y-m-d", strtotime("sunday this week", $midnight_plus1));
echo "  周日: " . $this_week_end_plus1 . PHP_EOL;
?>

在周日午夜前一秒 (2021-12-19 23:59:59):
  周一: Mon - 2021-12-13
  周日: Sun - 2021-12-19

在周一午夜零点 (2021-12-20 00:00:00):
  周一: Mon - 2021-12-20
  周日: Sun - 2021-12-26

在周一午夜后一秒 (2021-12-20 00:00:01):
  周一: Mon - 2021-12-20
  周日: Sun - 2021-12-26

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Order_model extends CI_Model {

    public function get_current_week_orders() {
        // 获取当前周的周一和周日日期
        $this_week_start = date("Y-m-d", strtotime("monday this week"));
        $this_week_end = date("Y-m-d", strtotime("sunday this week"));

        // 构建数据库查询
        $this->db->select('*');
        $this->db->from('orders');
        $this->db->where("status_id", 16); // 假设只关心特定状态的订单
        // 查询条件确保 updated_at 在当前周的周一00:00:00到周日23:59:59之间
        $this->db->where("updated_at >= '$this_week_start 00:00:00'");
        $this->db->where("updated_at <= '$this_week_end 23:59:59'"); // 确保包含周日全天

        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            return $query->result_array();
        } else {
            return [];
        }
    }

    // 示例：获取当前周订单数量
    public function get_current_week_order_count() {
        $this_week_start = date("Y-m-d", strtotime("monday this week"));
        $this_week_end = date("Y-m-d", strtotime("sunday this week"));

        $this->db->select('COUNT(id) as order_count');
        $this->db->from('orders');
        $this->db->where("status_id", 16);
        $this->db->where("updated_at >= '$this_week_start 00:00:00'");
        $this->db->where("updated_at <= '$this_week_end 23:59:59'");

        $query = $this->db->get();
        return $query->row()->order_count;
    }
}