XEQueryBuilder.js

// The database of options for the UI elements.
var XEqueryBuilderDB = {
    "type":{
        "operators":["=","!=","IN"],
        "constants":["TYPE_DAMAGE","TYPE_MISS","TYPE_HEAL","TYPE_AURA","TYPE_DEATH","TYPE_CAST","TYPE_DISPEL","TYPE_GAIN",
            "TYPE_ENCHANT","TYPE_DURABILITY","TYPE_SUMMON","TYPE_OTHER"],
        "description":"Event type"
    },
    "fullType":{
        "operators":["=","!=","IN"],
        "constants":["SWING_DAMAGE","RANGE_DAMAGE","SPELL_DAMAGE","SPELL_PERIODIC_DAMAGE","DAMAGE_SPLIT","DAMAGE_SHIELD",
            "ENVIRONMENTAL_DAMAGE","SPELL_BUILDING_DAMAGE","SWING_MISSED","RANGE_MISSED","SPELL_MISSED","SPELL_PERIODIC_MISSED",
            "DAMAGE_SHIELD_MISSED","SPELL_HEAL","SPELL_PERIODIC_HEAL","SPELL_BUILDING_HEAL","SPELL_AURA_APPLIED",
            "SPELL_AURA_APPLIED_DOSE","SPELL_AURA_REMOVED","SPELL_AURA_REMOVED_DOSE","SPELL_EXTRA_ATTACKS","SPELL_AURA_REFRESH",
            "PARTY_KILL","UNIT_DIED","UNIT_DESTROYED","SPELL_INSTAKILL","SPELL_CAST_START","SPELL_CAST_SUCCESS","SPELL_CAST_FAILED",
            "SPELL_INTERRUPT","SPELL_DISPEL","SPELL_DISPEL_FAILED","SPELL_STOLEN","SPELL_AURA_BROKEN","SPELL_AURA_BROKEN_SPELL",
            "SPELL_ENERGIZE","SPELL_DRAIN","SPELL_LEECH","SPELL_PERIODIC_ENERGIZE","SPELL_PERIODIC_DRAIN","SPELL_PERIODIC_LEECH",
            "ENCHANT_APPLIED","ENCHANT_REMOVED","SPELL_DURABILITY_DAMAGE","SPELL_DURABILITY_DAMAGE_ALL","SPELL_SUMMON","SPELL_CREATE",
            "SPELL_RESURRECT"],
        "description":"Full event type"
    },
    "missType":{
        "operators":["=","!=","IN"],
        "constants":["MISS_ABSORB","MISS_BLOCK","MISS_DEFLECT","MISS_DODGE","MISS_EVADE","MISS_IMMUNE","MISS_MISS","MISS_PARRY",
            "MISS_RESIST","MISS_REFLECT","MISS_MISFIRE"],
        "description":"Event (TYPE_MISS) miss type"
    },
    "powerType":{
        "operators":["=","!=","IN"],
        "constants":["POWER_HEALTH","POWER_MANA","POWER_RAGE","POWER_FOCUS","POWER_ENERGY","POWER_HAPPINESS","POWER_RUNES",
        "POWER_RUNIC_POWER","POWER_SOUL_SHARDS","POWER_POWER_ECLIPSE","POWER_HOLY_POWER","POWER_ALTERNATE_POWER","POWER_DARK_FORCE",
        "POWER_LIGHT_FORCE","POWER_SHADOW_ORBS","POWER_BURNING_EMBERS"],
        "description":"Event (TYPE_ENERGIZE / DRAIN / LEECH) power type"
    },
    "school":{
        "operators":["=","!=","IN"],
        "constants":["PHYSICAL","HOLY","FIRE","NATURE","FROST","SHADOW","ARCANE"],
        "description":"Spell school"
    },
    "sourceType":{
        "operators":["=","!=","IN"],
        "constants":["'Player'","'Creature'","'Pet'","'Vehicle'","'Unknown'"],
        "description":"Source actor type"
    },
    "targetType":{
        "operators":["=","!=","IN"],
        "constants":["'Player'","'Creature'","'Pet'","'Vehicle'","'Unknown'"],
        "description":"Target actor type"
    },
    "sourceReaction":{
        "operators":["=","!=","IN"],
        "constants":["REACTION_FRIENDLY","REACTION_NEUTRAL","REACTION_HOSTILE"],
        "description":"Source actor reaction"
    },
    "targetReaction":{
        "operators":["=","!=","IN"],
        "constants":["REACTION_FRIENDLY","REACTION_NEUTRAL","REACTION_HOSTILE"],
        "description":"Target actor reaction"
    },
    "sourceIcon":{
        "operators":["=","!=","IN"],
        "constants":["ICON_STAR","ICON_CIRCLE","ICON_DIAMOND","ICON_TRIANGLE","ICON_MOON","ICON_SQUARE","ICON_CROSS","ICON_SKULL"],
        "description":"Source actor raid icon"
    },
    "targetIcon":{
        "operators":["=","!=","IN"],
        "constants":["ICON_STAR","ICON_CIRCLE","ICON_DIAMOND","ICON_TRIANGLE","ICON_MOON","ICON_SQUARE","ICON_CROSS","ICON_SKULL"],
        "description":"Target actor raid icon"
    },
    "isCritical":{
        "operators":["=","!="],
        "constants":["TRUE","FALSE"],
        "description":"Event is critical"
    },
    "isCrushing": {
        "operators": ["=", "!="],
        "constants": ["TRUE", "FALSE"],
        "description": "Event is crushing"
    },
    "isGlancing": {
        "operators": ["=", "!="],
        "constants": ["TRUE", "FALSE"],
        "description": "Event is glancing"
    },
    "spell": {
        "operators": ["=", "!=", "IN"],
        "inputType": "string",
        "description": "Spell name"
    },
    "spellID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "Spell ID"
    },
    "extraSpell": {
        "operators": ["=", "!=", "IN"],
        "inputType": "string",
        "description": "Extra spell"
    },
    "extraSpellID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "Extra spell ID"
    },
    "amount": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount"
    },
    "absorbed": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount absorbed"
    },
    "blocked": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount blocked"
    },
    "resisted": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount resisted"
    },
    "missAmount": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount missed"
    },
    "overheal": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount overheal"
    },
    "overkill": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "Event amount overkill"
    },
    "healingDone": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "WoL healing done amount (amount - overheal + absorbed)"
    },
    "damageTaken": {
        "operators": ["=", "!=", "IN", ">", "<", ">=", "<="],
        "inputType": "number",
        "description": "WoL damage taken amount"
    },
    "sourceID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL source actor ID"
    },
    "sourceUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged source actor ID"
    },
    "masterSourceUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged actor ID of source's master"
    },
    "sourceMobID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "Source actor mob (WoW) ID"
    },
    "sourceName": {
        "operators": ["=", "!=", "IN"],
        "inputType": "string",
        "description": "Source actor name"
    },
    "targetID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL target actor ID"
    },
    "targetUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged target actor ID"
    },
    "mastertargetUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged actor ID of target's master"
    },
    "targetMobID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "Target actor mob (WoW) ID"
    },
    "targetName": {
        "operators": ["=", "!=", "IN"],
        "inputType": "string",
        "description": "Target actor name"
    },
    "healID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL source actor ID (Shield support)"
    },
    "healUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged source actor ID (Shield support)"
    },
    "masterhealUID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "WoL merged actor ID of source's master (Shield support)"
    },
    "healSpell": {
        "operators": ["=", "!=", "IN"],
        "inputType": "string",
        "description": "Spell (Shield support)"
    },
    "healSpellID": {
        "operators": ["=", "!=", "IN"],
        "inputType": "number",
        "description": "Spell ID (Shield support)"
    }
};

