| Server IP : 74.208.127.88 / Your IP : 18.218.24.244 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/t/sae/application/take_inventoryOLD/ |
Upload File : |
<?
require_once("../model/dbconn.php");
require_once("../model/pos.php");
include "../../library/check_login.php";
include "../../library/config.php";
?>
<!-- Bootstrap core CSS -->
<script type="text/javascript" src="js/jquery-3.2.1.min.js"></script>
<script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.12.1/js/dataTables.bootstrap4.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.3.0/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.3.0/js/responsive.bootstrap4.min.js"></script>
<!-- Custom styles for this template -->
<link href="dist/js/bootstrap.js" rel="stylesheet">
<link href="dist/css/bootstrap.css" rel="stylesheet">
<link href="assets/style.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.12.1/css/dataTables.bootstrap4.min.css" rel="stylesheet">
<link href="https://cdn.datatables.net/responsive/2.3.0/css/responsive.bootstrap4.min.css" rel="stylesheet">
<header>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Realizar Inventario Sistema App SAE 5.0">
<meta name="author" content="Sistemas Yusa">
<title>Realizar Inventario</title>
<style>
.btn-flotante {
font-size: 16px; /* Cambiar el tamaño de la tipografia */
text-transform: uppercase; /* Texto en mayusculas */
font-weight: bold; /* Fuente en negrita o bold */
color: #ffffff; /* Color del texto */
border-radius: 5px; /* Borde del boton */
letter-spacing: 2px; /* Espacio entre letras */
background-color: #E91E63; /* Color de fondo */
padding: 18px 30px; /* Relleno del boton */
position: fixed;
bottom: 40px;
right: 40px;
transition: all 300ms ease 0ms;
box-shadow: 0px 8px 15px rgba(0, 0, 0, 0.1);
z-index: 99;
}
.btn-flotante:hover {
background-color: #2c2fa5; /* Color de fondo al pasar el cursor */
box-shadow: 0px 15px 20px rgba(0, 0, 0, 0.3);
transform: translateY(-7px);
}
@media only screen and (max-width: 600px) {
.btn-flotante {
font-size: 14px;
padding: 12px 20px;
bottom: 20px;
right: 20px;
}
}
</style>
<!-- Fixed navbar -->
<nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark"> <a class="navbar-brand" href="#">Sistema de inventario</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarCollapse" aria-controls="navbarCollapse" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button>
<div class="collapse navbar-collapse" id="navbarCollapse">
<ul class="navbar-nav mr-auto">
<li class="nav-item active"> <a class="nav-link" href="../master/inventary.php">Regresar <span class="sr-only">(current)</span></a> </li>
<a href="">Nuevo</a>
</ul>
</div>
</nav>
</header>
<!-- Begin page content -->
<section class="content" name="formulario">
<br>
<hr>
<div class="row">
<div class="col-12 col-md-12">
<!-- Contenido -->
<div class="table-responsive">
<form method="post" id="update_form">
<div align="right" style="margin:5px;">
<button name="multiple_update" id="multiple_update" class="btn-flotante">Actualizacion de Inventario</button>
</div>
<div class="box-body">
<div class="box-body table-responsive no-padding">
<table id="example" class="table table-striped table-bordered dt-responsive nowrap" style="width:100%">
<thead>
<th width="4%"><input id="selectall" type="checkbox"></th>
<th width="18%">Codigo</th>
<th width="13%">Codigo de Barras</th>
<th width="22%">Nombre</th>
<th width="14%">status </th>
<th width="8%">Precio Publico</th>
<th width="11%">Exitencia</th>
<th width="11%">Ubicacion</th>
</thead>
<tbody></tbody>
</table>
</div>
</div>
</form>
</div>
</div>
<script>
$(document).ready(function(){
function fetch_data()
{
$.ajax({
url:"Registros.php",
method:"POST",
dataType:"json",
success:function(data)
{
var html = '';
for(var count = 0; count < data.length; count++)
{
html += '<tr>';
html += '<td><input type="checkbox" id="'+data[count].id+'" data-id_item="'+data[count].id_item+'" data-item_name="'+data[count].item_name+'" data-status="'+data[count].status+'" data-barcode="'+data[count].barcode+'" data-price="'+data[count].price+'" data-stock="'+data[count].stock+'" class="check_box" /></td>';
html += '<td>'+data[count].id_item+'</td>';
html += '<td>'+data[count].barcode+'</td>';
html += '<td>'+data[count].item_name+'</td>';
html += '<td>'+data[count].status+'</td>';
html += '<td>'+data[count].price+'</td>';
html += '<td>'+data[count].stock+'</td>';
html += '<td>'+data[count].location+'</td></tr>';
}
$('tbody').html(html);
}
});
}
fetch_data();
//sirve para checar todos los check
var checkbox = document.getElementById('selectall');
checkbox.addEventListener("change", validaCheckbox, false);
function validaCheckbox()
{
var checked = checkbox.checked;
if(checked){
alert('seleccionar todos');
fetch_data2();
}else{
fetch_data();
}
}
function fetch_data2()
{
$.ajax({
url:"Registros.php",
method:"POST",
dataType:"json",
success:function(data)
{
var html = '';
for(var count = 0; count < data.length; count++)
{
html += '<tr>';
html += '<td><input type="checkbox" id="'+data[count].id+'" data-id_item="'+data[count].id_item+'" data-item_name="'+data[count].item_name+'" data-status="'+data[count].status+'" data-barcode="'+data[count].barcode+'" data-price="'+data[count].price+'" data-stock="'+data[count].stock+'" class="check_box" /></td>';
html += '<td>'+data[count].id_item+'</td>';
html += '<td>'+data[count].barcode+'</td>';
html += '<td>'+data[count].item_name+'</td>';
html += '<td>'+data[count].status+'</td>';
html += '<td>'+data[count].price+'</td>';
html += '<td>'+data[count].location+'</td>';
html += '<td><input type="text" name="stock[]" class="form-control" value="'+$(this).data("stock")+'" /><input type="hidden" name="hidden_id[]" value="'+$(this).attr('id')+'" /></td>';
}
$('tbody').html(html);
}
});
}
$(document).on('click', '.check_box', function(){
var html = '';
if(this.checked)
{
html = '<td><input type="checkbox" id="'+$(this).attr('id')+'" data-id_item="'+$(this).data('id_item')+'" data-item_name="'+$(this).data('item_name')+'" data-status="'+$(this).data('status')+'" data-barcode="'+$(this).data('barcode')+'" data-price="'+$(this).data('price')+'" data-stock="'+$(this).data('stock')+'" class="check_box" checked /></td>';
html += '<td><input type="text" name="id_item[]" class="form-control" value="'+$(this).data("id_item")+'" /></td>';
html += '<td><input type="text" name="barcode[]" class="form-control" value="'+$(this).data("barcode")+'" /></td>';
html += '<td><input type="text" name="item_name[]" class="form-control" value="'+$(this).data("item_name")+'" /></td>';
html += '<td><select name="status[]" id="status_'+$(this).attr('id')+'" class="form-control"><option value="'+$(this).data("status")+'">'+$(this).data("status")+'</option> <option value="1">deshabilitado</option><option value="">Habilitado</option></select></td>';
html += '<td><input type="text" name="price[]" class="form-control" value="'+$(this).data("price")+'" /></td>';
html += '<td><input type="text" name="stock[]" class="form-control" value="'+$(this).data("stock")+'" /><input type="hidden" name="hidden_id[]" value="'+$(this).attr('id')+'" /></td>';
html += '<td><input type="text" name="location[]" class="form-control" value="'+$(this).data("location")+'" /><input type="hidden" name="hidden_id[]" value="'+$(this).attr('id')+'" /></td>';
}
else
{
html = '<td><input type="checkbox" id="'+$(this).attr('id')+'" data-id_item="'+$(this).data('id_item')+'" data-item_name="'+$(this).data('item_name')+'" data-status="'+$(this).data('status')+'" data-barcode="'+$(this).data('barcode')+'" data-price="'+$(this).data('price')+'" data-stock="'+$(this).data('stock')+'" class="check_box" /></td>';
html += '<td>'+$(this).data('id_item')+'</td>';
html += '<td>'+$(this).data('barcode')+'</td>';
html += '<td>'+$(this).data('item_name')+'</td>';
html += '<td>'+$(this).data('status')+'</td>';
html += '<td>'+$(this).data('price')+'</td>';
html += '<td>'+$(this).data('stock')+'</td>';
html += '<td>'+$(this).data('location')+'</td>';
}
$(this).closest('tr').html(html);
$('#status_'+$(this).attr('id')+'').val($(this).data('status'));
});
$('#update_form').on('submit', function(event){
event.preventDefault();
if($('.check_box:checked').length > 0)
{
$.ajax({
url:"ActualizacionMultiple.php",
method:"POST",
data:$(this).serialize(),
success:function()
{
alert('Registro(s) Actualizado(s).');
fetch_data();
}
})
}else{
$.ajax({
url:"ActualizacionMultiple.php",
method:"POST",
data:$(this).serialize(),
success:function()
{
alert('Registro(s) Actualizado(s).');
fetch_data();
}
})
}
});
});
</script>
<!-- Fin Contenido -->
</div>
</div>
<!-- Fin row -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<?php include "../layout/footer.php"; //footer template ?>
<?php include "../layout/bottom-footer.php"; //footer template ?>
</body>
</html>