Viewing File: /home/cienp/public_html/portal/relt_almx_cons.php

<?php
    if ($_POST[passa] == 'yes') {
?>

<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="clearfix"></div>
    <div class="row">
        <div class="col-md-12 col-sm-12 col-xs-12">
            <div class="x_panel">
                <div class="x_title">
                    <h2>Relatório de Consumo <small>Gerenciador Almoxarifado</small></h2>
                    <div class="clearfix"></div>
                </div>
                <div class="x_content">
                    <br />
                    <form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=impr_almx_cons" enctype="multipart/form-data" method="POST" name="form5">

                        <!-- <div class="form-group">
                            <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">N° Saída</label>
                            <div class="col-md-3 col-sm-3 col-xs-12">
                                <input type="text" id="v_id_said" name="v_id_said" class="form-control col-md-7 col-xs-12" maxlength="10">
                            </div>
                        </div> -->

                        <div class="form-group">
                            <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Solicitante:</label>
                            <div class="col-md-3 col-sm-6 col-xs-12">
                                <select name="v_id_resp" id="v_id_resp" class="form-control">
                                    <option value="">Selecione</option>
<?php
                                    $sqldp  = "SELECT id_colb, nm_colb ";
                                    $sqldp .= "FROM ".$pref_tabl."colb ";
                                    $sqldp .= "ORDER BY nm_colb ";
                                    $resdp  = mysqli_query($conn, $sqldp);
                                    if (mysqli_num_rows($resdp) > 0) {
                                        while ($linhadp = mysqli_fetch_array($resdp)) {
?>
                                        <option value="<?=$linhadp[id_colb]?>"><?=$linhadp[nm_colb]?></option>
<?php
                                        }
                                    }
?>
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Produto</label>
                            <div class="col-md-3 col-sm-6 col-xs-12">
                                <input name="v_nm_prdt" type="text" id="v_nm_prdt" maxlength="60" class="form-control">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Data de Início</label>
                            <div class='col-lg-2 col-md-3 col-sm-3 col-xs-12'>
                                <div class="form-group">
                                    <div class='input-group date' id='myDatepicker2'>
                                        <input name="v_dt_inic" type="text" id="v_dt_inic" class="form-control" />
                                        <span class="input-group-addon">
                                           <span class="glyphicon glyphicon-calendar"></span>
                                        </span>
                                    </div>
                                </div>
                            </div>
                            <label class="control-label col-xs-12 date_atte">até</label>
                            <div class='col-lg-2 col-md-3 col-sm-3 col-xs-12'>
                                <div class="form-group">
                                    <div class='input-group date' id='myDatepicker3'>
                                        <input name="v_dt_finl" type="text" id="v_dt_finl" class="form-control" />
                                        <span class="input-group-addon">
                                           <span class="glyphicon glyphicon-calendar"></span>
                                        </span>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <!--<div class="ln_solid"></div>--><br />
                        <div class="form-group">
                            <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
                                <a href="index1.php"><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">Pesquisar</button>
                                <input name="passa" type="hidden" id="passa" value="yes">
                                <input type="hidden" name="v_id_prdt" id="v_id_prdt" value="">
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
    $(document).ready(function(){
        $('#myDatepicker2').datetimepicker({
            format: 'DD/MM/YYYY',
            locale:'pt-br'
        });
        $('#myDatepicker3').datetimepicker({
            format: 'DD/MM/YYYY',
            locale:'pt-br'
        });
        var produtos = [
        <?
        $sqldp  = "SELECT p.id_prdt, p.nm_prdt, p.nu_item, c.sg_clas, p.nu_estq ";
        $sqldp .= "FROM ".$pref_tabl."almx_prdt p, ".$pref_tabl."almx_clas c ";
        $sqldp .= "WHERE p.id_clas = c.id_clas ";
        $sqldp .= "ORDER BY c.sg_clas, p.nu_item, p.nm_prdt ";
        $resdp  = mysqli_query($conn, $sqldp);
        while ($linhadp = mysqli_fetch_array($resdp)) {
            $linhadp[nm_prdt] = str_replace("'","\'",$linhadp[nm_prdt]);
            $de_item = $linhadp['sg_clas'].'-'.str_pad($linhadp['nu_item'], 5, "0", STR_PAD_LEFT).' - '. $linhadp[nm_prdt];
            echo "{ value: '$de_item', data: '$linhadp[id_prdt]' },";
        }
    ?>
        ];

        $('#v_nm_prdt').autocomplete({
            lookup: produtos,
            onSelect: function (suggestion) {
                $("#v_id_prdt").val(suggestion.data);
            }
        });
    });
</script>

<?php
    } else {
	    require "erro.php";
    }
?>