<?php

class Sistema_Model_VistoriasLaudosPreliminares extends Agro_Db_Table_Abstract {
	protected $_schema = 'sistema';
	protected $_name = 'vistorias_laudos_preliminares';
	protected $_primary = array('id_vistoria','id_laudo_preliminar');
	protected $_sequence = false;

    public function save(array $data) {
        $Row = $this->find($data['id_vistoria'], $data['id_laudo_preliminar'])->current();
        if (!$Row) $Row = $this->createRow();

        $Row->id_laudo_preliminar = $data['id_laudo_preliminar'];
        $Row->id_vistoria = $data['id_vistoria'];

        return $Row->save();
    }

	public function delete($idVistoria) {
		$this->_db->query("delete from sistema.vistorias_laudos_preliminares where id_vistoria = $idVistoria");
	}

    public function getLaudosByVistoria($idVistoria) {
        $return = null;

        if ($idVistoria) {
            $Select = $this->select()->setIntegrityCheck(false);
            $Select->from(array('vlp' => 'sistema.vistorias_laudos_preliminares'), false);
            $Select->join(array('lf' => 'sinistro.laudos_preliminares'), 'vlp.id_laudo_preliminar = lf.id', 'id as id_laudo');
            $Select->join(array('s' => 'sistema.status'), 'lf.id_status = s.id', 'ds_chave');
            $Select->where('vlp.id_vistoria = ?', $idVistoria);
            $status = $this->fetchRow($Select);

            if ($status) {
                return $status;
            }
        }
        return $return;
    }
}