使用jQuery数据表构建主从网格

问题描述

我现在使用jQuery数据表作为网格，我想显示主要详细信息(订单-订单详细信息)取决于主ID(用于创建明细表的ajax调用)我发现的一切 https://datatables.net/examples/api/row_details.html 这是静态字符串我的要求可以吗?

i'm using jQuery datatable as grid now i want to display master details(orders - order details)depending on master ID (ajax call to create the detail table)all i foundhttps://datatables.net/examples/api/row_details.htmlwhich is static stringis my request possible ?

谢谢

推荐答案

您可以在呈现扩展行信息之前执行ajax请求.

You can do ajax request before render extended row info.

创建一个接受行信息和回调的函数，该函数将呈现扩展的行信息.

Create a function that accept row info and callback which will render extended row info.

在函数内部执行ajax回调，并在成功调用后对格式化数据进行渲染回调.

Inside a function do ajax callback and on success call render callback with formatted data.

基于示例链接代码的代码示例:

Code example base on example link code:

/* Formatting function for row details - modify as you need */
function format ( d ) {
    // `d` is the original data object for the row
    return '<table cellpadding="5" cellspacing="0" border="0" style="padding-left:50px;">'+
        '<tr>'+
            '<td>Full name:</td>'+
            '<td>'+d.name+'</td>'+
        '</tr>'+
        '<tr>'+
            '<td>Extension number:</td>'+
            '<td>'+d.extn+'</td>'+
        '</tr>'+
        '<tr>'+
            '<td>Extra info:</td>'+
            '<td>And any further details here (images etc)...</td>'+
        '</tr>'+
    '</table>';
}

function loadAjaxInfo(data, callback) {
    $.ajax({
      ...
      data: {/*Put your request needle here*/},
      ...
      success: function(response){
        callback(format(response));
      }
    })
}

$(document).ready(function() {
    var table = $('#example').DataTable( {
        "ajax": "../ajax/data/objects.txt",
        "columns": [
            {
                "className":      'details-control',
                "orderable":      false,
                "data":           null,
                "defaultContent": ''
            },
            { "data": "name" },
            { "data": "position" },
            { "data": "office" },
            { "data": "salary" }
        ],
        "order": [[1, 'asc']]
    } );

    // Add event listener for opening and closing details
    $('#example tbody').on('click', 'td.details-control', function () {
        var tr = $(this).closest('tr');
        var row = table.row( tr );

        if ( row.child.isShown() ) {
            // This row is already open - close it
            row.child.hide();
            tr.removeClass('shown');
        }
        else {
          loadAjaxInfo(row.data(), function(formattedContent){
            // Open this row
            row.child(formattedContent).show();
            tr.addClass('shown');
          });
        }
    } );
} );

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

这篇关于使用jQuery数据表构建主从网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！