[Koha-bugs] [Bug 5476] New: Harcoded date format en Members.pm -> GetMessages

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5476

           Summary: Harcoded date format en Members.pm -> GetMessages
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_2
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: minor
          Priority: P5
         Component: Patrons
        AssignedTo: kyle.m.hall at gmail.com
        ReportedBy: jmlongo at uncu.edu.ar
         QAContact: koha-bugs at lists.koha-community.org
                CC: gmcharlt at gmail.com
   Estimated Hours: 0.0


I have came across a problem with the messages system, as it displays the
messages for the borrowers with a date format that is not the format chosen for
the system in SysPrefs...

We use the dd/mm/yyyy date format system wide, and the messages have their
dates in the mm/dd/yyyy format.

I backtraced the date that is printed with the message and found that this
problematic format is harcoded in the GetMessage routine, inside the module
Messages.pm, as can be seen in the following chunk of code...

my $query = "SELECT
                  branches.branchname,
                  messages.*,
                  DATE_FORMAT( message_date, '%m/%d/%Y' ) AS
message_date_formatted,
                  messages.branchcode LIKE '$branchcode' AS can_delete
                  FROM messages, branches
                  WHERE borrowernumber = ?
                  AND message_type LIKE ?
                  AND messages.branchcode = branches.branchcode
                  ORDER BY message_date DESC";

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.