User Tools

Site Tools


Sidebar

PROJECTS

CLIENT AREA

PRIVATE

fast:fast-invoice

This is an old revision of the document!


Fast Invoice Documentation

User Area:

  • Invoice List
  • User Area
    • View My Profile
    • Change Password
  • 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.

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;
fast/fast-invoice.1381335643.txt.gz · Last modified: 2017/03/10 22:59 (external edit)