[01.03.2024 10:30:30.975 +00:00 INF] Migrations [01.03.2024 10:30:31.123 +00:00 INF] 20240229001: Migration_GetAllByStatus (not applied) [01.03.2024 10:30:31.124 +00:00 INF] 20240229002: Migration_GetAll (not applied) [01.03.2024 10:30:31.131 +00:00 INF] 20240229003: Migration_GetOrdersByUserId (not applied) [01.03.2024 10:30:31.132 +00:00 INF] 20240105195988: Migration_20240105195988 [01.03.2024 10:30:31.132 +00:00 INF] 20240106150801: Migration_20240106150801 [01.03.2024 10:30:31.132 +00:00 INF] 20240222282856: Migration_20240222282856 [01.03.2024 10:30:31.132 +00:00 INF] 20240225185332: Migration_20240225185332 [01.03.2024 10:30:31.133 +00:00 INF] 20240226001548: Migration_20240226001548 [01.03.2024 10:30:31.133 +00:00 WRN] 202403091170645: Migration_202403091170645 (current) [01.03.2024 10:30:31.154 +00:00 INF] 20240229001: Migration_GetAllByStatus migrating [01.03.2024 10:30:31.161 +00:00 INF] Beginning Transaction [01.03.2024 10:30:31.173 +00:00 INF] BEGIN TRANSACTION [01.03.2024 10:30:31.205 +00:00 INF] ExecuteEmbeddedSqlScript Create_GetAllByStatus.sql [01.03.2024 10:30:31.245 +00:00 INF] CREATE PROCEDURE Order_GetAllByStatus ( @offset int = 0, @limit int = 10, --@orderStatus int, @categoryId int = null, @productName varchar(256) = null, @lan varchar(2) ) AS BEGIN SET NOCOUNT ON; DECLARE @categoryIds TABLE (Id int); WITH cteTree AS( SELECT pc.Id FROM ProductCategories pc WHERE pc.Id = @categoryId UNION ALL SELECT pc.Id FROM ProductCategories pc JOIN cteTree AS ct ON ct.id = pc.ParentId) INSERT INTO @categoryIds SELECT * FROM cteTree; SELECT o.CreatedDate, o.id, o.ImageUrl, SUM(oi.Count) AS TotalCount, STUFF( (SELECT DISTINCT ';' + t.TranslationInfo FROM OrderItems oi JOIN ProductCategories pc ON pc.id = oi.ProductCategoryId JOIN TextContents tc ON pc.TextContentId = tc.Id JOIN Translations t ON tc.Id = t.TextContentId WHERE oi.OrderId = o.Id AND oi.Deleted = 0 AND T.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) FOR XML PATH ('')) , 1, 1, '') AS CatList, STUFF( (SELECT DISTINCT '\' + oi.ImageUrl FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ImageList, STUFF( (SELECT DISTINCT '\' + oi.ProductName FROM OrderItems oi WHERE oi.OrderId = o.Id AND oi.Deleted = 0 FOR XML PATH ('')) , 1, 1, '') AS ProductNameList, u.Id AS CreatedUserId, u.DisplayName AS CreatedUserDisplayName, us.ProfileIMageUrl AS CreatedUserImageUrl FROM OrderItems oi JOIN Orders o on o.id = oi.OrderId AND o.Status in (3, 4) JOIN AppUsers u ON o.UserId = u.Id JOIN UserSettings us ON us.UserId = u.Id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) AND oi.Deleted = 0 GROUP BY oi.OrderId, o.Id, o.ImageUrl, o.CreatedDate, u.Id ,u.DisplayName, us.ProfileIMageUrl HAVING(SUM(oi.Count) > 0) ORDER BY oi.OrderId OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(distinct o.id) AS TotalCount FROM Orders o JOIN OrderItems oi on oi.orderid = o.id WHERE (oi.ProductCategoryId IN (SELECT * FROM @categoryIds) OR @categoryId IS NULL) AND o.Deleted = 0 AND oi.Deleted = 0 AND (oi.ProductName LIKE '%' + @productName + '%' OR @productName IS NULL) and o.Status in (3, 4) END GO [01.03.2024 10:30:31.391 +00:00 INF] => 0.1842138s [01.03.2024 10:30:31.419 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (20240229001, '2024-03-01T10:30:31', N'Migration_GetAllByStatus') [01.03.2024 10:30:31.429 +00:00 INF] Committing Transaction [01.03.2024 10:30:31.449 +00:00 INF] COMMIT TRANSACTION [01.03.2024 10:30:31.450 +00:00 INF] 20240229001: Migration_GetAllByStatus migrated [01.03.2024 10:30:31.450 +00:00 INF] => 0.244741s [01.03.2024 10:30:31.451 +00:00 INF] 20240229002: Migration_GetAll migrating [01.03.2024 10:30:31.451 +00:00 INF] Beginning Transaction [01.03.2024 10:30:31.458 +00:00 INF] BEGIN TRANSACTION [01.03.2024 10:30:31.463 +00:00 INF] ExecuteEmbeddedSqlScript Create_GetAll.sql [01.03.2024 10:30:31.464 +00:00 INF] CREATE PROCEDURE [dbo].[Order_GetAll] ( @offset int = 0, @limit int = 10, @status int = null, @fullText nvarchar(256) = null, @startDate datetime = null, @endDate datetime = null, @vip bit = null, @orderNumber int = null ) AS BEGIN SET NOCOUNT ON; SELECT o.*, u.DisplayName, u.PhoneNumber FROM Orders o JOIN AppUsers u ON o.UserId = u.Id WHERE Deleted=0 AND (@status IS NULL OR o.status = @status) AND (@fullText IS NULL OR u.DisplayName like '%' + @fullText + '%' OR u.PhoneNumber like '%' + @fullText + '%' OR o.OrderNumber like '%' + @fullText + '%') AND (@startDate IS NULL OR o.createdDate >= CAST(@startDate AS DATETIME)) AND (@endDate IS NULL OR o.createdDate <= CAST(@endDate AS DATETIME)) AND (@vip IS NULL OR o.Id IN (SELECT vo.OrderId FROM VipOrders vo WHERE vo.active = 1)) ORDER BY o.Status, o.OrderNumber DESC OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY SELECT COUNT(o.Id) TotalCount FROM Orders o JOIN AppUsers u ON o.UserId = u.Id WHERE o.Deleted = 0 AND (@status IS NULL OR o.status = @status) AND (@fullText IS NULL OR u.DisplayName like '%' + @fullText + '%' OR u.PhoneNumber like '%' + @fullText + '%' OR o.OrderNumber like '%' + @fullText + '%') AND (@startDate IS NULL OR o.createdDate >= CAST(@startDate AS DATETIME)) AND (@endDate IS NULL OR o.createdDate <= CAST(@endDate AS DATETIME)) AND (@vip IS NULL OR o.Id IN (SELECT vo.OrderId FROM VipOrders vo WHERE vo.active = 1)) END [01.03.2024 10:30:31.468 +00:00 INF] => 0.0047055s [01.03.2024 10:30:31.469 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (20240229002, '2024-03-01T10:30:31', N'Migration_GetAll') [01.03.2024 10:30:31.473 +00:00 INF] Committing Transaction [01.03.2024 10:30:31.488 +00:00 INF] COMMIT TRANSACTION [01.03.2024 10:30:31.489 +00:00 INF] 20240229002: Migration_GetAll migrated [01.03.2024 10:30:31.489 +00:00 INF] => 0.025128s [01.03.2024 10:30:31.489 +00:00 INF] 20240229003: Migration_GetOrdersByUserId migrating [01.03.2024 10:30:31.489 +00:00 INF] Beginning Transaction [01.03.2024 10:30:31.490 +00:00 INF] BEGIN TRANSACTION [01.03.2024 10:30:31.491 +00:00 INF] ExecuteEmbeddedSqlScript Create_GetOrdersByUserId.sql [01.03.2024 10:30:31.491 +00:00 INF] CREATE PROCEDURE [dbo].[Order_GetOrdersByUserId] ( @userId varchar(125), @offset int = 0, @limit int = 10, @status int = null ) AS BEGIN SET NOCOUNT ON; DECLARE @OfferInfo TABLE ( Id int IDENTITY(1,1), OrderId uniqueidentifier, Status INT, Count INT ) DECLARE @PageOrders TABLE ( Id UNIQUEIDENTIFIER ) INSERT INTO @PageOrders SELECT Id FROM Orders o WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) ORDER BY o.Id OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY INSERT INTO @OfferInfo SELECT offer.OrderId, offer.Status, Count(offer.Id) AS Count FROM Offers offer JOIN Orders orders ON orders.Id = offer.OrderId AND orders.UserId = @userId GROUP BY offer.Status, offer.OrderId SELECT o.*, offers.id AS AcceptedOfferId, oi.*, t.TranslationInfo AS CategoryName, offi.* FROM @PageOrders po JOIN Orders o ON o.Id = po.Id JOIN OrderItems oi ON oi.OrderId = o.Id AND oi.Deleted = 0 LEFT JOin @OfferInfo offi ON offi.OrderId = oi.OrderId JOIN ProductCategories pc on oi.ProductCategoryId = pc.Id JOIN TextContents tc ON tc.Id = pc.TextContentId JOIN Translations t ON t.TextContentId = tc.Id AND t.LanguageId = 2 LEFT JOIN Offers offers ON o.Id = offers.OrderId WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) AND oi.Deleted = 0 ORDER BY o.id, o.UpdatedDate SELECT COUNT(Id) TotalCount FROM Orders WHERE Deleted = 0 AND UserId = @userId AND (Status = @status OR @status IS NULL) END [01.03.2024 10:30:31.499 +00:00 INF] => 0.0073031s [01.03.2024 10:30:31.499 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (20240229003, '2024-03-01T10:30:31', N'Migration_GetOrdersByUserId') [01.03.2024 10:30:31.500 +00:00 INF] Committing Transaction [01.03.2024 10:30:31.508 +00:00 INF] COMMIT TRANSACTION [01.03.2024 10:30:31.509 +00:00 INF] 20240229003: Migration_GetOrdersByUserId migrated [01.03.2024 10:30:31.509 +00:00 INF] => 0.0172771s [01.03.2024 10:36:26.761 +00:00 INF] 0HN1PRAFTIQQB:00000002 Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [01.03.2024 10:36:26.781 +00:00 INF] 0HN1PRAFTIQQB:00000002 Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [01.03.2024 10:36:28.123 +00:00 INF] 0HN1PRAFTIQQB:00000002 Received HTTP response headers after 1340.1813ms - 200 [01.03.2024 10:36:28.134 +00:00 INF] 0HN1PRAFTIQQB:00000002 End processing HTTP request after 1385.4159ms - 200 [01.03.2024 10:36:28.183 +00:00 INF] 0HN1PRAFTIQQB:00000002 Start processing HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994554002800&text=7632 [01.03.2024 10:36:28.183 +00:00 INF] 0HN1PRAFTIQQB:00000002 Sending HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994554002800&text=7632 [01.03.2024 10:36:29.961 +00:00 INF] 0HN1PRAFTIQQB:00000002 Received HTTP response headers after 1778.1943ms - 200 [01.03.2024 10:36:29.962 +00:00 INF] 0HN1PRAFTIQQB:00000002 End processing HTTP request after 1779.3144ms - 200 [01.03.2024 16:58:56.283 +00:00 INF] Migrations [01.03.2024 16:58:56.402 +00:00 INF] 20240229001: Migration_GetAllByStatus [01.03.2024 16:58:56.404 +00:00 INF] 20240229002: Migration_GetAll [01.03.2024 16:58:56.412 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [01.03.2024 16:58:56.413 +00:00 INF] 20240105195988: Migration_20240105195988 [01.03.2024 16:58:56.415 +00:00 INF] 20240106150801: Migration_20240106150801 [01.03.2024 16:58:56.421 +00:00 INF] 20240222282856: Migration_20240222282856 [01.03.2024 16:58:56.421 +00:00 INF] 20240225185332: Migration_20240225185332 [01.03.2024 16:58:56.422 +00:00 INF] 20240226001548: Migration_20240226001548 [01.03.2024 16:58:56.422 +00:00 WRN] 202403091170645: Migration_202403091170645 (current) [01.03.2024 18:56:11.040 +00:00 INF] 0HN1Q23HEUU30:00000004 Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [01.03.2024 18:56:11.099 +00:00 INF] 0HN1Q23HEUU30:00000004 Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [01.03.2024 18:56:11.424 +00:00 INF] 0HN1Q23HEUU30:00000004 Received HTTP response headers after 304.1266ms - 200 [01.03.2024 18:56:11.438 +00:00 INF] 0HN1Q23HEUU30:00000004 End processing HTTP request after 430.0404ms - 200 [01.03.2024 18:56:11.508 +00:00 INF] 0HN1Q23HEUU30:00000004 Start processing HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994503626004&text=5481 [01.03.2024 18:56:11.508 +00:00 INF] 0HN1Q23HEUU30:00000004 Sending HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994503626004&text=5481 [01.03.2024 18:56:13.665 +00:00 INF] 0HN1Q23HEUU30:00000004 Received HTTP response headers after 2156.3198ms - 200 [01.03.2024 18:56:13.668 +00:00 INF] 0HN1Q23HEUU30:00000004 End processing HTTP request after 2160.1183ms - 200