SpServices with JqGrid in Page Load sharepoint

-
Hi friends,
Here is code to display spservices getlistitems in jqgrid Sharepoint page load event.
Here is the code. here my list name is ProjectDetails.


<head runat="server">
<meta name="WebPartPageExpansion" content="full" />
<meta http-equiv="X-UA-Compatible" content="IE=10" />
<SharePoint:CssRegistration Name="default" runat="server"/>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<style type="text/css" src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/css/ui.jqgrid.css"></style>
<link href="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/css/ui.jqgrid.css"></link>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/i18n/grid.locale-el.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/jquery.jqGrid.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/json2/20140204/json2.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices-2014.02.min.js"></script>


<script>

</script>
<script>
$(document).ready(function() {
var mydata;
var JqData1=[];
GetMyData();
function ForGettingUserName() {
  var userName = $().SPServices.SPGetCurrentUser({
      fieldName : "Title",
      debug : false
    });
  return userName;
}

function GetMyData() {
ForGettingUserName();

  sortIdexName = jQuery("#list").getGridParam("sortname"); //Maintaining Consitant SortName after the Sortcol event
  sortOrderName = jQuery("#list").getGridParam("sortorder"); //Maintaining Consistant Sort Order
  Query = "<Query> <Where><Eq><FieldRef Name='ApprovalStatus' /><Value Type='Text'>Pending</Value></Eq></Where></Query>";
  //Query = GetTheOrderByType(sortIdexName, sortOrderName);

  var CAMLViewFields ="<ViewFields>"+" <FieldRef Name='ProjectId' />"+
  "<FieldRef Name='ProjectName' /><FieldRef Name='DeliveryManager' /><FieldRef Name='ApprovalStatus' /></ViewFields>"
  GetDataOnLoad(Query, CAMLViewFields);
}
//Function for Getting the Query Type and the particular WHERE CLAUSE TO send the Query to GetListItem function
/*function GetTheOrderByType(index, sortOrder, userName) {
  var OrderByType;
  if (index == "ProjectName") {
    if (sortOrder == "desc") {
      OrderByType = "<Query>" +
         + "<Where><Or>" + "<Eq>" + "<FieldRef Name='deliveryManager'/><Value Type='Text'>"
         + userName + "</Value>" + "</Eq>"
         + "<Eq><FieldRef Name='projectManager'/><Value Type='Text'>"
         + userName + "</Value></Eq>" + "</Or></Where>" +
         + "<OrderBy><FieldRef  Name='projectName' Ascending='FALSE' /></OrderBy>" +
         + "</Query>";
    } else {
      OrderByType = "<Query>" +
         + "<Where><Or>" + "<Eq>" + "<FieldRef Name='deliveryManager'/><Value Type='Text'>"
         + userName + "</Value>" + "</Eq>"
         + "<Eq><FieldRef Name='projectManager'/><Value Type='Text'>"
         + userName + "</Value></Eq>" + "</Or></Where>" +
         + "<OrderBy><FieldRef  Name='projectName' Ascending='FALSE' /></OrderBy>" +
         + "</Query>";
    }
  } else if (index == "ApprovalStatus") {
    if (sortOrder == "desc") {
      OrderByType = "<Query>" +
         + "<Where><Or>" + "<Eq>" + "<FieldRef Name='deliveryManager'/><Value Type='Text'>"
         + userName + "</Value>" + "</Eq>"
         + "<Eq><FieldRef Name='projectManager'/><Value Type='Text'>"
         + userName + "</Value></Eq>" + "</Or></Where>" +
         + "<OrderBy><FieldRef  Name='approvalStatus' Ascending='FALSE' /></OrderBy>" +
         + "</Query>";
    } else {
      OrderByType = "<Query>" +
         + "<Where><Or>" + "<Eq>" + "<FieldRef Name='deliveryManager'/><Value Type='Text'>"
         + userName + "</Value>" + "</Eq>"
         + "<Eq><FieldRef Name='projectManager'/><Value Type='Text'>"
         + userName + "</Value></Eq>" + "</Or></Where>" +
         + "<OrderBy><FieldRef  Name='approvalStatus' Ascending='FALSE' /></OrderBy>" +
         + "</Query>";
    }
    return OrderByType;
  }
}*/
  //This function gets the data from List using SpServices
  function GetDataOnLoad(Query, CAMLViewFields) {
    $().SPServices({
      operation : "GetListItems",
      async : false,
      listName : "ProjectDetails",
      CAMLQuery : Query,
      CAMLViewFields : CAMLViewFields,
      completefunc : processResult
    });
  }

//Processing the XML result to formatted Json so that We can bind data to grid in Json format
function processResult(xData, status) {
  var counter = 0; // Gets the total number of records retrieved from the list (We can also use xData.ItemCount method for counting the number of rows in the data )
  var newJqData = "";
alert(xData.responseText);
  $(xData.responseXML).SPFilterNode("z:row").each(function () {

    var JqData={};
    if (counter == 0) {
     JqData.PID= $(this).attr("ows_ID");
     JqData.PName=$(this).attr("ows_ProjectName");
     JqData.PManager=$(this).attr("ows_DeliveryManager");
JqData.PStatus=$(this).attr("ows_ApprovalStatus");
      counter = counter + 1;
    } else {
      JqData.PID= $(this).attr("ows_ID");
      JqData.PName=$(this).attr("ows_ProjectName");
      JqData.PManager=$(this).attr("ows_DeliveryManager");
JqData.PStatus=$(this).attr("ows_ApprovalStatus");

      counter = counter + 1;  
      }
      JqData1.push(JqData);
  });
//];
 // FinalDataForGrid(newJqData, counter);
}
/*
function FinalDataForGrid(jqData, resultCount) {
  dataFromList = jqData;
  //var a;
  var currentValue = jQuery("#list").getGridParam('rowNum');
  var totalPages = Math.ceil(resultCount / currentValue);
  var PageNumber = jQuery("#list").getGridParam("page"); // Current page number selected in the selection box of the JqGrid  //formatting rows
 newStr = "{total:" + '"' + 1 + '"' + "," + "page:" + '"' + 1 + '"' + ","
     + "records:" + '"'
     + resultCount + '"' + ","
     + "rows:"
     + "[" + dataFromList + "]}";
     alert(newStr );
  var a = jQuery("#list")[0];
  a.addJSONData(newStr); //Binding data to the grid which is of JSON Format
 //jQuery("#list").addJSONData(newStr);
}
*/
//var a = jQuery("#list")[0];
 jQuery("#list").jqGrid({
  data: JqData1,
  datatype: "local",
   height: 150,
   width:900,
         hidegrid: false,
  colNames: ['PID', 'PName','PManager','PStatus'],
         colModel: [
             { name: 'PID', index: 'PID', width: 100, align: "center", sorttype: 'int' },
             { name: 'PName', index: 'PName', width: 100, align: "left" },
             { name: 'PManager', index: 'PManager', width: 100, align: "left" },
             { name: 'PStatus', index: 'PStatus', width: 100, align: "left" }
                   ],

  pager: true,
  pager: '#pager',
  pageinput: true,
  rowNum: 5,
  rowList: [5, 10, 20, 50, 100],
  sortname: 'ApprovalStatus',
  sortorder: "asc",
  viewrecords: true,
  autowidth: true,
  emptyrecords: "No records to view",
  loadtext: "Loading..."
});
jQuery("#list").jqGrid('navGrid', "#pager", { edit: false, add: false, del: false, search: true, refresh: true });


});
</script>

