Home Explore Help
Register Sign In
hytc
/
hytc-admin
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
hytc-admin
/
addons
/
customcharts
/
testdata.sql

testdata.sql 2.6 KB
Permalink History Raw

123456789101112131415161718192021222324 
  1. 

  2. -- ----------------------------
    3. 

  3. -- Records of __PREFIX__customcharts_total_number
    4. 

  4. -- ----------------------------
    5. 

  5. INSERT INTO `__PREFIX__customcharts_total_number` (`id`, `name`, `title`, `field_total`, `type_total`, `field_time`, `field_time_type`, `type_time`, `where`, `icon`, `icon_color`, `weigh`, `is_money`) VALUES
    6. 

  6. (1, '__PREFIX__user', '会员总数', 'id', 'count', 'jointime', 'bigint', 'all', '', 'fa fa-user-o', '#00ccff', 1, 0),
    7. 

  7. (2, '__PREFIX__admin_log', '管理员操作数', 'id', 'count', 'createtime', 'bigint', 'all', '', 'fa fa-dashboard', '#cc6b6b', 2, 0),
    8. 

  8. (3, '__PREFIX__attachment', '附件总数', 'id', 'count', 'createtime', 'bigint', 'all', '', 'fa fa-file-photo-o', '#7bd387', 3, 0),
    9. 

  9. (4, '__PREFIX__admin', '管理员数', 'id', 'count', 'createtime', 'bigint', 'all', '', 'fa fa-user', '#446af5', 4, 0);
    10. 

  10. 

  11. -- ----------------------------
    12. 

  12. -- Records of __PREFIX__customcharts_ranking
    13. 

  13. -- ----------------------------
    14. 

  14. INSERT INTO `__PREFIX__customcharts_ranking` (`id`, `name`, `field_total`, `type_total`, `group_field`, `field_time`, `field_time_type`, `type_time`, `unit`, `title`, `where`, `weigh`, `show_num`, `join_table`, `foreign_key`, `local_key`, `field_show`) VALUES
    15. 

  15. (1, '__PREFIX__admin_log', 'id', 'count', 'admin_id', 'createtime', 'bigint', 'today', '操作次数', '管理员操作排行', '', 1, 10, '__PREFIX__admin', 'admin_id', 'id', 'nickname'),
    16. 

  16. (2, '__PREFIX__admin_log', 'id', 'count', 'admin_id', 'createtime', 'bigint', 'week', '操作次数', '管理员操作排行', '', 1, 10, '__PREFIX__admin', 'admin_id', 'id', 'nickname'),
    17. 

  17. (3, '__PREFIX__admin_log', 'id', 'count', 'admin_id', 'createtime', 'bigint', 'month', '操作次数', '管理员操作排行', '', 1, 10, '__PREFIX__admin', 'admin_id', 'id', 'nickname');
    18. 

  18. 

  19. -- ----------------------------
    20. 

  20. -- Records of __PREFIX__customcharts_chart
    21. 

  21. -- ----------------------------
    22. 

  22. INSERT INTO `__PREFIX__customcharts_chart` (`id`, `name`, `field_total`, `type_total`, `group_field`, `field_time`, `field_time_type`, `chart_type`, `legend_title`, `unit`, `title`, `subtext`, `where`, `weigh`, `join_table`, `foreign_key`, `local_key`, `field_show`, `dictionary`) VALUES
    23. 

  23. (1, 'fa_admin_log', 'id', 'count', 'admin_id', 'createtime', 'bigint', 'graph', '操作数', '次', '管理员操作数', '系统管理员操作次数分析', '', 1, 'fa_admin', 'admin_id', 'id', 'nickname', ''),
    24. 

  24. (2, 'fa_user', 'id', 'count', 'gender', 'logintime', 'bigint', 'pie', '性别', '人', '男女比例分析', '分析所有会员性别占比', '', 1, '', 'id', 'id', 'nickname', '{\"0\":\"女\",\"1\":\"男\"}');
    25.