public function mailing_list($year = "_") { if ($year == "_" || $year == Year::current_year()->year) { $year_alias = ""; } else { $year_alias = '.' . Year::where('year', '=', $year)->select('alias')->first()->alias; } return $this->alias . $year_alias . '@cserevue.org.au'; }
public function get_user_status($user_id) { $user = DB::table('team_user')->where('team_id', '=', $this->id)->where('user_id', '=', $user_id)->where('year_id', '=', Year::current_year()->id)->first(); $status = ''; if ($user != NULL) { $status .= $user->status; } return $status; }
public function get_manage($id) { $executive = Executive::find($id); $year = Year::current_year(); $users = array(); foreach ($year->users as $a) { $users[] = $a->profile->full_name; } return View::make('executives.manage')->with('executive', $executive)->with('users', $users)->with('year', $year); }
public function post_edit() { $input = Input::get(); $camp = CampSetting::where('year_id', '=', Year::current_year()->id); $camp_reg = DB::table('camp_registrations')->where('camp_setting_id', '=', $camp->first()->id)->where('user_id', '=', Auth::user()->id); $rules = array('id' => 'required', 'car_places' => 'integer'); $validation = Validator::make($input, $rules); if ($validation->passes()) { $camp_reg->update(Input::except('_token')); return Redirect::to('rms/camp/registrations/edit')->with('success', 'Successfully Edited registration for Camp'); } else { return Redirect::to('rms/camp/registrations/edit')->withErrors($validation)->withInput(); } }
public function get_admin($current = 'current') { if ($current == 'current') { $year = Year::current_year(); } else { $year = Year::find($current); } if ($year) { $orders = MerchOrder::where('year_id', '=', $year->id)->get(); $items = MerchItem::current_merch(); $sizes = array('8' => '8', '10' => '10', '12' => '12', '14' => '14', 'XS' => 'XS', 'S' => 'S', 'M' => 'M', 'L' => 'L', 'XL' => 'XL', 'XXL' => 'XXL'); return View::make('merch.orders.admin')->with('orders', $orders)->with('items', $items)->with('sizes', $sizes)->with('year', $year); } else { return "Invalid ID"; } }
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 static function current_bundles() { return WellbeingBundle::where('year_id', '=', Year::current_year()->id); }
public static function current_nights() { return WellbeingNight::where('year_id', '=', Year::current_year()->id); }
$team_id = Request::segment(4); $team = Team::find($team_id); if (!Auth::User()->admin && !Auth::User()->is_currently_part_of_exec() && $team->privacy == 1 && !Auth::User()->is_part_of_team(Year::current_year()->id, $team_id)) { return Redirect::to('rms/account')->with('warning', 'You are not permitted access. Please login as an admin'); } }); Route::filter('manage_team', function () { $team_id = Request::segment(4); if (!Auth::User()->can_manage_team($team_id)) { return Redirect::to('rms/account')->with('warning', 'You are not permitted access. Please login as an admin'); } }); Route::filter('signed_up_for_camp', function () { if (Auth::user()->has_signed_up_for_camp()) { return Redirect::to('rms/camp/registrations/edit'); } }); Route::filter('orgs', function () { $on_orgs = false; $teams = DB::table('teams')->where('privacy', '=', '0')->lists('id'); foreach ($teams as $team) { $count = DB::table('team_user')->where('team_id', '=', $team)->where('year_id', '=', Year::current_year()->id)->where('status', '=', 'head')->where('user_id', '=', Auth::User()->id)->get(); if (count($count) != 0) { $on_orgs = true; break; } } if (!Auth::User()->admin && !Auth::User()->is_currently_part_of_exec() && !$on_orgs) { return Redirect::to('rms/account')->with('warning', 'You are not permitted access. Please login as an admin'); } });
public function get_delete() { $id = Auth::User()->wellbeing_orders_year(Year::current_year()->id)->first()->id; $order = WellbeingOrder::find($id); $order->nights()->detach(); $order->bundles()->detach(); $order->delete(); return Redirect::to('rms/wellbeing/orders/')->with('success', 'Successfully Cancelled Order'); }
public function getSponsors() { $year = Year::current_year(); $sponsors = $year->sponsors()->orderBy('sponsor_year.sponsor_level', 'desc')->get(); return View::make('home.sponsors')->with('year', $year)->with('sponsors', $sponsors); }
public function can_manage_team($team_id) { if ($this->admin || $this->is_currently_part_of_exec()) { return true; } else { $team = Team::find($team_id); $result = $team->users()->where('users.id', '=', $this->id)->where('status', '=', 'head')->where('year_id', '=', Year::current_year()->id)->get(); return count($result) != 0; } }
public static function current_orders() { return WellbeingOrder::where('year_id', '=', Year::current_year()->id); }
public function post_renew() { $user = Auth::user(); $year = Year::current_year(); if ($user->needs_to_renew) { $user->years()->attach($year->id); return Redirect::to('rms/account')->with('success', 'You succesfully renewed'); } else { return Redirect::to('rms/account')->with('warning', 'You didn\'t need to renew'); } }
public function get_member_leave_ajax($team_id) { $user = Auth::User(); $user->teams()->where('team_id', '=', $team_id)->where('year_id', '=', Year::current_year()->id)->first()->pivot->delete(); return View::make('teams.index.ajax')->with('data', 'Leave Successful')->with('state', 'success'); }