select  a.cj,  nvl(b.rs,0) rs1, nvl(c.rs,0) rs2, nvl(d.rs,0) rs3, nvl(e.rs,0) rs4  from  ( select '99' cj from dual union select '95' cj from dual union select '90' cj from dual union select '85' cj from dual union select '80' cj from dual union select '75' cj from dual  union select '70' cj from dual  union select '60' cj from dual union select '50' cj from dual union select '40' cj from dual union select '20' cj from dual  union select '0' cj from dual ) a  left join  (select cj ,count(cj) rs from (select b.njdm_id nj,case when cj='优秀' and mod(substr(a.xh_id,9,1),2)=1 then 95   when cj='优秀' and  mod(substr(a.xh_id,9,1),2)=0 then 90 when cj='良好' and mod(substr(a.xh_id,9,1),2)=0 then 80  when cj='良好' and  mod(substr(a.xh_id,9,1),2)=1 then 85 when cj='中等' and mod(substr(a.xh_id,9,1),2)=0 then 70   when cj='中等' and  mod(substr(a.xh_id,9,1),2)=1 then 75 when cj='及格'  then 60  when cj='不及格'  then 50 when bfzcj>97 then 99   when bfzcj>=93 then 95 when bfzcj>=88 then 90 when bfzcj>=83 then 85  when bfzcj>=78 then 80 when bfzcj>=73 then 75 when bfzcj>=68 then 70 when bfzcj>=60 then 60 when bfzcj>=50 then 50 when bfzcj>=30 then 40 when bfzcj>=10 then 20 else 0 end  cj from jw_cj_xscjb a,jw_xjgl_xsjbxxb b,zftal_xtgl_zydmb d where b.zyh_id=d.zyh and b.xz<>'3' and a.xh_id=b.xh_id and b.njdm_id='2023'  and bfzcj>0 and a.cjbz is null  ) group by cj ) b on a.cj=b.cj  left join   (select cj ,count(cj) rs from (select b.njdm_id nj,case when cj='优秀' and mod(substr(a.xh_id,9,1),2)=1 then 95   when cj='优秀' and  mod(substr(a.xh_id,9,1),2)=0 then 90 when cj='良好' and mod(substr(a.xh_id,9,1),2)=0 then 80  when cj='良好' and  mod(substr(a.xh_id,9,1),2)=1 then 85 when cj='中等' and mod(substr(a.xh_id,9,1),2)=0 then 70   when cj='中等' and  mod(substr(a.xh_id,9,1),2)=1 then 75 when cj='及格'  then 60  when cj='不及格'  then 50 when bfzcj>97 then 99  when bfzcj>=93 then 95 when bfzcj>=88 then 90 when bfzcj>=83 then 85  when bfzcj>=78 then 80 when bfzcj>=73 then 75 when bfzcj>=68 then 70 when bfzcj>=60 then 60 when bfzcj>=50 then 50 when bfzcj>=30 then 40 when bfzcj>=10 then 20 else 0 end  cj from jw_cj_xscjb a,jw_xjgl_xsjbxxb b,zftal_xtgl_zydmb d where b.zyh_id=d.zyh and b.xz<>'3' and a.xh_id=b.xh_id and b.njdm_id='2022'  and bfzcj>0 and a.cjbz is null  ) group by cj ) c on  a.cj=c.cj  left join   (select cj ,count(cj) rs from (select b.njdm_id nj,case when cj='优秀' and mod(substr(a.xh_id,9,1),2)=1 then 95   when cj='优秀' and  mod(substr(a.xh_id,9,1),2)=0 then 90 when cj='良好' and mod(substr(a.xh_id,9,1),2)=0 then 80  when cj='良好' and  mod(substr(a.xh_id,9,1),2)=1 then 85 when cj='中等' and mod(substr(a.xh_id,9,1),2)=0 then 70   when cj='中等' and  mod(substr(a.xh_id,9,1),2)=1 then 75 when cj='及格'  then 60  when cj='不及格'  then 50 when bfzcj>97 then 99  when bfzcj>=93 then 95 when bfzcj>=88 then 90 when bfzcj>=83 then 85  when bfzcj>=78 then 80 when bfzcj>=73 then 75 when bfzcj>=68 then 70 when bfzcj>=60 then 60 when bfzcj>=50 then 50 when bfzcj>=30 then 40 when bfzcj>=10 then 20 else 0 end  cj from jw_cj_xscjb a,jw_xjgl_xsjbxxb b,zftal_xtgl_zydmb d where b.zyh_id=d.zyh_id and  b.xz<>'3' and a.xh_id=b.xh_id and b.njdm_id='2021'  and bfzcj>0 and a.cjbz is null　 ) group by cj ) d on  a.cj=d.cj   left join   (select cj ,count(cj) rs from (select b.njdm_id nj,case when cj='优秀' and mod(substr(a.xh_id,9,1),2)=1 then 95   when cj='优秀' and  mod(substr(a.xh_id,9,1),2)=0 then 90 when cj='良好' and mod(substr(a.xh_id,9,1),2)=0 then 80  when cj='良好' and  mod(substr(a.xh_id,9,1),2)=1 then 85 when cj='中等' and mod(substr(a.xh_id,9,1),2)=0 then 70   when cj='中等' and  mod(substr(a.xh_id,9,1),2)=1 then 75 when cj='及格'  then 60  when cj='不及格'  then 50 when bfzcj>97 then 99  when bfzcj>=93 then 95 when bfzcj>=88 then 90 when bfzcj>=83 then 85  when bfzcj>=78 then 80 when bfzcj>=73 then 75 when bfzcj>=68 then 70 when bfzcj>=60 then 60 when bfzcj>=50 then 50 when bfzcj>=30 then 40 when bfzcj>=10 then 20 else 0 end  cj from jw_cj_xscjb a,jw_xjgl_xsjbxxb b,zftal_xtgl_zydmb d where b.zyh_id=d.zyh and b.xz<>'3' and a.xh_id=b.xh_id and b.njdm_id='2020'  and bfzcj>0 and a.cjbz is null  ) group by cj ) e on  a.cj=e.cj    order by cj desc   
 <script type="text/javascript">
