Sites Management

The Sites Management page provides comprehensive control over website layouts and pages within your system. This interface allows administrators to view, search, edit, delete, and manage all site configurations, themes, and layout properties. The page supports both soft-delete and hard-delete operations, with role-based permissions controlling access to various functions.

Quick Start

To quickly find and manage sites: 1) Use the search box to filter by site name, 2) Select theme filter if needed, 3) Use checkboxes to select multiple sites for bulk operations, 4) Click Edit icon to modify layouts, or 5) Use Delete to soft-delete sites. The "Show All" button clears all filters.

Toolbar Functions

Button/Control Function Permission Required
Add Creates a new site layout page Layout_Add
Back Returns to previous page in browser history None
Search Box Filters sites by DSN name (supports partial matches). Press Enter or click Search button None
Search Executes search with current search box text None
Show All Clears all search filters and displays all sites None
Theme Filter Dropdown to filter sites by color scheme/theme None
Check All Selects/deselects all visible site checkboxes for bulk operations None
X (Delete/Undelete) Bulk delete selected sites (red X) or undelete if viewing deleted items (green +) Layout_Delete
Permanently Delete Hard delete selected sites and all associated widgets (only visible when viewing deleted items) Layout_Delete

Sites Table Columns

Column Description Sortable
Checkbox Selection checkbox for bulk operations (delete, undelete, hard delete) No
Site DSN (Data Source Name) of the site. Long names are truncated with "..." but show full name on hover Yes
Edit Icon Pencil icon that opens the Page Layout Editor in a popup window No
Delete Link Red "Delete" text link that soft-deletes the site with confirmation prompt No
Status Current status of the site (Active, Inactive, Deleted, etc.) Yes

Search and Filtering

Search Functionality

The search system provides flexible filtering options:

  1. Text Search: Enter partial or complete site DSN names in the search box
  2. Enter Key Support: Press Enter while in the search box to execute search
  3. Wildcard Matching: Search uses SQL LIKE with wildcards for partial matches
  4. Case Insensitive: Search is not case-sensitive
  5. Persistent Search: Search terms are remembered in client variables

Theme Filtering

The theme dropdown allows filtering by color scheme:

  • Shows all available theme references from the Colors table
  • Combines with text search for refined results
  • Updates URL parameters to maintain filter state

Ownership Filtering

Non-admin users see filtered results based on:

  • Sites they own (matching their email username)
  • Sites owned by members of their workgroup
  • Hidden pages excluded unless explicitly shown

Sorting System

The table supports column-based sorting with visual indicators:

Column Sort Behavior Visual Indicator
Site (DSN) Alphabetical ascending/descending Arrow icon (ascending.gif/descending.gif)
Status Numerical status code order Arrow icon (ascending.gif/descending.gif)

Sorting Tips

Click a column header to sort by that column. Click the same header again to reverse the sort direction. The arrow icon shows current sort direction. Sort preferences are remembered across sessions using client variables.

Deletion Workflows

Soft Delete Process

Sites can be soft-deleted, which marks them as deleted without removing data:

  1. Single Delete: Click the red "Delete" link next to a site
  2. Confirmation: Confirm the deletion in the JavaScript alert
  3. Status Update: Site status changes to 17 (deleted)
  4. Visibility: Site disappears from normal view but remains in database
  5. Recovery: Can be undeleted by viewing deleted items and using undelete function

Bulk Delete Process

Multiple sites can be deleted simultaneously:

  1. Selection: Check boxes next to sites to delete (or use "Check All")
  2. Delete Button: Click the red "X" button in the header
  3. Confirmation: Confirm bulk deletion in popup dialog
  4. Processing: All selected sites are marked with status 17
  5. Redirect: Page redirects to show deleted items view

Undelete Process

Soft-deleted sites can be restored:

  1. View Deleted: Navigate to Sites_search.cfm?showdeleted=true
  2. Select Sites: Check boxes next to sites to restore
  3. Undelete Button: Click the green "+" button
  4. Confirmation: Confirm restoration in popup dialog
  5. Status Restore: Site status changes back to 1 (active)

Hard Delete Process (Permanent)

Already-deleted sites can be permanently removed:

  1. Prerequisite: Sites must already be soft-deleted (status 17)
  2. View Deleted: Access the deleted items view
  3. Select Sites: Check boxes next to sites to permanently delete
  4. Hard Delete Button: Click "Permanently Delete" button
  5. Warning Confirmation: Confirm with "This cannot be undone!" warning
  6. Cascade Delete: Removes all associated widgets first
  7. Site Removal: Completely removes site records from database

Important Deletion Warning

Hard deletion permanently removes sites and all associated widgets from the database. This action cannot be undone. Always verify you have backups before performing hard deletions. Soft deletion is recommended for most scenarios as it allows recovery.

Editing and Layout Management

Page Layout Editor

The edit icon opens the Page Layout Editor in a popup window:

  • Popup Window: Opens in separate window (300x300px default)
  • Live Editing: Make changes to page layout and widgets
  • Permission Check: Requires Layout_Edit permission
  • Locked Pages: Some pages may be locked and show no edit icon

Inline Editing View

When URL parameter "editpage" is present, an inline editor appears:

  • Embedded Editor: 720px wide iframe with page layout editor
  • Additional Links: Edit Colors and Edit Properties links
  • Float Option: Option to open in separate floating window
  • Full Integration: Direct access to all editing functions

Preview Functionality

When URL parameter "page" is present, a preview appears:

  • Live Preview: 770px wide iframe showing actual page
  • Current View Header: Shows which page is being previewed
  • Close Button: X button to close preview and return to list
  • Scrollable Content: 500px height with auto scrolling

Permission System

The Sites Management page enforces role-based permissions:

Permission Required For Effect When Missing
Layout_Review Accessing the Sites page at all Redirected to "denied" page
Layout_Add Creating new sites Add button is disabled
Layout_Edit Editing existing sites Edit icons are hidden
Layout_Delete Deleting sites Delete links are hidden

Admin Override

User ID 1 (admin) bypasses all permission checks and can perform any action regardless of assigned permissions.

Status Indicators

The page provides several visual status indicators:

Indicator Meaning Location
Showing Deleted Currently viewing soft-deleted sites Search results header
Red row highlight Site pending deletion confirmation Table rows
Truncated names (...) Site name longer than 25 characters Site column (hover for full name)
Missing edit/delete icons Page is locked or user lacks permissions Action columns

Search Results Information

The black header bar shows detailed search result information:

  • No Results: "No records found matching [search term]"
  • Single Result: "Your search of [search term] returned 1 result"
  • Multiple Results: "Your search of [search term] returned X results"
  • All Records: When no search term, shows total count
  • Deleted View Badge: Red badge when viewing deleted items

URL Parameters

The page responds to various URL parameters for different modes:

Parameter Purpose Example
query Search filter for site names ?query=mysite
sort Column to sort by ?sort=DSN
showdeleted Show soft-deleted sites ?showdeleted=true
theme Filter by color scheme ?theme=blue
owner Filter by site owner ?owner=username
page Show preview of specific page ?page=homepage
editpage Show inline editor for page ?editpage=123

Summary

The Sites Management page provides comprehensive control over website layouts with powerful search, filtering, and bulk operation capabilities. Users can efficiently manage large numbers of sites through the sortable table interface, while role-based permissions ensure appropriate access control. The soft-delete system with undelete capability provides safety, while hard-delete options allow permanent cleanup when needed. Integration with the Page Layout Editor enables seamless editing workflows, and the preview functionality allows quick content verification without leaving the management interface.