VoIP Mailing List Archives

[cervajs2 at gmail.com]

hi,

i'm trying replace CDR with CEL

reasons:

- minimize Stasis listeners (CDR)

- CEL, CDR produces "similar" data

- own logic of CDR meaning like "calldate,src,dst,direction,.." dst is
always first connected point in PBX - real user or IVR/queue etc.,
numbers are only attributes of object "user"


do you have any tips/logic/comments for this goal?


my custom cdr table

CREATE TABLE `cdr` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT 'user id',
`tenant_id` int(11) NOT NULL COMMENT 'tenant id',
`calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL DEFAULT '',
`src` varchar(80) NOT NULL DEFAULT '',
`dst` varchar(80) NOT NULL DEFAULT '',
`duration` int(11) NOT NULL DEFAULT '0',
`billsec` int(11) NOT NULL DEFAULT '0',
`disposition` varchar(45) NOT NULL DEFAULT '' COMMENT 'asterisk hangup cause',
`way` enum('loc','in','out') NOT NULL DEFAULT 'loc' COMMENT 'call direction (loc - local, in - incoming, out - outgoing)',
`trunk` varchar(80) NOT NULL COMMENT 'used SIP trunk',
`hangupcause` varchar(10) NOT NULL COMMENT 'hangup cause',
`hangupside` varchar(10) NOT NULL COMMENT 'hangup on which side',
`uniqueid` varchar(64) NOT NULL DEFAULT '',
`linkedid` varchar(64) NOT NULL,
`data` json NOT NULL COMMENT 'metadata',
`stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'creation date',
PRIMARY KEY (`id`),
KEY `dst` (`dst`),
KEY `uniqueid` (`uniqueid`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CEL pairing for simple call scenario

user_id = own variable (from cel userfield or CELGenUserEvent app)
tenant_id = own variable (from cel accountcode or CELGenUserEvent app)
calldate = eventtime
src = cid_num
dst = exten
duration = eventtime(event HANGUP) - eventtime(eventtype BRIDGE_ENTER) (no eventtype PICKUP,FORWARD,*TRANSFER) (or howto identify event RINGING?)
billsec = eventtime(event HANGUP) - eventtime(eventtype ANSWER) (no eventtype PICKUP,FORWARD,*TRANSFER)
way = own variable (CELGenUserEvent app)
disposition = extra: {"hangupcause":16,"hangupsource":"SIP/siptrunk-00000a80","dialstatus":"ANSWER"}
trunk = own variable (CELGenUserEvent app)
hangupcause = extra: {"hangupcause":16,"hangupsource":"SIP/siptrunk-00000a80","dialstatus":"ANSWER"}
hangupside = ???




--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users