Module:Commerce form query sandbox

Documentation for this module may be created at Module:Commerce form query sandbox/doc

local p = {}
local cargo = mw.ext.cargo

function p.Main(frame)

local tierexist = false
local categoryexist = false
local weightexist = false

 
--[Defining table and fields...]--
local table='GeneralData, _pageData'
local fields='GeneralData._pageName=Item,POWER(Commerce,1)/Weight=Value per Pound,Commerce,Weight'
--[Defining individual arguments for later...]--
local joinonargs='GeneralData._pageName=_pageData._pageName'

--[Get user defined fields set]--

--[Get Tier range]--
local mintier = frame.args.mintier
local maxtier = frame.args.maxtier
if mintier ~= nil and mintier ~= '' then
  tierexist = true                                              --[The user wants to specify by tier]
  if maxtier ~= nil and maxtier ~= '' then
    if maxtier < mintier then
      maxtier=mintier   --[if maxtier is smaller than mintier, set equal to mintier, else left alone]
    end
  else 
    maxtier=999999
  end
end

--[Get Weight range]--
local minweight = frame.args.minweight
local maxweight = frame.args.maxweight
if minweight ~= nil and minweight ~= '' then
  weightexist = true                                         --[The user wants to specify by weight]
  if maxweight ~= nil and maxweight ~= '' then
    if maxweight < minweight then
      maxweight=minweight --[if maxweight is smaller than minweight, set equal to minweight, else left alone]
    end
  else 
    maxweight=999999
  end
end




end

function p.getquery(table, fields, args)
  return cargo.query(table, fields, args)
end

return p