Module:Usedin

Documentation for this module may be created at Module:Usedin/doc

local p = {}
local cargo = mw.ext.cargo
local NumberFormater = require('Module:NumberFormater')
local tooltipstruct = [[<span class="simple-tooltip simple-tooltip-inline tooltipstered" style="color: #b847cb;" data-simple-tooltip="%s">%s</span>]]
local rowstruct = [=[<tr>
    <td>[[File:%s.%s|40px|link=]] [[%s]]</td>
    <td>%s</td>
    <td>%s</td>
    </tr>]=]
local ret = {}

local function QuerySmithingRecipes(item)
	local tables = 'AnvilCraft'
	-- Multi-column dependent quantities so query them all.
    local fields = '_pageName, Item, Resource1, Resource2, Resource3, Resource4, Quantity1, Quantity2, Quantity3, Quantity4'
    local args = {
        where = 'AnvilCraft.Resource1="'.. item ..'" OR ' .. 'AnvilCraft.Resource2="'.. item ..'" OR ' .. 'AnvilCraft.Resource3="'.. item ..'" OR ' .. 'AnvilCraft.Resource4="'.. item ..'"',
        orderBy = 'AnvilCraft.Item'
    }
    local results = cargo.query( tables, fields, args )
	-- if there are any results.
    if #results > 0 then
    	for r = 1, #results do
    		-- Set specific quantity
    		local quantity
    		if results[r].Resource1 == item then
    			quantity = tostring(results[r].quantity1)
    		elseif results[r].Resource2 == item then
    			quantity = tostring(results[r].quantity2)
    		elseif results[r].Resource3 == item then
    			quantity = tostring(results[r].quantity3)
    		elseif results[r].Resource4 == item then
    			quantity = tostring(results[r].quantity4)
    		end
    		-- Build string and add to return table
    		ret[#ret+1] = string.format(rowstruct, results[r].Item, "png", results[r]._pageName, 
    			string.format(tooltipstruct, NumberFormater.formatnumber(quantity), NumberFormater.formatwithseperator(quantity)), "Smithing" )
    	end
    end
end

local function QueryStamps(item)
	local tables = 'Stamps'
	local fields = '_pageName, Bonus'
    local args = {
        where = 'Stamps.Material="'.. item .. '"',
        orderBy = 'Stamps._pageName'
    }
    local results = cargo.query( tables, fields, args )
	if #results > 0 then
		for r = 1, #results do
			ret[#ret+1] = string.format(rowstruct, results[r]._pageName, "png", results[r]._pageName, 
				"Lots", "Stamps" .. string.format(tooltipstruct, results[4].Bonus, "More Info."))
		end
	end
end

local function QueryExtraData(item)
	local tables = 'UsedinExtraData'
	local fields = 'Icon, Source, Amount, Type'
    local args = {
        where = 'UsedinExtraData.Item="'.. item .. '"',
        orderBy = 'UsedinExtraData.Source'
    }
    local results = cargo.query( tables, fields, args )
	if #results > 0 then
		for r = 1, #results do
			ret[#ret+1] = string.format(rowstruct, results[r].Icon, "png", results[r].Source, results[r].Amount, results[r].Type)
		end
	end
end

-- <tr><td>{{#if:{{{Icon|}}}|[[File:{{{Icon}}}.gif|40px|link=]] }}{{{Name}}}</td><td>{{NumberNabber|{{{Quantity}}}|{{PAGENAME}}}}</td><td>{{{Source}}}</td></tr>
local function QueryQuests(item)
	local tables = 'Quests'
    local fields = '_pageName, QuestName, Requirements'
    local temp = ''
    local args = {
        where = 'Quests.Requirements LIKE "%>'.. item ..'<%"',
        groupBy = 'Quests._pageName',
    }
    local results = cargo.query( tables, fields, args )
	if #results > 0 then
		local nabber = require('Module:Loops') --testing direct call
		for r = 1, #results do
			local args = {}
			args.searchText = item
			args.list = results[r].Requirements
			ret[#ret+1] = string.format(rowstruct, results[r]._pageName, "gif",
				string.format('%s#%s|%s', results[r]._pageName, results[r].QuestName, results[r].QuestName), nabber.numberNabberMain(args), "Quests")
		end
	end
end

function p.main(frame)
	local item = frame.args[1]
	local header = [[<table class='wikitable sortable mw-collapsible' style ='min-width:45%%'><caption class='nowrap'>What %s is used in</caption><tr><th>Name</th><th>Quantity</th><th>Type</th><tr>]]
	QuerySmithingRecipes(item)
	QueryStamps(item)
	QueryExtraData(item)
	QueryQuests(item)
	
	if #ret > 0 then
		return string.format(header, item) .. table.concat(ret) .. "</table>"
	end
	return '' -- return empty string if there are no results.
end

return p