Get a Freelance Job

Hi,

I have an application done in PHP and Mysql and i want it to me modified.

The applicaitons allows employees to enter the username and passwords to login. Once logged in they can enter their start time and finish time for the day. THis way i can keep record of their hours and how long they worked each day.

Now what i want done is the following:
– Employees login with own username and password
– Once logged in they have the option to add timesheet or view timesheets
– if add time sheet is selected: the will have the enter the following information:
– start time and date, finish time and date
– a drop down list will have the option yes or no for lunch. which means if they pick no, it means they did not have lunch for that day.
– another drop down list will have the option of oevrtime yes or no. if yes is selected a box will appear asking them to enter the start time and finish time of the overtime hours

once all the information is entered a box will shown the number of hours worked in the day as follows:

finish time – start time. If lunch is selected as yes it will be (finish time – start time) – 1 which is 1 hour for lunch

if overtime is selected as yes the number of hours of overtime will be added to the number of hours worked after deducting lunch time.
so after all that the number of hours is displayed.

then they have a button that says add time sheet details.

if the pick the option to view time sheets, it will list all the timesheets entered by the logged in user only and give them the ability to edit it and the save it.

also in view time sheets it will display the timesheets in order from the last created to the first created and displays the sheet number and the employee name and the start time and date and the finishtime and date and the hours worked per each sheet

in the administrator view: admin can see all jobsheets, edit or delete any timesheet. Also the admin can search for each employee between set dates and the ability to manage users: create delete and edit.

Once you have the applicationt that i currently have it will be clear that the chnages i have asked for are not hard and should not take long to do.

Any further explaination can be asked for once the bid is accepted.

1. Overtime and penalty shots
A hockey game usually never ends in a draw. So we need to extend the calculation for overtime and penalty shots.
Overtime is another 5 minutes of playing. If a team scores the game is over and the team which scored has one.
When there is no score in overtime, they go to shootout. Each team has to select three players for a shootout. If one team scored more after the three, it wins. If it is a draw, each team shoots one more time. If one team scores and the other does not, the team with the goal won. If none scored or both scored it continues 1 one 1 until one team wins.

So we need to add the penalty shooters to the lineup.

I think we can use the same variables for the shootout that we have for the games.

The shooter has the following options.

Score
Miss
Saved by goalie

2. Ticket price
The user needs to be able to set the ticket prices for his seats and stands. This should be possible for all games at once or individually depending on the preference of the User.

3. Calculate the attendance per game
For this we need to create a formula.

Strength home team * Strenght away team * Ranking home team * Ranking away team * Ticket price / Factor

For this we need something on the backend to give points to the ranking and strength and ticket price.
I have attached an Excel sheet to show you what I mean.

So in the backend I want to be able to change the values of the points.
I also want to be able to change the value of the price ranges and strength ranges.
BUT this option needs to be closed once a season has had the first game day so it is fix for a whole season.
I also need to be able to change the factor so that the number is calculated correct.

This formula needs to be in there twice so that once the attendance in the stands and once in the seats is calculated.