fast:fast-invoice
Differences
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 12:01] 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 35: | Line 36: | ||
| * table users | * table users | ||
| - | RENAME TABLE `donias2_iasdb`.`users` TO `donias2_iasdb`.`site_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 `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` CHANGE `email` `user_email` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; | ||
| Line 42: | Line 47: | ||
| UPDATE `site_users` SET `group_id` = 20 WHERE group_id = 1; | UPDATE `site_users` SET `group_id` = 20 WHERE group_id = 1; | ||
| UPDATE `site_users` SET `group_id` =1 WHERE group_id =9; | 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) | ||
fast/fast-invoice.1381338098.txt.gz · Last modified: 2017/03/10 22:59 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
