bmlt-enabled / bmlt-enabled/yap
Missed Call Report
- 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.