public function postIndex(Request $request)
{
$nls = $request->input('nls');
$messages = array('required' => Lang::get('book.nls_required'), 'numeric' => Lang::get('book.nls_numeric'));
$v = Validator::make($request->all(), Geng::$rules['nls'], $messages);
if ($v->fails()) {
return redirect()->back()->withInput()->withErrors($v->errors());
} else {
$user_info = Geng::where('nls', '=', $nls);
if ($user_info->count()) {
Session::put('nls', $nls);
return Redirect('/input/pokaz');
} else {
return redirect()->back()->withInput()->withErrors(['nls' => Lang::get('book.nls')]);
}
}
}
public function Adres(Request $request)
{
$street = $request->input('street');
if (Input::has("nd")) {
$dom = $request->input('nd');
} else {
$dom = $request->input('house');
}
$korp = $request->input('nkor');
$results = Geng::where('ul', '=', $street)->where('nd', '=', $dom)->where('nkor', '=', $korp)->get();
if ($results->isEmpty()) {
Session::flash('msg', 'Не найдено');
return redirect('/admin/card');
}
if ($results->count() == 1) {
$results = Geng::join('schet', 'g_eng.nls', '=', 'schet.nls')->join('mar_sh', 'mar_sh.tip', '=', 'schet.tip')->select('g_eng.nls', 'fio', 'data_of', 'propis', 'ul', 'nd', 'nkor', 'nkw', 'nkw1', 'chas', 'kom', 'telefon', 'telefons', 'telefonr', 'dat_vv', 'n_chet', 'dat_ust', 'god_v', 'plomba', 'nazw', 'pr_f', 'dat_gp', 'g_eng.tar', 'ktp', 'uch', 'inn', 'ntehusl', 'dtehusl')->where('ul', '=', $street)->where('nd', '=', $dom)->where('nkor', '=', $korp)->first();
$oborots = Oborot::selectRaw('god,mes,kol_lim,n_pok,DATE_FORMAT(data_n,"%d.%m.%y") as data_n,k_pok,DATE_FORMAT(data_k,"%d.%m.%y") as data_k,potr,summa,prim,prim,n_pok_n,k_pok_n,n_pok_n2,k_pok_n2,tar')->where('nls', $results->nls)->where('DAT_k', '>=', date("Y-m-d", strtotime("-6 month")))->Orderby('dat_k')->get();
return View::make('admin.agreement', compact('results', 'oborots'));
}
return View::make('admin.list', compact('results'));
}
