27 lines
811 B
Go
27 lines
811 B
Go
package system
|
|
|
|
import (
|
|
"ai4m/global"
|
|
"ai4m/model/system/response"
|
|
)
|
|
|
|
type ScreenService struct {
|
|
}
|
|
|
|
func (screenService *ScreenService) ScreenStorage() (response.ScreenStorage, error) {
|
|
var screenStorage response.ScreenStorage
|
|
err := global.PCM_MYSQL.Raw("select count(*) as storageNum from t_file where deleted_at is null").Scan(&screenStorage.StorageNum).Error
|
|
if err != nil {
|
|
return screenStorage, err
|
|
}
|
|
err = global.PCM_MYSQL.Raw("SELECT COALESCE(SUM(size), 0) AS storageSum FROM t_file WHERE deleted_at IS NULL").Scan(&screenStorage.StorageSize).Error
|
|
if err != nil {
|
|
return screenStorage, err
|
|
}
|
|
err = global.PCM_MYSQL.Raw("select count(*) from t_file where label_dict='4'").Scan(&screenStorage.ModelNum).Error
|
|
if err != nil {
|
|
return screenStorage, err
|
|
}
|
|
return screenStorage, nil
|
|
}
|