XXX，DJANGO ORM里确实有很深的水，需要慢慢理解。。
比如：
获取指定时间段的数据：
app.deployversion_set.filter(add_date__range=(date_start, date_end))
按月获取记录数：
app_month = DeployVersion.objects.extra(select={'month': connections[DeployVersion.objects.db].ops.date_trunc_sql('month', 'add_date')}).values('month').annotate(dcount=Count('add_date'))
class DeployVersionSAAppView(TemplateView): template_name = 'version/sa_deployversion_app.html' def get_context_data(self, **kwargs): context = super(DeployVersionSAAppView, self).get_context_data(**kwargs) app_dict = {} app_month_dict = {} appcount = App.objects.annotate(num_app=Count('deployversion')) for app in appcount: if self.request.GET.has_key('date_start') and self.request.GET.has_key('date_end') : date_start = self.request.GET['date_start'] date_end = self.request.GET['date_end'] context['days'] = date_start+'至'+date_end app_qryset = app.deployversion_set.filter(add_date__range=(date_start, date_end)) else: context['days'] = '所有时间' app_qryset = app.deployversion_set.all() if app_qryset.count(): app_key = str(app.name) app_dict[app_key] = app_qryset.count() app_month = DeployVersion.objects.extra(select={'month': connections[DeployVersion.objects.db].ops.date_trunc_sql('month', 'add_date')}).values('month').annotate(dcount=Count('add_date')) for app_count in app_month: app_count_item = str(app_count['month'])[:7] if app_month_dict.has_key(app_count_item): app_month_dict[app_count_item] += 1 else: app_month_dict[app_count_item] = 1 app_month_list = sorted(app_month_dict.items(), key=lambda d: d[0], reverse=False) month_categories = [] month_data = [] for item_temp in app_month_list: month_categories.append(item_temp[0]) month_data.append(item_temp[1]) categories = app_dict.keys() data = app_dict.values() context['now'] = timezone.now() context['current_page'] = "deployversion-list-sa-app" context['form'] = SAAppForm context['categories'] = categories context['data'] = data context['month_categories'] = month_categories context['month_data'] = month_data return context
哈哈，本周个人超计划搞定。
