@@ -6,1 +6,4 @@
 namespace Persistence.API.Controllers;
+
+/// <summary>
+/// <20>אבמעא ס גנולוםם<D79D>לט האםם<D79D>לט

@@ -45,4 +79,0 @@
-		public async Task<ActionResult<int>> Save(Guid setpointKey, object newValue, CancellationToken token)
-		{
-			// ToDo: вычитка idUser
-			await setpointRepository.Save(setpointKey, newValue, 0, token);

@@ -35,0 +56,4 @@
+	/// <param name="token"></param>
+	/// <returns></returns>
+	[HttpGet("log")]
+	public async Task<ActionResult<Dictionary<Guid, IEnumerable<SetpointLogDto>>>> GetLog([FromQuery] IEnumerable<Guid> setpointKeys, CancellationToken token)

@@ -43,0 +73,4 @@
+	[HttpPost]
+	public async Task<ActionResult<int>> Save(Guid setpointKey, object newValue, CancellationToken token)
+	{
+		// ToDo: вычитка idUser

@@ -0,0 +42,4 @@
+	/// <param name="token"></param>
+	/// <returns></returns>
+	[HttpGet("statistics/{autoDrillingSystem}")]
+	public async Task<ActionResult<int>> GetStatistics([FromRoute] string? autoDrillingSystem, int? importantId, CancellationToken token)

@@ -0,0 +44,4 @@
+	[HttpGet("statistics/{autoDrillingSystem}")]
+	public async Task<ActionResult<int>> GetStatistics([FromRoute] string? autoDrillingSystem, int? importantId, CancellationToken token)
+	{
+		var result = await techMessagesRepository.GetStatistics(importantId, autoDrillingSystem, token);

@@ -0,0 +71,4 @@
+	[HttpPost]
+	public async Task<ActionResult<int>> InsertRange([FromBody] IEnumerable<TechMessageDto> dtos, CancellationToken token)
+	{
+		var result = await techMessagesRepository.InsertRange(dtos, token);

@@ -0,0 +83,4 @@
+	[HttpGet("categories")]
+	public ActionResult<Dictionary<int, string>> GetImportantCategories()
+	{
+		var result = new Dictionary<int, string>()

@@ -19,2 +20,3 @@
 
-    [HttpGet]
+	/// <summary>
+	/// Получить список объектов, удовлетворяющий диапазону дат

@@ -29,3 +40,4 @@
+	[HttpGet("datesRange")]
     public async Task<IActionResult> GetDatesRange(CancellationToken token)
     {
         var result = await this.timeSeriesDataRepository.GetDatesRange(token);

@@ -0,0 +21,4 @@
+		Task<IApiResponse<IEnumerable<string>>> GetSystems(CancellationToken token);
+
+		[Get($"{BaseRoute}/statistics/" + "{autoDrillingSystem}")]
+		Task<IApiResponse<int>> GetStatistics(string? autoDrillingSystem, int? importantId, CancellationToken token);

@@ -0,0 +159,4 @@
+			var imortantId = 0;
+			var autoDrillingSystem = nameof(TechMessageDto.System);
+			var dtos = await InsertRange();
+			var filteredDtos = dtos.Where(e => e.CategoryId == imortantId && e.System == e.System);

@@ -0,0 +30,4 @@
+				.SortBy(request.SortSettings)
+				.Skip(request.Skip)
+				.Take(request.Take)
+				.ToListAsync();

@@ -0,0 +35,4 @@
+			{
+				Skip = request.Skip,
+				Take = request.Take,
+				Count = entities.Count,

@@ -0,0 +45,4 @@
+		public async Task<Dictionary<string, int>> GetStatistics(int? importantId, string? autoDrillingSystem, CancellationToken token)
+		{
+			var query = GetQueryReadOnly();
+			var count = await query

@@ -0,0 +47,4 @@
+			var query = GetQueryReadOnly();
+			var count = await query
+				.Where(e => importantId == null || e.CategoryId == importantId)
+				.Where(e => autoDrillingSystem == null || e.System.Name == autoDrillingSystem)

@@ -0,0 +56,4 @@
+
+		public async Task<IEnumerable<string>> GetSystems(CancellationToken token)
+		{
+			var entities = await GetSystems();

@@ -0,0 +59,4 @@
+			var entities = await GetSystems();
+			var systems = entities.Select(e => e.Name);
+
+			return systems ?? [];

@@ -0,0 +69,4 @@
+			foreach (var dto in dtos)
+			{
+				var entity = dto.Adapt<TechMessage>();
+				var systems = await GetSystems();

@@ -0,0 +70,4 @@
+			{
+				var entity = dto.Adapt<TechMessage>();
+				var systems = await GetSystems();
+				var systemId = systems.FirstOrDefault(e => e.Name == dto.System)?.SystemId

@@ -0,0 +88,4 @@
+		{
+			var systems = await memoryCache.GetOrCreateAsync(SystemCacheKey, async f =>
+			{
+				f.AbsoluteExpirationRelativeToNow = TimeSpan.FromMinutes(60);

@@ -0,0 +91,4 @@
+				f.AbsoluteExpirationRelativeToNow = TimeSpan.FromMinutes(60);
+
+				var query = db.Set<ADSystem>();
+				var entities = await query.ToListAsync();

@@ -0,0 +97,4 @@
+				return dtos;
+			});
+
+			return systems ?? [];

@@ -0,0 +103,4 @@
+		{
+			memoryCache.Remove(SystemCacheKey);
+
+			var systemId = Guid.NewGuid();

@@ -0,0 +3,4 @@
+/// <summary>
+/// Модель системы автобурения
+/// </summary>
+public class ADSystemDto

@@ -0,0 +38,4 @@
+		/// <param name="autoDrillingSystem">Система автобурения</param>
+		/// <param name="token"></param>
+		/// <returns></returns>
+		Task<Dictionary<string, int>> GetStatistics(int? importantId, string? autoDrillingSystem, CancellationToken token);

@@ -52,0 +106,4 @@
+	{
+		await setpointRepository.Save(setpointKey, newValue, idUser, token);
+
+		return Ok();

@@ -134,0 +144,4 @@
+			//assert
+			Assert.Equal(HttpStatusCode.OK, response.StatusCode);
+			Assert.NotNull(response.Content);
+			Assert.Equal(DateTimeOffset.MinValue, response.Content?.From);

@@ -134,0 +161,4 @@
+			//assert
+			Assert.Equal(HttpStatusCode.OK, response.StatusCode);
+			Assert.NotNull(response.Content);
+			Assert.NotNull(response.Content?.From);

@@ -0,0 +144,4 @@
+		public async Task GetStatistics_returns_success()
+		{
+			//arrange
+			memoryCache.Remove(SystemCacheKey);

@@ -0,0 +185,4 @@
+		public async Task GetDatesRange_returns_success()
+		{
+			//act
+			var response = await techMessagesClient.GetDatesRangeAsync(new CancellationToken());

@@ -46,0 +47,4 @@
+		{
+			var query = GetQueryReadOnly();
+			var entities = await query
+				.Where(e => e.Created > dateBegin)