<?php


class ruas extends ruasDAO
{

    public function ObterPorDistritos($cod)
    {

        # Faz conex�o
        $conexao = new conexaoBanco();
        $conexao->conectar();

        # Executa comando SQL
        $stmt = $conexao->pdo->prepare('SELECT cod_rua, rua_nome, cod_distrito, cod_bairro FROM ruas WHERE cod_distrito = ? ORDER BY cod_rua DESC');

        // Executa Query
        $stmt->bindValue(1, $cod);
        $stmt->execute();
        $retorno = $stmt->fetchAll(PDO::FETCH_ASSOC);

        $lista = array();
        $i = 0;

        foreach ($retorno as $row) {
            #Inst�ncia da entidade
            $ruasBE = new ruasBE();

            #Atribui valores
            $ruasBE->setCod_rua($row['cod_rua']);
            $ruasBE->setRua_nome($row['rua_nome']);
            $ruasBE->setCod_distrito($row['cod_distrito']);
            $ruasBE->setCod_bairro($row['cod_bairro']);

            $lista[$i] = $ruasBE;
            $i++;
        }

        return $lista;
    }

    public function geraTabelaGeral()
    {
        $res = $this->ObterPorTodos();
        $distritos = new distritos();
        $bairros = new bairros();

        echo "<table class='tabelaspesquisa table table-striped table-hover dt-responsive' cellspacing='0' width='100%'>";
        echo "<thead>";
        echo "<th>ID</th>";
        echo "<th>LOGRADOURO</th>";
        echo "<th>DISTRITO</th>";
        echo "<th>BAIRRO</th>";
        echo "<th></th>";
        echo "<th></th>";
        echo "</thead>";
        echo "<tbody>";

        foreach ($res as $r) {
            echo "<tr>";
            echo "<td>" . $r->getCod_rua() . "</td>";
            echo "<td>" . $r->getRua_nome() . "</td>";
            echo "<td>" . $distritos->ObterPorPK($r->getCod_distrito())->getDistrito_nome() . "</td>";
            echo "<td>" . $bairros->ObterPorPK($r->getCod_bairro())->getBairro_nome() . "</td>";
            echo "<td><a href='#' data-toggle='modal' data-target='#myModal" . $r->getCod_rua() . "'>
            <i class='fa fa-edit fa-lg' aria-hidden='true'></i></a></td>";
            echo "<td><a href='#' onclick='excluir(" . $r->getCod_rua() . ")' >
            <i class='txt-red fa fa-remove fa-lg' aria-hidden='true'></i></a></td>";
            echo "</tr>";
            ?>
            <div class="modal fade" id="myModal<?= $r->getCod_rua(); ?>" tabindex="-1" role="dialog"
                 aria-labelledby="myModalLabel">
                <div class="modal-dialog" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span
                                    aria-hidden="true">&times;</span></button>
                            <h4 class="modal-title" id="myModalLabel">Cadastro de Logradouro</h4>
                        </div>
                        <div class="modal-body">
                            <label for="cod_rua">Código</label>
                            <input type="text" disabled class="form-control" id="cod_rua<?= $r->getCod_rua(); ?>"
                                   name="cod_rua"
                                   value="<?=
                                   $r->getCod_rua();
                                   ?>">
                            <label for="nome">LOGRADOURO</label>
                            <input type="text" autofocus class="form-control" id="rua_nome<?= $r->getCod_rua(); ?>"
                                   name="rua_nome"
                                   value="<?= $r->getRua_nome()
                                   ?>">
                            <label for="cod_distrito">DISTRITO</label>
                            <select onchange="bairrocomboUp(this.value, '<?= $r->getCod_rua(); ?>')" class="form-control" name="cod_distrito" id="cod_distrito<?= $r->getCod_rua();
                            ?>">
                                <?php echo $distritos->comboDistritosUpdate($r->getCod_distrito()) ?>
                            </select>
                            <label for="cod_bairro">BAIRRO</label>
                            <select class="form-control" name="cod_bairro" id="cod_bairro<?= $r->getCod_rua(); ?>">
                                <option
                                    value="<?php echo $r->getCod_bairro() ?>"><?php echo $bairros->ObterPorPK($r->getCod_bairro())->getBairro_nome() ?>
                                </option>
                            </select>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-default" data-dismiss="modal">Fechar</button>
                            <button type="button" class="btn btn-primary" data-dismiss="modal"
                                    onclick="update('<?= $r->getCod_rua() ?>')">Salvar
                            </button>
                        </div>
                    </div>
                </div>
            </div>
            <?php
        }
        echo "</tbody>";
        echo "</table>";
    }

    public function comboRuasUpdate($cod)
    {
        $t = $this->ObterPorPK($cod);
        $res = $this->ObterPorTodos();
        echo "<option value='" . $t->getCod_rua() . "' >" . $t->getRua_nome() . "</option>";
        foreach ($res as $r) {
            echo "<option value='" . $r->getCod_rua() . "' >" . $r->getRua_nome() . "</option>";
        }
    }

    public function comboRuas()
    {
        $res = $this->ObterPorTodos();
        foreach ($res as $r) {
            echo "<option value='" . $r->getCod_rua() . "' >" . $r->getRua_nome() . "</option>";
        }
    }
}