From 4b11c6a497559c7aa19a2fb441acbe7561d78511 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 7 Jan 2019 09:17:08 -0500 Subject: [PATCH] More db updates Adding more to general settings. Ajax pagination checkbox City search checkbox --- classes/data/settings/dataSettingsGeneral.php | 15 +++++++++++++++ index.php | 2 +- ...se_V1.1.45.sql => create_database_V1.1.46.sql} | 4 +++- setup/databaseScripts/dbVersions.php | 1 + ...base_V1.1.45.sql => drop_database_V1.1.46.sql} | 2 +- setup/databaseScripts/update_database_V1.1.46.sql | 15 +++++++++++++++ views/admin/management/index.html | 7 +++++++ 7 files changed, 43 insertions(+), 3 deletions(-) rename setup/databaseScripts/{create_database_V1.1.45.sql => create_database_V1.1.46.sql} (99%) rename setup/databaseScripts/{drop_database_V1.1.45.sql => drop_database_V1.1.46.sql} (96%) create mode 100755 setup/databaseScripts/update_database_V1.1.46.sql diff --git a/classes/data/settings/dataSettingsGeneral.php b/classes/data/settings/dataSettingsGeneral.php index 474991ab..2f498a69 100755 --- a/classes/data/settings/dataSettingsGeneral.php +++ b/classes/data/settings/dataSettingsGeneral.php @@ -452,6 +452,14 @@ class GlmDataSettingsGeneral extends GlmDataAbstract 'use' => 'a' ), + // Front-end Listings - Ajax Paginate List + 'list_ajax_pagination' => array( + 'field' => 'list_ajax_pagination', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' + ), + // Front-end Listings - Pagination Count 'list_pagination_count' => array( 'field' => 'list_pagination_count', @@ -499,6 +507,13 @@ class GlmDataSettingsGeneral extends GlmDataAbstract 'use' => 'a' ), + // Front-end Listings - Show Search City + 'list_show_search_city' => array( + 'field' => 'list_show_search_city', + 'type' => 'checkbox', + 'default' => false, + 'use' => 'a' + ), // Front-end Listings - Show Search Amenities 'list_show_search_region' => array( 'field' => 'list_show_search_region', diff --git a/index.php b/index.php index 8b5ee666..7e7a1cc0 100755 --- a/index.php +++ b/index.php @@ -48,7 +48,7 @@ if (!defined('ABSPATH')) { */ define('GLM_MEMBERS_PLUGIN_VERSION', '2.10.46'); -define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.45'); +define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.46'); // 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.45.sql b/setup/databaseScripts/create_database_V1.1.46.sql similarity index 99% rename from setup/databaseScripts/create_database_V1.1.45.sql rename to setup/databaseScripts/create_database_V1.1.46.sql index 5983163e..56d4cfe6 100755 --- a/setup/databaseScripts/create_database_V1.1.45.sql +++ b/setup/databaseScripts/create_database_V1.1.46.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database -- File Created: 12/29/16 12:06:00 --- Database Version: 1.1.45 +-- Database Version: 1.1.46 -- Database Creation Script -- -- To permit each query below to be executed separately, @@ -354,6 +354,7 @@ CREATE TABLE {prefix}settings_general ( list_show_list BOOLEAN DEFAULT '1', list_order_list SMALLINT DEFAULT '10', list_pagination BOOLEAN DEFAULT '1', + list_ajax_pagination BOOLEAN DEFAULT '0', list_pagination_count SMALLINT DEFAULT '20', list_show_search_filters_opened BOOLEAN DEFAULT '0', list_show_search BOOLEAN DEFAULT '1', @@ -362,6 +363,7 @@ CREATE TABLE {prefix}settings_general ( list_show_search_amenities BOOLEAN DEFAULT '1', list_show_search_region BOOLEAN DEFAULT '1', list_show_search_alpha BOOLEAN DEFAULT '1', + list_show_search_city BOOLEAN DEFAULT '0', list_floating_search BOOLEAN DEFAULT '0', list_floating_search_distance_top INTEGER DEFAULT '0', -- How far from the top the sticky Search/Filters box should hover list_show_detail_link BOOLEAN DEFAULT '1', diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index 9e8f79be..cdbfaa1e 100755 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -77,6 +77,7 @@ $glmMembersDbVersions = array( '1.1.43' => array('version' => '1.1.43', 'tables' => 23, 'date' => '11/07/18'), '1.1.44' => array('version' => '1.1.44', 'tables' => 23, 'date' => '11/08/18'), '1.1.45' => array('version' => '1.1.45', 'tables' => 23, 'date' => '01/02/19'), + '1.1.46' => array('version' => '1.1.46', 'tables' => 23, 'date' => '01/07/19'), ); diff --git a/setup/databaseScripts/drop_database_V1.1.45.sql b/setup/databaseScripts/drop_database_V1.1.46.sql similarity index 96% rename from setup/databaseScripts/drop_database_V1.1.45.sql rename to setup/databaseScripts/drop_database_V1.1.46.sql index 479bd5ac..2bd86d24 100755 --- a/setup/databaseScripts/drop_database_V1.1.45.sql +++ b/setup/databaseScripts/drop_database_V1.1.46.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database -- File Created: 12/09/14 15:27:15 --- Database Version: 1.1.45 +-- Database Version: 1.1.46 -- Database Deletion Script -- Note: Tables with DELETE CASCADE must appear before referenced table diff --git a/setup/databaseScripts/update_database_V1.1.46.sql b/setup/databaseScripts/update_database_V1.1.46.sql new file mode 100755 index 00000000..9de66d23 --- /dev/null +++ b/setup/databaseScripts/update_database_V1.1.46.sql @@ -0,0 +1,15 @@ +-- Gaslight Media Members Database +-- File Created: 2019-01-02 +-- Database Version: 1.1.45 +-- 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 + +-- Add list_ajax_pagination to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN list_ajax_pagination BOOLEAN DEFAULT '0'; -- Use Ajax pagination + +---- + +-- Add list_show_search_city to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN list_show_search_city BOOLEAN DEFAULT '0'; -- Add city to Search Form diff --git a/views/admin/management/index.html b/views/admin/management/index.html index d726533a..55bd9c64 100755 --- a/views/admin/management/index.html +++ b/views/admin/management/index.html @@ -335,6 +335,12 @@ + + Ajax Pagination: + + + + Pagination Count: @@ -441,6 +447,7 @@ Show Search Form:Text Search: Category Search: Amenities Search: + City Search: Regions Search: Show Alpha Index: Filter Box Opened by Default: -- 2.17.1