public DashboardHistoryController(IDashboardModelFactory dashboardModelFactory,
IOrganigramaModelFactory organigramaModelFactory,
IEmployeeFormatModelFactory employeeFormatModelFactory)
{
this._dashboardModelFactory = dashboardModelFactory;
this._organigramaModelFactory = organigramaModelFactory;
this._employeeFormatModelFactory = employeeFormatModelFactory;
}
public DashboardService(
IUnitOfWork unitOfWork,
IFilterService filterService,
IUserService userService,
IDashboardModelFactory dashboardModelFactory)
: base(unitOfWork)
{
this.filterService = filterService ?? throw new ArgumentNullException(nameof(filterService));
this.userService = userService ?? throw new ArgumentNullException(nameof(userService));
this.dashboardModelFactory = dashboardModelFactory ?? throw new ArgumentNullException(nameof(dashboardModelFactory));
}
public JsonResult GenerateIncidenciaReportData(string dateIni, string dateFin,
[FromServices] IDashboardModelFactory dashboardModelFactory,
[FromServices] IRepository <EmployeeFormat> employeeFormatRepository,
[FromServices] IRepository <DocumentType> documentTypeRepository,
[FromServices] IEmployeeFormatModelFactory employeeFormatModelFactory)
{
List <ReportEmployeeDetailModel> modelFaltas = new List <ReportEmployeeDetailModel>();
List <ReportEmployeeDetailModel> modelIncapacidades = new List <ReportEmployeeDetailModel>();
List <ReportEmployeeDetailModel> modelVacaciones = new List <ReportEmployeeDetailModel>();
List <ReportEmployeeDetailModel> modelPermisos = new List <ReportEmployeeDetailModel>();
var dias = Math.Abs(Math.Round((DateTime.Parse(dateIni) - DateTime.Parse(dateFin)).TotalDays, 0));
if (dias == 0)
{
dias = 1;
}
for (int i = 0; i < dias; i++)
{
var t = DateTime.Parse(dateIni).AddDays(i);
var results = dashboardModelFactory.GetNoRegistry(t.ToShortDateString());
modelFaltas.AddRange(results);
var formats = employeeFormatModelFactory.GetAllApprovedFormats(t);
var f = formats.Where(d => d.FormatName.ToLower().Contains("incapacidad"));
modelIncapacidades.AddRange(f.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId
}));
var g = formats.Where(d => d.FormatName.ToLower().Contains("vacacion"));
modelVacaciones.AddRange(g.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId
}));
var p = formats.Where(d => d.FormatName.ToLower().Contains("permiso"));
modelPermisos.AddRange(p.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId
}));
}
var data = new {
incapacidades = modelIncapacidades.ToArray(),
incapacidadesTotal = modelIncapacidades.Count,
faltas = modelFaltas.ToArray(),
faltastotal = modelFaltas.Count,
vacaciones = modelVacaciones.ToArray(),
totalvacaciones = modelVacaciones.Count,
permisos = modelPermisos.ToArray(),
totalpermisos = modelPermisos.Count
};
return(Json(data));
}
public FileResult PrintIncidenciaReportData(string dateIni, string dateFin,
[FromServices] IDashboardModelFactory dashboardModelFactory,
[FromServices] IEmployeeFormatModelFactory employeeFormatModelFactory,
[FromServices] SARH.Core.Configuration.IConfigurationManager configManager)
{
List <ReportEmployeeDetailModel> model = new List <ReportEmployeeDetailModel>();
var dias = Math.Abs(Math.Round((DateTime.Parse(dateIni) - DateTime.Parse(dateFin)).TotalDays, 0));
if (dias == 0)
{
dias = 1;
}
for (int i = 0; i < dias; i++)
{
var t = DateTime.Parse(dateIni).AddDays(i);
var results = dashboardModelFactory.GetNoRegistry(t.ToShortDateString());
model.AddRange(results);
var formats = employeeFormatModelFactory.GetAllApprovedFormats(t);
var f = formats.Where(d => d.FormatName.ToLower().Contains("incapacidad"));
model.AddRange(f.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 2
}));
var g = formats.Where(d => d.FormatName.ToLower().Contains("vacacion"));
model.AddRange(g.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 3
}));
var p = formats.Where(d => d.FormatName.ToLower().Contains("permiso"));
model.AddRange(p.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 4
}));
}
IConfigPdf config = new ConfigPdf()
{
FontPathPdf = configManager.FontPathPdf,
ImgPathPdf = configManager.ImgPathPdf,
FontPathBarCode = configManager.FontPathBarCode
};
PdfManager manager = new PdfManager(config);
string fileName = $"{Path.GetTempPath()}IncidenciasPeriodo-{dateIni.Replace("/", string.Empty)}-{dateFin.Replace("/", string.Empty)}.pdf";
if (System.IO.File.Exists(fileName))
{
System.IO.File.Delete(fileName);
}
try
{
manager.CreateIncidenciasReport(new Core.PdfCreator.FormatData.DocumentInfoPdfData()
{
TitleDocumento = "Reporte Diario de Incidencias",
FormatId = $"{dateIni}-{dateFin}",
IncidenciasReport = model.Select(n => new Core.PdfCreator.FormatData.ReportEmployeeDetail()
{
Area = n.Area,
DetailType = n.DetailType,
Fecha = n.Fecha,
JobCenter = n.JobCenter,
JobTitle = n.JobTitle,
ID = n.ID,
Name = n.Name,
Type = n.Type
}).ToList()
}, fileName);
}
catch (Exception ex)
{
byte[] FileBytesError = System.Text.Encoding.UTF8.GetBytes(ex.Message);
return(File(FileBytesError, "text/plain"));
}
byte[] FileBytes = System.IO.File.ReadAllBytes(fileName);
return(File(FileBytes, "application/pdf"));
}
public FileResult ExportIncidenciaReportData(string dateIni, string dateFin,
[FromServices] IDashboardModelFactory dashboardModelFactory,
[FromServices] IEmployeeFormatModelFactory employeeFormatModelFactory)
{
List <ReportEmployeeDetailModel> model = new List <ReportEmployeeDetailModel>();
var dias = Math.Abs(Math.Round((DateTime.Parse(dateIni) - DateTime.Parse(dateFin)).TotalDays, 0));
if (dias == 0)
{
dias = 1;
}
for (int i = 0; i < dias; i++)
{
var t = DateTime.Parse(dateIni).AddDays(i);
var results = dashboardModelFactory.GetNoRegistry(t.ToShortDateString());
model.AddRange(results);
var formats = employeeFormatModelFactory.GetAllApprovedFormats(t);
var f = formats.Where(d => d.FormatName.ToLower().Contains("incapacidad"));
model.AddRange(f.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 2
}));
var g = formats.Where(d => d.FormatName.ToLower().Contains("vacacion"));
model.AddRange(g.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 3
}));
var p = formats.Where(d => d.FormatName.ToLower().Contains("permiso"));
model.AddRange(p.Select(h => new ReportEmployeeDetailModel()
{
Area = h.Area,
JobCenter = h.Centro,
JobTitle = h.JobTitle,
Fecha = $"{h.StartDate} - {h.EndDate}",
Name = h.Name,
DetailType = h.Comments,
ID = h.EmployeeId,
Type = 4
}));
}
var sb = new StringBuilder();
sb.Append("Id Empleado,Nombre,Area,Centro,Puesto,Periodo,Observaciones,Tipo");
model.ForEach(d =>
{
sb.AppendLine();
sb.Append($"{d.ID},{d.Name},{d.Area},{d.JobCenter},{d.JobTitle},{d.Fecha},{d.DetailType},{GetTypeModel(d.Type)}");
});
return(File(new System.Text.UTF8Encoding().GetBytes(sb.ToString()), "text/csv", $"IncidenciasPeriodo-{dateIni.Replace("/",string.Empty)}-{dateFin.Replace("/",string.Empty)}.csv"));
}
public HomeController(IDashboardModelFactory dashboardModelFactory,
IEmployeeFormatModelFactory employeeFormatModelFactory)
{
this._dashboardModelFactory = dashboardModelFactory;
this._employeeFormatModelFactory = employeeFormatModelFactory;
}
public JsonResult ProcesstIncidents(string iDate, string eDate,
[FromServices] IRepository <EmployeeDiscount> discountRepo,
[FromServices] IOrganigramaModelFactory organimgramaModelFactory,
[FromServices] IDashboardModelFactory dashboardModelFactory,
[FromServices] IRepository <NOMIPAQIncidence> nomiPAQIncidence,
[FromServices] IEmployeeFormatModelFactory employeeFormatModelFactory,
[FromServices] IRepository <NOMIPAQVacation> nomiPAQVacation,
[FromServices] INomipaqIncidenciasModelFactory nomipaqincidenciasModelFactory)
{
var employeess = organimgramaModelFactory.GetAllData();
List <PersonalDashboardData> personalData = new List <PersonalDashboardData>();
List <EmployeeIncidents> employeeIncidents = new List <EmployeeIncidents>();
var formatos = employeeFormatModelFactory.GetAllFormats(DateTime.Parse(iDate), DateTime.Parse(eDate));
if (formatos.Any())
{
formatos.Where(f => f.Approved == true && f.FormatName.ToLower().Contains("vacacion")).ToList().ForEach(t =>
{
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
parameters.Add(new KeyValuePair <string, string>("@fechaInicio", t.StartDate));
parameters.Add(new KeyValuePair <string, string>("@fechaFin", t.EndDate));
parameters.Add(new KeyValuePair <string, string>("@fechaPago", t.FechaSolicitud));
parameters.Add(new KeyValuePair <string, string>("@EMP", t.EmployeeId));
nomiPAQVacation.GetStoredProcData("VacacionesNominPAQ", parameters);
});
}
employeess.Employess.ToList().ForEach(emp =>
{
var dashInfo = dashboardModelFactory.GetPersonalDashboardData(int.Parse(emp.Id).ToString("00000"), DateTime.Parse(iDate), DateTime.Parse(eDate));
personalData.Add(dashInfo);
});
personalData.ForEach(emp =>
{
if (emp.PorcentajeRetardos > 0)
{
int veces = 0;
bool process = false;
emp.Days.Where(r => r.RetardoEntrada.Equals(1)).ToList().ForEach(day =>
{
DateTime dateA = DateTime.Parse($"{day.RegisterDate} {day.StartJobDay}");
DateTime dateB = DateTime.Parse($"{day.RegisterDate} {day.StartWorkDate}");
var diff = (dateA - dateB).TotalMinutes;
if (diff < 11 && !process)
{
veces++;
if (veces == 3)
{
employeeIncidents.Add(new EmployeeIncidents()
{
Employee = emp.EmployeeId,
Mnemonico = "RET1",
Period = day.RegisterDate
});
process = true;
}
}
if (diff < 61 && !process)
{
employeeIncidents.Add(new EmployeeIncidents()
{
Employee = emp.EmployeeId,
Mnemonico = "RET2",
Period = day.RegisterDate
});
process = true;
}
if (diff < 121 && !process)
{
employeeIncidents.Add(new EmployeeIncidents()
{
Employee = emp.EmployeeId,
Mnemonico = "RET3",
Period = day.RegisterDate
});
process = true;
}
});
}
});
if (formatos.Any())
{
var formatApproved = formatos.Where(f => f.Approved == true && f.FormatName.ToLower().Contains("permiso")).ToList();
formatApproved.ToList().ForEach(t =>
{
string mnemonico = string.Empty;
if (t.AdditionalInfo.Equals("Con goce de sueldo"))
{
mnemonico = "PCS";
}
else
{
mnemonico = "PSS";
}
employeeIncidents.Add(new EmployeeIncidents()
{
Employee = int.Parse(t.EmployeeId).ToString("00000"),
Period = t.StartDate,
Mnemonico = mnemonico
});
});
}
var dias = Math.Abs(Math.Round((DateTime.Parse(iDate) - DateTime.Parse(eDate)).TotalDays, 0));
if (dias == 0)
{
dias = 1;
}
for (int i = 0; i < dias; i++)
{
var t = DateTime.Parse(iDate).AddDays(i);
var results = dashboardModelFactory.GetNoRegistry(t.ToShortDateString());
results.ForEach(f =>
{
employeeIncidents.Add(new EmployeeIncidents()
{
Employee = int.Parse(f.ID).ToString("00000"),
Period = f.Fecha,
Mnemonico = "FINJ"
});
});
}
var incidencias = nomipaqincidenciasModelFactory.GetAllIncidencias();
var incidenciasNomipaq = incidencias.Where(g => g.Fecha >= DateTime.Parse(iDate) && g.Fecha <= (DateTime.Parse(eDate)));
if (employeeIncidents.Any())
{
employeeIncidents.ForEach(item =>
{
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
parameters.Add(new KeyValuePair <string, string>("@Empleado", item.Employee));
parameters.Add(new KeyValuePair <string, string>("@TipoIncidencia", item.Mnemonico));
parameters.Add(new KeyValuePair <string, string>("@fecha", item.Period));
nomiPAQIncidence.GetStoredProcData("IncidenciasNominPAQ", parameters);
});
}
return(Json("Ok"));
}
