File Manager

Editing 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>
<script src="<?php echo $this->site_root?>/vendors/moment/min/moment.min.js"></script>
<script src="<?php echo $this->site_root?>/vendors/moment/locale/pt-br.js"></script>
<script src="<?php echo $this->site_root?>/vendors/bootstrap-daterangepicker/daterangepicker.js"></script>
<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>

$(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