SoqlBuilder.cls

global class SoqlBuilder implements Soqlable{
	
    private Set<Object>     selectx     = null;
    private Boolean         selectCount = false;
    private Boolean         selectAverage = false;
    private Boolean         selectSum = false;
    private Boolean         selectMin = false;
    private Boolean         selectMax = false;
	private String 			aggx		= null;  
    private String          fromx       = null;
    private Condition       wherex      = null;
    private List<OrderBy>   orderByx    = null;
    private String          groupByx    = null;
    private Integer         limitx      = null;
    public Boolean 			hoopla {get; set;}
    public String 			groupByField {get; set;}
        
    global SoqlBuilder(){
    	hoopla = false;
    }

    global SoqlBuilder(Boolean hoopla){
    	this.hoopla = hoopla;
    }
    
    global SoqlBuilder selectx(String field){ 
    	return addToSelect(field);
    }
    
    global SoqlBuilder selectx(Field field){ 
        return addToSelect(field);
    }
    
    global SoqlBuilder selectx(SoqlBuilder field){ 
        return addToSelect(field);
    }
     
    global SoqlBuilder selectx(List<Object> fields){ 
        return selectx(ApexLangUtils.listToSet(fields));
    }
    
    global SoqlBuilder selectx(Set<Object> fields){ 
    	if(fields != null && fields.size() > 0){
    		for(Object field : fields){
    			addToSelect(field);
    		}
    	}
        return this;
    }
    
    private SoqlBuilder addToSelect(Object field){
        if(field == null){
            throw new IllegalArgumentException('null field');
        }
        if(field instanceof String || field instanceof Field || field instanceof SoqlBuilder ){
	        if(selectx == null){
	            selectx = new Set<Object>();
	        }
	        selectx.add(field);
        } else {
            throw new IllegalArgumentException('Invalid field type.  A field must be either a String, Field, or SoqlBuilder.');
        }
        this.selectCount = false;
        return this;
    }

    global SoqlBuilder selectCount(){ 
        return selectCountx();
    }

    global SoqlBuilder selectCountx(){ 
        this.selectCount = true;
        return this;
    }

    global SoqlBuilder selectCount(String aggx){ 
		this.aggx = aggx;
        return selectCountx();
    }

    global SoqlBuilder selectAveragex(String aggx){ 
        this.selectAverage = true;
		this.aggx = aggx;
        return this;
    }

    global SoqlBuilder selectSumx(String aggx){ 
        this.selectSum = true;
		this.aggx = aggx;
        return this;
    }

    global SoqlBuilder selectMinx(String aggx){ 
        this.selectMin = true;
		this.aggx = aggx;
        return this;
    }

    global SoqlBuilder selectMaxx(String aggx){ 
        this.selectMax = true;
		this.aggx = aggx;
        return this;
    }

    global SoqlBuilder fromx(String fromx){
        this.fromx = fromx; 
        return this;
    }

    global SoqlBuilder wherex(Condition wherex){ 
        this.wherex = wherex;
    	return this;
    }
    
    global SoqlBuilder orderByx(OrderBy orderByx){ 
    	if(this.orderByx == null){
    		this.orderByx = new List<OrderBy>();
    	}
    	this.orderByx.add(orderByx);
        return this;
    }

    global SoqlBuilder orderByx(List<OrderBy> orderByx){ 
        if(orderByx != null && orderByx.size() > 0){
            for(OrderBy field : orderByx){
                orderByx(field);
            }
        }
        return this;
    }
    
   global SoqlBuilder groupByx(String groupByx){
        this.groupByx = groupByx; 
        return this;
    }

    global SoqlBuilder limitx(Integer limitx){
        this.limitx = limitx; 
        return this;
    }    
    
    global String toSoql(){ return this.toSoql(null); }
    
    global String toSoql(SoqlOptions options){
    	
        //Special @hooplasoftware mod
        if(aggx == null && hoopla == true)
        	aggx = 'id';
        
        if(options == null){
            options = SoqlOptions.DEFAULT_OPTIONS;
        }
        if(ApexLangUtils.isBlank(fromx)){
            throw new IllegalStateException('Illegal state!  You must invoke fromx() with valid object name before invoking toSoql().');
        }
        Boolean isFirst = true;

		String soql;
        if(hoopla)
	         soql = 'SELECT ' + groupByField + ', ';
	    else
	         soql = 'SELECT ';
        
        
        if(selectx == null){
            selectx = new Set<Object>();
        }
        if(this.selectCount != null && this.selectCount && aggx == null){
        	soql += 'COUNT()';
        } else if (this.selectCount != null && this.selectCount) {  
        		soql += 'COUNT(' + aggx + ')';
        } else if (this.selectAverage != null && this.selectAverage){
 				soql += 'AVG(' + aggx + ')';
	    } else if (this.selectSum != null && this.selectSum){
 				soql += 'SUM(' + aggx + ')';
        } else if (this.selectMin != null && this.selectMin) {
 				soql += 'MIN(' + aggx + ')';
        } else if (this.selectMax != null && this.selectMax) {
 				soql += 'MAX(' + aggx + ')';
        } else {
        	if (selectx.size() <= 0){
	            selectx.add('id');
	        }
	        String distinctField = null;
	        Map<String,String> distinctFields = new Map<String,String>();
            for(Object value : selectx){
                if(value instanceof Field){
                    distinctField = ((Field)value).toSoql(options);
                } else if(value instanceof SoqlBuilder){
                    distinctField = '(' + ((SoqlBuilder)value).toSoql(options) + ')';
                } else {
                    distinctField = ''+value;
                }
                distinctField = ApexLangUtils.trim(distinctField);
                distinctFields.put(ApexLangUtils.lowerCase(distinctField),distinctField);
            }
            soql += ApexLangUtils.joinStrings(distinctFields.values(),',');
        }
        soql += ' FROM ' + fromx;
        if(wherex != null){
	        //@hooplasoftware MOD
			if(hoopla) 
			{
				soql += ' WHERE ' + groupByField + ' IN {!Users} ';  
				String wherexs = wherex.toSoql(options);
				if(wherexs != null && wherexs != '')  
					soql += ' AND ' + wherex.toSoql(options); 
			}
			else
				soql += ' WHERE ' + wherex.toSoql(options);
				
        }
          
        if(groupByx != null && groupByx != ''){
           soql += ' GROUP BY ' + groupByx + ' ';
        }
          
        if(orderByx != null && orderByx.size() > 0){
            isFirst = true;
        	for(OrderBy orderBy : orderByx){
        		if(orderBy == null){
        			continue;
        		}
	            if(isFirst){  
	                isFirst = false;
                    soql += ' ORDER BY ';
	            } else {
	                soql += ', ';
	            }
                soql += orderBy.toSoql(options);
        	}
        }
        if(limitx != null){
            soql += ' LIMIT ' + limitx;
        }
        return soql;
    }
    
    
}