工作日常小计四

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