user.go 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158
  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. // PotentialEdit
  772. // @Title 编辑潜在客户(转客户)
  773. // @Description 编辑潜在客户(转客户)
  774. // @Param request body request.UserEidtReq true "type json string"
  775. // @Success 200 {object} request.UserAddReq
  776. // @router /potential/edit [post]
  777. func (this *UserController) PotentialEdit() {
  778. br := new(models.BaseResponse).Init()
  779. defer func() {
  780. this.Data["json"] = br
  781. this.ServeJSON()
  782. }()
  783. var req request.UserEidtReq
  784. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  785. if err != nil {
  786. br.Msg = "参数解析异常!"
  787. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  788. return
  789. }
  790. if req.RealName == "" {
  791. br.Msg = "请输入姓名"
  792. return
  793. }
  794. req.Phone = strings.TrimSpace(req.Phone)
  795. req.Email = strings.TrimSpace(req.Email)
  796. if req.Phone == "" && req.Email == "" {
  797. br.Msg = "至少输入一个手机号或邮箱"
  798. return
  799. }
  800. if req.Phone != "" {
  801. if req.AreaCode == "86" {
  802. if !utils.ValidateMobileFormatat(req.Phone) {
  803. br.Msg = "手机号格式有误, 请检查"
  804. return
  805. }
  806. }
  807. user, err := models.GetUserByPhone(req.Phone, req.AreaCode)
  808. if err != nil && err != orm.ErrNoRows {
  809. br.Msg = "编辑用户失败"
  810. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  811. return
  812. }
  813. if user != nil && user.UserId != req.UserId {
  814. br.Msg = "手机号已存在,请重新输入"
  815. return
  816. }
  817. }
  818. if req.Email != "" {
  819. if !utils.ValidateEmailFormatat(req.Email) {
  820. br.Msg = "邮箱格式有误, 请检查"
  821. return
  822. }
  823. user, err := models.GetUserByEmail(req.Email)
  824. if err != nil && err != orm.ErrNoRows {
  825. br.Msg = "编辑用户失败"
  826. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  827. return
  828. }
  829. if user != nil && user.UserId != req.UserId {
  830. br.Msg = "邮箱已存在,请重新输入"
  831. return
  832. }
  833. }
  834. if req.SellerId <= 0 {
  835. br.Msg = "请选择营业部/销售"
  836. return
  837. }
  838. if req.ValidStartTime == "" || req.ValidEndTime == "" {
  839. br.Msg = "请选择合理的有效期范围"
  840. return
  841. }
  842. validStartTime, err := time.Parse(utils.FormatDate, req.ValidStartTime)
  843. if err != nil {
  844. br.Msg = "错误的日期格式"
  845. return
  846. }
  847. validStartTime = validStartTime.In(time.Local).Add(-time.Hour * 8)
  848. validEndTime, err := time.Parse(utils.FormatDate, req.ValidEndTime)
  849. if err != nil {
  850. br.Msg = "错误的日期格式"
  851. return
  852. }
  853. validEndTime = validEndTime.In(time.Local).Add(-time.Hour*8 + time.Hour*24)
  854. if !validStartTime.Before(validEndTime) {
  855. br.Msg = "请选择合理的有效期范围"
  856. return
  857. }
  858. if req.Company == "" {
  859. br.Msg = "请输入所属公司"
  860. return
  861. }
  862. if req.IsEnabled && time.Now().After(validEndTime) {
  863. br.Msg = "启用后,有效期必须大于当前时间"
  864. return
  865. }
  866. user, err := models.GetUserById(req.UserId)
  867. if err != nil {
  868. if err == orm.ErrNoRows {
  869. br.Msg = "用户不存在或已删除,请重新刷新页面"
  870. br.ErrMsg = "用户不存在或已删除,请重新刷新页面,Err:" + err.Error()
  871. return
  872. }
  873. br.Msg = "编辑用户失败"
  874. br.ErrMsg = "编辑用户失败, 系统错误,Err:" + err.Error()
  875. return
  876. }
  877. user.RealName = req.RealName
  878. user.AreaCode = req.AreaCode
  879. user.Phone = req.Phone
  880. user.Email = req.Email
  881. user.SellerId = req.SellerId
  882. user.ValidStartTime = validStartTime
  883. user.ValidEndTime = validEndTime
  884. user.Company = req.Company
  885. user.ModifyTime = time.Now()
  886. // 当用户状态初始为潜在客户时,才更新创建时间
  887. if user.Status == utils.UserStatusPotential {
  888. user.CreateTime = time.Now()
  889. }
  890. oldStatus := user.Status
  891. if !req.IsEnabled {
  892. user.Status = 0
  893. } else {
  894. user.Status = 2
  895. }
  896. err = models.SaveUser(user, req.ChartPermission)
  897. if err != nil {
  898. br.Msg = "添加客户失败"
  899. br.ErrMsg = "添加客户失败,系统错误,Err:" + err.Error()
  900. return
  901. }
  902. record := &models.UserChangeRecord{}
  903. record.UserId = req.UserId
  904. record.SysUserId = this.SysUser.SysUserId
  905. if oldStatus == utils.UserStatusPotential && user.Status == utils.UserStatusFormal {
  906. record.Content = this.SysUser.SysRealName + "新增用户"
  907. } else {
  908. record.Content = this.SysUser.SysRealName + "编辑用户"
  909. }
  910. record.Insert()
  911. br.Msg = "编辑成功"
  912. br.Success = true
  913. br.Ret = 200
  914. }
  915. // Detail
  916. // @Title 用户详情信息
  917. // @Description 用户详情信息
  918. // @Param UserId query int true "用户id"
  919. // @Success 200 {object} models.LoginResp
  920. // @router /detail [get]
  921. func (this *UserController) Detail() {
  922. br := new(models.BaseResponse).Init()
  923. defer func() {
  924. this.Data["json"] = br
  925. this.ServeJSON()
  926. }()
  927. UserId, _ := this.GetInt("UserId")
  928. if UserId <= 0 {
  929. br.Msg = "查询用户不存在"
  930. return
  931. }
  932. user, err := models.GetUserViewById(UserId)
  933. if err != nil {
  934. if err == orm.ErrNoRows {
  935. br.Msg = "用户不存在或已删除,请刷新页面"
  936. return
  937. }
  938. br.Msg = "查询用户失败"
  939. br.ErrMsg = "查询用户失败,系统错误,Err:" + err.Error()
  940. return
  941. }
  942. if user == nil {
  943. br.Msg = "用户不存在或已删除,请刷新页面"
  944. return
  945. }
  946. permissionList, err := services.GetUserPermissionById(UserId)
  947. if err != nil {
  948. br.Msg = "用户权限获取失败,请重新尝试"
  949. return
  950. }
  951. permissionMap := make(map[string][]string)
  952. for _, pm := range permissionList {
  953. permissionMap[pm.ParentName] = append(permissionMap[pm.ParentName], pm.PermissionName)
  954. }
  955. resp := new(response.UserDetailResp)
  956. resp.Detail = user
  957. resp.Permission = permissionMap
  958. br.Msg = "查询成功"
  959. br.Ret = 200
  960. br.Success = true
  961. br.Data = resp
  962. }
  963. // Delete
  964. // @Title 系统用户详情信息
  965. // @Description 用户详情信息
  966. // @Param request body request.UserDeleteReq true "type json string"
  967. // @Success 200 {object} models.LoginResp
  968. // @router /delete [post]
  969. func (this *UserController) Delete() {
  970. br := new(models.BaseResponse).Init()
  971. defer func() {
  972. this.Data["json"] = br
  973. this.ServeJSON()
  974. }()
  975. var req request.UserDeleteReq
  976. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  977. if err != nil {
  978. br.Msg = "参数解析异常!"
  979. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  980. return
  981. }
  982. err = models.DeleteUserById(req.UserId)
  983. if err != nil {
  984. br.Msg = "删除失败"
  985. br.ErrMsg = "删除失败,系统错误,Err:" + err.Error()
  986. return
  987. }
  988. br.Msg = "删除成功"
  989. br.Success = true
  990. br.Ret = 200
  991. }
  992. // @Title 开启/禁用用户
  993. // @Description 开启/禁用用户接口
  994. // @Param request body system.SysuserEditReq true "type json string"
  995. // @Success 200 操作成功
  996. // @router /editEnabled [post]
  997. func (this *UserController) EditEnabled() {
  998. br := new(models.BaseResponse).Init()
  999. defer func() {
  1000. this.Data["json"] = br
  1001. this.ServeJSON()
  1002. }()
  1003. var req request.UserEditEnabledReq
  1004. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1005. if err != nil {
  1006. br.Msg = "参数解析异常!"
  1007. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1008. return
  1009. }
  1010. user, err := models.GetUserById(req.UserId)
  1011. if err != nil {
  1012. br.Msg = "获取数据失败"
  1013. br.ErrMsg = "获取系统用户数据失败,Err:" + err.Error()
  1014. return
  1015. }
  1016. if !req.IsEnabled {
  1017. user.Status = 0
  1018. err = user.Update([]string{"status"})
  1019. if err != nil {
  1020. br.Msg = "修改失败"
  1021. br.ErrMsg = "修改系统用户数据失败,Err:" + err.Error()
  1022. return
  1023. }
  1024. } else {
  1025. validStartTime, err := time.Parse(utils.FormatDate, req.ValidStartTime)
  1026. if err != nil {
  1027. br.Msg = "日期格式不正确"
  1028. return
  1029. }
  1030. validEndTime, err := time.Parse(utils.FormatDate, req.ValidEndTime)
  1031. if err != nil {
  1032. br.Msg = "日期格式不正确"
  1033. return
  1034. }
  1035. if !validEndTime.After(validStartTime) {
  1036. br.Msg = "有效期结束日期在开始日期之前,日期格式不正确"
  1037. return
  1038. }
  1039. validStartTime = validStartTime.Local().Add(-time.Hour * 8)
  1040. validEndTime = validEndTime.Local().Add(-time.Hour*8 + time.Hour*24)
  1041. curTime := time.Now()
  1042. if curTime.After(validEndTime) {
  1043. br.Msg = "有效期已到期,请重新设置"
  1044. return
  1045. }
  1046. user.Status = 2
  1047. user.ModifyTime = curTime
  1048. user.ValidStartTime = validStartTime
  1049. user.ValidEndTime = validEndTime
  1050. err = user.Update([]string{"status", "modify_time", "valid_start_time", "valid_end_time"})
  1051. if err != nil {
  1052. br.Msg = "修改失败"
  1053. br.ErrMsg = "修改系统用户数据失败,Err:" + err.Error()
  1054. return
  1055. }
  1056. }
  1057. // 记录操作
  1058. record := &models.UserChangeRecord{}
  1059. record.UserId = req.UserId
  1060. record.SysUserId = this.SysUser.SysUserId
  1061. if user.Status == 0 {
  1062. record.Content = this.SysUser.SysRealName + "禁用用户"
  1063. } else {
  1064. record.Content = this.SysUser.SysRealName + "启用用户"
  1065. }
  1066. record.Insert()
  1067. br.Ret = 200
  1068. br.Success = true
  1069. br.Msg = "操作成功"
  1070. }
  1071. // @Title 用户信息变更记录
  1072. // @Description 用户信息变更记录
  1073. // @Param UserId query int true "用户id"
  1074. // @Success 200 操作成功
  1075. // @router /change_list [get]
  1076. func (this *UserController) ChangeList() {
  1077. br := new(models.BaseResponse).Init()
  1078. defer func() {
  1079. this.Data["json"] = br
  1080. this.ServeJSON()
  1081. }()
  1082. userId, _ := this.GetInt("UserId")
  1083. if userId <= 0 {
  1084. br.Msg = "用户信息错误"
  1085. return
  1086. }
  1087. userRcord, err := models.GetUserChangeRecordListById(userId)
  1088. if err != nil {
  1089. br.Msg = "用户信息变更查询失败"
  1090. br.ErrMsg = "用户信息变更查询失败,系统错误,Err:" + err.Error()
  1091. return
  1092. }
  1093. resp := new(response.UserChangeRecordResp)
  1094. resp.List = userRcord
  1095. br.Data = resp
  1096. br.Msg = "查询成功"
  1097. br.Success = true
  1098. br.Ret = 200
  1099. }