{"id":1208,"date":"2025-06-30T14:03:27","date_gmt":"2025-06-30T06:03:27","guid":{"rendered":"https:\/\/eve2333.top\/?p=1208"},"modified":"2025-07-01T22:29:26","modified_gmt":"2025-07-01T14:29:26","slug":"saas%e7%9f%ad%e9%93%be%e6%8e%a5%e7%b3%bb%e7%bb%9f-%e6%96%b0%e6%89%8b%e4%bb%8e%e9%9b%b6%e5%ad%a6%e4%b9%a0-9-%e7%9f%ad%e9%93%be%e6%8e%a5%e7%9b%91%e6%8e%a7%e4%b8%8b","status":"publish","type":"post","link":"https:\/\/eve2333.top\/?p=1208","title":{"rendered":"SaaS\u77ed\u94fe\u63a5\u7cfb\u7edf-\u65b0\u624b\u4ece\u96f6\u5b66\u4e60 9. \u77ed\u94fe\u63a5\u76d1\u63a7(\u4e0b"},"content":{"rendered":"\n

- \u7b2c13\u8282\uff1a\u5982\u4f55\u5f00\u53d1\u8bbf\u95ee\u5355\u4e2a\u77ed\u94fe\u63a5\u76d1\u63a7\u7edf\u8ba1\u529f\u80fd<\/h2>\n\n\n\n
package com.nageoffer.shortlink.project.controller;\n\nimport com.nageoffer.shortlink.project.common.convention.result.Result;\nimport com.nageoffer.shortlink.project.common.convention.result.Results;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsRespDTO;\nimport com.nageoffer.shortlink.project.service.ShortLinkStatsService;\nimport lombok.RequiredArgsConstructor;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\n\/**\n * \u77ed\u94fe\u63a5\u76d1\u63a7\u63a7\u5236\u5c42\n *\/\n@RestController\n@RequiredArgsConstructor\npublic class ShortLinkStatsController {\n\n    private final ShortLinkStatsService shortLinkStatsService;\n\n    \/**\n     * \u8bbf\u95ee\u5355\u4e2a\u77ed\u94fe\u63a5\u6307\u5b9a\u65f6\u95f4\u5185\u76d1\u63a7\u6570\u636e\n     *\/\n    @GetMapping(\"\/api\/short-link\/v1\/stats\")\n    public Result<ShortLinkStatsRespDTO> shortLinkStats(ShortLinkStatsReqDTO requestParam) {\n        return Results.success(shortLinkStatsService.oneShortLinkStats(requestParam));\n    }\n}\n<\/pre>\n\n\n\n
\u670d\u52a1\u5668\u505a\u51fa\u4e00\u4e9b\u4fee\u6539\u6216\u8005\u8bf4\u65b0\u589e\u624d\u4f1apost\u548cput\uff1b \u90fd\u7528\u7684\u662fget\u65b9\u6cd5\uff0c \u4e00\u5171\u56db\u4e2a\u53c2\u6570<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dto.req;\n\nimport lombok.Data;\n\n\/**\n * \u77ed\u94fe\u63a5\u76d1\u63a7\u8bf7\u6c42\u53c2\u6570\n *\/\n@Data\npublic class ShortLinkStatsReqDTO {\n\n    \/**\n     * \u5b8c\u6574\u77ed\u94fe\u63a5\n     *\/\n    private String fullShortUrl;\n\n    \/**\n     * \u5206\u7ec4\u6807\u8bc6\n     *\/\n    private String gid;\n\n    \/**\n     * \u5f00\u59cb\u65e5\u671f\n     *\/\n    private String startDate;\n\n    \/**\n     * \u7ed3\u675f\u65e5\u671f\n     *\/\n    private String endDate;\n}\n<\/pre>\n\n\n\n
 \u4ece200\u591a\u884c\u7684impl\uff1a\u9996\u5148\u7b2c\u4e00\u6b65\u5bf9\u5427\uff1f\u6211\u4eec\u8981\u5148\u53bb\u5224\u65ad\u4e00\u4e0b\u4ed6\u6709\u6ca1\u6709\u8bbf\u95ee\u8bb0\u5f55\uff0c\u5982\u679c\u6ca1\u6709\u7684\u8bdd\uff0c\u8fd9\u91cc\u9762\u5176\u5b9e\u8fd4\u56de\u7684\u5c31\u662f\u6211\u4eec\u8fd9\u91cc\u9762\u521b\u5efa\u4e00\u4e2a\u6211\u60f3\u4e00\u60f3\u90a3\u5c31\u62ff\u8fd9\u4e2a\u3002\u7136\u540e\u521b\u5efa\u6211\u53bb\u4f60\u770b\u5982\u679c\u8bf4\u77ed\u94fe\u63a5\u6ca1\u6709\u8bbf\u95ee\u8fc7\uff0c\u4ed6\u8fd8\u662f\u628a\u8fd9\u4e9b\u6570\u636e\u8fd9\u4e9b\u7ed9\u4f60\u770b\uff0c\u4ed6\u611f\u53d7\u7684\u6709\u70b9\u591a\uff0c\u5176\u5b9e\u6b63\u5e38\u7684\u8bdd\u6211\u4eec\u76f4\u63a5\u5c55\u793a\u4e2a\u8d22\u52a1\u8bb0\u5f55\u5c31\u884c\u4e86\uff0c\u6240\u4ee5\u8bf4\u5982\u679c\u6ca1\u6709\u8bbf\u95ee\u8bb0\u5f55\uff0c\u6211\u4eec\u8fd9\u91cc\u9762\u76f4\u63a5\u6709\u542c\u5230\uff0c\u90a3\u524d\u7aef\u4e5f\u4f1a\u6839\u636e now\u53bb\u5224\u65ad\u662f\u5426\u5c55\u793a\u5c55\u53f0\u67e5\u9a8c\u3002\u7136\u540e\u7684\u8bdd\u6211\u4eec\u5f00\u59cb\u505a\u6280\u672f\u8bbf\u95ee\uff0c\u6211\u7ed9\u5927\u5bb6\u6253\u5f00\u4e00\u4e2a\u6709\u7684\u6280\u672f\u8bbf\u95ee\u7684\u8bdd\u5c31\u6307\u7684\u662f\u6307\u7684\u662f\u5b83\u7684\u5bf9\u5e94\u65e5\u671f\u7684\u4e00\u4e2a\u8bbf\u95ee\u6b21\u6570\u4eba\u6570\u4ee5\u53caIP\u6570\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u8fd9\u4e2a\u662f\u5b83\u5bf9\u5e94\u7684\u53cd\u9988\u8bb0\u5f55\u5bf9\u5427\uff1f\u65e5\u671f\uff0c\u7136\u540e\u8bbf\u95ee\u91cf\uff0c\u7136\u540eppuv\u4ee5\u53cauip\uff0c\u8fd9\u4e2a\u662f\u6bd4\u8f83\u597d\u505a\u7684\u3002\u7136\u540e\u5047\u5982\u8bf4\u6211\u4eec\u8bbf\u95ee\u7684\u662f10\u670819\u53f7\u523011\u670818\u53f7\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u54ea\u6015\u4e2d\u95f4\u8fd9\u4e9b\u6570\u636e\u5b83\u6ca1\u6709\u8bb0\u5f55\u8fd4\u56de\u4e86\u96f6\u7684\uff0c\u8fd9\u6837\u7684\u8bdd\u5176\u5b9e\u5728\u6211\u4eec\u8fd9\u8fb9\u7684\u8bdd\u505a\u4e86\u4e00\u6b65\u5904\u7406\uff0c\u4e3a\u4ec0\u4e48\uff1f\u662f\u56e0\u4e3a\u6211\u4eec\u5b58\u5230\u6570\u636e\u5e93\u91cc\u9762\uff0c\u5176\u5b9e\u67e5\u7684\u662f\u67e5\u7684\u662f\u8fd9\u5f20\u8868t_link_access_stats\u3002\u5982\u679c\u8bf4\u4f60\u5728\u5bf9\u5e94\u6ca1\u6709\u5bf9\u5e94\u65f6\u95f4\u6ca1\u6709\u53bb\u8bbf\u95ee\u7684\u8bdd\uff0c\u5b83\u8fd9\u91cc\u9762\u662f\u6ca1\u6709\u8bb0\u5f55\u7684\uff0c\u81ea\u7136\u8fd9\u91cc\u9762\u4e5f\u6ca1\u6709\u8fd9\u5bf9\u5e94\u8bbf\u95ee\u8bb0\u5f55\u4e86\uff0c\u6240\u4ee5\u8bf4\u6211\u4eec\u662f\u600e\u4e48\u505a\u7684\uff0c\u6211\u4eec\u662f\u6839\u636e\u5b83\u7684\u521b\u5efa\u65f6\u95f4\u4ee5\u53ca\u5b83\u7684\u5f00\u59cb\u65f6\u95f4\u548c\u7ed3\u675f\u65f6\u95f4\u53bb\u7ed9\u5b83\u505a\u4e86\u4e00\u4e2a\u53d6\u8303\u56f4\u7684\u53c2\u6570\uff0c\u4ec0\u4e48\u610f\u601d\uff1f\u6bd4\u5982\u8bf4\u4f60\u662f10\u670819~11\u670818\uff0c\u6211\u4f1a\u628a\u4f60\u8fd9\u6bcf\u4e00\u5929\u7684\u6570\u636e\u90fd\u7ed9\u4f60\u521b\u5efa\u51fa\u6765\u4e00\u6761\u8bb0\u5f55\uff0c\u7136\u540e\u6211\u4eec\u901a\u8fc7for each\u521b\u5efa\u51fa\u6765\u7684\u65f6\u95f4\u5b57\u6bb5\u8fdb\u884cfor each\u53bb\u5224\u65ad\uff0c\u548c\u4ed6\u67e5\u51fa\u6765\u7684\u8bb0\u5f55\u8fdb\u884c\u4e00\u4e2a\u6bd4\u5bf9\uff0c\u7136\u540e\u5982\u679c\u6709\u503c\u7684\u8bdd\u5c31\u8d4b\u503c\u7ed9\u5bf9\u5e94\u7684\u503c\uff0c\u5982\u679c\u6ca1\u503c\u5168\u90e8\u5c31\u662f0\uff0c\u6bd4\u8f83\u5bb9\u6613\u7406\u89e3\u3002<\/p>\n\n\n\n
\u7136\u540e\u7b2c\u4e8c\u4e2a\u7684\u8bdd\u5c31\u662f\u5730\u533a\uff0c\u4e4b\u524d\u505a\u5730\u533a\u7684\u65f6\u5019\u8ddf\u5927\u5bb6\u8bb2\u8fc7\uff0c\u6211\u4eec\u53ea\u505a\u56fd\u5185\u7684\u4e00\u4e2a\u5730\u56fe\u8bbf\u95ee\uff0c\u7136\u540e\u5b83\u8fd9\u91cc\u9762\u662fTop5\uff0c\u5e94\u8be5\u662f\u6240\u6709\u7684\u5730\u533a\u90fd\u8fd4\u56de\u4e86\uff0c\u56e0\u4e3a\u6211\u4eec\u8fd9\u91cc\u9762\u6ca1\u5bb6\u91cc\u9762\u7684\uff0c\u6240\u6709\u7684\u5730\u533a\u6211\u4eec\u90fd\u8fd4\u56de\u4e86\uff0c\u6211\u4eec\u662f\u6240\u6709\u5730\u533a\u90fdreturn\u4e86\uff0c\u7136\u540e\u7ed9\u5b83\u56e0\u4e3a\u5b83\u6709\u4e2a\u5565\u5b83\u6709\u4e00\u4e2a\u767e\u5206\u6bd4\u7684\u53c2\u6570\uff0c\u6240\u4ee5\u8bf4\u6211\u4eec\u8fd9\u91cc\u9762\u7ed9\u5b83\u8fdb\u884c\u4e86\u8fd9\u79cd\u8fdb\u884c\u9664\u6cd5\u8fd0\u7b97\uff0c\u7136\u540e\u4e5f\u7ed9\u5b83\u53d6\u4e86\u4e00\u4e2a\u4f59\uff0c\u5c31\u907f\u514d\u524d\u7aef\u53bb\u505a\u4e86\u3002
\u7136\u540e\u518d\u63a5\u4e0b\u6765\u662f\u5c0f\u65f6\u8bbf\u95ee\uff0c\u5c31\u662f\u5728\u4f60\u6240\u7528\u7684\u65f6\u95f4\u6bb5\u5185\uff0c\u5b83\u768424\u5c0f\u65f6\u5206\u5e03\u6240\u5360\u7528\u7684\u4e00\u4e2a\u65f6\u95f4\uff0c\u7136\u540e\u57fa\u672c\u4e0a\u5dee\u4e0d\u591a\uff0c\u628a\u5b83\u7684\u5c0f\u65f6\u6570\u636e\u7edf\u8ba1\u51fa\u6765\uff0c\u7136\u540e\u7ed9\u5b83\u8f6c\u6362\u6210\u6211\u4eec\u5bf9\u4ec0\u4e48\u8f6c\u6362\u6210\u6211\u4eec\u5bf9\u5e94\u7684\u6570\u503c\uff0c\u7136\u540e\u65b0\u589e\u8fdb\u53bb\u5176\u5b9e\u4e00\u5171\u4f60\u770b\u4e00\u517124\u4e2a\u5c0f\u65f6\u5bf9\u5427\uff1f0~23\uff0c\u8fd9\u6837\u7684\u8bdd\u5176\u5b9e\u5b83\u5c31\u662f\u4e00\u4e2a\u6570\u7ec4\u8fd4\u56de\u4e860~23\uff1b
\u7136\u540e\u8fd9\u8fb9\u5c31\u662f\u9ad8\u9891\u8bbf\u95eeIP\uff0c\u7136\u540e\u6211\u4eec\u8fd9\u8fb9\u7684\u8bdd\u53ef\u4ee5\u770b\u4e00\u4e0b\u3002\u5c31\u662f\u8fd9\u6837\u7684\u4e00\u4e2asql\uff0c\u6211\u4eec\u8fd9\u4e2a\u662f\u505a\u4e86\u9ad8\u9891\u8bbf\u95ee\u4e86\uff0c\u5c31\u662f\u8fd4\u56de\u4e86\u524d5\u6761\uff0c\u7136\u540e\u8fd9\u8fb9\u5bf9\u5e94\u8fd4\u56de\u4e24\u4e2a\u53c2\u6570\uff0c\u4e00\u4e2a\u662fIP\uff0c\u4e00\u4e2a\u662fcount\uff0c\u7136\u540e\u4e00\u5468\u8be6\u60c5\u7684\u8bdd\u4e00\u6837\u7684\u903b\u8f91\uff0c\u7136\u540e\u8bbf\u95ee\u6d4f\u89c8\u5668\u8bb0\u5f55\uff0c\u56e0\u4e3a\u6d4f\u89c8\u5668\u8fd9\u8fb9\u7684\u8bdd\u5e94\u8be5\u4e5f\u662f\u4e00\u4e2a\u767e\u5206\u6bd4\u7684\uff0c\u5b83\u6709\u4e00\u4e2a\u6d4f\u89c8\u5668\u662f\u6709\u4e00\u4e2a\u767e\u5206\u6bd4\u7684\uff0c\u6240\u4ee5\u8bf4\u6211\u4eec\u8fd9\u8fb9\u4e00\u6837\u8fdb\u884c\u4e86\u4e00\u4e2a\u767e\u5206\u6bd4\u7684\u9664\u6cd5\u8fd0\u7b97\uff0c\u7136\u540e\u64cd\u4f5c\u7cfb\u7edf\u8fd9\u91cc\u7684\u8bdd\u6709\u4e00\u70b9\u4e0d\u592a\u4e00\u6837\u7684\u662f\u4ec0\u4e48\uff1f\u5b83\u8fd9\u91cc\u9762\u5176\u5b9e\u5c31\u53ea\u9700\u8981\u6709\u4e24\u4e2a\u53c2\u6570\u800c\u5df2\uff0c\u5bf9\u5427\uff1f\u6240\u4ee5\u8bf4\u6211\u4eec\u8fd9\u91cc\u9762\u7ed9\u5b83\u628a\u8fd9\u4e2a\u6570\u636e\u7ed9\u5b83\u7edf\u8ba1\u51fa\u6765\uff0c\u7136\u540e\u505a\u4e86\u4e00\u4e2a\u7c7b\u4f3c\u4e8e\u9879\u76ee\u7684\u8fd9\u79cd\u64cd\u4f5c\uff0c\u7136\u540e\u7ed9\u5b83\u5bf9\u5e94\u4e86\u4e00\u6837\u7684\u4e00\u4e2a\u5904\u7f5a\u8fd0\u7b97\u3002\u7136\u540e\u8bbf\u5ba2\u7c7b\u578b\u7684\u8bdd\uff0c\u8fd9\u91cc\u53ef\u80fd\u5c31\u6709\u4e00\u70b9\u7a0d\u5fae\u7684\u6709\u4e00\u70b9\u590d\u6742\uff0c\u4f9d\u8d56\u6211\u4eec\u4e4b\u524d\u7684\u4ec0\u4e48\uff1f\u8fd9\u91cc\u4f9d\u8d56\u4e8e\u6211\u4eec\u7684\u8bbf\u5ba2\u7c7b\u578b\uff0c\u6240\u4ee5\u8bf4\u8fd9\u91cc\u9762\u7684\u8ba1\u7b97\u4f1a\u7a0d\u5fae\u590d\u6742\u4e00\u70b9\uff0c\u7136\u540e\u6211\u4eec\u8fd9\u91cc\u9762\u4e00\u6837\u7684\u628a new\u90fd\u8fd4\u56de\u51fa\u53bb\u3002\u53ef\u4ee5\u770b\u5230\u6211\u4eec\u8fd9\u8fb9\u8fd4\u56de\u7684\u4e00\u4e2a\u6807\u8bc6\u662fUV type\uff0c\u4e00\u4e2anew user\uff0c\u4e00\u4e2a\u6b27\u62c9\u7684user\uff0c\u7136\u540e\u90fd\u7ed9\u5b83\u52a0\u5230\u4e86 UV type state\u96c6\u5408\u91cc\u9762\u53bb\u3002\u7136\u540e\u63a5\u4e0b\u6765\u5c31\u662f\u8bbf\u95ee\u8bbe\u5907\u548c\u8bbf\u95ee\u7f51\u7edc\u5176\u5b9e\u90fd\u662f\u4e00\u6837\u7684\uff0c\u6700\u7ec8\u6211\u4eec\u7528\u6784\u9020\u8005\u6a21\u5f0f\u628a\u8fd9\u4e9b\u6570\u636e\u5168\u90e8\u7ed9\u5b83\u6784\u9020\u6210\u4e00\u4e2a\u53c2\u6570\uff0c\u4e5f\u5c31\u662f\u6211\u4eec\u77ed\u94fe\u63a5\u76d1\u63a7\u7684\u4e00\u4e2a\u8be6\u7ec6\u53c2\u6570\uff0c\u53ef\u4ee5\u770b\u5230\u8fd9\u91cc\u9762\u5565\u90fd\u6709\uff0c\u57fa\u672c\u4e0a\u628a\u90a3\u4e9b\u53c2\u6570\u90fd\u5305\u62ec\u4e86\uff0c\u6211\u7ed9\u5927\u5bb6\u8054\u8c03\u4e00\u4e0b\uff0c\u56e0\u4e3a\u592a\u590d\u6742\u4e86\uff0c\u786e\u5b9e\u4e0d\u5fcd\u5fc3\u803d\u8bef\u5927\u5bb6\u65f6\u95f4\uff0c\u6211\u5c31\u81ea\u5df1\u5199\u4e86\uff0c\u540e\u7eed\u5927\u5bb6\u53ef\u4ee5\u770b\u7740\u4ee3\u7801\u4e00\u8d77debug\u4e00\u4e0b\uff0c\u6bd4\u8f83\u5bb9\u6613\u7406\u89e3<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.service.impl;\n\n\nimport cn.hutool.core.bean.BeanUtil;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkAccessStatsDO;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkDeviceStatsDO;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkLocaleStatsDO;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkNetworkStatsDO;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkAccessLogsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkAccessStatsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkBrowserStatsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkDeviceStatsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkLocaleStatsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkNetworkStatsMapper;\nimport com.nageoffer.shortlink.project.dao.mapper.LinkOsStatsMapper;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsAccessDailyRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsBrowserRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsDeviceRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsLocaleCNRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsNetworkRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsOsRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsTopIpRespDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsUvRespDTO;\nimport com.nageoffer.shortlink.project.service.ShortLinkStatsService;\nimport lombok.RequiredArgsConstructor;\nimport org.springframework.stereotype.Service;\n\nimport java.util.ArrayList;\nimport java.util.HashMap;\nimport java.util.List;\nimport java.util.Objects;\nimport java.util.concurrent.atomic.AtomicInteger;\n\n\/**\n * \u77ed\u94fe\u63a5\u76d1\u63a7\u63a5\u53e3\u5b9e\u73b0\u5c42\n *\/\n@Service\n@RequiredArgsConstructor\npublic class ShortLinkStatsServiceImpl implements ShortLinkStatsService {\n\n    private final LinkAccessStatsMapper linkAccessStatsMapper;\n    private final LinkLocaleStatsMapper linkLocaleStatsMapper;\n    private final LinkAccessLogsMapper linkAccessLogsMapper;\n    private final LinkBrowserStatsMapper linkBrowserStatsMapper;\n    private final LinkOsStatsMapper linkOsStatsMapper;\n    private final LinkDeviceStatsMapper linkDeviceStatsMapper;\n    private final LinkNetworkStatsMapper linkNetworkStatsMapper;\n\n    @Override\n    public ShortLinkStatsRespDTO oneShortLinkStats(ShortLinkStatsReqDTO requestParam) {\n        \/\/ \u57fa\u7840\u8bbf\u95ee\u8be6\u60c5\n        List<LinkAccessStatsDO> listStatsByShortLink = linkAccessStatsMapper.listStatsByShortLink(requestParam);\n        \/\/ \u5730\u533a\u8bbf\u95ee\u8be6\u60c5\uff08\u4ec5\u56fd\u5185\uff09\n        List<ShortLinkStatsLocaleCNRespDTO> localeCnStats = new ArrayList<>();\n        List<LinkLocaleStatsDO> listedLocaleByShortLink = linkLocaleStatsMapper.listLocaleByShortLink(requestParam);\n        int localeCnSum = listedLocaleByShortLink.stream()\n                .mapToInt(LinkLocaleStatsDO::getCnt)\n                .sum();\n        listedLocaleByShortLink.forEach(each -> {\n            double ratio = (double) each.getCnt() \/ localeCnSum;\n            double actualRatio = Math.round(ratio * 100.0) \/ 100.0;\n            ShortLinkStatsLocaleCNRespDTO localeCNRespDTO = ShortLinkStatsLocaleCNRespDTO.builder()\n                    .cnt(each.getCnt())\n                    .locale(each.getProvince())\n                    .ratio(actualRatio)\n                    .build();\n            localeCnStats.add(localeCNRespDTO);\n        });\n        \/\/ \u5c0f\u65f6\u8bbf\u95ee\u8be6\u60c5\n        List<Integer> hourStats = new ArrayList<>();\n        List<LinkAccessStatsDO> listHourStatsByShortLink = linkAccessStatsMapper.listHourStatsByShortLink(requestParam);\n        for (int i = 0; i < 24; i++) {\n            AtomicInteger hour = new AtomicInteger(i);\n            int hourCnt = listHourStatsByShortLink.stream()\n                    .filter(each -> Objects.equals(each.getHour(), hour.get()))\n                    .findFirst()\n                    .map(LinkAccessStatsDO::getPv)\n                    .orElse(0);\n            hourStats.add(hourCnt);\n        }\n        \/\/ \u9ad8\u9891\u8bbf\u95eeIP\u8be6\u60c5\n        List<ShortLinkStatsTopIpRespDTO> topIpStats = new ArrayList<>();\n        List<HashMap<String, Object>> listTopIpByShortLink = linkAccessLogsMapper.listTopIpByShortLink(requestParam);\n        listTopIpByShortLink.forEach(each -> {\n            ShortLinkStatsTopIpRespDTO statsTopIpRespDTO = ShortLinkStatsTopIpRespDTO.builder()\n                    .ip(each.get(\"ip\").toString())\n                    .cnt(Integer.parseInt(each.get(\"count\").toString()))\n                    .build();\n            topIpStats.add(statsTopIpRespDTO);\n        });\n        \/\/ \u4e00\u5468\u8bbf\u95ee\u8be6\u60c5\n        List<Integer> weekdayStats = new ArrayList<>();\n        List<LinkAccessStatsDO> listWeekdayStatsByShortLink = linkAccessStatsMapper.listWeekdayStatsByShortLink(requestParam);\n        for (int i = 1; i < 8; i++) {\n            AtomicInteger weekday = new AtomicInteger(i);\n            int weekdayCnt = listWeekdayStatsByShortLink.stream()\n                    .filter(each -> Objects.equals(each.getWeekday(), weekday.get()))\n                    .findFirst()\n                    .map(LinkAccessStatsDO::getPv)\n                    .orElse(0);\n            weekdayStats.add(weekdayCnt);\n        }\n        \/\/ \u6d4f\u89c8\u5668\u8bbf\u95ee\u8be6\u60c5\n        List<ShortLinkStatsBrowserRespDTO> browserStats = new ArrayList<>();\n        List<HashMap<String, Object>> listBrowserStatsByShortLink = linkBrowserStatsMapper.listBrowserStatsByShortLink(requestParam);\n        int browserSum = listBrowserStatsByShortLink.stream()\n                .mapToInt(each -> Integer.parseInt(each.get(\"count\").toString()))\n                .sum();\n        listBrowserStatsByShortLink.forEach(each -> {\n            double ratio = (double) Integer.parseInt(each.get(\"count\").toString()) \/ browserSum;\n            double actualRatio = Math.round(ratio * 100.0) \/ 100.0;\n            ShortLinkStatsBrowserRespDTO browserRespDTO = ShortLinkStatsBrowserRespDTO.builder()\n                    .cnt(Integer.parseInt(each.get(\"count\").toString()))\n                    .browser(each.get(\"browser\").toString())\n                    .ratio(actualRatio)\n                    .build();\n            browserStats.add(browserRespDTO);\n        });\n        \/\/ \u64cd\u4f5c\u7cfb\u7edf\u8bbf\u95ee\u8be6\u60c5\n        List<ShortLinkStatsOsRespDTO> osStats = new ArrayList<>();\n        List<HashMap<String, Object>> listOsStatsByShortLink = linkOsStatsMapper.listOsStatsByShortLink(requestParam);\n        int osSum = listOsStatsByShortLink.stream()\n                .mapToInt(each -> Integer.parseInt(each.get(\"count\").toString()))\n                .sum();\n        listOsStatsByShortLink.forEach(each -> {\n            double ratio = (double) Integer.parseInt(each.get(\"count\").toString()) \/ osSum;\n            double actualRatio = Math.round(ratio * 100.0) \/ 100.0;\n            ShortLinkStatsOsRespDTO osRespDTO = ShortLinkStatsOsRespDTO.builder()\n                    .cnt(Integer.parseInt(each.get(\"count\").toString()))\n                    .os(each.get(\"os\").toString())\n                    .ratio(actualRatio)\n                    .build();\n            osStats.add(osRespDTO);\n        });\n        \/\/ \u8bbf\u5ba2\u8bbf\u95ee\u7c7b\u578b\u8be6\u60c5\n        List<ShortLinkStatsUvRespDTO> uvTypeStats = new ArrayList<>();\n        HashMap<String, Object> findUvTypeByShortLink = linkAccessLogsMapper.findUvTypeCntByShortLink(requestParam);\n        int oldUserCnt = Integer.parseInt(findUvTypeByShortLink.get(\"oldUserCnt\").toString());\n        int newUserCnt = Integer.parseInt(findUvTypeByShortLink.get(\"newUserCnt\").toString());\n        int uvSum = oldUserCnt + newUserCnt;\n        double oldRatio = (double) oldUserCnt \/ uvSum;\n        double actualOldRatio = Math.round(oldRatio * 100.0) \/ 100.0;\n        double newRatio = (double) newUserCnt \/ uvSum;\n        double actualNewRatio = Math.round(newRatio * 100.0) \/ 100.0;\n        ShortLinkStatsUvRespDTO newUvRespDTO = ShortLinkStatsUvRespDTO.builder()\n                .uvType(\"newUser\")\n                .cnt(newUserCnt)\n                .ratio(actualNewRatio)\n                .build();\n        uvTypeStats.add(newUvRespDTO);\n        ShortLinkStatsUvRespDTO oldUvRespDTO = ShortLinkStatsUvRespDTO.builder()\n                .uvType(\"oldUser\")\n                .cnt(oldUserCnt)\n                .ratio(actualOldRatio)\n                .build();\n        uvTypeStats.add(oldUvRespDTO);\n        \/\/ \u8bbf\u95ee\u8bbe\u5907\u7c7b\u578b\u8be6\u60c5\n        List<ShortLinkStatsDeviceRespDTO> deviceStats = new ArrayList<>();\n        List<LinkDeviceStatsDO> listDeviceStatsByShortLink = linkDeviceStatsMapper.listDeviceStatsByShortLink(requestParam);\n        int deviceSum = listDeviceStatsByShortLink.stream()\n                .mapToInt(LinkDeviceStatsDO::getCnt)\n                .sum();\n        listDeviceStatsByShortLink.forEach(each -> {\n            double ratio = (double) each.getCnt() \/ deviceSum;\n            double actualRatio = Math.round(ratio * 100.0) \/ 100.0;\n            ShortLinkStatsDeviceRespDTO deviceRespDTO = ShortLinkStatsDeviceRespDTO.builder()\n                    .cnt(each.getCnt())\n                    .device(each.getDevice())\n                    .ratio(actualRatio)\n                    .build();\n            deviceStats.add(deviceRespDTO);\n        });\n        \/\/ \u8bbf\u95ee\u7f51\u7edc\u7c7b\u578b\u8be6\u60c5\n        List<ShortLinkStatsNetworkRespDTO> networkStats = new ArrayList<>();\n        List<LinkNetworkStatsDO> listNetworkStatsByShortLink = linkNetworkStatsMapper.listNetworkStatsByShortLink(requestParam);\n        int networkSum = listNetworkStatsByShortLink.stream()\n                .mapToInt(LinkNetworkStatsDO::getCnt)\n                .sum();\n        listNetworkStatsByShortLink.forEach(each -> {\n            double ratio = (double) each.getCnt() \/ networkSum;\n            double actualRatio = Math.round(ratio * 100.0) \/ 100.0;\n            ShortLinkStatsNetworkRespDTO networkRespDTO = ShortLinkStatsNetworkRespDTO.builder()\n                    .cnt(each.getCnt())\n                    .network(each.getNetwork())\n                    .ratio(actualRatio)\n                    .build();\n            networkStats.add(networkRespDTO);\n        });\n        return ShortLinkStatsRespDTO.builder()\n                .daily(BeanUtil.copyToList(listStatsByShortLink, ShortLinkStatsAccessDailyRespDTO.class))\n                .localeCnStats(localeCnStats)\n                .hourStats(hourStats)\n                .topIpStats(topIpStats)\n                .weekdayStats(weekdayStats)\n                .browserStats(browserStats)\n                .osStats(osStats)\n                .uvTypeStats(uvTypeStats)\n                .deviceStats(deviceStats)\n                .networkStats(networkStats)\n                .build();\n    }\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkAccessLogsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.HashMap;\nimport java.util.List;\n\n\/**\n * \u8bbf\u95ee\u65e5\u5fd7\u76d1\u63a7\u6301\u4e45\u5c42\n *\/\npublic interface LinkAccessLogsMapper extends BaseMapper<LinkAccessLogsDO> {\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u9ad8\u9891\u8bbf\u95eeIP\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    ip, \" +\n            \"    COUNT(ip) AS count \" +\n            \"FROM \" +\n            \"    t_link_access_logs \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND create_time BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, ip \" +\n            \"ORDER BY \" +\n            \"    count DESC \" +\n            \"LIMIT 5;\")\n    List<HashMap<String, Object>> listTopIpByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u65b0\u65e7\u8bbf\u5ba2\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    SUM(old_user) AS oldUserCnt, \" +\n            \"    SUM(new_user) AS newUserCnt \" +\n            \"FROM ( \" +\n            \"    SELECT \" +\n            \"        CASE WHEN COUNT(DISTINCT DATE(create_time)) > 1 THEN 1 ELSE 0 END AS old_user, \" +\n            \"        CASE WHEN COUNT(DISTINCT DATE(create_time)) = 1 AND MAX(create_time) >= #{param.startDate} AND MAX(create_time) <= #{param.endDate} THEN 1 ELSE 0 END AS new_user \" +\n            \"    FROM \" +\n            \"        t_link_access_logs \" +\n            \"    WHERE \" +\n            \"        full_short_url = #{param.fullShortUrl} \" +\n            \"        AND gid = #{param.gid} \" +\n            \"    GROUP BY \" +\n            \"        user \" +\n            \") AS user_counts;\")\n    HashMap<String, Object> findUvTypeCntByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkAccessStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\n\/**\n * \u77ed\u94fe\u63a5\u57fa\u7840\u8bbf\u95ee\u76d1\u63a7\u6301\u4e45\u5c42\n *\/\npublic interface LinkAccessStatsMapper extends BaseMapper<LinkAccessStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u57fa\u7840\u8bbf\u95ee\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_access_stats (full_short_url, gid, date, pv, uv, uip, hour, weekday, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkAccessStats.fullShortUrl}, #{linkAccessStats.gid}, #{linkAccessStats.date}, #{linkAccessStats.pv}, #{linkAccessStats.uv}, #{linkAccessStats.uip}, #{linkAccessStats.hour}, #{linkAccessStats.weekday}, NOW(), NOW(), 0) ON DUPLICATE KEY UPDATE pv = pv +  #{linkAccessStats.pv}, \" +\n            \"uv = uv + #{linkAccessStats.uv}, \" +\n            \" uip = uip + #{linkAccessStats.uip};\")\n    void shortLinkStats(@Param(\"linkAccessStats\") LinkAccessStatsDO linkAccessStatsDO);\n\n\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u57fa\u7840\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    date, \" +\n            \"    SUM(pv) AS pv, \" +\n            \"    SUM(uv) AS uv, \" +\n            \"    SUM(uip) AS uip \" +\n            \"FROM \" +\n            \"    t_link_access_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, date;\")\n    List<LinkAccessStatsDO> listStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u5c0f\u65f6\u57fa\u7840\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    hour, \" +\n            \"    SUM(pv) AS pv \" +\n            \"FROM \" +\n            \"    t_link_access_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, hour;\")\n    List<LinkAccessStatsDO> listHourStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u5c0f\u65f6\u57fa\u7840\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    weekday, \" +\n            \"    SUM(pv) AS pv \" +\n            \"FROM \" +\n            \"    t_link_access_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, weekday;\")\n    List<LinkAccessStatsDO> listWeekdayStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}\n<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkBrowserStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.HashMap;\nimport java.util.List;\n\n\/**\n * \u6d4f\u89c8\u5668\u7edf\u8ba1\u8bbf\u95ee\u6301\u4e45\u5c42\n *\/\npublic interface LinkBrowserStatsMapper extends BaseMapper<LinkBrowserStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u6d4f\u89c8\u5668\u8bbf\u95ee\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_browser_stats (full_short_url, gid, date, cnt, browser, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkBrowserStats.fullShortUrl}, #{linkBrowserStats.gid}, #{linkBrowserStats.date}, #{linkBrowserStats.cnt}, #{linkBrowserStats.browser}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE cnt = cnt +  #{linkBrowserStats.cnt};\")\n    void shortLinkBrowserState(@Param(\"linkBrowserStats\") LinkBrowserStatsDO linkBrowserStatsDO);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u6d4f\u89c8\u5668\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    browser, \" +\n            \"    SUM(cnt) AS count \" +\n            \"FROM \" +\n            \"    t_link_browser_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, date, browser;\")\n    List<HashMap<String, Object>> listBrowserStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkDeviceStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\n\/**\n * \u8bbf\u95ee\u8bbe\u5907\u76d1\u63a7\u6301\u4e45\u5c42\n *\/\npublic interface LinkDeviceStatsMapper extends BaseMapper<LinkDeviceStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u8bbf\u95ee\u8bbe\u5907\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_device_stats (full_short_url, gid, date, cnt, device, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkDeviceStats.fullShortUrl}, #{linkDeviceStats.gid}, #{linkDeviceStats.date}, #{linkDeviceStats.cnt}, #{linkDeviceStats.device}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE cnt = cnt +  #{linkDeviceStats.cnt};\")\n    void shortLinkDeviceState(@Param(\"linkDeviceStats\") LinkDeviceStatsDO linkDeviceStatsDO);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u8bbf\u95ee\u8bbe\u5907\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    device, \" +\n            \"    SUM(cnt) AS cnt \" +\n            \"FROM \" +\n            \"    t_link_device_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, device;\")\n    List<LinkDeviceStatsDO> listDeviceStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkLocaleStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\n\/**\n * \u5730\u533a\u7edf\u8ba1\u8bbf\u95ee\u6301\u4e45\u5c42\n *\/\npublic interface LinkLocaleStatsMapper extends BaseMapper<LinkLocaleStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u5730\u533a\u8bbf\u95ee\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_locale_stats (full_short_url, gid, date, cnt, country, province, city, adcode, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkLocaleStats.fullShortUrl}, #{linkLocaleStats.gid}, #{linkLocaleStats.date}, #{linkLocaleStats.cnt}, #{linkLocaleStats.country}, #{linkLocaleStats.province}, #{linkLocaleStats.city}, #{linkLocaleStats.adcode}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE cnt = cnt +  #{linkLocaleStats.cnt};\")\n    void shortLinkLocaleState(@Param(\"linkLocaleStats\") LinkLocaleStatsDO linkLocaleStatsDO);\n\n\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u57fa\u7840\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    province, \" +\n            \"    SUM(cnt) AS cnt \" +\n            \"FROM \" +\n            \"    t_link_locale_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, province;\")\n    List<LinkLocaleStatsDO> listLocaleByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkNetworkStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.List;\n\n\/**\n * \u8bbf\u95ee\u7f51\u7edc\u76d1\u63a7\u6301\u4e45\u5c42\n *\/\npublic interface LinkNetworkStatsMapper extends BaseMapper<LinkNetworkStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u8bbf\u95ee\u8bbe\u5907\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_network_stats (full_short_url, gid, date, cnt, network, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkNetworkStats.fullShortUrl}, #{linkNetworkStats.gid}, #{linkNetworkStats.date}, #{linkNetworkStats.cnt}, #{linkNetworkStats.network}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE cnt = cnt +  #{linkNetworkStats.cnt};\")\n    void shortLinkNetworkState(@Param(\"linkNetworkStats\") LinkNetworkStatsDO linkNetworkStatsDO);\n\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u8bbf\u95ee\u7f51\u7edc\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    network, \" +\n            \"    SUM(cnt) AS cnt \" +\n            \"FROM \" +\n            \"    t_link_network_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid, network;\")\n    List<LinkNetworkStatsDO> listNetworkStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}\n<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkOsStatsDO;\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Select;\n\nimport java.util.HashMap;\nimport java.util.List;\n\n\/**\n * \u64cd\u4f5c\u7cfb\u7edf\u7edf\u8ba1\u8bbf\u95ee\u6301\u4e45\u5c42\n *\/\npublic interface LinkOsStatsMapper extends BaseMapper<LinkOsStatsDO> {\n\n    \/**\n     * \u8bb0\u5f55\u5730\u533a\u8bbf\u95ee\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_os_stats (full_short_url, gid, date, cnt, os, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkOsStats.fullShortUrl}, #{linkOsStats.gid}, #{linkOsStats.date}, #{linkOsStats.cnt}, #{linkOsStats.os}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE cnt = cnt +  #{linkOsStats.cnt};\")\n    void shortLinkOsState(@Param(\"linkOsStats\") LinkOsStatsDO linkOsStatsDO);\n\n    \/**\n     * \u6839\u636e\u77ed\u94fe\u63a5\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u5185\u64cd\u4f5c\u7cfb\u7edf\u76d1\u63a7\u6570\u636e\n     *\/\n    @Select(\"SELECT \" +\n            \"    os, \" +\n            \"    SUM(cnt) AS count \" +\n            \"FROM \" +\n            \"    t_link_os_stats \" +\n            \"WHERE \" +\n            \"    full_short_url = #{param.fullShortUrl} \" +\n            \"    AND gid = #{param.gid} \" +\n            \"    AND date BETWEEN #{param.startDate} and #{param.endDate} \" +\n            \"GROUP BY \" +\n            \"    full_short_url, gid,  os;\")\n    List<HashMap<String, Object>> listOsStatsByShortLink(@Param(\"param\") ShortLinkStatsReqDTO requestParam);\n\n}\n<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u6d4f\u89c8\u5668\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsBrowserRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u6d4f\u89c8\u5668\n     *\/\n    private String browser;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport lombok.Data;\n\nimport java.util.Date;\n\n\/**\n * \u77ed\u94fe\u63a5\u57fa\u7840\u8bbf\u95ee\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\npublic class ShortLinkStatsAccessDailyRespDTO {\n\n    \/**\n     * \u65e5\u671f\n     *\/\n    @JsonFormat(pattern = \"yyyy-MM-dd\", timezone = \"GMT+8\")\n    private Date date;\n\n    \/**\n     * \u8bbf\u95ee\u91cf\n     *\/\n    private Integer pv;\n\n    \/**\n     * \u72ec\u7acb\u8bbf\u5ba2\u6570\n     *\/\n    private Integer uv;\n\n    \/**\n     * \u72ec\u7acbIP\u6570\n     *\/\n    private Integer uip;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u8bbf\u95ee\u8bbe\u5907\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsDeviceRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u8bbe\u5907\u7c7b\u578b\n     *\/\n    private String device;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u5730\u533a\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsLocaleCNRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u5730\u533a\n     *\/\n    private String locale;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u8bbf\u95ee\u7f51\u7edc\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsNetworkRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u8bbf\u95ee\u7f51\u7edc\n     *\/\n    private String network;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u64cd\u4f5c\u7cfb\u7edf\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsOsRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u64cd\u4f5c\u7cfb\u7edf\n     *\/\n    private String os;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\nimport java.util.List;\n\n\/**\n * \u77ed\u94fe\u63a5\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsRespDTO {\n\n    \/**\n     * \u8bbf\u95ee\u91cf\n     *\/\n    private Integer pv;\n\n    \/**\n     * \u72ec\u7acb\u8bbf\u5ba2\u6570\n     *\/\n    private Integer uv;\n\n    \/**\n     * \u72ec\u7acbIP\u6570\n     *\/\n    private Integer uip;\n\n    \/**\n     * \u57fa\u7840\u8bbf\u95ee\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsAccessDailyRespDTO> daily;\n\n    \/**\n     * \u5730\u533a\u8bbf\u95ee\u8be6\u60c5\uff08\u4ec5\u56fd\u5185\uff09\n     *\/\n    private List<ShortLinkStatsLocaleCNRespDTO> localeCnStats;\n\n    \/**\n     * \u5c0f\u65f6\u8bbf\u95ee\u8be6\u60c5\n     *\/\n    private List<Integer> hourStats;\n\n    \/**\n     * \u9ad8\u9891\u8bbf\u95eeIP\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsTopIpRespDTO> topIpStats;\n\n    \/**\n     * \u4e00\u5468\u8bbf\u95ee\u8be6\u60c5\n     *\/\n    private List<Integer> weekdayStats;\n\n    \/**\n     * \u6d4f\u89c8\u5668\u8bbf\u95ee\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsBrowserRespDTO> browserStats;\n\n    \/**\n     * \u64cd\u4f5c\u7cfb\u7edf\u8bbf\u95ee\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsOsRespDTO> osStats;\n\n    \/**\n     * \u8bbf\u5ba2\u8bbf\u95ee\u7c7b\u578b\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsUvRespDTO> uvTypeStats;\n\n    \/**\n     * \u8bbf\u95ee\u8bbe\u5907\u7c7b\u578b\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsDeviceRespDTO> deviceStats;\n\n    \/**\n     * \u8bbf\u95ee\u7f51\u7edc\u7c7b\u578b\u8be6\u60c5\n     *\/\n    private List<ShortLinkStatsNetworkRespDTO> networkStats;\n}\n<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u9ad8\u9891\u8bbf\u95eeIP\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsTopIpRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * IP\n     *\/\n    private String ip;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.dto.resp;\n\nimport lombok.AllArgsConstructor;\nimport lombok.Builder;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\n\n\/**\n * \u77ed\u94fe\u63a5\u8bbf\u5ba2\u76d1\u63a7\u54cd\u5e94\u53c2\u6570\n *\/\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class ShortLinkStatsUvRespDTO {\n\n    \/**\n     * \u7edf\u8ba1\n     *\/\n    private Integer cnt;\n\n    \/**\n     * \u8bbf\u5ba2\u7c7b\u578b\n     *\/\n    private String uvType;\n\n    \/**\n     * \u5360\u6bd4\n     *\/\n    private Double ratio;\n}<\/pre>\n\n\n\n
package com.nageoffer.shortlink.project.service;\n\nimport com.nageoffer.shortlink.project.dto.req.ShortLinkStatsReqDTO;\nimport com.nageoffer.shortlink.project.dto.resp.ShortLinkStatsRespDTO;\n\n\/**\n * \u77ed\u94fe\u63a5\u76d1\u63a7\u63a5\u53e3\u5c42\n *\/\npublic interface ShortLinkStatsService {\n\n    \/**\n     * \u83b7\u53d6\u5355\u4e2a\u77ed\u94fe\u63a5\u76d1\u63a7\u6570\u636e\n     *\n     * @param requestParam \u83b7\u53d6\u77ed\u94fe\u63a5\u76d1\u63a7\u6570\u636e\u5165\u53c2\n     * @return \u77ed\u94fe\u63a5\u76d1\u63a7\u6570\u636e\n     *\/\n    ShortLinkStatsRespDTO oneShortLinkStats(ShortLinkStatsReqDTO requestParam);\n}\n<\/pre>\n\n\n\n
\u201cfeature: \u5f00\u53d1\u5355\u4e2a\u77ed\u94fe\u63a5\u8bbf\u95ee\u76d1\u63a7\u8be6\u60c5\u529f\u80fd\u201d\u914d\u540811.18\u7684fix: \u4fee\u590d\u77ed\u94fe\u63a5\u76d1\u63a7\u76f8\u5173\u6570\u636e<\/p>\n\n\n\n
\n
\u9ad8\u9891\u8bbf\u95eeip\u90a3\u6bb5\u4ee3\u7801\u6709\u70b9\u95ee\u9898\uff0c\u4f20\u5165\u53c2\u6570\u7684\u65f6\u95f4\u662f\u65e5\u671f\uff0c\u67e5\u8be2\u7528\u7684\u662fcreate_time\uff0c\u4f1a\u628a\u65e5\u671f\u8f6c\u6362\u4e3a\u5f53\u5929\u76840\u70b9\uff0c\u8fd9\u6837\u7684\u8bdd\u4f20\u5165\u7684\u7ed3\u675f\u65e5\u671f\u5f53\u5929\u7684\u6570\u636e\u5c31\u67e5\u4e0d\u5230\u4e86\u3002\u6211\u7528\u7684\u6bd4\u8f83\u7b28\u7684\u65b9\u6cd5\u5c31\u662f\u5728mapper\u91cc\u9762\u67e5\u8be2\u7684\u65f6\u5019\u518d\u589e\u52a0\u4e24\u4e2a\u53c2\u6570\uff0c\u4e00\u4e2a\u662f\u5f00\u59cb\u65e5\u671f\u540e\u9762\u62fc\u63a500:00:00\uff0c\u4e00\u4e2a\u662f\u7ed3\u675f\u65e5\u671f\u540e\u9762\u62fc\u63a523:59:59
t_link_access_logs \u8868\u4e2d\u7684sql\u548ccreateTime\u6709\u5173\u7684\u90fd\u5f97\u6362\u6210 CONCAT(#{param.startDate},' 00:00:00') \u548c CONCAT(#{param.endDate},' 23:59:59') \u4e0d\u7136\u67e5\u4e0d\u5230\u5f53\u5929\u7684\u6570\u636e<\/p>\n<\/blockquote>\n\n\n\n
\n
 \u4e3a\u4ec0\u4e48\u8981\u4f7f\u7528AtomicInteger\u6570\u636e\u7c7b\u578b\uff1f\u56e0\u4e3alamda\u91cc\u4e0d\u5141\u8bb8\u7528 int\uff0c\u5176\u5b9e\u4f7f\u7528 Integer \u4e5f\u662f\u53ef\u4ee5\u7684\uff1aAtomicInteger \u662f\u4f60\u8bf4\u7684\u8fd9\u4e2a\u6548\u679c\uff0c\u4e0d\u8fc7\u54b1\u4eec\u8fd9\u91cc\u4ec5\u4e3a\u4e86\u9075\u5b88 lamda \u8868\u8fbe\u5f0f\u7684\u89c4\u8303<\/p>\n<\/blockquote>\n\n\n\n
\n
\u5355\u4e2a\u77ed\u94fe\u63a5\u4ee5\u53ca\u5206\u7ec4\u76d1\u63a7\u4e2d\u6d4f\u89c8\u5668\u7684\u7edf\u8ba1 SQL \u4e5f\u5e94\u8be5\u5c06 date \u5206\u7ec4\u6761\u4ef6\u5220\u6389\uff0c\u8be6\u60c5\u67e5\u770b\u4e0b\u8ff0\u63d0\u4ea4\u3002<\/p>\n<\/blockquote>\n\n\n\n
- \u7b2c14\u8282\uff1a\u5982\u4f55\u8bb0\u5f55\u77ed\u94fe\u63a5\u8bbf\u95ee\u65e5\u5fd7<\/h2>\n\n\n\n
\u5b83\u5176\u5b9e\u662f\u6709\u4e00\u4e2a\u8bbf\u95ee\u76d1\u63a7\u7684\uff1a\u8bbf\u95ee\u65f6\u95f4\uff0c\u8bbf\u95eeIP\uff0c\u8bbf\u5ba2\u5730\u533a\uff0c\u8bbe\u5907\u4fe1\u606f\uff0c\u8bbf\u5ba2\u7c7b\u578b\uff0c\u8bbf\u95ee\u6765\u6e90\uff0c\u8bbf\u95ee\u94fe\u63a5\uff1b<\/p>\n\n\n\n
t_link_access_logs\u6570\u636e\u5e93\u6dfb\u52a02\u4e2a\uff0cdevice\uff0cvarchar(64)\u8bbf\u95ee\u8bbe\u5907\uff1bnetwork varchar(64)\u8bbf\u95ee\u7f51\u7edc\uff1b<\/p>\n\n\n\n
ALTER TABLE t_link_access_logs\nADD COLUMN `network` VARCHAR(64) DEFAULT NULL COMMENT '\u8bbf\u95ee\u7f51\u7edc' AFTER `os`,\nADD COLUMN `device` VARCHAR(64) DEFAULT NULL COMMENT '\u8bbf\u95ee\u8bbe\u5907' AFTER `network`,\nADD COLUMN `locale` VARCHAR(256) DEFAULT NULL COMMENT '\u8bbf\u95ee\u5730\u533a' AFTER `device`;\n\nALTER TABLE t_link_access_logs\nMODIFY COLUMN `ip` VARCHAR(64) DEFAULT NULL COMMENT 'IP' AFTER `user`;<\/code><\/pre>\n\n\n\n
LinkAccessLogsDO.java\u6dfb\u52a0<\/p>\n\n\n\n
    \/**\n     * \u8bbf\u95ee\u7f51\u7edc\n     *\/\n    private String network;\n\n    \/**\n     * \u8bbf\u95ee\u8bbe\u5907\n     *\/\n    private String device;\n\n    \/**\n     * \u5730\u533a\n     *\/\n    private String locale;<\/code><\/pre>\n\n\n\n
- \u7b2c15\u8282\uff1a\u5206\u9875\u67e5\u8be2\u77ed\u94fe\u63a5\u8bbf\u95ee\u65e5\u5fd7<\/h2>\n\n\n\n
    private void shortLinkStats(String fullShortUrl, String gid, ServletRequest request, ServletResponse response) {\n        AtomicBoolean uvFirstFlag = new AtomicBoolean();\n        Cookie[] cookies = ((HttpServletRequest) request).getCookies();\n        try {\n            AtomicReference<String> uv = new AtomicReference<>();\n            Runnable addResponseCookieTask = () -> {\n                uv.set(UUID.fastUUID().toString());\n                Cookie uvCookie = new Cookie(\"uv\", uv.get());\n                uvCookie.setMaxAge(60 * 60 * 24 * 30);\n                uvCookie.setPath(StrUtil.sub(fullShortUrl, fullShortUrl.indexOf(\"\/\"), fullShortUrl.length()));\n                ((HttpServletResponse) response).addCookie(uvCookie);\n                uvFirstFlag.set(Boolean.TRUE);\n                stringRedisTemplate.opsForSet().add(\"short-link:stats:uv:\" + fullShortUrl, uv.get());\n            };\n            if (ArrayUtil.isNotEmpty(cookies)) {\n                Arrays.stream(cookies)\n                        .filter(each -> Objects.equals(each.getName(), \"uv\"))\n                        .findFirst()\n                        .map(Cookie::getValue)\n                        .ifPresentOrElse(each -> {\n                            uv.set(each);\n                            Long uvAdded = stringRedisTemplate.opsForSet().add(\"short-link:stats:uv:\" + fullShortUrl, each);\n                            uvFirstFlag.set(uvAdded != null && uvAdded > 0L);\n                        }, addResponseCookieTask);\n            } else {\n                addResponseCookieTask.run();\n            }\n            String remoteAddr = LinkUtil.getActualIp(((HttpServletRequest) request));\n            Long uipAdded = stringRedisTemplate.opsForSet().add(\"short-link:stats:uip:\" + fullShortUrl, remoteAddr);\n            boolean uipFirstFlag = uipAdded != null && uipAdded > 0L;\n            if (StrUtil.isBlank(gid)) {\n                LambdaQueryWrapper<ShortLinkGotoDO> queryWrapper = Wrappers.lambdaQuery(ShortLinkGotoDO.class)\n                        .eq(ShortLinkGotoDO::getFullShortUrl, fullShortUrl);\n                ShortLinkGotoDO shortLinkGotoDO = shortLinkGotoMapper.selectOne(queryWrapper);\n                gid = shortLinkGotoDO.getGid();\n            }\n            int hour = DateUtil.hour(new Date(), true);\n            Week week = DateUtil.dayOfWeekEnum(new Date());\n            int weekValue = week.getIso8601Value();\n            LinkAccessStatsDO linkAccessStatsDO = LinkAccessStatsDO.builder()\n                    .pv(1)\n                    \/\/uv\u4e0d\u518d\u8bbe\u7f6e\u62101\n                    .uv(uvFirstFlag.get() ? 1 : 0)\n                    .uip(uipFirstFlag ? 1 : 0)\n                    .hour(hour)\n                    .weekday(weekValue)\n                    .fullShortUrl(fullShortUrl)\n                    .gid(gid)\n                    .date(new Date())\n                    .build();\n            linkAccessStatsMapper.shortLinkStats(linkAccessStatsDO);\n            Map<String, Object> localeParamMap = new HashMap<>();\n            localeParamMap.put(\"key\", statsLocaleAmapKey);\n            localeParamMap.put(\"ip\", remoteAddr);\n            String localeResultStr = HttpUtil.get(AMAP_REMOTE_URL, localeParamMap);\n            JSONObject localeResultObj = JSON.parseObject(localeResultStr);\n            String infoCode = localeResultObj.getString(\"infocode\");\n            String actualProvince;\n            String actualCity;\n\n            if (StrUtil.isNotBlank(infoCode) && StrUtil.equals(infoCode, \"10000\")) {\n                String province = localeResultObj.getString(\"province\");\n                boolean unknownFlag = StrUtil.equals(province, \"[]\");\n                LinkLocaleStatsDO linkLocaleStatsDO = LinkLocaleStatsDO.builder()\n                        \/*\n                        .province(unknownFlag ? \"\u672a\u77e5\" : province)\n                        .city(unknownFlag ? \"\u672a\u77e5\" : localeResultObj.getString(\"city\"))\n                        *\/\n                        .province(actualProvince = unknownFlag ? \"\u672a\u77e5\" : province)\n                        .city(actualCity = unknownFlag ? \"\u672a\u77e5\" : localeResultObj.getString(\"city\"))\n\n                        .adcode(unknownFlag ? \"\u672a\u77e5\" : localeResultObj.getString(\"adcode\"))\n                        .cnt(1)\n                        .fullShortUrl(fullShortUrl)\n                        .country(\"\u4e2d\u56fd\")\n                        .gid(gid)\n                        .date(new Date())\n                        .build();\n                linkLocaleStatsMapper.shortLinkLocaleState(linkLocaleStatsDO);\n                String os = LinkUtil.getOs(((HttpServletRequest) request));\n\n                LinkOsStatsDO linkOsStatsDO = LinkOsStatsDO.builder()\n                        .os(os)\n                        .cnt(1)\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .date(new Date())\n                        .build();\n                linkOsStatsMapper.shortLinkOsState(linkOsStatsDO);\n                String browser = LinkUtil.getBrowser(((HttpServletRequest) request));\n\n                LinkBrowserStatsDO linkBrowserStatsDO = LinkBrowserStatsDO.builder()\n                        .browser(browser)\n                        .cnt(1)\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .date(new Date())\n                        .build();\n               \/*\n                LinkAccessLogsDO linkAccessLogsDO = LinkAccessLogsDO.builder()\n                        .user(uv.get())\n                        .ip(remoteAddr)\n                        .browser(browser)\n                        .os(os)\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .build();\n                linkAccessLogsMapper.insert(linkAccessLogsDO);\n                *\/\n                linkBrowserStatsMapper.shortLinkBrowserState(linkBrowserStatsDO);\n                String device = LinkUtil.getDevice(((HttpServletRequest) request));\n\n                LinkDeviceStatsDO linkDeviceStatsDO = LinkDeviceStatsDO.builder()\n                        \/\/.device(LinkUtil.getDevice(((HttpServletRequest) request)))\n                        .device(device)\n                        .cnt(1)\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .date(new Date())\n                        .build();\n                linkDeviceStatsMapper.shortLinkDeviceState(linkDeviceStatsDO);\n                String network = LinkUtil.getNetwork(((HttpServletRequest) request));\n\n                LinkNetworkStatsDO linkNetworkStatsDO = LinkNetworkStatsDO.builder()\n                        \/\/.network(LinkUtil.getNetwork(((HttpServletRequest) request)))\n                        .network(network)\n                        .cnt(1)\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .date(new Date())\n                        .build();\n                linkNetworkStatsMapper.shortLinkNetworkState(linkNetworkStatsDO);\n                LinkAccessLogsDO linkAccessLogsDO = LinkAccessLogsDO.builder()\n                        .user(uv.get())\n                        .ip(remoteAddr)\n                        .browser(browser)\n                        .os(os)\n                        .network(network)\n                        .device(device)\n                        .locale(StrUtil.join(\"-\", \"\u4e2d\u56fd\", actualProvince, actualCity))\n                        .gid(gid)\n                        .fullShortUrl(fullShortUrl)\n                        .build();\n                linkAccessLogsMapper.insert(linkAccessLogsDO);\n\n            }\n\n        } catch (Throwable ex) {\n            log.error(\"\u77ed\u94fe\u63a5\u8bbf\u95ee\u91cf\u7edf\u8ba1\u5f02\u5e38\", ex);\n        }\n    }<\/code><\/pre>\n\n\n\n
\u4fee\u6539host\u7684\u90a3\u4e2aip\u4f4d127.0.0.1\u5bfc\u5411nageoffer.com ,\u5728\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95eenurl.ink:8001\/1fN5rc\uff0c\u5373\u53ef\"\"<\/p>\n\n\n\n
- \u7b2c16\u8282\uff1a\u5206\u9875\u67e5\u8be2\u77ed\u94fe\u63a5\u4eca\u65e5\u4ee5\u53ca\u5386\u53f2\u8bbf\u95ee\u4fe1\u606f\u8bbe\u8ba1<\/h2>\n\n\n\n
\n
 \u8fd9\u91cc\u4e3a\u4ec0\u4e48\u4e0d\u76f4\u63a5\u6839\u636ecreatetime between 0 - \u73b0\u5728\u65f6\u95f4 \u6765\u67e5\uff0c\u7136\u540esum\u4e00\u4e0b : \u611f\u89c9\u76f4\u63a5Date creatime = CURDATE\uff08\uff09\u5c31\u80fd\u67e5\u5f53\u65e5\u7684
\u5b9e\u73b0\u65b9\u6cd5\u6709\u5f88\u591a\uff0c\u53ea\u4e0d\u8fc7\u6211\u7528\u4e86\u5176\u4e2d\u4e00\u79cd\u800c\u5df2\u3002\u5982\u679c\u6309\u7167\u4f60\u8bf4\u7684\u8fd9\u79cd\u6539\u6539\u4ee3\u7801\u4e5f\u80fd\u7528\uff0c\u90a3\u5c31\u6ca1\u95ee\u9898 <\/p>\n<\/blockquote>\n\n\n\n
 \u77ed\u94fe\u63a5\u76d1\u63a7\u4e4b\u5206\u9875\u67e5\u8be2PV\u3001UV\u3001UIP<\/p>\n\n\n\n
 \u77ed\u94fe\u63a5link\u8868\u65b0\u589e\u5386\u53f2\u7edf\u8ba1\u5b57\u6bb5<\/p>\n\n\n\n
`total_pv` int(11) DEFAULT '0' COMMENT '\u5386\u53f2PV',\n`total_uv` int(11) DEFAULT '0' COMMENT '\u5386\u53f2UV',\n`total_uip` int(11) DEFAULT '0' COMMENT '\u5386\u53f2UIP',\n\n\n\u9488\u5bf9\u539f\u94fe\u63a5\u8868\u7684\u4fee\u6539, \u8fd9\u91cc\u53ef\u4ee5\u7528\u6d4b\u8bd5\u6587\u4ef6\u5feb\u901f\u751f\u6210\nALTER TABLE t_link_%d ADD COLUMN total_uv INT DEFAULT 0 COMMENT '\u5386\u53f2uv' after `describe` , \nADD COLUMN total_pv INT DEFAULT 0 COMMENT '\u5386\u53f2pv' after total_uv , \nADD COLUMN total_uip INT DEFAULT 0 COMMENT '\u5386\u53f2uip' after total_pv ;<\/code><\/pre>\n\n\n\n
\u589e\u52a0\u6bcf\u65e5\u7edf\u8ba1\u8868<\/p>\n\n\n\n
CREATE TABLE `t_link_stats_today` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',\n  `gid` varchar(32) DEFAULT 'default' COMMENT '\u5206\u7ec4\u6807\u8bc6',\n  `full_short_url` varchar(128) DEFAULT NULL COMMENT '\u77ed\u94fe\u63a5',\n  `date` date DEFAULT NULL COMMENT '\u65e5\u671f',\n  `today_pv` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5PV',\n  `today_uv` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5UV',\n  `today_uip` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5IP\u6570',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  `update_time` datetime DEFAULT NULL COMMENT '\u4fee\u6539\u65f6\u95f4',\n  `del_flag` tinyint(1) DEFAULT NULL COMMENT '\u5220\u9664\u6807\u8bc6 0\uff1a\u672a\u5220\u9664 1\uff1a\u5df2\u5220\u9664',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `idx_unique_full-short-url` (`full_short_url`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;;\n<\/code><\/pre>\n\n\n\n
 \u9a6c\u4e01\u9009\u62e9\u91cd\u65b0\u521b\u5efa16\u4e2a\u8868\u5e76\u53c8\u5199\u5165\u6570\u636e\uff0c<\/p>\n\n\n\n
\"\"<\/p>\n\n\n\n
\u4e0b\u9762\u90fd\u662f feature\uff1a\u5f00\u53d1\u77ed\u94fe\u63a5\u5206\u9875\u76d1\u63a7\u76f8\u5173\u529f\u80fd\uff1b

optimize:\u5b8c\u5584\u77ed\u94fe\u63a5\u76d1\u63a7\u63a5\u53e3\u529f\u80fd-------feature:\u5f00\u53d1\u77ed\u94fe\u63a5\u76d1\u63a7\u76f8\u5173\u7528\u6237\u8bbf\u95ee\u660e\u7ec6-------fix:\u4fee\u590d\u77ed\u94fe\u63a5\u76d1\u63a7\u76f8\u5173\u6570\u636e--------feature\uff1a\u5f00\u53d1\u77ed\u94fe\u63a5\u76d1\u63a7\u4e4b\u5206\u9875\u8bbf\u95ee\u8bb0\u5f55\u63a5\u53e3\u8fd9\u4e9b\u5c31\u4e0d\u518d\u8d58\u8ff0\u4e86<\/p>\n\n\n\n
 project\\dao\\entity\u6dfb\u52a0\u5982\u4e0b\u4ee3\u7801<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dao.entiry;\n\nimport com.baomidou.mybatisplus.annotation.TableName;\nimport com.nageoffer.shortlink.project.common.database.BaseDO;\nimport lombok.Data;\n\nimport java.util.Date;\n\n\/**\n * \u77ed\u94fe\u63a5\u4eca\u65e5\u7edf\u8ba1\u5b9e\u4f53\n *\/\n@TableName(\"t_link_stats_today\")\n@Data\npublic class LinkStatsTodayDO extends BaseDO {\n\n    \/**\n     * id\n     *\/\n    private Long id;\n\n    \/**\n     * \u5206\u7ec4\u6807\u8bc6\n     *\/\n    private String gid;\n\n    \/**\n     * \u77ed\u94fe\u63a5\n     *\/\n    private String fullShortUrl;\n\n    \/**\n     * \u65e5\u671f\n     *\/\n    private Date date;\n\n    \/**\n     * \u4eca\u65e5pv\n     *\/\n    private Integer todayPv;\n\n    \/**\n     * \u4eca\u65e5uv\n     *\/\n    private Integer todayUv;\n\n    \/**\n     * \u4eca\u65e5ip\u6570\n     *\/\n    private Integer todayIpCount;\n}<\/pre>\n\n\n\n
 LinkStatsTodayMapper.java\u5982\u4e0b<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkStatsTodayDO;\n\n\/**\n * \u77ed\u94fe\u63a5\u4eca\u65e5\u7edf\u8ba1\u6301\u4e45\u5c42\n * *\/\npublic interface LinkStatsTodayMapper extends BaseMapper<LinkStatsTodayDO> {\n}<\/pre>\n\n\n\n
 ShortLinkDO\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9<\/p>\n\n\n\n
\/**\n * \u5386\u53f2PV\n *\/\nprivate Integer totalPv;\n\n\/**\n * \u5386\u53f2UV\n *\/\nprivate Integer totalUv;\n\n\/**\n * \u5386\u53f2UIP\n *\/\nprivate Integer totalUip;\n<\/pre>\n\n\n\n
\u5206\u9875\u67e5\u8be2\u51fa\u6765\u7684project\\dto\\resp\u7684ShortLinkPageRespDTO.java\u6dfb\u52a0\u5982\u4e0b <\/p>\n\n\n\n
\/**\n * \u5386\u53f2PV\n *\/\nprivate Integer totalPv;\n\n\/**\n * \u4eca\u65e5PV\n *\/\nprivate Integer toDayPv;\n\n\/**\n * \u5386\u53f2UV\n *\/\nprivate Integer totalUv;\n\n\/**\n * \u4eca\u65e5UV\n *\/\nprivate Integer toDayUv;\n\n\/**\n * \u5386\u53f2UIP\n *\/\nprivate Integer totalUIp;\n\n\/**\n * \u4eca\u65e5UIP\n *\/\nprivate Integer toDayUIp;<\/pre>\n\n\n\n
\u5269\u4e0b\u7684\u4e24\u4e2a admin\\remote\\dto\\req\u6dfb\u52a0ShortLinkPageReqDTO.java<\/p>\n\n\n\n
\/**\n * \u6392\u5e8f\u6807\u8bc6\n *\/\nprivate String orderTag;<\/pre>\n\n\n\n
 ShortLinkPageRespDTO.java\u6dfb\u52a0admin\\remote\\dto\\resp<\/p>\n\n\n\n
\/**\n * \u5386\u53f2PV\n *\/\nprivate Integer totalPv;\n\n\/**\n * \u4eca\u65e5PV\n *\/\nprivate Integer todayPv;\n\n\/**\n * \u5386\u53f2UV\n *\/\nprivate Integer totalUv;\n\n\/**\n * \u4eca\u65e5UV\n *\/\nprivate Integer todayUv;\n\n\/**\n * \u5386\u53f2UIP\n *\/\nprivate Integer totalUip;\n\n\/**\n * \u4eca\u65e5UIP\n *\/\nprivate Integer todayUip;<\/pre>\n\n\n\n
\u65b0\u5efa \u8868<\/p>\n\n\n\n
package com.nageoffer.shortlink.admin.test;\n\npublic class UserTableShardingTest {\n\n    public static final String SQL = \"CREATE TABLE `t_link_stats_today_%d` (\\n\"\n            + \"    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',\\n\"\n            + \"    `gid` varchar(32) DEFAULT 'default' COMMENT '\u5206\u7ec4\u6807\u8bc6',\\n\"\n            + \"    `full_short_url` varchar(128) DEFAULT NULL COMMENT '\u77ed\u94fe\u63a5',\\n\"\n            + \"    `date` date DEFAULT NULL COMMENT '\u65e5\u671f',\\n\"\n            + \"    `today_pv` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5PV',\\n\"\n            + \"    `today_uv` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5UV',\\n\"\n            + \"    `today_uip` int(11) DEFAULT '0' COMMENT '\u4eca\u65e5IP\u6570',\\n\"\n            + \"    `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\\n\"\n            + \"    `update_time` datetime DEFAULT NULL COMMENT '\u4fee\u6539\u65f6\u95f4',\\n\"\n            + \"    `del_flag` tinyint(1) DEFAULT NULL COMMENT '\u5220\u9664\u6807\u8bc6 0\uff1a\u672a\u5220\u9664 1\uff1a\u5df2\u5220\u9664',\\n\"\n            + \"    PRIMARY KEY (`id`),\\n\"\n            + \"    UNIQUE KEY `idx_unique_today_stats` (`full_short_url`,`gid`,`date`) USING BTREE\\n\"\n            + \") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\";\n\n    public static void main(String[] args) {\n        for (int i = 0; i < 16; i++) {\n            System.out.printf((SQL) + \"%n\", i);\n        }\n    }\n}<\/code><\/pre>\n\n\n\n
\n\n\n\n
 \u6211\u611f\u89c9\u5176\u5b9e\u6ca1\u5fc5\u8981\u65b0\u5efa\u4e00\u5f20\u8868\uff0c\u7ef4\u62a4\u8fd9\u5f20\u8868\u611f\u89c9\uff0c\u6bcf\u6b21\u8bbf\u95ee\u7684\u65f6\u5019\u90fd\u8981\u540c\u65f6\u64cd\u4f5c\u591a\u5f20\u8868\uff0c\u6240\u4ee5\u6211\u89c9\u5f97\u5176\u5b9e\u53ef\u4ee5\u76f4\u63a5\u7528t_link_access_stats\u8fd9\u5f20\u8868\uff0c\u56e0\u4e3a\u8fd9\u5f20\u8868\u91cc\u6839\u636eDate\u6709\u552f\u4e00\u7d22\u5f15\uff0c\u67e5\u8be2\u5f53\u5929\u7684\u8bbf\u95ee\u6570\u636e\u7684\u8bdd\u76f4\u63a5\u67e5\u5f53\u5929\u7684\uff0c\u5386\u53f2\u7684\u5c31\u76f4\u63a5\u6240\u6709\u7684sum\u52a0\u8d77\u6765\u5c31\u53ef\u4ee5\"\"<\/p>\n\n\n\n
\u5b8c\u5168\u662f\u53ef\u4ee5\u7684\uff0c\u540e\u671f\u8981\u662f\u6015\u9891\u7e41sum\uff0c\u76f4\u63a5\u628asum\u7ed3\u679c\u6570\u636e\u5b58redis\u3002\u518d\u8d70\u4e00\u5c42redis\u515c\u5e95\u5c31\u5b8c\u7f8e\u4e86 <\/p>\n\n\n\n
- \u7b2c17\u8282\uff1a\u5982\u4f55\u7edf\u8ba1\u77ed\u94fe\u63a5\u6c47\u603b\u8bbf\u95ee\u6570\u636e<\/h2>\n\n\n\n
\n\n\n\n
\u8fd9\u91cc\u4fee\u6539\u77ed\u94fe\u63a5\u90e8\u5206\u7684\u4e1a\u52a1\u4ee3\u7801\u4e5f\u9700\u8981\u4fee\u6539\uff1a \u540e\u9762\u91cd\u6784\u4e86\uff0c\u4fee\u6539\u77ed\u94fe\u63a5\u5206\u7ec4\u4e0d\u9700\u8981\u53d8\u66f4\u76d1\u63a7\u8868<\/p>\n\n\n\n
 \u6211\u4eec\u5206\u8868\u7684\u64cd\u4f5c\u4fee\u6539shardingsphere-config-dev.yaml<\/p>\n\n\n\n
# \u6570\u636e\u6e90\u96c6\u5408\ndataSources:\n  ds_0:\n    dataSourceClassName: com.zaxxer.hikari.HikariDataSource\n    driverClassName: com.mysql.cj.jdbc.Driver\n    jdbcUrl: jdbc:mysql:\/\/127.0.0.1:3306\/link?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true&allowMultiQueries=true&serverTimezone=Asia\/Shanghai\n    username: root\n    password: root\n\nrules:\n  - !SHARDING\n    tables:\n      t_link:\n        actualDataNodes: ds_0.t_link_${0..15}\n        tableStrategy:\n          standard:\n            shardingColumn: gid\n            shardingAlgorithmName: link_table_hash_mod\n      t_link_goto:\n        actualDataNodes: ds_0.t_link_goto_${0..15}\n        tableStrategy:\n          standard:\n            shardingColumn: full_short_url\n            shardingAlgorithmName: link_goto_table_hash_mod\n      t_link_stats_today:\n        actualDataNodes: ds_0.t_link_stats_today_${0..15}\n        tableStrategy:\n          standard:\n            shardingColumn: gid\n            shardingAlgorithmName: link_stats_today_hash_mod\n    shardingAlgorithms:\n      link_table_hash_mod:\n        type: HASH_MOD\n        props:\n          sharding-count: 16\n      link_goto_table_hash_mod:\n        type: HASH_MOD\n        props:\n          sharding-count: 16\n      link_stats_today_hash_mod:\n        type: HASH_MOD\n        props:\n          sharding-count: 16\nprops:\n  sql-show: true<\/code><\/pre>\n\n\n\n
 \u90a3today_ip_count\u7684\u8bdd\u90a3\u8fd9\u4e2a\u5206\u8868\u7684\u6570\u91cf\u5e94\u8be5\u8981\u8981\u6bd4\u8fd9\u4e2at_link\u8981\u591a\u5f88\u591a\u561b\uff0c\u4e3a\u4ec0\u4e48\u8fd8\u662f\u8981\u520616\u4e2a\uff1f\u56e0\u4e3a\u5c31\u662f\u5e38\u89c4\u7684\u5206\u8868\u884c\u4e3a\u5bf9\u5427\uff0c\u8fd8\u6709\u5c31\u662f\u77ed\u94fe\u63a5\u4f60\u521b\u5efa\u51fa\u6765\u4ed6\u4e0d\u4e00\u5b9a\u6709\u4eba\u8bbf\u95ee<\/p>\n\n\n\n
 \u6211\u4eec\u4fee\u6539\u4e86\u57fa\u7840\u8bbe\u65bd\uff0c\u73b0\u5728\u4fee\u6539\u4ee3\u7801\u6765\u9002\u914d\uff0c\u4fee\u6539project\u7684ShortLinkServicelmpl.java\uff0c\u6dfb\u52a0                .totalPv(0).totalUv(0).totalUip(0)     \u4e3a\u4e86\u77ed\u94fe\u63a5\u65b0\u589e\u65f6\u521d\u59cb\u5316\u8bbf\u95ee\u7edf\u8ba1\u4e3a0<\/p>\n\n\n\n
    @Override\n    public ShortLinkCreateRespDTO createShortLink(ShortLinkCreateReqDTO requestParam) {\n        String shortLinkSuffix = generateSuffix(requestParam);\n        String fullShortUrl = StrBuilder.create(requestParam.getDomain())\n                .append(\"\/\")\n                .append(shortLinkSuffix)\n                .toString();\n        ShortLinkDO shortLinkDO = ShortLinkDO.builder()\n                .domain(requestParam.getDomain())\n                .originUrl(requestParam.getOriginUrl())\n                .gid(requestParam.getGid())\n                .createdType(requestParam.getCreatedType())\n                .validDateType(requestParam.getValidDateType())\n                .validDate(requestParam.getValidDate())\n                .describe(requestParam.getDescribe())\n                .shortUri(shortLinkSuffix)\n                .enableStatus(0)\n                .totalPv(0)\n                .totalUv(0)\n                .totalUip(0)\n                .fullShortUrl(fullShortUrl)\n                .favicon(getFavicon(requestParam.getOriginUrl()))\n                .build();\n        ShortLinkGotoDO linkGotoDO = ShortLinkGotoDO.builder()\n                .fullShortUrl(fullShortUrl)\n                .gid(requestParam.getGid())\n                .build();<\/code><\/pre>\n\n\n\n
 \u5f00\u53d1\u77ed\u94fe\u63a5\u76d1\u63a7\u4e4b\u6c47\u603b\u7edf\u8ba1\uff0cproject\\dao\\mapper\u7684\u8865\u5145ShortLinkMapper.java<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.ShortLinkDO;\nimport org.apache.ibatis.annotations.Param;\nimport org.apache.ibatis.annotations.Update;\n\npublic interface ShortLinkMapper extends BaseMapper<ShortLinkDO> {\n    \/**\n     * \u77ed\u94fe\u63a5\u8bbf\u95ee\u7edf\u8ba1\u81ea\u589e\n     *\/\n    @Update(\"update t_link set total_pv = total_pv + #{totalPv}, total_uv = total_uv + #{totalUv}, total_uip = total_uip + #{totalUip} where gid = #{gid} and full_short_url = #{fullShortUrl}\")\n    void incrementStats(\n            @Param(\"gid\") String gid,\n            @Param(\"fullShortUrl\") String fullShortUrl,\n            @Param(\"totalPv\") Integer totalPv,\n            @Param(\"totalUv\") Integer totalUv,\n            @Param(\"totalUip\") Integer totalUip\n    );\n}\n<\/pre>\n\n\n\n
  ShortLinkServicelmpl.java\u91cc\u9762\u6dfb\u52a0\uff0cshortLinkStats\u65b9\u6cd5\u91cc\u9762\u524d\u9762\u5df2\u7ecf\u5bf9uv\u4ec0\u4e48\u7684\u5904\u7406\u4e86\uff0c<\/p>\n\n\n\n
            LinkAccessLogsDO linkAccessLogsDO = LinkAccessLogsDO.builder()\n                    .user(uv.get())\n                    .ip(remoteAddr)\n                    .browser(browser)\n                    .os(os)\n                    .network(network)\n                    .device(device)\n                    .locale(StrUtil.join(\"-\", \"\u4e2d\u56fd\", actualProvince, actualCity))\n                    .gid(gid)\n                    .fullShortUrl(fullShortUrl)\n                    .build();\n            linkAccessLogsMapper.insert(linkAccessLogsDO);\n            baseMapper.incrementStats(gid, fullShortUrl, 1, uvFirstFlag.get() ? 1 : 0, uipFirstFlag ? 1 : 0);\n        }\n\n    } catch (Throwable ex) {\n        log.error(\"\u77ed\u94fe\u63a5\u8bbf\u95ee\u91cf\u7edf\u8ba1\u5f02\u5e38\", ex);\n    }\n}<\/pre>\n\n\n\n
 \u91cd\u542f\u4e0b\uff0c\u521b\u5efa\u4e0b\u65b0\u7684\u77ed\u94fe\u63a5\uff0c\u5f97\u5230\u4e86nurl.ink\/2v5g6C,\u6d4f\u89c8\u5668http:\/\/nurl.ink:8001\/2v5g6C<\/a>\uff0c\u770b\u770b\u6570\u636e\u5e93<\/p>\n\n\n\n
 \"\"\"\"<\/p>\n\n\n\n
- \u7b2c18\u8282\uff1a\u5982\u4f55\u7edf\u8ba1\u77ed\u94fe\u63a5\u76d1\u63a7\u4e4b\u4eca\u65e5\u6570\u636e\u8bbf\u95ee<\/h2>\n\n\n\n
LinkStatsTodayMapper.java\u4fee\u6539<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dao.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.nageoffer.shortlink.project.dao.entiry.LinkStatsTodayDO;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Param;\n\/**\n * \u77ed\u94fe\u63a5\u4eca\u65e5\u7edf\u8ba1\u6301\u4e45\u5c42\n * *\/\npublic interface LinkStatsTodayMapper extends BaseMapper<LinkStatsTodayDO> {\n\n    \/**\n     * \u8bb0\u5f55\u4eca\u65e5\u7edf\u8ba1\u76d1\u63a7\u6570\u636e\n     *\/\n    @Insert(\"INSERT INTO t_link_stats_today (full_short_url, gid, date,  today_uv, today_pv, today_uip, create_time, update_time, del_flag) \" +\n            \"VALUES( #{linkTodayStats.fullShortUrl}, #{linkTodayStats.gid}, #{linkTodayStats.date}, #{linkTodayStats.todayUv}, #{linkTodayStats.todayPv}, #{linkTodayStats.todayUip}, NOW(), NOW(), 0) \" +\n            \"ON DUPLICATE KEY UPDATE today_uv = today_uv +  #{linkTodayStats.todayUv}, today_pv = today_pv +  #{linkTodayStats.todayPv}, today_uip = today_uip +  #{linkTodayStats.todayUip};\")\n    void shortLinkTodayState(@Param(\"linkTodayStats\") LinkStatsTodayDO linkStatsTodayDO);\n\n}<\/pre>\n\n\n\n
 LinkStatsTodayDOjava\u4fee\u6539\u4e3a<\/p>\n\n\n\n
package com.nageoffer.shortlink.project.dao.entiry;\n\nimport com.baomidou.mybatisplus.annotation.TableName;\nimport com.nageoffer.shortlink.project.common.database.BaseDO;\nimport lombok.*;\nimport lombok.NoArgsConstructor;\nimport java.util.Date;\n\n\/**\n * \u77ed\u94fe\u63a5\u4eca\u65e5\u7edf\u8ba1\u5b9e\u4f53\n *\/\n@TableName(\"t_link_stats_today\")\n@Data\n@Builder\n@NoArgsConstructor\n@AllArgsConstructor\npublic class LinkStatsTodayDO extends BaseDO {\n\n    \/**\n     * id\n     *\/\n    private Long id;\n\n    \/**\n     * \u5206\u7ec4\u6807\u8bc6\n     *\/\n    private String gid;\n\n    \/**\n     * \u77ed\u94fe\u63a5\n     *\/\n    private String fullShortUrl;\n\n    \/**\n     * \u65e5\u671f\n     *\/\n    private Date date;\n\n    \/**\n     * \u4eca\u65e5pv\n     *\/\n    private Integer todayPv;\n\n    \/**\n     * \u4eca\u65e5uv\n     *\/\n    private Integer todayUv;\n\n    \/**\n     * \u4eca\u65e5ip\u6570\n     *\/\n    private Integer todayUip;\n}<\/pre>\n\n\n\n
 ShortLinkServicelmpl.java<\/p>\n\n\n\n
            linkAccessLogsMapper.insert(linkAccessLogsDO);\n            baseMapper.incrementStats(gid, fullShortUrl, 1, uvFirstFlag.get() ? 1 : 0, uipFirstFlag ? 1 : 0);\n            LinkStatsTodayDO linkStatsTodayDO = LinkStatsTodayDO.builder()\n                    .todayPv(1)\n                    .todayUv(uvFirstFlag.get() ? 1 : 0)\n                    .todayUip(uipFirstFlag ? 1 : 0)\n                    .gid(gid)\n                    .fullShortUrl(fullShortUrl)\n                    .date(new Date())\n                    .build();\n            linkStatsTodayMapper.shortLinkTodayState(linkStatsTodayDO);\n        }\n\n    } catch (Throwable ex) {\n        log.error(\"\u77ed\u94fe\u63a5\u8bbf\u95ee\u91cf\u7edf\u8ba1\u5f02\u5e38\", ex);\n    }\n}<\/pre>\n\n\n\n
 \u6211\u4eec\u7b2c\u4e8c\u6b21\u521b\u5efa\u4e00\u4e0b\uff0c<\/p>\n\n\n\n
{\n    \"domain\": \"nurl.ink\",\n    \"originUrl\": \"https:\/\/nageoffer.com\",\n    \"gid\": \"1k91Uw\",\n    \"createdType\": 1,\n    \"validDateType\": 0,\n    \"describe\": \"2025.6.29\u7b2c\u4e8c\u6b21\u521b\u5efa\"\n}\n\n\n\u5f97\u5230nurl.ink\/29OdGJ<\/code><\/pre>\n\n\n\n
 \u6211\u8bbf\u95ee\u4e86http:\/\/nurl.ink:8001\/29OdGJ<\/a> 3\u6b21\uff0cpv\u5728sql\u4e3a3\"\"<\/p>\n\n\n\n
\n
\u7b2c\u4e00\u6761\u521b\u5efa\u7684\u77ed\u94fe\u63a5\u7684total_uv\u548cuip\u4e3a0.\u4e0d\u5e94\u8be5\u4e5f\u662f1\u561b\uff1f<\/p>\n\n\n\n
\u7b2c\u4e00\u6761\u4e3a0\u662f\u4e0d\u662f\u56e0\u4e3acookie\u548credis\u91cc\u9762\u5df2\u7ecf\u6709uv\u548cuip\u4e86\u5427\uff0c\u4ed6\u53ea\u662f\u628a\u6570\u636e\u5e93\u91cc\u5b58\u7684\u5220\u9664\u4e86\uff0ccookie\u548credis\u7684\u6ca1\u6709\u5220\uff0c\u6240\u4ee5\u5e76\u4e0d\u662f\u7b2c\u4e00\u6b21\u8bbf\u95ee\uff1b\u521b\u5efa\u51fa\u6765\u53c8\u6ca1\u6709\u8bbf\u95ee\uff0c\u4e3a 0 \u662f\u6b63\u5e38\u7684<\/p>\n\n\n\n
pv,uv\u6362\u4e2a\u987a\u5e8f\u5c31\u89e3\u51b3\u4e86\u554a\uff0cinsert\u8bed\u53e5\u6570\u636e\u5e93\u5b57\u6bb5\u548c\u5bf9\u8c61\u91cc\u7684\u503c\u4e00\u4e00\u5bf9\u5e94<\/p>\n<\/blockquote>\n\n\n\n
\n
 ClownMing\uff1a\u6211\u89c9\u5f97today\u63d2\u5165\u7684\u65f6\u5019\u4e0d\u80fd\u7528\u4e4b\u524d\u7684flag\u6765\u5224\u65ad\u4e86\uff0c\u6211\u81ea\u5df1\u662f\u8fd9\u6837\u5199\u7684\uff1a AtomicBoolean uvTodayFirstFlag = new AtomicBoolean(); Long uvTodayAdd = stringRedisTemplate.opsForSet().add(\"short-link:stats:uv:\" + DateUtil.formatDate(date) + \":\" + fullShortUrl, uv.get()); uvTodayFirstFlag.set(uvTodayAdd != null && uvTodayAdd > 0L); Long uipTodayAdd = stringRedisTemplate.opsForSet().add(\"short-link:stats:ip:\" + DateUtil.formatDate(date) + \":\" + fullShortUrl, ipAddress); boolean uipTodayFirstFlag = uipTodayAdd != null && uipTodayAdd > 0L; LinkStatsTodayDO linkStatsTodayDO = LinkStatsTodayDO.builder() .id(SnowUtil.getSnowflakeNextId()) .gid(gid) .fullShortUrl(fullShortUrl) .date(date) .todayPv(1) .todayUv(uvTodayFirstFlag.get() ? 1 : 0) .todayUip(uipTodayFirstFlag ? 1 : 0) .build(); linkStatsTodayMapper.shortLinkTodayStats(linkStatsTodayDO);<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d ClownMing\uff1a\u6211\u4e5f\u6709\u76f8\u540c\u7684\u60f3\u6cd5\uff0c\u56e0\u4e3a\u524d\u9762\u7684flag\u662f\u5224\u65ad\u7d2f\u8ba1\u7684\uff0c\u6bcf\u4e00\u5929\u9700\u8981\u5237\u65b0\uff0c\u611f\u89c9\u8fd9\u91cc\u53ef\u4ee5\u6539\u8fdb\u5c31\u662f\uff0c\u7f13\u5b58\u53ef\u4ee5\u8bbe\u7f6e\u4e00\u4e0b\u6709\u6548\u671f\uff0c\u7136\u540e\u53ef\u4ee5\u4e0d\u7528AtomicBoolean\uff0c\u76f4\u63a5\u7528boolean\u5c31\u884c\uff0c\u9ad8\u5e76\u53d1\u7684\u65f6\u5019\u6548\u7387\u597d\u70b9\u7684\u611f\u89c9<\/p>\n\n\n\n
Everglow \u56de\u590d ClownMing\uff1a\u7ed9\u539f\u6765\u7684uv uip\u96c6\u5408 \u8bbe\u4e00\u4e2a\u8f85\u52a9\u952e\uff0c\u7ed9\u8f85\u52a9\u952e\u8bbe\u7f6e\u4e2a\u4e00\u5929\u8fc7\u671f\u5c31\u53ef\u4ee5\u4e86<\/p>\n\n\n\n
Aleksib \u56de\u590d \u6817\u5b50ing\uff1a\u54e5\u4eec\u8fd9\u91cc\u4e3a\u5565\u53ef\u4ee5\u4e0d\u7528AtomicBoolean\u554a\uff1f<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d Aleksib\uff1a\u6ca1\u6709\u4ec0\u4e48\u56e0\u4e3a\u554a\uff0c\u5c31\u662f\u6ca1\u6709lambda\u7684\u573a\u666f\uff0c\u7528\u54ea\u4e2a\u90fd\u662f\u4e00\u6837\u7684<\/p>\n\n\n\n
\u674e\u6e29\u5019 \u56de\u590d \u6817\u5b50ing\uff1a\u8fd9\u548clambda\u8868\u8fbe\u5f0f\u6ca1\u5173\u7cfb\u5427\uff0c\u6211\u8bb0\u5f97boolean\u5728\u591a\u7ebf\u7a0b\u4e0b\u662f\u4e0d\u5b89\u5168\u7684\uff0cAtomicBoolean\u662f\u5b89\u5168\u7684<\/p>\n\n\n\n
\u674e\u6e29\u5019 \u56de\u590d Everglow\uff1a\u6211\u89c9\u5f97\u8fd9\u4e2a\u53ef\u884c<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d \u674e\u6e29\u5019\uff1a\u90a3\u4f60\u53ef\u4ee5\u8bf4\u4e00\u4e0b\u4e3a\u4ec0\u4e48\u4e0d\u80fd\u7528boolean<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d \u674e\u6e29\u5019\uff1a\u53ef\u4ee5\u63a2\u8ba8\u4e00\u4e0b\uff0c\u90a3\u6211\u53ef\u4ee5\u95ee\u4f60\u4e00\u4e0b\uff0c\u4e3a\u4ec0\u4e48\u9a6c\u54e5 uvFirstFlag \u7528 ActomBoolean \u7136\u540e uipFirstFlag \u7528\u7684\u662f boolean \uff0c\u4f60\u53ef\u4ee5\u56de\u7b54\u4e00\u4e0b\u3002<\/p>\n\n\n\n
\u674e\u6e29\u5019 \u56de\u590d \u6817\u5b50ing\uff1a\u6211\u662f\u8fd9\u6837\u8ba4\u4e3a\u7684\u54c8\uff1a\u5c31\u697c\u4e3b\u7684\u6848\u4f8b\u4e3a\u4f8b\u5728uvTodayFirstFlag.set\u7684\u65f6\u5019\uff0c\u591a\u7ebf\u7a0b\u540c\u65f6\u6253\u5230\u8fd9\u91cc\u3002\u5728\u4f7f\u7528boolean\u7684\u60c5\u51b5\u4e0b\uff0c\u5728\u540c\u4e00\u65f6\u523b\u90fd\u8bbe\u7f6e\u4e86\u6210true\u4e86,\u90a3\u8fd9\u6837\u6700\u540e\u7edf\u8ba1uv\u7684\u65f6\u5019\u80af\u5b9a\u591a\u4e86\u4e00\u6b21\uff08\u6b63\u5e38\u4e00\u4e2a\u4e00\u4e2a0\uff0c\u4e00\u4e2a1\uff09\u3002\u4f46\u662f\u4f7f\u7528AtomicBoolean\u7684\u8bdd\u5c31\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u95ee\u9898\uff0cAtomicBoolean\u5e95\u5c42\u662fCAS\u7684\uff0c\u63d0\u4f9b\u4e86\u4e00\u4e9b\u539f\u5b50\u64cd\u4f5c\u7684\u65b9\u6cd5\uff0c\u5982get()\u548cset()\uff0c\u53ef\u4ee5\u4fdd\u6301\u591a\u4e2a\u7ebf\u7a0b\u540c\u65f6\u6253\u5230\u8fd9\u91cc\u65f6\u53ea\u4f1aset\u4e00\u6b21\uff08\u4e2a\u4eba\u770b\u6cd5\uff09<\/p>\n\n\n\n
\u674e\u6e29\u5019 \u56de\u590d \u6817\u5b50ing\uff1a\u8fd9\u4e2a\u6211\u76ee\u524d\u6c34\u5e73\u6ca1\u548b\u770b\u61c2\uff0c\u4e5f\u53ef\u80fd\u662f\u9a6c\u54e5\u624b\u8bef\u6253\u9519\u4e86\uff1f<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d \u674e\u6e29\u5019\uff1a1. \u5c40\u90e8\u53d8\u91cf\uff0c\u4ed6\u7684\u4f5c\u7528\u8303\u56f4\u6709\u6ca1\u6709\u8d85\u51fa\u65b9\u6cd5\uff0c\u4f1a\u4e0d\u4f1a\u5b58\u5728\u591a\u7ebf\u7a0b\u7684\u95ee\u9898\u5462\uff1f 2. \u5982\u679c\u4e0d\u4f1a\uff0c\u90a3 cas \u91cd\u8bd5\u662f\u4e0d\u662f\u9020\u6210\u4e00\u4e2a\u6027\u80fd\u635f\u8017\uff0c\u7ebf\u7a0b\u8fc7\u591a\uff0c\u5c31\u4f1a\u6027\u80fd\u4e0b\u964d\uff1f<\/p>\n\n\n\n
\u674e\u6e29\u5019 \u56de\u590d \u6817\u5b50ing\uff1a\u5c40\u90e8\u53d8\u91cf\uff0c\u4ed6\u4eec\u4e0d\u90fd\u662f\u5728shortlinkstats\u65b9\u6cd5\u91cc\u9762\u7684\u4e48\uff0c\u90a3\u5c82\u4e0d\u662f\u90fd\u662f\u5c40\u90e8\u53d8\u91cf\u4e86\uff0c\u4f60\u548b\u770b\u9a6c\u54e5\u4e00\u4e2aboolean\uff0c\u4e00\u4e2a\u7528actomboolean<\/p>\n\n\n\n
\u6817\u5b50ing \u56de\u590d \u674e\u6e29\u5019\uff1a\u6211\u4e0d\u662f\u8bf4\u8fc7\uff0c\u56e0\u4e3alambda\u91cc\u9762\u4e0d\u80fd\u4f7f\u7528boolean\uff0c\u9700\u8981\u4f7f\u7528\u4e0d\u80fd\u53d1\u751f\u4fee\u6539\u7684\u5f15\u7528\uff0c\u6240\u4ee5\u4f7f\u7528\u4e86ActomBoolean\u8fd9\u4e2a\u4e0d\u53ef\u53d8\u7c7b\uff0c\u624d\u80fd\u5728lambda\u4e2d\u4f7f\u7528<\/p>\n\n\n\n
7 \u56de\u590d \u6817\u5b50ing\uff1a\u6211\u89c9\u5f97\u53ef\u4ee5\u91cd\u590d\u4f7f\u7528\uff0c\u56e0\u4e3a\u7d2f\u8ba1\u5224\u65ad\u4e5f\u9700\u8981\u8bbe\u7f6e\u6bcf\u5929\u8fc7\u671f\uff0c\u8fd9\u6837\u624d\u80fd\u5224\u65ad\u7b2c\u4e8c\u5929\u662f\u5426\u767b\u9646\uff0c\u6240\u4ee5\u5728today\u903b\u8f91\u5e94\u8be5\u4e5f\u53ef\u4ee5\u4f7f\u7528<\/p>\n\n\n\n
\u9a6c\u4e01 \u56de\u590d ClownMing\uff1a\u770b\u4e86\u5927\u5bb6\u5728\u8ba8\u8bba Boolean \u548c AtomicBoolean\uff0c\u8fd9\u91cc\u603b\u7ed3\u56de\u590d\u4e0b\u3002\u5728\u54b1\u4eec\u8fd9\u4e2a\u573a\u666f\u91cc\u7528\u4e24\u4e2a\u90fd\u662f\u53ef\u4ee5\u7684\uff0c\u56e0\u4e3a\u4e0d\u5b58\u5728\u5e76\u53d1\u8bf7\u6c42\uff0c\u6240\u4ee5\u4e24\u8005\u4f5c\u7528\u4e00\u81f4\uff0c\u90fd\u662f\u4e3a\u4e86\u89e3\u51b3 lamda \u7684\u89c4\u8303\u7f16\u8bd1\u95ee\u9898\u3002\u53ea\u662f\u6211\u4e60\u60ef\u7528\u4e86 AtomicBoolean \u6240\u4ee5\u5728\u4ee3\u7801\u91cc\u5199\u4e0a\u4e86<\/p>\n\n\n\n
TheTurtle \u56de\u590d 7\uff1a\u7d2f\u8ba1\u5224\u65ad\u4e5f\u9700\u8981\u8bbe\u7f6e\u6bcf\u5929\u8fc7\u671f \u662f\u4ec0\u4e48\u610f\u601d\uff1f<\/p>\n\n\n\n
TheTurtle \u56de\u590d \u6817\u5b50ing\uff1a1. \u611f\u89c9\u8fd9\u79cd\u65b9\u6848\u53c8\u4f1a\u5bfc\u81f4uv\u548cuip\u7684\u7d2f\u8ba1\u7edf\u8ba1\u4f1a\u6709\u95ee\u9898\uff1a\u5bf9\u4e8e\u7d2f\u8ba1uv\u7684\u8bddcookies\u4e0d\u80fd\u8fc7\u671f\uff0c\u4e0d\u7136\u8fc7\u6bb5\u65f6\u95f4\u5bf9\u4e8e\u540c\u4e00\u4e2a\u4eba\u5176\u5b9e\u4f1a\u88ab\u770b\u4f5c\u4e24\u4e2a\u4eba\uff0c\u800c\u5bf9\u4e8e\u7d2f\u8ba1uip\u4e5f\u662f\u540c\u7406\uff08\u56e0\u6b64\u5982\u679c\u7528redis\u67e5\u91cduip\u7684\u8bdd\u8fd8\u8981\u89e3\u51b3\u4f18\u5316\u7a7a\u95f4\u95ee\u9898\uff09\u30022. \u6211\u5728\u60f3\u53ef\u4e0d\u53ef\u4ee5\u7ed9\u6bcf\u65e5uv\u5355\u72ec\u8bbe\u7f6e\u4e00\u4e2acookie\uff0c\u6bcf\u5929\u96f6\u70b9\u8fc7\u671f\uff1b\u800c\u5bf9\u4e8e\u6bcf\u65e5ip\uff0c\u53ef\u4ee5\u5355\u72ec\u8bbe\u4e00\u4e2atoday_ip_set\uff0c\u4e5f\u662f\u6bcf\u65e5\u96f6\u70b9\u8fc7\u671f\uff0c\u6b64\u5916\u5728\u5904\u7406ip\u65f6\u8fd8\u9700\u8981\u52a0\u5230\u4e4b\u524d\u7684total_ip_set\u3002<\/p>\n\n\n\n
TheTurtle \u56de\u590d \u6817\u5b50ing\uff1a\u7528\u4e24\u79cdcookie\u4ee5\u53ca\u4e24\u79cdredis-set\u6765\u5224\u65ad\u3002<\/p>\n\n\n\n
3 \u56de\u590d ClownMing\uff1a\u611f\u89c9\u8fd9\u91cc\u786e\u5b9e\u5224\u65ad\u7528\u4e4b\u524d\u7684Flag\u6709\u70b9\u95ee\u9898<\/p>\n\n\n\n
Venom. \u56de\u590d \u6817\u5b50ing\uff1a\u6211\u4e5f\u89c9\u5f97\u8bbe\u7f6e\u6709\u6548\u671f\u6bd4\u8f83\u597d<\/p>\n\n\n\n
\u76ae\u86cb\u7626\u8089\u7ca5\u3002 \u56de\u590d Venom.\uff1a\u7ed9cookie\u8bbe\u7f6e\u4e00\u4e2a\u65f6\u95f4,\u53cd\u6b63\u6ca1\u6709\u7528\u6237\u7684cookie\u5c31\u5f53\u4f5c\u65b0\u7528\u6237\u3002\u65f6\u95f4\u5c31\u8bbe\u7f6e\u4e3a\u4eca\u65e5\u768423:59:59\u51cf\u53bb\u5f53\u524d\u65f6\u95f4\u3002<\/p>\n\n\n\n
Venom. \u56de\u590d \u76ae\u86cb\u7626\u8089\u7ca5\u3002\uff1a\u6ca1\u592a\u61c2\u4f60\u4ec0\u4e48\u610f\u601d \u6211\u89c9\u5f97\u8fd9\u5757\u7684\u95ee\u9898\u5c31\u662fredis\u91cc\u9762\u7edf\u8ba1uv\u548cuip\u7684set\u8981\u8bbe\u7f6e\u6709\u6548\u671f \u8981\u4e0d\u7136\u5230\u540e\u9762\u7edf\u8ba1\u903b\u8f91\u5c31\u4e0d\u5bf9\u4e86<\/p>\n\n\n\n
\u76ae\u86cb\u7626\u8089\u7ca5\u3002 \u56de\u590d Venom.\uff1a\u5f53 uv Cookie \u4e0d\u5b58\u5728\u65f6\uff0c\u8c03\u7528\u4e86 addResponseCookieTask \u4efb\u52a1\u3002\u8fd9\u4e2a\u4efb\u52a1\u8d1f\u8d23\u751f\u6210\u4e00\u4e2a\u65b0\u7684 uv Cookie \u5e76\u5c06\u5176\u5b58\u50a8\u5230 Redis \u4e2d\uff0c\u540c\u65f6\u5c06 uvFirstFlag \u8bbe\u7f6e\u4e3a true\uff0c\u8868\u793a\u8fd9\u662f\u9996\u6b21\u8bbf\u95ee\u3002\u6240\u4ee5\u6211\u628auv cookie\u7684\u65f6\u95f4\u8bbe\u7f6e\u4e3a23:59:59\u51cf\u53bb\u5f53\u524d\u8bbf\u95ee\u65f6\u95f4\u3002\u90a3\u4e48\u5c31\u80fd\u505a\u5230cookie\u5230\u4e86\u5341\u4e8c\u70b9\u5c31\u81ea\u52a8\u5220\u9664\u4e86\uff0c\u56e0\u4e3a\u6ca1\u6709\u6709\u6548\u7684 uv Cookie\uff0c\u7cfb\u7edf\u4f1a\u518d\u6b21\u6267\u884c\u201c\u9996\u6b21\u8bbf\u95ee\u201d\u7684\u903b\u8f91\uff0c\u5c06\u8be5\u7528\u6237\u8bb0\u5f55\u4e3a\u65b0\u8bbf\u5ba2\uff0c\u5e76\u89e6\u53d1 uv + 1 \u7684\u64cd\u4f5c\u3002<\/p>\n\n\n\n
Cool \u56de\u590d \u674e\u6e29\u5019\uff1a\u5b9e\u9645\u4e0a\u591a\u7ebf\u7a0b\u4e0b\u4e5f\u4e0d\u4f1a\u6709\u7ebf\u7a0b\u5b89\u5168\uff0c\u56e0\u4e3aboolean\u7684\u8bfb\u5199\u90fd\u662f\u539f\u5b50\u6027\u7684\uff0c\u5e76\u4e14\u4f7f\u7528atomicBoolean\u4e5f\u4e0d\u4f1a\u8ba9\u591a\u4e2a\u7ebf\u7a0b\u6253\u8fdb\u6765\u53easet\u4e00\u6b21\uff0ccas\u5728\u522b\u7684\u7ebf\u7a0b\u5bf9\u53d8\u91cf\u4fee\u6539\u540e\u4f1a\u518d\u6b21\u6267\u884c<\/p>\n\n\n\n
\u767d\u65e5\u68a6\u60f3\u5bb6 \u56de\u590d 3\uff1a\u7528\u4e4b\u524d\u7684flag\u6709\u5565\u95ee\u9898\u561b\uff1f\u6ca1\u592a\u61c2<\/p>\n\n\n\n
\n\n\n\n
\u95ee\u9898\u5206\u6790\u603b\u7ed3<\/h3>\n\n\n\n
1. ClownMing \u7684\u89c2\u70b9\u662f\u5426\u6b63\u786e\uff1f<\/strong><\/h4>\n\n\n\n
\u6b63\u786e <\/strong>\u3002
\u539f\u4ee3\u7801\u4e2d uvFirstFlag<\/code> \u548c uipFirstFlag<\/code> \u662f\u57fa\u4e8e\u7d2f\u8ba1\u7edf\u8ba1\u7684\u5224\u65ad\uff08\u53ef\u80fd\u5305\u542b\u8de8\u5929\u6570\u636e\uff09\uff0c\u800c LinkStatsTodayDO<\/code> \u9700\u8981\u7edf\u8ba1\u5f53\u65e5\u9996\u6b21\u8bbf\u95ee <\/strong>\u3002\u5982\u679c\u76f4\u63a5\u590d\u7528\u7d2f\u8ba1\u6807\u5fd7\uff0c\u4f1a\u5bfc\u81f4\u4ee5\u4e0b\u95ee\u9898\uff1a<\/p>\n\n\n\n