Fetch sample/case names from database

Fetch the sample/case names from the database rather than from a
static file in the repository.

Issue:
https://issues.genenetwork.org/issues/quality-control/read-samples-from-database-by-species

1 files changed, 15 insertions, 2 deletions

diff --git a/qc_app/templates/index.html b/qc_app/templates/index.html
index a454dd2..358b521 100644
--- a/qc_app/templates/index.html
+++ b/qc_app/templates/index.html
@@ -1,4 +1,5 @@
 {%extends "base.html"%}
+{%from "flash_messages.html" import flash_all_messages%}
 
 {%block title%}Data Upload{%endblock%}
 
@@ -55,6 +56,18 @@
   {%endwith%}
 
   <fieldset>
+    <label for="select_species01">Species</label>
+    <select id="select_species01"
+	    name="speciesid"
+	    required="required">
+      <option value="">Select species</option>
+      {%for aspecies in species%}
+      <option value="{{aspecies.SpeciesId}}">{{aspecies.MenuName}}</option>
+      {%endfor%}
+    </select>
+  </fieldset>
+
+  <fieldset>
     <legend>file type</legend>
 
     <input type="radio" name="filetype" value="average" id="filetype_average"
@@ -111,8 +124,8 @@
 <form method="POST" action="{{url_for('samples.select_species')}}">
   <legend class="heading">upload samples</legend>
   <fieldset>
-    <label for="select:species">Species</label>
-    <select id="select:species" name="species_id" required="required">
+    <label for="select_species02">Species</label>
+    <select id="select_species02" name="species_id" required="required">
       <option value="">Select species</option>
       {%for spec in species%}
       <option value="{{spec.SpeciesId}}">{{spec.MenuName}}</option>