Module:NewsSearch - Revision history

Couchor at 11:59, 19 April 2024

2024-04-19T11:59:19Z

← Older revision		Revision as of 11:59, 19 April 2024
Line 65:		Line 65:
	if args.title then		if args.title then
	args.title = string.gsub(args.title, '_', ' ')		args.title = string.gsub(args.title, '_', ' ')
	if ~~args.categories or args.games~~ then		if whereStr ~= '' then
	whereStr = whereStr .. ' AND _pageName ~~HOLDS~~ LIKE "%' .. args.title.. '%"'		whereStr = whereStr .. ' AND _pageName LIKE "%' .. args.title.. '%"'
	else		else
	whereStr = whereStr .. ' _pageName LIKE "%' .. args.title.. '%"'		whereStr = whereStr .. ' _pageName LIKE "%' .. args.title.. '%"'

Couchor at 11:54, 19 April 2024

2024-04-19T11:54:40Z

← Older revision		Revision as of 11:54, 19 April 2024
Line 68:		Line 68:
	whereStr = whereStr .. ' AND _pageName HOLDS LIKE "%' .. args.title.. '%"'		whereStr = whereStr .. ' AND _pageName HOLDS LIKE "%' .. args.title.. '%"'
	else		else
	whereStr = whereStr .. ' _pageName ~~HOLDS~~ LIKE "%' .. args.title.. '%"'		whereStr = whereStr .. ' _pageName LIKE "%' .. args.title.. '%"'
	end		end
	end		end

Couchor at 11:52, 19 April 2024

2024-04-19T11:52:19Z

← Older revision		Revision as of 11:52, 19 April 2024
Line 63:		Line 63:
	end		end

	if args.~~tag~~ then		if args.title then
	args.title = string.gsub(args.title, '_', ' ')		args.title = string.gsub(args.title, '_', ' ')
	if args.categories or args.games then		if args.categories or args.games then

Couchor at 11:51, 19 April 2024

2024-04-19T11:51:35Z

← Older revision		Revision as of 11:51, 19 April 2024
Line 60:		Line 60:
	else		else
	whereStr = whereStr .. ' tags HOLDS LIKE "%' .. args.tag .. '%"'		whereStr = whereStr .. ' tags HOLDS LIKE "%' .. args.tag .. '%"'
			end
			end

			if args.tag then
			args.title = string.gsub(args.title, '_', ' ')
			if args.categories or args.games then
			whereStr = whereStr .. ' AND _pageName HOLDS LIKE "%' .. args.title.. '%"'
			else
			whereStr = whereStr .. ' _pageName HOLDS LIKE "%' .. args.title.. '%"'
	end		end
	end		end

Couchor at 18:50, 13 March 2024

2024-03-13T18:50:58Z

← Older revision		Revision as of 18:50, 13 March 2024
Line 3:		Line 3:
	local cargo = mw.ext.cargo		local cargo = mw.ext.cargo

	local limit = 10		local limit = 100000

	local NewsSearch = {}		local NewsSearch = {}

Couchor at 18:50, 13 March 2024

2024-03-13T18:50:13Z

← Older revision		Revision as of 18:50, 13 March 2024
Line 1:		Line 1:
	local getArgs = require('Module:Arguments').getArgs		local getArgs = require('Module:Arguments').getArgs
			local News = require('Module:NewsItem')
	local cargo = mw.ext.cargo		local cargo = mw.ext.cargo

