public static function getVideo($id) { $video = DB::table('videos AS v')->join('users AS u', 'v.user_id', '=', 'u.id')->where('v.id', $id)->select(array('*', 'v.id AS video_id', 'v.creation_date AS video_creation_date'))->first(); $video->time_interval = calculate_time_period($video->video_creation_date); $video->video_view_count = show_view_count($video->video_view_count); $video->view_count = show_view_count($video->view_count); return $video; }
public static function getPhoto($id) { $photo = DB::table('photos AS p')->join('users AS u', 'p.user_id', '=', 'u.id')->join('files AS f', 'f.parent_id', '=', 'p.id')->where('p.id', $id)->select(array('*', 'p.id AS photo_id', 'p.creation_date AS photo_creation_date'))->first(); $photo->time_interval = calculate_time_period($photo->photo_creation_date); $photo->photo_view_count = show_view_count($photo->photo_view_count); $photo->view_count = show_view_count($photo->view_count); return $photo; }