Module:FisherPassiveList: Difference between revisions

From Brighter Shores Wiki
Jump to navigation Jump to search
Content added Content deleted
(starting copy of miner, needs a lot of data checking)
 
m (condense table by omitting " (skill node)" from the displayed links to the skill nodes (link still goes to node))
 
(4 intermediate revisions by the same user not shown)
Line 22: Line 22:
'?Activity coins = coins',
'?Activity coins = coins',
'?Skill node name = product',
'?Skill node name = product',
'?Activity input #- = material',
'sort = Profession Level A',
'sort = Profession Level A',
'limit = 500'
'limit = 500'
Line 56: Line 57:
for _, item in ipairs(results) do
for _, item in ipairs(results) do


--catch badly submitted data
-- profit from selling the items
if not item.givesCoins then
item.material = item.material or ''
item.product = item.product or ''
item.product = item.product or ''
-- price of bait
-- query is: there is a shop object page that has this item AND has buy price cannot be "N/A"
-- query is: there is a shop object page that has this item AND has buy price cannot be "N/A"
local query = mw.smw.ask('[[Sold item::' .. item.product .. ']][[Shop sell price::!~N/A]]|?Shop sell price=data|mainlabel=-')
local query = mw.smw.ask('[[Sold item::' .. item.material .. ']][[Shop buy price::!~N/A]]|?Shop buy price=data|mainlabel=-')
if type(query)=='table' then
if type(query)=='table' then
-- price is returned as a number
-- price is returned as a number, 0.1 is for the crate
item.coins = tonumber(query[1].data)*0.005 or 0
item.buy = (0.1+tonumber(query[1].data)*0.005) or 0
else
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
-- 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
item.coins = 0
item.buy = 0
end
end
end
-- price of fish
-- query is: there is a shop object page that has this item AND has buy price cannot be "N/A"
local query = mw.smw.ask('[[Sold item::' .. item.product .. ']][[Shop sell price::!~N/A]]|?Shop sell price=data|mainlabel=-')
if type(query)=='table' then
-- price is returned as a number
item.sell = tonumber(query[1].data)*0.005 or 0
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
item.sell = 0
end
-- profitability
item.profit = item.buy and item.sell and item.sell - item.buy
item.profitPerXP = item.profit and item.XP and item.profit / item.XP
-- no downtime for passives
-- no downtime for passives
Line 78: Line 92:
-- properties per hour
-- properties per hour
item.XPPerHour = item.XP and item.productPerHour and math.floor(item.XP * item.productPerHour)
item.XPPerHour = item.XP and item.productPerHour and math.floor(item.XP * item.productPerHour)
item.coinsPerHour = item.coins and item.productPerHour and math.floor(item.coins * item.productPerHour)
item.profitPerHour = item.profit and item.productPerHour and math.floor(item.profit * item.productPerHour)
end
end


Line 90: Line 104:
:tag('tr')
:tag('tr')
:tag('th')
:tag('th')
:wikitext('[[File:Miner small icon.png|15px]] Level')
:wikitext('[[File:Fisher small icon.png|15px]] Level')
:done()
:done()
:tag('th')
:tag('th')
:attr{ colspan = '2' }
:attr{ colspan = '2' }
:wikitext('Mining node')
:wikitext('Fishing node')
:done()
:done()
:tag('th')
:tag('th')
:attr{ colspan = '3' }
:attr{ colspan = '3' }
:wikitext('Product')
:wikitext('Bait')
:done()
:done()
:tag('th')
:tag('th')
:attr{ colspan = '10' }
:wikitext('Quantity/hr')
:wikitext('Buy<br>Value')
:done()
:tag('th')
:attr{ colspan = '3' }
:wikitext('Fish')
:done()
:tag('th')
:attr{ colspan = '10' }
:wikitext('Sell<br>Value')
:done()
:tag('th')
:attr{ colspan = '10' }
:wikitext('Profit')
:done()
:done()
:tag('th')
:tag('th')
Line 113: Line 140:
:wikitext('XP/hr')
:wikitext('XP/hr')
:done()
:done()
-- :tag('th')
-- :attr{ colspan = '10' }
-- :wikitext('Coins/XP')
-- :done()
:done()
:done()


