BUG when using OCS Last Contact (date field) and brazilian portuguese language on multi search page

Question

Hi,

The line with expression "1242 m/d/y" in brazilian portuguese language and others cause incorrect timestamp conversion for a given date (e.g. 07/01/12 - MM/DD/AA), because the portuguese language file has the line with expression "1270 DDMMYYYY" used by input data.

In Brazil, the date representation is DD/MM/AAAA. Thus, the line should be replaced to "1242 d/m/y" to work correctly.

The below debug code is in brazilian language mode:

 

[DEBUG]RAW DATAS[DEBUG]
0 => HARDWARE
[DEBUG]table field=[DEBUG]
0 => LASTCOME
[DEBUG]Comparison field=[DEBUG]
0 => small
[DEBUG]value to search=[DEBUG]
0 => 01/07/2012
[DEBUG]Complementary field=[DEBUG]
[DEBUG]AND OR Field=[DEBUG]

[DEBUG]table =>[DEBUG]HARDWARE
[DEBUG]filed =>[DEBUG] unix_timestamp(LASTCOME) 
[DEBUG]comparison =>[DEBUG] <= 
[DEBUG]value to search =>[DEBUG]1325901600
[DEBUG]complementary field =>[DEBUG]
[DEBUG]AND_OR =>[DEBUG]

[DEBUG]NORMAL CONDITION REQUEST[DEBUG]

---

[DEBUG]REQUEST MADE => [DEBUG]
select distinct ID as HARDWARE_ID from hardware where ( ( unix_timestamp(LASTCOME) <= 1325901600)) and deviceid<>'_SYSTEMGROUP_' AND deviceid <> '_DOWNLOADGROUP_' 
[DEBUG] => weight: [DEBUG]1

 

The below code is in english language mode:

 

[DEBUG]RAW DATAS[DEBUG]
0 => HARDWARE
[DEBUG]table field=[DEBUG]
0 => LASTCOME
[DEBUG]Comparison field=[DEBUG]
0 => small
[DEBUG]value to search=[DEBUG]
0 => 07/01/2012
[DEBUG]Complementary field=[DEBUG]
[DEBUG]AND OR Field=[DEBUG]

[DEBUG]table =>[DEBUG]HARDWARE
[DEBUG]filed =>[DEBUG] unix_timestamp(LASTCOME) 
[DEBUG]comparison =>[DEBUG] <= 
[DEBUG]value to search =>[DEBUG]1341111600
[DEBUG]complementary field =>[DEBUG]
[DEBUG]AND_OR =>[DEBUG]

[DEBUG]NORMAL CONDITION REQUEST[DEBUG]

---

[DEBUG]REQUEST MADE => [DEBUG]
select distinct ID as HARDWARE_ID from hardware where ( ( unix_timestamp(LASTCOME) <= 1341111600)) and deviceid<>'_SYSTEMGROUP_' AND deviceid <> '_DOWNLOADGROUP_' 
[DEBUG] => weight: [DEBUG]1

 

Answer 1

What timezone have you set in your php.ini ?

Comments

Hi,

The default timezone of php configuration is America/Sao_Paulo.

 

Default timezone

America/Sao_Paulo

 

The result for this filter is correctly shown in english, french and italian. Incorrect results are obtained in brazilian, spanish, polish, portuguese.

 

$ grep '1242' language/*/*.txt | cat -n

     1 language/brazilian_portuguese/brazilian_portuguese.txt:1242 m/d/y

     2 language/english/english.txt:1242 m/d/y

     3 language/french/french.txt:1242 d/m/y

     4 language/german/german.txt:1242 M/T/J

     5 language/hungarian/hungarian.txt:1242 m/d/y

     6 language/italian/italian.txt:1242 d/m/y

     7 language/polish/polish.txt:1242 m/d/y

     8 language/portuguese/portuguese.txt:1242 m/d/y

     9 language/russian/russian.txt:1242 m/d/y

    10 language/slovenian/slovenian.txt:1242 m/d/y

    11 language/spanish/spanish.txt:1242 m/d/y

    12 language/turkish/turkish.txt:1242 m/d/y

 

$ grep '1270' language/*/*.txt | cat -n

     1 language/brazilian_portuguese/brazilian_portuguese.txt:1270 DDMMYYYY

     2 language/english/english.txt:1270 MMDDYYYY

     3 language/french/french.txt:1270 DDMMYYYY

     4 language/german/german.txt:1270 TTMMJJJJ

     5 language/hungarian/hungarian.txt:1270 DDMMYYYY

     6 language/italian/italian.txt:1270 DDMMYYYY

     7 language/polish/polish.txt:1270 DDMMYYYY

     8 language/portuguese/portuguese.txt:1270 DDMMYYYY

     9 language/russian/russian.txt:1270 DDMMYYYY

    10 language/slovenian/slovenian.txt:1270 DDMMYYYY

    11 language/spanish/spanish.txt:1270 DDMMYYYY

    12 language/turkish/turkish.txt:1270 DDMMYYYY

 

$ head -300 require/function_search.php | tail -10

//modification d'un champ texte en date dans certains cas

  if ($field == "LASTDATE" or $field == "LASTCOME" or $field == "REGVALUE"){

  $tab_date = explode('/', $field_value);

  $ref_date = explode('/', $l->g(1242));

$day=array_search('d',$ref_date);

$months=array_search('m',$ref_date);

$year=array_search('y',$ref_date);

  //on applique le traitement que si la date est valide

  if (@checkdate ($tab_date[$months],$tab_date[$day],$tab_date[$year])){

  $field= " unix_timestamp(".$field.") ";

 

$ head -427 require/function_search.php | tail -8

$select2 .= "</select>";

echo "<td>".$select2;

if (array_key_exists($value,$opt2SelectField)){

if ($opt2SelectField[$value."-LBL"] == "calendar")

$opt2SelectField[$value."-LBL"]= calendars("InputValue-".$nameField,$l->g(1270));

echo $select."&nbsp;&nbsp;<input name='InputValue-".$nameField."' id='InputValue-".$nameField."' value=\"".stripslashes($protectedPost["InputValue-".$nameField])."\">&nbsp;".$opt2SelectField[$value."-LBL"];

}

 

 

Answer 2

This directive is commented on php.ini.