Skip to main content

Code To Save the Items in SharePoint Using SP Service : All type of columns

//***********************************************Code Start*****************************************************

$(document).ready(function()
{

//**********Enable/Disable Approval Required By PE field, based on Type of Request selection
$("input:radio[name=ctl00$m$g_0114c063_901b_4b52_ba51_625c6af34065$ff41$ctl00$RadioButtons]").change(function() {
var value = $(this).val();
if (value =="ctl00" || value =="ctl01" )
{
$('input:checkbox[name=ctl00$m$g_0114c063_901b_4b52_ba51_625c6af34065$ff181$ctl00$ctl00$BooleanField]').attr('checked', true);
$("input[title='Approval Required By PE']").removeAttr("disabled");
}
else
{
$('input:checkbox[name=ctl00$m$g_0114c063_901b_4b52_ba51_625c6af34065$ff181$ctl00$ctl00$BooleanField]').attr('checked', false);
$("input[title='Approval Required By PE']").attr("disabled", "disabled");
}
});

$().SPServices.SPFilterDropdown({
  relationshipList: "Program Profile",
  relationshipListColumn: "Title",
  columnName: "Program Title",
  CAMLQuery: "<Eq><FieldRef Name='Genre' /><Value Type='Choice'>Original Series</Value></Eq>",
  completefunc: null,
  debug: false
});

//Clear all auto populated fields
$('select[title="Program Title"]').change(function(e) {
ClearAllPeopleFields();
$("input[Title='Focus ID']").val('');
var selProgramID = $('select[title="Program Title"] :selected').val()
//Filter Episode Drop Down
$().SPServices.SPCascadeDropdowns({
relationshipList: "Episode Profile",
relationshipListParentColumn: "ProgramTitle",
relationshipListChildColumn: "LinkTitle",
parentColumn: "Program Title",
childColumn: "Episode",
debug: true
});
});


//Episode selction change
$('select[title="Episode"]').change(function(e) {
var epid = $('select[title="Episode"] :selected').val();
var ProgId= $('select[title="Program Title"] :selected').val();

ClearAllPeopleFields();

$().SPServices({
       operation: "GetListItems",
       listName: "Episode Profile",
       CAMLViewFields: "<ViewFields>"+
        "<FieldRef Name='AirDate' /><FieldRef Name='Focus_x0020_ID' /><FieldRef Name='MR_x0020_Contact_x0020__x0023_1' /><FieldRef Name='MR_x0020_Contact_x0020__x0023_2' />"+
        "<FieldRef Name='PhotoEditor' /><FieldRef Name='AccountManager' /><FieldRef Name='Ingestor' /><FieldRef Name='Retoucher' /><FieldRef Name='Metadata' />"+
        "</ViewFields>",      
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+ epid +"</Value></Eq></Where></Query>",
       
       completefunc: function (xData, Status) {
        //alert(Status);
   $(xData.responseXML).SPFilterNode("z:row").each(function() {
//Set Focus ID

//var airdate = $(this).attr("ows_AirDate");
var EAirDate = $(this).attr("ows_AirDate");
$("input[Title='ADate']").val(EAirDate);
//alert(EAirDate);
   var focus = $(this).attr("ows_Focus_x0020_ID");
        if(focus==null)
focus='';
else
focus=Math.round(focus);
   $("input[Title='Focus ID']").val(focus);
 
   var AccountManager= $(this).attr("ows_AccountManager");
if(AccountManager!= null)
{
setpeoplefield("Account Manager",AccountManager);
}
   var retoucher = $(this).attr("ows_Retoucher");
            if(retoucher != null)
            {              
               setpeoplefield("Retoucher",retoucher);
               }
               var PhotoEditor= $(this).attr("ows_PhotoEditor");
               if(PhotoEditor != null)
               {
              setpeoplefield("Photo Editor",PhotoEditor);
}
var Ingestor = $(this).attr("ows_Ingestor");
               if(Ingestor != null)
               {
               setpeoplefield("Ingestor",Ingestor);
               }
               var Metadata= $(this).attr("ows_Metadata");
if(Metadata!= null)
{
setpeoplefield("Metadata",Metadata);
}
               var mrcontact1 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_1");
               if(mrcontact1 != null)
               {
setpeoplefield("MR Contact #1",mrcontact1);
               }
             
               var mrcontact2 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_2");
               if(mrcontact2 != null)
               {
setpeoplefield("MR Contact #2",mrcontact2);
               }
});
}
});

$().SPServices({
       operation: "GetListItems",
       listName: "Episode Profile",
       CAMLViewFields: "<ViewFields>"+        
"<FieldRef Name='MR_x0020_Contact_x0020__x0023_3' /><FieldRef Name='MR_x0020_Contact_x0020__x0023_4' />"+
"<FieldRef Name='Legal_x0020_Contact_x0020__x0023' /><FieldRef Name='Legal_x0020_Contact_x0020__x00231' /><FieldRef Name='Legal_x0020_Contact_x0020__x00230' /><FieldRef Name='Legal_x0020_Contact_x0020__x00232' />"+
        "</ViewFields>",      
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+ epid +"</Value></Eq></Where></Query>",
       
       completefunc: function (xData, Status) {
   $(xData.responseXML).SPFilterNode("z:row").each(function() {
   
    //var airdate = $(this).attr("ows_AirDate");
               var mrcontact3 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_3");
               if(mrcontact3 != null)
               {
  setpeoplefield("MR Contact #3",mrcontact3);
               }
               
               var mrcontact4 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_4");
               if(mrcontact4 != null)
               {
                setpeoplefield("MR Contact #4",mrcontact4);
}

               var legalcontact1= $(this).attr("ows_Legal_x0020_Contact_x0020__x0023");
               if(legalcontact1 != null)
               {
setpeoplefield("Legal Contact #1",legalcontact1);
}
             
               var legalcontact2= $(this).attr("ows_Legal_x0020_Contact_x0020__x00230");
               if(legalcontact2 != null)
               {
                setpeoplefield("Legal Contact #2",legalcontact2);
}

var legalcontact3= $(this).attr("ows_Legal_x0020_Contact_x0020__x00231");
               if(legalcontact3 != null)
               {
setpeoplefield("Legal Contact #3",legalcontact3);
}

var legalcontact4= $(this).attr("ows_Legal_x0020_Contact_x0020__x00232");
if(legalcontact4 != null)
{
setpeoplefield("Legal Contact #4",legalcontact4);
}
});
}
});


// getting contract from program profile list
       $().SPServices({
        operation: "GetListItems",
listName: "Program Profile",
CAMLViewFields: "<ViewFields><FieldRef Name='ID' /><FieldRef Name='Contract1' /><FieldRef Name='Contract2' /><FieldRef Name='Contract3' /><FieldRef Name='Contract4' /></ViewFields>",        
CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+ProgId+"</Value></Eq></Where></Query>",

completefunc: function (xData, Status) {          
            $(xData.responseXML).SPFilterNode("z:row").each(function()
            {
            var ProID= $(this).attr("ows_ID");
           
            var contract= $(this).attr("ows_Contract1");
               if(contract!= null)
$("input[Title='Contract1']").val(contract);
           
            var contract2= $(this).attr("ows_Contract2");
            if(contract2!= null)              
            $("input[Title='Contract2']").val(contract2);
           
            var contract3= $(this).attr("ows_Contract3");
            if(contract3!= null)
            $("input[Title='Contract3']").val(contract3);
           
            var contract4= $(this).attr("ows_Contract4");
            if(contract4!= null)
            $("input[Title='Contract4']").val(contract4);
            });
}
});

// getting phtographer from phtographer list

       $().SPServices({
        operation: "GetListItems",
listName: "Episode Profile",        
CAMLViewFields: "<ViewFields><FieldRef Name='Photographer1' /><FieldRef Name='Photographer2' /><FieldRef Name='Photographer3' /><FieldRef Name='Photographer4' /></ViewFields>",        
CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+epid+"</Value></Eq></Where></Query>",

completefunc: function (xData, Status) {
         
            $(xData.responseXML).SPFilterNode("z:row").each(function() {
           
                     
            var Photographer1= $(this).attr("ows_Photographer1");
           
       if(Photographer1!= null)
       {
       
        Photographer1=Photographer1.split(';#');
           Photographer1=Photographer1[0];                          
           $('select[title="Photographer1"]').val(Photographer1);
           setPhotographerComments(Photographer1,'Label1');
       }
       var Photographer2= $(this).attr("ows_Photographer2");
       if(Photographer2!= null)
       {
       
        Photographer2=Photographer2.split(';#');
           Photographer2=Photographer2[0];                          
           $('select[title="Photographer2"]').val(Photographer2);
           setPhotographerComments(Photographer2,'Label2');
       }      

       var Photographer3= $(this).attr("ows_Photographer3");
       if(Photographer3!= null)
       {
       
        Photographer3=Photographer3.split(';#');
           Photographer3=Photographer3[0];                          
           $('select[title="Photographer3"]').val(Photographer3);
           setPhotographerComments(Photographer3,'Label3');
       }

       var Photographer4= $(this).attr("ows_Photographer4");
       if(Photographer4!= null)
       {

        Photographer4=Photographer4.split(';#');
           Photographer4=Photographer4[0];                          
           $('select[title="Photographer4"]').val(Photographer4);
           setPhotographerComments(Photographer4,'Label4');
       }
 
            });
}
});
});
});


