<?php

/**
 * @method array getDSlideType4Select($columns = '*', $where = null, $order = null, $limit = null);
 */

abstract class App_Slide_Abstract_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Slide';
    protected $_urlParseFields = array('html', 'url');

    protected function _getFromColumns()
    {
        $columns =  parent::_getFromColumns();
        $columns['image'] = new Zend_Db_Expr(
            "IF(`{$this->_tableAlias}`.`type` = 'image', `{$this->_tableAlias}`.`image`, "
            . "`{$this->_tableAlias}`.`backgroundImage`)"
        );
        return $columns;
    }

    public function getListSelect()
    {
        if (null !== $this->_select) {
            return $this->_select;
        }
        $select = parent::getListSelect();
        $select->join(
            $this->_getPair('DSlideType'),
            "`DSlideType`.`id` = `{$this->_tableAlias}`.`type`",
            array('typeTitle' => 'title')
        );
        return $select;
    }
}