725 lines
40 KiB
C#
725 lines
40 KiB
C#
using System.Net.Http.Headers;
|
|
using System.Reflection.Metadata;
|
|
using BMA.EHR.Application.Common.Interfaces;
|
|
using BMA.EHR.Application.Responses;
|
|
using BMA.EHR.Domain.Extensions;
|
|
using BMA.EHR.Domain.Models.HR;
|
|
using BMA.EHR.Domain.Models.Organizations;
|
|
using BMA.EHR.Domain.Models.Retirement;
|
|
using Microsoft.AspNetCore.Hosting;
|
|
using Microsoft.AspNetCore.Http;
|
|
using Microsoft.AspNetCore.Mvc;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.Extensions.Configuration;
|
|
using Newtonsoft.Json;
|
|
|
|
namespace BMA.EHR.Application.Repositories.Reports
|
|
{
|
|
public class RetireReportRepository
|
|
{
|
|
#region " Fields "
|
|
|
|
private readonly IApplicationDBContext _dbContext;
|
|
private readonly IWebHostEnvironment _hostingEnvironment;
|
|
private readonly MinIOService _documentService;
|
|
private readonly OrganizationCommonRepository _organizationCommonRepository;
|
|
private readonly IConfiguration _configuration;
|
|
|
|
#endregion
|
|
|
|
#region " Constructor and Destructor "
|
|
|
|
public RetireReportRepository(IApplicationDBContext dbContext,
|
|
MinIOService documentService,
|
|
OrganizationCommonRepository organizationCommonRepository,
|
|
IWebHostEnvironment hostEnvironment,
|
|
IConfiguration configuration)
|
|
{
|
|
_dbContext = dbContext;
|
|
_hostingEnvironment = hostEnvironment;
|
|
_organizationCommonRepository = organizationCommonRepository;
|
|
_documentService = documentService;
|
|
_configuration = configuration;
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region " Methods "
|
|
|
|
//public async Task<List<RetirementPeriod>> GetListRetirePeriodAsync(Guid Id)
|
|
//{
|
|
// try
|
|
// {
|
|
// // 1. query
|
|
// //var data = await _dbContext.Set<RetirementPeriod>()
|
|
// // .Include(x => x.RetirementProfiles)
|
|
// // .ThenInclude(x => x.Profile)
|
|
// // .ToListAsync();
|
|
|
|
// // 2. data not found throw exception
|
|
|
|
// // 3. Load Report File
|
|
|
|
// //return data;
|
|
// }
|
|
// catch
|
|
// {
|
|
// throw;
|
|
// }
|
|
//}
|
|
|
|
#region รายงานประกาศเกษียณ
|
|
public async Task<dynamic> GetProfileRetirementdAsync(Guid retireId, string token)
|
|
{
|
|
var retire = await _dbContext.Set<RetirementPeriod>()
|
|
.Include(x => x.RetirementProfiles)
|
|
.FirstOrDefaultAsync(x => x.Id == retireId);
|
|
// var retires = new List<dynamic>();
|
|
var apiUrl = $"{_configuration["API"]}/org/root/search/sort";
|
|
dynamic rootOrder = new List<string>();
|
|
dynamic child1Order = new List<string>();
|
|
dynamic child2Order = new List<string>();
|
|
dynamic child3Order = new List<string>();
|
|
dynamic child4Order = new List<string>();
|
|
dynamic posTypeNameOrder = new List<string>();
|
|
dynamic posLevelNameOrder = new List<string>();
|
|
dynamic hospital = new List<string>();
|
|
using (var client = new HttpClient())
|
|
{
|
|
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token.Replace("Bearer ", ""));
|
|
client.DefaultRequestHeaders.Add("api-key", _configuration["API_KEY"]);
|
|
var _req = new HttpRequestMessage(HttpMethod.Get, apiUrl);
|
|
var _res = await client.SendAsync(_req);
|
|
var _result = await _res.Content.ReadAsStringAsync();
|
|
|
|
var org = JsonConvert.DeserializeObject<dynamic>(_result);
|
|
|
|
if (org != null && org.result != null)
|
|
{
|
|
rootOrder = org.result.root;
|
|
child1Order = org.result.child1;
|
|
child2Order = org.result.child2;
|
|
child3Order = org.result.child3;
|
|
child4Order = org.result.child4;
|
|
posTypeNameOrder = org.result.posTypeNameOrder;
|
|
posLevelNameOrder = org.result.posLevelNameOrder;
|
|
hospital = org.result.hospital;
|
|
}
|
|
}
|
|
if (retire == null)
|
|
{
|
|
var retireHistorys = await _dbContext.Set<RetirementPeriodHistory>().AsQueryable()
|
|
.FirstOrDefaultAsync(x => x.Id == retireId);
|
|
if (retireHistorys == null)
|
|
return null;
|
|
|
|
//var profile_retireHistory = await _dbContext.Set<RetirementProfile>()
|
|
// .Where(x => x.RetirementPeriod == retire)
|
|
// .OrderBy(x => x.Order)
|
|
// .Select(x => new
|
|
// {
|
|
// order = x.Order,
|
|
// id = x.Id,
|
|
// reason = x.Reason,
|
|
// remove = x.Remove,
|
|
// profileId = x.Profile.Id,
|
|
// citizenId = x.Profile.CitizenId,
|
|
// prefix = x.Profile.Prefix == null ? string.Empty : x.Profile.Prefix.Name,
|
|
// fullName = $"{x.Profile.FirstName} {x.Profile.LastName}",
|
|
// organizationOrganization = x.Profile.OrganizationOrganization,
|
|
// oc = x.Profile.Oc,
|
|
// position = x.Profile.Position == null ? string.Empty : x.Profile.Position.Name,
|
|
// positionType = x.Profile.PositionType == null ? string.Empty : x.Profile.PositionType.Name,
|
|
// positionExecutive = x.Profile.PositionExecutive,
|
|
// posNo = x.Profile.PosNo == null ? string.Empty : x.Profile.PosNo.Name,
|
|
// positionEmployeePosition = x.Profile.PositionEmployeePosition,
|
|
// positionEmployeeLevel = x.Profile.PositionEmployeeLevel,
|
|
// positionEmployeeGroup = x.Profile.PositionEmployeeGroup,
|
|
// posNoEmployee = x.Profile.PosNoEmployee,
|
|
// })
|
|
// .ToListAsync();
|
|
|
|
//return new { retireHistorys.Detail, retireHistorys.Id, retireHistorys.CreatedAt, Year = retireHistorys.Year.ToThaiYear().ToString().ToThaiNumber(), retireHistorys.Round, retireHistorys.Type, retireHistorys.TypeReport, Total = retireHistorys.Total.ToString().ToThaiNumber(), profile = profile_retireHistory };
|
|
using (var client = new HttpClient())
|
|
{
|
|
var url = await _documentService.ImagesPathByName($"{retireHistorys.ProfileFile}.json");
|
|
var responseTask = client.GetAsync(url);
|
|
var results = responseTask.Result;
|
|
var json = results.Content.ReadAsStringAsync().Result;
|
|
List<ProfileJsonRequest> profiles = JsonConvert.DeserializeObject<List<ProfileJsonRequest>>(json);
|
|
if (retireHistorys.TypeReport != null)
|
|
{
|
|
retireHistorys.Total = profiles.Where(x => x.remove == retireHistorys.TypeReport).Count();
|
|
profiles = profiles.Where(x => x.remove == retireHistorys.TypeReport).OrderBy(x => x.order).ToList();
|
|
}
|
|
else
|
|
{
|
|
profiles = profiles.OrderBy(x => x.order).ToList();
|
|
}
|
|
var mapProfiles = new List<ProfileRetireJsonRequest>();
|
|
// string previousRoot = null;
|
|
// string previousPosTypeName = null;
|
|
// string previousPosLevelName = null;
|
|
if (profiles.Count > 0)
|
|
{
|
|
mapProfiles = profiles
|
|
// .OrderBy(x => rootOrder.ToObject<List<string>>().IndexOf(x.root))
|
|
// .ThenBy(x => posTypeNameOrder.ToObject<List<string>>().IndexOf(x.posTypeName ?? ""))
|
|
// .ThenBy(x => posLevelNameOrder.ToObject<List<string>>().IndexOf(x.posLevelName ?? ""))
|
|
.Select((profile, index) =>
|
|
{
|
|
// bool isDuplicateRoot = profile.root == previousRoot;
|
|
// previousRoot = profile.root;
|
|
// bool isDuplicatePosType = profile.posTypeName == previousPosTypeName;
|
|
// previousPosTypeName = profile.posTypeName;
|
|
// bool isDuplicatePosLevel = profile.posLevelName == previousPosLevelName;
|
|
// previousPosLevelName = profile.posLevelName;
|
|
return new ProfileRetireJsonRequest
|
|
{
|
|
order = retireHistorys.TypeReport == null ? (index + 1).ToString().ToThaiNumber() : $"{(index + 1).ToString().ToThaiNumber()}. ลำดับที่ {(profile.order).ToString().ToThaiNumber()}",
|
|
fullName = $"{profile.prefix}{profile.firstName} {profile.lastName}",
|
|
root = "",
|
|
child = (profile.posExecutiveName == null ? "" : profile.posExecutiveName + "\n") +
|
|
(profile.child4 == null ? "" : profile.child4 + "\n") +
|
|
(profile.child3 == null ? "" : profile.child3 + "\n") +
|
|
(profile.child2 == null ? "" : profile.child2 + "\n") +
|
|
(profile.child1 == null ? "" : profile.child1 + "\n") +
|
|
(profile.reason == null ? "" : profile.reason),
|
|
position = profile.position != "" && profile.position != null ? profile.position : "-",
|
|
posNo = profile.posNo != "" && profile.posNo != null ? profile.posNo?.ToThaiNumber() : "-",
|
|
reason = profile.reason != "" && profile.reason != null ? profile.reason : "-",
|
|
};
|
|
}).ToList();
|
|
}
|
|
string SignDate = retireHistorys.SignDate != null ? DateTime.Parse(retireHistorys.SignDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "-";
|
|
return new { SignDate, retireHistorys.Detail, retireHistorys.Id, retireHistorys.CreatedAt, Year = retireHistorys.Year.ToThaiYear().ToString().ToThaiNumber(), retireHistorys.Round, retireHistorys.Type, retireHistorys.TypeReport, Total = retireHistorys.Total.ToString().ToThaiNumber(), profiles = mapProfiles };
|
|
}
|
|
}
|
|
else
|
|
{
|
|
var profile_retire = await _dbContext.Set<RetirementProfile>()
|
|
.Include(x => x.RetirementPeriod)
|
|
.Where(x => x.RetirementPeriod == retire && (retire.TypeReport == null || retire.TypeReport == x.Remove))
|
|
.OrderBy(x => x.Order)
|
|
.Select(x => new
|
|
{
|
|
order = x.Order,
|
|
id = x.Id,
|
|
reason = x.Reason,
|
|
remove = x.Remove,
|
|
profileId = x.profileId,
|
|
prefix = x.prefix,
|
|
firstName = x.firstName,
|
|
lastName = x.lastName,
|
|
citizenId = x.citizenId,
|
|
root = x.root,
|
|
rootId = x.rootId,
|
|
rootShortName = x.rootShortName,
|
|
child1 = x.child1,
|
|
child1Id = x.child1Id,
|
|
child1ShortName = x.child1ShortName,
|
|
child2 = x.child2,
|
|
child2Id = x.child2Id,
|
|
child2ShortName = x.child2ShortName,
|
|
child3 = x.child3,
|
|
child3Id = x.child3Id,
|
|
child3ShortName = x.child3ShortName,
|
|
child4 = x.child4,
|
|
child4Id = x.child4Id,
|
|
child4ShortName = x.child4ShortName,
|
|
posMasterNo = x.posMasterNo,
|
|
position = x.position,
|
|
posTypeId = x.posTypeId,
|
|
posTypeName = x.posTypeName,
|
|
posTypeRank = x.posTypeRank,
|
|
posLevelId = x.posLevelId,
|
|
posLevelName = x.posLevelName,
|
|
posLevelRank = x.posLevelRank,
|
|
posExecutiveId = x.posExecutiveId,
|
|
posExecutiveName = x.posExecutiveName,
|
|
posNo = x.posNo,
|
|
})
|
|
.ToListAsync();
|
|
// foreach (var r in profile_retire)
|
|
// {
|
|
// var data = new ProfileJsonRequest
|
|
// {
|
|
// order = r.order,
|
|
// id = r.id,
|
|
// reason = r.reason,
|
|
// remove = r.remove,
|
|
// profileId = r.profileId,
|
|
// citizenId = r.citizenId,
|
|
// prefix = r.prefix,
|
|
// fullName = r.fullName,
|
|
// organizationOrganization = r.organizationOrganization,
|
|
// oc = r.ocId == null ? null : _organizationCommonRepository.GetOrganizationNameFullPath(r.ocId.Value),
|
|
// position = r.position,
|
|
// positionType = r.positionType,
|
|
// positionExecutive = r.positionExecutive,
|
|
// posNo = r.posNo,
|
|
// positionEmployeePosition = r.positionEmployeePosition,
|
|
// positionEmployeeLevel = r.positionEmployeeLevel,
|
|
// positionEmployeeGroup = r.positionEmployeeGroup,
|
|
// posNoEmployee = r.posNoEmployee,
|
|
// };
|
|
// retires.Add(data);
|
|
// }
|
|
var mapProfiles = new List<ProfileRetireJsonRequest>();
|
|
string previousRoot = null;
|
|
string previousChild1 = null;
|
|
string previousPosTypeName = null;
|
|
string previousPosLevelName = null;
|
|
if (profile_retire.Count > 0)
|
|
{
|
|
if (retire.TypeReport == null)
|
|
{
|
|
profile_retire = profile_retire
|
|
.OrderBy(x => string.IsNullOrEmpty(x.root) ? int.MaxValue : rootOrder.ToObject<List<string>>().IndexOf(x.root))
|
|
.ThenBy(x => child1Order.ToObject<List<string>>().IndexOf(x.child1 ?? ""))
|
|
.ThenBy(x => child2Order.ToObject<List<string>>().IndexOf(x.child2 ?? ""))
|
|
.ThenBy(x => child3Order.ToObject<List<string>>().IndexOf(x.child3 ?? ""))
|
|
.ThenBy(x => child4Order.ToObject<List<string>>().IndexOf(x.child4 ?? ""))
|
|
.ThenBy(x => posTypeNameOrder.ToObject<List<string>>().IndexOf(x.posTypeName ?? ""))
|
|
.ThenBy(x => posLevelNameOrder.ToObject<List<string>>().IndexOf(x.posLevelName ?? ""))
|
|
.ThenBy(x => x.posNo).ToList();
|
|
}
|
|
mapProfiles = profile_retire.Select((profile, index) =>
|
|
{
|
|
bool isDuplicateRoot = profile.root == previousRoot;
|
|
previousRoot = profile.root;
|
|
if (isDuplicateRoot == false)
|
|
{
|
|
previousChild1 = null;
|
|
previousPosTypeName = null;
|
|
previousPosLevelName = null;
|
|
}
|
|
bool isDuplicateHospital = profile.child1 == previousChild1;
|
|
previousChild1 = profile.child1;
|
|
if (isDuplicateHospital == false)
|
|
{
|
|
previousPosTypeName = null;
|
|
previousPosLevelName = null;
|
|
}
|
|
bool isDuplicatePosType = profile.posTypeName == previousPosTypeName;
|
|
previousPosTypeName = profile.posTypeName;
|
|
bool isDuplicatePosLevel = profile.posLevelName == previousPosLevelName;
|
|
previousPosLevelName = profile.posLevelName;
|
|
return new ProfileRetireJsonRequest
|
|
{
|
|
order = retire.TypeReport == null ? (index + 1).ToString().ToThaiNumber() : $"{(index + 1).ToString().ToThaiNumber()}. ลำดับที่ {(profile.order).ToString().ToThaiNumber()}",
|
|
fullName = $"{profile.prefix}{profile.firstName} {profile.lastName}",
|
|
root = (isDuplicateRoot ? "" : profile.root + "\n") +
|
|
(isDuplicateHospital || !hospital.ToObject<List<string>>().Contains(profile.child1) ? "" : profile.child1 + "\n") +
|
|
(isDuplicatePosType ? "" : $"ตำแหน่งประเภท{profile.posTypeName}" + "\n") +
|
|
(isDuplicatePosLevel ? "" : $"ระดับ{profile.posLevelName}"),
|
|
child = (profile.posExecutiveName == null ? "" : profile.posExecutiveName + "\n") +
|
|
(profile.child4 == null ? "" : profile.child4 + "\n") +
|
|
(profile.child3 == null ? "" : profile.child3 + "\n") +
|
|
(profile.child2 == null ? "" : profile.child2 + "\n") +
|
|
(profile.child1 == null || hospital.ToObject<List<string>>().Contains(profile.child1) ? "" : profile.child1 + "\n") +
|
|
(profile.reason == null ? "" : profile.reason),
|
|
position = profile.position != "" && profile.position != null ? profile.position : "-",
|
|
posNo = profile.posNo != "" && profile.posNo != null ? profile.posNo?.ToThaiNumber() : "-",
|
|
reason = profile.reason != "" && profile.reason != null ? profile.reason : "-",
|
|
};
|
|
}).ToList();
|
|
}
|
|
string SignDate = retire.SignDate != null ? DateTime.Parse(retire.SignDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "-";
|
|
return new { SignDate, retire.Detail, retire.Id, retire.CreatedAt, Year = retire.Year.ToThaiYear().ToString().ToThaiNumber(), retire.Round, retire.Type, retire.TypeReport, Total = profile_retire.Count.ToString().ToThaiNumber(), profiles = mapProfiles };
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region รายงานบันทึกการถึงแก่กรรม
|
|
public async Task<dynamic> GetRetirementDeceasedAsync(Guid id)
|
|
{
|
|
var data = await _dbContext.Set<RetirementDeceased>().AsQueryable()
|
|
.Where(x => x.Id == id)
|
|
.Select(p => new
|
|
{
|
|
p.Id,
|
|
p.prefix,
|
|
p.profileId,
|
|
p.firstName,
|
|
p.lastName,
|
|
p.root,
|
|
p.rootShortName,
|
|
p.child1,
|
|
p.child1ShortName,
|
|
p.child2,
|
|
p.child2ShortName,
|
|
p.child3,
|
|
p.child3ShortName,
|
|
p.child4,
|
|
p.child4ShortName,
|
|
p.posMasterNo,
|
|
p.posLevelName,
|
|
p.posTypeName,
|
|
p.position,
|
|
p.Number,
|
|
p.Date,
|
|
p.Location,
|
|
p.Reason,
|
|
})
|
|
.FirstOrDefaultAsync();
|
|
|
|
if (data == null)
|
|
return null;
|
|
|
|
// string Prefix = string.IsNullOrEmpty(data.Prefix.ToString()) ? string.Empty : data.Prefix.ToString();
|
|
// string FirstName = string.IsNullOrEmpty(data.FirstName.ToString()) ? string.Empty : data.FirstName.ToString();
|
|
// string LastName = string.IsNullOrEmpty(data.LastName.ToString()) ? string.Empty : data.LastName.ToString();
|
|
// string FullName = $"{Prefix} {FirstName} {LastName}";
|
|
string Date = string.IsNullOrEmpty(data.Date.ToString()) ? "-" : DateTime.Parse(data.Date.ToString()).ToThaiFullDate().ToString().ToThaiNumber();
|
|
string CurrentDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).ToThaiFullDate().ToString().ToThaiNumber();
|
|
return new
|
|
{
|
|
FullName = $"{data.prefix} {data.firstName} {data.lastName}",
|
|
Date,
|
|
CurrentDate,
|
|
data.profileId,
|
|
data.prefix,
|
|
data.firstName,
|
|
data.lastName,
|
|
data.root,
|
|
data.rootShortName,
|
|
data.child1,
|
|
data.child1ShortName,
|
|
data.child2,
|
|
data.child2ShortName,
|
|
data.child3,
|
|
data.child3ShortName,
|
|
data.child4,
|
|
data.child4ShortName,
|
|
data.posMasterNo,
|
|
data.posLevelName,
|
|
data.posTypeName,
|
|
Number = data.Number != null ? data.Number.ToThaiNumber() : "-",
|
|
Location = data.Location != null ? data.Location.ToThaiNumber() : "-",
|
|
data.Reason,
|
|
Position = data.position,
|
|
};
|
|
}
|
|
#endregion
|
|
|
|
#region หัวกระดาษหนังสือเวียน
|
|
public async Task<dynamic> GetHeadRetirementDeceasedAsync(Guid id)
|
|
{
|
|
var data = await _dbContext.Set<RetirementDeceased>().AsQueryable()
|
|
// .Include(x => x.Profile)
|
|
.Where(x => x.Id == id)
|
|
.FirstOrDefaultAsync();
|
|
var oc = "";
|
|
if (data == null)
|
|
return new
|
|
{
|
|
Oc = oc,
|
|
Number = $"กท /",
|
|
Date = "",
|
|
Subject = "ข้าราชการถึงแก่กรรม",
|
|
Send = "หัวหน้าสำนักงาน ก.ก.",
|
|
};
|
|
|
|
// if (data.Profile.OcId != null)
|
|
// {
|
|
// var organization = await _dbContext.Set<OrganizationEntity>().AsQueryable()
|
|
// .Where(x => x.Id == data.Profile.OcId)
|
|
// .FirstOrDefaultAsync();
|
|
// if (organization != null)
|
|
// {
|
|
// var organizationAgency = await _dbContext.Set<OrganizationEntity>().AsQueryable()
|
|
// .Where(x => x.Id == organization.OrganizationAgencyId)
|
|
// .FirstOrDefaultAsync();
|
|
// if (organizationAgency != null)
|
|
// {
|
|
// var agency = await _dbContext.Set<OrganizationEntity>().AsQueryable()
|
|
// .Where(x => x.Id == organizationAgency.Id)
|
|
// .FirstOrDefaultAsync();
|
|
// if (agency != null)
|
|
// {
|
|
// oc = agency.OrganizationOrganization?.Name;
|
|
// }
|
|
// }
|
|
// }
|
|
// }
|
|
|
|
return new
|
|
{
|
|
Oc = oc,
|
|
Number = $"กท /{(data.CreatedAt.Year.ToThaiYear()).ToString().ToThaiNumber()}",
|
|
Date = data.CreatedAt.ToThaiFullDate2().ToString().ToThaiNumber(),
|
|
Subject = "ข้าราชการถึงแก่กรรม",
|
|
Send = "หัวหน้าสำนักงาน ก.ก.",
|
|
};
|
|
}
|
|
#endregion
|
|
|
|
#region บันทึกหนังสือเวียน
|
|
public async Task UploadFileRetirementDeceasedAsync(Guid id, Domain.Models.Documents.Document file)
|
|
{
|
|
var data = await _dbContext.Set<RetirementDeceased>().AsQueryable()
|
|
// .Include(x => x.Profile)
|
|
.Where(x => x.Id == id)
|
|
.FirstOrDefaultAsync();
|
|
if (data != null)
|
|
data.DocumentForward = file;
|
|
await _dbContext.SaveChangesAsync();
|
|
}
|
|
#endregion
|
|
|
|
#region แบบฟอร์มหนังสือขอลาออกจากราชการ
|
|
public async Task<object> GetResignByUser(Guid id)
|
|
{
|
|
var data = await _dbContext.Set<RetirementResign>().AsQueryable()
|
|
.Where(x => x.Id == id)
|
|
.Select(p => new
|
|
{
|
|
p.Id,
|
|
p.prefix,
|
|
p.firstName,
|
|
p.lastName,
|
|
p.profileId,
|
|
p.Location,
|
|
p.SendDate,
|
|
p.ActiveDate,
|
|
p.Reason,
|
|
p.ReasonResign,
|
|
p.Remark,
|
|
p.Status,
|
|
salary = p.AmountOld,
|
|
p.ApproveReason,
|
|
p.RejectReason,
|
|
p.IsActive,
|
|
p.CreatedAt,
|
|
p.PositionTypeOld,
|
|
p.PositionLevelOld,
|
|
p.PositionNumberOld,
|
|
p.OrganizationPositionOld,
|
|
p.OligarchReject,
|
|
p.OligarchApproveReason,
|
|
p.OligarchRejectReason,
|
|
p.OligarchRejectDate,
|
|
p.CommanderReject,
|
|
p.CommanderApproveReason,
|
|
p.CommanderRejectReason,
|
|
p.CommanderRejectDate,
|
|
p.RemarkHorizontal,
|
|
Type = "OFFICER"
|
|
})
|
|
.FirstOrDefaultAsync();
|
|
if (data == null)
|
|
data = await _dbContext.Set<RetirementResignEmployee>().AsQueryable()
|
|
.Where(x => x.Id == id)
|
|
.Select(p => new
|
|
{
|
|
p.Id,
|
|
p.prefix,
|
|
p.firstName,
|
|
p.lastName,
|
|
p.profileId,
|
|
p.Location,
|
|
p.SendDate,
|
|
p.ActiveDate,
|
|
p.Reason,
|
|
p.ReasonResign,
|
|
p.Remark,
|
|
p.Status,
|
|
salary = p.AmountOld,
|
|
p.ApproveReason,
|
|
p.RejectReason,
|
|
p.IsActive,
|
|
p.CreatedAt,
|
|
p.PositionTypeOld,
|
|
p.PositionLevelOld,
|
|
p.PositionNumberOld,
|
|
p.OrganizationPositionOld,
|
|
p.OligarchReject,
|
|
p.OligarchApproveReason,
|
|
p.OligarchRejectReason,
|
|
p.OligarchRejectDate,
|
|
p.CommanderReject,
|
|
p.CommanderApproveReason,
|
|
p.CommanderRejectReason,
|
|
p.CommanderRejectDate,
|
|
p.RemarkHorizontal,
|
|
Type = "EMPLOYEE",
|
|
})
|
|
.FirstOrDefaultAsync();
|
|
if (data == null)
|
|
return null;
|
|
|
|
var approverPositionExecutiveName = "...............";
|
|
var approverStatus = "☐ อนุญาต";
|
|
var approverRejectStatus = "☐ ยับยั้งการลาออกไว้จนถึงวันที่...................";
|
|
var approver = "...................";
|
|
var approverPosition = "...................";
|
|
|
|
var diffDate = "☐ ไม่น้อยกว่า ๓๐ วัน ☐ น้อยกว่า ๓๐ วัน";
|
|
if (data.SendDate.HasValue && data.ActiveDate.HasValue)
|
|
{
|
|
var time = data.ActiveDate.Value - data.SendDate.Value;
|
|
var day = time.TotalDays;
|
|
if (day < 30)
|
|
{
|
|
diffDate = "☐ ไม่น้อยกว่า ๓๐ วัน ☑ น้อยกว่า ๓๐ วัน";
|
|
}
|
|
else
|
|
{
|
|
diffDate = "☑ ไม่น้อยกว่า ๓๐ วัน ☐ น้อยกว่า ๓๐ วัน";
|
|
}
|
|
}
|
|
|
|
var commanderDateUpdate = "วันที่...................";
|
|
var commanderStatus = "☐ อนุญาต ตั้งแต่วันที่...................";
|
|
var commanderCommentApprove = "...................";
|
|
var commanderRejectStatus = "☐ ยับยั้งการลาออกไว้จนถึงวันที่...................";
|
|
var commanderCommentReject = "...................";
|
|
var commander = "...................";
|
|
var commanderPosition = "...................";
|
|
|
|
if (data.Type == "OFFICER")
|
|
{
|
|
var Approver = _dbContext.Set<RetirementResignApprover>()
|
|
.Where(x => x.RetirementResign.Id == data.Id && x.ApproveType == "APPROVER")
|
|
.ToList();
|
|
var Commander = _dbContext.Set<RetirementResignApprover>()
|
|
.Where(x => x.RetirementResign.Id == data.Id && x.ApproveType == "COMMANDER")
|
|
.OrderByDescending(x => x.Seq)
|
|
.ToList();
|
|
if (Approver.Count > 0)
|
|
{
|
|
approverPositionExecutiveName = Approver[0].PositionExecutiveName;
|
|
approverStatus = Approver[0].ApproveStatus == "APPROVE" ? "☑ อนุญาต" : approverStatus;
|
|
approverRejectStatus = Approver[0].ApproveStatus == "REJECT"
|
|
? $"☑ ยับยั้งการลาออกไว้จนถึง{(Approver[0].RejectDate != null ? DateTime.Parse(Approver[0].RejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: approverRejectStatus;
|
|
approver = $"{Approver[0].Prefix}{Approver[0].FirstName} {Approver[0].LastName}";
|
|
approverPosition = Approver[0].PositionName;
|
|
}
|
|
if (Commander.Count > 0)
|
|
{
|
|
commanderDateUpdate = Commander.Count > 1
|
|
? Commander[1].LastUpdatedAt != null
|
|
? DateTime.Parse(Commander[1].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber()
|
|
: commanderDateUpdate
|
|
: Commander[0].LastUpdatedAt != null
|
|
? DateTime.Parse(Commander[0].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber()
|
|
: commanderDateUpdate;
|
|
commanderStatus = Commander[0].ApproveStatus == "APPROVE"
|
|
? $"☑ อนุญาต ตั้งแต่{(Commander[0].LastUpdatedAt != null ? DateTime.Parse(Commander[0].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: commanderStatus;
|
|
commanderCommentApprove = Commander[0].ApproveStatus == "APPROVE"
|
|
? !string.IsNullOrWhiteSpace(Commander[0].Comment) ? Commander[0].Comment : commanderCommentApprove
|
|
: commanderCommentApprove;
|
|
commanderRejectStatus = Commander[0].ApproveStatus == "REJECT"
|
|
? $"☑ ยับยั้งการลาออกไว้จนถึง{(Commander[0].RejectDate != null ? DateTime.Parse(Commander[0].RejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: approverRejectStatus;
|
|
commanderCommentReject = Commander[0].ApproveStatus == "REJECT"
|
|
? !string.IsNullOrWhiteSpace(Commander[0].Comment) ? Commander[0].Comment : commanderCommentReject
|
|
: commanderCommentReject;
|
|
commander = $"{Commander[0].Prefix}{Commander[0].FirstName} {Commander[0].LastName}";
|
|
commanderPosition = Commander[0].PositionName;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
var EmpApproves = _dbContext.Set<RetirementResignEmployeeApprover>()
|
|
.Where(x => x.RetirementResignEmployee.Id == data.Id && x.ApproveType == "APPROVER")
|
|
.ToList();
|
|
var EmpCommander = _dbContext.Set<RetirementResignEmployeeApprover>()
|
|
.Where(x => x.RetirementResignEmployee.Id == data.Id && x.ApproveType == "COMMANDER")
|
|
.OrderByDescending(x => x.Seq)
|
|
.ToList();
|
|
if (EmpApproves.Count > 0)
|
|
{
|
|
approverPositionExecutiveName = EmpApproves[0].PositionExecutiveName;
|
|
approverStatus = EmpApproves[0].ApproveStatus == "APPROVE" ? "☑ อนุญาต" : approverStatus;
|
|
approverRejectStatus = EmpApproves[0].ApproveStatus == "REJECT"
|
|
? $"☑ ยับยั้งการลาออกไว้จนถึง{(EmpApproves[0].RejectDate != null ? DateTime.Parse(EmpApproves[0].RejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: approverRejectStatus;
|
|
approver = $"{EmpApproves[0].Prefix}{EmpApproves[0].FirstName} {EmpApproves[0].LastName}";
|
|
approverPosition = EmpApproves[0].PositionName;
|
|
}
|
|
if (EmpCommander.Count > 0)
|
|
{
|
|
commanderDateUpdate = EmpCommander.Count > 1
|
|
? EmpCommander[1].LastUpdatedAt != null
|
|
? DateTime.Parse(EmpCommander[1].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber()
|
|
: commanderDateUpdate
|
|
: EmpCommander[0].LastUpdatedAt != null
|
|
? DateTime.Parse(EmpCommander[0].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber()
|
|
: commanderDateUpdate;
|
|
commanderStatus = EmpCommander[0].ApproveStatus == "APPROVE"
|
|
? $"☑ อนุญาต ตั้งแต่{(EmpCommander[0].LastUpdatedAt != null ? DateTime.Parse(EmpCommander[0].LastUpdatedAt.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: commanderStatus;
|
|
commanderCommentApprove = EmpCommander[0].ApproveStatus == "APPROVE"
|
|
? !string.IsNullOrWhiteSpace(EmpCommander[0].Comment) ? EmpCommander[0].Comment : commanderCommentApprove
|
|
: commanderCommentApprove;
|
|
commanderRejectStatus = EmpCommander[0].ApproveStatus == "REJECT"
|
|
? $"☑ ยับยั้งการลาออกไว้จนถึง{(EmpCommander[0].RejectDate != null ? DateTime.Parse(EmpCommander[0].RejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber() : "วันที่...................")}"
|
|
: approverRejectStatus;
|
|
commanderCommentReject = EmpCommander[0].ApproveStatus == "REJECT"
|
|
? !string.IsNullOrWhiteSpace(EmpCommander[0].Comment) ? EmpCommander[0].Comment : commanderCommentReject
|
|
: commanderCommentReject;
|
|
commander = $"{EmpCommander[0].Prefix}{EmpCommander[0].FirstName} {EmpCommander[0].LastName}";
|
|
commanderPosition = EmpCommander[0].PositionName;
|
|
}
|
|
}
|
|
|
|
var _data = new
|
|
{
|
|
data.Id,
|
|
data.profileId,
|
|
data.prefix,
|
|
data.firstName,
|
|
data.lastName,
|
|
Location = string.IsNullOrEmpty(data.Location) ? string.Empty : data.Location.ToThaiNumber(),
|
|
FullName = $"{data.prefix}{data.firstName} {data.lastName}",
|
|
SendDate = string.IsNullOrEmpty(data.SendDate.ToString()) ? string.Empty : DateTime.Parse(data.SendDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber(),
|
|
ActiveDate = string.IsNullOrEmpty(data.ActiveDate.ToString()) ? string.Empty : DateTime.Parse(data.ActiveDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber(),
|
|
data.Reason,
|
|
data.ReasonResign,
|
|
data.Remark,
|
|
ReasonRemark = data.Reason == "OTHER" ? string.IsNullOrEmpty(data.Remark) ? data.ReasonResign : $"{data.ReasonResign}({data.Remark})" : data.ReasonResign,
|
|
data.Status,
|
|
data.salary,
|
|
data.PositionTypeOld,
|
|
data.PositionLevelOld,
|
|
data.PositionNumberOld,
|
|
data.OrganizationPositionOld,
|
|
data.ApproveReason,
|
|
data.RejectReason,
|
|
data.IsActive,
|
|
data.CreatedAt,
|
|
data.OligarchReject,
|
|
data.OligarchApproveReason,
|
|
data.OligarchRejectReason,
|
|
OligarchRejectDate = string.IsNullOrEmpty(data.OligarchRejectDate.ToString()) ? string.Empty : DateTime.Parse(data.OligarchRejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber(),
|
|
data.CommanderReject,
|
|
data.CommanderApproveReason,
|
|
data.CommanderRejectReason,
|
|
CommanderRejectDate = string.IsNullOrEmpty(data.CommanderRejectDate.ToString()) ? string.Empty : DateTime.Parse(data.CommanderRejectDate.ToString()).ToThaiFullDate().ToString().ToThaiNumber(),
|
|
data.RemarkHorizontal,
|
|
dear = approverPositionExecutiveName,
|
|
approverStatus,
|
|
approverRejectStatus,
|
|
approver,
|
|
approverPosition,
|
|
diffDate,
|
|
commanderDateUpdate,
|
|
commanderStatus,
|
|
commanderCommentApprove,
|
|
commanderRejectStatus,
|
|
commanderCommentReject,
|
|
commander,
|
|
commanderPosition
|
|
};
|
|
|
|
return _data;
|
|
}
|
|
#endregion
|
|
|
|
#endregion
|
|
}
|
|
}
|