cal : Calendar plugin for Lino Welfare¶
The lino_welfare.modlib.cal plugin extends
lino_xl.modlib.cal for Lino Welfare.
See also cal : Calendar functionality.
Side note: Code snippets (lines starting with >>>) in this document get
tested as part of our development workflow. The following
initialization snippet tells you which demo project is being used in
this document.
>>> from lino import startup
>>> startup('lino_welfare.projects.gerd.settings.doctests')
>>> from lino.api.doctest import *
Repair database after uncomplete test run: >>> settings.SITE.site_config.update(hide_events_before=i2d(20140401))
Calendar entry types¶
Guests¶
Lifecycle of a calendar entry¶
>>> rt.show(cal.EntryStates)
...
====== ============ ================ ============= ================= ======== =================== =========
Wert name Text Button text Gäste ausfüllen Stabil nicht blockierend No auto
------ ------------ ---------------- ------------- ----------------- -------- ------------------- ---------
10 suggested Vorschlag ? Ja Nein Nein Nein
20 draft Entwurf ☐ Ja Nein Nein Nein
40 published Veröffentlicht ☼ Ja Ja Nein Nein
50 took_place Stattgefunden ☑ Nein Ja Nein Nein
70 cancelled Storniert ☒ Nein Ja Ja Ja
====== ============ ================ ============= ================= ======== =================== =========
Not for everybody¶
Only users with the OfficeUser role can see the calendar
functionality. All users with one of the following user_types can see
each other’s calendars:
>>> from lino.modlib.office.roles import OfficeUser
>>> for p in users.UserTypes.items():
... if p.has_required_roles([OfficeUser]):
... print(p)
...
100 (Begleiter im DSBE+DFA)
110 (Begleiter im DSBE+DFA (Verwalter))
120 (Begleiter im im DSBE+DFA (flexibel))
130 (Administrative Kraft im DSBE+DFA)
200 (Berater Erstempfang)
300 (Schuldenberater)
400 (Sozi)
410 (Sozialarbeiter (Verwalter))
420 (Sozialarbeiter ASD (flexibel))
430 (Administrative Kraft ASD)
500 (Buchhalter)
510 (Buchhalter (Verwalter))
900 (Verwalter)
910 (Security advisor)
Events today¶
Here is what the lino_xl.lib.cal.EntriesByDay table gives:
>>> rt.login('theresia').show(cal.EntriesByDay, language='en', header_level=1)
...
===========================
Thu 22/05/2014 (22.05.2014)
===========================
============ ======================== ============================ ================== ============= ===================== ====== =======================================
Start time Client Short description Managed by Assigned to Calendar entry type Room Workflow
------------ ------------------------ ---------------------------- ------------------ ------------- --------------------- ------ ---------------------------------------
Absent for private reasons Patrick Paraneau Absences [⚑] **☑ Took place** → [☐]
08:30:00 Versammlung Rolf Rompen External meetings [⚑] **☼ Published** → [☑] [☒] [☐]
09:00:00 BRECHT Bernd (177) Évaluation 13 Hubert Huppertz Evaluation [▽] [⚑] **? Suggested** → [☼] [☑] [☒]
09:00:00 JEANÉMART Jérôme (181) Auswertung 2 Hubert Huppertz Evaluation [▽] [⚑] **? Suggested** → [☼] [☑] [☒]
13:30:00 Petit-déjeuner Romain Raffault Internal meetings [⚑] **☒ Cancelled**
============ ======================== ============================ ================== ============= ===================== ====== =======================================
My calendar entries¶
Here is the My calendar entries view for Alicia.
>>> rt.login('alicia').show(cal.MyEntries, language='en')
...
================================= ========================== ===================== ============================ ===============================
When Client Calendar entry type Short description Workflow
--------------------------------- -------------------------- --------------------- ---------------------------- -------------------------------
`Sat 24/05/2014 at 10:20 <…>`__ Meeting Séminaire **☐ Draft** → [☼] [☒]
`Sun 25/05/2014 <…>`__ Absences Absent for private reasons **☐ Draft** → [☼] [☒]
`Mon 26/05/2014 <…>`__ RADERMACHER Fritz (158*) Evaluation Évaluation 5 [▽] **? Suggested** → [☼] [☒]
`Mon 26/05/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 14 [▽] **? Suggested** → [☼] [☒]
`Thu 29/05/2014 at 08:30 <…>`__ Meeting Consultation **☐ Draft** → [☼] [☒]
`Tue 03/06/2014 at 11:10 <…>`__ Meeting Réunion **☐ Draft** → [☼] [☒]
`Wed 04/06/2014 <…>`__ HILGERS Hildegard (133) Evaluation Évaluation 6 [▽] **? Suggested** → [☼] [☒]
`Mon 09/06/2014 at 09:40 <…>`__ Meeting Petit-déjeuner **☐ Draft** → [☼] [☒]
`Thu 26/06/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 15 [▽] **? Suggested** → [☼] [☒]
`Tue 26/08/2014 <…>`__ RADERMACHER Fritz (158*) Evaluation Évaluation 6 [▽] **? Suggested** → [☼] [☒]
`Thu 04/09/2014 <…>`__ HILGERS Hildegard (133) Evaluation Évaluation 7 [▽] **? Suggested** → [☼] [☒]
`Wed 10/09/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 1 [▽] **? Suggested** → [☼] [☒]
`Fri 10/10/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 2 [▽] **? Suggested** → [☼] [☒]
`Mon 10/11/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 3 [▽] **? Suggested** → [☼] [☒]
`Wed 26/11/2014 <…>`__ RADERMACHER Fritz (158*) Evaluation Évaluation 7 [▽] **? Suggested** → [☼] [☒]
`Wed 10/12/2014 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 4 [▽] **? Suggested** → [☼] [☒]
`Mon 12/01/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 5 [▽] **? Suggested** → [☼] [☒]
`Thu 12/02/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 6 [▽] **? Suggested** → [☼] [☒]
`Thu 12/03/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 7 [▽] **? Suggested** → [☼] [☒]
`Mon 13/04/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 8 [▽] **? Suggested** → [☼] [☒]
`Wed 13/05/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 9 [▽] **? Suggested** → [☼] [☒]
`Mon 15/06/2015 at 09:00 <…>`__ DA VINCI David (165) Evaluation Évaluation 10 [▽] **? Suggested** → [☼] [☒]
================================= ========================== ===================== ============================ ===============================
These are for Hubert:
>>> rt.login('hubert').show(cal.MyEntries, language='en')
...
================================= ========================= =============================== ============================ ===================================
When Client Calendar entry type Short description Workflow
--------------------------------- ------------------------- ------------------------------- ---------------------------- -----------------------------------
`Thu 22/05/2014 at 09:00 <…>`__ BRECHT Bernd (177) Evaluation Évaluation 13 [▽] **? Suggested** → [☼] [☑] [☒]
`Thu 22/05/2014 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 2 [▽] **? Suggested** → [☼] [☑] [☒]
`Sat 24/05/2014 at 11:10 <…>`__ HILGERS Hildegard (133) Internal meetings with client Auswertung **? Suggested** → [☼] [☒]
`Mon 26/05/2014 <…>`__ Absences Absent for private reasons **? Suggested** → [☼] [☒]
`Fri 30/05/2014 at 09:40 <…>`__ JACOBS Jacqueline (137) Internal meetings with client Seminar **? Suggested** → [☼] [☒]
`Wed 04/06/2014 at 13:30 <…>`__ KAIVERS Karl (141) Internal meetings with client Beratung **? Suggested** → [☼] [☒]
...
`Mon 02/03/2015 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 11 [▽] **? Suggested** → [☼] [☒]
`Thu 02/04/2015 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 12 [▽] **? Suggested** → [☼] [☒]
`Mon 04/05/2015 <…>`__ DENON Denis (180*) Evaluation Auswertung 4 [▽] **? Suggested** → [☼] [☒]
`Mon 04/05/2015 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 13 [▽] **? Suggested** → [☼] [☒]
`Thu 04/06/2015 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 14 [▽] **? Suggested** → [☼] [☒]
`Mon 06/07/2015 at 09:00 <…>`__ JEANÉMART Jérôme (181) Evaluation Auswertung 15 [▽] **? Suggested** → [☼] [☒]
================================= ========================= =============================== ============================ ===================================
And these for Mélanie:
>>> rt.login('melanie').show(cal.MyEntries, language='en')
...
================================= ============================= =============================== ============================ ===============================
When Client Calendar entry type Short description Workflow
--------------------------------- ----------------------------- ------------------------------- ---------------------------- -------------------------------
`Mon 26/05/2014 at 08:30 <…>`__ INGELS Irene (135) External meetings with client Interview **? Suggested** → [☼] [☒]
`Wed 28/05/2014 <…>`__ Absences Absent for private reasons **? Suggested** → [☼] [☒]
`Wed 28/05/2014 at 09:00 <…>`__ MEESSEN Melissa (147) Evaluation Évaluation 5 [▽] **? Suggested** → [☼] [☒]
`Wed 28/05/2014 at 09:00 <…>`__ RADERMACHER Edgard (157) Evaluation Évaluation 15 [▽] **? Suggested** → [☼] [☒]
`Sat 31/05/2014 at 11:10 <…>`__ JONAS Josef (139) External meetings with client Première rencontre **? Suggested** → [☼] [☒]
`Thu 05/06/2014 at 09:40 <…>`__ LASCHET Laura (143) External meetings with client Evaluation **? Suggested** → [☼] [☒]
...
`Mon 20/04/2015 at 09:00 <…>`__ RADERMACHER Edgard (157) Evaluation Évaluation 9 [▽] **? Suggested** → [☼] [☒]
`Mon 04/05/2015 at 09:00 <…>`__ RADERMACHER Guido (159) Evaluation Évaluation 10 [▽] **? Suggested** → [☼] [☒]
`Mon 04/05/2015 at 09:00 <…>`__ ÖSTGES Otto (168) Evaluation Évaluation 9 [▽] **? Suggested** → [☼] [☒]
`Mon 18/05/2015 at 09:00 <…>`__ DUBOIS Robin (179) Evaluation Évaluation 14 [▽] **? Suggested** → [☼] [☒]
`Wed 20/05/2015 at 09:00 <…>`__ RADERMACHER Edgard (157) Evaluation Évaluation 10 [▽] **? Suggested** → [☼] [☒]
`Thu 18/06/2015 at 09:00 <…>`__ DUBOIS Robin (179) Evaluation Évaluation 15 [▽] **? Suggested** → [☼] [☒]
================================= ============================= =============================== ============================ ===============================
These are Alicia’s appointments of the last two months:
>>> pv = dict(start_date=dd.today(-15), end_date=dd.today(-1))
>>> rt.login('alicia').show(cal.MyEntries, language='en',
... param_values=pv)
================================= ======== ===================== ==================== ===============================
When Client Calendar entry type Short description Workflow
--------------------------------- -------- --------------------- -------------------- -------------------------------
`Thu 08/05/2014 at 11:10 <…>`__ Meeting Interview **☒ Cancelled**
`Tue 13/05/2014 at 09:40 <…>`__ Meeting Première rencontre **☑ Took place** → [☐]
`Sun 18/05/2014 at 13:30 <…>`__ Meeting Evaluation **☼ Published** → [☑] [☒] [☐]
================================= ======== ===================== ==================== ===============================
Overdue appointments¶
>>> rt.login('alicia').show(cal.MyOverdueAppointments, language='en')
...
==================================================================== =================================================== ===================== ===================================
Calendar entry Controlled by Calendar entry type Workflow
-------------------------------------------------------------------- --------------------------------------------------- --------------------- -----------------------------------
`Évaluation 5 (02.04.2014) with LAMBERTZ Guido (142) <…>`__ `Art60§7 job supplyment#6 (Guido LAMBERTZ) <…>`__ Evaluation [▽] **? Suggested** → [☼] [☑] [☒]
`Évaluation 13 (24.04.2014 09:00) with DA VINCI David (165) <…>`__ `ISIP#24 (David DA VINCI) <…>`__ Evaluation [▽] **? Suggested** → [☼] [☑] [☒]
==================================================================== =================================================== ===================== ===================================
Calendars and Subscriptions¶
A Calendar is a set of events that can be shown or hidden in the Calendar Panel.
In Lino Welfare, we have one Calendar per User. Or to be more precise:
The
Usermodel has acalendarfield.The calendar of a calendar entry is indirectly defined by the Event’s
userfield.
Two users can share a common calendar. This is possible when two colleagues really work together when receiving visitors.
A Subscription is when a given user decides that she wants to see the calendar of another user.
Every user is, by default, subscribed to her own calendar. For example, demo user rolf is automatically subscribed to the following calendars:
>>> ses = rt.login('rolf')
>>> with translation.override('de'):
... ses.show(cal.SubscriptionsByUser, ses.get_user())
==== ========== ===========
ID Kalender versteckt
---- ---------- -----------
8 rolf Nein
==== ========== ===========
Calendar entries by client¶
- class lino_welfare.modlib.cal.EntriesByClient¶
Shows calendar entries having either
projector one guest pointing to this client.
This table is special in that it shows not only events directly related to the
client (i.e. project pointing to it)
but also those where this client is among the guests.
The following snippet finds examples of clients where this is the case
>>> hb = settings.SITE.site_config.hide_events_before
>>> hb
datetime.date(2014, 4, 1)
>>> from lino.utils import mti
>>> candidates = set()
>>> for obj in cal.Guest.objects.filter(event__start_date__gt=hb):
... if obj.partner and obj.partner_id != obj.event.project_id:
... if mti.get_child(obj.partner, pcsw.Client):
... candidates.add(obj.partner_id)
>>> print(sorted(candidates))
[174, 176, 179, 180, 181, 213, 240, 259]
>>> qs = cal.Event.objects.filter(start_date__gt=hb, project_id__in=candidates)
>>> print(sorted(set([e.project.id for e in qs])))
[179, 180, 181]
>>> obj = pcsw.Client.objects.get(id=179)
>>> rt.show(cal.EntriesByClient, obj, header_level=1,
... language="en", column_names="when_text user summary project")
...
================================================================
Calendar entries of DUBOIS Robin (179) (Dates 01.04.2014 to ...)
================================================================
================================= ================ =================== ====================
When Managed by Short description Client
--------------------------------- ---------------- ------------------- --------------------
`Thu 18/06/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 15 DUBOIS Robin (179)
`Mon 18/05/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 14 DUBOIS Robin (179)
`Fri 17/04/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 13 DUBOIS Robin (179)
`Tue 17/03/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 12 DUBOIS Robin (179)
`Tue 17/02/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 11 DUBOIS Robin (179)
`Thu 15/01/2015 at 09:00 <…>`__ Mélanie Mélard Évaluation 10 DUBOIS Robin (179)
`Mon 15/12/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 9 DUBOIS Robin (179)
`Thu 13/11/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 8 DUBOIS Robin (179)
`Mon 13/10/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 7 DUBOIS Robin (179)
`Thu 11/09/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 6 DUBOIS Robin (179)
`Mon 11/08/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 5 DUBOIS Robin (179)
`Thu 10/07/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 4 DUBOIS Robin (179)
`Tue 17/06/2014 at 09:00 <…>`__ Robin Rood
`Tue 10/06/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 3 DUBOIS Robin (179)
`Thu 22/05/2014 <…>`__ Mélanie Mélard Urgent problem DUBOIS Robin (179)
`Wed 07/05/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 2 DUBOIS Robin (179)
`Mon 07/04/2014 at 09:00 <…>`__ Mélanie Mélard Évaluation 1 DUBOIS Robin (179)
================================= ================ =================== ====================
Hiding all events before a given date¶
This database has hide_events_before set to 2014-04-01.
>>> settings.SITE.site_config.hide_events_before
datetime.date(2014, 4, 1)
Events generated by a contract¶
>>> settings.SITE.site_config.update(hide_events_before=None)
>>> obj = isip.Contract.objects.get(id=18)
>>> rt.show(cal.EntriesByController, obj, header_level=4, language="en")
Calendar entries of ISIP#18 (Alfons RADERMACHER)
================================================
================================ =================== ================= ===== =================
When Short description Managed by No. Workflow
-------------------------------- ------------------- ----------------- ----- -----------------
`Tue 12/11/2013 (09:00) <…>`__ Évaluation 9 Alicia Allmanns 9 **? Suggested**
`Wed 09/10/2013 (09:00) <…>`__ Évaluation 8 Alicia Allmanns 8 **? Suggested**
`Mon 09/09/2013 (09:00) <…>`__ Évaluation 7 Alicia Allmanns 7 **? Suggested**
`Thu 08/08/2013 (09:00) <…>`__ Évaluation 6 Alicia Allmanns 6 **? Suggested**
`Mon 08/07/2013 (09:00) <…>`__ Évaluation 5 Alicia Allmanns 5 **? Suggested**
`Thu 06/06/2013 (09:00) <…>`__ Évaluation 4 Alicia Allmanns 4 **? Suggested**
`Mon 06/05/2013 (09:00) <…>`__ Évaluation 3 Alicia Allmanns 3 **? Suggested**
`Thu 04/04/2013 (09:00) <…>`__ Évaluation 2 Alicia Allmanns 2 **? Suggested**
`Mon 04/03/2013 (09:00) <…>`__ Évaluation 1 Alicia Allmanns 1 **? Suggested**
================================ =================== ================= ===== =================
After modifying hide_events_before we must tidy up
and reset it in order to not disturb other test cases:
>>> settings.SITE.site_config.update(hide_events_before=i2d(20140401))
Filter list of clients when creating appointment¶
The “Client” field of a calendar entry in Lino Welfare has a filtered choice list which shows only coached clients. “Quand on veut ajouter un rendez-vous dans le panneau “Rendez-vous aujourd’hui”, la liste déroulante pour le choix du bénéficiaire fait référence à la liste de l’onglet CONTACTS –> BÉNÉFICIAIRES. Nous souhaitons que la liste de référence soit celle de l’onglet CPAS –> BÉNÉFICIAIRES. En effet, cette dernière ne reprend que les dossiers actifs (attribués aux travailleurs sociaux).”
>>> show_choices('romain', '/choices/cal/AllEntries/project')
<br/>
AUSDEMWALD Alfons (116)
BRECHT Bernd (177)
COLLARD Charlotte (118)
DENON Denis (180*)
DOBBELSTEIN Dorothée (124)
DUBOIS Robin (179)
EMONTS Daniel (128)
EMONTS-GAST Erna (152)
ENGELS Edgar (129)
EVERS Eberhart (127)
FAYMONVILLE Luc (130*)
GROTECLAES Gregory (132)
HILGERS Hildegard (133)
JACOBS Jacqueline (137)
JEANÉMART Jérôme (181)
JONAS Josef (139)
KAIVERS Karl (141)
KELLER Karl (178)
LAMBERTZ Guido (142)
LAZARUS Line (144)
MALMENDIER Marc (146)
MEESSEN Melissa (147)
RADERMACHER Alfons (153)
RADERMACHER Christian (155)
RADERMACHER Edgard (157)
RADERMACHER Guido (159)
RADERMACHER Hedi (161)
RADERMECKER Rik (173)
DA VINCI David (165)
VAN VEEN Vincent (166)
ÖSTGES Otto (168)
<ParamsPanel main …has no variables¶
This section helped us to understand and solve another problem which occured while working on ticket #340.
<ParamsPanel main in ParamsLayout on cal.Subscriptions> of LayoutHandle for ParamsLayout on cal.Subscriptions has no variables
>>> from lino.utils.jsgen import with_user_profile
>>> class W:
... def write(self, s):
... pass
>>> w = W()
>>> def f():
... dd.plugins.extjs.renderer.write_lino_js(w)
>>> with_user_profile(users.UserTypes.anonymous, f)
...