def get(self):
meter_key = self.get_str("meter_key")
meter = Meter.get_meter(meter_key)
reader = self.require_current_reader()
if reader.key() != meter.reader.key():
self.return_forbidden()
self.return_ok(self.page_fields(meter, reader))
def get(self):
meter_key = self.get_str("meter_key")
meter = Meter.get_meter(meter_key)
if meter.is_public:
current_reader = self.find_current_reader()
else:
current_reader = self.require_current_reader()
if current_reader.key() != meter.reader.key():
self.return_forbidden()
self.return_ok(self.page_fields(meter, current_reader))
def get(self):
meter_key = self.get_str("meter_key")
meter = Meter.get_meter(meter_key)
if meter.is_public:
current_reader = self.find_current_reader()
else:
current_reader = self.require_current_reader()
if current_reader.key() != meter.reader.key():
self.return_forbidden()
reads = Read.gql(
"where meter = :1 order by read_date desc", meter).fetch(1000)
self.return_ok(
{
'reads': reads,
'template_name': 'export_reads.csv',
'content_disposition': 'attachment; filename=reads.csv;'})
def post(self):
current_reader = self.require_current_reader()
meter_key = self.post_str("meter_key")
meter = Meter.get_meter(meter_key)
if current_reader.key() != meter.reader.key():
self.return_forbidden()
try:
read_date = self.post_datetime("read", meter.get_tzinfo())
value = self.post_float("value")
read = Read(meter=meter, read_date=read_date, value=value)
read.put()
fields = self.page_fields(meter, current_reader)
fields['read'] = read
self.return_ok(fields)
except HTTPBadRequest as e:
self.return_bad_request(self.page_fields(meter, current_reader, e))
def page_fields(self):
meter_key = self.get_str("meter_key")
meter = Meter.get_meter(meter_key)
now = datetime.datetime.now().date()
now = datetime.datetime(now.year, now.month, 1)
months = []
for month in range(-11, 1):
month_start = now + \
dateutil.relativedelta.relativedelta(months=month)
month_finish = month_start + \
dateutil.relativedelta.relativedelta(months=1)
months.append(self.kwh(meter, month_start, month_finish))
labels = ','.join(
'"' + datetime.datetime.strftime(month['start_date'], '%b %Y') +
'"' for month in months)
data = ','.join(str(round(month['kwh'], 2)) for month in months)
return {'current_reader': self.find_current_reader(),
'meter': meter, 'data': data, 'labels': labels}
def post(self):
current_reader = self.require_current_reader()
meter_key = self.post_str("meter_key")
meter = Meter.get_meter(meter_key)
try:
if current_reader.key() != meter.reader.key():
self.return_forbidden()
if 'delete' in self.request.POST:
fields = self.page_fields(meter, current_reader)
meter.delete_meter()
fields['message'] = 'Meter deleted successfully.'
self.return_see_other('/')
else:
is_public = 'is_public' in self.request.POST
email_address = self.post_str('email_address')
confirm_email_address = self.post_str('confirm_email_address')
reminder_frequency = self.post_str('reminder_frequency')
utility_units = self.post_str('utility_units')
name = self.post_str('name')
time_zone = self.post_str('time_zone')
reminder_start = self.post_datetime(
"reminder_start", pytz.timezone(time_zone))
utility_id, units = utility_units.split('-')
email_address = email_address.strip()
if email_address != confirm_email_address.strip():
raise HTTPBadRequest("The email addresses don't match")
customer_read_frequency = self.post_str(
'customer_read_frequency')
meter.update(
utility_id, units, name, time_zone, is_public,
email_address, reminder_start, reminder_frequency,
customer_read_frequency)
fields = self.page_fields(meter, current_reader)
fields['message'] = 'Settings updated successfully.'
self.return_ok(fields)
except HTTPBadRequest as e:
self.return_bad_request(
self.page_fields(meter, current_reader, str(e)))
def post(self):
try:
current_reader = self.require_current_reader()
meter_key = self.post_str("meter_key")
meter = Meter.get_meter(meter_key)
if current_reader.key() != meter.reader.key():
self.return_forbidden()
file_item = self.post_file("spreadsheet")
if file_item.filename.endswith(".csv"):
rdr = csv.reader(file_item.file)
for row in rdr:
if len(row) < 2:
raise HTTPBadRequest("""Expecting 2 fields per row, the
date in the format yyyy-MM-dd HH:mm followed by
the reading.""")
try:
read_date = datetime.datetime.strptime(
row[0].strip(), '%Y-%m-%d %H:%M')
except ValueError as e:
raise HTTPBadRequest(
"Problem at line number " + str(rdr.line_num) +
" of the file. The first field (the read date "
"field) isn't formatted correctly, it should be "
"of the form 2010-02-23T21:46. " + str(e))
value = float(row[1].strip())
read = Read(meter=meter, read_date=read_date, value=value)
read.put()
fields = self.page_fields(meter, current_reader)
fields['message'] = 'File imported successfully.'
self.return_ok(fields)
else:
raise HTTPBadRequest("The file name must end with '.csv.'")
except HTTPBadRequest as e:
e.values = self.page_fields(meter, current_reader)
raise e
