GetListItem and UpdateListItem using SPServices in MOSS 2007
$(document).ready(function() {
var itemToUpdate = GetListItem();
UpdateListItem(itemToUpdate);
});
function GetListItem(){
var today = new Date();
var dayOfWeek = today.getDay();
var itemID = 0;
var out = "";
var titleField = "<FieldRef Name='Title' />";
var descriptionField = "<FieldRef Name='Description' />";
var viewFields = "<ViewFields>" + titleField + descriptionField + "</ViewFields>";
var myQuery = "<Query>" +
"<OrderBy>" +
"<FieldRef Name='ItemOrder' Ascending='True'/>" +
"</OrderBy>" +
"</Query>";
$().SPServices({
operation: "GetListItems",
async: false,
listName: "MyList",
CAMLQuery: myQuery,
CAMLViewFields: viewFields,
completefunc: function (xData, Status) {
var activeItemAvailable = false;
$(xData.responseXML).SPFilterNode("z:row").each(function() {
strTitle = $(this).attr("ows_Title");
strDescription = $(this).attr("ows_Description");
itemID = $(this).attr("ows_ID");
});
$("#divID").html(out);
}
});
return itemID;
}
function UpdateListItem(itemToBeUpdated)
{
var today = new Date();
var lastTuesdayDate = today.GetLastTuesdayOfWeek().toISOString();
$().SPServices({
operation:"UpdateListItems",
async: false,
listName: "MyList",
ID: itemToBeUpdated,
valuepairs:[["IsActive", true], ["DateMadeActive", lastTuesdayDate]],
completefunc:function(xData, Status)
{
}
});
}
Date.prototype.GetLastTuesdayOfWeek = function() {
return (new Date(this.setDate(this.getDate() - this.getDay() + 2)));
}
$(document).ready(function() {
var itemToUpdate = GetListItem();
UpdateListItem(itemToUpdate);
});
function GetListItem(){
var today = new Date();
var dayOfWeek = today.getDay();
var itemID = 0;
var out = "";
var titleField = "<FieldRef Name='Title' />";
var descriptionField = "<FieldRef Name='Description' />";
var viewFields = "<ViewFields>" + titleField + descriptionField + "</ViewFields>";
var myQuery = "<Query>" +
"<OrderBy>" +
"<FieldRef Name='ItemOrder' Ascending='True'/>" +
"</OrderBy>" +
"</Query>";
$().SPServices({
operation: "GetListItems",
async: false,
listName: "MyList",
CAMLQuery: myQuery,
CAMLViewFields: viewFields,
completefunc: function (xData, Status) {
var activeItemAvailable = false;
$(xData.responseXML).SPFilterNode("z:row").each(function() {
strTitle = $(this).attr("ows_Title");
strDescription = $(this).attr("ows_Description");
itemID = $(this).attr("ows_ID");
});
$("#divID").html(out);
}
});
return itemID;
}
function UpdateListItem(itemToBeUpdated)
{
var today = new Date();
var lastTuesdayDate = today.GetLastTuesdayOfWeek().toISOString();
$().SPServices({
operation:"UpdateListItems",
async: false,
listName: "MyList",
ID: itemToBeUpdated,
valuepairs:[["IsActive", true], ["DateMadeActive", lastTuesdayDate]],
completefunc:function(xData, Status)
{
}
});
}
Date.prototype.GetLastTuesdayOfWeek = function() {
return (new Date(this.setDate(this.getDate() - this.getDay() + 2)));
}
I simply couldn’t depart your site before suggesting that I really enjoyed the usual information an individual supply in your visitors? Is going to be again steadily to check out new posts.
ReplyDeleteCRO Agency in Chennai