cel.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338
  1. #!/usr/bin/env python3
  2. import json
  3. import re
  4. from datetime import datetime
  5. from datetime import timedelta as td
  6. fieldsFilter = ('id', 'linkedid', 'appdata', 'lastdata')
  7. class CdrChannel:
  8. def __init__(self, chanData):
  9. self._str = chanData
  10. try:
  11. (self.tech,
  12. self.peer,
  13. self.context,
  14. self.id,
  15. self.leg) = re.match(r'(\w+)/(\w+)(?:@([\w-]+))?-([0-9a-f]{8})(?:;([0-9]+))?', chanData).groups()
  16. except:
  17. pass
  18. def __repr__(self):
  19. return self._str
  20. class CdrEvent:
  21. def __init__(self, eventData):
  22. eventData = dict(eventData)
  23. for key, value in eventData.items():
  24. if ((key not in fieldsFilter) and (value is not None) and (str(value) != '')):
  25. if key == 'extra':
  26. setattr(self, key, json.loads(value))
  27. elif key in ('channame','channel','dstchannel'):
  28. setattr(self, key, CdrChannel(value))
  29. else:
  30. setattr(self, key, value)
  31. def __getattr__(self, attr):
  32. return None
  33. class CdrEvents:
  34. def __init__(self):
  35. self._events = []
  36. self._channels = {}
  37. self._dstchannels = {}
  38. self.start = 0
  39. self._waitingchannel = None
  40. def add(self, event):
  41. if not isinstance(event, CdrEvent):
  42. event = CdrEvent(event)
  43. if not self.start:
  44. self.start = event.calldate
  45. if (event.lastapp == 'Return' and event.billsec==0):
  46. return
  47. if (event.lastapp == 'Return'):
  48. event.lastapp='Dial'
  49. event.duration=event.billsec
  50. event.cnum = event.src
  51. if (event.channel.id not in self._channels):
  52. self._channels[event.channel.id] = event
  53. if (event.dstchannel.id not in self._dstchannels):
  54. self._dstchannels[event.dstchannel.id] = event.dst
  55. if (self._waitingchannel is not None) and (self._waitingchannel.id == event.channel.id): # if dial event after queue event
  56. for e in self._events:
  57. if (e.lastapp == 'Queue') and (e.dstchannel.id == event.channel.id):
  58. e.duration = (event.calldate-e.calldate).total_seconds() + event.duration
  59. e.billsec = event.billsec
  60. self._waitingchannel = None
  61. if (event.lastapp == 'Queue'):
  62. event.billsec = 0
  63. queueevent = event
  64. for e in self._events:
  65. if (e.lastapp == 'Queue') and (e.uniqueid == event.uniqueid):#find first queue event
  66. queueevent = e
  67. if (event.disposition == 'ANSWERED'): #if it answered - fill duration and waitng based on answered dial event
  68. queueevent.disposition = 'ANSWERED'
  69. queueevent.dstchannel = event.dstchannel
  70. if (event.dstchannel.id in self._channels): # if dial event before queue event
  71. dialevent = self._channels[event.dstchannel.id]
  72. queueevent.duration = (dialevent.calldate-queueevent.calldate).total_seconds() + dialevent.duration
  73. queueevent.billsec = dialevent.billsec
  74. else:
  75. self._waitingchannel = event.dstchannel # wait for dial event
  76. else:
  77. if queueevent.disposition != 'ANSWERED': #count total queue duration
  78. queueevent.duration = (event.calldate-queueevent.calldate).total_seconds() + event.duration
  79. if (event != queueevent):
  80. return; # add only forst queue event
  81. if (event.lastapp == 'Dial' and event.dstchannel.id in self._dstchannels):
  82. event.dst = self._dstchannels[event.dstchannel.id] #get dst from fisrt event with rthis channel. for transfer
  83. if (event.lastapp == 'Dial' and event.dstchannel.id in self._channels):
  84. event.dst = self._channels[event.dstchannel.id].dst #for transfer to queue
  85. self.end = event.calldate + td(seconds=event.duration)
  86. self._events.append(event)
  87. @property
  88. def all(self):
  89. return self._events
  90. @property
  91. def first(self):
  92. return self._events[0] if len(self._events) > 0 else None
  93. @property
  94. def second(self):
  95. return self._events[1] if len(self._events) > 1 else None
  96. @property
  97. def last(self):
  98. return self._events[-1] if len(self._events) > 0 else None
  99. def filter(self, key, value, func='__eq__'):
  100. result = CdrEvents()
  101. for event in self._events:
  102. if getattr(str(getattr(event, key)), func)(value):
  103. result.add(event)
  104. return result
  105. def has(self, value, key='disposition'):
  106. for event in self._events:
  107. if getattr(event, key) == value:
  108. return True
  109. return False
  110. def __len__(self):
  111. return len(self._events)
  112. def simple(self):
  113. res = []
  114. for event in self._events:
  115. simple_event = {'start': event.calldate,
  116. 'answered': event.disposition=='ANSWERED',
  117. 'duration': event.billsec,
  118. 'waiting': event.duration - event.billsec,
  119. 'application': event.lastapp,
  120. 'caller': event.cnum,
  121. 'dst': event.dst,
  122. 'uniqueid': event.uniqueid,
  123. 'file': event.recordingfile}
  124. res.append(simple_event)
  125. return res
  126. class CdrUserEvents(CdrEvents):
  127. def __init__(self, user):
  128. self._user = user
  129. self._events = []
  130. self.start = 0
  131. self.answered = 0
  132. self.end = 0
  133. self.recordingfile = ''
  134. @property
  135. def start(self):
  136. return self.start
  137. @property
  138. def answered(self):
  139. return self.answered
  140. @property
  141. def end(self):
  142. return self.end
  143. @property
  144. def recordingfile(self):
  145. return self.recordingfile
  146. def add(self, event):
  147. if not isinstance(event, CdrEvent):
  148. event = CdrEvent(event)
  149. if self._user in (event.src, event.dst, event.cnum):
  150. if (self.answer ==0) and (event.disposition == 'ANSWERED'):
  151. self.answer = event.calldate + event.duration - event.billsec
  152. self.recordingfile = event.recordingfile
  153. if (self.recordingfile == ''):
  154. self.recordingfile = event.recordingfile
  155. if len(self._events) == 0:
  156. self.start = event.calldate
  157. self.end = event.calldate + td(seconds=event.duration)
  158. self._events.append(event)
  159. else:
  160. if (event.calldate + td(seconds=event.duration)) > self.end:
  161. self.end = event.calldate + td(seconds=event.duration)
  162. if event.calldate < self.start:
  163. self.start = event.calldate
  164. lo = 0
  165. hi = len(self._events)
  166. while lo < hi:
  167. mid = (lo+hi)//2
  168. if event.calldate <= self._events[mid].calldate:
  169. hi = mid
  170. else:
  171. lo = mid+1
  172. self._events.insert(lo, event)
  173. def simple(self):
  174. res = []
  175. for event in self._events:
  176. simple_event = {'start': event.calldate,
  177. 'answered': event.disposition=='ANSWERED',
  178. 'duration': event.duration,
  179. #'waiting': event.waiting,
  180. 'application': event.lastapp,
  181. 'dst': event.dst,
  182. 'uniqueid': event.uniqueid,
  183. 'file': event.recordingfile}
  184. res.append(simple_event)
  185. return res
  186. class CelEvents(CdrEvents):
  187. def has(self, value, key='eventtype'):
  188. return super().has(value, key)
  189. class CdrCall:
  190. def __init__(self, event=None):
  191. self.events = CdrEvents()
  192. if event is not None:
  193. self.events.add(event)
  194. self.linkedid = event['linkedid']
  195. else:
  196. self.linkedid = None
  197. @property
  198. def start(self):
  199. return self.events.first.calldate
  200. @property
  201. def disposition(self):
  202. return self.events.first.disposition
  203. @property
  204. def file(self):
  205. return self.events.first.recordingfile
  206. @property
  207. def src(self):
  208. return self.events.first.cnum
  209. @property
  210. def direction(self):
  211. if self.events.first.dcontext == 'from-internal':
  212. if self.events.first.outbound_cnum is not None:
  213. return 'outbound'
  214. else:
  215. return 'local'
  216. else:
  217. return 'inbound'
  218. @property
  219. def dst(self):
  220. # placeholder
  221. # TODO: determine last dst based on disposition
  222. if self.direction == 'outbound':
  223. return self.events.first.dst
  224. elif self.direction == 'local':
  225. return self.events.first.dst
  226. else:
  227. if self.events.first.dstchannel is not None:
  228. return self.events.first.dstchannel.peer
  229. else:
  230. return self.events.first.dst
  231. @property
  232. def did(self):
  233. if self.direction == 'inbound':
  234. return self.events.first.did
  235. else:
  236. return None
  237. @property
  238. def duration(self):
  239. if not self.isAnswered:
  240. return 0
  241. else:
  242. if len(self.events) > 1:
  243. return self.events.second.billsec
  244. else:
  245. return self.events.first.billsec
  246. @property
  247. def waiting(self):
  248. if not self.isAnswered:
  249. return self.events.first.duration
  250. else:
  251. # TODO: exclude time on ivr
  252. return self.events.first.duration - self.duration
  253. @property
  254. def isAnswered(self):
  255. return self.disposition == 'ANSWERED';
  256. class CdrUserCall(CdrCall):
  257. def __init__(self, user, event=None):
  258. self.user = user
  259. self.events = CdrUserEvents(user)
  260. if event is not None:
  261. self.events.add(event)
  262. self.linkedid = event['linkedid']
  263. else:
  264. self.linkedid = None
  265. @property
  266. def file(self):
  267. return self.events.recordingfile
  268. @property
  269. def src(self):
  270. return self.events.first.cnum
  271. @property
  272. def direction(self):
  273. if self.user in (self.events.first.src, self.events.first.cnum):
  274. return 'outbound'
  275. else:
  276. return 'inbound'
  277. @property
  278. def dst(self):
  279. return self.events.first.dst
  280. @property
  281. def did(self):
  282. if self.direction == 'inbound':
  283. return self.events.first.did
  284. else:
  285. return None
  286. @property
  287. def duration(self):
  288. if not self.events.answer == 0:
  289. return 0
  290. else:
  291. return self.events.end - self.events.answer
  292. @property
  293. def waiting(self):
  294. if not self.event.answer == 0:
  295. return self.events.end - self.events.start
  296. else:
  297. # TODO: exclude time on ivr
  298. return self.events.answer - self.events.start
  299. @property
  300. def isAnswered(self):
  301. return self.events.answer != 0;
  302. @property
  303. def simple(self):
  304. return {'start': self.start,
  305. 'direction': self.direction,
  306. 'answered': self.isAnswered,
  307. 'duration': self.duration,
  308. 'waiting': self.waiting,
  309. 'src': self.src,
  310. 'dst': self.dst,
  311. 'did': self.did,
  312. 'linkedid': self.linkedid,
  313. 'file': self.file,
  314. 'transfer_from': self.events.first.transfer_from
  315. }#'events': self.events.simple()}
  316. class CelCall:
  317. def __init__(self, event=None):
  318. self.events = CelEvents()
  319. if event is not None:
  320. self.events.add(event)
  321. self.linkedid = event['linkedid']
  322. else:
  323. self.linkedid = None
  324. @property
  325. def start(self):
  326. return self.events.first.eventtime