cel.py 11 KB

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