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');
