DEMO SITE v1.7.31

Header SummaryNEW
1.7.28
Default 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

Add Export into CSV Print
Search

#OrderdateRequireddateShippeddateStatusCommentsCustomernumber
Actions
120.10.2003 00:00:0027.10.2003 00:00:0024.10.2003 00:00:00Shiffdfd424 View Edit Remove
221.10.2003 00:00:0030.10.2003 00:00:0023.10.2003 00:00:00ShippedQuesto ordine è stato contestato, ma risolto…452 View Edit Remove
322.10.2003 00:00:0031.10.2003 00:00:0026.12.2003 00:00:00ShippedThis order was on hold because customers's credit…148 View Edit Remove
421.10.2003 00:00:0030.10.2003 00:00:0027.10.2003 00:00:00Shipped462 View Edit Remove
523.10.2003 00:00:0030.10.2003 00:00:00CancelledCustomer called to cancel. The warehouse was…448 View Edit Remove
628.10.2003 00:00:0003.11.2003 00:00:0001.11.2003 00:00:00Shipped161 View Edit Remove
704.11.2003 00:00:0014.11.2003 00:00:0009.11.2003 00:00:00Shipped276 View Edit Remove
804.11.2003 00:00:0012.11.2003 00:00:0007.11.2003 00:00:00Shipped452 View Edit Remove
905.11.2003 00:00:0013.11.2003 00:00:0007.11.2003 00:00:00Shipped233 View Edit Remove
1005.11.2003 00:00:0014.11.2003 00:00:0011.11.2003 00:00:00Shipped175 View Edit Remove