function ClearAllPeopleFields()
{
var blankValue= " ";
clearpeoplefield("Retoucher",blankValue);
    clearpeoplefield("Ingestor",blankValue);
    clearpeoplefield("MR Contact #1",blankValue);
    clearpeoplefield("MR Contact #2",blankValue);
    clearpeoplefield("MR Contact #3",blankValue);
    clearpeoplefield("MR Contact #4",blankValue);
    clearpeoplefield("Legal Contact #1",blankValue);
    clearpeoplefield("Legal Contact #2",blankValue);
    clearpeoplefield("Legal Contact #3",blankValue);
    clearpeoplefield("Legal Contact #4",blankValue);            
clearpeoplefield("Account Manager",blankValue);            
clearpeoplefield("Metadata",blankValue);            
clearpeoplefield("Photo Editor",blankValue);
}

function clearpeoplefield(fieldName,fieldValue)
{
$().SPFindPeoplePicker({
peoplePickerDisplayName: fieldName,
valueToSet: fieldValue,
checkNames: false
});
}

function setpeoplefield(fieldName,fieldValue)
{
fieldValue=fieldValue.split("#");
fieldValue=fieldValue[1];

$().SPFindPeoplePicker({
peoplePickerDisplayName: fieldName,
valueToSet: fieldValue,
checkNames: true
});
}

