From 147d3ed405135e1b0d3c15e8f70a61e640f221df Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 21 Feb 2018 12:54:59 -0500 Subject: [PATCH] Adding new flags and member message to management. In management area we now have a flag for overriding the moderation of packages. If checked all package edits by members are pending and need to be approved. Also theres a member message text area that if enabled will output above the member package add edit page. --- classes/data/dataManagement.php | 323 ++++++++++-------- index.php | 2 +- ..._V1.1.6.sql => create_database_V1.1.7.sql} | 5 +- setup/databaseScripts/dbVersions.php | 1 + .../update_database_V1.1.7.sql | 20 ++ views/admin/management/packaging.html | 29 ++ views/admin/packaging/index.html | 73 ++-- 7 files changed, 269 insertions(+), 184 deletions(-) rename setup/databaseScripts/{create_database_V1.1.6.sql => create_database_V1.1.7.sql} (93%) create mode 100644 setup/databaseScripts/update_database_V1.1.7.sql diff --git a/classes/data/dataManagement.php b/classes/data/dataManagement.php index e7c0c0b..aca0c49 100644 --- a/classes/data/dataManagement.php +++ b/classes/data/dataManagement.php @@ -115,28 +115,53 @@ class GlmDataPackagingManagement extends GlmDataAbstract 'use' => 'a' ), + // All edit moderated + 'package_all_moderated' => array( + 'field' => 'package_all_moderated', + 'type' => 'checkbox', + 'default' => false, + 'use' => 'a' + ), + + + // Display Member member + 'package_display_member_message' => array( + 'field' => 'package_display_member_message', + 'type' => 'checkbox', + 'default' => false, + 'use' => 'a' + ), + + // Member Message + 'package_member_message' => array( + 'field' => 'package_member_message', + 'type' => 'text', + 'required' => false, + 'use' => 'a', + ), + // Canonical Page Slug 'canonical_package_page' => array ( - 'field' => 'canonical_package_page', - 'type' => 'text', + 'field' => 'canonical_package_page', + 'type' => 'text', 'required' => true, - 'use' => 'a' + 'use' => 'a' ), // Member List Link to Packages on Member Detail 'package_link_text_member_list' => array ( - 'field' => 'package_link_text_member_list', - 'type' => 'text', + 'field' => 'package_link_text_member_list', + 'type' => 'text', 'required' => false, - 'use' => 'a' + 'use' => 'a' ), // Member Detail Link to Packages on Member Detail 'package_link_text_member_detail' => array ( - 'field' => 'package_link_text_member_detail', - 'type' => 'text', + 'field' => 'package_link_text_member_detail', + 'type' => 'text', 'required' => false, - 'use' => 'a' + 'use' => 'a' ), // Notification To Email @@ -165,283 +190,283 @@ class GlmDataPackagingManagement extends GlmDataAbstract // 'package_list_show_member_image' => array( - 'field' => 'package_list_show_member_image', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_image', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_link' => array( - 'field' => 'package_list_show_member_link', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_link', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_link_newtarget' => array( - 'field' => 'package_list_show_member_link_newtarget', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_link_newtarget', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_offsite_url' => array( - 'field' => 'package_list_show_offsite_url', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_offsite_url', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_offsite_url_newtarget' => array( - 'field' => 'package_list_show_offsite_url_newtarget', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_offsite_url_newtarget', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_image' => array( - 'field' => 'package_list_show_image', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_image', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_short_descr' => array( - 'field' => 'package_list_show_short_descr', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_short_descr', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_expire_date' => array( - 'field' => 'package_list_show_expire_date', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_expire_date', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_pricing' => array( - 'field' => 'package_list_show_pricing', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_pricing', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_address' => array( - 'field' => 'package_list_show_member_address', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_address', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_short_descr' => array( - 'field' => 'package_list_show_member_short_descr', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_short_descr', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_second_address' => array( - 'field' => 'package_list_show_member_second_address', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_second_address', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_street' => array( - 'field' => 'package_list_show_member_street', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_street', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_citystatezip' => array( - 'field' => 'package_list_show_member_citystatezip', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_citystatezip', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_country' => array( - 'field' => 'package_list_show_member_country', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_country', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_region' => array( - 'field' => 'package_list_show_member_region', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_region', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_phone' => array( - 'field' => 'package_list_show_member_phone', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_phone', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_tollfree' => array( - 'field' => 'package_list_show_member_tollfree', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_tollfree', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_email' => array( - 'field' => 'package_list_show_member_email', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_email', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_website_url' => array( - 'field' => 'package_list_show_member_website_url', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_website_url', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_member_website_url_newtarget' => array( - 'field' => 'package_list_show_member_website_url_newtarget', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_member_website_url_newtarget', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_list_show_package_detail_link' => array( - 'field' => 'package_list_show_package_detail_link', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_list_show_package_detail_link', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_link' => array( - 'field' => 'package_detail_show_member_link', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_link', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_link_newtarget' => array( - 'field' => 'package_detail_show_member_link_newtarget', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_link_newtarget', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_offsite_url' => array( - 'field' => 'package_detail_show_offsite_url', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_offsite_url', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_offsite_url_newtarget' => array( - 'field' => 'package_detail_show_offsite_url_newtarget', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_offsite_url_newtarget', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_image' => array( - 'field' => 'package_detail_show_image', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_image', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_address' => array( - 'field' => 'package_detail_show_member_address', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_address', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_street' => array( - 'field' => 'package_detail_show_member_street', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_street', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_citystatezip' => array( - 'field' => 'package_detail_show_member_citystatezip', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_citystatezip', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_country' => array( - 'field' => 'package_detail_show_member_country', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_country', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_region' => array( - 'field' => 'package_detail_show_member_region', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_region', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_phone' => array( - 'field' => 'package_detail_show_member_phone', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_phone', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_tollfree' => array( - 'field' => 'package_detail_show_member_tollfree', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_tollfree', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ), // 'package_detail_show_member_email' => array( - 'field' => 'package_detail_show_member_email', - 'type' => 'checkbox', - 'default' => true, - 'use' => 'a' + 'field' => 'package_detail_show_member_email', + 'type' => 'checkbox', + 'default' => true, + 'use' => 'a' ) ); diff --git a/index.php b/index.php index e79411d..46f746f 100644 --- a/index.php +++ b/index.php @@ -44,7 +44,7 @@ if (!defined('ABSPATH')) { * version from this plugin. */ define('GLM_MEMBERS_PACKAGING_PLUGIN_VERSION', '1.2.17'); -define('GLM_MEMBERS_PACKAGING_PLUGIN_DB_VERSION', '1.1.6'); +define('GLM_MEMBERS_PACKAGING_PLUGIN_DB_VERSION', '1.1.7'); // This is the minimum version of the GLM Members DB plugin require for this plugin. define('GLM_MEMBERS_PACKAGING_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '2.9.15'); diff --git a/setup/databaseScripts/create_database_V1.1.6.sql b/setup/databaseScripts/create_database_V1.1.7.sql similarity index 93% rename from setup/databaseScripts/create_database_V1.1.6.sql rename to setup/databaseScripts/create_database_V1.1.7.sql index cfa2ff4..0ee81ee 100644 --- a/setup/databaseScripts/create_database_V1.1.6.sql +++ b/setup/databaseScripts/create_database_V1.1.7.sql @@ -57,12 +57,15 @@ CREATE TABLE {prefix}package_elements ( -- Package Management Settings CREATE TABLE {prefix}management ( id INT NOT NULL AUTO_INCREMENT, - canonical_package_page TINYTEXT NULL, -- Canonical page slug for package detail + canonical_package_page TINYTEXT NULL, -- Canonical page slug for package detail package_link_text_member_list TINYTEXT NULL, package_link_text_member_detail TINYTEXT NULL, package_to_email TINYTEXT NULL, -- Email address of the recipient package_from_email TINYTEXT NULL, -- Email address of the sender package_email_notification TEXT NULL, -- Email notification message + package_display_member_message BOOLEAN DEFAULT '0', -- Boolean to show member message or not + package_member_message TEXT NULL, -- Member Message + package_all_moderated BOOLEAN DEFAULT '0', -- if all packages are moderated or not package_list_show_image BOOLEAN DEFAULT '1', package_list_show_short_descr BOOLEAN DEFAULT '1', package_list_show_expire_date BOOLEAN DEFAULT '1', diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index bf42a27..de15c0e 100644 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -22,5 +22,6 @@ $glmMembersPackagingDbVersions = array( '1.1.4' => array('version' => '1.1.4', 'tables' => 3), '1.1.5' => array('version' => '1.1.5', 'tables' => 3), '1.1.6' => array('version' => '1.1.6', 'tables' => 3), + '1.1.7' => array('version' => '1.1.7', 'tables' => 3), ); diff --git a/setup/databaseScripts/update_database_V1.1.7.sql b/setup/databaseScripts/update_database_V1.1.7.sql new file mode 100644 index 0000000..0a03af0 --- /dev/null +++ b/setup/databaseScripts/update_database_V1.1.7.sql @@ -0,0 +1,20 @@ +-- Gaslight Media Members Database +-- File Created: 2/20/2018 +-- Database Version: 1.1.7 +-- 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 dashses + +-- Display member message +ALTER TABLE {prefix}management ADD COLUMN package_display_member_message BOOLEAN DEFAULT '0'; + +---- + +-- Member message +ALTER TABLE {prefix}management ADD COLUMN package_member_message TEXT DEFAULT NULL; + +---- + +-- All member packages moderated +ALTER TABLE {prefix}management ADD COLUMN package_all_moderated BOOLEAN DEFAULT '0'; diff --git a/views/admin/management/packaging.html b/views/admin/management/packaging.html index df72fa4..2e264c4 100644 --- a/views/admin/management/packaging.html +++ b/views/admin/management/packaging.html @@ -16,6 +16,15 @@ + + + + + + + + + + + + + + + diff --git a/views/admin/packaging/index.html b/views/admin/packaging/index.html index bea5aa7..2cebfa0 100644 --- a/views/admin/packaging/index.html +++ b/views/admin/packaging/index.html @@ -2,6 +2,7 @@ When the member is editing member packages. It is also being used to display the list of packages for members manager. *} + {include file='admin/packaging/header.html'} {if $packageUpdated}

