Versie 2.5 17-10-2022 Updated 21-09-2023

Algemeen

- Changed version in Subscription calls for note in 'magimp' to v2.5
- Added DLN_ORD_ID to Subscription calls
- Added role 'updater' AND added authorization to some calls
- Examples/output must be same structure
- Clarify error in parameters voor response message
- Added error messages for HTTP response
- Changed checks on parameters ( multi-dimensional arrays )
- Changed query for 'empty' timestamp field
- Added date/time to magimp.reserve2
- Added client IP address to magimp.reserve4
- Created function to convert date into YYYY-MM-DD for MySQL ( from DD-MM-YYYY or DD/MM/YYYY or YYYY/MM/DD )
- Implement authorization on URL's for Endpoints(Accesses)
- Changed code for correct authorization to create/modify/delete Endpoints
- Changes selection criteria on correct timestamp fields ( not all tables )
- Restructered Course call and CourseGroup calls
- Added two new files ( changed names, included 's' in name ) for uniform purposes
- Changed some definitions for consistency
- Added calculation/check on parameters ( max 1 month ( 31 days ) )
- Changed type of season/number of courses (consistency)
- Added field timestamp to lessonBlock and variation

Calls

Activity calls

Added tarief.vrij-decimal2 for activityprice
Added address data of location
Added WebInfo information
Added pricelistName CursAd: tarief.reserve2
Changed order according to definition
Added selection based on parameter 'updated_since' for ALL and BASIC queries
Changed query selection for calls by {id}: removed selection on 'restapi' parameter
Activity calls timestamps implemented

Activity by IdWeb calls

AdminSeason calls

Added some fields in /adminseason call for Mijn Omgeving information
Use seizoe.vrij-logical4 instead of seizoe.vrij-logical1
Change field to seizoe.vrij-logical3

Association calls

CancelReason calls

Call CancelReason ( CursAd: Opzegredenen )
Added field opzegg.vrij-nummer1 as canceldays

Category calls

Course calls

Added tarief.vrij-decimal2 for lessonprice
Added address data of location
Added WebInfo information
Added parameter 'cluster' to call /course/groups/{id}
Added pricelistName CursAd: tarief.reserve2
Added selection based on parameter 'updated_since' for ALL and BASIC queries
Changed query selection for calls by {id}: removed selection on 'restapi' parameter

Course by IdWeb calls

Added tarief.vrij-decimal2 for lessonprice
Added address data of location to Course calls
Added WebInfo information
Added pricelistName CursAd: tarief.reserve2
Changed query selection for calls by {id}: removed selection on 'restapi' parameter

CourseGroup calls

Restructured CourseGroup calls

Debtor calls

Added age check (>18)
Added 'Salutation' object ( CursAd: aanhef)
Added call to Debtor section ( removed from Participant section )
Changed call to get invoices by FTP
Remove checks on 'id' for update and changed order in Debtor controller
Added parameter season ( onwards up ) in /debtor/financial/{id}
Added amountTotal as calculated field ( amountNet + amountVAT
Added avg1 - avg5 fields
Added salutation to POST (create)
Newsletter & avg1_media are required fields for POST ( create )
Changed call for no 0 students from debtor - null in array
Added 'triggering' on field naw.timestamp

Participant calls

Get participant presence information by StudentID
Changed call to select Teacher and Location data from dlnhis ( not deelne ) table
Added CursAd Plaatsingsdatum as 'confirmdate' to relevant calls
Changed call to select Teacher and Location data from dlnhis ( not deelne ) table
Added call to Debtor section ( removed from Participant section )
Added CursAd Plaatsingsdatum as 'confirmdate' to relevant Participant calls
CursAd stat.statuswaarde instead of deelne.statuswaarde
Implemented array for buttons to show in Mijn Omgeving
Added crsgen.id_planning and crsgen.vrij-character2 ( BlockNumber ) to Participant calls
Added deelne.startdatum, deelne.einddatum
Changed seizoe.seizoe-num -> seizoe.reserve1 ( CursAd trigger created )

Schedule calls

Student calls

Added 'Salutation' object ( CursAd: aanhef)
Added avg1 - avg5 fields
Added salutation to POST (create)
Always add 'geslacht' and 'gebdatum' as a pair in PUT call
Added 'triggering' on field naw.timestamp

Subscription calls

Added DLN_ORD_ID to Subscription calls
Determine correct 'id-aanhef' based on gender and age
Changed documentation and type ( to boolean ) for two fields: DLN_NIEUWSBRIEF and DLN_AVG1
Added calls for both function ( ReSubscription and CancelSubscription ) - Changed mappings
DLN_TYPE ( field 125 'magimp' ) for Mijn_Omgeving: MijnHerinschrijving/MijnAfmelding
Added opzegg.vrij-logical4 ( cancelreason published for Mijn Omgeving )
Added DLN_OPZEGCODE to /subscription/cancelkeys
Reorganised Subscription calls. Added parameters to call /subscription ( from - until )
City not found -> still error, city inactive -> activate
Added status of 'magimp' record for call /subscription and /subscription/{id}
Added default subscription default status
Changed wrong parameter VGD_AVG5 -> DLN_AVG5

Subscription Education calls

Added DLN_ORD_ID to Subscription calls

TeacherInvoice calls

Some call are authorized ( contact for more information )
PUT calls are implemented fully, GET calls are implemented partially
Added some amounts and 'teacher' data to GET calls
Changed logic for invoicelines and ledgerlines
Remove duplicates and added amounts to invoicelines
Added some fields ( docent.personeelsnummer - fktrin.btwperc - fktring.btw-perc )
Added docent.personeelnummer (calls uses Commom\Teacher.php)
Changed query and added memory for call
Added fields faktin.maandfaktuur & faktin.maandnummer
Workaround: return only field 'reference' ( performance/memory problem )