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_docnumber',
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',
126 'name': 'leader_office_id',
130 'name': 'leader_name',
134 'name': 'leader_phone',
138 'name': 'leader_fax',
142 'name': 'leader_email',
146 'name': 'leader_company_id',
150 'name': 'leader_role',
154 'name': 'leader_active',
158 'name': 'leader_remarks',
162 'name': 'leader_passwd',
166 'name': 'leader_owner_id',
170 'name': 'leader_lang',
174 'name': 'leader_no_reset_sent',
178 'name': 'leader_action_type',
182 'name': 'leader_project_id',
186 'name': 'leader_deleted_by',
190 'name': 'leader_deleted_dt',
194 'name': 'leader_firstname',
198 'name': 'leader_lastname',
202 'name': 'leader_name_facebook',
206 'name': 'leader_url_blog',
210 'name': 'leader_url_twitter',
214 'name': 'leader_url_linkedin',
218 'name': 'leader_crm_lead_percentage',
222 'name': 'leader_crm_industry_id',
226 'name': 'leader_crm_updated_action_id',
230 'name': 'leader_crm_created_action_id',
234 'name': 'leader_crm_type_id',
248 render : function (_self)
250 _this.customerSel = _self;
252 select : function (combo, record, index)
254 _this.grid.footer.onClick('first');
258 displayField : 'cust_name',
260 emptyText : "Select customer",
261 fieldLabel : 'cust_name',
262 forceSelection : true,
263 hiddenName : 'cust_id',
265 loadingText : "Searching...",
269 qtip : "Select Customer",
270 queryParam : 'query[cust_name]',
271 selectOnFocus : true,
272 tpl : '<div class="x-grid-cell-text x-btn button"><b>{cust_name}</b> </div>',
273 triggerAction : 'all',
275 valueField : 'cust_id',
281 beforeload : function (_self, o){
282 o.params = o.params || {};
284 if (!_this.relDate) {
287 var dt = _this.relDate.getValue();
289 o.params['_group'] = 'arAging';
290 o.params['_name'] = 'customers';
291 o.params['relDate:text'] = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');
292 o.params['useDocDate:text'] = false
296 sortInfo : { direction : 'ASC', field: 'cust_name' },
301 url : baseURL + '/Roo/metasql.php'
308 totalProperty : 'total',
309 fields : [{"name":"cust_id","type":"int"},"cust_name"]
322 render : function (_self)
\r
324 _this.relDate = _self;
\r
325 _self.setValue( new Date() );
\r
327 select : function (combo, date)
329 _this.grid.footer.onClick('first');
339 xtype: 'PagingToolbar',
342 displayMsg : "Displaying araging{0} - {1} of {2}",
343 emptyMsg : "Nothing found",
348 xtype: 'ColumnModel',
350 dataIndex : 'araging_docdate',
353 renderer : function(v) { return String.format('{0}', v); }
356 xtype: 'ColumnModel',
358 dataIndex : 'araging_cust_name',
361 renderer : function(v) { return String.format('{0}', v); }
364 xtype: 'ColumnModel',
366 dataIndex : 'araging_doctype',
369 renderer : function(v) {
374 return "Credit Memo";
378 return "Cash Receipt";
380 return String.format('{0}', v);
385 xtype: 'ColumnModel',
387 dataIndex : 'araging_docnumber',
388 header : 'Docnumber',
390 renderer : function(v) {
392 return String.format('{0}', v);
397 xtype: 'ColumnModel',
399 dataIndex : 'araging_ponumber_pretty',
402 renderer : function(v) { return String.format('{0}', v); }
405 xtype: 'ColumnModel',
408 dataIndex : 'araging_aropen_amount',
411 renderer : function(v) {
413 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
414 Roo.util.Format.usMoney(v));
418 xtype: 'ColumnModel',
421 dataIndex : 'araging_cur_val',
424 renderer : function(v) {
426 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
427 Roo.util.Format.usMoney(v));
431 xtype: 'ColumnModel',
434 dataIndex : 'araging_sixty_val',
437 renderer : function(v) {
439 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
440 Roo.util.Format.usMoney(v));
444 xtype: 'ColumnModel',
447 dataIndex : 'araging_ninety_val',
450 renderer : function(v) {
452 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
453 Roo.util.Format.usMoney(v));
457 xtype: 'ColumnModel',
460 dataIndex : 'araging_plus_val',
461 header : 'Over 90 days',
463 renderer : function(v) {
465 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
466 Roo.util.Format.usMoney(v));
470 xtype: 'ColumnModel',
473 dataIndex : 'araging_total_val',
476 renderer : function(v) {
478 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
479 Roo.util.Format.usMoney(v));
487 xtype: 'LayoutRegion',