Viewing File: /home/cienp/public_html/portal/alt_solc_item.php
<?
if ($_POST[passa] == 'yes') {
$s_id_item = protecao($_POST[id_item],'inteiro');
$s_id_comp = protecao($_POST[id_comp],'inteiro');
$sql = "SELECT c.*, u.nm_user, t.de_tipo, ";
$sql .= "DATE_FORMAT(c.dt_cads, '%d/%m/%Y') as dt_cads ";
$sql .= "FROM ".$pref_tabl."comp c, ".$pref_tabl."solc_tipo t, ".$pref_tabl."user u ";
$sql .= "WHERE c.id_cads = u.id_user ";
$sql .= "AND c.id_tipo = t.id_tipo ";
$sql .= "AND c.id_comp = $s_id_comp ";
$sql .= "LIMIT 1";
#echo $sql.'<br>';
$res = mysqli_query($conn, $sql);
if (mysqli_num_rows($res) > 0) {
$linha = mysqli_fetch_array($res);
}
// verifica se esta na situação Aguardando Recebimento e desabilita campos
// retirado por Jarbas em 04/02/21
// if ($linha[id_sitc] == 8) {
// $de_desb = 'disabled';
// $de_opcs = 'alt_recb';
// } else {
$de_opcs = 'alt_item';
// }
$sqlit = "SELECT i.id_item, i.nu_qtde, i.de_item, i.nu_valr, ";
$sqlit .= "DATE_FORMAT(i.dt_recb, '%d/%m/%Y') as dt_recb ";
$sqlit .= "FROM ".$pref_tabl."item i ";
$sqlit .= "WHERE i.id_item = $s_id_item ";
$sqlit .= "LIMIT 1";
#echo $sql.'<br>';
$resit = mysqli_query($conn, $sqlit);
if (mysqli_num_rows($resit) > 0) {
$linhait = mysqli_fetch_array($resit);
?>
<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="row">
<div class="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="x_content">
<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>Inserção de Solicitação!</strong> Sua Solicitação foi inserida com sucesso!
</div>";
?>
</div>
<div class="row">
<div class="col-xs-12">
<h1 class="text_mobl">
O<?php echo $linha[fl_ocos];?> N° <?php echo $linha[nu_oc];?>
<small class="pull-right">Data de Solicitação: <?php echo $linha[dt_cads];?></small>
</h1>
</div>
</div>
<div class="row">
<div class="col-sm-12 text_mobl_item">
<div class="form-group" align="center" style="font-size: 16px;">
<p><b>Solicitante:</b> <?php echo $linha[nm_user];?></p>
<p><b>Tipo de Solicitação:</b> <?php echo $linha[de_tipo];?></p>
</div>
</div>
</div>
</div>
<div class="x_title">
<h2>Item da Solicitação <small>Gerenciador do Item da Solicitação</small></h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<div class="row">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" enctype="multipart/form-data" method="POST" name="tstest">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Quantidade</label>
<div class="col-md-1 col-sm-6 col-xs-12">
<input type="text" id="nu_qtde" name="nu_qtde" class="form-control col-md-7 col-xs-12" maxlength="9" value="<?php echo moeda($linhait['nu_qtde']);?>" <?php echo $de_desb;?>>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Valor</label>
<div class="col-md-1 col-sm-6 col-xs-12">
<input type="text" id="nu_valr" name="nu_valr" class="form-control col-md-7 col-xs-12" value="<?php echo moeda($linhait['nu_valr']);?>" <?php echo $de_desb;?>>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Descrição</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="de_item" name="de_item" class="form-control col-md-7 col-xs-12" value="<?=$linhait['de_item']?>" <?php echo $de_desb;?>>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Data de recebimento:</label>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class='input-group date' id='myDatepicker2'>
<input type='text' class="form-control" id="dt_recb" name="dt_recb" value="<?php echo $linhait['dt_recb'];?>" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</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 class="btn btn-primary" type="reset">Resetar</button>
<button type="submit" class="btn btn-success">Enviar</button>
<input name="opc" type="hidden" id="opc" value="<?php echo $de_opcs;?>">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input name="id_item" type="hidden" id="id_item" value="<?php echo $s_id_item;?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<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 name="passa" type="hidden" id="passa" value="yes">
</div>
</div>
</form>
<br />
</div>
</div>
</div>
</div>
</div>
</div>
<script>
function ver_finl() {
if (confirm('Tem certeza que deseja finalizar a inserção dos itens da solicitação?')) {
document.acidente.action = "index1.php?pg=sql_solc";
document.acidente.opc.value = 'finl_pree';
document.acidente.submit();
}
}
function voltar() {
document.acidente.action = "index1.php?pg=alt_solc";
document.acidente.submit();
}
$('#myDatepicker2').datetimepicker({
format: 'DD/MM/YYYY',
locale:'pt-br'
});
$(document).ready(function(){
$("#nu_qtde").inputmask('decimal', {
'alias': 'numeric',
'groupSeparator': '.',
'autoGroup': true,
'digits': 2,
'radixPoint': ",",
'digitsOptional': false,
'allowMinus': false,
'placeholder': ''
});
$("#nu_valr").inputmask('decimal', {
'alias': 'numeric',
'groupSeparator': '.',
'autoGroup': true,
'digits': 2,
'radixPoint': ",",
'digitsOptional': false,
'allowMinus': false,
'placeholder': ''
});
});
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
<input type="hidden" name="opc" id="opc">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<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>
<?
}
if ($_GET[certo] == 'E')
echo "<script language=\"javascript\">alertErro('Erro ao efetuar a operação. Erro na sql de inserção!');</script>";
if ($_GET[certo] == 'S')
echo "<script language=\"javascript\">alertSucesso('O Tipo de solicitação foi inserido corretamente!');</script>";
if ($_GET[certo] == 'J')
echo "<script language=\"javascript\">alertErro('Erro ao efetuar a operação. Tipo de solicitação já cadastrado!');</script>";
} else
require "erro.php";
?>
Back to Directory
File Manager