从助手函数内部识别调用它的控制器和方法

composer require spatie/backtrace

// helpers.php
use SpatieBacktraceBacktrace;
use SpatieBacktraceFrame as SpatieBacktraceFrame;
use IlluminateSupportFacadesStorage;
use IlluminateSupportFacadesAuth;

if (!function_exists('logDatabaseError')) {
    function logDatabaseError (IlluminateDatabaseQueryException $exception) {
        // 创建一个回溯实例
        $backtrace = Backtrace::create();

        // 过滤回溯帧，找到第一个继承自 AppHttpControllersController 的类
        $controllerResponsible = collect($backtrace->frames())
            ->filter(function (SpatieBacktraceFrame $frame) {
                return (bool) $frame->class; // 确保帧有类名
            })
            ->filter(function (SpatieBacktraceFrame $frame) {
                // 检查该类是否是控制器或其子类
                return is_subclass_of($frame->class, AppHttpControllersController::class);
            })
            ->first(); // 获取第一个匹配的控制器帧

        $log_string = "TIME: " . now()->toDateTimeString() . PHP_EOL;
        $log_string .= "User ID: " . (Auth::check() ? Auth::user()->id : 'Guest') . PHP_EOL;

        if ($controllerResponsible) {
            $log_string .= "Controller->Action: " . $controllerResponsible->class . "->" . $controllerResponsible->method . PHP_EOL;
        } else {
            $log_string .= "Controller->Action: Not found or not a Controller method" . PHP_EOL;
        }
        $log_string .= "Exception: " . $exception->getMessage() . PHP_EOL;
        $log_string .= "File: " . $exception->getFile() . " Line: " . $exception->getLine() . PHP_EOL;
        $log_string .= "Trace: " . $exception->getTraceAsString() . PHP_EOL; // 包含完整的异常堆栈

        Storage::disk('logs')->append('database.log', $log_string);
    }
}

// app/Http/Controllers/BestControllerEver.php
namespace AppHttpControllers;

use IlluminateHttpRequest;
use IlluminateSupportFacadesDB;
use IlluminateDatabaseQueryException;

class BestControllerEver extends Controller
{
    public function writeStuffToDatabase (Request $request) {
        try {
            // 模拟一个数据库操作，这里故意调用一个不存在的表来触发异常
            DB::table('my_unavailable_table')->get();
        }
        catch (QueryException $exception) {
            logDatabaseError($exception); // 助手函数会自动识别调用方
            return response()->json(['error' => 'Database operation failed.'], 500);
        }
        return response()->json(['message' => 'Data written successfully.']);
    }
}

composer require spatie/backtrace

// app/Exceptions/Handler.php
namespace AppExceptions;

use IlluminateFoundationExceptionsHandler as ExceptionHandler;
use Throwable;
use SpatieBacktraceBacktrace as SpatieBacktrace;
use SpatieBacktraceFrame as SpatieBacktraceFrame;

class Handler extends ExceptionHandler
{
    /**
     * 用于在 reportable 闭包和 context 方法之间传递控制器信息。
     * @var SpatieBacktraceFrame|null
     */
    public $controllerResponsible = null;

    /**
     * 不应报告的异常类型列表。
     *
     * @var array<int, class-string<Throwable>>
     */
    protected $dontReport = [
        //
    ];

    /**
     * 不应闪存到会话的输入字段列表。
     *
     * @var array<int, string>
     */
    protected $dontFlash = [
        'current_password',
        'password',
        'password_confirmation',
    ];

    /**
     * 注册异常处理回调。
     *
     * @return void
     */
    public function register()
    {
        $this->reportable(function (Throwable $e) {
            // 为异常创建回溯实例
            $backtraceInstance = SpatieBacktrace::createForThrowable($e);

            // 过滤回溯帧，找到第一个继承自 AppHttpControllersController 的类
            $controllerResponsible = collect($backtraceInstance->frames())
                ->filter(function (SpatieBacktraceFrame $frame) {
                    return (bool) $frame->class;
                })
                ->filter(function (SpatieBacktraceFrame $frame) {
                    return is_subclass_of($frame->class, AppHttpControllersController::class);
                })
                ->first();

            $this->controllerResponsible = $controllerResponsible; // 将结果存储到实例属性中
        });
    }

    /**
     * 获取用于日志记录的默认上下文变量。
     *
     * @return array<string, mixed>
     */
    protected function context()
    {
        $extraContext = [];

        // 如果找到了负责的控制器，则将其信息添加到上下文
        if ($this->controllerResponsible instanceof SpatieBacktraceFrame) {
            $extraContext['controller'] = $this->controllerResponsible->class;
            $extraContext['method'] = $this->controllerResponsible->method;
            $extraContext['controller@method'] = $this->controllerResponsible->class . '@' . $this->controllerResponsible->method;
        }

        // 合并父类的上下文和我们自定义的上下文
        return array_merge(parent::context(), $extraContext);
    }
}

// app/Http/Controllers/BestControllerEver.php
namespace AppHttpControllers;

use IlluminateHttpRequest;
use IlluminateSupportFacadesDB;

class BestControllerEver extends Controller
{
    public function writeStuffToDatabase (Request $request) {
        // 直接执行数据库操作，无需 try-catch 捕获 QueryException
        // 任何 QueryException 将被全局异常处理器捕获并处理
        DB::table('my_unavailable_table')->get();

        return response()->json(['message' => 'Data written successfully.']);
    }
}

[2023-10-27 10:30:00] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'your_database.my_unavailable_table' doesn't exist (Connection: mysql, SQL: select * from `my_unavailable_table`) {"exception":"[class]","file":"[path]","line":123,"controller":"App\Http\Controllers\BestControllerEver","method":"writeStuffToDatabase","controller@method":"App\Http\Controllers\BestControllerEver@writeStuffToDatabase"}