Sprachdateien

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3

Ich habe ein bis zwei Fragen zu den Sprachfiles und zu dem Datumsformat:

In der Bestellübersicht des Kunden steht -trotz deutscher Sprachfiles- der Status in englisch (cancelled, shipped...) usw. Wo finde ich die Sprachfiles zum Ändern?

Ferner sind viele Datumsanzeigen nicht im deutschen Format, sondern ebenfalls im englischen Format. Wo kann das geändert werden? Kann es sein, das deswegen die Mass Action wie hier beschrieben nicht funktioniert? Ich kann eingeben was ich will, es werden immer alle Produkte angezeigt.

Was muss ich genau eingeben, wenn 10 Tage vor "product sales end" eine Aktion durchgeführt werden soll?

Hoffe ich habe es halbwegs verständlich formuliert.

Ups, for the Date files i have found this Topic . When will be there a new Version of the Shop?

I have the language files found and new created

nicolas wrote: Hi,

1. The order statuses are already translated in HikaShop. Please replace the content of the file administrator/components/com_hikashop/types/categorysub.php with this: pastebin.com/wJYf6Xrh
Then it should display the statuses in German.

nicolas wrote: 2. The date formats come from translations. You can change these translations with an override
HIKASHOP_DATE_FORMAT="%d %B %Y"
HIKASHOP_EXTENDED_DATE_FORMAT="%d %B %Y %H:%M"
hikashop.com/download/languages.html#modify

nicolas wrote: 3. The date display format is not related to the mass actions filtering system.
For such filtering rule, you want to have a product column filter like this:
product_sale_end <= {time}+864000

nicolas wrote:
4. Next version of HikaShop will be released in a few weeks.

hi..

nicolas wrote: Hi,

2. Not all the dates use yet these translations. For these, you need to edit the "listing" file of the "order" view for your backend template via the menu Display>Views and change the format in that file directly.

nicolas wrote: 3. I'm pretty sure the mass action should work as I said. If you turn on the debug mode option of the Joomla configuration and process the mass action to display the products, what are the queries logged at the bottom of the result page ?

UPDATE `ah5we_hikashop_massaction` 
  SET `massaction_name`='test',`massaction_description`='',`massaction_published`='1',`massaction_table`='product',`massaction_triggers`='',`massaction_filters`='a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:5:\"
  limit\";s:4:\"data\";a:2:{s:5:\"start\";s:1:\"0\";s:5:\"value\";s:3:\"500\";}}i:2;O:8:\"stdClass\":2:{s:4:\"name\";s:13:\"productColumn\";s:4:\"data\";a:3:{s:4:\"type\";s:16:\"product_sale_end\";s:8:\"operator\";s:2:\"<=\";s:5:\"value\";s:13:\"{time}+864000\";}}}',`massaction_actions`='a:1:{i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:14:\"displayResults\";s:4:\"data\";a:1:{s:7:\"product\";a:8:{s:10:\"product_id\";s:10:\"product_id\";s:12:\"product_name\";s:12:\"product_name\";s:16:\"product_quantity\";s:16:\"product_quantity\";s:12:\"product_code\";s:12:\"product_code\";s:17:\"product_published\";s:17:\"product_published\";s:11:\"product_hit\";s:11:\"product_hit\";s:18:\"product_sale_start\";s:18:\"product_sale_start\";s:16:\"product_sale_end\";s:16:\"product_sale_end\";}}}}' 
  WHERE `massaction_id`='2'

„EXPLAIN“ unmöglich für Abfrage: UPDATE `ah5we_hikashop_massaction` SET `massaction_name`='test',`massaction_description`='',`massaction_published`='1',`massaction_table`='product',`massaction_triggers`='',`massaction_filters`='a:2:{i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:5:\"limit\";s:4:\"data\";a:2:{s:5:\"start\";s:1:\"0\";s:5:\"value\";s:3:\"500\";}}i:2;O:8:\"stdClass\":2:{s:4:\"name\";s:13:\"productColumn\";s:4:\"data\";a:3:{s:4:\"type\";s:16:\"product_sale_end\";s:8:\"operator\";s:2:\"<=\";s:5:\"value\";s:13:\"{time}+864000\";}}}',`massaction_actions`='a:1:{i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:14:\"displayResults\";s:4:\"data\";a:1:{s:7:\"product\";a:8:{s:10:\"product_id\";s:10:\"product_id\";s:12:\"product_name\";s:12:\"product_name\";s:16:\"product_quantity\";s:16:\"product_quantity\";s:12:\"product_code\";s:12:\"product_code\";s:17:\"product_published\";s:17:\"product_published\";s:11:\"product_hit\";s:11:\"product_hit\";s:18:\"product_sale_start\";s:18:\"product_sale_start\";s:16:\"product_sale_end\";s:16:\"product_sale_end\";}}}}' WHERE `massaction_id`='2'

SELECT hk_product.* 
  FROM ah5we_hikashop_product as hk_product 
  WHERE (hk_product.product_sale_end <= '2014-09-14 02:24:30') 
  LIMIT 0, 500

1	SIMPLE	hk_product	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where

Hi,

Thanks to edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "getRequest" remove/comment the line:

//$filter['value'] = strftime('%Y-%m-%d %H:%M:%S',$filter['value']);

Xavier wrote: Hi,

Thanks to edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "getRequest" remove/comment the line:

//$filter['value'] = strftime('%Y-%m-%d %H:%M:%S',$filter['value']);

Sorry, it´s me again.

Theres another problem with my Mass-Action.

I fount this nice example: change the category of a product .

In this example you write: product_quantity = 0, but whatever I do, the 0 does not work. If i set "0" all my products will be changed to out of stock, but if I set "-0" it seems it works. Could that be right???

Hi,

If it works with "-0", so use it. With "0" that should be ok, I will do some checks about that.

There is not yet complete documentation for this. It's on my todo list
"Int", "Float", "String" I think that it's ok, regarding operation, you should find an example in the documentation, you can edit dynamically the values, for example increase the stock by 1 thanks to: "product.product_quantity + 1"