resource_data.go 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_cygx/models"
  6. "hongze/hongze_cygx/utils"
  7. "strconv"
  8. "strings"
  9. "time"
  10. )
  11. func GetResourceDataList(condition string, pars []interface{}, startSize, pageSize int, user *models.WxUserItem) (items []*models.CygxResourceDataResp, err error) {
  12. uid := user.UserId
  13. list, e := models.GetResourceDataList(condition, pars, startSize, pageSize)
  14. if e != nil {
  15. err = errors.New("GetResourceDataList, Err: " + e.Error())
  16. return
  17. }
  18. mapItems := make(map[string]*models.CygxResourceDataResp)
  19. for _, v := range list {
  20. //预处理文章
  21. item := new(models.CygxResourceDataResp)
  22. item.Id = v.Id
  23. item.SourceId = v.SourceId
  24. item.Source = v.Source
  25. item.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  26. mapItems[fmt.Sprint(v.Source, v.SourceId)] = item
  27. }
  28. var articleIds []int
  29. var newchartIds []int
  30. var roadshowIds []string
  31. var activityIds []int
  32. var activityvideoIds []string
  33. var activityvoiceIds []string
  34. var activityspecialIds []int
  35. var researchsummaryIds []int
  36. var minutessummaryIds []int
  37. var meetingreviewchaptIds []int
  38. var productinteriorIds []int
  39. var reportselectionIds []int // 报告精选
  40. var yanxuanSpecialIds []int // 研选专栏
  41. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial 、 本周研究汇总: researchsummary 、 上周纪要汇总 :minutessummary 、晨会精华 :meetingreviewchapt "`
  42. for _, v := range list {
  43. if v.Source == "article" {
  44. articleIds = append(articleIds, v.SourceId)
  45. } else if v.Source == "newchart" {
  46. newchartIds = append(newchartIds, v.SourceId)
  47. } else if v.Source == "roadshow" {
  48. roadshowIds = append(roadshowIds, strconv.Itoa(v.SourceId))
  49. } else if v.Source == "activity" {
  50. activityIds = append(activityIds, v.SourceId)
  51. } else if v.Source == "activityvideo" {
  52. activityvideoIds = append(activityvideoIds, strconv.Itoa(v.SourceId))
  53. } else if v.Source == "activityvoice" {
  54. activityvoiceIds = append(activityvoiceIds, strconv.Itoa(v.SourceId))
  55. } else if v.Source == "activityspecial" {
  56. activityspecialIds = append(activityspecialIds, v.SourceId)
  57. } else if v.Source == "researchsummary" {
  58. researchsummaryIds = append(researchsummaryIds, v.SourceId)
  59. } else if v.Source == "minutessummary" {
  60. minutessummaryIds = append(minutessummaryIds, v.SourceId)
  61. } else if v.Source == "meetingreviewchapt" {
  62. meetingreviewchaptIds = append(meetingreviewchaptIds, v.SourceId)
  63. } else if v.Source == "productinterior" {
  64. productinteriorIds = append(productinteriorIds, v.SourceId)
  65. } else if v.Source == "reportselection" {
  66. reportselectionIds = append(reportselectionIds, v.SourceId)
  67. } else if v.Source == utils.CYGX_OBJ_YANXUANSPECIAL {
  68. yanxuanSpecialIds = append(yanxuanSpecialIds, v.SourceId)
  69. }
  70. }
  71. //处理文章
  72. if len(articleIds) > 0 {
  73. pars = make([]interface{}, 0)
  74. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(len(articleIds)) + `)`
  75. pars = append(pars, articleIds)
  76. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  77. if e != nil {
  78. err = errors.New("GetResourceDataList, Err: " + e.Error())
  79. return
  80. }
  81. listArticle, e = HandleArticleCategoryImg(listArticle)
  82. if e != nil {
  83. err = errors.New("HandleArticleCategoryImg, Err: " + e.Error())
  84. return
  85. }
  86. for _, v := range listArticle {
  87. v.Body = ""
  88. v.BodyHtml = ""
  89. mapItems[fmt.Sprint("article", v.ArticleId)].Article = v
  90. }
  91. }
  92. //处理晨会精华
  93. if len(meetingreviewchaptIds) > 0 {
  94. pars = make([]interface{}, 0)
  95. condition = ` AND c.id IN (` + utils.GetOrmInReplace(len(meetingreviewchaptIds)) + `)`
  96. pars = append(pars, meetingreviewchaptIds)
  97. listrMeet, e := models.GetCygxMorningMeetingReviewChapterList(condition, pars)
  98. if e != nil {
  99. err = errors.New("GetResourceDataList, Err: " + e.Error())
  100. return
  101. }
  102. for _, v := range listrMeet {
  103. v.Content = AnnotationHtml(v.Content)
  104. v.PublishTime = utils.TimeRemoveHms2(v.PublishTime)
  105. mapItems[fmt.Sprint("meetingreviewchapt", v.Id)].Meetingreviewchapt = v
  106. }
  107. }
  108. //处理上周纪要汇总
  109. if len(minutessummaryIds) > 0 {
  110. pars = make([]interface{}, 0)
  111. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(minutessummaryIds)) + `)`
  112. pars = append(pars, minutessummaryIds)
  113. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_minutes_summary", pars, 0, len(minutessummaryIds))
  114. if e != nil {
  115. err = errors.New("GetResourceDataList, Err: " + e.Error())
  116. return
  117. }
  118. for _, v := range listresearchsummary {
  119. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  120. mapItems[fmt.Sprint("minutessummary", v.ArticleId)].Minutessummary = v
  121. }
  122. }
  123. //处理本周纪要汇总
  124. if len(researchsummaryIds) > 0 {
  125. pars = make([]interface{}, 0)
  126. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(researchsummaryIds)) + `)`
  127. pars = append(pars, researchsummaryIds)
  128. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_research_summary", pars, 0, len(researchsummaryIds))
  129. if e != nil {
  130. err = errors.New("GetReportSelectionListHome, Err: " + e.Error())
  131. return
  132. }
  133. for _, v := range listresearchsummary {
  134. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  135. mapItems[fmt.Sprint("researchsummary", v.ArticleId)].Researchsummary = v
  136. }
  137. }
  138. //处理产品内测
  139. if len(productinteriorIds) > 0 {
  140. pars = make([]interface{}, 0)
  141. condition = ` AND art.status = 1 AND art.product_interior_id IN (` + utils.GetOrmInReplace(len(productinteriorIds)) + `)`
  142. pars = append(pars, productinteriorIds)
  143. listProductInterior, e := models.GetCygxProductInteriorList(condition, pars, 0, len(productinteriorIds))
  144. if e != nil {
  145. err = errors.New("GetCygxProductInteriorList, Err: " + e.Error())
  146. return
  147. }
  148. for _, v := range listProductInterior {
  149. v.Body = ProductInteriorHtml(v.Body)
  150. v.PublishTime = utils.TimeRemoveHms2(v.PublishTime)
  151. mapItems[fmt.Sprint("productinterior", v.ProductInteriorId)].ProductInterior = v
  152. }
  153. }
  154. detail, e := models.GetConfigByCode("city_img_url")
  155. if e != nil {
  156. err = errors.New("GetResourceDataList, Err: " + e.Error())
  157. return
  158. }
  159. detailChart, e := models.GetConfigByCode("chart_img_url")
  160. if e != nil {
  161. err = errors.New("GetResourceDataList, Err: " + e.Error())
  162. return
  163. }
  164. addressList := strings.Split(detail.ConfigValue, "{|}")
  165. mapAddress := make(map[string]string)
  166. chartList := strings.Split(detailChart.ConfigValue, "{|}")
  167. mapChart := make(map[string]string)
  168. var cityName string
  169. var chartName string
  170. var imgUrl string
  171. var imgUrlChart string
  172. for _, v := range addressList {
  173. vslice := strings.Split(v, "_")
  174. cityName = vslice[0]
  175. imgUrl = vslice[len(vslice)-1]
  176. mapAddress[cityName] = imgUrl
  177. }
  178. for _, v := range chartList {
  179. vslice := strings.Split(v, "_")
  180. chartName = vslice[0]
  181. imgUrlChart = vslice[len(vslice)-1]
  182. mapChart[chartName] = imgUrlChart
  183. }
  184. var imgUrlResp string
  185. //处理活动
  186. if len(activityIds) > 0 {
  187. for _, vss := range activityIds {
  188. imgUrlResp += strconv.Itoa(vss) + ","
  189. }
  190. pars = make([]interface{}, 0)
  191. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `)`
  192. pars = append(pars, activityIds)
  193. activityList, e := models.GetActivityListNew(condition, pars, uid, 0, len(activityIds), 0, 0, "")
  194. if e != nil {
  195. err = errors.New("GetResourceDataList, Err: " + e.Error())
  196. return
  197. }
  198. //处理不同的报名方式按钮回显
  199. mapActivitySignup, e := GetActivitySignupResp(activityIds, user)
  200. if e != nil {
  201. e = errors.New("GetActivitySignupResp, Err: " + e.Error())
  202. return
  203. }
  204. var activityListRersp []*models.ActivityDetail
  205. for _, v := range activityList {
  206. v.SignupType = mapActivitySignup[v.ActivityId]
  207. //activityListRersp = append(activityListRersp, ActivityButtonShow(v))
  208. }
  209. activityListRersp = ActivityArrButtonShow(activityList)
  210. for _, v := range activityListRersp {
  211. if v == nil {
  212. continue
  213. }
  214. if v.ActivityType == 0 {
  215. if mapAddress[v.City] != "" {
  216. imgUrlResp = mapAddress[v.City]
  217. } else {
  218. imgUrlResp = mapAddress["其它"]
  219. }
  220. } else {
  221. if mapChart[v.ChartPermissionName] != "" {
  222. imgUrlResp = mapChart[v.ChartPermissionName]
  223. }
  224. }
  225. v.SourceType = 1
  226. v.Expert, _ = GetReportContentTextSub(v.Expert)
  227. mapItems[fmt.Sprint("activity", v.ActivityId)].Activity = v
  228. }
  229. }
  230. //处理图表
  231. if len(newchartIds) > 0 {
  232. pars = make([]interface{}, 0)
  233. condition = ` AND a.chart_id IN (` + utils.GetOrmInReplace(len(newchartIds)) + `)`
  234. pars = append(pars, newchartIds)
  235. chartDateList, e := models.GetChartListCollectionNew(condition, pars, uid, 0, len(newchartIds))
  236. if e != nil {
  237. err = errors.New("GetResourceDataList, Err: " + e.Error())
  238. return
  239. }
  240. for _, v := range chartDateList {
  241. mapItems[fmt.Sprint("newchart", v.ChartId)].Newchart = v
  242. }
  243. }
  244. //处理专项调研
  245. if len(activityspecialIds) > 0 {
  246. pars = make([]interface{}, 0)
  247. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityspecialIds)) + `)`
  248. pars = append(pars, activityspecialIds)
  249. activitySpeciallist, e := models.GetCygxActivitySpecialDetailList(condition, pars, user.UserId, 0, len(activityspecialIds))
  250. if e != nil {
  251. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  252. return
  253. }
  254. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  255. if e != nil {
  256. err = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  257. return
  258. }
  259. for _, v := range activitySpeciallist {
  260. if mapChart[v.ChartPermissionName] != "" {
  261. imgUrlResp = mapChart[v.ChartPermissionName]
  262. }
  263. if _, ok := UserMap[v.ActivityId]; ok {
  264. v.IsTrip = 1
  265. }
  266. if v.Days == 0 {
  267. v.TripStatus = 1
  268. v.TripImgLink = v.TripImgLink
  269. } else {
  270. v.TripStatus = 2
  271. v.TripImgLink = v.TripImgLinkFix
  272. v.ActivityTimeText = v.ActivityTimeTextByDay
  273. }
  274. resultTimeStart := utils.StrTimeToTime(v.ActivityTime) //时间字符串格式转时间格式
  275. resultTimeEnd := utils.StrTimeToTime(v.ActivityTimeEnd) //时间字符串格式转时间格式
  276. if resultTimeStart.After(time.Now()) {
  277. v.ActiveState = 1
  278. } else if time.Now().After(resultTimeEnd) {
  279. v.ActiveState = 3
  280. } else {
  281. v.ActiveState = 2
  282. }
  283. v.ImgUrl = imgUrlResp
  284. mapItems[fmt.Sprint("activityspecial", v.ActivityId)].Activityspecial = v
  285. }
  286. }
  287. if len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds) > 0 {
  288. audioIdstr := strings.Join(activityvoiceIds, ",")
  289. ideoIdsStr := strings.Join(roadshowIds, ",")
  290. activityVideoIdsStr := strings.Join(activityvideoIds, ",")
  291. list, _, e := GetMicroRoadShowMycollect(len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds), 0, audioIdstr, ideoIdsStr, activityVideoIdsStr)
  292. if e != nil {
  293. err = errors.New("GetMicroRoadShowMycollect, Err: " + e.Error())
  294. return
  295. }
  296. for _, item := range list {
  297. if item.Type == 1 {
  298. //音频
  299. count, e := models.GetVoiceCollectCount(user.UserId, item.Id)
  300. if e != nil {
  301. err = errors.New("GetVoiceCollectCount, Err: " + e.Error())
  302. return
  303. }
  304. if count > 0 {
  305. item.IsCollect = true
  306. }
  307. } else if item.Type == 2 {
  308. //活动视频
  309. count, e := models.GetActivityVideoCollectCount(user.UserId, item.Id)
  310. if e != nil {
  311. err = errors.New("GetActivityVideoCollectCount, Err: " + e.Error())
  312. return
  313. }
  314. if count > 0 {
  315. item.IsCollect = true
  316. }
  317. } else if item.Type == 3 {
  318. //微路演视频
  319. count, e := models.GetVideoCollectCount(user.UserId, item.Id)
  320. if e != nil {
  321. err = errors.New("GetVideoCollectCount, Err: " + e.Error())
  322. return
  323. }
  324. if count > 0 {
  325. item.IsCollect = true
  326. }
  327. }
  328. }
  329. // 用户权限
  330. authInfo, permissionArr, e := GetUserRaiPermissionInfo(user.UserId, user.CompanyId)
  331. if e != nil {
  332. err = errors.New("GetUserRaiPermissionInfo, Err: " + e.Error())
  333. return
  334. }
  335. // 获取默认图配置
  336. audioMap, videoMap, audioShareMap, videoShareMap, e := GetMicroRoadShowDefaultImgConfig()
  337. if e != nil {
  338. err = errors.New("GetMicroRoadShowDefaultImgConfig, Err: " + e.Error())
  339. return
  340. }
  341. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  342. for i := range list {
  343. // 权限
  344. au := new(models.UserPermissionAuthInfo)
  345. au.SellerName = authInfo.SellerName
  346. au.SellerMobile = authInfo.SellerMobile
  347. au.HasPermission = authInfo.HasPermission
  348. au.OperationMode = authInfo.OperationMode
  349. if au.HasPermission == 1 {
  350. // 非宏观权限进一步判断是否有权限
  351. if list[i].ChartPermissionId != utils.HONG_GUAN_ID && !utils.InArrayByStr(permissionArr, list[i].ChartPermissionName) {
  352. au.HasPermission = 2
  353. }
  354. }
  355. // 无权限的弹框提示
  356. if au.HasPermission != 1 {
  357. if au.OperationMode == UserPermissionOperationModeCall {
  358. if list[i].Type == 1 {
  359. au.PopupMsg = UserPermissionPopupMsgCallActivity
  360. } else {
  361. au.PopupMsg = UserPermissionPopupMsgCallMicroVideo
  362. }
  363. } else {
  364. if list[i].Type == 1 {
  365. au.PopupMsg = UserPermissionPopupMsgApplyActivity
  366. } else {
  367. au.PopupMsg = UserPermissionPopupMsgApplyMicroVideo
  368. }
  369. }
  370. }
  371. list[i].AuthInfo = au
  372. list[i].PublishTime = utils.StrTimeToTime(list[i].PublishTime).Format(utils.FormatDate)
  373. // 默认图
  374. if list[i].BackgroundImg == "" {
  375. if list[i].Type == 1 {
  376. list[i].BackgroundImg = audioMap[list[i].ChartPermissionId]
  377. } else {
  378. list[i].BackgroundImg = videoMap[list[i].ChartPermissionId]
  379. }
  380. }
  381. // 分享图
  382. if list[i].ShareImg == "" {
  383. if list[i].Type == 1 {
  384. list[i].ShareImg = audioShareMap[list[i].ChartPermissionId]
  385. } else {
  386. list[i].ShareImg = videoShareMap[list[i].ChartPermissionId]
  387. }
  388. }
  389. }
  390. //Type int `description:"类型: 1-音频; 2-活动视频; 3-产业视频"`
  391. for _, item := range list {
  392. if item.Type == 1 {
  393. mapItems[fmt.Sprint("activityvoice", item.Id)].Activityvoice = item
  394. } else if item.Type == 2 {
  395. mapItems[fmt.Sprint("activityvideo", item.Id)].Activityvideo = item
  396. } else if item.Type == 3 {
  397. mapItems[fmt.Sprint("roadshow", item.Id)].Roadshow = item
  398. }
  399. }
  400. }
  401. //处理报告精选
  402. lenreportselectionIds := len(reportselectionIds)
  403. if lenreportselectionIds > 0 {
  404. pars = make([]interface{}, 0)
  405. condition = ` AND article_id IN (` + utils.GetOrmInReplace(lenreportselectionIds) + `)`
  406. pars = append(pars, reportselectionIds)
  407. listreportselection, e := models.GetReportSelectionList(condition, pars, 0, lenreportselectionIds)
  408. if e != nil {
  409. err = errors.New("GetReportSelectionList, Err: " + e.Error())
  410. return
  411. }
  412. for _, v := range listreportselection {
  413. v.Title += "(第" + v.Periods + "期)"
  414. v.MarketStrategy = AnnotationHtml(v.MarketStrategy)
  415. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  416. mapItems[fmt.Sprint("reportselection", v.ArticleId)].ReportSelection = v
  417. }
  418. }
  419. //处理研选专栏
  420. lenyanxuanSpecialIds := len(yanxuanSpecialIds)
  421. if lenyanxuanSpecialIds > 0 {
  422. pars = make([]interface{}, 0)
  423. condition = ` AND a.id IN (` + utils.GetOrmInReplace(lenyanxuanSpecialIds) + `) `
  424. pars = append(pars, yanxuanSpecialIds)
  425. listyanxuanSpecial, e := models.GetYanxuanSpecialList(user.UserId, condition, pars)
  426. if e != nil {
  427. err = errors.New("GetYanxuanSpecialList, Err: " + e.Error())
  428. return
  429. }
  430. for _, v := range listyanxuanSpecial {
  431. v.Annotation, _ = GetReportContentTextSubNew(v.Content)
  432. mapItems[fmt.Sprint(utils.CYGX_OBJ_YANXUANSPECIAL, v.Id)].YanxuanSpecial = v
  433. }
  434. }
  435. for _, vList := range list {
  436. for _, v := range mapItems {
  437. //如果这些类型都为空,那么就不合并
  438. if v.Article == nil && v.Newchart == nil && v.Roadshow == nil && v.Activity == nil && v.Activityvideo == nil && v.Activityvoice == nil && v.Activityspecial == nil && v.Researchsummary == nil && v.Minutessummary == nil && v.Meetingreviewchapt == nil && v.ProductInterior == nil && v.IndustrialResource == nil && v.ReportSelection == nil && v.YanxuanSpecial == nil {
  439. continue
  440. }
  441. if v.SourceId == vList.SourceId {
  442. items = append(items, v)
  443. }
  444. }
  445. }
  446. return
  447. }
  448. // 同步活动到最新数据表
  449. func UpdateResourceData(sourceId int, source, doType, publishDate string) (err error) {
  450. defer func() {
  451. if err != nil {
  452. go utils.SendAlarmMsg("同步到最新数据表失败,Err:"+err.Error()+"资源ID"+strconv.Itoa(sourceId)+"资源类型"+source+"操作方式"+doType, 3)
  453. }
  454. }()
  455. if doType == "add" {
  456. item := new(models.CygxResourceData)
  457. item.SourceId = sourceId
  458. item.Source = source
  459. item.PublishDate = publishDate
  460. item.CreateTime = time.Now()
  461. _, err = models.AddCygxResourceData(item)
  462. } else if doType == "delete" {
  463. err = models.DeleteResourceData(sourceId, source)
  464. } else if doType == "update" {
  465. err = models.UpdateResourceData(sourceId, source, publishDate)
  466. }
  467. return
  468. }
  469. // 批量删除最新图表数据
  470. func Deletenewchart(chartIdsDelete []int) (err error) {
  471. defer func() {
  472. if err != nil {
  473. fmt.Println(err)
  474. go utils.SendAlarmMsg("批量删除最新图表数据,Err:"+err.Error(), 3)
  475. }
  476. }()
  477. lenchartIdsDelete := len(chartIdsDelete)
  478. if lenchartIdsDelete == 0 {
  479. return
  480. }
  481. var condition string
  482. var pars []interface{}
  483. condition += ` AND source = 'newchart' AND source_id IN (` + utils.GetOrmInReplace(lenchartIdsDelete) + `) `
  484. pars = append(pars, chartIdsDelete)
  485. err = models.DeleteResourceDataList(condition, pars)
  486. return
  487. }
  488. //func init() {
  489. // UpdateArticleResourceData(9050)
  490. //}
  491. // 更新文章
  492. func UpdateArticleResourceData(sourceId int) {
  493. var err error
  494. defer func() {
  495. if err != nil {
  496. fmt.Println("err:", err)
  497. go utils.SendAlarmMsg("更新文章 失败,UpdateArticleResourceData Err:"+err.Error()+"资源ID"+strconv.Itoa(sourceId), 3)
  498. }
  499. }()
  500. var source = utils.CYGX_OBJ_ARTICLE
  501. var condition string
  502. var pars []interface{}
  503. condition = ` AND publish_status = 1 AND article_id = ? `
  504. pars = append(pars, sourceId)
  505. total, e := models.GetCygxArticleCount(condition, pars)
  506. if e != nil {
  507. err = errors.New("GetCygxReportSelection, Err: " + err.Error())
  508. return
  509. }
  510. //如果取消发布了就做删除处理
  511. if total == 0 {
  512. e = models.DeleteResourceData(sourceId, source)
  513. if e != nil {
  514. err = errors.New("DeleteResourceData, Err: " + e.Error())
  515. return
  516. }
  517. //删除 cygx_resource_data 表关联的产业ID,标的ID
  518. e = models.DeleteCygxResourceDataGroup(sourceId, source)
  519. if e != nil {
  520. err = errors.New("DeleteCygxResourceDataGroup, Err: " + e.Error())
  521. return
  522. }
  523. } else {
  524. //判断是否存在,如果不存在就新增,存在就更新
  525. totalData, e := models.GetCygxResourceDataBySourceAndIdCount(sourceId, source)
  526. if e != nil {
  527. err = errors.New("GetCygxReportSelectionBySourceAndId, Err: " + e.Error())
  528. return
  529. }
  530. detail, e := models.GetArticleDetailById(sourceId)
  531. if e != nil {
  532. err = errors.New("GetCygxReportSelectionInfoById, Err: " + e.Error())
  533. return
  534. }
  535. var resourceDataId int
  536. publishDate := time.Now().Format(utils.FormatDateTime)
  537. item := new(models.CygxResourceData)
  538. if detail.ArticleTypeId > 0 {
  539. item.SearchTag = detail.ArticleTypeName // 研选类型名称
  540. } else {
  541. item.SearchTag = detail.MatchTypeName
  542. }
  543. item.SourceId = sourceId
  544. item.Source = source
  545. item.PublishDate = publishDate
  546. item.CreateTime = time.Now()
  547. if totalData == 0 {
  548. newId, e := models.AddCygxResourceData(item)
  549. if e != nil {
  550. err = errors.New("AddCygxResourceData, Err: " + e.Error())
  551. return
  552. }
  553. resourceDataId = int(newId)
  554. } else {
  555. e = models.UpdateResourceDataByItem(item)
  556. if e != nil {
  557. err = errors.New("UpdateResourceData, Err: " + e.Error())
  558. return
  559. }
  560. sourceDetail, e := models.GetCygxResourceDataByIdAndSource(sourceId, source)
  561. if e != nil {
  562. err = errors.New("UpdateResourceData, Err: " + e.Error())
  563. return
  564. }
  565. resourceDataId = sourceDetail.Id
  566. }
  567. //建立首页资源表,与产业的关系
  568. industrialList, e := models.GetIndustrialArticleGroupManagementListByArticleId(sourceId)
  569. if e != nil && e.Error() != utils.ErrNoRow() {
  570. err = errors.New("GetIndustrialArticleGroupManagementList, Err: " + e.Error() + "sourceId:" + strconv.Itoa(sourceId))
  571. return
  572. }
  573. var industrialItems []*models.CygxResourceDataIndustrialGroupManagement
  574. for _, v := range industrialList {
  575. var industrialItem = new(models.CygxResourceDataIndustrialGroupManagement)
  576. industrialItem.SourceId = sourceId
  577. industrialItem.Source = source
  578. industrialItem.IndustrialManagementId = v.IndustrialManagementId
  579. industrialItem.ResourceDataId = resourceDataId
  580. industrialItem.CreateTime = time.Now()
  581. industrialItems = append(industrialItems, industrialItem)
  582. }
  583. //建立首页资源表,与标的 的关系
  584. subjectList, e := models.GetSubjectArticleGroupManagementListByArtcileId(sourceId)
  585. if e != nil && e.Error() != utils.ErrNoRow() {
  586. err = errors.New("GetSubjectArticleGroupManagementList, Err: " + e.Error() + "sourceId:" + strconv.Itoa(sourceId))
  587. return
  588. }
  589. var subjectItems []*models.CygxResourceDataIndustrialGroupSubject
  590. for _, v := range subjectList {
  591. var subjectItem = new(models.CygxResourceDataIndustrialGroupSubject)
  592. subjectItem.SourceId = sourceId
  593. subjectItem.Source = source
  594. subjectItem.IndustrialSubjectId = v.IndustrialSubjectId
  595. subjectItem.ResourceDataId = resourceDataId
  596. subjectItem.CreateTime = time.Now()
  597. subjectItems = append(subjectItems, subjectItem)
  598. }
  599. //插入关联信息
  600. e = models.AddCygxResourceDataGroup(sourceId, source, industrialItems, subjectItems)
  601. if e != nil {
  602. err = errors.New("AddCygxResourceDataGroup, Err: " + e.Error())
  603. return
  604. }
  605. }
  606. return
  607. }