<?php

class Endosso_Model_Proposta_Observacoes extends Agro_Db_Table_Propostas {
	protected $_name = 'propostas_observacoes';
	protected $_schema = 'seguro';
	protected $_primary = 'id';
	
	public function add($idProposta, $row) {
		$Row = $this->createRow();
		
		$Row->ds_observacao = $row['ds_observacao'];
		$Row->id_proposta = $idProposta;
		$Row->fl_principal = 1;
		$Row->id_usuario_criacao = $row['id_usuario_criacao'];
		$Row->id_usuario_alteracao = $row['id_usuario_alteracao'];
		$Row->fl_ativo = $row['fl_ativo'] ? 1 : 0;
		$Row->fl_del = $row['fl_del'] ? 1 : 0;
		
		return $Row->save();
	}
	
	public function save($row) {
		$Row = $this->fetchRow("id_proposta = {$row['id_proposta']} and fl_principal is true");
		if (!$Row) { $Row = $this->createRow(); }
		
		$Row->ds_observacao = $row['ds_observacao'];
		$Row->id_proposta = $row['id_proposta'];
		$Row->fl_principal = 1;
		
		return $Row->save();
	}
	
	public function save_informacoes($row) {
		$Row = $this->getRow($row['id']);
		
		$Row->ds_observacao = $row['ds_observacao'];
		$Row->id_proposta = $row['id_proposta'];
		$Row->fl_principal = 0;
		
		return $Row->save();
	}
	
}