<?php

class Sinistro_Model_TransmissaoAvisosEssor extends Agro_Db_Table_Abstract {
	protected $_schema = 'sinistro';
	protected $_name = 'avisos';
	protected $_view = 'v_avisos_transmissao_essor';
	protected $_primary = 'id';
	//public $_order = array('id_proposta','id');

	public function save($dados) {
	}

	public function getData($where=false) {
		$select = $this->select();
		
		$select->setIntegrityCheck(false);
		$select->from("{$this->_schema}.{$this->_view}");		

		if ($this->_order) {
			$select->order($this->_order);
		}

		if (is_array($where)) {
			foreach ($where as $clause) {
				if (is_array($clause)) {
					$field = $clause['field'];
					$operator = $clause['operator'];
					$value = $clause['value'];

					if (is_numeric($value)) {
						$select->where("$field $operator ?", $value);
					} else {
						$select->where("normalize($field) $operator normalize(?)", $value);
					}
				} else {
					$select->where($clause, '');
				}
			}
		} elseif ($where != '') {
			$select->where($where);
		}

		return $select;
	}
}