Sillaj

Sillaj is a PHP time tracking tool. It allows to register time on projects and tasks and create various reports and Gantt graphs. Sillaj is multiuser and multilanguage, uses a database backend and is themable through templates.

Sillaj makes extensive use of the following libraries (thanks to the authors !) :

• PEAR
• Smarty
• PHPMailer
• JpGraph
• Calendar Popup

Sillaj is distributed under the GPL.

Sillaj can be downloaded from http://sillaj.sourceforge.net/

Created by Michaël Delorme - sillaj@gmail.com
Thanks to janson.peter/@gmail.com for the swedish translation, to lmoehri/@gwdg.de for the german translation and bert.fransen/@sygma.nl for the dutch translation

See changes.txt for version notes.

Required

• Webserver - e.g. Apache
• PHP 4.x or 5.x
• PEAR (core), PEAR::DB and PEAR::Calendar (included)
• Any database (?) - Tested with MySQL 4.1+ or 5.x
• Browser : Gecko-based (Firefox 1+), Opera 8+ or Internet Explorer 5+
  -> use of xmlHttpRequest()

Installation

1. Copy the sillaj directory somewhere below your web root directory
2. Make sure you have a PEAR directory in your PHP directory and check that this PEAR directory is declared in the include_dir directive of php.ini). e.g. :
   

   include_path = ".;c:\php\includes;c:\php\pear;"

3. copy the content of /lib/pear/ in your PEAR directory if necessary
4. create the database

   $ mysqladmin -u root -p create sillaj

5. use the SQL script (in /sql/) to create the tables

   $ mysql -u root -p sillaj < sql/mysql.sql

6. create a database user (who must have the rights to create temporary tables)

   $ mysql -u root -p sillaj
   $mysql> GRANT ALL ON sillaj.* to 'sillaj'@'localhost' IDENTIFIED BY 'sillaj';

7. Modify /inc/config.php
   • Connection parameters according to your database settings
   • Chose your default language (french, swedish, german, dutch or english) and date formats
   • If you want gantt graphs, set BOO_ENABLE_GRAPH_SILLAJ to true and enable GD (in your php.ini : uncomment extension=php_gd2.dll or gd.so)
8. check that the webserver can write in /templates/*/templates_c and in /cache/
   ex :

   $ chmod 777 templates/default/templates_c
   $ chmod 777 cache

9. Check that PHP sessions are enabled in php.ini (see PHP manual)
10. You can add a PHP accelerator
11. Go to http://server/sillaj/ ; you should get the login page, click on "Create an account", fill-in the required informations and start using Sillaj

It doesn't work !

See the Frequently Asked Questions or the forum.

Features

• Multiuser ; each user has its own projects/tasks. Users can see other people's reports (if allowed on site-wide basis and if the users allowed)
  People can share their tasks and projects, so a team can use the same parameters and build complete and accurate time reports.
• Reports by project or task. Full events listing for a project or a task.
• Gantt charts for projects and tasks
• Can hide some projects or tasks in reports (ex : vacations)
• XHTML 1.0 compliant + CSS3. Accessibility checked.
• Templates driven. Create easily your templates with Smarty tags (or just a CSS) !
• Multilanguage capable (english by default ; dutch, french, german and swedish translations available). Dates are localized too.
• Atom and RSS feeds available for any user
• Optimized PHP code (and Smarty cache where applicable). OOP.
• Can export reports to a spreadsheet
• Allow specific tasks for a project. Only these tasks are shown when inputting an event
  (xmlhttprequest)
• Search engine (Opensearch compatibility)
• Password reminder
• Automatic duration calculation if only start and end time are input
• Time can be entered as hh-mm-ss hh:mm:ss hh,mm,ss hh;mm;ss or "hh mm ss" (with or without seconds)
• Passwords stored encrypted in the database. Password not send in clear text (nonce based authentication)
• You can use Sillaj as a backend for an OSX widget thanks to Johan Ström. See Sillaj-Widget
• Free, libre

Adding translation

• Add a directory in /lang/ (according to ISO 639-1)
• Copy lang.php, lang.txt and lang.js from any other language directory
• Translate
• add in config.php in the array $arrLanguageNameLookup

Mail your files so I can add them to the source files

Adding templates

Copy the /templates/defaults directory to /templates/my_new_templates dir and modify as you like...

Mail your files so I can add them to the source files

Adding themes to a template

Just add a new css file in /templates/*/styles/
You must then use a browser that allows you to switch stylesheets to take full advantage of this feature

Note that default.css, print.css and calendar.css are mandatory.

Mail your files so I can add them to the source files

Miscellanous

Check the /doc/ directory for more information on the API