searching Filter in other language doesn't work

SG
Topic Author
Offline

13 years 5 months ago - 13 years 5 months ago #104116 by SG

searching Filter in other language doesn't work was created by SG

Hi,

I made a filter in HikaShop (see picture below) and a Module of the type: mod_hikashop_filter (also see second picture below).
Now I can use it to search product names and codes(numbers).
This seems to work only for one language!

The site is using three languages (en, nl, fr) so I'd like to be able to search in those three languages. I'm using Falang and the rest of the site (products, categories) get's translated fine.

Luck-ally the product_code is working in the three languages since it obviously doesn't change but when I go to french and search something in french, it doesn't work.

1) Am I missing something to make this work for the other languages? for example using french words when visiting french version.

2) If question 1 is solved would it be possible to make the search wider so it searches in all languages. That way someone can use a french word when he is returning to the site and forgot to change the language from english to french. Otherwise he might think that it doesn't exist.

I'm using HikaShop 2.1.0 and Joomla 2.5 by the way.

Thanks guys.

Edit:
Here are the request when debugging is on:

Code:

42 requêtes exécutées

    SELECT *
      FROM x6ou0_hikashop_config
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM x6ou0_menu AS m
      LEFT JOIN x6ou0_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    SELECT joomlatablename,tablepkID
      FROM `x6ou0_falang_tableinfo`
    SELECT *
      FROM x6ou0_languages
      ORDER BY ordering
    SHOW FULL COLUMNS
      FROM `x6ou0_languages`
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(513,526,549,233,548,546,486,464,444,201,449,450,469,470,471,472,503,502,514,547)
      AND falang_content.reference_table='menu'
    SELECT *
      FROM x6ou0_menu
      WHERE id = '470'
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(470)
      AND falang_content.reference_table='menu'
    SELECT *
      FROM x6ou0_hikashop_category
      WHERE category_id = '2'
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(2)
      AND falang_content.reference_table='hikashop_category'
    SELECT category_id
      FROM x6ou0_hikashop_category
      WHERE (category_access = 'all' OR category_access LIKE '%,13,%')
      AND category_id IN (2)
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(2)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM x6ou0_hikashop_filter
      WHERE filter_published = 1
      AND (filter_access = 'all' OR filter_access LIKE '%,13,%')
      ORDER BY filter_ordering
    SELECT b.*
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id=2
      GROUP BY b.category_id
      ORDER BY b.category_left
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(1,2)
      AND falang_content.reference_table='hikashop_category'
    SELECT a.*,b.*
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_file AS b
      ON a.category_id=b.file_ref_id
      AND b.file_type='category'
      WHERE a.category_id = 2
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(2)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM x6ou0_hikashop_category
      WHERE category_id = '2'
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(2)
      AND falang_content.reference_table='hikashop_category'
    SELECT a.*
      FROM x6ou0_hikashop_category AS a
      WHERE a.category_left > 2
      AND a.category_right < 871
      AND a.category_type = 'product'
      AND a.category_published=1
      AND (a.category_access = 'all' OR a.category_access LIKE '%,13,%')
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM x6ou0_menu
      WHERE id = '470'
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(470)
      AND falang_content.reference_table='menu'
    SELECT DISTINCT b.*
      FROM x6ou0_hikashop_product_category AS a
      LEFT JOIN x6ou0_hikashop_product AS b
      ON a.product_id=b.product_id
      WHERE b.product_published=1
      AND b.product_type = 'main'
      AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,2)
      AND (b.product_access = 'all' OR b.product_access LIKE '%,13,%')
      AND ( b.product_alias LIKE '%Fleur%' OR b.product_code LIKE '%Fleur%' OR b.product_description LIKE '%Fleur%' OR b.product_name LIKE '%Fleur%' )
      ORDER BY a.ordering ASC
      LIMIT 0, 50
    SELECT count( DISTINCT b.product_id)
      FROM x6ou0_hikashop_product_category AS a
      LEFT JOIN x6ou0_hikashop_product AS b
      ON a.product_id=b.product_id
      WHERE b.product_published=1
      AND b.product_type = 'main'
      AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,2)
      AND (b.product_access = 'all' OR b.product_access LIKE '%,13,%')
      AND ( b.product_alias LIKE '%Fleur%' OR b.product_code LIKE '%Fleur%' OR b.product_description LIKE '%Fleur%' OR b.product_name LIKE '%Fleur%' )
      ORDER BY a.ordering ASC
    SELECT b.*
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id=2
      GROUP BY b.category_id
      ORDER BY b.category_left
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(1,2)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM x6ou0_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='category'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,13,%')
      AND ((field_with_sub_categories=0
      AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1
      AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%')))
      ORDER BY a.`field_ordering` ASC
    SELECT ts.template
      FROM x6ou0_template_styles AS ts
      INNER JOIN x6ou0_menu AS m
      ON ts.id=m.template_style_id
      WHERE m.id = 470
      AND m.template_style_id != 0
    SELECT *
      FROM x6ou0_hikashop_filter
      WHERE filter_published = 1
      AND (filter_access = 'all' OR filter_access LIKE '%,13,%')
      ORDER BY filter_ordering
    SELECT *
      FROM x6ou0_menu
      WHERE id = '470'
      LIMIT 1
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(470)
      AND falang_content.reference_table='menu'
    SELECT a.*, COUNT(pc.product_id) AS product_count
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_product_category AS pc
      ON pc.category_id = a.category_id
      WHERE a.category_type = 'product'
      AND a.category_parent_id > 1
      AND a.category_published = 1
      GROUP BY a.category_id
      ORDER BY a.category_left, a.category_ordering
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(12,15,16,41,42,17,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,18,19,39,40,20,13,43,44,45,46,47,91,92,48,49,93,94,50,51,52,53,54,55,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,56,95,96,57,58,59,60,97,98,61,62,63,64,65,66,14,99,100,101,102,129,130,103,131,132,104,105,106,107,108,109,117,118,119,120,121,122,123,124,125,126,127,128,110,133,134,111,112,135,136,113,114,115,116)
      AND falang_content.reference_table='hikashop_category'
    SELECT a.id
      FROM x6ou0_menu AS a
      WHERE a.link LIKE '%option=com_hikashop%'
      AND a.link LIKE '%view=category%'
      AND a.link LIKE '%layout=listing%'
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
      WHERE falang_content.language_id=3
      AND falang_content.published=1
      AND falang_content.reference_id IN(469,473,505,526,514)
      AND falang_content.reference_table='menu'
    SELECT a.*
      FROM x6ou0_hikashop_config AS a
      WHERE config_namekey IN ('menu_469','menu_473','menu_505','menu_526','menu_514')
    SELECT r.*
      FROM x6ou0_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'component')
      ORDER BY r.ordering, r.id
    SELECT r.*
      FROM x6ou0_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'body')
      ORDER BY r.ordering, r.id
    SELECT r.*
      FROM x6ou0_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'everywhere')
      ORDER BY r.ordering, r.id
    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM x6ou0_categories as c
      LEFT JOIN x6ou0_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM x6ou0_categories AS cat JOIN x6ou0_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id=79
      AND badcats.id is null
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
      ORDER BY c.lft
    UPDATE `x6ou0_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:47;s:19:\"session.timer.start\";i:1368619955;s:18:\"session.timer.last\";i:1368622144;s:17:\"session.timer.now\";i:1368622226;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:2:\"21\";s:22:\"470_filter_test_filter\";s:5:\"Fleur\";s:48:\"product_hikashop_category_information_menu_470_2\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:13;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"608d68efa905e6a5c295d92ce3e00caf\";}hikashop_viewed_products|a:5:{i:1290;i:1290;i:99;i:99;i:1273;i:1273;i:2404;i:2404;i:2783;i:2783;}' , `time` = '1368622227'
      WHERE `session_id` = '129027498b3aaaea71a057b08200eaf7'

23 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :

    13 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM x6ou0_falang_content AS falang_content
    3 × SELECT *
      FROM x6ou0_menu
    3 × SELECT r.*
      FROM x6ou0_rereplacer AS r
    2 × SELECT b.*
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_category AS b
      ON a.category_left >= b.category_left
    2 × SELECT *
      FROM x6ou0_hikashop_filter
    2 × SELECT *
      FROM x6ou0_hikashop_category
    1 × SELECT ts.template
      FROM x6ou0_template_styles AS ts
      INNER JOIN x6ou0_menu AS m
      ON ts.id=m.template_style_id
    1 × SELECT *
      FROM x6ou0_hikashop_field as a
    1 × SELECT a.*, COUNT(pc.product_id) AS product_count
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_product_category AS pc
      ON pc.category_id = a.category_id
    1 × SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM x6ou0_categories as c
      LEFT JOIN x6ou0_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM x6ou0_categories AS cat JOIN x6ou0_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
    1 × SELECT a.id
      FROM x6ou0_menu AS a
    1 × SELECT a.*
      FROM x6ou0_hikashop_config AS a
    1 × SELECT count( DISTINCT b.product_id)
      FROM x6ou0_hikashop_product_category AS a
      LEFT JOIN x6ou0_hikashop_product AS b
      ON a.product_id=b.product_id
    1 × SELECT a.*,b.*
      FROM x6ou0_hikashop_category AS a
      LEFT JOIN x6ou0_hikashop_file AS b
      ON a.category_id=b.file_ref_id
      AND b.file_type='category'
    1 × SELECT joomlatablename,tablepkID
      FROM `x6ou0_falang_tableinfo
    1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM x6ou0_menu AS m
      LEFT JOIN x6ou0_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT *
      FROM x6ou0_languages
    1 × SELECT category_id
      FROM x6ou0_hikashop_category
    1 × SELECT a.*
      FROM x6ou0_hikashop_category AS a
    1 × SELECT *
      FROM x6ou0_hikashop_confi
    1 × SELECT DISTINCT b.*
      FROM x6ou0_hikashop_product_category AS a
      LEFT JOIN x6ou0_hikashop_product AS b
      ON a.product_id=b.product_id

