/****************************************************************
** Licensed Materials - Property of IBM
**
** BI and PM: qs
**
** (C) Copyright IBM Corp. 2001, 2015
**
** US Government Users Restricted Rights - Use, duplication or
** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
*****************************************************************/
// Copyright (C) 2008 Cognos ULC, an IBM Company. All Rights Reserved.
// Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in the United States and/or other countries. IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both. Other company, product, or service names may be trademarks or service marks of others.
function changeDialog(oSelectElement)
{
if (oSelectElement === null || oSelectElement.options === null || oSelectElement.options.length <= 0)
{
return;
}
var sFilterDialogType = oSelectElement.options[oSelectElement.selectedIndex].value;
if (sFilterDialogType == "")
{
return;
}
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, getNullOption(), basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
}
else
{
getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, false, basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
}
};
function hideFilterOperation()
{
if (document.f.operation)
{
document.f.operation.style.display = "none";
}
};
function changeDateRangeDialog(oDateRangeElement)
{
var oSelectedElement = oDateRangeElement.options[oDateRangeElement.selectedIndex];
if (oSelectedElement === null)
{
return;
}
var sFilterDialogType = oSelectedElement.value;
if (sFilterDialogType == "")
{
return;
}
if ("filterDaysBeforeToday" == sFilterDialogType)
{
if ("selectDateTime" == complexFilterType)
{
cf.dlgGlobalSetParm("xxPreviousFilter", "filterDateTimeRange");
}
else
{
cf.dlgGlobalRemoveParm("xxPreviousFilter");
}
}
else if ("filterDateRange" == sFilterDialogType && "filterDateTimeRange" == cf.dlgGlobalGetParm("xxPreviousFilter"))
{
oSelectedElement.value = "filterDateTimeRange";
}
changeDialog(oDateRangeElement);
};
function removeExecute()
{
var oBtn = document.getElementById("executeButton");
if (oBtn)
{
oBtn.href = "#";
}
};
function submitFilterExpression(sFE)
{
if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
{
removeEnumChildrenFromFilter();
}
clearFilterConversionGlobals();
var oMQMgr = goDialogManager.getMiniQueryManager();
var oCol = oMQMgr.getColumnById(cf.dlgGlobalGetParm("xxColName"));
var sDetailAgg = oMQMgr.getDetailAggregate(oCol);
var sSummaryAgg = oMQMgr.getSummaryAggregate(oCol);
if (sSummaryAgg != "none" && (sDetailAgg == "count" || sDetailAgg == "countDistinct"))
{
sFE.m_nNode.setAttribute("postAutoAggregation","true");
}
else
{
sFE.m_nNode.setAttribute("postAutoAggregation","false");
}
if (cf.isDetailFilterEnabled())
{
submitFilter(sFE, onlyPrompt, (document.f.filterBasedOnDS && !document.f.filterBasedOnDS.checked));
}
else
{
submitFilter(sFE, onlyPrompt, true);
}
};
function submitFilter(fString, onlyPrompt, summaryFilter)
{
var cf = getConfigFrame();
var oCC = cf.getCombinedFilter();
if (oCC || cf.getFilterMode() != cf.giFILTERCPLXMODE_SIMPLE)
{
submitComplexFilter(fString, onlyPrompt, summaryFilter);
}
else
{
submitBasicFilter(fString, onlyPrompt, summaryFilter);
}
};
function submitBasicFilter(fString, onlyPrompt, summaryFilter)
{
var cf = getConfigFrame();
if (fString && typeof fString.getXML == 'function')
{
fString = fString.getXML();
}
var bIsNot = (fd_getNOT() == "true");
cf.dofc(fString, onlyPrompt, summaryFilter, bIsNot);
cf.hideDialogFrame();
cf.dlgGlobalReset();
};
function submitComplexFilter(fCondition, onlyPrompt, summaryFilter)
{
var oMQMgr = goDialogManager.getMiniQueryManager();
var cf = getConfigFrame();
var oCC = cf.getCombinedFilter();
var sSummary = "true";
var iMode = cf.getFilterMode();
var oF = null;
var oFG = null;
if (oCC == null)
{
oCC = cf.convertToCombinedFilter();
}
var fString = fCondition;
if (fCondition && typeof fCondition.getXML == 'function')
{
fString = fCondition.getXML();
}
if (fString.length <= 0 || fString == ("[" + getPromptId() + "]"))
{
if (!cf.dlgGlobalGetParm("xxNewFilter"))
{
oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
if (oF)
{
oF.removeSelf();
}
if (iMode == cf.giFILTERCPLXMODE_SIMPLE)
{
cf.addColumnsForReselection();
cf.sendCmd(oCC.getCommand(), "", true);
}
}
if (iMode != cf.giFILTERCPLXMODE_SIMPLE)
{
cf.dlgReset();
if (cf.isDetailFilterEnabled())
{
cf.dlgGlobalSetParm("xxAllowDetail", true);
}
cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
var sTab = cf.dlgGlobalGetParm("xxFCtab");
if (!sTab)
{
sTab = (oCC.getCurrentFilterGroup() == oCC.getSummaryFilter() ? 's': 'r');
}
cf.dlgGlobalSetParm("xxFCtab", sTab);
cf.dlgSetParm("m_tab", sTab);
cf.dlgSubmit();
}
else
{
cf.hideDialogFrame();
}
return;
}
if (this.summarizationValue)
{
if (this.summarizationValue == "raw")
{
sSummary = "none";
}
else if (this.summarizationValue == "details")
{
sSummary = "true";
}
else
{
var summaryValue = '';
if ( document.getElementById("summary") )
{
summaryValue = document.getElementById("summary").value;
if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
{
summaryValue = parseInt(summaryValue, 10);
}
}
sSummary = oMQMgr.getColumnId(summaryValue);
if (sSummary == oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
sSummary = "";
}
}
}
var filterBasedOnDS = document.getElementById("filterBasedOnDS");
if (filterBasedOnDS && filterBasedOnDS.checked && cf.isDetailFilterEnabled())
{
sSummary = "none";
}
var bFilterFromMetadata = (cf.dlgGlobalGetParm("xxFilterFromMetadata") === true);
if (iMode != cf.giFILTERCPLXMODE_SIMPLE || bFilterFromMetadata)
{
if (!cf.cfgGet("combinedFilters_default"))
{
cf.cfgSet("combinedFilters_default", oCC.clone());
}
cf.dlgReset();
if (sSummary == "none")
{
oCC.setFilterView(cf.giFILTERVIEW_RAW);
cf.dlgGlobalSetParm("xxFCtab", "r");
}
else
{
oCC.setFilterView(cf.giFILTERVIEW_SUMMARY);
cf.dlgGlobalSetParm("xxFCtab", "s");
}
if (fCondition && typeof fCondition.setDataItemName == 'function')
{
fCondition.setDataItemName(cf.dlgGlobalGetParm('xxColName'));
}
oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
if (oF == null || cf.dlgGlobalGetParm("xxNewFilter"))
{
var sFID = oCC.generateID();
var selColSize = cf.cfgSize("SelColumns");
var sel = cf.cfgGetAt("SelColumns", 0);
oF = new cf.CFilter(
sFID,
(bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFCid') : oMQMgr.getColumnId(sel)),
cf.gsFILTER_REFTYPE_COLUMN,
this.complexFilterType,
fCondition,
sSummary,
(bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFullColExpression') : fCondition)
);
oF.setNot(fd_getNOT());
oCC.getCurrentFilterGroup().addPredicate(oF);
oF.setDirty();
}
else if (oF != null)
{
oF.setCondition(fCondition);
oF.setSummary(sSummary);
oF.setNot(fd_getNOT());
oFG = oCC.getCurrentFilterGroup();
if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
{
oF.removeSelf();
oFG.addPredicate(oF);
}
}
if (cf.dlgGlobalGetParm("xxFCtab") != null)
{
cf.dlgSetParm("m_tab", cf.dlgGlobalGetParm("xxFCtab"));
}
if (cf.isDetailFilterEnabled())
{
cf.dlgGlobalSetParm("xxAllowDetail", true);
}
cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
cf.dlgSubmit();
}
else
{
oF = (oCC ? oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid")) : null);
if (oF)
{
oF.setCondition(fCondition);
oF.setSummary(sSummary);
oF.setNot(fd_getNOT());
oCC.setFilterView(sSummary == "none" ? cf.giFILTERVIEW_RAW : cf.giFILTERVIEW_SUMMARY);
oFG = oCC.getCurrentFilterGroup();
if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
{
oF.removeSelf();
oFG.addPredicate(oF);
}
cf.addColumnsForReselection();
cf.sendCmd(oCC.getCommand(), "", true);
cf.hideDialogFrame();
}
cf.dlgGlobalReset();
}
};
function cancelDialog()
{
if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
{
cancelEnumToRangeConversion();
}
clearFilterConversionGlobals();
var oAppFrame = getAppFrame();
if (oAppFrame !== null)
{
if (oAppFrame.getFilterMode() == oAppFrame.giFILTERCPLXMODE_WIZARD)
{
oAppFrame.dlgReset();
if (oAppFrame.isDetailFilterEnabled())
{
oAppFrame.dlgGlobalSetParm("xxAllowDetail", true);
}
oAppFrame.dlgSetParm("m", "/" + oAppFrame.qs_dir + "/filterCombine.xts");
if (oAppFrame.dlgGlobalGetParm("xxFCtab"))
{
oAppFrame.dlgSetParm("m_tab", oAppFrame.dlgGlobalGetParm("xxFCtab"));
}
oAppFrame.dlgSubmit();
}
else
{
if(typeof requestTracking != "undefined" && requestTracking != "")
{
if(typeof showCancellingIndicator != "undefined")
{
showCancellingIndicator();
}
var urlParams = "b_action=xts.run&m=portal/om-request.xts&ui.action=cancel";
urlParams += "&m_tracking=" + encodeURIComponent(requestTracking);
requestTracking = "";
oAppFrame.sendDispatcherRequest(urlParams, cancelResponse);
}
else
{
oAppFrame.dlgReset();
oAppFrame.dlgGlobalReset();
oAppFrame.hideDialogFrame();
}
}
}
};
function clearFilterConversionGlobals()
{
cf.dlgGlobalRemoveParm("xxConvertRangeToENUM");
cf.dlgGlobalRemoveParm("xxConvertRangeFromValue");
cf.dlgGlobalRemoveParm("xxConvertRangeToValue");
cf.dlgGlobalRemoveParm("xxConvertENUMToRange");
};
function cancelEnumToRangeConversion()
{
var nFilterElement = getFilterElement();
if (nFilterElement)
{
var fromNode = getChildNodeByName(nFilterElement, cf.gsFE_FROM_NODE);
if (fromNode)
{
nFilterElement.removeChild(fromNode);
}
var toNode = getChildNodeByName(nFilterElement, cf.gsFE_TO_NODE);
if (toNode)
{
nFilterElement.removeChild(toNode);
}
nFilterElement.setAttribute(cf.gsFE_FILTERTYPE_ATTR, cf.gsFE_FILTERTYPE_ENUM);
}
};
function removeEnumChildrenFromFilter()
{
var nFilterElement = getFilterElement();
if (nFilterElement)
{
var childNode;
var childNodeName;
for (var iChild=nFilterElement.childNodes.length-1; iChild>=0; iChild--)
{
childNode = nFilterElement.childNodes[iChild];
if (typeof childNode.baseName != "undefined")
{
childNodeName = childNode.baseName;
}
else
{
childNodeName = childNode.localName;
}
if (childNodeName === cf.gsFE_VALUE_NODE)
{
nFilterElement.removeChild(childNode);
}
}
}
};
function getFilterElement()
{
var nFilterElement;
var nFilter;
var oFilter;
var cf = getConfigFrame();
var oCC = cf.getCombinedFilter();
if (oCC == null)
{
var oMQMgr = goDialogManager.getMiniQueryManager();
var aFilters = oMQMgr.getFiltersForColumn(cf.dlgGlobalGetParm("xxFCid"));
if (aFilters)
{
oFilter = aFilters[0];
}
}
else if (oCC)
{
oFilter = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
}
if (oFilter)
{
nFilter = (oFilter.m_nNode ? oFilter.m_nNode : oFilter);
}
if (nFilter)
{
nFilterElement = getChildNodeByName(nFilter, cf.gsFE_NODE);
}
return nFilterElement;
};
function getChildNodeByName(node, nodeName)
{
var ii;
var childNode;
var childNodeName;
if (node)
{
for (ii = 0; ii < node.childNodes.length; ii++)
{
if (typeof node.childNodes[ii].baseName != "undefined")
{
childNodeName = node.childNodes[ii].baseName;
}
else
{
childNodeName = node.childNodes[ii].localName;
}
if (nodeName === childNodeName)
{
childNode = node.childNodes[ii];
break;
}
if (node.childNodes[ii].hasChildNodes())
{
childNode = getChildNodeByName(node.childNodes[ii], nodeName);
if (childNode)
{
break;
}
}
}
}
return childNode;
};
function cancelResponse(response)
{
cf.dlgReset();
cf.dlgGlobalReset();
cf.hideDialogFrame();
};
function cleanUpPage()
{
pickerControldateFrom.m_oDatePickerDialog.hidePicker();
pickerControldateTo.m_oDatePickerDialog.hidePicker();
};
function toDropDown()
{
pickerControldateFrom.m_oDatePickerDialog.hidePicker();
toGotFocus();
};
function fromDropDown()
{
pickerControldateTo.m_oDatePickerDialog.hidePicker();
fromGotFocus();
};
function fromGotFocus()
{
document.f.fromValue[0].checked = true;
};
function toGotFocus()
{
document.f.toValue[0].checked = true;
};
function catchSubmit(iKeyCode)
{
if (iKeyCode == 13)
{
execute();
}
};
function updateBasedOn()
{
if (cf.getCombinedFilter() != null)
{
cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
}
};
function getPromptId()
{
if (isPromptParamAndIdEncoded())
{
return decodeURIComponent(cf.dlgGlobalGetParm("xxPromptID"));
}
return cf.dlgGlobalGetParm("xxPromptID");
};
function isPromptParamAndIdEncoded()
{
if (cf.dlgGlobalGetParm("xxPromptParamAndIDEncoded"))
{
return true;
}
return false;
};
function addNullOptionToFilter(fs, di, opt)
{
if (getConfigFrame().dlgGlobalGetParm('xxIsNullAllowed') == true && opt)
{
if (opt == 'include')
{
if ((fs != "")&&(fs != di))
{
fs += " or " + di + " is null";
}
}
else if (opt == 'exclude')
{
if ((fs == "")||(fs == di))
{
fs = di + " is not null";
}
else
{
fs += " and " + di + " is not null";
}
}
else if (opt == 'only')
{
fs = di + " is null";
}
}
return fs;
};
function showNullOptions(bShow)
{
var cf = getConfigFrame();
var ds = cf.cfgGet("DialogSize");
var dsDefined = true;
var advOptionSize = 40;
if (ds == 0 || typeof ds == 'undefined' || ds == null)
{
dsDefined = false;
}
if (bShow)
{
document.getElementById('QsdlgVisibleNullOptions').style.display = 'block';
document.getElementById('QsdlgHiddenNullOptions').style.display = 'none';
if (dsDefined)
{
ds += advOptionSize;
cf.showDialogFrame(ds);
}
}
else
{
document.getElementById('QsdlgVisibleNullOptions').style.display = 'none';
document.getElementById('QsdlgHiddenNullOptions').style.display = 'block';
if (dsDefined)
{
ds -= advOptionSize;
cf.showDialogFrame(ds);
}
}
updateNullOptionText();
};
function updateNullOptionText()
{
var d = document.getElementById('nullOptionText');
if (d)
{
d.innerHTML = document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].innerHTML;
}
update_NOC();
};
function getNullOption()
{
return document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].value;
};
function setNullOption(opt)
{
switch(opt)
{
case 'only':
document.f.QsdlgNullOptions.selectedIndex = 3;
break;
case 'exclude':
case 'false':
document.f.QsdlgNullOptions.selectedIndex = 2;
break;
case 'include':
case 'true':
document.f.QsdlgNullOptions.selectedIndex = 1;
break;
default:
document.f.QsdlgNullOptions.selectedIndex = 0;
break;
}
updateNullOptionText();
};
function update_NOC()
{
set_NOC_disable('nocOnly',false);
switch (document.f.QsdlgNullOptions.selectedIndex)
{
case 1:
break;
case 2:
break;
case 3:
set_NOC_disable('nocOnly', true);
break;
default:
break;
}
};
function set_NOC_disable(type, state)
{
var a = document.getElementsByTagName("span");
for (var i=0; i < a.length; i++)
{
if (a[i].getAttribute(type))
{
set_NOC_Children(a[i], state);
}
}
};
function set_NOC_Children(o, state)
{
if (o == null)
{
return;
}
if (state && typeof o.setAttribute == 'function')
{
o.setAttribute('disabled', 'disabled');
}
if (!state && typeof o.removeAttribute == 'function')
{
o.removeAttribute('disabled');
}
try
{
o.disabled = state;
}
catch(e)
{}
var c = o.firstChild;
while (c)
{
set_NOC_Children(c, state);
c = c.nextSibling;
}
};
function initNullOptions()
{
var cf = getConfigFrame();
if (cf !== null)
{
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
{
showNullOptions(false);
if (cf.dlgGlobalGetParm('xxNullOption') != "")
{
setNullOption(cf.dlgGlobalGetParm('xxNullOption'));
}
}
else
{
cf.showDialogFrame(400);
}
}
var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
if (oPC)
{
oPC.setExclusive( (cf.dlgGlobalGetParm('xxNOT') == 'true') );
}
if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
{
document.f.oExcludeSelectedValues.options[(cf.dlgGlobalGetParm('xxNOT') == 'true' ? 1 : 0)].selected = true;
}
};
function sendPicklistRequest()
{
showLoading();
var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
if (activeRequest != null)
{
cf.cancelDispatcherRequest(activeRequest);
}
var oMQMgr = goDialogManager.getMiniQueryManager();
for (var i = 0; i < oMQMgr.getAllColumns().length; i++)
{
if((oMQMgr.isMeasure(i) === false) && (!oMQMgr.isReportExpression(i)))
{
var bIdAlreadySet = false;
for (var j = 0; j < cf.dlgGlobalSize('xxOtherColIds'); j++)
{
if (oMQMgr.getColumnId(i) == cf.dlgGlobalGetParmAt('xxOtherColIds', j))
{
bIdAlreadySet = true;
break;
}
}
if (!bIdAlreadySet)
{
cf.dlgGlobalSetParmAt("xxOtherColIds", cf.dlgGlobalSize('xxOtherColIds'), oMQMgr.getColumnId(i));
cf.dlgGlobalSetParmAt("xxOtherColExps", cf.dlgGlobalSize('xxOtherColExps'), oMQMgr.getExpression(i));
}
else
{
bIdAlreadySet = false;
}
}
}
var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run";
url += buildUrlFromGlobalParms();
if (typeof cf.routingServerGroup != "undefined")
{
url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
}
if (cf.dlgGetParm('productLocale'))
{
url += "&productLocale=" + encodeURIComponent(cf.dlgGetParm('productLocale'));
}
url += "&xxListSeparator=" + encodeURIComponent(goDialogManager.getMiniQueryManager().getListSeparator());
if (cf.cafContextId != "")
{
url += "&ui.cafcontextid=" + cf.cafContextId;
}
url += "&textBoxControl=checkBoxListpList";
if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
{
url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
}
if (cf.cfgGet("markup_track") != "undefined")
{
url += "&markup_track=" + cf.cfgGet("markup_track");
}
cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
};
function buildUrlFromGlobalParms()
{
var aURL = [];
var aKeys = cf.dlgGlobalKeys();
aKeys = [
'searchConversation',
'searchTracking',
'xxCalcOp',
'xxColid',
'xxCreds',
'xxDesignMode',
'xxExprLocale',
'xxFilterItemRef',
'xxFilterItemRefExp',
'xxFullColExpression',
'xxHun',
'xxIsAttribute',
'xxIsNullAllowed',
'xxLevelNumber',
'xxModelName',
'xxOtherColIds',
'xxPromptCascade',
'xxPromptParam',
'xxPromptValues',
'xxRetrievePrompt',
'xxSearchPath',
'xxUseItemRef',
'xxUseItemRefExp',
'xxDisplayItemRef',
'xxDisplayItemRefExp',
'xxFilteredColId',
'xxFilteredColExpression',
'xxUseMUN',
'xxExecutionParameters'
];
var idxKey;
var sAmpersand = "&";
var sEquals = "=";
for(idxKey = 0; idxKey < aKeys.length; idxKey++)
{
var sKey = aKeys[idxKey];
var iSize = cf.dlgGlobalSize(sKey);
if (iSize > 0)
{
if (sKey == 'xxOtherColIds')
{
var url = "";
for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
{
url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
}
aURL.push(url);
}
else
{
for (var i = 0; i < iSize; i++)
{
aURL.push(sAmpersand);
aURL.push(sKey);
aURL.push(sEquals);
aURL.push(encodeURIComponent(cf.dlgGlobalGetParmAt(sKey, i)));
}
}
}
else if (cf.dlgGlobalGetParm(sKey))
{
aURL.push(sAmpersand);
aURL.push(sKey);
aURL.push(sEquals);
aURL.push(encodeURIComponent(cf.dlgGlobalGetParm(sKey)));
}
}
return aURL.join('');
};
function sendSearchRequest(bInit)
{
if (!bInit && promptsRetrieved == false)
{
return;
}
var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
if (activeRequest != null)
{
cf.cancelDispatcherRequest(activeRequest);
}
var url = "m=/" + cf.qs_dir + "/filterSearchRequest.xts&b_action=xts.run";
url += "&_sws_pSearch_searchValue=" + encodeURIComponent(document.f._sws_pSearch_searchValue.value);
url += "&_sws_pSearch_matchAnywhere=" + document.f._sws_pSearch_matchAnywhere.value;
url += "&_sws_pSearch_matchAll=" + document.f._sws_pSearch_matchAll.value;
url += "&_sws_pSearch_caseInsensitive=" + document.f._sws_pSearch_caseInsensitive.value;
url += "&_sws_pSearch_submit=true";
url += "&_promptIdBasedNames=true";
if (cf.cafContextId != "")
{
url += "&ui.cafcontextid=" + cf.cafContextId;
}
if (bInit)
{
cf.dlgGlobalRemoveParm("searchConversation");
cf.dlgGlobalRemoveParm("searchTracking");
}
else
{
url += "&_promptControl=search";
}
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
var sStoredExpr = cf.dlgGlobalGetParm('xxFullColExpression');
if (sDataType === "MUN" && sStoredExpr.substring(0, 8) === "children" )
{
cf.dlgGlobalSetParm('xxFullColExpression', "caption(" + cf.dlgGlobalGetParm('xxFullColExpression') + ")");
}
url += buildUrlFromGlobalParms();
cf.dlgGlobalSetParm('xxFullColExpression', sStoredExpr);
if (typeof cf.routingServerGroup != "undefined")
{
url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
}
if (promptsRetrieved != false)
{
url = url.replace(/&xxRetrievePrompt=[^&]*/gi, '');
url = url.replace(/&xxSearchPath=[^&]*/gi, '');
}
url += "&textBoxControl=searchpSearch";
if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
{
url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
}
if (cf.cfgGet("markup_track") != "undefined")
{
url += "&markup_track=" + cf.cfgGet("markup_track");
}
cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processSearchResponse));
};
function processSearchResponse(response)
{
promptsRetrieved = true;
cf.dlgGlobalSetParm("xxActiveRequest", null);
searchpSearch.stopAnimateSearchIcon();
if (cf.cfgGet("LAST_ACTION") == "" || cf.cfgGet("LAST_ACTION") != "filterSearchExecute")
{
if (!cf.checkResponse(response, document, "filterSearchInit", filterSearch_init))
{
return;
}
}
else
{
if (!cf.checkResponse(response, document, "filterSearchExecute", filterSearch_execute))
{
return;
}
}
var bPrompting = false;
var sReportSpecification = "";
try
{
eval(response);
if (bPrompting && bPrompting === true)
{
sendPromptRequest(sReportSpecification);
}
}
catch(e)
{
}
};
function fd_getUseValue(obj)
{
var sRetVal = "";
if (obj)
{
if ( typeof obj == "string" )
{
sRetVal = obj;
}
else if( typeof obj.getUse == "function" )
{
sRetVal = obj.getUse();
}
else if( obj.nodeType || typeof obj.getAttribute == "function" )
{
sRetVal = obj.getAttribute("use");
}
}
return sRetVal;
};
function fd_getDisplayValue(obj)
{
if (typeof obj == "object")
{
if (obj.nodeType || typeof obj.getAttribute == "function")
{
var dv = obj.getAttribute("display");
if (dv)
{
return fd_xmldecode(dv);
}
}
else if (typeof obj.getDisplay == "function")
{
return obj.getDisplay();
}
}
return fd_getUseValue(obj);
};
function fd_xmldecode(str)
{
var cf = getConfigFrame();
if (cf !== null && typeof cf.sXmlDecode == "function")
{
str = cf.sXmlDecode(str);
}
return str;
};
function fd_getNOT()
{
if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
{
return (document.f.oExcludeSelectedValues.options[document.f.oExcludeSelectedValues.options.selectedIndex].value);
}
else
{
var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
if (oPC)
{
return ( "" + oPC.isExclusive() );
}
}
return '';
};
function buildFilterDateExpression()
{
var oFE = new cf.CFilterExpression();
oFE.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
oFE.setNullOption(no);
if (no == "only")
{
return oFE;
}
}
var sFromUseValue = pickerControldateFrom.sGetValue();
var sFromDisplayValue = pickerControldateFrom.sGetFormatValue();
var sToUseValue = pickerControldateTo.sGetValue();
var sToDisplayValue = pickerControldateTo.sGetFormatValue();
if (document.getElementById("textBoxstringValueFrom"))
{
if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
{
sFromUseValue = substVarValueFrom;
sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
}
else if (document.f.fromValue[2].checked == true)
{
sFromUseValue = null;
}
if (document.f.toValue[1].checked == true && substVarValueTo != null)
{
sToUseValue = substVarValueTo;
sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
}
else if (document.f.toValue[2].checked == true)
{
sToUseValue = null;
}
}
else
{
if (document.f.fromValue[1].checked == true)
{
sFromUseValue = null;
}
if (document.f.toValue[1].checked == true)
{
sToUseValue = null;
}
}
if (sFromUseValue !== null && sToUseValue !== null && pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate)
{
tmp = sFromUseValue;
sFromUseValue = sToUseValue;
sToUseValue = tmp;
tmp = sFromDisplayValue;
sFromDisplayValue = sToDisplayValue;
sToDisplayValue = tmp;
}
if (cf.dlgGlobalGetParm("xxDataType") == 52)
{
if (sFromUseValue !== null)
{
sFromUseValue += (document.f.promptBox.checked ? "T" : " ") + "00:00:00.000";
}
if (sToUseValue !== null)
{
sToUseValue += (document.f.promptBox.checked ? "T" : " ") + "23:59:59.999";
}
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
oFE.setPrompt(promptID);
var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
var sPromptValues = oParamManager.getRangePromptValues(sFromUseValue, sFromDisplayValue, sToUseValue, sToDisplayValue);
cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
}
else
{
if (sFromUseValue !== null)
{
oFE.setFrom(sFromUseValue, sFromDisplayValue);
}
if (sToUseValue !== null)
{
oFE.setTo(sToUseValue, sToDisplayValue);
}
}
return oFE;
};
function getAppFrame()
{
var oAppFrame = null;
if (typeof getConfigFrame == "function")
{
oAppFrame = getConfigFrame();
}
else if (typeof goDialogManager != "undefined")
{
oAppFrame = goDialogManager.getApplicationFrame();
}
return oAppFrame;
};
function setupDialog()
{
var oFilterFeature = goDialogManager.getThisFeatureObject();
var oFilterName = document.getElementById("filterNameStr");
oFilterName.appendChild(document.createTextNode(decodeURIComponent(oFilterFeature.m_sLabel)));
var oFilterDeleteLink = document.getElementById("filterDeleteLink");
var oFilterDeleteText = oFilterDeleteLink.innerHTML;
oFilterDeleteText = oFilterDeleteText.replace(/<a>/i, '');
oFilterDeleteText = oFilterDeleteText.replace(/<\/a>/i, '');
oFilterDeleteLink.innerHTML = oFilterDeleteText;
var oAppFrame = getAppFrame();
if (oAppFrame !== null && oAppFrame.isDetailFilterEnabled())
{
document.getElementById("b_summaryOptions").style.display = "block";
}
for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
{
document.f.r_summaryOption[idxSummaryOption].checked = (document.f.r_summaryOption[idxSummaryOption].value == oFilterFeature.m_sFilterSummaryType);
}
if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
{
document.f.oExcludeSelectedValues.options[(oFilterFeature.m_bNOT ? 1 : 0)].selected = true;
}
};
function execute()
{
var oFilterFeature = goDialogManager.getThisFeatureObject();
var sSummaryOption = "";
for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
{
if (document.f.r_summaryOption[idxSummaryOption].checked)
{
sSummaryOption = document.f.r_summaryOption[idxSummaryOption].value;
}
}
goDialogManager.getFeatureManager().executeFeature("ModelFilter", [fd_getNOT(), sSummaryOption]);
};
function deleteModelFilter()
{
goDialogManager.getFeatureManager().executeFeature("ModelFilter", ["DELETE"]);
};
function filterDialogCommon_init()
{
attachMouseEvents();
var x = document.getElementById("link1");
var y = document.getElementById("link2");
if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
{
y.style.display = "none";
}
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (cf.dlgGlobalGetParm('xxPromptState') == true)
{
document.f.promptBox.checked = true;
}
else if (cf.dlgGlobalGetParm('xxPromptState') == false)
{
document.f.promptBox.checked = false;
}
else if (sXXPromptParam != "")
{
document.f.promptBox.checked = true;
}
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
initNullOptions();
};
function filterCombine_execute(bLeaveDialog)
{
var sTab = cf.dlgGlobalGetParm("xxFCtab");
cf.dlgGlobalReset();
cf.dlgGlobalSetParm("xxFCtab", sTab);
var oCFilters = cf.getCombinedFilter();
if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
{
cf.addColumnsForReselection();
cf.sendCmd(oCFilters.getCommand(), "", true, bLeaveDialog);
}
else
{
cf.hideDialogFrame();
}
if(typeof oCFilters != "undefined" && oCFilters != null)
{
oCFilters.clearDirtyFlag();
cf.cfgRemove("combinedFilters");
cf.cfgRemove("combinedFilters_default");
cf.cfgBackup("filter_promptValues");
cf.cfgBackup("filter_promptValuesXML");
}
};
function filterCombine_cancelDialog()
{
cf.dlgGlobalReset();
var oCCdefault = cf.cfgGet("combinedFilters_default");
if (oCCdefault)
{
var oCC = cf.getCombinedFilter();
if (oCC)
{
var nParent = oCC.m_nNode.parentNode;
if (nParent)
{
nParent.insertBefore(oCCdefault.m_nNode, oCC.m_nNode);
nParent.removeChild(oCC.m_nNode);
}
}
cf.cfgRemove("combinedFilters_default");
}
cf.cfgRemove("combinedFilters");
cf.cfgRestore("filter_promptValues");
cf.cfgRestore("filter_promptValuesXML");
cf.hideDialogFrame();
};
function filterCombine_applyChanges()
{
var oCFilters = cf.getCombinedFilter();
var iCurrentFilterGroup = oCFilters.m_iFilterView;
var sTab = cf.dlgGlobalGetParm("xxFCtab");
if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
{
execute(null, true);
oCFilters.renderFilterView(oFilterViewObj);
}
};
function filterCombine_init(sTab, iFilterView)
{
attachMouseEvents();
oFilterViewObj = document.getElementById('filterList');
var oCFilters;
if (cf)
{
cf.setFilterMode(cf.giFILTERCPLXMODE_WIZARD);
cf.dlgGlobalSetParm("xxFCtab", sTab);
oCFilters = cf.getCombinedFilter();
if (oCFilters)
{
var oBackup = cf.cfgGet("combinedFilters_default");
if (!oBackup)
{
cf.cfgSet("combinedFilters_default", oCFilters.clone());
}
oCFilters.setFilterView(iFilterView);
oCFilters.renderFilterView(oFilterViewObj);
}
}
if (cf && cf.dlgGlobalGetParm("xxAllowDetail") != true && oCFilters.getRawFilter().getSize() == 0)
{
var rTabElement = document.getElementById("rTab");
if (rTabElement)
{
rTabElement.parentNode.parentNode.parentNode.parentNode.style.display = "none";
}
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(300);
}
document.onclick = function(event)
{
var sTCN = ((window.event && window.event.srcElement) ? window.event.srcElement : event.target).className;
if ( gFContextMenu && gFContextMenu.m_contextMenu && !sTCN.match(/\bclsFilterOperator\b/gi) )
{
gFContextMenu.m_contextMenu.remove();
}
return true;
};
};
function filterCombine_gf()
{
var oCFilters = cf.getCombinedFilter();
oCFilters.groupFilters(oCFilters.getSelectedIds(oFilterViewObj));
oCFilters.renderFilterView(oFilterViewObj);
};
function filterCombine_ugf()
{
var oCFilters = cf.getCombinedFilter();
oCFilters.unGroupFilters(oCFilters.getSelectedIds(oFilterViewObj));
oCFilters.renderFilterView(oFilterViewObj);
};
function filterCombine_df()
{
var oCFilters = cf.getCombinedFilter();
oCFilters.deleteFilters(oCFilters.getSelectedIds(oFilterViewObj));
oCFilters.renderFilterView(oFilterViewObj);
};
function filterCombine_fNot(bNot)
{
var oCFilters = cf.getCombinedFilter();
var aFilterIDs = oCFilters.getSelectedIds(oFilterViewObj);
for (var idxFilter in aFilterIDs)
{
var sFilterId = aFilterIDs[idxFilter];
var oFilter = oCFilters.getFilterById(sFilterId);
if (oFilter !== null)
{
oFilter.setNot(bNot);
}
}
oCFilters.setDirty();
oCFilters.renderFilterView(oFilterViewObj);
};
function filterCombine_dfa()
{
var oCFilters = cf.getCombinedFilter();
oCFilters.deleteAll();
oCFilters.renderFilterView(oFilterViewObj);
};
function filterCombine_afl()
{
cf.dlgGlobalSetParm("xxNewFilter", true);
goDialogManager.getFeatureManager().launchFeature('FilterSimple');
};
function filterCombine_cOp(sId, sOp)
{
var oCFilters = cf.getCombinedFilter();
var oFilterGroup = oCFilters.getFilterById(sId);
if (oFilterGroup.isNot())
{
if (sOp == cf.gsFILTEROPERATOR_AND)
{
sOp = cf.gsFILTEROPERATOR_NAND;
}
else if (sOp == cf.gsFILTEROPERATOR_OR)
{
sOp = cf.gsFILTEROPERATOR_NOR;
}
}
oFilterGroup.setOperator(sOp);
oCFilters.renderFilterView(oFilterViewObj);
if (window && window.getSelection && window.getSelection().removeAllRanges)
{
window.getSelection().removeAllRanges();
}
};
function filterCombine_modifyFilter(sFID, sTab)
{
cf.dlgGlobalSetParm("xxNewFilter", false);
cf.dlgGlobalSetParm("xxFCtab", sTab);
cf.dlgGlobalSetParm("xxShowTypeInDropDown", cf.checkCalcFunctionAgainstDB("FLEXIBLE_FILTERS"));
goDialogManager.getFeatureManager().launchFeature('FilterSimple', [sFID, true]);
};
function filterCombine_tab(sTab, sDialogName)
{
cf.dlgReset();
if (cf.isDetailFilterEnabled())
{
cf.dlgGlobalSetParm("xxAllowDetail", true);
}
cf.dlgSetParm("m", "/" + cf.qs_dir + "/" + sDialogName);
cf.dlgSetParm("m_tab", sTab);
cf.dlgSubmit();
};
function filterDateRange_execute()
{
if((document.f.fromValue[0].checked && !pickerControldateFrom.isValid())||(document.f.toValue[0].checked && !pickerControldateTo.isValid()))
{
return;
}
submitFilterExpression( buildFilterDateExpression() );
};
function filterCommon_isColumHidden(sColId)
{
var oMQMgr = goDialogManager.getMiniQueryManager();
var oCol = oMQMgr.getColumnById(sColId);
var bHidden = false;
if (oCol && oCol !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
bHidden = (oCol.getAttribute("hide") == "layout");
}
return bHidden;
};
function filterCommon_initBasedOnDatasourceBox()
{
var bRetval = false;
if (cf.isDetailFilterEnabled())
{
var bIsColHidden = filterCommon_isColumHidden( cf.dlgGlobalGetParm("xxColName") );
if (bIsColHidden)
{
document.getElementById("displayBasedOn").disabled = true;
document.f.filterBasedOnDS.disabled = true;
}
document.getElementById("displayBasedOn").style.display = "block";
if (cf.dlgGlobalGetParm('xxBasedOn') == 'details')
{
document.f.filterBasedOnDS.checked = false;
}
bRetval = document.f.filterBasedOnDS.checked;
}
return bRetval;
};
function filterDateRange_init(oOptions)
{
attachMouseEvents();
filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(oOptions.bUseAdv ? 565 : 495);
}
initNullOptions();
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
var oDateTo = document.getElementById('dateEditBoxdateTo');
if (oDateTo)
{
oDateTo.onclick = toGotFocus;
oDateTo.onkeypress = toGotFocus;
oDateTo.onpaste = toGotFocus;
}
var oDateFrom = document.getElementById('dateEditBoxdateFrom');
if (oDateFrom)
{
oDateFrom.onclick = fromGotFocus;
oDateFrom.onkeypress = fromGotFocus;
oDateFrom.onpaste = fromGotFocus;
}
if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
{
pickerControldateFrom.m_oEditBox.focus();
}
document.onclick = cleanUpPage;
if (document.dateToimgPicker)
{
document.dateToimgPicker.onmousedown = toDropDown;
}
if (document.dateFromimgPicker)
{
document.dateFromimgPicker.onmousedown = fromDropDown;
}
};
function filterDateTimeRange_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var sFromUseValue = pickerControldateFrom.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeFrom.sGetValue();
var sFromDisplayValue = pickerControldateFrom.sGetFormatValue() + " " + timePickertimeFrom.sGetFormatValue();
var sToUseValue = pickerControldateTo.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeTo.sGetValue();
var sToDisplayValue = pickerControldateTo.sGetFormatValue() + " " + timePickertimeTo.sGetFormatValue();
if (document.getElementById("textBoxstringValueFrom"))
{
if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
{
sFromUseValue = substVarValueFrom;
sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
}
else if (document.f.fromValue[2].checked == true)
{
sFromUseValue = null;
}
if (document.f.toValue[1].checked == true && substVarValueTo != null)
{
sToUseValue = substVarValueTo;
sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
}
else if (document.f.toValue[2].checked == true)
{
sToUseValue = null;
}
}
else
{
if (document.f.fromValue[1].checked == true)
{
sFromUseValue = null;
}
if (document.f.toValue[1].checked == true)
{
sToUseValue = null;
}
}
if ( sFromUseValue !== null && sToUseValue !== null && (pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate || (pickerControldateFrom.m_dDate.toString() == pickerControldateTo.m_dDate.toString() && timePickertimeFrom.sGetValue() > timePickertimeTo.sGetValue())) )
{
tmp = sFromUseValue;
sFromUseValue = sToUseValue;
sToUseValue = tmp;
tmp = sFromDisplayValue;
sFromDisplayValue = sToDisplayValue;
sToDisplayValue = tmp;
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
var sPromptValues = oParamManager.getRangePromptValues(
sFromUseValue,
sFromDisplayValue,
sToUseValue,
sToDisplayValue
);
cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
}
else
{
if (sFromUseValue !== null)
{
fe.setFrom(sFromUseValue, sFromDisplayValue);
}
if (sToUseValue !== null)
{
fe.setTo(sToUseValue, sToDisplayValue);
}
}
return fe;
};
function filterDateTimeRange_execute()
{
if((document.f.fromValue[0].checked && !pickerControldateFrom.isValid())||(document.f.toValue[0].checked && !pickerControldateTo.isValid())||(document.f.fromValue[0].checked && !timePickertimeFrom.isValid())||(document.f.toValue[0].checked && !timePickertimeTo.isValid()))
{
return;
}
submitFilterExpression( filterDateTimeRange_buildFilterExpression() );
};
function filterDateTimeRange_init(oOptions)
{
attachMouseEvents();
filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(oOptions.bUseAdv ? 550 : 495);
}
initNullOptions();
var oDateFrom = document.getElementById('dateEditBoxdateFrom');
var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
if (oDateFrom)
{
oDateFrom.onclick = fromGotFocus;
oDateFrom.onkeypress = fromGotFocus;
oDateFrom.onpaste = fromGotFocus;
}
if (oTimeFrom)
{
oTimeFrom.onclick = fromGotFocus;
oTimeFrom.onkeypress = fromGotFocus;
oTimeFrom.onpaste = fromGotFocus;
}
var oDateTo = document.getElementById('dateEditBoxdateTo');
var oTimeTo = document.getElementById('timeEditBoxtimeTo');
if (oDateTo)
{
oDateTo.onclick = toGotFocus;
oDateTo.onkeypress = toGotFocus;
oDateTo.onpaste = toGotFocus;
}
if (oTimeTo)
{
oTimeTo.onclick = toGotFocus;
oTimeTo.onkeypress = toGotFocus;
oTimeTo.onpaste = toGotFocus;
}
if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
{
pickerControldateFrom.m_oEditBox.focus();
}
document.onclick = cleanUpPage;
if (document.dateToimgPicker)
{
document.dateToimgPicker.onmousedown = toDropDown;
}
if (document.dateFromimgPicker)
{
document.dateFromimgPicker.onmousedown = fromDropDown;
}
};
function filterDialogCommon_setParmValues()
{
var oPC = G_PM_THIS_.getPromptControl('inputList');
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(415);
var aParams = [];
for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
{
aParams.push(
createParamValue(
fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j)),
fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j))
)
);
}
for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
{
aParams.push(
createParamValue(
fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1)),
fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k))
)
);
}
if ( oPC )
{
oPC.setParameterValues( aParams );
}
}
if (oPC)
{
var elInput = oPC.m_oForm;
if (elInput && !elInput.disabled)
{
elInput.focus();
}
}
};
function filterDaysBeforeToday_init()
{
filterDialogCommon_init();
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
filterDialogCommon_setParmValues();
var hintText = document.getElementById("hintText");
if (hintText)
{
hintText.innerHTML = sXXTodayString + " - " + sXXAllDaysString;
}
};
function filterDaysBeforeToday_buildFilterExpression()
{
return filterTypeInStartsEndsContains_buildFilterExpression("daysBeforeToday");
};
function filterDaysBeforeToday_execute()
{
submitFilterExpression( filterDaysBeforeToday_buildFilterExpression() );
};
function filterTypeInCommon_init()
{
filterDialogCommon_init();
var x = document.getElementById("link1");
var y = document.getElementById("link2");
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
}
else
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
}
y.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
filterDialogCommon_setParmValues();
};
function filterTypeInExactlyMatches_init()
{
filterTypeInCommon_init();
};
function filterTypeInExactlyMatches_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var oPC = G_PM_THIS_.getPromptControl('inputList');
var aParamValues = oPC.getParameterValues();
if (aParamValues.length > 0)
{
var promptID = getPromptId();
if (document.f.promptBox.checked)
{
fe.setPrompt(promptID);
}
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
if (sDataType !== "")
{
fe.setDataType(sDataType);
}
if (document.f.promptBox.checked)
{
var promptValues = '';
promptValues += oPC.preProcess();
promptValues += '';
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
for (i = 0; i < aParamValues.length; i++)
{
fe.addValue( aParamValues[i].getUseValue(), aParamValues[i].getDisplayValue() );
}
}
}
else if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
cf.updateOrAddPromptParm("p_" + promptID, '');
onlyPrompt = true;
}
fe.setFilterType("exactlyMatches");
return fe;
};
function filterTypeInExactlyMatches_execute()
{
submitFilterExpression( filterTypeInExactlyMatches_buildFilterExpression() );
};
function filterTypeInMatchesSQLPattern_buildFilterExpression()
{
var fe = filterTypeInExactlyMatches_buildFilterExpression();
fe.setFilterType("isLike");
return fe;
};
function filterTypeInMatchesSQLPattern_execute()
{
submitFilterExpression( filterTypeInMatchesSQLPattern_buildFilterExpression() );
};
function filterTypeInRange_getExcludeFlag(sBound)
{
var sXXNodeName = ( sBound == "from" ? "xxFromNode" : "xxToNode" );
var sRangeNodeName = ( sBound == "from" ? "start" : "end" );
var nNode = cf.dlgGlobalGetParm(sXXNodeName);
var nSelectChoices = cf.dlgGlobalGetParm("xxSelectChoicesNode");
var bExclude = ( nNode && nNode.getAttribute(cf.gsFE_EXCLUSIVE_ATTR) === "true" );
if ( !bExclude && nSelectChoices )
{
var nNode = nSelectChoices.findChildByName(sRangeNodeName);
bExclude = (nNode && nNode.getAttribute("inclusive") === "false");
}
return bExclude;
};
function filterTypeInRange_init()
{
filterTypeInCommon_init();
filterTypeInRange_buildIncludeMenu("from");
filterTypeInRange_buildIncludeMenu("to");
};
function filterTypeInRange_execute()
{
submitFilterExpression( filterTypeInRange_buildFilterExpression() );
};
function filterTypeInRange_buildFilterExpression()
{
var oFE = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
oFE.setNullOption(no);
if (no == "only")
{
return oFE;
}
}
var sFromUseValue = filterTypeInRange_getValue("from");
var sToUseValue = filterTypeInRange_getValue("to");
var bFromInclusive = filterTypeInRange_getInclusive("from");
var bToInclusive = filterTypeInRange_getInclusive("to");
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
oFE.setPrompt(promptID);
var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
var sPromptValues = oParamManager.getRangePromptValues(
sFromUseValue,
sFromUseValue,
sToUseValue,
sToUseValue,
bFromInclusive,
bToInclusive
);
cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
}
else
{
if (sFromUseValue !== null)
{
oFE.setFrom(sFromUseValue, sFromUseValue, !bFromInclusive);
}
if (sToUseValue !== null)
{
oFE.setTo(sToUseValue, sToUseValue, !bToInclusive);
}
}
if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
{
oFE.setDataType('string');
}
oFE.setFilterType(cf.gsFE_FILTERTYPE_TYPEINRANGE);
return oFE;
};
function filterTypeInRange_getValue(sName)
{
var oRadio = document.getElementById(sName + "Value");
return ( oRadio && oRadio.checked ? document.f[sName + "TB"].value : null );
};
function filterTypeInRange_getInclusive(sPrefix)
{
return ( window["filterTypeInRange_inclusive_" + sPrefix] !== false );
};
function filterTypeInRange_buildIncludeMenu(sPrefix)
{
if (!sPrefix)
{
return;
}
var sParentDiv = sPrefix + "IncludedDiv";
var sWebRoot = cf.cfgGet("gsWebRoot");
var oIncludeButtonStyle = new CUIStyle('includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton');
var oIncludedFlyoutMenu = new CUIStyle('headerButtonDropDown', 'headerButtonDropDownRollover', 'headerButtonDropDown', 'headerButtonDropDown','headerButtonDropDown');
var oIncludedMenuItemStyle = new CUIStyle('includeMenuItem_normal', 'includeMenuItem_hover', 'includeMenuItem_pressed', '', 'menuItem_disabled');
var oIncludedBar = new CBar(sParentDiv, null, null, sWebRoot + '/common/images/toolbar/', '', '', 'qs', 'tt');
oIncludedBar.setMenuType(cHorizonalBar);
var oIncludedMenuItem = new CQSMenuItem(oIncludedBar, sFILTER_INCLUDED, '', '', oIncludeButtonStyle, sWebRoot, null);
oIncludedMenuItem.setIconPrecedingText("(");
oIncludedMenuItem.setIconTrailingText(")");
oIncludedMenuItem.setDropDownArrow(sWebRoot + "/common/images/toolbar_drop_arrow.gif");
var menuStyle = new CUIStyle('clsMenu', '', '', '', '');
var oIncludedMenu = oIncludedMenuItem.createDropDownMenu(menuStyle);
oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_INCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_INCLUDED + '","'+sPrefix+'",true,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_EXCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_EXCLUDED + '","'+sPrefix+'",false,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
oIncludedBar.draw();
if ( filterTypeInRange_getExcludeFlag(sPrefix) )
{
filterTypeInRange_includeMenuOnClickHandler( sFILTER_EXCLUDED, sPrefix, false, oIncludedMenuItem );
}
return oIncludedMenuItem;
};
function filterTypeInRange_includeMenuOnClickHandler(sNewLabel, sPrefix, bInclusive, oMenuItem)
{
if ( !oMenuItem )
{
oMenuItem = (this ? this.menuItem : null);
}
if (oMenuItem && oMenuItem.getParent && oMenuItem.getParent().getParent)
{
var menuItemForLabel = oMenuItem.getParent().getParent();
menuItemForLabel.setLabel(sNewLabel);
if (menuItemForLabel.getParent && menuItemForLabel.getParent().draw)
{
menuItemForLabel.getParent().draw();
}
}
window["filterTypeInRange_inclusive_" + sPrefix] = ( bInclusive !== false );
if (window && window.getSelection && window.getSelection().removeAllRanges)
{
window.getSelection().removeAllRanges();
}
return true;
};
function filterTypeInStartsEndsContains_buildFilterExpression(sFilterType)
{
var fe = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var oPC = G_PM_THIS_.getPromptControl('inputList');
var oParamValue = oPC.getParameterValues();
if (oParamValue)
{
var promptID = getPromptId();
if (document.f.promptBox.checked)
{
fe.setPrompt(promptID);
}
if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
{
fe.setDataType('string');
}
if (document.f.promptBox.checked)
{
var promptValues = '';
promptValues += oPC.preProcess();
promptValues += '';
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
fe.addValue( oParamValue.use, oParamValue.display );
}
fe.setFilterType(sFilterType);
}
else if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
cf.updateOrAddPromptParm("p_" + promptID, '');
onlyPrompt = true;
}
return fe;
};
function filterTypeInStartsEndsContains_execute(sFilterType)
{
submitFilterExpression( buildFilterExpression() );
};
function createParamValue( sUse, sDisplay )
{
var oParam = new C_ParameterValue(
{
"n": "selectOption",
"@useValue": sUse,
"@displayValue": sDisplay
}
);
return oParam;
};
function filterIntervalRange_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
var firstValDisplay = null;
var secondValDisplay = null;
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var firstInterval = intervalControlintervalFrom.sGetInterval();
var secondInterval = intervalControlintervalTo.sGetInterval();
var firstIntervalXSD = intervalControlintervalFrom.sGetXSDValue();
var secondIntervalXSD = intervalControlintervalTo.sGetXSDValue();
if (document.getElementById("textBoxstringValueFrom"))
{
if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
{
firstInterval = substVarValueFrom;
firstValDisplay = textBoxstringValueFrom.sGetFormatValue();
}
else if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[2].checked == true)
{
firstInterval = sFILTER_LOWEST_VALUE;
}
if (document.f.toValue[1].checked == true && substVarValueTo != null)
{
secondInterval = substVarValueTo;
secondValDisplay = textBoxstringValueTo.sGetFormatValue();
}
else if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[2].checked == true)
{
secondInterval = sFILTER_HIGHEST_VALUE;
}
}
else
{
if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[1].checked == true)
{
firstInterval = sFILTER_LOWEST_VALUE;
}
if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[1].checked == true)
{
secondInterval = sFILTER_HIGHEST_VALUE;
}
}
if (
(
(firstInterval != "" && document.f.fromValue[0].checked) &&
(secondInterval != "" && document.f.toValue[0].checked) ) &&
(
(
parseInt(intervalControlintervalFrom.m_oDays.value,10) > parseInt(intervalControlintervalTo.m_oDays.value,10)
) || (
parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
parseInt(intervalControlintervalFrom.m_oHours.value,10) > parseInt(intervalControlintervalTo.m_oHours.value,10)
) || (
parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
parseInt(intervalControlintervalFrom.m_oMinutes.value,10) > parseInt(intervalControlintervalTo.m_oMinutes.value,10)
) || (
parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
parseInt(intervalControlintervalFrom.m_oMinutes.value,10) == parseInt(intervalControlintervalTo.m_oMinutes.value,10) &&
parseInt(intervalControlintervalFrom.m_oSeconds.value,10) > parseInt(intervalControlintervalTo.m_oSeconds.value,10)
)
)
)
{
var tmp = firstInterval;
firstInterval = secondInterval;
secondInterval = tmp;
tmp = firstIntervalXSD;
firstIntervalXSD = secondIntervalXSD;
secondIntervalXSD = tmp;
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
var promptValues = '';
if (firstInterval == sFILTER_LOWEST_VALUE && secondInterval == sFILTER_HIGHEST_VALUE)
{
onlyPrompt = true;
promptValues = '';
}
else
{
if (firstInterval == sFILTER_LOWEST_VALUE)
{
promptValues += '';
if (secondValDisplay)
{
promptValues += '';
}
else
{
promptValues += '';
}
promptValues += '';
}
else if (secondInterval == sFILTER_HIGHEST_VALUE)
{
promptValues += '';
if (firstValDisplay)
{
promptValues += '';
}
else
{
promptValues += '';
}
promptValues += '';
}
else if (firstInterval == secondInterval)
{
if (firstValDisplay)
{
promptValues += '';
}
else
{
promptValues += '';
}
}
else
{
promptValues += '';
if (firstValDisplay)
{
promptValues += '';
}
else
{
promptValues += '';
}
if (secondValDisplay)
{
promptValues += '';
}
else
{
promptValues += '';
}
promptValues += '';
}
promptValues += '';
}
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
if (firstInterval != sFILTER_LOWEST_VALUE)
{
fe.setFrom(firstInterval, (firstValDisplay ? firstValDisplay : firstInterval));
}
if (secondInterval != sFILTER_HIGHEST_VALUE)
{
fe.setTo(secondInterval, (secondValDisplay ? secondValDisplay : secondInterval));
}
}
return fe;
};
function filterIntervalRange_execute()
{
if((document.f.fromValue[0].checked && !intervalControlintervalFrom.isValid())||(document.f.toValue[0].checked && !intervalControlintervalTo.isValid()))
{
return;
}
submitFilterExpression( filterIntervalRange_buildFilterExpression() );
};
function filterIntervalRange_init(oOptions)
{
attachMouseEvents();
filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(oOptions.bUseAdv ? 565 : 500);
}
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
initNullOptions();
filterIntervalRange_initBox(document.f.intervalDaysintervalFrom, fromGotFocus);
filterIntervalRange_initBox(document.f.intervalHoursintervalFrom, fromGotFocus);
filterIntervalRange_initBox(document.f.intervalMinutesintervalFrom, fromGotFocus);
filterIntervalRange_initBox(document.f.intervalSecondsintervalFrom, fromGotFocus);
filterIntervalRange_initBox(document.f.intervalDaysintervalTo, toGotFocus);
filterIntervalRange_initBox(document.f.intervalHoursintervalTo, toGotFocus);
filterIntervalRange_initBox(document.f.intervalMinutesintervalTo, toGotFocus);
filterIntervalRange_initBox(document.f.intervalSecondsintervalTo, toGotFocus);
if (document.f && document.f.intervalDaysintervalFrom && !document.f.intervalDaysintervalFrom.disabled)
{
document.f.intervalDaysintervalFrom.focus();
}
};
function filterIntervalRange_initBox(oCtrl, oEventHandler)
{
if (oCtrl)
{
if (oCtrl.value == "")
{
oCtrl.value = sFILTER_INTERVAL_DEFAULT_VALUE;
}
oCtrl.onclick = oEventHandler;
oCtrl.onkeypress = oEventHandler;
oCtrl.onblur = oEventHandler;
}
};
function filterNumRange_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
onlyPrompt = false;
var fromValUse = '';
var fromValDisplay = '';
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
{
fromValUse = textBoxtextBoxFrom.sGetValue();
fromValUse = fromValUse.replace("\.", decimalSeparator);
fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
}
else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
{
fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
}
var toValUse = '';
var toValDisplay = '';
if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
{
toValUse = textBoxtextBoxTo.sGetValue();
toValUse = toValUse.replace("\.", decimalSeparator);
toValDisplay = textBoxtextBoxTo.sGetFormatValue();
}
else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
{
toValUse = substVarValueTo.replace("\.", decimalSeparator);
toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
}
if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
{
var tmp = fromValUse;
fromValUse = toValUse;
toValUse = tmp;
tmp = fromValDisplay;
fromValDisplay = toValDisplay;
toValDisplay = tmp;
}
if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
{
fromValUse = sFILTER_NUMBER_LOWEST;
}
if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
{
toValUse = sFILTER_NUMBER_HIGHEST;
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
var promptValues = '';
if ((fromValUse == '' && toValUse == '') ||
(fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST))
{
onlyPrompt = true;
promptValues = '';
}
else
{
if (fromValUse == sFILTER_NUMBER_LOWEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (toValUse == sFILTER_NUMBER_HIGHEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (fromValUse == toValUse)
{
promptValues += '';
}
else
{
promptValues += '';
promptValues += '';
promptValues += '';
promptValues += '';
}
promptValues += '';
}
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
if (fromValUse != sFILTER_NUMBER_LOWEST)
{
fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
}
if (toValUse != sFILTER_NUMBER_HIGHEST)
{
fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
}
}
return fe;
};
function filterNumRange_execute()
{
if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
{
return;
}
submitFilterExpression( filterNumRange_buildFilterExpression() );
};
function filterNumRange_init(oOptions)
{
attachMouseEvents();
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
initNullOptions();
filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(410);
}
var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
if (oTextBoxFrom)
{
oTextBoxFrom.onclick = fromGotFocus;
oTextBoxFrom.onkeypress = fromGotFocus;
oTextBoxFrom.onpaste = fromGotFocus;
}
var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
if (oTextBoxTo)
{
oTextBoxTo.onclick = toGotFocus;
oTextBoxTo.onkeypress = toGotFocus;
oTextBoxTo.onpaste = toGotFocus;
}
if (!textBoxtextBoxFrom.m_oForm.disabled)
{
textBoxtextBoxFrom.m_oForm.focus();
}
};
function filterNumSumRange_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
onlyPrompt = false;
var fromValUse = '';
var fromValDisplay = '';
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
{
fromValUse = textBoxtextBoxFrom.sGetValue();
fromValUse = fromValUse.replace("\.", decimalSeparator);
fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
}
else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
{
fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
}
var toValUse = '';
var toValDisplay = '';
if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
{
toValUse = textBoxtextBoxTo.sGetValue();
toValUse = toValUse.replace("\.", decimalSeparator);
toValDisplay = textBoxtextBoxTo.sGetFormatValue();
}
else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
{
toValUse = substVarValueTo.replace("\.", decimalSeparator);
toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
}
if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
{
var tmp = fromValUse;
fromValUse = toValUse;
toValUse = tmp;
tmp = fromValDisplay;
fromValDisplay = toValDisplay;
toValDisplay = tmp;
}
if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
{
fromValUse = sFILTER_NUMBER_LOWEST;
}
if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
{
toValUse = sFILTER_NUMBER_HIGHEST;
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
var promptValues = '';
if (fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST)
{
onlyPrompt = true;
promptValues = '';
}
else
{
if (fromValUse == sFILTER_NUMBER_LOWEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (toValUse == sFILTER_NUMBER_HIGHEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (fromValUse == toValUse)
{
promptValues += '';
}
else
{
promptValues += '';
promptValues += '';
promptValues += '';
promptValues += '';
}
promptValues += '';
}
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
if (fromValUse != sFILTER_NUMBER_LOWEST)
{
fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
}
if (toValUse != sFILTER_NUMBER_HIGHEST)
{
fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
}
}
return fe;
};
function filterNumSumRange_execute()
{
var oMQMgr = goDialogManager.getMiniQueryManager();
if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
{
return;
}
var fString = filterNumSumRange_buildFilterExpression();
var summaryValue = filterNumSumRange_getSummaryValue();
submitFilter(fString, onlyPrompt, summaryValue);
};
function filterNumSumRange_getSummaryValue()
{
var oMQMgr = goDialogManager.getMiniQueryManager();
var summaryValue = !(summarizationValue == "raw" && cf.isDetailFilterEnabled());
if ( summarizationValue == "summary" )
{
summaryValue = document.getElementById("summary").value;
if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
{
summaryValue = parseInt(summaryValue, 10);
}
summaryValue = oMQMgr.getColumnId(summaryValue);
}
return (summaryValue);
};
function filterNumSumRange_init(oOptions)
{
attachMouseEvents();
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(420);
}
var y = document.createElement("select");
y.id = "summary";
if (oOptions.sUnSummarized == "" && cf.dlgGlobalGetParm('xxFilterDependancy'))
{
if (oOptions.sNonMeasure == "")
{
document.getElementById("displayNonMeasureSumm").style.display = "none";
document.getElementById("displayMeasureGrp").style.display = "inline";
document.getElementById("displayMeasureNoGrp").style.display = "none";
document.getElementById("measureGrp").appendChild(y);
if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
{
document.f.summarization1[1].checked = "true";
}
else
{
y.disabled = "true";
if ((cf.dlgGlobalGetParm('xxBasedOn') == 'raw') && cf.isDetailFilterEnabled())
{
document.f.summarization1[2].checked = "true";
}
else
{
document.f.summarization1[0].checked = "true";
}
}
if (!cf.isDetailFilterEnabled())
{
document.getElementById("displayBasedOn1").style.display = "none";
document.getElementById("displayBasedOn2").style.display = "none";
}
if (cf.isDetailFilterEnabled())
{
var oInfoMessage = document.getElementById("filterBasedOnInfoMessage");
if (oInfoMessage)
{
oInfoMessage.style.display = "block";
}
}
}
else
{
document.getElementById("displayNonMeasureSumm").style.display = "inline";
document.getElementById("displayMeasureGrp").style.display = "none";
document.getElementById("displayMeasureNoGrp").style.display = "none";
document.getElementById("nonMeasureSumm").appendChild(y);
if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
{
document.f.summarization2[1].checked = "true";
}
else
{
document.f.summarization2[0].checked = "true";
}
}
if (cf.dlgGlobalGetParm('xxBasedOn') && cf.dlgGlobalGetParm('xxBasedOn') != 'summary')
{
y.disabled = "true";
}
for (var i = 0; i < cf.dlgGlobalSize('xxFilterDependancy'); i++)
{
var label = cf.dlgGlobalGetParmAt('xxFilterDependancy', i);
var newOption = new Option(label[1], label[0]);
y.options[y.options.length] = newOption;
if (cf.dlgGlobalGetParm('xxSummaryOf') == label[0])
{
y.options[y.options.length - 1].selected = "true";
}
}
}
else
{
document.getElementById("displayNonMeasureSumm").style.display = "none";
document.getElementById("displayMeasureGrp").style.display = "none";
if (cf.isDetailFilterEnabled())
{
document.getElementById("displayMeasureNoGrp").style.display = "inline";
if (cf.dlgGlobalGetParm('xxBasedOn') == 'raw')
{
document.f.summarization3[1].checked = "true";
}
else
{
document.f.summarization3[0].checked = "true";
}
}
else
{
document.getElementById("displayMeasureNoGrp").style.display = "none";
}
}
summarizationValue = (cf.dlgGlobalGetParm('xxBasedOn') ? cf.dlgGlobalGetParm('xxBasedOn') : "details");
initNullOptions();
var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
if (oTextBoxFrom)
{
oTextBoxFrom.onclick = fromGotFocus;
oTextBoxFrom.onkeypress = fromGotFocus;
oTextBoxFrom.onpaste = fromGotFocus;
}
var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
if (oTextBoxTo)
{
oTextBoxTo.onclick = toGotFocus;
oTextBoxTo.onkeypress = toGotFocus;
oTextBoxTo.onpaste = toGotFocus;
}
if (!textBoxtextBoxFrom.m_oForm.disabled)
{
textBoxtextBoxFrom.m_oForm.focus();
}
};
function filterNumSumRange_setState(enabled)
{
if (document.getElementById("summary"))
{
if (enabled)
{
document.getElementById("summary").removeAttribute("disabled");
}
else
{
document.getElementById("summary").disabled = true;
}
}
return true;
};
function filterNumSumRange_setSummVal(val)
{
if (summarizationValue != val)
{
summarizationValue = val;
}
if (cf.cfgGet("combinedFilters") != null)
{
cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
}
};
function filterPicklist_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
if (filterPicklist_someCheckedSomeUnchecked() || document.f.oExcludeSelectedValues.options[1].selected === true)
{
var promptID = getPromptId();
if (document.f.promptBox.checked)
{
fe.setPrompt(promptID);
}
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
if (sDataType !== "")
{
fe.setDataType(sDataType);
}
var aPromptValues = new Object();
for (i = 0; i < checkBoxListpList.m_oForm.length; i++)
{
if ( checkBoxListpList.m_oForm[i].checked )
{
var str = checkBoxListpList.m_oForm[i].value;
if (document.f.promptBox.checked)
{
var sDisplayValue = cf.getDisplayValueForOption(checkBoxListpList.m_oForm[i]);
var sUseValue = str;
aPromptValues[sUseValue] = sDisplayValue;
}
else
{
var dv = null;
if (checkBoxListpList.m_oForm[i].nextSibling && checkBoxListpList.m_oForm[i].nextSibling.nodeType == 3)
{
dv = checkBoxListpList.m_oForm[i].nextSibling.nodeValue;
}
fe.addValue(str, dv);
}
}
}
if (document.f.promptBox.checked)
{
var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
var sPromptValues = oParamManager.getOptionPromptValues(aPromptValues);
cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
}
}
else if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
cf.updateOrAddPromptParm("p_" + promptID, '');
onlyPrompt = true;
}
return fe;
};
function filterPicklist_execute()
{
submitFilterExpression( filterPicklist_buildFilterExpression() );
};
function filterPicklist_hideLoading()
{
var theDiv = document.getElementById("loadingDiv");
theDiv.parentNode.removeChild(theDiv);
};
function filterPicklist_init(sPromptName, sSearchForLabel, sTypeInLabel)
{
attachMouseEvents();
var x = document.getElementById("link1");
if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
{
x.style.display = "none";
}
var y = document.getElementById("link2");
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
if (sDataType === "MUN")
{
y.style.display = "none";
}
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
if (sDataType !== "MUN")
{
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
}
}
else
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
if (sDataType !== "MUN")
{
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
}
}
x.appendChild(document.createTextNode(sSearchForLabel));
if (y.href)
{
y.appendChild(document.createTextNode(sTypeInLabel));
}
x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
if (cf.dlgGlobalGetParm('xxPromptState') == true)
{
document.f.promptBox.checked = true;
}
else if (cf.dlgGlobalGetParm('xxPromptState') == false)
{
document.f.promptBox.checked = false;
}
else if (sPromptName != "")
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.cfgSet("DialogSize", advClosedSize);
}
initNullOptions();
filterPicklist_sendRequestForList();
};
function filterPicklist_processResponse(response)
{
hideLoading();
cf.dlgGlobalSetParm("xxActiveRequest", null);
if (!cf.checkResponse(response, document, "filterPickList", filterPicklist_sendRequestForList))
{
return;
}
var bPrompting = false;
var sReportSpecification = "";
eval(response);
if(typeof status != "undefined" && status == "working" && typeof tracking != "undefined" && tracking != "")
{
showLoading();
requestTracking = tracking;
var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run&ui.action=wait&m_tracking=";
url += tracking;
if (typeof cf.routingServerGroup != "undefined")
{
url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
}
if (cf.cafContextId != "")
{
url += "&ui.cafcontextid=" + cf.cafContextId;
}
setTimeout("sendWaitRequest('" + url + "');", 100);
}
if (bPrompting && bPrompting === true)
{
sendPromptRequest(sReportSpecification);
}
else
{
requestTracking = "";
var allCheckBoxes = document.f.p_pickList;
if (typeof allCheckBoxes != "undefined")
{
var numFound = 0;
var convertRangeToCheckBoxes = cf.dlgGlobalGetParm("xxConvertRangeToENUM");
if (convertRangeToCheckBoxes)
{
numFound = filterPicklist_convertRangeToCheckBoxes(allCheckBoxes);
}
else
{
for (var i = 0; i < allCheckBoxes.length; i++)
{
for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
{
var useValue = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
if (allCheckBoxes[i].value.toUpperCase() == useValue.toUpperCase())
{
allCheckBoxes[i].checked = true;
checkBoxListpList.updateSelected(true);
checkBoxListpList.checkData();
numFound++;
break;
}
}
for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
{
if (allCheckBoxes[i].value.toUpperCase() == cf.dlgGlobalGetParmAt("xxSelects", k).toUpperCase())
{
allCheckBoxes[i].checked = true;
checkBoxListpList.updateSelected(true);
checkBoxListpList.checkData();
numFound++;
break;
}
}
if (numFound == (cf.dlgGlobalSize("xxPickList") + (cf.dlgGlobalSize("xxSelects") / 2)))
{
break;
}
}
}
}
cf.dlgGlobalRemoveParm("xxPickListIsLoaded");
cf.dlgGlobalRemoveParm("xxSelectsIsLoaded");
}
};
function filterPicklist_convertRangeToCheckBoxes(allCheckBoxes)
{
var convertFromValue = cf.dlgGlobalGetParm("xxConvertRangeFromValue");
convertFromValue = convertFromValue.getAttribute("use");
var convertToValue = cf.dlgGlobalGetParm("xxConvertRangeToValue");
convertToValue = convertToValue.getAttribute("use");
var isString = false;
if (isNaN(convertFromValue) || isNaN(convertToValue))
{
isString = true;
}
if (!isString)
{
for (var i = 0; i < allCheckBoxes.length; i++)
{
currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
if (isNaN(currentCheckBoxValue))
{
isString = true;
break;
}
}
}
if (!isString)
{
convertFromValue = +convertFromValue;
convertToValue = +convertToValue;
}
var currentCheckBoxValue;
var numFound = 0;
if (convertFromValue && convertToValue)
{
for (var i = 0; i < allCheckBoxes.length; i++)
{
currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
if (!isString)
{
currentCheckBoxValue = +currentCheckBoxValue;
}
if ((currentCheckBoxValue >= convertFromValue) && (currentCheckBoxValue <= convertToValue))
{
allCheckBoxes[i].checked = true;
checkBoxListpList.updateSelected(true);
checkBoxListpList.checkData();
numFound++;
}
}
}
return numFound;
};
function filterPicklist_sendRequestForList()
{
sendPicklistRequest();
};
function filterPicklist_sendWaitRequest(url)
{
cf.sendDispatcherRequest(url, processResponse);
};
function filterPicklist_showCancellingIndicator()
{
var theDiv = document.getElementById("loadingDiv");
if(theDiv)
{
var oldSpanText = theDiv.getElementsByTagName("SPAN");
if(oldSpanText.length > 0)
{
var newSpanText = document.createElement("SPAN");
newSpanText.appendChild(document.createTextNode(sCancelIndicator));
theDiv.replaceChild(newSpanText, oldSpanText[0]);
}
}
};
function filterPicklist_showLoading()
{
var theParent = document.getElementById("selectListpList");
var newDiv = document.createElement("DIV");
newDiv.id = "loadingDiv";
newDiv.className = "clsCheckBox";
var loadingIcon = document.createElement("IMG");
loadingIcon.align = "middle";
loadingIcon.src = cf.TREE_LOADING;
newDiv.appendChild(loadingIcon);
var newSpanText = document.createElement("SPAN");
newSpanText.appendChild(document.createTextNode(PMT_TRE_TREE_LOADING));
newSpanText.style.paddingLeft = "4px";
newDiv.appendChild(newSpanText);
newDiv.style.verticalAlign = "middle";
newDiv.style.padding = "2px";
theParent.appendChild(newDiv);
};
function filterPicklist_someCheckedSomeUnchecked()
{
return ((checkBoxListpList.m_iSelectedCount > 0) && (checkBoxListpList.m_iItemCount > checkBoxListpList.m_iSelectedCount));
};
function filterSearch_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
if (searchpSearch.m_oLstChoices.length > 0)
{
var promptID = getPromptId();
if (document.f.promptBox.checked)
{
fe.setPrompt(promptID);
}
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
if (sDataType !== "")
{
fe.setDataType(sDataType);
}
var promptValues = '';
for (i = 0; i < searchpSearch.m_oLstChoices.length; i++)
{
var str = searchpSearch.m_oLstChoices.options[i].value;
var dv = cf.getDisplayValueForOption(searchpSearch.m_oLstChoices.options[i]);
if (document.f.promptBox.checked)
{
promptValues += '';
}
else
{
fe.addValue(str, dv);
}
}
if (document.f.promptBox.checked)
{
promptValues += '';
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
}
else if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
cf.updateOrAddPromptParm("p_" + promptID, '');
onlyPrompt = true;
}
fe.setFilterType("search");
return fe;
};
function filterSearch_execute()
{
cf.cfgSet("LAST_ACTION", "filterSearchExecute");
submitFilterExpression( filterSearch_buildFilterExpression() );
};
function filterSearch_init()
{
attachMouseEvents();
var x = document.getElementById("link1");
var y = document.getElementById("link2");
var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
if (sDataType === "MUN")
{
y.style.display = "none";
}
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
if (sDataType !== "MUN")
{
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
}
}
else
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
if (sDataType !== "MUN")
{
y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
}
}
x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
if (y.href)
{
y.appendChild(document.createTextNode(sFILTER_TYPE_IN_VALUES));
}
x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
if (cf.dlgGlobalGetParm('xxPromptState') == true)
{
document.f.promptBox.checked = true;
}
else if (cf.dlgGlobalGetParm('xxPromptState') == false)
{
document.f.promptBox.checked = false;
}
else if (sXXPromptParam != "")
{
document.f.promptBox.checked = true;
}
initNullOptions();
if (sPromptCB!='')
{
document.f.promptBox.checked = (sPromptCB == 'true' ? true : false);
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(520);
if (searchpSearch.m_oLstChoices.options.length == 0)
{
var uv = null;
var dv = null;
if (cf.dlgGlobalGetParm("xxPickListIsLoaded") != true)
{
for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
{
uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j));
searchpSearch.addNoUpdate(dv, uv);
}
}
if (cf.dlgGlobalGetParm("xxSelectsIsLoaded") != true)
{
for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
{
uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1));
dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k));
searchpSearch.addNoUpdate(dv, uv);
}
}
searchpSearch.update();
cf.dlgGlobalSetParm("xxPickListIsLoaded", true);
cf.dlgGlobalSetParm("xxSelectsIsLoaded", true);
}
}
document.f._sws_pSearch_searchValue.focus();
if (typeof searchpSearch == "object");
{
searchpSearch.startAnimateSearchIcon();
}
sendSearchRequest(true);
};
function filterTimeRange_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
var fromValDisplay = null;
var toValDisplay = null;
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var fromValueString = timePickertimeFrom.sGetValue();
var toValueString = timePickertimeTo.sGetValue();
if (document.getElementById("textBoxstringValueFrom"))
{
if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
{
fromValueString = substVarValueFrom;
fromValDisplay = textBoxstringValueFrom.sGetFormatValue();
}
else if ((fromValueString == '' && fromValueString.length == 0) || (document.f.fromValue[2].checked == true))
{
fromValueString = sFILTER_TIME_EARLIEST;
}
if (document.f.toValue[1].checked == true && substVarValueTo != null)
{
toValueString = substVarValueTo;
toValDisplay = textBoxstringValueTo.sGetFormatValue();
}
else if ((toValueString == '' && toValueString.length == 0) || (document.f.toValue[2].checked == true))
{
toValueString = sFILTER_TIME_LATEST;
}
}
else
{
if ((fromValueString == '' && fromValueString.length == 0) || document.f.fromValue[1].checked == true)
{
fromValueString = sFILTER_TIME_EARLIEST;
}
if ((toValueString == '' && toValueString.length == 0) || document.f.toValue[1].checked == true)
{
toValueString = sFILTER_TIME_LATEST;
}
}
if (((fromValueString != "" && document.f.fromValue[0].checked)&&(toValueString != "" && document.f.toValue[0].checked))&&(fromValueString > toValueString))
{
var tmp = fromValueString;
fromValueString = toValueString;
toValueString = tmp;
}
if (document.f.promptBox.checked)
{
var promptID = getPromptId();
fe.setPrompt(promptID);
var promptValues = '';
if (fromValueString == sFILTER_TIME_EARLIEST && toValueString == sFILTER_TIME_LATEST)
{
onlyPrompt = true;
promptValues = '';
}
else
{
if (fromValueString == sFILTER_TIME_EARLIEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (toValueString == sFILTER_TIME_LATEST)
{
promptValues += '';
promptValues += '';
promptValues += '';
}
else if (fromValueString == toValueString)
{
promptValues += '';
}
else
{
promptValues += '';
promptValues += '';
promptValues += '';
promptValues += '';
}
promptValues += '';
}
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
else
{
if (fromValueString != sFILTER_TIME_EARLIEST)
{
fe.setFrom(fromValueString, (fromValDisplay ? fromValDisplay : fromValueString));
}
if (toValueString != sFILTER_TIME_LATEST)
{
fe.setTo(toValueString, (toValDisplay ? toValDisplay : toValueString));
}
}
return fe;
};
function filterTimeRange_execute()
{
if((document.f.fromValue[0].checked && !timePickertimeFrom.isValid())||(document.f.toValue[0].checked && !timePickertimeTo.isValid()))
{
return;
}
submitFilterExpression( filterTimeRange_buildFilterExpression() );
};
function filterTimeRange_init(oOptions)
{
attachMouseEvents();
var x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
initNullOptions();
filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (oOptions.bPrompt)
{
document.f.promptBox.checked = true;
}
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(oOptions.bUseAdv ? 530 : 460);
}
var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
if (oTimeFrom)
{
oTimeFrom.onclick = fromGotFocus;
oTimeFrom.onkeypress = fromGotFocus;
oTimeFrom.onpaste = fromGotFocus;
}
var oTimeTo = document.getElementById('timeEditBoxtimeTo');
if (oTimeTo)
{
oTimeTo.onclick = toGotFocus;
oTimeTo.onkeypress = toGotFocus;
oTimeTo.onpaste = toGotFocus;
}
if (timePickertimeFrom && timePickertimeFrom.m_oHours && !timePickertimeFrom.m_oHours.disabled)
{
timePickertimeFrom.m_oHours.focus();
}
};
function filterTree_buildFilterExpression()
{
var fe = new cf.CFilterExpression();
onlyPrompt = false;
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
var no = getNullOption();
fe.setNullOption(no);
if (no == "only")
{
return fe;
}
}
var listSeparator = goDialogManager.getMiniQueryManager().getListSeparator();
var promptID = getPromptId();
if (document.f.promptBox.checked)
{
fe.setPrompt(promptID);
}
fe.setDataType('MUN');
var promptValues = '';
var picklistValue = "";
var bFirst = true;
var a = treepList.getSelectionOrder();
for (i = 0; i < a.length; i++)
{
if (document.f.promptBox.checked)
{
promptValues += '';
}
else
{
fe.addValue(a[i].getValue(), a[i].getName());
}
}
if (document.f.promptBox.checked)
{
promptValues += '';
cf.updateOrAddPromptParm("p_" + promptID, promptValues);
}
return fe;
};
function filterTree_execute()
{
submitFilterExpression( filterTree_buildFilterExpression() );
};
function filterTree_init()
{
attachMouseEvents();
var x = document.getElementById("link1");
if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
{
x.style.display = "none";
}
var basedOnVal = filterCommon_initBasedOnDatasourceBox();
if (cf.isDetailFilterEnabled())
{
document.getElementById("filterBasedOnInfoMessage").style.display = "block";
}
if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
}
else
{
x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
}
x.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
x = document.getElementById("colName");
x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
if (cf.dlgGlobalGetParm('xxPromptState') == true)
{
document.f.promptBox.checked = true;
}
else if (cf.dlgGlobalGetParm('xxPromptState') == false)
{
document.f.promptBox.checked = false;
}
else if (sXXPromptName != "")
{
document.f.promptBox.checked = true;
}
initNullOptions();
treepList.setSelectionMode(DISCONTIGUOUS_TREE_SELECTION);
treepList.setSelectTreeUI(CHECKBOX_TREE);
treepList.setAllowDragDrop(false);
treepList.setTrackSelectionOrder(true);
treepList.setNodesCanHaveChildren(true);
treepList.setRootNodeShowing(false);
treepList.setPromptingTree(false);
treepList.setLoadOnTheFlyFunction(loadFunc);
treepList.getRootNode().setCanHaveChildren(true);
if (cf && cf.showDialogFrame)
{
cf.showDialogFrame(advClosedSize);
}
treepList.setupOuterTable();
filterTree_sendRequestForList();
};
function loadFunc(loadingNode)
{
if (loadingNode.getName() == "root")
{
return;
}
else
{
cf.dlgGlobalSetParm('xxFullColExpression', loadingNode.getValue());
filterTree_sendRequestForList();
}
};
function filterTree_processResponse(response)
{
cf.dlgGlobalSetParm("xxActiveRequest", null);
if (!cf.checkResponse(response, document, "filterTreeList", filterTree_sendRequestForList))
{
return;
}
var bPrompting = false;
var sReportSpecification = "";
eval(response);
if (bPrompting && bPrompting === true)
{
sendPromptRequest(sReportSpecification);
return;
}
for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
{
var mun = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
var n = _treenodes[mun];
if (typeof n == "object" && typeof n.setSelected == "function")
{
n.setSelected(true);
}
}
for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
{
var mun = cf.dlgGlobalGetParmAt("xxSelects", k);
var n = _treenodes[mun];
if (n instanceof CTreeNode)
{
n.setSelected(true);
}
}
if(bDrawAll == 'true')
{
treepList.removeLoading(treepList.getRootNode());
treepList.setLoading(false);
setTimeout("treepList.drawAll()", 100);
setTimeout("treepList.checkData()", 110);
treepList.getRootNode().m_bRendered = true;
}
else
{
if(typeof addToNode != "undefined")
{
treepList.childrenReadyForNode(_treenodes[addToNode]);
}
else
{
if(cf.dlgGlobalGetParm('xxFullColExpression') )
{
treepList.childrenReadyForNode(_treenodes[cf.dlgGlobalGetParm('xxFullColExpression')]);
}
}
}
};
function filterTree_sendRequestForList()
{
var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
if (activeRequest != null)
{
cf.cancelDispatcherRequest(activeRequest);
}
var url = "m=/" + cf.qs_dir + "/filterTreeRequest.xts&b_action=xts.run";
if (cf.dlgGlobalGetParm('xxFullColExpression'))
{
url += "&xxFullColExpression=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFullColExpression'));
}
if (cf.dlgGlobalGetParm('xxModelName'))
{
url += "&xxModelName=" + encodeURIComponent(cf.dlgGlobalGetParm('xxModelName'));
}
if (cf.dlgGlobalGetParm('xxColid'))
{
url += "&xxColid=" + encodeURIComponent(cf.dlgGlobalGetParm('xxColid'));
}
if (cf.dlgGlobalGetParm('xxRetrievePrompt'))
{
url += "&xxRetrievePrompt=" + encodeURIComponent(cf.dlgGlobalGetParm('xxRetrievePrompt'));
}
if (cf.dlgGlobalGetParm('xxSearchPath'))
{
url += "&xxSearchPath=" + encodeURIComponent(cf.dlgGlobalGetParm('xxSearchPath'));
}
if (cf.dlgGlobalGetParm('xxFilterItemRef'))
{
url += "&xxFilterItemRef=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRef'));
}
if (cf.dlgGlobalGetParm('xxFilterItemRefExp'))
{
url += "&xxFilterItemRefExp=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRefExp'));
}
if (cf.dlgGlobalGetParm('xxPromptParam'))
{
if (isPromptParamAndIdEncoded())
{
url += "&xxPromptParam=" + cf.dlgGlobalGetParm('xxPromptParam');
}
else
{
url += "&xxPromptParam=" + encodeURIComponent(cf.dlgGlobalGetParm('xxPromptParam'));
}
}
for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
{
url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
}
for (var i = 0; i < cf.dlgGlobalSize('xxPromptCascade'); i++)
{
url += "&xxPromptCascade=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptCascade', i));
}
for (var i = 0; i < cf.dlgGlobalSize('xxCreds'); i++)
{
url += "&xxCreds=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxCreds', i));
}
for (var i = 0; i < cf.dlgGlobalSize('xxPromptValues'); i++)
{
url += "&xxPromptValues=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptValues', i));
}
if (cf.dlgGlobalGetParm('xxExprLocale'))
{
url += "&xxExprLocale=" + encodeURIComponent(cf.dlgGlobalGetParm('xxExprLocale'));
}
if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
{
url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
}
if (cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters() !== null)
{
url += "¶meterValues=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters());
}
else if (cf.cfgGet('parameterValues'))
{
url += "¶meterValues=" + encodeURIComponent(cf.cfgGet('parameterValues'));
}
if (typeof cf.routingServerGroup != "undefined")
{
url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
}
if (cf.cafContextId != "")
{
url += "&ui.cafcontextid=" + cf.cafContextId;
}
url += "&depth=2&textBoxControl=treepList";
if (cf.cfgGet("markup_track") != "undefined")
{
url += "&markup_track=" + cf.cfgGet("markup_track");
}
cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
};
function getColumnIdFromFCId (sFCId)
{
var oMQMgr = goDialogManager.getMiniQueryManager();
if(typeof cf.dialogGlobalValues["xxNewFilter"] != "undefined")
{
var oColumn = oMQMgr.getColumnById(sFCId);
if (oColumn !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
return sFCId;
}
else
{
var oCC= cf.getCombinedFilter();
if(oCC)
{
var filterNode=oCC.getFilterById(sFCId);
if(filterNode)
{
var cid=filterNode.getColumnId();
return cid;
}
}
}
return "";
}
var oColumn1 = oMQMgr.getColumnFromFilter(sFCId);
if (oColumn1 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
return oColumn1.getAttribute("id");
}
var oColumn2 = oMQMgr.getColumnById(sFCId);
if (oColumn2 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
return sFCId;
}
return "";
};
function getFilterDataType (sFCId)
{
var oMQMgr = goDialogManager.getMiniQueryManager();
var sColumnId = getColumnIdFromFCId(sFCId);
var sDataType = "";
if(sColumnId === "")
{
var sType = oMQMgr.getFilterDataType(sFCId);
if(sType != oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
{
return sType;
}
if (cf.dlgGlobalGetParm('xxFilterIsString'))
{
sDataType = "string";
}
else if (cf.dlgGlobalGetParm('xxUseMUN'))
{
sDataType = "MUN";
}
return sDataType;
}
var sPromptFilterItemRef = oMQMgr.getPromptFilterItemRef(sColumnId);
var sPromptUseItemRef = oMQMgr.getPromptUseItemRef(sColumnId);
var bPromptFilterRefIsString = oMQMgr.isPromptFilterItemRefString(sColumnId);
var bPromptUseItemRefIsString = oMQMgr.isPromptUseItemRefString(sColumnId);
var bColumnIsMUN = oMQMgr.isMUN(sColumnId);
var bIsString = cf.dlgGlobalGetParm('xxFilterIsString') && !bColumnIsMUN;
if (sPromptUseItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
{
bIsString = bPromptUseItemRefIsString;
}
else if (sPromptFilterItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
{
bIsString = bPromptFilterRefIsString;
}
var aFilters = oMQMgr.getFiltersForColumn(sColumnId);
for (var key in aFilters)
{
try
{
var oObject = aFilters[key];
var sExistingFilterDataType = oObject.getElementsByTagName("FilterExpression")[0].getElementsByTagName("FE")[0].getAttribute("dataType");
if (sExistingFilterDataType === "string")
{
bIsString = true;
break;
}
}
catch (e)
{
}
}
if (bIsString)
{
sDataType = "string";
}
else if (bColumnIsMUN == true && sPromptFilterItemRef === oMQMgr.MINI_QUERY_NONE_STR && sPromptUseItemRef === oMQMgr.MINI_QUERY_NONE_STR)
{
sDataType = "MUN";
}
return sDataType;
};
function executeOk(evt)
{
var oDialogManager = new CDialogManager();
if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
{
execute();
}
};
function executeCancel(evt)
{
var oDialogManager = new CDialogManager();
if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
{
typeof this.cancelDialog == 'function' ? this.cancelDialog() : getConfigFrame().hideDialogFrame();
}
};
function sendPromptRequest(sReportSpecification)
{
var cf = getConfigFrame();
sReportSpecification = sReportSpecification.replace(/^\s+|\s+$/,"");
var oReportManager = goDialogManager.getApplicationManager().getReportManager();
var oQSRequest = oReportManager.createRequest("runSpecification");
oQSRequest.setRequestType("post");
oQSRequest.addOption("m", "prompting/promptDataSource.xts");
oQSRequest.addOption("ccs_invoke", "parent");
oQSRequest.addOption("isEncoded", "1");
oQSRequest.addOption("specification", sReportSpecification);
oQSRequest.addOption("b_action", "xts.run");
oQSRequest.addOption("ui.action", "collectParameterValuesSpecification");
oQSRequest.addOption("releaseConversation", "1");
if (typeof cf.cafContextId === "string")
{
oQSRequest.addOption("ui.cafcontextid", cf.cafContextId);
}
if (typeof cf.routingServerGroup === "string")
{
oQSRequest.addOption("routingServerGroup", cf.routingServerGroup);
}
oQSRequest.addOption("tracking", oReportManager.getCVObj().getTracking());
cf.hideDialogFrame();
oReportManager.sendQSRequest(oQSRequest);
};