Macrotone Timesheet User's Guide

Geoffrey S. Chapman

Macrotone Consulting Ltd

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license can be found on-line at http://www.gnu.org/licenses/fdl.html.

March 2016

Revision History
Revision 1.0.3May 2016 Geoffrey S. Chapman

Abstract

This book covers the use of the Macrotone Timesheet component which allows you to easily create employee timesheets on your Joomla!™-powered web sites.


Table of Contents

Preface
I. User's Guide
1. Introduction and installation
Introducing Macrotone Timesheet
Requirements and compatibility
Installation
Installation
Updating to the latest release
Uninstallation
Credits
2. Initial set-up and usage
Parameter Settings
Back End Screens
Dashboard
Users
Logging
Support
Timecodes
Timesheets
Front End Screens
Timesheets view
Timesheet view
Timesheet edit
Timecodes
Individual Timecode display
Print output
Modules and Plugins
3. Version Changes
Release Versions
Timesheet 1.0.3
Timesheet 1.0.2
Timesheet 1.0.1
Timesheet 1.0.0
II. Advanced Configuration
4. Print Configuration
Methods of modifying print output
HTML Boxes
Standard Joomla method
Modifying the print output.
Add logo to Joomla print popup
Change size of print popup window
III. Design
5. Design Criteria
Planning and Analysis
Planning and Project Analysis
Gather the Necessary Data
Define Security Requirements
Select Data Management Functions
Select Data Presentation Functions
Define Special Function Requirements
Handling of date fields.
Cron tasks
Multi-Lingual support
6. Database Design
Designing the Database Objects
Database Objects - Procedures, Views, Triggers
Database Triggers
Database Routines (Procedures)
Database Views
Data Model
Timecodes Table
Users Table
Timesheet Table
Timesheet Log Table
Implementing Database Objects
Additional Database Objects Needed
About Building Database Objects
Default Base Data
7. HTML Table grid
jqGrid language files
8. CSS Styling
Back End styling
9. Helper Classes
General Helper
Logging Helper
IV. Appendices
A. GNU General Public License version 3
B. GNU Free Documentation License
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries