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)