NethVoice CTI cdr refactor #7133
Description
Redesign of the call report section of the NethVoice CTI with the display of calls grouped by linkedid and the details of all events related to the main call in the right drawer.
Asterisk cdr has a record for each iteration of the call.
This complicates the visualization for the end user as it does not make the outcome of the call clear.
By changing the queries that NethVoice CTI performs it is possible to group all the occurrences of a call summarizing the outcome in a single line.
Ask for the new queries for the various views for the Switchboard mode (all, In, out, lost, internal), which must be adapt to the other modes (Group and Personal), I can't attach here.
it is necessary to allow by clicking on the record line to see all the steps that characterized the call in order of time.
Evaluate
CREATE INDEX idx_linkedid ON cdr(linkedid);
CREATE INDEX idx_disposition ON cdr(disposition);
CREATE INDEX idx_lastapp ON cdr(lastapp);