User Area Expansion

User Area:

1. Invoice List
2. User Area
   1. View My Profile
3. Fast Pay Area (page where invoice can be paid without log in, secure key required)
   1. 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

• 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';

yum install libXrender
yum install fontconfig
yum install libXext

• 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)