public function index()
{
$name = "Ivan";
$age = $_GET['age'];
$results = DB::getQueryLog();
var_dump($results);
exit;
return view("sites.sites")->with("name", $name)->with("age", $age);
}
/**
* 打印原生态sql
* @access protected
* @param boolean $needLog 是否要记录日志
* @return array
*/
protected function printRawSql($needLog = false)
{
$queries = \DB::getQueryLog();
$formattedQueries = [];
foreach ($queries as $query) {
$prep = $query['query'];
foreach ($query['bindings'] as $binding) {
$prep = preg_replace("#\\?#", $binding, $prep, 1);
}
$formattedQueries[] = $prep;
}
if ($needLog) {
\Log::info($formattedQueries);
}
return $formattedQueries;
}
protected function response($response)
{
if (Utils::isNinjaDev()) {
$count = count(\DB::getQueryLog());
Log::info(Request::method() . ' - ' . Request::url() . ": {$count} queries");
Log::info(json_encode(\DB::getQueryLog()));
}
$index = Request::get('index') ?: 'data';
if ($index == 'none') {
unset($response['meta']);
} else {
$meta = isset($response['meta']) ? $response['meta'] : null;
$response = [$index => $response];
if ($meta) {
$response['meta'] = $meta;
unset($response[$index]['meta']);
}
}
$response = json_encode($response, JSON_PRETTY_PRINT);
$headers = Utils::getApiHeaders();
return Response::make($response, 200, $headers);
}
public function testPermissions()
{
\DB::enableQueryLog();
$user = \Auth::user();
// $role = Role::create(['name' => 'test', 'slug' => 'test', 'description' => 'test']);
// $user->assignRole(Role::where('slug', 'test')->first());
// $user->revokeRole($role = Role::where('slug', 'test')->first());
// $role->delete();
dd([$user->getPermissions(), \DB::getQueryLog()]);
}
