Removing the word "FREE" on product

Dimi Ingle
Topic Author
Offline
Junior Boarder

12 years 2 weeks ago #1088 by Dimi Ingle

Removing the word "FREE" on product was created by Dimi Ingle

Hi Guys

Please can you tell me how to remove the word "FREE" from my product drop downs. For example, if we have different flavours/ sizes of the same product listed, the drop down has the word "Free" in it. I'd like to remove it to avoid confusion that the product is free. Is there a way to make it blank?

Please assist

Please Log in or Create an account to join the conversation.

Linh Robert
Offline
Banned

12 years 2 weeks ago #1089 by Linh Robert

Replied by Linh Robert on topic Re: Removing the word "FREE" on product

Can I get a screenshot you post here?

If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket Notice: Undefined variable: target in /home/omegatheme/public_html/components/com_kunena/template/aurelia/layouts/bbcode/url/default.php on line 32
> www.omegatheme.com/member/

Please Log in or Create an account to join the conversation.

Dimi Ingle
Topic Author
Offline
Junior Boarder

12 years 2 weeks ago #1091 by Dimi Ingle

Replied by Dimi Ingle on topic Re: Removing the word "FREE" on product

Here's an example of the word "FREE" used on the drop down

Attachments:

Please Log in or Create an account to join the conversation.

Linh Robert
Offline
Banned

12 years 2 weeks ago #1095 by Linh Robert

Replied by Linh Robert on topic Re: Removing the word "FREE" on product

Hi,
First, please check the file administrator/components/com_virtuemart/models/customfields.php
in line ~592, make sure the code looks like:

Code:

$free = JText::_('COM_VIRTUEMART_CART_PRICE_FREE');

in line ~774, make sure the code looks like:

Code:

if ($price == 0 ) $price = JText::_('COM_VIRTUEMART_CART_PRICE_FREE');

Second, Please check the language file /language/en-GB/en-GB.com_virtuemart.ini and find the string COM_VIRTUEMART_CART_PRICE_FREE in rest of file, make sure the translation is:

Code:

COM_VIRTUEMART_CART_PRICE_FREE=No additional charge

(Joomla 1.5)
or

Code:

COM_VIRTUEMART_CART_PRICE_FREE="No additional charge"

(Joomla 2.5)

Thanks

Please Log in or Create an account to join the conversation.

Dimi Ingle
Topic Author
Offline
Junior Boarder

12 years 2 weeks ago #1108 by Dimi Ingle

Replied by Dimi Ingle on topic Re: Removing the word "FREE" on product

Hello

Thanks for the assistance, however line 592 is blank? Line 774 contains the following

Code:

$html .= ' <span>'.$productCustom->custom_title.' : </span>'.$productCustom->custom_value;

Here is the full code of my administrator/components/com_virtuemart/models/customfields.php file. Could you perhaps bold or highlight what needs to be modified. Im scared of breaking the site

Code:

<?php
/**
*
* Description
*
* @package	VirtueMart
* @subpackage
* @author Max Milbers
* @link http://www.virtuemart.net
* @copyright Copyright (c) 2004 - 2010 VirtueMart Team. All rights reserved by the author.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* @version $Id: custom.php 3057 2011-04-19 12:59:22Z Electrocity $
*/

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die('Restricted access');

// Load the model framework
jimport( 'joomla.application.component.model');

if(!class_exists('VmModel'))require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'vmmodel.php');

/**
 * Model for VirtueMart Customs Fields
 *
 * @package		VirtueMart
 */
class VirtueMartModelCustomfields extends VmModel {

	/**
	 * constructs a VmModel
	 * setMainTable defines the maintable of the model
	 * @author Max Milbers
	 */
	function __construct($modelName ='product') {
		parent::__construct('virtuemart_customfield_id');
		$this->setMainTable('product_customfields');
	}


    /**
     * Gets a single custom by virtuemart_customfield_id
     * @param string $type
     * @param string $mime mime type of custom, use for exampel image
     * @return customobject
     */
    function getCustomfield(){

   		$this->data = $this->getTable('product_customfields');
   		$this->data->load($this->_id);

  		return $this;

    }
	// **************************************************
	// Custom FIELDS
	//

     function getProductCustomsChilds($childs){

		$data = array();
	     	foreach ($childs as &$child) {
	     		$query='SELECT C.* , field.*
					FROM `#__virtuemart_product_customfields` AS field
					LEFT JOIN `#__virtuemart_customs` AS C ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
					WHERE `virtuemart_product_id` ='.(int)$child->virtuemart_product_id;
				$query .=' and C.field_type = "C" ';

				$this->_db->setQuery($query);
				$child->field = $this->_db->loadObject();
	     		$child->display = $this->displayType($child->virtuemart_product_id,'C');
	     		if ($child->field) $data[] = $child ;
	     	}
			return $data ;

     }
	public function getCustomParentTitle($custom_parent_id) {

    	$q='SELECT custom_title FROM `#__virtuemart_customs` WHERE virtuemart_custom_id ='.(int)$custom_parent_id;
		$this->_db->setQuery($q);
		return $this->_db->loadResult();
	}

