Module:Event cards

To generate {{Event cards}}, invoke using the main function.

---

local getArgs          = require('Module:Arguments').getArgs
local DatatableBuilder = require('Module:DatatableBuilder')
local QueryBuilder     = require('Module:QueryBuilder')

local DisplayFns = require('Module:DisplayFunctions')

local VariablesLua = mw.ext.VariablesLua

local p = {}

local function formatLink(page, name)
	if page == nil or page == '' then return end
	return string.format('[[%s|%s]]', page, name or page)
end

local function makeBasicQueryBuilder(eventId)
	local qb = QueryBuilder.new()
	qb
		:setTables('cards, card_skills')
		:setFields([[
			cards._pageName = cardPageName,
			cards.card_name,
			cards.thumbnail,
			cards.card_character,
			cards.status,
			card_skills.skill_type
		]])
		:setJoinOn([[
			cards._pageID = card_skills._pageID
		]])
		:addWhere('card_id', '>', 0)
		:setOrderBy('cards.card_id ASC')
		:setGroupBy('cards._pageID')
		:setLimit(5)
	qb
		:addWhere('cards.event_id', '=', eventId)

	return qb
end

local function makeTable(caption, data)
	local datatable = DatatableBuilder.new()
	datatable
		:setCaption(caption)
		:setColumns{
			{
				name = 'thumbnail',
				header = 'Thumbnail',
				dataFields = { 'cards.thumbnail' },
				fn = DisplayFns.image('64px'),
				sortable = false
			},
			{
				name = 'name',
				header = 'Card name',
				dataFields = { 'cardPageName', 'cards.card_name' },
				fn = formatLink
			},
			{
				name = 'character',
				header = 'Character',
				dataFields = { 'cards.card_character' }
			},
			{
				name = 'status',
				header = 'Status',
				dataFields = { 'cards.status' }
			},
			{
				name = 'skill',
				header = 'Skill',
				dataFields = { 'card_skills.skill_type' },
				fn = formatLink
			},
		}
		:setData(data)

	return datatable
end

function p.main(frame)
	local args = getArgs(frame)

	local eventId = args['event id'] or VariablesLua.var('event id')
	local gachaId = args['debut gacha id']
	
	local gachaCardsQuery = makeBasicQueryBuilder(eventId)
		:addWhere('cards.gacha_id', '=', gachaId)
	local shopCardsQuery = makeBasicQueryBuilder(eventId)
		:addWhere('cards.acquire', 'HOLDS', 'Event Exchange Shop')
	
	local gachaCardsTable = makeTable('Gacha cards', gachaCardsQuery:query())
	local shopCardsTable  = makeTable('Event Exchange Shop cards', shopCardsQuery:query())

	return gachaCardsTable:tostring() .. shopCardsTable:tostring() 
end

return p