| Server IP : 74.208.127.88 / Your IP : 18.222.188.218 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
if(isset($_SESSION["reabastecer"])){
$cart = $_SESSION["reabastecer"];
if(count($cart)>0){
$process = true;
//////////////////////////////////
if($process==true){
//verificammos si es entrada,salida o pendiente entrada
if($_POST["ajust_id"]>0)
{
$operation_type = 2;
$sell2 = new Re2Data();
$sell2->user_id = $_SESSION["user_id"];
$sell2->total = $_POST["total"];
$sell2->stock_to_id = $_POST["stock_id"];
$sell2->person_id=$_POST["client_id"]!=""?$_POST["client_id"]:"NULL";
$s = $sell2->add_re();
}
else
{
if($_POST["d_id"]==2){
$operation_type= 3; // 3.- entrada-pendiente
echo $_POST["ajust_id"];
}else{
$operation_type = 1;
}
$sell = new ReData();
$sell->user_id = $_SESSION["user_id"];
$sell->p_id = $_POST["p_id"];
$sell->d_id = $_POST["d_id"];
$sell->total = $_POST["total"];
$sell->stock_to_id = $_POST["stock_id"];
$sell->operation_type_id = $operation_type;
$sell->person_id=$_POST["client_id"]!=""?$_POST["client_id"]:"NULL";
$s = $sell->add_re();
}
foreach($cart as $c){
//verificammos si es entreda salida o pendiente entrada
if($_POST["ajust_id"]>0)
{
$operation_type = 2;
}
else
{
if($_POST["d_id"]==2){
$operation_type= 3; // 3.- entrada-pendiente
echo $_POST["ajust_id"];
}else{
$operation_type = 1;
}
}
//consultamos el producto de la tabla
$product = ProductData::getById($c["product_id"]);
$op = new OperationData2();
$op->price_in = $c["price_in"];
$op->price_out = $product->price_out;
$op->barcode = $product->barcode;
$op->stock_id = $_POST["stock_id"];
$op->product_id = $c["product_id"] ;
$op->operation_type_id=$operation_type; // 1 - entrada
$op->re_id=$s[1];
$op->q = $c["q"];
$add = $op->add();
//entrada de inventario compra
if($operation_type == 1){
//actualizamos stock en tabla item
$item = ProductData::getBycodeItem($product->barcode);
//stock antes de actualizar segun el almacen
if($_POST["stock_id"] == 1){
$preStock = $item->stock + $c["q"];
$item->updateStock($product->barcode,$preStock);
}elseif($_POST["stock_id"]== 2){
$preStock = $item->stock2 + $c["q"];
$item->updateStock2($product->barcode,$preStock);
}elseif($_POST["stock_id"] == 3){
$preStock = $item->stock3 + $c["q"];
$item->updateStock3($product->barcode,$preStock);
}else{
$preStock = $item->stock4 + $c["q"];
$item->updateStock4($product->barcode,$preStock);
}
//cargamos el valor de compras al valor anterios sumamos
//salida de inventario ajuste
}elseif($operation_type == 2){
//actualizamos stock en tabla item
$item = ProductData::getBycodeItem($product->barcode);
if($_POST["stock_id"] == 1){
$preStock = $item->stock - $c["q"];
$item->updateStock($product->barcode,$preStock);
}elseif($_POST["stock_id"]== 2){
$preStock = $item->stock2 - $c["q"];
$item->updateStock2($product->barcode,$preStock);
}elseif($_POST["stock_id"] == 3){
$preStock = $item->stock3 - $c["q"];
$item->updateStock3($product->barcode,$preStock);
}else{
$preStock = $item->stock4 - $c["q"];
$item->updateStock4($product->barcode,$preStock);
}
}else{
echo "Funciones no activadas de movimiento de inventario!!!";
}
}
////////////////// generando el mensaje
$subject = "[".$s[1]."] Nuevo reabastecimiento en el inventario";
$message = "<p>Se ha realizado un reabastecimiento en el inventario con Id = ".$s[1]."</p>";
$person_th="";
$person_td="";
if($_POST["client_id"]!=""){
$person = PersonData::getProvidersId($_POST["client_id"]);
$person_th="<td>Proveedor</td>";
$person_td="<td>".$person->name." ".$person->lastname."</td>";
}
$message .= "<table border='1'><tr>
<td>Id</td>
$person_th
<td>Almacen</td>
<td>Estado de pago</td>
<td>Estado de entrega</td>
<td>Total</td>
</tr>
<tr>
<td>".$s[1]."</td>
$person_td
<td>".StockData::getById($sell->stock_to_id)->name."</td>
<td>".PData::getById($sell->p_id)->name."</td>
<td>".DData::getById($sell->d_id)->name."</td>
<td> $".number_format($sell->total,2,".",",")."</td>
</tr>
</table>";
$message.="<h3 style='color:#333;'>Resumen</h3>";
$message.="<table border='1'><thead><th>Id</th><th>Codigo</th><th>Cantidad</th><th>Unidad</th><th>Producto</th><th>P.U</th><th>P. Total</th></thead>";
foreach($cart as $c){
$message.="<tr>";
$product = ProductData::getById($c["product_id"]);
$message.="<td>".$product->id."</td>";
$message.="<td>".$product->barcode."</td>";
$message.="<td>".$c["q"]."</td>";
$message.="<td>".$product->unit."</td>";
$message.="<td>".$product->name."</td>";
$message.="<td>$ ".number_format($product->price_in,2,".",",")."</td>";
$message.="<td>$ ".number_format($c["q"]*$product->price_in,2,".",",")."</td>";
$message.="</tr>";
}
$message.="</table>";
//////////////////
if($subject!=""&&$message!=""){
$m = new MailData();
$m->open();
$m->mail->Subject = $subject;
$m->message = "<p>$message</p>";
$m->mail->IsHTML(true);
$m->send();
}
//////////////////
unset($_SESSION["reabastecer"]);
setcookie("selled","selled");
$origen= StockData::getById($_POST["stock_id"])->name;
////////////////////
print "<script>alert('Se realizo una compra para el almacen: ".$origen." ');</script>";
print "<script>window.location='index.php?view=onere&id=$s[1]';</script>";
}
}
}
?>