package data

import (
	"context"
	"fmt"
	"time"

	"kra/internal/biz/example"
	"kra/internal/conf"
	dataexample "kra/internal/data/example"
	datasystem "kra/internal/data/system"
	pkgcasbin "kra/pkg/casbin"

	"github.com/casbin/casbin/v2"
	oracle "github.com/dzwvip/gorm-oracle"
	"github.com/glebarez/sqlite"
	_ "github.com/go-sql-driver/mysql"
	"github.com/google/wire"
	"github.com/redis/go-redis/v9"
	"gorm.io/driver/mysql"
	"gorm.io/driver/postgres"
	"gorm.io/driver/sqlserver"
	"gorm.io/gorm"
	"gorm.io/gorm/logger"
	"gorm.io/gorm/schema"
)

// ProviderSet is data providers.
var ProviderSet = wire.NewSet(
	NewDB,
	NewData,
	NewRedisClient,
	NewCasbinEnforcer,
	NewOssUploader,
	NewDataAuthorityProvider,
	// System
	datasystem.NewUserRepo,
	datasystem.NewApiRepo,
	datasystem.NewAuthorityRepo,
	datasystem.NewAuthorityBtnRepo,
	datasystem.NewCasbinRepo,
	datasystem.NewMenuRepo,
	datasystem.NewDictionaryRepo,
	datasystem.NewDictionaryDetailRepo,
	datasystem.NewJwtBlacklistRepo,
	datasystem.NewOperationRecordRepo,
	datasystem.NewParamsRepo,
	datasystem.NewErrorRepo,
	datasystem.NewVersionRepo,
	datasystem.NewExportTemplateRepo,
	datasystem.NewAutoCodeRepo,
	datasystem.NewAutoCodeHistoryRepo,
	datasystem.NewAutoCodePackageRepo,
	datasystem.NewAutoCodeTemplateRepo,
	datasystem.NewAutoCodePluginRepo,
	// Example
	dataexample.NewFileUploadRepo,
	dataexample.NewCustomerRepo,
	dataexample.NewAttachmentCategoryRepo,
	dataexample.NewBreakpointContinueRepo,
)

// Data 数据层包装器
type Data struct {
	db    *gorm.DB
	redis redis.UniversalClient
}

// NewData 创建数据层包装器
func NewData(db *gorm.DB, redisClient redis.UniversalClient) (*Data, func(), error) {
	cleanup := func() {
		// 关闭数据库连接
		if db != nil {
			sqlDB, err := db.DB()
			if err == nil {
				sqlDB.Close()
			}
		}
		// 关闭Redis连接
		if redisClient != nil {
			redisClient.Close()
		}
	}
	return &Data{db: db, redis: redisClient}, cleanup, nil
}

// DB 获取数据库连接
func (d *Data) DB() *gorm.DB {
	return d.db
}

// Redis 获取Redis客户端
func (d *Data) Redis() redis.UniversalClient {
	return d.redis
}

// NewDB 创建数据库连接（根据配置的数据库类型）
func NewDB(system *conf.System, mysqlCfg *conf.Mysql, pgsqlCfg *conf.Pgsql, sqliteCfg *conf.Sqlite, mssqlCfg *conf.Mssql, oracleCfg *conf.Oracle) (*gorm.DB, error) {
	dbType := "mysql"
	if system != nil && system.DbType != "" {
		dbType = system.DbType
	}

	switch dbType {
	case "mysql":
		return NewMysqlDB(mysqlCfg)
	case "pgsql":
		return NewPgsqlDB(pgsqlCfg)
	case "sqlite":
		return NewSqliteDB(sqliteCfg)
	case "mssql":
		return NewMssqlDB(mssqlCfg)
	case "oracle":
		return NewOracleDB(oracleCfg)
	default:
		return NewMysqlDB(mysqlCfg)
	}
}

// NewMysqlDB 创建MySQL数据库连接
func NewMysqlDB(c *conf.Mysql) (*gorm.DB, error) {
	if c == nil || c.DbName == "" {
		return nil, fmt.Errorf("mysql config is empty")
	}

	dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?%s",
		c.Username, c.Password, c.Path, c.Port, c.DbName, c.Config)

	gormConfig := newGormConfig(c.Prefix, c.Singular, c.LogMode)

	db, err := gorm.Open(mysql.New(mysql.Config{
		DSN:                       dsn,
		DefaultStringSize:         191,
		SkipInitializeWithVersion: false,
	}), gormConfig)
	if err != nil {
		return nil, err
	}

	if c.Engine != "" {
		db.InstanceSet("gorm:table_options", "ENGINE="+c.Engine)
	}

	sqlDB, err := db.DB()
	if err != nil {
		return nil, err
	}

	sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
	sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))

	return db, nil
}

// NewPgsqlDB 创建PostgreSQL数据库连接
func NewPgsqlDB(c *conf.Pgsql) (*gorm.DB, error) {
	if c == nil || c.DbName == "" {
		return nil, fmt.Errorf("pgsql config is empty")
	}

	dsn := fmt.Sprintf("host=%s user=%s password=%s dbname=%s port=%s %s",
		c.Path, c.Username, c.Password, c.DbName, c.Port, c.Config)

	gormConfig := newGormConfig(c.Prefix, c.Singular, c.LogMode)

	db, err := gorm.Open(postgres.New(postgres.Config{
		DSN:                  dsn,
		PreferSimpleProtocol: false,
	}), gormConfig)
	if err != nil {
		return nil, err
	}

	sqlDB, err := db.DB()
	if err != nil {
		return nil, err
	}

	sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
	sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))

	return db, nil
}

