| Server IP : 74.208.127.88 / Your IP : 3.20.221.0 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/muebles/pos11/core/app/action/ |
Upload File : |
<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(Sin Dev)</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
//VERSION 3.6
$itotal = OperationData::GetInputQByStock($product->id,StockData::getPrincipal()->id);
$itotal2 = OperationData2::GetInputQByStock($product->id,StockData::getPrincipal()->id);
//sumamos las entrdas
$entradas = $itotal2;
//ventas en tabla t_sale_detail
$operations3 = OperationData::getByc2($product->name);
$totalV=0;
foreach($operations3 as $op)
{
$totalV = $totalV + $op->qty;
}
//Ordenes de compra o inventario inicial
$ordenes_Compra = OperationData2::getAllByProductIdAndStock_OC($product->barcode,1);
$OC=0;
foreach($ordenes_Compra as $op)
{
$OC = $OC + $op->q;
}
?>
<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 $entradas-$totalV + $OC; ?>
</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>