django报表系统_django报障系统之解决工单和报表

前面实现了用户的角色管理、权限管理、故障管理。下面学习下解决故障

当有权限的用户登录后，可以看到自己创建的单子，或者自己已经接了单子和解决完成的单子

创建好对应的url

当用户处理的时候，跳转到处理的页面

处理完成后把状态 改成“已处理”，没有完成的把状态改成“处理中”

下面是报表管理

报表只有总监能看到，这里用的报表使用了hichart，插件来实现的

{% extends 'layout.html' %}

{% block content %}

{% endblock %}

$(function () {

Highcharts.setOptions({

global: {

useUTC: false

}

});

$.ajax({

url: '/report.html',

type: "POST",

data: {'csrfmiddlewaretoken': '{{ csrf_token }}'},

dataType: 'JSON',

success: function (arg) {

console.log(arg);

$('#container').highcharts({

chart: {

plotBackgroundColor: null,

plotBorderWidth: null,

plotShadow: false

},

title: {

text: '运维人员处理报障占比'

},

tooltip: {

headerFormat: '{series.name}
',

pointFormat: '{point.name}: {point.percentage:.1f}%'

},

plotOptions: {

pie: {

allowPointSelect: true,

cursor: 'pointer',

dataLabels: {

enabled: true,

format: '{point.name}: {point.percentage:.1f} %',

style: {

color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'

}

}

}

},

series: [{

type: 'pie',

name: '运维人员处理报障占比',

data: arg.pie

}]

});

Highcharts.chart('container2', {

title: {

text: '每日处理订单详细',

x: -20 //center

},

subtitle: {

text: '...',

x: -20

},

legend: {

layout: 'horizontal',

align: 'center',

verticalAlign: 'bottom',

borderWidth: 1

},

xAxis:{

labels:{

formatter:function(){

return Highcharts.dateFormat("%Y-%m-%d",this.value);

//return this.value;

}

},

minTickInterval:24

},

series: arg.zhexian

});

}

});

})

{% endblock %}

后端的数据提供是：

def report(request):

if request.permission_code == "LOOK":

if request.method == "GET":

return render(request,'report.html')

else:

from django.db.models import Count

#饼图

result = models.Order.objects.filter(status=3).values_list('processor__nickname').annotate(ct=Count('id'))

response = {}

result_dic ={}

for bin in result:

# key = bin['processor_id']

# if key in result_dic:

# result_dic[key]['data'].append([bin['processor__nickname'],bin['ct']])

# else:

# result_dic[key]={'data':[[bin['processor__nickname'],bin['ct']],]}

response['pie']=list(result)

ymd_list = models.Order.objects.filter(status=3).extra(select={'ymd':"strftime('%%s',strftime('%%Y-%%m-%%d',ptime))"}).values('processor_id','processor__nickname','ymd').annotate(ct=Count('id'))

ymd_dict = {}

for row in ymd_list:

key = row['processor_id']

if key in ymd_dict:

ymd_dict[key]['data'].append([float(row['ymd'])*1000, row['ct']])

else:

ymd_dict[key] = {'name':row['processor__nickname'],'data':[ [float(row['ymd'])*1000, row['ct']], ]}

response['zhexian']=list(ymd_dict.values())

return HttpResponse(json.dumps(response))

结果：