public function money()
{
$proposales = Proposale::join('childrens', 'proposales.children_id', '=', 'childrens.id')->join('programs', 'proposales.program_id', '=', 'programs.id')->select('proposales.*', 'childrens.name as children_name', 'childrens.surname as children_surname', 'childrens.id as children_id', 'programs.title as program_name')->get();
return view('admin.money')->with('proposales', $proposales);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$proposales = Proposale::join('childrens', 'proposales.children_id', '=', 'childrens.id')->join('users', 'proposales.user_id', '=', 'users.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', 'users.name as user_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', 'childrens.application_form as application_form')->orderBy('proposales.id', 'desc')->get();
$all_news = News::where('active', '=', '1')->get();
return view('admin.proposales')->with('proposales', $proposales)->with('all_news', $all_news);
}
