Module:ChefList: Difference between revisions

From Brighter Shores Wiki
Jump to navigation Jump to search
Content added Content deleted
(hide broken image links in table)
m (add purge link)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
require('strict')
require('strict')
require('Module:Mw.html extension')
require('Module:Mw.html extension')
local search = require('Module:RecipeTreeSearch')
local param = require( 'Module:Paramtest' )
local currency = require('Module:Currency')
local lang = mw.getContentLanguage()
local lang = mw.getContentLanguage()
local plist = require('Module:ProfessionList')
local purge = require('Module:Purge')._purge


local p = {}
local p = {}
Line 10: Line 9:
-- non dynamic module, no inputs
-- non dynamic module, no inputs
function p.main()
function p.main()
-- returns only directly needed parameter needed for the row,
local queryString = '[[Category:Chef]] AND [[Category:Pages with recipes]] AND [[-Sold item.Sold by::Head Chef (shop)]]'
-- other parameters are determined by subqueries of chained pages
local query = {
local function screenFunction(item)
'[[-Sold item.Sold by::Head Chef (shop)]]',
return not item.passive
'?Profession Level A = lvl',
end
'? #- = name',
'?Recipe JSON = recipeJSON',
local results = plist.generate_recipe_table(queryString,screenFunction)
'?Activity XP = XP',
'?Activity duration = duration',
'?Value = sell',
'sort = Profession Level A',
'limit = 500'
}
local results = mw.smw.ask(query)

results = p.screenResults(results,false)


results = p.formatResults(results)
results = p.formatResults(results)
Line 36: Line 27:
end
end


-- do calculations and determine strings to go in cells
-- makes the html for the cells containing currency directly
function p.formatResults(results)
-- Replaces nil with an "unknown" cell
local function currency_cell(amount)
--simple check for nil results
if not amount then
if results ==nil or results[1] == nil then
return mw.html.create('td')
return nil
:addClass('table-bg-gray')
:css{ ['text-align'] = 'center' }
:attr{ colspan = '10' }
:wikitext("''unknown''")
:done()
end
end
return currency._cell(amount, { html = 'yes' })
end

-- Need to split the table into two, lines with crates are passive and lines without are not
function p.screenResults(results,isPassive)
local resultsPassive = {}
local resultsNotPassive = {}
-- iterate through products
-- iterate through products
for _, item in ipairs(results) do
for _, item in ipairs(results) do
local hasCrate = item.recipeJSON and string.find(item.recipeJSON,'Crate')
-- list of all pages to edit, if edit is needed
if hasCrate then
item.allPageEdits = { item.pageName }
table.insert(resultsPassive,item)
for _,intermediate in ipairs(item.intermediateMaterials) do
else
table.insert(resultsNotPassive,item)
table.insert(item.allPageEdits,intermediate.name)
end
end
end
if isPassive then
return resultsPassive
else
return resultsNotPassive
end
end


-- profitability
-- do calculations and determine strings to go in cells
item.profitPerXP = item.profit and item.xp and item.profit / item.xp
function p.formatResults(results)

-- iterate through products
for _, item in ipairs(results) do
-- New module for recipe searching
local fullRecipe = search.main(item.name)
item.materials = fullRecipe.materials
item.outputQuantity = fullRecipe.output[1].quantity
item.buy = fullRecipe.buyPrice
item.XP = fullRecipe.xp
item.duration = fullRecipe.duration
-- iterate through materials, keep track of how many materials are needed from each shop
-- iterate through materials, keep track of how many materials are needed from each shop
Line 94: Line 53:
-- query which shop sold it, add to running total
-- query which shop sold it, add to running total
local shopNameQuery = '[[:+]][[Sold item::' .. material.name .. ']]|?Sold by #-|mainlabel=' .. material.name
local shopNameQuery = '[[:+]][[Sold item::' .. material.name .. ']]|?Sold by #-=data|mainlabel=' .. material.name
local shopNameResult = mw.smw.ask(shopNameQuery) or {}
local shopNameResult = mw.smw.ask(shopNameQuery) or {}
local shopName = ''
local shopName = (shopNameResult and shopNameResult[1] and shopNameResult[1].data) or ''


if shopNameResult[1] and shopNameResult[1]["Sold by"] then
shopName = shopNameResult[1]["Sold by"] or ''
end
if shopName=="The Frequently Fresh Fish Stall" then
if shopName=="The Frequently Fresh Fish Stall" then
item.fishShopTrips = item.fishShopTrips + 1
item.fishShopTrips = item.fishShopTrips + 1
Line 110: Line 65:
end
end
-- direct values
item.sell = item.sell and item.outputQuantity and item.sell * item.outputQuantity
item.profit = item.sell and item.buy and item.sell - item.buy
item.profitPerXP = item.profit and item.XP and math.floor(item.profit / item.XP * 100) / 100