function clearAllFields()
{
 
$("input[Title='Contract1']").val('');
$("input[Title='Contract2']").val('');
$("input[Title='Contract3']").val('');
$("input[Title='Contract4']").val('');

//Photographer fields
$('select[title="Photographer1"] :selected').val(0);
$('select[title="Photographer1"] :selected').val(0);
    $('select[title="Photographer1"] :selected').val(0);
    $('select[title="Photographer1"] :selected').val(0);
   
}

function setPhotographerComments(PhotogrpaherID,ControlID)
{
document.getElementById(ControlID).innerHTML = "";
$().SPServices({
operation: "GetListItems",
   listName: "Photographers",
   CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",          
   CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+PhotogrpaherID+"</Value></Eq></Where></Query>",
   completefunc: function (xData, Status) {
    $(xData.responseXML).SPFilterNode("z:row").each(function() {
        var comments= $(this).attr("ows_Comments");
           if(comments!= null){
            document.getElementById(ControlID).innerHTML = comments;
           }                
});
}
});
}
function validate(strdate)
{
var alertMessage="";
if((($("input[title='Request Title']").val())=="") || (($("input[title='Due Date']").val())=="") || (($(".retoucher div[title='People Picker']").siblings("textarea").val())=="") || ($(".retoucher div[title='People Picker']").length == 0))
{
if(($("input[title='Request Title']").val())=="")
{
alertMessage=alertMessage+"Request Title is required";
}
if(($("input[title='Due Date']").val())=="")
{
alertMessage=alertMessage+"\nDue Date is required"
}
if(($(".retoucher div[title='People Picker']").siblings("textarea").val())=="")
{
alertMessage=alertMessage+"\nRetoucher is required"
}
if($(".typeofrequest input:radio:checked").length == 0)
{
alertMessage=alertMessage+"\nType of Request is required"
}

if(isNaN($("input[title='Focus ID']").val()))
{
alert("Focus ID can only accpet numeric values");
}
alert(alertMessage);
}
else
{
itemsChecked(strdate);
}
}

// function for get episode

function getprgEpiItemID(title,ProID,ProT,Epid,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox,airdate)
{

var vals = new Object();
    var qs = location.search.substring(1, location.search.length);
    var args = qs.split("&");
    for (var i=0; i < args.length; i++)
    {
        var nameVal = args[i].split("=");
        var temp = unescape(nameVal[1]).split('+');
        nameVal[1] = temp.join(' ');
        vals[nameVal[0]] = nameVal[1];
    }
    var itemID;
    var parentID,episodeID;  

if(vals["ItemID"]!=null)
{

itemID= vals["ItemID"];
$().SPServices({
        operation: "GetListItems",
        listName: "Image Request Detail",
        CAMLViewFields: "<ViewFields><FieldRef Name='ProgramId' /><FieldRef Name='EpisodeID' /></ViewFields>",
        CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Integer'>" + itemID + "</Value></Eq></Where></Query>",
        completefunc: function (xData, Status) {
        $(xData.responseXML).SPFilterNode("z:row").each(function() {

            parentID = $(this).attr("ows_ProgramId");
                     
            episodeID = $(this).attr("ows_EpisodeID");
           
           
            //updatelist(title,ProID,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,parentID,episodeID,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox);
            });
           }
         
          });

}
else if(vals["ProgID"]!=null && vals["EpiID"]!=null)
{
parentID = vals["ProgID"];
    episodeID = vals["EpiID"];
    //alert(parentID +episodeID );
    //updatelist(title,ProID,ProT,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,parentID,episodeID,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox);
}
else
{
// code for save the date without query string

   
updatelistitem(title,ProID,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,ProT,Epid,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox,airdate);

}

}


