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                                         xtype: 'Button',
211                                         xns: Roo.Toolbar,
212                                         listeners : {
213                                             click : function (_self, e)
214                                             {
215                                                 
216                                                 var sel = _this.grid.selModel.getSelected();
217                                                 if (!sel) {
218                                                     Roo.MessageBox.alert("Error", "Select a report");
219                                                     return;
220                                                 }
221                                                 
222                                                 Pman.Dialog.Image.show(
223                                                    {
224                                                         _url : baseURL+'/Xtuple/Report',
225                                                         params  : {
226                                                             on_id : sel.data.report_id
227                                                         }
228                                                         
229                                                    },
230                                                    function (data) {
231                                                         Roo.MessageBox.alert("Notice", "Updated");
232                                                         _this.grid.footer.onClick('refresh');
233                                                    }
234                                                );
235                                             }
236                                         },
237                                         text : "Upload New version"
238                                     }
239                                 ]
240                             },
241                             colModel : [
242                                 {
243                                     xtype: 'ColumnModel',
244                                     xns: Roo.grid,
245                                     header : 'Report name',
246                                     width : 200,
247                                     dataIndex : 'report_name',
248                                     renderer : function(v) { return String.format('{0}', v); }
249                                 },
250                                 {
251                                     xtype: 'ColumnModel',
252                                     xns: Roo.grid,
253                                     header : 'Report descrip',
254                                     width : 200,
255                                     dataIndex : 'report_descrip',
256                                     renderer : function(v) { return String.format('{0}', v); }
257                                 }
258                             ]
259                         }
260                     },
261                     {
262                         xtype: 'GridPanel',
263                         xns: Roo,
264                         listeners : {
265                             activate : function() {
266                                 _this.vpanel = this;
267                                 if (_this.vgrid) {
268                                     _this.vgrid.footer.onClick('first');
269                                 }
270                             }
271                         },
272                         background : false,
273                         fitContainer : true,
274                         fitToframe : true,
275                         region : 'east',
276                         tableName : 'report',
277                         title : "report",
278                         grid : {
279                             xtype: 'Grid',
280                             xns: Roo.grid,
281                             listeners : {
282                                 render : function() 
283                                 {
284                                     _this.vgrid = this; 
285                                     //_this.dialog = Pman.Dialog.FILL_IN
286                                     if (_this.vpanel.active) {
287                                        this.footer.onClick('first');
288                                     }
289                                 },
290                                 rowdblclick : function (_self, rowIndex, e)
291                                 {
292                                     if (!_this.dialog) return;
293                                     _this.dialog.show( this.getDataSource().getAt(rowIndex).data, function() {
294                                         _this.grid.footer.onClick('first');
295                                     }); 
296                                 }
297                             },
298                             autoExpandColumn : 'report_name',
299                             loadMask : true,
300                             dataSource : {
301                                 xtype: 'Store',
302                                 xns: Roo.data,
303                                 listeners : {
304                                     beforeload : function (_self, options)
305                                     {
306                                         if (!_this.grid) {
307                                             return false;
308                                         } 
309                                         var sel  = _this.grid.selModel.getSelected()
310                                         if (!sel) {
311                                             this.removeAll();
312                                             return false;
313                                         }
314                                         options.params.report_name = sel.data.report_name;
315                                         
316                                         
317                                     }
318                                 },
319                                 remoteSort : true,
320                                 sortInfo : { field : 'report_grade', direction: 'DESC' },
321                                 proxy : {
322                                     xtype: 'HttpProxy',
323                                     xns: Roo.data,
324                                     method : 'GET',
325                                     url : baseURL + '/Roo/report.php'
326                                 },
327                                 reader : {
328                                     xtype: 'JsonReader',
329                                     xns: Roo.data,
330                                     totalProperty : 'total',
331                                     root : 'data',
332                                     id : 'id',
333                                     fields : [
334                                         {
335                                             'name': 'report_id',
336                                             'type': 'int'
337                                         },
338                                         {
339                                             'name': 'report_name',
340                                             'type': 'string'
341                                         },
342                                         {
343                                             'name': 'report_sys',
344                                             'type': 'int'
345                                         },
346                                         {
347                                             'name': 'report_source',
348                                             'type': 'string'
349                                         },
350                                         {
351                                             'name': 'report_descrip',
352                                             'type': 'string'
353                                         },
354                                         {
355                                             'name': 'report_grade',
356                                             'type': 'int'
357                                         },
358                                         {
359                                             'name': 'report_loaddate',
360                                             'type': 'date',
361                                             'dateFormat': 'Y-m-d'
362                                         }
363                                     ]
364                                 }
365                             },
366                             footer : {
367                                 xtype: 'PagingToolbar',
368                                 xns: Roo,
369                                 pageSize : 25,
370                                 displayInfo : true,
371                                 displayMsg : "Displaying report{0} - {1} of {2}",
372                                 emptyMsg : "No report found"
373                             },
374                             colModel : [
375                                 {
376                                     xtype: 'ColumnModel',
377                                     xns: Roo.grid,
378                                     header : 'Report grade',
379                                     width : 75,
380                                     dataIndex : 'report_grade',
381                                     renderer : function(v) { return String.format('{0}', v); }
382                                 },
383                                 {
384                                     xtype: 'ColumnModel',
385                                     xns: Roo.grid,
386                                     header : 'Report loaddate',
387                                     width : 75,
388                                     dataIndex : 'report_loaddate',
389                                     renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
390                                 }
391                             ]
392                         }
393                     }
394                 ],
395                 center : {
396                     xtype: 'LayoutRegion',
397                     xns: Roo
398                 },
399                 east : {
400                     xtype: 'LayoutRegion',
401                     xns: Roo,
402                     split : true,
403                     title : "Versions",
404                     titlebar : true,
405                     width : 200
406                 }
407             }
408         };
409     }
410 });