From 9f76abc95859be4ce7b6b19d51b3b2844c04a197 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Tue, 8 Sep 2020 13:37:25 -0500
Subject: Changed regular and global search results table to use the new sort
 method that always places NAs at bottom, changed the Add to Collection
 button's color, and added something to the regular search page template to
 display alternative text if there are more than 50000 results *
 wqflask/wqflask/templates/gsearch_gene.html - Added natural-minus-na sort to
 certain columns and changed Add button color *
 wqflask/wqflask/templates/gsearch_pheno.html - Added natural-minus-na sort to
 certain columns and changed Add button color *
 wqflask/wqflask/templates/search_result_page.html - Added natural-minus-na
 sort to certain columns, changed Add button color, and added template logic
 that shows alternative text if there are more than 50,000 results

---
 wqflask/wqflask/templates/gsearch_gene.html       | 14 ++++-----
 wqflask/wqflask/templates/gsearch_pheno.html      | 14 ++++-----
 wqflask/wqflask/templates/search_result_page.html | 38 +++++++++++++----------
 3 files changed, 35 insertions(+), 31 deletions(-)

(limited to 'wqflask')

diff --git a/wqflask/wqflask/templates/gsearch_gene.html b/wqflask/wqflask/templates/gsearch_gene.html
index acb3ee75..478d6f5f 100644
--- a/wqflask/wqflask/templates/gsearch_gene.html
+++ b/wqflask/wqflask/templates/gsearch_gene.html
@@ -20,7 +20,7 @@
             <button class="btn btn-default" id="select_all"><span class="glyphicon glyphicon-ok"></span> Select All</button>
             <button class="btn btn-default" id="deselect_all"><span class="glyphicon glyphicon-remove"></span> Deselect All</button>
             <button class="btn btn-default" id="invert"><span class="glyphicon glyphicon-resize-vertical"></span> Invert</button>
-            <button class="btn btn-default" id="add" disabled ><span class="glyphicon glyphicon-plus-sign"></span> Add</button>
+            <button class="btn btn-success" id="add" disabled ><span class="glyphicon glyphicon-plus-sign"></span> Add</button>
             <input type="text" id="searchbox" class="form-control" style="width: 180px; display: inline;" placeholder="Search This Table For ...">
             <input type="text" id="select_top" class="form-control" style="width: 120px; display: inline;" placeholder="Select Top ...">
             <form id="export_form" method="POST" action="/export_traits_csv" style="display: inline;">
@@ -47,12 +47,12 @@
 
 {% block js %}
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='js_alt/md5.min.js') }}"></script>
-    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTables/js/jquery.dataTables.min.js') }}"></script>
     <script language="javascript" type="text/javascript" src="/static/new/js_external/jszip.min.js"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/plugins/sorting/natural.js') }}"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/colReorder/js/dataTables.colReorder.js') }}"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/colResize/dataTables.colResize.js') }}"></script>
+    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
 
     <script type='text/javascript'>
       var the_rows = {{ trait_list|safe }};
