goods_remind.go

package model

import (
	"github.com/gohouse/gorose/v2"
	"time"
)

func UpdateGoodsRemindStatus(db gorose.IOrm, id int64, remindStatus int) (err error) {
	_, err = db.Table("lie_goods_remind").Where("id", id).Data(map[string]interface{}{
		"status":           remindStatus,
		"last_remind_time": time.Now().Unix(),
	}).Update()
	return err
}

func UpdateExpiredGoodsRemindStatus(db gorose.IOrm) (err error) {
	oneMonthAgeTimestamp := time.Now().Unix() - 30*24*3600
	_, err = db.Table("lie_goods_remind").Where("add_time", "<", oneMonthAgeTimestamp).Data(map[string]interface{}{
		"status":           2,
		"last_remind_time": time.Now().Unix(),
	}).Update()
	return err
}