#CakePHP RecordTrac Port
This is a port of [RecordTrac] (https://github.com/postcode/recordtrac) using CakePHP (2.5.4) as the framework. Although this project is called a "port," it does not follow the same conventions for JSON files and DB as the original RecordTrac.
You will need to have CakePHP (2.5.4) installed, install it from the instructions on their site.
record-trac.sqlis included with this, it is the structure for the database, import it into the database that you configured in CakePHP.
If you would like some test data (recommended), also import
Copy the files from this package into the corresponding CakePHP folders, the following files will need to be edited rather than overwritten if you are installing to a CakePHP installation that already has applications running:
Edit /app/Config/recordtrac.php to match your agency's information
In your app/Config/routes.php add thes lines (replacing the default). make sure this is before pages route
Router::connect('/', array('controller' => 'recordtrac', 'action' => 'index')); //sets recordtrac as default index for whole CakePHP install
Router::connect('/about', array('controller' => 'pages', 'action' => 'display', 'about')); //just a prettier for /about
Router::connect('/track', array('controller' => 'requests', 'action' => 'track', 'track')); // track is really part of requests, not a seperate controller
Router::connect('/track/:id', array('controller' => 'requests', 'action' => 'view'),array('pass' => array('id'))); //This routes /track/REQUESTID
You should now be able to go to your root URL and see the RecordTrac landing page.
To login as a staff member, the credentials are: email@example.com/letmein (master admin page can be found at /admin)
YOU MUST CHANGE THESE CREDENTIALS BEFORE GOING INTO PRODUCTION
If you have any questions, please create an issue in github.
###Additional Notes You may want to add a honeypot to your implementation in order to stave off spam, install CakePHP HoneyPot Blacklist Component to accomplish this.
###Technologies Used http://www.ekoim.com/blog/bootstrap-cakephp-bootstrapcake/ - CakePHP Bootstrap Layout Addition
http://getbootstrap.com - Twitter Bootstrap (as included in the above Layout)
http://www.cakephp.org - CakePHP
https://github.com/destinydriven/cakephp-high-charts-plugin - Charts on landing page
https://github.com/josegonzalez/cakephp-upload - file uploads for records
###Why Make a CakePHP port? When researching RecordTrac, the usefullness of the product became immediately apparent. The functionality of the application and ease of use for users really impressed. It is a great product!
After getting a demo installed, there were a few items that could use some re-arranging. One of the big things was the seperation of JSON and Model data. It seemed unneccesarily complex to have the data seperated. For example, the department.json does not relate to the doctypes.json and so forth. So, in an effort to curb some of the extra editing, in the CakePHP version, all of that information is held in models. This makes it easier for assigned "super admins" to edit departments, users, and doctypes very easily. I also added in the ability for "super admins" to edit the copy for closures and extensions of requests.
Another factor in the port was familiarity of the core technologies. Working with a python/postgresql code base is something that was doable, but not something that I am completely comfortable with. Realizing the huge impact this application would have on our organization, being very familiar with the base technologies was a must. Choosing CakePHP/mySQL was a matter of technologies that I am very familiar with, and would be comfortable supporting. It also came to reason that others may be in the same situation, thus the reason for openly sharing the project.