I need to iterate through each child row in a datatable.
For example, if I have AJAX data structured like this:
"data": [
{
"date" : "1/17/2016",
"supplier" : "supplier1",
"total" : "$10",
"payment" : "Cash",
"product" : Array[2]
0: "product1"
1: "product2"
"price" : Array[2]
0: "$5"
1: "$5"
},
{
"date" : "2/1/2016",
"supplier" : "supplier2",
"total" : "$3",
"payment" : "Cash",
"product" : Array[1]
0: "product1"
"price" : Array[1]
0: "$3"
},
{
"date" : "1/17/2016",
"supplier" : "supplier3",
"total" : "$15",
"payment" : "Cash",
"product" : Array[3]
0: "product1"
1: "product2"
2: "product3"
"price" : Array[2]
0: "$3"
1: "$5"
2: "$7"
},
I want to create a child row in the datatable for the product & price arrays. You can see an example of what I'm aiming for in the following link: here.
To customize the formatting, I only need to edit the script within the function format as follows:
function format ( d ) {
// `d` is the original data object for the row
return '<table class="table table-border table-hover">'+
'<tr>'+
'<td>Product</td>'+
'<td>Price</td>'+
'</tr>' +
'<?php
$loop = 5;
echo $loop; <-- here
for ($i=0; $i<$loop; $i++) {
echo "<tr><td>'+d.product['$i']+'</td> <td>'+d.price['$i']+'</tr>";
} ?>' +
'</table>';
}
Everything runs smoothly, and the data displays correctly, but I have to manually define the variable $loop.
I attempted to set $loop = "'+d.product.length+'", which should dynamically determine the length of the product array, but when entering the loop, it seems that $loop becomes 0 as no rows are displayed.
Additionally, when I try using
'"+d.product_.length+"' + '"+d.product_.length+"'$loop, it results in 33 when the product array count is 3. However, changing the operation to addition instead of concatenation yields a result of 0.
If anyone has a solution to this issue so I can accurately determine how many iterations my script should perform, please let me know. Your help would be greatly appreciated!