user.go 32 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012
  1. package front
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "github.com/dchest/captcha"
  6. "github.com/gorilla/sessions"
  7. "github.com/shopspring/decimal"
  8. "go.mongodb.org/mongo-driver/bson"
  9. "go.mongodb.org/mongo-driver/bson/primitive"
  10. mgo "mongodb"
  11. qu "qfw/util"
  12. "strconv"
  13. "strings"
  14. "sync"
  15. "time"
  16. . "util"
  17. )
  18. var store = sessions.NewCookieStore([]byte("jianyu_secret20210422"))
  19. func (f *Front) Login() {
  20. defer qu.Catch()
  21. if f.Method() == "POST" {
  22. username := f.GetString("username")
  23. password := f.GetString("pwd")
  24. imgCode := f.GetString("imgCode")
  25. passwordEn := qu.SE.EncodeString(password)
  26. qu.Debug(username, passwordEn, imgCode)
  27. //session, err := store.Get(f.Request, "dataTagLoginImgCode")
  28. //if err != nil {
  29. // qu.Debug("图片验证码session获取失败-%s \n", username)
  30. // f.ServeJson(map[string]interface{}{
  31. // "code": 0,
  32. // "status": false,
  33. // "message": "获取失败",
  34. // })
  35. // return
  36. //}
  37. //code := qu.ObjToString(session.Values["dataTagLoginImgCode"])
  38. //if code == "" {
  39. // qu.Debug("图片验证码过期-%s \n", username)
  40. // f.ServeJson(map[string]interface{}{
  41. // "checked": false,
  42. // "message": "图片验证码过期",
  43. // })
  44. // return
  45. //}
  46. //if !captcha.VerifyString(code, imgCode) {
  47. // qu.Debug("图片验证码错误-%s \n", username)
  48. // f.ServeJson(map[string]interface{}{
  49. // "checked": false,
  50. // "message": "图片验证码错误",
  51. // })
  52. // return
  53. //}
  54. query := map[string]interface{}{
  55. "s_login": username,
  56. "s_password": passwordEn,
  57. }
  58. user, _ := Mgo.FindOne("s_user", query)
  59. checked := false
  60. if user != nil && len(*user) > 0 {
  61. if (*user)["b_delete"] == true {
  62. f.ServeJson(map[string]interface{}{
  63. "checked": false,
  64. "message": "用户已被删除,请联系管理员",
  65. })
  66. return
  67. }
  68. if (*user)["i_state"] == false {
  69. f.ServeJson(map[string]interface{}{
  70. "checked": false,
  71. "message": "用户状态未启用,请联系管理员",
  72. })
  73. return
  74. }
  75. checked = true
  76. f.SetSession("user", map[string]interface{}{
  77. "s_groupid": (*user)["s_groupid"],
  78. "s_name": (*user)["s_name"],
  79. "i_role": (*user)["i_role"],
  80. "s_pwd": password,
  81. "s_login": username,
  82. "id": mgo.BsonIdToSId((*user)["_id"]),
  83. })
  84. UserMenu[username] = GetUserMenu(qu.IntAll((*user)["i_role"]))
  85. f.ServeJson(map[string]interface{}{
  86. "checked": checked,
  87. "role": (*user)["i_role"],
  88. })
  89. }
  90. f.ServeJson(map[string]interface{}{
  91. "checked": checked,
  92. "message": "账号或密码错误",
  93. })
  94. } else {
  95. _ = f.Render("login.html")
  96. }
  97. }
  98. // Code 获取图片验证码
  99. func (f *Front) Code() {
  100. id := captcha.NewLen(4)
  101. //r := &http.Request{}
  102. f.Request.Header.Add("Cache-Control", "no-cache, no-store, must-revalidate")
  103. f.Request.Header.Add("Pragma", "no-cache")
  104. f.Request.Header.Add("Expires", "0")
  105. f.Request.Header.Add("Content-Type", "image/png")
  106. w := f.ResponseWriter
  107. session, err := store.Get(f.Request, "dataTagLoginImgCode")
  108. if err != nil {
  109. qu.Debug("session1获取失败")
  110. return
  111. }
  112. session.Values["dataTagLoginImgCode"] = id
  113. session.Options.MaxAge = 60
  114. if err := session.Save(f.Request, w); err != nil {
  115. qu.Debug("session1保存错误,验证码 ", id)
  116. }
  117. err2 := captcha.WriteImage(w, id, 90, 30)
  118. if err2 != nil {
  119. qu.Debug("生成图片验证码错误,验证码 ", id)
  120. }
  121. return
  122. }
  123. func (f *Front) Logout() {
  124. f.DelSession("user")
  125. _ = f.Redirect("/")
  126. }
  127. func (f *Front) UserGroup() {
  128. defer qu.Catch()
  129. if f.Method() == "POST" {
  130. start, _ := f.GetInteger("start")
  131. limit, _ := f.GetInteger("length")
  132. draw, _ := f.GetInteger("draw")
  133. searchStr := f.GetString("search[value]")
  134. search := strings.TrimSpace(searchStr)
  135. status := f.GetString("s_status")
  136. query := map[string]interface{}{
  137. "b_delete": false,
  138. }
  139. if status == "1" {
  140. query["i_state"] = true
  141. } else if status == "-1" {
  142. query["i_state"] = false
  143. } else {
  144. delete(query, "i_state")
  145. }
  146. if search != "" {
  147. query["$or"] = []interface{}{
  148. bson.M{"s_name": bson.M{"$regex": search}},
  149. }
  150. }
  151. data, _ := Mgo.Find("s_group", query, `{"i_createtime":-1}`, nil, false, start, limit)
  152. count := Mgo.Count("s_group", query)
  153. f.ServeJson(map[string]interface{}{
  154. "draw": draw,
  155. "data": data,
  156. "recordsFiltered": count,
  157. "recordsTotal": count,
  158. })
  159. } else {
  160. _ = f.Render("user/user_group.html")
  161. }
  162. }
  163. func (f *Front) GroupNameExist() {
  164. name := f.GetString("s_name")
  165. info, _ := Mgo.FindOne("s_group", map[string]interface{}{"s_name": name})
  166. if len(*info) > 0 {
  167. f.ServeJson(map[string]interface{}{
  168. "rep": true,
  169. })
  170. }
  171. f.ServeJson(map[string]interface{}{
  172. "rep": false,
  173. })
  174. }
  175. func (f *Front) UserGroupNew() {
  176. defer qu.Catch()
  177. if f.Method() == "POST" {
  178. data := GetPostForm(f.Request)
  179. group := *qu.ObjToMap(data["group"])
  180. user := *qu.ObjToMap(data["user"])
  181. currenttime := time.Now().Unix()
  182. group["i_createtime"] = currenttime
  183. group["i_updatetime"] = currenttime
  184. group["b_delete"] = false
  185. group["i_state"] = true
  186. group["check_size"] = qu.IntAll(user["u1_size"])
  187. group["user_size"] = qu.IntAll(user["u2_size"])
  188. gid := Mgo.Save("s_group", group) // 保存用户组
  189. if gid != "" {
  190. // 1、用户组管理员账号
  191. m1 := make(map[string]interface{})
  192. m1["s_groupid"] = gid
  193. m1["s_name"] = ""
  194. m1["s_login"] = group["s_name"]
  195. if group["default_pwd"] == false {
  196. m1["s_password"] = qu.SE.EncodeString(qu.ObjToString(group["s_password"]))
  197. } else {
  198. m1["s_password"] = qu.SE.EncodeString(Password)
  199. }
  200. m1["i_role"] = group["i_role"]
  201. m1["s_phone"] = ""
  202. m1["i_createtime"] = currenttime
  203. m1["i_updatetime"] = currenttime
  204. m1["i_state"] = true
  205. m1["b_delete"] = false
  206. Mgo.Save("s_user", m1)
  207. // 2、质检员账号
  208. for i := 0; i < qu.IntAll(user["u1_size"]); i++ {
  209. m := make(map[string]interface{})
  210. m["s_groupid"] = gid
  211. m["s_name"] = ""
  212. m["s_login"] = qu.ObjToString(group["s_name"]) + "_zj_" + strconv.Itoa(i+1)
  213. if user["u1_default_pwd"] == false {
  214. m["s_password"] = qu.SE.EncodeString(qu.ObjToString(user["u1_pwd"]))
  215. } else {
  216. m["s_password"] = qu.SE.EncodeString(Password)
  217. }
  218. m["i_role"] = "3"
  219. m["s_phone"] = ""
  220. m["i_createtime"] = currenttime
  221. m["i_updatetime"] = currenttime
  222. m["i_state"] = true
  223. m["b_delete"] = false
  224. Mgo.Save("s_user", m)
  225. }
  226. // 3、普通用户账号
  227. for i := 0; i < qu.IntAll(user["u2_size"]); i++ {
  228. m := make(map[string]interface{})
  229. m["s_groupid"] = gid
  230. m["s_name"] = ""
  231. m["s_login"] = qu.ObjToString(group["s_name"]) + "_" + strconv.Itoa(i+1)
  232. if user["u2_default_pwd"] == false {
  233. m["s_password"] = qu.SE.EncodeString(qu.ObjToString(user["u2_pwd"]))
  234. } else {
  235. m["s_password"] = qu.SE.EncodeString(Password)
  236. }
  237. m["i_role"] = "4"
  238. m["s_phone"] = ""
  239. m["i_createtime"] = currenttime
  240. m["i_updatetime"] = currenttime
  241. m["i_state"] = true
  242. m["b_delete"] = false
  243. Mgo.Save("s_user", m)
  244. }
  245. f.ServeJson(map[string]interface{}{
  246. "rep": true,
  247. })
  248. } else {
  249. f.ServeJson(map[string]interface{}{
  250. "rep": false,
  251. })
  252. }
  253. } else {
  254. f.T["pwd"] = Password
  255. _ = f.Render("user/user_group_create.html", &f.T)
  256. }
  257. }
  258. func (f *Front) GroupModify() {
  259. defer qu.Catch()
  260. if f.Method() == "POST" {
  261. data := GetPostForm(f.Request)
  262. id := qu.ObjToString(data["id"])
  263. delete(data, "id")
  264. qu.Debug(data, id)
  265. data["i_updatetime"] = time.Now().Unix()
  266. b := Mgo.UpdateById("s_group", id, map[string]interface{}{"$set": data})
  267. f.ServeJson(map[string]interface{}{
  268. "rep": b,
  269. })
  270. }
  271. }
  272. func (f *Front) UserGroupState() {
  273. defer qu.Catch()
  274. if f.Method() == "POST" {
  275. data := GetPostForm(f.Request)
  276. b := Mgo.UpdateById("s_group", qu.ObjToString(data["id"]), map[string]interface{}{"$set": map[string]interface{}{"i_state": data["state"]}})
  277. b = Mgo.Update("s_user", map[string]interface{}{"s_groupid": qu.ObjToString(data["id"])}, map[string]interface{}{"$set": map[string]interface{}{"i_state": data["state"]}}, false, true)
  278. if !b {
  279. f.ServeJson(map[string]interface{}{
  280. "rep": b,
  281. })
  282. return
  283. }
  284. f.ServeJson(map[string]interface{}{
  285. "rep": b,
  286. })
  287. }
  288. }
  289. func (f *Front) UserGroupStateBulk() {
  290. defer qu.Catch()
  291. if f.Method() == "POST" {
  292. data := GetPostForm(f.Request)
  293. qu.Debug(data)
  294. ids := strings.Split(qu.ObjToString(data["ids"]), ",")
  295. for _, k := range ids {
  296. m := map[string]interface{}{"i_state": data["state"], "i_updatetime": time.Now().Unix()}
  297. b := Mgo.UpdateById("s_group", k, map[string]interface{}{"$set": m})
  298. if !b {
  299. f.ServeJson(map[string]interface{}{
  300. "rep": b,
  301. })
  302. return
  303. }
  304. b = Mgo.Update("s_user", map[string]interface{}{"s_groupid": k}, map[string]interface{}{"$set": m}, false, true)
  305. if !b {
  306. f.ServeJson(map[string]interface{}{
  307. "rep": b,
  308. })
  309. return
  310. }
  311. }
  312. f.ServeJson(map[string]interface{}{
  313. "rep": true,
  314. })
  315. }
  316. }
  317. func (f *Front) UserStateBulk() {
  318. defer qu.Catch()
  319. if f.Method() == "POST" {
  320. data := GetPostForm(f.Request)
  321. ids := strings.Split(qu.ObjToString(data["ids"]), ",")
  322. for _, k := range ids {
  323. m := map[string]interface{}{"i_state": data["state"], "i_updatetime": time.Now().Unix()}
  324. b := Mgo.UpdateById("s_user", k, map[string]interface{}{"$set": m})
  325. if !b {
  326. f.ServeJson(map[string]interface{}{
  327. "rep": b,
  328. })
  329. }
  330. }
  331. f.ServeJson(map[string]interface{}{
  332. "rep": true,
  333. })
  334. }
  335. }
  336. func (f *Front) UserGroupDel() {
  337. defer qu.Catch()
  338. if f.Method() == "POST" {
  339. data := GetPostForm(f.Request)
  340. qu.Debug(data)
  341. m := map[string]interface{}{"b_delete": true, "i_updatetime": time.Now().Unix()}
  342. b := Mgo.UpdateById("s_group", qu.ObjToString(data["id"]), map[string]interface{}{"$set": m})
  343. f.ServeJson(map[string]interface{}{
  344. "rep": b,
  345. })
  346. }
  347. }
  348. func (f *Front) UserManage() {
  349. defer qu.Catch()
  350. stype := f.GetString("stype")
  351. if f.Method() == "POST" {
  352. data := GetPostForm(f.Request)
  353. gid := qu.ObjToString(data["gid"])
  354. draw, _ := f.GetInteger("draw")
  355. query := map[string]interface{}{"s_groupid": gid, "b_delete": false}
  356. info, b := Mgo.Find("s_user", query, nil, nil, false, -1, -1)
  357. count := Mgo.Count("s_user", query)
  358. if b && len(*info) > 0 {
  359. f.ServeJson(map[string]interface{}{
  360. "rep": true,
  361. "data": *info,
  362. "draw": draw,
  363. "recordsFiltered": count,
  364. "recordsTotal": count,
  365. })
  366. } else {
  367. f.ServeJson(map[string]interface{}{
  368. "rep": false,
  369. })
  370. }
  371. } else {
  372. f.T["gid"] = f.GetString("id")
  373. f.T["stype"] = stype
  374. _ = f.Render("user/user_list.html", &f.T)
  375. }
  376. }
  377. func (f *Front) UserState() {
  378. defer qu.Catch()
  379. if f.Method() == "POST" {
  380. data := GetPostForm(f.Request)
  381. m := map[string]interface{}{"i_state": data["state"], "i_updatetime": time.Now().Unix()}
  382. b := Mgo.UpdateById("s_user", qu.ObjToString(data["id"]), map[string]interface{}{"$set": m})
  383. f.ServeJson(map[string]interface{}{
  384. "rep": b,
  385. })
  386. }
  387. }
  388. func (f *Front) UserAll() {
  389. defer qu.Catch()
  390. gid := f.GetString("gid")
  391. if f.Method() == "POST" {
  392. start, _ := f.GetInteger("start")
  393. limit, _ := f.GetInteger("length")
  394. draw, _ := f.GetInteger("draw")
  395. searchStr := f.GetString("search[value]")
  396. search := strings.TrimSpace(searchStr)
  397. query := map[string]interface{}{
  398. "b_delete": false,
  399. }
  400. user := f.GetSession("user").(map[string]interface{})
  401. if gid == "" {
  402. if user["i_role"] != "0" && user["i_role"] != "1" {
  403. query["s_groupid"] = qu.ObjToString(user["s_groupid"])
  404. }
  405. } else {
  406. query["s_groupid"] = gid
  407. }
  408. if search != "" {
  409. query["$or"] = []interface{}{
  410. bson.M{"s_login": bson.M{"$regex": search}},
  411. }
  412. }
  413. data, _ := Mgo.Find("s_user", query, `{"i_updatetime":-1}`, nil, false, start, limit)
  414. count := Mgo.Count("s_user", query)
  415. f.ServeJson(map[string]interface{}{
  416. "draw": draw,
  417. "data": data,
  418. "recordsFiltered": count,
  419. "recordsTotal": count,
  420. })
  421. } else {
  422. f.T["gid"] = gid
  423. _ = f.Render("user/user_list.html", &f.T)
  424. }
  425. }
  426. func (f *Front) UserDel() {
  427. defer qu.Catch()
  428. if f.Method() == "POST" {
  429. data := GetPostForm(f.Request)
  430. m := map[string]interface{}{"b_delete": true, "i_updatetime": time.Now().Unix()}
  431. b := Mgo.UpdateById("s_user", qu.ObjToString(data["id"]), map[string]interface{}{"$set": m})
  432. f.ServeJson(map[string]interface{}{
  433. "rep": b,
  434. })
  435. }
  436. }
  437. func (f *Front) UserModify() {
  438. defer qu.Catch()
  439. if f.Method() == "POST" {
  440. data := GetPostForm(f.Request)
  441. id := qu.ObjToString(data["id"])
  442. delete(data, "id")
  443. data["i_updatetime"] = time.Now().Unix()
  444. b := Mgo.UpdateById("s_user", id, map[string]interface{}{"$set": map[string]interface{}{"s_name": data["s_name"], "s_phone": data["s_phone"]}})
  445. f.ServeJson(map[string]interface{}{
  446. "rep": b,
  447. })
  448. }
  449. }
  450. func (f *Front) UserNew() {
  451. defer qu.Catch()
  452. if f.Method() == "POST" {
  453. user := f.GetSession("user").(map[string]interface{})
  454. //uRole := qu.ObjToString(user["i_role"])
  455. currenttime := time.Now().Unix()
  456. stype := f.GetString("stype")
  457. irole := f.GetString("i_role")
  458. if stype == "group" {
  459. size, e := f.GetInteger("size")
  460. if e != nil {
  461. f.ServeJson(map[string]interface{}{
  462. "rep": false,
  463. "msg": "新增保存数量出错",
  464. })
  465. return
  466. }
  467. gid := f.GetString("gid")
  468. info, _ := Mgo.FindById("s_group", gid, map[string]interface{}{"check_size": 1, "user_size": 1, "s_name": 1})
  469. if len(*info) > 0 {
  470. if irole == "3" {
  471. oldnum := qu.IntAll((*info)["check_size"])
  472. Mgo.UpdateById("s_group", gid, map[string]interface{}{"$set": map[string]interface{}{"check_size": oldnum + size}})
  473. for i := 0; i < size; i++ {
  474. newUser := make(map[string]interface{})
  475. newUser["i_role"] = irole
  476. newUser["s_name"] = ""
  477. newUser["s_phone"] = ""
  478. newUser["s_groupid"] = gid
  479. newUser["s_login"] = qu.ObjToString((*info)["s_name"]) + "_zj_" + strconv.Itoa(oldnum+i+1)
  480. newUser["s_password"] = qu.SE.EncodeString(Password)
  481. newUser["i_createtime"] = currenttime
  482. newUser["i_updatetime"] = currenttime
  483. newUser["i_state"] = true
  484. newUser["b_delete"] = false
  485. Mgo.Save("s_user", newUser)
  486. }
  487. } else if irole == "4" {
  488. oldnum := qu.IntAll((*info)["user_size"])
  489. Mgo.UpdateById("s_group", gid, map[string]interface{}{"$set": map[string]interface{}{"user_size": oldnum + size}})
  490. for i := 0; i < size; i++ {
  491. newUser := make(map[string]interface{})
  492. newUser["i_role"] = irole
  493. newUser["s_name"] = ""
  494. newUser["s_phone"] = ""
  495. newUser["s_groupid"] = gid
  496. newUser["s_login"] = qu.ObjToString((*info)["s_name"]) + "_" + strconv.Itoa(oldnum+i+1)
  497. newUser["s_password"] = qu.SE.EncodeString(Password)
  498. newUser["i_createtime"] = currenttime
  499. newUser["i_updatetime"] = currenttime
  500. newUser["i_state"] = true
  501. newUser["b_delete"] = false
  502. Mgo.Save("s_user", newUser)
  503. }
  504. }
  505. }
  506. f.ServeJson(map[string]interface{}{
  507. "rep": true,
  508. })
  509. } else {
  510. gid := qu.ObjToString(user["s_groupid"]) //登陆用户的组id
  511. if irole == "1" {
  512. // 添加jy管理人员账号
  513. login := f.GetString("login")
  514. pwd := f.GetString("pwd")
  515. newUser := make(map[string]interface{})
  516. newUser["i_role"] = irole
  517. newUser["s_name"] = f.GetString("name")
  518. newUser["s_phone"] = f.GetString("phone")
  519. newUser["s_groupid"] = gid
  520. newUser["s_login"] = login
  521. newUser["s_password"] = qu.SE.EncodeString(pwd)
  522. newUser["i_createtime"] = currenttime
  523. newUser["i_updatetime"] = currenttime
  524. newUser["i_state"] = true
  525. newUser["b_delete"] = false
  526. Mgo.Save("s_user", newUser)
  527. } else {
  528. size, e := f.GetInteger("size")
  529. if e != nil {
  530. f.ServeJson(map[string]interface{}{
  531. "rep": false,
  532. "msg": "新增保存数量出错",
  533. })
  534. return
  535. }
  536. info, _ := Mgo.FindById("s_group", gid, map[string]interface{}{"check_size": 1, "user_size": 1, "s_name": 1})
  537. if len(*info) > 0 {
  538. if irole == "3" {
  539. oldnum := qu.IntAll((*info)["check_size"])
  540. Mgo.UpdateById("s_group", gid, map[string]interface{}{"$set": map[string]interface{}{"check_size": oldnum + size}})
  541. for i := 0; i < size; i++ {
  542. newUser := make(map[string]interface{})
  543. newUser["i_role"] = irole
  544. newUser["s_name"] = ""
  545. newUser["s_phone"] = ""
  546. newUser["s_groupid"] = gid
  547. newUser["s_login"] = qu.ObjToString((*info)["s_name"]) + "_zj_" + strconv.Itoa(oldnum+i+1)
  548. newUser["s_password"] = qu.SE.EncodeString(Password)
  549. newUser["i_createtime"] = currenttime
  550. newUser["i_updatetime"] = currenttime
  551. newUser["i_state"] = true
  552. newUser["b_delete"] = false
  553. Mgo.Save("s_user", newUser)
  554. }
  555. } else if irole == "4" {
  556. oldnum := qu.IntAll((*info)["user_size"])
  557. Mgo.UpdateById("s_group", gid, map[string]interface{}{"$set": map[string]interface{}{"user_size": oldnum + size}})
  558. for i := 0; i < size; i++ {
  559. newUser := make(map[string]interface{})
  560. newUser["i_role"] = irole
  561. newUser["s_name"] = ""
  562. newUser["s_phone"] = ""
  563. newUser["s_groupid"] = gid
  564. newUser["s_login"] = qu.ObjToString((*info)["s_name"]) + "_" + strconv.Itoa(oldnum+i+1)
  565. newUser["s_password"] = qu.SE.EncodeString(Password)
  566. newUser["i_createtime"] = currenttime
  567. newUser["i_updatetime"] = currenttime
  568. newUser["i_state"] = true
  569. newUser["b_delete"] = false
  570. Mgo.Save("s_user", newUser)
  571. }
  572. }
  573. }
  574. }
  575. f.ServeJson(map[string]interface{}{
  576. "rep": true,
  577. })
  578. }
  579. f.ServeJson(map[string]interface{}{
  580. "rep": false,
  581. "msg": "添加账号信息失败",
  582. })
  583. }
  584. }
  585. func (f *Front) GroupList() {
  586. qu.Catch()
  587. query := map[string]interface{}{"b_delete": false, "i_state": true}
  588. field := map[string]interface{}{"s_name": 1, "s_personname": 1}
  589. info, b := Mgo.Find("s_group", query, nil, field, false, -1, -1)
  590. if b && len(*info) > 0 {
  591. f.ServeJson(map[string]interface{}{
  592. "rep": b,
  593. "data": *info,
  594. })
  595. }
  596. }
  597. func (f *Front) UserList() {
  598. qu.Catch()
  599. if f.Method() == "POST" {
  600. //user := f.GetSession("user").(map[string]interface{})
  601. //gid := qu.ObjToString(user["s_groupid"])
  602. gid := f.GetString("gid")
  603. query := map[string]interface{}{"s_groupid": gid, "b_delete": false, "i_state": true, "i_role": "4"}
  604. field := map[string]interface{}{"s_login": 1, "s_groupid": 1, "s_name": 1}
  605. info, b := Mgo.Find("s_user", query, `{"_id": 1}`, field, false, -1, -1)
  606. if b && len(*info) > 0 {
  607. f.ServeJson(map[string]interface{}{
  608. "rep": b,
  609. "data": *info,
  610. })
  611. }
  612. }
  613. }
  614. // UserTaskSave 用户任务分发
  615. func (f *Front) UserTaskSave() {
  616. defer qu.Catch()
  617. user := f.GetSession("user").(map[string]interface{})
  618. username := qu.ObjToString(user["s_login"])
  619. var taskArr []map[string]interface{}
  620. var userTaskIdArr []string
  621. userTaskIdInfo := map[string]Task{}
  622. success := false
  623. msg := ""
  624. groupTaskId := f.GetString("grouptaskid") //用户组任务id
  625. groupTask, _ := Mgo.FindById(TASKCOLLNAME, groupTaskId, nil)
  626. if len(*groupTask) == 0 {
  627. qu.Debug("GroupTask Find Error:", groupTaskId)
  628. msg = "用户组任务:" + groupTaskId + "查询失败"
  629. f.ServeJson(map[string]interface{}{"success": false, "msg": msg})
  630. return
  631. }
  632. sourceinfo := qu.ObjToString((*groupTask)["s_sourceinfo"])
  633. userNums := f.GetString("usernums")
  634. var userArr []map[string]interface{}
  635. if err := json.Unmarshal([]byte(userNums), &userArr); err != nil {
  636. qu.Debug("UserInfo Unmarshal Failed:", err)
  637. msg = "用户信息解析失败"
  638. } else {
  639. for _, userInfo := range userArr {
  640. userid := qu.ObjToString(userInfo["s_userid"])
  641. name := qu.ObjToString(userInfo["s_name"]) //可能为空
  642. login := qu.ObjToString(userInfo["s_login"])
  643. givenum := qu.IntAll(userInfo["i_givenum"])
  644. userTaskId := primitive.NewObjectID()
  645. userTaskIdStr := mgo.BsonIdToSId(userTaskId)
  646. userTaskIdArr = append(userTaskIdArr, userTaskIdStr)
  647. ut := Task{
  648. UserId: userid,
  649. GiveNum: givenum,
  650. UserName: login,
  651. }
  652. userTaskIdInfo[userTaskIdStr] = ut
  653. userTask := map[string]interface{}{
  654. "_id": userTaskId, //生成任务id
  655. "s_projectid": qu.ObjToString((*groupTask)["s_projectid"]), //项目标识
  656. "s_projectname": qu.ObjToString((*groupTask)["s_projectname"]), //项目名称
  657. "s_status": "未开始", //任务状态
  658. "s_personid": userid, //任务负责人标识
  659. "s_personname": name, //任务负责人
  660. "s_login": login, //用户账号
  661. "s_groupname": qu.ObjToString((*groupTask)["s_groupname"]), //用户组名称
  662. "s_groupid": qu.ObjToString((*groupTask)["s_groupid"]), //用户组标识
  663. "i_givenum": givenum, //分发数据量
  664. "s_createname": username, //创建人
  665. "i_createtime": time.Now().Unix(), //创建时间
  666. "s_progress": "0%", //完成进度
  667. "s_sourceinfo": sourceinfo, //源数据表
  668. "s_stype": "user", //任务类型
  669. "s_parentid": groupTaskId, //父任务及用户组任务id
  670. "s_entname": qu.ObjToString((*groupTask)["s_entname"]), //公司名称
  671. "s_departname": qu.ObjToString((*groupTask)["s_departname"]), //部门名称
  672. "s_rulename": qu.ObjToString((*groupTask)["s_rulename"]), //规则名称
  673. }
  674. taskArr = append(taskArr, userTask)
  675. }
  676. }
  677. if len(taskArr) > 0 {
  678. //分发数据后更新对应用户组任务信息
  679. success = Mgo.UpdateById(TASKCOLLNAME, groupTaskId, map[string]interface{}{
  680. "$push": map[string]interface{}{
  681. "v_sonids": map[string]interface{}{
  682. "$each": userTaskIdArr,
  683. },
  684. },
  685. })
  686. if !success {
  687. msg = "更新用户组任务:" + groupTaskId + "关联用户任务失败"
  688. } else { //用户分发任务
  689. success = Mgo.SaveBulk(TASKCOLLNAME, taskArr...)
  690. if success {
  691. //用户分发任务后更新该用户组任务的状态和开始时间
  692. Mgo.Update(TASKCOLLNAME,
  693. map[string]interface{}{
  694. "_id": mgo.StringTOBsonId(groupTaskId),
  695. "s_status": "未开始",
  696. },
  697. map[string]interface{}{
  698. "$set": map[string]interface{}{
  699. "s_status": "进行中",
  700. "i_starttime": time.Now().Unix(),
  701. }},
  702. false, false)
  703. msg = "任务分发成功"
  704. UpdateSourceInfoByUser(sourceinfo, groupTaskId, userTaskIdInfo) //用户分发任务成功后,同时更新任务数据源表
  705. }
  706. }
  707. }
  708. f.ServeJson(map[string]interface{}{"success": success, "msg": msg})
  709. }
  710. // UserTaskList 用户任务列表
  711. func (f *Front) UserTaskList() {
  712. defer qu.Catch()
  713. user := f.GetSession("user").(map[string]interface{})
  714. s_role := qu.ObjToString(user["i_role"])
  715. s_personid := qu.ObjToString(user["id"])
  716. gid := qu.ObjToString(user["s_groupid"])
  717. if f.Method() == "POST" {
  718. start, _ := f.GetInteger("start")
  719. limit, _ := f.GetInteger("length")
  720. draw, _ := f.GetInteger("draw")
  721. status := f.GetString("s_status")
  722. searchStr := f.GetString("search[value]")
  723. search := strings.TrimSpace(searchStr)
  724. query := map[string]interface{}{
  725. "s_stype": "user",
  726. }
  727. if s_role == "4" {
  728. query["s_personid"] = s_personid
  729. } else if s_role == "2" || s_role == "1" {
  730. query["s_groupid"] = gid
  731. }
  732. if status != "-1" { //任务状态
  733. query["s_status"] = status
  734. }
  735. if search != "" {
  736. query["$or"] = []interface{}{
  737. map[string]interface{}{"s_projectname": map[string]interface{}{"$regex": search}},
  738. }
  739. }
  740. count := Mgo.Count(TASKCOLLNAME, query)
  741. qu.Debug("Query:", query, count)
  742. list, _ := Mgo.Find(TASKCOLLNAME, query, map[string]interface{}{"_id": -1}, nil, false, start, limit)
  743. for _, l := range *list {
  744. if status := qu.ObjToString(l["s_status"]); status == "进行中" { //更新任务进度
  745. giveNum := qu.IntAll(l["i_givenum"])
  746. sourceinfo := qu.ObjToString(l["s_sourceinfo"])
  747. tagNum := Mgo.Count(sourceinfo, map[string]interface{}{"s_usertaskid": mgo.BsonIdToSId(l["_id"]), "b_istag": true})
  748. progressFloat := float64(tagNum) / float64(giveNum)
  749. value, _ := strconv.ParseFloat(fmt.Sprintf("%.4f", progressFloat), 64)
  750. decimalValue := decimal.NewFromFloat(value)
  751. decimalValue = decimalValue.Mul(decimal.NewFromInt(100))
  752. value, _ = decimalValue.Float64()
  753. progress := fmt.Sprint(value) + "%"
  754. l["s_progress"] = progress
  755. //同步数据库
  756. Mgo.UpdateById(TASKCOLLNAME, l["_id"], map[string]interface{}{"$set": map[string]interface{}{"s_progress": progress}})
  757. }
  758. }
  759. f.ServeJson(map[string]interface{}{"draw": draw, "data": *list, "recordsFiltered": count, "recordsTotal": count})
  760. } else {
  761. _ = f.Render("project/task_user_list.html", &f.T)
  762. }
  763. }
  764. // UserTaskRetrieve 用户任务收回
  765. func (f *Front) UserTaskRetrieve() {
  766. defer qu.Catch()
  767. user := f.GetSession("user").(map[string]interface{})
  768. username := qu.ObjToString(user["s_login"])
  769. userTaskId := f.GetString("taskid") //用户任务id
  770. qu.Debug("User Task Id:", userTaskId)
  771. sourceInfo := f.GetString("s_sourceinfo") //数据源表
  772. //status := f.GetString("s_status")
  773. task, _ := Mgo.FindById(TASKCOLLNAME, userTaskId, map[string]interface{}{"s_status": 1})
  774. if len(*task) <= 0 {
  775. f.ServeJson(map[string]interface{}{"success": false, "msg": "查询任务失败"})
  776. return
  777. }
  778. status := qu.ObjToString((*task)["s_status"])
  779. userTaskIdStatus := map[string]string{userTaskId: status}
  780. msg, count, success := RetrieveCloseTaskByUser(sourceInfo, username, userTaskIdStatus)
  781. //userTask, _ := Mgo.FindById(TASKCOLLNAME, userTaskId, nil)
  782. f.ServeJson(map[string]interface{}{"success": success, "count": count, "msg": msg})
  783. }
  784. // UserTaskDeliver 标注完成交付任务
  785. func (f *Front) UserTaskDeliver() {
  786. defer qu.Catch()
  787. success := false
  788. msg := ""
  789. user := f.GetSession("user").(map[string]interface{})
  790. username := qu.ObjToString(user["s_login"])
  791. userTaskId := f.GetString("taskid") //用户任务id
  792. sourceInfo := f.GetString("s_sourceinfo") //数据源表
  793. count := Mgo.Count(sourceInfo, map[string]interface{}{"s_usertaskid": userTaskId, "b_istag": false}) //查询是否含有未标注数据
  794. qu.Debug("User Task Id:", userTaskId, count)
  795. if count == 0 { //标注完成更新任务状态
  796. set := map[string]interface{}{
  797. "s_status": "已完成", //收回、关闭时默认任务状态已完成
  798. "i_updatetime": time.Now().Unix(),
  799. "s_updateperson": username,
  800. "i_completetime": time.Now().Unix(),
  801. }
  802. success = Mgo.UpdateById(TASKCOLLNAME, userTaskId, map[string]interface{}{"$set": set})
  803. if !success {
  804. msg = "更新任务信息失败"
  805. }
  806. } else {
  807. msg = "数据未标注完成"
  808. }
  809. f.ServeJson(map[string]interface{}{"success": success, "msg": msg})
  810. }
  811. // UserTaskClose 用户任务打回
  812. func (f *Front) UserTaskClose() {
  813. defer qu.Catch()
  814. user := f.GetSession("user").(map[string]interface{})
  815. username := qu.ObjToString(user["s_login"])
  816. taskid := f.GetString("taskid") //用户任务id
  817. qu.Debug("User Task Id:", taskid)
  818. sourceInfo := f.GetString("s_sourceinfo") //数据源表
  819. currenttime := time.Now().Unix()
  820. //更新数据源
  821. success := Mgo.Update(sourceInfo, map[string]interface{}{"s_usertaskid": taskid}, map[string]interface{}{
  822. "$set": map[string]interface{}{
  823. "b_istag": false,
  824. "b_check": false,
  825. "i_ckdata": 0,
  826. "i_updatetime": currenttime,
  827. },
  828. "$unset": map[string]interface{}{
  829. "v_taginfo": "",
  830. "v_checkinfo": "",
  831. },
  832. }, false, true)
  833. // 修改任务
  834. if success {
  835. Mgo.UpdateById(TASKCOLLNAME, taskid, map[string]interface{}{
  836. "$set": map[string]interface{}{
  837. "s_status": "未开始",
  838. "s_updateperson": username,
  839. "i_updatetime": currenttime,
  840. "s_progress": "0%",
  841. },
  842. "$unset": map[string]interface{}{
  843. "i_completetime": "",
  844. },
  845. })
  846. } else {
  847. f.ServeJson(map[string]interface{}{"success": false, "msg": "操作失败"})
  848. return
  849. }
  850. f.ServeJson(map[string]interface{}{"success": success})
  851. }
  852. // UpdateSourceInfoByUser 用户分发任务成功后更新数据源表
  853. func UpdateSourceInfoByUser(sourceinfo, groupTaskId string, userTaskIdInfo map[string]Task) {
  854. defer qu.Catch()
  855. for userTaskId, tInfo := range userTaskIdInfo {
  856. userId := tInfo.UserId
  857. num := tInfo.GiveNum
  858. userName := tInfo.UserName
  859. sess := Mgo.GetMgoConn()
  860. defer Mgo.DestoryMongoConn(sess)
  861. ch := make(chan bool, 5)
  862. wg := &sync.WaitGroup{}
  863. lock := &sync.Mutex{}
  864. query := map[string]interface{}{
  865. "s_grouptaskid": groupTaskId,
  866. "b_isgiveuser": false,
  867. }
  868. updateArr := [][]map[string]interface{}{}
  869. qu.Debug("Query:", query)
  870. it := sess.DB(Mgo.DbName).C(sourceinfo).Find(&query).Limit(int64(num)).Iter()
  871. n := 0
  872. for tmp := make(map[string]interface{}); it.Next(tmp); n++ {
  873. ch <- true
  874. wg.Add(1)
  875. go func(tmp map[string]interface{}) {
  876. defer func() {
  877. <-ch
  878. wg.Done()
  879. }()
  880. update := []map[string]interface{}{}
  881. update = append(update, map[string]interface{}{"_id": tmp["_id"]})
  882. update = append(update, map[string]interface{}{
  883. "$set": map[string]interface{}{
  884. "s_usertaskid": userTaskId,
  885. "s_userid": userId,
  886. "s_login": userName,
  887. "b_isgiveuser": true,
  888. "i_updatetime": time.Now().Unix(),
  889. },
  890. })
  891. lock.Lock()
  892. updateArr = append(updateArr, update)
  893. if len(updateArr) > 500 {
  894. Mgo.UpdateBulk(sourceinfo, updateArr...)
  895. updateArr = [][]map[string]interface{}{}
  896. }
  897. lock.Unlock()
  898. }(tmp)
  899. if n%100 == 0 {
  900. qu.Debug("current:", n)
  901. }
  902. tmp = map[string]interface{}{}
  903. }
  904. wg.Wait()
  905. lock.Lock()
  906. if len(updateArr) > 0 {
  907. Mgo.UpdateBulk(sourceinfo, updateArr...)
  908. updateArr = [][]map[string]interface{}{}
  909. }
  910. lock.Unlock()
  911. }
  912. }
  913. // RetrieveCloseTaskByUser 用户收回任务、关闭,更新数据源
  914. func RetrieveCloseTaskByUser(sourceInfo, username string, userTaskIdStatus map[string]string) (allMsg string, allCount int, allSuccess bool) {
  915. defer qu.Catch()
  916. allSuccess = true
  917. for taskId, userTaskStatus := range userTaskIdStatus {
  918. /*
  919. 收回时userTaskStatus:未开始、进行中
  920. 关闭时userTaskStatus:未开始
  921. */
  922. qu.Debug(taskId, userTaskStatus)
  923. //用户任务要更新的信息
  924. taskSet := map[string]interface{}{
  925. "s_status": "已完成", //收回、关闭时默认任务状态已完成
  926. "i_updatetime": time.Now().Unix(),
  927. "s_updateperson": username,
  928. "s_progress": "100%",
  929. "i_completetime": time.Now().Unix(),
  930. }
  931. if userTaskStatus == "未开始" { //未开始的任务手动添加开始时间
  932. taskSet["i_starttime"] = time.Now().Unix()
  933. taskSet["s_status"] = "已关闭"
  934. }
  935. query := map[string]interface{}{
  936. "s_usertaskid": taskId,
  937. "b_istag": false,
  938. }
  939. count := Mgo.Count(sourceInfo, query)
  940. qu.Debug("Find Task Id:", taskId, " Retrieve Count:", count)
  941. if count > 0 { //更新数据源信息
  942. set := map[string]interface{}{
  943. "i_updatetime": time.Now().Unix(),
  944. "b_isgiveuser": false,
  945. }
  946. unset := map[string]interface{}{
  947. "s_usertaskid": "",
  948. "s_userid": "",
  949. "s_login": "",
  950. }
  951. success := Mgo.Update(sourceInfo, query, map[string]interface{}{"$set": set, "$unset": unset}, false, true)
  952. qu.Debug("Update SourceInfo:", success)
  953. if success {
  954. allCount += count
  955. //收回成功,更新task信息
  956. success = Mgo.UpdateById(TASKCOLLNAME, taskId, map[string]interface{}{
  957. "$set": taskSet,
  958. "$inc": map[string]interface{}{ //更新数据量
  959. "i_givenum": -count,
  960. },
  961. })
  962. if !success {
  963. allMsg += "任务ID:" + taskId + "更新数据失败;"
  964. allSuccess = false
  965. }
  966. qu.Debug("Update:", taskId, success)
  967. } else {
  968. allMsg += "任务ID:" + taskId + "更新数据源失败;"
  969. allSuccess = false
  970. }
  971. } else { //没有要收回的数据,只更新任务信息
  972. success := Mgo.UpdateById(TASKCOLLNAME, taskId, map[string]interface{}{
  973. "$set": taskSet,
  974. })
  975. if !success {
  976. allMsg += "任务ID:" + taskId + "更新数据失败;"
  977. allSuccess = false
  978. }
  979. qu.Debug("Update:", taskId, success)
  980. }
  981. }
  982. return
  983. }