var retStr = "Failed";
var dateTimeStamp = Now();
// Get the generated Events records from the Event Element and the Event datetime properties
var dataQry = application.ptCalendar.calEventsDAO.getEventsUnion(
startDate=arguments.startDate
,endDate=arguments.endDate
);
retStruct = writeCacheData(cacheQry=dataQry,dateTimeStamp=dateTimeStamp);
if ( StructKeyExists(retStruct,"msg") )
retStr = retStruct.msg;
return retStr;
var retStr = "false";
var memResult = deleteCacheData();
var keyResult = removeCacheDataKeys();
// Remove the ptCalendarCache events key
//if ( StructKeyExists(application.ptCalendarCache,"events") )
// StructDelete(application.ptCalendarCache,"events");
// Remove the ptCalendarCache eventsCacheUpdateDateTime key
//if ( StructKeyExists(application.ptCalendarCache,"eventsCacheUpdateDateTime") )
// StructDelete(application.ptCalendarCache,"eventsCacheUpdateDateTime");
if ( StructKeyExists(memResult,"MSG") )
retStr = memResult.MSG;
return retStr;
var retQry = QueryNew('tmp');
// Get the events records from application.ptCalendarCache.events data cache;
retQry = readCacheData();
if ( IsDate(arguments.startDate) AND retQry.recordCount GT 0 )
retQry = getEventsQueryDirect(startDate=arguments.startDate,endDate=arguments.endDate,rebuildFieldCache=arguments.rebuildFieldCache);
return retQry;
var dataQry = QueryNew("tmp");
var retStruct = { 'error_msg': '', 'qry': dataQry, 'status': false, 'recordCount': 0 };
var sqlcmdtext = "";
var keyArray = ArrayNew(1);
var i = 1;
var eventsFieldStruct = {};
var dateTimefieldStruct = {};
var sqlResult = {};
if ( NOT IsDate(arguments.startDate) )
arguments.startDate = '';
if ( NOT IsDate(arguments.endDate) )
arguments.endDate = '';
// New Event Field Struct Caching
eventsFieldStruct = application.ptCalendar.calEventDetailsDAO.getEventDetailsFieldStruct(rebuildFieldCache=arguments.rebuildFieldCache);
// New DateTime Field Struct Caching
dateTimefieldStruct = application.ptCalendar.calEventDateTimeDAO.getDateTimeFieldStruct(rebuildFieldCache=arguments.rebuildFieldCache);
// Combine both field structs into one
StructAppend(eventsFieldStruct, dateTimefieldStruct, false);
// Convert the keys from the field struct into an array so we can count the length
if ( NOT StructIsEmpty(eventsFieldStruct) )
keyArray = StructKeyArray(eventsFieldStruct);
SELECT
#keyArray[i]#,
FROM #tableName#
WHERE 1 = 1
AND CAST( eventDate AS DATE )
BETWEEN CAST( AS DATE )
AND CAST( AS DATE )
AND CAST( eventDate AS DATE ) >= CAST( AS DATE )
retStruct.qry = dataQry;
retStruct.recordCount = dataQry.recordCount;
retStruct.status = true;
retStruct.cmd = sqlResult.sql;
retStruct.error_msg = cfcatch.message;
retStruct.status = false;
retStruct.msg = retStruct.error_msg;
retStruct.details = cfcatch.detail;
retStruct.cmd = sqlResult.sql;
doErrorLogging("App","memoryCache.getEventsQueryDirect",retStruct);
var retStruct = StructNew();
var retFlag = false;
var dateTimeStamp = Now();
var dataQry = QueryNew("temp");
var cachedEventQry = getEvents(); // QofQ of the Cached Event Records
//var cachedEventQry = application.ptCalendarCache.events; // This would be without IsQuery protection
// Generate the LIVE unCached events records
var newEventsQry = application.ptCalendar.calEventsDAO.getEventsByEventID(
eventID=arguments.eventID,
useCache=false
);
SELECT cachedEventQry.*
FROM cachedEventQry
UNION
SELECT newEventsQry.*
FROM newEventsQry
ORDER BY eventDate, AllDay DESC, StartTime
retStruct = writeCacheData(cacheQry=cachedEventQry,dateTimeStamp=dateTimeStamp);
if ( StructKeyExists(retStruct,"status") )
retFlag = retStruct.status;
return retFlag;
var dateTimeStamp = Now();
// Remove events cache records by EventID
var deleteEvents = deleteEventCacheRecord(
eventID=arguments.eventID
);
// Create new events cache records by EventID
var addEvents = addEventCacheRecord(
eventID=arguments.eventID
);
//Updating the timestamp and data is handled by the add and delete functions
return true;
var retStruct = StructNew();
var retFlag = false;
var dateTimeStamp = Now();
var dataQry = QueryNew("temp");
var cachedEventQry = getEvents(); // QofQ of the Cached Event Records
//var cachedEventQry = application.ptCalendarCache.events; // This would be without IsQuery protection
SELECT *
FROM cachedEventQry
WHERE 1 = 1
AND calEventID <>
ORDER BY eventDate, AllDay DESC, StartTime
retStruct = writeCacheData(cacheQry=cachedEventQry,dateTimeStamp=dateTimeStamp);
if ( StructKeyExists(retStruct,"status") )
retFlag = retStruct.status;
var retStruct = StructNew();
var retFlag = false;
var dateTimeStamp = Now();
var dataQry = QueryNew("temp");
var cachedEventQry = getEvents(); // Cached Event Records
SELECT *
FROM cachedEventQry
WHERE 1 = 1
AND dtHashID <>
ORDER BY eventDate, AllDay DESC, StartTime
retStruct = writeCacheData(cacheQry=cachedEventQry,dateTimeStamp=dateTimeStamp);
if ( StructKeyExists(retStruct,"status") )
retFlag = retStruct.status;
return retFlag;
var retStruct = StructNew();
var dateTimeStamp = Now();
var cachedQry = QueryNew('temp');
retStruct = writeCacheData(cacheQry=cachedQry,dateTimeStamp=dateTimeStamp);
return retStruct;
// Get the cache records from application.ptCalendarCache.events;
if ( StructKeyExists(application,"ptCalendarCache") AND StructKeyExists(application.ptCalendarCache,"events") AND IsQuery(application.ptCalendarCache.events) )
retQry = application.ptCalendarCache.events;
var retStruct = StructNew();
if ( NOT StructKeyExists(application,"ptCalendarCache") )
application.ptCalendarCache = StructNew();
application.ptCalendarCache.events = arguments.cacheQry;
application.ptCalendarCache.eventsCacheUpdateDateTime = arguments.dateTimeStamp;
retStruct.status = true;
retStruct.msg = "Success";
return retStruct;
// Remove the ptCalendarCache events key
if ( StructKeyExists(application.ptCalendarCache,"events") )
StructDelete(application.ptCalendarCache,"events");
// Remove the ptCalendarCache eventsCacheUpdateDateTime key
if ( StructKeyExists(application.ptCalendarCache,"eventsCacheUpdateDateTime") )
StructDelete(application.ptCalendarCache,"eventsCacheUpdateDateTime");
retStr = true;