<?php

namespace App\Logging;

use Monolog\Logger;
use Illuminate\Support\Facades\DB;
use Monolog\Handler\AbstractProcessingHandler;

class MySQLLoggingHandler extends AbstractProcessingHandler
{
  public function __construct($level = Logger::DEBUG, $bubble = true)
  {
    $this->table = 'logs';
    parent::__construct($level, $bubble);
  }

  protected function write(array $record): void
  {
    $data = array(
      'type'       => $record['message'], // role
      'context'       => json_encode($record['context']), // message
      'level'         => $record['level'], // URL
      'level_name'    => $record['level_name'], // Method
      'channel'       => $record['channel'],
      'record_datetime' => $record['datetime']->format('Y-m-d H:i:s'),
      'extra'         => json_encode($record['extra']),
      'formatted'     => $record['formatted'],
      'remote_addr'   => $_SERVER['REMOTE_ADDR'],
      'user_agent'    => $_SERVER['HTTP_USER_AGENT'],
      'created_at'    => date("Y-m-d H:i:s"),
    );
    DB::connection()->table($this->table)->insert($data);
  }
}