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
Next revision Both sides next revision
fast:fast-invoice [2013/10/09 11:55]
admin [Data Migration]
fast:fast-invoice [2014/07/30 11:10]
admin
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` 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.
 +  * 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)