Line 133: Line 164:
:END()
:END()
-- activity
-- fishing node
:tag('td')
:tag('td')
:css{ ['border-right'] = '0', ['text-align'] = 'right', ['max-width'] = '100px' }
:css{ ['border-right'] = '0', ['text-align'] = 'right', ['max-width'] = '100px' }
Line 142: Line 173:
:tag('td')
:tag('td')
:addClass('plinkt-link no-border')
:addClass('plinkt-link no-border')
:wikitext('[[' .. item.name .. ']]')
:wikitext('[[' .. item.name .. '|' .. item.product ..']]')
:done()
:done()
-- products (coins or items)
-- bait (items)
:tag('td')
:tag('td')
:css{ ['border-right'] = '0', ['text-align'] = 'right' }
:css{ ['border-right'] = '0', ['text-align'] = 'right' }
:attr{ ['data-sort-value'] = item.name }
:attr{ ['data-sort-value'] = item.material }
:wikitext(' 0.005 &times; ')
:done()
:tag('td')
:css{ ['border-right'] = '0', ['border-left'] = '0', ['text-align'] = 'center', ['max-width'] = '100px' }
:addClass('plinkt-link no-border')
:wikitext('[[File:' .. item.material .. '.png|link=' .. item.material .. '|30x30px]]')
:done()
:tag('td')
:css{ ['border-left'] = '0', ['text-align'] = 'left' }
:wikitext('[[' .. item.material .. ']]')
:done()
-- profit per hour (coins)
:node(currency_cell(item.buy))
-- fish
:tag('td')
:css{ ['border-right'] = '0', ['text-align'] = 'right' }
:attr{ ['data-sort-value'] = item.product }
:wikitext('0.005 &times; ')
:wikitext('0.005 &times; ')
:done()
:done()
:tag('td')
:tag('td')
:css{ ['border-right'] = '0', ['text-align'] = 'center' }
:css{ ['border-right'] = '0', ['border-left'] = '0', ['text-align'] = 'center', ['max-width'] = '100px' }
:addClass('plinkt-link no-border')
:addClass('plinkt-link no-border')
:wikitext('[[File:' .. item.product .. '.png|link=' .. item.product .. '|30x30px]]')
:wikitext('[[File:' .. item.product .. '.png|link=' .. item.product .. '|30x30px]]')
:done()
:done()
:tag('td')
:tag('td')
:css{ ['border-left'] = '0', ['text-align'] = 'left' }
:addClass('plinkt-link no-border')
:wikitext('[[' .. item.product .. ']]')
:wikitext('[[' .. item.product .. ']]')
:done()
:done()
-- economics
-- products per hour (items)
:node(currency_cell(item.sell))
:tag('td')
:node(currency_cell(item.profit))
:css{ ['text-align'] = 'right' }
:node(currency_cell(item.profitPerHour))
:wikitext('0.9 &times; [[File:' .. item.product .. '.png|link=' .. item.product .. '|30x30px]]')
:done()
-- profit per hour (coins)
:node(currency_cell(item.coinsPerHour))


-- XP
-- XP
Line 187: Line 233:
:node(unknown_value_cell)
:node(unknown_value_cell)
:END()
:END()
-- coins per xp
-- :node(currency_cell(item.profitPerXP))


:done()
:done()

Latest revision as of 11:04, 15 December 2024

Module documentation
This documentation is transcluded from Module:FisherPassiveList/doc. [edit] [history] [purge]
This module does not have any documentation. Please consider adding documentation at Module:FisherPassiveList/doc. [edit]
Module:FisherPassiveList's function main is invoked by Template:FisherPassiveList.
Module:FisherPassiveList requires Module:Currency.
Module:FisherPassiveList requires Module:Mw.html extension.
Module:FisherPassiveList requires Module:Paramtest.
Module:FisherPassiveList requires strict.

require('strict')
require('Module:Mw.html extension')
local param = require( 'Module:Paramtest' )
local currency = require('Module:Currency')
local lang = mw.getContentLanguage()

local p = {}

-- 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 = {
		'[[Variant of::Herring (skill node)||Bream (skill node)||Wraddock (skill node)||Mackibut (skill node)||Dab (skill node)||Sturlet (skill node)]]',
		'?Variant of #- = variant',
		'?Profession Level A = lvl',
		'? #- = name',
		'?Image #- = Image',
		'?Activity XP = XP',
		'?Activity duration = duration',
		'?Activity coins = coins',
		'?Skill node name = product',
		'?Activity input #- = material',
		'sort = Profession Level A',
		'limit = 500'
	}
	local results = mw.smw.ask(query)

	results = p.formatResults(results)

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

end

-- makes the html for the cells containing currency directly
-- Replaces nil with an "unknown" cell
local function currency_cell(amount)
	if not amount then
		return mw.html.create('td')
			:addClass('table-bg-gray')
			:css{ ['text-align'] = 'center' }
			:attr{ colspan = '10' }
			:wikitext("''unknown''")
		:done()
	end
	return currency._cell(amount, { html = 'yes' })
end

