private void KeepAliveThread(Object state)
{
while (!_disposed)
{
try
{
_workingMres.Wait();
if (!_client.Connected)
{
Thread.Sleep(10);
continue;
}
SendMessageQueue.Enqueue(new NetworkMessage()
{
Type = MessageType.KeepAlive
});
Thread.Sleep(1000);
}
catch (Exception ex)
{
if (ex is SocketException || ex is IOException)
{
continue;
}
Debug.WriteLine(ex.Message);
throw;
}
}
}
private static void OnMessageSent(IntPtr context, string sendName, uint sendHash, IntPtr message)
{
if (hv_msg_hasFormat(message, "f"))
{
SendMessageQueue msgQueue = (SendMessageQueue)GCHandle.FromIntPtr(hv_getUserData(context)).Target;
msgQueue.AddMessage(sendName, hv_msg_getFloat(message, 0));
}
}
/// <summary>
/// 處理取回派回結果後，根據派送成功或者失敗，決定是否回補點數。
/// </summary>
private void HandleSendMessageHistory(
SendMessageRule sendMessageRule,
SendMessageQueue sendMessageQueue,
SendMessageHistory sendMessageHistory)
{
if (sendMessageHistory.Delivered)
{
return;
}
if (sendMessageHistory.Price != 0)
{
return; // 如果簡訊商就算傳送失敗，但有收取簡訊費用，就不回補點數
}
if (sendMessageHistory.ProviderName == SmsProviderType.Every8d.ToString())
{
return; // Every8d 會重送，不需要回補點數
}
DateTime utcNow = DateTime.UtcNow;
// 補點
decimal point = sendMessageHistory.MessageCost;
var userRepository = this.unitOfWork.Repository <ApplicationUser>();
var user = sendMessageRule.CreatedUser;
user.SmsBalance += point;
userRepository.Update(user);
// 寫入交易明細
var tradeDetailRepository = this.unitOfWork.Repository <TradeDetail>();
var tradeDetail = new TradeDetail
{
TradeTime = utcNow,
TradeType = TradeType.CoverOfSendMessage,
Point = point,
OwnerId = user.Id,
TargetId = sendMessageHistory.Id.ToString(),
Remark = string.Format("{0}(簡訊編號：{1}，序列編號:{2})，收訊門號{3}發送失敗({4})，回補點數{5}點",
AttributeHelper.GetColumnDescription(sendMessageRule.SendTimeType),
sendMessageRule.Id,
sendMessageQueue.Id,
sendMessageHistory.DestinationAddress,
//AttributeHelper.GetColumnDescription(sendMessageHistory.DeliveryStatus),
sendMessageHistory.DeliveryStatusString,
point)
};
tradeDetailRepository.Insert(tradeDetail);
// 自動補點與點數預警 // 回補點數，不用自動補點與點數預警
//CheckCredit(user);
}
private void UpdateDb(SendMessageQueue sendMessageQueue, SEND_SMS_RESULT sendMessageResult)
{
// 寫入對應的 SendMessageResult
var every8d_SendMessageResult = new Every8d_SendMessageResult();
every8d_SendMessageResult.SourceTable = SourceTable.SendMessageQueue;
every8d_SendMessageResult.SourceTableId = sendMessageQueue.Id;
every8d_SendMessageResult.SendTime = sendMessageQueue.SendTime;
every8d_SendMessageResult.Subject = sendMessageQueue.SendTitle;
every8d_SendMessageResult.Content = sendMessageQueue.SendBody;
every8d_SendMessageResult.CreatedTime = DateTime.UtcNow;
every8d_SendMessageResult.CREDIT = sendMessageResult.CREDIT;
every8d_SendMessageResult.SENDED = sendMessageResult.SENDED;
every8d_SendMessageResult.COST = sendMessageResult.COST;
every8d_SendMessageResult.UNSEND = sendMessageResult.UNSEND;
every8d_SendMessageResult.BATCH_ID = sendMessageResult.BATCH_ID;
every8d_SendMessageResult = this.unitOfWork.Repository <Every8d_SendMessageResult>().Insert(every8d_SendMessageResult);
// Every8d 在此階段無法取得寫入 SendMessageHistory，無對應資料結構
// CreateSendMessageHistory(sendMessageQueue.Id);
// 在 Thread 中等待 30 秒，再寫入 DeliveryReportQueue
var delayMilliseconds = (int)30 * 1000;
FaFTaskFactory.StartNew(delayMilliseconds, () =>
{
using (var context = new ApplicationDbContext())
{
var _unitOfWork = new UnitOfWork(context);
var _repository = _unitOfWork.Repository <DeliveryReportQueue>();
// 寫入簡訊派送結果等待取回序列
var deliveryReportQueue = new DeliveryReportQueue();
deliveryReportQueue.SourceTableId = sendMessageQueue.Id;
deliveryReportQueue.SourceTable = SourceTable.SendMessageQueue;
deliveryReportQueue.RequestId = every8d_SendMessageResult.BATCH_ID;
deliveryReportQueue.ProviderName = this.Name;
deliveryReportQueue.CreatedTime = DateTime.UtcNow;
deliveryReportQueue.SendMessageResultItemCount = every8d_SendMessageResult.SENDED.HasValue ? every8d_SendMessageResult.SENDED.Value : 0;
deliveryReportQueue.DeliveryReportCount = 0;
deliveryReportQueue = _repository.Insert(deliveryReportQueue);
}
});
}
public void Queue_SendsMessageToDriver()
{
var driver = Substitute.For <IDriver>();
var logger = Substitute.For <ILogger>();
var q = new SendMessageQueue(TimeSpan.Zero, driver, logger, null);
var message = new PostMessage("channel");
q.Enqueue(message);
Thread.Sleep(10);
driver
.Received()
.SendMessageAsync(message, logger);
}
public void Queue_OnError()
{
var driver = Substitute.For <IDriver>();
var logger = Substitute.For <ILogger>();
var message = new PostMessage("channel");
driver.SendMessageAsync(message, logger)
.Returns(
_ => throw new Exception("test"),
_ => Task.CompletedTask);
var resetEvent = new AutoResetEvent(false);
var q = new SendMessageQueue(TimeSpan.Zero, driver, logger, async(queue, msg, l, ex) =>
{
await Task.Delay(10);
Assert.Same(msg, message);
Assert.Same(logger, l);
Assert.Equal("test", ex.Message);
Assert.Equal(1, msg.SendAttempts);
queue.Enqueue(msg);
resetEvent.Set();
});
q.Enqueue(message);
if (!resetEvent.WaitOne(100))
{
Assert.True(false, "reset event not set in callback");
}
driver
.Received(2)
.SendMessageAsync(message, logger);
}
public void CreateSendMessageQueue(SendMessageRule sendMessageRule, SendMessageQueue sendMessageQueue)
{
DateTime utcNow = DateTime.UtcNow;
// 只針對非預先扣除的簡訊類型，對於打算要發送的內容進行扣點
if (!ShouldWithhold(sendMessageRule.SendTimeType))
{
// 扣點
decimal point = sendMessageQueue.TotalMessageCost;
var userRepository = this.unitOfWork.Repository <ApplicationUser>();
var user = sendMessageRule.CreatedUser;
user.SmsBalance -= point;
userRepository.Update(user);
// 寫入交易明細
var tradeDetailRepository = this.unitOfWork.Repository <TradeDetail>();
var tradeDetail = new TradeDetail
{
TradeTime = utcNow,
TradeType = TradeType.DeductionOfSendMessage,
Point = -1 * point,
OwnerId = user.Id,
TargetId = sendMessageRule.Id.ToString(),
Remark = string.Format("{0}(簡訊編號：{1}，序列編號:{2})，建立完成(共{3}筆收訊人)，扣除{4}點",
AttributeHelper.GetColumnDescription(sendMessageRule.SendTimeType),
sendMessageRule.Id,
sendMessageQueue.Id,
this.unitOfWork.Repository <MessageReceiver>().Count(p => p.SendMessageRuleId == sendMessageRule.Id),
point)
};
tradeDetailRepository.Insert(tradeDetail);
// 自動補點與點數預警
CheckCredit(user);
}
}
public void Queue(BaseScertMessage message)
{
SendMessageQueue.Enqueue(message);
}
/// <summary>
/// 在 GetDeliveryReport 之後，更新大表 SendMessageHistory
/// </summary>
public void UpdateSendMessageHistory(int sendMessageQueueId)
{
var sendMessageRuleRepository = this.unitOfWork.Repository <SendMessageRule>();
var sendMessageQueueRepository = this.unitOfWork.Repository <SendMessageQueue>();
var sendMessageHistoryRepository = this.unitOfWork.Repository <SendMessageHistory>();
SendMessageQueue sendMessageQueue = sendMessageQueueRepository.GetById(sendMessageQueueId);
SendMessageRule sendMessageRule = sendMessageRuleRepository.GetById(sendMessageQueue.SendMessageRuleId);
var clientTimezoneOffset = sendMessageRule.ClientTimezoneOffset;
var messageReceivers = this.unitOfWork.Repository <MessageReceiver>().GetMany(p =>
p.SendMessageRuleId == sendMessageQueue.SendMessageRuleId &&
p.SendBody == sendMessageQueue.SendBody).ToList();
Every8d_SendMessageResult sendMessageResult = this.unitOfWork.Repository <Every8d_SendMessageResult>().Get(p => p.SourceTable == SourceTable.SendMessageQueue && p.SourceTableId == sendMessageQueueId);
// if (SendMessageResult == null) return; 不應該為 null
int?DepartmentId = null;
if (sendMessageRule.CreatedUser.Department != null)
{
DepartmentId = sendMessageRule.CreatedUser.Department.Id;
}
string CreatedUserId = sendMessageRule.CreatedUser.Id;
int SendMessageRuleId = sendMessageQueue.SendMessageRuleId;
SendMessageType SendMessageType = sendMessageQueue.SendMessageType;
DateTime SendTime = sendMessageQueue.SendTime;
string SendTitle = sendMessageQueue.SendTitle;
string SendBody = sendMessageQueue.SendBody;
SendCustType SendCustType = sendMessageQueue.SendCustType;
string RequestId = sendMessageResult.BATCH_ID;
string ProviderName = this.Name;
DateTime SendMessageResultCreatedTime = sendMessageResult.CreatedTime;
List <Every8d_DeliveryReport> DeliveryReports = sendMessageResult.DeliveryReports.ToList();
//foreach (var DeliveryReport in DeliveryReports)
for (var i = 0; i < DeliveryReports.Count; i++)
{
var DeliveryReport = DeliveryReports[i];
var messageReceiver = (0 <= i && i < messageReceivers.Count) ? messageReceivers[i] : null;
string DestinationName = DeliveryReport.NAME;
var entity = new SendMessageHistory();
////////////////////////////////////////
// 01 ~ 05
entity.DepartmentId = DepartmentId;
entity.CreatedUserId = CreatedUserId;
entity.SendMessageRuleId = SendMessageRuleId;
entity.SendMessageQueueId = sendMessageQueueId;
entity.SendMessageType = SendMessageType;
////////////////////////////////////////
// 06 ~ 10
entity.SendTime = SendTime;
entity.SendTitle = SendTitle;
entity.SendBody = SendBody;
entity.SendCustType = SendCustType;
entity.RequestId = RequestId;
////////////////////////////////////////
// 11 ~ 15
entity.ProviderName = ProviderName;
entity.MessageId = null;
entity.MessageStatus = MessageStatus.Unknown;
entity.MessageStatusString = entity.MessageStatus.ToString();
entity.SenderAddress = sendMessageRule.SenderAddress;
////////////////////////////////////////
// 16 ~ 20
// 20151106 Norman, Infobip 給的手機門號是 E164格式，但是沒有加上 "+"，使用 【MobileUtil.GetE164PhoneNumber】會導致誤判
var destinationAddress = DeliveryReport.MOBILE;
if (!destinationAddress.StartsWith("+", StringComparison.OrdinalIgnoreCase))
{
destinationAddress = "+" + destinationAddress;
}
entity.DestinationAddress = MobileUtil.GetE164PhoneNumber(destinationAddress);
entity.SendMessageResultCreatedTime = SendMessageResultCreatedTime;
// TODO: 驗證 Every8d 回傳發送時間轉成 UTC 時間是否正確
//entity.SentDate = Converter.ToDateTime(DeliveryReport.SENT_TIME, Converter.Every8d_SentTime).Value; // 2010/03/23 12:05:29
//entity.DoneDate = Converter.ToDateTime(DeliveryReport.SENT_TIME, Converter.Every8d_SentTime).Value; // 2010/03/23 12:05:29，簡訊供應商沒有提供此資訊，因此設定與SentDate一致
entity.SentDate = Converter.ToDateTime(DeliveryReport.SENT_TIME, Converter.Every8d_SentTime).Value.ToUniversalTime(); // 2010/03/23 12:05:29
entity.DoneDate = Converter.ToDateTime(DeliveryReport.SENT_TIME, Converter.Every8d_SentTime).Value.ToUniversalTime(); // 2010/03/23 12:05:29，簡訊供應商沒有提供此資訊，因此設定與SentDate一致
entity.DeliveryStatus = (DeliveryReportStatus)Convert.ToInt32(DeliveryReport.STATUS);
////////////////////////////////////////
// 21 ~ 25
entity.DeliveryStatusString = entity.DeliveryStatus.ToString();
entity.Price = Convert.ToDecimal(DeliveryReport.COST);
entity.DeliveryReportCreatedTime = DeliveryReport.CreatedTime;
entity.MessageCost = (new MessageCostInfo(entity.SendBody, entity.DestinationAddress).MessageCost);
entity.Delivered = IsDelivered(entity.DeliveryStatus);
////////////////////////////////////////
// 26
entity.DestinationName = DestinationName;
entity.Region = MobileUtil.GetRegionName(entity.DestinationAddress);
entity.CreatedTime = DateTime.UtcNow;
entity.RetryMaxTimes = systemParameters.RetryMaxTimes;
entity.RetryTotalTimes = 0;
entity.SendMessageRetryHistoryId = null;
entity.Email = messageReceiver != null ? messageReceiver.Email : string.Empty;
entity = sendMessageHistoryRepository.Insert(entity);
// 如果發送失敗，就回補點數
// 20151123 Norman, Eric 要求發送失敗不回補點數
//this.tradeService.HandleSendMessageHistory(sendMessageRule, sendMessageQueue, entity);
}
// (6) 出統計表
this.sendMessageStatisticService.AddOrUpdateSendMessageStatistic(sendMessageQueueId);
}
private static void OnMessageSent(double timeStamp, string receiverName, IntPtr message, IntPtr userData) {
if (hv_msg_hasFormat(message, "f")) {
SendMessageQueue msgQueue = (SendMessageQueue) GCHandle.FromIntPtr(userData).Target;
msgQueue.AddMessage(receiverName, hv_msg_getFloat(message, 0));
}
}
public void QueueServerEcho()
{
SendMessageQueue.Enqueue(new RT_MSG_SERVER_ECHO());
UtcLastServerEchoSent = DateTime.UtcNow;
}
/// <summary>
/// 在 GetDeliveryReport 之後，更新大表 SendMessageHistory
/// </summary>
public void UpdateSendMessageHistory(int sendMessageQueueId)
{
var sendMessageRuleRepository = this.unitOfWork.Repository <SendMessageRule>();
var sendMessageQueueRepository = this.unitOfWork.Repository <SendMessageQueue>();
var sendMessageHistoryRepository = this.unitOfWork.Repository <SendMessageHistory>();
SendMessageQueue sendMessageQueue = sendMessageQueueRepository.GetById(sendMessageQueueId);
SendMessageRule sendMessageRule = sendMessageRuleRepository.GetById(sendMessageQueue.SendMessageRuleId);
Infobip_SendMessageResult sendMessageResult = this.unitOfWork.Repository <Infobip_SendMessageResult>().Get(p => p.SourceTable == SourceTable.SendMessageQueue && p.SourceTableId == sendMessageQueueId);
if (sendMessageResult == null)
{
throw new Exception(string.Format("InfobipSmsProvider(smsProviderType = {0})，無法取得 Infobip_SendMessageResult(SendMessageQueueId：{1})", smsProviderType.ToString(), sendMessageQueueId));
}
int?DepartmentId = null;
if (sendMessageRule.CreatedUser.Department != null)
{
DepartmentId = sendMessageRule.CreatedUser.Department.Id;
}
string CreatedUserId = sendMessageRule.CreatedUser.Id;
int SendMessageRuleId = sendMessageQueue.SendMessageRuleId;
SendMessageType SendMessageType = sendMessageQueue.SendMessageType;
DateTime SendTime = sendMessageQueue.SendTime;
string SendTitle = sendMessageQueue.SendTitle;
string SendBody = sendMessageQueue.SendBody;
SendCustType SendCustType = sendMessageQueue.SendCustType;
string RequestId = sendMessageResult.ClientCorrelator;
string ProviderName = this.Name;
DateTime SendMessageResultCreatedTime = sendMessageResult.CreatedTime;
List <Infobip_SendMessageResultItem> SendMessageResults = sendMessageResult.SendMessageResults.ToList();
foreach (var SendMessageResult in SendMessageResults)
{
Infobip_DeliveryReport DeliveryReport = SendMessageResult.DeliveryReport;
if (DeliveryReport == null)
{
continue; // 如果尚未取得派送報表，就忽略
}
SendMessageHistory entity = this.unitOfWork.Repository <SendMessageHistory>().Get(p => p.MessageId == SendMessageResult.MessageId);
if (entity == null)
{
continue; // 如果找不到對應 MessageId，就忽略
}
string DestinationName = SendMessageResult.DestinationName;
////////////////////////////////////////
// 01 ~ 05
entity.DepartmentId = DepartmentId;
entity.CreatedUserId = CreatedUserId;
entity.SendMessageRuleId = SendMessageRuleId;
entity.SendMessageQueueId = sendMessageQueueId;
entity.SendMessageType = SendMessageType;
////////////////////////////////////////
// 06 ~ 10
entity.SendTime = SendTime;
entity.SendTitle = SendTitle;
entity.SendBody = SendBody;
entity.SendCustType = SendCustType;
entity.RequestId = RequestId;
////////////////////////////////////////
// 11 ~ 15
entity.ProviderName = ProviderName;
entity.MessageId = SendMessageResult.MessageId;
entity.MessageStatus = (EFunTech.Sms.Schema.MessageStatus)((int)SendMessageResult.MessageStatus);
entity.MessageStatusString = entity.MessageStatus.ToString();
entity.SenderAddress = SendMessageResult.SenderAddress;
////////////////////////////////////////
// 16 ~ 20
// 20151106 Norman, Infobip 給的手機門號是 E164格式，但是沒有加上 "+"，使用 【MobileUtil.GetE164PhoneNumber】會導致誤判
var destinationAddress = SendMessageResult.DestinationAddress;
if (!destinationAddress.StartsWith("+", StringComparison.OrdinalIgnoreCase))
{
destinationAddress = "+" + destinationAddress;
}
entity.DestinationAddress = MobileUtil.GetE164PhoneNumber(destinationAddress);
entity.SendMessageResultCreatedTime = SendMessageResultCreatedTime;
entity.SentDate = DeliveryReport.SentDate;
entity.DoneDate = DeliveryReport.DoneDate;
entity.DeliveryStatus = DeliveryReport.Status;
////////////////////////////////////////
// 21 ~ 25
entity.DeliveryStatusString = entity.DeliveryStatus.ToString();
entity.Price = DeliveryReport.Price ?? (decimal)0.0;
entity.DeliveryReportCreatedTime = DeliveryReport.CreatedTime;
entity.MessageCost = (new MessageCostInfo(entity.SendBody, entity.DestinationAddress).MessageCost);
entity.Delivered = IsDelivered(entity.DeliveryStatus);
////////////////////////////////////////
// 26
entity.DestinationName = DestinationName;
entity.Region = MobileUtil.GetRegionName(entity.DestinationAddress);
sendMessageHistoryRepository.Update(entity);
// 如果發送失敗，就回補點數
// 20151123 Norman, Eric 要求發送失敗不回補點數
//this.tradeService.HandleSendMessageHistory(sendMessageRule, sendMessageQueue, entity);
}
// (6) 出統計表
this.sendMessageStatisticService.AddOrUpdateSendMessageStatistic(sendMessageQueueId);
}
/// <summary>
/// 在 SendSMS 之後，建立大表 SendMessageHistory
/// </summary>
public void CreateSendMessageHistory(SendMessageQueue sendMessageQueue)
{
int sendMessageQueueId = sendMessageQueue.Id;
var sendMessageRuleRepository = this.unitOfWork.Repository <SendMessageRule>();
var sendMessageQueueRepository = this.unitOfWork.Repository <SendMessageQueue>();
var sendMessageHistoryRepository = this.unitOfWork.Repository <SendMessageHistory>();
SendMessageRule sendMessageRule = sendMessageRuleRepository.GetById(sendMessageQueue.SendMessageRuleId);
Infobip_SendMessageResult sendMessageResult = this.unitOfWork.Repository <Infobip_SendMessageResult>().Get(p => p.SourceTable == SourceTable.SendMessageQueue && p.SourceTableId == sendMessageQueueId);
if (sendMessageResult == null)
{
throw new Exception(string.Format("InfobipSmsProvider(smsProviderType = {0})，無法取得 Infobip_SendMessageResult(SendMessageQueueId：{1})", smsProviderType.ToString(), sendMessageQueueId));
}
int?DepartmentId = null;
if (sendMessageRule.CreatedUser.Department != null)
{
DepartmentId = sendMessageRule.CreatedUser.Department.Id;
}
string CreatedUserId = sendMessageRule.CreatedUser.Id;
int SendMessageRuleId = sendMessageQueue.SendMessageRuleId;
SendMessageType SendMessageType = sendMessageQueue.SendMessageType;
DateTime SendTime = sendMessageQueue.SendTime;
string SendTitle = sendMessageQueue.SendTitle;
string SendBody = sendMessageQueue.SendBody;
SendCustType SendCustType = sendMessageQueue.SendCustType;
string RequestId = sendMessageResult.ClientCorrelator;
string ProviderName = this.Name;
DateTime SendMessageResultCreatedTime = sendMessageResult.CreatedTime;
List <Infobip_SendMessageResultItem> SendMessageResults = sendMessageResult.SendMessageResults.ToList();
foreach (var SendMessageResult in SendMessageResults)
{
string DestinationName = SendMessageResult.DestinationName;
var entity = new SendMessageHistory();
////////////////////////////////////////
// 01 ~ 05
entity.DepartmentId = DepartmentId;
entity.CreatedUserId = CreatedUserId;
entity.SendMessageRuleId = SendMessageRuleId;
entity.SendMessageQueueId = sendMessageQueueId;
entity.SendMessageType = SendMessageType;
////////////////////////////////////////
// 06 ~ 10
entity.SendTime = SendTime;
entity.SendTitle = SendTitle;
entity.SendBody = SendBody;
entity.SendCustType = SendCustType;
entity.RequestId = RequestId;
////////////////////////////////////////
// 11 ~ 15
entity.ProviderName = ProviderName;
entity.MessageId = SendMessageResult.MessageId;
entity.MessageStatus = (EFunTech.Sms.Schema.MessageStatus)((int)SendMessageResult.MessageStatus);
entity.MessageStatusString = entity.MessageStatus.ToString();
entity.SenderAddress = SendMessageResult.SenderAddress;
////////////////////////////////////////
// 16 ~ 20
// 20151106 Norman, Infobip 給的手機門號是 E164格式，但是沒有加上 "+"，使用 【MobileUtil.GetE164PhoneNumber】會導致誤判
var destinationAddress = SendMessageResult.DestinationAddress;
if (!destinationAddress.StartsWith("+", StringComparison.OrdinalIgnoreCase))
{
destinationAddress = "+" + destinationAddress;
}
entity.DestinationAddress = MobileUtil.GetE164PhoneNumber(destinationAddress);
entity.SendMessageResultCreatedTime = SendMessageResultCreatedTime;
entity.SentDate = null;
entity.DoneDate = null;
entity.DeliveryStatus = DeliveryReportStatus.MessageAccepted;
////////////////////////////////////////
// 21 ~ 25
entity.DeliveryStatusString = entity.DeliveryStatus.ToString();
entity.Price = (decimal)0.0; // 尚未傳送完成
entity.DeliveryReportCreatedTime = null;
entity.MessageCost = (new MessageCostInfo(entity.SendBody, entity.DestinationAddress).MessageCost);
entity.Delivered = IsDelivered(entity.DeliveryStatus);
////////////////////////////////////////
// 26
entity.DestinationName = DestinationName;
entity.Region = MobileUtil.GetRegionName(entity.DestinationAddress);
entity.CreatedTime = DateTime.UtcNow;
entity.RetryMaxTimes = systemParameters.RetryMaxTimes;
entity.RetryTotalTimes = 0;
entity.SendMessageRetryHistoryId = null;
entity.Email = SendMessageResult.Email;
entity = sendMessageHistoryRepository.Insert(entity);
}
// (6) 出統計表
this.sendMessageStatisticService.AddOrUpdateSendMessageStatistic(sendMessageQueueId);
}
private void UpdateDb_SendSMS(SendMessageQueue sendMessageQueue, List <MessageReceiver> messageReceivers, SendMessageResult sendMessageResult)
{
// 寫入對應的 SendMessageResult
var infobip_SendMessageResult = new Infobip_SendMessageResult();
infobip_SendMessageResult.SourceTable = SourceTable.SendMessageQueue;
infobip_SendMessageResult.SourceTableId = sendMessageQueue.Id;
infobip_SendMessageResult.ClientCorrelator = sendMessageResult.ClientCorrelator;
infobip_SendMessageResult.CreatedTime = DateTime.UtcNow; // 接收發送命令回傳值的時間
infobip_SendMessageResult.Balance = this.Balance;
infobip_SendMessageResult = this.unitOfWork.Repository <Infobip_SendMessageResult>().Insert(infobip_SendMessageResult);
var sendMessageResultItemRepository = this.unitOfWork.Repository <Infobip_SendMessageResultItem>();
for (var i = 0; i < sendMessageResult.SendMessageResults.Length; i++)
{
// 一個 messageReceiver 對應一個 sendMessageResult
// 尚未驗證，是否我傳送的 destinations 順序與 SendMessageResults 順序一致
// 【目前假設是一致的】
var messageReceiver = messageReceivers[i];
var sendMessageResultItem = sendMessageResult.SendMessageResults[i];
// 20160715 Norman, 改成以下方式，用以解決以下問題
// The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.Infobip_DeliveryReport_dbo.Infobip_SendMessageResultItem_MessageId". The conflict occurred in database "EFunTechSms", table "dbo.Infobip_SendMessageResultItem", column 'MessageId'.
var infobip_SendMessageResultItem = sendMessageResultItemRepository.Get(p => p.MessageId == sendMessageResultItem.MessageId);
if (infobip_SendMessageResultItem == null)
{
// insert
infobip_SendMessageResultItem = new Infobip_SendMessageResultItem();
infobip_SendMessageResultItem.MessageId = sendMessageResultItem.MessageId;
infobip_SendMessageResultItem.MessageStatusString = sendMessageResultItem.MessageStatus;
EFunTech.Sms.Schema.MessageStatus MessageStatus = EFunTech.Sms.Schema.MessageStatus.Unknown;
Enum.TryParse <EFunTech.Sms.Schema.MessageStatus>(sendMessageResultItem.MessageStatus, out MessageStatus);
infobip_SendMessageResultItem.MessageStatus = MessageStatus;
infobip_SendMessageResultItem.SenderAddress = sendMessageResultItem.SenderAddress;
infobip_SendMessageResultItem.DestinationAddress = sendMessageResultItem.DestinationAddress;
infobip_SendMessageResultItem.SendMessageResult = infobip_SendMessageResult;
infobip_SendMessageResultItem.DestinationName = messageReceiver.Name;
infobip_SendMessageResultItem.Email = messageReceiver.Email;
infobip_SendMessageResultItem = sendMessageResultItemRepository.Insert(infobip_SendMessageResultItem);
}
else
{
// update
//infobip_SendMessageResultItem.MessageId = sendMessageResultItem.MessageId; // update 不需要這個欄位
infobip_SendMessageResultItem.MessageStatusString = sendMessageResultItem.MessageStatus;
EFunTech.Sms.Schema.MessageStatus MessageStatus = EFunTech.Sms.Schema.MessageStatus.Unknown;
Enum.TryParse <EFunTech.Sms.Schema.MessageStatus>(sendMessageResultItem.MessageStatus, out MessageStatus);
infobip_SendMessageResultItem.MessageStatus = MessageStatus;
infobip_SendMessageResultItem.SenderAddress = sendMessageResultItem.SenderAddress;
infobip_SendMessageResultItem.DestinationAddress = sendMessageResultItem.DestinationAddress;
infobip_SendMessageResultItem.SendMessageResult = infobip_SendMessageResult;
infobip_SendMessageResultItem.DestinationName = messageReceiver.Name;
infobip_SendMessageResultItem.Email = messageReceiver.Email;
sendMessageResultItemRepository.Update(infobip_SendMessageResultItem);
}
}
var infobip_ResourceReference = new Infobip_ResourceReference();
infobip_ResourceReference.SendMessageResultId = infobip_SendMessageResult.Id;
infobip_ResourceReference.ResourceURL = sendMessageResult.ResourceRef.ResourceURL;
infobip_ResourceReference = this.unitOfWork.Repository <Infobip_ResourceReference>().Insert(infobip_ResourceReference);
CreateSendMessageHistory(sendMessageQueue);
// 在 Thread 中等待 30 秒，再寫入 DeliveryReportQueue
var delayMilliseconds = (int)30 * 1000;
FaFTaskFactory.StartNew(delayMilliseconds, () =>
{
using (var context = new ApplicationDbContext())
{
var _unitOfWork = new UnitOfWork(context);
var _repository = _unitOfWork.Repository <DeliveryReportQueue>();
// 寫入簡訊派送結果等待取回序列
var deliveryReportQueue = new DeliveryReportQueue();
deliveryReportQueue.SourceTableId = sendMessageQueue.Id;
deliveryReportQueue.SourceTable = SourceTable.SendMessageQueue;
deliveryReportQueue.RequestId = infobip_SendMessageResult.ClientCorrelator;
deliveryReportQueue.ProviderName = this.Name;
deliveryReportQueue.CreatedTime = DateTime.UtcNow;
deliveryReportQueue.SendMessageResultItemCount = infobip_SendMessageResult.SendMessageResults.Count;
deliveryReportQueue.DeliveryReportCount = 0;
deliveryReportQueue = _repository.Insert(deliveryReportQueue);
}
});
}
public void SendSMS(int sendMessageRuleId, DateTime sendTime)
{
UniqueJob uniqueJob = null;
try
{
uniqueJob = this.uniqueJobList.AddOrUpdate("SendSMS", sendMessageRuleId, sendTime);
if (uniqueJob == null)
{
return; // Job 已經存在
}
// 如果在 SendMessageQueue 中已經有對應資料，就忽略
if (this.unitOfWork.Repository <SendMessageQueue>().Any(p =>
p.SendMessageRuleId == sendMessageRuleId &&
p.SendTime == sendTime))
{
return;
}
using (var scope = this.unitOfWork.CreateTransactionScope())
{
SendMessageRule sendMessageRule = this.unitOfWork.Repository <SendMessageRule>().GetById(sendMessageRuleId);
if (sendMessageRule == null)
{
this.logService.Error("sendMessageRule is null (sendMessageRuleId: {0})", sendMessageRuleId);
return;
}
this.logService.Debug("CommonSmsService，發送簡訊(簡訊編號：{0}，預定發送時間：{1}，實際發送時間：{2})",
sendMessageRule.Id,
Converter.ToLocalTime(sendTime, sendMessageRule.ClientTimezoneOffset).ToString(Converter.Every8d_SentTime),
Converter.ToLocalTime(DateTime.UtcNow, sendMessageRule.ClientTimezoneOffset).ToString(Converter.Every8d_SentTime));
ApplicationUser user = sendMessageRule.CreatedUser;
if (sendMessageRule.SendMessageRuleStatus != SendMessageRuleStatus.Ready)
{
return;
}
// 此簡訊規則下，所有收訊者資訊
var ruleReceivers = this.unitOfWork.Repository <MessageReceiver>().GetMany(p => p.SendMessageRuleId == sendMessageRule.Id).ToList();
// 目前有效的黑名單手機號碼 (E164)
var blackListMobiles = this.unitOfWork.Repository <Blacklist>()
.GetMany(p => p.CreatedUser.Id == sendMessageRule.CreatedUser.Id && p.Enabled == true)
.Select(p => p.Mobile)
.Distinct()
.ToList()
.Select(p => MobileUtil.GetE164PhoneNumber(p))
.ToList();
// 在黑名單的收訊者
var ruleReceiversInBlackList = ruleReceivers
.Where(p => blackListMobiles.Contains(MobileUtil.GetE164PhoneNumber(p.Mobile)))
.ToList();
// 不在黑名單的收訊者
var ruleReceiversNotInBlackList = ruleReceivers
.Where(p => !blackListMobiles.Contains(MobileUtil.GetE164PhoneNumber(p.Mobile)))
.ToList();
this.logService.Debug("CommonSmsService，發送簡訊(簡訊編號：{0}，預定發送名單：{1})", sendMessageRuleId, ExcelBugFix.GetInformation(ruleReceivers.Select(p => p.Mobile).ToList()));
this.logService.Debug("CommonSmsService，發送簡訊(簡訊編號：{0}，黑名單：{1})", sendMessageRuleId, ExcelBugFix.GetInformation(ruleReceiversInBlackList.Select(p => p.Mobile).ToList()));
this.logService.Debug("CommonSmsService，發送簡訊(簡訊編號：{0}，實際發送名單：{1})", sendMessageRuleId, ExcelBugFix.GetInformation(ruleReceiversNotInBlackList.Select(p => p.Mobile).ToList()));
//List<string> detailInformations = new List<string>();
//detailInformations.AddRange(ExcelBugFix.GetDetailInformation(ruleReceivers.Select(p => p.Mobile).ToList())
// .Select(p => string.Format("CommonSmsService，發送簡訊(簡訊編號：{0}，預定發送名單(全)：{1})", sendMessageRuleId, p))
// .ToList());
//detailInformations.AddRange(ExcelBugFix.GetDetailInformation(ruleReceiversInBlackList.Select(p => p.Mobile).ToList())
// .Select(p => string.Format("CommonSmsService，發送簡訊(簡訊編號：{0}，黑名單(全)：{1})", sendMessageRuleId, p))
// .ToList());
//detailInformations.AddRange(ExcelBugFix.GetDetailInformation(ruleReceiversNotInBlackList.Select(p => p.Mobile).ToList())
// .Select(p => string.Format("CommonSmsService，發送簡訊(簡訊編號：{0}，實際發送名單(全)：{1})", sendMessageRuleId, p))
// .ToList());
//foreach (var detailInformation in detailInformations)
//{
// this.logService.Debug(detailInformation);
//}
// 找出所有不同的發送內容
var sendBodies = ruleReceiversNotInBlackList.Select(p => p.SendBody).Distinct().ToList();
// 針對沒有執行預扣的簡訊規則，判斷是否有足夠點數進行簡訊發送作業
decimal totalMessageCost = ruleReceiversNotInBlackList.Sum(p => p.MessageCost);
if (!this.tradeService.ShouldWithhold(sendMessageRule.SendTimeType))
{
if (sendMessageRule.CreatedUser.SmsBalance < totalMessageCost)
{
string message = string.Format("執行{0}失敗(編號:{1})，使用者 {2} 點數不足，目前點數 {3} 點，發送所需點數 {4} 點",
AttributeHelper.GetColumnDescription(sendMessageRule.SendTimeType),
sendMessageRule.Id,
sendMessageRule.CreatedUser.UserName,
sendMessageRule.CreatedUser.SmsBalance,
totalMessageCost);
this.logService.Error(message);
throw new Exception(message);
}
}
// 找出可以使用的簡訊供應商(可連線且餘額足夠)
SmsProviderType userSmsProviderType = user.SmsProviderType;
ISmsProvider provider = GetProvider(userSmsProviderType, totalMessageCost); // 如果沒有找到，將會拋出例外
// 開始發送，將 SendMessageRule 狀態改變為 Sending (正在發送簡訊規則)
sendMessageRule.SendMessageRuleStatus = SendMessageRuleStatus.Sending;
sendMessageRule.CreatedUser = user;
this.unitOfWork.Repository <SendMessageRule>().Update(sendMessageRule);
foreach (var sendBody in sendBodies)
{
// 依據傳送內容分群，每個群組使用一個SendMessageQueue，
// 此SendMessageQueue下，所有收訊者資訊
var queueReceivers = ruleReceiversNotInBlackList.Where(p => p.SendBody == sendBody).ToList();
var sendMessageQueue = new SendMessageQueue();
sendMessageQueue.SendMessageType = sendMessageRule.SendMessageType;
sendMessageQueue.SendTime = sendTime.ToUniversalTime(); // 預定發送訊息的時間(SendSMS經由Hangfire傳遞過來的sendTime，會將DateTimeKind轉為 Local，必須再轉成 Utc)
sendMessageQueue.SendTitle = sendMessageRule.SendTitle;
sendMessageQueue.SendBody = sendBody;
sendMessageQueue.SendCustType = sendMessageRule.SendCustType;
sendMessageQueue.TotalReceiverCount = queueReceivers.Count();
sendMessageQueue.TotalMessageCost = queueReceivers.Sum(p => p.MessageCost);
sendMessageQueue.SendMessageRuleId = sendMessageRule.Id;
// 只針對非預先扣除的簡訊類型，對於打算要發送的內容進行扣點
this.tradeService.CreateSendMessageQueue(sendMessageRule, sendMessageQueue);
sendMessageQueue = this.unitOfWork.Repository <SendMessageQueue>().Insert(sendMessageQueue);
this.logService.Debug("CommonSmsService，發送簡訊(簡訊編號：{0}，序列號碼：{1}，發送名單：{2}，發送內容：{3})",
sendMessageRuleId,
sendMessageQueue.Id,
ExcelBugFix.GetInformation(queueReceivers.Select(p => p.Mobile).ToList()),
sendBody);
provider.SendSMS(sendMessageQueue.Id); // TODO: 在 EVA 測試, 要先註解這一行，避免發送簡訊
} // foreach (var sendBody in sendBodies)
// 全部簡訊發送完畢，將 SendMessageRule 狀態改變為 Sending (簡訊規則已發送完畢)
sendMessageRule.SendMessageRuleStatus = SendMessageRuleStatus.Sent;
this.unitOfWork.Repository <SendMessageRule>().Update(sendMessageRule);
// http://www.dotblogs.com.tw/rainmaker/archive/2015/08/19/153169.aspx
// 檢查此簡訊規則是否任務完成，
// 如果是的話，將狀態設為 Finish
// 如果否的話，將狀態設為 Ready (等待下次週期簡訊發送)
bool isFinish = !sendMessageRule.GetNextSendTime().HasValue;
sendMessageRule.SendMessageRuleStatus = isFinish ? SendMessageRuleStatus.Finish : SendMessageRuleStatus.Ready;
this.unitOfWork.Repository <SendMessageRule>().Update(sendMessageRule);
// 針對預先扣點的發送時間類型，進行黑名單的收訊者 - 退還點數
this.tradeService.HandleReceiversInBlackList(sendMessageRule, ruleReceiversInBlackList);
scope.Complete();
}
////////////////////////////////////////
}
catch (Exception ex)
{
this.logService.Error(ex);
throw;
}
finally
{
if (uniqueJob != null)
{
this.uniqueJobList.Remove(uniqueJob);
}
}
}