diff options
| -rw-r--r-- | program/management/commands/export_showlog.py | 44 | ||||
| -rw-r--r-- | program/views.py | 12 |
2 files changed, 50 insertions, 6 deletions
diff --git a/program/management/commands/export_showlog.py b/program/management/commands/export_showlog.py new file mode 100644 index 0000000..da78cd2 --- /dev/null +++ b/program/management/commands/export_showlog.py @@ -0,0 +1,44 @@ +# -*- coding: utf-8 -*- + +import codecs +import sys +from datetime import date, datetime, time, timedelta +from django.core.management.base import BaseCommand, CommandError +from program.models import TimeSlot + + +class Command(BaseCommand): + help = 'export playlog for one year' + args = '<year>' + + def handle(self, *args, **options): + UTF8Writer = codecs.getwriter('utf8') + sys.stdout = UTF8Writer(sys.stdout) + + if len(args) == 1: + try: + year = int(args[0]) + except ValueError: + raise CommandError("'%s' is not a valid year" % args[0]) + else: + raise CommandError('you must provide the year') + + print "# Radio Helsinki Sendungslog %d" % year + + start = datetime.strptime('%d__01__01__00__00' % (year), '%Y__%m__%d__%H__%M') + end = datetime.strptime('%d__01__01__00__00' % (year+1), '%Y__%m__%d__%H__%M') + + currentDate = None + for ts in TimeSlot.objects.filter(end__gt=start, start__lt=end).select_related('programslot').select_related('show'): + if currentDate == None or currentDate < ts.start.date(): + if currentDate: + print "\n" + currentDate = ts.start.date() + print currentDate.strftime("## %a %d.%m.%Y:\n") + + title = ts.show.name + if ts.programslot.is_repetition: + title += " (WH)" + + print " * **%s - %s**: %s" % (ts.start.strftime("%H:%M:%S"), ts.end.strftime("%H:%M:%S"), title) + diff --git a/program/views.py b/program/views.py index 9886d08..a9c83e4 100644 --- a/program/views.py +++ b/program/views.py @@ -193,14 +193,14 @@ def json_day_schedule(request, year=None, month=None, day=None): else: today = datetime.strptime('%s__%s__%s__00__00' % (year, month, day), '%Y__%m__%d__%H__%M') - timeslots = TimeSlot.objects.get_24h_timeslots(today).select_related('programslot') + timeslots = TimeSlot.objects.get_24h_timeslots(today).select_related('programslot').select_related('show') schedule = [] for ts in timeslots: entry = { 'start': ts.start.strftime('%Y-%m-%d_%H:%M:%S'), 'end': ts.end.strftime('%Y-%m-%d_%H:%M:%S'), - 'title': ts.programslot.show.name, - 'id': ts.programslot.show.id, + 'title': ts.show.name, + 'id': ts.show.id, 'automation-id': -1 } @@ -220,10 +220,10 @@ def json_timeslots_specials(request): if show['type'] == 's': specials[show['id']] = show - for ts in TimeSlot.objects.filter(end__gt=datetime.now).filter(programslot__automation_id__in=specials.iterkeys()): + for ts in TimeSlot.objects.filter(end__gt=datetime.now, programslot__automation_id__in=specials.iterkeys()).select_related('show'): automation_id = ts.programslot.automation_id - specials[automation_id]['pv_id'] = int(ts.programslot.show.id) - specials[automation_id]['pv_name'] = ts.programslot.show.name + specials[automation_id]['pv_id'] = int(ts.show.id) + specials[automation_id]['pv_name'] = ts.show.name specials[automation_id]['pv_start'] = ts.start.strftime('%Y-%m-%d_%H:%M:%S') specials[automation_id]['pv_end'] = ts.end.strftime('%Y-%m-%d_%H:%M:%S') |