| Server IP : 74.208.127.88 / Your IP : 216.73.216.20 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
$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:120px">Precios de venta</th>
<th style="width:60px">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::getLike($Iden);
if(count($products) == 0){
echo "<script>alert('No hay valores que coincidan con la búsqueda.');</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 por almacen
$operations3 = OperationData::getByc2OK($product->barcode, $stock_id);
$totalV=0;
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="?view=ventana&product_code=<?php echo $product->id;?>" target="_blank" onClick="window.open(this.href, this.target, 'width=400,height=600', 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 $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; ?>">
<div class="input-group">
<button class="btn btn-warning"><a href="index.php?view=editproduct&id=<?php echo $product->id; ?>" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-pencil"></i>Editar</a></button>
</form>
<button class="btn btn-info"><a href="index.php?view=history&product_id=<?php echo $product->id; ?>&stock=1" class="btn btn-xs btn-info"><i class="glyphicon glyphicon-trash"></i>Historial</a></button>
</div>
</td>
</tr>
<?php endforeach;?>
<script>
/**
SweetAlert
*/
set_focus("#txtsearchitem");
$("#txtsearchitem").val("");
</script>
<?php
}
} else {
echo "<script>alert('Estas metiendo un valor no numérico');</script>";
}
?>
</tbody>
</table>
</div>