Field Formula Apply formula for fields before insert/update operation (added in version 2.5)

You can apply basic formula to change value of the field before insert/update operation dynamically. It can be done using the callback function also but this function is added to provide more convenient way to do same. It also helps to set the value to NULL for empty values to help to enter data in case of database restriction for e.g. saving NULL for datetime for empty values.

  
                                    $pdocrud = new PDOCrud();
                                     // format field to 2 decimal point
                                    $pdocrud->fieldFormula("tax", "formula",array("type" =>"round","decimalpoint"=>2));
                                    // format field to 2 decimal point
                                    $pdocrud->fieldFormula("product_discount", "formula",array("type" =>"number_format","decimalpoint"=>2));
                                    // get ceil value of field
                                    $pdocrud->fieldFormula("product_price", "formula",array("type" =>"ceil"));
                                    //get floor value of field
                                    $pdocrud->fieldFormula("product_sell_price", "formula",array("type" =>"floor"));
                                    //string type - adding prefix of sku always and checking for duplicate i.e. string already have sku or not
                                    $pdocrud->fieldFormula("product_id","string",array("type" =>"prefix","str"=>"SKU_","duplicate"=>true));
                                    //make product name first letter upper case
                                    $pdocrud->fieldFormula("product_name", "string",array("type" =>"uppercase"));
                                    //setting value to NULL if empty
                                    $pdocrud->fieldFormula("added_Date", "string",array("type" =>"null"));
                                     
                                    echo $pdocrud->dbTable("products")->render();
                            

Formula based field content formatting

Products

Showing 1 to 10 of 98 entries

# Product id Product name Product line ProductScale ProductVendor Product description Product image Product url Qty available Product price Product sell price Tax Product discount Added date Product cat Actions
1 66 0 0.00 0.00 0 0 0000-00-00 Electronics
2 90000 Doesnt matter Dumbass 1 Wankers laksjdlkasj /lkajdlskajs.com wankers.com/myproduct 2 20.00 2.00 5 0 2023-05-11 wakers
3 90001 https://pdocrud.com/script/uploads/1684574573_maiale.jpeg 0 0.00 0.00 0 0 0000-00-00 Electronics
4 azdzd https://pdocrud.com/script/uploads/1682007520_Screen Shot 04-17-23 at 05.22 PM.PNG 0 0.00 0.00 0 0 0000-00-00 Electronics
5 ed https://pdocrud.com/script/uploads/1685140617_1684825694495.jfif 0 0.00 0.00 0 0 0000-00-00 Electronics
6 RE RE RE RE RE RE RE RE 12 0.00 0.00 233 232 2023-04-27 RERE
7 S12_2823 2002 Suzuki XREO Motorcycles 1:12 Unimax Art Galleries Official logos and insignias, saddle bags located on side of motorcycle, detailed engine, working steering, working suspension, two leather seats, luggage rack, dual exhaust pipes, small saddle bag located on handle bars, two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand, diecast metal with plastic parts and baked enamel finish. http://displays2go.com.au/slir/w144-h144/images/product_images/1392609013.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 9997 66.27 150.62 2 2 2016-12-20 Electronics
8 S12_3148 1969 Corvair Monza Classic Cars 1:18 Welly Diecast Productions 1:18 scale die-cast about 10" long doors open, hood opens, trunk opens and wheels roll http://displays2go.com.au/images/product_images/1392665476.gif https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 6906 89.14 151.08 0 0 2016-12-20 Electronics
9 S12_4473 1957 Chevy Pickup Trucks and Buses 1:12 Exoto Designs 1:12 scale die-cast about 20" long Hood opens, Rubber wheels http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 6125 55.70 118.50 0 0 2016-12-20 Fashion
10 S18_1342 1937 Lincoln Berline Vintage Cars 1:18 Motor City Art Classics Features opening engine cover, doors, trunk, and fuel filler cap. Color black http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 8693 60.62 102.74 0 0 2016-12-20 Electronics
# Product id Product name Product line ProductScale ProductVendor Product description Product image Product url Qty available Product price Product sell price Tax Product discount Added date Product cat Actions