<?php
class Advertise_IndexController extends System_Controller_Db_Table
{
    /**
     * Redirector - defined for code completion
     *
     * @var Zend_Controller_Action_Helper_Redirector
     */
    protected $_redirector = null;

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


    public function editAction()
    {
        parent::editAction();
//        $paramAdvertiseID = (int)$this->view->object['ID'];
//        if ($paramAdvertiseID > 0 && $this->getRequest()->isPost()){
//            $paramPlaceID = $this->getRequest()->getParam('Place_ID', 0);
//            if ($paramPlaceID){
//                $tablePlaceAdvertise = new Advertise_Place_Advertise_Table();
//                $selectPlaceAdvertise = $tablePlaceAdvertise->select();
//                $selectPlaceAdvertise->where('Place_ID = ?', $paramPlaceID);
//                $selectPlaceAdvertise->where('Advertise_ID = ?', $paramAdvertiseID);
//                $objectPlaceAdvertise = $tablePlaceAdvertise->fetchRow($selectPlaceAdvertise);
//                if (!is_object($objectPlaceAdvertise)){
//                    $listPlaceAdvertise = $tablePlaceAdvertise->fetchAll($tablePlaceAdvertise->select()->where('Advertise_ID = ?', $paramAdvertiseID));
//                    foreach ($listPlaceAdvertise as $objectPlaceAdvertise){
//                        $objectPlaceAdvertise->delete();
//                    }
//                    $objectPlaceAdvertise = $tablePlaceAdvertise->fetchNew();
//                    $objectPlaceAdvertise->Place_ID = $paramPlaceID;
//                    $objectPlaceAdvertise->Advertise_ID = $this->view->object->ID;
//                    $objectPlaceAdvertise->save();
//                }
//            }
//        }
    }

    public function showAction()
    {
        $paramID = $this->getRequest()->getParam('ID', $this->getRequest()->getParam('id'));
        if (!$paramID){
            throw new Zend_Exception('Parametr ID should be defined for Advertise_IndexController->showAction()', 404);
        }

		$this->_select->where($this->_model->getTableName() . '.ID = ?' , $paramID);
		$object = $this->_model->fetchRow($this->_select);

		if (!is_object($object)){
			throw new Zend_Exception('Object with ID = ' . $paramID . ' not found in DB', 404);
		}
		$object->Shows = $object->Shows + 1;
		$object->save();
	    $this->view->row = $object->toArray();
    }

    public function clickAction()
    {
		$paramID = $this->getRequest()->getParam('ID', $this->getRequest()->getParam('id'));
		if ($paramID === NULL){
			throw new Zend_Exception('Param ID should be defined for getAction', 404);
		}

		$this->_select->where($this->_model->getTableName() . '.ID = ?' , $paramID);
		$object = $this->_model->fetchRow($this->_select);

		if (!is_object($object)){
			throw new Zend_Exception('Object with ID = ' . $paramID . ' not found in DB', 404);
		}

	    $this->view->row = $object->toArray();
        $this->_helper->viewRenderer->setNoRender(true);
        $this->_redirector = $this->_helper->getHelper('Redirector');

        // Set the default options for the redirector
        // Since the object is registered in the helper broker, these
        // become relevant for all actions from this point forward
        $this->_redirector->setCode(301)
                          ->setGotoUrl($object->URL);
		$object->Clicks = $object->Clicks + 1;
		$object->save();
        $this->_redirector->redirectAndExit();
        return; // never reached
    }
}