SFSP database system
The basic goal is to build a database system in JQUERY/PHP/MySQL to manage the Summer Food Program membership database.
Dynamic Database Driven Website
Membership database system
Designed to track each food participant
Intuitive easy-to-use interface
Creates customizable membership cards with photo and integrated barcodes or QR Code
Customizable card backgrounds and logos (can be based on member type)(Child - Adult or Senior)
Comprehensive set of reports on membership, visits and other statistics
Each member record has:
Full contact details (name, address, phone, mobile, e-mail)
Emergency contact details (name, address, phone, mobile, e-mail)
Standard attributes (Banned, Suspended, Cancelled)
User definable attributes/flags
User definable member types (e.g. Standard, Staff, Junior, etc)
Free text field for notes (e.g. allergy information)
Photo (JPG, GIF and BMP supported).
Meals received
Money paid
Each Student under 18 will eat free
Optional operator passwords for FrontGate module
Card Designer for modifying the design of membership and pass cards
FrontGate/Reception module - a Point of Sale application for handling
Customizable Menus
Membership meals
Logging of member visits
Pass handling
Loyalty points
Integrates with a receipt printer
Enter and record financial transactions
Meal price
new membership
membership renewal
club entry
barcoded goods
User-defined transactions
Accept transaction payments as cash, card or check
track receipts
menu production records
Add multiple restaurants and locations and and weekly customizable menus
Create and sell passes for member entry to club
Passes can be time limited, use limited (count number of uses) or both
Passes can have optional value to offset against entry charges (when used with transactions)
Membership passes will cover so many free meals per year whatever is assigned by the administrator
Operators with usernames and passwords
Can be used to restrict access to all programs and modules
Can be used to restrict access to reports or just financial reports
Loyalty Points
Points can be added or redeemed via the FrontGate module
Can be automatically added according to spend
Can be assigned a redemption cash value as a discount against spend
Member visit logging module to track eat participant
Group Accounts for collecting individual members into an associated group, e.g. a family
Will integrate with a barcode scanner or magnetic card reader or QR CODE.
Will work in a network configuration with an large number of networked PCs and tablets
Web Based Application
part 2
application should have the following users
administrative access
dispatcher
driver
track driver delivery locations (alert)
track drivers hours of work
print reports and forms once site is visited
delivery/pickup receipt (copy of document will be uploaded)
each receipt must be electronically signed with tablet device
track milage to each location
assign gas card number
restaurant vendor
participant
reports needed to be pre filled and printed
will be discussed once project is accepted
Dear client
i have 100% completion rate and 5/5 reputation. i have designed many membership site like this and i have experience in data driven websites. i can help you in this project and you will get 100% satisfaction. well in need to discuss more details about your project.
waiting for you reply.