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:14] admin [Data Migration] |
fast:fast-invoice [2014/07/30 11:34] admin [Notes Statuses (notes.type_id)] |
||
|---|---|---|---|
| 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 48: | Line 53: | ||
| ALTER TABLE `site_users` CHANGE `lastip` `last_ip` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0'; | 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.txt · Last modified: 2017/03/10 23:00 (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