-- there will be extra time spent buying and selling items, and moving between stations
-- there will be extra time spent buying and selling items, and moving between stations
-- assume make one trip to buy 24 of each material from each shop per batch of 24 food
-- assume make one trip to buy 24 of each material from each shop per batch of 24 food
Line 127: Line 77:


-- 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.profitPerHour = item.profit and item.productPerHour and math.floor(item.profit * item.productPerHour)
item.profitPerHour = item.profit and item.productPerHour and math.floor(item.profit * item.productPerHour)
-- testing something that will stop broken image links appearing
local imgQuery = mw.smw.ask('[[File:' .. item.name .. '.png]]|?Modification date #- =data|mainlabel=-')
item.imgResult = imgQuery and imgQuery[1] and imgQuery[1].data
end
end


Line 140: Line 86:
-- make the table
-- make the table
function p.displayTable(results)
function p.displayTable(results)
--simple check for nil results
if results ==nil or results[1] == nil then
return 'No data found for table'
end
local out = mw.html.create('table')
local out = mw.html.create('table')
:addClass('wikitable sortable')
:addClass('wikitable sortable')
:tag('caption')
:wikitext('This list is updated dynamically. '..purge())
:done()
:tag('tr')
:tag('tr')
:tag('th')
:tag('th')
Line 180: Line 135:
:done()
:done()
: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
for i, item in ipairs(results) do
local row = out:tag('tr')
local row = out:tag('tr')
:IF(item.lvl)
--level
:IF(item.level)
:tag('td')
:tag('td')
:css{ ['text-align'] = 'center' }
:css{ ['text-align'] = 'center' }
:wikitext(item.lvl)
:wikitext(item.level)
:done()
:done()
:ELSE()
:ELSE()
:node(plist.unknown_value_edit_cell(item.pageName,1))
:node(unknown_value_cell)
:END()
:END()
-- recipe
:node(plist.three_column_image_text(item.product,item.output[1].quantity,'File:' .. item.product .. '.png',item.product,item.product))
-- materials
:node(plist.one_column_image_text(item.materials))
:node(plist.currency_cell(item.buyPrice))
:node(plist.currency_cell(item.sellPrice))
:node(plist.currency_cell(item.profit))
:node(plist.currency_cell(item.profitPerHour))


:tag('td')
-- XP
:IF(item.xp)
:css{ ['border-right'] = '0', ['padding-right'] = '0', ['text-align'] = 'right' }
:attr{ ['data-sort-value'] = item.name }
:wikitext(item.outputQuantity .. ' ×')
:done()
:tag('td')
:addClass('plinkt-image no-border')
:css{ ['border-left'] = '0', ['padding-left'] = '0' }
:IF(item.imgResult)
:wikitext('[[File:' .. item.name .. '.png|link=' .. item.name .. '|30px]]')
:END()
:done()
:tag('td')
:addClass('plinkt-link no-border')
:wikitext('[[' .. item.name .. ']]')
:done()

local materialCell = row:tag('td')

for i, _ in ipairs(item.materials) do
materialCell:wikitext(item.materials[i].quantity .. '&times; [[File:' .. item.materials[i].name .. '.png|18px|link=' .. item.materials[i].name .. ']] [[' .. item.materials[i].name .. ']]<br>')
end
row
:node(currency_cell(item.buy))
:node(currency_cell(item.sell))
:node(currency_cell(item.profit))
:node(currency_cell(item.profitPerHour))

:IF(item.XP)
:tag('td')
:tag('td')
:wikitext(item.XP and lang:formatNum(tonumber(item.XP)))
:wikitext(item.xp and lang:formatNum(tonumber(item.xp)))
:done()
:done()
:ELSE()
:ELSE()
:node(plist.unknown_value_edit_cell(item.allPageEdits,1))
:node(unknown_value_cell)
:END()
:END()

-- XP per hour
:IF(item.XPPerHour)
:IF(item.xpPerHour)
:tag('td')
:tag('td')
:wikitext(item.XPPerHour and lang:formatNum(tonumber(item.XPPerHour)))
:wikitext(item.xpPerHour and lang:formatNum(tonumber(item.xpPerHour)))
:done()
:done()
:ELSE()
:ELSE()
:node(unknown_value_cell)
:node(plist.unknown_value_cell(1))
:END()
:END()

-- XP per hour
:node(currency_cell(item.profitPerXP))
:node(plist.currency_cell(item.profitPerXP))

:done()
:done()
end
end

