artsite/service/cron-jobs/sitemap2.js

/**
 * 每天运行一次，生成站点地图
 */

const fs = require("fs");
const datefns = require("date-fns");
const models = require("../../models");

const sitemapPath = __dirname + "/../../dist/sitemap.xml";
const sitemapTempPath = __dirname + "/../../dist/sitemap.xml.temp";

// 生成站点地图
async function generateSitemap() {
  let commonXml = [
    '<?xml version="1.0" encoding="UTF-8"?>',
    // '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">',
    "<urlset",
    '  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"',
    '  xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd http://www.w3.org/1999/xhtml http://www.w3.org/2002/08/xhtml/xhtml1-strict.xsd"',
    '  xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"',
    '  xmlns:xhtml="http://www.w3.org/1999/xhtml"',
    ">",
    "  <url>",
    "    <loc>https://art.pcoloring.com</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/coloring-page-gallery</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/coloring-page-albums</loc>",
    `    <lastmod>2025-07-22</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/video-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/mandala-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/zentangle-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/zen-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/flower-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/cat-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/butterfly-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/architecture-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/simple-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/girl-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/fantasy-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/christmas-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/patterns-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/peacock-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/dragon-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/unicorn-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/food-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/how-to-color-online</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/how-to-color-mandala-coloring-page</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/benefit-of-coloring-pages</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/choose-the-right-coloring-tools</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/color-combinations-guide</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/tips-tricks/coloring-techniques-for-beginners</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/app</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/contact</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/about</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/faq</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/privacy-policy</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
    "  <url>",
    "    <loc>https://art.pcoloring.com/terms-of-service</loc>",
    `    <lastmod>2026-05-13</lastmod>`,
    "  </url>",
  ];

  // albums
  let albumsXml = [];
  let albums = await models.ArtAlbum.find({ pid: "art", enabled: true })
    .sort({ order: "asc" })
    .select("_id timeLastModify")
    .lean()
    .exec();
  albums.forEach((e) => {
    albumsXml = albumsXml.concat([
      "  <url>",
      `    <loc>https://art.pcoloring.com/coloring-page-album/${e._id}</loc>`,
      `    <lastmod>${datefns.format(e.timeLastModify, "yyyy-MM-dd")}</lastmod>`,
      "  </url>",
    ]);
  });

  // details
  let detailsXml = [];
  const cursor = await models.Art.find({ status: 9000 })
    .select("name title publishTime")
    .sort({ publishTime: -1 })
    .cursor(); // 使用cursor，避免一次查询太多记录内存受不了
  // 遍历游标中的每个文档
  for await (const doc of cursor) {
    detailsXml = detailsXml.concat([
      "  <url>",
      `    <loc>https://art.pcoloring.com/coloring-page/${doc._id}</loc>`,
      `    <lastmod>${datefns.format(doc.publishTime, "yyyy-MM-dd")}</lastmod>`,
      "  </url>",
    ]);
  }

  let endXml = ["</urlset>"];

  let sitemapXml = [...commonXml, ...albumsXml, ...detailsXml, ...endXml];

  let sitemapXmlStr = sitemapXml.join("\n");

  fs.writeFileSync(sitemapTempPath, sitemapXmlStr); // 先写入临时文件
  fs.renameSync(sitemapTempPath, sitemapPath); // 再重命名

  console.log("生成sitemap成功");
}

function run() {
  generateSitemap();
}

module.exports = { run };

if (require.main == module) {
  run();
}