Viewing File: /home/cienp/public_html/portal/alt_anim_solc.php
<?
if ($_POST[passa] == 'yes') {
require "$this->include_dir/conecta.php";
$s_id_solc = protecao($_POST[id_solc],'inteiro');
$sql = "SELECT s.*, c.id_colb, c.nm_colb, e.id_estd, e.nu_estd, e.de_titl, ";
$sql .= "DATE_FORMAT(s.dt_inic, '%d/%m/%Y') as dt_inic, ";
$sql .= "DATE_FORMAT(s.dt_finl, '%d/%m/%Y') as dt_finl ";
$sql .= "FROM ".$pref_tabl."anim_estd e, ".$pref_tabl."colb c, ".$pref_tabl."anim_solc s ";
$sql .= "WHERE s.id_colb = c.id_colb ";
$sql .= "AND s.id_estd = e.id_estd ";
$sql .= "AND s.id_solc = '$s_id_solc' ";
$sql .= "LIMIT 1 ";
$res = mysqli_query($conn, $sql);
#echo $sql.'<br>';
if (mysqli_num_rows($res) > 0) {
$linha = mysqli_fetch_array($res);
$qenrq = $linha['fl_enrq'];
$selenrq[$qenrq] = "checked";
?>
<script src="<?php echo $this->site_root?>/vendors/jquery/dist/jquery.min.js"></script><!-- jQuery -->
<script src="<?php echo $this->site_root?>/vendors/moment/min/moment.min.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/moment/locale/pt-br.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/bootstrap-daterangepicker/daterangepicker.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/bootstrap-datetimepicker/build/js/bootstrap-datetimepicker.min.js"></script>
<div class="right_col" role="main">
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Alteração de Solicitação <small>Gerenciador de Solicitação</small></h2>
<div class="clearfix"></div>
</div>
<div class="form-group">
<?php
if ($_GET[certo] == 'S') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alteração de Solicitação!</strong> Sua solicitação foi alterada com sucesso!
</div>";
}
if ($_GET[certo] == 'N') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alteração de Solicitação!</strong> Erro ao efetuar a operação. Entre em contato com o administrador.
</div>";
}
?>
</div>
<div class="x_content">
<br />
<form id="form_locl" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_anim_solc" enctype="multipart/form-data" method="POST" name="form_">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Solicitante <span class="required">*</span></label>
<div class="col-md-3 col-sm-12 col-xs-12">
<select name="id_colb" id="id_colb" class="form-control" required>
<option value="">Selecione</option>
<?php
$sqlfo = "SELECT id_colb, nm_colb ";
$sqlfo .= "FROM ".$pref_tabl."colb ";
$sqlfo .= "WHERE fl_atvo = 'S' ";
$sqlfo .= "ORDER BY nm_colb ";
$resfo = mysqli_query($conn, $sqlfo);
if (mysqli_num_rows($resfo) > 0) {
while ($linhafo = mysqli_fetch_array($resfo)) {
$selforn = '';
if ($linha[id_colb] == $linhafo[id_colb])
$selforn = 'selected';
?>
<option value="<?=$linhafo[id_colb]?>" <?=$selforn?>><?=$linhafo[nm_colb]?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">De Responsável <span class="required">*</span></label>
<div class="col-md-3 col-sm-12 col-xs-12">
<select name="id_resp" id="id_resp" class="form-control" required>
<option value="">Selecione</option>
<?php
$sqlre = "SELECT id_colb, nm_colb ";
$sqlre .= "FROM ".$pref_tabl."colb ";
$sqlre .= "WHERE fl_atvo = 'S' ";
$sqlre .= "ORDER BY nm_colb ";
$resre = mysqli_query($conn, $sqlre);
if (mysqli_num_rows($resre) > 0) {
while ($linhafo = mysqli_fetch_array($resre)) {
$selforn = '';
if ($linha[id_resp] == $linhafo[id_colb])
$selforn = 'selected';
?>
<option value="<?=$linhafo[id_colb]?>" <?=$selforn?>><?=$linhafo[nm_colb]?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Estudo <span class="required">*</span></label>
<div class="col-md-3 col-sm-12 col-xs-12">
<select name="id_estd" id="id_estd" class="form-control" required>
<option value="">Selecione</option>
<?php
$sqlfo = "SELECT id_estd, nu_estd, de_titl ";
$sqlfo .= "FROM ".$pref_tabl."anim_estd ";
$sqlfo .= "WHERE fl_atvo = 'S' ";
$sqlfo .= "ORDER BY de_titl ";
$resfo = mysqli_query($conn, $sqlfo);
if (mysqli_num_rows($resfo) > 0) {
while ($linhafo = mysqli_fetch_array($resfo)) {
$selforn = '';
if ($linha[id_estd] == $linhafo[id_estd])
$selforn = 'selected';
?>
<option value="<?=$linhafo[id_estd]?>" <?=$selforn?>><?=$linhafo[nu_estd]?> - <?=$linhafo[de_titl]?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group" style="margin-bottom:0px;">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Data Início</label>
<div class='col-lg-2 col-md-3 col-sm-3 col-xs-12'>
<div class="form-group">
<div class='input-group date' id='myDatepicker7'>
<input name="dt_inic" type="text" id="dt_inic" class="form-control" value='<?php echo $linha[dt_inic];?>' />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
</div>
<div class="form-group" style="margin-bottom:0px;">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Data Final</label>
<div class='col-lg-2 col-md-3 col-sm-3 col-xs-12'>
<div class="form-group">
<div class='input-group date' id='myDatepicker8'>
<input name="dt_finl" type="text" id="dt_finl" class="form-control" value='<?php echo $linha[dt_finl];?>' />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Nº CEUA <span class="required">*</span></label>
<div class="col-md-3 col-sm-6 col-xs-12">
<input type="text" id="nu_ceua" name="nu_ceua" required="required" class="form-control col-md-7 col-xs-12" maxlength="60" value="<?php echo $linha[nu_ceua];?>">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Duração do experimento <span>(dias)</span></label>
<div class="col-md-3 col-sm-6 col-xs-12">
<input type="tel" id="nu_durc" name="nu_durc" required="required" class="form-control col-md-7 col-xs-12" maxlength="4" value="<?php echo $linha[nu_durc];?>">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Enriquecimento Ambiental</label>
<div class="col-md-6 col-sm-6 col-xs-12" style="margin-top: 7px;">
<input type="radio" class="flat" name="fl_enrq" value="S" <?=$selenrq['S']?>> Sim
<input type="radio" class="flat" name="fl_enrq" value="N" <?=$selenrq['N']?>> Não
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Observação</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_obsr" name="de_obsr" rows="3" placeholder="Digite sua Observação"><?php echo $linha[de_obsr];?></textarea>
</div>
</div>
<div class="form-group text-center">
<small>*Obs: campos obrigatórios</small>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<a href="javascript:voltar();"><button class="btn btn-primary" type="button">Voltar</button></a>
<button type="submit" class="btn btn-success">Alterar</button>
<input name="opc" type="hidden" id="opc" value="alt">
<input type="hidden" name="id_solc" id="id_solc" value="<?=$s_id_solc?>">
<input type="hidden" name="v_id_colb" id="v_id_colb" value="<?=$_POST[v_id_colb]?>">
<input type="hidden" name="v_id_linh" id="v_id_linh" value="<?=$_POST[v_id_linh]?>">
<input type="hidden" name="v_fl_tipo" id="v_fl_tipo" value="<?=$_POST[v_fl_tipo]?>">
<input type="hidden" name="v_id_estd" id="v_id_estd" value="<?=$_POST[v_id_estd]?>">
<input type="hidden" name="v_nu_ceua" id="v_nu_ceua" value="<?=$_POST[v_nu_ceua]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<script>
function voltar() {
document.acidente.action = "index1.php?pg=ver_anim_solc";
document.acidente.submit();
}
$('#myDatepicker7').datetimepicker({
format: 'DD/MM/YYYY',
locale:'pt-br'
});
$('#myDatepicker8').datetimepicker({
format: 'DD/MM/YYYY',
locale:'pt-br'
});
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
<input type="hidden" name="id_solc" id="id_solc" value="<?=$s_id_solc?>">
<input type="hidden" name="opc" id="opc" value="">
<input type="hidden" name="v_id_colb" id="v_id_colb" value="<?=$_POST[v_id_colb]?>">
<input type="hidden" name="v_id_linh" id="v_id_linh" value="<?=$_POST[v_id_linh]?>">
<input type="hidden" name="v_fl_tipo" id="v_fl_tipo" value="<?=$_POST[v_fl_tipo]?>">
<input type="hidden" name="v_id_estd" id="v_id_estd" value="<?=$_POST[v_id_estd]?>">
<input type="hidden" name="v_nu_ceua" id="v_nu_ceua" value="<?=$_POST[v_nu_ceua]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
<input type="hidden" name="passa" id="passa" value="yes">
</form>
<?php
}
} else {
require "erro.php";
}
?>
Back to Directory
File Manager