| Server IP : 74.208.127.88 / Your IP : 216.73.216.148 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/appsae/core/app/action/ |
Upload File : |
<?php
echo "Almacen que busca: ";
echo $stock_id = $_SESSION['stock_id'];
$almacen = StockData::getByid($stock_id);
?>
<div class="box-body table-responsive no-padding" style="max-width:1124px;">
<table id="table_search" class="table table-bordered table-hover ">
<thead>
<tr class="tableheader">
<th style="width:40px">#</th>
<th style="width:60px">Id</th>
<th style="width:250px">Imagen</th>
<th style="width:300px">Nombre</th>
<th style="width:120px">Precio</th>
<th style="width:300px">Precio de venta</th>
<th style="width:60px" COLSPAN="3" align="center">Existencia</th>
<th>Ubi</th>
<th style="width:160px">Operaciones</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$Iden = ($_POST['ID']);
if(isset($Iden)){
$products = ProductData::getBycode2($Iden);
if(count($products) == 0){
echo "<script>
$.notifyDefaults({
url_target: '_self'
});
$.notify({
message: 'Clic Aqui para Ver Ayuda!',
url: 'https://www.youtube.com/watch?v=jqiqsdu4t6c&list=LLcuskh7GrX1jFEahFHKdZPA&index=1'
});
$.notify({
title: '<strong>Codigo No Existe</strong>',
message: 'Revisar al escribir el codigo de barras.'
},{
type: 'danger'
});
</script>";
} else {
?>
<?php foreach($products as $product): ?>
<?php
//compras
$itotal2 = OperationData2::GetInputQByStock($product->id, $stock_id);
//ordenes de compra
$itotal_O = OperationData2::getBySumOC($product->barcode, $stock_id);
//Total de entradas
$entradas = $itotal2 + $itotal_O['0']->sum;
//ventas en tabla t_sale_detail
$vendedores = UserData::getByIdStock($stock_id);
//print_r($vendedores);
$totalV=0;
foreach($vendedores as $vendedor){
//ventas en tabla t_sale_detail por almacen
$operations3 = OperationData::getByc2OK($product->barcode, $vendedor->id_user);
foreach($operations3 as $op)
{
$totalV = $totalV + $op->qty;
}
}
//ajuste salida
$totalAjusteS = -1*OperationData2::getOutputQByStock($product->id, $stock_id);
//devoluciones de tabla operations
$operations4 = OperationData::getAllByProductIdAndStockDev($product->id, $stock_id);
$totalDev=0;
foreach($operations4 as $op2)
{
$totalDev = $totalDev + $op2->q;
}
//existencia
$existencia = ($entradas - $totalV + $totalDev) + $totalAjusteS;
?>
<tr class="<?php echo "danger"?>">
<td><?php echo $product->id; ?></td>
<td><?php echo $product->barcode; ?></td>
<td>
<?php if($product->image!=""):?>
<a href=""><img src="storage/products/<?php echo $product->image;?>" width="75" height="75"></a>
<a href="report/image.php?product_code=<?php echo $product->id;?>" target="_blank" onClick="window.open(this.href, this.target, 'width=400,height=400', directories=0, menubar=0,scrollbars=0,resizable=0); return false;">Zoom</a>
<?php endif;?>
</td>
<td><?php echo $product->name; ?></td>
<td>
<b>$ <?php echo number_format($product->price_out,2,".",","); ?></b>
</td>
<td style="width:30px;"><a href="index.php?view=productbyprice&id=<?php echo $product->id;?>" class="btn btn-default btn-xs"><i class="fa fa-th-list"></i> Precios</a> </td>
<td>
<?php echo "Almacen:"; ?>
</td>
<td>
<?php echo $almacen->name;?>
</td>
<td>
<?php echo $existencia;?>
</td>
<td>
<?php echo $product->presentation; ?>
</td>
<td style="width:250px;">
<form method="post" action="index.php?view=editproduct&id=<?php echo $product->id; ?>">
<input type="hidden" name="product_id" value="<?php echo $product->id; ?>">
<button class="btn btn-warning" title="editar producto"><a href="index.php?view=editproduct&id=<?php echo $product->id; ?>" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil"></i></a></button>
<button class="btn btn-secundary" title="editar Precio"><a href="index.php?view=PriceCam&id=<?php echo $product->id; ?>" class="btn btn-xs btn-dark"><i class="glyphicon glyphicon-edit"></i></a></button>
</form>
<div class="input-group">
<button class="btn btn-info" title="historial de producto"><a href="index.php?view=history&product_id=<?php echo $product->id; ?>&stock=1" class="btn btn-xs btn-info"><i class="glyphicon glyphicon-level-up"></i></a></button>
<button class="btn btn-success" title="Surtir producto"><a href="index.php?view=re&product=&code=<?php echo $product->barcode; ?>" class="btn btn-xs btn-success"><i class="glyphicon glyphicon-repeat"></i></a></button>
<button class="btn btn-primary" title="codigo de Barras Producto"><a href="index.php?view=newbarcode&id=<?php echo $product->barcode; ?>&name=<?php echo $product->name; ?>&price=<?php echo $product->price_out; ?>" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-barcode"></i></a></button>
</div>
<?php if($_SESSION['rol']==1){?>
<td style="width:100px;">
<a href="#" onclick="prueba(<?php echo $product->id; ?>)" id="oper-<?php echo $product->id; ?>" class="btn tip btn-xs btn-danger" title="Eliminar">
<i class="glyphicon glyphicon-trash"></i></a>
</td>
<?php }?>
</tr>
<?php endforeach;?>
<script>
/*
SweetAlert
*/
async function prueba(id) {
console.log("entrando a funcion");
const { isConfirmed, value } = await Swal.fire({
title: 'Eliminacion de Producto',
text: "Se eliminara registro de manera permanente, desea continuar!",
icon: 'warning',
input: 'password',
showCancelButton: true,
confirmButtonColor: '#3085d6',
cancelButtonColor: '#d33',
confirmButtonText: 'Si, borrar!!'
});
$.ajax({
type:'post',
url:"./?action=logindel",
//contentType: 'application/json; charset=utf-8',
data: { pass: value, id: id },
dataType: 'json',
success:function(res){
console.log(res);
if(res==true){
Swal.fire( 'Buen trabajo!',
'Producto eliminado!',
'success')
setTimeout(function(){ window.location.reload(); }, 30000);
}else{
Swal.fire({
icon: 'error',
title: 'Oops...',
text: 'Datos invalidos',
})
}
}
})
}
set_focus("#txtsearchitem2");
$("#txtsearchitem2").val("");
</script>
<script language=JavaScript>
<!--
//No permite copien el codigo o las imágenes de las paginas
//Javascript por cortesia de webservicio.com .. no modifiquen el codigo o no funcionara correctamente
function click(e) {
if (document.all) {
if (event.button==2||event.button==3) {
return false;
}
}
if (document.layers) {
if (e.which == 3) {
window.open LA DIRECCION QUE EMPIEZA DESDE HTTP, HASTA .PHTML, LO BORRAS Y PONES LA URL DE LA FOTO, HACES LO MISMO CON LO DE ARRIBA Y ESO DE CATION Y TODO ESO, ES PARA NO MOSTRAR NADA COMO LA DIRECCION, HISTORIAL Y ESO ESTO DE width=250,height=60' ES EL TAMAÑO DE LA VENTANA,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,ESQUE SI NO EXPERIMENTAS NO VAS APRENDER('http://www.webservicio.com/minipopup.phtml','_blank','location=0,menubar=0,toolbar=0,personalbar=0,status=0,scrollbars=0,width=250,height=60')
return false;
}
}
}
if (document.layers) {
document.captureEvents(Event.MOUSEDOWN);
}
document.onmousedown=click;
// -->
</SCRIPT>
<?php
}
} else {
echo "<script>alert('Estas metiendo un valor no numérico');</script>";
}
?>
</tbody>
</table>
</div>