User Tools

Site Tools


fast:fast-invoice

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
fast:fast-invoice [2013/10/09 11:11]
admin
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 20: Line 21:
  
 ===== Data Migration ===== ===== 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)
fast/fast-invoice.txt · Last modified: 2017/03/10 23:00 (external edit)