| | | 1 | | using System.ComponentModel.DataAnnotations; |
| | | 2 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 3 | | |
| | | 4 | | namespace OzonDomains.Models; |
| | | 5 | | |
| | | 6 | | [Table("WarehouseStockSyncRuns")] |
| | | 7 | | public class WarehouseStockSyncRun |
| | | 8 | | { |
| | | 9 | | [Key] |
| | | 10 | | [DatabaseGenerated(DatabaseGeneratedOption.Identity)] |
| | 25 | 11 | | public long Id { get; set; } |
| | | 12 | | |
| | | 13 | | [Required] |
| | | 14 | | [MaxLength(32)] |
| | 25 | 15 | | public string SourceType { get; set; } = WarehouseStockSyncSourceType.GoogleSheets; |
| | | 16 | | |
| | | 17 | | [Required] |
| | | 18 | | [MaxLength(32)] |
| | 30 | 19 | | public string Status { get; set; } = WarehouseStockSyncRunStatus.Running; |
| | | 20 | | |
| | 16 | 21 | | public DateTime StartedAtUtc { get; set; } = DateTime.UtcNow; |
| | | 22 | | |
| | 0 | 23 | | public DateTime? CompletedAtUtc { get; set; } |
| | | 24 | | |
| | 0 | 25 | | public int RowsRead { get; set; } |
| | | 26 | | |
| | 0 | 27 | | public int RowsSaved { get; set; } |
| | | 28 | | |
| | | 29 | | [MaxLength(255)] |
| | 0 | 30 | | public string? TriggeredBy { get; set; } |
| | | 31 | | |
| | | 32 | | [MaxLength(255)] |
| | 0 | 33 | | public string? SourceFileName { get; set; } |
| | | 34 | | |
| | 2 | 35 | | public string? ErrorMessage { get; set; } |
| | | 36 | | |
| | 14 | 37 | | public DateTime CreatedAtUtc { get; set; } = DateTime.UtcNow; |
| | | 38 | | |
| | 14 | 39 | | public virtual ICollection<WarehouseStockSnapshot> SnapshotRows { get; set; } = new List<WarehouseStockSnapshot>(); |
| | | 40 | | } |
| | | 41 | | |
| | | 42 | | public static class WarehouseStockSyncRunStatus |
| | | 43 | | { |
| | | 44 | | public const string Running = "Running"; |
| | | 45 | | public const string Success = "Success"; |
| | | 46 | | public const string Failed = "Failed"; |
| | | 47 | | } |
| | | 48 | | |
| | | 49 | | public static class WarehouseStockSyncSourceType |
| | | 50 | | { |
| | | 51 | | public const string GoogleSheets = "GoogleSheets"; |
| | | 52 | | public const string ExcelManual = "ExcelManual"; |
| | | 53 | | |
| | | 54 | | /// <summary> |
| | | 55 | | /// Нулевая строка-«надгробие» для артикула, исчезнувшего из источника: без неё отчёт этапа 1 |
| | | 56 | | /// не видит артикул и не обнуляет его остаток на маркетплейсе. |
| | | 57 | | /// </summary> |
| | | 58 | | public const string Tombstone = "Tombstone"; |
| | | 59 | | } |