| | | 1 | | using System.ComponentModel.DataAnnotations; |
| | | 2 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 3 | | using Microsoft.EntityFrameworkCore; |
| | | 4 | | |
| | | 5 | | namespace OzonDomains.Models.OzonHandover; |
| | | 6 | | |
| | | 7 | | /// <summary> |
| | | 8 | | /// Позиция акта выдачи/приёма-передачи Ozon. <see cref="ItemNo"/> — это номер отправления Ozon |
| | | 9 | | /// (совпадает по формату с <see cref="Order.ShipmentNumber"/>, например "0128796250-0017-2") — |
| | | 10 | | /// по нему позиция сопоставляется с заказом в системе. |
| | | 11 | | /// </summary> |
| | | 12 | | [Table("OzonHandoverActItems")] |
| | | 13 | | [Index(nameof(ItemNo))] |
| | | 14 | | public class OzonHandoverActItem |
| | | 15 | | { |
| | | 16 | | [Key] |
| | | 17 | | [DatabaseGenerated(DatabaseGeneratedOption.Identity)] |
| | 0 | 18 | | public long Id { get; set; } |
| | | 19 | | |
| | 0 | 20 | | public int ActId { get; set; } |
| | | 21 | | |
| | | 22 | | /// <summary>Заказ, сопоставленный по ItemNo/ShipmentNumber. Null, если сопоставить не удалось.</summary> |
| | 8 | 23 | | public int? OrderId { get; set; } |
| | | 24 | | |
| | 11 | 25 | | public int RowNo { get; set; } |
| | | 26 | | |
| | | 27 | | /// <summary>Номер отправления Ozon источника — ключ сопоставления с Order.ShipmentNumber.</summary> |
| | | 28 | | [MaxLength(50)] |
| | 12 | 29 | | public string? ItemNo { get; set; } |
| | | 30 | | |
| | | 31 | | [MaxLength(500)] |
| | 11 | 32 | | public string? ProductName { get; set; } |
| | | 33 | | |
| | | 34 | | [MaxLength(100)] |
| | 11 | 35 | | public string? Barcode { get; set; } |
| | | 36 | | |
| | 18 | 37 | | public decimal Value { get; set; } |
| | 11 | 38 | | public decimal? ValueApi { get; set; } |
| | 11 | 39 | | public int? WeightG { get; set; } |
| | | 40 | | |
| | | 41 | | /// <summary>Статус позиции: accepted / rejected / pending.</summary> |
| | | 42 | | [MaxLength(30)] |
| | 46 | 43 | | public string? Status { get; set; } |
| | | 44 | | |
| | 18 | 45 | | public bool Defect { get; set; } |
| | 18 | 46 | | public bool Missort { get; set; } |
| | | 47 | | |
| | | 48 | | [MaxLength(1000)] |
| | 11 | 49 | | public string? Comment { get; set; } |
| | | 50 | | |
| | 11 | 51 | | public DateTime? MarkedAt { get; set; } |
| | | 52 | | |
| | 11 | 53 | | public long? Sku { get; set; } |
| | | 54 | | |
| | | 55 | | [MaxLength(100)] |
| | 11 | 56 | | public string? OfferId { get; set; } |
| | | 57 | | |
| | | 58 | | /// <summary>Метка аккаунта источника на уровне позиции (может отличаться от акта).</summary> |
| | | 59 | | [MaxLength(50)] |
| | 11 | 60 | | public string? AccountLabel { get; set; } |
| | | 61 | | |
| | | 62 | | /// <summary>Идентификатор возврата в системе Ozon (return_id).</summary> |
| | 19 | 63 | | public long? ReturnId { get; set; } |
| | | 64 | | |
| | | 65 | | /// <summary>Статус отправления в Ozon на момент выгрузки (ozon_status), например "ReceivedBySeller".</summary> |
| | | 66 | | [MaxLength(50)] |
| | 11 | 67 | | public string? OzonStatus { get; set; } |
| | | 68 | | |
| | | 69 | | [MaxLength(200)] |
| | 12 | 70 | | public string? OzonStatusName { get; set; } |
| | | 71 | | |
| | | 72 | | [MaxLength(20)] |
| | 19 | 73 | | public string? ReturnType { get; set; } |
| | | 74 | | |
| | | 75 | | [MaxLength(100)] |
| | 12 | 76 | | public string? BoxBarcode { get; set; } |
| | | 77 | | |
| | | 78 | | [MaxLength(1000)] |
| | 12 | 79 | | public string? Reason { get; set; } |
| | | 80 | | |
| | 11 | 81 | | public bool ReasonIsDefect { get; set; } |
| | | 82 | | |
| | | 83 | | [Column(TypeName = "text")] |
| | 12 | 84 | | public string? ClientComment { get; set; } |
| | | 85 | | |
| | 11 | 86 | | public DateTime? ClientPhotosExpiresAt { get; set; } |
| | 11 | 87 | | public int PhotosCount { get; set; } |
| | | 88 | | |
| | | 89 | | [Column(TypeName = "text")] |
| | 15 | 90 | | public string? PhotosError { get; set; } |
| | | 91 | | |
| | | 92 | | [Column(TypeName = "text")] |
| | 11 | 93 | | public string? RejectionComment { get; set; } |
| | | 94 | | |
| | | 95 | | [MaxLength(1000)] |
| | 11 | 96 | | public string? RejectionReason { get; set; } |
| | | 97 | | |
| | | 98 | | [MaxLength(100)] |
| | 11 | 99 | | public string? RuPostTracking { get; set; } |
| | | 100 | | |
| | | 101 | | [MaxLength(100)] |
| | 11 | 102 | | public string? ReturnNumber { get; set; } |
| | | 103 | | |
| | | 104 | | [MaxLength(100)] |
| | 11 | 105 | | public string? OrderNumber { get; set; } |
| | | 106 | | |
| | | 107 | | [MaxLength(100)] |
| | 11 | 108 | | public string? ClientReturnMethod { get; set; } |
| | | 109 | | |
| | 11 | 110 | | public long? WarehouseId { get; set; } |
| | | 111 | | |
| | | 112 | | [ForeignKey(nameof(ActId))] |
| | 0 | 113 | | public virtual OzonHandoverAct? Act { get; set; } |
| | | 114 | | |
| | | 115 | | [ForeignKey(nameof(OrderId))] |
| | 0 | 116 | | public virtual Order? Order { get; set; } |
| | | 117 | | |
| | 24 | 118 | | public virtual List<OzonHandoverActItemPhoto> Photos { get; set; } = new(); |
| | | 119 | | } |