#!/usr/local/bin/python3.3
import cgi
import cgitb
import pymysql
import datetime
import gviz_api
import DAPRfunctions as dapr
import DAPRfunctionsBED as daprBED

#dapr.loadConfiguration()

cookie = dapr.get_cookies()
db = dapr.DBConnection()

cgitb.enable()

if cookie:
    print(cookie)
    fname = cookie["fname"].value
    lname = cookie["lname"].value
    name = " ".join((fname, lname))
    admin = cookie["admin"].value
    uid = cookie["uid"].value
    uname = cookie["uname"].value
    
    
    form = cgi.FieldStorage()
    
    bid = form.getvalue('bid')
    bed = daprBED.BEDfile(bid)

    
     
    print("Content-type: text/html\n")
    dapr.phead(name, admin)
    
    print("""
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js">
    </script>
    
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js">
    </script>
    
    <script type="text/javascript" src="../../dapr_test/js/bedinfo.js">
    </script>
    """)
    
    print("""<div class="container">""")
    
    if admin == "1":
        print('<li style="float: right; color:red ! important;">admin</li><br/>')
    
    print("""
        
    <div class="page-header">
    <h1>BED Details</h1>      
    </div>
    
    <div class="panel panel-default" >
      <div class="panel-heading">Metrics</div>
      <div class="panel-body" id="BEDmetrics">
      
          <div class="row">
          <div class="col-md-5" style="background-color:white;">
                <div id="chart_div_1" ></div>
          </div>
          <div class="col-md-5" style="background-color:white;">
                <div id="chart_div_2" ></div>
          </div>
          </div>
          
          <div class="row">
          <div class="col-md-5" style="background-color:white;">
                <div id="chart_div_3" ></div>
          </div>
          <div class="col-md-5" style="background-color:white;">
                <div id="chart_div_4" ></div>
          </div>
          </div>

      </div>
    </div>
    
    <div class="panel panel-default" >
      <div class="panel-heading">BED File Contents</div>
      <div class="panel-body" id="BEDcontents">Panel Content</div>
    </div>
    
    <div class="text-center">
        <button type="button" class="btn btn-default">
        Print Report
        </button>
    
    </div>
    
    """)

    print("""</div>""")    

    # print json variables to the page
    
    # print("""
    # <script type="text/javascript">
        # var bid="%s"
    # </script
    # """% bid)
    
    
    # add fields with data for js  
    #qcolnames="select fieldnames from BEDfile where bid=%s"%bid
    #(colnames_str,) = db.runQueryFetchOne(qcolnames)
    
    colnames_str=",".join(bed.colnames)
    
    print("""<input type="hidden" id="colnames" value="%s">
    """%colnames_str)
    print("""<input type="hidden" id="bid" value="%s">
    """%bid)
    
    
    
    dapr.ptail()

else:
    print("Location: login.py")
    print("Content-type: text/html\n")