def seewhatwehave(request):
smid = get_sm_id(request)
if smid is None:
return pd.DataFrame(), pd.DataFrame(), ''
df = loadDataFromDb(f"select * from sm_accounts where session_id = '{smid}' and active='1' order by type_id", returndf=True)
df['type'] = df['type_id'].map({0: 'Electricity', 1: 'Gas', 2:'Electricity Export'})
df['source_id'].fillna(0, inplace=True)
df['source'] = df['source_id'].map({0: 'n3rgy', 1: 'Octopus'})
s = f"""
select sm_accounts.account_id, sm_accounts.type_id, sm_periods.period from sm_accounts
left join sm_periods on sm_periods.period between sm_accounts.first_period and sm_accounts.last_period
left join sm_quantity on sm_quantity.period_id=sm_periods.period_id and sm_quantity.account_id= sm_accounts.account_id
where sm_quantity.quantity is null and sm_accounts.session_id='{smid}' and sm_accounts.active='1'
"""
df_gaps = loadDataFromDb(s, returndf=True)
df2 = df_gaps.groupby('account_id').count()
df['gaps'] = df.account_id.map(df2.period)
df.gaps.fillna(0, inplace=True)
df_gaps.sort_values(['type_id','period'], ascending=[True, False], inplace=True)
s3 = '<P>All times on this page are in UTC.</P><TABLE><TR><TH>ID</TH><TH>Type</TH><TH>First Period</TH><TH>Last Period</TH><TH>Gaps</TH><TH>Last Updated</TH><TH>Source</TH></TR>'
for i, j in df.iterrows():
s3a = '<TR><TD>{}</TD><TD>{}</TD><TD>{}</TD><TD>{}</TD><TD>{}</TD><TD>{}</TD><TD>{}</TD></TR>'
g = '0' if j.gaps == 0 else '{:.0f}'.format(j.gaps)
s3 += s3a.format(j.account_id, j.type, j.first_period, j.last_period, g, str(j.last_updated)[:16], j.source)
s3 += '</TABLE><BR>'
return df, df_gaps, s3
def homepage(request):
urladmin = request.get_full_path().replace('home', 'admin', 1)
smid = get_sm_id(request)
if smid is not None:
sql = f"select type_id, first_period, last_period, source_id, region from sm_accounts where session_id= '{smid}' and active='1' order by type_id;"
df = loadDataFromDb(sql, returndf=True)
else:
df = pd.DataFrame()
s = """<P>This website allows UK energy customers with smart meters to access their energy consumption data,
and to perform a range of calculations on the back of this, for example reconciling bills and tracking carbon intensity. </P>"""
u = request.get_full_path().replace('home', 'getstarting')
s += f'<P>If you are new to this site, I recommend taking a look at the <A HREF="{u}">Getting Started</A> page.</P>'
if isdemo(request):
if df.shape[0] == 0:
s += """<P>You are running this in demo mode (ie without a key), which is designed to show you the functionality with
data from a made up user. Unfortunately for some reason, the server is missing the data for the made up user. Please try
again later. Alternatively, you can load your own data from Octopus or n3rgy, by selecting the option from the dropdown list below: </P>
"""
else:
s += """<P>You are running this in demo mode (ie without a key), which is designed to show you the functionality with
electricity consumption data from a made up user. You can try out the functionality using this demo data.
Alternatively, you can load your own data from Octopus or n3rgy (which can include gas consumption or electricity export),
by selecting the option from the dropdown list below. </P>
"""
s += formforkeys(request)
else:
if df.shape[0] == 0:
s += f"""<P>The server no longer has the data for this user (it is deleted within 7 days of last being accessed).
You can load new data from Octopus or n3rgy on the <A HREF="{urladmin}">Admin Page</A>. </P>
"""
else:
s += """<P>The server has the following data for this user:</P>"""
s += homepagewhatwehave(request, df)
s += '</DIV>'
output = create_sm_page(request, s, 'Welcome')
return output
def netimportPage(request):
smid = get_sm_id(request)
start = request.GET.get('start', '2019-01-01')
end = request.GET.get('end','2025-12-01')
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
start = month + '-{:02d}'.format(day)
end = start
endstr = """
select local_date, local_time as local_time_start, timezone_adj, import as total_import, export as total_export
from fulldata order by period"""
else:
endstr = f"""
select local_date as day, count(period_id) as numperiods, sum(import) as total_import, sum(export) as total_export
from fulldata where date_trunc('month', local_date)='{month}-01'
group by local_date order by local_date"""
else:
endstr = f"""
select date_trunc('month',local_date) as month, count(period_id) as numperiods,
sum(import) as total_import,
sum(export) as total_export
from fulldata group by month order by month"""
s = f'''
with periods as (select * from sm_periods where local_date between '{start}' and '{end}' )
, quantities1 as ({quantitystr(smid, 0)})
, quantities2 as ({quantitystr(smid, 2)})
, full1 as
(select periods.*, quantities1.quantity
from periods inner join quantities1 on periods.period_id=quantities1.period_id order by 1)
, full2 as
(select periods.*, quantities2.quantity
from periods inner join quantities2 on periods.period_id=quantities2.period_id order by 1)
, fulldata as
(select full2.*, coalesce(full1.quantity,0) as import, coalesce(full2.quantity,0) as export
from full2 left outer join full1 on full2.period_id=full1.period_id)
{endstr}
'''
data = loadDataFromDb(s, returndf=True)
url = request.get_full_path()
if data.shape[0]==0:
return nodata(request)
#raise Exception(request.GET)
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
heading = 'Half-hourly Net Import on {}-{:02d}'.format(month, day)
navbar = getnavbar(request)
description = f'Import and export for each half hour (in kWh, labels are start-times, in local time)'
labels = str(data['local_time_start'].tolist())
imports = str(['{:.2f}'.format(x) for x in data['total_import'].values])
exports = str(['{:.2f}'.format(x) for x in data['total_export'].values])
table = '<TABLE><TR><TH>Total Import</TH><TD>{:.3f}</TD></TR>'.format(data.total_import.sum())
table += '<TR><TH>Total Export</TH><TD>{:.3f}</TD></TR>'.format(data.total_export.sum())
table += '<TR><TH>Total Net Import</TH><TD>{:.3f}</TD></TR></TABLE>'.format(data.total_import.sum()-data.total_export.sum())
table += '<BR><TABLE><TR><TH>Period Start</TH><TH>Import</TH><TH>Export</TH><TH>Net Import</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD>{}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD></TR>'
table += t.format(j.local_time_start, j.total_import, j.total_export, j.total_import-j.total_export)
table += '</TABLE>'
else:
heading = 'Daily Net Import for {}'.format(month)
navbar = getnavbar(request)
description = f"Daily import and export (in kWh) for each day"
labels = str([x.strftime('%d %b') for x in data['day'].tolist()])
imports = str(['{:.2f}'.format(x) for x in data.total_import.tolist()])
exports = str(['{:.2f}'.format(x) for x in data.total_export.tolist()])
table = '<TABLE><TR><TH>Total Import</TH><TD>{:.3f}</TD></TR>'.format(data.total_import.sum())
table += '<TR><TH>Total Export</TH><TD>{:.3f}</TD></TR>'.format(data.total_export.sum())
table += '<TR><TH>Total Net Import</TH><TD>{:.3f}</TD></TR></TABLE>'.format(data.total_import.sum()-data.total_export.sum())
table += '<BR><TABLE><TR><TH>Day</TH><TH>Import</TH><TH>Export</TH><TH>Net Import</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD></TR>'
table += t.format(adj_url(url, [],[('day',j.day.day)]),
j.day.strftime('%a %b %d'), j.total_import, j.total_export, j.total_import-j.total_export)
table += '</TABLE>'
else:
heading = 'Monthly Net Import'
navbar = getnavbar(request)
description = f"Monthly import and export (in kWh) for each month:"
labels = str([x.strftime('%b-%Y') for x in data['month'].tolist()])
imports = str(['{:.2f}'.format(x) for x in data.total_import.tolist()])
exports = str(['{:.2f}'.format(x) for x in data.total_export.tolist()])
table = '<TABLE><TR><TH>Total Import</TH><TD>{:.3f}</TD></TR>'.format(data.total_import.sum())
table += '<TR><TH>Total Export</TH><TD>{:.3f}</TD></TR>'.format(data.total_export.sum())
table += '<TR><TH>Net Import</TH><TD>{:.3f}</TD></TR></TABLE>'.format(data.total_import.sum()-data.total_export.sum())
table += '<BR><TABLE><TR><TH>Month</TH><TH>Total<BR>Import</TH><TH>Total<BR>Export</TH><TH>Net<BR>Import</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD></TR>'
table += t.format(adj_url(url, [],[('month',j.month.strftime('%Y-%m'))]),
j.month.strftime('%b %Y'), j.total_import, j.total_export, j.total_import-j.total_export)
table += '</TABLE>'
#raise Exception
if 'chartscale' in request.GET:
c = request.GET.get('chartscale').split(',')
chartscale = f'min: {c[0]}, '
if len(c)>1:
chartscale += f'max: {c[1]}, '
else:
chartscale = 'suggestedMin: 0'
with open(os.path.dirname(os.path.realpath(__file__)) + "/templates/chart_template3.html", "r") as f:
inner = f.read()
kwargs = {'navbar': navbar ,
'description': description,
'chartlabels': labels,
'imports': imports,
'exports': exports,
'table': table+'<BR>',
'chartscale': chartscale,
}
for k, v in kwargs.items():
inner = inner.replace('{' + k + '}', v)
output = create_sm_page(request, inner, heading)
return output
def emissionsPage(request):
smid = get_sm_id(request)
url = request.get_full_path()
start = request.GET.get('start', '2018-01-01')
end = request.GET.get('end','2025-01-01')
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
start = month + '-{:02d}'.format(day)
endstr = f"""
select period local_date, local_time, prof_qty*intensity prof_emis,
prof_qty, actual_qty*intensity actual_emis, actual_qty
from fulldata where local_date='{start}'
order by period"""
else:
endstr = f"""
select local_date, sum(prof_qty*intensity) prof_emis,
sum(prof_qty) prof_qty, sum(actual_qty*intensity) actual_emis, sum(actual_qty) actual_qty
from fulldata
where date_trunc('month', local_date)='{month}-01'
group by local_date
order by local_date"""
else:
endstr = """
select date_trunc('month', local_date) as month, sum(prof_qty*intensity) prof_emis,
sum(prof_qty) prof_qty, sum(actual_qty*intensity) actual_emis, sum(actual_qty) actual_qty
from fulldata
group by month
order by month"""
s = f'''
with periods as (select * from sm_periods where local_date between '{start}' and '{end}' )
, quantities as ({quantitystr(smid, 0)})
, emis as (select period_id, value from sm_hh_variable_vals v
inner join sm_variables var on v.var_id=var.var_id and var.product='CO2_National')
, prof as (select period_id, value from sm_hh_variable_vals v
inner join sm_variables var on v.var_id=var.var_id and var.product='Profile_1')
, fulldata as
(select periods.*, emis.value intensity, prof.value prof_qty, coalesce(quantities.quantity, 0) actual_qty
from periods inner join emis on periods.period_id=emis.period_id
inner join prof on periods.period_id=prof.period_id
left outer join quantities on periods.period_id=quantities.period_id)
{endstr}
'''
data = loadDataFromDb(s, returndf=True)
if data.shape[0]==0:
return nodata(request)
data['prof_intensity'] = data.prof_emis/data.prof_qty
data['actual_intensity'] = np.where(data.actual_qty==0, data.prof_intensity, data.actual_emis/data.actual_qty)
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
data['prof_emis'] = data.prof_emis*data.actual_qty.sum()/data.prof_qty.sum()
data['prof_qty'] = data.prof_qty*data.actual_qty.sum()/data.prof_qty.sum()
day = int(request.GET.get('day'))
heading = 'Half-hourly Carbon Intensity on {}-{:02d}'.format(month, day)
navbar = getnavbar(request)
description = 'Carbon intensity for average domestic profile and this customer in g/kwh for each half hour (labels are start-times, in local time). '
labels = str(data['local_time'].tolist())
profile = str(['{:.2f}'.format(x) for x in data['prof_qty'].values])
actual = str(['{:.2f}'.format(x) for x in data['actual_qty'].values])
intensity = str(['{:.2f}'.format(x) for x in data['prof_intensity'].values])
avg = data.prof_emis.sum()/data.prof_qty.sum()
table = '<TABLE><TR><TH>Average Domestic Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
if data.actual_qty.sum()>0:
avg = data.actual_emis.sum()/data.actual_qty.sum()
table += '<TR><TH>Your Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
table += '<TR><TH>Your Emissions (kg)</TH><TD>{:.2f}</TD></TR></TABLE>'.format(data.actual_emis.sum()/1000)
table += '<BR><TABLE><TR><TH>Period Start</TH><TH>Intensity</TH><TH>Avg Domestic<BR>Consumption</TH><TH>Your<BR>Consumption</TH><TH>Your<BR>Emissions</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD>{}</TD><TD>{:.0f}</TD><TD>{:.2f}</TD><TD>{:.2f}</TD><TD>{:.2f}</TD></TR>'
table += t.format(j.local_time, j.prof_intensity, j.prof_qty, j.actual_qty, j.actual_emis/1000 )
table += '</TABLE>'
else:
heading = 'Daily Carbon Intensity for {}'.format( month)
navbar = getnavbar(request)
description = "Carbon intensity for average domestic profile and this customer in g/kwh for each day."
labels = str([x.strftime('%d %b') for x in data['local_date'].tolist()])
profile = str(['{:.2f}'.format(x) for x in data['prof_intensity'].values])
actual = str(['{:.2f}'.format(x) for x in data['actual_intensity'].values])
avg = data.prof_emis.sum()/data.prof_qty.sum()
table = '<TABLE><TR><TH>Average Domestic Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
if data.actual_qty.sum()>0:
avg = data.actual_emis.sum()/data.actual_qty.sum()
table += '<TR><TH>Your Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
table += '<TR><TH>Your Consumption (kwh)</TH><TD>{:.1f}</TD></TR>'.format(data.actual_qty.sum())
table += '<TR><TH>Your Emissions (kg)</TH><TD>{:.1f}</TD></TR></TABLE>'.format(data.actual_emis.sum()/1000)
table += '<BR><TABLE><TR><TH>Day</TH><TH>Avg Domestic Intensity</TH><TH>Your Intensity</TH><TH>Your Consumption</TH><TH>Your Emissions</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.1f}</TD><TD>{:.1f}</TD><TD>{:.1f}</TD><TD>{:.1f}</TD></TR>'
table += t.format(adj_url(url, [],[('day',j.local_date.day)]),
j.local_date.strftime('%a %b %d'), j.prof_intensity, j.actual_intensity, j.actual_qty, j.actual_emis/1000)
table += '</TABLE>'
else:
heading = 'Monthly Carbon Intensity'
navbar = getnavbar(request)
description = "Carbon intensity for average domestic profile and this customer in g/kwh for each month"
labels = str([x.strftime('%b-%Y') for x in data['month'].tolist()])
profile = str(['{:.1f}'.format(x) for x in data['prof_intensity'].values])
actual = str(['{:.1f}'.format(x) for x in data['actual_intensity'].values])
avg = data.prof_emis.sum()/data.prof_qty.sum()
table = '<TABLE><TR><TH>Average Domestic Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
if data.actual_qty.sum()>0:
avg = data.actual_emis.sum()/data.actual_qty.sum()
table += '<TR><TH>Your Intensity (g/kwh)</TH><TD>{:.1f}</TD></TR>'.format(avg)
table += '<TR><TH>Your Consumption (kwh)</TH><TD>{:.1f}</TD></TR>'.format(data.actual_qty.sum())
table += '<TR><TH>Your Emissions (kg)</TH><TD>{:.1f}</TD></TR></TABLE>'.format(data.actual_emis.sum()/1000)
table += '<BR><TABLE><TR><TH>Month</TH><TH>Avg Domestic<BR>Intensity</TH><TH>Your<BR>Intensity</TH>'
table += '<TH>Your<BR>Consumption</TH><TH>Your Emissions</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.1f}</TD><TD>{:.1f}</TD><TD>{:.1f}</TD><TD>{:.1f}</TD></TR>'
table += t.format(adj_url(url, [],[('month',j.month.strftime('%Y-%m'))]),
j.month.strftime('%b %Y'), j.prof_intensity, j.actual_intensity, j.actual_qty, j.actual_emis/1000)
table += '</TABLE>'
kwargs = {'navbar': navbar,
'description': description,
'chartlabels': labels,
'profile': profile,
'actual': actual,
'table': table + '<BR><BR>'
}
if 'day' in request.GET:
with open(os.path.dirname(os.path.realpath(__file__)) + "/templates/chart_emis2.html", "r") as f:
inner = f.read()
kwargs['intensity'] = intensity
else:
with open(os.path.dirname(os.path.realpath(__file__)) + "/templates/chart_emis.html", "r") as f:
inner = f.read()
for k, v in kwargs.items():
inner = inner.replace('{' + k + '}', v)
output = create_sm_page(request, inner, heading)
return output
def costPage(request, choice):
type_id = type_ids[choice]
prefix = ['','gas','export'][type_id]
smid = get_sm_id(request)
vat = 1 if type_id==2 else 1.05
isfixed, pricestr = parsetariff(request, request.GET.get(prefix+'tariff'), type_id, vat)
has_pricebands = isfixed & (type_id==0)
start = request.GET.get('start', '2018-01-01')
end = request.GET.get('end','2025-01-01')
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
start = month + '-{:02d}'.format(day)
end = start
endstr = """
select local_date, local_time as local_time_start, timezone_adj, quantity as total_quantity,
value as price, quantity*value as total_cost
from fulldata order by period"""
else:
if has_pricebands:
endstr = f"""
select local_date as day, count(period_id) as numperiods, sum(quantity) as total_quantity,
sum(value)/count(value) as price, sum(quantity*value) as total_cost
from fulldata where date_trunc('month', local_date)='{month}-01'
group by local_date, value order by local_date"""
else:
endstr = f"""
select local_date as day, count(period_id) as numperiods, sum(quantity) as total_quantity,
sum(value)/count(value) as price, sum(quantity*value) as total_cost
from fulldata where date_trunc('month', local_date)='{month}-01'
group by local_date order by local_date"""
else:
if has_pricebands:
endstr = f"""
select date_trunc('month',local_date) as month, count(period_id) as numperiods,
sum(value)/count(value) as price, sum(quantity) as total_quantity, sum(quantity*value) as total_cost
from fulldata group by month, value order by month"""
else:
endstr = f"""
select date_trunc('month',local_date) as month, count(period_id) as numperiods,
sum(value)/count(value) as price, sum(quantity) as total_quantity, sum(quantity*value) as total_cost
from fulldata group by month order by month"""
s = f'''
with periods as (select * from sm_periods where local_date between '{start}' and '{end}' )
, prices as ({pricestr} )
, quantities as ({quantitystr(smid, type_id)})
, fulldata as
(select periods.*, quantities.quantity, prices.value
from periods inner join quantities on periods.period_id=quantities.period_id
inner join prices on periods.period_id=prices.period_id)
{endstr}
'''
data = loadDataFromDb(s, returndf=True)
url = request.get_full_path()
type = ['electricity cost','gas cost','export revenue'][type_id]
costrev = 'revenue' if type_id==2 else 'cost'
if data.shape[0]==0:
return nodata(request)
if type_id==1:
gasmult = float(request.GET.get('gasmult', '1'))
data['total_quantity']*=gasmult
data['total_cost']*=gasmult
if gasmult == 1:
gaswarn = '<BR><P><B>These results do not include any <A HREF="https://www.theenergyshop.com/guides/how-to-convert-gas-units-to-kwh" target="_blank">gas conversion from m3 to kwh</A>. If your meter is SMETS2, you should most likely include a parameter gasmult=11.18 or thereabouts.</B>'
elif 10<gasmult<12:
gaswarn = '<BR><P>These results are based on a gas conversion of {}kwh per m3. This factor can be adjusted in the url. This conversion should not be applied if your meter is SMETS1.</P>'.format(gasmult)
else:
gaswarn = '<BR><B>These results are based on a gas conversion of {}kwh per m3. This factor appears wrong.</B> It <A HREF="https://www.theenergyshop.com/guides/how-to-convert-gas-units-to-kwh" target="_blank"> should be around 11.18</A>, based on a volume correction factor of 1.02264, a calorific value of about 40, and dividing by the kwh to joule conversion of 3.6. Your latest bill should show the applicable conversions.'.format(gasmult)
else: gaswarn = ''
if has_pricebands:
data['price'] = data['price'].astype(float)
if 'day' not in request.GET:
if 'month' not in request.GET:
volumes_by_price = data.groupby(['month','price']).sum().total_quantity.unstack()
data = data.groupby('month').sum().reset_index()
else:
volumes_by_price = data.groupby(['day','price']).sum().total_quantity.unstack()
data = data.groupby('day').sum().reset_index()
if len(volumes_by_price.columns)>1:
volumes_by_price.rename(columns={x: x*vat for x in volumes_by_price.columns}, inplace=True)
#volumes_by_price.loc[:,:] = volumes_by_price.values / volumes_by_price.sum(axis=1).values.reshape(-1,1)
else:
has_pricebands = False
data['price'] = np.where(data.total_quantity==0, data.price, data.total_cost/data.total_quantity).astype(float)
data['total_cost'] *= vat
data['price'] *= vat
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
heading = 'Half-hourly {} on {}-{:02d}'.format(type.title(), month, day)
navbar = getnavbar(request)
description = f'{costrev.title()} in pence for each half hour (labels are start-times, in local time). '
labels = str(data['local_time_start'].tolist())
cost = str(['{:.2f}'.format(x) for x in data['total_cost'].values])
table = '<TABLE><TR><TH>Total Quantity (kwh)</TH><TD>{:.2f}</TD></TR>'.format(data.total_quantity.sum())
table += '<TR><TH>Total {} (£)</TH><TD>{:.2f}</TD></TR>'.format(costrev.title(), data.total_cost.sum()/100)
avg = data.total_cost.sum()/data.total_quantity.sum()
table += '<TR><TH>Average Price (p/kwh)</TH><TD>{:.2f}</TD></TR></TABLE>'.format(avg)
table += f'<BR><TABLE><TR><TH>Period Start</TH><TH>Quantity</TH><TH>Price</TH><TH>{costrev.title()}</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD>{}</TD><TD>{:.3f}</TD><TD>{:.2f}</TD><TD>{:.2f}</TD></TR>'
table += t.format(j.local_time_start, j.total_quantity, j.price, j.total_cost )
table += '</TABLE>'
else:
heading = 'Daily {} for {}'.format(type.capitalize(), month)
navbar = getnavbar(request)
description = f"{costrev.title()} (in £) for each day. "
labels = str([x.strftime('%d %b') for x in data['day'].tolist()])
cost = str(['{:.2f}'.format(x/100) for x in data.total_cost.tolist()])
table = '<TABLE><TR><TH>Monthly Quantity (kwh)</TH><TD>{:.1f}</TD></TR>'.format(data.total_quantity.sum())
table += '<TR><TH>Total {} (£)</TH><TD>{:.2f}</TD></TR>'.format(costrev.title(), data.total_cost.sum()/100)
avg = 48*data.total_cost.sum()/data.numperiods.sum()/100
table += '<TR><TH>Avg Daily {} (£)</TH><TD>{:.2f}</TD></TR>'.format(costrev.title(), avg)
avg = 48*(data.total_quantity).sum()/data.numperiods.sum()
table += '<TR><TH>Avg Daily Quantity (kwh)</TH><TD>{:.2f}</TD></TR>'.format(avg)
avg = data.total_cost.sum()/data.total_quantity.sum()
table += '<TR><TH>Avg Price (p/kwh)</TH><TD>{:.2f}</TD></TR>'.format(avg)
if has_pricebands:
for p in volumes_by_price.columns:
table += f'<TR><TH>Pct Qty at {p}p/kWh</TH><TD>{volumes_by_price[p].sum()/volumes_by_price.values.sum():.0%}</TD></TR>'
table += '</TABLE>'
table += f'<BR><TABLE><TR><TH>Day</TH><TH>Quantity</TH><TH>{costrev.title()}</TH><TH>Average<BR>Price</TH>'
if has_pricebands:
for col in volumes_by_price.columns:
table += f'<TH>Qty at <BR>{col}</TH>'
table += '</TR>'
for i, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD>'
tablerow = t.format(adj_url(url, [],[('day',j.day.day)]),
j.day.strftime('%a %b %d'), j.total_quantity, j.total_cost/100, j.price)
if has_pricebands:
for col in volumes_by_price.columns:
tablerow += '<TD>{:.1%}</TD>'.format(volumes_by_price[col].iloc[i]/volumes_by_price.iloc[i].sum())
table += tablerow + '</TR>'
table += '</TABLE>'
else:
heading = 'Monthly {}'.format(type.capitalize())
navbar = getnavbar(request)
description = f"{costrev.title()} (in £) for each month. "
labels = str([x.strftime('%b-%Y') for x in data['month'].tolist()])
cost = str(['{:.2f}'.format(x/100) for x in data['total_cost'].tolist()])
table = '<TABLE><TR><TH>Total Quantity (kwh)</TH><TD>{:.1f}</TD></TR>'.format(data.total_quantity.sum())
table += '<TR><TH>Total {} (£)</TH><TD>{:.2f}</TD></TR>'.format(costrev.title(), data.total_cost.sum()/100)
avg = 48*data.total_cost.sum()/data.numperiods.sum()/100
table += '<TR><TH>Avg Daily {} (£)</TH><TD>{:.2f}</TD></TR>'.format(costrev.title(), avg)
avg = 48*(data.total_quantity).sum()/data.numperiods.sum()
table += '<TR><TH>Avg Daily Quantity (kwh)</TH><TD>{:.2f}</TD></TR>'.format(avg)
avg = data.total_cost.sum()/data.total_quantity.sum()
table += '<TR><TH>Avg Price (p/kwh)</TH><TD>{:.2f}</TD></TR>'.format(avg)
if has_pricebands:
for p in volumes_by_price.columns:
table += f'<TR><TH>Pct Qty at {p}p/kWh</TH><TD>{volumes_by_price[p].sum()/volumes_by_price.values.sum():.1%}</TD></TR>'
table += '</TABLE>'
table += f'<BR><TABLE><TR><TH>Month</TH><TH>Total<BR>Quantity</TH><TH>Total<BR>{costrev.title()}</TH>'
table += f'<TH>Daily<BR>{costrev.title()}</TH><TH>Daily<BR>Quantity</TH><TH>Average<BR>Price</TH>'
if has_pricebands:
for col in volumes_by_price.columns:
table += f'<TH>Qty at <BR>{col}</TH>'
table += '</TR>'
for i, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD><TD>{:.3f}</TD>'
dq = 48*(j.total_quantity/j.numperiods)
dc = 48*(j.total_cost/j.numperiods)/100
tablerow = t.format(adj_url(url, [],[('month',j.month.strftime('%Y-%m'))]),
j.month.strftime('%b %Y'), j.total_quantity, j.total_cost/100, dc, dq, j.price)
if has_pricebands:
for col in volumes_by_price.columns:
tablerow += '<TD>{:.1%}</TD>'.format(volumes_by_price[col].iloc[i]/volumes_by_price.iloc[i].sum())
table += tablerow + '</TR>'
table += '</TABLE>'
if type_id!=2:
description += 'All costs include 5% VAT and exclude standing charges. '
if 'chartscale' in request.GET:
c = request.GET.get('chartscale').split(',')
chartscale = f'min: {c[0]}, '
if len(c)>1:
chartscale += f'max: {c[1]}, '
else:
chartscale = 'suggestedMin: 0'
with open(os.path.dirname(os.path.realpath(__file__)) + "/templates/chart_template.html", "r") as f:
inner = f.read()
kwargs = {'navbar': navbar + gaswarn,
'description': description,
'chartlabels': labels,
'quantity': cost,
'table': table,
'chartscale': chartscale,
}
for k, v in kwargs.items():
inner = inner.replace('{' + k + '}', v)
output = create_sm_page(request, inner, heading)
return output
def consumptionPage(request, choice):
smid = get_sm_id(request)
type_id = type_ids[choice]
start = request.GET.get('start', '2018-01-01')
end = request.GET.get('end','2025-01-01')
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
start = month + '-{:02d}'.format(day)
end = start
endstr = """
select local_date, local_time as local_time_start, timezone_adj, quantity as total_quantity
from fulldata order by period"""
else:
endstr = f"""
select local_date as day, count(period_id) as numperiods, sum(quantity) as total_quantity
from fulldata where date_trunc('month', local_date)='{month}-01'
group by local_date order by local_date"""
else:
endstr = f"""
select date_trunc('month',local_date) as month, count(period_id) as numperiods,
sum(quantity) as total_quantity
from fulldata group by month order by month"""
s = f'''
with periods as (select * from sm_periods where local_date between '{start}' and '{end}' )
, quantities as ({quantitystr(smid, type_id)})
, fulldata as
(select periods.*, quantities.quantity
from periods inner join quantities on periods.period_id=quantities.period_id)
{endstr}
'''
data = loadDataFromDb(s, returndf=True)
url = request.get_full_path()
type = ['electricity consumption','gas consumption','electricity export'][type_id]
if data.shape[0]==0:
return nodata(request)
if type_id==1:
gasmult = float(request.GET.get('gasmult', '1'))
data['total_quantity']*=gasmult
if gasmult == 1:
gaswarn = '<BR><P><B>These results do not include any <A HREF="https://www.theenergyshop.com/guides/how-to-convert-gas-units-to-kwh" target="_blank">gas conversion from m3 to kwh</A>. If your meter is SMETS2, you should most likely include a parameter gasmult=11.18 or thereabouts.</B>'
elif 10<gasmult<12:
gaswarn = '<BR><P>These results are based on a gas conversion of {}kwh per m3. This factor can be adjusted in the url. This conversion should not be applied if your meter is SMETS1.</P>'.format(gasmult)
else:
gaswarn = '<BR><B>These results are based on a gas conversion of {}kwh per m3. This factor appears wrong.</B> It <A HREF="https://www.theenergyshop.com/guides/how-to-convert-gas-units-to-kwh" target="_blank"> should be around 11.18</A>, based on a volume correction factor of 1.02264, a calorific value of about 40, and dividing by the kwh to joule conversion of 3.6. Your latest bill should show the applicable conversions.'.format(gasmult)
else:
gaswarn = ''
if 'month' in request.GET:
month = request.GET.get('month')
if 'day' in request.GET:
day = int(request.GET.get('day'))
heading = 'Half-hourly {} on {}-{:02d}'.format(type.title(), month, day)
navbar = getnavbar(request)
description = f'{type.capitalize()} for each half hour (labels are start-times, in local time)'
labels = str(data['local_time_start'].tolist())
quantity = str(['{:.2f}'.format(x) for x in data['total_quantity'].values])
table = '<TABLE><TR><TH>Total Quantity</TH><TD>{:.3f}</TD></TR></TABLE>'.format(data.total_quantity.sum())
table += '<BR><TABLE><TR><TH>Period Start</TH><TH>Quantity</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD>{}</TD><TD>{:.3f}</TD></TR>'
table += t.format(j.local_time_start, j.total_quantity)
table += '</TABLE>'
else:
heading = 'Daily {} for {}'.format(type.title(), month)
navbar = getnavbar(request)
description = f"{type.capitalize()} (in KWh) for each day"
labels = str([x.strftime('%d %b') for x in data['day'].tolist()])
quantity = str(['{:.2f}'.format(x) for x in data.total_quantity.tolist()])
table = '<TABLE><TR><TH>Total Quantity</TH><TD>{:.3f}</TD></TR>'.format(data.total_quantity.sum())
avg = 48*(data.total_quantity).sum()/data.numperiods.sum()
table += '<TR><TH>Avg Daily Quantity</TH><TD>{:.3f}</TD></TR></TABLE>'.format(avg)
table += '<BR><TABLE><TR><TH>Day</TH><TH>Quantity</TH></TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD></TR>'
table += t.format(adj_url(url, [],[('day',j.day.day)]),
j.day.strftime('%a %b %d'), j.total_quantity)
table += '</TABLE>'
else:
heading = 'Monthly {}'.format(type.title())
navbar = getnavbar(request)
description = f"Average daily {type.capitalize()} (in KWh) for each month:"
labels = str([x.strftime('%b-%Y') for x in data['month'].tolist()])
quantity = 48*data['total_quantity']/data['numperiods']
quantity = str(['{:.2f}'.format(x) for x in quantity.tolist()])
table = '<TABLE><TR><TH>Total Quantity</TH><TD>{:.3f}</TD></TR>'.format(data.total_quantity.sum())
avg = 48*data.total_quantity.sum()/data.numperiods.sum()
table += '<TR><TH>Avg Daily Quantity</TH><TD>{:.3f}</TD></TR></TABLE>'.format(avg)
table += '<BR><TABLE><TR><TH>Month</TH><TH>Total<BR>Quantity</TH><TH>Daily<BR>Quantity</TR>'
for _, j in data.iterrows():
t = '<TR><TD><A HREF="{}">{}</A></TD><TD>{:.3f}</TD><TD>{:.3f}</TD></TR>'
avg = 48*(j.total_quantity/j.numperiods)
table += t.format(adj_url(url, [],[('month',j.month.strftime('%Y-%m'))]),
j.month.strftime('%b %Y'), j.total_quantity, avg)
table += '</TABLE>'
if 'chartscale' in request.GET:
c = request.GET.get('chartscale').split(',')
chartscale = f'min: {c[0]}, '
if len(c)>1:
chartscale += f'max: {c[1]}, '
else:
chartscale = 'suggestedMin: 0'
with open(os.path.dirname(os.path.realpath(__file__)) + "/templates/chart_template.html", "r") as f:
inner = f.read()
kwargs = {'navbar': navbar + gaswarn,
'description': description,
'chartlabels': labels,
'quantity': quantity,
'table': table+'<BR>',
'chartscale': chartscale,
}
for k, v in kwargs.items():
inner = inner.replace('{' + k + '}', v)
output = create_sm_page(request, inner, heading)
return output
def adminPage(request):
url = request.get_full_path()
if request.method == 'POST':
task = list(request.POST.keys())[0]
if isdemo(request):
raise Exception(
'You must use your n3rgy code or your octopus code to load or delete data. Click Back to return to the Admin screen.'
)
if task == 'delete':
smid = get_sm_id(request)
deleteSmData(smid)
output = redirect(adj_url(url, [], [('mode', '101')]))
for k, v in request.COOKIES.items():
if k[:5] == 'sm_id':
output.set_cookie(k, v, max_age=-1)
return output
if task == 'loadelectricity':
smid = loadSmData(request, 0)
elif task == 'loadgas':
smid = loadSmData(request, 1)
elif task == 'loadexport':
smid = loadSmData(request, 2)
else:
raise Exception(str(request.POST.keys()))
sm_log(request, 'admin', smid)
mode = getmode(smid)
output = redirect(adj_url(url, [], [('mode', mode)]))
key = 'sm_id_' + request.GET.get('octopus',
request.GET.get('n3rgy', None))[-3:]
output.set_cookie(key, smid, max_age=3600)
return output
smid = get_sm_id(request)
types = ['Electricity', 'Gas', 'Export']
if 'source' in request.GET:
source = request.GET.get('source')
if source == 'octopus':
sample = 'A-ABCD1234sk_live_BCmPlrj6LwktwfYvosMRePcd'
s = '''
<P>If you are an Octopus customer, you can access your data using a key made up of your account
(eg A-ABCD1234 - you can find this on your bill) followed by your security key (which should be like
sk_live_BCmPlrj6LwktwfYvosMRePcd, which you can find on
the <A HREF="https://octopus.energy/dashboard/developer/" target="_blank">Octopus developer page</A>).
These two strings should be joined together without any gap between them, eg A-ABCD1234sk_live_BCmPlrj6LwktwfYvosMRePcd.</P>
<P>Your Octopus key will never be stored by the website. You may later choose to store consumption data, however you will be
given further details before you do.</P>
'''
elif source == 'n3rgy':
sample = 'B816B327CE29A3C1'
s = '''
<P>If you have registered with n3rgy, you will have registered using your MAC, which is a unique 16 digit string
printed on your in-house display (something like B816B327CE29A3C1 - don't include any hyphens or spaces).
If you have not yet registered with n3rgy, you can do for free by going to
<A HREF="https://data.n3rgy.com/home" target="_blank">their website</A> and clicking on the "I'm a Consumer" button
in the top right corner. </P>
<P>Your n3rgy key will never be stored by the website. You may later choose to store consumption data, however you will be
given further details before you do.</P>
'''
url = adj_url(url, ['source', 'octopus', 'hash'], [])
s += f"""
<form action="{url}" method="get">
<div class="form-group row">
<label for="inputEmail3" class="col-sm-2 col-form-label">Key</label>
<div class="col-sm-10">
<input type="text" class="form-control" name="{source}" value="{sample}">
</div>
</div>
<div class="form-group row">
<div class="col-sm-10">
<button type="submit" class="btn btn-primary">Check for data</button>
</div>
</div>
</form>
"""
return create_sm_page(request, s, 'Smart Meter Admin')
s = ''
data, df_gaps, tablestr = seewhatwehave(request)
choosesource = formforkeys(request)
if isdemo(request):
if data.shape[0] == 0:
s += """
<P>You are currently looking at this page without providing an account key, so it is just attempting to display
data for the demo account. However, it can't currently find any data for the demo account. However, if you would like
to load your own data from Octopus or n3rgy, select the source from the dropdown list below.</P>"""
s += choosesource
else:
s += """
<P>You are currently looking at this page without providing an account key, so it will just display data
for the <B>demo account</B>. Alternatively, if you would would like to see your own data, you can
select one of Octopus or n3rgy as a source from the dropdown below.<P>
"""
s += choosesource
s += """
<H3>Currently Loaded Data</H3>
"""
s += tablestr
else:
source = 'Octopus' if 'octopus' in request.GET else 'n3rgy'
s += f"""
<P>This is the Admin page for your account where you can see the data we have for you, and any additional data from
{source} that you may wish to load. You can also delete all your data from this server. </P>
"""
if data.shape[0] > 0:
s += "<H4>Currently Loaded Data</H4>"
s += tablestr
numgaps = df_gaps.shape[0]
if numgaps > 0:
s += f'<P><B>You have {numgaps} gaps in the data we have stored</B>. '
if request.GET.get('hidegaps', '0') == '0':
s += 'These are shown at the bottom of the page.</P>'
else:
s += 'If you want to see these, remove the hidegaps=1 flag in the url.'
s += f'''
<P>Any data will be deleted from the server up to 7 days after it is last updated. You can delete the data manually
at any point using the following buttons.</P>
<form action="{url}" method="post">
<input type="submit" name="delete" value="Delete Data">
</form> <BR><BR> '''
else:
s += "<P>We currently have no data stored for this account.</P>"
s += """
<script type="text/javascript">
var submit;
var _formConfirm_submitted = false;
function checkForm(form) // Submit button clicked
{
submit.disabled = true;
submit.value = "Please wait...";
return true;
}
function Clicked(button)
{
submit= button ;
}
</script>
"""
if source == 'Octopus':
key = request.GET.get('octopus')
if request.GET.get('includeprice', '0') == '1':
df = octopusmeters(key, getprices=True)
else:
df = octopusmeters(key, getprices=False)
s += '<H4>Data Available from Octopus</H4>'
if isinstance(df, tuple):
s += '<P><B>Invalid key</B>. Your key should be the combination of your account number and your security key, with no characters in between. '
if df[0] == 404:
s += f'The Octopus API responded that it could not recognise account number {key[:10]}. '
s += 'This should be your account number, eg A-ABCD1234. You can find it on your bill or your Octopus webpage. '
elif df[0] == 401:
s += f'The Octopus API responded with a security error. This may mean that your security key {key[10:]} was wrong. '
s += 'You should be able to find it on the <A HREF="https://octopus.energy/dashboard/developer/" target="_blank">developer page</A> of the Octopus website. '
s += f'Alternatively, it may be that this is merely the wrong security key for the account {key[:10]}. '
else:
s += f'Unknown error connecting to your account: {df[1]}. '
elif df.shape[0] == 0:
s += f'''
<P><B>We connected to your Octopus account, but couldn't find any meters with consumption data</B>. You can see the full information Octopus has for your meters on <A HREF="{url.replace('other','octoaccount')}">Octopus Account Details</A>. Feel free to get in touch with
me so I can investigate.
'''
else:
if request.GET.get('includeprice', '0') == '1':
s += '<TABLE><TR><TH>Type</TH><TH>MPAN</TH><TH>Meter</TH><TH>Last Time (UTC)</TH><TH>Tariff</TH><TH>Product</TH><TH>Region</TH><TH>Price</TH></TR>'
for i, j in df.iterrows():
s += f"<TR><TD>{types[j.type_id]}</TD><TD>{j.mpan}</TD><TD>{j.serial}</TD><TD>{j.laststart}</TD><TD>{j.tariff}</TD><TD>{j['product']}</TD><TD>{j.region}</TD><TD>{j['prices']}</TD></TR>"
s += '</TABLE>'
else:
s += '<TABLE><TR><TH>Type</TH><TH>MPAN</TH><TH>Meter</TH><TH>Last Time (UTC)</TH><TH>Tariff</TH><TH>Product</TH><TH>Region</TH></TR>'
for i, j in df.iterrows():
s += f"<TR><TD>{types[j.type_id]}</TD><TD>{j.mpan}</TD><TD>{j.serial}</TD><TD>{j.laststart}</TD><TD>{j.tariff}</TD><TD>{j.tariff[5:-2]}</TD><TD>{j.tariff[-1]}</TD></TR>"
s += '</TABLE>'
s += f'''<P>You can see the full information Octopus has for your meters on <A HREF="{url.replace('other','octoaccount')}">Octopus Account Details</A>. Please let me know if you have additional meters that you think I should be picking up.</P> '''
s += '''
<P>You can load the latest data to the server using the buttons below. <B>Clicking this button indicates
that you are happy for your data to be stored on the server</B>. Your security key will not be stored, nor will any
other information that could be used to identify you. Your data will be deleted automatically within 7 days of you last
loading data, and you can delete it manually at any time on this page.
<P>Note that at the moment each of these buttons will take about 10 seconds to load in the data. I will be working on optimising
this over the coming days. </P>
<form onsubmit="if( _formConfirm_submitted == false ){ _formConfirm_submitted = true;return true }else{ return false; }" '''
s += f'''action="{url}" method="post" >'''
j = []
if 0 in df.type_id.unique():
j.append(
'''<input type="submit" name="loadelectricity" value="Load Electricity Data" onclick="this.value='Loading...';">'''
)
if 1 in df.type_id.unique():
j.append(
'''<input type="submit" name="loadgas" value="Load Gas Data" onclick="this.value='Loading...';">'''
)
if 2 in df.type_id.unique():
j.append(
'''<input type="submit" name="loadexport" value="Load Export Data" onclick="this.value='Loading...';">'''
)
s += ' '.join(j) + '</form><BR>'
if source == 'n3rgy':
key = request.GET.get('n3rgy')
n3adj = int(request.GET.get('n3adj', '1'))
ndata = n3rgymeters(key, n3adj)
s += '<H4>Data Available from n3rgy</H4>'
if isinstance(ndata, tuple):
s += "<P><B>Invalid key</B>. Your key should be the in-home display's MAC code that you used to set up your n3rgy account."
s += " it should be 16 digits without any spaces or dashes in between the characters. "
s += f"Error code: {ndata[0]}, message: {ndata[1]}"
else:
found = [x[0] for x in ndata if x[1] == 200]
numvalid = len(found)
if numvalid == 0:
s += "<P><B>We connected to your n3rgy account. but couldn't find any meters with data</B>.</P> "
if numvalid > 0:
s += '<P>We connected to your n3rgy account, and the following data types were found:</P>'
s += '<TABLE><TR><TH>Type</TH><TH>LastDateTime (UTC)</TH></TR>'
for i in range(3):
if ndata[i][1] == 200:
s += f"<TR><TD>{types[i]}</TD><TD>{ndata[i][2]}</TD></TR>"
s += '</TABLE>'
if numvalid < 3 and False:
s += "<P>We had problems accessing the following data types.</P> "
s += '<TABLE><TR><TH>Type</TH><TH>Status</TH><TH>Message</TH></TR>'
for i in range(3):
if ndata[i][1] != 200:
s += f"<TR><TD>{types[i]}</TD><TD>{ndata[i][1]}</TD><TD>{ndata[i][2]}</TD></TR>"
s += '</TABLE><BR>'
if numvalid > 0:
s += '''<P>You can load the latest data to the server using the buttons below. <B>Clicking this button indicates
that you are happy for your data to be stored on the server</B>. Your security key will not be stored, nor will any
other information that could be used to identify you. Your data will be deleted automatically within 7 days of you last
loading data, and you can delete it manually at any time on this page.
<P>Note that at the moment each of these buttons will take about 10 seconds to load in the data. I will be working on optimising
this over the coming days. </P>
<form onsubmit="if( _formConfirm_submitted == false ){ _formConfirm_submitted = true;return true }else{ return false; }" '''
s += f'''action="{url}" method="post" >'''
j = []
if 0 in found:
j.append(
'''<input type="submit" name="loadelectricity" value="Load Electricity Data" onclick="this.value='Loading...';">'''
)
if 1 in found:
j.append(
'''<input type="submit" name="loadgas" value="Load Gas Data" onclick="this.value='Loading...';">'''
)
if 2 in found:
j.append(
'''<input type="submit" name="loadexport" value="Load Export Data" onclick="this.value='Loading...';">'''
)
s += ' '.join(j) + '</form><BR><BR>'
if df_gaps.shape[0] > 0:
if request.GET.get('hidegaps', '0') == '0':
df_gaps['type'] = df_gaps.type_id.map({
0: 'Electricity',
1: 'Gas',
2: 'Electricity Export'
})
s5 = """
<P>The following table is a list of all gaps in your data, that is, any periods between the first period and last period
for which we don't have consumption data. If you click 'Load' above, it will try and fill these gaps.
However, it may be the case that n3rgy or Octopus have been unable to retrieve your data from your smart meter.</P>
<TABLE><TR><TH>Type</TH><TH>Period</TH>
"""
for _, j in df_gaps.iterrows():
s5 += '<TR><TD>{}</TD><TD>{}</TD></TR>'.format(
j['type'], j['period'])
s5 += '</TABLE><BR>'
s += s5
s += '</DIV>'
output = create_sm_page(request, s, 'Smart Meter Admin')
return output
def checkRequest(request):
choice = request.path_info.split('/')[-1]
url = request.get_full_path()
smid = get_sm_id(request)
if choice == '':
if '?' in url:
url = url.replace('?', 'home?')
else:
url = url + 'home'
return redirect(url)
elif choice in ['sm', 'smartmeter']:
url = url.replace(choice, f'{choice}/home')
return redirect(url)
if 'MAC' in request.GET:
return redirect(
adj_url(url, ['MAC'], [('n3rgy', request.GET.get('MAC'))]))
if isdemo(request):
if ('tariff' not in request.GET) and (choice in ['cost']):
u = adj_url(url, [], [('tariff', '15')])
return redirect(u)
if choice in [
'home', 'admin', 'info', 'getstarting', 'checks', 'logpage',
'gastracker', 'electracker', 'other', 'memory', 'octobill',
'octoaccount', 'customprofile'
]:
return choice
type_id, type_label = get_type_id(choice)
if type_id == -1:
content = """
<P>This functionality is not yet implemented. Please try another page from the menu or check back later.</P>"""
return create_sm_page(request, content, 'Invalid Page')
if smid is not None:
s = f"select account_id from sm_accounts where session_id= '{smid}' and active='1'"
account_id = loadDataFromDb(s)
else:
account_id = []
if len(account_id) == 0:
adminurl = url.replace(choice, 'admin', 1)
heading = 'No data stored for this user'
content = f"""
<P>There is no data currently stored for you. Please visit the <A HREF="{adminurl}">Admin Page</A> to reload data. </P>"""
return create_sm_page(request, content, heading)
if choice in ['cost', 'gascost', 'exportrevenue']:
prefix = ['', 'gas', 'export'][type_id]
tariff = request.GET.get(prefix + 'tariff', None)
if tariff is None:
return getTariff(request, choice)
else:
isfixed = tariff.replace(',', '').replace(':', '').replace(
'-', '').replace('.', '').isnumeric()
if (isfixed == 0):
if 'region' not in request.GET:
return getTariff(request, choice)
region = request.GET.get('region')
s = f"select var_id, granularity_id from sm_variables where product='{tariff}' and region='{region}' and type_id={type_id}"
s = loadDataFromDb(s)
if len(s) == 0:
return getTariff(request, choice)
return choice