function showHint(str)
{
var xmlhttp;
if (str.length==0)
  { 
  document.getElementById("opt").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("opt").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","server_zyxx.asp?jgh="+str,true);
xmlhttp.send();
}


function windowresize()
  {
  location.reload();
  }

</script>
<!DOCTYPE html>

<!DOCTYPE html>
<html style="height: 100%">
    <head>
        <meta charset="gb2312">
    </head>
    <body style="height: 100%; margin: 0"  onresize="windowresize();" > 
       <form method="POST" action="cjfbtj_1.asp" >
  
        <p align="center"></font><select size="1" name="xydm" onchange="showHint(this.value)">
						<option value="qx">==请选择学院==</option>
						<option value="01法学院">法学院</option>
						<option value="02文学与传播学院">文学与传播学院</option>
						<option value="03外国语学院">外国语学院</option>
						<option value="04教育学院">教育学院</option>
						<option value="05金融与数学学院">金融与数学学院</option>
						<option value="06电子工程学院">电子工程学院</option>
						<option value="07化学与材料工程学院">化学与材料工程学院</option>
						<option value="08计算机学院">计算机学院</option>
						<option value="09美术与设计学院">美术与设计学院</option>
						<option value="10体育学院">体育学院</option>
						<option value="11音乐学院">音乐学院</option>
						<option value="12经济与管理学院">经济与管理学院</option>
						<option value="13生物工程学院">生物工程学院</option>
						<option value="14机械与电气工程学院">机械与电气工程学院</option>
						<option value="15马克思主义学院">马克思主义学院</option>
					   </select>&nbsp; <select name="zydm" id="opt"  > 
                    　　<option value="qxzy">==请选择专业==</option> 
					　　</select>
					<font size="2">&nbsp;</font><select size="1" name="lx">
						<option value="">==学生类别==</option>
						<option value="4">本科生</option>
						<option value="2">专升本</option>
						<option value="sf">师范生</option>
						<option value="ns">男生</option>
                        <option value="nv">女生</option>

					</select>&nbsp; <select size="1" name="cjlx">
						<option value="">=请选择成绩类型=</option>
						<option value="1" > 正考成绩</option>
						<option value="2" >补(缓)考成绩</option>
						<option value="3" >重修成绩</option>
						<option value="4" >公共选课成绩</option>
						<option value="5" >学位核心课成绩</option>
						<option value="6">考试课程</option>
					</select>&nbsp; <input type="submit"  name="b1" value="查询"></p>
					<p align="left"><span style="font-size:10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 当前统计：全校全部课程成绩分布</span></p>
		 </form>	  
        <div id="container" style="height: 85%" >
			<p align="center"></div>
        <script type="text/javascript" src="https://fastly.jsdelivr.net/npm/echarts@5.3.2/dist/echarts.min.js"></script>
         <script type="text/javascript" src="https://api.map.baidu.com/api?v=2.0&ak=BSnmSno9iTRu7Q5b2LiVyVojBFgSyQ7k&__ec_v__=20210512"></script>
 
          <script type="text/javascript">
var dom = document.getElementById("container");
var myChart = echarts.init(dom);
var app = {};

var option;
var waterMarkText = '淮南师范学院教务处';
var canvas = document.createElement('canvas');
var ctx = canvas.getContext('2d');
canvas.width = 180;
canvas.height = 180;
         
         
ctx.textAlign = 'center';
ctx.textBaseline = 'middle';
ctx.globalAlpha = 0.08;
ctx.font = '18px Microsoft Yahei';
ctx.translate(70, 70);
ctx.rotate(-Math.PI / 4);
ctx.fillText(waterMarkText, 0, 0);

var kd= document.body.scrollWidth/1600;

// prettier-ignore
const hours = [
    '100', '95', '90', '85', '80', '75', '70',  '60',  '50',  '40', '20','0'
];
// prettier-ignore
const days = [
    '2023级全校全部课程成绩分布', '2022级全校全部课程成绩分布', '2021级全校全部课程成绩分布', '2020级全校全部课程成绩分布'
];
// prettier-ignore
const data=[,[0,0,8,'98-100'],[0,1,3279,'93-97'],[0,2,6296,'88-92'],[0,3,12128,'83-87'],[0,4,14151,'78-82'],[0,5,6652,'73-77'],[0,6,5439,'68-72'],[0,7,3290,'60-67'],[0,8,873,'50-59'],[0,9,123,'30-49'],[0,10,241,'10-29'],[0,11,12,'0-9'],,[1,0,98,'98-100'],[1,1,20025,'93-97'],[1,2,31675,'88-92'],[1,3,48683,'83-87'],[1,4,55650,'78-82'],[1,5,25297,'73-77'],[1,6,22103,'68-72'],[1,7,15972,'60-67'],[1,8,3425,'50-59'],[1,9,512,'30-49'],[1,10,1072,'10-29'],[1,11,44,'0-9'],,[2,0,55,'98-100'],[2,1,29367,'93-97'],[2,2,46210,'88-92'],[2,3,69709,'83-87'],[2,4,77849,'78-82'],[2,5,36763,'73-77'],[2,6,31027,'68-72'],[2,7,21686,'60-67'],[2,8,5038,'50-59'],[2,9,776,'30-49'],[2,10,1507,'10-29'],[2,11,79,'0-9'],,[3,0,235,'98-100'],[3,1,37199,'93-97'],[3,2,61693,'88-92'],[3,3,88728,'83-87'],[3,4,104486,'78-82'],[3,5,44474,'73-77'],[3,6,42085,'68-72'],[3,7,27746,'60-67'],[3,8,6793,'50-59'],[3,9,1531,'30-49'],[3,10,1466,'10-29'],[3,11,85,'0-9']];
const title = [];
const singleAxis = [];
const series = [];
days.forEach(function (day, idx) {
  title.push({
    textStyle: {
      color: '#104BA9',
      fontWeight: 'normal',
      fontSize: 14
          },
   x:'center',
    textBaseline: 'middle',
    top: ((idx) * 100) /4 +1 + '%',
    text: day    
  });
  singleAxis.push({
    left: 50,
    right: 50,

    type: 'category',
    boundaryGap: false,
    data: hours,
    top: ((idx+0.1) * 100) /4 +5 + '%',
    height: 100 /6-5 + '%',
    axisLabel: {
      interval:0
    }
  });
  series.push({
    singleAxisIndex: idx,
    coordinateSystem: 'singleAxis',
    type: 'scatter',
    data: [],
    symbolSize: function (dataItem) {
      return dataItem[1] /697*kd;
    }
  });
});
data.forEach(function (dataItem) {
  series[dataItem[0]].data.push([dataItem[1], dataItem[2], dataItem[3]]);
});
option = {
 
 backgroundColor: {
        type: 'pattern',
        image: canvas,
        repeat: 'repeat'
    },

 toolbox: {
        show: true,
        orient: 'vertical',
        left: '90%',
        top: '5%',
       feature: {
            mark: {show: true},
            dataView: { title: '数据查看',readOnly: false},
             dataView: {show: true, readOnly: false},
                          restore: {show: true},
            saveAsImage: {show: true}
        }
    },
tooltip: {
    //trigger: 'axis',
        axisPointer: {
            type: 'shadow'
        },
    showDelay: 1,
    formatter: function (params ) {
     
       return (
        '<span style="color:#1240AB;fontSize:12;">'+params.value[2] +'</span>分数区间 :</br><span style="color:red;fontSize:12;">'+params.value[1]+'</span>人次 '
            )
      },
    
    
     axisPointer: {
       show: true,
       type: 'cross',
        lineStyle: {
        type: 'dashed',
        width: 2
         }
      }
   },    
    title: title,
     
  singleAxis: singleAxis,
  series: series
};

if (option && typeof option === 'object') {
    myChart.setOption(option);
}

        </script>
     
    </body>
</html>