private void CreatePeriodicConsumptionItem(InventoryItem inventoryItem,
WarehouseConsumption previousWhc,
IEnumerable<InventoryTransaction> transactionItems)
{
var pci = PeriodicConsumptionItem.Create(inventoryItem);
PeriodicConsumptionItems.Add(pci);
var previousCost = 0m;
if (previousWhc != null)
{
var previousPci = previousWhc.PeriodicConsumptionItems.SingleOrDefault(x => x.InventoryItemId == inventoryItem.Id);
if (previousPci != null)
pci.InStock =
previousPci.PhysicalInventory != null
? previousPci.PhysicalInventory.GetValueOrDefault(0)
: previousPci.GetInventoryPrediction();
if (previousPci != null)
previousCost = previousPci.Cost * pci.InStock;
}
var tim = transactionItems.Where(x => x.InventoryItem.Id == inventoryItem.Id).ToList();
pci.Added = tim.Where(x => x.TargetWarehouseId == WarehouseId).Sum(x => x.Quantity * x.Multiplier) / pci.UnitMultiplier;
pci.Removed = tim.Where(x => x.SourceWarehouseId == WarehouseId).Sum(x => x.Quantity * x.Multiplier) / pci.UnitMultiplier;
var totalPrice = tim.Where(x => x.TargetWarehouseId == WarehouseId).Sum(x => x.Price * x.Quantity);
if (pci.InStock + pci.Purchase > 0)
pci.Cost = decimal.Round((totalPrice + previousCost) / (pci.InStock + pci.Added), 2);
}
public static PeriodicConsumptionItem Create(InventoryItem inventoryItem)
{
return new PeriodicConsumptionItem
{
InventoryItemId = inventoryItem.Id,
InventoryItemName = inventoryItem.Name,
UnitName = inventoryItem.TransactionUnit ?? inventoryItem.BaseUnit,
UnitMultiplier = inventoryItem.TransactionUnitMultiplier > 0
? inventoryItem.TransactionUnitMultiplier
: 1
};
}
public InventoryTransaction Add(InventoryTransactionType transactionType, InventoryItem inventoryItem, decimal price, decimal quantity, string unit, int multiplier)
{
var result = new InventoryTransaction
{
Date = DateTime.Now,
InventoryTransactionTypeId = transactionType.Id,
SourceWarehouseId = transactionType.DefaultSourceWarehouseId,
TargetWarehouseId = transactionType.DefaultTargetWarehouseId,
InventoryItem = inventoryItem,
Multiplier = multiplier,
Price = price,
Quantity = quantity,
Unit = unit
};
TransactionItems.Add(result);
return result;
}
public decimal GetInventory(InventoryItem inventoryItem, Warehouse warehouse)
{
var previousInventory = 0m;
if (_applicationState.PreviousWorkPeriod != null)
{
var ppci = _inventoryDao.GetPeriodConsumptionItem(_applicationState.PreviousWorkPeriod.Id, inventoryItem.Id, warehouse.Id);
previousInventory = ppci.GetPhysicalInventory();
}
var transactions = GetTransactionItems(inventoryItem, warehouse).ToList();
var positiveSum = transactions.Where(x => x.TargetWarehouseId == warehouse.Id).Sum(y => (y.Quantity * y.Multiplier) / inventoryItem.Multiplier);
var negativeSum = transactions.Where(x => x.SourceWarehouseId == warehouse.Id).Sum(y => (y.Quantity * y.Multiplier) / inventoryItem.Multiplier);
var currentConsumption = (
from sale in GetSales(_applicationState.CurrentWorkPeriod, inventoryItem.Id, warehouse.Id)
let recipe = _inventoryDao.GetRecipe(sale.PortionName, sale.MenuItemId)
let rip = recipe.RecipeItems.Where(x => x.InventoryItem.Id == inventoryItem.Id)
select (rip.Sum(x => x.Quantity) * sale.Total) / (inventoryItem.Multiplier)).Sum();
return previousInventory + (positiveSum - negativeSum) - currentConsumption;
}
public MaterialViewModel(InventoryItem model, IWorkspace workspace)
{
Model = model;
_workspace = workspace;
}
public void TestCost()
{
var workspace = PrepareMenu("c:\\sd1.txt");
var iskender = workspace.Single<MenuItem>(x => x.Name.ToLower().Contains("iskender"));
iskender.Portions[0].MenuItemId = iskender.Id;
Assert.IsTrue(workspace.All<MenuItem>().Count() > 0);
Assert.IsNotNull(iskender);
Assert.IsTrue(iskender.Portions.Count == 1);
var donerEti = new InventoryItem { Name = "Döner Eti", BaseUnit = "GR", GroupCode = "", TransactionUnit = "KG", TransactionUnitMultiplier = 1000 };
var yogurt = new InventoryItem { Name = "Yoğurt", BaseUnit = "GR", GroupCode = "", TransactionUnit = "KG", TransactionUnitMultiplier = 1000 };
var pide = new InventoryItem { Name = "Pide", BaseUnit = "Yarım", GroupCode = "", TransactionUnit = "Adet", TransactionUnitMultiplier = 2 };
var zeytinYagi = new InventoryItem { Name = "Zeytin Yağı", BaseUnit = "Ölçü", GroupCode = "", TransactionUnit = "Litre", TransactionUnitMultiplier = 100 };
workspace.Add(donerEti);
workspace.Add(yogurt);
workspace.Add(pide);
workspace.Add(zeytinYagi);
var rp = new Recipe { Name = "İskender Reçetesi", Portion = iskender.Portions[0] };
workspace.Add(rp);
rp.RecipeItems.Add(new RecipeItem { InventoryItem = donerEti, Quantity = 120 });
rp.RecipeItems.Add(new RecipeItem { InventoryItem = yogurt, Quantity = 50 });
rp.RecipeItems.Add(new RecipeItem { InventoryItem = pide, Quantity = 2 });
rp.RecipeItems.Add(new RecipeItem { InventoryItem = zeytinYagi, Quantity = 1 });
AppServices.MainDataContext.StartWorkPeriod("", 0, 0, 0);
var transaction = new Transaction { Date = DateTime.Now, Name = "1" };
workspace.Add(transaction);
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = donerEti, Multiplier = 1000, Price = 16, Quantity = 10, Unit = "KG" });
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = pide, Multiplier = 2, Price = 1, Quantity = 50, Unit = "Adet" });
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = yogurt, Multiplier = 1000, Price = 4, Quantity = 30, Unit = "KG" });
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = zeytinYagi, Multiplier = 100, Price = 5, Quantity = 5, Unit = "Litre" });
var ticket = new Ticket();
workspace.Add(ticket);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
var pc = InventoryService.GetCurrentPeriodicConsumption(workspace);
workspace.Add(pc);
var iskenderCostItem = pc.CostItems.Single(x => x.Portion.MenuItemId == iskender.Id);
Assert.AreEqual(iskenderCostItem.Quantity, 3);
var etCost = ((16m / 1000m) * 120m);
var pideCost = ((1m / 2m) * 2m);
var yogurtCost = ((4m / 1000m) * 50m);
var zeytinYagiCost = ((5m / 100m) * 1m);
var iskenderCost = decimal.Round(etCost + pideCost + yogurtCost + zeytinYagiCost, 2);
Assert.AreEqual(iskenderCost, iskenderCostItem.CostPrediction);
var etpc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == donerEti.Id);
var pidepc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == pide.Id);
var yogurtpc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == yogurt.Id);
var zeytinYagipc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == zeytinYagi.Id);
etpc.PhysicalInventory = 9.5m;
yogurtpc.PhysicalInventory = 28;
zeytinYagipc.PhysicalInventory = 4.5m;
InventoryService.CalculateCost(pc, AppServices.MainDataContext.CurrentWorkPeriod);
etCost = (etpc.GetConsumption() * etCost) / etpc.GetPredictedConsumption();
pideCost = (pidepc.GetConsumption() * pideCost) / pidepc.GetPredictedConsumption();
yogurtCost = (yogurtpc.GetConsumption() * yogurtCost) / yogurtpc.GetPredictedConsumption();
zeytinYagiCost = (zeytinYagipc.GetConsumption() * zeytinYagiCost) / zeytinYagipc.GetPredictedConsumption();
Assert.AreEqual(iskenderCostItem.Cost, decimal.Round(etCost + pideCost + yogurtCost + zeytinYagiCost, 2));
}
public void TestPurchase()
{
var workspace = PrepareMenu("c:\\sd2.txt");
var iskender = workspace.Single<MenuItem>(x => x.Name.ToLower().Contains("iskender"));
iskender.Portions[0].MenuItemId = iskender.Id;
Assert.IsTrue(workspace.All<MenuItem>().Count() > 0);
Assert.IsNotNull(iskender);
Assert.IsTrue(iskender.Portions.Count == 1);
var donerEti = new InventoryItem { Name = "Döner Eti", BaseUnit = "GR", GroupCode = "", TransactionUnit = "KG", TransactionUnitMultiplier = 1000 };
var yogurt = new InventoryItem { Name = "Yoğurt", BaseUnit = "GR", GroupCode = "", TransactionUnit = "KG", TransactionUnitMultiplier = 1000 };
var pide = new InventoryItem { Name = "Pide", BaseUnit = "Yarım", GroupCode = "", TransactionUnit = "Adet", TransactionUnitMultiplier = 2 };
workspace.Add(donerEti);
workspace.Add(yogurt);
workspace.Add(pide);
var rp = new Recipe { Name = "İskender Reçetesi", Portion = iskender.Portions[0] };
workspace.Add(rp);
rp.RecipeItems.Add(new RecipeItem { InventoryItem = donerEti, Quantity = 120 });
rp.RecipeItems.Add(new RecipeItem { InventoryItem = yogurt, Quantity = 50 });
rp.RecipeItems.Add(new RecipeItem { InventoryItem = pide, Quantity = 2 });
AppServices.MainDataContext.StartWorkPeriod("", 0, 0, 0);
var transaction = new Transaction { Date = DateTime.Now, Name = "1" };
workspace.Add(transaction);
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = donerEti, Multiplier = 1000, Price = 16, Quantity = 10, Unit = "KG" });
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = pide, Multiplier = 2, Price = 1, Quantity = 50, Unit = "Adet" });
transaction.TransactionItems.Add(new TransactionItem { InventoryItem = yogurt, Multiplier = 1000, Price = 4, Quantity = 30, Unit = "KG" });
var transactionTotal = transaction.TransactionItems.Sum(x => x.Price * x.Quantity);
Assert.AreEqual(transactionTotal, (16 * 10) + (50 * 1) + (30 * 4));
var ticket = new Ticket();
workspace.Add(ticket);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
var transaction2 = new Transaction { Date = DateTime.Now, Name = "1" };
workspace.Add(transaction2);
transaction2.TransactionItems.Add(new TransactionItem { InventoryItem = donerEti, Multiplier = 1000, Price = 15, Quantity = 10, Unit = "KG" });
var pc = InventoryService.GetCurrentPeriodicConsumption(workspace);
workspace.Add(pc);
var etpc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == donerEti.Id);
Assert.IsNotNull(etpc);
Assert.AreEqual(etpc.InStock, 0);
Assert.AreEqual(etpc.Purchase, 20);
Assert.AreEqual(etpc.Consumption, 0.24m);
Assert.AreEqual(etpc.Cost, 15.5m);
var yogurtpc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == yogurt.Id);
Assert.IsNotNull(yogurtpc);
Assert.AreEqual(yogurtpc.InStock, 0);
Assert.AreEqual(yogurtpc.Purchase, 30);
Assert.AreEqual(yogurtpc.Consumption, 0.1m);
var pidepc = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == pide.Id);
Assert.IsNotNull(pidepc);
Assert.AreEqual(pidepc.InStock, 0);
Assert.AreEqual(pidepc.Purchase, 50);
Assert.AreEqual(pidepc.Consumption, 2);
Assert.AreEqual(pc.CostItems.Count(), 1);
AppServices.MainDataContext.StopWorkPeriod("");
Thread.Sleep(1);
AppServices.MainDataContext.StartWorkPeriod("", 0, 0, 0);
Thread.Sleep(1);
transaction = new Transaction { Date = DateTime.Now, Name = "1" };
workspace.Add(transaction);
const int etAlimMiktari = 50;
var ti = new TransactionItem { InventoryItem = donerEti, Multiplier = 1000, Price = 12, Quantity = etAlimMiktari, Unit = "KG" };
transaction.TransactionItems.Add(ti);
ticket = new Ticket();
workspace.Add(ticket);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
pc = InventoryService.GetCurrentPeriodicConsumption(workspace);
workspace.Add(pc);
var etpc2 = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == donerEti.Id);
Assert.IsNotNull(etpc2);
Assert.AreEqual(etpc2.InStock, etpc.GetInventoryPrediction());
Assert.AreEqual(etpc2.Purchase, etAlimMiktari);
Assert.AreEqual(etpc2.GetInventoryPrediction(), etpc.GetInventoryPrediction() + etAlimMiktari - 0.24m);
var cost = ((etpc.Cost * etpc.GetInventoryPrediction()) + (ti.Price * ti.Quantity)) /
(etpc2.InStock + etpc2.Purchase);
cost = decimal.Round(cost, 2);
Assert.AreEqual(etpc2.Cost, cost);
AppServices.MainDataContext.StopWorkPeriod("");
Thread.Sleep(1);
AppServices.MainDataContext.StartWorkPeriod("", 0, 0, 0);
Thread.Sleep(1);
transaction = new Transaction { Date = DateTime.Now, Name = "1" };
workspace.Add(transaction);
ti = new TransactionItem { InventoryItem = donerEti, Multiplier = 1000, Price = 10, Quantity = etAlimMiktari, Unit = "KG" };
transaction.TransactionItems.Add(ti);
ticket = new Ticket();
workspace.Add(ticket);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
ticket.AddTicketItem(0, iskender, iskender.Portions[0].Name);
pc = InventoryService.GetCurrentPeriodicConsumption(workspace);
workspace.Add(pc);
var etpc3 = pc.PeriodicConsumptionItems.Single(x => x.InventoryItem.Id == donerEti.Id);
Assert.IsNotNull(etpc3);
Assert.AreEqual(etpc3.InStock, etpc2.GetInventoryPrediction());
Assert.AreEqual(etpc3.Purchase, etAlimMiktari);
Assert.AreEqual(etpc3.GetInventoryPrediction(), etpc2.GetInventoryPrediction() + etAlimMiktari - 0.24m);
cost = ((etpc2.Cost * etpc2.GetInventoryPrediction()) + (ti.Price * ti.Quantity)) /
(etpc3.InStock + etpc3.Purchase);
cost = decimal.Round(cost, 2);
Assert.AreEqual(etpc3.Cost, cost);
}
private IEnumerable<InventoryTransaction> GetTransactionItems(InventoryItem inventoryItem, Warehouse warehouse)
{
return _inventoryDao.GetTransactionItems(_applicationState.CurrentWorkPeriod.StartDate, inventoryItem.Id, warehouse.Id);
}
