git.roojs.org Git - Pman.Admin/blob - Pman.Tab.AdminLogDrill.bjs

   1 {
   2     "id": "roo-file-265",
   3     "name": "Pman.Tab.AdminLogDrill",
   4     "parent": "Pman.Tab.AdminLogs",
   5     "title": "Pman.Tab.AdminLogDrill",
   6     "path": "/home/alan/gitlive/Pman.Admin/Pman.Tab.AdminLogDrill.bjs",
   7     "items": [
   8         {
   9             "region": "center",
  10             "title": "Event Drilldown",
  11             "xtype": "NestedLayoutPanel",
  12             "|xns": "Roo",
  13             "items": [
  14                 {
  15                     "|xns": "Roo",
  16                     "xtype": "BorderLayout",
  17                     "*prop": "layout",
  18                     "items": [
  19                         {
  20                             "*prop": "west",
  21                             "split": true,
  22                             "width": 270,
  23                             "xtype": "LayoutRegion",
  24                             "|xns": "Roo"
  25                         },
  26                         {
  27                             "|xns": "Roo",
  28                             "xtype": "LayoutRegion",
  29                             "*prop": "center"
  30                         },
  31                         {
  32                             "*prop": "east",
  33                             "split": true,
  34                             "width": 600,
  35                             "xtype": "LayoutRegion",
  36                             "|xns": "Roo"
  37                         },
  38                         {
  39                             "listeners": {
  40                                 "|activate": "function() {\n    _this.datepanel = this;\n    if (_this.dategrid) {\n        _this.dategrid.ds.load({});\n    }\n}"
  41                             },
  42                             "background": true,
  43                             "fitContainer": true,
  44                             "fitToframe": true,
  45                             "region": "west",
  46                             "tableName": "Events",
  47                             "title": "Events",
  48                             "xtype": "GridPanel",
  49                             "|xns": "Roo",
  50                             "items": [
  51                                 {
  52                                     "listeners": {
  53                                         "|render": "function() \n{\n    _this.dategrid = this; \n    //_this.dialog = Pman.Dialog.FILL_IN\n    if (_this.panel.active) {\n       this.ds.load({});\n    }\n}",
  54                                         "rowclick": "function (_self, rowIndex, e)\n{\n    _this.tablegrid.footer.onClick('first');\n}"
  55                                     },
  56                                     "*prop": "grid",
  57                                     "autoExpandColumn": "person_name",
  58                                     "loadMask": true,
  59                                     "xtype": "Grid",
  60                                     "|xns": "Roo.grid",
  61                                     "items": [
  62                                         {
  63                                             "listeners": {
  64                                                 "beforeload": "function (_self, o)\n{\n    if (! _this.dateFrom) {\n     return;\n    }\n    o.params = o.params || {};\n     \n \n    act = _this.dateFrom.getValue();\n    if (act.format) {\n        o.params['query[from]'] = act.format('Y-m-d');\n    }\n    act = _this.dateTo.getValue();\n    if (act.format) {\n        o.params['query[to]'] = act.format('Y-m-d');\n    }\n    o.params['query[person_sum]'] = 1;\n    o.params._columns = 'person_id,person_id_name,person_id_email,qty';\n    o.params.limit = 999;\n \n}"
  65                                             },
  66                                             "*prop": "dataSource",
  67                                             "remoteSort": true,
  68                                             "xtype": "Store",
  69                                             "|sortInfo": "{ field : 'person_name', direction: 'ASC' }",
  70                                             "|xns": "Roo.data",
  71                                             "items": [
  72                                                 {
  73                                                     "*prop": "proxy",
  74                                                     "xtype": "HttpProxy",
  75                                                     "method": "GET",
  76                                                     "|url": "baseURL + '/Roo/Events.php'",
  77                                                     "|xns": "Roo.data"
  78                                                 },
  79                                                 {
  80                                                     "|xns": "Roo.data",
  81                                                     "xtype": "JsonReader",
  82                                                     "totalProperty": "total",
  83                                                     "root": "data",
  84                                                     "*prop": "reader",
  85                                                     "id": "id",
  86                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_name',\n        'type': 'string'\n    },\n    {\n        'name': 'event_when',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'action',\n        'type': 'string'\n    },\n    {\n        'name': 'ipaddr',\n        'type': 'string'\n    },\n    {\n        'name': 'on_id',\n        'type': 'int'\n    },\n    {\n        'name': 'on_table',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id',\n        'type': 'int'\n    },\n    {\n        'name': 'remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_name',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_email',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_role',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_active',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_dt',\n        'type': 'date'\n    }\n]"
  87                                                 }
  88                                             ]
  89                                         },
  90                                         {
  91                                             "*prop": "toolbar",
  92                                             "xtype": "Toolbar",
  93                                             "listeners": {},
  94                                             "|xns": "Roo",
  95                                             "items": [
  96                                                 {
  97                                                     "text": "Date Range",
  98                                                     "xtype": "TextItem",
  99                                                     "|xns": "Roo.Toolbar"
 100                                                 },
 101                                                 {
 102                                                     "listeners": {
 103                                                         "render": "function (_self)\n{\n  _this.dateFrom = _self;\n}",
 104                                                         "change": "function (_self, newValue, oldValue)\n{\n  _this.dategrid.ds.load({});\n}"
 105                                                     },
 106                                                     "format": "Y-m-d",
 107                                                     "|value": "(function() { d = new Date(); return d.format('Y-m-01'); })()",
 108                                                     "xtype": "DateField",
 109                                                     "|xns": "Roo.form"
 110                                                 },
 111                                                 {
 112                                                     "listeners": {
 113                                                         "render": "function (_self)\n{\n  _this.dateTo = _self;\n}",
 114                                                         "change": "function (_self, newValue, oldValue)\n{\n  _this.dategrid.ds.load({});\n}"
 115                                                     },
 116                                                     "format": "Y-m-d",
 117                                                     "|value": "(function() { var d = new Date();d =  d.add(Date.MONTH, 1) ; return d.format('Y-m-01'); })()",
 118                                                     "xtype": "DateField",
 119                                                     "|xns": "Roo.form"
 120                                                 }
 121                                             ]
 122                                         },
 123                                         {
 124                                             "*prop": "colModel[]",
 125                                             "dataIndex": "person_id_name",
 126                                             "header": "Person name",
 127                                             "sortable": true,
 128                                             "width": 200,
 129                                             "xtype": "ColumnModel",
 130                                             "|renderer": "function(v,x,r) {\n     return String.format('{0} &lt;<a href=\"mailto:{1}\">{1}</a>&gt;', v, r.data.person_id_email); \n }",
 131                                             "|xns": "Roo.grid"
 132                                         },
 133                                         {
 134                                             "*prop": "colModel[]",
 135                                             "dataIndex": "qty",
 136                                             "header": "Changes",
 137                                             "sortable": true,
 138                                             "width": 70,
 139                                             "xtype": "ColumnModel",
 140                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 141                                             "|xns": "Roo.grid"
 142                                         }
 143                                     ]
 144                                 }
 145                             ]
 146                         },
 147                         {
 148                             "listeners": {
 149                                 "|activate": "function() {\n    _this.tablepanel = this;\n    if (_this.tablegrid) {\n        _this.tablegrid.footer.onClick('first');\n    }\n}"
 150                             },
 151                             "background": true,
 152                             "fitContainer": true,
 153                             "fitToframe": true,
 154                             "region": "center",
 155                             "tableName": "Events",
 156                             "title": "Events",
 157                             "xtype": "GridPanel",
 158                             "|xns": "Roo",
 159                             "items": [
 160                                 {
 161                                     "listeners": {
 162                                         "|render": "function() \n{\n    _this.tablegrid = this; \n    //_this.dialog = Pman.Dialog.FILL_IN\n    if (_this.tablepanel.active) {\n       this.footer.onClick('first');\n    }\n}",
 163                                         "rowclick": "function (_self, rowIndex, e)\n{\n    _this.detailgrid.footer.onClick('first');\n}"
 164                                     },
 165                                     "*prop": "grid",
 166                                     "autoExpandColumn": "person_name",
 167                                     "loadMask": true,
 168                                     "xtype": "Grid",
 169                                     "|xns": "Roo.grid",
 170                                     "items": [
 171                                         {
 172                                             "listeners": {
 173                                                 "beforeload": "function (_self, o)\n{\n     if (! _this.dategrid) {\n     return;\n    }\n    \n    var s = _this.dategrid.selModel.getSelected();\n    if (!s) {\n        _this.tablegrid.view.el.mask(\"Select a person\");\n        return false;\n    }\n    _this.tablegrid.view.el.unmask();\n \n    o.params = o.params || {};\n     \n \n    act = _this.dateFrom.getValue();\n    if (act.format) {\n        o.params['query[from]'] = act.format('Y-m-d');\n    }\n    act = _this.dateTo.getValue();\n    if (act.format) {\n        o.params['query[to]'] = act.format('Y-m-d');\n    }\n    o.params.person_id = s.data.person_id;\n    o.params['query[table_sum]'] = 1;\n    o.params._columns = 'on_table,qty,uqty';\n\n    \n}"
 174                                             },
 175                                             "*prop": "dataSource",
 176                                             "remoteSort": true,
 177                                             "xtype": "Store",
 178                                             "|sortInfo": "{ field : 'on_table', direction: 'ASC' }",
 179                                             "|xns": "Roo.data",
 180                                             "items": [
 181                                                 {
 182                                                     "*prop": "proxy",
 183                                                     "xtype": "HttpProxy",
 184                                                     "method": "GET",
 185                                                     "|url": "baseURL + '/Roo/Events.php'",
 186                                                     "|xns": "Roo.data"
 187                                                 },
 188                                                 {
 189                                                     "|xns": "Roo.data",
 190                                                     "xtype": "JsonReader",
 191                                                     "totalProperty": "total",
 192                                                     "root": "data",
 193                                                     "*prop": "reader",
 194                                                     "id": "id",
 195                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_name',\n        'type': 'string'\n    },\n    {\n        'name': 'event_when',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'action',\n        'type': 'string'\n    },\n    {\n        'name': 'ipaddr',\n        'type': 'string'\n    },\n    {\n        'name': 'on_id',\n        'type': 'int'\n    },\n    {\n        'name': 'on_table',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id',\n        'type': 'int'\n    },\n    {\n        'name': 'remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_name',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_email',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_role',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_active',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_dt',\n        'type': 'date'\n    }\n]"
 196                                                 }
 197                                             ]
 198                                         },
 199                                         {
 200                                             "*prop": "footer",
 201                                             "xtype": "PagingToolbar",
 202                                             "pageSize": 25,
 203                                             "displayInfo": true,
 204                                             "displayMsg": "Displaying Events{0} - {1} of {2}",
 205                                             "emptyMsg": "No Events found",
 206                                             "|xns": "Roo"
 207                                         },
 208                                         {
 209                                             "*prop": "toolbar",
 210                                             "xtype": "Toolbar",
 211                                             "listeners": {},
 212                                             "|xns": "Roo",
 213                                             "items": [
 214                                                 {
 215                                                     "listeners": {
 216                                                         "|select": "function (combo, record, index)\n{\n   _this.dategrid.ds.load({});\n}",
 217                                                         "|render": "function (_self)\n{\n  _this.actionSel = _self;\n}"
 218                                                     },
 219                                                     "allowBlank": true,
 220                                                     "displayField": "action",
 221                                                     "editable": false,
 222                                                     "emptyText": "Select Action",
 223                                                     "forceSelection": true,
 224                                                     "listWidth": 300,
 225                                                     "loadingText": "Searching...",
 226                                                     "minChars": 2,
 227                                                     "name": "action",
 228                                                     "pageSize": 20,
 229                                                     "qtip": "Select Action",
 230                                                     "queryParam": "query[action]",
 231                                                     "selectOnFocus": true,
 232                                                     "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{action}</b> </div>",
 233                                                     "triggerAction": "all",
 234                                                     "typeAhead": true,
 235                                                     "valueField": "action",
 236                                                     "width": 150,
 237                                                     "xtype": "ComboBox",
 238                                                     "|xns": "Roo.form",
 239                                                     "items": [
 240                                                         {
 241                                                             "listeners": {
 242                                                                 "|beforeload": "function (_self, o)\n{\n    o.params = o.params || {};\n    // staff can see all logs, other companies can only see their own.\n    if (Pman.Login.authUser.company_id_comptype != 'OWNER') {\n        o.params.company_id = Pman.Login.authUser.company_id;\n    }\n    o.params._distinct = 'action';\n    o.params._columns ='action';\n}"
 243                                                             },
 244                                                             "*prop": "store",
 245                                                             "remoteSort": true,
 246                                                             "xtype": "Store",
 247                                                             "|sortInfo": "{ field : 'action' , direction : 'ASC' }",
 248                                                             "|xns": "Roo.data",
 249                                                             "items": [
 250                                                                 {
 251                                                                     "*prop": "proxy",
 252                                                                     "method": "GET",
 253                                                                     "xtype": "HttpProxy",
 254                                                                     "|url": "baseURL + '/Roo/Events.php'",
 255                                                                     "|xns": "Roo.data"
 256                                                                 },
 257                                                                 {
 258                                                                     "|xns": "Roo.data",
 259                                                                     "xtype": "JsonReader",
 260                                                                     "totalProperty": "total",
 261                                                                     "root": "data",
 262                                                                     "*prop": "reader",
 263                                                                     "id": "id",
 264                                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_name',\n        'type': 'string'\n    },\n    {\n        'name': 'event_when',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'action',\n        'type': 'string'\n    },\n    {\n        'name': 'ipaddr',\n        'type': 'string'\n    },\n    {\n        'name': 'on_id',\n        'type': 'int'\n    },\n    {\n        'name': 'on_table',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id',\n        'type': 'int'\n    },\n    {\n        'name': 'remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_name',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_email',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_role',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_active',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_dt',\n        'type': 'date'\n    }\n]"
 265                                                                 }
 266                                                             ]
 267                                                         }
 268                                                     ]
 269                                                 },
 270                                                 {
 271                                                     "listeners": {
 272                                                         "|select": "function (combo, record, index)\n{\n   _this.dategrid.ds.load({});\n}",
 273                                                         "|render": "function (_self)\n{\n  _this.affectSel = _self;\n}"
 274                                                     },
 275                                                     "allowBlank": true,
 276                                                     "displayField": "on_table",
 277                                                     "editable": false,
 278                                                     "emptyText": "Select Affects",
 279                                                     "forceSelection": true,
 280                                                     "listWidth": 300,
 281                                                     "loadingText": "Searching...",
 282                                                     "minChars": 2,
 283                                                     "name": "on_table",
 284                                                     "pageSize": 20,
 285                                                     "qtip": "Select Action",
 286                                                     "queryParam": "query[on_table]",
 287                                                     "selectOnFocus": true,
 288                                                     "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{on_table}</b> </div>",
 289                                                     "triggerAction": "all",
 290                                                     "typeAhead": true,
 291                                                     "valueField": "action",
 292                                                     "width": 150,
 293                                                     "xtype": "ComboBox",
 294                                                     "|xns": "Roo.form",
 295                                                     "items": [
 296                                                         {
 297                                                             "listeners": {
 298                                                                 "|beforeload": "function (_self, o)\n{\n    o.params = o.params || {};\n    // staff can see all logs, other companies can only see their own.\n    if (Pman.Login.authUser.company_id_comptype != 'OWNER') {\n        o.params.company_id = Pman.Login.authUser.company_id;\n    }\n    o.params._distinct = 'on_table';\n    o.params._columns ='on_table';\n}"
 299                                                             },
 300                                                             "*prop": "store",
 301                                                             "remoteSort": true,
 302                                                             "xtype": "Store",
 303                                                             "|sortInfo": "{ field : 'on_table' , direction : 'ASC' }",
 304                                                             "|xns": "Roo.data",
 305                                                             "items": [
 306                                                                 {
 307                                                                     "*prop": "proxy",
 308                                                                     "method": "GET",
 309                                                                     "xtype": "HttpProxy",
 310                                                                     "|url": "baseURL + '/Roo/Events.php'",
 311                                                                     "|xns": "Roo.data"
 312                                                                 },
 313                                                                 {
 314                                                                     "|xns": "Roo.data",
 315                                                                     "xtype": "JsonReader",
 316                                                                     "totalProperty": "total",
 317                                                                     "root": "data",
 318                                                                     "*prop": "reader",
 319                                                                     "id": "id",
 320                                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_name',\n        'type': 'string'\n    },\n    {\n        'name': 'event_when',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'action',\n        'type': 'string'\n    },\n    {\n        'name': 'ipaddr',\n        'type': 'string'\n    },\n    {\n        'name': 'on_id',\n        'type': 'int'\n    },\n    {\n        'name': 'on_table',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id',\n        'type': 'int'\n    },\n    {\n        'name': 'remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_name',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_email',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_role',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_active',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_dt',\n        'type': 'date'\n    }\n]"
 321                                                                 }
 322                                                             ]
 323                                                         }
 324                                                     ]
 325                                                 }
 326                                             ]
 327                                         },
 328                                         {
 329                                             "*prop": "colModel[]",
 330                                             "dataIndex": "on_table",
 331                                             "header": "Table",
 332                                             "sortable": true,
 333                                             "width": 200,
 334                                             "xtype": "ColumnModel",
 335                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 336                                             "|xns": "Roo.grid"
 337                                         },
 338                                         {
 339                                             "*prop": "colModel[]",
 340                                             "dataIndex": "uqty",
 341                                             "header": "#Affected",
 342                                             "sortable": true,
 343                                             "width": 70,
 344                                             "xtype": "ColumnModel",
 345                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 346                                             "|xns": "Roo.grid"
 347                                         },
 348                                         {
 349                                             "*prop": "colModel[]",
 350                                             "dataIndex": "qty",
 351                                             "header": "Changes",
 352                                             "sortable": true,
 353                                             "width": 70,
 354                                             "xtype": "ColumnModel",
 355                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 356                                             "|xns": "Roo.grid"
 357                                         }
 358                                     ]
 359                                 }
 360                             ]
 361                         },
 362                         {
 363                             "listeners": {
 364                                 "|activate": "function() {\n    _this.detailpanel = this;\n    if (_this.detailgrid) {\n        _this.detailgrid.footer.onClick('first');\n    }\n}"
 365                             },
 366                             "background": true,
 367                             "fitContainer": true,
 368                             "fitToframe": true,
 369                             "region": "east",
 370                             "tableName": "Events",
 371                             "title": "Events",
 372                             "xtype": "GridPanel",
 373                             "|xns": "Roo",
 374                             "items": [
 375                                 {
 376                                     "listeners": {
 377                                         "|render": "function() \n{\n    _this.detailgrid = this; \n    //_this.dialog = Pman.Dialog.FILL_IN\n    if (_this.detailpanel.active) {\n       this.footer.onClick('first');\n    }\n}"
 378                                     },
 379                                     "*prop": "grid",
 380                                     "autoExpandColumn": "person_name",
 381                                     "loadMask": true,
 382                                     "xtype": "Grid",
 383                                     "|xns": "Roo.grid",
 384                                     "items": [
 385                                         {
 386                                             "listeners": {
 387                                                 "beforeload": "function (_self, o)\n{\n     if (! _this.dategrid) {\n         return false;\n    }\n    \n    o.params = o.params || {};\n    \n    var s = _this.dategrid.selModel.getSelected();\n    if (!s) {\n        _this.detailgrid.view.el.mask(\"Select a person\");\n        return false;\n    }\n    \n    o.params.person_id = s.data.person_id;    \n    \n    var s = _this.tablegrid.selModel.getSelected();\n    if (!s) {\n        _this.detailgrid.view.el.mask(\"Select a table\");\n        return false;\n    }\n    o.params.on_table = s.data.on_table;        \n    \n    _this.detailgrid.view.el.unmask();\n \n\n     \n \n    act = _this.dateFrom.getValue();\n    if (act.format) {\n        o.params['query[from]'] = act.format('Y-m-d');\n    }\n    act = _this.dateTo.getValue();\n    if (act.format) {\n        o.params['query[to]'] = act.format('Y-m-d');\n    }\n\n    //o.params['query[table_d]'] = 1;\n    //o.params._columns = 'on_table,qty,uqty';\n\n    \n}"
 388                                             },
 389                                             "*prop": "dataSource",
 390                                             "remoteSort": true,
 391                                             "xtype": "Store",
 392                                             "|sortInfo": "{ field : 'person_name', direction: 'ASC' }",
 393                                             "|xns": "Roo.data",
 394                                             "items": [
 395                                                 {
 396                                                     "*prop": "proxy",
 397                                                     "xtype": "HttpProxy",
 398                                                     "method": "GET",
 399                                                     "|url": "baseURL + '/Roo/Events.php'",
 400                                                     "|xns": "Roo.data"
 401                                                 },
 402                                                 {
 403                                                     "|xns": "Roo.data",
 404                                                     "xtype": "JsonReader",
 405                                                     "totalProperty": "total",
 406                                                     "root": "data",
 407                                                     "*prop": "reader",
 408                                                     "id": "id",
 409                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_name',\n        'type': 'string'\n    },\n    {\n        'name': 'event_when',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'action',\n        'type': 'string'\n    },\n    {\n        'name': 'ipaddr',\n        'type': 'string'\n    },\n    {\n        'name': 'on_id',\n        'type': 'int'\n    },\n    {\n        'name': 'on_table',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id',\n        'type': 'int'\n    },\n    {\n        'name': 'remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_name',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_email',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_role',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_active',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'person_id_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'person_id_deleted_dt',\n        'type': 'date'\n    }\n]"
 410                                                 }
 411                                             ]
 412                                         },
 413                                         {
 414                                             "*prop": "footer",
 415                                             "xtype": "PagingToolbar",
 416                                             "pageSize": 25,
 417                                             "displayInfo": true,
 418                                             "displayMsg": "Displaying Events{0} - {1} of {2}",
 419                                             "emptyMsg": "No Events found",
 420                                             "|xns": "Roo"
 421                                         },
 422                                         {
 423                                             "*prop": "colModel[]",
 424                                             "dataIndex": "id",
 425                                             "header": "Id",
 426                                             "width": 50,
 427                                             "xtype": "ColumnModel",
 428                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 429                                             "|xns": "Roo.grid"
 430                                         },
 431                                         {
 432                                             "xtype": "ColumnModel",
 433                                             "header": "Event when",
 434                                             "width": 75,
 435                                             "dataIndex": "event_when",
 436                                             "|renderer": "function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }",
 437                                             "|xns": "Roo.grid",
 438                                             "*prop": "colModel[]"
 439                                         },
 440                                         {
 441                                             "*prop": "colModel[]",
 442                                             "dataIndex": "action",
 443                                             "header": "Action",
 444                                             "width": 50,
 445                                             "xtype": "ColumnModel",
 446                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 447                                             "|xns": "Roo.grid"
 448                                         },
 449                                         {
 450                                             "*prop": "colModel[]",
 451                                             "dataIndex": "ipaddr",
 452                                             "header": "Ipaddr",
 453                                             "width": 100,
 454                                             "xtype": "ColumnModel",
 455                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 456                                             "|xns": "Roo.grid"
 457                                         },
 458                                         {
 459                                             "*prop": "colModel[]",
 460                                             "dataIndex": "on_id",
 461                                             "header": "#ID",
 462                                             "width": 75,
 463                                             "xtype": "ColumnModel",
 464                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 465                                             "|xns": "Roo.grid"
 466                                         },
 467                                         {
 468                                             "xtype": "ColumnModel",
 469                                             "header": "Remarks",
 470                                             "width": 200,
 471                                             "dataIndex": "remarks",
 472                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 473                                             "|xns": "Roo.grid",
 474                                             "*prop": "colModel[]"
 475                                         }
 476                                     ]
 477                                 }
 478                             ]
 479                         }
 480                     ]
 481                 }
 482             ]
 483         }
 484     ],
 485     "permname": "",
 486     "modOrder": "003"
 487 }