DEMO SITE v1.7.28

Nested tables Bootstrap 4.5 theme

Example of table nesting

HIDE CODE
<?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

Add
#OrderdateRequireddateShippeddateStatusCommentsCustomernumber
Actions
101.07.2003 00:00:0010.07.2003 00:00:0005.07.2003 00:00:00ShippedNULL250 View Edit Remove
202.07.2003 00:00:0012.07.2003 00:00:0003.07.2003 00:00:00ShippedNULL124 View Edit Remove
304.07.2003 00:00:0014.07.2003 00:00:0006.07.2003 00:00:00ShippedCustomer is interested in buying more Ferrari…242 View Edit Remove
407.07.2003 00:00:0016.07.2003 00:00:0013.07.2003 00:00:00Shipped496 View Edit Remove
516.07.2003 00:00:0023.07.2003 00:00:0021.07.2003 00:00:00Shipped282 View Edit Remove
624.07.2003 00:00:0002.08.2003 00:00:0030.07.2003 00:00:00Shipped161 View Edit Remove
701.08.2003 00:00:0009.08.2003 00:00:0004.08.2003 00:00:00Shipped334 View Edit Remove
808.08.2003 00:00:0016.08.2003 00:00:0013.08.2003 00:00:00Shipped124 View Edit Remove
910.08.2003 00:00:0018.08.2003 00:00:0012.08.2003 00:00:00ShippedCan we deliver the new Ford Mustang models by…320 View Edit Remove
1013.08.2003 00:00:0021.08.2003 00:00:0014.08.2003 00:00:00Shipped381 View Edit Remove
showing_records 1 to 10 of 332
Search
 
slot thailand
slot thailand slot gacor
slot gacor