Category Management

The Category Management page provides comprehensive tools for managing product or content categories within your system. This interface allows you to search, view, edit, delete, and organize categories with full control over their lifecycle including soft delete and permanent deletion capabilities.

---

Toolbar Functions

The toolbar provides essential navigation and action buttons for category management:

Button	Function	Description
Add	Create New Category	Opens the category creation form to add a new category record
Back	Navigation	Returns to the previous page in your browser history
Search Box	Text Search	Enter search terms to filter categories by ID or other fields
Search	Execute Search	Performs the search using the entered criteria
Show All	Clear Filters	Removes all search filters and displays all active categories
UnDelete	View Deleted	Switches to deleted categories view for recovery operations

---

Search Functionality

The search system provides flexible filtering options:

Search Methods

• Text Search: Enter any text in the search box to find categories containing that text in their ID field
• Enter Key: Press Enter while in the search box to execute the search immediately
• Wildcard Matching: The search uses partial matching, so entering "cat" will find categories with "cat" anywhere in the ID
• Case Insensitive: Search is not case-sensitive, so "CAT" and "cat" produce the same results

Search Results Display

The system displays search results with contextual information:

• No records found - When search returns no matches
• 1 result - When exactly one category matches
• Multiple results - Shows count when multiple categories match
• Search terms are highlighted in orange for easy identification

---

Data Table Columns

The category data table displays comprehensive information with sortable columns:

Column	Data Type	Description	Sortable
Checkbox	Selection	Individual selection checkbox for bulk operations	No
Actions	Links	Edit icon and Delete link for individual record actions	No
ID	Integer	Unique identifier for each category record	Yes
Cat Name	Text	Display name of the category	Yes
Description	Text	Detailed description of the category (currently not displayed)	Yes
Status	Integer	Active status (1=Active, 2=Deleted, NULL=Active)	Yes

Sorting Behavior

• Click Column Headers: Click any sortable column header to sort by that field
• Toggle Direction: Clicking the same column header toggles between ascending and descending order
• Visual Indicators: Sort direction is indicated by ascending/descending arrow icons
• Persistent Settings: Sort preferences are remembered across page sessions

---

Bulk Operations

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

Selection Controls

Control	Function	Description
Master Checkbox	Select All/None	Toggles selection of all visible categories at once
Individual Checkboxes	Select Specific	Select individual categories for bulk operations
X	Bulk Delete	Soft delete selected categories (Active mode)
+	Bulk Restore	Restore selected categories (Deleted mode)
Permanently Delete	Hard Delete	Permanently remove selected categories (Deleted mode)

Bulk Operation Workflow

1. Select Categories: Use checkboxes to select the categories you want to modify
2. Choose Action: Click the appropriate bulk action button based on your needs
3. Confirm Operation: Respond to the confirmation dialog to proceed or cancel
4. View Results: The page refreshes to show the updated category list

---

Delete Workflows

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

Soft Delete Process

1. Initial Deletion: Categories are marked as deleted (Active = 2) but remain in the database
2. Confirmation Required: Each delete action requires explicit confirmation
3. Immediate Redirect: After deletion, you're redirected to the deleted items view
4. Reversible: Soft-deleted categories can be restored at any time

Recovery Process

1. Access Deleted View: Click "UnDelete" to view soft-deleted categories
2. Select Categories: Choose which deleted categories to restore
3. Restore Action: Click the green "+" button to restore selected items
4. Confirmation: Confirm the restoration in the dialog box
5. Return to Active: Restored categories return to active status (Active = 1)

Permanent Deletion

1. Access Deleted View: Navigate to the deleted categories view
2. Select Items: Choose categories for permanent removal
3. Hard Delete: Click "Permanently Delete" button
4. Double Confirmation: Confirm the irreversible action in the warning dialog
5. Complete Removal: Selected categories are permanently removed from the database

---

Individual Record Actions

Each category record provides individual action options for precise management:

Action	Icon/Link	Function	Destination
Edit	ð??쳌 Edit Icon	Opens category edit form	cat_RecordEdit.cfm
Delete	Delete Link	Soft delete individual category	Returns to search with deleted view

Edit Workflow

1. Click Edit Icon: Click the edit icon next to any category
2. Modify Details: Update category information in the edit form
3. Save Changes: Submit the form to save modifications
4. Return to List: Navigate back to the category list to see changes

---

View Modes

The system provides two distinct view modes for comprehensive category management:

Active Categories Mode

• Default View: Shows all active categories (Active = 1 or NULL)
• Available Actions: Add, Edit, Search, Soft Delete
• Bulk Operations: Mass deletion of selected categories
• Status Display: Shows active status indicators

Deleted Categories Mode

• Access Method: Click "UnDelete" button to switch modes
• Shows Only: Categories with Active = 2 (soft deleted)
• Available Actions: Restore, Permanent Delete, Search
• Recovery Options: Individual and bulk restoration capabilities
• Return Navigation: "Back to Categories" button returns to active view

---

Data Persistence

The system maintains user preferences and search states across sessions:

Client Variables

Variable	Purpose	Default Value
category_query	Remembers last search term	Empty string
category_sort	Remembers sort column	"desc" (Description)
category_sort_indic	Remembers sort direction	"ASC" (Ascending)

Session Behavior

• Search Persistence: Your last search term is remembered when you return
• Sort Preferences: Column sort settings persist across page visits
• Automatic Restoration: Previous settings are automatically applied on page load
• Cross-Session: Preferences are maintained between browser sessions

---

---

Permission Requirements

Category management requires appropriate administrative permissions:

Restricted Operations

• Permanent Deletion: Requires highest-level administrative privileges
• Bulk Operations: May require elevated permissions for mass changes
• System Categories: Some categories may be protected from modification
• Cross-Reference Checks: Categories in use by other records may have deletion restrictions