// Inserts the base UI building blocks.
function insertQueryBuilderUI () {
    // Add the XE Query Builder tab to the interface.
    $('#logRoot').tabs('add', '#tab-XEQueryBuilderUI', 'Query Builder');
    // Build the base UI in the <div> created automatically above.
    $('#tab-XEQueryBuilderUI').append('<div id=\'queryElementContainer"></div>' +
        '<div style="margin-top: 3px">' +
			'<input id="addElement" type="button" value="Add element" /> with ' +
			'<select id="joinTypeSelect">' +
				'<option value="AND">AND</option>' +
				'<option value="OR">OR</option>' +
				//'<option value="(">)</option>' +
				//'<option value=")">)</option>' +
			'</select>' +
			' as a joiner.' +
		'</div>');
    
    $('<input type="submit" value="Build query">').appendTo('#tab-XEQueryBuilderUI').click(function () {
        $('#expression').val(generateQueryString());
        $('#logRoot').tabs('select', '#tab-querybuilder');
    });
    
    // Bind the click() event on the addElement button.
    $("#addElement").click(function () {
        $("#queryElementContainer").append(generateElementHTML($("#joinTypeSelect").val()));
        $("#joinTypeSelect").val("AND");
        fillIdentifierList();
    });
    
    // Trigger the click() event to add the initial element.
    $("#addElement").click();
} // End of insertQueryBuilderUI.

