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')); }