class.collaborator.php

<?php
/*********************************************************************
    class.collaborator.php

    Ticket collaborator

    Peter Rotich <peter@osticket.com>
    Copyright (c)  2006-2013 osTicket
    http://www.osticket.com

    Released under the GNU General Public License WITHOUT ANY WARRANTY.
    See LICENSE.TXT for details.

    vim: expandtab sw=4 ts=4 sts=4:
**********************************************************************/
require_once(INCLUDE_DIR . 'class.user.php');
require_once(INCLUDE_DIR . 'class.client.php');

class Collaborator extends TicketUser {

    var $ht;

    var $user;
    var $ticket;

    function __construct($id) {
        $this->load($id);
        parent::__construct($this->getUser());
    }

    function load($id) {

        if(!$id && !($id=$this->getId()))
            return;

        $sql='SELECT * FROM '.TICKET_COLLABORATOR_TABLE
            .' WHERE id='.db_input($id);

        $this->ht = db_fetch_array(db_query($sql));
        $this->ticket = null;
    }

    function reload() {
        return $this->load();
    }

    function __toString() {
        return Format::htmlchars(sprintf('%s <%s>', $this->getName(),
                    $this->getEmail()));
    }

    function getId() {
        return $this->ht['id'];
    }

    function isActive() {
        return ($this->ht['isactive']);
    }

    function getCreateDate() {
        return $this->ht['created'];
    }

    function getTicketId() {
        return $this->ht['ticket_id'];
    }

    function getTicket() {
        if(!$this->ticket && $this->getTicketId())
            $this->ticket = Ticket::lookup($this->getTicketId());

        return $this->ticket;
    }

    function getUserId() {
        return $this->ht['user_id'];
    }

    function getUser() {

        if(!$this->user && $this->getUserId())
            $this->user = User::lookup($this->getUserId());

        return $this->user;
    }

    function remove() {

        $sql='DELETE FROM '.TICKET_COLLABORATOR_TABLE
            .' WHERE id='.db_input($this->getId())
            .' LIMIT 1';

        return  (db_query($sql) && db_affected_rows());
    }

    static function add($info, &$errors) {

        if (!$info || !$info['ticketId'] || !$info['userId'])
            $errors['err'] = __('Invalid or missing information');
        elseif (($c=self::lookup($info)))
            $errors['err'] = sprintf(__('%s is already a collaborator'),
                    $c->getName());

        if ($errors) return false;

        $sql='INSERT INTO '.TICKET_COLLABORATOR_TABLE
            .' SET updated=NOW() '
            .' ,isactive='.db_input(isset($info['isactive']) ?  $info['isactive'] : 0)
            .' ,ticket_id='.db_input($info['ticketId'])
            .' ,user_id='.db_input($info['userId']);

        if(db_query($sql) && ($id=db_insert_id()))
            return self::lookup($id);

        $errors['err'] = __('Unable to add collaborator. Internal error');

        return false;
    }

    static function forTicket($tid, $criteria=array()) {

        $collaborators = array();

        $sql='SELECT id FROM '.TICKET_COLLABORATOR_TABLE
            .' WHERE ticket_id='.db_input($tid);

        if(isset($criteria['isactive']))
            $sql.=' AND isactive='.db_input($criteria['isactive']);

        //TODO: sort by name of the user

        if(($res=db_query($sql)) && db_num_rows($res))
            while(list($id)=db_fetch_row($res))
                $collaborators[] = self::lookup($id);

        return $collaborators;
    }

    static function getIdByInfo($info) {

        $sql='SELECT id FROM '.TICKET_COLLABORATOR_TABLE
            .' WHERE ticket_id='.db_input($info['ticketId'])
            .' AND user_id='.db_input($info['userId']);

        return db_result(db_query($sql));
    }

    static function lookup($criteria) {

        $id = is_numeric($criteria)
            ? $criteria : self::getIdByInfo($criteria);

        return ($id
                && ($c = new Collaborator($id))
                && $c->getId() == $id)
            ? $c : null;
    }
}

class TicketCollaborator extends VerySimpleModel {
    static $meta = array(
        'table' => TICKET_COLLABORATOR_TABLE,
        'pk' => array('id'),
        'joins' => array(
            'ticket' => array(
                'constraint' => array('ticket_id' => 'TicketModel.ticket_id'),
            ),
            'user' => array(
                'constraint' => array('user_id' => 'User.id'),
            ),
        ),
    );
}
?>