-
Notifications
You must be signed in to change notification settings - Fork 0
/
log_get.go
204 lines (190 loc) · 8.14 KB
/
log_get.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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
package ServiceHousekeeping
import (
CoreSQL "github.com/fotomxq/weeekj_core/v5/core/sql"
CoreSQLPages "github.com/fotomxq/weeekj_core/v5/core/sql/pages"
CoreSQLTime "github.com/fotomxq/weeekj_core/v5/core/sql/time"
Router2SystemConfig "github.com/fotomxq/weeekj_core/v5/router2/system_config"
"github.com/lib/pq"
)
// ArgsGetLogList 获取日志列表参数
type ArgsGetLogList struct {
//分页
Pages CoreSQLPages.ArgsDataList `json:"pages"`
//服务用户ID
UserID int64 `db:"user_id" json:"userID" check:"id" empty:"true"`
//组织ID
// -1 跳过
OrgID int64 `db:"org_id" json:"orgID" check:"id" empty:"true"`
//成员ID
BindID int64 `db:"bind_id" json:"bindID" check:"id" empty:"true"`
//订单ID
OrderID int64 `db:"order_id" json:"orderID" check:"id" empty:"true"`
//是否已经上门
NeedIsNeed bool `json:"needIsNeed"`
IsNeed bool `json:"isNeed"`
//是否完成
NeedIsFinish bool `json:"needIsFinish"`
IsFinish bool `json:"isFinish"`
//是否支付
NeedIsPay bool `json:"needIsPay"`
IsPay bool `json:"isPay"`
//编号
// 商户下唯一
SN int64 `db:"sn" json:"sn" check:"int64Than0" empty:"true"`
//今日编号
SNDay int64 `db:"sn_day" json:"snDay" check:"int64Than0" empty:"true"`
//时间范围
// 部分统计支持
TimeBetween CoreSQLTime.DataCoreTime `json:"timeBetween"`
//是否删除
IsRemove bool `db:"is_remove" json:"isRemove" check:"bool"`
//搜索
Search string `json:"search" check:"search" empty:"true"`
}
// GetLogList 获取日志列表
func GetLogList(args *ArgsGetLogList) (dataList []FieldsLog, dataCount int64, err error) {
where := ""
maps := map[string]interface{}{}
where = CoreSQL.GetDeleteSQL(args.IsRemove, where)
if args.UserID > -1 {
where = where + " AND user_id = :user_id"
maps["user_id"] = args.UserID
}
if args.OrgID > -1 {
where = where + " AND org_id = :org_id"
maps["org_id"] = args.OrgID
}
if args.BindID > -1 {
where = where + " AND (bind_id = :bind_id OR :bind_id = ANY(other_binds))"
maps["bind_id"] = args.BindID
}
if args.OrderID > -1 {
where = where + " AND order_id = :order_id"
maps["order_id"] = args.OrderID
}
if args.NeedIsNeed {
if args.IsNeed {
where = where + " AND need_at >= to_timestamp(1000000)"
} else {
where = where + " AND need_at < to_timestamp(1000000)"
}
}
if args.NeedIsFinish {
if args.IsFinish {
where = where + " AND finish_at >= to_timestamp(1000000)"
} else {
where = where + " AND finish_at < to_timestamp(1000000)"
}
}
if args.NeedIsPay {
if args.IsPay {
where = where + " AND pay_at >= to_timestamp(1000000)"
} else {
where = where + " AND pay_at < to_timestamp(1000000)"
}
}
if args.SN > 0 {
where = where + " AND sn = :sn"
maps["sn"] = args.SN
}
if args.SNDay > 0 {
where = where + " AND sn_day = :sn_day"
maps["sn_day"] = args.SNDay
}
if args.TimeBetween.MinTime != "" && args.TimeBetween.MaxTime != "" {
var timeBetween CoreSQLTime.FieldsCoreTime
timeBetween, err = CoreSQLTime.GetBetweenByISO(args.TimeBetween)
if err != nil {
return
}
where = where + " AND create_at >= :start_at AND create_at <= :end_at"
maps["start_at"] = timeBetween.MinTime
maps["end_at"] = timeBetween.MaxTime
}
if args.Search != "" {
where = where + " AND (des ILIKE '%' || :search || '%' OR address::text ILIKE '%' || :search || '%')"
maps["search"] = args.Search
}
tableName := "service_housekeeping_log"
dataCount, err = CoreSQL.GetListPageAndCount(
Router2SystemConfig.MainDB.DB,
&dataList,
tableName,
"id",
"SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id FROM "+tableName+" WHERE "+where,
where,
maps,
&args.Pages,
[]string{"id", "create_at", "update_at", "delete_at", "need_at", "finish_at", "pay_at"},
)
return
}
// ArgsGetLogID 获取数据参数
type ArgsGetLogID struct {
//ID
ID int64 `db:"id" json:"id" check:"id"`
//组织ID
OrgID int64 `db:"org_id" json:"orgID" check:"id"`
//服务负责人
BindID int64 `db:"bind_id" json:"bindID" check:"id" empty:"true"`
}
// GetLogID 获取数据
func GetLogID(args *ArgsGetLogID) (data FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Get(&data, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE id = $1 AND ($2 < 1 OR org_id = $2) AND ($3 < 1 OR (bind_id = $3 OR $3 = ANY(other_binds)))", args.ID, args.OrgID, args.BindID)
return
}
// 获取服务单
func getLogID(id int64) (data FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Get(&data, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE id = $1", id)
return
}
// ArgsGetLogByUserID 获取用户的ID参数
type ArgsGetLogByUserID struct {
//ID
ID int64 `db:"id" json:"id" check:"id"`
//服务用户ID
UserID int64 `db:"user_id" json:"userID" check:"id"`
}
// GetLogByUserID 获取用户的ID
func GetLogByUserID(args *ArgsGetLogByUserID) (data FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Get(&data, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE id = $1 AND user_id = $2", args.ID, args.UserID)
return
}
// ArgsGetLogByOrderIDs 通过订单ID列查询服务单参数
type ArgsGetLogByOrderIDs struct {
//订单ID列
OrderIDs pq.Int64Array `db:"order_ids" json:"orderIDs" check:"ids"`
//组织ID
OrgID int64 `db:"org_id" json:"orgID" check:"id" empty:"true"`
//服务负责人
BindID int64 `db:"bind_id" json:"bindID" check:"id" empty:"true"`
//服务用户ID
UserID int64 `db:"user_id" json:"userID" check:"id" empty:"true"`
}
// GetLogByOrderIDs 通过订单ID列查询服务单
func GetLogByOrderIDs(args *ArgsGetLogByOrderIDs) (dataList []FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Select(&dataList, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE ($1 < 1 OR user_id = $1) AND delete_at < to_timestamp(1000000) AND order_id = ANY($2) AND ($3 < 1 OR org_id = $3) AND ($4 < 1 OR bind_id = $4)", args.UserID, args.OrderIDs, args.OrgID, args.BindID)
return
}
// 获取订单关联的服务单
func getLogByOrderID(orderID int64) (dataList []FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Select(&dataList, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE order_id = $1 AND delete_at < to_timestamp(1000000)", orderID)
return
}
// 获取支付关联的服务单
func getLogByPayID(payID int64) (dataList []FieldsLog, err error) {
err = Router2SystemConfig.MainDB.Select(&dataList, "SELECT id, create_at, update_at, delete_at, sn, sn_day, need_at, finish_at, user_id, org_id, bind_id, other_binds, mall_product_id, order_id, currency, price, pay_id, pay_at, des, address, config_id, params FROM service_housekeeping_log WHERE pay_id = $1 AND delete_at < to_timestamp(1000000)", payID)
return
}
// 获取订单关联的服务单数量
func getCountByOrderID(orderID int64) (count int64) {
_ = Router2SystemConfig.MainDB.Get(&count, "SELECT COUNT(id) FROM service_housekeeping_log WHERE order_id = $1 AND delete_at < to_timestamp(1000000)", orderID)
return
}
// 批量获取服务单
func getListByIDs(ids pq.Int64Array) (dataList []FieldsLog, err error) {
if err = Router2SystemConfig.MainDB.Select(&dataList, "SELECT id, org_id, bind_id FROM service_housekeeping_log WHERE id = ANY($1) AND delete_at < to_timestamp(1000000)", ids); err != nil {
return
}
return
}