public T2Blueprint(BlueprintID bpID, int matLevel, int prodLevel)
{
MatLevel = matLevel;
ProdLevel = prodLevel;
Product = CommonQueries.GetProductFromBlueprint(bpID);
Details = CommonQueries.GetBlueprintDetails(bpID);
var t1ID = CommonQueries.GetT1VersionOfT2(Product);
var t1BPID = CommonQueries.GetBlueprintFromProduct(t1ID);
//Console.WriteLine(new T1Blueprint(t1BPID, 0, 0).InventionMaterials);
Materials = new List <BPMaterial>();
var rawMaterials = CommonQueries.GetMaterialsRaw(Product);
var extraMaterials = CommonQueries.GetMaterialsExtra(bpID);
var t1Materials = CommonQueries.GetMaterialsRaw(t1ID);
var extraT1Materials = CommonQueries.GetMaterialsExtra(t1BPID);
// TODO: currently this assumes there is always exactly 1 recyclable material which is the t1 item
var rawMaterialsAfterRecycling = rawMaterials.Subtract(t1Materials);
// adjust for ME
var adjustedRawMaterials = rawMaterialsAfterRecycling.AdjustForMEWastage(matLevel, Details.wasteFactor);
Materials = adjustedRawMaterials.Union(extraMaterials).ToList();
}
public decimal BaseInventionChance()
{
var typeId = Product;
var groupId = CommonQueries.GetGroupID(Product);
if (groupId == GroupID.Battlecruiser || groupId == GroupID.Battleship ||
typeId == CommonQueries.GetTypeID("Covetor"))
{
return(0.2m);
}
if (groupId == GroupID.Cruiser || groupId == GroupID.Industrial ||
typeId == CommonQueries.GetTypeID("Retriever"))
{
return(0.25m);
}
if (groupId == GroupID.Frigate || groupId == GroupID.Destroyer ||
groupId == GroupID.Freighter || typeId == CommonQueries.GetTypeID("Procurer"))
{
return(0.3m);
}
if (HasT2Version())
{
return(0.4m);
}
return(0);
}
public T1Blueprint(BlueprintID bpID, int matlevel, int prodLevel)
{
MatLevel = matlevel;
ProdLevel = prodLevel;
Product = CommonQueries.GetProductFromBlueprint(bpID);
Details = CommonQueries.GetBlueprintDetails(bpID);
Materials = CommonQueries.GetMaterialsRaw(Product)
.AdjustForMEWastage(matlevel, Details.wasteFactor)
.Union(CommonQueries.GetMaterialsExtra(bpID))
.ToList();
var extraMats = CommonQueries.GetMaterialsExtra(bpID, ActivityIDs.Invention).ToList();
if (extraMats.Any())
{
// data dump is terrible and gives data interfaces a damagePerJob of 100% :ccp:
InventionMaterials = extraMats
.Where(m => m.matID.GetGroupID() != GroupID.DataInterfaces)
.ToList();
InventionInterface = extraMats
.Single(m => m.matID.GetGroupID() == GroupID.DataInterfaces)
.matID;
}
}
public T2Blueprint GetInventionResult(out int outputRuns, int inputRuns = -1, int MLmod = -4, int PLmod = -4, int runsMod = 0, string outputName = null)
{
if (inputRuns == -1)
{
inputRuns = Details.maxProductionLimit;
}
var t2bpID = CommonQueries.GetBlueprintFromProduct(CommonQueries.GetT2VersionOfT1(Product, outputName));
var t2bp = new T2Blueprint(t2bpID, MLmod, PLmod);
outputRuns = (int)((inputRuns / (decimal)Details.maxProductionLimit) * (t2bp.Details.maxProductionLimit / 10.0m)) + runsMod;
outputRuns = Math.Min(Math.Max(outputRuns, 1), t2bp.Details.maxProductionLimit);
return(t2bp);
}
public static IEnumerable <MaterialID> GetMetaGroupVersionOfT1(MaterialID matID, int metaGroupID)
{
using (var cnn = new SQLiteConnection(DefaultDatabase.dbConnection))
{
cnn.Open();
var query = @"select typeId from invMetaTypes where parentTypeID = " + matID + " and metaGroupID = " + metaGroupID;
var results = DefaultDatabase.RunSQLTableQuery(query, cnn);
var t1Name = CommonQueries.GetTypeName(matID);
while (results.Read())
{
yield return(new MaterialID(results["typeID"].ToInt()));
}
}
}
public static TSpreadsheet Create <TSpreadsheet>(T2Blueprint bp, int rowNum = 0, TSpreadsheet existing = null, Decryptor decryptor = null) where TSpreadsheet : class, Spreadsheet, new()
{
var spreadsheet = existing ?? new TSpreadsheet();
spreadsheet.AddCell(new SimpleCell("Invention"), 0, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Quantity"), 1, rowNum);
spreadsheet.AddCell(new SimpleCell("Buy"), 2, rowNum);
spreadsheet.AddCell(new SimpleCell("Sell"), 3, rowNum);
spreadsheet.AddCell(new SimpleCell("BrokerFee"), 4, rowNum);
spreadsheet.AddCell(new SimpleCell("TransactionTax"), 5, rowNum);
spreadsheet.AddCell(new SimpleCell("Buy/Sell/CustomBuy"), 6, rowNum);
spreadsheet.AddCell(new SimpleCell("Unit Cost"), 7, rowNum);
spreadsheet.AddCell(new SimpleCell("Cost per run"), 8, rowNum);
spreadsheet.AddCell(new SimpleCell("Total cost"), 9, rowNum);
spreadsheet.AddCell(new SimpleCell("(Needed)"), 10, rowNum);
var t1BP = new T1Blueprint(CommonQueries.GetBlueprintFromProduct(CommonQueries.GetT1VersionOfT2(bp.Product)), 0, 0);
// TODO: too much copy&paste between this and ManufacturingSpreadsheet
// TODO: brokerFee
rowNum++;
Cell topUnitCost = null, bottomUnitCost = null;
Cell topCostPerRun = null, bottomCostPerRun = null;
Cell topTotalCost = null, bottomTotalCost = null;
var mats = t1BP.InventionMaterials.Union(decryptor != null ? new[] { new BPMaterial(decryptor.MaterialID, 1) } : Enumerable.Empty <BPMaterial>());
foreach (var mat in mats)
{
spreadsheet.AddCell(new SimpleCell(CommonQueries.GetTypeName(mat.matID)), 0, rowNum);
var matQty = spreadsheet.AddCell(new SimpleCell("=" + mat.quantity.ToString() + "*" + mat.damagePerJob.ToString()), 1, rowNum);
var buy = spreadsheet.AddCell(new EveCentralCell(mat.matID, type: PriceType.buy, measure: PriceMeasure.max), 2, rowNum);
var sell = spreadsheet.AddCell(new EveCentralCell(mat.matID, type: PriceType.sell, measure: PriceMeasure.min), 3, rowNum);
var bfAmount = spreadsheet.AddCell(new FormulaCell("={0}*0.01", /*brokerFee, */ buy), 4, rowNum);
// 5 empty
var buysell = spreadsheet.AddCell(new SimpleCell("Sell"), 6, rowNum);
var unitCost = spreadsheet.AddCell(new FormulaCell("=if({0}=\"Sell\",{1},if({0}=\"Buy\",{2}+{3},{0}+{3}))", buysell, sell, buy, /*brokerFee*/ bfAmount), 7, rowNum);
bottomUnitCost = unitCost; topUnitCost = topUnitCost ?? unitCost;
var costPerRun = spreadsheet.AddCell(new FormulaCell("={0}*{1}", unitCost, matQty), 8, rowNum);
bottomCostPerRun = costPerRun; topCostPerRun = topCostPerRun ?? bottomCostPerRun;
var totalCost = spreadsheet.AddCell(new FormulaCell("={0}", costPerRun), 9, rowNum);
bottomTotalCost = totalCost; topTotalCost = topTotalCost ?? totalCost;
rowNum++;
}
spreadsheet.AddCell(new SimpleCell(CommonQueries.GetTypeName(t1BP.InventionInterface)), 0, rowNum);
spreadsheet.AddCell(new SimpleCell("0"), 1, rowNum);
spreadsheet.AddCell(new EveCentralCell(t1BP.InventionInterface, type: PriceType.buy, measure: PriceMeasure.max), 2, rowNum);
spreadsheet.AddCell(new EveCentralCell(t1BP.InventionInterface, type: PriceType.sell, measure: PriceMeasure.min), 3, rowNum);
// todo: meta items
rowNum++;
var totalUnitCost = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topUnitCost, bottomUnitCost), 7, rowNum);
var totalCostPerRun = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topCostPerRun, bottomCostPerRun), 8, rowNum);
var totalTotalCost = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topTotalCost, bottomTotalCost), 9, rowNum);
rowNum += 2;
spreadsheet.AddCell(new SimpleCell("Datacore 1 skill"), 0, rowNum);
var d1Skill = spreadsheet.AddCell(new SimpleCell("4"), 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Datacore 2 skill"), 0, rowNum);
var d2Skill = spreadsheet.AddCell(new SimpleCell("4"), 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Interface skill"), 0, rowNum);
var intSkill = spreadsheet.AddCell(new SimpleCell("4"), 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Decryptor modifier"), 0, rowNum);
var decMod = spreadsheet.AddCell(new SimpleCell(decryptor != null ? decryptor.InventionMod.ToString() : "1"), 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Invention chance"), 0, rowNum);
var invChance = spreadsheet.AddCell(new FormulaCell("=" + t1BP.BaseInventionChance() + "*(1+0.01*{0})*(1+({1}+{2})*(0.1/5-0))*{3}", intSkill, d1Skill, d2Skill, decMod), 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Cost per BP"), 0, rowNum);
var costPerBP = spreadsheet.AddCell(new FormulaCell("={0}/{1}", totalTotalCost, invChance), 1, rowNum);
rowNum++;
int outputruns;
var invResult = decryptor != null?t1BP.GetInventionResult(out outputruns, MLmod : decryptor.MlResult, PLmod : decryptor.PlResult, runsMod : decryptor.RunsMod, outputName : CommonQueries.GetTypeName(bp.Product))
: t1BP.GetInventionResult(out outputruns, outputName: CommonQueries.GetTypeName(bp.Product));
spreadsheet.AddCell(new SimpleCell("Cost per unit"), 0, rowNum);
var costPerUnit = spreadsheet.AddCell(new FormulaCell("={0}/" + outputruns, costPerBP), 1, rowNum);
rowNum += 2;
ManufacturingSpreadsheet.Create <TSpreadsheet>(invResult, rowNum, spreadsheet, costPerUnit);
rowNum = spreadsheet.Height + 1;
spreadsheet.AddCell(new SimpleCell("Copying time p/u: "), 0, rowNum);
spreadsheet.AddCell(new SimpleCell((t1BP.CopyTime() / outputruns).FormatSeconds()), 1, rowNum);
spreadsheet.AddCell(new SimpleCell((t1BP.CopyTime() / outputruns).ToString()), 2, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Invention time p/u: "), 0, rowNum);
spreadsheet.AddCell(new SimpleCell((t1BP.InventionTime() / outputruns).FormatSeconds()), 1, rowNum);
spreadsheet.AddCell(new SimpleCell((t1BP.InventionTime() / outputruns).ToString()), 2, rowNum);
return(spreadsheet);
}
public static TSpreadsheet Create <TSpreadsheet>(IBlueprint bp, int rowNum = 0, TSpreadsheet existing = null, Cell blueprintCost = null, int numToMake = 1) where TSpreadsheet : class, Spreadsheet, new()
{
var spreadsheet = existing ?? new TSpreadsheet();
spreadsheet.AddCell(new SimpleCell(CommonQueries.GetTypeName(bp.Product)), 0, rowNum);
var quantity = new SimpleCell(numToMake.ToString());
var brokerFee = new SimpleCell("0.0045");
var transactionTax = new SimpleCell("0.0105");
rowNum++;
spreadsheet.AddCell(new SimpleCell("Quantity"), 1, rowNum);
spreadsheet.AddCell(new SimpleCell("Buy"), 2, rowNum);
spreadsheet.AddCell(new SimpleCell("Sell"), 3, rowNum);
spreadsheet.AddCell(new SimpleCell("BrokerFee"), 4, rowNum);
spreadsheet.AddCell(new SimpleCell("TransactionTax"), 5, rowNum);
spreadsheet.AddCell(new SimpleCell("Buy/Sell/CustomBuy"), 6, rowNum);
spreadsheet.AddCell(new SimpleCell("Unit Cost"), 7, rowNum);
spreadsheet.AddCell(new SimpleCell("Cost per run"), 8, rowNum);
spreadsheet.AddCell(new SimpleCell("Total cost"), 9, rowNum);
spreadsheet.AddCell(new SimpleCell("(Needed)"), 10, rowNum);
rowNum++;
Cell topUnitCost = null, bottomUnitCost = null;
Cell topCostPerRun = null, bottomCostPerRun = null;
Cell topTotalCost = null, bottomTotalCost = null;
foreach (var mat in bp.Materials)
{
spreadsheet.AddCell(new SimpleCell(CommonQueries.GetTypeName(mat.matID)), 0, rowNum);
var matQty = spreadsheet.AddCell(new SimpleCell("=" + mat.quantity.ToString() + "*" + mat.damagePerJob.ToString()), 1, rowNum);
var buy = spreadsheet.AddCell(new EveCentralCell(mat.matID, type: PriceType.buy, measure: PriceMeasure.max), 2, rowNum);
var sell = spreadsheet.AddCell(new EveCentralCell(mat.matID, type: PriceType.sell, measure: PriceMeasure.min), 3, rowNum);
var bfAmount = spreadsheet.AddCell(new FormulaCell("={0}*{1}", brokerFee, buy), 4, rowNum);
// 5 empty
var buysell = spreadsheet.AddCell(new SimpleCell("Sell"), 6, rowNum);
var unitCost = spreadsheet.AddCell(new FormulaCell("=if({0}=\"Sell\",{1},if({0}=\"Buy\",{2}+{3},{0}+{3}))", buysell, sell, buy, bfAmount), 7, rowNum);
bottomUnitCost = unitCost; topUnitCost = topUnitCost ?? unitCost;
var costPerRun = spreadsheet.AddCell(new FormulaCell("={0}*{1}", unitCost, matQty), 8, rowNum);
bottomCostPerRun = costPerRun; topCostPerRun = topCostPerRun ?? bottomCostPerRun;
var totalCost = spreadsheet.AddCell(new FormulaCell("={0}*{1}", costPerRun, quantity), 9, rowNum);
bottomTotalCost = totalCost; topTotalCost = topTotalCost ?? totalCost;
var needed = spreadsheet.AddCell(new FormulaCell("={0}*{1}", matQty, quantity), 10, rowNum);
rowNum++;
}
if (blueprintCost != null)
{
spreadsheet.AddCell(new SimpleCell("Blueprint (per unit)"), 0, rowNum);
var costPerRun = spreadsheet.AddCell(new FormulaCell("={0}", blueprintCost), 8, rowNum);
bottomCostPerRun = costPerRun; topCostPerRun = topCostPerRun ?? bottomCostPerRun;
var totalCost = spreadsheet.AddCell(new FormulaCell("={0}*{1}", costPerRun, quantity), 9, rowNum);
bottomTotalCost = totalCost; topTotalCost = topTotalCost ?? totalCost;
rowNum++;
}
var totalUnitCost = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topUnitCost, bottomUnitCost), 7, rowNum);
var totalCostPerRun = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topCostPerRun, bottomCostPerRun), 8, rowNum);
var totalTotalCost = spreadsheet.AddCell(new FormulaCell("=SUM({0}:{1})", topTotalCost, bottomTotalCost), 9, rowNum);
rowNum += 2;
spreadsheet.AddCell(new SimpleCell("Buy/Sell/CustomSell"), 6, rowNum);
spreadsheet.AddCell(new SimpleCell("Unit Value"), 7, rowNum);
spreadsheet.AddCell(new SimpleCell("Total Value"), 9, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell(CommonQueries.GetTypeName(bp.Product)), 0, rowNum);
var prodBuy = spreadsheet.AddCell(new EveCentralCell(bp.Product, type: PriceType.buy, measure: PriceMeasure.max), 2, rowNum);
var prodSell = spreadsheet.AddCell(new EveCentralCell(bp.Product, type: PriceType.sell, measure: PriceMeasure.min), 3, rowNum);
// 4 empty
var ttAmount = spreadsheet.AddCell(new FormulaCell("={0}*{1}", prodSell, transactionTax), 5, rowNum);
var prodBuySell = spreadsheet.AddCell(new SimpleCell("Sell"), 6, rowNum);
var prodValue = spreadsheet.AddCell(new FormulaCell("=if({0}=\"Sell\",{1}-{3},if({0}=\"Buy\",{2},{0}-{3}))", prodBuySell, prodSell, prodBuy, ttAmount), 7, rowNum);
var totalValue = spreadsheet.AddCell(new FormulaCell("={0}*{1}", prodValue, quantity), 9, rowNum);
rowNum += 2;
spreadsheet.AddCell(new SimpleCell("Profit"), 9, rowNum);
spreadsheet.AddCell(new SimpleCell("Margin"), 10, rowNum);
rowNum++;
var profit = spreadsheet.AddCell(new FormulaCell("={0}-{1}", totalValue, totalTotalCost), 9, rowNum);
spreadsheet.AddCell(new FormulaCell("={0}/{1}", profit, totalValue), 10, rowNum);
rowNum--;
spreadsheet.AddCell(new SimpleCell("Number of runs: "), 0, rowNum);
spreadsheet.AddCell(quantity, 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Broker fee: "), 0, rowNum);
spreadsheet.AddCell(brokerFee, 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Transaction tax: "), 0, rowNum);
spreadsheet.AddCell(transactionTax, 1, rowNum);
rowNum++;
spreadsheet.AddCell(new SimpleCell("Production time: "), 0, rowNum);
spreadsheet.AddCell(new SimpleCell(bp.ManufacturingTime().FormatSeconds()), 1, rowNum);
var mt = spreadsheet.AddCell(new SimpleCell(bp.ManufacturingTime().ToString()), 2, rowNum);
return(spreadsheet);
}
private Decryptor WithName(string name)
{
Name = name;
MaterialID = CommonQueries.GetMaterialID(name);
return(this);
}
public override string Format(object input)
{
var attrID = new AttributeID(input.ToInt());
return(CommonQueries.GetAttributeName(attrID));
}
public override string Format(object input)
{
var typeId = new TypeID(input.ToInt());
return(CommonQueries.GetTypeName(typeId));
}
public override string Format(object input)
{
var groupId = new GroupID(input.ToInt());
return(CommonQueries.GetGroupName(groupId));
}
public static MaterialID GetT2VersionOfT1(MaterialID matID, string outputName = null)
{
var result = GetMetaGroupVersionOfT1(matID, 2); // note metaGroup not metaLevel
return(result.FirstOrDefault(r => outputName != null ? CommonQueries.GetTypeName(r) == outputName : true));
}
public static List <BPMaterial> AdjustForMEWastage(this IEnumerable <BPMaterial> mats, int ME, int wasteFactor = 10)
{
var meWastageFactor = 1 + CommonQueries.GetWasteForME(ME, wasteFactor);
return(mats.Select(m => new BPMaterial(m.matID, (long)Math.Round(m.quantity * meWastageFactor, 0, MidpointRounding.AwayFromZero))).ToList());
}
public BPMaterial(string typeName, long quantity, decimal damagePerJob = 1)
: this(new MaterialID(CommonQueries.GetTypeID(typeName).ToInt()), quantity, damagePerJob)
{
}
public bool HasT2Version()
{
return(CommonQueries.GetT2VersionOfT1(Product).ToInt() != 0);
}
