Đã Đóng

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.

Kỹ năng: Xử lí dữ liệu, HTML, MySQL, PHP, Kiến trúc phần mềm

Xem thêm: sheets jobs, php to excel export, php codeigniter jobs, o jobs, lamp jobs, jobs that use excel, jobs of the future, jobs in import export, jobs in editing, jobs in data, in house jobs, house keeping jobs, data stage 8.1, codeigniter jobs, auto jobs, php simple time sheet, time sheet mysql, styling jobs, import export jobs, php development framework, codeigniter future, william, time table, time sheet, simple csv

Về Bên Thuê:
( 10 nhận xét ) Pretoria, South Africa

Mã Dự Án: #1731527

17 freelancer đang chào giá trung bình $143 cho công việc này

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 Thêm

$360 USD trong 12 ngày
(173 Đánh Giá)
8.9
toinnisfree

pls chk pmb

$135 USD trong 3 ngày
(797 Đánh Giá)
8.3
gopalvora

Hi Ready to start Thanks

$150 USD trong 7 ngày
(450 Đánh Giá)
8.2
neoconcepts

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

$150 USD trong 3 ngày
(155 Đánh Giá)
7.5
humashahid80

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

$150 USD trong 5 ngày
(92 Đánh Giá)
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 Thêm

$250 USD trong 10 ngày
(73 Đánh Giá)
7.6
stdhtelkom

Hello, I can help you. Thanks, Steve

$100 USD trong 2 ngày
(34 Đánh Giá)
6.1
nobelsolution

Hi, Please check PMB for more details.

$150 USD trong 2 ngày
(12 Đánh Giá)
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 trong 2 ngày
(2 Đánh Giá)
3.0
sridevi84

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

$40 USD trong 5 ngày
(1 Đánh Giá)
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 Thêm

$80 USD trong 4 ngày
(1 Đánh Giá)
1.8
joyji

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

$165 USD trong 3 ngày
(0 Đánh Giá)
0.0
GabrielNegut

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

$40 USD trong 5 ngày
(0 Đánh Giá)
0.0
OP1Dv8bR2

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

$250 USD trong 1 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
0.0
tjumlani

Can be done in less than 6 hours.

$100 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$110 USD trong 2 ngày
(0 Đánh Giá)
0.0