/**
* Retrieves statistics of user activity for past months for user dashboard.
*
* @param \Illuminate\Http\Request $request
* @return JSON array with each month's hours and total hours and rank
*/
public function graphInformation(Request $request)
{
if ($request->get('token') != null) {
$authenticatedUser = JWTAuth::setToken($request->get('token'))->authenticate();
$id = $authenticatedUser->volunteer_id;
$volunteer = Volunteer::findOrFail($id);
// four months
$activitiesWithinFrame = Activity::completed()->subMonth(3)->lists('activities.activity_id');
$fourMonthsUserList = Task::whereIn('activity_id', $activitiesWithinFrame)->where('volunteer_id', $id)->where('status', 'completed')->lists('activity_id');
if ($fourMonthsUserList->isEmpty()) {
$fourMonthsAgo = 0;
} else {
$fourMonthsAgo = Activity::whereIn('activity_id', $fourMonthsUserList)->sum('expected_duration_minutes');
$fourMonthsAgo = floor($fourMonthsAgo / 60);
}
// three months
$activitiesWithinFrame = Activity::completed()->subMonth(2)->lists('activities.activity_id');
$threeMonthsUserList = Task::whereIn('activity_id', $activitiesWithinFrame)->where('volunteer_id', $id)->where('status', 'completed')->lists('activity_id');
if ($threeMonthsUserList->isEmpty()) {
$threeMonthsAgo = 0;
} else {
$threeMonthsAgo = Activity::whereIn('activity_id', $threeMonthsUserList)->sum('expected_duration_minutes');
$threeMonthsAgo = floor($threeMonthsAgo / 60);
}
// two months
$activitiesWithinFrame = Activity::completed()->subMonth(1)->lists('activities.activity_id');
$twoMonthsUserList = Task::whereIn('activity_id', $activitiesWithinFrame)->where('volunteer_id', $id)->where('status', 'completed')->lists('activity_id');
if ($twoMonthsUserList->isEmpty()) {
$twoMonthsAgo = 0;
} else {
$twoMonthsAgo = Activity::whereIn('activity_id', $twoMonthsUserList)->sum('expected_duration_minutes');
$twoMonthsAgo = floor($twoMonthsAgo / 60);
}
// one months
$activitiesWithinFrame = Activity::completed()->subMonth(0)->lists('activities.activity_id');
$oneMonthsUserList = Task::whereIn('activity_id', $activitiesWithinFrame)->where('volunteer_id', $id)->where('status', 'completed')->lists('activity_id');
if ($oneMonthsUserList->isEmpty()) {
$oneMonthAgo = 0;
} else {
$oneMonthAgo = Activity::whereIn('activity_id', $oneMonthsUserList)->sum('expected_duration_minutes');
$oneMonthAgo = floor($oneMonthAgo / 60);
}
$rankid = Volunteer::where('volunteer_id', $id)->value('rank_id');
$rank = Rank::findOrFail($rankid)->name;
$totalHours = $volunteer->minutes_volunteered;
$totalHours = floor($totalHours / 60);
return response()->json(compact('fourMonthsAgo', 'threeMonthsAgo', 'twoMonthsAgo', 'oneMonthAgo', 'rank', 'totalHours'));
} else {
$status = ["Missing parameter"];
return response()->json(compact('status'));
}
}
