def get(self, request, args: str = None):
try:
if request.GET.get('page') == 'n':
username = request.GET.get('user')
mess = request.GET.get('mess')
opt = request.GET.get('opt')
if opt == 'u':
page_number = SqlOrder.objects.filter(
username=username, text__contains=mess).count()
sql = (
f'select core_sqlorder.*,core_databaselist.connection_name,\n'
f'core_databaselist.computer_room from core_sqlorder INNER JOIN \n'
f'core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \n'
f'WHERE core_sqlorder.username = %s and core_sqlorder.text like %s \n'
f'ORDER BY core_sqlorder.id desc;')
else:
page_number = SqlOrder.objects.filter(
username=username, work_id__contains=mess).count()
sql = (
f'select core_sqlorder.*,core_databaselist.connection_name,\n'
f'core_databaselist.computer_room from core_sqlorder INNER JOIN \n'
f'core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \n'
f'WHERE core_sqlorder.username = %s and core_sqlorder.work_id like %s \n'
f'ORDER BY core_sqlorder.id desc;')
info = SqlOrder.objects.raw(sql, [username, "%" + mess + "%"])
data = util.ser(info)
return Response({'page': page_number, 'data': data})
else:
try:
username = request.GET.get('user')
page = request.GET.get('page')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
page_number = SqlOrder.objects.filter(
username=username).count()
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.username = '******'ORDER BY core_sqlorder.id DESC "
% username)[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args=None):
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
pagenumber = SqlOrder.objects.filter(assigned=username).aggregate(alter_number=Count('id'))
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
'''
select core_sqlorder.*,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder \
INNER JOIN core_databaselist on \
core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.assigned = '%s'\
ORDER BY core_sqlorder.id desc
'''%username
)[start:end]
data = util.ser(info)
return Response({'page': pagenumber, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
try:
page = request.GET.get('page')
qurey = json.loads(request.GET.get('query'))
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
start = (int(page) - 1) * 20
end = int(page) * 20
if qurey['valve']:
if len(qurey['picker']) == 0:
info = SqlOrder.objects.filter(
username=request.user,
version__contains=qurey['version'],
text__contains=qurey['text']).order_by(
'-id').defer('sql')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text']).only('id').count()
else:
print("查询")
picker = []
query_builder = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text'],
version__contains=qurey['version'])
for i in qurey['picker']:
picker.append(i)
if picker[0] == "":
info = query_builder.defer('sql').order_by(
'-id')[start:end]
else:
info = query_builder.filter(
date__gte=picker[0],
date__lte=picker[1]).defer('sql').order_by(
'-id')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text']).only('id').count()
else:
info = SqlOrder.objects.filter(
username=request.user).defer('sql').order_by(
'-id')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user).only('id').count()
data = util.ser(info)
return Response({
'page': page_number,
'data': data,
'multi': custom_com['multi']
})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args=None):
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
pagenumber = SqlOrder.objects.filter(status=1, assigned=username).count()
start = int(page) * 10 - 10
end = int(page) * 10
sql = SqlOrder.objects.raw(
'''
select core_sqlorder.*,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder \
INNER JOIN core_databaselist on \
core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.status = 1 and core_sqlorder.assigned = '%s'\
ORDER BY core_sqlorder.id desc
''' % username
)[start:end]
data = util.ser(sql)
return Response({'data': data, 'page': pagenumber})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args=None):
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
pagenumber = SqlOrder.objects.filter(
status=1).all().values('id')
pagenumber.query.distinct = ['id']
start = int(page) * 10 - 10
end = int(page) * 10
sql = SqlOrder.objects.raw('''
select core_sqlorder.*,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder \
INNER JOIN core_databaselist on \
core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.status = 1 and core_sqlorder.assigned = '%s'\
ORDER BY core_sqlorder.id desc
''' % username)[start:end]
data = util.ser(sql)
return Response({'data': data, 'page': len(pagenumber)})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def put(self, request, args: str = None):
'''
:argument 当工单驳回后重新提交功能接口api
:param args: 根据获得order_id 返回对应被驳回的sql
:return:
'''
try:
order_id = request.data['id']
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.id = %s" % order_id)
data = util.ser(info)
sql = data[0]['sql'].split(';')
_tmp = ''
for i in sql:
_tmp += i + ";\n"
return Response({
'data': data[0],
'sql': _tmp.strip('\n'),
'type': 0
})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str=None):
try:
#username = request.GET.get('user')
username = str(request.user)
page = request.GET.get('page')
auth_user = request.user
DJANGO_INFO.info(f'{auth_user}:{username}')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
page_number = SqlOrder.objects.filter(
username=username).aggregate(alter_number=Count('id'))
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.username = '******'ORDER BY core_sqlorder.id DESC "
% username)[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def put(self, request, args: str = None):
'''
:argument 当工单驳回后重新提交功能接口api
:param args: 根据获得order_id 返回对应被驳回的sql
:return:
'''
try:
order_id = request.data['id']
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.id = %s" % order_id)
data = util.ser(info)
sql = data[0]['sql'].split(';')
_tmp = ''
for i in sql:
_tmp += i + ";\n"
return Response({'data': data[0], 'sql': _tmp.strip('\n'), 'type': 0})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args=None):
try:
page = request.GET.get('page')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
pagenumber = SqlOrder.objects.filter(
status=1, assigned=request.user).count()
start = int(page) * 10 - 10
end = int(page) * 10
sql = SqlOrder.objects.raw('''
select o.id,o.work_id,o.text,o.backup,o.date,o.assigned,
o.username,o.real_name,o.basename,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder as o \
INNER JOIN core_databaselist on \
o.bundle_id = core_databaselist.id where o.status = 1 and o.assigned = '%s'\
ORDER BY o.id desc
''' % request.user)[start:end]
data = util.ser(sql)
return Response({'data': data, 'page': pagenumber})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def post(self, request, args: str = None):
try:
id = request.data['id']
info = json.loads(request.data['opid'])
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
sql = []
for i in info:
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.id = %s"
% id)
data = util.ser(info)
_data = SqlRecord.objects.filter(sequence=i).first()
roll = rollback.rollbackSQL(db=_data.backup_dbname, opid=i)
link = _data.backup_dbname + '.' + roll
spa = rollback.roll(backdb=link, opid=i)
sql.append(spa)
_h = sorted([i[0][0] for i in sql])
return Response({'data': data[0], 'sql': _h, 'type': 1})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
'''
:argument 审核页面数据展示请求接口
:param None
:return 数据条数, 数据
'''
try:
workid = request.GET.get('workid', None)
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
print(e)
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
if workid:
info = CloudOrder.objects.get(workid=workid)
if info.type == 0:
info = onlineinfo_db.objects.filter(workid=workid)
data = util.ser(info)
elif info.type == 2:
info = addnewpcinfo_db.objects.filter(workid=workid)
data = util.ser(info)
else:
info = extendinfo_db.objects.filter(workid=workid)
data = util.ser(info)
return Response({'data': data})
else:
page_number = CloudOrder.objects.all().exclude(
status=4).aggregate(alter_number=Count('id'))
start = (int(page) - 1) * 20
end = int(page) * 20
info = CloudOrder.objects.all().exclude(
status=4).order_by('-date')[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
print(e)
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str=None):
try:
username = request.GET.get('user')
page = request.GET.get('page')
workid = request.GET.get('workid', None)
except KeyError as e:
client.captureException()
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
if workid:
info = CloudOrder.objects.get(workid=workid)
if info.type == 0:
info = onlineinfo_db.objects.filter(workid=workid)
data = util.ser(info)
elif info.type == 2:
info = addnewpcinfo_db.objects.filter(workid=workid)
data = util.ser(info)
else:
info = extendinfo_db.objects.filter(workid=workid)
data = util.ser(info)
return Response({'data': data})
else:
# if username == 'admin':
# page_number = CloudOrder.objects.all().order_by('-date').aggregate(alter_number=Count('id'))
# else:
page_number = CloudOrder.objects.filter(username=username).aggregate(alter_number=Count('id'))
start = (int(page) - 1) * 20
end = int(page) * 20
# if username == 'admin':
# info = CloudOrder.objects.all().order_by('-date')[start:end]
# else:
info = CloudOrder.objects.filter(username=username).order_by('-date')[start:end]
data = util.ser(info)
print(data)
return Response({'page': page_number, 'data': data})
except Exception as e:
client.captureException()
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def post(self, request, args: str = None):
'''
:argument 当工单执行后sql回滚功能接口api
:param args: 根据获得order_id 返回对应的回滚sql
:return: {'data': data[0], 'sql': rollback_sql, 'type': 1}
'''
try:
order_id = request.data['id']
tmp = list(set(json.loads(request.data['opid'])))
info = [x for x in tmp if x.find("0_0_") == -1]
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
sql = []
rollback_sql = []
dataset = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.id = %s" % order_id)
data = util.ser(dataset)
for i in info:
_data = SqlRecord.objects.filter(sequence=i).first()
roll = rollback.rollbackSQL(db=_data.backup_dbname, opid=i)
link = _data.backup_dbname + '.' + roll['tablename']
sql.append(rollback.roll(backdb=link, opid=i))
for i in sql:
for c in i:
rollback_sql.append(c['rollback_statement'])
rollback_sql = sorted(rollback_sql)
if rollback_sql == []: return HttpResponse(status=500)
rollback_sql = [{'sql': x} for x in rollback_sql]
return Response({
'data': data[0],
'sql': rollback_sql,
'type': 1
})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
'''
:argument 审核页面数据展示请求接口
:param None
:return 数据条数, 数据
'''
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
page_number = SqlOrder.objects.filter(
assigned=username).count()
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw('''
select o.id,o.work_id,o.text,o.backup,o.date,o.assigned,
o.username,o.real_name,o.status,o.basename,o.delay,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder as o \
INNER JOIN core_databaselist on \
o.bundle_id = core_databaselist.id where o.assigned = '%s'\
ORDER BY o.id desc
''' % username)[start:end]
data = util.ser(info)
info = Account.objects.filter(group='perform').all()
ser = serializers.UserINFO(info, many=True)
return Response({
'page': page_number,
'data': data,
'multi': custom_com['multi'],
'multi_list': ser.data
})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def post(self, request, args: str = None):
'''
:argument 当工单执行后sql回滚功能接口api
:param args: 根据获得order_id 返回对应的回滚sql
:return: {'data': data[0], 'sql': rollback_sql, 'type': 1}
'''
try:
order_id = request.data['id']
info = list(set(json.loads(request.data['opid'])))
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
sql = []
rollback_sql = []
for i in info:
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.id = %s"
% order_id)
data = util.ser(info)
_data = SqlRecord.objects.filter(sequence=i).first()
roll = rollback.rollbackSQL(db=_data.backup_dbname, opid=i)
link = _data.backup_dbname + '.' + roll['tablename']
sql.append(rollback.roll(backdb=link, opid=i))
for i in sql:
for c in i:
rollback_sql.append(c['rollback_statement'])
rollback_sql = sorted(rollback_sql)
if rollback_sql == []: return HttpResponse(status=500)
rollback_sql = [{'sql': x} for x in rollback_sql]
return Response({'data': data[0], 'sql': rollback_sql, 'type': 1})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
try:
page = request.GET.get('page')
qurey = json.loads(request.GET.get('query'))
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
start = (int(page) - 1) * 20
end = int(page) * 20
if qurey['valve']:
if len(qurey['picker']) == 0:
info = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text']).order_by(
'-id')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text']).count()
else:
picker = []
for i in qurey['picker']:
picker.append(i)
info = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text'],
date__gte=picker[0],
date__lte=picker[1]).order_by('-id')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user,
text__contains=qurey['text']).count()
else:
info = SqlOrder.objects.filter(
username=request.user).order_by('-id')[start:end]
page_number = SqlOrder.objects.filter(
username=request.user).count()
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
'''
:argument 审核页面数据展示请求接口
:param None
:return 数据条数, 数据
'''
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
page_number = SqlOrder.objects.filter(assigned=username).count()
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
'''
select core_sqlorder.*,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder \
INNER JOIN core_databaselist on \
core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.assigned = '%s'\
ORDER BY core_sqlorder.id desc
''' % username
)[start:end]
data = util.ser(info)
info = Account.objects.filter(group='perform').all()
ser = serializers.UserINFO(info, many=True)
return Response(
{'page': page_number, 'data': data, 'multi': custom_com['multi'], 'multi_list': ser.data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
try:
choice = request.GET.get('choice', None)
page = request.GET.get('page', None)
if choice == 'all':
page_number = modelist_db.objects.all().aggregate(
alter_number=Count('id'))
start = (int(page) - 1) * 10
end = int(page) * 10
info = modelist_db.objects.all()[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
info = modelist_db.objects.all().values('projectname', 'modename',
'servicename', 'base_port',
'jmx_port', 'http_port',
'dubbo_port')
temp_info = {}
for d in info:
if d['projectname'] not in temp_info.keys():
temp = {}
temp_info[d['projectname']] = []
temp[d['modename']] = []
temp[d['modename']].append(d['servicename'])
temp_info[d['projectname']].append(temp)
else:
temp = {}
temp_list = []
for data in temp_info[d['projectname']]:
print(type(data.keys()))
temp_list.append(list(data.keys())[0])
if d['modename'] in data.keys():
data[d['modename']].append(d['servicename'])
if d['modename'] not in temp_list:
temp = {}
temp[d['modename']] = []
temp[d['modename']].append(d['servicename'])
temp_info[d['projectname']].append(temp)
print(temp_info)
return Response({'data': temp_info})
except Exception as e:
client.captureException()
def get(self, request, args: str = None):
try:
username = request.GET.get('user')
page = request.GET.get('page')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
page_number = SqlOrder.objects.filter(
username=username).count()
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
"select core_sqlorder.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_sqlorder INNER JOIN \
core_databaselist on core_sqlorder.bundle_id = core_databaselist.id \
WHERE core_sqlorder.username = '******'ORDER BY core_sqlorder.id DESC "
% username)[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
try:
username = request.GET.get('user')
page = request.GET.get('page')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
else:
try:
page_number = ArchiveLog.objects.filter(
username=username).aggregate(alter_number=Count('id'))
start = (int(page) - 1) * 20
end = int(page) * 20
info = ArchiveInfo.objects.raw(
"select ArchiveLog.*,core_databaselist.connection_name,\
core_databaselist.computer_room from core_archive_log INNER JOIN \
core_databaselist on ArchiveLog.source_id = core_databaselist.id \
WHERE core_archive_log.created_user = '******'ORDER BY core_archive_log.id DESC "
% username)[start:end]
data = util.ser(info)
return Response({'page': page_number, 'data': data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
'''
:argument 审核页面数据展示请求接口
:param None
:return 数据条数, 数据
'''
try:
if request.GET.get('page') == 'n':
mess = request.GET.get('mess')
opt = request.GET.get('opt')
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
if opt == 'u' :
page_number = SqlOrder.objects.filter(username__contains = mess).count()
sql = (
f'select core_sqlorder.*,core_databaselist.connection_name,\n'
f'core_databaselist.computer_room from core_sqlorder\n'
f'INNER JOIN core_databaselist on\n'
f'core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.username like %s\n'
f'ORDER BY core_sqlorder.id desc;')
elif opt == 't':
page_number = SqlOrder.objects.filter(text__contains=mess).count()
sql = (
f'select core_sqlorder.*,core_databaselist.connection_name,\n'
f'core_databaselist.computer_room from core_sqlorder\n'
f'INNER JOIN core_databaselist on\n'
f'core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.text like %s\n'
f'ORDER BY core_sqlorder.id desc;')
else:
page_number = SqlOrder.objects.filter(work_id__contains = mess).count()
sql = (
f'select core_sqlorder.*,core_databaselist.connection_name,\n'
f'core_databaselist.computer_room from core_sqlorder\n'
f'INNER JOIN core_databaselist on\n'
f'core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.work_id like %s\n'
f'ORDER BY core_sqlorder.id desc;')
# //where core_sqlorder.work_id like '%'''+mess+'''%' ORDER BY core_sqlorder.id desc '''
info = SqlOrder.objects.raw(sql, ["%"+mess+"%"])
data = util.ser(info)
info = Account.objects.filter(group='perform').all()
ser = serializers.UserINFO(info, many=True)
return Response(
{'page': page_number, 'data': data, 'multi': custom_com['multi'], 'multi_list': ser.data})
else:
try:
page = request.GET.get('page')
username = request.GET.get('username')
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
page_number = SqlOrder.objects.filter(assigned=username).count()
start = (int(page) - 1) * 20
end = int(page) * 20
info = SqlOrder.objects.raw(
'''
select core_sqlorder.*,core_databaselist.connection_name, \
core_databaselist.computer_room from core_sqlorder \
INNER JOIN core_databaselist on \
core_sqlorder.bundle_id = core_databaselist.id where core_sqlorder.assigned = '%s'\
ORDER BY core_sqlorder.id desc
''' % username
)[start:end]
data = util.ser(info)
info = Account.objects.filter(group='perform').all()
ser = serializers.UserINFO(info, many=True)
return Response(
{'page': page_number, 'data': data, 'multi': custom_com['multi'], 'multi_list': ser.data})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
def get(self, request, args: str = None):
'''
:argument 审核页面数据展示请求接口
:param None
:return 数据条数, 数据
'''
try:
page = request.GET.get('page')
qurey = json.loads(request.GET.get('query'))
except KeyError as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
else:
try:
un_init = util.init_conf()
custom_com = ast.literal_eval(un_init['other'])
start = (int(page) - 1) * 20
end = int(page) * 20
u_mulit = Account.objects.filter(username=request.user).first()
if u_mulit.group == 'perform':
if qurey['valve']:
if len(qurey['picker']) == 0:
info = SqlOrder.objects.filter(
executor=request.user,
username__contains=qurey['user']).defer(
'sql').order_by('-id')[start:end]
page_number = SqlOrder.objects.filter(
executor=request.user,
username__contains=qurey['user']).only(
'id').count()
else:
picker = []
for i in qurey['picker']:
picker.append(i)
info = SqlOrder.objects.filter(
executor=request.user,
username__contains=qurey['user'],
date__gte=picker[0],
date__lte=picker[1]).defer('sql').order_by(
'-id')[start:end]
page_number = SqlOrder.objects.filter(
executor=request.user,
username__contains=qurey['user'],
date__gte=picker[0],
date__lte=picker[1]).only('id').count()
else:
page_number = SqlOrder.objects.filter(
executor=request.user).only('id').count()
info = SqlOrder.objects.filter(
executor=request.user).defer('sql').order_by(
'-id')[start:end]
else:
if qurey['valve']:
if len(qurey['picker']) == 0:
info = SqlOrder.objects.filter(
assigned=request.user,
username__contains=qurey['user']).defer(
'sql').order_by('-id')[start:end]
page_number = SqlOrder.objects.filter(
assigned=request.user,
username__contains=qurey['user']).only(
'id').count()
else:
picker = []
for i in qurey['picker']:
picker.append(i)
info = SqlOrder.objects.filter(
assigned=request.user,
username__contains=qurey['user'],
date__gte=picker[0],
date__lte=picker[1]).defer('sql').order_by(
'-id')[start:end]
page_number = SqlOrder.objects.filter(
assigned=request.user,
username__contains=qurey['user'],
date__gte=picker[0],
date__lte=picker[1]).only('id').count()
else:
page_number = SqlOrder.objects.filter(
assigned=request.user).only('id').count()
info = SqlOrder.objects.filter(
assigned=request.user).defer('sql').order_by(
'-id')[start:end]
data = util.ser(info)
info = Account.objects.filter(group='perform').all()
ser = serializers.UserINFO(info, many=True)
return Response({
'page': page_number,
'data': data,
'multi': custom_com['multi'],
'multi_list': ser.data
})
except Exception as e:
CUSTOM_ERROR.error(f'{e.__class__.__name__}: {e}')
return HttpResponse(status=500)
