Training webpages and accounting

[rpcme]

For training, we need to:

1. Display a summary page of available training
2. Display detail pages for each available training
3. Keep a running count of available seats for each offering.

For Mojoconf 2015: For (1), would like a child page to the landing having the course description, trainer biography, and trainer profile picture. For (2) would like to have the ability to display the course outline, prereq, etc. -- what is currently under https://github.com/mojoconf/nyc-2015-06-05/tree/master/training (right now, the text is not "golden") For (3) would like to keep a running count of seats available so we know when people can no longer purchase a training seat

For this conference, each course has a maximum of 18 seats.

[jhthorsen]

I'm setting up a new table now, which I think is related to this:

CREATE TABLE conference_products (
  conference_id INTEGER REFERENCES conferences (id) ON UPDATE CASCADE,
  name TEXT NOT NULL,
  description TEXT NOT NULL DEFAULT '',
  price REAL NOT NULL,
  currency VARCHAR(3) NOT NULL DEFAULT 'USD',
  n_of INTEGER NOT NULL DEFAULT -1, -- max number, -1 = infinite
  available_from TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  available_to TIMESTAMP NOT NULL DEFAULT '2099-12-31 23:59:59',
);

[rpcme]

This is useful but not sure if description belongs here or in a "training data sheet" table which lists all the training sections. It may be overboard at this point to do it though.

[jhthorsen]

"description" is a TEXT, meaning it can hold a looooong description. I was thinking I would use Text::Markdown to format it on the page.

[rpcme]

okay. this means the CGI modernization training synopsis under https://github.com/mojoconf/nyc-2015-06-05/tree/master/training needs to be converted to md.

Would be helpful to document that "block text" should be done in md so we're not caught on this in the future.