From ac1355347da154311a0727a2368d9daea457f32b Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Fri, 19 Dec 2014 10:20:22 -0500 Subject: [PATCH] Bug 13241 - Change creation_time to created_on --- C4/Utils/DataTables/VirtualShelves.pm | 2 +- C4/VirtualShelves.pm | 2 +- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 8 ++++---- .../prog/en/modules/virtualshelves/shelves.tt | 2 +- .../virtualshelves/tables/shelves_results.tt | 4 ++-- 6 files changed, 10 insertions(+), 10 deletions(-) diff --git a/C4/Utils/DataTables/VirtualShelves.pm b/C4/Utils/DataTables/VirtualShelves.pm index f6531c8..900be1a 100644 --- a/C4/Utils/DataTables/VirtualShelves.pm +++ b/C4/Utils/DataTables/VirtualShelves.pm @@ -31,7 +31,7 @@ sub search { # But the code is too dirty to refactor... my $select = q| SELECT vs.shelfnumber, vs.shelfname, vs.owner, vs.category AS type, - vs.creation_time, vs.lastmodified as modification_time, + vs.created_on, vs.lastmodified as modification_time, bo.surname, bo.firstname, vs.sortfield as sortby, count(vc.biblionumber) as count |; diff --git a/C4/VirtualShelves.pm b/C4/VirtualShelves.pm index 5222e73..6761174 100644 --- a/C4/VirtualShelves.pm +++ b/C4/VirtualShelves.pm @@ -322,7 +322,7 @@ sub AddShelf { return -1 unless _CheckShelfName($hashref->{shelfname}, $hashref->{category}, $owner, 0); my $query = q|INSERT INTO virtualshelves - (shelfname,owner,category,sortfield,allow_add,allow_delete_own,allow_delete_other, creation_time) + (shelfname,owner,category,sortfield,allow_add,allow_delete_own,allow_delete_other, created_on) VALUES (?,?,?,?,?,?,?, NOW()) |; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 479a431..a7e9d7c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2320,7 +2320,7 @@ CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) `category` varchar(1) default NULL, -- type of list (private [1], public [2]) `sortfield` varchar(16) default NULL, -- the field this list is sorted on `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified - `creation_time` TIMESTAMP NOT NULL, -- creation time + `created_on` TIMESTAMP NOT NULL, -- creation time `allow_add` tinyint(1) default 0, -- permission for adding entries to list `allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself `allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3b0f6e3..fdf6bad 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9603,16 +9603,16 @@ $DBversion = "3.19.00.XXX"; if ( CheckVersion($DBversion) ) { $dbh->do(q| ALTER TABLE virtualshelves - ADD COLUMN creation_time TIMESTAMP NOT NULL AFTER lastmodified + ADD COLUMN created_on TIMESTAMP NOT NULL AFTER lastmodified |); - # Set creation_time = lastmodified + # Set created_on = lastmodified # I would say it's better than 0000-00-00 # Set modified to the existing value (do not get the current ts!) $dbh->do(q| UPDATE virtualshelves - SET creation_time = lastmodified, lastmodified = lastmodified + SET created_on = lastmodified, lastmodified = lastmodified |); - print "Upgrade to $DBversion done (Bug XXXXX: Add DB field virtualshelves.creation_time)\n"; + print "Upgrade to $DBversion done (Bug XXXXX: Add DB field virtualshelves.created_on)\n"; SetVersion ($DBversion); } diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt index 59953b9..0f479a5 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt @@ -54,7 +54,7 @@ $(document).ready(function(){ { 'mDataProp': 'dt_count' }, { 'mDataProp': 'dt_owner' }, { 'mDataProp': 'dt_sortby' }, - { 'mDataProp': 'dt_creation_time' }, + { 'mDataProp': 'dt_created_on' }, { 'mDataProp': 'dt_modification_time' }, { 'mDataProp': 'dt_action', 'bSortable': false } ], diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/tables/shelves_results.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/tables/shelves_results.tt index 0144ebc..3a94b3f 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/tables/shelves_results.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/tables/shelves_results.tt @@ -16,8 +16,8 @@ "[% data.firstname %] [% data.surname %]", "dt_sortby": [% IF data.sortby == "author" %]"Author"[% ELSIF data.sortby == "copyrightdate" %]"Year"[% ELSIF data.sortby == "itemcallnumber" %]"Call number"[% ELSE %]"Title"[% END %], - "dt_creation_time": - "[% data.creation_time | $KohaDates %]", + "dt_created_on": + "[% data.created_on | $KohaDates %]", "dt_modification_time": "[% data.modification_time | $KohaDates %]", "dt_action": -- 1.7.2.5