*/ 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 $relatedRecordId - Product/Service Id * @return */ 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 $relatedRecordId - Product/Service Id * @param $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 $relatedRecordId - Product/Service Id */ function deleteListPrice($relatedRecordId) { $db = PearDatabase::getInstance(); $db->pquery('DELETE FROM vtiger_pricebookproductrel WHERE pricebookid = ? AND productid = ?', array($this->getId(), $relatedRecordId)); } }