db

type AcknowledgeSecurityAlertsParams struct {
	AcknowledgedBy string   `json:"acknowledged_by"`
	Ids            []int64  `json:"ids"`
	KeptKinds      []string `json:"kept_kinds"`
}

type AddBatchItemParams struct {
	BatchID        int64 `json:"batch_id"`
	VariantID      int64 `json:"variant_id"`
	QuantityBought int64 `json:"quantity_bought"`
	UnitCost       int64 `json:"unit_cost"`
}

type AddCashboxAccountBalanceParams struct {
	AccountID int64 `json:"account_id"`
	ShiftID   int64 `json:"shift_id"`
	Balance   int64 `json:"balance"`
}

type AddClientLoyaltyPointsParams struct {
	ID                 int64 `json:"id"`
	TotalLoyaltyPoints int64 `json:"total_loyalty_points"`
	ValidLoyaltyPoints int64 `json:"valid_loyalty_points"`
}

type AddInventoryStockQuantityParams struct {
	InventoryID int64 `json:"inventory_id"`
	VariantID   int64 `json:"variant_id"`
	Quantity    int64 `json:"quantity"`
}

type AddInvoiceDiscountBranchParams struct {
	InvoiceDiscountID int64 `json:"invoice_discount_id"`
	BranchID          int64 `json:"branch_id"`
}

type AddInvoiceProductParams struct {
	InvoiceID int64         `json:"invoice_id"`
	ProductID int64         `json:"product_id"`
	VariantID sql.NullInt64 `json:"variant_id"`
	UnitPrice int64         `json:"unit_price"`
	LineTotal int64         `json:"line_total"`
	Discount  int16         `json:"discount"`
	Quantity  int64         `json:"quantity"`
	UnitCost  int64         `json:"unit_cost"`
}

type AddProductSaleOptionsForEntriesParams struct {
	SaleOptionIds []int64  `json:"sale_option_ids"`
	Entries       []string `json:"entries"`
}

type AddPurchaseItemParams struct {
	PurchaseID   sql.NullInt64 `json:"purchase_id"`
	VariantID    sql.NullInt64 `json:"variant_id"`
	AssetID      sql.NullInt64 `json:"asset_id"`
	Quantity     int64         `json:"quantity"`
	UnitPrice    int64         `json:"unit_price"`
	CurrencyCode string        `json:"currency_code"`
}

type AddPurchasedProductCostParams struct {
	ProductSupplierID int64  `json:"product_supplier_id"`
	UnitCost          int64  `json:"unit_cost"`
	CurrencyCode      string `json:"currency_code"`
}

type AddPurchasedProductParams struct {
	ProductID  int64 `json:"product_id"`
	SupplierID int64 `json:"supplier_id"`
}

type AddStockCountItemParams struct {
	StockCountID    int64 `json:"stock_count_id"`
	VariantID       int64 `json:"variant_id"`
	SystemQuantity  int64 `json:"system_quantity"`
	CountedQuantity int64 `json:"counted_quantity"`
	Difference      int64 `json:"difference"`
}

type AddVariantTxParams struct {
	ProductID int64  `json:"product_id"`
	ColorID   *int64 `json:"color_id"`
	SizeID    *int64 `json:"size_id"`
	// Barcode is optional -- a unique EAN-13 is generated when it's nil.
	Barcode *int64 `json:"barcode"`
}

type AddWhatsAppChatMessageParams struct {
	Instance    string    `json:"instance"`
	WaID        string    `json:"wa_id"`
	ChatJid     string    `json:"chat_jid"`
	ChatPhone   string    `json:"chat_phone"`
	ContactName string    `json:"contact_name"`
	FromMe      bool      `json:"from_me"`
	Kind        string    `json:"kind"`
	Body        string    `json:"body"`
	MediaType   string    `json:"media_type"`
	SentAt      time.Time `json:"sent_at"`
}

type AddWhatsAppPollReplyParams struct {
	WaID       string    `json:"wa_id"`
	Body       string    `json:"body"`
	Kind       string    `json:"kind"`
	ReceivedAt time.Time `json:"received_at"`
	MediaType  string    `json:"media_type"`
	PollRef    string    `json:"poll_ref"`
}

type AdjustBatchItemRemainingQuantityParams struct {
	Delta int64 `json:"delta"`
	ID    int64 `json:"id"`
}

type AdminActivity struct {
	ID          int64         `json:"id"`
	UserID      sql.NullInt64 `json:"user_id"`
	Method      string        `json:"method"`
	Route       string        `json:"route"`
	EntityID    sql.NullInt64 `json:"entity_id"`
	Summary     string        `json:"summary"`
	Detail      string        `json:"detail"`
	CreatedAt   time.Time     `json:"created_at"`
	RepeatCount int32         `json:"repeat_count"`
	ReleaseType string        `json:"release_type"`
}

type AdoptSalespersonAttendanceIDParams struct {
	ID               int64         `json:"id"`
	BranchID         sql.NullInt64 `json:"branch_id"`
	AttendanceUserID string        `json:"attendance_user_id"`
}

type AppRelease struct {
	ID         int64         `json:"id"`
	Version    string        `json:"version"`
	Flavor     string        `json:"flavor"`
	FileName   string        `json:"file_name"`
	FilePath   string        `json:"file_path"`
	SizeBytes  int64         `json:"size_bytes"`
	Sha256     string        `json:"sha256"`
	Signature  string        `json:"signature"`
	Notes      string        `json:"notes"`
	UploadedBy sql.NullInt64 `json:"uploaded_by"`
	CreatedAt  time.Time     `json:"created_at"`
}

type AppSetting struct {
	ID                         int16           `json:"id"`
	FinancialsHighSeasonMonths json.RawMessage `json:"financials_high_season_months"`
	UpdatedAt                  time.Time       `json:"updated_at"`
	ActivityMessageSeconds     int16           `json:"activity_message_seconds"`
	ActivityDisplayMode        string          `json:"activity_display_mode"`
	BarcodeLabelWidth          float32         `json:"barcode_label_width"`
	BarcodeLabelHeight         float32         `json:"barcode_label_height"`
	UpcomingEventsDays         int16           `json:"upcoming_events_days"`
	UpcomingEventsMenuDays     int16           `json:"upcoming_events_menu_days"`
	HiddenBuiltinEvents        json.RawMessage `json:"hidden_builtin_events"`
	DefaultLowStockThreshold   int64           `json:"default_low_stock_threshold"`
	WhatsappEnabled            bool            `json:"whatsapp_enabled"`
	WhatsappPhoneNumberID      string          `json:"whatsapp_phone_number_id"`
	WhatsappAccessToken        string          `json:"whatsapp_access_token"`
	WhatsappTemplateName       string          `json:"whatsapp_template_name"`
	WhatsappTemplateLang       string          `json:"whatsapp_template_lang"`
	WhatsappTemplateParams     string          `json:"whatsapp_template_params"`
	ProductAutofillEnabled     bool            `json:"product_autofill_enabled"`
	ProductAutofillRules       json.RawMessage `json:"product_autofill_rules"`
	ProductAutofillCodeLayout  string          `json:"product_autofill_code_layout"`
	WhatsappMessageCostMicros  int64           `json:"whatsapp_message_cost_micros"`
	WhatsappWebhookVerifyToken string          `json:"whatsapp_webhook_verify_token"`
	WhatsappAppSecret          string          `json:"whatsapp_app_secret"`
	EmailResendApiKey          string          `json:"email_resend_api_key"`
	EmailSenderName            string          `json:"email_sender_name"`
	EmailSenderAddress         string          `json:"email_sender_address"`
	EmailReplyTo               string          `json:"email_reply_to"`
	EmailDefaultRecipients     string          `json:"email_default_recipients"`
	EmailBusinessName          string          `json:"email_business_name"`
	EmailCsvColumns            json.RawMessage `json:"email_csv_columns"`
	EmailAttachmentFormat      string          `json:"email_attachment_format"`
	EmailGroupByRegister       bool            `json:"email_group_by_register"`
	EmailOldestFirst           bool            `json:"email_oldest_first"`
	ReviewPlaceID              string          `json:"review_place_id"`
	ReviewBaseUrl              string          `json:"review_base_url"`
	ReviewTitle                string          `json:"review_title"`
	ReviewDescription          string          `json:"review_description"`
	GooglePlacesApiKey         string          `json:"google_places_api_key"`
	WhatsappSender             string          `json:"whatsapp_sender"`
	WhatsappBridgeUrl          string          `json:"whatsapp_bridge_url"`
	WhatsappBridgeKey          string          `json:"whatsapp_bridge_key"`
	WhatsappBridgeMessage      string          `json:"whatsapp_bridge_message"`
	WhatsappPollQuestion       string          `json:"whatsapp_poll_question"`
	WhatsappPollOptions        string          `json:"whatsapp_poll_options"`
	WhatsappFeedbackMode       string          `json:"whatsapp_feedback_mode"`
	WhatsappBridgeLinkMessage  string          `json:"whatsapp_bridge_link_message"`
	WhatsappChannelUrl         string          `json:"whatsapp_channel_url"`
	WhatsappMessageLogo        bool            `json:"whatsapp_message_logo"`
	WhatsappFollowup           bool            `json:"whatsapp_followup"`
	WhatsappFollowupGood       string          `json:"whatsapp_followup_good"`
	WhatsappFollowupOkay       string          `json:"whatsapp_followup_okay"`
	WhatsappFollowupBad        string          `json:"whatsapp_followup_bad"`
	GoogleReviewsEnabled       bool            `json:"google_reviews_enabled"`
	WhatsappHiddenFields       string          `json:"whatsapp_hidden_fields"`
	WhatsappChannelFirst       bool            `json:"whatsapp_channel_first"`
	WhatsappDeleteForMe        bool            `json:"whatsapp_delete_for_me"`
	WhatsappDeletePollForMe    bool            `json:"whatsapp_delete_poll_for_me"`
	UploadPagesFollowSystem    bool            `json:"upload_pages_follow_system"`
	UnknownImagesAutoDelete    bool            `json:"unknown_images_auto_delete"`
	TablePageSize              int16           `json:"table_page_size"`
	WhatsappWelcomeEarly       bool            `json:"whatsapp_welcome_early"`
	BarcodeLabelDesign         json.RawMessage `json:"barcode_label_design"`
	WhatsappMessageNew         bool            `json:"whatsapp_message_new"`
	WhatsappMessageReturning   bool            `json:"whatsapp_message_returning"`
	WhatsappPollNew            bool            `json:"whatsapp_poll_new"`
	WhatsappPollReturning      bool            `json:"whatsapp_poll_returning"`
	WhatsappFollowupReturning  bool            `json:"whatsapp_followup_returning"`
}

