原创

[koreader]statistics插件之博客阅读统计模块

前言

去年我打算将koreader的阅读统计模块挪到我的博客站点，为了自己更好的能看到阅读统计，经过3天左右的开发，现在可以汇报下了

截图

架构

编码阶段刚结束，随意添加了几个统计的内容，先凑活着用，后续再调整。

图用了echart.

通过syncthingt（安卓版本）同步koreader目录下的staticstics.sqlite3文件，系统通过采集到本地mysql表中，然后针对表进行具体的查询。

关键查询

最近一个阶段（比如周，月）每天阅读的页数及阅读时间

<select id="getDatesFromAllDetail" parameterType="String" resultMap="datesFromAllDetail">
<!-- '%Y-%m-%d'--> SELECT dates, COUNT(*) AS pages, SUM(sum_duration) AS durations,year,month FROM (SELECT DATE_FORMAT(FROM_UNIXTIME(start_time), '%Y') AS year, DATE_FORMAT(FROM_UNIXTIME(start_time), '%m') AS month, DATE_FORMAT(FROM_UNIXTIME(start_time), #{dateFormat}) AS dates, SUM(duration) AS sum_duration FROM biz_koread_statistics_page_stat WHERE 1=1 <if test="startTime!=null"> AND start_time >= #{startTime} </if> GROUP BY id_book , page , dates,year,month) AS b GROUP BY dates,year,month ORDER BY dates DESC; </select>

获取近一日/近一周/近一月/近一年/总时间的阅读时间


SELECT
        (select sum(duration) as all_books from biz_koread_statistics_page_stat) AS all_books,
        (select sum(duration) as begin_day from biz_koread_statistics_page_stat where 1=1
        <if test="fromBeginDay!=null">
            and start_time>#{fromBeginDay}
        </if>) AS begin_day,
        (select sum(duration) as begin_week from biz_koread_statistics_page_stat where 1=1
        <if test="fromBeginWeek!=null">
            and start_time>#{fromBeginWeek}
        </if>) AS begin_week,
        (select sum(duration) as begin_month from biz_koread_statistics_page_stat where 1=1
        <if test="fromBeginMonth!=null">
            and start_time>#{fromBeginMonth}
        </if>) AS begin_month,
        (select sum(duration) as begin_year from biz_koread_statistics_page_stat where 1=1
        <if test="fromBeginYear!=null">
            and start_time>#{fromBeginYear}
        </if>) AS begin_year
    FROM DUAL

本文来自：[koreader]statistics插件之博客阅读统计模块-小码农，转载请保留本条链接，感谢！

温馨提示：

本文最后更新于 2023年01月02日，已超过 719 天没有更新。若文章内的图片失效（无法正常加载），请留言反馈或直接联系我。

正文到此结束

所属分类：开发

本文标签： koreader
本文链接： https://djc8.cn/archives/koreader-blog-reading-statistics-module-of-statistics-plugin.html
版权声明： 本文由小码农原创发布，转载请遵循《署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)》许可协议授权

[koreader]statistics插件之博客阅读统计模块

前言

截图

架构

关键查询

热门推荐

相关文章

关于我

本文目录

标签云

近期评论

网站信息