Yii2 - 如何在没有上一季度的情况下获得当前季度？

Question

I've a problem here. I need to get a quarter of the year without the past quarter. F.e:

In my database I have a field created_at, which saves the timestamp of service created. I need to not involve those services, which was made in the past quarter. How should I do that?

I'm trying to write a SQL function like this to not involve those services, which was made in the past quarter:

$services= Service::find()
        ->where([         
            'client_service.created' => function ($model) {
                 return ceil(date('n') / 3) - 4;

But I guess I'm wrong. Thanks for any help.

Edited:

        $services= Service::find()
        ->select(['client.id as client_id'])
        ->joinWith('client')
        ->where([         
            'service.type' => Service::TYPE,
            'service.is_archived' => Service::ARCHIVED,])
        ->andWhere([
            'or',
            ['client_service.status' => ClientService::STATUS_NEGATIVE],
            [client_service.created' => function ($model) {
                 return ceil(date('n') / 3) - 4;]

Answer 1

Find start and end date of quarter

$date =  new \DateTime(); // Current Date and Time
$quarter_start = clone($date);

// Find the offset of months
$months_offset = ($date->format('m') - 1) % 3;

// Modify quarter date
$quarter_start->modify(" - " . $months_offset . " month")->modify("first day of this month");

$quarter_end = clone($quarter_start);
$quarter_end->modify("+ 3 month");

$startDate = $quarter_start->format('Y-m-d');
$endDate = $quarter_end->format('Y-m-d');

Query

$services= Service::find()
    ->select(['client.id as client_id'])
    ->joinWith('client')
    ->where([         
        'service.type' => Service::TYPE,
        'service.is_archived' => Service::ARCHIVED,])
    ->andWhere([
        'or',
        ['client_service.status' => ClientService::STATUS_NEGATIVE],
        ['between', 'date_format(FROM_UNIXTIME(client_service.created), "%Y-%m-%d")', $startDate, $endDate]

You can also use mysql Quarter() to achieve the result.