type AppUpdateEvent struct {
	ID         int64         `json:"id"`
	RegisterID int64         `json:"register_id"`
	ReleaseID  sql.NullInt64 `json:"release_id"`
	AppVersion string        `json:"app_version"`
	State      string        `json:"state"`
	Detail     string        `json:"detail"`
	CreatedAt  time.Time     `json:"created_at"`
}

type ApplyBranchSettlementTxParams struct {
	BranchID      int64
	ClientRef     string
	SaleClientRef string
	GrandTotal    int64
	OccurredAt    time.Time
	Payments      []BranchInvoicePaymentParams
}

type ApplyBranchSettlementTxResult struct {
	Settlement     BranchInvoiceSettlement
	Payments       []BranchInvoiceSettlementPayment
	InvoiceUpdated bool
	// Status is the resolved lifecycle of this settlement (one of the
	// SettlementStatus* constants). Frozen is the shorthand the caller
	// reacts to: the sale's shift was already closed, so nothing was
	// replayed and the change is deliberately not surfaced.
	Status string
	Frozen bool
}

type ApplyWhatsAppBridgeTickParams struct {
	DeliveryStatus string    `json:"delivery_status"`
	At             time.Time `json:"at"`
	BridgeRef      string    `json:"bridge_ref"`
}

type ApplyWhatsAppBridgeTickRow struct {
	ID       int64         `json:"id"`
	BranchID sql.NullInt64 `json:"branch_id"`
}

type ApplyWhatsAppDeliveryStatusParams struct {
	DeliveryStatus  string       `json:"delivery_status"`
	At              time.Time    `json:"at"`
	DeliveryError   string       `json:"delivery_error"`
	Billable        sql.NullBool `json:"billable"`
	PricingCategory string       `json:"pricing_category"`
	Wamid           string       `json:"wamid"`
}

type Asset struct {
	ID         int64     `json:"id"`
	Name       string    `json:"name"`
	Code       string    `json:"code"`
	CategoryID int64     `json:"category_id"`
	Version    int32     `json:"version"`
	BoughtAt   time.Time `json:"bought_at"`
	CreatedAt  time.Time `json:"created_at"`
	Cost       int64     `json:"cost"`
}

type AssetCategory struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	IsActive  bool      `json:"is_active"`
	Icon      string    `json:"icon"`
	Color     string    `json:"color"`
	CreatedAt time.Time `json:"created_at"`
}

type AttachWhatsAppPollParams struct {
	PollRef      string `json:"poll_ref"`
	PollQuestion string `json:"poll_question"`
	PollOptions  string `json:"poll_options"`
	ID           int64  `json:"id"`
}

type Attribute struct {
	ID   int64  `json:"id"`
	Name string `json:"name"`
}

type AttributesValue struct {
	ID          int64     `json:"id"`
	AttributeID int64     `json:"attribute_id"`
	Value       string    `json:"value"`
	CreatedAt   time.Time `json:"created_at"`
}

type AuditAction string

type AuditLog struct {
	ID         int64                 `json:"id"`
	EntityType string                `json:"entity_type"`
	EntityID   int64                 `json:"entity_id"`
	Action     AuditAction           `json:"action"`
	Before     pqtype.NullRawMessage `json:"before"`
	After      pqtype.NullRawMessage `json:"after"`
	ActorID    sql.NullInt64         `json:"actor_id"`
	Source     string                `json:"source"`
	CreatedAt  time.Time             `json:"created_at"`
}

type Batch struct {
	ID          int64         `json:"id"`
	Code        string        `json:"code"`
	PurchaseID  sql.NullInt64 `json:"purchase_id"`
	InventoryID sql.NullInt64 `json:"inventory_id"`
	Note        string        `json:"note"`
	CreatedAt   time.Time     `json:"created_at"`
}

type BatchItem struct {
	ID                int64 `json:"id"`
	BatchID           int64 `json:"batch_id"`
	VariantID         int64 `json:"variant_id"`
	QuantityBought    int64 `json:"quantity_bought"`
	UnitCost          int64 `json:"unit_cost"`
	RemainingQuantity int64 `json:"remaining_quantity"`
}

type BatchSetClientPhoneFlagsParams struct {
	Ids            []int64  `json:"ids"`
	PhoneValids    []bool   `json:"phone_valids"`
	PhoneCountries []string `json:"phone_countries"`
}

type BatchUpdateClientPhonesParams struct {
	Ids            []int64  `json:"ids"`
	Phones         []string `json:"phones"`
	PhoneValids    []bool   `json:"phone_valids"`
	PhoneCountries []string `json:"phone_countries"`
}

type Branch struct {
	ID                       int64          `json:"id"`
	Name                     string         `json:"name"`
	Code                     string         `json:"code"`
	IsActive                 bool           `json:"is_active"`
	LastSeenAt               sql.NullTime   `json:"last_seen_at"`
	CreatedAt                time.Time      `json:"created_at"`
	InventoryID              sql.NullInt64  `json:"inventory_id"`
	Timezone                 string         `json:"timezone"`
	QuickAccessInitializedAt sql.NullTime   `json:"quick_access_initialized_at"`
	HiddenFromReports        bool           `json:"hidden_from_reports"`
	GooglePlaceID            string         `json:"google_place_id"`
	WhatsappNumberID         sql.NullInt64  `json:"whatsapp_number_id"`
	WhatsappEnabled          bool           `json:"whatsapp_enabled"`
	WhatsappHiddenFields     sql.NullString `json:"whatsapp_hidden_fields"`
}

type BranchAttendanceChange struct {
	ID              int64     `json:"id"`
	BranchID        int64     `json:"branch_id"`
	ClientRef       string    `json:"client_ref"`
	Kind            string    `json:"kind"`
	SalespersonName string    `json:"salesperson_name"`
	AttendanceDate  string    `json:"attendance_date"`
	OriginalTime    string    `json:"original_time"`
	RequestedTime   string    `json:"requested_time"`
	RequestedType   string    `json:"requested_type"`
	Action          string    `json:"action"`
	Status          string    `json:"status"`
	Note            string    `json:"note"`
	Actor           string    `json:"actor"`
	OccurredAt      time.Time `json:"occurred_at"`
	ReceivedAt      time.Time `json:"received_at"`
	RegisterID      int64     `json:"register_id"`
}

type BranchAttendanceChangeRefsPresentParams struct {
	RegisterID int64    `json:"register_id"`
	Column2    []string `json:"column_2"`
}

