Sponsors Management

The Sponsors Management page provides comprehensive user account administration for chapters, sponsors, and system users. This interface allows administrators to view, edit, activate/deactivate, and manage user permissions across the platform. The system supports both soft-delete (recoverable) and hard-delete (permanent) operations, along with bulk actions for efficient user management.

Quick Start

  1. Use the search box to find specific users by ID, name, or email
  2. Click "Show Permissions" to view detailed permission columns
  3. Use individual action buttons (Edit, Delete, View) for single user operations
  4. Select multiple users with checkboxes for bulk operations
  5. Click "UnDelete" to view and restore soft-deleted users

Toolbar Functions

Button Function Description
Add Chapter Create New Chapter Opens the chapter creation form when viewing chapters category
Add Create New User Opens the user creation form for non-chapter users
Back Navigate Back Returns to the previous page using browser history
Close Close Interface Closes the admin interface and returns to Control Panel
ð??? Refresh Page Reloads the current page to refresh data
Search Box Filter Users Search by user ID, sponsor name, or email address
Show All Clear Filters Removes all search filters and shows all active users
Show Permissions Toggle Permission View Shows/hides detailed permission columns for each user
UnDelete View Deleted Users Shows soft-deleted users that can be restored

Data Table Columns

Column Description Features
Checkbox Selection for bulk operations Select individual users or use "Select All" header checkbox
Sponsor Name Display name of the user or organization Sortable, searchable
Alias Short name or URL slug for the user Displayed in lowercase, used for site URLs
Login / Email User's login username and email address Clickable mailto link, searchable
Category User type (Chapter, Sponsor, etc.) Determines available actions and features
Actions Individual user action buttons Edit, Delete, View, Status, and admin functions
Status Toggle Active/Inactive status indicator Click to toggle between active/inactive states
ID Unique user identifier Sortable, searchable
Permission Columns Individual permission checkboxes (when enabled) Click to add/remove specific permissions

Action Buttons

Individual User Actions

Action Color Function
Edit Gray Opens user/chapter edit form
User Blue Opens user record edit (for chapters)
Delete Red Soft-delete user (recoverable)
View Blue Opens user presence view
Status Dynamic Chapter import status (color-coded by progress)
Scan Blue Scan chapter for import pages
Reset Orange Reset chapter (clears content for fresh import)
Purge Red Permanently delete chapter and all assets
Website Cyan Opens external chapter website
Site Cyan Opens user's layout page on platform
LoginAs Cyan Login as this user (Super User only)
Logout Red Force user logout on next page load
History Blue View user activity history
Revoke Orange Revoke all trusted devices

Bulk Operations

Operation Button Color Function
Delete Selected Red Soft-delete multiple selected users
Logout Selected Yellow Force logout multiple selected users
Restore Selected Green Restore soft-deleted users to active status
Permanently Delete Red Hard delete soft-deleted users and all assets

Status Indicators

User Status Icons

Icon Status Action
â?? Green Check Active User Click to deactivate
â?? Gray Dash Inactive User Click to activate
â?? Red X Soft-Deleted User No action (view only)

Chapter Status Colors

Color Status Description
Green Complete All pages created and content imported
Blue Pages Ready All pages created, content import pending
Yellow In Progress Some pages created or scanning completed
Red Not Started No staging data or import activity

Permission Management

When "Show Permissions" is enabled, additional columns appear showing individual permission checkboxes for each user. The system includes the following permission types:

Permission Access Level Description
Files Content Management Upload and manage files and documents
Zip Content Management Upload and extract ZIP archives
Front Page Site Management Edit front page content and layout
Colors Design Manage color schemes and themes
Backgrounds Design Upload and manage background images
Users Administration Manage user accounts and permissions
Calendar Content Management Create and manage calendar events
Events Content Management Manage event listings and details
Filters Content Management Create and manage content filters
Links Site Management Manage navigation links and menus
Content Content Management Create and edit page content
Layout Pages Site Management Create and manage page layouts
Widgets Site Management Add and configure page widgets
Forms Content Management Create and manage web forms
Listings Content Management Manage directory listings
Tenants Property Management Manage tenant information
Rentals Property Management Manage rental property listings

