/modules/Products/addPbProductRelToDB.php
PHP | 61 lines | 47 code | 2 blank | 12 comment | 9 complexity | 5f70af3ea1e077832f4ca059cb530f41 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0
- <?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.
- ********************************************************************************/
- require_once('include/database/PearDatabase.php');
- require_once('user_privileges/default_module_view.php');
- global $adb,$singlepane_view;
- global $log;
- $idlist = vtlib_purify($_POST['idlist']);
- $returnmodule=vtlib_purify($_REQUEST['return_module']);
- $returnaction=vtlib_purify($_REQUEST['return_action']);
- $pricebook_id=vtlib_purify($_REQUEST['pricebook_id']);
- $productid=vtlib_purify($_REQUEST['product_id']);
- $parenttab = getParentTab();
- if(isset($_REQUEST['pricebook_id']) && $_REQUEST['pricebook_id']!='')
- {
- $currency_id = getPriceBookCurrency($pricebook_id);
- //split the string and store in an array
- $storearray = explode(";",$idlist);
- foreach($storearray as $id)
- {
- if($id != '') {
- $lp_name = $id.'_listprice';
- $list_price = CurrencyField::convertToDBFormat($_REQUEST[$lp_name], null, false);
- //Updating the vtiger_pricebook product rel vtiger_table
- $log->info("Products :: Inserting vtiger_products to price book");
- $query= "insert into vtiger_pricebookproductrel (pricebookid,productid,listprice,usedcurrency) values(?,?,?,?)";
- $adb->pquery($query, array($pricebook_id,$id,$list_price,$currency_id));
- }
- }
- if($singlepane_view == 'true')
- header("Location: index.php?module=PriceBooks&action=DetailView&record=$pricebook_id&parenttab=$parenttab");
- else
- header("Location: index.php?module=PriceBooks&action=CallRelatedList&record=$pricebook_id&parenttab=$parenttab");
- }
- elseif(isset($_REQUEST['product_id']) && $_REQUEST['product_id']!='')
- {
- //split the string and store in an array
- $storearray = explode(";",$idlist);
- foreach($storearray as $id)
- {
- if($id != '') {
- $currency_id = getPriceBookCurrency($id);
- $lp_name = $id.'_listprice';
- $list_price = CurrencyField::convertToDBFormat($_REQUEST[$lp_name], null, false);
- //Updating the vtiger_pricebook product rel vtiger_table
- $log->info("Products :: Inserting PriceBooks to Product");
- $query= "insert into vtiger_pricebookproductrel (pricebookid,productid,listprice,usedcurrency) values(?,?,?,?)";
- $adb->pquery($query, array($id,$productid,$list_price,$currency_id));
- }
- }
- header("Location: index.php?module=$returnmodule&action=$returnaction&record=$productid&parenttab=$parenttab");
- }
- ?>