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
