public function getPageData($route) { $sql = "select * from pages where name='" . $this->mysqli->escape_string($route) . "' limit 1"; $result = $this->mysqli->query($sql); if (!$result) { Files::addtolog(LOG_MYSQLI, $sql . '--->>>' . $this->mysqli->error); throw new Exception($this->mysqli->error); } else { if ($result->num_rows > 0) { $pageData = $result->fetch_assoc(); } else { ROUTE::status404(); } } return $pageData; }
Route::get('import/lists', function () { return view('import/lists'); }); Route::resource('lists', 'ListsController'); Route::resource('templates', 'TemplatesController'); Route::resource('campaigns', 'CampaignsController'); Route::get('/inbox', function () { if (Input::has("search")) { $query = Input::get("search"); $search = DB::select('select subject,id,recipient,sender,size,custom_id from email_sent WHERE subject LIKE "%' . $query . '%" Order By id DESC Limit 0,25'); return view('inbox')->with('search', $search)->with('query', $query); } else { $search = DB::select('select * from email_sent Order By id DESC LIMIT 50 '); return view('inbox')->with('search', $search); } }); ROUTE::get('single-message/{slug}', function ($slug) { $slug = DB::select('select * from mailer WHERE attach5="' . $slug . '"'); // select * from mon_cases where slug=$slug limit 1 return View::make('single-message')->with('slug', $slug); }); // Authentication routes... Route::get('auth/login', 'Auth\\AuthController@getLogin'); Route::post('auth/login', 'Auth\\AuthController@postLogin'); Route::get('auth/logout', 'Auth\\AuthController@getLogout'); // Registration routes... Route::get('auth/register', 'Auth\\AuthController@getRegister'); Route::post('auth/register', 'Auth\\AuthController@postRegister');
/* |-------------------------------------------------------------------------- | 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('/', function () { return view('welcome'); }); //teams ROUTE::get('/api/teams/getTeams', 'TeamController@getAllTeams'); ROUTE::get('/api/teams/getTeam/{id}', 'TeamController@getTeamById'); //conferences ROUTE::get('/api/conference/getConferences', 'ConferenceController@getAllConferences'); ROUTE::get('/api/conference/getTeamsByConference/{id}', 'ConferenceTeamController@getTeamsByConference'); //players ROUTE::get('/api/players/getAllPlayers', 'PlayerController@getAllPlayers'); ROUTE::get('/api/players/getPlayersByFirstName/{name}', 'PlayerController@getPlayersByFirstName'); ROUTE::get('/api/players/getPlayersByLastName/{name}', 'PlayerController@getPlayersByLastName'); ROUTE::get('/api/players/getPlayersByName/{first}/{last}', 'PlayerController@getPlayersByFullName'); ROUTE::get('/api/players/getPlayer/{id}', 'PlayerController@getPlayerById'); //stats ROUTE::get('/api/stats/getStatTypes', 'StatTypeController@getStatTypes'); ROUTE::get('/api/stats/getPlayerStats/{id}', 'CareerStatController@getPlayerStats'); ROUTE::get('/api/stats/getSpecificPlayerStat/{id}/{statId}', 'CareerStatController@getStat');
<?php Route::get('Medical-Marijuana-News', 'HomeController@index'); Route::get('contact-us', 'HomeController@index'); Route::get('faq', 'HomeController@index'); Route::get('Illinois-Medical-Marijuana-Information', 'HomeController@index'); Route::get('Medical-Marijuana-Strain-Guide', 'HomeController@index'); Route::get('Shop-420-Windy-City', 'HomeController@index'); Route::get('420-Windy-City-Medical-Marijuana-Blog', 'BlogFrontController@index'); ROUTE::get('420-Windy-City-Medical-Marijuana-Blog/{slug}', function ($slug) { $slug = DB::table('tb_blogs')->where('slug', $slug)->first(); return View::make('blogs.view')->with('slug', $slug); }); ROUTE::get('Medical-Marijuana-Strain-Guide/{slug}', function ($slug) { return View::make('strains.view')->with('slug', $slug); }); ROUTE::get('420-Windy-City-Medical-Marijuana-Blog/{category}', function ($slug) { $slug = DB::table('tb_blogs')->where('slug', $slug)->first(); return View::make('blogs.view')->with('slug', $slug); });
//BRAND Route::get('/brand/flag/{id}', ['as' => 'brand.flag', 'uses' => 'BrandController@flag']); //PURCHASE Route::get('/purchase/category/{category_id}/{provider_id?}/', ['as' => 'purchase.category.index', 'uses' => 'PurchaseController@categoryIndex']); Route::get('/purchase/brand/{id}/{provider_id?}', ['as' => 'purchase.brand.index', 'uses' => 'PurchaseController@brandIndex']); Route::get('/purchase/provider/{id}', ['as' => 'purchase.provider.index', 'uses' => 'PurchaseController@providerIndex']); Route::get('/purchase/product/{id}', ['as' => 'purchase.product.index', 'uses' => 'PurchaseController@productIndex']); Route::get('/purchase/search/{string}', ['as' => 'purchase.search.index', 'uses' => 'PurchaseController@searchIndex']); Route::get('/purchase/label/{id}', ['as' => 'purchase.label.index', 'uses' => 'PurchaseController@labelIndex']); Route::get('/purchase/flag/', ['as' => 'purchase.flag.index', 'uses' => 'PurchaseController@flagIndex']); Route::get('/purchase/filter/{category_id?}/{brand_id?}/{provider_id?}', ['as' => 'purchase.filter.index', 'uses' => 'PurchaseController@filterIndex']); Route::get('/purchase/delete/{purchase_id}/{products_id}', ['as' => 'purchase.delete', 'uses' => 'PurchaseController@delete']); //CURRENCY Route::get('/currency/delete/{string}', ['as' => 'currency.delete', 'uses' => 'CurrencyController@delete']); //LABELS ROUTE::get('/label/delete/{id}', ['as' => 'label.delete', 'uses' => 'LabelController@delete']); Route::get('/label/flag/{id}', ['as' => 'label.flag', 'uses' => 'LabelController@flag']); //FILTER Route::post('/filter/request', ['as' => 'filter.request', 'uses' => 'FilterController@ajax']); //Route::resource('import', 'ImportController'); Route::resource('/settings', 'SettingsController'); Route::resource('/user', 'UserController'); Route::resource('/note', 'NoteController'); Route::resource('/currency', 'CurrencyController'); Route::resource('/file', 'FileController'); Route::resource('/category', 'CategoryController'); Route::resource('/product', 'ProductController'); Route::resource('/provider', 'ProviderController'); Route::resource('/history', 'HistoryController'); Route::resource('/brand', 'BrandController'); Route::resource('/purchase', 'PurchaseController');