// 库存预警历史DAO层 // 职责:预警历史查询、删除(无Insert/Update,由预警状态变更时自动归档) // 紧密耦合:service.InventoryWarningHistory // 注意:历史记录由系统自动归档,非用户手动创建 package dao import ( "assets/consts/public" dto "assets/model/dto/stock" entity "assets/model/entity/stock" "context" "gitea.com/red-future/common/db/mongo" "github.com/gogf/gf/v2/frame/g" "go.mongodb.org/mongo-driver/v2/bson" ) var InventoryWarningHistory = new(inventoryWarningHistory) type inventoryWarningHistory struct{} func (d *inventoryWarningHistory) GetOne(ctx context.Context, req *dto.GetInventoryWarningHistoryReq) (res *entity.InventoryWarningHistory, err error) { filter := bson.M{"_id": req.Id} err = mongo.DB().FindOne(ctx, filter, &res, public.InventoryWarningHistoryCollection) return } func (d *inventoryWarningHistory) List(ctx context.Context, req *dto.ListInventoryWarningHistoryReq) (res []entity.InventoryWarningHistory, total int64, err error) { filter, err := d.buildListFilter(ctx, req) if err != nil { return } total, err = mongo.DB().Find(ctx, filter, &res, public.InventoryWarningHistoryCollection, req.Page, req.OrderBy) return } func (d *inventoryWarningHistory) DeleteFake(ctx context.Context, req *dto.DeleteInventoryWarningHistoryReq) (err error) { filter := bson.M{"_id": req.Id} _, err = mongo.DB().DeleteSoft(ctx, filter, public.InventoryWarningHistoryCollection) return } func (d *inventoryWarningHistory) buildListFilter(ctx context.Context, req *dto.ListInventoryWarningHistoryReq) (filter bson.M, err error) { _ = ctx filter = bson.M{} if !g.IsEmpty(req.WarningType) { filter["warningType"] = req.WarningType } // 兼容单值和数组参数(优先使用数组) if len(req.BatchIDs) > 0 { filter["batchId"] = bson.M{"$in": req.BatchIDs} } else if !g.IsEmpty(req.BatchID) { filter["batchId"] = req.BatchID } if len(req.AssetIDs) > 0 { filter["assetId"] = bson.M{"$in": req.AssetIDs} } else if !g.IsEmpty(req.AssetID) { filter["assetId"] = req.AssetID } if len(req.AssetSkuIDs) > 0 { filter["assetSkuId"] = bson.M{"$in": req.AssetSkuIDs} } else if !g.IsEmpty(req.AssetSkuID) { filter["assetSkuId"] = req.AssetSkuID } if len(req.SupplierIDs) > 0 { filter["supplierId"] = bson.M{"$in": req.SupplierIDs} } else if !g.IsEmpty(req.SupplierID) { filter["supplierId"] = req.SupplierID } if !g.IsEmpty(req.Status) { filter["status"] = req.Status } if !g.IsEmpty(req.ProcessMethod) { filter["processMethod"] = req.ProcessMethod } if !g.IsEmpty(req.Keyword) { filter["batchNo"] = bson.M{"$regex": req.Keyword, "$options": "i"} } return }