ของหน่วยงานปล่อยว่างไว้</font>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>หน่วยงานเจ้าของผลงาน</label>";
      echo "<div class='col-sm-6'>";
      echo "<select name='schoolcode' class='form-control'>";
      if($schoolBest==$system_office_code){
        echo "<option value='".$system_office_code."' selected>สพท.</option>";
      }else{
        echo "<option value='".$system_office_code."'>สพท.</option>";
      }
      $dbSCH=mysqli_query($connect, "SELECT * FROM system_school");
      while ($rsSCH=mysqli_fetch_array($dbSCH)){
        $school_Code=$rsSCH[smis];
        if ($school_Code==$schoolBest) {
          echo "<option value='$school_Code' selected>".$rsSCH[schoolname]." ".$status[$school_Code]."</option>";
        }else{
          echo "<option value='$school_Code'>".$rsSCH[schoolname]." ".$status[$school_Code]."</option>";
        }
      }
      echo "</select>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>ระดับของผลงาน</label>";
      echo "<div class='col-sm-6'>";
      echo "<select name='level' class='form-control'>";
      echo "<option value=''>เลือก</option>";
      for($l=0; $l<count($level); $l++){
        if ($level[$l]==$rs[level]) {
          echo "<option value='$level[$l]' selected>".$level[$l]."</option>";
        }else{
          echo "<option value='$level[$l]'>".$level[$l]."</option>";
        }
      }
      echo "</select>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>เรื่อง/หัวข้อ</label>";
      echo "<div class='col-sm-6'>";
        echo "<input type='text' name='subject' class='form-control' value='".$rs[subject]."'>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>รับรองโดย</label>";
      echo "<div class='col-sm-6'>";
        echo "<input type='text' name='guarantee' class='form-control' value='".$rs[guarantee]."'>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>อัพโหลดไฟล์ ";
      echo "</label>";
      echo "<div class='col-sm-6'>";
        echo "<input type='file' name='refer_file'>";
        if($rs[refer_file] != ''){
        echo "<hr><i class='fas fa-file-download fa-lg'></i> ".$rs[refer_file];
        //echo "<img src='$rs[refer_file]' width='150'>";
        }
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>Link เนื้อหา/บทความอ้างอิง</label>";
      echo "<div class='col-sm-9'>";
        echo "<input type='text' name='refer_link' class='form-control' value='".$rs[refer_link]."'>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "<div class='form-group row'>";
      echo "<label class='col-sm-3 col-form-label'>รายละเอียด</label>";
      echo "<div class='col-sm-9'>";
        echo "<textarea class='textarea' name='detail'>$rs[detail]</textarea>";
      echo "</div>";  //.col-sm
    echo "</div>";  //.form-group row

    echo "</div>";    //<!-- /.card-body col-12 -->
    echo "<div class='card-footer'>";
      echo "<a class='btn btn-app bg-dark' href='JavaScript:window.history.go(-1);'><i class='fas fa-redo'></i>ยกเลิก</a>";
      echo "<a class='btn btn-app float-right bg-danger' href=\"javascript:$('form').submit()\"><i class='fas fa-save'></i>บันทึก</a>";
    echo "</div>";
    echo "</form>";
    echo "</div>";    //<!-- /.card card-primary -->
    break;

  case 'update':
    $basename = basename($_FILES['refer_file']['name']);
    if ($basename!=""){
      $fileName = file_upload();
      $sql = "UPDATE best SET year='$_POST[year]', name='$_POST[name]', schoolcode='$_POST[schoolcode]', subject='$_POST[subject]', guarantee='$_POST[guarantee]', level='$_POST[level]', refer_file='$fileName', refer_link='$_POST[refer_link]', detail='$_POST[detail]' WHERE id='$id' ";
    }else{
      $sql = "UPDATE best SET year='$_POST[year]', name='$_POST[name]', schoolcode='$_POST[schoolcode]', subject='$_POST[subject]', guarantee='$_POST[guarantee]', level='$_POST[level]', refer_link='$_POST[refer_link]', detail='$_POST[detail]' WHERE id='$id' ";
    }
    $dbquery = mysqli_query($connect,$sql);
    echo "<center><img src='images/ok.png' border=0 height=200></center>";
    echo "<meta http-equiv='refresh' content='0;url=tableBest.php?op=1.6'>";
  break;

  case 'del':
    $db=mysqli_query($connect, "DELETE FROM best WHERE id='$id' ");
    echo "<center><img src='images/ok.png' border=0 height=200></center>";
    echo "<meta http-equiv='refresh' content='0;url=tableBest.php?op=1.6'>";
    break;

  default:    // .$sch No blank //
    //<!-- Main content -->
    echo "<section class='content'>";
    echo "<div class='card card-default'>";
      echo "<div class='card-body'>";
    echo "<div class='col-12 col-sm-6'>";
    echo "<label>ค้นหา <i class='fas fa-search'></i></label>";
    echo "<select name='schoolcode' class='form-control' onChange=location.href='tableBest.php?op=1.6&sch='+this.options[this.selectedIndex].value;>";
    echo "<option value='All'>สพท.</option>";
    $db=mysqli_query($connect, "SELECT * FROM system_school");
    while ($rs=mysqli_fetch_array($db)){
      $school_Code=$rs[smis];
      if ($school_Code==$sch) {
        echo "<option value='$school_Code' selected>".$rs[schoolname]." ".$status[$school_Code]."</option>";
      }else{
        echo "<option value='$school_Code'>".$rs[schoolname]." ".$status[$school_Code]."</option>";
      }
    }
    echo "</select>";
    echo "</div>";    //<!-- /.col-12 -->
    echo "</div>";    //<!-- /.card-body -->

    echo "<div class='card-body'>";
    echo "<Table style='width:100%' id='myTable' class='table table-bordered table-hover'>";
    echo "<thead><th>ปี</th><th>เจ้าของผลงาน<br>หน่วยงาน</th><th>เรื่อง/หัวข้อ</th>
      <th>ระดับของผลงาน</th><th>ดูข้อมูล</th></thead>";
    echo "<tbody>";
    $query=mysqli_query($connect, "SELECT * FROM best order by year");
    while($rs=mysqli_fetch_array($query)){
      $id=$rs[id];
      $school_Code=$rs[schoolcode];
      if($school_Code==$system_office_code){
        $officeName=$_s_name;
      }else{
        $officeName=$schoolName[$school_Code];
      }
      echo "<tr><td>$rs[year]</td>";
      echo "<td>";
      if($rs[name]!=''){
        echo $rs[name]."<br>(".$officeName.")";
      }else{
        echo $officeName."</td>";
      }
      echo "<td>$rs[subject]</td>";
      if($rs[guarantee]==''){
        echo"<td>$rs[level]</td>";
      }else{
        echo "<td>$rs[level]<br>($rs[guarantee])</td>";
      }
      echo "<td align=center width=100><a href='#detail$id' data-toggle='modal'><i class='fas fa-eye text-$navbarColor fa-lg'></i></a>";
      // .for Admin
      if($_SESSION['admin_bigdata']=='bigdata'){
        echo " &nbsp;<a href='tableBest.php?op=1.6&page=edit&id=$id' title='ขอแก้ไข'><i class='fas fa-edit text-success fa-lg'></i></a>";
        echo " &nbsp;<a href='tableBest.php?op=1.6&page=del&id=$id' title='ลบทันที' onClick='return Conf(this)'><i class='fas fa-trash text-danger fa-lg'></i></a>";
      }
      echo "</td></tr>";
      //<!--start In Modal -->
                  echo "<div id='detail$id' class='modal fade' role='dialog'>";
      echo "<div class='modal-dialog modal-lg'>";
      echo "  <div class='modal-content'>";
      echo"    <div class='modal-header'>";
      echo "      <div class='modal-title'><i class='nav-icon fas fa-star fa-lg text-$navbarColor'></i> BEST PRACTICE ID : $id</div>";
      echo "    </div>";
      echo "    <div class='modal-body'>";
        //<!-- Detail start -->
        $sql="SELECT * FROM best WHERE id='$id'";
        $db=mysqli_query($connect, $sql);
        $rs=mysqli_fetch_array($db);
        $schoolBest=$rs[schoolcode];
        echo "<div class='card-body col-12'>";
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>ปี</div></div>";
          echo $rs[year] ;
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>ชื่อ - สกุล เจ้าของผลงาน</div></div>";
          echo $rs[name];  //.col-sm
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>หน่วยงานเจ้าของผลงาน</div></div>";
          if($schoolBest==$system_office_code){
            echo $_name;
          }else{
            $dbSCH=mysqli_query($connect, "SELECT * FROM system_school WHERE smis='$schoolBest' ");
            $rsSCH=mysqli_fetch_array($dbSCH);
            echo $rsSCH[schoolname]." ".$status[$school_Code];
          }
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>ระดับผลงาน</div></div>";
            echo $rs[level];
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>เรื่อง/หัวข้อ</div></div>";
          echo $rs[subject] ;
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>รับรองโดย</div></div>";
          echo $rs[guarantee] ;
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>ไฟล์</div></div>";
          if($rs[refer_file] != ''){
            echo "<a class='btn btn-app' href=$rs[refer_file] target='_blank'><i class='fas fa-file-download'></i>Download</a>";
            //echo "<img src='$rs[refer_file]' width='150'>";
            }
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>เนื้อหา/บทความอ้างอิง</div></div>";
            if($rs[refer_link] != ''){
              echo "<a class='btn btn-app' href=$rs[refer_link] target='_blank'><i class='fas fa-globe'></i>URL</a>";
            }
        echo "</div>";  //.form-group row
        echo "<div class='form-group row'>";
          echo "<div class='col-sm-3'><div class='text-title text-info float-right'>รายละเอียด</div></div>";
          echo $rs[detail] ;
        echo "</div>";  //.form-group row
      echo "    </div>";
      echo "    <div class='modal-footer'>";
      echo "    <button type='button' class='btn btn-default' data-dismiss='modal'><i class='fas fa-times'></i> ปิด</button>";
      echo "    </div>";
      echo "  </div>";
      echo "</div>";
      echo "</div>";
      //  <!--End Modal -->
    }
    echo "</tbody>";
    echo "</table>";
    echo "</form>";
    echo "</div>";    //<!-- /.card-body -->
    echo "</div></section>";
    break;
}

