编辑文件 - Extract.php

✏️ 正在编辑: Extract.php

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

<?php

class Form_Filtro_Extract extends Yuppie_Form_Filtro
{

protected $postRequired = true;
    
    public function init()
    {
        $this->dbtable = Model_Container::getTransactions();

$this->addElement('select', 'type', [
            'label'        => 'Tipo:',
            'multiOptions' => [
                ''            => '',
                'CREDITO'     => 'CRÉDITO',
                'RECEBIMENTO' => 'RECEBIMENTO',
                'SAQUE'       => 'SAQUE',
                'PAGAMENTO'   => 'PAGAMENTO',
                'TARIFA'      => 'TARIFA',
            ]
        ]);

$this->addElement('date', 'initial_date', [
            'label' => 'Data Inicial:',
        ]);

$this->addElement('date', 'final_date', [
            'label' => 'Data Final:',
        ]);

$this->addElement('select', 'situation', [
            'label'        => 'Situação:',
            'multiOptions' => [
                ''          => '',
                'PENDENTE'    => 'PENDENTE',
                'PROCESSANDO' => 'PROCESSANDO',
                'CONCLUIDO'   => 'CONCLUÍDO',
                'RECEBIDO'    => 'RECEBIDO',
                'ERRO'        => 'ERRO',
            ]
        ]);

$this->_initButtons();
        $this->removeElement('new');
    }

public function search()
    {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $id      = get_class($this);
        $ns      = new Zend_Session_Namespace($id);

if ($request->isPost() && $this->isValid($request->getPost())) {
            $ns->unsetAll();
            $ns->$id = $request->getPost();
        }

if ($this->postRequired && (!$ns->$id || !$this->getValues())) {
            return;
        }

return $this->dbtable->extract($this->_getWhere());
    }

protected function _getWhere()
    {
        $fields = $this->getValues();
        $params = [];
        
        if (!empty($fields['type'])) {
            $params['transaction.type = ?'] = $fields['type'];
        }

if (!empty($fields['situation'])) {
            $params['transaction.situation = ?'] = $fields['situation'];
        }

if (!empty($fields['initial_date']) && !empty($fields['final_date'])) {
            $dataDe = new Zend_Date($fields['initial_date'], 'dd/MM/yyyy');
            $params['transaction.created_at >= ?'] = $dataDe->get('yyyy-MM-dd 00:00:00');

$dataA = new Zend_Date($fields['final_date'], 'dd/MM/yyyy');
            $params['transaction.created_at <= ?'] = $dataA->get('yyyy-MM-dd 23:59:59');
        }

return $params;
    }

}

← 返回文件管理器