Custom online database for expenses and time tracking.

Encerrado Postado há 6 anos Pago na entrega
Encerrado Pago na entrega

Custom online database for expenses and time tracking for a very small company.

We want to have a database where time and expenses are entered by employees and the administrator can create reports and extract data.

The source code must be delivered, as we want to ensure no connection to a third-party server is attempted in order to keep the privacy of the data.

The user interface must be a webpage and the database to be hosted on our server.

The employee logs in using a username and password.

In the time logging page, the employee enters tasks that contains : date ; short text description ; internal project number (string) ; client project number (string) ; type of work (field / office) ; amount of time worked (in hours if office, in days if field) ; amount of food allowance claimed ($) ; state/province in which the worked was performed. This page is a listing of all time logged so far and can be filtered for a specific date range, per project (internal or client), and/or per type of work or a combination of all.

In the expense page, the employees enters expenses that contains : date ; category (from a drop-down list) ; item (string) ; amount ; tip amount ; taxes (2 types) ; total paid ; project number. Then the employee uploads a picture of the expense limited to 1MB. The sum of amount + tip + taxes must be equal to total paid. This page is a listing of all expenses logged so far and can be filtered for a specific date range, per project, and/or per category or a combination of all.

The administrator logs in using a username and password.

The administrator can create a daily, weekly or monthly report of time spent on a project in the previous month, total time logged filtered by employee, project, etc. and save this to a .CSV format or Excel format, and in a PDF.

The administrator can create a CSV/EXCEL/PDF report listing all expenses, by filtering by employee name, date range, project number. For example, the administrator can create a PDF report of expenses of employee #1, assigned to project #2 during the "Current Month" or "Previous Month" or "From 2017xxxx to 2017yyyy" and in this PDF, on each page, one expense will be shown with all of its information and the uploaded picture.

The employees only have access to their own entries but are allowed to get a sum of amount, tip amount, taxes and total paid filtered by date period and project. The employees can edit their entries. In a similar way the employees can get a report of time logged and food allowance paid filtered by date period and project.

The administrator can get a sum of amount, tip amount, taxes and total paid filtered by employee, date period and project.

The administrator has access to an employee list and can add/remove users.

During the development of the project, the freelancer is to provide us a draft of the work in progress online so we can provide comments as it goes.

Programação de Banco de Dados MySQL PHP Arquitetura de software SQL

ID do Projeto: #15898870

Sobre o projeto

18 propostas Projeto remoto Ativo em há 6 anos

18 freelancers estão ofertando em média $14531 nesse trabalho

JinNg

Bloody Indian scammers! Relevant Skills and Experience Bloody Indian scammers! Proposed Milestones $250000 AUD - Bloody Indian scammers! I have reported you repeating this project at a higher quote.

$250000 AUD in 3 dias
(30 Comentários)
6.4
parveen2505

I am a web application development expert having an experience of 4 years .This is easy task for me can deliver the work on time with accuracy .

$238 AUD in 15 dias
(56 Comentários)
4.7
RobertRajC

A proposal has not yet been provided

$55 AUD in 5 dias
(1 Comentário)
1.8
ShivaTek

Thank you for the detailed requirements provided. As per our understanding and estimation, we will be able to complete the project in 3 days with a budget of 250 AUD. Relevant Skills and Experience Our team has experi Mais

$250 AUD in 3 dias
(0 Comentários)
0.0
manue1q

Hello! I would like help you in your project Thank you! Relevant Skills and Experience I have develop a web page to my university in php and mysql Proposed Milestones $155 AUD - Web

$155 AUD in 10 dias
(0 Comentários)
0.0