In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]

[ View Advanced ] [ Issue History ] [ Print ]

Tags

No tags attached.

Reference

https://groups.google.com/d/topic/in-portal-dev/LAACkQdKcfU/discussion

Change Log Message

Added short date/time formats for a language

Estimate Points

Attached Files

short_date_time_formats_in_language.patch [^] (6,400 bytes) 2012-07-12 11:08 [Show Content]

Index: admin_templates/regional/languages_edit.tpl
===================================================================
--- admin_templates/regional/languages_edit.tpl	(revision 15359)
+++ admin_templates/regional/languages_edit.tpl	(working copy)
@@ -66,7 +66,9 @@
 			<inp2:m_RenderElement name="inp_edit_options" prefix="lang" field="InputDateFormat"/>
 			<inp2:m_RenderElement name="inp_edit_options" prefix="lang" field="InputTimeFormat"/>
 			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="DateFormat"/>
+			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="ShortDateFormat"/>
 			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="TimeFormat"/>
+			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="ShortTimeFormat"/>
 
 			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="DecimalPoint"/>
 			<inp2:m_RenderElement name="inp_edit_box" prefix="lang" field="ThousandSep"/>
Index: install/english.lang
===================================================================
--- install/english.lang	(revision 15433)
+++ install/english.lang	(working copy)
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <LANGUAGES Version="6">
-	<LANGUAGE Encoding="base64" PackName="English" LocalName="English" DateFormat="m/d/Y" TimeFormat="g:i A" InputDateFormat="m/d/Y" InputTimeFormat="g:i:s A" DecimalPoint="." ThousandSep="," Charset="utf-8" UnitSystem="2" Locale="en-US" UserDocsUrl="http://docs.in-portal.org/eng/index.php">
+	<LANGUAGE Encoding="base64" PackName="English" LocalName="English" DateFormat="m/d/Y" ShortDateFormat="m/d" TimeFormat="g:i A" ShortTimeFormat="g:i A" InputDateFormat="m/d/Y" InputTimeFormat="g:i:s A" DecimalPoint="." ThousandSep="," Charset="utf-8" UnitSystem="2" Locale="en-US" UserDocsUrl="http://docs.in-portal.org/eng/index.php">
 		<EMAILDESIGNS>
 			<HTML>JGJvZHkNCjxici8+PGJyLz4NCg0KU2luY2VyZWx5LDxici8+PGJyLz4NCg0KV2Vic2l0ZSBhZG1pbmlzdHJhdGlvbi4NCg0KPCEtLSMjIDxpbnAyOmVtYWlsLWxvZ19JdGVtTGluayB0ZW1wbGF0ZT0icGxhdGZvcm0vbXlfYWNjb3VudC9lbWFpbCIvPiAjIy0tPg==</HTML>
 		</EMAILDESIGNS>
@@ -625,7 +625,9 @@
 			<PHRASE Label="la_fld_SentStatus" Module="Core" Type="1" Column="U2VudA==">U2VudA==</PHRASE>
 			<PHRASE Label="la_fld_Server" Module="Core" Type="1">U2VydmVy</PHRASE>
 			<PHRASE Label="la_fld_SessionLogId" Module="Core" Type="1" Column="U2Vzc2lvbiBMb2cgSUQ=">U2Vzc2lvbiBMb2cgSUQ=</PHRASE>
+			<PHRASE Label="la_fld_ShortDateFormat" Module="Core" Type="1" Column="U2hvcnQgRGF0ZSBGb3JtYXQ=">U2hvcnQgRGF0ZSBGb3JtYXQ=</PHRASE>
 			<PHRASE Label="la_fld_ShortIsoCode" Module="Core" Type="1" Column="U2hvcnQgSVNPIENvZGU=">U2hvcnQgSVNPIENvZGU=</PHRASE>
+			<PHRASE Label="la_fld_ShortTimeFormat" Module="Core" Type="1" Column="U2hvcnQgVGltZSBGb3JtYXQ=">U2hvcnQgVGltZSBGb3JtYXQ=</PHRASE>
 			<PHRASE Label="la_fld_SimpleSearch" Module="Core" Type="1">U2ltcGxlIFNlYXJjaA==</PHRASE>
 			<PHRASE Label="la_fld_SiteDomainLimitation" Module="Core" Type="1" Column="U2l0ZSBEb21haW4gTGltaXRhdGlvbg==">U2l0ZSBEb21haW4gTGltaXRhdGlvbg==</PHRASE>
 			<PHRASE Label="la_fld_SkinName" Module="Core" Type="1" Column="TmFtZQ==">TmFtZQ==</PHRASE>
Index: install/install_schema.sql
===================================================================
--- install/install_schema.sql	(revision 15433)
+++ install/install_schema.sql	(working copy)
@@ -169,7 +169,9 @@
   IconURL varchar(255) DEFAULT NULL,
   IconDisabledURL varchar(255) DEFAULT NULL,
   DateFormat varchar(50) NOT NULL DEFAULT 'm/d/Y',
+  ShortDateFormat varchar(255) NOT NULL DEFAULT 'm/d',
   TimeFormat varchar(50) NOT NULL DEFAULT 'g:i:s A',
+  ShortTimeFormat varchar(255) NOT NULL DEFAULT 'g:i A',
   InputDateFormat varchar(50) NOT NULL DEFAULT 'm/d/Y',
   InputTimeFormat varchar(50) NOT NULL DEFAULT 'g:i:s A',
   DecimalPoint varchar(10) NOT NULL DEFAULT '.',
