快捷導(dǎo)航

django項(xiàng)目用higcharts統(tǒng)計(jì)最近七天文章點(diǎn)擊量

更新時(shí)間：2019年08月17日 09:37:30 作者：記住我忘記我

這篇文章主要介紹了django項(xiàng)目用higcharts統(tǒng)計(jì)最近七天文章點(diǎn)擊量,本文給大家介紹的非常詳細(xì)，具有一定的參考借鑒價(jià)值，需要的朋友可以參考下

下載higcharts插件放在static文件夾下

前端引入

<script src="/static/highcharts/highcharts.js"></script>
<script src="/static/highcharts/modules/exporting.js"></script>
<script src="/static/highcharts/modules/oldie.js"></script>
<script src="/static/highcharts/highcharts-zh_CN.js"></script>

定義在頁面中的位置

<div id="container" style="min-width:400px;height:400px"></div>

前端js

<script>
  var chart = Highcharts.chart('container', {
 chart: {
  type: 'line'
 },
 title: {
  text: '日點(diǎn)擊量和點(diǎn)贊量統(tǒng)計(jì)'
 },
 subtitle: {
  text: '數(shù)據(jù)來源: terroristhouse.com'
 },
 xAxis: {
  categories: {{ list_week_day|safe }}
 },
 yAxis: {
  title: {
   text: '數(shù)量 (次)'
  }
 },
 plotOptions: {
  line: {
   dataLabels: {
    // 開啟數(shù)據(jù)標(biāo)簽
    enabled: true
   },
   // 關(guān)閉鼠標(biāo)跟蹤，對(duì)應(yīng)的提示框、點(diǎn)擊事件會(huì)失效
   enableMouseTracking: false
  }
 },
 series: [{
  name: '點(diǎn)擊量',
  data:{{ clicknum_list|safe }}
 }, {
  name: '點(diǎn)贊量',
  data: {{ praise_num_list|safe }}
 }]
});
  </script>

路由

# 點(diǎn)擊量統(tǒng)計(jì)
re_path('article/click/', article.click,name='article/click/'),

后臺(tái)方法

from blog.utils import function

# 點(diǎn)擊量
def click(request):
 recent_seven_days = function.recent_seven_days()
 list_week_day = recent_seven_days[::-1] # 進(jìn)行倒序
 clicknum_list = []
 praise_num_list = []
 # print(list_week_day)
 for v in list_week_day:
  click_num_obj = Praise.objects.filter(click_addtime=v,click_sort=1).aggregate(clicknum=Count('click_sort'))
  praise_num_obj = Praise.objects.filter(click_addtime=v,click_sort=0).aggregate(praise_num=Count('click_sort'))
  # print(click_num_obj['clicknum'],praise_num_obj['praise_num'])
  clicknum = int(click_num_obj['clicknum']) if (click_num_obj['clicknum'] is not None) else 0
  praise_num = int(praise_num_obj['praise_num']) if (praise_num_obj['praise_num'] is not None) else 0

  clicknum_list.append(clicknum)

  praise_num_list.append(praise_num)
 # print(clicknum_list)

 # data=[{
 #  'name': '點(diǎn)擊量',
 #  'data': clicknum_list
 # }, {
 #  'name': '點(diǎn)贊量',
 #  'data': praise_num_list
 # }]

 # num= [ '20190624', '20190625', '20190626', '20190627', '20190628', '20190629', '20190630']
 return render(request,'article/click.html',locals())

應(yīng)用目錄下創(chuàng)建untils文件夾，并在其下創(chuàng)建function.py文件，用來獲取最近七天日期

# 七天日期
def recent_seven_days():# 通過for 循環(huán)得到天數(shù)，如果想得到兩周的時(shí)間，只需要把8改成15就可以了。
 import datetime
 d = datetime.datetime.now()#2019-6-28 9:25:43.843164
 lists = []
 for i in range(1,8):#i:1-7
  oneday = datetime.timedelta(days=i) #1 day, 0:00:00  2 days, 0:00:00 ... 7 days, 0:00:00
  day = d - oneday#2019-06-27 11:32:10.186535 2019-06-26 11:32:10.186535 ... 2019-06-21 11:32:10.186535
  date_to = datetime.datetime(day.year, day.month, day.day)#2019-06-27 00:00:00 2019-06-26 00:00:00 ... 2019-06-21 00:00:00
  lists.append(str(date_to)[0:10])#2019-06-27 2019-06-26 ... 2019-06-21
 return lists

頁面效果