This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
fast:fast-invoice [2013/10/09 11:15] admin [Data Migration] |
fast:fast-invoice [2017/03/10 23:00] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Fast Invoice Documentation ====== | ====== Fast Invoice Documentation ====== | ||
+ | |||
+ | [[ :User Area Expansion]] | ||
**User Area:** | **User Area:** | ||
- | * Invoice List | + | - Invoice List |
- | * User Area | + | - User Area |
- | * View My Profile | + | - View My Profile |
- | * Change Password | + | - Fast Pay Area (page where invoice can be paid without log in, secure key required) |
- | * 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. |
- | * Once invoice paid key becomes invalid or if time set expires. | + | |
**Admin Area:** | **Admin Area:** | ||
Line 25: | Line 26: | ||
ALTER TABLE `invoices` CHANGE `created` `inv_date` DATE NOT NULL; | 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` 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) |