Module:PotionList: Difference between revisions

Use multiple rows for multiple reagents
(Created page with "require('Module:Mw.html extension') local param = require( 'Module:Paramtest' ) local currency = require('Module:Currency') local lang = mw.getContentLanguage() require("Module:Mw.html extension") local p = {} -- non dynamic module, no inputs function p.main() -- returns almost every parameter needed for the row, except buy values for reagents local query = { 'Category:Potions', '|Potent Potion Station', '?Profe...")
 
(Use multiple rows for multiple reagents)
(2 intermediate revisions by the same user not shown)
Line 1:
require('Module:Mw.html extension')
local param = require( 'Module:Paramtest' )
local currency = require('Module:Currency')
local lang = mw.getContentLanguage()
require("Module:Mw.html extension")
 
 
Line 10 ⟶ 9:
-- non dynamic module, no inputs
function p.main()
 
-- returns almost every parameter needed for the row, except buy values for reagents
local query = {
Line 28 ⟶ 27:
}
local results = mw.smw.ask(query)
 
results = p.formatResults(results)
 
return p.displayTable(results)
 
end
 
-- makes the html for the cells containing currency directly, no tags needed
-- Replaces nil with an "unknown" cell
-- flag is for if the number should not be known, replaces with zero
local function currency_cell(amount, rowspan)
rowspan = rowspan or 1
return currency._cell(amount, { html = 'yes' })
if rowspan <= 1 then rowspan = nil end
if not amount then
return tostring(mw.html.create('td')
:addClass('table-bg-gray')
:css{ ['text-align'] = 'center' }
:attr{ colspan = '10', rowspan = rowspan }
:wikitext("''unknown''")
:done())
end
return currency._cell(amount, { html = 'yes', rowspan = rowspan })
end
 
Line 44 ⟶ 53:
function p.formatResults(results)
 
-- iterate through potions
for i, item in ipairs(results) do
 
--in case of single reagent potions, make table of 1 element
if type(item.reagents) ~= 'table' then
item.reagents = {item.reagents}
end
 
-- iterate through reagents, adding buy price to running total (individuals not needed)
-- starting value 20 is for bottle
item.buy = 20
for j, reagent in ipairs(item.reagents) do
 
--shamelessley lifted from Module:Products
local shopPriceQuery = '[[:+]][[Sold item::' .. reagent .. ']]|?Shop buy price|mainlabel=' .. reagent
local shopPriceResult = mw.smw.ask(shopPriceQuery) or {}
local shopPrice = 0
 
if shopPriceResult[1] and shopPriceResult[1]["Shop buy price"] then
shopPrice = tonumber(shopPriceResult[1]["Shop buy price"]) or 0
end
 
item.buy = item.buy + shopPrice
end
 
-- sanitise data, set to 0 if its not there
local lvl = item.lvl or '?'
local buy = item.buy or 0
local sell = item.sell or 0
local brewXP = item.brewXP or 0
local prepXP = item.prepXP or 0
local brewKP = item.brewKP or 0
local prepKP = item.prepKP or 0
local brewDuration = item.brewDuration or 0
local prepDuration = item.prepDuration or 0
 
-- direct values
item.profit = item.sell and item.buy and item.sell - item.buy
item.XP = item.brewXP and item.prepXP and item.brewXP + item.prepXP
item.KP = item.brewKP and item.prepKP and item.brewKP + item.prepKP
item.profitPerXP = item.profit and item.XP and math.floor(item.profit / item.XP * 100) / 100
 
-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
if shopPriceResult[1] and shopPriceResult[1]["Shop buy price"] then
local batchSize = 12
shopPrice = tonumber(shopPriceResult[1]["Shop buy price"]) or 0
local downtime = 40
end
item.duration = item.prepDuration and item.brewDuration and item.prepDuration + item.brewDuration + downtime/batchSize
item.potionPerHour = item.duration and 1 / item.duration * 3600
item.buy = item.buy + shopPrice
end
-- sanitise data, set to 0 if its not there
local lvl = item.lvl or '?'
local buy = item.buy or 0
local sell = item.sell or 0
local brewXP = item.brewXP or 0
local prepXP = item.prepXP or 0
local brewKP = item.brewKP or 0
local prepKP = item.prepKP or 0
local brewDuration = item.brewDuration or 0
local prepDuration = item.prepDuration or 0
-- direct values
item.profit = sell - buy
item.XP = brewXP + prepXP
item.KP = brewKP + prepKP
item.profitPerXP = math.floor(item.profit / item.XP * 100) / 100
 
-- properties per hour
-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
item.XPPerHour = item.XP and item.potionPerHour and math.floor(item.XP * item.potionPerHour)
local batchSize = 12
item.KPPerHour = item.KP and item.potionPerHour and math.floor(item.KP * item.potionPerHour) / 100
local downtime = 40
item.profitPerHour = item.profit and item.potionPerHour and math.floor(item.profit * item.potionPerHour)
item.duration = prepDuration + brewDuration + downtime/batchSize
item.potionPerHour = 1 / item.duration * 3600
-- properties per hour
item.XPPerHour = math.floor(item.XP * item.potionPerHour)
item.KPPerHour = math.floor(item.KP * item.potionPerHour) / 100
item.profitPerHour = math.floor(item.profit * item.potionPerHour)
-- flags for if data values should be shown
item.hasLvl = param.has_content(item.lvl)
item.hasBuy = param.has_content(item.buy)
item.hasSell = param.has_content(item.sell)
item.hasProfit = item.hasBuy and item.hasSell
item.hasXP = param.has_content(item.brewXP) and param.has_content(item.prepXP)
item.hasKP = param.has_content(item.brewKP) and param.has_content(item.prepKP)
item.hasDuration = param.has_content(item.brewDuration) and param.has_content(item.prepDuration)
end
 
