company_share.go 34 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "github.com/rdlucklib/rdluck_tools/paging"
  6. "hongze/hz_crm_api/models"
  7. "hongze/hz_crm_api/models/company"
  8. "hongze/hz_crm_api/models/system"
  9. "hongze/hz_crm_api/services"
  10. "hongze/hz_crm_api/utils"
  11. "strconv"
  12. "strings"
  13. "time"
  14. )
  15. // @Title 设置共享客户
  16. // @Description 设置共享客户接口
  17. // @Param request body company.CompanyShareReq true "type json string"
  18. // @Success Ret=200 设置成功
  19. // @router /share [post]
  20. func (this *CompanyController) CompanyShare() {
  21. br := new(models.BaseResponse).Init()
  22. defer func() {
  23. this.Data["json"] = br
  24. this.ServeJSON()
  25. }()
  26. sysUser := this.SysUser
  27. if sysUser == nil {
  28. br.Msg = "请登录"
  29. br.ErrMsg = "请登录,SysUser Is Empty"
  30. br.Ret = 408
  31. return
  32. }
  33. var req company.CompanyShareReq
  34. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  35. if err != nil {
  36. br.Msg = "参数解析异常!"
  37. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  38. return
  39. }
  40. if req.CompanyId <= 0 {
  41. br.Msg = "参数异常!"
  42. br.ErrMsg = "CompanyId:" + strconv.Itoa(req.CompanyId)
  43. return
  44. }
  45. if req.IsShare < 0 {
  46. br.Msg = "参数异常!"
  47. br.ErrMsg = "IsShare:" + strconv.Itoa(req.IsShare)
  48. return
  49. }
  50. //查询该客户
  51. companyItem, err := company.GetCompanyById(req.CompanyId)
  52. if err != nil {
  53. br.Msg = "查找客户失败"
  54. br.ErrMsg = "查找客户失败,Err:" + err.Error()
  55. return
  56. }
  57. //待更新字段
  58. updateCol := make([]string, 0)
  59. companyItem.IsShare = req.IsShare
  60. updateCol = append(updateCol, "IsShare")
  61. if req.IsShare == 0 {
  62. companyItem.ShareSeller = ""
  63. companyItem.ShareSellerId = 0
  64. updateCol = append(updateCol, "ShareSeller", "ShareSellerId")
  65. }
  66. err = companyItem.Update(updateCol)
  67. if err != nil {
  68. br.Msg = "修改客户信息失败"
  69. br.ErrMsg = "修改客户信息失败,Err:" + err.Error()
  70. return
  71. }
  72. //新增操作记录
  73. //{
  74. // remark := "移动到:" + seller.RealName
  75. // operation := "move_seller"
  76. // services.AddCompanyOperationRecord(req.CompanyId, seller.AdminId, sysUser.AdminId, productId, sysUser.AdminId, cp.CompanyName,
  77. // cp.ProductName, sysUser.RealName, remark, operation, "", sysUser.RealName, "", cp.Status)
  78. //}
  79. br.Ret = 200
  80. br.Success = true
  81. br.Msg = "设置成功"
  82. }
  83. // CompanyShareList
  84. // @Title 共享客户列表
  85. // @Description 共享客户列表接口
  86. // @Param SellerId query string false "选择的销售id"
  87. // @Param OriginalSellerId query string false "选择的原销售id"
  88. // @Param Keyword query string true "搜索关键词"
  89. // @Param ListParam query int false "筛选字段参数,用来筛选的字段, 枚举值:0:全部 、 1:已分配 、 2:未分配 、 3:未共享 "
  90. // @Param SortParam query string false "排序字段参数,用来排序的字段, 枚举值:'viewTotal':总阅读次数 、 'viewTime':阅读时间 、 'roadShowTotal':累计路演次数 、`expireDay:到期时间` 、 `createTime:创建时间` 、 'formalTime': 转正时间 、 'freezeTime':冻结时间 、'lossTime':流失时间 、'tryOutDay':试用天数"
  91. // @Param SortType query string true "如何排序,是正序还是倒序,枚举值:`asc 正序`,`desc 倒叙`"
  92. // @Param PageSize query int true "每页数据条数"
  93. // @Param CurrentIndex query int true "当前页页码,从1开始"
  94. // @Success Ret=200 设置成功
  95. // @router /share/list [get]
  96. func (this *CompanyController) CompanyShareList() {
  97. br := new(models.BaseResponse).Init()
  98. defer func() {
  99. this.Data["json"] = br
  100. this.ServeJSON()
  101. }()
  102. sysUser := this.SysUser
  103. if sysUser == nil {
  104. br.Msg = "请登录"
  105. br.ErrMsg = "请登录,SysUser Is Empty"
  106. br.Ret = 408
  107. return
  108. }
  109. pageSize, _ := this.GetInt("PageSize")
  110. currentIndex, _ := this.GetInt("CurrentIndex")
  111. sellerIds := this.GetString("SellerId")
  112. originalSellerIds := this.GetString("OriginalSellerId")
  113. keyword := this.GetString("Keyword")
  114. //排序参数
  115. sortParam := this.GetString("SortParam")
  116. listParam, _ := this.GetInt("ListParam")
  117. sortType := this.GetString("SortType")
  118. var total int
  119. page := paging.GetPaging(currentIndex, pageSize, total)
  120. var startSize int
  121. if pageSize <= 0 {
  122. pageSize = utils.PageSize20
  123. }
  124. if currentIndex <= 0 {
  125. currentIndex = 1
  126. }
  127. startSize = paging.StartIndex(currentIndex, pageSize)
  128. var condition string
  129. var pars []interface{}
  130. if keyword != "" {
  131. companyIdStr, err := company.GetCompanyIdByKeyWord(keyword)
  132. if err != nil {
  133. br.Msg = "获取客户信息失败"
  134. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  135. return
  136. }
  137. if companyIdStr != "" {
  138. condition += ` AND (a.company_name LIKE '%` + keyword + `%' OR a.credit_code LIKE '%` + keyword + `%' OR a.company_id IN(` + companyIdStr + `)) `
  139. } else {
  140. condition += ` AND (a.company_name LIKE '%` + keyword + `%' OR a.credit_code LIKE '%` + keyword + `%' ) `
  141. }
  142. }
  143. // 咨询组的分组id
  144. groupId := 0
  145. if utils.RunMode == "release" {
  146. groupId = 37
  147. } else {
  148. groupId = 61
  149. }
  150. roleTypeCode := sysUser.RoleTypeCode
  151. productId := services.GetProductId(roleTypeCode)
  152. //权限控制
  153. {
  154. //如果不是超级管理员或者财务
  155. if roleTypeCode != utils.ROLE_TYPE_CODE_ADMIN && roleTypeCode != utils.ROLE_TYPE_CODE_FINANCE {
  156. //如果是部门管理员
  157. if roleTypeCode == utils.ROLE_TYPE_CODE_FICC_ADMIN || roleTypeCode == utils.ROLE_TYPE_CODE_RAI_ADMIN {
  158. condition += ` AND b.product_id=? `
  159. pars = append(pars, productId)
  160. } else {
  161. condition += ` AND b.product_id=? `
  162. pars = append(pars, productId)
  163. }
  164. if sysUser.Authority == 2 && roleTypeCode == utils.ROLE_TYPE_CODE_FICC_GROUP {
  165. groupIdStr, err := services.GetFiccChildGroupIdsByGroupIds(sysUser.GroupId)
  166. if err != nil {
  167. br.Msg = "获取销售分组信息失败!"
  168. br.ErrMsg = "获取销售分组信息失败!Err:" + err.Error()
  169. return
  170. }
  171. if groupIdStr != "" {
  172. condition += ` AND b.group_id IN (` + groupIdStr + `) `
  173. }
  174. } else if sysUser.Authority == 4 || roleTypeCode == utils.ROLE_TYPE_CODE_RAI_GROUP {
  175. condition += ` AND b.group_id=? `
  176. pars = append(pars, sysUser.GroupId)
  177. } else if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN && sysUser.AdminId != 66 && sysUser.AdminId != 15 && roleTypeCode != utils.ROLE_TYPE_CODE_FICC_ADMIN && roleTypeCode != utils.ROLE_TYPE_CODE_RAI_ADMIN {
  178. if sysUser.GroupId == groupId {
  179. condition += ` AND a.share_seller_id=? `
  180. pars = append(pars, sysUser.AdminId)
  181. } else {
  182. condition += ` AND b.seller_id=? `
  183. pars = append(pars, sysUser.AdminId)
  184. }
  185. }
  186. }
  187. }
  188. if listParam == 0 {
  189. if sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_SELLER || sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_GROUP || sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_TEAM {
  190. //非咨询组销售,那么默认查看“未共享”的客户
  191. if sysUser.GroupId != groupId {
  192. listParam = 3
  193. if sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_SELLER {
  194. condition += ` AND b.seller_id = ? `
  195. pars = append(pars, sysUser.AdminId)
  196. }
  197. } else {
  198. condition += ` AND a.is_share=1 `
  199. }
  200. } else if sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_ADMIN || sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_ADMIN {
  201. // 管理员,默认查看“待分配”客户
  202. listParam = 2
  203. }
  204. }
  205. if listParam == 1 {
  206. condition += ` AND a.share_seller_id > 0 AND a.is_share=1 `
  207. } else if listParam == 2 {
  208. condition += ` AND a.share_seller_id = 0 AND a.is_share=1 `
  209. } else if listParam == 3 { // 未共享
  210. condition += ` AND a.is_share=0 and b.status="正式"`
  211. }
  212. if sellerIds != "" {
  213. condition += ` AND a.share_seller_id IN (` + sellerIds + `) `
  214. }
  215. if originalSellerIds != "" {
  216. condition += ` AND b.seller_id IN (` + originalSellerIds + `) `
  217. }
  218. total, err := company.GetShareCompanyListCount(condition, pars)
  219. if err != nil {
  220. br.Msg = "获取失败"
  221. br.ErrMsg = "获取数据总数失败,Err:" + err.Error()
  222. return
  223. }
  224. sortStr := ``
  225. if sortParam != "" && sortType != "" {
  226. if sortParam == "expireDay" {
  227. if roleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  228. if sortType == "asc" {
  229. sortStr = " ORDER BY min_end_date"
  230. } else {
  231. sortStr = " ORDER BY max_end_date"
  232. }
  233. } else {
  234. sortStr = " ORDER BY b.end_date "
  235. }
  236. } else if sortParam == "createTime" {
  237. sortStr = " ORDER BY a.created_time "
  238. } else if sortParam == "viewTotal" {
  239. if roleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  240. sortStr = " ORDER BY all_view_total"
  241. } else {
  242. sortStr = " ORDER BY b.view_total "
  243. }
  244. } else if sortParam == "viewTime" {
  245. if roleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  246. if sortType == "asc" {
  247. sortStr = " ORDER BY min_last_view_time"
  248. } else {
  249. sortStr = " ORDER BY max_last_view_time"
  250. }
  251. } else {
  252. sortStr = " ORDER BY b.last_view_time "
  253. }
  254. } else if sortParam == "roadShowTotal" {
  255. sortStr = " ORDER BY b.road_show_total "
  256. } else if sortParam == "formalTime" {
  257. sortStr = " ORDER BY b.formal_time "
  258. } else if sortParam == "freezeTime" {
  259. sortStr = " ORDER BY b.freeze_time "
  260. } else if sortParam == "lossTime" {
  261. sortStr = " ORDER BY b.loss_time "
  262. } else if sortParam == "todoCreateTime" {
  263. sortStr = " ORDER BY b.todo_create_time "
  264. } else if sortParam == "todoApproveTime" {
  265. sortStr = " ORDER BY b.todo_approve_time "
  266. } else if sortParam == "tryOutDay" {
  267. if roleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  268. sortStr = " ORDER BY all_try_out_day_total "
  269. } else {
  270. sortStr = " ORDER BY b.try_out_day_total "
  271. }
  272. } else if sortParam == "lastServiceTime" {
  273. // 最新服务时间
  274. sortStr = ` ORDER BY last_service_time `
  275. } else if sortParam == "serviceTimes" {
  276. // 服务次数
  277. sortStr = ` ORDER BY service_times `
  278. } else {
  279. br.Msg = "获取失败"
  280. br.ErrMsg = "排序字段传入数据异常:" + sortParam
  281. return
  282. }
  283. sortStr += fmt.Sprintf(` %s`, sortType)
  284. } else {
  285. if roleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  286. sortStr = " ORDER BY sort_status asc, all_view_total desc, a.created_time "
  287. } else {
  288. sortStr = " ORDER BY sort_status asc, b.view_total desc, a.created_time "
  289. }
  290. sortStr += " DESC "
  291. }
  292. list, err := company.GetShareCompanyList(condition, sortStr, pars, startSize, pageSize)
  293. if err != nil {
  294. br.Msg = "获取失败"
  295. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  296. return
  297. }
  298. //企业用户数组切片
  299. companyIds := make([]int, 0)
  300. companyIdSlice := make([]string, 0)
  301. for _, v := range list {
  302. companyIds = append(companyIds, v.CompanyId)
  303. companyIdSlice = append(companyIdSlice, strconv.Itoa(v.CompanyId))
  304. }
  305. //企业用户产品开通数
  306. companyIdStr := strings.Join(companyIdSlice, ",")
  307. companyProductTotalList, _ := company.GetCountProductByCompanyIds(companyIdStr)
  308. companyProductTotalMap := make(map[int]*company.CompanyProductTotalSlice)
  309. for _, companyProductTotal := range companyProductTotalList {
  310. companyProductTotalMap[companyProductTotal.CompanyId] = companyProductTotal
  311. }
  312. lenList := len(list)
  313. // 客户产品详细信息
  314. companyProductMap := make(map[string]*company.CompanyProduct)
  315. var companyProductCondition string
  316. var companyProductPars []interface{}
  317. companyProductList, err := company.GetCompanyProductsByCompanyIds(companyIdStr, companyProductCondition, companyProductPars)
  318. if err != nil {
  319. br.Msg = "获取失败"
  320. br.ErrMsg = "获取客户产品数据失败,Err:" + err.Error()
  321. return
  322. }
  323. for _, companyProduct := range companyProductList {
  324. key := fmt.Sprint(companyProduct.CompanyId, "_", companyProduct.ProductId)
  325. companyProductMap[key] = companyProduct
  326. }
  327. // 查询当前销售是否有领取客户的权限
  328. //receiveEnabled, _ := services.CheckCompanyReceiveButton(sysUser.AdminId)
  329. for i := 0; i < lenList; i++ {
  330. item := list[i]
  331. //校验该客户是否存在多个产品,如果是,那么代表是共享客户
  332. if companyProductTotal, ok := companyProductTotalMap[int(item.CompanyId)]; ok {
  333. if companyProductTotal.Total > 1 {
  334. list[i].IsShared = true
  335. }
  336. }
  337. var expireDay string
  338. itemStatus := item.Status
  339. if itemStatus != "" {
  340. if !strings.Contains(item.Status, "/") {
  341. if itemStatus == utils.COMPANY_STATUS_FOREVER { //永续
  342. expireDay = "-"
  343. } else if itemStatus == utils.COMPANY_STATUS_TRY_OUT || itemStatus == utils.COMPANY_STATUS_FORMAL { //试用/正式
  344. if item.StartDate != "" && item.EndDate != "" {
  345. endDateTime, _ := time.Parse(utils.FormatDate, item.EndDate)
  346. endDateTime = endDateTime.AddDate(0, 0, 1)
  347. sub := endDateTime.Sub(time.Now())
  348. if sub < 0 {
  349. sub = 0
  350. }
  351. expireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  352. } else {
  353. expireDay = "-"
  354. }
  355. } else if itemStatus == utils.COMPANY_STATUS_LOSE {
  356. expireDay = "-"
  357. } else if itemStatus == utils.COMPANY_STATUS_FREEZE {
  358. if item.StartDate != "" && item.EndDate != "" {
  359. endDateTime, _ := time.Parse(utils.FormatDate, item.EndDate)
  360. endDateTime = endDateTime.AddDate(0, 0, 0)
  361. sub := endDateTime.Sub(time.Now())
  362. if sub < 0 {
  363. sub = 0
  364. }
  365. expireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  366. } else {
  367. expireDay = "-"
  368. }
  369. } else {
  370. expireDay = "-"
  371. }
  372. } else {
  373. tmpStatusArr := strings.Split(item.Status, "/")
  374. ficcStatus := tmpStatusArr[0]
  375. raiStatus := tmpStatusArr[1]
  376. var ficcEndDate, tryEndDate string
  377. var ficcExpireDay, tryExpireDay string
  378. if item.EndDate != "" {
  379. endDateArr := strings.Split(item.EndDate, "/")
  380. if len(endDateArr) == 1 {
  381. ficcEndDate = endDateArr[0]
  382. } else if len(endDateArr) > 1 {
  383. ficcEndDate = endDateArr[0]
  384. tryEndDate = endDateArr[1]
  385. }
  386. if ficcStatus == utils.COMPANY_STATUS_FOREVER { //永续
  387. ficcExpireDay = "-"
  388. } else if ficcStatus == utils.COMPANY_STATUS_TRY_OUT || ficcStatus == utils.COMPANY_STATUS_FORMAL { //试用/正式
  389. if ficcEndDate != "" {
  390. endDateTime, _ := time.Parse(utils.FormatDate, ficcEndDate)
  391. endDateTime = endDateTime.AddDate(0, 0, 1)
  392. sub := endDateTime.Sub(time.Now())
  393. if sub < 0 {
  394. sub = 0
  395. }
  396. ficcExpireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  397. } else {
  398. ficcExpireDay = "-"
  399. }
  400. } else if ficcStatus == utils.COMPANY_STATUS_LOSE { //流失
  401. ficcExpireDay = "-"
  402. } else if ficcStatus == utils.COMPANY_STATUS_FREEZE { //冻结
  403. if item.StartDate != "" && item.EndDate != "" {
  404. endDateTime, _ := time.Parse(utils.FormatDate, ficcEndDate)
  405. endDateTime = endDateTime.AddDate(0, 0, 0)
  406. sub := endDateTime.Sub(time.Now())
  407. if sub < 0 {
  408. sub = 0
  409. }
  410. ficcExpireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  411. } else {
  412. ficcExpireDay = "-"
  413. }
  414. } else {
  415. ficcExpireDay = "-"
  416. }
  417. if raiStatus == utils.COMPANY_STATUS_FOREVER { //永续
  418. tryExpireDay = "-"
  419. } else if raiStatus == utils.COMPANY_STATUS_TRY_OUT || raiStatus == utils.COMPANY_STATUS_FORMAL { //试用/正式
  420. if tryEndDate != "" {
  421. endDateTime, _ := time.Parse(utils.FormatDate, tryEndDate)
  422. endDateTime = endDateTime.AddDate(0, 0, 1)
  423. sub := endDateTime.Sub(time.Now())
  424. if sub < 0 {
  425. sub = 0
  426. }
  427. tryExpireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  428. } else {
  429. tryExpireDay = "-"
  430. }
  431. } else if raiStatus == utils.COMPANY_STATUS_LOSE { //流失
  432. tryExpireDay = "-"
  433. } else if raiStatus == utils.COMPANY_STATUS_FREEZE { //冻结
  434. if item.StartDate != "" && item.EndDate != "" {
  435. endDateTime, _ := time.Parse(utils.FormatDate, tryEndDate)
  436. endDateTime = endDateTime.AddDate(0, 0, 0)
  437. sub := endDateTime.Sub(time.Now())
  438. if sub < 0 {
  439. sub = 0
  440. }
  441. tryExpireDay = fmt.Sprintf("%v", int(sub.Hours()/24))
  442. } else {
  443. tryExpireDay = "-"
  444. }
  445. } else {
  446. tryExpireDay = "-"
  447. }
  448. }
  449. expireDay = ficcExpireDay + "/" + tryExpireDay
  450. }
  451. }
  452. list[i].ExpireDay = expireDay
  453. //按钮显示控制
  454. btnItem := new(company.ButtonPermission)
  455. if item.CompanyId != 1 {
  456. //*btnItem = services.GetCompanyPermissionButton(roleTypeCode, itemStatus, item.GroupIds, item.GroupIds, item.GroupId, sysUser.GroupId, item.SellerId, sysUser.AdminId, sysUser.Authority, item.ProductId, item.ShareSellerId)
  457. //根据销售"领取客户"的权限对部分按钮做限制
  458. //btnItem = services.GetCompanyPermissionButtonByReceiveEnabled(btnItem, receiveEnabled)
  459. // 13.6正式客户共享按钮显示控制
  460. btnItem = services.GetShareCompanyPermissionButton(roleTypeCode, itemStatus, item.ProductId, item, sysUser)
  461. }
  462. list[i].BtnItem = btnItem
  463. if item.FreezeStartDate != "" && item.FreezeEndDate != "" && item.Status == utils.COMPANY_STATUS_FREEZE {
  464. freezeEndDate, _ := time.Parse(utils.FormatDate, item.FreezeEndDate)
  465. if time.Now().Before(freezeEndDate) {
  466. expireDays := freezeEndDate.Sub(time.Now()).Hours() / 24
  467. list[i].FreezeExpireDays = int(expireDays) + 1
  468. }
  469. }
  470. ficcKey := fmt.Sprint(item.CompanyId, "_", 1)
  471. //ficc
  472. if tmpCompanyProduct, ok := companyProductMap[ficcKey]; ok {
  473. //套餐类型
  474. item.FiccPackageType = tmpCompanyProduct.PackageType
  475. //总试用天数
  476. item.FiccTryOutDay = tmpCompanyProduct.TryOutDayTotal
  477. //总阅读次数
  478. item.FiccView = tmpCompanyProduct.ViewTotal
  479. if !tmpCompanyProduct.LastViewTime.IsZero() {
  480. //最近一次阅读时间
  481. item.FiccLastViewTime = tmpCompanyProduct.LastViewTime.Format(utils.FormatDateTime)
  482. }
  483. }
  484. //权益
  485. raiKey := fmt.Sprint(item.CompanyId, "_", 2)
  486. if tmpCompanyProduct, ok := companyProductMap[raiKey]; ok {
  487. //总阅读次数
  488. item.RaiView = tmpCompanyProduct.ViewTotal
  489. //总试用天数
  490. item.RaiTryOutDay = tmpCompanyProduct.TryOutDayTotal
  491. if !tmpCompanyProduct.LastViewTime.IsZero() {
  492. //最近一次阅读时间
  493. item.RaiLastViewTime = tmpCompanyProduct.LastViewTime.Format(utils.FormatDateTime)
  494. }
  495. }
  496. }
  497. companyLists := make([]*company.CompanyListItem, 0)
  498. //查询阅读次数
  499. if list == nil {
  500. companyLists = make([]*company.CompanyListItem, 0)
  501. } else {
  502. for _, v := range list {
  503. //viewTotal:=GetviewTotal(v.CompanyId)
  504. //活跃(客户状态)
  505. tmpStatus := v.Status
  506. if v.IsShare == 1 {
  507. tmpStatus = v.Status + "(共享)"
  508. } else {
  509. if v.BtnItem.BtnModifySeller == true {
  510. v.BtnItem.BtnModifySeller = false
  511. }
  512. }
  513. if v.IsShare == 1 && v.BtnItem.BtnModifySeller == true {
  514. //如果已经是共享客户了,取消共享按钮全都显示,和修改销售权限一样
  515. v.BtnItem.BtnShare = true
  516. }
  517. companyList := &company.CompanyListItem{
  518. CompanyId: v.CompanyId,
  519. CompanyName: v.CompanyName,
  520. CreditCode: v.CreditCode,
  521. CompanyCode: v.CompanyCode,
  522. StartDate: v.StartDate,
  523. EndDate: v.EndDate,
  524. LoseReason: v.LoseReason,
  525. RenewalReason: v.RenewalReason,
  526. FreezeReason: v.FreezeReason,
  527. LossTime: v.LossTime,
  528. Status: tmpStatus,
  529. CompanyType: v.CompanyType,
  530. ApproveStatus: v.ApproveStatus,
  531. SellerName: v.SellerName,
  532. SellerId: v.SellerId,
  533. SellerIds: v.SellerIds,
  534. ExpireDay: v.ExpireDay,
  535. FreezeTime: v.FreezeTime,
  536. GroupId: v.GroupId,
  537. GroupIds: v.GroupIds,
  538. DepartmentId: v.DepartmentId,
  539. IndustryName: v.IndustryName,
  540. IsSuspend: v.IsSuspend,
  541. CreatedTime: v.CreatedTime,
  542. Source: v.Source,
  543. Province: v.Province,
  544. City: v.City,
  545. Address: v.Address,
  546. Reasons: v.Reasons,
  547. FreezeStartDate: v.FreezeStartDate,
  548. FreezeEndDate: v.FreezeEndDate,
  549. FreezeExpireDays: v.FreezeExpireDays,
  550. BtnItem: v.BtnItem,
  551. ProductId: v.ProductId,
  552. FormalTime: v.FormalTime,
  553. IsShared: v.IsShared,
  554. RegionType: v.RegionType,
  555. FiccPackageType: v.FiccPackageType,
  556. FiccLastViewTime: v.FiccLastViewTime,
  557. RaiLastViewTime: v.RaiLastViewTime,
  558. //FiccView: viewTotal[0],
  559. //RaiView: viewTotal[1],
  560. //FiccView: ficcViewTotal,
  561. //RaiView: raiViewTotal,
  562. FiccView: v.FiccView,
  563. RaiView: v.RaiView,
  564. FiccTryOutDay: v.FiccTryOutDay,
  565. RaiTryOutDay: v.RaiTryOutDay,
  566. AllViewTotal: v.AllViewTotal,
  567. RoadShowTotal: v.RoadShowTotal,
  568. TryStageSlice: v.TryStageSlice,
  569. Deadline: v.Deadline,
  570. WeekViewActive: v.WeekViewActive,
  571. IsShare: v.IsShare,
  572. ShareSeller: v.ShareSeller,
  573. ShareSellerId: v.ShareSellerId,
  574. LastServiceTime: v.LastServiceTime,
  575. ServiceTimes: v.ServiceTimes,
  576. }
  577. companyLists = append(companyLists, companyList)
  578. }
  579. }
  580. if companyLists == nil {
  581. companyLists = make([]*company.CompanyListItem, 0)
  582. }
  583. var isShareGroup bool
  584. if sysUser.GroupId == groupId {
  585. isShareGroup = true
  586. }
  587. page = paging.GetPaging(currentIndex, pageSize, total)
  588. resp := new(company.CompanyListResp)
  589. resp.List = companyLists
  590. resp.IsShareGroup = isShareGroup
  591. resp.Status = listParam
  592. resp.Paging = page
  593. br.Ret = 200
  594. br.Success = true
  595. br.Msg = "获取成功"
  596. br.Data = resp
  597. }
  598. // @Title 分配共享销售
  599. // @Description 分配共享销售接口
  600. // @Param request body company.MoveShareSellerReq true "type json string"
  601. // @Success Ret=200 分配成功
  602. // @router /share/moveSeller [post]
  603. func (this *CompanyController) MoveShareSeller() {
  604. br := new(models.BaseResponse).Init()
  605. defer func() {
  606. this.Data["json"] = br
  607. this.ServeJSON()
  608. }()
  609. sysUser := this.SysUser
  610. if sysUser == nil {
  611. br.Msg = "请登录"
  612. br.ErrMsg = "请登录,SysUser Is Empty"
  613. br.Ret = 408
  614. return
  615. }
  616. var req company.MoveShareSellerReq
  617. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  618. if err != nil {
  619. br.Msg = "参数解析异常!"
  620. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  621. return
  622. }
  623. if req.CompanyId <= 0 {
  624. br.Msg = "参数异常!"
  625. br.ErrMsg = "CompanyId:" + strconv.Itoa(req.CompanyId)
  626. return
  627. }
  628. if req.SellsId <= 0 {
  629. br.Msg = "参数异常!"
  630. br.ErrMsg = "SellsId:" + strconv.Itoa(req.SellsId)
  631. return
  632. }
  633. seller, err := system.GetSysAdminById(req.SellsId)
  634. if err != nil {
  635. br.Msg = "获取销售信息失败"
  636. br.ErrMsg = "获取销售信息失败,Err:" + err.Error()
  637. return
  638. }
  639. //查询该客户
  640. companyItem, err := company.GetCompanyById(req.CompanyId)
  641. if err != nil {
  642. br.Msg = "查找客户失败"
  643. br.ErrMsg = "查找客户失败,Err:" + err.Error()
  644. return
  645. }
  646. //待更新字段
  647. updateCol := make([]string, 0)
  648. companyItem.ShareSeller = seller.RealName
  649. companyItem.ShareSellerId = seller.AdminId
  650. updateCol = append(updateCol, "ShareSeller", "ShareSellerId")
  651. err = companyItem.Update(updateCol)
  652. if err != nil {
  653. br.Msg = "修改客户信息失败"
  654. br.ErrMsg = "修改客户信息失败,Err:" + err.Error()
  655. return
  656. }
  657. //新增操作记录
  658. //{
  659. // remark := "移动到:" + seller.RealName
  660. // operation := "move_seller"
  661. // services.AddCompanyOperationRecord(req.CompanyId, seller.AdminId, sysUser.AdminId, productId, sysUser.AdminId, cp.CompanyName,
  662. // cp.ProductName, sysUser.RealName, remark, operation, "", sysUser.RealName, "", cp.Status)
  663. //}
  664. //变更销售员与联系人关系
  665. //_ = models.UpdateUserSellerRelationByCompanyId(req.CompanyId, productId, seller.AdminId, seller.RealName)
  666. br.Ret = 200
  667. br.Success = true
  668. br.Msg = "分配成功"
  669. }
  670. // CompanyShareAddRemark
  671. // @Title 新增客户备注
  672. // @Description 新增客户备注
  673. // @Param request body company.RemarkReq true "type json string"
  674. // @Success 200 编辑成功
  675. // @router /share/remark/add [post]
  676. func (this *CompanyController) CompanyShareAddRemark() {
  677. br := new(models.BaseResponse).Init()
  678. defer func() {
  679. this.Data["json"] = br
  680. this.ServeJSON()
  681. }()
  682. sysUser := this.SysUser
  683. if sysUser == nil {
  684. br.Msg = "请登录"
  685. br.ErrMsg = "请登录,SysUser Is Empty"
  686. br.Ret = 408
  687. return
  688. }
  689. var req company.RemarkReq
  690. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  691. if err != nil {
  692. br.Msg = "参数解析异常!"
  693. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  694. return
  695. }
  696. if req.CompanyId <= 0 {
  697. br.Msg = "参数缺失"
  698. br.ErrMsg = "参数缺失,客户编号未传!"
  699. return
  700. }
  701. if req.Remark == "" {
  702. br.Msg = "参数缺失"
  703. br.ErrMsg = "参数缺失,备注说明未传!"
  704. return
  705. }
  706. var productId int
  707. groupFicc := []string{
  708. utils.ROLE_TYPE_CODE_FICC_SELLER, utils.ROLE_TYPE_CODE_FICC_TEAM, utils.ROLE_TYPE_CODE_FICC_GROUP,
  709. utils.ROLE_TYPE_CODE_FICC_DEPARTMENT, utils.ROLE_TYPE_CODE_FICC_ADMIN,
  710. }
  711. groupRai := []string{
  712. utils.ROLE_TYPE_CODE_RAI_SELLER, utils.ROLE_TYPE_CODE_RAI_GROUP, utils.ROLE_TYPE_CODE_RAI_GROUP,
  713. utils.ROLE_TYPE_CODE_RAI_DEPARTMENT, utils.ROLE_TYPE_CODE_RAI_ADMIN,
  714. }
  715. if utils.InArrayByStr(groupFicc, sysUser.RoleTypeCode) {
  716. productId = 1
  717. }
  718. if utils.InArrayByStr(groupRai, sysUser.RoleTypeCode) {
  719. productId = 2
  720. }
  721. if productId == 0 {
  722. br.Msg = "该角色不可添加备注"
  723. return
  724. }
  725. companyProduct, err := company.GetCompanyProductByCompanyIdAndProductId(req.CompanyId, productId)
  726. if err != nil {
  727. br.Msg = "查询客户异常"
  728. br.ErrMsg = "查询客户异常,Err:" + err.Error()
  729. }
  730. remark := company.CompanyProductRemark{
  731. CompanyId: companyProduct.CompanyId,
  732. ProductId: companyProduct.ProductId,
  733. ProductName: companyProduct.ProductName,
  734. Remark: req.Remark,
  735. CreateTime: time.Now(),
  736. SysUserId: sysUser.AdminId,
  737. SysRealName: sysUser.RealName,
  738. }
  739. err = company.AddCompanyRemark(&remark)
  740. if err != nil {
  741. br.Msg = "操作失败"
  742. br.ErrMsg = "新增共享客户备注失败, Err: " + err.Error()
  743. return
  744. }
  745. go func() {
  746. approveContent := req.Remark
  747. remark := "新增备注"
  748. operation := "add_remark"
  749. _ = services.AddCompanyOperationRecord(req.CompanyId, companyProduct.SellerId, sysUser.AdminId, companyProduct.ProductId, sysUser.AdminId, companyProduct.CompanyName,
  750. companyProduct.ProductName, sysUser.RealName, remark, operation, approveContent, sysUser.RealName, "", companyProduct.Status)
  751. }()
  752. br.Ret = 200
  753. br.Success = true
  754. br.Msg = "编辑成功"
  755. }
  756. // CompanyShareMark
  757. // @Title 新增客户标记
  758. // @Description 新增客户标记
  759. // @Param request body company.CompanyMarkReq true "type json string"
  760. // @Success 200 编辑成功
  761. // @router /share/mark [post]
  762. func (this *CompanyController) CompanyShareMark() {
  763. br := new(models.BaseResponse).Init()
  764. defer func() {
  765. this.Data["json"] = br
  766. this.ServeJSON()
  767. }()
  768. sysUser := this.SysUser
  769. if sysUser == nil {
  770. br.Msg = "请登录"
  771. br.ErrMsg = "请登录,SysUser Is Empty"
  772. br.Ret = 408
  773. return
  774. }
  775. var req company.CompanyMarkReq
  776. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  777. if err != nil {
  778. br.Msg = "参数解析异常!"
  779. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  780. return
  781. }
  782. if req.CompanyServiceRecordId <= 0 {
  783. br.Msg = "参数缺失"
  784. br.ErrMsg = "参数缺失,备注ID未传!"
  785. return
  786. }
  787. err = company.UpdateCompanyServiceRecordMark(req.CompanyServiceRecordId, req.Status)
  788. if err != nil {
  789. br.Msg = "操作失败"
  790. br.ErrMsg = "新增共享客户备注失败, Err: " + err.Error()
  791. return
  792. }
  793. br.Ret = 200
  794. br.Success = true
  795. br.Msg = "编辑成功"
  796. }
  797. // @Title 共享客户列表-同城
  798. // @Description 共享客户列表接口
  799. // @Param Keyword query string true "搜索关键词"
  800. // @Param ListParam query int false "筛选字段参数,用来筛选的字段, 枚举值:0:全部 、 1:已分配 、 2:未分配 "
  801. // @Param SortParam query string false "排序字段参数,用来排序的字段, 枚举值:'viewTotal':总阅读次数 、 'viewTime':阅读时间 、 'roadShowTotal':累计路演次数 、`expireDay:到期时间` 、 `createTime:创建时间` 、 'formalTime': 转正时间 、 'freezeTime':冻结时间 、'lossTime':流失时间 、'tryOutDay':试用天数"
  802. // @Param SortType query string true "如何排序,是正序还是倒序,枚举值:`asc 正序`,`desc 倒叙`"
  803. // @Param PageSize query int true "每页数据条数"
  804. // @Param CurrentIndex query int true "当前页页码,从1开始"
  805. // @Success Ret=200 设置成功
  806. // @router /share/list/city [get]
  807. func (this *CompanyController) CompanyShareListByCity() {
  808. br := new(models.BaseResponse).Init()
  809. defer func() {
  810. this.Data["json"] = br
  811. this.ServeJSON()
  812. }()
  813. sysUser := this.SysUser
  814. if sysUser == nil {
  815. br.Msg = "请登录"
  816. br.ErrMsg = "请登录,SysUser Is Empty"
  817. br.Ret = 408
  818. return
  819. }
  820. pageSize, _ := this.GetInt("PageSize")
  821. currentIndex, _ := this.GetInt("CurrentIndex")
  822. keyword := this.GetString("Keyword")
  823. province := this.GetString("Province")
  824. city := this.GetString("City")
  825. //排序参数
  826. //sortParam := this.GetString("SortParam")
  827. //listParam, _ := this.GetInt("ListParam")
  828. //sortType := this.GetString("SortType")
  829. var total int
  830. page := paging.GetPaging(currentIndex, pageSize, total)
  831. var startSize int
  832. if pageSize <= 0 {
  833. pageSize = utils.PageSize20
  834. }
  835. if currentIndex <= 0 {
  836. currentIndex = 1
  837. }
  838. startSize = paging.StartIndex(currentIndex, pageSize)
  839. var condition string
  840. var pars []interface{}
  841. if keyword != "" {
  842. companyIdStr, err := company.GetCompanyIdByKeyWord(keyword)
  843. if err != nil {
  844. br.Msg = "获取客户信息失败"
  845. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  846. return
  847. }
  848. if companyIdStr != "" {
  849. condition += ` AND (a.company_name LIKE '%` + keyword + `%' OR a.credit_code LIKE '%` + keyword + `%' OR a.company_id IN(` + companyIdStr + `)) `
  850. } else {
  851. condition += ` AND (a.company_name LIKE '%` + keyword + `%' OR a.credit_code LIKE '%` + keyword + `%' ) `
  852. }
  853. }
  854. condition += ` AND a.is_share=1 `
  855. if province != "" {
  856. var provinceSql string
  857. slice := strings.Split(province, ",")
  858. for _, v := range slice {
  859. provinceSql += "'" + v + "'" + ","
  860. }
  861. provinceSql = strings.TrimRight(provinceSql, ",")
  862. condition += ` AND a.province IN (` + provinceSql + `) `
  863. }
  864. if city != "" {
  865. var citySql string
  866. slice := strings.Split(city, ",")
  867. for _, v := range slice {
  868. citySql += "'" + v + "'" + ","
  869. }
  870. citySql = strings.TrimRight(citySql, ",")
  871. condition += ` AND a.city IN (` + citySql + `) `
  872. }
  873. total, err := company.GetShareCompanyListCount(condition, pars)
  874. if err != nil {
  875. br.Msg = "获取失败"
  876. br.ErrMsg = "获取数据总数失败,Err:" + err.Error()
  877. return
  878. }
  879. sortStr := ` `
  880. //if sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  881. // sortStr = " ORDER BY sort_status asc, all_view_total desc, a.created_time "
  882. //} else {
  883. // sortStr = " ORDER BY sort_status asc, b.view_total desc, a.created_time "
  884. //}
  885. list, err := company.GetShareCompanyList(condition, sortStr, pars, startSize, pageSize)
  886. if err != nil {
  887. br.Msg = "获取失败"
  888. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  889. return
  890. }
  891. //企业用户数组切片
  892. companyIds := make([]int, 0)
  893. companyIdSlice := make([]string, 0)
  894. for _, v := range list {
  895. companyIds = append(companyIds, v.CompanyId)
  896. companyIdSlice = append(companyIdSlice, strconv.Itoa(v.CompanyId))
  897. }
  898. //企业用户产品开通数
  899. companyIdStr := strings.Join(companyIdSlice, ",")
  900. companyProductTotalList, _ := company.GetCountProductByCompanyIds(companyIdStr)
  901. companyProductTotalMap := make(map[int]*company.CompanyProductTotalSlice)
  902. for _, companyProductTotal := range companyProductTotalList {
  903. companyProductTotalMap[companyProductTotal.CompanyId] = companyProductTotal
  904. }
  905. // 客户产品详细信息
  906. companyProductMap := make(map[string]*company.CompanyProduct)
  907. var companyProductCondition string
  908. var companyProductPars []interface{}
  909. companyProductList, err := company.GetCompanyProductsByCompanyIds(companyIdStr, companyProductCondition, companyProductPars)
  910. if err != nil {
  911. br.Msg = "获取失败"
  912. br.ErrMsg = "获取客户产品数据失败,Err:" + err.Error()
  913. return
  914. }
  915. for _, companyProduct := range companyProductList {
  916. key := fmt.Sprint(companyProduct.CompanyId, "_", companyProduct.ProductId)
  917. companyProductMap[key] = companyProduct
  918. }
  919. companyLists := make([]*company.CompanyListItem, 0)
  920. //查询阅读次数
  921. if list == nil {
  922. companyLists = make([]*company.CompanyListItem, 0)
  923. } else {
  924. for _, v := range list {
  925. //viewTotal:=GetviewTotal(v.CompanyId)
  926. //活跃(客户状态)
  927. tmpStatus := v.Status
  928. if v.IsShare == 1 {
  929. tmpStatus = v.Status + "(共享)"
  930. }
  931. companyList := &company.CompanyListItem{
  932. CompanyId: v.CompanyId,
  933. CompanyName: v.CompanyName,
  934. CreditCode: v.CreditCode,
  935. CompanyCode: v.CompanyCode,
  936. StartDate: v.StartDate,
  937. EndDate: v.EndDate,
  938. LoseReason: v.LoseReason,
  939. RenewalReason: v.RenewalReason,
  940. FreezeReason: v.FreezeReason,
  941. LossTime: v.LossTime,
  942. Status: tmpStatus,
  943. CompanyType: v.CompanyType,
  944. ApproveStatus: v.ApproveStatus,
  945. SellerName: v.SellerName,
  946. SellerId: v.SellerId,
  947. SellerIds: v.SellerIds,
  948. ExpireDay: v.ExpireDay,
  949. FreezeTime: v.FreezeTime,
  950. GroupId: v.GroupId,
  951. GroupIds: v.GroupIds,
  952. DepartmentId: v.DepartmentId,
  953. IndustryName: v.IndustryName,
  954. IsSuspend: v.IsSuspend,
  955. CreatedTime: v.CreatedTime,
  956. Source: v.Source,
  957. Province: v.Province,
  958. City: v.City,
  959. Address: v.Address,
  960. Reasons: v.Reasons,
  961. FreezeStartDate: v.FreezeStartDate,
  962. FreezeEndDate: v.FreezeEndDate,
  963. FreezeExpireDays: v.FreezeExpireDays,
  964. BtnItem: v.BtnItem,
  965. ProductId: v.ProductId,
  966. FormalTime: v.FormalTime,
  967. IsShared: v.IsShared,
  968. RegionType: v.RegionType,
  969. FiccPackageType: v.FiccPackageType,
  970. FiccLastViewTime: v.FiccLastViewTime,
  971. RaiLastViewTime: v.RaiLastViewTime,
  972. //FiccView: viewTotal[0],
  973. //RaiView: viewTotal[1],
  974. //FiccView: ficcViewTotal,
  975. //RaiView: raiViewTotal,
  976. FiccView: v.FiccView,
  977. RaiView: v.RaiView,
  978. FiccTryOutDay: v.FiccTryOutDay,
  979. RaiTryOutDay: v.RaiTryOutDay,
  980. AllViewTotal: v.AllViewTotal,
  981. RoadShowTotal: v.RoadShowTotal,
  982. TryStageSlice: v.TryStageSlice,
  983. Deadline: v.Deadline,
  984. WeekViewActive: v.WeekViewActive,
  985. IsShare: v.IsShare,
  986. ShareSeller: v.ShareSeller,
  987. ShareSellerId: v.ShareSellerId,
  988. LastServiceTime: v.LastServiceTime,
  989. ServiceTimes: v.ServiceTimes,
  990. }
  991. companyLists = append(companyLists, companyList)
  992. }
  993. }
  994. if companyLists == nil {
  995. companyLists = make([]*company.CompanyListItem, 0)
  996. }
  997. page = paging.GetPaging(currentIndex, pageSize, total)
  998. resp := new(company.CompanyListResp)
  999. resp.List = companyLists
  1000. resp.Paging = page
  1001. br.Ret = 200
  1002. br.Success = true
  1003. br.Msg = "获取成功"
  1004. br.Data = resp
  1005. }