Link call with their audio file records

Registered by Alex

if phone calls are recorded (with either FreePBX or other Voip server) would be great to link call_id with this phonecall record.

In case of FreePBX - with "uniqueid" and 'recordingfile' from cdr table (in asteriskcdrdb DB by default) on call end.
Could be done both for queXS VOIP ON and OFF modes, for automatic (set with FreePBX) and manual (triggered from queXS operator panel) records.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
Alex
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
Proposed for main
Implementation:
Not started
Milestone target:
milestone icon 1.15.0

Whiteboard

(?)

Work Items

Work items:
define settings for asteriskcdrdb DB table cdr connection (if different from "asterisk" DB) : TODO
define setting for path to recorded audiofiles : TODO
add 'unqueid' and 'recordingfile' columns to `call` table : TODO
catch 'uniqueid' on call end (where 'dst' = number dialed and 'calldate' +/- 1 min and 'channel' LIKE %operator_extension% ) : TODO
save 'unqueid' and 'recordingfile' data at call_end in `call` table : TODO
add audio file link and embedd audio player to calllist.php : TODO
update `call` data with other 'cdr' data like real call time ('calldate'), 'duration', 'disposition', 'billsec' (optional) : TODO
auto-assign call outcome_id depending on 'disposition' status: TODO
add audiofile links to Lime and queXS reports : TODO

This blueprint contains Public information 
Everyone can see this information.