	/** @return autorized Types of data **/
    function getField_types(){

		return array( 'S' =>'COM_VIRTUEMART_CUSTOM_STRING',
			'I'=>'COM_VIRTUEMART_CUSTOM_INT',
			'P'=>'COM_VIRTUEMART_CUSTOM_PARENT',
			'B'=>'COM_VIRTUEMART_CUSTOM_BOOL',
			'D'=>'COM_VIRTUEMART_DATE',
			'T'=>'COM_VIRTUEMART_TIME',
			'M'=>'COM_VIRTUEMART_IMAGE',
			'V'=>'COM_VIRTUEMART_CUSTOM_CART_VARIANT',
			'E'=>'COM_VIRTUEMART_CUSTOM_EXTENSION'
			);

			// 'U'=>'COM_VIRTUEMART_CUSTOM_CART_USER_VARIANT',
			// 'C'=>'COM_VIRTUEMART_CUSTOM_PRODUCT_CHILD',
			// 'G'=>'COM_VIRTUEMART_CUSTOM_PRODUCT_CHILD_GROUP',
//			'R'=>'COM_VIRTUEMART_RELATED_PRODUCT',
//			'Z'=>'COM_VIRTUEMART_RELATED_CATEGORY',
    }
	private $_hidden = array();

	/**
	 * Use this to adjust the hidden fields of the displaycustomHandler to your form
	 *
	 * @author Max Milbers
	 * @param string $name for exampel view
	 * @param string $value for exampel custom
	 */
	public function addHidden($name, $value=''){
		$this->_hidden[$name] = $value;
	}

	/**
	 * Adds the hidden fields which are needed for the form in every case
	 * @author Max Milbers
	 * OBSELTE ?
	 */
	private function addHiddenByType($datas){

		$this->addHidden('virtuemart_custom_id',$datas->virtuemart_custom_id);
		$this->addHidden('option','com_virtuemart');

	}

	/**
	 * Displays a possibility to select created custom
	 * @author Max Milbers
	 * @author Patrick Kohl
	 */
	public function displayCustomSelection(){

		$customslist = $this->getCustomsList();
		if (isset($this->virtuemart_custom_id)) $value = $this->virtuemart_custom_id ;
		else $value = JRequest::getInt( 'custom_parent_id',0);
		return  VmHTML::row('select','COM_VIRTUEMART_CUSTOM_PARENT', 'custom_parent_id', $customslist , $value);
	}

    /**
     * Retrieve a list of layouts from the default and choosen templates directory.
     *
     * We may use here the getCustoms function of the custom model or write something simular
     * @author Max Milbers
     * @param name of the view
     * @return object List of flypage objects
     */
    function getCustomsList( $publishedOnly = FALSE ) {
    	$vendorId=1;
		// get custom parents
    	$q='SELECT virtuemart_custom_id as value ,custom_title as text FROM `#__virtuemart_customs` where custom_parent_id=0
			AND field_type <> "R" AND field_type <> "Z" ';
		if ($publishedOnly) $q.='AND `published`=1';
		if ($ID = JRequest::getInt( 'virtuemart_custom_id',0)) $q .=' and `virtuemart_custom_id`!='.(int)$ID;
		//if (isset($this->virtuemart_custom_id)) $q.=' and virtuemart_custom_id !='.$this->virtuemart_custom_id;
		$this->_db->setQuery($q);
//		$result = $this->_db->loadAssocList();
		$result = $this->_db->loadObjectList();

    	$errMsg = $this->_db->getErrorMsg();
		$errs = $this->_db->getErrors();

		if(!empty($errMsg)){
			$app = JFactory::getApplication();
			$errNum = $this->_db->getErrorNum();
			$app->enqueueMessage('SQL-Error: '.$errNum.' '.$errMsg);
		}

		if($errs){
			$app = JFactory::getApplication();
			foreach($errs as $err){
				$app->enqueueMessage($err);
			}
		}

		return $result;
    }
	/**
	 * This displays a custom handler.
	 *
	 * @param string $html atttributes, Just for displaying the fullsized image
	 */
	public function displayCustomFields($datas){

		$identify = ''; // ':'.$this->virtuemart_custom_id;
		if (!class_exists('VmHTML')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'html.php');
		if ($datas->field_type) $this->addHidden('field_type',$datas->field_type);
		$this->addHiddenByType($datas);

		//$html = '<div id="custom_title">'.$datas->custom_title.'</div>';
		$html = ' <table class="admintable"> ';

		if(!class_exists('Permissions')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'permissions.php');
		if(!Permissions::getInstance()->check('admin') ) $readonly='readonly'; else $readonly ='';
		// only input when not set else display
		if ($datas->field_type) $html .= VmHTML::row('value','COM_VIRTUEMART_CUSTOM_FIELD_TYPE', $datas->field_types[$datas->field_type] ) ;
		else $html .= VmHTML::row('select','COM_VIRTUEMART_CUSTOM_FIELD_TYPE', 'field_type', $this->getOptions($datas->field_types) , $datas->field_type,VmHTML::validate('R')) ;
		$html .= VmHTML::row('input','COM_VIRTUEMART_TITLE','custom_title',$datas->custom_title,VmHTML::validate('S'));
		$html .= VmHTML::row('input','COM_VIRTUEMART_DESCRIPTION','custom_field_desc',$datas->custom_field_desc);
		// change input by type
		$html .= VmHTML::row('input','COM_VIRTUEMART_DEFAULT','custom_value',$datas->custom_value);
		$html .= VmHTML::row('input','COM_VIRTUEMART_CUSTOM_TIP','custom_tip',$datas->custom_tip);
		$html .= VmHTML::row('select','COM_VIRTUEMART_CUSTOM_PARENT','custom_parent_id',$this->getParentList($datas->virtuemart_custom_id),  $datas->custom_parent_id,'');
		//$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_CUSTOM_PARENT','custom_parent_id',$this->getCustomsList(),  $datas->custom_parent_id,'');
		$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_PUBLISHED','published',$datas->published);
		$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_CUSTOM_ADMIN_ONLY','admin_only',$datas->admin_only);
		$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_CUSTOM_IS_LIST','is_list',$datas->is_list);
		$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_CUSTOM_IS_HIDDEN','is_hidden',$datas->is_hidden);
		$html .= VmHTML::row('booleanlist','COM_VIRTUEMART_CUSTOM_IS_CART_ATTRIBUTE','is_cart_attribute',$datas->is_cart_attribute);

		$html .= '</table>';
		$html .= VmHTML::inputHidden($this->_hidden);

		return $html;
	}

