jeudi 7 mars 2019

How to use `where` or `whereIn` condition inside laravel `select ` query

I am trying to get monthly total sales for current year from sales table. I did something like below to get the result. But, it's returning all different month's sales sum. Would someone help me please to find out the every month's sales total from January to December for current year. I tried something like this -

$months = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12];

$monthlySales = Sale::whereIn(DB::raw('MONTH(created_at)'), $months)
                    ->whereYear('created_at', '=', date('Y'))
                    ->select(DB::raw("SUM(((sellingprice * discount_percent) / 100) * productqty) as monthlySale"))
                    ->get();

dd($monthlySales);



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire