====== Fast Invoice Documentation ======

[[ :User Area Expansion]]

**User Area:**

  - Invoice List
  - User Area
    - View My Profile 
  - Fast Pay Area (page where invoice can be paid without log in, secure key required)
    - Once invoice paid key becomes invalid or if time set expires.

**Admin Area:**

  * Invoice List
  * Manage Clients
  * Manage Users
  * User Area
    * View My Profile
    * Change Password

===== Data Migration =====

  * table invoices

  ALTER TABLE  `invoices` CHANGE  `created`  `inv_date` DATE NOT NULL;
  ALTER TABLE  `invoices` CHANGE  `method`  `pay_method` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
  ALTER TABLE  `invoices` ADD  `taxrate` DECIMAL( 6, 4 ) NOT NULL AFTER  `pay_method`;
  ALTER TABLE  `invoices` CHANGE  `tax`  `taxtotal` DECIMAL( 8, 2 ) NOT NULL DEFAULT  '0.00';
  ALTER TABLE  `invoices` CHANGE  `status`  `status_OLD` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
  ALTER TABLE  `invoices` ADD  `status` TINYINT( 2 ) NOT NULL, ADD  `notes` TEXT NOT NULL;
  
  UPDATE  `invoices` SET  `status` =1 WHERE  `status_OLD` =  'Paid';
  ALTER TABLE `invoices` DROP `status_OLD`;

  * table users

  RENAME TABLE  `users` TO  `site_users`;
  
  FIX PHONE #s
  UPDATE users SET phone = replace(replace(replace(replace(`phone`,' ',''),'(',''),')',''),'-','') WHERE phone RLIKE '^[+]?[-() 0-9]+$';
  
  ALTER TABLE  `site_users` CHANGE  `password`  `user_password` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  ALTER TABLE  `site_users` CHANGE  `email`  `user_email` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
  ALTER TABLE `site_users` DROP `currency`;
  ALTER TABLE  `site_users` CHANGE  `userlevel`  `group_id` TINYINT( 1 ) NOT NULL DEFAULT  '1';
  UPDATE  `site_users` SET  `group_id` = 20 WHERE group_id = 1;
  UPDATE  `site_users` SET  `group_id` =1 WHERE group_id =9;
  **created RENAME TO user_regdate**
  ALTER TABLE  `site_users` CHANGE  `notes`  `note` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
  ALTER TABLE  `site_users` CHANGE  `lastlogin`  `user_lastvisit` DATETIME NULL DEFAULT  '0000-00-00 00:00:00';
  ALTER TABLE `site_users` DROP `active`;
  ALTER TABLE  `site_users` CHANGE  `lastip`  `last_ip` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT  '0';
  
==== Install wkhtmltopdf on CentOS ====

  yum install libXrender
  yum install fontconfig
  yum install libXext
 
==== Notes Statuses (notes.type_id) ====

  * 0 - Manual notes.
  * 1 - Auto notes.
  * 2 - Email Sent Successfully.
  * 3 - Email Send Failed
  * 5 - Manual Invoice Changed to Paid
  * 10 - Payment processed successfully (Stripes.com)
  * 11 - Failed to process payment (Stripes.com)