// Fills in the identifier list and all subsequent elements.
function fillIdentifierList() {
	var listHtml = "", identifier, currentElement = $("#queryElementContainer div:last-child");
	
	// Clean up the first element.
	$("#tab-XEQueryBuilderUI div").eq(1).find(".removeElement").hide();
	$("#tab-XEQueryBuilderUI div").eq(1).find(".joinClause").hide();
	
	// Generate the HTML for the identifier options.
	for (identifier in XEqueryBuilderDB) {
		if (XEqueryBuilderDB.hasOwnProperty(identifier)) {
			listHtml += "<option value=\"" + identifier +
                "\" title=\"" + XEqueryBuilderDB[identifier].description +
                "\">" + identifier + "</option>";
		}
	}
	
	// Insert the <option> tags into the identifier list.
	currentElement.find(".identifierSelect").html(listHtml);
	
	// Bind to the change event of the identifier.
	currentElement.find(".identifierSelect").change(function () {
		var listHtml = "", currentIdentifier = XEqueryBuilderDB[currentElement.find(".identifierSelect").val()], operator;
		// Fill in the operators for the currently selected identifier.
		for (operator in currentIdentifier.operators) {
			if (currentIdentifier.operators.hasOwnProperty(operator)) {
				listHtml += "<option value=\"" + currentIdentifier.operators[operator] + "\">" + currentIdentifier.operators[operator] + "</option>";
			}
		}
		currentElement.find(".operatorSelect").html(listHtml);
		
		// Unbind any previous change event listener.
		currentElement.find(".operatorSelect").unbind("change");
		// Bind to the change event of the operator.
		currentElement.find(".operatorSelect").change(function () {
			var currentOperator = currentElement.find(".operatorSelect").val();
			// Set to blank to clear any previous operands.
			currentElement.find(".operandContainer").html("");
			// If IN is selected, show the + button and add in ( ) wrappers.
			if (currentOperator === "IN") {
				currentElement.find(".inClauseLeft").text("(");
				currentElement.find(".inClauseRight").text(")");
				currentElement.find(".qualifierAdd").show();
			} else { // Otherwise make sure they are hidden.
				currentElement.find(".inClauseLeft").html("");
				currentElement.find(".inClauseRight").html("");
				currentElement.find(".qualifierAdd").hide();
			}
			// Fill in the proper HTML for the current identifier.
			currentElement.find(".operandContainer").html(generateOperandHtml(currentElement));
		}); // End of operatorSelect.change().
		
		// Unbind any old bindings.
		currentElement.find(".qualifierAdd").unbind("click");
		// And (re)bind to the + button's click() event.
		currentElement.find(".qualifierAdd").click(function () {
			// When clicked add a ", " in between elements and insert a new operand.
			currentElement.find(".operandContainer").append("<span>, </span>" + generateOperandHtml(currentElement));
		});
		
		// Now that it is bound, trigger the change event to deal with the operand code, and then show the operator select.
		currentElement.find(".operatorSelect").change();
		currentElement.find(".operatorSelect").show();
	}); // End of identifierSelect.change().
	
	// Now that the change event is bound, trigger it and show everything.
	currentElement.find(".identifierSelect").change();
	currentElement.find(".identifierSelect").show();
	
	// Bind the remove button's functionality.
	currentElement.find(".removeElement").click(function () {
		// remove() should unbind any registered event handlers, so no need to worry about that.
		currentElement.remove();
	});
} // End of fillIdentifierList().

