Thinktomorrow\Chief\Mediagallery\Http\MediagalleryController::index()

Complexity

Conditions	4
Paths	8

Size

Total Lines	40
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function index(Request $request)
    {
        $search = $request->input('search', false);
        $unused = $request->input('unused', false);
        $owner = $request->input('owner', false);

        $assets = Asset::with('media')->orderBy('created_at', 'DESC')->select('assets.*');

        if ($search) {
            $assets->whereHas('media', function (Builder $query) use ($search) {
                $query->where('file_name', 'LIKE', '%' . $search . '%');
            });
        }

        if ($unused) {
            $assets->whereNotExists(function ($query) {
                $query->select(DB::raw(1))
                    ->from('asset_pivots')
                    ->whereRaw('asset_pivots.asset_id = assets.id')
                    ->where('asset_pivots.unused', 0);
            });
        }

        if($owner){
            $owner = FlatReferenceFactory::fromString($owner)->instance();
            $modelAssets = collect();
            $modelAssets = $modelAssets->merge($owner->assets());

            $owner->children()->each(function($module) use($modelAssets){
                $modelAssets = $modelAssets->merge($module->assets());

The assignment to $modelAssets is dead and can be removed.

            });

            $assets->whereIn('id', $modelAssets->pluck('id'));
        }

        $assets = $assets->paginate(20);

        $pages = UrlHelper::allOnlineModels();

        return view('chief::back.mediagallery.index', compact('assets', 'pages'));
    }