<?php

abstract class App_Slide_AbstractObj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Banner';
    protected $_urlParseFields = array('html');
    public $itemName = 'Slide';
    public $itemsName = 'Slides';
    public $imageWidth = 940;
    public $imageHeight = 395;
    public $htmlWidth = 200;
    public $descriptionLengh = 330;
    
    protected function _from(Zend_Db_Select $select = null)
    {
        if (null === $select) {
            $select = $this->select;
        }
        $columns = array(
            '*',
            'image' => new Zend_Db_Expr("IF(`{$this->_tableAlias}`.`type` = 'image', `{$this->_tableAlias}`.`image`, 
                                        `{$this->_tableAlias}`.`backgroundImage`)")
        );
        $select->from($this->pair, $columns);
        return $select;
    }
    
    protected function _join(Zend_Db_Select $select = null)
    {
        $select = parent::_join($select);
        $select->join(
            $this->pairDBannerType, 
            "`DBannerType`.`id` = `{$this->_tableAlias}`.`type`",
            array('typeTitle' => 'title')
        );
        return $select;
    }
}