3 from datetime import datetime
5 from monitor import config
6 from monitor import database
7 from monitor.common import Time
11 tickets = database.dbLoad("survey_tickets")
14 #f = open('rt_monitor_data.csv','w')
15 queue = int(sys.argv[1])
19 print >>f, "ticket_id,s1,s2,start,lastreply,replies,complete,creator"
20 for t in sorted(tickets.keys()):
22 start = datetime(2004,1,1)
23 lastreply = datetime.now()
28 if tickets[t]['queue'] != queue: continue
29 for tr in tickets[t]['transactions']:
30 # create - ticketid,creator, datecreated,
31 # correspond - creator, datecreated, content
32 # status - newvalue = resolved
33 if tr['type'] == 'Create':
34 start = tr['datecreated']
35 creator = tr['creator']
36 if complete==0: complete = 1
37 elif tr['type'] == 'Correspond':
38 if tr['creator'] not in exclude:
39 lastreply = tr['datecreated']
41 if complete == 1: complete = 2
43 elif tr['type'] == 'Status' and tr['newvalue'] == 'resolved':
45 if complete == 2: complete = 3
48 if complete in [2,3]: complete = 1
50 print >>f, "%s,%s,%s,%s,%s,%s,%s,%s" % (t, start.strftime('%Y-%m-%d'), lastreply.strftime('%Y-%m-%d'), Time.dt_to_ts(start), Time.dt_to_ts(lastreply), replies, complete, creator)
53 if __name__ == '__main__':