Module:BassaridEmployment: Difference between revisions

From MicrasWiki
Jump to navigationJump to search
NewZimiaGov (talk | contribs)
No edit summary
NewZimiaGov (talk | contribs)
No edit summary
Line 10: Line 10:
--  optional Hatch Ministry tempo (HatchMinistryDailyOpsBVR if present).
--  optional Hatch Ministry tempo (HatchMinistryDailyOpsBVR if present).
--
--
-- Usage:
-- Auditable output:
--  {{#invoke:BassaridEmployment|generateTable}}
--  Shows distinct product counts per company and per-row multipliers for each factor.
--  {{#invoke:BassaridEmployment|generateTable|city=Vaeringheim}}
--  {{#invoke:BassaridEmployment|generateTable|sector=Services}}
--  {{#invoke:BassaridEmployment|generateTable|limit=80}}
--  {{#invoke:BassaridEmployment|generateTable|dashboard=no}}


local p = {}
local p = {}
Line 76: Line 72:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- READ COMPANY ROSTERS FROM PRICE MODULE OUTPUT (breakdown table)
-- COMPANY ROSTERS + DISTINCT PRODUCT COUNTS FROM PRICE MODULE OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function extractCompaniesFromModule(modName, sectorLabel)
local function splitCellsByDoublePipe(line)
-- line starts with "| date [[PSSC]] || product || company || ..."
line = trim(line)
line = line:gsub("^|%s*", "")
local parts = mw.text.split(line, "||", true)
for i = 1, #parts do
parts[i] = trim(parts[i])
end
return parts
end
 
local function extractCompaniesAndDistinctProducts(modName, sectorLabel)
local ok, m = pcall(require, modName)
local ok, m = pcall(require, modName)
if not ok or not m or type(m.generateTable) ~= "function" then
if not ok or not m or type(m.generateTable) ~= "function" then
return {}, {}
return { present = false, companies = {}, productCount = {} }
end
end


-- Ask for full expanded breakdown so all rows appear
local out = m.generateTable({ args = { mode = "breakdown", collapse = "no" } }) or ""
local out = m.generateTable({ args = { mode = "breakdown", collapse = "no" } }) or ""


local companies = {}
local companies = {}
local seen = {}
local seenCompany = {}
local productCounts = {}
local productsSeenByCompany = {} -- company -> set(product)=true


for line in out:gmatch("[^\n]+") do
for line in out:gmatch("[^\n]+") do
line = trim(line)
line = trim(line)
-- Data row pattern: | <date> [[PSSC]] || <product> || <company> || ...
 
-- Data line in your price modules:
-- | <date> [[PSSC]] || <product> || <company> || <base> || <level> || ...
if line:match("^|%s*%d+/%d+/%d+%s*%[%[PSSC%]%]%s*||") then
if line:match("^|%s*%d+/%d+/%d+%s*%[%[PSSC%]%]%s*||") then
-- Split on "||"
local cells = splitCellsByDoublePipe(line)
local cells = {}
local product = stripWiki(cells[2] or "")
for cell in line:gmatch("([^|]-)%s*||%s*") do
local company = stripWiki(cells[3] or "")
cell = trim(cell)
 
if cell ~= "" then table.insert(cells, cell) end
if company ~= "" then
end
if not seenCompany[company] then
-- tail cell
seenCompany[company] = true
local tail = line:match("||%s*([^|].-)%s*$")
table.insert(companies, { name = company, sector = sectorLabel })
if tail then
end
tail = trim(tail)
if tail ~= "" then table.insert(cells, tail) end
end


-- expected: 1=date, 2=product, 3=company
if product ~= "" then
local company = cells[3]
productsSeenByCompany[company] = productsSeenByCompany[company] or {}
if company then
productsSeenByCompany[company][product] = true
company = stripWiki(company)
if company ~= "" then
if not seen[company] then
seen[company] = true
table.insert(companies, { name = company, sector = sectorLabel })
end
productCounts[company] = (productCounts[company] or 0) + 1
end
end
end
end
Line 123: Line 121:
end
end


return companies, productCounts
-- count distinct products per company
local distinctCount = {}
for company, set in pairs(productsSeenByCompany) do
local n = 0
for _ in pairs(set) do n = n + 1 end
distinctCount[company] = n
end
 
return { present = true, companies = companies, productCount = distinctCount }
end
end


local function buildCompanyRoster()
local function buildCompanyRosterAndCounts()
local roster = {}
local roster = {}
local counts = {}
local counts = {} -- company -> total distinct products across all modules (normally 1 sector)
local sectorOf = {} -- company -> sector (first seen)
local seen = {}
local seen = {}


local agCompanies, agCounts = extractCompaniesFromModule("Module:AutoUpdateAgPrices", "Agricultural")
local ag = extractCompaniesAndDistinctProducts("Module:AutoUpdateAgPrices", "Agricultural")
local mfCompanies, mfCounts = extractCompaniesFromModule("Module:AutoUpdateManfPrices", "Mining/Manufacturing")
local mf = extractCompaniesAndDistinctProducts("Module:AutoUpdateManfPrices", "Mining/Manufacturing")
local svCompanies, svCounts = extractCompaniesFromModule("Module:AutoUpdateServPrices", "Services")
local sv = extractCompaniesAndDistinctProducts("Module:AutoUpdateServPrices", "Services")


local function addAll(list, cts)
local function addPack(pack)
for _, c in ipairs(list or {}) do
for _, c in ipairs(pack.companies or {}) do
if not seen[c.name] then
if not seen[c.name] then
seen[c.name] = true
seen[c.name] = true
table.insert(roster, c)
table.insert(roster, c)
sectorOf[c.name] = c.sector
end
end
counts[c.name] = (counts[c.name] or 0) + (cts[c.name] or 0)
counts[c.name] = (counts[c.name] or 0) + (pack.productCount[c.name] or 0)
end
end
end
end


addAll(agCompanies, agCounts or {})
addPack(ag)
addAll(mfCompanies, mfCounts or {})
addPack(mf)
addAll(svCompanies, svCounts or {})
addPack(sv)


return roster, counts
return {
roster = roster,
productCounts = counts,
modulePresence = {
ag = ag.present, mf = mf.present, sv = sv.present
}
}
end
end


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- COST INDEX (avg adjusted vs base)
-- COST INDEX (avg adjusted vs base) from price modules
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function getCostIndex(moduleName)
local function getCostIndex(moduleName)
local ok, m = pcall(require, moduleName)
local ok, m = pcall(require, moduleName)
if not ok or not m or type(m.generateTable) ~= "function" then
if not ok or not m or type(m.generateTable) ~= "function" then
return { ratio = 1.0, avgNew = nil, avgBase = nil }
return { present = false, ratio = 1.0 }
end
end
local out = m.generateTable({ args = { mode = "summary" } }) or ""
local out = m.generateTable({ args = { mode = "summary" } }) or ""
Line 164: Line 178:
aNew, aBase = tonumber(aNew), tonumber(aBase)
aNew, aBase = tonumber(aNew), tonumber(aBase)
if not aNew or not aBase or aBase == 0 then
if not aNew or not aBase or aBase == 0 then
return { ratio = 1.0, avgNew = aNew, avgBase = aBase }
return { present = true, ratio = 1.0 }
end
end
return { ratio = aNew / aBase, avgNew = aNew, avgBase = aBase }
return { present = true, ratio = aNew / aBase }
end
 
local function sectorCostMultiplier(sec, costAg, costManf, costServ)
local r = 1.0
if sec == "Agricultural" then r = costAg.ratio or 1.0
elseif sec == "Mining/Manufacturing" then r = costManf.ratio or 1.0
elseif sec == "Services" then r = costServ.ratio or 1.0 end
return clamp(0.92 + (r - 1.0) * 0.20, 0.85, 1.12)
end
end


Line 175: Line 197:
local ok, m = pcall(require, "Module:BassaridMarketActivity")
local ok, m = pcall(require, "Module:BassaridMarketActivity")
if not ok or not m or type(m.generateTable) ~= "function" then
if not ok or not m or type(m.generateTable) ~= "function" then
return { avgPct = 0.0, bias = 0.0 }
return { present = false, bias = 0.0, avgPct = 0.0 }
end
end


Line 190: Line 212:
local avg = (n > 0) and (sum / n) or 0.0
local avg = (n > 0) and (sum / n) or 0.0
local bias = (n > 0) and ((pos - neg) / n) or 0.0
local bias = (n > 0) and ((pos - neg) / n) or 0.0
return { avgPct = avg, bias = bias }
return { present = true, bias = bias, avgPct = avg }
end
end


Line 205: Line 227:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- WEATHER SIGNAL + MULTIPLIER
-- WEATHER
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function getWeatherSignal(city, year, dayOfYear)
local function getWeatherSignal(city, year, dayOfYear)
local ok, wx = pcall(require, "Module:BassaridiaForecast")
local ok, wx = pcall(require, "Module:BassaridiaForecast")
if not ok or not wx or type(wx.getOpsData) ~= "function" then
if not ok or not wx or type(wx.getOpsData) ~= "function" then
return { level = 0, label = "Green", impacts = {}, condition = "" }
return { present = false, level = 0, label = "Green", impacts = {}, condition = "" }
end
end
local op = wx.getOpsData(city, year, dayOfYear)
local op = wx.getOpsData(city, year, dayOfYear)
if not op or not op.alert then
if not op or not op.alert then
return { level = 0, label = "Green", impacts = {}, condition = "" }
return { present = true, level = 0, label = "Green", impacts = {}, condition = "" }
end
end
return {
return {
present = true,
level = tonumber(op.alert.level) or 0,
level = tonumber(op.alert.level) or 0,
label = tostring(op.alert.label or "Green"),
label = tostring(op.alert.label or "Green"),
Line 252: Line 275:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- WAR LEAGUE TEMPO + MULTIPLIER
-- WAR LEAGUE TEMPO
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function getWarTempo(di)
local function getWarTempo(di)
local ok, wl = pcall(require, "Module:WarLeagueDivisionOpsBVR")
local ok, wl = pcall(require, "Module:WarLeagueDivisionOpsBVR")
if not ok or not wl or type(wl.makeTable) ~= "function" then
if not ok or not wl or type(wl.makeTable) ~= "function" then
return { score = 0, redRate = 0 }
return { present = false, score = 0, redRate = 0 }
end
end


Line 269: Line 292:
if rows == 0 then rows = 36 end
if rows == 0 then rows = 36 end
local severity = (high * 1.0 + critical * 2.0) / rows
local severity = (high * 1.0 + critical * 2.0) / rows
return { score = severity, redRate = (high + critical) / rows }
return { present = true, score = severity, redRate = (high + critical) / rows }
end
end


Line 285: Line 308:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- TEMPLE TEMPO + MULTIPLIER
-- TEMPLE TEMPO
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function getTempleTempo()
local function getTempleTempo()
local ok, tb = pcall(require, "Module:MissionaryDailyOpsBVR")
local ok, tb = pcall(require, "Module:MissionaryDailyOpsBVR")
if not ok or not tb or type(tb.makeTable) ~= "function" then
if not ok or not tb or type(tb.makeTable) ~= "function" then
return { redRate = 0 }
return { present = false, redRate = 0 }
end
end
local out = tb.makeTable({ args = { region = "Core", includeThreat = "no", showEcon = "no", limit = 40, showlegend = "no" } }) or ""
local out = tb.makeTable({ args = { region = "Core", includeThreat = "no", showEcon = "no", limit = 40, showlegend = "no" } }) or ""
Line 299: Line 322:
end
end
if n == 0 then n = 40 end
if n == 0 then n = 40 end
return { redRate = red / n }
return { present = true, redRate = red / n }
end
end


Line 311: Line 334:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- OPTIONAL HATCH MINISTRY TEMPO + MULTIPLIER  (FIXED)
-- OPTIONAL HATCH MINISTRY TEMPO
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function getHatchTempo(di)
local function getHatchTempo(di)
Line 324: Line 347:
for _ in out:gmatch("[Ii]nspect")  do c = c + 1 end
for _ in out:gmatch("[Ii]nspect")  do c = c + 1 end
for _ in out:gmatch("[Ss]eiz")      do c = c + 1 end
for _ in out:gmatch("[Ss]eiz")      do c = c + 1 end
return { present = true, intensity = c }
return { present = true, intensity = c }
end
end
Line 339: Line 361:


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-- BUILD BASE SHARES FROM PRODUCT-COUNTS
-- BASE SHARES (uses distinct product counts as size proxy)
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
local function buildBaseShares(roster, productCounts)
local function buildBaseShares(roster, productCounts)
local sectorTarget = {
local sectorTarget = { Agricultural = 0.34, ["Mining/Manufacturing"] = 0.33, Services = 0.33 }
["Agricultural"] = 0.34,
["Mining/Manufacturing"] = 0.33,
["Services"] = 0.33
}


local bySector = { Agricultural = {}, ["Mining/Manufacturing"] = {}, Services = {} }
local bySector = { Agricultural = {}, ["Mining/Manufacturing"] = {}, Services = {} }
Line 358: Line 376:
for _, c in ipairs(list) do
for _, c in ipairs(list) do
local nprod = productCounts[c.name] or 1
local nprod = productCounts[c.name] or 1
local w = (math.sqrt(nprod)) * (0.7 + hashFrac("w:" .. c.name) * 1.2) -- stable
-- weight: sqrt(distinct products) * stable factor
shares[c.name] = { sector = sec, raw = w, share = 0, nprod = nprod }
local w = math.sqrt(math.max(1, nprod)) * (0.7 + hashFrac("w:" .. c.name) * 1.2)
shares[c.name] = { share = 0, nprod = nprod, raw = w, sector = sec }
rawSum = rawSum + w
rawSum = rawSum + w
end
end
Line 368: Line 387:
end
end
end
end
return shares
return shares
end
end
Line 386: Line 404:
math.randomseed(di.year * 1000 + di.dayOfYear)
math.randomseed(di.year * 1000 + di.dayOfYear)


-- roster from the three price modules
-- roster + distinct product counts from the 3 modules
local roster, productCounts = buildCompanyRoster()
local rosterPack = buildCompanyRosterAndCounts()
local roster = rosterPack.roster
local productCounts = rosterPack.productCounts
 
if #roster == 0 then
if #roster == 0 then
return "''BassaridEmployment error: could not read company rosters from price modules.''"
return "''BassaridEmployment error: could not read company rosters from the three price modules.''"
end
end


local shares = buildBaseShares(roster, productCounts)
local shares = buildBaseShares(roster, productCounts)


-- costs
-- factor inputs
local costAg  = getCostIndex("Module:AutoUpdateAgPrices")
local costAg  = getCostIndex("Module:AutoUpdateAgPrices")
local costManf = getCostIndex("Module:AutoUpdateManfPrices")
local costManf = getCostIndex("Module:AutoUpdateManfPrices")
local costServ = getCostIndex("Module:AutoUpdateServPrices")
local costServ = getCostIndex("Module:AutoUpdateServPrices")


-- signals
local market = getMarketSentiment()
local market = getMarketSentiment()
local wx = getWeatherSignal(city, di.year, di.dayOfYear)
local wx = getWeatherSignal(city, di.year, di.dayOfYear)
Line 413: Line 433:
u = u + clamp((wx.level or 0) * 0.005, 0, 0.02)
u = u + clamp((wx.level or 0) * 0.005, 0, 0.02)
u = clamp(u, 0.02, 0.08)
u = clamp(u, 0.02, 0.08)
local employedPopulation = math.floor(population * (1 - u))
local employedPopulation = math.floor(population * (1 - u))
local function sectorCostMultiplier(sec)
local r = 1.0
if sec == "Agricultural" then r = costAg.ratio or 1.0
elseif sec == "Mining/Manufacturing" then r = costManf.ratio or 1.0
elseif sec == "Services" then r = costServ.ratio or 1.0 end
return clamp(0.92 + (r - 1.0) * 0.20, 0.85, 1.12)
end


local function combinedMultiplier(sec)
local function combinedMultiplier(sec)
local m = 1.0
local mCost = sectorCostMultiplier(sec, costAg, costManf, costServ)
m = m * sectorCostMultiplier(sec)
local mWx = weatherMultiplier(wx, sec)
m = m * weatherMultiplier(wx, sec)
local mWar = warMultiplier(war, sec)
m = m * warMultiplier(war, sec)
local mTemple = templeMultiplier(temple, sec)
m = m * templeMultiplier(temple, sec)
local mHatch = hatchMultiplier(hatch, sec)
m = m * hatchMultiplier(hatch, sec)
local mMkt = marketMultiplier(market, sec)
m = m * marketMultiplier(market, sec)
return clamp(mCost * mWx * mWar * mTemple * mHatch * mMkt, 0.65, 1.25),
return clamp(m, 0.65, 1.25)
      mCost, mWx, mWar, mTemple, mHatch, mMkt
end
end


Line 439: Line 450:
if showDashboard then
if showDashboard then
table.insert(out, "{| class=\"wikitable\" style=\"width:100%;\"")
table.insert(out, "{| class=\"wikitable\" style=\"width:100%;\"")
table.insert(out, "! colspan=\"4\" | General Port Employment Signals — " .. di.dateString)
table.insert(out, "! colspan=\"4\" | Employment factor audit — " .. di.dateString)
table.insert(out, "|-")
table.insert(out, string.format("| '''Rosters present''' || Ag=%s; Manf=%s; Serv=%s || '''Weather''' || %s (%s)",
tostring(rosterPack.modulePresence.ag),
tostring(rosterPack.modulePresence.mf),
tostring(rosterPack.modulePresence.sv),
(wx.label or "Green"), (wx.condition or "")))
table.insert(out, "|-")
table.insert(out, "|-")
table.insert(out, string.format("| '''Weather''' || %s (%s) || '''Market bias''' || %.2f",
table.insert(out, string.format("| '''Costs present''' || Ag=%s (%.3f); Manf=%s (%.3f); Serv=%s (%.3f) || '''Market present''' || %s (bias %.2f)",
(wx.label or "Green"), (wx.condition or ""), (market.bias or 0)))
tostring(costAg.present), (costAg.ratio or 1.0),
tostring(costManf.present), (costManf.ratio or 1.0),
tostring(costServ.present), (costServ.ratio or 1.0),
tostring(market.present), (market.bias or 0)))
table.insert(out, "|-")
table.insert(out, "|-")
table.insert(out, string.format("| '''Cost ratio (Ag/Manf/Serv)''' || %.3f / %.3f / %.3f || '''War tempo (red-rate)''' || %.2f",
table.insert(out, string.format("| '''War present''' || %s (red-rate %.2f) || '''Temple present''' || %s (red-rate %.2f)",
(costAg.ratio or 1.0), (costManf.ratio or 1.0), (costServ.ratio or 1.0),
tostring(war.present), (war.redRate or 0),
(war.redRate or 0)))
tostring(temple.present), (temple.redRate or 0)))
table.insert(out, "|-")
table.insert(out, "|-")
table.insert(out, string.format("| '''Temple tempo (red-rate)''' || %.2f || '''Unemployment (modeled)''' || %.2f%%",
table.insert(out, string.format("| '''Hatch present''' || %s (intensity %d) || '''Modeled unemployment''' || %.2f%%",
(temple.redRate or 0), u * 100))
tostring(hatch.present), (hatch.intensity or 0), u * 100))
table.insert(out, "|}")
table.insert(out, "|}")
table.insert(out, "")
table.insert(out, "")
Line 456: Line 476:
table.insert(out, '<div style="overflow-x:auto;">')
table.insert(out, '<div style="overflow-x:auto;">')
table.insert(out, "{| class=\"wikitable sortable\"")
table.insert(out, "{| class=\"wikitable sortable\"")
table.insert(out, "! Date !! Sector !! Company !! Products !! Base Share % !! Prev Emp. !! Curr Emp. !! Δ !! Drivers")
table.insert(out, "! Date !! Sector !! Company !! Products (distinct) !! Base Share % !! Prev Emp. !! Curr Emp. !! Δ !! mCost !! mWx !! mWar !! mTemple !! mHatch !! mMkt")


local n = 0
local n = 0
Line 464: Line 484:
local rec = shares[c.name]
local rec = shares[c.name]
local share = (rec and rec.share) or 0
local share = (rec and rec.share) or 0
local nprod = (rec and rec.nprod) or (productCounts[c.name] or 1)
local nprod = (rec and rec.nprod) or (productCounts[c.name] or 0)


local prev = math.max(1, math.floor(employedPopulation * share))
local prev = math.max(1, math.floor(employedPopulation * share))


local mAll, mCost, mWx, mWar, mTemple, mHatch, mMkt = combinedMultiplier(sec)
-- stable company/day jitter ±9%
local jitter = (hashFrac(string.format("jit:%s:%d:%d", c.name, di.year, di.dayOfYear)) - 0.5) * 0.18
local jitter = (hashFrac(string.format("jit:%s:%d:%d", c.name, di.year, di.dayOfYear)) - 0.5) * 0.18
local mult = combinedMultiplier(sec) * (1.0 + jitter)
local curr = math.max(1, math.floor(prev * mAll * (1.0 + jitter)))
local curr = math.max(1, math.floor(prev * mult))


local deltaSym = "•"
local deltaSym = "•"
Line 480: Line 502:
elseif curr == prev then rowStyle = ' style="background-color:lightgreen;"'
elseif curr == prev then rowStyle = ' style="background-color:lightgreen;"'
else rowStyle = ' style="background-color:#ffcccb;"' end
else rowStyle = ' style="background-color:#ffcccb;"' end
local drivers = string.format(
"cost×%.2f; wx×%.2f; war×%.2f; temple×%.2f; hatch×%.2f; mkt×%.2f",
sectorCostMultiplier(sec),
weatherMultiplier(wx, sec),
warMultiplier(war, sec),
templeMultiplier(temple, sec),
hatchMultiplier(hatch, sec),
marketMultiplier(market, sec)
)


table.insert(out, string.format(
table.insert(out, string.format(
"|-%s\n| %s || %s || %s || %d || %.3f%% || %d || %d || %s || %s",
"|-%s\n| %s || %s || %s || %d || %.3f%% || %d || %d || %s || %.2f || %.2f || %.2f || %.2f || %.2f || %.2f",
rowStyle,
rowStyle,
di.dateString,
di.dateString,
Line 502: Line 514:
curr,
curr,
deltaSym,
deltaSym,
drivers
mCost, mWx, mWar, mTemple, mHatch, mMkt
))
))



Revision as of 19:07, 19 January 2026

Documentation for this module may be created at Module:BassaridEmployment/doc

-- Module:BassaridEmployment
-- Employment report derived from company rosters inside:
--   Module:AutoUpdateAgPrices
--   Module:AutoUpdateManfPrices
--   Module:AutoUpdateServPrices
--
-- Factors:
--   costs (price-module ratios), weather (BassaridiaForecast), market (BassaridMarketActivity),
--   War League tempo (WarLeagueDivisionOpsBVR), Temple tempo (MissionaryDailyOpsBVR),
--   optional Hatch Ministry tempo (HatchMinistryDailyOpsBVR if present).
--
-- Auditable output:
--   Shows distinct product counts per company and per-row multipliers for each factor.

local p = {}

--------------------------------------------------------------------------------
-- UTIL
--------------------------------------------------------------------------------
local function trim(s)
	s = tostring(s or "")
	return (s:gsub("^%s+", ""):gsub("%s+$", ""))
end

local function stripWiki(s)
	s = tostring(s or "")
	s = s:gsub("%{%b{}%}", "")                                 -- templates
	s = s:gsub("%[%[[^%]|]+|([^%]]+)%]%]", "%1")               -- piped links
	s = s:gsub("%[%[([^%]]+)%]%]", "%1")                       -- plain links
	s = s:gsub("'''''", ""):gsub("'''", ""):gsub("''", "")     -- ital/bold
	s = s:gsub("&nbsp;", " ")
	return trim(s)
end

local function clamp(x, lo, hi)
	if x < lo then return lo end
	if x > hi then return hi end
	return x
end

local function hashFrac(s)
	local ok, h = pcall(function() return mw.hash.hashValue("md5", tostring(s or "")) end)
	if not ok or not h or #h < 8 then return 0.5 end
	local n = tonumber(h:sub(1, 8), 16) or 0
	return (n % 1000000) / 1000000
end

--------------------------------------------------------------------------------
-- DATE (PSSC)
--------------------------------------------------------------------------------
local DAYS_IN_YEAR = 183
local function getCurrentDateInfo()
	local startDate = os.time({year = 1999, month = 8, day = 6})
	local secondsInDay = 86400
	local now = os.time()
	local totalDays = math.floor((now - startDate) / secondsInDay)
	local yearFraction = totalDays / DAYS_IN_YEAR
	local psscYear = math.floor(yearFraction)
	local dayOfYear = math.floor((yearFraction - psscYear) * DAYS_IN_YEAR) + 1

	local month, dayOfMonth
	if dayOfYear <= 61 then month, dayOfMonth = 1, dayOfYear
	elseif dayOfYear <= 122 then month, dayOfMonth = 2, dayOfYear - 61
	else month, dayOfMonth = 3, dayOfYear - 122 end

	return {
		dateString = string.format("%d/%d/%d [[PSSC]]", dayOfMonth, month, psscYear),
		year = psscYear,
		dayOfYear = dayOfYear
	}
end

--------------------------------------------------------------------------------
-- COMPANY ROSTERS + DISTINCT PRODUCT COUNTS FROM PRICE MODULE OUTPUT
--------------------------------------------------------------------------------
local function splitCellsByDoublePipe(line)
	-- line starts with "| date [[PSSC]] || product || company || ..."
	line = trim(line)
	line = line:gsub("^|%s*", "")
	local parts = mw.text.split(line, "||", true)
	for i = 1, #parts do
		parts[i] = trim(parts[i])
	end
	return parts
end

local function extractCompaniesAndDistinctProducts(modName, sectorLabel)
	local ok, m = pcall(require, modName)
	if not ok or not m or type(m.generateTable) ~= "function" then
		return { present = false, companies = {}, productCount = {} }
	end

	local out = m.generateTable({ args = { mode = "breakdown", collapse = "no" } }) or ""

	local companies = {}
	local seenCompany = {}
	local productsSeenByCompany = {} -- company -> set(product)=true

	for line in out:gmatch("[^\n]+") do
		line = trim(line)

		-- Data line in your price modules:
		-- | <date> [[PSSC]] || <product> || <company> || <base> || <level> || ...
		if line:match("^|%s*%d+/%d+/%d+%s*%[%[PSSC%]%]%s*||") then
			local cells = splitCellsByDoublePipe(line)
			local product = stripWiki(cells[2] or "")
			local company = stripWiki(cells[3] or "")

			if company ~= "" then
				if not seenCompany[company] then
					seenCompany[company] = true
					table.insert(companies, { name = company, sector = sectorLabel })
				end

				if product ~= "" then
					productsSeenByCompany[company] = productsSeenByCompany[company] or {}
					productsSeenByCompany[company][product] = true
				end
			end
		end
	end

	-- count distinct products per company
	local distinctCount = {}
	for company, set in pairs(productsSeenByCompany) do
		local n = 0
		for _ in pairs(set) do n = n + 1 end
		distinctCount[company] = n
	end

	return { present = true, companies = companies, productCount = distinctCount }
end

local function buildCompanyRosterAndCounts()
	local roster = {}
	local counts = {} -- company -> total distinct products across all modules (normally 1 sector)
	local sectorOf = {} -- company -> sector (first seen)
	local seen = {}

	local ag = extractCompaniesAndDistinctProducts("Module:AutoUpdateAgPrices", "Agricultural")
	local mf = extractCompaniesAndDistinctProducts("Module:AutoUpdateManfPrices", "Mining/Manufacturing")
	local sv = extractCompaniesAndDistinctProducts("Module:AutoUpdateServPrices", "Services")

	local function addPack(pack)
		for _, c in ipairs(pack.companies or {}) do
			if not seen[c.name] then
				seen[c.name] = true
				table.insert(roster, c)
				sectorOf[c.name] = c.sector
			end
			counts[c.name] = (counts[c.name] or 0) + (pack.productCount[c.name] or 0)
		end
	end

	addPack(ag)
	addPack(mf)
	addPack(sv)

	return {
		roster = roster,
		productCounts = counts,
		modulePresence = {
			ag = ag.present, mf = mf.present, sv = sv.present
		}
	}
end

--------------------------------------------------------------------------------
-- COST INDEX (avg adjusted vs base) from price modules
--------------------------------------------------------------------------------
local function getCostIndex(moduleName)
	local ok, m = pcall(require, moduleName)
	if not ok or not m or type(m.generateTable) ~= "function" then
		return { present = false, ratio = 1.0 }
	end
	local out = m.generateTable({ args = { mode = "summary" } }) or ""
	local aNew, aBase = out:match("Average adjusted %(([%d%.]+)%) vs base %(([%d%.]+)%)")
	aNew, aBase = tonumber(aNew), tonumber(aBase)
	if not aNew or not aBase or aBase == 0 then
		return { present = true, ratio = 1.0 }
	end
	return { present = true, ratio = aNew / aBase }
end

local function sectorCostMultiplier(sec, costAg, costManf, costServ)
	local r = 1.0
	if sec == "Agricultural" then r = costAg.ratio or 1.0
	elseif sec == "Mining/Manufacturing" then r = costManf.ratio or 1.0
	elseif sec == "Services" then r = costServ.ratio or 1.0 end
	return clamp(0.92 + (r - 1.0) * 0.20, 0.85, 1.12)
end

--------------------------------------------------------------------------------
-- MARKET SENTIMENT
--------------------------------------------------------------------------------
local function getMarketSentiment()
	local ok, m = pcall(require, "Module:BassaridMarketActivity")
	if not ok or not m or type(m.generateTable) ~= "function" then
		return { present = false, bias = 0.0, avgPct = 0.0 }
	end

	local out = m.generateTable({ args = {} }) or ""
	local sum, n, pos, neg = 0, 0, 0, 0
	for pct in out:gmatch("([%+%-]?%d+%.?%d*)%%") do
		local v = tonumber(pct)
		if v then
			sum = sum + v
			n = n + 1
			if v > 0 then pos = pos + 1 elseif v < 0 then neg = neg + 1 end
		end
	end
	local avg = (n > 0) and (sum / n) or 0.0
	local bias = (n > 0) and ((pos - neg) / n) or 0.0
	return { present = true, bias = bias, avgPct = avg }
end

local function marketMultiplier(market, sector)
	local b = clamp(market.bias or 0, -1, 1)
	if sector == "Services" then
		return clamp(1.0 + b * 0.03, 0.95, 1.05)
	elseif sector == "Mining/Manufacturing" then
		return clamp(1.0 + b * 0.02, 0.96, 1.04)
	else
		return clamp(1.0 + b * 0.01, 0.97, 1.03)
	end
end

--------------------------------------------------------------------------------
-- WEATHER
--------------------------------------------------------------------------------
local function getWeatherSignal(city, year, dayOfYear)
	local ok, wx = pcall(require, "Module:BassaridiaForecast")
	if not ok or not wx or type(wx.getOpsData) ~= "function" then
		return { present = false, level = 0, label = "Green", impacts = {}, condition = "" }
	end
	local op = wx.getOpsData(city, year, dayOfYear)
	if not op or not op.alert then
		return { present = true, level = 0, label = "Green", impacts = {}, condition = "" }
	end
	return {
		present = true,
		level = tonumber(op.alert.level) or 0,
		label = tostring(op.alert.label or "Green"),
		condition = tostring(op.condition or ""),
		impacts = op.impacts or {}
	}
end

local function weatherMultiplier(wx, sector)
	local lvl = tonumber(wx.level or 0) or 0
	local m = 1.0
	if lvl == 1 then m = 0.98
	elseif lvl == 2 then m = 0.93
	elseif lvl >= 3 then m = 0.85 end

	local imp = wx.impacts or {}
	local g = tostring(imp.ground or "")
	local s = tostring(imp.sea or "")
	local a = tostring(imp.air or "")

	if sector == "Agricultural" then
		if g == "No-Go" then m = m * 0.75
		elseif g == "Degraded" then m = m * 0.90 end
	elseif sector == "Mining/Manufacturing" then
		if g == "No-Go" then m = m * 0.78
		elseif g == "Degraded" then m = m * 0.92 end
	elseif sector == "Services" then
		if s == "Closed" then m = m * 0.85
		elseif s == "Degraded" then m = m * 0.93 end
		if a == "No-Go" then m = m * 0.92 end
	end

	return clamp(m, 0.65, 1.10)
end

--------------------------------------------------------------------------------
-- WAR LEAGUE TEMPO
--------------------------------------------------------------------------------
local function getWarTempo(di)
	local ok, wl = pcall(require, "Module:WarLeagueDivisionOpsBVR")
	if not ok or not wl or type(wl.makeTable) ~= "function" then
		return { present = false, score = 0, redRate = 0 }
	end

	local out = wl.makeTable({ args = { rows = 36, showlegend = "no", seed = (di.year * 1000 + di.dayOfYear) } }) or ""
	local rows, high, critical = 0, 0, 0
	for u in out:gmatch("||%s*(LOW|MEDIUM|HIGH|CRITICAL)%s*||") do
		rows = rows + 1
		if u == "HIGH" then high = high + 1 end
		if u == "CRITICAL" then critical = critical + 1 end
	end
	if rows == 0 then rows = 36 end
	local severity = (high * 1.0 + critical * 2.0) / rows
	return { present = true, score = severity, redRate = (high + critical) / rows }
end

local function warMultiplier(war, sector)
	local s = tonumber(war.score or 0) or 0
	if sector == "Services" then
		return clamp(1.0 + (s * 0.08), 0.95, 1.18)
	elseif sector == "Mining/Manufacturing" then
		return clamp(1.0 + (s * 0.06), 0.95, 1.15)
	elseif sector == "Agricultural" then
		return clamp(1.0 - (s * 0.03), 0.88, 1.05)
	end
	return 1.0
end

--------------------------------------------------------------------------------
-- TEMPLE TEMPO
--------------------------------------------------------------------------------
local function getTempleTempo()
	local ok, tb = pcall(require, "Module:MissionaryDailyOpsBVR")
	if not ok or not tb or type(tb.makeTable) ~= "function" then
		return { present = false, redRate = 0 }
	end
	local out = tb.makeTable({ args = { region = "Core", includeThreat = "no", showEcon = "no", limit = 40, showlegend = "no" } }) or ""
	local red, n = 0, 0
	for sev in out:gmatch("||%s*(Green|Yellow|Red)%s*$") do
		n = n + 1
		if sev == "Red" then red = red + 1 end
	end
	if n == 0 then n = 40 end
	return { present = true, redRate = red / n }
end

local function templeMultiplier(temple, sector)
	local r = tonumber(temple.redRate or 0) or 0
	if sector == "Services" then
		return clamp(1.0 + (r * 0.06), 0.98, 1.10)
	end
	return clamp(1.0 + (r * 0.02), 0.98, 1.06)
end

--------------------------------------------------------------------------------
-- OPTIONAL HATCH MINISTRY TEMPO
--------------------------------------------------------------------------------
local function getHatchTempo(di)
	local ok, hm = pcall(require, "Module:HatchMinistryDailyOpsBVR")
	if not ok or not hm or type(hm.makeTable) ~= "function" then
		return { present = false, intensity = 0 }
	end

	local out = hm.makeTable({ args = { rows = 30, seed = (di.year * 1000 + di.dayOfYear) } }) or ""
	local c = 0
	for _ in out:gmatch("[Ii]nterdict") do c = c + 1 end
	for _ in out:gmatch("[Ii]nspect")   do c = c + 1 end
	for _ in out:gmatch("[Ss]eiz")      do c = c + 1 end
	return { present = true, intensity = c }
end

local function hatchMultiplier(hatch, sector)
	if not hatch or not hatch.present then return 1.0 end
	local x = tonumber(hatch.intensity or 0) or 0
	if sector == "Services" then
		return clamp(1.0 + (x * 0.002), 1.0, 1.12)
	else
		return clamp(1.0 - (x * 0.001), 0.90, 1.02)
	end
end

--------------------------------------------------------------------------------
-- BASE SHARES (uses distinct product counts as size proxy)
--------------------------------------------------------------------------------
local function buildBaseShares(roster, productCounts)
	local sectorTarget = { Agricultural = 0.34, ["Mining/Manufacturing"] = 0.33, Services = 0.33 }

	local bySector = { Agricultural = {}, ["Mining/Manufacturing"] = {}, Services = {} }
	for _, c in ipairs(roster) do
		table.insert(bySector[c.sector], c)
	end

	local shares = {}
	for sec, list in pairs(bySector) do
		local rawSum = 0
		for _, c in ipairs(list) do
			local nprod = productCounts[c.name] or 1
			-- weight: sqrt(distinct products) * stable factor
			local w = math.sqrt(math.max(1, nprod)) * (0.7 + hashFrac("w:" .. c.name) * 1.2)
			shares[c.name] = { share = 0, nprod = nprod, raw = w, sector = sec }
			rawSum = rawSum + w
		end
		local target = sectorTarget[sec] or 0
		for _, c in ipairs(list) do
			local rec = shares[c.name]
			rec.share = (rawSum > 0) and (rec.raw / rawSum) * target or 0
		end
	end
	return shares
end

--------------------------------------------------------------------------------
-- MAIN
--------------------------------------------------------------------------------
function p.generateTable(frame)
	local args = (frame and frame.args) or {}
	local di = getCurrentDateInfo()

	local city = tostring(args.city or "Vaeringheim")
	local sectorFilter = trim(tostring(args.sector or "")) -- Agricultural | Mining/Manufacturing | Services
	local limit = tonumber(args.limit or "")
	local showDashboard = tostring(args.dashboard or "yes"):lower() ~= "no"

	math.randomseed(di.year * 1000 + di.dayOfYear)

	-- roster + distinct product counts from the 3 modules
	local rosterPack = buildCompanyRosterAndCounts()
	local roster = rosterPack.roster
	local productCounts = rosterPack.productCounts

	if #roster == 0 then
		return "''BassaridEmployment error: could not read company rosters from the three price modules.''"
	end

	local shares = buildBaseShares(roster, productCounts)

	-- factor inputs
	local costAg   = getCostIndex("Module:AutoUpdateAgPrices")
	local costManf = getCostIndex("Module:AutoUpdateManfPrices")
	local costServ = getCostIndex("Module:AutoUpdateServPrices")

	local market = getMarketSentiment()
	local wx = getWeatherSignal(city, di.year, di.dayOfYear)
	local war = getWarTempo(di)
	local temple = getTempleTempo()
	local hatch = getHatchTempo(di)

	-- macro base
	local population = 94160000
	local baseU = 0.04
	local u = baseU
	u = u - clamp((market.bias or 0) * 0.01, -0.01, 0.01)
	u = u + clamp((wx.level or 0) * 0.005, 0, 0.02)
	u = clamp(u, 0.02, 0.08)
	local employedPopulation = math.floor(population * (1 - u))

	local function combinedMultiplier(sec)
		local mCost = sectorCostMultiplier(sec, costAg, costManf, costServ)
		local mWx = weatherMultiplier(wx, sec)
		local mWar = warMultiplier(war, sec)
		local mTemple = templeMultiplier(temple, sec)
		local mHatch = hatchMultiplier(hatch, sec)
		local mMkt = marketMultiplier(market, sec)
		return clamp(mCost * mWx * mWar * mTemple * mHatch * mMkt, 0.65, 1.25),
		       mCost, mWx, mWar, mTemple, mHatch, mMkt
	end

	local out = {}

	if showDashboard then
		table.insert(out, "{| class=\"wikitable\" style=\"width:100%;\"")
		table.insert(out, "! colspan=\"4\" | Employment factor audit — " .. di.dateString)
		table.insert(out, "|-")
		table.insert(out, string.format("| '''Rosters present''' || Ag=%s; Manf=%s; Serv=%s || '''Weather''' || %s (%s)",
			tostring(rosterPack.modulePresence.ag),
			tostring(rosterPack.modulePresence.mf),
			tostring(rosterPack.modulePresence.sv),
			(wx.label or "Green"), (wx.condition or "")))
		table.insert(out, "|-")
		table.insert(out, string.format("| '''Costs present''' || Ag=%s (%.3f); Manf=%s (%.3f); Serv=%s (%.3f) || '''Market present''' || %s (bias %.2f)",
			tostring(costAg.present), (costAg.ratio or 1.0),
			tostring(costManf.present), (costManf.ratio or 1.0),
			tostring(costServ.present), (costServ.ratio or 1.0),
			tostring(market.present), (market.bias or 0)))
		table.insert(out, "|-")
		table.insert(out, string.format("| '''War present''' || %s (red-rate %.2f) || '''Temple present''' || %s (red-rate %.2f)",
			tostring(war.present), (war.redRate or 0),
			tostring(temple.present), (temple.redRate or 0)))
		table.insert(out, "|-")
		table.insert(out, string.format("| '''Hatch present''' || %s (intensity %d) || '''Modeled unemployment''' || %.2f%%",
			tostring(hatch.present), (hatch.intensity or 0), u * 100))
		table.insert(out, "|}")
		table.insert(out, "")
	end

	table.insert(out, '<div style="overflow-x:auto;">')
	table.insert(out, "{| class=\"wikitable sortable\"")
	table.insert(out, "! Date !! Sector !! Company !! Products (distinct) !! Base Share % !! Prev Emp. !! Curr Emp. !! Δ !! mCost !! mWx !! mWar !! mTemple !! mHatch !! mMkt")

	local n = 0
	for _, c in ipairs(roster) do
		local sec = c.sector
		if sectorFilter == "" or sec == sectorFilter then
			local rec = shares[c.name]
			local share = (rec and rec.share) or 0
			local nprod = (rec and rec.nprod) or (productCounts[c.name] or 0)

			local prev = math.max(1, math.floor(employedPopulation * share))

			local mAll, mCost, mWx, mWar, mTemple, mHatch, mMkt = combinedMultiplier(sec)

			-- stable company/day jitter ±9%
			local jitter = (hashFrac(string.format("jit:%s:%d:%d", c.name, di.year, di.dayOfYear)) - 0.5) * 0.18
			local curr = math.max(1, math.floor(prev * mAll * (1.0 + jitter)))

			local deltaSym = "•"
			if curr > prev then deltaSym = "↑"
			elseif curr < prev then deltaSym = "↓" end

			local rowStyle
			if curr > prev then rowStyle = ' style="background-color:lightblue;"'
			elseif curr == prev then rowStyle = ' style="background-color:lightgreen;"'
			else rowStyle = ' style="background-color:#ffcccb;"' end

			table.insert(out, string.format(
				"|-%s\n| %s || %s || %s || %d || %.3f%% || %d || %d || %s || %.2f || %.2f || %.2f || %.2f || %.2f || %.2f",
				rowStyle,
				di.dateString,
				sec,
				c.name,
				nprod,
				share * 100,
				prev,
				curr,
				deltaSym,
				mCost, mWx, mWar, mTemple, mHatch, mMkt
			))

			n = n + 1
			if limit and n >= limit then break end
		end
	end

	table.insert(out, "|}")
	table.insert(out, "</div>")

	return table.concat(out, "\n")
end

return p