I want to display the quantity sold per each product using the below query. From this query I am getting each product id and the quantity sold. The problem is that I want to get by name so that I am able to display it in the pie chart. I have a relationship in BakeryOrderItem but I dont know how to use it in this case. I should be able to do something like BakeryOrderItem()->product->name.
//returns quantity of each product sold
$product_quantities = BakeryOrderItem::whereBetween('created_at', array(date('2018-01-01'), date('2018-03-31')))
->select('product_id', DB::raw("SUM(quantity) as qty"))
->groupBy('product_id')
->orderBy('qty', 'desc')
->take(6)
->get();
On this second query I need to display a line in the line chart for each product. The chart should show a line for the top 6 product sold for January, February and march.
//returns number of products sold per month
$product_details = BakeryOrderItem::whereBetween('created_at', array(date('2018-01-01'), date('2018-03-31')))
->select(DB::raw("to_char(created_at, 'Mon') as month"),
DB::raw("SUM(quantity) as qty"))
->groupBy('month')
->orderBy('qty', 'desc')
->take(6)
->get();
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire