Pman.Tab.XtupleReports.bjs
[Pman.Xtuple] / Pman.Tab.XtupleReports.js
1 //<script type="text/javascript">
2
3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
4
5 Pman.Tab.XtupleReports = new Roo.XComponent({
6     part     :  ["Xtuple","Reports"],
7     order    : '500-Pman.Tab.XtupleReports',
8     region   : 'center',
9     parent   : 'Pman.Tab.Admin',
10     name     : "unnamed module",
11     disabled : false, 
12     permname : '', 
13     _tree : function()
14     {
15         var _this = this;
16         var MODULE = this;
17         return {
18             xtype: 'NestedLayoutPanel',
19             xns: Roo,
20             title : "Reports",
21             layout : {
22                 xtype: 'BorderLayout',
23                 xns: Roo,
24                 items : [
25                     {
26                         xtype: 'GridPanel',
27                         xns: Roo,
28                         title : "report",
29                         fitToframe : true,
30                         fitContainer : true,
31                         tableName : 'report',
32                         background : true,
33                         region : 'center',
34                         listeners : {
35                             activate : function() {
36                                 _this.panel = this;
37                                 if (_this.grid) {
38                                     _this.grid.footer.onClick('first');
39                                 }
40                             }
41                         },
42                         grid : {
43                             xtype: 'Grid',
44                             xns: Roo.grid,
45                             listeners : {
46                                 render : function() 
47                                 {
48                                     _this.grid = this; 
49                                     //_this.dialog = Pman.Dialog.FILL_IN
50                                     if (_this.panel.active) {
51                                        this.footer.onClick('first');
52                                     }
53                                 },
54                                 rowdblclick : function (_self, rowIndex, e)
55                                 {
56                                     var rec = this.ds.getAt(rowIndex);
57                                     new Pman.Download({
58                                         url : baseURL + '/Roo/Report/' + rec.data.report_name +'-' + rec.data.report_id + '.rpt',
59                                         method : 'GET',
60                                         params : {
61                                             _id : rec.data.report_id,
62                                             _download : 1
63                                         }
64                                     });
65                                     Roo.MessageBox.alert("Downloading",
66                                     
67                                        "Report template is downloading - use " +
68                                            '<a href="http://sourceforge.net/projects/openrpt/files/openrpt/">' + 
69                                            "report writer to edit this" + 
70                                            '</a>'
71                                        );
72                                            
73                                     
74                                     
75                                 }
76                             },
77                             autoExpandColumn : 'report_descrip',
78                             loadMask : true,
79                             dataSource : {
80                                 xtype: 'Store',
81                                 xns: Roo.data,
82                                 listeners : {
83                                     beforeload : function (_self, options)
84                                     {
85                                         options.params['search[name]'] = _this.searchName.getValue();
86                                         options.params._max_versions = 1;
87                                     }
88                                 },
89                                 remoteSort : true,
90                                 sortInfo : { field : 'report_name', direction: 'ASC' },
91                                 proxy : {
92                                     xtype: 'HttpProxy',
93                                     xns: Roo.data,
94                                     method : 'GET',
95                                     url : baseURL + '/Roo/report.php'
96                                 },
97                                 reader : {
98                                     xtype: 'JsonReader',
99                                     xns: Roo.data,
100                                     totalProperty : 'total',
101                                     root : 'data',
102                                     id : 'id',
103                                     fields : [
104                                         {
105                                             'name': 'report_id',
106                                             'type': 'int'
107                                         },
108                                         {
109                                             'name': 'report_name',
110                                             'type': 'string'
111                                         },
112                                         {
113                                             'name': 'report_sys',
114                                             'type': 'int'
115                                         },
116                                         {
117                                             'name': 'report_source',
118                                             'type': 'string'
119                                         },
120                                         {
121                                             'name': 'report_descrip',
122                                             'type': 'string'
123                                         },
124                                         {
125                                             'name': 'report_grade',
126                                             'type': 'int'
127                                         },
128                                         {
129                                             'name': 'report_loaddate',
130                                             'type': 'date',
131                                             'dateFormat': 'Y-m-d'
132                                         }
133                                     ]
134                                 }
135                             },
136                             sm : {
137                                 xtype: 'RowSelectionModel',
138                                 xns: Roo.grid,
139                                 listeners : {
140                                     afterselectionchange : function (_self)
141                                     {
142                                         _this.vgrid.footer.onClick('first');
143                                     }
144                                 },
145                                 singleSelect : true
146                             },
147                             footer : {
148                                 xtype: 'PagingToolbar',
149                                 xns: Roo,
150                                 pageSize : 25,
151                                 displayInfo : true,
152                                 displayMsg : "Displaying report{0} - {1} of {2}",
153                                 emptyMsg : "No report found"
154                             },
155                             toolbar : {
156                                 xtype: 'Toolbar',
157                                 xns: Roo,
158                                 items : [
159                                     {
160                                         xtype: 'TextField',
161                                         xns: Roo.form,
162                                         listeners : {
163                                             render : function (_self)
164                                             {
165                                                 _this.searchName = _self;
166                                             },
167                                             specialkey : function (_self, e)
168                                             {
169                                                 _this.grid.footer.onClick('first');
170                                             }
171                                         }
172                                     },
173                                     {
174                                         xtype: 'Button',
175                                         xns: Roo.Toolbar,
176                                         listeners : {
177                                             click : function (_self, e)
178                                             {
179                                             _this.grid.footer.onClick('first');
180                                             }
181                                         },
182                                         cls : 'x-btn-icon',
183                                         icon : rootURL + '/Pman/templates/images/search.gif'
184                                     },
185                                     {
186                                         xtype: 'Button',
187                                         xns: Roo.Toolbar,
188                                         listeners : {
189                                             click : function (_self, e)
190                                             {
191                                                 _this.searchBox.setValue('');
192                                                 _this.publication_name_combo.setValue('');
193                                                 _this.publication_lang_combo.setValue('');
194                                                 _this.country_combo.setValue('');
195                                                 _this.category_media_id_combo.setValue('');
196                                                 _this.role_combo.setValue('');      
197                                             
198                                                 
199                                                 _this.grid.footer.onClick('first');
200                                             }
201                                         },
202                                         cls : 'x-btn-icon',
203                                         icon : rootURL + '/Pman/templates/images/edit-clear.gif'
204                                     },
205                                     {
206                                         xtype: 'Fill',
207                                         xns: Roo.Toolbar
208                                     }
209                                 ]
210                             },
211                             colModel : [
212                                 {
213                                     xtype: 'ColumnModel',
214                                     xns: Roo.grid,
215                                     header : 'Report name',
216                                     width : 200,
217                                     dataIndex : 'report_name',
218                                     renderer : function(v) { return String.format('{0}', v); }
219                                 },
220                                 {
221                                     xtype: 'ColumnModel',
222                                     xns: Roo.grid,
223                                     header : 'Report descrip',
224                                     width : 200,
225                                     dataIndex : 'report_descrip',
226                                     renderer : function(v) { return String.format('{0}', v); }
227                                 }
228                             ]
229                         }
230                     },
231                     {
232                         xtype: 'GridPanel',
233                         xns: Roo,
234                         listeners : {
235                             activate : function() {
236                                 _this.vpanel = this;
237                                 if (_this.vgrid) {
238                                     _this.vgrid.footer.onClick('first');
239                                 }
240                             }
241                         },
242                         background : false,
243                         fitContainer : true,
244                         fitToframe : true,
245                         region : 'east',
246                         tableName : 'report',
247                         title : "report",
248                         grid : {
249                             xtype: 'Grid',
250                             xns: Roo.grid,
251                             listeners : {
252                                 render : function() 
253                                 {
254                                     _this.vgrid = this; 
255                                     //_this.dialog = Pman.Dialog.FILL_IN
256                                     if (_this.vpanel.active) {
257                                        this.footer.onClick('first');
258                                     }
259                                 },
260                                 rowdblclick : function (_self, rowIndex, e)
261                                 {
262                                     if (!_this.dialog) return;
263                                     _this.dialog.show( this.getDataSource().getAt(rowIndex).data, function() {
264                                         _this.grid.footer.onClick('first');
265                                     }); 
266                                 }
267                             },
268                             autoExpandColumn : 'report_name',
269                             loadMask : true,
270                             dataSource : {
271                                 xtype: 'Store',
272                                 xns: Roo.data,
273                                 listeners : {
274                                     beforeload : function (_self, options)
275                                     {
276                                         if (!_this.grid) {
277                                             return false;
278                                         } 
279                                         var sel  = _this.grid.selModel.getSelected()
280                                         if (!sel) {
281                                             this.removeAll();
282                                             return false;
283                                         }
284                                         options.params.report_name = sel.data.report_name;
285                                         
286                                         
287                                     }
288                                 },
289                                 remoteSort : true,
290                                 sortInfo : { field : 'report_grade', direction: 'DESC' },
291                                 proxy : {
292                                     xtype: 'HttpProxy',
293                                     xns: Roo.data,
294                                     method : 'GET',
295                                     url : baseURL + '/Roo/report.php'
296                                 },
297                                 reader : {
298                                     xtype: 'JsonReader',
299                                     xns: Roo.data,
300                                     totalProperty : 'total',
301                                     root : 'data',
302                                     id : 'id',
303                                     fields : [
304                                         {
305                                             'name': 'report_id',
306                                             'type': 'int'
307                                         },
308                                         {
309                                             'name': 'report_name',
310                                             'type': 'string'
311                                         },
312                                         {
313                                             'name': 'report_sys',
314                                             'type': 'int'
315                                         },
316                                         {
317                                             'name': 'report_source',
318                                             'type': 'string'
319                                         },
320                                         {
321                                             'name': 'report_descrip',
322                                             'type': 'string'
323                                         },
324                                         {
325                                             'name': 'report_grade',
326                                             'type': 'int'
327                                         },
328                                         {
329                                             'name': 'report_loaddate',
330                                             'type': 'date',
331                                             'dateFormat': 'Y-m-d'
332                                         }
333                                     ]
334                                 }
335                             },
336                             footer : {
337                                 xtype: 'PagingToolbar',
338                                 xns: Roo,
339                                 pageSize : 25,
340                                 displayInfo : true,
341                                 displayMsg : "Displaying report{0} - {1} of {2}",
342                                 emptyMsg : "No report found"
343                             },
344                             colModel : [
345                                 {
346                                     xtype: 'ColumnModel',
347                                     xns: Roo.grid,
348                                     header : 'Report grade',
349                                     width : 75,
350                                     dataIndex : 'report_grade',
351                                     renderer : function(v) { return String.format('{0}', v); }
352                                 },
353                                 {
354                                     xtype: 'ColumnModel',
355                                     xns: Roo.grid,
356                                     header : 'Report loaddate',
357                                     width : 75,
358                                     dataIndex : 'report_loaddate',
359                                     renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
360                                 }
361                             ]
362                         }
363                     }
364                 ],
365                 center : {
366                     xtype: 'LayoutRegion',
367                     xns: Roo
368                 },
369                 east : {
370                     xtype: 'LayoutRegion',
371                     xns: Roo,
372                     split : true,
373                     title : "Versions",
374                     titlebar : true,
375                     width : 200
376                 }
377             }
378         };
379     }
380 });