def search_db_cp_result(request):
start_date = request.POST.get('startDate', 'error')
end_date = request.POST.get('endDate', 'error')
if start_date=='error' or end_date=='error':
url = 'monitor/search_db_cp_result.html'
search_db_error(url, request)
# <<<<<<< HEAD
count = request.POST.get('count', 0)
try:
count = int(count)
except:
count = 0
# =======
# log.debug(start_date)
# cp1 = CirculatingPump1Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# cp2 = CirculatingPump2Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# count += cp1.count()
# database_list = zip(list(cp1), list(cp2))
# response_data = {
# 'database_list':database_list,
# 'count': count,
# }
# >>>>>>> hp45
response_data = controller.search_database('cp', start_date, end_date, count)
url = 'monitor/search_db_cp_result.html'
html = render_to_string(url, response_data, RequestContext(request))
return HttpResponse(html)
def search_db_excel(request):
obj_type = request.POST.get('objType','error')
# get table header
columns = request.POST.get('columns', 'error').encode('utf-8')
num_col = int(request.POST.get('numCol', 'error'))
col_mat = columns.replace('"', '').replace('[', '').replace(']', '').split(",")
# table content
# rows = request.POST.get('rows', 'error').encode('utf-8')
# num_row = int(request.POST.get('numRow', 'error'))
# row_split = rows.replace('"', '').replace('[', '').replace(']', '').split(",")
# row_mat = [[None for x in range(num_col)] for x in range(num_row)]
# search db accord. to obj_type & start~end date
start_date = request.POST.get('startDate', 'error')
end_date = request.POST.get('endDate', 'error')
# date exception
if start_date=='error' or end_date=='error':
if 'cur' in obj_type:
url = 'monitor/search_db_'+obj_type.replace('-', '_')+'_result.html'
elif 'int' in obj_type:
url = 'monitor/search_db_'+obj_type.replace('-', '_')+'_result.html'
else:
url = 'monitor/search_db_'+obj_type+'_result.html'
search_db_error(url, request)
floor = request.POST.get('floor', '0')
name = request.POST.get('name', '0')
data = controller.search_database(obj_type, start_date, end_date, count=0, floor=floor, name=name, excel=True)
if 'database' in data.keys():
# most of ciu cases
row_mat = make_rows(obj_type, num_col, data["count"], data["database"])
else:
# all cases except ciu, and 'ciu all' cases
row_mat = make_rows(obj_type, num_col, data["count"], data["database_list"])
# if '.' in r:
# # type = float
# row_mat[i][j] = float(r)
# elif r.isdigit():
# row_mat[i][j] = int(r)
# else:
# row_mat[i][j] = r
# j += 1
# if j == num_col:
# j = 0; i += 1;
# if i == num_row: break;
# create excel file
make_excel_file(obj_type, col_mat, row_mat)
response_data = {"obj_type":obj_type}
return HttpResponse(json.dumps(response_data), content_type="application/json")
def search_db_fm_int_result(request):
start_date = request.POST.get('startDate', 'error')
end_date = request.POST.get('endDate', 'error')
if start_date=='error' or end_date=='error':
url = 'monitor/search_db_fm_int_result.html'
search_db_error(url, request)
count = request.POST.get('count', 0)
try:
count = int(count)
except:
count = 0
response_data = controller.search_database('fm-int', start_date, end_date, count)
url = 'monitor/search_db_fm_int_result.html'
html = render_to_string(url, response_data, RequestContext(request))
return HttpResponse(html)
def search_db_power_int_result(request):
start_date = request.POST.get("startDate", "error")
end_date = request.POST.get("endDate", "error")
if start_date == "error" or end_date == "error":
url = "monitor/search_db_power_int_result.html"
search_db_error(url, request)
count = request.POST.get("count", 0)
try:
count = int(count)
except:
count = 0
response_data = controller.search_database("power-int", start_date, end_date, count)
url = "monitor/search_db_power_int_result.html"
html = render_to_string(url, response_data, RequestContext(request))
return HttpResponse(html)
def search_db_ciu_result(request):
start_date = request.POST.get("startDate", "error")
end_date = request.POST.get("endDate", "error")
if start_date == "error" or end_date == "error":
url = "monitor/search_db_ciu_result.html"
search_db_error(url, request)
floor = request.POST.get("floor", "0")
name = request.POST.get("name", "0")
count = request.POST.get("count", 0)
try:
count = int(count)
except:
count = 0
response_data = controller.search_database("ciu", start_date, end_date, count=count, floor=floor, name=name)
url = "monitor/search_db_ciu_result.html"
html = render_to_string(url, response_data, RequestContext(request))
return HttpResponse(html)
def search_db_hp_result(request):
start_date = request.POST.get('startDate', 'error')
end_date = request.POST.get('endDate', 'error')
if start_date=='error' or end_date=='error':
url = 'monitor/search_db_hp_result.html'
search_db_error(url, request)
# <<<<<<< HEAD
count = request.POST.get('count', 0)
try:
count = int(count)
except:
count = 0
response_data = controller.search_database('hp', start_date, end_date, count)
# =======
# log.debug("start")
# hp1 = HeatPump1Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# hp2 = HeatPump2Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# hp3 = HeatPump3Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# hp4 = HeatPump4Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# hp5 = HeatPump5Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# hp6 = HeatPump6Logger.objects.filter(Q(dateTime__gte=start_date), Q(dateTime__lte=end_date)).order_by('-dateTime')
# count += hp1.count()
# log.debug("search done")
# database_list = zip(list(hp1), list(hp2), list(hp3), list(hp4), list(hp5), list(hp6))
# log.debug("zip done")
# response_data = {
# 'database_list':database_list,
# 'count': count,
# }
# >>>>>>> hp45
url = 'monitor/search_db_hp_result.html'
html = render_to_string(url, response_data, RequestContext(request))
return HttpResponse(html)
