User Tools

Site Tools


Sidebar

PROJECTS

CLIENT AREA

PRIVATE

fast:fast-invoice

Fast Invoice Documentation

User Area Expansion

User Area:

  1. Invoice List
  2. User Area
    1. View My Profile
  3. Fast Pay Area (page where invoice can be paid without log in, secure key required)
    1. Once invoice paid key becomes invalid or if time set expires.

Admin Area:

  • Invoice List
  • Manage Clients
  • Manage Users
  • User Area
    • View My Profile
    • Change Password

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)