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 : researchers.php

<?php
	include "_lib.php";
?>
<!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>

</head>
<body>

<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-active"><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-hover"><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-red 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="researcher_find.php">
                <div class="w3-cell">
                    <input type="text" name="kw" class="w3-input w3-large w3-border w3-text-blue" placeholder="ค้นหานักวิจัย..." style="width: 350px;">
                    <input type="radio" name="find_in" value="name" class="w3-radio" checked> จากชื่อ - นามสกุล &nbsp; &nbsp;
                    <input type="radio" name="find_in" value="expertise" class="w3-radio"> จากความเชี่ยวชาญ
                </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 id, faculty_id FROM researcher WHERE 1 ";
            $reses = $g_db->getObjects($sql);
            foreach ($reses as $res) {
                $sql = "UPDATE research SET faculty_id='".$res->faculty_id."' WHERE researcher_id='".$res->id."' ";
                $g_db->query($sql);
            }
            for ($fac_id = 1; $fac_id <= 12; $fac_id) {
                $sql = "SELECT COUNT(id) AS total FROM research WHERE faculty_id";
            }
        */
        /*
            $sql = "SELECT id, name FROM faculty WHERE 1 ORDER BY ordering";
            $facs = $g_db->getObjects($sql);
            for ($year = 2565; $year <= 2567; $year++) {
                foreach ($facs as $fac) {
                    $sql = "SELECT COUNT(id) AS total FROM research WHERE fund_year='".$year."' AND faculty_id='".$fac->id."' ";
                    $total = $g_db->getValue($sql);

$binds = array();
                    $binds['faculty_id'] = $fac->id;
                    $binds['faculty_name'] = $fac->name;
                    $binds['research_year'] = $year;
                    $binds['research_count'] = $total;
                    $g_db->insertData('report_faculty_research', $binds);
                }
            }
        */

$sql = "SELECT id, name FROM faculty WHERE 1 ORDER BY ordering";
        $facs = $g_db->getObjects($sql);
        $series = "";
        foreach ($facs as $fac) {
            $series .= "createSeries('f".$fac->id."', '".$fac->name."');\n";
        }

$data = "";
        for ($year = 2565; $year <= 2567; $year++) {
            $sql = "SELECT * FROM report_faculty_research WHERE research_year='".$year."' ";
            $reports = $g_db->getObjects($sql);
            
            $data .= "{
                        category: '".$year."',\n";
            foreach($reports as $report) {
                $data .= "f".$report->faculty_id.": ".$report->research_count.",\n";
            }
            $data .= "},\n";
        }

?>
        <script>
            am4core.ready(function() {

// Themes begin
            am4core.useTheme(am4themes_animated);
            // Themes end

var chart = am4core.create('chartdiv', am4charts.XYChart)
            chart.colors.step = 2;
            chart.paddingTop = 40;

let title = chart.titles.create();
            title.text = "จำนวนนักวิจัยแยกตามหน่วยงาน 3 ปีย้อนหลัง";
            title.fontSize = 18;
            title.fontWeight = "bold";
            title.padding(0, 0, 30, 0);

chart.legend = new am4charts.Legend()
            chart.legend.position = 'right'
            chart.legend.paddingBottom = 20
            chart.legend.labels.template.maxWidth = 150

var xAxis = chart.xAxes.push(new am4charts.CategoryAxis())
            xAxis.dataFields.category = 'category'
            xAxis.renderer.cellStartLocation = 0.1
            xAxis.renderer.cellEndLocation = 0.9
            xAxis.renderer.grid.template.location = 0;
            xAxis.title.text = "ปีงบประมาณ";

var yAxis = chart.yAxes.push(new am4charts.ValueAxis());
            yAxis.min = 0;
            yAxis.title.text = "จำนวนนักวิจัย";

function createSeries(value, name) {
                var series = chart.series.push(new am4charts.ColumnSeries())
                series.dataFields.valueY = value
                series.dataFields.categoryX = 'category'
                series.name = name

series.columns.template.tooltipText = "ปี {categoryX}\n{name}\n{valueY} คน";

series.events.on("hidden", arrangeColumns);
                series.events.on("shown", arrangeColumns);
                /*
                var bullet = series.bullets.push(new am4charts.LabelBullet())
                bullet.interactionsEnabled = false
                bullet.dy = 30;
                bullet.label.text = '{valueY}'
                bullet.label.fill = am4core.color('#ffffff')
                */

return series;
            }

chart.data = [<?=$data?>]

<?=$series?>

function arrangeColumns() {

var series = chart.series.getIndex(0);

var w = 1 - xAxis.renderer.cellStartLocation - (1 - xAxis.renderer.cellEndLocation);
                if (series.dataItems.length > 1) {
                    var x0 = xAxis.getX(series.dataItems.getIndex(0), "categoryX");
                    var x1 = xAxis.getX(series.dataItems.getIndex(1), "categoryX");
                    var delta = ((x1 - x0) / chart.series.length) * w;
                    if (am4core.isNumber(delta)) {
                        var middle = chart.series.length / 2;

chart.series.each(function(series) {
                            var trueIndex = chart.series.indexOf(series);
                            var newIndex = series.dummyData;

var dx = (newIndex - trueIndex + middle - newMiddle) * delta

series.animate({ property: "dx", to: dx }, series.interpolationDuration, series.interpolationEasing);
                            series.bulletsContainer.animate({ property: "dx", to: dx }, series.interpolationDuration, series.interpolationEasing);
                        })
                    }
                }
            }

}); // end am4core.ready()
        </script>

