<?php

class IndexController extends Zend_Controller_Action {

    function init () {
	
		Zend_Loader::loadClass( 'Car' );

        $this->initView();
		$this->view->baseUrl = $this->_request->getBaseUrl();
    }

    function indexAction () {

        $this->view->title = "Home";
		
		$car = new Car();
		$this->view->cars = $car->fetchAll();
		
        $this->render();
    }

    function addAction () {

        $this->view->title = "Add Car";
		
		if ( $this->_request->isPost() ) {
		
			Zend_Loader::loadClass( 'Zend_Filter_StripTags' );
			
			$filter = new Zend_Filter_StripTags();
			
			$make	= trim( $filter->filter( $this->_request->getPost( 'make' ) ) );
			$model	= trim( $filter->filter( $this->_request->getPost( 'model' ) ) );
			$seats	= trim( $filter->filter( $this->_request->getPost( 'seats' ) ) );
			$colour	= trim( $filter->filter( $this->_request->getPost( 'colour' ) ) );
			$reg	= trim( $filter->filter( $this->_request->getPost( 'reg' ) ) );
			
			if ( ( $make != '' ) && ( $model != '' ) && ( $seats != '' ) && ( $colour != '' ) && ( $reg != '' ) ) {
			
				$data = array(
					'make'		=> $make,
					'model'		=> $model,
					'seats'		=> $seats,
					'colour'	=> $colour,
					'reg'		=> $reg,
				);
				
				$car = new Car();
				$car->insert( $data );
				
				$this->_redirect( '/' );				
				return;
			}
		}
		
		$this->view->car = new stdClass();
		$this->view->car->id		= null;
		$this->view->car->make		= '';
		$this->view->car->model		= '';
		$this->view->car->seats		= null;
		$this->view->car->colour	= '';
		$this->view->car->reg		= '';
		
		$this->view->action = 'add';
		$this->view->buttonText = 'Add';		
		
        $this->render();
    }

    function editAction () {

        $this->view->title = "Edit Car";
		
		$car = new Car();
		
		if ( $this->_request->isPost() ) {
		
			Zend_Loader::loadClass( 'Zend_Filter_StripTags' );
			
			$filter = new Zend_Filter_StripTags();
			
			$id = (int)$this->_request->getPost( 'id' );
			$make	= trim( $filter->filter( $this->_request->getPost( 'make' ) ) );
			$model	= trim( $filter->filter( $this->_request->getPost( 'model' ) ) );
			$seats	= trim( $filter->filter( $this->_request->getPost( 'seats' ) ) );
			$colour	= trim( $filter->filter( $this->_request->getPost( 'colour' ) ) );
			$reg	= trim( $filter->filter( $this->_request->getPost( 'reg' ) ) );
			
			if ( $id !== false ) {
			
				if ( ( $make != '' ) && ( $model != '' ) && ( $seats != '' ) && ( $colour != '' ) && ( $reg != '' ) ) {
				
					$data = array(
						'make'		=> $make,
						'model'		=> $model,
						'seats'		=> $seats,
						'colour'	=> $colour,
						'reg'		=> $reg,
					);
					
					$where = 'id = ' . $id;					
					$car->update( $data, $where );
					
					$this->_redirect( '/' );
					return;
				}
				
				else {
				
					$this->view->car = $car->fetchRow( 'id = ' . $id );
				}				
			}
		}
			
		else {
			
			$id = (int)$this->_request->getParam( 'id', 0 );
				
			if ( $id > 0) {
				
				$this->view->car = $car->fetchRow( 'id = ' . $id );
			}
			
			else {

				$this->view->car = $car->fetchRow( 'id = 1' );
			}
		}
		
		$this->view->action = 'edit';
		$this->view->buttonText = 'Update';
		
        $this->render();
    }

    function deleteAction () {

        $this->view->title = "Delete Car";
		
		$car = new Car();
		
		if ( $this->_request->isPost() ) {
		
			Zend_Loader::loadClass( 'Zend_Filter_Alpha' );
			$filter = new Zend_Filter_Alpha();
			
			$id = (int)$this->_request->getPost( 'id' );
			$del = $filter->filter( $this->_request->getPost( 'del' ) );
			
			if ( ( $del == 'Yes' ) && ( $id > 0 ) ) {
			
				$where = 'id = ' . $id;
				$rows_affected = $car->delete( $where );
			}
		}
		
		else {
		
			$id = (int)$this->_request->getParam( 'id' );
			
			if ( $id > 0 ) {
			
				$this->view->car = $car->fetchRow( 'id = ' . $id );
				
				if ( $this->view->car->id > 0 ) {
				
					$this->render();
					return;
				}
			}
		}
		
        $this->_redirect( '/' );
    }
}