	/**
	 * child classes can add their own options and you can get them with this function
	 *
	 * @param array $optionsarray
	 */
	private function getOptions($field_types){
		$options=array();
		foreach($field_types as $optionName=>$langkey){
			$options[] = JHTML::_('select.option',  $optionName, JText::_( $langkey ) );
		}
		return $options;
	}

	/**
	 * Just for creating simpel rows
	 *
	 * @author Max Milbers
	 * @param string $descr
	 * @param string $name
	 */
	private function displayRow($descr, $name,$readonly=''){
		$html = '<tr>
		<td class="labelcell">'.JText::_($descr).'</td>
		<td> <input type="text" '.$readonly.'class="inputbox '.$readonly.'" name="'.$name.'" size="70" value="'.$this->$name.'" /></td>
	</tr>';
		return $html;
	}

	function getParentList($excludedId = 0) {

		$this->_db->setQuery(' SELECT virtuemart_custom_id as value,custom_title as text FROM `#__virtuemart_customs` WHERE `field_type` ="P" and virtuemart_custom_id!='.$excludedId );
		if ($results =$this->_db->loadObjectList()) return $results ;
		else return array();
	}
	function getProductChildCustomRelation() {

		$this->_db->setQuery(' SELECT virtuemart_custom_id as value,custom_title as text FROM `#__virtuemart_customs` WHERE `field_type` ="C"' );
		if ($results =$this->_db->loadObjectList()) return $results ;
		else return array();
	}
	function getProductChildCustom($product_id ) {
		$this->_db->setQuery(' SELECT `virtuemart_custom_id`,`custom_value` FROM `#__virtuemart_product_customfields` WHERE  `virtuemart_product_id` ='.(int)$product_id);
		if ($childcustom = $this->_db->loadObject()) return $childcustom;
		else {
			$childcustom->virtuemart_custom_id = 0;
			$childcustom->custom_value = '';
			return $childcustom;
		}
	}
	function getProductParentRelation($product_id ) {
		$this->_db->setQuery(' SELECT `custom_value` FROM `#__virtuemart_product_customfields` WHERE  `virtuemart_product_id` ='.(int)$product_id);
		if ($childcustom = $this->_db->loadResult()) return '('.$childcustom.')';
		else return JText::_('COM_VIRTUEMART_CUSTOM_NO_PARENT_RELATION');
	}
	/**
     * AUthor Kohl Patrick
     * Load all custom fields for a Single product
     * return custom fields value and definition
     */
     public function getproductCustomslist($virtuemart_product_id) {

		$query='SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_jplugin_id`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_cart_attribute` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`,field.`custom_param`,field.`custom_price`,field.`ordering`
			FROM `#__virtuemart_customs` AS C
			LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
			Where `virtuemart_product_id` ='.$virtuemart_product_id.' order by field.`ordering` ASC';
		$this->_db->setQuery($query);
		$productCustoms = $this->_db->loadObjectList();
		if (!$productCustoms ) return array();
		$row= 0 ;
		foreach ($productCustoms as $field ) {

			if($field->field_type =='E') {

				JPluginHelper::importPlugin('vmcustom');
				$dispatcher = JDispatcher::getInstance();
				$retValue = $dispatcher->trigger('plgVmDeclarePluginParams',array('custom',$field->custom_element,$field->custom_jplugin_id,$field));

			}
			//vmdebug('fields',$field);
			$field->display = $this->inputType($field,$virtuemart_product_id,$row); //custom_param without S !!!
			$row++ ;
		}
		return $productCustoms;
     }

/**
 * Formating admin display by roles
 * input Types for product only !
 * $field->is_cart_attribute if can have a price
 */

