[jira] Created: (OFBIZ-1168) Provide date/time locale support to ofbiz

[Nicolas Malin (Jira)]

Provide date/time locale support to ofbiz
-----------------------------------------

                 Key: OFBIZ-1168
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
             Project: OFBiz
          Issue Type: Improvement
    Affects Versions: SVN trunk
            Reporter: Daniel Martínez
            Priority: Minor


Provide locale date/time support for ofbiz. This includes:

- Showing date/time data in locale format
- Allowing the user to input date/time data in his locale format

Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Martínez updated OFBIZ-1168:
-----------------------------------

    Attachment: locale_date_format.patch

Resume:

- Adds a new option in general.properties to configure ofbiz to use locale date/time format or no (defaults to no)
- Adds two new utility methods in UtilDateTime.java to convert between a sortable format string to a localized one and to get the format used (for the javascript calendar)
- Modifies javascript calendar to support localized formats. For this a new javascript library file is used (MIT license) from Matt Kruse
- Modifies screenWidgetHtmlFormRenderer to support localized date formats

When locale.dateformat=N, ofbiz works with sortable date formats normally
When locale.dateformat=Y, ofbiz uses localized date/time formats, but it does not work:

- For java methods accesed directly from the controller (as they are not aware of the use of locale formats, i.e. order manager)
- For performFind service (see https://issues.apache.org/jira/browse/OFBIZ-221)

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12514416 ]

Adrian Crum commented on OFBIZ-1168:
------------------------------------

Daniel,

Thank you for the patch! Have you taken a look at OFBIZ-1164? I believe it would be best to wait on some of this until that issue makes its way into the project.

An improved popup calendar is something we sorely need. The one in this patch assumes a US locale - the same problem the current one has. Licensing may be an issue also. I recommend writing one from scratch that gets passed a properly constructed java.util.Calendar object - then use that object in the java script to handle Month/Day names, date/time formatting, etc. See the UtilDateTime.toCalendar method. Also take a look at how that method is used in the month.bsh script in OFBIZ-1089.

Localized date/time formats will not work in the components (like order manager) until they are updated to support it.

Don't be discouraged - I support the idea of configurable date/time data entry, but right now you are shooting at a moving target. Let's wait until OFBIZ-1164 gets committed, then we can see where to make the necessary changes.

In the meantime, an updated popup calendar would be a good thing to work on - if you are inclined to do so.

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12514586 ]

Daniel Martínez commented on OFBIZ-1168:
----------------------------------------

Adrian,

Thanks for the comment and review. I see from your patch in OFBIZ-1164 that you are already taking care of date formats as well, good :)

Yes, I am willing to make a new javascript calendar. I will post when I have something.

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12514589 ]

Jacques Le Roux commented on OFBIZ-1168:
----------------------------------------

Daniel,

This is a great news (at least for me :o). Could it be possible please to take into account :

. If possible quicker than the existing one (I guess, most of the slowness comes from the fact that we open a new browser window, perhaps an Ajax solution exists out there ?)
. localisable
. Compatible with Firefox extenions changing the broswer windows status bar  (see link below)
. Whithout pb with HTTPS  : https://issues.apache.org/jira/browse/OFBIZ-841#action_12483746

Thanks

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532924 ]

Jacques Le Roux commented on OFBIZ-1168:
----------------------------------------

Any news ?

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532957 ]

Daniel Martínez commented on OFBIZ-1168:
----------------------------------------

I am still alive :)

Just after holidays most of my time have gone to a project. I have already started with the calendar though, but it is still in very early stage. Will post when it si more advanced.

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543005 ]

Jacopo Cappellato commented on OFBIZ-1168:
------------------------------------------

Has this issue been addressedby the work Adrian recently did?

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adrian Crum closed OFBIZ-1168.
------------------------------

    Resolution: Fixed

Some of the things in Daniel's patch have been fixed. The only thing that hasn't been fixed is the popup calendar. There was some discussion about that - http://www.nabble.com/New-javascript-calendar-(dojo)-t4153386.html, and we should open a separate issue for it.

> Provide date/time locale support to ofbiz
> -----------------------------------------
>
>                 Key: OFBIZ-1168
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1168
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Daniel Martínez
>            Priority: Minor
>         Attachments: locale_date_format.patch
>
>
> Provide locale date/time support for ofbiz. This includes:
> - Showing date/time data in locale format
> - Allowing the user to input date/time data in his locale format
> Locale format lists will be those provided by java standard API

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.