// Generates the proper HTML to insert for a given identifier's operand.
function generateOperandHtml(currentElement) {
	var listHtml = "", x, i, currentIdentifier = XEqueryBuilderDB[currentElement.find(".identifierSelect").val()];
	if (currentIdentifier.hasOwnProperty("constants")) { // If this identifier has a list of constants, use that in a select list.
		listHtml = "<select class=\"constantSelect\">";
		for (i = 0, x = currentIdentifier.constants.length; i < x; i++) {
			listHtml += "<option value=\"" + currentIdentifier.constants[i] + "\">" + currentIdentifier.constants[i]+ "</option>";
		}
		listHtml += "</select>";
	} else { // Otherwise use the input type defined for this identifier.
		if (currentIdentifier.inputType === "string") {
			listHtml = "<input class=\"stringInput\" type=\"text\" value=\"\" />";
		} else {
			// HTML5 input type, falls back to text on browsers that don't support it.
			listHtml = "<input class=\"numberInput\" type=\"number\" value=\"0\" />";
		}
	}
	return listHtml;
} // End of generateOperandHtml().

// Generates the base HTML for a query element.
function generateElementHTML(joinClause) {
	var divHtml = "<div class=\"queryElement\">"+
        "<span class=\"joinClause\">" + joinClause + "&nbsp;</span>" +
        "<select class=\"identifierSelect\"><option disabled=\"disabled\"></option></select>" +
        "<select class=\"operatorSelect\" style=\"display: none;\"><option disabled=\"disabled\"></option></select>" +
        "<span class=\"inClauseLeft\"></span>" +
		"<span class=\"operandContainer\"></span>" +
		"<input class=\"qualifierAdd\" type=\"button\" value=\"+\" style=\"display: none;\"/>" +
		"<span class=\"inClauseRight\"></span>" +
		"<input class=\"removeElement\" type=\"button\" value=\"Remove\" />" +
	"</div>";
	return divHtml;
} // End of generateElementHTML().

// Generate the query string based on the current UI elements.
function generateQueryString() {
	var i, x, j, y, queryString = "", elements = $(".queryElement"), value = "", children;
	for (i = 0, x = elements.length; i < x; i++) {
		// If this isn't the first element, grab the join clause.
		if (i > 0) {
			value = $(elements[i]).find(".joinClause").text();
			queryString += "\n" + value.substring(0, value.length - 1) + " ";
		}
		// Insert the current identifier.
		queryString += $(elements[i]).find(".identifierSelect").val();
		// Insert the operator.
		value = $(elements[i]).find(".operatorSelect").val();
		queryString += " " + value;
		// Insert the "(", if present.
		queryString += " " + $(elements[i]).find(".inClauseLeft").text();
		// Handle the differing operand cases.
		if (value === "IN") {
			children = $(elements[i]).find(".operandContainer").children();
			for (j = 0, y = children.length; j < y; j++) {
				if ($(children[j]).is("select")) {
					queryString += $(children[j]).val();
				} else if ($(children[j]).is("input")) {
					if ($(children[j]).attr("type") === "text") {
						queryString += "\"" + $(children[j]).val() + "\"";
					} else {
						queryString += $(children[j]).val();
					}
				} else if ($(children[j]).is("span")) {
					queryString += $(children[j]).text();
				}
			}
		} else {
			if ($(elements[i]).find(".operandContainer").children().is("select")) {
				queryString += "\"" + $(elements[i]).find(".operandContainer").children().val()
                    .replace(/[\\"]/g, "\\$&") + "\""; // Prepend \ to \ and " (escape string).
			} else if ($(elements[i]).find(".operandContainer").children().is("input")) {
				if ($(elements[i]).find(".operandContainer").children().attr("type") === "text") {
					queryString += "\"" + $(elements[i]).find(".operandContainer").children().val() + "\"";
				} else {
					queryString += $(elements[i]).find(".operandContainer").children().val();
				}
			}
		}
		queryString += $(elements[i]).find(".inClauseRight").text();
	}
	return queryString;
} // End of generateQueryString.

$(document).ready(function() {
    insertQueryBuilderUI();
});