web_gmmsg.go 43 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621
  1. package msg
  2. import (
  3. "database/sql"
  4. "encoding/base64"
  5. "github.com/gin-gonic/gin"
  6. "github.com/xuri/excelize/v2"
  7. "math/rand"
  8. "net/http"
  9. "rocommon"
  10. "rocommon/service"
  11. "rocommon/socket/mysql"
  12. "rocommon/util"
  13. "roserver/baseserver/model"
  14. dbmodel "roserver/db/model"
  15. selfmodel "roserver/game/model"
  16. gmweb "roserver/gmweb/model"
  17. "roserver/serverproto"
  18. "strconv"
  19. "strings"
  20. "time"
  21. )
  22. type WebBriefInfo struct {
  23. Uid uint64
  24. NickName string
  25. BaseLevel int32
  26. CreateDate string
  27. LastLoginDate string
  28. BanDate string
  29. MapLevel int32
  30. FightPower uint32
  31. ActiveCode string
  32. OpenId string
  33. Serverid int //所属区服
  34. }
  35. type WebUserDetailInfo struct {
  36. WebBriefInfo
  37. Rmb uint32
  38. Zeny uint64
  39. ArenaScore uint32
  40. TowerLevel uint32
  41. HeroData []*serverproto.HeroData
  42. }
  43. type WebUserChatMsgInfo struct {
  44. Uid uint64
  45. TargetUid uint64
  46. MsgType int32
  47. Content string
  48. MsgData string
  49. }
  50. func verifyProcess(ctx *gin.Context) bool {
  51. return true
  52. tokenRaw := ctx.Request.FormValue("token")
  53. if tokenRaw == "" {
  54. tokenRaw = ctx.Request.Header.Get("Authorization")
  55. if tokenRaw == "" {
  56. ctx.JSON(http.StatusOK, "请重新登陆")
  57. return false
  58. }
  59. }
  60. _, err := gmweb.VerifyAction(tokenRaw)
  61. if err != nil {
  62. ctx.JSON(http.StatusOK, "请重新登陆")
  63. return false
  64. }
  65. return true
  66. }
  67. // 检索玩家数据
  68. // select * from role where nick_name like '%11%' and base_level>=1 and base_level<=3 and create_date>=str_to_date('2020-05-07', '%Y-%m-%d') and ban_date is NULL and map_level >=2 and fight_power >=1 and fight_power <=3
  69. // http://127.0.0.1:8086/gm/user_get?nickname=11&lmin=1&lmax=3&createdate=2020-05-07&banstatus=0&maplevel=2&fmin=1&fmax=3&pnum=1
  70. func WebGmProcessUserGet(c *gin.Context) {
  71. if !verifyProcess(c) {
  72. return
  73. }
  74. nickName := c.DefaultQuery("nickname", "") ///default ""
  75. activeCode := c.DefaultQuery("activecode", "")
  76. lminStr := c.DefaultQuery("lmin", "")
  77. lmaxStr := c.DefaultQuery("lmax", "")
  78. createdate := c.DefaultQuery("createdate", "")
  79. lastlogindate := c.DefaultQuery("lastlogindate", "")
  80. banstatusStr := c.DefaultQuery("banstatus", "")
  81. maplevelStr := c.DefaultQuery("maplevel", "")
  82. fminStr := c.DefaultQuery("fmin", "")
  83. fmaxStr := c.DefaultQuery("fmax", "")
  84. pagNumStr := c.DefaultQuery("pnum", "")
  85. //var paramList []interface{}
  86. procSqlStrPrefix := "select * from role where "
  87. procSqlStr := ""
  88. if nickName != "" {
  89. //procSqlStr += "nick_name like ? "
  90. //paramList = append(paramList, "'%"+nickName+"%'")
  91. procSqlStr += "nick_name like '%" + nickName + "%'"
  92. }
  93. if activeCode != "" {
  94. procSqlStr += " and active_code=" + activeCode
  95. }
  96. if lminStr != "" {
  97. baseLevel, _ := model.Str2Num(lminStr)
  98. if baseLevel > 0 {
  99. procSqlStr += " and base_level>=" + lminStr
  100. }
  101. }
  102. if lmaxStr != "" {
  103. baseLevel, _ := model.Str2Num(lmaxStr)
  104. if baseLevel > 0 {
  105. procSqlStr += " and base_level<=" + lmaxStr
  106. }
  107. }
  108. if createdate != "" {
  109. //2020-05-07T10:13:02+08:00
  110. //2018-01-12
  111. procSqlStr += " and create_date>=str_to_date('" + createdate + "', '%Y-%m-%d')"
  112. }
  113. if lastlogindate != "" {
  114. //2018-01-12
  115. procSqlStr += " and last_login_date>=str_to_date('" + lastlogindate + "', '%Y-%m-%d')"
  116. }
  117. if banstatusStr != "" {
  118. banstatus, _ := model.Str2Num(banstatusStr)
  119. if banstatus > 0 {
  120. procSqlStr += " and ban_date is not NULL"
  121. } else {
  122. procSqlStr += " and ban_date is NULL"
  123. }
  124. }
  125. if maplevelStr != "" {
  126. maplevel, _ := model.Str2Num(maplevelStr)
  127. if maplevel > 0 {
  128. procSqlStr += " and map_level >=" + maplevelStr
  129. }
  130. }
  131. if fminStr != "" {
  132. fmin, _ := model.Str2Num(fminStr)
  133. if fmin > 0 {
  134. procSqlStr += " and fight_power >=" + fminStr
  135. }
  136. }
  137. if fmaxStr != "" {
  138. fmax, _ := model.Str2Num(fmaxStr)
  139. if fmax > 0 {
  140. procSqlStr += " and fight_power <=" + fmaxStr
  141. }
  142. }
  143. if procSqlStr == "" {
  144. c.JSON(http.StatusOK, gin.H{
  145. "err": "param is empty",
  146. })
  147. return
  148. }
  149. procSqlStr = procSqlStrPrefix + procSqlStr
  150. pageNum, _ := model.Str2Num(pagNumStr)
  151. if pageNum <= 0 {
  152. pageNum = 1
  153. }
  154. pageNum -= 1
  155. procSqlStr += " limit " + strconv.Itoa(int(pageNum*20)) + ",20"
  156. var uidList []*WebBriefInfo
  157. service.GetMysql().Operate(func(rawClient interface{}) interface{} {
  158. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  159. wrapper.Query(procSqlStr).Each(func(wrapper2 *mysql.Wrapper) bool {
  160. bfInfo := parseUserInfo(wrapper2)
  161. if bfInfo != nil {
  162. uidList = append(uidList, bfInfo)
  163. }
  164. return true
  165. })
  166. if wrapper.Err != nil {
  167. util.ErrorF("nickname=%v WebGmProcessUserGet err=%v", nickName, wrapper.Err)
  168. }
  169. return nil
  170. })
  171. c.JSON(http.StatusOK, uidList)
  172. }
  173. // 获取玩家详细信息
  174. // http://127.0.0.1:8086/gm/info_get?uid=1111
  175. func WebGmProcessUserInfoGet(c *gin.Context) {
  176. if !verifyProcess(c) {
  177. return
  178. }
  179. var errStr = ""
  180. uidStr := c.DefaultQuery("uid", "") ///default ""
  181. uid, _ := model.Str2NumU64(uidStr)
  182. if uidStr == "" || uid == 0 {
  183. errStr = "uid invalid!!!"
  184. util.InfoF(errStr)
  185. c.JSON(http.StatusOK, gin.H{
  186. "err": errStr,
  187. })
  188. return
  189. }
  190. //获取简介信息
  191. var bfInfo *WebBriefInfo = nil
  192. if service.GetMysql() != nil {
  193. service.GetMysql().Operate(func(rawClient interface{}) interface{} {
  194. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  195. wrapper.Query("select * from role where uid=?", uid).Each(func(wrapper2 *mysql.Wrapper) bool {
  196. bfInfo = parseUserInfo(wrapper2)
  197. return true
  198. })
  199. if wrapper.Err != nil {
  200. util.ErrorF("uid=%v WebGmProcessUserGet err=%v", uid, wrapper.Err)
  201. }
  202. return nil
  203. })
  204. if bfInfo == nil {
  205. c.JSON(http.StatusOK, gin.H{
  206. "err": "玩家不存在!!!",
  207. })
  208. return
  209. }
  210. }
  211. //从redis中获取其他详细信息
  212. userInfo := webGMGetRoleInfo(uid)
  213. if userInfo == nil {
  214. c.JSON(http.StatusOK, bfInfo)
  215. } else {
  216. c.JSON(http.StatusOK, userInfo)
  217. //if bfInfo != nil {
  218. // detailInfo := &WebUserDetailInfo{WebBriefInfo: *bfInfo}
  219. // detailInfo.Rmb = userInfo.Base.Rmb
  220. // detailInfo.Zeny = userInfo.Base.Coin
  221. //
  222. // c.JSON(http.StatusOK, detailInfo)
  223. //} else {
  224. // c.JSON(http.StatusOK, userInfo)
  225. //}
  226. }
  227. }
  228. // 东南亚支付服务使用
  229. func WebGmProcessUserListGet(c *gin.Context) {
  230. if !verifyProcess(c) {
  231. return
  232. }
  233. var errStr = ""
  234. uidStr := c.DefaultQuery("userId", "") ///default ""
  235. //uid, _ := model.Str2NumU64(uidStr)
  236. if uidStr == "" {
  237. errStr = "uid invalid!!!"
  238. util.InfoF(errStr)
  239. c.JSON(http.StatusOK, gin.H{
  240. "err": errStr,
  241. })
  242. return
  243. }
  244. //获取简介信息
  245. bfInfoList := make([]*Uid, 0)
  246. if len(service.GetMysqlPay()) > 0 {
  247. for _, v := range service.GetMysqlPay() {
  248. var bfInfo *WebBriefInfo = nil
  249. v.Operate(func(rawClient interface{}) interface{} {
  250. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  251. wrapper.Query("select * from role where open_id=?", uidStr).Each(func(wrapper2 *mysql.Wrapper) bool {
  252. bfInfo = parseUserInfo(wrapper2)
  253. return true
  254. })
  255. if wrapper.Err != nil {
  256. util.ErrorF("uid=%v WebGmProcessUserGet err=%v", uidStr, wrapper.Err)
  257. }
  258. return nil
  259. })
  260. serverId := strconv.Itoa(bfInfo.Serverid / 2)
  261. bfInfoList = append(bfInfoList, &Uid{Uid: strconv.FormatUint(bfInfo.Uid, 10), Server: serverId, CharacterName: bfInfo.NickName, ServerName: serverId + "区"})
  262. }
  263. if len(bfInfoList) == 0 {
  264. c.JSON(http.StatusOK, gin.H{
  265. "err": "玩家不存在!!!",
  266. })
  267. return
  268. }
  269. }
  270. c.JSON(http.StatusOK, UserList{UserId: uidStr, Uids: bfInfoList})
  271. }
  272. // 东南亚支付服务使用
  273. func WebGmProcessUserListCheck(c *gin.Context) {
  274. if !verifyProcess(c) {
  275. return
  276. }
  277. var errStr = ""
  278. uidStr := c.DefaultQuery("uid", "") ///default ""
  279. uid, _ := model.Str2NumU64(uidStr)
  280. if uidStr == "" || uid == 0 {
  281. errStr = "uid invalid!!!"
  282. util.InfoF(errStr)
  283. c.JSON(http.StatusOK, gin.H{
  284. "err": errStr,
  285. })
  286. return
  287. }
  288. //获取简介信息
  289. var bfInfo *WebBriefInfo = nil
  290. if len(service.GetMysqlPay()) > 0 {
  291. for _, v := range service.GetMysqlPay() {
  292. v.Operate(func(rawClient interface{}) interface{} {
  293. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  294. wrapper.Query("select * from role where uid=?", uid).Each(func(wrapper2 *mysql.Wrapper) bool {
  295. bfInfo = parseUserInfo(wrapper2)
  296. return true
  297. })
  298. if wrapper.Err != nil {
  299. util.ErrorF("uid=%v WebGmProcessUserGet err=%v", uid, wrapper.Err)
  300. }
  301. return nil
  302. })
  303. }
  304. if bfInfo == nil {
  305. c.JSON(http.StatusOK, gin.H{
  306. "err": "玩家不存在!!!",
  307. })
  308. return
  309. }
  310. }
  311. if bfInfo == nil {
  312. c.JSON(404, gin.H{
  313. "code": "UID_NOT_FOUND",
  314. "message": "UID does not exist",
  315. })
  316. return
  317. }
  318. serverId := strconv.Itoa(bfInfo.Serverid / 2)
  319. c.JSON(http.StatusOK, CheckUser{CharacterName: bfInfo.NickName, Server: serverId, ServerName: serverId + "区"})
  320. }
  321. func WebGmProcessCreateOrder(c *gin.Context) {
  322. if !verifyProcess(c) {
  323. return
  324. }
  325. var errStr = ""
  326. serverId := service.GetServiceConfig().Node.Zone / 2
  327. uidStr := c.DefaultQuery("uid", "") ///default ""
  328. orderIdStr := c.DefaultQuery("order_id", "") ///default ""
  329. productIdStr := c.DefaultQuery("productId", "") ///default ""
  330. countStr := c.DefaultQuery("count", "") ///default ""
  331. typeStr := c.DefaultQuery("productType", "") ///default ""
  332. //uid, _ := model.Str2NumU64(uidStr)
  333. cpOrderId := model.GenerateUidByZone(service.GetServiceConfig().Node.Zone)
  334. productId, _ := strconv.Atoi(productIdStr)
  335. type1, _ := strconv.Atoi(typeStr)
  336. count, _ := strconv.Atoi(countStr)
  337. if uidStr == "" || orderIdStr == "" || productIdStr == "" {
  338. errStr = "uid invalid!!!"
  339. util.ErrorF("param error:%v ,%v,%v", uidStr, orderIdStr, productIdStr)
  340. c.JSON(http.StatusOK, gin.H{
  341. "err": errStr,
  342. })
  343. return
  344. }
  345. ss := &serverproto.SSPayOrderCreateReq{
  346. OrderId: orderIdStr,
  347. GoodsId: int32(productId),
  348. GoodsType: int32(type1),
  349. Count: int32(count),
  350. Uid: uidStr,
  351. OrderCode: cpOrderId,
  352. }
  353. selfmodel.SendSocial(ss)
  354. c.JSON(http.StatusOK, gin.H{
  355. "status": "success",
  356. "serverId": serverId,
  357. "order_code": strconv.FormatUint(uint64(cpOrderId), 10),
  358. })
  359. }
  360. type UserList struct {
  361. UserId string `json:"userId"`
  362. Uids []*Uid `json:"uids"`
  363. }
  364. type Uid struct {
  365. Uid string `json:"uid"`
  366. Server string `json:"server"`
  367. ServerName string `json:"serverName"`
  368. CharacterName string `json:"characterName"`
  369. }
  370. type CheckUser struct {
  371. Server string `json:"server"`
  372. ServerName string `json:"serverName"`
  373. CharacterName string `json:"characterName"`
  374. //CallBackKey string `json:"callBackKey"`
  375. }
  376. // 封号
  377. // http://127.0.0.1:8086/gm/ban?uid=1111&ban=1
  378. func WebGmProcessBanUser(c *gin.Context) {
  379. if !verifyProcess(c) {
  380. return
  381. }
  382. var errStr = ""
  383. uidStr := c.DefaultQuery("uid", "") ///default ""
  384. banStr := c.DefaultQuery("ban", "")
  385. banTypeStr := c.DefaultQuery("bantype", "1")
  386. banDurationTimeStr := c.DefaultQuery("bantime", "25920") //25920小时
  387. uid, _ := model.Str2NumU64(uidStr)
  388. if uidStr == "" || uid == 0 {
  389. errStr = "uid invalid!!!"
  390. util.InfoF(errStr)
  391. c.JSON(http.StatusOK, gin.H{
  392. "err": errStr,
  393. })
  394. return
  395. }
  396. ban, _ := model.Str2Num(banStr)
  397. banType, _ := model.Str2Num(banTypeStr)
  398. banDurationTime, _ := model.Str2Num(banDurationTimeStr)
  399. if service.GetMysql() != nil {
  400. var getUid uint64 = 0
  401. var banData interface{} = nil
  402. service.GetMysql().Operate(func(rawClient interface{}) interface{} {
  403. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  404. if banType == 1 {
  405. wrapper.Query("select uid,ban_date from role where uid=?", uid).Each(func(wrapper2 *mysql.Wrapper) bool {
  406. //bfInfo = parseUserInfo(wrapper2)
  407. err := wrapper.Scan(&getUid, &banData)
  408. if err != nil {
  409. util.ErrorF("uid=%v WebGmProcessBanUser err=%v", uid, err)
  410. }
  411. return true
  412. })
  413. } else if banType == 2 {
  414. wrapper.Query("select uid,ban_chat_date from role where uid=?", uid).Each(func(wrapper2 *mysql.Wrapper) bool {
  415. //bfInfo = parseUserInfo(wrapper2)
  416. err := wrapper.Scan(&getUid, &banData)
  417. if err != nil {
  418. util.ErrorF("uid=%v WebGmProcessBanUser err=%v", uid, err)
  419. }
  420. return true
  421. })
  422. }
  423. if wrapper.Err != nil {
  424. util.ErrorF("uid=%v WebGmProcessBanUser err=%v", uid, wrapper.Err)
  425. }
  426. return nil
  427. })
  428. if getUid <= 0 {
  429. c.JSON(http.StatusOK, gin.H{
  430. "err": "user not find!!!",
  431. })
  432. return
  433. } else if banData == nil && ban <= 0 {
  434. c.JSON(http.StatusOK, gin.H{
  435. "err": "玩家没有处于封号状态,无法做解封操作",
  436. })
  437. return
  438. }
  439. }
  440. //} else if banData != nil && ban > 0 {
  441. // banTimeStamp := banData.(time.Time).Unix()
  442. // nowTime := util.GetTimeSeconds()
  443. // if banTimeStamp > nowTime {
  444. // c.JSON(http.StatusOK, gin.H{
  445. // "err": "玩家处于封号状态,无法封号操作",
  446. // "endtime": banData,
  447. // })
  448. // return
  449. // }
  450. //}
  451. //ban
  452. if ok, banEndTime := webGMRoleBan(uid, ban > 0, banType, banDurationTime); ok {
  453. c.JSON(http.StatusOK, gin.H{
  454. "err": "操作成功",
  455. "endtime": util.GetTimeByUint32(uint32(banEndTime)),
  456. })
  457. } else {
  458. c.JSON(http.StatusOK, gin.H{
  459. "err": "玩家不存在",
  460. })
  461. }
  462. }
  463. // 1私聊,2公聊
  464. // http://127.0.0.1:8086/gm/chat_msg?type=2&uid=111&msgdate=2020-05-05%2021:42:59
  465. func WebGmProcessChatMsg(c *gin.Context) {
  466. if !verifyProcess(c) {
  467. return
  468. }
  469. msgDataStr := c.DefaultQuery("msgdate", "")
  470. typeStr := c.DefaultQuery("type", "")
  471. uidStr := c.DefaultQuery("uid", "") ///default ""
  472. if msgDataStr == "" && uidStr == "" {
  473. c.JSON(http.StatusOK, gin.H{
  474. "err": "输入时间和玩家uid不能都为空",
  475. })
  476. return
  477. }
  478. procSqlStr := "select * from role_msg where "
  479. if typeStr != "" {
  480. msgType, _ := model.Str2Num(typeStr)
  481. if msgType > 0 {
  482. procSqlStr += " msg_type=" + typeStr
  483. } else {
  484. procSqlStr += " msg_type=1"
  485. }
  486. }
  487. if uidStr != "" {
  488. uid, _ := model.Str2NumU64(uidStr)
  489. if uid > 0 {
  490. procSqlStr += " and uid=" + uidStr
  491. }
  492. }
  493. procSqlStr += " and msg_date>=str_to_date('" + msgDataStr + "', '%Y-%m-%d %H:%i:%S')"
  494. var msgInfoList []*WebUserChatMsgInfo
  495. service.GetMysql().Operate(func(rawClient interface{}) interface{} {
  496. wrapper := mysql.NewWrapper(rawClient.(*sql.DB))
  497. wrapper.Query(procSqlStr).Each(func(wrapper2 *mysql.Wrapper) bool {
  498. msgInfo := parseChatMsgInfo(wrapper2)
  499. if msgInfo != nil {
  500. msgInfoList = append(msgInfoList, msgInfo)
  501. }
  502. return true
  503. })
  504. if wrapper.Err != nil {
  505. util.ErrorF("WebGmProcessChatMsg err=%v", wrapper.Err)
  506. }
  507. return nil
  508. })
  509. if len(msgInfoList) <= 0 {
  510. c.JSON(http.StatusOK, gin.H{
  511. "err": "消息为空",
  512. })
  513. } else {
  514. c.JSON(http.StatusOK, msgInfoList)
  515. }
  516. }
  517. // 邮件
  518. // http://127.0.0.1:8086/gm/mail?type=list 获取当前的定时邮件列表
  519. // http://127.0.0.1:8086/gm/mail?type=add&title=title&content=content&reward=101:1,102:3//添加邮件
  520. // http://127.0.0.1:8086/gm/mail?type=add&title=title&content=content&reward=101:1,102:3&senddate=2020-05-09%2000:00:00
  521. // http://127.0.0.1:8086/gm/mail?type=del&id=邮件id
  522. func WebGmProcessMail(c *gin.Context) {
  523. if !verifyProcess(c) {
  524. return
  525. }
  526. idStr := c.DefaultQuery("id", "")
  527. uidStr := c.DefaultQuery("uid", "")
  528. senddateStr := c.DefaultQuery("senddate", "")
  529. titleStr := c.DefaultQuery("title", "")
  530. contentStr := c.DefaultQuery("content", "")
  531. rewardStr := c.DefaultQuery("reward", "")
  532. // list表示获取邮件列表
  533. // attach添加替换邮件
  534. // del删除延迟发送邮件
  535. mailType := c.DefaultQuery("type", "")
  536. if mailType == "add" && titleStr == "" && contentStr == "" {
  537. c.JSON(http.StatusOK, gin.H{
  538. "err": "输入的标题和正文为空!!!",
  539. })
  540. return
  541. }
  542. id, _ := model.Str2Num(idStr)
  543. //uid
  544. var uidList []uint64
  545. uidStrList := strings.Split(uidStr, ",")
  546. for idx := 0; idx < len(uidStrList); idx++ {
  547. tmpUid, _ := model.Str2NumU64(uidStrList[idx])
  548. if tmpUid > 0 {
  549. uidList = append(uidList, tmpUid)
  550. }
  551. }
  552. if len(uidList) <= 0 && uidStr != "" {
  553. c.JSON(http.StatusOK, gin.H{
  554. "err": "输入的玩家id不正确!!!",
  555. })
  556. return
  557. }
  558. //reward
  559. var rewardList []*serverproto.KeyValueType
  560. rewardStrList := strings.Split(rewardStr, ",")
  561. for idx := 0; idx < len(rewardStrList); idx++ {
  562. key, val := model.Str2Res(rewardStrList[idx])
  563. if key > 0 && val > 0 {
  564. rewardList = append(rewardList, &serverproto.KeyValueType{Key: key, Value: val})
  565. }
  566. }
  567. //sendtime
  568. var sendTime uint64 = 0
  569. if senddateStr != "" {
  570. loc := util.GetLoc()
  571. sendDate, err := time.ParseInLocation(util.DATE_FORMAT, senddateStr, loc)
  572. if err != nil {
  573. c.JSON(http.StatusOK, gin.H{
  574. "err": "发送时间填写不对!!! 正确格式:2021-01-11 14:17:12",
  575. })
  576. return
  577. }
  578. util.InfoF("WebGmProcessMail sendtime=%v", sendDate.Local().String())
  579. sendTime = uint64(sendDate.Local().UnixNano() / 1e6)
  580. } else {
  581. //以发送时的时间为准
  582. sendTime = util.GetTimeMilliseconds()
  583. }
  584. if mailType == "del" {
  585. gmweb.GetMailUpdateMag().DelMailItem(id)
  586. c.JSON(http.StatusOK, "删除延迟发送邮件成功")
  587. } else if mailType == "list" {
  588. mailList := gmweb.GetMailUpdateMag().GetMailList()
  589. c.JSON(http.StatusOK, mailList)
  590. } else if mailType == "add" {
  591. gmweb.GetMailUpdateMag().AttachMail2Update(id, uidList, titleStr, contentStr, sendTime, rewardList)
  592. c.JSON(http.StatusOK, "发送邮件成功")
  593. }
  594. }
  595. func WebGmProcessMailPost(c *gin.Context) {
  596. if !verifyProcess(c) {
  597. return
  598. }
  599. idStr := c.PostForm("id")
  600. uidStrList := c.PostFormArray("uid")
  601. senddateStr := c.PostForm("senddate")
  602. titleStr := c.PostForm("title")
  603. contentStr := c.PostForm("content")
  604. rewardStr := c.PostForm("reward")
  605. // list表示获取邮件列表
  606. // attach添加替换邮件
  607. // del删除延迟发送邮件
  608. mailType := c.PostForm("type")
  609. if mailType == "add" && titleStr == "" && contentStr == "" {
  610. c.JSON(http.StatusOK, gin.H{
  611. "err": "输入的标题和正文为空!!!",
  612. })
  613. return
  614. }
  615. id, _ := model.Str2Num(idStr)
  616. //uid
  617. var uidList []uint64
  618. for idx := 0; idx < len(uidStrList); idx++ {
  619. tmpUid, _ := model.Str2NumU64(uidStrList[idx])
  620. if tmpUid > 0 {
  621. uidList = append(uidList, tmpUid)
  622. }
  623. }
  624. //reward
  625. var rewardList []*serverproto.KeyValueType
  626. rewardStrList := strings.Split(rewardStr, ",")
  627. for idx := 0; idx < len(rewardStrList); idx++ {
  628. key, val := model.Str2Res(rewardStrList[idx])
  629. if key > 0 && val > 0 {
  630. rewardList = append(rewardList, &serverproto.KeyValueType{Key: key, Value: val})
  631. }
  632. }
  633. //sendtime
  634. var sendTime uint64 = 0
  635. if senddateStr != "" {
  636. loc := util.GetLoc()
  637. sendDate, err := time.ParseInLocation(util.DATE_FORMAT, senddateStr, loc)
  638. if err != nil {
  639. c.JSON(http.StatusOK, gin.H{
  640. "err": "发送时间填写不对!!!",
  641. })
  642. return
  643. }
  644. util.InfoF("WebGmProcessMail sendtime=%v", sendDate.Local().String())
  645. sendTime = uint64(sendDate.Local().UnixNano() / 1e6)
  646. }
  647. if mailType == "del" {
  648. gmweb.GetMailUpdateMag().DelMailItem(id)
  649. c.JSON(http.StatusOK, "删除延迟发送邮件成功")
  650. } else if mailType == "list" {
  651. mailList := gmweb.GetMailUpdateMag().GetMailList()
  652. c.JSON(http.StatusOK, mailList)
  653. } else if mailType == "add" {
  654. gmweb.GetMailUpdateMag().AttachMail2Update(id, uidList, titleStr, contentStr, sendTime, rewardList)
  655. c.JSON(http.StatusOK, "发送邮件成功")
  656. }
  657. }
  658. // http://127.0.0.1:8086/gm/notice?&token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE1OTAyMjQ2NzAsImlhdCI6MTU5MDIyMTA3MH0.WihVh5AsvHm6MKHwoCELJgNzz9aA-ETPtchotLj_9Z0&col=<color=%23ff4b14>商城购买!!!!!!!!!!!!<%23color>&count=5&interval=5
  659. func WebGmProcessNotice(c *gin.Context) {
  660. if !verifyProcess(c) {
  661. return
  662. }
  663. colorStr := c.DefaultQuery("col", "")
  664. //speedStr := c.DefaultQuery("speed", "")
  665. countStr := c.DefaultQuery("count", "")
  666. intervalStr := c.DefaultQuery("interval", "")
  667. if colorStr == "" || countStr == "" {
  668. c.JSON(http.StatusOK, "color,count,interval不能为空")
  669. return
  670. }
  671. count, _ := model.Str2Num(countStr)
  672. interval, _ := model.Str2Num(intervalStr)
  673. if count <= 0 || interval <= 0 {
  674. c.JSON(http.StatusOK, "color,count,interval不能为空")
  675. return
  676. }
  677. noticeNtf := &serverproto.SSWebGMNoticeNtf{
  678. NoticeInfo: &serverproto.GMNoticeInfo{
  679. NoticeColor: colorStr,
  680. NoticeCount: uint32(count),
  681. NoticeInterval: uint32(interval),
  682. },
  683. }
  684. gmweb.SendSocial(noticeNtf)
  685. c.JSON(http.StatusOK, "公告发送成功")
  686. }
  687. func WebGMProcessServerMaintain(c *gin.Context) {
  688. stateStr := c.DefaultQuery("state", "1")
  689. //把在线玩家踢下线
  690. if stateStr == "1" {
  691. state, _ := model.Str2Num(stateStr)
  692. ntfMsg := &serverproto.SSWEBGMServerMaintainNtf{
  693. State: int32(state),
  694. }
  695. gmweb.SendSocial(ntfMsg)
  696. c.JSON(http.StatusOK, "维护成功(强制所有玩家下线)")
  697. } else {
  698. c.JSON(http.StatusOK, "state不为1")
  699. }
  700. }
  701. // http://127.0.0.1:8086/gm/guildbattle_state
  702. func WebGmGetGuildBattleState(c *gin.Context) {
  703. state, banType, ok := webGMGetGuildBattleState()
  704. if ok {
  705. c.JSON(http.StatusOK, gin.H{
  706. "err": "操作成功",
  707. "battle_state": state, //0:不在公会战内,1:公会战内
  708. "ban_type": banType, //0:公会战未禁止,1:公会战禁止
  709. })
  710. } else {
  711. c.JSON(http.StatusOK, gin.H{
  712. "err": "操作失败",
  713. "battle_state": -1, //-1:数据库查询异常,0:不在公会战内,1:公会战内
  714. "ban_type": -1, //-1:数据库查询异常,0:公会战未禁止,1:公会战禁止
  715. })
  716. }
  717. }
  718. func WebGMProcessServerRegister(c *gin.Context) {
  719. stateStr := c.DefaultQuery("state", "1")
  720. //关闭注册
  721. if stateStr == "1" {
  722. webGMServerRegister(stateStr)
  723. c.JSON(http.StatusOK, "关闭注册操作成功")
  724. } else {
  725. //开启注册
  726. webGMServerRegister(stateStr)
  727. c.JSON(http.StatusOK, "开启注册操作成功")
  728. }
  729. }
  730. func WebGMProcessServerConfigReload(c *gin.Context) {
  731. cfgStr := c.DefaultQuery("config", "") //例如AdvertisingScreen,ActivitiesCfg,ActiveCodeCfg
  732. cfgStrList := strings.Split(cfgStr, ",")
  733. if len(cfgStrList) <= 0 {
  734. c.JSON(http.StatusOK, "热加载配置文件不能为空!")
  735. return
  736. }
  737. for idx := 0; idx < len(cfgStrList); idx++ {
  738. if _, ok := serverproto.CFGNameList[cfgStrList[idx]]; !ok {
  739. errStr := "配置文件有误" + cfgStrList[idx]
  740. c.JSON(http.StatusOK, errStr)
  741. return
  742. }
  743. }
  744. webGMServerConfigReload(cfgStrList)
  745. c.JSON(http.StatusOK, "热加载配置文件成功!")
  746. }
  747. // 公会战GM//1:取消封停 2:封停
  748. // http://127.0.0.1:8086/gm/guildbattle
  749. func WebGmProcessGuildBattle(c *gin.Context) {
  750. /*
  751. if !verifyProcess(c) {
  752. return
  753. }
  754. */
  755. //ban
  756. if ok := webGMGuildBattleState(); ok {
  757. c.JSON(http.StatusOK, gin.H{
  758. "err": "操作成功",
  759. })
  760. }
  761. }
  762. func webGMGuildBattleState() bool {
  763. banNtf := &serverproto.SSWebGMGuildBattle{}
  764. gmweb.SendSocial(banNtf)
  765. return true
  766. }
  767. func webGMGetGuildBattleState() (int32, int32, bool) {
  768. keyStr := "guildbattle:base:"
  769. ret, err := service.GetRedis().Get(keyStr).Result()
  770. if err != nil {
  771. util.InfoF("loadGuildBattleBase get guildId key=%v err=%v\n", keyStr, err)
  772. return 0, 0, false
  773. }
  774. if ret == "" {
  775. util.InfoF("loadGuildBattleBase key(%v)->val empty", keyStr)
  776. return 0, 0, false
  777. }
  778. str, err := base64.StdEncoding.DecodeString(ret)
  779. if err != nil {
  780. util.InfoF("loadGuildBattleBase key(%v)->val DecodeString error", keyStr)
  781. return 0, 0, false
  782. }
  783. guildBase := &serverproto.GuildBattleBase{}
  784. err = rocommon.GetCodec().Unmarshal(str, guildBase)
  785. if err == nil {
  786. battleState := int32(0)
  787. //1:开始阶段, 10:展示阶段
  788. if 1 <= guildBase.GuildBattleState && guildBase.GuildBattleState <= 10 {
  789. battleState = 1
  790. }
  791. util.InfoF("loadGuildBattleBase success:%v", guildBase)
  792. return battleState, guildBase.BanType, true
  793. }
  794. return 0, 0, false
  795. }
  796. // ///////////
  797. func parseUserInfo(wrapper *mysql.Wrapper) *WebBriefInfo {
  798. var Uid uint64
  799. var NickName sql.NullString
  800. var BaseLevel sql.NullInt64
  801. var CreateDate sql.NullString
  802. var LastLoginDate sql.NullString
  803. var BanDate sql.NullString
  804. var MapLevel sql.NullInt64
  805. var FightPower sql.NullInt64
  806. var ActiveCode sql.NullString
  807. var OpenId sql.NullString
  808. err := wrapper.Scan(&Uid, &NickName, &BaseLevel, &CreateDate,
  809. &LastLoginDate, &BanDate, &MapLevel, &FightPower, &ActiveCode, &OpenId)
  810. if err == nil {
  811. bfInfo := &WebBriefInfo{
  812. Uid: Uid,
  813. }
  814. if NickName.Valid {
  815. bfInfo.NickName = NickName.String
  816. }
  817. if BaseLevel.Valid {
  818. bfInfo.BaseLevel = int32(BaseLevel.Int64)
  819. }
  820. if CreateDate.Valid {
  821. bfInfo.CreateDate = CreateDate.String
  822. }
  823. if LastLoginDate.Valid {
  824. bfInfo.LastLoginDate = LastLoginDate.String
  825. }
  826. if BanDate.Valid {
  827. bfInfo.BanDate = BanDate.String
  828. }
  829. if MapLevel.Valid {
  830. bfInfo.MapLevel = int32(MapLevel.Int64)
  831. }
  832. if FightPower.Valid {
  833. bfInfo.FightPower = uint32(FightPower.Int64)
  834. }
  835. if ActiveCode.Valid {
  836. bfInfo.ActiveCode = ActiveCode.String
  837. }
  838. if OpenId.Valid {
  839. bfInfo.OpenId = OpenId.String
  840. }
  841. return bfInfo
  842. } else {
  843. util.ErrorF("WebGmProcessUserGet err=%v", wrapper.Err)
  844. }
  845. return nil
  846. }
  847. func parseChatMsgInfo(wrapper *mysql.Wrapper) *WebUserChatMsgInfo {
  848. var Uid uint64
  849. var TargetUid sql.NullInt64
  850. var MsgType sql.NullInt64
  851. var Content sql.NullString
  852. var MsgData sql.NullString
  853. err := wrapper.Scan(&Uid, &TargetUid, &MsgType, &Content, &MsgData)
  854. if err == nil {
  855. msgInfo := &WebUserChatMsgInfo{
  856. Uid: Uid,
  857. }
  858. if TargetUid.Valid {
  859. msgInfo.TargetUid = uint64(TargetUid.Int64)
  860. }
  861. if MsgType.Valid {
  862. msgInfo.MsgType = int32(MsgType.Int64)
  863. }
  864. if Content.Valid {
  865. msgInfo.Content = Content.String
  866. }
  867. if MsgData.Valid {
  868. msgInfo.MsgData = MsgData.String
  869. }
  870. return msgInfo
  871. } else {
  872. util.ErrorF("WebGmProcessUserGet err=%v", wrapper.Err)
  873. }
  874. return nil
  875. }
  876. func webGMGetRoleInfo(uid uint64) *serverproto.WebRoleInfo {
  877. if uid <= 0 {
  878. return nil
  879. }
  880. value := strconv.FormatUint(uid, 10)
  881. uidInfo := &serverproto.WebRoleInfo{}
  882. uidInfo.Base = &serverproto.RoleBase{}
  883. err := model.GetMessageFromRedis(dbmodel.RoleBasePrefix, value, uidInfo.Base)
  884. if err != nil {
  885. return nil
  886. }
  887. uidInfo.RoleHero = &serverproto.RoleHero{}
  888. err = dbmodel.GetRoleHeroDataFromRedis(uid, uidInfo.RoleHero)
  889. if err != nil && err != service.NIL {
  890. util.InfoF("WebGMGetRoleInfo RoleHero err=%v uid=%v", err, uid)
  891. return nil
  892. }
  893. return uidInfo
  894. }
  895. func webGMRoleBan(uid uint64, ban bool, banType, banDurationTime int) (bool, uint64) {
  896. value := strconv.FormatUint(uid, 10)
  897. tmpRoleBase := &serverproto.RoleBase{}
  898. err := model.GetMessageFromRedis(dbmodel.RoleBasePrefix, value, tmpRoleBase)
  899. if err != nil {
  900. util.InfoF("webGMRoleBan can't find uid=%v player", uid)
  901. return false, 0
  902. }
  903. //默认2小时
  904. //var banTime uint64 = 2 * 60 * 60 //s
  905. var banTime = uint64(banDurationTime) * 60 * 60 //s
  906. if ban {
  907. //1封号,2禁言
  908. if banType == 1 {
  909. tmpRoleBase.BanTime = uint64(util.GetTimeSeconds()) + banTime
  910. } else if banType == 2 {
  911. tmpRoleBase.ChatBanTime = uint64(util.GetTimeSeconds()) + banTime
  912. }
  913. } else {
  914. if banType == 1 {
  915. tmpRoleBase.BanTime = 0
  916. } else if banType == 2 {
  917. tmpRoleBase.ChatBanTime = 0
  918. }
  919. //清除作弊次数
  920. tmpRoleRoleStatistic := &serverproto.RoleStatistic{}
  921. err = model.GetMessageFromRedis(dbmodel.RoleStatisticDataPrefix, value, tmpRoleRoleStatistic)
  922. if err == nil {
  923. tmpRoleRoleStatistic.CheatData = nil
  924. err = dbmodel.SetSystemDataToRedis(dbmodel.RoleStatisticDataPrefix, uid, tmpRoleRoleStatistic)
  925. if err != nil {
  926. util.InfoF("webGMRoleBan clear cheat data err=%v uid=%v", err, uid)
  927. }
  928. }
  929. }
  930. err = dbmodel.SetRoleToRedis(uid, tmpRoleBase)
  931. if err != nil {
  932. util.InfoF("webGMRoleBan save banTime err=%v uid=%v", err, uid)
  933. }
  934. //banType 1封号,2禁言
  935. if banType == 1 {
  936. dbmodel.DoUpdatePlayerBanInfo2MysqlORM(nil, uid, tmpRoleBase.BanTime, int32(banType))
  937. } else if banType == 2 {
  938. dbmodel.DoUpdatePlayerBanInfo2MysqlORM(nil, uid, tmpRoleBase.ChatBanTime, int32(banType))
  939. }
  940. //发送给social,在线的玩家直接踢下线
  941. banNtf := &serverproto.SSWebGMBanNtf{
  942. BanUid: uid,
  943. IsBan: ban,
  944. BanTime: banTime,
  945. BanType: int32(banType),
  946. }
  947. gmweb.SendSocial(banNtf)
  948. return true, tmpRoleBase.BanTime
  949. }
  950. // 服务器创建功能开启/关闭
  951. func webGMServerRegister(stateStr string) {
  952. service.GetRedis().HSet(model.ServerPrefix, "registerclose", stateStr)
  953. }
  954. func webGMServerConfigReload(cfgStrList []string) {
  955. ntfMsg := &serverproto.SSServerConfigReloadNtf{
  956. CfgList: cfgStrList,
  957. }
  958. gmweb.SendSocial(ntfMsg)
  959. }
  960. func WebGMLookMail(c *gin.Context) {
  961. uidStr := c.DefaultQuery("uid", "")
  962. tmpBeginTime := c.DefaultQuery("begin_time", "0")
  963. tmpEndTime := c.DefaultQuery("end_time", "0")
  964. beginT, _ := model.Str2NumU64(tmpBeginTime)
  965. endT, _ := model.Str2NumU64(tmpEndTime)
  966. if len(uidStr) <= 0 {
  967. c.JSON(http.StatusOK, "uid 错误")
  968. return
  969. }
  970. var ret []*serverproto.MailContent
  971. keyStr := dbmodel.RoleMailDataPrefix + uidStr
  972. valueStrList, err := service.GetRedis().HGetAll(keyStr).Result()
  973. if err != nil && err != service.NIL {
  974. util.InfoF("uid=%v GetRoleMailDataFromRedis err=%v", uidStr, err)
  975. return
  976. }
  977. for key, value := range valueStrList {
  978. if key == "maxId" || key == "gMaxId" {
  979. continue
  980. }
  981. //if key == "DelMail"{
  982. // tmp := &serverproto.DelMail{}
  983. // err := model.GetDecodeMessage(tmp, value)
  984. // if err != nil{continue}
  985. // for _, mail := range tmp.DelMail {
  986. // if mail.BeginTime < beginT{continue}
  987. // if endT > 0 && mail.BeginTime > endT{continue}
  988. // ret = append(ret, mail)
  989. // }
  990. //}
  991. mailData := &serverproto.MailContent{}
  992. if err := model.GetDecodeMessage(mailData, value); err != nil {
  993. util.InfoF("uid=%v GetRoleMailDataFromRedis key=%v err=%v", uidStr, key, err)
  994. continue
  995. } else {
  996. if mailData.BeginTime < beginT {
  997. continue
  998. }
  999. if endT > 0 && mailData.BeginTime > endT {
  1000. continue
  1001. }
  1002. ret = append(ret, mailData)
  1003. }
  1004. }
  1005. c.JSON(http.StatusOK, ret)
  1006. }
  1007. func WebGMSetHead(c *gin.Context) {
  1008. uidStr := c.DefaultQuery("uid", "")
  1009. headStr := c.DefaultQuery("headId", "0")
  1010. stateStr := c.DefaultQuery("state", "0")
  1011. headId, _ := model.Str2Num(headStr)
  1012. state, _ := model.Str2Num(stateStr)
  1013. uid, _ := model.Str2NumU64(uidStr)
  1014. if headId <= 0 || state < 0 || uid <= 0 {
  1015. c.JSON(http.StatusOK, "parameter error")
  1016. return
  1017. }
  1018. msg := &serverproto.SSWebGMHeadChange{
  1019. HeadId: int32(headId),
  1020. Uid: uid,
  1021. State: int32(state),
  1022. }
  1023. gmweb.SendSocial(msg)
  1024. c.JSON(http.StatusOK, msg)
  1025. }
  1026. func WebGMGetHead(c *gin.Context) {
  1027. uidStr := c.DefaultQuery("uid", "")
  1028. if uidStr == "" {
  1029. c.JSON(http.StatusOK, "uid error:"+uidStr)
  1030. return
  1031. }
  1032. headData := &serverproto.RoleHead{}
  1033. err := model.GetMessageFromRedis(dbmodel.RoleHeadDataPrefix, uidStr, headData)
  1034. if err != nil && err != service.NIL {
  1035. c.JSON(http.StatusOK, "uid read redis head error"+uidStr)
  1036. return
  1037. }
  1038. retMsg := &serverproto.RoleHead{}
  1039. for _, data := range headData.Heads {
  1040. if data.State < int32(1) { // 未完成的称号不显示
  1041. continue
  1042. }
  1043. retMsg.Heads = append(retMsg.Heads, data)
  1044. }
  1045. c.JSON(http.StatusOK, retMsg)
  1046. }
  1047. // 删除背包内道具
  1048. func WebGMDelItem(c *gin.Context) {
  1049. uidStr := c.DefaultQuery("uid", "")
  1050. delItemStr := c.DefaultQuery("del", "")
  1051. if uidStr == "" {
  1052. c.JSON(http.StatusOK, "uid error:"+uidStr)
  1053. return
  1054. }
  1055. //uid
  1056. uid, _ := model.Str2NumU64(uidStr)
  1057. if uid <= 0 {
  1058. c.JSON(http.StatusOK, gin.H{
  1059. "err": "uid invalid",
  1060. })
  1061. util.InfoF("uid=%v uid invalid", uid)
  1062. return
  1063. }
  1064. //del item list
  1065. var delKV []*serverproto.KeyValueType
  1066. delItemStrList := strings.Split(delItemStr, ",")
  1067. for idx := 0; idx < len(delItemStrList); idx++ {
  1068. k, v := model.Str2Res(delItemStrList[idx])
  1069. if k <= 0 || v <= 0 {
  1070. continue
  1071. }
  1072. delKV = append(delKV, &serverproto.KeyValueType{Key: k, Value: v})
  1073. }
  1074. if len(delKV) <= 0 {
  1075. c.JSON(http.StatusOK, gin.H{
  1076. "err": "uid del item invalid",
  1077. })
  1078. util.InfoF("uid=%v item invalid", uid)
  1079. return
  1080. }
  1081. roleBag := &serverproto.RoleBag{}
  1082. err := dbmodel.GetSystemDataFromRedis(dbmodel.RoleBagDataPrefix, uid, roleBag)
  1083. if err != nil {
  1084. c.JSON(http.StatusOK, gin.H{
  1085. "err": "uid get bag error",
  1086. })
  1087. util.InfoF("uid=%v uid get bag error=%v", uid, err)
  1088. return
  1089. }
  1090. var tmpItemDataList []*serverproto.ItemData
  1091. for idx := 0; idx < len(delKV); idx++ {
  1092. delkv := delKV[idx]
  1093. for i := 0; i < len(roleBag.ItemList); i++ {
  1094. if roleBag.ItemList[i].ConfigId != delkv.Key {
  1095. tmpItemDataList = append(tmpItemDataList, roleBag.ItemList[i])
  1096. } else {
  1097. if roleBag.ItemList[i].Num >= uint32(delkv.Value) {
  1098. roleBag.ItemList[i].Num -= uint32(delkv.Value)
  1099. tmpItemDataList = append(tmpItemDataList, roleBag.ItemList[i])
  1100. }
  1101. }
  1102. }
  1103. }
  1104. roleBag.ItemList = tmpItemDataList
  1105. //1.直接数据库操作
  1106. dbmodel.SetSystemDataToRedis(dbmodel.RoleBagDataPrefix, uid, roleBag)
  1107. //2.在线发送给对应的game玩家
  1108. //发送给social,在线的玩家直接踢下线
  1109. banNtf := &serverproto.SSWebGMDelItemNtf{
  1110. Uid: uid,
  1111. DelItemList: delKV,
  1112. }
  1113. gmweb.SendSocial(banNtf)
  1114. c.JSON(http.StatusOK, gin.H{
  1115. "err": "del item ok",
  1116. })
  1117. }
  1118. var RedisCdk2 service.RedisConnector
  1119. func GetCdk(c *gin.Context) {
  1120. countStr := c.DefaultQuery("count", "")
  1121. awardStr := c.DefaultQuery("award", "")
  1122. if awardStr == "" {
  1123. c.JSON(http.StatusOK, "award error:"+awardStr)
  1124. return
  1125. }
  1126. count, e := strconv.Atoi(countStr)
  1127. if e != nil {
  1128. c.JSON(http.StatusOK, e)
  1129. return
  1130. }
  1131. var awardKV []*serverproto.KeyValueType
  1132. itemStrList := strings.Split(awardStr, ",")
  1133. for idx := 0; idx < len(itemStrList); idx++ {
  1134. k, v := model.Str2Res(itemStrList[idx])
  1135. if k <= 0 || v <= 0 {
  1136. continue
  1137. }
  1138. awardKV = append(awardKV, &serverproto.KeyValueType{Key: k, Value: v})
  1139. }
  1140. awardData := &serverproto.SCUseHeadFrameItemAck{}
  1141. awardData.ItemList = awardKV
  1142. err, a2 := model.GetEncodeMessage(awardData)
  1143. if err != nil {
  1144. c.JSON(http.StatusOK, err)
  1145. return
  1146. }
  1147. rand.Seed(time.Now().UnixNano())
  1148. f := excelize.NewFile()
  1149. sheetName := "Sheet1"
  1150. cdk := make(map[string]interface{}, 0)
  1151. for i := 0; i < count; i++ {
  1152. // 生成随机字符串
  1153. randomString := generateRandomString(length)
  1154. cdk[randomString] = a2
  1155. cellName, err := excelize.CoordinatesToCellName(1, i+1)
  1156. if err != nil {
  1157. c.JSON(http.StatusOK, err)
  1158. return
  1159. }
  1160. // 设置单元格的值
  1161. f.SetCellValue(sheetName, cellName, randomString)
  1162. }
  1163. util.InfoF("aaaa:%v", cdk)
  1164. _, err2 := RedisCdk2.RedisCli().HMSet(dbmodel.CdkNormal, cdk).Result()
  1165. if err2 != nil {
  1166. util.InfoF("aaaa3:%v", err2)
  1167. c.JSON(http.StatusOK, err2)
  1168. return
  1169. }
  1170. util.InfoF("aaaa2:%v", cdk)
  1171. // 保存文件
  1172. filePath := "cdkNormal.xlsx"
  1173. if err := f.SaveAs(filePath); err != nil {
  1174. c.JSON(http.StatusOK, err)
  1175. return
  1176. }
  1177. c.JSON(http.StatusOK, "cdk successful")
  1178. }
  1179. // 定义生成随机字符串的长度
  1180. const length = 15
  1181. func generateRandomString(length int) string {
  1182. // 定义可用的字符集(大写字母)
  1183. const charset = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
  1184. // 初始化一个字节切片来存储结果
  1185. result := make([]byte, length)
  1186. // 生成随机字符
  1187. for i := range result {
  1188. result[i] = charset[rand.Intn(len(charset))]
  1189. }
  1190. // 将字节切片转换为字符串并返回
  1191. return string(result)
  1192. }
  1193. // 删除背包内道具
  1194. func WebGMDelPoint(c *gin.Context) {
  1195. uidStr := c.DefaultQuery("uid", "")
  1196. delItemStr := c.DefaultQuery("del", "")
  1197. if uidStr == "" {
  1198. c.JSON(http.StatusOK, "uid error:"+uidStr)
  1199. return
  1200. }
  1201. //uid
  1202. uid, _ := model.Str2NumU64(uidStr)
  1203. if uid <= 0 {
  1204. c.JSON(http.StatusOK, gin.H{
  1205. "err": "uid invalid",
  1206. })
  1207. util.InfoF("uid=%v uid invalid", uid)
  1208. return
  1209. }
  1210. //del item list
  1211. var delKV []*serverproto.KeyValueType
  1212. delItemStrList := strings.Split(delItemStr, ",")
  1213. for idx := 0; idx < len(delItemStrList); idx++ {
  1214. k, v := model.Str2Res(delItemStrList[idx])
  1215. if k <= 0 || v <= 0 {
  1216. continue
  1217. }
  1218. delKV = append(delKV, &serverproto.KeyValueType{Key: k, Value: v})
  1219. }
  1220. if len(delKV) <= 0 {
  1221. c.JSON(http.StatusOK, gin.H{
  1222. "err": "uid del item invalid",
  1223. })
  1224. util.InfoF("uid=%v item invalid", uid)
  1225. return
  1226. }
  1227. //2.在线发送给对应的game玩家
  1228. //发送给social,在线的玩家直接踢下线
  1229. banNtf := &serverproto.SSWebGMDelItemNtf{
  1230. Uid: uid,
  1231. DelItemList: delKV,
  1232. IsPoint: true,
  1233. }
  1234. gmweb.SendSocial(banNtf)
  1235. c.JSON(http.StatusOK, gin.H{
  1236. "err": "del item ok",
  1237. })
  1238. }
  1239. // 删除背包内道具
  1240. func WebGMDelItemAll(c *gin.Context) {
  1241. uidStr := c.DefaultQuery("uid", "")
  1242. delItemStr := c.DefaultQuery("del", "")
  1243. if uidStr == "" {
  1244. c.JSON(http.StatusOK, "uid error:"+uidStr)
  1245. return
  1246. }
  1247. //uid
  1248. uid, _ := model.Str2NumU64(uidStr)
  1249. if uid <= 0 {
  1250. c.JSON(http.StatusOK, gin.H{
  1251. "err": "uid invalid",
  1252. })
  1253. util.InfoF("uid=%v uid invalid", uid)
  1254. return
  1255. }
  1256. //del item list
  1257. var delKV []*serverproto.KeyValueType
  1258. delItemStrList := strings.Split(delItemStr, ",")
  1259. for idx := 0; idx < len(delItemStrList); idx++ {
  1260. k, v := model.Str2Res(delItemStrList[idx])
  1261. if k <= 0 || v <= 0 {
  1262. continue
  1263. }
  1264. delKV = append(delKV, &serverproto.KeyValueType{Key: k, Value: v})
  1265. }
  1266. if len(delKV) <= 0 {
  1267. c.JSON(http.StatusOK, gin.H{
  1268. "err": "uid del item invalid",
  1269. })
  1270. util.InfoF("uid=%v item invalid", uid)
  1271. return
  1272. }
  1273. roleBag := &serverproto.RoleBag{}
  1274. err := dbmodel.GetSystemDataFromRedis(dbmodel.RoleBagDataPrefix, uid, roleBag)
  1275. if err != nil {
  1276. c.JSON(http.StatusOK, gin.H{
  1277. "err": "uid get bag error",
  1278. })
  1279. util.InfoF("uid=%v uid get bag error=%v", uid, err)
  1280. return
  1281. }
  1282. var count uint32
  1283. //var tmpItemDataList []*serverproto.ItemData
  1284. for idx := 0; idx < len(delKV); idx++ {
  1285. delkv := delKV[idx]
  1286. for i := 0; i < len(roleBag.ItemList); i++ {
  1287. if roleBag.ItemList[i].ConfigId != delkv.Key {
  1288. //tmpItemDataList = append(tmpItemDataList, roleBag.ItemList[i])
  1289. continue
  1290. } else {
  1291. count = count + roleBag.ItemList[i].Num
  1292. roleBag.ItemList[i].Num = 0
  1293. }
  1294. }
  1295. }
  1296. //roleBag.ItemList = tmpItemDataList
  1297. //1.直接数据库操作
  1298. dbmodel.SetSystemDataToRedis(dbmodel.RoleBagDataPrefix, uid, roleBag)
  1299. if count > 0 {
  1300. util.ErrorF("del 707 uid:%v count:%v", uid, count)
  1301. }
  1302. //2.在线发送给对应的game玩家
  1303. //发送给social,在线的玩家直接踢下线
  1304. //banNtf := &serverproto.SSWebGMDelItemNtf{
  1305. // Uid: uid,
  1306. // DelItemList: delKV,
  1307. //}
  1308. //gmweb.SendSocial(banNtf)
  1309. c.JSON(http.StatusOK, gin.H{
  1310. "err": "del item ok",
  1311. })
  1312. }
  1313. // 删除背包内道具
  1314. func WebGMDelEquip(c *gin.Context) {
  1315. uidStr := c.DefaultQuery("uid", "")
  1316. delItemStr := c.DefaultQuery("del", "")
  1317. if uidStr == "" {
  1318. c.JSON(http.StatusOK, "uid error:"+uidStr)
  1319. return
  1320. }
  1321. //uid
  1322. uid, _ := model.Str2NumU64(uidStr)
  1323. if uid <= 0 {
  1324. c.JSON(http.StatusOK, gin.H{
  1325. "err": "uid invalid",
  1326. })
  1327. util.InfoF("uid=%v uid invalid", uid)
  1328. return
  1329. }
  1330. //del item list
  1331. var delKV []*serverproto.KeyValueType
  1332. delItemStrList := strings.Split(delItemStr, ",")
  1333. for idx := 0; idx < len(delItemStrList); idx++ {
  1334. k, v := model.Str2Res(delItemStrList[idx])
  1335. if k <= 0 || v <= 0 {
  1336. continue
  1337. }
  1338. delKV = append(delKV, &serverproto.KeyValueType{Key: k, Value: v})
  1339. }
  1340. if len(delKV) <= 0 {
  1341. c.JSON(http.StatusOK, gin.H{
  1342. "err": "uid del item invalid",
  1343. })
  1344. util.InfoF("uid=%v item invalid", uid)
  1345. return
  1346. }
  1347. roleBag := &serverproto.RoleEquip{}
  1348. err := dbmodel.GetSystemDataFromRedis(dbmodel.RoleEquipDataPrefix, uid, roleBag)
  1349. if err != nil {
  1350. c.JSON(http.StatusOK, gin.H{
  1351. "err": err,
  1352. })
  1353. util.ErrorF("uid=%v uid get equip error=%v", uid, err)
  1354. return
  1355. }
  1356. roleBase := &serverproto.RoleBase{}
  1357. _ = dbmodel.GetRoleBaseFromRedis(uid, roleBase)
  1358. roleHero := &serverproto.RoleHero{}
  1359. err = dbmodel.GetRoleHeroDataFromRedis(uid, roleHero)
  1360. if err != nil {
  1361. c.JSON(http.StatusOK, gin.H{
  1362. "err": "uid get bag error",
  1363. })
  1364. util.InfoF("uid=%v uid get hero error=%v", uid, err)
  1365. return
  1366. }
  1367. //roleCard := &serverproto.RoleCard{}
  1368. //err = dbmodel.GetSystemDataFromRedis(dbmodel.RoleCardDataPrefix, uid, roleCard)
  1369. //if err != nil {
  1370. // c.JSON(http.StatusOK, gin.H{
  1371. // "err": "uid get bag error",
  1372. // })
  1373. // util.InfoF("uid=%v uid get hero error=%v", uid, err)
  1374. // return
  1375. //}
  1376. var count int32
  1377. //var tmpItemDataList []*serverproto.EquipData
  1378. for i := 0; i < len(roleBag.EquipList); i++ {
  1379. for idx := 0; idx < len(delKV); idx++ {
  1380. delkv := delKV[idx]
  1381. if roleBag.EquipList[i].ConfigId != delkv.Key {
  1382. continue
  1383. } else {
  1384. count = count + roleBag.EquipList[i].Num
  1385. roleBag.EquipList[i].Num = 0
  1386. }
  1387. }
  1388. }
  1389. var count2 int32
  1390. for idx := 0; idx < len(delKV); idx++ {
  1391. delkv := delKV[idx]
  1392. for i := 0; i < len(roleBase.RoleData.HeroData.Slot.SlotList); i++ {
  1393. if roleBase.RoleData.HeroData.Slot.SlotList[i].EquipId != delkv.Key {
  1394. continue
  1395. } else {
  1396. roleBase.RoleData.HeroData.Slot.SlotList[i].EquipId = 0
  1397. count2++
  1398. }
  1399. }
  1400. }
  1401. var count3 int32
  1402. ////cardlist := make([]int32, 0)
  1403. for idx := 0; idx < len(delKV); idx++ {
  1404. delkv := delKV[idx]
  1405. for i := 0; i < len(roleHero.HeroData); i++ {
  1406. for j := 0; j < len(roleHero.HeroData[i].Slot.SlotList); j++ {
  1407. if roleHero.HeroData[i].Slot.SlotList[j].EquipId != delkv.Key {
  1408. continue
  1409. } else {
  1410. roleHero.HeroData[i].Slot.SlotList[j].EquipId = 0
  1411. count3++
  1412. //util.ErrorF("get equip2 uid:%v count:%v", uid, count)
  1413. }
  1414. }
  1415. }
  1416. }
  1417. if count+count2+count3 > 0 {
  1418. util.ErrorF("del equip uid:%v count:%v ,%v,%v", uid, count, count2, count3)
  1419. }
  1420. //1.直接数据库操作
  1421. dbmodel.SetRoleHeroDataToRedis(uid, roleHero)
  1422. dbmodel.SetSystemDataToRedis(dbmodel.RoleEquipDataPrefix, uid, roleBag)
  1423. //dbmodel.SetRoleToRedis(uid, roleBase)
  1424. //2.在线发送给对应的game玩家
  1425. //发送给social,在线的玩家直接踢下线
  1426. //banNtf := &serverproto.SSWebGMDelItemNtf{
  1427. // Uid: uid,
  1428. // DelItemList: delKV,
  1429. //}
  1430. //gmweb.SendSocial(banNtf)
  1431. c.JSON(http.StatusOK, gin.H{
  1432. "err": "del item ok",
  1433. })
  1434. }
  1435. /*
  1436. //检索玩家数据
  1437. http://127.0.0.1:8086/gm/user_get?nickname=11&lmin=1&lmax=3&createdate=2020-05-07&banstatus=0&maplevel=2&fmin=1&fmax=3&pnum=1
  1438. nickname 昵称,不需要则不填写去掉nickname=11
  1439. lmin=1&lmax=3 等级,[min,max]区间内
  1440. createdate=2020-05-07 创建角色日期
  1441. lastlogindate=2020-05-07 最后登录日期
  1442. banstatus=0 当前玩家状态:0表示正常1表示封号
  1443. maplevel=10001 关卡进度,格式为mapid * 10000 + maplevel
  1444. fmin=1&fmax=2 队伍战力 [min,max]区间
  1445. pnum=1 表示当前是第几页
  1446. //获取玩家详细信息
  1447. //http://127.0.0.1:8086/gm/info_get?uid=6824453512924037889
  1448. 根据检索玩家数据,得到对应的玩家uid,再使用该url获取玩家的相信信息
  1449. uid=6824453512924037889 玩家uid
  1450. //封号
  1451. //http://127.0.0.1:8086/gm/ban?uid=6824453512924037889&ban=1
  1452. ban=1 1表示封号,0表示解封
  1453. //聊天管理
  1454. //1私聊,2公聊
  1455. //http://127.0.0.1:8086/gm/chat_msg?type=2&uid=6824453512924037889&msgdate=2020-05-05%2021:42:59
  1456. type=2 1私聊,2公聊
  1457. uid=6824453512924037889 玩家uid
  1458. msgdate=2020-05-05%2021:42:59 >=该时间后的所有聊天信息
  1459. //邮件管理
  1460. //http://127.0.0.1:8086/gm/mail?type=list 获取当前的定时邮件列表
  1461. //http://127.0.0.1:8086/gm/mail?type=add&title=title&content=content&reward=101:1,102:3 添加邮件
  1462. //http://127.0.0.1:8086/gm/mail?type=add&title=title&content=content&reward=101:1,102:3&senddate=2020-05-09%2000:00:00 添加邮件
  1463. //http://127.0.0.1:8086/gm/mail?type=del&id=1 删除延迟发送邮件(该邮件还未发送时才会删除成功)
  1464. type=list list获取邮件列表操作,add添加操作,del删除操作
  1465. title=标题 邮件标题
  1466. content=正文 邮件正文
  1467. reward=奖励 邮件奖励,格式: 101:1,102:3,106:222
  1468. */
  1469. //登录的账号和密码
  1470. //[wtgame,wtgame123]
  1471. //需要在请求时带上token
  1472. //发送公告
  1473. //http://127.0.0.1:8086/gm/notice?&token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE1OTAyMzEyNTAsImlhdCI6MTU5MDIyNzY1MH0.PIGt_fXQFai4NJz3sg2LICbQFRFWWwxuak8KkUGtsig&col=<color=%23ff4b14>商城购买12312321!!123123!!!!!!!!!!<%2Fcolor>&count=5&interval=5
  1474. //<color=%23ff4b14>商城购买12312321!!123123!!!!!!!!!!<%2Fcolor>
  1475. //记得修改<color=%23ff4b14>和<%2Fcolor>之间的内容