<?php

class Sistema_Model_Agencias extends Agro_Db_Table_Abstract {
	protected $_schema = 'sistema';
	protected $_name = 'agencias';
	protected $_primary = 'id';
	public $_order = 'ds_nome_agencia';

	public function save($data) {
		$Row = $this->getRow($data['id']);

		$Row->id_banco = $data['id_banco'];
		$Row->ds_agencia = $data['ds_agencia'];
		$Row->ds_nome_agencia = $data['ds_nome_agencia'];
		$Row->ds_cnpj = $data['ds_cnpj'];

		return $Row->save();
	}

	public function getData($where=false) {
		$Select = $this->select()->setIntegrityCheck(false);
		$Select->from(array('a' => 'sistema.agencias'));
		$Select->join(array('b' => 'sistema.bancos'), 'a.id_banco = b.id', 'ds_nome_banco');

		if (is_array($where)) {
			foreach ($where as $clause) {
				if (is_array($clause)) {
					$field = $clause['field'];
					$operator = $clause['operator'];
					$value = $clause['value'];
					$Select->where("$field $operator ?", $value);
				} else {
					$Select->where($clause, '');
				}
			}
		} elseif ($where != '') {
			$Select->where($where);
		}

		$Select->order($this->_order);
		return $Select;
	}
}