Formula based Formatting of CRUD table column Format crud table column using formula

You can format table column using various formula functions. For example you can make any table column content to uppercase, first letter uppercase, lowercase or you can add prefix, suffix etc.

  
                               $pdocrud = new PDOCrud();
                                // format field to 2 decimal point
                               $pdocrud->tableColFormatting("tax", "formula",array("type" =>"round","decimalpoint"=>2));
                               // format field to 2 decimal point
                               $pdocrud->tableColFormatting("product_discount", "formula",array("type" =>"number_format","decimalpoint"=>2));
                               // get ceil value of field
                               $pdocrud->tableColFormatting("product_price", "formula",array("type" =>"ceil"));
                               //get floor value of field
                               $pdocrud->tableColFormatting("product_sell_price", "formula",array("type" =>"floor"));

                               $pdocrud->crudTableCol(array("product_name", "product_price","product_sell_price","tax","product_discount"));
                               echo $pdocrud->dbTable("products")->render();
                            

Formula based table content formatting

Products

Showing 1 to 10 of 105 entries

# Product name Product price Product sell price Tax Product discount Actions
1 2003 Harley-Davidson Eagle Drag Bike 92 193 0 0.00
2 1962 LanciaA Delta 16V 104 147 0 0.00
3 1968 Ford Mustang 96 194 0 0.00
4 2001 Ferrari Enzo 96 207 0 0.00
5 1958 Setra Bus 78 136 0 0.00
6 2002 Suzuki XREO 67 150 0 0.00
7 1969 Corvair Monza 90 151 0 0.00
8 1968 Dodge Charger 76 117 0 0.00
9 1969 Ford Falcon 84 173 0 0.00
10 1970 Plymouth Hemi Cuda 32 79 0 0.00
# Product name Product price Product sell price Tax Product discount Actions