public function insc() { $materials = Material::orderBy('title')->get(); $activitiesNotInsc = Activity::orderBy('name')->get(); $activitiesInsc = Activity::orderBy('name')->get(); return view('activitiesmaterial', compact('materials', 'activNotInsc', 'activInsc'))->with('material', 'materialS'); }
function packageSelectedIndex(Request $request) { //dd($request->input('idP')); $id_package = $request->input('idP'); $activities = Activity::orderBy('name')->get(); $packagesactivities = Package::join('packagesActivities', 'packages.id', '=', 'packagesActivities.id_package')->select('packagesActivities.*', 'packages.*')->where('packagesActivities.id_package', '=', $id_package)->get(); $packages = Package::orderBy('name')->get(); return view('package', compact('activities', 'packagesactivities', 'packages')); }
public function subscribing() { $activities = Activity::orderBy('name')->get(); $id_activity = '1'; $partSubscribed = ActivityParticipant::join('participants', 'activitiesparticipants.id_participant', '=', 'participants.id')->select('participants.name as pName', 'participants.cpf', 'participants.type', 'activitiesparticipants.role_participant')->where('activitiesparticipants.id_activity', '=', $id_activity)->orderBy('pName')->get(); $partNotSubscribed = Participant::WhereNotIn('id', function ($query) use($id_activity) { $query->select('id_participant')->from('activitiesparticipants')->where('id_activity', '=', $id_activity); })->orderBy('name')->get(); $speakers = ActivityParticipant::join('participants', 'activitiesparticipants.id_participant', '=', 'participants.id')->select('participants.name as pName', 'participants.cpf', 'participants.type', 'activitiesparticipants.role_participant')->where('activitiesparticipants.id_activity', '=', $id_activity)->where('activitiesparticipants.role_participant', '=', 'speaker')->orderBy('pName')->get(); $judges = ActivityParticipant::join('participants', 'activitiesparticipants.id_participant', '=', 'participants.id')->select('participants.name as pName', 'participants.cpf', 'participants.type', 'activitiesparticipants.role_participant')->where('activitiesparticipants.id_activity', '=', $id_activity)->where('activitiesparticipants.role_participant', '=', 'judge')->orderBy('pName')->get(); $responsability = "Palestrantes"; return view('lista.atividade', compact('activities', 'partSubscribed', 'partNotSubscribed', 'speakers', 'judges', 'responsability')); }
public function programacaoPage() { $activities = Activity::orderBy('start', 'startTime')->get(); $types = Activity::getTypes(); return view('site.site_programacao', compact('activities', 'types')); }