def get_water_by_date_chart(request):
start_time = request.POST.get('start_time')
end_time = request.POST.get('end_time')
# print 'start_time: %s\nend_time: %s' % (start_time, end_time, )
if start_time is None or end_time is None:
result = dict()
result['message'] = u'时间日期为空, 请传入查询时间'.encode('utf-8')
result['code'] = -1
result['result'] = False
return HttpResponse(content=json.dumps(obj=result, ensure_ascii=False),
content_type='application/json',
charset='utf-8')
try:
start = DateUtils.convert_str_to_date(str_date=start_time)
end = DateUtils.convert_str_to_date(str_date=end_time)
water_list = Water.objects.filter(curTime__range=(start, end))
if water_list is None or len(water_list) == 0:
result = dict()
result['result'] = False
result['message'] = u'数据为空'
result['code'] = -1
return HttpResponse(content=json.dumps(obj=result,
ensure_ascii=False),
content_type='application/json',
charset='utf-8')
else:
data = dict()
x_time = list()
phs = list()
pressures = list()
temperatures = list()
electrolytics = list()
for info in water_list:
x_time.append(DateUtils.convert_date_to_str(info.curTime))
phs.append(info.ph)
pressures.append(info.pressure)
temperatures.append(info.temperature)
electrolytics.append(info.electrolytic)
data['x_time'] = x_time
data['phs'] = phs
data['pressures'] = pressures
data['temperatures'] = temperatures
data['electrolytics'] = electrolytics
result = dict()
result['result'] = True
result['message'] = 'success'
result['code'] = 0
result['data'] = data
return JsonResponse(data=result, safe=False, status=200)
except Exception, e:
result = dict()
result['message'] = e.message
result['result'] = False
result['code'] = -1
return JsonResponse(data=result)
def get_compare_info(request):
a_time = request.POST.get('a_time')
b_time = request.POST.get('b_time')
result = dict()
if a_time is None or b_time is None:
result['message'] = u'时间日期为空, 请传入查询时间'.encode('utf-8')
result['code'] = -1
result['result'] = False
return HttpResponse(content=json.dumps(obj=result, ensure_ascii=False),
content_type='application/json',
charset='utf-8')
try:
a = DateUtils.convert_str_to_date(str_date=a_time)
b = DateUtils.convert_str_to_date(str_date=b_time)
water_list = Water.objects.filter(curTime__in=[a, b])
if len(water_list) < 2:
result['message'] = '查询时间数据为空, 请先把指定日期数据添加到数据库中'
result['code'] = -1
result['result'] = False
return HttpResponse(content=json.dumps(obj=result,
ensure_ascii=False),
content_type='appllication/json',
charset='utf-8')
data_list = list()
for info in water_list:
data = dict()
data['pressure'] = info.pressure
data['temperature'] = info.temperature
data['ph'] = info.ph
data['electrolytic'] = info.electrolytic
data['curTime'] = DateUtils.convert_date_to_str(info.curTime)
data_list.append(data)
result['message'] = 'success'
result['code'] = 0
result['result'] = True
result['data'] = data_list
return JsonResponse(data=result, status=200, safe=False)
except Exception, e:
result['message'] = e.message
result['result'] = False
result['code'] = -1
return JsonResponse(data=result, status=501)