编辑文件 - ProtocoloPagamento.php

✏️ 正在编辑: ProtocoloPagamento.php

路径: /srv/systems_dir/yuppiecred/application/models/DbTable/ProtocoloPagamento.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php

class Model_DbTable_ProtocoloPagamento extends Core_DbTable
{

protected $_primary = 'id';
    protected $_name = 'tb_protocolo_pagamento';
    protected static $_viewName = 'vw_protocolos_pagamento';
    
    protected $_dependentTables = array(
        'Model_DbTable_Contrato',
        'Model_DbTable_ProtocoloContrato',
        'Model_DbTable_ProtocoloValorRecuperado'
    );
    
    protected $_referenceMap = array(
        'Corretor' => array(
            'columns' => array('corretor_id'),
            'refTableClass' => 'Model_DbTable_Corretor',
            'refColumns' => array('id')
        ),
        'FormaPagamento' => array(
            'columns' => array('forma_pagamento_id'),
            'refTableClass' => 'Model_DbTable_Tipos',
            'refColumns' => array('id')
        ),
        'BancoFebraban' => array(
            'columns' => array( 'banco' ),
            'refTableClass' => 'Model_DbTable_BancoFebraban',
            'refColumns' => array( 'codigo' )
        ),
        'Conta' => array(
            'columns' => array( 'conta_id' ),
            'refTableClass' => 'Model_DbTable_Conta',
            'refColumns' => array( 'id' )
        )
    );
    
    public static function getViewName()
    {
        return self::$_viewName;
    }
    
    public function excluirProtocolo($protocoloId)
    {
        //deleta os protocolos dos contratos
        $item = new Model_DbTable_ProtocoloContrato();
        $item->delete("protocolo_id = $protocoloId");
        
        return parent::delete("id = $protocoloId");
    }

public function getProtocolosExclusao($ids)
    {
        $dbtable = new Model_DbTable_ProtocoloPagamento();
        $select = $dbtable->getAdapter()->select()
            ->from([$this->_name], ['id', 'data_quitacao'])
            ->where('id IN (?)', new Zend_Db_Expr(implode(',', $ids)));

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

← 返回文件管理器