| 
			
							
				 Hello... Ok do you think you can resolv my problem with support ? 
			 | 
			
				Vminvice with VM 1.1 ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Now, VM invoice calcul Total price with Total without taxe 
Is it possible to permit doing the inverse : 
Total with taxe permit to obtain total without TAXE see screen attachement... 
 
It will be very good for everybody 
 
Thank's & best regards 
			 | 
			
				Vminvice with VM 1.1 ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Now, VM invoice calcul Total price with Total without taxe 
Is it possible to permit doing the inverse : 
Total with taxe permit to obtain total without TAXE see screen attachement... 
 
It will be very good for everybody 
 
Thank's & best regards 
			 | 
			
				Vminvice with VM 1.1 ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Hello, in the item calcul part, is it possible to calcule price without TAX directly with prices all tax ?? 
 
Thanks. 
			 | 
			
				Vminvice with VM 1.1 ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 I think it's work.... I'm going to test it more profundly.. 
Thanks, 
			 | 
			
				manual order entry,  ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 My version is Version: 	2.0.39 
Dernière version: 	2.0.39 
Date: 	16. June 2014 
 
What is the ID of "in stock status" because i have e french version... 
			 | 
			
				manual order entry,  ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 When I create a manual order, the stock is not accounting and does not escape. 
thanks 
			 | 
			
				manual order entry,  ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Hello, i'm working in Tense flow and i must have a stock check for my Inventory management. 
I have Joomla 1.5 and Virtuemart 1.1.9 
 
Thank's 
			 | 
			
				manual order entry,  ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Good job, thank you very much.... That' work... 
ARTIO = very serious, very good 
Thank's & best regards 
 
Gaël 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Hello, my VM version is 1.1.9 
yes, this two colunms are in virtuemart *_products 
 
thanks 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 I tried : 
        	WHERE '.implode(' OR ', $wheres).' OR p.`product_sku` LIKE ' . $db->Quote('%'.$filter.'%').' OR p.`product_barcode` = ' . $db->Quote('%'.$filter.'%').' OR p.`product_isbn` = ' . $db->Quote('%'.$filter.'%'), 0, 50);  
 
But it's the same thing... 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 Good for the component, but nothing appears in the search bar... 
 
 
Sorry and thank you 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 White page on the composant with this code : 
 
	//join all language tables, because we search in all languages and we need at least one translation 
        	$joins = $wheres = $selects = array(); 
        	foreach (self::getVm2LanguageTable('#__virtuemart_products', -1) as $o => $tableName){ 
        		$selects[] = '`'.$tableName.'`.product_name AS product_name_'.substr($tableName, -5); 
        		$joins[] = 'LEFT JOIN `'.$tableName.'` ON (p.virtuemart_product_id = `'.$tableName.'`.virtuemart_product_id)'; 
        		$wheres[] = '`'.$tableName.'`.`product_name` LIKE '.$db->Quote('%' . $filter . '%').''; 
        	} 
        	 
        	$db->setQuery('SELECT p.`virtuemart_product_id` AS `id`, p.`product_sku`,  
        	p.product_in_stock, p.product_ordered, '.implode(', ', $selects).' 
        	FROM `#__virtuemart_products` AS p '.implode(' ', $joins).'  
        	WHERE '.implode(' OR ', $wheres).' OR p.`product_sku` LIKE ' . $db->Quote('%'.$filter.'%').' OR p.`product_barcode` LIKE ' .  
			$db->Quote($filter).' OR p.`product_isbn` LIKE ' . $db->Quote($filter). ,0,50); 
        } 
        else 
        	$db->setQuery('SELECT `product_id` AS `id`,`product_name`, `product_sku`, product_in_stock 
        	FROM `#__vm_product`  
        	WHERE `product_name` LIKE ' . $db->Quote('%' . $filter . '%').' OR `product_sku` LIKE ' . $db->Quote('%' . $filter . '%'),0,50); 
 
		$res = $db->loadObjectList(); 
		if (COM_VMINVOICE_ISVM2) 
       		self::pickTranslation($res, 'product_name', $lang); //pick proper translation of product name 
         
        foreach ($res as $product) 
 
 
Thanks 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 In my table the colunms names are : product_barcode and product_isbn 
varchan 200 
 
thanks 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
				
			
				 			 | 
			
							
				 How to modify product search to find proctucs with a special colunm entry ? 
			 | 
			
				How to modify produc ...												
			 | 
			
				
					
										
					
										
					
					
						Posted 11 years, 4 months ago 
					
										
					by gael30
										
				 
			 | 
		
						
		
			| 
				More			 |