def getValues(request):
context = {}
if request.method == 'POST':
s0 = Series.objects.get(name=request.POST.get('series'))
dateFrom = dt.datetime.strptime(request.POST.get('from'), "%a, %d %b %Y %H:%M:%S %Z").replace(tzinfo = None)
dateTo = dt.datetime.strptime(request.POST.get('to'), "%a, %d %b %Y %H:%M:%S %Z").replace(tzinfo = None)
result = Value.objects.filter(series=s0, date__gte=dateFrom, date__lt=dateTo).order_by('date')
if not result:
tmp = Value.objects.filter(series=s0, date__lt=dateFrom)
if tmp:
tmp = tmp.latest('date')
reference = tmp.date
dateFrom = reference.replace(year=reference.year-1)
result = Value.objects.filter(series=s0).filter(date__gte=dateFrom, date__lt=dateTo).order_by('date')
if s0.encryptionKey==None:
values = [{'x':obj.date.isoformat(), 'y':str(obj.recordOpen)} for obj in result]
else:
values = [{'x':obj.date.isoformat(), 'y':binascii.b2a_base64(obj.record).decode("utf-8")} for obj in result]
context = {'values': values}
return JsonResponse(context)
评论列表
文章目录