/**
* 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);
}
