Module:CompanyLanding - Revision history

Couchor at 08:23, 16 January 2024

2024-01-16T08:23:15Z

← Older revision		Revision as of 08:23, 16 January 2024
Line 31:		Line 31:
	function p.query(page)		function p.query(page)
	local tables = 'Companies'		local tables = 'Companies'
	local fields = '_pageName, country~~, logo, logoDark, logoLight~~'		local fields = '_pageName, country'
	local cargoArgs = {		local cargoArgs = {
	limit = limit,		limit = limit,

Couchor at 20:08, 10 October 2023

2023-10-10T20:08:46Z

← Older revision		Revision as of 20:08, 10 October 2023
Line 55:		Line 55:
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]
	pageDisplayName = ~~string~~.~~gsub~~(result._pageName~~, 'Companies/', ''~~)		pageDisplayName = mw.ext.displaytitle.get(result._pageName)
	local firstLetter = string.upper(string.sub(pageDisplayName, 1, 1))		local firstLetter = string.upper(string.sub(pageDisplayName, 1, 1))

Couchor at 20:07, 10 October 2023

2023-10-10T20:07:19Z

← Older revision		Revision as of 20:07, 10 October 2023
Line 64:		Line 64:
	end		end

	local company = mw.html.create('li'):wikitext('[[' .. result._pageName ~~.. '\|' .. pageDisplayName~~ .. ']]')		local company = mw.html.create('li'):wikitext('[[' .. result._pageName .. ']]')

	list = list .. tostring(company)		list = list .. tostring(company)

Couchor at 20:24, 29 September 2023

2023-09-29T20:24:24Z

← Older revision		Revision as of 20:24, 29 September 2023
Line 31:		Line 31:
	function p.query(page)		function p.query(page)
	local tables = 'Companies'		local tables = 'Companies'
	local fields = '_pageName~~, page~~, country, logo, logoDark, logoLight'		local fields = '_pageName, country, logo, logoDark, logoLight'
	local cargoArgs = {		local cargoArgs = {
	limit = limit,		limit = limit,
	offset = (page - 1) * limit,		offset = (page - 1) * limit,
	orderBy = '~~page~~ ASC'		orderBy = '_pageName ASC'
	-- orderBy = 'SUBSTRING(_pageName, LENGTH("Companies/" + 1)'		-- orderBy = 'SUBSTRING(_pageName, LENGTH("Companies/" + 1)'
	}		}
Line 49:		Line 49:

	if #results > 0 then		if #results > 0 then
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(~~results[1].page~~, 1, 1))		local pageDisplayName = string.gsub(results[1]._pageName, 'Companies/', '')
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(~~results[1].page~~, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(pageDisplayName, 1, 1))
			if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(pageDisplayName, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	if page == 1 then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if page == 1 then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]
			pageDisplayName = string.gsub(result._pageName, 'Companies/', '')
	local firstLetter = string.upper(string.sub(~~result.page~~, 1, 1))		local firstLetter = string.upper(string.sub(pageDisplayName, 1, 1))

	-- Create new list for entries with next starting letter		-- Create new list for entries with next starting letter
Line 63:		Line 64:
	end		end

	local company = mw.html.create('li'):wikitext('[[' .. result._pageName .. '\|' .. ~~result.page~~ .. ']]')		local company = mw.html.create('li'):wikitext('[[' .. result._pageName .. '\|' .. pageDisplayName .. ']]')

	list = list .. tostring(company)		list = list .. tostring(company)

Couchor at 22:02, 27 September 2023

2023-09-27T22:02:27Z

← Older revision		Revision as of 22:02, 27 September 2023
Line 51:		Line 51:
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	if ~~not VariablesLua.varexists('firstLetter')~~ then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if page == 1 then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]

Couchor at 22:00, 27 September 2023

2023-09-27T22:00:44Z

← Older revision		Revision as of 22:00, 27 September 2023
Line 51:		Line 51:
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
			if not VariablesLua.varexists('firstLetter') then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]

Couchor at 21:59, 27 September 2023

2023-09-27T21:59:07Z

← Older revision		Revision as of 21:59, 27 September 2023
Line 50:		Line 50:
	if #results > 0 then		if #results > 0 then
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))
	~~list = list .. 'LETTER ON: ' .. letter~~		if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter))
	~~-- else list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter))~~
	end
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]

Couchor at 21:58, 27 September 2023

2023-09-27T21:58:32Z

← Older revision		Revision as of 21:58, 27 September 2023
Line 51:		Line 51:
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))
	list = list .. 'LETTER ON: ' .. letter		list = list .. 'LETTER ON: ' .. letter
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) else list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter))
			-- else list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter))
			end
	for i = 1, #results do		for i = 1, #results do
	local result = results[i]		local result = results[i]

Couchor at 21:57, 27 September 2023

2023-09-27T21:57:02Z

← Older revision		Revision as of 21:57, 27 September 2023
Line 56:		Line 56:

	local firstLetter = string.upper(string.sub(result.page, 1, 1))		local firstLetter = string.upper(string.sub(result.page, 1, 1))
	~~list = list .. 'FIRST LTTER: ' .. firstLetter~~
	-- Create new list for entries with next starting letter		-- Create new list for entries with next starting letter
	if firstLetter ~= letter then		if firstLetter ~= letter then

Couchor at 21:56, 27 September 2023

2023-09-27T21:56:33Z

← Older revision		Revision as of 21:56, 27 September 2023
Line 50:		Line 50:
	if #results > 0 then		if #results > 0 then
	local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))		local letter = VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') or string.upper(string.sub(results[1].page, 1, 1))
			list = list .. 'LETTER ON: ' .. letter
	if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) else list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end		if VariablesLua.varexists('firstLetter') and VariablesLua.var('firstLetter') ~= string.upper(string.sub(results[1].page, 1, 1)) then list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) else list = list .. tostring(mw.html.create('div'):css('font-weight', '800'):wikitext(letter)) end
	for i = 1, #results do		for i = 1, #results do
Line 55:		Line 56:

	local firstLetter = string.upper(string.sub(result.page, 1, 1))		local firstLetter = string.upper(string.sub(result.page, 1, 1))
			list = list .. 'FIRST LTTER: ' .. firstLetter
	-- Create new list for entries with next starting letter		-- Create new list for entries with next starting letter
	if firstLetter ~= letter then		if firstLetter ~= letter then