From a55a44a50813ffdd3770a76007e391c94598ace1 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 8 Mar 2017 10:50:04 -0500 Subject: [PATCH] Adding reservation URL This will add the reservation url for the member info record. --- classes/data/dataMemberInfo.php | 7 +++++++ index.php | 2 +- ...atabase_V1.1.25.sql => create_database_V1.1.26.sql} | 3 ++- setup/databaseScripts/dbVersions.php | 1 + setup/databaseScripts/update_database_V1.1.26.sql | 10 ++++++++++ views/admin/member/memberInfo/editContact.html | 10 ++++++++++ views/front/members/detail.html | 1 + views/front/members/list.html | 2 ++ 8 files changed, 34 insertions(+), 2 deletions(-) rename setup/databaseScripts/{create_database_V1.1.25.sql => create_database_V1.1.26.sql} (99%) create mode 100644 setup/databaseScripts/update_database_V1.1.26.sql diff --git a/classes/data/dataMemberInfo.php b/classes/data/dataMemberInfo.php index 22bd0dbd..5ad9c6c6 100644 --- a/classes/data/dataMemberInfo.php +++ b/classes/data/dataMemberInfo.php @@ -327,6 +327,13 @@ class GlmDataMemberInfo extends GlmDataAbstract 'use' => 'a' ), + // Reservation URL + 'reservation_url' => array( + 'field' => 'reservation_url', + 'type' => 'text', + 'use' => 'a' + ), + // Logo 'logo' => array( 'field' => 'logo', diff --git a/index.php b/index.php index 2678c5dd..a6b0f1fe 100644 --- a/index.php +++ b/index.php @@ -39,7 +39,7 @@ */ define('GLM_MEMBERS_PLUGIN_VERSION', '2.9.8'); -define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.25'); +define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.26'); // Check if plugin version is not current in WordPress option and if needed updated it if (GLM_MEMBERS_PLUGIN_VERSION != get_option('glmMembersDatabasePluginVersion')) { diff --git a/setup/databaseScripts/create_database_V1.1.25.sql b/setup/databaseScripts/create_database_V1.1.26.sql similarity index 99% rename from setup/databaseScripts/create_database_V1.1.25.sql rename to setup/databaseScripts/create_database_V1.1.26.sql index eb613b5b..a369b7c2 100644 --- a/setup/databaseScripts/create_database_V1.1.25.sql +++ b/setup/databaseScripts/create_database_V1.1.26.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database -- File Created: 12/29/16 12:06:00 --- Database Version: 1.1.24 +-- Database Version: 1.1.26 -- Database Creation Script -- -- To permit each query below to be executed separately, @@ -205,6 +205,7 @@ CREATE TABLE {prefix}member_info ( phone TINYTEXT NULL, -- Primary phone number toll_free TINYTEXT NULL, -- Toll Free phone number url TINYTEXT NULL, -- URL with information about this member + reservation_url TEXT NULL, -- Reservation URL email TINYTEXT NULL, -- Main E-Mail address for this member logo TINYTEXT NULL, -- Member logo cc_type INT NULL, -- Bitmap of credit card types accepted - See credit_card array in plugin.ini diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index 4c7fb96b..34389698 100644 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -57,6 +57,7 @@ $glmMembersDbVersions = array( '1.1.23' => array('version' => '1.1.23', 'tables' => 18, 'date' => '12/29/16'), '1.1.24' => array('version' => '1.1.24', 'tables' => 18, 'date' => '01/03/17'), '1.1.25' => array('version' => '1.1.25', 'tables' => 18, 'date' => '02/02/17'), + '1.1.26' => array('version' => '1.1.26', 'tables' => 18, 'date' => '03/08/17'), ); diff --git a/setup/databaseScripts/update_database_V1.1.26.sql b/setup/databaseScripts/update_database_V1.1.26.sql new file mode 100644 index 00000000..74ffb932 --- /dev/null +++ b/setup/databaseScripts/update_database_V1.1.26.sql @@ -0,0 +1,10 @@ +-- Gaslight Media Members Database +-- File Created: 03/08/17 +-- Database Version: 1.1.26 +-- Database Update From Previous Version Script +-- +-- To permit each query below to be executed separately, +-- all queries must be separated by a line with four dashes +-- Sets which character to use to separate phone numbers + +ALTER TABLE {prefix}member_info ADD COLUMN reservation_url TEXT DEFAULT NULL; diff --git a/views/admin/member/memberInfo/editContact.html b/views/admin/member/memberInfo/editContact.html index 69b0d9ef..4948aedd 100644 --- a/views/admin/member/memberInfo/editContact.html +++ b/views/admin/member/memberInfo/editContact.html @@ -30,6 +30,16 @@ {if $memberInfo.fieldFail.url}

{$memberInfo.fieldFail.url}

{/if} + + Reservation URL: + + {if $memberInfo.fieldData.reservation_url} + Test Link + {/if} + + {if $memberInfo.fieldFail.reservation_url}

{$memberInfo.fieldFail.reservation_url}

{/if} + + Mailing Address 1: diff --git a/views/front/members/detail.html b/views/front/members/detail.html index a751d80d..ea983bac 100644 --- a/views/front/members/detail.html +++ b/views/front/members/detail.html @@ -117,6 +117,7 @@