<?php

class Agronet_TesteController extends Agro_Controller_Action {

	public function indexAction() {
	}
	
	public function logAction() {
		$id = $this->getRequest()->getParam('id');
		
		if ($id) {
			$Log = Agro_Db_Table_Abstract::getDefaultAdapter()->fetchRow("select * from log.log_default where id = $id");
			$User = Agro_Db_Table_Abstract::getDefaultAdapter()->fetchOne("select ds_nome_usuario from sistema.usuarios where id = {$Log['id_usuario_criacao']}");
			
			$this->view->user = $User;
			$this->view->log = $Log;
		}
	}
	
	public function whoamiAction() {
		$this->getHelper('layout')->disableLayout();
		$this->getHelper('ViewRenderer')->setNoRender();
		
		$User = Zend_Auth::getInstance()->getIdentity();
		$result['message'] = $User->id;
		$result['status'] = true;
		
		$this->getResponse()->setBody(Zend_Json::encode($result));
	}
	
	public function mailtiAction() {
		$this->getHelper('layout')->disableLayout();
		$this->getHelper('ViewRenderer')->setNoRender();
		$Mail = Agro_Db_Table_Abstract:: getDefaultAdapter()->fetchRow("select ds_valor from sistema.configuracao_sistema where ds_nome = 'EMAIL_TI'");
		
		$result['message'] = $Mail['ds_valor'];
		
		$this->getResponse()->setBody(Zend_Json::encode($result));		
	}
}