<?php

class Atendimento_Model_PropostaPendencia extends Agro_Db_Table_Abstract {
	protected $_schema = 'seguro';
	protected $_name = 'propostas_pendencias';
	protected $_primary = array('id_proposta_status', 'id_pendencia');
	
	public function save(array $values) {
		$Row = $this->createRow();
		
		$Row->dt_prazo = Agro_Util::formatDate($values['dt_prazo'], Zend_Date::W3C);
		$Row->id_proposta_status = $values['id_proposta_status'];
		$Row->id_pendencia = $values['id_pendencia'];
		$Row->hr_prazo = $values['hr_prazo'];
		
		return $Row->save();
	}
	
	public function getIdStatusProposta($idProposta) {
		$Select = $this->select()->setIntegrityCheck(false);
		$Select->from(array('ps' => 'seguro.propostas_status'), 'id');
		$Select->where('id_proposta = ?', $idProposta);
		$Select->where('fl_ativo is true');
		
		return $this->getAdapter()->fetchOne($Select);
	}
	
}