private IQueryOver <VodovozOrder> GetOrdersQuery(IUnitOfWork uow)
{
OrderForRouteListJournalNode resultAlias = null;
VodovozOrder orderAlias = null;
Nomenclature nomenclatureAlias = null;
OrderItem orderItemAlias = null;
Counterparty counterpartyAlias = null;
DeliveryPoint deliveryPointAlias = null;
DeliverySchedule deliveryScheduleAlias = null;
Employee authorAlias = null;
Employee lastEditorAlias = null;
District districtAlias = null;
Nomenclature sanitizationNomenclature =
new NomenclatureParametersProvider(new ParametersProvider()).GetSanitisationNomenclature(uow);
var query = uow.Session.QueryOver <VodovozOrder>(() => orderAlias);
if (FilterViewModel.ViewTypes != ViewTypes.Order && FilterViewModel.ViewTypes != ViewTypes.All)
{
query.Where(o => o.Id == -1);
}
if (FilterViewModel.RestrictStatus != null)
{
query.Where(o => o.OrderStatus == FilterViewModel.RestrictStatus);
}
if (FilterViewModel.RestrictPaymentType != null)
{
query.Where(o => o.PaymentType == FilterViewModel.RestrictPaymentType);
}
if (FilterViewModel.HideStatuses != null)
{
query.WhereRestrictionOn(o => o.OrderStatus).Not.IsIn(FilterViewModel.HideStatuses);
}
if (FilterViewModel.RestrictOnlySelfDelivery != null)
{
query.Where(o => o.SelfDelivery == FilterViewModel.RestrictOnlySelfDelivery);
}
if (FilterViewModel.RestrictWithoutSelfDelivery != null)
{
query.Where(o => o.SelfDelivery != FilterViewModel.RestrictWithoutSelfDelivery);
}
if (FilterViewModel.RestrictCounterparty != null)
{
query.Where(o => o.Client == FilterViewModel.RestrictCounterparty);
}
if (FilterViewModel.DeliveryPoint != null)
{
query.Where(o => o.DeliveryPoint == FilterViewModel.DeliveryPoint);
}
if (FilterViewModel.RestrictStartDate != null)
{
query.Where(o => o.DeliveryDate >= FilterViewModel.RestrictStartDate);
}
if (FilterViewModel.RestrictEndDate != null)
{
query.Where(o => o.DeliveryDate <= FilterViewModel.RestrictEndDate.Value.AddDays(1).AddTicks(-1));
}
if (FilterViewModel.RestrictLessThreeHours == true)
{
query.Where(Restrictions
.GtProperty(Projections.SqlFunction(
new SQLFunctionTemplate(NHibernateUtil.Time, "ADDTIME(?1, ?2)"),
NHibernateUtil.Time,
Projections.Property(() => deliveryScheduleAlias.From),
Projections.Constant("3:0:0")),
Projections.Property(() => deliveryScheduleAlias.To)));
}
if (FilterViewModel.RestrictHideService != null)
{
if (FilterViewModel.RestrictHideService.Value)
{
query.Where(o => o.OrderAddressType != OrderAddressType.Service);
}
else
{
query.Where(o => o.OrderAddressType == OrderAddressType.Service);
}
}
if (FilterViewModel.RestrictOnlyService != null)
{
if (FilterViewModel.RestrictOnlyService.Value)
{
query.Where(o => o.OrderAddressType == OrderAddressType.Service);
}
else
{
query.Where(o => o.OrderAddressType != OrderAddressType.Service);
}
}
if (FilterViewModel.OrderPaymentStatus != null)
{
query.Where(o => o.OrderPaymentStatus == FilterViewModel.OrderPaymentStatus);
}
var bottleCountSubquery = QueryOver.Of <OrderItem>(() => orderItemAlias)
.Where(() => orderAlias.Id == orderItemAlias.Order.Id)
.JoinAlias(() => orderItemAlias.Nomenclature, () => nomenclatureAlias)
.Where(() => nomenclatureAlias.Category == NomenclatureCategory.water && nomenclatureAlias.TareVolume == TareVolume.Vol19L)
.Select(Projections.Sum(() => orderItemAlias.Count));
var sanitisationCountSubquery = QueryOver.Of <OrderItem>(() => orderItemAlias)
.Where(() => orderAlias.Id == orderItemAlias.Order.Id)
.Where(() => orderItemAlias.Nomenclature.Id == sanitizationNomenclature.Id)
.Select(Projections.Sum(() => orderItemAlias.Count));
var orderSumSubquery = QueryOver.Of <OrderItem>(() => orderItemAlias)
.Where(() => orderItemAlias.Order.Id == orderAlias.Id)
.Select(
Projections.Sum(
Projections.SqlFunction(
new SQLFunctionTemplate(NHibernateUtil.Decimal, "?1 * ?2 - IF(?3 IS NULL OR ?3 = 0, IFNULL(?4, 0), ?3)"),
NHibernateUtil.Decimal,
Projections.Property <OrderItem>(x => x.Count),
Projections.Property <OrderItem>(x => x.Price),
Projections.Property <OrderItem>(x => x.DiscountMoney),
Projections.Property <OrderItem>(x => x.OriginalDiscountMoney)
)
)
);
query.Left.JoinAlias(o => o.DeliveryPoint, () => deliveryPointAlias)
.Left.JoinAlias(o => o.DeliverySchedule, () => deliveryScheduleAlias)
.Left.JoinAlias(o => o.Client, () => counterpartyAlias)
.Left.JoinAlias(o => o.Author, () => authorAlias)
.Left.JoinAlias(o => o.LastEditor, () => lastEditorAlias)
.Left.JoinAlias(() => deliveryPointAlias.District, () => districtAlias);
query.Where(GetSearchCriterion(
() => orderAlias.Id,
() => counterpartyAlias.Name,
() => deliveryPointAlias.CompiledAddress,
() => authorAlias.LastName,
() => orderAlias.DriverCallId,
() => orderAlias.OnlineOrder,
() => orderAlias.EShopOrder,
() => orderAlias.OrderPaymentStatus
));
if (FilterViewModel.IncludeDistrictsIds != null && FilterViewModel.IncludeDistrictsIds.Any())
{
query = query.Where(() => deliveryPointAlias.District.Id.IsIn(FilterViewModel.IncludeDistrictsIds));
}
// Для того чтобы уже добавленные в МЛ заказы больше не появлялись
if (FilterViewModel.ExceptIds != null && FilterViewModel.ExceptIds.Any())
{
query.Where(o => !RestrictionExtensions.IsIn(o.Id, FilterViewModel.ExceptIds));
}
var resultQuery = query
.SelectList(list => list
.Select(() => orderAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => orderAlias.SelfDelivery).WithAlias(() => resultAlias.IsSelfDelivery)
.Select(() => deliveryScheduleAlias.Name).WithAlias(() => resultAlias.DeliveryTime)
.Select(() => orderAlias.OrderStatus).WithAlias(() => resultAlias.StatusEnum)
.Select(() => orderAlias.Address1c).WithAlias(() => resultAlias.Address1c)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorLastName)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => counterpartyAlias.Name).WithAlias(() => resultAlias.Counterparty)
.Select(() => districtAlias.DistrictName).WithAlias(() => resultAlias.DistrictName)
.Select(() => deliveryPointAlias.CompiledAddress).WithAlias(() => resultAlias.CompilledAddress)
.Select(() => deliveryPointAlias.City).WithAlias(() => resultAlias.City)
.Select(() => deliveryPointAlias.Street).WithAlias(() => resultAlias.Street)
.Select(() => deliveryPointAlias.Building).WithAlias(() => resultAlias.Building)
.SelectSubQuery(orderSumSubquery).WithAlias(() => resultAlias.Sum)
.SelectSubQuery(bottleCountSubquery).WithAlias(() => resultAlias.BottleAmount)
.SelectSubQuery(sanitisationCountSubquery).WithAlias(() => resultAlias.SanitisationAmount)
)
.OrderBy(x => x.CreateDate).Desc
.TransformUsing(Transformers.AliasToBean <OrderForRouteListJournalNode <VodovozOrder> >());
return(resultQuery);
}
public static void Main(string[] args)
{
logger.Debug("Start");
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
try {
IniConfigSource driverConfFile = new IniConfigSource(driverConfigFile);
driverConfFile.Reload();
IConfig mysqlConfig = driverConfFile.Configs["Mysql"];
mysqlServerHostName = mysqlConfig.GetString("mysql_server_host_name");
mysqlServerPort = mysqlConfig.GetString("mysql_server_port", "3306");
mysqlUser = mysqlConfig.GetString("mysql_user");
mysqlPassword = mysqlConfig.GetString("mysql_password");
mysqlDatabase = mysqlConfig.GetString("mysql_database");
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = mysqlServerHostName;
conStrBuilder.Port = UInt32.Parse(mysqlServerPort);
conStrBuilder.Database = mysqlDatabase;
conStrBuilder.UserID = mysqlUser;
conStrBuilder.Password = mysqlPassword;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = MySQLConfiguration.Standard
.Dialect <MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new [] {
Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
QS.HistoryLog.HistoryMain.Enable();
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка в настройке подключения к БД.");
}
try {
INomenclatureParametersProvider nomenclatureParametersProvider =
new NomenclatureParametersProvider(new ParametersProvider());
INomenclatureRepository nomenclatureRepository = new NomenclatureRepository(nomenclatureParametersProvider);
ImporterDataFromOnlineStore importer = new ImporterDataFromOnlineStore(
nomenclatureParametersProvider,
nomenclatureRepository
);
importer.Start();
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
