public void Group_by_code_and_product()
{
var code = new string(Guid.NewGuid().ToString().Take(20).ToArray());
var supplier = TestSupplier.CreateNaked(session);
var client = TestClient.CreateNaked(session);
var price = supplier.Prices[0];
var order = new TestOrder(client.Users[0], price)
{
WriteTime = DateTime.Now.AddDays(-5)
};
var productSynonym = price.AddProductSynonym(TestProduct.Random(session).First());
session.Save(productSynonym);
var item = order.AddItem(TestProduct.RandomProducts(session).First(), 10, 456);
item.SynonymCode = productSynonym.Id;
item.Code = code;
session.Save(order);
Property("ReportInterval", 5);
Property("SupplierProductCodePosition", 0);
Property("SupplierProductNamePosition", 1);
Property("FirmCodeEqual", new List <ulong> {
supplier.Id
});
var sheet = ReadReport <RatingReport>();
Assert.AreEqual("Оригинальный код товара", sheet.GetRow(2).GetCell(0).StringCellValue);
Assert.AreEqual(code, sheet.GetRow(3).GetCell(0).StringCellValue);
Assert.AreEqual("Оригинальное наименование товара", sheet.GetRow(2).GetCell(1).StringCellValue);
Assert.AreEqual(productSynonym.Name, sheet.GetRow(3).GetCell(1).StringCellValue);
}
public void Generate_report()
{
var code = new string(Guid.NewGuid().ToString().Take(20).ToArray());
var supplier = TestSupplier.CreateNaked(session);
var client = TestClient.CreateNaked(session);
var price = supplier.Prices[0];
var order = new TestOrder(client.Users[0], price)
{
WriteTime = DateTime.Now.AddDays(-5)
};
var productSynonym = price.AddProductSynonym(TestProduct.Random(session).First());
session.Save(productSynonym);
var item = order.AddItem(TestProduct.RandomProducts(session).First(), 10, 456);
item.SynonymCode = productSynonym.Id;
item.Code = code;
session.Save(order);
Property("ReportInterval", 5);
Property("SupplierId", supplier.Id);
Property("Regions", new List <ulong> {
client.RegionCode
});
var AFCode = $"{item.Product.Id}_{item.CodeFirmCr ?? 0}";
var sheet = ReadReport <PulsOrderReport>();
var text = ToText(sheet);
Assert.That(text, Does.Contain(AFCode));
}
