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)