Index: install/upgrades.sql
===================================================================
--- install/upgrades.sql	(revision 15433)
+++ install/upgrades.sql	(working copy)
@@ -2763,3 +2763,12 @@
 ALTER TABLE ScheduledTasks ADD RunSchedule VARCHAR(255) NOT NULL DEFAULT '* * * * *' AFTER Event;
 DELETE FROM UserPersistentSessionData WHERE VariableName = 'scheduled-task[Default]columns_.';
 DELETE FROM LanguageLabels WHERE PhraseKey = 'LA_FLD_RUNINTERVAL';
+
+ALTER TABLE Languages
+	ADD ShortDateFormat VARCHAR(255) NOT NULL DEFAULT 'm/d' AFTER DateFormat,
+	ADD ShortTimeFormat VARCHAR(255) NOT NULL DEFAULT 'g:i A' AFTER TimeFormat;
+
+UPDATE Languages
+SET
+	ShortDateFormat = REPLACE(REPLACE(DateFormat, '/Y', ''), '/y', ''),
+	ShortTimeFormat = REPLACE(TimeFormat, ':s', '');
Index: units/helpers/language_import_helper.php
===================================================================
--- units/helpers/language_import_helper.php	(revision 15359)
+++ units/helpers/language_import_helper.php	(working copy)
@@ -738,8 +738,9 @@
 		function _getExportFields()
 		{
 			return Array (
-				'PackName', 'LocalName', 'DateFormat', 'TimeFormat', 'InputDateFormat', 'InputTimeFormat',
-				'DecimalPoint', 'ThousandSep', 'Charset', 'UnitSystem', 'Locale', 'UserDocsUrl'
+				'PackName', 'LocalName', 'DateFormat', 'ShortDateFormat', 'TimeFormat', 'ShortTimeFormat',
+				'InputDateFormat', 'InputTimeFormat', 'DecimalPoint', 'ThousandSep', 'Charset', 'UnitSystem',
+				'Locale', 'UserDocsUrl'
 			);
 		}
 
Index: units/languages/languages_config.php
===================================================================
--- units/languages/languages_config.php	(revision 15359)
+++ units/languages/languages_config.php	(working copy)
@@ -187,7 +187,9 @@
 			'not_null' => '1', 'required' => 1, 'default' => 'g:i:s A',
 		),
 		'DateFormat' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => 'm/d/Y'),
+		'ShortDateFormat' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => 'm/d'),
 		'TimeFormat' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => 'g:i:s A'),
+		'ShortTimeFormat' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => 'g:i A'),
 		'DecimalPoint' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => '.'),
 		'ThousandSep' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
 		'Charset' => Array ('type' => 'string', 'not_null' => '1', 'required' => 1, 'default' => 'utf-8'),

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0004772) alex (manager) 2012-07-12 11:09	Will test all together later.

(0004773) alex (manager) 2012-07-12 11:09	Fix committed to 5.2.x branch. Commit Message: Fixes 0001343: Add short date/time output formats

(0004840) alex (manager) 2012-07-25 05:29	Since 5.2.0 version was released.

Related Changesets
In-Portal CMS: 5.2.x r15436 Timestamp: 2012-07-12 11:09:50 Author: alex [ Details ] [ Diff ]	Fixes 0001343: Add short date/time output formats
	mod - /in-portal/branches/5.2.x/core/admin_templates/regional/languages_edit.tpl	[ Diff ] [ File ]
	mod - /in-portal/branches/5.2.x/core/install/english.lang	[ Diff ] [ File ]
	mod - /in-portal/branches/5.2.x/core/install/install_schema.sql	[ Diff ] [ File ]
	mod - /in-portal/branches/5.2.x/core/install/upgrades.sql	[ Diff ] [ File ]
	mod - /in-portal/branches/5.2.x/core/units/helpers/language_import_helper.php	[ Diff ] [ File ]
	mod - /in-portal/branches/5.2.x/core/units/languages/languages_config.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2012-07-25 05:29	alex	Note Added: 0004840
2012-07-25 05:29	alex	Status	resolved => closed
2012-07-12 11:09	alex	Note Added: 0004773
2012-07-12 11:09	alex	Status	reviewed and tested => resolved
2012-07-12 11:09	alex	Fixed in Version	=> 5.2.0
2012-07-12 11:09	alex	Resolution	open => fixed
2012-07-12 11:09	alex	Assigned To	!COMMUNITY => alex
2012-07-12 11:09	alex	Changeset attached	5.2.x r15436
2012-07-12 11:09	alex	Note Added: 0004772
2012-07-12 11:09	alex	Status	needs testing => reviewed and tested
2012-07-12 11:09	alex	Assigned To	=> !COMMUNITY
2012-07-12 11:09	alex	Developer	=> alex
2012-07-12 11:09	alex	Status	active => needs testing
2012-07-12 11:08	alex	File Added: short_date_time_formats_in_language.patch
2012-07-09 11:25	alex	New Issue
2012-07-09 11:25	alex	Reference	=> https://groups.google.com/d/topic/in-portal-dev/LAACkQdKcfU/discussion
2012-07-09 11:25	alex	Change Log Message	=> Added short date/time formats for a language
2012-07-09 11:25	alex	Estimate Points	=> 1

Web Development by Intechnic

In-Portal Open Source CMS