public KpiGeneralEmployeeReport_ExportDTO(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO)
{
this.STT = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.STT;
this.KpiPeriod = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiPeriodName;
this.KpiYear = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiYearName;
this.TotalLeadPLanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLeadPLanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLeadPLanned.ToString();
this.TotalLead = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLead == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLead.ToString();
this.TotalLeadRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLeadRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalLeadRatio.ToString();
this.TotalOpportunityPlanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunityPlanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunityPlanned.ToString();
this.TotalOpportunity = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunity == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunity.ToString();
this.TotalOpportunityRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunityRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOpportunityRatio.ToString();
this.TotalCustomerPlanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomerPlanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomerPlanned.ToString();
this.TotalCustomer = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomer == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomer.ToString();
this.TotalCustomerRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomerRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalCustomerRatio.ToString();
this.TotalContractPLanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContractPLanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContractPLanned.ToString();
this.TotalContract = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContract == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContract.ToString();
this.TotalContractRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContractRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalContractRatio.ToString();
this.TotalOrderPlanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrderPlanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrderPlanned.ToString();
this.TotalOrder = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrder == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrder.ToString();
this.TotalOrderRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrderRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalOrderRatio.ToString();
this.TotalSalesOfOrderPlanned = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrderPlanned == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrderPlanned.ToString();
this.TotalSalesOfOrder = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrder == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrder.ToString();
this.TotalSalesOfOrderRatio = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrderRatio == null ? "" : KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.TotalSalesOfOrderRatio.ToString();
}
public async Task <ActionResult <List <KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO> > > List([FromBody] KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
if (KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.AppUserId == null)
{
return(BadRequest(new { message = "Chưa chọn nhân viên" }));
}
DateTime StartDate, EndDate;
long? SaleEmployeeId = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.AppUserId.Equal.Value;
long? KpiPeriodId = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.KpiPeriodId?.Equal;
long? KpiYearId = KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.KpiYearId?.Equal;
(StartDate, EndDate) = DateTimeConvert(KpiPeriodId, KpiYearId);
var KpiGeneralId = await DataContext.KpiGeneral
.Where(x => x.EmployeeId == SaleEmployeeId.Value &&
(KpiYearId.HasValue == false || x.KpiYearId == KpiYearId.Value) &&
x.StatusId == StatusEnum.ACTIVE.Id &&
(KpiYearId == null || x.KpiYearId == KpiYearId) &&
x.DeletedAt == null)
.Select(x => x.Id)
.FirstOrDefaultAsync();
var KpiGeneral = await KpiGeneralService.Get(KpiGeneralId);
if (KpiGeneral == null)
{
return(new List <KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO>());
}
var KpiPeriodIds = KpiGeneral.KpiGeneralContents
.SelectMany(x => x.KpiGeneralContentKpiPeriodMappings)
.Where(x => KpiPeriodId.HasValue == false || x.KpiPeriodId == KpiPeriodId.Value)
.Select(x => x.KpiPeriodId)
.Distinct()
.Skip(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.Skip)
.Take(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportFilterDTO.Take)
.ToList();
var KpiPeriods = await KpiPeriodService.List(new KpiPeriodFilter
{
Skip = 0,
Take = int.MaxValue,
Selects = KpiPeriodSelect.ALL,
Id = new IdFilter {
In = KpiPeriodIds
},
OrderBy = KpiPeriodOrder.Id,
OrderType = OrderType.ASC
});
var KpiGeneralContentKpiPeriodMappings = KpiGeneral.KpiGeneralContents
.SelectMany(x => x.KpiGeneralContentKpiPeriodMappings)
.Where(x => KpiPeriodIds.Contains(x.KpiPeriodId))
.ToList();
List <KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO>
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTOs = new List <KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO>();
Parallel.ForEach(KpiPeriods, KpiPeriod =>
{
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO
= new KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO();
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiPeriodId = KpiPeriod.Id;
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiPeriodName = KpiPeriod.Name;
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiYearId = KpiGeneral.KpiYearId;
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.KpiYearName = KpiGeneral.KpiYear.Name;
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO.SaleEmployeeId = SaleEmployeeId.Value;
KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTOs.Add(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTO);
});
//#region Danh sách Lead
//var CustomerLeadDAOs = await DataContext.CustomerLead
// .Where(x => x.UserId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Danh sách cơ hội thành công
//var OpportunityDAOs = await DataContext.Opportunity
// .Where(x => x.AppUserId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// x.SaleStageId == Enums.SaleStageEnum.CLOSED.Id &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Danh sách khách hàng
//#region Khách hàng lẻ
//var CustomerRetailDAOs = await DataContext.CustomerRetail
// .Where(x => x.AssignedAppUserId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Khách hàng đại lý
//var CustomerAgentDAOs = await DataContext.CustomerAgent
// .Where(x => x.AssignedAppUserId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Khách hàng dự án
//var CustomerProjectDAOs = await DataContext.CustomerProject
// .Where(x => x.AppUserAssignedId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Khách hàng xuất khẩu
//var CustomerExportDAOs = await DataContext.CustomerExport
// .Where(x => x.AppUserAssignedId == SaleEmployeeId &&
// x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
// !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#endregion
//#region Danh sách đơn hàng
//#region Đơn hàng lẻ
//var OrderRetailDAOs = await DataContext.OrderRetail
// .Where(x => x.AppUserAssignedId == SaleEmployeeId &&
// x.OrderDate >= StartDate && x.OrderDate <= EndDate
// && !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Đơn hàng đại lý
//var OrderAgentDAOs = await DataContext.DirectSalesOrder
// .Where(x => x.SaleEmployeeId == SaleEmployeeId &&
// x.OrderDate >= StartDate && x.OrderDate <= EndDate
// && !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Đơn hàng dự án
//var OrderProjectDAOs = await DataContext.OrderProject
// .Where(x => x.AppUserAssignedId == SaleEmployeeId &&
// x.OrderDate >= StartDate && x.OrderDate <= EndDate
// && !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#region Đơn hàng xuất khẩu
//var OrderExportDAOs = await DataContext.OrderExport
// .Where(x => x.AppUserAssignedId == SaleEmployeeId &&
// x.OrderDate >= StartDate && x.OrderDate <= EndDate
// && !x.DeletedAt.HasValue
// ).ToListAsync();
//#endregion
//#endregion
#region Danh sách hợp đồng đã hoàn thành theo nhân viên
var ContractDAOs = await DataContext.Contract
.Where(x => x.AppUserId == SaleEmployeeId &&
x.ValidityDate >= StartDate && x.ValidityDate <= EndDate &&
!x.DeletedAt.HasValue
).ToListAsync();
#endregion
#region Danh sách ticket thành công
var TicketDAOs = await DataContext.Ticket
.Where(x => x.UserId == SaleEmployeeId &&
x.CreatedAt >= StartDate && x.CreatedAt <= EndDate &&
x.SLAStatusId == Enums.SLAStatusEnum.Success.Id &&
!x.DeletedAt.HasValue
).ToListAsync();
#endregion
//Parallel.ForEach(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTOs, Period =>
//{
// foreach (var KpiPeriod in KpiPeriodEnum.KpiPeriodEnumList)
// {
// if (KpiPeriod.Id == Period.KpiPeriodId)
// Period.KpiPeriodName = KpiPeriod.Name;
// }
// DateTime Start, End;
// (Start, End) = DateTimeConvert(Period.KpiPeriodId, Period.KpiYearId);
// #region Số Lead
// //kế hoạch
// Period.TotalLeadPLanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAL_LEAD.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalLeadPLanned.HasValue)
// {
// //thực hiện
// Period.TotalLead = Period.TotalLeadPLanned == null ? null : (decimal?)CustomerLeadDAOs.Count();
// //tỉ lệ
// Period.TotalLeadRatio = Period.TotalLeadPLanned == null || Period.TotalLead == null || Period.TotalLeadPLanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalLead.Value / Period.TotalLeadPLanned.Value) * 100, 2);
// }
// #endregion
// #region Số cơ hội thành công
// //kế hoạch
// Period.TotalOpportunityPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAL_OPPORTUNITY.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalOpportunityPlanned.HasValue)
// {
// //thực hiện
// Period.TotalOpportunity = Period.TotalOpportunityPlanned == null ? null : (decimal?)OpportunityDAOs.Count();
// //tỉ lệ
// Period.TotalOpportunityRatio = Period.TotalOpportunityPlanned == null || Period.TotalOpportunity == null || Period.TotalOpportunityPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalOpportunity.Value / Period.TotalOpportunityPlanned.Value) * 100, 2);
// }
// #endregion
// #region Số khách hàng
// //kế hoạch
// Period.TotalCustomerPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAL_CUSTOMER.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalCustomerPlanned.HasValue)
// {
// //thực hiện
// Period.TotalCustomer = Period.TotalCustomerPlanned == null ? null : (decimal?)(CustomerRetailDAOs.Count + CustomerAgentDAOs.Count() + CustomerProjectDAOs.Count() + CustomerExportDAOs.Count());
// //tỉ lệ
// Period.TotalCustomerRatio = Period.TotalCustomerPlanned == null || Period.TotalCustomer == null || Period.TotalCustomerPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalCustomer.Value / Period.TotalCustomerPlanned.Value) * 100, 2);
// }
// #endregion
// #region Số đơn hàng
// //kế hoạch
// Period.TotalOrderPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAl_ORDER.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalOrderPlanned.HasValue)
// {
// //thực hiện
// Period.TotalOrder = Period.TotalOrderPlanned == null ? null : (decimal?)(OrderRetailDAOs.Count() + OrderAgentDAOs.Count() + OrderProjectDAOs.Count() + OrderExportDAOs.Count());
// //tỉ lệ
// Period.TotalOrderRatio = Period.TotalOrderPlanned == null || Period.TotalOrder == null || Period.TotalOrderPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalOrder.Value / Period.TotalOrderPlanned.Value) * 100, 2);
// }
// #endregion
// #region Doanh số theo đơn hàng
// //kế hoạch
// Period.TotalSalesOfOrderPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.SALES_BY_ORDER.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalSalesOfOrderPlanned.HasValue)
// {
// //thực hiện
// Period.TotalSalesOfOrder = Period.TotalSalesOfOrderPlanned == null ? null : (decimal?)(OrderRetailDAOs.Sum(p => p.Total) + OrderAgentDAOs.Sum(p => p.Total) + OrderProjectDAOs.Sum(p => p.Total) + OrderExportDAOs.Sum(p => p.Total));
// //tỉ lệ
// Period.TotalSalesOfOrderRatio = Period.TotalSalesOfOrderPlanned == null || Period.TotalSalesOfOrder == null || Period.TotalSalesOfOrderPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalSalesOfOrder.Value / Period.TotalSalesOfOrderPlanned.Value) * 100, 2);
// }
// #endregion
// #region Số hợp đồng
// //kế hoạch
// Period.TotalContractPLanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAL_CONTRACT.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalContractPLanned.HasValue)
// {
// //thực hiện
// Period.TotalContract = Period.TotalContractPLanned == null ? null : (decimal?)ContractDAOs.Count();
// //tỉ lệ
// Period.TotalContractRatio = Period.TotalContractPLanned == null || Period.TotalContract == null || Period.TotalContractPLanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalContract.Value / Period.TotalContractPLanned.Value) * 100, 2);
// }
// #endregion
// #region Doanh số theo hợp đồng
// //kế hoạch
// Period.TotalSalesOfContractPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.SALES_BY_CONTRACT.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalSalesOfContractPlanned.HasValue)
// {
// //thực hiện
// Period.TotalSalesOfContract = Period.TotalSalesOfContractPlanned == null ? null : (decimal?)ContractDAOs.Sum(p=>p.TotalValue);
// //tỉ lệ
// Period.TotalSalesOfContractRatio = Period.TotalSalesOfContractPlanned == null || Period.TotalSalesOfContract == null || Period.TotalSalesOfContractPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalSalesOfContract.Value / Period.TotalSalesOfContractPlanned.Value) * 100, 2);
// }
// #endregion
// #region Số ticket hoàn thành
// //kế hoạch
// Period.TotalTicketCompletedPlanned = KpiGeneralContentKpiPeriodMappings
// .Where(x => x.KpiPeriodId == Period.KpiPeriodId &&
// x.KpiGeneralContent.KpiCriteriaGeneralId == KpiCriteriaGeneralEnum.TOTAL_TICKET_COMPLETE.Id)
// .Select(x => x.Value)
// .FirstOrDefault();
// if (Period.TotalTicketCompletedPlanned.HasValue)
// {
// //thực hiện
// Period.TotalTicketCompleted = Period.TotalTicketCompletedPlanned == null ? null : (decimal?)TicketDAOs.Count();
// //tỉ lệ
// Period.TotalTicketCompletedRatio = Period.TotalTicketCompletedPlanned == null || Period.TotalTicketCompleted == null || Period.TotalTicketCompletedPlanned == 0 ? null :
// (decimal?)
// Math.Round((Period.TotalTicketCompleted.Value / Period.TotalTicketCompletedPlanned.Value) * 100, 2);
// }
// #endregion
//});
return(KpiGeneralEmployeeReport_KpiGeneralEmployeeReportDTOs.OrderBy(x => x.KpiPeriodId).ThenBy(x => x.KpiYearId).ToList());
}
