Payroll System

Simple online-capable payroll system.

Dev Notes

Setup

Download and install the following:

• [Git] (http://git-scm.com)
• [GitHub for Windows] (http://windows.github.com) (shortened to GH for the rest of this readme)
• [CakePHP] (http://www.cakephp.org)
• [WampServer] (http://www.wampserver.com/en/)

IMPORTANT it is assumed that the user has at least basic knowledge of how to use these software.

Configuration

1. Unzip CakePHP to C:\cakephp\ (rename root folder)

   File hierarchy should look like this:

    C:\
    	cakephp\
    		app\
    		lib\
    		...
   

   OPTIONAL only lib\ folder is really necessary; all other files/folders can be deleted

2. Left-click on wampserver tray icon > Apache > httpd.conf

3. IMPORTANT Uncomment LoadModule rewrite_module modules/mod_rewrite.so (just CTRL+F it), save, and resart WampServer

4. clone repo to C:\wamp\www\ (NOT *username*/Documents/GitHub if using GH)

   directory should look like this:

    C:\
    	wamp\
    		www\
    			payroll\
    				app\
    				...
   

   IMPORTANT check payroll\app\tmp\ folder if it contains the following folders. If it doesn't, manually add them:

    ..\
    	tmp\
    		cache\
    			models\
    			persistent\
    			views\
    		logs\
    		sessions\
    		tests\
   

5. run WampServer (127.0.0.1 any browser), click 'payroll' under 'Your Projects'

6. CakePHP's default home page should load with couple warnings (define new seed/salt in config.php) and with everything else OK (except for database config).

Database Syncronization

1. Open 'db model.mwb' from Dropbox in Workbench
2. Once you see the diagram, go to Database > Synchronize Model... (or CTRL+SHIFT+Z)
3. Follow instructions in the wizard

Notes on Syncronization Failures

• sometimes just reordering generated queries will fix most errors
• [this might help with errno 150's] (http://www.eliacom.com/mysql-gui-wp-errno-150.php)
• show engine innodb status query will give better description of error
• if all else fails, drop table in database and clean sync
• or just drop db altogether :P

Exporting Databases

In Workbench, Server Administration > left pane > Data Export/Restore > Data Export.