public function filter()
{
$filterStatus = Input::get('filterStatus');
if (Input::get('filterArrayType')) {
$filterArrayType = Input::get('filterArrayType');
} else {
$filterArrayType = array();
}
$q_finance = Finance::query();
if (count($filterArrayType) != 0) {
$q_finance = $q_finance->whereIn('type_of_funding', $filterArrayType);
}
if ($filterStatus != '0') {
$q_finance = $q_finance->where('status', '=', $filterStatus);
}
$q_sum = clone $q_finance;
$sum = $q_sum->sum('sum');
$finances = $q_finance->get();
return view('finance.tableRow', ['finances' => $finances, 'sum' => $sum]);
}
