Module:Gacha datatable

To generate {{Gacha datatable}}, invoke using the main function.

---

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

local p = {}

local function formatLogo(logo)
	if logo then
		return string.format('[[File:%s|192px]]', logo)
	end
	
	return nil
end

local function formatName(pageName, gachaName)
	return string.format('[[%s|%s]]', pageName, gachaName)
end

local function formatRateUp(ids)
	if ids == nil then return nil end
	
	local qb = QueryBuilder.new()
	qb
		:setTables('Cards')
		:setFields([[
			_pageName,
			thumbnail
		]])
		:addWhereList('card_id', '=', ids, ',', 'OR')
		:setOrderBy('card_id ASC')
	
	local results = qb:query()
	
	if results and #results > 0 then
		local content = ''
		
		for _, card in ipairs(results) do
			content = content .. string.format(
				'[[File:%s|80px|link=%s]] ',
				card.thumbnail,
				card._pageName
			)
		end
		
		local wrapper = mw.html.create('div')
		wrapper
			:css({
				['display'] = 'flex',
				['flex-wrap'] = 'wrap',
				['gap'] = '5px'
			})
			:wikitext(content)
	
		return tostring(wrapper)
	end
end


function p.main(frame)
	local args = getArgs(frame)
	
	local qb = QueryBuilder.new()
	qb
		:setTables('gachas, gacha_rate_up')
		:setFields([[
			gachas._pageName,
			gachas.gacha_name,
			gachas.logo,
			DATE_FORMAT(DATE_ADD(gachas.start, INTERVAL 9 HOUR), "%Y/%m/%d, %H:%i JST") = start,
			DATE_FORMAT(DATE_ADD(gachas.end, INTERVAL 9 HOUR), "%Y/%m/%d, %H:%i JST") =  end,
			gacha_rate_up.ids
		]])
		:setJoinOn('gachas._pageID = gacha_rate_up._pageID')
		:addWhere('gachas.gacha_id', '>', 0)
		:setOrderBy('gachas.start ASC, gachas.gacha_id ASC')
		:setGroupBy('gachas._pageName')
		:setLimit(200)
	qb
   		:addWhere('start', '<', args['start before'])
		:addWhere('start', '>', args['start after'])
		:addWhere('end', '<', args['end before'])
		:addWhere('end', '>', args['end after'])
		:addWhereList(
			'type',
			'=',
			args['type'],
			',',
			'OR'
		)
        
	local datatable = DatatableBuilder.new()
	datatable
		:setColumns{
			{ 
				name = 'logo',
				header = 'Logo',
				dataFields = { 'gachas.logo' },
				func = formatLogo,
				css = { ['width'] = '192px' },
				sortable = false
			},
			{
				name = 'name',
				header = 'Gacha',
				dataFields = { 'gachas._pageName', 'gachas.gacha_name' },
				func = formatName,
				css = { ['min-width'] = '150px' },
			},
			{
				name = 'start',
				header = 'Start date',
				dataFields = { 'start' },
				css = { ['white-space'] = 'nowrap' }
			},
			{
				name = 'end',
				header = 'End date',
				dataFields = { 'end' },
				css = { ['white-space'] = 'nowrap' }
			},
			{
				name = 'rate up',
				header = 'Rate up cards',
				dataFields = { 'gacha_rate_up.ids' },
				func = formatRateUp,
				default = '',
				css = { ['min-width'] = '275px' },
			}
		}
		:setData({})
	
	return datatable:tostring() .. 
	'<p>Data table has been disabled, see [https://blog.sekaipedia.org/2023/04/unexpected-disruption-due-to-extension.html our blog post] for more details.</p>'
	..
	'<p>Consider using [[:Category:Gachas]] instead.</p>'

end

return p