analytics/webcontent/qs/dialogs/customizeRangesDialog.js

/****************************************************************
** 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 buildCustomRangesCalcExpression()
{
	var sColExp = cf.dlgGlobalGetParm('xxColumnExpression');
	var sDecimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
	var sListSeparator = goDialogManager.getMiniQueryManager().getListSeparator();

	var sCalcExpr = "";
	var bIsFirst = true;
	var bIfOutput = false;
	for (var i = 0; i < customRangeNames.length; i++)
	{
		var oRangeLiteral = new CRangeLiteral(customRangeValues[i], customRangeNames[i]);
		var iRangeType = oRangeLiteral.getFilterType();
		if (bIsFirst)
		{
			sCalcExpr = "if (";
			bIsFirst = false;
		}
		else
		{
			sCalcExpr += " else if (";
		}
			
		if (cf.dlgGlobalGetParm('xxCustomType') == '1' && cf.dlgGlobalGetParm('xxAggregateType') != null)
		{
			sCalcExpr += cf.dlgGlobalGetParm('xxAggregateType') + "(" + sColExp + ")";
		}
		else if (cf.dlgGlobalGetParm('xxCustomType') != '0')
		{
			sCalcExpr += sColExp;
		}

		if (cf.dlgGlobalGetParm('xxCustomType') == '0')
		{
			switch (iRangeType)
			{
				case 0: 
					sCalcExpr += "substring(" + sColExp + ", 1, " + oRangeLiteral.getFirstValue().length + ") in_range {'" + oRangeLiteral.getFirstValue().replace(/'/g, "''").replace("\.", sDecimalSeparator) + "'}";
					break;
				case 1: 
					sCalcExpr += "substring(" + sColExp + ", 1, " + oRangeLiteral.getFirstValue().length + ") in_range {'" + oRangeLiteral.getFirstValue().replace(/'/g, "''").replace("\.", sDecimalSeparator) + "':}";
					break;
				case 2: 
					sCalcExpr += "substring(" + sColExp + ", 1, " + oRangeLiteral.getSecondValue().length + ") in_range {:'" + oRangeLiteral.getSecondValue().replace(/'/g, "''").replace("\.", sDecimalSeparator) + "'}";
					break;
				case 3: 
					sCalcExpr += "substring(" + sColExp + ", 1, " + oRangeLiteral.getSecondValue().length + ") in_range {'" + oRangeLiteral.getFirstValue().replace(/'/g, "''").replace("\.", sDecimalSeparator) + "' : '" + oRangeLiteral.getSecondValue().replace(/'/g, "''").replace("\.", sDecimalSeparator) + "'}";
					break;
				default:
					return;
			}
		}
		else
		{
			var sFirstValue = oRangeLiteral.getFirstValue();
			var sSecondValue = oRangeLiteral.getSecondValue();
			if ((cf.dlgGlobalGetParm('xxCustomType') != '3') && (cf.dlgGlobalGetParm('xxCustomType') != '4') && (cf.dlgGlobalGetParm('xxCustomType') != '5'))
			{
				
				if (sFirstValue)
				{
					sFirstValue = sFirstValue.replace("\.", sDecimalSeparator);
				}
				if (sSecondValue)
				{
					sSecondValue = sSecondValue.replace("\.", sDecimalSeparator);
				}
			}

			switch (iRangeType)
			{
				case 0: 
					sCalcExpr += " in_range {" + sFirstValue + "}";
					break;
				case 1: 
					sCalcExpr += " in_range {" + sFirstValue + ":}";
					break;
				case 2: 
					sCalcExpr += " in_range {:" + sSecondValue + "}";
					break;
				case 3: 
					sCalcExpr += " in_range {" + sFirstValue + " : " + sSecondValue + "}";
					break;
				default:
					return;
			}
		}
		sCalcExpr += ") then ('" + customRangeNames[i].replace(/'/g, "''") + "')";
		bIfOutput = true;
	}
	
	var oMQMgr = goDialogManager.getMiniQueryManager();

	if (bIfOutput)
	{
		sCalcExpr += " else (";
	}
	else if (customRangeNames.length == 0)
	{
		var oMQCols = oMQMgr.getElementsByAttribute("expression", sColExp);
		if (oMQCols.length > 0 && oMQMgr.isNumeric(oMQCols[0]))
		{
			sCalcExpr = "if (" + sColExp + " in_range {1:0}) then (null) else (";
		}
		else
		{
			sCalcExpr = "if (" + sColExp + " in ('')) then (null) else (";
		}
	}
	if (sCalcExpr != "")
	{
		
		if (document.f.remaining_values_options[0].checked == true)
		{
			if (cf.dlgGlobalGetParm('xxCustomType') == '0')
			{
				sCalcExpr += sColExp;
			}
			else if (cf.dlgGlobalGetParm('xxCustomType') == '1')
			{
				var iNumDecs
				var iColumnIdx = cf.dlgGlobalGetParm('xxColumnIndex');
				var colDataType = oMQMgr.getDataType(iColumnIdx);
				
				
				
				if(colDataType == 3 || colDataType == 20 || colDataType == 30 || colDataType == 31 || colDataType == 32)
				{
				    iNumDecs = (cf.dlgGlobalGetParm('xxNumDecimals') ? cf.dlgGlobalGetParm('xxNumDecimals') : 2);
				}
				else
				{
				    iNumDecs = (cf.dlgGlobalGetParm('xxNumDecimals') ? cf.dlgGlobalGetParm('xxNumDecimals') : 0);
				}
				
				if (parseInt(iNumDecs) > 6)
				{
					iNumDecs = 6;
				}
				if (cf.dlgGlobalGetParm('xxAggregateType') == null)
				{
					
					if(gsCustomGroups == "TRUE")
							sCalcExpr += "CAST(CAST((" + sColExp + ") as decimal(20" + sListSeparator + iNumDecs + ")) as varchar(20))";
					else
							sCalcExpr += "CAST(CAST((" + sColExp + ") as decimal(20" + sListSeparator + iNumDecs + ")) as nvarchar(20))";
					}
				else
				{
					
					if(gsCustomGroups == "TRUE")
							sCalcExpr += "CAST(CAST(" + cf.dlgGlobalGetParm('xxAggregateType') + "(" + sColExp + ") as decimal(20" + sListSeparator + iNumDecs + ")) as varchar(20))";
					else
							sCalcExpr += "CAST(CAST(" + cf.dlgGlobalGetParm('xxAggregateType') + "(" + sColExp + ") as decimal(20" + sListSeparator + iNumDecs + ")) as nvarchar(20))";
				}
			}
			else
			{
				
				if(gsCustomGroups == "TRUE")
						sCalcExpr += "CAST(" + sColExp + " as varchar(30))";
				else
						sCalcExpr += "CAST(" + sColExp + " as nvarchar(30))";
			}
		}
		else if ((document.f.remaining_values_options[1].checked == true) || (document.f.remaining_values_options[2].checked == true && document.f.range_name_text.value == ""))
		{
			sCalcExpr += "null";
		}
		else
		{
			
			if(gsCustomGroups == "TRUE")
					sCalcExpr += "CAST('" + document.f.range_name_text.value.replace(/'/g, "''") + "' as varchar(30))";
			else
					sCalcExpr += "CAST('" + document.f.range_name_text.value.replace(/'/g, "''") + "' as nvarchar(30))";	
		}
		sCalcExpr += ")";
	}

	return sCalcExpr;
};