Subscriber Mass Delete

Overview

Subscriber Mass Delete allows you to delete multiple subscriber accounts simultaneously. This feature performs cascade deletion, automatically removing all related data including Radius authentication, invoices, payments, and associated records.

WHAT IS SUBSCRIBER MASS DELETE?

Subscriber Mass Delete is a bulk deletion feature that:

• Bulk Deletion - Delete multiple subscribers at once
• Permission-Based - Resellers can only delete their own subscribers
• Cascade Deletion - Automatically removes all related data
• Radius Cleanup - Removes Radcheck, Radusergroup, Radreply
• Activity Logging - Tracks all deletion operations
• Selective Deletion - Skip subscribers without permission
• Confirmation Required - Prevents accidental deletions

Perfect for: Cleaning up inactive accounts, bulk account removal, data cleanup!

---

📋 Table of Contents

1. How It Works
2. Permission-Based Access
3. What Gets Deleted
4. Step-by-Step Guide
5. Best Practices
6. Common Use Cases

---

How It Works

The Process

1. Select Subscribers → 2. Click Mass Delete → 3. Confirm Deletion → 
4. Permission Check → 5. Delete Subscriber → 6. Cascade Delete → 
7. Activity Logged → 8. Success Message

What Happens When You Delete

Automatic Actions:

• ✅ Subscriber profile deleted
• ✅ Radcheck entries removed (Radius authentication)
• ✅ Radusergroup entries removed (Radius groups)
• ✅ Radreply entries removed (Radius attributes)
• ✅ Related invoices deleted (cascade)
• ✅ Related payments deleted (cascade)
• ✅ Related ledger entries deleted (cascade)
• ✅ Related documents deleted (cascade)
• ✅ Related MAC addresses deleted (cascade)
• ✅ Related IP assignments deleted (cascade)
• ✅ Activity log generated

---

Permission-Based Access

Admin & Staff

Can Do:

• ✅ Delete any subscriber in ISP/Branch
• ✅ No permission restrictions
• ✅ Full access to all subscribers

Deletion Scope:

Admin/Staff → Can delete ALL subscribers

---

Reseller, Sub-reseller, Retailer

Can Do:

• ✅ Delete only their own subscribers
• ✅ Delete subscribers of their sub-resellers
• ✅ Delete subscribers of their retailers
• ❌ Cannot delete other resellers' subscribers

Permission Check:

Reseller → Can delete:
  - Own subscribers
  - Sub-reseller's subscribers
  - Retailer's subscribers

Sub-reseller → Can delete:
  - Own subscribers
  - Retailer's subscribers

Retailer → Can delete:
  - Own subscribers only

Selective Deletion:

• If permission denied: Skip subscriber (no error)
• Continue with next subscriber
• Only delete authorized subscribers

---

What Gets Deleted

1. Subscriber Profile

Deleted:

• Subscriber record from subscribers table
• All profile information
• All settings and configurations

---

2. Radius Authentication (Cascade)

Deleted:

• Radcheck - Authentication attributes

  • Username
  • Password (Cleartext-Password)
  • Expiration date
  • Other check attributes

• Radusergroup - Group memberships

  • Package policy groups
  • User group assignments

• Radreply - Reply attributes

  • Framed-IP-Address
  • Framed-IP-Netmask
  • Other reply attributes

---

3. Related Data (Cascade)

Deleted via Model Relationships:

• Invoices - All subscriber invoices
• Payments - All payment records
• Ledger Entries - All balance transactions
• Documents - Identity documents
• MAC Addresses - Registered MAC addresses
• IP Assignments - Static IP assignments
• Subscriber Services - Package service records
• Notes - Private and global notes
• Tickets - Support tickets
• Activity Logs - Related to subscriber

---

Step-by-Step Guide

Step 1: Access Subscriber List

Navigate to Subscribers:

1. Go to Subscribers menu
2. View All Subscribers page
3. See list of subscribers

---

Step 2: Select Subscribers

Selection Methods:

Method 1: Individual Selection

1. Check checkbox next to each subscriber
2. Select multiple subscribers
3. Selected IDs collected

Method 2: Select All

1. Check "Select All" checkbox
2. All visible subscribers selected
3. Can deselect individual subscribers

Method 3: Filter and Select

1. Apply filters (status, package, area, etc.)
2. Select filtered subscribers
3. Only filtered subscribers affected

---

Step 3: Click Mass Delete

Initiate Deletion:

1. Click "Mass Delete" button
2. Confirmation modal appears
3. Review selected subscribers

---

Step 4: Confirm Deletion

Confirmation Modal:

Are you sure you want to delete X subscribers?
This action cannot be undone.

Selected Subscribers: [List of IDs]

[Cancel] [Confirm Delete]

Important:

• Review selected subscribers carefully
• Deletion is permanent
• Cannot be undone
• All related data will be deleted

---

Step 5: System Processing

What Happens:

1. System parses selected subscriber IDs
2. Loops through each subscriber ID
3. Checks user permission for each subscriber
4. Deletes authorized subscribers
5. Skips unauthorized subscribers (no error)
6. Cascade deletes related data
7. Generates activity log
8. Returns success message

