Versie 2.2 08-05-2020

Algemeen

    • Added field tarief.opmerkingen as 'Remarks'
    • Added field groep-max as numberOfLessons Changed in CourseQuery vrij-character3 to lestype ( Field added, added to database trigger and converted in CursAd database )
    • Added fields to Participant calls
    • Same type/logic/label for 'automatische incasso' in Participant calls and Debtor Financial call
    • Added fields from CursAd table 'faktuu'
    • Added fields cursus.cursus-oms and cursus.cursus-oms-verv as separate fields in API: name1 and name2
    • Added field id-gebouw Changed type to integer ( id-gebouw=gid and id-lokaal=id)
    • Added fields to Course calls crsgen.vrij-datum1 cancelDate crsgen.vrij-datum2 subscriptionclosedDate crsgen.vrij-datum3 publishDate
    • 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 fields cursus.cursus-oms and cursus.cursus-oms-verv as separate fields in API: name1 and name2

Added field id-gebouw Changed type to integer ( id-gebouw=gid and id-lokaal=id)

Change format fields startTime endTime in array lessonBlocks

  

Activity by IdWeb calls

Added fields cursus.cursus-oms and cursus.cursus-oms-verv as separate fields in API: name1 and name2

Added field id-gebouw Changed type to integer ( id-gebouw=gid and id-lokaal=id)

Change format fields startTime endTime in array lessonBlocks

  

Category calls

 

Course calls

Added field tarief.opmerkingen as 'Remarks'

Added field groep-max as numberOfLessons

Added fields cursus.cursus-oms and cursus.cursus-oms-verv as separate fields in API: name1 and name2

Added field id-gebouw Changed type to integer ( id-gebouw=gid and id-lokaal=id)

Added fields to Course calls crsgen.vrij-datum1 cancelDate crsgen.vrij-datum2 subscriptionclosedDate crsgen.vrij-datum3 publishDate

    "lessonBlocks": [
      {
        "id_planning": 1,
        "id": 1,
        "BlockNumber": "3.1",
        "lessonType": "1",
        "startDate": "YYYY-MM-DD",
        "endDate": "YYYY-MM-DD",
        "startTime": "HH:MM",
        "endTime": "HH:MM",
        "duration": {
          "hours": 2,
          "minutes": 15
        },
        "numberOfLessons": 8,
        "agegroup": {
          "id": 2,
          "code": "J6-12",
          "description": "Jeugd 6-12 jaar",
          "fromAge": 6,
          "toAge": 12
        },
        "cancelDate": "YYYY-MM-DD",
        "subscriptionclosedDate": "YYYY-MM-DD",
        "publishDate": "YYYY-MM-DD",
        "published": true,
        "remarks": "Remarks for lessonBlock",
        "teacher": {
          "id": 2,
          "code": "JJ",
          "initials": "JJ",
          "firstName": "Jos",
          "middleName": "van",
          "lastName": "Janssen"
        },

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 field tarief.opmerkingen as 'Remarks'

Added field groep-max as numberOfLessons

Added fields cursus.cursus-oms and cursus.cursus-oms-verv as separate fields in API: name1 and name2

Added field id-gebouw Changed type to integer ( id-gebouw=gid and id-lokaal=id)

Added fields to Course calls crsgen.vrij-datum1 cancelDate crsgen.vrij-datum2 subscriptionclosedDate crsgen.vrij-datum3 publishDate

    "lessonBlocks": [
      {
        "id_planning": 1,
        "id": 1,
        "BlockNumber": "3.1",
        "lessonType": "1",
        "startDate": "YYYY-MM-DD",
        "endDate": "YYYY-MM-DD",
        "startTime": "HH:MM",
        "endTime": "HH:MM",
        "duration": {
          "hours": 2,
          "minutes": 15
        },
        "numberOfLessons": 8,
        "agegroup": {
          "id": 2,
          "code": "J6-12",
          "description": "Jeugd 6-12 jaar",
          "fromAge": 6,
          "toAge": 12
        },
        "cancelDate": "YYYY-MM-DD",
        "subscriptionclosedDate": "YYYY-MM-DD",
        "publishDate": "YYYY-MM-DD",
        "published": true,
        "remarks": "Remarks for lessonBlock",
        "teacher": {
          "id": 2,
          "code": "JJ",
          "initials": "JJ",
          "firstName": "Jos",
          "middleName": "van",
          "lastName": "Janssen"
        },

Change format fields startTime endTime in array lessonBlocks

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

  

CourseGroup calls

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

  

Debtor calls

/debtor/financial/{id} Same type/logic/label for 'automatische incasso' in Participant calls and Debtor Financial call

/debtor/financial/{id} Added fields from CursAd table 'faktuu'

  "invoices": [
    {
      "invoiceSeason": "2019",
      "firstInvoiceMonth": "Jan.",
      "invoiceNumber": "string",
      "invoiceDate": "YYYY-MM-DD",
      "invoiceTerms": 5,
      "invoiceTermsOpen": 3,
      "invoiceTermsOpenMonths": "Jan/Apr/Jun",
      "invoiceAmountOpenPeriod": "15.29",
      "invoiceAmountOpen": "63.48",
      "invoiceAmountNet": "123.45",
      "invoiceAmountVAT": "31.67",
      "invoiceHighVAT": "21.00",
      "invoiceAmountVATHigh": "31.67",
      "invoiceLowVAT": "9.00",
      "invoiceAmountVATLow": "11.22",
      "AutoIncasso": false,
      "Reminders": true,
      "Printed": true,

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

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

 

Participant calls

Added fields to Participant calls

  "financials": {
    "amountInvoiced": "105.85",
    "AutoIncasso": false,
    "firstInvoiceMonth": "Jan.",
    "numberInvoicedMonths": "1",
    "monthsPeriods": "Jan/Apr/Jun",
    "monthsPeriodsInvoiced": "Nov/Dec",
    "codeVat": "hoog",
    "descVat": "21%",
    "codeVariation": "J6-12",
    "descVariation": "Jeugd 6-12 jaar"
  }

Same type/logic/label for 'automatische incasso' in Participant calls and Debtor Financial call

Cast field 'lestijd' to float

Incorrect WHERE clause ( due to MariaDB update )

Added WHERE clause to Participant calls - only active records

  

School calls

 

Student calls

 

Subscription calls

 

Subscription Education calls

Changed definition for DLN-LL field in magimp

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