1 //<script type="text/javascript">
3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
5 Pman.Tab.XtupleArAging = new Roo.XComponent({
6 part : ["Xtuple","ArAging"],
7 order : '300-Pman.Tab.XtupleArAging',
9 parent : 'Pman.Tab.XtupleAccountsTab',
10 name : "unnamed module",
18 xtype: 'NestedLayoutPanel',
24 title : "Accounts Recievable",
26 xtype: 'BorderLayout',
33 activate : function() {
36 _this.grid.footer.onClick('first');
53 //_this.dialog = Pman.Dialog.FILL_IN
54 if (_this.panel.active) {
55 this.footer.onClick('first');
59 autoExpandColumn : 'araging_cust_name',
65 beforeload : function (_self, o)
67 o.params = o.params || {};
71 var dt = _this.relDate.getValue();
76 'relDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),
77 'useDocDate:text' : false
80 var cs = _this.customerSel.getValue();
82 params['cust_id:number'] = cs;
87 Roo.apply(o.params,params);
96 url : baseURL + '/Roo/Metasql.php'
103 totalProperty : 'total',
106 'name': 'araging_apopen_id',
110 'name': 'araging_cust_id',
124 render : function (_self)
126 _this.customerSel = _self;
128 select : function (combo, record, index)
130 _this.grid.footer.onClick('first');
134 displayField : 'cust_name',
136 emptyText : "Select customer",
137 fieldLabel : 'cust_name',
138 forceSelection : true,
139 hiddenName : 'cust_id',
141 loadingText : "Searching...",
145 qtip : "Select Customer",
146 queryParam : 'cust_name:text',
147 selectOnFocus : true,
148 tpl : '<div class="x-grid-cell-text x-btn button"><b>{cust_name}</b> </div>',
149 triggerAction : 'all',
151 valueField : 'cust_id',
157 beforeload : function (_self, o){
158 o.params = o.params || {};
160 if (!_this.relDate) {
163 var dt = _this.relDate.getValue();
165 o.params['_group'] = 'arAging';
166 o.params['_name'] = 'customers';
167 o.params['relDate:text'] = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');
168 o.params['useDocDate:text'] = false
172 sortInfo : { direction : 'ASC', field: 'cust_name' },
177 url : baseURL + '/Roo/metasql.php'
184 totalProperty : 'total',
185 fields : [{"name":"cust_id","type":"int"},"cust_name"]
198 render : function (_self)
\r
200 _this.relDate = _self;
\r
201 _self.setValue( new Date() );
\r
203 select : function (combo, date)
205 _this.grid.footer.onClick('first');
215 xtype: 'PagingToolbar',
218 displayMsg : "Displaying araging{0} - {1} of {2}",
219 emptyMsg : "Nothing found",
224 xtype: 'ColumnModel',
226 dataIndex : 'araging_docdate',
229 renderer : function(v) {
230 var d = Date.parseDate(v, 'Y-m-d');
232 return String.format('{0}', d.format('d/M/Y'));
236 xtype: 'ColumnModel',
238 dataIndex : 'araging_cust_name',
241 renderer : function(v) { return String.format('{0}', v); }
244 xtype: 'ColumnModel',
246 dataIndex : 'araging_doctype',
249 renderer : function(v) {
254 return "Credit Memo";
258 return "Cash Receipt";
262 return String.format('{0}', v);
267 xtype: 'ColumnModel',
269 dataIndex : 'araging_docnumber',
270 header : 'Docnumber',
272 renderer : function(v) {
274 return String.format('{0}', v);
279 xtype: 'ColumnModel',
281 dataIndex : 'araging_ponumber_pretty',
284 renderer : function(v) { return String.format('{0}', v); }
287 xtype: 'ColumnModel',
289 dataIndex : 'araging_curr_symbol',
292 renderer : function(v) {
294 return String.format('{0}', v);
299 xtype: 'ColumnModel',
302 dataIndex : 'araging_aropen_amount',
305 renderer : function(v) {
307 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
308 Roo.util.Format.usMoney(v));
312 xtype: 'ColumnModel',
315 dataIndex : 'araging_cur_val',
318 renderer : function(v) {
320 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
321 Roo.util.Format.usMoney(v));
325 xtype: 'ColumnModel',
328 dataIndex : 'araging_sixty_val',
331 renderer : function(v) {
333 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
334 Roo.util.Format.usMoney(v));
338 xtype: 'ColumnModel',
341 dataIndex : 'araging_ninety_val',
344 renderer : function(v) {
346 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
347 Roo.util.Format.usMoney(v));
351 xtype: 'ColumnModel',
354 dataIndex : 'araging_plus_val',
355 header : 'Over 90 days',
357 renderer : function(v) {
359 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
360 Roo.util.Format.usMoney(v));
364 xtype: 'ColumnModel',
367 dataIndex : 'araging_total_val',
370 renderer : function(v) {
372 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
373 Roo.util.Format.usMoney(v));
377 xtype: 'ColumnModel',
380 dataIndex : 'araging_base_total',
381 header : 'Total (BASE)',
383 renderer : function(v) {
385 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
386 Roo.util.Format.usMoney(v));
394 xtype: 'LayoutRegion',