echarts动态的生成数据
定义一个数组变量,将数据遍历到数组中echarts中的series直接给它赋值series
var series = [];
$.each(res.count_stu,function (index,value) {
series.push(
{
name:index,
type:'bar',
barWidth: '40',
label: {
normal: {
show: true,
position: 'top',
formatter:'{c}'
}
},
data:value
},
)
});
数据库中查询不同间隔的用户数量
SELECT
`group`.`name` scl_name,
count(
CASE
WHEN jointexam_user.user_score BETWEEN :min_score
AND :max_score THEN
1
END
) '别名'
FROM
jointexam_user
INNER JOIN `group` ON `group`.id = jointexam_user.scl_id
WHERE
jointexam_user.mstplan_id = 453
AND jointexam_user.subjplan_id = 0
AND jointexam_user.subject_id = 0
GROUP BY
`group`.id