Gecko [ research.sskru.ac.th ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
_test	[ DIR ]	drwxr-xr-x
files	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
mods	[ DIR ]	drwxr-xr-x
pics	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
_config.php	247 B	-rw-r--r--
_json.php	747 B	-rw-r--r--
_lib.php	1.06 KB	-rw-r--r--
action.php	602 B	-rw-r--r--
admin.php	4.42 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
ajax.php	1.08 KB	-rw-r--r--
areas_of_operation.php	11.18 KB	-rw-r--r--
areas_of_operation_test.php	11.18 KB	-rw-r--r--
footer.php	265 B	-rw-r--r--
inde-4.php	871.03 KB	-rw-r--r--
index.php	11.8 KB	-rw-r--r--
index1.php	11.98 KB	-rw-r--r--
innovation_find.php	11.56 KB	-rw-r--r--
innovation_fox.php	584 B	-rw-r--r--
innovations.php	13.44 KB	-rw-r--r--
localhost.sql	1.8 MB	-rw-r--r--
publication_find.php	11.87 KB	-rw-r--r--
publications.php	21.83 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
research_find.php	10.06 KB	-rw-r--r--
research_view.php	8.06 KB	-rw-r--r--
researcher_faculty.php	9.87 KB	-rw-r--r--
researcher_find.php	9.52 KB	-rw-r--r--
researcher_info.php	13.07 KB	-rw-r--r--
researchers.php	15.65 KB	-rw-r--r--
researches.php	16.27 KB	-rw-r--r--
scan.php	0 B	-rw-r--r--
tenka.massupload.v1.php	0 B	-rw-r--r--

Code Editor : areas_of_operation.php

<?php
	include "_lib.php";

$sql = "SELECT MAX(fund_year) AS max_year, MIN(fund_year) as min_year FROM research WHERE fund_year > 0 ";
  $year = $g_db->getObject($sql);

$start = $g_util->getParam('start', $year->min_year);
  $stop = $g_util->getParam('stop', $year->max_year);
  $province = $g_util->getParam('province', '');

$sql_cond = " AND fund_year BETWEEN '".$start."' AND '".$stop."' ";
  if ($province != '') {
    $sql_cond .= " AND area_province = '".$province."' ";
  }
  
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>ระบบสาระสนเทศงานวิจัย สถาบันวิจัยและพัฒนา มหาวิทยาลัยราชภัฏศรีสะเกษ </title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="icon" type="image/x-icon" href="images/logo.ico">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" href="includes/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Noto+Sans+Thai&display=swap">
<style>
    body,h1,h2,h3,h4,h5 {font-family: 'Noto Sans Thai', sans-serif; color:#333333;}
    body {font-size:16px;}
    *{margin: 0;
    padding: 0;
    box-sizing: border-box;
    list-style: none;
    text-decoration: none;
    font-family: 'Noto Sans Thai', sans-serif;}
    .w3-half img{margin-bottom:-6px;margin-top:16px;opacity:0.8;cursor:pointer}
    .w3-half img:hover{opacity:1}
    .ris-dark {background-color:#232659; color:#FFF;}
    .ris-light {color:#f4c213;}
    .ris-hover:hover {background-color:#f4c213!important; color:#232659!important;}
    .ris-active {background-color:#f4c213; color:#232659;!important}
    .ris-link {color:#000088!important;}
    .ris-link-hover:hover {color:#880000!important;}
</style>
  <script src="https://api.longdo.com/map/?key=e33e1029912c128a2e2c777051ce1ee4"></script>
  <script>
    var map;
    function init() {
      map = new longdo.Map({
        placeholder: document.getElementById('map')
      });
    <?php
      if ($province != '') {
        $sql = "SELECT PROVINCE_LAT, PROVINCE_LONG, PROVINCE_ZOOM FROM area_provinces WHERE PROVINCE_ID='".$province."' ";
        $loc = $g_db->getObject($sql);
    ?>
      map.location({ lon:<?=$loc->PROVINCE_LONG?>, lat:<?=$loc->PROVINCE_LAT?> }, true);
      map.zoom(<?=$loc->PROVINCE_ZOOM?>, true);
    <?php
      } else {
    ?>
      map.location({ lon:100, lat:16 }, true);
      map.zoom(6, true);
    <?php
      }
    ?>
      //map.Ui.DPad.visible(false);
      //map.Ui.Zoombar.visible(false);
      //map.Ui.Geolocation.visible(false);
      map.Ui.Toolbar.visible(false);
      map.Ui.LayerSelector.visible(false);
      map.Ui.Fullscreen.visible(false);
      map.Ui.Crosshair.visible(false);
      map.Ui.Scale.visible(false);
<?php
  $sql = "SELECT 
              research.id, 
              research.title, 
              researcher.tname, 
              researcher.name, 
              research.fund_year, 
              research.area_lat, 
              research.area_long, 
              research.area_address 
          FROM research 
            LEFT JOIN researcher ON (research.researcher_id = researcher.id)
          WHERE research.area_lat IS NOT NULL AND research.area_long IS NOT NULL ";
  $sql .= $sql_cond;
  $sql .= " ORDER BY research.id ";
  $rows = $g_db->getObjects($sql);
  foreach ($rows as $row) {
    if (is_numeric($row->area_lat) && is_numeric($row->area_long)) {
?>
      var marker<?=$row->id?> = new longdo.Marker({ lon: <?=$row->area_long?>, lat: <?=$row->area_lat?> },
      {
        title: '<?=$row->title?>',
        detail: '<?=$row->tname?> <?=$row->name?><br>ปีงบประมาณ <?=$row->fund_year?><br><br><a href="https://www.research.sskru.ac.th/ris/research_view.php?res_id=<?=$row->id?>" target="_blank"><b>รายละเอียด</b></a>',
        visibleRange: { min: 6, max: 19 },
        weight: longdo.OverlayWeight.Top,
        icon: {
            url: 'https://www.research.sskru.ac.th/ris/images/marker/<?=$row->fund_year?>i.png',
            offset: { x: 12, y: 45 }
        }
        
      });
      map.Overlays.add(marker<?=$row->id?>);
<?php
    }
  }
?>
    }
  </script>
</head>
<body onload="init();">

<nav class="w3-sidebar ris-dark w3-collapse w3-top w3-padding" style="z-index:3;width:250px;" id="mySidebar"><br>
    <a href="javascript:void(0)" onclick="w3_close()" class="w3-button w3-hide-large w3-display-topleft" style="width:100%;font-size:22px">X</a>
    <div class="w3-container">
        <h3 class="w3-padding-16 ris-light" style="font-weight: bold;">RIS SSKRU</h3>
    </div>
    <div class="w3-bar-block">
        <a href="index.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large" ris-hover><i class="fa fa-home" aria-hidden="true"></i> หน้าหลัก</a> 
        <a href="researches.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-hover"><i class="fa fa-file-text-o" aria-hidden="true"></i> งานวิจัย</a> 
        <a href="researchers.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-hover"><i class="fa fa-users" aria-hidden="true"></i> นักวิจัย</a> 
        <a href="publications.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-hover"><i class="fa fa-newspaper-o" aria-hidden="true"></i> การตีพิมพ์</a> 
        <a href="innovations.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-hover"><i class="fa fa-cogs" aria-hidden="true"></i> นวัตกรรมและสิ่งประดิษฐ์</a> 
        <a href="areas_of_operation.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-active"><i class="fa fa-globe" aria-hidden="true"></i> พื้นที่ดำเนินการ</a> 
        <a href="admin.php" onclick="w3_close()" class="w3-bar-item w3-button w3-round-large ris-hover"><i class="fa fa-user-secret" aria-hidden="true"></i> ผู้ดูแลระบบ</a>
    </div>
    </nav>

<header class="w3-container w3-top w3-hide-large w3-xlarge w3-padding">
    <a href="javascript:void(0)" class="w3-button w3-red w3-margin-right" onclick="w3_open()">&#9776;</a>
    <span></span>
    </header>

<div class="w3-overlay w3-hide-large" onclick="w3_close()" style="cursor:pointer" title="close side menu" id="myOverlay"></div>

<div class="w3-main" style="margin-left:250px;margin-right:0px">
        <div class="w3-bottombar" style="padding-top:20px;padding-bottom:20px">
            <div class="w3-row">
                <div class="w3-col" style="width:140px"><img src="images/logo.png" class="w3-image w3-padding"></div>
                <div class="w3-rest"><br><h3>ระบบสารสนเทศงานวิจัย สถาบันวิจัยและพัฒนา มหาวิทยาลัยราชภัฏศรีสะเกษ<br>
                Research Information System(RIS)</h3></div>
            </div>
        </div>
        <div class="w3-panel">
            <a href="index.php" class="ris-link ris-link-hover">หน้าหลัก</a> > 
            พื้นที่ดำเนินการ
        </div>
        <div class="w3-panel w3-center">
            <center>
            <form action="areas_of_operation.php">
                <div class="w3-cell" style="width: 350px;">
                  <div class="w3-cell-row w3-panel">
                    <div class="w3-cell">ปีงบประมาณ: </div>
                    <div class="w3-cell">
                      <select id="start" name="start" class="w3-select w3-border w3-text-indigo" required>
                      <?php
                        print $g_util->optionIntRev($start, $year->max_year, $year->min_year);
                      ?>
                      </select>
                    </div>
                    <div class="w3-cell"> ถึง </div>
                    <div class="w3-cell">
                      <select id="stop" name="stop" class="w3-select w3-border w3-text-indigo" required>
                      <?php
                        print $g_util->optionIntRev($stop, $year->max_year, $year->min_year);
                      ?>
                      </select>
                    </div>
                  </div>
                </div>
                <div class="w3-cell"> &nbsp; จังหวัด: &nbsp;</div>
                <div class="w3-cell">
                  <select id="province" name="province" class="w3-select w3-border w3-text-indigo">
                    <option value=""></option>
                  <?php
                    $sql = "SELECT PROVINCE_ID, PROVINCE_NAME FROM area_provinces WHERE 1 ORDER BY CONVERT(PROVINCE_NAME using tis620) ";
                    print $g_db->getOption($sql, $province);
                  ?>
                  </select>
                </div>
                <div class="w3-cell">
                    <button type="submit" class="w3-button w3-large w3-border w3-blue"><i class="fa fa-search" aria-hidden="true"></i> ค้นหา</button>
                </div>
            </form>
            </center>
        </div>

<?php
            $sql = "SELECT area_province FROM research WHERE area_province is NOT NULL ".$sql_cond." GROUP BY area_province";
            $provinces = $g_db->getRecordCount($sql);

$sql = "SELECT area_amphur FROM research WHERE area_amphur is NOT NULL ".$sql_cond." GROUP BY area_amphur";
            $amphurs = $g_db->getRecordCount($sql);

$sql = "SELECT area_district FROM research WHERE area_district is NOT NULL ".$sql_cond." GROUP BY area_district";
            $districts = $g_db->getRecordCount($sql);

$sql = "SELECT id FROM research WHERE area_province is NOT NULL".$sql_cond;
            $totals = $g_db->getRecordCount($sql);
        ?>
        <div class="w3-cell-row w3-panel">
            <div class="w3-cell">
                <h2 class="w3-center" style="font-weight: bold;">AREA OF OPERATION RIS SSKRU</h2>
            </div>
            <div class="w3-cell">
              <div class="w3-padding w3-center w3-light-blue w3-card-4">
                    <h2><?=$g_util->setNumberFormat($provinces)?></h2>
                    จังหวัด
                </div>
            </div>
            <div class="w3-cell">
              <div class="w3-padding w3-center w3-khaki w3-card-4 w3-margin-left">
                    <h2><?=$g_util->setNumberFormat($amphurs)?></h2>
                    อำเภอ
                </div>
            </div>
            <div class="w3-cell">
                <div class="w3-padding w3-center w3-sand w3-card-4 w3-margin-left">
                    <h2><?=$g_util->setNumberFormat($districts)?></h2>
                    ตำบล
                </div>
            </div>
        </div>
    
          <div class="">
            <div id="map" class="w3-margin" style="width: 96%; height: 600px;"> </div>
          </div>

<?php
        include("footer.php");
?>
</div>
</body>
</html>
<?php
    $g_db->close();
?>

${this.title}

Code Editor : areas_of_operation.php