diff static/js/app.js @ 0:7537482eed36 draft

planemo upload for repository https://github.com/galaxyproject/tools-iuc/tree/master/tools/annotateviz commit 9bbaa3eacc76ff3bf2b6da313cc0d85705f15dd1-dirty

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/static/js/app.js	Sat Jun 17 13:31:06 2017 -0400
@@ -0,0 +1,173 @@
+var app = angular.module('app', ['ngTouch', 'ui.grid','ui.grid.expandable', 'ui.grid.pagination']);
+
+app.service('transcriptome', [
+ '$http', 'uiGridConstants', function($http, uiGridConstants) {
+
+  var paginationOptions = {
+    pageNumber: 1,
+    pageSize: 25,
+    sort: null
+  };
+  var query ={
+    baseurl: '/api/datasets/'+hdaId+'?provider=sqlite-dict&data_type=raw_data&query=',
+    groupby: '%20group%20by%20gene_id%20',
+    genesel: 'select%20t.gene_id,sum(e.frag_count)%20as%20e_count%20from%20expression%20e,transcript%20t%20',
+    diffsel:"select%20feature_name as gene_id,sample_id_A||'vs'||sample_id_b%20as%20contrast,log_fold_change%20as%20logfc,p_value,fdr%20from%20diff_expression%20d%20",
+    diffwhere: 'where%20d.feature_name=t.gene_id%20',
+    totsel: 'select%20gene_id%20from%20',
+    transjoin: 'transcript%20t,%20orf%20o,blastdbase%20x%20',
+    tottable: 'transcript%20t,%20orf%20o,blastdbase%20x%20,%20diff_expression%20d%20,hmmerdbase%20h%20',
+    pfamjoin: 'transcript%20t,%20orf%20o,hmmerdbase%20h%20',
+    genewhere: 'where%20e.feature_name=t.gene_id%20',
+    transwhere: 'where%20t.transcript_id=o.transcript_id%20and%20x.trinityid=t.transcript_id%20',
+    totwhere: 'where%20t.transcript_id=o.transcript_id%20and%20x.trinityid=t.transcript_id%20and%20h.queryprotid=o.orf_id%20and%20d.feature_name=t.gene_id%20',
+    orfwhere: 'where%20t.transcript_id=o.transcript_id%20and%20x.Trinityid=o.orf_id%20',
+    pfamwhere: 'where%20t.transcript_id=o.transcript_id%20and%20h.queryprotid=o.orf_id%20',
+    group: 'group%20by%20gene_id%20',
+    pfamsel: 'select%20t.gene_id,o.orf_id,h.pfam_id,h.hmmerdomain%20as%20h_domain,querystartalign,3*(queryendalign-querystartalign)/o.length%20as%20h_qcov,h.fullseqevalue%20as%20h_eval%20from%20',
+    //transgroup: 'group%20by%20trans_id%20',
+    //orfgroup: 'group%20by%20orf_id%20',
+    filter: '',
+    sorting: 'order%20by gene_id%20asc%20',
+    paging: 'limit%20'+paginationOptions.pageSize+'%20offset%20 '+(paginationOptions.pageNumber - 1) * paginationOptions.pageSize,
+    transsel: 'select%20distinct%20t.gene_id%20as%20gene_id,t.transcript_id%20as%20trans_id,length(sequence)%20as%20t_len,x.FullAccession%20as%20x_hit,abs(x.queryend-x.querystart)/o.length%20as%20x_qcov,x.percentidentity%20as%20x_id,x.evalue%20as%20x_eval,x.databasesource%20as%20x_source%20from%20',
+    orfsel:   'select%20distinct%20t.gene_id%20as%20gene_id,o.orf_id%20,o.rend,o.lend,o.length%20as%20o_len,o.strand,x.FullAccession%20as%20p_hit,3*abs(x.queryend-x.querystart)/o.length%20as%20p_qcov,x.percentidentity%20as%20p_id,x.evalue%20as%20p_eval,x.databasesource%20as%20p_source%20from%20',
+  }
+
+    mygridOptions = {
+    enableHorizontalScrollbar: 0,
+    enableVerticalScrollbar: 1,
+    expandableRowTemplate: 'GridTemplate.html',
+    expandableRowHeight: 180,
+    //subGridVariable will be available in subGrid scope
+    expandableRowScope: {
+    subGridVariable: 'subGridScopeVariable'
+        },
+   // enableFiltering: true,
+   // useExternalFiltering: true,
+    paginationPageSizes: [25, 50],
+    paginationPageSize: 25,
+    useExternalPagination: true,
+    useExternalSorting: true,
+    columnDefs: [
+      { name: 'gene_id', enableSorting: false  },
+      { name: 'e_count'}
+    ],
+    onRegisterApi: function(gridApi) {
+      this.gridApi = gridApi;
+/*
+      $scope.gridApi.core.on.sortChanged($scope, function(grid, sortColumns) {
+        if (sortColumns.length == 0) {
+          paginationOptions.sort = null;
+        } else {
+          paginationOptions.sort = sortColumns[0].sort.direction;
+        }
+        getPage();
+      });
+*/
+      gridApi.pagination.on.paginationChanged(this, function (newPage, pageSize) {
+        paginationOptions.pageNumber = newPage;
+        paginationOptions.pageSize = pageSize;
+        query.paging='limit%20'+paginationOptions.pageSize+'%20offset%20 '+(paginationOptions.pageNumber - 1) * paginationOptions.pageSize;
+        getPage();
+      });
+   getPage();
+    }
+  };
+
+  var unpack = function(url) {
+      $http.get(url)
+     .success (function(response){
+        return [].concat.apply([], response.data);
+     });
+  };
+  var getPage = function() {
+
+
+    var tot_url=  query.totsel +query.tottable +query.totwhere+ query.group+query.filter;
+    var gene_url= query.baseurl + query.genesel + query.genewhere+ 'and%20t.gene_id%20in%20('+tot_url+ query.sorting+query.paging+')'+query.group;
+    var trans_url = query.baseurl + query.transsel +query.transjoin +query.transwhere+'and%20t.gene_id%20in%20('+tot_url+ query.sorting+query.paging+')'+query.group;
+    var orf_url = query.baseurl + query.orfsel +query.transjoin +query.orfwhere+'and%20t.gene_id%20in%20('+tot_url+ query.sorting+query.paging+')'+query.group;
+    var pfam_url = query.baseurl + query.pfamsel +query.pfamjoin +query.pfamwhere+'and%20t.gene_id%20in%20('+tot_url+ query.sorting+query.paging+')'+query.group;
+    var diff_url = query.baseurl + query.diffsel  +'where%20feature_name%20in%20('+tot_url+ query.sorting+query.paging+')';
+
+    $http.get(query.baseurl+tot_url)
+     .success (function(response){
+
+        mygridOptions.totalItems = ([].concat.apply([], response.data)).length;
+
+     });
+
+
+     trans_promise=$http.get(trans_url);
+    $http.get(orf_url)
+     .success (function(response){
+        orfdata = [].concat.apply([], response.data);
+     });
+     $http.get(pfam_url)
+     .success (function(response){
+        pfamdata = [].concat.apply([], response.data);
+     });
+     $http.get(diff_url)
+     .success (function(response){
+        diffdata = [].concat.apply([], response.data);
+     });
+     trans_promise.then(function(response){   transdata = [].concat.apply([], response.data);
+     $http.get(gene_url)
+     .success (function(response){
+        mygridOptions.data = [].concat.apply([], response.data);
+        for(i = 0; i < mygridOptions.data.length; i++){
+
+        mygridOptions.data[i].subGridOptions1 = {
+            enableVerticalScrollbars: 1,
+
+          columnDefs: [ {name:"trans_id", field:"trans_id"},{name:"t_len", field:"t_len"},{name:"x_hit", field:"x_hit"},{name:"x_qcov", field:"x_qcov"},
+                     ,{name:"x_id", field:"x_id"},{name:"x_eval", field:"x_eval"},{name:"x_source", field:"x_source"} ],
+          data: transdata.filter(function(trans){return trans.gene_id===mygridOptions.data[i].gene_id;})
+          }
+       //      for(j = 0; j < this.gridOptions.data[i].subGridOptions.data.length; j++){
+
+                 mygridOptions.data[i].subGridOptions2 = {
+                     //enableVerticalScrollbars: 0,
+
+                     columnDefs: [ {name:"orf_id", field:"orf_id"},{name:"rend", field:"rend"},{name:"lend", field:"lend"},{name:"o_len", field:"o_len"},{name:"strand", field:"strand"},{name:"p_hit", field:"p_hit"},{name:"p_qcov", field:"p_qcov"},
+                     ,{name:"p_id", field:"p_id"},{name:"p_eval", field:"p_eval"},{name:"p_source", field:"p_source"}],
+                     data: orfdata.filter(function(orf){return orf.gene_id===mygridOptions.data[i].gene_id;})
+                }
+                 mygridOptions.data[i].subGridOptions3 = {
+                           //enableVerticalScrollbars: 0,
+                     columnDefs: [ {name:"orf_id", field:"orf_id"}, {name:"pfam_id", field:"pfam_id"},{name:"hmmerdomain", field:"h_domain"},{name:"querystartalign", field:"QueryStartAlign"},{name:"h_qcov", field:"h_qcov"},{name:"h_eval", field:"h_eval"} ],
+                     data: pfamdata.filter(function(pfam){return pfam.gene_id===mygridOptions.data[i].gene_id;})
+                }
+                mygridOptions.data[i].subGridOptions0 = {
+                           //enableVerticalScrollbars: 0,
+            columnDefs: [ {name:"contrast", field:"contrast"},{name:"logfc", field:"logfc"},{name:"p_value", field:"p_value"},{name:"fdr", field:"fdr"} ],
+            data: diffdata.filter(function(diff){return diff.gene_id===mygridOptions.data[i].gene_id;})
+                }
+    //         }
+        }
+
+     });//end get gene_url
+});//end promise
+  };
+ // getPage();
+  return {filter: (function() {
+     if (this.filterValue.length>0){
+        query.filter= 'having%20'+this.filterValue+'%20';
+    }
+    else {
+        query.filter='';
+    }
+    getPage();
+    console.log('filtering');
+  }),
+  gridOptions: mygridOptions
+  };
+
+}
+]);
+app.controller('MainCtrl',['$scope', 'transcriptome', function($scope,transcriptome) {
+    $scope.gridOptions=transcriptome.gridOptions;
+    $scope.filter=transcriptome.filter;
+}
+]);