analytics/webcontent/qs/classes/CReportDefinition.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 CReportDefinition()
{
};

CReportDefinition.prototype = new AFeatureObject();

CReportDefinition.prototype.setup = function (aFeatureParams)
{
	reportDefinition();
};

function reportDefinition()
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	dlgReset();
	dlgGlobalReset();
	var usedFilters = new Array();
	for (var i = 0; i < oMQMgr.getAllColumns().length; i++)
	{
		var calcOp = oMQMgr.getCalcOp(i);
		if (calcOp !== MINI_QUERY_NO_COLUMN_FOUND && calcOp !== MINI_QUERY_ATTRIBUTE_NOT_FOUND)
		{
			if (calcOp.substring(0,5) == "range" || calcOp.substring(0,5) == "group")
			{
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(i), oMQMgr.getExpression(i), "customvalue"));
			}
			else
			{
				var colExp;
				if (oMQMgr.getDetailAggregate(i) != "calculated")
				{
					colExp = oMQMgr.getCalculatedExpression(i);
				}
				else
				{
					colExp = oMQMgr.getExpression(i);
				}
				var calculationType = "calculation";
				if (oMQMgr.isMeasure(i) === true)
				{
					calculationType += "_fact";
				}
				else if (oMQMgr.getUsage(i) == 2)
				{
					calculationType += "_dimension";
				}
				else
				{
					calculationType += "_attribute";
				}
				
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(i), colExp, calculationType));
			}
		}
		else
		{
			var colOp;
			if (oMQMgr.isMeasure(i) === true)
			{
				colOp = "query_item_measure";
			}
			else
			{
				colOp = "query_item_attribute";
			}
			
			
			
			
			dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(i), oMQMgr.getExpression(i), colOp));
		}
		
		
		var oColumn = oMQMgr.getColumnLabel(i);
		var aFilters = oMQMgr.getFiltersForColumn(oColumn);
		
		if(aFilters && aFilters.length)
		{
		    
		    if(aFilters[0].nextSibling == null && aFilters[0].previousSibling == null)
		    {
		        var oFilter = (aFilters[0] instanceof CFilter ? aFilters[0] : new CFilter("", aFilters[0]));
		        var arExpr = oFilter.getText();
		        var sFilterType =  goApplicationManager.get("filterTitleDefault");
		        colOp = goApplicationManager.get("filterTitleDefault");
		        dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(sFilterType, arExpr, colOp));
            }
		}
	}
	
	
	var oCC = getCombinedFilter();
	
	if(oCC)
	{   
	    var smFilter = oCC.getSummaryFilter();
	    var rwFilter = oCC.getRawFilter();
	    var rwFilterC = rwFilter.getColumnIds();
	    var smFilterC = smFilter.getColumnIds();
	    var sFilterType = goApplicationManager.get("filterCombineTitleDefault");
	    var predicate = null;
	    var operator = null;
	    
	    
	    if(rwFilterC.length > 1)
	    {
	        predicate = rwFilter.getPredicates();
	        operator = rwFilter.getOperator();
	        displayFilter(predicate, operator, sFilterType);
	    }
	    
	    
	    if(smFilterC.length > 1)
	    {
	        predicate = smFilter.getPredicates();
	        operator = smFilter.getOperator();
	        displayFilter(predicate, operator, sFilterType);
	    }
    }
		
	dlgSetParm("m", "/" + qs_dir + "/reportDefinition.xts");
	dlgSubmit();
};

function Filter(){
this.arExpr;
this.recursiveCounter;
this.isRecursiveCall;
this.firstTime;
};


function displayFilter(predicate, operator, sFilterType)
{
    var fv = new Filter();
    
	fv.arExpr = "";
	fv.recursiveCounter = 0;
	fv.isRecursiveCall = false;
    fv.firstTime = true;
    
    var colOp = goApplicationManager.get("filterTitleDefault");
    for (var i = 0; i < predicate.length; i++)
    {
        if(predicate[i] instanceof CFilterGroup)
        {
        	
            fv.arExpr = fv.retrieveChildGroupsAndFilters(predicate[i], operator, fv);
            fv.arExpr += (i != (predicate.length - 1)) ? ") " + operator + "  " : ")";
            fv.recursiveCounter--;
        }
        else
        {   
            fv.arExpr += predicate[i].getText();
            if(i != (predicate.length - 1))
            {
                fv.arExpr += "  " + operator + "  ";
            }
        }
        
        
        fv.firstTime = true;
        fv.recursiveCounter = 0;
    }

	
	if(fv.arExpr.indexOf("\) OR \)") != -1) {
	fv.arExpr = fv.arExpr.replace(/\) OR \)/g,"))");
	}
	if(fv.arExpr.indexOf("\) AND \)") != -1) {
	fv.arExpr = fv.arExpr.replace(/\) AND \)/g,"))");
	}
	
    dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(sFilterType, fv.arExpr, colOp));
};


	
Filter.prototype.retrieveChildGroupsAndFilters = function(predicate, opr1, fv) {

	fv.arExpr += fv.arExpr.length == 0 ? "(" : "(";
	var prd = predicate.getPredicates();
	var opr = predicate.getOperator();

     
	for (var j = 0; j < prd.length; j++) {
		if (prd[j] instanceof CFilterGroup) {
			fv.recursiveCounter++;
			fv.isRecursiveCall = true;
			fv.arExpr = fv.retrieveChildGroupsAndFilters(prd[j], opr, fv);
		} else {
			fv.arExpr += prd[j].getText();
			if (j != (prd.length - 1)) {
				fv.arExpr += "  " + opr + "  ";
			}
		}
	}
    
    
	if (fv.isRecursiveCall) {
		if (fv.recursiveCounter == 1) {
			if (!fv.firstTime)
				fv.arExpr += ")";
			else {
				fv.arExpr += ") " + opr1 + " ";
				fv.firstTime = false;
			}
		} else
		    if (fv.recursiveCounter > 1) 
			    fv.arExpr += ") " + opr1 + " ";
	}
	
	fv.recursiveCounter--;
	return fv.arExpr;
};