Build a small online database that communicates with TSheets

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

We are a 5 employee manufacturing business that is looking to improve our time/project tracking system. Currently we use a Microsoft Access program. We would like to integrate [login to view URL] for a better payroll system, and then build a new database online.

The database would pull the hours worked out of TSheets. The database would update the Job list so TSheet employees could only clock in to Jobs that were not closed.

The database would be based on Jobs, grouped together by Projects.

I don't know a lot about databases so I will explain the project in a way I think is best but feel free to change the layout if you think that would make more sense.

There would be a Jobs table. Job(unique); Project; DueDate; Status; Jobdescription

Project table. Project(unique); Customer; Projectdescription; Projectduedate

Customer table. Customer(unique); ??

Table to contain time info retrieved from TSheets. Employee; Date; ClockIn; ClockOut; Job; Description; Hours(calculated field?)

UI

We would like 1 view showing Jobs, sorted by status, with the total hours and an editable status.

1 view showing Projects. Projects that have 1 or more uncompleted Jobs would at the top of the list. Clicking on the Project would show a pop up with all associated Jobs.

1 view showing data retrieved from TSheets.

TSheets API: [login to view URL]

Programování databází PHP SQL

Identifikační číslo projektu: #16641795

O projektu

24 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

WebInfoSolutions

How will user roles will use this application? I saw there are 5 employees, I am assuming this will be used for internal purpose only?

$833 CAD za 10 dní
(254 recenzí)
7.9

24 Freelnceři na tento projekt zveřejňují nabídky v průměru $1440

tojisb059

hello, how are you? I am a skilled website developer and I have worked on the similar projects, I can do this job on time with some great results. let's have a chat session to discuss details. thank you

$988 CAD za 20 dní
(581 Recenzí)
9.2
augurstech

Dear Employer Hope you are doing well Coming to your project scope we will develop your database which will pull the hours worked out of Tsheets that will be based on jobs grouped together by projects. Ping us via Další

$1058 CAD za 20 dní
(227 Recenzí)
9.3
hiretechexperts

Hello, I Have gone through the project description provided , but need to ask few points. So please click Chat button to send me a text message when you have time to discuss. At present I am placing a placeholder bid Další

$1250 CAD za 10 dní
(77 Recenzí)
8.3
asifchaudhry2015

Hi there, I am Senior PHP Developer. I checked TSheets API and I am really confident to do this project for you as per your posted requirement. I have a great experience. Let's discuss with me. Thanks

$1500 CAD za 30 dní
(264 Recenzí)
8.5
dotcomdotbd

Hello, PHP expert here. I've just checked the API doc. Its a RESTFull API, also they have git repo. So it won't be a problem get the data. Please lets discuss more detail. Thanks

$1558 CAD za 30 dní
(86 Recenzí)
7.5
xiqian88

Hello sir I read your proposal and i am interested in your project I have rich experience in Ruby on Rails and Angularjs,Laravel,ASP.NET I am sure i can satisfy you in time Regards.

$1000 CAD za 15 dní
(39 Recenzí)
7.1
zhangyingtai

Dear sir I am interested in this project and can do it. I am familiar with tsheets api and I have done a similar project. I am ready to work for you. Looking forward to hearing from you soon. Best Regards, Další

$1529 CAD za 20 dní
(52 Recenzí)
6.9
gr8tech

Hello there, I will provide integration between your application and Tsheets through the provided API. On the database side, I can use Access or a PHP/MySQL/MariaDB for the online database. I have gone through your pro Další

$823 CAD za 20 dní
(30 Recenzí)
5.3
WebStar426

Hi, thank you for looking at my cover letter. I’ve carefully gone through your job posting. I can work with you anytime you want. I believe I possess the necessary skills and experience you are seeking. I look for Další

$1111 CAD za 20 dní
(6 Recenzí)
3.0
VirtualBrainInc

Hello, I have briefly read the description on online database development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.

$2000 CAD za 20 dní
(6 Recenzí)
3.0
gsoftwareinc

Hi, Thank you for posting the project. We will love working with you, it is nice when you found a client that knows what he wants! Nice specs. I think that my company it is a perfect fit for this project. You wi Další

$750 CAD za 7 dní
(6 Recenzí)
2.3