company_share.go 33 KB

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