Skip to content
Anders Revsgaard edited this page Dec 30, 2018 · 8 revisions

Sortingtime is a time tracking system which support tracking time spent on tasks, send time reports, and send invoices.

Sortingtime is available online and as open source.

Architecture

Sortingtime is build to be hosted in a Azure app service. Sortingtime contain a frontend web application and a backend web job. Both are hosted in the same app service. Data is mainly persists in an SQL database. Generated PDF reports and invoices are persisted in a blob storage. The frontend web application communicate with the backend web job using a query.

SQL Database

Image

Partitions

Data is separated into partitions. When a user sign up a partition and organisation is created for the user. The user can subsequently create more users which then are connected to the same partition and organisation. Users connected to a partition share data and settings.

Groups

Task and material data is connected to a group. A group is the user's / organisation's customer. The grouping is called customer in the Sortigtime user interface.

Tasks

A task is an assignment and time is registered per day as a task item.

Materials

Currently not implemented. Materials should contain materials used and and related material price resolving a task at at customer. The material price should become a part of the subsequently invoice.

Reports

Reports are reports of the time spent on different tasks by the users.

Invoices

Invoices are the time spent on different tasks by the users multiplied by the price.

Clone this wiki locally