public function edit($id) { $data = []; $data['article'] = ArticleCategory::with('articles')->get(); $data['content'] = \App\Doctor::find($id); $data['list_province'] = \App\Province::lists('name', 'id'); $data['list_city'] = \App\City::lists('name', 'id'); $data['list_specialization'] = \App\Specialization::lists('name', 'id'); $data['days'] = \App\Day::lists('name', 'id'); return view('frontend.pages.clinic.doctor-edit', compact('data')); }
public function search(Request $request) { $data = array(); $data['days'] = \App\Day::lists('name', 'id'); $data['article'] = ArticleCategory::with('articles')->get(); $data['city'] = \App\City::all(); $data['specialization'] = \App\Specialization::all(); $data['city_k'] = urldecode($request->input('city')); $data['specialization_k'] = urldecode($request->input('specialization')); $data['keyword'] = urldecode($request->input('keyword')); $data['gender_k'] = $request->input('gender'); $data['practice_day_k'] = $request->input('practice_day'); $data['city_obj'] = \App\City::where('name', 'like', '%' . $data['city_k'] . '%')->lists('id'); $arr_specialization = \App\Specialization::where('name', 'like', '%' . $data['specialization_k'] . '%')->lists('id'); /*$result = \App\Specialization::where('name','like','%'.$data['specialization_k'].'%') ->whereHas('doctors', function($query) use($data){ $query->whereIn('city_id', $data['city_obj']) ->where('name','like', '%'.$data['keyword'].'%') ->whereHas('day', function($query) use($data){ if(!empty($data['practice_day_k']) > 0) $query->whereIn('days.id', $data['practice_day_k']); }) ; if(!empty($data['gender_k'])){ $query->where('gender',$data['gender_k']); } })-> with('doctors')->get();*/ $result = \App\Doctor::whereIn('city_id', $data['city_obj'])->where('name', 'like', '%' . $data['keyword'] . '%')->whereHas('day', function ($query) use($data) { if (!empty($data['practice_day_k']) > 0) { $query->whereIn('days.id', $data['practice_day_k']); } }); if (!empty($data['gender_k'])) { $result->where('gender', $data['gender_k']); } $result = $result->paginate(10); $data['article'] = ArticleCategory::with('articles')->get(); $data['content'] = $result; return view('frontend.pages.home.search-result', compact('data')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(HomeFormRequest $request) { // SEARCH STUFF TO FIX. NEED TO REDIRECT TO ANOTHER PAGE AND SHOW RESULTS THERE. https://laracasts.com/lessons/search-essentials // $query = $request->get('q'); // $articles = $query // ? Article::search($query)->get() // : Article::all(); //LONGER WAY OF CODING // if ($query) // { // $articles = Article::where('lat', 'LIKE', "%$query%")->get(); // } // else // { // $articles = Article::all(); // } // $days = Day::lists('dayname', 'id'); // $categories = Category::lists('name', 'id'); // ADD ANY/ALL OPTION $days = array(8 => 'Any') + Day::lists('dayname', 'id')->toArray(); $categories = array(4 => 'All') + Category::lists('name', 'id')->toArray(); return view('home', compact('categories', 'days')); }
public function edit($id) { $article = Article::find($id); $deals = Deal::all()->lists('dealname', 'dayID'); $categories = Category::lists('name', 'id'); $days = Day::lists('dayname', 'id'); return view('articles.edit', compact('article', 'categories', 'days', 'deals')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $schedules = Schedule::find($id); $academicRegistrations = AcademicRegistration::lists('academic_year', 'id'); $programStudies = ProgramStudy::lists('name', 'id'); $courses = Course::lists('course_name', 'id'); $studies = Study::lists('study_name', 'id'); $lecturers = Lecturer::lists('name', 'id'); $days = Day::lists('day', 'id'); return view('dashboard.admin.schedule.edit', ['schedule' => $schedules, 'academicRegistration' => $academicRegistrations, 'programStudy' => $programStudies, 'course' => $courses, 'study' => $studies, 'lecturer' => $lecturers, 'day' => $days]); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // $data = array(); $data['content'] = \App\Doctor::find($id); $data['list_province'] = \App\Province::lists('name', 'id'); $data['list_city'] = \App\City::lists('name', 'id'); $data['list_specialization'] = \App\Specialization::lists('name', 'id'); $data['days'] = \App\Day::lists('name', 'id'); return view('pages.admin.doctor.edit')->with('data', $data); }
public function getCustomerPoint($action, $id) { $city_options = \App\City::lists('name', 'id'); $days_options = \App\Day::lists('name', 'id'); $status_options = ['active' => 'Activo', 'inactive' => 'Inactivo']; $type_options = ['agency' => 'Agencia', 'branch' => 'Sucursal', 'atm' => 'Cajero']; $product_options = \App\Product::where('status', 'active')->whereIn('type', ['important_product', 'product'])->lists('name', 'id'); return AdminItem::get_request('customer-point', $action, $id, $this, ['parent' => 'parent'], ['city_options' => $city_options, 'days_options' => $days_options, 'status_options' => $status_options, 'type_options' => $type_options, 'product_options' => $product_options]); }