3 "name": "Pman.Tab.XtupleApAging",
4 "parent": "Pman.Tab.XtupleAccountsTab",
6 "path": "/home/edward/gitlive/web.xtuple/Pman/Xtuple/Pman.Tab.XtupleApAging.bjs",
13 "title": "Accounts Payable",
14 "xtype": "NestedLayoutPanel",
19 "xtype": "BorderLayout",
24 "xtype": "LayoutRegion",
29 "|activate": "function() {\n _this.panel = this;\n if (_this.grid) {\n _this.grid.footer.onClick('first');\n }\n}"
35 "tableName": "apopen",
42 "|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}"
45 "autoExpandColumn": "araging_cust_name",
52 "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}"
54 "*prop": "dataSource",
64 "|url": "baseURL + '/Roo/Metasql.php'",
71 "totalProperty": "total",
72 "xtype": "JsonReader",
73 "|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]",
85 "render": "function (_self)\n{\n _this.customerSel = _self;\n}",
86 "select": "function (combo, record, index)\n{\n _this.grid.footer.onClick('first');\n}"
89 "displayField": "cust_name",
91 "emptyText": "Select customer",
92 "fieldLabel": "cust_name",
93 "forceSelection": true,
94 "hiddenName": "cust_id",
96 "loadingText": "Searching...",
100 "qtip": "Select Customer",
101 "queryParam": "cust_name:text",
102 "selectOnFocus": true,
103 "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{cust_name}</b> </div>",
104 "triggerAction": "all",
106 "valueField": "cust_id",
113 "|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"
118 "|sortInfo": "{ direction : 'ASC', field: 'cust_name' }",
124 "xtype": "HttpProxy",
125 "|url": "baseURL + '/Roo/metasql.php'",
130 "xtype": "JsonReader",
134 "totalProperty": "total",
135 "|fields": "[{\"name\":\"cust_id\",\"type\":\"int\"},\"cust_name\"]"
144 "|xns": "Roo.Toolbar"
148 "render": "function (_self)\r\n{\r\n _this.relDate = _self;\r\n _self.setValue( new Date() );\r\n}",
149 "select": "function (combo, date)\n{\n _this.grid.footer.onClick('first');\n}"
154 "xtype": "DateField",
162 "displayMsg": "Displaying araging{0} - {1} of {2}",
163 "emptyMsg": "Nothing found",
165 "xtype": "PagingToolbar",
169 "*prop": "colModel[]",
170 "dataIndex": "araging_docdate",
173 "xtype": "ColumnModel",
174 "|renderer": "function(v) { \n var d = Date.parseDate(v, 'Y-m-d');\n\n return String.format('{0}', d.format('d/M/Y')); \n}",
178 "*prop": "colModel[]",
179 "dataIndex": "araging_cust_name",
180 "header": "Customer",
182 "xtype": "ColumnModel",
183 "|renderer": "function(v) { return String.format('{0}', v); }",
187 "*prop": "colModel[]",
188 "dataIndex": "araging_doctype",
189 "header": "Doc Type",
191 "xtype": "ColumnModel",
192 "|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 }",
196 "*prop": "colModel[]",
197 "dataIndex": "araging_docnumber",
198 "header": "Docnumber",
200 "xtype": "ColumnModel",
201 "|renderer": "function(v) {\n \n return String.format('{0}', v); \n \n }",
205 "*prop": "colModel[]",
206 "dataIndex": "araging_ponumber_pretty",
209 "xtype": "ColumnModel",
210 "|renderer": "function(v) { return String.format('{0}', v); }",
214 "*prop": "colModel[]",
215 "dataIndex": "araging_curr_symbol",
216 "header": "Currency",
218 "xtype": "ColumnModel",
219 "|renderer": "function(v) {\n \n return String.format('{0}', v); \n \n }",
223 "*prop": "colModel[]",
225 "dataIndex": "araging_aropen_amount",
228 "xtype": "ColumnModel",
229 "|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 }",
233 "*prop": "colModel[]",
235 "dataIndex": "araging_cur_val",
238 "xtype": "ColumnModel",
239 "|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 }",
243 "*prop": "colModel[]",
245 "dataIndex": "araging_sixty_val",
248 "xtype": "ColumnModel",
249 "|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 }",
253 "*prop": "colModel[]",
255 "dataIndex": "araging_ninety_val",
258 "xtype": "ColumnModel",
259 "|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 }",
263 "*prop": "colModel[]",
265 "dataIndex": "araging_plus_val",
266 "header": "Over 90 days",
268 "xtype": "ColumnModel",
269 "|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 }",
273 "*prop": "colModel[]",
275 "dataIndex": "araging_total_val",
278 "xtype": "ColumnModel",
279 "|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 }",
283 "*prop": "colModel[]",
285 "dataIndex": "araging_base_total",
286 "header": "Total (BASE)",
288 "xtype": "ColumnModel",
289 "|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 }",