You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
2.1 KiB
82 lines
2.1 KiB
6 months ago
|
package service
|
||
|
|
|
||
|
|
import (
|
||
|
|
"fmt"
|
||
|
|
|
||
|
|
"bkb-seller/global"
|
||
|
|
"bkb-seller/model"
|
||
|
|
"bkb-seller/model/request"
|
||
|
|
"bkb-seller/model/response"
|
||
|
|
)
|
||
|
|
|
||
|
|
func GetSysDictDataLabel(typeCode, value string) string {
|
||
|
|
var res string
|
||
|
|
|
||
|
|
cacheKey := "bkb-admin_sys_dict_labels"
|
||
|
|
labelKey := fmt.Sprintf("%s_%s", typeCode, value)
|
||
|
|
res = RedisHashGet(cacheKey, labelKey)
|
||
|
|
if res == "" {
|
||
|
|
_ = global.MG_DB.Model(&model.SysDictData{}).Select("label").Where("type_code=? AND `value`=?", typeCode, value).Scan(&res).Error
|
||
|
|
go RedisHashSet(cacheKey, labelKey, res)
|
||
|
|
}
|
||
|
|
return res
|
||
|
|
}
|
||
|
|
|
||
|
|
func GetSysDictDataList(params request.SearchDictDataParams) (err error, list any) {
|
||
|
|
var lists []model.SysDictDataView
|
||
|
|
err = global.MG_DB.Model(&model.SysDictData{}).Where("type_code=? AND `status`='1'", params.TypeCode).Order("sort asc").Find(&lists).Error
|
||
|
|
return err, lists
|
||
|
|
}
|
||
|
|
|
||
|
|
func GetSysDictDataListByTypeCode(typeCode string) (list []model.SysDictDataView, err error) {
|
||
|
|
var lists []model.SysDictDataView
|
||
|
|
err = global.MG_DB.Model(&model.SysDictData{}).Where("type_code=? AND `status`='1'", typeCode).Order("sort asc").Find(&lists).Error
|
||
|
|
return lists, err
|
||
|
|
}
|
||
|
|
|
||
|
|
func ListCourier(req request.ListCourier) (res []response.Courier, total int64, err error) {
|
||
|
|
var list []model.Courier
|
||
|
|
offset := req.PageSize * (req.Page - 1)
|
||
|
|
db := global.MG_DB.Model(&model.Courier{})
|
||
|
|
if req.Name != ""{
|
||
|
|
db.Where("name like ?",req.Name+"%")
|
||
|
|
}
|
||
|
|
err = db.Count(&total).Error
|
||
|
|
if err != nil {
|
||
|
|
return
|
||
|
|
}
|
||
|
|
err = db.Offset(offset).Limit(req.PageSize).Find(&list).Error
|
||
|
|
if err != nil {
|
||
|
|
return
|
||
|
|
}
|
||
|
|
res = make([]response.Courier, 0, len(list))
|
||
|
|
for _, v := range list {
|
||
|
|
res = append(res, response.Courier{
|
||
|
|
|
||
|
|
Name: v.Name,
|
||
|
|
Code: v.Code,
|
||
|
|
})
|
||
|
|
}
|
||
|
|
return
|
||
|
|
}
|
||
|
|
|
||
|
|
func getSysDictDataMap(typeCode string, values ...string) (map[string]string, error) {
|
||
|
|
var (
|
||
|
|
err error
|
||
|
|
list []model.SysDictData
|
||
|
|
result = make(map[string]string)
|
||
|
|
)
|
||
|
|
db := global.MG_DB.Model(&model.SysDictData{}).Where("type_code = ?", typeCode)
|
||
|
|
if len(values) != 0 {
|
||
|
|
db = db.Where("value IN (?)", values)
|
||
|
|
}
|
||
|
|
err = db.Select("value,label").Find(&list).Error
|
||
|
|
if err != nil {
|
||
|
|
return nil, err
|
||
|
|
}
|
||
|
|
for _, data := range list {
|
||
|
|
result[data.Value] = data.Label
|
||
|
|
}
|
||
|
|
return result, nil
|
||
|
|
}
|