annotate app_notes.txt @ 15:27cd1a94580f default tip

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