def get_realtime(self, uid, sim): """Get the location of the current realtime request. workflow: if there is alive memcached, we can get location from it, else get location from db return result to user browser """ ret = DotDict(status=ErrorCode.SUCCESS, message='', location=None) location = QueryHelper.get_location_info(self.current_user.tid, self.db, self.redis) locations = [location,] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] if (location and location.clatitude and location.clongitude): if not location.name: location.name = '' if location.has_key('id'): del location['id'] location['degree'] = float(location.degree) location['tid'] = self.current_user.tid ret.location = location return ret
def post(self): """Get latest location of a terminal. """ status = ErrorCode.SUCCESS res = {} try: data = DotDict(json_decode(self.request.body)) mobile = str(data.mobile) token = data.token logging.info("[REALTIME] Request, data:%s", data) except Exception as e: status = ErrorCode.DATA_FORMAT_ILLEGAL logging.exception("[REALTIME] Invalid data format, body: %s, mobile: %s.", self.request.body, mobile) self.write_ret(status) return try: status = self.basic_check(token, mobile) if status != ErrorCode.SUCCESS: self.write_ret(status) return terminal = QueryHelper.get_terminal_by_tmobile(mobile, self.db) tid = terminal.tid location = QueryHelper.get_location_info(tid, self.db, self.redis) # check and make name valid if location and location['name'] is None: location['name'] = '' # check and make clatclon valid locations = [location,] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] if (location and location.clatitude and location.clongitude): res = dict(lon=location.get('longitude', 0), lat=location.get('latitude', 0), clon=location.get('clongitude', 0), clat=location.get('clatitude', 0), timestamp=location.get('timestamp',0), name=location.get('name',''), type=location.get('type',0)) self.write_ret(status, dict_=dict(res=res)) except Exception as e: logging.exception("[REALTIME] sid: %s. Exception: %s", mobile, e.args) status = ErrorCode.FAILED self.write_ret(status)
def handle_report_info(self, info): """These reports should be handled here: POWERLOW/POWERFULL/POWEROFF/POWERDOWN ILLEGALMOVE ILLEGALSHAKE EMERGENCY REGION_ENTER REGION_OUT STOP SPEED_LIMIT """ if not info: return # 1: get available location from lbmphelper report = lbmphelper.handle_location(info, self.redis, cellid=True, db=self.db) if not (report['cLat'] and report['cLon']): #NOTE: Get latest location last_location = QueryHelper.get_location_info(report.dev_id, self.db, self.redis) if last_location: #NOTE: Try to make the location is complete. locations = [last_location,] locations = lbmphelper.get_locations_with_clatlon(locations, self.db) last_location = locations[0] report['lat'] = last_location['latitude'] report['lon'] = last_location['longitude'] report['cLat'] = last_location['clatitude'] report['cLon'] = last_location['clongitude'] report['name'] = last_location['name'] report['type'] = last_location['type'] logging.info("[EVENTER] The report has invalid location and use last_location. report: %s", report) else: logging.info("[EVENTER] The report has invalid location and last_location is invalid. report: %s", report) current_time = int(time.time()) alarm_mobile = get_alarm_mobile(report.dev_id, self.db, self.redis) #NOTE: in pvt, timestamp is no used, so use gps_time as timestamp if not report.get('timestamp',None): report['timestamp'] = report['gps_time'] if report['timestamp'] > (current_time + 24*60*60): logging.info("[EVENTER] The report's (gps_time - current_time) is more than 24 hours, so drop it:%s", report) return #NOTE: If undefend, just save location into db if info['rName'] in [EVENTER.RNAME.ILLEGALMOVE, EVENTER.RNAME.ILLEGALSHAKE]: if str(info.get('is_notify','')) == '1': # send notify even if CF logging.info("[EVENTER] Send notify forever, go ahead. Terminal: %s, is_notify: %s", report.dev_id, info.get('is_notify','')) elif alarm_mobile: logging.info("[EVENTER] Send notify forever , go ahead. Terminal: %s, alarm_mobile: %s", report.dev_id, alarm_mobile) else: mannual_status = QueryHelper.get_mannual_status_by_tid(info['dev_id'], self.db) if int(mannual_status) == UWEB.DEFEND_STATUS.NO: report['category'] = EVENTER.CATEGORY.REALTIME insert_location(report, self.db, self.redis) update_terminal_dynamic_info(self.db, self.redis, report) logging.info("[EVENTER] %s mannual_status is undefend, drop %s report.", info['dev_id'], info['rName']) return if info['rName'] in [EVENTER.RNAME.POWERDOWN, EVENTER.RNAME.POWERLOW]: # if alert_freq_key is exists,return alert_freq_key = get_alert_freq_key(report.dev_id + info['rName']) alert_freq = QueryHelper.get_alert_freq_by_tid(info['dev_id'], self.db) if alert_freq != 0: if self.redis.exists(alert_freq_key): logging.info("[EVENTER] Don't send duplicate %s alert to terminal:%s in %s seconds", info["rName"], report.dev_id, alert_freq) return else: self.redis.setvalue(alert_freq_key, 1, time=alert_freq) #NOTE: keep alarm info alarm = dict(tid=report['dev_id'], category=report['category'], type=report['type'], timestamp=report.get('timestamp',0), latitude=report.get('lat',0), longitude=report.get('lon',0), clatitude=report.get('cLat',0), clongitude=report.get('cLon',0), name=report['name'] if report.get('name',None) is not None else '', degree=report.get('degree',0), speed=report.get('speed',0)) if info['rName'] in [EVENTER.RNAME.REGION_OUT, EVENTER.RNAME.REGION_ENTER]: region = report['region'] alarm['region_id'] = region.region_id record_alarm_info(self.db, self.redis, alarm) # 2: save into database. T_LOCATION, T_EVENT lid = insert_location(report, self.db, self.redis) update_terminal_dynamic_info(self.db, self.redis, report) self.event_hook(report.category, report.dev_id, report.get('terminal_type',1), report.get('timestamp'), lid, report.pbat, report.get('fobid'), report.get('region_id', -1)) # 3: notify the owner user = QueryHelper.get_user_by_tid(report.dev_id, self.db) if not user: logging.error("[EVENTER] Cannot find USER of terminal: %s", report.dev_id) return # send sms to owner if report.rName in [EVENTER.RNAME.STOP]: logging.info("[EVENTER] %s alert needn't to push to user. Terminal: %s", report.rName, report.dev_id) return #NOTE: notify user by sms sms_option = QueryHelper.get_sms_option_by_uid(user.owner_mobile, EVENTER.SMS_CATEGORY[report.rName].lower(), self.db) if sms_option == UWEB.SMS_OPTION.SEND: logging.info("[EVENTER] Notify report to user by sms. category: %s, tid: %s, mobile: %s", report.rName, report.dev_id, user['owner_mobile']) self.notify_report_by_sms(report, user['owner_mobile']) else: logging.info("[EVENTER] Remind option of %s is closed. Terminal: %s", report.rName, report.dev_id) if alarm_mobile: logging.info("[EVENTER] Notify report to user by sms. category: %s, tid: %s, alarm_mobile: %s", report.rName, report.dev_id, alarm_mobile) self.notify_report_by_sms(report, alarm_mobile) #NOTE: notify user by push terminal = self.db.get("SELECT push_status FROM T_TERMINAL_INFO" " WHERE tid = %s", report.dev_id) if terminal and terminal.push_status == 1: logging.info("[EVENTER] Notify report to user by push. category: %s, tid: %s, mobile: %s", report.rName, report.dev_id, user['owner_mobile']) self.notify_report_by_push(report, user['owner_mobile']) else: logging.info("[EVENTER] Push option of %s is closed. Terminal: %s", report.rName, report.dev_id) #NOTE: notify alarm_mobile if alarm_mobile: logging.info("[EVENTER] Notify report to user by push. category: %s, tid: %s, alarm_mobile: %s", report.rName, report.dev_id, alarm_mobile) self.notify_report_by_push(report, alarm_mobile)
def handle_location(location, redis, cellid=False, db=None): """ @param location: position/report/locationdesc/pvt memcached cellid: if True issue cellid @return location eg. {u'gps_time': 1407138438, u'dev_id': u'T123SIMULATOR', u'defend_status': u'1', u'locate_error': 20, u'alt': 0, u'speed': 126.3, u'cLat': 0, u'cLon': 0, u'lon': 418507200, u'valid': u'0', u'ns': u'N', u'gps': u'20', u'fobid': u'', u'degree': 276.5, u'softversion': u'1.0.0', u'timestamp': 1407138438, u'terminal_type': u'1', u'sessionID': u'cyndqhy9', u'pbat': u'10', u'lat': 95630400, u'is_notify': u'', u'rName': u'POWERDOWN', u'name': None, u'ew': u'E', u'dev_type': u'1', u'command': u'T26', u't': u'REPORT', u'gsm': u'6', u'cellid': u'460:0:10101:03633' u'type':0, u'category':9, } """ location = DotDict(location) if location.valid == GATEWAY.LOCATION_STATUS.SUCCESS: # 1 location.type = 0 if location.get('speed') is not None and location.speed <= UWEB.SPEED_DIFF: pass #location.degree = get_last_degree(location, redis, db) elif location.valid == GATEWAY.LOCATION_STATUS.UNMOVE: # 4 logging.info("[LBMPHELPER] Tid:%s gps locate flag :%s", location.dev_id, location.valid) #last_location = QueryHelper.get_location_info(location.dev_id, db, redis) last_location = QueryHelper.get_gps_location_info(location.dev_id, db, redis) if last_location: current_time = int(time.time()) diff = current_time - last_location.timestamp logging.info("[LBMPHELPER] current time:%s, last locaiton time:%s, diff time:%s", current_time, last_location.timestamp, diff) if (current_time - last_location.timestamp) < 60 * 60 * 24 * 30: # 30 days. in seconds logging.info("[LBMPHELPER] Tid:%s, current_time - last_location.timestamp < 30 days, so use last location time:%s", location.dev_id, last_location.timestamp) location.gps_time = last_location.timestamp location.lat = last_location.latitude location.lon = last_location.longitude location.cLat = last_location.clatitude location.cLon = last_location.clongitude location.type = 0 location.gps = 0 else: location.type = 0 logging.info("[LBMPHELPER] Tid:%s, current_time - last_location.timestamp >= 600s, so use location itself: %s.", location.dev_id, location) pass else: location.type = 0 logging.info("[LBMPHELPER] Tid:%s, found no location before, so use location itself: %s.", location.dev_id, location) pass # location.lat = last_location.latitude # if (current_time - last_location.timestamp) > 600: # location.gps_time = current_time # logging.info("Tid:%s, current_time - last_location.timestamp > 600s, so use current time:%s", location.dev_id, current_time) # else: # logging.info("Tid:%s, current_time - last_location.timestamp <= 600s, so use last location time:%s", location.dev_id, last_location.timestamp) # location.gps_time = last_location.timestamp # location.lat = last_location.latitude # location.lon = last_location.longitude # location.cLat = last_location.clatitude # location.cLon = last_location.clongitude # location.type = 0 # location.gps = 0 #else: # location.lat = 0 # location.lon = 0 # location.cLat = 0 # location.cLon = 0 # location.type = 0 # location.gps_time = int(time.time()) # location.degree = 0.00 # location.gps = 0 # #if cellid: # # location = issue_cellid(location, db, redis) elif location.valid == GATEWAY.LOCATION_STATUS.MOVE: # 6 logging.info("[LBMPHELPER] tid:%s gps locate flag :%s", location.dev_id, location.valid) location.lat = 0 location.lon = 0 location.cLat = 0 location.cLon = 0 location.type = 0 location.gps_time = int(time.time()) location.degree = 0.00 location.gps = 0 if cellid: location = issue_cellid(location, db, redis) else: # 0,2,5 logging.info("[LBMPHELPER] tid:%s gps locate flag :%s", location.dev_id, location.valid) location.lat = 0 location.lon = 0 location.cLat = 0 location.cLon = 0 location.type = 0 location.gps_time = int(time.time()) location.degree = 0.00 #if db: # location.degree = get_last_degree(location, redis, db) location.gps = 0 if cellid: # 1: issue cellid location = issue_cellid(location, db, redis) if location.lon and location.lat: # 2: check the location whether is odd last_location = QueryHelper.get_location_info(location.dev_id, db, redis) if last_location: distance = get_distance(location.lon, location.lat, last_location.longitude, last_location.latitude) if distance > 5000: login_time = QueryHelper.get_login_time_by_tid(location.dev_id, db, redis) if last_location.timestamp < login_time: logging.info("[LBMPHELPER] tid: %s distance:%s > 5000m, and last login time: %s, after last location timestamp: %s, use cellid location.", location.dev_id, distance, login_time, last_location.timestamp) else: location.lat, location.lon = (last_location.latitude, last_location.longitude) logging.info("[LBMPHELPER] tid:%s, distance:%s > 5000m, use last location: %s ", location.dev_id, distance, last_location) elif distance < 2000: location.lat, location.lon = (last_location.latitude, last_location.longitude) logging.info("[LBMPHELPER] tid:%s distance:%s < 2000m, use last location:%s", location.dev_id, distance, last_location) else: logging.info("[LBMPHELPER] tid:%s 2000m < distance:%s < 5000m, use cellid location", location.dev_id, distance) else: logging.info("[LBMPHELPER] tid:%s last location is none, use cellid location", location.dev_id) if location and location.lat and location.lon: clats, clons = get_clocation_from_ge([location.lat,], [location.lon,]) location.cLat, location.cLon = clats[0], clons[0] # drop some odd cellid location if location.type == 1 and location.cLat and location.cLon: if PtInPolygon(location, DM_ZJGS_POLYGON): location.lat = 0 location.lon = 0 location.cLat = 0 location.cLon = 0 #if (location['t'] == EVENTER.INFO_TYPE.REPORT or # location['command'] == GATEWAY.T_MESSAGE_TYPE.LOCATIONDESC): # NOTE: change it temporarily: in platform get loction name of all if location.cLat and location.cLon: location.name = get_location_name(location.cLat, location.cLon, redis) if location['t'] == EVENTER.INFO_TYPE.POSITION: location.category = EVENTER.CATEGORY.REALTIME elif location['t'] == EVENTER.INFO_TYPE.REPORT: location.category = EVENTER.CATEGORY[location.rName] else: location.category = EVENTER.CATEGORY.UNKNOWN return location
def post(self): logging.info("[UWEB] Android login test") status = ErrorCode.SUCCESS cid = UWEB.DUMMY_CID oid = UWEB.DUMMY_OID uid = ConfHelper.UWEB_CONF.test_uid tid = ConfHelper.UWEB_CONF.test_tid sim = ConfHelper.UWEB_CONF.test_sim version_type = int(self.get_argument("version_type", 0)) biz_type = UWEB.BIZ_TYPE.YDWS self.bookkeep(dict(cid=cid, oid=oid, uid=uid, tid=tid, sim=sim)) user_info = QueryHelper.get_user_by_uid(uid, self.db) # NOTE: add cars_info, it's same as lastinfo cars_info = {} terminals = QueryHelper.get_terminals_by_uid(uid, biz_type, self.db) for terminal in terminals: # 1: get terminal tid = terminal.tid group_info = get_group_info_by_tid(self.db, tid) terminal_info_key = get_terminal_info_key(tid) terminal_cache = self.redis.getvalue(terminal_info_key) if terminal_cache: terminal['gps'] = terminal_cache['gps'] terminal['gsm'] = terminal_cache['gsm'] terminal['pbat'] = terminal_cache['pbat'] mobile = terminal['mobile'] terminal['keys_num'] = 0 if terminal['login'] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal['login'] = GATEWAY.TERMINAL_LOGIN.ONLINE # NOTE: if alias is null, provide cnum or sim instead terminal['alias'] = QueryHelper.get_alias_by_tid( tid, self.redis, self.db) fobs = self.db.query("SELECT fobid FROM T_FOB" " WHERE tid = %s", tid) terminal['fob_list'] = [fob.fobid for fob in fobs] terminal['sim'] = terminal['mobile'] # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location, ] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] self.redis.setvalue( location_key, location, EVENTER.LOCATION_EXPIRY) if location and location['name'] is None: location['name'] = '' avatar_name, avatar_path, avatar_full_path, avatar_time = self.get_avatar_info( mobile) service_status = QueryHelper.get_service_status_by_tmobile( self.db, mobile) car_dct = {} if location and location['type'] == 1: # cellid location['locate_error'] = 500 # mile car_info = dict(defend_status=terminal['defend_status'] if terminal['defend_status'] is not None else 1, service_status=service_status, mannual_status=terminal['mannual_status'] if terminal['mannual_status'] is not None else 1, fob_status=terminal['fob_status'] if terminal['fob_status'] is not None else 0, timestamp=location['timestamp'] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get('locate_error', 20) if location else 20, bt_name=terminal['bt_name'] if terminal.get('bt_name', None) is not None else '', bt_mac=terminal['bt_mac'] if terminal.get('bt_mac', None) is not None else '', dev_type=terminal['dev_type'] if terminal.get('dev_type', None) is not None else 'A', name=location.name if location else '', type=location.type if location else 1, latitude=location['latitude'] if location else 0, longitude=location['longitude'] if location else 0, clatitude=location['clatitude'] if location else 0, clongitude=location['clongitude'] if location else 0, login=terminal['login'] if terminal['login'] is not None else 0, gps=terminal['gps'] if terminal['gps'] is not None else 0, gsm=terminal['gsm'] if terminal['gsm'] is not None else 0, pbat=terminal['pbat'] if terminal['pbat'] is not None else 0, mobile=terminal['mobile'], owner_mobile=terminal['owner_mobile'], alias=terminal['alias'], #keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, group_id=group_info['group_id'], group_name=group_info['group_name'], icon_type=terminal['icon_type'], avatar_path=avatar_path, avatar_time=avatar_time, fob_list=terminal['fob_list'] if terminal['fob_list'] else []) car_dct[tid] = car_info cars_info.update(car_dct) #push_info = NotifyHelper.get_push_info() push_id = uid push_key = NotifyHelper.get_push_key(push_id, self.redis) lastinfo_time_key = get_lastinfo_time_key(uid) lastinfo_time = self.redis.getvalue(lastinfo_time_key) push = dict(id='', key='') t = int(time.time()) * 1000 push_key = get_push_key(uid, t) json_data = WSPushHelper.register_wspush(uid, self.redis) data = json_data['data'] if data: id = data.get('push_id', '') key = data.get('psd', '') push['id'] = id push['key'] = key if version_type >= 1: terminals = [] for k, v in cars_info.iteritems(): v.update({'tid': k}) terminals.append(v) self.write_ret(status, dict_=DotDict(wspush=push, push_id=push_id, push_key=push_key, name=user_info.name if user_info else uid, user_type=UWEB.USER_TYPE.PERSON, lastinfo_time=lastinfo_time, terminals=terminals)) else: self.write_ret(status, dict_=DotDict(wspush=push, push_id=push_id, # app_key=push_info.app_key, push_key=push_key, name=user_info.name if user_info else uid, user_type=UWEB.USER_TYPE.PERSON, cars_info=cars_info, lastinfo_time=lastinfo_time, cars=terminals,))
def post(self): username = self.get_argument("username") password = self.get_argument("password") user_type = self.get_argument("user_type", UWEB.USER_TYPE.PERSON) biz_type = self.get_argument("biz_type", UWEB.BIZ_TYPE.YDWS) devid = self.get_argument("devid", "") versionname = self.get_argument("versionname", "") version_type = int(self.get_argument("version_type", 0)) logging.info("[UWEB] Android login request, username: %s, password: %s, user_type: %s, devid: %s", username, password, user_type, devid) # must check username and password avoid sql injection. if not (username.isalnum() and password.isalnum()): status = ErrorCode.ILLEGAL_LABEL self.write_ret(status) return # check the user, return uid, tid, sim and status cid, oid, uid, terminals, user_type, status = self.login_passwd_auth(username, password, user_type) logging.info( "[UWEB] Login auth, cid:%s, oid:%s, uid:%s, user_type:%s", cid, oid, uid, user_type) if status == ErrorCode.SUCCESS: # role: 0: person; 1: operator; 2: enterprise # method 0: web; 1: android; 2: ios # NOTE: keep the login log login_info = dict(uid=uid, role=0, method=1, versionname=versionname) record_login_user(login_info, self.db) self.bookkeep(dict(cid=cid, oid=oid, uid=uid, tid=terminals[0].tid, sim=terminals[0].sim)) user_info = QueryHelper.get_user_by_uid(uid, self.db) # NOTE: add cars_info, it's same as lastinfo cars_info = {} if user_type == UWEB.USER_TYPE.PERSON: terminals = QueryHelper.get_terminals_by_uid(uid, biz_type, self.db) elif user_type == UWEB.USER_TYPE.OPERATOR: terminals = QueryHelper.get_terminals_by_oid(oid, biz_type, self.db) elif user_type == UWEB.USER_TYPE.CORP: terminals = QueryHelper.get_terminals_by_cid(cid, biz_type, self.db) else: logging.error("[UWEB] Invalid user_type: %s", user_type) for terminal in terminals: # 1: get terminal tid = terminal.tid group_info = get_group_info_by_tid(self.db, tid) terminal_info_key = get_terminal_info_key(tid) terminal_cache = self.redis.getvalue(terminal_info_key) if terminal_cache: terminal['gps'] = terminal_cache['gps'] terminal['gsm'] = terminal_cache['gsm'] terminal['pbat'] = terminal_cache['pbat'] mobile = terminal['mobile'] terminal['keys_num'] = 0 if terminal['login'] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal['login'] = GATEWAY.TERMINAL_LOGIN.ONLINE # NOTE: if alias is null, provide cnum or sim instead terminal['alias'] = QueryHelper.get_alias_by_tid( tid, self.redis, self.db) fobs = self.db.query("SELECT fobid FROM T_FOB" " WHERE tid = %s", tid) terminal['fob_list'] = [fob.fobid for fob in fobs] terminal['sim'] = terminal['mobile'] # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location, ] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] self.redis.setvalue(location_key, location, EVENTER.LOCATION_EXPIRY) if location and location['name'] is None: location['name'] = '' avatar_name, avatar_path, avatar_full_path, avatar_time = self.get_avatar_info(mobile) service_status = QueryHelper.get_service_status_by_tmobile( self.db, mobile) car_dct = {} if location and location['type'] == 1: # cellid location['locate_error'] = 500 # mile car_info = dict(defend_status=terminal['defend_status'] if terminal['defend_status'] is not None else 1, service_status=service_status, mannual_status=terminal['mannual_status'] if terminal['mannual_status'] is not None else 1, fob_status=terminal['fob_status'] if terminal['fob_status'] is not None else 0, timestamp=location['timestamp'] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get('locate_error', 20) if location else 20, bt_name=terminal['bt_name'] if terminal.get('bt_name', None) is not None else '', bt_mac=terminal['bt_mac'] if terminal.get('bt_mac', None) is not None else '', dev_type=terminal['dev_type'] if terminal.get('dev_type', None) is not None else 'A', name=location.name if location else '', type=location.type if location else 1, latitude=location['latitude'] if location else 0, longitude=location['longitude'] if location else 0, clatitude=location['clatitude'] if location else 0, clongitude=location['clongitude'] if location else 0, login=terminal['login'] if terminal['login'] is not None else 0, gps=terminal['gps'] if terminal['gps'] is not None else 0, gsm=terminal['gsm'] if terminal['gsm'] is not None else 0, pbat=terminal['pbat'] if terminal['pbat'] is not None else 0, mobile=terminal['mobile'], owner_mobile=terminal['owner_mobile'], alias=terminal['alias'], #keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, group_id=group_info['group_id'], group_name=group_info['group_name'], icon_type=terminal['icon_type'], avatar_path=avatar_path, avatar_time=avatar_time, fob_list=terminal['fob_list'] if terminal['fob_list'] else []) car_dct[tid] = car_info cars_info.update(car_dct) #push_info = NotifyHelper.get_push_info() push_id = devid if devid else uid push_key = NotifyHelper.get_push_key(push_id, self.redis) lastinfo_time_key = get_lastinfo_time_key(uid) lastinfo_time = self.redis.getvalue(lastinfo_time_key) # uid --> android_push_list # check push_id whether exists in a old android_push_list old_android_push_list_key = self.redis.get(push_id) if old_android_push_list_key: old_android_push_list = self.redis.getvalue( old_android_push_list_key) if not isinstance(old_android_push_list, list): self.redis.delete(old_android_push_list_key) old_android_push_list = [] if old_android_push_list and (push_id in old_android_push_list): logging.info("[UWEB] push_id:%s has existed in a old_android_push_list: %s, so remove push_id from the list.", push_id, old_android_push_list) old_android_push_list.remove(push_id) self.redis.set(old_android_push_list_key, old_android_push_list) android_push_list_key = get_android_push_list_key(uid) android_push_list = self.redis.getvalue(android_push_list_key) android_push_list = android_push_list if android_push_list else [] if push_id not in android_push_list: android_push_list.append(push_id) self.redis.set(android_push_list_key, android_push_list) self.redis.set(push_id, android_push_list_key) logging.info("[UWEB] uid: %s, android_push_lst: %s", username, android_push_list) if user_info: self.login_sms_remind(uid, user_info.mobile, terminals, login="******") else: pass # corp maybe no user_info push = dict(id='', key='') json_data = WSPushHelper.register_wspush(uid, self.redis) data = json_data['data'] if data: id = data.get('push_id', '') key = data.get('psd', '') push['id'] = id push['key'] = key if version_type >= 1: terminals = [] for k, v in cars_info.iteritems(): v.update({'tid': k}) terminals.append(v) self.write_ret(status, dict_=DotDict(wspush=push, push_id=push_id, push_key=push_key, name=user_info.name if user_info else username, user_type=user_type, terminals=terminals, lastinfo_time=lastinfo_time,)) else: self.write_ret(status, dict_=DotDict(wspush=push, push_id=push_id, # app_key=push_info.app_key, push_key=push_key, name=user_info.name if user_info else username, user_type=user_type, cars_info=cars_info, lastinfo_time=lastinfo_time, cars=terminals)) else: logging.info("[UWEB] username: %s login failed, message: %s", username, ErrorCode.ERROR_MESSAGE[status]) self.write_ret(status)
def request_realtime(self, query, callback=None): """ All realtime requests in REALTIME_VALID_INTERVAL will be considered as only one. If not, invoke gf and use handle_location of lbmphelper. """ location = QueryHelper.get_location_info(self.current_user.tid, self.db, self.redis) if location and location['name'] is None: location['name'] = '' ret = DotDict(status=ErrorCode.SUCCESS, message='', location=None) locations = [location,] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] if (location and location.clatitude and location.clongitude): if location.has_key('id'): del location['id'] location['degree'] = float(location.degree) location['tid'] = self.current_user.tid ret.location = location if callback: callback(ret) return lat, lon = get_latlon_from_cellid(0,0,0,0, self.current_user.sim) clat, clon = get_clocation_from_ge([lat,],[lon,]) clat = int(clat[0]) if len(clat)>0 else 0 clon = int(clon[0]) if len(clon)>0 else 0 name = get_location_name(clat, clon, self.redis) location = DotDict(category = 1, # cellid dev_id = self.current_user.tid, lat = lat, lon = lon, cLat = clat, cLon = clon, alt = 0, gps_time = int(time.time()), type = 1, speed = 0.0, degree = 0.0, name = name, cellid = None, locate_error = 20) if clat and clon: ret.location = DotDict() ret.location.latitude = lat ret.location.longitude = lon ret.location.clongitude = clon ret.location.clatitude = clat ret.location.timestamp = int(time.time()) ret.location.name = name ret.location.speed = 0 ret.location.type = 1 ret.location.tid = self.current_user.tid ret.location.degree = 0.0 ret.location.locte_error = 20 insert_location(location, self.db, self.redis) logging.info("[UWEB] tid %s cellid query success", self.current_user.tid) else: ret.status = ErrorCode.LOCATION_CELLID_FAILED ret.message = ErrorCode.ERROR_MESSAGE[ret.status] logging.info("[UWEB] Do not find any location, and cellid query failed. tid: %s", self.current_user.tid) if callback: callback(ret)
def post(self): try: data = DotDict(json_decode(self.request.body)) except Exception as e: status = ErrorCode.ILLEGAL_DATA_FORMAT logging.info("[UWEB] lastfinfo failed, message: %s, request: \n%s", ErrorCode.ERROR_MESSAGE[status], self.request.body) self.write_ret(status) return try: cars_info = OrderedDict() usable = 0 # nothing is modified, the cars_info is no use, use the data last time status = ErrorCode.SUCCESS terminals = self.db.query("SELECT tid FROM T_TERMINAL_INFO" " WHERE service_status = %s" " AND owner_mobile = %s" " AND login_permit = 1" " ORDER BY LOGIN DESC", UWEB.SERVICE_STATUS.ON, self.current_user.uid) tids = [terminal.tid for terminal in terminals] # 1 inquery data for tid in tids: # 1: get terminal info terminal = QueryHelper.get_terminal_info(tid, self.db, self.redis) if terminal['login'] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal['login'] = GATEWAY.TERMINAL_LOGIN.ONLINE # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location,] locations = get_locations_with_clatlon(locations, self.db) location = locations[0] self.redis.setvalue(location_key, location, EVENTER.LOCATION_EXPIRY) if location and location['name'] is None: location['name'] = '' if location and location['type'] == 1: # cellid location['locate_error'] = 500 # mile car_dct = {} car_info=dict(defend_status=terminal['defend_status'] if terminal['defend_status'] is not None else 1, mannual_status=terminal['mannual_status'] if terminal['mannual_status'] is not None else 1, fob_status=terminal['fob_status'] if terminal['fob_status'] is not None else 0, timestamp=location['timestamp'] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get('locate_error', 20) if location else 20, name=location.name if location else '', type=location.type if location else 1, latitude=location['latitude'] if location else 0, longitude=location['longitude'] if location else 0, clatitude=location['clatitude'] if location else 0, clongitude=location['clongitude'] if location else 0, login=terminal['login'] if terminal['login'] is not None else 0, bt_name=terminal.get('bt_name', '') if terminal else '', bt_mac=terminal.get('bt_mac', '') if terminal else '', gps=terminal['gps'] if terminal['gps'] is not None else 0, gsm=terminal['gsm'] if terminal['gsm'] is not None else 0, pbat=terminal['pbat'] if terminal['pbat'] is not None else 0, mobile=terminal['mobile'], owner_mobile=terminal['owner_mobile'], alias=terminal['alias'], #keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, fob_list=terminal['fob_list'] if terminal['fob_list'] else []) car_dct[tid]=car_info cars_info.update(car_dct) lastinfo_key = get_lastinfo_key(self.current_user.uid) # BIG NOTE: here, compare lastinfo and cars_info as str lastinfo = self.redis.get(lastinfo_key) lastinfo_time_key = get_lastinfo_time_key(self.current_user.uid) lastinfo_time = self.redis.getvalue(lastinfo_time_key) if lastinfo == str(cars_info): pass else: lastinfo_time = int(time.time()) self.redis.setvalue(lastinfo_key, cars_info) self.redis.setvalue(lastinfo_time_key, lastinfo_time) track_tid = data.get('track_tid', None) # use cache track_info = [] query_time = data.get('time', None) track_time = data.get('track_time', query_time) # 2 check whether provide usable data if data.get('cache', None): # use cache if query_time is not None: # use time if int(query_time) < lastinfo_time: usable = 1 if track_tid: if track_tid not in tids: logging.error("The terminal with tid: %s does not exist", track_tid) else: track_key = get_track_key(track_tid) self.redis.setvalue(track_key, 1, UWEB.TRACK_INTERVAL) if int(query_time) == -1: pass elif lastinfo_time - query_time > 1: # every 30 second, ternimal generate a location car_info = cars_info[track_tid] endtime = int(car_info['timestamp'])-1 if car_info['timestamp'] else int(lastinfo_time)-1 track = self.db.query("SELECT id, latitude, longitude," " clatitude, clongitude" " FROM T_LOCATION" " WHERE tid = %s" " AND NOT (latitude = 0 OR longitude = 0)" " AND (timestamp BETWEEN %s AND %s)" " AND type = 0" " ORDER BY timestamp", track_tid, int(track_time)+1, endtime) track = get_locations_with_clatlon(track, self.db) for item in track: if item['clatitude'] and item['clongitude']: track_info.append(item['clatitude']) track_info.append(item['clongitude']) else: cars_info = {} usable = 0 else: # no time if lastinfo == cars_info: cars_info = {} usable = 0 else: usable = 1 else: usable = 1 self.write_ret(status, dict_=DotDict(cars_info=cars_info, track_info=track_info, usable=usable, lastinfo_time=lastinfo_time)) except Exception as e: logging.exception("[UWEB] uid: %s, data: %s get lastinfo failed. Exception: %s", self.current_user.uid, data, e.args) status = ErrorCode.SERVER_BUSY self.write_ret(status)
def post(self): try: data = DotDict(json_decode(self.request.body)) track_lst = data.get('track_lst', []) current_time = int(time.time()) lastinfo_time = data.get('lastinfo_time') #NOTE: first time, lastinfo_time = -1, set the lsstinfo_time as current_time if lastinfo_time == -1: lastinfo_time = current_time except Exception as e: status = ErrorCode.ILLEGAL_DATA_FORMAT logging.info("[UWEB] lastfinfo for corp failed, message: %s, Exception: %s, request: \n%s", ErrorCode.ERROR_MESSAGE[status], e.args, self.request.body) self.write_ret(status) return try: status = ErrorCode.SUCCESS corp = self.db.get("SELECT cid, name, mobile FROM T_CORP WHERE cid = %s", self.current_user.cid) if self.current_user.oid == UWEB.DUMMY_OID: groups = self.db.query("SELECT id gid, name FROM T_GROUP WHERE corp_id = %s", self.current_user.cid) else: groups = self.db.query("SELECT group_id FROM T_GROUP_OPERATOR WHERE oper_id = %s", self.current_user.oid) gids = [g.group_id for g in groups] groups = self.db.query("SELECT id gid, name FROM T_GROUP WHERE id IN %s", tuple(DUMMY_IDS + gids)) res = DotDict(name=corp.name if corp else '', cid=corp.cid if corp else '', online=0, offline=0, groups=[], lastinfo_time=current_time) for group in groups: group['trackers'] = {} terminals = self.db.query("SELECT tid FROM T_TERMINAL_INFO" " WHERE group_id = %s" " AND (service_status = %s" " OR service_status = %s)", group.gid, UWEB.SERVICE_STATUS.ON, UWEB.SERVICE_STATUS.TO_BE_ACTIVATED) tids = [str(terminal.tid) for terminal in terminals] for tid in tids: group['trackers'][tid] = {} # 1: get terminal info terminal = QueryHelper.get_terminal_info(tid, self.db, self.redis) if terminal['login'] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal['login'] = GATEWAY.TERMINAL_LOGIN.ONLINE if terminal['login'] == GATEWAY.TERMINAL_LOGIN.ONLINE: res['online'] +=1 else: res['offline'] +=1 # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location,] #locations = get_locations_with_clatlon(locations, self.db) location = locations[0] self.redis.setvalue(location_key, location, EVENTER.LOCATION_EXPIRY) if location and location['name'] is None: location['name'] = '' if location and location['type'] == 1: # cellid location['locate_error'] = 500 # mile #1: build the basic_info basic_info=dict(defend_status=terminal['defend_status'] if terminal['defend_status'] is not None else 1, mannual_status=terminal['mannual_status'] if terminal['mannual_status'] is not None else 1, fob_status=terminal['fob_status'] if terminal['fob_status'] is not None else 0, timestamp=location['timestamp'] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get('locate_error', 20) if location else 20, name=location.name if location else '', type=location.type if location else 1, latitude=location['latitude'] if location else 0, longitude=location['longitude'] if location else 0, clatitude=location['clatitude'] if location else 0, clongitude=location['clongitude'] if location else 0, login=terminal['login'] if terminal['login'] is not None else 0, bt_name=terminal.get('bt_name', '') if terminal else '', bt_mac=terminal.get('bt_mac', '') if terminal else '', gps=terminal['gps'] if terminal['gps'] is not None else 0, gsm=terminal['gsm'] if terminal['gsm'] is not None else 0, pbat=terminal['pbat'] if terminal['pbat'] is not None else 0, mobile=terminal['mobile'], owner_mobile=terminal['owner_mobile'], alias=terminal['alias'], #keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, icon_type=terminal['icon_type'] if terminal.get('icon_type', None) is not None else 0, fob_list=terminal['fob_list'] if terminal['fob_list'] else []) #2: build track_info track_info = [] for item in track_lst: if tid == item['track_tid']: track_key = get_track_key(tid) self.redis.setvalue(track_key, 1, UWEB.TRACK_INTERVAL) endtime = int(basic_info['timestamp'])-1 if basic_info['timestamp'] else int(current_time)-1 points_track = self.db.query("SELECT id, latitude, longitude," " clatitude, clongitude, type, timestamp" " FROM T_LOCATION" " WHERE tid = %s" " AND NOT (latitude = 0 OR longitude = 0)" " AND (timestamp BETWEEN %s AND %s)" " AND type = 0" " ORDER BY timestamp", tid, int(item['track_time'])+1, endtime) #points_track = get_locations_with_clatlon(points_track, self.db) for point in points_track: if point['clatitude'] and point['clongitude']: t = dict(latitude=point['latitude'], longitude=point['longitude'], clatitude=point['clatitude'], clongitude=point['clongitude'], type=point['type'], timestamp=point['timestamp']) track_info.append(t) break #3: build trace_info trace_info = [] points_trace = self.db.query("SELECT distinct id, latitude, longitude," " clatitude, clongitude" " FROM T_LOCATION" " WHERE tid = %s" " AND NOT (latitude = 0 OR longitude = 0)" " AND (timestamp between %s and %s)" " AND type = 0" " ORDER BY timestamp", tid, int(current_time)-60*5, basic_info['timestamp']) #points_trace = get_locations_with_clatlon(points_trace, self.db) points_trace = points_trace[:5] len_trace = 0 if points_trace: for point in points_trace: if len_trace >= 5: break if point['clatitude'] and point['clongitude']: trace_info.append(point['clatitude']) trace_info.append(point['clongitude']) len_trace += 1 else: continue #4: build alert_info alarm_info_key = get_alarm_info_key(tid) alarm_info_all = self.redis.getvalue(alarm_info_key) alarm_info_all = alarm_info_all if alarm_info_all else [] alarm_info = [] if alarm_info_all: for alarm in alarm_info_all: #NOTE: here, check alarm's keeptime when kept in reids, not timestamp alarm occurs if alarm.get('keeptime', None) is None: alarm['keeptime'] = alarm['timestamp'] if alarm['keeptime'] >= lastinfo_time/1000: alarm_info.append(alarm) if alarm_info: # NOTE: here, do not remove alarm_info, it will automagically disappear after 1 day #self.redis.delete(alarm_info_key) #logging.info("[UWEB] lastinfo_time: %s, alarm_info_key: %s, alarm_info: %s", lastinfo_time, alarm_info_key, alarm_info) pass for alarm in alarm_info: alarm['alias'] = terminal['alias'] group['trackers'][tid]['basic_info'] = basic_info group['trackers'][tid]['track_info'] = track_info group['trackers'][tid]['trace_info'] = trace_info group['trackers'][tid]['alarm_info'] = alarm_info res.groups.append(group) self.write_ret(status, dict_=DotDict(res=res, res_type=3)) except Exception as e: logging.exception("[UWEB] cid: %s get corp lastinfo failed. Exception: %s", self.current_user.cid, e.args) status = ErrorCode.SERVER_BUSY self.write_ret(status)
def _on_finish(db): self.db = db try: data = DotDict(json_decode(self.request.body)) biz_type = data.get("biz_type", UWEB.BIZ_TYPE.YDWS) track_list = data.get("track_list", []) version_type = int(data.get("version_type", 0)) logging.info("[UWEB] Lastposition request: %s", data) except Exception as e: self.write_ret(ErrorCode.ILLEGAL_DATA_FORMAT) self.finish() return try: res = OrderedDict() usable = 1 status = ErrorCode.SUCCESS if data.get('tids', None): terminals = [] for tid in data.tids: terminal = QueryHelper.get_terminal_info(tid, self.db, self.redis) if terminal: terminals.append(DotDict(tid=tid)) else: logging.exception("[UWEB] tid: %s can not be found.", tid) else: if self.current_user.oid != UWEB.DUMMY_OID: # operator,Note: operator also has cid, so we check oid firstly. groups = self.db.query("SELECT group_id " " FROM T_GROUP_OPERATOR" " WHERE oper_id = %s", self.current_user.oid) gids = [g.group_id for g in groups] terminals = self.db.query("SELECT tid FROM T_TERMINAL_INFO" " WHERE (service_status = %s" " OR service_status = %s)" " AND biz_type = %s" " AND group_id IN %s" " ORDER BY LOGIN DESC", UWEB.SERVICE_STATUS.ON, UWEB.SERVICE_STATUS.TO_BE_ACTIVATED, biz_type, tuple(DUMMY_IDS + gids)) elif self.current_user.cid != UWEB.DUMMY_CID: # Corp groups = self.db.query("SELECT id gid, name " " FROM T_GROUP" " WHERE corp_id = %s", self.current_user.cid) gids = [g.gid for g in groups] terminals = self.db.query("SELECT tid FROM T_TERMINAL_INFO" " WHERE (service_status = %s" " OR service_status = %s)" " AND biz_type = %s" " AND group_id IN %s" " ORDER BY LOGIN DESC", UWEB.SERVICE_STATUS.ON, UWEB.SERVICE_STATUS.TO_BE_ACTIVATED, biz_type, tuple(DUMMY_IDS + gids)) else : # individual user #NOTE: only show the terminals with login_permit is 1 terminals = self.db.query("SELECT tid FROM T_TERMINAL_INFO" " WHERE (service_status = %s" " OR service_status = %s)" " AND biz_type = %s" " AND owner_mobile = %s" " AND login_permit = 1" " ORDER BY login DESC", UWEB.SERVICE_STATUS.ON, UWEB.SERVICE_STATUS.TO_BE_ACTIVATED, biz_type, self.current_user.uid) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info("[UWEB] Lastinfo step1 used time: %s > 5s", _now_time - _start_time) tids = [terminal.tid for terminal in terminals] for tid in tids: _now_time = time.time() if (_now_time - _start_time) > 5: logging.info("[UWEB] Lastinfo step2 used time: %s > 5s", _now_time - _start_time) res[tid] = {'car_info':{}, 'track_info':[]} # 0: get group info group_info = get_group_info_by_tid(self.db, tid) # 1: get terminal info terminal = QueryHelper.get_terminal_info(tid, self.db, self.redis) mobile = terminal['mobile'] if terminal['login'] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal['login'] = GATEWAY.TERMINAL_LOGIN.ONLINE # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location,] #locations = get_locations_with_clatlon(locations, self.db) location = locations[0] if location.clatitude and location.clongitude: self.redis.setvalue(location_key, location, EVENTER.LOCATION_EXPIRY) if location and location['name'] is None: location['name'] = location['name'] if location['name'] else '' if location and location['type'] == 1: # cellid location['locate_error'] = 500 # mile avatar_full_path, avatar_path, avatar_name, avatar_time = self.get_avatar_info(mobile) service_status = QueryHelper.get_service_status_by_tmobile(self.db, mobile) acc_status_info = QueryHelper.get_acc_status_info_by_tid(self.client_id, tid, self.db, self.redis) acc_message = acc_status_info['acc_message'] car_info=dict(defend_status=terminal['defend_status'] if terminal.get('defend_status', None) is not None else 1, service_status=service_status, mannual_status=terminal['mannual_status'] if terminal.get('mannual_status', None) is not None else 1, acc_message=acc_message, fob_status=terminal['fob_status'] if terminal.get('fob_status', None) is not None else 0, timestamp=location['timestamp'] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get('locate_error', 20) if location else 20, name=location.name if location else '', type=location.type if location else 1, latitude=location['latitude'] if location else 0, longitude=location['longitude'] if location else 0, clatitude=location['clatitude'] if location else 0, clongitude=location['clongitude'] if location else 0, login=terminal['login'] if terminal['login'] is not None else 0, bt_name=terminal.get('bt_name', '') if terminal else '', bt_mac=terminal.get('bt_mac', '') if terminal else '', dev_type=terminal['dev_type'] if terminal.get('dev_type', None) is not None else 'A', gps=terminal['gps'] if terminal['gps'] is not None else 0, gsm=terminal['gsm'] if terminal['gsm'] is not None else 0, pbat=terminal['pbat'] if terminal['pbat'] is not None else 0, mobile=terminal['mobile'], owner_mobile = terminal['owner_mobile'], alias=terminal['alias'] if terminal['alias'] else terminal['mobile'], #keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, group_id=group_info['group_id'], group_name=group_info['group_name'], icon_type=terminal['icon_type'], fob_list=terminal['fob_list'] if terminal['fob_list'] else [], avatar_path=avatar_path, avatar_time=avatar_time) res[tid]['car_info'] = car_info lastposition_key = get_lastposition_key(self.current_user.uid) lastposition = self.redis.get(lastposition_key) lastposition_time_key = get_lastposition_time_key(self.current_user.uid) lastposition_time = self.redis.getvalue(lastposition_time_key) if lastposition == str(res): pass else: lastposition_time = int(time.time()) self.redis.setvalue(lastposition_key, res) self.redis.setvalue(lastposition_time_key, lastposition_time) query_time = data.get('lastposition_time', None) # 2 check whether provide usable data if int(data.get('cache', 0)) == 1: # use cache if int(query_time) == lastposition_time: usable = 0 res = {} else: usable = 1 for item in track_list: track_tid = item['track_tid'] if track_tid not in tids: logging.error("The terminal with tid: %s does not exist", track_tid) else: track_time = item['track_time'] track_key = get_track_key(track_tid) self.redis.setvalue(track_key, 1, UWEB.TRACK_INTERVAL) car_info = res[track_tid]['car_info'] endtime = int(car_info['timestamp'])-1 if car_info['timestamp'] else int(lastposition_time)-1 track_info = self.get_track_info(track_tid, int(track_time)+1, endtime) res[track_tid]['track_info'] = track_info else: usable = 1 for item in track_list: track_tid = item['track_tid'] if track_tid not in tids: logging.error("The terminal with tid: %s does not exist", track_tid) else: track_time = item['track_time'] track_key = get_track_key(track_tid) self.redis.setvalue(track_key, 1, UWEB.TRACK_INTERVAL) car_info = res[track_tid]['car_info'] endtime = int(car_info['timestamp'])-1 if car_info['timestamp'] else int(time.time())-1 track_info = self.get_track_info(track_tid, int(track_time)+1, endtime) res[track_tid]['track_info'] = track_info if int(version_type) >= 1: terminals = [] for k, v in res.iteritems(): v.update({'tid':k}) terminals.append(v) self.write_ret(status, dict_=DotDict(terminals=terminals, usable=usable, lastposition_time=lastposition_time)) else: self.write_ret(status, dict_=DotDict(res=res, usable=usable, lastposition_time=lastposition_time)) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info("[UWEB] Lastinfo step3 used time: %s > 5s", _now_time - _start_time) except Exception as e: logging.exception("[UWEB] uid: %s get lastposition failed. Exception: %s", self.current_user.uid, e.args) status = ErrorCode.SERVER_BUSY self.write_ret(status) IOLoop.instance().add_callback(self.finish)
def _on_finish(db): self.db = db try: data = DotDict(json_decode(self.request.body)) track_lst = data.get("track_lst", []) # NOTE: nearly all timestamp's len is 10, here use 13 current_time = int(time.time() * 1000) lastinfo_time = data.get("lastinfo_time") except Exception as e: status = ErrorCode.ILLEGAL_DATA_FORMAT logging.info( "[UWEB] inlastfinfo for corp failed, message: %s, Exception: %s, request: \n%s", ErrorCode.ERROR_MESSAGE[status], e.args, self.request.body, ) self.write_ret(status) IOLoop.instance().add_callback(self.finish) return try: status = ErrorCode.SUCCESS REMOVE_GID_TID = [] # [(gid, tid),(gid,tid),] res_type = 0 # NOTE: first time, lastinfo_time = -1, set the lsstinfo_time # as current_time if lastinfo_time == -1: # logging.info("[UWEB] res_type=2, first time, cid:%s", self.current_user.cid) res_type = 2 lastinfo_time = current_time corp = self.db.get("SELECT cid, name, mobile FROM T_CORP WHERE cid = %s", self.current_user.cid) if self.current_user.oid == UWEB.DUMMY_OID: uid = self.current_user.cid groups = self.db.query("SELECT id gid, name FROM T_GROUP WHERE corp_id = %s" " ORDER BY id", uid) else: uid = self.current_user.oid groups = self.db.query("SELECT group_id FROM T_GROUP_OPERATOR WHERE oper_id = %s", uid) gids = [g.group_id for g in groups] groups = self.db.query( "SELECT id gid, name FROM T_GROUP WHERE id IN %s" " ORDER BY id", tuple(DUMMY_IDS + gids) ) corp_info = dict(name=corp["name"] if corp else "", cid=corp["cid"] if corp else "") corp_info_key = get_corp_info_key(uid) corp_info_tuple = self.redis.getvalue(corp_info_key) if corp_info_tuple: corp_info_old, corp_info_time = corp_info_tuple else: corp_info_old, corp_info_time = None, None if corp_info_old is not None: if corp_info_old != corp_info: # logging.info("[UWEB] res_type=2, corp_info changed, cid:%s", self.current_user.cid) res_type = 2 self.redis.setvalue(corp_info_key, (corp_info, current_time)) else: if lastinfo_time < corp_info_time: # logging.info("[UWEB] res_type=2, corp_info time changed, lastinfo_time:%s < corp_info_time:%s, cid:%s", # lastinfo_time, corp_info_time, # self.current_user.cid) res_type = 2 else: self.redis.setvalue(corp_info_key, (corp_info, current_time)) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step1_corp used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) res = DotDict( name=corp_info["name"], cid=corp_info["cid"], online=0, offline=0, groups=[], lastinfo_time=current_time, ) group_info_key = get_group_info_key(uid) group_info_tuple = self.redis.getvalue(group_info_key) if group_info_tuple: group_info_old, group_info_time = group_info_tuple else: group_info_old, group_info_time = None, None if group_info_old is not None: if group_info_old != groups: # logging.info("[UWEB] res_type=2, group_info changed, cid:%s", self.current_user.cid) res_type = 2 self.redis.setvalue(group_info_key, (groups, current_time)) else: if lastinfo_time < group_info_time: # logging.info("[UWEB] res_type=2, group_info time changed, lastinfo_time:%s < group_info_time:%s, cid:%s", # lastinfo_time, group_info_time, # self.current_user.cid) res_type = 2 else: self.redis.setvalue(group_info_key, (groups, current_time)) for group in groups: group["trackers"] = {} terminals = QueryHelper.get_terminals_by_group_id(group.gid, db) tids = [str(terminal.tid) for terminal in terminals] _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step1_group_sql used time: %s > 5s, cid: %s, gid: %s", _now_time - _start_time, self.current_user.cid, group.gid, ) terminal_info_key = get_group_terminal_info_key(uid, group.gid) terminal_info_tuple = self.redis.getvalue(terminal_info_key) if terminal_info_tuple: terminal_info_old, terminal_info_time = terminal_info_tuple else: terminal_info_old, terminal_info_time = None, None if terminal_info_old is not None: if terminal_info_old != tids: # logging.info("[UWEB] res_type=2, terminal_info changed, cid:%s", self.current_user.cid) res_type = 2 self.redis.setvalue(terminal_info_key, (tids, current_time)) else: if lastinfo_time < terminal_info_time: # logging.info("[UWEB] res_type=2, terminal_info time changed, lastinfo_time:%s < terminal_info_time:%s, cid:%s", # lastinfo_time, terminal_info_time, # self.current_user.cid) res_type = 2 else: self.redis.setvalue(terminal_info_key, (tids, current_time)) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step1_group used time: %s > 5s, cid: %s, gid: %s", _now_time - _start_time, self.current_user.cid, group.gid, ) for tid in tids: _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step2 used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) group["trackers"][tid] = {} # 1: get terminal info terminal = QueryHelper.get_terminal_info(tid, self.db, self.redis) if terminal["login"] == GATEWAY.TERMINAL_LOGIN.SLEEP: terminal["login"] = GATEWAY.TERMINAL_LOGIN.ONLINE if terminal["login"] == GATEWAY.TERMINAL_LOGIN.ONLINE: res["online"] += 1 else: res["offline"] += 1 # 2: get location location = QueryHelper.get_location_info(tid, self.db, self.redis) if location and not (location.clatitude or location.clongitude): location_key = get_location_key(str(tid)) locations = [location] # NOTE: offset latlon # locations = get_locations_with_clatlon(locations, self.db) location = locations[0] self.redis.setvalue(location_key, location, EVENTER.LOCATION_EXPIRY) if location and location["name"] is None: location["name"] = "" if location and location["type"] == 1: # cellid location["locate_error"] = 500 # mile acc_status_info = QueryHelper.get_acc_status_info_by_tid( self.client_id, tid, self.db, self.redis ) acc_message = acc_status_info["acc_message"] op_status = acc_status_info["op_status"] # 1: build the basic_info basic_info = dict( defend_status=terminal["defend_status"] if terminal["defend_status"] is not None else 1, mannual_status=terminal["mannual_status"] if terminal["mannual_status"] is not None else 1, acc_message=acc_message, op_status=op_status, fob_status=terminal["fob_status"] if terminal["fob_status"] is not None else 0, timestamp=location["timestamp"] if location else 0, speed=location.speed if location else 0, # NOTE: degree's type is Decimal, # float() it before json_encode degree=float(location.degree) if location else 0.00, locate_error=location.get("locate_error", 20) if location else 20, name=location.name if location else "", type=location.type if location else 1, latitude=location["latitude"] if location else 0, longitude=location["longitude"] if location else 0, clatitude=location["clatitude"] if location else 0, clongitude=location["clongitude"] if location else 0, login=terminal["login"] if terminal["login"] is not None else 0, bt_name=terminal.get("bt_name", "") if terminal else "", bt_mac=terminal.get("bt_mac", "") if terminal else "", dev_type=terminal["dev_type"] if terminal.get("dev_type", None) is not None else "A", gps=terminal["gps"] if terminal["gps"] is not None else 0, gsm=terminal["gsm"] if terminal["gsm"] is not None else 0, pbat=terminal["pbat"] if terminal["pbat"] is not None else 0, mobile=terminal["mobile"], owner_mobile=terminal["owner_mobile"], alias=terminal["alias"], # keys_num=terminal['keys_num'] if terminal['keys_num'] is not None else 0, keys_num=0, icon_type=terminal["icon_type"] if terminal.get("icon_type", None) is not None else 0, fob_list=terminal["fob_list"] if terminal["fob_list"] else [], ) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step2_basic used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) # 2: build track_info track_info = [] for item in track_lst: if tid == item["track_tid"]: track_key = get_track_key(tid) self.redis.setvalue(track_key, 1, UWEB.TRACK_INTERVAL) # endtime = int(basic_info['timestamp'])-1 if basic_info['timestamp'] else (current_time/1000)-1 endtime = int(basic_info["timestamp"]) - 1 points_track = [] logging.info( "[UWEB] tid: %s, track_time, %s, %s", tid, int(item["track_time"]) + 1, endtime ) # NOTE: offset latlon # points_track = get_locations_with_clatlon(points_track, self.db) for point in points_track: if point["clatitude"] and point["clongitude"]: t = dict( latitude=point["latitude"], longitude=point["longitude"], clatitude=point["clatitude"], clongitude=point["clongitude"], type=point["type"], timestamp=point["timestamp"], ) track_info.append(t) break _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step2_track used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) # 3: build trace_info trace_info = [] points_trace = [] points_trace = points_trace[-5:] # points_trace = get_locations_with_clatlon(points_trace, self.db) len_trace = 0 if points_trace: for point in points_trace: if len_trace >= 5: break if point["clatitude"] and point["clongitude"]: trace_info.append(point["clatitude"]) trace_info.append(point["clongitude"]) len_trace += 1 else: continue _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step2_trace used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) # 4: build alert_info alarm_info_key = get_alarm_info_key(tid) alarm_info_all = self.redis.getvalue(alarm_info_key) alarm_info_all = alarm_info_all if alarm_info_all else [] alarm_info = [] if alarm_info_all: for alarm in alarm_info_all: # NOTE: here, check alarm's keeptime when kept # in reids, not timestamp alarm occurs if alarm.get("keeptime", None) is None: alarm["keeptime"] = alarm["timestamp"] if alarm["keeptime"] >= lastinfo_time / 1000: alarm_info.append(alarm) for alarm in alarm_info: alarm["alias"] = terminal["alias"] _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step2_alarm used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) group["trackers"][tid]["basic_info"] = basic_info group["trackers"][tid]["track_info"] = track_info group["trackers"][tid]["trace_info"] = trace_info group["trackers"][tid]["alarm_info"] = alarm_info terminal_detail_key = get_group_terminal_detail_key(uid, group.gid, tid) terminal_detail_tuple = self.redis.getvalue(terminal_detail_key) if terminal_detail_tuple: terminal_detail_old, terminal_detail_time = terminal_detail_tuple else: terminal_detail_old, terminal_detail_time = None, None if res_type != 2: if terminal_detail_old is not None: if terminal_detail_old != group["trackers"][tid]: self.redis.setvalue(terminal_detail_key, (group["trackers"][tid], current_time)) # logging.info("[UWEB] res_type=1, terminal detail changed cid:%s", self.current_user.cid) res_type = 1 else: if lastinfo_time < terminal_detail_time: # logging.info("[UWEB] res_type=1, terminal detail time changed cid:%s", self.current_user.cid) res_type = 1 else: # logging.info("[UWEB] res_type=0, terminal detail no changed cid:%s", self.current_user.cid) REMOVE_GID_TID.append((group.gid, tid)) else: self.redis.setvalue(terminal_detail_key, (group["trackers"][tid], current_time)) else: pass res.groups.append(group) if res_type == 0: res = DotDict(lastinfo_time=current_time) self.write_ret(status, dict_=DotDict(res=res, res_type=res_type)) else: if res_type == 1: for gid, tid in REMOVE_GID_TID: # logging.info("[UWEB] res_type=1, gid: %s, tid: %s is tobe removed. cid:%s", # gid, tid, self.current_user.cid) for index, group in enumerate(res.groups): if gid == group["gid"]: del res.groups[index]["trackers"][tid] # logging.info("[UWEB] res_type=1, gid: %s, tid: %s is removed. cid:%s", # gid, tid, self.current_user.cid) _groups = deepcopy(res.groups) for index, group in enumerate(_groups): if not group["trackers"]: res.groups.remove(group) # logging.info("[UWEB] res_type=1, gid: %s, has no tracker, remove it. cid:%s", # gid, self.current_user.cid) self.write_ret(status, dict_=DotDict(res=res, res_type=res_type)) _now_time = time.time() if (_now_time - _start_time) > 5: logging.info( "[UWEB] Inclastinfo step3 used time: %s > 5s, cid: %s", _now_time - _start_time, self.current_user.cid, ) except Exception as e: logging.exception( "[UWEB] cid: %s get corp lastinfo failed. Exception: %s", self.current_user.cid, e.args ) status = ErrorCode.SERVER_BUSY self.write_ret(status) IOLoop.instance().add_callback(self.finish)