To use the old function names until they are all replaced by the new ones, you can temporarily declare these old functions in Setup -> Header:
Code: Select all
Date.prototype.addDays = function (days) {
var date = new Date(this.valueOf());
date.setDate(date.getDate() + days);
return date;
}
String.prototype.ltrim = function () {
return this.replace(/^\s+/, "");
}
String.prototype.rtrim = function () {
return this.replace(/\s+$/, "");
}
String.prototype.fixNbsp = function () {
return this.replace(/\xA0/g, " ")
}
String.prototype.capitalise = function () {
return this.charAt(0).toUpperCase() + this.slice(1);
}
String.prototype.toTitleCase = function () {
return this.toLowerCase().replace(/^(\w)|\s(\w)/g, (grp) => grp.toUpperCase());
}
String.prototype.justNumbers = function () {
return this.replace(/[^0-9]/g, '');
}
String.prototype.withoutNumbers = function () {
return this.replace(/\d+/g, '');
}
Date.prototype.withoutTime = function () {
let d = new Date(this);
d.setHours(0, 0, 0, 0);
return d;
}
function nuBase64decode(str) {
const text = atob(str);
const length = text.length;
const bytes = new Uint8Array(length);
for (let i = 0; i < length; i++) {
bytes[i] = text.charCodeAt(i);
}
const decoder = new TextDecoder(); // default is utf-8
return decoder.decode(bytes);
}
function nuBase64encode(str) {
let encode = encodeURIComponent(str).replace(/%([a-f0-9]{2})/gi, (m, $1) => String.fromCharCode(parseInt($1, 10)))
return btoa(encode);
To identify forms or events that still use the old functions, you can run the following queries on your database:
Search Form Custom Code:
Code: Select all
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'getTabIndexByTitle' AS OldFunctionName FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '% getTabIndexByTitle%' OR
`sfo_edit_javascript` LIKE '% getTabIndexByTitle%' OR
`sfo_browse_javascript` LIKE '% getTabIndexByTitle%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'toTitleCase' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.toTitleCase%' OR
`sfo_edit_javascript` LIKE '%.toTitleCase%' OR
`sfo_browse_javascript` LIKE '%.toTitleCase%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'capitalise' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.capitalise%' OR
`sfo_edit_javascript` LIKE '%.capitalise%' OR
`sfo_browse_javascript` LIKE '%.capitalise%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'cssNumber' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.cssNumber%' OR
`sfo_edit_javascript` LIKE '%cssNumber%' OR
`sfo_browse_javascript` LIKE '%.cssNumber%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'enterKey' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.enterKey%' OR
`sfo_edit_javascript` LIKE '%.enterKey%' OR
`sfo_browse_javascript` LIKE '%.enterKey%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'addDays' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.addDays%' OR
`sfo_edit_javascript` LIKE '%.addDays%' OR
`sfo_browse_javascript` LIKE '%.addDays%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'withoutTime' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.withoutTime%' OR
`sfo_edit_javascript` LIKE '%.withoutTime%' OR
`sfo_browse_javascript` LIKE '%.withoutTime%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'withoutNumber' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.withoutNumber%' OR
`sfo_edit_javascript` LIKE '%.withoutNumber%' OR
`sfo_browse_javascript` LIKE '%.withoutNumber%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'isEmpty' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.isEmpty%' OR
`sfo_edit_javascript` LIKE '%.isEmpty%' OR
`sfo_browse_javascript` LIKE '%.isEmpty%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'justNumbers' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.justNumbers%' OR
`sfo_edit_javascript` LIKE '%.justNumbers%' OR
`sfo_browse_javascript` LIKE '%.justNumbers%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'fixNbsp' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%.fixNbsp%' OR
`sfo_edit_javascript` LIKE '%.fixNbsp%' OR
`sfo_browse_javascript` LIKE '%.fixNbsp%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'hex2rgb' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%hex2rgb%' OR
`sfo_edit_javascript` LIKE '%hex2rgb%' OR
`sfo_browse_javascript` LIKE '%hex2rgb%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'ColorToHex' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%ColorToHex%' OR
`sfo_edit_javascript` LIKE '%ColorToHex%' OR
`sfo_browse_javascript` LIKE '%ColorToHex%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'nuBase64decode' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%nuBase64decode%' OR
`sfo_edit_javascript` LIKE '%nuBase64decode%' OR
`sfo_browse_javascript` LIKE '%nuBase64decode%'
UNION
SELECT 'Form Custom Code', `zzzzsys_form_id`, CONCAT( `sfo_code`, ' / ', `sfo_description`) , 'nuBase64encode' FROM `zzzzsys_form`
WHERE `sfo_javascript` LIKE '%nuBase64encode%' OR
`sfo_edit_javascript` LIKE '%nuBase64encode%' OR
`sfo_browse_javascript` LIKE '%nuBase64encode%';
Search Object Events:
Code: Select all
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'getTabIndexByTitle' AS OldFunctionName
FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '% getTabIndexByTitle%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'toTitleCase' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.toTitleCase%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'capitalise' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.capitalise%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'cssNumber' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.cssNumber%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'enterKey' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.enterKey%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'addDays' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.addDays%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'withoutTime' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.withoutTime%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'withoutNumber' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.withoutNumber%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'isEmpty' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.isEmpty%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'justNumbers' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.justNumbers%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'fixNbsp' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%.fixNbsp%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'hex2rgb' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%hex2rgb%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'ColorToHex' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%ColorToHex%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'nuBase64decode' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%nuBase64decode%'
UNION
SELECT 'Object Event', zzzzsys_event_id, sev_zzzzsys_object_id, 'nuBase64encode' FROM `zzzzsys_event`
WHERE `sev_javascript` LIKE '%nuBase64encode%'