I need PHP script which which extract the following details from my Asterisk CDR for any given DID which is being stored in `userfield`.
> Date-Time
> DID (I am recording this is `userfield`)
> CLID
> t1 (time when call was received)
> t2 (time when call was answered by agent)
> t3 (time when call was hung-up)
> t4 (Hold time: t2-t1)
> t5 (Talk time: t3-t2)
Fancy HTML etc is not required. Just simple tabulation will do.
Call Flow:
==========
[caller] -> [Trixbox IVR] -> [Trixbox Call Queue] -> [Trixbox Human Operator]
I can send a sample of about 100-200 records from my CDR.