Python・Djangoで家計簿アプリ開発⑪【口座詳細ページ作成（続き）】

#一定間隔の各口座残高
class AccountHis(models.Model):
    date = models.DateField(default=timezone.now)
    name = models.ForeignKey(Account, on_delete=models.CASCADE)
    balance = models.IntegerField()

    def __str__(self):
        return str(self.date) +'_' + self.name.name

from django.apps import AppConfig

class MoneyDiaryConfig(AppConfig):
    default_auto_field = 'django.db.models.BigAutoField'
    name = 'money_diary'
    
    #以下追加
    def ready(self):
        """起動時に呼び出される"""
        from .update import start
        start()

from apscheduler.schedulers.background import BackgroundScheduler
from .models import Account, AccountBalance, AccountHis

#定期実行の処理
def update():
    account = Account.objects.values_list('name', flat=True)

    for name in account:
        account = AccountBalance.objects.all().filter(name__name=name).latest('date')

        AccountHis.objects.create(
            name = account.name,
            balance = account.balance
        )

    print('更新')

#定期実行のインターバル設定
def start():
    scheduler = BackgroundScheduler()
    scheduler.add_job(update, 'cron', hour=0) 
    scheduler.start()

class Account_DetailView(View):
    def get(self, request, num, year=int(today[0]), month=int(today[1])):
        # 選択口座のデータの取得
        account = AccountBalance.objects.get(id=num)
        # 選択講座の収支データの取得
        income = Income.objects.all().filter(account__name=account.name, date__year=year, date__month=month).order_by()
        expense = Expense.objects.all().filter(account__name=account.name, date__year=year, date__month=month).order_by()

        #グラフのデータ取得
        account_his = AccountHis.objects.all().filter(name=account.name)

        balance = []
        date = []

        #グラフ用データをリストに格納
        for n in account_his:
            date.append(n.date.strftime('%y/%m/%d'))
            balance.append(n.balance)

        # 月次切り替えの際の条件
        if month == 12:
            last_year = year
            last_month = 11
            next_year = year + 1
            next_month = 1
        elif month == 1:
            last_year = year - 1
            last_month = 12
            next_year = year
            next_month = 2
        else:
            last_year = year
            last_month = month - 1
            next_year = year
            next_month = month + 1

        params = {
            'account': account,
            'income': income,
            'expense': expense,
            'date': date,
            'balance': balance,
            'year': year,
            'month': month,
            'last_year': last_year,
            'last_month': last_month,
            'next_year': next_year,
            'next_month': next_month,
        }

        return render(request, 'money_diary/account_detail.html', params)

def start():
    scheduler = BackgroundScheduler()
    scheduler.add_job(update, 'interval', seconds=30) 
    scheduler.start()

options: {
      //凡例非表示
      legend: {
        display: false
      },
      scales: {
          //X軸(以下追加)
          xAxes: [{
              ticks: {
                autoSkip: true,
                maxTicksLimit: 10,
              }
          }],
          yAxes: [{
              ticks: {
                  beginAtZero:true
              },
          }]
      }
      }
  });