Advanced Order Form, Export to CSV, and more

ORDER FORM CUSTOMER REQUIRED INFORMATION First Name Middle Name Last Name Address city state zip code Birthday (12-25-89 format; month-day-year) Attach photo Attach signature ($10 extra) Type (type 1, type 2) If TYPE 1 ID number = 343 609 231(random generated, each set of 3 must be range from 100-999) Eyes (BR,BL,BK,HZ,GR) height (5-11) gender (F,M) Expiration date (Add +8 years from issue date) Issue date (Add +21 years, and +7 days) If TYPE 2 ID number = D9461234 (random generated, letter stays the same, range from 10000000-9999999) Eyes(BRN,BLK,BLU,HAZ,BLN) hair(BRN,BLK,BLN,GRY,WHT) weight (210) height (5-10) gender (F,M) Expiration date (Add +8 years from issue date) Issue date (Add +21 years) OTHER INFORMATION Shipping info Production speed, shipping type, and display order total Moneypak number (option to add up to 5 moneypaks total) Email BULK ORDER Bulk order option to add as many friends as they want. User can press "add" button, to allow user to add more friends using all same information above. (Customer required information- each customer needs to be able to choose type1- or type2). Pricing changes if there are a certain amount of people) 1 person = $150 2 - 5 people = $125 each person 6 - 15 people = $100 each person 25+ people = $85 each Order form will add total amount so they can see how much everything will cost, while adding more people to the order, or additional options (production speed, signature, etc…) Captcha Flood protection (1 submit per 60 seconds) ------ After order submit. - Customers submitted photos are renamed to the value of "First Name + Last Name" text box. Ex: John [login to view URL] - Customers signature file are renamed to "First Name + Last Name-signature" text box. Ex: John [login to view URL] - Every order is emailed too my email as backup. - Also emails customer their order information and order number as well. Backend - Orders are stored so I can browse all orders by dates, once order comes in, there are these type of orders (confirmed,not confirmed, completed) I can choose what it is with a click of a button - If a bulk order comes in, I want the bulk order to show each individual person separately so I see "how many" orders there really are. If only 1 or 2 moneypak numbers were submitted, you must indicate that entire order belongs to that moneypak #. - Ability to add tracking number, once tracking number is added, automatically emails customer and marks completed. - I need to be able to filter and sort by moneypak amount as well. I need a field in the backend where I can put the moneypak value of the card. - The order system must add up the total of all orders (if I put the value of the moneypak in the order) - I also want a page where I can check of moneypak status. "MoneyPak Status", it will show each moneypak order submitted. with a "Used / Not Used" button, so I can keep track of which ones are used or not - The ability to checkbox as many orders as I want and export CSV with certain information. (exporting TYPE1 will contain different columns than TYPE2) So you can only export Type1 or Type2 at a time, but as many as you want. I will provide examples of CSV files of exactly how they must be exported. - There will be two export options (export customer data, and export ANSI data) which I provided to you as well. When I export ANSI data, it will generate a txt for each user or I can click ANSI next to the order to view the ANSI code. - There will also be a download link next to each order that goes to their photo, and signature - The ability to search by order number, moneypak number, email, name, tracking number. - The ability to edit orders, delete orders. - Backend must be password protected, sql injection protected, very secure.