// Function for saving the data in  list

function itemsChecked(strdate)
    {

    var idValues = new Array();

//alert("on items checked");

$(".typeofrequest input:radio:checked").each(function()
{
var typeofrequest= $(this).siblings("label").html();
//alert(typeofrequest);
var title=$("input[title='Request Title']").val();

var ProT=$("select[title='Program Title']").val();

var ProID=$("select[title='Program Title']").val();

var Epid=$("select[title='Episode']").val();


var dueDate=$("input[title='Due Date']").val();
var airdate=$("input[title='ADate']").val();

dueDate=ConvertDateToISO(dueDate);

//var date = new Date(dueDate);
//var instructn=$("input[title='InstructionForRetoucher']").val();
var instructn=$("nobr:contains('PE Instructions')").closest('tr').find("div[role='textbox']").html();

//var instructn= $("div[role='textbox']").html();
var tmp = document.createElement("DIV");
                tmp.innerHTML = instructn;
                    instructnnew = tmp.textContent||tmp.innerText;


var Legalrestrictions=$("nobr:contains('Legal Restrictions')").closest('tr').find("div[role='textbox']").html();

//var instructn= $("div[role='textbox']").html();
var tmp1 = document.createElement("DIV");
                tmp1.innerHTML = Legalrestrictions;
                    legalinstructnnew = tmp1.textContent||tmp1.innerText;
                   
                   
        var stcomments=$("nobr:contains('Comments')").closest('tr').find("div[role='textbox']").html();


var tmp5 = document.createElement("DIV");
                tmp5 .innerHTML = stcomments;
                    comments = tmp5.textContent||tmp5.innerText;          
//alert(comments);

var noofimages=$("input[title='Number Of Images']").val();
//alert(noofimages);
var status=$("select[title='Status']").val();

var accountmanager = getPickerInputElement("ff19");
//alert("accountmanager="+accountmanager);
var retoucher = getPickerInputElement("ff8");
//alert("retoucher ="+retoucher);

var ingestor = getPickerInputElement("ff28");
//alert("ingestor ="+ingestor);
var metadata = getPickerInputElement("ff29");
//alert("metadata ="+metadata);
var mrcontact1 = getPickerInputElement("ff20");
//alert("mrcontact1 ="+mrcontact1);
var mrcontact2= getPickerInputElement("ff21");
//alert("mrcontact2="+mrcontact2);
var mrcontact3= getPickerInputElement("ff22");
//alert("mrcontact3="+mrcontact3);
var mrcontact4= getPickerInputElement("ff23");
//alert("mrcontact4="+mrcontact4);
var legalcontact1 = getPickerInputElement("ff24");
//alert("legalcontact1 ="+legalcontact1);
var legalcontact2 = getPickerInputElement("ff25");
//alert("legalcontact2 ="+legalcontact2);

var legalcontact3 = getPickerInputElement("ff26");
//alert("legalcontact3 ="+legalcontact3);

var legalcontact4 = getPickerInputElement("ff27");

var photoeditor = getPickerInputElement("ff37");

var photographer = $("select[Title='Photographer']").val();
//testing line
var approvedcheckbox;

var RetouchingRequiredcheckbox;
if ($('#ctl00_m_g_0114c063_901b_4b52_ba51_625c6af34065_ff181_ctl00_ctl00_BooleanField').is(':checked'))
{
  approvedcheckbox = 1;
  //alert("true");
}

else
{
  approvedcheckbox = 0;
 
  //alert("false");
}

if ($('#ctl00_m_g_0114c063_901b_4b52_ba51_625c6af34065_ff171_ctl00_ctl00_BooleanField').is(':checked'))
{
  RetouchingRequiredcheckbox = 1;
  //alert("true");
}
else
{
  RetouchingRequiredcheckbox = 0;
 
  //alert("false");
}

//  var dec for et the Photographer fiels value

var photographer1= $("select[Title='Photographer1']").val();
var photographer2 = $("select[Title='Photographer2']").val();
var photographer3 = $("select[Title='Photographer3']").val();
var photographer4 = $("select[Title='Photographer4']").val();

// Code get the Contract  fiels value

var Contract1=$("input[title='Contract1']").val();
var Contract2=$("input[title='Contract2']").val();
var Contract3=$("input[title='Contract3']").val();
var Contract4=$("input[title='Contract4']").val();

        var contract = $("input[Title='Photoshoot/Contract']").val();
       

        var focus = $("input[Title='Focus ID']").val();
        // alert("focus ="+focus);

        var legalrestric=$("nobr:contains('Legal Restrictions')").closest('tr').find("div[role='textbox']").html();
     
        var tmp3 = document.createElement("DIV");
                tmp3.innerHTML = legalrestric;
                   legalrestric = tmp3.textContent||tmp3.innerText;
       //alert('update')
getprgEpiItemID(title,ProID,ProT,Epid,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox,airdate);
});
}
 
