Header SummaryNEW
1.7.28 Bootstrap 4.5 theme
Create a custom header as you navigate through multiple tabs highlighting main table details
HIDE CODE
<?php $xcrud = Xcrud::get_instance(); $xcrud->table('orders'); $xcrud->default_tab('Order info'); $xcrud->title_columns("<span style='border: 1px solid #e5e5e5; padding: 5px; display: block; margin-bottom: 6px;'><b> Order Number: {orderNumber}</b><br><b> Customer Number: {customerNumber}</b></span>"); $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'); $orderdetails->order_by("productCode","asc"); //$orderdetails->limit(1000); $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(); ?> <script> $('.xcrud-tabs .menu .item').tab('change tab','tab1.php'); </script>
Orders
# | Orderdate | Requireddate | Shippeddate | Status | Comments | Customernumber | |
---|---|---|---|---|---|---|---|
1 | 27.06.2003 00:00:00 | 04.07.2003 00:00:00 | 03.07.2003 00:00:00 | Shipped | NULL | 141 | View Edit Remove |
2 | 01.07.2003 00:00:00 | 10.07.2003 00:00:00 | 05.07.2003 00:00:00 | Shipped | 250 | View Edit Remove | |
3 | 02.07.2003 00:00:00 | 12.07.2003 00:00:00 | 03.07.2003 00:00:00 | Shipped | NULL | 124 | View Edit Remove |
4 | 04.07.2003 00:00:00 | 14.07.2003 00:00:00 | 06.07.2003 00:00:00 | Shipped | Customer is interested in buying more Ferrari | 242 | View Edit Remove |
5 | 10.07.2003 00:00:00 | 20.07.2003 00:00:00 | 15.05.2024 00:00:00 | Shipped | PROVA | 353 | View Edit Remove |
6 | 07.07.2003 00:00:00 | 16.07.2003 00:00:00 | 13.07.2003 00:00:00 | Shipped | 496 | View Edit Remove | |
7 | 16.07.2003 00:00:00 | 23.07.2003 00:00:00 | 21.07.2003 00:00:00 | Shipped | 282 | View Edit Remove | |
8 | 24.07.2003 00:00:00 | 02.08.2003 00:00:00 | 30.07.2003 00:00:00 | Shipped | 161 | View Edit Remove | |
9 | 01.08.2003 00:00:00 | 09.08.2003 00:00:00 | 04.08.2003 00:00:00 | Shipped | 334 | View Edit Remove | |
10 | 08.08.2003 00:00:00 | 16.08.2003 00:00:00 | 13.08.2003 00:00:00 | Shipped | 124 | View Edit Remove |