SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nhttrqhz_ttr2.jos_thong_ke_kqua_hoc_tap_cac_nam1' doesn't exist<br />
<b>Warning</b>:  Undefined variable $summaryrows in <b>/home/nhttrqhz/public_html/x/THONG_TIN_KQ_HTAP_LOP1.php</b> on line <b>240</b><br />
<table id='grid4p'></table><div id='pager4p'></div><script type='text/javascript'>jQuery(document).ready(function($) {jQuery('#grid4p').jqGrid({"width":1500,"hoverrows":true,"viewrecords":true,"jsonReader":{"repeatitems":false,"subgrid":{"repeatitems":false}},"xmlReader":{"repeatitems":false,"subgrid":{"repeatitems":false}},"gridview":true,"url":"THONG_TIN_KQ_HTAP_LOP1.php","editurl":"THONG_TIN_KQ_HTAP_LOP1.php","cellurl":"THONG_TIN_KQ_HTAP_LOP1.php","caption":"<span style=\"color:#0000ff; font-size: 17px; font-weight: bold;\"> THỐNG KÊ CHẤT LƯỢNG GD HẰNG NĂM</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<select id=\"kqhtcacnamp\">\n        <option value=\"nh\">NĂM HỌC</option>\n        <option value=\"nh1\">NĂM HỌC NO</option>\n\n        <option value=\"lop\">LỚP</option>\n        <option value=\"lop1\">LỚP NO</option>\n        <option value=\"xoa\">XÓA GROUP</option>\n         </select>","rownumbers":true,"rowNum":1020,"rowList":[500,530,600,750],"sortname":"ID","height":"auto","userDataOnFooter":true,"footerrow":true,"grouping":true,"groupingView":{"groupField":["nh"],"groupColumnShow":[true],"groupText":["Năm học: <b>{0}</b>"],"groupDataSorted":true,"groupSummary":[true,true,true],"groupCollapse":true},"datatype":"json","colModel":[],"postData":{"oper":"grid"},"prmNames":{"page":"page","rows":"rows","sort":"sidx","order":"sord","search":"_search","nd":"nd","id":"id","filter":"filters","searchField":"searchField","searchOper":"searchOper","searchString":"searchString","oper":"oper","query":"grid","addoper":"add","editoper":"edit","deloper":"del","excel":"excel","subgrid":"subgrid","totalrows":"totalrows","autocomplete":"autocmpl"},"loadError":function(xhr,status, err){ try {jQuery.jgrid.info_dialog(jQuery.jgrid.errors.errcap,'<div class="ui-state-error">'+ xhr.responseText +'</div>', jQuery.jgrid.edit.bClose,{buttonalign:'right'});} catch(e) { alert(xhr.responseText);} },"pager":"#pager4p"});jQuery('#grid4p').jqGrid('navGrid','#pager4p',{"edit":true,"add":true,"del":true,"search":true,"refresh":true,"view":false,"excel":true,"pdf":false,"csv":false,"columns":false},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"errorTextFormat":function(r){ return r.responseText;}},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"errorTextFormat":function(r){ return r.responseText;}},{"errorTextFormat":function(r){ return r.responseText;}},{"drag":true,"closeAfterSearch":true,"multipleSearch":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150});jQuery('#grid4p').jqGrid('navButtonAdd','#pager4p',{id:'pager4p_excel', caption:'',title:'Export To Excel',onClickButton : function(e)
{
    try {
        jQuery("#grid4p").jqGrid('excelExport',{tag:'excel', url:'THONG_TIN_KQ_HTAP_LOP1.php'});
    } catch (e) {
        window.location= 'THONG_TIN_KQ_HTAP_LOP1.php?oper=excel';
    }
},buttonicon:'ui-icon-newwin'});jQuery('#grid4p').jqGrid('setGroupHeaders',{"useColSpanStyle":true,"groupHeaders":[{"startColumnName":"hl_xs","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL XS</span>"},{"startColumnName":"hl_g","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL G</span>"},{"startColumnName":"hl_k","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL KH</span>"},{"startColumnName":"hl_tb","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL TB</span>"},{"startColumnName":"hl_y","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL Y</span>"},{"startColumnName":"tu_tb","numberOfColumns":2,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">HL TỪ TB</span>"},{"startColumnName":"hk_t","numberOfColumns":2,"titleText":"<span style=\"color:#990099; font-weight: bold;\">HK TỐT</span>"},{"startColumnName":"hk_k","numberOfColumns":2,"titleText":"<span style=\"color:#990099; font-weight: bold;\">HK KHÁ</span>"},{"startColumnName":"hk_tb","numberOfColumns":2,"titleText":"<span style=\"color:#990099; font-weight: bold;\">HK TB</span>"},{"startColumnName":"hk_kt","numberOfColumns":2,"titleText":"<span style=\"color:#990099; font-weight: bold;\">HK KT </span>"}]});
 function thinghiem1(cellvalue, options, rowObject) {
    return  "<a href='#'>"+ (rowObject.hlG/rowObject.so_hs)+ "</a>"; }


