public function get_search($format = '.html') { $input = Input::get(); $years = Year::lists('year', 'id'); if (array_key_exists('q', $input) && $input['q'] != '') { $q = $input['q']; $year_id = $input['y']; $year = Year::find($year_id)->year; if (strlen($q) > 8) { $phone_query = $q; } else { $phone_query = 'NOTAPHONENUMBER'; } if (preg_match("/^[_a-z0-9-]+(\\.[_a-z0-9+-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,})\$/i", $q)) { $email_query = $q; } else { $email_query = 'NOTANEMAILADDRESS'; } $results = User::join('profiles', 'users.id', '=', 'profiles.user_id')->join('user_year', 'users.id', '=', 'user_year.user_id')->where('year_id', '=', $year_id)->where(function ($query) use($q, $email_query, $phone_query) { $query->orWhere('full_name', 'LIKE', '%' . $q . '%'); $query->orWhere('display_name', 'LIKE', '%' . $q . '%'); $query->orWhere('email', 'LIKE', '%' . $email_query . '%'); $query->orWhere('phone', 'LIKE', '%' . $phone_query . '%'); })->get(); } else { $q = ''; $year = Year::current_year()->year; $results = array(); } switch ($format) { case '.csv': return View::make('users.search_csv')->with('results', $results); default: return View::make('users.search')->with('query', $q)->with('year', $year)->with('years', $years)->with('results', $results); } }
public function get_edit($id) { $years = Year::lists('year', 'id'); $camp = CampSetting::find($id); return View::make('camp.settings.edit')->with('camp', $camp)->with('years', $years); }
public function get_remove_from_year($id) { $sponsor = Sponsor::find($id); $years = Year::lists('year', 'id'); return View::make('sponsors.remove_from_year')->with('sponsor', $sponsor)->with('years', $years); }
public function get_edit($id) { $years = Year::lists('year', 'id'); $bundle = WellbeingBundle::find($id); return View::make('wellbeing.bundles.edit')->with('years', $years)->with('bundle', $bundle); }
public function get_edit($id) { $night = WellbeingNight::find($id); $years = Year::lists('year', 'id'); return View::make('wellbeing.nights.edit')->with('night', $night)->with('years', $years); }