public async Task <List <MachineInformationModel> > GetListMachineID(string factory, string building, string machine_type)
{
var machines = await _repoMachineInfomation.FindAll()
.Where(x => x.factory_id.Trim() == factory.Trim() &&
x.building_id.Trim() == building.Trim() &&
x.machine_type.ToString() == machine_type.Trim())
.Select(x => new MachineInformationModel()
{
machine_type = x.machine_type,
machine_id = x.machine_id,
machine_name = x.machine_name
}).Distinct().ToListAsync();
return(machines);
}
public async Task <object> GetDownTimeAnalysis(string factory, string building, int?machine_type, string machine, int?shift, string date, string dateTo)
{
DateTime timeFrom = Convert.ToDateTime(date);
DateTime timeTo = Convert.ToDateTime(dateTo);
var queryActionTime = _repoActionTime.FindAll().Where(x => timeFrom <= x.shift_date && timeTo >= x.shift_date);
var queryDowtimeRecord = _repoDownTimeRecord.FindAll();
if (factory != null && factory != "ALL")
{
queryActionTime = queryActionTime.Where(x => x.factory_id.Trim() == factory.Trim());
}
if (building != null && building != "ALL")
{
queryActionTime = queryActionTime.Where(x => x.building_id.Trim() == building.Trim());
}
if (shift != 0)
{
queryActionTime = queryActionTime.Where(x => x.shift_id == shift);
}
if (machine_type != 0)
{
var listMachines = await _repoMachineInformation.FindAll().Where(x => x.machine_type == machine_type).Select(x => x.machine_id).ToListAsync();
if (machine != "ALL" && machine != null)
{
listMachines = listMachines.Where(x => x.Trim() == machine.Trim()).ToList();
}
queryActionTime = queryActionTime.Where(x => listMachines.Contains(x.machine_id));
}
//Join table ActionTime vs DowTimeRecord => id,duration , idDowtime
var queryJoin = queryActionTime.Join(queryDowtimeRecord, x => x.id, y => y.action_time_id, (x, y) => new
{
x.id,
y.downtime_reason_id,
x.duration_sec
}
).ToList();
//GetData Reason
var data = await GetListReason();
foreach (var item in data)
{
decimal?num = queryJoin.Where(x => x.downtime_reason_id == item.id).Sum(x => x.duration_sec);
item.duration = num;
}
//Group by Reason1
var dataGroup = data.GroupBy(x => x.reason_1).ToList();
List <ReasonAnalysis_Dto> result = new List <ReasonAnalysis_Dto>();
foreach (var item in dataGroup)
{
ReasonAnalysis_Dto rea_2 = new ReasonAnalysis_Dto();
var num = item.Sum(x => x.duration);
rea_2.reason_1 = item.Key;
rea_2.duration = num.Value;
result.Add(rea_2);
}
// Chuyển Material, Machine, Manpower lên trên cùng.
// Mehod và Others xuống dưới
// List<ReasonAnalysis_Dto> result1 = new List<ReasonAnalysis_Dto>();
// var countResult = result.Count();
// for (int i = countResult - 3; i < countResult; i++)
// {
// result1.Add(result[i]);
// }
// for (int i = 0; i < countResult-3; i++)
// {
// result1.Add(result[i]);
// }
return(new
{
resA = data.OrderByDescending(x => x.duration).Take(10),
resB = result.OrderByDescending(x => x.duration)
});
}