Tuesday, 4 October 2016

My ajax datatable



/** ------------------------jquery datatable ----------------------------------**/

$.fn.dataTableExt.afnFiltering.push(
function( oSettings, aData, iDataIndex ) {
var iFini = document.getElementById('min').value;
var iFfin = document.getElementById('max').value;
var iStartDateCol = 7;
var iEndDateCol = 7;

iFini=iFini.substring(6,10) + iFini.substring(3,5)+ iFini.substring(0,2);
iFfin=iFfin.substring(6,10) + iFfin.substring(3,5)+ iFfin.substring(0,2);

var datofini=aData[iStartDateCol].substring(6,10) + aData[iStartDateCol].substring(3,5)+ aData[iStartDateCol].substring(0,2);
var datoffin=aData[iEndDateCol].substring(6,10) + aData[iEndDateCol].substring(3,5)+ aData[iEndDateCol].substring(0,2);

if ( iFini === "" && iFfin === "" )
{
return true;
}
else if ( iFini <= datofini && iFfin === "")
{
return true;
}
else if ( iFfin >= datoffin && iFini === "")
{
return true;
}
else if (iFini <= datofini && iFfin >= datoffin)
{
return true;
}
return false;
}
);
          $(document).ready(function () {
                $('.datepicker').datepicker({
                    format: "dd-mm-yyyy"
                });
           
            });
           
$(document).ready(function() {
    var table = $('#example').DataTable();
    var table2 = $('#example').DataTable();

        // Setup - add a text input to each footer cell
    $('#example tfoot th').each( function () {
        var title = $(this).text();
        $(this).html( '<input type="text" class="footer" placeholder="Search '+title+'" />' );
    } );
    // Apply the search
    table.columns().every( function () {
        var that = this;

        $( 'input', this.footer() ).on( 'keyup change', function () {
            if ( that.search() !== this.value ) {
                that
                    .search( this.value )
                    .draw();
            }
        } );
    } );
   

} );


/** --------- Table for builder Projects----------- **/
var TableDatatablesAjax76=function(){
var a=function(){$(".date-picker").datepicker({rtl:App.isRTL(),autoclose:!0})},e=function(){
var a=new Datatable;
a.init({src:$("#datatable_ajax76"),onSuccess:function(a,e){},onError:function(a){},
onDataLoad:function(a){},loadingMessage:"Loading...",
dataTable:{bStateSave:!0,lengthMenu:[[10,20,50,100,150,-1],[10,20,50,100,150,"All"]],buttons: [
                { extend: 'print', className: 'btn dark btn-outline' },              
                { extend: 'pdf', className: 'btn green btn-outline' },
                { extend: 'excel', className: 'btn yellow btn-outline ' },
                { extend: 'csv', className: 'btn purple btn-outline ' },
            ],"dom": "<<B>><<>r><t><'row'<'col-md-5 col-sm-12'i><p>>",pageLength:10,
ajax:{url:"https://static.t2hdev.com/kontrollit/search/regstatus"},order:[[1,"asc"]]}}),
a.getTableWrapper().on("click",".table-group-action-submit",function(e){e.preventDefault();
var t=$(".table-group-action-input",a.getTableWrapper());""!=t.val()&&a.getSelectedRowsCount()>0?(a.setAjaxParam("customActionType","group_action"),a.setAjaxParam("customActionName",t.val()),
a.setAjaxParam("id",a.getSelectedRows()),a.getDataTable().ajax.reload(),
a.clearAjaxParams()):""==t.val()?App.alert({type:"danger",icon:"warning",
message:"Please select an action",

container:a.getTableWrapper(),
place:"prepend"}):0===a.getSelectedRowsCount()&&App.alert({type:"danger",
icon:"warning",
message:"No record selected",
container:a.getTableWrapper(),place:"prepend"})})};
return{init:function(){a(),e()}}}();
jQuery(document).ready(function(){TableDatatablesAjax76.init()});





var TableDatatablesAjax77=function(){
var a=function(){$(".date-picker").datepicker({rtl:App.isRTL(),autoclose:!0})},e=function(){
var a=new Datatable;
a.init({src:$("#datatable_ajax77"),onSuccess:function(a,e){},onError:function(a){},
onDataLoad:function(a){},loadingMessage:"Loading...",
dataTable:{bStateSave:!0,lengthMenu:[[10,20,50,100,150,-1],[10,20,50,100,150,"All"]],pageLength:10,

ajax:{url:"https://static.t2hdev.com/kontrollit/search/regstatus"},order:[[1,"asc"]]}}),
a.getTableWrapper().on("click",".table-group-action-submit",function(e){e.preventDefault();
var t=$(".table-group-action-input",a.getTableWrapper());""!=t.val()&&a.getSelectedRowsCount()>0?(a.setAjaxParam("customActionType","group_action"),a.setAjaxParam("customActionName",t.val()),
a.setAjaxParam("id",a.getSelectedRows()),a.getDataTable().ajax.reload(),
a.clearAjaxParams()):""==t.val()?App.alert({type:"danger",icon:"warning",
message:"Please select an action",
container:a.getTableWrapper(),
place:"prepend"}):0===a.getSelectedRowsCount()&&App.alert({type:"danger",
icon:"warning",
message:"No record selected",
container:a.getTableWrapper(),place:"prepend"})})};
return{init:function(){a(),e()}}}();
jQuery(document).ready(function(){TableDatatablesAjax77.init()});
















No comments:

Post a Comment