hortusfox-web/app/models/LogModel.php

<?php

/**
 * Class LogModel
 * 
 * Manages the system log
 */ 
class LogModel extends \Asatru\Database\Model {
    const LOG_MAX_STRING_LENGTH = 1024;

    /**
     * @param $user
     * @param $target
     * @param $property
     * @param $value
     * @param $link
     * @return void
     * @throws \Exception
     */
    public static function addLog($user, $target, $property, $value, $link = null)
    {
        try {
            if ((is_string($value)) && (strlen($value) >= self::LOG_MAX_STRING_LENGTH)) {
                $value = substr($value, 0, self::LOG_MAX_STRING_LENGTH - 4) . '...';
            }

            static::raw('INSERT INTO `@THIS` (user, target, property, value, link) VALUES(?, ?, ?, ?, ?)', [$user, $target, $property, $value, $link]);
        } catch (\Exception $e) {
            throw $e;
        }
    }

    /**
     * @param $user
     * @param $limit
     * @return array
     * @throws \Exception
     */
    public static function getHistory($user = null, $limit = 100)
    {
        try {
            $result = [];
            $history = null;

            if (($user) && (is_int($user))) {
                $history = static::raw('SELECT * FROM `@THIS` WHERE user = ? ORDER BY created_at DESC LIMIT ' . $limit, [$user]);
            } else {
                $history = static::raw('SELECT * FROM `@THIS` ORDER BY created_at DESC LIMIT ' . $limit);
            }

            foreach ($history as $entry) {
                $log_user = UserModel::getUserById($entry->get('user'));

                if ($log_user) {
                    $result[] = [
                        'user' => $log_user->get('name'),
                        'target' => $entry->get('target'),
                        'property' => $entry->get('property'),
                        'value' => $entry->get('value'),
                        'link' => $entry->get('link'),
                        'date' => $entry->get('created_at')
                    ];
                }
            }

            return $result;
        } catch (\Exception $e) {
            throw $e;
        }
    }
}