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 and ids ~= nil then
		local qb = QueryBuilder.new()
		qb
			:setTables('Cards')
			:setFields([[
				_pageName,
				thumbnail
			]])
			:addWhereList('card_id', '=', ids, ',', 'OR')
		
		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
			
			return content
		end
	end
	
	return nil
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')
		: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'])
        
	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
			},
			{
				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
			}
		}
		:setData(qb:query())
	
	return datatable:tostring()

end

return p