2023-05-24 15:28:14 +08:00
|
|
|
import logging
|
|
|
|
|
|
2023-05-24 14:27:48 +08:00
|
|
|
from django.urls import reverse
|
|
|
|
|
|
2024-07-16 16:20:16 +02:00
|
|
|
from apps.alerts.models import BundledNotification
|
|
|
|
|
from apps.alerts.tasks import send_update_log_report_signal
|
2023-05-24 14:27:48 +08:00
|
|
|
from apps.twilioapp.models import TwilioCallStatuses, TwilioPhoneCall, TwilioSMS, TwilioSMSstatuses
|
|
|
|
|
from common.api_helpers.utils import create_engine_url
|
|
|
|
|
|
2023-05-24 15:28:14 +08:00
|
|
|
logger = logging.getLogger(__name__)
|
|
|
|
|
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
def update_twilio_call_status(call_sid, call_status):
|
|
|
|
|
"""The function checks existence of TwilioPhoneCall instance
|
|
|
|
|
according to call_sid and updates status on message_status
|
|
|
|
|
|
|
|
|
|
Args:
|
|
|
|
|
call_sid (str): sid of Twilio call
|
|
|
|
|
call_status (str): new status
|
|
|
|
|
|
|
|
|
|
Returns:
|
|
|
|
|
|
|
|
|
|
"""
|
2024-07-16 16:20:16 +02:00
|
|
|
from apps.base.models import UserNotificationPolicy, UserNotificationPolicyLogRecord
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
if call_sid and call_status:
|
2023-05-24 15:28:14 +08:00
|
|
|
logger.info(f"twilioapp.update_twilio_call_status: processing sid={call_sid} status={call_status}")
|
2023-06-08 13:13:54 +08:00
|
|
|
status_code = TwilioCallStatuses.DETERMINANT.get(call_status)
|
|
|
|
|
|
|
|
|
|
if status_code is None:
|
|
|
|
|
logger.warning(
|
|
|
|
|
f"twilioapp.update_twilio_call_status: unexpected status sid={call_sid} status={call_status}"
|
|
|
|
|
)
|
|
|
|
|
return
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
twilio_phone_call = TwilioPhoneCall.objects.filter(sid=call_sid).first()
|
|
|
|
|
|
2023-06-08 13:13:54 +08:00
|
|
|
if twilio_phone_call is None:
|
|
|
|
|
logger.warning(f"twilioapp.update_twilio_call_status: twilio_phone_call not found sid={call_sid}")
|
|
|
|
|
return
|
|
|
|
|
|
|
|
|
|
logger.info(f"twilioapp.update_twilio_call_status: found twilio_phone_call sid={call_sid}")
|
|
|
|
|
twilio_phone_call.status = status_code
|
|
|
|
|
twilio_phone_call.save(update_fields=["status"])
|
|
|
|
|
phone_call_record = twilio_phone_call.phone_call_record
|
|
|
|
|
|
|
|
|
|
if phone_call_record is None:
|
|
|
|
|
logger.warning(
|
|
|
|
|
f"twilioapp.update_twilio_call_status: twilio_phone_call has no phone_call record sid={call_sid} "
|
|
|
|
|
f"status={call_status}"
|
2023-05-24 15:28:14 +08:00
|
|
|
)
|
2023-06-08 13:13:54 +08:00
|
|
|
return
|
|
|
|
|
|
|
|
|
|
logger.info(
|
|
|
|
|
f"twilioapp.update_twilio_call_status: found phone_call_record id={phone_call_record.id} "
|
|
|
|
|
f"sid={call_sid} status={call_status}"
|
|
|
|
|
)
|
|
|
|
|
log_record_type = None
|
|
|
|
|
log_record_error_code = None
|
|
|
|
|
if status_code == TwilioCallStatuses.COMPLETED:
|
|
|
|
|
log_record_type = UserNotificationPolicyLogRecord.TYPE_PERSONAL_NOTIFICATION_SUCCESS
|
|
|
|
|
elif status_code in [TwilioCallStatuses.FAILED, TwilioCallStatuses.BUSY, TwilioCallStatuses.NO_ANSWER]:
|
|
|
|
|
log_record_type = UserNotificationPolicyLogRecord.TYPE_PERSONAL_NOTIFICATION_FAILED
|
|
|
|
|
log_record_error_code = get_error_code_by_twilio_status(status_code)
|
|
|
|
|
if log_record_type is not None:
|
|
|
|
|
log_record = UserNotificationPolicyLogRecord(
|
|
|
|
|
type=log_record_type,
|
|
|
|
|
notification_error_code=log_record_error_code,
|
|
|
|
|
author=phone_call_record.receiver,
|
|
|
|
|
notification_policy=phone_call_record.notification_policy,
|
|
|
|
|
alert_group=phone_call_record.represents_alert_group,
|
2024-07-16 16:20:16 +02:00
|
|
|
notification_step=UserNotificationPolicy.Step.NOTIFY,
|
|
|
|
|
notification_channel=UserNotificationPolicy.NotificationChannel.PHONE_CALL,
|
2023-06-08 13:13:54 +08:00
|
|
|
)
|
|
|
|
|
log_record.save()
|
2023-05-24 15:28:14 +08:00
|
|
|
logger.info(
|
2023-06-08 13:13:54 +08:00
|
|
|
f"twilioapp.update_twilio_call_status: created log_record log_record_id={log_record.id} "
|
|
|
|
|
f"type={log_record_type}"
|
2023-05-24 15:28:14 +08:00
|
|
|
)
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
|
|
|
|
|
def get_error_code_by_twilio_status(status):
|
2023-07-25 10:43:23 +01:00
|
|
|
from apps.base.models import UserNotificationPolicyLogRecord
|
|
|
|
|
|
2023-05-24 14:27:48 +08:00
|
|
|
TWILIO_ERRORS_TO_ERROR_CODES_MAP = {
|
|
|
|
|
TwilioCallStatuses.BUSY: UserNotificationPolicyLogRecord.ERROR_NOTIFICATION_PHONE_CALL_LINE_BUSY,
|
|
|
|
|
TwilioCallStatuses.FAILED: UserNotificationPolicyLogRecord.ERROR_NOTIFICATION_PHONE_CALL_FAILED,
|
|
|
|
|
TwilioCallStatuses.NO_ANSWER: UserNotificationPolicyLogRecord.ERROR_NOTIFICATION_PHONE_CALL_NO_ANSWER,
|
|
|
|
|
}
|
|
|
|
|
return TWILIO_ERRORS_TO_ERROR_CODES_MAP.get(status, None)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
def update_twilio_sms_status(message_sid, message_status):
|
|
|
|
|
"""The function checks existence of SMSMessage
|
|
|
|
|
instance according to message_sid and updates status on
|
|
|
|
|
message_status
|
|
|
|
|
|
|
|
|
|
Args:
|
|
|
|
|
message_sid (str): sid of Twilio message
|
|
|
|
|
message_status (str): new status
|
|
|
|
|
|
|
|
|
|
Returns:
|
|
|
|
|
|
|
|
|
|
"""
|
2024-07-16 16:20:16 +02:00
|
|
|
from apps.base.models import UserNotificationPolicy, UserNotificationPolicyLogRecord
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
if message_sid and message_status:
|
2023-05-24 15:28:14 +08:00
|
|
|
logger.info(f"twilioapp.update_twilio_message_status: processing sid={message_sid} status={message_status}")
|
2023-06-08 13:13:54 +08:00
|
|
|
status_code = TwilioSMSstatuses.DETERMINANT.get(message_status)
|
|
|
|
|
if status_code is None:
|
|
|
|
|
logger.warning(
|
|
|
|
|
f"twilioapp.update_twilio_message_status: unexpected status sid={message_sid} status={message_status}"
|
|
|
|
|
)
|
|
|
|
|
return
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
twilio_sms = TwilioSMS.objects.filter(sid=message_sid).first()
|
2023-06-08 13:13:54 +08:00
|
|
|
if twilio_sms is None:
|
|
|
|
|
logger.warning(f"twilioapp.update_twilio_message_status: twilio_sms not found sid={message_sid}")
|
|
|
|
|
return
|
|
|
|
|
|
|
|
|
|
logger.info(f"twilioapp.update_twilio_sms_status: found twilio_sms sid={message_sid}")
|
|
|
|
|
twilio_sms.status = status_code
|
|
|
|
|
twilio_sms.save(update_fields=["status"])
|
|
|
|
|
sms_record = twilio_sms.sms_record
|
|
|
|
|
|
|
|
|
|
if sms_record is None:
|
|
|
|
|
logger.warning(f"twilioapp.update_twilio_sms_status: twilio_sms has no sms_record sid={message_sid}")
|
|
|
|
|
return
|
|
|
|
|
|
|
|
|
|
logger.info(
|
|
|
|
|
f"twilioapp.update_twilio_sms_status: found sms_record id={sms_record.id} "
|
|
|
|
|
f"sid={message_sid} status={message_status}"
|
|
|
|
|
)
|
|
|
|
|
log_record_type = None
|
|
|
|
|
log_record_error_code = None
|
|
|
|
|
if status_code == TwilioSMSstatuses.DELIVERED:
|
|
|
|
|
log_record_type = UserNotificationPolicyLogRecord.TYPE_PERSONAL_NOTIFICATION_SUCCESS
|
|
|
|
|
elif status_code in [TwilioSMSstatuses.UNDELIVERED, TwilioSMSstatuses.FAILED]:
|
|
|
|
|
log_record_type = UserNotificationPolicyLogRecord.TYPE_PERSONAL_NOTIFICATION_FAILED
|
|
|
|
|
log_record_error_code = get_sms_error_code_by_twilio_status(status_code)
|
|
|
|
|
if log_record_type is not None:
|
2024-07-16 16:20:16 +02:00
|
|
|
if sms_record.represents_bundle_uuid:
|
|
|
|
|
notifications = BundledNotification.objects.filter(bundle_uuid=sms_record.represents_bundle_uuid)
|
|
|
|
|
log_records_to_create = []
|
|
|
|
|
for notification in notifications:
|
|
|
|
|
log_record = UserNotificationPolicyLogRecord(
|
|
|
|
|
type=log_record_type,
|
|
|
|
|
notification_error_code=log_record_error_code,
|
|
|
|
|
author=sms_record.receiver,
|
|
|
|
|
notification_policy=notification.notification_policy,
|
|
|
|
|
alert_group=notification.alert_group,
|
|
|
|
|
notification_step=UserNotificationPolicy.Step.NOTIFY,
|
|
|
|
|
notification_channel=UserNotificationPolicy.NotificationChannel.SMS,
|
|
|
|
|
)
|
|
|
|
|
log_records_to_create.append(log_record)
|
|
|
|
|
# send send_update_log_report_signal with 10 seconds delay
|
|
|
|
|
send_update_log_report_signal.apply_async(
|
|
|
|
|
kwargs={"alert_group_pk": notification.alert_group_id}, countdown=10
|
|
|
|
|
)
|
|
|
|
|
UserNotificationPolicyLogRecord.objects.bulk_create(log_records_to_create, batch_size=5000)
|
|
|
|
|
logger.info(
|
|
|
|
|
f"twilioapp.update_twilio_sms_status: created log_records for sms bundle "
|
|
|
|
|
f"{sms_record.represents_bundle_uuid} type={log_record_type}"
|
|
|
|
|
)
|
|
|
|
|
else:
|
|
|
|
|
log_record = UserNotificationPolicyLogRecord(
|
|
|
|
|
type=log_record_type,
|
|
|
|
|
notification_error_code=log_record_error_code,
|
|
|
|
|
author=sms_record.receiver,
|
|
|
|
|
notification_policy=sms_record.notification_policy,
|
|
|
|
|
alert_group=sms_record.represents_alert_group,
|
|
|
|
|
notification_step=UserNotificationPolicy.Step.NOTIFY,
|
|
|
|
|
notification_channel=UserNotificationPolicy.NotificationChannel.SMS,
|
|
|
|
|
)
|
|
|
|
|
log_record.save()
|
|
|
|
|
logger.info(
|
|
|
|
|
f"twilioapp.update_twilio_sms_status: created log_record log_record_id={log_record.id} "
|
|
|
|
|
f"type={log_record_type}"
|
|
|
|
|
)
|
2023-05-24 14:27:48 +08:00
|
|
|
|
|
|
|
|
|
|
|
|
|
def get_sms_error_code_by_twilio_status(status):
|
2023-07-25 10:43:23 +01:00
|
|
|
from apps.base.models import UserNotificationPolicyLogRecord
|
|
|
|
|
|
2023-05-24 14:27:48 +08:00
|
|
|
TWILIO_ERRORS_TO_ERROR_CODES_MAP = {
|
|
|
|
|
TwilioSMSstatuses.UNDELIVERED: UserNotificationPolicyLogRecord.ERROR_NOTIFICATION_SMS_DELIVERY_FAILED,
|
|
|
|
|
TwilioSMSstatuses.FAILED: UserNotificationPolicyLogRecord.ERROR_NOTIFICATION_SMS_DELIVERY_FAILED,
|
|
|
|
|
}
|
|
|
|
|
return TWILIO_ERRORS_TO_ERROR_CODES_MAP.get(status, None)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
def get_call_status_callback_url():
|
|
|
|
|
return create_engine_url(reverse("twilioapp:call_status_events"))
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
def get_sms_status_callback_url():
|
|
|
|
|
return create_engine_url(reverse("twilioapp:sms_status_events"))
|