	public function inputType($field,$product_id,$row){

		$field->custom_value = empty($field->custom_value) ? $field->value : $field->custom_value ;

		if ($field->is_cart_attribute)  $priceInput = '<input type="text" value="'.(isset($field->custom_price)?$field->custom_price: '0').'" name="field['.$row.'][custom_price]" />';
		else $priceInput = ' ';

		if ($field->is_list) {
			$options = array();
			$values = explode(';',$field->custom_value);

			foreach ($values as $key => $val)
				$options[] = array( 'value' => $val ,'text' =>$val);
			return JHTML::_('select.genericlist', $options,'field['.$row.'][custom_value]').$priceInput;
		} else {

			switch ($field->field_type) {
				/* variants*/
				case 'V':
					return '<input type="text" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" /></td><td>'.$priceInput;
				break;
				/*
				 * Stockable (group of) child variants
				 * Special type setted by the plugin
				 */
				case 'G':
				return ;
				break;
				/*Extended by plugin*/
				case 'E':

					$html = '<input type="hidden" value="'.$field->value.'" name="field['.$row.'][custom_value]" />' ;
					if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');
					JPluginHelper::importPlugin('vmcustom');
					$dispatcher = JDispatcher::getInstance();
// 					echo 'vmCustomPlugin <pre>'.print_r($field,1).'</pre>';die;
// 					vmdebug('vmCustomPlugin',$field);

					$retValues = $dispatcher->trigger('plgVmOnProductEdit',array($field,$product_id,&$row,&$retValue));


					return $html.$retValue.$priceInput;
				break;
				case 'D':
					return vmJsApi::jDate($field->custom_value, 'field['.$row.'][custom_value]','field_'.$row.'_customvalue').$priceInput;
				break;
				case 'T':
					//TODO Patrick
					return '<input type="text" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" /></td><td>'.$priceInput;
				break;
				/* string or integer */
				case 'S':
				case 'I':
					return '<input type="text" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" /></td><td>'.$priceInput;
				break;
				/* bool */
				case 'B':
					return JHTML::_( 'select.booleanlist', 'field['.$row.'][custom_value]' , 'class="inputbox"', $field->custom_value).'</td><td>'.$priceInput;
				break;
				/* parent */
				case 'P':
					return $field->custom_value.'<input type="hidden" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" /></td><td>';
				break;
				/* related category*/
				case 'Z':
					if (!$field->custom_value) return '';// special case it's category ID !
					$q='SELECT * FROM `#__virtuemart_categories_'.VMLANG.'` JOIN `#__virtuemart_categories` AS p using (`virtuemart_category_id`) WHERE `published`=1 AND `virtuemart_category_id`= "'.(int)$field->custom_value.'" ';
					$this->_db->setQuery($q);
					//echo $this->_db->_sql;
					if ($category = $this->_db->loadObject() ) {
						$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_category_medias` WHERE `virtuemart_category_id`= "'.(int)$field->custom_value.'" ';
						$this->_db->setQuery($q);
						$thumb ='';
						if ($media_id = $this->_db->loadResult()) {
							$thumb = $this->displayCustomMedia($media_id);
						}
						$display = '<input type="hidden" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" />';
						return  $display.JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=category&task=edit&virtuemart_category_id=' . (int)$field->custom_value ), $thumb.' '.$category->category_name, array ('title' => $category->category_name ) ).$display;
					}
					else return 'no result';
				/* related product*/
				case 'R':
					if (!$field->custom_value) return '';
					$q='SELECT `product_name`,`product_sku`,`product_s_desc` FROM `#__virtuemart_products_'.VMLANG.'` as l JOIN `#__virtuemart_products` AS p using (`virtuemart_product_id`) WHERE `virtuemart_product_id`='.(int)$field->custom_value;
					$this->_db->setQuery($q);
					$related = $this->_db->loadObject();
					$display = $related->product_name.'('.$related->product_sku.')';
					$display = '<input type="hidden" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" />';

					$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias`WHERE `virtuemart_product_id`= "'.(int)$field->custom_value.'" AND (`ordering` = 0 OR `ordering` = 1)';
					$this->_db->setQuery($q);
					$thumb ='';
					if ($media_id = $this->_db->loadResult()) {
						$thumb = $this->displayCustomMedia($media_id);
					}
					return $display.JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=product&task=edit&virtuemart_product_id='.$field->custom_value), $thumb.'<br /> '.$related->product_name, array ('title' => $related->product_name.'<br/>'.$related->product_s_desc) );
				break;
				/* image */
				case 'M':
					if (empty($product)){
						$vendorId=1;
					} else {
						$vendorId = $product->virtuemart_vendor_id;
					}
					$q='SELECT `virtuemart_media_id` as value,`file_title` as text FROM `#__virtuemart_medias` WHERE `published`=1
					AND (`virtuemart_vendor_id`= "'.$vendorId.'" OR `shared` = "1")';
					$this->_db->setQuery($q);
					$options = $this->_db->loadObjectList();
					return JHTML::_('select.genericlist', $options,'field['.$row.'][custom_value]','','value' ,'text',$field->custom_value).'</td><td>'.$priceInput;
				break;
				/* Child product Group */
				case 'G':
				break;
				/* Child product */
				case 'C':
					if (empty($product)){
						$virtuemart_product_id = JRequest::getInt('virtuemart_product_id', 0);
					} else {
						$virtuemart_product_id = $product->virtuemart_product_id;
					}
					$html = '';
					$q='SELECT concat(`product_sku`,":",`product_name`) as text ,`virtuemart_product_id`,`product_in_stock` FROM `#__virtuemart_products` WHERE `published`=1
					AND `virtuemart_product_id`= "'.$field->custom_value.'"';
					//$db->setQuery(' SELECT virtuemart_product_id, product_name FROM `#__virtuemart_products` WHERE `product_parent_id` ='.(int)$product_id);
					$this->_db->setQuery($q);
					if ($child = $this->_db->loadObject()) {
						$html .= JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=product&task=edit&virtuemart_product_id='.$field->custom_value), $child->text.' ('.$field->custom_value.')', array ('title' => $child->text ));
						$html .= ' '.JText::_('COM_VIRTUEMART_PRODUCT_FORM_IN_STOCK').':'.$child->product_in_stock ;
						$html .= '<input type="hidden" value="'.$child->virtuemart_product_id.'" name="field['.$row.'][custom_value]" /></div><div>'.$priceInput;
						return $html;
//					return '<input type="text" value="'.$field->custom_value.'" name="field['.$row.'][custom_value]" />';
					}
					else return JText::_('COM_VIRTUEMART_CUSTOM_NO_CHILD_PRODUCT');
				break;
			}

		}
	}
     public function getProductCustomsField($product) {

		$query='SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
			FROM `#__virtuemart_customs` AS C
			LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
			Where `virtuemart_product_id` ='.(int)$product->virtuemart_product_id.' and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z"';
		$query .=' and is_cart_attribute = 0 order by field.`ordering`,virtuemart_custom_id' ;
		$this->_db->setQuery($query);
		if ($productCustoms = $this->_db->loadObjectList()) {

			$row= 0 ;
			if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');
			foreach ($productCustoms as $field ) {
				if ($field->field_type == "E"){
					JPluginHelper::importPlugin('vmcustom');
					$dispatcher = JDispatcher::getInstance();
					$ret = $dispatcher->trigger('plgVmOnDisplayProductFE',array($product,&$row,&$field,));

				}
				else {
					$field->display = $this->displayType($field->custom_value,$field->field_type,$field->is_list,$field->custom_price,$row);
				}
				$row++ ;
			}
			return $productCustoms;
		} else return array();
     }

     public function getProductCustomsFieldRelatedCategories($product) {

		$query='SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
			FROM `#__virtuemart_customs` AS C
			LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
			Where `virtuemart_product_id` ='.(int)$product->virtuemart_product_id.' and `field_type` = "Z"';
		$query .=' and is_cart_attribute = 0 order by virtuemart_custom_id' ;
		$this->_db->setQuery($query);
		if ($productCustoms = $this->_db->loadObjectList()) {
			$row= 0 ;
			foreach ($productCustoms as & $field ) {
				$field->display = $this->displayType($field->custom_value,$field->field_type,$field->is_list,$field->custom_price,$row);
				$row++ ;
			}
			return $productCustoms;
		} else return array();
     }

     public function getProductCustomsFieldRelatedProducts($product) {

		$query='SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
			FROM `#__virtuemart_customs` AS C
			LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
			Where `virtuemart_product_id` ='.(int)$product->virtuemart_product_id.' and `field_type` = "R"';
		$query .=' and is_cart_attribute = 0 order by virtuemart_custom_id' ;
		$this->_db->setQuery($query);
		if ($productCustoms = $this->_db->loadObjectList()) {
			$row= 0 ;
			foreach ($productCustoms as & $field ) {
				$field->display = $this->displayType($field->custom_value,$field->field_type,$field->is_list,$field->custom_price,$row);
				$row++ ;
			}
			return $productCustoms;
		} else return array();
     }

	 // temp function TODO better one
     public function getProductCustomsFieldCart($product) {

			// group by virtuemart_custom_id
			$query='SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
				FROM `#__virtuemart_customs` AS C
				LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
				Where `virtuemart_product_id` ='.(int)$product->virtuemart_product_id.' and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z"';
			$query .=' and is_cart_attribute = 1 group by virtuemart_custom_id' ;

			$this->_db->setQuery($query);
			$groups = $this->_db->loadObjectList();

			if (!class_exists('VmHTML')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'html.php');
			$row= 0 ;
			if(!class_exists('CurrencyDisplay')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'currencydisplay.php');
			$currency = CurrencyDisplay::getInstance();

			if(!class_exists('calculationHelper')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'calculationh.php');
			$calculator = calculationHelper::getInstance();
			if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');

			$free = JText::_('COM_VIRTUEMART_CART_PRICE_FREE');
			// render select list
			foreach ($groups as $group) {

//				$query='SELECT  field.`virtuemart_customfield_id` as value ,concat(field.`custom_value`," :bu ", field.`custom_price`) AS text
				$query='SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id` as value ,field.`custom_value`, field.`custom_price`, field.`custom_param`
					FROM `#__virtuemart_customs` AS C
					LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
					Where `virtuemart_product_id` ='.(int)$product->virtuemart_product_id;
				$query .=' and is_cart_attribute = 1 and C.`virtuemart_custom_id`='.(int)$group->virtuemart_custom_id ;

                                // We want the field to be ordered as the user defined
                                $query .=' ORDER BY field.`ordering`';

				$this->_db->setQuery($query);
				$options = $this->_db->loadObjectList(); //vmdebug('getProductCustomsFieldCart',$this->_db);
				$group->options = array();
				foreach ( $options as $option){
					$group->options[$option->value] = $option;
				}

				if ($group->field_type == 'V'){
					$default = current($group->options);
					foreach ($group->options as &$productCustom) {
						if ((float)$productCustom->custom_price ) $price = $currency->priceDisplay($calculator->calculateCustomPriceWithTax($productCustom->custom_price)) ;
						else  $price = $free ;
						$productCustom->text =  $productCustom->custom_value.' : '.$price;

					}
					$group->display = VmHTML::select('customPrice['.$row.']['.$group->virtuemart_custom_id.']',$group->options,$default->custom_value,'','value','text',false);
				} else if ($group->field_type == 'G'){
					$group->display .=''; // no direct display done by plugin;
				} else if ($group->field_type == 'E'){
					$group->display ='';

					foreach ($group->options as $productCustom) {
						if ((float)$productCustom->custom_price ) $price = $currency->priceDisplay($calculator->calculateCustomPriceWithTax($productCustom->custom_price));
						else  $price = $free ;
						$productCustom->text =  $productCustom->custom_value.' : '.$price;
//// plugin
						if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');
						JPluginHelper::importPlugin('vmcustom');
						$dispatcher = JDispatcher::getInstance();
						$fieldsToShow = $dispatcher->trigger('plgVmOnDisplayProductVariantFE',array($productCustom,&$row,&$group));

						$group->display .= '<input type="hidden" value="'.$productCustom->value.'" name="customPrice['.$row.']['.$group->virtuemart_custom_id.']" /> '.JText::_('COM_VIRTUEMART_CART_PRICE').': '.$price ;
						$row++;
					}
					$row--;
				} else if ($group->field_type == 'U'){
					foreach ($group->options as $productCustom) {
						if ((float)$productCustom->custom_price ) $price = $currency->priceDisplay($calculator->calculateCustomPriceWithTax($productCustom->custom_price));
						else  $price = $free ;
						$productCustom->text =  $productCustom->custom_value.' : '.$price;

					$group->display .= '<input type="text" value="'.JText::_($productCustom->custom_value).'" name="customPrice['.$row.']['.$group->virtuemart_custom_id.']['.$productCustom->value.']" /> '.JText::_('COM_VIRTUEMART_CART_PRICE').': '.$price ;
					}
				} else {
					$group->display ='';
					$checked = 'checked="checked"';
					foreach ($group->options as $productCustom) {
						if ((float)$productCustom->custom_price ) $price = $currency->priceDisplay($calculator->calculateCustomPriceWithTax($productCustom->custom_price));
						else  $price = $free ;
						$group->display .= '<input id="'.$productCustom->value.'" '.$checked.' type="radio" value="'.$productCustom->value.'" name="customPrice['.$row.']['.$group->virtuemart_custom_id.']" /><label for="'.$productCustom->value.'">'.$this->displayType($productCustom->custom_value,$group->field_type,0,'',$row).': '.$price.'</label>' ;
						$checked ='';
					}
				}
				$row++ ;
			}

			return $groups;

     }

  /**
  * Formating front display by roles
  *  for product only !
  */
	public function displayType($value,$type,$is_list=0,$price = 0,$row=''){

			if(!class_exists('CurrencyDisplay')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'currencydisplay.php');
			$currency = CurrencyDisplay::getInstance();

			if ($is_list>0) {
			$options = array();
			$values = explode(';',$value);

			foreach ($values as $key => $val){
				$options[] = array( 'value' => $val ,'text' =>$val);
			}

			return JHTML::_('select.genericlist', $options,'field['.$row.'][custom_value]',null,'value','text',false,true);
		} else {
			if ($price > 0){

				$price = $currency->priceDisplay((float)$price);
			}
			switch ($type) {

				/* variants*/
				case 'V':
					if ($price == 0 ) $price = JText::_('COM_VIRTUEMART_CART_PRICE_FREE') ;
					/* Loads the product price details */
					return '<input type="text" value="'.JText::_($value).'" name="field['.$row.'][custom_value]" /> '.JText::_('COM_VIRTUEMART_CART_PRICE').$price .' ';
					break;
				/*Date variant*/
				case 'D':
					return '<span class="product_custom_date">'.vmJsApi::date($value,'LC1',true).'</span>';//vmJsApi::jDate($field->custom_value, 'field['.$row.'][custom_value]','field_'.$row.'_customvalue').$priceInput;
				break;
				/* string or integer */
				case 'S':
				case 'I':
					return JText::_($value);
				break;
				/* bool */
				case 'B':
					if ($value == 0) return JText::_('COM_VIRTUEMART_NO') ;
					return JText::_('COM_VIRTUEMART_YES') ;
				break;
				/* parent */
				case 'P':
					return '<span class="product_custom_parent">'.JText::_($value).'</span>';
				break;
				/* related */
				case 'R':
					$q='SELECT l.`product_name`, p.`product_parent_id` , l.`product_name`, x.`virtuemart_category_id` FROM `#__virtuemart_products_'.VMLANG.'` as l
					 JOIN `#__virtuemart_products` AS p using (`virtuemart_product_id`)
					 LEFT JOIN `#__virtuemart_product_categories` as x on x.`virtuemart_product_id` = p.`virtuemart_product_id`
					 WHERE p.`published`=1 AND  p.`virtuemart_product_id`= "'.(int)$value.'" ';
					$this->_db->setQuery($q);
					$related = $this->_db->loadObject();
					if(empty ($related)) return '';
					$thumb = '';
					$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias`WHERE `virtuemart_product_id`= "'.(int)$value.'" AND (`ordering` = 0 OR `ordering` = 1)';
					$this->_db->setQuery($q);
					if ($media_id = $this->_db->loadResult()) {
						$thumb = $this->displayCustomMedia($media_id);
						return JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $value . '&virtuemart_category_id=' . $related->virtuemart_category_id ), $thumb.' '.$related->product_name, array ('title' => $related->product_name ) );
					}
				break;
				/* image */
				case 'M':
					return $this->displayCustomMedia($value);
				break;
				/* categorie */
				case 'Z':
					$q='SELECT * FROM `#__virtuemart_categories_'.VMLANG.'` as l JOIN `#__virtuemart_categories` AS c using (`virtuemart_category_id`) WHERE `published`=1 AND l.`virtuemart_category_id`= "'.(int)$value.'" ';
					$this->_db->setQuery($q);
					if ($category = $this->_db->loadObject() ) {
						$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_category_medias`WHERE `virtuemart_category_id`= "'.$category->virtuemart_category_id.'" ';
						$this->_db->setQuery($q);
						$thumb ='';
						if ($media_id = $this->_db->loadResult()) {
							$thumb = $this->displayCustomMedia($media_id);
						}
						return  JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=category&virtuemart_category_id=' . $category->virtuemart_category_id ), $thumb.' '.$category->category_name, array ('title' => $category->category_name ) );
					}
					else return '';
				/* Child Group list
				* this have no direct display , used for stockable product
				*/
				case 'G':
					return '';//'<input type="text" value="'.JText::_($value).'" name="field['.$row.'][custom_value]" /> '.JText::_('COM_VIRTUEMART_CART_PRICE').' : '.$price .' ';
					break;
				break;
				/* related */
				case 'R':
				/* Child product */
				case 'C':
					$q='SELECT p.`virtuemart_product_id` ,p.`product_parent_id` , l.`product_name`, x.`virtuemart_category_id` FROM `#__virtuemart_products_'.VMLANG.'` as l
					JOIN `#__virtuemart_products` as p  using (`virtuemart_product_id`)
					LEFT JOIN `#__virtuemart_product_categories` as x on x.`virtuemart_product_id` = p.`virtuemart_product_id`
					WHERE `published`=1 AND p.`virtuemart_product_id`= "'.(int)$value.'" ';
					$this->_db->setQuery($q);
					//echo $this->_db->_sql;
					if ($child = $this->_db->loadObject() ) {
						$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias` WHERE `virtuemart_product_id`= "'.$child->virtuemart_product_id.'" ';
						$this->_db->setQuery($q);
						$thumb ='';
						if ($media_id = $this->_db->loadResult()) {
							$thumb = $this->displayCustomMedia($media_id);
						} else {
							$q='SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias` WHERE `virtuemart_product_id`= "'.$child->product_parent_id.'" ';
							$this->_db->setQuery($q);
							if ($media_id = $this->_db->loadResult()) $thumb = $this->displayCustomMedia($media_id);
						}
						return  JHTML::link ( JRoute::_ ( 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $child->virtuemart_product_id . '&virtuemart_category_id=' . $child->virtuemart_category_id ), $thumb.'<br /> '.$child->product_name, array ('title' => $child->product_name ) );
					}
					else return 'not child'.$value;
				break;
			}
		}
	}

	function displayCustomMedia($media_id,$table='product'){

			if (!class_exists('TableMedias'))
			require(JPATH_VM_ADMINISTRATOR . DS . 'tables' . DS . 'medias.php');
		//$data = $this->getTable('medias');
		$db =& JFactory::getDBO();
		$data = new TableMedias($db);
   		$data->load((int)$media_id);

  		if (!class_exists('VmMediaHandler')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'mediahandler.php');
  		$media = VmMediaHandler::createMedia($data,$table);

		return $media->displayMediaThumb('',false,'',true,true);

	}

	/*
	 * render custom fields display cart module FE
	 */
	public function CustomsFieldCartModDisplay($priceKey,$product) {
		if (empty($calculator)) {
			if(!class_exists('calculationHelper')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'calculationh.php');
			$calculator = calculationHelper::getInstance();
		}
		$product_id = (int)$priceKey;
		$variantmods = $calculator->parseModifier($priceKey);
		$row = 0 ;
		$html = '<div class="vm-customfield-mod">';
		foreach ($variantmods as $variant=>$selected){
			if ($selected) {

				$productCustom = self::getProductCustomFieldCart ($product_id,$selected );
 				if ($productCustom->field_type == "E") {


				} elseif (($productCustom->field_type == "G")) {
					$child = self::getChild($productCustom->custom_value);
					$html .= '<br/ >'.$child->product_name;
				} elseif (($productCustom->field_type == "M")) {
					$html .= ' <span>'.$productCustom->custom_title.' : </span>'.self::displayCustomMedia($productCustom->custom_value);
				}else {

					$html .= ' <span>'.$productCustom->custom_title.' : </span>'.$productCustom->custom_value;
				}
			}
			$row++;
		}
		if ($variantmods) {
			$product = self::addParam($product);
			if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');

			JPluginHelper::importPlugin('vmcustom');
			$dispatcher = JDispatcher::getInstance();
			$dispatcher->trigger('plgVmOnViewCartModule',array($product, $row,&$html));
		}
		return $html.'</div>';
	}

	/*
	 * render custom fields display cart FE
	 */
	public function CustomsFieldCartDisplay($priceKey,$product) {
		if (empty($calculator)) {
			if(!class_exists('calculationHelper')) require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'calculationh.php');
			$calculator = calculationHelper::getInstance();
		}
		$product_id = (int)$priceKey;
		$variantmods = $calculator->parseModifier($priceKey);
		$row = 0 ;

		$html = '<div class="vm-customfield-cart">';
		foreach ($variantmods as $variant=>$selected){
			if ($selected) {
				$productCustom = self::getProductCustomFieldCart ($product_id,$selected );
				$html .= ' <span class="product-field-type-'.$productCustom->field_type.'">';
 				if ($productCustom->field_type == "E") {

				} elseif (($productCustom->field_type == "G")) {
					$child = self::getChild($productCustom->custom_value);
					$html .= $productCustom->custom_title.' : '.$child->product_name.'</span>';
				} elseif (($productCustom->field_type == "M")) {
					$html .= $productCustom->custom_title.' : '.self::displayCustomMedia($productCustom->custom_value).'</span>';
				} else {

					$html .= $productCustom->custom_title.' : '.$productCustom->custom_value.'</span>';
				}
			}
			$row++;
		}
		if ($variantmods ) {
			$product = self::addParam($product);
			if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');
			JPluginHelper::importPlugin('vmcustom');
			$dispatcher = JDispatcher::getInstance();
			$dispatcher->trigger('plgVmOnViewCart',array($product, $row,&$html));

			$html .= '</span>';
		}
		return $html.'</div>';
	}

