We have a small martial arts club and wish to make things more up to date with regard to members 'signing in' and our general membership database and retail purchases area etc. We need some kind of program to record various information and make the 'sign in' process more 'electronic'.
## Deliverables
The program needs to include the following criteria:
1. record contact details and other information for all members including photo & notes & financials(club purchases etc) source of origin of new member(tv/ flyer / yellow pages etc)credit card / direct debit card details/ next of kin contact etc. current level of membership(rank)(….& more )
2. Number of member’s visits to be recorded in ‘attendance register’ and on members personal details.
3. provision to send email to single member or all members at once
4. record a $ amount collected upon ‘check in’ for any monies received at front desk
5. have simple user interface for ‘check in’ procedure(simply enter member number and press ‘Enter’)
6. ‘check in’ to auto record the cost of admission and add that amount to the front desk monies received ledger.
7. option to check members in to 5 ??" 10 different types of lessons (which may have different entry prices) and record the duration of each of those lessons (in minutes)
8. facility to add different instructors to different lessons and instructors name to be recorded with that lesson
9. ‘Events’ calendar with provision to list various events on particular dates
10. ability to find those various events in calendar upon searching the calendar to see when those events are / or were in past.
11. each member to have the option to be linked with various payment plans (pre pay 1 visit per week, paid on a monthly basis etc)
12. provision to ‘red flag’ on ‘check in’ if member is un-financial or has ‘used up’ their number of ‘pre paid’ visits (including audio sounds)
13. provision for member who has used up their ‘pre paid’ visits to be able to pay at front desk for an extra visit.(with that payment adding on to their financial record and also recorded in the general ‘cash register’ for that day.
14. provision to pop up notes for certain members on check in.(for important notices/ reminders etc) (including audio sounds)
15. Certain types of ‘special’ lessons not eligible for ‘pre paid’ plans and must be paid for separately
16. provision for member to pay in advance for those ‘special’ lessons (and therefore be admitted immediately without having to pay at ‘check in’ or the time of the lesson beginning)
17. retail items in 6 different categories to be able to be listed for purchase
18. stock inventory (including brief suppliers details and cost of stock) and automatic ‘re ordering’ upon stock levels dropping to certain numbers
19. $ amounts of members purchases to be listed on members details as well as daily cash register
20. 2 levels of admin. Full & ‘ front desk’
21. invoices and statements easily printed upon purchase of goods or lessons
Reports needed are:
1. Number of attendances between 2 dates (or only 1 date)
2. Number of total lessons available to members during the same period of time(to ascertain individual members attendance averages)
3. Total $ amount collected between 2 dates (or only 1 date) from all or any retail ‘categories’
4. total number of new members added between 2 dates including ‘source of origin’ of members
5. report on impending membership renewals / birthdays
6. report on how many lessons each ‘instructor’ performed between 2 dates
And also....
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows xp