/** * show Statuses */ public function getStatuses($paginateItems = 50) { app('veer')->loadedComponents['counted']['orders'] = \Veer\Models\Order::select(\DB::raw('count(*) as orders_count, status_id'))->groupBy('status_id')->lists('orders_count', 'status_id'); app('veer')->loadedComponents['counted']['orders_history'] = \Veer\Models\OrderHistory::select(\DB::raw('count(*) as orders_count, status_id'))->groupBy('status_id')->lists('orders_count', 'status_id'); app('veer')->loadedComponents['counted']['bills'] = \Veer\Models\OrderBill::select(\DB::raw('count(*) as orders_count, status_id'))->groupBy('status_id')->lists('orders_count', 'status_id'); return \Veer\Models\OrderStatus::orderBy('manual_order', 'asc')->paginate($paginateItems); }
/** * Get all veer shop statuses * @return object */ function statuses($flag = null) { if (empty($flag)) { return \Cache::remember('listOfStatuses', 0.5, function () { return \Veer\Models\OrderStatus::orderBy('manual_order', 'asc')->get(); }); } $statuses = $flag == "secret" ? \Veer\Models\OrderStatus::where($flag, '=', true) : \Veer\Models\OrderStatus::where('flag_' . $flag, '=', true); return \Cache::remember('listofStatuses-' . $flag, 0.5, function () use($statuses) { return $statuses->orderBy('manual_order', 'asc')->get(); }); }