company_share.go 33 KB

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