<?php
class Advertise_PlaceController extends System_Controller_Db_Table
{
    public function editAction()
    {
        parent::editAction();
    }

    public function showAction()
    {
        $paramName = $this->getRequest()->getParam('Name');
        $paramSiteID = $this->getRequest()->getParam('Site_ID');
        if (!$paramName){
            throw new Zend_Exception('Parametr Name should be defined for Advertise_PlaceController->getAction()');
        }
        $this->_select->where('Name = ?', $paramName);
        $objectPlace = $this->_model->fetchRow($this->_select);
        if (!is_object($objectPlace)){
            throw new Zend_Exception('Object Advertise_Place not found in DB');
        }
        if ($objectPlace->Site_ID){
            $paramSiteID = $objectPlace->Site_ID;
        }
        $this->view->object = $objectPlace->toArray();
        $tableAdvertise = new Advertise_Table();
        $selectAdvertise = $tableAdvertise->select();
        if ($objectPlace->Width){
            $selectAdvertise->where('Width = ?', $objectPlace->Width);
        }
        if ($objectPlace->Height){
            $selectAdvertise->where('Height = ?', $objectPlace->Height);
        }

        if ($paramSiteID){
            $selectAdvertise->where('Site_ID = ?', $paramSiteID);
        }
        $listAdvertise = $tableAdvertise->fetchAll($selectAdvertise);
        if ($listAdvertise->count()){
            $this->view->advertise = $listAdvertise->current()->toArray();
        }
    }

    public function getlistAction()
    {
        $this->_select->setIntegrityCheck(false);
        $this->_select->from($this->_model);
        $this->_select->joinLeft('advertise_site', 'advertise_site.ID = advertise_place.Site_ID', array('Site_Name' => 'Name'));
        parent::getlistAction();
    }

}