/** * Display the specified resource. * * @param Request $request * @return \Illuminate\Http\Response */ public function search(Request $request) { $query = DB::table('teachers')->join('users', 'teachers.id', '=', 'users.id')->join('teacher_topic', 'teacher_topic.teacher_id', '=', 'teachers.id')->join('topics', 'topics.id', '=', 'teacher_topic.topic_id')->join('subjects', 'subjects.id', '=', 'topics.subject_id')->join('grades', 'grades.id', '=', 'subjects.grade_id')->join('qualifications', 'qualifications.teacher_id', '=', 'teachers.id')->select('users.id', 'users.name', 'users.picture', 'users.gender', 'qualifications.college', 'qualifications.degree', 'users.introduction', 'teachers.rating', 'teachers.rating_count', 'teachers.minfees')->where('teachers.display', '=', 1); if ($request->search !== null && $request->search !== '') { $query->where('users.name', 'LIKE', '%' . $request->search . '%')->orWhere('topics.name', 'LIKE', '%' . $request->search . '%')->orWhere('subjects.name', 'LIKE', '%' . $request->search . '%')->orWhere('grades.name', 'LIKE', '%' . $request->search . '%'); } $teachers = $query->distinct()->groupBy('name')->get(); $results = count($teachers); if ($request->search && empty($teachers)) { $query = DB::table('teachers')->join('users', 'teachers.id', '=', 'users.id')->join('qualifications', 'qualifications.teacher_id', '=', 'teachers.id')->select('users.id', 'users.name', 'users.picture', 'users.gender', 'qualifications.college', 'qualifications.degree', 'users.introduction', 'teachers.rating', 'teachers.rating_count', 'teachers.minfees')->where('teachers.display', '=', 1); $teachers = $query->distinct()->groupBy('name')->get(); } //var_dump($results); //var_dump($request->search); //echo "<pre>";print_r($teachers);echo "</pre>"; $request->flashOnly('search'); $topIds = [76, 272, 230, 128, 52, 38, 181, 43]; foreach ($teachers as $key => $teacher) { if (in_array($teacher->id, $topIds)) { unset($teachers[$key]); array_unshift($teachers, $teacher); } } //foreach ($teachers as $key => $teacher) { echo $teacher->picture."<br>"; } return view('frontend.teachers', ['teachers' => $teachers, 'page' => 'teachers', 'results' => $results]); }
public function postLogin(Request $request) { $request->flashOnly('email'); $this->validate($request, ['email' => 'required', 'password' => 'required']); $credentials = $request->only('email', 'password'); if (Auth::attempt($credentials, $request->has('remember'))) { return redirect()->intended($this->redirectPath()); } return redirect('/auth/login')->withInput($request->only('email'))->withErrors(['email' => '用戶名或密碼錯誤!']); }
/** * Show the form for creating a new resource. * * @param Request $request * @return \Illuminate\Http\Response */ public function find(Request $request) { $givenname = $request->input('givenname'); $surname = $request->input('surname'); $request->flashOnly('givenname', 'surname'); $holderQuery = Holder::with('animals.medications')->where('givenname', 'LIKE', $givenname)->orWhere('surname', 'LIKE', $surname); $holderSql = $holderQuery->toSql(); $holder = $holderQuery->first(); return view('home.index', ['holder' => $holder, 'sql' => $holderSql]); }
/** * Get all daftar barang by divisi * * @return Response * @author Y.Brahmantyo A.K **/ public function getSearchBarang(Request $request) { $divisi = divisi::all(); $arrdivisi = []; foreach ($divisi as $d) { $arrdivisi[$d->iddivisi] = $d->nama; } $barang = barang::where('namadet', 'like', '%' . $request->input('search') . '%')->paginate(Config::get('pages')); $request->flashOnly('search'); return view('admin.master.barang.index')->with('barang', $barang)->with('arrdivisi', $arrdivisi); }
/** * Get Daftar Stock * * @return Response * @author Y.Brahmantyo A.K **/ public function getIndex(Request $request) { $stock = stock::selectRaw('sup.nama AS supplier,stock.plu,mb.namadet AS nmbarang,SUM(stock.qtyunitsisa) qtyunit,stu.namasatuan satunit,SUM(stock.qtypjgsisa) qtypjg,stp.namasatuan satpjg,SUM(stock.qtybrtsisa) qtybrt,stb.namasatuan satbrt')->leftJoin('mbarang AS mb', 'mb.plu', '=', 'stock.plu')->leftJoin('msupplier AS sup', 'sup.idsupp', '=', 'mb.idsup')->leftJoin('msatuan AS stu', 'stu.idsatuan', '=', 'mb.satunit')->leftJoin('msatuan AS stp', 'stp.idsatuan', '=', 'mb.satpjg')->leftJoin('msatuan AS stb', 'stb.idsatuan', '=', 'mb.satbrt'); if (!empty($request->input('p'))) { $search = $request->input('p'); $stock = $stock->where('sup.nama', 'like', '%' . $search . '%')->orWhere('stock.plu', 'like', '%' . $search . '%')->orWhere('mb.namadet', 'like', '%' . $search . '%'); } $stock = $stock->groupBy('stock.plu')->paginate(\Config::get('pages')); $request->flashOnly('p'); return view('admin.report.stock')->with('stock', $stock); }
/** * Run the validation check, will call laravels validator. * * @return boolean */ public function check() { if ($this->preCheck() === false) { return false; } $this->lastValidator = $this->validation->make($this->getInput(), $this->getRules(), $this->getFailedMessages()); if ($this->lastValidator->fails()) { $this->request->getSessionStore()->flash('errors', $this->lastValidator->getMessageBag()); $this->request->flashOnly(array_keys($this->selectInput(false))); return false; } return true; }
/** * Flash only some of the input to the session. * * @param array|mixed $keys * @return void * @static */ public static function flashOnly($keys) { \Illuminate\Http\Request::flashOnly($keys); }
/** * 登录 */ public function login(Request $request) { // get option if ($request->isMethod('get')) { //如果已登录跳转到管理首页 if ($request->session()->has('admin_id')) { session()->flash('msg_success', '请勿重复登录'); return redirect('/admin'); } return view('admin.login'); } if (!$request->isMethod('post')) { App::abort(404); } // post option $sUsername = trim($request->input('username', null)); $sPassword = trim($request->input('password', null)); $validate = $this->login_validator(['username' => $sUsername, 'password' => $sPassword]); $temp_admin = Admin::where('username', $sUsername)->select('id')->get(); $admin_id = isset($temp_admin[0]) ? $temp_admin[0]->id : 0; unset($temp_admin); if ($validate->fails() || !$admin_id) { session()->flash('msg_error', '账号或密码错误'); $request->flashOnly('username'); return back(); } $oAdminLoginLog = new AdminLoginLog(); $login_ip = ip2long($_SERVER['REMOTE_ADDR']); $login_time = time(); // 禁止短时间内错误的登录次数过多 $timeline = strtotime("-5 minutes"); if (AdminLoginLog::where('created_at', '>', date("Y-m-d H:i:s", $timeline))->where('admin_id', $admin_id)->where('log_status', '0')->count() > 3) { session()->flash('msg_error', '登录失败次数过多,请稍后再试'); $request->flashOnly('username'); return back(); } $sPassword = md5($sPassword . md5($sPassword)); $admin = Admin::where('username', $sUsername)->where('password', $sPassword)->first(); // 账号密码错误 if (!$admin) { $oAdminLoginLog->admin_id = $admin_id; $oAdminLoginLog->log_ip = $login_ip; $oAdminLoginLog->log_status = 0; // 失败 $oAdminLoginLog->save(); session()->flash('msg_error', '账号或密码错误'); $request->flashOnly('username'); return back(); } // session中存入id $request->session()->put('admin_id', $admin->id); $request->session()->put('username', $admin->username); // login ip && time update $admin->login_ip = $login_ip; $admin->login_time = $login_time; $admin->save(); // 更新管理员登录记录表 $oAdminLoginLog->admin_id = $admin->id; $oAdminLoginLog->log_ip = $login_ip; $oAdminLoginLog->log_status = 1; // 成功 $oAdminLoginLog->save(); // 登录成功 session()->flash('msg_error', '登录成功'); return redirect('/admin'); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request, $id) { $input = $request->all(); if (array_key_exists('selected-tags', $input)) { $this->snippet->where('id', $id)->update(['title' => $input['title'], 'body' => $input['body']]); // スニペットにタグを紐付ける $snippet = Snippet::find($id); $snippet->tags()->detach(); $snippet->tags()->attach($input['selected-tags']); return redirect()->to("/snippet/{$id}"); } else { \Session::flash('snippetFormError', '必ずタグを選択してください'); $request->flashOnly('title', 'body'); return redirect()->back()->withInput(); } }