|
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/PriceBooks/models/ |
Upload File : |
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.1
* ("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.
*************************************************************************************/
/**
* PriceBooks Record Model Class
*/
class PriceBooks_Record_Model extends Vtiger_Record_Model {
/**
* Function return the url to fetch List Price of the Product for the current PriceBook
* @return <String>
*/
function getProductListPriceURL() {
$url = 'module=PriceBooks&action=ProductListPrice&record=' . $this->getId();
$rawData = $this->getRawData();
$src_record = $rawData['src_record'];
if (!empty($src_record)) {
$url .= '&itemId=' . $src_record;
}
return $url;
}
/**
* Function returns the List Price for PriceBook-Product/Service relation
* @param <Integer> $relatedRecordId - Product/Service Id
* @return <Integer>
*/
function getProductsListPrice($relatedRecordId) {
$db = PearDatabase::getInstance();
$result = $db->pquery('SELECT listprice FROM vtiger_pricebookproductrel WHERE pricebookid = ? AND productid = ?',
array($this->getId(), $relatedRecordId));
if($db->num_rows($result)) {
return $db->query_result($result, 0, 'listprice');
}
return false;
}
/**
* Function updates ListPrice for PriceBook-Product/Service relation
* @param <Integer> $relatedRecordId - Product/Service Id
* @param <Integer> $price - listprice
*/
function updateListPrice($relatedRecordId, $price) {
$db = PearDatabase::getInstance();
$result = $db->pquery('SELECT * FROM vtiger_pricebookproductrel WHERE pricebookid = ? AND productid = ?',
array($this->getId(), $relatedRecordId));
if($db->num_rows($result)) {
$db->pquery('UPDATE vtiger_pricebookproductrel SET listprice = ? WHERE pricebookid = ? AND productid = ?',
array($price, $this->getId(), $relatedRecordId));
} else {
$db->pquery('INSERT INTO vtiger_pricebookproductrel (pricebookid,productid,listprice,usedcurrency) values(?,?,?,?)',
array($this->getId(), $relatedRecordId, $price, $this->get('currency_id')));
}
}
/**
* Function deletes the List Price for PriceBooks-Product/Services relationship
* @param <Integer> $relatedRecordId - Product/Service Id
*/
function deleteListPrice($relatedRecordId) {
$db = PearDatabase::getInstance();
$db->pquery('DELETE FROM vtiger_pricebookproductrel WHERE pricebookid = ? AND productid = ?',
array($this->getId(), $relatedRecordId));
}
}