diff options
| author | Étienne Loks <etienne.loks@peacefrogs.net> | 2011-08-04 17:48:47 +0200 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@peacefrogs.net> | 2011-08-04 17:48:47 +0200 |
| commit | 08006c6d855cc30424e58a92c61bbae34dc1b7d5 (patch) | |
| tree | b8835e5de81cdfc0bcc56947b4d87003746f6b93 | |
| parent | aa9887b46cd33a61001b135dd2db9b8d445c746e (diff) | |
| download | Ishtar-08006c6d855cc30424e58a92c61bbae34dc1b7d5.tar.bz2 Ishtar-08006c6d855cc30424e58a92c61bbae34dc1b7d5.zip | |
Correct unknow department (closes #555)
| -rw-r--r-- | ishtar/ishtar_base/models.py | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/ishtar/ishtar_base/models.py b/ishtar/ishtar_base/models.py index e686b6ca2..a41b17215 100644 --- a/ishtar/ishtar_base/models.py +++ b/ishtar/ishtar_base/models.py @@ -400,7 +400,8 @@ class FileDashboard: .order_by('-date') self.research['by_dpt'] = FileByDepartment.objects\ - .filter(file__file_type=prog_type)\ + .filter(file__file_type=prog_type, + department__isnull=False)\ .values('department__label')\ .annotate(number=Count('file'))\ .order_by('department__label') @@ -436,7 +437,8 @@ class FileDashboard: .order_by('-date') self.rescue['by_dpt'] = FileByDepartment.objects\ - .filter(file__file_type=rescue_type)\ + .filter(file__file_type=rescue_type, + department__isnull=False)\ .values('department__label')\ .annotate(number=Count('file'))\ .order_by('department__label') @@ -476,7 +478,8 @@ class FileDashboard: .annotate(number=Sum('file__total_surface'))\ .order_by('-number','town__name')[:10] self.rescue['surface_by_dpt'] = FileByDepartment.objects\ - .filter(file__file_type=rescue_type)\ + .filter(file__file_type=rescue_type, + department__isnull=False)\ .values('department__label')\ .annotate(number=Sum('file__total_surface'))\ .order_by('department__label') |