113 lines
3.1 KiB
Go
Executable File
113 lines
3.1 KiB
Go
Executable File
package models
|
|
|
|
import (
|
|
"time"
|
|
|
|
"github.com/sujit-baniya/fiber-boilerplate/app"
|
|
"gorm.io/gorm"
|
|
)
|
|
|
|
type Roles struct {
|
|
gorm.Model
|
|
ID uint `gorm:"primarykey"`
|
|
CreatedAt time.Time `json:"created_at" gorm:"column:created_at"`
|
|
Description string `json:"description" gorm:"column:description"`
|
|
Name string `json:"name" gorm:"column:name"`
|
|
HomeUrl string `json:"home_url" gorm:"column:home_url"`
|
|
EsPortalCliente bool `json:"es_portal_cliente" gorm:"column:es_portal_cliente;default:false"`
|
|
EsPortalPartner bool `json:"es_portal_partner" gorm:"column:es_portal_partner;default:false"`
|
|
Submodules []Submodules `json:"submodules" gorm:"many2many:roles_submodules"`
|
|
ConxDBs []ConxDb `json:"conx_dbs" gorm:"many2many:roles_conx_db"`
|
|
}
|
|
|
|
// TableName overrides the table name used by Modules to `modules`
|
|
func (Roles) TableName() string {
|
|
return "roles"
|
|
}
|
|
|
|
// AllModules recupera todos los módulos con búsqueda
|
|
func AllRoles(limit, offset int, search string) ([]Roles, int64, error) {
|
|
var roles []Roles
|
|
var total int64
|
|
db := app.Http.Database.DB.Model(&Roles{})
|
|
|
|
// Filtrar por término de búsqueda si se proporciona
|
|
if search != "" {
|
|
db = db.Where("name LIKE ? OR description LIKE ?", "%"+search+"%", "%"+search+"%")
|
|
}
|
|
|
|
// Obtener el total de módulos
|
|
if err := db.Count(&total).Error; err != nil {
|
|
return nil, 0, err
|
|
}
|
|
|
|
// Obtener los módulos con paginación
|
|
if err := db.Order("id DESC").Limit(limit).Offset(offset).Preload("Submodules").Preload("ConxDBs").Find(&roles).Error; err != nil {
|
|
return nil, 0, err
|
|
}
|
|
|
|
return roles, total, nil
|
|
}
|
|
|
|
// AllRolesSelect recupera todos los roles sin paginación
|
|
func AllRolesSelect() ([]Roles, error) {
|
|
var roles []Roles
|
|
|
|
// Realizar la consulta para obtener todos los roles
|
|
if err := app.Http.Database.DB.Model(&Roles{}).Find(&roles).Error; err != nil {
|
|
return nil, err
|
|
}
|
|
|
|
return roles, nil
|
|
}
|
|
|
|
// CreateModule creates a new rol
|
|
func CreateRole(role Roles) error {
|
|
var conxDbs []ConxDb
|
|
for _, db := range role.ConxDBs {
|
|
var found ConxDb
|
|
if err := app.Http.Database.DB.First(&found, db.ID).Error; err == nil {
|
|
conxDbs = append(conxDbs, found)
|
|
}
|
|
}
|
|
role.ConxDBs = conxDbs
|
|
if err := app.Http.Database.DB.Create(&role).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// UpdateModule updates an existing module
|
|
func UpdateRole(role Roles) error {
|
|
if err := app.Http.Database.DB.Save(&role).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// DeleteModule deletes a module by its ID
|
|
func DeleteRole(id uint) error {
|
|
if err := app.Http.Database.DB.Delete(&Roles{}, id).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func FindRoleByName(name string) (Roles, error) {
|
|
var role Roles
|
|
if err := app.Http.Database.DB.Where("name = ?", name).First(&role).Error; err != nil {
|
|
return role, err
|
|
}
|
|
return role, nil
|
|
}
|
|
|
|
// GetPortalRoles devuelve los roles marcados como portal cliente o portal partner.
|
|
func GetPortalRoles() ([]Roles, error) {
|
|
var roles []Roles
|
|
err := app.Http.Database.DB.
|
|
Where("es_portal_cliente = ? OR es_portal_partner = ?", true, true).
|
|
Order("name ASC").
|
|
Find(&roles).Error
|
|
return roles, err
|
|
}
|