ignite-ui infrafistics grid computed checkbox column

2015 version

by wwwroot

HTML

<script src="http://igniteui.com/js/modernizr.min.js"></script>
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.min.js"></script>
<script src="http://cdn-na.infragistics.com/igniteui/2015.2/latest/js/infragistics.core.js"></script>
<script src="http://cdn-na.infragistics.com/igniteui/2015.2/latest/js/infragistics.lob.js"></script>
<script src="http://igniteui.com/js-data/northwindProducts"></script>
<link href="http://cdn-na.infragistics.com/igniteui/2015.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet"></link>
<link href="http://cdn-na.infragistics.com/igniteui/2015.2/latest/css/structure/infragistics.css" rel="stylesheet"></link>

<table id="grid1"></table>

CSS

.c1 {
  background-color: red;
}

JavaScript

$(function() {

  function calculateTotal(data, grid) {
    var res = data["Exclude1"] * data["Exclude2"] * data["Exclude3"];
    console.info(res);
    return res;
  }

  function onEditCellEnded(evt, ui) {
    console.log(ui);
    console.info(data_source);
    if (ui.columnKey === "all") {
      data_source[ui.rowID - 1]["Exclude1"] = ui.value;
      data_source[ui.rowID - 1]["Exclude2"] = ui.value;
      data_source[ui.rowID - 1]["Exclude3"] = ui.value;
    } else {
      data_source[ui.rowID - 1][ui.columnKey] = !ui.value;
    }
    $('#grid1').igGrid("dataBind");
  }

  var columnSettings = [{
    headerText: "",
    key: "ProductID",
    hidden: true
  }, {
    headerText: "Product Name",
    key: "ProductName",
    readOnly: true
  }, {
    headerText: "All",
    key: "all",
    readOnly: false,
    dataType: "bool",
    unbound: true,
    formula: calculateTotal
  }, {
    headerText: "Exclude1",
    key: "Exclude1",
    readOnly: false,
    dataType: "bool"
  }, {
    headerText: "Exclude2",
    key: "Exclude2",
    readOnly: false,
    dataType: "bool"
  }, {
    headerText: "Exclude3",
    key: "Exclude3",
    readOnly: false,
    dataType: "bool"
  }, ];
  $('#grid1').igGrid({
    dataSource: data_source,
    primaryKey: "ProductID",
    responseDataKey: "results",
    dataSourceType: "json",
    width: "100%",
    enableHoverStyles: false,
    autoGenerateColumns: false,
    columns: columnSettings,
    renderCheckboxes: true,

    features: [{
      name: "Filtering",
      allowFiltering: true,
      caseSensitive: false
    }, {
      name: 'Sorting',
      type: "local",
    }, {
      name: "Updating",
      validation: false,
      enableAddRow: false,
      editMode: "cell",
      excelNavigationMode: true,
      enableDeleteRow: false,
      editCellEnded: onEditCellEnded,
      editCellStarted: function() {
        $("#grid1").igGridUpdating("endEdit", true, true);
      }
    }]
  });
});

var data_source = [{
  "ProductID": 1,
 ...