Picking up monthly items ELOQUENT MODEL

Question

Well I need to make one query where I have to bring all the listed items of the month in which we are.

In the query I’ve done I’m bringing them all with status O of OK:

$vendas = Encomenda::where('FlgStEncomenda', 'O')->count();

In my table structure I have a created_at which is the date of creation, composed of data and hora as follows 2016-11-02 16:25:03 through it I need to do the research. So I have to return all the vendas registered this month.

Answer 1

In the version Larable until 5.2 use the whereRaw:

$mes = date('m');

$vendas = Encomenda::where('FlgStEncomenda', 'O')
                   ->whereRaw("MONTH(created_at)={$mes}") 
                   ->count();

or

$vendas = Encomenda::where('FlgStEncomenda', 'O')
                   ->whereRaw("MONTH(created_at)=?", array($mes)) 
                   ->count();

---

In the version Larable 5.3 use the new method whereMonth:

$mes = date('m');

$vendas = Encomenda::where('FlgStEncomenda', 'O')
                   ->whereMonth("created_at",$mes) 
                   ->count();

_{Remarks: in the whereRaw any existing function in the bank can be used, for example in the bank link to the SOPT, owns the SQL Date, month and year filters obtained from a field date or datetime in Banco mysql. I must also point out that the whereRaw works in current versions of Larable.}

References:

• Where Clauses - Laravel 5.3
• Where Exists Clauses