Class tracabilité

<?php
define('WATCHDOG_INFO', 1);
define('WATCHDOG_NOTICE', 2);
define('WATCHDOG_WARNING', 3);
define('WATCHDOG_ERROR', 4);
define('WATCHDOG_ALERT', 5);
define('WATCHDOG_URGENCY', 6);
 
class iJ_Provider_Watchdog {
    private $conn;
    
    public function __construct(){
        $this->conn = iJ_Core::instance()->conn;
    }
    
    public function log($severity, $type, $message, $location = '', $variables = ''){ 
        if(!$this->conn->hasError()){
            if(strtolower($location) === 'self')
                $location = $_SERVER['REQUEST_URI'];
                
            $watch = array(
            	'type' => $type,
            	'timestamp' => time(),
            	'message' => $message,
            	'location' => $location,
            	'hostname' => iJ_Core::instance()->request->getVisitorIP(),
            	'severity' => $severity,
            	'variables' => $variables,
            	'id_user' => (iJ_User::current() === NULL) ? 0 : iJ_User::current()->getId(),
            );
            
            $this->conn->insert('watchdog', $watch, FALSE);
        }        
    }
    
    public function getLogs($severity = NULL, $type = NULL, $limitstart = 0, $limitend = 25){
        $query = 'SELECT * FROM watchdog WHERE 1=1';
        
        if($severity !== NULL)
            $query .= ' AND severity='.intval($severity);
        
        if($type !== NULL)
            $query .= ' AND type="'.$this->conn->escapeString($type).'"';
        
        $query .= sprintf(' ORDER BY timestamp DESC LIMIT %d, %d', $limitstart, $limitend);
        $q = $this->conn->query($query);
        $watchs = array();
        while($watch = $this->conn->fetchArray($q)){
            $watch['icon'] = $this->getIcon($watch);
            array_push($watchs, $watch);
        }
        return $watchs;
    }
    
    public function getLogsBetween($timestamp1, $timestamp2){
        $q = $this->conn->queryf('SELECT * FROM watchdog WHERE timestamp BETWEEN %d AND %d', $timestamp1, $timestamp2);        
        $watchs = array();
        while($watch = $this->conn->fetchArray($q)){
            $watch['icon'] = $this->getIcon($watch);
            array_push($watchs, $watch);
        }
        return $watchs;
    }
    
    private function getIcon($watch){
        switch($watch['severity']){
            case WATCHDOG_INFO:
                return 'images/icons/watchdog_ok.png';
            case WATCHDOG_NOTICE:
                return 'images/icons/watchdog_notice1.png';
            case WATCHDOG_WARNING:
                return 'images/icons/watchdog_warning.png';
            case WATCHDOG_ERROR:
                return 'images/icons/watchdog_error.png';
            case WATCHDOG_ALERT:
                return 'images/icons/watchdog_error.png';
            case WATCHDOG_URGENCY:
                return 'images/icons/watchdog_error.png';
        }
        return 'images/icons/watchdog_warning.png';
    }
    
    public function getTypes(){
        return $this->conn->fetchAll('SELECT DISTINCT type FROM watchdog', TRUE);
    }
    
    public function deleteOldLogs($limit = 1000){
        $this->conn->queryf('DELETE FROM watchdog WHERE id_watchdog NOT IN (SELECT id_watchdog FROM watchdog ORDER BY timestamp DESC LIMIT 0, %d)', $limit);
    }
    
    public function deleteAllLogs(){
        $this->conn->query('DELETE FROM watchdog'); 
    }
}