1
CREATE TABLE IF NOT EXISTS wallpapers (
2
    enddate TEXT PRIMARY KEY,  -- 日期作为主键 (YYYYMMDD)，防止同一天重复插入
3
    urlbase TEXT,              -- Bing 原始路径 ID
4
    title TEXT,                -- 标题
5
    description TEXT,          -- 描述
6
    author TEXT,               -- 作者
7
    copyrightlink TEXT,        -- 版权链接
8
    wp BOOLEAN,                -- 是否可做壁纸
9
    pic_url_uhd TEXT,          -- 4K 原图链接
10
    pic_url_1200 TEXT,         -- 1920x1200 链接
11
    pic_url_1080 TEXT,         -- 1920x1080 链接
12
    pic_url_1920 TEXT,         -- 1080x1920 竖屏链接
13
    views INTEGER DEFAULT 0,   -- 浏览量 (默认0)
14
    downloads INTEGER DEFAULT 0, -- 下载量 (默认0)
15
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
16
);

1
// ================= 配置区域 =================
2
const ALLOWED_ORIGINS = [
3
    "[https://dailywall.ybjun.com](https://dailywall.ybjun.com)", // 主站
4
    "http://localhost:5173",       // 本地调试
5
    "[http://127.0.0.1:5173](http://127.0.0.1:5173)"
6
];
7
const R2_DOMAIN = "[https://bingpics.ybjun.com](https://bingpics.ybjun.com)";
8
const SIZES = { uhd: 'UHD', w1200: '1920x1200', w1080: '1920x1080', mobile: '1080x1920' };
9

10
export default {
11
  // === 模块 1: 定时任务入口 ===
12
  async scheduled(event, env, ctx) {
13
    ctx.waitUntil(handleSchedule(env));
14
  },
15

16
  // === 模块 2: API 请求入口 ===
17
  async fetch(request, env, ctx) {
18
    const url = new URL(request.url);
19
    const path = url.pathname;
20
    const method = request.method;
21
    const origin = request.headers.get("Origin"); // 获取请求来源用于CORS
22

23
    // 处理 CORS 预检
24
    if (method === "OPTIONS") {
25
      return new Response(null, { headers: getCorsHeaders(origin) });
26
    }
27

28
    try {
29
      // 路由：获取今日壁纸
30
      if (path === '/api/latest') {
31
        const { results } = await env.DB.prepare(
32
          "SELECT * FROM wallpapers ORDER BY enddate DESC LIMIT 1"
33
        ).run();
34
        return jsonResponse(results[0], origin);
35
      }
36

37
      // 路由：获取列表 (支持分页和排序)
38
      if (path === '/api/list') {
39
        const page = parseInt(url.searchParams.get('page') || '1');
40
        const limit = 13; // 多取一张用于前端判断逻辑
41
        const offset = (page - 1) * limit;
42
        const sort = url.searchParams.get('sort') || 'date';
43

44
        let query = "SELECT * FROM wallpapers";
45
        if (sort === 'popular') {
46
          query += " ORDER BY downloads DESC, views DESC, enddate DESC";
47
        } else {
48
          query += " ORDER BY enddate DESC";
49
        }
50
        query += " LIMIT ? OFFSET ?";
51

52
        const { results } = await env.DB.prepare(query).bind(limit, offset).run();
53
        return jsonResponse(results, origin);
54
      }
55

56
      // 路由：随机壁纸
57
      if (path === '/api/random') {
58
        const { results } = await env.DB.prepare("SELECT * FROM wallpapers ORDER BY RANDOM() LIMIT 1").run();
59
        return jsonResponse(results[0], origin);
60
      }
61

62
      // 路由：搜索
63
      if (path === '/api/search') {
64
        const keyword = url.searchParams.get('q');
65
        if (!keyword) return jsonResponse([], origin);
66
        const searchStr = `%${keyword}%`;
67
        const { results } = await env.DB.prepare(
68
          "SELECT * FROM wallpapers WHERE title LIKE ? OR description LIKE ? OR author LIKE ? ORDER BY enddate DESC"
69
        ).bind(searchStr, searchStr, searchStr).run();
70
        return jsonResponse(results, origin);
71
      }
72

73
      // 路由：详情 (浏览量+1)
74
      if (path === '/api/detail') {
75
        const date = url.searchParams.get('date');
76
        if (!date) return errorResponse("Missing date", 400, origin);
77
        // 异步更新浏览量，不阻塞响应
78
        ctx.waitUntil(env.DB.prepare("UPDATE wallpapers SET views = views + 1 WHERE enddate = ?").bind(date).run());
79
        const { results } = await env.DB.prepare("SELECT * FROM wallpapers WHERE enddate = ?").bind(date).run();
80
        return jsonResponse(results[0], origin);
81
      }
82

83
      // 路由：下载 (下载量+1)
84
      if (path === '/api/download' && method === 'POST') {
85
        const date = url.searchParams.get('date');
86
        if (date) {
87
           await env.DB.prepare("UPDATE wallpapers SET downloads = downloads + 1 WHERE enddate = ?").bind(date).run();
88
           return jsonResponse({ status: "ok" }, origin);
89
        }
90
        return errorResponse("Missing date", 400, origin);
91
      }
92

93
      // 路由：Sitemap XML 生成
94
      if (path === '/sitemap.xml') {
95
        const { results } = await env.DB.prepare("SELECT enddate FROM wallpapers ORDER BY enddate DESC").run();
96
        const SITE_URL = "[https://dailywall.ybjun.com](https://dailywall.ybjun.com)";
97
        let xml = `<?xml version="1.0" encoding="UTF-8"?>\n<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">`;
98
        // ... (省略 XML 拼接细节) ...
99
        return new Response(xml, { headers: { "Content-Type": "application/xml", "Cache-Control": "public, max-age=3600" } });
100
      }
101

102
      return errorResponse("Endpoint not found", 404, origin);
103
    } catch (e) {
104
      return errorResponse(e.message, 500, origin);
105
    }
106
  }
107
};
108

