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;
254 displayField : 'cust_name',
256 emptyText : "Select customer",
257 fieldLabel : 'cust_name',
258 forceSelection : true,
259 hiddenName : 'cust_id',
261 loadingText : "Searching...",
265 qtip : "Select Customer",
266 queryParam : 'query[cust_name]',
267 selectOnFocus : true,
268 tpl : '<div class="x-grid-cell-text x-btn button"><b>{cust_name}</b> </div>',
269 triggerAction : 'all',
271 valueField : 'cust_id',
277 beforeload : function (_self, o){
278 o.params = o.params || {};
280 if (!_this.relDate) {
283 var dt = _this.relDate.getValue();
285 o.params['_group'] = 'arAging';
286 o.params['_name'] = 'customers';
287 o.params['relDate:text'] = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');
288 o.params['useDocDate:text'] = false
292 sortInfo : { direction : 'ASC', field: 'cust_name' },
297 url : baseURL + '/Roo/metasql.php'
304 totalProperty : 'total',
305 fields : [{"name":"cust_id","type":"int"},"cust_name"]
318 render : function (_self)
\r
320 _this.relDate = _self;
\r
321 _self.setValue( new Date() );
\r
323 select : function (combo, date)
325 _this.grid.footer.onClick('first');
335 xtype: 'PagingToolbar',
338 displayMsg : "Displaying araging{0} - {1} of {2}",
339 emptyMsg : "Nothing found",
344 xtype: 'ColumnModel',
346 dataIndex : 'araging_docdate',
349 renderer : function(v) { return String.format('{0}', v); }
352 xtype: 'ColumnModel',
354 dataIndex : 'araging_cust_name',
357 renderer : function(v) { return String.format('{0}', v); }
360 xtype: 'ColumnModel',
362 dataIndex : 'araging_doctype',
365 renderer : function(v) { return String.format('{0}', v); }
368 xtype: 'ColumnModel',
370 dataIndex : 'araging_docnumber',
371 header : 'Docnumber',
373 renderer : function(v) {
378 return "Credit Memo";
382 return "Cash Receipt";
384 return String.format('{0}', v);
389 xtype: 'ColumnModel',
391 dataIndex : 'araging_ponumber_pretty',
394 renderer : function(v) { return String.format('{0}', v); }
397 xtype: 'ColumnModel',
400 dataIndex : 'araging_aropen_amount',
403 renderer : function(v) {
405 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
406 Roo.util.Format.usMoney(v));
410 xtype: 'ColumnModel',
413 dataIndex : 'araging_cur_val',
416 renderer : function(v) {
418 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
419 Roo.util.Format.usMoney(v));
423 xtype: 'ColumnModel',
426 dataIndex : 'araging_sixty_val',
429 renderer : function(v) {
431 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
432 Roo.util.Format.usMoney(v));
436 xtype: 'ColumnModel',
439 dataIndex : 'araging_ninety_val',
442 renderer : function(v) {
444 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
445 Roo.util.Format.usMoney(v));
449 xtype: 'ColumnModel',
452 dataIndex : 'araging_plus_val',
453 header : 'Over 90 days',
455 renderer : function(v) {
457 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
458 Roo.util.Format.usMoney(v));
462 xtype: 'ColumnModel',
465 dataIndex : 'araging_total_val',
468 renderer : function(v) {
470 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
471 Roo.util.Format.usMoney(v));
479 xtype: 'LayoutRegion',