Module:Sandbox/User:Alsang/PotionList: Difference between revisions

seems to work, has input sanitation now
(not saved progress in a while)
 
(seems to work, has input sanitation now)
Line 1:
local p = {}
local param = require( 'Module:Paramtest' )
 
 
-- non dynamic module, no inputs
Line 8 ⟶ 10:
'[[Category:Potions]]',
'[[Uses facility::Standard Potion Station||Potent Potion Station]]',
'[[Uses item.Uses item::Brown Kelp]]', -- restrict for testing
'?Profession Level A = lvl',
'? #- = name',
Line 23 ⟶ 24:
local results = mw.smw.ask(query)
local results = p.calculateValuesmakeTableStrings(results)
 
-- actual output
--return p.displayTable(results)
return p.displayTable(results)
-- for testing
return '<pre>' ..mw.text.jsonEncode(results, mw.text.JSON_PRETTY).. '</pre>'
--return '<pre>' ..mw.text.jsonEncode(results, mw.text.JSON_PRETTY).. '</pre>'
end
 
-- do calculations and determine strings to go in cells
-- any values not directly returned by the query
function p.calculateValuesmakeTableStrings(results)
 
-- iterate through potions
Line 46 ⟶ 49:
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 {}
Line 58 ⟶ 62:
end
item.profit = item.sell - item.buy
item.XP = item.brewXP + item.prepXP
item.KP = item.brewKP + item.prepKP
item.profitPerXP = item.profit / item.XP
-- sanitise data, set to 0 if its not there
-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
item.durationlocal lvl = item.prepDuration + item.brewDurationlvl +or 40/120
item.XPPerHourlocal sell = item.XP / item.durationsell *or 36000
item.KPPerHourlocal brewXP = item.KP / item.duration * 3600brewXP /or 1000
item.profitPerHourlocal prepXP = item.profit / item.durationprepXP *or 36000
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 - item.buy
item.XP = brewXP + prepXP
item.KP = brewKP + prepKP
item.profitPerXP = math.floor(item.profit / item.XP * 100) / 100
 
-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
local batchSize = 12
local downtime = 40
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)
-- currency strings for table
if param.has_content(item.buy) then
item.buyString = '|| {{Currency cell|' .. item.buy .. '}}'
else
item.buyString = '|| colspan="10" | Unknown'
end
if param.has_content(item.sell) then
item.sellString = '|| {{Currency cell|' .. item.sell .. '}}'
else
item.sellString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) then
item.profitString = '|| {{Currency cell|' .. item.profit .. '}}'
else
item.profitString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) and param.has_content(item.brewXP) and param.has_content(item.prepXP) then
item.profitPerXPString = '|| {{Currency cell|' .. item.profitPerXP .. '}}'
else
item.profitPerXPString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) and param.has_content(item.brewDuration) and param.has_content(item.prepDuration) then
item.profitPerHourString = '|| {{Currency cell|' .. item.profitPerHour .. '}}'
else
item.profitPerHourString = '|| colspan="10" | Unknown'
end
-- KP/KP strings
if param.has_content(item.brewXP) and param.has_content(item.prepXP) then
item.XPString = '|| {{formatnum:' .. item.XP .. '}}'
else
item.XPString = '|| Unknown'
end
if param.has_content(item.brewKP) and param.has_content(item.prepKP) then
item.KPString = '|| {{formatnum:' .. item.KP .. '}}%'
else
item.KPString = '|| Unknown'
end
if param.has_content(item.brewXP) and param.has_content(item.prepXP) and param.has_content(item.brewDuration) and param.has_content(item.prepDuration) then
item.XPPerHourString = '|| {{formatnum:' .. item.XPPerHour .. '}}'
else
item.XPPerHourString = '|| Unknown'
end
if param.has_content(item.brewKP) and param.has_content(item.prepKP) and param.has_content(item.prepDuration) then
item.KPPerHourString = '|| {{formatnum:' .. item.KPPerHour .. '}}'
else
item.KPPerHourString = '|| Unknown'
end
end
 
Line 76 ⟶ 154:
-- make the table
function p.displayTable(results)
local currency = require('Module:Currency').parse
local out = {}
table.insert(out, 'Potions per hour assumes 40 seconds resupply between each batch of 12 potions.')
table.insert(out, '{| class="wikitable sortable"')
Line 87 ⟶ 165:
table.insert(headerRow, '!! colspan="10" | Buy Value')
table.insert(headerRow, '!! colspan="10" | Sell Value')
table.insert(headerRow, '!! colspan="10" | Profit Value')
table.insert(headerRow, '!! XP')
table.insert(headerRow, '!! KP')
Line 95 ⟶ 173:
table.insert(headerRow, '!! colspan="10" | Profit/hr')
table.insert(out, table.concat(headerRow, ' '))
table.insert(headerRow, '|-')
for i,item in ipairs(results) do
table.insert(out, '|-')
local itemRow = {}
table.insert(itemRow, '| [[File:Alchemist small icon.png|15px]] ' .. item.lvl )
table.insert(itemRow, '|| {{plink|' .. item.name .. '}}')
table.insert(itemRow, '||')
for j, reagent in ipairs(item.reagents) do
table.insert(itemRow, '{{plink|' .. reagent .. '}}<br>')
end
table.insert(itemRow, item.buyString )
table.insert(itemRow, item.sellString )
table.insert(itemRow, item.profitString )
table.insert(itemRow, item.XPString )
table.insert(itemRow, item.KPString )
table.insert(itemRow, item.profitPerXPString )
table.insert(itemRow, item.XPPerHourString )
table.insert(itemRow, item.KPPerHourString )
table.insert(itemRow, item.profitPerHourString )
table.insert(out, table.concat(itemRow, ' '))
end
table.insert(out, '|}')
930

edits