137 lines
4.0 KiB
Go
137 lines
4.0 KiB
Go
package productbenefitmod
|
|
|
|
import (
|
|
"fmt"
|
|
"time"
|
|
|
|
"91porn-server/common/db"
|
|
"91porn-server/common/log"
|
|
"91porn-server/models"
|
|
|
|
"go.mongodb.org/mongo-driver/bson"
|
|
"go.mongodb.org/mongo-driver/bson/primitive"
|
|
"go.mongodb.org/mongo-driver/mongo"
|
|
"go.mongodb.org/mongo-driver/mongo/options"
|
|
)
|
|
|
|
const table = models.ProductBenefit
|
|
|
|
// InitIndex 设置index
|
|
func initIndex() {
|
|
coll := coll(nil)
|
|
many := []mongo.IndexModel{
|
|
{
|
|
Keys: bson.D{{Key: "privilege", Value: 1}},
|
|
},
|
|
{
|
|
Keys: bson.D{{Key: "createdAt", Value: 1}},
|
|
},
|
|
{
|
|
Keys: bson.D{{Key: "updatedAt", Value: 1}},
|
|
},
|
|
}
|
|
if _, err := coll.CreateIndex(many); err != nil {
|
|
panic(fmt.Sprintf("%s model set index err ==>[%+v]", table, err))
|
|
}
|
|
}
|
|
|
|
func coll(t *db.MongoTool) *db.MongoTool {
|
|
if t == nil {
|
|
return mdb.Coll(table)
|
|
}
|
|
return t.Coll(table)
|
|
}
|
|
|
|
// FindProductBenefit 查询
|
|
func FindProductBenefit(pageNum, pageSize uint64) (p []ProductBenefit, err error) {
|
|
opts := (&options.FindOptions{}).
|
|
SetSort(bson.D{{Key: "sortCode", Value: -1}}).
|
|
SetSkip(int64((pageNum - 1) * pageSize)).
|
|
SetLimit(int64(pageSize))
|
|
var back []ProductBenefit
|
|
if err = coll(nil).Find(&back, nil, opts); err != nil {
|
|
log.Error(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "FindProductBenefit", table, "Find", err))
|
|
return nil, err
|
|
}
|
|
return back, nil
|
|
}
|
|
|
|
// FindAllProductBenefit 查询
|
|
func FindAllProductBenefit() (p []ALlProductBenefit, err error) {
|
|
opts := (&options.FindOptions{}).
|
|
SetSort(bson.D{{Key: "sortCode", Value: -1}})
|
|
var back []ALlProductBenefit
|
|
if err = coll(nil).Find(&back, nil, opts); err != nil {
|
|
log.Error(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "FindProductBenefit", table, "Find", err))
|
|
return nil, err
|
|
}
|
|
return back, nil
|
|
}
|
|
|
|
// FindProductBenefitByPrivilege 根据privilege查询
|
|
func FindProductBenefitByPrivilege(privileges *[]int) (p []ProductBenefit, err error) {
|
|
opts := options.Find().SetSort(bson.D{{"sortCode", -1}})
|
|
var back []ProductBenefit
|
|
if err = coll(nil).Find(&back, bson.M{"privilege": bson.M{"$in": privileges}}, opts); err != nil {
|
|
log.Error(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "FindProductBenefit", table, "Find", err))
|
|
return nil, err
|
|
}
|
|
return back, nil
|
|
}
|
|
|
|
// InsertProductBenefit 插入一条数据
|
|
func InsertProductBenefit(p *ProductBenefit) (err error) {
|
|
p.CreatedAt = time.Now()
|
|
if _, err = coll(nil).InsertOne(p); err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "InsertProductBenefit", table, "InsertOne", err))
|
|
}
|
|
return
|
|
}
|
|
|
|
// UpdateProductBenefit 修改Product类型
|
|
func UpdateProductBenefit(id string, set *ProductBenefitSelector) (err error) {
|
|
set.UpdatedAt = time.Now()
|
|
oid, err := primitive.ObjectIDFromHex(id)
|
|
if err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "UpdateProductBenefit", table, "ObjectIDFromHex", err),
|
|
log.Any("id", id),
|
|
log.Any("set", set),
|
|
)
|
|
return
|
|
}
|
|
if _, err = coll(nil).UpdateOne(bson.M{"_id": oid}, bson.M{"$set": set}); err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "UpdateProductBenefit", table, "UpdateOne", err),
|
|
log.Any("oid", oid),
|
|
log.Any("set", set),
|
|
)
|
|
}
|
|
return
|
|
}
|
|
|
|
// RemoveProductBenefit 删除Product类型
|
|
func RemoveProductBenefit(id string) (err error) {
|
|
OID, err := primitive.ObjectIDFromHex(id)
|
|
if err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "RemoveProductBenefit", table, "ObjectIDFromHex", err),
|
|
log.Any("id", id),
|
|
)
|
|
return
|
|
}
|
|
if _, err = coll(nil).DeleteOne(bson.M{"_id": OID}); err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "RemoveProductBenefit", table, "DeleteOne", err),
|
|
log.Any("OID", OID),
|
|
)
|
|
}
|
|
return
|
|
}
|
|
|
|
func FindOne(t *db.MongoTool, cond bson.M, opts ...*options.FindOneOptions) (data *ProductBenefit, err error) {
|
|
if err = coll(nil).FindOne(&data, cond, opts...); err != nil {
|
|
log.Warn(fmt.Sprintf("[METHOD-%s]==> Model %s %s fail error:%+v:", "FindOne", table, "FindOne", err),
|
|
log.Any("cond", cond),
|
|
)
|
|
return
|
|
}
|
|
return
|
|
}
|