D
Hello,
We are using your package but i stucked at one place actually i have to exclude one vendor in total sales. I have tried join and many other ways to do it. but it shows incorrect stats.
Here is code of Dashboard Controller (I added marketplace_orders table join)
private function getOrdersBetweenDate($start, $end)
{
return $this->order->scopeQuery(function ($query) use ($start, $end) {
return $query->leftjoin('marketplace_orders','marketplace_orders.order_id','=','orders.id')->where('orders.created_at', '>=', $start)->where('orders.created_at', '<=', $end)
->where('orders.status', '!=', 'canceled')
->where('orders.status','!=','closed')
->where('orders.status','!=','fraud')
->where('orders.status','!=','pending')
->where('marketplace_orders.marketplace_seller_id','!=',8);
});
}
Can you please tell me how can i do correct that.
Thankyou
Deepak Sharma