http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=9166 -- You are receiving this mail because: You are watching all bug changes.

DELETE FROM systempreferences; SOURCE .../installer/data/mysql/sysprefs.sql SELECT variable,value FROM systempreferences; -- It should say 'CalendarFirstDayOfWeek' and '0'

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #1 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 27560 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=27560&action=edit Bug 12137 - Extend CalendarFirstDayOfWeek to be any day TEST PLAN --------- 1) Backup DB 2) In mysql: 3) Restore your DB 4) .../installer/data/mysql/updatedatabase.pl -- If your previous value for 'CalendarFirstDayOfWeek' was 'Sunday', it should be '0'. For 'Monday', it should be '1'. 5) Test an installation with 'de-DE' as the language. -- The default value should be '1'. 6) Test an installation with 'nb-NO' as the language. -- The default value should be '1'. 7) In the staff client, confirm that any day of the week is available in the I18N/L10N system preferences for the CalendarFirstDayOfWeek dropdown. -- I'm aware they aren't in order, but I'm after functionality, not finesse. 8) In another tab, go to a staff place that has a datepicker. For example, Home -> Tools -> Inventory/stocktaking 9) For each possible value in the CalendarFirstDayOfWeek, go to the other tab, refresh the page after updating the system preference, and click the datepicker icon. -- The date picker should then start on the selected day of the week. 10) Find some date picker in the OPAC, and repeat the same process. 11) Run koha QA test tools. NOTE: I was unable to figure out how to trigger OPAC datepicker. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #3 from M. Tompsett <mtompset@hotmail.com> --- NOTE: With the OPAC, you need to test prog and bootstrap themes. -- You are receiving this mail because: You are watching all bug changes.

DELETE FROM systempreferences; SOURCE .../installer/data/mysql/sysprefs.sql SELECT variable,value FROM systempreferences; -- It should say 'CalendarFirstDayOfWeek' and '0' May say '1' if you are using Norwegian.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #27560|0 |1 is obsolete| | --- Comment #5 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 28619 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=28619&action=edit Bug 12137 - Extend CalendarFirstDayOfWeek to be any day Mubassir Ahsan asked on the Koha mailing list: Is there any option to set Saturday as the first day of the week? Please help me. CalendarFirstDayOfWeek is currently either Sunday|Monday. By converting it to 0|1|2|3|4|5|6 (Sunday, Monday, ..., Saturday), we can allow any day of the week to be the first day of the week in the date picker. TEST PLAN --------- 1) Backup DB 2) In mysql: 3) Restore your DB 4) .../installer/data/mysql/updatedatabase.pl -- If your previous value for 'CalendarFirstDayOfWeek' was 'Sunday', it should be '0'. For 'Monday', it should be '1'. 5) Test an installation with 'de-DE' as the language. -- The default value should be '1'. 6) Test an installation with 'nb-NO' as the language. -- The default value should be '1'. 7) In the staff client, confirm that any day of the week is available in the I18N/L10N system preferences for the CalendarFirstDayOfWeek dropdown. -- I'm aware they aren't in order, but I'm after functionality, not finesse. 8) In another tab, go to a staff place that has a datepicker. For example, Home -> Tools -> Inventory/stocktaking 9) For each possible value in the CalendarFirstDayOfWeek, go to the other tab, refresh the page after updating the system preference, and click the datepicker icon. -- The date picker should then start on the selected day of the week. 10) Log into OPAC -- This may require setting: opacuserlogin to 'Allow'. 11) Click the personal details tab on the left. 12) There is a date picker for the date of birth. -- The date picker should then start on the selected day of the week. 13) Run koha QA test tools. -- You are receiving this mail because: You are watching all bug changes.

