$(document).ready(function () { var intervaltime = $('#intervaltime').val(); //LoadData(); var table = $('#tbl_1').DataTable({ "ajax": { method: 'POST', url: '/Home/GetDataPrevious', contentType: "application/json; charset=utf-8", dataSrc: '' }, "columnDefs": [ { className: "Title", "targets": [0] } ], "columns": [ { "data": "timeZone"} ], "filter": true, "paging": false, "info": false, "searching": false, "ordering": true, "createdRow": function (row, data, index) { var tr = $(row).closest('tr'); var thisrow = table.row(tr); let list = data.dashboarddetails; let html = '<table class="display">'; html += '<thead>'; html += '<tr>'; html += '<th style="background-color: #009879;color: #ffffff;">Branch</th>'; html += '<th style="background-color: #009879;color: #ffffff;">Total No of Orders</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># In Kitchen (Ordered)</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># with Kitchen Delay</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># Kitchen Ready</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># with window time</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># Driver Assigned</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># Delivered</th>'; html += '<th style="background-color: #009879;color: #ffffff;">Expected Delivery Time</th>'; html += '<th style="background-color: #009879;color: #ffffff;"># with Delivery Delay</th>'; html += '<th style="background-color: #009879;color: #ffffff;">Dispatcher Notifications (Updated from Dispatcher Screen)</th>'; html += '</tr>'; html += '</thead>'; html += '<tbody>'; for (let i = 0; i < list.length; i++){ html += '<tr>'; html += '<td>'; html += list[i].branch; html += '</td>'; html += '<td>'; html += list[i].totalOrders; html += '</td>'; html += '<td>'; html += list[i].ordersInKitchen; html += '</td>'; html += '<td>'; html += list[i].ordersKitchenDelay; html += '</td>'; html += '<td>'; html += list[i].ordersKitchenReady; html += '</td>'; html += '<td>'; html += list[i].ordersWaitingDelay; html += '</td>'; html += '<td>'; html += list[i].ordersAssigned; html += '</td>'; html += '<td>'; html += list[i].ordersDelivered; html += '</td>'; html += '<td>'; html += list[i].expectedDeliveryTime; html += '</td>'; html += '<td>'; html += list[i].ordersDeliveryDelay; html += '</td>'; html += '<td>'; html += list[i].memo; html += '</td>'; html += '</tr>'; } html += '</tbody>'; html += '</table>'; thisrow.child(html).show(); tr.addClass('shown'); } }); var intervalsec = intervaltime * 1000; setInterval(function () { table.ajax.reload(); }, intervalsec); });
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter