| Server IP : 74.208.127.88 / Your IP : 3.128.190.205 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/view/ |
Upload File : |
<?php
$iva_name = ConfigurationData::getByPreffix("imp-name")->val;
$iva_val = ConfigurationData::getByPreffix("imp-val")->val;
$stock_id = $_SESSION['stock_id'];
$almacen = StockData::getByid($stock_id);
?>
<ol class="breadcrumb">
<li><a href="./?view=home">Inicio</a></li>
<li><a href="./?view=stocks">Almacenes</a></li>
</ol>
<section class="content">
<div class="row">
<div class="col-md-12">
<nav class = "navbar navbar-inverse">
<div class = "container-fluid">
<a href = "#" class = "navbar-brand">Ajuste de Inventario</a>
</div>
</nav>
</content>
<div class = "row-fluid" class="form-control">
<div class = "col-md-3"></div>
<div class="panel panel-default">
<div class="panel-body">
<hr style = "border-top:1px dotted #000;"/>
<div class = "form-inline">
<form>
<div class="row">
<div class="col-md-6">
<input type="hidden" id="view" name="view" value="Ajustes">
<input type="text" id="product" name="product" class="form-control" placeholder="buscar por nombre">
<input type="text" id="code" name="code" class="form-control" placeholder="buscar por coddigo">
</div>
<div class="col-md-3">
<button type="submit" class="btn btn-primary"><i class="glyphicon glyphicon-search"></i> Buscar</button>
</div>
</div>
</form>
</div>
<script type='text/javascript'>
document.forms[0].elements["code"].focus()
document.forms[0].elements["code"].select()
</script>
<div class="col-md-12">
<?php if(isset($_GET["product"])&&($_GET["product"]!="")):?>
<?php
$id=$_GET["product"];
$products = ProductData::getAll_2($id);
if(count($products)>0){
?>
<h3>Resultados de la Busqueda</h3>
<div class = "table-responsive">
<table class = "table table-bordered">
<thead class="alert-info">
<th>Codigo</th>
<th>Nombre</th>
<th>Unidad</th>
<th>Costo unitario</th>
<th>Compras</th>
<th>Cantidad</th>
<th style="width:100px;"></th>
</thead>
<?php
$products_in_cero=0;
foreach($products as $product):
$total = OperationData::GetQByStock($product->id,$almacen->id);
$total2 = OperationData2::GetQByStock($product->id,$almacen->id);
?>
<form method="post" action="index.php?view=addtore">
<tr class="<?php if($q<=$product->inventary_min){ echo "danger"; }?>">
<td style="width:80px;"><?php echo $product->barcode; ?></td>
<td><?php echo $product->name; ?></td>
<td><?php echo $product->unit; ?></td>
<td><b> <input type="text" name="price_in" id="price_in" required value="<?php echo $product->price_in; ?>" class="form-control" placeholder="Efectivo"></b></td>
<td>
<?php echo ($total2); ?>
</td>
<td>
<input type="hidden" name="product_id" value="<?php echo $product->id; ?>">
<input type="" class="form-control" required id="q" name="q" value="10" placeholder="Cantidad de producto ..."></td>
<td style="width:100px;">
<button type="submit" class="btn btn-success"><i class="glyphicon glyphicon-refresh"></i> Agregar</button>
</td>
</tr>
</form>
<?php endforeach;?>
</table>
</div>
<?php
}
?>
<br><hr>
<hr><br>
<?php else:
?>
<?php endif; ?>
</div>
<div class="col-md-12">
<?php if(isset($_GET["code"])&&($_GET["code"]!="")):?>
<?php
$search=$_GET["code"];
$product = ProductData::getBycode($search);
if(isset($product)>0){
?>
<h3>Resultados de la Busqueda</h3>
<div class = "table-responsive">
<table class = "table table-bordered">
<thead class="alert-info">
<th>Codigo</th>
<th>Nombre</th>
<th>Unidad</th>
<th>Costo unitario</th>
<th>Compras</th>
<th>Cantidad</th>
<th style="width:100px;"></th>
</thead>
<?php
$products_in_cero=0;
//compras
$itotal2 = OperationData2::GetInputQByStock($product->id,StockData::getPrincipal()->id);
//ordenes de compra
$itotal_O = OperationData2::getBySumOC($product->barcode, StockData::getPrincipal()->id);
//Total de entradas
$entradas = $itotal2 + $itotal_O['0']->sum;
//ventas en tabla t_sale_detail por almacen
$operations3 = OperationData::getByc2s($product->name, StockData::getPrincipal()->id);
$totalV=0;
foreach($operations3 as $op)
{
$totalV = $totalV + $op->qty;
}
//ajuste salida
$totalAjusteS = -1*OperationData2::getOutputQByStock($product->id,StockData::getPrincipal()->id);
//devoluciones de tabla operations
$operations4 = OperationData::getAllByProductIdAndStockDev($product->id,StockData::getPrincipal()->id);
$totalDev=0;
foreach($operations4 as $op2)
{
$totalDev = $totalDev + $op2->q;
}
//existencia
$existencia = ($entradas - $totalV + $totalDev) + $totalAjusteS;
?>
<form method="post" action="index.php?view=addtore">
<tr class="<?php if($q<=$product->inventary_min){ echo "danger"; }?>">
<td style="width:80px;"><?php echo $product->barcode; ?></td>
<td><?php echo $product->name; ?></td>
<td><?php echo $product->unit; ?></td>
<td><b> <input type="text" name="price_in" id="price_in" required value="<?php echo $product->price_in; ?>" class="form-control" placeholder="Efectivo"></b></td>
<td>
<?php
echo $entradas;
?>
</td>
<td>
<input type="hidden" name="product_id" value="<?php echo $product->id; ?>">
<input type="" class="form-control" required id="q" name="q" value="10" placeholder="Cantidad de producto ..."></td>
<td style="width:100px;">
<button type="submit" class="btn btn-success" id="btnadd2"><i class="glyphicon glyphicon-refresh"></i> Agregar</button>
</td>
</tr>
</form>
</table>
</div>
<script type='text/javascript'>
document.forms[1].elements["q"].focus()
document.forms[1].elements["q"].select()
</script>
<?php
}
?>
<br><hr>
<hr><br>
<?php else:
?>
<?php endif; ?>
</div>
<div id="Oculto"></div>
<div class="col-md-12">
<!--- Carrito de compras :) -->
<?php if(isset($_SESSION["reabastecer"])):
$total = 0;
?>
<h2>Lista de Reabastecimiento</h2>
<div class="box box-primary">
<table class="table table-bordered table-hover">
<thead>
<th style="width:30px;">Codigo</th>
<th style="width:30px;">Cantidad</th>
<th style="width:30px;">Unidad</th>
<th>Producto</th>
<th style="width:30px;">Costo Unitario</th>
<th style="width:30px;">Costo total</th>
<th ></th>
</thead>
<?php foreach($_SESSION["reabastecer"] as $p):
$product = ProductData::getById($p["product_id"]);
?>
<tr >
<td><?php echo $p["product_id"]; ?></td>
<td ><?php echo $p["q"]; ?></td>
<td><?php echo $product->unit; ?></td>
<td><?php echo $product->name; ?></td>
<td><b>$ <?php echo number_format($p["price_in"],2,",","."); ?></b></td>
<td><b>$ <?php $pt = $p["price_in"]*$p["q"]; $total +=$pt; echo number_format($pt,2,",","."); ?></b></td>
<td style="width:30px;"><a href="index.php?view=clearre&product_id=<?php echo $product->id; ?>" class="btn btn-danger"><i class="glyphicon glyphicon-remove"></i> Cancelar</a></td>
</tr>
<?php endforeach; ?>
</table>
</div>
<form method="post" class="form-horizontal" id="processere" action="index.php?view=processre">
<input type="hidden" name="total" value="<?php echo $total*1.16; ?>" class="form-control" placeholder="Total">
<h2>Resumen</h2>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Almacen</label>
<div class="col-lg-10">
<?php
$clients = StockData::getAll();
$defecto= StockData::getById(1);
?>
<select name="stock_id" class="form-control" required >
<?php foreach($clients as $client):?>
<option value="<?php echo $client->id;?>"><?php echo $client->name;?></option>
<?php endforeach;?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Proveedor</label>
<div class="col-lg-10">
<?php
$clients = PersonData::getProviders();
?>
<select name="client_id" class="form-control">
<option value="">-- NINGUNO --</option>
<?php foreach($clients as $client):?>
<option value="<?php echo $client->id;?>"><?php echo $client->name." ".$client->lastname;?></option>
<?php endforeach;?>
</select>
<div class="btn-group pull-left">
<a href="./?view=newprovider" class="btn btn-default"></a>
</div>
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Tipo de Ajuste</label>
<div class="col-lg-10">
<?php
$clients = AjustTypeData::getAll();
?>
<select name="ajust_id" class="form-control">
<option value="">-- Compra --</option>
<?php foreach($clients as $client):?>
<option value="<?php echo $client->id;?>"><?php echo $client->name;?></option>
<?php endforeach;?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Pago</label>
<div class="col-lg-4">
<?php
$clients = PData::getAll();
?>
<select name="p_id" class="form-control">
<?php foreach($clients as $client):?>
<option value="<?php echo $client->id;?>"><?php echo $client->name;?></option>
<?php endforeach;?>
</select>
</div>
<label for="inputEmail1" class="col-lg-2 control-label">Entrega</label>
<div class="col-lg-4">
<?php
$clients = DData::getAll();
?>
<select name="d_id" class="form-control">
<?php foreach($clients as $client):?>
<option value="<?php echo $client->id;?>"><?php echo $client->name;?></option>
<?php endforeach;?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">importe</label>
<div class="col-lg-10">
<input type="text" name="money" id="money" required value="<?php echo $total*1.16?>" class="form-control" id="money" placeholder="Efectivo">
</div>
</div>
<script type='text/javascript'>
document.forms[1].elements["stock_id"].focus()
</script>
<script type='text/javascript'>
document.forms[0].elements["product"].focus()
</script>
<div class="row">
<div class="col-md-6 col-md-offset-6">
<div class="box box-primary">
<table class="table table-bordered">
<tr>
<td><p>Subtotal</p></td>
<td><p><b>$ <?php echo number_format($total,2,'.',','); ?></b></p></td>
</tr>
<tr>
<td><p><?php echo $iva_name." (".$iva_val."%) ";?></p></td>
<td><p><b>$ <?php echo number_format($total*($iva_val/100),2,'.',','); ?></b></p></td>
</tr>
<tr>
<td><p>Total</p></td>
<td><p><b>$ <?php
$ivaX= $total*($iva_val/100);
$total= $total + $ivaX;
echo number_format($total,2,'.',','); ?></b></p></td>
</tr>
</table>
</div>
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<div class="checkbox">
<label>
<input name="is_oficial" type="hidden" value="1">
</label>
</div>
</div>
</div>
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<div class="checkbox">
<label>
<a href="index.php?view=clearre" class="btn btn-danger"><i class="glyphicon glyphicon-remove"></i> Cancelar</a>
<button class="btn btn-primary" id="id_of_button"><i class="fa fa-refresh"></i> Procesar Valores</button>
</label>
</div>
</div>
</div>
</form>
</div>
<script type="text/javascript">
$(document).keyup(function(event){
event.preventDefault();
if (event.keyCode == 16) {
document.getElementById("id_of_button").click();
}
if (event.keyCode == 13) {
document.getElementById("money").focus;
}
});
</script>
<script>
$("#processsell").submit(function(e){
money = $("#money").val();
if(money<<?php echo $total;?>){
alert("No se puede efectuar la operacion");
e.preventDefault();
}else{
go = confirm("Cambio: $"+(money-<?php echo $total;?>));
if(go){}
else{e.preventDefault();}
}
});
</script>
</div>
</div>
<br><br><br><br><br>
<?php endif; ?>
</div>
</section>