@php $per_age = cache('CustomPagination')?->wishlist ?? Modules\GlobalSetting\app\Models\CustomPagination::where('section_name', 'Wishlist')->value('item_qty'); $userFavorites = userAuth() ->favoriteProducts() ->with('translation') ->withCount([ 'reviews as average_rating' => function ($query) { $query ->select(Illuminate\Support\Facades\DB::raw('coalesce(avg(rating), 0) as average_rating')) ->where('status', 1); }, 'reviews as reviews_count' => function ($query) { $query->where('status', 1); }, ]) ->withCount('order_products') ->active() ->paginate($per_age); @endphp