Autres tables :

    1 × UPDATE `x6ou0_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:47;s:19:\"session.timer.start\";i:1368619955;s:18:\"session.timer.last\";i:1368622144;s:17:\"session.timer.now\";i:1368622226;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:2:\"21\";s:22:\"470_filter_test_filter\";s:5:\"Fleur\";s:48:\"product_hikashop_category_information_menu_470_2\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:13;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"608d68efa905e6a5c295d92ce3e00caf\";}hikashop_viewed_products|a:5:{i:1290;i:1290;i:99;i:99;i:1273;i:1273;i:2404;i:2404;i:2783;i:2783;}' , `time` = '1368622227'
    1 × SHOW FULL COLUMNS
      FROM `x6ou0_languages

Last edit: 13 years 5 months ago by SG.

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

nicolas
Offline

13 years 5 months ago #104155 by nicolas

Replied by nicolas on topic searching Filter in other language doesn't work

Hi,

You're not missing anything. Text filters do not handle translations for now so only the main information of the product is taken into account.
Actually you're the first one requesting it.

I added an issue on our tracking system in order to handle that for next version of HikaShop, but in the mean time, an alternative to such text filter is to use the Joomla search module alongside with the hikashop product search plugin which handles the translations.

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

SG
Topic Author
Offline

13 years 5 months ago - 13 years 5 months ago #104173 by SG

