TP6 时间查询

whereDay('create_time')
whereTime('create_time', 'today')

whereDay('create_time', 'yesterday')

whereWeek('create_time')

/**
 * 根据时间筛选数据
 */
public function searchTimeAttr($query, $value, $data)
{
    switch ($value) {
        case 'today': //今日
            $query->whereDay('create_time');
            break;
        case 'week': //本周
            $query->whereWeek('create_time');
            break;
        case 'month': //本月
            $query->whereMonth('create_time');
            break;
        case 'year': //本年
            $query->whereYear('create_time');
            break;
        case 'quarter': //本季度
            $query->whereBetweenTime('create_time', ...getQuarterTime());
            break;
        default:
            break;
    }
}

/**
 * 获取当前季度时间范围
 */
function getQuarterTime()
{
    $month = intval(date('m'));
    if ($month < 4) {
        $start = date('Y-01-01 00:00:00');
        $end   = date("Y-03-31 23:59:59");
    } else if ($month < 7) {
        $start = date('Y-04-01 00:00:00');
        $end   = date("Y-06-30 23:59:59");
    } else if ($month < 10) {
        $start = date('Y-07-01 00:00:00');
        $end   = date("Y-09-30 23:59:59");
    } else {
        $start = date('Y-10-01 00:00:00');
        $end   = date("Y-12-31 23:59:59");
    }
    return [$start, $end];
}

date('Y-m-d', strtotime('+1 days')) . ' 07:00:00'

strtotime(date('Y-m-d'))
strtotime(date('Y-m-d', strtotime('+1 days'))) - 1