<?php

class Sistema_Model_Regioes extends Agro_Db_Table_Abstract {
	public $_pairs = array('key' => 'id', 'field' => 'ds_nome_regiao');
	protected $_schema = 'sistema';
	protected $_name = 'regioes';
	protected $_primary = 'id';
	public $_order = 'ds_nome_regiao';

	public $_columnExcel = array(
		'id' => 'Cod.',
		'ds_nome_regiao' => 'Regiao'
	);

	public function getCombo($field='ds_sigla', $idPais='', $first=true) {
		if ($idPais) {
			$Rs = $this->fetchAll("id_pais = $idPais", $field);
		} else {
			$Rs = $this->fetchAll("1=1", $this->_order);
		}

		if (is_object($Rs)) {
			if ($first) $options[] = '';
			foreach ($Rs as $row) {
				$options[$row->id] = $row->{$field};
			}

			return $options;
		} else {
			return false;
		}
	}


}