Headings Management

The Headings Management page allows administrators to create, edit, and manage review categories within the system. These categories serve as organizational structures for grouping sponsors and other content. The page provides comprehensive tools for category lifecycle management including soft-delete capabilities, bulk operations, and member tracking.

Quick Start

To add a new category: Click Add â?? Enter category name and description â?? Check "Active" if needed â?? Click Add. To edit: Click Edit next to any category â?? Modify fields â?? Click Save. Use the search filter to find specific categories quickly.

Permissions and Access

Access to the Headings Management page requires specific permissions:

Permission Level Access Rights Restrictions
Headings Permission Full access to create, edit, delete categories Must be explicitly granted in user permissions
Admin (ID = 1) Unrestricted access to all functions None
No Permission Redirected to access denied page Cannot access any headings functions

Page Header and Navigation

The page header provides essential navigation and user information:

Element Function Visual Indicator
User Badge Shows logged-in user, links to Control Panel Username
Page Title Displays "Review Categories" with tags icon ð?쳌·ï¸쳌 Review Categories
Date Display Shows current date for reference Monday Jan 01, 2024
Deleted Mode Badge Appears when viewing deleted records Showing Deleted

Toolbar Functions

The main toolbar provides essential category management actions:

Button Function Availability
â?? Add Opens inline form to create new category Always available
â?쳌 Back Returns to previous page in browser history Always available
â?? Close Closes page or returns to Control Panel Always available
ð??? Refreshes the current page Always available
UnDelete Switches to deleted records view Normal view only
â?쳌 Back to Active Records Returns to normal active records view Deleted view only

Record Counter

The toolbar displays a real-time count of categories (e.g., "15 categories" or "1 category") in the top-right corner, helping administrators understand the scope of their data.

Category Data Table

The main data table displays all categories with comprehensive information and management options:

Column Description Features
Checkbox Selection checkbox for bulk operations Header checkbox selects all visible rows
Category Name The primary name/title of the category Sortable, searchable, required field
Description Detailed description of the category purpose Sortable, searchable, optional field
Members Count of sponsors assigned to this category 5 badge format
Actions Edit, Delete, View, and Restore buttons Context-sensitive based on category state
Status Icon Visual indicator of category active state Clickable to toggle activation status
ID Unique database identifier for the category Sortable, useful for troubleshooting

Status Indicators

Each category displays a visual status indicator:

  • â?? Green Check Circle: Active category (clickable to deactivate)
  • â­? Gray Dash Circle: Inactive category (clickable to activate)
  • â쳌? Red X Circle: Deleted category (non-clickable)

Table Features

  • Pagination: 25, 50, 100, or All records per page
  • Search: Global search across Category Name and Description
  • Sorting: Click column headers to sort (Category Name default)
  • State Persistence: Table remembers your pagination and sorting preferences
  • Deleted Row Styling: Deleted categories appear with reduced opacity

Action Buttons

Each category row contains context-sensitive action buttons:

Button Function Availability
Edit Opens inline edit form for the category Always available
Delete Soft-deletes the category (requires confirmation) Only when category has no members
Restore Restores a deleted category to active status Deleted view only
View Opens sponsor management filtered by category Only when category has members

Deletion Protection

Categories with associated sponsors cannot be deleted until all sponsors are reassigned to other categories. This prevents orphaned data and maintains referential integrity.

Bulk Operations

The system supports powerful bulk operations for managing multiple categories simultaneously:

Bulk Selection

  1. Select Individual: Check individual category checkboxes
  2. Select All Visible: Click the header checkbox to select all categories on current page
  3. Select Across Pages: DataTable automatically includes selections from all pages
  4. Confirm Selection: Selected count updates dynamically

Bulk Delete (Normal View)

  1. Select desired categories using checkboxes
  2. Click the ð???ï¸쳌 Delete Selected button
  3. Confirm the bulk soft-delete operation
  4. Selected categories are moved to deleted status (Active = 2)
  5. Page refreshes showing remaining active categories

Bulk Restore (Deleted View)

  1. Navigate to deleted view using "UnDelete" button
  2. Select categories to restore using checkboxes
  3. Click ð??? Un-Delete Selected
  4. Confirm restoration operation
  5. Selected categories return to active status

