| 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/vicosa22/modulos/movimento/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 05/11/2015
* Time: 13:58
*/
$cod_sol = $_GET['cod_sol'];
$cod_esc = $_GET['cod_esc'];
$rs_sql = mysql_query("SELECT * FROM v_lista_solic_escola where sol_id=$cod_sol");;
$resulta = mysql_fetch_array($rs_sql);
//Lista itens da solicitação
$rsSolItem = mysql_query("SELECT * from v_lista_solic_escola_item where sli_sol_id = $cod_sol ");
//$rs_esc = mysql_query("SELECT * FROM escolas where esc_id in(select id_entidade from usuarios_ent where usu_id = '$idusu') ORDER BY esc_nome");;
$rs_esc = mysql_query("SELECT * FROM escolas where esc_id = $cod_esc ORDER BY esc_nome");;
$rs_prg = mysql_query("SELECT * FROM programa order by prg_programa");
if ($resulta['sol_tipo']=='1') {
$rs_prd = mysql_query("SELECT * FROM v_lista_produtos_licitados WHERE qtd_entradanf OR qtd_implantacao OR qtedevol IS NOT NULL order by pro_produto");
} else {
$rs_prd = mysql_query("SELECT * FROM produtos WHERE pro_tipo=2 order by pro_produto");
}
$rs_und = mysql_query("SELECT * FROM unidade order by und_desc");
?>
<head id="Head1">
<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-->
<div class="container panel panel-primary panel-body">
<button type="button" name="bt_novo" class="btn" onclick=location.href='?page=./movimento/esc_solicitacao&lido=1'>
<i class="fa fa-arrow-left" title="voltar"></i>
</button>
<?php
if ($resulta['sol_tipo']=='1') {
echo "<span style='font-size:20px;'> Solicitações | Produtos da Merenda | Itens </span >";
} else {
echo "<span style='font-size:20px;'> Solicitações | Copa e Cozinha | Itens </span >";
}
?>
</div>
<!--
EDICAO DE SOLICITAÇÕES
-->
<form id="form1" name="form1" id="cad_sol" method="post" action="?page=./escola_almox/soldesp_crud&var_acao=editar">
<div class="container panel-body panel panel-primary">
<div id="id_form" class="panel">
<div class="col-md-2">
ID
<input type="text" name="txt_id" size="4px" style="text-align: center;" readonly="readonly"
value="<?php echo $resulta['sol_id'] ?>" class="form-control" id="txt_id">
</div>
<div class="col-md-2">
Data
<input type="text" readonly name="txt_data" required autofocus value="<?php echo date('d/m/Y') ?>" onKeyup="formataData(this,event);"
class="form-control" maxlength="10">
</div>
<div class="col-md-4">
Escola
<select name="txt_escola" disabled class="form-control">
<?php while ($_esc = mysql_fetch_array($rs_esc)) {
if ($resulta['sol_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-2">
Programa
<select name="txt_programa" disabled class="form-control">
<option value="0" selected>Selecione</option>
<?php while ($_prg = mysql_fetch_array($rs_prg)) {
if ($resulta['sol_prg_id']==$_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-2">
Observação
<textarea rows="3" cols="5" readonly name="txt_obs" class="form-control"><?php echo $resulta['sol_obs'] ?></textarea>
</div>
</div>
<!-- <div class="centro">-->
<!-- <button type="submit" name="bt_novo" class="btn botao_direita" title="salvar"><i class="fa fa-check"></i></button>-->
<!-- </div>-->
</div>
</form>
<!--ITENS-->
<div class="container panel-body panel panel-primary">
<div class="panel-heading">
Itens da solicitação nº: <?php echo $resulta['sol_id'] ?>
</div>
<div class="panel-body">
<div class="tab-content">
<form id="form1" name="form1" id="cad_produto" method="post" action="?page=./escola_almox/soldesp_crud&var_acao=cadastrar_item">
<div class="tab-pane" id="produtos">
<div class='panel panel-body panel-primary filterable'>
<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>Unidade</th>
<th>Quant.</th>
</tr>
</thead>
<tbody>
<?php
while ($row_rsResult = mysql_fetch_array($rsSolItem)) {
echo "<tr>";
echo "<td>" . $row_rsResult['sli_sol_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . "</td>";
echo "<td>" . $row_rsResult['und_desc'] . "</td>";
echo "<td>" . number_format($row_rsResult['sli_qtd'], 2, ',', '.') . "</td>";
$cod_sol = $row_rsResult['sli_sol_id'];
$cod_soli = $row_rsResult['sli_id'];
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</html>