// function for get the value of control
function getPickerInputElement(identifier)
{
                //This function is used to retrieve the people picker field values
                var tags = document.getElementsByTagName("DIV");
                var retoucher="";
                for (var j=0; j < tags.length; j++)
                {
                var tempString = tags[j].id;
                                if ((tempString.indexOf(identifier) > 0) && (tempString.indexOf("UserField_upLevelDiv") > 0))
                                {
                                                var peoplePickerDivs = tags[j].getElementsByTagName("DIV"),
                                                i,
                                                length = peoplePickerDivs.length,
                                                dataDiv = null,
                                                parser = null,
                                                dataDoc = null;
                                               
                                                for (i = 0; i < length; i = i + 1)
                                                {
                                                                if (peoplePickerDivs[i].id != null)
                                                                {
                                                                                if (peoplePickerDivs[i].id == 'divEntityData')
                                                                                {
                                                                                                entityDataDiv = peoplePickerDivs[i];
                                                                                                dataDiv = entityDataDiv.getElementsByTagName('div')[0];
                               
                                                                                                if (window.DOMParser)
                                                                                                {
                                                                                                                parser = new DOMParser();
                                                                                                                dataDoc = parser.parseFromString(dataDiv.attributes["data"].value, "text/xml");
                                                                                                }
                                                                                                else
                                                                                                {
                                                                                                                dataDoc = new ActiveXObject("Microsoft.XMLDOM");
                                                                                                                dataDoc.async = "false";
                                                                                                                dataDoc.loadXML(dataDiv.attributes["data"].value);
                                                                                                }
                                                                                                var userId = getXmlValue(dataDoc, "/ArrayOfDictionaryEntry/DictionaryEntry[./Key = 'SPUserID']/Value");
                                                                                                //var userName = getXmlValue(dataDoc, "/ArrayOfDictionaryEntry/DictionaryEntry[./Key = 'AccountName']/Value");
                                                                                                var userName = entityDataDiv.getAttribute("displaytext");
                                                                                                retoucher += userId + ";#" + userName+";#";     //Gets the usersnames in 'ID;#DisplayName' format which is required in UpdateListItem spservice.                                                                                            
                                                                                }
                                                                }
                                                }
                                }
                }
                return retoucher;
}
// end  
    function getXmlValue(xmlDocument, xpath) {
   // alert("getXmlValue");
var results = null;

if (xmlDocument.evaluate) {
results = xmlDocument.evaluate("/ArrayOfDictionaryEntry/DictionaryEntry[./Key = 'SPUserID']/Value", xmlDocument, null, XPathResult.UNORDERED_NODE_SNAPSHOT_TYPE, null);
if (results.snapshotLength > 0) {
return results.snapshotItem(0).textContent;
}
} else {
results = xmlDocument.selectSingleNode(xpath);
if (results != null) {
return results.text;
}
}

return null;
}