Bulk Permanent Delete

  1. Navigate to deleted view
  2. Select categories for permanent removal
  3. Click ð???ï¸쳌 Permanently Delete
  4. Confirm permanent deletion (cannot be undone)
  5. Records are completely removed from database

Adding Categories

Create new categories using the inline add form:

  1. Initiate: Click the â?? Add button in the toolbar
  2. Form Display: Inline form appears at top of page with gray background
  3. Fill Required Fields:
    • Active Checkbox: Check to make category immediately active
    • Category Name: Enter unique, descriptive name (required)
    • Description: Add detailed explanation of category purpose (optional)
  4. Submit: Click Add to create category
  5. Cancel: Click Cancel to abort without saving
  6. Completion: Page refreshes showing new category in table

Add Form Fields

Field Type Default Required
Active Checkbox Checked (Active) No
Category Name Text Input Empty Yes
Description Text Input Empty No

Editing Categories

Modify existing categories using the inline edit form:

  1. Initiate: Click the Edit button for desired category
  2. Form Population: Edit form appears with current category data pre-filled
  3. Modify Fields: Update any combination of:
    • Active Status: Check/uncheck to control category availability
    • Category Name: Modify the primary category identifier
    • Description: Update or add category description
  4. Save Changes: Click Save to commit changes
  5. Cancel Changes: Click Cancel to discard modifications
  6. Completion: Page refreshes showing updated category information

Edit Form Validation

  • Category Name: Cannot be empty, should be unique
  • Active Status: Unchecking makes category unavailable for new assignments
  • Member Impact: Changes don't affect existing sponsor-category relationships
  • Database Constraints: System enforces referential integrity automatically

Deletion Workflows

The system implements a comprehensive three-tier deletion system for data safety:

Soft Delete Workflow

  1. Eligibility Check: System verifies category has no associated sponsors
  2. Initiate Delete: Click Delete button
  3. Confirmation Dialog: "Soft-delete category: [Name]?" appears
  4. Confirm Action: Click "OK" to proceed or "Cancel" to abort
  5. Status Update: Category Active field set to 2 (deleted)
  6. Visual Change: Category disappears from normal view
  7. Recovery Option: Category remains in database for potential restoration

Restore Workflow

  1. Access Deleted View: Click "UnDelete" button in toolbar
  2. Locate Category: Find deleted category in red-tinted table
  3. Initiate Restore: Click Restore button
  4. Status Update: Category Active field set to 1 (active)
  5. Immediate Availability: Category becomes available for assignments
  6. View Return: Return to normal view to see restored category

Permanent Delete Workflow

  1. Prerequisites: Category must already be soft-deleted (Active = 2)
  2. Access Deleted View: Navigate to deleted records view
  3. Select Categories: Choose categories for permanent removal
  4. Initiate Permanent Delete: Click ð???ï¸쳌 Permanently Delete
  5. Final Warning: "PERMANENTLY delete... This cannot be undone!" confirmation
  6. Database Removal: Records completely removed from Categories table
  7. No Recovery: Permanent deletion cannot be reversed

Deletion Safety

Warning: Permanent deletion is irreversible. Always verify that deleted categories are no longer needed before permanent removal. Consider exporting data backups before bulk permanent deletions.

Status Management

Categories have three distinct status states that control their availability and behavior:

Status Active Value Visual Indicator Behavior
Active 1 â?? Green check circle Available for assignments, visible in dropdowns
Inactive 0 or NULL â­? Gray dash circle Not available for new assignments, existing preserved
Deleted 2 â쳌? Red X circle Hidden from normal view, can be restored

Status Toggle Actions

  • Activate: Click gray dash circle â?? Category becomes active and available
  • Deactivate: Click green check circle â?? Category becomes inactive but preserved
  • Restore: Use "Restore" button in deleted view â?? Returns to active status
  • Delete: Use "Delete" button â?? Moves to deleted status (soft delete)

Status Impact on Sponsors

  • Active Categories: Available in sponsor assignment dropdowns
  • Inactive Categories: Existing assignments maintained, no new assignments possible
  • Deleted Categories: Existing assignments preserved but category hidden from most views
  • Permanent Deletion: Would break sponsor assignments (prevented by system)

Search and Filtering

The system provides comprehensive search and filtering capabilities for efficient category management:

  • Search Field: Located in top-right of data table
  • Search Scope: Searches across Category Name and Description fields
  • Real-time Filtering: Results update as you type
  • Case Insensitive: Search ignores uppercase/lowercase differences
  • Partial Matching: Finds categories containing search terms

