public function search()
{
$datas = MmcalculationModel::query();
$calculationSelection = Input::get('calculationSelection');
$calculationKeySearch = Input::get('calculationKeySearch');
Log::info("xx->" . Input::get('calculationSelection'));
$queryString = null;
if (Input::has('page')) {
// paging
Log::info("into paging");
$queryString = session()->get('calculation_keySearch');
} else {
if (Input::has('calculationKeySearch')) {
$queryString = Input::get('calculationKeySearch');
session()->put('calculation_keySearch', $calculationKeySearch);
}
if (!empty($calculationSelection)) {
session()->put('calculation_selection', $calculationSelection);
}
session()->put('calculation_keySearch', $queryString);
session()->put('calculation_selection', $calculationSelection);
}
$haveWhere = false;
if (!empty($queryString)) {
$datas = $datas->orWhere('B', 'LIKE', "%{$queryString}%")->orWhere('C', 'LIKE', "%{$queryString}%")->orWhere('D', 'LIKE', "%{$queryString}%");
$haveWhere = true;
}
if (!empty($calculationSelection)) {
if ($calculationSelection == '1') {
$datas = $datas->where('H', '=', session()->get('user_empId'));
} else {
if ($calculationSelection == '2') {
$datas = $datas->where('H', '!=', session()->get('user_empId'));
}
}
}
$datas = $datas->orderBy('updated_dt', 'DESC')->paginate(12);
return view('ais/design_calculation', ['lists' => $datas]);
}
