statistics/correspondence.py

   1
   2
   3 def dt_mod_range(dt, range=(60*60*24*7)):
   4         t_stamp = time.mktime(dt.timetuple())
   5         t_stamp -= (t_stamp % range)
   6         dt_ret = datetime.datetime.fromtimestamp(t_stamp)
   7         return dt_ret
   8
   9 SUPPORT =3
  10 MONITOR =22
  11
  12 weekly_bin = {}
  13 c = 0
  14 for ticket in tickets.keys():
  15         if tickets[ticket]['queue'] != MONITOR: continue
  16         for t in tickets[ticket]['transactions']:
  17                 if t['type'] == 'Correspond':
  18                         #print t['datecreated'], t['field'], t['oldvalue'], t['type'], t['newvalue'], t['subject']
  19                         k = dt_mod_range(t['datecreated'])
  20                         s_key = k.strftime("%Y-%m-%d")
  21                         if s_key not in weekly_bin: weekly_bin[s_key] = 0
  22
  23                         weekly_bin[s_key] += 1
  24
  25                 #       c += 1
  26                 #if c > 100 : break;
  27         #break;
  28
  29 dates = weekly_bin.keys()
  30 dates.sort()
  31 for t in dates:
  32         print t, ",", weekly_bin[t]
  33