tsd/TSDWord.php5

<?php

class TSDWord extends TSDLeaf {
    public static $ATTRIBUTES = array(
        'word' => 'edit',
        'definition' => 'edit'
    );

    public function __construct($word = '') {
        parent::__construct('TSDDictionary', self::$ATTRIBUTES, 'word', $word, 'TSDDictionaryAlignment', 'word');
    }

    public function isValid() {
        return (
            ($this->word != '') &&
            ($this->definition != '')
        );
    }

    public function getParent() {
        return null;
    }

    public function getIdentifier() {
        return $this->word;
    }

    public function listChildren($constraints = array(), $limit = array(), $order = array(), $cnt = false) {
        return null;
    }

    public function listValidChildren($constraints = array(), $limit = array(), $order = array(), $cnt = false) {
        return null;
    }

    public static function getList($constraints = array(), $limit = array(), $order = array(), $cnt = false) {
        return self::getListImpl('TSDWord', 'TSDDictionary', array_keys(self::$ATTRIBUTES), $constraints,
                                    array(), $limit, $order, $cnt);
    }

    public static function listByLetter($letter, $cnt = false) {
        return self::getListImpl('TSDWord', 'TSDDictionary', array_keys(self::$ATTRIBUTES), array(),
                                    array('LIKE', 'word' => "$letter%"), array(), array(), $cnt);
    }

    public static function getResourceAlignments($urlOrId, $mode = TSD::MODE_LIVE) {
        if(($id = self::getCWISID($urlOrId)) === false)
            return false;
        $query = 'SELECT TSDDictionary.word, definition, reason, version, status FROM TSDDictionaryAlignment LEFT JOIN '
            . 'TSDDictionary ON TSDDictionary.word = TSDDictionaryAlignment.word WHERE TSDDictionaryAlignment.resourceId = '
            . $id;
        switch($mode) {
            case TSD::MODE_LIVE:
                $query .= ' AND version = \'LIVE\'';
                break;
            case TSD::MODE_DEV:
                $query .= ' AND version = \'DEV\'';
                break;
            case TSD::MODE_DEV_ACTIVE:
                $query .= ' AND version = \'DEV\' AND status <> \'DELETED\'';
                break;
            case TSD::MODE_NEW:
                $query .= ' AND version = \'DEV\' AND status = \'NEW\'';
                break;
            case TSD::MODE_CHANGED:
                $query .= ' AND version = \'DEV\' AND status = \'CHANGED\'';
                break;
            case TSD::MODE_DELETED:
                $query .= ' AND version = \'DEV\' AND status = \'DELETED\'';
                break;
            case TSD::MODE_APPROVED:
                $query .= ' AND version = \'DEV\' AND status = \'APPROVED\'';
                break;
            case TSD::MODE_ALL:
                $query .= '';
                break;
        }
        $DBI = TSD::getDBI();
        $result = $DBI->query($query);
        if(count($DBI->getError()) > 0) {
            $this->setError('DB error(s): ' . implode('; ', $DBI->getError()));
            return null;
        }
        $out = array();
        foreach($result as $r) {
            $obj = new TSDWord();
            $obj->addAttribute('reason', false);
            $obj->addAttribute('version', false);
            $obj->addAttribute('status', false);
            $obj->setAttr('reason', $r['reason']);
            $obj->setAttr('word', $r['word']);
            $obj->setAttr('definition', $r['definition']);
            $obj->setAttr('version', $r['version']);
            $obj->setAttr('status', $r['status']);
            $out[] = $obj;
        }
        return $out;
    }
}

?>

---