<?php

namespace App\WideSlide;

abstract class AbstractObj extends \Qs_Db_Obj
{
    const HOME_PAGE_ID = 1;

    protected $_tableAlias = 'WideSlide';
    protected $_fileFields = array('image');

    public function getSliderPages($columns = array('id', 'menuTitle'))
    {
        $pages = \Qs_SiteMap::find(null, array('type' => 'WideSlide\\'));
        return ($pages) ? \Qs_Array::fetchPairs($pages, $columns) : array() ;
    }

    /**
     * @return \Zend_Db_Select
     */
    public function getListSelect()
    {
        if (null === $this->_select) {
            parent::getListSelect();
            $this->_joinPageContent($this->_select);
        }
        return $this->_select;
    }

    protected function _joinPageContent(\Zend_Db_Select $select)
    {
        $select->joinLeft(
            $this->_getPair('PageContent'),
            '`PageContent`.`idPage` = `' . $this->_tableAlias . '`.`pageId`'
            . ' AND `PageContent`.`language` = "'.  \Qs_Db_Language::getDefault() .'"',
            array('pageTitle' => 'menuTitle')
        );
        return $this;
    }
}