diff --git a/src/app/Providers/AppServiceProvider.php b/src/app/Providers/AppServiceProvider.php index 0c010ec2..84b15482 100644 --- a/src/app/Providers/AppServiceProvider.php +++ b/src/app/Providers/AppServiceProvider.php @@ -1,109 +1,116 @@ sql, implode(', ', $query->bindings))); + \Log::debug( + sprintf( + '[SQL] %s [%s]: %.4f sec.', + $query->sql, + implode(', ', $query->bindings), + $query->time / 1000 + ) + ); }); } // Register some template helpers Blade::directive('theme_asset', function ($path) { $path = trim($path, '/\'"'); return ""; }); // Query builder 'withEnvTenant' macro Builder::macro('withEnvTenant', function (string $table = null) { $tenant_id = \config('app.tenant_id'); if ($tenant_id) { /** @var Builder $this */ return $this->where(($table ? "$table." : '') . 'tenant_id', $tenant_id); } /** @var Builder $this */ return $this->whereNull(($table ? "$table." : '') . 'tenant_id'); }); // Query builder 'withUserTenant' macro Builder::macro('withUserTenant', function (string $table = null) { $tenant_id = auth()->user()->tenant_id; if ($tenant_id) { /** @var Builder $this */ return $this->where(($table ? "$table." : '') . 'tenant_id', $tenant_id); } /** @var Builder $this */ return $this->whereNull(($table ? "$table." : '') . 'tenant_id'); }); // Query builder 'whereLike' mocro Builder::macro('whereLike', function (string $column, string $search, int $mode = 0) { $search = addcslashes($search, '%_'); switch ($mode) { case 2: $search .= '%'; break; case 1: $search = '%' . $search; break; default: $search = '%' . $search . '%'; } /** @var Builder $this */ return $this->where($column, 'like', $search); }); } }