rhjohnsonsc2
01-19-2010, 04:32 AM
Updated 01/19/2010
I am in need of a php and MySql driven check-in system for a private club. Potential members can use a Join form on the club's website, to sign up, then they have to check their email and and click a link to confirm membership, then they are directed to a page online that thanks them for joining ****** and they get a temporary membership ID of WEB****. The information goes to our Mysql Database as a member application that has been confirmed.
When a membership application is still in the membership_apps table in the DB, if membership has been confirmed, you should be able to run a script in the browser (e.g http://yourdomain.com/check-in/processmembershipapps.php) to add the member to the members table.
You should aslo be able to run a script for your email list that will add each members first name and email address to a .txt file, this is so you can export it then import into a php mail list. The export script, (e.g http://yourdomain.com/check-in/exportmaillist.php)
(e.g. .txt file
Name and email
Robert and Jonie robert@mydomain.com)
The database tables need to have these tables:
*attendance_records (records members that check-in to our party)
*join_location_codes (Have multiple location Joins, either at party check-in or WEB. e.g GVL or WEB)
*events (listed events, such as party locations)
*Members (see notes at the bottom of required info)
*membership_types (1 Year $10.00)
*membership_applications (Confirmed YES or NO)
*settings
*staff
*** Required Members Info to collect on sign up on the Club's website. folder should show as: http://yourdomain.com/join
*Member Type: Couple / Single Female / Single Male
*Membership Type = 1 Year $10.00
*His_first _Name
*His_last_name
*his_date of birth (must be over 21 to join)
*Her_first_name
*Her_last_name
*her_date of birth (Must be over 21 to join)
*contact name
*address
*city
*state
*zip code
*phone number
*email address (for confirming membership and to be placed on a newsletter)
*Receive Postal Mail --- yes or No
*Receive Email --- YES or No
*SLS ID
*AFF ID
*Submit Application
User checks email looks for link to confirm, clicks link> redirected to a thank you for joining ***** your temp membership ID is WEB**** please bring with you to your first party.
If member shows up for a party and has not yet registered, the person performing check-in can enter the info manually, the info would be the same as above except you would have a staff area to verify info:
Staff area:
*his_ID_checked (Yes / NO )
*ID Type (text box)
*her_ID_checked (yes/no)
*her ID type (text box)
*attended orientation ( yes / no )
*Membership standing (New, good, banned, see manager)(By default, all members should be "New" until they check-in at the party) (should be able to add fields to the drop down menu if needed)
*Staff comments are about the member
*Submit new membership
**** If member is "NEW" by default when they check-in, the person would be prompted to ask if the new member has attended orientation, If NO, send member to orientation. In this case I would "Edit member" by checking ID's and so on and chaging if the attended orientation to "YES" then I would proceed to perform check-in. I would enter their membership ID # or Email address or Phone number and click the "Submit" button continue to next step in check-in process. See 4 Step Check-in process below.
When you submit a new membership at a party location, you should be redirected to a new page telling you that new membership has been created and their membership ID is GVL**** (start all membership numbers at 1000)
Check-in: All new members signing up on the form online are temporary until they come to a party and all info has been verified by a staff member performing the check-in.
you can check-in members by 1 of 3 ways:
membership number
phone number
email address
Once that has been entered, submit and go to the next page. Next page should contain the members if couple then it would list his first name and his last name and her first name and her last name with the ability to have a check box to the left of eah of their names, that in case one of the people in the couple are coming with anther member, then there would be a membership ID number of the person attending with them (e.g A male of one couple wants to attend a party with a female of another couple, they are both members, we can join them together for one party at check-in using both membership ID's) Once that has been entered, then you can submit onto the next page, this lists the members info section and then it will have the event fee's all ready pre populated(e.g $35.00) and then the next line would be pre populated with membership fee due (e.g.$10.00)(These fees should be able to be changed in the Database at anytime) The next line would have the amount total due to club, the next line would have the amount tendered. The next line would have change due to member. Then submit to the next page, this page would allow you to print name tags using a Dymo Label Printer (.LWL) file. The final step, is the Check-in button. The whole check-in process of one member should take no less that one minute, unless you have a new member to register.
*** If a member does not owe a membership fee or member gets in free, you should be able to just zero out the pre-populated fields***
You should be able to have in the menu page to reprint Name badges also, all you would have to do is enter the first name of the member needing a new badge.
I have some sample pages with the menus on them that I created in HTML to show the structure of the pages, I need it clean, ledgible, and easy to navigate.
Menus:
Top Menu should have:
Home | Members | Check-in | Reports | Admin
Members: should be able to: (menu items below can be side menus items)
add New Member
Look up Member
Edit Member
Delete Member
Check-in you should be able to:
Check-in
Reprint Name Badges (type in the first name of the person needing Name badge)
Reports: you should have a menu to: (this can be a side menu item)
Check Drawer (New window opens to tell you total money collected)
Event report ( New window opens to give you:
Total New Membership Fee's collected
Event Fee's Collected
Single Female's in attendance
Single Males in attendance
Couples in attendance
Total people in attendance)
Admin Menu:
this section you should be able to:
Settings (Set the party location and date of next event)(e.g event: Greenville Hotel Party, Date 2010-01-11)
-----------------------------------------
Export Data (export the event reports by a particular event date or members names into a .csv file or .txt file)
--------------------------------------------------------------------
Void Transaction
Refund Transaction
------------------------------------------------------------------
List Staff Members
Add Staff
Edit Staff
Delete Staff
(These actions need to be done from the users end without access to the backend, but could also be done in the backend also)
-------------------------------------------------------------------
List Event
Add Event
Edit Event
Delete Event
(These action need to be done from the users end without access to the backend, but could be done in the backend also)
4 Step Process to Check-in:
Click Check-in from top menu>
1) enter member ID, or Email Address, or Phone Number to locate member info. Click "continue"
2) Small section here. Members listed. Each members name would have a check box next to thir names. Under that would be a section too add another member id, so if you could take two single members and join as a couple. (e.g. one person from one couple attends party, another person from another couple attends party, if they are a male & female, they could be joined together as one couple for that party only) So, in the check boxes, you would uncheck the person that is not there and add the membership number of the other person attending for that one party.
3) here you will see a section for members info, next section would list the event, and Event fee, membership fee due if any, total amout due, and amount tendered, and change due. click "continue"
4) Print name badges (just prints the first name of each member) Label printer to use is a Dymo label writer turbo 400. The file is a .lwl file for events.
Check-in complete / back to home!
Please contact me for the sample files of what the check-in system should resemble, It does not have to look like this, but it has to perform effortlessly and no with no bugs.
I am in need of a php and MySql driven check-in system for a private club. Potential members can use a Join form on the club's website, to sign up, then they have to check their email and and click a link to confirm membership, then they are directed to a page online that thanks them for joining ****** and they get a temporary membership ID of WEB****. The information goes to our Mysql Database as a member application that has been confirmed.
When a membership application is still in the membership_apps table in the DB, if membership has been confirmed, you should be able to run a script in the browser (e.g http://yourdomain.com/check-in/processmembershipapps.php) to add the member to the members table.
You should aslo be able to run a script for your email list that will add each members first name and email address to a .txt file, this is so you can export it then import into a php mail list. The export script, (e.g http://yourdomain.com/check-in/exportmaillist.php)
(e.g. .txt file
Name and email
Robert and Jonie robert@mydomain.com)
The database tables need to have these tables:
*attendance_records (records members that check-in to our party)
*join_location_codes (Have multiple location Joins, either at party check-in or WEB. e.g GVL or WEB)
*events (listed events, such as party locations)
*Members (see notes at the bottom of required info)
*membership_types (1 Year $10.00)
*membership_applications (Confirmed YES or NO)
*settings
*staff
*** Required Members Info to collect on sign up on the Club's website. folder should show as: http://yourdomain.com/join
*Member Type: Couple / Single Female / Single Male
*Membership Type = 1 Year $10.00
*His_first _Name
*His_last_name
*his_date of birth (must be over 21 to join)
*Her_first_name
*Her_last_name
*her_date of birth (Must be over 21 to join)
*contact name
*address
*city
*state
*zip code
*phone number
*email address (for confirming membership and to be placed on a newsletter)
*Receive Postal Mail --- yes or No
*Receive Email --- YES or No
*SLS ID
*AFF ID
*Submit Application
User checks email looks for link to confirm, clicks link> redirected to a thank you for joining ***** your temp membership ID is WEB**** please bring with you to your first party.
If member shows up for a party and has not yet registered, the person performing check-in can enter the info manually, the info would be the same as above except you would have a staff area to verify info:
Staff area:
*his_ID_checked (Yes / NO )
*ID Type (text box)
*her_ID_checked (yes/no)
*her ID type (text box)
*attended orientation ( yes / no )
*Membership standing (New, good, banned, see manager)(By default, all members should be "New" until they check-in at the party) (should be able to add fields to the drop down menu if needed)
*Staff comments are about the member
*Submit new membership
**** If member is "NEW" by default when they check-in, the person would be prompted to ask if the new member has attended orientation, If NO, send member to orientation. In this case I would "Edit member" by checking ID's and so on and chaging if the attended orientation to "YES" then I would proceed to perform check-in. I would enter their membership ID # or Email address or Phone number and click the "Submit" button continue to next step in check-in process. See 4 Step Check-in process below.
When you submit a new membership at a party location, you should be redirected to a new page telling you that new membership has been created and their membership ID is GVL**** (start all membership numbers at 1000)
Check-in: All new members signing up on the form online are temporary until they come to a party and all info has been verified by a staff member performing the check-in.
you can check-in members by 1 of 3 ways:
membership number
phone number
email address
Once that has been entered, submit and go to the next page. Next page should contain the members if couple then it would list his first name and his last name and her first name and her last name with the ability to have a check box to the left of eah of their names, that in case one of the people in the couple are coming with anther member, then there would be a membership ID number of the person attending with them (e.g A male of one couple wants to attend a party with a female of another couple, they are both members, we can join them together for one party at check-in using both membership ID's) Once that has been entered, then you can submit onto the next page, this lists the members info section and then it will have the event fee's all ready pre populated(e.g $35.00) and then the next line would be pre populated with membership fee due (e.g.$10.00)(These fees should be able to be changed in the Database at anytime) The next line would have the amount total due to club, the next line would have the amount tendered. The next line would have change due to member. Then submit to the next page, this page would allow you to print name tags using a Dymo Label Printer (.LWL) file. The final step, is the Check-in button. The whole check-in process of one member should take no less that one minute, unless you have a new member to register.
*** If a member does not owe a membership fee or member gets in free, you should be able to just zero out the pre-populated fields***
You should be able to have in the menu page to reprint Name badges also, all you would have to do is enter the first name of the member needing a new badge.
I have some sample pages with the menus on them that I created in HTML to show the structure of the pages, I need it clean, ledgible, and easy to navigate.
Menus:
Top Menu should have:
Home | Members | Check-in | Reports | Admin
Members: should be able to: (menu items below can be side menus items)
add New Member
Look up Member
Edit Member
Delete Member
Check-in you should be able to:
Check-in
Reprint Name Badges (type in the first name of the person needing Name badge)
Reports: you should have a menu to: (this can be a side menu item)
Check Drawer (New window opens to tell you total money collected)
Event report ( New window opens to give you:
Total New Membership Fee's collected
Event Fee's Collected
Single Female's in attendance
Single Males in attendance
Couples in attendance
Total people in attendance)
Admin Menu:
this section you should be able to:
Settings (Set the party location and date of next event)(e.g event: Greenville Hotel Party, Date 2010-01-11)
-----------------------------------------
Export Data (export the event reports by a particular event date or members names into a .csv file or .txt file)
--------------------------------------------------------------------
Void Transaction
Refund Transaction
------------------------------------------------------------------
List Staff Members
Add Staff
Edit Staff
Delete Staff
(These actions need to be done from the users end without access to the backend, but could also be done in the backend also)
-------------------------------------------------------------------
List Event
Add Event
Edit Event
Delete Event
(These action need to be done from the users end without access to the backend, but could be done in the backend also)
4 Step Process to Check-in:
Click Check-in from top menu>
1) enter member ID, or Email Address, or Phone Number to locate member info. Click "continue"
2) Small section here. Members listed. Each members name would have a check box next to thir names. Under that would be a section too add another member id, so if you could take two single members and join as a couple. (e.g. one person from one couple attends party, another person from another couple attends party, if they are a male & female, they could be joined together as one couple for that party only) So, in the check boxes, you would uncheck the person that is not there and add the membership number of the other person attending for that one party.
3) here you will see a section for members info, next section would list the event, and Event fee, membership fee due if any, total amout due, and amount tendered, and change due. click "continue"
4) Print name badges (just prints the first name of each member) Label printer to use is a Dymo label writer turbo 400. The file is a .lwl file for events.
Check-in complete / back to home!
Please contact me for the sample files of what the check-in system should resemble, It does not have to look like this, but it has to perform effortlessly and no with no bugs.