package mysql

import (
	"errors"

	"gorm.io/gorm"
	"myschools.me/heritage/heritage-api/model"
)

func PointCreate(p *model.Point) error {
	db, err := newDB()
	if err != nil {
		return err
	}
	return db.Create(p).Error
}

func PointUpdate(p *model.Point) (bool, error) {
	db, err := newDB()
	if err != nil {
		return false, err
	}
	tx := db.Model(&model.Point{}).Where("id = ? AND deleted = false", p.ID).Updates(p)
	if tx.Error != nil {
		return false, tx.Error
	}
	return tx.RowsAffected > 0, nil
}

func PointDelete(id *string) (bool, error) {
	db, err := newDB()
	if err != nil {
		return false, err
	}
	tx := db.Model(&model.Point{}).Where("id = ? AND deleted = false", *id).Update("deleted", true)
	if tx.Error != nil {
		return false, tx.Error
	}
	return tx.RowsAffected > 0, nil
}

func PointByID(id *string) (*model.Point, bool, error) {
	db, err := newDB()
	if err != nil {
		return nil, false, err
	}
	var p model.Point
	if err := db.Where("id = ? AND deleted = false", *id).First(&p).Error; err != nil {
		if errors.Is(err, gorm.ErrRecordNotFound) {
			return nil, false, nil
		}
		return nil, false, err
	}
	return &p, true, nil
}

func PointList(objectID, indicatorID, keyword *string, offset, limit *int) ([]model.Point, int64, error) {
	db, err := newDB()
	if err != nil {
		return nil, 0, err
	}
	q := db.Model(&model.Point{}).Where("deleted = false")
	if objectID != nil && *objectID != "" {
		q = q.Where("object_id = ?", *objectID)
	}
	if indicatorID != nil && *indicatorID != "" {
		q = q.Where("indicator_id = ?", *indicatorID)
	}
	if keyword != nil && *keyword != "" {
		kw := "%" + *keyword + "%"
		q = q.Where("name LIKE ?", kw)
	}

	var total int64
	if err := q.Count(&total).Error; err != nil {
		return nil, 0, err
	}

	var items []model.Point
	if err := q.Order("created_at desc").Offset(*offset).Limit(*limit).Find(&items).Error; err != nil {
		return nil, 0, err
	}
	return items, total, nil
}