	/*
	 * render custom fields display order BE/FE
	 */
	public function CustomsFieldOrderDisplay($item,$view='FE') {
		$row = 0 ;
		$item->param = json_decode($item->product_attribute,true);
		$html = '<div class="vm-customfield-cart">';

		foreach ($item->param as $virtuemart_customfield_id=>$param){
 			if ($param) {
				if ($productCustom = self::getProductCustomFieldCart ($item->virtuemart_product_id,$virtuemart_customfield_id ) ) {
// vmdebug('$param',$param);
					if ($productCustom->field_type == "E") {
 

					} elseif (($productCustom->field_type == "G")) {
						$child = self::getChild($productCustom->value);
						$html .= ' <span>'.$productCustom->custom_title.' : '.$child->product_name.'</span>';
					} elseif (($productCustom->field_type == "M")) {
						$html .= ' <span>'.$productCustom->custom_title.' : '.self::displayCustomMedia($productCustom->value).'</span>';
					}  else {

						$html .= '<span>'.$productCustom->custom_title.' : '.$productCustom->value.'</span>';
					}
				} else {
					// falldown method if customfield are deleted
					foreach((array)$param as $key => $value) $html .= '<br/ >'.($key?'<span>'.$key.' : </span>':'').$value;
				}
			}
			$row++;
		}
		if ($item->param) {
			// $item = self::addParam($item);
			if(!class_exists('vmCustomPlugin')) require(JPATH_VM_PLUGINS.DS.'vmcustomplugin.php');
			JPluginHelper::importPlugin('vmcustom');
			$dispatcher = JDispatcher::getInstance();
			$dispatcher->trigger('plgVmDisplayInOrder'.$view,array( $item, $row, &$html));

		}
		return $html.'</div>';
	}

