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

cgitb.enable()

cookie = dapr.get_cookies()

#dapr.loadConfiguration()

def pass_val_to_js(id,val):
    input_str=""" 
    <input type="hidden" value="%s" id="%s" />
    """%(val,id)
    return(input_str)

if 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
    ceid = cookie["ck_eid"].value
    
    form = cgi.FieldStorage()
    
    eid = form.getvalue('exp')

    nuname = form.getvalue("uname")
    nbid = form.getvalue("bid")
    
    proj = form.getvalue('project')
    study = form.getvalue('study')
    
    #if exp is set on the drop down, then filter by exp 
    # exp in the cookie will always be set, so I need to test before the cookie value is transfered to eid
    #   if not, but study is set, then filter by study
    #       if not, but project is set, then filter by project
    #
    # full query: 
    #"""select * from BEDfile b where bid in 
    #    (select bid from ExperimentBEDfile where eid in 
    #        (select eid from StudyExperiment where sid in 
    #            (select sid from ProjectStudy where prid= %s )))"""
    
    
    select_clause="""select b.bid, location, b.name, w.name, c.name, description1, peaknumber, uploader, upload_date, bedtoolcommand
        from BEDfile b """
    where_clause=" "
    join_clause=""" join WetlabMethod w using(wmid)
        join ComputationalMethod c using(cmid) 
        """
    orderby_clause=""" order by upload_date desc, b.name asc"""
    
    if eid and eid!= "0" :
        where_clause=where_clause+"""where bid in 
        (select bid from ExperimentBEDfile where eid = %s)"""%eid
    elif study and study != "0" :
        where_clause=where_clause+"""where bid in 
        (select bid from ExperimentBEDfile where eid in 
            (select eid from StudyExperiment where sid = %s))"""%study
    elif proj and proj != "0":
        where_clause=where_clause+"""where bid in
        (select bid from ExperimentBEDfile where eid in 
            (select eid from StudyExperiment where sid in 
                (select sid from ProjectStudy where prid= %s )))"""%proj
    
    #TODO: add admin filter
    
    get_bed_query=select_clause+join_clause+where_clause+orderby_clause
    
    #form eid takes precedence over cookie eid
    #and we want to save it to the cookie
    if eid and eid != "0" :
        cookie["ck_eid"]=eid
        print(cookie)
    else:
        if ceid != "0":
            eid=ceid
        else:
            eid_error_flag=True
            eid_error="there is no experiment set"
    
    
    # #for debugging
    # print("Content-type: text/html\n")
    # print("proj "+proj)
    # print("study "+study)
    # print("eid "+eid)
    # print("ceid "+ceid)
    
    
    db=dapr.DBConnection()

    qexname = "select title from Experiment where eid = '%s'" % eid    
    exname = db.runQuery(qexname)[0][0]
    
    
    print("Content-type: text/html\n")
    print(pass_val_to_js("pass_proj",proj))
    print(pass_val_to_js("pass_study",study))
    print(pass_val_to_js("pass_eid",eid))
    
    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="../../dapr_test/js/BEDfunctions.js">
    </script>
    
    """)

    dapr.phead(name, admin)
    print("""<div class="container">""")
    
    print("""<div class="lead">
    <h1 class="well" align="center"><b>BEDtools</b></h1>
    </div>
     """)
    
    ### separate the python from the HTML
    # form HTML and js was copied from upload_v0.2.py    
    
    print("""
    <form class="form-horizontal" action='./BEDfunctions.py' method ='post' >
<fieldset>

<!-- Form Name -->
<legend>Select BED files for analysis</legend>

<!-- Select Basic -->
<div class="form-group">
  <label class="col-md-4 control-label" for="project">Project</label>
  <div class="col-md-4">
    <select id="project" name="project" class="form-control">
    </select>
  </div>
</div>

<!-- Select Basic -->
<div class="form-group">
  <label class="col-md-4 control-label" for="study">Study</label>
  <div class="col-md-4">
    <select id="study" name="study" class="form-control">
    </select>
  </div>
</div>