Line 8:		Line 9:
	function NewsSearch.main(frame)		function NewsSearch.main(frame)
	local args = getArgs(frame)		local args = getArgs(frame)
			local results = NewsSearch.query( args)

	if ~~args.games == nil and args.categories == nil and args.tag == nil~~ then		if #results > 0 then
	~~-- If initial load, then display nothing~~		local container = mw.html.create('div'):attr('id', 'news-search-container')
	~~if args.initial then return~~
	~~-- else return tableContainer:wikitext(table.concat(args, ', ')) end~~		local ul = mw.html.create('ul')
	~~else return~~ mw.html.create('div'):~~wikitext~~('~~At least one category or game needs to be chosen.~~'~~) end~~
	~~end~~		for r = 1, #results do
			ul:node(mw.html.create('li'):node(News.main(newsObject(results[r]))))
	~~if args.more then return NewsSearch.html(args.offset or 0~~, ~~args~~) ~~end~~		end

			container:node(ul)
	-- local ~~listContainer~~ = mw.html.create('~~div~~'):~~attr~~('~~id', 'list__container~~')
	~~-- tableContainer~~:node(~~listContainer)~~		return container
	~~local html = NewsSearch~~.~~html~~(~~args.offset or 0, args~~)

	~~if html == nil or html == '' then~~
	~~return '<div>No news found</div>'~~
	~~else~~
	~~return html~~
	~~-- local loadMore = frame~~:~~callParserFunction{ name = '#widget', args = { 'Pagination', id = 'list__container', template = 'NewsSearch', arg = mw.text.jsonEncode~~(~~{categories = args.categories}~~) ~~} }~~
	~~-- tableContainer:node(loadMore)~~
	end		end
	end		end

	function NewsSearch.query(~~offset,~~ args)		function NewsSearch.query(args)
	local whereStr = ''		local whereStr = ''

Line 74:		Line 68:
	where = whereStr,		where = whereStr,
	orderBy = 'date DESC',		orderBy = 'date DESC',
	limit = limit,		limit = limit
	~~offset = offset~~
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
Line 82:		Line 75:
	end		end

	function ~~NewsSearch.html~~(~~offset, args~~)		function newsObject(result)
	local ~~results~~ = ~~NewsSearch~~.~~query(offset~~, ~~args)~~		local object = {
	~~local list = ''~~		date = result.date,
			_pageName = result._pageName,
			category = result.category,
			game = result.game,
			content = result.content,
			author = result.author
			}

	~~if #results > 0 then~~		return object
	~~for i = 1, #results do~~
	~~local result = results[i]~~
	~~local image = mw.html.create('div'):wikitext('[[File:' .. result.image .. '\|300px]]')~~
	~~local title = mw.html.create('div'):addClass('news-latest-item-title'):wikitext(mw.ext.displaytitle.get(result._pageName))~~
	~~local description = getExcerpt(removeLinks(result.content))~~

	~~local dateString = mw.ustring.gsub(result.date, "%s(AM\|PM)$", "")~~

	~~-- Use os.date to convert the string to a table of date and time components~~
	local dateTimeTable = os.date("*t", os.time({year=string.sub(dateString, 1, 4), month=string.sub(dateString, 6, 7), day=string.sub(dateString, 9, 10), hour=tonumber(string.sub(dateString, 12, 13)) + ((string.sub(dateString, 22, 22) == "PM") and 12 or 0), min=string.sub(dateString, 15, 16), sec=string.sub(dateString, 18, 19)}))

	~~-- Use os.date again to format the date and time components into a desired format~~
	~~local formatedDate = os.date("%d %b %Y %H:%M", os.time(dateTimeTable))~~

	~~local date = mw.html.create('div'):wikitext(formatedDate)~~
	~~local text = mw.html.create('div'):addClass('news-latest-item-text'):node(title):node(description):node(date)~~
	local div = mw.html.create('div'):addClass('news-latest-item'):node(image):node(text):node(mw.html.create('div'):addClass('link-overlay'):wikitext('[[File:Team_placeholder_light.png\|1x1px\|link=' .. result._pageName .. ']]'))
	~~list = list .. tostring(div)~~
	~~end~~
	~~else~~
	return ~~nil~~
	~~end~~
	~~return list~~
	~~end~~

	~~function getExcerpt(text)~~
	~~return text:sub(1, 100)~~
	~~end~~

	~~function removeLinks(text)~~
	~~local result = text:gsub("%[%[(.-)\|.-%]%]", "%1"):gsub("%[%[(.-)%]%]", "%1")~~
	~~return result~~
	end		end

	return NewsSearch		return NewsSearch

Couchor at 14:40, 12 February 2024

2024-02-12T14:40:25Z