Package Updated

{/if} @@ -9,41 +10,47 @@ {if $option == 'edit' || $option == 'add'} - {if apply_filters('glm_members_permit_admin_members_packaging_edit_package', true)} + {if apply_filters('glm_members_permit_admin_members_packaging_edit_package', true)} - {if $option == 'edit'} - {if $lockedToMember} -

Edit Package

+ {if $option == 'edit'} + {if $lockedToMember} +

Edit Package

+ {else} +

Edit Multi-{$terms.term_member_cap} Package

+ {/if} + Delete this Package + +
+
+

Cancel

+

+
+
+

WARNING:

+

+ Clicking the "Delete this Package" button above will + delete all of the data and images associated with this package. + +

+

+ Once deleted, this information will no longer be available and cannot be retrieved! +

+
+
{else} -

Edit Multi-{$terms.term_member_cap} Package

+ {if $lockedToMember} +

Add new Package

+ {else} +

Add new Multi-{$terms.term_member_cap} Package

+ {/if} {/if} - Delete this Package - -
-
-

Cancel

-

-
-
-

WARNING:

-

- Clicking the "Delete this Package" button above will - delete all of the data and images associated with this package. - -

-

- Once deleted, this information will no longer be available and cannot be retrieved! -

-
-
- {else} - {if $lockedToMember} -

