public function now()
{
$history = LeaveRequest::with('user')->with('entitlement')->where('mgr_id', '=', 6)->orderBy('id', 'DESC')->take(20)->get();
return $history;
//$leaves = User::with('leaveRequest')->where('id', '=', 6)->get();
//return $leaves;
// return Config::get('systech.annual_start_date');
// $enrolls = Enroll::with('sassions')->orderBy('id', 'DESC')->take(10)->get();
/*$leaveSum = DB::table('leave_requests')->where('user_id', '=', 6)
->where('entitlement_id', '=', 1)->sum('no_of_days');
echo $leaveSum;
*/
}
public function showApproveRequest()
{
$userId = $this->getUserId();
$histories = LeaveRequest::with('user')->with('entitlement')->where('mgr_id', '=', $userId)->orderBy('id', 'DESC')->take(20)->get();
$leave_history = array();
foreach ($histories as $history) {
$row = array();
$row['id'] = $history['id'];
$row['user_id'] = $history['id'];
$row['no_of_days'] = $history['no_of_days'];
$row['from_date'] = $history['from_date'];
$row['to_date'] = $history['to_date'];
$row['status'] = $history['status'];
$user = $history['user'];
$row['user_name'] = $user['first_name'] . ' ' . $user['last_name'];
$ent = $history['entitlement'];
$row['entitlement_name'] = $ent['name'] . ' (' . $ent['no_of_days'] . ' days)';
$leave_history[] = $row;
}
return Response::jsend('success', $leave_history);
}