echo "</div></div>";  //<!-- /.Main Content -->
echo "</div>";  //<!-- /.content-wrapper -->

include("index.f.php"); ?>
<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<script src="plugins/summernote/lang/summernote-th-TH.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote({
    lang: 'th-TH',
    placeholder: '<h1>บันทึกรายละเอียด</h1>',
    tabsize: 2,
    height: 250,
    toolbar: [
      ['font', ['bold', 'italic', 'underline', 'clear']],
      ['para', ['ul', 'ol']],
      ['insert', ['link', 'picture', 'video']],
      ['view', ['fullscreen', 'codeview', 'help']]
    ]
  })
  });
</script>

  <!--Data Table-->
  <!--Export table button CSS-->
  <link rel="stylesheet" href="js/dataTable/jquery.dataTables.min.css">
  <link rel="stylesheet" href="js/dataTable/buttons.dataTables.min.css">
  <script type="text/javascript" src="js/dataTable/jquery-2.1.1.min.js"></script>
  <script type="text/javascript"  src="js/dataTable/jquery.dataTables.min.js"></script>
  <script type="text/javascript"  src="js/dataTable/dataTables.buttons.min.js"></script>
  <!--Export table buttons-->
  <script type="text/javascript"  src="js/dataTable/jszip.min.js"></script>
  <script type="text/javascript" src="js/dataTable/pdfmake.min.js" ></script>
  <script type="text/javascript"  src="js/dataTable/vfs_fonts.js"></script>
  <script type="text/javascript" src="js/dataTable/buttons.html5.min.js"></script>
  <script type="text/javascript" src="js/dataTable/buttons.print.min.js"></script>
  <script type="text/javascript" src="js/dataTable/buttons.colVis.min.js"></script>