@@ -218,31 +218,31 @@
                     },
                     { 
                       'title': "Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "100px",
                       'data': "location_repr"
                     },
                     {
                       'title': "Mean",
-                      'type': "natural", 
+                      'type': "natural-minus-na",
                       'data': "mean",
                       'orderSequence': [ "desc", "asc"]
                     },
                     { 
                       'title': "Max<br>LRS<a href=\"http://genenetwork.org//glossary.html#LRS\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural", 
+                      'type': "natural-minus-na",
                       'data': "LRS_score_repr",
                       'orderSequence': [ "desc", "asc"]
                     },
                     { 
                       'title': "Max LRS<br>Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "100px",
                       'data': "max_lrs_text"
                     },
                     { 
                       'title': "Additive<br>Effect<a href=\"http://genenetwork.org//glossary.html#A\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "50px",
                       'data': "additive",
                       'orderSequence': [ "desc", "asc"]
diff --git a/wqflask/wqflask/templates/gsearch_pheno.html b/wqflask/wqflask/templates/gsearch_pheno.html
index 0a58952c..eb998d15 100644
--- a/wqflask/wqflask/templates/gsearch_pheno.html
+++ b/wqflask/wqflask/templates/gsearch_pheno.html
@@ -20,7 +20,7 @@
             <button class="btn btn-default" id="select_all"><span class="glyphicon glyphicon-ok"></span> Select All</button>
             <button class="btn btn-default" id="deselect_all"><span class="glyphicon glyphicon-remove"></span> Deselect All</button>
             <button class="btn btn-default" id="invert"><span class="glyphicon glyphicon-resize-vertical"></span> Invert</button>
-            <button class="btn btn-default" id="add" disabled ><span class="glyphicon glyphicon-plus-sign"></span> Add</button>
+            <button class="btn btn-success" id="add" disabled ><span class="glyphicon glyphicon-plus-sign"></span> Add</button>
             <input type="text" id="searchbox" class="form-control" style="width: 200px; display: inline;" placeholder="Search This Table For ...">
             <input type="text" id="select_top" class="form-control" style="width: 200px; display: inline;" placeholder="Select Top ...">
             <form id="export_form" method="POST" action="/export_traits_csv" style="display: inline;">
@@ -47,12 +47,12 @@
 
 {% block js %}
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='js_alt/md5.min.js') }}"></script>
-    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTables/js/jquery.dataTables.min.js') }}"></script>
     <script language="javascript" type="text/javascript" src="/static/new/js_external/jszip.min.js"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/plugins/sorting/natural.js') }}"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/colReorder/js/dataTables.colReorder.js') }}"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/colResize/dataTables.colResize.js') }}"></script>
+    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
 
     <script type='text/javascript'>
       var the_rows = {{ trait_list|safe }};
@@ -191,7 +191,7 @@
                     },
                     {
                       'title': "Mean",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "10%",
                       'data': "mean"
                     },
@@ -218,7 +218,7 @@
                     },
                     {
                       'title': "Year",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': null,
                       'orderDataType': "dom-inner-text",
                       'render': function(data, type, row, meta) {
@@ -232,19 +232,19 @@
                     },
                     {
                       'title': "Max LRS<a href=\"http://genenetwork.org//glossary.html#LRS\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': "LRS_score_repr",
                       'orderSequence': [ "desc", "asc"]
                     },
                     {
                       'title': "Max LRS Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "10%",
                       'data': "max_lrs_text"
                     },
                     {
                       'title': "Additive Effect<a href=\"http://genenetwork.org//glossary.html#A\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': "additive",
                       'orderSequence': [ "desc", "asc"]
                     }
diff --git a/wqflask/wqflask/templates/search_result_page.html b/wqflask/wqflask/templates/search_result_page.html
index 94e8de46..ff3d3be8 100644
--- a/wqflask/wqflask/templates/search_result_page.html
+++ b/wqflask/wqflask/templates/search_result_page.html
@@ -8,11 +8,12 @@
 {% endblock %}
 {% block content %}
 <!-- Start of body -->
-    <div style="padding-left: 10px;>
+    <div style="padding-left: 10px;">
         <input type="hidden" name="uc_id" id="uc_id" value="{{ uc_id }}">
 
         <div style="padding-top: 10px; padding-bottom: 10px; font-size: 16px;">
         <!-- Need to customize text more for other types of searches -->
+
         <p><b>Search Results:</b> We searched <a href="http://genenetwork.org/webqtl/main.py?FormID=sharinginfo&{% if dataset.accession_id != 'None' %}GN_AccessionId={{ dataset.accession_id }}{% else %}InfoPageName={{ dataset.name }}{% endif %}">{{ dataset.fullname }}</a>
            to find all records
                 {% if go_term is not none %}
@@ -47,8 +48,9 @@
                 {% endfor %}
                 {% endif %}
                 <br>
-                {{ results|count }} records are shown below.
+                A total of {{ results|count }} records were found.
         </p>
+
         {% if go_term is not none %}
         <p><b>The associated genes include:</b><br><br>{% for word in search_terms %}{{ word.search_term[0] }}{% endfor %}</p>
         {% endif %}
@@ -58,7 +60,9 @@
         <!--<hr style="height: 1px; background-color: #A9A9A9;">-->
 
         </div>
-
+        {% if too_many_results %}
+        <p>Your search generated over 50000 results. Please modify your search to generate 50000 or fewer matches.</p>
+        {% else %}
         <div style="min-width: 950px;">
           <form id="trait_submission_form" target="_blank" action="/corr_matrix" method="post">
             <input type="hidden" name="tool_used" value="" />
@@ -145,6 +149,7 @@
             </table>
           </div>
         </div>
+        {% endif %}
     </div>
 
     <div id="myModal"></div>
@@ -155,7 +160,6 @@
 
 {% block js %}
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='js_alt/md5.min.js') }}"></script>
-    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
 
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTables/js/jquery.dataTables.min.js') }}"></script>
     <script language="javascript" type="text/javascript" src="/static/new/js_external/jszip.min.js"></script>
