1 //<script type="text/javascript">
3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
5 Pman.Tab.AdminLogDrill = new Roo.XComponent({
6 part : ["Admin","LogDrill"],
7 order : '003-Pman.Tab.AdminLogDrill',
9 parent : 'Pman.Tab.AdminLogs',
10 name : "Pman.Tab.AdminLogDrill",
18 xtype: 'NestedLayoutPanel',
22 title : "Event Drilldown",
36 render : function (_self)
38 _this.dateFrom = _self;
40 change : function (_self, newValue, oldValue)
42 _this.dategrid.ds.load({});
46 value : (function() { var d = new Date(); return d.format('Y-m-01'); })()
52 render : function (_self)
56 change : function (_self, newValue, oldValue)
58 _this.dategrid.ds.load({});
62 value : (function() { var d = new Date();d = d.add(Date.MONTH, 1) ; return d.format('Y-m-01'); })()
68 select : function (combo, record, index)
70 _this.dategrid.ds.load({});
72 render : function (_self)
74 _this.actionSel = _self;
78 displayField : 'action',
80 emptyText : "Select Action",
81 forceSelection : true,
83 loadingText : "Searching...",
87 qtip : "Select Action",
88 queryParam : 'query[action]',
90 tpl : '<div class="x-grid-cell-text x-btn button"><b>{action}</b> </div>',
91 triggerAction : 'all',
93 valueField : 'action',
99 beforeload : function (_self, o)
101 o.params = o.params || {};
102 // staff can see all logs, other companies can only see their own.
103 if (Pman.Login.authUser.company_id_comptype != 'OWNER') {
104 o.params.company_id = Pman.Login.authUser.company_id;
106 o.params._distinct = 'action';
107 o.params._columns ='action';
111 sortInfo : { field : 'action' , direction : 'ASC' },
116 url : baseURL + '/Roo/Events.php'
121 totalProperty : 'total',
130 'name': 'person_name',
134 'name': 'event_when',
136 'dateFormat': 'Y-m-d'
163 'name': 'person_id_id',
167 'name': 'person_id_office_id',
171 'name': 'person_id_name',
175 'name': 'person_id_phone',
179 'name': 'person_id_fax',
183 'name': 'person_id_email',
187 'name': 'person_id_company_id',
191 'name': 'person_id_role',
195 'name': 'person_id_active',
199 'name': 'person_id_remarks',
203 'name': 'person_id_passwd',
207 'name': 'person_id_owner_id',
211 'name': 'person_id_lang',
215 'name': 'person_id_no_reset_sent',
219 'name': 'person_id_action_type',
223 'name': 'person_id_project_id',
227 'name': 'person_id_deleted_by',
231 'name': 'person_id_deleted_dt',
241 xtype: 'BorderLayout',
248 activate : function() {
249 _this.datepanel = this;
250 if (_this.dategrid) {
251 _this.dategrid.ds.load({});
259 tableName : 'Events',
267 _this.dategrid = this;
268 //_this.dialog = Pman.Dialog.FILL_IN
269 if (_this.panel.active) {
273 rowclick : function (_self, rowIndex, e)
275 _this.tablegrid.footer.onClick('first');
278 autoExpandColumn : 'person_name',
284 beforeload : function (_self, o)
288 if (! _this.dateFrom) {
293 _this.tablegrid.ds.removeAll();
294 _this.panel.layout.getRegion('east').getActivePanel().grid.ds.removeAll();
299 o.params = o.params || {};
301 var act = _this.actionSel ? _this.actionSel.getValue() : '';
303 o.params.action = act;
305 var tbl = _this.affectSel ? _this.affectSel.getValue() : '';
307 o.params.on_table = tbl;
309 act = _this.dateFrom.getValue();
311 o.params['query[from]'] = act.format('Y-m-d');
313 act = _this.dateTo.getValue();
315 o.params['query[to]'] = act.format('Y-m-d');
320 o.params['query[person_sum]'] = 1;
321 o.params._columns = 'person_id,person_id_name,person_id_email,qty,uqty';
322 o.params.limit = 999;
327 sortInfo : { field : 'person_name', direction: 'ASC' },
332 url : baseURL + '/Roo/Events.php'
337 totalProperty : 'total',
346 'name': 'person_name',
350 'name': 'event_when',
352 'dateFormat': 'Y-m-d'
379 'name': 'person_id_id',
383 'name': 'person_id_office_id',
387 'name': 'person_id_name',
391 'name': 'person_id_phone',
395 'name': 'person_id_fax',
399 'name': 'person_id_email',
403 'name': 'person_id_company_id',
407 'name': 'person_id_role',
411 'name': 'person_id_active',
415 'name': 'person_id_remarks',
419 'name': 'person_id_passwd',
423 'name': 'person_id_owner_id',
427 'name': 'person_id_lang',
431 'name': 'person_id_no_reset_sent',
435 'name': 'person_id_action_type',
439 'name': 'person_id_project_id',
443 'name': 'person_id_deleted_by',
447 'name': 'person_id_deleted_dt',
455 xtype: 'ColumnModel',
457 dataIndex : 'person_id_name',
458 header : 'Person name',
461 renderer : function(v,x,r) {
462 return String.format('{0} <<a href="mailto:{1}">{1}</a>>', v, r.data.person_id_email);
466 xtype: 'ColumnModel',
469 header : '#Affected',
472 renderer : function(v) { return String.format('{0}', v); }
475 xtype: 'ColumnModel',
481 renderer : function(v) { return String.format('{0}', v); }
490 activate : function() {
491 _this.tablepanel = this;
492 if (_this.tablegrid) {
493 _this.tablegrid.footer.onClick('first');
501 tableName : 'Events',
509 _this.tablegrid = this;
510 //_this.dialog = Pman.Dialog.FILL_IN
511 if (_this.tablepanel.active) {
512 this.footer.onClick('first');
515 rowclick : function (_self, rowIndex, e)
518 _this.panel.layout.getRegion('east').getActivePanel().grid.footer.onClick('first');
521 autoExpandColumn : 'person_name',
527 beforeload : function (_self, o)
529 if (! _this.dategrid) {
533 _this.panel.layout.getRegion('east').getActivePanel().grid.ds.removeAll();
539 var s = _this.dategrid.selModel.getSelected();
541 _this.tablegrid.view.el.mask("Select a person");
544 _this.tablegrid.view.el.unmask();
546 o.params = o.params || {};
547 var act = _this.actionSel.getValue();
549 o.params.action = act;
551 var tbl = _this.affectSel.getValue();
553 o.params.on_table = tbl;
556 act = _this.dateFrom.getValue();
558 o.params['query[from]'] = act.format('Y-m-d');
560 act = _this.dateTo.getValue();
562 o.params['query[to]'] = act.format('Y-m-d');
564 o.params.person_id = s.data.person_id;
565 o.params['query[table_sum]'] = 1;
566 o.params._columns = 'on_table,qty,uqty';
572 sortInfo : { field : 'on_table', direction: 'ASC' },
577 url : baseURL + '/Roo/Events.php'
582 totalProperty : 'total',
591 'name': 'person_name',
595 'name': 'event_when',
597 'dateFormat': 'Y-m-d'
624 'name': 'person_id_id',
628 'name': 'person_id_office_id',
632 'name': 'person_id_name',
636 'name': 'person_id_phone',
640 'name': 'person_id_fax',
644 'name': 'person_id_email',
648 'name': 'person_id_company_id',
652 'name': 'person_id_role',
656 'name': 'person_id_active',
660 'name': 'person_id_remarks',
664 'name': 'person_id_passwd',
668 'name': 'person_id_owner_id',
672 'name': 'person_id_lang',
676 'name': 'person_id_no_reset_sent',
680 'name': 'person_id_action_type',
684 'name': 'person_id_project_id',
688 'name': 'person_id_deleted_by',
692 'name': 'person_id_deleted_dt',
699 xtype: 'PagingToolbar',
703 displayMsg : "Displaying Events{0} - {1} of {2}",
704 emptyMsg : "No Events found"
714 select : function (combo, record, index)
716 _this.dategrid.ds.load({});
718 render : function (_self)
720 _this.actionSel = _self;
724 displayField : 'action',
726 emptyText : "Select Action",
727 forceSelection : true,
729 loadingText : "Searching...",
733 qtip : "Select Action",
734 queryParam : 'query[action]',
735 selectOnFocus : true,
736 tpl : '<div class="x-grid-cell-text x-btn button"><b>{action}</b> </div>',
737 triggerAction : 'all',
739 valueField : 'action',
745 beforeload : function (_self, o)
747 o.params = o.params || {};
748 // staff can see all logs, other companies can only see their own.
749 if (Pman.Login.authUser.company_id_comptype != 'OWNER') {
750 o.params.company_id = Pman.Login.authUser.company_id;
752 o.params._distinct = 'action';
753 o.params._columns ='action';
757 sortInfo : { field : 'action' , direction : 'ASC' },
762 url : baseURL + '/Roo/Events.php'
767 totalProperty : 'total',
776 'name': 'person_name',
780 'name': 'event_when',
782 'dateFormat': 'Y-m-d'
809 'name': 'person_id_id',
813 'name': 'person_id_office_id',
817 'name': 'person_id_name',
821 'name': 'person_id_phone',
825 'name': 'person_id_fax',
829 'name': 'person_id_email',
833 'name': 'person_id_company_id',
837 'name': 'person_id_role',
841 'name': 'person_id_active',
845 'name': 'person_id_remarks',
849 'name': 'person_id_passwd',
853 'name': 'person_id_owner_id',
857 'name': 'person_id_lang',
861 'name': 'person_id_no_reset_sent',
865 'name': 'person_id_action_type',
869 'name': 'person_id_project_id',
873 'name': 'person_id_deleted_by',
877 'name': 'person_id_deleted_dt',
888 select : function (combo, record, index)
890 _this.dategrid.ds.load({});
892 render : function (_self)
894 _this.affectSel = _self;
898 displayField : 'on_table',
900 emptyText : "Select Affects",
901 forceSelection : true,
903 loadingText : "Searching...",
907 qtip : "Select Action",
908 queryParam : 'query[on_table]',
909 selectOnFocus : true,
910 tpl : '<div class="x-grid-cell-text x-btn button"><b>{on_table}</b> </div>',
911 triggerAction : 'all',
913 valueField : 'action',
919 beforeload : function (_self, o)
921 o.params = o.params || {};
922 // staff can see all logs, other companies can only see their own.
923 if (Pman.Login.authUser.company_id_comptype != 'OWNER') {
924 o.params.company_id = Pman.Login.authUser.company_id;
926 o.params._distinct = 'on_table';
927 o.params._columns ='on_table';
931 sortInfo : { field : 'on_table' , direction : 'ASC' },
936 url : baseURL + '/Roo/Events.php'
941 totalProperty : 'total',
950 'name': 'person_name',
954 'name': 'event_when',
956 'dateFormat': 'Y-m-d'
983 'name': 'person_id_id',
987 'name': 'person_id_office_id',
991 'name': 'person_id_name',
995 'name': 'person_id_phone',
999 'name': 'person_id_fax',
1003 'name': 'person_id_email',
1007 'name': 'person_id_company_id',
1011 'name': 'person_id_role',
1015 'name': 'person_id_active',
1019 'name': 'person_id_remarks',
1023 'name': 'person_id_passwd',
1027 'name': 'person_id_owner_id',
1031 'name': 'person_id_lang',
1035 'name': 'person_id_no_reset_sent',
1039 'name': 'person_id_action_type',
1043 'name': 'person_id_project_id',
1047 'name': 'person_id_deleted_by',
1051 'name': 'person_id_deleted_dt',
1062 xtype: 'ColumnModel',
1064 dataIndex : 'on_table',
1068 renderer : function(v) {
1070 return "Login / Logout / Errors";
1072 return String.format('{0}', v);
1076 xtype: 'ColumnModel',
1079 header : '#Affected',
1082 renderer : function(v) { return String.format('{0}', v); }
1085 xtype: 'ColumnModel',
1091 renderer : function(v) { return String.format('{0}', v); }
1100 activate : function() {
1101 _this.detailpanel = this;
1102 if (_this.detailgrid) {
1103 _this.detailgrid.footer.onClick('first');
1108 fitContainer : true,
1111 tableName : 'Events',
1119 _this.detailgrid = this;
1120 //_this.dialog = Pman.Dialog.FILL_IN
1121 if (_this.detailpanel.active) {
1122 this.footer.onClick('first');
1126 autoExpandColumn : 'person_name',
1132 beforeload : function (_self, o)
1134 if (! _this.dategrid) {
1138 o.params = o.params || {};
1140 var s = _this.dategrid.selModel.getSelected();
1142 _this.detailgrid.view.el.mask("Select a person");
1146 o.params.person_id = s.data.person_id;
1148 var s = _this.tablegrid.selModel.getSelected();
1150 _this.detailgrid.view.el.mask("Select a table");
1153 o.params.on_table = s.data.on_table;
1155 _this.detailgrid.view.el.unmask();
1157 var act = _this.actionSel.getValue();
1159 o.params.action = act;
1161 var tbl = _this.affectSel.getValue();
1163 o.params.on_table = tbl;
1167 act = _this.dateFrom.getValue();
1169 o.params['query[from]'] = act.format('Y-m-d');
1171 act = _this.dateTo.getValue();
1173 o.params['query[to]'] = act.format('Y-m-d');
1176 //o.params['query[table_d]'] = 1;
1177 //o.params._columns = 'on_table,qty,uqty';
1183 sortInfo : { field : 'event_when', direction: 'DESC' },
1188 url : baseURL + '/Roo/Events.php'
1191 xtype: 'JsonReader',
1193 totalProperty : 'total',
1202 'name': 'person_name',
1206 'name': 'event_when',
1208 'dateFormat': 'Y-m-d'
1227 'name': 'person_id',
1235 'name': 'person_id_id',
1239 'name': 'person_id_office_id',
1243 'name': 'person_id_name',
1247 'name': 'person_id_phone',
1251 'name': 'person_id_fax',
1255 'name': 'person_id_email',
1259 'name': 'person_id_company_id',
1263 'name': 'person_id_role',
1267 'name': 'person_id_active',
1271 'name': 'person_id_remarks',
1275 'name': 'person_id_passwd',
1279 'name': 'person_id_owner_id',
1283 'name': 'person_id_lang',
1287 'name': 'person_id_no_reset_sent',
1291 'name': 'person_id_action_type',
1295 'name': 'person_id_project_id',
1299 'name': 'person_id_deleted_by',
1303 'name': 'person_id_deleted_dt',
1310 xtype: 'PagingToolbar',
1314 displayMsg : "Displaying Events{0} - {1} of {2}",
1315 emptyMsg : "No Events found"
1319 xtype: 'ColumnModel',
1324 renderer : function(v) { return String.format('{0}', v); }
1327 xtype: 'ColumnModel',
1329 header : 'Event when',
1331 dataIndex : 'event_when',
1332 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1335 xtype: 'ColumnModel',
1337 dataIndex : 'action',
1340 renderer : function(v) { return String.format('{0}', v); }
1343 xtype: 'ColumnModel',
1345 dataIndex : 'ipaddr',
1348 renderer : function(v) { return String.format('{0}', v); }
1351 xtype: 'ColumnModel',
1353 dataIndex : 'on_id',
1356 renderer : function(v) { return String.format('{0}', v); }
1359 xtype: 'ColumnModel',
1363 dataIndex : 'remarks',
1364 renderer : function(v) { return String.format('{0}', v); }
1373 activate : function() {
1374 _this.daypanel = this;
1375 if (_this.daygrid) {
1376 _this.daygrid.footer.onClick('first');
1381 fitContainer : true,
1384 tableName : 'Events',
1385 title : "Daily summary",
1392 _this.daygrid = this;
1393 //_this.dialog = Pman.Dialog.FILL_IN
1394 if (_this.daypanel.active) {
1395 this.footer.onClick('first');
1399 autoExpandColumn : 'person_name',
1405 beforeload : function (_self, o)
1407 if (! _this.dategrid) {
1411 o.params = o.params || {};
1413 var s = _this.dategrid.selModel.getSelected();
1415 _this.detailgrid.view.el.mask("Select a person");
1419 o.params.person_id = s.data.person_id;
1421 var s = _this.tablegrid.selModel.getSelected();
1423 _this.detailgrid.view.el.mask("Select a table");
1426 o.params.on_table = s.data.on_table;
1428 _this.detailgrid.view.el.unmask();
1430 var act = _this.actionSel.getValue();
1432 o.params.action = act;
1434 var tbl = _this.affectSel.getValue();
1436 o.params.on_table = tbl;
1440 act = _this.dateFrom.getValue();
1442 o.params['query[from]'] = act.format('Y-m-d');
1444 act = _this.dateTo.getValue();
1446 o.params['query[to]'] = act.format('Y-m-d');
1449 o.params['query[day_sum]'] = 1;
1450 o.params._columns = 'on_day,qty,uqty';
1456 sortInfo : { field : 'on_day', direction: 'ASC' },
1461 url : baseURL + '/Roo/Events.php'
1464 xtype: 'JsonReader',
1466 totalProperty : 'total',
1475 'name': 'person_name',
1479 'name': 'event_when',
1481 'dateFormat': 'Y-m-d'
1500 'name': 'person_id',
1508 'name': 'person_id_id',
1512 'name': 'person_id_office_id',
1516 'name': 'person_id_name',
1520 'name': 'person_id_phone',
1524 'name': 'person_id_fax',
1528 'name': 'person_id_email',
1532 'name': 'person_id_company_id',
1536 'name': 'person_id_role',
1540 'name': 'person_id_active',
1544 'name': 'person_id_remarks',
1548 'name': 'person_id_passwd',
1552 'name': 'person_id_owner_id',
1556 'name': 'person_id_lang',
1560 'name': 'person_id_no_reset_sent',
1564 'name': 'person_id_action_type',
1568 'name': 'person_id_project_id',
1572 'name': 'person_id_deleted_by',
1576 'name': 'person_id_deleted_dt',
1583 xtype: 'PagingToolbar',
1587 displayMsg : "Displaying Events{0} - {1} of {2}",
1588 emptyMsg : "No Events found"
1592 xtype: 'ColumnModel',
1594 dataIndex : 'on_day',
1595 header : 'Event when',
1598 renderer : function(v) { return String.format('{0}', v ); }
1601 xtype: 'ColumnModel',
1604 header : '#Affected',
1607 renderer : function(v) { return String.format('{0}', v); }
1610 xtype: 'ColumnModel',
1616 renderer : function(v) { return String.format('{0}', v); }
1623 xtype: 'LayoutRegion',
1629 xtype: 'LayoutRegion',
1633 xtype: 'LayoutRegion',
1636 tabPosition : 'top',