<?php

class Relatorio_Model_Row_Funcionario extends Agro_Db_Table_Row_Proposta {
	
	public function solicitacoes($filter=false) {
		$Model = new Solicitacao_Model_Tarefa();
		
		$where = array();
		$where[] = "id_executor=$this->id_usuario";
		
		if ($filter){
			if ($filter["id_tarefa_tipo"]){
				$where[] = "id_tarefa_tipo={$filter["id_tarefa_tipo"]}";
			}
			
			if ($filter["id_status"]){
				$where[] = "id_status={$filter["id_status"]}";
			}
			
			if ($filter["data_inicio"]){
				$DataInicio = new Zend_Date($filter["data_inicio"]);
				
				if ($filter["data_fim"]){
					$DataFim = new Zend_Date($filter["data_fim"]);
				} else {
					$DataFim = new Zend_Date();
				}
				
				$where[] = "(dt_criacao BETWEEN '{$DataInicio->get(Zend_Date::W3C)}' and  '{$DataFim->get(Zend_Date::W3C)}')";
			}
		}

		return $Model->fetchAll(implode(" and ", $where), "dt_criacao");
	}
	
}