User.class.php

<?php
    class User extends Model {
        // ===========
        // = Statics =
        // ===========
        public static function tryLogin($login) {
            return new static();
        }

        protected static $table_name = 'USER';

        public static function create($post) {
            parent::exec('USER_CREATE', [':firstname' => $post->firstname,
                                         ':lastname' => $post->lastname,
                                         ':login' => $post->login,
                                         ':avatar' => $post->avatar,
                                         ':avatar_url' => $post->avatar_url,
                                         ':email' => $post->email,
                                         ':password' => $post->password,
                                         ':role' => $post->role]);
        }

        public static function getList() {
            $stm = parent::exec('USER_GET_LIST');
            return $stm->fetchAll();
        }

        public static function getWithId($id) {
            $stm = parent::exec('USER_GET_WITH_ID', [':id' => $id]);
            return $stm->fetch();
        }

        public static function getWithLogin($login) {
            $stm = parent::exec('USER_GET_WITH_LOGIN', [':login' => $login]);
            return $stm->fetch();
        }

        public static function update($put, $id) {
            parent::exec('USER_UPDATE', [
                ':firstname' => $put->firstname, 
                ':lastname' => $put->lastname, 
                ':login' => $put->login, 
                ':password' => $put->password, 
                ':email' => $put->email, 
                ':role' => $put->role, 
                ':id' => $id]);
        }

        public static function delete($id) {
            parent::exec('USER_DELETE', [':id' => $id]);
        }
    }
?>