SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nhttrqhz_ttr2.TK_TDUA_CAC_TRUONG1' doesn't exist<table id='gridtd113'></table><script type='text/javascript'>jQuery(document).ready(function($) {jQuery('#gridtd113').jqGrid({"width":1300,"hoverrows":true,"viewrecords":true,"jsonReader":{"repeatitems":false,"subgrid":{"repeatitems":false}},"xmlReader":{"repeatitems":false,"subgrid":{"repeatitems":false}},"gridview":true,"url":"TK_KE_TDUA_CAC_TRUONG.php","editurl":"TK_KE_TDUA_CAC_TRUONG.php","cellurl":"TK_KE_TDUA_CAC_TRUONG.php","caption":"<span style=\"color:#0000ff; font-size: 17px; font-weight: bold;\">THỐNG KÊ SỐ LƯỢNG DANH HIỆU THI ĐUA BẬC THCS&nbsp;&nbsp;&nbsp;</span><select id=\"box123a\">\n        <option value=\"nh\">NĂM HỌC</option>\n        <option value=\"dv\">ĐƠN VỊ</option>\n        <option value=\"xoa\">XÓA GROUP</option>\n         </select>","rowNum":1000,"rowList":[50,100,1500],"sortname":"nh","height":"auto","userDataOnFooter":true,"footerrow":true,"rownumbers":true,"grouping":true,"groupingView":{"groupField":["nh"],"groupColumnShow":[true],"groupText":["<b>Năm học: {0}</b><span class=\"mausac3\">(CSTĐ={sl_cstd}, LĐTT={sl_ldtt}, TTLĐXS={sl_ttxs},TTLĐTT={sl_tttt}, Cờ TĐ={sl_co}, B.Khen={sl_bk}, B.Khen C.Nhân={sl_bk_cn}, B.Khen T.Thể={sl_bk_tt})</span>"],"groupDataSorted":true,"groupSummary":[true],"groupCollapse":false,"groupOrder":["desc"]},"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":"#pagertd113"});jQuery('#gridtd113').jqGrid('navGrid','#pagertd113',{"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('#gridtd113').jqGrid('navButtonAdd','#pagertd113',{id:'pagertd113_excel', caption:'',title:'Export To Excel',onClickButton : function(e)
{
    try {
        jQuery("#gridtd113").jqGrid('excelExport',{tag:'excel', url:'TK_KE_TDUA_CAC_TRUONG.php'});
    } catch (e) {
        window.location= 'TK_KE_TDUA_CAC_TRUONG.php?oper=excel';
    }
},buttonicon:'ui-icon-newwin'});jQuery('#gridtd113').jqGrid('setGroupHeaders',{"useColSpanStyle":true,"groupHeaders":[{"startColumnName":"sl_cstd","numberOfColumns":3,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">CSTĐ</span>"},{"startColumnName":"sl_ldtt","numberOfColumns":4,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">LĐ TIÊN TIẾN</span>"},{"startColumnName":"sl_bk","numberOfColumns":3,"titleText":"<span style=\"color:#0000Ff; font-weight: bold;\">BẰNG KHEN</span>"}]});
  function lonchaub (cellValue, options, rowdata){
   var bien=cellValue;
   if(bien=='CSTĐ'|| bien=='M'|| bien=='Nữ' || bien=='XH'){  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:red; font-weight: bold;">'+ (bien) + "</span>";
    }
    else if (bien>=5 && bien<8 )
    {
   return '<span class="md-flexbox-code" style="color:#FF00F3; font-weight: bold;">'+ (bien) + "</span>";
    }
   else
    {
   return '<span class="md-flexbox-code" style="color:#0000FF; font-weight: bold;">'+ (bien) + "</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("#box123a").change(function(){
     var vl = $(this).val();
     if(vl) {
        if(vl == "xoa") {
          jQuery("#gridtd113").jqGrid('groupingRemove',true);
                }
  else if (vl == "nh"){
            jQuery("#gridtd113").jqGrid('groupingGroupBy',[vl], { groupText: [
            '<span class="mausac0">Năm học: {0} </span> <span class="mausac4">(CSTĐ={sl_cstd}, LĐTT={sl_ldtt}| TTLĐTT={sl_tttt},TTLĐXS={sl_ttxs}| Cờ TĐ={sl_co}, B.Khen={sl_bk}, B.Khen C.Nhân={sl_bk_cn}, B.Khen T.Thể={sl_bk_tt})</span>',
            '<span class="mausac3">Đơn vị: {0}</span> <span class="mausac5">(CSTĐ={sl_cstd}, LĐTT={sl_ldtt}| TTLĐTT={sl_tttt},TTLĐXS={sl_ttxs}| Cờ TĐ={sl_co}, B.Khen={sl_bk}, B.Khen C.Nhân={sl_bk_cn}, B.Khen T.Thể={sl_bk_tt})</span>'
                ] ,groupOrder : ['desc','asc']} );
                    }
    else if (vl == "dv"){
            jQuery("#gridtd113").jqGrid('groupingGroupBy',[vl], { groupText: [
            '<span class="mausac1">Đơn vị: {0} </span> <span class="mausac5">(CSTĐ={sl_cstd}, LĐTT={sl_ldtt}, TTLĐTT={sl_tttt},TTLĐXS={sl_ttxs}, Cờ TĐ={sl_co}, B.Khen={sl_bk}, B.Khen C.Nhân={sl_bk_cn}, B.Khen T.Thể={sl_bk_tt})</span>',
            '<span class="mausac4">Năm học: {0} </span> <span class="mausac7">(CSTĐ={sl_cstd}, LĐTT={sl_ldtt},TTLĐTT={sl_tttt}, TTLĐXS={sl_ttxs}, Cờ TĐ={sl_co}, B.Khen={sl_bk}, B.Khen C.Nhân={sl_bk_cn}, B.Khen T.Thể={sl_bk_tt})</span>'
            ], groupCollapse: true, groupColumnShow:[true],groupOrder : ['asc','desc'] } );
                   }

      }
});

 });</script>