Add new Package

- {else} -

Add new Multi-{$terms.term_member_cap} Package

- {/if} - {/if} Return to Package List + {if $settings.package_display_member_message} +
+
+

{$settings.package_member_message|nl2br}

+
+ {/if} @@ -51,7 +58,7 @@ {if $lockedToMember} - {if apply_filters('glm_user_is_moderated', $lockedToMember)} + {if apply_filters('glm_user_is_moderated', $lockedToMember) || $settings.package_all_moderated} {/if} {else} @@ -73,7 +80,7 @@ {if $packageInfo.fieldFail.title}

{$packageInfo.fieldFail.title}

{/if} - {if apply_filters('glm_user_is_moderated', $lockedToMember)} + {if apply_filters('glm_user_is_moderated', $lockedToMember) || $settings.package_all_moderated} {else} -- 2.17.1

Moderated

All Edit Moderated + + {if $packagingSettings.fieldFail.package_all_moderated}

{$packagingSettings.fieldFail.package_all_moderated}

{/if}
+

Package Settings

Package Detail Page Permalink Name: @@ -37,6 +46,26 @@ {if $packagingSettings.fieldFail.package_link_text_member_detail}

{$packagingSettings.fieldFail.package_link_text_member_detail}

{/if}

Member Message

Display Member Message + + {if $packagingSettings.fieldFail.package_display_member_message}

{$packagingSettings.fieldFail.package_display_member_message}

{/if}
+
Member Message + {php} + wp_editor('{if $packagingSettings} {$packagingSettings.fieldData.package_member_message|escape:quotes} {/if}', 'package_member_message', array( + 'media_buttons' => false, + 'textarea_name' => 'package_member_message', + 'editor_height' => 300, + )); + {/php} +

E-Mail Notification Settings

Sender Email Address
Status: