package repository

import (
	"fmt"
	"github.com/go-pg/pg/v10"
	"github.com/tiptok/gocomm/common"
	"github.com/tiptok/gocomm/pkg/cache"
	. "github.com/tiptok/gocomm/pkg/orm/pgx"
	"gitlab.fjmaimaimai.com/mmm-go/godevp/pkg/domain"
	"gitlab.fjmaimaimai.com/mmm-go/godevp/pkg/infrastructure/pg/models"
	"gitlab.fjmaimaimai.com/mmm-go/godevp/pkg/infrastructure/pg/transaction"
)

var (
	cacheRoleIdKey = func(id int64) string {
		return fmt.Sprintf("%v:cache:Role:id:%v", "godevp", id)
	}
)

type RoleRepository struct {
	*cache.CachedRepository
	transactionContext *transaction.TransactionContext
}

func (repository *RoleRepository) Save(dm *domain.Role) (*domain.Role, error) {
	var (
		err error
		m   = &models.Role{}
		tx  = repository.transactionContext.PgTx
	)
	if err = common.GobModelTransform(m, dm); err != nil {
		return nil, err
	}
	if dm.Identify() == nil {
		if err = tx.Insert(m); err != nil {
			return nil, err
		}
		dm.Id = m.Id
		return dm, nil
	}
	queryFunc := func() (interface{}, error) {
		return tx.Exec(`update role set role_name=?,parent_id=?,update_time=now() where id = ?`, m.RoleName, m.ParentId, m.Id)
	}
	if _, err = repository.Query(queryFunc, cacheRoleIdKey(dm.Id)); err != nil {
		return nil, err
	}
	return dm, nil
}

func (repository *RoleRepository) Remove(Role *domain.Role) (*domain.Role, error) {
	var (
		tx        = repository.transactionContext.PgTx
		RoleModel = &models.Role{Id: Role.Identify().(int64)}
	)
	queryFunc := func() (interface{}, error) {
		return tx.Model(RoleModel).Where("id = ?", Role.Id).Delete()
	}
	if _, err := repository.Query(queryFunc, cacheRoleIdKey(Role.Id)); err != nil {
		return Role, err
	}
	//if _, err := tx.Model(RoleModel).Where("id = ?", Role.Id).Delete(); err != nil {
	//	return Role, err
	//}
	return Role, nil
}

func (repository *RoleRepository) FindOne(queryOptions map[string]interface{}) (*domain.Role, error) {
	tx := repository.transactionContext.PgDd
	RoleModel := new(models.Role)
	//query := NewQuery(tx.Model(RoleModel), queryOptions)
	//query.SetWhere("id = ?", "id")
	//if err := query.First(); err != nil {
	//	return nil, fmt.Errorf("query row not found")
	//}
	queryFunc := func() (interface{}, error) {
		query := NewQuery(tx.Model(RoleModel), queryOptions)
		query.SetWhere("id = ?", "id")
		if err := query.First(); err != nil {
			return nil, fmt.Errorf("query row not found")
		}
		return RoleModel, nil
	}
	var options []cache.QueryOption
	if _, ok := queryOptions["id"]; !ok {
		options = append(options, cache.WithNoCacheFlag())
	}
	if err := repository.QueryCache(cacheRoleIdKey(queryOptions["id"].(int64)), RoleModel, queryFunc, options...); err != nil {
		return nil, err
	}

	if RoleModel.Id == 0 {
		return nil, fmt.Errorf("query row not found")
	}
	return repository.transformPgModelToDomainModel(RoleModel)
}

func (repository *RoleRepository) Find(queryOptions map[string]interface{}) (int64, []*domain.Role, error) {
	tx := repository.transactionContext.PgTx
	var RoleModels []*models.Role
	Roles := make([]*domain.Role, 0)
	query := NewQuery(tx.Model(&RoleModels), queryOptions).
		SetWhere("parent_id=?", "parentId").
		SetOrder("create_time", "sortByCreateTime").
		SetOrder("update_time", "sortByUpdateTime").
		SetOrder("id", "orderById")

	var err error
	if inRoleIds, ok := queryOptions["inRoleIds"]; ok {
		query.Where("id in (?)", pg.In(inRoleIds))
	}
	if query.AffectRow, err = query.SelectAndCount(); err != nil {
		return 0, Roles, err
	}
	for _, RoleModel := range RoleModels {
		if Role, err := repository.transformPgModelToDomainModel(RoleModel); err != nil {
			return 0, Roles, err
		} else {
			Roles = append(Roles, Role)
		}
	}
	return int64(query.AffectRow), Roles, nil
}

func (repository *RoleRepository) transformPgModelToDomainModel(RoleModel *models.Role) (*domain.Role, error) {
	m := &domain.Role{}
	err := common.GobModelTransform(m, RoleModel)
	return m, err
}

func NewRoleRepository(transactionContext *transaction.TransactionContext) (*RoleRepository, error) {
	if transactionContext == nil {
		return nil, fmt.Errorf("transactionContext参数不能为nil")
	}
	return &RoleRepository{transactionContext: transactionContext, CachedRepository: cache.NewDefaultCachedRepository()}, nil
}