Get a Freelance Job

I am seeking an experienced PHP programmer availabile IMMEDIATELY to test and complete small a php based timesheet system. The system is 80% complete and requires approx 5-6hrs to finish based on programming time so far.

Current Situation: The current tool has two main interfaces:

A) an input form to allow user to enter staff working times. This seems to be working fine.

B) A report form that allows user to create a simple downloadable report.

All the design layout inputs and form s…

I need a simple SharePoint application. Basically it will function as a time sheet for employees. The employee will enter in the amount of time they worked on a particular day, along with a few other fields such as type of work etc. and then click save. The data will then need to be approved by a supervisor. The supervisor will approve the time the employee worked by entering a PIN number or something similar. All records must be stored in the database.

We are looking for an online tool where our remote staff can logon each week and submit the hours worked without having to send us timesheets – in addition we need to be able to have a system whereby they can enter the number of items used by a customer each week so we can bill the customer accordingly. I would need to be able to add, remove and edit employees, customers, products and then allow employees to enter their daily hours once a week and the consumables usage for each product per client each week.

I think it would look something like this:

** Add, edit, view and remove employees
Employee surname
Employee first name
Employee number
Nat Ins Number
DOB
Home Address
Post code
Telephone number
Email address
Job title
Start date
Contract employed on (drop down from contracts)
Password

** Add, edit, view and remove contracts
Contract ID
Company name
Company address
Company post code
Company telephone
Contact name
Start date
Consumables (yes/no)

** Employee timesheet
Employees should be able to view their old timesheets or add a new time sheet ONLY – admin should also be able to edit and delete timesheets for any employee
Employee ID (for employee it should be auto populated based on their login)
Contract ID – auto populated from their login
Date and time of adding timesheet
IP address used
Week number (from drop down – 1 to 52)
For each day start time and end time
Tick box to confirm acceptance of T&C

** Consumables
Add, edit, view and delete consumables
Consumable ID
Description
Unit cost price
Unit sell price
Supplier

** Consumables usage
From drop down choose contract ID
Admin should create the consumable instance by adding consumables to the contract and for each consumable enter a date, a free text line entry and a qty in stock
Employees or admin should then on an ongoing basis be able to add or remove stock by entering a date, free text line and new qty in stock

** Admin reports
List all employees with details
List all contracts with details
List all consumables with details
From a dropdown of employee numbers and week numbers show timesheet (admin should be able to view a timesheet for one employee or all employees for one week or for all weeks)
From a dropdown of contract numbers and week numbers show consumables usage report (should be able to view for one or all consumables between given dates)

Simple cell coding. Takes about 30 min or less. The main project is about adding double-shifts work hours expanding over 24 hrs and also checking for special weekend hrs that expanding over 24hrs, and listing them in fractions. Already finished manually written sample with detail comments is provided.

Simply adding date and hours. Takes about an hour or less for an MS Office expert.The main project is about calculating and adding up the total hours worked in three different shifts. User only needs to inter start and end time and the rest of the cells should populate automatically. Two of the shifts have special hours that need to be separated into their own cell. And the 48 hours that make up the weekend would need their cell too. Already finished, manually written sample with detailed comments is provided.

Simple cell coding. Takes about 30 min or less. The main project is about adding double-shifts work hours expanding over 24 hrs and also checking for special weekend hrs that expanding over 24hrs, and listing them in fractions. Already finished manually written sample with detail comments is provided.

REQUEST #1
I need an excel macro with coding that shows me each punch in and punch out for an employee and totals the amount of hours and minutes that the employee has worked for the day.
I’ll try to break the current process I use into separate steps, so that you can more easily follow the logic and create the code.

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.