Datagrid checkbox questions

[siccak]

Hello,

I have two questions about using datagrid with checkbox column.

1. check All button

I am using my datagrid with pagination and if I click check all button then only rows on first page are selected. Is there any way how to check rows on all pages?

2. hiding checkbox and getChecked method

Is there any way how to conditionally hide checkbox on row, based on some formula or anything else? I am achieving this by using rowStyler, but it has some drawbacks. getChecked method is returning values from all checkboxes (not respecting hidden or disabled checkboxes) and this will be more complicated if my first question will be answered.

Thank you, Sicco

[jarry]

Click the check button on column header, only the current page rows are checked. You can custom this behavior by overriding the 'onCheckAll' and 'onUncheckAll' event handlers.

Code:

$('#tt').datagrid({
    url:'test.php',
    pagination:true,
    idField:'itemid',
    onCheckAll:function(){
        var state = $(this).data('datagrid');
        $.ajax({
            url:'getallrows.php',
            type:'POST',
            dataType:'json',
            success:function(data){
                state.checkedRows = data.rows;
                state.selectedRows = data.rows;
            }
        })
    },
    onUncheckAll:function(){
        var state = $(this).data('datagrid');
        state.checkedRows = [];
        state.selectedRows = [];
    }
});

[siccak]

Thank you jarry, it works.

And about my second question, it seems I am out of luck.

Siccak

[jarry]

To hide the checkbox conditionally, define the 'styler' or 'rowStyler' function to achieve this functionality. Please refer to the code below.

Code:

<style>
  .dg-nocheck .datagrid-cell-check{
    display: none;
  }
</style>
<th data-options="field:'ck',checkbox:true,
    styler:function(index,row){
      if (row.listprice>40){
        return {class:'dg-nocheck'};        
      }
    }"></th>

[lloyd]

I was going to ask the same (1. check All button) question.
I would suggest doing it this way as the pagination function already has all the data.

Code:

        tg.treegrid({
            onCheckAll: function() {
                var allRows = $(this).treegrid('getAllRows');
                var state = $(this).data('datagrid');
                
                state.checkedRows = allRows;
            },
            onUncheckAll: function() {
                var state = $(this).data('datagrid');
                state.checkedRows = [];
            }
        }).treegrid('clientPaging');