// NewSqliteDB 创建SQLite数据库连接
func NewSqliteDB(c *conf.Sqlite) (*gorm.DB, error) {
	if c == nil || c.DbName == "" {
		return nil, fmt.Errorf("sqlite config is empty")
	}

	dsn := c.DbName
	if c.Path != "" {
		dsn = fmt.Sprintf("%s/%s", c.Path, c.DbName)
	}

	gormConfig := newGormConfig(c.Prefix, c.Singular, c.LogMode)

	db, err := gorm.Open(sqlite.Open(dsn), gormConfig)
	if err != nil {
		return nil, err
	}

	sqlDB, err := db.DB()
	if err != nil {
		return nil, err
	}

	sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
	sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))

	return db, nil
}

// NewMssqlDB 创建MSSQL数据库连接
func NewMssqlDB(c *conf.Mssql) (*gorm.DB, error) {
	if c == nil || c.DbName == "" {
		return nil, fmt.Errorf("mssql config is empty")
	}

	dsn := fmt.Sprintf("sqlserver://%s:%s@%s:%s?database=%s&%s",
		c.Username, c.Password, c.Path, c.Port, c.DbName, c.Config)

	gormConfig := newGormConfig(c.Prefix, c.Singular, c.LogMode)

	db, err := gorm.Open(sqlserver.New(sqlserver.Config{
		DSN:               dsn,
		DefaultStringSize: 191,
	}), gormConfig)
	if err != nil {
		return nil, err
	}

	if c.Engine != "" {
		db.InstanceSet("gorm:table_options", "ENGINE="+c.Engine)
	}

	sqlDB, err := db.DB()
	if err != nil {
		return nil, err
	}

	sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
	sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))

	return db, nil
}

// NewOracleDB 创建Oracle数据库连接
func NewOracleDB(c *conf.Oracle) (*gorm.DB, error) {
	if c == nil || c.DbName == "" {
		return nil, fmt.Errorf("oracle config is empty")
	}

	dsn := fmt.Sprintf("oracle://%s:%s@%s:%s/%s?%s",
		c.Username, c.Password, c.Path, c.Port, c.DbName, c.Config)

	gormConfig := newGormConfig(c.Prefix, c.Singular, c.LogMode)

	db, err := gorm.Open(oracle.Open(dsn), gormConfig)
	if err != nil {
		return nil, err
	}

	sqlDB, err := db.DB()
	if err != nil {
		return nil, err
	}

	sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
	sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))

	return db, nil
}

// newGormConfig 创建GORM配置
func newGormConfig(prefix string, singular bool, logMode string) *gorm.Config {
	return &gorm.Config{
		Logger: logger.New(
			&gormLogWriter{},
			logger.Config{
				SlowThreshold: 200 * time.Millisecond,
				LogLevel:      parseLogLevel(logMode),
				Colorful:      true,
			},
		),
		NamingStrategy: schema.NamingStrategy{
			TablePrefix:   prefix,
			SingularTable: singular,
		},
		DisableForeignKeyConstraintWhenMigrating: true,
	}
}

// gormLogWriter GORM日志写入器
type gormLogWriter struct{}

func (w *gormLogWriter) Printf(format string, args ...interface{}) {
	fmt.Printf(format+"\n", args...)
}

// parseLogLevel 解析日志级别
func parseLogLevel(level string) logger.LogLevel {
	switch level {
	case "silent":
		return logger.Silent
	case "error":
		return logger.Error
	case "warn":
		return logger.Warn
	case "info":
		return logger.Info
	default:
		return logger.Info
	}
}

// NewRedisClient 创建Redis客户端
func NewRedisClient(c *conf.Redis, system *conf.System) (redis.UniversalClient, error) {
	// 如果不使用Redis，返回nil
	if system != nil && !system.UseRedis {
		return nil, nil
	}

	if c == nil {
		return nil, nil
	}

	var client redis.UniversalClient

	// 使用集群模式
	if c.UseCluster {
		client = redis.NewClusterClient(&redis.ClusterOptions{
			Addrs:    c.ClusterAddrs,
			Password: c.Password,
		})
	} else {
		// 使用单例模式
		client = redis.NewClient(&redis.Options{
			Addr:     c.Addr,
			Password: c.Password,
			DB:       int(c.Db),
		})
	}

	// 测试连接
	_, err := client.Ping(context.Background()).Result()
	if err != nil {
		return nil, fmt.Errorf("redis connect ping failed: %v", err)
	}

	return client, nil
}

// NewCasbinEnforcer 创建Casbin Enforcer
func NewCasbinEnforcer(db *gorm.DB) (*casbin.SyncedCachedEnforcer, error) {
	return pkgcasbin.InitCasbin(db, "")
}

// NewOssUploader 创建OSS上传器（默认使用空实现）
func NewOssUploader() example.OssUploader {
	// TODO: 根据配置返回实际的OSS实现
	return &example.NilOssUploader{}
}

// NewDataAuthorityProvider 创建数据权限提供者（默认使用简单实现）
func NewDataAuthorityProvider() example.DataAuthorityProvider {
	// TODO: 根据需要返回实际的数据权限实现
	return &example.SimpleDataAuthorityProvider{}
}