private bool ValidateVpsSigniture(OrderReadOnly order, CallbackRequestModel callbackRequest, OpayoSettings settings)
{
var md5Values = new List <string>
{
callbackRequest.VPSTxId,
callbackRequest.VendorTxCode,
callbackRequest.Status,
callbackRequest.TxAuthNo,
settings.VendorName.ToLowerInvariant(),
callbackRequest.AVSCV2,
order.Properties[OpayoConstants.OrderProperties.SecurityKey]?.Value,
callbackRequest.AddressResult,
callbackRequest.PostCodeResult,
callbackRequest.CV2Result,
callbackRequest.GiftAid,
callbackRequest.SecureStatus,
callbackRequest.CAVV,
callbackRequest.AddressStatus,
callbackRequest.PayerStatus,
callbackRequest.CardType,
callbackRequest.Last4Digits,
callbackRequest.DeclineCode,
callbackRequest.ExpiryDate,
callbackRequest.FraudResponse,
callbackRequest.BankAuthCode
};
string calcedMd5Hash = string.Join("", md5Values.Where(v => string.IsNullOrEmpty(v) == false)).ToMD5Hash().ToUpperInvariant();
return(callbackRequest.VPSSignature == calcedMd5Hash);
}
public CallbackResult HandleCallback(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
switch (request.Status)
{
case OpayoConstants.CallbackRequest.Status.Abort:
return(GenerateAbortedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Rejected:
return(GenerateRejectedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Registered:
case OpayoConstants.CallbackRequest.Status.Error:
return(GenerateErrorCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Pending:
return(GeneratePendingCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Ok:
return(GenerateOkCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.NotAuthorised:
return(GenerateNotAuthorisedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Authenticated:
return(GenerateAuthenticatedCallbackResponse(order, request, settings));
default:
return(CallbackResult.Empty);
}
}
private CallbackResult GeneratePendingCallbackResponse(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
logger.Warn <OpayoServerClient>("Payment transaction pending:\n\tOpayoTx: {VPSTxId}", request.VPSTxId);
var validSig = ValidateVpsSigniture(order, request, settings);
return(new CallbackResult
{
TransactionInfo = validSig
? new TransactionInfo
{
TransactionId = request.VPSTxId,
AmountAuthorized = order.TotalPrice.Value.WithTax,
TransactionFee = request.Surcharge,
PaymentStatus = PaymentStatus.PendingExternalSystem
}
: null,
HttpResponse = new HttpResponseMessage(System.Net.HttpStatusCode.OK)
{
Content = validSig
? GenerateOkCallbackResponseBody()
: GenerateInvalidCallbackResponseBody()
}
});
}
private CallbackResult GenerateOkCallbackResponse(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
logger.Warn <OpayoServerClient>("Payment transaction okay:\n\tOpayoTx: {VPSTxId}", request.VPSTxId);
var validSig = ValidateVpsSigniture(order, request, settings);
return(new CallbackResult
{
TransactionInfo = validSig
? new TransactionInfo
{
TransactionId = request.VPSTxId,
AmountAuthorized = order.TotalPrice.Value.WithTax,
TransactionFee = request.Surcharge,
PaymentStatus = request.TxType == "PAYMENT" ? PaymentStatus.Captured : PaymentStatus.Authorized
}
: null,
HttpResponse = new HttpResponseMessage(System.Net.HttpStatusCode.OK)
{
Content = validSig
? GenerateOkCallbackResponseBody()
: GenerateInvalidCallbackResponseBody()
},
MetaData = validSig
? new Dictionary <string, string>
{
{ OpayoConstants.OrderProperties.TransDetails, string.Join(":", request.TxAuthNo, request.CardType, request.Last4Digits) },
{ OpayoConstants.OrderProperties.TransDetailsHash, string.Join(":", request.TxAuthNo, request.CardType, request.Last4Digits).ToMD5Hash() }
}
: null
});
}
public CallbackResult HandleCallback(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
switch (request.Status)
{
case OpayoConstants.CallbackRequest.Status.Abort:
return(GenerateAbortedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Rejected:
return(GenerateRejectedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Registered:
case OpayoConstants.CallbackRequest.Status.Error:
return(GenerateErrorCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Pending:
return(GeneratePendingCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Ok:
return(GenerateOkCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.NotAuthorised:
return(GenerateNotAuthorisedCallbackResponse(order, request, settings));
case OpayoConstants.CallbackRequest.Status.Authenticated:
return(GenerateAuthenticatedCallbackResponse(order, request, settings));
default:
logger.Warn <SagePayServerClient>("Unknown callback response status recieved: {status}", request.Status);
return(CallbackResult.Empty);
}
}
public override CallbackResult ProcessCallback(OrderReadOnly order, HttpRequestBase request, OpayoSettings settings)
{
var callbackRequestModel = CallbackRequestModel.FromRequest(request);
var client = new OpayoServerClient(
logger,
new OpayoServerClientConfig {
ProviderAlias = Alias,
ContinueUrl = paymentProviderUriResolver.GetContinueUrl(Alias, order.GenerateOrderReference(), hashProvider),
CancelUrl = paymentProviderUriResolver.GetCancelUrl(Alias, order.GenerateOrderReference(), hashProvider),
ErrorUrl = GetErrorUrl(order, settings)
});
return(client.HandleCallback(order, callbackRequestModel, settings));
}
private CallbackResult GenerateErrorCallbackResponse(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
logger.Warn <OpayoServerClient>("Payment transaction error:\n\tOpayoTx: {VPSTxId}\n\tDetail: {StatusDetail}", request.VPSTxId, request.StatusDetail);
var validSig = ValidateVpsSigniture(order, request, settings);
return(new CallbackResult
{
HttpResponse = new HttpResponseMessage(System.Net.HttpStatusCode.OK)
{
Content = validSig
? GenerateRejectedCallbackResponseBody()
: GenerateInvalidCallbackResponseBody()
}
});
}
private void threadProc()
{
while (!_isbreak)
{
SortedList <string, string> list = BusinessDao.GetNeedCheckDebitRecords();
Log.WriteDebugLog("StatusCheckThread::threadProc", "存在{0}个需要确认的订单。", list.Count);
foreach (string orderId in list.Keys)
{
string target = list[orderId];
Log.WriteDebugLog("StatusCheckThread::threadProc", "{0} 准备开始确认订单的状态，渠道{1}。", orderId, target);
LoanBank bank = new LoanBank();
string merchantCode = String.Empty;
InquriyTransferResponse response = bank.DuitkuOrderStatusInquiryRequest(orderId, target);
if (response.statusCode == "00")
{
CallbackRequestModel callback = new CallbackRequestModel();
callback.amount = response.amount;
callback.merchantOrderId = response.merchantOrderId;
DataProviderResultModel resultModel = DuitkuProvider.SetDuitkuPaybackRecordStaus(callback);
if (resultModel.result == Result.SUCCESS)
{
Log.WriteDebugLog("StatusCheckThread::threadProc", "[{0}]重做成功了。", orderId);
}
else
{
Log.WriteDebugLog("StatusCheckThread::threadProc", "[{0}]接口调用成功，但是数据库操作失败了。", orderId);
}
}
else
{
Log.WriteDebugLog("StatusCheckThread::threadProc", "[{0}]重做失败了。", orderId);
}
///重做次数＋1
BusinessDao.UpdateRedoUserPayBackRecordStatus(orderId);
}
Thread.Sleep(10 * 60 * 1000);
}
}
public static DataProviderResultModel SetDuitkuPaybackRecordStaus(CallbackRequestModel request)
{
DataBaseOperator dbo = null;
IDbConnection conn = null;
IDbTransaction tran = null;
int dbret = -1;
DataProviderResultModel result = new DataProviderResultModel();
try
{
dbo = new DataBaseOperator();
string sqlStr = "select debitId,type,userId from IFUserPayBackDebitRecord where id = @iId and status = @iStatus";
ParamCollections pc = new ParamCollections();
pc.Add("@iId", request.merchantOrderId);
pc.Add("@iStatus", -2);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]查询还款记录表的数据，用户、还款类型、贷款记录ID。", request.merchantOrderId);
DataTable paybackInfo = dbo.GetTable(sqlStr, pc.GetParams(true));
if (null != paybackInfo && paybackInfo.Rows.Count == 1)
{
string debitId = Convert.ToString(paybackInfo.Rows[0]["debitId"]);
string type = Convert.ToString(paybackInfo.Rows[0]["type"]);
string userId = Convert.ToString(paybackInfo.Rows[0]["userId"]);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]查询到还款记录，用户：{1}、还款类型:{2}、贷款记录ID:{3}。"
, request.merchantOrderId, userId, type, debitId);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]开始更新还款记录表的状态", request.merchantOrderId);
conn = dbo.GetConnection();
tran = dbo.BeginTransaction(conn);
sqlStr = @"update IFUserPayBackDebitRecord set status = @iStatus1,statusTime = now(),money=@fMoney
where id = @iId and status = @iStatus2";
pc.Add("@iStatus1", 1);
pc.Add("@fMoney", request.amount);
pc.Add("@iId", request.merchantOrderId);
pc.Add("@iStatus2", -2);
result.data = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新还款记录表的状态，结果为：{1}", request.merchantOrderId, result.data);
sqlStr = @"select date_format(now(),'%Y-%m-%d') now,date_format(payBackDayTime,'%Y-%m-%d') payBackDayTime
from IFUserDebitRecord where debitId = @iDebitId";
pc.Add("@iDebitId", debitId);
DataTable debitInfo = dbo.GetTable(sqlStr, pc.GetParams(true));
if (null != debitInfo && debitInfo.Rows.Count == 1)
{
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]查询到用户应还时间{1}"
, request.merchantOrderId, debitInfo.Rows[0]["payBackDayTime"]);
string extendLogSql = String.Empty;
//tran = conn.BeginTransaction();
///3 － 延期；4 － 还款
if (type == "3")
{
//如果还款日期大于当前日期，延期后的时间是从还款时间＋7天（相当于提前延期）。
//如果还款日期小于当前日期，延期时间是从当天＋7天。
DateTime now = DateTime.Now;
DateTime payback = DateTime.Now;
DateTime.TryParse(Convert.ToString(debitInfo.Rows[0]["payBackDayTime"]), out payback);
DateTime.TryParse(Convert.ToString(debitInfo.Rows[0]["now"]), out now);
DataProviderResultModel extendResult = DebitProvider.GetUserExtendRecord(Convert.ToInt32(debitId));
if (extendResult.result == Result.SUCCESS)
{
DebitExtendModel extendInfo = extendResult.data as DebitExtendModel;
float amoutMoney = 0f;
float needPayMoney = 0f;
float.TryParse(request.amount, out amoutMoney);
needPayMoney = (float)Math.Round(extendInfo.extendFee + extendInfo.overdueMoney - extendInfo.partMoney, 0);
amoutMoney = (float)Math.Round(amoutMoney, 0);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]核对应还金额 needPayMoney:{1} - amoutMoney:{2}", request.merchantOrderId, needPayMoney, amoutMoney);
if (amoutMoney >= (extendInfo.extendFee - extendInfo.partMoney))
{
#region 全额延期逻辑
//如果存在逾期，全额支付后需清算逾期
if (extendInfo.overdueMoney > 0 && amoutMoney >= needPayMoney)
{
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "逾期费用：{0}，开始清算。", extendInfo.overdueMoney);
sqlStr = @"update IFUserDebitOverdueRecord set clearStatus=@iClearStatus,clearTime=now(),clearSource=@iClearSource
where debitId=@iDebitId";
pc.Add("@iClearStatus", 1);
pc.Add("@iClearSource", 2);
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}][{1}]清算逾期费用 成功({2})。", request.merchantOrderId, debitId, dbret);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]金额大于最小延期费，系统自动审核。用户[{1}]。", request.merchantOrderId, extendInfo.userId);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及最后还款时间。", request.merchantOrderId);
TimeSpan ts = payback.Subtract(now);
if (ts.Days >= 0)
{
sqlStr = @"update IFUserDebitRecord set status = @iStatus,paybackdayTime=date_add(paybackdayTime, interval 7 day)
,statusTime = now(),partMoney=@fPartMoney,overdueMoney = 0,overdueDay = 0
where debitId = @iDebitId";
}
else
{
sqlStr = @"update IFUserDebitRecord set status = @iStatus,paybackdayTime=date_add(now(), interval 7 day)
,statusTime = now(),partMoney=@fPartMoney,overdueMoney = 0,overdueDay = 0
where debitId = @iDebitId";
}
pc.Add("@iStatus", 1);
//如果多还了，就暂存到部份还款字段。
if (amoutMoney - needPayMoney > 0)
{
pc.Add("@fPartMoney", amoutMoney - needPayMoney);
}
else
{
pc.Add("@fPartMoney", 0);
}
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及最后还款时间 成功({1})。", request.merchantOrderId, dbret);
//插日志
extendLogSql = @"insert into IFUserDebitPaybackTimeChange(debitId, beforTime, changeDays, afterTime,
changeType, remarks,createTime,adminId,objectId)
values(@iDebitId, @dBeforTime, @iChangeDays, @dAfterTime,
@iChangeType, @sRemarks, now(), @iAdminId, @iObjectId);";
pc.Add("@iDebitId", debitId);
pc.Add("@dBeforTime", payback.ToString("yyyy-MM-dd"));
pc.Add("@iChangeDays", ts.Days >= 0 ? ts.Days + 7 : 7 + (ts.Days * -1));
pc.Add("@dAfterTime", ts.Days >= 0 ? payback.AddDays(7).ToString("yyyy-MM-dd") : now.AddDays(7).ToString("yyyy-MM-dd"));
pc.Add("@iChangeType", 4);
pc.Add("@sRemarks", "Proses perpanjangan disetujui(10001).");
pc.Add("@iAdminId", "-1");
pc.Add("@iObjectId", request.merchantOrderId);
dbret = dbo.ExecuteStatement(extendLogSql, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}] 插入贷款的还款时间变更记录 成功({1})。", request.merchantOrderId, dbret);
}
else
{
//如果只还了最小的延期费，则不清算逾期费
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]金额大于最小延期费，系统自动审核。用户[{1}]。", request.merchantOrderId, extendInfo.userId);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及最后还款时间，因为没有支付逾期费，所以。", request.merchantOrderId);
sqlStr = @"update IFUserDebitRecord set status = @iStatus,paybackdayTime=date_add(paybackdayTime, interval 7 day)
,statusTime = now(),partMoney=@fPartMoney
where debitId = @iDebitId";
pc.Add("@iStatus", 1);
//如果多还了，就暂存到部份还款字段。
if (amoutMoney - (extendInfo.extendFee - extendInfo.partMoney) > 0)
{
pc.Add("@fPartMoney", amoutMoney - (extendInfo.extendFee - extendInfo.partMoney));
}
else
{
pc.Add("@fPartMoney", 0);
}
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及最后还款时间 成功({1})。", request.merchantOrderId, dbret);
extendLogSql = @"insert into IFUserDebitPaybackTimeChange(debitId, beforTime, changeDays, afterTime,
changeType, remarks,createTime,adminId,objectId)
values(@iDebitId, @dBeforTime, @iChangeDays, @dAfterTime,
@iChangeType, @sRemarks, now(), @iAdminId, @iObjectId);";
pc.Add("@iDebitId", debitId);
pc.Add("@dBeforTime", payback.ToString("yyyy-MM-dd"));
pc.Add("@iChangeDays", 7);
pc.Add("@dAfterTime", payback.AddDays(7).ToString("yyyy-MM-dd"));
pc.Add("@iChangeType", 4);
pc.Add("@sRemarks", "Proses perpanjangan disetujui(10002).");
pc.Add("@iAdminId", "-1");
pc.Add("@iObjectId", request.merchantOrderId);
dbret = dbo.ExecuteStatement(extendLogSql, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入贷款的还款时间变更记录 成功({1})。", request.merchantOrderId, dbret);
}
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]开始插入审核记录。", request.merchantOrderId);
sqlStr = @"insert into IFUserAduitDebitRecord(AduitType,debitId,status,description,adminId,auditTime)
values(@iAuditType, @iDebitId, @iAuditStatus, @sAuditDescription, @iUserId, now());" ;
pc.Add("@iAuditType", 2);
pc.Add("@iDebitId", debitId);
pc.Add("@iAuditStatus", 1);
pc.Add("@sAuditDescription", "Proses perpanjangan disetujui(10002).");
pc.Add("@iUserId", -1);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入审核记录 成功({1})。", request.merchantOrderId, dbret);
#endregion
}
else
{
#region 部份延期逻辑
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]金额对不上，将已还计入部份还款。", request.merchantOrderId);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]应支付：{1}，收到用户支付：{2}，差额：{3}，历史支付：{4}。"
, request.merchantOrderId, needPayMoney, amoutMoney, needPayMoney - amoutMoney, extendInfo.partMoney);
sqlStr = @"update IFUserPayBackDebitRecord set status = @iStatus1,statusTime = now(),money=@fMoney
where id = @iId";
pc.Add("@iStatus1", 1);
pc.Add("@fMoney", request.amount);
pc.Add("@iId", request.merchantOrderId);
result.data = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
sqlStr = @"update IFUserDebitRecord set status = if(date_format(payBackDayTime,'%Y-%m-%d') < date_format(now(),'%Y-%m-%d'), 4, 1)
,partMoney=ifnull(partMoney,0)+@fMoney,statusTime = now()
where debitId = @iDebitId";
pc.Add("@fMoney", request.amount);
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
//取，如果延期成功，下一次还款时间
sqlStr = @"SELECT if(convert(date_format(payBackDayTime,'%Y%m%d'), signed) >=
convert(date_format(now(),'%Y%m%d'),signed), date_format(date_add(payBackDayTime, interval 7 day),'%Y-%m-%d')
, date_format(date_add(now(), interval 7 day),'%Y-%m-%d')
) extendNextPayback FROM IFUserDebitRecord where debitId = @iDebitId;";
pc.Add("@iDebitId", debitId);
object extendNextPayback = dbo.GetScalar(sqlStr, pc.GetParams(true));
sqlStr = @"insert into IFUserAduitDebitRecord(AduitType,debitId,status,description,adminId,auditTime)
values(@iAuditType, @iDebitId, @iAuditStatus, @sAuditDescription, @iUserId, now());" ;
//还款所需金额 ＝ 贷款金额 ＋ 逾期费 － 本次支付 － 历史支付金额
float needPaybackMoney = extendInfo.debitMoney + extendInfo.overdueMoney - amoutMoney - extendInfo.partMoney;
//已支付Rp100.000，还款还需要支付Rp140.000，延期到2018-09-21还需要支付Rp400.000
//Sudah bayar 100 harus d bayarkan 1.400.000 sepenuhnya dibayar dan untuk diperpanjang sampai 21 -09- 2018 harus bayar 400.000
string desc = String.Format("Sudah bayar {0} harus dibayarkan {1} sepenuhnya dan untuk diperpanjang sampai {2} harus bayar {3}.\r\nJika ada pertanyaan silakan hubungi:\r\n0813 1682 3995\r\n0813 8366 2454."
, amoutMoney.ToString("N0").Replace(",", "."), needPaybackMoney.ToString("N0").Replace(",", "."), extendNextPayback, (needPayMoney - amoutMoney).ToString("N0").Replace(",", "."));
pc.Add("@iAuditType", 2);
pc.Add("@iDebitId", debitId);
pc.Add("@iAuditStatus", 1);
pc.Add("@sAuditDescription", desc);//延期申请（审核中）
pc.Add("@iUserId", -1);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入审核记录 成功({1})。", request.merchantOrderId, dbret);
extendLogSql = @"insert into IFUserDebitPaybackTimeChange(debitId, changeDays,
changeType, remarks,createTime,adminId,objectId)
values(@iDebitId, @iChangeDays,
@iChangeType, @sRemarks, now(), @iAdminId, @iObjectId);";
pc.Add("@iDebitId", debitId);
pc.Add("@iChangeDays", 0);
pc.Add("@iChangeType", -1);
pc.Add("@sRemarks", desc);
pc.Add("@iAdminId", "-1");
pc.Add("@iObjectId", request.merchantOrderId);
dbret = dbo.ExecuteStatement(extendLogSql, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入贷款的还款时间变更记录 成功({1})。", request.merchantOrderId, dbret);
#endregion
}
}
}
if (type == "4")
{
DataProviderResultModel debitResult = DebitProvider.GetUserDebitRecord(Convert.ToInt32(debitId));
if (debitResult.result == Result.SUCCESS)
{
DebitInfoModel debitModel = debitResult.data as DebitInfoModel;
float amoutMoney = 0f;
float needPayMoney = 0f;
float.TryParse(request.amount, out amoutMoney);
needPayMoney = (float)Math.Round(debitModel.payBackMoney, 0);
amoutMoney = (float)Math.Round(amoutMoney, 0);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]核对应还金额 needPayMoney:{1} - amoutMoney:{2}", request.merchantOrderId, needPayMoney, amoutMoney);
if (amoutMoney >= needPayMoney)
{
#region 全额还款逻辑
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]金额对上，系统自动审核。用户[{1}]全额还款次数＋1。", request.merchantOrderId, debitModel.userId);
sqlStr = @"update IFUsers set fullPaymentTimes = ifnull(fullPaymentTimes,0) + 1 where userId = @iUserId";
pc.Add("@iUserId", debitModel.userId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新用户全额还款次数成功（{1}）。", request.merchantOrderId, dbret);
sqlStr = @"update IFUserDebitRecord set status = @iStatus,userPaybackTime=now(),statusTime = now(),
partMoney=@fPartMoney,overdueMoney = 0,overdueDay = 0
where debitId = @iDebitId";
pc.Add("@iStatus", 3);
//如果多还了，暂存到该字段。
pc.Add("@fPartMoney", amoutMoney - needPayMoney);
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
//如果存在逾期，全额支付后需清算逾期
if (debitModel.overdueMoney > 0)
{
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]逾期费用：{1}，开始清算。", request.merchantOrderId, debitModel.overdueMoney);
sqlStr = @"update IFUserDebitOverdueRecord set clearStatus=@iClearStatus,clearTime=now(),clearSource=@iClearSource
where debitId=@iDebitId";
pc.Add("@iClearStatus", 1);
pc.Add("@iClearSource", 2);
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}][{1}]清算逾期费用 成功({2})。", request.merchantOrderId, debitId, dbret);
}
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及还款时间 成功({1})。", request.merchantOrderId, dbret);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]开始插入审核记录。", request.merchantOrderId);
sqlStr = @"insert into IFUserAduitDebitRecord(AduitType,debitId,status,description,adminId,auditTime)
values(@iAuditType, @iDebitId, @iAuditStatus, @sAuditDescription, @iUserId, now());" ;
pc.Add("@iAuditType", 3);
pc.Add("@iDebitId", debitId);
pc.Add("@iAuditStatus", 3);
pc.Add("@sAuditDescription", "Proses pembayaran disetujui(10002).");
pc.Add("@iUserId", -1);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入审核记录 成功({1})。", request.merchantOrderId, dbret);
extendLogSql = @"insert into IFUserDebitPaybackTimeChange(debitId, changeDays,
changeType, remarks,createTime,adminId,objectId)
values(@iDebitId, @iChangeDays,
@iChangeType, @sRemarks, now(), @iAdminId, @iObjectId);";
pc.Add("@iDebitId", debitId);
pc.Add("@iChangeDays", 0);
pc.Add("@iChangeType", 6);
pc.Add("@sRemarks", "Proses pembayaran disetujui(10002).");
pc.Add("@iAdminId", "-1");
pc.Add("@iObjectId", request.merchantOrderId);
dbret = dbo.ExecuteStatement(extendLogSql, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入贷款的还款时间变更记录 成功({1})。", request.merchantOrderId, dbret);
#endregion
}
else
{
#region 部份还款逻辑
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]金额对不上，进入人工审核。", request.merchantOrderId);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]应支付：{1}，收到用户支付：{2}，差额：{3}，历史支付：{4}。"
, request.merchantOrderId, needPayMoney, amoutMoney, needPayMoney - amoutMoney, debitModel.partMoney);
sqlStr = @"update IFUserPayBackDebitRecord set status = @iStatus1,statusTime = now(),money=@fMoney
where id = @iId";
pc.Add("@iStatus1", 1);
pc.Add("@fMoney", request.amount);
pc.Add("@iId", request.merchantOrderId);
result.data = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
//原来是什么状态，就更新为什么状态,将还款的钱更新到部份还款金额字段。
sqlStr = @"update IFUserDebitRecord set status = if(payBackDayTime < now(), 4, 1)
,partMoney=ifnull(partMoney,0)+@fMoney,statusTime = now()
where debitId = @iDebitId";
//pc.Add("@iStatus", 1);
pc.Add("@fMoney", request.amount);
pc.Add("@iDebitId", debitId);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]更新贷款记录表状态及还款时间 成功({1})。", request.merchantOrderId, dbret);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]开始插入审核记录。", request.merchantOrderId);
sqlStr = @"insert into IFUserAduitDebitRecord(AduitType,debitId,status,description,adminId,auditTime)
values(@iAuditType, @iDebitId, @iAuditStatus, @sAuditDescription, @iUserId, now());" ;
string desc = String.Format("Sudah membayar Rp {0}.\r\nuntuk pelunasan silakan bayarkan kembali sisanya sebesar Rp {1}.\r\nJika ada pertanyaan silakan hubungi:\r\n0813 1682 3995\r\n0813 8366 2454."
, amoutMoney.ToString("N0").Replace(",", "."), (debitModel.payBackMoney - amoutMoney).ToString("N0").Replace(",", "."));
pc.Add("@iAuditType", 3);
pc.Add("@iDebitId", debitId);
pc.Add("@iAuditStatus", 1);
pc.Add("@sAuditDescription", desc);
pc.Add("@iUserId", -1);
dbret = dbo.ExecuteStatement(sqlStr, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入审核记录 成功({1})。", request.merchantOrderId, dbret);
extendLogSql = @"insert into IFUserDebitPaybackTimeChange(debitId, changeDays,
changeType, remarks,createTime,adminId,objectId)
values(@iDebitId, @iChangeDays,
@iChangeType, @sRemarks, now(), @iAdminId, @iObjectId);";
pc.Add("@iDebitId", debitId);
pc.Add("@iChangeDays", 0);
pc.Add("@iChangeType", 7);
pc.Add("@sRemarks", desc);
pc.Add("@iAdminId", "-1");
pc.Add("@iObjectId", request.merchantOrderId);
dbret = dbo.ExecuteStatement(extendLogSql, pc.GetParams(true), conn);
Log.WriteDebugLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]插入贷款的还款时间变更记录 成功({1})。", request.merchantOrderId, dbret);
#endregion
}
}
}
result.result = Result.SUCCESS;
tran.Commit();
}
else
{
result.result = Result.ERROR;
Log.WriteErrorLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "[{0}]查找贷款ID失败，记录不存在。{1}", request.merchantOrderId, debitId);
tran.Rollback();
}
}
else
{
result.result = Result.ERROR;
Log.WriteErrorLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "根据订单ID查找贷款ID失败，有可能该订单已处理。{0}", request.merchantOrderId);
}
}
catch (Exception ex)
{
if (null != tran)
{
tran.Rollback();
}
result.result = Result.ERROR;
result.message = ex.Message;
Log.WriteErrorLog("DuitkuProvider::SetDuitkuPaybackRecordStaus", "{0} 订单在执行时发生异常： {1}", request.merchantOrderId, ex.Message);
}
finally
{
if (null != dbo)
{
if (null != conn)
{
dbo.ReleaseConnection(conn);
}
dbo.Close();
dbo = null;
}
}
return(result);
}
public static DataProviderResultModel SaveDuitkuCallbackRecord(CallbackRequestModel request)
{
DataProviderResultModel result = new DataProviderResultModel();
DataBaseOperator dbo = null;
IDbConnection conn = null;
IDbTransaction tran = null;
try
{
dbo = new DataBaseOperator();
conn = dbo.GetConnection();
tran = dbo.BeginTransaction(conn);
ParamCollections pc = new ParamCollections();
string sqlStr = @"insert into IFDuitkuCallbackLogs(merchantCode,amount,merchantOrderId,productDetail,additionalParam,
merchantUserId,reference,signature,issuer_name,issuer_bank,createTime,guid)
values(@sMerchantCode,@sAmount,@sMerchantOrderId,@sProductDetail,@sAdditionalParam,
@sMerchantUserId,@sReference,@sSignature,@sIssuer_name,@sIssuer_bank,now(),@sGuid);";
string guid = Guid.NewGuid().ToString();
pc.Add("@sMerchantCode", request.merchantCode);
pc.Add("@sAmount", request.amount);
pc.Add("@sMerchantOrderId", request.merchantOrderId);
pc.Add("@sProductDetail", request.productDetail);
pc.Add("@sAdditionalParam", request.additionalParam);
pc.Add("@sMerchantUserId", request.merchantUserId);
pc.Add("@sReference", request.reference);
pc.Add("@sSignature", request.signature);
pc.Add("@sIssuer_name", request.issuer_name);
pc.Add("@sIssuer_bank", request.issuer_bank);
pc.Add("@sGuid", guid);
dbo.ExecuteStatement(sqlStr, pc.GetParams());
result.data = guid;
result.result = Result.SUCCESS;
}
catch (Exception ex)
{
if (null != tran)
{
tran.Rollback();
}
result.result = Result.ERROR;
result.message = ex.Message;
Log.WriteErrorLog("DuitkuProvider::SaveDuitkuCallbackRecord", "{0}", ex.Message);
}
finally
{
if (null != tran)
{
tran.Commit();
}
if (null != dbo)
{
if (null != conn)
{
dbo.ReleaseConnection(conn);
}
dbo.Close();
dbo = null;
}
}
return(result);
}
private CallbackResult GenerateAuthenticatedCallbackResponse(OrderReadOnly order, CallbackRequestModel request, OpayoSettings settings)
{
logger.Warn <OpayoServerClient>("Payment transaction Authenticated:\n\tOpayoTx: {VPSTxId}", request.VPSTxId);
var validSig = ValidateVpsSigniture(order, request, settings);
return(new CallbackResult
{
HttpResponse = new HttpResponseMessage(System.Net.HttpStatusCode.OK)
{
Content = validSig
? GenerateOkCallbackResponseBody()
: GenerateInvalidCallbackResponseBody()
},
MetaData = validSig
? new Dictionary <string, string>
{
{ OpayoConstants.OrderProperties.TransDetails, string.Join(":", request.TxAuthNo, request.CardType, request.Last4Digits) },
{ OpayoConstants.OrderProperties.TransDetailsHash, string.Join(":", request.TxAuthNo, request.CardType, request.Last4Digits).ToMD5Hash() }
}
: null
});
}
public ActionResult <string> CallbackRequest([FromForm] CallbackRequestModel request)
{
Redis redis = new Redis();
string key = String.Format("CallbackRequest_{0}", request.merchantOrderId);
try
{
if (!request.IsEmpty())
{
if (redis.LockTake(key, 1, 20))
{
try
{
string signature = String.Empty;
string duitkuKey = getDuitkuKey(request.merchantCode);
signature = request.merchantCode + request.amount + request.merchantOrderId + duitkuKey;
signature = HelperProvider.MD532(signature);
DataProviderResultModel result = DuitkuProvider.SaveDuitkuCallbackRecord(request);
string guid = Convert.ToString(result.data);
///记录调用日志，最终需要写入数据库
Log.WriteLog("DuitkuController::CallbackRequest", "{0} - {1}", result.result, JsonConvert.SerializeObject(request));
//验证签名
if (signature == request.signature)
{
Log.WriteDebugLog("DuitkuController::CallbackRequest", "签名验证通过:{0} - 传入为：{1}", signature, request.signature);
///验证通过
DataProviderResultModel ret = DuitkuProvider.SetDuitkuPaybackRecordStaus(request);
if (ret.result == Result.SUCCESS)
{
Log.WriteDebugLog("DuitkuController::CallbackRequest", "回调操作成功。");
DuitkuProvider.SetDuitkuCallbackRecordStatus(guid, 1);
return("Success");
}
else
{
Log.WriteErrorLog("DuitkuController::CallbackRequest", "回调操作失败。");
DuitkuProvider.SetDuitkuCallbackRecordStatus(guid, -1);
return("Error");
}
}
else
{
Log.WriteDebugLog("DuitkuController::CallbackRequest", "签名验证没有通过:{0} - 传入为：{1}", signature, request.signature);
///签名不通过
return("Bad Signature");
}
}
finally
{
redis.LockRelease(key, 1);
}
}
else
{
Log.WriteDebugLog("DuitkuController::CallbackRequest", "获取锁失败。{0}", JsonConvert.SerializeObject(request));
return("Get lock failed.");
}
}
else
{
Log.WriteDebugLog("DuitkuController::CallbackRequest", "参数异常，缺少必要的参数:{0}", JsonConvert.SerializeObject(request));
return("Bad Parameter");
}
}
catch (Exception ex)
{
Log.WriteErrorLog("DuitkuController::CallbackRequest", "{0}", ex.Message);
}
finally
{
redis.LockRelease(key, 1);
}
return("Error");
}
public override bool CanRefundPayments => false; // FOR NOW
public override CallbackResult ProcessCallback(OrderReadOnly order, HttpRequestBase request, PayNlPaymentProviderSettings settings)
{
Vendr.Log.Info <PayNlPaymentProvider>("PayNl Callback for order");
var transactionId = "";
var sync = true;
if (sync)
{
transactionId = request.QueryString["orderId"];
}
else
{
// async callback on webhook url
var callbackInfo = CallbackRequestModel.FromRequest(request);
transactionId = callbackInfo.OrderId;
}
var payNlConfiguration = new PAYNLSDK.API.PayNlConfiguration(settings.ServiceId, settings.ApiToken);
var payNlClient = new ApiTokenClient(payNlConfiguration);
var transaction = new Transaction(payNlClient);
Vendr.Log.Info <PayNlPaymentProvider>("Retrieve transaction details from PayNl to validate order");
var info = transaction.Info(transactionId);
Vendr.Log.Info <PayNlPaymentProvider>("Retrieved transaction details {@payNlTransactionDetails}", info);
var vendrTransactionInfo = new TransactionInfo
{
AmountAuthorized = info.PaymentDetails.Amount,
TransactionFee = 0m,
TransactionId = transactionId,
};
if ((int)info.PaymentDetails.State == 100)
{
Vendr.Log.Info <PayNlPaymentProvider>("Payment State is autorized");
vendrTransactionInfo.PaymentStatus = PaymentStatus.Authorized;
}
else if ((int)info.PaymentDetails.State > 0)
{
Vendr.Log.Info <PayNlPaymentProvider>("Payment State is still pending");
vendrTransactionInfo.PaymentStatus = PaymentStatus.PendingExternalSystem;
}
else if ((int)info.PaymentDetails.State < 0)
{
Vendr.Log.Info <PayNlPaymentProvider>("Payment State was closed in error");
vendrTransactionInfo.PaymentStatus = PaymentStatus.Error;
}
return(new CallbackResult
{
TransactionInfo = vendrTransactionInfo,
MetaData = new Dictionary <string, string>()
{
{ "CardType", info.PaymentDetails.CardType },
{ "CardBrand", info.PaymentDetails.CardBrand },
{ "IpAddress", info.Connection.IP },
{ "TransactionId", transactionId },
{ "PaymentSessionId", info.StatsDetails.PaymentSessionId.ToString() }
}
});
}
