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',
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) {
354 var d = Date.parseDate(v, 'Y-m-d');
356 return String.format('{0}', v.format('d/M/Y'));
360 xtype: 'ColumnModel',
362 dataIndex : 'araging_cust_name',
365 renderer : function(v) { return String.format('{0}', v); }
368 xtype: 'ColumnModel',
370 dataIndex : 'araging_doctype',
373 renderer : function(v) {
378 return "Credit Memo";
382 return "Cash Receipt";
384 return String.format('{0}', v);
389 xtype: 'ColumnModel',
391 dataIndex : 'araging_docnumber',
392 header : 'Docnumber',
394 renderer : function(v) {
396 return String.format('{0}', v);
401 xtype: 'ColumnModel',
403 dataIndex : 'araging_ponumber_pretty',
406 renderer : function(v) { return String.format('{0}', v); }
409 xtype: 'ColumnModel',
412 dataIndex : 'araging_aropen_amount',
415 renderer : function(v) {
417 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
418 Roo.util.Format.usMoney(v));
422 xtype: 'ColumnModel',
425 dataIndex : 'araging_cur_val',
428 renderer : function(v) {
430 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
431 Roo.util.Format.usMoney(v));
435 xtype: 'ColumnModel',
438 dataIndex : 'araging_sixty_val',
441 renderer : function(v) {
443 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
444 Roo.util.Format.usMoney(v));
448 xtype: 'ColumnModel',
451 dataIndex : 'araging_ninety_val',
454 renderer : function(v) {
456 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
457 Roo.util.Format.usMoney(v));
461 xtype: 'ColumnModel',
464 dataIndex : 'araging_plus_val',
465 header : 'Over 90 days',
467 renderer : function(v) {
469 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
470 Roo.util.Format.usMoney(v));
474 xtype: 'ColumnModel',
477 dataIndex : 'araging_total_val',
480 renderer : function(v) {
482 return String.format(v*1 < 0 ? '<span style="color:red">{0}</span>' : '{0}',
483 Roo.util.Format.usMoney(v));
491 xtype: 'LayoutRegion',