detail.js 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
  1. var express = require('express');
  2. var router = express.Router();
  3. const redis = require('../../libs/redis');
  4. const models = require('../../models');
  5. const utils = require('../../libs/utils');
  6. const common = require('./common');
  7. const { getListBuilder } = require('../../libs/pager');
  8. const categories = require('../../config/category');
  9. const { tags } = require('../../config/tag');
  10. const { coloringList } = require('./config');
  11. const CACHE_PREFIX = "art_v2";
  12. // const CACHE_EXPIRES = 60; // 60s刷新一次
  13. const CACHE_EXPIRES = 600;
  14. const artSelect = 'name title desc seoTitle seoDescription width height date publishTime tags lastMod mystery hasSpecial useSpecialThumb publishVersion totalStartCount totalDoneCount completionRate';
  15. // 详情页路由
  16. router.get('/:id', function (req, res, next) {
  17. (async function () {
  18. let id = req.params.id;
  19. utils.validators.validateId(id);
  20. // let cacheKey = `${CACHE_PREFIX}_detail_${id}`;
  21. // let htmlData = await redis.getAsync(cacheKey);
  22. let htmlData = null;
  23. if (!htmlData) {
  24. // 详情
  25. let doc = await models.Art
  26. .findById(id)
  27. .select(artSelect)
  28. .populate('user', 'username name')
  29. .lean()
  30. .exec();
  31. if (!doc) throw createError(404, 'Art Not Found!');
  32. common.organizeDetail(doc);
  33. // 关联推荐
  34. let mytags = [...doc.tags];
  35. let cates = categories.map(e => e.id);
  36. let alltags = tags.map(e => e.tag);
  37. mytags = mytags.filter(e => !cates.includes(e) && alltags.includes(e));
  38. if (mytags.length == 0) mytags = [...doc.tags];
  39. let query = {
  40. page: req.query.page,
  41. length: req.query.length,
  42. search: req.query.search,
  43. orderBy: 'publishTime',
  44. order: 'desc',
  45. base: { open: true, status: 9000 },
  46. filters: { tags: mytags },
  47. }
  48. let result = await getListBuilder(query, models.Art, [{ path: 'user', select: 'username' }]);
  49. common.organizeData(result.data);
  50. // 填色页合集推荐
  51. const recmCollections = recommendColoringPages(doc, coloringList);
  52. // 评论
  53. const comments = await models.Comment.find({ approved: true, page: doc._id }).sort({ createdAt: -1 });
  54. // deeplink 相关
  55. let applink = `https://art.pcoloring.com${req.originalUrl}`;
  56. let downlink = `https://pcoloring.com/anc/`;
  57. const userAgent = req.headers['user-agent'];
  58. console.log('User-Agent:', userAgent);
  59. if (userAgent) {
  60. const ua = userAgent.toLowerCase();
  61. if (ua.includes('iphone') || ua.includes('ipad') || ua.includes('ipod')) {
  62. downlink = 'itms-apps://itunes.apple.com/app/id1575480118?utm_source=share';
  63. } else if (ua.includes('android')) {
  64. downlink = 'https://play.google.com/store/apps/details?id=com.pcoloring.art.puzzle.color.by.number&utm_source=share';
  65. }
  66. }
  67. let data = {
  68. title: `${doc.seoTitle}`,
  69. description: `${doc.seoDescription}`,
  70. detail: doc,
  71. data: result.data,
  72. page: result.page,
  73. pageId: doc._id,
  74. length: result.length,
  75. recordsFiltered: result.recordsFiltered,
  76. recordsTotal: result.recordsTotal,
  77. relates: result.data,
  78. uri: `/coloring-page/${doc._id}`,
  79. imageUrl: doc.thumb,
  80. pageUri: common.replaceUriParams,
  81. comments,
  82. dateFormat: common.dateFormat,
  83. collections: recmCollections,
  84. applink,
  85. downlink,
  86. };
  87. // 渲染EJS模板到内存中
  88. res.render('v2/detail', data, async (err, html) => {
  89. if (err) {
  90. // 如果渲染出错,调用next()传递错误
  91. return next(err);
  92. }
  93. // 渲染成功,存redis, 发送数据到客户端
  94. htmlData = html;
  95. // try {
  96. // await redis.set(cacheKey, htmlData, 'EX', CACHE_EXPIRES);
  97. // } catch (e) {
  98. // console.error(e);
  99. // }
  100. res.send(htmlData);
  101. });
  102. } else {
  103. // 缓存命中, 直接发送缓存数据
  104. res.set({ 'X-From-Cache': 'true' });
  105. res.send(htmlData);
  106. }
  107. })().catch(next);
  108. });
  109. /**
  110. * 填色页推荐系统 - 根据标签相似度推荐相关填色页合集
  111. * @param {Object} currentPage - 当前填色页对象,包含tags属性
  112. * @param {Array} collections - 所有填色页合集列表
  113. * @returns {Array} - 推荐的3个填色页合集
  114. */
  115. function recommendColoringPages(currentPage, collections) {
  116. // 计算每个候选页与当前页的标签匹配度
  117. const scoredPages = collections.map(page => {
  118. const matchedTags = page.tags.filter(tag =>
  119. currentPage.tags.some(currentTag =>
  120. currentTag.toLowerCase() === tag.toLowerCase()
  121. )
  122. );
  123. return {
  124. ...page,
  125. score: matchedTags.length,
  126. matchedTags
  127. };
  128. });
  129. // 按匹配度降序排序
  130. scoredPages.sort((a, b) => b.score - a.score);
  131. // 收集匹配度大于0的推荐
  132. const tagMatchedRecommendations = scoredPages.filter(page => page.score > 0);
  133. // 如果标签匹配的推荐不足3个,从剩余的合集中随机选取补足
  134. if (tagMatchedRecommendations.length < 3) {
  135. const remainingPages = scoredPages.filter(page => page.score === 0);
  136. // 打乱剩余页面顺序
  137. const shuffledRemaining = remainingPages.sort(() => 0.5 - Math.random());
  138. // 补足到3个推荐
  139. return [...tagMatchedRecommendations, ...shuffledRemaining].slice(0, 3);
  140. }
  141. // 如果标签匹配的推荐超过3个,取前3个
  142. return tagMatchedRecommendations.slice(0, 3);
  143. }
  144. module.exports = router;