lundi 17 juillet 2017

how to add Checkbox dynamically for all rows and columns while page onload Jquery datatable?

I need to add checkboxes in all rows and column header while onload of datatable.

Here is the HTML code

<body>
    <c:if test="${not empty table}">
  ${table}
</c:if>

</body>
<script>

    $(document).ready(function() {
        $('#sheet_0').DataTable();

        var container = $('#sheet_0');
        var rowSize = $('table#sheet_0 tr').length
        alert(rowSize);

        for (var r = 0; r < rowSize; r++) {
            $('<input />', {
                type : 'checkbox',
                id : 'cb' + id,
                value : name
            }).appendTo('tr');
        }

    });     
</script>

I have done like above checkboxes are not loaded. The table is loaded by reading an Xlsx file and load into HTML

Using spring I have set the table content in model attribute and view in html.

<table border="1" cellpadding="2" cellspacing="0" id="sheet_0" style="border-collapse: collapse;">
          <tr>
            <td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1" colspan="3">Seguros Generales</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1" colspan="3">Seguros de Personas</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1">&nbsp;</td><td class="td_0_1" rowspan="2">Total general</td>
          </tr>
          <tr>
            <td class="td_0_2">Modalidad</td><td class="td_0_2">Ramo</td><td class="td_0_2">LBC-G</td><td class="td_0_2">CRI-G</td><td class="td_0_2">ILL-G</td><td class="td_0_2">ALI-G</td><td class="td_0_3">BIS-G</td><td class="td_0_3">FOR-G</td><td class="td_0_3">LAT-G</td><td class="td_0_2">TOT. SG</td><td class="td_0_3">BUP-P</td><td class="td_0_2">LVI-P</td><td class="td_0_2">LBC-P</td><td class="td_0_3">PRO-P</td><td class="td_0_3">NAL-P</td><td class="td_0_3">ALI-P</td><td class="td_0_3">CRDI-P</td><td class="td_0_2">TOT. SP</td>
          </tr>
          <tr>
            <td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_3">&nbsp;</td><td class="td_0_2">&nbsp;</td><td class="td_0_2">&nbsp;</td>
          </tr>
          <tr>
            <td class="td_0_2">Seguros Generales</td><td class="td_0_2">Incendio</td><td class="td_0_3">0.0</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">0.0</td><td class="td_0_3">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_2">-</td><td class="td_0_2">0.0</td>
          </tr>
          <tr>
            <td class="td_0_2">&nbsp;</td><td class="td_0_2">Robo</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_2">-</td><td class="td_0_3">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_2">-</td><td class="td_0_2">-</td>
          </tr>
          <tr>
            <td class="td_0_2">&nbsp;</td><td class="td_0_2">Transportes</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_2">-</td><td class="td_0_3">-</td><td class="td_0_4">-</td><td class="td_0_4">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_3">-</td><td class="td_0_2">-</td><td class="td_0_2">-</td>
          </tr>
          <tr>
<table>

Help me to fix this, Thanks




Aucun commentaire:

Enregistrer un commentaire