class PowerLineVoltageArrayRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) args = parser.parse_args() voltage = args.get('voltage') linename = args.get('linename') rs = [] if (linename == None): rs = self.dao.query_lineVoltage(voltage) else: rs = self.dao.query_lineVoltageBlur(voltage, linename) if rs == None: return make_response( jsonify({ 'error': '根据电压等级查询线路信息失败', 'errorcode': 10000000 }), 401) else: return json.dumps(obj=rs) def get(self): return self.post()
class PowerLineTypeRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) args = parser.parse_args() linename = args.get('linename') rs = [] if (linename == None or linename == ''): rs = self.dao.query_lineTypes() else: rs = self.dao.query_lineTypesBlur(linename) if rs == None: return make_response( jsonify({ 'error': '查询线路电压等级失败', 'errorcode': 10000000 }), 401) else: return rs #else: # return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
def ClassifyPhoto(self,towers,photoPath,date,basefolder): #纬度一度的差异 直接计算差异比坐标转换之后再计算虽然在精度上下降了,但是效率上得到了很大的提高 # 综合考虑之后采用直接通过经度和纬度差异的方式进行计算 unitLat = 111000.0 photoCoordinate = self.GetPhotoCoordinate(photoPath) if photoCoordinate==None: return None dis = [] for towerItem in towers: unitLng = unitLat*math.cos(math.radians(photoCoordinate['lat'])) dLat = (towerItem['tower_lat']-photoCoordinate['lat'])*unitLat*(towerItem['tower_lat']-photoCoordinate['lat'])*unitLat dLng = (towerItem['tower_lng']-photoCoordinate['lng'])*unitLng*(towerItem['tower_lng']-photoCoordinate['lng'])*unitLng dis.append(math.sqrt(dLat+dLng)) index = dis.index(min(dis)) #将文件移动到对应的文件夹下 daoLine=LinesDao() line=daoLine.query_line_fuzzy(towers[index]['tower_linename']) filename=os.path.basename(photoPath) #构建目标路径 basePath = '\\'+str(line[0]['lines_voltage'])+'\\'+str(line[0]['lines_id'])+'\\'+str(towers[index]['tower_id'])+'\\'+date+'\\未分类\\'+filename distPath= basefolder+basePath #移动文件夹 self.MoveFile(photoPath,distPath) return (basePath,index,line[0]['lines_id'])
class PowerLineVoltageRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) args = parser.parse_args() voltage = args.get('voltage') rs = self.dao.query_lineVoltage(voltage) if rs == None: return make_response(jsonify({'error': 'Unauthorized access'}), 401) else: return rs #else: # return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
class PowerLineSearchFuzzy(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) args = parser.parse_args() linename = args.get('linename') rs = self.dao.query_line_fuzzy(linename) if rs == None: return make_response( jsonify({ 'error': '根据线路名称查询线路信息失败', 'errorcode': 10000000 }), 401) else: return json.dumps(rs) #else: # return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
class PowerLineListRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) rs = self.dao.query_lines() if rs == None: return make_response( jsonify({ 'error': '查询线路信息失败', 'errorcode': 10000000 }), 401) else: return rs #else: # return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
class PowerLineListPageRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): #if (request.data != ""): # data = json.loads(request.data) # token = data['token'] # user = self.userDao.verify_token(token, '') # if (not user): # return make_response(jsonify({'error': 'Unauthorized access'}), 401) args = parser.parse_args() work_team = args.get('work_team') page_size = args.get('page_size') page_index = args.get('page_index') rs = self.dao.query_line_pages(work_team, page_size, page_index) if rs == None: return make_response( jsonify({ 'error': '查询线路信息失败', 'errorcode': 10000000 }), 401) else: return rs #else: # return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
class PowerLineTowerQueryRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): if (request.data != ""): data = json.loads(request.data) token = data['token'] user = self.userDao.verify_token(token, '') if (not user): return make_response( jsonify({ 'error': '用户不存在或登录过期', 'errorcode': 10000000 }), 400) if user == 1010301: return make_response( jsonify({ 'error': '登录过期', 'errorcode': user }), 400) if user == 1010302: return make_response( jsonify({ 'error': '用户验证错误', 'errorcode': user }), 400) args = parser.parse_args() voltage = args.get('voltage') work_team = args.get('work_team') line_name = args.get('line_name') page_size = args.get('page_size') page_index = args.get('page_index') rs = self.dao.query_line_condition(user, voltage, work_team, line_name, page_size, page_index) if rs == None: return make_response( jsonify({ 'error': '查询杆塔信息失败', 'errorcode': 10000000 }), 401) else: return rs else: return make_response(jsonify({'error': 'Unauthorized access'}), 401) def get(self): return self.post()
def post(self): if (request.data != ""): data = json.loads(request.data) token = data['token'] args = parser.parse_args() voltage = args.get('voltage') work_team = args.get('work_team') line_name = args.get('line_name') page_size = args.get('page_size') user = self.userDao.verify_token(token, '') if (not user): return make_response(jsonify({'error': 'Unauthorized access'}), 401) lineDao = LinesDao() rs = lineDao.query_tower_pages(user, voltage, work_team, line_name, page_size) if rs == None: return make_response(jsonify({'error': 'Unauthorized access'}), 401) else: return rs else: return make_response(jsonify({'error': 'Unauthorized access'}), 401)
class PowerLineListPages(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): if (request.data != ""): data = json.loads(request.data) token = data['token'] args = parser.parse_args() work_team = args.get('work_team') page_size = args.get('page_size') user = self.userDao.verify_token(token, '') user = self.userDao.verify_token(token, '') if (not user): return make_response( jsonify({ 'error': '用户不存在或登录过期', 'errorcode': 10000000 }), 400) if user == 1010301: return make_response( jsonify({ 'error': '登录过期', 'errorcode': user }), 400) if user == 1010302: return make_response( jsonify({ 'error': '用户验证错误', 'errorcode': user }), 400) rs = self.dao.query_line_pagesNumber(user, work_team, page_size) if rs == None: return make_response( jsonify({ 'error': '查询线路分页数失败', 'errorcode': 10000000 }), 401) else: return rs return make_response(jsonify({'error': '传入参数错误'}), 401) def get(self): return self.post()
class PowerLineAddRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): if (request.data != ""): data = json.loads(request.data) token = data['token'] lineInfo = data['line'] user = self.userDao.verify_token(token, '') if (not user): return make_response( jsonify({ 'error': '用户不存在或登录过期', 'errorcode': 10000000 }), 400) if user == 1010301: return make_response( jsonify({ 'error': '登录过期', 'errorcode': user }), 400) if user == 1010302: return make_response( jsonify({ 'error': '用户验证错误', 'errorcode': user }), 400) line = Lines() line.lines_name = lineInfo[0]['lines_name'] line.lines_construct_date = lineInfo[0]['lines_construct_date'] line.lines_voltage = lineInfo[0]['lines_voltage'] line.lines_work_team = lineInfo[0]['lines_work_team'] line.lines_incharge = lineInfo[0]['lines_incharge'] rs = self.dao.add_line(user, line) if rs == 3010901: return make_response(jsonify({'error': '没有权限添加线路'}), 401) else: return make_response(jsonify({'success': '添加线路成功'}), 200) return make_response(jsonify({'error': '传入参数错误'}), 401) def get(self): return self.post()
class PowerLineDeleteRoute(Resource): def __init__(self): self.dao = LinesDao() self.userDao = UserDAO() def post(self): if (request.data != ""): data = json.loads(request.data) token = data['token'] user = self.userDao.verify_token(token, '') if (not user): return make_response( jsonify({ 'error': '用户不存在或登录过期', 'errorcode': 10000000 }), 401) if user == 1010301: return make_response( jsonify({ 'error': '登录过期', 'errorcode': user }), 401) if user == 1010302: return make_response( jsonify({ 'error': '用户验证错误', 'errorcode': user }), 400) args = parser.parse_args() lineid = args.get('lineid') rs = self.dao.query_line_delete(user, lineid) if rs != 1: return make_response( jsonify({ 'error': '根据线路id查询线路信息失败', 'error': 10000000 }), 401) else: return rs else: return make_response(jsonify({'error': '没有登录,无权限查询线路信息'}), 401) def get(self): return self.post()
def __init__(self): self.dao = LinesDao() self.userDao = UserDAO