@@ -163,6 +167,8 @@
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/buttons/js/dataTables.buttons.min.js') }}"></script>
     <script language="javascript" type="text/javascript" src="{{ url_for('js', filename='DataTablesExtensions/buttons/js/buttons.colVis.min.js') }}"></script>
 
+    <script language="javascript" type="text/javascript" src="/static/new/javascript/search_results.js"></script>
+
     <script type='text/javascript'>
         var trait_list = {{ trait_list|safe }};
     </script>
@@ -218,9 +224,7 @@
                 }
             }
 
-            console.time("Creating table");
             //ZS: Need to make sort by symbol, also need to make sure blank symbol fields at the bottom and symbols starting with numbers below letters
-
             $('#trait_table').DataTable( {
                 'drawCallback': function( settings ) {
                      $('#trait_table tr').click(function(event) {
@@ -314,33 +318,33 @@
                     },
                     {
                       'title': "Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "120px",
                       'data': "location"
                     },
                     {
                       'title': "Mean",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "40px",
                       'data': "mean",
                       'orderSequence': [ "desc", "asc"]
                     },
                     {
                       'title': "Max LRS<a href=\"http://genenetwork.org//glossary.html#LRS\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': "lrs_score",
                       'width': "80px",
                       'orderSequence': [ "desc", "asc"]
                     },
                     {
                       'title': "Max LRS Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "150px",
                       'data': "lrs_location"
                     },
                     {
                       'title': "Additive Effect<a href=\"http://genenetwork.org//glossary.html#A\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': "additive",
                       'width': "120px",
                       'orderSequence': [ "desc", "asc"]
@@ -360,7 +364,7 @@
                     },
                     {
                       'title': "Mean",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "110px",
                       'data': "mean",
                       'orderSequence': [ "desc", "asc"]
@@ -387,7 +391,7 @@
                     },
                     {
                       'title': "Year",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'orderDataType': "dom-inner-text",
                       'data': null,
                       'width': "80px",
@@ -402,27 +406,27 @@
                     },
                     {
                       'title': "Max LRS<a href=\"http://genenetwork.org//glossary.html#LRS\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'data': "lrs_score",
                       'width': "80px",
                       'orderSequence': [ "desc", "asc"]
                     },
                     {
                       'title': "Max LRS Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "150px",
                       'data': "lrs_location"
                     },
                     {
                       'title': "Additive Effect<a href=\"http://genenetwork.org//glossary.html#A\" target=\"_blank\" style=\"color: white;\"><sup>?</sup></a>",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "120px",
                       'data': "additive",
                       'orderSequence': [ "desc", "asc"]
                     }{% elif dataset.type == 'Geno' %},
                     {
                       'title': "Location",
-                      'type': "natural",
+                      'type': "natural-minus-na",
                       'width': "140px",
                       'data': "location"
                     }{% endif %}
-- 
cgit v1.2.3