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'));
}
