From c20b4289171e083ee6b6cfca356d4932d8ccf261 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 28 Mar 2018 19:44:33 -0400 Subject: [PATCH] Form and db updates Update the last db script so the defaults get set for the new fields. Adding some form styles. --- css/admin.css | 51 +++++++++- .../create_database_V0.0.16.sql | 4 +- .../update_database_V0.0.16.sql | 5 + tmux-client-18661.log | 98 +++++++++++++++++++ 4 files changed, 152 insertions(+), 6 deletions(-) create mode 100644 tmux-client-18661.log diff --git a/css/admin.css b/css/admin.css index 192bd16..ecb293a 100644 --- a/css/admin.css +++ b/css/admin.css @@ -26,20 +26,63 @@ /* glm-billing-form */ .glm-billing-form { - max-width: 750px; + margin: 10px 0; + max-width: 300px; + padding: 20px 12px 10px 20px; + font-size: .813rem; } .glm-billing-field { width: 100%; + padding: 0; + margin: 3px 0 0 0; } .glm-billing-label { - font-size: 1rem; - padding: 7px 0 3px; + font-weight; bold; + padding: 0; + margin: 3px 0 0 0; } .glm-billing-input { - font-size: 1rem; padding: 3px 0; } .glm-billing-input label { width: 100%; display: block; } +.glm-billing-input input[type=text], +.glm-billing-input input[type=date], +.glm-billing-input input[type=datetime], +.glm-billing-input input[type=number], +.glm-billing-input input[type=search], +.glm-billing-input input[type=time], +.glm-billing-input input[type=url], +.glm-billing-input input[type=email], +.glm-billing-input textarea, +.glm-billing-input select{ + box-sizing: border-box; + -webkit-box-sizing: border-box; + -moz-box-sizing: border-box; + border:1px solid #BEBEBE; + padding: 4px; + margin:0px; + -webkit-transition: all 0.30s ease-in-out; + -moz-transition: all 0.30s ease-in-out; + -ms-transition: all 0.30s ease-in-out; + -o-transition: all 0.30s ease-in-out; + outline: none; + width: 100%; +} +.glm-billing-input input[type=text]:focus, +.glm-billing-input input[type=date]:focus, +.glm-billing-input input[type=datetime]:focus, +.glm-billing-input input[type=number]:focus, +.glm-billing-input input[type=search]:focus, +.glm-billing-input input[type=time]:focus, +.glm-billing-input input[type=url]:focus, +.glm-billing-input input[type=email]:focus, +.glm-billing-input textarea:focus, +.glm-billing-input select:focus{ + -moz-box-shadow: 0 0 8px #88D5E9; + -webkit-box-shadow: 0 0 8px #88D5E9; + box-shadow: 0 0 8px #88D5E9; + border: 1px solid #88D5E9; +} diff --git a/setup/databaseScripts/create_database_V0.0.16.sql b/setup/databaseScripts/create_database_V0.0.16.sql index 6feec67..564d691 100644 --- a/setup/databaseScripts/create_database_V0.0.16.sql +++ b/setup/databaseScripts/create_database_V0.0.16.sql @@ -225,9 +225,9 @@ CREATE TABLE {prefix}settings ( -- Set default billing Settings entry INSERT INTO {prefix}settings - ( id ) + ( id, days_before_renewal ,days_after_expired ) VALUES - ( 1 ); + ( 1, 90, 30 ); ---- diff --git a/setup/databaseScripts/update_database_V0.0.16.sql b/setup/databaseScripts/update_database_V0.0.16.sql index 70d3f9e..6f37c43 100644 --- a/setup/databaseScripts/update_database_V0.0.16.sql +++ b/setup/databaseScripts/update_database_V0.0.16.sql @@ -12,3 +12,8 @@ ALTER TABLE {prefix}settings CHANGE days_before_create_invoice days_before_renew -- Add date for after renewal date ALTER TABLE {prefix}settings ADD days_after_expired INT NULL; -- Number of days after renewal date expired + +---- + +-- Update the settings +UPDATE {prefix}settings SET days_before_renewal = 90, days_after_expired = 30 WHERE id = 1; diff --git a/tmux-client-18661.log b/tmux-client-18661.log new file mode 100644 index 0000000..876f111 --- /dev/null +++ b/tmux-client-18661.log @@ -0,0 +1,98 @@ +1522278467.911448 client started (18661): version 2.5, socket /tmp/tmux-1000/default, protocol 8 +1522278467.911487 on Linux 4.13.0-37-generic #42-Ubuntu SMP Wed Mar 7 14:13:23 UTC 2018; libevent 2.1.8-stable (poll) +1522278467.911510 socket is /tmp/tmux-1000/default +1522278467.911528 trying connect +1522278467.911598 add peer 0x55c665a50a90: 6 ((nil)) +1522278467.911662 sending message 100 to peer 0x55c665a50a90 (4 bytes) +1522278467.911670 sending message 101 to peer 0x55c665a50a90 (16 bytes) +1522278467.911677 sending message 102 to peer 0x55c665a50a90 (11 bytes) +1522278467.911682 sending message 108 to peer 0x55c665a50a90 (55 bytes) +1522278467.911690 sending message 104 to peer 0x55c665a50a90 (0 bytes) +1522278467.911696 sending message 107 to peer 0x55c665a50a90 (4 bytes) +1522278467.911703 sending message 105 to peer 0x55c665a50a90 (13 bytes) +1522278467.911712 sending message 105 to peer 0x55c665a50a90 (123 bytes) +1522278467.911718 sending message 105 to peer 0x55c665a50a90 (22 bytes) +1522278467.911725 sending message 105 to peer 0x55c665a50a90 (20 bytes) +1522278467.911730 sending message 105 to peer 0x55c665a50a90 (54 bytes) +1522278467.911737 sending message 105 to peer 0x55c665a50a90 (49 bytes) +1522278467.911743 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.911748 sending message 105 to peer 0x55c665a50a90 (13 bytes) +1522278467.911754 sending message 105 to peer 0x55c665a50a90 (12 bytes) +1522278467.911760 sending message 105 to peer 0x55c665a50a90 (16 bytes) +1522278467.911766 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.911772 sending message 105 to peer 0x55c665a50a90 (20 bytes) +1522278467.911777 sending message 105 to peer 0x55c665a50a90 (20 bytes) +1522278467.911783 sending message 105 to peer 0x55c665a50a90 (19 bytes) +1522278467.911790 sending message 105 to peer 0x55c665a50a90 (31 bytes) +1522278467.911798 sending message 105 to peer 0x55c665a50a90 (19 bytes) +1522278467.911806 sending message 105 to peer 0x55c665a50a90 (28 bytes) +1522278467.911812 sending message 105 to peer 0x55c665a50a90 (17 bytes) +1522278467.911818 sending message 105 to peer 0x55c665a50a90 (18 bytes) +1522278467.911824 sending message 105 to peer 0x55c665a50a90 (23 bytes) +1522278467.911830 sending message 105 to peer 0x55c665a50a90 (17 bytes) +1522278467.911835 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.911841 sending message 105 to peer 0x55c665a50a90 (8 bytes) +1522278467.911847 sending message 105 to peer 0x55c665a50a90 (35 bytes) +1522278467.911853 sending message 105 to peer 0x55c665a50a90 (14 bytes) +1522278467.911858 sending message 105 to peer 0x55c665a50a90 (32 bytes) +1522278467.911864 sending message 105 to peer 0x55c665a50a90 (1468 bytes) +1522278467.911878 sending message 105 to peer 0x55c665a50a90 (52 bytes) +1522278467.911884 sending message 105 to peer 0x55c665a50a90 (89 bytes) +1522278467.911889 sending message 105 to peer 0x55c665a50a90 (50 bytes) +1522278467.911894 sending message 105 to peer 0x55c665a50a90 (16 bytes) +1522278467.911899 sending message 105 to peer 0x55c665a50a90 (25 bytes) +1522278467.911905 sending message 105 to peer 0x55c665a50a90 (42 bytes) +1522278467.911910 sending message 105 to peer 0x55c665a50a90 (46 bytes) +1522278467.911915 sending message 105 to peer 0x55c665a50a90 (56 bytes) +1522278467.911920 sending message 105 to peer 0x55c665a50a90 (62 bytes) +1522278467.911925 sending message 105 to peer 0x55c665a50a90 (11 bytes) +1522278467.911931 sending message 105 to peer 0x55c665a50a90 (252 bytes) +1522278467.911936 sending message 105 to peer 0x55c665a50a90 (28 bytes) +1522278467.911941 sending message 105 to peer 0x55c665a50a90 (59 bytes) +1522278467.911946 sending message 105 to peer 0x55c665a50a90 (18 bytes) +1522278467.911951 sending message 105 to peer 0x55c665a50a90 (19 bytes) +1522278467.911956 sending message 105 to peer 0x55c665a50a90 (18 bytes) +1522278467.911961 sending message 105 to peer 0x55c665a50a90 (86 bytes) +1522278467.911966 sending message 105 to peer 0x55c665a50a90 (15 bytes) +1522278467.911971 sending message 105 to peer 0x55c665a50a90 (8 bytes) +1522278467.911977 sending message 105 to peer 0x55c665a50a90 (19 bytes) +1522278467.912000 sending message 105 to peer 0x55c665a50a90 (47 bytes) +1522278467.912006 sending message 105 to peer 0x55c665a50a90 (14 bytes) +1522278467.912013 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.912018 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.912024 sending message 105 to peer 0x55c665a50a90 (33 bytes) +1522278467.912029 sending message 105 to peer 0x55c665a50a90 (35 bytes) +1522278467.912034 sending message 105 to peer 0x55c665a50a90 (13 bytes) +1522278467.912039 sending message 105 to peer 0x55c665a50a90 (11 bytes) +1522278467.912044 sending message 105 to peer 0x55c665a50a90 (15 bytes) +1522278467.912049 sending message 105 to peer 0x55c665a50a90 (35 bytes) +1522278467.912054 sending message 105 to peer 0x55c665a50a90 (38 bytes) +1522278467.912060 sending message 105 to peer 0x55c665a50a90 (12 bytes) +1522278467.912065 sending message 105 to peer 0x55c665a50a90 (17 bytes) +1522278467.912070 sending message 105 to peer 0x55c665a50a90 (18 bytes) +1522278467.912075 sending message 105 to peer 0x55c665a50a90 (13 bytes) +1522278467.912080 sending message 105 to peer 0x55c665a50a90 (56 bytes) +1522278467.912085 sending message 105 to peer 0x55c665a50a90 (44 bytes) +1522278467.912090 sending message 105 to peer 0x55c665a50a90 (41 bytes) +1522278467.912095 sending message 105 to peer 0x55c665a50a90 (70 bytes) +1522278467.912101 sending message 105 to peer 0x55c665a50a90 (25 bytes) +1522278467.912106 sending message 105 to peer 0x55c665a50a90 (230 bytes) +1522278467.912111 sending message 105 to peer 0x55c665a50a90 (22 bytes) +1522278467.912117 sending message 105 to peer 0x55c665a50a90 (31 bytes) +1522278467.912122 sending message 105 to peer 0x55c665a50a90 (15 bytes) +1522278467.912127 sending message 105 to peer 0x55c665a50a90 (25 bytes) +1522278467.912132 sending message 105 to peer 0x55c665a50a90 (17 bytes) +1522278467.912137 sending message 105 to peer 0x55c665a50a90 (21 bytes) +1522278467.912142 sending message 105 to peer 0x55c665a50a90 (11 bytes) +1522278467.912147 sending message 105 to peer 0x55c665a50a90 (20 bytes) +1522278467.912152 sending message 105 to peer 0x55c665a50a90 (27 bytes) +1522278467.912157 sending message 105 to peer 0x55c665a50a90 (30 bytes) +1522278467.912162 sending message 105 to peer 0x55c665a50a90 (16 bytes) +1522278467.912167 sending message 105 to peer 0x55c665a50a90 (75 bytes) +1522278467.912172 sending message 105 to peer 0x55c665a50a90 (16 bytes) +1522278467.912177 sending message 106 to peer 0x55c665a50a90 (0 bytes) +1522278467.912183 sending message 200 to peer 0x55c665a50a90 (4 bytes) +1522278467.912188 client loop enter +1522278467.912619 peer 0x55c665a50a90 message 211 +1522278467.912636 peer 0x55c665a50a90 message 203 +1522278467.912642 client loop exit -- 2.17.1