ClearSLAAlertCache deletes an SLA alert cache entry by its ID.

CreateAlertLog inserts a new alert log entry into the database.

CreateSLAAlertCache inserts a new entry into the sla_alert_cache table.

CreateTagAlert adds a new tag alert configuration for a user.

CreateUser adds a new user to the database.

DeleteTagAlert removes a specific tag alert configuration.

GetAllConfigurations retrieves all configuration values from the database.

GetAllUsers retrieves all users from the database.

GetConfiguration retrieves a configuration value by key from the database.

GetSLAAlertCache retrieves an SLA alert cache entry by user, ticket, and alert type.

GetTagAlertsByUser retrieves all tag alerts for a specific user.

GetUserByEmail retrieves a user by their email.

GetUserByID retrieves a user by their ID.

GetUsersWithDailySummaryEnabled returns a list of users who have enabled the daily summary.

SetConfiguration sets a configuration value by key in the database.

SetDatabase sets the global Database variable to the provided database instance.

UpdateUser updates a user's information in the database.

Database is a global variable to hold the database instance.