| Application Routes |-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the controller to call when that URI is requested. | */ Route::get('/', ['as' => 'home', function () { Session::reflash(); // Dummy query to calculate rows \App\Models\Video::selectRaw('SQL_CALC_FOUND_ROWS videos.*')->filtered()->limit(0)->first(); // get actual count $id = \DB::select('SELECT FOUND_ROWS() c')[0]->c - 1; $id = mt_rand(0, $id); $video = \App\Models\Video::filtered()->skip($id)->first(); return redirect($video->id); }]); Route::get('messages', 'MessageController@page'); Route::get('user/{username}', 'UserController@show'); Route::get('user/{username}/favs', 'UserController@show_favs'); Route::get('user/{username}/comments', 'UserController@show_comments'); Route::get('logout', 'UserController@logout'); Route::post('login', 'UserController@login'); Route::get('register', 'UserController@create'); Route::post('register', 'UserController@store'); Route::get('activate/{token}', 'UserController@activate'); Route::get('index', 'VideoController@index'); Route::post('index/{id}', 'VideoController@update'); Route::get('upload', 'VideoController@create'); Route::get('categories', 'CategoryController@index');
/** * @param bool $category * @return Video */ public function getPrev($category = false) { if (!$category) { return Video::filtered()->where('id', '<', $this->id)->orderBy('id', 'DESC')->first(); } else { return Video::whereCategoryId($this->category->id)->where('id', '<', $this->id)->orderBy('id', 'DESC')->first(); } }