logical_log.go 41 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238
  1. package loging
  2. import (
  3. "context"
  4. "encoding/json"
  5. "errors"
  6. "fmt"
  7. "github.com/go-redis/redis/v8"
  8. "go.uber.org/zap"
  9. "gorm.io/gorm"
  10. "log-server/global"
  11. "log-server/model/log"
  12. "log-server/model/log/request"
  13. "log-server/model/typeManage"
  14. "log-server/service/cache"
  15. "log-server/utils"
  16. "strconv"
  17. "strings"
  18. "time"
  19. )
  20. var (
  21. FailStatus = "fail"
  22. OkStatus = "ok"
  23. NoLogStatus = "notStatus"
  24. GameCacheKey = "%s:game"
  25. NodeGameCacheKey = "%s:log"
  26. reportPointsKey = "%s:logUuid:"
  27. logUuidAccountGameId = "%s:logUuid:account:gameId"
  28. ComputerCacheKey = "%s:computer:list"
  29. ComputerPullAccountCacheKey = "%s:computer:%s:pullAccount:"
  30. ComputerEnterMainCacheKey = "%s:computer:%s:enterMain:"
  31. ComputerTaskSuccessCacheKey = "%s:computer:%s:taskSuccess:"
  32. GameFeeRateCacheKey = "%s:game:gameFeeRate:%d"
  33. GameComputerRateCacheKey = "%s:Computer:Rate:%s:"
  34. GamePcFeeRateCacheKey = "%s:gamePc:gameFeeRate:%d:%s"
  35. OnLineComputerNum = "%s:OnLineComputerNum:"
  36. PcReportingLog = "%s:pc:Reporting:%s"
  37. GameDeviceErrKey = "%s:device:%d"
  38. GameDeviceAccountErrKey = "%s:deviceAccount:%d"
  39. GameDeviceUuidKey = "%s:GameDeviceUuid:%s"
  40. )
  41. type LogicalLog struct {
  42. Status int // 状态
  43. Request request.AddLogRequest
  44. cache cache.Cache
  45. ScriptType int
  46. Person typeManage.ResponsiblePerson
  47. }
  48. func (s *LogicalLog) CurrentDate() (current string) {
  49. current = time.Now().Format("2006-01-02")
  50. return
  51. }
  52. func (s *LogicalLog) YesterdayDate() (yesterday string) {
  53. yesterday = time.Now().Add(-time.Hour * 24).Format("2006-01-02")
  54. return
  55. }
  56. func (s *LogicalLog) DataAdd() (err error) {
  57. logInfo, err := s.RepositoryData()
  58. if err != nil {
  59. return err
  60. }
  61. err = s.LogAdd(logInfo)
  62. if err != nil {
  63. return
  64. }
  65. /*if s.Status == 0 {
  66. _ = s.errLogAdd(logInfo)
  67. }*/
  68. ctx := context.Background()
  69. err = s.SetGameCache(ctx, s.CurrentDate(), logInfo.GameId)
  70. if err != nil {
  71. return
  72. }
  73. err = s.SetAccountGameIdCache(ctx, s.CurrentDate(), logInfo)
  74. if err != nil {
  75. return
  76. }
  77. if logInfo.PcCode != "" {
  78. err = s.SetComputerCache(ctx, s.CurrentDate(), logInfo.PcCode, logInfo.Operator)
  79. _ = s.StatisticsComputerRateData(ctx, logInfo.PcCode, logInfo.GameId)
  80. _ = s.SetOnlineComputerNumCache(ctx, s.CurrentDate(), logInfo.PcCode, logInfo.Operator)
  81. s.SetPcReportingLog(ctx, logInfo.PcCode, logInfo.Operator)
  82. }
  83. return
  84. }
  85. func (s *LogicalLog) NoLogStatusDataAdd(ctx context.Context) (err error) {
  86. logInfo, err := s.RepositoryData()
  87. if err != nil {
  88. return err
  89. }
  90. err = s.LogAdd(logInfo)
  91. return
  92. }
  93. func (s *LogicalLog) getLogByUuid(uuid string) (log log.Loging, err error) {
  94. createDate := time.Now().Format("2006-01")
  95. db := global.GVA_DB.Table("loging_" + createDate)
  96. db = db.Where("log_uuid = ?", uuid)
  97. db = db.Where("coding = 4101099 or coding = 4103099")
  98. db.First(&log)
  99. return
  100. }
  101. func (s *LogicalLog) GetLogByUuidCoding(uuid string, coding int, scriptType int) (log log.Loging, err error) {
  102. createDate := time.Now().Format("2006-01")
  103. db := global.GVA_DB.Table("loging_" + createDate)
  104. db = db.Where("log_uuid = ?", uuid)
  105. db = db.Where("coding = ?", coding)
  106. db = db.Where("script_type = ?", scriptType)
  107. db.First(&log)
  108. return
  109. }
  110. func (s *LogicalLog) RepositoryData() (*log.Loging, error) {
  111. nodeCode, typeCode, err := s.codeData()
  112. if err != nil {
  113. return nil, err
  114. }
  115. if s.Request.GameId == 0 {
  116. loging, err := s.GetAccountGameIdCache(context.Background(), s.CurrentDate(), s.Request.LogUuid)
  117. if err != nil {
  118. return nil, err
  119. }
  120. if loging.GameId == 0 {
  121. return nil, errors.New("没有找到数据" + s.Request.LogUuid)
  122. }
  123. s.Request.GameId = loging.GameId
  124. s.Request.Account = loging.Account
  125. s.Request.DeviceId = loging.DeviceId
  126. s.Request.ComputerType = loging.ComputerType
  127. s.Request.EnvCode = loging.EnvCode
  128. s.Request.Operator = loging.Operator
  129. s.Request.PcCode = loging.PcCode
  130. s.Request.PcIp = loging.PcIp
  131. s.Request.PcMac = loging.PcMac
  132. s.Request.SimulatorIp = loging.SimulatorIp
  133. s.Request.SimulatorMac = loging.SimulatorMac
  134. s.Request.AccountType = loging.AccountType
  135. s.Request.TaskType = loging.TaskType
  136. }
  137. logInfo := new(log.Loging)
  138. logInfo.Coding = s.Request.Coding
  139. logInfo.GameId = s.Request.GameId
  140. logInfo.Status = s.Status
  141. logInfo.Account = s.Request.Account
  142. logInfo.NodeCoding = nodeCode
  143. logInfo.TypeCoding = typeCode
  144. logInfo.DeviceId = s.Request.DeviceId
  145. logInfo.ComputerType = s.Request.ComputerType
  146. logInfo.EnvCode = s.Request.EnvCode
  147. logInfo.LogUuid = s.Request.LogUuid
  148. logInfo.Operator = s.Request.Operator
  149. logInfo.PcCode = s.Request.PcCode
  150. logInfo.PcIp = s.Request.PcIp
  151. logInfo.SimulatorIp = s.Request.SimulatorIp
  152. logInfo.SimulatorMac = s.Request.SimulatorMac
  153. logInfo.PcMac = s.Request.PcMac
  154. logInfo.AccountType = s.Request.AccountType
  155. logInfo.TaskType = s.Request.TaskType
  156. logInfo.ScriptType = s.ScriptType
  157. logInfo.Remarks = s.Request.Remarks
  158. logInfo.CreateDate = time.Now().Format("2006-01-02")
  159. logInfo.CreateTime = time.Now().Format("2006-01-02 15:04:05")
  160. return logInfo, err
  161. }
  162. func (s *LogicalLog) codeData() (nodeCode, typeCode int, err error) {
  163. code := strconv.Itoa(s.Request.Coding)
  164. nodeCodeStr := code[:3]
  165. typeCodeStr := code[:5]
  166. nodeCode, err = strconv.Atoi(nodeCodeStr)
  167. if err != nil {
  168. return
  169. }
  170. typeCode, err = strconv.Atoi(typeCodeStr)
  171. return
  172. }
  173. func (s *LogicalLog) LogAdd(l *log.Loging) error {
  174. createDate := l.CreateDate
  175. splitTime := strings.Split(createDate, "-")
  176. date := splitTime[0] + "-" + splitTime[1]
  177. if date != "2022-11" {
  178. table := "loging_" + splitTime[0] + "-" + splitTime[1]
  179. return global.GVA_DB.Table(table).Create(&l).Error
  180. }
  181. return global.GVA_DB.Create(&l).Error
  182. }
  183. func (s *LogicalLog) errLogAdd(l *log.Loging) error {
  184. return global.GVA_DB.Table("err_log").Create(&l).Error
  185. }
  186. func (s *LogicalLog) ReportPointsLog(ctx context.Context, request1 request.AddLogRequest) (err error) {
  187. key := reportPointsKey + request1.LogUuid
  188. status, err := global.GVA_REDIS.Exists(ctx, key).Result()
  189. if err != nil {
  190. return
  191. }
  192. var reportPointsData []*request.ReportPointsData
  193. if status == 0 {
  194. reportData := new(request.ReportPointsData)
  195. reportData.Data = request1.ReportPointsData
  196. reportData.Date = time.Now().Format("2006-01-02 15:04:05")
  197. reportPointsData = append(reportPointsData, reportData)
  198. str, _ := json.Marshal(reportPointsData)
  199. global.GVA_REDIS.Set(ctx, key, str, time.Minute*20)
  200. } else {
  201. str, _ := global.GVA_REDIS.Get(ctx, key).Result()
  202. err := json.Unmarshal([]byte(str), &reportPointsData)
  203. if err != nil {
  204. return err
  205. }
  206. reportData := new(request.ReportPointsData)
  207. reportData.Data = request1.ReportPointsData
  208. reportData.Date = time.Now().Format("2006-01-02 15:04:05")
  209. reportPointsData = append(reportPointsData, reportData)
  210. str1, _ := json.Marshal(reportPointsData)
  211. global.GVA_REDIS.Set(ctx, key, str1, time.Minute*20)
  212. }
  213. return err
  214. }
  215. func (s *LogicalLog) ReportPointsLogAdd(ctx context.Context, request1 request.AddLogRequest, status int) (err error) {
  216. key := reportPointsKey + request1.LogUuid
  217. isNull, err := global.GVA_REDIS.Exists(ctx, key).Result()
  218. if err != nil {
  219. return
  220. }
  221. if isNull == 0 {
  222. return
  223. } else {
  224. str, err := global.GVA_REDIS.Get(ctx, key).Result()
  225. if err != nil {
  226. return err
  227. }
  228. logIfo, _ := s.GetAccountGameIdCache(ctx, s.CurrentDate(), request1.LogUuid)
  229. var reportPointsData []*request.ReportPointsData
  230. err = json.Unmarshal([]byte(str), &reportPointsData)
  231. if err != nil {
  232. return err
  233. }
  234. reportPoints := new(log.ReportPointsLog)
  235. reportPoints.ReportPointsData = str
  236. reportPoints.LogUuid = request1.LogUuid
  237. reportPoints.Status = status
  238. reportPoints.Account = logIfo.Account
  239. reportPoints.GameId = logIfo.GameId
  240. reportPoints.Coding = logIfo.Coding
  241. reportPoints.ReportPointsNum = len(reportPointsData)
  242. reportPoints.CreateDate = time.Now().Format("2006-01-02")
  243. reportPoints.CreateTime = time.Now().Format("2006-01-02 15:04:05")
  244. err = global.GVA_DB.Create(&reportPoints).Error
  245. if err != nil {
  246. return err
  247. }
  248. global.GVA_REDIS.Del(ctx, key)
  249. err = s.DelAccountGameIdCache(ctx, s.CurrentDate(), logIfo.LogUuid)
  250. }
  251. return
  252. }
  253. func (s *LogicalLog) ExistsKey(ctx context.Context, key string) (bool, error) {
  254. isNull, err := global.GVA_REDIS.Exists(ctx, key).Result()
  255. if err != nil {
  256. return false, err
  257. }
  258. if isNull == 0 {
  259. return false, nil
  260. } else {
  261. return true, nil
  262. }
  263. }
  264. func (s *LogicalLog) ExistsHsKey(ctx context.Context, key string, field string) (bool, error) {
  265. isNull, err := global.GVA_REDIS.HExists(ctx, key, field).Result()
  266. if err != nil {
  267. return false, err
  268. }
  269. return isNull, err
  270. }
  271. // 前3个编号
  272. func (s *LogicalLog) NodeLogSetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (err error) {
  273. node := code[:3]
  274. err = s.LogSetNum(ctx, date, gameId, node, status, taskType)
  275. return
  276. }
  277. // 前5个编号
  278. func (s *LogicalLog) TypeLogSetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (err error) {
  279. node := code[:5]
  280. err = s.LogSetNum(ctx, date, gameId, node, status, taskType)
  281. return
  282. }
  283. // 整个编号
  284. func (s *LogicalLog) CodeLogSetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (err error) {
  285. err = s.LogSetNum(ctx, date, gameId, code, status, taskType)
  286. return
  287. }
  288. // 前5个编号和整个编号缓存
  289. func (s *LogicalLog) PartTypeLogSetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (err error) {
  290. node := code[:5]
  291. err = s.LogSetNum(ctx, date, gameId, node, status, taskType)
  292. if err != nil {
  293. return
  294. }
  295. err = s.LogSetNum(ctx, date, gameId, code, status, taskType)
  296. return
  297. }
  298. func (s *LogicalLog) LogSetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (err error) {
  299. strGameId := strconv.Itoa(gameId)
  300. nodeGameCacheKey := fmt.Sprintf(NodeGameCacheKey, date)
  301. key := nodeGameCacheKey + ":" + strGameId + ":" + strconv.Itoa(taskType) + ":" + status + ":" + code
  302. err = s.SetCacheNum(ctx, key)
  303. return
  304. }
  305. func (s *LogicalLog) SetCacheNum(ctx context.Context, key string) (err error) {
  306. bl, err := s.ExistsKey(ctx, key)
  307. if err != nil {
  308. return err
  309. }
  310. if !bl {
  311. err = global.GVA_REDIS.Set(ctx, key, 1, time.Hour*48).Err()
  312. return err
  313. } else {
  314. err = global.GVA_REDIS.Incr(ctx, key).Err()
  315. return err
  316. }
  317. }
  318. func (s *LogicalLog) NodeLogGetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (num int, err error) {
  319. node := code[:3]
  320. num, err = s.LogGetNum(ctx, date, gameId, node, status, taskType)
  321. return
  322. }
  323. func (s *LogicalLog) TypeLogGetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (num int, err error) {
  324. node := code[:5]
  325. num, err = s.LogGetNum(ctx, date, gameId, node, status, taskType)
  326. return
  327. }
  328. func (s *LogicalLog) CodeLogGetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (num int, err error) {
  329. num, err = s.LogGetNum(ctx, date, gameId, code, status, taskType)
  330. return
  331. }
  332. func (s *LogicalLog) LogGetNum(ctx context.Context, date string, gameId int, code string, status string, taskType int) (num int, err error) {
  333. strGameId := strconv.Itoa(gameId)
  334. nodeGameCacheKey := fmt.Sprintf(NodeGameCacheKey, date)
  335. key := nodeGameCacheKey + ":" + strGameId + ":" + strconv.Itoa(taskType) + ":" + status + ":" + code
  336. num, err = s.GetCacheNum(ctx, key)
  337. return
  338. }
  339. func (s *LogicalLog) GetCacheNum(ctx context.Context, key string) (num int, err error) {
  340. num, err = global.GVA_REDIS.Get(ctx, key).Int()
  341. if err != nil {
  342. if err == redis.Nil {
  343. return 0, nil
  344. }
  345. return 0, err
  346. }
  347. return num, err
  348. }
  349. func (s *LogicalLog) SetGameCache(ctx context.Context, date string, gameId int) (err error) {
  350. key := fmt.Sprintf(GameCacheKey, date)
  351. _, err = global.GVA_REDIS.HSet(ctx, key, gameId, 1).Result()
  352. if err != nil {
  353. return err
  354. }
  355. return err
  356. }
  357. func (s *LogicalLog) GetGameCache(ctx context.Context, date string) (mps map[string]string, err error) {
  358. key := fmt.Sprintf(GameCacheKey, date)
  359. mps, err = global.GVA_REDIS.HGetAll(ctx, key).Result()
  360. if err != nil {
  361. return mps, err
  362. }
  363. return mps, err
  364. }
  365. func (s *LogicalLog) SetAccountGameIdCache(ctx context.Context, date string, logInfo *log.Loging) (err error) {
  366. key := fmt.Sprintf(logUuidAccountGameId, date)
  367. value, _ := json.Marshal(logInfo)
  368. _, err = global.GVA_REDIS.HGet(ctx, key, logInfo.LogUuid).Result()
  369. if err != nil {
  370. if err == redis.Nil {
  371. _, err = global.GVA_REDIS.HSet(ctx, key, logInfo.LogUuid, value).Result()
  372. if err != nil {
  373. return err
  374. }
  375. } else {
  376. return err
  377. }
  378. }
  379. return err
  380. }
  381. func (s *LogicalLog) GetAccountGameIdCache(ctx context.Context, date string, uuid string) (logInfo log.Loging, err error) {
  382. key := fmt.Sprintf(logUuidAccountGameId, date)
  383. data, err := global.GVA_REDIS.HGet(ctx, key, uuid).Result()
  384. if err != nil {
  385. if err == redis.Nil {
  386. logInfo, err = s.getLogByUuid(uuid)
  387. return logInfo, nil
  388. }
  389. return logInfo, err
  390. }
  391. err = json.Unmarshal([]byte(data), &logInfo)
  392. return
  393. }
  394. func (s *LogicalLog) DelAccountGameIdCache(ctx context.Context, date string, uuid string) (err error) {
  395. key := fmt.Sprintf(logUuidAccountGameId, date)
  396. _, err = global.GVA_REDIS.HDel(ctx, key, uuid).Result()
  397. return
  398. }
  399. func (s *LogicalLog) GetGameStatisticsCacheKeys(ctx context.Context, date string, gameId int, taskType int) (keys []string, err error) {
  400. strGameId := strconv.Itoa(gameId)
  401. nodeGameCacheKey := fmt.Sprintf(NodeGameCacheKey, date)
  402. key := nodeGameCacheKey + ":" + strGameId + ":" + strconv.Itoa(taskType) + ":*"
  403. keys, err = global.GVA_REDIS.Keys(ctx, key).Result()
  404. return
  405. }
  406. func (s *LogicalLog) ByCacheKeyGetEndNode(key string) (code string) {
  407. str := strings.Split(key, ":")
  408. code = str[len(str)-1]
  409. return
  410. }
  411. func (s *LogicalLog) SetUuidCodeCache(ctx context.Context, date string, uuid string, code int, gameId int) (err error) {
  412. key := fmt.Sprintf(reportPointsKey, date) + strconv.Itoa(gameId) + ":" + uuid
  413. _, err = global.GVA_REDIS.HSet(ctx, key, code, 1).Result()
  414. if err != nil {
  415. return err
  416. }
  417. return err
  418. }
  419. func (s *LogicalLog) ExistsUuidCodeCache(ctx context.Context, date string, uuid string, code int, gameId int) (b bool, err error) {
  420. key := fmt.Sprintf(reportPointsKey, date) + strconv.Itoa(gameId) + ":" + uuid
  421. b, err = s.ExistsHsKey(ctx, key, strconv.Itoa(code))
  422. if err != nil {
  423. return false, err
  424. }
  425. return
  426. }
  427. func (s *LogicalLog) GetCacheKeys(ctx context.Context, keys string) (key []string, err error) {
  428. key, err = global.GVA_REDIS.Keys(ctx, keys).Result()
  429. return
  430. }
  431. func (s *LogicalLog) DelStatisticsNumCache(ctx context.Context, date string, gameId int) (err error) {
  432. key1FailStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "1" + ":" + FailStatus + ":*"
  433. key1NoLogStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "1" + ":" + NoLogStatus + ":*"
  434. key1OkStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "1" + ":" + OkStatus + ":*"
  435. key0FailStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "0" + ":" + FailStatus + ":*"
  436. key0NoLogStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "0" + ":" + NoLogStatus + ":*"
  437. key0OkStatus := fmt.Sprintf(NodeGameCacheKey, date) + ":" + strconv.Itoa(gameId) + ":" + "0" + ":" + OkStatus + ":*"
  438. fmt.Println(key1FailStatus)
  439. fmt.Println(key1NoLogStatus)
  440. fmt.Println(key1OkStatus)
  441. fmt.Println(key0FailStatus)
  442. fmt.Println(key0NoLogStatus)
  443. fmt.Println(key0OkStatus)
  444. err = s.cache.DelBatheCache(ctx, key1FailStatus)
  445. err = s.cache.DelBatheCache(ctx, key1NoLogStatus)
  446. err = s.cache.DelBatheCache(ctx, key1OkStatus)
  447. err = s.cache.DelBatheCache(ctx, key0FailStatus)
  448. err = s.cache.DelBatheCache(ctx, key0NoLogStatus)
  449. err = s.cache.DelBatheCache(ctx, key0OkStatus)
  450. if err != nil {
  451. return err
  452. }
  453. return
  454. }
  455. func (s *LogicalLog) DelUuidCodeCache(ctx context.Context, date string, gameId int) (err error) {
  456. key := fmt.Sprintf(reportPointsKey, date) + strconv.Itoa(gameId) + ":*"
  457. keys, err := global.GVA_REDIS.Keys(ctx, key).Result()
  458. for _, v := range keys {
  459. err = s.cache.DelBatheHsCache(ctx, v)
  460. }
  461. if err != nil {
  462. return err
  463. }
  464. return err
  465. }
  466. // 统计电脑使用的记录
  467. func (s *LogicalLog) SetComputerCache(ctx context.Context, date string, pcCode, operator string) (err error) {
  468. key := fmt.Sprintf(ComputerCacheKey, date)
  469. _, err = global.GVA_REDIS.HSet(ctx, key, pcCode, operator).Result()
  470. if err != nil {
  471. return err
  472. }
  473. return err
  474. }
  475. // 获取统计电脑使用的记录
  476. func (s *LogicalLog) GetComputerCache(ctx context.Context, date string) (mps map[string]string, err error) {
  477. key := fmt.Sprintf(ComputerCacheKey, date)
  478. mps, err = global.GVA_REDIS.HGetAll(ctx, key).Result()
  479. if err != nil {
  480. return mps, err
  481. }
  482. return mps, err
  483. }
  484. // 统计电脑拉取账号的数量
  485. func (s *LogicalLog) SetComputerPullAccountNumCache(ctx context.Context, date string, pcCode string, gameId int) (err error) {
  486. key := fmt.Sprintf(ComputerPullAccountCacheKey, date, pcCode) + strconv.Itoa(gameId)
  487. err = s.cache.SetCacheNum(ctx, key)
  488. return err
  489. }
  490. // 获取统计电脑拉取账号的数量
  491. func (s *LogicalLog) GetComputerPullAccountNumCache(ctx context.Context, date string, pcCode string) (mps map[string]int, err error) {
  492. key := fmt.Sprintf(ComputerPullAccountCacheKey, date, pcCode)
  493. mps, err = s.GetByPcCodeGameNumCache(ctx, key)
  494. if len(mps) == 0 {
  495. return
  496. }
  497. return
  498. }
  499. // 统计电脑进入主线的数量
  500. func (s *LogicalLog) SetComputerEnterMainNumCache(ctx context.Context, date string, pcCode string, gameId int) (err error) {
  501. key := fmt.Sprintf(ComputerEnterMainCacheKey, date, pcCode) + strconv.Itoa(gameId)
  502. err = s.cache.SetCacheNum(ctx, key)
  503. return err
  504. }
  505. // 获取统计电脑进入主线的数量
  506. func (s *LogicalLog) GetComputerEnterMainNumCache(ctx context.Context, date string, pcCode string) (mps map[string]int, err error) {
  507. key := fmt.Sprintf(ComputerEnterMainCacheKey, date, pcCode)
  508. mps, err = s.GetByPcCodeGameNumCache(ctx, key)
  509. if len(mps) == 0 {
  510. return
  511. }
  512. return
  513. }
  514. // 统计电脑任务成功的数量
  515. func (s *LogicalLog) SetComputerTaskSuccessNumCache(ctx context.Context, date string, pcCode string, gameId int) (err error) {
  516. key := fmt.Sprintf(ComputerTaskSuccessCacheKey, date, pcCode) + strconv.Itoa(gameId)
  517. err = s.cache.SetCacheNum(ctx, key)
  518. return err
  519. }
  520. // 获取统计电脑任务成功的数量
  521. func (s *LogicalLog) GetComputerTaskSuccessNumCache(ctx context.Context, date string, pcCode string) (mps map[string]int, err error) {
  522. key := fmt.Sprintf(ComputerTaskSuccessCacheKey, date, pcCode)
  523. mps, err = s.GetByPcCodeGameNumCache(ctx, key)
  524. if len(mps) == 0 {
  525. return
  526. }
  527. return
  528. }
  529. // 通过电脑code获取游戏缓存的数量
  530. func (s *LogicalLog) GetByPcCodeGameNumCache(ctx context.Context, key string) (mps map[string]int, err error) {
  531. key += "*"
  532. data, err := s.cache.GetCacheKeys(ctx, key)
  533. if len(data) == 0 {
  534. return
  535. }
  536. mps = make(map[string]int)
  537. for _, k := range data {
  538. gameId := s.ByCacheKeyGetEndNode(k)
  539. num, _ := s.cache.GetCacheNum(ctx, k)
  540. mps[gameId] = num
  541. }
  542. return
  543. }
  544. // 统计游戏付费效率的预埋数据
  545. func (s *LogicalLog) StatisticsFeeRateData(ctx context.Context, gameId int, logUuid string) {
  546. key := fmt.Sprintf(GameFeeRateCacheKey, s.CurrentDate(), gameId)
  547. z := &redis.Z{
  548. Member: logUuid,
  549. Score: float64(time.Now().UnixNano() / 1e6),
  550. }
  551. global.GVA_REDIS.ZAdd(ctx, key, z)
  552. }
  553. // 获取统计游戏付费效率的数量
  554. func (s *LogicalLog) GetStatisticsFeeRate(ctx context.Context, gameId int) (num int) {
  555. key := fmt.Sprintf(GameFeeRateCacheKey, s.CurrentDate(), gameId)
  556. z, err := global.GVA_REDIS.ZRangeWithScores(ctx, key, -1, -1).Result()
  557. if err != nil {
  558. return
  559. }
  560. if len(z) == 0 {
  561. return
  562. }
  563. end := z[0].Score
  564. start := z[0].Score - 30*60*1000
  565. op := redis.ZRangeBy{
  566. Min: strconv.Itoa(int(start)),
  567. Max: strconv.Itoa(int(end)),
  568. }
  569. i, err := global.GVA_REDIS.ZRangeByScore(ctx, key, &op).Result()
  570. if err != nil {
  571. return
  572. }
  573. num = len(i)
  574. return
  575. }
  576. // 获取统计单台电脑单个游戏付费效率的预埋数据
  577. func (s *LogicalLog) GetStatisticsPcFeeRate(ctx context.Context, pcCode string, gameId int) (num int) {
  578. key := fmt.Sprintf(GamePcFeeRateCacheKey, s.CurrentDate(), gameId, pcCode)
  579. z, err := global.GVA_REDIS.ZRangeWithScores(ctx, key, -1, -1).Result()
  580. if err != nil {
  581. return
  582. }
  583. if len(z) == 0 {
  584. return
  585. }
  586. end := z[0].Score
  587. start := z[0].Score - 30*60*1000
  588. op := redis.ZRangeBy{
  589. Min: strconv.Itoa(int(start)),
  590. Max: strconv.Itoa(int(end)),
  591. }
  592. i, err := global.GVA_REDIS.ZRangeByScore(ctx, key, &op).Result()
  593. if err != nil {
  594. return
  595. }
  596. num = len(i)
  597. return
  598. }
  599. // 统计单台电脑单个游戏付费效率的预埋数据
  600. func (s *LogicalLog) StatisticsPcFeeRateData(ctx context.Context, pcCode string, logUuid string, gameId int) {
  601. key := fmt.Sprintf(GamePcFeeRateCacheKey, s.CurrentDate(), gameId, pcCode)
  602. z := &redis.Z{
  603. Member: logUuid,
  604. Score: float64(time.Now().UnixNano() / 1e6),
  605. }
  606. global.GVA_REDIS.ZAdd(ctx, key, z)
  607. }
  608. // 统计电脑效率的预埋数据
  609. func (s *LogicalLog) StatisticsComputerRateData(ctx context.Context, pcCode string, gameId int) (err error) {
  610. hour := time.Now().Hour()
  611. key := fmt.Sprintf(GameComputerRateCacheKey, s.CurrentDate(), pcCode)
  612. key = key + strconv.Itoa(hour)
  613. err = s.cache.SetCacheStr(ctx, key, gameId)
  614. return
  615. }
  616. // 统计电脑效率的预埋数据
  617. func (s *LogicalLog) GetStatisticsComputerRate(ctx context.Context, pcCode string) (num int) {
  618. key := fmt.Sprintf(GameComputerRateCacheKey, s.CurrentDate(), pcCode)
  619. key = key + "*"
  620. data, _ := s.cache.GetCacheKeys(ctx, key)
  621. h := map[string]int{
  622. "2": 1,
  623. "3": 1,
  624. "4": 1,
  625. "5": 1,
  626. "6": 1,
  627. "7": 1,
  628. "8": 1,
  629. }
  630. var i = 0
  631. for _, v := range data {
  632. key := strings.Split(v, ":")
  633. hr := key[len(key)-1:][0]
  634. if _, ok := h[hr]; ok {
  635. continue
  636. }
  637. i++
  638. }
  639. hour := time.Now().Hour()
  640. //num = hour + 1 - len(data)
  641. if hour >= 8 {
  642. num = hour + 1 - 7 - i
  643. } else {
  644. notCalculated := hour - 2
  645. num = hour + 1 - notCalculated - i
  646. }
  647. return
  648. }
  649. // 请求机房任务数据
  650. func (s *LogicalLog) RequestJfRoom() (result []byte, err error) {
  651. today := time.Now().Format("2006-01-02")
  652. jfurl := "http://xjf.lianyou.fun:8099/v1/task_statistics"
  653. jfparams := map[string]string{
  654. "query": "date:" + today + ",type:machine",
  655. }
  656. result, err = utils.HttpGet(jfurl, jfparams)
  657. return
  658. }
  659. // 请求机房数据接口数据
  660. func (s *LogicalLog) RequestTaskData() (result []byte, err error) {
  661. today := time.Now().Format("2006-01-02")
  662. jfurl := "http://xjf.lianyou.fun:8118/data/taskDateLog"
  663. jfparams := map[string]string{
  664. "date": today,
  665. }
  666. result, err = utils.HttpGet(jfurl, jfparams)
  667. return
  668. }
  669. // 统计在线电脑数据
  670. func (s *LogicalLog) SetOnlineComputerNumCache(ctx context.Context, date string, pcCode string, operator string) (err error) {
  671. key := fmt.Sprintf(OnLineComputerNum, date)
  672. key += pcCode
  673. err = s.cache.SetCacheStr(ctx, key, operator)
  674. return err
  675. }
  676. // 获取在线电脑数据
  677. func (s *LogicalLog) GetOnlineComputerNumCache(ctx context.Context, date string) (mps map[string]string, err error) {
  678. key := fmt.Sprintf(OnLineComputerNum, date)
  679. mps, err = s.GetAllOnlineComputerNumCache(ctx, key)
  680. if len(mps) == 0 {
  681. return
  682. }
  683. return
  684. }
  685. // 获取所有在线电脑
  686. func (s *LogicalLog) GetAllOnlineComputerNumCache(ctx context.Context, key string) (mps map[string]string, err error) {
  687. key += "*"
  688. data, err := s.cache.GetCacheKeys(ctx, key)
  689. if len(data) == 0 {
  690. return
  691. }
  692. mps = make(map[string]string)
  693. for _, k := range data {
  694. pcCode := s.ByCacheKeyGetEndNode(k)
  695. operator, _ := s.cache.GetCacheStr(ctx, k)
  696. mps[pcCode] = operator
  697. }
  698. return
  699. }
  700. // 获取电脑2小时内上报的次数
  701. func (s *LogicalLog) GetPcReportingLog(ctx context.Context, pcCode string) (num int) {
  702. key := fmt.Sprintf(PcReportingLog, s.CurrentDate(), pcCode)
  703. z, err := global.GVA_REDIS.ZRangeWithScores(ctx, key, -1, -1).Result()
  704. if err != nil {
  705. return
  706. }
  707. if len(z) == 0 {
  708. return
  709. }
  710. end := time.Now().UnixNano()/1e6 + 60*1000*2
  711. start := end - (60*60*1000 + 60*1000*4)
  712. op := redis.ZRangeBy{
  713. Min: strconv.Itoa(int(start)),
  714. Max: strconv.Itoa(int(end)),
  715. }
  716. i, err := global.GVA_REDIS.ZRangeByScore(ctx, key, &op).Result()
  717. if err != nil {
  718. return
  719. }
  720. num = len(i)
  721. return
  722. }
  723. // 获取电脑上报的次数
  724. func (s *LogicalLog) CheckPcReportingLog(ctx context.Context, pcCode string, timeInterval int64) (num int) {
  725. key := fmt.Sprintf(PcReportingLog, s.CurrentDate(), pcCode)
  726. z, err := global.GVA_REDIS.ZRangeWithScores(ctx, key, -1, -1).Result()
  727. if err != nil {
  728. return
  729. }
  730. if len(z) == 0 {
  731. return
  732. }
  733. end := time.Now().UnixNano()/1e6 + 60*1000*2
  734. start := end - timeInterval
  735. op := redis.ZRangeBy{
  736. Min: strconv.Itoa(int(start)),
  737. Max: strconv.Itoa(int(end)),
  738. }
  739. i, err := global.GVA_REDIS.ZRangeByScore(ctx, key, &op).Result()
  740. if err != nil {
  741. return
  742. }
  743. num = len(i)
  744. return
  745. }
  746. // 添加电脑定时上报记录
  747. func (s *LogicalLog) SetPcReportingLog(ctx context.Context, pcCode string, operator string) {
  748. key := fmt.Sprintf(PcReportingLog, s.CurrentDate(), pcCode)
  749. z := &redis.Z{
  750. Member: operator,
  751. Score: float64(time.Now().UnixNano() / 1e6),
  752. }
  753. global.GVA_REDIS.ZAdd(ctx, key, z)
  754. }
  755. // 删除hash缓存数据
  756. func (s *LogicalLog) DelHashKey(ctx context.Context, date string) {
  757. gameKeys := fmt.Sprintf(GameCacheKey, date)
  758. data, _ := global.GVA_REDIS.HKeys(ctx, gameKeys).Result()
  759. global.GVA_REDIS.HDel(ctx, gameKeys, data...)
  760. logUuidAccountGameId := fmt.Sprintf(logUuidAccountGameId, date)
  761. logUuid, _ := global.GVA_REDIS.HKeys(ctx, logUuidAccountGameId).Result()
  762. global.GVA_REDIS.HDel(ctx, logUuidAccountGameId, logUuid...)
  763. taskStatisticsKey := fmt.Sprintf("%s:taskStatistics", date)
  764. taskStatistics, _ := global.GVA_REDIS.HKeys(ctx, taskStatisticsKey).Result()
  765. global.GVA_REDIS.HDel(ctx, taskStatisticsKey, taskStatistics...)
  766. computerListKey := fmt.Sprintf(ComputerCacheKey, date)
  767. computerListKeys, _ := global.GVA_REDIS.HKeys(ctx, computerListKey).Result()
  768. global.GVA_REDIS.HDel(ctx, computerListKey, computerListKeys...)
  769. }
  770. // 删除ZSet缓存数据
  771. func (s *LogicalLog) DelZSetKey(ctx context.Context, date string) {
  772. gamePcKey := fmt.Sprintf("%s:gamePc:gameFeeRate*", date)
  773. gameKey := fmt.Sprintf("%s:game:gameFeeRate*", date)
  774. pcReportingKey := fmt.Sprintf("%s:pc:Reporting:*", date)
  775. beginTime, _ := time.ParseInLocation("2006-01-02", date, time.Local)
  776. beginTimeI := strconv.Itoa(int(beginTime.Unix() * 1000))
  777. endTime := strconv.Itoa(int(beginTime.Unix()*1000 + 24*60*60*1000))
  778. gamePcKeys, _ := global.GVA_REDIS.Keys(ctx, gamePcKey).Result()
  779. gameKeys, _ := global.GVA_REDIS.Keys(ctx, gameKey).Result()
  780. pcReportingKeys, _ := global.GVA_REDIS.Keys(ctx, pcReportingKey).Result()
  781. for _, k := range gamePcKeys {
  782. global.GVA_REDIS.ZRemRangeByScore(ctx, k, beginTimeI, endTime)
  783. }
  784. for _, k := range gameKeys {
  785. global.GVA_REDIS.ZRemRangeByScore(ctx, k, beginTimeI, endTime)
  786. }
  787. for _, k := range pcReportingKeys {
  788. global.GVA_REDIS.ZRemRangeByScore(ctx, k, beginTimeI, endTime)
  789. }
  790. }
  791. // 删除hashUuid缓存数据
  792. func (s *LogicalLog) DelHashUuidKey(ctx context.Context, date string) {
  793. gameIds, _ := s.GetGameCache(ctx, date)
  794. for id, _ := range gameIds {
  795. gamekeys := fmt.Sprintf("%s:logUuid:%s:*", date, id)
  796. data, _ := global.GVA_REDIS.Keys(ctx, gamekeys).Result()
  797. for _, hkey := range data {
  798. value, _ := global.GVA_REDIS.HKeys(ctx, hkey).Result()
  799. global.GVA_REDIS.HDel(ctx, hkey, value...)
  800. }
  801. }
  802. }
  803. // 记录扫码订单号信息
  804. func (s *LogicalLog) AddCodeLog(request request.AddLogRequest, status int) {
  805. if request.Remarks == "" {
  806. return
  807. }
  808. logSC := new(log.LogScanningCode)
  809. logSC.GameId = request.GameId
  810. logSC.LogUuid = request.LogUuid
  811. logSC.TaskType = request.TaskType
  812. logSC.Status = status
  813. if logSC.Status == 0 {
  814. logSC.Status = -1
  815. }
  816. codeSupplier := strings.Split(request.Remarks, "|")
  817. logSC.OrderNum = codeSupplier[0]
  818. logSC.Supplier = codeSupplier[1]
  819. logSC.CreateDate = time.Now()
  820. err := global.GVA_DB.Omit("create_time").Create(&logSC).Error
  821. if err != nil {
  822. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  823. }
  824. }
  825. // 记录ip信息
  826. func (s *LogicalLog) AddIpLog(request request.AddLogRequest) {
  827. if request.SimulatorIp == "" {
  828. return
  829. }
  830. logSC := new(log.IpLog)
  831. logSC.GameId = request.GameId
  832. logSC.LogUuid = request.LogUuid
  833. logSC.Ip = request.SimulatorIp
  834. logSC.Account = request.Account
  835. logSC.PcCode = request.PcCode
  836. logSC.CreateDate = time.Now().Format("2006-01-02")
  837. err := global.GVA_DB.Omit("create_time").Create(&logSC).Error
  838. if err != nil {
  839. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  840. }
  841. }
  842. // 进入游戏ip信息
  843. func (s *LogicalLog) UpdateIpLogStatus(logUuid string, createDate string) {
  844. err := global.GVA_DB.Table("ip_log").Where("create_date = ?", createDate).Where("log_uuid = ?", logUuid).Update("status", 2).Error
  845. if err != nil {
  846. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  847. }
  848. }
  849. // 记录设备信息
  850. func (s *LogicalLog) AddDeviceLog(request request.AddLogRequest) {
  851. logSC := new(log.DeviceLog)
  852. logSC.GameId = request.GameId
  853. logSC.LogUuid = request.LogUuid
  854. logSC.Account = request.Account
  855. logSC.DeviceId = request.DeviceId
  856. logSC.DeviceImei = request.DeviceImei
  857. logSC.DeviceIp = request.SimulatorIp
  858. logSC.DeviceMac = request.DeviceMac
  859. logSC.DeviceManufacturer = request.DeviceManufacturer
  860. logSC.DeviceModel = request.DeviceModel
  861. logSC.DeviceSdk = request.DeviceSdk
  862. logSC.DeviceNumber = request.DeviceNumber
  863. logSC.SimulatorCode = request.SimulatorCode
  864. logSC.IsErr = -1
  865. logSC.ErrStatus = 1
  866. logSC.DeviceHex = s.DeviceHexLog(request)
  867. logSC.AccountHex = s.AccountHexLog(request)
  868. logSC.CreateDate = time.Now().Format("2006-01-02")
  869. logSC.PcCode = request.PcCode
  870. logSC.SimulatorIpCity = request.SimulatorIpCity
  871. ctx := context.Background()
  872. if s.CheckDeviceLogIsSave(logSC) {
  873. logSC.IsErr = 1
  874. logSC.ErrStatus = 4
  875. logSC.CreateDate = time.Now().Format("2006-01-02")
  876. err := global.GVA_DB.Omit("create_time").Create(&logSC).Error
  877. if err != nil {
  878. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  879. }
  880. return
  881. }
  882. var deviceLogs []log.DeviceErr
  883. if request.TaskType == 1 {
  884. global.GVA_DB.Table("game_account").Where("account = ?", request.Account).Where("game_id = ?", request.GameId).Order("id desc").Limit(1).Find(&deviceLogs)
  885. if len(deviceLogs) != 0 {
  886. if deviceLogs[0].AccountHex != "" && deviceLogs[0].AccountHex != logSC.AccountHex {
  887. logSC.IsErr = 1
  888. logSC.ErrStatus = 3
  889. gameDeviceErrKey := fmt.Sprintf(GameDeviceErrKey, logSC.CreateDate, request.GameId)
  890. s.cache.SetCacheNum(ctx, gameDeviceErrKey)
  891. }
  892. }
  893. } else {
  894. if !errors.Is(global.GVA_DB.Table("game_account").Where("game_id = ?", request.GameId).Where("account != ?", request.Account).Where("device_hex = ?", logSC.DeviceHex).Order("id desc").Limit(10).Find(&deviceLogs).Error, gorm.ErrRecordNotFound) {
  895. if len(deviceLogs) > 2 {
  896. logSC.IsErr = 1
  897. logSC.ErrStatus = 2
  898. gameDeviceAccountErrKey := fmt.Sprintf(GameDeviceAccountErrKey, logSC.CreateDate, request.GameId)
  899. s.cache.SetCacheNum(ctx, gameDeviceAccountErrKey)
  900. }
  901. }
  902. }
  903. logSC.CreateDate = time.Now().Format("2006-01-02")
  904. err := global.GVA_DB.Omit("create_time").Create(&logSC).Error
  905. if err != nil {
  906. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  907. }
  908. if logSC.ErrStatus == 3 || logSC.ErrStatus == 2 {
  909. s.AddDeviceErr(logSC, deviceLogs)
  910. }
  911. }
  912. func (s *LogicalLog) AddDeviceErr(deviceLog *log.DeviceLog, deviceErrs []log.DeviceErr) {
  913. var deviceErr = log.DeviceErr{}
  914. deviceErr.GameId = deviceLog.GameId
  915. deviceErr.ScriptDeviceId = deviceLog.ScriptDeviceId
  916. deviceErr.Account = deviceLog.Account
  917. deviceErr.DeviceId = deviceLog.DeviceId
  918. deviceErr.DeviceImei = deviceLog.DeviceImei
  919. deviceErr.DeviceMac = deviceLog.DeviceMac
  920. deviceErr.DeviceManufacturer = deviceLog.DeviceManufacturer
  921. deviceErr.DeviceModel = deviceLog.DeviceModel
  922. deviceErr.DeviceSdk = deviceLog.DeviceSdk
  923. deviceErr.DeviceNumber = deviceLog.DeviceNumber
  924. deviceErr.AccountHex = deviceLog.AccountHex
  925. deviceErr.DeviceHex = deviceLog.DeviceHex
  926. deviceErr.CreateTime = time.Now()
  927. deviceErrs = append(deviceErrs, deviceErr)
  928. for k, _ := range deviceErrs {
  929. deviceErrs[k].DeviceLogId = deviceLog.Id
  930. deviceErrs[k].CreateDate = time.Now()
  931. }
  932. err := global.GVA_DB.Table("device_err").Omit("id").Create(&deviceErrs).Error
  933. if err != nil {
  934. global.GVA_LOG.Error("create AddAccount fail", zap.Error(err))
  935. }
  936. }
  937. func (s *LogicalLog) CheckDeviceLogIsSave(deviceLog *log.DeviceLog) bool {
  938. return deviceLog.DeviceManufacturer == "" || deviceLog.DeviceModel == "" || deviceLog.DeviceImei == "" || deviceLog.DeviceSdk == "" || deviceLog.DeviceMac == "" || deviceLog.DeviceNumber == "" || deviceLog.DeviceId == ""
  939. }
  940. func (s *LogicalLog) DeviceHexLog(request request.AddLogRequest) string {
  941. logSC := new(log.DeviceHex)
  942. logSC.GameId = request.GameId
  943. logSC.DeviceId = request.DeviceId
  944. logSC.DeviceImei = request.DeviceImei
  945. logSC.DeviceMac = request.DeviceMac
  946. logSC.DeviceManufacturer = request.DeviceManufacturer
  947. logSC.DeviceModel = request.DeviceModel
  948. logSC.DeviceSdk = request.DeviceSdk
  949. logSC.DeviceNumber = request.DeviceNumber
  950. dh, _ := json.Marshal(logSC)
  951. return utils.ByteToHex(dh)
  952. }
  953. func (s *LogicalLog) AccountHexLog(request request.AddLogRequest) string {
  954. logSC := new(log.AccountHex)
  955. logSC.GameId = request.GameId
  956. logSC.DeviceId = request.DeviceId
  957. logSC.DeviceImei = request.DeviceImei
  958. logSC.DeviceMac = request.DeviceMac
  959. logSC.DeviceManufacturer = request.DeviceManufacturer
  960. logSC.DeviceModel = request.DeviceModel
  961. logSC.DeviceSdk = request.DeviceSdk
  962. logSC.DeviceNumber = request.DeviceNumber
  963. logSC.Account = request.Account
  964. dh, _ := json.Marshal(logSC)
  965. return utils.ByteToHex(dh)
  966. }
  967. // 修改设备信息状态
  968. func (s *LogicalLog) UpdateDeviceLogStatus(logUuid string, createDate string) {
  969. err := global.GVA_DB.Table("device_log").Where("create_date = ?", createDate).Where("log_uuid = ?", logUuid).Update("status", 1).Error
  970. if err != nil {
  971. global.GVA_LOG.Error("update UpdateDeviceLogStatus fail", zap.Error(err))
  972. }
  973. }
  974. // 修改设备信息状态
  975. func (s *LogicalLog) UpdateDeviceLogScriptId(logUuid string, scriptDeviceId string, createDate string) {
  976. err := global.GVA_DB.Table("device_log").Where("create_date = ?", createDate).Where("log_uuid = ?", logUuid).Update("script_device_id", scriptDeviceId).Update("status", 1).Error
  977. if err != nil {
  978. global.GVA_LOG.Error("create LogScanningCode fail", zap.Error(err))
  979. }
  980. }
  981. func (s *LogicalLog) AddAccount(request request.AddLogRequest, deviceLog log.DeviceLog) {
  982. gameAccount := new(log.GameAccount)
  983. gameAccount.GameId = request.GameId
  984. gameAccount.ScriptDeviceId = request.ScriptDeviceId
  985. gameAccount.Account = request.Account
  986. if deviceLog.ErrStatus != 4 {
  987. gameAccount.DeviceId = deviceLog.DeviceId
  988. gameAccount.DeviceImei = deviceLog.DeviceImei
  989. gameAccount.DeviceMac = deviceLog.DeviceMac
  990. gameAccount.DeviceManufacturer = deviceLog.DeviceManufacturer
  991. gameAccount.DeviceModel = deviceLog.DeviceModel
  992. gameAccount.DeviceSdk = deviceLog.DeviceSdk
  993. gameAccount.DeviceNumber = deviceLog.DeviceNumber
  994. gameAccount.AccountHex = deviceLog.AccountHex
  995. gameAccount.DeviceHex = deviceLog.DeviceHex
  996. }
  997. err := global.GVA_DB.Omit("create_time", "update_time", "use_num").Create(&gameAccount).Error
  998. if err != nil {
  999. global.GVA_LOG.Error("create AddAccount fail", zap.Error(err))
  1000. }
  1001. }
  1002. func (s *LogicalLog) AddScriptDeviceErr(gameId int, account, firstDeviceId, currentDeviceId string, firstAccount string, firstGameId int, status uint, pcCode string, operator string) {
  1003. scriptDeviceErr := new(log.ScriptDeviceErr)
  1004. scriptDeviceErr.GameId = firstGameId
  1005. scriptDeviceErr.Account = firstAccount
  1006. scriptDeviceErr.CurrentAccount = account
  1007. scriptDeviceErr.CurrentGameId = gameId
  1008. scriptDeviceErr.FirstDeviceId = firstDeviceId
  1009. scriptDeviceErr.CurrentDeviceId = currentDeviceId
  1010. scriptDeviceErr.CreateDate = time.Now().Format("2006-01-02")
  1011. scriptDeviceErr.Status = status
  1012. scriptDeviceErr.PcCode = pcCode
  1013. scriptDeviceErr.Operator = operator
  1014. err := global.GVA_DB.Omit("create_time").Create(&scriptDeviceErr).Error
  1015. if err != nil {
  1016. global.GVA_LOG.Error("create AddScriptDeviceErr fail", zap.Error(err))
  1017. }
  1018. }
  1019. func (s *LogicalLog) CheckDeviceId(request request.AddLogRequest) {
  1020. if request.ScriptDeviceId == "" {
  1021. // 通知异常逻辑
  1022. global.GVA_LOG.Error("get CheckDeviceId fail", zap.Error(errors.New("没有获取到设备id")))
  1023. return
  1024. }
  1025. date := time.Now().Format("2006-01-02")
  1026. s.UpdateDeviceLogScriptId(request.LogUuid, request.ScriptDeviceId, date)
  1027. var device log.DeviceLog
  1028. global.GVA_DB.Table("device_log").Where("create_date = ?", date).Where("log_uuid = ?", request.LogUuid).First(&device)
  1029. global.GVA_LOG.Warn("进入 CheckDeviceId")
  1030. if request.TaskType == 0 {
  1031. b, deviceLog := s.CheckDeviceIdErr(request.ScriptDeviceId, request.LogUuid, request.GameId)
  1032. // 有异常处理
  1033. if b && len(deviceLog) >= 3 {
  1034. s.AddScriptDeviceErr(request.GameId, request.Account, request.ScriptDeviceId, request.ScriptDeviceId, deviceLog[0].Account, deviceLog[0].GameId, 2, request.PcCode, request.Operator)
  1035. //ct := fmt.Sprintf("<font color=\"warning\">%s:%d, 相同设备id</font>", request.PcCode, request.GameId)
  1036. //s.SendDeviceMsg(ct, request.Operator)
  1037. }
  1038. s.AddAccount(request, device)
  1039. return
  1040. }
  1041. var gameAccount log.GameAccount
  1042. result := global.GVA_DB.Where("game_id = ?", request.GameId).Where("account = ?", request.Account).First(&gameAccount)
  1043. if result.Error != nil {
  1044. if result.Error == gorm.ErrRecordNotFound {
  1045. // 数据不存在,执行创建操作
  1046. s.AddAccount(request, device)
  1047. return
  1048. } else {
  1049. // 其他错误
  1050. global.GVA_LOG.Error("Select GameAccount fail", zap.Error(result.Error))
  1051. return
  1052. }
  1053. }
  1054. if gameAccount.ScriptDeviceId != request.ScriptDeviceId || device.ErrStatus == 3 || gameAccount.DeviceHex == "" {
  1055. s.AddScriptDeviceErr(request.GameId, request.Account, gameAccount.ScriptDeviceId, request.ScriptDeviceId, gameAccount.Account, gameAccount.GameId, 1, request.PcCode, request.Operator)
  1056. //ct := fmt.Sprintf("<font color=\"warning\">%s:%d, 设备id出现不同</font>", request.PcCode, request.GameId)
  1057. //s.SendDeviceMsg(ct, request.Operator)
  1058. gameAccount.ScriptDeviceId = request.ScriptDeviceId
  1059. if gameAccount.DeviceHex != device.DeviceHex {
  1060. gameAccount.DeviceId = device.DeviceId
  1061. gameAccount.DeviceImei = device.DeviceImei
  1062. gameAccount.DeviceMac = device.DeviceMac
  1063. gameAccount.DeviceManufacturer = device.DeviceManufacturer
  1064. gameAccount.DeviceModel = device.DeviceModel
  1065. gameAccount.DeviceSdk = device.DeviceSdk
  1066. gameAccount.DeviceNumber = device.DeviceNumber
  1067. gameAccount.AccountHex = device.AccountHex
  1068. gameAccount.DeviceHex = device.DeviceHex
  1069. }
  1070. }
  1071. gameAccount.UseNum += 1
  1072. global.GVA_DB.Save(&gameAccount)
  1073. }
  1074. func (s *LogicalLog) SendDeviceMsg(content string, operator string) {
  1075. c := "# 设备异常"
  1076. c += "\n"
  1077. ct := content
  1078. ct = c + ct
  1079. fmt.Println(ct)
  1080. mpsPerson, _ := s.Person.GetUserInfoData()
  1081. if operator != "" {
  1082. s.SendContent(ct, mpsPerson[operator].Url)
  1083. url := global.GVA_CONFIG.SendUrl.ComputerSendUrl
  1084. s.SendContent(ct, url)
  1085. var sendTextData SendTextMsg
  1086. sendTextData.MsgType = "text"
  1087. sendTextData.Text.MentionedMobileList = []string{mpsPerson[operator].MobilePhoneNumber}
  1088. _, _ = s.SendMsgData(url, sendTextData)
  1089. }
  1090. }
  1091. type SendMsg struct {
  1092. MsgType string `json:"msgtype"`
  1093. Markdown struct {
  1094. Content string `json:"content"`
  1095. } `json:"markdown"`
  1096. }
  1097. type SendTextMsg struct {
  1098. MsgType string `json:"msgtype"`
  1099. Text struct {
  1100. MentionedMobileList []string `json:"mentioned_mobile_list"`
  1101. } `json:"text"`
  1102. }
  1103. func (s *LogicalLog) SendContent(content, url string) {
  1104. var sendMsg SendMsg
  1105. sendMsg.MsgType = "markdown"
  1106. sendMsg.Markdown.Content = content
  1107. _, _ = s.SendMsgData(url, sendMsg)
  1108. }
  1109. func (s *LogicalLog) SendMsgData(url string, params interface{}) (result []byte, err error) {
  1110. result, err = utils.HttpPost(url, params)
  1111. return
  1112. }
  1113. func (s *LogicalLog) CheckDeviceIdErr(scriptDeviceId string, uuid string, gameId int) (bool, []log.GameAccount) {
  1114. var deviceLog []log.GameAccount
  1115. // result := global.GVA_DB.Where("create_date <= ?", time.Now().Format("2006-01-02")).Where("create_date >= ?", time.Now().Add(-time.Hour*24).Format("2006-01-02")).Where("game_id = ?", gameId).Where("script_device_id = ?", scriptDeviceId).Find(&deviceLog)
  1116. result := global.GVA_DB.Where("game_id = ?", gameId).Where("script_device_id = ?", scriptDeviceId).Find(&deviceLog)
  1117. if result.Error != nil {
  1118. if result.Error == gorm.ErrRecordNotFound {
  1119. return false, deviceLog
  1120. }
  1121. }
  1122. return true, deviceLog
  1123. }
  1124. func (s *LogicalLog) AddDeviceErrLog(request request.AddLogRequest, st uint) {
  1125. if request.Err == "" {
  1126. return
  1127. }
  1128. ctx := context.Background()
  1129. key := fmt.Sprintf(GameDeviceUuidKey, time.Now().Format("2006-01-02"), request.LogUuid)
  1130. status, _ := s.ExistsKey(ctx, key)
  1131. if status {
  1132. return
  1133. }
  1134. errLog := new(log.DeviceErrLog)
  1135. errLog.GameId = request.GameId
  1136. errLog.CreateDate = time.Now()
  1137. errLog.CreateTime = time.Now()
  1138. errLog.Err = request.Err
  1139. errLog.PcCode = request.PcCode
  1140. content, _ := json.Marshal(request)
  1141. errLog.Content = string(content)
  1142. errLog.Status = st
  1143. err := errLog.Create()
  1144. if err != nil {
  1145. global.GVA_LOG.Error("create AddAccount fail", zap.Error(err))
  1146. return
  1147. }
  1148. global.GVA_REDIS.Set(ctx, key, 1, time.Hour)
  1149. }