View Filtering

View Mode Shows Access Method
Normal View Active and inactive categories (Active â?  2) Default view
Deleted View Only soft-deleted categories (Active = 2) Click "UnDelete" button

Column Sorting

  • Sortable Columns: Category Name, Description, Members, ID
  • Default Sort: Category Name ascending (alphabetical)
  • Sort Indicators: Arrow icons show current sort direction
  • Multi-level Sort: Hold Shift while clicking for secondary sorts
  • Persistent Sorting: Sort preferences saved between sessions

Advanced Filtering Tips

  • Exact Phrases: Use quotes for exact phrase matching
  • Multiple Terms: Space-separated terms work as AND search
  • Category Codes: Search by ID number for precise lookup
  • Member Counts: Sort by Members column to find heavily-used categories
  • Status Filtering: Use view modes to focus on specific category states

Member Tracking

The Members column provides real-time tracking of sponsor assignments to each category:

Member Count Display

Display Meaning Actions Available
5 Category has 5 assigned sponsors View button available, Delete button hidden
0 Category has no assigned sponsors Delete button available, View button hidden

Viewing Category Members

  1. Identify Categories with Members: Look for numbered badges in Members column
  2. Click View Button: Click View for categories with members
  3. Sponsor Manager Opens: New tab/window opens to Sponsor Manager
  4. Pre-filtered Results: Shows only sponsors assigned to selected category
  5. Full Management: Edit, reassign, or manage sponsors from filtered view

Member Impact on Operations

  • Deletion Protection: Categories with members cannot be deleted
  • Status Changes: Can deactivate categories with members (preserves assignments)
  • Editing Freedom: Can edit name/description regardless of member count
  • Bulk Operations: Member count affects bulk delete eligibility
  • Data Integrity: System prevents orphaned sponsor assignments

Data Table Controls

The category table includes comprehensive DataTable controls for enhanced usability:

Pagination Controls

Control Function Location
Show Entries Select 25, 50, 100, or All records per page Top-left above table
Page Numbers Navigate to specific page of results Top-right and bottom-right
Info Display "Showing X to Y of Z categories" Bottom-left of table
Search Box Global search across category data Top-center above table

Bulk Operation Controls

  • Delete Selected Button: Appears between search and pagination in normal view
  • Un-Delete Selected Button: Available in deleted view for restoration
  • Permanently Delete Button: Available in deleted view for final removal
  • Cross-page Selection: Maintains selections across paginated results
  • Selection Counter: Shows count of selected items dynamically

State Persistence

  • Page Size: Remembers your preferred number of records per page
  • Sort Order: Maintains column sort preferences between sessions
  • Search Terms: Preserves search filters during navigation
  • Column Widths: Saves any column resizing adjustments
  • View Mode: Remembers normal vs. deleted view preference

Keyboard Shortcuts

Enhance your productivity with these keyboard shortcuts:

Shortcut Function Context
Ctrl+F Focus search box Table view
Escape Clear search filter When search box focused
Enter Submit form Add/Edit forms
Tab Navigate between form fields Add/Edit forms
F5 Refresh page Any view
Alt+â?쳌 Browser back Any view

Troubleshooting

Common Issues

Issue Cause Solution
Cannot delete category Category has assigned sponsors Reassign sponsors to other categories first
Delete button missing Category has members Use deactivate instead, or remove members first
Category not appearing in dropdowns Category is inactive or deleted Activate category using status icon
Search not finding category Category is deleted or search typo Check deleted view or verify spelling
Bulk operations not working No categories selected Select categories using checkboxes first

Performance Tips

  • Large Datasets: Use pagination instead of "Show All" for better performance
  • Search Efficiency: Use specific terms rather than single characters
  • Bulk Operations: Process large bulk operations during low-usage periods
  • Browser Cache: Clear browser cache if experiencing display issues
  • Session Timeout: Save work frequently to prevent session timeouts

Summary

The Headings Management page provides comprehensive category administration with soft-delete protection, bulk operations, member tracking, and intuitive inline editing. Use the toolbar for primary actions, leverage the search and filtering capabilities for efficient navigation, and utilize the three-tier deletion system for safe data management. The member tracking system prevents accidental data loss while maintaining referential integrity throughout the application.