<?php

class Produto_AtributoController extends Agro_Controller_Action {
	public $_paginator = false;
	
	public function init() {
		$this->view->title = 'Produto » Atributos » Atributo';
	}

	public function getModel() {
		return new Produto_Model_Atributos();
	}
	
	public function getForm() {
		return new Produto_Form_Atributo();
	}
	
	
	public function getFilter() {
		$where = array();
		
		if ($this->getRequest()->getParam('ds_chave_rn')) {
			$where[] = array(
				'field' => 'ds_chave_rn',
				'operator' => 'ilike',
				'value' => '%'.$this->getRequest()->getParam('ds_chave_rn').'%'
			);
		}
		
		if ($this->getRequest()->getParam('id_atributo_modulo')) {
			if ($this->getRequest()->getParam('id_atributo_modulo')) {
				$where[] = array(
					'field' => 'id_atributo_modulo',
					'operator' => '=',
					'value' => $this->getRequest()->getParam('id_atributo_modulo')
				);
			}
		}
		if($this->getRequest()->getParam('fl_ativo')) {
			$where[] = array(
				'field' => 'fl_ativo',
				'operator' => ' = ',
				'value' =>  $this->getRequest()->getParam('fl_ativo')
			);
		}
		return $where;
	}
	
	public function save(array $post) {		
		try {
			$ModelAtributos = $this->getModel();
			$ModelAtributos->save($post);

			$this->_redirect('/produto/atributo');
		} catch (Exception $e) {
			$this->view->showMessage(MSG_ERROR, 'error', $e);
		}
	}
	
	public function ordemperguntaAction() {
		$this->getHelper('ViewRenderer')->setNoRender();
		$this->getHelper('layout')->disableLayout();
		$Model = new Produto_Model_Atributos();
		$Model->alteraOrdemPerguntas($this->getRequest());
		return $this->getResponse()->setBody(Zend_Json::encode('1'));
	}
	
	public function gettablesAction() {
		$this->getHelper('ViewRenderer')->setNoRender();
		$this->getHelper('layout')->disableLayout();
		
		$Util = new Agro_Util();
		
		return $this->getResponse()->setBody(Zend_Json::encode($Util->getTables($this->getRequest()->getParam('ds_schema'))));
	}
	
	public function getcolumnsAction() {
		$this->getHelper('ViewRenderer')->setNoRender();
		$this->getHelper('layout')->disableLayout();
		
		$Util = new Agro_Util();
		
		return $this->getResponse()->setBody(Zend_Json::encode($Util->getColumns($this->getRequest()->getParam('ds_table'))));
	}
}