var catCom = server.CommonSpot.api.getObject('Categories'); var catQry = catCom.getList(type="Document"); SELECT NAME FROM catQry WHERE id = if ( catQry.recordCount ) return catQry.NAME; else return ""; SELECT CategoryTypeID FROM generalCategories WHERE category = if ( catQry.recordCount ) return catQry.categoryTypeID; else return ""; var q = QueryNew("temp"); var rStr = ""; select ShortDesc from AvailableTemplates Where PageID = if ( q.recordcount ) rStr = q.ShortDesc; return rStr; select id, groupname from idgroup var retData = {}; var linkURL = ''; var newWindowName = ''; var newWindowParams = ''; var pageID = getPageIDfromCSExtURLStr(str=arguments.str); var Bookmark = ''; var LinkType = ''; var subSiteid = ''; var LinkDisplay = ''; var LinkPageID = ''; retData.pageid = pageID; retData.url = arguments.str; retData.target = ''; //newWindowName retData.targetprops = ''; //newWindowParams retData.onclick = ''; retData.bookmark = ''; //linkPageJump retData.subsiteid = ''; retData.linktype = ''; //retData.linkPageID = ''; //PageID //retData.linkPageJump = ''; //Bookmark //retData.linkDisplay = ''; //LinkDisplay (seems to be the same as url) //retData.linkSubSiteID = ''; //subSiteid if ( IsNumeric(arguments.str) ) arguments.str = parseCSURL(str=arguments.str,useLogging=arguments.useLogging); if ( arguments.useLogging AND FindNoCase('broken-link-',arguments.str,1) ) { retData.url = arguments.str; return retData; } try { cfmodule(template="/commonspot/utilities/ct-decipher-linkurl.cfm" ,URL=arguments.str ,VarName="linkURL" ,LinkNewWindowNameVar="newWindowName" ,LinkNewWindowParamsVar="newWindowParams" ,LinkPageJumpVar = 'bookmark' ,LinkTypeVar = 'LinkType' ,LinkSubSiteIDVar = 'subSiteid' ,DisplayVarName = 'LinkDisplay' ,LinkPageIDVar = 'LinkPageID' ); } catch (any ex) { if ( arguments.useLogging ) { // Set the targetURL to the broken-link-{pageid} text linkURL = "broken-link-#arguments.str#--see-logs"; if ( IsNumeric(arguments.str) ) errorStr = "CS Page ID: #arguments.str#"; else errorStr = "URL: #arguments.str#"; // Create Log Msg logMsg = "[csData_2_0.parseCSExtURLData] Error attempting to decipher #errorStr# using the ct-decipher-linkurl module#Chr(10)##ex.message#"; if ( StructKeyExists(ex,"detail") AND LEN(TRIM(ex.detail)) ) logMsg = logMsg & "#Chr(10)#Details: #ex.detail#"; server.ADF.objectFactory.getBean("log_1_0").logAppend(logMsg); } } retData.url = linkURL; retData.bookmark = Bookmark; retData.linktype = LinkType; retData.subsiteid = subSiteid; if ( LinkType EQ 'newTab' AND TRIM(newWindowParams) EQ '' ) newWindowParams = 'useTab=1'; retData.target = newWindowName; retData.targetprops = newWindowParams; if ( LinkType EQ 'newWindow' AND TRIM(newWindowParams) EQ '' ) retData.onClick = "csExtendedWindow('#newWindowName#','#linkURL#','#newWindowParams#'); return false;"; // Old CS newwindow // retData.onclick = "javascript:doWindowOpen('#linkURL#','#newWindowName#','#newWindowParams#'); return false;"; //retData.LinkPageID = LinkPageID; //retData.LinkPageJump = LinkPageJump; //retData.LinkDisplay = LinkDisplay; return retData; var reHTML = ''; var useStyleSheets = false; if ( StructKeyExists(Request,"Page") AND StructKeyExists(Request.Page,"UseStyleSheets") ) useStyleSheets = Request.Page.UseStyleSheets; return reHTML; var retData = StructNew(); var hrefArray = parseLinksInHTML(str=arguments.linkHTML); retData['href'] = ''; retData['onclick'] = ''; retData['target'] = ''; retData['title'] = ''; retData['alt'] = ''; retData['class'] = ''; retData['id'] = ''; retData['style'] = ''; if ( ArrayLen(hrefArray) ) retData = hrefArray[1]; return retData; var retArr = ArrayNew(1); var retData = StructNew(); var tagToolsObj = CreateObject("java","com.paperthin.common.html.TagTools").init(Server.CommonSpot.UDF.util.getBean("")); var hrefArray = ArrayNew(1); if ( LEN(TRIM(arguments.str)) ) { hrefArray = tagToolsObj.FindTags(arguments.str,"href"); for ( i=1; i <= ArrayLen(hrefArray); i++ ) { if ( StructKeyExists(hrefArray[i],"TagAttrs") ) { retData = StructNew(); retData['href'] = ''; retData['onclick'] = ''; retData['target'] = ''; retData['title'] = ''; retData['alt'] = ''; retData['class'] = ''; retData['id'] = ''; retData['style'] = ''; for ( key IN hrefArray[i].TagAttrs ){ retData[key] = hrefArray[i].TagAttrs[key]; } } ArrayAppend(retArr,retData); } } return retArr; var qry = QueryNew("temp"); var metadataFormObj = Server.CommonSpot.ObjectFactory.getObject('MetadataForm'); var allMetadataForms = metadataFormObj.getForms(); SELECT ID, CAST(FormName AS VARCHAR) AS Name FROM allMetadataForms WHERE FormName = var qry = QueryNew("temp"); var metadataFormObj = Server.CommonSpot.ObjectFactory.getObject('MetadataForm'); var allMetadataForms = metadataFormObj.getForms(); SELECT ID, CAST(FormName AS VARCHAR) AS Name FROM allMetadataForms WHERE ID = var subsiteData = application.ADF.csData.getSubsiteQueryByID(subsiteID=arguments.subsiteID); var retURL = Replace(request.site.url, request.site.CP_URL, "") & subsiteData.SubSiteURL; return retURL; var retData = {}; if ( IsNumeric(arguments.imageIdOrCPimageStr) ) retData = getImageInfoByImageID(imageid=arguments.imageIdOrCPimageStr); else retData = getImageInfoByCPIMAGE(cpimage=arguments.imageIdOrCPimageStr); return retData; var retData = {}; var imageData = {}; var imgID = arguments.imageid; var imgComponent = Server.CommonSpot.api.getObject('image'); var csVersion = server.ADF.csVersion; var isCS107plus = application.ADF.utils.minimumVersionCheck(version=csVersion,minimumVersionsList="10.7"); // Only available for CommonSpot 10.7 and above if ( isCS107plus ) { if( IsNumeric(imgID) AND imgID GT 0 ) { try { retData = imgComponent.getRenderInfo(imageID=imgID); } catch ( any expt ) { if ( StructKeyExists(expt,"message") AND LEN(TRIM(expt.message)) ) retData.errorMsg = expt.message; } } } else retData.errorMsg = "The getCSImageInfo() method can only be used with CommonSpot 10.7 or above!"; return retData; var retData = {}; var imgID = ""; // Get the ImageID from the CPIMAGE string imgID = parseCPIMAGE(cpimage=arguments.cpimage); if ( IsNumeric(imgID) ) retData = getImageInfoByImageID(imageID=imgID); else retData.errorMsg = "The getImageInfoByCPIMAGE() method requires a CPIMAGE string"; return retData; var retData = {}; var imgIDStr = arguments.imageidOrCpimage; var imgSize = arguments.sizeNameOrPosition; var imgData = {}; var imgSizeData = {}; var imgGenRes = {}; var imgComponent = Server.CommonSpot.api.getObject('image'); var csVersion = server.ADF.csVersion; var isCS107plus = application.ADF.utils.minimumVersionCheck(version=csVersion,minimumVersionsList="10.7"); var RenderWebP = 0; retData.imageid = 0; retData.imageURL = ''; retData.imageURL_webP = ''; retData.alt = ''; retData.title = ''; retData.sizeCount = 0; retData.sizeKeys = []; retData.size = 1; // Only available for CommonSpot 10.7 and above if ( isCS107plus ) { // Get the ImageData struct if ( IsStruct(arguments.imageStruct) AND !StructIsEmpty(arguments.imageStruct) AND StructKeyExists(arguments.imageStruct,'imageid') ) imgData = arguments.imageStruct; else if ( !IsNumeric(imgIDStr) AND LEN(TRIM(imgIDStr)) GT 0 AND FindNoCase('cpimage',imgIDStr) ) imgData = getImageInfoByCPIMAGE(cpimage=imgIDStr); // from the CPIMAGE string else if ( IsNumeric(imgIDStr) AND imgIDStr GT 0 ) imgData = getImageInfoByImageID(imageid=imgIDStr); // from the IMAGEID value if ( IsStruct(imgData) AND !StructIsEmpty(imgData) ) { if ( StructKeyExists(imgData,'RenderWebP') ) RenderWebP = imgData.RenderWebP; if ( StructKeyExists(imgData,'imageid') ) retData.imageid = imgData.imageid; if ( StructKeyExists(imgData,'AltText') ) retData.alt = imgData.AltText; if ( StructKeyExists(imgData,'TitleText') ) retData.title = imgData.TitleText; if ( StructKeyExists(imgData,"Images") AND IsArray(imgData.Images) ) retData.sizeCount = ArrayLen(imgData.Images); if ( StructKeyExists(imgData,"ImageSizes") AND IsStruct(imgData.ImageSizes) ) retData.sizeKeys = structKeyArray(imgData.ImageSizes); // If keywords, largest or smallest are used... find the image position (imgPos) and clear the imgSize if ( !IsNumeric(imgSize) ) { if ( imgSize EQ "largest" OR imgSize EQ "smallest") { if ( retData.sizeCount GT 0 ) { if (imgSize EQ "largest") imgSize = 1; else if ( imgSize EQ "smallest" ) imgSize = retData.sizeCount; } } else imgSize = TRIM(imgSize); } if ( IsNumeric(imgSize) AND StructKeyExists(imgData,"Images") AND IsArray(imgData.Images) AND ArrayLen(imgData.Images) GT 0 AND imgSize LTE retData.sizeCount ) { // Get the Array item at the imgSize position imgSizeData = imgData.Images[imgSize]; retData.imageURL = parseStandardImageUrlData(imageUrlData=imgSizeData); retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgSizeData); } else if ( LEN(TRIM(imgSize)) AND StructKeyExists(imgData,"ImageSizes") AND StructKeyExists(imgData.ImageSizes,imgSize) ) { imgSizeData = imgData.ImageSizes[imgSize]; retData.imageURL = parseStandardImageUrlData(imageUrlData=imgSizeData); retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgSizeData); } else if ( StructKeyExists(imgData,'ResolvedURL') ) { //imgData = imgData.ResolvedURL; retData.imageURL = parseStandardImageUrlData(imageUrlData=imgData); retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgData); } // Generate if WebP does not exist if ( RenderWebP AND LEN(TRIM(retData.imageURL_webP)) EQ 0 ) { imgGenRes = imgObj.generateWebP(imageID=retData.imageid,skipIfExists=1); if ( ImgGenRes.StatusCode GT 0 ) { imgData = ImgGenRes.ImageInfo; if ( LEN(TRIM(imgSize)) AND StructKeyExists(imgData,"ImageSizes") AND StructKeyExists(imgData.ImageSizes,imgSize) ) { imgSizeData = imgData.ImageSizes[imgSize]; retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgSizeData); } else if ( IsNumeric(imgPos) AND StructKeyExists(imgData,"Images") AND ArrayLen(imgData.Images) GT 0 AND ArrayLen(imgData.Images) LTE imgPos ) { imgSizeData = imgData.Images[imgPos]; retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgSizeData); } else if ( StructKeyExists(imgData,'ResolvedURL') ) { imgData = imgData.ResolvedURL; retData.imageURL_webP = parseWebPImageUrlData(imageUrlData=imgData); } } } // end - RenderWebP logic if ( LEN(TRIM(imgSize)) ) retData.size = imgSize; } // end - IsStruct logic else retData.errorMsg = "No Image Data was returned from the provided imageid, cpimage or imageStruct!"; } else retData.errorMsg = "The getParsedImageData() method can only be used with CommonSpot 10.7 or above!"; return retData; var imgUrlStr = ''; var imgData = arguments.imageUrlData; var csVersion = server.ADF.csVersion; var isCS107plus = application.ADF.utils.minimumVersionCheck(version=csVersion,minimumVersionsList="10.7"); if ( StructKeyExists(imgData,'ResolvedURL') ) imgData = imgData.ResolvedURL; if ( isCS107plus ) { if ( StructKeyExists(imgData,'ImageFound') AND imgData.ImageFound AND StructKeyExists(imgData,'serverRelative') ) imgUrlStr = imgData.serverRelative; } else { if ( StructKeyExists(imgData,'serverRelative') ) imgUrlStr = imgData.serverRelative; } return imgUrlStr; var imgUrlStr = ''; var imgData = arguments.imageUrlData; var csVersion = server.ADF.csVersion; var isCS107plus = application.ADF.utils.minimumVersionCheck(version=csVersion,minimumVersionsList="10.7"); if ( StructKeyExists(imgData,'ResolvedURL') ) imgData = imgData.ResolvedURL; if ( isCS107plus ) { if ( StructKeyExists(imgData,'ImageFound_WebP') AND imgData.ImageFound_WebP AND StructKeyExists(imgData,'serverRelative_webP') ) imgUrlStr = imgData.serverRelative_webP; } return imgUrlStr; var custMD = Duplicate(arguments.metadata); var imageComponent = server.CommonSpot.api.getObject('Image'); var key = ''; var subKey = ''; var pageIDfld = ''; var imgPathfld = ''; var imgIDfld = ''; var imageID = ''; var imgData = ''; var skipFld = false; // Loop over the struct for ( key IN custMD ){ // Loop over the fields in the form for ( subKey IN custMD[key] ){ pageIDfld = subKey & "_PAGEID"; imgPathfld = subKey & "_IMAGEPATH"; if ( StructKeyExists(custMD[key],pageIDfld) ) { imageID = custMD[key][pageIDfld]; if ( IsNumeric(imageID) AND imageID GT 0 ) { try { imgData = imageComponent.getInfo(imageid=imageID); if ( IsStruct(imgData) AND NOT StructIsEmpty(imgData) ) { custMD[key][imgPathfld] = custMD[key][subKey]; custMD[key][subKey] = imageID; } } catch (any ex) { // Not a valid ImageID skipFld = true; } } } } } return custMD; var retQry = ''; var grpObj = Server.CommonSpot.api.getObject('Groups'); var dataQry = ''; var usersQry = ''; var userID = ''; var tempQry = ''; var chkRetQry = ''; //var isACF = ( FindNoCase(cfmlEngineType,'ColdFusion Server') ) ? true : false; dataQry = grpObj.getMembers(groupIDList=arguments.groupIDList); retQry = QueryNew(dataQry.ColumnList); for ( var i = 1; i <= dataQry.RecordCount; i++ ) { if ( dataQry.Type[i] EQ "Group" ) { usersQry = getCsGroupUsersQry(groupIdList=dataQry.id[i]); for ( var u = 1; u <= usersQry.RecordCount; u++ ) { userID = usersQry.id[u]; // Check the retQry for the userid chkRetQry = queryExecute( "SELECT * FROM retQry WHERE id = :id", { id = userID, cfsqltype="cf_sql_integer" }, { dbtype="query" } ); if ( chkRetQry.RecordCount EQ 0 ) { // Get the user details from usersQry tempQry = queryExecute( "SELECT * FROM usersQry WHERE id = :id", { id = userID, cfsqltype="cf_sql_integer" }, { dbtype="query" } ); // Add the user details to the retQry retQry = variables.data.QueryAppend(QueryOne=retQry, QueryTwo=tempQry, UnionAll=false); //if ( isACF ) // CF 2018+ Only - QueryAppend(retQry, tempQry); } } } else if ( dataQry.Type[i] EQ "user" ) { userID = dataQry.id[i]; // Check the retQry for the userid chkRetQry = queryExecute( "SELECT * FROM retQry WHERE id = :id", { id = userID, cfsqltype="cf_sql_integer" }, { dbtype="query" } ); if ( chkRetQry.RecordCount EQ 0 ) { // Get the user details from dataQry tempQry = queryExecute( "SELECT * FROM dataQry WHERE id = :id", { id = userID, cfsqltype="cf_sql_integer" }, { dbtype="query" } ); // Add the user details to the retQry retQry = variables.data.QueryAppend(QueryOne=retQry, QueryTwo=tempQry, UnionAll=false); //if ( isACF ) // CF 2018+ Only - QueryAppend(retQry, tempQry); } } } return retQry; var retVal = 0; var imgData = getCsImageDataByFilename(filename=arguments.filename); if ( StructKeyExists(imgData,"id") AND imgData.id GT 0 ) retVal = imgData.id; return retVal; var retVal = 0; var imgData = getCsImageDataByTitle(title=arguments.title); if ( StructKeyExists(imgData,"id") AND imgData.id GT 0 ) retVal = imgData.id; return retVal; var retStruct = { 'id': 0, 'filename': '', 'title': '', 'subsiteID': 0, 'SubsiteUrl': '', 'DocType': '' }; var imgQry = QueryNew('tmp'); SELECT sp.id, sp.subsiteID, sp.filename, sp.title, sp.DocType, ss.SubsiteUrl FROM SitePages sp JOIN Subsites ss ON ss.id = sp.subsiteID WHERE FileName = AND ss.id = if ( imgQry.RecordCount ) { retStruct = QueryGetRow(imgQry, 1); /* retStruct = { 'id': imgQry.id[1], 'filename': imgQry.filename[1], 'title': imgQry.title[1], 'subsiteID': imgQry.subsiteID[1], 'SubsiteUrl': imgQry.SubsiteUrl[1], 'DocType': imgQry.DocType[1] };*/ retStruct.ImgInfo = Server.CommonSpot.UDF.image.getInfo(retStruct.id); retStruct.ImgURL = "#Request.SubsiteCache[csImgInfo.subsiteID].imagesURL##csImgInfo.filename#"; } return retStruct; var retStruct = { 'id': 0, 'filename': '', 'title': '', 'subsiteID': 0, 'SubsiteUrl': '', 'DocType': '' }; var imgQry = QueryNew('tmp'); var imgID = 0; SELECT sp.id, sp.subsiteID, sp.filename, sp.title, sp.DocType, ss.SubsiteUrl FROM SitePages sp JOIN Subsites ss ON ss.id = sp.subsiteID WHERE title= AND ss.id = if ( imgQry.RecordCount ) { retStruct = QueryGetRow(imgQry, 1); retStruct.ImgInfo = Server.CommonSpot.UDF.image.getInfo(retStruct.id); retStruct.ImgURL = "#Request.SubsiteCache[csImgInfo.subsiteID].imagesURL##csImgInfo.filename#"; } return retStruct; var ext = ''; // normalizeFilename adds dashes arguments.str = Server.CommonSpot.UDF.util.normalizeFilename(sourceString=arguments.str,allowExtension=arguments.preserveExtension); if ( arguments.addDashes ) { if ( arguments.preserveExtension AND ListLen(arguments.str,".") GT 1 ) { ext = ListLast(arguments.str,"."); arguments.str = Mid(arguments.str,1,(Len(arguments.str) - Len(ext) - 1)); } arguments.str = REReplace(arguments.str,"[^[:alnum:]]+","-","ALL"); if ( ext NEQ '' ) arguments.str = arguments.str & '.' & ext; } // Check if we want the output string to be converted to lowercase if ( arguments.makeLowercase ) arguments.str = LCase(arguments.str); return arguments.str; var retData = {}; var imageData = {}; var imgURL = arguments.imageURL; var imgComponent = Server.CommonSpot.api.getObject('image'); var csVersion = server.ADF.csVersion; var isCS107plus = application.ADF.utils.minimumVersionCheck(version=csVersion,minimumVersionsList="10.7"); // Only available for CommonSpot 10.7 and above if ( isCS107plus ) { if( len(arguments.imageURL) ) { try { imageFilename = listlast(imageURL,'/'); imagePath = listDeleteAt(imageURL,listlen(imageURL,'/'),'/') & '/'; sql = "SELECT sp.id FROM sitepages AS sp LEFT OUTER JOIN subsites AS ss ON ss.id = sp.subsiteid WHERE ss.ImagesURL = :subsiteURL AND sp.FileName = :imageFilename" qparams = structNew(); qparams.subsiteURL = { value=imagePath, cfsqltype="cf_sql_varchar" }; qparams.imageFilename = { value=imageFilename, cfsqltype="cf_sql_varchar" }; options = { datasource=request.site.datasource }; qryResult = queryExecute(sql, qparams, options); retData = imgComponent.getRenderInfo(imageID=qryResult.id); } catch ( any expt ) { if ( StructKeyExists(expt,"message") AND LEN(TRIM(expt.message)) ) retData.errorMsg = expt.message; } } } else retData.errorMsg = "The getImageInfoByImageURL() method can only be used with CommonSpot 10.7 or above!"; return retData;