<?php
    ini_set('display_errors', 'on');
    $id    = $_GET['id'];
    $idend = $_GET['idend'];
    //$conn  = conexao::getInstance();
    $proce = $conn->query("select * from processos WHERE codigo='$id'");
    $d     = $proce->fetch(PDO::FETCH_OBJ);
    //ABAS
    $prazo = $conn->query("select * from prazos where cod_proc='$id' ORDER BY data_venc DESC");
    $a     = $prazo->fetch(PDO::FETCH_OBJ);

    $alarme  = $conn->query("select * from alarmes where cod_prazo='$a->codigo'");
    $alarme1 = $conn->query("select * from alarmes where cod_prazo='$a->codigo'");
    $ala     = $alarme1->fetch(PDO::FETCH_OBJ);

    $tip_prazo = $conn->query("select * from tipo_prazos ORDER BY tipo_prazo DESC");
?>
<script src="js/mascara.js" type="text/javascript"></script>
<div class="panel panel-primary active" style="font-size: 17px;" align="center">
    Prazo | Edição
</div>
<div>
    <form id="form2" name="form2" OnSubmit="showCarga()" id="frm_andamento" method="post" action="?page=processos/info_crud&var=prazo_edt">
        <a name="anda">
            <input type='hidden' name='codigo' value="<?php echo $a->codigo ?>"/>
            <input type='hidden' name='cod_proc' value="<?php echo $d->codigo ?>"/>
            <input type='hidden' name='num_proc' value="<?php echo $d->n_processo ?>"/>
            <input type='hidden' name='status' value="1"/>

            <div class="col-lg-4 col-md-4 col-sm-4 col-xs-8">
                <a class='j50 link' href="index2.php?page=auxi/prazo_cad">
                    <i class='fa fa-plus-circle'></i>&nbsp;Tipo de prazo</a>&nbsp;&nbsp;
                <i class='fa fa-refresh' onclick="combo('cod_fase','sel_fase','0')" style="cursor: hand;"></i>
                <script src="js/index.js"></script>
                <div id="cod_fase">
                    <select id="cod_tipo_prazo" name="cod_tipo_prazo" class="form-control">
                        <?php while ($iprazo = $tip_prazo->fetch(PDO::FETCH_OBJ)) {
                            if ($a->cod_tipo_prazo==$iprazo->codigo) {
                                $selected = 'selected';
                            } else {
                                $selected = '';
                            } ?>
                            <option value="<?php echo $iprazo->codigo ?>"<?php echo $selected; ?>><?php echo $iprazo->tipo_prazo ?></option>
                        <?php } ?>
                    </select>
                </div>
            </div>
            <div class='col-xs-4 col-sm-2 col-md-2 col-lg-2'>
                <label for='data_publicacao'>Publicação</label>
                <input type='text' class='form-control' name='data_publicacao' id='data_publicacao' value="<?php echo date('d/m/Y', strtotime($a->data_publicacao)) ?>"/></div>
            <div class='col-xs-4 col-sm-6 col-md-6 col-lg-6'>
                <label for='descricao'>Descrição</label>
                <input type='text' class='form-control upper' name='descricao' id='descricao' value="<?php echo $a->descricao ?>"/></div>
            <div class='col-xs-12 col-sm-12 col-md-12 col-lg-12'>
                <label for='obs'>Observação</label>
                <textarea class='form-control' name='obs' id='obs' cols='1' rows='2'><?php echo $a->obs ?></textarea></div>
            <div class='col-xs-12 col-sm-12 col-md-12 col-lg-12'>
                <label for='email'>E-mail para aviso <span style="font-size: 11px;">(para mais de um destinatário, separar com vírgula)</span></label>
                <input type='text' class='form-control lower' maxlength="500" name='email' id='email' value="<?php echo $ala->email ?>"/></div>
            <div class='col-xs-6 col-sm-3 col-md-3 col-lg-3'>
                <label for='data_venc'>Vencimento prazo</label>
                <input type='date' class='form-control' name='data_venc' id='data_venc' value="<?php echo $a->data_venc ?>"/></div>
            <div class='col-xs-4 col-sm-2 col-md-2 col-lg-2'>
                <label for='hora_venc'>Hora</label>
                <input type='text' class='form-control' name='hora_venc' id='hora_venc' value="<?php echo $a->hora_venc ?>"/></div>
            <div class='col-xs-2 col-sm-2 col-md-2 col-lg-2'>
                <label for='bt_novo'>&nbsp;</label>
                <br>
                <button type="submit" name="bt_novo" class="btn btn-primary form-control"><i class="glyphicon glyphicon-ok"></i></button>
            </div>
            <div class='col-xs-12 col-sm-12 col-md-12 col-lg-12 panel-body'>
                <table id="id_alarme" class='table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
                    <thead>
                    <tr class="success">
                        <th width="2%">ID</th>
                        <th>Alarme</th>
                        <th>Vencimento</th>
                        <th>Hora</th>
                    </tr>
                    </thead>
                    <tbody>
                    <?php
                        while ($alm = $alarme->fetch(PDO::FETCH_OBJ)) {
                            echo "<tr>";
                            echo "<td>" . $alm->codigo . "</td>";
                            echo "<td>" . $alm->descricao . "</td>";
                            echo "<td>" . date('d/m/Y', strtotime($alm->data)) . "</td>";
                            echo "<td>" . $alm->hora . "</td>";
                            echo "</tr>";
                        }
                    ?>
                    </tbody>
                </table>
            </div>
        </a>
    </form>
</div>