<?php 
/** @see Zend_Controller_Action */ 
require_once 'Zend/Controller/Action.php'; 
require_once 'Zend/Mail.php';
 
class IndexController extends Zend_Controller_Action 
{ 
    function preDispatch()
		{
			$auth = Zend_Auth::getInstance();
			
			if (!$auth->hasIdentity()) {
				$this->view->identified = false;
			}
			else
			{
				$this->view->identified = true;
			}
		}
    
    public function indexAction() 
    { 
    	// disable layouts for this action:
      $this->_helper->layout->disableLayout();
      
      $this->view->title = Zend_registry::get('translate')->_('Title');
    } 
    
    public function profileAction() 
    { 
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('Profile');
    } 
    
    public function projectsAction() 
    { 
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('Projects');
    	
    	$tagid = (int)$this->_request->getParam('tagid');
    	
    	$catid = (int)$this->_request->getParam('catid');
    	
    	// get images for projects
    	$projects = new Projects();    
		  $select = $projects->select();
		  $select->setIntegrityCheck ( false ); // pour le join sinon erreur 
		  
		  $db = Zend_Registry::get('db');
			$logger = Zend_Registry::get('logger');
    	
    	if ($tagid > 0)
    	{
    		// SELECT * FROM images,projects,images_tags where img_pro_id = pro_id and imtg_img_id = img_id and imtg_tag_id = 3
    		$select->from ( $projects )->join ( 'images', 'img_pro_id = projects.pro_id',  Array('img_filename'))
    														 ->join ( 'images_tags', 'imtg_img_id = img_id', Array())
    														 ->where( 'imtg_tag_id = ?', $tagid )
    														 ->order('pro_date DESC');
    	}
    	else if($catid > 0)
    	{
    		$select->from ( $projects )->joinLeft( 'images', 'img_pro_id = projects.pro_id AND img_position = 1',  'img_filename')
												 ->where( 'pro_cat_id = ?', $catid)
												 ->order('pro_date DESC');
    	}
    	else
    	{
			$select->from ( $projects )->joinLeft( 'images', 'img_pro_id = projects.pro_id AND img_position = 1', 'img_filename')
												 ->order('pro_date DESC');
    	}
    	
    	$this->view->projects = $projects->fetchAll($select);
    	
    	$logger->info(Zend_registry::get('db')->getProfiler()->getLastQueryProfile()->getQuery());
											 
			$tags = new Tags();
    	$this->view->tags = $tags->fetchAll();   	   	
    	$this->view->catid = $catid;
    } 
    
    public function projectdetailsAction() 
    { 
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('ProjectDetails');
    	
    	$id = (int)$this->_request->getParam('id', 0);
			if ($id > 0) {
				$project = new Projects();
				$this->view->project = $project->fetchRow('pro_id='.$id);
        $this->view->id = $id;
						
				// get images for this project
				$images = new Images();
				$select = $images->select()->where('img_pro_id = ?', (int) $id);
    		$this->view->images = $images->fetchAll($select);
			}
    } 
    
    public function teamAction() 
    {
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('Team');
    }
    
    public function referencesAction() 
    { 
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('References');
    	
			$references = new References();
			$select = $references->select()->order(array('ref_type ASC', 'ref_client ASC'));
    	$this->view->references = $references->fetchAll($select);
    } 
    
    public function contactAction() 
    {
    	$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('Contact');

			$form = new FormContact();
			$this->view->form = $form;
			
			if ($this->_request->isPost()) {
				$formData = $this->_request->getPost();
			
				if ($form->isValid($formData)) {					
					$tr = new Zend_Mail_Transport_Sendmail();
          Zend_Mail::setDefaultTransport($tr);
          
          $mail = new Zend_Mail();
					$mail->setBodyText('From '.$form->getValue('FirstName').' '.$form->getValue('Name').' at '.$form->getValue('Company').' : '.$form->getValue('Text'));
					$mail->setFrom($form->getValue('Email'));
					$mail->addTo('symetry@symetry.be');
					$mail->setSubject($form->getValue('Subject'));
					$mail->send();
					
					$this->_redirect('/Index/contactthanks');
				} else {
					$form->populate($formData);
				}
			}
    }
    
    public function contactthanksAction()
    {
    		$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('Contact');
    }
    
    public function legalinformationAction()
    {
    		$this->view->title = Zend_registry::get('translate')->_('Title').' - '.Zend_registry::get('translate')->_('LegalInformation');
    }
    
    public function pressAction()
    {
    }
}