| Server IP : 74.208.127.88 / Your IP : 3.17.73.81 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/application/sales/ |
Upload File : |
<?php
session_start();
require_once ("../model/dbconn.php");
require_once ("../model/pos.php");
function cmp($a, $b) {
return strcmp($a["id_item"], $b["id_item"]);
}
$uniqid = $_SESSION['pos_uniqid'];
$kasir = $_SESSION['pos_id'];
$id_item = "A23";
$pos = new pos();
$result = array();
$query = $pos->getItem3($id_item);
$data = $query[1];
$result['id_item'] = $data['id_item'];
$result['item_name'] = $data['item_name'];
$result['barcode'] = $data['barcode'];
$result['price'] = $data['price'];
//Consultar product
$bar = $result['barcode'];
$posP = new pos();
$queryP = $posP->getIdProduct($bar);
//print_r($queryP);
$data2 = $queryP[1];
//id producto
$resultP = $data2['id'];
//barcode de producto
$resultB = $data2['barcode'];
//Consultar Compras
$posC = new pos();
$queryC = $posC->getItemCompras($resultP);
$data3 = $queryC[1];
$resultC = $data3['compras'];
//Consultar Ordenes de Compras
$posC2 = new pos();
$queryC2 = $posC2->getItemCompras2($resultB);
$data3a = $queryC2[1];
$resultC2 = $data3a['Ocompras'];
//SUMAMOS OC Y Compras
$resultC= $resultC2 + $resultC;
//Consultar Ajustes
$posM = new pos();
$queryM = $posM->getItemMerma($resultP);
$dataX = $queryM[1];
$resultM = $dataX['merma'];
//Consultar Ventas
$posV = new pos();
$queryV = $posV->getItemVentas($bar);
$data4 = $queryV[1];
$resultV = $data4['ventas'];
//Consultar Devoluciones
$posD = new pos();
$queryD = $posD->getItemDev($resultP);
$data5 = $queryD[1];
$resultD = $data5['dev'];
//existencias actuales agregando ordenes de compra
$resultE = $resultC - $resultV + $resultD - $resultM;
$insert = $pos->saveTempSaleE($kasir,$uniqid,$result['id_item'],$result['barcode'],$result['item_name'],$result['price'],$resultC,$resultV, $resultD, $resultM, $resultE);
$retval['result'] = $insert[0];
$retval['error'] = $insert[1];
echo json_encode($retval);