Module:Sandbox/User:Alsang: Difference between revisions

require('strict')

require('Module:Mw.html extension')

local param = require( 'Module:Paramtest' )

local currency = require('Module:Currency')

local lang = mw.getContentLanguage()

local xpdata = mw.loadData('Module:Experience/data')

-- non dynamic module, no inputs

function p.main()

-- returns only directly needed parameter needed for the row,

-- other parameters are determined by subqueries of chained pages

local query = {

'[[Activity JSON::~*]]',

'? = name',

'?Activity JSON = activityJSON',

'limit = 1500'

}

local results = mw.smw.ask(query)

results = p.screenResults(results)

return p.displayTable(results)

--for debugging

--return '<pre>'..mw.text.jsonEncode(results, mw.text.JSON_PRETTY)..'</pre>'

end

-- goes through a list of results and culls the ones which are not needed for this table

function p.screenResults(results)

local resultsScreened = {}

-- iterate through products

for _, item in ipairs(results) do

-- if theres only one activity, wrap in table

if type(item.activityJSON)=='string' then

item.activityJSON = { item.activityJSON }

end

for j,json in ipairs(item.activityJSON) do

local activityJSON = mw.text.jsonDecode(json)

if activityJSON.duration and tonumber(activityJSON.duration)==20 then

local itemNew = {}

itemNew.name = item.name

itemNew.XP = activityJSON.xp

itemNew.lvl = activityJSON.level

itemNew.profession = activityJSON.profession

itemNew.duration = activityJSON.duration

itemNew.product = activityJSON.output[1].name

itemNew.XPperHour = itemNew.XP and tonumber(itemNew.XP) and itemNew.duration and tonumber(itemNew.duration) and tonumber(itemNew.XP) * 3600 / tonumber(itemNew.duration)

itemNew.fitXP = xpdata.knowledge[itemNew.lvl]*4*0.0005

if itemNew.lvl>=200 then

itemNew.fitXP = itemNew.fitXP * 4

end

itemNew.fitXP = math.floor(itemNew.fitXP * 100 ) / 100

local query = mw.smw.ask('[[Sold item::' .. itemNew.product .. ']][[Shop sell price::!~N/A]]|?Shop sell price=data|mainlabel=-')

if type(query)=='table' then

-- price is returned as a number

itemNew.productSellPrice = tonumber(query[1].data)*0.005

else

-- will return nil if the item is not in a shop, or if it is in a shop but can only be sold to the shop

itemNew.productSellPrice = nil

end

table.insert(resultsScreened,itemNew)

end

end

end

-- sort the results by recipe level

table.sort(resultsScreened, function(item1, item2)

local lvl1 = item1.lvl

local lvl2 = item2.lvl

if (lvl1 == nil) ~= (lvl2 == nil) then --one of two are empty

return lvl2 == nil -- true if lvl2 is nil but not lvl1, false if lvl1 is nil but not lvl2

end

if lvl1 == nil then

return false -- Both empty, equivalent

end

return lvl1 < lvl2 -- normal comparison

end)

return resultsScreened

end

-- make the table

function p.displayTable(results)

local out = mw.html.create('table')

:addClass('wikitable sortable')

:tag('tr')

:tag('th')

:wikitext('Page')

:done()

:tag('th')

:wikitext('Product')

:done()

:tag('th')

:wikitext('Profession')

:done()

:tag('th')

:wikitext('Level')

:done()

:tag('th')

:wikitext('XP')

:done()

:tag('th')

:wikitext('0.0005 of levelup XP')

:done()

:tag('th')

:wikitext('sell price<br>per action')

:done()

:tag('th')

:wikitext('Duration')

:done()

:tag('th')

:wikitext('XP/hr')

:done()

:done()

for i, item in ipairs(results) do

local row = out:tag('tr')

--level

:tag('td')

:wikitext(item.name)

:done()

:tag('td')

:wikitext('[[' .. item.product .. ']]')

:done()

:tag('td')

:wikitext('[[' .. item.profession .. ']]')

:done()

:tag('td')

:wikitext(item.lvl)

:done()

:tag('td')

:wikitext(item.XP)

:done()

:tag('td')

:wikitext(item.fitXP)

:done()

:tag('td')

:wikitext(item.productSellPrice)

:done()

:tag('td')

:wikitext(item.duration)

:done()

:tag('td')

:wikitext(item.XPperHour)

:done()

:done()

end

return out

end

function p.fisherPages()

'[[Variant of::Flounder||Eel||Pufferfish||Gurnard||Bass||Ray||Cod]]',

'sort = Variant of,Profession Level A',