type BranchAttendanceEvent struct {
	ID               int64        `json:"id"`
	BranchID         int64        `json:"branch_id"`
	ClientRef        string       `json:"client_ref"`
	SalespersonName  string       `json:"salesperson_name"`
	AttendanceUserID string       `json:"attendance_user_id"`
	EventDate        string       `json:"event_date"`
	EventTime        string       `json:"event_time"`
	EventAt          string       `json:"event_at"`
	Type             string       `json:"type"`
	Status           string       `json:"status"`
	ReceivedAt       time.Time    `json:"received_at"`
	ChangedBy        string       `json:"changed_by"`
	ChangeNote       string       `json:"change_note"`
	RemovedAt        sql.NullTime `json:"removed_at"`
	RemovedBy        string       `json:"removed_by"`
}

type BranchAttendanceEventRefsPresentParams struct {
	BranchID int64    `json:"branch_id"`
	Column2  []string `json:"column_2"`
}

type BranchCashboxAccount struct {
	BranchID         int64          `json:"branch_id"`
	CashboxAccountID int64          `json:"cashbox_account_id"`
	IsEnabled        bool           `json:"is_enabled"`
	SortOrder        sql.NullInt32  `json:"sort_order"`
	Color            sql.NullString `json:"color"`
	CurrencyCode     sql.NullString `json:"currency_code"`
	UpdatedAt        time.Time      `json:"updated_at"`
}

type BranchClientLinksPresentParams struct {
	RegisterID int64   `json:"register_id"`
	Column2    []int64 `json:"column_2"`
}

type BranchCommand struct {
	ID          int64                 `json:"id"`
	BranchID    int64                 `json:"branch_id"`
	Type        string                `json:"type"`
	Payload     json.RawMessage       `json:"payload"`
	Status      string                `json:"status"`
	Result      pqtype.NullRawMessage `json:"result"`
	Error       sql.NullString        `json:"error"`
	IssuedBy    int64                 `json:"issued_by"`
	CreatedAt   time.Time             `json:"created_at"`
	CompletedAt sql.NullTime          `json:"completed_at"`
	RegisterID  int64                 `json:"register_id"`
}

type BranchCommandSummaryRow struct {
	BranchID        int64       `json:"branch_id"`
	Pending         int64       `json:"pending"`
	FailedRecent    int64       `json:"failed_recent"`
	OldestPendingAt interface{} `json:"oldest_pending_at"`
	LastIssuedAt    interface{} `json:"last_issued_at"`
}

type BranchExpense struct {
	ID                       int64          `json:"id"`
	BranchID                 int64          `json:"branch_id"`
	ClientRef                string         `json:"client_ref"`
	Description              string         `json:"description"`
	Amount                   int64          `json:"amount"`
	CurrencyCode             string         `json:"currency_code"`
	BranchCashboxAccountID   int64          `json:"branch_cashbox_account_id"`
	BranchShiftID            sql.NullInt64  `json:"branch_shift_id"`
	OccurredAt               time.Time      `json:"occurred_at"`
	ReceivedAt               time.Time      `json:"received_at"`
	CategoryID               sql.NullInt64  `json:"category_id"`
	BranchCashboxAccountName sql.NullString `json:"branch_cashbox_account_name"`
	CancelledAt              sql.NullTime   `json:"cancelled_at"`
	FromCentral              bool           `json:"from_central"`
}

type BranchExpenseImage struct {
	ID              int64     `json:"id"`
	BranchExpenseID int64     `json:"branch_expense_id"`
	FilePath        string    `json:"file_path"`
	ContentType     string    `json:"content_type"`
	SizeBytes       int64     `json:"size_bytes"`
	CreatedAt       time.Time `json:"created_at"`
	Rotation        int16     `json:"rotation"`
}

type BranchExpenseRefsPresentParams struct {
	BranchID int64    `json:"branch_id"`
	Column2  []string `json:"column_2"`
}

type BranchExpenseUploadToken struct {
	ID              int64        `json:"id"`
	BranchExpenseID int64        `json:"branch_expense_id"`
	Token           string       `json:"token"`
	ExpiresAt       time.Time    `json:"expires_at"`
	UsedAt          sql.NullTime `json:"used_at"`
	CreatedAt       time.Time    `json:"created_at"`
}

type BranchInvoice struct {
	ID                     int64          `json:"id"`
	BranchID               int64          `json:"branch_id"`
	ClientRef              string         `json:"client_ref"`
	Kind                   string         `json:"kind"`
	BranchInvoiceCode      string         `json:"branch_invoice_code"`
	BranchCashboxAccountID int64          `json:"branch_cashbox_account_id"`
	BranchShiftID          int64          `json:"branch_shift_id"`
	BranchInventoryID      int64          `json:"branch_inventory_id"`
	BranchClientID         sql.NullInt64  `json:"branch_client_id"`
	RelatedClientRef       sql.NullString `json:"related_client_ref"`
	Discount               int16          `json:"discount"`
	Subtotal               int64          `json:"subtotal"`
	DiscountedTotal        int64          `json:"discounted_total"`
	GrandTotal             int64          `json:"grand_total"`
	LoyaltyPointsDelta     int64          `json:"loyalty_points_delta"`
	OccurredAt             time.Time      `json:"occurred_at"`
	ReceivedAt             time.Time      `json:"received_at"`
	SalespersonName        string         `json:"salesperson_name"`
	Historical             bool           `json:"historical"`
	ClientUid              uuid.NullUUID  `json:"client_uid"`
	RegisterID             int64          `json:"register_id"`
	CancelledAt            sql.NullTime   `json:"cancelled_at"`
	SalespersonID          sql.NullInt64  `json:"salesperson_id"`
	LbpTotal               sql.NullInt64  `json:"lbp_total"`
	LbpRate                sql.NullInt64  `json:"lbp_rate"`
	InvoiceDiscount        int64          `json:"invoice_discount"`
	InvoiceDiscountName    string         `json:"invoice_discount_name"`
}

type BranchInvoiceItem struct {
	ID              int64         `json:"id"`
	BranchInvoiceID int64         `json:"branch_invoice_id"`
	BranchProductID int64         `json:"branch_product_id"`
	UnitPrice       int64         `json:"unit_price"`
	LineTotal       int64         `json:"line_total"`
	Discount        int16         `json:"discount"`
	Quantity        int64         `json:"quantity"`
	ProductUid      uuid.NullUUID `json:"product_uid"`
	Unknown         bool          `json:"unknown"`
	Deal            string        `json:"deal"`
	DealDiscount    int64         `json:"deal_discount"`
	InvoiceDiscount int64         `json:"invoice_discount"`
}

type BranchInvoiceItemParams struct {
	BranchProductID int64 `json:"branch_product_id"`
	// Barcode is the SKU's globally-unique barcode -- the only identifier
	// that resolves a branch line to a central product_variants row (see
	// applySyncedProductVariant in kashi-pos). Empty from older kashi-pos
	// builds; such lines are recorded but skip the central stock decrement.
	Barcode string `json:"barcode"`
	// ProductUID is the variant's shared identity (see 000093_sync_uid).
	// When set it wins over Barcode for resolving the central variant;
	// older tills leave it empty and fall back to the barcode.
	ProductUID uuid.NullUUID `json:"product_uid"`
	UnitPrice  int64         `json:"unit_price"`
	LineTotal  int64         `json:"line_total"`
	// A deal line (000202): the deal's name and what it took off the line.
	Deal         string `json:"deal"`
	DealDiscount int64  `json:"deal_discount"`
	// The line's share of the sale's invoice discount (000212), cents;
	// LineTotal already has it off.
	InvoiceDiscount int64 `json:"invoice_discount"`
	// Unknown: the till rang this up as an "Unknown item" (its placeholder
	// barcode, or the product the branch named for it). Such a line is stored
	// unresolved and moves no stock until it is matched to a real product.
	Unknown  bool  `json:"unknown"`
	Discount int16 `json:"discount"`
	Quantity int64 `json:"quantity"`
}

type BranchInvoicePayment struct {
	ID              int64  `json:"id"`
	BranchInvoiceID int64  `json:"branch_invoice_id"`
	AccountName     string `json:"account_name"`
	Amount          int64  `json:"amount"`
}

type BranchInvoicePaymentParams struct {
	AccountName string `json:"account_name"`
	Amount      int64  `json:"amount"`
	// CouponCode is set only when this payment line was a coupon redeemed
	// at checkout -- empty for every ordinary cash/card/account payment.
	// See RedeemCoupon.
	CouponCode string `json:"coupon_code"`
}

type BranchInvoiceRefsPresentParams struct {
	BranchID int64    `json:"branch_id"`
	Column2  []string `json:"column_2"`
}

type BranchInvoiceSettlement struct {
	ID            int64     `json:"id"`
	BranchID      int64     `json:"branch_id"`
	ClientRef     string    `json:"client_ref"`
	SaleClientRef string    `json:"sale_client_ref"`
	GrandTotal    int64     `json:"grand_total"`
	OccurredAt    time.Time `json:"occurred_at"`
	ReceivedAt    time.Time `json:"received_at"`
	Status        string    `json:"status"`
}

