Nested tables Bootstrap theme
Example of table nesting
HIDE CODE
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | <?php $xcrud = Xcrud::get_instance(); $xcrud ->table( 'orders' ); $xcrud ->default_tab( 'Order info' ); $xcrud ->parsley_active(true); //Make extension mandatory $xcrud ->set_attr( 'comments' , array ( 'required' => 'required' )); $orderdetails = $xcrud ->nested_table( 'Order details' , 'orderNumber' , 'orderdetails' , 'orderNumber' ); // 2nd level $orderdetails ->columns( 'productCode,quantityOrdered,priceEach' ); $orderdetails ->fields( 'productCode,quantityOrdered,priceEach' ); $orderdetails ->default_tab( 'Detail information' ); $customers = $xcrud ->nested_table( 'Customers' , 'customerNumber' , 'customers' , 'customerNumber' ); // 2nd level 2 $customers ->columns( 'customerName,city,country' ); $products = $orderdetails ->nested_table( 'Products' , 'productCode' , 'products' , 'productCode' ); // 3rd level $products ->default_tab( 'Product details' ); $productLines = $products ->nested_table( 'Product Lines' , 'productLine' , 'productlines' , 'productLine' ); // 4th level echo $xcrud ->render(); ?> |
Orders
# | Orderdate | Requireddate | Shippeddate | Status | Comments | Customernumber | |
---|---|---|---|---|---|---|---|
1 | 20.02.2003 00:00:00 | 28.05.2003 00:00:00 | 23.04.2003 22:00:00 | Shipped | Difficult to negotiate with customer. We need… | 131 | View Edit Remove |
2 | 03.03.2003 00:00:00 | 12.03.2003 00:00:00 | 08.03.2003 00:00:00 | Shipped | 385 | View Edit Remove | |
3 | 10.03.2003 00:00:00 | 19.03.2003 00:00:00 | 11.03.2003 00:00:00 | Shipped | Customer requested that FedEx Ground is used for… | 486 | View Edit Remove |
4 | 18.03.2003 00:00:00 | 24.03.2003 00:00:00 | 20.03.2003 00:00:00 | Shipped | 187 | View Edit Remove | |
5 | 25.03.2003 00:00:00 | 31.03.2003 00:00:00 | 30.03.2003 00:00:00 | Shipped | 129 | View Edit Remove | |
6 | 24.03.2003 00:00:00 | 03.04.2003 00:00:00 | 29.03.2003 00:00:00 | Shipped | Customer requested that ad materials (such as… | 144 | View Edit Remove |
7 | 26.03.2003 00:00:00 | 02.04.2003 00:00:00 | 27.03.2003 00:00:00 | Shipped | 124 | View Edit Remove | |
8 | 01.04.2003 00:00:00 | 07.04.2003 00:00:00 | 02.04.2003 00:00:00 | Shipped | 172 | View Edit Remove | |
9 | 04.04.2003 00:00:00 | 12.04.2003 00:00:00 | 07.04.2003 00:00:00 | Shipped | 424 | View Edit Remove | |
10 | 11.04.2003 00:00:00 | 19.04.2003 00:00:00 | 13.04.2003 00:00:00 | Shipped | 381 | View Edit Remove |