package store

import (
	"context"
	"database/sql"
	"errors"

	"gitlab.com/Timfa/bluegit/internal/access"
	"gitlab.com/Timfa/bluegit/internal/i18n"
)

// TransferGroupOwner maakt toID de eigenaar. De vorige eigenaar blijft beheerder.
// toID moet al lid zijn.
func (s *Store) TransferGroupOwner(ctx context.Context, groupID, fromID, toID int64) error {
	if fromID == 0 || toID == 0 || fromID == toID {
		return i18n.E("err.ownerSame")
	}
	g, err := s.GroupByID(ctx, groupID)
	if err != nil {
		return err
	}
	if g.OwnerID != fromID {
		return i18n.E("err.ownerOnly")
	}
	var role string
	err = s.db.QueryRowContext(ctx, `SELECT role FROM group_members WHERE group_id = ? AND user_id = ?`, groupID, toID).Scan(&role)
	if errors.Is(err, sql.ErrNoRows) {
		return i18n.E("err.ownerMember")
	}
	if err != nil {
		return err
	}
	tx, err := s.db.BeginTx(ctx, nil)
	if err != nil {
		return err
	}
	defer func() { _ = tx.Rollback() }()
	if _, err := tx.ExecContext(ctx, `UPDATE groups SET owner_id = ? WHERE id = ?`, toID, groupID); err != nil {
		return err
	}
	if _, err := tx.ExecContext(ctx, `INSERT INTO group_members (group_id, user_id, role) VALUES (?, ?, ?)
		ON CONFLICT(group_id, user_id) DO UPDATE SET role = ?`, groupID, fromID, string(access.RoleMaintainer), string(access.RoleMaintainer)); err != nil {
		return err
	}
	if _, err := tx.ExecContext(ctx, `UPDATE group_members SET role = ? WHERE group_id = ? AND user_id = ?`, string(access.RoleMaintainer), groupID, toID); err != nil {
		return err
	}
	return tx.Commit()
}
