SystemController.go 77 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580
  1. package partial
  2. import (
  3. "errors"
  4. "fmt"
  5. "git.qianqiusoft.com/qianqiusoft/light-apiengine/entitys"
  6. "git.qianqiusoft.com/qianqiusoft/light-apiengine/models"
  7. sysmodel "git.qianqiusoft.com/qianqiusoft/light-apiengine/models"
  8. sysutils "git.qianqiusoft.com/qianqiusoft/light-apiengine/utils"
  9. "html/template"
  10. "strconv"
  11. "strings"
  12. "time"
  13. )
  14. // _Sidebar
  15. // @Title _Sidebar
  16. // @Description 获取导航菜单
  17. // @Param user string false "用户id"
  18. // @Success 200 {object} Account
  19. // @Failure 403 :id is empty
  20. func System_Sidebar(c *entitys.CtrlContext) {
  21. //System_GetMenuTree(c)
  22. _type := c.Ctx.DefaultQuery("type", "")
  23. type_op := c.Ctx.DefaultQuery("type_op", "")
  24. hidden := c.Ctx.DefaultQuery("hidden", "")
  25. name := c.Ctx.DefaultQuery("name", "")
  26. cn_id := c.Ctx.DefaultQuery("cn_id", "")
  27. tk, _ := c.Ctx.Get("token")
  28. user := tk.(*entitys.Token)
  29. op := template.HTML(type_op)
  30. // 管理员角色ID 5c38ee66-c5e6-40a7-b190-86d115bae3e5
  31. exist, _ := c.Db.Table("sys_user_role").Where("user_id = ? and role_id = ?", user.UserId, "5c38ee66-c5e6-40a7-b190-86d115bae3e5").Exist()
  32. //如果是管理员
  33. var paramMap_i_t map[string]interface{}
  34. if exist {
  35. paramMap_i_t = map[string]interface{}{"user_id": "", "name": name, "cn_id": cn_id, "sort": "name", "type": _type, "type_op": op, "hidden": hidden}
  36. } else {
  37. paramMap_i_t = map[string]interface{}{"user_id": user.UserId, "name": name, "cn_id": cn_id, "sort": "name", "type": _type, "type_op": op, "hidden": hidden}
  38. }
  39. result, err := sysutils.TreeSearch(c.Db, "system", "get_menu_tree", "sys_menu", paramMap_i_t)
  40. if err == nil {
  41. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  42. } else {
  43. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  44. }
  45. }
  46. // _GetMenuTree
  47. // @Title _GetMenuTree
  48. // @Description 获取系统菜单
  49. // @Param user string false "用户id"
  50. // @Success 200 {object} Account
  51. // @Failure 403 :id is empty
  52. func System_GetMenuTree(c *entitys.CtrlContext) {
  53. _type := c.Ctx.DefaultQuery("type", "")
  54. type_op := c.Ctx.DefaultQuery("type_op", "")
  55. hidden := c.Ctx.DefaultQuery("hidden", "")
  56. name := c.Ctx.DefaultQuery("name", "")
  57. cn_id := c.Ctx.DefaultQuery("cn_id", "")
  58. op := template.HTML(type_op)
  59. paramMap_i_t := map[string]interface{}{"user_id": "", "name": name, "cn_id": cn_id, "sort": "name", "type": _type, "type_op": op, "hidden": hidden}
  60. result, err := sysutils.TreeSearch(c.Db, "system", "get_menu_tree", "sys_menu", paramMap_i_t)
  61. if err == nil {
  62. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  63. } else {
  64. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  65. }
  66. }
  67. // _GetDomainTree
  68. // @Title _GetDomainTree
  69. // @Description 获取域树
  70. // @Success 200 {object} Account
  71. // @Failure 403 :id is empty
  72. func System_GetDomainTree(c *entitys.CtrlContext) {
  73. del_flag := c.Ctx.DefaultQuery("del_flag", "")
  74. paramMap_i_t := map[string]interface{}{"sort": "name", "del_flag": del_flag}
  75. result, err := sysutils.TreeSearch(c.Db, "system", "get_domain_tree", "sys_domain", paramMap_i_t)
  76. if err == nil {
  77. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  78. } else {
  79. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  80. }
  81. }
  82. // _FindUserPage
  83. // @Title _FindUserPage
  84. // @Description 获取用户分页数
  85. // @Success 200 {object} Account
  86. // @Failure 403 :id is empty
  87. func System_FindUserPage(c *entitys.CtrlContext) {
  88. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  89. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  90. name := c.Ctx.DefaultQuery("name", "")
  91. login_id := c.Ctx.DefaultQuery("login_id", "")
  92. org_id := c.Ctx.DefaultQuery("org_id", "")
  93. cn_org_id := c.Ctx.DefaultQuery("cn_org_id", "")
  94. var roleRule interface{}
  95. rule_code := "org_tree"
  96. user_id := c.Ctx.GetString("user_id")
  97. exist, _ := c.Db.Table("sys_user_role").Where("user_id = ? and role_id = ?", user_id, "5c38ee66-c5e6-40a7-b190-86d115bae3e5").Exist()
  98. //如果是管理员
  99. if exist {
  100. user_id = ""
  101. roleRule = ""
  102. } else if rule_code != "" {
  103. var roleRules []models.SysDataPermissionDetail
  104. // 根据rule_code获取角色对应的接口规则
  105. err := c.Db.SqlMapClient("get_user_rule_by_code", rule_code, user_id).Find(&roleRules)
  106. if err != nil {
  107. roleRule = ""
  108. } else {
  109. roleRule = sysutils.ParseRule(roleRules)
  110. }
  111. }
  112. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "name": name, "login_id": login_id, "org_id": org_id, "cn_org_id": cn_org_id, "user_id": user_id, "role_rule": roleRule}
  113. result, err := sysutils.PageSearch(c.Db, "system", "find_user_page", "sys_user", paramMap_i_t)
  114. if err != nil {
  115. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  116. return
  117. }
  118. //type Role struct {
  119. // RoleName string `json:"role_name"`
  120. // UserRole string `json:"user_role"`
  121. //}
  122. ////获取用户角色
  123. //users := result.Content.([]map[string]interface{})
  124. //for i, user := range users {
  125. // roles := []Role{}
  126. // err := c.Db.SqlMapClient("get_roles_by_user_id", user["id"]).Find(&roles)
  127. // if err != nil {
  128. // fmt.Println("----", err.Error())
  129. // continue
  130. // }
  131. // users[i]["user_role"] = roles[0].UserRole
  132. // users[i]["role_name"] = roles[0].RoleName
  133. //}
  134. //
  135. //result.Content = users
  136. if err == nil {
  137. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  138. } else {
  139. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  140. }
  141. }
  142. // _GetOrgTree
  143. // @Title _GetOrgTree
  144. // @Description 获取组织架构树
  145. // @Success 200 {object} Account
  146. // @Failure 403 :id is empty
  147. func System_GetOrgTree(c *entitys.CtrlContext) {
  148. var roleRule interface{} = ""
  149. rule_code := "org_tree"
  150. var user sysmodel.SysUser
  151. // 管理员角色ID 5c38ee66-c5e6-40a7-b190-86d115bae3e5,如果是管理员,可以看所有,否则只看到本部门
  152. user_id := c.Ctx.GetString("user_id")
  153. exist, _ := c.Db.Table("sys_user_role").Where("user_id = ? and role_id = ?", user_id, "5c38ee66-c5e6-40a7-b190-86d115bae3e5").Exist()
  154. //如果是管理员
  155. if exist {
  156. user_id = ""
  157. paramMap_i_t := map[string]interface{}{"sort": "name", "role_rule": roleRule}
  158. result, err := sysutils.TreeSearch(c.Db, "system", "get_org_tree", "sys_org", paramMap_i_t)
  159. if err == nil {
  160. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  161. } else {
  162. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  163. }
  164. } else if rule_code != "" {
  165. var roleRules []models.SysDataPermissionDetail
  166. // 根据rule_code获取角色对应的接口规则
  167. err := c.Db.SqlMapClient("get_user_rule_by_code", rule_code, user_id).Find(&roleRules)
  168. if err != nil {
  169. roleRule = ""
  170. } else {
  171. roleRule = sysutils.ParseRule(roleRules)
  172. }
  173. // 查找用户组织ID
  174. _, err = c.Db.ID(user_id).Get(&user)
  175. if err != nil {
  176. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  177. return
  178. }
  179. stplkey := fmt.Sprintf("%s_%s.tpl", "system", "get_org_tree")
  180. paramMap_i_t := map[string]interface{}{"sort": "name", "org_id": user.OrgId, "role_rule": roleRule}
  181. result, err := c.Db.SqlTemplateClient(stplkey, &paramMap_i_t).Query().List()
  182. if err != nil {
  183. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  184. return
  185. }
  186. tree, err := sysutils.BuildTree(user.OrgId, result)
  187. if err == nil {
  188. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", tree})
  189. } else {
  190. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  191. }
  192. }
  193. }
  194. // _FindOrgPage
  195. // @Title _FindOrgPage
  196. // @Description 获取组织架构分页数
  197. // @Success 200 {object} Account
  198. // @Failure 403 :id is empty
  199. func System_FindOrgPage(c *entitys.CtrlContext) {
  200. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  201. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  202. name := c.Ctx.DefaultQuery("name", "")
  203. code := c.Ctx.DefaultQuery("code", "")
  204. cn_id := c.Ctx.DefaultQuery("cn_id", "")
  205. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "name": name, "code": code, "cn_id": cn_id}
  206. result, err := sysutils.PageSearch(c.Db, "system", "find_org_page", "sys_org", paramMap_i_t)
  207. if err == nil {
  208. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  209. } else {
  210. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  211. }
  212. }
  213. // _AddUser
  214. // @Title _AddUser
  215. // @Description 添加用户
  216. // @Param login_id string false "登录ID"
  217. // @Param password string false "密码"
  218. // @Param org_id string false "组织ID"
  219. // @Param email string false "邮箱"
  220. // @Success 200 {object} Account
  221. // @Failure 403 :id is empty
  222. func System_AddUser(c *entitys.CtrlContext) {
  223. tk, _ := c.Ctx.Get("token")
  224. opUser := tk.(*entitys.Token)
  225. var user sysmodel.SysUser
  226. err := c.Ctx.BindJSON(&user)
  227. if err != nil {
  228. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  229. }
  230. fmt.Println(user.LoginId, "-----add user-----", user.Password, " --- ", user.OrgId)
  231. //查找login_id是否存在
  232. exit, _ := c.PlatformDbEngine.Table(new(sysmodel.SysUser)).Where("login_id = ? and del_flag = ?", user.LoginId, 0).Exist()
  233. if exit {
  234. c.Ctx.JSON(200, sysmodel.SysReturn{500, "login_id exit", nil})
  235. return
  236. }
  237. user_id := c.Ctx.GetString("user_id")
  238. user.Id = sysutils.NewUUID()
  239. user.Name = user.LoginId
  240. user.CreateTime = models.NowLocal()
  241. user.LastUpdateTime = time.Now().UnixNano()
  242. user.CreateBy = user_id
  243. user.LastUpdateBy = user_id
  244. user.DelFlag = 0
  245. user.Domain = opUser.Domain
  246. user.Password = sysutils.HashPassword(user.Password, "")
  247. _, err = c.PlatformDbEngine.Insert(&user)
  248. if err != nil {
  249. c.Ctx.JSON(200, sysmodel.SysReturn{500, "平台插入用户错误:" + err.Error(), nil})
  250. }
  251. _, err = c.Db.Insert(&user)
  252. ret := __none_func_system__(user.LoginId, user.Password, user.OrgId, user.Email)
  253. if ret && err == nil {
  254. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  255. } else {
  256. c.Ctx.JSON(200, sysmodel.SysReturn{500, "域数据库插入用户错误:" + err.Error(), nil})
  257. }
  258. }
  259. // _DelUser
  260. // @Title _DelUser
  261. // @Description 删除用户
  262. // @Param id string false "用户ID"
  263. // @Success 200 {object} Account
  264. // @Failure 403 :id is empty
  265. func System_DelUser(c *entitys.CtrlContext) {
  266. type Param struct {
  267. Id string `json:"id"`
  268. }
  269. var params []Param
  270. c.Ctx.BindJSON(&params)
  271. ids := []string{}
  272. for _, param := range params {
  273. ids = append(ids, param.Id)
  274. }
  275. session := c.Db.NewSession()
  276. defer session.Close()
  277. session.Begin()
  278. _, err := c.Db.Table(new(models.SysUser)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  279. if err != nil {
  280. session.Rollback()
  281. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  282. return
  283. }
  284. _, err = c.Db.Table(new(models.SysUserRole)).In("user_id", ids).Update(map[string]interface{}{"del_flag": 1})
  285. if err != nil {
  286. session.Rollback()
  287. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  288. return
  289. }
  290. session.Commit()
  291. _, err = c.PlatformDbEngine.Table(new(models.SysUser)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  292. if err == nil {
  293. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  294. } else {
  295. c.Ctx.JSON(200, sysmodel.SysReturn{500, "平台删除用户失败:" + err.Error(), nil})
  296. }
  297. }
  298. // _UpdateUser
  299. // @Title _UpdateUser
  300. // @Description 修改用户
  301. // @Param login_id string false "登录ID"
  302. // @Param password string false "密码"
  303. // @Param org_id string false "组织ID"
  304. // @Param email string false "邮箱"
  305. // @Success 200 {object} Account
  306. // @Failure 403 :id is empty
  307. func System_UpdateUser(c *entitys.CtrlContext) {
  308. tk, _ := c.Ctx.Get("token")
  309. user := tk.(*entitys.Token)
  310. var postData struct {
  311. sysmodel.SysUser
  312. UserRole []string `json:"user_role"`
  313. }
  314. //var user sysmodel.SysUser
  315. err := c.Ctx.BindJSON(&postData)
  316. if err != nil {
  317. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  318. return
  319. }
  320. //postData.LastUpdateTime = time.Now().UnixNano()
  321. //postData.LastUpdateBy = user.UserId
  322. session := c.Db.NewSession()
  323. defer session.Close()
  324. session.Begin()
  325. //paramMap, _ := sysutils.BeanToMap(&postData)
  326. paramMap := map[string]interface{}{"id": postData.Id, "temp_id": postData.TempId, "temp_value": postData.TempValue, "name": postData.Name, "email": postData.Email, "mobile": postData.Mobile, "org_id": postData.OrgId, "last_update_time": time.Now().UnixNano(), "last_update_by": user.UserId}
  327. _, err = session.SqlMapClient("update_user", &paramMap).Execute()
  328. if err != nil {
  329. session.Rollback()
  330. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  331. return
  332. }
  333. _, err = c.PlatformDbEngine.SqlMapClient("update_user", &paramMap).Execute()
  334. if err != nil {
  335. session.Rollback()
  336. c.Ctx.JSON(500, sysmodel.SysReturn{500, "平台更新用户失败:" + err.Error(), nil})
  337. return
  338. }
  339. userRoles := []sysmodel.SysUserRole{}
  340. for _, roleId := range postData.UserRole {
  341. userRole := sysmodel.SysUserRole{}
  342. userRole.Id = sysutils.NewUUID()
  343. userRole.UserId = postData.Id
  344. userRole.RoleId = roleId
  345. userRole.DelFlag = 0
  346. userRole.CreateTime = sysmodel.NowLocal()
  347. userRole.CreateBy = user.UserId
  348. userRole.LastUpdateBy = user.UserId
  349. userRole.LastUpdateTime = time.Now().UnixNano()
  350. userRoles = append(userRoles, userRole)
  351. }
  352. _, err = session.SqlMapClient("delete_user_role", &map[string]interface{}{"user_id": postData.Id}).Execute()
  353. if err != nil {
  354. session.Rollback()
  355. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  356. return
  357. }
  358. _, err = session.InsertMulti(&userRoles)
  359. if err == nil {
  360. session.Commit()
  361. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  362. } else {
  363. session.Rollback()
  364. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  365. }
  366. }
  367. // _UpdatePassword
  368. // @Title _UpdatePassword
  369. // @Description 修改用户密码
  370. // @Param string false "用户ID"
  371. // @Param password string false "密码"
  372. // @Success 200 {object} Account
  373. // @Failure 403 :id is empty
  374. func System_UpdatePassword(c *entitys.CtrlContext) {
  375. var user sysmodel.SysUser
  376. err := c.Ctx.BindJSON(&user)
  377. operatorId := c.Ctx.GetString("user_id")
  378. if err != nil {
  379. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  380. return
  381. }
  382. user.Password = sysutils.HashPassword(user.Password, "")
  383. paramMap := map[string]interface{}{"id": user.Id, "password": user.Password, "last_update_time": time.Now().UnixNano(), "last_update_by": operatorId}
  384. _, err = c.PlatformDbEngine.SqlMapClient("update_user_password", &paramMap).Execute()
  385. if err == nil {
  386. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  387. } else {
  388. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  389. }
  390. }
  391. // _GetUser
  392. // @Title _GetUser
  393. // @Description 更加用户ID获取用户信息
  394. // @Param user_id string false "用户ID"
  395. // @Success 200 {object} Account
  396. // @Failure 403 :id is empty
  397. func System_GetUser(c *entitys.CtrlContext) {
  398. user_id := c.Ctx.Query("user_id")
  399. var user sysmodel.SysUser
  400. _, err := c.Db.SqlMapClient("selectone_sys_user", &map[string]interface{}{"id": user_id}).Get(&user)
  401. if err == nil {
  402. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", user})
  403. } else {
  404. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  405. }
  406. }
  407. // _AddRole
  408. // @Title _AddRole
  409. // @Description 添加角色
  410. // @Param name string false "角色名称"
  411. // @Param remark string false "备注"
  412. // @Success 200 {object} Account
  413. // @Failure 403 :id is empty
  414. func System_AddRole(c *entitys.CtrlContext) {
  415. var paramObj0 models.SysRole
  416. c.Ctx.BindJSON(&paramObj0)
  417. tk, _ := c.Ctx.Get("token")
  418. user := tk.(*entitys.Token)
  419. paramObj0.Id = sysutils.NewUUID()
  420. paramObj0.CreateBy = user.UserId
  421. paramObj0.LastUpdateBy = user.UserId
  422. paramObj0.CreateTime = models.NowLocal()
  423. paramObj0.LastUpdateTime = time.Now().UnixNano()
  424. paramObj0.DelFlag = 0
  425. //_, err := c.LocalSqlMapClient("insert_sys_role", &paramObj0).Execute()
  426. paramMap, err := sysutils.BeanToMap(&paramObj0)
  427. _, err = c.Db.SqlMapClient("insert_sys_role", paramMap).Execute()
  428. if err == nil {
  429. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  430. } else {
  431. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  432. }
  433. }
  434. // _DelRole
  435. // @Title _DelRole
  436. // @Description 添加角色
  437. // @Param id string false "角色ID"
  438. // @Success 200 {object} Account
  439. // @Failure 403 :id is empty
  440. func System_DelRole(c *entitys.CtrlContext) {
  441. type Param struct {
  442. Id string `json:"id"`
  443. }
  444. var params []Param
  445. c.Ctx.BindJSON(&params)
  446. ids := []string{}
  447. for _, param := range params {
  448. ids = append(ids, param.Id)
  449. }
  450. _, err := c.Db.Table(new(models.SysRole)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  451. if err == nil {
  452. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  453. } else {
  454. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  455. }
  456. }
  457. // _UpdateRole
  458. // @Title _UpdateRole
  459. // @Description 修改角色
  460. // @Param id string false "角色ID"
  461. // @Param name string false "角色名称"
  462. // @Param remark string false "备注"
  463. // @Success 200 {object} Account
  464. // @Failure 403 :id is empty
  465. func System_UpdateRole(c *entitys.CtrlContext) {
  466. var role sysmodel.SysRole
  467. err := c.Ctx.BindJSON(&role)
  468. if err != nil {
  469. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  470. return
  471. }
  472. paramMap, _ := sysutils.BeanToMap(&role)
  473. _, err = c.Db.SqlMapClient("update_sys_role", paramMap).Execute()
  474. if err == nil {
  475. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  476. } else {
  477. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  478. }
  479. }
  480. // _GetUserRoles
  481. // @Title _GetUserRoles
  482. // @Description 根据用户id获取用户角色
  483. // @Param user_id string false "用户ID"
  484. // @Success 200 {object} Account
  485. // @Failure 403 :id is empty
  486. func System_GetUserRoles(c *entitys.CtrlContext) {
  487. user_id := c.Ctx.Query("user_id")
  488. var roles []sysmodel.SysRole
  489. err := c.Db.SQL("select sys_role.* from sys_user_role, sys_role where sys_user_role.role_id = sys_role.id and sys_role.del_flag = 0 and sys_user_role.user_id = ? order by sys_role.priority asc", user_id).Find(&roles)
  490. if err == nil {
  491. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", roles})
  492. } else {
  493. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  494. }
  495. }
  496. // _FindRolePage
  497. // @Title _FindRolePage
  498. // @Description 角色分页
  499. // @Param page false "分页参数"
  500. // @Success 200 {object} Account
  501. // @Failure 403 :id is empty
  502. func System_FindRolePage(c *entitys.CtrlContext) {
  503. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  504. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  505. name := c.Ctx.DefaultQuery("name", "")
  506. code := c.Ctx.DefaultQuery("code", "")
  507. paramMap_i_t := map[string]interface{}{"name": name, "code": code, "page": page, "rows": rows}
  508. result, err := sysutils.PageSearch(c.Db, "system", "find_role_page", "sys_role", paramMap_i_t)
  509. if err == nil {
  510. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  511. } else {
  512. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  513. }
  514. }
  515. // _FindMenuPage
  516. // @Title _FindMenuPage
  517. // @Description 获取角色分页数
  518. // @Success 200 {object} Account
  519. // @Failure 403 :id is empty
  520. func System_FindMenuPage(c *entitys.CtrlContext) {
  521. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  522. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  523. user_id := c.Ctx.DefaultQuery("user_id", "")
  524. name := c.Ctx.DefaultQuery("name", "")
  525. code := c.Ctx.DefaultQuery("code", "")
  526. cn_id := c.Ctx.DefaultQuery("cn_id", "")
  527. _type := c.Ctx.DefaultQuery("type", "")
  528. type_op := c.Ctx.DefaultQuery("type_op", "")
  529. hidden := c.Ctx.DefaultQuery("hidden", "")
  530. op := template.HTML(type_op)
  531. // 管理员角色ID 5c38ee66-c5e6-40a7-b190-86d115bae3e5
  532. exist, _ := c.Db.Table("sys_user_role").Where("user_id = ? and role_id = ?", user_id, "5c38ee66-c5e6-40a7-b190-86d115bae3e5").Exist()
  533. //如果是管理员
  534. if exist {
  535. user_id = ""
  536. }
  537. paramMap_i_t := map[string]interface{}{"user_id": user_id, "hidden": hidden, "page": page, "rows": rows, "type": _type, "type_op": op, "name": name, "code": code, "cn_id": cn_id}
  538. result, err := sysutils.PageSearch(c.Db, "system", "find_menu_page", "sys_menu", paramMap_i_t)
  539. if err == nil {
  540. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  541. } else {
  542. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  543. }
  544. }
  545. // _FindDomainPage
  546. // @Title _FindDomainPage
  547. // @Description 获取域分页数
  548. // @Success 200 {object} Account
  549. // @Failure 403 :id is empty
  550. func System_FindDomainPage(c *entitys.CtrlContext) {
  551. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  552. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  553. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows}
  554. result, err := sysutils.PageSearch(c.Db, "system", "find_domain_page", "sys_domain", paramMap_i_t)
  555. if err == nil {
  556. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  557. } else {
  558. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  559. }
  560. }
  561. // _FindRoleMenu
  562. // @Title _FindRoleMenu
  563. // @Description 查找角色权限
  564. // @Param role_id string false "角色id"
  565. // @Success 200 {object} Account
  566. // @Failure 403 :id is empty
  567. func System_FindRoleMenu(c *entitys.CtrlContext) {
  568. role_id := c.Ctx.Query("role_id")
  569. ret := __none_func_system__(role_id)
  570. if ret {
  571. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  572. } else {
  573. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  574. }
  575. }
  576. // _SaveRoleMenu
  577. // @Title _SaveRoleMenu
  578. // @Description 保存角色权限
  579. // @Param role_menu string false "角色权限"
  580. // @Success 200 {object} Account
  581. // @Failure 403 :id is empty
  582. func System_SaveRoleMenu(c *entitys.CtrlContext) {
  583. var paramObj0 []models.SaveRoleMenu
  584. c.Ctx.BindJSON(&paramObj0)
  585. ret := __none_func_system__(paramObj0)
  586. if ret {
  587. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  588. } else {
  589. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  590. }
  591. }
  592. // _RoleAll
  593. // @Title _RoleAll
  594. // @Description 查找所有角色
  595. // @Success 200 {object} Account
  596. // @Failure 403 :id is empty
  597. func System_RoleAll(c *entitys.CtrlContext) {
  598. ret := __none_func_system__()
  599. if ret {
  600. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  601. } else {
  602. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  603. }
  604. }
  605. // _FindPermissions
  606. // @Title _FindPermissions
  607. // @Description 查找用户权限
  608. // @Success 200 {object} Account
  609. // @Failure 403 :id is empty
  610. func System_FindPermissions(c *entitys.CtrlContext) {
  611. ret := __none_func_system__()
  612. if ret {
  613. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  614. } else {
  615. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  616. }
  617. }
  618. // _AddMenu
  619. // @Title _AddMenu
  620. // @Description 添加菜单
  621. // @Param string false "菜单"
  622. // @Success 200 {object} Account
  623. // @Failure 403 :id is empty
  624. func System_AddMenu(c *entitys.CtrlContext) {
  625. var paramObj0 models.SysMenu
  626. c.Ctx.BindJSON(&paramObj0)
  627. tk, _ := c.Ctx.Get("token")
  628. user := tk.(*entitys.Token)
  629. paramObj0.Id = sysutils.NewUUID()
  630. paramObj0.CreateBy = user.UserId
  631. paramObj0.LastUpdateBy = user.UserId
  632. paramObj0.CreateTime = models.NowLocal()
  633. paramObj0.LastUpdateTime = time.Now().UnixNano()
  634. paramObj0.DelFlag = 0
  635. if paramObj0.Parent != "" {
  636. parentNodes := []sysmodel.SysMenu{}
  637. err := c.Db.SqlMapClient("select_parent_menu", paramObj0.Parent).Find(&parentNodes)
  638. if err != nil {
  639. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  640. return
  641. }
  642. paramObj0.Inheritance = fmt.Sprintf("|%s%s", paramObj0.Id, parentNodes[0].Inheritance)
  643. } else {
  644. paramObj0.Inheritance = fmt.Sprintf("|%s|", paramObj0.Id)
  645. }
  646. //_, err := c.LocalSqlMapClient("insert_sys_menu", &paramObj0).Execute()
  647. paramMap, err := sysutils.BeanToMap(&paramObj0)
  648. _, err = c.Db.SqlMapClient("insert_sys_menu", paramMap).Execute()
  649. if err == nil {
  650. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  651. } else {
  652. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  653. }
  654. }
  655. // _DelMenu
  656. // @Title _DelMenu
  657. // @Description 删除菜单
  658. // @Param id string false "菜单ID"
  659. // @Success 200 {object} Account
  660. // @Failure 403 :id is empty
  661. func System_DelMenu(c *entitys.CtrlContext) {
  662. type Param struct {
  663. Id string `json:"id"`
  664. }
  665. var params []Param
  666. c.Ctx.BindJSON(&params)
  667. ids := []string{}
  668. for _, param := range params {
  669. ids = append(ids, param.Id)
  670. }
  671. _, err := c.Db.Table(new(models.SysMenu)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  672. if err == nil {
  673. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  674. } else {
  675. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  676. }
  677. }
  678. // _UpdateMenu
  679. // @Title _UpdateMenu
  680. // @Description 更新菜单
  681. // @Param string false "菜单"
  682. // @Success 200 {object} Account
  683. // @Failure 403 :id is empty
  684. func System_UpdateMenu(c *entitys.CtrlContext) {
  685. var paramObj0 models.SysMenu
  686. err := c.Ctx.BindJSON(&paramObj0)
  687. tk, _ := c.Ctx.Get("token")
  688. user := tk.(*entitys.Token)
  689. if paramObj0.Parent != "" {
  690. parentNode := sysmodel.SysMenu{}
  691. bool, err := c.Db.SqlMapClient("select_parent_menu", paramObj0.Parent).Get(&parentNode)
  692. if !bool || err != nil {
  693. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  694. return
  695. }
  696. paramObj0.Inheritance = fmt.Sprintf("|%s%s", paramObj0.Id, parentNode.Inheritance)
  697. } else {
  698. paramObj0.Inheritance = fmt.Sprintf("|%s|", paramObj0.Id)
  699. }
  700. paramObj0.LastUpdateBy = user.UserId
  701. paramObj0.LastUpdateTime = time.Now().UnixNano()
  702. sess := c.Db.NewSession()
  703. sess.Begin()
  704. paramMap, err := sysutils.BeanToMap(&paramObj0)
  705. _, err = sess.SqlMapClient("update_sys_menu", paramMap).Execute()
  706. if err != nil {
  707. sess.Rollback()
  708. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  709. }
  710. // 查找目录,修改Inheritance值
  711. //childrenNodes := []sysmodel.SysMenu{}
  712. childrenNode := new(sysmodel.SysMenu)
  713. rows, err := sess.SqlMapClient("select_children_menu", paramObj0.Id).Rows(childrenNode)
  714. if err != nil {
  715. sess.Rollback()
  716. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  717. return
  718. }
  719. defer rows.Close()
  720. for rows.Next() {
  721. err = rows.Scan(childrenNode)
  722. if err != nil {
  723. sess.Rollback()
  724. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  725. return
  726. }
  727. childrenNode.Inheritance = fmt.Sprintf("%s%s|", paramObj0.Inheritance, childrenNode.Id)
  728. childrenNode.LastUpdateBy = user.UserId
  729. childrenNode.LastUpdateTime = time.Now().UnixNano()
  730. paramMap, _ := sysutils.BeanToMap(childrenNode)
  731. _, err = c.Db.SqlMapClient("update_sys_menu", paramMap).Execute()
  732. if err != nil {
  733. break
  734. }
  735. }
  736. if err == nil {
  737. sess.Commit()
  738. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  739. } else {
  740. sess.Rollback()
  741. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  742. }
  743. }
  744. // _AddOrg
  745. // @Title _AddOrg
  746. // @Description 添加组织
  747. // @Param name string false "组织名称"
  748. // @Param domain string false "域"
  749. // @Param parent string false "父ID"
  750. // @Success 200 {object} Account
  751. // @Failure 403 :id is empty
  752. func System_AddOrg(c *entitys.CtrlContext) {
  753. var paramObj0 models.SysOrg
  754. c.Ctx.BindJSON(&paramObj0)
  755. tk, _ := c.Ctx.Get("token")
  756. user := tk.(*entitys.Token)
  757. paramObj0.Id = sysutils.NewUUID()
  758. paramObj0.CreateBy = user.UserId
  759. paramObj0.LastUpdateBy = user.UserId
  760. paramObj0.CreateTime = models.NowLocal()
  761. paramObj0.LastUpdateTime = time.Now().UnixNano()
  762. paramObj0.DelFlag = 0
  763. if paramObj0.Parent != "" {
  764. parentNodes := []sysmodel.SysOrg{}
  765. err := c.Db.SqlMapClient("one_sys_org", map[string]interface{}{"id": paramObj0.Parent}).Find(&parentNodes)
  766. if err != nil {
  767. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  768. return
  769. }
  770. paramObj0.Inheritance = fmt.Sprintf("|%s%s", paramObj0.Id, parentNodes[0].Inheritance)
  771. } else {
  772. paramObj0.Inheritance = fmt.Sprintf("|%s|", paramObj0.Id)
  773. }
  774. //_, err := c.LocalSqlMapClient("insert_sys_org", &paramObj0).Execute()
  775. paramMap, err := sysutils.BeanToMap(&paramObj0)
  776. _, err = c.Db.SqlMapClient("insert_sys_org", paramMap).Execute()
  777. if err == nil {
  778. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  779. } else {
  780. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  781. }
  782. }
  783. // _DelOrg
  784. // @Title _DelOrg
  785. // @Description 删除组织
  786. // @Param id string array false "用户ID"
  787. // @Success 200 {object} Account
  788. // @Failure 403 :id is empty
  789. func System_DelOrg(c *entitys.CtrlContext) {
  790. type Param struct {
  791. Id string `json:"id"`
  792. }
  793. var params []Param
  794. c.Ctx.BindJSON(&params)
  795. ids := []string{}
  796. for _, param := range params {
  797. ids = append(ids, param.Id)
  798. }
  799. _, err := c.Db.Table(new(models.SysOrg)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  800. if err == nil {
  801. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  802. } else {
  803. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  804. }
  805. }
  806. // _UpdateOrg
  807. // @Title _UpdateOrg
  808. // @Description 修改组织
  809. // @Param name string false "组织名称"
  810. // @Param domain string false "域"
  811. // @Param parent string false "父ID"
  812. // @Success 200 {object} Account
  813. // @Failure 403 :id is empty
  814. func System_UpdateOrg(c *entitys.CtrlContext) {
  815. //name := c.Ctx.Query("name")
  816. //domain := c.Ctx.Query("domain")
  817. //parent := c.Ctx.Query("parent")
  818. var paramObj0 models.SysOrg
  819. err := c.Ctx.BindJSON(&paramObj0)
  820. tk, _ := c.Ctx.Get("token")
  821. user := tk.(*entitys.Token)
  822. if paramObj0.Parent != "" {
  823. parentNodes := []sysmodel.SysOrg{}
  824. err := c.Db.SqlMapClient("one_sys_org", paramObj0.Parent).Find(&parentNodes)
  825. if err != nil {
  826. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  827. return
  828. }
  829. paramObj0.Inheritance = fmt.Sprintf("|%s%s", paramObj0.Id, parentNodes[0].Inheritance)
  830. } else {
  831. paramObj0.Inheritance = fmt.Sprintf("|%s|", paramObj0.Id)
  832. }
  833. paramObj0.LastUpdateBy = user.UserId
  834. paramObj0.LastUpdateTime = time.Now().UnixNano()
  835. paramMap, err := sysutils.BeanToMap(&paramObj0)
  836. _, err = c.Db.SqlMapClient("update_sys_org", paramMap).Execute()
  837. if err == nil {
  838. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  839. } else {
  840. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  841. }
  842. }
  843. // _GetOrgByUserid
  844. // @Title _GetOrgByUserid
  845. // @Description 根据组织
  846. // @Param user_id string false "用户id"
  847. // @Success 200 {object} Account
  848. // @Failure 403 :id is empty
  849. func System_GetOrgUsers(c *entitys.CtrlContext) {
  850. user_id := c.Ctx.Query("user_id")
  851. role_id := c.Ctx.Query("role_id")
  852. fmt.Println(user_id, "---------", role_id)
  853. var err error
  854. //users := []sysmodel.SysUser{}
  855. var users []sysmodel.SysUser
  856. if role_id == "" {
  857. err = c.Db.SqlMapClient("get_org_users", user_id).Find(&users)
  858. } else {
  859. err = c.Db.SqlMapClient("get_org_role_users", user_id, role_id).Find(&users)
  860. if err != nil || users == nil {
  861. c.Ctx.JSON(500, sysmodel.SysReturn{500, "无法找到部门审批人!", nil})
  862. return
  863. }
  864. }
  865. if err == nil {
  866. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", users})
  867. } else {
  868. c.Ctx.JSON(500, sysmodel.SysReturn{500, "错误", nil})
  869. }
  870. }
  871. // _AddDomain
  872. // @Title _AddDomain
  873. // @Description 添加域
  874. // @Param false "域"
  875. // @Success 200 {object} Account
  876. // @Failure 403 :id is empty
  877. func System_AddDomain(c *entitys.CtrlContext) {
  878. var paramObj0 models.SysDomain
  879. c.Ctx.BindJSON(&paramObj0)
  880. ////1、测试连接串
  881. //db, err := xorm.NewEngine("mysql", paramObj0.DataSource)
  882. //if err == nil {
  883. // //engine.initOrmEngine(db, "mysql")
  884. // //c.BusinessOrmEngine[v.Domain] = db
  885. //}
  886. tk, _ := c.Ctx.Get("token")
  887. user := tk.(*entitys.Token)
  888. paramObj0.Id = sysutils.NewUUID()
  889. paramObj0.CreateBy = user.UserId
  890. paramObj0.LastUpdateBy = user.UserId
  891. paramObj0.CreateTime = sysmodel.NowLocal()
  892. paramObj0.LastUpdateTime = time.Now().UnixNano()
  893. paramObj0.Theme = "default"
  894. paramObj0.DelFlag = 0
  895. paramMap, err := sysutils.BeanToMap(&paramObj0)
  896. if err != nil {
  897. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  898. return
  899. }
  900. _, err = c.Db.SqlMapClient("insert_sys_domain", paramMap).Execute()
  901. if err == nil {
  902. //添加数据库基本用户权限数据
  903. ret := c.App.AddBusinessDb(paramObj0.Id, "admin@"+paramObj0.Domain, paramObj0.Domain, paramObj0.DataSource, true)
  904. if ret {
  905. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", paramObj0.Id})
  906. } else {
  907. c.Ctx.JSON(500, sysmodel.SysReturn{500, "数据库初始化错误。", nil})
  908. }
  909. } else {
  910. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  911. }
  912. }
  913. // _DelDomain
  914. // @Title _DelDomain
  915. // @Description 删除域
  916. // @Param id string false "域ID"
  917. // @Success 200 {object} Account
  918. // @Failure 403 :id is empty
  919. func System_DelDomain(c *entitys.CtrlContext) {
  920. type Param struct {
  921. Id string `json:"id"`
  922. }
  923. var params []Param
  924. c.Ctx.BindJSON(&params)
  925. ids := []string{}
  926. for _, param := range params {
  927. ids = append(ids, param.Id)
  928. }
  929. _, err := c.Db.Table(new(models.SysDomain)).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  930. if err != nil {
  931. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  932. return
  933. }
  934. ret := __none_func_system__()
  935. if ret {
  936. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  937. } else {
  938. c.Ctx.JSON(200, sysmodel.SysReturn{500, "", nil})
  939. }
  940. }
  941. // _UpdateDomain
  942. // @Title _UpdateDomain
  943. // @Description 修改域
  944. // @Param false "域"
  945. // @Success 200 {object} Account
  946. // @Failure 403 :id is empty
  947. func System_UpdateDomain(c *entitys.CtrlContext) {
  948. var paramObj0 models.SysDomain
  949. c.Ctx.BindJSON(&paramObj0)
  950. tk, _ := c.Ctx.Get("token")
  951. user := tk.(*entitys.Token)
  952. paramObj0.LastUpdateTime = time.Now().UnixNano()
  953. paramObj0.LastUpdateBy = user.UserId
  954. paramMap, err := sysutils.BeanToMap(&paramObj0)
  955. if err != nil {
  956. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  957. return
  958. }
  959. _, err = c.Db.SqlMapClient("update_sys_domain", paramMap).Execute()
  960. if err == nil {
  961. //添加数据库基本用户权限数据
  962. ret := c.App.AddBusinessDb(paramObj0.Id, "admin@"+paramObj0.Domain, paramObj0.Domain, paramObj0.DataSource, true)
  963. if ret {
  964. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", paramObj0.Id})
  965. } else {
  966. c.Ctx.JSON(500, sysmodel.SysReturn{500, "数据库初始化错误。", nil})
  967. }
  968. } else {
  969. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  970. }
  971. }
  972. // _GetDomain
  973. // @Title _GetDomain
  974. // @Description 根据domain获取域
  975. // @Param domain string false "域"
  976. // @Success 200 {object} Account
  977. // @Failure 403 :id is empty
  978. func System_GetDomain(c *entitys.CtrlContext) {
  979. domain := c.Ctx.Query("domain")
  980. var domainObj sysmodel.SysDomain
  981. _, err := c.PlatformDbEngine.Where("domain = ?", domain).Get(&domainObj)
  982. if err == nil {
  983. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", domainObj})
  984. } else {
  985. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  986. }
  987. }
  988. // _AddDomainMenu
  989. // @Title _AddDomainMenu
  990. // @Description 域添加菜单
  991. // @Param false "添加域菜单bean"
  992. // @Success 200 {object} Account
  993. // @Failure 403 :id is empty
  994. func System_AddDomainMenu(c *entitys.CtrlContext) {
  995. var paramObj0 struct {
  996. //域名ID
  997. DomainId string `json:"domain_id"`
  998. //菜单
  999. Menus []sysmodel.SysMenu `json:"menus"`
  1000. // type
  1001. Type int `json:"type"`
  1002. }
  1003. err := c.Ctx.BindJSON(&paramObj0)
  1004. if err != nil {
  1005. c.Ctx.JSON(500, sysmodel.SysReturn{500, "BindJSON error: " + err.Error(), nil})
  1006. return
  1007. }
  1008. var domain sysmodel.SysDomain
  1009. param := map[string]interface{}{"id": paramObj0.DomainId}
  1010. _, err = c.Db.SqlMapClient("selectone_sys_domain", &param).Get(&domain)
  1011. if err != nil {
  1012. c.Ctx.JSON(500, sysmodel.SysReturn{500, "not find domain error: " + err.Error(), nil})
  1013. return
  1014. }
  1015. var menuIds = make([]string, len(paramObj0.Menus))
  1016. for i := range paramObj0.Menus {
  1017. menuIds[i] = paramObj0.Menus[i].Id
  1018. }
  1019. var menus []sysmodel.SysMenu
  1020. err = c.Db.In("id", menuIds).Find(&menus)
  1021. if err != nil {
  1022. c.Ctx.JSON(500, sysmodel.SysReturn{500, "find menu error: " + err.Error(), nil})
  1023. return
  1024. }
  1025. for i := range menus {
  1026. for j := range paramObj0.Menus {
  1027. if menus[i].Id == paramObj0.Menus[j].Id {
  1028. menus[i].Name = paramObj0.Menus[j].Name
  1029. break
  1030. }
  1031. }
  1032. }
  1033. session := c.App.GetBusinessDb(domain.Domain).NewSession()
  1034. defer session.Close()
  1035. session.Begin()
  1036. deleteSqlMapKey := ""
  1037. if paramObj0.Type >= 0 {
  1038. deleteSqlMapKey = "delete_backend_sys_menu"
  1039. } else {
  1040. deleteSqlMapKey = "delete_app_sys_menu"
  1041. }
  1042. _, err = c.App.GetBusinessDb(domain.Domain).SqlMapClient(deleteSqlMapKey).Execute()
  1043. if err != nil {
  1044. session.Rollback()
  1045. c.Ctx.JSON(500, sysmodel.SysReturn{500, "Insert menu error: " + err.Error(), nil})
  1046. return
  1047. }
  1048. if len(paramObj0.Menus) <= 0 {
  1049. session.Commit()
  1050. c.Ctx.JSON(200, sysmodel.SysReturn{200, "the menus is empty", nil})
  1051. return
  1052. }
  1053. _, err = c.App.GetBusinessDb(domain.Domain).Insert(&paramObj0.Menus)
  1054. if err != nil {
  1055. session.Rollback()
  1056. c.Ctx.JSON(500, sysmodel.SysReturn{500, "Insert menu error: " + err.Error(), nil})
  1057. return
  1058. }
  1059. session.Commit()
  1060. ret := __none_func_system__(paramObj0)
  1061. if ret {
  1062. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1063. } else {
  1064. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  1065. }
  1066. }
  1067. // _GetDomainMenuTree
  1068. // @Title _GetDomainMenuTree
  1069. // @Description 域添加菜单
  1070. // @Param domain_id string false "域id"
  1071. // @Success 200 {object} Account
  1072. // @Failure 403 :id is empty
  1073. func System_GetDomainMenuTree(c *entitys.CtrlContext) {
  1074. domain_id := c.Ctx.Query("domain_id")
  1075. _type := c.Ctx.DefaultQuery("type", "")
  1076. type_op := c.Ctx.DefaultQuery("type_op", "")
  1077. op := template.HTML(type_op)
  1078. var domain sysmodel.SysDomain
  1079. param := map[string]interface{}{"id": domain_id, "type": _type, "type_op": op}
  1080. _, err := c.Db.SqlMapClient("selectone_sys_domain", &param).Get(&domain)
  1081. if err != nil {
  1082. c.Ctx.JSON(500, sysmodel.SysReturn{500, "not find domain error: " + err.Error(), nil})
  1083. return
  1084. }
  1085. paramMap := map[string]interface{}{"user_id": "", "type": _type, "type_op": op, "name": "", "hidden": ""}
  1086. domainMenus, err := c.App.GetBusinessDb(domain.Domain).SqlTemplateClient("system_get_menu_tree.tpl", &paramMap).Query().List()
  1087. if err != nil {
  1088. c.Ctx.JSON(500, sysmodel.SysReturn{500, "get domain_menu tree: " + err.Error(), nil})
  1089. return
  1090. }
  1091. domainTree, err := sysutils.BuildTree("", domainMenus)
  1092. sysMenus, err := c.Db.SqlTemplateClient("system_get_menu_tree.tpl", &paramMap).Query().List()
  1093. if err != nil {
  1094. c.Ctx.JSON(500, sysmodel.SysReturn{500, "get sys_menu tree: " + err.Error(), nil})
  1095. return
  1096. }
  1097. var sysMenusMap map[string]map[string]interface{}
  1098. sysMenusMap = make(map[string]map[string]interface{}, 0)
  1099. for _, menu := range sysMenus {
  1100. sysMenusMap[menu["id"].(string)] = menu
  1101. }
  1102. //剔除域已存在的菜单
  1103. //for _, domainMenu := range domainMenus {
  1104. // delete(sysMenusMap, domainMenu["id"].(string))
  1105. //}
  1106. var sysMenuRest []map[string]interface{}
  1107. for _, menu := range sysMenusMap {
  1108. sysMenuRest = append(sysMenuRest, menu)
  1109. }
  1110. sysTree, err := sysutils.BuildTree("", sysMenuRest)
  1111. ret := __none_func_system__(domain_id)
  1112. if ret {
  1113. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", map[string]interface{}{"sys_tree": sysTree, "domain_tree": domainTree}})
  1114. } else {
  1115. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  1116. }
  1117. }
  1118. // _GetUserMenuTree
  1119. // @Title _GetUserMenuTree
  1120. // @Description 获取用户权限菜单
  1121. // @Param user_id string false "用户id"
  1122. // @Success 200 {object} Account
  1123. // @Failure 403 :id is empty
  1124. func System_GetRoleMenuTree(c *entitys.CtrlContext) {
  1125. role_id := c.Ctx.Query("role_id")
  1126. //paramMap := map[string]interface{}{"role_id": role_id}
  1127. //sysMenu, err := c.Db.SqlMapClient("get_role_no_have_menu_tree", &paramMap).Query().List()
  1128. //if err != nil {
  1129. // c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1130. // return
  1131. //}
  1132. //sysTree, err := sysutils.BuildTree("", sysMenu)
  1133. op := template.HTML(">=")
  1134. paramMap := map[string]interface{}{"user_id": "", "sort": "name", "type": 0, "type_op": op, "hidden": 0}
  1135. sysTree, err := sysutils.TreeSearch(c.Db, "system", "get_menu_tree", "sys_menu", paramMap)
  1136. if err != nil {
  1137. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1138. return
  1139. }
  1140. paramMap2 := map[string]interface{}{"role_id": role_id}
  1141. //roleTree, err := sysutils.TreeSearch(c.Db, "system", "get_role_menu_tree", "sys_menu", paramMap2)
  1142. roleMenu, err := c.Db.SqlMapClient("get_role_menu_tree", &paramMap2).Query().List()
  1143. if err != nil {
  1144. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1145. return
  1146. }
  1147. roleTree, err := sysutils.BuildTree("", roleMenu)
  1148. ret := __none_func_system__(role_id)
  1149. if ret {
  1150. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", map[string]interface{}{"sys_tree": sysTree, "role_tree": roleTree}})
  1151. } else {
  1152. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  1153. }
  1154. }
  1155. // _AddRoleMenu
  1156. // @Title _AddRoleMenu
  1157. // @Description 添加角色菜单
  1158. // @Param menu_id false "菜单id"
  1159. // @Param role_id string false "角色id"
  1160. // @Success 200 {object} Account
  1161. // @Failure 403 :id is empty
  1162. func System_AddRoleMenu(c *entitys.CtrlContext) {
  1163. tk, _ := c.Ctx.Get("token")
  1164. user := tk.(*entitys.Token)
  1165. var paramObj0 struct {
  1166. MenuIds []string `json:"menu_ids"`
  1167. RoleId string `json:"role_id"`
  1168. }
  1169. c.Ctx.BindJSON(&paramObj0)
  1170. session := c.Db.NewSession()
  1171. defer session.Close()
  1172. session.Begin()
  1173. _, err := session.SqlMapClient("del_role_menu", paramObj0.RoleId).Execute()
  1174. if err != nil {
  1175. session.Rollback()
  1176. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1177. return
  1178. }
  1179. var roleMenus []*sysmodel.SysRoleMenu
  1180. for _, menu := range paramObj0.MenuIds {
  1181. roleMenu := &sysmodel.SysRoleMenu{}
  1182. roleMenu.Id = sysutils.NewUUID()
  1183. roleMenu.MenuId = menu
  1184. roleMenu.RoleId = paramObj0.RoleId
  1185. roleMenu.CreateBy = user.UserId
  1186. roleMenu.CreateTime = sysmodel.NowLocal()
  1187. roleMenus = append(roleMenus, roleMenu)
  1188. }
  1189. _, err = session.InsertMulti(&roleMenus)
  1190. if err != nil {
  1191. session.Rollback()
  1192. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1193. return
  1194. }
  1195. session.Commit()
  1196. ret := __none_func_system__(paramObj0)
  1197. if ret {
  1198. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1199. } else {
  1200. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  1201. }
  1202. }
  1203. // _FindAreaPage
  1204. // @Title _FindAreaPage
  1205. // @Description 获取区域管理分页数
  1206. // @Success 200 {object} Account
  1207. // @Failure 403 :id is empty
  1208. func System_FindAreaPage(c *entitys.CtrlContext) {
  1209. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  1210. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  1211. var paramMap = make(map[string]interface{})
  1212. paramMap["page"] = page
  1213. paramMap["rows"] = rows
  1214. paramMap["del_flag"] = c.Ctx.Query("del_flag")
  1215. paramMap["id"] = c.Ctx.Query("id")
  1216. paramMap["name"] = c.Ctx.Query("name")
  1217. paramMap["parent"] = c.Ctx.Query("parent")
  1218. paramMap["inheritance"] = c.Ctx.Query("inheritance")
  1219. paramMap["temp_id"] = c.Ctx.Query("temp_id")
  1220. paramMap["manager"] = c.Ctx.Query("manager")
  1221. paramMap["org_id"] = c.Ctx.Query("org_id")
  1222. paramMap["org_name"] = c.Ctx.Query("org_name")
  1223. paramMap["org_inheritance"] = c.Ctx.Query("org_inheritance")
  1224. paramMap["manager_name"] = c.Ctx.Query("manager_name")
  1225. result, err := sysutils.PageSearch(c.Db, "system", "find_area_page", "sys_user", paramMap)
  1226. if err == nil {
  1227. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1228. } else {
  1229. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1230. }
  1231. }
  1232. // _AddArea
  1233. // @Title _AddArea
  1234. // @Description 添加区域
  1235. // @Param name string false "区域名称"
  1236. // @Param parent string false "父节点"
  1237. // @Param inheritance string false "继承关系"
  1238. // @Param org_id string false "组织ID"
  1239. // @Param temp_id string false "模板ID"
  1240. // @Param temp_value string false "模板内容"
  1241. // @Param manager string false "负责人"
  1242. // @Success 200 {object} Account
  1243. // @Failure 403 :id is empty
  1244. func System_AddArea(c *entitys.CtrlContext) {
  1245. var err error
  1246. var bean sysmodel.SysArea
  1247. if err = c.Ctx.BindJSON(&bean); err != nil {
  1248. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1249. return
  1250. }
  1251. user_id := c.Ctx.GetString("user_id")
  1252. bean.Id = sysutils.NewUUID()
  1253. bean.DelFlag = 0
  1254. bean.CreateBy = user_id
  1255. bean.LastUpdateBy = user_id
  1256. bean.CreateTime = sysmodel.NowLocal()
  1257. bean.LastUpdateTime = time.Now().UnixNano()
  1258. if bean.Parent != "" {
  1259. parentNodes := sysmodel.SysArea{}
  1260. _, err := c.Db.SqlMapClient("selectone_sys_area", &map[string]interface{}{"id": bean.Parent}).Get(&parentNodes)
  1261. if err != nil {
  1262. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1263. return
  1264. }
  1265. bean.Inheritance = fmt.Sprintf("|%s%s", bean.Id, parentNodes.Inheritance)
  1266. } else {
  1267. bean.Inheritance = fmt.Sprintf("|%s|", bean.Id)
  1268. }
  1269. _, err = c.Db.InsertOne(&bean)
  1270. if err == nil {
  1271. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1272. } else {
  1273. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1274. }
  1275. }
  1276. // _DelArea
  1277. // @Title _DelArea
  1278. // @Description 删除区域
  1279. // @Param ids string false "用户ID"
  1280. // @Success 200 {object} Account
  1281. // @Failure 403 :id is empty
  1282. func System_DelArea(c *entitys.CtrlContext) {
  1283. var err error
  1284. var bean = &models.SysArea{}
  1285. type Param struct {
  1286. Id string `json:"id"`
  1287. }
  1288. var params []Param
  1289. c.Ctx.BindJSON(&params)
  1290. ids := []string{}
  1291. for _, param := range params {
  1292. ids = append(ids, param.Id)
  1293. }
  1294. session := c.Db.NewSession()
  1295. defer session.Close()
  1296. if err := session.Begin(); err != nil {
  1297. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1298. return
  1299. }
  1300. _, err = session.Table(bean).Where("del_flag=1").In("id", ids).Delete(bean)
  1301. if err == nil {
  1302. _, err = session.Table(bean).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  1303. }
  1304. if err == nil {
  1305. err = session.Commit()
  1306. }
  1307. if err == nil {
  1308. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1309. } else {
  1310. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1311. }
  1312. }
  1313. // _RecoverArea
  1314. // @Title _RecoverArea
  1315. // @Description 恢复区域
  1316. // @Param ids string false "区域ID"
  1317. // @Success 200 {object} Account
  1318. // @Failure 403 :id is empty
  1319. func System_RecoverArea(c *entitys.CtrlContext) {
  1320. var err error
  1321. var bean = &models.SysArea{}
  1322. idArr := make([]string, 0)
  1323. if ids := c.Ctx.Query("ids"); ids == "" {
  1324. err = c.Ctx.BindJSON(&idArr)
  1325. if err != nil || len(idArr) <= 0 {
  1326. c.Ctx.JSON(500, sysmodel.SysReturn{500, "ids is empty", nil})
  1327. return
  1328. }
  1329. } else {
  1330. idArr = strings.Split(ids, ",")
  1331. }
  1332. _, err = c.Db.Table(bean).In("id", idArr).Update(map[string]interface{}{"del_flag": 0})
  1333. if err == nil {
  1334. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1335. } else {
  1336. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1337. }
  1338. }
  1339. // _UpdateArea
  1340. // @Title _UpdateArea
  1341. // @Description 修改区域
  1342. // @Param name string false "区域名称"
  1343. // @Param parent string false "父节点"
  1344. // @Param inheritance string false "继承关系"
  1345. // @Param org_id string false "组织ID"
  1346. // @Param temp_id string false "模板ID"
  1347. // @Param temp_value string false "模板内容"
  1348. // @Param manager string false "负责人"
  1349. // @Success 200 {object} Account
  1350. // @Failure 403 :id is empty
  1351. func System_UpdateArea(c *entitys.CtrlContext) {
  1352. var err error
  1353. var bean sysmodel.SysArea
  1354. if err = c.Ctx.BindJSON(&bean); err != nil {
  1355. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1356. return
  1357. }
  1358. user_id := c.Ctx.GetString("user_id")
  1359. exist, err := c.Db.Table(&bean).Where("id = ?", bean.Id).Exist()
  1360. if !exist && err == nil {
  1361. err = errors.New("record does not exist")
  1362. }
  1363. if err != nil {
  1364. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1365. return
  1366. }
  1367. bean.LastUpdateBy = user_id
  1368. bean.LastUpdateTime = time.Now().UnixNano()
  1369. if bean.Parent != "" {
  1370. parentNodes := sysmodel.SysArea{}
  1371. _, err := c.Db.SqlMapClient("selectone_sys_area", &map[string]interface{}{"id": bean.Parent}).Get(&parentNodes)
  1372. if err != nil {
  1373. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1374. return
  1375. }
  1376. if parentNodes.Inheritance == "" {
  1377. parentNodes.Inheritance = "|"
  1378. }
  1379. bean.Inheritance = fmt.Sprintf("|%s%s", bean.Id, parentNodes.Inheritance)
  1380. } else {
  1381. bean.Inheritance = fmt.Sprintf("|%s|", bean.Id)
  1382. }
  1383. _, err = c.Db.AllCols().ID(bean.Id).Update(&bean)
  1384. if err == nil {
  1385. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1386. } else {
  1387. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1388. }
  1389. }
  1390. // _GetArea
  1391. // @Title _GetArea
  1392. // @Description 根据区域ID获取区域信息
  1393. // @Param id string false "区域ID"
  1394. // @Success 200 {object} Account
  1395. // @Failure 403 :id is empty
  1396. func System_GetArea(c *entitys.CtrlContext) {
  1397. id := c.Ctx.Query("id")
  1398. //var area sysmodel.SysArea
  1399. //exist, err := c.Db.SqlMapClient("get_area", &map[string]interface{}{"id": id}).Get(&area)
  1400. result := c.Db.SqlMapClient("get_area", &map[string]interface{}{"id": id}).Query()
  1401. if result.Result != nil && len(result.Result) > 0 {
  1402. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result.Result[0]})
  1403. } else {
  1404. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  1405. }
  1406. }
  1407. // _GetAreaTree
  1408. // @Title _GetAreaTree
  1409. // @Description 获取区域管理树
  1410. // @Success 200 {object} Account
  1411. // @Failure 403 :id is empty
  1412. func System_GetAreaTree(c *entitys.CtrlContext) {
  1413. paramMap_i_t := map[string]interface{}{"sort": "name"}
  1414. result, err := sysutils.TreeSearch(c.Db, "system", "get_area_tree", "sys_area", paramMap_i_t)
  1415. if err == nil {
  1416. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1417. } else {
  1418. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1419. }
  1420. }
  1421. // _FindAreaTemplatePage
  1422. // @Title _FindAreaTemplatePage
  1423. // @Description 获取区域模板分页数
  1424. // @Success 200 {object} Account
  1425. // @Failure 403 :id is empty
  1426. func System_FindAreaTemplatePage(c *entitys.CtrlContext) {
  1427. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  1428. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  1429. del_flag := c.Ctx.Query("del_flag")
  1430. name := c.Ctx.Query("name")
  1431. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "del_flag": del_flag, "name": name}
  1432. result, err := sysutils.PageSearch(c.Db, "system", "find_area_template_page", "sys_area", paramMap_i_t)
  1433. if err == nil {
  1434. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1435. } else {
  1436. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1437. }
  1438. }
  1439. // _AddAreaTemplate
  1440. // @Title _AddAreaTemplate
  1441. // @Description 添加区域模板
  1442. // @Param name string false "名称"
  1443. // @Param type int64 false "模板类型 0:固定模板 1:动态模板 2:自定义模板"
  1444. // @Param default int64 false "是否默认 1:是 0:否"
  1445. // @Success 200 {object} Account
  1446. // @Failure 403 :id is empty
  1447. func System_AddAreaTemplate(c *entitys.CtrlContext) {
  1448. var err error
  1449. var bean sysmodel.SysAreaTemplate
  1450. if err = c.Ctx.BindJSON(&bean); err != nil {
  1451. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1452. return
  1453. }
  1454. user_id := c.Ctx.GetString("user_id")
  1455. bean.Id = sysutils.NewUUID()
  1456. bean.DelFlag = 0
  1457. bean.CreateBy = user_id
  1458. bean.LastUpdateBy = user_id
  1459. bean.CreateTime = sysmodel.NowLocal()
  1460. bean.LastUpdateTime = time.Now().UnixNano()
  1461. _, err = c.Db.InsertOne(&bean)
  1462. if err == nil {
  1463. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1464. } else {
  1465. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1466. }
  1467. }
  1468. // _UpdateAreaTemplate
  1469. // @Title _UpdateAreaTemplate
  1470. // @Description 修改区域模板
  1471. // @Param name string false "名称"
  1472. // @Param type int64 false "模板类型 0:固定模板 1:动态模板 2:自定义模板"
  1473. // @Param default int64 false "是否默认 1:是 0:否"
  1474. // @Success 200 {object} Account
  1475. // @Failure 403 :id is empty
  1476. func System_UpdateAreaTemplate(c *entitys.CtrlContext) {
  1477. var err error
  1478. var bean sysmodel.SysAreaTemplate
  1479. if err = c.Ctx.BindJSON(&bean); err != nil {
  1480. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1481. return
  1482. }
  1483. user_id := c.Ctx.GetString("user_id")
  1484. exist, err := c.Db.Table(&bean).Where("id = ?", bean.Id).Exist()
  1485. if !exist && err == nil {
  1486. err = errors.New("record does not exist")
  1487. }
  1488. if err != nil {
  1489. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1490. return
  1491. }
  1492. bean.LastUpdateBy = user_id
  1493. bean.LastUpdateTime = time.Now().UnixNano()
  1494. _, err = c.Db.AllCols().ID(bean.Id).Update(&bean)
  1495. if err == nil {
  1496. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1497. } else {
  1498. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1499. }
  1500. }
  1501. // _DelAreaTemplate
  1502. // @Title _DelAreaTemplate
  1503. // @Description 删除区域模板
  1504. // @Param ids string false "区域模板ID 多个之间(,)隔开"
  1505. // @Success 200 {object} Account
  1506. // @Failure 403 :id is empty
  1507. func System_DelAreaTemplate(c *entitys.CtrlContext) {
  1508. var err error
  1509. var bean = &models.SysAreaTemplate{}
  1510. type Param struct {
  1511. Id string `json:"id"`
  1512. }
  1513. var params []Param
  1514. c.Ctx.BindJSON(&params)
  1515. ids := []string{}
  1516. for _, param := range params {
  1517. ids = append(ids, param.Id)
  1518. }
  1519. session := c.Db.NewSession()
  1520. defer session.Close()
  1521. if err := session.Begin(); err != nil {
  1522. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1523. return
  1524. }
  1525. _, err = session.Table(bean).Where("del_flag=1").In("id", ids).Delete(bean)
  1526. if err == nil {
  1527. _, err = session.Table(bean).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  1528. }
  1529. if err == nil {
  1530. err = session.Commit()
  1531. }
  1532. if err == nil {
  1533. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1534. } else {
  1535. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1536. }
  1537. }
  1538. // _RecoverAreaTemplate
  1539. // @Title _RecoverAreaTemplate
  1540. // @Description 恢复区域模板
  1541. // @Param ids string false "区域模板ID 多个之间(,)隔开"
  1542. // @Success 200 {object} Account
  1543. // @Failure 403 :id is empty
  1544. func System_RecoverAreaTemplate(c *entitys.CtrlContext) {
  1545. var err error
  1546. var bean = &models.SysAreaTemplate{}
  1547. idArr := make([]string, 0)
  1548. if ids := c.Ctx.Query("ids"); ids == "" {
  1549. err = c.Ctx.BindJSON(&idArr)
  1550. if err != nil || len(idArr) <= 0 {
  1551. c.Ctx.JSON(500, sysmodel.SysReturn{500, "ids is empty", nil})
  1552. return
  1553. }
  1554. } else {
  1555. idArr = strings.Split(ids, ",")
  1556. }
  1557. _, err = c.Db.Table(bean).In("id", idArr).Update(map[string]interface{}{"del_flag": 0})
  1558. if err == nil {
  1559. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1560. } else {
  1561. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1562. }
  1563. }
  1564. // _GetAreaTemplate
  1565. // @Title _GetAreaTemplate
  1566. // @Description 根据区域模板ID获取区域模板信息
  1567. // @Param id string false "区域模板ID"
  1568. // @Success 200 {object} Account
  1569. // @Failure 403 :id is empty
  1570. func System_GetAreaTemplate(c *entitys.CtrlContext) {
  1571. id := c.Ctx.Query("id")
  1572. var area sysmodel.SysAreaTemplate
  1573. exist, err := c.Db.SqlMapClient("selectone_sys_area_template", &map[string]interface{}{"id": id}).Get(&area)
  1574. if !exist && err == nil {
  1575. err = errors.New("record does not exist")
  1576. }
  1577. if err == nil {
  1578. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", area})
  1579. } else {
  1580. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1581. }
  1582. }
  1583. // _FindAreaTemplateDetailPage
  1584. // @Title _FindAreaTemplateDetailPage
  1585. // @Description 获取区域模板明细分页数
  1586. // @Success 200 {object} Account
  1587. // @Failure 403 :id is empty
  1588. func System_FindAreaTemplateDetailPage(c *entitys.CtrlContext) {
  1589. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  1590. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  1591. del_flag := c.Ctx.Query("del_flag")
  1592. __sort__ := c.Ctx.Query("__sort__")
  1593. name := c.Ctx.Query("name")
  1594. temp_id := c.Ctx.Query("temp_id")
  1595. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "del_flag": del_flag, "name": name, "temp_id": temp_id, "__sort__": __sort__}
  1596. result, err := sysutils.PageSearch(c.Db, "system", "find_area_template_detail_page", "sys_area", paramMap_i_t)
  1597. if err == nil {
  1598. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1599. } else {
  1600. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1601. }
  1602. }
  1603. // _AddAreaTemplateDetail
  1604. // @Title _AddAreaTemplateDetail
  1605. // @Description 添加区域模板明细
  1606. // @Param temp_id string false "模板id"
  1607. // @Param name string false "名称"
  1608. // @Param value string false "值"
  1609. // @Param type int64 false "类型 0:数值项 1:单选项 2:文字项 3:列表项"
  1610. // @Param priority int64 false "优先级"
  1611. // @Param content string false "内容"
  1612. // @Success 200 {object} Account
  1613. // @Failure 403 :id is empty
  1614. func System_AddAreaTemplateDetail(c *entitys.CtrlContext) {
  1615. var err error
  1616. var bean sysmodel.SysAreaTemplateDetail
  1617. if err = c.Ctx.BindJSON(&bean); err != nil {
  1618. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1619. return
  1620. }
  1621. user_id := c.Ctx.GetString("user_id")
  1622. bean.Id = sysutils.NewUUID()
  1623. bean.DelFlag = 0
  1624. bean.CreateBy = user_id
  1625. bean.LastUpdateBy = user_id
  1626. bean.CreateTime = sysmodel.NowLocal()
  1627. bean.LastUpdateTime = time.Now().UnixNano()
  1628. _, err = c.Db.InsertOne(&bean)
  1629. if err == nil {
  1630. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1631. } else {
  1632. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1633. }
  1634. }
  1635. // _UpdateAreaTemplateDetail
  1636. // @Title _UpdateAreaTemplateDetail
  1637. // @Description 修改区域模板明细
  1638. // @Param temp_id string false "模板id"
  1639. // @Param name string false "名称"
  1640. // @Param value string false "值"
  1641. // @Param type int64 false "类型 0:数值项 1:单选项 2:文字项 3:列表项"
  1642. // @Param priority int64 false "优先级"
  1643. // @Param content string false "内容"
  1644. // @Success 200 {object} Account
  1645. // @Failure 403 :id is empty
  1646. func System_UpdateAreaTemplateDetail(c *entitys.CtrlContext) {
  1647. var err error
  1648. var bean sysmodel.SysAreaTemplateDetail
  1649. if err = c.Ctx.BindJSON(&bean); err != nil {
  1650. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1651. return
  1652. }
  1653. user_id := c.Ctx.GetString("user_id")
  1654. exist, err := c.Db.Table(&bean).Where("id = ?", bean.Id).Exist()
  1655. if !exist && err == nil {
  1656. err = errors.New("record does not exist")
  1657. }
  1658. if err != nil {
  1659. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1660. return
  1661. }
  1662. bean.LastUpdateBy = user_id
  1663. bean.LastUpdateTime = time.Now().UnixNano()
  1664. _, err = c.Db.AllCols().ID(bean.Id).Update(&bean)
  1665. if err == nil {
  1666. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1667. } else {
  1668. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1669. }
  1670. }
  1671. // _DelAreaTemplateDetail
  1672. // @Title _DelAreaTemplateDetail
  1673. // @Description 删除区域模板明细
  1674. // @Param ids string false "区域模板明细ID 多个之间(,)隔开"
  1675. // @Success 200 {object} Account
  1676. // @Failure 403 :id is empty
  1677. func System_DelAreaTemplateDetail(c *entitys.CtrlContext) {
  1678. var err error
  1679. var bean = &models.SysAreaTemplateDetail{}
  1680. type Param struct {
  1681. Id string `json:"id"`
  1682. }
  1683. var params []Param
  1684. c.Ctx.BindJSON(&params)
  1685. ids := []string{}
  1686. for _, param := range params {
  1687. ids = append(ids, param.Id)
  1688. }
  1689. session := c.Db.NewSession()
  1690. defer session.Close()
  1691. if err := session.Begin(); err != nil {
  1692. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1693. return
  1694. }
  1695. _, err = session.Table(bean).Where("del_flag=1").In("id", ids).Delete(bean)
  1696. if err == nil {
  1697. _, err = session.Table(bean).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  1698. }
  1699. if err == nil {
  1700. err = session.Commit()
  1701. }
  1702. if err == nil {
  1703. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1704. } else {
  1705. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1706. }
  1707. }
  1708. // _RecoverAreaTemplateDetail
  1709. // @Title _RecoverAreaTemplateDetail
  1710. // @Description 恢复区域模板明细
  1711. // @Param ids string false "区域模板明细ID 多个之间(,)隔开"
  1712. // @Success 200 {object} Account
  1713. // @Failure 403 :id is empty
  1714. func System_RecoverAreaTemplateDetail(c *entitys.CtrlContext) {
  1715. var err error
  1716. var bean = &models.SysAreaTemplateDetail{}
  1717. idArr := make([]string, 0)
  1718. if ids := c.Ctx.Query("ids"); ids == "" {
  1719. err = c.Ctx.BindJSON(&idArr)
  1720. if err != nil || len(idArr) <= 0 {
  1721. c.Ctx.JSON(500, sysmodel.SysReturn{500, "ids is empty", nil})
  1722. return
  1723. }
  1724. } else {
  1725. idArr = strings.Split(ids, ",")
  1726. }
  1727. _, err = c.Db.Table(bean).In("id", idArr).Update(map[string]interface{}{"del_flag": 0})
  1728. if err == nil {
  1729. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1730. } else {
  1731. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1732. }
  1733. }
  1734. // _GetAreaTemplateDetail
  1735. // @Title _GetAreaTemplateDetail
  1736. // @Description 根据区域模板明细ID获取区域模板明细信息
  1737. // @Param id string false "区域模板明细ID"
  1738. // @Success 200 {object} Account
  1739. // @Failure 403 :id is empty
  1740. func System_GetAreaTemplateDetail(c *entitys.CtrlContext) {
  1741. id := c.Ctx.Query("id")
  1742. var area sysmodel.SysAreaTemplateDetail
  1743. exist, err := c.Db.SqlMapClient("selectone_sys_area_template_detail", &map[string]interface{}{"id": id}).Get(&area)
  1744. if !exist && err == nil {
  1745. err = errors.New("record does not exist")
  1746. }
  1747. if err == nil {
  1748. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", area})
  1749. } else {
  1750. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1751. }
  1752. }
  1753. // _FindUserTemplatePage
  1754. // @Title _FindUserTemplatePage
  1755. // @Description 获取用户信息模板分页数
  1756. // @Success 200 {object} Account
  1757. // @Failure 403 :id is empty
  1758. func System_FindUserTemplatePage(c *entitys.CtrlContext) {
  1759. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  1760. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  1761. del_flag := c.Ctx.Query("del_flag")
  1762. name := c.Ctx.Query("name")
  1763. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "del_flag": del_flag, "name": name}
  1764. result, err := sysutils.PageSearch(c.Db, "system", "find_user_template_page", "sys_area", paramMap_i_t)
  1765. if err == nil {
  1766. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1767. } else {
  1768. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1769. }
  1770. }
  1771. // _AddUserTemplate
  1772. // @Title _AddUserTemplate
  1773. // @Description 添加用户信息模板
  1774. // @Param name string false "名称"
  1775. // @Param type int64 false "模板类型 0:固定模板 1:动态模板 2:自定义模板"
  1776. // @Param default int64 false "是否默认 1:是 0:否"
  1777. // @Success 200 {object} Account
  1778. // @Failure 403 :id is empty
  1779. func System_AddUserTemplate(c *entitys.CtrlContext) {
  1780. var err error
  1781. var bean sysmodel.SysUserTemplate
  1782. if err = c.Ctx.BindJSON(&bean); err != nil {
  1783. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1784. return
  1785. }
  1786. user_id := c.Ctx.GetString("user_id")
  1787. bean.Id = sysutils.NewUUID()
  1788. bean.DelFlag = 0
  1789. bean.CreateBy = user_id
  1790. bean.LastUpdateBy = user_id
  1791. bean.CreateTime = sysmodel.NowLocal()
  1792. bean.LastUpdateTime = time.Now().UnixNano()
  1793. _, err = c.Db.InsertOne(&bean)
  1794. if err == nil {
  1795. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1796. } else {
  1797. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1798. }
  1799. }
  1800. // _UpdateUserTemplate
  1801. // @Title _UpdateUserTemplate
  1802. // @Description 修改用户信息模板
  1803. // @Param name string false "名称"
  1804. // @Param type int64 false "模板类型 0:固定模板 1:动态模板 2:自定义模板"
  1805. // @Param default int64 false "是否默认 1:是 0:否"
  1806. // @Success 200 {object} Account
  1807. // @Failure 403 :id is empty
  1808. func System_UpdateUserTemplate(c *entitys.CtrlContext) {
  1809. var err error
  1810. var bean sysmodel.SysUserTemplate
  1811. if err = c.Ctx.BindJSON(&bean); err != nil {
  1812. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1813. return
  1814. }
  1815. user_id := c.Ctx.GetString("user_id")
  1816. exist, err := c.Db.Table(&bean).Where("id = ?", bean.Id).Exist()
  1817. if !exist && err == nil {
  1818. err = errors.New("record does not exist")
  1819. }
  1820. if err != nil {
  1821. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1822. return
  1823. }
  1824. bean.LastUpdateBy = user_id
  1825. bean.LastUpdateTime = time.Now().UnixNano()
  1826. _, err = c.Db.AllCols().ID(bean.Id).Update(&bean)
  1827. if err == nil {
  1828. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1829. } else {
  1830. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1831. }
  1832. }
  1833. // _DelUserTemplate
  1834. // @Title _DelUserTemplate
  1835. // @Description 删除用户信息模板
  1836. // @Param ids string false "用户信息模板ID 多个之间(,)隔开"
  1837. // @Success 200 {object} Account
  1838. // @Failure 403 :id is empty
  1839. func System_DelUserTemplate(c *entitys.CtrlContext) {
  1840. var err error
  1841. var bean = &models.SysUserTemplate{}
  1842. type Param struct {
  1843. Id string `json:"id"`
  1844. }
  1845. var params []Param
  1846. c.Ctx.BindJSON(&params)
  1847. ids := []string{}
  1848. for _, param := range params {
  1849. ids = append(ids, param.Id)
  1850. }
  1851. session := c.Db.NewSession()
  1852. defer session.Close()
  1853. if err := session.Begin(); err != nil {
  1854. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1855. return
  1856. }
  1857. _, err = session.Table(bean).Where("del_flag=1").In("id", ids).Delete(bean)
  1858. if err == nil {
  1859. _, err = session.Table(bean).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  1860. }
  1861. if err == nil {
  1862. err = session.Commit()
  1863. }
  1864. if err == nil {
  1865. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1866. } else {
  1867. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1868. }
  1869. }
  1870. // _RecoverUserTemplate
  1871. // @Title _RecoverUserTemplate
  1872. // @Description 恢复用户信息模板
  1873. // @Param ids string false "用户信息模板ID 多个之间(,)隔开"
  1874. // @Success 200 {object} Account
  1875. // @Failure 403 :id is empty
  1876. func System_RecoverUserTemplate(c *entitys.CtrlContext) {
  1877. var err error
  1878. var bean = &models.SysUserTemplate{}
  1879. idArr := make([]string, 0)
  1880. if ids := c.Ctx.Query("ids"); ids == "" {
  1881. err = c.Ctx.BindJSON(&idArr)
  1882. if err != nil || len(idArr) <= 0 {
  1883. c.Ctx.JSON(500, sysmodel.SysReturn{500, "ids is empty", nil})
  1884. return
  1885. }
  1886. } else {
  1887. idArr = strings.Split(ids, ",")
  1888. }
  1889. _, err = c.Db.Table(bean).In("id", idArr).Update(map[string]interface{}{"del_flag": 0})
  1890. if err == nil {
  1891. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  1892. } else {
  1893. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1894. }
  1895. }
  1896. // _GetUserTemplate
  1897. // @Title _GetUserTemplate
  1898. // @Description 根据用户信息模板ID获取用户信息模板信息
  1899. // @Param id string false "用户信息模板ID"
  1900. // @Success 200 {object} Account
  1901. // @Failure 403 :id is empty
  1902. func System_GetUserTemplate(c *entitys.CtrlContext) {
  1903. id := c.Ctx.Query("id")
  1904. var area sysmodel.SysUserTemplate
  1905. exist, err := c.Db.SqlMapClient("selectone_sys_user_template", &map[string]interface{}{"id": id}).Get(&area)
  1906. if !exist && err == nil {
  1907. err = errors.New("record does not exist")
  1908. }
  1909. if err == nil {
  1910. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", area})
  1911. } else {
  1912. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1913. }
  1914. }
  1915. // _FindUserTemplateDetailPage
  1916. // @Title _FindUserTemplateDetailPage
  1917. // @Description 获取用户信息模板明细分页数
  1918. // @Success 200 {object} Account
  1919. // @Failure 403 :id is empty
  1920. func System_FindUserTemplateDetailPage(c *entitys.CtrlContext) {
  1921. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  1922. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  1923. del_flag := c.Ctx.Query("del_flag")
  1924. __sort__ := c.Ctx.Query("__sort__")
  1925. name := c.Ctx.Query("name")
  1926. temp_id := c.Ctx.Query("temp_id")
  1927. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "del_flag": del_flag, "name": name, "temp_id": temp_id, "__sort__": __sort__}
  1928. result, err := sysutils.PageSearch(c.Db, "system", "find_user_template_detail_page", "sys_area", paramMap_i_t)
  1929. if err == nil {
  1930. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  1931. } else {
  1932. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1933. }
  1934. }
  1935. // _AddUserTemplateDetail
  1936. // @Title _AddUserTemplateDetail
  1937. // @Description 添加用户信息模板明细
  1938. // @Param temp_id string false "模板id"
  1939. // @Param name string false "名称"
  1940. // @Param value string false "值"
  1941. // @Param type int64 false "类型 0:数值项 1:单选项 2:文字项 3:列表项"
  1942. // @Param priority int64 false "优先级"
  1943. // @Param content string false "内容"
  1944. // @Success 200 {object} Account
  1945. // @Failure 403 :id is empty
  1946. func System_AddUserTemplateDetail(c *entitys.CtrlContext) {
  1947. var err error
  1948. var bean sysmodel.SysUserTemplateDetail
  1949. if err = c.Ctx.BindJSON(&bean); err != nil {
  1950. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1951. return
  1952. }
  1953. user_id := c.Ctx.GetString("user_id")
  1954. bean.Id = sysutils.NewUUID()
  1955. bean.DelFlag = 0
  1956. bean.CreateBy = user_id
  1957. bean.LastUpdateBy = user_id
  1958. bean.CreateTime = sysmodel.NowLocal()
  1959. bean.LastUpdateTime = time.Now().UnixNano()
  1960. _, err = c.Db.InsertOne(&bean)
  1961. if err == nil {
  1962. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1963. } else {
  1964. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1965. }
  1966. }
  1967. // _UpdateUserTemplateDetail
  1968. // @Title _UpdateUserTemplateDetail
  1969. // @Description 修改用户信息模板明细
  1970. // @Param temp_id string false "模板id"
  1971. // @Param name string false "名称"
  1972. // @Param value string false "值"
  1973. // @Param type int64 false "类型 0:数值项 1:单选项 2:文字项 3:列表项"
  1974. // @Param priority int64 false "优先级"
  1975. // @Param content string false "内容"
  1976. // @Success 200 {object} Account
  1977. // @Failure 403 :id is empty
  1978. func System_UpdateUserTemplateDetail(c *entitys.CtrlContext) {
  1979. var err error
  1980. var bean sysmodel.SysUserTemplateDetail
  1981. if err = c.Ctx.BindJSON(&bean); err != nil {
  1982. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  1983. return
  1984. }
  1985. user_id := c.Ctx.GetString("user_id")
  1986. exist, err := c.Db.Table(&bean).Where("id = ?", bean.Id).Exist()
  1987. if !exist && err == nil {
  1988. err = errors.New("record does not exist")
  1989. }
  1990. if err != nil {
  1991. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  1992. return
  1993. }
  1994. bean.LastUpdateBy = user_id
  1995. bean.LastUpdateTime = time.Now().UnixNano()
  1996. _, err = c.Db.AllCols().ID(bean.Id).Update(&bean)
  1997. if err == nil {
  1998. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", bean.Id})
  1999. } else {
  2000. c.Ctx.JSON(200, sysmodel.SysReturn{500, err.Error(), nil})
  2001. }
  2002. }
  2003. // _DelUserTemplateDetail
  2004. // @Title _DelUserTemplateDetail
  2005. // @Description 删除用户信息模板明细
  2006. // @Param ids string false "用户信息模板明细ID 多个之间(,)隔开"
  2007. // @Success 200 {object} Account
  2008. // @Failure 403 :id is empty
  2009. func System_DelUserTemplateDetail(c *entitys.CtrlContext) {
  2010. var err error
  2011. var bean = &models.SysUserTemplateDetail{}
  2012. type Param struct {
  2013. Id string `json:"id"`
  2014. }
  2015. var params []Param
  2016. c.Ctx.BindJSON(&params)
  2017. ids := []string{}
  2018. for _, param := range params {
  2019. ids = append(ids, param.Id)
  2020. }
  2021. session := c.Db.NewSession()
  2022. defer session.Close()
  2023. if err := session.Begin(); err != nil {
  2024. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2025. return
  2026. }
  2027. _, err = session.Table(bean).Where("del_flag=1").In("id", ids).Delete(bean)
  2028. if err == nil {
  2029. _, err = session.Table(bean).In("id", ids).Update(map[string]interface{}{"del_flag": 1})
  2030. }
  2031. if err == nil {
  2032. err = session.Commit()
  2033. }
  2034. if err == nil {
  2035. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2036. } else {
  2037. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2038. }
  2039. }
  2040. // _RecoverUserTemplateDetail
  2041. // @Title _RecoverUserTemplateDetail
  2042. // @Description 恢复用户信息模板明细
  2043. // @Param ids string false "用户信息模板明细ID 多个之间(,)隔开"
  2044. // @Success 200 {object} Account
  2045. // @Failure 403 :id is empty
  2046. func System_RecoverUserTemplateDetail(c *entitys.CtrlContext) {
  2047. var err error
  2048. var bean = &models.SysUserTemplateDetail{}
  2049. idArr := make([]string, 0)
  2050. if ids := c.Ctx.Query("ids"); ids == "" {
  2051. err = c.Ctx.BindJSON(&idArr)
  2052. if err != nil || len(idArr) <= 0 {
  2053. c.Ctx.JSON(500, sysmodel.SysReturn{500, "ids is empty", nil})
  2054. return
  2055. }
  2056. } else {
  2057. idArr = strings.Split(ids, ",")
  2058. }
  2059. _, err = c.Db.Table(bean).In("id", idArr).Update(map[string]interface{}{"del_flag": 0})
  2060. if err == nil {
  2061. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2062. } else {
  2063. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2064. }
  2065. }
  2066. // _GetUserTemplateDetail
  2067. // @Title _GetUserTemplateDetail
  2068. // @Description 根据用户信息模板明细ID获取用户信息模板明细信息
  2069. // @Param id string false "用户信息模板明细ID"
  2070. // @Success 200 {object} Account
  2071. // @Failure 403 :id is empty
  2072. func System_GetUserTemplateDetail(c *entitys.CtrlContext) {
  2073. id := c.Ctx.Query("id")
  2074. var area sysmodel.SysUserTemplateDetail
  2075. exist, err := c.Db.SqlMapClient("selectone_sys_user_template_detail", &map[string]interface{}{"id": id}).Get(&area)
  2076. if !exist && err == nil {
  2077. err = errors.New("record does not exist")
  2078. }
  2079. if err == nil {
  2080. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", area})
  2081. } else {
  2082. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2083. }
  2084. }
  2085. // _AddOptionset
  2086. // @Title _AddOptionset
  2087. // @Description 添加字典
  2088. // @Param false "字典"
  2089. // @Success 200 {object} Account
  2090. // @Failure 403 :id is empty
  2091. func System_AddOptionset(c *entitys.CtrlContext) {
  2092. var paramObj0 models.SysOptionset
  2093. c.Ctx.BindJSON(&paramObj0)
  2094. user_id := c.Ctx.GetString("user_id")
  2095. paramObj0.Id = sysutils.NewUUID()
  2096. paramObj0.CreateBy = user_id
  2097. paramObj0.CreateTime = sysmodel.NowLocal()
  2098. paramObj0.LastUpdateTime = time.Now().UnixNano()
  2099. paramObj0.LastUpdateBy = user_id
  2100. paramObj0.DelFlag = 0
  2101. paramMap, _ := sysutils.BeanToMap(&paramObj0)
  2102. _, err := c.Db.SqlMapClient("insert_sys_optionset", paramMap).Execute()
  2103. if err == nil {
  2104. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2105. } else {
  2106. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2107. }
  2108. }
  2109. // _DelOptionset
  2110. // @Title _DelOptionset
  2111. // @Description 删除字典
  2112. // @Param id string false "字典ID"
  2113. // @Success 200 {object} Account
  2114. // @Failure 403 :id is empty
  2115. func System_DelOptionset(c *entitys.CtrlContext) {
  2116. type Param struct {
  2117. Id string `json:"id"`
  2118. }
  2119. var params []Param
  2120. c.Ctx.BindJSON(&params)
  2121. ids := []string{}
  2122. for _, param := range params {
  2123. ids = append(ids, param.Id)
  2124. }
  2125. _, err := c.Db.Table(new(models.SysOptionset)).In("id", ids).Update(map[string]interface{}{"del_flag": 1, "last_update_time": time.Now().UnixNano(), "last_update_by": c.Ctx.GetString("user_id")})
  2126. if err == nil {
  2127. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2128. } else {
  2129. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  2130. }
  2131. }
  2132. // _UpdateOptionset
  2133. // @Title _UpdateOptionset
  2134. // @Description 修改字典
  2135. // @Param false "字典"
  2136. // @Success 200 {object} Account
  2137. // @Failure 403 :id is empty
  2138. func System_UpdateOptionset(c *entitys.CtrlContext) {
  2139. var paramObj0 models.SysOptionset
  2140. c.Ctx.BindJSON(&paramObj0)
  2141. user_id := c.Ctx.GetString("user_id")
  2142. paramObj0.LastUpdateBy = user_id
  2143. paramObj0.LastUpdateTime = time.Now().UnixNano()
  2144. paramMap, _ := sysutils.BeanToMap(&paramObj0)
  2145. _, err := c.Db.SqlMapClient("update_sys_optionset", paramMap).Execute()
  2146. if err == nil {
  2147. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2148. } else {
  2149. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2150. }
  2151. }
  2152. // _FindOptionsetPage
  2153. // @Title _FindOptionsetPage
  2154. // @Description 获取字典分页数
  2155. // @Success 200 {object} Account
  2156. // @Failure 403 :id is empty
  2157. func System_FindOptionsetPage(c *entitys.CtrlContext) {
  2158. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  2159. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  2160. name := c.Ctx.DefaultQuery("name", "")
  2161. code := c.Ctx.DefaultQuery("code", "")
  2162. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows, "name": name, "code": code}
  2163. result, err := sysutils.PageSearch(c.Db, "system", "find_optionset_page", "sys_optionset", paramMap_i_t)
  2164. if err == nil {
  2165. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  2166. } else {
  2167. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2168. }
  2169. }
  2170. // _GetOptionsetByCode
  2171. // @Title _GetOptionsetByCode
  2172. // @Description 根据编码查找字典
  2173. // @Param code string false "字典编码"
  2174. // @Success 200 {object} Account
  2175. // @Failure 403 :id is empty
  2176. func System_GetOptionsetByCode(c *entitys.CtrlContext) {
  2177. code := c.Ctx.Query("code")
  2178. var option sysmodel.SysOptionset
  2179. exit, err := c.Db.Table(new(sysmodel.SysOptionset)).Where("code = ?", code).Get(&option)
  2180. if exit && err == nil {
  2181. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", option})
  2182. } else {
  2183. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  2184. }
  2185. }
  2186. // _AddDataPermission
  2187. // @Title _AddDataPermission
  2188. // @Description 添加数据权限
  2189. // @Param string false "数据权限"
  2190. // @Success 200 {object} Account
  2191. // @Failure 403 :id is empty
  2192. func System_AddDataPermission(c *entitys.CtrlContext) {
  2193. var paramObj0 models.SysDataPermission
  2194. c.Ctx.BindJSON(&paramObj0)
  2195. ret := __none_func_system__(paramObj0)
  2196. if ret {
  2197. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2198. } else {
  2199. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  2200. }
  2201. }
  2202. // _DelDataPermission
  2203. // @Title _DelDataPermission
  2204. // @Description 删除数据权限
  2205. // @Param id string false "数据权限ID"
  2206. // @Success 200 {object} Account
  2207. // @Failure 403 :id is empty
  2208. func System_DelDataPermission(c *entitys.CtrlContext) {
  2209. id := c.Ctx.Query("id")
  2210. ret := __none_func_system__(id)
  2211. if ret {
  2212. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2213. } else {
  2214. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  2215. }
  2216. }
  2217. // _UpdateDataPermission
  2218. // @Title _UpdateDataPermission
  2219. // @Description 更新数据权限
  2220. // @Param string false "数据权限"
  2221. // @Success 200 {object} Account
  2222. // @Failure 403 :id is empty
  2223. func System_UpdateDataPermission(c *entitys.CtrlContext) {
  2224. var paramObj0 models.SysDataPermission
  2225. c.Ctx.BindJSON(&paramObj0)
  2226. ret := __none_func_system__(paramObj0)
  2227. if ret {
  2228. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", nil})
  2229. } else {
  2230. c.Ctx.JSON(500, sysmodel.SysReturn{500, "", nil})
  2231. }
  2232. }
  2233. // _FindDataPermissionPage
  2234. // @Title _FindDataPermissionPage
  2235. // @Description 分页获取数据权限
  2236. // @Success 200 {object} Account
  2237. // @Failure 403 :id is empty
  2238. func System_FindDataPermissionPage(c *entitys.CtrlContext) {
  2239. page, _ := strconv.Atoi(c.Ctx.DefaultQuery("page", "1"))
  2240. rows, _ := strconv.Atoi(c.Ctx.DefaultQuery("rows", "10"))
  2241. paramMap_i_t := map[string]interface{}{"page": page, "rows": rows}
  2242. result, err := sysutils.PageSearch(c.Db, "system", "find_data_permission_page", "data_permission", paramMap_i_t)
  2243. if err == nil {
  2244. c.Ctx.JSON(200, sysmodel.SysReturn{200, "", result})
  2245. } else {
  2246. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2247. }
  2248. }
  2249. // _ModifyPassword
  2250. // @Title _ModifyPassword
  2251. // @Description 修改密码
  2252. // @Param body models.ModifyPassword true ""
  2253. // @Success 200 {object} Account
  2254. // @Failure 403 :id is empty
  2255. func System_ModifyPassword(c *entitys.CtrlContext) {
  2256. var err error
  2257. var param models.ModifyPassword
  2258. if err = c.Ctx.BindJSON(&param); err != nil {
  2259. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2260. return
  2261. }
  2262. var errmsg string
  2263. switch {
  2264. case param.Origin == "":
  2265. errmsg = "原密码不能为空"
  2266. case param.New == "":
  2267. errmsg = "新密码不能为空"
  2268. case param.Confirm == "":
  2269. errmsg = "确认密码不能为空"
  2270. case param.Confirm != param.New:
  2271. errmsg = "两次密码不一致"
  2272. }
  2273. if errmsg != "" {
  2274. c.Ctx.JSON(500, sysmodel.SysReturn{500, errmsg, nil})
  2275. return
  2276. }
  2277. engine := c.PlatformDbEngine
  2278. var userId = c.Ctx.GetString("user_id")
  2279. if param.UserId == "" {
  2280. param.UserId = userId
  2281. }
  2282. var user sysmodel.SysUser
  2283. _, err = engine.ID(param.UserId).Get(&user)
  2284. if err != nil {
  2285. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2286. return
  2287. }
  2288. password := sysutils.HashPassword(param.Origin, "")
  2289. if !strings.EqualFold(password, user.Password) {
  2290. c.Ctx.JSON(500, sysmodel.SysReturn{500, "原密码错误", nil})
  2291. return
  2292. }
  2293. _, err = engine.Table(user).ID(user.Id).
  2294. Update(map[string]interface{}{
  2295. "password": sysutils.HashPassword(param.New, ""),
  2296. "last_update_by": userId,
  2297. "last_update_time": time.Now().UnixNano(),
  2298. })
  2299. if err == nil {
  2300. c.Ctx.JSON(200, sysmodel.SysReturn{200, "modify successfully", nil})
  2301. } else {
  2302. c.Ctx.JSON(500, sysmodel.SysReturn{500, err.Error(), nil})
  2303. }
  2304. }
  2305. func __none_func_system__(params ...interface{}) bool {
  2306. return true
  2307. }