def get_alarm_num(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') get_month_alarm_to_db(company_id) query_alarm_info = AlarmNum.query.filter( AlarmNum.org_id == company_id).order_by(AlarmNum.row_datetime).all() alarm_info_list = list() last_tw_month = get_month_list() if not query_alarm_info: for tm in last_tw_month: month = tm.split('-')[1] alarm_info_list.append({"name": month, "value": 0}) result = return_result(companyId=company_id, month={"alarmNum": alarm_info_list}, token=token) print_exit_func(func_name) return jsonify(result) # for qa in query_alarm_info: # alarm_info_list.append({"name": qa.row_datetime.strftime('%Y-%m'), "value": qa.alarm_num}) # # print(qa.row_datetime) last_tw_month = get_month_list() month_alarm_dict = dict() for qa in query_alarm_info: month_alarm_dict[qa.row_datetime] = {"alarm_num": qa.alarm_num} for tm in last_tw_month: month = tm.split('-')[1] tm_date = datetime.datetime.strptime(tm, '%Y-%m-%d') if tm_date in month_alarm_dict: alarm_info_list.append({ "name": month, "value": month_alarm_dict[tm_date]['alarm_num'] }) else: alarm_info_list.append({"name": month, "value": 0}) result = return_result(companyId=company_id, month={"alarmNum": alarm_info_list}, token=token) print_exit_func(func_name) return jsonify(result)
def get_curr_month_alarm_stat_source(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') today_date = datetime.date.today() today_month = today_date.strftime("%Y-%m") today_month_day = today_date.strftime("%Y-%m-1") get_month_src_alarm_to_db(company_id) query_alarm_src = AlarmSrcStat.query.filter( and_(AlarmSrcStat.row_datetime >= today_month_day, AlarmSrcStat.org_id == company_id)).first() if not query_alarm_src: result = return_result(companyId=company_id, date=today_month, source={ "wechat": 0, "mix": 0, "nano": 0 }, token=token) print_exit_func(func_name) return jsonify(result) total_num = query_alarm_src.alarm_total wechat_num = query_alarm_src.alarm_wechat mix_num = query_alarm_src.alarm_mix nano_num = query_alarm_src.alarm_nano result = return_result(companyId=company_id, date=today_month, total=total_num, source={ "wechat": wechat_num, "mix": mix_num, "nano": nano_num }, token=token) print_exit_func(func_name) return jsonify(result)
def get_today_work_overview(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) print(result[0]) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') today_date = datetime.date.today() get_work_overview_to_db(company_id) query_work_overview = WorkOverview.query.filter( and_(WorkOverview.row_datetime >= today_date, WorkOverview.org_id == company_id)).first() if not query_work_overview: result = return_result(company_id=company_id, today_date=today_date, token=token) print_exit_func(func_name) return jsonify(result) date = str(query_work_overview.row_datetime.date()) repair_num = query_work_overview.ev_num_repair mainten_num = query_work_overview.ev_num_maintenance result = return_result(company_id=company_id, data=date, repairTask=repair_num, maintenanceTask=mainten_num, token=token) print_exit_func(func_name) return jsonify(result)
def get_company_overview(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') today_date = datetime.date.today() get_company_info_to_db(company_id) query_org_overview = OrgOverview.query.filter( and_(OrgOverview.org_id == company_id, OrgOverview.row_datetime >= today_date)).first() if not query_org_overview: result = return_result(companyId=company_id, date=today_date, token=token) print_exit_func(func_name) return jsonify(result) date = str(query_org_overview.row_datetime.date()) total_elevators = query_org_overview.ev_total total_employees = query_org_overview.Employee_total result = return_result(companyId=company_id, date=date, totalElevators=total_elevators, totalEmployees=total_employees, token=token) print_exit_func(func_name) return jsonify(result)
def get_ev_area(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') today_date = datetime.date.today() get_main_com_ev_area_to_db(company_id, []) query_ev_area = EvArea.query.filter( and_(EvArea.row_datetime >= today_date, EvArea.org_id == company_id)).all() # if query_ev_area is None: # print_exit_func(func_name) # return jsonify({"code": 1, "message": "请求companyId值返回为空"}) project_info = [] for ea in query_ev_area: project_info.append({ "projectName": ea.project_name, "longitude": ea.user_longitude, "latitude": ea.user_latitude, "evNum": ea.ev_num }) results = return_result(companyId=company_id, projectInfo=project_info, token=token) print_exit_func(func_name) return jsonify(results)
def get_repair_main_stat(): func_name = inspect.stack()[0][3] print_enter_func(func_name) pm.set_para(ARG_FLAG_ORG_ID) result = request_pre_check(request.args, pm) if not result[0]: print_exit_func(func_name) return jsonify(result[1]) company_id = request.args.get('companyId') token = request.headers.get('tokenStr') get_month_maintan_repair_to_db(company_id) query_repair_main = RepairMainStat.query.filter(RepairMainStat.org_id == company_id). \ order_by(RepairMainStat.row_datetime).all() repair = list() mainten = list() last_tw_month = get_month_list() if not query_repair_main: for tm in last_tw_month: month = tm.split('-')[1] repair.append({"name": month, "value": 0}) mainten.append({"name": month, "value": 0}) result = return_result(companyId=company_id, month={ "repair": repair, "maintenance": mainten }, token=token) print_exit_func(func_name) return jsonify(result) # print(last_tw_month) # for qr in query_repair_main: # # print(qr.row_datetime,qr.ev_num_repair,qr.ev_num_maintenance) # repair.append({"name": qr.row_datetime.strftime('%Y-%m'), "value": qr.ev_num_repair}) # mainten.append({"name": qr.row_datetime.strftime('%Y-%m'), "value": qr.ev_num_maintenance}) month_mainten_repair = dict() for qr in query_repair_main: month_mainten_repair[qr.row_datetime] = { "repair": qr.ev_num_repair, "mainten": qr.ev_num_maintenance } for tm in last_tw_month: month = tm.split('-')[1] tm_date = datetime.datetime.strptime(tm, '%Y-%m-%d') if tm_date in month_mainten_repair: repair.append({ "name": month, "value": month_mainten_repair[tm_date]['repair'] }) mainten.append({ "name": month, "value": month_mainten_repair[tm_date]['mainten'] }) else: repair.append({"name": month, "value": 0}) mainten.append({"name": month, "value": 0}) result = return_result(companyId=company_id, month={ "repair": repair, "maintenance": mainten }, token=token) print_exit_func(func_name) return jsonify(result)