user.go 27 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "eta/eta_mini_crm/models"
  5. "eta/eta_mini_crm/models/request"
  6. "eta/eta_mini_crm/models/response"
  7. "eta/eta_mini_crm/services"
  8. "eta/eta_mini_crm/utils"
  9. "math"
  10. "strings"
  11. "time"
  12. "github.com/beego/beego/v2/client/orm"
  13. "github.com/rdlucklib/rdluck_tools/paging"
  14. )
  15. type UserController struct {
  16. BaseAuthController
  17. }
  18. // Add
  19. // @Title 添加新客户
  20. // @Description 添加新客户
  21. // @Param request body request.UserAddReq true "type json string"
  22. // @Success 200 {object} request.UserAddReq
  23. // @router /add [post]
  24. func (this *UserController) Add() {
  25. br := new(models.BaseResponse).Init()
  26. defer func() {
  27. this.Data["json"] = br
  28. this.ServeJSON()
  29. }()
  30. var req request.UserAddReq
  31. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  32. if err != nil {
  33. br.Msg = "参数解析异常!"
  34. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  35. return
  36. }
  37. if req.RealName == "" {
  38. br.Msg = "请输入姓名"
  39. return
  40. }
  41. req.Phone = strings.TrimSpace(req.Phone)
  42. req.Email = strings.TrimSpace(req.Email)
  43. if req.Phone == "" && req.Email == "" {
  44. br.Msg = "至少输入一个手机号或邮箱"
  45. return
  46. }
  47. var userByPhone, userByEmail *models.User
  48. if req.Phone != "" {
  49. if req.AreaCode == "86" {
  50. if !utils.ValidateMobileFormatat(req.Phone) {
  51. br.Msg = "手机号格式有误, 请检查"
  52. return
  53. }
  54. }
  55. userByPhone, err = models.GetUserByPhone(req.Phone, req.AreaCode)
  56. if err != nil && err != orm.ErrNoRows {
  57. br.Msg = "添加用户失败"
  58. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  59. return
  60. }
  61. if userByPhone != nil {
  62. switch userByPhone.Status {
  63. case 0:
  64. userByPhone.Status = 2
  65. case 1:
  66. userByPhone.Status = 2
  67. default:
  68. br.Msg = "手机号已存在,请重新输入"
  69. return
  70. }
  71. }
  72. }
  73. if req.Email != "" {
  74. if !utils.ValidateEmailFormatat(req.Email) {
  75. br.Msg = "邮箱格式有误, 请检查"
  76. return
  77. }
  78. userByEmail, err = models.GetUserByEmail(req.Email)
  79. if err != nil && err != orm.ErrNoRows {
  80. br.Msg = "添加用户失败"
  81. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  82. return
  83. }
  84. if userByEmail != nil {
  85. switch userByEmail.Status {
  86. case 0:
  87. userByEmail.Status = 2
  88. case 1:
  89. userByEmail.Status = 2
  90. default:
  91. br.Msg = "邮箱已存在,请重新输入"
  92. return
  93. }
  94. }
  95. }
  96. if req.SellerId <= 0 {
  97. br.Msg = "请选择营业部/销售"
  98. return
  99. }
  100. if req.ValidStartTime == "" || req.ValidEndTime == "" {
  101. br.Msg = "请选择合理的有效期范围"
  102. return
  103. }
  104. validStartTime, err := time.Parse(utils.FormatDate, req.ValidStartTime)
  105. if err != nil {
  106. br.Msg = "错误的日期格式"
  107. return
  108. }
  109. validEndTime, err := time.Parse(utils.FormatDate, req.ValidEndTime)
  110. if err != nil {
  111. br.Msg = "错误的日期格式"
  112. return
  113. }
  114. if !validStartTime.Before(validEndTime) {
  115. br.Msg = "请选择合理的有效期范围"
  116. return
  117. }
  118. if req.Company == "" {
  119. br.Msg = "请输入所属公司"
  120. return
  121. }
  122. if userByPhone != nil && userByEmail != nil && userByPhone.UserId != userByEmail.UserId {
  123. br.Msg = "邮箱已存在,请重新输入"
  124. return
  125. }
  126. user := &models.User{}
  127. curTime := time.Now()
  128. if userByPhone == nil && userByEmail == nil {
  129. user.CreateTime = curTime
  130. user.ModifyTime = curTime
  131. }
  132. if userByEmail != nil {
  133. user = userByEmail
  134. }
  135. if userByPhone != nil {
  136. user = userByPhone
  137. }
  138. validStartTime = validStartTime.Local().Add(-time.Hour * 8)
  139. validEndTime = validEndTime.Local().Add(-time.Hour*8 + time.Hour*24)
  140. if curTime.Before(validEndTime) {
  141. user.Status = 2
  142. } else {
  143. user.Status = 0
  144. }
  145. user.RealName = req.RealName
  146. user.AreaCode = req.AreaCode
  147. user.Phone = req.Phone
  148. user.Email = req.Email
  149. user.SellerId = req.SellerId
  150. user.ValidStartTime = validStartTime
  151. user.ValidEndTime = validEndTime
  152. user.Company = req.Company
  153. user.ModifyTime = curTime
  154. err = models.SaveUser(user, req.ChartPermission)
  155. if err != nil {
  156. br.Msg = "添加客户失败"
  157. br.ErrMsg = "添加客户失败,系统错误,Err:" + err.Error()
  158. return
  159. }
  160. if user.Status == 2 {
  161. userRecord := &models.UserChangeRecord{}
  162. userRecord.UserId = user.UserId
  163. userRecord.SysUserId = this.SysUser.SysUserId
  164. userRecord.Content = this.SysUser.SysRealName + "新增用户"
  165. userRecord.Insert()
  166. }
  167. br.Msg = "添加成功"
  168. br.Success = true
  169. br.Ret = 200
  170. }
  171. // edit
  172. // @Title 编辑客户
  173. // @Description 编辑客户
  174. // @Param request body request.UserEidtReq true "type json string"
  175. // @Success 200 {object} request.UserAddReq
  176. // @router /edit [post]
  177. func (this *UserController) Edit() {
  178. br := new(models.BaseResponse).Init()
  179. defer func() {
  180. this.Data["json"] = br
  181. this.ServeJSON()
  182. }()
  183. var req request.UserEidtReq
  184. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  185. if err != nil {
  186. br.Msg = "参数解析异常!"
  187. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  188. return
  189. }
  190. if req.RealName == "" {
  191. br.Msg = "请输入姓名"
  192. return
  193. }
  194. req.Phone = strings.TrimSpace(req.Phone)
  195. req.Email = strings.TrimSpace(req.Email)
  196. if req.Phone == "" && req.Email == "" {
  197. br.Msg = "至少输入一个手机号或邮箱"
  198. return
  199. }
  200. if req.Phone != "" {
  201. if req.AreaCode == "86" {
  202. if !utils.ValidateMobileFormatat(req.Phone) {
  203. br.Msg = "手机号格式有误, 请检查"
  204. return
  205. }
  206. }
  207. user, err := models.GetUserByPhone(req.Phone, req.AreaCode)
  208. if err != nil && err != orm.ErrNoRows {
  209. br.Msg = "编辑用户失败"
  210. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  211. return
  212. }
  213. if user != nil && user.UserId != req.UserId {
  214. br.Msg = "手机号已存在,请重新输入"
  215. return
  216. }
  217. }
  218. if req.Email != "" {
  219. if !utils.ValidateEmailFormatat(req.Email) {
  220. br.Msg = "邮箱格式有误, 请检查"
  221. return
  222. }
  223. user, err := models.GetUserByEmail(req.Email)
  224. if err != nil && err != orm.ErrNoRows {
  225. br.Msg = "编辑用户失败"
  226. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  227. return
  228. }
  229. if user != nil && user.UserId != req.UserId {
  230. br.Msg = "邮箱已存在,请重新输入"
  231. return
  232. }
  233. }
  234. if req.SellerId <= 0 {
  235. br.Msg = "请选择营业部/销售"
  236. return
  237. }
  238. if req.ValidStartTime == "" || req.ValidEndTime == "" {
  239. br.Msg = "请选择合理的有效期范围"
  240. return
  241. }
  242. validStartTime, err := time.Parse(utils.FormatDate, req.ValidStartTime)
  243. if err != nil {
  244. br.Msg = "错误的日期格式"
  245. return
  246. }
  247. validStartTime = validStartTime.In(time.Local).Add(-time.Hour * 8)
  248. validEndTime, err := time.Parse(utils.FormatDate, req.ValidEndTime)
  249. if err != nil {
  250. br.Msg = "错误的日期格式"
  251. return
  252. }
  253. validEndTime = validEndTime.In(time.Local).Add(-time.Hour*8 + time.Hour*24)
  254. if !validStartTime.Before(validEndTime) {
  255. br.Msg = "请选择合理的有效期范围"
  256. return
  257. }
  258. if req.Company == "" {
  259. br.Msg = "请输入所属公司"
  260. return
  261. }
  262. if req.IsEnabled && time.Now().After(validEndTime) {
  263. br.Msg = "启用后,有效期必须大于当前时间"
  264. return
  265. }
  266. user, err := models.GetUserById(req.UserId)
  267. if err != nil {
  268. if err == orm.ErrNoRows {
  269. br.Msg = "用户不存在或已删除,请重新刷新页面"
  270. br.ErrMsg = "用户不存在或已删除,请重新刷新页面,Err:" + err.Error()
  271. return
  272. }
  273. br.Msg = "编辑用户失败"
  274. br.ErrMsg = "编辑用户失败, 系统错误,Err:" + err.Error()
  275. return
  276. }
  277. user.RealName = req.RealName
  278. user.AreaCode = req.AreaCode
  279. user.Phone = req.Phone
  280. user.Email = req.Email
  281. user.SellerId = req.SellerId
  282. user.ValidStartTime = validStartTime
  283. user.ValidEndTime = validEndTime
  284. user.Company = req.Company
  285. user.ModifyTime = time.Now()
  286. // 当用户状态初始为潜在客户时,才更新创建时间
  287. if user.Status == utils.UserStatusPotential {
  288. user.CreateTime = time.Now()
  289. }
  290. oldStatus := user.Status
  291. if !req.IsEnabled {
  292. user.Status = 0
  293. } else {
  294. user.Status = 2
  295. }
  296. err = models.SaveUser(user, req.ChartPermission)
  297. if err != nil {
  298. br.Msg = "添加客户失败"
  299. br.ErrMsg = "添加客户失败,系统错误,Err:" + err.Error()
  300. return
  301. }
  302. record := &models.UserChangeRecord{}
  303. record.UserId = req.UserId
  304. record.SysUserId = this.SysUser.SysUserId
  305. if oldStatus == utils.UserStatusPotential && user.Status == utils.UserStatusFormal {
  306. record.Content = this.SysUser.SysRealName + "新增用户"
  307. } else {
  308. record.Content = this.SysUser.SysRealName + "编辑用户"
  309. }
  310. record.Insert()
  311. br.Msg = "编辑成功"
  312. br.Success = true
  313. br.Ret = 200
  314. }
  315. // Check
  316. // @Title 编辑客户
  317. // @Description 编辑客户
  318. // @Param request body request.UserEidtReq true "type json string"
  319. // @Success 200 {object} request.UserAddReq
  320. // @router /check [post]
  321. func (this *UserController) Check() {
  322. br := new(models.BaseResponse).Init()
  323. defer func() {
  324. this.Data["json"] = br
  325. this.ServeJSON()
  326. }()
  327. var req request.UserCheckReq
  328. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  329. if err != nil {
  330. br.Msg = "参数解析异常!"
  331. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  332. return
  333. }
  334. req.Phone = strings.TrimSpace(req.Phone)
  335. req.Email = strings.TrimSpace(req.Email)
  336. if req.Phone == "" && req.Email == "" {
  337. br.Msg = "至少输入一个手机号或邮箱"
  338. return
  339. }
  340. userCheckResp := new(response.UserCheckResp)
  341. if req.Phone != "" {
  342. if req.AreaCode == "86" {
  343. if !utils.ValidateMobileFormatat(req.Phone) {
  344. br.Msg = "手机号格式有误, 请检查"
  345. return
  346. }
  347. }
  348. user, err := models.GetUserByPhone(req.Phone, req.AreaCode)
  349. if err != nil && err != orm.ErrNoRows {
  350. br.Msg = "编辑用户失败"
  351. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  352. return
  353. }
  354. if user != nil {
  355. userCheckResp.UserId = user.UserId
  356. userCheckResp.Status = user.Status
  357. if user.Status == utils.UserStatusNo {
  358. br.Ret = 200
  359. br.Success = true
  360. br.Msg = "该用户已被禁用,确认启用并更新用户信息吗?"
  361. br.Data = userCheckResp
  362. return
  363. }
  364. if user.Status == utils.UserStatusPotential {
  365. br.Ret = 200
  366. br.Success = true
  367. br.Msg = "该用户已在潜在列表,确认转客户并更新用户信息吗?"
  368. br.Data = userCheckResp
  369. return
  370. }
  371. if user.Status == utils.UserStatusFormal {
  372. br.Msg = "手机号已存在,请重新输入"
  373. return
  374. }
  375. }
  376. }
  377. if req.Email != "" {
  378. if !utils.ValidateEmailFormatat(req.Email) {
  379. br.Msg = "邮箱格式有误, 请检查"
  380. return
  381. }
  382. user, err := models.GetUserByEmail(req.Email)
  383. if err != nil && err != orm.ErrNoRows {
  384. br.Msg = "编辑用户失败"
  385. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  386. return
  387. }
  388. if user != nil {
  389. userCheckResp.UserId = user.UserId
  390. if user.Status == 0 {
  391. br.Ret = 200
  392. br.Success = true
  393. br.Msg = "该用户已被禁用,确认启用并更新用户信息吗?"
  394. br.Data = userCheckResp
  395. return
  396. }
  397. if user.Status == 1 {
  398. br.Ret = 200
  399. br.Success = true
  400. br.Msg = "该用户已被禁用,确认启用并更新用户信息吗?"
  401. br.Data = userCheckResp
  402. return
  403. }
  404. if user.Status == 2 {
  405. br.Msg = "邮箱已存在,请重新输入"
  406. return
  407. }
  408. return
  409. }
  410. }
  411. br.Ret = 200
  412. br.Success = true
  413. br.Msg = "邮箱或手机号合格"
  414. }
  415. // List
  416. // @Title 用户列表
  417. // @Description 用户列表
  418. // @Param PageSize query int true "每页数据条数"
  419. // @Param CurrentIndex query int true "当前页页码,从1开始"
  420. // @Param SellerId query string true "销售id"
  421. // @Param Status query int true "用户状态"
  422. // @Param KeyWord query string true "手机号/邮箱/姓名"
  423. // @Param IsRegistered query string true "是否注册"
  424. // @Param IsSubscribed query string true "是否关注"
  425. // @Param RegisterStartDate query string true "注册开始时间"
  426. // @Param RegisterEndDate query string true "注册结束时间"
  427. // @Param CreateStartDate query string true "创建开始时间"
  428. // @Param CreateEndDate query string true "创建结束时间"
  429. // @Param SortParam query string true "排序字段"
  430. // @Param SortType query string true "排序方式"
  431. // @Success 200 {object} response.UserListResp
  432. // @router /list [get]
  433. func (this *UserController) List() {
  434. br := new(models.BaseResponse).Init()
  435. defer func() {
  436. this.Data["json"] = br
  437. this.ServeJSON()
  438. }()
  439. pageSize, _ := this.GetInt("PageSize")
  440. currentIndex, _ := this.GetInt("CurrentIndex")
  441. sellerIdStr := this.GetString("SellerId")
  442. status := this.GetString("Status")
  443. keyWord := this.GetString("KeyWord")
  444. IsRegistered := this.GetString("IsRegistered")
  445. IsSubscribed := this.GetString("IsSubscribed")
  446. registerStartDate := this.GetString("RegisterStartDate")
  447. registerEndDate := this.GetString("RegisterEndDate")
  448. createStartDate := this.GetString("CreateStartDate")
  449. createEndDate := this.GetString("CreateEndDate")
  450. sortParma := this.GetString("SortParam")
  451. sortType := this.GetString("SortType")
  452. var condition string
  453. var sortCondition string
  454. var pars []interface{}
  455. if keyWord != "" {
  456. condition += ` AND (u.real_name LIKE ? OR u.phone LIKE ? OR u.email LIKE ?) `
  457. pars = utils.GetLikeKeywordPars(pars, keyWord, 3)
  458. }
  459. if pageSize <= 0 {
  460. pageSize = utils.PageSize20
  461. } else if pageSize > utils.PageSize100 {
  462. pageSize = utils.PageSize100
  463. }
  464. if currentIndex <= 0 {
  465. currentIndex = 1
  466. }
  467. if sortParma != "" && sortType != "" {
  468. sortCondition = " ORDER BY "
  469. var param, sort string
  470. switch sortParma {
  471. case "RegisterTime":
  472. param = "u.register_time"
  473. case "CreateTime":
  474. param = "u.create_time"
  475. case "RestDate":
  476. param = "u.valid_end_time"
  477. }
  478. switch sortType {
  479. case "asc":
  480. sort = " ASC "
  481. case "desc":
  482. sort = " DESC "
  483. }
  484. if param != "" && sort != "" {
  485. sortCondition += param + " " + sort
  486. } else {
  487. sortCondition = ""
  488. }
  489. }
  490. if sortCondition == "" {
  491. sortCondition = " ORDER BY u.valid_end_time ASC"
  492. }
  493. if sellerIdStr != "" {
  494. sellerIds := strings.Split(sellerIdStr, ",")
  495. if len(sellerIds) != 0 {
  496. condition += ` AND ( `
  497. for i, id := range sellerIds {
  498. if i == 0 {
  499. condition += ` u.seller_id = ? `
  500. pars = append(pars, id)
  501. } else {
  502. condition += ` OR u.seller_id = ? `
  503. pars = append(pars, id)
  504. }
  505. }
  506. condition += `) `
  507. }
  508. }
  509. switch status {
  510. case "禁用":
  511. condition += " AND u.status=? "
  512. pars = append(pars, 0)
  513. case "潜在":
  514. condition += " AND u.status=? "
  515. pars = append(pars, 1)
  516. case "正式":
  517. condition += " AND u.status=? "
  518. pars = append(pars, 2)
  519. case "":
  520. condition += " AND (u.status=? OR u.status=?) "
  521. pars = append(pars, 0, 2)
  522. }
  523. switch IsRegistered {
  524. case "是":
  525. condition += " AND u.is_registered=? "
  526. pars = append(pars, true)
  527. case "否":
  528. condition += " AND u.is_registered=? "
  529. pars = append(pars, false)
  530. }
  531. switch IsSubscribed {
  532. case "是":
  533. condition += " AND u.is_subscribed=? "
  534. pars = append(pars, true)
  535. case "否":
  536. condition += " AND u.is_subscribed=? "
  537. pars = append(pars, false)
  538. }
  539. if registerStartDate != "" {
  540. registerStartTime, er := time.Parse(utils.FormatDate, registerStartDate)
  541. if er != nil {
  542. br.Msg = "日期格式有误"
  543. return
  544. }
  545. condition += " AND u.register_time>? "
  546. pars = append(pars, registerStartTime)
  547. }
  548. if registerEndDate != "" {
  549. registerEndTime, er := time.Parse(utils.FormatDate, registerEndDate)
  550. if er != nil {
  551. br.Msg = "日期格式有误"
  552. return
  553. }
  554. condition += " AND u.register_time<? "
  555. pars = append(pars, registerEndTime)
  556. }
  557. if createStartDate != "" {
  558. createStartTime, er := time.Parse(utils.FormatDate, createStartDate)
  559. if er != nil {
  560. br.Msg = "日期格式有误"
  561. return
  562. }
  563. condition += " AND u.create_time>? "
  564. pars = append(pars, createStartTime)
  565. }
  566. if createEndDate != "" {
  567. createEndTime, er := time.Parse(utils.FormatDate, createEndDate)
  568. if er != nil {
  569. br.Msg = "日期格式有误"
  570. return
  571. }
  572. condition += " AND u.create_time<? "
  573. pars = append(pars, createEndTime)
  574. }
  575. if pageSize <= 0 {
  576. pageSize = utils.PageSize20
  577. } else if pageSize > utils.PageSize100 {
  578. pageSize = utils.PageSize100
  579. }
  580. if currentIndex <= 0 {
  581. currentIndex = 1
  582. }
  583. startSize := utils.StartIndex(currentIndex, pageSize)
  584. total, err := models.GetUserCount(condition, pars)
  585. if err != nil {
  586. br.Msg = "获取失败"
  587. br.ErrMsg = "获取失败,Err:" + err.Error()
  588. return
  589. }
  590. userList, err := models.GetUserListByConditonSort(condition, sortCondition, pars, startSize, pageSize)
  591. if err != nil {
  592. br.Msg = "查询用户失败"
  593. br.Msg = "查询用户失败,系统错误,Err:" + err.Error()
  594. return
  595. }
  596. for _, u := range userList {
  597. if u.ValidEndTime == "" {
  598. u.RestDate = 0
  599. } else {
  600. endTime, err := time.Parse(utils.FormatDateTime, u.ValidEndTime)
  601. if err != nil {
  602. br.Msg = "用户有效时间格式有误"
  603. br.ErrMsg = "用户有效时间格式有误,Err:" + err.Error()
  604. return
  605. }
  606. // 对天数向上取整
  607. daysBetween := int(math.Ceil(time.Until(endTime).Hours() / 24))
  608. if daysBetween < 0 {
  609. daysBetween = 0
  610. }
  611. u.RestDate = daysBetween
  612. }
  613. }
  614. page := paging.GetPaging(currentIndex, pageSize, total)
  615. resp := new(response.UserListResp)
  616. resp.Paging = page
  617. resp.List = userList
  618. br.Data = resp
  619. br.Ret = 200
  620. br.Success = true
  621. br.Msg = "获取成功"
  622. }
  623. // PotentialList
  624. // @Title 潜在用户列表
  625. // @Description 潜在用户列表
  626. // @Param PageSize query int true "每页数据条数"
  627. // @Param CurrentIndex query int true "当前页页码,从1开始"
  628. // @Param KeyWord query string true "手机号/邮箱"
  629. // @Param RegisterStartDate query string true "注册开始时间"
  630. // @Param RegisterEndDate query string true "注册结束时间"
  631. // @Param LastUpdateStartDate query string true "最后一次阅读开始时间"
  632. // @Param LastUpdateEndDate query string true "最后一次阅读结束时间"
  633. // @Param SortParam query string true "排序字段"
  634. // @Param SortType query string true "排序方式"
  635. // @Success 200 {object} response.UserListResp
  636. // @router /potential/list [get]
  637. func (this *UserController) PotentialList() {
  638. br := new(models.BaseResponse).Init()
  639. defer func() {
  640. this.Data["json"] = br
  641. this.ServeJSON()
  642. }()
  643. pageSize, _ := this.GetInt("PageSize")
  644. currentIndex, _ := this.GetInt("CurrentIndex")
  645. keyWord := this.GetString("KeyWord")
  646. registerStartDate := this.GetString("RegisterStartDate")
  647. registerEndDate := this.GetString("RegisterEndDate")
  648. lastUpdateStartDate := this.GetString("LastUpdateStartDate")
  649. lastUpdateEndDate := this.GetString("LastUpdateEndDate")
  650. sortParma := this.GetString("SortParam")
  651. sortType := this.GetString("SortType")
  652. var sortCondition string
  653. var condition string
  654. var pars []interface{}
  655. if keyWord != "" {
  656. condition += ` AND ( u.phone LIKE ? OR u.email LIKE ?) `
  657. pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
  658. }
  659. if pageSize <= 0 {
  660. pageSize = utils.PageSize20
  661. } else if pageSize > utils.PageSize100 {
  662. pageSize = utils.PageSize100
  663. }
  664. if currentIndex <= 0 {
  665. currentIndex = 1
  666. }
  667. if sortParma != "" && sortType != "" {
  668. sortCondition = " ORDER BY "
  669. var param, sort string
  670. switch sortParma {
  671. case "RegisterTime":
  672. param = "u.register_time"
  673. case "LastUpdateTime":
  674. param = "last_update_time"
  675. case "ReadCnt":
  676. param = "read_cnt"
  677. }
  678. switch sortType {
  679. case "asc":
  680. sort = " ASC "
  681. case "desc":
  682. sort = " DESC "
  683. }
  684. if param != "" && sort != "" {
  685. sortCondition += param + " " + sort
  686. } else {
  687. sortCondition = ""
  688. }
  689. }
  690. if registerStartDate != "" {
  691. registerStartTime, er := time.Parse(utils.FormatDate, registerStartDate)
  692. if er != nil {
  693. br.Msg = "日期格式有误"
  694. return
  695. }
  696. condition += " AND u.register_time>? "
  697. pars = append(pars, registerStartTime)
  698. }
  699. if registerEndDate != "" {
  700. registerEndTime, er := time.Parse(utils.FormatDate, registerEndDate)
  701. if er != nil {
  702. br.Msg = "日期格式有误"
  703. return
  704. }
  705. condition += " AND u.register_time<? "
  706. pars = append(pars, registerEndTime)
  707. }
  708. if lastUpdateStartDate != "" {
  709. lastUpdateStartTime, er := time.Parse(utils.FormatDate, lastUpdateStartDate)
  710. if er != nil {
  711. br.Msg = "日期格式有误"
  712. return
  713. }
  714. condition += " AND ur.create_time>? "
  715. pars = append(pars, lastUpdateStartTime)
  716. }
  717. if lastUpdateEndDate != "" {
  718. lastUpdateEndTime, er := time.Parse(utils.FormatDate, lastUpdateEndDate)
  719. if er != nil {
  720. br.Msg = "日期格式有误"
  721. return
  722. }
  723. condition += " AND ur.create_time<? "
  724. pars = append(pars, lastUpdateEndTime)
  725. }
  726. if pageSize <= 0 {
  727. pageSize = utils.PageSize20
  728. } else if pageSize > utils.PageSize100 {
  729. pageSize = utils.PageSize100
  730. }
  731. if currentIndex <= 0 {
  732. currentIndex = 1
  733. }
  734. startSize := utils.StartIndex(currentIndex, pageSize)
  735. total, err := models.GetPotentialUserCountByConditon(condition, pars)
  736. if err != nil {
  737. br.Msg = "获取失败"
  738. br.ErrMsg = "获取失败,Err:" + err.Error()
  739. return
  740. }
  741. resp := new(response.UserListResp)
  742. if total == 0 {
  743. page := paging.GetPaging(currentIndex, pageSize, total)
  744. resp.Paging = page
  745. br.Msg = "获取成功"
  746. br.Ret = 200
  747. br.Success = true
  748. br.Data = resp
  749. return
  750. }
  751. userIds, err := models.GetPotentialUserIdsByConditon(condition, pars)
  752. if err != nil {
  753. br.Msg = "查询用户失败"
  754. br.Msg = "查询用户失败,系统错误,Err:" + err.Error()
  755. return
  756. }
  757. userList, err := models.GetPotentialUserListByConditonSort(userIds, sortCondition, startSize, pageSize)
  758. if err != nil {
  759. br.Msg = "查询用户失败"
  760. br.Msg = "查询用户失败,系统错误,Err:" + err.Error()
  761. return
  762. }
  763. page := paging.GetPaging(currentIndex, pageSize, total)
  764. resp.Paging = page
  765. resp.List = userList
  766. br.Data = resp
  767. br.Ret = 200
  768. br.Success = true
  769. br.Msg = "获取成功"
  770. }
  771. // Detail
  772. // @Title 用户详情信息
  773. // @Description 用户详情信息
  774. // @Param UserId query int true "用户id"
  775. // @Success 200 {object} models.LoginResp
  776. // @router /detail [get]
  777. func (this *UserController) Detail() {
  778. br := new(models.BaseResponse).Init()
  779. defer func() {
  780. this.Data["json"] = br
  781. this.ServeJSON()
  782. }()
  783. UserId, _ := this.GetInt("UserId")
  784. if UserId <= 0 {
  785. br.Msg = "查询用户不存在"
  786. return
  787. }
  788. user, err := models.GetUserViewById(UserId)
  789. if err != nil {
  790. if err == orm.ErrNoRows {
  791. br.Msg = "用户不存在或已删除,请刷新页面"
  792. return
  793. }
  794. br.Msg = "查询用户失败"
  795. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  796. return
  797. }
  798. if user == nil {
  799. br.Msg = "用户不存在或已删除,请刷新页面"
  800. return
  801. }
  802. permissionList, err := services.GetUserPermissionById(UserId)
  803. if err != nil {
  804. br.Msg = "用户权限获取失败,请重新尝试"
  805. return
  806. }
  807. permissionMap := make(map[string][]string)
  808. for _, pm := range permissionList {
  809. permissionMap[pm.ParentName] = append(permissionMap[pm.ParentName], pm.PermissionName)
  810. }
  811. resp := new(response.UserDetailResp)
  812. resp.Detail = user
  813. resp.Permission = permissionMap
  814. br.Msg = "查询成功"
  815. br.Ret = 200
  816. br.Success = true
  817. br.Data = resp
  818. }
  819. // Delete
  820. // @Title 系统用户详情信息
  821. // @Description 用户详情信息
  822. // @Param request body request.UserDeleteReq true "type json string"
  823. // @Success 200 {object} models.LoginResp
  824. // @router /delete [post]
  825. func (this *UserController) Delete() {
  826. br := new(models.BaseResponse).Init()
  827. defer func() {
  828. this.Data["json"] = br
  829. this.ServeJSON()
  830. }()
  831. var req request.UserDeleteReq
  832. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  833. if err != nil {
  834. br.Msg = "参数解析异常!"
  835. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  836. return
  837. }
  838. err = models.DeleteUserById(req.UserId)
  839. if err != nil {
  840. br.Msg = "删除失败"
  841. br.ErrMsg = "删除失败,系统错误,Err:" + err.Error()
  842. return
  843. }
  844. br.Msg = "删除成功"
  845. br.Success = true
  846. br.Ret = 200
  847. }
  848. // @Title 开启/禁用用户
  849. // @Description 开启/禁用用户接口
  850. // @Param request body system.SysuserEditReq true "type json string"
  851. // @Success 200 操作成功
  852. // @router /editEnabled [post]
  853. func (this *UserController) EditEnabled() {
  854. br := new(models.BaseResponse).Init()
  855. defer func() {
  856. this.Data["json"] = br
  857. this.ServeJSON()
  858. }()
  859. var req request.UserEditEnabledReq
  860. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  861. if err != nil {
  862. br.Msg = "参数解析异常!"
  863. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  864. return
  865. }
  866. user, err := models.GetUserById(req.UserId)
  867. if err != nil {
  868. br.Msg = "获取数据失败"
  869. br.ErrMsg = "获取系统用户数据失败,Err:" + err.Error()
  870. return
  871. }
  872. if !req.IsEnabled {
  873. user.Status = 0
  874. err = user.Update([]string{"status"})
  875. if err != nil {
  876. br.Msg = "修改失败"
  877. br.ErrMsg = "修改系统用户数据失败,Err:" + err.Error()
  878. return
  879. }
  880. } else {
  881. validStartTime, err := time.Parse(utils.FormatDate, req.ValidStartTime)
  882. if err != nil {
  883. br.Msg = "日期格式不正确"
  884. return
  885. }
  886. validEndTime, err := time.Parse(utils.FormatDate, req.ValidEndTime)
  887. if err != nil {
  888. br.Msg = "日期格式不正确"
  889. return
  890. }
  891. if !validEndTime.After(validStartTime) {
  892. br.Msg = "有效期结束日期在开始日期之前,日期格式不正确"
  893. return
  894. }
  895. validStartTime = validStartTime.Local().Add(-time.Hour * 8)
  896. validEndTime = validEndTime.Local().Add(-time.Hour*8 + time.Hour*24)
  897. curTime := time.Now()
  898. if curTime.After(validEndTime) {
  899. br.Msg = "有效期已到期,请重新设置"
  900. return
  901. }
  902. user.Status = 2
  903. user.ModifyTime = curTime
  904. user.ValidStartTime = validStartTime
  905. user.ValidEndTime = validEndTime
  906. err = user.Update([]string{"status", "modify_time", "valid_start_time", "valid_end_time"})
  907. if err != nil {
  908. br.Msg = "修改失败"
  909. br.ErrMsg = "修改系统用户数据失败,Err:" + err.Error()
  910. return
  911. }
  912. }
  913. // 记录操作
  914. record := &models.UserChangeRecord{}
  915. record.UserId = req.UserId
  916. record.SysUserId = this.SysUser.SysUserId
  917. if user.Status == 0 {
  918. record.Content = this.SysUser.SysRealName + "禁用用户"
  919. } else {
  920. record.Content = this.SysUser.SysRealName + "启用用户"
  921. }
  922. record.Insert()
  923. br.Ret = 200
  924. br.Success = true
  925. br.Msg = "操作成功"
  926. }
  927. // @Title 用户信息变更记录
  928. // @Description 用户信息变更记录
  929. // @Param UserId query int true "用户id"
  930. // @Success 200 操作成功
  931. // @router /change_list [get]
  932. func (this *UserController) ChangeList() {
  933. br := new(models.BaseResponse).Init()
  934. defer func() {
  935. this.Data["json"] = br
  936. this.ServeJSON()
  937. }()
  938. userId, _ := this.GetInt("UserId")
  939. if userId <= 0 {
  940. br.Msg = "用户信息错误"
  941. return
  942. }
  943. userRcord, err := models.GetUserChangeRecordListById(userId)
  944. if err != nil {
  945. br.Msg = "用户信息变更查询失败"
  946. br.ErrMsg = "用户信息变更查询失败,系统错误,Err:" + err.Error()
  947. return
  948. }
  949. resp := new(response.UserChangeRecordResp)
  950. resp.List = userRcord
  951. br.Data = resp
  952. br.Msg = "查询成功"
  953. br.Success = true
  954. br.Ret = 200
  955. }