Viewing File: /home/cienp/public_html/portal/ver_almx_entr.php
<?
if ($_POST[passa] == 'yes') {
require "$this->include_dir/conecta.php";
$s_id_entr = protecao($_POST[id_entr],'inteiro');
$sql = "SELECT e.id_entr, e.nu_qtde, e.vl_unit, e.nu_nota, e.id_locl, p.id_prdt, p.nm_prdt, p.nu_item, ";
$sql .= "c.sg_clas, s.id_setr, s.nm_setr, e.id_marc, e.id_cond, e.de_obsr, ";
$sql .= "DATE_FORMAT(e.dt_entr, '%d/%m/%Y') as dt_ent2 ";
$sql .= "FROM ".$pref_tabl."almx_prdt p, ".$pref_tabl."almx_clas c, ".$pref_tabl."setr s, ";
$sql .= $pref_tabl."almx_entr e ";
$sql .= "WHERE e.id_setr = s.id_setr ";
$sql .= "AND e.id_prdt = p.id_prdt ";
$sql .= "AND p.id_clas = c.id_clas ";
$sql .= "AND e.id_entr = '$s_id_entr' ";
$sql .= "LIMIT 1";
$res = mysqli_query($conn, $sql);
if (mysqli_num_rows($res) > 0) {
$linha = mysqli_fetch_array($res);
$linha['de_obsr'] = nl2br($linha['de_obsr']);
$nu_item = $linha['sg_clas'].'-'.str_pad($linha['nu_item'], 5, "0", STR_PAD_LEFT);
$sqlnn = "SELECT n1.de_locl as de_locl1, n2.de_locl as de_locl2, ";
$sqlnn .= "n3.de_locl as de_locl3, n4.de_locl as de_locl4 ";
$sqlnn .= "FROM ".$pref_tabl."almx_locl n1, ".$pref_tabl."almx_locl n2, ";
$sqlnn .= $pref_tabl."almx_locl n3, ".$pref_tabl."almx_locl n4 ";
$sqlnn .= "WHERE n4.id_locl_pais = n3.id_locl ";
$sqlnn .= "AND n3.id_locl_pais = n2.id_locl ";
$sqlnn .= "AND n2.id_locl_pais = n1.id_locl ";
$sqlnn .= "AND n4.id_locl = $linha[id_locl] ";
$sqlnn .= "LIMIT 1 ";
$resnn = mysqli_query($conn, $sqlnn);
if (mysqli_num_rows($resnn) > 0) {
$linhann = mysqli_fetch_array($resnn);
}
if ($linha['id_marc'] > 0) {
$sqldp = "SELECT id_marc, de_marc ";
$sqldp .= "FROM ".$pref_tabl."almx_marc ";
$sqldp .= "WHERE id_marc = '$linha[id_marc]' ";
$sqldp .= "LIMIT 1 ";
$resdp = mysqli_query($conn, $sqldp);
if (mysqli_num_rows($resdp) > 0) {
$linhadp = mysqli_fetch_array($resdp);
}
}
if ($linha['id_cond'] > 0) {
$sqlcd = "SELECT id_cond, de_cond ";
$sqlcd .= "FROM ".$pref_tabl."almx_cond ";
$sqlcd .= "WHERE id_cond = '$linha[id_cond]' ";
$sqlcd .= "LIMIT 1 ";
$rescd = mysqli_query($conn, $sqlcd);
if (mysqli_num_rows($rescd) > 0) {
$linhacd = mysqli_fetch_array($rescd);
}
}
?>
<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">
<di class="x_panel">
<div class="x_title">
<h2>Visualizar Entrada de Almoxarifado</h2>
<ul class="nav navbar-right panel_toolbox">
<li>
<a href="javascript:exc_almx_entr('<?php echo $linha['id_entr'] ?>')" style="padding:0px;"><button class="btn btn-danger" type="button">Excluir</button></a>
</li>
<li>
<a href="javascript:voltar();" style="padding:0px;"><button class="btn btn-primary" type="button">Voltar</button></a>
</li>
</ul>
<div class="clearfix"></div>
</div>
<?php
if ($_GET[certo] == 'X') {
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>Visualizar Entrada de Almoxarifado!</strong> A entrada de almoxarifado foi excluída com sucesso!
</div>";
}
?>
<div class="x_content">
<div class="row">
<br />
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>N°:</b> <?php echo $linha['id_entr'];?></p>
<p><b>NF:</b> <?php echo $linha['nu_nota'];?></p>
<p><b>Produto:</b> <?php echo $nu_item;?> - <?php echo $linha['nm_prdt'] ?></p>
<p><b>Setor:</b> <?php echo $linha['nm_setr'];?></p>
<p><b>Local:</b> <?php echo $linhann['de_locl1'] ?>, <?php echo $linhann['de_locl1'] ?>, <?php echo $linhann['de_locl3'] ?>, <?php echo $linhann['de_locl4'] ?></p>
<p><b>Condição de recebimento:</b> <?php echo $linhacd['de_cond'];?></p>
</div>
</div>
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>Quantidade:</b> <?php echo moeda($linha['nu_qtde']);?></p>
<p><b>Valor Unitário:</b> R$ <?php echo moeda($linha['vl_unit']);?></p>
<p><b>Valor Total:</b> R$ <?php echo moeda($linha['vl_unit']*$linha['nu_qtde']); ?></p>
<p><b>Data Entrada:</b> <?php echo $linha['dt_ent2'];?></p>
<p><b>Marca:</b> <?php echo $linhadp['de_marc'];?></p>
</div>
</div>
<div class="col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>Observação:</b> <?php echo $linha['de_obsr'];?></p>
</div>
</div>
<br />
</div>
</div>
</div>
</div>
</div>
</div>
<SCRIPT LANGUAGE="javascript">
function exc_almx_entr(xb){
if (confirm('Você tem certeza que deseja excluir essa entrada?')) {
document.acidente.action = "index1.php?pg=sql_almx_entr";
document.acidente.id_entr.value = xb;
document.acidente.opc.value = 'exc';
document.acidente.submit();
}
}
function voltar() {
document.acidente.action = "index1.php?pg=res_almx_entr";
document.acidente.submit();
}
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
<input type="hidden" name="id_entr" id="id_entr">
<input type="hidden" name="opc" id="opc">
<input type="hidden" name="v_id_prdt" id="v_id_prdt" value="<?=$_POST[v_id_prdt]?>">
<input type="hidden" name="v_id_setr" id="v_id_setr" value="<?=$_POST[v_id_setr]?>">
<input type="hidden" name="v_id_entr" id="v_id_entr" value="<?=$_POST[v_id_entr]?>">
<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>
<?
}
} else
require "erro.php";
?>
Back to Directory
File Manager