type BranchInvoiceSettlementPayment struct {
	ID                        int64  `json:"id"`
	BranchInvoiceSettlementID int64  `json:"branch_invoice_settlement_id"`
	AccountName               string `json:"account_name"`
	Amount                    int64  `json:"amount"`
}

type BranchLoanRefsPresentParams struct {
	BranchID sql.NullInt64 `json:"branch_id"`
	Column2  []string      `json:"column_2"`
}

type BranchQuickAccessItem struct {
	BranchID         int64  `json:"branch_id"`
	ProductVariantID int64  `json:"product_variant_id"`
	Position         int32  `json:"position"`
	Color            string `json:"color"`
	TextColor        string `json:"text_color"`
}

type BranchRegister struct {
	ID                       int64                 `json:"id"`
	BranchID                 int64                 `json:"branch_id"`
	Code                     string                `json:"code"`
	Name                     string                `json:"name"`
	ApiKeyHash               string                `json:"api_key_hash"`
	IsActive                 bool                  `json:"is_active"`
	LastSeenAt               sql.NullTime          `json:"last_seen_at"`
	ReportedSettings         pqtype.NullRawMessage `json:"reported_settings"`
	ReportedSettingsAt       sql.NullTime          `json:"reported_settings_at"`
	CreatedAt                time.Time             `json:"created_at"`
	QuickAccessMode          string                `json:"quick_access_mode"`
	QuickAccessModeChangedAt time.Time             `json:"quick_access_mode_changed_at"`
	TargetReleaseID          sql.NullInt64         `json:"target_release_id"`
	AppVersion               string                `json:"app_version"`
	AppFlavor                string                `json:"app_flavor"`
	UpdateState              string                `json:"update_state"`
	UpdateDetail             string                `json:"update_detail"`
	UpdateProgress           int32                 `json:"update_progress"`
	UpdateReportedAt         sql.NullTime          `json:"update_reported_at"`
	HiddenFromReports        bool                  `json:"hidden_from_reports"`
	TargetForce              bool                  `json:"target_force"`
}

type BranchSalespersonExistsParams struct {
	ID       int64         `json:"id"`
	BranchID sql.NullInt64 `json:"branch_id"`
}

type BranchSetting struct {
	BranchID                           int64           `json:"branch_id"`
	BranchName                         string          `json:"branch_name"`
	TaxRate                            float64         `json:"tax_rate"`
	RoundingMode                       string          `json:"rounding_mode"`
	RoundingCurrency                   string          `json:"rounding_currency"`
	ExchangeRate                       int64           `json:"exchange_rate"`
	ExchangeWindowHours                int64           `json:"exchange_window_hours"`
	MarketName                         string          `json:"market_name"`
	MarketPhone                        string          `json:"market_phone"`
	MarketDescription                  string          `json:"market_description"`
	ReturnPolicy                       string          `json:"return_policy"`
	Website                            string          `json:"website"`
	Instagram                          string          `json:"instagram"`
	SocialPlatforms                    json.RawMessage `json:"social_platforms"`
	SocialHandles                      json.RawMessage `json:"social_handles"`
	UpdatedAt                          time.Time       `json:"updated_at"`
	SearchButtonEnabled                bool            `json:"search_button_enabled"`
	CustomItemDiscountsEnabled         bool            `json:"custom_item_discounts_enabled"`
	CustomItemPricesEnabled            bool            `json:"custom_item_prices_enabled"`
	PerUnitItemPricesEnabled           bool            `json:"per_unit_item_prices_enabled"`
	PriceChangeManualOverrideMode      bool            `json:"price_change_manual_override_mode"`
	InvoiceKeyboardMode                bool            `json:"invoice_keyboard_mode"`
	ClientRequired                     bool            `json:"client_required"`
	PageUnlockClients                  bool            `json:"page_unlock_clients"`
	PageUnlockInventory                bool            `json:"page_unlock_inventory"`
	PageUnlockTransfers                bool            `json:"page_unlock_transfers"`
	PageUnlockAttendance               bool            `json:"page_unlock_attendance"`
	PageUnlockSalespersons             bool            `json:"page_unlock_salespersons"`
	PrinterSize                        string          `json:"printer_size"`
	ReceiptWidth                       int64           `json:"receipt_width"`
	ReceiptHeight                      int64           `json:"receipt_height"`
	ReceiptEnabled                     bool            `json:"receipt_enabled"`
	ReceiptFont                        string          `json:"receipt_font"`
	ReceiptBodyFont                    string          `json:"receipt_body_font"`
	ReceiptTitleSize                   float64         `json:"receipt_title_size"`
	ReceiptBodySize                    float64         `json:"receipt_body_size"`
	ReceiptCutoff                      bool            `json:"receipt_cutoff"`
	PrinterID                          string          `json:"printer_id"`
	ReceiptPrinter                     string          `json:"receipt_printer"`
	ScreenPort                         string          `json:"screen_port"`
	AkuvoxIp                           string          `json:"akuvox_ip"`
	AkuvoxUsername                     string          `json:"akuvox_username"`
	AttendanceEnabled                  bool            `json:"attendance_enabled"`
	AttendanceDuplicateIntervalSeconds int64           `json:"attendance_duplicate_interval_seconds"`
	AttendanceCashierHistory           bool            `json:"attendance_cashier_history"`
	ManagedLocally                     []string        `json:"managed_locally"`
	SplitPrimaryCurrency               string          `json:"split_primary_currency"`
	SplitPrimaryFirst                  bool            `json:"split_primary_first"`
	SplitPrimaryStep                   int64           `json:"split_primary_step"`
	OversellMode                       string          `json:"oversell_mode"`
	CloseShiftRequiresSync             bool            `json:"close_shift_requires_sync"`
	SalespersonPerInvoiceRequired      bool            `json:"salesperson_per_invoice_required"`
	NonAdminMonthNavEnabled            bool            `json:"non_admin_month_nav_enabled"`
	OpeningFloatEnabled                bool            `json:"opening_float_enabled"`
	CountOpeningCashOnClose            bool            `json:"count_opening_cash_on_close"`
	OverchangeConfirmation             bool            `json:"overchange_confirmation"`
	PageUnlockProducts                 bool            `json:"page_unlock_products"`
	HidePaymentMethodCurrency          bool            `json:"hide_payment_method_currency"`
	AutoAppendLbpZeros                 bool            `json:"auto_append_lbp_zeros"`
	AutoCloseStaleShifts               bool            `json:"auto_close_stale_shifts"`
	VisitorCounterEnabled              bool            `json:"visitor_counter_enabled"`
	ShiftReceiptUploadMode             int64           `json:"shift_receipt_upload_mode"`
	BranchPhone                        string          `json:"branch_phone"`
	MaxOverpaymentCents                int64           `json:"max_overpayment_cents"`
	DefaultOpeningFloatUsd             int64           `json:"default_opening_float_usd"`
	DefaultOpeningFloatLbp             int64           `json:"default_opening_float_lbp"`
	DisplayPrefs                       json.RawMessage `json:"display_prefs"`
	ScanByCodeEnabled                  bool            `json:"scan_by_code_enabled"`
	SoundsEnabled                      bool            `json:"sounds_enabled"`
	AttendanceManagerApprovalEnabled   bool            `json:"attendance_manager_approval_enabled"`
	ShiftReportSignatures              bool            `json:"shift_report_signatures"`
	ShiftReportUppercaseHeader         bool            `json:"shift_report_uppercase_header"`
	AutoCoverNegativeLbp               bool            `json:"auto_cover_negative_lbp"`
	ProductSearchCodeOnly              bool            `json:"product_search_code_only"`
	PriceEditRestricted                bool            `json:"price_edit_restricted"`
	PriceEditCodes                     string          `json:"price_edit_codes"`
	UnknownProductBarcode              string          `json:"unknown_product_barcode"`
	ProductSearchHiddenFields          string          `json:"product_search_hidden_fields"`
	ReceiptTheme                       string          `json:"receipt_theme"`
	ReceiptLayout                      string          `json:"receipt_layout"`
	DiscountToggle                     bool            `json:"discount_toggle"`
	DiscountToggleDefaultOff           bool            `json:"discount_toggle_default_off"`
	DealToggle                         bool            `json:"deal_toggle"`
}