function lonchaub (cellValue, options, rowdata){
   var bien=cellValue;
   if(bien=='K6'|| bien=='K7'|| bien=='K8' || bien=='K9' || bien=='TT'){  return '<span style="color:red; font-weight: bold;">'+ (bien) + "</span>";     }
     else{   return bien }
}
function lonchauc (cellValue, options, rowdata){
   var bien=cellValue;
   if(bien=='T6'|| bien=='T7'|| bien=='T8' || bien=='T9' || bien=='TS'){  return '<span style="color:red; font-weight: bold;">'+ (bien) + "</span>";     }
     else{   return bien }
}
function lonchaua (cellValue, options, rowdata)
{
var bien=parseFloat(cellValue);
var lon=" ";
   if (bien==0)
   {
    return lon;
   }
    else if (bien<5)
    {
   return '<span class="md-flexbox-code" style="color:#000000; font-weight: bold;">'+ (bien).toFixed(1) + "</span>";
    }
    else if (bien>=5 && bien<8 )
    {
   return '<span class="md-flexbox-code" style="color:#FF00F3; font-weight: bold;">'+ (bien).toFixed(1) + "</span>";
    }
   else
    {
   return '<span class="md-flexbox-code" style="color:#0000FF; font-weight: bold;">'+ (bien).toFixed(1) + "</span>";
    }
}
function lonchauaA (cellValue, options, rowdata)
{var bien=cellValue;
   if (bien=='x')
   { return '<span style="color:#0000FF; font-weight: bold; text-align: center; background: #00ff00;">'+ (bien) + "</span>";  }
    else{return bien;}
}

jQuery("#kqhtcacnamp").change(function(){
     var vl = $(this).val();
     if(vl) {
        if(vl == "xoa") {
          jQuery("#grid4p").jqGrid('groupingRemove',true);
                }
  else if (vl == "nh"){
            jQuery("#grid4").jqGrid('groupingGroupBy',[vl,'lop'], { groupText: [
            '<span class="mausac11">Năm học {0} </span>-Có <span class="mausac4">{1}</span><b> lớp</b>',
            'Khối: {0}- có <span class="mausac4">{1}</span> <b> lớp'
                ] ,groupOrder : ['desc','asc']} );
                    }
  else if (vl == "nh1"){
            jQuery("#grid4p").jqGrid('groupingGroupBy',['lop'], { groupText: [
            '<span class="mausac11">Lớp {0} </span>-Có <span class="mausac4">{1}</span><b> NH</b>',
                ] ,groupOrder : ['desc','asc']} );
                    }
  else if (vl == "lop"){
            jQuery("#grid4p").jqGrid('groupingGroupBy',[vl,'nh'], { groupText: [
            '<span class="mausac2">Khối {0} </span>-Có <span class="mausac4">{1}</span><b> lớp</b>',
            '<span class="mausac4">Năm học:</span> {0}- có <span class="mausac3">{1}</span> <b> lớp',
                ] ,groupOrder : ['desc','asc']} );
                    }

     else if (vl == "lop1"){
            jQuery("#grid4p").jqGrid('groupingGroupBy',['lop'], { groupText: [
            '<span class="mausac2">Lớp: {0} </span>-Có <span class="mausac1">{1}</span><b> năm học</b>',
            ], groupCollapse: true, groupColumnShow:[true],groupOrder : ['asc','desc'] } );
                   }
      }
});


 });</script>