function getPeoplePickerDataDocument() {
//alert("getPeoplePickerDataDocument");
var peoplePickerElement = document.getElementById('ctl00_m_g_f16d3211_6c5d_48a0_8c13_0baec8fc5d63_ff81_ctl00_ctl00_UserField_upLevelDiv'),
peoplePickerDivs = peoplePickerElement.getElementsByTagName('div'),
i,
length = peoplePickerDivs.length,

dataDiv = null,
parser = null,
dataDoc = null;

for (i = 0; i < length; i = i + 1) {
if (peoplePickerDivs[i].id != null) {
if (peoplePickerDivs[i].id == 'divEntityData') {
entityDataDiv = peoplePickerDivs[i];
dataDiv = entityDataDiv.getElementsByTagName('div')[0];

if (window.DOMParser) {
parser = new DOMParser();
dataDoc = parser.parseFromString(dataDiv.attributes["data"].value, "text/xml");
} else {
dataDoc = new ActiveXObject("Microsoft.XMLDOM");
dataDoc.async = "false";
dataDoc.loadXML(dataDiv.attributes["data"].value);
}

return dataDoc;
}
}
}

return null;
}

   
function ConvertDateToISO(dtDate)
{
//*************************************************
//Converts Javascript dtDate to ISO 8601 standard for compatibility with SharePoint lists
//Inputs: dtDate = Javascript date format (optional)
//*************************************************
//alert("InISOCOnversion");
  var d;
  if (dtDate != null)  {
     //Date value supplied
   
     d = new Date(dtDate);
  }
  else  {
     //No date supplied, Create new date object
     d = new Date();
  }
  //Generate ISO 8601 date/time formatted string
  var s = "";
  //alert(d.getFullYear());
  if(d.getFullYear)
  {
  //alert("FullYear");
         s += d.getFullYear() + "-";
    }
    else
    {
    //alert("getyear");
    var year= d.getYear() + 1900;
    s += year + "-";
       
    }
  //s += d.getYear() + "-";
  s += d.getMonth() + 1 + "-";
  s += d.getDate();
  s += "T" + d.getHours() + ":";
  s += d.getMinutes() + ":";
  //Replace the "Z" below with the required
  //time zone offset (eg "+10:00" - Australian EST)
  s += d.getSeconds() + "Z";
  //Return the ISO8601 date string
  return s;
}

function updatelistitem(title,ProID,dueDate,instructnnew,legalinstructnnew,typeofrequest,noofimages,status,retoucher,photographer1,photographer2,photographer3,photographer4,Contract1,Contract2,Contract3,Contract4,contract,focus,legalrestric,parentID,episodeID,accountmanager,comments,retoucher,ingestor,metadata,photoeditor,mrcontact1,mrcontact2,mrcontact3,mrcontact4,legalcontact1,legalcontact2,legalcontact3,legalcontact4,approvedcheckbox,RetouchingRequiredcheckbox,airdate)
{
 

    $().SPServices({
        operation: "UpdateListItems",
        async: false,
        listName: "Image Request Detail",      

        updates: "<Batch OnError='Continue' PreCalc='TRUE'>" +
                    "<Method ID='1' Cmd='New'>" +
                        "<Field Name='Title'>" + CDATAWrap(title) + "</Field>" +
                        "<Field Name='ProgramId'>" + CDATAWrap(ProID) + "</Field>" +
                         "<Field Name='DueDate'>" + CDATAWrap(dueDate) + "</Field>" +
                         "<Field Name='InstructionForRetoucher'>" + CDATAWrap(instructnnew) + "</Field>" +
                        // "<Field Name='LegalRestrictions'>" + CDATAWrap(legalinstructnnew) + "</Field>" +
"<Field Name='TypeOfRequest'>" + CDATAWrap(typeofrequest) + "</Field>" +
"<Field Name='NumberOfImages'>" + CDATAWrap(noofimages) + "</Field>" +
"<Field Name='Status'>" + CDATAWrap(status) +  "</Field>" +
"<Field Name='Retoucher'>" + CDATAWrap(retoucher) +  "</Field>" +
"<Field Name='CopyTypeOfRequest'>" + typeofrequest +  "</Field>" +

"<Field Name='Photographer1'>" + CDATAWrap(photographer1) +  "</Field>" +
"<Field Name='Photographer2'>" + CDATAWrap(photographer2) +  "</Field>" +
"<Field Name='Photographer3'>" + CDATAWrap(photographer3) +  "</Field>" +
"<Field Name='Photographer4'>" + CDATAWrap(photographer4) +  "</Field>" +

"<Field Name='Contract1'>" + CDATAWrap(Contract1) +  "</Field>" +
"<Field Name='Contract2'>" + CDATAWrap(Contract2) +  "</Field>" +
"<Field Name='Contract3'>" + CDATAWrap(Contract3) +  "</Field>" +
"<Field Name='Contract4'>" + CDATAWrap(Contract4) +  "</Field>" +


//"<Field Name='ProgramId'>" + CDATAWrap(parentID) +  "</Field>" +
"<Field Name='ProgramTitle'>" + CDATAWrap(parentID) +  "</Field>" +

"<Field Name='EpisodeID'>" + CDATAWrap(episodeID) +  "</Field>" +
"<Field Name='Episode'>" + CDATAWrap(episodeID) +  "</Field>" +
// "<Field Name='PhotoshootContract'>" + CDATAWrap(contract) +  "</Field>" +
"<Field Name='FocusID'>" + CDATAWrap(focus) +  "</Field>" +
"<Field Name='LegalRestrictions'>" + CDATAWrap(legalrestric) +  "</Field>" +
"<Field Name='AccountManager'>" + CDATAWrap(accountmanager) +  "</Field>" +
"<Field Name='Comments'>" + CDATAWrap(comments) +  "</Field>" +
"<Field Name='Ingestor'>" + CDATAWrap(ingestor) +  "</Field>" +
"<Field Name='Metadata'>" + CDATAWrap(metadata) +  "</Field>" +
"<Field Name='PhotoEditor'>" + CDATAWrap(photoeditor) +  "</Field>" +
"<Field Name='MRContact_x0023_1'>" + CDATAWrap(mrcontact1) +  "</Field>" +

"<Field Name='MRContact_x0023_2'>" + CDATAWrap(mrcontact2) +  "</Field>" +
"<Field Name='MRContact_x0023_3'>" + CDATAWrap(mrcontact3) +  "</Field>" +
"<Field Name='MRContact_x0023_4'>" + CDATAWrap(mrcontact4) +  "</Field>" +
"<Field Name='LegalContact_x0023_1'>" + CDATAWrap(legalcontact1) +  "</Field>" +
"<Field Name='LegalContact_x0023_2'>" + CDATAWrap(legalcontact2) +  "</Field>" +
"<Field Name='LegalContact_x0023_3'>" + CDATAWrap(legalcontact3) +  "</Field>" +
"<Field Name='LegalContact_x0023_4'>" + CDATAWrap(legalcontact4) +  "</Field>" +
"<Field Name='ApprovalRequiredByPE'>" + CDATAWrap(approvedcheckbox) +  "</Field>" +
"<Field Name='NoRetouchingRequired'>" + CDATAWrap(RetouchingRequiredcheckbox) +  "</Field>" +
"<Field Name='ADate'>" + CDATAWrap(airdate) +  "</Field>" +


                    "</Method>" +
                "</Batch>",
        completefunc: function (xData, Status) {
            //get the ID for the newly created Issue
            var out = $().SPServices.SPDebugXMLHttpResult({
node: xData.responseXML
});

            var newId =  $(xData.responseXML).SPFilterNode("z:row").attr("ows_ID");
         
        }
     
    });
alert("Request Created Successfully");
//$( "#dialog" ).dialog();
window.location.href = '/sites/photoservices/SitePages/Photoeditorjobqueue_Home.aspx';

//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageThenRedirect", "alert('" + "Item created successfully!" + "');window.location='" + "/sites/photoservices/SitePages/Photoeditorjobqueue_Home.aspx",true);

    }