Permission Management Tips

  • Click any permission checkbox to immediately add or remove that permission
  • Changes are applied instantly without requiring a save button
  • Super Users can see and modify all permissions
  • Regular admins can only modify permissions they have access to
  • The Web Administrator account cannot have permissions modified

Delete Workflows

Soft Delete Process

  1. Individual Delete: Click the "Delete" action button next to any user
  2. Bulk Delete: Select multiple users with checkboxes and click "Delete Selected"
  3. Confirmation: Confirm the deletion in the popup dialog
  4. Result: Users are marked as deleted (Is_Active = 2) but remain in the database
  5. Recovery: Use the "UnDelete" button to view and restore soft-deleted users

Hard Delete Process (Permanent)

  1. Access: Click "UnDelete" to view soft-deleted users
  2. Selection: Select users that are already soft-deleted
  3. Action: Click "Permanently Delete" button
  4. Confirmation: Confirm twice in popup dialogs (irreversible action)
  5. Assets Removed: The system permanently deletes:
    • User account record
    • All owned layout pages and widgets
    • All owned content pages and navigation
    • Chapter events and calendar entries
    • Content filters and theme settings
    • Trusted device records

Chapter Reset Workflow

  1. Trigger: Click "Reset" action for an active chapter
  2. Confirmation: Confirm the reset operation
  3. Process: The system:
    • Deletes all imported sub-pages and their widgets
    • Removes chapter-owned pages and navigation
    • Clears import staging data
    • Removes navigation widgets from theme page
    • Deletes and rebuilds theme layout from template
  4. Result: Chapter is restored to a clean state ready for fresh import
  5. Logging: Action is logged to the ChangeLog table

Search and Filtering

Search Functionality

The search system supports multiple search criteria:

Search Type Fields Searched Example
ID Search User ID number "123" finds user with ID 123
Name Search Sponsor_Name field "chapter" finds all chapters
Email Search Email_Username field "admin" finds admin users
Partial Match All searchable fields "test" finds "TestChapter", "test@email.com"

Filter Options

Filter URL Parameter Description
Show Deleted ?showdeleted=true Shows only soft-deleted users (Is_Active = 2)
Category Filter ?category=Chapter Shows only users of specified category
Show Permissions ?ShwPerm=yes Displays permission columns
Workgroup Filter ?wrkgrp=groupname Filters by user workgroup membership

DataTable Features

Sorting and Pagination

  • Default Sort: Users are sorted by ID in descending order (newest first)
  • Column Sorting: Click any column header to sort by that field
  • Multi-Column Sort: Hold Shift and click additional columns for secondary sorting
  • Page Size: Choose 25, 50, 100, or "All" records per page
  • State Persistence: Table remembers your sorting, pagination, and search settings

Advanced Features

  • Global Search: DataTable's built-in search filters all visible columns
  • Column Visibility: Permission columns can be toggled on/off
  • Responsive Design: Table adapts to different screen sizes
  • Bulk Selection: "Select All" checkbox in header selects all visible rows
  • Cross-Page Selection: Selections persist across page changes

Security Features

Access Control

  • Permission Checking: Users must have "User" permission to access this interface
  • Super User Functions: LoginAs, Force Logout, and Revoke functions require Super_User permission
  • Admin Protection: The Web Administrator account (ID=1) cannot be deleted or logged out
  • Workgroup Filtering: Non-admin users can only see users in their workgroup

Audit Logging

  • Chapter Resets: All chapter reset operations are logged to ChangeLog table
  • IP Tracking: User IP addresses are recorded for audit purposes
  • Action Timestamps: All operations include precise timestamp information
  • User Attribution: Actions are attributed to the performing administrator

Session Management

  • Force Logout: Administrators can force user sessions to end
  • Trusted Device Revocation: Remove all trusted devices for enhanced security
  • Bulk Operations: Apply logout actions to multiple users simultaneously
  • Immediate Effect: Forced logouts take effect on the user's next page request


Summary

The Sponsors Management interface provides comprehensive user administration capabilities with robust security features, flexible filtering options, and powerful bulk operations. The system supports both recoverable soft-delete and permanent hard-delete operations, along with specialized chapter management functions including import status tracking and reset capabilities. Permission management is handled through an intuitive checkbox interface, while the DataTable provides advanced sorting, searching, and pagination features for efficient user management at scale.