annotate 7vt/Reopening/notes.txt @ 192:86ffef4ee862

Tentative design for priority-to-newcomers
author Henry Thompson <ht@markup.co.uk>
date Sat, 22 Aug 2020 15:39:04 +0100
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
192
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
1 Trial of odoo now running at
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
2 http://markup.co.uk:8069/event
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
3
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
4 website menu field is for individual event page...
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
5
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
6 No obvious support for a recurring event
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
7
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
8 Edit this
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
9 /usr/lib/python3/dist-packages/odoo/addons/website_event/views/event_templates.xml
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
10 to e.g. change 'Register' to 'Request place(s)'
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
11
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
12 Hmm. Message goes to registrant, but not to admin...
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
13
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
14 Need to find sources...
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
15 What would it take to do a priority-to-newcomers queuing system for
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
16 7vt MfW?
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
17 1) Database with tables
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
18 a) adult, with id, name, email (key), household (fk), headOfHousehold (bool)
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
19 b) household, with id, num adults, num children
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
20 c) child, with id, name (key1), parent1 (fk), parent2 (fk), household (key2)
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
21 d) meeting, with id, date, start, end
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
22 e) roomUse, with id, event (fk), room, numAvail (int), numHeldBack (int)
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
23 f) request, with id, event (fk), household (fk), numAdults, allOrNone (bool), numChildren, timestamp
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
24 g) booking, with id, request (fk), room (fk), accepted (int), turnedUp (int)
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
25 2) Actions/forms
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
26 a) Register a household
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
27 b) Edit a household
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
28 c) Request a booking
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
29 d) Show requests/bookings (with expected status for requests,
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
30 e.g. currently nth of m for room
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
31 e) Cancel a request/booking
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
32 f) Make bookings and notify head of household for all requests,
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
33 including position on waiting list if not accepted w/o
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
34 qualification
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
35 g) Notify new winner(s), new waiting list positions, on cancellation
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
36
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
37 Doesn't as proposed allow for different categories of children,
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
38 i.e. this really only works for meeting room use for All Age, not
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
39 breakout rooms yet.
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
40
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
41 Do we want to require an acknowledgement?
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
42
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
43 Waiting list are allowed to turn up, possibly be admitted at 10 past
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
44 to empty places from heldBack and no-shows.
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
45
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
46 Priority based on
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
47 1) inverse number of previous attendances
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
48 a) with no-shows counting double?
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
49 b) with some relief depending on how long ago?
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
50 2) time of request
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
51
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
52 I.e. compute a score based on previous attendance, then sort by that
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
53 score, lowest first, and within requests with the same scores, by
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
54 request time, fill room(s) from the top down. If adding a
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
55 larger-than-one household won't fit, if no children and not allOrNone,
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
56 accept as many adults as possible. If there's another room, move
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
57 remnant if any there, otherwise move to waiting list, along with
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
58 everyone thereafter, in order.
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
59
86ffef4ee862 Tentative design for priority-to-newcomers
Henry Thompson <ht@markup.co.uk>
parents:
diff changeset
60 No groups including children on waiting list?