VishwaVivah

The Admin Registration List Module allows the admin to view all registered users in the system along with their payment status.

The admin should be able to:

• View all registered users
• See serial number, name, mobile number
• View payment status (Paid / Unpaid)
• Filter users based on payment status

Table

members_profile_table

• id INT PK Unique member ID
• profile_id VARCHAR — Public profile ID (VMMYY####)
• name VARCHAR(100) — Member name
• mobile_no VARCHAR(15) — Mobile number
• email VARCHAR(100) — Email ID
• created_at DATETIME — Profile created date
• is_active BOOLEAN — Profile status

member_payment_table

• id INT PK Payment ID
• member_id INT FK Reference members_profile_table(id)
• payment_status VARCHAR(20) — Payment status
• amount DECIMAL(10,2) — Payment amount
• payment_date DATETIME — Payment date
• transaction_id VARCHAR(200) — Payment transaction ID
• is_active BOOLEAN — Status

Admin should have filter options:

• All Users
• Paid Users
• Unpaid Users

Validations

Serial Number

• Auto generated
• Starts from 1
• Increment sequentially

Name

• Mandatory
• Minimum 3 characters
• Maximum 100 characters

Mobile Number

• Mandatory
• Must be 10 digits
• Only numbers allowed
• Must exist in registration_table

Payment Status

Allowed values:

• Paid
• Unpaid
• Action Button

Admin can view all registered users

Only active users should appear

Payment status must reflect actual payment records

Unpaid users should still appear in list