← Older revision		Revision as of 14:40, 12 February 2024
Line 2:		Line 2:
	local cargo = mw.ext.cargo		local cargo = mw.ext.cargo

	local limit = 25		local limit = 10

	local NewsSearch = {}		local NewsSearch = {}
Line 9:		Line 9:
	local args = getArgs(frame)		local args = getArgs(frame)

	if args.games == nil and args.categories == nil then return tableContainer:wikitext('At least one category or game needs to be chosen') end		if args.games == nil and args.categories == nil and args.tag == nil then
			-- If initial load, then display nothing
			if args.initial then return
			-- else return tableContainer:wikitext(table.concat(args, ', ')) end
			else return mw.html.create('div'):wikitext('At least one category or game needs to be chosen.') end
			end

			if args.more then return NewsSearch.html(args.offset or 0, args) end

	~~if args.more then return NewsSearch.html(args.page or 1, args) end~~

	~~local tableContainer = mw.html.create('div')~~		-- local listContainer = mw.html.create('div'):attr('id', 'list__container')
	local listContainer = mw.html.create('div'):attr('id', 'list__container')		-- tableContainer:node(listContainer)
	tableContainer:node(listContainer)		local html = NewsSearch.html(args.offset or 0, args)
	local html = NewsSearch.html(args.~~page~~ or 1, args)

	if html == nil or html == '' then		if html == nil or html == '' then
	return ~~listContainer:wikitext(~~'No news found')		return '<div>No news found</div>'
	else		else
	~~listContainer:node(~~html)		return html
	local loadMore = frame:callParserFunction{ name = '#widget', args = { 'Pagination', id = 'list__container', template = 'NewsSearch', arg = mw.text.jsonEncode({categories = args.categories}) } }		-- local loadMore = frame:callParserFunction{ name = '#widget', args = { 'Pagination', id = 'list__container', template = 'NewsSearch', arg = mw.text.jsonEncode({categories = args.categories}) } }
	tableContainer:node(loadMore)		-- tableContainer:node(loadMore)
	end		end

	~~return tableContainer~~
	end		end

	function NewsSearch.query(~~page~~, args)		function NewsSearch.query(offset, args)
	local whereStr = ''		local whereStr = ''

Line 55:		Line 58:
	end		end
	whereStr = whereStr .. ')'		whereStr = whereStr .. ')'
			end

			if args.tag then
			args.tag = string.gsub(args.tag, '_', ' ')
			if args.categories or args.games then
			whereStr = whereStr .. ' AND tags HOLDS LIKE "%' .. args.tag .. '%"'
			else
			whereStr = whereStr .. ' tags HOLDS LIKE "%' .. args.tag .. '%"'
			end
	end		end

	local tables = 'News'		local tables = 'News'
	local fields = '_pageName, date, category, game'		local fields = '_pageName, date, category, game, image, content'
	local cargoArgs = {		local cargoArgs = {
	where = whereStr,		where = whereStr,
	orderBy = 'date DESC',		orderBy = 'date DESC',
	limit = limit,		limit = limit,
	offset = ~~(page - 1) * limit~~		offset = offset
	}		}
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)

	return results		return results

	end		end

	function NewsSearch.html(~~page~~, args)		function NewsSearch.html(offset, args)
	local results = NewsSearch.query(~~page~~, args)		local results = NewsSearch.query(offset, args)
	local list = ''		local list = ''

Line 77:		Line 89:
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]
			local image = mw.html.create('div'):wikitext('[[File:' .. result.image .. '\|300px]]')
			local title = mw.html.create('div'):addClass('news-latest-item-title'):wikitext(mw.ext.displaytitle.get(result._pageName))
			local description = getExcerpt(removeLinks(result.content))

	local dateString = mw.ustring.gsub(result.date, "%s(AM\|PM)$", "")		local dateString = mw.ustring.gsub(result.date, "%s(AM\|PM)$", "")

