333 lines
23 KiB
C#
333 lines
23 KiB
C#
using BMA.EHR.Application.Repositories;
|
|
using BMA.EHR.Application.Repositories.MessageQueue;
|
|
using BMA.EHR.Application.Responses;
|
|
using BMA.EHR.Application.Responses.Profiles;
|
|
using BMA.EHR.Discipline.Service.Requests;
|
|
using BMA.EHR.Domain.Common;
|
|
using BMA.EHR.Domain.Models.Discipline;
|
|
using BMA.EHR.Domain.Shared;
|
|
using BMA.EHR.Domain.Extensions;
|
|
using BMA.EHR.Infrastructure.Persistence;
|
|
// using BMA.EHR.Placement.Service.Requests;
|
|
using Microsoft.AspNetCore.Authorization;
|
|
using Microsoft.AspNetCore.Mvc;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Newtonsoft.Json.Linq;
|
|
using Newtonsoft.Json;
|
|
using Swashbuckle.AspNetCore.Annotations;
|
|
using System.Security.Claims;
|
|
|
|
namespace BMA.EHR.DisciplineSuspend.Service.Controllers
|
|
{
|
|
[Route("api/v{version:apiVersion}/discipline/report")]
|
|
[ApiVersion("1.0")]
|
|
[ApiController]
|
|
[Produces("application/json")]
|
|
[Authorize]
|
|
[SwaggerTag("ระบบวินัยรายงาน")]
|
|
public class DisciplineReportController : BaseController
|
|
{
|
|
private readonly DisciplineDbContext _context;
|
|
private readonly MinIODisciplineService _documentService;
|
|
private readonly IHttpContextAccessor _httpContextAccessor;
|
|
private readonly PermissionRepository _permission;
|
|
private readonly UserProfileRepository _userProfileRepository;
|
|
|
|
public DisciplineReportController(DisciplineDbContext context,
|
|
MinIODisciplineService documentService,
|
|
IHttpContextAccessor httpContextAccessor,
|
|
PermissionRepository permission,
|
|
UserProfileRepository userProfileRepository)
|
|
{
|
|
// _repository = repository;
|
|
_context = context;
|
|
_documentService = documentService;
|
|
_httpContextAccessor = httpContextAccessor;
|
|
_permission = permission;
|
|
_userProfileRepository = userProfileRepository;
|
|
}
|
|
|
|
#region " Properties "
|
|
|
|
private string? UserId => _httpContextAccessor?.HttpContext?.User?.FindFirst(ClaimTypes.NameIdentifier)?.Value;
|
|
|
|
private string? FullName => _httpContextAccessor?.HttpContext?.User?.FindFirst("name")?.Value;
|
|
private string? AccessToken => _httpContextAccessor?.HttpContext?.Request.Headers["Authorization"];
|
|
|
|
|
|
#endregion
|
|
|
|
/// <summary>
|
|
/// รายชื่อออกคำสั่งลงโทษ
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
/// <response code="200"></response>
|
|
/// <response code="400">ค่าตัวแปรที่ส่งมาไม่ถูกต้อง</response>
|
|
/// <response code="401">ไม่ได้ Login เข้าระบบ</response>
|
|
/// <response code="500">เมื่อเกิดข้อผิดพลาดในการทำงาน</response>
|
|
[HttpPost("{type}")]
|
|
public async Task<ActionResult<ResponseObject>> GetReportDiscipline([FromBody] DisciplineReportRequest req, string type)
|
|
{
|
|
var getPermission = await _permission.GetPermissionAPIAsync("LIST", "SYS_DISCIPLINE_REPORT");
|
|
var jsonData = JsonConvert.DeserializeObject<JObject>(getPermission);
|
|
if (jsonData["status"]?.ToString() != "200")
|
|
{
|
|
return Error(jsonData["message"]?.ToString(), StatusCodes.Status403Forbidden);
|
|
}
|
|
|
|
var data_search1 = await _context.DisciplineComplaints
|
|
.Include(x => x.DisciplineComplaint_Profiles)
|
|
.Where(x => req.status.Trim().ToUpper() == "ALL" ? true : (x.Status != null && x.Status.Contains(req.status.Trim().ToUpper())))
|
|
.Where(x => req.offenseDetail.Trim().ToUpper() == "ALL" ? true : (x.OffenseDetails != null && x.OffenseDetails.Contains(req.status.Trim().ToUpper())))
|
|
// .Where(x => req.disciplinaryFaultLevel.Trim().ToUpper() == "ALL" ? true : (x.DisciplinaryFaultLevel != null && x.DisciplinaryFaultLevel.Contains(req.status.Trim().ToUpper())))
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToListAsync();
|
|
|
|
var mapData1 = data_search1
|
|
.SelectMany((d) => d.DisciplineComplaint_Profiles.Select((profile) => new
|
|
{
|
|
fullName = $"{profile.Prefix}{profile.FirstName} {profile.LastName}",
|
|
citizenId = profile.CitizenId,
|
|
position = profile.Position,
|
|
posLevel = profile.posLevelName,
|
|
oc = profile.Organization,
|
|
CreatedAt = profile.CreatedAt,
|
|
offense = d.OffenseDetails != null && d.OffenseDetails != ""
|
|
? d.OffenseDetails == "NOT_SPECIFIED"
|
|
? "ความผิดวินัยยังไม่ระบุ"
|
|
: d.OffenseDetails == "NOT_DEADLY"
|
|
? "ความผิดวินัยไม่ร้ายแรง"
|
|
: d.OffenseDetails == "DEADLY"
|
|
? "ความผิดวินัยร้ายแรง"
|
|
: ""
|
|
: "",
|
|
faultLevel = "",
|
|
Child4Id = profile.child4DnaId,
|
|
Child4 = profile.child4,
|
|
Child3Id = profile.child3DnaId,
|
|
Child3 = profile.child3,
|
|
Child2Id = profile.child2DnaId,
|
|
Child2 = profile.child2,
|
|
Child1Id = profile.child1DnaId,
|
|
Child1 = profile.child1,
|
|
RootId = profile.rootDnaId,
|
|
Root = profile.root,
|
|
PosType = profile.posTypeName,
|
|
PosLevel = profile.posLevelName
|
|
}))
|
|
.Where(x => req.node == 4 ? x.Child4Id == req.nodeId : (req.node == 3 ? x.Child3Id == req.nodeId : (req.node == 2 ? x.Child2Id == req.nodeId : (req.node == 1 ? x.Child1Id == req.nodeId : (req.node == 0 ? x.RootId == req.nodeId : (req.node == null ? true : true))))))
|
|
.Where(x => jsonData["result"] == "OWNER" || jsonData["result"] == "CHILD" ? true : (req.node == 0 ? x.Child1Id == null : (req.node == 1 ? x.Child2Id == null : (req.node == 2 ? x.Child3Id == null : (req.node == 3 ? x.Child4Id == null : true)))))
|
|
.Where(x => string.IsNullOrEmpty(req.posType) || x.PosType == req.posType)
|
|
.Where(x => string.IsNullOrEmpty(req.posLevel) || x.PosLevel == req.posLevel)
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToList();
|
|
var groupedResult1 = mapData1
|
|
.GroupBy(x => x.fullName)
|
|
.Select(g => new
|
|
{
|
|
one = g.Count(), // Count of records per fullName
|
|
two = 0,
|
|
three = 0,
|
|
g.Where(x => x.fullName != null || x.fullName != "").FirstOrDefault()?.fullName,
|
|
g.Where(x => x.citizenId != null || x.citizenId != "").FirstOrDefault()?.citizenId,
|
|
g.Where(x => x.position != null || x.position != "").FirstOrDefault()?.position,
|
|
g.Where(x => x.posLevel != null || x.posLevel != "").FirstOrDefault()?.posLevel,
|
|
oc = (g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 == null ? "" : g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 + "\n") +
|
|
(g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 == null ? "" : g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 + "\n") +
|
|
(g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 == null ? "" : g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 + "\n") +
|
|
(g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 == null ? "" : g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 + "\n") +
|
|
(g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root == null ? "" : g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root),
|
|
g.Where(x => x.offense != null || x.offense != "").FirstOrDefault()?.offense,
|
|
g.Where(x => x.faultLevel != null || x.faultLevel != "").FirstOrDefault()?.faultLevel,
|
|
})
|
|
.ToList();
|
|
|
|
var data_search2 = await _context.DisciplineInvestigates
|
|
.Include(x => x.DisciplineInvestigate_ProfileComplaints)
|
|
.Where(x => req.status.Trim().ToUpper() == "ALL" ? true : (x.Status != null && x.Status.Contains(req.status.Trim().ToUpper())))
|
|
.Where(x => req.offenseDetail.Trim().ToUpper() == "ALL" ? true : (x.OffenseDetails != null && x.OffenseDetails.Contains(req.status.Trim().ToUpper())))
|
|
// .Where(x => req.disciplinaryFaultLevel.Trim().ToUpper() == "ALL" ? true : (x.DisciplinaryFaultLevel != null && x.DisciplinaryFaultLevel.Contains(req.status.Trim().ToUpper())))
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToListAsync();
|
|
|
|
var mapData2 = data_search2
|
|
.SelectMany((d) => d.DisciplineInvestigate_ProfileComplaints.Select((profile) => new
|
|
{
|
|
fullName = $"{profile.Prefix}{profile.FirstName} {profile.LastName}",
|
|
citizenId = profile.CitizenId,
|
|
position = profile.Position,
|
|
posLevel = profile.posLevelName,
|
|
oc = profile.Organization,
|
|
CreatedAt = profile.CreatedAt,
|
|
offense = d.OffenseDetails != null && d.OffenseDetails != ""
|
|
? d.OffenseDetails == "NOT_SPECIFIED"
|
|
? "ความผิดวินัยยังไม่ระบุ"
|
|
: d.OffenseDetails == "NOT_DEADLY"
|
|
? "ความผิดวินัยไม่ร้ายแรง"
|
|
: d.OffenseDetails == "DEADLY"
|
|
? "ความผิดวินัยร้ายแรง"
|
|
: ""
|
|
: "",
|
|
faultLevel = "",
|
|
Child4Id = profile.child4DnaId,
|
|
Child4 = profile.child4,
|
|
Child3Id = profile.child3DnaId,
|
|
Child3 = profile.child3,
|
|
Child2Id = profile.child2DnaId,
|
|
Child2 = profile.child2,
|
|
Child1Id = profile.child1DnaId,
|
|
Child1 = profile.child1,
|
|
RootId = profile.rootDnaId,
|
|
Root = profile.root,
|
|
PosType = profile.posTypeName,
|
|
PosLevel = profile.posLevelName
|
|
}))
|
|
.Where(x => req.node == 4 ? x.Child4Id == req.nodeId : (req.node == 3 ? x.Child3Id == req.nodeId : (req.node == 2 ? x.Child2Id == req.nodeId : (req.node == 1 ? x.Child1Id == req.nodeId : (req.node == 0 ? x.RootId == req.nodeId : (req.node == null ? true : true))))))
|
|
.Where(x => jsonData["result"] == "OWNER" || jsonData["result"] == "CHILD" ? true : (req.node == 0 ? x.Child1Id == null : (req.node == 1 ? x.Child2Id == null : (req.node == 2 ? x.Child3Id == null : (req.node == 3 ? x.Child4Id == null : true)))))
|
|
.Where(x => string.IsNullOrEmpty(req.posType) || x.PosType == req.posType)
|
|
.Where(x => string.IsNullOrEmpty(req.posLevel) || x.PosLevel == req.posLevel)
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToList();
|
|
var groupedResult2 = mapData2
|
|
.GroupBy(x => x.fullName)
|
|
.Select(g => new
|
|
{
|
|
one = 0,
|
|
two = g.Count(), // Count of records per fullName
|
|
three = 0,
|
|
g.Where(x => x.fullName != null || x.fullName != "").FirstOrDefault()?.fullName,
|
|
g.Where(x => x.citizenId != null || x.citizenId != "").FirstOrDefault()?.citizenId,
|
|
g.Where(x => x.position != null || x.position != "").FirstOrDefault()?.position,
|
|
g.Where(x => x.posLevel != null || x.posLevel != "").FirstOrDefault()?.posLevel,
|
|
oc = (g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 == null ? "" : g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 + "\n") +
|
|
(g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 == null ? "" : g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 + "\n") +
|
|
(g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 == null ? "" : g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 + "\n") +
|
|
(g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 == null ? "" : g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 + "\n") +
|
|
(g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root == null ? "" : g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root),
|
|
g.Where(x => x.offense != null || x.offense != "").FirstOrDefault()?.offense,
|
|
g.Where(x => x.faultLevel != null || x.faultLevel != "").FirstOrDefault()?.faultLevel,
|
|
})
|
|
.ToList();
|
|
|
|
var data_search3 = await _context.DisciplineDisciplinarys
|
|
.Include(x => x.DisciplineDisciplinary_ProfileComplaintInvestigates)
|
|
.Where(x => req.status.Trim().ToUpper() == "ALL" ? true : (x.Status != null && x.Status.Contains(req.status.Trim().ToUpper())))
|
|
.Where(x => req.offenseDetail.Trim().ToUpper() == "ALL" ? true : (x.OffenseDetails != null && x.OffenseDetails.Contains(req.status.Trim().ToUpper())))
|
|
.Where(x => req.disciplinaryFaultLevel.Trim().ToUpper() == "ALL" ? true : (x.DisciplinaryFaultLevel != null && x.DisciplinaryFaultLevel.Contains(req.status.Trim().ToUpper())))
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToListAsync();
|
|
|
|
var mapData3 = data_search3
|
|
.SelectMany((d) => d.DisciplineDisciplinary_ProfileComplaintInvestigates.Select((profile) => new
|
|
{
|
|
fullName = $"{profile.Prefix}{profile.FirstName} {profile.LastName}",
|
|
citizenId = profile.CitizenId,
|
|
position = profile.Position,
|
|
posLevel = profile.posLevelName,
|
|
oc = profile.Organization,
|
|
CreatedAt = profile.CreatedAt,
|
|
offense = d.OffenseDetails != null && d.OffenseDetails != ""
|
|
? d.OffenseDetails == "NOT_SPECIFIED"
|
|
? "ความผิดวินัยยังไม่ระบุ"
|
|
: d.OffenseDetails == "NOT_DEADLY"
|
|
? "ความผิดวินัยไม่ร้ายแรง"
|
|
: d.OffenseDetails == "DEADLY"
|
|
? "ความผิดวินัยร้ายแรง"
|
|
: ""
|
|
: "",
|
|
faultLevel = d.DisciplinaryFaultLevel,
|
|
Child4Id = profile.child4DnaId,
|
|
Child4 = profile.child4,
|
|
Child3Id = profile.child3DnaId,
|
|
Child3 = profile.child3,
|
|
Child2Id = profile.child2DnaId,
|
|
Child2 = profile.child2,
|
|
Child1Id = profile.child1DnaId,
|
|
Child1 = profile.child1,
|
|
RootId = profile.rootDnaId,
|
|
Root = profile.root,
|
|
PosType = profile.posTypeName,
|
|
PosLevel = profile.posLevelName
|
|
}))
|
|
.Where(x => req.node == 4 ? x.Child4Id == req.nodeId : (req.node == 3 ? x.Child3Id == req.nodeId : (req.node == 2 ? x.Child2Id == req.nodeId : (req.node == 1 ? x.Child1Id == req.nodeId : (req.node == 0 ? x.RootId == req.nodeId : (req.node == null ? true : true))))))
|
|
.Where(x => jsonData["result"] == "OWNER" || jsonData["result"] == "CHILD" ? true : (req.node == 0 ? x.Child1Id == null : (req.node == 1 ? x.Child2Id == null : (req.node == 2 ? x.Child3Id == null : (req.node == 3 ? x.Child4Id == null : true)))))
|
|
.Where(x => string.IsNullOrEmpty(req.posType) || x.PosType == req.posType)
|
|
.Where(x => string.IsNullOrEmpty(req.posLevel) || x.PosLevel == req.posLevel)
|
|
.OrderByDescending(x => x.CreatedAt)
|
|
.ToList();
|
|
var groupedResult3 = mapData3
|
|
.GroupBy(x => x.fullName)
|
|
.Select(g => new
|
|
{
|
|
one = 0,
|
|
two = 0,
|
|
three = g.Count(), // Count of records per fullName
|
|
g.Where(x => x.fullName != null || x.fullName != "").FirstOrDefault()?.fullName,
|
|
g.Where(x => x.citizenId != null || x.citizenId != "").FirstOrDefault()?.citizenId,
|
|
g.Where(x => x.position != null || x.position != "").FirstOrDefault()?.position,
|
|
g.Where(x => x.posLevel != null || x.posLevel != "").FirstOrDefault()?.posLevel,
|
|
oc = (g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 == null ? "" : g.Where(x => x.Child4 != null || x.Child4 != "").FirstOrDefault()?.Child4 + "\n") +
|
|
(g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 == null ? "" : g.Where(x => x.Child3 != null || x.Child3 != "").FirstOrDefault()?.Child3 + "\n") +
|
|
(g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 == null ? "" : g.Where(x => x.Child2 != null || x.Child2 != "").FirstOrDefault()?.Child2 + "\n") +
|
|
(g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 == null ? "" : g.Where(x => x.Child1 != null || x.Child1 != "").FirstOrDefault()?.Child1 + "\n") +
|
|
(g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root == null ? "" : g.Where(x => x.Root != null || x.Root != "").FirstOrDefault()?.Root),
|
|
g.Where(x => x.offense != null || x.offense != "").FirstOrDefault()?.offense,
|
|
g.Where(x => x.faultLevel != null || x.faultLevel != "").FirstOrDefault()?.faultLevel,
|
|
})
|
|
.ToList();
|
|
|
|
var resultSum = groupedResult1.Concat(groupedResult2).Concat(groupedResult3).ToArray();
|
|
var groupedResult = resultSum
|
|
.GroupBy(x => x.fullName)
|
|
.Select(g => new
|
|
{
|
|
// g.Where(x => x.no != null || x.no != "").FirstOrDefault()?.no,
|
|
g.Where(x => x.fullName != null || x.fullName != "").FirstOrDefault()?.fullName,
|
|
g.Where(x => x.citizenId != null || x.citizenId != "").FirstOrDefault()?.citizenId,
|
|
g.Where(x => x.position != null || x.position != "").FirstOrDefault()?.position,
|
|
g.Where(x => x.posLevel != null || x.posLevel != "").FirstOrDefault()?.posLevel,
|
|
g.Where(x => x.oc != null || x.oc != "").FirstOrDefault()?.oc,
|
|
g.Where(x => x.offense != null || x.offense != "").FirstOrDefault()?.offense,
|
|
g.Where(x => x.faultLevel != null || x.faultLevel != "").FirstOrDefault()?.faultLevel,
|
|
one = g.Sum(x => x.one), // Replace `score` with actual field name
|
|
two = g.Sum(x => x.two), // Replace `score` with actual field name
|
|
three = g.Sum(x => x.three), // Replace `score` with actual field name
|
|
})
|
|
.OrderBy(x => x.citizenId)
|
|
.ToList();
|
|
var resultMap = new List<dynamic>();
|
|
var count = 1;
|
|
foreach (var p in groupedResult)
|
|
{
|
|
var emp = new
|
|
{
|
|
no = count,
|
|
fullName = p.fullName,
|
|
citizenId = p.citizenId,
|
|
position = p.position,
|
|
posLevel = p.posLevel,
|
|
oc = p.oc,
|
|
offense = p.offense,
|
|
faultLevel = p.faultLevel,
|
|
one = p.one,
|
|
two = p.two,
|
|
three = p.three,
|
|
};
|
|
resultMap.Add(emp);
|
|
count++;
|
|
}
|
|
var result = new
|
|
{
|
|
template = "reportDiscipline",
|
|
reportName = "xlsx-report",
|
|
data = new
|
|
{
|
|
year = (req.year + 543).ToString().ToThaiNumber(),
|
|
dateCurrent = $"ณ วันที่ {DateTime.Now.Date.ToThaiShortDate().ToThaiNumber()}",
|
|
data = resultMap
|
|
}
|
|
};
|
|
return Success(result);
|
|
}
|
|
}
|
|
}
|