Module:RenderCraftingRecipesTable

local cargo = mw.ext.cargo

local p = {} local buildings = {}

local function loadBuildingsPower local tables = 'buildings' local fields = 'name, powerUsage' local args = { where = 'powerUsage > 0' } local result = cargo.query(tables, fields, args) buildings = {} for _, building in pairs(result) do   buildings[building.name] = tonumber(building.powerUsage) end end

local function round(num, numDecimalPlaces) local mult = 10^(numDecimalPlaces or 0) return math.floor(num * mult + 0.5) / mult end

local function generateRecipeTableRow(recipe) local html = '' -- fix some parameters recipe.alternateRecipe = (tonumber(recipe.alternateRecipe) or 0) > 0 recipe.inCraftBench = (tonumber(recipe.inCraftBench) or 0) > 0 recipe.inWorkShop = (tonumber(recipe.inWorkShop) or 0) > 0 recipe.craftingTime = tonumber(recipe.craftingTime) or 0 if recipe.craftedIn == nil or #tostring(recipe.craftedIn) <= 1 then -- <=1 instead of ==0 just in case of \n or single space characters; normally craftedIn is a long word if recipe.inWorkShop then recipe.craftedIn = 'Equipment Workshop' elseif recipe.inCraftBench then recipe.craftedIn = 'Craft Bench' else recipe.craftedIn = 'Build Gun' end end -- split ingredients and products from recipe into separate arrays local ingredients = {} for i=1, 9, 1 do   local item = recipe["ingredient" .. i]   if item ~= nil and #item > 0 then ingredients[i] = { name = item, amount = tonumber(recipe["quantity" .. i]) or 1 } end end

local products = {} for i=1, 4, 1 do   local item = recipe["product" .. i]   if item ~= nil and #item > 0 then products[i] = { name = item, amount = tonumber(recipe["productCount" .. i]) or 1 } end end -- calculations for table cells local ingredientsCols = #ingredients <= 1 and 1 or math.max(2, math.ceil(#ingredients/2)) local ingredientsRows = math.ceil(#ingredients/ingredientsCols) local ingredientsColspan = 12 / ingredientsCols -- ingredients column is 12 columns wide (with colspan) to be divisible by 1, 2, 3 or 4 local productsCols = #products <= 1 and 1 or math.max(2, math.ceil(#products/2)) local productsRows = math.ceil(#products/productsCols) local productsColspan = 2 / productsCols local maxRows = math.max(ingredientsRows, productsRows) local ingredientsRowspan = maxRows / ingredientsRows local productsRowspan = maxRows / productsRows local ingredientCells = {} local productCells = {} -- function generates HTML for ingredients/products cells and stores generated code in targetTable array local function generateCells(list, rowspan, colspan, targetTable, addEnergyPerItem) for i=1, #list, 1 do     local td = '' local ipm = 60 / recipe.craftingTime * list[i].amount td = td .. ' ' .. list[i].amount .. ' × '      td = td .. ' ' .. list[i].name .. '  '      if recipe.craftingTime > 0 then td = td .. ' ' .. ipm .. ' / min ' -- calculate energy per item if addEnergyPerItem then buildingPower = buildings[recipe.craftedIn] if buildingPower ~= nil then local displayText = round(recipe.craftingTime * buildingPower / list[i].amount, 2) .. ' MJ / item' local tooltipText = 'The energy consumed by ' .. recipe.craftedIn .. ' to craft 1 item at 100% clock' td = td .. '' .. mw.getCurrentFrame:expandTemplate{title='Tooltip', args={[1]=displayText, [2]=tooltipText, [3]='no underline'}} .. ' '         end end else -- if no craftingTime and no ipm to display then add some empty block for proper spacing td = td .. ' '     end td = td .. ' '     targetTable[i] = td    end -- odd amount of ingredients/products leaves one empty cell in the column, which should be filled by a blank cell -- also generate one empty cell when there's no ingredients/products at all if #list == 0 or #list > 1 and #list % 2 == 1 then targetTable[#targetTable+1] = ' ' end end -- generate all ingredients and products cells generateCells(ingredients, ingredientsRowspan, ingredientsColspan, ingredientCells) generateCells(products, productsRowspan, productsColspan, productCells, true) -- for products add energy per item -- assemble the table for i=1, maxRows, 1 do   -- recipe name column if i == 1 then recipeName = recipe.recipeName if recipe.alternateRecipe then recipeName = recipeName .. ' ' .. 'Alternate ' end html = html .. '' .. '' .. recipeName .. ' '   else html = html .. ' '   end -- ingredients column for j=1, ingredientsCols, 1 do     local index = (i-1)*ingredientsCols+j if index <= #ingredientCells then html = html .. ingredientCells[index] end end -- building column if i == 1 then html = html .. ' ' .. recipe.craftedIn .. ' ' if recipe.craftingTime > 0 then html = html .. ' ' .. recipe.craftingTime .. ' sec' end if recipe.inCraftBench or recipe.inWorkShop then local displayText = ' × ' .. recipe.craftingClicks local tooltipText = 240 / (tonumber(recipe.craftingClicks) or 0) .. ' / min' html = html ..' ' .. mw.getCurrentFrame:expandTemplate{title='Tooltip', args={[1]=displayText, [2]=tooltipText, [3]='no underline'}} end html = html .. ' '   end -- products column for j=1, productsCols, 1 do     local index = (i-1)*productsCols+j if index <= #productCells then html = html .. productCells[index] end end html = html .. ' ' end return html end