Line 83:		Line 99:

	-- Use os.date again to format the date and time components into a desired format		-- Use os.date again to format the date and time components into a desired format
	local ~~formattedDate~~ = os.date("%d %b %Y %H:%M", os.time(dateTimeTable))		local formatedDate = os.date("%d %b %Y %H:%M", os.time(dateTimeTable))

	local news = mw.html.create('div'):~~wikitext~~(~~formattedDate~~ .. ' - [[' .. result._pageName .. ']]')		local date = mw.html.create('div'):wikitext(formatedDate)
	list = list .. tostring(~~news~~)		local text = mw.html.create('div'):addClass('news-latest-item-text'):node(title):node(description):node(date)
			local div = mw.html.create('div'):addClass('news-latest-item'):node(image):node(text):node(mw.html.create('div'):addClass('link-overlay'):wikitext('[[File:Team_placeholder_light.png\|1x1px\|link=' .. result._pageName .. ']]'))
			list = list .. tostring(div)
	end		end
	else		else
Line 92:		Line 110:
	end		end
	return list		return list
			end

			function getExcerpt(text)
			return text:sub(1, 100)
			end

			function removeLinks(text)
			local result = text:gsub("%[%[(.-)\|.-%]%]", "%1"):gsub("%[%[(.-)%]%]", "%1")
			return result
	end		end

	return NewsSearch		return NewsSearch

Couchor at 18:17, 18 October 2023

2023-10-18T18:17:11Z

← Older revision		Revision as of 18:17, 18 October 2023
Line 37:		Line 37:
	for i = 1, #categories do		for i = 1, #categories do
	if i ~= 1 then whereStr = whereStr .. ' OR ' end		if i ~= 1 then whereStr = whereStr .. ' OR ' end
	whereStr = whereStr .. ' category HOLDS "' .. categories[i] .. '"'		whereStr = whereStr .. ' category HOLDS WITHIN "' .. categories[i] .. '"'
	end		end
	whereStr = whereStr .. ')'		whereStr = whereStr .. ')'
Line 52:		Line 52:
	for i = 1, #games do		for i = 1, #games do
	if i ~= 1 then whereStr = whereStr .. ' OR ' end		if i ~= 1 then whereStr = whereStr .. ' OR ' end
	whereStr = whereStr .. ' game HOLDS "' .. games[i] .. '"'		whereStr = whereStr .. ' game HOLDS WITHIN "' .. games[i] .. '"'
	end		end
	whereStr = whereStr .. ')'		whereStr = whereStr .. ')'

Couchor at 21:01, 17 October 2023

2023-10-17T21:01:44Z

← Older revision		Revision as of 21:01, 17 October 2023
Line 37:		Line 37:
	for i = 1, #categories do		for i = 1, #categories do
	if i ~= 1 then whereStr = whereStr .. ' OR ' end		if i ~= 1 then whereStr = whereStr .. ' OR ' end
	whereStr = whereStr .. ' category HOLDS ~~WITHIN~~ "' .. categories[i] .. '"'		whereStr = whereStr .. ' category HOLDS "' .. categories[i] .. '"'
	end		end
	whereStr = whereStr .. ')'		whereStr = whereStr .. ')'
Line 52:		Line 52:
	for i = 1, #games do		for i = 1, #games do
	if i ~= 1 then whereStr = whereStr .. ' OR ' end		if i ~= 1 then whereStr = whereStr .. ' OR ' end
	whereStr = whereStr .. ' game HOLDS ~~WITHIN~~ "' .. games[i] .. '"'		whereStr = whereStr .. ' game HOLDS "' .. games[i] .. '"'
	end		end
	whereStr = whereStr .. ')'		whereStr = whereStr .. ')'

Couchor at 21:32, 28 July 2023

2023-07-28T21:32:38Z

← Older revision		Revision as of 21:32, 28 July 2023
Line 11:		Line 11:
	if args.games == nil and args.categories == nil then return tableContainer:wikitext('At least one category or game needs to be chosen') end		if args.games == nil and args.categories == nil then return tableContainer:wikitext('At least one category or game needs to be chosen') end

	if args.more then return NewsSearch.html(args.page or 1) end		if args.more then return NewsSearch.html(args.page or 1, args) end

	local tableContainer = mw.html.create('div')		local tableContainer = mw.html.create('div')