Field Formular
/Disabled Logic NEW Bootstrap theme
A field is disabled when value changes to above 1000
HIDE CODE
<?php // Get an instance of the Xcrud class $xcrud = Xcrud::get_instance(); // Set the table to work with $xcrud->table("orderdetails"); // Define which columns to display in the table // These columns will be shown in the table view $xcrud->columns("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total"); // Define which fields are available for data entry or editing // These fields will be shown in the form view for adding/editing records $xcrud->fields("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total"); // Set up a relation between the 'officeCode' field in the 'orderdetails' table // and the 'officeCode' and 'city' fields in the 'offices' table $xcrud->relation("officeCode", "offices", "officeCode", "city"); // Set up a dynamic formula for the 'total' field // When the 'onmouseout' event is triggered on the 'quantityOrdered' or 'priceEach' fields, // the 'total' field will be calculated as quantityOrdered * priceEach and rounded to one decimal place $xcrud->set_formular( "total", 'parseFloat({quantityOrdered}*{priceEach}).toFixed(1)', "onmouseout", "quantityOrdered,priceEach" ); //When total is above 1000 the field totoal become disabled $xcrud->disable_logic("total","total",">","1000"); // Render the Xcrud instance to display the table and form // This will output the HTML needed to display the table and form on the web page echo $xcrud->render(); ?>
Orderdetails
# | Ordernumber | Productcode | Orderlinenumber | Quantityordered | Priceeach | Total | |
---|---|---|---|---|---|---|---|
1 | 510101 | S24_2022 | 2 | 50 | 55.55 | 2777.5 | View Edit Remove |
2 | 10102 | S18_1342 | 2 | 390 | 95.55 | 0 | View Edit Remove |
3 | 10102 | S18_1367 | 1 | 41 | 43.13 | 0 | View Edit Remove |
4 | 10103 | S10_1949 | 11 | 26 | 214.3 | 0 | View Edit Remove |
5 | 10103 | S10_4962 | 4 | 42 | 119.67 | 0 | View Edit Remove |
6 | 10103 | S12_1666 | 8 | 40 | 121.64 | 0 | View Edit Remove |
7 | 10103 | S18_1097 | 10 | 35 | 94.5 | 0 | View Edit Remove |
8 | 10103 | S18_2432 | 2 | 22 | 58.34 | 0 | View Edit Remove |
9 | 10103 | S18_2949 | 12 | 27 | 92.19 | 0 | View Edit Remove |
10 | 10103 | S18_2957 | 14 | 35 | 61.84 | 0 | View Edit Remove |