Replied by SG on topic searching Filter in other language doesn't work

Hi,

I like the way that Filter shows all products in a layout that customers are use to when browsing a category.
I made a listing with 4 columns as you can see in the first picture below.
The product name, product code and price is shown in the result. (price is currently hidden for not logged in users)

When I tried out the search module and placed it also on the left side and search the same word, the result doesn't look that nice.
First you see options (like SEARCH FOR: any words, all words, exact phrase & SEARCH ONLY: .... ) that are not needed in my case and the products are shown in text in a list without product code, price and picture. It also first show the product category which is not needed. And as you can see the layout isn't nice and you loose a lot of space. (see second picture)

If there was a way to use the search plugin and show the result like the filter does than it would definitely be a good alternative. I don't know where to change the appearance of the result to make it look like the result of the filter? Is this possible?

Result with Filter when searching for the word: Flowers

Result with Search plugin. Also when searching for the word: Flowers

About making the filter work:
If you know the code to change the sql-query to include the falang content table and the change the following result query, I wouldn't mind changing it if you tell what code to place in which file.

Code:

SELECT DISTINCT b.*
  FROM x6ou0_hikashop_product_category AS a
  LEFT JOIN x6ou0_hikashop_product AS b
  ON a.product_id=b.product_id
  WHERE b.product_published=1
  AND b.product_type = 'main'
  AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,2)
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%' OR b.product_access LIKE '%,2,%')
  AND ( b.product_alias LIKE '%flowers%' OR b.product_code LIKE '%flowers%' OR b.product_description LIKE '%flowers%' OR b.product_name LIKE '%flowers%' )
  ORDER BY a.ordering ASC
  LIMIT 0, 50

Last edit: 13 years 5 months ago by SG.

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

nicolas
Offline

13 years 5 months ago #104181 by nicolas

Replied by nicolas on topic searching Filter in other language doesn't work

That's not possible, the search results page of joomla cannot be substituted by a HikaShop products listing page.

And for the code to change the query: I'll tell you once we develop the feature. It's not just two lines of code to add. It's more complex and it needs to be done and tested properly.

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

SG
Topic Author
Offline

13 years 5 months ago #104182 by SG

Replied by SG on topic searching Filter in other language doesn't work

I see. I'm out of luck then.

Thanks for getting back so quickly and letting me know.

I'm looking forward for the code so if you need a guinea pig to test it once it's developed, definitely let me know

The following user(s) said Thank You: nicolas

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

SG
Topic Author
Offline

13 years 5 months ago #104752 by SG

Replied by SG on topic searching Filter in other language doesn't work

Hi,

In the meantime I found out way to do it and I like to share it.
It's really just a silly workaround but it works for now.

The trick is to combine the three language in a field of choose that you are not displaying.
It can be a custom field that you hide or like in my case I did it with product_description since we are not using it.

For example when you have the following columns/languages:

product_name|en-GB (column S)/li]
product_name|fr-FR (column T)
product_name|nl-NL (column V)

Then you just combine these these three fields in the column/field of your choose, like I said previously I'll be using product_description and I put:

Code:

S & " " & T & " " & V

So I get something like:

Magnet red mushroom Aimant champignon rouge Magneet rode paddestoel

Don't forget to add product_description or the field that you have chosen in the filter.
The advantage is that you can search in whatever language you want. So you can use french words while you are browsing in english.

This might help achieve a bit of the same effect until HikaShop has time to implement it the right way.

Cheers

The following user(s) said Thank You: Xavier

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

Time to create page: 0.115 seconds