Build a small online database that communicates with TSheets

完了済み 投稿 6年前 着払い
完了済み 着払い

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]

データベースプログラミング PHP SQL

プロジェクトID: #16641795

プロジェクトについて

24個の提案 リモートプロジェクト アクティブ 6年前

アワード:

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 10日以内
(254レビュー)
7.9

24人のフリーランサーが、平均$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 20日以内
(581件のレビュー)
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 もっと

$1058 CAD 20日以内
(227件のレビュー)
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 もっと

$1250 CAD 10日以内
(77件のレビュー)
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 30日以内
(264件のレビュー)
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 30日以内
(86件のレビュー)
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 15日以内
(39件のレビュー)
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, もっと

$1529 CAD 20日以内
(52件のレビュー)
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 もっと

$823 CAD 20日以内
(30件のレビュー)
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 もっと

$1111 CAD 20日以内
(6件のレビュー)
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 20日以内
(6件のレビュー)
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 もっと

$750 CAD 7日以内
(6件のレビュー)
2.3