function CDATAWrap(data)
{
return "<![CDATA[" + data + "]]>";
}


// Function for getting commnets on page load  from Photographer lis
$(document).ready(function() {

// Photographer #1
$('select[title="Photographer1"]').change(function(e) {
var selectedValue = $('select[title="Photographer1"] :selected').text();

$().SPServices({
       operation: "GetListItems",
       listName: "Photographers",
       CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
           
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+selectedValue+"</Value></Eq></Where></Query>",
       completefunc: function (xData, Status) {
        //alert(Status);
           $(xData.responseXML).SPFilterNode("z:row").each(function() {
            //PremiereDate = $(this).attr("ows_PremiereDate");

               var comments= $(this).attr("ows_Comments");
               if(comments!= null)
            {              
             document.getElementById('Label1').innerHTML = comments;
               }
               else
               {
                document.getElementById('Label1').innerHTML = "";
               }

               
});
 }
});
});
//2nd Photographer
$('select[title="Photographer2"]').change(function(e) {
var ph2= $('select[title="Photographer2"] :selected').text();

$().SPServices({
       operation: "GetListItems",
       listName: "Photographers",
       CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
           
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+ph2+"</Value></Eq></Where></Query>",
       completefunc: function (xData, Status) {
        //alert(Status);
           $(xData.responseXML).SPFilterNode("z:row").each(function() {
            //PremiereDate = $(this).attr("ows_PremiereDate");

               var comments2= $(this).attr("ows_Comments");
               if(comments2!= null)
            {              
             document.getElementById('Label2').innerHTML = comments2;
               }
               else
               {
                document.getElementById('Label2').innerHTML = "";
               }

               
});
 }
});
});

//3rd Photographer
$('select[title="Photographer3"]').change(function(e) {
var ph3= $('select[title="Photographer3"] :selected').text();

$().SPServices({
       operation: "GetListItems",
       listName: "Photographers",
       CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
           
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+ph3+"</Value></Eq></Where></Query>",
       completefunc: function (xData, Status) {
        //alert(Status);
           $(xData.responseXML).SPFilterNode("z:row").each(function() {
            //PremiereDate = $(this).attr("ows_PremiereDate");

               var comments3= $(this).attr("ows_Comments");
               if(comments3!= null)
            {              
             document.getElementById('Label3').innerHTML = comments3;
               }
               else
               {
                document.getElementById('Label3').innerHTML = "";
               }

               
});
}
});

});
//Photographer
//4rd Photographer
$('select[title="Photographer4"]').change(function(e) {
var ph4= $('select[title="Photographer4"] :selected').text();

$().SPServices({
       operation: "GetListItems",
       listName: "Photographers",
       CAMLViewFields: "<ViewFields><FieldRef Name='Comments' /></ViewFields>",
           
       CAMLQuery: "<Query><Where><Eq><FieldRef Name='Name'/><Value Type='Text'>"+ph4+"</Value></Eq></Where></Query>",
       completefunc: function (xData, Status) {
        //alert(Status);
           $(xData.responseXML).SPFilterNode("z:row").each(function() {
            //PremiereDate = $(this).attr("ows_PremiereDate");

               var comments4= $(this).attr("ows_Comments");
               if(comments4!= null)
            {              
             document.getElementById('Label4').innerHTML = comments4;
               }
               else
               {
                document.getElementById('Label4').innerHTML = "";
               }

               
});
}
});

});
});