109
// === 模块 3: 核心采集逻辑 ===
110
async function handleSchedule(env) {
111
  // 加时间戳防止缓存
112
  const bingApi = `https://cn.bing.com/HPImageArchive.aspx?format=js&idx=0&n=1&mkt=zh-CN&_=${Date.now()}`;
113
  try {
114
    const resp = await fetch(bingApi, {
115
      headers: { "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36..." } // 伪装浏览器
116
    });
117
    if (!resp.ok) throw new Error(`Bing API Error: ${resp.status}`);
118
    const data = await resp.json();
119
    for (const img of data.images) {
120
        await processImage(img, env);
121
    }
122
  } catch (e) { console.error(e); }
123
}
124

125
async function processImage(img, env) {
126
    const date = img.enddate;
127
    // 1. 查重
128
    const { results } = await env.DB.prepare("SELECT * FROM wallpapers WHERE enddate = ?").bind(date).run();
129
    if (results.length > 0) return;
130

131
    // 2. 正则提取 ID (OHR.xxx)
132
    const idMatch = img.urlbase.match(/id=([^&]+)/);
133
    const cleanId = idMatch ? idMatch[1] : null;
134

135
    // 3. 并发下载并上传 R2
136
    const uploadTasks = [];
137
    const urls = {};
138
    // ... 遍历 SIZES ...
139
    for (const item of sizeList) {
140
        const randomStr = crypto.randomUUID().split('-')[0]; // 生成随机文件名防爬虫
141
        const fileName = `${date}_${randomStr}_${item.suffix}.jpg`;
142
        const downloadUrl = `https://www.bing.com/th?id=${cleanId}_${item.suffix}.jpg&pid=hp...`;
143

144
        // 使用立即执行函数封装 Promise，确保任务真正启动
145
        const task = (async () => {
146
             const imgResp = await fetch(downloadUrl, { headers: { ... } }); // 带 Referer 头
147
             if(imgResp.ok) {
148
                 await env.MY_BUCKET.put(fileName, imgResp.body, {
149
                    httpMetadata: { cacheControl: "public, max-age=31536000, immutable" } // 强制缓存
150
                 });
151
                 urls[item.key] = `${R2_DOMAIN}/${fileName}`;
152
             }
153
        })();
154
        uploadTasks.push(task);
155
    }
156
    await Promise.all(uploadTasks);
157

158
    // 4. 入库 (使用 || null 防止 undefined 报错)
159
    await env.DB.prepare(`INSERT INTO wallpapers ...`).bind(..., urls.pic_url_uhd || null, ...).run();
160
}
161

162
// ... 辅助函数 (jsonResponse, getCorsHeaders) ...

1
<!-- 使用 transition 实现背景切换时的丝滑淡入淡出 -->
2
<transition name="bg-fade">
3
  <img
4
    v-if="appState.currentWallpaper"
5
    :key="appState.currentWallpaper"
6
    :src="appState.currentWallpaper"
7
    class="absolute inset-0 w-full h-full object-cover"
8
  />
9
</transition>
10
<!-- 覆盖一层 backdrop-blur 实现模糊效果，无需处理图片本身 -->
11
<div class="absolute inset-0 backdrop-blur-[30px] bg-white/30 dark:bg-black/40"></div>

1
const { idle } = useIdle(3000)
2
const { y } = useWindowScroll()
3
const showHeroControls = computed(() => y.value > 100 ? true : !idle.value)

1
const { width, height } = useWindowSize()
2
const isLandscape = computed(() => width.value > height.value)
3

4
const getWallpaperUrl = (paper) => {
5
  // 如果是横屏，优先用 1080p 横图；否则用竖图
6
  return isLandscape.value
7
    ? (paper.pic_url_1080 || paper.pic_url_uhd)
8
    : (paper.pic_url_1920 || paper.pic_url_uhd)
9
}

1
<head>
2
  <title>胖哥必应美图库 - 每日必应壁纸高清下载</title>
3
  <meta name="description" content="收录微软必应每日高清壁纸，提供4K原图、1080P及手机竖屏壁纸免费下载..." />
4
  <meta name="keywords" content="必应壁纸, Bing Wallpaper, 4K壁纸, 每日一图" />
5
  <!-- Open Graph 协议，优化微信/推特分享卡片 -->
6
  <meta property="og:title" content="胖哥必应美图库" />
7
  <meta property="og:image" content="[https://bingpics.ybjun.com/icon.png](https://bingpics.ybjun.com/icon.png)" />
8
</head>