imo-tikuwa/cakephp-operation-logs

OperationLogs plugin for CakePHP

v2.0.1 2020-10-15 09:33 UTC

This package is auto-updated.

Last update: 2020-10-17 00:03:16 UTC


README

Installation

You can install this plugin into your CakePHP application using composer.

The recommended way to install composer packages is:

# for CakePHP4
composer require imo-tikuwa/cakephp-operation-logs "2.*"

# for CakePHP3
composer require imo-tikuwa/cakephp-operation-logs "1.*"

How to Use

Load plugin to bootstrap.php

// cakephp 3.6 or less
Plugin::load('OperationLogs', ['bootstrap' => true]);

// cakephp 3.7 or higher
Application::addPlugin('OperationLogs', ['bootstrap' => true]);

or Application.php

    public function bootstrap(): void
    {
        parent::bootstrap();

+        $this->addPlugin('OperationLogs', ['bootstrap' => true]);
    }

Execute the database table initialization command.
※Executing the command will delete & create operation_logs, operation_logs_hourly, operation_logs_daily, operation_logs_monthly tables.
※If you want to record up to microseconds, specify the --enable_micro option.

cake init_operation_logs

Append middleware to Application.php

use OperationLogs\Middleware\OperationLogsMiddleware;

    public function middleware($middlewareQueue)
    {
        $middlewareQueue
            // Add operation_logs middleware.
            ->add(new OperationLogsMiddleware([
                'exclude_urls' => [
                    '/debug-kit',
                    '/admin'
                ]
            ]))
            ;
        return $middlewareQueue;
    }

※If you want to log all requests without using the option, please replace with OperationLogsSimpleMiddleware middleware.

use OperationLogs\Middleware\OperationLogsSimpleMiddleware;

    public function middleware($middlewareQueue)
    {
        $middlewareQueue
            // Add operation_logs middleware.
            ->add(new OperationLogsSimpleMiddleware())
            ;
        return $middlewareQueue;
    }

Options.

option name option type default example memo
mode string 'exclude' 'include' Only 'exclude' and 'include' allowed
exclude_urls string array [ '/debug-kit' ] [ '/debug-kit', '/admin' ] Exclude with prefix match
exclude_ips string array [] [ '192.168', '::' ] Exclude with prefix match
exclude_user_agents string array [] [ 'Safari', 'Edge' ] Exclude with broad match
include_urls string array [] [ '/admin/top' ] Include with prefix match
include_ips string array [] [ '192.168.1.3' ] Include with prefix match
include_user_agents string array [] [ 'Firefox', 'Chrome' ] Include with broad match

※If 'mode' is 'exclude' the 'include_〇〇' option is ignored. (And vice versa)

Data summary commands.

daily_summaryコマンド、monthly_summaryコマンド、hourly_summaryコマンドがあります。
operation_logsテーブルのデータを元にクライアントIP、ユーザーエージェント、リクエストURLなどでグルーピングしたデータを集計します。

daily_summary command.

--target_ymdオプションで集計日を設定可能。
未指定のときは前日のデータを集計します。
データはoperation_logs_dailyテーブルに記録されます。

cake daily_summary --target_ymd=2020-02-13

monthly_summary command.

--target_ymオプションで集計年月を6桁の数字で設定可能。
未指定の時は先月のデータを集計します。
データはoperation_logs_monthlyテーブルに記録されます。

cake monthly_summary --target_ym=202002

hourly_summary command.

--target_ymdオプションで集計日を設定可能。
未指定の時は前日のデータを集計します。
1時間単位でデータを集計します。
データはoperation_logs_hourlyテーブルに記録されます。

cake hourly_summary --target_ymd=2020-02-13