| | | 1 | | using System; |
| | | 2 | | using System.ComponentModel.DataAnnotations; |
| | | 3 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 4 | | |
| | | 5 | | namespace OzonDomains.Models |
| | | 6 | | { |
| | | 7 | | /// <summary> |
| | | 8 | | /// Статистика ответов продавца на сообщения клиентов в чатах Ozon |
| | | 9 | | /// </summary> |
| | | 10 | | [Table("OzonChatResponseStatistics")] |
| | | 11 | | public class OzonChatResponseStatistic |
| | | 12 | | { |
| | | 13 | | [Key] |
| | | 14 | | [DatabaseGenerated(DatabaseGeneratedOption.Identity)] |
| | 3 | 15 | | public long Id { get; set; } |
| | | 16 | | |
| | | 17 | | /// <summary> |
| | | 18 | | /// ID чата в системе Ozon |
| | | 19 | | /// </summary> |
| | | 20 | | [Required] |
| | | 21 | | [MaxLength(100)] |
| | 6 | 22 | | public string ChatId { get; set; } = string.Empty; |
| | | 23 | | |
| | | 24 | | /// <summary> |
| | | 25 | | /// ID клиента Ozon в нашей системе |
| | | 26 | | /// </summary> |
| | | 27 | | [Required] |
| | 3 | 28 | | public int ClientId { get; set; } |
| | | 29 | | |
| | | 30 | | /// <summary> |
| | | 31 | | /// ID заказа в нашей системе (может быть null) |
| | | 32 | | /// </summary> |
| | 0 | 33 | | public int? OrderId { get; set; } |
| | | 34 | | |
| | | 35 | | /// <summary> |
| | | 36 | | /// Номер отправления (для быстрого поиска) |
| | | 37 | | /// </summary> |
| | | 38 | | [MaxLength(50)] |
| | 0 | 39 | | public string? PostingNumber { get; set; } |
| | | 40 | | |
| | | 41 | | /// <summary> |
| | | 42 | | /// ID сообщения клиента в системе Ozon |
| | | 43 | | /// </summary> |
| | | 44 | | [Required] |
| | 0 | 45 | | public long ClientMessageId { get; set; } |
| | | 46 | | |
| | | 47 | | /// <summary> |
| | | 48 | | /// Текст сообщения клиента |
| | | 49 | | /// </summary> |
| | | 50 | | [Column(TypeName = "longtext")] |
| | 3 | 51 | | public string? ClientMessageText { get; set; } |
| | | 52 | | |
| | | 53 | | /// <summary> |
| | | 54 | | /// Дата и время отправки сообщения клиентом (UTC) |
| | | 55 | | /// </summary> |
| | | 56 | | [Required] |
| | 0 | 57 | | public DateTime ClientMessageDate { get; set; } |
| | | 58 | | |
| | | 59 | | /// <summary> |
| | | 60 | | /// ID ответного сообщения продавца (если был ответ) |
| | | 61 | | /// </summary> |
| | 0 | 62 | | public long? SellerResponseMessageId { get; set; } |
| | | 63 | | |
| | | 64 | | /// <summary> |
| | | 65 | | /// Текст ответа продавца (если был ответ) |
| | | 66 | | /// </summary> |
| | | 67 | | [Column(TypeName = "longtext")] |
| | 0 | 68 | | public string? SellerResponseText { get; set; } |
| | | 69 | | |
| | | 70 | | /// <summary> |
| | | 71 | | /// Дата и время ответа продавца (UTC) |
| | | 72 | | /// </summary> |
| | 0 | 73 | | public DateTime? SellerResponseDate { get; set; } |
| | | 74 | | |
| | | 75 | | /// <summary> |
| | | 76 | | /// Время ответа в секундах (разница между ответом и вопросом) |
| | | 77 | | /// </summary> |
| | 0 | 78 | | public int? ResponseTimeSeconds { get; set; } |
| | | 79 | | |
| | | 80 | | /// <summary> |
| | | 81 | | /// Был ли дан ответ на сообщение |
| | | 82 | | /// </summary> |
| | 0 | 83 | | public bool IsAnswered { get; set; } = false; |
| | | 84 | | |
| | | 85 | | /// <summary> |
| | | 86 | | /// Тип чата (Buyer_Seller, Buyer_Support) |
| | | 87 | | /// </summary> |
| | | 88 | | [MaxLength(50)] |
| | 0 | 89 | | public string? ChatType { get; set; } |
| | | 90 | | |
| | | 91 | | /// <summary> |
| | | 92 | | /// Статус чата на момент записи (Opened, Closed) |
| | | 93 | | /// </summary> |
| | | 94 | | [MaxLength(50)] |
| | 0 | 95 | | public string? ChatStatus { get; set; } |
| | | 96 | | |
| | | 97 | | /// <summary> |
| | | 98 | | /// Имя оператора/пользователя, который ответил (если известно) |
| | | 99 | | /// </summary> |
| | | 100 | | [MaxLength(200)] |
| | 0 | 101 | | public string? ResponderName { get; set; } |
| | | 102 | | |
| | | 103 | | /// <summary> |
| | | 104 | | /// Дата создания записи в БД |
| | | 105 | | /// </summary> |
| | 3 | 106 | | public DateTime CreatedAt { get; set; } = DateTime.UtcNow; |
| | | 107 | | |
| | | 108 | | /// <summary> |
| | | 109 | | /// Дата последнего обновления записи |
| | | 110 | | /// </summary> |
| | 3 | 111 | | public DateTime UpdatedAt { get; set; } = DateTime.UtcNow; |
| | | 112 | | |
| | | 113 | | // Navigation properties |
| | | 114 | | [ForeignKey(nameof(ClientId))] |
| | 0 | 115 | | public virtual OzonClient? Client { get; set; } |
| | | 116 | | |
| | | 117 | | [ForeignKey(nameof(OrderId))] |
| | 0 | 118 | | public virtual Order? Order { get; set; } |
| | | 119 | | } |
| | | 120 | | } |