type BranchShift struct {
	ID                int64        `json:"id"`
	BranchID          int64        `json:"branch_id"`
	ClientRef         string       `json:"client_ref"`
	BranchShiftID     int64        `json:"branch_shift_id"`
	OpenedAt          sql.NullTime `json:"opened_at"`
	ClosedAt          sql.NullTime `json:"closed_at"`
	ClosingPersonName string       `json:"closing_person_name"`
	OpeningFloatUsd   int64        `json:"opening_float_usd"`
	OpeningFloatLbp   int64        `json:"opening_float_lbp"`
	ExpectedUsd       int64        `json:"expected_usd"`
	ExpectedLbp       int64        `json:"expected_lbp"`
	ExpectedVisa      int64        `json:"expected_visa"`
	ExpectedWhish     int64        `json:"expected_whish"`
	CountedUsd        int64        `json:"counted_usd"`
	CountedLbp        int64        `json:"counted_lbp"`
	CountedVisa       int64        `json:"counted_visa"`
	CountedWhish      int64        `json:"counted_whish"`
	VarianceUsd       int64        `json:"variance_usd"`
	VarianceLbp       int64        `json:"variance_lbp"`
	VarianceVisa      int64        `json:"variance_visa"`
	VarianceWhish     int64        `json:"variance_whish"`
	OccurredAt        time.Time    `json:"occurred_at"`
	ReceivedAt        time.Time    `json:"received_at"`
	RegisterID        int64        `json:"register_id"`
	LbpRate           int64        `json:"lbp_rate"`
}

type BranchShiftIsClosedParams struct {
	RegisterID    int64 `json:"register_id"`
	BranchShiftID int64 `json:"branch_shift_id"`
}

type BranchShiftReceiptImage struct {
	ID            int64     `json:"id"`
	BranchShiftID int64     `json:"branch_shift_id"`
	FilePath      string    `json:"file_path"`
	ContentType   string    `json:"content_type"`
	SizeBytes     int64     `json:"size_bytes"`
	CreatedAt     time.Time `json:"created_at"`
	Rotation      int16     `json:"rotation"`
}

type BranchShiftRefsPresentParams struct {
	RegisterID int64    `json:"register_id"`
	Column2    []string `json:"column_2"`
}

type BranchShiftUploadToken struct {
	ID            int64        `json:"id"`
	BranchShiftID int64        `json:"branch_shift_id"`
	Token         string       `json:"token"`
	ExpiresAt     time.Time    `json:"expires_at"`
	UsedAt        sql.NullTime `json:"used_at"`
	CreatedAt     time.Time    `json:"created_at"`
}

type BranchSyncConflict struct {
	ID              int64                 `json:"id"`
	BranchID        int64                 `json:"branch_id"`
	Entity          string                `json:"entity"`
	Ref             string                `json:"ref"`
	Kind            string                `json:"kind"`
	BranchPayload   json.RawMessage       `json:"branch_payload"`
	CentralClientID sql.NullInt64         `json:"central_client_id"`
	Status          string                `json:"status"`
	Resolution      pqtype.NullRawMessage `json:"resolution"`
	ResolvedBy      sql.NullInt64         `json:"resolved_by"`
	CreatedAt       time.Time             `json:"created_at"`
	UpdatedAt       time.Time             `json:"updated_at"`
}

type BranchSyncConflictSummaryRow struct {
	BranchID     int64       `json:"branch_id"`
	Open         int64       `json:"open"`
	OpenOversold int64       `json:"open_oversold"`
	OldestOpenAt interface{} `json:"oldest_open_at"`
}

type BranchTarget struct {
	ID           int64         `json:"id"`
	BranchID     int64         `json:"branch_id"`
	DateFrom     time.Time     `json:"date_from"`
	DateTo       time.Time     `json:"date_to"`
	TargetAmount int64         `json:"target_amount"`
	Color        string        `json:"color"`
	CreatedAt    time.Time     `json:"created_at"`
	UpdatedAt    time.Time     `json:"updated_at"`
	SeriesID     sql.NullInt64 `json:"series_id"`
	IsActive     bool          `json:"is_active"`
}

type BranchTargetSeries struct {
	ID            int64     `json:"id"`
	BranchID      int64     `json:"branch_id"`
	TargetAmount  int64     `json:"target_amount"`
	Color         string    `json:"color"`
	StartDay      int32     `json:"start_day"`
	IntervalCount int32     `json:"interval_count"`
	Active        bool      `json:"active"`
	CreatedAt     time.Time `json:"created_at"`
	UpdatedAt     time.Time `json:"updated_at"`
}

type BranchTransferItemParams struct {
	Barcode    string        `json:"barcode"`
	ProductUID uuid.NullUUID `json:"product_uid"`
	Quantity   int64         `json:"quantity"`
}

type BranchTransferUploadToken struct {
	ID         int64        `json:"id"`
	TransferID int64        `json:"transfer_id"`
	Token      string       `json:"token"`
	ExpiresAt  time.Time    `json:"expires_at"`
	UsedAt     sql.NullTime `json:"used_at"`
	CreatedAt  time.Time    `json:"created_at"`
}