<script type="text/javascript" charset="utf-8">
<!--
  var $i=jQuery.noConflict();
  $i(document).ready(function() {
    $i('#myTable').DataTable( {
      dom: 'Bfrtip',
      buttons: [{
        extend: 'excelHtml5',
        title : '' ,
        text: '<i class="fas fa-file-excel"></i> ส่งออก EXCEL',
        titleAttr: 'Excel'
      },
      {
        extend: 'print',
        title : '' ,
        text: '<i class="fas fa-print"></i> พิมพ์',
        titleAttr: 'PRINT'
      }
      ],
      "lengthMenu": [[100, 200, -1], [100, 200, "All"]],
      "oLanguage": {
      "sLengthMenu": "แสดง _MENU_ เร็คคอร์ด ต่อหน้า",
      "sZeroRecords": "ไม่เจอข้อมูลที่ค้นหา",
      "sInfo": "แสดง _START_ ถึง _END_ ของ _TOTAL_ เร็คคอร์ด",
      "sInfoEmpty": "แสดง 0 ถึง 0 ของ 0 เร็คคอร์ด",
      "sInfoFiltered": "(จากเร็คคอร์ดทั้งหมด _MAX_ เร็คคอร์ด)",
      "sSearch": "ค้นหา :"
    }
    });
});

function Conf(object) {
  if (confirm("ยื น ยั น !  คุณต้องการทำรายการนี้ - ใช่ หรือ ไม่") ==true) {
  return true;
  }
  return false;
}
//-->
</script>

<div class='modal fade bd-example-modal-xl' id='bestModal' role="dialog">
<div class='modal-dialog modal-xl' role=document>  <div class='modal-content'>    <div class='modal-header'>      <h4 class='modal-title'>Default Modal </h4>      <button type='button' class='close' data-dismiss='modal' aria-label='Close'>        <span aria-hidden='true'>&times;</span>      </button>    </div>    <div class='modal-body'><div class='card card-info'><div class='card-header'><span id='first'></span><h3 class='card-title'><i class='nav-icon fas fa-thumbs-up fa-lg'></i> ข้อมูล BEST PRACTICE ID : </h3></div><div class='card-body col-12'><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>ปี</h6></div><div class='col-sm-1'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>ชื่อ - สกุล เจ้าของผลงาน</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>หน่วยงานเจ้าของผลงาน</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>ระดับผลงาน</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>เรื่อง/หัวข้อ</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>รับรองโดย</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>ไฟล์</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>Link เนื้อหา/บทความอ้างอิง</h6></div><div class='col-sm-9'></div></div><div class='form-group row'><div class='col-sm-3'><h6 class='text-title text-info'>รายละเอียด</h6></div><div class='col-sm-9'></div></div></div></form></div>      </div>      <div class='modal-footer justify-content-between'>        <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>      </div>    </div>  </div></div>