/// <summary>
/// Данные по станкам
/// </summary>
private static async Task GetPlaneStationsData(RouteData result, List <PlaneStantionOnTrip> planeStations,
int tripId, ILogger logger)
{
var sqlRStations = new StantionsRepository(logger);
var sqlRTrips = new TripsRepository(logger);
var sqlRTrains = new TrainRepository(logger);
var sqlRChangedStantion = new ChangePlaneStantionOnTripsRepository(logger);
var sqlRPlanedRouteTrains = new PlanedRouteTrainsRepository(logger);
var planedTripWithStation = new PlanedTripWithStations
{
TripName = (await sqlRTrips.ById(tripId)).Name,
PlaneStations = new List <PlanedStation>()
};
var currentTripPlaneStations = planeStations.Where(x => x.TripId == tripId);
foreach (var currentTripPlaneStation in currentTripPlaneStations)
{
var changedStationData = await sqlRChangedStantion.ByPlaneStantionOnTripId(currentTripPlaneStation.Id);
var toAdd = new PlanedStation
{
PlanedStationId = currentTripPlaneStation.Id,
StationName = (await sqlRStations.ById(currentTripPlaneStation.StantionId)).Name,
InTime = currentTripPlaneStation.InTime,
OutTime = currentTripPlaneStation.OutTime,
ChangeStationsId = changedStationData?.Id,
ChangedInTime = changedStationData?.InTime,
ChangedOutTime = changedStationData?.OutTime,
ChangeDroped = changedStationData?.Droped,
ChangeTrainId = changedStationData?.TrainId
};
//TODO надо уточнить стоит ли так делать. Возвращать нулл если поезд нихуя непоменялся
var planedRouteTrain = await sqlRPlanedRouteTrains.ById(currentTripPlaneStation.PlanedRouteTrainId);
if (planedRouteTrain.TrainId == toAdd.ChangeTrainId)
{
toAdd.ChangeTrainId = null;
}
if (toAdd.ChangeTrainId != null)
{
toAdd.ChangeTranName = (await sqlRTrains.ById(toAdd.ChangeTrainId)).Name;
}
planedTripWithStation.PlaneStations.Add(toAdd);
}
result.PlaneRoute.TripsWithStations.Add(planedTripWithStation);
}
/// <summary>
/// То2 таблица
/// </summary>
private static async Task <ChangedTo2OrCtoDto> GetTo2OrCto(GetRouteInformationTableRequest input, ILogger logger)
{
var sqlRPlaneInspections = new PlanedInspectionRoutesRepository(logger);
var sqlRChangedInspections = new ChangedPlanedInspectionRoutesRepository(logger);
var planedInspection = await sqlRPlaneInspections.ById(input.EntityId);
var changedInspection = await sqlRChangedInspections.ByPlanedInspectionRouteId(planedInspection.Id);
var sqlRTrains = new TrainRepository(logger);
var sqlRPlanedRouteTrains = new PlanedRouteTrainsRepository(logger);
var sqlRRoute = new RoutesRepository(logger);
var planedRouteTrain = await sqlRPlanedRouteTrains.ById(input.PlanedRouteTrainId);
var route = await sqlRRoute.ById(planedRouteTrain.RouteId);
var train = await sqlRTrains.ById(planedRouteTrain.TrainId);
var result = new ChangedTo2OrCtoDto
{
Id = planedInspection.Id,
RouteName = route.Name,
TrainName = train.Name,
Plan = new ChangedTo2OrCtoDto.Planned
{
DateStart = planedInspection.Start.ToFuckingGenaFormat(planedRouteTrain.Date),
DateEnd = planedInspection.End.ToFuckingGenaFormat(planedRouteTrain.Date)
},
Fact = new ChangedTo2OrCtoDto.Actual
{
DateStart = planedInspection.Start.ToFuckingGenaFormat(planedRouteTrain.Date),
DateEnd = planedInspection.End.ToFuckingGenaFormat(planedRouteTrain.Date),
Canseled = false
}
};
if (changedInspection != null)
{
result.Fact.DateStart = changedInspection.Start.ToFuckingGenaFormat(planedRouteTrain.Date);
result.Fact.DateEnd = changedInspection.End.ToFuckingGenaFormat(planedRouteTrain.Date);
if (changedInspection.Droped)
{
result.Fact.Canseled = changedInspection.Droped;
}
}
return(result);
}
//В эксельку кто когда сваливает с депо
public async Task <ReportResponse> EscapeFromDepoReport(ExcelDataRequest input)
{
var sqlRPlaneTrain = new PlanedRouteTrainsRepository(_logger);
var sqlRRoute = new RoutesRepository(_logger);
var sqlRTrain = new TrainRepository(_logger);
var sqlRTrip = new TripsRepository(_logger);
var sqlRUser = new UserRepository(_logger);
var sqlRPlaneStation = new PlanedStationOnTripsRepository(_logger);
var sqlRPlaneBrigade = new PlaneBrigadeTrainsRepository(_logger);
if (input.Date == null)
{
throw new ValidationException("Не задан StartDate");
}
var result = new ReportResponse {
Rows = new List <Row>()
};
result.Columns = new List <Column>
{
new Column("col0", "Маршрут", "string"),
//№ поезда(Походу рейс https://alcodevelop.atlassian.net/browse/CPPK-4)
new Column("col1", "№ поезда", "string"),
new Column("col2", "Машинист", "string"),
new Column("col3", "Состав", "string"),
new Column("col4", "КП", "string"),
};
//Бля ну получим все поезда наверно
var planeTrains = await sqlRPlaneTrain.GetAll();
//За указанные сутки
planeTrains = planeTrains.Where(x => x.Date.Date == input.Date.Date).ToList();
foreach (var planeTrain in planeTrains)
{
var route = await sqlRRoute.ById(planeTrain.RouteId);
var train = await sqlRTrain.ById(planeTrain.TrainId);
//Берем все станки маршрута
var planeStations = await sqlRPlaneStation.ByPlannedRouteTrainId(planeTrain.Id);
var startStation = planeStations.OrderBy(x => x.OutTime).FirstOrDefault();
var trip = new Trip();
if (startStation != null)
{
trip = await sqlRTrip.ById(startStation.TripId);
}
var planeBrigades = await sqlRPlaneBrigade.ByPlanedRouteTrainId(planeTrain.Id);
//TODO брать 1-го юзера и делать машинистом, както неправильно) хДД
User motorman = null;
if (planeBrigades.Count != 0)
{
motorman = await sqlRUser.ById(planeBrigades.First().UserId);
}
var toadd = new Row
{
Id = new RowId(DateTime.Now.Ticks.GetHashCode(), 2),
HasItems = false.ToString(),
ParentId = null,
//Маршрут
Col0 = route.Name,
//№ поезда(Походу рейс https://alcodevelop.atlassian.net/browse/CPPK-4)
Col1 = trip.Name,
//Машинист
Col2 = motorman?.Name,
//Состав
Col3 = train.Name,
//КП
Col4 = startStation?.OutTime.ToStringTimeOnly()
};
result.Rows.Add(toadd);
}
return(result);
}
/// <summary>
/// Рейсы со станками таблица
/// </summary>
private static async Task <RouteInformationTableTrip> GetTripData(GetRouteInformationTableRequest input, ILogger logger)
{
var sqlRStations = new StantionsRepository(logger);
var sqlRTrips = new TripsRepository(logger);
var sqlRTrains = new TrainRepository(logger);
var sqlRChangedStation = new ChangePlaneStantionOnTripsRepository(logger);
var sqlRPlannedRouteTrains = new PlanedRouteTrainsRepository(logger);
var sqlRPlannedStations = new PlanedStationOnTripsRepository(logger);
var result = new RouteInformationTableTrip
{
Stantions = new List <RouteInformationTableStantion>(),
DataSource = new DataSource()
};
var plannedRouteTrain = await sqlRPlannedRouteTrains.ById(input.PlanedRouteTrainId);
var plannedStations = await sqlRPlannedStations.ByPlannedRouteTrainId(input.PlanedRouteTrainId);
var tripId = plannedStations.Where(x => x.TripId == input.EntityId).Select(x => x.TripId).ToList();
if (!tripId.Any())
{
return(result);
}
var trip = await sqlRTrips.ById(tripId.First());
result.Trip = trip.Name;
var currentTripPlaneStations = plannedStations.Where(x => x.TripId == trip.Id);
foreach (var currentTripPlaneStation in currentTripPlaneStations)
{
var planTrain = await sqlRTrains.ById(plannedRouteTrain.TrainId);
var changedStationData =
await sqlRChangedStation.ByPlaneStantionOnTripId(currentTripPlaneStation.Id);
//String changedTrainName;
//if (changedStationData?.TrainId != null)
// changedTrainName = (await sqlRTrains.ById(changedStationData.TrainId)).Name;
var toAdd = new RouteInformationTableStantion
{
Id = currentTripPlaneStation.Id,
Name = (await sqlRStations.ById(currentTripPlaneStation.StantionId)).Name,
Train = planTrain.Name,
StartPlan = currentTripPlaneStation.InTime.ToStringTimeOnly(),
EndPlan = currentTripPlaneStation.OutTime.ToStringTimeOnly(),
TrainId = planTrain.Id,
StartFact = currentTripPlaneStation.InTime.ToFuckingGenaFormat(plannedRouteTrain.Date.Date),
EndFact = currentTripPlaneStation.OutTime.ToFuckingGenaFormat(plannedRouteTrain.Date.Date),
Canceled = false,
PlaneStationOnTripId = currentTripPlaneStation.Id
};
if (changedStationData != null)
{
toAdd.StartFact = changedStationData.InTime.ToFuckingGenaFormat(plannedRouteTrain.Date.Date);
toAdd.EndFact = changedStationData.OutTime.ToFuckingGenaFormat(plannedRouteTrain.Date.Date);
toAdd.Canceled = changedStationData.Droped;
if (changedStationData.TrainId != null)
{
toAdd.TrainId = (int)changedStationData.TrainId;
}
}
result.Stantions.Add(toAdd);
}
var availableTrains = await GetAvaibleTrains(plannedRouteTrain.TrainId, logger);
result.DataSource.Trains =
availableTrains.Select(x => new DataSourceDto {
Value = x.TrainId, Text = x.TrainName
}).ToList();
return(result);
}
/// <summary>
/// То1 таблица
/// </summary>
private static async Task <ReportResponse> GetTo1Table(int planedRouteTrainId, ILogger logger)
{
var sqlRTrains = new TrainRepository(logger);
var sqlRPlanedRouteTrains = new PlanedRouteTrainsRepository(logger);
var sqlRRoute = new RoutesRepository(logger);
var sqlRInspections = new InspectionRepository(logger);
var sqlRTaskAttributes = new TrainTaskAttributesRepository(logger);
var sqlRUser = new UserRepository(logger);
var result = new ReportResponse {
Rows = new List <Row>()
};
result.Columns = new List <Column>
{
new Column("col0", "Номер", "number"),
new Column("col1", "Состав", "string"),
new Column("col2", "Рейс", "string"),
new Column("col3", "Время начала", "date"),
new Column("col4", "Время окончания", "date"),
new Column("col5", "Количество созданных инцидентов", "number"),
new Column("col6", "Исполнитель", "string"),
new Column("col7", "Меток считано всего (в том числе при обходе и закрытии задач)", "number"),
};
var planedRouteTrain = await sqlRPlanedRouteTrains.ById(planedRouteTrainId);
var route = await sqlRRoute.ById(planedRouteTrain.RouteId);
//Надо получить ТО 1 на этот день или блядь для этого поезда. хуй его знает
var currentTrainInspections = await sqlRInspections.GetByTrainId(planedRouteTrain.TrainId);
//Выбираем за текущий денек
var currentDayInspections =
currentTrainInspections.Where(x => x.DateStart.Date.Equals(planedRouteTrain.CreateDate) && x.CheckListType == CheckListType.TO1);
foreach (var currentDayInspection in currentDayInspections)
{
var row = new Row
{
Id = new RowId(currentDayInspection.Id, 1),
HasItems = false.ToString(),
ParentId = null,
//Номер
Col0 = currentDayInspection.Id.ToString(),
//Состав
Col1 = (await sqlRTrains.ById(planedRouteTrain.TrainId)).Name,
//Рейс
Col2 = route.Name,
//Время начала
Col3 = currentDayInspection.DateStart.ToStringDateTime(),
//Время окончания
Col4 = currentDayInspection.DateEnd?.ToStringDateTime(),
//Количество созданных инцидентов
Col5 = (await sqlRTaskAttributes.ByInspectionId(currentDayInspection.Id))?.Count.ToString(),
//Исполнитель
Col6 = (await sqlRUser.ById(currentDayInspection.UserId))?.Name,
//Меток считано всего (в том числе при обходе и закрытии задач)
Col7 = "In Development",
};
result.Rows.Add(row);
}
return(result);
}
/// <summary>
/// Приемка/Сдача ЛБ таблица
/// </summary>
private static async Task <ReportResponse> GetLocomotvInspectionsTable(ReportRequest input, int planedRouteTrainId, ILogger logger)
{
var sqlRTrains = new TrainRepository(logger);
var sqlRPlanedRouteTrains = new PlanedRouteTrainsRepository(logger);
var sqlRRoute = new RoutesRepository(logger);
var sqlRInspections = new InspectionRepository(logger);
var sqlRTaskAttributes = new TrainTaskAttributesRepository(logger);
var sqlRUser = new UserRepository(logger);
var sqlRBrigade = new BrigadeRepository(logger);
var result = new ReportResponse {
Rows = new List <Row>()
};
result.Columns = new List <Column>
{
new Column("col0", "Состав", "string"),
new Column("col1", "Тип", "string"),
new Column("col2", "Время начала", "date"),
new Column("col3", "Время окончания", "date"),
new Column("col4", "Меток считано", "number"),
new Column("col5", "Новых инцидентов заведено (из них критических)", "number"),
new Column("col6", "Инцидентов на составе всего", "string"),
new Column("col7", "Километров всего", "number"),
new Column("col8", "Километров за смену", "number"),
new Column("col9", "КВт*ч (по каждому вагону)", "string"),
};
var planedRouteTrain = await sqlRPlanedRouteTrains.ById(planedRouteTrainId);
//var route = await sqlRRoute.ById(planedRouteTrain.RouteId);
var currentTrainInspections = await sqlRInspections.GetByTrainId(planedRouteTrain.TrainId);
var currentDayInspections =
currentTrainInspections.Where(x => x.DateStart.Date.Equals(planedRouteTrain.CreateDate));
foreach (var currentDayInspection in currentDayInspections)
{
var user = await sqlRUser.ById(currentDayInspection.UserId);
if (user.BrigadeId == null)
{
continue;
}
var brigade = await sqlRBrigade.ById((int)user.BrigadeId);
if (brigade.BrigadeType != BrigadeType.Locomotiv)
{
continue;
}
var row = new Row
{
Id = new RowId(currentDayInspection.Id, 1),
HasItems = false.ToString(),
ParentId = null,
//Состав
Col0 = (await sqlRTrains.ById(planedRouteTrain.TrainId)).Name,
//Тип
Col1 = GetStringInspectionType(currentDayInspection.CheckListType),
//Время начала
Col2 = currentDayInspection.DateStart.ToStringDateTime(),
//Время окончания
Col3 = currentDayInspection.DateEnd?.ToStringDateTime(),
//Меток считано
Col4 = "666",
//Новых инцидентов заведено (из них критических)
Col5 = "666",
//Инцидентов на составе всего
Col6 = "666",
//Километров всего
Col7 = "666",
//Километров за смену
Col8 = "666",
//КВт*ч (по каждому вагону)
Col9 = "In Development",
};
result.Rows.Add(row);
}
return(result);
}
public async Task <List <PlanedRouteTrainDto> > PlanedRouteTrainsTable(DateTime startTime, DateTime EndTime)
{
var sqlRPlanedRouteTrains = new PlanedRouteTrainsRepository(_logger);
var sqlRRoutes = new RoutesRepository(_logger);
var sqlRTrains = new TrainRepository(_logger);
var sqlRUsers = new UserRepository(_logger);
var sqlRDayOfROutes = new DayOfRoutesRepoisitory(_logger);
var sqlRStations = new StantionsRepository(_logger);
var sqlRPlaneStationsOnTrips = new PlanedStationOnTripsRepository(_logger);
var sqlRPlaneBrigadeTrains = new PlaneBrigadeTrainsRepository(_logger);
var planedRouteTrains = await sqlRPlanedRouteTrains.GetAll();
planedRouteTrains = planedRouteTrains.Where(x => x.Date >= startTime && x.Date < EndTime).ToList();
//var result = new List<PlanedRouteTrainDto>();
var dictionary = new Dictionary <int, PlanedRouteTrainDto>();
//var routeDictionary = planedRouteTrains.ToDictionary(e => e.RouteId);
//Собственно надо набить словарик доступными роутами
var routes = await sqlRRoutes.GetAll(0, Int32.MaxValue, null);
routes.Data = routes.Data.Where(x => x.TurnoverId != null).ToList();
foreach (var route in routes.Data)
{
var planedRouteTrainDto = new PlanedRouteTrainDto
{
Route = route,
RouteDays = new List <DayOfWeek>(),
DaysData = new List <DayData>()
};
if (route.TurnoverId != null)
{
var daysOfRoutes = await sqlRDayOfROutes.DaysByTurnoverId((int)route.TurnoverId);
var days = daysOfRoutes.Select(x => x.Day);
planedRouteTrainDto.RouteDays.AddRange(days);
var proccesDate = startTime;
while (proccesDate <= EndTime)
{
var currentDay = proccesDate.DayOfWeek;
if (days.Contains(currentDay))
{
planedRouteTrainDto.DaysData.Add(new DayData
{
Date = proccesDate.Date, DateString = proccesDate.Date.ToString()
});
}
proccesDate = proccesDate.AddDays(1);
}
}
if (dictionary.ContainsKey(route.Id))
{
dictionary[route.Id].DaysData.AddRange(planedRouteTrainDto.DaysData);
}
else
{
dictionary.Add(route.Id, planedRouteTrainDto);
}
}
foreach (var planedRouteTrain in planedRouteTrains)
{
//достаем роут
var route = await sqlRRoutes.ById(planedRouteTrain.RouteId);
//var currentRouteItems = planedRouteTrains.Where(e => e.RouteId == route.Id);
var planedRouteTrainDto = new PlanedRouteTrainDto
{
Route = route,
DaysData = new List <DayData>()
};
var toAdd = new DayData
{
Train = await sqlRTrains.ById(planedRouteTrain.TrainId),
PlanedRouteTrainId = planedRouteTrain.Id,
Date = planedRouteTrain.Date
};
toAdd.DateString = toAdd.Date.ToString("yyyy-MM-ddTHH:mm:ssZ");
var planeBrigadeTrains = await sqlRPlaneBrigadeTrains.ByPlanedRouteTrainId(planedRouteTrain.Id);
toAdd.Users = new List <DaysUser>();
foreach (var planeBrigadeTrain in planeBrigadeTrains)
{
var user = await sqlRUsers.ById(planeBrigadeTrain.UserId);
var userToAdd = new DaysUser
{
UserId = user.Id, Name = user.Name, PlaneBrigadeTrainsId = planeBrigadeTrain.Id
};
userToAdd.UserStations = new UserStations();
var planedStationInput = await sqlRPlaneStationsOnTrips.ById(planeBrigadeTrain.StantionStartId);
userToAdd.UserStations.InputTime = planedStationInput.OutTime;
userToAdd.UserStations.InputName = (await sqlRStations.ById(planedStationInput.StantionId)).Name;
var planedStationOutput = await sqlRPlaneStationsOnTrips.ById(planeBrigadeTrain.StantionEndId);
userToAdd.UserStations.OutputTime = planedStationOutput.InTime;
userToAdd.UserStations.OutputName = (await sqlRStations.ById(planedStationOutput.StantionId)).Name;
//userToAdd.UserStations.InputName = (await sqlRStations.ById(planeBrigadeTrain.StantionStartId)).Name;
//userToAdd.UserStations.OutputName = (await sqlRStations.ById(planeBrigadeTrain.StantionEndId)).Name;
toAdd.Users.Add(userToAdd);
}
planedRouteTrainDto.DaysData.Add(toAdd);
if (dictionary.ContainsKey(route.Id))
{
//надо взять текущие деньки роута и проверить что такого еще нет. кстати если его нет надо нахуй послать, а если есть заменить.
var currentDays = dictionary[route.Id].DaysData;
var day = currentDays.FirstOrDefault(x =>
x.Date.Date.Equals(planedRouteTrainDto.DaysData.First().Date.Date));
if (day == null)
{
dictionary[route.Id].DaysData.AddRange(planedRouteTrainDto.DaysData);
continue;
}
//throw new ValidationException("На этот день нельзя добавить поезд");
var index = dictionary[route.Id].DaysData.IndexOf(day);
dictionary[route.Id].DaysData[index] = planedRouteTrainDto.DaysData.First();
//dictionary[route.Id].DaysData.AddRange(planedRouteTrainDto.DaysData);
}
else
{
dictionary.Add(route.Id, planedRouteTrainDto);
}
}
//var train = await sqlRTrains.ByIdWithStations(planedRouteTrain.TrainId);
var result = new List <PlanedRouteTrainDto>();
result.AddRange(dictionary.Values);
return(result);
}
private static Train GetTrainById(TrainRepository sqlR, int?id)
{
return(sqlR.ById(id).Result);
}