Admin Control Panel v2.0

✎ Editing: qa_test_pages.sh ← Back

#!/bin/bash
# Comprehensive QA Testing Script for Admin Panel
# Tests all pages and captures errors

BASE_URL="http://127.0.0.1:8000"
LOG_FILE="/tmp/qa_test_results.log"
ERRORS_FILE="/tmp/qa_errors.log"

echo "=== QA Testing Started at $(date) ===" > $LOG_FILE
echo "" > $ERRORS_FILE

# Array of pages to test
pages=(
    "panel/dashboard"
    "panel/users/leads/list"
    "panel/users/customer/list"
    "panel/users/employee/list"
    "panel/attendance/list"
    "panel/my-attendance/list"
    "panel/attendance/report"
    "panel/time-off/list"
    "panel/software-project-management/list"
    "panel/task-dashboard/admin"
    "panel/leads"
    "panel/leads/dashboard"
    "panel/leads/kanban"
    "panel/finance/accounting/list"
    "panel/finance/transactions/list"
    "panel/finance/overtime/list"
    "panel/smm-list"
    "panel/cms/items/list"
    "panel/cms/testimonial/list"
    "panel/cms/about_home/list"
    "panel/cms/home_services/list"
    "panel/about_us/about/list"
    "panel/about_us/portfolio/list"
    "panel/about_us/about_us/list"
    "panel/about_us/about_company/list"
    "panel/about_us/about_description/list"
    "panel/about_us/gallery/list"
    "panel/about_us/team/list"
    "panel/about_us/jobs/list"
    "panel/blog/list"
    "panel/contact_us/list"
    "panel/contact_table/list"
    "panel/setting/list"
    "panel/settings/whatsapp"
    "panel/smtp/list"
    "panel/settings/contract/list"
    "panel/roles/roles/list"
    "panel/roles/permissions/list"
    "panel/hiring/dashboard"
    "panel/hiring/job-postings"
    "panel/hiring/applications"
    "panel/page/list"
    "panel/faq/list"
    "panel/service/list"
    "panel/social/connections"
    "panel/maintenance-contract/list"
)

total=${#pages[@]}
current=0
errors=0

for page in "${pages[@]}"; do
    current=$((current + 1))
    url="${BASE_URL}/${page}"
    
    echo "[$current/$total] Testing: $page" | tee -a $LOG_FILE
    
    # Check HTTP status and look for SQL errors
    response=$(curl -s -w "\n%{http_code}" -L "$url" 2>&1)
    http_code=$(echo "$response" | tail -n1)
    body=$(echo "$response" | sed '$d')
    
    # Check for common error patterns
    if echo "$body" | grep -qi "SQLSTATE\|QueryException\|Column not found\|Table.*doesn't exist\|Unknown column"; then
        echo "  ❌ ERROR FOUND!" | tee -a $LOG_FILE
        echo "  URL: $url" >> $ERRORS_FILE
        echo "$body" | grep -i "SQLSTATE\|QueryException\|Column not found\|Table.*doesn't exist\|Unknown column" | head -3 >> $ERRORS_FILE
        echo "---" >> $ERRORS_FILE
        errors=$((errors + 1))
    elif [ "$http_code" != "200" ] && [ "$http_code" != "302" ]; then
        echo "  ⚠️  HTTP $http_code" | tee -a $LOG_FILE
    else
        echo "  ✅ OK" | tee -a $LOG_FILE
    fi
    
    sleep 0.5
done

echo "" | tee -a $LOG_FILE
echo "=== QA Testing Completed ===" | tee -a $LOG_FILE
echo "Total pages tested: $total" | tee -a $LOG_FILE
echo "Errors found: $errors" | tee -a $LOG_FILE

if [ $errors -gt 0 ]; then
    echo "" | tee -a $LOG_FILE
    echo "=== ERRORS SUMMARY ===" | tee -a $LOG_FILE
    cat $ERRORS_FILE | tee -a $LOG_FILE
fi

Cancel