| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/portais/controller_antigo/publicacao/ext/ |
Upload File : |
<?php
class ufs extends ufsDAO
{
public function gerarCombo()
{
$result = $this->ObterPorCliente();
foreach ($result as $l) {
echo "<option value='" . $l->getCod_uf() . "'>" . $l->getUf_descricao() . "</option>";
}
}
public function ComboEdicao($cod_uf){
$result = $this->ObterPorCliente();
?>
<select class='form-control' name='cod_uf' onchange="combo('cidade', 'combocidades', this.value)">
<option value="<?= $cod_uf ?>"><?= $this->ObterPorPK($cod_uf)->getUf_descricao(); ?></option>
<?php
foreach ($result as $l) {
echo "<option value='" . $l->getCod_uf() . "'>" . $l->getUf_descricao() . "</option>";
}
echo "</select>";
}
public function gerarComboEdicao($cod_uf){
$result = $this->ObterPorTodos();
?>
<select class='form-control' name='cod_uf' onchange="combo('cidade', 'combocidades', this.value)">
<option value="<?= $cod_uf ?>"><?= $this->ObterPorPK($cod_uf)->getUf_descricao(); ?></option>
<?php
foreach ($result as $l) {
echo "<option value='" . $l->getCod_uf() . "'>" . $l->getUf_descricao() . "</option>";
}
echo "</select>";
}
public function ObterPorCliente()
{
# Faz conex�o
$conexao = new conexaoBanco();
$conexao->conectar();
# Executa comando SQL
$stmt = $conexao->pdo->prepare('SELECT cod_uf, uf_nome, uf_descricao, ies_ativo FROM ufs WHERE ies_ativo = 1 ORDER BY cod_uf ASC');
// Executa Query
$stmt->execute();
$retorno = $stmt->fetchAll(PDO::FETCH_ASSOC);
$lista = array();
$i = 0;
foreach ($retorno as $row) {
#Inst�ncia da entidade
$ufsBE = new ufsBE();
#Atribui valores
$ufsBE->setCod_uf($row['cod_uf']);
$ufsBE->setUf_nome($row['uf_nome']);
$ufsBE->setUf_descricao($row['uf_descricao']);
$ufsBE->setIes_ativo($row['ies_ativo']);
$lista[$i] = $ufsBE;
$i++;
}
return $lista;
}
}