配置屏幕
# 配置屏幕
# 首次登录
需要输入账号与统一密码
演示账号:dpm 密码:123456
# 屏幕管理
1、可以重新建大屏幕
2、当鼠标到这个位置时就可以进行修改
3、删除大屏(本功能未开放)
4、修改屏幕名称
5、最终演示的界面(给用户的就是这里打开的网址)
6、复制一个大屏幕
# 配置界面
# 动态数据
API地址:ajax.ashx?method=ShuJu&id=1&LSval1=参数1 ID:动态SQL中的ID LSval1至LSval9:支持9个参数
# 数据格式
# 翻牌器
method=ShuJu
有数值,有标题
select count(1) data,'销售金额' suffixText from ckd
1
# 柱状图
method=ZhuZhuangTu
{
"categories": [
"苹果",
],
"series": [{
"name": "手机品牌",
"data": [
1000879,
]
}]
}
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
select [userid] as categories,'用户积分' as name, sum(jifenshuliang)data from [NBWanS_JiFen] group by [userid]
1
# 折线图
{
"categories": [
"苹果",
],
"series": [{
"name": "手机品牌",
"data": [
1000879,
]
}]
}
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
# 饼图
method=ShuJu
[{
"name": "PC",
"value": 97,
"url": "http://www.baidu.com"
}]
1
2
3
4
5
2
3
4
5
select [userid] as name, sum(jifenshuliang)value from [NBWanS_JiFen] group by [userid]
1
# 象型图
{
"categories": [
"苹果",
],
"series": [{
"name": "手机品牌",
"data": [
1000879,
]
}]
}
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
# 雷达图
{
indicator: [{
name: '销售',
max: 6500
}],
series: [{
data: [{
value: [4300, 10000, 28000, 35000, 50000, 19000],
name: '预算分配(Allocated Budget)'
}]
}]
}
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
# 散点图
[{
data: [
[1, 8.04],
[2, 6.95]
]},
{
data: [
[1, 4.04],
[2, 3.95]
]
}]
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
# 漏斗图
method=ShuJu
[{
value: 335,
name: '直接访问'
},
{
value: 310,
name: '邮件营销'
},
{
value: 234,
name: '联盟广告'
}]
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
# 轮播图
method=ShuJu
[{
value: 图片地址1,
},
{
value: 图片地址2,
}]
1
2
3
4
5
6
2
3
4
5
6
# 地图
method=ShuJu
[
"name": "测试坐标1",
"value": 1,
"lng": 118.30078125,
"lat": 36.91915611148194,
"zoom": 1
},
{
"name": "测试坐标2",
"value": 1,
"lng": 112.21435546875,
"lat": 37.965854128749434,
"zoom": 1
}
]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# 表格
method=ShuJu
SELECT TOP 5 [jifenshuliang] ,[jifenshuoming] FROM [NBWanS_JiFen]
1
上次更新: 2022/04/26, 16:00:33