2025-03-31 11:59:42 +08:00

117 lines
7.6 KiB
Go

// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.28.0
package db
import (
"context"
"github.com/jackc/pgx/v5/pgtype"
)
type Querier interface {
AllCategories(ctx context.Context) ([]*Category, error)
AllCustomers(ctx context.Context) ([]*Customer, error)
AllProjects(ctx context.Context) ([]*Project, error)
AllSysDepartment(ctx context.Context) ([]*SysDepartment, error)
AllSysMenu(ctx context.Context) ([]*SysMenu, error)
AllSysRole(ctx context.Context) ([]*SysRole, error)
CountCategoriesCondition(ctx context.Context, arg *CountCategoriesConditionParams) (int64, error)
CountCustomers(ctx context.Context) (int64, error)
CountProjects(ctx context.Context, status int16) (int64, error)
CountSysAuditLogCondition(ctx context.Context, arg *CountSysAuditLogConditionParams) (int64, error)
CountSysConfigCondition(ctx context.Context, key string) (int64, error)
CountSysDepartmentCondition(ctx context.Context, arg *CountSysDepartmentConditionParams) (int64, error)
CountSysRole(ctx context.Context) (int64, error)
CountSysRoleCondition(ctx context.Context, arg *CountSysRoleConditionParams) (int64, error)
CountSysUser(ctx context.Context) (int64, error)
CountSysUserCondition(ctx context.Context, arg *CountSysUserConditionParams) (int64, error)
CountSysUserLoginLogCondition(ctx context.Context, arg *CountSysUserLoginLogConditionParams) (int64, error)
CreateBudget(ctx context.Context, arg *CreateBudgetParams) (*Budget, error)
CreateCategory(ctx context.Context, arg *CreateCategoryParams) (*Category, error)
CreateCustomer(ctx context.Context, arg *CreateCustomerParams) (*Customer, error)
CreateExpense(ctx context.Context, arg *CreateExpenseParams) (*Expense, error)
CreateIncome(ctx context.Context, arg *CreateIncomeParams) (*Income, error)
CreateProject(ctx context.Context, arg *CreateProjectParams) (*Project, error)
CreateProjectFile(ctx context.Context, arg *CreateProjectFileParams) (*ProjectFile, error)
CreateRoleMenu(ctx context.Context, arg *CreateRoleMenuParams) error
CreateSysAuditLog(ctx context.Context, arg *CreateSysAuditLogParams) error
CreateSysConfig(ctx context.Context, arg *CreateSysConfigParams) error
CreateSysDepartment(ctx context.Context, arg *CreateSysDepartmentParams) (*SysDepartment, error)
CreateSysMenu(ctx context.Context, arg *CreateSysMenuParams) (*SysMenu, error)
CreateSysRole(ctx context.Context, arg *CreateSysRoleParams) (*SysRole, error)
CreateSysUser(ctx context.Context, arg *CreateSysUserParams) (*SysUser, error)
CreateSysUserLoginLog(ctx context.Context, arg *CreateSysUserLoginLogParams) error
DeleteProjectFile(ctx context.Context, projectID int64) error
DeleteRoleMneuByRoleID(ctx context.Context, roleID int32) error
ExistsCategories(ctx context.Context) (bool, error)
ExistsMenu(ctx context.Context) (bool, error)
ExistsSysConfigByKey(ctx context.Context, key string) (bool, error)
ExistsSysDepartment(ctx context.Context) (bool, error)
ExistsSysUser(ctx context.Context) (bool, error)
ExistsVipRole(ctx context.Context) (bool, error)
GetBudget(ctx context.Context, id int64) (*Budget, error)
GetCategory(ctx context.Context, id int32) (*Category, error)
GetCustomer(ctx context.Context, id int64) (*Customer, error)
GetExpense(ctx context.Context, id int64) (*Expense, error)
GetFirstVipRole(ctx context.Context) (*SysRole, error)
GetIncome(ctx context.Context, id int64) (*Income, error)
GetProject(ctx context.Context, id int64) (*Project, error)
GetSysConfig(ctx context.Context, id int32) (*SysConfig, error)
GetSysConfigByKey(ctx context.Context, key string) (*SysConfig, error)
GetSysDepartment(ctx context.Context, id int32) (*SysDepartment, error)
GetSysMenu(ctx context.Context, id int32) (*SysMenu, error)
GetSysMenuByUrl(ctx context.Context, url string) (*SysMenu, error)
GetSysRole(ctx context.Context, id int32) (*SysRole, error)
GetSysRoleByUserID(ctx context.Context, id int32) (*SysRole, error)
GetSysUser(ctx context.Context, id int32) (*SysUser, error)
GetSysUserByEmail(ctx context.Context, email string) (*SysUser, error)
ListBudgets(ctx context.Context, projectID int64) ([]*Budget, error)
ListCategories(ctx context.Context) ([]*Category, error)
ListCategoriesByPath(ctx context.Context, parentPath string) ([]*Category, error)
ListCategoriesCondition(ctx context.Context, arg *ListCategoriesConditionParams) ([]*Category, error)
ListCategoriesRecursive(ctx context.Context) ([]*ListCategoriesRecursiveRow, error)
ListCustomers(ctx context.Context, arg *ListCustomersParams) ([]*Customer, error)
ListProjectFiles(ctx context.Context, projectID int64) ([]*ProjectFile, error)
ListProjects(ctx context.Context, arg *ListProjectsParams) ([]*Project, error)
ListSysAuditLogCondition(ctx context.Context, arg *ListSysAuditLogConditionParams) ([]*SysAuditLog, error)
ListSysConfigCondition(ctx context.Context, arg *ListSysConfigConditionParams) ([]*SysConfig, error)
ListSysDepartment(ctx context.Context) ([]*SysDepartment, error)
ListSysDepartmentCondition(ctx context.Context, arg *ListSysDepartmentConditionParams) ([]*SysDepartment, error)
ListSysDepartmentRecursive(ctx context.Context) ([]*ListSysDepartmentRecursiveRow, error)
ListSysMenuByRoleID(ctx context.Context, roleID int32) ([]*SysMenu, error)
ListSysMenuIDByRoleID(ctx context.Context, roleID int32) ([]int32, error)
ListSysRole(ctx context.Context) ([]*SysRole, error)
ListSysRoleCondition(ctx context.Context, arg *ListSysRoleConditionParams) ([]*SysRole, error)
ListSysUser(ctx context.Context) ([]*SysUser, error)
ListSysUserByIds(ctx context.Context, dollar_1 []int32) ([]*SysUser, error)
ListSysUserCondition(ctx context.Context, arg *ListSysUserConditionParams) ([]*ListSysUserConditionRow, error)
ListSysUserLoginLogCondition(ctx context.Context, arg *ListSysUserLoginLogConditionParams) ([]*SysUserLoginLog, error)
RecursiveSysMenus(ctx context.Context) ([]*RecursiveSysMenusRow, error)
RecursiveSysMenusByRoleID(ctx context.Context, roleID int32) ([]*RecursiveSysMenusByRoleIDRow, error)
StatisticsExpense(ctx context.Context) ([]*StatisticsExpenseRow, error)
StatisticsExpenseByProjectID(ctx context.Context, projectID int64) ([]*StatisticsExpenseByProjectIDRow, error)
StatisticsIncome(ctx context.Context) ([]*StatisticsIncomeRow, error)
StatisticsIncomeByProjectID(ctx context.Context, projectID int64) ([]*StatisticsIncomeByProjectIDRow, error)
StatisticsProjectItem(ctx context.Context, id int64) (*StatisticsProjectItemRow, error)
StatisticsProjects(ctx context.Context) ([]*StatisticsProjectsRow, error)
SumExpense(ctx context.Context) (pgtype.Numeric, error)
SumExpenseByProjectID(ctx context.Context, projectID int64) (pgtype.Numeric, error)
SumIncome(ctx context.Context) (pgtype.Numeric, error)
SumIncomeByProjectID(ctx context.Context, projectID int64) (pgtype.Numeric, error)
UpdateBudget(ctx context.Context, arg *UpdateBudgetParams) (*Budget, error)
UpdateCategory(ctx context.Context, arg *UpdateCategoryParams) (*Category, error)
UpdateCustomer(ctx context.Context, arg *UpdateCustomerParams) (*Customer, error)
UpdateExpense(ctx context.Context, arg *UpdateExpenseParams) (*Expense, error)
UpdateIncome(ctx context.Context, arg *UpdateIncomeParams) (*Income, error)
UpdateProject(ctx context.Context, arg *UpdateProjectParams) (*Project, error)
UpdateSysConfigByKey(ctx context.Context, arg *UpdateSysConfigByKeyParams) error
UpdateSysDepartment(ctx context.Context, arg *UpdateSysDepartmentParams) (*SysDepartment, error)
UpdateSysMenu(ctx context.Context, arg *UpdateSysMenuParams) (*SysMenu, error)
UpdateSysRole(ctx context.Context, arg *UpdateSysRoleParams) (*SysRole, error)
UpdateSysUser(ctx context.Context, arg *UpdateSysUserParams) (*SysUser, error)
}
var _ Querier = (*Queries)(nil)