public function favourites()
{
$fbUserId = \Session::get('fb_user_id');
if ($fbUserId) {
$query = Confession::join('favourites', 'confessions.confession_id', '=', 'favourites.confession_id')->where('favourites.fb_user_id', '=', $fbUserId)->orderBy('status_updated_at', 'DESC')->approved()->with('favourites')->with('categories');
if (intval(\Input::get('count')) == 0) {
$count = self::MAX_CONFESSION_COUNT;
} else {
$count = min(intval(\Input::get('count')), self::MAX_CONFESSION_COUNT);
}
if (\Input::get('timestamp')) {
$query->whereRaw('UNIX_TIMESTAMP(status_updated_at) <= ?', [\Input::get('timestamp')]);
}
$query->take($count);
if (intval(\Input::get('offset')) > 0) {
$query->skip(intval(\Input::get('offset')));
}
$confessions = $query->get();
foreach ($confessions as $confession) {
$confession->status_updated_at_timestamp = $confession->status_updated_at->timestamp;
$confession->getFacebookInformation();
}
return \Response::json(['success' => true, 'data' => ['confessions' => $confessions]]);
}
return \Response::json(['success' => false, 'errors' => ['User not logged in.']]);
}
