public void GetDeliveryReport()
{
try
{
var predicate = PredicateBuilder.True <DeliveryReportQueue>();
// 避免 Migration 錯誤
//{
// var innerPredicate = PredicateBuilder.False<DeliveryReportQueue>();
// var sendMessageQueueIds = this.unitOfWork.Repository<SendMessageQueue>().GetAll().Select(p => p.Id).ToList();
// foreach (var sendMessageQueueId in sendMessageQueueIds)
// {
// innerPredicate = innerPredicate.Or(p => p.SendMessageQueueId == sendMessageQueueId);
// }
// predicate = predicate.And(innerPredicate); // 會造成無窮迴圈，WHY???
//}
// 尚未接收完成
{
predicate = predicate.And(p => p.DeliveryReportCount < p.SendMessageResultItemCount);
}
// 尚未過期
{
var expiryDate = DateTime.UtcNow.AddTicks(-1 * DeliveryReportQueue.QueryInterval.Ticks);
predicate = predicate.And(p => p.CreatedTime >= expiryDate); // 尚未過期
}
var queues = this.unitOfWork.Repository <DeliveryReportQueue>()
.GetAll()
.AsExpandable()
.Where(predicate)
.OrderByDescending(p => p.CreatedTime)
.ToList();
if (!queues.Any())
{
return;
}
var queuesInfos = queues
.ToList()
.Select(p => string.Format("{{ 簡訊發送識別碼:{0}, 已發送: {1}, 已接收:{2}}}", p.RequestId, p.SendMessageResultItemCount, p.DeliveryReportCount))
.ToList();
this.logService.Debug("等待接收簡訊發送結果序列：{0})", ExcelBugFix.GetInformation(queuesInfos));
// 原本邏輯
//foreach (var queue in queues)
//{
// BackgroundJob.Enqueue<CommonSmsService>(x => x.GetDeliveryReport(queue.RequestId));
//}
var requestIds = queues.Select(p => p.RequestId).ToList();
var unlockedRequestIds = this.uniqueJobList.GetUnlockedJob("GetDeliveryReport", requestIds);
foreach (var requestId in unlockedRequestIds)
{
BackgroundJob.Enqueue <CommonSmsService>(x => x.GetDeliveryReport(requestId));
}
}
catch (Exception ex)
{
this.logService.Error(ex);
throw;
}
}
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);
}
}
}