Processing:

For each selected subscriber:
  1. Check permission
  2. If authorized: Delete subscriber
  3. If not authorized: Skip (continue)
  4. Cascade delete related data
  5. Count successful deletions

---

Step 6: Review Results

Success Message:

Successfully X Subscribers Deleted.

What Happened:

• X subscribers deleted
• All related data removed
• Radius authentication cleaned up
• Activity logged

If No Deletions:

Oops! Something Wrong.

Possible Reasons:

• No permission for any selected subscribers
• Invalid subscriber IDs
• System error

---

Best Practices

Before Deleting

1. Verify Subscribers

✅ Review selected subscribers carefully
✅ Ensure correct subscribers selected
✅ Check subscriber details
✅ Verify no active services

2. Check Financial Records

✅ Verify no outstanding invoices
✅ Check payment history
✅ Ensure balance settled
✅ Export financial data if needed

3. Backup Data (If Needed)

✅ Export subscriber data
✅ Save important information
✅ Archive documents
✅ Keep financial records

4. Verify Permissions

✅ Ensure you have permission
✅ Check subscriber ownership
✅ Verify hierarchical access

---

During Deletion

1. Use Filters

✅ Filter by status (Inactive, Expired)
✅ Filter by package
✅ Filter by area
✅ Filter by salesperson

2. Review Selection

✅ Double-check selected subscribers
✅ Verify count matches expectation
✅ Ensure no active subscribers included

3. Confirm Carefully

✅ Read confirmation message
✅ Verify subscriber count
✅ Understand deletion is permanent

---

After Deletion

1. Verify Deletion

✅ Check subscriber list updated
✅ Verify subscribers removed
✅ Confirm count decreased

2. Check Activity Log

✅ Review activity log entry
✅ Verify deletion recorded
✅ Check who performed deletion

3. Verify Radius Cleanup

✅ Ensure Radcheck entries removed
✅ Verify Radusergroup cleaned
✅ Check Radreply removed

---

Common Use Cases

Use Case 1: Clean Up Inactive Accounts

Scenario:

Multiple inactive subscribers
No activity for months
Need to clean up database

Steps:

1. Filter by profile status: Inactive/Expired
2. Filter by last activity date
3. Select all filtered subscribers
4. Mass delete
5. Database cleaned

Result:

• Inactive accounts removed
• Database optimized
• Cleaner subscriber list

---

Use Case 2: Remove Test Accounts

Scenario:

Multiple test accounts created
Testing phase complete
Need to remove test data

Steps:

1. Filter by username pattern (test*)
2. Or filter by specific package
3. Select all test accounts
4. Mass delete
5. Test data removed

Result:

• Test accounts removed
• Production data clean
• No test data pollution

---

Use Case 3: Reseller Cleanup

Scenario:

Reseller wants to clean up
Multiple expired subscribers
Need to remove old accounts

Steps:

1. Reseller logs in
2. Filters by expired status
3. Selects expired subscribers
4. Mass delete (only authorized)
5. Expired accounts removed

Result:

• Reseller's expired accounts removed
• Only authorized deletions performed
• Other resellers' subscribers untouched

---

Use Case 4: Area-Based Cleanup

Scenario:

Service discontinued in specific area
All subscribers in area need removal
Bulk deletion required

Steps:

1. Filter by country/province/city/area
2. Select all subscribers in area
3. Mass delete
4. Area subscribers removed

Result:

• All area subscribers removed
• Service area cleaned up
• Database updated

---

Use Case 5: Package Discontinuation

Scenario:

Package being discontinued
No subscribers should remain on package
Need to remove all package subscribers

Steps:

1. Filter by package
2. Select all subscribers on package
3. Mass delete
4. Package subscribers removed

Result:

• All package subscribers removed
• Package can be safely deleted
• No orphaned subscribers

---

Summary

Subscriber Mass Delete is a powerful bulk deletion feature that:

✅ Bulk Deletion:

• Delete multiple subscribers at once
• Efficient database cleanup
• Time-saving operation

✅ Permission-Based:

• Admin/Staff: Delete any subscriber
• Reseller: Delete own subscribers only
• Selective deletion (skip unauthorized)
• Hierarchical access control

✅ Cascade Deletion:

• Subscriber profile removed
• Radius authentication cleaned (Radcheck, Radusergroup, Radreply)
• All related data deleted (invoices, payments, ledger, documents)
• Complete data cleanup

✅ Safety Features:

• Confirmation required
• Permission checks
• Activity logging
• Selective deletion (skip unauthorized)

✅ Use Cases:

• Clean up inactive accounts
• Remove test accounts
• Reseller cleanup
• Area-based cleanup
• Package discontinuation

⚠️ Important Warnings:

• Deletion is permanent
• Cannot be undone
• All related data deleted
• Review carefully before confirming
• Backup important data first

Perfect for ISPs wanting efficient bulk subscriber removal with automatic Radius cleanup and cascade deletion!