<!-- Select Basic -->
<div class="form-group">
  <label class="col-md-4 control-label" for="exp">Experiment</label>
  <div class="col-md-4">
    <select id="exp" name="exp" class="form-control">
    </select>
  </div>
</div>
<div class="text-center">
<input type="submit" value="Get BED files" class="btn btn-lg btn-default"/>
</div>

</fieldset>
</form>

    """)
    
    
    res1 = db.runQuery(get_bed_query)
    
    if len(res1) > 0:
        print("""
        <div id="bedfiles"><div class="datagrid"><table id="example" class="display" cellspacing="0" width="100%">
          <thead>
                 <tr>
                     <th></th>
                     <th>ID</th>
                     <th>BED file</th>
                     <th>Wetlab method</th>
                     <th>Computational method</th>
                     <th>Info1</th>
                     <th>Peak Number</th>
                     <th>Uploader</th>
                     <th>Upload time</th>
                     <th>bedtools command</th>
                     <th>Download</th>
                   </tr></thead><tbody>"""
                   )
        n1 = len(res1)
        for i in range(n1):
            row = res1[i]

            print("""<td><input name ="input" class="input" type="checkbox"/></td>""")

            
            for j in range(len(row)):
                if j == 0 or j == 2:
                    print("""<td><a href="./bedinfo.py?bid=%s">%s</a></td>""" % (str(row[0]),str(row[j])))
                elif j == 1:
                    pass
                else:
                    print("<td>%s</td>" % str(row[j]))
            
            print("""<td><a href="%s">Download</a></td></tr>""" % row[1])
        print("</tbody>")
        print("</table></div></div></br></br>")
        
    
    
    print(""" 
    <b><h3>Pick your tool for analysis:</h3></b>
    </br>
    <p><b style="color:red ! important">Note: Please select experiment using dropdowns at the top of the page BEFORE selecting tool!</b></p>
    <b>Analysis tool: </b><select name='tool' id="tool-select";>
                     <option>-- please select an analysis tool-- </option>
                     <option id='intersect'>Bedtools Intersect(2)</option>
                     <option id='copy'>Copy a file(1)</option>
                     <option id='closest'>Bedtools Closest(2)</option>
                     <option id='intersect-v'>Bedtools No Overlap(2)</option>
                     <option id='intersect-wao'>Bedtools Combine and Overlap(2)</option>
                     <option id='window-w'>Bedtools Overlap Windows by 10000bp(2)</option>
                     <option id='jaccard'>Bedtools Jaccard(2)</option>
        </select>
        </br>
        </br>
    <div class="tool-button">
    <p><input type="button" value="Select Analysis Tool" class="btn btn-lg btn-default" id="submit-tool"></p>
    </div>
        
        </br>
        </br>
        <div class="tool-description">
        </div>
        

    """)
    
    
    
    ##TODO make this work for each row rather than one section at the bottom 
    print("""
    <br/>
    <p class="lead"><b>Delete a BED file:</b></p>
    <p><b style="color:red ! important">Note: This CANNOT be undone.</b></p>
    <p>Please select ONE BED file using checkboxes.</p>
    <p><input type="button" value="Delete BED file" class="btn btn-lg btn-default" id="remove"></p>
    <br/>
    </div>
    </div>
    """)

    ## code for bed copy
    if nbid != None:
        q2 = """select wmid,cmid,name,location,description1,description2,description3,bedtoolcommand, stringency, source from BEDfile where bid = "%s";"""%bid
        q3 = """select bid from BEDfile order by bid DESC limit 1;"""
        q4 = """select eid from Experiment where title = "%s";"""%eid
        add_new = db.runQuery(q2)
        nbid = db.runQuery(q3)
        neid = db.runQuery(q4)
        name = add_new[0][2] + "_" + str(nbid)
        Copy(nbid,name, add_new[0][3], add_new[0][4], add_new[0][5], add_new[0][6], add_new[0][7], nuname, add_new[0][1], add_new[0][0],add_new[0][8], add_new[0][9],neid)
     
    dapr.ptail()
    

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