Part I. Macrotone Issue Tracker

Table of Contents

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