Simple time tracking frontend with optional JIRA synchronisation
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
app
ci
doc
sql
src
web
.dockerignore
.editorconfig
.gitignore
ChangeLog
Dockerfile
LICENSE
README.rst
build.xml
composer.json
composer.lock
docker-compose.override.yml
docker-compose.yml
nginx-conf.d-default.conf
phpcs.xml

README.rst

doc/netresearch.jpg


Netresearch TimeTracker

Project and customer based time tracking for company employees.

Features:

  • Time tracking with autocompletion
    • Bulk entry for sickness or vacation
  • Per-user, pre-project and company wide charts
  • Administration interface for customers, projects, users and teams
  • CSV export for controlling tasks
  • LDAP authentication
  • JIRA integration: Creates and updates worklog entries in issues

1   Usage

1.1   Add worklog entry

Click the button Add Entry. Use the keyboard shortcut a.

1.2   Edit worklog entry

Just click inside any field of any existing worklog entry.

1.3   Delete worklog entry

Rightclick on an worklog entry and select Delete from context menu. Use keyboard shortcut d to delete focused worklog entry.

1.4   Focus

Worklog entry with focus has a yellow background. Move the focus with keyboard up and down keys.

1.5   User roles

DEV (Developer)
is allowed to track times, do bulk entries (if presets where created) and view bar charts in the Interpretation tab
CTL (Controller)
Includes the role DEV and is additionally able export data to csv in the Controlling tab
PL (Project leader)
Includes the role CTL and is additionally able manage customers, projects, user, teams, presets, ticket systems and activities in Administration tab

2   Installation and set up

2.1   Requirements

  • PHP 5.6+
  • MySQL database
  • composer
  • libraries listed in composer.json

2.2   Setup - manual from from sources

  1. Fetch a local copy:

    $ git clone git@github.com:netresearch/timetracker.git
    
  2. Create a MySQL database and import sql/schema.sql into it

  3. Install dependencies:

    $ composer install
    

    It will ask you for some configuration options. If you want to adjust that later, edit app/config/parameters.yml

  4. Make cache and log directory writable:

    $ chmod -R og+w app/cache/ app/logs/
    
  5. Copy web/.htaccess_dev to web/.htaccess.

    On nginx, symlink web/app_dev.php or web/app.php to web/index.php.

  6. Create a virtual host web server entry pointing to /path/to/timetracker/web/

  7. Open the timetracker URL in your browser. If you see a white page, run:

    $ php app/console assets:install
    
  8. Login with your LDAP credentials

2.3   Setup - with prebuilt docker images

  1. Create an empty folder
  2. Put the provided docker-composer.yml from this git repo in it
  3. Put the provided nginx configuration file from this repo into the above created folder
  4. Put the provided app/config/parameters.yml.dist from this repo as paramters.yml into the above created folder
  5. Check and adapt the copied confoguration files to your needs
  6. Run docker-compose up -d

2.4   Trusted proxies

To work behind a proxy Symfony needs to know which proxies are allowed to trust.

There are two ENV variables which can be set to modify the proxy behavior of the app:

TRUSTED_PROXY_LIST

The variable expects a valid JSON encoded list of IPs or IP ranges:

TRUSTED_PROXY_LIST=["192.0.0.1","10.0.0.0\/8"]
TRUSTED_PROXY_ALL

The variable expects a boolean 1/0 to indicate if the application should handle each address in $_SERVER[REMOTE_ADDR] as a trusted proxy:

TRUSTED_PROXY_ALL=1

3   Configuration

