Module:Companies/Search - Revision history

Couchor at 17:00, 26 March 2024

2024-03-26T17:00:28Z

← Older revision		Revision as of 17:00, 26 March 2024
Line 28:		Line 28:
	function query(args)		function query(args)
	local whereStr = ''		local whereStr = ''

			if args.type then whereStr = whereStr .. 'db_type HOLDS "' .. args.type .. '"' end

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

Couchor at 16:40, 26 March 2024

2024-03-26T16:40:57Z

← Older revision		Revision as of 16:40, 26 March 2024
Line 28:		Line 28:
	function query(args)		function query(args)
	local whereStr = ''		local whereStr = ''

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

	local tables = 'Companies'		local tables = 'Companies'

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

2024-03-13T21:55:26Z

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

New page

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

local cargo = mw.ext.cargo

local limit = 100000

local CompaniesList = {}

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

if #results > 0 then
local container = mw.html.create('div'):attr('id', 'companies-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 = 'Companies'
local fields = '_pageName'
local cargoArgs = {
where = whereStr,
orderBy = '_pageName DESC',
limit = limit
}
local results = cargo.query(tables, fields, cargoArgs)

return results
end

return CompaniesList