Food Program

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