<?php

class Relatorio_SistemaController extends Agro_Controller_Report {

	public function init() {
		$this->view->title = 'Relatórios » Sistema » Relatórios disponíveis';
	}

	public function emailvistoriadoresAction() {
		$this->getHelper('ViewRenderer')->setNoRender();
		$this->getHelper('layout')->disableLayout();

		$Sistema = new Relatorio_Model_Sistema();
		$Rs = $Sistema->getVistoriadores();

		$i=0;
		$arr = array();
		foreach ($Rs as $Row) {
			$arr[$i]['ds_nome_fantasia'] = $Row['ds_nome_fantasia'];
			$arr[$i]['ds_email']         = $Row['ds_email'];
			$i++;
		}

		$titles = array(
			'ds_nome_fantasia' => 'Empresa',
			'ds_email' => 'Email'
		);

		switch ($this->getRequest()->getParam('tipo')) {
			case 'excel':
				$Csv = new Agro_Plugin_Rs2Csv();
				$Csv->setRecordSet($arr);
				$Csv->setType("application/octet-stream");
				$Csv->setFileName("relatorio_emissao.csv");
				$Csv->setDisposition("attachment");
				$Csv->setTitles($titles);
				$Csv->setSeparator(";");
				$Csv->getCsv();

				break;
			case 'html':
				$Html = new Agro_Plugin_Rs2Html();
				$Html->setRecordSet($arr);
				$Html->setTitles($titles);
				$Html->getHtml();

				break;
		}
	}

}