20230815 Django日期區間計算練習

accounts = Account.objects.filter(date__month=8).filter(io='INPUT') #但這邊有個問題，不管哪年八月都會被查到吧？

data = {}

        now = datetime.datetime.now()

        # 收集今年月份

        today_year = now.year

        today_year_months = range(1,now.month+1)

        for today_year_month in today_year_months:

            month_key = '%s_%s' % (today_year, today_year_month)

            data[month_key]=[] # 建立每個月份的 list

            accounts = Account.objects.filter(date__year=today_year).filter(date__month=today_year_month).filter(io='INPUT')

            for node in accounts:

                data[month_key].append(node.price)

            # 加總

            data[month_key] = sum(data[month_key])

        # 如果 data 沒有 12 個 key len (data.keys ())；會做這樣的判斷 因為想減少 DB 連線次數 雖然只有年底會節省到 -.-

        if len(data.keys()) < 12:

            # 繼續收集去年月份

            last_year =  int(now.year) -1

            last_year_months = range(now.month+1, 13)

            for last_year_month in last_year_months:

                month_key = '%s_%s' % (last_year, last_year_month)

                data[month_key]=[] # 建立每個月份的 list

                accounts = Account.objects.filter(date__year=last_year).filter(date__month=last_year_month).filter(io='INPUT')

                for node in accounts:

                    data[month_key].append(node.price)

                # 加總

                data[month_key] = sum(data[month_key])