Latest revision as of 07:41, 1 January 2025

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

require('strict')
require('Module:Mw.html extension')
local lang = mw.getContentLanguage()
local plist = require('Module:ProfessionList')
local purge = require('Module:Purge')._purge

local p = {}

-- non dynamic module, no inputs
function p.main()
	
	local queryString = '[[Category:Chef]] AND [[Category:Pages with recipes]] AND [[-Sold item.Sold by::Head Chef (shop)]]'
	
	local function screenFunction(item)
		return not item.passive
	end
	
	local results = plist.generate_recipe_table(queryString,screenFunction)

	results = p.formatResults(results)

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

end

-- do calculations and determine strings to go in cells
function p.formatResults(results)
	
	--simple check for nil results
	if results ==nil or results[1] == nil then
		return nil
	end
	
	-- iterate through products
	for _, item in ipairs(results) do
		
		-- list of all pages to edit, if edit is needed
		item.allPageEdits = { item.pageName }
		for _,intermediate in ipairs(item.intermediateMaterials) do
			table.insert(item.allPageEdits,intermediate.name)
		end

		-- profitability
		item.profitPerXP = item.profit and item.xp and item.profit / item.xp
		
		-- iterate through materials, keep track of how many materials are needed from each shop
		item.fishShopTrips = 0
		item.vegShopTrips = 0
		for _, material in ipairs(item.materials) do
		
			-- query which shop sold it, add to running total
			local shopNameQuery = '[[:+]][[Sold item::' .. material.name .. ']]|?Sold by #-=data|mainlabel=' .. material.name
			local shopNameResult = mw.smw.ask(shopNameQuery) or {}
			local shopName = (shopNameResult and shopNameResult[1] and shopNameResult[1].data) or ''

			if shopName=="The Frequently Fresh Fish Stall" then
				item.fishShopTrips = item.fishShopTrips + 1
			elseif shopName=="Kevin's Ingredients" then
				item.vegShopTrips = item.vegShopTrips + 1
			end

		end
		
		-- there will be extra time spent buying and selling items, and moving between stations
		-- assume make one trip to buy 24 of each material from each shop per batch of 24 food
		local batchSize = 24
		-- 20 seconds moving between stations per 24 made
		-- 30 seconds per trip to Kevin's Ingredients
		-- 60 seconds per trip to the fish shop
		-- are these results optimal? no. are they approximate? yes
		local downtime = 20 + item.vegShopTrips * 30 + item.fishShopTrips * 60
		item.duration = item.duration and item.duration + downtime/batchSize
		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)
	
	--simple check for nil results
	if results ==nil or results[1] == nil then
		return 'No data found for table'
	end
	
	local out = mw.html.create('table')
		:addClass('wikitable sortable')
		:tag('caption')
			:wikitext('This list is updated dynamically. '..purge())
		:done()
		:tag('tr')
			:tag('th')
				:wikitext('[[File:Chef small icon.png|15px]]  Level')
			:done()
			:tag('th')
				:attr{ colspan = '3' }
				:wikitext('Products')
			:done()
			:tag('th')
				:wikitext('Materials')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Buy Value')
			:done()
			:tag('th')
				:attr{ colspan = '10' }
				:wikitext('Sell 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()

	for i, item in ipairs(results) do
		local row = out:tag('tr')
		
			--level
			:IF(item.level)
				:tag('td')
					:css{ ['text-align'] = 'center' }
					:wikitext(item.level)
				:done()
			:ELSE()
				:node(plist.unknown_value_edit_cell(item.pageName,1))
			:END()
			
			-- recipe
			:node(plist.three_column_image_text(item.product,item.output[1].quantity,'File:' .. item.product .. '.png',item.product,item.product))
			
			-- materials
			:node(plist.one_column_image_text(item.materials))
			:node(plist.currency_cell(item.buyPrice))
			:node(plist.currency_cell(item.sellPrice))
			:node(plist.currency_cell(item.profit))
			:node(plist.currency_cell(item.profitPerHour))

			-- XP
			:IF(item.xp)
				:tag('td')
					:wikitext(item.xp and lang:formatNum(tonumber(item.xp)))
				:done()
			:ELSE()
				:node(plist.unknown_value_edit_cell(item.allPageEdits,1))
			:END()
			
			-- XP per hour
			:IF(item.xpPerHour)
				:tag('td')
					:wikitext(item.xpPerHour and lang:formatNum(tonumber(item.xpPerHour)))
				:done()
			:ELSE()
				:node(plist.unknown_value_cell(1))
			:END()
			
			-- XP per hour
			:node(plist.currency_cell(item.profitPerXP))
			
		:done()
	end

	return out
end

return p