web_gmmsg.go 43 KB

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