<?php

abstract class App_SideBlock_Abstract_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'SideBlock';
    protected $_urlParseFields = ['content', 'linkUrl'];

    /**
     * @param array|string|null $blockCols [OPTIONAL]
     * @param array|string|null $block2PageCols [OPTIONAL]
     * @param array|int|null $pageIds [OPTIONAL]
     * @return \Zend_Db_Select
     */
    protected function _getBasicListSelect($blockCols = '*', $block2PageCols = null, $pageIds = null)
    {
        $block2Page = $this->_tableAlias . '2Page';
        $joinCondition = ["`{$block2Page}`.`idSideBlock` = `{$this->_tableAlias}`.`id`"];
        if (null !== $pageIds) {
            $joinCondition["`{$block2Page}`.`idPage` " . (is_array($pageIds) ? 'IN(?)' : '= ?')] = $pageIds;
        }
        $all = $this->_db->quote(App_SideBlock_Obj::PAGE_ALL);
        $joinCondition[] = "`{$block2Page}`.`auto` = IF(`{$this->_tableAlias}`.`pageType` = {$all}, 'y', 'n')";

        $select = $this->_db->select()
            ->from($this->_getPair(), $blockCols)
            ->join($this->_getPair($block2Page), Qs_Db::getWhereSql($joinCondition), $block2PageCols);

        return $select;
    }

    public static function getPages4Select()
    {
        $where = ['`Page`.`showSideBlock` = "y"'];
        return (array) App_Cms_Obj::getInstance()->getFilteredPages4Select(0, $where);
    }
}