def get(self): parser = RequestParser(trim=True) parser.add_argument('name', type=str) args = parser.parse_args(strict=True) criterion = set() if args['name']: criterion.add(ConfigCountries.name == args['name']) pagination = paginate(ConfigCountries.query, criterion, 1, 300) return make_response_from_pagination(pagination)
def post(self): parser = RequestParser() parser.add_argument('page', type=int) parser.add_argument('pageSize', type=int) parser.add_argument('code', type=str) args = parser.parse_args() shijianchuo = int(time.time()) actiontime = shijianchuo - 2592000 criterion = set() criterion.add(EntertainmentCityTradeLog.ec == args['code']) criterion.add(EntertainmentCityTradeLog.state == 1) criterion.add(EntertainmentCityTradeLog.actionTime > actiontime) query = db.session.query(distinct(EntertainmentCityTradeLog.username)) pagination = paginate(query, criterion, args['page'], args['pageSize']) if not pagination.items: return {"errorMsg": "目前没有会员创建该娱乐城钱包"} result = [] for user in pagination.items: data = {} user = list(user) user = (' '.join(user)) data['username'] = user data['code'] = args['code'] member = UpdataallWallet(user) m_data = member.everybalence(args['code'], user) m_data = m_data.content.decode() m_data = json.loads(m_data) # '''{"Guid": "cf2bce64-528b-40dd-8d1a-a9afae96ee5b", "Success": true, "Code": "0", "Message": "Success", "Data": {"balance": "0", "CurrencyCode": null}}''' if m_data['Code'] == "0": data['state'] = 1 data['balance'] = "%.2f" % float(m_data['Data']['balance']) result.append(data) else: data['state'] = 0 data['balance'] = '--' result.append(data) history = OperationalRecord() history.username = g.current_user.username history.creatTime = time_to_value() history.remark = "更新%s所有钱包" % args['code'] history.ylc = args['code'] try: db.session.add(history) db.session.commit() except: db.session.rollback() db.session.remove() return make_response(result, page=pagination.page, pages=pagination.pages, total=pagination.total)
def get(self): parser = RequestParser() parser.add_argument('page', type=int, default=DEFAULT_PAGE) parser.add_argument('pageSize', type=int, default=DEFAULT_PAGE_SIZE) parser.add_argument('name', type=str) parser.add_argument('starttime', type=int) parser.add_argument('endtime', type=int) parser.add_argument('include', type=str) parser.add_argument('exclude', type=str) parser.add_argument('username', type=str) args = parser.parse_args(strict=True) criterion = set() criterion.add(OperationalRecord.ylc == args['name']) if args['starttime']: criterion.add(OperationalRecord.creatTime >= args['starttime']) if args['endtime']: criterion.add(OperationalRecord.creatTime <= args['endtime']) if args["include"]: a = args["include"].split(',') b = [] for i in a: c = '%{}%'.format(i) b.append(c) criterion.add(or_(*[OperationalRecord.remark.like(w) for w in b])) if args["exclude"]: a = args["exclude"].split(',') b = [] for i in a: c = '%{}%'.format(i) b.append(c) criterion.add( and_(*[OperationalRecord.remark.notlike(w) for w in b])) if args['username']: criterion.add(OperationalRecord.username == args['username']) query = db.session.query(OperationalRecord).order_by( OperationalRecord.creatTime.desc()) result = [] pagination = paginate(query, criterion, args['page'], args['pageSize']) for item in pagination.items: result.append({ 'id': item.id, 'username': item.username, 'createtime': item.creatTime, 'remark': item.remark }) return make_response(result, page=pagination.page, pages=pagination.pages, total=pagination.total)
def get(self): parser = RequestParser(trim=True) parser.add_argument('page', type=int, default=DEFAULT_PAGE) parser.add_argument('pageSize', type=int, default=DEFAULT_PAGE_SIZE) parser.add_argument('username', type=str) parser.add_argument('yulecheng', type=str) parser.add_argument('TimeLower', type=int) parser.add_argument('TimeUpper', type=int) parser.add_argument('amountLower', type=int) parser.add_argument('amountUpper', type=int) parser.add_argument('state', type=str) parser.add_argument('buquan', type=int) args = parser.parse_args(strict=True) criterion = set() criterion.add( and_(EntertainmentCityTradeLog.state != 0, EntertainmentCityTradeLog.state != 1)) if 'buquan' in args and args['buquan'] is not None: if args['buquan'] == 1: criterion.add(EntertainmentCityTradeLog.state == 3) if 'username' in args and args['username'] is not None: criterion.add( EntertainmentCityTradeLog.username == args['username']) if 'yulecheng' in args and args['yulecheng'] is not None: ylcname = args['yulecheng'].split(',') criterion.add( or_(EntertainmentCityTradeLog.ec.in_(ylcname), EntertainmentCityTradeLog.last_ec.in_(ylcname))) if 'TimeLower' in args and args['TimeLower'] is not None: criterion.add(EntertainmentCityTradeLog.actionTime >= args['TimeLower']) if 'TimeUpper' in args and args['TimeUpper'] is not None: criterion.add(EntertainmentCityTradeLog.actionTime <= args['TimeUpper']) if 'amountLower' in args and args['amountLower'] is not None: criterion.add( EntertainmentCityTradeLog.amount >= args['amountLower'] ) if 'amountUpper' in args and args['amountUpper'] is not None: criterion.add( EntertainmentCityTradeLog.amount <= args['amountUpper'] ) else: if 'username' in args and args['username'] is not None: criterion.add( EntertainmentCityTradeLog.username == args['username']) if 'yulecheng' in args and args['yulecheng'] is not None: ylcname = args['yulecheng'].split(',') criterion.add( or_(EntertainmentCityTradeLog.ec.in_(ylcname), EntertainmentCityTradeLog.last_ec.in_(ylcname))) if 'TimeLower' in args and args['TimeLower'] is not None: criterion.add( EntertainmentCityTradeLog.actionTime >= args['TimeLower']) if 'TimeUpper' in args and args['TimeUpper'] is not None: criterion.add( EntertainmentCityTradeLog.actionTime <= args['TimeUpper']) if 'amountLower' in args and args['amountLower'] is not None: criterion.add( EntertainmentCityTradeLog.amount >= args['amountLower']) if 'amountUpper' in args and args['amountUpper'] is not None: criterion.add( EntertainmentCityTradeLog.amount <= args['amountUpper']) if 'state' in args and args['state'] is not None: state = args['state'].split(',') criterion.add(or_(EntertainmentCityTradeLog.state.in_(state))) query = db.session.query( EntertainmentCityTradeLog.id, EntertainmentCityTradeLog.uid, EntertainmentCityTradeLog.username, EntertainmentCityTradeLog.operator, EntertainmentCityTradeLog.ec, EntertainmentCityTradeLog.last_ec, EntertainmentCityTradeLog.actionTime, EntertainmentCityTradeLog.amount, EntertainmentCityTradeLog.state, EntertainmentCityTradeLog.type, EntertainmentCityTradeLog.orderid, ).order_by(EntertainmentCityTradeLog.actionTime.desc()) result = [] pagination = paginate(query, criterion, args['page'], args['pageSize']) for item in pagination.items: result.append({ 'id': item.id, 'uid': item.uid, 'username': item.username, 'ec': item.ec, 'last_ec': item.last_ec, 'actionTime': item.actionTime, 'amount': item.amount, 'state': item.state, 'type': item.type, 'operator': item.operator, 'orderid': item.orderid }) return make_response(result, page=pagination.page, pages=pagination.pages, total=pagination.total)
def get(self): parser = RequestParser(trim=True) parser.add_argument('page', type=int, default=DEFAULT_PAGE) parser.add_argument('pageSize', type=int, default=DEFAULT_PAGE_SIZE) parser.add_argument('username', type=str) parser.add_argument('yulecheng', type=str) parser.add_argument('TimeLower', type=int) parser.add_argument('TimeUpper', type=int) args = parser.parse_args(strict=True) criterion = set() if 'username' in args and args['username'] is not None: criterion.add( EntertainmentCityTradeLog.username == args['username']) else: return {"errorMsg": "账号不能为空"} if 'yulecheng' in args and args['yulecheng'] is not None: ylcname = args['yulecheng'].split(',') if ylcname is not None: criterion.add( or_(EntertainmentCityTradeLog.ec.in_(ylcname), EntertainmentCityTradeLog.last_ec.in_(ylcname))) else: return {"errorMsg": "请选择要查询的娱乐城"} if 'TimeLower' in args and args['TimeLower'] is not None: criterion.add( EntertainmentCityTradeLog.actionTime >= args['TimeLower']) else: return {"errorMsg": "请填写起始时间"} if 'TimeUpper' in args and args['TimeUpper'] is not None: criterion.add( EntertainmentCityTradeLog.actionTime <= args['TimeUpper']) else: return {"errorMsg": "请填写结束时间"} query = db.session.query( EntertainmentCityTradeLog.id, EntertainmentCityTradeLog.uid, EntertainmentCityTradeLog.username, EntertainmentCityTradeLog.ec, EntertainmentCityTradeLog.last_ec, EntertainmentCityTradeLog.actionTime, EntertainmentCityTradeLog.orderid, EntertainmentCityTradeLog.amount, EntertainmentCityTradeLog.state, EntertainmentCityTradeLog.type).order_by( EntertainmentCityTradeLog.actionTime.desc()) result = [] pagination = paginate(query, criterion, args['page'], args['pageSize']) for item in pagination.items: result.append({ 'id': item.id, 'uid': item.uid, 'username': item.username, 'ec': item.ec, 'last_ec': item.last_ec, 'actionTime': item.actionTime, 'orderid': item.orderid, 'amount': item.amount, 'state': item.state, 'type': item.type }) return make_response(result, page=pagination.page, pages=pagination.pages, total=pagination.total)
def getPlayedByType(self, criterion, page, pageSize): m_query = db.session.query(BlastPlayedGroupCredit) pagination = paginate(m_query, criterion, page, pageSize) return pagination
def getDataType(self, page, pageSize, criterion): m_query = db.session.query(BlastType) pagination = paginate(m_query, criterion, page, pageSize) return pagination
def getData(self,criterion, page, pageSize): m_query = db.session.query(BlastLHCRatio) pagination = paginate(m_query, criterion, page, pageSize) return pagination
def getPlayedByGroupId(self,criterion,page,pageSize): m_query = db.session.query(BlastPlayed) pagination = paginate(m_query, criterion, page, pageSize) return pagination
def getBlastDataAdmin(self, criterion, page, pageSize): m_query = db.session.query(BlastDataAdmin).order_by( desc(BlastDataAdmin.actionNo)) pagination = paginate(m_query, criterion, page, pageSize) return pagination