/*jshint globalstrict:true */ /*global angular:true */ /* ## Table A paginated table of events matching a query ### Parameters * query :: A string representing then current query * size :: Number of events per page to show * pages :: Number of pages to show. size * pages = number of cached events. Bigger = more memory usage byh the browser * offset :: Position from which to start in the array of hits * sort :: An array with 2 elements. sort[0]: field, sort[1]: direction ('asc' or 'desc') * style :: hash of css properties * fields :: columns to show in table * overflow :: 'height' or 'min-height' controls wether the row will expand (min-height) to to fit the table, or if the table will scroll to fit the row (height) * sortable :: Allow sorting? * spyable :: Show the 'eye' icon that reveals the last ES query for this panel ### Group Events #### Sends * table_documents :: An array containing all of the documents in the table. Only used by the fields panel so far. #### Receives * selected_fields :: An array of fields to show */ 'use strict'; angular.module('kibana.table', []) .controller('table', function($rootScope, $scope, eventBus, fields, querySrv, dashboard, filterSrv) { // Set and populate defaults var _d = { status : "Stable", query : "*", size : 100, // Per page pages : 5, // Pages available offset : 0, sort : ['@timestamp','desc'], group : "default", style : {'font-size': '9pt'}, overflow: 'height', fields : [], highlight : [], sortable: true, header : true, paging : true, spyable: true }; _.defaults($scope.panel,_d); $scope.init = function () { $scope.set_listeners($scope.panel.group); $scope.get_data(); }; $scope.set_listeners = function(group) { $scope.$on('refresh',function(){$scope.get_data();}); eventBus.register($scope,'sort', function(event,sort){ $scope.panel.sort = _.clone(sort); $scope.get_data(); }); eventBus.register($scope,'selected_fields', function(event, fields) { $scope.panel.fields = _.clone(fields); }); eventBus.register($scope,'table_documents', function(event, docs) { querySrv.list[querySrv.ids[0]].query = docs.query; $scope.data = docs.docs; }); }; $scope.set_sort = function(field) { if($scope.panel.sort[0] === field) { $scope.panel.sort[1] = $scope.panel.sort[1] === 'asc' ? 'desc' : 'asc'; } else { $scope.panel.sort[0] = field; } $scope.get_data(); }; $scope.toggle_field = function(field) { if (_.indexOf($scope.panel.fields,field) > -1) { $scope.panel.fields = _.without($scope.panel.fields,field); } else { $scope.panel.fields.push(field); } broadcast_results(); }; $scope.toggle_highlight = function(field) { if (_.indexOf($scope.panel.highlight,field) > -1) { $scope.panel.highlight = _.without($scope.panel.highlight,field); } else { $scope.panel.highlight.push(field); } }; $scope.toggle_details = function(row) { row.kibana = row.kibana || {}; row.kibana.details = !row.kibana.details ? $scope.without_kibana(row) : false; }; $scope.page = function(page) { $scope.panel.offset = page*$scope.panel.size; $scope.get_data(); }; $scope.build_search = function(field,value,negate) { var query = field+":"; // This needs to be abstracted somewhere if(_.isArray(value)) { query = query+"(" + _.map(value,function(v){return angular.toJson(v);}).join(" AND ") + ")"; } else { query = query+angular.toJson(value); } filterSrv.set({type:'querystring',query:query,mandate:(negate ? 'mustNot':'must')}); $scope.panel.offset = 0; dashboard.refresh(); }; $scope.get_data = function(segment,query_id) { $scope.panel.error = false; // Make sure we have everything for the request to complete if(dashboard.indices.length === 0) { return; } $scope.panel.loading = true; var _segment = _.isUndefined(segment) ? 0 : segment; $scope.segment = _segment; var request = $scope.ejs.Request().indices(dashboard.indices[_segment]); var boolQuery = $scope.ejs.BoolQuery(); _.each(querySrv.list,function(q) { boolQuery = boolQuery.should(querySrv.toEjsObj(q)); }); request = request.query( $scope.ejs.FilteredQuery( boolQuery, filterSrv.getBoolFilter(filterSrv.ids) )) .highlight( $scope.ejs.Highlight($scope.panel.highlight) .fragmentSize(2147483647) // Max size of a 32bit unsigned int .preTags('@start-highlight@') .postTags('@end-highlight@') ) .size($scope.panel.size*$scope.panel.pages) .sort($scope.panel.sort[0],$scope.panel.sort[1]); $scope.populate_modal(request); var results = request.doSearch(); // Populate scope when we have results results.then(function(results) { $scope.panel.loading = false; if(_segment === 0) { $scope.hits = 0; $scope.data = []; query_id = $scope.query_id = new Date().getTime(); } // Check for error and abort if found if(!(_.isUndefined(results.error))) { $scope.panel.error = $scope.parse_error(results.error); return; } // Check that we're still on the same query, if not stop if($scope.query_id === query_id) { $scope.data= $scope.data.concat(_.map(results.hits.hits, function(hit) { return { _source : kbn.flatten_json(hit._source), highlight : kbn.flatten_json(hit.highlight||{}) }; })); $scope.hits += results.hits.total; // Sort the data $scope.data = _.sortBy($scope.data, function(v){ return v._source[$scope.panel.sort[0]]; }); // Reverse if needed if($scope.panel.sort[1] === 'desc') { $scope.data.reverse(); } // Keep only what we need for the set $scope.data = $scope.data.slice(0,$scope.panel.size * $scope.panel.pages); } else { return; } // This breaks, use $scope.data for this $scope.all_fields = kbn.get_all_fields(_.pluck($scope.data,'_source')); broadcast_results(); // If we're not sorting in reverse chrono order, query every index for // size*pages results // Otherwise, only get size*pages results then stop querying //($scope.data.length < $scope.panel.size*$scope.panel.pages // || !(($scope.panel.sort[0] === $scope.time.field) && $scope.panel.sort[1] === 'desc')) if($scope.data.length < $scope.panel.size*$scope.panel.pages && _segment+1 < dashboard.indices.length ) { $scope.get_data(_segment+1,$scope.query_id); } }); }; $scope.populate_modal = function(request) { $scope.modal = { title: "Table Inspector", body : "
Last Elasticsearch Query
"+
          'curl -XGET '+config.elasticsearch+'/'+dashboard.indices+"/_search?pretty -d'\n"+
          angular.toJson(JSON.parse(request.toString()),true)+
        "'
", }; }; $scope.without_kibana = function (row) { return { _source : row._source, highlight : row.highlight }; }; // Broadcast a list of all fields. Note that receivers of field array // events should be able to receive from multiple sources, merge, dedupe // and sort on the fly if needed. function broadcast_results() { eventBus.broadcast($scope.$id,$scope.panel.group,"fields", { all : $scope.all_fields, sort : $scope.panel.sort, active: $scope.panel.fields }); eventBus.broadcast($scope.$id,$scope.panel.group,"table_documents", { query: querySrv.list[querySrv.ids[0]].query, docs : _.pluck($scope.data,'_source'), index: $scope.index }); } $scope.set_refresh = function (state) { $scope.refresh = state; }; $scope.close_edit = function() { if($scope.refresh) { $scope.get_data(); } $scope.refresh = false; }; }) .filter('highlight', function() { return function(text) { if (!_.isUndefined(text) && !_.isNull(text) && text.toString().length > 0) { return text.toString(). replace(/&/g, '&'). replace(//g, '>'). replace(/\r?\n/g, '
'). replace(/@start-highlight@/g, ''). replace(/@end-highlight@/g, ''); } return ''; }; });