/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$lastPosts = Post::latest()->take(2)->get();
$lastEvents = Event::latest()->take(2)->get();
$lastEvents2 = Event::latest()->skip(2)->take(2)->get();
return view('welcome')->with('lastPosts', $lastPosts)->with('lastEvents', $lastEvents)->with('lastEvents2', $lastEvents2);
}
public function postFinancialStatus(Request $request)
{
$data = $request->all();
$latest = FinancialStatus::latest('created_at')->first();
$event_id = Event::latest('id')->first()->id;
$head_id = Head::where('event_id', $event_id)->where('position', 'Finance Committee Head')->first()->id;
$data['weekly_income'] = $data['cash_in'] - $data['cash_out'];
$data['cash_in_hand'] = $latest->cash_in_hand + $data['weekly_income'];
$data['target_budget'] = $latest['target_budget'];
$data['event_id'] = $event_id;
$data['head_id'] = $head_id;
FinancialStatus::create($data);
return redirect("/");
}
public function getIndex()
{
$users = User::all();
$user = $this->getUser();
$curr_event = Event::latest('id')->first();
$all_comm = Committee::all();
$committees = Committee::where('event_id', $curr_event->id)->get();
$comm_array = Committee::where('event_id', $curr_event->id)->get(array('id'))->toArray();
$events = Event::all();
$tasks = Task::where('assigned_to', $user['id'])->whereIn('comm_id', $comm_array)->get();
//tasks assigned to current user
$all_tasks = Task::all();
$categories = array('Pending', 'In-progress', 'Delayed', 'Finished');
$comments = Comment::all();
//get current event id
$curr_event_id = $curr_event->id;
//check if current user is upper head
//get all heads of current event
$heads = Head::where('event_id', $curr_event_id)->where('user_id', $user->id)->get();
//get all comm_id(as array) in the current event where current user is a head
$heads_comm = Head::where('event_id', $curr_event_id)->where('user_id', $user['id'])->get(array('comm_id'))->toArray();
//members of committee
$mem = Member::whereIn('comm_id', $heads_comm)->get(array('user_id'))->toArray();
$members = User::whereIn('id', $mem)->get();
//get all committees in the current event where current user is a head
$head_committees = Committee::whereIn('id', $heads_comm)->get();
//current user is a head
$heads_comm = Head::where('user_id', $user['id'])->get();
//committees where current user is a member
$mem_comm = Member::where('user_id', $user['id'])->get();
$url = "pages/profile";
//check if curret user is admin
if ($user->id == 1) {
return redirect('/admin/');
}
//check if current user is OAH
if ($curr_event->oah_id == $user->id) {
$url = "pages/oah";
}
//return heads page if user is lower head
if ($heads != "[]") {
$url = "pages/heads";
}
if ($user->standing == "unconfirmed") {
$url = "pages/oops";
}
return view($url, compact('users', 'user', 'events', 'curr_event', 'all_comm', 'committees', 'tasks', 'all_tasks', 'categories', 'comments', 'head_committees', 'heads_comm', 'mem_comm', 'members'));
}
function getTask()
{
$user = \Auth::user();
$events = Event::all();
$event = Event::latest('id')->first();
$tasks = Task::all();
$categories = array('Pending', 'In-progress', 'Delayed', 'Finished');
//Array of head->id of user
$heads_comm = Head::where('event_id', $event->id)->where('user_id', $user->id)->get(array('comm_id'))->toArray();
//members of committee
$mem = Member::whereIn('comm_id', $heads_comm)->get(array('user_id'))->toArray();
$members = User::whereIn('id', $mem)->get();
//committees where user is head
$committees = Committee::whereIn('id', $heads_comm)->get();
return view('pages/task', compact('user', 'members', 'events', 'event', 'committees', 'tasks', 'categories'));
}
public function getBalance()
{
$user = \Auth::user();
$curr_event = Event::latest('id')->first();
$is_head = Head::where('event_id', $curr_event->id)->where('user_id', $user->id)->first();
if ($is_head->position == "Finance Committee Head") {
$is_head = true;
} else {
$is_head = false;
}
if (!$is_head) {
return redirect("/");
}
$users = User::where('standing', 'active')->oldest('lname')->get();
return view('pages/finance', compact('user', 'users'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$events = Event::latest()->get();
return view('events.events', compact('events'));
}
private function currentEvent()
{
return Event::latest('id')->first();
}
public function events()
{
$events = Event::latest('date')->get();
$steminars = Steminar::latest('date')->get();
return view('main.events', compact('events', 'steminars'));
}
/**
* get all users in a list for a select box
* @return mixed
*/
public function getList()
{
return $this->model->latest('created_at')->lists('name', 'id');
}
public function index()
{
$events = Event::latest()->where('name', 'settle')->paginate(20);
return view('admin.credit.settle.index', compact('events'))->with(['title' => 'Settlement Management']);
}
/**
* List all the current events
*
* @return $this
*/
public function index()
{
// Get all the events
$events = Event::latest()->published()->get();
return view('events.index')->with('events', $events);
}
public function team()
{
$lastSliders = Slider::latest()->take(1)->get();
$lastPosts = Post::latest()->take(2)->get();
$lastEvents = Event::latest()->take(2)->get();
$title = 'Equipo';
$lastEvents2 = Event::latest()->skip(2)->take(2)->get();
return view('guest.team')->with('title', $title)->with('lastPosts', $lastPosts)->with('lastEvents', $lastEvents)->with('lastEvents2', $lastEvents2)->with('lastSliders', $lastSliders);
}
/**
* Store a newly created event in the events table.
*
* @param \Illuminate\Http\Request $input
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$messages = ['date_format' => 'The start time does not match the format HH:MM:SS'];
//Validates the input from the create event page
$this->validate($request, ['name' => 'required|max:40', 'venue' => 'required|max:30', 'city' => 'required|max:30', 'price' => 'required|numeric', 'information' => 'required|max:255', 'description' => 'required', 'capacity' => 'required|numeric', 'date' => 'required|date', 'start_time' => 'required|date_format:H:i:s', 'end_time' => 'required|date_format:H:i:s', 'image' => 'image|required'], $messages);
//adds all the data from the create events page to the database in the events table
$name = $request->input('name');
$venue = $request->input('venue');
$city = $request->input('city');
$price = $request->input('price');
$information = $request->input('information');
$description = $request->input('description');
$capacity = $request->input('capacity');
$date = $request->input('date');
$start_time = $date . ' ' . $request->input('start_time');
$end_time = $date . ' ' . $request->input('end_time');
$image = 'image';
echo $end_time;
Event::create(['name' => $name, 'venue' => $venue, 'city' => $city, 'price' => $price, 'information' => $information, 'description' => $description, 'capacity' => $capacity, 'date' => $start_time, 'end_time' => $end_time, 'image' => $image]);
//gets the id of the event above and concats it to the file extension of the image uploaded.
$name = Event::latest()->first()->id . "." . Input::file('image')->getClientOriginalExtension();
//gets the event ID and concat on the imaage file extension that was uploaded
//moves and renames the image selected from a temp directory to the event_images folder as
Input::file('image')->move(public_path() . '/img/event_images', $name);
//moves the uploaded image from the tmp directory to a premanant one (/public/img/event_images) and renames it to <eventID>.<fileExt>
$image = Event::latest()->first();
//returns the latest event added to the table (the one just added above)
$image->image = $name;
//adds the image name from above to the image column of the latest event
$image->save();
//saves the above action
return redirect('events');
//redirects to events view when finished
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$events = Event::latest('date')->paginate(10);
return view('cp.events.index', compact('events'));
}