detail.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  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://art.pcoloring.com/app`;
  57. let openapplink = applink;
  58. if (!req.originalUrl.includes('check')) {
  59. openapplink = applink.concat(req.originalUrl.includes('?') ? '&check=1' : '?check=1');
  60. }
  61. const userAgent = req.headers['user-agent'];
  62. console.log('User-Agent:', userAgent);
  63. if (userAgent) {
  64. const ua = userAgent.toLowerCase();
  65. if (ua.includes('iphone') || ua.includes('ipad') || ua.includes('ipod')) {
  66. downlink = 'itms-apps://itunes.apple.com/app/id1575480118?utm_source=share';
  67. } else if (ua.includes('android')) {
  68. downlink = 'https://play.google.com/store/apps/details?id=com.pcoloring.art.puzzle.color.by.number&utm_source=share';
  69. }
  70. }
  71. let data = {
  72. title: `${doc.seoTitle}`,
  73. description: `${doc.seoDescription}`,
  74. detail: doc,
  75. data: result.data,
  76. page: result.page,
  77. pageId: doc._id,
  78. length: result.length,
  79. recordsFiltered: result.recordsFiltered,
  80. recordsTotal: result.recordsTotal,
  81. relates: result.data,
  82. uri: `/coloring-page/${doc._id}`,
  83. imageUrl: doc.thumb,
  84. pageUri: common.replaceUriParams,
  85. comments,
  86. dateFormat: common.dateFormat,
  87. collections: recmCollections,
  88. applink,
  89. downlink,
  90. openapplink,
  91. };
  92. // 渲染EJS模板到内存中
  93. res.render('v2/detail', data, async (err, html) => {
  94. if (err) {
  95. // 如果渲染出错,调用next()传递错误
  96. return next(err);
  97. }
  98. // 渲染成功,存redis, 发送数据到客户端
  99. htmlData = html;
  100. // try {
  101. // await redis.set(cacheKey, htmlData, 'EX', CACHE_EXPIRES);
  102. // } catch (e) {
  103. // console.error(e);
  104. // }
  105. res.send(htmlData);
  106. });
  107. } else {
  108. // 缓存命中, 直接发送缓存数据
  109. res.set({ 'X-From-Cache': 'true' });
  110. res.send(htmlData);
  111. }
  112. })().catch(next);
  113. });
  114. /**
  115. * 填色页推荐系统 - 根据标签相似度推荐相关填色页合集
  116. * @param {Object} currentPage - 当前填色页对象,包含tags属性
  117. * @param {Array} collections - 所有填色页合集列表
  118. * @returns {Array} - 推荐的3个填色页合集
  119. */
  120. function recommendColoringPages(currentPage, collections) {
  121. // 计算每个候选页与当前页的标签匹配度
  122. const scoredPages = collections.map(page => {
  123. const matchedTags = page.tags.filter(tag =>
  124. currentPage.tags.some(currentTag =>
  125. currentTag.toLowerCase() === tag.toLowerCase()
  126. )
  127. );
  128. return {
  129. ...page,
  130. score: matchedTags.length,
  131. matchedTags
  132. };
  133. });
  134. // 按匹配度降序排序
  135. scoredPages.sort((a, b) => b.score - a.score);
  136. // 收集匹配度大于0的推荐
  137. const tagMatchedRecommendations = scoredPages.filter(page => page.score > 0);
  138. // 如果标签匹配的推荐不足3个,从剩余的合集中随机选取补足
  139. if (tagMatchedRecommendations.length < 3) {
  140. const remainingPages = scoredPages.filter(page => page.score === 0);
  141. // 打乱剩余页面顺序
  142. const shuffledRemaining = remainingPages.sort(() => 0.5 - Math.random());
  143. // 补足到3个推荐
  144. return [...tagMatchedRecommendations, ...shuffledRemaining].slice(0, 3);
  145. }
  146. // 如果标签匹配的推荐超过3个,取前3个
  147. return tagMatchedRecommendations.slice(0, 3);
  148. }
  149. module.exports = router;