local fields = 'recipeName, alternateRecipe, mainRecipe, craftedIn, inCraftBench, inWorkShop, craftingTime, craftingClicks, unreleased, experimental, product=product1, product2, product3, product4, productCount=productCount1, productCount2, productCount3, productCount4, ingredient1, quantity1, ingredient2, quantity2, ingredient3, quantity3, ingredient4, quantity4, ingredient5, quantity5, ingredient6, quantity6, ingredient7, quantity7, ingredient8, quantity8'

local function generateTable(recipes) local html = ' ' return html end

function p.generateCraftingRecipes(frame) local itemName = frame.args.item or frame.args[1] local experimental = frame.args.experimental and (#frame.args.experimental > 0) or false local experimentalCondition = experimental and ' and (experimental=True)' or ' and (experimental is null or experimental=False)' local tables = 'crafting_recipes' local args = { where = '(product="' .. itemName .. '" or product2="' .. itemName .. '" or product3="' .. itemName .. '" or product4="' .. itemName .. '")' .. experimentalCondition, orderBy = 'mainRecipe DESC, alternateRecipe ASC' } local recipes = cargo.query(tables, fields, args) if #recipes > 0 then loadBuildingsPower return generateTable(recipes) else return "'''" .. itemName .. "''' can't be crafted." end end

function p.generateCraftingUsage(frame) local itemName = frame.args.item or frame.args[1] local experimental = frame.args.experimental and (#frame.args.experimental > 0) or false local unreleased = frame.args.unreleased and (#frame.args.unreleased > 0) or false local experimentalCondition = experimental and ' and (experimental=True)' or ' and (experimental is null or experimental=False)' local unreleasedCondition = unreleased and '' or ' and (unreleased is null or unreleased=False)' local tables = 'crafting_recipes' local args = { where = 'product IS NOT NULL and _pageName NOT LIKE "%/%" and (ingredient1="' .. itemName .. '" or ingredient2="' .. itemName .. '" or ingredient3="' .. itemName .. '" or ingredient4="' .. itemName .. '" or ingredient5="' .. itemName .. '" or ingredient6="' .. itemName .. '" or ingredient7="' .. itemName .. '" or ingredient8="' .. itemName .. '" or ingredient9="' .. itemName .. '" or ingredient10="' .. itemName .. '")' .. experimentalCondition .. unreleasedCondition, orderBy = '(craftedIn IS NOT NULL or inWorkShop or inCraftBench) DESC, product ASC, alternateRecipe ASC' } local recipes = cargo.query(tables, fields, args) if #recipes > 0 then loadBuildingsPower return generateTable(recipes) else return "'''" .. itemName .. "''' isn't used to craft anything." end end

return p