lc_finance/server/dao/department.go

package dao

import "server/global"

type Department struct {
	Id            int       `gorm:"primarykey" from:"id" json:"ID"`
	Name          string    `json:"name" from:"name" gorm:"comment:部门名称"`
	Desc          string    `json:"desc" from:"desc" gorm:"comment:部门描述"`
	PrincipalId   int       `json:"principalId" from:"principal_id" gorm:"comment:负责人id"`
	PrincipalName string    `json:"principalName" from:"principal_name" gorm:"comment:负责人姓名"`
	Users         []SysUser `json:"users" gorm:"-"`
	IsStart       bool      `json:"isStart" from:"is_start" gorm:"comment:是否启用"`
}

func (Department) TableName() string {
	return "department"
}

// TODO:部门查询

// QueryAllDep 查询所有部门
func QueryAllDep() (deps []Department, err error) {
	err = global.GVA_DB.Model(&Department{}).Find(&deps).Error
	return deps, err
}

// QueryDepByStart 查询启用部门
func QueryDepByStart() (deps []Department, err error) {
	err = global.GVA_DB.Model(&Department{}).Where("is_start = ?", true).Find(&deps).Error
	return deps, err
}

// QueryUsersByDepId 查询部门下的用户
func QueryUsersByDepId(depId int) (users []SysUser, err error) {
	err = global.GVA_DB.Model(&SysUser{}).Where("department_id =?", depId).Find(&users).Error
	return users, err
}

// TODO:部门新增

// CreateDep 创建部门
func (d Department) CreateDep() error {
	return global.GVA_DB.Create(&d).Error
}

// TODO:部门修改

// UpdateDep 修改部门
func (d Department) UpdateDep() error {
	return global.GVA_DB.Model(&d).Updates(d).Error
}

// UpdateDepStatus 修改部门状态
func UpdateDepStatus(depId int, isStart bool) error {
	return global.GVA_DB.Model(&Department{}).Where("id = ?", depId).Update("is_start", isStart).Error
}

// TODO:部门删除

// DeleteDep 删除部门
func DeleteDep(depId int) error {
	return global.GVA_DB.Where("id = ?", depId).Delete(&Department{}).Error
}