public function add_group($id) { // //$retreats = \montserrat\Retreat::where('end','>',\Carbon\Carbon::today())->pluck('idnumber','title','id'); $retreats = \montserrat\Retreat::select(\DB::raw('CONCAT(idnumber, "-", title, " (",DATE_FORMAT(start_date,"%m-%d-%Y"),")") as description'), 'id')->where("end_date", ">", \Carbon\Carbon::today()->subWeek())->orderBy('start_date')->pluck('description', 'id'); $retreats->prepend('Unassigned', 0); $groups = \montserrat\Group::orderBy('title')->pluck('title', 'id'); $rooms = \montserrat\Room::orderby('name')->pluck('name', 'id'); $rooms->prepend('Unassigned', 0); $defaults['group_id'] = $id; $defaults['retreat_id'] = 0; $dt_today = \Carbon\Carbon::today(); $defaults['today'] = $dt_today->month . '/' . $dt_today->day . '/' . $dt_today->year; return view('registrations.add_group', compact('retreats', 'groups', 'rooms', 'defaults')); //dd($retreatants); }
public function add_group($group_id = 0) { // $staff = \montserrat\Contact::with('groups')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_STAFF); })->orderBy('sort_name')->pluck('sort_name', 'id'); $groups = \montserrat\Group::orderBy('title')->pluck('title', 'id'); $current_user = Auth::user(); $user_email = \montserrat\Email::whereEmail($current_user->email)->first(); $defaults['group_id'] = $group_id; if (empty($user_email->contact_id)) { $defaults['user_id'] = 0; } else { $defaults['user_id'] = $user_email->contact_id; } return view('touchpoints.add_group', compact('staff', 'groups', 'defaults')); }