CMS-CSE/core/class/historique.class.php

<?php

class historique
{
    public static function getAll() {
        db::query("SELECT "
                . "" . DB_T_HISTORIQUE . ".id, "
                . "" . DB_T_HISTORIQUE . ".idUser ,"
                . "CONCAT (" . DB_T_USER . ".prenom, ' ', " . DB_T_USER . ".nom) AS 'user' ,"
                . "" . DB_T_HISTORIQUE . ".idPage, "
                . "" . DB_T_HISTORIQUE . ".log, "
                . "" . DB_T_HISTORIQUE . ".addDate "
                . "FROM " . DB_T_HISTORIQUE . " "
                . "INNER JOIN " . DB_T_USER . " ON " . DB_T_HISTORIQUE . ".idUser = " . DB_T_USER . ".id ");
        return db::resultset();
    }

    public static function getByPage(string $_idPage) {
        db::query("SELECT "
                . "" . DB_T_HISTORIQUE . ".id, "
                . "" . DB_T_HISTORIQUE . ".idUser ,"
                . "CONCAT (" . DB_T_USER . ".prenom, ' ', " . DB_T_USER . ".nom) AS 'user' ,"
                . "" . DB_T_HISTORIQUE . ".log, "
                . "" . DB_T_HISTORIQUE . ".addDate "
                . "FROM " . DB_T_HISTORIQUE . " "
                . "INNER JOIN " . DB_T_USER . " ON " . DB_T_HISTORIQUE . ".idUser = " . DB_T_USER . ".id "
                . "WHERE " . DB_T_HISTORIQUE . ".idPage = :idPage");
        db::bind(':idPage', $_idPage);
        return db::resultset();
    }

    public static function getByUser(int $_idUser) {
        db::query("SELECT "
                . "" . DB_T_HISTORIQUE . ".id, "
                . "" . DB_T_HISTORIQUE . ".idPage, "
                . "" . DB_T_HISTORIQUE . ".log, "
                . "" . DB_T_HISTORIQUE . ".addDate "
                . "FROM " . DB_T_HISTORIQUE . " "
                . "WHERE " . DB_T_HISTORIQUE . ".idUser = :idUser");
        db::bind(':idUser', $_idUser);
        return db::resultset();
    }

    private static function add(array $_input){
        db::query("INSERT INTO " . DB_T_HISTORIQUE . " (idUser, idPage, log) VALUES (:idUser, :idPage, :log)");
        db::bind(':idUser', $_input["idUser"]);
        db::bind(':idPage', $_input["idPage"]);
        db::bind(':log', $_input["log"]);
        try {
            db::execute();
        } catch (Exception $ex) {
            alert::recError("Erreur lors de l'enregistrement de l'historique");
        }
    }

    public static function recordLogs(){
        if(session::isConnect() AND (alert::getSuccess() OR alert::getWarning() OR alert::getError())){
            $log = NULL;

            if(alert::getSuccess()){
                foreach (alert::getSuccess() as $value) { 
                    $log .= "[success] " . $value . "\r\n";
                }
            }
            
            if(alert::getWarning()){
                foreach (alert::getWarning() as $value) { 
                    $log .= "[warning] " . $value . "\r\n";
                }
            }

            if(alert::getError()){
                foreach (alert::getError() as $value) { 
                    $log .= "[error] " . $value . "\r\n";
                }
            }

            $logs = array(
                "idUser" => session::getId(),
                "idPage" => $_SERVER["REQUEST_URI"],
                "log" => $log
            );

            self::add($logs);
        }
    }
}