I am looking to put something on the back end of our company website where our sales reps can log in each day and put in any sales they got. I want to be able as an administrator to then check (check box) whether the account was started so we can create a commission schedule for them.
We need to be able to see it as a sales leader board connected from a laptop to a tv screen projected in our office. We do not want anyone who goes to our website to have access to it.
The sales rep would log in and be able to see all his sales for the month and previous months. He/she can click to enter a new sale (Residential or Commercial), Name, Address, Phone Number, Fax Number, Cell Phone #, email address, Initial Service Charge, Monthly Service Charge, Frequency (Weekly,Bi weekly, Monthly, Bi Monthly, Quarterly, One Time Service, Termite), Total Annual Revenue
As the admin we can create a monthly sales report, click when the sale has been services so i shows it under "Serviced for the Month" column so we can generate a monthly commission check for them.
this is the data i would want displayed in our office for all to see. I want it to be a leader board, so when someone else sells more for the month it moves him/her to the top of the leader board.
This is only the data, hopefully as a programmer you are more creative than i and can display the information to be seen better graphically.
I need it to be really simple. A program that is self explanatory once logged in as a sales rep as well as the admin side.