public GarmentMonitoringProductionFlowDto(GarmentMonitoringProductionFlowDto flowDto)
{
Id = flowDto.Id;
this.Ro = flowDto.Ro;
this.BuyerCode = flowDto.BuyerCode;
this.Article = flowDto.Article;
this.Comodity = flowDto.Comodity;
this.QtyOrder = flowDto.QtyOrder;
this.Size = flowDto.Size;
this.QtyCutting = flowDto.QtyCutting;
this.QtyLoading = flowDto.QtyLoading;
this.QtySewing = flowDto.QtySewing;
this.QtyFinishing = flowDto.QtyFinishing;
this.Wip = flowDto.Wip;
}
public async Task <MemoryStream> Handle(GetXlsMonitoringProductionFlowQuery request, CancellationToken cancellationToken)
{
DateTimeOffset date = new DateTimeOffset(request.date, new TimeSpan(7, 0, 0));
var QueryRo = (from a in garmentCuttingOutRepository.Query
join b in garmentCuttingOutItemRepository.Query on a.Identity equals b.CutOutId
where a.UnitFromId == request.unit && a.CuttingOutDate <= date
select a.RONo).Distinct();
List <string> _ro = new List <string>();
foreach (var item in QueryRo)
{
_ro.Add(item);
}
CostCalculationGarmentDataProductionReport costCalculation = await GetDataCostCal(_ro, request.token);
var QueryCuttingOut = (from a in garmentCuttingOutRepository.Query
join b in garmentCuttingOutItemRepository.Query on a.Identity equals b.CutOutId
join c in garmentCuttingOutDetailRepository.Query on b.Identity equals c.CutOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.UnitFromId == request.unit && a.CuttingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyCutting = c.CuttingOutQuantity, Size = c.SizeName
});
var QueryLoading = (from a in garmentLoadingRepository.Query
join b in garmentLoadingItemRepository.Query on a.Identity equals b.LoadingId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.UnitId == request.unit && a.LoadingDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyLoading = b.Quantity, Size = b.SizeName
});
var QuerySewingOutIsDifSize = from a in garmentSewingOutRepository.Query
join b in garmentSewingOutItemRepository.Query on a.Identity equals b.SewingOutId
join c in garmentSewingOutDetailRepository.Query on b.Identity equals c.SewingOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.SewingTo == "FINISHING" && a.UnitId == request.unit && a.SewingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtySewing = c.Quantity, Size = c.SizeName
};
var QuerySewingOut = from a in garmentSewingOutRepository.Query
join b in garmentSewingOutItemRepository.Query on a.Identity equals b.SewingOutId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.SewingTo == "FINISHING" && a.UnitId == request.unit && a.SewingOutDate <= date && a.IsDifferentSize == false
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtySewing = b.Quantity, Size = b.SizeName
};
var QueryFinishingOutisDifSize = from a in garmentFinishingOutRepository.Query
join b in garmentFinishingOutItemRepository.Query on a.Identity equals b.FinishingOutId
join c in garmentFinishingOutDetailRepository.Query on b.Identity equals c.FinishingOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.FinishingTo == "GUDANG JADI" && a.UnitId == request.unit && a.FinishingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyFinishing = c.Quantity, Size = c.SizeName
};
var QueryFinishingOut = from a in garmentFinishingOutRepository.Query
join b in garmentFinishingOutItemRepository.Query on a.Identity equals b.FinishingOutId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.FinishingTo == "GUDANG JADI" && a.UnitId == request.unit && a.FinishingOutDate <= date && a.IsDifferentSize == false
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyFinishing = b.Quantity, Size = b.SizeName
};
var queryNow = QueryCuttingOut.Union(QueryLoading).Union(QuerySewingOutIsDifSize).Union(QuerySewingOut).Union(QueryFinishingOut).Union(QueryFinishingOutisDifSize).AsEnumerable();
var querySum = queryNow.GroupBy(x => new { x.Size, x.Ro, x.Article, x.BuyerCode, x.Comodity, x.QtyOrder }, (key, group) => new
{
ro = key.Ro,
article = key.Article,
buyer = key.BuyerCode,
comodity = key.Comodity,
qtyOrder = key.QtyOrder,
qtycutting = group.Sum(s => s.QtyCutting),
qtySewing = group.Sum(s => s.QtySewing),
qtyLoading = group.Sum(s => s.QtyLoading),
qtyFinishing = group.Sum(s => s.QtyFinishing),
size = key.Size,
});
var querySumTotal = queryNow.GroupBy(x => new { x.Ro, x.Article, x.BuyerCode, x.Comodity, x.QtyOrder }, (key, group) => new
{
ro = key.Ro,
article = key.Article,
buyer = key.BuyerCode,
comodity = key.Comodity,
qtyOrder = key.QtyOrder,
qtycutting = group.Sum(s => s.QtyCutting),
qtySewing = group.Sum(s => s.QtySewing),
qtyLoading = group.Sum(s => s.QtyLoading),
qtyFinishing = group.Sum(s => s.QtyFinishing),
size = "TOTAL"
});
var query = querySum.Union(querySumTotal).OrderBy(s => s.ro);
GarmentMonitoringProductionFlowListViewModel garmentMonitoringProductionFlow = new GarmentMonitoringProductionFlowListViewModel();
List <GarmentMonitoringProductionFlowDto> monitoringDtos = new List <GarmentMonitoringProductionFlowDto>();
foreach (var item in query)
{
GarmentMonitoringProductionFlowDto garmentMonitoringDto = new GarmentMonitoringProductionFlowDto()
{
Article = item.article,
Ro = item.ro,
BuyerCode = item.buyer,
QtyOrder = item.qtyOrder,
QtyCutting = item.qtycutting,
QtySewing = item.qtySewing,
QtyFinishing = item.qtyFinishing,
QtyLoading = item.qtyLoading,
Size = item.size,
Comodity = item.comodity,
Wip = item.qtycutting - item.qtyFinishing
};
monitoringDtos.Add(garmentMonitoringDto);
}
garmentMonitoringProductionFlow.garmentMonitorings = monitoringDtos;
var reportDataTable = new DataTable();
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "RO", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Kode Buyer", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "No Article", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Komoditi", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Jumlah Order", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Ukuran", DataType = typeof(string)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Hasil Potong", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Hasil Loading", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Hasil Sewing", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Hasil Finishing", DataType = typeof(double)
});
reportDataTable.Columns.Add(new DataColumn()
{
ColumnName = "Barang Dalam Proses", DataType = typeof(double)
});
if (garmentMonitoringProductionFlow.garmentMonitorings.Count > 0)
{
foreach (var report in garmentMonitoringProductionFlow.garmentMonitorings)
{
reportDataTable.Rows.Add(report.Ro, report.BuyerCode, report.Article, report.Comodity, report.QtyOrder, report.Size, report.QtyCutting, report.QtyLoading, report.QtySewing, report.QtyFinishing, report.Wip);
}
}
using (var package = new ExcelPackage())
{
var worksheet = package.Workbook.Worksheets.Add("Sheet 1");
worksheet.Cells["A1"].LoadFromDataTable(reportDataTable, true);
var stream = new MemoryStream();
var lisa = garmentMonitoringProductionFlow.garmentMonitorings.GroupBy(x => new { x.Ro, x.Article, x.BuyerCode, x.Comodity, x.QtyOrder }).
Select(x => new
{
Id = x.Key,
Quantity = x.Count(),
buyerGroup = x.GroupBy(y => y.BuyerCode)
.Select(y => new
{
Id = y.Key,
buyerGroup = y.Count()
})
});
int A = 1, B = 0;
List <int> listbold = new List <int>();
foreach (var item in lisa)
{
B = A + 1;
A += item.Quantity;
listbold.Add(item.Quantity);
worksheet.Cells["A" + B + ":E" + A + ""].Merge = true;
worksheet.Cells["A" + B + ":E" + A + ""].Style.VerticalAlignment = ExcelVerticalAlignment.Top;
worksheet.Cells["F" + (A)].Style.Font.Bold = true;
worksheet.Cells["G" + (A)].Style.Font.Bold = true;
worksheet.Cells["H" + (A)].Style.Font.Bold = true;
worksheet.Cells["I" + (A)].Style.Font.Bold = true;
worksheet.Cells["J" + (A)].Style.Font.Bold = true;
worksheet.Cells["K" + (A)].Style.Font.Bold = true;
}
package.SaveAs(stream);
return(stream);
}
}
public async Task <GarmentMonitoringProductionFlowListViewModel> Handle(GetMonitoringProductionFlowQuery request, CancellationToken cancellationToken)
{
DateTimeOffset date = new DateTimeOffset(request.date, new TimeSpan(7, 0, 0));
var QueryRo = (from a in garmentCuttingOutRepository.Query
join b in garmentCuttingOutItemRepository.Query on a.Identity equals b.CutOutId
where a.UnitFromId == request.unit && a.CuttingOutDate <= date
select a.RONo).Distinct();
List <string> _ro = new List <string>();
foreach (var item in QueryRo)
{
_ro.Add(item);
}
CostCalculationGarmentDataProductionReport costCalculation = await GetDataCostCal(_ro, request.token);
var QueryCuttingOut = (from a in garmentCuttingOutRepository.Query
join b in garmentCuttingOutItemRepository.Query on a.Identity equals b.CutOutId
join c in garmentCuttingOutDetailRepository.Query on b.Identity equals c.CutOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.UnitFromId == request.unit && a.CuttingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyCutting = c.CuttingOutQuantity, Size = c.SizeName
});
var QueryLoading = (from a in garmentLoadingRepository.Query
join b in garmentLoadingItemRepository.Query on a.Identity equals b.LoadingId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.UnitId == request.unit && a.LoadingDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyLoading = b.Quantity, Size = b.SizeName
});
var QuerySewingOutIsDifSize = from a in garmentSewingOutRepository.Query
join b in garmentSewingOutItemRepository.Query on a.Identity equals b.SewingOutId
join c in garmentSewingOutDetailRepository.Query on b.Identity equals c.SewingOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.SewingTo == "FINISHING" && a.UnitId == request.unit && a.SewingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtySewing = c.Quantity, Size = c.SizeName
};
var QuerySewingOut = from a in garmentSewingOutRepository.Query
join b in garmentSewingOutItemRepository.Query on a.Identity equals b.SewingOutId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.SewingTo == "FINISHING" && a.UnitId == request.unit && a.SewingOutDate <= date && a.IsDifferentSize == false
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtySewing = b.Quantity, Size = b.SizeName
};
var QueryFinishingOutisDifSize = from a in garmentFinishingOutRepository.Query
join b in garmentFinishingOutItemRepository.Query on a.Identity equals b.FinishingOutId
join c in garmentFinishingOutDetailRepository.Query on b.Identity equals c.FinishingOutItemId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.FinishingTo == "GUDANG JADI" && a.UnitId == request.unit && a.FinishingOutDate <= date
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyFinishing = c.Quantity, Size = c.SizeName
};
var QueryFinishingOut = from a in garmentFinishingOutRepository.Query
join b in garmentFinishingOutItemRepository.Query on a.Identity equals b.FinishingOutId
where (request.ro == null || (request.ro != null && request.ro != "" && a.RONo == request.ro)) && a.FinishingTo == "GUDANG JADI" && a.UnitId == request.unit && a.FinishingOutDate <= date && a.IsDifferentSize == false
select new monitoringView {
Ro = a.RONo, Article = a.Article, Comodity = a.ComodityName, BuyerCode = (from cost in costCalculation.data where cost.ro == a.RONo select cost.buyerCode).FirstOrDefault(), QtyOrder = (from cost in costCalculation.data where cost.ro == a.RONo select cost.qtyOrder).FirstOrDefault(), QtyFinishing = b.Quantity, Size = b.SizeName
};
var queryNow = QueryCuttingOut.Union(QueryLoading).Union(QuerySewingOutIsDifSize).Union(QuerySewingOut).Union(QueryFinishingOut).Union(QueryFinishingOutisDifSize).AsEnumerable();
var querySum = queryNow.GroupBy(x => new { x.Size, x.Ro, x.Article, x.BuyerCode, x.Comodity, x.QtyOrder }, (key, group) => new
{
ro = key.Ro,
article = key.Article,
buyer = key.BuyerCode,
comodity = key.Comodity,
qtyOrder = key.QtyOrder,
qtycutting = group.Sum(s => s.QtyCutting),
qtySewing = group.Sum(s => s.QtySewing),
qtyLoading = group.Sum(s => s.QtyLoading),
qtyFinishing = group.Sum(s => s.QtyFinishing),
size = key.Size,
});
var querySumTotal = queryNow.GroupBy(x => new { x.Ro, x.Article, x.BuyerCode, x.Comodity, x.QtyOrder }, (key, group) => new
{
ro = key.Ro,
article = key.Article,
buyer = key.BuyerCode,
comodity = key.Comodity,
qtyOrder = key.QtyOrder,
qtycutting = group.Sum(s => s.QtyCutting),
qtySewing = group.Sum(s => s.QtySewing),
qtyLoading = group.Sum(s => s.QtyLoading),
qtyFinishing = group.Sum(s => s.QtyFinishing),
size = "TOTAL"
});
var query = querySum.Union(querySumTotal).OrderBy(s => s.ro);
GarmentMonitoringProductionFlowListViewModel garmentMonitoringProductionFlow = new GarmentMonitoringProductionFlowListViewModel();
List <GarmentMonitoringProductionFlowDto> monitoringDtos = new List <GarmentMonitoringProductionFlowDto>();
foreach (var item in query)
{
GarmentMonitoringProductionFlowDto garmentMonitoringDto = new GarmentMonitoringProductionFlowDto()
{
Article = item.article,
Ro = item.ro,
BuyerCode = item.buyer,
QtyOrder = item.qtyOrder,
QtyCutting = item.qtycutting,
QtySewing = item.qtySewing,
QtyFinishing = item.qtyFinishing,
QtyLoading = item.qtyLoading,
Size = item.size,
Comodity = item.comodity,
Wip = item.qtycutting - item.qtyFinishing
};
monitoringDtos.Add(garmentMonitoringDto);
}
garmentMonitoringProductionFlow.garmentMonitorings = monitoringDtos;
return(garmentMonitoringProductionFlow);
}