public function getFilterData()
{
$client_inn = Input::get('ClientInn');
$debtor_inn = Input::get('DebtorInn');
$active = Input::get('Active');
$noActive = Input::get('NoActive');
if (!empty($debtor_inn) || !empty($client_inn) || !empty($active)) {
$relations = Relation::query();
if ($active == 1) {
$relations->where('active', '=', 1);
}
if ($active == 2) {
$relations->where('active', '=', 0);
}
if (!empty($client_inn)) {
/* $relations->whereHas('client', function($query) use ($client_inn)
{
$query->where('inn', '=', $client_inn);
});
*/
$relations->where('client_id', '=', $client_inn);
}
if (!empty($debtor_inn)) {
/* $relations->whereHas('debtor',function($query) use ($debtor_inn)
{
$query->where('inn', '=', $debtor_inn);
});*/
$relations->where('debtor_id', '=', $debtor_inn);
}
$relations = $relations->get();
} else {
$relations = Relation::all();
}
return view('relations.table', ['relations' => $relations]);
}
