1 //<script type="text/javascript">
3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
7 // register the module first
8 Pman.on('beforeload', function()
11 part : ["Admin","LogDrill"],
12 modKey : '003-Pman.Tab.AdminLogDrill',
13 module : Pman.Tab.AdminLogDrill,
15 parent : Pman.Tab.AdminLogs,
16 name : "Pman.Tab.AdminLogDrill",
22 Pman.Tab.AdminLogDrill = new Roo.util.Observable({
28 add : function(parentLayout, region)
32 this.parentLayout = parentLayout;
34 this.panel = parentLayout.addxtype({
35 xtype: 'NestedLayoutPanel',
38 title : "Event Drilldown",
40 xtype: 'BorderLayout',
47 activate : function() {
48 _this.datepanel = this;
50 _this.dategrid.ds.load({});
66 _this.dategrid = this;
67 //_this.dialog = Pman.Dialog.FILL_IN
68 if (_this.panel.active) {
72 rowclick : function (_self, rowIndex, e)
74 _this.tablegrid.footer.onClick('first');
77 autoExpandColumn : 'person_name',
83 beforeload : function (_self, o)
85 if (! _this.dateFrom) {
88 o.params = o.params || {};
91 act = _this.dateFrom.getValue();
93 o.params['query[from]'] = act.format('Y-m-d');
95 act = _this.dateTo.getValue();
97 o.params['query[to]'] = act.format('Y-m-d');
99 o.params['query[person_sum]'] = 1;
100 o.params._columns = 'person_id,person_id_name,person_id_email,qty';
101 o.params.limit = 999;
106 sortInfo : { field : 'person_name', direction: 'ASC' },
111 url : baseURL + '/Roo/Events.php'
116 totalProperty : 'total',
125 'name': 'person_name',
129 'name': 'event_when',
131 'dateFormat': 'Y-m-d'
158 'name': 'person_id_id',
162 'name': 'person_id_office_id',
166 'name': 'person_id_name',
170 'name': 'person_id_phone',
174 'name': 'person_id_fax',
178 'name': 'person_id_email',
182 'name': 'person_id_company_id',
186 'name': 'person_id_role',
190 'name': 'person_id_active',
194 'name': 'person_id_remarks',
198 'name': 'person_id_passwd',
202 'name': 'person_id_owner_id',
206 'name': 'person_id_lang',
210 'name': 'person_id_no_reset_sent',
214 'name': 'person_id_action_type',
218 'name': 'person_id_project_id',
222 'name': 'person_id_deleted_by',
226 'name': 'person_id_deleted_dt',
245 render : function (_self)
247 _this.dateFrom = _self;
249 change : function (_self, newValue, oldValue)
251 _this.dategrid.ds.load({});
255 value : (function() { d = new Date(); return d.format('Y-m-01'); })()
261 render : function (_self)
263 _this.dateTo = _self;
265 change : function (_self, newValue, oldValue)
267 _this.dategrid.ds.load({});
271 value : (function() { var d = new Date();d = d.add(Date.MONTH, 1) ; return d.format('Y-m-01'); })()
277 xtype: 'ColumnModel',
279 dataIndex : 'person_id_name',
280 header : 'Person name',
283 renderer : function(v,x,r) {
284 return String.format('{0} <<a href="mailto:{1}">{1}</a>>', v, r.data.person_id_email);
288 xtype: 'ColumnModel',
294 renderer : function(v) { return String.format('{0}', v); }
303 activate : function() {
304 _this.tablepanel = this;
305 if (_this.tablegrid) {
306 _this.tablegrid.footer.onClick('first');
314 tableName : 'Events',
322 _this.tablegrid = this;
323 //_this.dialog = Pman.Dialog.FILL_IN
324 if (_this.tablepanel.active) {
325 this.footer.onClick('first');
328 rowclick : function (_self, rowIndex, e)
330 _this.detailgrid.footer.onClick('first');
333 autoExpandColumn : 'person_name',
339 beforeload : function (_self, o)
341 if (! _this.dategrid) {
345 var s = _this.dategrid.selModel.getSelected();
347 _this.tablegrid.view.el.mask("Select a person");
350 _this.tablegrid.view.el.unmask();
352 o.params = o.params || {};
355 act = _this.dateFrom.getValue();
357 o.params['query[from]'] = act.format('Y-m-d');
359 act = _this.dateTo.getValue();
361 o.params['query[to]'] = act.format('Y-m-d');
363 o.params.person_id = s.data.person_id;
364 o.params['query[table_sum]'] = 1;
365 o.params._columns = 'on_table,qty,uqty';
371 sortInfo : { field : 'on_table', direction: 'ASC' },
376 url : baseURL + '/Roo/Events.php'
381 totalProperty : 'total',
390 'name': 'person_name',
394 'name': 'event_when',
396 'dateFormat': 'Y-m-d'
423 'name': 'person_id_id',
427 'name': 'person_id_office_id',
431 'name': 'person_id_name',
435 'name': 'person_id_phone',
439 'name': 'person_id_fax',
443 'name': 'person_id_email',
447 'name': 'person_id_company_id',
451 'name': 'person_id_role',
455 'name': 'person_id_active',
459 'name': 'person_id_remarks',
463 'name': 'person_id_passwd',
467 'name': 'person_id_owner_id',
471 'name': 'person_id_lang',
475 'name': 'person_id_no_reset_sent',
479 'name': 'person_id_action_type',
483 'name': 'person_id_project_id',
487 'name': 'person_id_deleted_by',
491 'name': 'person_id_deleted_dt',
498 xtype: 'PagingToolbar',
502 displayMsg : "Displaying Events{0} - {1} of {2}",
503 emptyMsg : "No Events found"
513 select : function (combo, record, index)
515 _this.dategrid.ds.load({});
517 render : function (_self)
519 _this.actionSel = _self;
523 displayField : 'action',
525 emptyText : "Select Action",
526 forceSelection : true,
528 loadingText : "Searching...",
532 qtip : "Select Action",
533 queryParam : 'query[action]',
534 selectOnFocus : true,
535 tpl : '<div class="x-grid-cell-text x-btn button"><b>{action}</b> </div>',
536 triggerAction : 'all',
538 valueField : 'action',
544 beforeload : function (_self, o)
546 o.params = o.params || {};
547 // staff can see all logs, other companies can only see their own.
548 if (Pman.Login.authUser.company_id_comptype != 'OWNER') {
549 o.params.company_id = Pman.Login.authUser.company_id;
551 o.params._distinct = 'action';
552 o.params._columns ='action';
556 sortInfo : { field : 'action' , direction : 'ASC' },
561 url : baseURL + '/Roo/Events.php'
566 totalProperty : 'total',
575 'name': 'person_name',
579 'name': 'event_when',
581 'dateFormat': 'Y-m-d'
608 'name': 'person_id_id',
612 'name': 'person_id_office_id',
616 'name': 'person_id_name',
620 'name': 'person_id_phone',
624 'name': 'person_id_fax',
628 'name': 'person_id_email',
632 'name': 'person_id_company_id',
636 'name': 'person_id_role',
640 'name': 'person_id_active',
644 'name': 'person_id_remarks',
648 'name': 'person_id_passwd',
652 'name': 'person_id_owner_id',
656 'name': 'person_id_lang',
660 'name': 'person_id_no_reset_sent',
664 'name': 'person_id_action_type',
668 'name': 'person_id_project_id',
672 'name': 'person_id_deleted_by',
676 'name': 'person_id_deleted_dt',
687 select : function (combo, record, index)
689 _this.dategrid.ds.load({});
691 render : function (_self)
693 _this.affectSel = _self;
697 displayField : 'on_table',
699 emptyText : "Select Affects",
700 forceSelection : true,
702 loadingText : "Searching...",
706 qtip : "Select Action",
707 queryParam : 'query[on_table]',
708 selectOnFocus : true,
709 tpl : '<div class="x-grid-cell-text x-btn button"><b>{on_table}</b> </div>',
710 triggerAction : 'all',
712 valueField : 'action',
718 beforeload : function (_self, o)
720 o.params = o.params || {};
721 // staff can see all logs, other companies can only see their own.
722 if (Pman.Login.authUser.company_id_comptype != 'OWNER') {
723 o.params.company_id = Pman.Login.authUser.company_id;
725 o.params._distinct = 'on_table';
726 o.params._columns ='on_table';
730 sortInfo : { field : 'on_table' , direction : 'ASC' },
735 url : baseURL + '/Roo/Events.php'
740 totalProperty : 'total',
749 'name': 'person_name',
753 'name': 'event_when',
755 'dateFormat': 'Y-m-d'
782 'name': 'person_id_id',
786 'name': 'person_id_office_id',
790 'name': 'person_id_name',
794 'name': 'person_id_phone',
798 'name': 'person_id_fax',
802 'name': 'person_id_email',
806 'name': 'person_id_company_id',
810 'name': 'person_id_role',
814 'name': 'person_id_active',
818 'name': 'person_id_remarks',
822 'name': 'person_id_passwd',
826 'name': 'person_id_owner_id',
830 'name': 'person_id_lang',
834 'name': 'person_id_no_reset_sent',
838 'name': 'person_id_action_type',
842 'name': 'person_id_project_id',
846 'name': 'person_id_deleted_by',
850 'name': 'person_id_deleted_dt',
861 xtype: 'ColumnModel',
863 dataIndex : 'on_table',
867 renderer : function(v) { return String.format('{0}', v); }
870 xtype: 'ColumnModel',
873 header : '#Affected',
876 renderer : function(v) { return String.format('{0}', v); }
879 xtype: 'ColumnModel',
885 renderer : function(v) { return String.format('{0}', v); }
894 activate : function() {
895 _this.detailpanel = this;
896 if (_this.detailgrid) {
897 _this.detailgrid.footer.onClick('first');
905 tableName : 'Events',
913 _this.detailgrid = this;
914 //_this.dialog = Pman.Dialog.FILL_IN
915 if (_this.detailpanel.active) {
916 this.footer.onClick('first');
920 autoExpandColumn : 'person_name',
926 beforeload : function (_self, o)
928 if (! _this.dategrid) {
932 o.params = o.params || {};
934 var s = _this.dategrid.selModel.getSelected();
936 _this.detailgrid.view.el.mask("Select a person");
940 o.params.person_id = s.data.person_id;
942 var s = _this.tablegrid.selModel.getSelected();
944 _this.detailgrid.view.el.mask("Select a table");
947 o.params.on_table = s.data.on_table;
949 _this.detailgrid.view.el.unmask();
954 act = _this.dateFrom.getValue();
956 o.params['query[from]'] = act.format('Y-m-d');
958 act = _this.dateTo.getValue();
960 o.params['query[to]'] = act.format('Y-m-d');
963 //o.params['query[table_d]'] = 1;
964 //o.params._columns = 'on_table,qty,uqty';
970 sortInfo : { field : 'person_name', direction: 'ASC' },
975 url : baseURL + '/Roo/Events.php'
980 totalProperty : 'total',
989 'name': 'person_name',
993 'name': 'event_when',
995 'dateFormat': 'Y-m-d'
1014 'name': 'person_id',
1022 'name': 'person_id_id',
1026 'name': 'person_id_office_id',
1030 'name': 'person_id_name',
1034 'name': 'person_id_phone',
1038 'name': 'person_id_fax',
1042 'name': 'person_id_email',
1046 'name': 'person_id_company_id',
1050 'name': 'person_id_role',
1054 'name': 'person_id_active',
1058 'name': 'person_id_remarks',
1062 'name': 'person_id_passwd',
1066 'name': 'person_id_owner_id',
1070 'name': 'person_id_lang',
1074 'name': 'person_id_no_reset_sent',
1078 'name': 'person_id_action_type',
1082 'name': 'person_id_project_id',
1086 'name': 'person_id_deleted_by',
1090 'name': 'person_id_deleted_dt',
1097 xtype: 'PagingToolbar',
1101 displayMsg : "Displaying Events{0} - {1} of {2}",
1102 emptyMsg : "No Events found"
1106 xtype: 'ColumnModel',
1111 renderer : function(v) { return String.format('{0}', v); }
1114 xtype: 'ColumnModel',
1116 header : 'Event when',
1118 dataIndex : 'event_when',
1119 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1122 xtype: 'ColumnModel',
1124 dataIndex : 'action',
1127 renderer : function(v) { return String.format('{0}', v); }
1130 xtype: 'ColumnModel',
1132 dataIndex : 'ipaddr',
1135 renderer : function(v) { return String.format('{0}', v); }
1138 xtype: 'ColumnModel',
1140 dataIndex : 'on_id',
1143 renderer : function(v) { return String.format('{0}', v); }
1146 xtype: 'ColumnModel',
1150 dataIndex : 'remarks',
1151 renderer : function(v) { return String.format('{0}', v); }
1158 xtype: 'LayoutRegion',
1164 xtype: 'LayoutRegion',
1168 xtype: 'LayoutRegion',
1175 this.layout = this.panel.layout;