-- do calculations and determine strings to go in cells
function p.formatResults(results)
	
	-- iterate through products
	for _, item in ipairs(results) do

		--catch badly submitted data	
		item.material = item.material or ''
		item.product = item.product or ''
		
		-- price of bait
		-- query is: there is a shop object page that has this item AND has buy price cannot be "N/A"
		local query = mw.smw.ask('[[Sold item::' .. item.material .. ']][[Shop buy price::!~N/A]]|?Shop buy price=data|mainlabel=-')
		if type(query)=='table' then
			-- price is returned as a number, 0.1 is for the crate
			item.buy = (0.1+tonumber(query[1].data)*0.005) or 0
		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
			item.buy =  0
		end
		
		-- price of fish
		-- query is: there is a shop object page that has this item AND has buy price cannot be "N/A"
		local query = mw.smw.ask('[[Sold item::' .. item.product .. ']][[Shop sell price::!~N/A]]|?Shop sell price=data|mainlabel=-')
		if type(query)=='table' then
			-- price is returned as a number
			item.sell = tonumber(query[1].data)*0.005 or 0
		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
			item.sell =  0
		end
		
		-- profitability
		item.profit = item.buy and item.sell and item.sell - item.buy
		item.profitPerXP = item.profit and item.XP and item.profit / item.XP
		
		-- no downtime for passives
		item.productPerHour = item.duration and 1 / item.duration * 3600

		-- properties per hour
		item.XPPerHour = item.XP and item.productPerHour and math.floor(item.XP * item.productPerHour)
		item.profitPerHour = item.profit and item.productPerHour and math.floor(item.profit * item.productPerHour)
	end

	return results
end

-- make the table
function p.displayTable(results)
	local out = mw.html.create('table')
		:addClass('wikitable sortable')
		:tag('tr')
			:tag('th')
				:wikitext('[[File:Fisher small icon.png|15px]]  Level')
			:done()
			:tag('th')
				:attr{ colspan = '2' }
				:wikitext('Fishing node')
			:done()
			:tag('th')
				:attr{ colspan = '3' }
				:wikitext('Bait')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Buy<br>Value')
			:done()
			:tag('th')
				:attr{ colspan = '3' }
				:wikitext('Fish')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Sell<br>Value')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Profit')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Profit/hr')
			:done()
			:tag('th')
				:wikitext('XP')
			:done()
			:tag('th')
				:wikitext('XP/hr')
			:done()
	--		:tag('th')
	--			:attr{ colspan = '10' }
	--			:wikitext('Coins/XP')
	--		:done()
		:done()

	local unknown_value_cell = mw.html.create('td')
		:addClass('table-bg-gray')
		:css{ ['text-align'] = 'center' }
		:wikitext("''unknown''")

	for i, item in ipairs(results) do
		local row = out:tag('tr')
		
			--level
			:IF(item.lvl)
				:tag('td')
					:css{ ['text-align'] = 'center' }
					:wikitext(item.lvl)
				:done()
			:ELSE()
				:node(unknown_value_cell)
			:END()
			
			-- fishing node
			:tag('td')
				:css{ ['border-right'] = '0', ['text-align'] = 'right', ['max-width'] = '100px' }
				:addClass('plinkt-link no-border')
				:attr{ ['data-sort-value'] = item.name }
				:wikitext(' [[' .. item.Image .. '|link=' .. item.name .. '|30x30px]]')
			:done()
			:tag('td')
				:addClass('plinkt-link no-border')
				:wikitext('[[' .. item.name .. '|'  .. item.product ..']]')
			:done()
			
			-- bait (items)
			:tag('td')
				:css{ ['border-right'] = '0', ['text-align'] = 'right' }
				:attr{ ['data-sort-value'] = item.material }
				:wikitext(' 0.005 &times; ')
			:done()
			:tag('td')
				:css{ ['border-right'] = '0', ['border-left'] = '0', ['text-align'] = 'center', ['max-width'] = '100px'  }
				:addClass('plinkt-link no-border')
				:wikitext('[[File:' .. item.material .. '.png|link=' .. item.material .. '|30x30px]]')
			:done()
			:tag('td')
				:css{ ['border-left'] = '0', ['text-align'] = 'left' }
				:wikitext('[[' .. item.material .. ']]')
			:done()
			
			-- profit per hour (coins)
			:node(currency_cell(item.buy))
			
			-- fish
			:tag('td')
				:css{ ['border-right'] = '0', ['text-align'] = 'right' }
				:attr{ ['data-sort-value'] = item.product }
				:wikitext('0.005 &times; ')
			:done()
			:tag('td')
				:css{ ['border-right'] = '0', ['border-left'] = '0', ['text-align'] = 'center', ['max-width'] = '100px'  }
				:addClass('plinkt-link no-border')
				:wikitext('[[File:' .. item.product .. '.png|link=' .. item.product .. '|30x30px]]')
			:done()
			:tag('td')
				:css{ ['border-left'] = '0', ['text-align'] = 'left' }
				:wikitext('[[' .. item.product .. ']]')
			:done()
			
			-- economics
			:node(currency_cell(item.sell))
			:node(currency_cell(item.profit))
			:node(currency_cell(item.profitPerHour))

			-- XP
			:IF(item.XP)
				:tag('td')
					:wikitext(item.XP and lang:formatNum(tonumber(item.XP)))
				:done()
			:ELSE()
				:node(unknown_value_cell)
			:END()
			
			-- XP per hour
			:IF(item.XPPerHour)
				:tag('td')
					:wikitext(item.XPPerHour and lang:formatNum(tonumber(item.XPPerHour)))
				:done()
			:ELSE()
				:node(unknown_value_cell)
			:END()
			
			-- coins per xp
		--	:node(currency_cell(item.profitPerXP))

		:done()
	end

	return out
end

return p