activity_signup.go 95 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057
  1. package cygx
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "github.com/rdlucklib/rdluck_tools/paging"
  6. "github.com/tealeg/xlsx"
  7. "hongze/hz_crm_api/controllers"
  8. "hongze/hz_crm_api/models"
  9. "hongze/hz_crm_api/models/cygx"
  10. "hongze/hz_crm_api/models/system"
  11. "hongze/hz_crm_api/services"
  12. cygxService "hongze/hz_crm_api/services/cygx"
  13. "hongze/hz_crm_api/utils"
  14. "html/template"
  15. "os"
  16. "path/filepath"
  17. "strconv"
  18. "strings"
  19. "time"
  20. )
  21. // 活动
  22. type ActivitySignupCoAntroller struct {
  23. controllers.BaseAuthController
  24. }
  25. // @Title 报名管理列表
  26. // @Description 获取报名管理列表接口
  27. // @Param PageSize query int true "每页数据条数"
  28. // @Param CurrentIndex query int true "当前页页码,从1开始"
  29. // @Param ChartPermissionId query string false "行业id"
  30. // @Param ActivityTypeId query string false "活动类型id 多个用 , 隔开列如: 1,2"
  31. // @Param StartDate query string false "开始时间 ,列如2021-03-06 "
  32. // @Param EndDate query string false "结束时间,列如2021-03-06 "
  33. // @Param KeyWord query string false "搜索关键词"
  34. // @Param SearchType query int true "筛选类型 1专家/分析师电话会、2专家/分析师线下沙龙 、3公司调研/、4C类电话会、5买方线下交流"
  35. // @Param ActiveState query int false "发布状态 ,1未开始、2进行中、3已结束 ,默认1未开始"
  36. // @Param PublishStatus query int false "发布状态 ,0未发布,1已发布,3已取消,传2查询所有"
  37. // @Param IsResearch query bool true "是否为研选"
  38. // @Success 200 {object} cygx.GetCygxSignupListRep
  39. // @router /activitySignup/list [get]
  40. func (this *ActivitySignupCoAntroller) SignupList() {
  41. br := new(models.BaseResponse).Init()
  42. defer func() {
  43. this.Data["json"] = br
  44. this.ServeJSON()
  45. }()
  46. sysUser := this.SysUser
  47. if sysUser == nil {
  48. br.Msg = "请登录"
  49. br.ErrMsg = "请登录,SysUser Is Empty"
  50. return
  51. }
  52. pageSize, _ := this.GetInt("PageSize")
  53. currentIndex, _ := this.GetInt("CurrentIndex")
  54. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  55. ActivityTypeId := this.GetString("ActivityTypeId")
  56. startDate := this.GetString("StartDate")
  57. endDate := this.GetString("EndDate")
  58. keyWord := this.GetString("KeyWord")
  59. activeState, _ := this.GetInt("ActiveState")
  60. searchType, _ := this.GetInt("SearchType")
  61. publishStatus, _ := this.GetInt("PublishStatus")
  62. isResearch, _ := this.GetBool("IsResearch", false) // 是否为研选 查研观向11.0 (研选活动独立显示)
  63. if activeState == 0 {
  64. activeState = 1
  65. }
  66. var startSize int
  67. if pageSize <= 0 {
  68. pageSize = utils.PageSize20
  69. }
  70. if currentIndex <= 0 {
  71. currentIndex = 1
  72. }
  73. startSize = utils.StartIndex(currentIndex, pageSize)
  74. var condition string
  75. var pars []interface{}
  76. if keyWord != "" {
  77. template.HTMLEscapeString(keyWord)
  78. keyWord = "%" + keyWord + "%"
  79. condition += ` AND (art.activity_name LIKE ? ) `
  80. pars = append(pars, keyWord)
  81. }
  82. condition += ` AND art.active_state = ? `
  83. pars = append(pars, activeState)
  84. if ActivityTypeId == "" {
  85. if searchType == 5 {
  86. condition += ` AND art.activity_type_id IN (8) `
  87. } else if searchType == 4 {
  88. condition += ` AND art.activity_type_id IN (7) `
  89. } else if searchType == 3 {
  90. condition += ` AND art.activity_type_id IN (3,4) `
  91. } else if searchType == 2 {
  92. condition += ` AND art.activity_type_id IN (5,6) `
  93. } else {
  94. condition += ` AND art.activity_type_id IN (1,2) ` //默认
  95. }
  96. }
  97. if ActivityTypeId != "" {
  98. condition += ` AND art.activity_type_id IN (` + ActivityTypeId + `) `
  99. }
  100. if isResearch {
  101. chartPermissionId = utils.CHART_PERMISSION_ID_YANXUAN
  102. } else {
  103. condition += ` AND art.chart_permission_id != '` + strconv.Itoa(utils.CHART_PERMISSION_ID_YANXUAN) + `'`
  104. }
  105. //行业名称
  106. if chartPermissionId > 0 {
  107. condition += ` AND art.chart_permission_id = '` + strconv.Itoa(chartPermissionId) + `'`
  108. }
  109. if startDate != "" {
  110. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  111. }
  112. if endDate != "" {
  113. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  114. }
  115. if publishStatus == 0 {
  116. condition += ` AND art.publish_status = 0 AND art.is_cancel = 0 `
  117. } else if publishStatus == 1 {
  118. condition += ` AND art.publish_status = 1 `
  119. } else if publishStatus == 3 {
  120. condition += ` AND art.publish_status = 0 AND art.is_cancel = 1 `
  121. }
  122. //C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到。
  123. if sysUser.Role != "admin" {
  124. conditionPermission, err := cygxService.GetAdminActivityPermission(sysUser, condition)
  125. if err != nil {
  126. br.Msg = "获取失败"
  127. br.ErrMsg = "获取失败,GetAdminActivityPermission Err:" + err.Error()
  128. return
  129. }
  130. condition += ` AND art.visible_range != 1 `
  131. condition += conditionPermission
  132. pars = append(pars, pars)
  133. }
  134. //condition += ` AND a.publish_status = 1 `
  135. total, err := cygx.GetCygxSignupCount(condition, pars)
  136. if err != nil {
  137. br.Msg = "获取失败"
  138. br.ErrMsg = "获取失败,Err:" + err.Error()
  139. return
  140. }
  141. if activeState == 3 {
  142. condition += ` ORDER BY art.activity_time DESC `
  143. } else {
  144. condition += ` ORDER BY art.activity_time ASC `
  145. }
  146. list, errList := cygx.GetCygxSignupListAll(condition, pars, startSize, pageSize)
  147. if errList != nil {
  148. br.Msg = "获取失败"
  149. br.ErrMsg = "获取失败,Err:" + errList.Error()
  150. return
  151. }
  152. var activityIds string
  153. for k, v := range list {
  154. if v.ChartPermissionNames != "" {
  155. list[k].ChartPermissionName = v.ChartPermissionNames
  156. }
  157. //if v.IsHideAppointment == 0 {
  158. // list[k].IsShowAppointment = cygxService.IsShowAppointmentByadminSet(v.IsCanAppointmentMinutes)
  159. //}
  160. activityIds += strconv.Itoa(v.ActivityId) + ","
  161. if v.ChartPermissionNameDeputy != "" && v.ChartPermissionNameDeputy != v.ChartPermissionName && v.YidongActivityId != "" {
  162. v.ChartPermissionName = v.ChartPermissionNameDeputy // 易董同步过来的活动展示副权限 v11.0
  163. }
  164. }
  165. activityIds = strings.TrimRight(activityIds, ",")
  166. mapIndustrial := make(map[int]string)
  167. mapSubject := make(map[string]string)
  168. if activityIds != "" {
  169. industrialList, err := cygx.GetIndustrialActivityGroupListByactivityIds(activityIds)
  170. if err != nil {
  171. br.Msg = "获取失败"
  172. br.ErrMsg = "获取失败,GetIndustrialActivityGroupListByactivityIds Err:" + err.Error()
  173. return
  174. }
  175. subjectList, err := cygx.GetSubjectActivityGroupListByactivityIds(activityIds)
  176. if err != nil {
  177. br.Msg = "获取失败"
  178. br.ErrMsg = "获取失败,GetSubjectActivityGroupListByactivityIds Err:" + err.Error()
  179. return
  180. }
  181. //合并活动对应的多个标的
  182. for _, v := range subjectList {
  183. mapSubject[fmt.Sprint(v.ActivityId, "_", v.IndustrialManagementId)] += v.SubjectName + "/"
  184. }
  185. //活动对应的产业
  186. for _, v := range industrialList {
  187. var labelSubject string
  188. labelSubject = mapSubject[fmt.Sprint(v.ActivityId, "_", v.IndustrialManagementId)]
  189. if labelSubject != "" {
  190. mapIndustrial[v.ActivityId] += v.IndustryName + "--" + strings.TrimRight(labelSubject, "/") + ","
  191. } else {
  192. mapIndustrial[v.ActivityId] += v.IndustryName + ","
  193. }
  194. }
  195. }
  196. for k, v := range list {
  197. if mapIndustrial[v.ActivityId] != "" && v.TemporaryLabel == "" {
  198. list[k].Label = strings.TrimRight(mapIndustrial[v.ActivityId], ",")
  199. }
  200. if v.IsCancel == 1 {
  201. v.PublishStatus = 3
  202. }
  203. if v.YidongActivityId != "" {
  204. list[k].ActivityTypeName += utils.YI_DONG_NAME
  205. list[k].LimitPeopleNum = 10000 // 前端根据这个字段是否大于0来处理是新增报名还是预约外呼
  206. }
  207. if v.IsYidongConduct == 1 {
  208. v.ActivityTypeName += utils.YI_DONG_NAME_TWO
  209. }
  210. if v.IsCanAppointmentMinutes == 1 {
  211. v.IsShowAppointment = true
  212. }
  213. }
  214. if len(list) == 0 {
  215. list = make([]*cygx.CygxSignupList, 0)
  216. }
  217. page := paging.GetPaging(currentIndex, pageSize, total)
  218. resp := new(cygx.GetCygxSignupListRep)
  219. resp.List = list
  220. resp.Paging = page
  221. br.Ret = 200
  222. br.Success = true
  223. br.Msg = "获取成功"
  224. br.Data = resp
  225. }
  226. // @Title 几种类型报名详情列表
  227. // @Description 获取几种类型报名详情列表接口
  228. // @Param ActivityId query int true "活动ID"
  229. // @Success 200 {object} cygx.GetAppointmentListRep
  230. // @router /activitySignup/appointmentList [get]
  231. func (this *ActivitySignupCoAntroller) AppointmentList() {
  232. br := new(models.BaseResponse).Init()
  233. defer func() {
  234. this.Data["json"] = br
  235. this.ServeJSON()
  236. }()
  237. sysUser := this.SysUser
  238. if sysUser == nil {
  239. br.Msg = "请登录"
  240. br.ErrMsg = "请登录,SysUser Is Empty"
  241. return
  242. }
  243. activityId, _ := this.GetInt("ActivityId")
  244. if activityId < 1 {
  245. br.Msg = "活动不存在"
  246. return
  247. }
  248. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  249. if activityInfo == nil {
  250. br.Msg = "活动不存在"
  251. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  252. return
  253. }
  254. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  255. resp := new(cygx.CanDownload)
  256. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  257. if errAdmin != nil {
  258. br.Msg = "获取失败"
  259. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  260. return
  261. }
  262. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  263. resp.IsCanDownload = true
  264. }
  265. memberType := "Admin"
  266. sqlStr := ` AND s.do_fail_type = 0 `
  267. totalStr := sqlStr
  268. list, err := cygx.GetCygxAppointmentList(activityId, sqlStr)
  269. if err != nil {
  270. br.Msg = "获取失败"
  271. br.ErrMsg = "获取失败,Err:" + err.Error()
  272. return
  273. }
  274. totalStr += " AND s.company_id != 16 "
  275. total, errtotal := cygx.GetCygxAppointmentCount(activityId, totalStr)
  276. if errtotal != nil {
  277. br.Msg = "获取失败"
  278. br.ErrMsg = "客户总数获取失败,Err:" + errtotal.Error()
  279. return
  280. }
  281. myTotal, errmyTotal := cygx.GetCygxAppointmentCount(activityId, sqlStr)
  282. if errmyTotal != nil {
  283. br.Msg = "获取失败"
  284. br.ErrMsg = "我的客户总数获取失败,Err:" + errmyTotal.Error()
  285. return
  286. }
  287. for k, v := range list {
  288. list[k].SellerName = v.PsellerName
  289. }
  290. respList := new(cygx.GetAppointmentListRep)
  291. //销售查看自己客户,销售组长查看组员
  292. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3 || activityInfo.IsYidongConduct == 1) {
  293. mapMobile, err := cygxService.GetAdminLookUserMobile(adminInfo)
  294. if err != nil {
  295. br.Msg = "获取失败"
  296. br.ErrMsg = "获取失败,销售对应权限,Err:" + err.Error()
  297. return
  298. }
  299. for _, v := range list {
  300. if _, ok := mapMobile[v.Mobile]; ok {
  301. respList.List = append(respList.List, v)
  302. }
  303. }
  304. } else {
  305. respList.List = list
  306. }
  307. if len(respList.List) == 0 {
  308. respList.List = make([]*cygx.CygxAppointmentList, 0)
  309. }
  310. respList.Total = total
  311. respList.MyTotal = myTotal
  312. respList.ActivityId = activityId
  313. respList.IsLimitPeople = activityInfo.IsLimitPeople
  314. respList.MemberType = memberType
  315. respList.IsResearchPoints = activityInfo.IsResearchPoints
  316. activityTypeId := activityInfo.ActivityTypeId
  317. //ExcelType string `description:"EXcel下载类型 AppointmentCall:预约外呼、ExpertSalon:专家沙龙报名、Teleconference:公司调研电话会、OfflineResearch:公司线下调研 "`
  318. if activityTypeId == 1 || activityTypeId == 2 {
  319. respList.ExcelType = "AppointmentCall"
  320. } else if activityTypeId == 5 || activityTypeId == 6 {
  321. respList.ExcelType = "ExpertSalon"
  322. } else if activityTypeId == 3 {
  323. respList.ExcelType = "Teleconference"
  324. } else if activityTypeId == 4 {
  325. respList.ExcelType = "OfflineResearch"
  326. } else if activityTypeId == 7 {
  327. respList.ExcelType = "CClass"
  328. }
  329. if activityInfo.YidongActivityId != "" {
  330. respList.ExcelType = "YiDong"
  331. }
  332. respList.IsYidongConduct = activityInfo.IsYidongConduct
  333. br.Ret = 200
  334. br.Success = true
  335. br.Msg = "获取成功"
  336. br.Data = respList
  337. }
  338. // @Title 外呼人员列表
  339. // @Description 获取外呼人员列表接口
  340. // @Param KeyWord query string false "搜索关键词"
  341. // @Success 200 {object} cygx.GetOutboundPersonnelListRep
  342. // @router /activitySignup/userList [get]
  343. func (this *ActivitySignupCoAntroller) OutboundPersonnelList() {
  344. br := new(models.BaseResponse).Init()
  345. defer func() {
  346. this.Data["json"] = br
  347. this.ServeJSON()
  348. }()
  349. keyWord := this.GetString("KeyWord")
  350. sysUser := this.SysUser
  351. if sysUser == nil {
  352. br.Msg = "请登录"
  353. br.ErrMsg = "请登录,SysUser Is Empty"
  354. return
  355. }
  356. if keyWord == "" {
  357. br.Msg = "请输入姓名"
  358. return
  359. }
  360. list, err := cygx.GetOutboundPersonnelList(keyWord)
  361. if err != nil {
  362. br.Msg = "获取失败"
  363. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  364. return
  365. }
  366. for k, v := range list {
  367. if len(v.Mobile) > 7 {
  368. list[k].Mobile = v.Mobile[0:3] + "****" + v.Mobile[7:]
  369. }
  370. }
  371. resp := new(cygx.GetOutboundPersonnelListRep)
  372. resp.List = list
  373. br.Ret = 200
  374. br.Success = true
  375. br.Msg = "获取成功"
  376. br.Data = resp
  377. }
  378. // @Title 新增外呼人员
  379. // @Description 新增外呼人员接口
  380. // @Param request body cygx.AddMeetingReminderReq true "type json string"
  381. // @Success 200 操作成功
  382. // @router /activitySignup/addUser [post]
  383. func (this *ActivitySignupCoAntroller) AddUser() {
  384. br := new(models.BaseResponse).Init()
  385. defer func() {
  386. this.Data["json"] = br
  387. this.ServeJSON()
  388. }()
  389. AdminUser := this.SysUser
  390. if AdminUser == nil {
  391. br.Msg = "请登录"
  392. br.ErrMsg = "请登录,SysUser Is Empty"
  393. return
  394. }
  395. var req cygx.AddMeetingReminderReq
  396. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  397. if err != nil {
  398. br.Msg = "参数解析异常!"
  399. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  400. return
  401. }
  402. var items []*cygx.CygxActivitySignup
  403. var itemsYidong []*cygx.YidongActivitySignup
  404. var itemsAppointment []*cygx.CygxActivityAppointment
  405. activityIds := req.ActivityIds
  406. uidList := req.List
  407. if activityIds == "" {
  408. br.Msg = "请选择活动"
  409. br.ErrMsg = "活动ID不能为空"
  410. return
  411. }
  412. activityIdList := strings.Split(activityIds, ",")
  413. var uids string
  414. for _, v := range uidList {
  415. uids += strconv.Itoa(v.UserId) + ","
  416. }
  417. uids = strings.TrimRight(uids, ",")
  418. for _, v := range uidList {
  419. uid := v.UserId
  420. wxUser, userErr := models.GetWxUserByUserId(uid)
  421. if userErr != nil {
  422. br.Msg = "编辑失败!查询用户信息失败"
  423. br.ErrMsg = "查询用户信息失败,Err:" + userErr.Error() + "用户UID:" + strconv.Itoa(uid) + "不存在"
  424. return
  425. }
  426. for _, vact := range activityIdList {
  427. activityId, _ := strconv.Atoi(vact)
  428. activityInfo, err := cygx.GetAddActivityInfoById(activityId)
  429. if err != nil {
  430. br.Msg = "活动不存在"
  431. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  432. return
  433. }
  434. if activityInfo.YidongActivityId != "" {
  435. errMsg := cygxService.CheckYidongActivitySignupTime(activityInfo)
  436. if errMsg != "" {
  437. br.Msg = errMsg
  438. br.ErrMsg = errMsg + "Err:activityId:" + strconv.Itoa(activityId)
  439. return
  440. }
  441. }
  442. limitPeopleNum, _ := strconv.Atoi(activityInfo.LimitPeopleNum)
  443. //if limitPeopleNum > 0 {
  444. if AdminUser.RoleTypeCode != "admin" {
  445. //havePower := cygxService.CheckaddSignuUserPower(wxUser.CompanyId, activityId, activityInfo)
  446. havePower, err := cygxService.GetActivityDetailUserPower(wxUser, AdminUser, activityInfo)
  447. if err != nil {
  448. br.Msg = "用户权限校验失败!"
  449. br.ErrMsg = "GetActivityDetailUserPower,Err:" + err.Error() + fmt.Sprint("UserId", wxUser.UserId, "ActivityId:", activityInfo.ActivityId)
  450. return
  451. }
  452. if !havePower {
  453. br.Msg = "当前活动对该客户不可见,无法报名"
  454. br.ErrMsg = "活动ID:" + strconv.Itoa(activityId) + "活动名称:" + activityInfo.ActivityName + "用户ID:" + strconv.Itoa(int(wxUser.UserId))
  455. return
  456. }
  457. //}
  458. if activityInfo.IsLimitPeople == 1 {
  459. //获取这个活动已经报名的用户数量
  460. totalSignup, errSignup := cygx.GetActivitySignupCountByActivityId(activityId)
  461. if errSignup != nil {
  462. br.Msg = "获取失败"
  463. br.ErrMsg = "获取失败,Err:" + errSignup.Error()
  464. return
  465. }
  466. //获取这个活动中输入的这些用户的报名数量
  467. totalThisUser, errThisUser := cygx.GetActivitySignupCountByThisUser(activityId, uids)
  468. if errThisUser != nil {
  469. br.Msg = "获取失败"
  470. br.ErrMsg = "获取失败,Err:" + errThisUser.Error()
  471. return
  472. }
  473. //如果是限制人数的就做报名人数限制判断
  474. if activityInfo.IsLimitPeople == 1 {
  475. if limitPeopleNum < totalSignup+len(uidList)-totalThisUser {
  476. br.Msg = "新增失败,活动人数超限"
  477. br.ErrMsg = "当前活动报名人数已满,活动:" + activityInfo.ActivityName
  478. return
  479. }
  480. }
  481. }
  482. }
  483. total, errtotal := cygx.GetActivitySignupCount(uid, activityId)
  484. if errtotal != nil {
  485. br.Msg = "获取失败"
  486. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  487. return
  488. }
  489. if total == 0 {
  490. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  491. if err != nil {
  492. br.Msg = "获取失败"
  493. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  494. return
  495. }
  496. item := new(cygx.CygxActivitySignup)
  497. item.UserId = infoUser.UserId
  498. item.RealName = infoUser.RealName
  499. item.SellerName = infoUser.SellerName
  500. item.ActivityId = activityId
  501. item.CreateTime = time.Now()
  502. item.Mobile = infoUser.Mobile
  503. item.Email = infoUser.Email
  504. item.CompanyId = infoUser.CompanyId
  505. item.CompanyName = infoUser.CompanyName
  506. item.Source = 2
  507. //优先绑定用户修改过的外呼手机号
  508. if infoUser.OutboundMobile != "" {
  509. item.OutboundMobile = infoUser.OutboundMobile
  510. if infoUser.OutboundCountryCode == "" {
  511. item.CountryCode = "86"
  512. } else {
  513. item.CountryCode = infoUser.OutboundCountryCode
  514. }
  515. } else {
  516. item.OutboundMobile = infoUser.Mobile
  517. if infoUser.CountryCode == "" {
  518. item.CountryCode = "86"
  519. } else {
  520. item.CountryCode = infoUser.CountryCode
  521. }
  522. }
  523. item.SignupType = 1
  524. items = append(items, item)
  525. if activityInfo.YidongActivityId != "" {
  526. //测试环境下弘则下面的用户才收到消息
  527. if utils.RunMode != "release" && item.CompanyId == 16 {
  528. itemYidong := new(cygx.YidongActivitySignup)
  529. itemYidong.YidongActivityId = activityInfo.YidongActivityId
  530. itemYidong.Mobile = item.Mobile
  531. itemYidong.RealName = item.RealName
  532. itemYidong.CompanyName = item.CompanyName
  533. itemYidong.CountryCode = item.CountryCode
  534. itemsYidong = append(itemsYidong, itemYidong)
  535. }
  536. }
  537. }
  538. if v.IsAppointment == 1 {
  539. //var isHideAppointment bool
  540. //if activityInfo.IsHideAppointment == 0 {
  541. // isHideAppointment = cygxService.IsShowAppointmentByadminSet(activityInfo.IsCanAppointmentMinutes)
  542. //}
  543. if activityInfo.IsCanAppointmentMinutes == 0 {
  544. br.Msg = "该活动无法预约纪要"
  545. br.ErrMsg = "该活动无法预约纪要,Err:" + activityInfo.ActivityName
  546. return
  547. }
  548. total, errtotal := cygx.GetUserCygxActivityAppointmentCount(uid, activityId)
  549. if errtotal != nil {
  550. br.Msg = "获取失败"
  551. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  552. return
  553. }
  554. //判断这个用户是否报名了,如果没有报名则写入报名数据
  555. if total == 0 {
  556. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  557. if err != nil {
  558. br.Msg = "获取失败"
  559. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  560. return
  561. }
  562. itemAppointment := new(cygx.CygxActivityAppointment)
  563. itemAppointment.UserId = infoUser.UserId
  564. itemAppointment.RealName = infoUser.RealName
  565. itemAppointment.SellerName = infoUser.SellerName
  566. itemAppointment.ActivityId = activityId
  567. itemAppointment.CreateTime = time.Now()
  568. itemAppointment.Mobile = infoUser.Mobile
  569. itemAppointment.Email = infoUser.Email
  570. itemAppointment.CompanyId = infoUser.CompanyId
  571. itemAppointment.CompanyName = infoUser.CompanyName
  572. itemAppointment.AdminId = AdminUser.AdminId
  573. itemAppointment.Source = 2
  574. itemsAppointment = append(itemsAppointment, itemAppointment)
  575. }
  576. }
  577. }
  578. }
  579. mapYidongActivity := make(map[int]int)
  580. err = cygx.AddCygxActivitySignup(items, itemsAppointment, mapYidongActivity)
  581. if err != nil {
  582. br.Msg = "操作失败"
  583. br.ErrMsg = "新增用户失败,Err:" + err.Error()
  584. return
  585. }
  586. //如果有值就向易董推送后台添加的报名信息
  587. if len(itemsYidong) > 0 {
  588. go cygxService.YidongActivityUserSingnUp(itemsYidong)
  589. }
  590. //添加操作日志记录
  591. br.Ret = 200
  592. br.Success = true
  593. br.Msg = "操作成功"
  594. br.IsAddLog = true
  595. }
  596. // @Title 报名失败详情列表
  597. // @Description 获取沙龙报名失败详情列表接口
  598. // @Param ActivityId query int true "活动ID"
  599. // @Success 200 {object} cygx.GetFailSignupListRep
  600. // @router /activitySignup/salonFailSignupList [get]
  601. func (this *ActivitySignupCoAntroller) SalonFailSignupList() {
  602. br := new(models.BaseResponse).Init()
  603. defer func() {
  604. this.Data["json"] = br
  605. this.ServeJSON()
  606. }()
  607. sysUser := this.SysUser
  608. if sysUser == nil {
  609. br.Msg = "请登录"
  610. br.ErrMsg = "请登录,SysUser Is Empty"
  611. return
  612. }
  613. respList := new(cygx.GetFailSignupListRep)
  614. activityId, _ := this.GetInt("ActivityId")
  615. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  616. if activityInfo == nil {
  617. br.Msg = "活动不存在"
  618. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  619. return
  620. }
  621. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  622. resp := new(cygx.CanDownload)
  623. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  624. if errAdmin != nil {
  625. br.Msg = "获取失败"
  626. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  627. return
  628. }
  629. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  630. resp.IsCanDownload = true
  631. }
  632. memberType := "Admin"
  633. sqlStr := ""
  634. sqlStr += ` AND s.fail_type >0 `
  635. list, err := cygx.GetFailSignupList(activityId, sqlStr)
  636. if err != nil {
  637. br.Msg = "获取失败"
  638. br.ErrMsg = "获取失败,Err:" + err.Error()
  639. return
  640. }
  641. sqlStrtotal := ` AND s.fail_type >0 `
  642. total, errtotal := cygx.GetCygxAppointmentCount(activityId, sqlStrtotal)
  643. if errtotal != nil {
  644. br.Msg = "获取失败"
  645. br.ErrMsg = "客户总数获取失败,Err:" + errtotal.Error()
  646. return
  647. }
  648. //权益申请销售只能看到自己名下的客户的申请 查研观向11.1
  649. companyIds, err := cygxService.GetAdminLookUserCompanyIds(sysUser)
  650. if err != nil {
  651. br.Msg = "获取失败"
  652. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  653. return
  654. }
  655. var companyIdstr []string
  656. for _, v := range companyIds {
  657. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  658. }
  659. myTotalsqlStr := ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `) AND s.fail_type >0 `
  660. myTotal, errmyTotal := cygx.GetCygxAppointmentCount(activityId, myTotalsqlStr)
  661. if errmyTotal != nil {
  662. br.Msg = "获取失败"
  663. br.ErrMsg = "我的客户总数获取失败,Err:" + errmyTotal.Error()
  664. return
  665. }
  666. if activityInfo.IsLimitPeople > 0 {
  667. //获取这个活动已经报名的用户数量
  668. totalSignup, errSignup := cygx.GetActivitySignupCountByActivityId(activityId)
  669. if errSignup != nil {
  670. br.Msg = "获取信息失败"
  671. br.ErrMsg = "获取数量失败,Err:" + errSignup.Error()
  672. return
  673. }
  674. limitPeopleNum, err := strconv.Atoi(activityInfo.LimitPeopleNum)
  675. if err != nil {
  676. br.Msg = "获取信息失败"
  677. br.ErrMsg = "数据转换失败,Err:" + err.Error()
  678. return
  679. }
  680. //如果报名人数不小于限制人数,则报名人数已满
  681. if limitPeopleNum <= totalSignup {
  682. respList.IsFull = true
  683. }
  684. }
  685. for k, v := range list {
  686. if v.DoFailType == 0 {
  687. list[k].SalonOperation = true
  688. list[k].CallOperation = v.SignupType
  689. } else {
  690. list[k].CallOperation = 3
  691. }
  692. }
  693. //销售查看自己客户,销售组长查看组员
  694. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3) {
  695. mapMobile, err := cygxService.GetAdminLookUserMobile(adminInfo)
  696. if err != nil {
  697. br.Msg = "获取失败"
  698. br.ErrMsg = "获取失败,销售对应权限,Err:" + err.Error()
  699. return
  700. }
  701. for _, v := range list {
  702. if _, ok := mapMobile[v.Mobile]; ok {
  703. respList.List = append(respList.List, v)
  704. }
  705. }
  706. } else {
  707. respList.List = list
  708. }
  709. if len(respList.List) == 0 {
  710. respList.List = make([]*cygx.FailSignupListRep, 0)
  711. }
  712. respList.Total = total
  713. respList.MyTotal = myTotal
  714. respList.IsLimitPeople = activityInfo.IsLimitPeople
  715. respList.MemberType = memberType
  716. activityTypeId := activityInfo.ActivityTypeId
  717. if activityTypeId == 1 || activityTypeId == 2 {
  718. respList.ExcelType = "AppointmentCall"
  719. } else if activityTypeId == 5 || activityTypeId == 6 {
  720. respList.ExcelType = "ExpertSalon"
  721. } else if activityTypeId == 3 {
  722. respList.ExcelType = "Teleconference"
  723. } else if activityTypeId == 4 {
  724. respList.ExcelType = "OfflineResearch"
  725. }
  726. br.Ret = 200
  727. br.Success = true
  728. br.Msg = "获取成功"
  729. br.Data = respList
  730. }
  731. // @Title 沙龙限制报名、加入报名
  732. // @Description 修改沙龙限制报名、加入报名接口
  733. // @Param request body cygx.SignupId true "type json string"
  734. // @Success 200 操作成功
  735. // @router /activitySignup/salonSignupEdit [post]
  736. func (this *ActivitySignupCoAntroller) SalonSignupEdit() {
  737. br := new(models.BaseResponse).Init()
  738. defer func() {
  739. this.Data["json"] = br
  740. this.ServeJSON()
  741. }()
  742. AdminUser := this.SysUser
  743. if AdminUser == nil {
  744. br.Msg = "请登录"
  745. br.ErrMsg = "请登录,SysUser Is Empty"
  746. return
  747. }
  748. var req cygx.SignupId
  749. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  750. if err != nil {
  751. br.Msg = "参数解析异常!"
  752. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  753. return
  754. }
  755. id := req.Id
  756. total, err := cygx.GetCygxSignupCountFile(id)
  757. if err != nil {
  758. br.Msg = "获取失败"
  759. br.ErrMsg = "获取失败,Err:" + err.Error()
  760. return
  761. }
  762. if total == 0 {
  763. br.Msg = "获取报名信息失败"
  764. br.ErrMsg = "获取失败,id:" + strconv.Itoa(id)
  765. return
  766. }
  767. detail, err := cygx.GetCygxSignupDetailById(id)
  768. if err != nil {
  769. br.Msg = "操作失败"
  770. br.ErrMsg = "操作失败,Err:" + err.Error()
  771. return
  772. }
  773. newIsAdminAddSignup := 0
  774. if detail.IsAdminAddSignup == 1 {
  775. newIsAdminAddSignup = 0
  776. } else {
  777. newIsAdminAddSignup = 1
  778. activityInfo, err := cygx.GetAddActivityInfoById(detail.ActivityId)
  779. if err != nil {
  780. br.Msg = "活动不存在"
  781. br.ErrMsg = "活动ID错误,Err:" + err.Error() + "activityId:" + strconv.Itoa(detail.ActivityId)
  782. return
  783. }
  784. if activityInfo.IsLimitPeople > 0 {
  785. //获取这个活动已经报名的用户数量
  786. totalSignup, errSignup := cygx.GetActivitySignupCountByActivityId(detail.ActivityId)
  787. if errSignup != nil {
  788. br.Msg = "操作失败"
  789. br.ErrMsg = "获取数量失败,Err:" + errSignup.Error()
  790. return
  791. }
  792. limitPeopleNum, err := strconv.Atoi(activityInfo.LimitPeopleNum)
  793. if err != nil {
  794. br.Msg = "操作失败"
  795. br.ErrMsg = "数据转换失败,Err:" + err.Error()
  796. return
  797. }
  798. if limitPeopleNum <= totalSignup {
  799. br.Msg = "新增失败,活动人数超限"
  800. return
  801. }
  802. adminInfo, errAdmin := system.GetSysUserById(AdminUser.AdminId)
  803. if errAdmin != nil {
  804. br.Msg = "获取失败"
  805. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  806. return
  807. }
  808. //如果操作的不是管理员就做下面的限制
  809. if adminInfo.Role != "admin" {
  810. activityId := detail.ActivityId
  811. //单机构两人限制
  812. {
  813. totalSignupCompany, err := cygx.GetActivitySignupCompanyCount(activityId, detail.CompanyId)
  814. if err != nil {
  815. br.Msg = "获取信息失败"
  816. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  817. return
  818. }
  819. if totalSignupCompany >= 2 {
  820. br.Msg = "新增失败,单机构最多2人报名同一活动。"
  821. br.ErrMsg = "新增失败,单机构最多2人报名同一活动。" + fmt.Sprint("activityId:", activityId, detail.Mobile)
  822. return
  823. }
  824. }
  825. //爽约限制
  826. //{
  827. // totalRestrict, err := cygx.GetUserRestrictCount(detail.Mobile)
  828. // if err != nil {
  829. // br.Msg = "获取信息失败"
  830. // br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  831. // return
  832. // }
  833. // if totalRestrict >= 1 {
  834. // br.Msg = "新增失败," + detail.RealName + "爽约次数过多。"
  835. // br.ErrMsg = detail.RealName + "由于爽约次数过多,暂时被限制报名资格"
  836. // return
  837. // }
  838. //}
  839. }
  840. }
  841. }
  842. var doFailType int
  843. if newIsAdminAddSignup == 1 {
  844. doFailType = 0
  845. } else {
  846. doFailType = detail.FailType
  847. }
  848. infoUser, err := cygx.GetUserAndCompanyNameList(detail.UserId)
  849. if err != nil {
  850. br.Msg = "获取失败"
  851. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  852. return
  853. }
  854. item := new(cygx.CygxActivitySignup)
  855. item.UserId = infoUser.UserId
  856. item.RealName = infoUser.RealName
  857. item.SellerName = infoUser.SellerName
  858. item.ActivityId = detail.ActivityId
  859. item.CreateTime = time.Now()
  860. item.Mobile = infoUser.Mobile
  861. item.Email = infoUser.Email
  862. item.CompanyId = infoUser.CompanyId
  863. item.CompanyName = infoUser.CompanyName
  864. err = cygx.SalonSignupEdit(newIsAdminAddSignup, doFailType, id, item)
  865. if err != nil {
  866. br.Msg = "修改失败"
  867. br.ErrMsg = "修改失败 Err:" + err.Error()
  868. return
  869. }
  870. var itemsSendWxMsg []*cygx.CygxSignupUser
  871. itemsSendWxMsg = append(itemsSendWxMsg, &cygx.CygxSignupUser{UserId: infoUser.UserId, ActivityId: detail.ActivityId})
  872. //销售或后台管理员给用户添加报名之后,进行模版消息推送
  873. if doFailType == 0 {
  874. go cygxService.SendWxMsgWithCygxActivitySignUpBySell(itemsSendWxMsg)
  875. }
  876. //添加操作日志记录
  877. br.Ret = 200
  878. br.Success = true
  879. br.Msg = "操作成功"
  880. br.IsAddLog = true
  881. }
  882. // @Title 公司调研电话会报名失败详情列表
  883. // @Description 获取公司调研电话会报名失败详情列表接口
  884. // @Param ActivityId query int true "活动ID"
  885. // @Success 200 {object} cygx.GetFailSignupListRep
  886. // @router /activitySignup/callFailSignupList [get]
  887. func (this *ActivitySignupCoAntroller) FailSignupList() {
  888. br := new(models.BaseResponse).Init()
  889. defer func() {
  890. this.Data["json"] = br
  891. this.ServeJSON()
  892. }()
  893. sysUser := this.SysUser
  894. if sysUser == nil {
  895. br.Msg = "请登录"
  896. br.ErrMsg = "请登录,SysUser Is Empty"
  897. return
  898. }
  899. activityId, _ := this.GetInt("ActivityId")
  900. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  901. if activityInfo == nil {
  902. br.Msg = "活动不存在"
  903. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  904. return
  905. }
  906. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  907. resp := new(cygx.CanDownload)
  908. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  909. if errAdmin != nil {
  910. br.Msg = "获取失败"
  911. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  912. return
  913. }
  914. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  915. resp.IsCanDownload = true
  916. }
  917. var list []*cygx.FailSignupListRep
  918. memberType := "Admin"
  919. var err error
  920. sqlStr := ""
  921. sqlStr += ` AND s.fail_type >0 `
  922. listSeller, errSeller := cygx.GetFailSignupList(activityId, sqlStr)
  923. list = listSeller
  924. err = errSeller
  925. if err != nil {
  926. br.Msg = "获取失败"
  927. br.ErrMsg = "获取失败,Err:" + err.Error()
  928. return
  929. }
  930. total, errtotal := cygx.GetCygxAppointmentCount(activityId, "")
  931. if errtotal != nil {
  932. br.Msg = "获取失败"
  933. br.ErrMsg = "客户总数获取失败,Err:" + errtotal.Error()
  934. return
  935. }
  936. //权益申请销售只能看到自己名下的客户的申请 查研观向11.1
  937. companyIds, err := cygxService.GetAdminLookUserCompanyIds(sysUser)
  938. if err != nil {
  939. br.Msg = "获取失败"
  940. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  941. return
  942. }
  943. var companyIdstr []string
  944. for _, v := range companyIds {
  945. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  946. }
  947. myTotalsqlStr := ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `) AND s.fail_type >0 `
  948. myTotal, errmyTotal := cygx.GetCygxAppointmentCount(activityId, myTotalsqlStr)
  949. if errmyTotal != nil {
  950. br.Msg = "获取失败"
  951. br.ErrMsg = "我的客户总数获取失败,Err:" + errmyTotal.Error()
  952. return
  953. }
  954. var listNew []*cygx.FailSignupListRep
  955. for k, v := range list {
  956. if k > 0 && list[k].Id == list[k-1].Id {
  957. list[k-1].SellerName = list[k-1].SellerName + "/" + v.SellerName
  958. }
  959. }
  960. for k, v := range list {
  961. if k > 0 && list[k].Id != list[k-1].Id {
  962. listNew = append(listNew, v)
  963. }
  964. if k == 0 && len(list) >= 2 && list[1].Id == list[0].Id {
  965. listNew = append(listNew, v)
  966. }
  967. }
  968. for k, v := range listNew {
  969. if v.IsAdminAddSignup == 0 {
  970. listNew[k].CallOperation = 3
  971. } else {
  972. listNew[k].CallOperation = v.MeetingType
  973. }
  974. }
  975. respList := new(cygx.GetFailSignupListRep)
  976. //销售查看自己客户,销售组长查看组员
  977. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3) {
  978. mapMobile, err := cygxService.GetAdminLookUserMobile(adminInfo)
  979. if err != nil {
  980. br.Msg = "获取失败"
  981. br.ErrMsg = "获取失败,销售对应权限,Err:" + err.Error()
  982. return
  983. }
  984. for _, v := range listNew {
  985. if _, ok := mapMobile[v.Mobile]; ok {
  986. respList.List = append(respList.List, v)
  987. }
  988. }
  989. } else {
  990. respList.List = listNew
  991. }
  992. if len(respList.List) == 0 {
  993. respList.List = make([]*cygx.FailSignupListRep, 0)
  994. }
  995. respList.List = listNew
  996. respList.Total = total
  997. respList.MyTotal = myTotal
  998. respList.IsLimitPeople = activityInfo.IsLimitPeople
  999. respList.MemberType = memberType
  1000. activityTypeId := activityInfo.ActivityTypeId
  1001. //ExcelType string `description:"EXcel下载类型 AppointmentCall:预约外呼、ExpertSalon:专家沙龙报名、Teleconference:公司调研电话会、OfflineResearch:公司线下调研 "`
  1002. if activityTypeId == 1 || activityTypeId == 2 {
  1003. respList.ExcelType = "AppointmentCall"
  1004. } else if activityTypeId == 5 || activityTypeId == 6 {
  1005. respList.ExcelType = "ExpertSalon"
  1006. } else if activityTypeId == 3 {
  1007. respList.ExcelType = "Teleconference"
  1008. } else if activityTypeId == 4 {
  1009. respList.ExcelType = "OfflineResearch"
  1010. }
  1011. br.Ret = 200
  1012. br.Success = true
  1013. br.Msg = "获取成功"
  1014. br.Data = respList
  1015. }
  1016. // @Title 修改公司调研电话会限制报名、预约外呼、自主拨入
  1017. // @Description 修改公司调研电话会限制报名、预约外呼、自主拨入接口
  1018. // @Param request body cygx.SignupIdCall true "type json string"
  1019. // @Success 200 操作成功
  1020. // @router /activitySignup/callSignupEdit [post]
  1021. func (this *ActivitySignupCoAntroller) CallSignupEdit() {
  1022. br := new(models.BaseResponse).Init()
  1023. defer func() {
  1024. this.Data["json"] = br
  1025. this.ServeJSON()
  1026. }()
  1027. sysUser := this.SysUser
  1028. if sysUser == nil {
  1029. br.Msg = "请登录"
  1030. br.ErrMsg = "请登录,SysUser Is Empty"
  1031. return
  1032. }
  1033. var req cygx.SignupIdCall
  1034. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1035. if err != nil {
  1036. br.Msg = "参数解析异常!"
  1037. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1038. return
  1039. }
  1040. id := req.Id
  1041. operationStatus := req.OperationStatus
  1042. total, err := cygx.GetCygxSignupCountFile(id)
  1043. if err != nil {
  1044. br.Msg = "获取失败"
  1045. br.ErrMsg = "获取失败,Err:" + err.Error()
  1046. return
  1047. }
  1048. if total == 0 {
  1049. br.Msg = "获取报名信息失败"
  1050. br.ErrMsg = "获取失败,id:" + strconv.Itoa(id)
  1051. return
  1052. }
  1053. detail, err := cygx.GetCygxSignupDetailById(id)
  1054. if err != nil {
  1055. br.Msg = "操作失败"
  1056. br.ErrMsg = "操作失败,Err:" + err.Error()
  1057. return
  1058. }
  1059. uid := detail.UserId
  1060. var doFailType int
  1061. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  1062. if err != nil {
  1063. br.Msg = "获取失败"
  1064. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  1065. return
  1066. }
  1067. item := new(cygx.CygxMySchedule)
  1068. item.UserId = infoUser.UserId
  1069. item.CreateTime = time.Now()
  1070. item.Mobile = infoUser.Mobile
  1071. item.ActivityId = detail.ActivityId
  1072. item.Email = infoUser.Email
  1073. item.CompanyId = infoUser.CompanyId
  1074. item.CompanyName = infoUser.CompanyName
  1075. if operationStatus == 1 {
  1076. doFailType = 0
  1077. } else {
  1078. doFailType = detail.FailType
  1079. }
  1080. var errEdit error
  1081. if operationStatus == 3 {
  1082. err3 := cygx.CallSignupEditByStatus3(id, doFailType, item)
  1083. errEdit = err3
  1084. } else {
  1085. err1_2 := cygx.CallSignupEditByStatus1_2(operationStatus, id, item)
  1086. errEdit = err1_2
  1087. }
  1088. if errEdit != nil {
  1089. br.Msg = "修改失败"
  1090. br.ErrMsg = "修改失败 Err:" + errEdit.Error()
  1091. return
  1092. }
  1093. br.Ret = 200
  1094. br.Success = true
  1095. br.Msg = "操作成功"
  1096. br.IsAddLog = true
  1097. }
  1098. // @Title 预约外呼详情、公司调研电话会excel表格下载
  1099. // @Description 获取预约外呼详情、公司调研电话会excel表格下载接口
  1100. // @Param ActivityId query int true "活动ID"
  1101. // @Success 200 导出成功
  1102. // @router /activitySignup/callExport [get]
  1103. func (this *ActivitySignupCoAntroller) CallExport() {
  1104. br := new(models.BaseResponse).Init()
  1105. defer func() {
  1106. this.Data["json"] = br
  1107. this.ServeJSON()
  1108. }()
  1109. sysUser := this.SysUser
  1110. if sysUser == nil {
  1111. br.Msg = "请登录"
  1112. br.ErrMsg = "请登录,SysUser Is Empty"
  1113. return
  1114. }
  1115. activityId, _ := this.GetInt("ActivityId")
  1116. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  1117. if activityInfo == nil {
  1118. br.Msg = "活动不存在"
  1119. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  1120. return
  1121. }
  1122. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  1123. resp := new(cygx.CanDownload)
  1124. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  1125. if errAdmin != nil {
  1126. br.Msg = "获取失败"
  1127. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  1128. return
  1129. }
  1130. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  1131. resp.IsCanDownload = true
  1132. }
  1133. //var err error
  1134. sqlStr := " "
  1135. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3) {
  1136. //权益申请销售只能看到自己名下的客户的申请 查研观向11.1
  1137. companyIds, err := cygxService.GetAdminLookUserCompanyIds(sysUser)
  1138. if err != nil {
  1139. br.Msg = "获取失败"
  1140. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  1141. return
  1142. }
  1143. var companyIdstr []string
  1144. for _, v := range companyIds {
  1145. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  1146. }
  1147. sqlStr += ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `) `
  1148. }
  1149. //公司调研电话会下载全部
  1150. if activityInfo.ActivityTypeId != 3 {
  1151. sqlStr += " AND s.signup_type = 1 "
  1152. }
  1153. list, err := cygx.GetCygxAppointmentList(activityId, sqlStr)
  1154. //err = errSeller
  1155. if err != nil {
  1156. br.Msg = "获取失败"
  1157. br.ErrMsg = "获取失败,Err:" + err.Error()
  1158. return
  1159. }
  1160. //会议提醒
  1161. listReminder, err := cygx.GetCygxActivityMeetingReminderList(activityId, sqlStr)
  1162. if err != nil {
  1163. br.Msg = "获取失败"
  1164. br.ErrMsg = "获取失败,Err:" + err.Error()
  1165. return
  1166. }
  1167. //预约纪要
  1168. listSummary, err := cygx.GetCygxAppointmentSummaryList(activityId, sqlStr)
  1169. if err != nil {
  1170. br.Msg = "获取失败"
  1171. br.ErrMsg = "获取失败,Err:" + err.Error()
  1172. return
  1173. }
  1174. //创建excel
  1175. dir, err := os.Executable()
  1176. exPath := filepath.Dir(dir)
  1177. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  1178. xlsxFile := xlsx.NewFile()
  1179. if err != nil {
  1180. br.Msg = "生成文件失败"
  1181. br.ErrMsg = "生成文件失败"
  1182. return
  1183. }
  1184. style := xlsx.NewStyle()
  1185. alignment := xlsx.Alignment{
  1186. Horizontal: "center",
  1187. Vertical: "center",
  1188. WrapText: true,
  1189. }
  1190. style.Alignment = alignment
  1191. style.ApplyAlignment = true
  1192. for pidIndex := 0; pidIndex <= 2; pidIndex++ {
  1193. var sheetName string
  1194. var listDate []*cygx.CygxAppointmentList
  1195. if pidIndex == 0 {
  1196. if activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 {
  1197. sheetName = "预约外呼"
  1198. } else {
  1199. sheetName = "名单"
  1200. }
  1201. listDate = list
  1202. } else if pidIndex == 1 {
  1203. sheetName = "会议提醒"
  1204. listDate = listReminder
  1205. } else {
  1206. sheetName = "预约纪要"
  1207. listDate = listSummary
  1208. }
  1209. sheet, err := xlsxFile.AddSheet(sheetName)
  1210. if err != nil {
  1211. br.Msg = "新增Sheet失败"
  1212. br.ErrMsg = "新增Sheet失败,Err:" + err.Error()
  1213. return
  1214. }
  1215. //标头
  1216. if pidIndex == 0 {
  1217. //如果是公司调研电话会就下载邮箱
  1218. if activityInfo.ActivityTypeId == 3 {
  1219. rowTitle := sheet.AddRow()
  1220. cellA := rowTitle.AddCell()
  1221. cellA.Value = "姓名"
  1222. cellB := rowTitle.AddCell()
  1223. cellB.Value = "外呼号码"
  1224. cellC := rowTitle.AddCell()
  1225. cellC.Value = "国际代码"
  1226. cellD := rowTitle.AddCell()
  1227. cellD.Value = "邮箱"
  1228. cellE := rowTitle.AddCell()
  1229. cellE.Value = "公司名称"
  1230. cellF := rowTitle.AddCell()
  1231. cellF.Value = "所属销售"
  1232. for _, item := range listDate {
  1233. row := sheet.AddRow()
  1234. cellA := row.AddCell()
  1235. cellA.Value = item.RealName
  1236. cellB := row.AddCell()
  1237. cellB.Value = item.OutboundMobile
  1238. cellC := row.AddCell()
  1239. if item.CountryCode == "" {
  1240. cellC.Value = "86"
  1241. } else {
  1242. cellC.Value = item.CountryCode
  1243. }
  1244. cellD := row.AddCell()
  1245. cellD.Value = item.Email
  1246. cellE := row.AddCell()
  1247. cellE.Value = item.CompanyName
  1248. cellF := row.AddCell()
  1249. cellF.Value = item.SellerName
  1250. }
  1251. } else {
  1252. rowTitle := sheet.AddRow()
  1253. cellA := rowTitle.AddCell()
  1254. cellA.Value = "姓名"
  1255. cellB := rowTitle.AddCell()
  1256. cellB.Value = "外呼号码"
  1257. cellC := rowTitle.AddCell()
  1258. cellC.Value = "国际代码"
  1259. cellD := rowTitle.AddCell()
  1260. cellD.Value = "公司名称"
  1261. cellE := rowTitle.AddCell()
  1262. cellE.Value = "所属销售"
  1263. for _, item := range listDate {
  1264. row := sheet.AddRow()
  1265. cellA := row.AddCell()
  1266. cellA.Value = item.RealName
  1267. cellB := row.AddCell()
  1268. cellB.Value = item.OutboundMobile
  1269. cellC := row.AddCell()
  1270. if item.CountryCode == "" {
  1271. cellC.Value = "86"
  1272. } else {
  1273. cellC.Value = item.CountryCode
  1274. }
  1275. cellD := row.AddCell()
  1276. cellD.Value = item.CompanyName
  1277. cellE := row.AddCell()
  1278. cellE.Value = item.SellerName
  1279. }
  1280. }
  1281. } else {
  1282. rowTitle := sheet.AddRow()
  1283. cellA := rowTitle.AddCell()
  1284. cellA.Value = "姓名"
  1285. cellB := rowTitle.AddCell()
  1286. cellB.Value = "公司名称"
  1287. cellC := rowTitle.AddCell()
  1288. cellC.Value = "所属销售"
  1289. for _, item := range listDate {
  1290. row := sheet.AddRow()
  1291. cellA := row.AddCell()
  1292. cellA.Value = item.RealName
  1293. cellB := row.AddCell()
  1294. cellB.Value = item.CompanyName
  1295. cellC := row.AddCell()
  1296. cellC.Value = item.SellerName
  1297. }
  1298. }
  1299. }
  1300. err = xlsxFile.Save(downLoadnFilePath)
  1301. if err != nil {
  1302. br.Msg = "保存文件失败"
  1303. br.ErrMsg = "保存文件失败"
  1304. return
  1305. }
  1306. //randStr := time.Now().Format(utils.FormatDateTimeUnSpace)
  1307. downloadFileName := activityInfo.ActivityName + ".xlsx"
  1308. this.Ctx.Output.Download(downLoadnFilePath, downloadFileName)
  1309. defer func() {
  1310. os.Remove(downLoadnFilePath)
  1311. }()
  1312. br.Success = true
  1313. br.Ret = 200
  1314. br.IsAddLog = true
  1315. }
  1316. // @Title 公司线下调研、报名excel表格下载
  1317. // @Description 获取公司线下调研、报名excel表格下载接口
  1318. // @Param ActivityId query int true "活动ID"
  1319. // @Param ExcelType query int true "下载方式 0:全部名单、1:预约外呼名单、2:自主入会(自主拨入)名单"
  1320. // @Success 200 导出成功
  1321. // @router /activitySignup/signupFailExport [get]
  1322. func (this *ActivitySignupCoAntroller) SignupFailExport() {
  1323. br := new(models.BaseResponse).Init()
  1324. defer func() {
  1325. this.Data["json"] = br
  1326. this.ServeJSON()
  1327. }()
  1328. AdminUser := this.SysUser
  1329. if AdminUser == nil {
  1330. br.Msg = "请登录"
  1331. br.ErrMsg = "请登录,SysUser Is Empty"
  1332. return
  1333. }
  1334. activityId, _ := this.GetInt("ActivityId")
  1335. excelType, _ := this.GetInt("ExcelType")
  1336. //signupType := this.GetString("SignupType")
  1337. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  1338. if activityInfo == nil {
  1339. br.Msg = "活动不存在"
  1340. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  1341. return
  1342. }
  1343. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  1344. resp := new(cygx.CanDownload)
  1345. adminInfo, errAdmin := system.GetSysUserById(AdminUser.AdminId)
  1346. if errAdmin != nil {
  1347. br.Msg = "获取失败"
  1348. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  1349. return
  1350. }
  1351. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  1352. resp.IsCanDownload = true
  1353. }
  1354. sqlStr := ""
  1355. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3 || activityInfo.IsYidongConduct == 1) {
  1356. //权益申请销售只能看到自己名下的客户的申请 查研观向11.1
  1357. companyIds, err := cygxService.GetAdminLookUserCompanyIds(AdminUser)
  1358. if err != nil {
  1359. br.Msg = "获取失败"
  1360. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  1361. return
  1362. }
  1363. var companyIdstr []string
  1364. for _, v := range companyIds {
  1365. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  1366. }
  1367. sqlStr += ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `)`
  1368. }
  1369. sqlStrOther := sqlStr
  1370. var listReminder []*cygx.CygxAppointmentList
  1371. var summaryList []*cygx.CygxAppointmentList
  1372. var err error
  1373. //消息提醒
  1374. listReminder, err = cygx.GetCygxActivityMeetingReminderList(activityId, sqlStrOther)
  1375. if err != nil {
  1376. br.Msg = "获取失败"
  1377. br.ErrMsg = "获取失败,Err:" + err.Error()
  1378. return
  1379. }
  1380. //预约纪要
  1381. summaryList, err = cygx.GetCygxAppointmentSummaryList(activityId, sqlStrOther)
  1382. if err != nil {
  1383. br.Msg = "获取失败"
  1384. br.ErrMsg = "获取失败,Err:" + err.Error()
  1385. return
  1386. }
  1387. if excelType == 1 {
  1388. sqlStr += ` AND s.signup_type = 1 `
  1389. } else if excelType == 2 {
  1390. sqlStr += ` AND s.signup_type IN (2,4) `
  1391. }
  1392. //}
  1393. list, err := cygx.GetCygxAppointmentList(activityId, sqlStr)
  1394. if err != nil {
  1395. br.Msg = "获取失败"
  1396. br.ErrMsg = "获取失败,Err:" + err.Error()
  1397. return
  1398. }
  1399. return
  1400. //创建excel
  1401. dir, err := os.Executable()
  1402. exPath := filepath.Dir(dir)
  1403. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  1404. xlsxFile := xlsx.NewFile()
  1405. if err != nil {
  1406. br.Msg = "生成文件失败"
  1407. br.ErrMsg = "生成文件失败"
  1408. return
  1409. }
  1410. style := xlsx.NewStyle()
  1411. alignment := xlsx.Alignment{
  1412. Horizontal: "center",
  1413. Vertical: "center",
  1414. WrapText: true,
  1415. }
  1416. style.Alignment = alignment
  1417. style.ApplyAlignment = true
  1418. for pidIndex := 0; pidIndex <= 2; pidIndex++ {
  1419. //只做专家电话会,分析师电话会的多Sheel下载
  1420. if activityInfo.ActivityTypeId != 1 && activityInfo.ActivityTypeId != 2 {
  1421. if pidIndex > 0 {
  1422. continue
  1423. }
  1424. }
  1425. var sheetName string
  1426. var listDate []*cygx.CygxAppointmentList
  1427. if pidIndex == 0 {
  1428. sheetName = "报名名单"
  1429. listDate = list
  1430. } else if pidIndex == 1 {
  1431. sheetName = "消息提醒名单"
  1432. listDate = listReminder
  1433. } else if pidIndex == 2 {
  1434. sheetName = "预约纪要名单"
  1435. listDate = summaryList
  1436. }
  1437. sheet, err := xlsxFile.AddSheet(sheetName)
  1438. if err != nil {
  1439. br.Msg = "新增Sheet失败"
  1440. br.ErrMsg = "新增Sheet失败,Err:" + err.Error()
  1441. return
  1442. }
  1443. //标头
  1444. if pidIndex == 0 {
  1445. if activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3 || (activityInfo.ActivityTypeId == 7 && activityInfo.IsYidongConduct == 1) {
  1446. rowTitle := sheet.AddRow()
  1447. cellA := rowTitle.AddCell()
  1448. cellA.Value = "姓名"
  1449. cellB := rowTitle.AddCell()
  1450. cellB.Value = "外呼号码"
  1451. cellC := rowTitle.AddCell()
  1452. cellC.Value = "国际代码"
  1453. cellD := rowTitle.AddCell()
  1454. cellD.Value = "邮箱"
  1455. cellE := rowTitle.AddCell()
  1456. cellE.Value = "公司名称"
  1457. cellF := rowTitle.AddCell()
  1458. cellF.Value = "所属销售"
  1459. for _, item := range listDate {
  1460. row := sheet.AddRow()
  1461. cellA := row.AddCell()
  1462. cellA.Value = item.RealName
  1463. cellB := row.AddCell()
  1464. cellB.Value = item.OutboundMobile
  1465. cellC := row.AddCell()
  1466. cellC.Value = item.CountryCode
  1467. cellD := row.AddCell()
  1468. cellD.Value = item.Email
  1469. cellE := row.AddCell()
  1470. cellE.Value = item.CompanyName
  1471. cellF := row.AddCell()
  1472. cellF.Value = item.SellerName
  1473. }
  1474. } else {
  1475. rowTitle := sheet.AddRow()
  1476. cellA := rowTitle.AddCell()
  1477. cellA.Value = "姓名"
  1478. cellB := rowTitle.AddCell()
  1479. cellB.Value = "公司名称"
  1480. cellC := rowTitle.AddCell()
  1481. cellC.Value = "所属销售"
  1482. for _, item := range listDate {
  1483. row := sheet.AddRow()
  1484. cellA := row.AddCell()
  1485. cellA.Value = item.RealName
  1486. cellB := row.AddCell()
  1487. cellB.Value = item.CompanyName
  1488. cellC := row.AddCell()
  1489. cellC.Value = item.SellerName
  1490. }
  1491. }
  1492. } else {
  1493. rowTitle := sheet.AddRow()
  1494. cellA := rowTitle.AddCell()
  1495. cellA.Value = "姓名"
  1496. cellB := rowTitle.AddCell()
  1497. cellB.Value = "公司名称"
  1498. cellC := rowTitle.AddCell()
  1499. cellC.Value = "所属销售"
  1500. for _, item := range listDate {
  1501. row := sheet.AddRow()
  1502. cellA := row.AddCell()
  1503. cellA.Value = item.RealName
  1504. cellB := row.AddCell()
  1505. cellB.Value = item.CompanyName
  1506. cellC := row.AddCell()
  1507. cellC.Value = item.SellerName
  1508. }
  1509. }
  1510. }
  1511. err = xlsxFile.Save(downLoadnFilePath)
  1512. if err != nil {
  1513. br.Msg = "保存文件失败"
  1514. br.ErrMsg = "保存文件失败"
  1515. return
  1516. }
  1517. //randStr := time.Now().Format(utils.FormatDateTimeUnSpace)
  1518. downloadFileName := activityInfo.ActivityName + ".xlsx"
  1519. this.Ctx.Output.Download(downLoadnFilePath, downloadFileName)
  1520. defer func() {
  1521. os.Remove(downLoadnFilePath)
  1522. }()
  1523. //添加操作日志记录
  1524. br.Success = true
  1525. br.Ret = 200
  1526. br.Msg = "导出成功"
  1527. br.IsAddLog = true
  1528. }
  1529. // @Title 修改外呼号码
  1530. // @Description 修改外呼号码接口
  1531. // @Param request body cygx.OutboundMobileEditResp true "type json string"
  1532. // @Success 200 操作成功
  1533. // @router /activitySignup/outboundMobileEdit [post]
  1534. func (this *ActivitySignupCoAntroller) OutboundMobileEdit() {
  1535. br := new(models.BaseResponse).Init()
  1536. defer func() {
  1537. this.Data["json"] = br
  1538. this.ServeJSON()
  1539. }()
  1540. sysUser := this.SysUser
  1541. if sysUser == nil {
  1542. br.Msg = "请登录"
  1543. br.ErrMsg = "请登录,SysUser Is Empty"
  1544. return
  1545. }
  1546. var req cygx.OutboundMobileEditResp
  1547. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1548. if err != nil {
  1549. br.Msg = "参数解析异常!"
  1550. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1551. return
  1552. }
  1553. id := req.Id
  1554. outboundMobile := req.OutboundMobile
  1555. countryCode := req.CountryCode
  1556. total, err := cygx.GetCygxSignupCountFile(id)
  1557. if err != nil {
  1558. br.Msg = "获取失败"
  1559. br.ErrMsg = "获取失败,Err:" + err.Error()
  1560. return
  1561. }
  1562. if total == 0 {
  1563. br.Msg = "获取报名信息失败"
  1564. br.ErrMsg = "获取失败,id:" + strconv.Itoa(id)
  1565. return
  1566. }
  1567. err = cygx.OutboundMobileEdit(id, outboundMobile, countryCode)
  1568. if err != nil {
  1569. br.Msg = "修改失败"
  1570. br.ErrMsg = "修改失败 Err:" + err.Error()
  1571. return
  1572. }
  1573. br.Ret = 200
  1574. br.Success = true
  1575. br.Msg = "操作成功"
  1576. br.IsAddLog = true
  1577. }
  1578. // @Title 单条报名详情
  1579. // @Description 获取单条报名详情接口
  1580. // @Param Id query int true "报名ID"
  1581. // @Success Ret=200 {object} cygx.CygxActivitySignup
  1582. // @router /activitySignup/signupDetail [get]
  1583. func (this *ActivitySignupCoAntroller) SignupDetail() {
  1584. br := new(models.BaseResponse).Init()
  1585. defer func() {
  1586. this.Data["json"] = br
  1587. this.ServeJSON()
  1588. }()
  1589. AdminUser := this.SysUser
  1590. if AdminUser == nil {
  1591. br.Msg = "请登录"
  1592. br.ErrMsg = "请登录,用户信息为空"
  1593. br.Ret = 408
  1594. return
  1595. }
  1596. id, _ := this.GetInt("Id")
  1597. if id < 1 {
  1598. br.Msg = "请输入报名ID"
  1599. return
  1600. }
  1601. detail, err := cygx.GetActivitySignupInfoById(id)
  1602. if err != nil {
  1603. br.Msg = "报名信息不存在"
  1604. br.ErrMsg = "报名信息ID错误,Err:" + err.Error() + "id:" + strconv.Itoa(id)
  1605. return
  1606. }
  1607. br.Ret = 200
  1608. br.Success = true
  1609. br.Msg = "获取成功"
  1610. br.Data = detail
  1611. }
  1612. // @Title 新增报名人员
  1613. // @Description 新增报名人员接口
  1614. // @Param request body cygx.AddMeetingReminderReq true "type json string"
  1615. // @Success 200 操作成功
  1616. // @router /activitySignup/addSignuUser [post]
  1617. func (this *ActivitySignupCoAntroller) AddSignuUser() {
  1618. br := new(models.BaseResponse).Init()
  1619. defer func() {
  1620. this.Data["json"] = br
  1621. this.ServeJSON()
  1622. }()
  1623. AdminUser := this.SysUser
  1624. if AdminUser == nil {
  1625. br.Msg = "请登录"
  1626. br.ErrMsg = "请登录,SysUser Is Empty"
  1627. return
  1628. }
  1629. var req cygx.AddMeetingReminderReq
  1630. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1631. if err != nil {
  1632. br.Msg = "参数解析异常!"
  1633. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1634. return
  1635. }
  1636. adminInfo, err := system.GetSysUserById(AdminUser.AdminId)
  1637. if err != nil {
  1638. br.Msg = "添加失败"
  1639. br.ErrMsg = "获取管理员信息失败,Err:" + err.Error()
  1640. return
  1641. }
  1642. var items []*cygx.CygxActivitySignup
  1643. var itemsYidong []*cygx.YidongActivitySignup
  1644. var itemsAppointment []*cygx.CygxActivityAppointment
  1645. mapYidongActivity := make(map[int]int)
  1646. activityIds := req.ActivityIds
  1647. uidList := req.List
  1648. if activityIds == "" {
  1649. br.Msg = "请选择活动"
  1650. br.ErrMsg = "活动ID不能为空"
  1651. return
  1652. }
  1653. //获取已经报名成功的用户,给没有成功的或者没有报名的用户发送模版消息
  1654. mapSignupSuccess := make(map[string]int)
  1655. var itemsSendWxMsg []*cygx.CygxSignupUser
  1656. var condition string
  1657. var pars []interface{}
  1658. condition = ` AND do_fail_type = 0 AND activity_id IN (` + activityIds + `) `
  1659. listSignup, err := cygx.GetActivitySignupList(condition, pars)
  1660. if err != nil && err.Error() != utils.ErrNoRow() {
  1661. br.Msg = "添加报名失败"
  1662. br.ErrMsg = "添加报名失败,Err:GetActivitySignupList:" + err.Error()
  1663. }
  1664. for _, v := range listSignup {
  1665. mapSignupSuccess[fmt.Sprint("UID_", v.UserId, "AID_", v.ActivityId)] = v.ActivityId
  1666. }
  1667. activityIdList := strings.Split(activityIds, ",")
  1668. var uids string
  1669. for _, v := range uidList {
  1670. uids += strconv.Itoa(v.UserId) + ","
  1671. }
  1672. uids = strings.TrimRight(uids, ",")
  1673. mapCompanyPeople := make(map[string]int)
  1674. checkIsYidongConduct := make(map[string]int)
  1675. for _, v := range uidList {
  1676. uid := v.UserId
  1677. wxUser, userErr := models.GetWxUserByUserId(uid)
  1678. if userErr != nil {
  1679. br.Msg = "编辑失败!查询用户信息失败"
  1680. br.ErrMsg = "查询用户信息失败,Err:" + userErr.Error() + "用户UID:" + strconv.Itoa(uid) + "不存在"
  1681. return
  1682. }
  1683. for _, vact := range activityIdList {
  1684. activityId, _ := strconv.Atoi(vact)
  1685. activityInfo, err := cygx.GetAddActivityInfoById(activityId)
  1686. if err != nil {
  1687. br.Msg = "活动不存在"
  1688. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  1689. return
  1690. }
  1691. // 如果是易董的办会,且不提供外呼,而且管理员还勾选了预约外呼,那么做判断
  1692. if activityInfo.IsYidongConduct == 1 && activityInfo.IsCanOutboundCall == 0 && v.SignupType == 1 {
  1693. br.Msg = "此活动不提供外呼"
  1694. br.ErrMsg = "此活动不提供外呼,Err:activityId:" + strconv.Itoa(activityId)
  1695. return
  1696. }
  1697. //同时 勾选一个易懂办会,一个非易懂办会的活动 的判断
  1698. checkIsYidongConduct[strconv.Itoa(activityInfo.IsYidongConduct)] = activityInfo.IsYidongConduct
  1699. if len(checkIsYidongConduct) > 1 {
  1700. br.Msg = "活动类型不同,无法同时新增报名"
  1701. br.ErrMsg = "活动类型不同,Err:activityIds:" + activityIds
  1702. return
  1703. }
  1704. if activityInfo.YidongActivityId != "" {
  1705. errMsg := cygxService.CheckYidongActivitySignupTime(activityInfo)
  1706. if errMsg != "" {
  1707. br.Msg = errMsg
  1708. br.ErrMsg = errMsg + "Err:activityId:" + strconv.Itoa(activityId)
  1709. return
  1710. }
  1711. mapYidongActivity[activityInfo.ActivityId] = activityInfo.ActivityId
  1712. }
  1713. activityTypeId := activityInfo.ActivityTypeId
  1714. if adminInfo.RoleTypeCode != "admin" {
  1715. havePower, err := cygxService.GetActivityDetailUserPower(wxUser, adminInfo, activityInfo)
  1716. if err != nil {
  1717. br.Msg = "用户权限校验失败!"
  1718. br.ErrMsg = "GetActivityDetailUserPower,Err:" + err.Error() + fmt.Sprint("UserId", wxUser.UserId, "ActivityId:", activityInfo.ActivityId)
  1719. return
  1720. }
  1721. if !havePower {
  1722. br.Msg = "当前活动对该客户不可见,无法报名"
  1723. br.ErrMsg = "活动ID:" + strconv.Itoa(activityId) + "活动名称:" + activityInfo.ActivityName + "用户ID:" + strconv.Itoa(int(wxUser.UserId))
  1724. return
  1725. }
  1726. popupMsg, err := cygxService.CheckActivityUserAll(activityInfo, wxUser)
  1727. if err != nil {
  1728. br.Msg = "报名失败!"
  1729. br.ErrMsg = "CheckActivityUserAll,Err:" + err.Error()
  1730. return
  1731. }
  1732. if popupMsg != "" {
  1733. br.Msg = fmt.Sprint("报名失败!用户:", wxUser.RealName, popupMsg)
  1734. return
  1735. }
  1736. if activityInfo.YidongActivityId == "" {
  1737. if activityTypeId == 1 || activityTypeId == 2 {
  1738. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  1739. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  1740. br.Msg = "报名名单已发送至办会平台,请联系相关人员处理。"
  1741. return
  1742. }
  1743. }
  1744. }
  1745. //弘则的不做校验
  1746. if activityInfo.IsLimitPeople == 1 && wxUser.CompanyId != utils.HZ_COMPANY_ID {
  1747. //单机构两人限制
  1748. {
  1749. sqlStr := ` AND s.do_fail_type = 0`
  1750. listSignUp, err := cygx.GetCygxAppointmentList(activityId, sqlStr)
  1751. if err != nil && err.Error() != utils.ErrNoRow() {
  1752. br.Msg = "获取失败"
  1753. br.ErrMsg = "获取失败,Err:" + err.Error()
  1754. return
  1755. }
  1756. for _, v := range listSignUp {
  1757. mapCompanyPeople[fmt.Sprint("CID_", v.CompanyId, "AID_", activityId)]++
  1758. }
  1759. mapCompanyPeople[fmt.Sprint("CID_", wxUser.CompanyId, "AID_", activityId)]++
  1760. if mapCompanyPeople[fmt.Sprint("CID_", wxUser.CompanyId, "AID_", activityId)] > 2 {
  1761. br.Msg = "新增失败," + wxUser.RealName + "单机构2人限制。"
  1762. br.ErrMsg = wxUser.RealName + "单机构2人限制"
  1763. return
  1764. }
  1765. }
  1766. //爽约限制
  1767. //{
  1768. // totalRestrict, err := cygx.GetUserRestrictCount(wxUser.Mobile)
  1769. // if err != nil {
  1770. // br.Msg = "获取信息失败"
  1771. // br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  1772. // return
  1773. // }
  1774. // if totalRestrict >= 1 {
  1775. // br.Msg = "新增失败," + wxUser.RealName + "爽约次数过多。"
  1776. // br.ErrMsg = wxUser.RealName + "由于爽约次数过多,暂时被限制报名资格"
  1777. // return
  1778. // }
  1779. //}
  1780. }
  1781. }
  1782. limitPeopleNum, _ := strconv.Atoi(activityInfo.LimitPeopleNum)
  1783. //获取这个活动已经报名的用户数量
  1784. totalSignup, errSignup := cygx.GetActivitySignupCountByActivityId(activityId)
  1785. if errSignup != nil {
  1786. br.Msg = "获取失败"
  1787. br.ErrMsg = "获取失败,Err:" + errSignup.Error()
  1788. return
  1789. }
  1790. //获取这个活动中输入的这些用户的报名数量
  1791. totalThisUser, errThisUser := cygx.GetActivitySignupCountByThisUser(activityId, uids)
  1792. if errThisUser != nil {
  1793. br.Msg = "获取失败"
  1794. br.ErrMsg = "获取失败,Err:" + errThisUser.Error()
  1795. return
  1796. }
  1797. //如果是限制人数的就做报名人数限制判断
  1798. if activityInfo.IsLimitPeople == 1 {
  1799. if limitPeopleNum < totalSignup+len(uidList)-totalThisUser {
  1800. br.Msg = "新增失败,活动人数超限"
  1801. br.ErrMsg = "当前活动报名人数已满,活动:" + activityInfo.ActivityName
  1802. return
  1803. }
  1804. }
  1805. total, errtotal := cygx.GetActivitySignupCount(uid, activityId)
  1806. if errtotal != nil {
  1807. br.Msg = "获取失败"
  1808. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  1809. return
  1810. }
  1811. //判断这个用户是否报名了,如果没有报名则写入报名数据
  1812. if total == 0 {
  1813. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  1814. if err != nil {
  1815. br.Msg = "获取失败"
  1816. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  1817. return
  1818. }
  1819. item := new(cygx.CygxActivitySignup)
  1820. item.UserId = infoUser.UserId
  1821. item.RealName = infoUser.RealName
  1822. item.SellerName = infoUser.SellerName
  1823. item.ActivityId = activityId
  1824. item.CreateTime = time.Now()
  1825. item.Mobile = infoUser.Mobile
  1826. item.Mobile = infoUser.Mobile
  1827. item.Email = infoUser.Email
  1828. item.CompanyId = infoUser.CompanyId
  1829. item.CompanyName = infoUser.CompanyName
  1830. //优先绑定用户修改过的外呼手机号
  1831. if infoUser.OutboundMobile != "" {
  1832. item.OutboundMobile = infoUser.OutboundMobile
  1833. if infoUser.OutboundCountryCode == "" {
  1834. item.CountryCode = "86"
  1835. } else {
  1836. item.CountryCode = infoUser.OutboundCountryCode
  1837. }
  1838. } else {
  1839. item.OutboundMobile = infoUser.Mobile
  1840. if infoUser.CountryCode == "" {
  1841. item.CountryCode = "86"
  1842. } else {
  1843. item.CountryCode = infoUser.CountryCode
  1844. }
  1845. }
  1846. //如果不填报名方式,则默认为我要报名这种方式
  1847. if v.SignupType == 0 {
  1848. item.SignupType = 3
  1849. } else {
  1850. item.SignupType = v.SignupType
  1851. }
  1852. item.Source = 2
  1853. items = append(items, item)
  1854. if activityInfo.YidongActivityId != "" {
  1855. itemYidong := new(cygx.YidongActivitySignup)
  1856. itemYidong.YidongActivityId = activityInfo.YidongActivityId
  1857. itemYidong.Mobile = item.Mobile
  1858. itemYidong.RealName = item.RealName
  1859. itemYidong.CompanyName = item.CompanyName
  1860. itemYidong.CountryCode = item.CountryCode
  1861. itemYidong.ActivityJoinType = activityInfo.ActivityJoinType
  1862. itemsYidong = append(itemsYidong, itemYidong)
  1863. }
  1864. }
  1865. if v.IsAppointment == 1 {
  1866. total, errtotal := cygx.GetUserCygxActivityAppointmentCount(uid, activityId)
  1867. if errtotal != nil {
  1868. br.Msg = "获取失败"
  1869. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  1870. return
  1871. }
  1872. //var isHideAppointment bool
  1873. //if activityInfo.IsCanAppointmentMinutes == 1 {
  1874. // isHideAppointment = cygxService.IsShowAppointmentByadminSet(activityInfo.IsCanAppointmentMinutes)
  1875. //}
  1876. if activityInfo.IsCanAppointmentMinutes == 0 {
  1877. br.Msg = "该活动无法预约纪要"
  1878. br.ErrMsg = "该活动无法预约纪要,Err:" + activityInfo.ActivityName
  1879. return
  1880. }
  1881. //判断这个用户是否报名了,如果没有报名则写入报名数据
  1882. if total == 0 {
  1883. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  1884. if err != nil {
  1885. br.Msg = "获取失败"
  1886. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  1887. return
  1888. }
  1889. itemAppointment := new(cygx.CygxActivityAppointment)
  1890. itemAppointment.UserId = infoUser.UserId
  1891. itemAppointment.RealName = infoUser.RealName
  1892. itemAppointment.SellerName = infoUser.SellerName
  1893. itemAppointment.ActivityId = activityId
  1894. itemAppointment.CreateTime = time.Now()
  1895. itemAppointment.Mobile = infoUser.Mobile
  1896. itemAppointment.Email = infoUser.Email
  1897. itemAppointment.CompanyId = infoUser.CompanyId
  1898. itemAppointment.CompanyName = infoUser.CompanyName
  1899. itemAppointment.Source = 2
  1900. itemAppointment.AdminId = adminInfo.AdminId
  1901. itemsAppointment = append(itemsAppointment, itemAppointment)
  1902. }
  1903. }
  1904. if mapSignupSuccess[fmt.Sprint("UID_", uid, "AID_", activityId)] == 0 {
  1905. itemsSendWxMsg = append(itemsSendWxMsg, &cygx.CygxSignupUser{UserId: uid, ActivityId: activityId})
  1906. }
  1907. }
  1908. }
  1909. //mapYidongActivity := make(map[int]int)
  1910. err = cygx.AddCygxActivitySignup(items, itemsAppointment, mapYidongActivity)
  1911. if err != nil {
  1912. br.Msg = "操作失败"
  1913. br.ErrMsg = "新增用户失败,Err:" + err.Error()
  1914. return
  1915. }
  1916. //如果有值就向易董推送后台添加的报名信息
  1917. if len(itemsYidong) > 0 {
  1918. go cygxService.YidongActivityUserSingnUp(itemsYidong)
  1919. }
  1920. //销售或后台管理员给用户添加报名之后,进行模版消息推送
  1921. if len(itemsSendWxMsg) > 0 {
  1922. go cygxService.SendWxMsgWithCygxActivitySignUpBySell(itemsSendWxMsg)
  1923. }
  1924. if len(items) > 0 {
  1925. //1用户报名添加到处理研选扣点
  1926. for _, v := range items {
  1927. go cygxService.YanXuanActivityPointsBillSignupAdd(v.ActivityId, v.UserId, adminInfo.AdminId)
  1928. }
  1929. }
  1930. //添加操作日志记录
  1931. br.IsAddLog = true
  1932. br.IsSendEmail = false
  1933. br.Ret = 200
  1934. br.Success = true
  1935. br.Msg = "操作成功"
  1936. }
  1937. // @Title 带问列表详情
  1938. // @Description 获取带问列表详情接口
  1939. // @Param ActivityId query int true "活动ID"
  1940. // @Success 200 {object} cygx.ActivityHelpAskListResp
  1941. // @router /activitySignup/askList [get]
  1942. func (this *ActivitySignupCoAntroller) AskList() {
  1943. br := new(models.BaseResponse).Init()
  1944. defer func() {
  1945. this.Data["json"] = br
  1946. this.ServeJSON()
  1947. }()
  1948. sysUser := this.SysUser
  1949. if sysUser == nil {
  1950. br.Msg = "请登录"
  1951. br.ErrMsg = "请登录,SysUser Is Empty"
  1952. return
  1953. }
  1954. activityId, _ := this.GetInt("ActivityId")
  1955. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  1956. if activityInfo == nil {
  1957. br.Msg = "活动不存在"
  1958. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  1959. return
  1960. }
  1961. list, err := cygx.GetActivityHelpAskList(activityId)
  1962. respist := new(cygx.ActivityHelpAskListResp)
  1963. if err != nil {
  1964. br.Msg = "获取失败"
  1965. br.ErrMsg = "获取失败,Err:" + err.Error()
  1966. return
  1967. }
  1968. respist.List = list
  1969. br.Ret = 200
  1970. br.Success = true
  1971. br.Msg = "获取成功"
  1972. br.Data = respist
  1973. }
  1974. // @Title 带问详情excel表格下载
  1975. // @Description 带问详情excel表格下载接口
  1976. // @Param ActivityId query int true "活动ID"
  1977. // @Success 200 导出成功
  1978. // @router /activitySignup/askListExport [get]
  1979. func (this *ActivitySignupCoAntroller) AskListExport() {
  1980. br := new(models.BaseResponse).Init()
  1981. defer func() {
  1982. this.Data["json"] = br
  1983. this.ServeJSON()
  1984. }()
  1985. AdminUser := this.SysUser
  1986. if AdminUser == nil {
  1987. br.Msg = "请登录"
  1988. br.ErrMsg = "请登录,SysUser Is Empty"
  1989. return
  1990. }
  1991. activityId, _ := this.GetInt("ActivityId")
  1992. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  1993. if activityInfo == nil {
  1994. br.Msg = "活动不存在"
  1995. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  1996. return
  1997. }
  1998. list, err := cygx.GetActivityHelpAskList(activityId)
  1999. if err != nil {
  2000. br.Msg = "获取失败"
  2001. br.ErrMsg = "获取失败,Err:" + err.Error()
  2002. return
  2003. }
  2004. //创建excel
  2005. dir, err := os.Executable()
  2006. exPath := filepath.Dir(dir)
  2007. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  2008. xlsxFile := xlsx.NewFile()
  2009. if err != nil {
  2010. br.Msg = "生成文件失败"
  2011. br.ErrMsg = "生成文件失败"
  2012. return
  2013. }
  2014. style := xlsx.NewStyle()
  2015. alignment := xlsx.Alignment{
  2016. Horizontal: "center",
  2017. Vertical: "center",
  2018. WrapText: true,
  2019. }
  2020. style.Alignment = alignment
  2021. style.ApplyAlignment = true
  2022. sheet, err := xlsxFile.AddSheet("名单")
  2023. if err != nil {
  2024. br.Msg = "新增Sheet失败"
  2025. br.ErrMsg = "新增Sheet失败,Err:" + err.Error()
  2026. return
  2027. }
  2028. //标头
  2029. rowTitle := sheet.AddRow()
  2030. cellA := rowTitle.AddCell()
  2031. cellA.Value = "姓名"
  2032. cellB := rowTitle.AddCell()
  2033. cellB.Value = "公司名称"
  2034. cellC := rowTitle.AddCell()
  2035. cellC.Value = "问题"
  2036. cellD := rowTitle.AddCell()
  2037. cellD.Value = "提交时间"
  2038. for _, item := range list {
  2039. row := sheet.AddRow()
  2040. cellA := row.AddCell()
  2041. cellA.Value = item.RealName
  2042. cellB := row.AddCell()
  2043. cellB.Value = item.CompanyName
  2044. cellC := row.AddCell()
  2045. cellC.Value = item.Content
  2046. cellD := row.AddCell()
  2047. cellD.Value = item.CreateTime
  2048. }
  2049. err = xlsxFile.Save(downLoadnFilePath)
  2050. if err != nil {
  2051. br.Msg = "保存文件失败"
  2052. br.ErrMsg = "保存文件失败"
  2053. return
  2054. }
  2055. randStr := time.Now().Format(utils.FormatDateTimeUnSpace)
  2056. downloadFileName := "问题列表" + randStr + ".xlsx"
  2057. this.Ctx.Output.Download(downLoadnFilePath, downloadFileName)
  2058. defer func() {
  2059. os.Remove(downLoadnFilePath)
  2060. }()
  2061. //添加操作日志记录
  2062. br.IsAddLog = true
  2063. br.Success = true
  2064. br.Ret = 200
  2065. br.Msg = "导出成功"
  2066. }
  2067. // @Title 新增报名人员(可择报名方式)
  2068. // @Description 新增报名人员(可择报名方式)接口
  2069. // @Param request body cygx.AddOutboundPersonnelJsonItm true "type json string"
  2070. // @Success 200 操作成功
  2071. // @router /activitySignup/addSignuUserOptType [post]
  2072. func (this *ActivitySignupCoAntroller) AddSignuUserOptType() {
  2073. br := new(models.BaseResponse).Init()
  2074. defer func() {
  2075. this.Data["json"] = br
  2076. this.ServeJSON()
  2077. }()
  2078. AdminUser := this.SysUser
  2079. if AdminUser == nil {
  2080. br.Msg = "请登录"
  2081. br.ErrMsg = "请登录,SysUser Is Empty"
  2082. return
  2083. }
  2084. var req cygx.AddOutboundPersonnelJsonItm
  2085. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2086. if err != nil {
  2087. br.Msg = "参数解析异常!"
  2088. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2089. return
  2090. }
  2091. adminInfo, err := system.GetSysUserById(AdminUser.AdminId)
  2092. if err != nil {
  2093. br.Msg = "添加失败"
  2094. br.ErrMsg = "获取管理员信息失败,Err:" + err.Error()
  2095. return
  2096. }
  2097. jsonStr := req.JsonStar
  2098. var config cygx.RequestCommonPolicyConfig
  2099. err = json.Unmarshal([]byte(jsonStr), &config.CommonPolicyconfigs)
  2100. if err != nil {
  2101. br.Msg = "参数解析异常!"
  2102. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2103. return
  2104. }
  2105. var uids string
  2106. for _, v := range config.CommonPolicyconfigs {
  2107. uids += strconv.Itoa(v.Uid) + ","
  2108. }
  2109. uids = strings.TrimRight(uids, ",")
  2110. var items []*cygx.CygxActivitySignup
  2111. activityIds := req.ActivityIds
  2112. uidList := strings.Split(uids, ",")
  2113. activityIdList := strings.Split(activityIds, ",")
  2114. for _, v := range config.CommonPolicyconfigs {
  2115. uid := v.Uid
  2116. wxUser, userErr := models.GetWxUserByUserId(uid)
  2117. if userErr != nil {
  2118. br.Msg = "编辑失败!查询用户信息失败"
  2119. br.ErrMsg = "查询用户信息失败,Err:" + userErr.Error() + "用户UID:" + strconv.Itoa(uid) + "不存在"
  2120. return
  2121. }
  2122. for _, vact := range activityIdList {
  2123. activityId, _ := strconv.Atoi(vact)
  2124. activityInfo, err := cygx.GetAddActivityInfoById(activityId)
  2125. if err != nil {
  2126. br.Msg = "活动不存在"
  2127. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  2128. return
  2129. }
  2130. if adminInfo.RoleTypeCode != "admin" {
  2131. havePower := cygxService.CheckaddSignuUserPower(wxUser.CompanyId, activityId, activityInfo)
  2132. if !havePower {
  2133. br.Msg = "当前活动对该客户不可见,无法报名"
  2134. br.ErrMsg = "活动ID:" + strconv.Itoa(activityId) + "活动名称:" + activityInfo.ActivityName + "用户ID:" + strconv.Itoa(int(wxUser.UserId))
  2135. return
  2136. }
  2137. }
  2138. limitPeopleNum, _ := strconv.Atoi(activityInfo.LimitPeopleNum)
  2139. //获取这个活动已经报名的用户数量
  2140. totalSignup, errSignup := cygx.GetActivitySignupCountByActivityId(activityId)
  2141. if errSignup != nil {
  2142. br.Msg = "获取失败"
  2143. br.ErrMsg = "获取失败,Err:" + errSignup.Error()
  2144. return
  2145. }
  2146. //获取这个活动中输入的这些用户的报名数量
  2147. totalThisUser, errThisUser := cygx.GetActivitySignupCountByThisUser(activityId, uids)
  2148. if errThisUser != nil {
  2149. br.Msg = "获取失败"
  2150. br.ErrMsg = "获取失败,Err:" + errThisUser.Error()
  2151. return
  2152. }
  2153. if limitPeopleNum < totalSignup+len(uidList)-totalThisUser {
  2154. br.Msg = "当前活动报名人数已满"
  2155. br.ErrMsg = "当前活动报名人数已满,活动:" + activityInfo.ActivityName
  2156. return
  2157. }
  2158. total, errtotal := cygx.GetActivitySignupCount(uid, activityId)
  2159. if errtotal != nil {
  2160. br.Msg = "获取失败"
  2161. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  2162. return
  2163. }
  2164. //判断这个用户是否报名了,如果没有报名则写入报名数据
  2165. if total == 0 {
  2166. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  2167. if err != nil {
  2168. br.Msg = "获取失败"
  2169. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  2170. return
  2171. }
  2172. item := new(cygx.CygxActivitySignup)
  2173. item.UserId = infoUser.UserId
  2174. item.RealName = infoUser.RealName
  2175. item.SellerName = infoUser.SellerName
  2176. item.ActivityId = activityId
  2177. item.CreateTime = time.Now()
  2178. item.Mobile = infoUser.Mobile
  2179. item.Email = infoUser.Email
  2180. item.CompanyId = infoUser.CompanyId
  2181. item.CompanyName = infoUser.CompanyName
  2182. //优先绑定用户修改过的外呼手机号
  2183. if infoUser.OutboundMobile != "" {
  2184. item.OutboundMobile = infoUser.OutboundMobile
  2185. if infoUser.OutboundCountryCode == "" {
  2186. item.CountryCode = "86"
  2187. } else {
  2188. item.CountryCode = infoUser.OutboundCountryCode
  2189. }
  2190. } else {
  2191. item.OutboundMobile = infoUser.Mobile
  2192. if infoUser.CountryCode == "" {
  2193. item.CountryCode = "86"
  2194. } else {
  2195. item.CountryCode = infoUser.CountryCode
  2196. }
  2197. }
  2198. signupType, _ := strconv.Atoi(v.Type)
  2199. item.SignupType = signupType
  2200. item.Source = 2
  2201. items = append(items, item)
  2202. }
  2203. }
  2204. }
  2205. err = cygx.AddCygxActivitySignupUser(items)
  2206. if err != nil {
  2207. br.Msg = "操作失败"
  2208. br.ErrMsg = "新增用户失败,Err:" + err.Error()
  2209. return
  2210. }
  2211. //添加操作日志记录
  2212. br.IsAddLog = true
  2213. br.Ret = 200
  2214. br.Success = true
  2215. br.Msg = "操作成功"
  2216. }
  2217. // @Title 活动取消报名
  2218. // @Description 活动取消报名接口
  2219. // @Param request body cygx.CygxSignupId true "type json string"
  2220. // @Success Ret=200
  2221. // @router /activitySignup/cancel [post]
  2222. func (this *ActivitySignupCoAntroller) SignupCancel() {
  2223. br := new(models.BaseResponse).Init()
  2224. defer func() {
  2225. this.Data["json"] = br
  2226. this.ServeJSON()
  2227. }()
  2228. AdminUser := this.SysUser
  2229. if AdminUser == nil {
  2230. br.Msg = "请登录"
  2231. br.ErrMsg = "请登录,SysUser Is Empty"
  2232. return
  2233. }
  2234. var req cygx.CygxSignupId
  2235. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2236. if err != nil {
  2237. br.Msg = "参数解析异常!"
  2238. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2239. return
  2240. }
  2241. adminInfo, err := system.GetSysUserById(AdminUser.AdminId)
  2242. if err != nil {
  2243. br.Msg = "添加失败"
  2244. br.ErrMsg = "获取管理员信息失败,Err:" + err.Error()
  2245. return
  2246. }
  2247. signupId := req.SignupId
  2248. cancelClass := req.CancelClass
  2249. detail, err := cygx.GetActivitySignupInfoById(signupId)
  2250. if err != nil {
  2251. br.Msg = "报名信息不存在"
  2252. br.ErrMsg = "报名信息ID错误,Err:" + err.Error() + "id:" + strconv.Itoa(signupId)
  2253. return
  2254. }
  2255. activityInfo, err := cygx.GetAddActivityInfoById(detail.ActivityId)
  2256. if err != nil {
  2257. br.Msg = "操作失败"
  2258. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(detail.ActivityId)
  2259. return
  2260. }
  2261. if cancelClass == 1 {
  2262. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  2263. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  2264. br.Msg = "活动开始前1小时内无法取消外呼,提示:外呼名单已发送专家组,请联系专家组取消"
  2265. return
  2266. }
  2267. }
  2268. activityTypeId := activityInfo.ActivityTypeId
  2269. if adminInfo.RoleTypeCode != "admin" {
  2270. if activityTypeId == 1 || activityTypeId == 2 {
  2271. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  2272. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  2273. br.Msg = "报名名单已发送至办会平台,请联系相关人员处理。"
  2274. br.ErrMsg = fmt.Sprint("UserId:", detail.UserId, "ActivityId:", detail.ActivityId)
  2275. return
  2276. }
  2277. }
  2278. //取消报名截止时间校验
  2279. //if activityInfo.CancelDeadline != utils.EmptyDateTimeStr {
  2280. // cancelDeadline := utils.StrTimeToTime(activityInfo.CancelDeadline) //时间字符串格式转时间格式
  2281. // if time.Now().After(cancelDeadline) {
  2282. // br.Msg = "当前时间晚于取消报名截止时间,已无法取消报名。"
  2283. // br.ErrMsg = fmt.Sprint("UserId:", detail.UserId, "ActivityId:", detail.ActivityId)
  2284. // return
  2285. // }
  2286. //}
  2287. }
  2288. _, err = cygx.CancelActivitySignup(detail)
  2289. if err != nil {
  2290. br.Msg = "操作失败"
  2291. br.ErrMsg = "操作失败,Err:" + err.Error()
  2292. return
  2293. }
  2294. go cygxService.YanXuanActivityPointsBillSignupCancel(detail.ActivityId, detail.UserId, adminInfo.AdminId)
  2295. //添加操作日志记录
  2296. br.IsAddLog = true
  2297. br.Ret = 200
  2298. br.Success = true
  2299. br.Msg = "操作成功"
  2300. }
  2301. // @Title 预约纪要详情
  2302. // @Description 预约纪要详情列表接口
  2303. // @Param ActivityId query int true "活动ID"
  2304. // @Success 200 {object} cygx.GetAppointmentListRep
  2305. // @router /activitySignup/appointment/summaryList [get]
  2306. func (this *ActivitySignupCoAntroller) SummaryList() {
  2307. br := new(models.BaseResponse).Init()
  2308. defer func() {
  2309. this.Data["json"] = br
  2310. this.ServeJSON()
  2311. }()
  2312. sysUser := this.SysUser
  2313. if sysUser == nil {
  2314. br.Msg = "请登录"
  2315. br.ErrMsg = "请登录,SysUser Is Empty"
  2316. return
  2317. }
  2318. activityId, _ := this.GetInt("ActivityId")
  2319. if activityId < 1 {
  2320. br.Msg = "活动不存在"
  2321. return
  2322. }
  2323. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  2324. if activityInfo == nil {
  2325. br.Msg = "活动不存在"
  2326. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  2327. return
  2328. }
  2329. var isShowMobile bool
  2330. if activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3 {
  2331. isShowMobile = true
  2332. }
  2333. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  2334. resp := new(cygx.CanDownload)
  2335. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  2336. if errAdmin != nil {
  2337. br.Msg = "获取失败"
  2338. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  2339. return
  2340. }
  2341. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  2342. resp.IsCanDownload = true
  2343. }
  2344. memberType := "Admin"
  2345. sqlStr := ""
  2346. totalStr := sqlStr
  2347. if isShowMobile {
  2348. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3) {
  2349. //权益申请销售只能看到自己名下的客户的申请
  2350. companyIds, err := cygxService.GetAdminLookUserCompanyIds(sysUser)
  2351. if err != nil {
  2352. br.Msg = "获取失败"
  2353. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  2354. return
  2355. }
  2356. var companyIdstr []string
  2357. for _, v := range companyIds {
  2358. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  2359. }
  2360. sqlStr += ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `) `
  2361. }
  2362. }
  2363. list, err := cygx.GetCygxAppointmentSummaryList(activityId, sqlStr)
  2364. if err != nil {
  2365. br.Msg = "获取失败"
  2366. br.ErrMsg = "获取失败,Err:" + err.Error()
  2367. return
  2368. }
  2369. total, errtotal := cygx.GetCygxAppointmentSummaryCount(activityId, totalStr)
  2370. if errtotal != nil {
  2371. br.Msg = "获取失败"
  2372. br.ErrMsg = "客户总数获取失败,Err:" + errtotal.Error()
  2373. return
  2374. }
  2375. myTotal, errmyTotal := cygx.GetCygxAppointmentSummaryCount(activityId, sqlStr)
  2376. if errmyTotal != nil {
  2377. br.Msg = "获取失败"
  2378. br.ErrMsg = "我的客户总数获取失败,Err:" + errmyTotal.Error()
  2379. return
  2380. }
  2381. for k, v := range list {
  2382. list[k].SellerName = v.PsellerName
  2383. if !isShowMobile {
  2384. list[k].Mobile = ""
  2385. }
  2386. }
  2387. respList := new(cygx.GetAppointmentListRep)
  2388. respList.List = list
  2389. respList.Total = total
  2390. respList.MyTotal = myTotal
  2391. respList.ActivityId = activityId
  2392. respList.IsLimitPeople = activityInfo.IsLimitPeople
  2393. respList.MemberType = memberType
  2394. activityTypeId := activityInfo.ActivityTypeId
  2395. //ExcelType string `description:"EXcel下载类型 AppointmentCall:预约外呼、ExpertSalon:专家沙龙报名、Teleconference:公司调研电话会、OfflineResearch:公司线下调研 "`
  2396. if activityTypeId == 1 || activityTypeId == 2 {
  2397. respList.ExcelType = "AppointmentCall"
  2398. } else if activityTypeId == 5 || activityTypeId == 6 {
  2399. respList.ExcelType = "ExpertSalon"
  2400. } else if activityTypeId == 3 {
  2401. respList.ExcelType = "Teleconference"
  2402. } else if activityTypeId == 4 {
  2403. respList.ExcelType = "OfflineResearch"
  2404. }
  2405. if isShowMobile {
  2406. respList.ActivityType = 1
  2407. }
  2408. br.Ret = 200
  2409. br.Success = true
  2410. br.Msg = "获取成功"
  2411. br.Data = respList
  2412. }
  2413. // @Title 新增预约纪要人员
  2414. // @Description 新增预约纪要人员接口
  2415. // @Param request body cygx.AddOutboundPersonnelItm true "type json string"
  2416. // @Success 200 操作成功
  2417. // @router /activitySignup/appointment/addSummaryUser [post]
  2418. func (this *ActivitySignupCoAntroller) AddSummaryUser() {
  2419. br := new(models.BaseResponse).Init()
  2420. defer func() {
  2421. this.Data["json"] = br
  2422. this.ServeJSON()
  2423. }()
  2424. AdminUser := this.SysUser
  2425. if AdminUser == nil {
  2426. br.Msg = "请登录"
  2427. br.ErrMsg = "请登录,SysUser Is Empty"
  2428. return
  2429. }
  2430. var req cygx.AddOutboundPersonnelItm
  2431. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2432. if err != nil {
  2433. br.Msg = "参数解析异常!"
  2434. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2435. return
  2436. }
  2437. adminInfo, err := system.GetSysUserById(AdminUser.AdminId)
  2438. if err != nil {
  2439. br.Msg = "添加失败"
  2440. br.ErrMsg = "获取管理员信息失败,Err:" + err.Error()
  2441. return
  2442. }
  2443. var items []*cygx.CygxActivityAppointment
  2444. uids := req.UserIds
  2445. activityIds := req.ActivityIds
  2446. uidList := strings.Split(uids, ",")
  2447. activityIdList := strings.Split(activityIds, ",")
  2448. for _, v := range uidList {
  2449. uid, err := strconv.Atoi(v)
  2450. if err != nil {
  2451. br.Msg = "操作失败"
  2452. br.ErrMsg = "查询用户信息失败,Err:" + err.Error()
  2453. return
  2454. }
  2455. wxUser, userErr := models.GetWxUserByUserId(uid)
  2456. if userErr != nil {
  2457. br.Msg = "编辑失败!查询用户信息失败"
  2458. br.ErrMsg = "查询用户信息失败,Err:" + userErr.Error() + "用户UID:" + strconv.Itoa(uid) + "不存在"
  2459. return
  2460. }
  2461. for _, vact := range activityIdList {
  2462. activityId, _ := strconv.Atoi(vact)
  2463. activityInfo, err := cygx.GetAddActivityInfoById(activityId)
  2464. if err != nil {
  2465. br.Msg = "活动不存在"
  2466. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  2467. return
  2468. }
  2469. if adminInfo.RoleTypeCode != "admin" {
  2470. //havePower := cygxService.CheckaddSignuUserPower(wxUser.CompanyId, activityId, activityInfo)
  2471. havePower, err := cygxService.GetActivityDetailUserPower(wxUser, AdminUser, activityInfo)
  2472. if err != nil {
  2473. br.Msg = "用户权限校验失败!"
  2474. br.ErrMsg = "GetActivityDetailUserPower,Err:" + err.Error() + fmt.Sprint("UserId", wxUser.UserId, "ActivityId:", activityInfo.ActivityId)
  2475. return
  2476. }
  2477. if !havePower {
  2478. br.Msg = "当前活动对该客户不可见,无法报名"
  2479. br.ErrMsg = "活动ID:" + strconv.Itoa(activityId) + "活动名称:" + activityInfo.ActivityName + "用户ID:" + strconv.Itoa(int(wxUser.UserId))
  2480. return
  2481. }
  2482. }
  2483. //isHideAppointment := cygxService.IsShowAppointmentByadminSet(activityInfo.IsCanAppointmentMinutes)
  2484. if activityInfo.IsCanAppointmentMinutes == 0 {
  2485. br.Msg = "当前活动无法新增预约纪要" + activityInfo.ActivityName
  2486. return
  2487. }
  2488. //if cygxService.CheckActivityAddAppointment(activityInfo) {
  2489. // br.Msg = "当前活动无法新增预约纪要" + activityInfo.ActivityName
  2490. // return
  2491. //}
  2492. total, errtotal := cygx.GetUserCygxActivityAppointmentCount(uid, activityId)
  2493. if errtotal != nil {
  2494. br.Msg = "获取失败"
  2495. br.ErrMsg = "获取失败,Err:" + errtotal.Error()
  2496. return
  2497. }
  2498. //判断这个用户是否报名了,如果没有报名则写入报名数据
  2499. if total == 0 {
  2500. infoUser, err := cygx.GetUserAndCompanyNameList(uid)
  2501. if err != nil {
  2502. br.Msg = "获取失败"
  2503. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  2504. return
  2505. }
  2506. item := new(cygx.CygxActivityAppointment)
  2507. item.UserId = infoUser.UserId
  2508. item.RealName = infoUser.RealName
  2509. item.SellerName = infoUser.SellerName
  2510. item.ActivityId = activityId
  2511. item.CreateTime = time.Now()
  2512. item.Mobile = infoUser.Mobile
  2513. item.Email = infoUser.Email
  2514. item.CompanyId = infoUser.CompanyId
  2515. item.CompanyName = infoUser.CompanyName
  2516. item.Source = 2
  2517. items = append(items, item)
  2518. }
  2519. }
  2520. }
  2521. err = cygx.AddCygxActivityAppointmentUser(items)
  2522. if err != nil {
  2523. br.Msg = "操作失败"
  2524. br.ErrMsg = "新增用户失败,Err:" + err.Error()
  2525. return
  2526. }
  2527. //添加操作日志记录
  2528. br.IsAddLog = true
  2529. br.Ret = 200
  2530. br.Success = true
  2531. br.Msg = "操作成功"
  2532. }
  2533. // @Title 取消纪要纪要预约
  2534. // @Description 取消纪要纪要预约接口
  2535. // @Param request body cygx.CygxSignupId true "type json string"
  2536. // @Success Ret=200
  2537. // @router /activitySignup/appointment/cancel [post]
  2538. func (this *ActivitySignupCoAntroller) SummaryCancel() {
  2539. br := new(models.BaseResponse).Init()
  2540. defer func() {
  2541. this.Data["json"] = br
  2542. this.ServeJSON()
  2543. }()
  2544. AdminUser := this.SysUser
  2545. if AdminUser == nil {
  2546. br.Msg = "请登录"
  2547. br.ErrMsg = "请登录,SysUser Is Empty"
  2548. return
  2549. }
  2550. var req cygx.CygxSignupId
  2551. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2552. if err != nil {
  2553. br.Msg = "参数解析异常!"
  2554. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2555. return
  2556. }
  2557. signupId := req.SignupId
  2558. detail, err := cygx.GetCygxAppointmentSummaryInfoById(signupId)
  2559. if err != nil {
  2560. br.Msg = "预约信息不存在"
  2561. br.ErrMsg = "预约信息ID错误,Err:" + err.Error() + "id:" + strconv.Itoa(signupId)
  2562. return
  2563. }
  2564. _, err = cygx.CancelcygxActivityAppointment(detail)
  2565. if err != nil {
  2566. br.Msg = "操作失败"
  2567. br.ErrMsg = "操作失败,Err:" + err.Error()
  2568. return
  2569. }
  2570. //添加操作日志记录
  2571. br.IsAddLog = true
  2572. br.Ret = 200
  2573. br.Success = true
  2574. br.Msg = "操作成功"
  2575. }
  2576. // @Title 会议提醒人数详情
  2577. // @Description 会议提醒人数详情列表接口
  2578. // @Param ActivityId query int true "活动ID"
  2579. // @Success 200 {object} cygx.GetAppointmentListRep
  2580. // @router /activitySignup/reminder/list [get]
  2581. func (this *ActivitySignupCoAntroller) ReminderList() {
  2582. br := new(models.BaseResponse).Init()
  2583. defer func() {
  2584. this.Data["json"] = br
  2585. this.ServeJSON()
  2586. }()
  2587. sysUser := this.SysUser
  2588. if sysUser == nil {
  2589. br.Msg = "请登录"
  2590. br.ErrMsg = "请登录,SysUser Is Empty"
  2591. return
  2592. }
  2593. activityId, _ := this.GetInt("ActivityId")
  2594. if activityId < 1 {
  2595. br.Msg = "活动不存在"
  2596. return
  2597. }
  2598. activityInfo, _ := cygx.GetAddActivityInfoById(activityId)
  2599. if activityInfo == nil {
  2600. br.Msg = "活动不存在"
  2601. br.ErrMsg = "活动ID错误,Err:activityId:" + strconv.Itoa(activityId)
  2602. return
  2603. }
  2604. //超级管理员和权益管理员、权益研究员可以下载所有客户,销售组长能下载本组客户,销售只能下载本人名下客户
  2605. resp := new(cygx.CanDownload)
  2606. adminInfo, errAdmin := system.GetSysUserById(sysUser.AdminId)
  2607. if errAdmin != nil {
  2608. br.Msg = "获取失败"
  2609. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  2610. return
  2611. }
  2612. if adminInfo.Role == "admin" || adminInfo.Role == "researcher" {
  2613. resp.IsCanDownload = true
  2614. }
  2615. memberType := "Admin"
  2616. sqlStr := ""
  2617. totalStr := sqlStr
  2618. if resp.IsCanDownload == false && (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 3) {
  2619. //权益申请销售只能看到自己名下的客户的申请
  2620. companyIds, err := cygxService.GetAdminLookUserCompanyIds(sysUser)
  2621. if err != nil {
  2622. br.Msg = "获取失败"
  2623. br.ErrMsg = "获取失败,GetAdminLookUserCompanyIds Err:" + err.Error()
  2624. return
  2625. }
  2626. var companyIdstr []string
  2627. for _, v := range companyIds {
  2628. companyIdstr = append(companyIdstr, strconv.Itoa(v))
  2629. }
  2630. sqlStr += ` AND s.company_id IN (` + strings.Join(companyIdstr, ",") + `) `
  2631. }
  2632. list, err := cygx.GetCygxActivityMeetingReminderList(activityId, sqlStr)
  2633. if err != nil {
  2634. br.Msg = "获取失败"
  2635. br.ErrMsg = "获取失败,Err:" + err.Error()
  2636. return
  2637. }
  2638. total, errtotal := cygx.GetCygxActivityMeetingReminderCount(activityId, totalStr)
  2639. if errtotal != nil {
  2640. br.Msg = "获取失败"
  2641. br.ErrMsg = "客户总数获取失败,Err:" + errtotal.Error()
  2642. return
  2643. }
  2644. myTotal, errmyTotal := cygx.GetCygxActivityMeetingReminderCount(activityId, sqlStr)
  2645. if errmyTotal != nil {
  2646. br.Msg = "获取失败"
  2647. br.ErrMsg = "我的客户总数获取失败,Err:" + errmyTotal.Error()
  2648. return
  2649. }
  2650. if len(list) > 0 {
  2651. for k, v := range list {
  2652. list[k].SellerName = v.PsellerName
  2653. }
  2654. } else {
  2655. list = make([]*cygx.CygxAppointmentList, 0)
  2656. }
  2657. respList := new(cygx.GetAppointmentListRep)
  2658. respList.List = list
  2659. respList.Total = total
  2660. respList.MyTotal = myTotal
  2661. respList.ActivityId = activityId
  2662. respList.IsLimitPeople = activityInfo.IsLimitPeople
  2663. respList.MemberType = memberType
  2664. activityTypeId := activityInfo.ActivityTypeId
  2665. //ExcelType string `description:"EXcel下载类型 AppointmentCall:预约外呼、ExpertSalon:专家沙龙报名、Teleconference:公司调研电话会、OfflineResearch:公司线下调研 "`
  2666. if activityTypeId == 1 || activityTypeId == 2 {
  2667. respList.ExcelType = "AppointmentCall"
  2668. } else if activityTypeId == 5 || activityTypeId == 6 {
  2669. respList.ExcelType = "ExpertSalon"
  2670. } else if activityTypeId == 3 {
  2671. respList.ExcelType = "Teleconference"
  2672. } else if activityTypeId == 4 {
  2673. respList.ExcelType = "OfflineResearch"
  2674. }
  2675. br.Ret = 200
  2676. br.Success = true
  2677. br.Msg = "获取成功"
  2678. br.Data = respList
  2679. }
  2680. // @Title 取消会议提醒
  2681. // @Description 取消会议提醒接口
  2682. // @Param request body cygx.CygxSignupId true "type json string"
  2683. // @Success Ret=200
  2684. // @router /activitySignup/reminder/cancel [post]
  2685. func (this *ActivitySignupCoAntroller) ReminderCancel() {
  2686. br := new(models.BaseResponse).Init()
  2687. defer func() {
  2688. this.Data["json"] = br
  2689. this.ServeJSON()
  2690. }()
  2691. AdminUser := this.SysUser
  2692. if AdminUser == nil {
  2693. br.Msg = "请登录"
  2694. br.ErrMsg = "请登录,SysUser Is Empty"
  2695. return
  2696. }
  2697. var req cygx.CygxSignupId
  2698. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2699. if err != nil {
  2700. br.Msg = "参数解析异常!"
  2701. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2702. return
  2703. }
  2704. signupId := req.SignupId
  2705. detail, err := cygx.GetCygxActivityMeetingReminderInfoById(signupId)
  2706. if err != nil {
  2707. br.Msg = "预约信息不存在"
  2708. br.ErrMsg = "预约信息ID错误,Err:" + err.Error() + "id:" + strconv.Itoa(signupId)
  2709. return
  2710. }
  2711. _, err = cygx.CancelActivityMeetingReminder(detail)
  2712. if err != nil {
  2713. br.Msg = "操作失败"
  2714. br.ErrMsg = "操作失败,Err:" + err.Error()
  2715. return
  2716. }
  2717. //添加操作日志记录
  2718. br.IsAddLog = true
  2719. br.Ret = 200
  2720. br.Success = true
  2721. br.Msg = "操作成功"
  2722. }
  2723. // @Title 发送模版消息
  2724. // @Description 发送模版消息接口
  2725. // @Param request body cygx.AddOutboundPersonnelItm true "type json string"
  2726. // @Success 200 操作成功
  2727. // @router /activitySignup/tempMsg [post]
  2728. func (this *ActivitySignupCoAntroller) TempMsg() {
  2729. br := new(models.BaseResponse).Init()
  2730. defer func() {
  2731. this.Data["json"] = br
  2732. this.ServeJSON()
  2733. }()
  2734. AdminUser := this.SysUser
  2735. if AdminUser == nil {
  2736. br.Msg = "请登录"
  2737. br.ErrMsg = "请登录,SysUser Is Empty"
  2738. return
  2739. }
  2740. var req cygx.ActivitySignupTempMsgReq
  2741. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  2742. if err != nil {
  2743. br.Msg = "参数解析异常!"
  2744. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  2745. return
  2746. }
  2747. //adminInfo, err := system.GetSysUserById(AdminUser.AdminId)
  2748. //if err != nil {
  2749. // br.Msg = "添加失败"
  2750. // br.ErrMsg = "获取管理员信息失败,Err:" + err.Error()
  2751. // return
  2752. //}
  2753. idSlice := strings.Split(req.ActivityIds, ",")
  2754. for _, sId := range idSlice {
  2755. id, e := strconv.Atoi(sId)
  2756. if e != nil {
  2757. br.Msg = "活动Id参数异常"
  2758. br.ErrMsg = "参数解析异常, Err:" + e.Error()
  2759. return
  2760. }
  2761. var openIdList []*models.OpenIdList
  2762. idMap := make(map[string]string, 0)
  2763. if strings.Contains(req.SendGroup, "1") {
  2764. list, err := models.GetCygxUserIndustryFllowOpneidByActivityIds(id)
  2765. if err != nil {
  2766. br.Msg = "查询openId失败"
  2767. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2768. return
  2769. }
  2770. for _, idList := range list {
  2771. openIdList = append(openIdList, idList)
  2772. idMap[idList.OpenId] = idList.OpenId
  2773. }
  2774. }
  2775. if strings.Contains(req.SendGroup, "2") {
  2776. list, err := models.GetCygxForeverUserIndustryFllowOpneidByActivityIds(id)
  2777. if err != nil {
  2778. br.Msg = "查询openId失败"
  2779. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2780. return
  2781. }
  2782. for _, idList := range openIdList {
  2783. idMap[idList.OpenId] = idList.OpenId
  2784. }
  2785. for _, idList := range list {
  2786. if _, ok := idMap[idList.OpenId]; !ok {
  2787. openIdList = append(openIdList, idList)
  2788. idMap[idList.OpenId] = idList.OpenId
  2789. }
  2790. }
  2791. }
  2792. if strings.Contains(req.SendGroup, "3") {
  2793. list, err := cygxService.GetCygxBigTypeUserIndustryFllowOpneidByActivityIds(id)
  2794. if err != nil {
  2795. br.Msg = "查询openId失败"
  2796. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2797. return
  2798. }
  2799. for _, idList := range openIdList {
  2800. idMap[idList.OpenId] = idList.OpenId
  2801. }
  2802. for _, idList := range list {
  2803. if _, ok := idMap[idList.OpenId]; !ok {
  2804. openIdList = append(openIdList, idList)
  2805. idMap[idList.OpenId] = idList.OpenId
  2806. }
  2807. }
  2808. }
  2809. if strings.Contains(req.SendGroup, "4") {
  2810. list, err := cygxService.GetCygxIndustryPackageUserIndustryFllowOpneidByActivityIds(id)
  2811. if err != nil {
  2812. br.Msg = "查询openId失败"
  2813. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2814. return
  2815. }
  2816. for _, idList := range openIdList {
  2817. idMap[idList.OpenId] = idList.OpenId
  2818. }
  2819. for _, idList := range list {
  2820. if _, ok := idMap[idList.OpenId]; !ok {
  2821. openIdList = append(openIdList, idList)
  2822. idMap[idList.OpenId] = idList.OpenId
  2823. }
  2824. }
  2825. }
  2826. if strings.Contains(req.SendGroup, "5") {
  2827. list, err := cygxService.GetCygxOtherIndustryPackageUserIndustryFllowOpneidByActivityIds(id)
  2828. if err != nil {
  2829. br.Msg = "查询openId失败"
  2830. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2831. return
  2832. }
  2833. for _, idList := range openIdList {
  2834. idMap[idList.OpenId] = idList.OpenId
  2835. }
  2836. for _, idList := range list {
  2837. if _, ok := idMap[idList.OpenId]; !ok {
  2838. openIdList = append(openIdList, idList)
  2839. idMap[idList.OpenId] = idList.OpenId
  2840. }
  2841. }
  2842. }
  2843. if strings.Contains(req.SendGroup, "6") {
  2844. list, err := models.GetCygxTryOutUserIndustryFllowOpneidByActivityIds(id)
  2845. if err != nil {
  2846. br.Msg = "查询openId失败"
  2847. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2848. return
  2849. }
  2850. for _, idList := range openIdList {
  2851. idMap[idList.OpenId] = idList.OpenId
  2852. }
  2853. for _, idList := range list {
  2854. if _, ok := idMap[idList.OpenId]; !ok {
  2855. openIdList = append(openIdList, idList)
  2856. idMap[idList.OpenId] = idList.OpenId
  2857. }
  2858. }
  2859. }
  2860. if strings.Contains(req.SendGroup, "7") {
  2861. list, err := cygxService.GetCygxInteractiveUserOpneidByActivityIds(id)
  2862. if err != nil {
  2863. br.Msg = "查询openId失败"
  2864. br.ErrMsg = "查询openId失败,Err:" + err.Error()
  2865. return
  2866. }
  2867. for _, idList := range openIdList {
  2868. idMap[idList.OpenId] = idList.OpenId
  2869. }
  2870. for _, idList := range list {
  2871. if _, ok := idMap[idList.OpenId]; !ok {
  2872. openIdList = append(openIdList, idList)
  2873. idMap[idList.OpenId] = idList.OpenId
  2874. }
  2875. }
  2876. }
  2877. if len(openIdList) > 0 {
  2878. openIdArr := make([]string, len(openIdList))
  2879. for i, v := range openIdList {
  2880. openIdArr[i] = v.OpenId
  2881. }
  2882. sendInfo := new(services.SendWxTemplate)
  2883. //sendInfo.First = req.FirstText
  2884. sendInfo.Keyword1 = req.ActivityName
  2885. sendInfo.Keyword2 = req.Content
  2886. //sendInfo.Keyword3 = meetingTime
  2887. sendInfo.Remark = "点击查看活动详情"
  2888. sendInfo.TemplateId = utils.WxMsgTemplateIdActivityChangeApplyXzs
  2889. sendInfo.RedirectUrl = utils.WX_MSG_PATH_ACTIVITY_DETAIL + strconv.Itoa(id)
  2890. sendInfo.RedirectTarget = 3
  2891. sendInfo.Resource = strconv.Itoa(id)
  2892. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ACTIVITY_CUSTOMIZE
  2893. sendInfo.OpenIdArr = openIdArr
  2894. e = services.SendTemplateMsg(sendInfo)
  2895. if e != nil {
  2896. br.Msg = "推送模板消息失败!"
  2897. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  2898. return
  2899. }
  2900. }
  2901. }
  2902. br.Ret = 200
  2903. br.Success = true
  2904. br.Msg = "发送成功"
  2905. }
  2906. // @Title 模版消息发送客户类型列表
  2907. // @Description 模版消息发送客户类型列表接口
  2908. // @Success Ret=200
  2909. // @router /activitySignup/tempMsg/sendGroupList [get]
  2910. func (this *ActivitySignupCoAntroller) SendGroupList() {
  2911. br := new(models.BaseResponse).Init()
  2912. defer func() {
  2913. this.Data["json"] = br
  2914. this.ServeJSON()
  2915. }()
  2916. AdminUser := this.SysUser
  2917. if AdminUser == nil {
  2918. br.Msg = "请登录"
  2919. br.ErrMsg = "请登录,SysUser Is Empty"
  2920. return
  2921. }
  2922. list := make([]cygx.SendGroup, 0)
  2923. list = append(list, cygx.SendGroup{
  2924. Id: 1,
  2925. Name: "全部客户",
  2926. })
  2927. list = append(list, cygx.SendGroup{
  2928. Id: 2,
  2929. Name: "永续客户",
  2930. })
  2931. list = append(list, cygx.SendGroup{
  2932. Id: 3,
  2933. Name: "大套餐客户",
  2934. })
  2935. list = append(list, cygx.SendGroup{
  2936. Id: 4,
  2937. Name: "行业套餐客户",
  2938. })
  2939. list = append(list, cygx.SendGroup{
  2940. Id: 5,
  2941. Name: "其他行业正式客户",
  2942. })
  2943. list = append(list, cygx.SendGroup{
  2944. Id: 6,
  2945. Name: "试用客户",
  2946. })
  2947. list = append(list, cygx.SendGroup{
  2948. Id: 7,
  2949. Name: "已参与互动的客户",
  2950. })
  2951. br.Ret = 200
  2952. br.Success = true
  2953. br.Data = list
  2954. }