Attachment 158835 Details for Bug 33478 – Bug 33478: Add formatting columns to letter table

[patch] Bug 33478: Add formatting columns to letter table

Bug-33478-Add-formatting-columns-to-letter-table.patch (text/plain), 3.93 KB, created by Aleisha Amohia on 2023-11-12 21:39:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Aleisha Amohia

Created: 2023-11-12 21:39:20 UTC

Size: 3.93 KB

patch

obsolete

>From 720a06959ddfe55658d586438e771cb2d6c01f4e Mon Sep 17 00:00:00 2001
>From: Aleisha Amohia <aleishaamohia@hotmail.com>
>Date: Tue, 18 Apr 2023 04:52:46 +0000
>Subject: [PATCH] Bug 33478: Add formatting columns to letter table
>
>Signed-off-by: Sam Lau <samalau@gmail.com>
>---
> .../bug_33478-add_letter_columns.pl           | 58 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  6 ++
> 2 files changed, 64 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl b/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl
>new file mode 100644
>index 00000000000..772413026be
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_33478-add_letter_columns.pl
>@@ -0,0 +1,58 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "33478",
>+    description => "Customise the format of notices when they are printed",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+
>+        if( !column_exists( 'letter', 'font_size' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `font_size` int(4) NOT NULL DEFAULT 14 AFTER `updated_on`
>+          });
>+
>+          say $out "Added column 'letter.font_size'";
>+        }
>+
>+        if( !column_exists( 'letter', 'text_justify' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `text_justify` enum('L','C','R') NOT NULL DEFAULT 'L' AFTER `font_size`
>+          });
>+
>+          say $out "Added column 'letter.text_justify'";
>+        }
>+
>+        if( !column_exists( 'letter', 'units' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `units` enum('POINT','INCH','MM','CM') NOT NULL DEFAULT 'INCH' AFTER `text_justify`
>+          });
>+
>+          say $out "Added column 'letter.units'";
>+        }
>+
>+        if( !column_exists( 'letter', 'notice_width' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `notice_width` float NOT NULL DEFAULT 8.5 AFTER `units`
>+          });
>+
>+          say $out "Added column 'letter.notice_width'";
>+        }
>+
>+        if( !column_exists( 'letter', 'top_margin' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `top_margin` float NOT NULL DEFAULT 0 AFTER `notice_width`
>+          });
>+
>+          say $out "Added column 'letter.top_margin'";
>+        }
>+
>+        if( !column_exists( 'letter', 'left_margin' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE letter ADD COLUMN `left_margin` float NOT NULL DEFAULT 0 AFTER `top_margin`
>+          });
>+
>+          say $out "Added column 'letter.left_margin'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index d0aa59933ba..34ad921fe9f 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4231,6 +4231,12 @@ CREATE TABLE `letter` (
>   `message_transport_type` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'transport type for this notice',
>   `lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang of the notice',
>   `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',
>+  `font_size` int(4) NOT NULL DEFAULT 14 COMMENT 'font size used when notice is printed',
>+  `text_justify` enum('L','C','R') NOT NULL DEFAULT 'L' COMMENT 'text justification used when notice is printed',
>+  `units` enum('POINT','INCH','MM','CM') NOT NULL DEFAULT 'INCH' COMMENT 'units to use for print measurements',
>+  `notice_width` float NOT NULL DEFAULT 8.5 COMMENT 'width of notice',
>+  `top_margin` float NOT NULL DEFAULT 0 COMMENT 'top margin for notice',
>+  `left_margin` float NOT NULL DEFAULT 0 COMMENT 'left margin for notice',
>   PRIMARY KEY (`id`),
>   UNIQUE KEY `letter_uniq_1` (`module`,`code`,`branchcode`,`message_transport_type`,`lang`),
>   KEY `message_transport_type_fk` (`message_transport_type`),
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 33478: 149743 | 149785 | 149786 | 149787 | 149914 | 149915 | 149916 | 149917 | 149918 | 149999 | 150000 | 150001 | 150002 | 150003 | 150004 | 150005 | 150006 | 150007 | 150008 | 150009 | 150010 | 150011 | 150012 | 150265 | 150266 | 150267 | 150268 | 150269 | 150270 | 150271 | 150272 | 150273 | 150274 | 150275 | 150276 | 150277 | 150324 | 150325 | 150326 | 150327 | 150328 | 150329 | 150330 | 150331 | 150332 | 150333 | 150334 | 150335 | 150336 | 150337 | 150338 | 150339 | 150340 | 150341 | 150342 | 150343 | 150344 | 150345 | 151548 | 151580 | 151581 | 151582 | 151583 | 151584 | 151585 | 151586 | 151587 | 151588 | 151589 | 151590 | 151591 | 151592 | 151593 | 156469 | 157368 | 157369 | 157370 | 157371 | 157372 | 157373 | 157374 | 157375 | 157376 | 157377 | 157378 | 157379 | 157380 | 157381 | 157382 | 157387 | 158835 | 158836 | 158837 | 158838 | 158839 | 158840 | 158841 | 158842 | 158843 | 158844 | 158845 | 158846 | 158847 | 158848 | 158849 | 158856 | 162556 | 162557 | 162558 | 162559 | 162560 | 162561 | 162562 | 162563 | 162564 | 162565 | 162566 | 162567 | 162568 | 162569 | 163903 | 163904 | 163905 | 163906 | 163907 | 163908 | 163909 | 163910 | 163911 | 163912 | 163913 | 163914 | 163915 | 163916 | 163924 | 163925 | 163926 | 163927 | 163928 | 163929 | 163930 | 163931 | 163932 | 163933 | 163934 | 163935 | 163936 | 163937 | 163938 | 164719 | 164720 | 164721 | 164722 | 164723 | 164724 | 164725 | 164726 | 164727 | 164728 | 164729 | 164730 | 164731 | 164732 | 164733 | 164741 | 164742 | 164743 | 164744 | 164745 | 164746 | 164747 | 164748 | 164749 | 164750 | 164751 | 164752 | 164753 | 164754 | 164755