public function get_events_by_category($cat)
{
if ($cat > 6) {
abort(404);
}
$status = Status::first();
if ($status->add_winners == 0) {
return EventDetails::where('grp', $cat)->select('event_name', 'event_description')->get()->toArray();
} else {
return EventDetails::where('grp', $cat)->get()->toArray();
}
}
public function findFeature()
{
// This method tests the functionality of the 'findFeature()' method of the ArcServer class.
// It will grab the first Status in the database and use it to retrieve the corresponding feature from the ArcGIS Server.
// This function also provides a sample of how to implement the ArcServer::findFeature() method in production.
$status = Status::first();
$response = ArcServer::findFeature($status);
echo "Looking for tailnumber: " . $status->statusable_name . "<br />\n";
if ($response === false) {
echo "An error prevented this query from completing";
// Log the error, if desired
} else {
// Success!
//The ArcGIS Server responded with an array of OBJECT_IDs, as expected (the array could be empty empty though)
echo "OBJECT_IDs => [" . implode(",", $response) . "]";
}
return;
}
/**
* Show the most recent Status for this Crew
*/
public function showCurrentStatus($id)
{
// Make sure this user is authorized...
if (Auth::user()->cannot('actAsAdminForCrew', $id)) {
// The current user does not have permission to perform admin functions for this crew
return redirect()->back()->withErrors("You're not authorized to access that crew!");
}
// Authorization complete - continue...
$status = Status::first();
$response = ArcServer::findFeature($status);
echo "Looking for tailnumber: " . $status->statusable_name . "<br />\n";
if ($response === false) {
echo "An error prevented this query from completing";
} else {
//This
echo "OBJECT_IDs => [" . implode(",", $response) . "]";
}
// Determine whether to redirect to a Crews Status Update form or an Aircraft Status Update form
// return "Showing most recent Status for Crew #".$id;
}
public function create_event()
{
if (\Auth::check()) {
$user = User::where('email', Session::get('email'))->first();
$data = Input::all();
//dd($data);
array_pop($data);
$rules = ['event_name' => 'required', 'file' => 'mimes:application/pdf'];
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
return Redirect::route('add_event')->withErrors($validator->errors())->withInput();
}
$event = new Events();
$event->society_email = $user->email;
if (sizeof(Events::all()) != 0) {
$event_count = Events::all()->last()->id + 1;
} else {
$event_count = 0;
}
$event->event_id = strtolower(substr($user->society, 0, 4)) . $event_count;
$eventdetails = new EventDetails();
$eventdetails->event_id = $event->event_id;
$eventdetails->event_name = $data['event_name'];
$eventdetails->event_description = json_encode($data['short_des']);
$eventdetails->long_des = json_encode($data['long_des']);
$eventdetails->rules = json_encode($data['rules']);
// rules n long des ke columns banenge
// n vo yahan par se vahan jayenge
if (Status::first()->add_events == 1) {
$data['timing'] = $data['date'] . " " . $data['time'];
$data['contact'] = array(array("name" => $data['contact_name1'], "number" => $data['contact_number1']), array("name" => $data['contact_name2'], "number" => $data['contact_number2']));
$data['prize_money'] = array($data['prize_money1'], $data['prize_money2']);
if (rtrim($data['timing']) != '' && strpos($data['timing'], 'undefined') === false) {
$tv = preg_split('/[- :]/', $data['timing']);
$d = mktime($tv[3], $tv[4], 0, $tv[1], $tv[2], $tv[0]);
$timestamp = date("Y-m-d h:i:s", $d);
$eventdetails->timing = $timestamp;
}
$eventdetails->contact = json_encode($data['contact']);
$eventdetails->prize_money = json_encode($data['prize_money']);
$eventdetails->approved = 0;
if (Input::file('file') != null && Input::file('file')->isValid()) {
$destinationPath = 'uploads';
// upload path
$extension = Input::file('file')->getClientOriginalExtension();
// getting image extension
$fileName = rand(11111, 99999) . '.' . $extension;
// renameing image
Input::file('file')->move($destinationPath, $fileName);
// uploading file to given path
$eventdetails->attachment = $fileName;
}
}
$event->save();
if ($eventdetails->save()) {
return Redirect::route('view_event');
} else {
Session::flash('success', '0');
return Redirect::back();
}
} else {
return Redirect::route('root');
}
}
public function add_soc_details($team, $id = -1, $redraw = 0)
{
$status = Status::first();
if (\Auth::check()) {
$societies = User::select('id', 'society', 'email')->get();
$user = User::where('email', Session::get('email'))->first();
$members = Members::where('soc_id', Session::get('email'))->where('type', $team)->get();
$members = $members->toArray();
foreach ($members as $key => $field) {
if ($members[$key]['events'] != '' && $members[$key]['events'] != null && $members[$key]['events'] != 'null') {
$x = EventDetails::where('event_id', $members[$key]['events'])->first();
if ($x != '') {
$members[$key]['events'] = EventDetails::where('event_id', $members[$key]['events'])->first()->event_name;
} else {
$members[$key]['events'] = '';
}
}
}
$disp_events = Events::where('society_email', Session::get('email'))->get()->pluck('event_id');
$disp_event_details = array();
foreach ($disp_events as $disp) {
$disp_event_details[] = EventDetails::where('event_id', $disp)->first();
}
if ($user->priviliges == 1) {
if ($id == -1) {
return \View::make('core_team', array('society' => $user->society, 'add_winners' => $status->add_winners, 'societies' => $societies, 'members' => $members, 'type' => $team, 'disp_events' => $disp_event_details, 'action' => 'Member Details', 'admin' => 1));
} else {
return Self::get_soc_mem_details($team, $id);
}
} else {
return \View::make('core_team', array('society' => $user->society, 'add_winners' => $status->add_winners, 'societies' => $societies, 'members' => $members, 'type' => $team, 'disp_events' => $disp_event_details, 'accessor' => $user->email, 'action' => 'Member Details', 'admin' => 0));
}
return Redirect::back();
}
return Redirect::route('root');
}
public function enable($what)
{
if (\Auth::check()) {
$user = User::where('email', Session::get('email'))->first();
if ($user->priviliges == 1) {
$status = Status::first();
if ($what == 0) {
$status->add_events = $status->add_events ? 0 : 1;
$status->save();
return $status->add_events;
} else {
if ($what == 1) {
$status->add_winners = $status->add_winners ? 0 : 1;
$status->save();
return $status->add_winners;
} else {
return 0;
}
}
}
}
}
