convert while filtering models

[ashkanjamili]

hi
how can I convert below line from Gregorian to Persian :

events = tb_order.objects.filter(time_start__year=self.year, time_start__month=self.month)

here is a full function :
def formatmonth(self, withyear=True):
events = tb_order.objects.filter(time_start__year=self.year, time_start__month=self.month)

    cal = f'<table border="0" cellpadding="0" cellspacing="0" class="calendar">\n'
    cal += f'{self.formatmonthname(self.year, self.month, withyear=withyear)}\n'
    cal += f'{self.formatweekheader()}\n'
    for week in self.monthdays2calendar(self.year, self.month):
        cal += f'{self.formatweek(week, events)}\n'
    return cal

[hramezani]

Hi,
Could you please provide more information here?
What do you exactly want to do?
What is the problem? What do you want to convert from Gregorian to Persian?

[ashkanjamili]

hi , I created a html calendar (shams type) and render it to the template . and then I have to collect and filter stored data in order to format months . however data are stored in Gregorian type. I tried below solution , if you any other idea please share it with me .
Utils.py :

from Project.models import tb_order
from maindata.models import Machine
from django.db.models import Q
from datetime import datetime, timedelta
from calendar import HTMLCalendar
import jdatetime


class Calendar(HTMLCalendar):
    def __init__(self, year=None, month=None):
        self.year = year
        self.month = month
        super(Calendar, self).__init__()


    # formats a day as a td
    # filter events by day
    def formatday(self, day, events):
        events_per_day = events.filter(time_start__day=day)
        d = ''
        for event in events_per_day:
            d += f'<li> {event.title} </li>'

        if day != 0:
            return f"<td><span class='date'>{day}</span><ul> {d} </ul></td>"
        return '<td></td>'

    # formats a week as a tr
    def formatweek(self, theweek, events):
        week = ''
        for d, weekday in theweek:
            week += self.formatday(d, events)
        return f'<tr> {week} </tr>'

    # formats a month as a table
    # filter events by year and month
    def formatmonth(self, withyear=True):

       
        events = tb_order.objects.filter(time_start__year=self.year, time_start__month=self.month)




        cal = f'<table border="0" cellpadding="0" cellspacing="0" class="calendar">\n'
        cal += f'{self.formatmonthname(self.year, self.month, withyear=withyear)}\n'
        cal += f'{self.formatweekheader()}\n'
        for week in self.monthdays2calendar(self.year, self.month):
            cal += f'{self.formatweek(week, events)}\n'
        return cal

in views.py :

class CalendarView(generic.ListView):
    model = tb_order
    template_name = 'pline/testcalender.html'

    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)

        # use today's date for the calendar
        d = date2jalali(get_date(self.request.GET.get('day', None)))
        # print(d.year, d.month)
        # d = get_date(self.request.GET.get('day', None))
        # Instantiate our calendar class with today's year and date
        cal = Calendar(d.year,d.month)
        # Call the formatmonth method, which returns our calendar as a table
        html_cal = cal.formatmonth(withyear=True)
        context['calendar'] = mark_safe(html_cal)
        context['prev_month'] = prev_month(d)
        context['next_month'] = next_month(d)
        return context

def get_date(req_day):
    if req_day:
        year, month = (int(x) for x in req_day.split('-'))
        return date(year, month, day=1)
    return datetime.today()

def prev_month(d):
    first = d.replace(day=1)
    prev_month = first - timedelta(days=1)
    month = 'month=' + str(prev_month.year) + '-' + str(prev_month.month)
    return month

def next_month(d):
    days_in_month = calendar.monthrange(d.year, d.month)[1]
    last = d.replace(day=days_in_month)
    next_month = last + timedelta(days=1)
    month = 'month=' + str(next_month.year) + '-' + str(next_month.month)
    return month

[hramezani]

I haven't still understood the problem. You can convert your datetime to Jalali by jdatetime.datetime.fromgregorian(datetime=datetime.datetime)