OpenStudio 2019.3.0

New features

• Ability to prevent check-ins on a subscription by adding a temporary check-in block
• Log acceptance of subscription terms
• Teachers can request sub teachers
• Finance / Expenses
• Custom "subscription activated" message when using direct debit for shop subscriptions

Optimizations

• Group shop sales in cash book by general ledger account
• List trial cards under reports / class cards
• Improved usability of customer profiles on mobile devices
• Update AdminLTE

And some bug fixes

Installation

• Run on Web2py 2.18.4
• Update redis library to lastest version using "pip uninstall redis" and "pip install redis"

Database maintenance

We cleaned up the database field a little bit by removing some unused fields. Unfortunately the foreign keys pointing to these fields have to be manually dropped before Web2py can complete the required migrations successfully. We also can't include an automatic script for this, as these keys might not be the same for every installation.

• Remove the following foreign keys for the invoices table using SQL queries
  • classes_attendance_id
  • auth_customer_id
  • workshops_products_customers_id
  • customers_classcards_id
  • customers_subscriptions_id

mysql> show create table invoices;

  CONSTRAINT `invoices_ibfk_1` FOREIGN KEY (`invoices_groups_id`) REFERENCES `invoices_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_2` FOREIGN KEY (`auth_customer_id`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_3` FOREIGN KEY (`payment_methods_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_4` FOREIGN KEY (`customers_classcards_id`) REFERENCES `customers_classcards` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_5` FOREIGN KEY (`workshops_products_customers_id`) REFERENCES `workshops_products_customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_6` FOREIGN KEY (`classes_attendance_id`) REFERENCES `classes_attendance` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_ibfk_7` FOREIGN KEY (`customers_subscriptions_id`) REFERENCES `customers_subscriptions` (`id`) ON DELETE CASCADE

mysql> alter table invoices drop foreign key receipts_ibfk_<number for key to remove>

Remove a foreign key for the receipts table using a SQL query

mysql> show create table receipts;

...
  CONSTRAINT `receipts_ibfk_1` FOREIGN KEY (`payment_methods_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `receipts_ibfk_2` FOREIGN KEY (`Created_by`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `receipts_ibfk_3` FOREIGN KEY (`CreatedBy`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE

mysql> alter table receipts drop foreign key receipts_ibfk_<number for Created_by>