<?php
class Regulacao_Model_Lvp001Croqui extends Agro_Db_Table_Abstract
{
    protected $_schema = 'regulacao';
    protected $_name = 'lvp001_croqui';
    protected $_primary = 'id';
    public $_order = 'id';

    public function getCroqui(int $id_proposta_vistoria)
    {
        $select = $this->select()->setIntegrityCheck(false)->distinct();
        $select->from(array('pvp' => 'seguro.propostas_vistorias_previas'), 'id_proposta');
        $select->join(array('lvp' => 'regulacao.lvp001'), 'lvp.id_proposta_vistoria = pvp.id', null);
        $select->join(
            array('lvpc' => 'regulacao.lvp001_croqui'),
            'lvpc.id_laudo = lvp.id',
            array('ds_coordenadas_poligono', 'area', 'nome')
        );
        $select->where('pvp.id = ?', $id_proposta_vistoria);

        return $this->getAdapter()->fetchAll($select);
    }

    public function countCroqui($id_laudo) {
        return Agro_Db_Table_Abstract::getDefaultAdapter()->fetchOne(
            'SELECT count(*)
               FROM regulacao.lvp001_croqui
              WHERE id_laudo = '. $id_laudo
        );
    }
}