Colors Management

The Colors Management page allows administrators to create, edit, and manage color themes and palettes used throughout the system. This centralized interface provides comprehensive control over visual styling elements, with support for different color types including website themes, custom palettes, and user-specific color schemes.

Quick Start

To add a new color theme: Click Add â?? Fill in Reference name and Type â?? Configure color values â?? Save. To manage existing themes: Use the search/filter tools to locate themes, then use the Actions column to Edit, Copy, or Delete. The system automatically prevents deletion of the Default website theme to maintain system integrity.

Permissions & Access

Access to the Colors Management page requires specific permissions:

  • Required Permission: Setup_Colors_Review in user permissions
  • Super Admin Override: Client ID = 1 bypasses permission checks
  • Workgroup Context: Users see colors within their assigned workgroup scope
  • Owner Filtering: Non-admin users only see colors they own (based on Email_Username)

Permission Tips

If you receive an "Access Denied" message, contact your system administrator to request the Setup_Colors_Review permission. The system will redirect unauthorized users to the denied page automatically.

Page Header Information

The header bar displays essential context and navigation elements:

Element Description
User Badge Shows logged-in user's email username, clickable to access Control Panel
Page Title Displays "Manage Colors" with palette icon
Status Badge Red "Showing Deleted" badge appears when viewing soft-deleted records
Date Display Current date in "Day Month DD, YYYY" format

Toolbar Functions

The main toolbar provides quick access to primary actions and navigation:

Button Function Notes
Add Opens Colors_RecordEdit.cfm to create new color theme Primary action for adding new themes
Back Returns to previous page in browser history Standard navigation
Close Closes page or returns to Control Panel Smart close handling for frames/windows
â?² Refreshes the current page Reloads data and resets filters
UnDelete Switches to deleted records view Only visible in active records view
Back to Active Returns to active records view Only visible in deleted records view
Record Count Shows total number of color themes found Updates based on current view/filters

DataTable Interface

Table Columns

The main data table displays color themes with the following columns:

Column Description Features
â?쳌 Checkbox Selection checkbox for bulk operations Disabled for Default theme; supports "Select All"
Reference Color theme name/identifier Sortable; Default theme shows blue badge
Type Color theme category (Website, Custom, etc.) Sortable; helps organize themes by purpose
Owner User who created/owns the theme Shows alias if available, otherwise email username
Actions Quick action buttons for each record Context-sensitive based on record status
Status Active/inactive indicator with toggle Clickable icons to change status
ID Unique database identifier Sortable; useful for debugging

Table Controls

The DataTable includes comprehensive controls for data management:

  • Page Length: Choose 25, 50, 100, or "All" records per page
  • Search Filter: Real-time search across Reference, Type, and Owner columns
  • Column Sorting: Click headers to sort; visual arrows indicate sort direction
  • Pagination: Navigate through multiple pages with numbered controls
  • State Persistence: Table remembers your sorting, filtering, and page settings

Bulk Operations

The interface supports bulk operations on selected records:

Operation Active View Deleted View
Select All Header checkbox selects all visible records Same functionality in deleted view
Delete Selected Delete Selected - Soft delete Not available
Un-Delete Selected Not available Un-Delete Selected - Restore records
Permanently Delete Not available Permanently Delete - Hard delete

Record Actions

Individual Record Actions

Each color theme record provides context-sensitive action buttons:

Action Button Style Function
Edit Edit Opens Colors_RecordEdit.cfm for the selected theme
Delete Delete Soft-deletes theme (not available for Default theme)
Restore Restore Restores soft-deleted theme (deleted view only)
Copy Copy Creates duplicate of theme via Colors_Copy.cfm

Status Indicators & Toggles

The status column provides visual indicators and interactive controls:

Icon Status Action
â?? Green Active (Active = 1 or NULL) Click to deactivate theme
â?? Gray Inactive (Active = 0) Click to activate theme
â?? Red Deleted (Active = 2) No click action; use Restore button

Delete & Recovery Workflows

Soft Delete Process

The system uses a three-tier deletion system for data safety:

  1. Soft Delete (Active = 2): Records are hidden from normal view but preserved in database
  2. Protection: Default website theme cannot be soft-deleted
  3. Bulk Operations: Multiple themes can be soft-deleted simultaneously
  4. Recovery: Soft-deleted themes can be restored to active status

Recovery Workflow

  1. Click UnDelete button in toolbar to switch to deleted records view
  2. Locate the themes you want to restore using search/filter tools
  3. Select individual themes or use "Select All" for bulk operations
  4. Click Un-Delete Selected to restore themes to active status
  5. Return to active view to see restored themes

Permanent Deletion

â? ï¸쳌 Permanent Deletion Warning

Hard deletion permanently removes color themes from the database and cannot be undone. This action is only available for themes that are already soft-deleted (Active = 2). Use with extreme caution.

To permanently delete themes:

  1. Switch to deleted records view using UnDelete button
  2. Select the themes you want to permanently remove
  3. Click Permanently Delete button
  4. Confirm the action in the warning dialog
  5. Themes are immediately removed from the database

Special Features

Default Theme Protection

The system includes built-in protection for the Default website theme:

  • Visual Identification: Default theme row has blue background highlight
  • Blue Badge: "DEFAULT" badge appears next to the reference name
  • Delete Protection: Cannot be soft-deleted or hard-deleted
  • Checkbox Disabled: Cannot be selected for bulk operations
  • Database Logic: SQL queries exclude Default theme from delete operations

Owner-Based Filtering

The system automatically filters color themes based on user permissions:

  • Super Admin (ID = 1): Sees all color themes regardless of owner
  • Regular Users: Only see themes they own (Owner = their Email_Username)
  • Owner Alias Display: Shows user alias if available, otherwise displays email username
  • Workgroup Context: Respects workgroup assignments for access control

Responsive Design

The interface adapts to different screen sizes:

  • Mobile-Friendly: Toolbar buttons stack appropriately on smaller screens
  • Table Scrolling: DataTable provides horizontal scrolling when needed
  • Touch-Friendly: Buttons and checkboxes sized for touch interaction
  • Flexible Layout: Content adapts to various viewport sizes

Technical Requirements

Database Setup

Before using this page, ensure the Colors table has the required Active column:

ALTER TABLE Colors ADD Active INT NULL DEFAULT 1;
UPDATE Colors SET Active = 1 WHERE Active IS NULL;

Browser Compatibility

  • Modern Browsers: Requires JavaScript and CSS3 support
  • DataTables: Uses jQuery DataTables 1.13.7 for table functionality
  • Bootstrap: Uses Bootstrap 5.3.3 for responsive design
  • Icons: Uses Bootstrap Icons 1.11.3 for visual elements

Summary

The Colors Management page provides comprehensive control over system color themes with robust safety features including soft-delete protection, owner-based filtering, and special handling for the Default theme. The interface combines powerful bulk operations with intuitive individual record management, making it easy to organize and maintain color schemes across the system. Advanced features like state persistence, responsive design, and permission-based access control ensure both usability and security for administrative users.