Versie 2.1 20-08-2019

Algemeen 

changes in green are backported from a newer version

    • Added Participant calls
    • Added tarief.vrij-logical2 ( for calculation module in WordPress plugin )
    • Error 500 - due to AVG checkboxes
    • Changed DLN-NIEUWSBRIEF and DLN-AVG1 in 'mappings'
    • Added 'space' in json output when concatenating fields
    • Added checks for UPDATE logical/character fields
    • Added Gebouwcode en Lokaalcode aan call(s)
    • Added WITH (NOLOCK) in all *Query programs in SELECT clauses
    • Changed updateDebtor function to look for correct field
    • Added logic for UPDATING iban / rekeningnr / bic
    • Remove 'leading' zero's in function AccountNumberfromIBAN($iban)
    • Added new call to get DebtorAccount data ( id and telephone an email data ) from parameter email
    • Check if IBAN is not empty
    • Added field iDEALPayment ( CursAd: cursus.vrij-logical4 )
    • Added some fields in Student Mapping
    • Added 'logical' fields for telephonenumbers to PersonAccount object 
    • Added parameter season
    • Added financial fields to Participant calls
    • Added financial data for Debtor
    • Implemented API call to get Students Id's from a DebtorId
    • Added fields for 01IDEAL with checks Made some VGD- fields required
    • Added fields to /subscription/coursekeys call 
    • Changed API code to accomodate single quotes in UPDATE/DELETE calls Student and Debtor
    • Changed call /coursegroup/system for Wordpress plugin
    • Cast field 'lestijd' to float
    • Change format fields startTime endTime in array lessonBlocks
    • Incorrect WHERE clause ( due to MariaDB update )
    • Changed definition for DLN-LL field in magimp
    • Division by zero error ( no Open Periods )
    • Changed definition for field paymentAmount
    • Added new call for courses NOT published for the Web ( Wordpress plugin )
    • Added WHERE clause to Participant calls - only active records
    • Added message 'No Wordpress cluster or cluster(s) in System record found!'
    • Changed mapping for SubscriptionEducation 

Calls

Activity calls

Added 'space' in json output when concatenating fields

Added Gebouwcode en Lokaalcode aan call(s)

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added field iDEALPayment ( CursAd: cursus.vrij-logical4 )

Change format fields startTime endTime in array lessonBlocks

 

Activity by IdWeb calls

Added 'space' in json output when concatenating fields

Added Gebouwcode en Lokaalcode aan call(s)

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added field iDEALPayment ( CursAd: cursus.vrij-logical4 )

Change format fields startTime endTime in array lessonBlocks

 

Category calls

Added 'space' in json output when concatenating fields

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

 

Course calls

Added tarief.vrij-logical2 ( for calculation module in WordPress plugin )

Added 'space' in json output when concatenating fields

Added Gebouwcode en Lokaalcode aan call(s)

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added field iDEALPayment ( CursAd: cursus.vrij-logical4 )

Change format fields startTime endTime in array lessonBlocks

/course/basicnotweb Added new call for courses NOT published for the Web ( Wordpress plugin )

 

Course by IdWeb calls

Added tarief.vrij-logical2 ( for calculation module in WordPress plugin )

Added 'space' in json output when concatenating fields

Added Gebouwcode en Lokaalcode aan call(s)

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added field iDEALPayment ( CursAd: cursus.vrij-logical4 )

Change format fields startTime endTime in array lessonBlocks

 

CourseGroup calls

Added 'space' in json output when concatenating fields

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Changed call /coursegroup/system for Wordpress plugin ( Adds cluster 'Wordpress' if not exists in sysy.vrij-character3 )

Added message 'No Wordpress cluster or cluster(s) in System record found!'

 

Debtor calls

Error 500 - due to AVG checkboxes

Added checks for UPDATE logical/character fields

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Changed updateDebtor function to look for correct field

Added logic for UPDATING iban / rekeningnr / bic

Remove 'leading' zero's in function AccountNumberfromIBAN($iban)

/debtor/email Added new call to get DebtorAccount data ( id and telephone an email data ) from parameter email

Check if IBAN is not empty

Added 'logical' fields for telephonenumbers to PersonAccount object 

Added financial data for Debtor

/debtor​/students​/{id} Implemented API call to get Students Id's from a DebtorId

Changed API code to accomodate single quotes in UPDATE/DELETE calls Student and Debtor

/debtor/financial/{id} Division by zero error ( no Open Periods )

/debtor/financial/{id} Changed definition for field paymentAmount

  

Participant calls

 Added Participant calls

/participant

/participant/{id}

/participant/student/{studentid}

 /participant/debtor/{debtorid}

/participant/course/{courseid}

 /participant/school/{schoolid}

Added Gebouwcode en Lokaalcode aan call(s)

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added parameter season ( alle calls )

Added financial fields to Participant calls

Cast field 'lestijd' to float

Incorrect WHERE clause ( due to MariaDB update )

Added WHERE clause to Participant calls - only active records

  

School calls

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

 

Student calls

Added checks for UPDATE logical/character fields

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added logic for UPDATING iban / rekeningnr / bic

Remove 'leading' zero's in function AccountNumberfromIBAN($iban)

Check if IBAN is not empty

Corrected some address fields in Student Mapping

Added 'logical' fields for telephonenumbers to PersonAccount object 

Changed API code to accomodate single quotes in UPDATE/DELETE calls Student and Debtor

  

Subscription calls

Changed DLN-NIEUWSBRIEF and DLN-AVG1 in 'mappings'

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Added fields for 01IDEAL with checks Made some VGD- fields required

Added fields to /subscription/coursekeys call 

  

Subscription Education calls

Added WITH (NOLOCK) in all *Query programs in SELECT clauses

Changed DLN-NIEUWSBRIEF and DLN-AVG1 in 'mappings'

Changed definition for DLN-LL field in magimp

Changed mapping for SubscriptionEducation ( DLN-LL, DLN-GR and DLN-BG )