<?php

class App_SystemLog_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Log';
    protected $_filterFields = ['ip', 'message'];

    public function clear($filter = [])
    {
        if (empty($filter)) {
            $this->_db->query('TRUNCATE ' . $this->_db->quoteIdentifier($this->_getTableName()));
        } else {
            $sql = 'DELETE FROM ' . $this->_db->quoteIdentifier($this->_getTableName())
                . ' WHERE ' . Qs_Db::getWhereSql($filter);
            $this->_db->query($sql);
        }
        return $this;
    }
}