| " + relatedColumnsXML[i].attr("DisplayName") + " | "; } outString += "
|---|
| " + showColumn(relatedColumnsXML[i], $(this).attr("ows_" + opt.relatedColumns[i]), opt) + " | "; } outString += "
| " + relatedColumnsXML[i].attr("DisplayName") + " | "; outString += "" + showColumn(relatedColumnsXML[i], $(this).attr("ows_" + opt.relatedColumns[i]), opt) + " | "; outString += "
|---|
| " + opt.node.nodeName + " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| " + opt.node.nodeName + " | " + ((opt.node.nodeValue !== null) ? checkLink(opt.node.nodeValue) : " ") + " | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| "; outString += showAttrs(opt.node, opt); outString += " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| " + opt.node.nodeName + " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| " + opt.node.nodeName + " | " + checkLink(opt.node.firstChild.nodeValue) + " | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| " + opt.node.nodeName + " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| "; outString += showAttrs(opt.node, opt); outString += " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| "; for (i = 0;i < opt.node.childNodes.length; i++) { outString += $().SPServices.SPDebugXMLHttpResult({ node: opt.node.childNodes.item(i), indent: opt.indent++ }); } outString += " | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
"; var firstMsg = msg.replace(/\{0\}/g, opt.initMsgCSSClass).replace(/\{1\}/g, opt.initMsg); // We need the DisplayName var columnDisplayName = $().SPServices.SPGetDisplayFromStatic({ listName: thisList, columnStaticName: opt.columnStaticName }); var columnObj = $("input[Title='" + columnDisplayName + "']"); $(columnObj).parent().append(firstMsg); $(columnObj).blur(function () { var columnValueIDs = []; // Get the columnDisplayName's value var columnValue = $(this).attr("value"); // Call the Lists Web Service (GetListItems) to see if the value already exists $().SPServices({ operation: "GetListItems", async: false, listName: thisList, // Make sure we get all the items, ignoring any filters on the default view. CAMLQuery: "
| " + " | List | " + "Page Class | " + "Page Type | " + "Page | " + (opt.showSrc ? "Script References | " : "") + "
|---|
| " + pageScriptSrc.type[i] + " | "; out += "" + fileName(pageScriptSrc.src[i]) + " |
which isn't needed and messes up the formatting columnObj.closest("span").find("br").remove(); columnObj.wrap("
");
// Create a div to contain the matching values and add it to the DOM
var containerId = genContainerId("SPAutocomplete", opt.columnName);
columnObj.after("";
if(opt.CAMLQuery.length > 0) {
camlQuery += "";
}
camlQuery += "<" + opt.filterType + ">" + columnValue + " ";
if(opt.CAMLQuery.length > 0) {
camlQuery += opt.CAMLQuery + " ";
}
camlQuery += " " + matchArray[i] + " ";
}
// Add all the list elements to the containerId container
$("#" + containerId).html(out);
// Set up hehavior for the available values in the list element
$("#" + containerId + " li").click(function () {
$("#" + containerId).fadeOut(opt.slideUpSpeed);
$("#" + columnObjId).val($(this).text());
}).mouseover(function () {
var mouseoverCss = {
"cursor": "hand",
"color": "#ffffff",
"background": "#3399ff"
};
$(this).css(mouseoverCss);
}).mouseout(function () {
var mouseoutCss = {
"cursor": "inherit",
"color": columnObjColor,
"background": "transparent"
};
$(this).css(mouseoutCss);
});
// If we've got some values to show, then show 'em!
if(matchArray.length > 0) {
$("#" + containerId).slideDown(opt.slideDownSpeed);
}
// Remove the processing indicator
columnObj.css("background-image", "");
});
}; // End $.fn.SPServices.SPAutocomplete
// Get the Query String parameters and their values and return in an array
$.fn.SPServices.SPGetQueryString = function () {
var i;
var queryStringVals = {};
var qs = location.search.substring(1, location.search.length);
var args = qs.split("&");
for (i=0; i < args.length; i++) {
var rxQS = /^([^=]+)=(.*)/i,
matches = rxQS.exec(args[i]);
if (rxQS.test(location.href)) {
if (matches !== null && matches.length > 2) {
queryStringVals[matches[1]] = unescape(matches[2]).replace('+', ' ');
}
}
}
return queryStringVals;
}; // End $.fn.SPServices.SPGetQueryString
// Get the current list's GUID (ID) from the current URL. Use of this function only makes sense if we're in a list's context,
// and we assume that we are calling it from an aspx page which is a form or view for the list.
$.fn.SPServices.SPListNameFromUrl = function () {
// Do we already know the current list?
if(thisList.length > 0) {
return thisList;
}
// Parse out the list's root URL from the current location
var thisPage = location.href;
var thisPageBaseName = thisPage.substring(0, thisPage.indexOf(".aspx"));
var listPath = unescape(thisPageBaseName.substring(0, thisPageBaseName.lastIndexOf(SLASH) + 1)).toUpperCase();
// Call GetListCollection and loop through the results to find a match with the list's URL to get the list's GUID (ID)
$().SPServices({
operation: "GetListCollection",
async: false,
completefunc: function(xData, Status) {
$(xData.responseXML).find("List").each(function() {
var defaultViewUrl = $(this).attr("DefaultViewUrl");
var listCollList = defaultViewUrl.substring(0, defaultViewUrl.lastIndexOf(SLASH) + 1).toUpperCase();
if(listPath.indexOf(listCollList) > 0) {
thisList = $(this).attr("ID");
return false;
}
});
}
});
// Return the GUID (ID)
return thisList;
}; // End $.fn.SPServices.SPListNameFromUrl
// SPUpdateMultipleListItems allows you to update multiple items in a list based upon some common characteristic or metadata criteria.
$.fn.SPServices.SPUpdateMultipleListItems = function (options) {
var opt = $.extend({}, {
webURL: "", // [Optional] URL of the target Web. If not specified, the current Web is used.
listName: "", // The list to operate on.
CAMLQuery: "", // A CAML fragment specifying which items in the list will be selected and updated
batchCmd: "Update", // The operation to perform. By default, Update.
valuepairs: [], // Valuepairs for the update in the form [[fieldname1, fieldvalue1], [fieldname2, fieldvalue2]...]
completefunc: null, // Function to call on completion of rendering the change.
debug: false // If true, show error messages;if false, run silent
}, options);
var i;
var itemsToUpdate = [];
var documentsToUpdate = [];
// Call GetListItems to find all of the items matching the CAMLQuery
$().SPServices({
operation: "GetListItems",
async: false,
webURL: opt.webURL,
listName: opt.listName,
CAMLQuery: opt.CAMLQuery,
CAMLQueryOptions: "";
for(i=0; i < itemsToUpdate.length; i++) {
batch += "";
for (fieldNum=0; fieldNum < opt.valuepairs.length; fieldNum++) {
batch += "" + opt.valuepairs[fieldNum][1] + " ";
}
batch += "" + itemsToUpdate[i] + " ";
if(documentsToUpdate[i].length > 0) {
batch += "" + documentsToUpdate[i] + " ";
}
batch += " ";
}
batch += " ";
// Call UpdateListItems to update all of the items matching the CAMLQuery
$().SPServices({
operation: "UpdateListItems",
async: false,
webURL: opt.webURL,
listName: opt.listName,
updates: batch,
completefunc: function(xData, Status) {
// If present, call completefunc when all else is done
if(opt.completefunc !== null) {
opt.completefunc();
}
}
});
}; // End $.fn.SPServices.SPUpdateMultipleListItems
////// PRIVATE FUNCTIONS ////////
// Display a column (field) formatted correctly based on its definition in the list.
// NOTE: Currently not dealing with locale differences.
// columnXML The XML node for the column from a GetList operation
// columnValue The text representation of the column's value
// opt The current set of options
function showColumn(columnXML, columnValue, opt) {
if(typeof columnValue === 'undefined') {
return "";
}
var i;
var outString;
var dispUrl;
var numDecimals;
switch(columnXML.attr("Type")) {
case "Text":
outString = columnValue;
break;
case "URL":
switch(columnXML.attr("Format")) {
// URL as hyperlink
case "Hyperlink":
outString = "" +
columnValue.substring(columnValue.search(",") + 1) + "";
break;
// URL as image
case "Image":
outString = "![" + columnValue.substring(columnValue.search(",") + 1) +
"](" + columnValue.substring(0, columnValue.search(",")) + ")
";
break;
// Just in case
default:
outString = columnValue;
break;
}
break;
case "User":
outString = "" +
columnValue.substring(columnValue.search(";#") + 2) + "";
break;
case "Calculated":
var calcColumn = columnValue.split(";#");
outString = calcColumn[1];
break;
case "Number":
numDecimals = columnXML.attr("Decimals");
outString = numDecimals === undefined ?
parseFloat(columnValue).toString() :
parseFloat(columnValue).toFixed(numDecimals).toString();
break;
case "Currency":
numDecimals = columnXML.attr("Decimals");
outString = numDecimals === undefined ?
parseFloat(columnValue).toFixed(2).toString() :
parseFloat(columnValue).toFixed(numDecimals).toString();
break;
case "Lookup":
// Get the display form URL for the lookup source list
dispUrl = getListFormUrl(columnXML.attr("List"), "DisplayForm");
outString = "" +
columnValue.substring(columnValue.search(";#") + 2) + "";
break;
case "LookupMulti":
// Get the display form URL for the lookup source list
dispUrl = getListFormUrl(columnXML.attr("List"), "DisplayForm");
// Show all the values as links to the items, separated by commas
outString = "";
if(columnValue.length > 0) {
var lookupMultiValues = columnValue.split(";#");
for (i=0; i < lookupMultiValues.length / 2; i++) {
outString += "" +
lookupMultiValues[(i * 2) + 1] + "";
if(i < (lookupMultiValues.length / 2) - 1) {
outString += ", ";
}
}
}
break;
case "Counter":
outString = columnValue;
break;
case "DateTime":
outString = columnValue;
break;
default:
outString = columnValue;
break;
}
return outString;
} // End of function showColumn
// Show a single attribute of a node, enclosed in a table
// node The XML node
// opt The current set of options
function showAttrs(node, opt) {
var i;
var out = "";
for (i=0; i < node.attributes.length; i++) {
out += "
";
return out;
} // End of function showAttrs
// Find a dropdown (or multi-select) in the DOM. Returns the dropdown onject and its type:
// S = Simple (select);C = Compound (input + select hybrid);M = Multi-select (select hybrid)
function dropdownCtl(colName) {
// Simple
if((this.Obj = $("select[Title='" + colName + "']")).html() !== null) {
this.Type = "S";
// Compound
} else if((this.Obj = $("input[Title='" + colName + "']")).html() !== null) {
this.Type = "C";
// Multi-select: This will find the multi-select column control in English and most other languages sites where the Title looks like 'Column Name possible values'
} else if((this.Obj = $("select[ID$='SelectCandidate'][Title^='" + colName + " ']")).html() !== null) {
this.Type = "M";
// Multi-select: This will find the multi-select column control on a Russian site (and perhaps others) where the Title looks like 'Выбранных значений: Column Name'
} else if((this.Obj = $("select[ID$='SelectCandidate'][Title$=': " + colName + "']")).html() !== null) {
this.Type = "M";
// Multi-select: This will find the multi-select column control on a German site (and perhaps others) where the Title looks like 'Mögliche Werte für "Tops".'
} else if((this.Obj = $("select[ID$='SelectCandidate'][Title$='\"" + colName + "\".']")).html() !== null) {
this.Type = "M";
} else {
this.Type = null;
}
} // End of function dropdownCtl
// Build an error message based on passed parameters
function errBox(func, param, msg) {
var errMsg = "Error in function
" + func + "
" + "Parameter
" + param + "
" + "Message
" + msg + "
" + "Click to continue
";
modalBox(errMsg);
} // End of function errBox
// Call this function to pop up a branded modal msgBox
function modalBox(msg) {
var boxCSS = "position:absolute;width:300px;height:150px;padding:10px;background-color:#000000;color:#ffffff;z-index:30;font-family:'Arial';font-size:12px;display:none;";
$("#aspnetForm").parent().append("");
// Set the width to match the width of the input control
$("#" + containerId).css("width", columnObj.width());
// Handle keypresses
$(columnObj).keyup(function () {
// Get the column's value
var columnValue = $(this).val();
// Hide the container while we're working on it
$("#" + containerId).hide();
// Have enough characters been typed yet?
if(columnValue.length < opt.numChars) {
return false;
}
// Show the the processingIndicator as a background image in the input element
columnObj.css({
"background-image": "url(" + opt.processingIndicator + ")",
"background-position": "right",
"background-repeat": "no-repeat"
});
// Array to hold the matched values
var matchArray = [];
// Build the appropriate CAMLQuery
var camlQuery = "
| " + i + " | " + node.attributes.item(i).nodeName + " | " + checkLink(node.attributes.item(i).nodeValue) + " |
" + func + "
" + "Parameter
" + param + "
" + "Message
" + msg + "
" + "Click to continue
" + msg);
var height = $("#SPServices_msgBox").height();
var width = $("#SPServices_msgBox").width();
var leftVal = ($(window).width() / 2) - (width / 2) + "px";
var topVal = ($(window).height() / 2) - (height / 2) - 100 + "px";
$("#SPServices_msgBox").css({border:'5px #C02000 solid', left:leftVal, top:topVal}).show().fadeTo("slow", 0.75).click(function () {
$(this).fadeOut("3000", function () {
$(this).remove();
});
});
} // End of function modalBox
// Generate a unique id for a containing div using the function name and the column display name
function genContainerId(funcname, columnName) {
return funcname + "_" + $().SPServices.SPGetStaticFromDisplay({
listName: $().SPServices.SPListNameFromUrl(),
columnDisplayName: columnName
});
} // End of function genContainerId
// Get the URL for a specified form for a list
function getListFormUrl(l, f) {
var u;
$().SPServices({
operation: "GetFormCollection",
async: false,
listName: l,
completefunc: function (xData, Status) {
$(xData.responseXML).find("Form").each(function() {
if($(this).attr("Type") === f) {
u = $(this).attr("Url");
// Stop looking;we're done
return false;
}
});
}
});
return u;
} // End of function getListFormUrl
// Add the option values to the SOAPEnvelope.payload for the operation
// opt = options for the call
// paramArray = an array of option names to add to the payload
// "paramName" if the parameter name and the option name match
// ["paramName", "optionName"] if the parameter name and the option name are different (this handles early "wrappings" with inconsistent naming)
function addToPayload(opt, paramArray) {
var i;
for (i=0; i < paramArray.length; i++) {
// the parameter name and the option name match
if(typeof paramArray[i] === "string") {
SOAPEnvelope.payload += wrapNode(paramArray[i], opt[paramArray[i]]);
// the parameter name and the option name are different
} else if(paramArray[i].length === 2) {
SOAPEnvelope.payload += wrapNode(paramArray[i][0], opt[paramArray[i][1]]);
// something isn't right, so report it
} else {
errBox(opt.operation, "paramArray[" + i + "]: " + paramArray[i], "Invalid paramArray element passed to addToPayload()");
}
}
} // End of function addToPayload
// Finds the td which contains a form field in default forms using the comment which contains:
//
// as the "anchor" to find it. Necessary because SharePoint doesn't give all field types ids or specific classes.
function findFormField(columnName) {
var thisFormBody;
// There's no easy way to find one of these columns; we'll look for the comment with the columnName
var searchText = RegExp("FieldName=\"" + columnName.replace(/[-[\]{}()*+?.,\\^$|#\s]/g, "\\$&") + "\"", "gi");
// Loop through all of the ms-formbody table cells
$("td.ms-formbody, td.ms-formbodysurvey").each(function() {
// Check for the right comment
if(searchText.test($(this).html())) {
thisFormBody = $(this);
// Found it, so we're done
return false;
}
});
return thisFormBody;
} // End of function findFormField
// Wrap an XML node (n) around a value (v)
function wrapNode(n, v) {
return "<" + n + ">" + v + "";
}
// Generate a random number for sorting arrays randomly
function randOrd() {
return (Math.round(Math.random())-0.5);
}
// If a string is a URL, format it as a link, else return the string as-is
function checkLink(s) {
return ((s.indexOf("http") === 0) || (s.indexOf(SLASH) === 0)) ? "" + s + "" : s;
}
// Get the filename from the full URL
function fileName(s) {
return s.substring(s.lastIndexOf(SLASH)+1,s.length);
}
// Escape string characters
function escapeHTML(s) {
return s.replace(/&/g,'&').replace(/"/g,'"').replace(//g,'>');
}
// Escape column values
function escapeColumnValue(s) {
return s.replace(/&(?![a-zA-Z]{1,8};)/g, "&");
//(/&/g,'&');
}
// Escape Url
function escapeUrl(u) {
return u.replace(/&/g,'%26');
}
})(jQuery);