DELETE FROM systempreferences; SOURCE .../installer/data/mysql/sysprefs.sql SELECT variable,value FROM systempreferences; -- It should say 'CalendarFirstDayOfWeek' and '0' May say '1' if you are using Norwegian.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #28619|0 |1 is obsolete| | --- Comment #6 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 33771 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=33771&action=edit Bug 12137 - Extend CalendarFirstDayOfWeek to be any day Mubassir Ahsan asked on the Koha mailing list: Is there any option to set Saturday as the first day of the week? Please help me. CalendarFirstDayOfWeek is currently either Sunday|Monday. By converting it to 0|1|2|3|4|5|6 (Sunday, Monday, ..., Saturday), we can allow any day of the week to be the first day of the week in the date picker. TEST PLAN --------- 1) Backup DB 2) In mysql: 3) Restore your DB 4) .../installer/data/mysql/updatedatabase.pl -- If your previous value for 'CalendarFirstDayOfWeek' was 'Sunday', it should be '0'. For 'Monday', it should be '1'. 5) Test an installation with 'de-DE' as the language. -- The default value should be '1'. 6) Test an installation with 'nb-NO' as the language. -- The default value should be '1'. 7) In the staff client, confirm that any day of the week is available in the I18N/L10N system preferences for the CalendarFirstDayOfWeek dropdown. -- I'm aware they aren't in order, but I'm after functionality, not finesse. 8) In another tab, go to a staff place that has a datepicker. For example, Home -> Tools -> Inventory/stocktaking 9) For each possible value in the CalendarFirstDayOfWeek, go to the other tab, refresh the page after updating the system preference, and click the datepicker icon. -- The date picker should then start on the selected day of the week. 10) Log into OPAC -- This may require setting: opacuserlogin to 'Allow'. 11) Click the personal details tab on the left. 12) There is a date picker for the date of birth. -- The date picker should then start on the selected day of the week. 13) Run koha QA test tools. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 Indranil Das Gupta <indradg@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |indradg@gmail.com Status|Needs Signoff |Patch doesn't apply --- Comment #8 from Indranil Das Gupta <indradg@gmail.com> --- (In reply to M. Tompsett from comment #7) Applying: Bug 12137 - Extend CalendarFirstDayOfWeek to be any day Using index info to reconstruct a base tree... M C4/Auth.pm M installer/data/mysql/sysprefs.sql M installer/data/mysql/updatedatabase.pl M koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref Falling back to patching base and 3-way merge... Auto-merging koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref Auto-merging installer/data/mysql/updatedatabase.pl CONFLICT (content): Merge conflict in installer/data/mysql/updatedatabase.pl Auto-merging installer/data/mysql/sysprefs.sql Auto-merging C4/Auth.pm Failed to merge in the changes. Patch failed at 0001 Bug 12137 - Extend CalendarFirstDayOfWeek to be any day -- You are receiving this mail because: You are watching all bug changes.

DELETE FROM systempreferences; SOURCE .../installer/data/mysql/sysprefs.sql SELECT variable,value FROM systempreferences; -- It should say 'CalendarFirstDayOfWeek' and '0' May say '1' if you are using Norwegian.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #37017|0 |1 is obsolete| | --- Comment #10 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 40332 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40332&action=edit Bug 12137 - Extend CalendarFirstDayOfWeek to be any day Mubassir Ahsan asked on the Koha mailing list: Is there any option to set Saturday as the first day of the week? Please help me. CalendarFirstDayOfWeek is currently either Sunday|Monday. By converting it to 0|1|2|3|4|5|6 (Sunday, Monday, ..., Saturday), we can allow any day of the week to be the first day of the week in the date picker. TEST PLAN --------- 1) Backup DB 2) In mysql: 3) Restore your DB 4) .../installer/data/mysql/updatedatabase.pl -- If your previous value for 'CalendarFirstDayOfWeek' was 'Sunday', it should be '0'. For 'Monday', it should be '1'. 5) Test an installation with 'de-DE' as the language. -- The default value should be '1'. 6) Test an installation with 'nb-NO' as the language. -- The default value should be '1'. 7) In the staff client, confirm that any day of the week is available in the I18N/L10N system preferences for the CalendarFirstDayOfWeek dropdown. -- I'm aware they aren't in order, but I'm after functionality, not finesse. 8) In another tab, go to a staff place that has a datepicker. For example, Home -> Tools -> Inventory/stocktaking 9) For each possible value in the CalendarFirstDayOfWeek, go to the other tab, refresh the page after updating the system preference, and click the datepicker icon. -- The date picker should then start on the selected day of the week. 10) Log into OPAC -- This may require setting: opacuserlogin to 'Allow'. 11) Click the personal details tab on the left. 12) There is a date picker for the date of birth. -- The date picker should then start on the selected day of the week. 13) Run koha QA test tools. NOTE: not an atomic update, since this is an old patch. -- You are receiving this mail because: You are watching all bug changes.

