<?php

class Seguro_Model_PropostaPendencia extends Agro_Db_Table_Abstract {
	protected $_primary = array('id_proposta_status', 'id_pendencia');
	protected $_name = 'propostas_pendencias';
	protected $_schema = 'seguro';
	
	public function save(array $values) {
		$Row = $this->find($values['id_proposta_status'], $values['id_pendencia'])->current();
		if (!$Row) {
			$Row = $this->createRow();
		}
		
		$Row->dt_prazo = ($values['dt_prazo'] ? $values['dt_prazo'] : null);
		$Row->id_proposta_status = $values['id_proposta_status'];
		$Row->id_pendencia = $values['id_pendencia'];
		
		$ret = $Row->save();
		if($ret) {
			return true;
		} else {
			return false;
		} 
	}

	public function getData($id_proposta) {
		$select = $this->select()->setIntegrityCheck(false);
		$select->from(array('ap' => 'atendimento.pendencias'), array('id', 'ds_nome_pendencia'));
		$select->join(array('pp' => 'seguro.propostas_pendencias'), 'ap.id = pp.id_pendencia', false);
		$select->join(array('ps' => 'seguro.propostas_status'), 'pp.id_proposta_status = ps.id', false);
		$select->where('ps.fl_ativo is true');
		$select->where('ps.id_proposta = ?', $id_proposta);

		return $this->fetchAll($select);
	}
}