| Server IP : 74.208.127.88 / Your IP : 3.15.238.90 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/app6/application/take_inventory/ |
Upload File : |
<?
require_once("../model/dbconn.php");
require_once("../model/pos.php");
?>
<!doctype html>
<html lang="es">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>Realizar Inventario</title>
<!-- Bootstrap core CSS -->
<link href="dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="assets/sticky-footer-navbar.css" rel="stylesheet">
<script type="text/javascript" src="js/jquery-3.2.1.min.js"></script>
</head>
<body>
<header>
<!-- Fixed navbar -->
<nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark"> <a class="navbar-brand" href="#">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="/muebles/application/sales/inventary.php">Inicio <span class="sr-only">(current)</span></a> </li>
<a href=""> Nuevo</a>
</ul>
</div>
</nav>
</header>
<!-- Begin page content -->
<div class="container">
<h3 class="mt-5">Sistema de inventario</h3>
<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 btn-primary">Actualizacion Multiple</button>
</div>
<div class="table-responsive">
<table class="table table-bordered table-striped">
<thead class="thead-dark">
<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>
</thead>
<tbody></tbody>
</table>
</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></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><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="0">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>';
}
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>';
}
$(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 -->
</div>
<!-- Fin container -->
<footer class="footer">
<div class="container"> <span class="text-muted">
<p>Soporte <a href="https://www.yusasoft1.com/" target="_blank">Sistemas Yusa</a></p>
</span> </div>
</footer>
<!-- Bootstrap core JavaScript
================================================== -->
<script src="dist/js/bootstrap.min.js"></script>
<!-- Placed at the end of the document so the pages load faster -->
</body>
</html>