article.go 58 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646
  1. package services
  2. import (
  3. "context"
  4. "encoding/json"
  5. "fmt"
  6. "github.com/PuerkitoBio/goquery"
  7. "github.com/beego/beego/v2/client/orm"
  8. "hongze/hongze_cygx/models"
  9. "hongze/hongze_cygx/utils"
  10. "html"
  11. "net/url"
  12. "strconv"
  13. "strings"
  14. "time"
  15. "unicode/utf8"
  16. )
  17. func GetReportContentSub(content string) (contentSub string, err error) {
  18. content = html.UnescapeString(content)
  19. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  20. if err != nil {
  21. fmt.Println("create doc err:", err.Error())
  22. return
  23. }
  24. n := 0
  25. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  26. if n > 3 {
  27. return
  28. }
  29. n++
  30. phtml, err := s.Html()
  31. if err != nil {
  32. fmt.Println("get html err", err.Error())
  33. return
  34. }
  35. if s.Text() != "" || strings.Contains(phtml, "src") {
  36. contentSub = contentSub + "<p>" + phtml + "</p>"
  37. }
  38. })
  39. return
  40. }
  41. func GetReportContentTextSub(content string) (contentSub string, err error) {
  42. content = html.UnescapeString(content)
  43. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  44. docText := doc.Text()
  45. bodyRune := []rune(docText)
  46. bodyRuneLen := len(bodyRune)
  47. if bodyRuneLen > 200 {
  48. bodyRuneLen = 200
  49. }
  50. body := string(bodyRune[:bodyRuneLen])
  51. contentSub = body
  52. contentSub = strings.Replace(body, "Powered by Froala Editor", "", -1)
  53. return
  54. }
  55. func GetReportContentTextSubNew(content string) (contentSub string, err error) {
  56. content = html.UnescapeString(content)
  57. doc, errdoc := goquery.NewDocumentFromReader(strings.NewReader(content))
  58. if errdoc != nil {
  59. err = errdoc
  60. return
  61. }
  62. docText := doc.Text()
  63. bodyRune := []rune(docText)
  64. bodyRuneLen := len(bodyRune)
  65. body := string(bodyRune[:bodyRuneLen])
  66. contentSub = body
  67. contentSub = strings.Replace(contentSub, "Powered by Froala Editor", "", -1)
  68. contentSub = strings.Replace(contentSub, " ", "", -1)
  69. contentSub = strings.Replace(contentSub, "<p data-f-id=\"pbf\" style=\"text-align: center; font-size: 14px; margin-top: 30px; opacity: 0.65; font-family: sanered by <a href=\"https://www.froala.com/wysiwyg-editor?pb=1\" title=\"Froala Editor\">Froala Editor</a></p>", "", -1)
  70. return
  71. }
  72. //GetReportContentTextSubByarticle 解析文章内容
  73. func GetReportContentTextSubByarticle(content, abstract string, articleId int) (contentSub string, err error) {
  74. var lenabstract int
  75. //如果不是研选就这么展示
  76. if articleId < utils.SummaryArticleId {
  77. abstract = html.UnescapeString(abstract)
  78. doc, errdoc := goquery.NewDocumentFromReader(strings.NewReader(abstract))
  79. if errdoc != nil {
  80. err = errdoc
  81. return
  82. }
  83. docabstract := doc.Text()
  84. lenabstract = utf8.RuneCountInString(docabstract)
  85. if lenabstract >= 20 {
  86. contentSub = docabstract
  87. return
  88. } else {
  89. contentSub, err = GetReportContentTextSubNew(content)
  90. }
  91. } else {
  92. contentSub, err = GetReportContentTextSubNew(content)
  93. }
  94. return
  95. }
  96. //解析文章内容
  97. func GetArticleAll() {
  98. var err error
  99. defer func() {
  100. if err != nil {
  101. fmt.Println("err:", err.Error())
  102. return
  103. }
  104. }()
  105. list, err := models.GetArticleAll()
  106. if err != nil {
  107. return
  108. }
  109. for _, v := range list {
  110. fmt.Println(v.ArticleId, v.Title)
  111. FixArticleContent(v.ArticleId)
  112. }
  113. }
  114. //解析报告
  115. func FixArticleContent(articleId int) {
  116. item, err := models.GetArticleDetailById(articleId)
  117. if err != nil {
  118. fmt.Println("GetArticleDetailById Err:" + err.Error())
  119. return
  120. }
  121. content := item.Body
  122. bodyText, _ := GetReportContentTextSub(content)
  123. content = html.UnescapeString(content)
  124. content = strings.Replace(content, "http", "https", -1)
  125. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  126. if err != nil {
  127. fmt.Println("create doc err:", err.Error())
  128. return
  129. }
  130. var expertNumArr []string
  131. var expertContentArr []string
  132. var interviewDateArr []string
  133. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  134. contentTxt := s.Text()
  135. if strings.Contains(contentTxt, "#访谈时间:") || strings.Contains(contentTxt, "访谈时间:") {
  136. interviewDate := s.Next().Text()
  137. interviewDateArr = append(interviewDateArr, interviewDate)
  138. }
  139. if strings.Contains(contentTxt, "#专家评价") || strings.Contains(contentTxt, "专家评价") {
  140. expertContent := s.Next().Text()
  141. if expertContent == "" {
  142. expertContent = contentTxt
  143. }
  144. if expertContent != "" {
  145. rightIndex := strings.Index(expertContent, ")")
  146. if rightIndex == 0 {
  147. rightIndex = strings.Index(expertContent, ")")
  148. }
  149. if rightIndex > 0 {
  150. expertNum := expertContent[:rightIndex]
  151. expertNum = strings.Replace(expertNum, "(", "", -1)
  152. expertNum = strings.Replace(expertNum, "(", "", -1)
  153. expertNum = strings.Replace(expertNum, "专家评价", "", -1)
  154. if expertNum != "" {
  155. expertNumArr = append(expertNumArr, expertNum)
  156. rightIndex = rightIndex
  157. expertContentStr := expertContent[rightIndex:]
  158. expertContentStr = strings.Replace(expertContentStr, ")", "", -1)
  159. expertContentStr = strings.TrimLeft(expertContentStr, ":")
  160. expertContentStr = strings.TrimRight(expertContentStr, "(推荐")
  161. expertContentArr = append(expertContentArr, expertContentStr)
  162. }
  163. }
  164. }
  165. }
  166. })
  167. if len(expertContentArr) <= 0 {
  168. doc.Find("pre").Each(func(i int, pre *goquery.Selection) {
  169. pre.Find("span").Each(func(n int, span *goquery.Selection) {
  170. contentTxt := span.Text()
  171. if strings.Contains(contentTxt, "#专家评价") || strings.Contains(contentTxt, "专家评价") {
  172. span.Find("span").Each(func(m int, subspan *goquery.Selection) {
  173. subspanText := subspan.Text()
  174. if strings.Contains(subspanText, "专家评价") {
  175. expertContent := subspan.Next().Text()
  176. if expertContent != "" {
  177. rightIndex := strings.Index(expertContent, ")")
  178. if rightIndex == 0 {
  179. rightIndex = strings.Index(expertContent, ")")
  180. }
  181. if rightIndex > 0 {
  182. expertNum := expertContent[:rightIndex]
  183. expertNum = strings.Replace(expertNum, "(", "", -1)
  184. expertNum = strings.Replace(expertNum, "(", "", -1)
  185. expertNum = strings.Replace(expertNum, "专家评价", "", -1)
  186. if expertNum != "" {
  187. expertNumArr = append(expertNumArr, expertNum)
  188. rightIndex = rightIndex
  189. expertContentStr := expertContent[rightIndex:]
  190. expertContentStr = strings.Replace(expertContentStr, ")", "", -1)
  191. expertContentStr = strings.TrimLeft(expertContentStr, ":")
  192. expertContentStr = strings.TrimRight(expertContentStr, "(推荐")
  193. expertContentArr = append(expertContentArr, expertContentStr)
  194. }
  195. }
  196. }
  197. }
  198. })
  199. }
  200. span.Find("span").Each(func(k int, sspan *goquery.Selection) {
  201. sspanText := sspan.Text()
  202. if strings.Contains(sspanText, "访谈时间") {
  203. sspanText = strings.Replace(sspanText, "#访谈时间:", "", -1)
  204. sspanText = strings.Replace(sspanText, "访谈时间:", "", -1)
  205. sspanText = strings.Replace(sspanText, "\n", "", -1)
  206. sspanText = strings.Replace(sspanText, " ", "", -1)
  207. sspanText = strings.Trim(sspanText, " ")
  208. sspanText = sspanText[:10]
  209. interviewDate := sspanText
  210. if interviewDate != "" {
  211. interviewDateArr = append(interviewDateArr, interviewDate)
  212. }
  213. }
  214. })
  215. })
  216. })
  217. }
  218. if len(expertContentArr) <= 0 {
  219. doc.Find("span").Each(func(i int, span *goquery.Selection) {
  220. span.Find("strong").Each(func(n int, strong *goquery.Selection) {
  221. spanText := span.Text()
  222. strongText := strong.Text()
  223. if strings.Contains(strongText, "#专家评价") || strings.Contains(strongText, "专家评价") {
  224. expertContent := strong.Parents().Text()
  225. if expertContent != "" {
  226. rightIndex := strings.Index(expertContent, ")")
  227. if rightIndex == 0 {
  228. rightIndex = strings.Index(expertContent, ")")
  229. }
  230. if rightIndex > 0 {
  231. expertNum := expertContent[:rightIndex]
  232. expertNum = strings.Replace(expertNum, "(", "", -1)
  233. expertNum = strings.Replace(expertNum, "(", "", -1)
  234. expertNum = strings.Replace(expertNum, "专家评价", "", -1)
  235. expertNum = strings.Replace(expertNum, "#", "", -1)
  236. expertNum = strings.Replace(expertNum, ":", "", -1)
  237. expertNum = strings.Replace(expertNum, "\n", "", -1)
  238. if expertNum != "" {
  239. expertNumArr = append(expertNumArr, expertNum)
  240. rightIndex = rightIndex
  241. expertContentStr := expertContent[rightIndex:]
  242. expertContentStr = strings.Replace(expertContentStr, ")", "", -1)
  243. expertContentStr = strings.TrimLeft(expertContentStr, ":")
  244. expertContentStr = strings.TrimRight(expertContentStr, "(推荐")
  245. expertContentArr = append(expertContentArr, expertContentStr)
  246. return
  247. }
  248. }
  249. }
  250. }
  251. if strings.Contains(spanText, "访谈时间") {
  252. spanText = strings.Replace(spanText, "#访谈时间:", "", -1)
  253. spanText = strings.Replace(spanText, "访谈时间:", "", -1)
  254. spanText = strings.Replace(spanText, "\n", "", -1)
  255. spanText = strings.Replace(spanText, " ", "", -1)
  256. spanText = strings.Trim(spanText, " ")
  257. spanText = spanText[:10]
  258. interviewDate := spanText
  259. if interviewDate != "" {
  260. interviewDateArr = append(interviewDateArr, interviewDate)
  261. }
  262. }
  263. })
  264. })
  265. }
  266. var expertNumStr, expertContentStr, interviewDateStr string
  267. if len(expertNumArr) > 0 {
  268. expertNumStr = expertNumArr[0]
  269. }
  270. if len(expertContentArr) > 0 {
  271. expertContentStr = expertContentArr[0]
  272. }
  273. if len(interviewDateArr) > 0 {
  274. interviewDateStr = interviewDateArr[0]
  275. }
  276. expertNumStr = strings.Replace(expertNumStr, "#:", "", -1)
  277. err = models.ModifyArticleExpert(articleId, expertNumStr, expertContentStr, interviewDateStr, bodyText)
  278. if err != nil {
  279. fmt.Println("ModifyArticleExpert Err:" + err.Error())
  280. return
  281. }
  282. }
  283. func FixArticleImgUrl(body string) (contentSub string, err error) {
  284. r := strings.NewReader(string(body))
  285. doc, err := goquery.NewDocumentFromReader(r)
  286. if err != nil {
  287. fmt.Println(err)
  288. }
  289. doc.Find("img").Each(func(i int, s *goquery.Selection) {
  290. src, _ := s.Attr("src")
  291. if i == 0 && src != "" {
  292. contentSub = src
  293. }
  294. })
  295. return
  296. }
  297. //获取标签里的第一个内容
  298. func FixArticleFirstCount(body string) (contentSub string, err error) {
  299. doc, err := goquery.NewDocumentFromReader(strings.NewReader(body))
  300. if err != nil {
  301. fmt.Println("create doc err:", err.Error())
  302. return
  303. }
  304. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  305. contentTxt := s.Text()
  306. fmt.Println(contentTxt)
  307. })
  308. return
  309. }
  310. func SynchronizationArtclehistory() {
  311. fmt.Println("同步开始")
  312. list, err := models.GetArticleHistoryList()
  313. if err != nil {
  314. fmt.Println("获取列表失败", err)
  315. }
  316. fmt.Println(len(list))
  317. for _, v := range list {
  318. //endDate := v.ModifyTime.Add(+time.Minute * 10).Format(utils.FormatDateTime)
  319. //detail, err := models.GetNewArticleHistoryRecordNewpv(v.UserId, v.ArticleId, endDate)
  320. //if err != nil && err.Error() != utils.ErrNoRow() {
  321. // fmt.Println("获取信息失败", err)
  322. //}
  323. v.OutType = 1
  324. //fmt.Println(v.Id)
  325. //if detail == nil {
  326. // _, err = models.AddCygxArticleViewRecordNewpv(v)
  327. // if err != nil {
  328. // fmt.Println("新增失败", err)
  329. // }
  330. //} else {
  331. // err = models.UpdateCygxArticleViewRecordNewpvList(v, v.StopTime)
  332. // if err != nil {
  333. // fmt.Println("修改失败", err)
  334. // }
  335. //}
  336. newId, err := models.AddCygxArticleViewRecordNewpv(v)
  337. fmt.Println("新增", newId)
  338. if err != nil {
  339. fmt.Println("新增失败", err)
  340. }
  341. }
  342. fmt.Println("同步结束")
  343. }
  344. //统计报表
  345. func StatisticalReport() {
  346. var isSummaryNumAll, isClassNum, pvNumAll, uvNumAll int
  347. list, err := models.GetChartPermissionActivity()
  348. if err != nil {
  349. fmt.Println("获取列表失败", err)
  350. }
  351. for _, v := range list {
  352. var listPv []*models.ReportMappingStatistical
  353. if v.PermissionName == "研选" {
  354. listPv, err = models.GetStatisticalReportArtilceExpert()
  355. if err != nil {
  356. fmt.Println("获取Pv列表失败", err)
  357. }
  358. } else {
  359. listPv, err = models.GetStatisticalReportArtilce(v.ChartPermissionId)
  360. if err != nil {
  361. fmt.Println("获取Pv列表失败", err)
  362. }
  363. }
  364. var pvNum, uvNum, isSummaryNum int
  365. for _, v2 := range listPv {
  366. pvNum += v2.Pv
  367. uvNum += v2.Uv
  368. if v2.IsSummary == "1" {
  369. isSummaryNum += 1
  370. }
  371. if v2.IsClass == "1" && v.ChartPermissionId <= 22 {
  372. isClassNum += 1
  373. }
  374. if v2.IsSummary == "1" && v.ChartPermissionId <= 22 {
  375. isSummaryNumAll += 1
  376. }
  377. }
  378. if v.ChartPermissionId <= 22 {
  379. pvNumAll += pvNum
  380. uvNumAll += uvNum
  381. }
  382. fmt.Println(v.PermissionName+"行业", len(listPv), "篇,其中主观类报告", isSummaryNum, "篇,客观类报告", len(listPv)-isSummaryNum, "篇。共产生阅读量pv-,", pvNum, ",uv-", uvNum)
  383. }
  384. fmt.Println("目前同步四大行业的总报告(已归类)数量", isClassNum, "篇,其中主观类报告", isSummaryNumAll, "篇,客观类报告", isClassNum-isSummaryNumAll, "篇。共产生阅读量pv-", pvNumAll, ",uv-", uvNumAll)
  385. var totalOnline int //线上
  386. var totalOffline int //线下
  387. var totalPeople int //共累计预约外呼人数
  388. var totalSignUpOff int //线下报名人数
  389. var totalSignUpOffTime int //线下报名人数
  390. var totalPeopleMeet int //线下参会人数
  391. o := orm.NewOrm()
  392. sql := `SELECT COUNT(1) FROM cygx_activity WHERE activity_type_id IN (1,2,3) AND publish_status = 1 AND is_submit_meeting = 1 AND activity_time <= NOW();`
  393. err = o.Raw(sql).QueryRow(&totalOnline)
  394. if err != nil {
  395. fmt.Println("获取线上", err)
  396. }
  397. sql = `SELECT COUNT(1) FROM cygx_activity WHERE activity_type_id IN (4,5,6) AND publish_status = 1 AND is_submit_meeting = 1 AND activity_time <= NOW();`
  398. err = o.Raw(sql).QueryRow(&totalOffline)
  399. if err != nil {
  400. fmt.Println("获取线下", err)
  401. }
  402. sql = `SELECT COUNT( 1 ) FROM
  403. cygx_activity_signup as s
  404. INNER JOIN cygx_activity as a ON a.activity_id = s.activity_id
  405. WHERE
  406. s.do_fail_type = 0
  407. AND a.is_submit_meeting = 1
  408. AND a.activity_time <= NOW()
  409. AND a.publish_status = 1`
  410. err = o.Raw(sql).QueryRow(&totalPeople)
  411. if err != nil {
  412. fmt.Println("共累计预约外呼人数", err)
  413. }
  414. sql = `SELECT COUNT( 1 ) FROM
  415. cygx_activity_signup as s
  416. INNER JOIN cygx_activity as a ON a.activity_id = s.activity_id
  417. WHERE
  418. s.do_fail_type = 0
  419. AND a.is_submit_meeting = 1
  420. AND a.activity_time <= NOW()
  421. AND a.activity_type_id IN (4,5,6)
  422. AND a.publish_status = 1`
  423. err = o.Raw(sql).QueryRow(&totalSignUpOff)
  424. if err != nil {
  425. fmt.Println("共累计预约外呼人数", err)
  426. }
  427. sql = `SELECT COUNT( 1 ) FROM
  428. cygx_activity_signup as s
  429. INNER JOIN cygx_activity as a ON a.activity_id = s.activity_id
  430. WHERE
  431. s.do_fail_type = 0
  432. AND a.publish_status = 1
  433. AND a.is_submit_meeting = 1
  434. AND a.activity_time <= NOW()
  435. AND a.is_submit_meeting = 1
  436. AND a.activity_type_id IN (4,5,6);`
  437. err = o.Raw(sql).QueryRow(&totalSignUpOffTime)
  438. if err != nil {
  439. fmt.Println("线下报名参会人数", err)
  440. }
  441. sql = `SELECT COUNT( 1 ) FROM
  442. cygx_activity_signup as s
  443. INNER JOIN cygx_activity as a ON a.activity_id = s.activity_id
  444. WHERE
  445. s.do_fail_type = 0
  446. AND a.is_submit_meeting = 1
  447. AND a.activity_time <= NOW()
  448. AND a.publish_status = 1
  449. AND s.is_meeting = 1
  450. AND a.activity_type_id IN (4,5,6);`
  451. err = o.Raw(sql).QueryRow(&totalPeopleMeet)
  452. if err != nil {
  453. fmt.Println("线下参会人数", err)
  454. }
  455. fmt.Println("共上线活动", totalOnline+totalOffline, "个,其中线上", totalOnline, "个,线下", totalOffline, "个")
  456. fmt.Println("共累计预约外呼人数", totalPeople, "人")
  457. fmt.Println("报名线下参会", totalSignUpOff, "人,实际到会人数", totalPeopleMeet, "人,线下到会率约", totalPeopleMeet*100/totalSignUpOff, "%")
  458. num := totalPeopleMeet / totalSignUpOffTime
  459. fmt.Println(num)
  460. fmt.Println(totalOnline)
  461. fmt.Println(totalOffline)
  462. fmt.Println(totalPeople)
  463. fmt.Println(totalSignUpOff)
  464. fmt.Println(totalPeopleMeet)
  465. fmt.Println(totalSignUpOffTime)
  466. fmt.Println(totalPeopleMeet / totalSignUpOffTime)
  467. return
  468. }
  469. // UserViewRedisData 阅读数据
  470. type UserViewRedisData struct {
  471. Mobile string `json:"mobile"`
  472. Email string `json:"email"`
  473. RealName string `json:"real_name"`
  474. CompanyName string `json:"company_name"`
  475. ViewTime string `json:"view_time" description:"阅读时间,格式:2022-02-17 13:06:13"`
  476. ProductId int `json:"product_id" description:"报告所属产品,ficc:1,权益:2"`
  477. CompanyId int `json:"company_id" description:"客户id"`
  478. }
  479. type ReportViewRecord struct {
  480. Id int `orm:"column(id);pk"`
  481. UserId int `description:"用户id"`
  482. ReportId int `description:"报告id"`
  483. Mobile string `description:"手机号"`
  484. Email string `description:"邮箱"`
  485. RealName string `description:"用户实际姓名"`
  486. CompanyName string `description:"公司名称"`
  487. CreateTime time.Time `description:"创建时间"`
  488. }
  489. // PushViewRecordNewRedisData 阅读数据加入到redis
  490. func PushViewRecordNewRedisData(reportViewRecord *ReportViewRecord, companyId int) bool {
  491. data := &UserViewRedisData{
  492. Mobile: reportViewRecord.Mobile,
  493. Email: reportViewRecord.Email,
  494. RealName: reportViewRecord.RealName,
  495. CompanyName: reportViewRecord.CompanyName,
  496. ViewTime: reportViewRecord.CreateTime.Format(utils.FormatDateTime),
  497. ProductId: 2,
  498. CompanyId: companyId,
  499. }
  500. if utils.Re == nil {
  501. err := utils.Rc.LPush(utils.CACHE_KEY_USER_VIEW, data)
  502. if err != nil {
  503. fmt.Println("PushViewRecordNewRedisData LPush Err:" + err.Error())
  504. }
  505. return true
  506. }
  507. return false
  508. }
  509. //func GetCeLueArticlePv() {
  510. // sum := 0
  511. // for i := 0; i <= 450; i++ {
  512. // if i >= 102 {
  513. // //GetCeLueArticlePvs(strconv.Itoa(i * 1000))
  514. // }
  515. // }
  516. // fmt.Println(sum)
  517. //}
  518. //获取策略平台报告阅读数据
  519. func GetCeLueArticlePv(cont context.Context) (err error) {
  520. defer func() {
  521. if err != nil {
  522. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  523. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  524. }
  525. }()
  526. startTime := time.Now().Add(-time.Minute * 12).Format("2006-01-02 15:04:05")
  527. endTime := time.Now().Format("2006-01-02 15:04:05")
  528. requestUrl := utils.ApiUrl + "backend/statistics_access?take=1000&skip=0&sort=ASC&mode=all&"
  529. encodeData := url.Values{}
  530. encodeData.Add("start_dt", startTime)
  531. encodeData.Add("end_dt", endTime)
  532. encodeStr := encodeData.Encode()
  533. requestUrl += encodeStr
  534. authorization := utils.ApiAuthorization
  535. body, err := PublicGetDate(requestUrl, authorization)
  536. if err != nil {
  537. return
  538. }
  539. var chartResult models.CeLueArticleResultApi
  540. err = json.Unmarshal(body, &chartResult)
  541. if err != nil {
  542. fmt.Println(err)
  543. return err
  544. }
  545. mapMobileArticleId := make(map[string]int)
  546. //获取当天阅读记录
  547. listPv, err := models.GetArticleHistoryRecordAllList()
  548. if err != nil && err.Error() != utils.ErrNoRow() {
  549. fmt.Println("获取当天阅读记录失败", err)
  550. return err
  551. }
  552. if len(listPv) > 0 {
  553. for _, v := range listPv {
  554. mapMobileArticleId[fmt.Sprint(v.Mobile, "_", v.ArticleId)] = v.ArticleId
  555. }
  556. }
  557. for _, v := range chartResult.Data {
  558. //fmt.Println(v.ArticleId)
  559. item := new(models.CygxCelueArticleHistoryRecord)
  560. item.CelueHistoryId = v.CelueHistoryId
  561. item.Mobile = v.Mobile
  562. item.ArticleId = v.ArticleId
  563. if v.CrmUser != nil {
  564. item.RealName = v.CrmUser.RealName
  565. }
  566. if v.CompanyName != nil {
  567. item.CompanyName = v.CompanyName.RealName
  568. }
  569. item.CreateDateApi = time.Now()
  570. t1, _ := time.Parse("2006-01-02T15:04:05Z", v.CreateDate)
  571. item.CreateTime = t1.Add(+time.Hour * 8).Format(utils.FormatDateTime)
  572. count, err := models.GetCeLueArticleCountById(v.CelueHistoryId)
  573. if err != nil && err.Error() != utils.ErrNoRow() {
  574. return err
  575. }
  576. if count == 0 {
  577. _, err := models.AddCeLueArticle(item, mapMobileArticleId)
  578. if err != nil {
  579. fmt.Println(err)
  580. return err
  581. }
  582. }
  583. }
  584. //处理同步过来的阅读记录所属用户
  585. var condition string
  586. condition = ` AND create_time > ` + "'" + startTime + "'"
  587. listArticlePv, err := models.GetArticleHistoryRecordAllByMobileList(condition)
  588. if err != nil {
  589. fmt.Println("GetArticleHistoryRecordAllByMobileList ,Err" + err.Error())
  590. }
  591. for _, v := range listArticlePv {
  592. if v.Mobile != "" {
  593. user, err := models.GetWxUserItemByMobile(v.Mobile)
  594. if err != nil && err.Error() != utils.ErrNoRow() {
  595. fmt.Println("GetWxUserItemByUserId ,Err" + err.Error())
  596. }
  597. if user != nil {
  598. err = models.UpdateCygxArticleHistoryRecordAll(user)
  599. if err != nil {
  600. fmt.Println("UpdateCygxArticleCollect ,Err" + err.Error())
  601. }
  602. }
  603. }
  604. }
  605. return
  606. }
  607. func GetArticleListByApi(cont context.Context) (err error) {
  608. defer func() {
  609. if err != nil {
  610. //fmt.Println("GetArticleListByApi Err:" + err.Error())
  611. go utils.SendAlarmMsg("同步策略平台数据失败", 2)
  612. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetArticleListByApi ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  613. }
  614. }()
  615. listUpdateArticle, err := models.GetArticleCeluePushList()
  616. if err != nil && err.Error() != utils.ErrNoRow() {
  617. return err
  618. }
  619. //如果长度为零就不处理
  620. if len(listUpdateArticle) == 0 {
  621. return err
  622. }
  623. for _, v := range listUpdateArticle {
  624. // 这里直接go出去会出现并发,导致文章md5ID唯一索引限制报错
  625. err = HandleArticleListByApi(v.ArticleId)
  626. if err != nil {
  627. utils.FileLog.Info("WxGetToken Result:%s ", err.Error())
  628. }
  629. }
  630. return
  631. }
  632. //func init() {
  633. // HandleArticleListByApi(7507)
  634. //}
  635. //处理同步过来的文章
  636. func HandleArticleListByApi(artcleId int) (err error) {
  637. defer func() {
  638. if err != nil {
  639. go utils.SendAlarmMsg("处理同步策略平台数据失败"+"GetArticleListByApi ErrMsg:"+err.Error(), 2)
  640. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetArticleListByApi ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  641. }
  642. }()
  643. var clueApiUrl string
  644. clueApiUrl = fmt.Sprint(utils.ApiUrl, "articles/", artcleId)
  645. fmt.Println(clueApiUrl)
  646. authorization := utils.ApiAuthorization
  647. body, err := PublicGetDate(clueApiUrl, authorization)
  648. if err != nil {
  649. fmt.Println(err)
  650. return
  651. }
  652. var articleResultDate models.ArticleDetailResultApi
  653. err = json.Unmarshal(body, &articleResultDate)
  654. if err != nil {
  655. fmt.Println("Getres.PublicGetDate Err:", err.Error())
  656. return err
  657. }
  658. item := new(models.CygxShanghaiCompanyLog)
  659. item.CreateTime = time.Now()
  660. item.Url = clueApiUrl
  661. item.Body = ""
  662. item.Result = string(body)
  663. go models.AddCygxShanghaiCompanyLog(item)
  664. articleResult := articleResultDate.Data
  665. exitMap := make(map[int]int)
  666. classMap := make(map[int]int)
  667. reportMap := make(map[int]int)
  668. summaryMap := make(map[int]int)
  669. listMap, err := models.GetArticleApiMap()
  670. if err != nil {
  671. fmt.Println("GetlistMap Err:", err.Error())
  672. return err
  673. }
  674. openIdList, err := models.GetUserRecordListByMobile(4, utils.ArticleTaskClassMobile)
  675. if err != nil {
  676. fmt.Println(err)
  677. return err
  678. }
  679. fmt.Println(openIdList)
  680. //新旧分类 反向隐射,是否归类,是否是报告,是否是纪要库
  681. for _, v := range listMap {
  682. exitMap[v.Id] = v.OldId
  683. if v.IsClass == 1 {
  684. classMap[v.OldId] = 1
  685. }
  686. if v.IsReport == 1 {
  687. reportMap[v.OldId] = 1
  688. }
  689. if v.IsSummary == 1 {
  690. summaryMap[v.OldId] = 1
  691. }
  692. }
  693. var list []*models.Tactics2
  694. var listAuthor []*models.CygxArticleAuthor
  695. //状态等于 2 跟 4 的进行同步
  696. if exitMap[articleResult.SeriesId] > 0 && (articleResult.PublishStatus == 2 || articleResult.PublishStatus == 4) {
  697. articleResult.PublishDate = time.Date(articleResult.PublishDate.Year(), articleResult.PublishDate.Month(), articleResult.PublishDate.Day(), articleResult.PublishDate.Hour(), articleResult.PublishDate.Minute(), articleResult.PublishDate.Second(), articleResult.PublishDate.Nanosecond(), time.Local)
  698. item := new(models.Tactics2)
  699. itemAuthor := new(models.CygxArticleAuthor)
  700. item.ArticleId = articleResult.ArticleId
  701. item.Title = articleResult.Title
  702. item.TitleEn = articleResult.TitleEn
  703. item.File = articleResult.File
  704. if articleResult.Frequency == "日度" {
  705. item.UpdateFrequency = "daily"
  706. } else if articleResult.Frequency == "周度" {
  707. item.UpdateFrequency = "weekly"
  708. } else if articleResult.Frequency == "月度" {
  709. item.UpdateFrequency = "monthly"
  710. } else if articleResult.Frequency == "季度" {
  711. item.UpdateFrequency = "quarterly"
  712. } else if articleResult.Frequency == "年度" {
  713. item.UpdateFrequency = "yearly"
  714. } else {
  715. item.UpdateFrequency = "unknow"
  716. }
  717. item.CreateDate = articleResult.CreateDate
  718. item.PublishDate = articleResult.PublishDate.Add(time.Hour * 8)
  719. item.PublishStatus = 1
  720. item.Body = articleResult.Content.Body
  721. item.Abstract = articleResult.Content.Abstract
  722. item.Annotation = articleResult.Content.Annotation
  723. item.CategoryName = articleResult.Industry.Name
  724. item.CategoryId = exitMap[articleResult.SeriesId]
  725. item.SubCategoryName = articleResult.Series.Name
  726. if len(articleResult.Stock) > 0 {
  727. var stock string
  728. for _, vS := range articleResult.Stock {
  729. stock += vS + "/"
  730. }
  731. stock = strings.TrimRight(stock, "/")
  732. item.Stock = stock
  733. }
  734. item.FieldName = articleResult.Field.Name
  735. list = append(list, item)
  736. itemAuthor.ArticleId = articleResult.ArticleId
  737. itemAuthor.Name = articleResult.Author.Name
  738. itemAuthor.Mobile = articleResult.Author.PhoneNumber
  739. listAuthor = append(listAuthor, itemAuthor)
  740. } else {
  741. // 如果这篇文章没有发布,那么就不作处理。
  742. err = models.UpdateArticlePublish(artcleId, 0)
  743. if err != nil {
  744. fmt.Println("UpdateArticlePublish Err:", err.Error())
  745. return err
  746. }
  747. go models.UpdateCygxArticleCeluePush(artcleId)
  748. return err
  749. }
  750. //同步作者
  751. for _, v := range listAuthor {
  752. var count int
  753. count, err = models.GetActivityAuthorCount(v.ArticleId, v.Mobile)
  754. if err != nil {
  755. fmt.Println("GetActivityAuthorCount Err:", err.Error())
  756. return err
  757. }
  758. if count == 0 {
  759. _, err = models.AddCygxActivityAuthor(v)
  760. if err != nil {
  761. fmt.Println("AddCygxActivityAuthor Err:", err.Error())
  762. return err
  763. }
  764. }
  765. }
  766. fmt.Println("同步文章条数:", len(list))
  767. listCustomArticle, err := models.GetCustomArticleId() //手动归类的文章,不替换文章类型
  768. if err != nil {
  769. fmt.Println("GetTacticsList Err:", err.Error())
  770. return err
  771. }
  772. listGetMatchTypeName, errMatch := models.GetMatchTypeNamenNotNull() //手动归类的文章,不替换文章类型
  773. if errMatch != nil {
  774. fmt.Println("GetTacticsList Err:", errMatch.Error())
  775. return err
  776. }
  777. //mapCategoryIdSet := make(map[int]int)
  778. //for _, vMatch := range listGetMatchTypeName {
  779. // mapCategoryIdSet[vMatch.CategoryId] = vMatch.CategoryIdSet
  780. //}
  781. fmt.Println("list len:", len(list))
  782. noSummaryArticleIds := "3454,3456,3457,3459,2449,2450,2453,2454,2459,2530,2583,2663,2670,2699,2715,2732,2748,2759,2399,2356,2870,3173,2978,2826,3470" //非纪要库类型的文章ID
  783. listNoSummaryArticleIds := strings.Split(noSummaryArticleIds, ",")
  784. for k, v := range list {
  785. //同步匹配类型
  786. matchTypeName := ""
  787. for _, vMatch := range listGetMatchTypeName {
  788. if v.CategoryId == vMatch.CategoryId {
  789. matchTypeName = vMatch.MatchTypeName
  790. }
  791. }
  792. //是否属于纪要库的数据
  793. if _, has := summaryMap[v.CategoryId]; has {
  794. v.IsSummary = 1
  795. }
  796. //排除不属于纪要库类型的文章
  797. for _, vArt := range listNoSummaryArticleIds {
  798. vArtInt, _ := strconv.Atoi(vArt)
  799. if v.ArticleId == vArtInt {
  800. v.IsSummary = 0
  801. }
  802. }
  803. if _, has := reportMap[v.CategoryId]; has {
  804. v.IsReport = 1
  805. if _, ok := classMap[v.CategoryId]; ok {
  806. v.IsClass = 1
  807. v.ReportType = 1 //是否属于行业报告
  808. } else {
  809. v.ReportType = 2 //是否属于产业报告
  810. }
  811. }
  812. v.Department = "弘则权益研究"
  813. //判断是否已经存在
  814. if v.ArticleId < 0 {
  815. fmt.Println("AddCygxArticle Err:")
  816. return err
  817. }
  818. var count int
  819. count, err = models.GetArticleCountById(v.ArticleId)
  820. if err != nil && err.Error() != utils.ErrNoRow() {
  821. fmt.Println("AddCygxArticle Err:", err.Error())
  822. return err
  823. }
  824. v.Body = strings.Replace(v.Body, "http://vmp.hzinsights.com", "https://vmp.hzinsights.com", -1)
  825. expertNumStr, expertContentStr, interviewDateStr, _, bodyReturn := BodyAnalysis2(v.Body)
  826. if strings.Index(v.Body, "报告全文(") > 0 && strings.Index(v.Body, "PDF格式报告下载.pdf") > 0 {
  827. v.Body = strings.Replace(v.Body, "报告全文(", "", -1)
  828. v.Body = strings.Replace(v.Body, "PDF格式报告下载.pdf", "", -1)
  829. v.Body = strings.Replace(v.Body, "):", "", -1)
  830. }
  831. var titleNew string
  832. titleNew = v.Title
  833. // 7资金流向 、11大类资产 、51每日复盘 、80医药周报、9估值研究
  834. if v.CategoryId == 7 || v.CategoryId == 11 || v.CategoryId == 51 || v.CategoryId == 9 {
  835. if v.UpdateFrequency == "daily" {
  836. var daystr string
  837. daystr = strconv.Itoa(v.PublishDate.Day())
  838. if len(daystr) == 1 {
  839. daystr = "0" + daystr
  840. }
  841. titleNew = v.Title + "(" + strconv.Itoa(v.PublishDate.Year())[2:len(strconv.Itoa(v.PublishDate.Year()))-0] + v.PublishDate.Format("01") + daystr + ")"
  842. } else if v.UpdateFrequency == "weekly" {
  843. titleNew = v.Title + utils.WeekByDate(v.PublishDate)
  844. }
  845. }
  846. if v.CategoryId == 80 {
  847. titleNew = v.Title + utils.WeekByDate(v.PublishDate)
  848. }
  849. if count > 0 {
  850. fmt.Println(k, v.ArticleId, "edit")
  851. var isCustom bool
  852. bodyText, _ := GetReportContentTextSub(v.Body)
  853. updateParams := make(map[string]interface{})
  854. //updateParams["Title"] = v.Title
  855. updateParams["Title"] = titleNew
  856. updateParams["TitleEn"] = v.TitleEn
  857. updateParams["UpdateFrequency"] = v.UpdateFrequency
  858. updateParams["CreateDate"] = v.CreateDate
  859. updateParams["PublishDate"] = v.PublishDate
  860. //updateParams["Body"] = html.EscapeString(v.Body)
  861. updateParams["Body"] = html.EscapeString(bodyReturn)
  862. updateParams["BodyText"] = bodyText
  863. updateParams["Abstract"] = html.EscapeString(v.Abstract)
  864. updateParams["CategoryName"] = v.CategoryName
  865. for _, vCustom := range listCustomArticle {
  866. if v.ArticleId == vCustom.ArticleId {
  867. fmt.Println("手动归类的文章:" + strconv.Itoa(v.ArticleId))
  868. isCustom = true
  869. }
  870. }
  871. if isCustom == false {
  872. updateParams["CategoryId"] = v.CategoryId
  873. updateParams["MatchTypeName"] = matchTypeName
  874. updateParams["IsSummary"] = v.IsSummary
  875. updateParams["IsReport"] = v.IsReport
  876. updateParams["ReportType"] = v.ReportType
  877. updateParams["SubCategoryName"] = v.SubCategoryName
  878. }
  879. //updateParams["CategoryId"] = v.CategoryId
  880. updateParams["PublishStatus"] = 1
  881. updateParams["ExpertBackground"] = expertContentStr
  882. updateParams["ExpertNumber"] = expertNumStr
  883. updateParams["InterviewDate"] = interviewDateStr
  884. //updateParams["IsClass"] = v.IsClass
  885. v.Department = "弘则权益研究"
  886. updateParams["Department"] = v.Department
  887. updateParams["FileLink"] = v.File
  888. updateParams["Stock"] = v.Stock
  889. updateParams["FieldName"] = v.FieldName
  890. updateParams["Annotation"] = v.Annotation
  891. whereParam := map[string]interface{}{"article_id": v.ArticleId}
  892. err = models.UpdateByExpr(models.CygxArticle{}, whereParam, updateParams)
  893. if err != nil {
  894. fmt.Println("UpdateByExpr Err:" + err.Error())
  895. return err
  896. }
  897. } else {
  898. fmt.Println(k, v.ArticleId, "add")
  899. item := new(models.CygxArticle)
  900. articleIdInt := v.ArticleId
  901. item.ArticleId = articleIdInt
  902. //item.Title = v.Title
  903. item.Title = titleNew
  904. item.TitleEn = v.TitleEn
  905. item.UpdateFrequency = v.UpdateFrequency
  906. item.CreateDate = v.CreateDate
  907. item.PublishDate = v.PublishDate.Format(utils.FormatDateTime)
  908. //item.Body = html.EscapeString(v.Body)
  909. item.Body = html.EscapeString(bodyReturn)
  910. item.Abstract = html.EscapeString(v.Abstract)
  911. item.CategoryName = v.CategoryName
  912. item.SubCategoryName = v.SubCategoryName
  913. item.CategoryId = v.CategoryId
  914. item.CategoryIdTwo = v.CategoryId
  915. item.PublishStatus = 1
  916. item.ExpertBackground = expertContentStr
  917. item.ExpertNumber = expertNumStr
  918. item.InterviewDate = interviewDateStr
  919. item.Department = v.Department
  920. item.ArticleIdMd5 = utils.MD5(strconv.Itoa(articleIdInt))
  921. item.IsClass = v.IsClass
  922. item.IsSummary = v.IsSummary
  923. item.IsReport = v.IsReport
  924. item.ReportType = v.ReportType
  925. item.FileLink = v.File
  926. item.MatchTypeName = matchTypeName
  927. item.Stock = v.Stock
  928. item.FieldName = v.FieldName
  929. item.Annotation = v.Annotation
  930. newId, err := models.AddCygxArticles(item)
  931. if err != nil {
  932. fmt.Println("AddCygxArticle Err:", err.Error())
  933. return err
  934. }
  935. //fmt.Println(newId)
  936. //报告自动归类,以及推送相关模板消息
  937. if v.ReportType == 2 {
  938. var subjectStr string
  939. var industrialManagementIdStr string
  940. var industrialSubjectIdStr string
  941. var keyword1 string
  942. var keyword2 string
  943. var keyword3 string
  944. var keyword4 string
  945. sliceSubjects := strings.Split(v.Stock, "/")
  946. mapManagementForSubject := make(map[string]string)
  947. mapIndustrialId := make(map[int]int)
  948. if len(sliceSubjects) > 0 {
  949. for _, vSubject := range sliceSubjects {
  950. sliceKuohao := strings.Split(vSubject, "(") //过滤括号
  951. sliceXiahuaxian := strings.Split(sliceKuohao[0], "-") //过滤下划线
  952. subject := sliceXiahuaxian[0]
  953. subjectStr += "'" + subject + "',"
  954. }
  955. //获取该产业下所对应的行业图片
  956. detailCategory, errCategory := models.GetdetailByCategoryIdOne(v.CategoryId)
  957. if errCategory != nil {
  958. fmt.Println("GetdetailByCategoryIdOne Err:", err.Error())
  959. return err
  960. }
  961. subjectStr = strings.TrimRight(subjectStr, ",")
  962. if subjectStr != "" {
  963. listIndustrial, err := models.GetIndustrialManagementForSubjecName(subjectStr, detailCategory.ChartPermissionId)
  964. if err != nil {
  965. fmt.Println("GetIndustrialManagementForSubjecName Err:", err.Error())
  966. return err
  967. }
  968. subjectStr = strings.Replace(subjectStr, "','", "】【", -1)
  969. subjectStr = strings.Replace(subjectStr, "'", "", -1)
  970. subjectStr = "【" + subjectStr + "】"
  971. if len(listIndustrial) > 0 {
  972. for _, vIndustrial := range listIndustrial {
  973. if _, ok := mapIndustrialId[vIndustrial.IndustrialManagementId]; !ok {
  974. industrialManagementIdStr += strconv.Itoa(vIndustrial.IndustrialManagementId) + ","
  975. }
  976. mapIndustrialId[vIndustrial.IndustrialManagementId] = vIndustrial.IndustrialManagementId
  977. industrialSubjectIdStr += strconv.Itoa(vIndustrial.IndustrialSubjectId) + ","
  978. mapManagementForSubject[vIndustrial.IndustryName] += vIndustrial.SubjectName + "/"
  979. if vIndustrial.LayoutTime == "0000-00-00 00:00:00" {
  980. go models.UpdateIndustrialManagementLayoutTime(v.PublishDate.Format(utils.FormatDateTime), vIndustrial.IndustrialManagementId)
  981. }
  982. }
  983. industrialManagementIdStr = strings.TrimRight(industrialManagementIdStr, ",")
  984. industrialSubjectIdStr = strings.TrimRight(industrialSubjectIdStr, ",")
  985. if industrialManagementIdStr != "" {
  986. err = models.ReportArticleClassificationEditNew(int(newId), industrialManagementIdStr, v.ArticleId, industrialSubjectIdStr)
  987. if err != nil {
  988. fmt.Println("ReportArticleClassificationEditNew Err:", err.Error())
  989. return err
  990. }
  991. }
  992. var peoductName string
  993. for mk, mv := range mapManagementForSubject {
  994. peoductName += "【" + mk + "--" + strings.TrimRight(mv, "/") + "】"
  995. }
  996. keyword1 = "新报告产业标签:【" + v.FieldName + "】,个股标签:" + subjectStr
  997. keyword2 = "已自动关联至以下产业和标的:" + peoductName
  998. keyword3 = v.Title
  999. keyword4 = v.PublishDate.Format(utils.FormatDateTime)
  1000. SendWxMsgWithArticleClassToAdmin(keyword1, keyword2, keyword3, keyword4, openIdList, articleIdInt)
  1001. } else {
  1002. keyword1 = "新报告产业标签:【" + v.FieldName + "】,个股标签:" + subjectStr
  1003. keyword2 = "未归类"
  1004. keyword3 = v.Title
  1005. keyword4 = v.PublishDate.Format(utils.FormatDateTime)
  1006. SendWxMsgWithArticleClassToAdmin(keyword1, keyword2, keyword3, keyword4, openIdList, articleIdInt)
  1007. go models.UpdateIsClassFail(artcleId)
  1008. }
  1009. }
  1010. }
  1011. }
  1012. }
  1013. //类型ID 医药(医享会:28 、药调研:301)、消费【渠道新声:32】、科技【科技前言:79】、智造【匠心智造:84】或者是纪要做消息模板推送
  1014. fmt.Println(v.CategoryId)
  1015. //if v.IsSummary == 1 || (v.CategoryId == 28 || v.CategoryId == 301 || v.CategoryId == 32 || v.CategoryId == 79 || v.CategoryId == 84) {
  1016. // sliceSubjects := strings.Split(v.Stock, "/")
  1017. // fmt.Println(sliceSubjects)
  1018. // if len(sliceSubjects) > 0 {
  1019. // var subjectStr string
  1020. // for _, vSubject := range sliceSubjects {
  1021. // sliceKuohao := strings.Split(vSubject, "(") //过滤括号
  1022. // sliceXiahuaxian := strings.Split(sliceKuohao[0], "-") //过滤下划线
  1023. // subject := sliceXiahuaxian[0]
  1024. // subjectStr += "'" + subject + "',"
  1025. // }
  1026. // if subjectStr != "" {
  1027. // subjectStr = strings.TrimRight(subjectStr, ",")
  1028. // activityIdList, err := models.GetActivityIdListBySubjecName(subjectStr)
  1029. // if err != nil {
  1030. // fmt.Println("GetActivityIdListBySubjecName Err:", err.Error())
  1031. // return err
  1032. // }
  1033. // if len(activityIdList) > 0 {
  1034. // var activityIdStr string
  1035. // for _, vAct := range activityIdList {
  1036. // activityIdStr += strconv.Itoa(vAct.ActivityId) + ","
  1037. // }
  1038. // activityIdStr = strings.TrimRight(activityIdStr, ",")
  1039. // if activityIdStr != "" {
  1040. // appointmentList, err := models.GetAppointmentListByActivityId(activityIdStr, "1,2,5")
  1041. // if err != nil {
  1042. // fmt.Println("GetAppointmentListByActivityId Err:", err.Error())
  1043. // return err
  1044. // }
  1045. // if len(appointmentList) > 0 {
  1046. // for _, vApp := range appointmentList {
  1047. //
  1048. // appointmentByMobileList, err := models.GetAppointmentListByActivityIdAndMobile(activityIdStr, vApp.Mobile)
  1049. // if err != nil {
  1050. // fmt.Println("GetAppointmentListByActivityId Err:", err.Error())
  1051. // return err
  1052. // }
  1053. // var appointmentActivityName string
  1054. // if len(appointmentByMobileList) > 0 {
  1055. // for _, vAppM := range appointmentByMobileList {
  1056. // appointmentActivityName += vAppM.ActivityName + ","
  1057. // }
  1058. // }
  1059. // appointmentActivityName = strings.TrimRight(appointmentActivityName, ",")
  1060. // if vApp.ActivityTypeId == 5 && v.CategoryId != 301 {
  1061. // continue
  1062. // }
  1063. //
  1064. // if vApp.Mobile != "" {
  1065. // openIdListByAppointment, err := models.GetUserRecordListByMobile(4, vApp.Mobile)
  1066. // if err != nil {
  1067. // fmt.Println(err)
  1068. // return err
  1069. // }
  1070. // keyword1 := "您预约的调研,有关联的纪要发布/更新了"
  1071. // keyword2 := appointmentActivityName
  1072. // keyword3 := v.Title
  1073. // keyword4 := v.PublishDate.Format(utils.FormatDateTime)
  1074. // SendWxMsgWithArticleClassToAdmin(keyword1, keyword2, keyword3, keyword4, openIdListByAppointment, artcleId)
  1075. // }
  1076. // }
  1077. // }
  1078. // }
  1079. // }
  1080. // }
  1081. // }
  1082. //}
  1083. //
  1084. ////【公司调研】系列纪要发布/更新后
  1085. //if v.CategoryId == 45 || v.CategoryId == 74 || v.CategoryId == 86 || v.CategoryId == 88 {
  1086. // fmt.Println("处理预约纪要")
  1087. // sliceSubjects := strings.Split(v.Stock, "/")
  1088. // if len(sliceSubjects) > 0 {
  1089. // var subjectStr string
  1090. // for _, vSubject := range sliceSubjects {
  1091. // sliceKuohao := strings.Split(vSubject, "(") //过滤括号
  1092. // sliceXiahuaxian := strings.Split(sliceKuohao[0], "-") //过滤下划线
  1093. // subject := sliceXiahuaxian[0]
  1094. // subjectStr += "'" + subject + "',"
  1095. // }
  1096. // if subjectStr != "" {
  1097. // subjectStr = strings.TrimRight(subjectStr, ",")
  1098. // activityIdList, err := models.GetActivityIdListBySubjecName(subjectStr)
  1099. // if err != nil {
  1100. // fmt.Println("GetActivityIdListBySubjecName Err:", err.Error())
  1101. // return err
  1102. // }
  1103. // if len(activityIdList) > 0 {
  1104. // var activityIdStr string
  1105. // for _, vAct := range activityIdList {
  1106. // activityIdStr += strconv.Itoa(vAct.ActivityId) + ","
  1107. // }
  1108. // activityIdStr = strings.TrimRight(activityIdStr, ",")
  1109. // if activityIdStr != "" {
  1110. // appointmentList, err := models.GetAppointmentListByActivityId(activityIdStr, "3,4")
  1111. // if err != nil {
  1112. // fmt.Println("GetAppointmentListByActivityId Err:", err.Error())
  1113. // return err
  1114. // }
  1115. // if len(appointmentList) > 0 {
  1116. // for _, vApp := range appointmentList {
  1117. // appointmentByMobileList, err := models.GetAppointmentListByActivityIdAndMobile(activityIdStr, vApp.Mobile)
  1118. // if err != nil {
  1119. // fmt.Println("GetAppointmentListByActivityId Err:", err.Error())
  1120. // return err
  1121. // }
  1122. // var appointmentActivityName string
  1123. // if len(appointmentByMobileList) > 0 {
  1124. // for _, vAppM := range appointmentByMobileList {
  1125. // appointmentActivityName += vAppM.ActivityName + ","
  1126. // }
  1127. // }
  1128. // appointmentActivityName = strings.TrimRight(appointmentActivityName, ",")
  1129. // if vApp.Mobile != "" {
  1130. // openIdListByAppointment, err := models.GetUserRecordListByMobile(4, vApp.Mobile)
  1131. // if err != nil {
  1132. // fmt.Println(err)
  1133. // return err
  1134. // }
  1135. // keyword1 := "您预约的调研,有关联的纪要发布/更新了"
  1136. // keyword2 := appointmentActivityName
  1137. // keyword3 := v.Title
  1138. // keyword4 := v.PublishDate.Format(utils.FormatDateTime)
  1139. // SendWxMsgWithArticleClassToAdmin(keyword1, keyword2, keyword3, keyword4, openIdListByAppointment, artcleId)
  1140. //
  1141. // }
  1142. // }
  1143. // }
  1144. // }
  1145. // }
  1146. // }
  1147. // }
  1148. //}
  1149. //【公司调研】系列纪要发布/更新后 end
  1150. //查研观向6.9模板消息推送规则
  1151. //但是如果报告的发布时间是在10天以前的,公众号就不推送了
  1152. if time.Now().AddDate(0, 0, -10).Before(articleResult.PublishDate.Add(time.Hour * 8)) {
  1153. go DoArticleOnenIdWxTemplateMsg(v.ArticleId)
  1154. }
  1155. }
  1156. go models.UpdateCygxArticleCeluePush(artcleId)
  1157. return err
  1158. }
  1159. //func init() {
  1160. // DoArticleOnenIdWxTemplateMsg(6940)
  1161. //}
  1162. //过滤策略平台报告,研选报告重复推送,以及权限勾选的推送
  1163. func DoArticleOnenIdWxTemplateMsg(articleId int) (err error) {
  1164. //策略平台同步过来的文章ID,做微信模板消息推送,同一篇报告12小时只推送一次
  1165. cacheKey := fmt.Sprint(utils.CACHE_KEY_ARTICLE_ID_TEMPLATE, ":ArticleId", articleId)
  1166. ttlTime := utils.Rc.GetRedisTTL(cacheKey)
  1167. if ttlTime > 0 {
  1168. return err
  1169. }
  1170. var msg string
  1171. defer func() {
  1172. if err != nil {
  1173. go utils.SendAlarmMsg("处理同步策略平台数据失败"+"GetArticleListByApi ErrMsg:"+err.Error(), 2)
  1174. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetArticleListByApi ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1175. fmt.Println(err)
  1176. }
  1177. if msg != "" {
  1178. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1179. }
  1180. }()
  1181. //获取文章详情
  1182. articleInfo, err := models.GetArticleDetailById(articleId)
  1183. if err != nil {
  1184. return
  1185. }
  1186. articleInfo.Abstract, _ = GetReportContentTextSub(articleInfo.Abstract)
  1187. var chartPermissionId int
  1188. var chartPermissionName string
  1189. reportMapDetail, err := models.GetdetailByCategoryIdPush(articleInfo.CategoryId)
  1190. if err != nil {
  1191. return err
  1192. }
  1193. if reportMapDetail.ChartPermissionId == utils.CE_LUE_ID {
  1194. chartPermissionId = utils.CE_LUE_ID
  1195. } else {
  1196. if reportMapDetail.PermissionType == 1 {
  1197. chartPermissionName = reportMapDetail.ChartPermissionName + "(主观)"
  1198. } else {
  1199. chartPermissionName = reportMapDetail.ChartPermissionName + "(客观)"
  1200. }
  1201. chartPermissionDetail, err := models.GetChartPermissionByRemark(chartPermissionName)
  1202. if err != nil {
  1203. return err
  1204. }
  1205. chartPermissionId = chartPermissionDetail.ChartPermissionId
  1206. }
  1207. //文章关联的产业
  1208. var industryName string
  1209. var industrialManagementId string
  1210. if chartPermissionId == utils.CE_LUE_ID {
  1211. industryName = reportMapDetail.SubCategoryName
  1212. } else {
  1213. detailIndustryNameList, err := models.GetIndustrialManagemenDetailByAaticleID(articleId)
  1214. if err != nil && err.Error() != utils.ErrNoRow() {
  1215. return err
  1216. }
  1217. //如果不存在关联的产业则不推送
  1218. if len(detailIndustryNameList) == 0 {
  1219. return err
  1220. }
  1221. for _, v := range detailIndustryNameList {
  1222. industryName += v.IndustryName + ","
  1223. industrialManagementId += strconv.Itoa(v.IndustrialManagementId) + ","
  1224. }
  1225. industryName = strings.TrimRight(industryName, ",")
  1226. industrialManagementId = strings.TrimRight(industrialManagementId, ",")
  1227. //处理勾选了全部行业赛道的用户
  1228. var allIn string
  1229. allIn = DoXzsChooseSend(reportMapDetail.ChartPermissionName)
  1230. if allIn != "" {
  1231. allInList, err := models.GetCygxXzsChooseSendByAllIn(allIn)
  1232. if err != nil && err.Error() != utils.ErrNoRow() {
  1233. return err
  1234. }
  1235. if len(allInList) > 0 {
  1236. var allInUserId string
  1237. for _, v := range allInList {
  1238. allInUserId += strconv.Itoa(v.UserId) + ","
  1239. }
  1240. allInUserId = strings.TrimRight(allInUserId, ",")
  1241. userFllowIndustrialList, err := models.GetUserFllowIndustrialListByUserIdAndIndustrial(allInUserId, industrialManagementId)
  1242. if err != nil && err.Error() != utils.ErrNoRow() {
  1243. return err
  1244. }
  1245. mapUserFllowed := make(map[string]int)
  1246. for _, v := range userFllowIndustrialList {
  1247. //用户ID与其关注的产业组成唯一索引,判断是否存在,如果不存在就进行自动关注
  1248. mapUserFllowed[fmt.Sprint("uid:", v.UserId, "_Industrial:", v.IndustrialManagementId)] = v.UserId
  1249. }
  1250. //获取这些allIN用户的的信息进行遍历生成需要插入的数据
  1251. userList, err := models.GetWxUserListByUserIds(allInUserId)
  1252. if err != nil && err.Error() != utils.ErrNoRow() {
  1253. return err
  1254. }
  1255. var industryFllowItems []*models.CygxIndustryFllow
  1256. for _, v := range detailIndustryNameList {
  1257. for _, vUser := range userList {
  1258. //如果用户这个用户没有关注这个产业就进行自动关注
  1259. if mapUserFllowed[fmt.Sprint("uid:", vUser.UserId, "_Industrial:", v.IndustrialManagementId)] == 0 {
  1260. item := new(models.CygxIndustryFllow)
  1261. item.IndustrialManagementId = v.IndustrialManagementId
  1262. item.UserId = vUser.UserId
  1263. item.Email = vUser.Email
  1264. item.Mobile = vUser.Mobile
  1265. item.RealName = vUser.RealName
  1266. item.CompanyId = vUser.CompanyId
  1267. item.CompanyName = vUser.CompanyName
  1268. item.Source = 3
  1269. item.Type = 1
  1270. item.CreateTime = time.Now()
  1271. item.ModifyTime = time.Now()
  1272. industryFllowItems = append(industryFllowItems, item)
  1273. }
  1274. }
  1275. }
  1276. err = models.AddCygxIndustryFllowMulti(industryFllowItems)
  1277. if err != nil {
  1278. go utils.SendAlarmMsg("用户关注全部赛道,出现新赛道批量添加失败 ,AddCygxIndustryFllowMulti ErrMsg:"+err.Error(), 2)
  1279. }
  1280. }
  1281. }
  1282. }
  1283. // 获取所有有权的用户的 openid
  1284. mapOpenidPower := make(map[int]string)
  1285. permissionIdList := make([]string, 0)
  1286. var condition string
  1287. var pars []interface{}
  1288. slicepermissionId := strings.Split(strconv.Itoa(chartPermissionId), ",")
  1289. if len(slicepermissionId) > 0 {
  1290. for _, v := range slicepermissionId {
  1291. permissionIdList = append(permissionIdList, v)
  1292. }
  1293. condition += ` AND p.chart_permission_id IN (` + utils.GetOrmInReplace(len(slicepermissionId)) + ` ) `
  1294. pars = append(pars, permissionIdList)
  1295. }
  1296. openidPowerList, err := models.GetCygxUserRecordPower(condition, pars)
  1297. if err != nil {
  1298. return err
  1299. }
  1300. for _, v := range openidPowerList {
  1301. mapOpenidPower[v.UserId] = v.OpenId
  1302. }
  1303. //获取关注这个文章对应产业的用户的 openid
  1304. mapOpenidFllow := make(map[int]string)
  1305. if chartPermissionId != utils.CE_LUE_ID {
  1306. openidFllowList, err := models.GetCygxUserFllowOpenid(articleId)
  1307. if err != nil {
  1308. return err
  1309. }
  1310. for _, v := range openidFllowList {
  1311. mapOpenidFllow[v.UserId] = v.OpenId
  1312. }
  1313. }
  1314. //获取拒绝接收推送的的用户的 openid
  1315. mapOpenidRefuset := make(map[int]string)
  1316. openidRefusetList, err := models.GetCygxUserRefusetOpenid()
  1317. if err != nil {
  1318. return err
  1319. }
  1320. for _, v := range openidRefusetList {
  1321. mapOpenidRefuset[v.UserId] = v.OpenId
  1322. }
  1323. //获取提交过推送规则的用户的 openid
  1324. mapUserIdChooseSend := make(map[int]int)
  1325. mapUserIdChooseSendTypeNoPermission := make(map[int]int)
  1326. chooseSendtList, err := models.GetCygxXzsChooseSend()
  1327. for _, v := range chooseSendtList {
  1328. mapUserIdChooseSend[v.UserId] = v.UserId
  1329. if v.IsRefuse == 1 {
  1330. continue
  1331. }
  1332. //获取选择主客观赛道的用户
  1333. if reportMapDetail.PermissionType == 1 {
  1334. if v.IsSubjective == 1 {
  1335. mapUserIdChooseSendTypeNoPermission[v.UserId] = v.UserId
  1336. }
  1337. } else {
  1338. if v.IsObjective == 1 {
  1339. mapUserIdChooseSendTypeNoPermission[v.UserId] = v.UserId
  1340. }
  1341. }
  1342. }
  1343. //已经推送了的openid
  1344. mapOpenidPushed := make(map[int]string)
  1345. keyword2 := articleInfo.Title
  1346. keyword3 := time.Now().Format(utils.FormatDateTime)
  1347. keyword4 := articleInfo.Abstract
  1348. mapAlreadySend := make(map[int]int)
  1349. //如果是策略就按照策略的推送方式来写
  1350. if reportMapDetail.ChartPermissionName == utils.CE_LUE_NAME {
  1351. //获取提交过推送规则的用户的 openid
  1352. mapUserFllowCeLue := make(map[int]string)
  1353. userFllowCeLueList, err := models.GetCygxUserFllowCeLueOpenid(articleInfo.CategoryId)
  1354. if err != nil {
  1355. return err
  1356. }
  1357. for _, v := range userFllowCeLueList {
  1358. mapUserFllowCeLue[v.UserId] = v.OpenId
  1359. }
  1360. for k, v := range mapOpenidPower {
  1361. if mapOpenidPushed[k] != "" {
  1362. continue
  1363. }
  1364. openIditem := new(models.OpenIdList)
  1365. openIditem.UserId = k
  1366. openIditem.OpenId = v
  1367. first := "您关注的赛道,有新的报告发布/更新,欢迎查看"
  1368. keyword1 := "所属赛道:" + industryName
  1369. mapActivityUserId := make(map[int]string)
  1370. if articleInfo.IsSummary == 1 {
  1371. sliceSubjectId, _ := models.GetSubjectIds(articleId)
  1372. if sliceSubjectId != "" {
  1373. appointmentList, err := models.GetCygxAppointmentSummaryBySubjectId(sliceSubjectId)
  1374. if err != nil {
  1375. fmt.Println("GetCygxAppointmentSummaryListBySubjectId Err:", err.Error())
  1376. return err
  1377. }
  1378. var userIds []string
  1379. if len(appointmentList) > 0 {
  1380. for _, v := range appointmentList {
  1381. //fmt.Println("mapActivityUserId:", v.UserId)
  1382. userIds = append(userIds, strconv.Itoa(v.UserId))
  1383. mapActivityUserId[v.UserId] += v.ActivityName + ","
  1384. }
  1385. userIdstr := strings.Join(userIds, ",")
  1386. openIdLists, err := models.GetOpenIdByUserIds(userIdstr)
  1387. if err != nil {
  1388. fmt.Println("GetOpenIdByUserIds Err:", err.Error())
  1389. return err
  1390. }
  1391. for _, item := range openIdLists {
  1392. first := "您预约的调研,有关联的纪要发布/更新了"
  1393. keyword1 := industryName
  1394. openIditem := new(models.OpenIdList)
  1395. openIditem.OpenId = item.OpenId
  1396. openIditem.UserId = item.UserId
  1397. if _, ok := mapAlreadySend[openIditem.UserId]; !ok {
  1398. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1399. delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1400. fmt.Println("AlreadySend:", openIditem.UserId)
  1401. mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1402. }
  1403. }
  1404. }
  1405. }
  1406. //fmt.Println("openIditem.UserId:", openIditem.UserId)
  1407. //if _,ok := mapActivityUserId[openIditem.UserId]; ok{
  1408. // first = "您预约的调研,有关联的纪要发布/更新了"
  1409. // keyword1 = industryName
  1410. // SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1411. // delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1412. // mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1413. //}
  1414. }
  1415. _, ok := mapAlreadySend[openIditem.UserId]
  1416. //如果有权限而且小助手没有提交过信息的 就做正常推送
  1417. if mapUserIdChooseSend[openIditem.UserId] == 0 && !ok {
  1418. fmt.Println("1:", articleId)
  1419. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1420. }
  1421. //如果小助手勾选了对应的权限信息 就做正常推送
  1422. if mapUserIdChooseSend[openIditem.UserId] != 0 && mapUserFllowCeLue[openIditem.UserId] != "" && !ok {
  1423. fmt.Println("2:", articleId)
  1424. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1425. }
  1426. }
  1427. } else {
  1428. for k, v := range mapOpenidPower {
  1429. if mapOpenidPushed[k] != "" {
  1430. continue
  1431. }
  1432. chooseSendtList, err := models.GetCygxXzsChooseSend()
  1433. if err != nil {
  1434. return err
  1435. }
  1436. mapUserIdChooseSendType := make(map[int]int)
  1437. for _, v := range chooseSendtList {
  1438. if v.IsRefuse == 1 {
  1439. continue
  1440. }
  1441. //获取选择主客观赛道的用户
  1442. if reportMapDetail.PermissionType == 1 {
  1443. if v.IsSubjective == 1 {
  1444. mapUserIdChooseSendType[v.UserId] = v.UserId
  1445. }
  1446. } else if reportMapDetail.PermissionType == 2 {
  1447. if v.IsObjective == 1 {
  1448. mapUserIdChooseSendType[v.UserId] = v.UserId
  1449. }
  1450. } else {
  1451. if v.IsSubjective == 1 || v.IsObjective == 1 {
  1452. mapUserIdChooseSendType[v.UserId] = v.UserId
  1453. }
  1454. }
  1455. }
  1456. openIditem := new(models.OpenIdList)
  1457. openIditem.UserId = k
  1458. openIditem.OpenId = v
  1459. first := "您关注的赛道,有新的报告发布/更新,欢迎查看"
  1460. keyword1 := "所属赛道:" + industryName
  1461. mapActivityUserId := make(map[int]string)
  1462. if articleInfo.IsSummary == 1 {
  1463. sliceSubjectId, _ := models.GetSubjectIds(articleId)
  1464. if sliceSubjectId != "" {
  1465. appointmentList, err := models.GetCygxAppointmentSummaryBySubjectId(sliceSubjectId)
  1466. if err != nil {
  1467. fmt.Println("GetCygxAppointmentSummaryListBySubjectId Err:", err.Error())
  1468. return err
  1469. }
  1470. var userIds []string
  1471. if len(appointmentList) > 0 {
  1472. for _, v := range appointmentList {
  1473. //fmt.Println("mapActivityUserId:", v.UserId)
  1474. userIds = append(userIds, strconv.Itoa(v.UserId))
  1475. mapActivityUserId[v.UserId] += v.ActivityName + ","
  1476. }
  1477. userIdstr := strings.Join(userIds, ",")
  1478. openIdLists, err := models.GetOpenIdByUserIds(userIdstr)
  1479. if err != nil {
  1480. fmt.Println("GetOpenIdByUserIds Err:", err.Error())
  1481. return err
  1482. }
  1483. for _, item := range openIdLists {
  1484. first := "您预约的调研,有关联的纪要发布/更新了"
  1485. keyword1 := industryName
  1486. openIditem := new(models.OpenIdList)
  1487. openIditem.OpenId = item.OpenId
  1488. openIditem.UserId = item.UserId
  1489. if _, ok := mapAlreadySend[openIditem.UserId]; !ok {
  1490. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1491. delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1492. fmt.Println("AlreadySend:", openIditem.UserId)
  1493. mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1494. }
  1495. }
  1496. }
  1497. }
  1498. //fmt.Println("openIditem.UserId:", openIditem.UserId)
  1499. //if _,ok := mapActivityUserId[openIditem.UserId]; ok{
  1500. // first = "您预约的调研,有关联的纪要发布/更新了"
  1501. // keyword1 = industryName
  1502. // SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1503. // delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1504. // mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1505. //}
  1506. }
  1507. //如果有权限而且小助手没有提交过信息的 就做正常推送
  1508. _, ok := mapAlreadySend[openIditem.UserId]
  1509. if mapUserIdChooseSend[openIditem.UserId] == 0 && !ok {
  1510. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1511. delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1512. mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1513. }
  1514. //如果小助手勾选了对应的权限信息 就做正常推送
  1515. if mapUserIdChooseSend[openIditem.UserId] != 0 && mapOpenidFllow[openIditem.UserId] != "" && mapUserIdChooseSendType[openIditem.UserId] > 0 && !ok {
  1516. SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1517. delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1518. mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1519. }
  1520. }
  1521. //获取提交过推送规则的用户的 openid 并推送模版消息
  1522. //mapActivityUserId := make(map[int]string)
  1523. //if articleInfo.IsSummary == 1 {
  1524. // sliceSubjectId, _ := models.GetSubjectIds(articleId)
  1525. // if sliceSubjectId != ""{
  1526. // appointmentList, err := models.GetCygxAppointmentSummaryBySubjectId(sliceSubjectId)
  1527. // if err != nil {
  1528. // fmt.Println("GetCygxAppointmentSummaryListBySubjectId Err:", err.Error())
  1529. // return err
  1530. // }
  1531. // if len(appointmentList) > 0 {
  1532. // for _, v := range appointmentList {
  1533. // fmt.Println("mapActivityUserId:", v.UserId)
  1534. // mapActivityUserId[v.UserId] += v.ActivityName + ","
  1535. // first = "您预约的调研,有关联的纪要发布/更新了"
  1536. // keyword1 = industryName
  1537. // if _, ok := mapAlreadySend[openIditem.UserId]; !ok{
  1538. // SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1539. // delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1540. // mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1541. // }
  1542. // }
  1543. // }
  1544. // }
  1545. // //fmt.Println("openIditem.UserId:", openIditem.UserId)
  1546. // //if _,ok := mapActivityUserId[openIditem.UserId]; ok{
  1547. // // first = "您预约的调研,有关联的纪要发布/更新了"
  1548. // // keyword1 = industryName
  1549. // // SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1550. // // delete(mapUserIdChooseSendTypeNoPermission, openIditem.UserId)
  1551. // // mapAlreadySend[openIditem.UserId] = openIditem.UserId
  1552. // //}
  1553. //}
  1554. //openIditem := new(models.OpenIdList)
  1555. //first := "您关注的赛道,有新的报告发布/更新,欢迎查看"
  1556. //keyword1 := "所属赛道:" + industryName
  1557. //var ids []string
  1558. //for k, _ := range mapUserIdChooseSendTypeNoPermission {
  1559. // ids = append(ids, strconv.Itoa(k))
  1560. //}
  1561. //if len(ids) > 0 {
  1562. // idStr := strings.Join(ids, ",")
  1563. // openidIlist, err := models.GetCygxXzsChooseSendOpenIdByUserIds(idStr)
  1564. // if err != nil {
  1565. // return err
  1566. // }
  1567. // for _, item := range openidIlist {
  1568. // openIditem.OpenId = item.OpenId
  1569. // openIditem.UserId = item.UserId
  1570. // if _, ok := mapAlreadySend[openIditem.UserId]; !ok {
  1571. // SendWxMsgWithArticleUpdate(first, keyword1, keyword2, keyword3, keyword4, openIditem, articleId)
  1572. // }
  1573. // }
  1574. //}
  1575. }
  1576. utils.Rc.Put(cacheKey, articleId, time.Hour*12)
  1577. return
  1578. }