jobs : The Jobs plugin¶
The lino_welfare.modlib.jobs plugin provides functionality for
managing job supplyments.
This document assumes that you have read jobs : Job supplyments.
Jobs¶
The Job model is used to represent a suppliable job.
- class lino_welfare.modlib.jobs.Job¶
- provider¶
The job provider for this job.
- workplace¶
The workplace for this job if the job provider has multiple workplaces. See Job providers with multiple workplaces.
This field is a dummy field it art60 is not installed.
>>> ses = rt.login('rolf')
>>> ses.show(jobs.Jobs, column_names="function provider sector", language="de")
...
=================== ================================ ==========================
Berufsbezeichnung Stellenanbieter Sektor
------------------- -------------------------------- --------------------------
Kellner BISA Horeca
Kellner R-Cycle Sperrgutsortierzentrum Landwirtschaft & Garten
Koch BISA Seefahrt
Koch Pro Aktiv V.o.G. Unterricht
Küchenassistent Pro Aktiv V.o.G. Medizin & Paramedizin
Küchenassistent R-Cycle Sperrgutsortierzentrum Reinigung
Tellerwäscher BISA Transport
Tellerwäscher R-Cycle Sperrgutsortierzentrum Bauwesen & Gebäudepflege
=================== ================================ ==========================
Job providers¶
The JobProvider model is used to represent a job provider
It is a polymorphic specialization (“MTI child”) of
contacts.Company.
>>> ses.show(jobs.JobProviders)
...
================================ ============ ================ ========= ======= ===== =========
Name Adresse E-Mail-Adresse Telefon Handy ID Sprache
-------------------------------- ------------ ---------------- --------- ------- ----- ---------
BISA 4700 Eupen 188 de
Pro Aktiv V.o.G. 4700 Eupen 191 de
R-Cycle Sperrgutsortierzentrum 4700 Eupen 189 de
================================ ============ ================ ========= ======= ===== =========
- class lino_welfare.modlib.jobs.JobProvider¶
Database model used to represent a job provider.
- is_social¶
Whether this is a recognized social economy project.
- class lino_welfare.modlib.jobs.WorkplacesByProvider¶
Shows the companies that act as workplaces for this job provider.
- class lino_welfare.modlib.jobs.Employer¶
Database model used to represent an employer.
Exists only when
jobs.with_employer_modelis True.- is_social¶
Whether this is a recognized social economy project.
Job Offers¶
>>> # settings.SITE.catch_layout_exceptions = False
>>> ses.show(jobs.Offers)
======================== ================== ========================= =================== ================ ============== =============
Name Stellenanbieter Sektor Berufsbezeichnung Beginn Auswahl Ende Auswahl Beginndatum
------------------------ ------------------ ------------------------- ------------------- ---------------- -------------- -------------
Übersetzer DE-FR (m/w) Pro Aktiv V.o.G. Landwirtschaft & Garten Kellner 22.01.14 02.05.14 01.06.14
======================== ================== ========================= =================== ================ ============== =============
Experiences by Job Offer¶
This table shows the Experiences which satisfy a given Job offer.
Example:
>>> obj = jobs.Offer.objects.get(pk=1)
>>> ses.show(jobs.ExperiencesByOffer, obj)
...
============ ========== ==================== =================================== ==========
Beginnt am Enddatum Klient Organisation Land
------------ ---------- -------------------- ----------------------------------- ----------
07.02.11 07.03.11 LAZARUS Line (144) Belgisches Rotes Kreuz Andorra
04.04.11 04.04.13 JONAS Josef (139) Pharmacies Populaires de Verviers Botswana
============ ========== ==================== =================================== ==========
Candidatures by job offer¶
This table shows the Candidatures which satisfy a given Job offer.
Example:
>>> obj = jobs.Offer.objects.get(pk=1)
>>> ses.show(jobs.CandidaturesByOffer.request(obj))
...
============== ======================= ======== ====================
Anfragedatum Klient Stelle Kandidatur-Zustand
-------------- ----------------------- -------- --------------------
02.05.14 MALMENDIER Marc (146) Inaktiv
27.06.14 KAIVERS Karl (141) Arbeitet
============== ======================= ======== ====================
>>> ses.show(jobs.ContractTypes)
=========================== ==========
Bezeichnung Referenz
--------------------------- ----------
Sozialökonomie art60-7a
Sozialökonomie - majoré art60-7b
Stadt Eupen art60-7e
mit Rückerstattung art60-7c
mit Rückerstattung Schule art60-7d
=========================== ==========
Contracts¶
- class lino_welfare.modlib.jobs.Contracts¶
Shows all Art60 job supplyments.
- class lino_welfare.modlib.jobs.ContractsByClient¶
Shows the Art60 job supplyments for this client.
- class lino_welfare.modlib.jobs.JobSupplyment¶
Model mixin for
jobs.Contractandart61.Contract. And also forart60.Contract.- duration¶
The duration of this job supplyment (number of working days).
Show all contracts¶
Via :menuselection`Explorer –> DSBE –> Art.60§7-Konventionen` you can see a list of all job supplyment contracts.
>>> show_menu_path(jobs.Contracts)
Explorer --> DSBE --> Art.60§7-Konventionen
The demo database contains 16 job supplyment contracts:
>>> ses.show(jobs.Contracts)
==== ============================= =============== ============== ========== ==================================================== ========================= ===========================
ID Klient NR-Nummer Laufzeit von Enddatum Stelle Verantwortlicher (DSBE) Art
---- ----------------------------- --------------- -------------- ---------- ---------------------------------------------------- ------------------------- ---------------------------
1 COLLARD Charlotte (118) 960715 002-61 06.10.12 05.10.13 Kellner bei BISA Alicia Allmanns mit Rückerstattung Schule
2 EVERTZ Bernd (126*) 890722 001-93 20.10.12 19.04.14 Kellner bei R-Cycle Sperrgutsortierzentrum Alicia Allmanns Sozialökonomie
3 FAYMONVILLE Luc (130*) 890202 001-76 17.11.12 16.11.13 Koch bei BISA Alicia Allmanns Sozialökonomie - majoré
4 FAYMONVILLE Luc (130*) 890202 001-76 17.11.13 17.11.14 Koch bei Pro Aktiv V.o.G. Hubert Huppertz Sozialökonomie
5 HILGERS Hildegard (133) 870325 002-29 01.12.12 30.11.14 Küchenassistent bei Pro Aktiv V.o.G. Alicia Allmanns Stadt Eupen
6 LAMBERTZ Guido (142) 810823 001-96 29.12.12 28.12.14 Küchenassistent bei R-Cycle Sperrgutsortierzentrum Alicia Allmanns Sozialökonomie - majoré
7 MALMENDIER Marc (146) 791013 001-77 12.01.13 11.01.14 Tellerwäscher bei BISA Alicia Allmanns Stadt Eupen
8 MALMENDIER Marc (146) 791013 001-77 12.01.14 12.01.15 Tellerwäscher bei R-Cycle Sperrgutsortierzentrum Mélanie Mélard mit Rückerstattung
9 RADERMACHER Christian (155) 761227 001-93 09.02.13 08.02.14 Kellner bei BISA Alicia Allmanns mit Rückerstattung Schule
10 RADERMACHER Christian (155) 761227 001-93 09.02.14 09.02.15 Kellner bei R-Cycle Sperrgutsortierzentrum Mélanie Mélard Sozialökonomie
11 RADERMACHER Fritz (158*) 750805 001-25 23.02.13 22.02.15 Koch bei BISA Alicia Allmanns Sozialökonomie - majoré
12 VAN VEEN Vincent (166) 710528 001-06 23.03.13 22.03.15 Koch bei Pro Aktiv V.o.G. Alicia Allmanns Sozialökonomie
13 RADERMECKER Rik (173) 730407 001-89 06.04.13 05.04.14 Küchenassistent bei Pro Aktiv V.o.G. Caroline Carnol Stadt Eupen
14 RADERMECKER Rik (173) 730407 001-89 06.04.14 06.04.15 Küchenassistent bei R-Cycle Sperrgutsortierzentrum Hubert Huppertz Sozialökonomie - majoré
15 DENON Denis (180*) 950810 001-04 04.05.13 03.05.14 Tellerwäscher bei BISA Alicia Allmanns Stadt Eupen
16 DENON Denis (180*) 950810 001-04 04.05.14 04.05.15 Tellerwäscher bei R-Cycle Sperrgutsortierzentrum Hubert Huppertz mit Rückerstattung
==== ============================= =============== ============== ========== ==================================================== ========================= ===========================
Use the filter parameters to show e.g. only contracts that were active on 2012-11-18:
>>> pv = dict(observed_event=isip.ContractEvents.active,
... start_date=i2d(20121118), end_date=i2d(20121118))
>>> kwargs = dict()
>>> kwargs.update(param_values=pv)
>>> ses.show(jobs.Contracts, **kwargs)
...
==== ========================= =============== ============== ========== ============================================ ========================= ===========================
ID Klient NR-Nummer Laufzeit von Enddatum Stelle Verantwortlicher (DSBE) Art
---- ------------------------- --------------- -------------- ---------- -------------------------------------------- ------------------------- ---------------------------
1 COLLARD Charlotte (118) 960715 002-61 06.10.12 05.10.13 Kellner bei BISA Alicia Allmanns mit Rückerstattung Schule
2 EVERTZ Bernd (126*) 890722 001-93 20.10.12 19.04.14 Kellner bei R-Cycle Sperrgutsortierzentrum Alicia Allmanns Sozialökonomie
3 FAYMONVILLE Luc (130*) 890202 001-76 17.11.12 16.11.13 Koch bei BISA Alicia Allmanns Sozialökonomie - majoré
==== ========================= =============== ============== ========== ============================================ ========================= ===========================
Use the filter parameters to show e.g. only contracts that started in October 2012:
>>> pv.update(observed_event=isip.ContractEvents.started,
... start_date=i2d(20121001), end_date=i2d(20121030))
>>> ses.show(jobs.Contracts, **kwargs)
...
==== ========================= =============== ============== ========== ============================================ ========================= ===========================
ID Klient NR-Nummer Laufzeit von Enddatum Stelle Verantwortlicher (DSBE) Art
---- ------------------------- --------------- -------------- ---------- -------------------------------------------- ------------------------- ---------------------------
1 COLLARD Charlotte (118) 960715 002-61 06.10.12 05.10.13 Kellner bei BISA Alicia Allmanns mit Rückerstattung Schule
2 EVERTZ Bernd (126*) 890722 001-93 20.10.12 19.04.14 Kellner bei R-Cycle Sperrgutsortierzentrum Alicia Allmanns Sozialökonomie
==== ========================= =============== ============== ========== ============================================ ========================= ===========================
Evaluations of a project¶
>>> obj = jobs.Contract.objects.get(pk=6)
>>> print(str(obj.client))
LAMBERTZ Guido (142)
>>> obj.active_period()
(datetime.date(2012, 12, 29), datetime.date(2014, 12, 28))
>>> obj.get_recurrence_set()
ExamPolicy #3 ('Alle 3 Monate')
>>> print(str(obj.get_recurrence_set().event_type))
Auswertung
>>> print(obj.get_recurrence_set().event_type.max_conflicting)
4
>>> [str(i.start_date) for i in obj.get_existing_auto_events()]
['2013-04-02', '2013-07-02', '2013-10-02', '2014-01-02', '2014-04-02', '2014-07-02', '2014-10-02']
>>> with ses.capture_logger('DEBUG') as out:
... wanted, unwanted = obj.get_wanted_auto_events(ses)
>>> print(out.getvalue())
Generating events between 2013-03-29 and 2014-12-28 (max. 72).
Évaluation 1 wants 2013-03-29 but conflicts with <QuerySet [Event #77 ('Karfreitag (29.03.2013)')]>, moving to 2013-04-01.
Évaluation 1 wants 2013-04-01 but conflicts with <QuerySet [Event #58 ('Ostermontag (01.04.2013)')]>, moving to 2013-04-02.
Reached upper date limit 2014-12-28 for 7
>>> settings.SITE.site_config.update(hide_events_before=None)
>>> ses.show(cal.EntriesByController.request(obj),
... column_names="when_html summary")
...
====================== ==================
Wann Kurzbeschreibung
---------------------- ------------------
`Do. 02.10.14 <…>`__ Évaluation 7
`Mi. 02.07.14 <…>`__ Évaluation 6
`Mi. 02.04.14 <…>`__ Évaluation 5
`Do. 02.01.14 <…>`__ Évaluation 4
`Mi. 02.10.13 <…>`__ Évaluation 3
`Di. 02.07.13 <…>`__ Évaluation 2
`Di. 02.04.13 <…>`__ Évaluation 1
====================== ==================
Mélanie has two appointments on 2014-09-15:
>>> from django.db.models import Count
>>> from lino.utils import SumCollector
>>> sc = SumCollector()
>>> for e in cal.Event.objects.filter(event_type__is_appointment=True):
... sc.collect((e.user.username, e.start_date), 1)
>>> for username_date, count in sc.items():
... if count > 1:
... print("{1} has {0} appointments on {2}".format(count, *username_date))
... break
melanie has 2 appointments on 2013-10-09
>>> d = i2d(20131009)
>>> pv = dict(start_date=d, end_date=d)
>>> ses.show(cal.EntriesByDay.request(param_values=pv),
... column_names="user start_date start_time summary project")
...
================= ============ ============ ================== ==========================
Verwaltet durch Beginnt am Beginnt um Kurzbeschreibung Klient
----------------- ------------ ------------ ------------------ --------------------------
Mélanie Mélard 09.10.13 09:00:00 Évaluation 2 AUSDEMWALD Alfons (116)
Mélanie Mélard 09.10.13 09:00:00 Évaluation 9 LAZARUS Line (144)
Alicia Allmanns 09.10.13 09:00:00 Évaluation 8 RADERMACHER Alfons (153)
================= ============ ============ ================== ==========================
The two appointments conflict, at least strictly speaking. This is because the EventType of these automatically generated evaluation appointments is configured to allow for up to 4 conflicting events:
>>> e = cal.EntriesByDay.request(param_values=pv).data_iterator[0]
>>> e.event_type
EventType #6 ('Auswertung')
>>> e.event_type.max_conflicting
4
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))
JobsOverview¶
The JobsOverview report
helps integration agents to make decisions like:
which jobs are soon going to be free, and which candidate(s) should we suggest?
Example content:
>>> ses.show(jobs.JobsOverview)
----------------------------
Sozialwirtschaft = "majorés"
----------------------------
+------------------------------------------------------------------------------------+---------------------------------------------------+--------------------------------+---------------------------------+
| Stelle | Arbeitet | Probezeit | Kandidaten |
+====================================================================================+===================================================+================================+=================================+
| `Kellner <…>`__ bei `R-Cycle Sperrgutsortierzentrum <…>`__ (1) *Sehr harte Stelle* | `RADERMACHER Christian (155) <…>`__ bis 09.02.15 | `FAYMONVILLE Luc (130*) <…>`__ | `JEANÉMART Jérôme (181) <…>`__ |
+------------------------------------------------------------------------------------+---------------------------------------------------+--------------------------------+---------------------------------+
| `Koch <…>`__ bei `Pro Aktiv V.o.G. <…>`__ (1) | `VAN VEEN Vincent (166) <…>`__ bis 22.03.15 |br| | `EMONTS-GAST Erna (152) <…>`__ | `JACOBS Jacqueline (137) <…>`__ |
| | `FAYMONVILLE Luc (130*) <…>`__ bis 17.11.14 | | |
+------------------------------------------------------------------------------------+---------------------------------------------------+--------------------------------+---------------------------------+
------
Intern
------
+--------------------------------------------------------------------------------------------+-------------------------------------------------+---------------------------------+-------------------------------+
| Stelle | Arbeitet | Probezeit | Kandidaten |
+============================================================================================+=================================================+=================================+===============================+
| `Koch <…>`__ bei `BISA <…>`__ (1) | `RADERMACHER Fritz (158*) <…>`__ bis 22.02.15 | `AUSDEMWALD Alfons (116) <…>`__ | `MEESSEN Melissa (147) <…>`__ |
+--------------------------------------------------------------------------------------------+-------------------------------------------------+---------------------------------+-------------------------------+
| `Küchenassistent <…>`__ bei `R-Cycle Sperrgutsortierzentrum <…>`__ (1) *Sehr harte Stelle* | `LAMBERTZ Guido (142) <…>`__ bis 28.12.14 |br| | `BRECHT Bernd (177) <…>`__ | `JONAS Josef (139) <…>`__ |
| | `RADERMECKER Rik (173) <…>`__ bis 06.04.15 | | |
+--------------------------------------------------------------------------------------------+-------------------------------------------------+---------------------------------+-------------------------------+
----------------------------------------------
Extern (Öffentl. VoE mit Kostenrückerstattung)
----------------------------------------------
======================================================================================================== ============================================== ============================ =============================
Stelle Arbeitet Probezeit Kandidaten
-------------------------------------------------------------------------------------------------------- ---------------------------------------------- ---------------------------- -----------------------------
`Küchenassistent <…>`__ bei `Pro Aktiv V.o.G. <…>`__ (1) *No supervisor. Only for independent people.* `HILGERS Hildegard (133) <…>`__ bis 30.11.14 `JONAS Josef (139) <…>`__
`Tellerwäscher <…>`__ bei `BISA <…>`__ (1) `KAIVERS Karl (141) <…>`__ `EMONTS Daniel (128) <…>`__
======================================================================================================== ============================================== ============================ =============================
------------------------------------
Extern (Privat Kostenrückerstattung)
------------------------------------
+----------------------------------------------------------------------+--------------------------------------------------+----------------------------+---------------------------------+
| Stelle | Arbeitet | Probezeit | Kandidaten |
+======================================================================+==================================================+============================+=================================+
| `Tellerwäscher <…>`__ bei `R-Cycle Sperrgutsortierzentrum <…>`__ (1) | `MALMENDIER Marc (146) <…>`__ bis 12.01.15 |br| | `ENGELS Edgar (129) <…>`__ | `RADERMACHER Guido (159) <…>`__ |
| | `DENON Denis (180*) <…>`__ bis 04.05.15 | | |
+----------------------------------------------------------------------+--------------------------------------------------+----------------------------+---------------------------------+
--------
Sonstige
--------
====================================== ========== ================================ ============================
Stelle Arbeitet Probezeit Kandidaten
-------------------------------------- ---------- -------------------------------- ----------------------------
`Kellner <…>`__ bei `BISA <…>`__ (1) `RADERMACHER Hedi (161) <…>`__ `ENGELS Edgar (129) <…>`__
====================================== ========== ================================ ============================
Printing this report caused a “NotImplementedError: <i> inside <text:p>” traceback when one of the jobs had a remark.
>>> settings.SITE.default_build_method = "appyodt"
>>> obj = ses.spawn(jobs.JobsOverview).create_instance()
>>> rv = ses.run(obj.do_print)
appy.pod render .../lino/modlib/printing/config/report/Default.odt -> .../media/webdav/userdocs/appyodt/jobs.JobsOverview.odt
>>> print(rv['success'])
True
>>> print(rv['open_url'])
...
/.../jobs.JobsOverview.odt
This bug was fixed 2013-04-23.
Note: the webdav/ is only there when lino.core.site.Site.use_java is True.
Configuration¶
- jobs.with_employer_model¶
Set this to True if you want to differentiate between two types of job providers, “services utilisateurs” and “employers”.
Dependencies¶
This plugin needs the lino_welfare.modlib.isip plugin.