From 80bb594a2da6300bfe56f222ddb40a75ec022ef8 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Fri, 7 Apr 2017 12:19:08 -0400 Subject: [PATCH] Additional database updates and indexes. --- classes/data/dataRegEvent.php | 4 +- classes/data/dataRegRequest.php | 19 +++- classes/data/dataRegRequestClass.php | 10 +- classes/data/dataRegRequestEvent.php | 10 +- classes/data/dataRegRequestRate.php | 10 +- classes/data/dataRegRequestRegistrant.php | 17 +++- classes/registrationsSupport.php | 58 +++++++++++- index.php | 2 +- models/admin/registrations/requests.php | 15 ++- ..._V0.0.6.sql => create_database_V0.0.7.sql} | 49 +++++----- setup/databaseScripts/dbVersions.php | 3 +- ...se_V0.0.6.sql => drop_database_V0.0.7.sql} | 0 .../update_database_V0.0.3.sql | 2 +- .../update_database_V0.0.4.sql | 2 +- .../update_database_V0.0.5.sql | 2 +- .../update_database_V0.0.6.sql | 2 +- .../update_database_V0.0.7.sql | 92 +++++++++++++++++++ views/admin/registrations/editRequest.html | 6 +- 18 files changed, 240 insertions(+), 63 deletions(-) rename setup/databaseScripts/{create_database_V0.0.6.sql => create_database_V0.0.7.sql} (95%) rename setup/databaseScripts/{drop_database_V0.0.6.sql => drop_database_V0.0.7.sql} (100%) create mode 100644 setup/databaseScripts/update_database_V0.0.7.sql diff --git a/classes/data/dataRegEvent.php b/classes/data/dataRegEvent.php index 8c741c1..cdf8cbf 100644 --- a/classes/data/dataRegEvent.php +++ b/classes/data/dataRegEvent.php @@ -216,8 +216,8 @@ class GlmDataRegistrationsRegEvent extends GlmDataAbstract ), // Bitmap of payment methods available to users for this event - See payment_method in plugin.ini - 'payment_methods' => array ( - 'field' => 'payment_methods', + 'payment_method' => array ( + 'field' => 'payment_method', 'type' => 'bitmap', 'bitmap' => $this->config['payment_methods'], 'default' => 0, // none selected diff --git a/classes/data/dataRegRequest.php b/classes/data/dataRegRequest.php index 56203d8..caed6e2 100644 --- a/classes/data/dataRegRequest.php +++ b/classes/data/dataRegRequest.php @@ -119,14 +119,25 @@ class GlmDataRegistrationsRequest extends GlmDataAbstract // Pointer to user account (table: account) who submitted the registrations 'account' => array ( 'field' => 'account', - 'type' => 'pointer', - 'p_table' => GLM_MEMBERS_REGISTRATIONS_PLUGIN_DB_PREFIX . 'account', - 'p_field' => 'id', - 'p_static' => true, + 'type' => 'integer', 'required' => true, 'use' => 'lgneud' ), + // Flag that indicates if request passed last validation with checkRegistrationRequest() + 'validated' => array ( + 'field' => 'validated', + 'type' => 'checkbox', + 'use' => 'a' + ), + + // Reasons that request did not pass validation with checkRegistrationRequest() + 'validation_message' => array ( + 'field' => 'validation_message', + 'type' => 'text', + 'use' => 'a' + ), + 'bill_fname' => array ( 'field' => 'bill_fname', 'type' => 'text', diff --git a/classes/data/dataRegRequestClass.php b/classes/data/dataRegRequestClass.php index af8768a..842d3d2 100644 --- a/classes/data/dataRegRequestClass.php +++ b/classes/data/dataRegRequestClass.php @@ -125,8 +125,8 @@ class GlmDataRegistrationsRequestClass extends GlmDataAbstract ), // Pointer to reg_event - 'event' => array ( - 'field' => 'event', + 'reg_event' => array ( + 'field' => 'reg_event', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' @@ -140,9 +140,9 @@ class GlmDataRegistrationsRequestClass extends GlmDataAbstract 'use' => 'lgneud' ), - // Pointer to times table entry in Events add-on - 'event_time' => array ( - 'field' => 'event_time', + // Pointer reg_time entry + 'reg_time' => array ( + 'field' => 'reg_time', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' diff --git a/classes/data/dataRegRequestEvent.php b/classes/data/dataRegRequestEvent.php index 4c4ad62..03d8179 100644 --- a/classes/data/dataRegRequestEvent.php +++ b/classes/data/dataRegRequestEvent.php @@ -133,8 +133,8 @@ class GlmDataRegistrationsRequestEvent extends GlmDataAbstract ), // Pointer to reg_event - 'event' => array ( - 'field' => 'event', + 'reg_event' => array ( + 'field' => 'reg_event', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' @@ -148,9 +148,9 @@ class GlmDataRegistrationsRequestEvent extends GlmDataAbstract 'use' => 'lgneud' ), - // Pointer to times table entry in Events add-on - 'event_time' => array ( - 'field' => 'event_time', + // Pointer reg_time entry + 'reg_time' => array ( + 'field' => 'reg_time', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' diff --git a/classes/data/dataRegRequestRate.php b/classes/data/dataRegRequestRate.php index c0c8c7a..6de377c 100644 --- a/classes/data/dataRegRequestRate.php +++ b/classes/data/dataRegRequestRate.php @@ -126,8 +126,8 @@ class GlmDataRegistrationsRegRequestRate extends GlmDataAbstract ), // Pointer to reg_event entry - 'event' => array ( - 'field' => 'event', + 'reg_event' => array ( + 'field' => 'reg_event', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' @@ -141,9 +141,9 @@ class GlmDataRegistrationsRegRequestRate extends GlmDataAbstract 'use' => 'lgneud' ), - // Pointer to times table entry in Events add-on - To help with registrant searches - 'event_time' => array ( - 'field' => 'event_time', + // Pointer reg_time entry + 'reg_time' => array ( + 'field' => 'reg_time', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' diff --git a/classes/data/dataRegRequestRegistrant.php b/classes/data/dataRegRequestRegistrant.php index 6af8dde..ae67d07 100644 --- a/classes/data/dataRegRequestRegistrant.php +++ b/classes/data/dataRegRequestRegistrant.php @@ -125,8 +125,8 @@ class GlmDataRegistrationsRequestRegistrant extends GlmDataAbstract ), // Pointer to reg_event entry - 'event' => array ( - 'field' => 'event', + 'reg_event' => array ( + 'field' => 'reg_event', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' @@ -140,9 +140,9 @@ class GlmDataRegistrationsRequestRegistrant extends GlmDataAbstract 'use' => 'lgneud' ), - // Pointer to times table entry in Events add-on - To help with registrant searches - 'event_time' => array ( - 'field' => 'event_time', + // Pointer reg_time entry + 'reg_time' => array ( + 'field' => 'reg_time', 'type' => 'integer', 'required' => true, 'use' => 'lgneud' @@ -195,6 +195,13 @@ class GlmDataRegistrationsRequestRegistrant extends GlmDataAbstract 'use' => 'lgneud' ), + // Flag for no registrant slot available for this registrant - Unable to get hold + 'reg_request_hold_not_available' => array ( + 'field' => 'reg_request_hold_not_available', + 'type' => 'checkbox', + 'use' => 'lgneud' + ), + // First Name of registrant 'fname' => array ( 'field' => 'fname', diff --git a/classes/registrationsSupport.php b/classes/registrationsSupport.php index 58351f4..cc76975 100644 --- a/classes/registrationsSupport.php +++ b/classes/registrationsSupport.php @@ -96,7 +96,7 @@ class GlmRegistrationsSupport * * ) * - * @param integer $requestID + * @param integer $requestId * * @return array Array of request and all associated information or false * @access public @@ -180,11 +180,67 @@ class GlmRegistrationsSupport } // Each Event } + $this->cart['status'] = true; + return $this->cart; } /* + * Checks validity of a request (cart) and sets new update time (for holds) + * + * This function loads the entire cart using the supplied request ID then checks it for any issues. + * + * Checks links to referenced events and event times records in the Event Add-on tables and notes if either are missing. + * Checks all referenced Accounts for non-guest carts and notes if any are missing. + * Checks all internal references between records in the cart and notes any issues. + * Checks all registrants and notes any problems. + * If this is a cart that has not been successfully completed + * Checks if registrant has a currently valid hold on an attendee slot + * If no currently valid hold, attempts to hold an attendee slot and flags if not available + * Updates all totals + * Updates request last accessed time + * + * @param integer $requestId + * + * @return array Array of request and all associated information or false + * @access public + */ + public function checkRegistrationRequest($requestId = false) + { + + $this->getRegistrationCart($requestId); + + if (!$this->cart['status']) { + return; + } + + // **** NEED TO COMPLETE THIS FUNCTION **** + + } + + /* + * Recalculates and updates all totals for a reg_)time entry + * + * @param integer $requestId + * + * @return array Array of request and all associated information or false + * @access public + */ + public function updateRegistrationTime($regTimeId = false) + { + + // Validate request ID + if (!$regTimeId || ($regTimeId-0) <= 0) { + return false; + } + + // **** NEED TO COMPLETE THIS FUNCTION **** + + } + + +/* * Add an account to the accounts list if not already there * * diff --git a/index.php b/index.php index a8d5b61..cd53bb8 100644 --- a/index.php +++ b/index.php @@ -38,7 +38,7 @@ * version from this plugin. */ define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_VERSION', '0.0.1'); -define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_DB_VERSION', '0.0.6'); +define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_DB_VERSION', '0.0.7'); // This is the minimum version of the GLM Members DB plugin require for this plugin. define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '2.8.0'); diff --git a/models/admin/registrations/requests.php b/models/admin/registrations/requests.php index aad096c..8ce01b3 100644 --- a/models/admin/registrations/requests.php +++ b/models/admin/registrations/requests.php @@ -84,7 +84,7 @@ class GlmMembersAdmin_registrations_requests extends GlmDataRegistrationsRequest $haveRequests = false; $requests = false; $haveRequest = false; - $requestID = false; + $requestId = false; $requestCart = false; $option = 'list'; $errorMsg = false; @@ -107,22 +107,27 @@ class GlmMembersAdmin_registrations_requests extends GlmDataRegistrationsRequest $option = $_REQUEST['option']; } - // Check for registration request ID submitted for edit operation + // Check for registration request ID submitted if (isset($_REQUEST['requestID']) && $_REQUEST['requestID'] != '') { - $requestID = ($_REQUEST['requestID'] - 0); + $requestId = ($_REQUEST['requestID'] - 0); } // Perform selected option switch ($option) { + // Check request and update holds + case 'check': + + $requestCart = $regSupport->checkRegistrationRequest($requestId); + // Display/Edit a registration request case 'edit': // If a request ID has been supplied - if ($requestID) { + if ($requestId) { // Try to get the complete cart for this request - $requestCart = $regSupport->getRegistrationCart($requestID); + $requestCart = $regSupport->getRegistrationCart($requestId); // If a valid cart was returned if ($requestCart && $requestCart['status']) { diff --git a/setup/databaseScripts/create_database_V0.0.6.sql b/setup/databaseScripts/create_database_V0.0.7.sql similarity index 95% rename from setup/databaseScripts/create_database_V0.0.6.sql rename to setup/databaseScripts/create_database_V0.0.7.sql index 6bd7fdd..e13438e 100644 --- a/setup/databaseScripts/create_database_V0.0.6.sql +++ b/setup/databaseScripts/create_database_V0.0.7.sql @@ -301,7 +301,7 @@ CREATE TABLE {prefix}payment_code ( -- Only created when selecting registrations for a particular event in the Events add-on CREATE TABLE {prefix}reg_event ( id INT NOT NULL AUTO_INCREMENT, - event INT NULL, -- Pointer to event in Events add-on + event INT NULL, -- Pointer to event in Events add-on - False if event record in Events add-on no longer exists event_name TINYTEXT NULL, -- Name of Event so it will always be in the cart data event_code TINYTEXT NULL, -- A short code used to reference this event - can be used to directly select an event to register for notify_email TINYTEXT NULL, -- E-Mail addresses to recieve notification of a registration other than org_internal_email in management, comma separated @@ -333,14 +333,14 @@ CREATE TABLE {prefix}reg_event ( CREATE TABLE {prefix}reg_time ( id INT NOT NULL AUTO_INCREMENT, reg_event INT NULL, -- Pointer to reg_event table - event_time INT NULL, -- Pointer to events times table entry + event_time INT NULL, -- Pointer to events times table entry - False if event time record in Events add-on no longer exists start_datetime DATETIME NULL, -- Date and time when event instance starts - Informational - Actual events data is definitive end_datetime DATETIME NULL, -- Date and time when event instance ends - Informational all_day BOOLEAN NULL, -- All Day flag - Informational attendees BOOLEAN NULL, -- Flag if tracking attendees or if only one per registration submission (registers account submitting) - get from reg_event attendee_max MEDIUMINT NULL, -- Attendee count limit - 0 = unlimited - get from reg_event record attendee_count MEDIUMINT NULL, -- Current attendee count - calculated on the fly and stored here for reference - attendees_pending MEDIUMINT NULL, -- Current number of attendees for this time in active pending carts (not processed) - Updated when carts are processed + attendees_pending MEDIUMINT NULL, -- Current number of attendees for this time in active pending carts (Not checked out and attendees slots held) attendees_available MEDIUMINT NULL, -- Currently available attendee count (limit - current - pending) total_base_charge DOUBLE NULL, -- Total base charges total_per_attendee DOUBLE NULL, -- Total per-attendee charges @@ -468,6 +468,8 @@ CREATE TABLE {prefix}account ( CREATE TABLE {prefix}reg_request ( id INT NOT NULL AUTO_INCREMENT, account INT NULL, -- Pointer to user account (reg_account) who submitted the registrations + validated BOOLEAN NULL, -- Flag that indicates if request passed last validation with checkRegistrationRequest() + validation_message TEXT NULL, -- Reasons that request did not pass validation with checkRegistrationRequest() bill_fname TINYTEXT NULL, -- Billing information used for this registration submission - Updates account billing address - Kept here for each request bill_lname TINYTEXT NULL, bill_org TINYTEXT NULL, @@ -507,9 +509,9 @@ CREATE TABLE {prefix}reg_request_event ( id INT NOT NULL AUTO_INCREMENT, account INT NULL, -- Pointer to account (person submitting the registration) reg_request INT NULL, -- Pointer to reg_request table - event INT NULL, -- Pointer to reg_event + reg_event INT NULL, -- Pointer to reg_event event_name TINYTEXT NULL, -- Name of Event so it will always be in the cart data - event_time INT NULL, -- Pointer to times table entry in Events add-on + reg_time INT NULL, -- Pointer to times table entry in Events add-on event_datetime DATETIME NULL, -- Date and time of event time selected so it will always be in the cart total_charge FLOAT, -- Last calculated total of all charges for registration to this event for all registrants mf_data TEXT NULL, -- Any MagicForm data associated with requested event @@ -517,8 +519,8 @@ CREATE TABLE {prefix}reg_request_event ( PRIMARY KEY (id), INDEX (reg_request), INDEX (account), - INDEX (event), - INDEX (event_time) + INDEX (reg_event), + INDEX (reg_time) ); ---- @@ -528,21 +530,21 @@ CREATE TABLE {prefix}reg_request_event ( CREATE TABLE {prefix}reg_request_class ( id INT NOT NULL AUTO_INCREMENT, account INT NULL, -- Pointer to account (person submitting the registration) - event INT NULL, -- Pointer to reg_event entry + reg_event INT NULL, -- Pointer to reg_event entry event_name TINYTEXT NULL, -- Name of Event so it will always be in the cart data - event_time INT NULL, -- Pointer to times table entry in Events add-on - To help with registrant searches + reg_time INT NULL, -- Pointer reg_time entry event_datetime DATETIME NULL, -- Date and time of event time selected so it will always be in the cart reg_request INT NULL, -- Pointer to the registration request record reg_request_event INT NULL, -- Pointer to reg_request_event table entry - class INT NULL, -- Pointer to event reg_class table + class INT NULL, -- Pointer to event reg_class table - False (0) if registration class no longer exits class_name TINYTEXT NULL, -- Name of event class at the time selected total_class_charge FLOAT, -- Last calculated total of all charges for this registration class for this request mf_data TEXT NULL, -- Any MagicForm data associated with registrant notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (account), - INDEX (event), - INDEX (event_time), + INDEX (reg_event), + INDEX (reg_time), INDEX (reg_request_event) ); @@ -553,15 +555,15 @@ CREATE TABLE {prefix}reg_request_class ( CREATE TABLE {prefix}reg_request_rate ( id INT NOT NULL AUTO_INCREMENT, account INT NULL, -- Pointer to account (person submitting the registration) - event INT NULL, -- Pointer to reg_event entry + reg_event INT NULL, -- Pointer to reg_event entry event_name TINYTEXT NULL, -- Name of Event so it will always be in the cart data - event_time INT NULL, -- Pointer to times table entry in Events add-on - To help with registrant searches + reg_time INT NULL, -- Pointer reg_time entry event_datetime DATETIME NULL, -- Date and time of event time selected so it will always be in the cart reg_request INT NULL, -- Pointer to the registration request record reg_request_event INT NULL, -- Pointer to reg_request_event table entry reg_request_class INT NULL, -- Pointer to reg_request_class table entry - rate INT NULL, -- Pointer to event reg_rate table - rate_name TINYTEXT NULL, -- Name of event class rate at the time selected + rate INT NULL, -- Pointer to event reg_rate table - False (0) if registration rate no longer exists + rate_name TINYTEXT NULL, -- Name of event class rate at the time selected base_rate FLOAT, -- Base rate at time of registration per_registrant FLOAT, -- Per Registrant Rate at time of registration registrant_credits TINYINT NULL, -- Number of registrant credits in base rate at time of registration @@ -571,8 +573,8 @@ CREATE TABLE {prefix}reg_request_rate ( notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (account), - INDEX (event), - INDEX (event_time), + INDEX (reg_event), + INDEX (reg_time), INDEX (reg_request_event), INDEX (reg_request_class) ); @@ -583,24 +585,25 @@ CREATE TABLE {prefix}reg_request_rate ( CREATE TABLE {prefix}reg_request_registrant ( id INT NOT NULL AUTO_INCREMENT, account INT NULL, -- Pointer to account for person submitting the registration - event INT NULL, -- Pointer to reg_event entry + reg_event INT NULL, -- Pointer to reg_event entry event_name TINYTEXT NULL, -- Name of Event so it will always be in the cart data - event_time INT NULL, -- Pointer to times table entry in Events add-on - To help with registrant searches + reg_time INT NULL, -- Pointer reg_time entry event_datetime DATETIME NULL, -- Date and time of event time selected so it will always be in the cart reg_request INT NULL, -- Pointer to the registration request record reg_request_event INT NULL, -- Pointer to reg_request_event table entry reg_request_class INT NULL, -- Pointer to reg_request_class table entry reg_request_rate INT NULL, -- Pointer to reg_request_rate table entry - reg_request_registrant INT NULL, -- Pointer to account for registrant (person attending) - Not needed if registrants are off for the event + reg_request_registrant INT NULL, -- Pointer to account for registrant (person attending) - False (0) if account no longer exists or registrant account not needed reg_request_hold BOOLEAN NULL, -- Registrant hold active - Registrant slots held certain time since last cart access - After this the slot needs to be updated if available + reg_request_hold_not_available BOOLEAN NULL, -- No registrant slot available for this registrant - Unable to get hold fname TINYTEXT NULL, -- First name of registrant at the time of selection lname TINYTEXT NULL, -- Last name of registrant at the time of selection mf_data TEXT NULL, -- Any MagicForm data associated with registrant notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (account), - INDEX (event), - INDEX (event_time), + INDEX (reg_event), + INDEX (reg_time), INDEX (reg_request), INDEX (reg_request_event), INDEX (reg_request_class), diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index 4a4bca7..a86cd05 100644 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -19,7 +19,8 @@ $glmMembersRegistrationsDbVersions = array( '0.0.3' => array('version' => '0.0.3', 'tables' => 18, 'date' => '04/03/2017'), '0.0.4' => array('version' => '0.0.4', 'tables' => 18, 'date' => '04/03/2017'), '0.0.5' => array('version' => '0.0.5', 'tables' => 18, 'date' => '04/04/2017'), - '0.0.6' => array('version' => '0.0.6', 'tables' => 19, 'date' => '04/06/2017') + '0.0.6' => array('version' => '0.0.6', 'tables' => 19, 'date' => '04/06/2017'), + '0.0.7' => array('version' => '0.0.7', 'tables' => 19, 'date' => '04/07/2017') ); diff --git a/setup/databaseScripts/drop_database_V0.0.6.sql b/setup/databaseScripts/drop_database_V0.0.7.sql similarity index 100% rename from setup/databaseScripts/drop_database_V0.0.6.sql rename to setup/databaseScripts/drop_database_V0.0.7.sql diff --git a/setup/databaseScripts/update_database_V0.0.3.sql b/setup/databaseScripts/update_database_V0.0.3.sql index e877349..dfb737e 100644 --- a/setup/databaseScripts/update_database_V0.0.3.sql +++ b/setup/databaseScripts/update_database_V0.0.3.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Registrations Add-On -- File Created: 03/28/17 11:33:00 --- Database Version: 0.0.2 +-- Database Version: 0.0.3 -- Database Update From Previous Version Script -- -- To permit each query below to be executed separately, diff --git a/setup/databaseScripts/update_database_V0.0.4.sql b/setup/databaseScripts/update_database_V0.0.4.sql index caa1193..0007856 100644 --- a/setup/databaseScripts/update_database_V0.0.4.sql +++ b/setup/databaseScripts/update_database_V0.0.4.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Registrations Add-On -- File Created: 03/28/17 11:33:00 --- Database Version: 0.0.2 +-- Database Version: 0.0.4 -- Database Update From Previous Version Script -- -- To permit each query below to be executed separately, diff --git a/setup/databaseScripts/update_database_V0.0.5.sql b/setup/databaseScripts/update_database_V0.0.5.sql index 8e2c887..961e0db 100644 --- a/setup/databaseScripts/update_database_V0.0.5.sql +++ b/setup/databaseScripts/update_database_V0.0.5.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Registrations Add-On -- File Created: 03/28/17 11:33:00 --- Database Version: 0.0.2 +-- Database Version: 0.0.5 -- Database Update From Previous Version Script -- -- To permit each query below to be executed separately, diff --git a/setup/databaseScripts/update_database_V0.0.6.sql b/setup/databaseScripts/update_database_V0.0.6.sql index 7a3c2d3..dfcfe88 100644 --- a/setup/databaseScripts/update_database_V0.0.6.sql +++ b/setup/databaseScripts/update_database_V0.0.6.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Registratiuons Add-On -- File Created: 08/30/16 09:47:15 --- Database Version: 0.0.23 +-- Database Version: 0.0.6 -- Database Update From Previous Version Script -- -- To permit each query below to be executed separately, diff --git a/setup/databaseScripts/update_database_V0.0.7.sql b/setup/databaseScripts/update_database_V0.0.7.sql new file mode 100644 index 0000000..131fd5a --- /dev/null +++ b/setup/databaseScripts/update_database_V0.0.7.sql @@ -0,0 +1,92 @@ +-- Gaslight Media Members Database - Registratiuons Add-On +-- File Created: 08/30/16 09:47:15 +-- Database Version: 0.0.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 dashes + +ALTER TABLE {prefix}reg_request ADD COLUMN validated BOOLEAN; + +---- + +ALTER TABLE {prefix}reg_request ADD COLUMN validation_message TEXT; + +---- + +ALTER TABLE {prefix}reg_request_registrant ADD COLUMN reg_request_hold_not_available BOOLEAN; + +---- + +DROP INDEX event ON {prefix}reg_request_registrant; +---- +ALTER TABLE {prefix}reg_request_registrant CHANGE event reg_event INT; +---- +CREATE INDEX reg_event ON {prefix}reg_request_registrant (reg_event); + +---- + +DROP INDEX event_time ON {prefix}reg_request_registrant; +---- +ALTER TABLE {prefix}reg_request_registrant CHANGE event_time reg_time INT; +---- +CREATE INDEX reg_time ON {prefix}reg_request_registrant (reg_time); + +---- + +DROP INDEX event ON {prefix}reg_request_rate; +---- +ALTER TABLE {prefix}reg_request_rate CHANGE event reg_event INT; +---- +CREATE INDEX reg_event ON {prefix}reg_request_rate (reg_event); + +---- + +DROP INDEX event_time ON {prefix}reg_request_rate; +---- +ALTER TABLE {prefix}reg_request_rate CHANGE event_time reg_time INT; +---- +CREATE INDEX reg_time ON {prefix}reg_request_rate (reg_time); + +---- + +DROP INDEX event ON {prefix}reg_request_class; +---- +ALTER TABLE {prefix}reg_request_class CHANGE event reg_event INT; +---- +CREATE INDEX reg_event ON {prefix}reg_request_class (reg_event); + +---- + +DROP INDEX event_time ON {prefix}reg_request_class; +---- +ALTER TABLE {prefix}reg_request_class CHANGE event_time reg_time INT; +---- +CREATE INDEX reg_time ON {prefix}reg_request_class (reg_time); + +---- + +DROP INDEX event ON {prefix}reg_request_event; +---- +ALTER TABLE {prefix}reg_request_event CHANGE event reg_event INT; +---- +CREATE INDEX reg_event ON {prefix}reg_request_event (reg_event); + +---- + +DROP INDEX event_time ON {prefix}reg_request_event; +---- +ALTER TABLE {prefix}reg_request_event CHANGE event_time reg_time INT; +---- +CREATE INDEX reg_time ON {prefix}reg_request_event (reg_time); + +---- + +CREATE INDEX event_time ON {prefix}reg_time (event_time); +---- +CREATE INDEX start_datetime ON {prefix}reg_time (start_datetime); + + + + + diff --git a/views/admin/registrations/editRequest.html b/views/admin/registrations/editRequest.html index 23b56ad..cddd5c7 100644 --- a/views/admin/registrations/editRequest.html +++ b/views/admin/registrations/editRequest.html @@ -1,8 +1,10 @@ {include file='admin/registrations/header.html'} - - Return to Registration Requests List +
+

Return to Registration Requests List

+

Check Reguest & Update Holds

+
{if $option == 'edit' || $option == 'update'} *** Edit or Update ***