public string GetPersonalNumber(SettingsWorkwearItemsViewModel settings, SheetRowWorkwearItems row, int columnIndex)
{
var original = settings.ConvertPersonnelNumber ?
EmployeeParse.ConvertPersonnelNumber(row.CellStringValue(columnIndex)) : row.CellStringValue(columnIndex);
return(original?.Trim());
}
public ImportModelWorkwearItems(DataParserWorkwearItems dataParser, SettingsWorkwearItemsViewModel settingsWorkwearItemsViewModel) : base(dataParser, typeof(CountersWorkwearItems), settingsWorkwearItemsViewModel)
{
this.dataParser = dataParser ?? throw new ArgumentNullException(nameof(dataParser));
this.settingsWorkwearItemsViewModel = settingsWorkwearItemsViewModel ?? throw new ArgumentNullException(nameof(settingsWorkwearItemsViewModel));
}
public void MatchChanges(
IProgressBarDisplayable progress,
SettingsWorkwearItemsViewModel settings,
CountersViewModel counters,
IUnitOfWork uow,
IEnumerable <SheetRowWorkwearItems> list,
List <ImportedColumn <DataTypeWorkwearItems> > columns)
{
var personnelNumberColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.PersonnelNumber);
var protectionToolsColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.ProtectionTools);
var nomenclatureColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Nomenclature);
var issueDateColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.IssueDate);
var countColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Count);
var postColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Post);
var subdivisionColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Subdivision);
var sizeAndGrowthColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.SizeAndGrowth);
var sizeColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Size);
var growthColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Growth);
progress.Start(list.Count() * 2 + 3, text: "Загрузка сотрудников");
var personnelNumbers = list.Select(x => GetPersonalNumber(settings, x, personnelNumberColumn.Index))
.Where(x => !String.IsNullOrWhiteSpace(x)).Distinct().ToArray();
var employees = uow.Session.QueryOver <EmployeeCard>()
.Where(x => x.PersonnelNumber.IsIn(personnelNumbers))
.Fetch(SelectMode.Fetch, x => x.WorkwearItems)
.List();
foreach (var row in list)
{
progress.Add(text: "Сопоставление");
row.Date = ParseDateOrNull(row.CellStringValue(issueDateColumn.Index));
if (row.Date == null)
{
row.ProgramSkipped = true;
row.AddColumnChange(issueDateColumn, ChangeType.ParseError);
continue;
}
if (row.CellIntValue(countColumn.Index) == null)
{
row.ProgramSkipped = true;
row.AddColumnChange(countColumn, ChangeType.ParseError);
continue;
}
row.Employee = employees.FirstOrDefault(x => x.PersonnelNumber == GetPersonalNumber(settings, row, personnelNumberColumn.Index));
if (row.Employee == null)
{
logger.Warn(
$"Не найден сотрудник в табельным номером [{GetPersonalNumber(settings, row, personnelNumberColumn.Index)}]. Пропускаем.");
row.ProgramSkipped = true;
row.AddColumnChange(personnelNumberColumn, ChangeType.NotFound);
counters.AddCount(CountersWorkwearItems.EmployeeNotFound);
continue;
}
var protectionToolName = row.CellStringValue(protectionToolsColumn.Index);
row.WorkwearItem = row.Employee.WorkwearItems.FirstOrDefault(x => x.ProtectionTools.Name == protectionToolName);
if (row.WorkwearItem == null && postColumn != null && subdivisionColumn != null)
{
if (!TryAddNorm(uow, row.CellStringValue(postColumn.Index),
row.CellStringValue(subdivisionColumn.Index), row.Employee))
{
row.AddColumnChange(postColumn, ChangeType.NotFound);
row.AddColumnChange(subdivisionColumn, ChangeType.NotFound);
}
else
{
counters.AddCount(CountersWorkwearItems.EmployeesAddNorm);
}
}
if (row.WorkwearItem != null)
{
continue;
}
row.ProgramSkipped = true;
row.AddColumnChange(protectionToolsColumn, ChangeType.NotFound);
}
progress.Add(text: "Загрузка номенклатуры");
var nomenclatureTypes = new NomenclatureTypes(uow, sizeService, true);
var nomenclatureNames =
list.Select(x => x.CellStringValue(nomenclatureColumn.Index)).Where(x => x != null).Distinct().ToArray();
var nomenclatures = nomenclatureRepository.GetNomenclatureByName(uow, nomenclatureNames);
progress.Add(text: "Загрузка операций выдачи");
var dates = list
.Select(x => x.Date)
.Where(x => x != null)
.Select(x => x.Value);
var startDate = dates.Min();
var endDate = dates.Max();
var employeeIds = list.Where(x => x.Employee != null)
.Select(x => x.Employee.Id).Distinct().ToArray();
var operations = uow.Session.QueryOver <EmployeeIssueOperation>()
.Where(x => x.Employee.Id.IsIn(employeeIds))
.Where(x => x.OperationTime >= startDate)
.Where(x => x.OperationTime < endDate.AddDays(1))
.List()
.GroupBy(x => x.Employee);
foreach (var row in list)
{
progress.Add(text: "Обработка операций выдачи");
if (row.Skipped)
{
continue;
}
var nomenclatureName = row.CellStringValue(nomenclatureColumn.Index);
if (String.IsNullOrWhiteSpace(nomenclatureName))
{
row.AddColumnChange(nomenclatureColumn, ChangeType.NotFound);
continue;
}
var nomenclature =
UsedNomeclature.FirstOrDefault(x => String.Equals(x.Name, nomenclatureName, StringComparison.CurrentCultureIgnoreCase));
if (nomenclature == null)
{
nomenclature =
nomenclatures.FirstOrDefault(x => String.Equals(x.Name, nomenclatureName, StringComparison.CurrentCultureIgnoreCase));
if (nomenclature == null)
{
nomenclature = new Nomenclature {
Name = nomenclatureName,
Type = row.WorkwearItem.ProtectionTools.Type,
Comment = "Создана при импорте выдачи из Excel",
};
nomenclature.Sex = nomenclatureTypes.ParseSex(nomenclature.Name) ?? ClothesSex.Universal;
row.WorkwearItem.ProtectionTools.AddNomeclature(nomenclature);
}
UsedNomeclature.Add(nomenclature);
}
row.Operation = operations.FirstOrDefault(group => group.Key == row.Employee)
?.FirstOrDefault(x => x.OperationTime.Date == row.Date && x.Nomenclature == nomenclature);
if (row.Operation != null)
{
//TODO Обновление операций не реализовано
continue;
}
if (row.Operation != null)
{
continue;
}
{
var count = row.CellIntValue(countColumn.Index).Value;
var expenseDate = row.WorkwearItem.ActiveNormItem.CalculateExpireDate(row.Date.Value, count);
row.Operation = new EmployeeIssueOperation {
OperationTime = row.Date.Value,
Employee = row.Employee,
Issued = count,
Nomenclature = nomenclature,
AutoWriteoffDate = expenseDate,
ExpiryByNorm = expenseDate,
NormItem = row.WorkwearItem.ActiveNormItem,
ProtectionTools = row.WorkwearItem.ProtectionTools,
Returned = 0,
StartOfUse = row.Date,
UseAutoWriteoff = expenseDate != null,
};
//Обрабатываем размер.
if (TryParseSizeAndGrowth(uow, row, columns, out var sizeAndGrowth))
{
row.Operation.WearSize = sizeAndGrowth.Size;
row.Operation.Height = sizeAndGrowth.Growth;
var sizeOk = nomenclature.Type.SizeType == sizeAndGrowth.Size.SizeType;
var growthOk = nomenclature.Type.HeightType == sizeAndGrowth.Growth.SizeType;
if (sizeAndGrowthColumn != null)
{
row.ChangedColumns.Add(sizeAndGrowthColumn, new ChangeState(sizeOk && growthOk ? ChangeType.NewEntity : ChangeType.ParseError));
}
if (sizeColumn != null)
{
row.ChangedColumns.Add(sizeColumn, new ChangeState(sizeOk ? ChangeType.NewEntity : ChangeType.ParseError));
}
if (growthColumn != null)
{
row.ChangedColumns.Add(growthColumn, new ChangeState(growthOk ? ChangeType.NewEntity : ChangeType.ParseError));
}
}
//Проставляем размер в сотрудника.
if (row.Operation.Height != null)
{
var employeeSize = row.Employee.Sizes.FirstOrDefault(x => x.SizeType == row.Operation.Height.SizeType);
if (employeeSize is null)
{
employeeSize = new EmployeeSize
{
Size = row.Operation.Height, SizeType = row.Operation.Height.SizeType, Employee = row.Employee
};
row.Employee.Sizes.Add(employeeSize);
}
else
{
employeeSize.Size = row.Operation.Height;
}
ChangedEmployees.Add(row.Employee);
counters.AddCount(CountersWorkwearItems.EmployeesSetSize);
}
if (row.Operation.WearSize != null)
{
var employeeSize = row.Employee.Sizes.FirstOrDefault(x => x.SizeType == row.Operation.WearSize.SizeType);
if (employeeSize is null)
{
employeeSize = new EmployeeSize
{
Size = row.Operation.WearSize, SizeType = row.Operation.WearSize.SizeType, Employee = row.Employee
};
row.Employee.Sizes.Add(employeeSize);
}
else
{
employeeSize.Size = row.Operation.WearSize;
}
ChangedEmployees.Add(row.Employee);
counters.AddCount(CountersWorkwearItems.EmployeesSetSize);
}
var toSetChangeColumns = columns.Where(
x => x.DataType != DataTypeWorkwearItems.Unknown &&
x.DataType != DataTypeWorkwearItems.SizeAndGrowth &&
x.DataType != DataTypeWorkwearItems.Size &&
x.DataType != DataTypeWorkwearItems.Growth
);
foreach (var column in toSetChangeColumns)
{
if (!row.ChangedColumns.ContainsKey(column))
{
row.ChangedColumns.Add(column, new ChangeState(ChangeType.NewEntity));
}
}
}
}
progress.Close();
}
