Macrotone Issue Tracker Design Guide
   Next

Macrotone Issue Tracker Design Guide

Geoffrey S. Chapman

Macrotone Consulting UK Ltd.

Copyright © 2012, - 2014 Macrotone Consulting Ltd, All rights reserved.

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.

November 2014

Revision History
Revision 1.6.5November 2014 Geoffrey S. Chapman

Abstract

This book covers the use of the Macrotone Issue Tracker component which allows you to control issues or problem reports on your Joomla!™-powered web sites.

Table of Contents

Preface
I. Macrotone Issue Tracker
1. Overview
2. Design
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
Pseudo-cron
Front-end access
UNIX System
Wget
Downloading GNU Wget
CURL command
Command Line Alternative
Securing the script
Cron Basics
Trouble shooting cron
Joomla Warning Messages
Automatic creation and update of issue via email.
Design Criteria
Implementation of email raise/update issues
New issue emails
Updates for existing issues.
Custom Fields
Possible implementations
Additional table fields
New custom tables
Progress History
Pactions View
Issue Reports
Report Export
Multi-Lingual support
Import/Export Facility
Alternative Alias identifiers
Ability to associate types with projects.
New Create Issue Button on List Views.
SMS Integration
Front End Download of Attachments
3. Database Design
Designing the Database Objects
Database Objects - Procedures, Views, Triggers
Database Triggers
Database Routines (Procedures)
Database Views
Data Model
Projects Table
People Table
Issues Table
Progress Table
Attachments Table
Priorities Table
Roles Table
Status Table
Issue Types Table
Email Types Table
Issue Log Table
Change History Table
Triggers Table
Custom Field Table
Custom Field Group Table
Meta Data Table
Implementing Database Objects
Additional Database Objects Needed
About Building Database Objects
Default Base Data
4. CSS Styling
Blue theme CSS styling
Alternative 'greenish' theme CSS styling
Spearmint flavoured style.
List Row colouring
Front End form
Back End styling
Bootstrap CSS
5. Helper Classes
General Helper
Logging Helper
Cron Helper
Date Helper
Database Triggers time
II. Appendices
A. GNU General Public License version 3
B. GNU Free Documentation License

List of Figures

2.1. Back End Pactions view
3.1. Data model for Issue Tracker 1.6
4.1. Item without fieldDiv styling.
4.2. Item with fieldDiv styling.
4.3. Blue theme css styling
4.4. Alternative theme styling
4.5. Spearmint theme styling
5.1. Log Entry Display

List of Tables

3.1. Projects table description
3.2. People table description
3.3. Issues table description
3.4. Progress table description
3.5. Attachments table description
3.6. Priorities table description
3.7. Roles table description
3.8. Status table description
3.9. Issue Types table description
3.10. Email types table description
3.11. Message types description
3.12. Log table description
3.13. Change History table description
3.14. Triggers table description
3.15. Custom Field table description
3.16. Custom Field Group table description
3.17. Meta data component table description
   Next
   Preface