public function index(Request $request) { if ($request->ajax()) { $client_id = Input::get('filter-client'); $debtor_id = Input::get('filter-debtor'); $registry = Input::get('filter-registry'); $choice = Input::get('filter-choice'); $commissions = DailyChargeCommission::query(); $commissions->where('handler', true); if ($client_id != 0) { $commissions->whereHas('delivery', function ($q) use($client_id) { $q->where('client_id', '=', $client_id); }); } if ($debtor_id != 0) { $commissions->whereHas('delivery', function ($q) use($debtor_id) { $q->where('debtor_id', '=', $debtor_id); }); } if ($registry != 0) { $commissions->whereHas('delivery', function ($q) use($registry) { $q->where('registry', '=', $registry); }); } if ($choice != 0) { $before = Input::get('filter-before'); $after = Input::get('filter-after'); $arratBetween = [$before, $after]; if ($choice == 1) { $commissions->whereHas('delivery', function ($q) use($arratBetween) { $q->whereBetween('date_of_registry', $arratBetween); }); } elseif ($choice == 2) { $commissions->whereBetween('created_at', $arratBetween); } } $commissions = $commissions->get(); return view('reportRepayment.tableRow', ['commissions' => $commissions]); } else { $clients = Client::Where('active', true)->get(); $debtors = Debtor::all(); $debtors = Debtor::all(); $registries = ChargeCommission::Distinct('registry')->lists('registry'); return view('reportRepayment.index', ['clients' => $clients, 'debtors' => $debtors, 'registries' => $registries]); } }