javascript - RowGrouping and SubTotals in Sharepoint List using Datatables -


hi using sharepoint list displaying using datatables , referred 1 articles , grouping not able group totals ,rowgrouping , subtotal on datatable

in field on grouping on calculated field called heirarch example field values generaly capital.establishment concatenation of 2 fields

below code

<script type="text/javascript" charset="utf8" src="http://code.jquery.com/jquery-1.11.3.min.js"></script>  <!-- datatables css -->  <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.css"/> <!-- datatables -->  <script type="text/javascript" src="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.js"></script> <script type="text/javascript" src="http://jquery-datatables-row-grouping.googlecode.com/svn/trunk/media/js/jquery.datatables.rowgrouping.js"></script>  <style type="text/css">     tr.group, tr.group:hover {     background-color: #ddd !important; } .pocell {     font-weight:bold; } </style>  <table id="example" class="display" cellspacing="0" width="100%">   <thead>     <tr>      </tr>   </thead>   </table>  <script type="text/javascript">   $(document).ready(function() {          var call = $.ajax({              url: _sppagecontextinfo.webabsoluteurl + "/_api/web/lists/getbytitle('demo%20custom%20list')/items?$select=hierarch,title,year2015,year2016,year2017,year2018,year2019,exp_x0020_total",              type: "get",              datatype: "json",              headers: {                  accept: "application/json;odata=verbose"              }           });          call.done(function (data,textstatus, jqxhr){ var marker;  var table = $('#example').datatable({     "aadata": data.d.results,     "columns": [         {             "title": "hierarchy",             "mdata": "hierarch",             "visible": false           }, {             "title": "title",             "mdata": "title"         }, {             "title": "year2015",             "mdata": "year2015",             "sortable": false         }, {             "title": "year2016",             "mdata": "year2016",             "sortable": false         }, {             "title": "year2017",             "mdata": "year2017",             "sortable": false         }, {             "title": "year2018",             "mdata": "year2018",             "sortable": false         }, {             "title": "year2019",             "mdata": "year2019",             "sortable": false         }, {             "title": "total expense",             "mdata": "exp_x0020_total",             "sortable": false         }     ],     "drawcallback": function (settings) {          var api = this.api();         var rows = api.rows({             page: 'current'         }).nodes();         var last = null;         api.column(0, {             page: 'current'         }).data().each(function (group, i) {             if (last !== group) {                 $(rows).eq(i).before(                 $("<tr></tr>", {                     "class": "group",                     "data-id": group                 }).append($("<td></td>", {                     "colspan": 1,                     "class": "pocell",                     "text": "hierarch # " + group.split('_').join('.')                 })).append($("<td></td>", {                     "id": "e" + group,                     "class": "nocount",                     "text": "60.00"                 })).append($("<td></td>", {                     "id": "f" + group,                     "class": "nocount",                     "text": "60.00"                 })).append($("<td></td>", {                     "id": "g" + group,                     "class": "nocount",                     "text": "50.00"                 })).append($("<td></td>", {                     "id": "h" + group,                     "class": "nocount",                     "text": "40.00"                 })).append($("<td></td>", {                     "id": "i" + group,                     "class": "nocount",                     "text": "30.00"                 })).append($("<td></td>", {                     "id": "j" + group,                     "class": "nocount",                     "text": "20.00"                 })).prop('outerhtml'));                 last = group;             }              val = api.row(api.row($(rows).eq(i)).index()).data();                $("#e" + val.hierarch.split('.').join('_')).text(parsefloat($("#e" + val.hierarch.split('.').join('_')).text()) + parsefloat(val.year2015));          //   $("#e" + val.hierarch).text(parsefloat($("#e" + val.hierarch).text()) + val.year2015);             $("#f" + val.hierarch).text(parsefloat($("#f" + val.hierarch).text()) + val.year2015);             $("#g" + val.hierarch).text(parsefloat($("#g" + val.hierarch).text()) + val.year2015);             $("#h" + val.hierarch).text(parsefloat($("#h" + val.hierarch).text()) + val.year2015);             $("#i" + val.hierarch).text(parsefloat($("#i" + val.hierarch).text()) + val.year2015);             $("#j" + val.hierarch).text(parsefloat($("#j" + val.hierarch).text()) + val.year2015);         });     } }); });          call.fail(function (jqxhr,textstatus,errorthrown){                  alert("error retrieving tasks: " + jqxhr.responsetext);          });  } );  </script>


Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more