Käynnissä

Simple Jog Logging / Time Sheet Database

I need a simple job logging / time tracking database. This will be used for an IT service provider that needs to record how much time is spent at a customers site. At the moment the data is collected in Excel and each technician populates the spreadsheet. there are 7 columns of data that is collected (JobID, Date, Hours, Client, Job Description, Technician, Type). Find below a description of each column

JobID - Unique Job Identifier

Date - Date the job was completed

Hours - How many hours in total were spent

Client - Drop down list of which client logged the job

Job Description - A description of what was done on the job

Technician - which technician performed the job

Type - Was the job standard rate, double time, time & half or No Charge.

We would like to make this a PHP application so our technician can update this while they are out of the office.

We would like each Technician so have their own login and be able to assign users admin rights so they can delete jobs. So there should be a page to add/delete/edit technicians. There should be also a page to add/delete/edit clients.

All data should be able to be exported to PDF by a filer/report function and also exported to CSV.

We like the current Excel Spreadsheet format as you are able to easily tab across and add each column with ease as well as you can see all the jobs previously done.

I am happy to supply the current Excel spreadsheet we are using on request.

Please find attached the Excel spreadsheet we are currently using to record our jobs. The data in the spreadsheet is sample data and it also using Excel's condition formatting to color code the type.

There is another sheet within the workbook called 'client template'. at the end of the month, the timesheet is sorted per client by Excel's inbuilt filters, and then it is copied to the client template and exported to PDF to be emailed to the client.

Taidot: AJAX, HTML, MySQL, PHP

Näytä lisää: total jobs login, technicians jobs, technician jobs in, technician jobs, service technician jobs, service technician, logging jobs, job technician, jobs using excel, jobs technician, jobs in an office, job for a c technician, job description it technician, job description for it technician, it technician job description, i need a technician, how to find technicians, find technicians, find technician, column jobs, what type of jobs are there, what are service jobs, how to add time, customers service jobs, need technicians

About the Employer:
( 2 reviews ) Fyshwick, Australia

Projektin tunnus: #1709943

Myönnetty käyttäjälle:

canlan318

Dear sir. I sent you a private message. Please check it. Regards.

750 $ AUD 10 päivässä
(77 arvostelua)
6.9

11 freelanceria on tarjonnut keskimäärin 981 $ tähän työhön

humashahid80

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

1200 $ AUD 30 päivässä
(63 arvostelua)
7.0
KRodri

Hello We can finish this website in the fixed time After we discuss more details we will provide detailed plans how to tackle this I want to see sample spreadsheet Thanks

800 $ AUD 20 päivässä
(35 arvostelua)
5.5
diamond1027

Hi, I am ready to start now. I have rich experiences on developing website. Best regards.

750 $ AUD 7 päivässä
(24 arvostelua)
4.4
freelancer0101

Please check my message for further details thanks

790 $ AUD 15 päivässä
(11 arvostelua)
4.4
desigmbooms

Experts here please check pmb for more details. Thanks

800 $ AUD 25 päivässä
(8 arvostelua)
4.4
nupurconsagous

"HELLO EXPERTS R HERE" We will give you a complete satisfaction and professional solution as per client requirement....we have expertise and skilled programmers

1500 $ AUD 25 päivässä
(3 arvostelua)
3.7
moovmoov1

can do it for you.

750 $ AUD 4 päivässä
(6 arvostelua)
3.5
mpuskaric

Hello: I've done similar apps in the past many times. I have good experience with generating both pdf end excel files on the fly (if needed for reporting etc.) I will also include a specially optimized version of Lisää

750 $ AUD 7 päivässä
(4 arvostelua)
3.3
blackhorse881

hello sir, i fully understood your requirement you basically need:- 1 Login system 2 Database system and its frontend to manage and edit entries 3 export the required data in the form on PDF file if any thing Lisää

750 $ AUD 15 päivässä
(0 arvostelua)
0.0
UU6mFWi78

Custom software development - <b><i>Removed by Admin</i></b>

1500 $ AUD 1 päivässä
(0 arvostelua)
0.0
tbldevelopment

We are providing this service so affordable because we want to prove our expertise, build a longterm relationship so when you have other IT needs, and substantiate a Freelance record of good customer relations. To dis Lisää

1200 $ AUD 14 päivässä
(1 arvostelu)
0.0