public function count($condicao = "")
{
try {
if (!empty($condicao)) {
$query = 'SELECT COUNT(*) AS total FROM ' . self::$tabela . ' WHERE excluido = 0 AND ' . $condicao;
} else {
$query = 'SELECT COUNT(*) AS total FROM ' . self::$tabela . ' WHERE excluido = 0';
}
$result = $this->conexao->prepare($query);
$result->execute();
$resultado = $result->fetch(PDO::FETCH_ASSOC);
return $resultado['total'];
} catch (PDOException $e) {
Conexao::alertaEnviaEmail("<code>" . $e->getMessage() . "</code>", $_SERVER['SCRIPT_NAME']);
}
}
protected function selecionarPorId($model, $id)
{
try {
$result = $this->conexao->prepare("SELECT *\n\t\t\t\t\t\t\t\t\t\t \t FROM " . $model::$tabela . "\n\t\t\t\t\t\t\t\t\t\t \t WHERE id = :id");
$result->bindParam(':id', $id, PDO::PARAM_INT);
$result->execute();
$linha = $result->fetch(PDO::FETCH_ASSOC);
$arrayModel = get_object_vars($model);
foreach ($arrayModel as $indice => $valor) {
if (!in_array($indice, array('tabela', 'conexao'))) {
$model->{$indice} = $linha[$indice];
}
}
} catch (PDOException $e) {
Conexao::alertaEnviaEmail("<code>" . $e->getMessage() . "</code>", $_SERVER['SCRIPT_NAME']);
}
}
