1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- <?php
- namespace App\Providers;
- use Illuminate\Support\Facades\DB;
- use Illuminate\Support\Facades\Log;
- use Illuminate\Support\ServiceProvider;
- use Dcat\Admin\Layout\Content;
- class AppServiceProvider extends ServiceProvider
- {
- /**
- * Register any application services.
- *
- * @return void
- */
- public function register()
- {
- //添加自定义辅助函数
- require_once __DIR__.'/../helpers.php';
- //自定义内容
- $newContent = new Content();
- $newContent->view('admin.layouts.content');
- $this->app->singleton(Content::class, function () use ($newContent) {
- return $newContent;
- });
- }
- /**
- * Bootstrap any application services.
- *
- * @return void
- */
- public function boot()
- {
- //把SQL输出到日志中
- if ($this->app->environment('local')) { // 仅在本地环境启用
- DB::listen(function ($query) {
- // 格式化 SQL 语句
- $sql = $query->sql;
- foreach ($query->bindings as $binding) {
- $sql = preg_replace('/\?/', "'" . addslashes($binding) . "'", $sql, 1);
- }
- // 输出到控制台
- //dump($sql . ' [' . $query->time . 'ms]');
- //输出到log
- Log::info($sql . ' [' . $query->time . 'ms]');
- });
- }
- }
- }
|