<?php

class App_SideBlock_Obj extends App_SideBlock_Abstract_Obj
{
    const TYPE_HTML              = 'html';
    const TYPE_TESTIMONIAL       = 'testimonial';
    const TYPE_SUBSCRIPTION      = 'subscription';
    const TYPE_RECENT_NEWS       = 'recentNews';
    const TYPE_FEATURED_POSTS    = 'featuredPosts';
    const TYPE_NEWSLETTERS       = 'newsLetters';
    const TYPE_UPCOMING_EVENTS   = 'upcomingEvents';
    const TYPE_USER_LOGIN        = 'userLoginForm';

    const PAGE_ALL    = 'all';
    const PAGE_CUSTOM = 'custom';

    const LINK_NONE = 'none';
    const LINK_PAGE = 'page';
    const LINK_URL  = 'url';

    protected $_idPage = null;

    public function getListSelect()
    {
        $this->_select = $this->_getBasicListSelect('*', null, $this->_idPage);
        $this->_select->where("`{$this->_tableAlias}`.`show` = 'y'");
        // переписуємо сортування, якщо часом блоки зловили чужий orderBy з реквеста
        $this->_select->reset(Zend_Db_Select::ORDER);
        $this->_select->order("{$this->_tableAlias}2Page.sorter");

        return $this->_select;
    }

    protected function _prepareList(&$list)
    {
        parent::_prepareList($list);
        if (is_array($list) && !empty($list)) {
            foreach (array_keys($list) as $k) {
                if ('page' == $list[$k]['linkType']) {
                    $list[$k]['linkUrl'] = Qs_SiteMap::find(array('id' => $list[$k]['linkPageId']), null, null, 'url');
                }
            }
        }
        return true;
    }

    public function setIdPage($id)
    {
        $this->_idPage = $id;
        return $this;
    }
}