编辑文件 - Bonificacao.php

✏️ 正在编辑: Bonificacao.php

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

<?php

class Model_Bonificacao
{

private $_id;
    private $_bancoId;
    private $_descricao;
    private $_frequencia;
    private $_percentual;
    private $_dataInicial;
    private $_dataFinal;
    private $_excluido;

public function getId()
    {
        return $this->_id;
    }

public function setId($id)
    {
        $this->_id = $id;
    }

public function getBancoId()
    {
        return $this->_bancoId;
    }

public function setBancoId($bancoId)
    {
        $this->_bancoId = $bancoId;
    }

public function getDescricao()
    {
        return $this->_descricao;
    }

public function setDescricao($descricao)
    {
        $this->_descricao = $descricao;
    }

public function getFrequencia()
    {
        return $this->_frequencia;
    }

public function setFrequencia($frequencia)
    {
        $this->_frequencia = $frequencia;
    }

public function getPercentual()
    {
        return $this->_percentual;
    }

public function setPercentual($percentual)
    {
        $this->_percentual = $percentual;
    }

public function getDataInicial()
    {
        return $this->_dataInicial;
    }

public function setDataInicial($dataInicial)
    {
        if( !empty($dataInicial) ){
            try {
                $data = new Zend_Date($dataInicial, Zend_Date::DATES, 'pt');
                $dataInicial = $data->toString('yyyy-MM-dd');
            } catch ( Zend_Date_Exception $e ) {
                echo $e->getMessage();
                $dataInicial = null;
            }
        } else {
            $dataInicial = null;
        }
        $this->_dataInicial = $dataInicial;
    }

public function getDataFinal()
    {
        return $this->_dataFinal;
    }

public function setDataFinal($dataFinal)
    {
        if( !empty($dataFinal) ){
            try {
                $data = new Zend_Date($dataFinal, Zend_Date::DATES, 'pt');
                $dataFinal = $data->toString('yyyy-MM-dd');
            } catch ( Zend_Date_Exception $e ) {
                echo $e->getMessage();
                $dataFinal = null;
            }
        } else {
            $dataFinal = null;
        }
        $this->_dataFinal = $dataFinal;
    }

public function getExcluido()
    {
        return $this->_excluido;
    }

public function setExcluido($excluido)
    {
        $this->_excluido = $excluido;
    }

public function __construct($options = null)
    {
        if( is_array($options) ){
            $this->setOptions($options);
        }
    }

public function setOptions(array $options)
    {
        $methods = get_class_methods($this);

foreach ( $options as $key => $value ) {
            $explode = explode("_", $key);
            $methodName = '';

foreach ( $explode as $v ) {
                $methodName .= ucfirst($v);
            }

$key = $methodName != '' ? $methodName : $key;

$method = 'set' . ucfirst($key);
            if( in_array($method, $methods) ){
                $this->$method($value);
            }
        }
        return $this;
    }

public function _toArray()
    {

$dbtable = new Model_DbTable_Rota();
        $info = $dbtable->info();

$methods = get_class_methods($this);

$data = array();

foreach ( $info['cols'] as $key ) {
            $col = $key;
            $explode = explode("_", $key);
            $methodName = '';

foreach ( $explode as $v ) {
                $methodName .= ucfirst($v);
            }

$key = $methodName != '' ? $methodName : $key;
            $method = 'get' . ucfirst($key);

if( in_array($method, $methods) ){
                $data[$col] = $this->$method();
            }
        }

return $data;
    }

/**
     * Insere ou altera o registro passado por parâmetro
     * @param Model_Rota $rota
     */
    public function salvar(Model_Rota $rota)
    {
        $dbtable = new Model_DbTable_Rota();

if( $rota->getId() > 0 ){
            $dbtable->update($rota->_toArray(), "id = " . $rota->getId());
            return $rota->getId();
        } else {
            return $dbtable->insert($rota->_toArray());
        }
    }

/**
     * Exclui o registro passado por parâmetro
     * @param int $id
     * @return int      The number of rows deleted
     */
    public function excluir($id)
    {

if( $id > 0 ){
            $dbtable = new Model_DbTable_Rota();
            return $dbtable->delete("id = " . $id);
        }

return null;
    }

/**
     * Retorna uma lista
     * @param string $where
     * @param string $order
     * @param int $count
     * @param int $offset
     * @return array
     */
    public function listar($where = null, $order = null, $count = null, $offset = null)
    {
        $dbtable = new Model_DbTable_Rota();
        return $dbtable->fetchAll($where, $order, $count, $offset);
    }

/**
     * Retorna um fetchRow do item passado por parâmetro
     * @param int $id
     * @return Zend_Db_Table_Row_Abstract | null
     */
    public function exibir($id)
    {
        $dbtable = new Model_DbTable_Rota();
        return $dbtable->fetchRow("id = " . $id);
    }

public function getRotasIdBySupervisor($supervisorId)
    {
        if( $supervisorId > 0 ){
            $dbtable = new Model_DbTable_Rota();
            $select = $dbtable->getAdapter()->select()->from('tb_rotas', array( 'id' ))
                    ->where("gerente_id = {$supervisorId}");
            $rotas = $dbtable->getAdapter()->fetchCol($select);
            return $rotas;
        }

return null;
    }
    
    
    public function getTotalValores($id)
    {
        if( $id > 0 ){
            $dbtable = new Model_DbTable_Rota();
            $select = $dbtable->getAdapter()->select()->from('tb_rotas', array( 'id','total_valores' => '(SUM(valor_hospedagem)+SUM(valor_refeicao)+SUM(valor_combustivel))' ))
                    ->where("tb_rotas.id = {$id}");   
            $total = $dbtable->getAdapter()->fetchRow($select);
            return $total;
        }

return null;
    }

}

← 返回文件管理器