This is a raffle tracking system. ? You will have a lot easier time with this if you know excel.
**THIS WILL MAKE A LOT MORE SENSE AFTER YOU SEE THE EXCEL FILE.**
You will: ? Create a MySql database with a connection in PHP that does the following:
1. Have a list of rows, from 00 to 99
2. Each row number will have several quantities input during the day. ? The system will add such quantities per row. ? So, for row 0, the user might input 500, 500, 500, and the system will show 1500 in the final report. For row 1, 1500, 500 and 1000 and the system will show 3000, etc.?
You may call this COLUMN A, which shows the sum of quantities, both per row and the grand total in the end. ? The sum of quantities will be referred as GROSS TOTAL.
3. ? The system will calculate the PERCENTAGE of the total for each row in Column A. ? You may call this column B or PERCENTAGE.?
4.? The system will multiply the total of each individual row in Column A by 72. ? You may call this column C or PAYOUT.
5. ? The system will subtract the amount in PAYOUT from the NET TOTAL. SEE BELOW.
6. If the result of the operation is positive, the numbers will be green. ? If the result is negative, the numbers will be pink. ? If the result is negative by more than 300.000, numbers will be red.
7. ? GROSS TOTAL ? has a COMMISSION which normally is 17% minus insurance, but the administrator should be able to set the percentage.?
COMMISSION = ((GROSS TOTAL - INSURANCE)*.17)
8. When the amount of an individual row is excessive and payout would be too large, the administrator will set an insurance. ? This reduces the total amount of a row. ? So, if a row has 10.000, payout would be 720.000. ? The administrator can set insurance for 5.000, making payout only 360.000
9.? A report should show GROSS TOTAL, COMMISSION, INSURANCE, and NET TOTAL. ? This report should be done for the date selected.
10. ? This has two levels. ? Administrator and user. ? There will only be one administrator and only one user. ? Continues...
## Deliverables
The administrator can do everything.
That is:
a. Input data
b. See the total report
c. See the insurance report
d. Download the total report
e. Activate a sheet for one particular date
f. Set insurance in individual rows
g. Set the commission percentage
h. Close the sheet of one particular date so that it accepts no more data.
The user can: ?
a. Input data
b. See the total report
c. See the insurance report
d. Download the total report
I do not have