type BranchUser struct {
	ID           int64     `json:"id"`
	BranchID     int64     `json:"branch_id"`
	Username     string    `json:"username"`
	Role         string    `json:"role"`
	AkuvoxUserID string    `json:"akuvox_user_id"`
	IsActive     bool      `json:"is_active"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type BranchVisitorEvent struct {
	ID         int64     `json:"id"`
	BranchID   int64     `json:"branch_id"`
	ClientRef  string    `json:"client_ref"`
	Day        string    `json:"day"`
	Direction  string    `json:"direction"`
	OccurredAt time.Time `json:"occurred_at"`
	ReceivedAt time.Time `json:"received_at"`
}

type BranchVisitorEventRefsPresentParams struct {
	BranchID int64    `json:"branch_id"`
	Column2  []string `json:"column_2"`
}

type BulkSetDiscountListItemsParams struct {
	DiscountListID int64         `json:"discount_list_id"`
	Discount       int16         `json:"discount"`
	DealID         sql.NullInt64 `json:"deal_id"`
	Entries        []string      `json:"entries"`
}

type BulkSetDiscountListOptionItemsParams struct {
	DiscountListID int64    `json:"discount_list_id"`
	SaleOptionID   int64    `json:"sale_option_id"`
	Discount       int16    `json:"discount"`
	Entries        []string `json:"entries"`
}

type BumpAdminActivityParams struct {
	UserID   sql.NullInt64 `json:"user_id"`
	Method   string        `json:"method"`
	Route    string        `json:"route"`
	EntityID sql.NullInt64 `json:"entity_id"`
	Summary  string        `json:"summary"`
	Detail   string        `json:"detail"`
}

type BusyHoursSalesParams struct {
	FromDay   time.Time `json:"from_day"`
	ToDay     time.Time `json:"to_day"`
	BranchIds []int64   `json:"branch_ids"`
}

type BusyHoursSalesRow struct {
	Weekday      int32 `json:"weekday"`
	Hour         int32 `json:"hour"`
	Invoices     int64 `json:"invoices"`
	RevenueCents int64 `json:"revenue_cents"`
}

type BusyHoursVisitorsParams struct {
	FromDay   time.Time `json:"from_day"`
	ToDay     time.Time `json:"to_day"`
	BranchIds []int64   `json:"branch_ids"`
}

type BusyHoursVisitorsRow struct {
	Weekday  int32 `json:"weekday"`
	Hour     int32 `json:"hour"`
	Visitors int64 `json:"visitors"`
}

type CalendarEvent struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	Icon      string    `json:"icon"`
	Color     string    `json:"color"`
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
	CreatedAt time.Time `json:"created_at"`
}

type Cashbox struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	Code      string    `json:"code"`
	IsActive  bool      `json:"is_active"`
	CreatedAt time.Time `json:"created_at"`
}

type CashboxAccount struct {
	ID           int64     `json:"id"`
	Name         string    `json:"name"`
	CurrencyCode string    `json:"currency_code"`
	SortOrder    int32     `json:"sort_order"`
	Color        string    `json:"color"`
	UpdatedAt    time.Time `json:"updated_at"`
	IsActive     bool      `json:"is_active"`
}

type ClaimEmailScheduleRunParams struct {
	NextRunAt sql.NullTime `json:"next_run_at"`
	ID        int64        `json:"id"`
	DueAt     sql.NullTime `json:"due_at"`
}

type ClaimWhatsAppPollFollowupParams struct {
	FollowupBody string `json:"followup_body"`
	ID           int64  `json:"id"`
	ForReturning bool   `json:"for_returning"`
	ForNew       bool   `json:"for_new"`
}

type ClaimWhatsAppPollFollowupRow struct {
	ClientPhone string `json:"client_phone"`
	Instance    string `json:"instance"`
}

type ClaimWhatsAppWelcomeParams struct {
	Invoice    string        `json:"invoice"`
	TotalCents int64         `json:"total_cents"`
	Items      int32         `json:"items"`
	Phone      string        `json:"phone"`
	Branch     sql.NullInt64 `json:"branch"`
}

type Client struct {
	ID                 int64         `json:"id"`
	Name               string        `json:"name"`
	Phone              string        `json:"phone"`
	TotalLoyaltyPoints int64         `json:"total_loyalty_points"`
	ValidLoyaltyPoints int64         `json:"valid_loyalty_points"`
	CreatedAt          time.Time     `json:"created_at"`
	UpdatedAt          time.Time     `json:"updated_at"`
	ClientType         string        `json:"client_type"`
	Uid                uuid.UUID     `json:"uid"`
	IsActive           bool          `json:"is_active"`
	BranchID           sql.NullInt64 `json:"branch_id"`
	PhoneValid         bool          `json:"phone_valid"`
	PhoneCountry       string        `json:"phone_country"`
}

type ClientLink struct {
	BranchID       int64 `json:"branch_id"`
	BranchClientID int64 `json:"branch_client_id"`
	ClientID       int64 `json:"client_id"`
	RegisterID     int64 `json:"register_id"`
}

type ClientMonthlySpendRow struct {
	Month      string // "YYYY-MM"
	TotalCents int64
}

type ClientPaymentMixRow struct {
	AccountName string
	TotalCents  int64
}

type ClientProfileStats struct {
	TotalSpentCents int64
	ItemsBought     int64
	FirstPurchaseAt *time.Time
}

type ClientRecentInvoiceRow struct {
	ID             int64
	InvoiceCode    string
	GrandTotal     int64
	OccurredAt     time.Time
	BranchName     string
	ItemCount      int64
	PaymentMethods string // comma-separated
}

type ClientSpend struct {
	ClientID        int64        `json:"client_id"`
	TotalSpent      int64        `json:"total_spent"`
	GrossSpent      int64        `json:"gross_spent"`
	InvoiceCount    int64        `json:"invoice_count"`
	ItemCount       int64        `json:"item_count"`
	RefreshedAt     time.Time    `json:"refreshed_at"`
	FirstPurchaseAt sql.NullTime `json:"first_purchase_at"`
}

type Color struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	HexValue  string    `json:"hex_value"`
	Version   int32     `json:"version"`
	CreatedAt time.Time `json:"created_at"`
}

type CompleteBranchCommandParams struct {
	ID     int64                 `json:"id"`
	Status string                `json:"status"`
	Result pqtype.NullRawMessage `json:"result"`
	Error  sql.NullString        `json:"error"`
}

type ConfirmBranchTransferItemParams struct {
	Barcode          string        `json:"barcode"`
	ProductUID       uuid.NullUUID `json:"product_uid"`
	ReceivedQuantity int64         `json:"received_quantity"`
}

type ConfirmBranchTransferTxParams struct {
	BranchID   int64                             `json:"branch_id"`
	TransferID int64                             `json:"transfer_id"`
	Note       string                            `json:"note"`
	Items      []ConfirmBranchTransferItemParams `json:"items"`
}

type CountAssetsParams struct {
	CategoryID sql.NullInt64 `json:"category_id"`
	Search     string        `json:"search"`
}

type CountAttributeValuesParams struct {
	AttributeName string `json:"attribute_name"`
	Search        string `json:"search"`
}

type CountAuditLogsParams struct {
	EntityType sql.NullString  `json:"entity_type"`
	EntityID   sql.NullInt64   `json:"entity_id"`
	Action     NullAuditAction `json:"action"`
	ActorID    sql.NullInt64   `json:"actor_id"`
	FromDate   sql.NullTime    `json:"from_date"`
	ToDate     sql.NullTime    `json:"to_date"`
}

type CountBranchCommandsParams struct {
	BranchID   int64  `json:"branch_id"`
	RegisterID int64  `json:"register_id"`
	Status     string `json:"status"`
	Type       string `json:"type"`
}

type CountBranchExpensesParams struct {
	BranchID sql.NullInt64 `json:"branch_id"`
	Search   string        `json:"search"`
}

type CountBranchInvoicesFilteredParams struct {
	BranchID   sql.NullInt64  `json:"branch_id"`
	Search     string         `json:"search"`
	RegisterID sql.NullInt64  `json:"register_id"`
	Kind       sql.NullString `json:"kind"`
	Status     sql.NullString `json:"status"`
	DateFrom   sql.NullTime   `json:"date_from"`
	DateTo     sql.NullTime   `json:"date_to"`
}

type CountBranchSyncConflictsParams struct {
	Column1 int64  `json:"column_1"`
	Column2 string `json:"column_2"`
	Column3 string `json:"column_3"`
	Column4 string `json:"column_4"`
}

type CountBranchVisitorDayByDirectionParams struct {
	BranchID  int64  `json:"branch_id"`
	Day       string `json:"day"`
	Direction string `json:"direction"`
}

type CountClientsBySpendingCachedParams struct {
	ClientType   sql.NullString `json:"client_type"`
	Search       sql.NullString `json:"search"`
	PhoneValid   sql.NullBool   `json:"phone_valid"`
	PhoneCountry sql.NullString `json:"phone_country"`
}

type CountClientsBySpendingParams struct {
	ClientType   sql.NullString `json:"client_type"`
	Search       sql.NullString `json:"search"`
	PhoneValid   sql.NullBool   `json:"phone_valid"`
	PhoneCountry sql.NullString `json:"phone_country"`
	BranchIds    []int64        `json:"branch_ids"`
	DateFrom     sql.NullTime   `json:"date_from"`
	DateTo       sql.NullTime   `json:"date_to"`
	Visit        string         `json:"visit"`
}

type CountCouponsParams struct {
	Search     string           `json:"search"`
	Status     NullCouponStatus `json:"status"`
	CategoryID sql.NullInt64    `json:"category_id"`
	ListID     sql.NullInt64    `json:"list_id"`
}

type CountDashboardExpensesParams struct {
	Scope    string        `json:"scope"`
	DateFrom time.Time     `json:"date_from"`
	DateTo   time.Time     `json:"date_to"`
	BranchID sql.NullInt64 `json:"branch_id"`
}

type CountDashboardPurchasesParams struct {
	Scope    string    `json:"scope"`
	DateFrom time.Time `json:"date_from"`
	DateTo   time.Time `json:"date_to"`
}

type CountDashboardSalesParams struct {
	Scope    string        `json:"scope"`
	DateFrom time.Time     `json:"date_from"`
	DateTo   time.Time     `json:"date_to"`
	BranchID sql.NullInt64 `json:"branch_id"`
}

type CountDiscountListItemsWithProductParams struct {
	Search         string `json:"search"`
	DiscountListID int64  `json:"discount_list_id"`
}

type CountDiscountListRuleDecidedRow struct {
	RuleID   int64 `json:"rule_id"`
	Variants int64 `json:"variants"`
}

type CountEmployeesParams struct {
	Search   string        `json:"search"`
	BranchID sql.NullInt64 `json:"branch_id"`
}

type CountExpensesParams struct {
	CategoryID sql.NullInt64  `json:"category_id"`
	Search     sql.NullString `json:"search"`
}

type CountInventoryStockParams struct {
	InventoryID int64  `json:"inventory_id"`
	Search      string `json:"search"`
}

type CountLatestAdditionsSinceParams struct {
	IncludeAccounting bool      `json:"include_accounting"`
	Since             time.Time `json:"since"`
	IncludeHr         bool      `json:"include_hr"`
	IncludeInventory  bool      `json:"include_inventory"`
}

type CountLoanPaymentsParams struct {
	LoanID     sql.NullInt64  `json:"loan_id"`
	CategoryID sql.NullInt64  `json:"category_id"`
	Search     sql.NullString `json:"search"`
}

type CountLoansParams struct {
	BranchID   sql.NullInt64  `json:"branch_id"`
	Origin     sql.NullString `json:"origin"`
	CategoryID sql.NullInt64  `json:"category_id"`
	Search     sql.NullString `json:"search"`
	Status     sql.NullString `json:"status"`
}

type CountLowStockProductsParams struct {
	Status sql.NullString `json:"status"`
	Search string         `json:"search"`
}

type CountPriceListItemsWithProductParams struct {
	PriceListID int64  `json:"price_list_id"`
	Search      string `json:"search"`
}

type CountShiftsParams struct {
	Status    string        `json:"status"`
	CashboxID sql.NullInt64 `json:"cashbox_id"`
	Search    string        `json:"search"`
}

type CountSlowMovingProductsParams struct {
	Category sql.NullString `json:"category"`
	Search   string         `json:"search"`
}

type CountStockCountsParams struct {
	InventoryID sql.NullInt64        `json:"inventory_id"`
	Status      NullStockCountStatus `json:"status"`
}

type CountStockMovementsParams struct {
	InventoryID   sql.NullInt64           `json:"inventory_id"`
	VariantID     sql.NullInt64           `json:"variant_id"`
	Reason        NullStockMovementReason `json:"reason"`
	ReferenceType sql.NullString          `json:"reference_type"`
	CreatedBy     sql.NullInt64           `json:"created_by"`
	FromDate      sql.NullTime            `json:"from_date"`
	ToDate        sql.NullTime            `json:"to_date"`
}

type CountVisitorIPsParams struct {
	Search      string `json:"search"`
	CountryCode string `json:"country_code"`
}

type CountWhatsAppMessagesParams struct {
	FromAt   time.Time `json:"from_at"`
	ToAt     time.Time `json:"to_at"`
	BranchID int64     `json:"branch_id"`
	Status   string    `json:"status"`
	Search   string    `json:"search"`
}

type CountWhatsAppRepliesParams struct {
	FromAt   time.Time `json:"from_at"`
	ToAt     time.Time `json:"to_at"`
	BranchID int64     `json:"branch_id"`
	Search   string    `json:"search"`
}

type Coupon struct {
	Code               string         `json:"code"`
	Status             CouponStatus   `json:"status"`
	ClientID           sql.NullInt64  `json:"client_id"`
	ValidUntil         sql.NullTime   `json:"valid_until"`
	CreatedAt          time.Time      `json:"created_at"`
	CategoryID         sql.NullInt64  `json:"category_id"`
	TypeID             sql.NullInt64  `json:"type_id"`
	ListID             sql.NullInt64  `json:"list_id"`
	ValueCents         int64          `json:"value_cents"`
	RedeemedBranchID   sql.NullInt64  `json:"redeemed_branch_id"`
	RedeemedInvoiceRef sql.NullString `json:"redeemed_invoice_ref"`
	RedeemedAt         sql.NullTime   `json:"redeemed_at"`
	UpdatedAt          time.Time      `json:"updated_at"`
}

type CouponCategory struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	IsActive  bool      `json:"is_active"`
	Icon      string    `json:"icon"`
	Color     string    `json:"color"`
	Scope     string    `json:"scope"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type CouponList struct {
	ID           int64     `json:"id"`
	Name         string    `json:"name"`
	CouponTypeID int64     `json:"coupon_type_id"`
	IsActive     bool      `json:"is_active"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type CouponStatus string

type CouponType struct {
	ID                  int64         `json:"id"`
	Name                string        `json:"name"`
	ValueCents          int64         `json:"value_cents"`
	CurrencyCode        string        `json:"currency_code"`
	IsActive            bool          `json:"is_active"`
	ReferenceOnly       bool          `json:"reference_only"`
	CalculateOnCheckout bool          `json:"calculate_on_checkout"`
	CodeOptional        bool          `json:"code_optional"`
	CategoryID          sql.NullInt64 `json:"category_id"`
	CreatedAt           time.Time     `json:"created_at"`
	UpdatedAt           time.Time     `json:"updated_at"`
}

type CreateAdminActivityParams struct {
	UserID   sql.NullInt64 `json:"user_id"`
	Method   string        `json:"method"`
	Route    string        `json:"route"`
	EntityID sql.NullInt64 `json:"entity_id"`
	Summary  string        `json:"summary"`
	Detail   string        `json:"detail"`
}

type CreateAppReleaseParams struct {
	Version    string        `json:"version"`
	Flavor     string        `json:"flavor"`
	FileName   string        `json:"file_name"`
	FilePath   string        `json:"file_path"`
	SizeBytes  int64         `json:"size_bytes"`
	Sha256     string        `json:"sha256"`
	Signature  string        `json:"signature"`
	Notes      string        `json:"notes"`
	UploadedBy sql.NullInt64 `json:"uploaded_by"`
}

type CreateAppUpdateEventParams struct {
	RegisterID int64         `json:"register_id"`
	ReleaseID  sql.NullInt64 `json:"release_id"`
	AppVersion string        `json:"app_version"`
	State      string        `json:"state"`
	Detail     string        `json:"detail"`
}

type CreateAssetCategoryParams struct {
	Name     string `json:"name"`
	IsActive bool   `json:"is_active"`
	Icon     string `json:"icon"`
	Color    string `json:"color"`
}

type CreateAssetParams struct {
	Name       string    `json:"name"`
	Code       string    `json:"code"`
	CategoryID int64     `json:"category_id"`
	BoughtAt   time.Time `json:"bought_at"`
}

type CreateAuditLogParams struct {
	EntityType string                `json:"entity_type"`
	EntityID   int64                 `json:"entity_id"`
	Action     AuditAction           `json:"action"`
	Before     pqtype.NullRawMessage `json:"before"`
	After      pqtype.NullRawMessage `json:"after"`
	ActorID    sql.NullInt64         `json:"actor_id"`
	Source     string                `json:"source"`
}

type CreateBatchParams struct {
	Code        string        `json:"code"`
	PurchaseID  sql.NullInt64 `json:"purchase_id"`
	InventoryID sql.NullInt64 `json:"inventory_id"`
	Note        string        `json:"note"`
}

type CreateBatchTxParams struct {
	Code       string `json:"code"`
	PurchaseID int64  `json:"purchase_id"`
	Note       string `json:"note"`
}

type CreateBatchTxResult struct {
	Batch Batch       `json:"batch"`
	Items []BatchItem `json:"items"`
}

type CreateBranchAttendanceChangeParams struct {
	BranchID        int64     `json:"branch_id"`
	ClientRef       string    `json:"client_ref"`
	Kind            string    `json:"kind"`
	SalespersonName string    `json:"salesperson_name"`
	AttendanceDate  string    `json:"attendance_date"`
	OriginalTime    string    `json:"original_time"`
	RequestedTime   string    `json:"requested_time"`
	RequestedType   string    `json:"requested_type"`
	Action          string    `json:"action"`
	Status          string    `json:"status"`
	Note            string    `json:"note"`
	Actor           string    `json:"actor"`
	OccurredAt      time.Time `json:"occurred_at"`
	RegisterID      int64     `json:"register_id"`
}

type CreateBranchAttendanceEventParams struct {
	BranchID         int64  `json:"branch_id"`
	ClientRef        string `json:"client_ref"`
	SalespersonName  string `json:"salesperson_name"`
	AttendanceUserID string `json:"attendance_user_id"`
	EventDate        string `json:"event_date"`
	EventTime        string `json:"event_time"`
	EventAt          string `json:"event_at"`
	Type             string `json:"type"`
	Status           string `json:"status"`
	ChangedBy        string `json:"changed_by"`
	ChangeNote       string `json:"change_note"`
}

type CreateBranchCommandParams struct {
	BranchID   int64           `json:"branch_id"`
	RegisterID int64           `json:"register_id"`
	Type       string          `json:"type"`
	Payload    json.RawMessage `json:"payload"`
	IssuedBy   int64           `json:"issued_by"`
}

type CreateBranchExpenseImageParams struct {
	BranchExpenseID int64  `json:"branch_expense_id"`
	FilePath        string `json:"file_path"`
	ContentType     string `json:"content_type"`
	SizeBytes       int64  `json:"size_bytes"`
}

type CreateBranchExpenseParams struct {
	BranchID                 int64          `json:"branch_id"`
	ClientRef                string         `json:"client_ref"`
	Description              string         `json:"description"`
	CategoryID               sql.NullInt64  `json:"category_id"`
	Amount                   int64          `json:"amount"`
	CurrencyCode             string         `json:"currency_code"`
	BranchCashboxAccountID   int64          `json:"branch_cashbox_account_id"`
	BranchCashboxAccountName sql.NullString `json:"branch_cashbox_account_name"`
	BranchShiftID            sql.NullInt64  `json:"branch_shift_id"`
	OccurredAt               time.Time      `json:"occurred_at"`
	FromCentral              bool           `json:"from_central"`
}

type CreateBranchExpenseUploadTokenParams struct {
	BranchExpenseID int64     `json:"branch_expense_id"`
	Token           string    `json:"token"`
	ExpiresAt       time.Time `json:"expires_at"`
}

type CreateBranchInvoiceItemParams struct {
	BranchInvoiceID int64         `json:"branch_invoice_id"`
	BranchProductID int64         `json:"branch_product_id"`
	UnitPrice       int64         `json:"unit_price"`
	LineTotal       int64         `json:"line_total"`
	Discount        int16         `json:"discount"`
	Quantity        int64         `json:"quantity"`
	ProductUid      uuid.NullUUID `json:"product_uid"`
	Unknown         bool          `json:"unknown"`
	Deal            string        `json:"deal"`
	DealDiscount    int64         `json:"deal_discount"`
}

type CreateBranchInvoiceParams struct {
	BranchID               int64          `json:"branch_id"`
	ClientRef              string         `json:"client_ref"`
	Kind                   string         `json:"kind"`
	BranchInvoiceCode      string         `json:"branch_invoice_code"`
	BranchCashboxAccountID int64          `json:"branch_cashbox_account_id"`
	BranchShiftID          int64          `json:"branch_shift_id"`
	BranchInventoryID      int64          `json:"branch_inventory_id"`
	BranchClientID         sql.NullInt64  `json:"branch_client_id"`
	RelatedClientRef       sql.NullString `json:"related_client_ref"`
	Discount               int16          `json:"discount"`
	Subtotal               int64          `json:"subtotal"`
	DiscountedTotal        int64          `json:"discounted_total"`
	GrandTotal             int64          `json:"grand_total"`
	LoyaltyPointsDelta     int64          `json:"loyalty_points_delta"`
	OccurredAt             time.Time      `json:"occurred_at"`
	SalespersonName        string         `json:"salesperson_name"`
	Historical             bool           `json:"historical"`
	ClientUid              uuid.NullUUID  `json:"client_uid"`
	RegisterID             int64          `json:"register_id"`
	SalespersonID          sql.NullInt64  `json:"salesperson_id"`
	LbpTotal               sql.NullInt64  `json:"lbp_total"`
	LbpRate                sql.NullInt64  `json:"lbp_rate"`
}

type CreateBranchInvoicePaymentParams struct {
	BranchInvoiceID int64  `json:"branch_invoice_id"`
	AccountName     string `json:"account_name"`
	Amount          int64  `json:"amount"`
}

type CreateBranchInvoiceSettlementParams struct {
	BranchID      int64     `json:"branch_id"`
	ClientRef     string    `json:"client_ref"`
	SaleClientRef string    `json:"sale_client_ref"`
	GrandTotal    int64     `json:"grand_total"`
	OccurredAt    time.Time `json:"occurred_at"`
	Status        string    `json:"status"`
}

type CreateBranchInvoiceSettlementPaymentParams struct {
	BranchInvoiceSettlementID int64  `json:"branch_invoice_settlement_id"`
	AccountName               string `json:"account_name"`
	Amount                    int64  `json:"amount"`
}

type CreateBranchInvoiceTxParams struct {
	CreateBranchInvoiceParams
	Items    []BranchInvoiceItemParams    `json:"items"`
	Payments []BranchInvoicePaymentParams `json:"payments"`
	// The sale's invoice discount (000212): what it took off, and the
	// rule's name. 0 / "" for none.
	InvoiceDiscount     int64  `json:"invoice_discount"`
	InvoiceDiscountName string `json:"invoice_discount_name"`
}

type CreateBranchInvoiceTxResult struct {
	Invoice  BranchInvoice          `json:"invoice"`
	Items    []BranchInvoiceItem    `json:"items"`
	Payments []BranchInvoicePayment `json:"payments"`
	// StockSkippedItems counts line items whose barcode did not resolve to
	// a central variant (or whose branch has no linked inventory); those
	// lines are stored but did not move central stock.
	StockSkippedItems int `json:"stock_skipped_items"`
	// Oversold lists the "oversold" alerts this sale opened or refreshed:
	// lines that left central on-hand below zero.
	Oversold []BranchSyncConflict `json:"oversold"`
}

type CreateBranchLoanParams struct {
	BranchID                 sql.NullInt64  `json:"branch_id"`
	ClientRef                sql.NullString `json:"client_ref"`
	Description              string         `json:"description"`
	CategoryID               int64          `json:"category_id"`
	Amount                   int64          `json:"amount"`
	CurrencyCode             string         `json:"currency_code"`
	BranchCashboxAccountID   sql.NullInt64  `json:"branch_cashbox_account_id"`
	BranchCashboxAccountName sql.NullString `json:"branch_cashbox_account_name"`
	BranchShiftID            sql.NullInt64  `json:"branch_shift_id"`
	OccurredAt               time.Time      `json:"occurred_at"`
}

type CreateBranchParams struct {
	Name string `json:"name"`
	Code string `json:"code"`
}

type CreateBranchRegisterParams struct {
	BranchID   int64  `json:"branch_id"`
	Code       string `json:"code"`
	Name       string `json:"name"`
	ApiKeyHash string `json:"api_key_hash"`
}

type CreateBranchSalespersonParams struct {
	Name          string        `json:"name"`
	BranchID      sql.NullInt64 `json:"branch_id"`
	IsSalesperson bool          `json:"is_salesperson"`
}

type CreateBranchShiftParams struct {
	BranchID          int64        `json:"branch_id"`
	ClientRef         string       `json:"client_ref"`
	BranchShiftID     int64        `json:"branch_shift_id"`
	OpenedAt          sql.NullTime `json:"opened_at"`
	ClosedAt          sql.NullTime `json:"closed_at"`
	ClosingPersonName string       `json:"closing_person_name"`
	OpeningFloatUsd   int64        `json:"opening_float_usd"`
	OpeningFloatLbp   int64        `json:"opening_float_lbp"`
	ExpectedUsd       int64        `json:"expected_usd"`
	ExpectedLbp       int64        `json:"expected_lbp"`
	ExpectedVisa      int64        `json:"expected_visa"`
	ExpectedWhish     int64        `json:"expected_whish"`
	CountedUsd        int64        `json:"counted_usd"`
	CountedLbp        int64        `json:"counted_lbp"`
	CountedVisa       int64        `json:"counted_visa"`
	CountedWhish      int64        `json:"counted_whish"`
	VarianceUsd       int64        `json:"variance_usd"`
	VarianceLbp       int64        `json:"variance_lbp"`
	VarianceVisa      int64        `json:"variance_visa"`
	VarianceWhish     int64        `json:"variance_whish"`
	OccurredAt        time.Time    `json:"occurred_at"`
	RegisterID        int64        `json:"register_id"`
	LbpRate           int64        `json:"lbp_rate"`
}

type CreateBranchShiftReceiptImageParams struct {
	BranchShiftID int64  `json:"branch_shift_id"`
	FilePath      string `json:"file_path"`
	ContentType   string `json:"content_type"`
	SizeBytes     int64  `json:"size_bytes"`
}

type CreateBranchShiftUploadTokenParams struct {
	BranchShiftID int64     `json:"branch_shift_id"`
	Token         string    `json:"token"`
	ExpiresAt     time.Time `json:"expires_at"`
}

type CreateBranchTargetParams struct {
	BranchID     int64     `json:"branch_id"`
	DateFrom     time.Time `json:"date_from"`
	DateTo       time.Time `json:"date_to"`
	TargetAmount int64     `json:"target_amount"`
	Color        string    `json:"color"`
}

type CreateBranchTargetSeriesParams struct {
	BranchID      int64  `json:"branch_id"`
	TargetAmount  int64  `json:"target_amount"`
	Color         string `json:"color"`
	StartDay      int32  `json:"start_day"`
	IntervalCount int32  `json:"interval_count"`
}

type CreateBranchTransferRequestParams struct {
	FromInventoryID int64          `json:"from_inventory_id"`
	ToInventoryID   int64          `json:"to_inventory_id"`
	Type            TransferType   `json:"type"`
	Note            string         `json:"note"`
	BranchID        sql.NullInt64  `json:"branch_id"`
	ClientRef       sql.NullString `json:"client_ref"`
	RegisterID      sql.NullInt64  `json:"register_id"`
}

type CreateBranchTransferRequestTxParams struct {
	BranchID      int64                      `json:"branch_id"`
	RegisterID    int64                      `json:"register_id"`
	ClientRef     string                     `json:"client_ref"`
	ToInventoryID int64                      `json:"to_inventory_id"`
	Note          string                     `json:"note"`
	Items         []BranchTransferItemParams `json:"items"`
}

type CreateBranchTransferRequestTxResult struct {
	Transfer Transfer       `json:"transfer"`
	Items    []TransferItem `json:"items"`
}

type CreateBranchTransferUploadTokenParams struct {
	TransferID int64     `json:"transfer_id"`
	Token      string    `json:"token"`
	ExpiresAt  time.Time `json:"expires_at"`
}

type CreateBranchTxParams struct {
	Name string `json:"name"`
	Code string `json:"code"`
	// The branch's first register takes the branch code, so a single-till
	// branch keeps logging in with the code it was created with.
	RegisterAPIKeyHash string `json:"register_api_key_hash"`
}

type CreateBranchTxResult struct {
	Branch    Branch         `json:"branch"`
	Register  BranchRegister `json:"register"`
	Inventory Inventory      `json:"inventory"`
}