Module:Locations/Full list - Revision history

Couchor at 12:32, 9 April 2024

2024-04-09T12:32:23Z

← Older revision		Revision as of 12:32, 9 April 2024
Line 48:		Line 48:
	where = whereStr,		where = whereStr,
	orderBy = "_pageData._modificationDate DESC",		orderBy = "_pageData._modificationDate DESC",
			limit = limit
	}		}

Couchor at 15:02, 26 March 2024

2024-03-26T15:02:41Z

← Older revision		Revision as of 15:02, 26 March 2024
Line 47:		Line 47:
	join = 'Locations._pageName = _pageData._pageName',		join = 'Locations._pageName = _pageData._pageName',
	where = whereStr,		where = whereStr,
	~~limit = 20,~~
	orderBy = "_pageData._modificationDate DESC",		orderBy = "_pageData._modificationDate DESC",
	}		}

Couchor at 14:56, 26 March 2024

2024-03-26T14:56:48Z

← Older revision		Revision as of 14:56, 26 March 2024
Line 28:		Line 28:
	local whereStr = ''		local whereStr = ''

	local tables = 'Locations'		if args.type then whereStr = whereStr .. 'Locations.type HOLDS "' .. args.type .. '"' end
	local fields = '_pageName'		if args.country then
			local countries = mw.text.split(args.country, ',')
			if whereStr ~= '' then whereStr = whereStr .. ' AND ' end
			whereStr = whereStr .. '('
			for i = 1, #countries do
			if i > 1 then whereStr = whereStr .. ' OR ' end
			whereStr = whereStr .. 'Locations.country="' .. countries[i] .. '"'
			end
			whereStr = whereStr .. ')'
			end

			if args.name then whereStr = whereStr .. (whereStr ~= '' and ' AND ' or '') .. 'Locations._pageName LIKE "%' .. args.name .. '%"' end

			local tables = 'Locations, _pageData'
			local fields = 'Locations._pageName=_pageName, Locations.franchise=franchise, Locations.country=country, Locations.city=city, Locations.type=type'
	local cargoArgs = {		local cargoArgs = {
			join = 'Locations._pageName = _pageData._pageName',
	where = whereStr,		where = whereStr,
	~~orderBy~~ = ~~'_pageName DESC'~~,		limit = 20,
	~~limit~~ = ~~limit~~		orderBy = "_pageData._modificationDate DESC",
	}		}

	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)

Couchor at 21:54, 13 March 2024

2024-03-13T21:54:05Z

← Older revision		Revision as of 21:54, 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

Couchor: Created page with "local getArgs = require('Module:Arguments').getArgs local News = require('Module:NewsItem') local cargo = mw.ext.cargo local limit = 100000 local LocationsList = {} function LocationsList.main(frame) local args = getArgs(frame) local results = query( args) if #results > 0 then local container = mw.html.create('div'):attr('id', 'locations-search-container') local ul = mw.html.create('ul') for r = 1, #results do ul:node(mw.html.create('li'):node('[['..."

2024-03-13T21:51:47Z

Created page with "local getArgs = require('Module:Arguments').getArgs local News = require('Module:NewsItem') local cargo = mw.ext.cargo local limit = 100000 local LocationsList = {} function LocationsList.main(frame) local args = getArgs(frame) local results = query( args) if #results > 0 then local container = mw.html.create('div'):attr('id', 'locations-search-container') local ul = mw.html.create('ul') for r = 1, #results do ul:node(mw.html.create('li'):node('[['..."

New page

local getArgs = require('Module:Arguments').getArgs
local News = require('Module:NewsItem')
local cargo = mw.ext.cargo

local limit = 100000

local LocationsList = {}

function LocationsList.main(frame)
local args = getArgs(frame)
local results = query( args)

if #results > 0 then
local container = mw.html.create('div'):attr('id', 'locations-search-container')

local ul = mw.html.create('ul')

for r = 1, #results do
ul:node(mw.html.create('li'):node('[[' .. results[r]._pageName .. ']]'))
end

container:node(ul)

return container
end
end

function query(args)
local whereStr = ''

local tables = 'Locations'
local fields = '_pageName'
local cargoArgs = {
where = whereStr,
orderBy = '_pageName DESC',
limit = limit
}
local results = cargo.query(tables, fields, cargoArgs)

return results
end

return LocationsList