Adding Timeslots to datastore
Jump to navigation
Jump to search
This script creates time slots in a datastore on a given date between 2 given hours with a given number of minutes between the slots.
//var FORMFIELD_DATUM = #1#; //formatted as YYYYMMDD
//var FORMFIELD_TIJDSTIPVAN = #2#;
//var FORMFIELD_TIJDSTIPTOT = #3#;
//var FORMFIELD_DUUR = #4#-0;
var FORMFIELD_DATUM = #REPLACE-FORMFIELD-Datum%yyyyMMdd#; //formatted as YYYYMMDD
var FORMFIELD_TIJDSTIPVAN = #REPLACE-FORMFIELD-Starttijd||Tijdstip#;
var FORMFIELD_TIJDSTIPTOT = #REPLACE-FORMFIELD-Eindtijd||Tijdstip#;
var FORMFIELD_DUUR = #REPLACE-FORMFIELD-LengteTijdsblokken||Code#-0;
var runningDate = new Date();
runningDate.setFullYear(FORMFIELD_DATUM.substring(0,4));
runningDate.setMonth(FORMFIELD_DATUM.substring(4,6)-1);
runningDate.setDate(FORMFIELD_DATUM.substring(6,8));
runningDate.setHours(FORMFIELD_TIJDSTIPVAN.substring(0,2), FORMFIELD_TIJDSTIPVAN.substring(3,5),0,0);
var endDate = new Date();
endDate.setFullYear(FORMFIELD_DATUM.substring(0,4));
endDate.setMonth(FORMFIELD_DATUM.substring(4,6)-1);
endDate.setDate(FORMFIELD_DATUM.substring(6,8));
endDate.setHours(FORMFIELD_TIJDSTIPTOT.substring(0,2), FORMFIELD_TIJDSTIPTOT.substring(3,5),0,0);
var entriesAdded = 0;
var entryDateFrom = null;
var entryDateTo = null;
var werkDatumMaand = '0' + runningDate.getMonth()+1;
werkDatumMaand = werkDatumMaand.substring(0,2);
//Maak datum leeg
CommonInterface.deleteParameterEntries('RDW - Terugbel - tijdstippen', { 'Datum': FORMFIELD_DATUM });
while (runningDate < endDate && entriesAdded < 1000) {
CommonInterface.addParameterEntry('RDW - Terugbel - tijdstippen', { 'Datum': FORMFIELD_DATUM, 'Tijdstip': runningDate.getHours().toString().padStart(2, '0')+":"+ runningDate.getMinutes().toString().padStart(2, '0'), 'Status': 'Open', 'DatumddMMyyyy': runningDate.getDate().toString().padStart(2, '0')+"/"+String(runningDate.getMonth()+1).toString().padStart(2, '0')+"/"+runningDate.getFullYear().toString().padStart(4, '0')});
runningDate.setMinutes(runningDate.getMinutes() + FORMFIELD_DUUR);
entriesAdded++;
}
return('Entries added: '+entriesAdded);