联系官方销售客服

1835022288

028-61286886

问题 求助问题 分享经验 开发需求
应用插件 版主：官方插件技术组
调用当天的总浏览量怎么写
星宸
类型：迅睿CMS 更新时间：2024-04-01 14:28:42 module=all 内容建站系统
插件 建站系统 V3.17
应用作者 迅睿官方团队
发布时间 2022-03-01 15:30:06
更新时间 2024-12-19 10:00:07

求教一下，想调用当天的总浏览量，用了下面这段代码怎么不管用
{sum sum=hits action=module module=all DAY_updatetime=0}

插件教程：https://www.xunruicms.com/doc/app-928.html

回帖
  • 开源社区插件技术-小鹏
    #1楼    开源社区插件技术-小鹏
    2024-04-01 08:54:45
    Chrome 0
    参考文档：《求和/累计运算标签 sum标签》Debug标签输出一下，看看数据。{$debug_sum}
  • 星宸
    #2楼    星宸
    2024-04-01 09:15:54
    Chrome 0
    开源社区插件技术-小鹏 标签解析：{list sum sum=hits action=module module=all DAY_updatetime=0}错误提示：在[my]表中字段[updatetime]不存在（可用字段：id、hits），字段不存在还有办法吗
  • 开源社区插件技术-小鹏
    #3楼    开源社区插件技术-小鹏
    2024-04-01 09:24:49
    Chrome 0
    加一个field=updatetime参数
  • 星宸
    #4楼    星宸
    2024-04-01 14:22:35
    Chrome 0
    开源社区插件技术-小鹏 {sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}是这样吗，加上了，调出来数据一直是0
  • 开源社区插件技术-小鹏
    #5楼    开源社区插件技术-小鹏
    2024-04-01 14:24:33
    Chrome 0
    要看debug数据才能知道原因
  • 星宸
    #6楼    星宸
    2024-04-01 14:28:42
    Chrome 0
    开源社区插件技术-小鹏

    标签解析：{list sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}查询解析: SELECT sum(hits) as ct FROM (SELECT updatetime,id,hits,'news' AS mid FROM `zcga_1_news` UNION ALL SELECT updatetime,id,hits,'zhuanti' AS mid FROM `zcga_1_zhuanti` UNION ALL SELECT updatetime,id,hits,'zddh' AS mid FROM `zcga_1_zddh` UNION ALL SELECT updatetime,id,hits,'jzemail' AS mid FROM `zcga_1_jzemail` UNION ALL SELECT updatetime,id,hits,'ztzl' AS mid FROM `zcga_1_ztzl` UNION ALL SELECT updatetime,id,hits,'fjzj' AS mid FROM `zcga_1_fjzj` UNION ALL SELECT updatetime,id,hits,'wlxxaq' AS mid FROM `zcga_1_wlxxaq` UNION ALL SELECT updatetime,id,hits,'fzgajsn' AS mid FROM `zcga_1_fzgajsn` UNION ALL SELECT updatetime,id,hits,'qjszlb' AS mid FROM `zcga_1_qjszlb` UNION ALL SELECT updatetime,id,hits,'sjwj' AS mid FROM `zcga_1_sjwj` UNION ALL SELECT updatetime,id,hits,'wzggw' AS mid FROM `zcga_1_wzggw` UNION ALL SELECT updatetime,id,hits,'gajb' AS mid FROM `zcga_1_gajb` UNION ALL SELECT updatetime,id,hits,'tztb' AS mid FROM `zcga_1_tztb` UNION ALL SELECT updatetime,id,hits,'zddb' AS mid FROM `zcga_1_zddb` UNION ALL SELECT updatetime,id,hits,'qzrb' AS mid FROM `zcga_1_qzrb` UNION ALL SELECT updatetime,id,hits,'mrqw' AS mid FROM `zcga_1_mrqw` UNION ALL SELECT updatetime,id,hits,'yyxtdh' AS mid FROM `zcga_1_yyxtdh` UNION ALL SELECT updatetime,id,hits,'qjszlba' AS mid FROM `zcga_1_qjszlba` UNION ALL SELECT updatetime,id,hits,'fzgajsna' AS mid FROM `zcga_1_fzgajsna` UNION ALL SELECT updatetime,id,hits,'yycx' AS mid FROM `zcga_1_yycx` UNION ALL SELECT updatetime,id,hits,'zbbqb' AS mid FROM `zcga_1_zbbqb` UNION ALL SELECT updatetime,id,hits,'zfjd' AS mid FROM `zcga_1_zfjd` UNION ALL SELECT updatetime,id,hits,'xxfw' AS mid FROM `zcga_1_xxfw` UNION ALL SELECT updatetime,id,hits,'zhibanbiao' AS mid FROM `zcga_1_zhibanbiao`) as my WHERE (`my`.`updatetime` BETWEEN 1711900800 AND 1711952812) ORDER BY NULL查询耗时: 0.00093793869018555s当前路由：home/index动态地址：index.php?变量前缀：t运算数量：运算变量：自动输出
    出现这些，没看出错误来
相关问题