|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/PurchaseOrder/models/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
/**
* PurchaseOrder Record Model Class
*/
class PurchaseOrder_Record_Model extends Inventory_Record_Model {
/**
* This Function adds the specified product quantity to the Product Quantity in Stock
* @param type $recordId
*/
function addStockToProducts($recordId) {
$db = PearDatabase::getInstance();
$recordModel = Inventory_Record_Model::getInstanceById($recordId);
$relatedProducts = $recordModel->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 <String> 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;
}
}