DELETE FROM systempreferences; SOURCE .../installer/data/mysql/sysprefs.sql SELECT variable,value FROM systempreferences; -- It should say 'CalendarFirstDayOfWeek' and '0' May say '1' if you are using Norwegian.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 Indranil Das Gupta <indradg@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #40332|0 |1 is obsolete| | --- Comment #11 from Indranil Das Gupta <indradg@gmail.com> --- Created attachment 40429 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40429&action=edit Bug 12137 - Extend CalendarFirstDayOfWeek to be any day Mubassir Ahsan asked on the Koha mailing list: Is there any option to set Saturday as the first day of the week? Please help me. CalendarFirstDayOfWeek is currently either Sunday|Monday. By converting it to 0|1|2|3|4|5|6 (Sunday, Monday, ..., Saturday), we can allow any day of the week to be the first day of the week in the date picker. TEST PLAN --------- 1) Backup DB 2) In mysql: 3) Restore your DB 4) .../installer/data/mysql/updatedatabase.pl -- If your previous value for 'CalendarFirstDayOfWeek' was 'Sunday', it should be '0'. For 'Monday', it should be '1'. 5) Test an installation with 'de-DE' as the language. -- The default value should be '1'. 6) Test an installation with 'nb-NO' as the language. -- The default value should be '1'. 7) In the staff client, confirm that any day of the week is available in the I18N/L10N system preferences for the CalendarFirstDayOfWeek dropdown. -- I'm aware they aren't in order, but I'm after functionality, not finesse. 8) In another tab, go to a staff place that has a datepicker. For example, Home -> Tools -> Inventory/stocktaking 9) For each possible value in the CalendarFirstDayOfWeek, go to the other tab, refresh the page after updating the system preference, and click the datepicker icon. -- The date picker should then start on the selected day of the week. 10) Log into OPAC -- This may require setting: opacuserlogin to 'Allow'. 11) Click the personal details tab on the left. 12) There is a date picker for the date of birth. -- The date picker should then start on the selected day of the week. 13) Run koha QA test tools. NOTE: not an atomic update, since this is an old patch. Signed-off-by: Indranil Das Gupta (L2C2 Technologies) <indradg@gmail.com> -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #12 from Indranil Das Gupta <indradg@gmail.com> --- Created attachment 40430 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40430&action=edit (possible followup) sort <select> index by value adds alphabetical sorting to <select> lists displayed by preferences.tt. although added for sorting the days of the week, this may have larger ramifications. haven't been tested thoroughly, but no apparent breakage seems to be happening in preferences. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@biblibre.co | |m --- Comment #14 from Jonathan Druart <jonathan.druart@biblibre.com> --- Since the list is complete, it would have been easier to add 'Saturday', don't you think? -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #16 from Jonathan Druart <jonathan.druart@biblibre.com> --- (In reply to M. Tompsett from comment #15)

(In reply to Jonathan Druart from comment #14)

...

Since the list is complete, it would have been easier to add 'Saturday', don't you think?

And then add 'Wednesday' or some other day when someone else asks? It's easier to change the values to do any day.

Nobody uses Wednesday as the first day of the week. The 3 possible values are Saturday, Sunday and Monday. https://en.wikipedia.org/wiki/Names_of_the_days_of_the_week#Numbered_days_of... -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #18 from Jonathan Druart <jonathan.druart@biblibre.com> --- (In reply to M. Tompsett from comment #17)

(In reply to Jonathan Druart from comment #14)

...

Since the list is complete, it would have been easier to add 'Saturday', don't you think?

Look at the old code: CalendarFirstDayOfWeek => ( C4::Context->preference("CalendarFirstDayOfWeek") eq "Sunday" ) ? 0 : 1

Is it easier to extend that with more code? Or just use the values 0-6 in the first place?

C4::Context->preference("CalendarFirstDayOfWeek") eq "Sunday" ? 0 : C4::Context->preference("CalendarFirstDayOfWeek") eq "Saturday" ? 6 : 1 Not very difficult. We will just need to update the different options available for the pref and if someone already uses this value outside of Koha (ok, there is certainly nobody), he could continue to do it. But this is not the question, is there another value than can exist for the "first day of week"? If only Sunday, Monday and Saturday are used all around the world, I don't see any sense to propose the 4 other days :) -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #21 from Jonathan Druart <jonathan.druart@biblibre.com> --- Created attachment 40473 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40473&action=edit Bug 12137: followup sort <select> index by value adds alphabetical sorting to <select> lists displayed by preferences.tt. although added for sorting the days of the week, this may have larger ramifications. haven't been tested thoroughly, but no apparent breakage seems to be happening in preferences. NOTE: Nice tweak. Makes days of week in sensible order. Properly adds sorting based on documentation that is really hard to find. Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Signed-off-by: Jonathan Druart <jonathan.druart@koha-community.org> -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12137 --- Comment #23 from Jonathan Druart <jonathan.druart@biblibre.com> --- (In reply to Marcel de Rooy from comment #19)

(In reply to Jonathan Druart from comment #18)

...

If only Sunday, Monday and Saturday are used all around the world, I don't see any sense to propose the 4 other days :)

Why should we use more bits for a date. We will never reach 2000.. LOL

The first day of the week comes from tradition. So let's say we are going to anticipate the change of a tradition. -- You are receiving this mail because: You are watching all bug changes.