"parent": "Pman.Tab.XtupleAccountsTab",
"title": "",
"path": "/home/edward/gitlive/web.xtuple/Pman/Xtuple/Pman.Tab.XtupleApAging.bjs",
- "items": [],
+ "items": [
+ {
+ "background": true,
+ "fitContainer": true,
+ "fitToFrame": true,
+ "region": "center",
+ "title": "Accounts Recievable",
+ "xtype": "NestedLayoutPanel",
+ "|xns": "Roo",
+ "items": [
+ {
+ "|xns": "Roo",
+ "xtype": "BorderLayout",
+ "*prop": "layout",
+ "items": [
+ {
+ "*prop": "center",
+ "xtype": "LayoutRegion",
+ "|xns": "Roo"
+ },
+ {
+ "listeners": {
+ "|activate": "function() {\n _this.panel = this;\n if (_this.grid) {\n _this.grid.footer.onClick('first');\n }\n}"
+ },
+ "background": true,
+ "fitContainer": true,
+ "fitToframe": true,
+ "region": "center",
+ "tableName": "aropen",
+ "title": "ArAging",
+ "xtype": "GridPanel",
+ "|xns": "Roo",
+ "items": [
+ {
+ "listeners": {
+ "|render": "function() \n{\n _this.grid = this; \n //_this.dialog = Pman.Dialog.FILL_IN\n if (_this.panel.active) {\n this.footer.onClick('first');\n }\n}"
+ },
+ "*prop": "grid",
+ "autoExpandColumn": "araging_cust_name",
+ "loadMask": true,
+ "xtype": "Grid",
+ "|xns": "Roo.grid",
+ "items": [
+ {
+ "listeners": {
+ "beforeload": "function (_self, o)\n{\n o.params = o.params || {};\n \n\n \n var dt = _this.relDate.getValue();\n \n var params = {\n _group : 'arAging',\n _name : 'bydate',\n 'relDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n 'useDocDate:text' : false\n };\n \n var cs = _this.customerSel.getValue();\n if (cs*1) {\n params['cust_id:number'] = cs;\n \n }\n \n \n Roo.apply(o.params,params);\n}"
+ },
+ "*prop": "dataSource",
+ "remoteSort": true,
+ "xtype": "Store",
+ "|xns": "Roo.data",
+ "items": [
+ {
+ "*prop": "proxy",
+ "method": "GET",
+ "timeout": 600000,
+ "xtype": "HttpProxy",
+ "|url": "baseURL + '/Roo/Metasql.php'",
+ "|xns": "Roo.data"
+ },
+ {
+ "*prop": "reader",
+ "id": "id",
+ "root": "data",
+ "totalProperty": "total",
+ "xtype": "JsonReader",
+ "|fields": "[\n {\n 'name': 'id',\n 'type': 'int'\n },\n {\n 'name': 'name',\n 'type': 'string'\n },\n {\n 'name': 'type',\n 'type': 'int'\n },\n {\n 'name': 'leader',\n 'type': 'int'\n },\n {\n 'name': 'leader_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_office_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_name',\n 'type': 'string'\n },\n {\n 'name': 'leader_phone',\n 'type': 'string'\n },\n {\n 'name': 'leader_fax',\n 'type': 'string'\n },\n {\n 'name': 'leader_email',\n 'type': 'string'\n },\n {\n 'name': 'leader_company_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_role',\n 'type': 'string'\n },\n {\n 'name': 'leader_active',\n 'type': 'int'\n },\n {\n 'name': 'leader_remarks',\n 'type': 'string'\n },\n {\n 'name': 'leader_passwd',\n 'type': 'string'\n },\n {\n 'name': 'leader_owner_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_lang',\n 'type': 'string'\n },\n {\n 'name': 'leader_no_reset_sent',\n 'type': 'int'\n },\n {\n 'name': 'leader_action_type',\n 'type': 'string'\n },\n {\n 'name': 'leader_project_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_deleted_by',\n 'type': 'int'\n },\n {\n 'name': 'leader_deleted_dt',\n 'type': 'date'\n },\n {\n 'name': 'leader_firstname',\n 'type': 'string'\n },\n {\n 'name': 'leader_lastname',\n 'type': 'string'\n },\n {\n 'name': 'leader_name_facebook',\n 'type': 'string'\n },\n {\n 'name': 'leader_url_blog',\n 'type': 'string'\n },\n {\n 'name': 'leader_url_twitter',\n 'type': 'string'\n },\n {\n 'name': 'leader_url_linkedin',\n 'type': 'string'\n },\n {\n 'name': 'leader_crm_lead_percentage',\n 'type': 'int'\n },\n {\n 'name': 'leader_crm_industry_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_crm_updated_action_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_crm_created_action_id',\n 'type': 'int'\n },\n {\n 'name': 'leader_crm_type_id',\n 'type': 'int'\n }\n]",
+ "|xns": "Roo.data"
+ }
+ ]
+ },
+ {
+ "|xns": "Roo",
+ "xtype": "Toolbar",
+ "*prop": "toolbar",
+ "items": [
+ {
+ "listeners": {
+ "render": "function (_self)\n{\n _this.customerSel = _self;\n}",
+ "select": "function (combo, record, index)\n{\n _this.grid.footer.onClick('first');\n}"
+ },
+ "allowBlank": true,
+ "displayField": "cust_name",
+ "editable": true,
+ "emptyText": "Select customer",
+ "fieldLabel": "cust_name",
+ "forceSelection": true,
+ "hiddenName": "cust_id",
+ "listWidth": 400,
+ "loadingText": "Searching...",
+ "minChars": 2,
+ "name": "cust_name",
+ "pageSize": 20,
+ "qtip": "Select Customer",
+ "queryParam": "cust_name:text",
+ "selectOnFocus": true,
+ "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{cust_name}</b> </div>",
+ "triggerAction": "all",
+ "typeAhead": true,
+ "valueField": "cust_id",
+ "width": 300,
+ "xtype": "ComboBox",
+ "|xns": "Roo.form",
+ "items": [
+ {
+ "listeners": {
+ "|beforeload": "function (_self, o){\n o.params = o.params || {};\n\n if (!_this.relDate) {\n return false;\n }\n var dt = _this.relDate.getValue(); \n // set more here\n o.params['_group'] = 'arAging';\n o.params['_name'] = 'customers';\n o.params['relDate:text'] = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');\n o.params['useDocDate:text'] = false \n}\n"
+ },
+ "*prop": "store",
+ "remoteSort": true,
+ "xtype": "Store",
+ "|sortInfo": "{ direction : 'ASC', field: 'cust_name' }",
+ "|xns": "Roo.data",
+ "items": [
+ {
+ "*prop": "proxy",
+ "method": "GET",
+ "xtype": "HttpProxy",
+ "|url": "baseURL + '/Roo/metasql.php'",
+ "|xns": "Roo.data"
+ },
+ {
+ "*prop": "reader",
+ "xtype": "JsonReader",
+ "|xns": "Roo.data",
+ "id": "cust_id",
+ "root": "data",
+ "totalProperty": "total",
+ "|fields": "[{\"name\":\"cust_id\",\"type\":\"int\"},\"cust_name\"]"
+ }
+ ]
+ }
+ ]
+ },
+ {
+ "text": "as Of:",
+ "xtype": "TextItem",
+ "|xns": "Roo.Toolbar"
+ },
+ {
+ "listeners": {
+ "render": "function (_self)\r\n{\r\n _this.relDate = _self;\r\n _self.setValue( new Date() );\r\n}",
+ "select": "function (combo, date)\n{\n _this.grid.footer.onClick('first');\n}"
+ },
+ "allowBlank": false,
+ "format": "Y-m-d",
+ "width": 100,
+ "xtype": "DateField",
+ "|xns": "Roo.form"
+ }
+ ]
+ },
+ {
+ "*prop": "footer",
+ "displayInfo": true,
+ "displayMsg": "Displaying araging{0} - {1} of {2}",
+ "emptyMsg": "Nothing found",
+ "pageSize": 25,
+ "xtype": "PagingToolbar",
+ "|xns": "Roo"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_docdate",
+ "header": "Date",
+ "width": 100,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n var d = Date.parseDate(v, 'Y-m-d');\n\n return String.format('{0}', d.format('d/M/Y')); \n}",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_cust_name",
+ "header": "Customer",
+ "width": 200,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_doctype",
+ "header": "Doc Type",
+ "width": 120,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) {\n switch(v) {\n case 'I':\n return \"Invoice\";\n case 'C':\n return \"Credit Memo\"; \n case 'D':\n return \"Debit Memo\"; \n case 'R':\n return \"Cash Receipt\"; \n default:\n return String.format('{0}', v); \n }\n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_docnumber",
+ "header": "Docnumber",
+ "width": 120,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) {\n \n return String.format('{0}', v); \n \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_ponumber_pretty",
+ "header": "Order",
+ "width": 150,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "dataIndex": "araging_curr_symbol",
+ "header": "Currency",
+ "width": 120,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) {\n \n return String.format('{0}', v); \n \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_aropen_amount",
+ "header": "Value",
+ "width": 100,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_cur_val",
+ "header": "30 Days",
+ "width": 100,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_sixty_val",
+ "header": "60 Days",
+ "width": 100,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_ninety_val",
+ "header": "90 Days",
+ "width": 100,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_plus_val",
+ "header": "Over 90 days",
+ "width": 150,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_total_val",
+ "header": "Total",
+ "width": 150,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ },
+ {
+ "*prop": "colModel[]",
+ "align": "right",
+ "dataIndex": "araging_base_total",
+ "header": "Total (BASE)",
+ "width": 150,
+ "xtype": "ColumnModel",
+ "|renderer": "function(v) { \n\n return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n Roo.util.Format.usMoney(v)); \n }",
+ "|xns": "Roo.grid"
+ }
+ ]
+ }
+ ]
+ }
+ ]
+ }
+ ]
+ }
+ ],
"permname": "",
"modOrder": "400"
}
\ No newline at end of file
-0
\ No newline at end of file
+//<script type="text/javascript">
+
+// Auto generated file - created by app.Builder.js- do not edit directly (at present!)
+
+Pman.Tab.XtupleApAging = new Roo.XComponent({
+ part : ["Xtuple","ApAging"],
+ order : '400-Pman.Tab.XtupleApAging',
+ region : 'center',
+ parent : 'Pman.Tab.XtupleAccountsTab',
+ name : "unnamed module",
+ disabled : false,
+ permname : '',
+ _tree : function()
+ {
+ var _this = this;
+ var MODULE = this;
+ return {
+ xtype: 'NestedLayoutPanel',
+ xns: Roo,
+ background : true,
+ fitContainer : true,
+ fitToFrame : true,
+ region : 'center',
+ title : "Accounts Recievable",
+ layout : {
+ xtype: 'BorderLayout',
+ xns: Roo,
+ items : [
+ {
+ xtype: 'GridPanel',
+ xns: Roo,
+ listeners : {
+ activate : function() {
+ _this.panel = this;
+ if (_this.grid) {
+ _this.grid.footer.onClick('first');
+ }
+ }
+ },
+ background : true,
+ fitContainer : true,
+ fitToframe : true,
+ region : 'center',
+ tableName : 'aropen',
+ title : "ArAging",
+ grid : {
+ xtype: 'Grid',
+ xns: Roo.grid,
+ listeners : {
+ render : function()
+ {
+ _this.grid = this;
+ //_this.dialog = Pman.Dialog.FILL_IN
+ if (_this.panel.active) {
+ this.footer.onClick('first');
+ }
+ }
+ },
+ autoExpandColumn : 'araging_cust_name',
+ loadMask : true,
+ dataSource : {
+ xtype: 'Store',
+ xns: Roo.data,
+ listeners : {
+ beforeload : function (_self, o)
+ {
+ o.params = o.params || {};
+
+
+
+ var dt = _this.relDate.getValue();
+
+ var params = {
+ _group : 'arAging',
+ _name : 'bydate',
+ 'relDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),
+ 'useDocDate:text' : false
+ };
+
+ var cs = _this.customerSel.getValue();
+ if (cs*1) {
+ params['cust_id:number'] = cs;
+
+ }
+
+
+ Roo.apply(o.params,params);
+ }
+ },
+ remoteSort : true,
+ proxy : {
+ xtype: 'HttpProxy',
+ xns: Roo.data,
+ method : 'GET',
+ timeout : 600000,
+ url : baseURL + '/Roo/Metasql.php'
+ },
+ reader : {
+ xtype: 'JsonReader',
+ xns: Roo.data,
+ id : 'id',
+ root : 'data',
+ totalProperty : 'total',
+ fields : [
+ {
+ 'name': 'id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'name',
+ 'type': 'string'
+ },
+ {
+ 'name': 'type',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_office_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_name',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_phone',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_fax',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_email',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_company_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_role',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_active',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_remarks',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_passwd',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_owner_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_lang',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_no_reset_sent',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_action_type',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_project_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_deleted_by',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_deleted_dt',
+ 'type': 'date'
+ },
+ {
+ 'name': 'leader_firstname',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_lastname',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_name_facebook',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_url_blog',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_url_twitter',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_url_linkedin',
+ 'type': 'string'
+ },
+ {
+ 'name': 'leader_crm_lead_percentage',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_crm_industry_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_crm_updated_action_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_crm_created_action_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'leader_crm_type_id',
+ 'type': 'int'
+ }
+ ]
+ }
+ },
+ toolbar : {
+ xtype: 'Toolbar',
+ xns: Roo,
+ items : [
+ {
+ xtype: 'ComboBox',
+ xns: Roo.form,
+ listeners : {
+ render : function (_self)
+ {
+ _this.customerSel = _self;
+ },
+ select : function (combo, record, index)
+ {
+ _this.grid.footer.onClick('first');
+ }
+ },
+ allowBlank : true,
+ displayField : 'cust_name',
+ editable : true,
+ emptyText : "Select customer",
+ fieldLabel : 'cust_name',
+ forceSelection : true,
+ hiddenName : 'cust_id',
+ listWidth : 400,
+ loadingText : "Searching...",
+ minChars : 2,
+ name : 'cust_name',
+ pageSize : 20,
+ qtip : "Select Customer",
+ queryParam : 'cust_name:text',
+ selectOnFocus : true,
+ tpl : '<div class="x-grid-cell-text x-btn button"><b>{cust_name}</b> </div>',
+ triggerAction : 'all',
+ typeAhead : true,
+ valueField : 'cust_id',
+ width : 300,
+ store : {
+ xtype: 'Store',
+ xns: Roo.data,
+ listeners : {
+ beforeload : function (_self, o){
+ o.params = o.params || {};
+
+ if (!_this.relDate) {
+ return false;
+ }
+ var dt = _this.relDate.getValue();
+ // set more here
+ o.params['_group'] = 'arAging';
+ o.params['_name'] = 'customers';
+ o.params['relDate:text'] = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');
+ o.params['useDocDate:text'] = false
+ }
+ },
+ remoteSort : true,
+ sortInfo : { direction : 'ASC', field: 'cust_name' },
+ proxy : {
+ xtype: 'HttpProxy',
+ xns: Roo.data,
+ method : 'GET',
+ url : baseURL + '/Roo/metasql.php'
+ },
+ reader : {
+ xtype: 'JsonReader',
+ xns: Roo.data,
+ id : 'cust_id',
+ root : 'data',
+ totalProperty : 'total',
+ fields : [{"name":"cust_id","type":"int"},"cust_name"]
+ }
+ }
+ },
+ {
+ xtype: 'TextItem',
+ xns: Roo.Toolbar,
+ text : "as Of:"
+ },
+ {
+ xtype: 'DateField',
+ xns: Roo.form,
+ listeners : {
+ render : function (_self)\r
+ {\r
+ _this.relDate = _self;\r
+ _self.setValue( new Date() );\r
+ },
+ select : function (combo, date)
+ {
+ _this.grid.footer.onClick('first');
+ }
+ },
+ allowBlank : false,
+ format : 'Y-m-d',
+ width : 100
+ }
+ ]
+ },
+ footer : {
+ xtype: 'PagingToolbar',
+ xns: Roo,
+ displayInfo : true,
+ displayMsg : "Displaying araging{0} - {1} of {2}",
+ emptyMsg : "Nothing found",
+ pageSize : 25
+ },
+ colModel : [
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_docdate',
+ header : 'Date',
+ width : 100,
+ renderer : function(v) {
+ var d = Date.parseDate(v, 'Y-m-d');
+
+ return String.format('{0}', d.format('d/M/Y'));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_cust_name',
+ header : 'Customer',
+ width : 200,
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_doctype',
+ header : 'Doc Type',
+ width : 120,
+ renderer : function(v) {
+ switch(v) {
+ case 'I':
+ return "Invoice";
+ case 'C':
+ return "Credit Memo";
+ case 'D':
+ return "Debit Memo";
+ case 'R':
+ return "Cash Receipt";
+ default:
+ return String.format('{0}', v);
+ }
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_docnumber',
+ header : 'Docnumber',
+ width : 120,
+ renderer : function(v) {
+
+ return String.format('{0}', v);
+
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_ponumber_pretty',
+ header : 'Order',
+ width : 150,
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ dataIndex : 'araging_curr_symbol',
+ header : 'Currency',
+ width : 120,
+ renderer : function(v) {
+
+ return String.format('{0}', v);
+
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_aropen_amount',
+ header : 'Value',
+ width : 100,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_cur_val',
+ header : '30 Days',
+ width : 100,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_sixty_val',
+ header : '60 Days',
+ width : 100,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_ninety_val',
+ header : '90 Days',
+ width : 100,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_plus_val',
+ header : 'Over 90 days',
+ width : 150,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_total_val',
+ header : 'Total',
+ width : 150,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ align : 'right',
+ dataIndex : 'araging_base_total',
+ header : 'Total (BASE)',
+ width : 150,
+ renderer : function(v) {
+
+ return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
+ Roo.util.Format.usMoney(v));
+ }
+ }
+ ]
+ }
+ }
+ ],
+ center : {
+ xtype: 'LayoutRegion',
+ xns: Roo
+ }
+ }
+ };
+ }
+});
projects / Pman.Xtuple / commitdiff