// comments hide show
$(document).ready(function(){
/* Hide/Show Editable 'Comments' column based on the 'Status' on page load*/
/* .hiddencolumn is used for editable 'Comments' field & .displayedcolumn is used for displayed 'Comments' field */

if(($("select[title='Status']").val() == 'Approved') || ($("select[title='Status']").val() == 'Rejected'))
{
$('.hiddencolumn').show();
$('.displayedcolumn').hide();


}

/* Hide/Show Editable 'Comments' column based on the 'Status' selected */
$("select[title='Status']").change(function(){
if(($("select[title='Status']").val() == 'Approved') || ($("select[title='Status']").val() == 'Rejected'))
{
// If 'Retouching Approved' or 'Retouching Rejected' is selected, then display editable 'Comments' and hide noneditable 'Comments'
$(".hiddencolumn").show();
$('.displayedcolumn').hide();



}
else
{
// if the above two status's are not selected, then display only non-editable 'Comments' column
$(".hiddencolumn").hide(); // Hide editable 'Comments' field
$(".hiddencolumn div[role='textbox'] p").html(""); // empty the editable 'Comments' field. Because, otherwise, if anyone of the above two status are selected again then earlier entered 'Comments' will be displayed
$('.displayedcolumn').show(); // show the non-editable content


}
});

});

// Popup window code
function newPopup(url){
popupWindow = window.open(
url,'popUpWindow','height=500,width=800,left=50,top=30,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes')
}
//*****************************************************Code END****************************************************

Comments

Popular posts from this blog

PowerShell For create Sub site in office 365

#Add references to SharePoint client assemblies and authenticate to Office 365 site Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.dll" Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.Runtime.dll" $Username = Read-Host -Prompt "Please enter your username" $Password = Read-Host -Prompt "Please enter your password" -AsSecureString $Site = "https://XXXXXXX.sharepoint.com/sites/Test2/" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site) $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) $Context.Credentials = $Creds $csvLocation = "C:\Users\PS_SiteCollectionsToCreate.csv" $csv = Import-Csv $csvLocation #List Custom Templates $Templates = $Context.Site.GetWebTemplates("1033","0") $Context.Load($Templates) $Context.ExecuteQuery() $Templates | Whe...

SharePoint Capacity Management and Sizing Overview

Capacity management   is an ongoing process, because no implementation remains static with regard to content and usage. You need to plan for growth and change, so that your SharePoint Server 2013–based environment can continue to deliver an effective business solution. Capacity Planning  is only one part of the capacity management cycle. It is the initial set of activities that brings the design architect to the point where there is an initial architecture that the architect believes will best serve the SharePoint Server 2013 deployment. The capacity management model includes additional steps to help you validate and tune the initial architecture, and provides a feedback loop for re-planning and optimizing the production environment until it can support design goals with optimal choices of hardware, topology, and configuration. Capacity management versus capacity planning Capacity management extends the concept of capacity planning to express a cyclical appr...

Convert SharePoint Date in to ConvertDateToISO - And Use for Custom Save

-------------Code ------------------------------------------- function ConvertDateToISO(dtDate) { //************************************************* //Converts Javascript dtDate to ISO 8601 standard for compatibility with SharePoint lists //Inputs: dtDate = Javascript date format (optional) //************************************************* //alert("InISOCOnversion");   var d;   if (dtDate != null)  {      //Date value supplied           d = new Date(dtDate);   }   else  {      //No date supplied, Create new date object      d = new Date();   }   //Generate ISO 8601 date/time formatted string   var s = "";   //alert(d.getFullYear());    if(d.getFullYear)    {    //alert("FullYear");          s += d.getFullYear() + "-";     }     else     {      //alert("ge...