404

D7net
:/ var / www / html / novonote / adm / app / adms / Models / helper /
Filename : AdmsView.php
back
<?php

namespace App\adms\Models\helper;

use PDO;

if (!defined('URL')) {
    header("Location: /");
    exit();
}

/**
 * Description of StsRead
 *
 * @copyright (c) year, Cesar Szpak - Celke
 */
class AdmsView extends AdmsConn
{

    private $Select;
    private $Values;
    private $Resultado;
    private $Query;
    private $Conn;

    function getResultado()
    {
        return $this->Resultado;
    }

    public function exeRead($Tabela, $Termos = null, $ParseString = null)
    {
        if (!empty($ParseString)) {
            parse_str($ParseString, $this->Values);
        }
        
        $this->Select = "call {$Tabela}.()";
        var_dump($Tabela);
	var_dump($Termos);	
	
     	
        $this->exeInstrucao();
    }

    public function fullRead($Query, $ParseString = null)
    { 
       
        $this->Select = (string) $Query;
        if (!empty($ParseString)) {
            parse_str($ParseString, $this->Values);
        }
       
        $this->exeInstrucao();
    }
    
    private function exeInstrucao()
    {
        $this->conexao();
        try {
            $this->getIntrucao();
            
            $this->Query->execute();
            $this->Resultado = $this->Query->fetchAll();
            
        } catch (Exception $ex) {
            $this->Resultado = null;
        }
    }

    private function conexao()
    {
        $this->Conn = parent::getConn();
        $this->Query = $this->Conn->prepare($this->Select);
        $this->Query->setFetchMode(PDO::FETCH_ASSOC);
    }

    private function getIntrucao()
    {
        if ($this->Values) {
            foreach ($this->Values as $Link => $Valor) {
                if ($Link == 'limit' || $Link == 'offset') {
                    $Valor = (int) $Valor;
                }
                $this->Query->bindValue(":{$Link}", $Valor, (is_int($Valor) ? PDO::PARAM_INT : PDO::PARAM_STR));
            }
        }
    }

}