Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/admin/pages/inv_inventario_general.php
Назад
<?php /** * @author Sistemas Aaron Cuevas Rosas * @copyright 2017/05/25 * @empresa COCINASDALLOWAY * @descripcion Inventario */ ?> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> <script> function habilita_campos(tipo){ if( tipo != '1' && tipo != '2' ){ document.getElementById('ancho').disabled=true; document.getElementById('alto').disabled=true; document.getElementById('grosor').disabled=true; }else{ document.getElementById('ancho').disabled=false; document.getElementById('alto').disabled=false; document.getElementById('grosor').disabled=false; } } </script> <?php //Archivo de Configuracion include("../config.php"); //Crear Objeto para conexion $conexion = new mysqli($host, $user, $pass, $db); //Archivo de Configuracion //include("../config1.php"); //Crear Objeto para conexion //$conexion1 = new mysqli($host1, $user1, $pass1, $db1); ?> <section class="content"> <div class="container-fluid"> <?php if(isset($_GET['cde']) and ($_GET['cde']=='1' || $_GET['cde']=='2')){ ?> <div class="col-xs-12 p-t-5"> <div class="alert alert-danger alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button> <?php if($_GET['cde']=='1'){?> <strong>Error!</strong> No se pudo guardar el registro. Contacte a soporte. <?php }?> <?php if($_GET['cde']=='2'){?> <strong>Error!</strong> El codigo ya se encuentra registrado. <?php }?> </div> </div> <?php } ?> <?php if(isset($_GET['cde']) and $_GET['cde']=='no'){ ?> <div class="col-xs-12 p-t-5"> <div class="alert alert-success alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button> <strong>Exito!</strong> Se guardó el articulo correctamente. </div> </div> <?php } ?> <!-- Basic Examples --> <div class="row clearfix"> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12"> <div class="card"> <div class="header"> <h2> Inventario </h2> </div> <div class="body"> <div class="table-responsive"> <table class="table table-bordered table-striped table-hover js-exportable dataTable"> <thead> <tr> <th>Codigo</th> <th>Proveedor</th> <th>tipo</th> <th>Descripción</th> <th>Imagen</th> <th>Ancho</th> <th>Alto</th> <th>Grosor</th> <th>Cantidad</th> <th>UM</th> <th>Costo</th> <th>Alta</th> <th>P. Venta</th> <!--<th>Categoria</th> <th>En linea</th>--> </tr> </thead> <tbody> <?php $query_inv = " SELECT * FROM inventario"; $consu_inv = $conexion -> query($query_inv); while($execu_inv = $consu_inv->fetch_array(MYSQLI_BOTH)){ $tipo=$execu_inv['id_tipo']; $um=$execu_inv['id_um']; $proveedor=$execu_inv['id_proveedor']; $query_inv1 = " SELECT * FROM tipo_articulo WHERE id='$tipo'"; $consu_inv1 = $conexion -> query($query_inv1); $execu_inv1 = $consu_inv1->fetch_array(MYSQLI_BOTH); $query_inv2 = " SELECT * FROM um WHERE id='$um'"; $consu_inv2 = $conexion -> query($query_inv2); $execu_inv2 = $consu_inv2->fetch_array(MYSQLI_BOTH); $query_inv3 = " SELECT * FROM proveedores WHERE id='$proveedor'"; $consu_inv3 = $conexion -> query($query_inv3); $execu_inv3 = $consu_inv3->fetch_array(MYSQLI_BOTH); ?> <tr> <td> <?php if($perfil=='admin'){ ?> <a href="#" data-toggle="modal" data-target="#detalle" data-id="<?php echo $execu_inv['codigo'];?>"><?php echo $execu_inv['codigo'];?></a></td> <?php }else{ ?> <?php echo $execu_inv['codigo'];?> <?php } ?> <td><?php echo $execu_inv3['nombre'];?></td> <td><?php echo $execu_inv1['dsc_tipo'];?></td> <td><?php echo utf8_encode($execu_inv['dsc_producto']);?></td> <td><button type="button" class="btn btn-primary btn-block waves-effect" data-trigger="focus" data-container="body" data-toggle="popover" data-placement="bottom" data-html="true" title="Imagen del articulo" data-content="<img src='http://www.cocinasdalloway.com/admin/pages/img_art/<?php echo $execu_inv['img'];?>' width='200px'height='200px'/>"> Ver </button></td> <td><?php echo $execu_inv['ancho'];?></td> <td><?php echo $execu_inv['alto'];?></td> <td><?php echo $execu_inv['grosor'];?></td> <td><?php echo $execu_inv['cantidad'];?></td> <td><?php echo $execu_inv2['dsc_um'];?></td> <td><?php echo '$'.number_format($execu_inv['costo'],2);?></td> <td><?php echo $execu_inv['fecha_alta'];?></td> <td><?php echo '$'.number_format($execu_inv['precio'],2);?></td> <!-- <td><?php /* if($execu_inv['id_categoria_ecomm']){ $query_cat1 = " SELECT * FROM t07_categorias WHERE t07_pk01='".$execu_inv['id_categoria_ecomm']."'"; $consu_cat1 = $conexion1 -> query($query_cat1); $execu_cat1 = $consu_cat1->fetch_array(MYSQLI_BOTH); echo $execu_cat1['t07_f001']; }else{ echo "S/C"; } */?></td> <td><?php echo $execu_inv['activo_ecomm'];?></td> --> </tr> <?php }?> </tbody> </table> </div> </div> </div> </div> </div> <!-- #END# Basic Examples --> </div> </section> <!-- /.Detalle De Documentos Vencidos --> <div class="modal fade" id="detalle" tabindex="-1"> <div class="modal-dialog" style="width: 75%;"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span></button> <h4 class="modal-title">Detalle producto</h4> </div> <div class="modal-body"> <form action="inv_alta_guardar1.php" method="post" enctype="multipart/form-data"> <div class="row clearfix"> <div class="col-sm-4"> <div class="form-group"> <div class="form-line"> <input readonly="readonly" autocomplete="off" maxlength="100" type="text" class="form-control" id="codigo" name="codigo" placeholder="Codigo" required="required" /> </div> </div> </div> <div class="col-sm-4"> <div class="form-group"> <div class="form-line"> <select class="form-control" id="tipo" name="tipo" onchange="habilita_campos(this.value)"> <?php $query_inv = " SELECT * FROM tipo_articulo"; $consu_inv = $conexion -> query($query_inv); while($execu_inv = $consu_inv->fetch_array(MYSQLI_BOTH)){ ?> <option id="t<?php echo $execu_inv['id']?>" value="<?php echo $execu_inv['id']?>"><?php echo $execu_inv['dsc_tipo']?></option> <?php } ?> </select> </div> </div> </div> </div> <div class="row clearfix"> <div class="col-sm-6"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" maxlength="80" type="text" class="form-control" id="dsc_producto" name="dsc_producto" placeholder="Descripcion articulo" required="required"/> </div> </div> </div> <div class="col-sm-6"> <div class="form-group"> <div class="form-line"> <select name="proveedor" id="proveedor" class="form-control show-tick" data-live-search="true" required> <option value="">-- Seleccione proveedor --</option> <?php $query_inv1 = " SELECT * FROM proveedores"; $consu_inv1 = $conexion -> query($query_inv1); while($execu_inv1 = $consu_inv1->fetch_array(MYSQLI_BOTH)){ ?> <option value="<?php echo $execu_inv1['id']?>"><?php echo $execu_inv1['id'].' - '.$execu_inv1['nombre']?></option> <?php } ?> </select> </div> </div> </div> </div> <div class="row clearfix"> <div class="col-sm-2"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" type="number" min="1" class="form-control" id="ancho" name="ancho" placeholder="Ancho" required="required"/> </div> </div> </div> <div class="col-sm-2"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" type="number" min="1" class="form-control" id="alto" name="alto" placeholder="Alto" required="required"/> </div> </div> </div> <div class="col-sm-2"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" type="number" min="1" class="form-control" id="grosor" name="grosor" placeholder="Grosor" required="required"/> </div> </div> </div> <div class="col-sm-2"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" type="number" min="0" step="0.1" class="form-control" id="costo" name="costo" placeholder="Costo" required="required"/> </div> </div> </div> <div class="col-sm-2"> <div class="form-group"> <div class="form-line"> <select name="um" id="um" class="form-control show-tick" data-live-search="true" required> <option value="">-- Seleccione um --</option> <?php $query_inv2 = " SELECT * FROM um"; $consu_inv2 = $conexion -> query($query_inv2); while($execu_inv2 = $consu_inv2->fetch_array(MYSQLI_BOTH)){ ?> <option value="<?php echo $execu_inv2['id']?>"><?php echo $execu_inv2['dsc_um']?></option> <?php } ?> </select> </div> </div> </div> </div> <div class="row clearfix"> <div class="col-sm-4"> <div class="form-group"> <div class="form-line"> <input type="file" class="form-control" id="fileToUpload" name="fileToUpload" placeholder="Archivo" accept="image/*" /> </div> </div> </div> </div> <div class="row clearfix"> <div class="col-sm-3"> <div class="form-group"> <div class="form-line"> <input autocomplete="off" type="number" min="0" step="0.1" class="form-control" id="precio" name="precio" placeholder="Precio de venta" /> </div> </div> </div> <!-- <div class="col-sm-4"> <div class="form-group"> <div class="form-line"> <select class="form-control" id="categoria_ecom" name="categoria_ecom" > <option value="">--Categoria Ecommerce--</option> <?php /* $query_cat2 = "SELECT * FROM t07_categorias;"; $consu_cat2 = $conexion1 -> query($query_cat2); if (!$consu_cat2) { printf("Errormessage: %s\n", $mysqli->error); } while($execu_cat2 = $consu_cat2->fetch_array(MYSQLI_BOTH)){ ?> <option value="<?php echo $execu_cat2['t07_pk01']?>"><?php echo $execu_cat2['t07_f001']?></option> <?php } */ ?> </select> </div> </div> </div> <div class="col-sm-4"> <div class="form-group"> <div class="form-line"> <select class="form-control" id="activo_ecom" name="activo_ecom" > <option value="">--Activo Ecommerce--</option> <option value="Si">Si</option> <option value="No">No</option> </select> </div> </div> </div> --> </div> <input type="submit" class="btn btn-primary m-t-15 waves-effect" value="GUARDAR"/> </form> <script> var id=""; $(document).ready(function (e) { $('#detalle').on('show.bs.modal', function(e) { id = $(e.relatedTarget).data().id; document.getElementById('codigo').value=id; $.ajax({ type: "POST", url: "inv_consulta_producto.php", data: "codigo="+id, dataType: 'json', sync:false, error: function(){ alert("Error contacte a Sistemas"); }, success: function(data){ //document.getElementById('tipo').value=''; document.getElementById('dsc_producto').value=''; document.getElementById('proveedor').value=''; document.getElementById('ancho').value=''; document.getElementById('alto').value=''; document.getElementById('grosor').value=''; document.getElementById('costo').value=''; document.getElementById('um').value=''; document.getElementById('precio').value=''; document.getElementById('categoria_ecom').value=''; document.getElementById('activo_ecom').value=''; $("#tipo").val(data.tipo); document.getElementById('dsc_producto').value=data.dsc_producto; document.getElementById('proveedor').value=data.id_proveedor; $("#proveedor").val(data.id_proveedor); document.getElementById('ancho').value=data.ancho; document.getElementById('alto').value=data.alto; document.getElementById('grosor').value=data.grosor; document.getElementById('costo').value=data.costo; document.getElementById('precio').value=data.precio; $("#um").val(data.um); $("#activo_ecom").val(data.activo_ecomm); $("#categoria_ecom").val(data.categoria_ecomm); habilita_campos(data.tipo) } }); }); }); </script> <div id="resultado_detalle"> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-right" data-dismiss="modal">Cerrar</button> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal -->
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка