| | | 1 | | using System; |
| | | 2 | | using System.Collections.Generic; |
| | | 3 | | using System.ComponentModel.DataAnnotations; |
| | | 4 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 5 | | using System.Linq; |
| | | 6 | | using System.Text; |
| | | 7 | | using System.Threading.Tasks; |
| | | 8 | | using TidVtbc; |
| | | 9 | | using WinSolutions.Sveta.Server.Data.DataModel.Kinds; |
| | | 10 | | using WinSolutions.Sveta.Server.Domain; |
| | | 11 | | |
| | | 12 | | namespace WinSolutions.Sveta.Server.Data.DataModel.Entities |
| | | 13 | | { |
| | | 14 | | public class Movement : ExternalRecord, ITrackableRecord |
| | | 15 | | { |
| | | 16 | | /// <summary> |
| | | 17 | | ///Дата создания документа |
| | | 18 | | /// </summary> |
| | | 19 | | [Required] |
| | | 20 | | //[DatabaseGenerated(DatabaseGeneratedOption.Computed)] |
| | 0 | 21 | | public DateTime DtCreated { get; set; } = DateTime.UtcNow; |
| | | 22 | | |
| | 999 | 23 | | public long? ParentId { get; set; } |
| | | 24 | | |
| | | 25 | | /// <summary> |
| | | 26 | | /// Родительский документ |
| | | 27 | | /// </summary> |
| | 349 | 28 | | public Movement Parent { get; set; } |
| | | 29 | | |
| | 0 | 30 | | public long? ChildrenId { get; set; } |
| | | 31 | | /// <summary> |
| | | 32 | | /// Дочерний документ |
| | | 33 | | /// </summary> |
| | 169 | 34 | | public Movement Children { get; set; } |
| | | 35 | | |
| | | 36 | | /// <summary> |
| | | 37 | | /// Тип прихода |
| | | 38 | | /// </summary> |
| | | 39 | | [Required] |
| | 1546 | 40 | | public MovementType MovementType { get; set; } |
| | | 41 | | |
| | | 42 | | /// <summary> |
| | | 43 | | ///Состав заказа |
| | | 44 | | /// </summary> |
| | 4151 | 45 | | public List<MovementItem> Items { get; set; } |
| | | 46 | | |
| | | 47 | | |
| | | 48 | | /// <summary> |
| | | 49 | | /// Заказчик |
| | | 50 | | /// </summary> |
| | | 51 | | [Required] |
| | 1649 | 52 | | public Contragent Customer { get; set; } |
| | | 53 | | |
| | | 54 | | /// <summary> |
| | | 55 | | /// Поставщик |
| | | 56 | | /// </summary> |
| | | 57 | | [Required] |
| | 895 | 58 | | public Contragent Supplier { get; set; } |
| | | 59 | | |
| | | 60 | | /// <summary> |
| | | 61 | | /// Получатель |
| | | 62 | | /// </summary> |
| | | 63 | | [Required] |
| | 1621 | 64 | | public Department Receiver { get; set; } |
| | | 65 | | |
| | | 66 | | /// <summary> |
| | | 67 | | /// Склад отправитель |
| | | 68 | | /// </summary> |
| | 1320 | 69 | | public Department Sender { get; set; } |
| | | 70 | | |
| | | 71 | | /// <summary> |
| | | 72 | | /// Размер предоплаты % |
| | | 73 | | /// </summary> |
| | | 74 | | [Required] |
| | | 75 | | [Column(TypeName = "decimal(18,2)")] |
| | 487 | 76 | | public decimal PrepaimentPercent { get; set; } |
| | | 77 | | |
| | | 78 | | /// <summary> |
| | | 79 | | /// Сумма предоплаты |
| | | 80 | | /// </summary> |
| | | 81 | | [Required] |
| | | 82 | | [Column(TypeName = "decimal(18,2)")] |
| | 590 | 83 | | public decimal PrepaimentSum { get; set; } |
| | | 84 | | |
| | | 85 | | /// <summary> |
| | | 86 | | /// Комментарии к документам |
| | | 87 | | /// </summary> |
| | 1127 | 88 | | public List<MovementNote> Notes { get; set; } |
| | | 89 | | |
| | | 90 | | //public string Comment { get; set; } |
| | | 91 | | |
| | | 92 | | /// <summary> |
| | | 93 | | /// Дата передачи поставщику |
| | | 94 | | /// </summary> |
| | 260 | 95 | | public DateTime? SupplierTransferDate { get; set; } |
| | | 96 | | |
| | | 97 | | /// <summary> |
| | | 98 | | /// Статус |
| | | 99 | | /// </summary> |
| | | 100 | | /* [Obsolete] |
| | | 101 | | public MovementsStatus Status { get; set; }*/ |
| | | 102 | | [Required] |
| | 18239 | 103 | | public MovementStatus MovementStatus { get; set; } |
| | | 104 | | |
| | | 105 | | /// <summary> |
| | | 106 | | /// Номер документа ORXXXXXXX/SHXXXXXXXX |
| | | 107 | | /// </summary> |
| | | 108 | | [Required] |
| | 1083 | 109 | | public string DocumentNumber { get; set; } |
| | | 110 | | |
| | | 111 | | /// <summary> |
| | | 112 | | /// Вложение - устарело - используем MovementAttachment |
| | | 113 | | /// </summary> |
| | | 114 | | [Obsolete] |
| | 740 | 115 | | public string Attachment { get; set; } |
| | | 116 | | |
| | | 117 | | /// <summary> |
| | | 118 | | /// Сумма занимаемого места на диске приложенных файлов |
| | | 119 | | /// </summary> |
| | 0 | 120 | | public long TotalAttachmentSize { get; set; } |
| | | 121 | | |
| | | 122 | | /// <summary> |
| | | 123 | | /// Список вложений |
| | | 124 | | /// </summary> |
| | 0 | 125 | | public List<MovementAttachment> MovementAttachments { get; set; } |
| | | 126 | | |
| | | 127 | | /// <summary> |
| | | 128 | | /// Тип доставки |
| | | 129 | | /// </summary> |
| | 1123 | 130 | | public DeliveryType DeliveryType { get; set; } |
| | | 131 | | |
| | | 132 | | /// <summary> |
| | | 133 | | /// История действий с документом |
| | | 134 | | /// </summary> |
| | 0 | 135 | | public List<MovementStatusJournal> MovementStatusJournals { get; set; } |
| | | 136 | | |
| | | 137 | | /// <summary> |
| | | 138 | | /// Минимальная сумма заказа на момент отправки в обработки |
| | | 139 | | /// </summary> |
| | 188 | 140 | | public decimal MinOrderSum { get; set; } |
| | | 141 | | |
| | | 142 | | /// <summary> |
| | | 143 | | /// Доступные действия над документом |
| | | 144 | | /// </summary> |
| | 282 | 145 | | [NotMapped] public List<MovementAction> Actions { get; set; } |
| | 0 | 146 | | [NotMapped] public long[] Statuses { get; set; } |
| | | 147 | | |
| | 807 | 148 | | public Movement() { } |
| | 72 | 149 | | public Movement CreateBaseOn(MovementType kind, MovementStatus status, RecordsState recstate) => new Movement |
| | 72 | 150 | | { |
| | 72 | 151 | | ParentId = this.Id, |
| | 72 | 152 | | Parent = this, |
| | 72 | 153 | | Items = this.Items.CloneItems(), |
| | 72 | 154 | | Customer = this.Customer, |
| | 72 | 155 | | Supplier = this.Supplier, |
| | 72 | 156 | | Receiver = this.Receiver, |
| | 72 | 157 | | Sender = this.Sender, |
| | 72 | 158 | | PrepaimentPercent = this.PrepaimentPercent, |
| | 72 | 159 | | PrepaimentSum = this.PrepaimentSum, |
| | 72 | 160 | | SupplierTransferDate = DateTime.UtcNow, |
| | 72 | 161 | | MovementStatus = status, |
| | 72 | 162 | | RecState = recstate, |
| | 72 | 163 | | MovementType = kind, |
| | 72 | 164 | | Notes = new List<MovementNote>(), |
| | 72 | 165 | | MinOrderSum = this.MinOrderSum, |
| | 72 | 166 | | DeliveryType = this.DeliveryType |
| | 72 | 167 | | }; |
| | 2 | 168 | | public Movement CloneThis(MovementStatus status, RecordsState recstate) => new Movement |
| | 2 | 169 | | { |
| | 2 | 170 | | ParentId = this.ParentId, |
| | 2 | 171 | | Parent = this.Parent, |
| | 2 | 172 | | Items = this.Items.CloneItems(), |
| | 2 | 173 | | Customer = this.Customer, |
| | 2 | 174 | | Supplier = this.Supplier, |
| | 2 | 175 | | Receiver = this.Receiver, |
| | 2 | 176 | | Sender = this.Sender, |
| | 2 | 177 | | PrepaimentPercent = this.PrepaimentPercent, |
| | 2 | 178 | | PrepaimentSum = this.PrepaimentSum, |
| | 2 | 179 | | SupplierTransferDate = DateTime.MinValue, |
| | 2 | 180 | | MovementStatus = status, |
| | 2 | 181 | | RecState = recstate, |
| | 2 | 182 | | MovementType = this.MovementType, |
| | 2 | 183 | | Notes = new List<MovementNote>(), |
| | 2 | 184 | | DeliveryType = this.DeliveryType |
| | 2 | 185 | | }; |
| | | 186 | | /// <summary> |
| | | 187 | | /// Возвращает числовое соответствие статуса документа в зависимости от переданной позиции |
| | | 188 | | /// </summary> |
| | | 189 | | /// <param name="movementStatus">номер статуса</param> |
| | | 190 | | /// <param name="position">номер позиции</param> |
| | | 191 | | /// <returns></returns> |
| | 0 | 192 | | public int GetPositionStatus(int position) => position switch |
| | 0 | 193 | | { |
| | 0 | 194 | | 0 => this.MovementStatus.Id switch |
| | 0 | 195 | | { |
| | 0 | 196 | | (long) MovementsStatus.OrderDraft => 1, |
| | 0 | 197 | | (long) MovementsStatus.InQueue => 2, |
| | 0 | 198 | | (long) MovementsStatus.SupplierReject => -1, |
| | 0 | 199 | | (long) MovementsStatus.CustomerReject => -1, |
| | 0 | 200 | | (long) MovementsStatus.Reject => -1, |
| | 0 | 201 | | _ => 4 |
| | 0 | 202 | | }, |
| | 0 | 203 | | // блок отгрузки |
| | 0 | 204 | | 1 => this.MovementStatus.Id switch |
| | 0 | 205 | | { |
| | 0 | 206 | | (long) MovementsStatus.ShipmentDraft => 1, |
| | 0 | 207 | | (long) MovementsStatus.PaymentAwaiting => 1, |
| | 0 | 208 | | (long) MovementsStatus.Picking => 2, |
| | 0 | 209 | | (long) MovementsStatus.ReadyForShipment => 3, |
| | 0 | 210 | | (long) MovementsStatus.SupplierReject => -1, |
| | 0 | 211 | | (long) MovementsStatus.CustomerReject => -1, |
| | 0 | 212 | | (long) MovementsStatus.Reject => -1, |
| | 0 | 213 | | (long) MovementsStatus.ShipmentReject => -1, |
| | 0 | 214 | | (long) MovementsStatus.Correction => -2, |
| | 0 | 215 | | _ => 4 |
| | 0 | 216 | | }, |
| | 0 | 217 | | // блок прихода |
| | 0 | 218 | | 2 => this.MovementStatus.Id switch |
| | 0 | 219 | | { |
| | 0 | 220 | | (long) MovementsStatus.Shipped => 0, |
| | 0 | 221 | | (long) MovementsStatus.Received => 4, |
| | 0 | 222 | | (long) MovementsStatus.CustomerReject => -1, |
| | 0 | 223 | | _ => 0 |
| | 0 | 224 | | }, |
| | 0 | 225 | | // блок оплаты |
| | 0 | 226 | | 3 => this.MovementStatus.Id switch |
| | 0 | 227 | | { |
| | 0 | 228 | | (long) MovementsStatus.PaymentAwaiting => 5, |
| | 0 | 229 | | (long) MovementsStatus.Picking => 6, |
| | 0 | 230 | | _ => 0 |
| | 0 | 231 | | }, |
| | 0 | 232 | | // блок претензии |
| | 0 | 233 | | 4 => this.MovementStatus.Id switch |
| | 0 | 234 | | { |
| | 0 | 235 | | (long) MovementsStatus.ClaimInProgress => -3, |
| | 0 | 236 | | (long) MovementsStatus.ClaimDeclined => -5, |
| | 0 | 237 | | (long) MovementsStatus.ClaimAccepted => -4, |
| | 0 | 238 | | _ => 0 |
| | 0 | 239 | | }, |
| | 0 | 240 | | _ => 0, |
| | 0 | 241 | | }; |
| | | 242 | | |
| | | 243 | | /// <summary> |
| | | 244 | | /// Заполняет список доступных действий с документом |
| | | 245 | | /// </summary> |
| | | 246 | | /// <param name="allActions">Список доступных действий</param> |
| | | 247 | | /// <param name="contragentKindId">Идентификатор типа контрагента</param> |
| | | 248 | | /// <param name="Roles">Список ролей пользователя</param> |
| | | 249 | | public void FillActions(List<MovementRouteAction> allActions, long contragentKindId, List<string> Roles) |
| | 118 | 250 | | { |
| | 118 | 251 | | long owner = contragentKindId switch |
| | 118 | 252 | | { |
| | 118 | 253 | | (long) ContragentKind.Retailer => 1, |
| | 118 | 254 | | (long) ContragentKind.Wholesaler => 2, |
| | 118 | 255 | | (long) ContragentKind.Platform => 3, |
| | 118 | 256 | | _ => 1 |
| | 118 | 257 | | }; |
| | | 258 | | |
| | 118 | 259 | | this.Actions = allActions |
| | 39530 | 260 | | .Where(d => d.OwnerActionId == owner && d.StatusId == this.MovementStatus.Id) |
| | 828 | 261 | | .Select(d => new MovementAction |
| | 828 | 262 | | { |
| | 828 | 263 | | Caption = d.Caption.Trim(), |
| | 828 | 264 | | Type = d.Type.Trim(), |
| | 828 | 265 | | Code = d.Code.Trim(), |
| | 828 | 266 | | Action = d.Action?.Replace("{id}", this.Id.ToString().Trim())? |
| | 828 | 267 | | .Replace("{parentId}", this.ParentId?.ToString()) |
| | 828 | 268 | | }) |
| | 828 | 269 | | .Where(d => !string.IsNullOrEmpty(this.Attachment) || !d.Code.ToUpper().Equals("GetAttachment".ToUpper() |
| | 827 | 270 | | .Where(d => this.MovementStatus.Id != (long)MovementsStatus.ReadyForShipment || |
| | 827 | 271 | | ((this.DeliveryType?.Code.Equals("Pickup") ?? true) ? !d.Code.Equals("Deliver") : !d.Code.Eq |
| | 827 | 272 | | .Where(d => this.DeliveryType?.Id == (long)DeliveryTypeKind.Delivery || !d.Code.Equals("PrintTn")) |
| | 826 | 273 | | .Where(d => Roles != null && !Roles.Contains("dd_sys_low_level") || |
| | 826 | 274 | | d.Type.ToUpper().Equals("GET")) |
| | 118 | 275 | | .ToList(); |
| | 118 | 276 | | } |
| | | 277 | | /// <summary> |
| | | 278 | | /// Формирует номер документа по формату |
| | | 279 | | /// </summary> |
| | | 280 | | /// <param name="envName">Имя окружения</param> |
| | | 281 | | /// <returns></returns> |
| | | 282 | | public void CreateDocumentNumber(string envName) => |
| | 169 | 283 | | this.DocumentNumber = this.MovementType.Id switch |
| | 169 | 284 | | { |
| | 169 | 285 | | (long) MovementKind.Order => $"OR{this.Id.ToString("D8")}", |
| | 169 | 286 | | (long) MovementKind.Shipment => ((Func<string>)(() => |
| | 241 | 287 | | { |
| | 241 | 288 | | return envName.ToLower() switch |
| | 241 | 289 | | { |
| | 241 | 290 | | "development" => TID.New(7801, 220, (int) this.Id + 100_000_000).StringWithDashes, |
| | 241 | 291 | | "qa" => TID.New(7801, 220, (int) this.Id + 200_000_000).StringWithDashes, |
| | 241 | 292 | | "stage" => TID.New(7801, 220, (int) this.Id + 300_000_000).StringWithDashes, |
| | 241 | 293 | | _ => TID.New(7801, 220, (int) this.Id).StringWithDashes, |
| | 241 | 294 | | }; |
| | 241 | 295 | | }))(), |
| | 169 | 296 | | (long) MovementKind.Arrival => $"RE{this.Id.ToString("D8")}", |
| | 169 | 297 | | _ => "" |
| | 169 | 298 | | }; |
| | | 299 | | |
| | | 300 | | /// <summary> |
| | | 301 | | /// Перерасчет суммы предоплаты |
| | | 302 | | /// </summary> |
| | | 303 | | /// <returns></returns> |
| | 75 | 304 | | public void ReCalculate() => this.PrepaimentSum = |
| | 152 | 305 | | (this.Items.Sum((i => (i.Price * i.Quantity))) * this.PrepaimentPercent) / 100; |
| | | 306 | | |
| | | 307 | | /// <summary> |
| | | 308 | | /// Обновление цен в документе |
| | | 309 | | /// </summary> |
| | | 310 | | /// <param name="movement">Документ</param> |
| | | 311 | | /// <param name="itemList">Список заказанных товаров</param> |
| | | 312 | | /// <returns>List<MovementItem></returns> |
| | | 313 | | public void UpdatePriceInDraft() |
| | 72 | 314 | | { |
| | 144 | 315 | | SupplyContract contract = this.Customer.ContractsAsBuyer.FirstOrDefault(d => !d.IsDeleted |
| | 144 | 316 | | && d.Seller.Id == |
| | 144 | 317 | | this.Supplier.Id |
| | 144 | 318 | | && d.BeginDate <= DateTime. |
| | 144 | 319 | | && d.EndDate >= DateTime.Ut |
| | 72 | 320 | | ?? throw new ArgumentException( |
| | 72 | 321 | | $"Не найден действующий контракт для" + |
| | 72 | 322 | | $" покупателя {this.Customer?.ShortName} и продавца {this.Supplier?.ShortName} |
| | | 323 | | |
| | 0 | 324 | | if (this.Items.Count == 0) return; |
| | 72 | 325 | | Parallel.ForEach(this.Items, item => |
| | 148 | 326 | | { |
| | 148 | 327 | | item.CalculatePrice(this.Receiver.Cluster, contract.RatioForCalculations); |
| | 148 | 328 | | }); |
| | 72 | 329 | | } |
| | | 330 | | |
| | | 331 | | public void AddItem(MovementItem mItem, RecordsState active) |
| | 73 | 332 | | { |
| | | 333 | | MovementItem movementItem; |
| | 73 | 334 | | this.Items ??= new List<MovementItem>(); |
| | 81 | 335 | | if (this.Items != null && this.Items.Any(d => d.Good.Id == mItem.Good.Id)) |
| | 4 | 336 | | { |
| | 8 | 337 | | movementItem = this.Items.FirstOrDefault(d => d.Good.Id == mItem.Good.Id) |
| | 4 | 338 | | ?? throw new ArgumentException($"Позиция в документе для товара {mItem.Good.Id} не найде |
| | 4 | 339 | | movementItem.Quantity = mItem.Quantity; |
| | 8 | 340 | | this.Items[this.Items.FindIndex(d => d.Good.Id == mItem.Good.Id)] = movementItem; |
| | 4 | 341 | | } |
| | | 342 | | else |
| | 69 | 343 | | { |
| | 138 | 344 | | SupplyContract contract = this.Customer.ContractsAsBuyer.FirstOrDefault(d => !d.IsDeleted |
| | 138 | 345 | | && d.Seller.Id == |
| | 138 | 346 | | this.Supplier.Id |
| | 138 | 347 | | && d.BeginDate <= |
| | 138 | 348 | | DateTime.UtcNow |
| | 138 | 349 | | && d.EndDate >= |
| | 138 | 350 | | DateTime.UtcNow) |
| | 69 | 351 | | ?? throw new ArgumentException( |
| | 69 | 352 | | $"Ошибка в расчете стоимости при добавлении позиции в документ. Не найден |
| | | 353 | | // иначе добавим товар в заявку |
| | 69 | 354 | | movementItem = new MovementItem |
| | 69 | 355 | | { |
| | 69 | 356 | | Good = mItem.Good, |
| | 69 | 357 | | Price = 0, |
| | 69 | 358 | | Quantity = mItem.Quantity, |
| | 69 | 359 | | RecState = active, |
| | 69 | 360 | | //MovementId = this.Id |
| | 69 | 361 | | }; |
| | 69 | 362 | | movementItem.CalculatePrice(this.Receiver.Cluster, contract.RatioForCalculations); |
| | 69 | 363 | | this.Items.Add(movementItem); |
| | 69 | 364 | | } |
| | 73 | 365 | | } |
| | | 366 | | public bool CheckCanWorkWithMovement(long contragentKindId, long contragentId, bool isOwner, List<Department> de |
| | | 367 | | , bool isAnonym = false, Guid anonymUuid = default) => |
| | 132 | 368 | | this.MovementType.Id switch |
| | 132 | 369 | | { |
| | 132 | 370 | | (long)MovementKind.Order => ((Func<bool>)(() => |
| | 263 | 371 | | { |
| | 263 | 372 | | return contragentKindId switch |
| | 263 | 373 | | { |
| | 263 | 374 | | (long) ContragentKind.Retailer => this.Customer.Id == contragentId |
| | 0 | 375 | | && (isOwner || departments.Any(x => x.Id == this.Receiver.Id)) |
| | 263 | 376 | | && (!isAnonym || this.GUID.Equals(anonymUuid)), |
| | 263 | 377 | | (long) ContragentKind.Wholesaler => false, |
| | 263 | 378 | | (long) ContragentKind.Platform => true, |
| | 263 | 379 | | _ => false, |
| | 263 | 380 | | }; |
| | 263 | 381 | | }))(), |
| | 132 | 382 | | (long)MovementKind.Shipment => ((Func<bool>)(() => |
| | 133 | 383 | | { |
| | 133 | 384 | | return contragentKindId switch |
| | 133 | 385 | | { |
| | 133 | 386 | | (long) ContragentKind.Wholesaler => (this.Supplier.Id == contragentId || |
| | 133 | 387 | | this.Customer.Id == contragentId) |
| | 0 | 388 | | && (isOwner || departments.Any(x=>x.Id == this.Sender.Id)), |
| | 133 | 389 | | (long) ContragentKind.Retailer => this.Customer.Id == contragentId && |
| | 133 | 390 | | (this.MovementStatus.Id != (long) MovementsStatus.ShipmentDraft) |
| | 0 | 391 | | && (isOwner || departments.Any(x => x.Id == this.Receiver.Id)), |
| | 133 | 392 | | (long) ContragentKind.Platform => true, |
| | 133 | 393 | | _ => false, |
| | 133 | 394 | | }; |
| | 133 | 395 | | }))(), |
| | 132 | 396 | | _ => false |
| | 132 | 397 | | }; |
| | | 398 | | |
| | | 399 | | public bool CheckEditable(MovementStatus draftStatus) => |
| | 70 | 400 | | this.MovementType.Id switch |
| | 70 | 401 | | { |
| | 70 | 402 | | (long) MovementKind.Order => this.MovementStatus.Id == draftStatus.Id, |
| | 70 | 403 | | (long) MovementKind.Shipment => this.MovementStatus.Id == draftStatus.Id || |
| | 70 | 404 | | this.MovementStatus.Id == (long) MovementsStatus.Correction, |
| | 70 | 405 | | _ => false |
| | 70 | 406 | | }; |
| | | 407 | | } |
| | | 408 | | } |