Regarding Dashboard Statistics

[dsharma]

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

[Vaishali Agarwal]

Hi @dsharma
You can raise the support ticket here https://bagisto.uvdesk.com/en/customer/create-ticket/

Thanks.