public function showHome()
{
$todaysDate = Carbon::now();
$event = CalendarEvent::where('date', '>', $todaysDate)->get()->random();
// dd($event);
$categoryId = $event->category_id;
$category = Category::where('id', '=', $categoryId)->first();
$group = Group::with('categories')->where('group_name', '<>', '')->get()->random();
return View::make('index')->with(array('event' => $event, 'group' => $group, 'category' => $category));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$event_page = CalendarEvent::find($id);
$events = CalendarEvent::where('category_id', '=', $event_page->category_id)->where('id', '!=', $event_page->id)->get();
if (!$event_page) {
Session::flash('errorMessage', 'The user does not exist');
App::abort(404);
// return View::make('errors.register');
}
return View::make('events.show')->with(array('events' => $events, 'event_page' => $event_page));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
/*CalendarEvent is the Class name in CalendarEvent model*/
$query = new CalendarEvent();
$search = Input::get('search');
if (Input::has('search')) {
$query->where('title', 'like', '%' . $search . "%")->orWhere('description', 'like', '%' . $search . "%");
/* ->orWhereHas('tag', function($q) use ($name){
$q->where('name', 'like', '%' . $search . "%")
}*/
/* ->orWhereHas('user', function($q) use ($search){
$q->where('first_name', 'like', '%' . $search . "%")
->orWhere('last_name', 'like', '%' . $search . "%");
});*/
}
//display a listing of calendar events
$calendar_events = $query->orderBy('start_date_time', 'desc')->paginate(10);
$calendar_events = $query->get();
/*->orderBy('start_date_time', 'desc')->paginate(10)
// dd($calendar_events);
/* compact() is a PHP function. It creates an array containing variables and their values*/
return View::make('calendar_events.index', compact('calendar_events'));
/*return View::make('calendar_events.index')->with('calendar_events', $calendar_events);*/
}
/**
* Display the specified resource.
* GET /users/{id}
*
* @param int $id
* @return Response
*/
public function show($id)
{
$events = CalendarEvent::where('user_id', '=', $id)->get();
$user = User::find($id);
return View::make('users.otherProfile', compact('events', 'user'));
}
/**
* Login user with facebook
*
* @return void
*/
public function loginWithFacebook()
{
// get data from input
$code = Input::get('code');
// get fb service
$fb = OAuth::consumer('Facebook');
// check if code is valid
// if code is provided get user data and sign in
if (!empty($code)) {
// This was a callback request from facebook, get the token
$token = $fb->requestAccessToken($code);
// Send a request with it
$result = json_decode($fb->request('/me?fields=id,name,email'), true);
$email = $result['email'];
$userId = User::where('email', '=', $email)->first()->id;
$user = User::find($userId);
$groups = Group::where('user_id', '=', $user->id)->get();
$events = CalendarEvent::where('user_id', '=', $user->id)->get();
Auth::login($user);
return View::make('users.show')->with(array('user' => $user, 'groups' => $groups, 'events' => $events));
} else {
// get fb authorization
$url = $fb->getAuthorizationUri();
// return to facebook login url
return Redirect::to((string) $url);
}
}
public function approveSelected()
{
$wingman_id = $_SESSION['user_id'];
$data = Input::get('submit_value');
if (is_array($data)) {
foreach ($data as $datapoint) {
$fragments = explode('/', $datapoint);
$student_id = $fragments[0];
$month = $fragments[1];
$year = $fragments[2];
$calendar_event = CalendarEvent::where('student_id', '=', $student_id)->get();
$wingman_id = DB::table('propel_student_wingman')->select('wingman_id')->where('student_id', '=', $student_id)->first();
foreach ($calendar_event as $event) {
$monthCurr = date('n', strtotime($event->start_time));
$yearCurr = date('Y', strtotime($event->start_time));
$status = $event->status;
if ($monthCurr == $month && $yearCurr == $year && $status != 'cancelled') {
$event->status = 'approved';
$event->save();
}
}
}
}
return Redirect::to(URL::to('/calendar/approve-calendar/'));
}
public function showCenterReport($city_id, $center_id)
{
$cities = City::where('id', '<=', '25')->orderby('name', 'ASC')->get();
$centers = Center::where('city_id', '=', $city_id)->where('status', '=', 1)->orderby('name', 'ASC')->get();
$tables = DB::table('Student')->join('propel_student_wingman as B', 'Student.id', '=', 'B.student_id')->join('User as C', 'C.id', '=', 'B.wingman_id')->join('Center as D', 'D.id', '=', 'Student.center_id')->join('City as E', 'E.id', '=', 'D.city_id');
$child_data = $tables->select('Student.id as id', 'Student.name as name', 'C.name as wingman_name', 'D.id as center_id', 'D.name as center_name', 'E.name as city_name', 'E.id as city_id')->distinct()->where('E.id', '=', $city_id)->orderby('D.name', 'ASC')->where('D.id', '=', $center_id)->get();
//$child_data = $tables->select('Student.name as name','C.name as wingman_name','D.id as center_id','D.name as center_name','E.name as city_name','E.id as city_id','F.id','F.id as journal_count','G.id as event_count')->distinct()->where('E.id','=',$city_id)->where('F.type','=','child_feedback')->orderby('D.name','ASC')->get(); //Test Query
$child_data = (array) $child_data;
$total = array();
$total['wingman_session_count'] = 0;
$total['asv_session_count'] = 0;
$total['journal_count'] = 0;
foreach ($child_data as $child) {
$calendarEvent = CalendarEvent::where('student_id', '=', $child->id)->where('status', '<>', 'cancelled')->where('type', '=', 'wingman_time')->get();
$child->wingman_session_count = count($calendarEvent);
$total['wingman_session_count'] += $child->wingman_session_count;
$calendarEvent = DB::table('propel_calendarEvents as A')->join('propel_wingmanTimes as B', 'A.id', '=', 'B.calendar_event_id')->where('A.student_id', '=', $child->id)->where('A.status', '=', 'attended')->get();
$child->wingman_module_attended = count($calendarEvent);
$calendarEvent = CalendarEvent::where('student_id', '=', $child->id)->where('status', '<>', 'cancelled')->where('type', '=', 'volunteer_time')->get();
$child->asv_session_count = count($calendarEvent);
$total['asv_session_count'] += $child->asv_session_count;
$journalEntry = WingmanJournal::where('student_id', '=', $child->id)->where('type', '=', 'child_feedback')->get();
$child->journal_count = count($journalEntry);
$total['journal_count'] += $child->journal_count;
}
return View::make('reports.child-report.city-report')->with('child_data', $child_data)->with('cities', $cities)->with('city_id', $city_id)->with('centers', $centers)->with('center_id', '0')->with('total', $total);
}
