def search_device(request):
ip_address = request.GET.get('ip_address', '')
device_name = request.GET.get('device_name', '')
if ip_address != '' and device_name == '':
device_all_list = Device.objects.filter(device_ip=ip_address)
elif device_name != '' and ip_address == '':
device_all_list = Device.objects.filter(
device_name__icontains=device_name)
elif ip_address != '' and device_name != '':
device_all_list = Device.objects.filter(
device_name__icontains=device_name, device_ip=ip_address)
else:
device_all_list = Device.objects.all()
page_of_objects, page_range = pages(request, device_all_list)
context = {}
context['devices'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['search_device_name'] = device_name
context['search_ip_address'] = ip_address
context['count'] = Device.objects.all().count()
return render(request, 'device_list.html', context)
def search_porterror_fix(request):
context = {}
port_error_fix_record_search_form = PortErrorFixRecordSearchForm(
request.GET)
if port_error_fix_record_search_form.is_valid():
time_begin = port_error_fix_record_search_form.cleaned_data[
'time_begin']
time_end = port_error_fix_record_search_form.cleaned_data['time_end']
fix_records = PortErrorFixRecord.objects.exclude(
problem_detail__icontains='系统自判').filter(
begin_time__range=(time_begin,
time_end)).order_by('-begin_time')
else:
context[
'port_error_fix_record_search_form'] = PortErrorFixRecordSearchForm(
)
return render(request, 'port_error_fix_record_list.html', context)
page_of_objects, page_range = pages(request, fix_records)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['time_begin'] = timezone.datetime.strftime(time_begin,
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_end,
'%Y-%m-%d+%H:%M:%S')
context[
'port_error_fix_record_search_form'] = port_error_fix_record_search_form
return render(request, 'port_error_fix_record_list.html', context)
def search_group_client(request):
context = {}
group_client_search_form = GroupClientSearchForm(request.GET)
if group_client_search_form.is_valid():
client_name = group_client_search_form.cleaned_data['client_name']
product_id = group_client_search_form.cleaned_data['product_id']
if client_name != '' and product_id is None:
group_client_all_list = ZxClientInfo.objects.raw(
__GROUP_CLIENT_QUERY +
"HAVING client_info.client_name like '%{}%'".format(
client_name))
elif client_name == '' and product_id is not None:
group_client_all_list = ZxClientInfo.objects.raw(
__GROUP_CLIENT_QUERY +
"HAVING client_info.product_id = {}".format(product_id))
elif client_name != '' and product_id is not None:
group_client_all_list = ZxClientInfo.objects.raw(
__GROUP_CLIENT_QUERY +
"HAVING client_info.client_name like '%{}%' and client_info.product_id = {}"
.format(client_name, product_id))
else:
group_client_all_list = ZxClientInfo.objects.raw(
__GROUP_CLIENT_QUERY)
else:
context['group_client_search_form'] = group_client_search_form
return render(request, 'group_client_list.html', context)
page_of_objects, page_range = pages(request, group_client_all_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['group_client_search_form'] = group_client_search_form
return render(request, 'group_client_list.html', context)
def search_oneway(request):
context = {}
oneway_search_form = OneWaySearchForm(request.GET)
if oneway_search_form.is_valid():
time_begin = oneway_search_form.cleaned_data['time_begin']
time_end = oneway_search_form.cleaned_data['time_end']
device_name = oneway_search_form.cleaned_data['device_name']
device_filter = ''
if device_name != '' or device_name is not None:
device_filter = "HAVING device_name like '%{}%' ".format(
device_name)
oneway_all_list = OneWayDevice.objects.raw(
__QUERY_ONEWAY_LIST + device_filter + __ONEWAY_ORDER_FIELD,
(time_begin, time_end))
else:
context['oneway_search_form'] = oneway_search_form
context['oneway_tag_form'] = OneWayTagForm()
return render(request, 'oneway_list.html', context)
page_of_objects, page_range = pages(request, oneway_all_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context[
'search_paras'] = 'time_begin={}&time_end={}&device_name={}'.format(
timezone.datetime.strftime(time_begin, '%Y-%m-%d+%H:%M:%S'),
timezone.datetime.strftime(time_end, '%Y-%m-%d+%H:%M:%S'),
device_name)
context['oneway_search_form'] = oneway_search_form
context['oneway_tag_form'] = OneWayTagForm()
return render(request, 'oneway_list.html', context)
def porterror_fix_list(request):
context = {}
time_begin = request.GET.get('time_begin', '')
time_end = request.GET.get('time_end', '')
if time_begin == '' or time_end == '':
today_time = timezone.datetime.now()
time_end = timezone.datetime(year=today_time.year,
month=today_time.month,
day=today_time.day,
hour=23,
minute=59,
second=59)
time_begin = time_end + timezone.timedelta(days=-2) # 默认下载当天的数据
else:
time_begin = timezone.datetime.strptime(time_begin,
'%Y-%m-%d %H:%M:%S')
time_end = timezone.datetime.strptime(time_end, '%Y-%m-%d %H:%M:%S')
# fix_records = PortErrorFixRecord.objects.all().order_by('-begin_time')
fix_records = PortErrorFixRecord.objects.exclude(
problem_detail__icontains='系统自判').order_by('-begin_time')
page_of_objects, page_range = pages(request, fix_records)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['time_begin'] = timezone.datetime.strftime(time_begin,
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_end,
'%Y-%m-%d+%H:%M:%S')
context[
'port_error_fix_record_search_form'] = PortErrorFixRecordSearchForm()
return render(request, 'port_error_fix_record_list.html', context)
def port_error_list(request):
order_field = request.GET.get('order_field', 'crc')
time_begin, time_end = getDateRange(-2) # 默认-2
time_range = (time_begin, time_end)
porterror_query = __queryline(order_field)
porterror_all_list = PortErrorDiff.objects.raw(
porterror_query, (time_begin, time_end, time_begin, time_end))
page_of_objects, page_range = pages(request, porterror_all_list)
my_tasks_cnt = 0
if request.user.is_authenticated:
my_tasks_cnt = PortErrorFixRecord.objects.filter(
worker=request.user.first_name, status=False).count()
context = {}
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['time_begin'] = timezone.datetime.strftime(time_range[0],
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_range[1],
'%Y-%m-%d+%H:%M:%S')
context['order_field'] = order_field
context['my_tasks_cnt'] = my_tasks_cnt
context['porterror_search_form'] = PortErrorSearchForm()
return render(request, 'port_error_list.html', context)
def device_list(request):
device_all_list = Device.objects.all()
page_of_objects, page_range = pages(request, device_all_list)
context = {}
context['devices'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['count'] = Device.objects.all().count()
return render(request, 'device_list.html', context)
def group_client_list(request):
context = {}
group_client_all_list = ZxClientInfo.objects.raw(__GROUP_CLIENT_QUERY)
page_of_objects, page_range = pages(request, group_client_all_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['group_client_search_form'] = GroupClientSearchForm()
return render(request, 'group_client_list.html', context)
def my_port_error_tasks(request):
context = {}
worker = request.user.first_name
porterror_query = __QUERY_MY_FIX_TASKS
porterror_all_list = PortErrorDiff.objects.raw(porterror_query, (worker, ))
page_of_objects, page_range = pages(request, porterror_all_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
return render(request, 'my_port_error_tasks.html', context)
def natpool_list(request):
context = {}
natpool_all_list = NatPoolUsage.objects.filter(
record_time__range=getDateRange(-2)).annotate(
nat_total=(F('device1_nat_usage') +
F('device2_nat_usage'))).order_by(
F('nat_total').desc())
page_of_objects, page_range = pages(request, natpool_all_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['natpool_search_form'] = NatPoolSearchForm()
return render(request, 'natpool.html', context)
def moudle_list(request):
# 默认展示前3天数据
moudle_all_list = OpticalMoudleDiff.objects.filter(
record_time__range=getDateRange(-3))
# moudle_all_list = OpticalMoudleDiff.objects.all()
page_of_objects, page_range = pages(request, moudle_all_list)
context = {}
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['moudle_search_form'] = MoudleSearchForm()
return render(request, 'moudle_list.html', context)
def ping_result_detail(request):
context = {}
source_device = request.GET.get('source_device', '')
target_device = request.GET.get('target_device', '')
target_ip = request.GET.get('target_ip', '')
time_begin, _ = getDateRange(-2)
time_end, _ = getDateRange(-1)
ping_detail_list = LinkPingTest.objects.filter(
source_device=source_device,
target_device=target_device,
record_time__range=(time_begin, time_end)).order_by('-record_time')
page_of_objects, page_range = pages(request, ping_detail_list)
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['search_paras'] = '&source_device={}&target_device={}'.format(
source_device, target_device)
return render(request, 'ping_result_detail.html', context)
def oneway_list(request):
time_begin, time_end = getDateRange(-1)
time_range = (time_begin, time_end)
oneway_all_list = OneWayDevice.objects.raw(
__QUERY_ONEWAY_LIST + __ONEWAY_ORDER_FIELD, time_range)
page_of_objects, page_range = pages(request, oneway_all_list)
context = {}
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
# context['time_begin'] = timezone.datetime.strftime(time_begin, '%Y-%m-%d+%H:%M:%S')
# context['time_end'] = timezone.datetime.strftime(time_end, '%Y-%m-%d+%H:%M:%S')
context[
'search_paras'] = 'time_begin={}&time_end={}&device_name={}'.format(
timezone.datetime.strftime(time_begin, '%Y-%m-%d+%H:%M:%S'),
timezone.datetime.strftime(time_end, '%Y-%m-%d+%H:%M:%S'), '')
context['oneway_search_form'] = OneWaySearchForm()
context['oneway_tag_form'] = OneWayTagForm()
return render(request, 'oneway_list.html', context)
def search_moudle(request):
moudle_search_form = MoudleSearchForm(request.GET)
if moudle_search_form.is_valid():
device_name = moudle_search_form.cleaned_data['device_name']
status = moudle_search_form.cleaned_data['status']
time_begin = moudle_search_form.cleaned_data['time_begin']
time_end = moudle_search_form.cleaned_data['time_end']
time_range = (time_begin, time_end)
if device_name != '':
moudle_all_list = OpticalMoudleDiff.objects.filter(
device_name__icontains=device_name,
status__contains=status,
record_time__range=time_range)
elif status != '':
moudle_all_list = OpticalMoudleDiff.objects.filter(
status=status, record_time__range=time_range)
else:
moudle_all_list = OpticalMoudleDiff.objects.filter(
record_time__range=time_range)
else:
context = {}
context['moudle_search_form'] = moudle_search_form
return render(request, 'moudle_list.html', context)
page_of_objects, page_range = pages(request, moudle_all_list)
context = {}
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['search_device_name'] = device_name
context['search_status'] = status
context['time_begin'] = timezone.datetime.strftime(time_range[0],
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_range[1],
'%Y-%m-%d+%H:%M:%S')
context['moudle_search_form'] = moudle_search_form
return render(request, 'moudle_list.html', context)
def search_natpool(request):
context = {}
natpool_search_form = NatPoolSearchForm(request.GET)
if natpool_search_form.is_valid():
time_begin = natpool_search_form.cleaned_data['time_begin']
time_end = natpool_search_form.cleaned_data['time_end']
device_name = natpool_search_form.cleaned_data['device_name']
if device_name != '':
natpool_all_list = NatPoolUsage.objects.filter(
Q(device1__icontains=device_name)
| Q(device2__icontains=device_name),
Q(record_time__range=(time_begin, time_end))).annotate(
nat_total=(F('device1_nat_usage') +
F('device2_nat_usage'))).order_by(
F('nat_total').desc())
context['search_device_name'] = device_name
else:
natpool_all_list = NatPoolUsage.objects.filter(
record_time__range=(time_begin, time_end)).annotate(
nat_total=(F('device1_nat_usage') +
F('device2_nat_usage'))).order_by(
F('nat_total').desc())
else:
context['natpool_search_form'] = natpool_search_form
return render(request, 'natpool.html', context)
page_of_objects, page_range = pages(request, natpool_all_list)
context['records'] = page_of_objects
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['time_begin'] = timezone.datetime.strftime(time_begin,
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_end,
'%Y-%m-%d+%H:%M:%S')
context['natpool_search_form'] = natpool_search_form
return render(request, 'natpool.html', context)
def search_port_error(request):
context = {}
order_field = request.GET.get('order_field', 'crc')
porterror_search_form = PortErrorSearchForm(request.GET)
if porterror_search_form.is_valid():
time_begin = porterror_search_form.cleaned_data['time_begin']
time_end = porterror_search_form.cleaned_data['time_end']
pwr_problem = porterror_search_form.cleaned_data['pwr_problem']
otherCmd = ''
if pwr_problem:
otherCmd += 'HAVING tx_state = 0 OR rx_state = 0 '
porterror_query = __queryline(order_field, otherCmd=otherCmd)
porterror_all_list = PortErrorDiff.objects.raw(
porterror_query, (time_begin, time_end, time_begin, time_end))
else:
context['porterror_search_form'] = porterror_search_form
return render(request, 'port_error_list.html', context)
page_of_objects, page_range = pages(request, porterror_all_list)
my_tasks_cnt = 0
if request.user.is_authenticated:
my_tasks_cnt = PortErrorFixRecord.objects.filter(
worker=request.user.first_name, status=False).count()
context['records'] = page_of_objects.object_list
context['page_of_objects'] = page_of_objects
context['page_range'] = page_range
context['time_begin'] = timezone.datetime.strftime(time_begin,
'%Y-%m-%d+%H:%M:%S')
context['time_end'] = timezone.datetime.strftime(time_end,
'%Y-%m-%d+%H:%M:%S')
context['order_field'] = order_field
context['my_tasks_cnt'] = my_tasks_cnt
context['pwr_problem'] = pwr_problem
context['porterror_search_form'] = porterror_search_form
return render(request, 'port_error_list.html', context)
