workDesktop.go 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654
  1. package entity
  2. import (
  3. "database/sql"
  4. "encoding/json"
  5. "errors"
  6. "fmt"
  7. "sort"
  8. "strconv"
  9. "strings"
  10. MC "app.yhyue.com/moapp/jybase/common"
  11. "app.yhyue.com/moapp/jybase/encrypt"
  12. "bp.jydev.jianyu360.cn/BaseService/userCenter/rpc/pb"
  13. "github.com/zeromicro/go-zero/core/logx"
  14. )
  15. // WorkDesktopMenu 工作桌面菜单信息
  16. type WorkDesktopMenu struct {
  17. MenuTree []*JYMenu //菜单
  18. UserId string //用户id
  19. NewUserId int64 //base_userid
  20. EntId int64 //企业id
  21. EntUserId int64 //企业用户id
  22. AppId string //appid 剑鱼:10000
  23. IntranetBool bool //是否开启内网访问模式
  24. Platform string //平台来源
  25. WorkStatus int64 //菜单分组
  26. AccountId int64 //账户id
  27. EntAccountId int64 //企业账户id
  28. PositionType int64 //职位类型 0:个人 1:企业
  29. PositionId int64 //职位id
  30. MgoUserId string //原mongo userId -- p278
  31. EntNicheDis int64 //企业角色 默认0:销售 1:企业资讯分配 2:部门资讯分配 3:企业资讯分配+销售 4:部门资讯分配+销售
  32. EntUserRole string //1:情报处理岗 2:情报分配岗 3:信息浏览岗 4:销售管理岗,多个逗号拼接
  33. }
  34. // JYMenu 工作桌面菜单内容
  35. type JYMenu struct {
  36. Id int
  37. Name string //菜单名称
  38. Match string //滤镜过滤正则
  39. OrderId int //菜单排序id
  40. ParentId int //父级id
  41. PowerIds string //权限id
  42. CheckCode int //是否必须验证权限才显示菜单
  43. Url string //菜单跳转链接
  44. Icon string //菜单图标
  45. AdditionalInfo map[string]Additional //附加弹窗信息
  46. AppType string //菜单模式
  47. OpenType string //打开方式
  48. Status int //是否是可用服务
  49. PermissionCode string //功能代码
  50. CapitalCode string //留资代码
  51. CapitalInfo Additional //留资弹窗
  52. Children []*JYMenu //菜单s
  53. Authority int //权限逻辑备注 默认0:功能权限、资源权限、留资权限必须全部满足;1:功能权限或资源权限或留资权限满足其一就行;
  54. Level int //1:一级菜单;2:二级菜单;3:三级菜单;4:四级菜单
  55. Exclude string //不需要显示菜单权限集合
  56. }
  57. type Additional struct {
  58. Title string `json:"title"` //弹窗标题
  59. Content string `json:"content"` //弹窗提示信息
  60. ConfirmUrl string `json:"confirmUrl,optional"` //确认按钮跳转地址
  61. ConfirmText string `json:"confirmText,optional"` //确认按钮
  62. IsShowCancel bool `json:"isShowCancel,optional"` //是否显示取消按钮
  63. AppType string `json:"appType,optional,omitempty"` //跳转方式
  64. OpenType string `json:"openType,optional,omitempty"`
  65. }
  66. // GetMenuTreeData 获取有效菜单数据
  67. func (m *WorkDesktopMenu) GetMenuTreeData() error {
  68. //P278 身份切换
  69. positionType := ``
  70. switch m.PositionType { //职位类型 0:个人 1:企业
  71. case 0:
  72. positionType = `AND available <= 2`
  73. case 1:
  74. positionType = `AND available >= 2`
  75. //P364 企业角色
  76. if m.EntUserRole != "" {
  77. positionType += ` AND (FIND_IN_SET('0',entrole)`
  78. for _, entUserRole := range strings.Split(m.EntUserRole, ",") {
  79. positionType += fmt.Sprintf(` OR FIND_IN_SET('%d',entrole)`, MC.Int64All(entUserRole)+1)
  80. }
  81. positionType += `)`
  82. } else {
  83. positionType += fmt.Sprintf(` AND (FIND_IN_SET('0',entrole) OR FIND_IN_SET('%d',entrole))`, m.EntNicheDis)
  84. }
  85. }
  86. //tidb数据
  87. query := fmt.Sprintf(`SELECT * FROM `+ConfigJson.WorkTableOut+` WHERE appid=? AND status=%d %s ORDER BY id ASC`, m.WorkStatus, positionType)
  88. //是否开启内网访问数据权限---对应 api 配置文件
  89. if m.IntranetBool {
  90. query = fmt.Sprintf(`SELECT * FROM `+ConfigJson.WorkTableInside+` WHERE appid=? AND status>=0 %s ORDER BY id ASC`, positionType)
  91. }
  92. logx.Info(m.PositionId, "query:", query)
  93. menuData := BaseMysql.SelectBySql(query, m.AppId)
  94. if menuData == nil || len(*menuData) == 0 {
  95. return errors.New("查询数据异常")
  96. }
  97. for _, v := range *menuData {
  98. menu := &JYMenu{
  99. Id: MC.IntAll(v["id"]),
  100. Name: MC.ObjToString(v["name"]),
  101. Match: MC.ObjToString(v["match"]),
  102. OrderId: MC.IntAll(v["orderid"]),
  103. ParentId: MC.IntAll(v["parentid"]),
  104. PowerIds: MC.ObjToString(v["powerids"]),
  105. CheckCode: MC.IntAll(v["checkcode"]),
  106. Icon: MC.ObjToString(v["icon"]),
  107. AppType: MC.ObjToString(v["apptype"]),
  108. OpenType: MC.ObjToString(v["opentype"]),
  109. Status: MC.IntAll(v["status"]),
  110. PermissionCode: MC.ObjToString(v["permissioncode"]),
  111. CapitalCode: MC.ObjToString(v["capitalcode"]),
  112. Authority: MC.IntAll(v["authority"]),
  113. Exclude: MC.ObjToString(v["exclude"]),
  114. }
  115. var OpenType = map[string]string{}
  116. if err := json.Unmarshal([]byte(MC.ObjToString(v["opentype"])), &OpenType); err == nil {
  117. menu.OpenType = OpenType[m.Platform]
  118. }
  119. switch m.Platform {
  120. case "WX":
  121. menu.Url = MC.ObjToString(v["wxurl"])
  122. menu.PowerIds = MC.ObjToString(v["wxpids"])
  123. case "APP":
  124. menu.Url = MC.ObjToString(v["appurl"])
  125. menu.PowerIds = MC.ObjToString(v["apppids"])
  126. default:
  127. menu.Url = MC.ObjToString(v["pcurl"])
  128. }
  129. //菜单(移动端)是否需要显示:PC端菜单不需要在移动端显示;或移动端菜单不需要在PC端显示。
  130. //transmit_ 两个不同菜单,需要在不同平台展示,常用功能添加后,能在不同的平台正常访问。如:移动端-运营商专版(搜索)|电脑端-营销(搜索)
  131. if menu.Url == "-1" || strings.HasPrefix(menu.Url, Transmit) {
  132. continue
  133. }
  134. if additionalInfo := MC.ObjToString(v["additionalinfo"]); additionalInfo != "" {
  135. additional := map[string]Additional{}
  136. if json.Unmarshal([]byte(additionalInfo), &additional) == nil {
  137. menu.AdditionalInfo = map[string]Additional{
  138. m.Platform: additional[m.Platform],
  139. }
  140. }
  141. }
  142. if capitalInfo := MC.ObjToString(v["capitalinfo"]); capitalInfo != "" {
  143. additional := Additional{}
  144. if json.Unmarshal([]byte(capitalInfo), &additional) == nil {
  145. menu.CapitalInfo = additional
  146. }
  147. }
  148. if menu.Id > 0 {
  149. m.MenuTree = append(m.MenuTree, menu)
  150. }
  151. }
  152. return nil
  153. }
  154. // WorkMenuTree 菜单-格式化-tree
  155. func (m *WorkDesktopMenu) WorkMenuTree(parentId int) (jyMenu []*JYMenu) {
  156. jyMenu = make([]*JYMenu, 0)
  157. for _, mv := range m.MenuTree {
  158. if mv.ParentId == parentId {
  159. mv.Children = m.WorkMenuTree(mv.Id)
  160. sort.SliceStable(mv.Children, func(i, j int) bool {
  161. return mv.Children[i].OrderId < mv.Children[j].OrderId
  162. })
  163. jyMenu = append(jyMenu, mv)
  164. }
  165. }
  166. sort.SliceStable(jyMenu, func(i, j int) bool {
  167. return jyMenu[i].OrderId < jyMenu[j].OrderId
  168. })
  169. return
  170. }
  171. // WorkMenuFormat 菜单 格式化
  172. func (m *WorkDesktopMenu) WorkMenuFormat() ([]*pb.MenuList, error) {
  173. //logx.Info("树的长度:", len(m.MenuTree))
  174. menuList := make([]*pb.MenuList, 0)
  175. for _, mv := range m.MenuTree {
  176. //if mv.Id < 466 {
  177. // continue
  178. //}
  179. //0:默认展示;1:需验证权限,有权限展示;2:需验证权限,无权限也可展示(可用服务无权限不展示)
  180. pBool := m.VerifyPermissions(mv.PowerIds, mv.Exclude)
  181. //checkCode==1 验证权限结果 无权限不显示
  182. if !pBool.HasBool && mv.CheckCode == 1 {
  183. continue
  184. }
  185. //有权限 验证是否需要展示--->excludeBool
  186. if pBool.ExcludeBool {
  187. continue
  188. }
  189. //GetResources(m.AppId, m.NewUserId, m.EntId, m.EntUserId)
  190. oneLevel := &pb.MenuList{
  191. Name: mv.Name,
  192. Icon: mv.Icon,
  193. Url: mv.Url,
  194. Id: encrypt.SE.EncodeString(strconv.Itoa(mv.Id)), //功能id加密
  195. Usable: pBool.HasBool, //MC.If(mv.PowerIds != "", usable && mv.CheckCode == 1, true).(bool),
  196. AppType: mv.AppType,
  197. OpenType: mv.OpenType,
  198. Child: []*pb.SecondLevelMenu{},
  199. TipInfo: &pb.TipInfo{
  200. Title: mv.AdditionalInfo[m.Platform].Title,
  201. Content: mv.AdditionalInfo[m.Platform].Content,
  202. ConfirmUrl: mv.AdditionalInfo[m.Platform].ConfirmUrl,
  203. ConfirmText: mv.AdditionalInfo[m.Platform].ConfirmText,
  204. IsShowCancel: mv.AdditionalInfo[m.Platform].IsShowCancel,
  205. AppType: mv.AdditionalInfo[m.Platform].AppType,
  206. OpenType: mv.AdditionalInfo[m.Platform].OpenType,
  207. },
  208. Match: MC.If(mv.Match != "", strings.Split(mv.Match, ","), []string{}).([]string),
  209. }
  210. if len(mv.Children) > 0 {
  211. for _, sv := range mv.Children {
  212. //0:默认展示;1:需验证权限,有权限展示;2:需验证权限,无权限也可展示(可用服务无权限不展示)
  213. pBool := m.VerifyPermissions(sv.PowerIds, sv.Exclude)
  214. //checkCode==1 验证权限结果 无权限不显示
  215. if !pBool.HasBool && sv.CheckCode == 1 {
  216. continue
  217. }
  218. //有权限 验证是否需要展示--->excludeBool
  219. if pBool.ExcludeBool {
  220. continue
  221. }
  222. secondLevel := &pb.SecondLevelMenu{
  223. Name: sv.Name,
  224. Icon: sv.Icon,
  225. Url: sv.Url,
  226. Id: encrypt.SE.EncodeString(strconv.Itoa(sv.Id)), //功能id加密
  227. Usable: pBool.HasBool, //MC.If(sv.PowerIds != "", usable && sv.CheckCode == 1, true).(bool),
  228. Child: []*pb.ThreeLevelMenu{},
  229. AppType: sv.AppType,
  230. OpenType: sv.OpenType,
  231. TipInfo: &pb.TipInfo{
  232. Title: sv.AdditionalInfo[m.Platform].Title,
  233. Content: sv.AdditionalInfo[m.Platform].Content,
  234. ConfirmUrl: sv.AdditionalInfo[m.Platform].ConfirmUrl,
  235. ConfirmText: sv.AdditionalInfo[m.Platform].ConfirmText,
  236. IsShowCancel: sv.AdditionalInfo[m.Platform].IsShowCancel,
  237. AppType: sv.AdditionalInfo[m.Platform].AppType,
  238. OpenType: sv.AdditionalInfo[m.Platform].OpenType,
  239. },
  240. Match: MC.If(sv.Match != "", strings.Split(sv.Match, ","), []string{}).([]string),
  241. }
  242. if len(sv.Children) > 0 {
  243. for _, tv := range sv.Children {
  244. //附件下载包、采购单位画像记录、企业画像记录 如果是大会员 排除此三项菜单
  245. //灵活性降低
  246. if (tv.Name == "采购单位画像记录" && m.VerifyPermissions("5", "").HasBool) || (tv.Name == "企业画像记录" && m.VerifyPermissions("4,12,13,19,20,21,23", "").HasBool) {
  247. continue
  248. }
  249. //0:默认展示;1:需验证权限,有权限展示;2:需验证权限,无权限也可展示(可用服务无权限不展示)
  250. pBool := m.VerifyPermissions(tv.PowerIds, tv.Exclude)
  251. //checkCode==1 验证权限结果 无权限不显示
  252. if !pBool.HasBool && tv.CheckCode == 1 {
  253. continue
  254. }
  255. //有权限 验证是否需要展示--->excludeBool
  256. if pBool.ExcludeBool {
  257. continue
  258. }
  259. var (
  260. //数据库默认提示弹窗信息
  261. title, content, confirmUrl, confirmText, isShowCancel, appType, openType, feasibility = tv.AdditionalInfo[m.Platform].Title, tv.AdditionalInfo[m.Platform].Content, tv.AdditionalInfo[m.Platform].ConfirmUrl, tv.AdditionalInfo[m.Platform].ConfirmText, tv.AdditionalInfo[m.Platform].IsShowCancel, tv.AdditionalInfo[m.Platform].AppType, tv.AdditionalInfo[m.Platform].OpenType, pBool.HasBool
  262. )
  263. //三级菜单------
  264. if len(tv.Children) == 0 && (tv.CapitalCode != "" || tv.PermissionCode != "") {
  265. //用户是否需要留资
  266. //资源中台获取用户权限--没有权限:title等置空
  267. //ResourceLib.PowerHandle()
  268. title, content, confirmUrl, confirmText, appType, openType, isShowCancel, feasibility = CheckCapitalResources(tv, m, pBool.HasBool, m.VerifyPermissions(tv.PermissionCode, "").HasBool, sv.Url)
  269. }
  270. //弹框地址处理
  271. threeLevel := &pb.ThreeLevelMenu{
  272. Name: tv.Name,
  273. Icon: tv.Icon,
  274. Url: tv.Url,
  275. Id: encrypt.SE.EncodeString(strconv.Itoa(tv.Id)), //功能id加密
  276. Usable: feasibility, //MC.If(tv.PowerIds != "", usable && tv.CheckCode == 1, true).(bool),
  277. AppType: tv.AppType,
  278. OpenType: tv.OpenType,
  279. TipInfo: &pb.TipInfo{
  280. Title: title,
  281. Content: content,
  282. ConfirmUrl: confirmUrl,
  283. ConfirmText: confirmText,
  284. IsShowCancel: isShowCancel,
  285. AppType: appType,
  286. OpenType: openType,
  287. },
  288. Match: MC.If(tv.Match != "", strings.Split(tv.Match, ","), []string{}).([]string),
  289. }
  290. if len(tv.Children) > 0 {
  291. L:
  292. for _, fv := range tv.Children {
  293. if fv.Name == "" {
  294. continue
  295. }
  296. if fv.CapitalCode != "" || fv.PermissionCode != "" {
  297. //用户是否需要留资
  298. //资源中台获取用户权限--没有权限:title等置空
  299. //ResourceLib.PowerHandle()
  300. //判断资源中台权限
  301. title, content, confirmUrl, confirmText, appType, openType, isShowCancel, feasibility = CheckCapitalResources(fv, m, pBool.HasBool, m.VerifyPermissions(fv.PermissionCode, "").HasBool, tv.Url)
  302. }
  303. threeLevel.Url = MC.If(fv.Url != "", fv.Url, tv.Url).(string)
  304. threeLevel.Icon = MC.If(fv.Icon != "", fv.Icon, tv.Icon).(string)
  305. threeLevel.AppType = fv.AppType
  306. threeLevel.OpenType = fv.OpenType
  307. threeLevel.Usable = feasibility
  308. if title != "" {
  309. threeLevel.TipInfo = &pb.TipInfo{
  310. Title: title,
  311. Content: content,
  312. ConfirmUrl: confirmUrl,
  313. ConfirmText: confirmText,
  314. IsShowCancel: isShowCancel,
  315. AppType: appType,
  316. OpenType: openType,
  317. }
  318. }
  319. threeLevel.Match = MC.If(fv.Match != "", strings.Split(fv.Match, ","), []string{}).([]string)
  320. //四级菜单必须有顺序性,大会员》商机管理》超级订阅》免费用户
  321. name := MC.If(strings.Contains(fv.Name, "-"), strings.Split(fv.Name, "-")[0], "免费").(string)
  322. if len(UserRolePowers[name]) > 0 && m.VerifyPermissions(strings.Join(UserRolePowers[name], ","), "").HasBool && m.VerifyPermissions(fv.PowerIds, "").HasBool {
  323. break L
  324. }
  325. }
  326. }
  327. //无资源中台权限 菜单不显示
  328. if !feasibility && tv.CheckCode == 1 {
  329. continue
  330. }
  331. if threeLevel != nil {
  332. secondLevel.Child = append(secondLevel.Child, threeLevel)
  333. }
  334. }
  335. }
  336. //二级菜单 有三级子菜单;才会显示
  337. if len(secondLevel.Child) == 0 && sv.CheckCode == 1 {
  338. continue
  339. }
  340. oneLevel.Child = append(oneLevel.Child, secondLevel)
  341. }
  342. }
  343. //一级菜单 有二级子菜单;才会显示
  344. if len(oneLevel.Child) == 0 && mv.CheckCode == 1 {
  345. continue
  346. }
  347. menuList = append(menuList, oneLevel)
  348. }
  349. //清用户内存信息
  350. func(baseUserid int64, appId, userId string) {
  351. OverallLock.Lock()
  352. defer OverallLock.Unlock()
  353. userInfo := UserInfoMap[baseUserid]
  354. if userInfo != nil {
  355. userInfo.Lock.Lock()
  356. defer userInfo.Lock.Unlock()
  357. userInfo.Permissions = map[string]int{}
  358. userInfo.Capitals = map[string]int{}
  359. }
  360. }(m.NewUserId, m.AppId, m.UserId)
  361. //bytes, _ := json.MarshalIndent(menuList, "", " ")
  362. //fmt.Printf("%s\n", bytes)
  363. return menuList, nil
  364. }
  365. type PowersBool struct {
  366. HasBool bool
  367. ExcludeBool bool
  368. }
  369. // VerifyPermissions 是否有权限可用此服务
  370. func (m *WorkDesktopMenu) VerifyPermissions(powerIds string, excludeCodes string) (pb *PowersBool) {
  371. pb = &PowersBool{}
  372. if powerIds == "" {
  373. pb.HasBool = true
  374. }
  375. if powerIds != "" || excludeCodes != "" {
  376. userPower := m.AutoUserPowerInfo() //m.TimeOut, m.BigMemberOff,
  377. if len(strings.Split(powerIds, ",")) > 0 {
  378. for _, pv := range strings.Split(powerIds, ",") {
  379. //同时满足
  380. if pvs := strings.Split(pv, "+"); len(pvs) > 1 {
  381. var pi int
  382. for _, v := range pvs {
  383. if userPower[v] > 0 {
  384. pi++
  385. }
  386. }
  387. if pi == len(pvs) {
  388. pb.HasBool = true
  389. break
  390. }
  391. } else if userPower[pv] > 0 {
  392. pb.HasBool = true
  393. break
  394. }
  395. }
  396. }
  397. if len(strings.Split(excludeCodes, ",")) > 0 {
  398. for _, pv := range strings.Split(excludeCodes, ",") {
  399. //同时满足
  400. if ecs := strings.Split(pv, "+"); len(ecs) > 1 {
  401. var ei int
  402. for _, v := range ecs {
  403. if userPower[v] > 0 {
  404. ei++
  405. }
  406. }
  407. if ei == len(ecs) {
  408. pb.ExcludeBool = true
  409. break
  410. }
  411. } else if userPower[pv] > 0 {
  412. pb.ExcludeBool = true
  413. break
  414. }
  415. }
  416. }
  417. }
  418. return
  419. }
  420. // WorkCommonly 常用功能
  421. var (
  422. WorkCommonly = "work_commonly"
  423. //WorkMenu = "work_menu"
  424. )
  425. // CommonlyUpdate 更新常用功能
  426. func CommonlyUpdate(in *pb.WorkDesktopComprehensiveReq) (B bool, M string) {
  427. //事务 1:查; 2: 存;3: 删;
  428. var (
  429. ids []string
  430. mk int
  431. )
  432. for _, mid := range strings.Split(in.MenuIds, ",") {
  433. if mid == "" {
  434. continue
  435. }
  436. //id 解密
  437. ids = append(ids, encrypt.SE.DecodeString(mid))
  438. mk++
  439. //常用功能数量限制
  440. if ConfigJson.CommonlySize > 0 && mk >= int(ConfigJson.CommonlySize) {
  441. break
  442. }
  443. }
  444. if in.UserId != "" {
  445. //更新此用户设置的常用功能
  446. if B = BaseMysql.ExecTx("常用功能批量更新", func(tx *sql.Tx) bool {
  447. //查询此用户常用功能是否已存在记录
  448. var (
  449. id = 0
  450. existingData *[]map[string]interface{}
  451. )
  452. //P278 身份切换 常用功能和职业id 绑定
  453. existingData = BaseMysql.SelectBySqlByTx(tx, `SELECT id FROM `+WorkCommonly+` WHERE base_userid = ? AND appid = ? AND field = ? AND userid = ? ORDER BY id DESC `, in.NewUserId, in.AppId, in.ActionMode, in.UserId)
  454. if existingData != nil && len(*existingData) > 0 {
  455. id = MC.IntAll((*existingData)[0]["id"])
  456. //} else {
  457. // //P278 之前版本查询逻辑
  458. // existingData = BaseMysql.SelectBySqlByTx(tx, `SELECT id FROM `+WorkCommonly+` WHERE base_userid = ? AND appid = ? AND field = ? ORDER BY id DESC `, in.NewUserId, in.AppId, in.ActionMode)
  459. // if existingData != nil && len(*existingData) > 0 {
  460. // id = MC.IntAll((*existingData)[0]["id"])
  461. // }
  462. }
  463. switch {
  464. case id > 0: //更新
  465. if BaseMysql.UpdateOrDeleteBySqlByTx(tx, `UPDATE `+WorkCommonly+` SET value = ?,userid = ? WHERE id = ?`, strings.Join(ids, ","), in.UserId, id) < 0 {
  466. logx.Info("常用功能-更新数据失败")
  467. return false
  468. }
  469. default: //插入
  470. if BaseMysql.InsertBySqlByTx(tx, `INSERT INTO `+WorkCommonly+` (appid,base_userid,platform,field,value,userid) VALUES (?,?,?,?,?,?)`, in.AppId, in.NewUserId, in.Platform, in.ActionMode, strings.Join(ids, ","), in.UserId) < 0 {
  471. logx.Info("常用功能-插入数据失败")
  472. return false
  473. }
  474. }
  475. return true
  476. }); !B {
  477. M = "常用功能更新数据失败"
  478. }
  479. }
  480. return
  481. }
  482. // 常用功能 隐藏 菜单
  483. func (m *WorkDesktopMenu) ExcludeMenu(mv *JYMenu) (ep bool) {
  484. cm := &JYMenu{
  485. Id: mv.Id,
  486. Name: mv.Name,
  487. ParentId: mv.ParentId,
  488. PowerIds: mv.PowerIds,
  489. CheckCode: mv.CheckCode,
  490. Level: mv.Level,
  491. Exclude: mv.Exclude,
  492. }
  493. level := cm.Level
  494. for i := 0; i < level; i++ {
  495. pBool := m.VerifyPermissions(cm.PowerIds, cm.Exclude)
  496. if pBool.ExcludeBool {
  497. ep = true
  498. continue
  499. }
  500. wmn := BaseMysql.SelectBySql(`SELECT * FROM base_service.work_menu_new wmn WHERE wmn.id = ?`, cm.ParentId)
  501. if wmn == nil || len(*wmn) == 0 {
  502. break
  503. }
  504. if cm.ParentId == 0 {
  505. break
  506. }
  507. cm = &JYMenu{
  508. Id: MC.IntAll((*wmn)[0]["id"]),
  509. Name: MC.InterfaceToStr((*wmn)[0]["name"]),
  510. ParentId: MC.IntAll((*wmn)[0]["parentid"]),
  511. PowerIds: MC.InterfaceToStr((*wmn)[0]["powerids"]),
  512. CheckCode: MC.IntAll((*wmn)[0]["checkcode"]),
  513. Level: MC.IntAll((*wmn)[0]["level"]),
  514. Exclude: MC.InterfaceToStr((*wmn)[0]["exclude"]),
  515. }
  516. }
  517. return
  518. }
  519. // CommonlyFormat 常用功能 格式化
  520. func (m *WorkDesktopMenu) CommonlyFormat(childMenus map[int][]*JYMenu) ([]*pb.ThreeLevelMenu, []string, bool) {
  521. menuList := make([]*pb.ThreeLevelMenu, 0)
  522. subLevel := map[int]bool{}
  523. delBool := false //更新因超级订阅用户,又购买大会员得用户 导致附件下载包||采购单位画像记录||企业画像记录 不应该展示
  524. var saveIds []string
  525. for _, mv := range m.MenuTree {
  526. //三级菜单已处理,子级四级菜单不再处理
  527. //过滤子级 ++
  528. if subLevel[mv.ParentId] {
  529. continue
  530. }
  531. //三级下架菜单:mv.Status == 1
  532. if mv.Status == 1 {
  533. delBool = true
  534. continue
  535. }
  536. //附件下载包、采购单位画像记录、企业画像记录 如果是大会员 排除此三项菜单
  537. //灵活性降低
  538. if (mv.Name == "采购单位画像记录" && m.VerifyPermissions("5", "").HasBool) || (mv.Name == "企业画像记录" && m.VerifyPermissions("4,12,13,19,20,21,23", "").HasBool) {
  539. delBool = true
  540. continue
  541. }
  542. if m.ExcludeMenu(mv) {
  543. delBool = true
  544. continue
  545. }
  546. //0:默认展示;1:需验证权限,有权限展示;2:需验证权限,无权限也可展示(可用服务无权限不展示)
  547. pBool := m.VerifyPermissions(mv.PowerIds, mv.Exclude)
  548. if pBool.ExcludeBool {
  549. delBool = true
  550. continue
  551. }
  552. feasibility := pBool.HasBool
  553. //三级菜单------
  554. if len(childMenus[mv.Id]) == 0 && (mv.CapitalCode != "" || mv.PermissionCode != "") {
  555. _, _, _, _, _, _, _, feasibility = CheckCapitalResources(mv, m, pBool.HasBool, m.VerifyPermissions(mv.PermissionCode, "").HasBool, "")
  556. }
  557. saveIds = append(saveIds, encrypt.SE.EncodeString(strconv.Itoa(mv.Id)))
  558. subLevel[mv.Id] = true
  559. oneLevel := &pb.ThreeLevelMenu{
  560. Name: mv.Name,
  561. Icon: mv.Icon,
  562. Url: mv.Url,
  563. Id: encrypt.SE.EncodeString(strconv.Itoa(mv.Id)), //功能id加密
  564. Usable: feasibility, //MC.If(mv.PowerIds != "", usable && mv.CheckCode == 1, true).(bool),
  565. AppType: mv.AppType,
  566. OpenType: mv.OpenType,
  567. TipInfo: &pb.TipInfo{
  568. Title: mv.AdditionalInfo[m.Platform].Title,
  569. Content: mv.AdditionalInfo[m.Platform].Content,
  570. ConfirmUrl: mv.AdditionalInfo[m.Platform].ConfirmUrl,
  571. ConfirmText: mv.AdditionalInfo[m.Platform].ConfirmText,
  572. IsShowCancel: mv.AdditionalInfo[m.Platform].IsShowCancel,
  573. AppType: mv.AppType,
  574. OpenType: mv.OpenType,
  575. },
  576. Match: MC.If(mv.Match != "", strings.Split(mv.Match, ","), []string{}).([]string),
  577. }
  578. //处理子级
  579. if childMenus[mv.Id] != nil && len(childMenus[mv.Id]) > 0 {
  580. childMenu := childMenus[mv.Id]
  581. sort.Slice(childMenu, func(i, j int) bool {
  582. return childMenu[i].OrderId < childMenu[j].OrderId
  583. })
  584. L:
  585. for _, cv := range childMenu {
  586. //cv.Status < 0 四级菜单 生效不再处理;因为常用功能设置保存的都是三级菜单id,如果三级菜单功能下架,只处理三级菜单。
  587. if cv.Name == "" || cv.ParentId != mv.Id || cv.Status < 0 {
  588. continue
  589. }
  590. if cv.CapitalCode != "" || cv.PermissionCode != "" {
  591. _, _, _, _, _, _, _, feasibility = CheckCapitalResources(cv, m, pBool.HasBool, m.VerifyPermissions(cv.PermissionCode, "").HasBool, mv.Url)
  592. }
  593. oneLevel.Url = MC.If(cv.Url != "", cv.Url, mv.Url).(string)
  594. oneLevel.Icon = MC.If(cv.Icon != "", cv.Icon, mv.Icon).(string)
  595. oneLevel.AppType = cv.AppType
  596. oneLevel.OpenType = cv.OpenType
  597. oneLevel.Usable = feasibility
  598. if cv.AdditionalInfo[m.Platform].Title != "" {
  599. oneLevel.TipInfo = &pb.TipInfo{
  600. Title: cv.AdditionalInfo[m.Platform].Title,
  601. Content: cv.AdditionalInfo[m.Platform].Content,
  602. ConfirmUrl: cv.AdditionalInfo[m.Platform].ConfirmUrl,
  603. ConfirmText: cv.AdditionalInfo[m.Platform].ConfirmText,
  604. IsShowCancel: cv.AdditionalInfo[m.Platform].IsShowCancel,
  605. AppType: cv.AppType,
  606. OpenType: cv.OpenType,
  607. }
  608. }
  609. oneLevel.Match = MC.If(cv.Match != "", strings.Split(cv.Match, ","), []string{}).([]string)
  610. name := MC.If(strings.Contains(cv.Name, "-"), strings.Split(cv.Name, "-")[0], "免费").(string)
  611. if len(UserRolePowers[name]) > 0 && m.VerifyPermissions(strings.Join(UserRolePowers[name], ","), "").HasBool {
  612. break L
  613. }
  614. }
  615. }
  616. //跨平台,非本平台功能,给用户提示信息
  617. if oneLevel.Url == "-1" {
  618. oneLevel.TipInfo = &pb.TipInfo{
  619. Title: ConfigJson.DefaultPopup[m.Platform].Title,
  620. Content: ConfigJson.DefaultPopup[m.Platform].Content,
  621. ConfirmUrl: ConfigJson.DefaultPopup[m.Platform].ConfirmUrl,
  622. ConfirmText: ConfigJson.DefaultPopup[m.Platform].ConfirmText,
  623. IsShowCancel: ConfigJson.DefaultPopup[m.Platform].IsShowCancel,
  624. }
  625. if oneLevel.TipInfo.ConfirmUrl == "" {
  626. oneLevel.TipInfo.AppType = ""
  627. oneLevel.TipInfo.OpenType = ""
  628. }
  629. oneLevel.Url = ""
  630. oneLevel.Usable = false
  631. }
  632. //1、当前平台有权限,清空提示信息
  633. //2、提示信息内容为空,清空提示信息
  634. if oneLevel.Usable || oneLevel.TipInfo.Content == "" {
  635. oneLevel.TipInfo = &pb.TipInfo{}
  636. }
  637. menuList = append(menuList, oneLevel)
  638. }
  639. return menuList, saveIds, delBool
  640. }