Collection Filter and Merge

collection_filter_and_merge.php

<?php 
public function list(Request $request)
{
  $filtering = new Collection;

        Expenditure::with('type', 'concept', 'store')
            ->chunk(200, function ($listExpenditures) use (&$filtering, $request) {

                if ($request->has('startDateRange') && $request->has('endDateRange')) {
                    $startDate = Carbon::createFromFormat('Y-m-d', $request->input('startDateRange'));
                    $endDate = Carbon::createFromFormat('Y-m-d', $request->input('endDateRange'));
                    $listExpenditures = $listExpenditures->filter(function ($expenditure) use ($startDate, $endDate) {
                        if ($expenditure->emited->between($startDate, $endDate)) {
                            return true;
                        }
                    });
                }

                if ($request->has('type')) {
                    $listExpenditures = $listExpenditures->filter(function ($expenditure) use ($request) {
                        if ($expenditure->type_id == $request->input('type')) {
                            return true;
                        }
                    });
                }

                if ($request->has('store')) {
                    $listExpenditures = $listExpenditures->filter(function ($expenditure) use ($request) {
                        if ($expenditure->store_id == $request->input('store')) {
                            return true;
                        }
                    });
                }

                if ($request->has('concept')) {
                    $listExpenditures = $listExpenditures->filter(function ($expenditure) use ($request) {
                        if ($expenditure->concept_id == $request->input('concept')) {
                            return true;
                        }
                    });
                }

                $filtering = $filtering->merge($listExpenditures);
            });
}