| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ 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/merenda/itapipoca19/modulos/movimento/ |
Upload File : |
<?php
/**
* Criado por PhpStorm.
* Projeto: SGAE.
* Arquivo: implanta_edt.php.
* Usuário: RalpAlves
* Data: 21/09/2015
* Hora: 15:23
*/
session_start();
$id_usu = $_SESSION['idusu'];
$usuario = $_SESSION['txt_usuario'];
$direito = $_SESSION['admin'];
$cod_id = $_GET['cod_id'];
$rs_imp = mysql_query("SELECT * FROM implantacao_esc where imp_id=$cod_id");
$rs_row = mysql_fetch_array($rs_imp);
$id_inv = $rs_row['imp_id'];
$rs_ite = mysql_query("SELECT * FROM v_lista_implantacao_esc_item where imi_imp_id=$id_inv");
$rs_prg = mysql_query("SELECT * FROM programa order by prg_programa");
$rs_prd = mysql_query("SELECT * FROM v_lista_prod WHERE pro_tipo=1 order by pro_produto");
$rs_und = mysql_query("SELECT * FROM unidade where und_ativo='1'");
$rs_esc = mysql_query("SELECT * FROM escolas ORDER BY esc_nome");
?>
<head xmlns="http://www.w3.org/1999/html">
<script type="text/javascript">
$(document).ready(function () {
$('#tabela').DataTable({
"pagingType": "full_numbers", "lengthMenu": [[8, 25, 50, -1], [8, 25, 50, "Todos"]], stateSave: true, "oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<em class='fa fa-search' title='pesquisar'></em>",
"sUrl": "",
"oPaginate": {
"sFirst": "<em class='fa fa-angle-double-left' title='primeiro registro'>",
"sPrevious": "<em class='fa fa-arrow-circle-left' title='registro anterior'></em>",
"sNext": "<em class='fa fa-arrow-circle-right' title='próximo registro'></em>",
"sLast": "<em class='fa fa-angle-double-right ' title='último registro'>"
}
}
});
});
</script>
<script type="text/javascript">
function excluir_registro(e) {
if (!confirm('Deseja realmente excluir este registro?')) {
if (window.event)
window.event.returnValue = false; else
e.preventDefault();
}
}
</script>
</head>
<!--FORMULARIO-->
<body style="padding-top: 40px;"/>
<div class="container">
<div class="panel panel-primary">
<div class="panel-body">
<button type="submit" id="#sign-up" name="bt_novo" class="btn botao_esquerda" onClick="location.href='?page=movimento/implanta'"><span
class="glyphicon glyphicon-arrow-left"
title="voltar"/></button>
<span style="font-size:20px;"> Inventário | Edição </span>
<a href="modulos/movimento/rel_inventario_ficha.php?id=<?=$cod_id?>" target='_blank'>
<i class="glyphicon glyphicon-print text-print navbar-right" title="gerar PDF"></i>
</a>
</div>
</div>
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./movimento/implanta_crud&var_acao=editar">
<div class=" panel panel-body panel-primary">
<div class="col-md-1 col-xs-1 col-lg-1">
ID inv.
<input type="text" name="txt_id" value="<?php echo $rs_row['imp_id'] ?>" readonly class="form-control" maxlength="10">
</div>
<div class="col-md-2 col-xs-2 col-lg-2">
Data
<input type="text" name="txt_data" required value="<?php echo $rs_row['imp_data'] ?>" autofocus
onKeyup="formataData(this,event);" class="form-control" maxlength="10">
</div>
<div class="col-md-4 col-xs-4 col-lg-4">
Escola
<select name="txt_escola" class="form-control">
<?php while ($_esc = mysql_fetch_array($rs_esc)) {
if ($rs_row['imp_esc_id']==$_esc['esc_id']) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option
value="<?=$_esc['esc_id']?>" <?php echo $selected; ?>><?=utf8_encode($_esc['esc_nome'])?></option>?>?>
<?php } ?>
</select>
</div>
<div class="col-md-4 col-xs-4 col-lg-4">
Programa
<select name="txt_programa" class="form-control">
<?php while ($_prg = mysql_fetch_array($rs_prg)) {
if ($rs_row['imp_programa']==$_prg['prg_id']) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option
value="<?=$_prg['prg_id']?>" <?php echo $selected; ?>><?=$_prg['prg_programa']?></option>?>?>
<?php } ?>
</select>
</div>
<div class="col-md-1 col-xs-1 col-lg-1">
<button type="submit" name="bt_novo" class="btn botao_direita" title="salvar"><i class="fa fa-check"></i></button>
</div>
</div>
</div>
</form>
<!--ITENS DA IMPLANTAÇÃO-->
<div class="container">
<div class="panel with-nav-tabs panel-primary">
<div class="panel-heading">
Itens da implantação
</div>
<div class="panel-body">
<div class="tab-content">
<form id="form1" name="form1" id="cad_produto" method="post" action="?page=./escola_almox/implanta_crud&var_acao=cad_item">
<div>
<input type="hidden" name="txt_data" value="<?php echo $rs_row['imp_data'] ?>"/>
<input type="hidden" name="txt_escola" value="<?php echo $rs_row['imp_esc_id'] ?>"/>
<div class="panel panel-body panel-primary filterable">
<!-- <div class="col-md-1 col-xs-1 col-lg-1 ">-->
<!-- ID Inv.<br>-->
<input type="hidden" name="txt_id_inv" readonly class="form-control" value="<?php echo $rs_row['imp_id'] ?>">
<!-- </div>-->
<div class="col-md-1 col-xs-1 col-lg-1" style="display: none">
Data<br>
<input type="text" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_row['imp_data'] ?>">
</div>
<div class="col-md-5 col-xs-5 col-lg-5">
Selecione o produto<br>
<select name="txt_produto" id="txt_produto" class="form-control">
<?php while ($_prd = mysql_fetch_array($rs_prd)) { ?>
<option
value="<?php echo $_prd['pro_id'] ?>"><?php echo utf8_encode($_prd['pro_produto'] . ' | ' . $_prd['und_desc']) ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
unidade
<select name="txt_unidade" class="form-control">
<?php while ($_und = mysql_fetch_array($rs_und)) {
if ($pro['pro_unid_id']==$_und['und_id']) {
$selected = 'selected';
} else {
$selected = '';
} ?>?>
<option value="<?=$_und['und_id']?>" <?php echo $selected; ?>><?=utf8_encode($_und['und_desc'])?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
Quantidade
<!--<input type="text" name="txt_qtd" autofocus class="form-control lm" onkeyup="formataValor(this,event);" required>-->
<input type="text" name="txt_qtd" autofocus class="form-control lm" required>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
Valor Unitário
<input type="text" name="txt_valor" class="form-control lm" required onKeyup="formataValor(this,event);">
</div>
<div class="col-md-1 col-xs-1 col-lg-1 ">
<br>
<button type='submit' name='bt_cad_prod' class='btn' title="Adiconar produto a preparação">
<i class="fa fa-check" title="salvar"></i>
</button>
</div>
</div>
<div class="panel panel-body panel-primary">
<table class="tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'">
<thead>
<tr>
<th>ID</th>
<th>Produto</th>
<th>Data</th>
<th class="centro">Unidade</th>
<th class="direita">Quantidade</th>
<th class="direita">Valor Unit.</th>
<th class="direita">Total</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while ($row_rsResult = mysql_fetch_array($rs_ite)) {
echo "<tr>";
echo "<td>" . $row_rsResult['imi_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . "</td>";
echo "<td>" . date('d/m/Y', strtotime($row_rsResult['imi_data'])) . "</td>";
echo "<td class='centro'>" . $row_rsResult['und_desc'] . "</td>";
echo "<td class='direita'>" . number_format($row_rsResult['imi_qtd'], 2, ',', '.') . "</td>";
echo "<td class='direita'>" . number_format($row_rsResult['imi_vrunit'], 2, ',', '.') . "</td>";
echo "<td class='direita'>" . number_format($row_rsResult['total'], 2, ',', '.') . "</td>";
$id_inv = $rs_row['imp_id'];
$id_ite = $row_rsResult['imi_id'];
// if ($direito=='1') {
echo "<td><a href='?page=escola_almox/implanta_crud&id_inv=$id_inv&id_ite=$id_ite&var_acao=exc_item'>
<em class='fa fa-trash text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
// } else {
// echo "<td><a href='#'><img src='img/not.png' width='16' title='sem permissão para excluir registro'/></a></td>";
// }
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</div>