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:40]
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 30: Line 31:
   ALTER TABLE  `invoices` ADD  `status` TINYINT( 2 ) NOT NULL, ADD  `notes` TEXT 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'​+  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)