</head>

<body>

<form id="form1" runat="server">

<div id='tblMain' style="float:left;width:600px">
  <table  id="list" ></table>
  <div id="pager" style="text-align:center;"></div>
</div>

</form>

</body>


Comments

Post a Comment

Popular posts from this blog

WCF interview questions

-
Windows Communication Foundation is... Some Important points I have collected from MSDN site are: A part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise. The global acceptance of Web services, which includes standard protocols for application-to-application communication, has changed software development. For example, the functions that Web services now provide include security, distributed transaction coordination, and reliable communication. The benefits of the changes in Web services should be reflected in the tools and technologies that developers use. Windows Communication Foundation (WCF) is designed to offer a manageable approach to distributed computing, broad interoperability, and direct support for service orientation. WCF simplifies development of connected applications through a new service-oriented programming model. WCF supports many styles of...
Read more

The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or operable program

-
Following worked for me: Uninstall the previously installed ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. Install 64-bit versions of ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. https://littletalk.wordpress.com/2013/09/23/install-and-configure-the-office-365-powershell-cmdlets/ If you get the following error  In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer , then install the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:  http://www.microsoft.com/en-us/download/details.aspx?id=39267 Copy the folders called MSOnline and MSOnline Extended from the source C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ to the folder C:\Windows\SysWOW64\WindowsPowerShell\v1.0...
Read more

what is Event Cache table in sharepoint

-
Every Content database in SharePoint Contains an EventCache table that is the change log for objects contained in the database. Each row in this table is depicting a change in an object where columns usually contain information such as the date and time of a change, the type of object that was changed, the nature of the change, and a unique identifier for the object. EventCache table is important because it stores the list of site events for which users might have requested alerts.
Read more