search filter on date

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #199799

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 2.5.28
-- PHP version -- : 5.x

hi
Is there a way
1- to filter products base on field of any products field that support " date type " ?
2- to show list of products base on the many product field value ?
3- to mix many filter for search or link to products ?
thank's

Last edit: 9 years 7 months ago by lionel75.

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

  • Posts: 82867
  • Thank you received: 13373
  • MODERATOR
9 years 7 months ago #199845

Hi,

1. There is no option to do that. You would have to develop your own filtering module in that case.

2. With the filters yes. You can create filters applying on each of your custom product fields, which will then allow the customers to show a list of products based on what they select in these filters.

3. Yes, you can create several filters and have them work together for the filtering of the products listings.

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

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #199899

Hi
Product can have many categories and i think categories exsit to be use with filter , search ,menu.
Does filter can use many categories because i don't succeed to select category1 AND category2 for my filter !! in a way the label name is category not categories ... but JEvents let us select multicategories and hikashop let us selct multicategories for product !!!




regard's

Attachments:
Last edit: 9 years 7 months ago by lionel75.

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

  • Posts: 82867
  • Thank you received: 13373
  • MODERATOR
9 years 7 months ago #199902

Hi,

This field is to say on which category you want to display the filter. You can only select one category there.
It has no incidence on the categories which would be listed inside the filter.

The following user(s) said Thank You: lionel75

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

  • Posts: 846
  • Thank you received: 92
9 years 6 months ago #201000

I ll study write now joomla extension extension .....
I try to understand the logic ( database cell format , hks BE GUI , joomla core) of hikashop compare to joomla choice implementation of some extension .

If i take date :
-joomla core use datetime
-hikashop use int ( like product_sale_end )
-hikashop use for custom field a date picker store in text format ? ( perhaps i write a mistake )

From a php ( and SLQ ) point of view why use so many differents date storage for manage date ?
I think there is a logic behind this that i don't understand until now .
Does datetime is a nightmare to manage in php ?
Does use unix storage is still more efficient ( speed) that use date time type object ?

Thank' s

Attachments:

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

  • Posts: 82867
  • Thank you received: 13373
  • MODERATOR
9 years 6 months ago #201014

We use int for the normal dates in the database instead of datetime because it is easier to make operations (for statistics, reports, filters, etc) on the columns and it is simpler to handle timezones.

We use a "text" format for the custom fields as you want the data to be readable even if you change the type of the custom field or when you export the data, and there is still no problem with timezones, and on top of that, you can have dates older than 1970 which is handy for birthday custom fields which wouldn't be possible with a timestamp...

There are different formats for everything because they solve different things. For example for the images:
JPG is compressed (small file size) so it's great for photos with a lot of pixels
PNG is not compressed (bigger file size) so it's great for icons, small images where you don't want to loose any detail. It also supports transparency
GIF is great for small images, animations because it is limited in the number of colors, but can support several frames played one after another.
Each format was made for a different purposes.

More information on SQL date formats:
stackoverflow.com/questions/409286/datetime-vs-timestamp
code.openark.org/blog/mysql/timestamp-vs...ch-should-i-be-using

The following user(s) said Thank You: lionel75

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

  • Posts: 846
  • Thank you received: 92
9 years 6 months ago #201103

Hi
thank's you for the great comparison beetween date and image ! All make sense ..... now

regard's

Last edit: 9 years 6 months ago by lionel75.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum