Created
August 27, 2025 15:28
-
-
Save gridphp/2e1628aeb7a2ca744076e4867e85a73f to your computer and use it in GitHub Desktop.
Custom number formatter showing 0.00 to blank, Line 31-32 and 56-78
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * PHP Grid Component | |
| * | |
| * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org | |
| * @version 2.0.0 | |
| * @license: see license.txt included in package | |
| */ | |
| include_once("../../config.php"); | |
| include(PHPGRID_LIBPATH."inc/jqgrid_dist.php"); | |
| // Database config file to be passed in phpgrid constructor | |
| $db_conf = array( | |
| "type" => PHPGRID_DBTYPE, | |
| "server" => PHPGRID_DBHOST, | |
| "user" => PHPGRID_DBUSER, | |
| "password" => PHPGRID_DBPASS, | |
| "database" => PHPGRID_DBNAME | |
| ); | |
| $g = new jqgrid($db_conf); | |
| $opt["caption"] = "Sample Grid"; | |
| $g->set_options($opt); | |
| $g->table = "city"; | |
| $cols = array(); | |
| $col = array(); | |
| $col["name"] = "state_id"; | |
| $col["formatter"] = "function(cellval,options,rowdata){ return format_custom_number(cellval); }"; | |
| $col["unformat"] = "function(cellval,options,cell){ return unformat_custom_number(cellval); }"; | |
| $cols[] = $col; | |
| $g->set_columns($cols,true); | |
| $out = $g->render("list1"); | |
| ?> | |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> | |
| <html> | |
| <head> | |
| <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link> | |
| <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link> | |
| <script src="../../lib/js/jquery.min.js" type="text/javascript"></script> | |
| <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script> | |
| <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script> | |
| <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script> | |
| </head> | |
| <body> | |
| <div> | |
| <?php echo $out?> | |
| </div> | |
| <script> | |
| function format_custom_number(n) | |
| { | |
| if (n == 0) return ''; | |
| n = parseInt(n).toFixed(2) + ''; | |
| x = n.split('.'); | |
| x1 = x[0]; | |
| x2 = x.length > 1 ? '.' + x[1] : ''; | |
| var rgx = /(\d+)(\d{3})/; | |
| while (rgx.test(x1)) { | |
| x1 = x1.replace(rgx, '$1' + ',' + '$2'); | |
| } | |
| return x1 + x2; | |
| } | |
| function unformat_custom_number(n) | |
| { | |
| return n.replace(",","").replace(".00",""); | |
| } | |
| </script> | |
| </body> | |
| </html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment