next »

[jehanon]

Do you know an extension for virtuemart to search on jos_vm_product.attribute  + jos_vm_product_type_1.color  + categories  ?

thank you

[zanardi]

No. But you may extend the VM search plugin to search wherever you need.

--
Francesco (zanardi)

[useris]

Hi,

Sorry for asking. Could you givea tip or advice or a code for VM search plugin which will search in jos_vm_product_type_1 table.
I have spent the whole week but could not get it work, I ma not PHP programmer.

Thanks

[BanquetTables.pro]

jehanon

Searching attributes is not the way to do this. IF it SHOULD be searchable, it should be a product_type

[useris]

Should I edit VM search plugin? Or which VM file I must alter?

[useris]

Weird that noone has a solution or has but don't wish to share. I am just with basic PHP knowledges, so VM comunity help woud be more than helpfull.

I need to make my virtuemart to search product type (_jos_vm_produc_type_x)

[BanquetTables.pro]

useris

I dont know of a search module that searches product type. Or seen anyone do a mod.

There are some filters here
http://extensions.virtuemart.net/index.php?option=com_sobi2&sobi2Task=sobi2Details&sobi2Id=566&Itemid=2


They are not exactly what you are looking for though

[useris]

Hi BanquetTables.pro,

Now filtering module is not what I need. I just did few testing on my site and search can find product if search phrase does not contain dot (.) for ex, search for 52
But If I will type search parameter with dot for ex. 52.11 it will not find my product.
I have product types which have dots.

I looked into vmsearch plugin and see the part of the code which builds search logic but don't know how to make it search phrases with dots

Code:

// Build search logic
$wheres = array( ) ;
switch( $phrase) {
case 'exact' :
$wheres2 = array( ) ;
foreach( $fields as $field ) {
$wheres2[] = "$field LIKE '%.%".$database->getEscaped($text)."%.%'" ;
}
$where = '(' . implode( ') OR (', $wheres2 ) . ')' ;
break ;
case 'all' :
case 'any' :
default :
$words = explode( ' ', $text ) ;
$wheres = array( ) ;
foreach( $words as $word ) {
$wheres2 = array( ) ;
foreach( $fields as $field ) {
$wheres2[] = "$field LIKE '%".$database->getEscaped($word)."%'" ;
}
$wheres[] = implode( ' OR ', $wheres2 ) ;
}
$where = '(' . implode( ($phrase == 'all' ? ') AND (' : ') OR ('), $wheres ) . ')' ;
break ;
}

[useris]

Hi,

I found out that VM search plugin search for product types. But new problem is that it only finds if I type search parameters without dots for ex. 31 and it will find all product which type contains 35

But if I search fro product type wtih dot for ex. 31.56 it will not find any product. Is it a bug in that plugin or VM? I configured product type value as "float" so it should understand that product type contains dats.

useris

I dont know of a search module that searches product type. Or seen anyone do a mod.

There are some filters here
http://extensions.virtuemart.net/index.php?option=com_sobi2&sobi2Task=sobi2Details&sobi2Id=566&Itemid=2


They are not exactly what you are looking for though