How to submit all wrapper class records using datatables.net jQuery plugin & apex dataTable?

Question

I am using the [datatables.net][1] jQuery plugin with an <apex:datatable /> and I want to submit all records checked from the dataTable meaning i'm using

<apex:stylesheet value="{!$Resource.lib}/css/jquery.dataTables.css"> 
<apex:includeScript value="{!$Resource.lib}/js/jquery.dataTables.min.js"/> 

Here is the Code to initialize dataTable Jquery:

 jQuery(document).ready(function(){
    $('table[id$="itemsList"]').dataTable();

    // Check / uncheck all available rows at once.
        jQuery('#selectAll').click( function(){             
            if(jQuery(this).is(':checked')){
                jQuery('.chkProd').attr('checked', true);               
            }else{
                jQuery('.chkProd').attr('checked', false);
            }
           });
 });

in my VisualForce Page. And i have the follow environment, which has "10","50","100" options records to display:

<apex:dataTable value="{!listaInnerProduct}" var="item" id="itemsList" rowClasses="odd,even" rendered="{!IF(tempListaInnerProd.size == 0,true,false)}">
           <apex:column >  
             <apex:facet name="header">
                <input type="checkbox" id="selectAll" value="" title="Selecccionar todos los registros." />
             </apex:facet>   
             <apex:inputCheckbox styleClass="chkProd" value="{!item.isSelected}" />  
           </apex:column>              
           <apex:column >  
             <apex:facet name="header">Cantidad</apex:facet> 
             <apex:inputText value="{!item.cantidad}" style="width:30px;" onkeypress="return isNumberKey(event)"></apex:inputText>
           </apex:column>         
</apex:dataTable>

Controller Code:

public with sharing class AgregarProductosController {

 public List<InnerProduct> listaInnerProduct {get;set;}

 public AgregarProductosController(ApexPages.standardController stdCon){
  this.listaInnerProduct = obtenerProductosInternos();
 }

public List<InnerProduct> obtenerProductosInternos(){
 List<InnerProduct> listaInnerProduct = new List<InnerProduct>();
 InnerProduct inProd;
 for(Product2 prod : [Select Id,Name From Product2]){

  //code to create new Wrapp object for each product2

 }
}

public class InnerProduct{
    public Id productId {get;set;}
    public String name {get;set;}
    public Boolean isSelected {get;set;}
}

I have the following problem:

-If i do check on some Rows and then go to Next Page button, and then Click on my commandButton.. the previous values are not sending to the server. Only the current page.

My question is: How could i send an array of ObjectHTMLRowElement (which ones i got it from the dataTable()) from the visualforce page to the controller and parse it to sObject?

Answer 1

I suggest you get in touch with Allan, at data tables.net/support : he is extremely reactive and efficient, you will get the answer you your questions, he has solved many for me already.

Answer 2

@mauforcedev What was the resolution to your datatables issue? I am in a similar predicament.

Thanks!

Answer 3

This was answered by mauriD in the comments above, but I will try to summarize it with a real example, so others will get a clear view of the solution. I provide the most essential code here without formatting, css styles etc.

VISUAL FORCE PAGE

External scripts on the page:

<apex:page controller="CustomController" showHeader="false" sidebar="false" standardStylesheets="false" docType="html-5.0">
<!-- jQuery -->
<apex:includescript value="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js" />
<!-- jQuery Data Table-->
<apex:includescript value="//cdn.datatables.net/1.10.4/js/jquery.dataTables.min.js" />
<apex:stylesheet value="//cdn.datatables.net/1.10.4/css/jquery.dataTables.min.css" /> 

Datatable initialization:

<apex:outputPanel id="contactTable">
    <!-- jQuery Data Table Start -->
    <script>
        $ = jQuery.noConflict();
        /* Initialise the table with the required column ordering data types */
        $(document).ready(function() {
            var mainTable = $('[id$="mainTable"]').dataTable(
                {
                    "order": [[ 1, "asc" ]],
                    "paging": true,
                    "pagingType": "full_numbers",
                    "pageLength":  10,
                    "stateSave": false,
                    "columnDefs": [ 
                        {"targets": 0, "orderable": false} 
                    ]
                }
            );
        } );
    </script>

    <table id="mainTable">
        <thead>
            <tr>
                <th><apex:inputCheckbox value="false" id="contactsMain" /></th>
                <th>NAME</th>
            </tr>
        </thead>

        <tbody>
            <apex:repeat value="{!leads}" var="lead" >
                <tr>
                    <td><apex:inputCheckbox value="{!lead.Can_Be_Contacted__c}"/></td>
                    <td><apex:outputText value="{!lead.name}"/></td>
                </tr>
            </apex:repeat>
        </tbody>
    </table>
    <!-- jQuery Data Table End -->
</apex:outputPanel>

<apex:pageMessages id="messagesSection"/>

Submit to the controller:

When a user clicks the "Continue" button, a js function will be invoked that do two important things: (1) displays all table rows on one page and (2) invokes an action function that makes an AJAX request to the controller passing all parameters. Notice that upon completion of AJAX call the following elements will be rerendered: contactTable and messagesSection. That makes sure that the page will display correct data (updated by the controller) and DataTable will be reinitialized again so the pagination will be restored.

<script>
    function prepareTable()
    {
        try
        {
            var contactTable = $('[id$="contacttable"]').DataTable();
            // redraw the table to show all rows on one page
            contactTable.page.len( -1 ).draw();
            // call actionFunction
            handleSubmit();
            return true;
        }
        catch (err)
        {
            console.log(err.message);
            return false;    
        }
    }
</script>
<button type="button" onclick="prepareTable()">Continue</button>
<apex:actionFunction name="handleSubmit" action="{!handleSubmit}" reRender="contactTable, messagesSection"/>

</apex:page>

CONTROLLER

public with sharing class CustomController
{
    public List<Lead> leads { get; set; }

    public CustomController()
    {
        this.leads = [SELECT Id, Name, Can_Be_Contacted__c FROM Lead];
    }

    public PageReference handleSubmit
    {
        update leads;
        return null;
    }
}