# -*- coding: utf-8 -*-
import sys
import os
def CreateHtml(tableId, dataType, fPath, rows, titles, pos):
logstr = ""
if len(rows) != 0:
periodRain = str(rows[-1][4]-rows[0][4])
selectedPeriod = str(rows[0][0])+' - '+str(rows[-1][0])
r_start = rows[0][4]
r_prev = 0
lrows = []
for row in rows:
lrow = list(row)
r_tmp = lrow[4]
if lrow[4] == r_start: #if first row
lrow[4] = lrow[4] - r_start
else:
lrow[4] = lrow[4] - r_prev
r_prev = r_tmp
lrows.append(lrow)
rows = lrows
# convert the data into a table
chart_table=""
for row in rows[:-1]:
rowstr="['{0}', {1}],\n".format(str(row[4]),str(row[pos]))
chart_table+=rowstr
row=rows[-1]
rowstr="['{0}', {1}],\n".format(str(row[4]),str(row[pos]))
chart_table+=rowstr
table=chart_table
else:
print "No data found"
return
# start creating the html page
logstr += ""+'\n\r'
logstr += ""+'\n\r'
logstr += " "+'\n\r'
logstr += " "+'\n\r'
# google chart snippet
c_code_1 = """
"""
c_code = c_code_1+c_code_2+c_code_3+'"'+c_code_4+'"'+c_code_5
logstr += c_code % (table)
logstr += '\n\r'
logstr += ""+'\n\r'
logstr += ""+'\n\r'
logstr += "EventGhost Climate Data Calculation Graph
"+'\n\r'
logstr += "
"+'\n\r'
logstr += ""+tableId+"
"+'\n\r'
logstr += "Selected period: "+selectedPeriod+"
"+'\n\r'
logstr += "Total rain during period: "+periodRain+" mm
"+'\n\r'
logstr += ''+'\n\r'
logstr += ""+'\n\r'
logstr += ""+'\n\r'
fName = tableId+'.html'
fileHandle = None
if not os.path.exists(fPath) and not os.path.isdir(fPath):
os.makedirs(fPath)
fileHandle = open(fPath+'/'+fName, 'a')
fileHandle.seek(0)
fileHandle.truncate()
fileHandle.write(logstr.encode('utf-8'))
fileHandle.close()