81 lines
1.7 KiB
Go
81 lines
1.7 KiB
Go
package mysql
|
|
|
|
import (
|
|
"errors"
|
|
|
|
"gorm.io/gorm"
|
|
"myschools.me/heritage/heritage-api/model"
|
|
)
|
|
|
|
func ProjectCreate(p *model.Project) error {
|
|
db, err := newDB()
|
|
if err != nil {
|
|
return err
|
|
}
|
|
return db.Create(p).Error
|
|
}
|
|
|
|
func ProjectUpdate(p *model.Project) (bool, error) {
|
|
db, err := newDB()
|
|
if err != nil {
|
|
return false, err
|
|
}
|
|
tx := db.Model(&model.Project{}).Where("id = ? AND deleted_at = ?", p.ID).Updates(p)
|
|
if tx.Error != nil {
|
|
return false, tx.Error
|
|
}
|
|
return tx.RowsAffected > 0, nil
|
|
}
|
|
|
|
func ProjectDelete(id *string) error {
|
|
db, err := newDB()
|
|
if err != nil {
|
|
return err
|
|
}
|
|
if err := db.Model(&model.Project{}).Where("id = ?", *id).Delete(&model.Project{}).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func ProjectFirst(id *string) (*model.Project, error) {
|
|
db, err := newDB()
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
var p model.Project
|
|
if err := db.Where("id = ?", *id).First(&p).Error; err != nil {
|
|
if !errors.Is(err, gorm.ErrRecordNotFound) {
|
|
return nil, err
|
|
}
|
|
}
|
|
return &p, nil
|
|
}
|
|
|
|
func ProjectList(orgID, keyword *string, offset, limit *int) ([]model.Project, int64, error) {
|
|
db, err := newDB()
|
|
if err != nil {
|
|
return nil, 0, err
|
|
}
|
|
|
|
q := db.Model(&model.Project{})
|
|
if orgID != nil && *orgID != "" {
|
|
q = q.Where("org_id = ?", *orgID)
|
|
}
|
|
if keyword != nil && *keyword != "" {
|
|
kw := "%" + *keyword + "%"
|
|
q = q.Where("project_no LIKE ? OR name LIKE ?", kw, kw)
|
|
}
|
|
|
|
var total int64
|
|
if err := q.Count(&total).Error; err != nil {
|
|
return nil, 0, err
|
|
}
|
|
|
|
var items []model.Project
|
|
if err := q.Order("created_at desc").Offset(*offset).Limit(*limit).Find(&items).Error; err != nil {
|
|
return nil, 0, err
|
|
}
|
|
return items, total, nil
|
|
}
|