{ "name" : "Pman.Tab.XtupleReconcile", "parent" : "Pman.Tab.XtupleAccountsTab", "title" : "Pman.Tab.XtupleReconcile", "path" : "/home/alan/gitlive/Pman.Xtuple/Pman.Tab.XtupleReconcile.bjs", "permname" : "", "modOrder" : "200", "items" : [ { "background" : true, "title" : "Bank Reconcile", "xtype" : "NestedLayoutPanel", "$ xns" : "Roo", "items" : [ { "xtype" : "BorderLayout", "$ xns" : "Roo", "* prop" : "layout", "items" : [ { "xtype" : "LayoutRegion", "$ xns" : "Roo", "* prop" : "center" }, { "xtype" : "LayoutRegion", "$ xns" : "Roo", "width" : 400, "split" : true, "* prop" : "west" }, { "listeners" : { "|activate" : "function() {\n _this.panel = this;\n if (_this.grid) {\n _this.grid.footer.onClick('first');\n }\n}" }, "region" : "center", "fitToframe" : true, "background" : true, "title" : "Bank Reconcile", "xtype" : "GridPanel", "fitContainer" : true, "$ xns" : "Roo", "tableName" : "metasql", "items" : [ { "listeners" : { "beforeedit" : "function (e)\n{\n // Roo.log(e);\n var ch = _this.grid.colModel.config[e.column].header;\n var val = e.value *1;\n // Roo.log(ch);\n // Roo.log(val);\n\n if (val > 0.0 && ch == 'Debit') {\n e.cancel = true;\n return;\n }\n if (val < 0.0 && ch == 'Credit') {\n e.cancel = true;\n return;\n }\n if (e.record.data.cleared || e.record.data.bankrec_posted) {\n e.cancel = true;\n return;\n }\n \n // allow start editing..\n}", "cellclick" : "function (_self, rowIndex, columnIndex, e)\n{\n var clear = function(ar) \n {\n var ar_in = ar;\n if (ar === true) {\n ar = [];\n \n _this.grid.ds.each(function(rec) {\n if (rec.data.doc_type == 'BF') {\n return;\n }\n ar.push(rec);\n });\n }\n var sortdate = false;\n var data = [];\n Roo.each(ar, function(rec) {\n if (rec.data.cleared || rec.data.bankrec_posted) {\n return;\n }\n if(!sortdate){\n sortdate = rec.data.sortdate;\n }\n data.push({\n id : rec.data.id,\n altid : rec.data.altid,\n curr_rate : rec.data.doc_exchrate,\n amount : rec.data.amount\n \n });\n });\n new Pman.Request({\n url : baseURL + '/Roo/bankrecitem',\n method : 'POST',\n mask : 'Clearing',\n params : {\n bankaccnt_id : _this.bankacct.getValue(),\n sortdate : sortdate,\n set_clear : Roo.encode(data)\n },\n success : function() {\n Roo.each(ar, function(rec) {\n rec.set('cleared', true);\n });\n if (ar_in === true) {\n _this.grid.ds.getAt(0).set('cleared', true);\n }\n _this.wgrid.footer.onClick('refresh');\n }\n });\n }\n \n \n var unclear = function(ar)\n {\n var ar_in = ar;\n if (ar === true) {\n ar = [];\n \n _this.grid.ds.each(function(rec) {\n if (rec.data.doc_type == 'BF') {\n return;\n }\n ar.push(rec);\n });\n }\n var sortdate = false;\n var data = [];\n Roo.each(ar, function(rec) {\n if (!rec.data.cleared || rec.data.bankrec_posted) {\n return;\n }\n if(!sortdate){\n sortdate = rec.data.sortdate;\n }\n data.push({\n id : rec.data.id,\n altid : rec.data.altid \n });\n });\n\n new Pman.Request({\n url : baseURL + '/Roo/bankrecitem',\n method : 'POST',\n mask : 'Clearing',\n params : {\n bankaccnt_id : _this.bankacct.getValue(),\n sortdate : sortdate,\n remove_clear :Roo.encode(data)\n \n },\n success : function() {\n Roo.each(ar, function(rec) {\n rec.set('cleared', false);\n });\n if (ar_in === true) {\n _this.grid.ds.getAt(0).set('cleared', false);\n } \n _this.wgrid.footer.onClick('refresh');\n }\n });\n \n \n };\n \n \n \n var di = this.colModel.config[columnIndex].dataIndex;\n if (di != 'cleared') {\n return;\n }\n var rec = this.ds.getAt(rowIndex);\n if (rec.data.doc_type == 'BF') {\n \n if (rec.data.cleared) {\n unclear(true);\n \n } else {\n clear(true);\n }\n \n return;\n }\n \n \n \n if (rec.data.cleared) {\n \n unclear([rec]);\n return;\n \n }\n \n clear([rec]);\n \n \n \n \n \n}", "|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}", "afteredit" : "function (e)\n{\n\n if (e.cancel) {\n return;\n }\n var ch = _this.grid.colModel.config[e.column].header;\n var val = e.originalValue *1;\n // Roo.log(ch);\n // Roo.log(val);\n\n if (val > 0.0 && ch == 'Debit') {\n e.cancel = true;\n return;\n }\n if (val < 0.0 && ch == 'Credit') {\n e.cancel = true;\n return;\n }\n if (e.record.data.cleared || e.record.data.bankrec_posted) {\n e.cancel = true;\n return;\n }\n if (val > 0.0 && e.value < 0.0) {\n Roo.log(\"CANCEL\"); \n e.record.set('amount', e.originalValue);\n e.cancel = true;\n return;\n }\n if (val < 0.0 && e.value > 0.0) {\n Roo.log(\"CANCEL\");\n e.record.set('amount', e.originalValue);\n e.cancel = true;\n return;\n } \n if (e.originalValue*1 == e.value*1) {\n return;\n }\n \n e.record.set('doc_exchrate', Math.abs(e.value * 1) / Math.abs(e.record.data.base_amount * 1));\n Roo.log(e.record);\n \n _this.grid.ds.updateBalance();\n // send it down the line...\n new Pman.Request({\n method : 'POST',\n url : baseURL + '/Roo/bankrecitem',\n mask : 'Saving',\n params : {\n bankaccnt_id : _this.bankacct.getValue(),\n set_amount : Math.abs(e.value),\n sortdate : e.record.data.sortdate,\n source_id : e.record.data.id,\n altid : e.record.data.altid\n }\n \n });\n \n \n \n \n}" }, "autoExpandColumn" : "notes", "xtype" : "EditorGrid", "loadMask" : true, "clicksToEdit" : 1, "$ xns" : "Roo.grid", "* prop" : "grid", "items" : [ { "listeners" : { "beforeloadadd" : "function (_self, records, options, res)\n{\n // _this.total = 0.0;\n\n \n\n\n _this.total = 1 * res.raw.amount;\n _this.bf = 1 * res.raw.amount;\n Roo.log(\"TOTAL:\" + _this.total);\n}\n", "beforeload" : "function (_self, o)\n{\n var s = _this.wgrid.getSelectionModel().getSelected();\n \n if (!s) {\n return false;\n }\n o.params._group = 'bankrec';\n o.params._name = 'all';\n o.params['sortdate:text'] = s.data.sortdate;\n o.params['bankaccntid:number'] = _this.bankacct.getValue();\n\n o.params['_cals'] = 'amount'\n}", "load" : "function (_self, records, options)\n{\n \n var bal = _this.bf;\n var cleared = true;\n var posted = true;\n Roo.each(records, function(rec) {\n if (!rec.data.cleared) {\n cleared = false;\n\n }\n if (!rec.data.bankrec_posted) {\n posted = false;\n }\n if (rec.data.doc_type != 'BF') {\n bal += rec.data.amount *1;\n rec.set('balance', bal); \n } else {\n rec.set('balance', _this.bf);\n }\n \n \n });\n \n var rec = this.reader.newRow({\n notes : 'Brought Forward',\n balance : _this.bf,\n doc_type : 'BF',\n cleared : cleared,\n bankrec_posted : posted\n });\n this.insert(0, [rec]);\n}" }, "xtype" : "Store", "remoteSort" : true, "$ sortInfo" : "{ field : 'metasql_group', direction: 'ASC' }", "$ xns" : "Roo.data", "$ updateBalance" : "function() {\n var bal = _this.bf;\n this.each( function(rec) {\n if (rec.data.doc_type != 'BF') {\n bal += rec.data.amount *1;\n rec.set('balance', bal); \n } else {\n rec.set('balance', _this.bf);\n }\n \n \n });\n}\n", "* prop" : "dataSource", "items" : [ { "$ url" : "baseURL + '/Roo/metasql.php'", "method" : "GET", "xtype" : "HttpProxy", "$ xns" : "Roo.data", "* prop" : "proxy" }, { "id" : "idx", "root" : "data", "xtype" : "JsonReader", "$ fields" : "[\n {\n 'name': 'metasql_id',\n 'type': 'int'\n },\n {\n 'name': 'metasql_group',\n 'type': 'string'\n },\n {\n 'name': 'metasql_name',\n 'type': 'string'\n },\n {\n 'name': 'metasql_notes',\n 'type': 'string'\n },\n {\n 'name': 'metasql_query',\n 'type': 'string'\n },\n {\n 'name': 'metasql_lastuser',\n 'type': 'string'\n },\n {\n 'name': 'metasql_lastupdate',\n 'type': 'date',\n 'dateFormat': 'Y-m-d'\n },\n {\n 'name': 'metasql_grade',\n 'type': 'int'\n }\n]", "$ xns" : "Roo.data", "* prop" : "reader", "totalProperty" : "total" } ] }, { "pageSize" : 50, "xtype" : "PagingToolbar", "emptyMsg" : "Nothing found", "$ xns" : "Roo", "displayMsg" : "Displaying records {0} - {1} of {2}", "displayInfo" : true, "* prop" : "footer" }, { "xtype" : "Toolbar", "$ xns" : "Roo", "* prop" : "toolbar", "items" : [ { "listeners" : { "render" : "function (_self)\n{\n _this.bankacct = _self;\n}", "select" : "function (combo, record, index)\n{ \n var curr = record.data.bankaccnt_curr_id_curr_abbr;\n var col = _this.grid.colModel.config.length -1;\n \n _this.grid.colModel.setColumnHeader(col, 'Balance (' + curr +')');\n \n _this.grid.ds.removeAll();\n \n _this.wgrid.footer.onClick('first');\n}" }, "listWidth" : 400, "triggerAction" : "all", "fieldLabel" : "bankaccnt", "forceSelection" : true, "selectOnFocus" : true, "pageSize" : 50, "displayField" : "bankaccnt_name", "emptyText" : "Select bankaccnt", "hiddenName" : "bankaccnt_id", "minChars" : 2, "valueField" : "bankaccnt_id", "xtype" : "ComboBox", "allowBlank" : false, "typeAhead" : true, "editable" : false, "width" : 300, "$ xns" : "Roo.form", "name" : "bankaccnt_name", "qtip" : "Select bankaccnt", "queryParam" : "", "tpl" : "