getProducts(); foreach ($relatedProducts as $key => $relatedProduct) { if($relatedProduct['qty'.$key]){ $productId = $relatedProduct['hdnProductId'.$key]; $result = $db->pquery("SELECT qtyinstock FROM vtiger_products WHERE productid=?", array($productId)); $qty = $db->query_result($result,0,"qtyinstock"); $stock = $qty + $relatedProduct['qty'.$key]; $db->pquery("UPDATE vtiger_products SET qtyinstock=? WHERE productid=?", array($stock, $productId)); } } } /** * This Function returns the current status of the specified Purchase Order. * @param type $purchaseOrderId * @return PurchaseOrderStatus */ function getPurchaseOrderStatus($purchaseOrderId){ $db = PearDatabase::getInstance(); $sql = "SELECT postatus FROM vtiger_purchaseorder WHERE purchaseorderid=?"; $result = $db->pquery($sql, array($purchaseOrderId)); $purchaseOrderStatus = $db->query_result($result,0,"postatus"); return $purchaseOrderStatus; } }