bmlt-enabled / bmlt-enabled/yap

Missed Call Report

Open
#1,311 1 comment 1 reaction 0 assignees View on GitHub
enhancement v5
Dominant language
PHP
Stars
13
Forks
12
Avg merge
5h 20m
Merged PRs (30d)
3

Description

There was a request for a better way to see missed calls.

```sql
SELECT b.*
FROM conference_participants a
INNER JOIN records b ON a.callsid = b.callsid
WHERE a.conferencesid IN (
SELECT b.conferencesid
FROM records_events a
INNER JOIN (
SELECT
re.callsid,
cp.conferencesid,
IFNULL(re.service_body_id, 0) AS service_body_id
FROM records_events re
INNER JOIN conference_participants cp ON re.callsid = cp.callsid
WHERE re.event_time BETWEEN '2024-12-27' AND '2025-01-25'
GROUP BY re.callsid, cp.conferencesid, re.service_body_id
) b ON a.callsid = b.callsid
WHERE a.event_id IN (7, 8, 12)
AND b.service_body_id = 6
GROUP BY a.service_body_id, b.conferencesid
HAVING SUM(CASE WHEN a.event_id = 12 THEN 1 ELSE 0 END) = 0
);
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.