Suljettu

Simple PHP time sheet from MySQL Data

Output a CSV or HTML page (selectable) in the format of the attached excel spreadsheet from a mysql table or ASCII file in the format of the data displayed below. The data below is exported in ASCII format from a fingerprint punch clock and then manually imported into the mysql database:

"1" "10213" "Sbusiso Ngcobo" "2000-01-01 00:00:00" "Fingerpint" "MainDoor" "O" "2" "0" "2000/01/01"

"2" "10213" "Sbusiso Ngcobo" "2000-01-01 00:06:00" "Fingerpint" "MainDoor" "I" "2" "0" "2000/01/01"

"3" "104" "Joshua William" "2012-05-16 06:32:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"4" "78" "Dwayne van Krakenburg" "2012-05-16 06:42:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"5" "215" "Chris Noel" "2012-05-16 06:44:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"6" "237" "Craig Stieger" "2012-05-16 06:46:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"7" "79" "Herman Abrahams" "2012-05-16 06:50:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"8" "10215" "test user" "2012-05-16 10:15:00" "Fingerpint" "MainDoor" "I" "2" "0" "2012/05/16"

"9" "10215" "test user" "2000-01-01 00:02:00" "Fingerpint" "MainDoor" "I" "2" "0" "2000/01/01"

"10" "10215" "test user" "2000-01-01 00:03:00" "Fingerpint" "MainDoor" "I" "2" "0" "2000/01/01"

Attached is a screen shot of the options the user needs. On submit, the HTML time sheet is displayed with an export to CSV button.

Calculations for time sheet are:

Normal Time

Overtime

Downtime

You do not need to do any styling or template, we will be doing all of that in house. All we need is plain HTML and PHP.

You can use any framework CakePHP, CodeIgniter etc. as long as it runs on a basic LAMP server.

The system will be expanded at a later stage, so possibly more jobs in the future.

Later development will include:

Auto Import of data from ASCII file.

Per project time keeping with data from existing system.

Editing and storing time sheets.

Taidot: tietojenkäsittely, HTML, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: sheets jobs, php codeigniter jobs, o jobs, lamp jobs, jobs use excel, jobs import export, house jobs, house keeping jobs, codeigniter jobs, auto jobs, php simple time sheet, time sheet mysql, styling jobs, php development framework, codeigniter future, william, time table, time sheet, simple csv, sheet, punch, php cakephp, noel, joshua, future house

About the Employer:
( 10 reviews ) Pretoria, South Africa

Projektin tunnus: #1731527

17 freelanceria on tarjonnut keskimäärin 143 $ tähän työhön

Webwingtechology

Dear Sir, Webwingtechnologies Software offers a wide range IT Services. We have over 23 programmers, all experts in their various respective programming disciplines plus a team of project and sales managers. Webwing Lisää

360 $ USD 12 päivässä
(173 arvostelua)
8.9
toinnisfree

pls chk pmb

135 $ USD 3 päivässä
(797 arvostelua)
8.3
gopalvora

Hi Ready to start Thanks

150 $ USD 7 päivässä
(450 arvostelua)
8.2
neoconcepts

i'm interested in this project. i have done similar project recently i can do in codeigniter framework

150 $ USD 3 päivässä
(155 arvostelua)
7.5
humashahid80

Hi, Immediately ready for your work, please check PMB for details.

150 $ USD 5 päivässä
(92 arvostelua)
7.5
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lisää

250 $ USD 10 päivässä
(73 arvostelua)
7.6
stdhtelkom

Hello, I can help you. Thanks, Steve

100 $ USD 2 päivässä
(34 arvostelua)
6.1
nobelsolution

Hi, Please check PMB for more details.

150 $ USD 2 päivässä
(12 arvostelua)
4.2
zalaman

This is a simple task. I can do the import as you wish and my choice will be CideIgniter, if thats fine with you, or plain PHP, if you want it like this.

100 $ USD 2 päivässä
(2 arvostelua)
3.0
sridevi84

Hi I've done such tasks before. Please consider my bid. I assure good work - php expert

40 $ USD 5 päivässä
(1 arvostelu)
2.3
JimMackin

Hi, I'm a skilled PHP programmer and interested in your project. I'd just like to clarify a few things. I can't see the attachments but presumably the page uses the comings and goings in the provided data to work out Lisää

80 $ USD 4 päivässä
(1 arvostelu)
1.8
joyji

Hey, We have expert team regarding to your project. Please check PMB for detail bid !!! Thanks.

165 $ USD 3 päivässä
(0 arvostelua)
0.0
GabrielNegut

Hello. Your project will be completed on time and on budget. Thanks.

40 $ USD 5 päivässä
(0 arvostelua)
0.0
OP1Dv8bR2

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

250 $ USD 1 päivässä
(0 arvostelua)
0.0
nevans77

Hello, I have over 12 years experience and done many projects with MySQL/PHP/HTML/Javascript/C++. I hope you accept my bid and have more work for me in future. Thank you

100 $ USD 2 päivässä
(0 arvostelua)
0.0
tjumlani

Can be done in less than 6 hours.

100 $ USD 1 päivässä
(0 arvostelua)
0.0
eepyaj

I've looked at the details of the project, and it seems simple enough. If I'm understanding correctly, you simply want something that will export your data from your database with some minor transformations (calculate Lisää

110 $ USD 2 päivässä
(0 arvostelua)
0.0