Complete the general panel for dashboard (closes #520)

2 files changed, 39 insertions, 3 deletions

diff --git a/ishtar/ishtar_base/models.py b/ishtar/ishtar_base/models.py
index cbf362b83..89cb8e605 100644
--- a/ishtar/ishtar_base/models.py
+++ b/ishtar/ishtar_base/models.py
@@ -25,8 +25,9 @@ import datetime
 from django.core.exceptions import ObjectDoesNotExist, ValidationError
 from django.core.validators import validate_slug
 from django.utils.translation import ugettext_lazy as _, ugettext
-from django.db.utils import DatabaseError
 from django.utils.safestring import SafeUnicode, mark_safe
+from django.core.urlresolvers import reverse, NoReverseMatch
+from django.db.utils import DatabaseError
 from django.db.models import Q, Max, Count
 from django.db.models.signals import m2m_changed
 
@@ -339,6 +340,13 @@ class BaseHistorizedItem(models.Model):
                 values[k] = getattr(self, k)
         return values
 
+    def get_show_url(self):
+        try:
+            return reverse('show-'+self.__class__.__name__.lower(),
+                                            args=[self.pk, ''])
+        except NoReverseMatch:
+            return
+
 class LightHistorizedItem(BaseHistorizedItem):
     history_date = models.DateTimeField(default=datetime.datetime.now)
     class Meta:
@@ -348,10 +356,38 @@ class LightHistorizedItem(BaseHistorizedItem):
         super(LightHistorizedItem, self).save(*args, **kwargs)
         return True
 
+class UserDashboard:
+    def __init__(self):
+        types = IshtarUser.objects.values('person__person_type',
+                                          'person__person_type__label')
+        self.types = types.annotate(number=Count('pk')).order_by(
+                                                       'person__person_type')
+
 class Dashboard:
     def __init__(self, model):
         self.model = model
         self.total_number = model.get_total_number()
+        history_model = self.model.history.model
+        # last edited - created
+        self.recents, self.lasts = [], []
+        for last_lst, modif_type in ((self.lasts, '+'), (self.recents, '~')):
+            last_ids = history_model.objects.values('id').annotate(hd=\
+                                                        Max('history_date'))
+            last_ids = last_ids.filter(history_type=modif_type)
+            if self.model == Item:
+                last_ids = last_ids.filter(downstream_treatment_id__isnull=True)
+                if modif_type == '+':
+                   last_ids = last_ids.filter(upstream_treatment_id__isnull=True)
+            last_ids = last_ids.order_by('-hd').distinct().all()[:5]
+            for idx in last_ids:
+                try:
+                    obj = self.model.objects.get(pk=idx['id'])
+                except:
+                    # deleted object are always referenced in history
+                    continue
+                obj.history_date = idx['hd']
+                print unicode(obj), obj.pk
+                last_lst.append(obj)
         # years
         self.years = model.get_years()
         self.years.sort()
diff --git a/ishtar/ishtar_base/views.py b/ishtar/ishtar_base/views.py
index ff55169c5..6527dec3a 100644
--- a/ishtar/ishtar_base/views.py
+++ b/ishtar/ishtar_base/views.py
@@ -243,7 +243,6 @@ def get_item(model, func_name, default_name, extra_request_keys=[],
         table_cols = full and [field.name for field in model._meta.fields
                                if field.name not in PRIVATE_FIELDS] \
                      or model.TABLE_COLS
-        print table_cols
         for item in items:
             data = [item.pk]
             for k in table_cols:
@@ -658,7 +657,8 @@ def dashboard_main(request, dct, obj_id=None, *args, **kwargs):
         (_(u"Operations"), models.Dashboard(models.Operation)),
         (_(u"Context records"), models.Dashboard(models.ContextRecord)),
         (_(u"Archaeological items"), models.Dashboard(models.Item)),
-        ]}
+        ],
+           'ishtar_users':models.UserDashboard()}
     return render_to_response('dashboard_main.html', dct,
                               context_instance=RequestContext(request))