Filter Product List

import com.imc.context.filters.ConditionAttribute;
import com.imc.context.filters.Condition.OPERATOR;
import com.imc.context.filters.Condition;
import com.google.common.collect.Sets;
import com.imc.vocabulary.Schema;
import com.imc.iss.groovy.salesitem.SalesItemsTree;
import com.imc.iss.groovy.lookupTable.GroovyLookupTable;
import com.imc.util.NullUtil;
import org.apache.commons.lang3.StringUtils;
import com.imc.datamodel.BusinessType;
import org.apache.commons.lang3.tuple.Pair;
import org.apache.jena.ext.com.google.common.collect.Lists;
import com.imc.datamodel.BusinessRelationAttribute;
import com.imc.iss.groovy.orgUnit.OrgUnit;
import com.imc.iss.groovy.GroovyCtxUtil;
import com.imc.iss.groovy.orgUnit.OrgUnitHierarchy;
import com.imc.datamodel.BusinessObject
import com.imc.context.filters.ConditionAggregate
import com.imc.context.filters.ConditionAggregateAND
import com.imc.context.filters.ConditionAggregateOR
 
 
/*
* 
* Groovy implementation of product filtering
*    
*  Binding variables
*  groovyLogger : GroovyLogger
*  groovyCtxUtil : GroovyCtxUtil
*  filterProductScript : Collection<Condition> 
*  userInfo : UserInfo 
*  employee : Employee 
*  contact  : Contact 
*  account  : Account 
*  dbLookupTable : GroovyLookupTable 
*/
 
 
def productCategoryList = [];
def materialGroupList = [];
ConditionAggregateAND conditionAggregateAND1 = new ConditionAggregateAND();
ConditionAggregateAND conditionAggregateAND2 = new ConditionAggregateAND();
ConditionAggregateOR conditionAggregateOR = new ConditionAggregateOR();
 
// Returns true if it's an eCommerce user.
groovyLogger.logDebug("Is this the Commerce User : "+ groovyCtxUtil.isCommerce());
 
// Get the user binding variable.
String username = userInfo.getUsername();
String userURI = userInfo.getUserBO().getUriAsString();
groovyLogger.logDebug("UserInfo user name : "+ username);
 
 
if(groovyCtxUtil.isCommerce() && binding.hasVariable('contact'))
{
    // eCommerce Product filter
    // Get the contact binding variable.
    String contactName = contact.getContactDataAttributeValue("http://www.inmindcloud.com/application/schema.owl#objectName");

    // Get the account binding variable.
    String accountGroup = account.getAccountDataAttributeValue("http://www.inmindcloud.com/application/schema.owl#accountGroup");

    // Query the lookup table.
    def rawData = dbLookupTable.table('PRODUCT_FILTER_URI').addSelectFields('account_group', 'product_category', 'material_group').addCondition('account_group', '==', accountGroup).search();

    rawData.each { line ->
        def productCategory = line['PRODUCT_CATEGORY']
        def materialGroup = line['MATERIAL_GROUP']
        
        if (!NullUtil.isNullorEmpty(productCategory)) {
            productCategoryList.add(productCategory)
        }
        
        if (!NullUtil.isNullorEmpty(materialGroup)) {
            materialGroupList.add(materialGroup)
        }
    }
    
    Condition condition01 = filterFactory.getCondition(Schema.Product, Schema.hasProductClassification, Schema.objectName, "Product", OPERATOR.EQUAL);
    conditionAggregateAND1.and(condition01);
    
    if (productCategoryList.size() > 0)
    {
        Condition condition02 = filterFactory.getCondition(Schema.Product, Schema.linksProductCategory, Schema.objectName, productCategoryList, OPERATOR.EQUAL);
        conditionAggregateAND1.and(condition02);
    }
    
    
    Condition condition03 = filterFactory.getCondition(Schema.objectERPId, "BT" , OPERATOR.EQUAL);
    conditionAggregateAND2.and(condition03);
    if (materialGroupList.size() > 0)
    {
        Condition condition04 = filterFactory.getCondition(Schema.Product, Schema.hasProductMaterialGroup, Schema.objectName, materialGroupList, OPERATOR.EQUAL);
        conditionAggregateAND2.and(condition04);
    }

    // Final condition setup.
    conditionAggregateOR.or(conditionAggregateAND1)
    conditionAggregateOR.or(conditionAggregateAND2)
    
    if (!conditionAggregateAND1.getConditions().isEmpty()){
        filterProductScript.add(conditionAggregateOR);
    }
} else {
    // CPQ Product filter
    // Get the employee binding variable.
    String employeeName = employee.getEmployeeDataAttributeValue("http://www.inmindcloud.com/application/schema.owl#objectName");

    // Query the lookup table.
    def rawData = dbLookupTable.table('PRODUCT_FILTER_URI').addSelectFields('account_group', 'product_category', 'material_group').addCondition('account_group', '==', accountGroup).search();

    rawData.each { line ->
        def productCategory = line['PRODUCT_CATEGORY']
        def materialGroup = line['MATERIAL_GROUP']
        
        if (!NullUtil.isNullorEmpty(productCategory)) {
            productCategoryList.add(productCategory)
        }
        
        if (!NullUtil.isNullorEmpty(materialGroup)) {
            materialGroupList.add(materialGroup)
        }
    }


    if (productCategoryList.size() > 0)
    {
        Condition condition01 = filterFactory.getCondition(Schema.Product, Schema.linksProductCategory, Schema.objectName, productCategoryList, OPERATOR.EQUAL);
        conditionAggregateAND1.and(condition01);
    }
    
    if (materialGroupList.size() > 0)
    {
        Condition condition02 = filterFactory.getCondition(Schema.Product, Schema.hasProductMaterialGroup, Schema.objectName, materialGroupList, OPERATOR.EQUAL);
        conditionAggregateAND1.and(condition02);
    }
    
    if (!conditionAggregateAND1.getConditions().isEmpty()){
        filterProductScript.add(conditionAggregateAND1);
    }
}