| Server IP : 103.233.192.212 / Your IP : 3.149.230.234 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/domains/sumpatuan.go.th/public_html/main/ |
Upload File : |
<?php require_once('db_main.php'); ?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="bg-all animated fadeIn faster ">
<?php include_once ("chatfacebook.php"); ?>
<div class="container-fluid p-0 " >
<div class="container bg-main fix-page mb-0 pb-0" >
<?php include_once ("menu.php"); ?>
</div>
<!------ data ------>
<div class="container bg-white fix-page mt-0 " id="data">
<div class="row">
<div class="col bg-cl-0 fcl-cl-1 bg-txt-head text-center">
วารสารหน่วยงาน
</div>
<div class="w-100"></div>
<div class="col text-secondary p-0" >
<div class="ps-4 p-2 box-link fw-300" >
<a href="subEService#data" class="link-danger fw-500">E-service</a> > วารสารหน่วยงาน
</div>
</div>
<div class="w-100"></div>
<div class="col p-5 pt-2 pb-2 fw-500">
<?php
$sql_cdata = "SELECT COUNT(*) FROM `data_subfile` WHERE `type_subfile`='วารสารหน่วยงาน' AND `stt_subfile`=0 ";
$qr_cdata = mysqli_query($con_db_main, $sql_cdata) or trigger_error("SQL", E_USER_ERROR);
$rs_cdata = mysqli_fetch_row($qr_cdata);
$numrows = $rs_cdata[0];
$rowsperpage = 10;
$totalpages = ceil($numrows / $rowsperpage);
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
$currentpage = (int) $_GET['currentpage'];
} else {
$currentpage = 1;
}
if ($currentpage > $totalpages) {
$currentpage = $totalpages;
}
if ($currentpage < 1) {
$currentpage = 1;
}
$offset = ($currentpage - 1) * $rowsperpage;
$sql_data = "SELECT * FROM `data_subfile` WHERE `type_subfile`='วารสารหน่วยงาน' AND `stt_subfile`=0 ORDER BY str_to_date(`lastupdate_subfile`,'%d/%m/%Y') DESC , `id_subfile` DESC LIMIT $offset, $rowsperpage ";
$qr_data = mysqli_query($con_db_main,$sql_data) or die( mysqli_error($con_db_main));
while($rs_data = mysqli_fetch_array($qr_data)){
$id_subfile=$rs_data['id_subfile'];
$type_subfile=$rs_data['type_subfile'];
echo '<div class="w-100 border-bottom pb-3 pt-3">
<div class="fw-500 fs-20">'.$rs_data['name_subfile'].'</div>';
$sql_data_filedoc = "SELECT * FROM `data_filedoc_subfile` WHERE `id_tbdata_filedoc_subfile`='$id_subfile' AND `tbdata_filedoc_subfile`='$type_subfile' ";
$qr_data_filedoc = mysqli_query($con_db_main,$sql_data_filedoc) or die( mysqli_error($con_db_main));
while($rs_data_filedoc = mysqli_fetch_array($qr_data_filedoc)){
echo '<div class="w-100 fw-300"><a target="_blank" href="../'.$rs_data_filedoc['path_filedoc_subfile'].'"class="ms-4 link-danger"><small class="text-secondary fs-14">ไฟล์เอกสาร</small> <i class="fas fa-download ms-2 me-1"></i> '.$rs_data_filedoc['name_filedoc_subfile'].'</a></div>';
}
echo '</div>';
}
?>
<?php
if($numrows == 0){
echo '<div class="w-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-20 fw-500" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>วารสารหน่วยงาน</div>';
}
?>
<!------------- NUMBER PAGE ------------->
<div class="mt-4 fs-12 w-100 text-secondary clearfix fw-300">
<div class="float-start lh-sm">
แสดงข้อมูลตั้งแต่ 1 ถึง 10 <br>จากข้อมูลทั้งหมด <?php echo $numrows; ?> ข้อมูล
</div>
<div class="float-end">
<div aria-label="Page navigation">
<ul class="pagination pagination-sm justify-content-end">
<?php
$range = 5;
if ($currentpage > 1) {
echo " <li class='page-item'>
<a class='page-link focus-ring focus-ring-secondary text-black-50' href='{$_SERVER['PHP_SELF']}?currentpage=1' aria-label='Previous'>
<i class='fas fa-angle-double-left'></i>
</a>
</li>";
$prevpage = $currentpage - 1;
echo "<li class='page-item'>
<a class='page-link focus-ring focus-ring-secondary text-black-50' href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage' aria-label='Previous'>
<i class='fas fa-angle-left'></i>
</a>
</li>";
}
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
if (($x > 0) && ($x <= $totalpages)) {
if ($x == $currentpage) {
echo "<li class='page-item active' aria-current='page'>
<a class='page-link focus-ring focus-ring-secondary text-bg-secondary' href='#'>$x <span class='sr-only'>(current)</span></a>
</li> ";
} else {
echo " <li class='page-item'><a class='page-link focus-ring focus-ring-secondary text-black-50' href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a></li>";
}
}
}
if ($currentpage != $totalpages) {
$nextpage = $currentpage + 1;
echo "<li class='page-item'>
<a class='page-link focus-ring focus-ring-secondary text-black-50' href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage' aria-label='Next'>
<i class='fas fa-angle-right'></i>
</a>
</li>";
echo "<li class='page-item'>
<a class='page-link focus-ring focus-ring-secondary text-black-50' href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages' aria-label='Next'>
<i class='fas fa-angle-double-right'></i>
</a>
</li>";
}
?>
</ul>
</div>
</div>
</div>
<!--------------------------------------->
</div>
<div class="w-100"></div>
<div class="col bg-cl-2 text-center fcl-cl-1 fs-1" style="height:10px;"></div>
</div>
</div>
<!------------------>
<?php include_once ("footer.php"); ?>
</div>
<?php include_once ("cookie.php"); ?>
</body>
</html>