using DocumentServiceApi.InitQMessage;
|
using DocumentServiceAPI.Model.Permissions;
|
using DocumentServiceAPI.Model.UserInfoModel;
|
using Furion.Schedule;
|
using Microsoft.Extensions.Logging;
|
using Npgsql.TypeHandlers;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace DocumentServiceAPI.Job
|
{
|
public class PermissionJob : IJob
|
{
|
private readonly ILogger<PermissionJob> _logger;
|
private readonly ISqlSugarClient _db;
|
private readonly PostMessageServices _InitQMessagePost;
|
public PermissionJob(ILogger<PermissionJob> logger , ISqlSugarClient db,PostMessageServices postMessageServices)
|
{
|
_logger = logger;
|
_db = db;
|
_InitQMessagePost = postMessageServices;
|
}
|
|
public async Task ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken)
|
{
|
|
_logger.LogInformation("执行了任务ExecuteAsync");
|
var TimeOutPList= await _db.Queryable<TenantPermissions>().Where(x => x.IsEn && x.OverTime < DateTime.Now).ToListAsync();
|
foreach (var item in TimeOutPList)
|
{
|
//设置权限为无效
|
item.IsEn = false;
|
|
}
|
await _db.Updateable(TimeOutPList).UpdateColumns(it => new { it.IsEn }).ExecuteCommandAsync();
|
|
var tPermissions= await _db.Queryable< TenantPermissions >().LeftJoin<TenantInfo>((tx,t)=>tx.TenantId==t.Id).Where((tx,t)=>tx.IsEn==true&&tx.OverTime<DateTime.Now.AddDays(15)).Select((tx,t)=>new {tx,t}).ToListAsync();
|
foreach (var t in tPermissions)
|
{
|
TimeSpan difference = t.tx.OverTime - DateTime.Now;
|
int data= difference.Days;
|
if (data == 15|| data == 10 ||data==3)
|
{
|
//第15天，10天，3天发送短信
|
_InitQMessagePost.PostDelayMessage(new MessAgeOption
|
{
|
|
Title="标书管理系统消息",
|
isNeedSMS = true,
|
PhoneCode = t.t.ItCode,
|
UserID = t.t.ZcUserID,
|
MsgContent = $"您的 标书管理系统将于{DateTime.Now.ToString("yyyy MM dd")}日到期，请尽快与客户经理联系【四川政采招投标咨询有限公司】",
|
SMSMsgContent = $"您的 标书管理系统将于{DateTime.Now.ToString("yyyy MM dd")}日到期，请尽快与客户经理联系【四川政采招投标咨询有限公司】"
|
}, DateTime.Now.AddHours(8));
|
}
|
|
}
|
|
return ;
|
|
|
}
|
}
|
|
|
}
|
