boka3/include/User.php

<?php
class User extends Entity {
    private $id = 0;
    private $name = '';
    private $notes = '';
    private $created = 0;

    public static function create_user($name) {
        $ins_user = prepare('insert into `user`(`name`) values (?)');
        bind($ins_user, 's', $name);
        execute($ins_user);
        return new User($ins_user->insert_id);
    }

    public function __construct($clue, $type = 'id') {
        parent::__construct();
        $find = null;
        switch($type) {
            case 'id':
                $find = prepare('select `id` from `user` where `id`=?');
                bind($find, 'i', $clue);
                break;
            case 'name':
                $find = prepare('select `id` from `user` where `name`=?');
                bind($find, 's', $clue);
                break;
            default:
                throw new Exception('Invalid type');
        }
        execute($find);
        $result = result_single($find);
        if(!$result) {
            throw new Exception("Invalid username '$clue'");
        }
        $this->id = $result['id'];
        $this->update_fields();
    }

    private function update_fields() {
        $get = prepare('select * from `user` where `id`=?');
        bind($get, 'i', $this->id);
        execute($get);
        $user = result_single($get);
        $this->name = $user['name'];
        $this->notes = $user['notes'];
        $this->created = $user['created'];
        return true;
    }

    public function matches($terms, $ldap) {
        $matches = array();
        foreach($terms as $term) {
            // Iterate over the terms
            $matched = false;
            $key = $term->get_key();
            switch($key) {
                case 'name':
                    // If the key is name, check username and displayname
                    $name = $this->get_name();
                    if(match_term($term, $name)) {
                        $matches['name'] = $name;
                        $matched = true;
                    }
                    $dname = $this->get_displayname($ldap);
                    if(match_term($term, $dname)) {
                        $matches['displayname'] = $dname;
                        $matched = true;
                    }
                    break;
                case 'note':
                    // If the key is note, check it.
                    $note = $this->get_note();
                    if($note && match_term($term, $note)) {
                        $matches['note'] = $note;
                        $matched = true;
                    }
                    break;
                case 'email':
                    $email = $this->get_email($ldap, false);
                    if($email && match_term($term, $email)) {
                        $matches['email'] = $email;
                        $matched = true;
                    }
                    break;
                case 'fritext':
                    //Check everything if the key is fritext
                    $name = $this->get_name();
                    if(match_term($term, $name)) {
                        $matches['name'] = $name;
                        $matched = true;
                    }
                    $dname = $this->get_displayname($ldap);
                    if(match_term($term, $dname)) {
                        $matches['displayname'] = $dname;
                        $matched = true;
                    }
            }
            if($term->is_mandatory() && !$matched) {
                return array();
            }
            if($term->is_negative() && $matched) {
                return array();
            }
        }
        return $matches;
    }

    public function get_displayname($ldap) {
        try {
            return $ldap->get_user($this->name);
        } catch(Exception $e) {
            return i18n('Not in SUKAT');
        }
    }

    public function get_email($ldap, $format = true) {
        try {
            return $ldap->get_user_email($this->name);
        } catch(Exception $e) {
            if($format) {
                return i18n('Email address missing');
            }
            return false;
        }
    }

    public function get_id() {
        return $this->id;
    }

    public function get_creation_time() {
        return $this->created;
    }

    public function get_name() {
        return $this->name;
    }

    public function set_name($newname) {
        $update = prepare('update `user` set `name`=? where `id`=?');
        bind($update, 'si', $newname, $this->id);
        execute($update);
        $this->name = $newname;
        return true;
    }

    public function get_notes() {
        return $this->notes;
    }

    public function set_notes($newnotes) {
        $update = prepare('update `user` set `notes`=? where `id`=?');
        bind($update, 'si', $newnotes, $this->id);
        execute($update);
        $this->notes = $newnotes;
        return true;
    }

    public function get_loans($type = 'both') {
        $statement = "select `id` from `event`
                      left join `loan` on `event`.`id` = `loan`.`event`
                      where
                          `type`='loan' and `user`=?";
        switch($type) {
            case 'active':
                $statement .= ' and `returntime` is null';
                break;
            case 'inactive':
                $statement .= ' and `returntime` is not null';
                break;
            case 'both':
                break;
            default:
                $err = "$type is not a valid argument. Valid arguments are active, inactive, both.";
                throw new Exception($err);
                break;
        }
        $statement .= ' order by `starttime` desc';
        $get = prepare($statement);
        bind($get, 'i', $this->id);
        execute($get);
        $loans = array();
        foreach(result_list($get) as $row) {
            $loans[] = new Loan($row['id']);
        }
        return $loans;
    }

    public function get_overdue_loans() {
        $overdue = array();
        foreach($this->get_loans('active') as $loan) {
            if($loan->is_overdue()) {
                $overdue[] = $loan;
            }
        }
        return $overdue;
    }

    public function get_expiring_loans($end_date) {
        $expiring = array();
        foreach($this->get_loans('active') as $loan) {
            if($loan->expires_before($end_date)) {
                $expiring[] = $loan;
            }
        }
        return $expiring;
    }

    public function has_created_events() {
        $get = prepare('select `initiator` from `event`');
        execute($get);
        foreach(result_list($get) as $row) {
            if($row['initiator'] === $this->id) {
                return true;
            }
        }
        $get = prepare('select `initiator` from `loan_extension`');
        execute($get);
        foreach(result_list($get) as $row) {
            if($row['initiator'] === $this->id) {
                return true;
            }
        }
    }
}
?>