Member Mini Project

First Phase of Development - 6 September 2025

This phase of Development will have 1. Member Login. (Login Page) 2. View and Update his Member Profile & his Member Business Profile. (Home Page) 3. If the Member has a Privilege as Club Manager, then he will Update Mobile Number Value of Other Members (of SelfLogin=0 Records) in the Clubs Assigned. (Manage Club Page)
Note: You are working on one Mini module of a Project Hosted on a Sub Domain, sharing the database and Images hosted on the Primary Domain.

1 - Login:

User Enters Mobile Number & Click on Proceed.. Validate if that Mobile Number Exists or Not for any Member Record in DB… If Exists, then verify if that Member Record, his Club Record & his District Record are Active are Not. (If any of these conditions Fail, then Show him Appropriate Alert as Toast which disappears after 10 seconds, and keep him there it self). If All are Found to be Active, then We send OTP to that Number and Update the Login form to enter the OTP. We Validate Mobile Number and OTP, if found to be Accurate, then Session is Created and user is taken to Dashboard Page. Session closes when the browser is closed (OR) on 15 Minute Inactivity (OR) on Clicking Logout.
Note: Validate Mobile Number field to Enter EXACT 10 DIGITS, No Alpha, No Symbol, No SPACE, No Less No More… Activate Proceed Button when 10 Digits are entered. Allow EXACT 6 DIGITS in OTP Field and Activate Submit Button after having 6 Digits entered..
Note 2: What does Active member, Active Club & Active District mean? In every table we have IsActive & InTrash columns which are Bit values. Being IsActive=1 & InTrash=0 is treated as Active Record.
Note 3: The Logged in Member might be a Member in General (OR) a Member with Manager Privilege. If the Mobile Number of the Logged in Member is Found for Any ACTIVE Club Record in his DISTRICT… Then he is Treated as Manager for that Club. He may be a Manager for One or More Clubs in his District.

2 - Home Page:

On Home Page We show the Logged in Members Profile & his Business Profile with Option to Update. If the Logged in Member has the Privilege to Manage any Clubs, then the Manage Club Button is Visible to Him.
Note: Every Member will have a Member Profile. We will Show it along with Option to Update. For Business Profile, If he doesn’t have an Existing Record, Then he will first See, You Haven’t Created You Business Profile yet!. CREATE NOW.
If he has an Existing Business Record, then he will see it along with Option to Update.

3 - Manage Club:

This Page is Accessible ONLY IF THE LOGGED IN MEMBER HAS THE PRIVILAGE TO MANAGE One or More Clubs. On this page, we Show Drop Down List with List of Active Clubs he can manage Along with Search Box. If he has Only One Club to manage, then the DDL will directly select that Value and display the Member Records from that Club. If he has more than One club to Manage, then -- All Clubs -- is shown in DDL and list of Member Records from all the clubs he has the Privilege is shown on the page. Changing the Value in DDL will display Member records based on the Selected Club. Search Box Filters the Records based on the Club(S) & Search Value. Search can be from Member Name, Membership Number, Mobile Number. We will be Showing the Name of the Member, Member Ship Number, his Club Name & his Mobile Number Value. (Sorted by Member Name A to Z). A Mobile Icon is shown beside member record, up on clicking A modal popup is shown to Enter / Update the Mobile Number value for that Member record.
Note: Validate Mobile Number field to Enter EXACT 10 DIGITS, No Alpha, No Symbol, No SPACE, No Less No More… ALSO ENSURE (No Duplicate Mobile Number) that the Mobile Number Entered in this field doesn’t exist to any other Member Record in the Entire Database in Members Records Table. (MOBILE NUMBER IS UNIQUE VALUE IN ENTIRE DB Table)
Mobile Icon to Update Mob. No is shown only beside the Member Record where SelfLogin=FALSE in Members table. If this Value is TRUE, then Mobile Icon is Not Shown.