Level 13
try this
$from = date('2019-12-05');
$to = date('2019-10-01');
$bestseller = Bestseller::whereBetween('bestseller', [$from, $to])->get();
Dec 12, 2019
3
Level 2
sql query to get best sellers in ecommerce within a date range?
`` Hello I have folowing tables in my ecommerce application:
products id name
orders id userid total created_date
order_items id orderid productid quantity
how can I query database to get best seller products which have been ordered within specific date range like 2019-10-1 to 2019-12-5? ``
Level 1
$from = date('2019-12-05'); $to = date('2019-10-01');
$bestseller = Order::whereDate('created_date','>=',$from) ->whereDate('created_date','<=',$to) ->get() ->orderBy('total','desc');
Level 2
thank you for response. your suggestion is going to give orders but I would like to get best sellers products which I think I am going to get from products table.
Please or to participate in this conversation.