| Server IP : 172.67.189.169 / Your IP : 216.73.216.59 Web Server : Apache/2 System : Linux cat167-197.static.lnwhostname.com 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 User : paphayomho ( 1042) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/paphayomho/domains/paphayomhospital.go.th/private_html/km_paphayom/ |
Upload File : |
<?php
include 'db.php';
session_start();
// ดึงข้อมูลข่าวสารล่าสุด 3 ข่าว
$news_res = $conn->query("SELECT * FROM km_news ORDER BY news_date DESC LIMIT 3");
// ดึงกิจกรรมที่กำลังจะมาถึง 3 กิจกรรม
$event_res = $conn->query("SELECT * FROM km_events WHERE event_date >= CURDATE() ORDER BY event_date ASC LIMIT 3");
// ดึงความรู้ยอดนิยม 4 อันดับ
$pop_res = $conn->query("SELECT d.*, c.cat_code FROM km_documents d JOIN ha_categories c ON d.cat_id = c.cat_id ORDER BY view_count DESC LIMIT 4");
// ฟังก์ชันสำหรับเช็คประเภทไฟล์เพื่อแสดง Icon หรือ Image
function getFilePreview($file_url) {
$ext = strtolower(pathinfo($file_url, PATHINFO_EXTENSION));
$img_exts = ['jpg', 'jpeg', 'png', 'gif'];
if (in_array($ext, $img_exts)) {
return '<img src="uploads/'.$file_url.'" class="card-img-top p-2" style="height: 180px; object-fit: cover; border-radius: 20px;">';
} else {
$icon = "fa-file-alt text-secondary";
if ($ext == 'pdf') $icon = "fa-file-pdf text-danger";
elseif (in_array($ext, ['doc', 'docx'])) $icon = "fa-file-word text-primary";
elseif (in_array($ext, ['xls', 'xlsx'])) $icon = "fa-file-excel text-success";
elseif (in_array($ext, ['ppt', 'pptx'])) $icon = "fa-file-powerpoint text-warning";
return '<div class="text-center py-4 bg-light" style="height: 180px; border-radius: 15px 15px 0 0; display: flex; align-items: center; justify-content: center;">
<i class="fas '.$icon.' fa-4x"></i>
</div>';
}
}
?>
<!DOCTYPE html>
<html lang="th">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>KM Portal - โรงพยาบาลป่าพะยอม</title>
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<link href="https://fonts.googleapis.com/css2?family=Sarabun:wght@300;400;700&display=swap" rel="stylesheet">
<style>
:root {
--primary-blue: #0056b3;
--deep-blue: #003d82;
--soft-bg: #f8fbff;
--accent-green: #28a745;
}
body { background-color: var(--soft-bg); font-family: 'Sarabun', sans-serif; color: #444; }
.navbar { transition: 0.3s; padding: 1rem 0; }
.hero-section {
background: linear-gradient(135deg, var(--deep-blue) 0%, var(--primary-blue) 100%);
color: white;
padding: 100px 0 80px;
border-radius: 0 0 10% 10% / 30px;
box-shadow: 0 10px 30px rgba(0,86,179,0.2);
}
.search-container { margin-top: -45px; z-index: 10; position: relative; }
.search-card { border: none; border-radius: 50px; box-shadow: 0 15px 35px rgba(0,0,0,0.1); }
.card-custom {
border: none;
border-radius: 20px;
background: #fff;
transition: all 0.3s cubic-bezier(.25,.8,.25,1);
overflow: hidden;
}
.card-custom:hover { transform: translateY(-10px); box-shadow: 0 20px 40px rgba(0,0,0,0.1); }
.section-title { position: relative; padding-left: 15px; margin-bottom: 25px; font-weight: 700; color: var(--deep-blue); }
.section-title::before { content: ''; position: absolute; left: 0; top: 5px; height: 20px; width: 5px; background: var(--primary-blue); border-radius: 10px; }
.news-link { text-decoration: none; color: inherit; display: block; padding: 12px; border-radius: 12px; }
.news-link:hover { background: #f0f7ff; color: var(--primary-blue); }
.cat-icon-box {
width: 70px; height: 70px; background: #eef5ff; color: var(--primary-blue); border-radius: 50%;
display: flex; align-items: center; justify-content: center; margin: 0 auto 15px; font-size: 1.8rem;
}
.footer { background: #fff; padding: 40px 0; margin-top: 80px; border-top: 1px solid #eee; }
</style>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-transparent position-absolute w-100">
<div class="container">
<a class="navbar-brand fw-bold" href="home.php"><i class="fas fa-hand-holding-medical me-2"></i>KM PAPHAYOM</a>
<div class="ms-auto">
<?php if(isset($_SESSION['user_id'])): ?>
<div class="dropdown">
<button class="btn btn-light rounded-pill dropdown-toggle shadow-sm px-4" data-bs-toggle="dropdown">
<i class="fas fa-user-circle me-1"></i> <?php echo $_SESSION['name']; ?>
</button>
<ul class="dropdown-menu dropdown-menu-end shadow-lg border-0 mt-2">
<li><a class="dropdown-item py-2" href="admin_panel.php"><i class="fas fa-tasks me-2"></i>จัดการคลังความรู้</a></li>
<li><hr class="dropdown-divider"></li>
<li><a class="dropdown-item py-2 text-danger" href="logout.php"><i class="fas fa-sign-out-alt me-2"></i>ออกจากระบบ</a></li>
</ul>
</div>
<?php else: ?>
<a href="login.php" class="btn btn-outline-light rounded-pill px-4 shadow-sm">เข้าสู่ระบบ</a>
<?php endif; ?>
</div>
</div>
</nav>
<header class="hero-section text-center">
<div class="container mt-4">
<h1 class="display-4 fw-bold mb-3">ระบบจัดการความรู้(KM) โรงพยาบาลป่าพะยอม</h1>
<p class="lead opacity-75 fw-light">แลกเปลี่ยน เรียนรู้ ร่วมพัฒนา สู่มาตรฐาน HA อย่างยั่งยืน</p>
</div>
</header>
<div class="container search-container">
<div class="row justify-content-center">
<div class="col-lg-8">
<div class="card search-card">
<div class="card-body p-2">
<form action="index.php" method="GET" class="d-flex align-items-center">
<i class="fas fa-search text-muted ms-4"></i>
<input type="text" name="q" class="form-control border-0 fs-5 ps-3 shadow-none" placeholder="ค้นหาคู่มือ CPG, แนวทางปฏิบัติ, หรือผลงาน R2R...">
<button class="btn btn-primary rounded-pill px-5 py-2 me-1 shadow-sm">ค้นหา</button>
</form>
</div>
</div>
</div>
</div>
</div>
<main class="container mt-5 pt-4">
<div class="row g-4 mb-5">
<div class="col-lg-7">
<h5 class="section-title">ข่าวสารประชาสัมพันธ์</h5>
<div class="card card-custom shadow-sm h-100 p-3">
<div class="card-body">
<?php if($news_res->num_rows > 0): ?>
<?php while($news = $news_res->fetch_assoc()): ?>
<a href="#" class="news-link">
<span class="badge bg-soft-primary text-primary mb-1" style="font-size: 0.7rem;"><?php echo date('d M Y', strtotime($news['news_date'])); ?></span>
<h6 class="mb-1 fw-bold"><?php echo $news['news_title']; ?></h6>
<p class="text-muted small mb-0 text-truncate">อัปเดตความเคลื่อนไหวกิจกรรมคุณภาพและมาตรฐาน HA...</p>
</a>
<hr class="opacity-50">
<?php endwhile; ?>
<?php else: ?>
<div class="text-center py-4 text-muted">ไม่มีข่าวประกาศ</div>
<?php endif; ?>
</div>
</div>
</div>
<div class="col-lg-5">
<h5 class="section-title text-success">ปฏิทินกิจกรรม KM</h5>
<div class="card card-custom shadow-sm h-100 p-3 border-top border-success border-4">
<div class="card-body">
<?php if($event_res->num_rows > 0): ?>
<?php while($ev = $event_res->fetch_assoc()): ?>
<div class="d-flex align-items-start mb-4">
<div class="bg-success text-white rounded p-2 text-center me-3 shadow-sm" style="min-width: 60px;">
<div class="small text-uppercase" style="font-size: 0.6rem;"><?php echo date('M', strtotime($ev['event_date'])); ?></div>
<div class="h4 mb-0 fw-bold"><?php echo date('d', strtotime($ev['event_date'])); ?></div>
</div>
<div>
<h6 class="mb-1 fw-bold"><?php echo $ev['event_name']; ?></h6>
<small class="text-muted"><i class="far fa-clock me-1"></i> <?php echo date('H:i', strtotime($ev['event_time'])); ?> น.</small>
</div>
</div>
<?php endwhile; ?>
<?php else: ?>
<div class="text-center py-4 text-muted">ไม่มีกิจกรรมที่กำลังจะมาถึง</div>
<?php endif; ?>
</div>
</div>
</div>
</div>
<div class="d-flex justify-content-between align-items-end mb-4">
<h5 class="section-title mb-0">ผลงานแนะนำ / ยอดนิยม</h5>
<a href="index.php" class="text-primary text-decoration-none small fw-bold">ดูทั้งหมด <i class="fas fa-arrow-right"></i></a>
</div>
<div class="row g-4 mb-5">
<?php while($pop = $pop_res->fetch_assoc()): ?>
<div class="col-md-6 col-lg-3">
<div class="card card-custom shadow-sm h-100 border-0">
<?php echo getFilePreview($pop['file_url']); ?>
<div class="card-body p-4 d-flex flex-column">
<span class="badge bg-light text-primary mb-2 align-self-start border border-primary"><?php echo $pop['cat_code']; ?></span>
<h6 class="fw-bold text-dark lh-base mb-3" style="min-height: 2.5rem;"><?php echo $pop['doc_title']; ?></h6>
<div class="mt-auto d-flex justify-content-between align-items-center border-top pt-3">
<small class="text-muted"><i class="far fa-eye me-1"></i> <?php echo $pop['view_count']; ?> ครั้ง</small>
<a href="uploads/<?php echo $pop['file_url']; ?>" target="_blank" class="btn btn-primary btn-sm rounded-pill px-3">เปิดดูไฟล์</a>
</div>
</div>
</div>
</div>
<?php endwhile; ?>
</div>
<h5 class="section-title mb-4">หมวดหมู่มาตรฐาน HA</h5>
<div class="row g-3 text-center mb-5">
<?php
$cats = $conn->query("SELECT * FROM ha_categories");
while($c = $cats->fetch_assoc()):
$icon = "fa-folder";
if($c['cat_code'] == 'PCT') $icon = "fa-user-md";
elseif($c['cat_code'] == 'ENV') $icon = "fa-tools";
elseif($c['cat_code'] == 'MED') $icon = "fa-pills";
elseif($c['cat_code'] == 'IC') $icon = "fa-virus-slash";
elseif($c['cat_code'] == 'R2R') $icon = "fa-microscope";
?>
<div class="col-6 col-md-4 col-lg-2">
<a href="index.php?cat=<?php echo $c['cat_id']; ?>" class="text-decoration-none">
<div class="card h-100 card-custom shadow-sm p-4 py-4">
<div class="cat-icon-box">
<i class="fas <?php echo $icon; ?>"></i>
</div>
<div class="fw-bold text-dark mb-1"><?php echo $c['cat_code']; ?></div>
<div class="text-muted x-small" style="font-size: 0.7rem;"><?php echo $c['cat_name_th']; ?></div>
</div>
</a>
</div>
<?php endwhile; ?>
</div>
</main>
<footer class="footer">
<div class="container text-center">
<h5 class="fw-bold text-primary mb-3"><i class="fas fa-hospital-symbol"></i> KM PAPHAYOM</h5>
<p class="text-muted small mb-1">ศูนย์จัดการความรู้ โรงพยาบาลป่าพะยอม จ.พัทลุง</p>
<p class="text-muted" style="font-size: 0.7rem;">© 2026 สงวนลิขสิทธิ์ตามมาตรฐาน HA (Hospital Accreditation)</p>
</div>
</footer>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>