def get(self, community_id, page_size, page): """查询小区的物业费缴费情况""" parser = reqparse.RequestParser() parser.add_argument('status', type=int, location='args') parser.add_argument('year', type=int, location='args') parser.add_argument('houseId', type=int, location='args') args = parser.parse_args() base_condition = '%%%s%%' status = args['status'] if args['status'] is not None else '' condition_status = base_condition % status house_id = args['houseId'] if house_id is None: fees = models.PropertyFee.query\ .filter_by(communityId=community_id)\ .filter(models.PropertyFee.status.like(condition_status))\ .order_by(models.PropertyFee.id.desc())\ .paginate(page, page_size, error_out=False).items else: fees = models.PropertyFee.query \ .filter_by(communityId=community_id) \ .filter_by(houseId=house_id) \ .filter(models.PropertyFee.status.like(condition_status)) \ .order_by(models.PropertyFee.id.desc()) \ .paginate(page, page_size, error_out=False).items return {'data': util.serialize(fees)}
def get(self, community_id, page_size, page): """分页查询报修情况""" parser = reqparse.RequestParser() parser.add_argument('type', type=int, location='args') parser.add_argument('userId', type=int, location='args') parser.add_argument('status', type=int, location='args') parser.add_argument('keyword', location='args') args = parser.parse_args() type_value = args['type'] if args['type'] is not None else '' condition_type = '%%%s%%' % type_value status = args['status'] if args['status'] is not None else '' condition_status = '%%%s%%' % status keyword = args['keyword'] if args['keyword'] is not None else '' condition = '%%%s%%' % keyword user_id = args['userId'] if user_id is None: fixes = models.Repair.query\ .filter(or_(models.Repair.description.like(condition), models.Repair.reporter.like(condition)))\ .filter(models.Repair.type.like(condition_type))\ .filter(models.Repair.status.like(condition_status))\ .filter_by(communityId=community_id)\ .order_by(models.Repair.reportTime.desc())\ .paginate(page, page_size, error_out=False).items else: fixes = models.Repair.query \ .filter(or_(models.Repair.description.like(condition), models.Repair.reporter.like(condition))) \ .filter(models.Repair.type.like(condition_type)) \ .filter(models.Repair.status.like(condition_status)) \ .filter_by(communityId=community_id) \ .filter_by(userId=user_id) \ .order_by(models.Repair.reportTime.desc()) \ .paginate(page, page_size, error_out=False).items return {'data': util.serialize(fixes)}
def get(self): parser = reqparse.RequestParser() parser.add_argument('thirdPartyId', required=True, location='args') args = parser.parse_args() third_party_id = args['thirdPartyId'] result = models.Community.query\ .filter_by(thirdPartyId=third_party_id).first() if result is None: return config.COMMUNITY_NOT_COOPERATE else: return {'data': util.serialize(result)}
def sendServerOnlinePacket(): '''孩儿们,老大王者归来了. ''' g.logger.debug('sendServerOnlinePacket sending') udpSocket = RunUdpServer.connectMultiCastServer() udpSocket.sendto(RunUdpServer._packData(command.server['sysServerOnline']), (setting.groupIp, setting.groupPort)) #发送 watchPath watchPathStr = util.serialize(setting.watchPath) udpSocket.sendto(RunUdpServer._packData(command.server['sysSendWatchPath'], str(len(watchPathStr))) + watchPathStr, (setting.groupIp, setting.groupPort)) udpSocket.close()
def post(self): """用户登录""" parser = reqparse.RequestParser() parser.add_argument('username', required=True) parser.add_argument('password', required=True) user = parser.parse_args() result = models.User.query.filter_by( username=user['username'], password=user['password']).first() if result is not None: return {'data': util.serialize(result, ['password'])} else: return config.USERNAME_OR_PASSWORD_ERROR
def get(self): parser = reqparse.RequestParser() parser.add_argument('communityId', type=int, location='args', required=True) parser.add_argument('buildingId', location='args', required=True) parser.add_argument('unitId', location='args', required=True) parser.add_argument('roomId', location='args', required=True) args = parser.parse_args() community_id = args['communityId'] building_id = args['buildingId'] unit_id = args['unitId'] room_id = args['roomId'] house = models.House.query.filter_by(communityId=community_id, buildingId=building_id, unitId=unit_id, roomId=room_id).first() return {'data': util.serialize(house)}
def get(self, community_id, page_size, page): """获取公告栏分页信息""" parser = reqparse.RequestParser() parser.add_argument('keyword', location='args') parser.add_argument('userId', type=int, location='args') args = parser.parse_args() base_condition = '%%%s%%' keyword = args['keyword'] if args['keyword'] is not None else '' condition = base_condition % keyword user_id = args['userId'] if user_id is not None and user_id != '': messages = models.BoardMessage.query\ .filter_by(userId=user_id)\ .filter(or_(models.BoardMessage.content.like(condition), models.BoardMessage.source.like(condition)))\ .filter(or_(models.BoardMessage.isTop.isnot(True), and_(models.BoardMessage.topEndTime > datetime.datetime.now(), models.BoardMessage.topStartTime < datetime.datetime.now())))\ .filter_by(communityId=community_id)\ .order_by(models.BoardMessage.topStartTime.desc(), models.BoardMessage.postTime.desc())\ .paginate(page, page_size, error_out=False).items else: messages = models.BoardMessage.query \ .filter(or_(models.BoardMessage.content.like(condition), models.BoardMessage.source.like(condition),)) \ .filter(or_(models.BoardMessage.isTop.isnot(True), and_( models.BoardMessage.topEndTime > datetime.datetime.now(), models.BoardMessage.topStartTime < datetime.datetime.now()))) \ .filter_by(communityId=community_id) \ .order_by(models.BoardMessage.topStartTime.desc(), models.BoardMessage.postTime.desc()) \ .paginate(page, page_size, error_out=False).items return {'data': util.serialize(messages, ['password'])}
def get(self, user_id): """获取某个用户信息""" user = models.User.query.filter_by(id=user_id).first() return {'data': util.serialize(user)}
def sysGetWatchPath(self, *args): g.logger.debug('sysGetWatchPath starting') watchPathStr = util.serialize(setting.watchPath) g.logger.debug('watchPathStr: %s' %watchPathStr) self._request(self._packData(command.server['sysSendWatchPath'], str(len(watchPathStr))) + watchPathStr)