	/*
	 * custom fields for cart and cart module
	 */
	public function getProductCustomFieldCart($product_id,$selected) {
		$db =& JFactory::getDBO();
		$query='SELECT C.`virtuemart_custom_id` , `custom_element` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_cart_attribute` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`,field.`custom_param`,field.`custom_price`
			FROM `#__virtuemart_customs` AS C
			LEFT JOIN `#__virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
			Where `virtuemart_product_id` ='.$product_id.' and `virtuemart_customfield_id` ='.(int)$selected;
		$db->setQuery($query);
		return $db->loadObject();
	}
	/*
	 * add parameter to product definition
	 */
	public function addParam($product) {
			$custom_param = empty($product->custom_param) ? array() : json_decode($product->custom_param,true);
			$product_param = empty($product->customPlugin) ? array() : json_decode($product->customPlugin,true);
			$params = (array)$product_param + (array)$custom_param;
			foreach ($params as $key => $param )
				$product->param[$key] = $param ;
		return $product ;
	}
	public function getChild($child) {
		$db = JFactory::getDBO();
		$db->setQuery('SELECT  `product_sku`, `product_name` FROM `#__virtuemart_products_'.VMLANG.'` WHERE virtuemart_product_id='.$child);
		return $db->loadObject();
	}

	public function setEditCustomHidden($customfield,$i) {
		$html = '
			<input type="hidden" value="'.$customfield->field_type .'" name="field['.$i .'][field_type]" />
			<input type="hidden" value="'.$customfield->virtuemart_custom_id.'" name="field['.$i .'][virtuemart_custom_id]" />
			<input type="hidden" value="'.$customfield->admin_only.'" checked="checked" name="admin_only" />';
		return $html;

	}
}
// pure php no closing tag

Please Log in or Create an account to join the conversation.

Linh Robert
Offline
Banned

12 years 1 week ago #1139 by Linh Robert

Replied by Linh Robert on topic Re: Removing the word "FREE" on product

Ok, I saw and it is in line 538 in your code, it is corrected already:

Code:

$free = JText::_('COM_VIRTUEMART_CART_PRICE_FREE');

So you can check /language/en-GB/en-GB.com_virtuemart.ini to make sure it is translated as this:

Code:

COM_VIRTUEMART_CART_PRICE_FREE=No additional charge

Code:

COM_VIRTUEMART_CART_PRICE_FREE="No additional charge"

Please Log in or Create an account to join the conversation.

Time to create page: 0.253 seconds

Removing the word "FREE" on product

About Growth

Information

Contact Info

Mobile Menu