3.1   Using OAuth to transmit work logs to Jira ticket system

  1. Configure your Jira ticket system
  2. Example for Jira 7
    • Create a SSH key pair with private and public pem file
    • Open "Application links" page in your Jira: https://jira.example.com/plugins/servlet/applinks/listApplicationLinks
    • "Create new link" with URL pointing to your TimeTracker installation
    • Just click "Continue" if Jira is blaming "no response"
    • Fill out the following form:
      • Application Name:
        timetracker (or chose any other name you like)
      • Application Type:
        Generic Application
      • Ignore the rest and hit "Continue"
    • After new Application is created click on action "edit" (the little pencil at the right to your new application)
      • Select "Incoming Authentication"
      • Consumer Key:
        timetracker (or chose any other name you like)
      • Consumer Name:
        TimeTracker (or chose any other name you like)
      • Public Key:
        Insert here the public key you created above
      • Click on "Save"
  3. Create a ticket system in TimeTracker
    • Set the type to Jira
    • Check the field timebooking
    • Enter the Base-URL to your Jira ticket system
    • The ticket URL is used for referencing ticket names to Jira "%s" serves is a placeholder for the ticket name in the URL (your URL might look as the following: https://jira.example.com/browse/%s)
    • The fields login, password, public and private key can be left empty
    • Enter the OAuth consumer key you already entered in Jira
    • Enter your private key you created above into OAuth consumer secret field
  4. Assign this ticket system to at least one project
  5. Start time tracking to this project
    • The TimeTracker checks if a valid Jira access token is available
    • If this is missing or incorrect the user is going to be forwarded to the Jira ticket system, which asks for the permission to grant read / write access to the TimeTracker.
    • If permitting, the user will receive an access token from Jira.
    • If not, he won't be asked for permission again.
    • With a valid access token the TimeTracker will add / edit a Jira work log for each entry with a valid ticket name.
    • The permission can be revoked by each user in its settings section in Jira.

3.2   Automatically create TimeTracker user on valid LDAP authentication

Per default every TimeTracker user has to be created manually. While setting ldap_create_user in app/config/parameters.yml to true new users of type DEV are going to be created automatically on a valid LDAP authentication. The type can be changed afterwards via the users panel in the administration tab or directly in the database.

3.3   Track time for external ticket systems to internal ticket system

Sometimes you not only want to track the times for the tickets from your ticket system. Assuming that you have a client providing an own ticket system, but you want to track the times for work on this tickets into your ticket system.

Example:

  • Your client provides tickets to your team via an own ticker system
  • The ticket numbers may be EXTERNAL-1, EXTERNAL-200 etc.
  • You share the information regarding the progress of the ticket in the clients ticket system
  • But you want to track the working time in your internal ticket system instance
  • Normally you would need to create a ticket in your ticket system e.g. name INTERNAL-1
  • You then would be able to book you efforts to INTERNAL-1 via Timetracker
  • That's quite ineffective because you always need to create an internal ticket

This feature tries to solve that problem.

  1. Create a project in Jira where the external times should be applied to

    1. Create a Jira project the Timetracker user has access to
    2. Ensure that the project provides the issue type task
    3. Let's assume it is named Customer Project with the key INTERNAL
  2. Create the clients ticket system in TimeTracker

    1. Go to Administration > Ticket-Sytem and create a new one:

      Name:

      e.g. Customer ticket system

      Type:

      Jira or Other or what you like

      The type does not effect this feature in any way

      URL:

      e.g. https://ticketing.customer.org/%s

      This is used to generate links in the work log description

      Timebooking:

      No

      This disables any contact to external ticket system

    2. Save the entry

  3. Create the external project in TimeTracker

    1. Go to Administration > Projects and create a new one:

      Name:

      set to e.g. Customer Project

      Ticket-System:

      Select the above created Customer ticket system

      Ticket-Prefix:

      Enter the prefix of your customers project tickets e.g. EXTERNAL if the tickets are in the form EXTERNAL-123

      Active:

      Yes

      "Internal Jira project key":

      select INTERNAL

      "Internal Jira ticket system":

      select your internal ticket system

If everything is correct, the following will happen:

  • If you are booking some working time to e.g. EXTERNAL-1 in TimeTracker for project Customer Project
  • TimeTracker will reach out for the configured internal Jira instance
  • It will search for an issue which name starts with EXTERNAL-1 in the configured internal Jira project
  • If it finds an entry, the work log is applied to this entry
  • If it does not find an entry, TimeTracker will create a new internal ticket with name EXTERNAL-1
  • The link to the ticket in customer Jira will be applied as ticket description
  • The work log is applied to the newly created ticket