SystemController.go 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "strconv"
  6. "strings"
  7. "time"
  8. "git.qianqiusoft.com/qianqiusoft/light-apiengine/models"
  9. "git.qianqiusoft.com/qianqiusoft/light-apiengine/entitys"
  10. sysmodel "git.qianqiusoft.com/qianqiusoft/light-apiengine/models"
  11. "git.qianqiusoft.com/qianqiusoft/light-apiengine/utils"
  12. )
  13. //https://www.kancloud.cn/xormplus/xorm/167077
  14. // _Login
  15. // @Title _Login
  16. // @Description 用户登录
  17. // @Param logininfo false "登录信息"
  18. // @Success 200 {object} sysmodel.Account
  19. // @Failure 403 :id is empty
  20. func System_Login(c *SystemController) {
  21. var logininfo sysmodel.LoginInfo
  22. c.Ctx.BindJSON(&logininfo)
  23. __none_func_system__(logininfo)
  24. fmt.Println(logininfo)
  25. var user sysmodel.SysUser
  26. ret, err := c.Db.SQL(sysmodel.SqlUserLogin, logininfo.Account).Get(&user)
  27. if ret && err == nil {
  28. //TODO check password
  29. timestamp := uint64(time.Now().UnixNano())
  30. md5Pwd := utils.HashPassword(logininfo.Password, "")
  31. //密码错误
  32. if !strings.EqualFold(user.Password, md5Pwd) {
  33. c.Ctx.JSON(200, sysmodel.SysReturn{400, "passowrd incorrect!", nil})
  34. return
  35. }
  36. token := &entitys.Token{}
  37. if v := utils.GlobalTokenStore.Get(logininfo.Account + user.Domain); v == nil {
  38. timestamp_str := strconv.FormatUint(timestamp, 10)
  39. sec_tooken := utils.GenerateToken(logininfo.Account + timestamp_str)
  40. token.AccessToken = sec_tooken
  41. token.RefreshToken = sec_tooken
  42. token.LoginID = logininfo.Account
  43. token.UserId = user.Id
  44. token.Result = 200
  45. //token.Password = pwd
  46. token.ServerIp = ""
  47. token.Domain = user.Domain
  48. utils.GlobalTokenStore.Set(sec_tooken, token)
  49. //设置session
  50. //fmt.Println("----------set token ----------", token.AccessToken)
  51. //session := sessions.Default(c.Ctx)
  52. //session.Set("token", token.AccessToken)
  53. //session.Save()
  54. } else {
  55. token = v
  56. }
  57. data := sysmodel.LoginReturnInfo{user.Id, user.LoginId, token.AccessToken}
  58. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", data})
  59. } else {
  60. //fmt.Println(err.Error())
  61. c.Ctx.JSON(200, sysmodel.SysReturn{400, "username or passowrd incorrect!", nil})
  62. }
  63. }
  64. // _Logout
  65. // @Title _Logout
  66. // @Description 用户退出
  67. // @Success 200 {object} sysmodel.Account
  68. // @Failure 403 :id is empty
  69. func System_Logout(c *SystemController) {
  70. token := c.Ctx.GetHeader("token")
  71. fmt.Println("delete token: ", token)
  72. utils.GlobalTokenStore.Remove(token)
  73. ret := __none_func_system__()
  74. if ret {
  75. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  76. } else {
  77. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  78. }
  79. }
  80. // _GetNavTree
  81. // @Title _GetNavTree
  82. // @Description 获取导航菜单
  83. // @Param user string false "用户id"
  84. // @Success 200 {object} models.Account
  85. // @Failure 403 :id is empty
  86. func System_GetNavTree(c *SystemController) {
  87. user_id := c.Ctx.GetString("user_id")
  88. ret := __none_func_system__(user_id)
  89. var menus []sysmodel.SysMenuTree
  90. c.Db.SQL(sysmodel.Selectall_nav_tree, user_id).Find(&menus)
  91. var menutree []sysmodel.SysMenuTree
  92. finChildrenMenu(&menus, "", nil, &menutree)
  93. for i := 0; i < len(menutree); i++ {
  94. finChildrenMenu(&menus, menutree[i].Id, &menutree[i], &menutree)
  95. }
  96. if ret {
  97. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", menutree})
  98. }
  99. }
  100. // _GetMenuTree
  101. // @Title _GetMenuTree
  102. // @Description 获取系统菜单
  103. // @Param user string false "用户id"
  104. // @Success 200 {object} sysmodel.Account
  105. // @Failure 403 :id is empty
  106. func System_GetMenuTree(c *SystemController) {
  107. user := c.Ctx.Param(":user")
  108. ret := __none_func_system__(user)
  109. var menus []sysmodel.SysMenuTree
  110. c.Db.SQL(sysmodel.Selectall_sys_menu).Find(&menus)
  111. var menutree []sysmodel.SysMenuTree
  112. finChildrenMenu(&menus, "", nil, &menutree)
  113. for i := 0; i < len(menutree); i++ {
  114. finChildrenMenu(&menus, menutree[i].Id, &menutree[i], &menutree)
  115. }
  116. if ret {
  117. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", menutree})
  118. }
  119. }
  120. // _GetOrgTree
  121. // @Title _GetOrgTree
  122. // @Description 获取组织架构树
  123. // @Success 200 {object} sysmodel.Account
  124. // @Failure 403 :id is empty
  125. func System_GetOrgTree(c *SystemController) {
  126. ret := __none_func_system__()
  127. var orgs []sysmodel.SysOrgTree
  128. c.Db.SQL(sysmodel.Selectall_sys_org).Find(&orgs)
  129. var orgtree []sysmodel.SysOrgTree
  130. finChildrenOrg(&orgs, "", nil, &orgtree)
  131. for i := 0; i < len(orgtree); i++ {
  132. finChildrenOrg(&orgs, orgtree[i].Id, &orgtree[i], &orgtree)
  133. }
  134. if ret {
  135. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", orgtree})
  136. } else {
  137. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  138. }
  139. }
  140. func finChildrenOrg(menus *[]sysmodel.SysOrgTree, parent string, parent_menu *sysmodel.SysOrgTree, menutree *[]sysmodel.SysOrgTree) {
  141. for _, m := range *menus {
  142. if m.Parent == parent {
  143. if parent_menu == nil {
  144. *menutree = append(*menutree, m)
  145. //finChildrenMenu(menus, m.Id, menutree[len(*menutree)-1], menutree)
  146. } else {
  147. parent_menu.Children = append(parent_menu.Children, m)
  148. finChildrenOrg(menus, m.Id, &parent_menu.Children[len(parent_menu.Children)-1], menutree)
  149. }
  150. }
  151. }
  152. }
  153. func finChildrenMenu(menus *[]sysmodel.SysMenuTree, parent string, parent_menu *sysmodel.SysMenuTree, menutree *[]sysmodel.SysMenuTree) {
  154. for _, m := range *menus {
  155. if m.Parent == parent {
  156. if parent_menu == nil {
  157. m.Level = 0
  158. m.ParentName = ""
  159. *menutree = append(*menutree, m)
  160. //finChildrenMenu(menus, m.Id, menutree[len(*menutree)-1], menutree)
  161. } else {
  162. m.Level = parent_menu.Level + 1
  163. m.ParentName = parent_menu.Name
  164. parent_menu.Children = append(parent_menu.Children, m)
  165. finChildrenMenu(menus, m.Id, &parent_menu.Children[len(parent_menu.Children)-1], menutree)
  166. }
  167. }
  168. }
  169. }
  170. // _FindUserPage
  171. // @Title _FindUserPage
  172. // @Description 获取用户分布数据
  173. // @Param page false "分页参数"
  174. // @Success 200 {object} sysmodel.Account
  175. // @Failure 403 :id is empty
  176. func System_FindUserPage(c *SystemController) {
  177. var getpageinfo sysmodel.GetPageInfo
  178. c.Ctx.BindJSON(&getpageinfo)
  179. __none_func_system__(getpageinfo)
  180. page := sysmodel.PageResult{}
  181. var users []sysmodel.UserInfo
  182. dbSession := c.Db.Table("sys_user")
  183. dbSession.Select("sys_user.*, sys_org.name org_name")
  184. countSession := c.Db.Table("sys_user")
  185. JoinTables := []models.Join{}
  186. //JoinTables = append(JoinTables, models.Join{TabelName: "sys_user_role", Condition: "sys_user_role.user_id = sys_user.id", JoinOperator: "left"})
  187. //JoinTables = append(JoinTables, models.Join{TabelName: "sys_role", Condition: "sys_user_role.role_id = sys_role.id", JoinOperator: "left"})
  188. JoinTables = append(JoinTables, models.Join{TabelName: "sys_org", Condition: "sys_org.id = sys_user.org_id", JoinOperator: "left"})
  189. for _, join := range JoinTables {
  190. dbSession = dbSession.Join(join.JoinOperator, join.TabelName, join.Condition)
  191. countSession = countSession.Join(join.JoinOperator, join.TabelName, join.Condition)
  192. }
  193. whereStr, datas, err := getpageinfo.Filter.Parse("")
  194. dbSession = dbSession.Where(whereStr, datas...)
  195. countSession = countSession.Where(whereStr, datas...)
  196. sidx := strings.Split(getpageinfo.Sidx, ",")
  197. for _, order := range sidx {
  198. order = strings.TrimSpace(order)
  199. if len(order) == 0 {
  200. continue
  201. }
  202. if strings.ToLower(getpageinfo.Sord) == "desc" {
  203. dbSession = dbSession.OrderBy(order + " desc")
  204. } else {
  205. dbSession = dbSession.OrderBy(order + " asc")
  206. }
  207. }
  208. totalPage, _ := countSession.Count()
  209. dbSession.Limit(getpageinfo.PageSize, (getpageinfo.PageNum-1)*getpageinfo.PageSize).Find(&users)
  210. //查找每个用户的角色
  211. for i, user := range users {
  212. roles := []sysmodel.UserInfo{}
  213. err := c.Db.SQL(sysmodel.SqlSelectUserRoles, user.Id).Find(&roles)
  214. if err != nil {
  215. fmt.Println("----", err.Error())
  216. continue
  217. }
  218. users[i].UserRole = roles[0].UserRole
  219. users[i].RoleName = roles[0].RoleName
  220. }
  221. page.Content = users
  222. page.PageSize = getpageinfo.PageSize
  223. page.PageNum = getpageinfo.PageNum
  224. page.TotalSize = int(totalPage)
  225. if err == nil {
  226. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", page})
  227. } else {
  228. fmt.Println(err.Error())
  229. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  230. }
  231. }
  232. // _AddUser
  233. // @Title _AddUser
  234. // @Description 添加用户
  235. // @Param login_id string false "登录ID"
  236. // @Param password string false "密码"
  237. // @Param org_id string false "组织ID"
  238. // @Param email string false "邮箱"
  239. // @Success 200 {object} models.Account
  240. // @Failure 403 :id is empty
  241. func System_AddUser(c *SystemController) {
  242. var user sysmodel.SysUser
  243. c.Ctx.BindJSON(&user)
  244. fmt.Println(user.LoginId, "-----add user-----", user.Password, " --- ", user.OrgId)
  245. //查找login_id是否存在
  246. oldUser := new(sysmodel.SysUser)
  247. count, _ := c.Db.SQL("select * from sys_user").Where("login_id = ?", user.LoginId).Count(&oldUser)
  248. if count > 1 {
  249. if oldUser.DelFlag == 0 {
  250. oldUser.DelFlag = 1
  251. _, err := c.Db.Id("id").Cols("del_flag").Update(&oldUser)
  252. if err != nil {
  253. c.Ctx.JSON(200, sysmodel.SysReturn{500, "login_id exit, update err: " + err.Error(), nil})
  254. }
  255. } else {
  256. c.Ctx.JSON(200, sysmodel.SysReturn{500, "login_id exit", nil})
  257. return
  258. }
  259. }
  260. user_id := c.Ctx.GetString("user_id")
  261. user.Id = utils.NewUUID()
  262. user.Name = user.LoginId
  263. user.CreateTime = time.Now()
  264. user.LastUpdateDate = time.Now()
  265. user.CreateBy = user_id
  266. user.LastUpdateBy = user_id
  267. user.DelFlag = 1
  268. user.Password = utils.HashPassword(user.Password, "")
  269. _, err := c.Db.Insert(&user)
  270. ret := __none_func_system__(user.LoginId, user.Password, user.OrgId, user.Email)
  271. if ret && err == nil {
  272. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  273. } else {
  274. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  275. }
  276. }
  277. // _DelUser
  278. // @Title _DelUser
  279. // @Description 删除用户
  280. // @Param id string false "用户ID"
  281. // @Success 200 {object} models.Account
  282. // @Failure 403 :id is empty
  283. func System_DelUser(c *SystemController) {
  284. type Param struct {
  285. Id string `json:"id"`
  286. }
  287. var params []Param
  288. c.Ctx.BindJSON(&params)
  289. ids := []string{}
  290. for _, param := range params {
  291. ids = append(ids, param.Id)
  292. }
  293. session := c.Db.NewSession()
  294. defer session.Close()
  295. //_, err := c.Db.Table(new(models.SysUser)).ID(param.Id).Update(map[string]interface{}{"del_flag": 0})
  296. _, err := c.Db.Table(new(models.SysUser)).In("id", ids).Update(map[string]interface{}{"del_flag": 0})
  297. if err != nil {
  298. session.Rollback()
  299. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  300. return
  301. }
  302. _, err = c.Db.Table(new(models.SysUserRole)).In("user_id", ids).Update(map[string]interface{}{"del_flag": 0})
  303. if err != nil {
  304. session.Rollback()
  305. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  306. return
  307. }
  308. session.Commit()
  309. ret := __none_func_system__()
  310. if ret {
  311. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  312. } else {
  313. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  314. }
  315. }
  316. // _UpdateUser
  317. // @Title _UpdateUser
  318. // @Description 修改用户
  319. // @Param login_id string false "登录ID"
  320. // @Param password string false "密码"
  321. // @Param org_id string false "组织ID"
  322. // @Param email string false "邮箱"
  323. // @Success 200 {object} models.Account
  324. // @Failure 403 :id is empty
  325. func System_UpdateUser(c *SystemController) {
  326. user_id := c.Ctx.GetString("user_id")
  327. var userInfo sysmodel.UserInfo
  328. c.Ctx.BindJSON(&userInfo)
  329. session := c.Db.NewSession()
  330. defer session.Close()
  331. //1、删除用户角色
  332. _, err := c.Db.SQL(sysmodel.SqlDeleteUserRoles, userInfo.Id).Execute()
  333. if err != nil {
  334. session.Rollback()
  335. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  336. return
  337. }
  338. //2、修改角色
  339. userRoles := []models.SysUserRole{}
  340. err = json.Unmarshal([]byte(userInfo.UserRole), &userRoles)
  341. if err != nil {
  342. session.Rollback()
  343. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  344. return
  345. }
  346. for i, _ := range userRoles {
  347. userRoles[i].Id = utils.NewUUID()
  348. userRoles[i].CreateBy = user_id
  349. userRoles[i].LastUpdateBy = user_id
  350. userRoles[i].CreateTime = time.Now()
  351. userRoles[i].LastUpdateDate = time.Now()
  352. userRoles[i].DelFlag = 1
  353. }
  354. _, err = c.Db.Insert(userRoles)
  355. if err != nil {
  356. session.Rollback()
  357. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  358. return
  359. }
  360. //3、更新用户信息
  361. _, err = c.Db.Table(new(models.SysUser)).ID(userInfo.Id).Update(map[string]interface{}{"name": userInfo.Name, "email": userInfo.Email, "org_id": userInfo.OrgId, "last_update_by": user_id, "last_update_date": time.Now()})
  362. if err != nil {
  363. session.Rollback()
  364. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  365. return
  366. }
  367. session.Commit()
  368. ret := __none_func_system__()
  369. if ret {
  370. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  371. } else {
  372. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  373. }
  374. }
  375. // _AddRole
  376. // @Title _AddRole
  377. // @Description 添加角色
  378. // @Param name string false "角色名称"
  379. // @Param remark string false "备注"
  380. // @Success 200 {object} models.Account
  381. // @Failure 403 :id is empty
  382. func System_AddRole(c *SystemController) {
  383. var role models.SysRole
  384. c.Ctx.BindJSON(&role)
  385. user_id := c.Ctx.GetString("user_id")
  386. role.Id = utils.NewUUID()
  387. role.DelFlag = 1
  388. role.CreateBy = user_id
  389. role.LastUpdateBy = user_id
  390. role.CreateTime = time.Now()
  391. role.LastUpdateDate = time.Now()
  392. _, err := c.Db.Insert(&role)
  393. ret := __none_func_system__()
  394. if ret && err == nil {
  395. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  396. } else {
  397. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  398. }
  399. }
  400. // _DelRole
  401. // @Title _DelRole
  402. // @Description 添加角色
  403. // @Param id string false "角色ID"
  404. // @Success 200 {object} models.Account
  405. // @Failure 403 :id is empty
  406. func System_DelRole(c *SystemController) {
  407. type Param struct {
  408. Id string `json:"id"`
  409. }
  410. var params []Param
  411. c.Ctx.BindJSON(&params)
  412. fmt.Println(params, "-----------")
  413. ids := []string{}
  414. for _, param := range params {
  415. ids = append(ids, param.Id)
  416. }
  417. _, err := c.Db.Table(new(models.SysRole)).In("id", ids).Update(map[string]interface{}{"del_flag": 0})
  418. if err != nil {
  419. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  420. return
  421. }
  422. ret := __none_func_system__()
  423. if ret {
  424. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  425. } else {
  426. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  427. }
  428. }
  429. // _UpdateRole
  430. // @Title _UpdateRole
  431. // @Description 修改角色
  432. // @Param id string false "角色ID"
  433. // @Param name string false "角色名称"
  434. // @Param remark string false "备注"
  435. // @Success 200 {object} models.Account
  436. // @Failure 403 :id is empty
  437. func System_UpdateRole(c *SystemController) {
  438. var role models.SysRole
  439. c.Ctx.BindJSON(&role)
  440. user_id := c.Ctx.GetString("user_id")
  441. role.LastUpdateBy = user_id
  442. role.LastUpdateDate = time.Now()
  443. c.Db.ID(role.Id).Update(&role)
  444. ret := __none_func_system__()
  445. if ret {
  446. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  447. } else {
  448. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  449. }
  450. }
  451. // _FindRolePage
  452. // @Title _FindRolePage
  453. // @Description 角色分页
  454. // @Param page false "分页参数"
  455. // @Success 200 {object} models.Account
  456. // @Failure 403 :id is empty
  457. func System_FindRolePage(c *SystemController) {
  458. var getpageinfo models.GetPageInfo
  459. c.Ctx.BindJSON(&getpageinfo)
  460. page := sysmodel.SysRolePageInfo{}
  461. var roles []sysmodel.SysRole
  462. err := c.Db.SQL(sysmodel.Selectall_sys_role).Limit(getpageinfo.PageSize, (getpageinfo.PageNum-1)*getpageinfo.PageSize).Find(&roles)
  463. if err != nil {
  464. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  465. return
  466. }
  467. fmt.Println("-----------", len(roles))
  468. page.Content = roles
  469. page.PageSize = getpageinfo.PageSize
  470. page.PageNum = getpageinfo.PageNum
  471. page.TotalSize = 1
  472. ret := __none_func_system__(getpageinfo)
  473. if ret {
  474. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", page})
  475. } else {
  476. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  477. }
  478. }
  479. // _FindRoleMenu
  480. // @Title _FindRoleMenu
  481. // @Description 查找角色权限
  482. // @Param user string false "用户id"
  483. // @Success 200 {object} models.Account
  484. // @Failure 403 :id is empty
  485. func System_FindRoleMenu(c *SystemController) {
  486. role_id, b := c.Ctx.GetQuery("roleId")
  487. if !b {
  488. c.Ctx.JSON(200, sysmodel.SysReturn{500, "roleId is null", nil})
  489. return
  490. }
  491. menus := []models.SysMenu{}
  492. c.Db.SQL(models.SqlFindRoleMenu, role_id).Find(&menus)
  493. ret := __none_func_system__()
  494. if ret {
  495. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", menus})
  496. } else {
  497. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  498. }
  499. }
  500. // _SaveRoleMenu
  501. // @Title _SaveRoleMenu
  502. // @Description 保存角色权限
  503. // @Param role_menu string false "角色权限"
  504. // @Success 200 {object} models.Account
  505. // @Failure 403 :id is empty
  506. func System_SaveRoleMenu(c *SystemController) {
  507. var saverolemenu []models.SysRoleMenu
  508. c.Ctx.BindJSON(&saverolemenu)
  509. if len(saverolemenu) < 1 {
  510. c.Ctx.JSON(200, sysmodel.SysReturn{500, "role menu length is error", nil})
  511. return
  512. }
  513. session := c.Db.NewSession()
  514. defer session.Close()
  515. err := session.Begin()
  516. //删除角色下的menu
  517. _, err = c.Db.Exec("delete from sys_role_menu where role_id = ?", saverolemenu[0].RoleId)
  518. //_, err = c.Db.Exec("delete from sys_role_menu where id = 1")
  519. if err != nil {
  520. session.Rollback()
  521. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  522. return
  523. }
  524. for i, _ := range saverolemenu {
  525. saverolemenu[i].Id = utils.NewUUID()
  526. saverolemenu[i].DelFlag = 1
  527. }
  528. _, err = c.Db.Insert(&saverolemenu)
  529. if err != nil {
  530. session.Rollback()
  531. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  532. return
  533. }
  534. session.Commit()
  535. ret := __none_func_system__(&saverolemenu)
  536. if ret {
  537. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  538. } else {
  539. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  540. }
  541. }
  542. // _RoleAll
  543. // @Title _RoleAll
  544. // @Description 查找所有角色
  545. // @Success 200 {object} models.Account
  546. // @Failure 403 :id is empty
  547. func System_RoleAll(c *SystemController) {
  548. var roles []sysmodel.SysRole
  549. err := c.Db.SQL(sysmodel.Selectall_sys_role).Find(&roles)
  550. ret := __none_func_system__()
  551. if ret && err == nil {
  552. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", roles})
  553. } else {
  554. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  555. }
  556. }
  557. // _FindPermissions
  558. // @Title _FindPermissions
  559. // @Description 查找用户权限
  560. // @Success 200 {object} models.Account
  561. // @Failure 403 :id is empty
  562. func System_FindPermissions(c *SystemController) {
  563. user_id := c.Ctx.GetString("user_id")
  564. //result, err := c.Db.Query(models.SqlFindUserPermissions, op.UserId)
  565. result, err := c.Db.QueryString(models.SqlFindUserPermissions, user_id)
  566. strs := []string{}
  567. for _, v := range result {
  568. strs = append(strs, v["perms"])
  569. }
  570. if err != nil {
  571. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  572. }
  573. ret := __none_func_system__()
  574. //strs = []string{"sys:menu:add", "sys:menu:view", "sys:menu:edit", "sys:menu:delete", "sys:user:edit", "sys:user:delete", "sys:user:add", "sys:role:view", "sys:role:edit", "sys:role:delete", "sys:role:add"}
  575. if ret {
  576. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", strs})
  577. } else {
  578. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  579. }
  580. }
  581. // _AddMenu
  582. // @Title _AddMenu
  583. // @Description 添加菜单
  584. // @Param string false "菜单"
  585. // @Success 200 {object} models.Account
  586. // @Failure 403 :id is empty
  587. func System_AddMenu(c *SystemController) {
  588. var sysmenu models.SysMenu
  589. c.Ctx.BindJSON(&sysmenu)
  590. user_id := c.Ctx.GetString("user_id")
  591. sysmenu.Id = utils.NewUUID()
  592. sysmenu.CreateBy = user_id
  593. sysmenu.LastUpdateBy = user_id
  594. sysmenu.LastUpdateDate = time.Now()
  595. sysmenu.CreateTime = time.Now()
  596. sysmenu.DelFlag = 1
  597. _, err := c.Db.Insert(&sysmenu)
  598. if err != nil {
  599. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  600. return
  601. }
  602. ret := __none_func_system__(sysmenu)
  603. if ret {
  604. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  605. } else {
  606. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  607. }
  608. }
  609. // _DelMenu
  610. // @Title _DelMenu
  611. // @Description 删除菜单
  612. // @Param id string false "菜单ID"
  613. // @Success 200 {object} models.Account
  614. // @Failure 403 :id is empty
  615. func System_DelMenu(c *SystemController) {
  616. type Param struct {
  617. Id string `json:"id"`
  618. }
  619. var params []Param
  620. c.Ctx.BindJSON(&params)
  621. fmt.Println(params, "-----------")
  622. ids := []string{}
  623. for _, param := range params {
  624. ids = append(ids, param.Id)
  625. }
  626. _, err := c.Db.Table(new(models.SysMenu)).In("id", ids).Update(map[string]interface{}{"del_flag": 0})
  627. if err != nil {
  628. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  629. return
  630. }
  631. ret := __none_func_system__()
  632. if ret {
  633. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  634. } else {
  635. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  636. }
  637. }
  638. // _UpdateMenu
  639. // @Title _UpdateMenu
  640. // @Description 更新菜单
  641. // @Param string false "菜单"
  642. // @Success 200 {object} models.Account
  643. // @Failure 403 :id is empty
  644. func System_UpdateMenu(c *SystemController) {
  645. var sysmenu models.SysMenu
  646. c.Ctx.BindJSON(&sysmenu)
  647. user_id := c.Ctx.GetString("user_id")
  648. sysmenu.LastUpdateBy = user_id
  649. sysmenu.LastUpdateDate = time.Now()
  650. _, err := c.Db.ID(sysmenu.Id).Update(&sysmenu)
  651. if err != nil {
  652. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  653. return
  654. }
  655. ret := __none_func_system__(sysmenu)
  656. if ret {
  657. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  658. } else {
  659. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  660. }
  661. }
  662. func __none_func_system__(params ...interface{}) bool {
  663. return true
  664. }