/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $children = Children::find($id); $members = Proposale::where('proposales.children_id', $id)->join('programs', 'proposales.program_id', '=', 'programs.id')->select('programs.title as program_title')->get(); $all_news = News::where('active', '=', '1')->get(); return view('user.edit_children', ['children' => $children, 'members' => $members, 'all_news' => $all_news]); }
public function all_proposales() { $user_id = Session::get('user_id'); $proposales = Proposale::where('proposales.user_id', '=', $user_id)->join('childrens', 'proposales.children_id', '=', 'childrens.id')->join('programs', 'proposales.program_id', '=', 'programs.id')->join('vacations', 'proposales.vacation_id', '=', 'vacations.id')->join('parts', 'proposales.part_id', '=', 'parts.id')->select('proposales.*', 'childrens.name as children_name', 'programs.title as program_name', 'vacations.start_date as program_start', 'vacations.finish_date as program_finish', 'parts.start_date as part_start', 'parts.finish_date as part_finish', 'childrens.application_form as application_form', 'childrens.id as children_id')->get(); $all_news = News::where('active', '=', '1')->get(); return view('user.proposales')->with('proposales', $proposales)->with('all_news', $all_news); }