Task #175
Updated by Dana Basheer about 2 months ago
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 registration_table * id INT PK Unique member User ID * profile_id VARCHAR — Public profile ID (VMMYY####) * name VARCHAR(100) VARCHAR — Member User name * mobile_no VARCHAR(15) VARCHAR — Mobile number * email VARCHAR(100) — Email ID * created_at DATETIME — Profile created Registration date * is_active BOOLEAN — Profile status Status member_payment_table user_subscription_table * id INT PK Payment Subscription ID * member_id profile_id INT FK Reference members_profile_table(id) User profile * payment_status VARCHAR(20) VARCHAR — Payment status Paid / Unpaid * amount amount_paid DECIMAL(10,2) DECIMAL — 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