Versions in this module Expand all Collapse all v0 v0.1.1 Oct 11, 2026 v0.1.0 Oct 11, 2026 Changes in this version + const DefaultPageSize + const MaxPageSize + var AdCost = sqlb.Col[float64](AdSpend, "cost") + var AdDay = sqlb.Col[time.Time](AdSpend, "day") + var AdProductID = sqlb.Col[string](AdSpend, "product_id") + var AdSpend = sqlb.Table + var AdVendorID = sqlb.Col[string](AdSpend, "vendor_id") + var CalDay = sqlb.Col[time.Time](Calendar, "day") + var CalFiscalYear = sqlb.Col[int32](Calendar, "fiscal_year") + var CalPeriodIndex = sqlb.Col[int32](Calendar, "period_index") + var CalPeriodLabel = sqlb.Col[string](Calendar, "period_label") + var Calendar = sqlb.Table + var Categories = sqlb.Table + var CategoryID = sqlb.Col[string](Categories, "id") + var CategoryName = sqlb.Col[string](Categories, "name") + var ClassName = sqlb.Col[string](Categories, "class_name") + var Department = sqlb.Col[string](Categories, "department") + var DimensionValues = []Dimension + var ErrFiscalYear = errors.New("periodcompare: fiscal-month dimension needs FiscalYear") + var ErrUnknownDimension = errors.New("periodcompare: unknown dimension") + var ErrUnknownMetric = errors.New("periodcompare: unknown metric in filter or sort") + var ErrUnknownOperator = errors.New("periodcompare: unknown numeric operator") + var Keywords = sqlb.Table + var KwKeywordID = sqlb.Col[int64](Keywords, "keyword_id") + var KwProductID = sqlb.Col[string](Keywords, "product_id") + var POCancelled = sqlb.Col[bool](POLines, "cancelled") + var POLines = sqlb.Table + var POProductID = sqlb.Col[string](POLines, "product_id") + var POQtyDue = sqlb.Col[int64](POLines, "qty_due") + var POUnitPrice = sqlb.Col[float64](POLines, "unit_price") + var POVendorID = sqlb.Col[string](POLines, "vendor_id") + var ProductCatID = sqlb.Col[string](Products, "category_id") + var ProductCode = sqlb.Col[string](Products, "code") + var ProductID = sqlb.Col[string](Products, "id") + var ProductImage = sqlb.Col[*string](Products, "image_url") + var ProductName = sqlb.Col[string](Products, "name") + var ProductVendorID = sqlb.Col[string](Products, "vendor_id") + var Products = sqlb.Table + var SaleIsGift = sqlb.Col[bool](SalesLines, "is_gift") + var SaleListPrice = sqlb.Col[float64](SalesLines, "list_price") + var SaleProductID = sqlb.Col[string](SalesLines, "product_id") + var SaleQty = sqlb.Col[int64](SalesLines, "qty") + var SaleSoldOn = sqlb.Col[time.Time](SalesLines, "sold_on") + var SaleStoreID = sqlb.Col[int32](SalesLines, "store_id") + var SaleUnitCost = sqlb.Col[float64](SalesLines, "unit_cost") + var SaleUnitPrice = sqlb.Col[float64](SalesLines, "unit_price") + var SaleVendorID = sqlb.Col[string](SalesLines, "vendor_id") + var SalesLines = sqlb.Table + var SnapDate = sqlb.Col[time.Time](StockSnapshots, "snapshot_date") + var SnapProductID = sqlb.Col[string](StockSnapshots, "product_id") + var SnapQty = sqlb.Col[int64](StockSnapshots, "qty") + var SnapRetail = sqlb.Col[float64](StockSnapshots, "retail_price") + var SnapStoreID = sqlb.Col[int32](StockSnapshots, "store_id") + var SnapVendorID = sqlb.Col[string](StockSnapshots, "vendor_id") + var StockLevels = sqlb.Table + var StockOnHand = sqlb.Col[int64](StockLevels, "on_hand") + var StockProductID = sqlb.Col[string](StockLevels, "product_id") + var StockRetail = sqlb.Col[float64](StockLevels, "retail_price") + var StockSnapshots = sqlb.Table + var StockStoreID = sqlb.Col[int32](StockLevels, "store_id") + var StockVendorID = sqlb.Col[string](StockLevels, "vendor_id") + var StoreID = sqlb.Col[int32](Stores, "id") + var StoreName = sqlb.Col[string](Stores, "name") + var Stores = sqlb.Table + var VendorID = sqlb.Col[string](Vendors, "id") + var VendorName = sqlb.Col[string](Vendors, "name") + var Vendors = sqlb.Table + type DateRange struct + From time.Time + To time.Time + type Dimension string + const ByClass + const ByDepartment + const ByFiscalMonth + const ByProduct + const ByStore + const ByVendor + type Filters struct + AllowedVendors []string + Classes []string + Departments []string + ExcludeMarkdowns bool + ExcludeReturns bool + IncludeMarkdowns bool + KeyIn []string + KeywordIDs []int64 + Numeric []NumericFilter + StoreIDs []int32 + VendorIDs []string + type Include struct + AdSpend bool + OnOrder bool + Snapshot bool + ThirdYear bool + type Metric string + const MetricAdCost + const MetricCurrentCost + const MetricCurrentMargin + const MetricCurrentSales + const MetricCurrentUnits + const MetricKey + const MetricMarginPct + const MetricOnHand + const MetricOnHandRetail + const MetricOnOrder + const MetricOnOrderRetail + const MetricPrevOnHand + const MetricPreviousSales + const MetricPreviousUnits + const MetricROAS + const MetricReturnedUnits + const MetricReturnsPct + const MetricSalesChange + const MetricSalesPct + const MetricSellThrough + const MetricThirdSales + const MetricThirdUnits + const MetricUnitsChange + const MetricUnitsPct + type NumericFilter struct + Metric Metric + Op NumericOp + Value float64 + type NumericOp string + const OpEqual + const OpGreater + const OpGreaterEq + const OpLess + const OpLessEq + type Page struct + Number int + Size int + type Params struct + Current DateRange + Dimension Dimension + Filters Filters + FiscalYear int32 + Include Include + Page Page + Previous DateRange + Sort Sort + Third DateRange + type Result struct + DisabledSources []string + Query sqlb.Query + Row *Row + SkippedFilters []string + func Build(p Params) (Result, error) + type Row struct + AdCost float64 + CurrentCost float64 + CurrentMargin float64 + CurrentSales float64 + CurrentUnits int64 + ImageURL *string + Key string + Label string + MarginPct *float64 + OnHand int64 + OnHandRetail float64 + OnOrder int64 + OnOrderRetail float64 + PrevOnHand int64 + PreviousSales float64 + PreviousUnits int64 + ROAS *float64 + ReturnedUnits int64 + ReturnsPct *float64 + SalesChange float64 + SalesPct *float64 + SellThrough *float64 + ThirdSales float64 + ThirdUnits int64 + Total int64 + UnitsChange float64 + UnitsPct *float64 + type Sort struct + By Metric + Dir SortDir + type SortDir string + const Asc + const Desc