<?php

class App_Application_Document_AdminObj extends App_Application_Document_AbstractObj
{
    public function getUserData()
    {
        static $data;
        if (null === $data) {
            $obj = new App_Application_User_AdminObj();
            $obj->setPrimaryKey($this->getApplicationUserId());
            $data = $obj->getData();
        }
        return $data;
    }

    protected function _getStatusFromColumn()
    {
        $_notSubmitted = $this->_db->quote(self::STATUS_NOT_SUBMITTED);
        $_awaiting_review = $this->_db->quote(self::STATUS_AWAITING_REVIEW);
        $_review_completed = $this->_db->quote(self::STATUS_REVIEW_COMPLETED);

        return new Zend_Db_Expr("
            IF (
                `ApplicationDocument`.`file` IS NOT NULL, 
                IF (`ApplicationDocument`.`reviewed` = 'y', {$_review_completed}, {$_awaiting_review}),
                {$_notSubmitted}
            ) AS `status`
        ");
    }
}