tsd/TSDText.php5

<?php

class TSDText extends TSDLeaf {
    public static $ATTRIBUTES = array(
        'book_title' => false,
        'book_id' => false,
        'book_gradeOrCourse' => false,
        'chapter_name' => false,
        'chapter_id' => false,
        'section_name' => false,
        'section_id' => false,
        'resourceId' => false,
        'reason' => false,
        'sectionId' => false,
        'status' => false,
        'version' => false
    );

    public function __construct($id = '') {
        if(is_array($id)) {
            $arr = $id;
            $id = '';
        }
        parent::__construct('Text', self::$ATTRIBUTES, 'section_id', $id, 'TSDTextbookAlignment', 'sectionId');
        if(isset($arr)) {
            foreach($arr as $elt) {
                switch(get_class($elt)) {
                    case 'TSDBook':
                        $this->setAttr('book_title', $elt->title);
                        $this->setAttr('book_id', $elt->id);
                        $this->setAttr('book_gradeOrCourse', $elt->gradeOrCourse);
                        break;
                    case 'TSDChapter':
                        $this->setAttr('chapter_name', $elt->name);
                        $this->setAttr('chapter_id', $elt->id);
                        break;
                    case 'TSDSection':
                        $this->setAttr('section_name', $elt->name);
                        $this->setAttr('section_id', $elt->id);
                        break;
                }
            }
            $this->setAttr('reason', '');
        }
    }

    public function isValid() {
        return true;
    }

    protected function populate() {
        $query = <<<END_QUERY
SELECT  TSDBook.title           AS book_title,
        TSDBook.gradeOrCourse   AS book_gradeOrCourse,
        TSDChapter.name         AS chapter_name,
        TSDSection.name         AS section_name,
        TSDSection.id           AS section_id
FROM TSDSection
    LEFT JOIN TSDChapter    ON TSDChapter.id    = TSDSection.chapterId
    LEFT JOIN TSDBook       ON TSDBook.id       = TSDChapter.bookId
WHERE
    TSDSection.id = '$this->section_id'
END_QUERY;

        $DBI = TSD::getDBI();

        $result = $DBI->query($query);
        if(count($DBI->getError()) > 0) {
            $this->setError('Failed to populate: ' . implode('; ', $DBI->getError()));
            return false;
        }

        if(count($result) == 0)
            return true;
        if(count($result) > 1)
            $this->setWarning("Multiple results for key 'id'; using first result");

        foreach($result[0] as $a => $v)
            $this->setAttr($a, $v);

        $this->inDB = true;

        return true;
    }

    protected static function getListImpl($constraints, $limit, $order, $cnt, $mode = 'normal') {
        $DBI = TSD::getDBI();
        if(!$DBI) {
            self::setStaticError('Cannot connect to TSD!');
            return null;
        }

        if($mode == 'normal')
            $attrs = array_keys(self::$ATTRIBUTES);
        else
            $attrs = array_merge(array_keys(self::$ATTRIBUTES), array('resourceId', 'reason', 'approved', 'deleteFlag'));

        $constraintC = self::criteriaToString($constraints, $attrs);
        if($constraintC === false)
            return null;
        $limitC = self::limitToString($limit);
        if($limitC === false)
            return null;
        $orderC = self::orderToString($order, $attrs);
        if($orderC === false)
            return null;

        if($cnt)
            $query = 'SELECT COUNT(*) ';
        else {
            $query = <<<END_QUERY
SELECT  TSDBook.title           AS book_title,
        TSDBook.gradeOrCourse   AS book_gradeOrCourse,
        TSDBook.id              AS book_id,
        TSDChapter.name         AS chapter_name,
        TSDChapter.id           AS chapter_id,
        TSDSection.name         AS section_name,
        TSDSection.id           AS section_id

END_QUERY;
            if($mode != 'normal')
                $query .= ', TSDTextbookAlignment.resourceId AS resourceId, TSDTextbookAlignment.reason AS reason, '
                    . 'TSDTextbookAlignment.version AS version, TSDTextbookAlignment.status AS status ';
        }

        $query .= <<<END_QUERY
FROM TSDSection
    LEFT JOIN TSDChapter    ON TSDChapter.id    = TSDSection.chapterId
    LEFT JOIN TSDBook       ON TSDBook.id       = TSDChapter.bookId
END_QUERY;
        if($mode != 'normal')
            $query .= ' LEFT JOIN TSDTextbookAlignment ON TSDSection.id = TSDTextbookAlignment.sectionId ';

        if($constraintC != '') {
            $constraintC = str_replace('section_name', 'TSDSection.name', $constraintC);
            $constraintC = str_replace('chapter_name', 'TSDChapter.name', $constraintC);
            $constraintC = str_replace('chapter_id', 'TSDChapter.id', $constraintC);
            $constraintC = str_replace('book_title', 'TSDBook.title', $constraintC);
            $constraintC = str_replace('book_id', 'TSDBook.id', $constraintC);
            $constraintC = str_replace('book_gradeOrCourse', 'TSDBook.gradeOrCourse', $constraintC);
            $constraintC = str_replace('section_id', 'TSDSection.id', $constraintC);
            $query .= ' WHERE ' . $constraintC;
        }
        $query .= ' ' . $limitC . ' ' . $orderC;

        $result = $DBI->query($query);
        if(count($DBI->getError()) > 0) {
            self::setStaticError('Error doing query: ' . implode('; ', $DBI->getError()));
            return null;
        }

        $ret = array();
        foreach($result as $r) {
            $obj = new TSDText();
            foreach($r as $a => $v)
                $obj->setAttr($a, $v);
            $obj->inDB = true;
            $ret[] = $obj;
        }

        return $ret;
    }

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

    public static function getResourceAlignments($urlOrId, $mode = TSD::MODE_LIVE) {
        if(($id = self::getCWISID($urlOrId)) === false)
            return false;
        switch($mode) {
            case TSD::MODE_LIVE:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_LIVE);
                break;
            case TSD::MODE_DEV:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV);
                break;
            case TSD::MODE_DEV_ACTIVE:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV,
                                    '<>', 'status' => TSD::STATUS_DELETED);
                break;
            case TSD::MODE_NEW:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV, 'status' => TSD::STATUS_NEW);
                break;
            case TSD::MODE_CHANGED:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV, 'status' => TSD::STATUS_CHANGED);
                break;
            case TSD::MODE_DELETED:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV, 'status' => TSD::STATUS_DELETED);
                break;
            case TSD::MODE_APPROVED:
                $modeArray = array('AND', 'resourceId' => $id, 'version' => TSD::VERSION_DEV, 'status' => TSD::STATUS_APPROVED);
                break;
            case TSD::MODE_ALL:
                $modeArray = array();
                break;
        }
        return self::getListImpl($modeArray, array(), array(), false, 'alignments');
    }

    public function commit() {
        $this->setError('You cannot commit TSDText objects!');
        return false;
    }

    public function getParent() {
        return null;
    }

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

    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;
    }
}

?>

---