function extendSql(name, type)
{
	var list = "";
	var sql = "";
	var sqlField = "";
	if (type == "checkbox" || type == "text")
	{
		sqlField = name.replace("[]", "");
		if( document.getElementsByName(name) != null)
		{	
			list = document.getElementsByName(name);
			sql = "";
			for (var i = 0; i < list.length; i++)
			{	if ((list[i].type == "checkbox" && list[i].checked) || list[i].type == "text")
				{	// Spezialfall: bereich:
					if (sqlField == "bereich" || type == "text")
					{
						if (type == "text")
						{
							list[i].value = list[i].value.replace(" ", "");
						}
					
						if (sql != "")
							sql += " OR " + sqlField + " LIKE '%" + escape(list[i].value) + "%'";
						else
							sql = sqlField + " LIKE '%" + escape(list[i].value) + "%'";
					}
					else
					{
						if (sql != "")
							sql += " OR " + sqlField + " = '" + escape(list[i].value) + "'";
						else
							sql = sqlField + " = '" + escape(list[i].value) + "'";
					}					
				}
			}
		}
	}
	return sql;

}


function update()
{
	var where = "";
	var lastElement;
	var sql = "";
	
	if ($("filter") == null)
		return;
	
	for (var i = 0; i < $("filter").elements.length; i++)
	{
		if ($("filter").elements[i].name != lastElement)
		{
			if ($("filter").elements[i].type == "checkbox" || $("filter").elements[i].type == "text")
			{
				if ($("filter").elements[i].value == "Ort..." || $("filter").elements[i].value == "Ort...")
					continue;
				sql = extendSql($("filter").elements[i].name, $("filter").elements[i].type);
				if (sql != "")
				{
					if (where != "")
						where += " AND (" + sql + ")";
					else
						where = "WHERE (" + sql + ")";
				}
			}

			lastElement = $("filter").elements[i].name;
		}
	
	}
	
	if (where == "")
		where = "WHERE aktiv = 1";
	else
		where += " AND aktiv = 1";
	
	

	var formData = "query=SELECT * FROM `lehrwesen` " + where + " ORDER BY `beginn`, `ende`";
	
	var post = 'post';
	
	new Ajax.Updater("lehrgaenge", "/lehrwesen/getData.php", {method: post, postBody: formData, evalScripts: true});
}


function showDetails(id)
{
	Element.toggle($(id));
}