return results
end
 
-- make the table
function p.displayTable(results)
 
local out = mw.html.create('table')
:addClass('wikitable sortable')
:tag('tr')
Line 125 ⟶ 123:
:done()
:tag('th')
:attr{ colspan = '2' }
:wikitext('Reagents (plus bottle)')
:done()
Line 154 ⟶ 153:
:done()
:done()
 
for i,item in ipairs(results) do
local rowspan = #item.reagents
local function createReagentCell(i)
-- need to generate the text for the reagent cell before starting the row
local reagentCellreagent = ''item.reagents[i]
local bottom_padding
for j, reagent in ipairs(item.reagents) do
local top_padding
reagentCell = reagentCell .. '[[File:' .. reagent .. '.png|30px|link=' .. reagent .. ']] [[' .. reagent .. ']]<br>'
if i ~= 1 then top_padding = '0' end
if i ~= rowspan then bottom_padding = '0' end
 
return tostring(mw.html.create('td')
:addClass('plinkt-image no-border')
:css{
['border-top'] = top_padding,
['padding-top'] = top_padding,
['border-bottom'] = bottom_padding,
['padding-bottom'] = bottom_padding
}
:tag('span')
:addClass('inventory-image')
:wikitext(('[[File:%s.png|x30px|link=%s]]'):format(reagent, reagent))
:done()
:done()) .. tostring(mw.html.create('td')
:addClass('plinkt-link no-border')
:css{
['border-top'] = top_padding,
['padding-top'] = top_padding,
['border-bottom'] = bottom_padding,
['padding-bottom'] = bottom_padding
}
:wikitext(('[[%s]]'):format(reagent))
:done())
end
 
local unknown_value_cell = mw.html.create('td')
out
:tagaddClass('trtable-bg-gray')
:css{ ['text-align'] = 'center' }
:attr{ rowspan = rowspan }
:tag('td')
:IFwikitext(item.hasBuy"''unknown''")
 
out:tag('tr')
:IF(item.lvl)
:tag('td')
:css{ ['text-align'] = 'center' }
:attr{ rowspan = rowspan }
:wikitext(item.lvl)
:ELSEdone()
:ELSE()
:addClass('table-bg-grey')
:node(unknown_value_cell)
:css{ ['text-align'] = 'center' }
:wikitextEND('unknown')
 
:END()
:done()
:tag('td')
:attr{ rowspan = rowspan }
:wikitext('[[File:' .. item.name .. '.png|30px|link=' .. item.name .. ']] [[' .. item.name .. ']]')
:done()
 
:wikitext(createReagentCell(1))
:tag('td')
 
:wikitext(reagentCell)
:wikitext(currency_cell(item.buy, rowspan))
:done()
 
:IFwikitext(currency_cell(item.hasBuysell, rowspan))
 
:wikitext(currency_cell(item.buy))
:wikitext(currency_cell(item.profit, rowspan))
:ELSE()
 
:wikitext(currency_cell(item.profitPerHour, rowspan))
 
:IF(item.XP)
:tag('td')
:attr{ rowspan = rowspan }
:addClass('table-bg-grey')
:wikitext(item.XP and lang:formatNum(tonumber(item.XP)))
:attr{ colspan = '10' }
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:done()
:END()
:IF(item.hasSell)
:wikitext(currency_cell(item.sell))
:ELSE()
:tagnode('td'unknown_value_cell)
:addClass('table-bg-grey')
:attr{ colspan = '10' }
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:done()
:END()
 
:IF(item.hasProfitXPPerHour)
:wikitext(currency_cell(item.profit))
:ELSE()
:tag('td')
:attr{ rowspan = rowspan }
:addClass('table-bg-grey')
:wikitext(item.XPPerHour and lang:formatNum(tonumber(item.XPPerHour)))
:attr{ colspan = '10' }
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:done()
:END()
:IF(item.hasProfit and item.hasDuration)
:wikitext(currency_cell(item.profitPerHour))
:ELSE()
:tagnode('td'unknown_value_cell)
:addClass('table-bg-grey')
:attr{ colspan = '10' }
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:done()
:END()
 
:wikitext(currency_cell(item.profitPerXP, rowspan))
:tag('td')
 
:IF(item.hasXP)
:done()
:wikitext(lang:formatNum(tonumber(item.XP)))
 
:ELSE()
for i = 2, rowspan do
:addClass('table-bg-grey')
out:tag('tr')
:css{ ['text-align'] = 'center' }
:wikitext('unknown'createReagentCell(i))
:END()
:done()
end
:tag('td')
:IF(item.hasXP and item.hasDuration)
:wikitext(lang:formatNum(tonumber(item.XPPerHour)))
:ELSE()
:addClass('table-bg-grey')
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:END()
:done()
:IF(item.hasXP and item.hasProfit)
:wikitext(currency_cell(item.profitPerXP))
:ELSE()
:tag('td')
:addClass('table-bg-grey')
:attr{ colspan = '10' }
:css{ ['text-align'] = 'center' }
:wikitext('unknown')
:done()
:END()
:done()
end
 
return out
end
351

edits