report.go 60 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869
  1. package roadshow
  2. import (
  3. "encoding/json"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. "hongze/hz_crm_api/models"
  6. "hongze/hz_crm_api/models/company"
  7. "hongze/hz_crm_api/models/cygx"
  8. "hongze/hz_crm_api/models/roadshow"
  9. "hongze/hz_crm_api/models/system"
  10. "hongze/hz_crm_api/services"
  11. roadshowService "hongze/hz_crm_api/services/roadshow"
  12. "hongze/hz_crm_api/utils"
  13. "strconv"
  14. "strings"
  15. "time"
  16. )
  17. // ResearcherReportList
  18. // @Title 研究员路演统计
  19. // @Description 研究员路演统计接口
  20. // @Param DataType query string true "枚举值:week、month、time_interval"
  21. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  22. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  23. // @Param CompanyType query string true "客户类型:'ficc','权益',传空默认为ficc,"
  24. // @Success 200 {object} roadshow.RsReportRecordResp
  25. // @router /report/researcher/list [get]
  26. func (this *CalendarController) ResearcherReportList() {
  27. br := new(models.BaseResponse).Init()
  28. defer func() {
  29. this.Data["json"] = br
  30. this.ServeJSON()
  31. }()
  32. sysUser := this.SysUser
  33. if sysUser == nil {
  34. br.Msg = "请登录"
  35. br.ErrMsg = "请登录,SysUser Is Empty"
  36. br.Ret = 408
  37. return
  38. }
  39. dataType := this.GetString("DataType")
  40. startDate := this.GetString("StartDate")
  41. endDate := this.GetString("EndDate")
  42. companyType := this.GetString("CompanyType", "ficc")
  43. var adminDataList []roadshowService.AdminDataMap
  44. var err error
  45. //var firstDate time.Time
  46. //获取列表
  47. switch dataType {
  48. case "week":
  49. adminDataList, _, err = roadshowService.GetWeekData("researcher", "company_status")
  50. if err != nil {
  51. br.Msg = "数据异常"
  52. br.ErrMsg = "数据异常,Err:" + err.Error()
  53. return
  54. }
  55. case "month":
  56. adminDataList, _, err = roadshowService.GetMonthData("researcher", "company_status")
  57. if err != nil {
  58. br.Msg = "数据异常"
  59. br.ErrMsg = "数据异常,Err:" + err.Error()
  60. return
  61. }
  62. case "time_interval":
  63. if startDate == `` || endDate == `` {
  64. br.Msg = "开始日期或结束日期不能为空"
  65. br.ErrMsg = "开始日期或结束日期不能为空,Err:" + err.Error()
  66. return
  67. }
  68. adminDataList, _, err = roadshowService.GetTimeIntervalData(startDate, endDate, "researcher", "company_status")
  69. if err != nil {
  70. br.Msg = "数据异常"
  71. br.ErrMsg = "数据异常,Err:" + err.Error()
  72. return
  73. }
  74. }
  75. var group []*roadshow.ResearcherGroup
  76. var researcherList []*roadshow.ResearcherGroup
  77. switch companyType {
  78. case utils.COMPANY_CLASSIFY_FICC:
  79. group, err = roadshow.GetResearcherGroup()
  80. if err != nil {
  81. br.Msg = "获取信息失败!"
  82. br.ErrMsg = "获取分组信息失败!Err:" + err.Error()
  83. return
  84. }
  85. researcherList, err = roadshow.GetResearcherV2()
  86. if err != nil {
  87. br.Msg = "获取信息失败!"
  88. br.ErrMsg = "获取分组信息失败!,GetResearcherV2 Err:" + err.Error()
  89. return
  90. }
  91. case utils.COMPANY_CLASSIFY_RAI:
  92. mapPermissionUser := make(map[string][]*roadshow.ResearcherGroup)
  93. listPermission, err := cygx.GetChartPermissionAll()
  94. if err != nil {
  95. br.Msg = "获取信息失败"
  96. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  97. return
  98. }
  99. mapPermissionId := make(map[string]int)
  100. for _, v := range listPermission {
  101. mapPermissionId[v.PermissionName] = v.ChartPermissionId
  102. }
  103. askUserList, err := cygx.GetAskEmailListResearcher()
  104. if err != nil {
  105. br.Msg = "获取失败"
  106. br.ErrMsg = "获取失败,GetAskEmailListResearcher Err: " + err.Error()
  107. return
  108. }
  109. sysUserList, err := system.GetAdminList()
  110. if err != nil {
  111. br.Msg = "获取失败"
  112. br.ErrMsg = "获取admin列表失败, Err:" + err.Error()
  113. return
  114. }
  115. adminMap := make(map[int]*system.Admin, 0)
  116. for _, v := range sysUserList {
  117. adminMap[v.AdminId] = v
  118. }
  119. for _, v := range askUserList {
  120. if admin, ok := adminMap[v.AdminId]; ok {
  121. item := &roadshow.ResearcherGroup{
  122. AdminId: v.AdminId,
  123. RealName: v.Name,
  124. GroupId: mapPermissionId[v.ChartPermissionName], //行业ID作为组别,进行关系映射
  125. GroupName: admin.GroupName,
  126. RoleTypeCode: admin.RoleTypeCode,
  127. }
  128. mapPermissionUser[v.ChartPermissionName] = append(mapPermissionUser[v.ChartPermissionName], item)
  129. researcherList = append(researcherList, item)
  130. }
  131. }
  132. for k, v := range mapPermissionUser {
  133. respItem := new(roadshow.ResearcherGroup)
  134. respItem.GroupName = k + "组"
  135. respItem.GroupId = mapPermissionId[k]
  136. respItem.ResearcherList = v
  137. group = append(group, respItem)
  138. }
  139. }
  140. groupMap := make(map[int][]*roadshow.ResearcherGroup)
  141. for _, v := range researcherList {
  142. item := &roadshow.ResearcherGroup{
  143. GroupId: v.GroupId,
  144. GroupName: v.GroupName,
  145. AdminId: v.AdminId,
  146. RealName: v.RealName,
  147. RoleTypeCode: v.RoleTypeCode,
  148. }
  149. if findItems, ok := groupMap[v.GroupId]; ok {
  150. findItems = append(findItems, item)
  151. groupMap[v.GroupId] = findItems
  152. } else {
  153. findItems = append(findItems, item)
  154. groupMap[v.GroupId] = findItems
  155. }
  156. //}
  157. }
  158. for _, v := range group {
  159. v.ResearcherList = groupMap[v.GroupId]
  160. }
  161. groupReportRecordList := make([]roadshow.GroupReportRecord, 0)
  162. rsAllReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  163. RsReportRecordResp := roadshow.RsReportRecordResp{
  164. List: groupReportRecordList,
  165. RsReportRecordNumList: rsAllReportRecordNumList,
  166. }
  167. startDateIndexList := make(map[int]string) //开始时间间隔map
  168. endDateIndexList := make(map[int]string) //结束时间间隔map
  169. tmpAllTryOutNumMap := make(map[int]int)
  170. tmpAllFormalNumMap := make(map[int]int)
  171. tmpAllMeetingNumMap := make(map[int]int)
  172. tmpAllRoadShowNumMap := make(map[int]int)
  173. tmpAllSalonNumMap := make(map[int]int)
  174. for _, v := range group {
  175. v.ResearcherList = groupMap[v.GroupId]
  176. tmpGroupAdminReportRecord := make([]roadshow.AdminReportRecord, 0)
  177. tmpGroupRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  178. //roadShowMap := make(map[int]int) // 路演总次数
  179. //salonMap := make(map[int]int) //沙龙路演次数
  180. tmpGroupTryOutNumMap := make(map[int]int)
  181. tmpGroupFormalNumMap := make(map[int]int)
  182. tmpGroupMeetingNumMap := make(map[int]int)
  183. tmpGroupRoadShowNumMap := make(map[int]int)
  184. tmpGroupSalonMapNumMap := make(map[int]int)
  185. for _, researcher := range groupMap[v.GroupId] {
  186. //组内研究员数据
  187. //每个区间的数据
  188. tmpAdminRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  189. for index, adminData := range adminDataList {
  190. startDateIndexList[index] = adminData.StartDate
  191. endDateIndexList[index] = adminData.EndDate
  192. var tmpTryOutNum, tmpFormalNum, tmpMeetingNum, tmpRoadShowNum, tmpSalonNum int
  193. if num, ok := adminData.TryOutMap[researcher.AdminId]; ok {
  194. tmpTryOutNum = num
  195. }
  196. if num, ok := adminData.FormalMap[researcher.AdminId]; ok {
  197. tmpFormalNum = num
  198. }
  199. if num, ok := adminData.MeetingMap[researcher.AdminId]; ok {
  200. tmpMeetingNum = num
  201. }
  202. if num, ok := adminData.RoadShowMap[researcher.AdminId]; ok { //路演总次数
  203. tmpRoadShowNum = num
  204. }
  205. if num, ok := adminData.SalonMap[researcher.AdminId]; ok { //路演总次数
  206. tmpSalonNum = num
  207. }
  208. tmpAdminRsReportRecordNum := roadshow.RsReportRecordNum{
  209. TryOutNum: tmpTryOutNum,
  210. FormalNum: tmpFormalNum,
  211. MeetingNum: tmpMeetingNum,
  212. RoadShowNum: tmpRoadShowNum,
  213. SalonNum: tmpSalonNum,
  214. StartDate: adminData.StartDate,
  215. EndDate: adminData.EndDate,
  216. }
  217. tmpAdminRsReportRecordNumList = append(tmpAdminRsReportRecordNumList, tmpAdminRsReportRecordNum)
  218. //组内数据汇总
  219. if _, ok := tmpGroupTryOutNumMap[index]; !ok {
  220. tmpGroupTryOutNumMap[index] = 0
  221. }
  222. if _, ok := tmpGroupFormalNumMap[index]; !ok {
  223. tmpGroupFormalNumMap[index] = 0
  224. }
  225. if _, ok := tmpGroupMeetingNumMap[index]; !ok {
  226. tmpGroupMeetingNumMap[index] = 0
  227. }
  228. if _, ok := tmpGroupRoadShowNumMap[index]; !ok {
  229. tmpGroupRoadShowNumMap[index] = 0
  230. }
  231. if _, ok := tmpGroupSalonMapNumMap[index]; !ok {
  232. tmpGroupSalonMapNumMap[index] = 0
  233. }
  234. tmpGroupTryOutNumMap[index] += tmpTryOutNum
  235. tmpGroupFormalNumMap[index] += tmpFormalNum
  236. tmpGroupMeetingNumMap[index] += tmpMeetingNum
  237. tmpGroupRoadShowNumMap[index] += tmpRoadShowNum
  238. tmpGroupSalonMapNumMap[index] += tmpSalonNum
  239. //总数据汇总
  240. if _, ok := tmpAllTryOutNumMap[index]; !ok {
  241. tmpAllTryOutNumMap[index] = 0
  242. }
  243. if _, ok := tmpAllFormalNumMap[index]; !ok {
  244. tmpAllFormalNumMap[index] = 0
  245. }
  246. if _, ok := tmpAllMeetingNumMap[index]; !ok {
  247. tmpAllMeetingNumMap[index] = 0
  248. }
  249. if _, ok := tmpGroupRoadShowNumMap[index]; !ok {
  250. tmpGroupRoadShowNumMap[index] = 0
  251. }
  252. if _, ok := tmpGroupSalonMapNumMap[index]; !ok {
  253. tmpGroupSalonMapNumMap[index] = 0
  254. }
  255. tmpAllTryOutNumMap[index] += tmpTryOutNum
  256. tmpAllFormalNumMap[index] += tmpFormalNum
  257. tmpAllMeetingNumMap[index] += tmpMeetingNum
  258. tmpAllRoadShowNumMap[index] += tmpRoadShowNum
  259. tmpAllSalonNumMap[index] += tmpSalonNum
  260. }
  261. tmpAdminReportRecord := roadshow.AdminReportRecord{
  262. Name: researcher.RealName,
  263. AdminId: researcher.AdminId,
  264. RsReportRecordNumList: tmpAdminRsReportRecordNumList,
  265. }
  266. tmpGroupAdminReportRecord = append(tmpGroupAdminReportRecord, tmpAdminReportRecord)
  267. }
  268. for i := 0; i < len(tmpGroupMeetingNumMap); i++ {
  269. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  270. TryOutNum: tmpGroupTryOutNumMap[i],
  271. FormalNum: tmpGroupFormalNumMap[i],
  272. MeetingNum: tmpGroupMeetingNumMap[i],
  273. RoadShowNum: tmpGroupRoadShowNumMap[i],
  274. SalonNum: tmpGroupSalonMapNumMap[i],
  275. StartDate: startDateIndexList[i],
  276. EndDate: endDateIndexList[i],
  277. }
  278. tmpGroupRsReportRecordNumList = append(tmpGroupRsReportRecordNumList, tmpGroupRsReportRecordNum)
  279. }
  280. groupReportRecord := roadshow.GroupReportRecord{
  281. Item: tmpGroupAdminReportRecord,
  282. Name: v.GroupName,
  283. RsReportRecordNumList: tmpGroupRsReportRecordNumList,
  284. }
  285. RsReportRecordResp.List = append(RsReportRecordResp.List, groupReportRecord)
  286. }
  287. //总体汇总数据
  288. for i := 0; i < len(tmpAllFormalNumMap); i++ {
  289. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  290. TryOutNum: tmpAllTryOutNumMap[i],
  291. FormalNum: tmpAllFormalNumMap[i],
  292. MeetingNum: tmpAllMeetingNumMap[i],
  293. RoadShowNum: tmpAllRoadShowNumMap[i],
  294. SalonNum: tmpAllSalonNumMap[i],
  295. StartDate: startDateIndexList[i],
  296. EndDate: endDateIndexList[i],
  297. }
  298. rsAllReportRecordNumList = append(rsAllReportRecordNumList, tmpGroupRsReportRecordNum)
  299. }
  300. RsReportRecordResp.RsReportRecordNumList = rsAllReportRecordNumList
  301. br.Ret = 200
  302. br.Success = true
  303. br.Msg = "获取成功"
  304. br.Data = RsReportRecordResp
  305. return
  306. }
  307. // SellerReportList
  308. // @Title 销售路演统计
  309. // @Description 销售路演统计接口
  310. // @Param DataType query string true "枚举值:week、month、time_interval、online、offline"
  311. // @Param DimensionType query string true "维度枚举值:company_status、roadshow_type"
  312. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  313. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  314. // @Param CompanyType query string true "客户类型:'ficc','权益',传空默认为ficc,"
  315. // @Success 200 {object} roadshow.RsReportRecordResp
  316. // @router /report/seller/list [get]
  317. func (this *CalendarController) SellerReportList() {
  318. br := new(models.BaseResponse).Init()
  319. defer func() {
  320. this.Data["json"] = br
  321. this.ServeJSON()
  322. }()
  323. sysUser := this.SysUser
  324. if sysUser == nil {
  325. br.Msg = "请登录"
  326. br.ErrMsg = "请登录,SysUser Is Empty"
  327. br.Ret = 408
  328. return
  329. }
  330. dataType := this.GetString("DataType")
  331. dimensionType := this.GetString("DimensionType")
  332. startDate := this.GetString("StartDate")
  333. endDate := this.GetString("EndDate")
  334. companyType := this.GetString("CompanyType", "ficc")
  335. if dimensionType == "" {
  336. dimensionType = "company_status"
  337. }
  338. var adminDataList []roadshowService.AdminDataMap
  339. var err error
  340. var firstDate time.Time
  341. //获取列表
  342. switch dataType {
  343. case "week":
  344. adminDataList, firstDate, err = roadshowService.GetWeekDataV2("seller", dimensionType, 6)
  345. if err != nil {
  346. br.Msg = "数据异常"
  347. br.ErrMsg = "数据异常,Err:" + err.Error()
  348. return
  349. }
  350. case "month":
  351. adminDataList, firstDate, err = roadshowService.GetMonthDataV2("seller", dimensionType, 6)
  352. if err != nil {
  353. br.Msg = "数据异常"
  354. br.ErrMsg = "数据异常,Err:" + err.Error()
  355. return
  356. }
  357. case "time_interval":
  358. if startDate == `` || endDate == `` {
  359. br.Msg = "开始日期或结束日期不能为空"
  360. br.ErrMsg = "开始日期或结束日期不能为空,Err:" + err.Error()
  361. return
  362. }
  363. adminDataList, firstDate, err = roadshowService.GetTimeIntervalData(startDate, endDate, "seller", dimensionType)
  364. if err != nil {
  365. br.Msg = "数据异常"
  366. br.ErrMsg = "数据异常,Err:" + err.Error()
  367. return
  368. }
  369. }
  370. var group []services.AdminGroup
  371. var groupIdRelationMap map[int]int
  372. var researcherList []*roadshow.Researcher
  373. switch companyType {
  374. case utils.COMPANY_CLASSIFY_FICC:
  375. group, groupIdRelationMap, err = services.GetFiccSystemGroup()
  376. if err != nil {
  377. br.Msg = "获取信息失败!"
  378. br.ErrMsg = "获取FICC销售信息失败!Err:" + err.Error()
  379. return
  380. }
  381. researcherList, err = services.GetFiccSeller(firstDate, groupIdRelationMap)
  382. case utils.COMPANY_CLASSIFY_RAI:
  383. group, groupIdRelationMap, err = services.GetRaiSystemGroup()
  384. if err != nil {
  385. br.Msg = "获取信息失败!"
  386. br.ErrMsg = "获取分组信息失败!Err:" + err.Error()
  387. return
  388. }
  389. researcherList, err = services.GetRaiSeller(groupIdRelationMap)
  390. if err != nil {
  391. br.Msg = "获取信息失败!"
  392. br.ErrMsg = "获取权益销售信息失败!Err:" + err.Error()
  393. return
  394. }
  395. }
  396. groupMap := make(map[int][]*roadshow.Researcher)
  397. for _, v := range researcherList {
  398. if v.RoleTypeCode == "ficc_admin" {
  399. findItems := groupMap[1]
  400. findItems = append(findItems, v)
  401. groupMap[1] = findItems
  402. } else {
  403. if findItems, ok := groupMap[v.GroupId]; ok {
  404. findItems = append(findItems, v)
  405. groupMap[v.GroupId] = findItems
  406. } else {
  407. findItems = append(findItems, v)
  408. groupMap[v.GroupId] = findItems
  409. }
  410. }
  411. }
  412. groupReportRecordList := make([]roadshow.GroupReportRecord, 0)
  413. rsAllReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  414. RsReportRecordResp := roadshow.RsReportRecordResp{
  415. List: groupReportRecordList,
  416. RsReportRecordNumList: rsAllReportRecordNumList,
  417. }
  418. startDateIndexList := make(map[int]string) //开始时间间隔map
  419. endDateIndexList := make(map[int]string) //结束时间间隔map
  420. tmpAllTryOutNumMap := make(map[int]int)
  421. tmpAllFormalNumMap := make(map[int]int)
  422. tmpAllMeetingNumMap := make(map[int]int)
  423. tmpAllOnlineNumMap := make(map[int]int)
  424. tmpAllOfflineNumMap := make(map[int]int)
  425. tmpAllRoadShowNumMap := make(map[int]int)
  426. tmpAllSalonNumMap := make(map[int]int)
  427. for _, v := range group {
  428. v.ResearcherList = groupMap[v.GroupId]
  429. tmpGroupAdminReportRecord := make([]roadshow.AdminReportRecord, 0)
  430. tmpGroupRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  431. tmpGroupTryOutNumMap := make(map[int]int)
  432. tmpGroupFormalNumMap := make(map[int]int)
  433. tmpGroupMeetingNumMap := make(map[int]int)
  434. tmpGroupOnlineNumMap := make(map[int]int)
  435. tmpGroupOfflineNumMap := make(map[int]int)
  436. tmpGroupRoadShowNumMap := make(map[int]int)
  437. tmpGroupSalonNumMap := make(map[int]int)
  438. for _, researcher := range groupMap[v.GroupId] {
  439. //组内研究员数据
  440. //每个区间的数据
  441. tmpAdminRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  442. for index, adminData := range adminDataList {
  443. startDateIndexList[index] = adminData.StartDate
  444. endDateIndexList[index] = adminData.EndDate
  445. var tmpTryOutNum, tmpFormalNum, tmpMeetingNum, tmpOnlineNum, tmpOfflineNum, tmpRoadShowNum, tmpSalonNum int
  446. if num, ok := adminData.TryOutMap[researcher.AdminId]; ok {
  447. tmpTryOutNum = num
  448. }
  449. if num, ok := adminData.FormalMap[researcher.AdminId]; ok {
  450. tmpFormalNum = num
  451. }
  452. if num, ok := adminData.MeetingMap[researcher.AdminId]; ok {
  453. tmpMeetingNum = num
  454. }
  455. if num, ok := adminData.OnlineMap[researcher.AdminId]; ok {
  456. tmpOnlineNum = num
  457. }
  458. if num, ok := adminData.OfflineMap[researcher.AdminId]; ok {
  459. tmpOfflineNum = num
  460. }
  461. if num, ok := adminData.RoadShowMap[researcher.AdminId]; ok {
  462. tmpRoadShowNum = num
  463. }
  464. if num, ok := adminData.SalonMap[researcher.AdminId]; ok {
  465. tmpSalonNum = num
  466. }
  467. tmpAdminRsReportRecordNum := roadshow.RsReportRecordNum{
  468. TryOutNum: tmpTryOutNum,
  469. FormalNum: tmpFormalNum,
  470. MeetingNum: tmpMeetingNum,
  471. OnlineNum: tmpOnlineNum,
  472. OfflineNum: tmpOfflineNum,
  473. RoadShowNum: tmpRoadShowNum,
  474. SalonNum: tmpSalonNum,
  475. StartDate: adminData.StartDate,
  476. EndDate: adminData.EndDate,
  477. }
  478. tmpAdminRsReportRecordNumList = append(tmpAdminRsReportRecordNumList, tmpAdminRsReportRecordNum)
  479. //组内数据汇总
  480. if _, ok := tmpGroupTryOutNumMap[index]; !ok {
  481. tmpGroupTryOutNumMap[index] = 0
  482. }
  483. if _, ok := tmpGroupFormalNumMap[index]; !ok {
  484. tmpGroupFormalNumMap[index] = 0
  485. }
  486. if _, ok := tmpGroupMeetingNumMap[index]; !ok {
  487. tmpGroupMeetingNumMap[index] = 0
  488. }
  489. if _, ok := tmpGroupOnlineNumMap[index]; !ok {
  490. tmpGroupOnlineNumMap[index] = 0
  491. }
  492. if _, ok := tmpGroupOfflineNumMap[index]; !ok {
  493. tmpGroupOfflineNumMap[index] = 0
  494. }
  495. if _, ok := tmpGroupRoadShowNumMap[index]; !ok {
  496. tmpGroupRoadShowNumMap[index] = 0
  497. }
  498. if _, ok := tmpGroupSalonNumMap[index]; !ok {
  499. tmpGroupSalonNumMap[index] = 0
  500. }
  501. tmpGroupTryOutNumMap[index] += tmpTryOutNum
  502. tmpGroupFormalNumMap[index] += tmpFormalNum
  503. tmpGroupMeetingNumMap[index] += tmpMeetingNum
  504. tmpGroupOnlineNumMap[index] += tmpOnlineNum
  505. tmpGroupOfflineNumMap[index] += tmpOfflineNum
  506. tmpGroupRoadShowNumMap[index] += tmpRoadShowNum
  507. tmpGroupSalonNumMap[index] += tmpSalonNum
  508. //总数据汇总
  509. if _, ok := tmpAllTryOutNumMap[index]; !ok {
  510. tmpAllTryOutNumMap[index] = 0
  511. }
  512. if _, ok := tmpAllFormalNumMap[index]; !ok {
  513. tmpAllFormalNumMap[index] = 0
  514. }
  515. if _, ok := tmpAllMeetingNumMap[index]; !ok {
  516. tmpAllMeetingNumMap[index] = 0
  517. }
  518. if _, ok := tmpAllOnlineNumMap[index]; !ok {
  519. tmpAllOnlineNumMap[index] = 0
  520. }
  521. if _, ok := tmpAllOfflineNumMap[index]; !ok {
  522. tmpAllOfflineNumMap[index] = 0
  523. }
  524. if _, ok := tmpAllRoadShowNumMap[index]; !ok {
  525. tmpAllRoadShowNumMap[index] = 0
  526. }
  527. if _, ok := tmpAllSalonNumMap[index]; !ok {
  528. tmpAllSalonNumMap[index] = 0
  529. }
  530. tmpAllTryOutNumMap[index] += tmpTryOutNum
  531. tmpAllFormalNumMap[index] += tmpFormalNum
  532. tmpAllMeetingNumMap[index] += tmpMeetingNum
  533. tmpAllOnlineNumMap[index] += tmpOnlineNum
  534. tmpAllOfflineNumMap[index] += tmpOfflineNum
  535. tmpAllRoadShowNumMap[index] += tmpRoadShowNum
  536. tmpAllSalonNumMap[index] += tmpSalonNum
  537. }
  538. tmpAdminReportRecord := roadshow.AdminReportRecord{
  539. Name: researcher.RealName,
  540. AdminId: researcher.AdminId,
  541. RsReportRecordNumList: tmpAdminRsReportRecordNumList,
  542. }
  543. tmpGroupAdminReportRecord = append(tmpGroupAdminReportRecord, tmpAdminReportRecord)
  544. }
  545. for i := 0; i < len(tmpGroupMeetingNumMap); i++ {
  546. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  547. TryOutNum: tmpGroupTryOutNumMap[i],
  548. FormalNum: tmpGroupFormalNumMap[i],
  549. MeetingNum: tmpGroupMeetingNumMap[i],
  550. OnlineNum: tmpGroupOnlineNumMap[i],
  551. OfflineNum: tmpGroupOfflineNumMap[i],
  552. RoadShowNum: tmpGroupRoadShowNumMap[i],
  553. SalonNum: tmpGroupSalonNumMap[i],
  554. StartDate: startDateIndexList[i],
  555. EndDate: endDateIndexList[i],
  556. }
  557. tmpGroupRsReportRecordNumList = append(tmpGroupRsReportRecordNumList, tmpGroupRsReportRecordNum)
  558. }
  559. groupReportRecord := roadshow.GroupReportRecord{
  560. Item: tmpGroupAdminReportRecord,
  561. Name: v.GroupName,
  562. GruopId: v.GroupId,
  563. RsReportRecordNumList: tmpGroupRsReportRecordNumList,
  564. }
  565. groupReportRecordList = append(groupReportRecordList, groupReportRecord)
  566. }
  567. //总体汇总数据
  568. for i := 0; i < len(tmpAllFormalNumMap); i++ {
  569. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  570. TryOutNum: tmpAllTryOutNumMap[i],
  571. FormalNum: tmpAllFormalNumMap[i],
  572. MeetingNum: tmpAllMeetingNumMap[i],
  573. OnlineNum: tmpAllOnlineNumMap[i],
  574. OfflineNum: tmpAllOfflineNumMap[i],
  575. RoadShowNum: tmpAllRoadShowNumMap[i],
  576. SalonNum: tmpAllSalonNumMap[i],
  577. StartDate: startDateIndexList[i],
  578. EndDate: endDateIndexList[i],
  579. }
  580. rsAllReportRecordNumList = append(rsAllReportRecordNumList, tmpGroupRsReportRecordNum)
  581. }
  582. RsReportRecordResp.RsReportRecordNumList = rsAllReportRecordNumList
  583. //tmpList := groupReportRecordList
  584. //因为RoleTypeCode不一样,所以需要重新从数据库取数据
  585. //adminInfo, _ := system.GetSysAdminById(sysUser.AdminId)
  586. //adminGroupId := adminInfo.GroupId
  587. //if tmpGroupId, ok := groupIdRelationMap[adminGroupId]; ok {
  588. // adminGroupId = tmpGroupId
  589. //}
  590. //switch adminInfo.RoleTypeCode {
  591. //case utils.ROLE_TYPE_CODE_FICC_GROUP, utils.ROLE_TYPE_CODE_FICC_TEAM:
  592. // for index, v := range tmpList {
  593. // //如果不是同一个分组,那么就移除该分组下的人员数据
  594. // if v.GruopId != adminGroupId {
  595. // tmpList[index].Item = make([]roadshow.AdminReportRecord, 0)
  596. // }
  597. // }
  598. // RsReportRecordResp.List = tmpList
  599. //case utils.ROLE_TYPE_CODE_FICC_ADMIN, utils.ROLE_TYPE_CODE_ADMIN:
  600. // //管理员、超管看全部数据
  601. // RsReportRecordResp.List = groupReportRecordList
  602. //}
  603. // 20230529-有权限查看该页面的用户权限同admin
  604. RsReportRecordResp.List = groupReportRecordList
  605. br.Ret = 200
  606. br.Success = true
  607. br.Msg = "获取成功"
  608. br.Data = RsReportRecordResp
  609. return
  610. }
  611. // ReportCalendarList
  612. // @Title 路演详情列表
  613. // @Description 路演详情列表接口
  614. // @Param AdminType query string true "枚举值:researcher、seller、 special:专项路演"
  615. // @Param DataType query string true "枚举值:try_out、formal、meeting、online、offline"
  616. // @Param AdminId query int true "用户id"
  617. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  618. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  619. // @Success 200 {object} []roadshow.RsReportRecordList
  620. // @router /report/calendar/list [get]
  621. func (this *CalendarController) ReportCalendarList() {
  622. br := new(models.BaseResponse).Init()
  623. defer func() {
  624. this.Data["json"] = br
  625. this.ServeJSON()
  626. }()
  627. sysUser := this.SysUser
  628. if sysUser == nil {
  629. br.Msg = "请登录"
  630. br.ErrMsg = "请登录,SysUser Is Empty"
  631. br.Ret = 408
  632. return
  633. }
  634. adminType := this.GetString("AdminType")
  635. dataType := this.GetString("DataType")
  636. startDate := this.GetString("StartDate")
  637. endDate := this.GetString("EndDate")
  638. adminId, _ := this.GetInt("AdminId")
  639. if adminId <= 0 {
  640. br.Msg = "请传入对应的人员"
  641. return
  642. }
  643. //正式客户
  644. var condition string
  645. var pars []interface{}
  646. condition = ` and a.start_date >= ? and a.end_date <= ? `
  647. pars = append(pars, startDate, endDate)
  648. //选择的人员类型(发起人还是被发起人)
  649. if adminType == "seller" {
  650. condition += ` and a.seller_id = ? `
  651. } else if adminType == "special" {
  652. condition += ` and a.seller_id = ? `
  653. detail, err := company.GetConfigDetailByCode("choice_researcher_adminid")
  654. if err != nil {
  655. br.Msg = "获取研究员信息失败!"
  656. br.ErrMsg = "选择研究员失败,Err:" + err.Error()
  657. return
  658. }
  659. condition += ` and a.researcher_id IN (` + detail.ConfigValue + `) `
  660. } else {
  661. condition += ` and a.researcher_id = ? `
  662. }
  663. pars = append(pars, adminId)
  664. //获取列表
  665. switch dataType {
  666. case "try_out":
  667. condition += ` and a.company_status = ? `
  668. pars = append(pars, "试用")
  669. case "formal":
  670. condition += ` and a.company_status = ? `
  671. pars = append(pars, "正式")
  672. case "meeting":
  673. condition += ` and a.activity_type = ? `
  674. pars = append(pars, "公开会议")
  675. case "online":
  676. condition += ` and a.roadshow_type = ? `
  677. pars = append(pars, "线上")
  678. case "offline":
  679. condition += ` and a.roadshow_type = ? `
  680. pars = append(pars, "线下")
  681. case "road_show":
  682. condition += ` and a.activity_type = ? `
  683. pars = append(pars, "路演")
  684. case "salon":
  685. condition += ` and a.activity_type = ? `
  686. pars = append(pars, "沙龙")
  687. default:
  688. br.Msg = "请传入类型"
  689. br.ErrMsg = "请传入类型DataType"
  690. return
  691. }
  692. list, err := roadshow.GetRsReportRecordList(condition, pars)
  693. if err != nil {
  694. br.Msg = "获取失败"
  695. br.ErrMsg = "获取失败,ERR:" + err.Error()
  696. return
  697. }
  698. br.Ret = 200
  699. br.Success = true
  700. br.Msg = "获取成功"
  701. br.Data = list
  702. return
  703. }
  704. // ChoiceResearcher
  705. // @Title 选择的研究员
  706. // @Description 选择的研究员接口
  707. // @Param AdminIds query string true "研究员ID ,多个用 , 隔开"
  708. // @Success 200 操作成功
  709. // @router /report/choice/researcher [post]
  710. func (this *CalendarController) ChoiceResearcher() {
  711. br := new(models.BaseResponse).Init()
  712. defer func() {
  713. this.Data["json"] = br
  714. this.ServeJSON()
  715. }()
  716. sysUser := this.SysUser
  717. if sysUser == nil {
  718. br.Msg = "请登录"
  719. br.ErrMsg = "请登录,SysUser Is Empty"
  720. br.Ret = 408
  721. return
  722. }
  723. var req roadshow.ResearcherIds
  724. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  725. if err != nil {
  726. br.Msg = "参数解析异常!"
  727. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  728. return
  729. }
  730. if req.AdminIds == "" {
  731. req.AdminIds = "0"
  732. }
  733. adminIdArr := strings.Split(req.AdminIds, ",")
  734. for _, v := range adminIdArr {
  735. _, err := strconv.Atoi(v)
  736. if err != nil {
  737. br.Msg = "选择研究员失败!"
  738. br.ErrMsg = "选择研究员失败,Err:" + err.Error()
  739. return
  740. }
  741. }
  742. err = company.CrmConfigUpdate(req.AdminIds, "choice_researcher_adminid")
  743. if err != nil {
  744. br.Msg = "操作失败"
  745. br.ErrMsg = "操作失败,Err:" + err.Error()
  746. return
  747. }
  748. br.Ret = 200
  749. br.Success = true
  750. br.Msg = "操作成功"
  751. return
  752. }
  753. // AdminList
  754. // @Title 选择的研究员列表
  755. // @Description 获取选择的研究员列表
  756. // @Success 200 {object} roadshow.Researcher
  757. // @Success 200 操作成功
  758. // @router /report/admin/list [get]
  759. func (this *CalendarController) AdminList() {
  760. br := new(models.BaseResponse).Init()
  761. defer func() {
  762. this.Data["json"] = br
  763. this.ServeJSON()
  764. }()
  765. sysUser := this.SysUser
  766. if sysUser == nil {
  767. br.Msg = "请登录"
  768. br.ErrMsg = "请登录,SysUser Is Empty"
  769. br.Ret = 408
  770. return
  771. }
  772. detail, err := company.GetConfigDetailByCode("choice_researcher_adminid")
  773. if err != nil {
  774. br.Msg = "获取研究员信息失败!"
  775. br.ErrMsg = "选择研究员失败,Err:" + err.Error()
  776. return
  777. }
  778. list, err := roadshow.GetChoiceResearcher(detail.ConfigValue)
  779. if err != nil {
  780. br.Msg = "操作失败"
  781. br.ErrMsg = "操作失败,Err:" + err.Error()
  782. return
  783. }
  784. br.Ret = 200
  785. br.Success = true
  786. br.Msg = "操作成功"
  787. br.Data = list
  788. return
  789. }
  790. // SellerReportList
  791. // @Title 专项路演统计
  792. // @Description 专项路演统计接口
  793. // @Success 200 {object} roadshow.RsReportRecordResp
  794. // @router /report/special/list [get]
  795. func (this *CalendarController) SpecialReportList() {
  796. br := new(models.BaseResponse).Init()
  797. defer func() {
  798. this.Data["json"] = br
  799. this.ServeJSON()
  800. }()
  801. sysUser := this.SysUser
  802. if sysUser == nil {
  803. br.Msg = "请登录"
  804. br.ErrMsg = "请登录,SysUser Is Empty"
  805. br.Ret = 408
  806. return
  807. }
  808. dimensionType := this.GetString("DimensionType")
  809. if dimensionType == "" {
  810. dimensionType = "seller_special"
  811. }
  812. var adminDataList []roadshowService.AdminDataMap
  813. var err error
  814. var firstDate time.Time
  815. //获取列表
  816. adminDataList, firstDate, err = roadshowService.GetWeekData("seller", dimensionType)
  817. if err != nil {
  818. br.Msg = "数据异常"
  819. br.ErrMsg = "数据异常,Err:" + err.Error()
  820. return
  821. }
  822. var haveData bool
  823. detail, err := company.GetConfigDetailByCode("choice_researcher_adminid")
  824. if err != nil {
  825. br.Msg = "获取信息失败!"
  826. br.ErrMsg = "获取选择研究员信息失败,Err:" + err.Error()
  827. return
  828. }
  829. adminMap := make(map[int]int)
  830. adminIdArr := strings.Split(detail.ConfigValue, ",")
  831. for _, v := range adminIdArr {
  832. adminId, err := strconv.Atoi(v)
  833. if err != nil {
  834. br.Msg = "获取信息失败!"
  835. br.ErrMsg = "获取选择研究员信息失败,Err:" + err.Error()
  836. return
  837. }
  838. adminMap[adminId] = adminId
  839. }
  840. group, groupIdRelationMap, err := services.GetFiccSystemGroup()
  841. if err != nil {
  842. br.Msg = "获取信息失败!"
  843. br.ErrMsg = "获取分组信息失败!Err:" + err.Error()
  844. return
  845. }
  846. researcherList, err := services.GetFiccSeller(firstDate, groupIdRelationMap)
  847. groupMap := make(map[int][]*roadshow.Researcher)
  848. for _, v := range researcherList {
  849. //if v.RoleTypeCode == "ficc_admin" {
  850. // findItems := groupMap[1]
  851. // findItems = append(findItems, v)
  852. // groupMap[1] = findItems
  853. //} else {
  854. if findItems, ok := groupMap[v.GroupId]; ok {
  855. findItems = append(findItems, v)
  856. groupMap[v.GroupId] = findItems
  857. } else {
  858. findItems = append(findItems, v)
  859. groupMap[v.GroupId] = findItems
  860. }
  861. //}
  862. }
  863. groupReportRecordList := make([]roadshow.GroupReportRecord, 0)
  864. rsAllReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  865. RsReportRecordResp := roadshow.RsReportRecordResp{
  866. List: groupReportRecordList,
  867. RsReportRecordNumList: rsAllReportRecordNumList,
  868. }
  869. startDateIndexList := make(map[int]string) //开始时间间隔map
  870. endDateIndexList := make(map[int]string) //结束时间间隔map
  871. tmpAllTryOutNumMap := make(map[int]int)
  872. tmpAllFormalNumMap := make(map[int]int)
  873. tmpAllMeetingNumMap := make(map[int]int)
  874. tmpAllOnlineNumMap := make(map[int]int)
  875. tmpAllOfflineNumMap := make(map[int]int)
  876. for _, v := range group {
  877. v.ResearcherList = groupMap[v.GroupId]
  878. tmpGroupAdminReportRecord := make([]roadshow.AdminReportRecord, 0)
  879. tmpGroupRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  880. tmpGroupTryOutNumMap := make(map[int]int)
  881. tmpGroupFormalNumMap := make(map[int]int)
  882. tmpGroupMeetingNumMap := make(map[int]int)
  883. tmpGroupOnlineNumMap := make(map[int]int)
  884. tmpGroupOfflineNumMap := make(map[int]int)
  885. for _, researcher := range groupMap[v.GroupId] {
  886. //组内研究员数据
  887. var isLook bool
  888. //如果是管理员或者本组的可以查看详情
  889. if sysUser.GroupId == v.GroupId || sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_ADMIN {
  890. isLook = true
  891. }
  892. //每个区间的数据
  893. tmpAdminRsReportRecordNumList := make([]roadshow.RsReportRecordNum, 0)
  894. var isAppend bool
  895. for index, adminData := range adminDataList {
  896. startDateIndexList[index] = adminData.StartDate
  897. endDateIndexList[index] = adminData.EndDate
  898. var tmpTryOutNum, tmpFormalNum, tmpMeetingNum, tmpOnlineNum, tmpOfflineNum int
  899. if num, ok := adminData.TryOutMap[researcher.AdminId]; ok {
  900. tmpTryOutNum = num
  901. }
  902. if num, ok := adminData.FormalMap[researcher.AdminId]; ok {
  903. tmpFormalNum = num
  904. }
  905. if num, ok := adminData.MeetingMap[researcher.AdminId]; ok {
  906. tmpMeetingNum = num
  907. }
  908. if num, ok := adminData.OnlineMap[researcher.AdminId]; ok {
  909. tmpOnlineNum = num
  910. }
  911. if num, ok := adminData.OfflineMap[researcher.AdminId]; ok {
  912. tmpOfflineNum = num
  913. }
  914. tmpAdminRsReportRecordNum := roadshow.RsReportRecordNum{
  915. TryOutNum: tmpTryOutNum,
  916. FormalNum: tmpFormalNum,
  917. MeetingNum: tmpMeetingNum,
  918. OnlineNum: tmpOnlineNum,
  919. OfflineNum: tmpOfflineNum,
  920. StartDate: adminData.StartDate,
  921. EndDate: adminData.EndDate,
  922. IsLook: isLook,
  923. }
  924. if tmpTryOutNum > 0 || tmpFormalNum > 0 || tmpMeetingNum > 0 || tmpOnlineNum > 0 || tmpOfflineNum > 0 {
  925. isAppend = true
  926. haveData = true
  927. }
  928. tmpAdminRsReportRecordNumList = append(tmpAdminRsReportRecordNumList, tmpAdminRsReportRecordNum)
  929. //组内数据汇总
  930. if _, ok := tmpGroupTryOutNumMap[index]; !ok {
  931. tmpGroupTryOutNumMap[index] = 0
  932. }
  933. if _, ok := tmpGroupFormalNumMap[index]; !ok {
  934. tmpGroupFormalNumMap[index] = 0
  935. }
  936. if _, ok := tmpGroupMeetingNumMap[index]; !ok {
  937. tmpGroupMeetingNumMap[index] = 0
  938. }
  939. if _, ok := tmpGroupOnlineNumMap[index]; !ok {
  940. tmpGroupOnlineNumMap[index] = 0
  941. }
  942. if _, ok := tmpGroupOfflineNumMap[index]; !ok {
  943. tmpGroupOfflineNumMap[index] = 0
  944. }
  945. tmpGroupTryOutNumMap[index] += tmpTryOutNum
  946. tmpGroupFormalNumMap[index] += tmpFormalNum
  947. tmpGroupMeetingNumMap[index] += tmpMeetingNum
  948. tmpGroupOnlineNumMap[index] += tmpOnlineNum
  949. tmpGroupOfflineNumMap[index] += tmpOfflineNum
  950. //总数据汇总
  951. if _, ok := tmpAllTryOutNumMap[index]; !ok {
  952. tmpAllTryOutNumMap[index] = 0
  953. }
  954. if _, ok := tmpAllFormalNumMap[index]; !ok {
  955. tmpAllFormalNumMap[index] = 0
  956. }
  957. if _, ok := tmpAllMeetingNumMap[index]; !ok {
  958. tmpAllMeetingNumMap[index] = 0
  959. }
  960. if _, ok := tmpAllOnlineNumMap[index]; !ok {
  961. tmpAllOnlineNumMap[index] = 0
  962. }
  963. if _, ok := tmpAllOfflineNumMap[index]; !ok {
  964. tmpAllOfflineNumMap[index] = 0
  965. }
  966. tmpAllTryOutNumMap[index] += tmpTryOutNum
  967. tmpAllFormalNumMap[index] += tmpFormalNum
  968. tmpAllMeetingNumMap[index] += tmpMeetingNum
  969. tmpAllOnlineNumMap[index] += tmpOnlineNum
  970. tmpAllOfflineNumMap[index] += tmpOfflineNum
  971. }
  972. tmpAdminReportRecord := roadshow.AdminReportRecord{
  973. Name: researcher.RealName,
  974. AdminId: researcher.AdminId,
  975. RsReportRecordNumList: tmpAdminRsReportRecordNumList,
  976. }
  977. if isAppend {
  978. tmpGroupAdminReportRecord = append(tmpGroupAdminReportRecord, tmpAdminReportRecord)
  979. }
  980. }
  981. for i := 0; i < len(tmpGroupMeetingNumMap); i++ {
  982. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  983. TryOutNum: tmpGroupTryOutNumMap[i],
  984. FormalNum: tmpGroupFormalNumMap[i],
  985. MeetingNum: tmpGroupMeetingNumMap[i],
  986. OnlineNum: tmpGroupOnlineNumMap[i],
  987. OfflineNum: tmpGroupOfflineNumMap[i],
  988. StartDate: startDateIndexList[i],
  989. EndDate: endDateIndexList[i],
  990. }
  991. tmpGroupRsReportRecordNumList = append(tmpGroupRsReportRecordNumList, tmpGroupRsReportRecordNum)
  992. }
  993. groupReportRecord := roadshow.GroupReportRecord{
  994. Item: tmpGroupAdminReportRecord,
  995. Name: v.GroupName,
  996. GruopId: v.GroupId,
  997. RsReportRecordNumList: tmpGroupRsReportRecordNumList,
  998. }
  999. if len(tmpGroupAdminReportRecord) > 0 {
  1000. groupReportRecordList = append(groupReportRecordList, groupReportRecord)
  1001. }
  1002. }
  1003. //总体汇总数据
  1004. for i := 0; i < len(tmpAllFormalNumMap); i++ {
  1005. tmpGroupRsReportRecordNum := roadshow.RsReportRecordNum{
  1006. TryOutNum: tmpAllTryOutNumMap[i],
  1007. FormalNum: tmpAllFormalNumMap[i],
  1008. MeetingNum: tmpAllMeetingNumMap[i],
  1009. OnlineNum: tmpAllOnlineNumMap[i],
  1010. OfflineNum: tmpAllOfflineNumMap[i],
  1011. StartDate: startDateIndexList[i],
  1012. EndDate: endDateIndexList[i],
  1013. }
  1014. rsAllReportRecordNumList = append(rsAllReportRecordNumList, tmpGroupRsReportRecordNum)
  1015. }
  1016. RsReportRecordResp.RsReportRecordNumList = rsAllReportRecordNumList
  1017. tmpList := groupReportRecordList
  1018. //因为RoleTypeCode不一样,所以需要重新从数据库取数据
  1019. adminInfo, _ := system.GetSysAdminById(sysUser.AdminId)
  1020. adminGroupId := adminInfo.GroupId
  1021. if tmpGroupId, ok := groupIdRelationMap[adminGroupId]; ok {
  1022. adminGroupId = tmpGroupId
  1023. }
  1024. switch adminInfo.RoleTypeCode {
  1025. case utils.ROLE_TYPE_CODE_FICC_GROUP, utils.ROLE_TYPE_CODE_FICC_TEAM:
  1026. for index, v := range tmpList {
  1027. //如果不是同一个分组,那么就移除该分组下的人员数据
  1028. if v.GruopId != adminGroupId {
  1029. tmpList[index].Item = make([]roadshow.AdminReportRecord, 0)
  1030. }
  1031. }
  1032. RsReportRecordResp.List = tmpList
  1033. case utils.ROLE_TYPE_CODE_FICC_ADMIN, utils.ROLE_TYPE_CODE_ADMIN:
  1034. //管理员、超管看全部数据
  1035. RsReportRecordResp.List = groupReportRecordList
  1036. }
  1037. //判断是否有数据如果没有,处理数据为空
  1038. if !haveData {
  1039. RsReportRecordResp = roadshow.RsReportRecordResp{
  1040. List: make([]roadshow.GroupReportRecord, 0),
  1041. RsReportRecordNumList: make([]roadshow.RsReportRecordNum, 0),
  1042. }
  1043. }
  1044. br.Ret = 200
  1045. br.Success = true
  1046. br.Msg = "获取成功"
  1047. br.Data = RsReportRecordResp
  1048. return
  1049. }
  1050. // ResearcherReportList
  1051. // @Title 研究员出差表
  1052. // @Description 研究员出差表接口
  1053. // @Param AdminId query int true "研究员id"
  1054. // @Param WeekQuery query int false "周查询: 0-本期(本周及下周); 1-前两周; 2-后两周"
  1055. // @Param BaseQueryDate query string false "周查询时的开始日期"
  1056. // @Success 200 {object} roadshow.BusinessTripResp
  1057. // @router /report/researcher/business_trip [get]
  1058. func (this *CalendarController) ResearcherBusinessTrip() {
  1059. br := new(models.BaseResponse).Init()
  1060. defer func() {
  1061. this.Data["json"] = br
  1062. this.ServeJSON()
  1063. }()
  1064. sysUser := this.SysUser
  1065. if sysUser == nil {
  1066. br.Msg = "请登录"
  1067. br.ErrMsg = "请登录,SysUser Is Empty"
  1068. br.Ret = 408
  1069. return
  1070. }
  1071. adminId, _ := this.GetInt("AdminId")
  1072. weekQuery, _ := this.GetInt("WeekQuery")
  1073. baseQueryDate := this.GetString("BaseQueryDate")
  1074. //fmt.Println(adminId)
  1075. group, err := roadshow.GetResearcherGroup()
  1076. if err != nil {
  1077. br.Msg = "获取信息失败!"
  1078. br.ErrMsg = "获取分组信息失败!Err:" + err.Error()
  1079. return
  1080. }
  1081. researcherList, err := roadshow.GetBusinessTripResearcher()
  1082. if err != nil {
  1083. br.Msg = "获取信息失败!"
  1084. br.ErrMsg = "获取分组信息失败!,GetBusinessTripResearcher Err:" + err.Error()
  1085. return
  1086. }
  1087. ////获取当天周日期
  1088. //nowWeekStart := utils.GetNowWeekMonday().AddDate(0, 0, -2)
  1089. ////nowWeekEnd := utils.GetNowWeekLastDay()
  1090. ////获取下周日期
  1091. //nextWeekStart := utils.GetNextWeekMonday().AddDate(0, 0, -2)
  1092. //nextWeekEnd := utils.GetNextWeekLastDay().AddDate(0, 0, -2)
  1093. var nowWeekStart time.Time
  1094. if baseQueryDate == "" {
  1095. now := time.Now()
  1096. weekDay := int(now.Weekday())
  1097. if weekDay == 6 {
  1098. nowWeekStart, _ = time.ParseInLocation(utils.FormatDate, now.Format(utils.FormatDate), time.Local)
  1099. } else {
  1100. nowWeekStart, _ = time.ParseInLocation(utils.FormatDate, now.AddDate(0, 0, -(weekDay+1)).Format(utils.FormatDate), time.Local)
  1101. }
  1102. }
  1103. // 查询需求是可以无限往前后两周查询, 以入参为本周开始日期
  1104. if baseQueryDate != "" {
  1105. t, e := time.ParseInLocation(utils.FormatDate, baseQueryDate, time.Local)
  1106. if e != nil {
  1107. br.Msg = "查询开始日期格式有误"
  1108. return
  1109. }
  1110. nowWeekStart = t
  1111. }
  1112. // 前/后两周
  1113. if weekQuery == 1 {
  1114. nowWeekStart = nowWeekStart.AddDate(0, 0, -14)
  1115. }
  1116. if weekQuery == 2 {
  1117. nowWeekStart = nowWeekStart.AddDate(0, 0, +14)
  1118. }
  1119. //nowWeekEnd := utils.GetNowWeekLastDay()
  1120. //获取下周日期
  1121. nextWeekStart := nowWeekStart.AddDate(0, 0, +7)
  1122. nextWeekEnd := nowWeekStart.AddDate(0, 0, +13)
  1123. //获取路演信息
  1124. roadshowList, err := roadshow.GetBusinessTripList(adminId, nowWeekStart.Format(utils.FormatDate), nextWeekEnd.Format(utils.FormatDateTime))
  1125. if err != nil {
  1126. br.Msg = "获取信息失败!"
  1127. br.ErrMsg = "获取路演信息失败!,GetBusinessTripList Err:" + err.Error()
  1128. return
  1129. }
  1130. roadshowMap := make(map[int][]*roadshow.BusinessTripResearcherList)
  1131. for _, v := range roadshowList {
  1132. if findVals, ok := roadshowMap[v.ResearcherId]; ok {
  1133. findVals = append(findVals, v)
  1134. roadshowMap[v.ResearcherId] = findVals
  1135. } else {
  1136. roadsItems := make([]*roadshow.BusinessTripResearcherList, 0)
  1137. roadsItems = append(roadsItems, v)
  1138. roadshowMap[v.ResearcherId] = roadsItems
  1139. }
  1140. }
  1141. //fmt.Println("roadshow json start")
  1142. //jsonBody, err := json.Marshal(roadshowMap)
  1143. //fmt.Println("json body:" + string(jsonBody))
  1144. //fmt.Println("roadshow json end")
  1145. groupMap := make(map[int][]*roadshow.BusinessTripResearcher)
  1146. for _, v := range researcherList {
  1147. if findRoadshowList, ok := roadshowMap[v.AdminId]; ok {
  1148. tripList := make([]*roadshow.BusinessTrip, 0)
  1149. researcherMap := make(map[string]string)
  1150. for i := 0; i < 7; i++ {
  1151. newDay, _ := time.ParseInLocation(utils.FormatDate, nowWeekStart.AddDate(0, 0, i).Format(utils.FormatDate), time.Local)
  1152. weekDate := newDay.Format(utils.FormatDate)
  1153. tripItem := new(roadshow.BusinessTrip)
  1154. for _, r := range findRoadshowList {
  1155. startDateT, _ := time.ParseInLocation(utils.FormatDate, r.StartDate, time.Local)
  1156. endDateT, _ := time.ParseInLocation(utils.FormatDate, r.EndDate, time.Local)
  1157. if int(endDateT.Sub(startDateT)) <= 0 {
  1158. skey := strconv.Itoa(r.ResearcherId) + r.StartDate
  1159. if _, sok := researcherMap[skey]; !sok {
  1160. if r != nil && (newDay.Equal(startDateT) || (newDay.Equal(endDateT)) || (newDay.Before(endDateT) && newDay.After(startDateT))) {
  1161. tripItem.City = r.City
  1162. researcherMap[skey] = skey
  1163. }
  1164. }
  1165. } else {
  1166. if r != nil && (newDay.Equal(startDateT) || (newDay.Equal(endDateT)) || (newDay.Before(endDateT) && newDay.After(startDateT))) {
  1167. tripItem.City = r.City
  1168. //researcherMap[skey] = skey
  1169. }
  1170. }
  1171. }
  1172. tripItem.WeekDate = weekDate
  1173. tripItem.WeekType = "current"
  1174. tripItem.Week = newDay.Weekday().String()
  1175. tripList = append(tripList, tripItem)
  1176. }
  1177. for i := 0; i < 7; i++ {
  1178. newDay := nextWeekStart.AddDate(0, 0, i)
  1179. weekDate := newDay.Format(utils.FormatDate)
  1180. tripItem := new(roadshow.BusinessTrip)
  1181. for _, r := range findRoadshowList {
  1182. startDateT, _ := time.ParseInLocation(utils.FormatDate, r.StartDate, time.Local)
  1183. endDateT, _ := time.ParseInLocation(utils.FormatDate, r.EndDate, time.Local)
  1184. if int(endDateT.Sub(startDateT)) <= 0 {
  1185. skey := strconv.Itoa(r.ResearcherId) + r.StartDate
  1186. if _, sok := researcherMap[skey]; !sok {
  1187. if r != nil && (newDay.Equal(startDateT) || (newDay.Equal(endDateT)) || (newDay.Before(endDateT) && newDay.After(startDateT))) {
  1188. tripItem.City = r.City
  1189. researcherMap[skey] = skey
  1190. }
  1191. }
  1192. } else {
  1193. if r != nil && (newDay.Equal(startDateT) || (newDay.Equal(endDateT)) || (newDay.Before(endDateT) && newDay.After(startDateT))) {
  1194. tripItem.City = r.City
  1195. //researcherMap[skey] = skey
  1196. }
  1197. }
  1198. }
  1199. tripItem.WeekDate = weekDate
  1200. tripItem.WeekType = "next"
  1201. tripItem.Week = newDay.Weekday().String()
  1202. tripList = append(tripList, tripItem)
  1203. }
  1204. v.BusinessTripList = tripList
  1205. //if v.RoleTypeCode == "ficc_admin" {
  1206. // findItems := groupMap[1]
  1207. // findItems = append(findItems, v)
  1208. // groupMap[1] = findItems
  1209. //} else {
  1210. if findItems, ok := groupMap[v.GroupId]; ok {
  1211. findItems = append(findItems, v)
  1212. groupMap[v.GroupId] = findItems
  1213. } else {
  1214. findItems = append(findItems, v)
  1215. groupMap[v.GroupId] = findItems
  1216. }
  1217. //}
  1218. }
  1219. }
  1220. groupList := make([]*roadshow.BusinessTripGroup, 0)
  1221. for _, v := range group {
  1222. item := new(roadshow.BusinessTripGroup)
  1223. item.GroupName = v.GroupName
  1224. item.GroupId = v.GroupId
  1225. item.ResearcherList = groupMap[v.GroupId]
  1226. groupList = append(groupList, item)
  1227. }
  1228. resp := new(roadshow.BusinessTripResp)
  1229. resp.GroupList = groupList
  1230. resp.BaseDate = nowWeekStart.Format(utils.FormatDate)
  1231. br.Ret = 200
  1232. br.Success = true
  1233. br.Msg = "获取成功"
  1234. br.Data = resp
  1235. return
  1236. }
  1237. // OverseasCustomReportCalendarList
  1238. // @Title 路演详情列表
  1239. // @Description 路演详情列表接口
  1240. // @Param Keyword query string true "关键字:客户名称"
  1241. // @Param CompanyStatus query string true "客户状态,枚举值:正式、试用、关闭"
  1242. // @Param SellerId query int true "销售id列表;多个用英文,分割"
  1243. // @Param ResearcherId query int true "销售id列表;多个用英文,分割"
  1244. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  1245. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  1246. // @Param SortField query string false "排序字段:start_date"
  1247. // @Param SortDesc query int false "1:降序,默认,2:升序"
  1248. // @Success 200 {object} []roadshow.RsReportRecordList
  1249. // @router /overseas_custom/calendar/list [get]
  1250. func (this *CalendarController) OverseasCustomReportCalendarList() {
  1251. br := new(models.BaseResponse).Init()
  1252. defer func() {
  1253. this.Data["json"] = br
  1254. this.ServeJSON()
  1255. }()
  1256. sysUser := this.SysUser
  1257. if sysUser == nil {
  1258. br.Msg = "请登录"
  1259. br.ErrMsg = "请登录,SysUser Is Empty"
  1260. br.Ret = 408
  1261. return
  1262. }
  1263. keyword := this.GetString("Keyword")
  1264. companyStatus := this.GetString("CompanyStatus")
  1265. startDate := this.GetString("StartDate")
  1266. endDate := this.GetString("EndDate")
  1267. sellerId := this.GetString("SellerId")
  1268. researcherId := this.GetString("ResearcherId")
  1269. pageSize, _ := this.GetInt("PageSize")
  1270. currentIndex, _ := this.GetInt("CurrentIndex")
  1271. sortField := this.GetString("SortField")
  1272. sortDesc, _ := this.GetInt("SortDesc")
  1273. var startSize int
  1274. if pageSize <= 0 {
  1275. pageSize = utils.PageSize20
  1276. }
  1277. if currentIndex <= 0 {
  1278. currentIndex = 1
  1279. }
  1280. startSize = paging.StartIndex(currentIndex, pageSize)
  1281. switch sortField {
  1282. case "start_date":
  1283. default:
  1284. sortField = "start_date"
  1285. }
  1286. // "1:降序,默认,2:升序"
  1287. sortDesStr := ` desc `
  1288. switch sortDesc {
  1289. case 2:
  1290. sortDesStr = ` asc `
  1291. default:
  1292. sortDesStr = "desc"
  1293. }
  1294. total, list, err := roadshow.GetOverseaCustomCalendarList(keyword, sellerId, researcherId, startDate, endDate, companyStatus, sortField, sortDesStr, startSize, pageSize)
  1295. if err != nil {
  1296. br.Msg = "获取失败"
  1297. br.ErrMsg = "获取失败,ERR:" + err.Error()
  1298. return
  1299. }
  1300. page := paging.GetPaging(currentIndex, pageSize, total)
  1301. resp := new(roadshow.OverseaCustomRecordInfoResp)
  1302. resp.Paging = page
  1303. resp.List = list
  1304. br.Ret = 200
  1305. br.Success = true
  1306. br.Msg = "获取成功"
  1307. br.Data = resp
  1308. return
  1309. }
  1310. // OverseasCustomCalendarAdminList
  1311. // @Title 海外客户路演用户列表接口
  1312. // @Description 海外客户路演用户列表接口
  1313. // @Param AdminType query string true "枚举值:researcher、seller"
  1314. // @Success 200 {object} []roadshow.AdminInfo
  1315. // @router /overseas_custom/sys_user/list [get]
  1316. func (this *CalendarController) OverseasCustomCalendarAdminList() {
  1317. br := new(models.BaseResponse).Init()
  1318. defer func() {
  1319. this.Data["json"] = br
  1320. this.ServeJSON()
  1321. }()
  1322. sysUser := this.SysUser
  1323. if sysUser == nil {
  1324. br.Msg = "请登录"
  1325. br.ErrMsg = "请登录,SysUser Is Empty"
  1326. br.Ret = 408
  1327. return
  1328. }
  1329. adminType := this.GetString("AdminType")
  1330. var list []*roadshow.AdminInfo
  1331. var err error
  1332. //选择的人员类型(发起人还是被发起人)
  1333. if adminType == "seller" {
  1334. list, err = roadshow.GetOverseaCustomCalendarSellerList()
  1335. } else if adminType == "researcher" {
  1336. list, err = roadshow.GetOverseaCustomCalendarResearcherList()
  1337. } else {
  1338. br.Msg = "错误的类型"
  1339. br.IsSendEmail = false
  1340. }
  1341. if err != nil {
  1342. br.Msg = "获取失败"
  1343. br.ErrMsg = "获取失败,ERR:" + err.Error()
  1344. return
  1345. }
  1346. br.Ret = 200
  1347. br.Success = true
  1348. br.Msg = "获取成功"
  1349. br.Data = list
  1350. return
  1351. }
  1352. // OverseasSellerReportList
  1353. // @Title 海外客户销售路演统计
  1354. // @Description 海外客户销售路演统计接口
  1355. // @Param DataType query string true "枚举值:week、month、time_interval、online、offline"
  1356. // @Param DimensionType query string true "维度枚举值:company_status、roadshow_type"
  1357. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  1358. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  1359. // @Success 200 {object} roadshow.RsReportRecordResp
  1360. // @router /overseas_custom/seller/list [get]
  1361. func (this *CalendarController) OverseasSellerReportList() {
  1362. br := new(models.BaseResponse).Init()
  1363. defer func() {
  1364. this.Data["json"] = br
  1365. this.ServeJSON()
  1366. }()
  1367. sysUser := this.SysUser
  1368. if sysUser == nil {
  1369. br.Msg = "请登录"
  1370. br.ErrMsg = "请登录,SysUser Is Empty"
  1371. br.Ret = 408
  1372. return
  1373. }
  1374. dataType := this.GetString("DataType")
  1375. dimensionType := this.GetString("DimensionType")
  1376. startDate := this.GetString("StartDate")
  1377. endDate := this.GetString("EndDate")
  1378. if dimensionType == "" {
  1379. dimensionType = "company_status"
  1380. }
  1381. var adminDataList []roadshowService.OverseasAdminDataMap
  1382. var err error
  1383. //获取列表
  1384. switch dataType {
  1385. case "week":
  1386. adminDataList, _, err = roadshowService.GetOverseasWeekDataV2("seller", dimensionType, 6)
  1387. if err != nil {
  1388. br.Msg = "数据异常"
  1389. br.ErrMsg = "数据异常,Err:" + err.Error()
  1390. return
  1391. }
  1392. case "month":
  1393. adminDataList, _, err = roadshowService.GetOverseasMonthDataV2("seller", dimensionType, 6)
  1394. if err != nil {
  1395. br.Msg = "数据异常"
  1396. br.ErrMsg = "数据异常,Err:" + err.Error()
  1397. return
  1398. }
  1399. case "time_interval":
  1400. if startDate == `` || endDate == `` {
  1401. br.Msg = "开始日期或结束日期不能为空"
  1402. br.ErrMsg = "开始日期或结束日期不能为空,Err:" + err.Error()
  1403. return
  1404. }
  1405. adminDataList, _, err = roadshowService.GetOverseasTimeIntervalData(startDate, endDate, "seller", dimensionType)
  1406. if err != nil {
  1407. br.Msg = "数据异常"
  1408. br.ErrMsg = "数据异常,Err:" + err.Error()
  1409. return
  1410. }
  1411. }
  1412. sellerList, err := roadshow.GetOverseaCustomCalendarSellerList()
  1413. adminReportRecordList := make([]roadshow.OverseasAdminReportRecord, 0)
  1414. rsAllReportRecordNumList := make([]roadshow.RsOverseasReportRecordNum, 0)
  1415. RsReportRecordResp := roadshow.RsOverseasReportRecordResp{
  1416. List: adminReportRecordList,
  1417. RsReportRecordNumList: rsAllReportRecordNumList,
  1418. }
  1419. startDateIndexList := make(map[int]string) //开始时间间隔map
  1420. endDateIndexList := make(map[int]string) //结束时间间隔map
  1421. tmpAllTryOutNumMap := make(map[int]int)
  1422. tmpAllFormalNumMap := make(map[int]int)
  1423. tmpAllCloseNumMap := make(map[int]int)
  1424. tmpAllOnlineNumMap := make(map[int]int)
  1425. tmpAllOfflineNumMap := make(map[int]int)
  1426. for _, researcher := range sellerList {
  1427. //每个区间的数据
  1428. tmpAdminRsReportRecordNumList := make([]roadshow.RsOverseasReportRecordNum, 0)
  1429. for index, adminData := range adminDataList {
  1430. startDateIndexList[index] = adminData.StartDate
  1431. endDateIndexList[index] = adminData.EndDate
  1432. var tmpTryOutNum, tmpFormalNum, tmpCloseNum, tmpOnlineNum, tmpOfflineNum int
  1433. if num, ok := adminData.TryOutMap[researcher.AdminId]; ok {
  1434. tmpTryOutNum = num
  1435. }
  1436. if num, ok := adminData.FormalMap[researcher.AdminId]; ok {
  1437. tmpFormalNum = num
  1438. }
  1439. if num, ok := adminData.CloseMap[researcher.AdminId]; ok {
  1440. tmpCloseNum = num
  1441. }
  1442. if num, ok := adminData.OnlineMap[researcher.AdminId]; ok {
  1443. tmpOnlineNum = num
  1444. }
  1445. if num, ok := adminData.OfflineMap[researcher.AdminId]; ok {
  1446. tmpOfflineNum = num
  1447. }
  1448. tmpAdminRsReportRecordNum := roadshow.RsOverseasReportRecordNum{
  1449. TryOutNum: tmpTryOutNum,
  1450. FormalNum: tmpFormalNum,
  1451. CloseNum: tmpCloseNum,
  1452. OnlineNum: tmpOnlineNum,
  1453. OfflineNum: tmpOfflineNum,
  1454. StartDate: adminData.StartDate,
  1455. EndDate: adminData.EndDate,
  1456. }
  1457. tmpAdminRsReportRecordNumList = append(tmpAdminRsReportRecordNumList, tmpAdminRsReportRecordNum)
  1458. //总数据汇总
  1459. if _, ok := tmpAllTryOutNumMap[index]; !ok {
  1460. tmpAllTryOutNumMap[index] = 0
  1461. }
  1462. if _, ok := tmpAllFormalNumMap[index]; !ok {
  1463. tmpAllFormalNumMap[index] = 0
  1464. }
  1465. if _, ok := tmpAllCloseNumMap[index]; !ok {
  1466. tmpAllCloseNumMap[index] = 0
  1467. }
  1468. if _, ok := tmpAllOnlineNumMap[index]; !ok {
  1469. tmpAllOnlineNumMap[index] = 0
  1470. }
  1471. if _, ok := tmpAllOfflineNumMap[index]; !ok {
  1472. tmpAllOfflineNumMap[index] = 0
  1473. }
  1474. tmpAllTryOutNumMap[index] += tmpTryOutNum
  1475. tmpAllFormalNumMap[index] += tmpFormalNum
  1476. tmpAllCloseNumMap[index] += tmpCloseNum
  1477. tmpAllOnlineNumMap[index] += tmpOnlineNum
  1478. tmpAllOfflineNumMap[index] += tmpOfflineNum
  1479. }
  1480. // 数据都为0的时候不显示
  1481. adminTotalNum := 0
  1482. for _, v := range tmpAdminRsReportRecordNumList {
  1483. adminTotalNum += v.TryOutNum + v.CloseNum + v.FormalNum
  1484. }
  1485. if adminTotalNum > 0 {
  1486. tmpAdminReportRecord := roadshow.OverseasAdminReportRecord{
  1487. Name: researcher.RealName,
  1488. AdminId: researcher.AdminId,
  1489. RsReportRecordNumList: tmpAdminRsReportRecordNumList,
  1490. }
  1491. RsReportRecordResp.List = append(RsReportRecordResp.List, tmpAdminReportRecord)
  1492. }
  1493. }
  1494. //总体汇总数据
  1495. for i := 0; i < len(tmpAllFormalNumMap); i++ {
  1496. tmpGroupRsReportRecordNum := roadshow.RsOverseasReportRecordNum{
  1497. TryOutNum: tmpAllTryOutNumMap[i],
  1498. FormalNum: tmpAllFormalNumMap[i],
  1499. CloseNum: tmpAllCloseNumMap[i],
  1500. OnlineNum: tmpAllOnlineNumMap[i],
  1501. OfflineNum: tmpAllOfflineNumMap[i],
  1502. StartDate: startDateIndexList[i],
  1503. EndDate: endDateIndexList[i],
  1504. }
  1505. rsAllReportRecordNumList = append(rsAllReportRecordNumList, tmpGroupRsReportRecordNum)
  1506. }
  1507. RsReportRecordResp.RsReportRecordNumList = rsAllReportRecordNumList
  1508. br.Ret = 200
  1509. br.Success = true
  1510. br.Msg = "获取成功"
  1511. br.Data = RsReportRecordResp
  1512. return
  1513. }
  1514. // OverseasResearcherReportList
  1515. // @Title 研究员路演统计
  1516. // @Description 研究员路演统计接口
  1517. // @Param DataType query string true "枚举值:week、month、time_interval"
  1518. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  1519. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  1520. // @Success 200 {object} roadshow.RsReportRecordResp
  1521. // @router /overseas_custom/researcher/list [get]
  1522. func (this *CalendarController) OverseasResearcherReportList() {
  1523. br := new(models.BaseResponse).Init()
  1524. defer func() {
  1525. this.Data["json"] = br
  1526. this.ServeJSON()
  1527. }()
  1528. sysUser := this.SysUser
  1529. if sysUser == nil {
  1530. br.Msg = "请登录"
  1531. br.ErrMsg = "请登录,SysUser Is Empty"
  1532. br.Ret = 408
  1533. return
  1534. }
  1535. dataType := this.GetString("DataType")
  1536. startDate := this.GetString("StartDate")
  1537. endDate := this.GetString("EndDate")
  1538. var adminDataList []roadshowService.OverseasAdminDataMap
  1539. var err error
  1540. //var firstDate time.Time
  1541. //获取列表
  1542. switch dataType {
  1543. case "week":
  1544. adminDataList, _, err = roadshowService.GetOverseasWeekData("researcher", "company_status")
  1545. if err != nil {
  1546. br.Msg = "数据异常"
  1547. br.ErrMsg = "数据异常,Err:" + err.Error()
  1548. return
  1549. }
  1550. case "month":
  1551. adminDataList, _, err = roadshowService.GetOverseasMonthData("researcher", "company_status")
  1552. if err != nil {
  1553. br.Msg = "数据异常"
  1554. br.ErrMsg = "数据异常,Err:" + err.Error()
  1555. return
  1556. }
  1557. case "time_interval":
  1558. if startDate == `` || endDate == `` {
  1559. br.Msg = "开始日期或结束日期不能为空"
  1560. br.ErrMsg = "开始日期或结束日期不能为空,Err:" + err.Error()
  1561. return
  1562. }
  1563. adminDataList, _, err = roadshowService.GetOverseasTimeIntervalData(startDate, endDate, "researcher", "company_status")
  1564. if err != nil {
  1565. br.Msg = "数据异常"
  1566. br.ErrMsg = "数据异常,Err:" + err.Error()
  1567. return
  1568. }
  1569. }
  1570. researcherList, err := roadshow.GetOverseaCustomCalendarResearcherList()
  1571. if err != nil {
  1572. br.Msg = "获取信息失败!"
  1573. br.ErrMsg = "获取分组信息失败!,GetResearcherV2 Err:" + err.Error()
  1574. return
  1575. }
  1576. adminReportRecordList := make([]roadshow.OverseasAdminReportRecord, 0)
  1577. rsAllReportRecordNumList := make([]roadshow.RsOverseasReportRecordNum, 0)
  1578. RsReportRecordResp := roadshow.RsOverseasReportRecordResp{
  1579. List: adminReportRecordList,
  1580. RsReportRecordNumList: rsAllReportRecordNumList,
  1581. }
  1582. startDateIndexList := make(map[int]string) //开始时间间隔map
  1583. endDateIndexList := make(map[int]string) //结束时间间隔map
  1584. tmpAllTryOutNumMap := make(map[int]int)
  1585. tmpAllFormalNumMap := make(map[int]int)
  1586. tmpAllMeetingNumMap := make(map[int]int)
  1587. for _, researcher := range researcherList {
  1588. //组内研究员数据
  1589. //每个区间的数据
  1590. tmpAdminRsReportRecordNumList := make([]roadshow.RsOverseasReportRecordNum, 0)
  1591. for index, adminData := range adminDataList {
  1592. startDateIndexList[index] = adminData.StartDate
  1593. endDateIndexList[index] = adminData.EndDate
  1594. var tmpTryOutNum, tmpFormalNum, tmpCloseNum int
  1595. if num, ok := adminData.TryOutMap[researcher.AdminId]; ok {
  1596. tmpTryOutNum = num
  1597. }
  1598. if num, ok := adminData.FormalMap[researcher.AdminId]; ok {
  1599. tmpFormalNum = num
  1600. }
  1601. if num, ok := adminData.CloseMap[researcher.AdminId]; ok {
  1602. tmpCloseNum = num
  1603. }
  1604. tmpAdminRsReportRecordNum := roadshow.RsOverseasReportRecordNum{
  1605. TryOutNum: tmpTryOutNum,
  1606. FormalNum: tmpFormalNum,
  1607. CloseNum: tmpCloseNum,
  1608. StartDate: adminData.StartDate,
  1609. EndDate: adminData.EndDate,
  1610. }
  1611. tmpAdminRsReportRecordNumList = append(tmpAdminRsReportRecordNumList, tmpAdminRsReportRecordNum)
  1612. //总数据汇总
  1613. if _, ok := tmpAllTryOutNumMap[index]; !ok {
  1614. tmpAllTryOutNumMap[index] = 0
  1615. }
  1616. if _, ok := tmpAllFormalNumMap[index]; !ok {
  1617. tmpAllFormalNumMap[index] = 0
  1618. }
  1619. if _, ok := tmpAllMeetingNumMap[index]; !ok {
  1620. tmpAllMeetingNumMap[index] = 0
  1621. }
  1622. tmpAllTryOutNumMap[index] += tmpTryOutNum
  1623. tmpAllFormalNumMap[index] += tmpFormalNum
  1624. tmpAllMeetingNumMap[index] += tmpCloseNum
  1625. }
  1626. // 数据都为0的时候不显示
  1627. adminTotalNum := 0
  1628. for _, v := range tmpAdminRsReportRecordNumList {
  1629. adminTotalNum += v.TryOutNum + v.CloseNum + v.FormalNum
  1630. }
  1631. if adminTotalNum > 0 {
  1632. tmpAdminReportRecord := roadshow.OverseasAdminReportRecord{
  1633. Name: researcher.RealName,
  1634. AdminId: researcher.AdminId,
  1635. RsReportRecordNumList: tmpAdminRsReportRecordNumList,
  1636. }
  1637. RsReportRecordResp.List = append(RsReportRecordResp.List, tmpAdminReportRecord)
  1638. }
  1639. }
  1640. //总体汇总数据
  1641. for i := 0; i < len(tmpAllFormalNumMap); i++ {
  1642. tmpGroupRsReportRecordNum := roadshow.RsOverseasReportRecordNum{
  1643. TryOutNum: tmpAllTryOutNumMap[i],
  1644. FormalNum: tmpAllFormalNumMap[i],
  1645. CloseNum: tmpAllMeetingNumMap[i],
  1646. StartDate: startDateIndexList[i],
  1647. EndDate: endDateIndexList[i],
  1648. }
  1649. rsAllReportRecordNumList = append(rsAllReportRecordNumList, tmpGroupRsReportRecordNum)
  1650. }
  1651. RsReportRecordResp.RsReportRecordNumList = rsAllReportRecordNumList
  1652. br.Ret = 200
  1653. br.Success = true
  1654. br.Msg = "获取成功"
  1655. br.Data = RsReportRecordResp
  1656. return
  1657. }
  1658. // OverseasCalendarList
  1659. // @Title 海外客户路演详情列表
  1660. // @Description 海外客户路演详情列表接口
  1661. // @Param AdminType query string true "枚举值:researcher、seller、 special:专项路演"
  1662. // @Param DataType query string true "枚举值:try_out、formal、close、online、offline"
  1663. // @Param AdminIds query string true "用户ids"
  1664. // @Param StartDate query string true "开始日期,格式:2022-04-06"
  1665. // @Param EndDate query string true "结束日期,格式:2022-04-06"
  1666. // @Success 200 {object} []roadshow.RsReportRecordList
  1667. // @router /overseas/calendar/list [get]
  1668. func (this *CalendarController) OverseasCalendarList() {
  1669. br := new(models.BaseResponse).Init()
  1670. defer func() {
  1671. this.Data["json"] = br
  1672. this.ServeJSON()
  1673. }()
  1674. sysUser := this.SysUser
  1675. if sysUser == nil {
  1676. br.Msg = "请登录"
  1677. br.ErrMsg = "请登录,SysUser Is Empty"
  1678. br.Ret = 408
  1679. return
  1680. }
  1681. adminType := this.GetString("AdminType")
  1682. dataType := this.GetString("DataType")
  1683. startDate := this.GetString("StartDate")
  1684. endDate := this.GetString("EndDate")
  1685. adminIds := this.GetString("AdminIds")
  1686. if adminIds == "" {
  1687. br.Msg = "请传入对应的人员"
  1688. return
  1689. }
  1690. //adminIdsArr := make([]int, 0)
  1691. //adminIdSlice := strings.Split(adminIds, ",")
  1692. //for _, v := range adminIdSlice {
  1693. // id,_ := strconv.Atoi(v)
  1694. // adminIdsArr = append(adminIdsArr, id)
  1695. //}
  1696. //正式客户
  1697. //var condition string
  1698. //var pars []interface{}
  1699. //condition = ` and a.start_date >= ? and a.end_date <= ? `
  1700. //pars = append(pars, startDate, endDate)
  1701. var sellerIds, researcherIds string
  1702. //选择的人员类型(发起人还是被发起人)
  1703. if adminType == "seller" {
  1704. //condition += ` and a.seller_id IN (` + utils.GetOrmInReplace(len(adminIdsArr)) + `)`
  1705. sellerIds = adminIds
  1706. } else {
  1707. //condition += ` and a.researcher_id IN (` + utils.GetOrmInReplace(len(adminIdsArr)) + `)`
  1708. researcherIds = adminIds
  1709. }
  1710. //pars = append(pars, adminIdsArr)
  1711. var status string
  1712. //获取列表
  1713. switch dataType {
  1714. case "try_out":
  1715. //condition += ` and a.company_status = ? )`
  1716. //pars = append(pars, "试用")
  1717. status = "试用"
  1718. case "formal":
  1719. //condition += ` and a.company_status = ? )`
  1720. //pars = append(pars, "正式")
  1721. status = "正式"
  1722. case "close":
  1723. //condition += ` and a.company_status = ? )`
  1724. //pars = append(pars, "关闭")
  1725. status = "关闭"
  1726. //case "online":
  1727. // condition += ` and a.roadshow_type = ? `
  1728. // pars = append(pars, "线上")
  1729. //case "offline":
  1730. // condition += ` and a.roadshow_type = ? `
  1731. // pars = append(pars, "线下")
  1732. default:
  1733. br.Msg = "请传入类型"
  1734. br.ErrMsg = "请传入类型DataType"
  1735. return
  1736. }
  1737. list, err := roadshow.GetOverseaCustomCalendarList2(sellerIds, researcherIds, startDate, endDate, status)
  1738. if err != nil {
  1739. br.Msg = "获取失败"
  1740. br.ErrMsg = "获取失败,ERR:" + err.Error()
  1741. return
  1742. }
  1743. br.Ret = 200
  1744. br.Success = true
  1745. br.Msg = "获取成功"
  1746. br.Data = list
  1747. return
  1748. }