Api: Create a mechanism for statement-based payments for organizations

[daleighan]

Instead of being charged automatically, they would need to get a statement that they would then go to the dashboard to pay. This is probably a feature that will not be included in the initial version but will need to be added earlier than some other features. There is also a web interface for it.

[daleighan]

id, due bill date, due date, amount due, status notes, payment_id General approach:

• Statement created by manual admin action
• Listed on user profile
• Paid with card on file

[daleighan]

create table organization_statements(
  id int(11) not null auto_increment,
  organization_id int(11) not null,
  billing_date datetime not null,
  due_date datetime not null,
  amount int(11) not null,
  status varchar(255) default 'outstanding',
  payment_id int(11) default null,
  notes text default null,
  created_at datetime not null,
  updated_at datetime not null,
  deleted_at datetime default null,
  primary key (id)
);
alter table organization_statements add column paid_date datetime after due_date;