<div id="chartdiv" style="width: 100%; height: 500px;"></div>
        <p>&nbsp;</p>
        <div class="w3-margin">
    <?php
        $sql = "SELECT 
                    researcher.*, 
                    faculty.name AS faculty_name 
                    FROM researcher 
                    LEFT JOIN faculty ON (researcher.faculty_id=faculty.id) 
                    WHERE 1 ";
        if ($kw != '') {
            $sql .= " AND(researcher.name LIKE '%".$kw."%') "; 
        }
        $sql .= " ORDER BY CONVERT(researcher.name USING tis620) ASC ";
        $g_db->pagesize = 20;
        $sql = $g_db->createPage($sql);
        $rows = $g_db->getObjects($sql);
    ?>
    <?php
        $g_db->page_url = "researchers.php?page=";
        $g_db->pagination();
    ?>
    <?php
	    $dir_picture = "pics/researcher/";
        for ($i=0; $i<count($rows); $i+=2) {
            $row = $rows[$i];
            $picture = "pics/researcher/".$row->picture;
            if (!is_file($picture)) {
                $picture = "pics/researcher/m0000.png";
            }
    ?>
    <div class="w3-cell-row w3-margin-bottom">
        <div class="w3-padding w3-cell w3-round-large w3-border w3-hover-light-grey" style="width: 49%;">
            <div class="w3-row-padding">
            <div class="w3-third w3-center w3-padding"><a href="researcher_info.php?res_id=<?=$row->id?>"><img src="<?=$picture?>" class="w3-image w3-circle" style="margin-top: -8px;" /></a></div>
                <div class="w3-twothird">
                    <div class="w3-panel"><a href="researcher_info.php?res_id=<?=$row->id?>" class="w3-large ris-link ris-link-hover"><?=$g_db->pageNo($i)?>. <?=$row->tname?> <?=$row->name?></a></div>
                    <div class="w3-panel"><p>สังกัด : <a href="researcher_faculty.php?fac_id=<?=$row->faculty_id?>" class="ris-link ris-link-hover"><?=$row->faculty_name?></a></div>
                    <div class="w3-panel"><p>ความเชี่ยวชาญ : <?=$row->expertise?></div>
                </div>
            </div>
        </div>
    <?php
            $row = $rows[$i+1];
            $picture = "pics/researcher/".$row->picture;
            if (!is_file($picture)) {
                $picture = "pics/researcher/m0000.png";
            }
    ?>
        <div class="w3-padding w3-cell" style="width: 2%;"></div>
        <div class="w3-padding w3-cell w3-round-large w3-border w3-hover-light-grey" style="width: 49%;">
            <div class="w3-row-padding">
                <div class="w3-third w3-center w3-padding"><a href="researcher_info.php?res_id=<?=$row->id?>"><img src="<?=$picture?>" class="w3-image w3-circle" style="margin-top: -8px;" /></a></div>
                <div class="w3-twothird">
                    <div class="w3-panel"><a href="researcher_info.php?res_id=<?=$row->id?>" class="w3-large ris-link ris-link-hover"><?=$g_db->pageNo($i+1)?>. <?=$row->tname?> <?=$row->name?></a></div>
                    <div class="w3-panel"><p>สังกัด : <a href="researcher_faculty.php?fac_id=<?=$row->faculty_id?>" class="ris-link ris-link-hover"><?=$row->faculty_name?></a></div>
                    <div class="w3-panel"><p>ความเชี่ยวชาญ : <?=$row->expertise?></div>
                </div>
            </div>
        </div>
    </div>
    <?php
        }
        
        $g_db->pagination();
    ?>
</div>

<?php
            include("footer.php");
    ?>
</div>
<script>
// Script to open and close sidebar
function w3_open() {
  document.getElementById("mySidebar").style.display = "block";
  document.getElementById("myOverlay").style.display = "block";
}
 
function w3_close() {
  document.getElementById("mySidebar").style.display = "none";
  document.getElementById("myOverlay").style.display = "none";
}

// Modal Image Gallery
function onClick(element) {
  document.getElementById("img01").src = element.src;
  document.getElementById("modal01").style.display = "block";
  var captionText = document.getElementById("caption");
  captionText.innerHTML = element.alt;
}
</script>

</body>
</html>
<?php
    $g_db->close();
?>

${this.title}

Code Editor : researchers.php