/
bind_update.go
31 lines (27 loc) · 944 Bytes
/
bind_update.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
package OrgCoreCore
import (
AnalysisAny2 "github.com/fotomxq/weeekj_core/v5/analysis/any2"
CoreSQL "github.com/fotomxq/weeekj_core/v5/core/sql"
Router2SystemConfig "github.com/fotomxq/weeekj_core/v5/router2/system_config"
"time"
)
// 更新登陆时间
type argsUpdateBindLastTime struct {
//绑定ID
ID int64 `db:"id" json:"id" check:"id"`
}
func updateBindLastTime(args *argsUpdateBindLastTime) (err error) {
_, err = CoreSQL.UpdateOne(Router2SystemConfig.MainDB.DB, "UPDATE org_core_bind SET last_at = NOW() WHERE id = :id", args)
if err != nil {
return
}
deleteBindCache(args.ID)
return
}
// 更新统计信息
func updateOrgBindAnalysis(orgID int64) {
var count int64
//机构人数
_ = Router2SystemConfig.MainDB.Get(&count, "SELECT COUNT(id) FROM org_core_bind WHERE org_id = $1 AND delete_at < to_timestamp(1000000)", orgID)
AnalysisAny2.AppendData("re", "org_bind_count", time.Time{}, orgID, 0, 0, 0, 0, count)
}