<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include("config/db_config.php");
include("config/sql_commandPHP7.php");
include("config/const.php");
db_connect();
session_start();

$keywrd = isset($_POST['keywrd']) ? addslashes($_POST['keywrd']) : '';
$enr = isset($_GET['enr']) ? addslashes($_GET['enr']) : '';
$py = isset($_GET['py']) ? addslashes($_GET['py']) : '';
$realsubmit = time();
$showtm = date("Y-m-d H:i:s", $realsubmit);

function get_profile($PID)
{
    $PID = intval($PID);
    $sql = "SELECT * FROM cr_profile WHERE user_id={$PID} AND del_flag=0";
    $query = db_query($sql);
    return db_fetch_array($query);
}

function get_classes($realsubmit, $keywrd)
{
    if ($keywrd == "") {
        $sql = "SELECT * FROM cr_class WHERE del_flag=0 AND IS_OPEN='Y' ORDER BY course_id, enrol_start";
    } else {
        $kw = addslashes($keywrd);
        $sql = "SELECT * FROM cr_class WHERE class_name LIKE '%{$kw}%' AND del_flag=0 AND IS_OPEN='Y' ORDER BY course_id, enrol_start";
    }
    return db_query($sql);
}

function get_cat($class_id)
{
    $class_id = intval($class_id);
    $sql = "SELECT cr_course_category.cat_name FROM cr_course_category 
            JOIN cr_course ON cr_course_category.cat_id = cr_course.cat_id
            JOIN cr_class ON cr_course.course_id = cr_class.course_id AND cr_class.class_id={$class_id}";
    $query = db_query($sql);
    $res = db_fetch_array($query);
    return isset($res['cat_name']) ? $res['cat_name'] : '';
}

function get_enrol($class_id, $user_id)
{
    $class_id = intval($class_id);
    $user_id = intval($user_id);
    $sql = "SELECT * FROM cr_enrol WHERE class_id={$class_id} AND user_id={$user_id} AND del_flag=0";
    $query = db_query($sql);
    return db_fetch_array($query);
}

function get_estatus($enrol_sts)
{
    $enrol_sts = intval($enrol_sts);
    $sql = "SELECT enrol_status FROM cr_enrol_status WHERE enrol_sid={$enrol_sts} AND del_flag=0";
    $query = db_query($sql);
    $res = db_fetch_array($query);
    return isset($res['enrol_status']) ? $res['enrol_status'] : '';
}

function get_pstatus($payment_sts)
{
    $payment_sts = intval($payment_sts);
    $sql = "SELECT payment_status FROM cr_payment_status WHERE payment_sid={$payment_sts} AND del_flag=0";
    $query = db_query($sql);
    $res = db_fetch_array($query);
    return isset($res['payment_status']) ? $res['payment_status'] : '';
}

function get_course($class_id)
{
    $class_id = intval($class_id);
    $sql = "SELECT course_id FROM cr_class WHERE class_id={$class_id} AND del_flag=0";
    $query = db_query($sql);
    $res = db_fetch_array($query);

    $cid = isset($res['course_id']) ? intval($res['course_id']) : 0;
    $sql2 = "SELECT * FROM cr_course WHERE course_id={$cid} AND del_flag=0";
    $query2 = db_query($sql2);
    return db_fetch_array($query2);
}
?>
<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="G-Gratitude Co.,Ltd.">
    <meta name="generator" content="Hugo 0.87.0">
    <title>RRU Credit Bank</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <link rel="canonical" href="https://getbootstrap.com/docs/5.1/examples/album/">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/style.css" type="text/css" rel="stylesheet">
    <link href="css/index-style.css" type="text/css" rel="stylesheet">
</head>

<body>
    <?php include("header.php"); ?>
    <main>
        <!-- Modal ประกาศ -->
        <div id="simpleModal" class="modal fade" role="dialog">
            <div class="modal-dialog modal-dialog-centered" role="document">
                <div class="modal-content">
                    <div class="modal-header border-0 pb-0">
                        <h6 class="col-12 modal-title">แจ้งผู้สมัครเข้าร่วมการอบรม
                            <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </h6>
                    </div>
                    <div class="modal-body">
                        <p class="text-center">
                            ขอความอนุเคราะห์ผู้สมัครที่ลงทะเบียนเข้าร่วมการอบรมแล้วทุกท่านเข้าร่วมไลน์กลุ่ม<br><img
                                src="line_group.jpg" class="img-fluid rounded-3 shadow-sm" alt="LINE group"><br><a
                                href="https://line.me/R/ti/g/cqT6uYFjj4">https://line.me/R/ti/g/cqT6uYFjj4</a></p>
                    </div>
                    <div class="modal-footer border-0 pt-0">
                        <button type="button" class="btn btn-secondary btn-block" data-bs-dismiss="modal">ปิด</button>
                    </div>
                </div>
            </div>
        </div>
        <!-- Modal ประกาศ -->

        <div class="py-5">
            <div class="container">
                <div style="padding:4px;" class="text-center mb-4 text-light">
                    <h3 class="section-title mb-0">ระบบจัดการหลักสูตรระยะสั้นและคลังหน่วยกิต</h3>
                    <div class="text-light">มหาวิทยาลัยราชภัฏราชนครินทร์</div>
                </div>
                <?php
                if ($enr == "f") {
                    ?>
                    <div class="alert alert-danger alert-dismissible fade show">
                        <button type="button" class="close" data-bs-dismiss="alert">&times;</button>
                        <strong>ผิดพลาด !</strong> ไม่สามารถลงทะเบียนได้, โปรดลองใหม่อีกครั้ง<br>

                    </div>
                    <?php
                } elseif ($enr == "c") {
                    ?>
                    <div class="alert alert-success alert-dismissible">
                        <button type="button" class="close" data-bs-dismiss="alert">&times;</button>
                        <strong>สำเร็จ !</strong> ลงทะเบียนเรียบร้อยแล้ว
                        <!--, กรุณา <a href="view_enrol.php?u=<?php //echo $res_prof[user_id]; ?>">ตรวจสอบสถานะการลงทะเบียน</a><br> -->
                        <!--<strong>Success !</strong> Enrol completed, please <a href="view_enrol.php?u=<?php //echo $res_prof[user_id]; ?>">check your status</a>.-->
                    </div>
                    <?php
                }
                ?>
                <?php
                if ($py == "f") {
                    ?>
                    <div class="alert alert-danger alert-dismissible fade show">
                        <button type="button" class="close" data-bs-dismiss="alert">&times;</button>
                        <strong>ผิดพลาด !</strong> ไม่สามารถส่งหลักฐานการชำระเงินได้, โปรดลองใหม่อีกครั้ง<br>
                    </div>
                    <?php
                } elseif ($py == "c") {
                    ?>
                    <div class="alert alert-success alert-dismissible">
                        <button type="button" class="close" data-bs-dismiss="alert">&times;</button>
                        <strong>สำเร็จ !</strong> ส่งหลักฐานการชำระเงินเรียบร้อยแล้ว
                        <!--, กรุณา <a href="view_enrol.php?u=<?php //echo $res_prof[user_id]; ?>">ตรวจสอบสถานะการลงทะเบียน</a><br>-->
                        <!--<strong>Success !</strong> Enrol completed, please <a href="view_enrol.php?u=<?php //echo $res_prof[user_id]; ?>">check your status</a>.-->
                    </div>
                    <?php
                }
                ?>

                <form name="search" action="index.php" method="post">
                    <!-- <div class="mb-3 col-md-12 hidden">
                        <input type="text" name="keywrd" value="<?php //echo $keywrd; ?>"> 
                        <input type="submit" value="ค้นหาวิชา">
                    </div> -->
                    <div class="row row-cols-1 row-cols-sm-2 row-cols-md-3 g-3">
                        <?php
                        $q_class = get_classes($realsubmit, $keywrd);
                        $num_class = db_num_rows($q_class);
                        if ($num_class > 0) {
                            for ($nc = 1; $nc <= $num_class; $nc++) {
                                $res_class = db_fetch_array($q_class);
                                $res_course = get_course($res_class['class_id']);
                                ?>
                                <!-- START SHOW CLASS -->

                                <div class="col">
                                    <div class="card shadow-sm"><a href="view_class.php?u=<?php echo $res_class['class_id']; ?>">
                                            <?php
                                            if ($res_class['class_cover'] != NULL) {
                                                ?>
                                                <img src="<?php echo $res_class['class_cover']; ?>" width="100%" height="225">
                                                <?php
                                            } else {
                                                ?>
                                                <svg class="bd-placeholder-img card-img-top" width="100%" height="225"
                                                    xmlns="http://www.w3.org/2000/svg" role="img"
                                                    aria-label="Placeholder: Thumbnail" preserveAspectRatio="xMidYMid slice"
                                                    focusable="false">
                                                    <title>Placeholder</title>
                                                    <rect width="100%" height="100%" fill="#55595c" /><text x="50%" y="50%"
                                                        fill="#eceeef" dy=".3em">Thumbnail</text>
                                                </svg>
                                                <?php
                                            }
                                            ?></a>

                                        <div class="card-body">
                                            <p class="card-text"><a
                                                    href="view_class.php?u=<?php echo $res_class['class_id']; ?>"><?php echo $res_class['class_name']; ?>
                                                    (ดูรายละเอียด)</a><br>
                                                <?php
                                                echo "ชุดวิชา : <strong>" . get_cat($res_class['class_id']) . "</strong><br>";
                                                ?>
                                                <?php echo "คุณสมบัติผู้ลงทะเบียน : <strong>" . $res_course['applicant_qualify']; ?></strong><br>
                                                <?php
                                                if ($res_class['class_fee'] != 0) {
                                                    echo "ค่าธรรมเนียม : <strong>" . number_format($res_class['class_fee']) . "</strong> บาท<br>";
                                                } else {
                                                    echo "ค่าธรรมเนียม : <strong>ไม่มีค่าใช้จ่าย</strong><br>";
                                                }
                                                $st = date_create($res_class['class_start']);
                                                $en = date_create($res_class['class_end']);

                                                echo "เริ่มเรียน : <strong>" . date_format($st, "d/m/Y (H:i น.)") . "</strong> <br>สิ้นสุด : <strong>" . date_format($en, "d/m/Y (H:i น.)"); ?></strong>
                                                <br><?php echo "สถานที่ : <strong>" . $res_class['class_location']; ?></strong>
                                            </p>
                                            <!-- ENROL -->
                                            <div class="d-flex justify-content-between align-items-center">
                                                <div class="btn-group">
                                                    <?php
                                                    if (isset($_SESSION["PID"]) && $_SESSION["PID"] != null) {
                                                        $res_enrol = get_enrol($res_class['class_id'], $_SESSION["PID"]);
                                                        $enrol_sts = $res_enrol['enrol_status'];
                                                        $res_sts = get_estatus($enrol_sts);
                                                        if ($enrol_sts != 0) {
                                                            if ($enrol_sts == 1) {
                                                                echo "<font color='#FF6600'>" ."คุณสมบัติ: ".$res_sts . "</font>";
                                                            }//orange
                                                            elseif ($enrol_sts == 2) {
                                                                echo "<font color='#009933'>" ."คุณสมบัติ: ". $res_sts . "</font>";
                                                            }//green
                                                            elseif ($enrol_sts == 3) {
                                                                echo "<font color='#CC0000'>" ."คุณสมบัติ: ". $res_sts . "</font>";
                                                            }//red
                                                            else {
                                                                echo $res_sts;
                                                            }
                                                        } else {
                                                            if (($realsubmit > $res_class['enrol_start_tm'] AND $res_class['enrol_end_tm'] > $realsubmit)) {//อยู่ในช่วงลงทะเบียน
                                                                echo "<a href='enrol.php?CID=$res_class[class_id]'><button type='button' class='btn btn-sm btn-outline-secondary'>ลงทะเบียน</button></a>";
                                                            } else {
                                                                echo "<font color='#FF6600'>รอเปิดการลงทะเบียน</font>";
                                                            }

                                                            ?>
                                                            <!--<a href="enrol.php?CID=<?php //echo $res_class['class_id'] ?>"><button type="button" class="btn btn-sm btn-outline-secondary">ลงทะเบียน</button></a>-->
                                                            <?php
                                                        }
                                                    } else {
                                                        ?>
                                                        <a href="signin.php"><button type="button"
                                                                class="btn btn-sm btn-outline-secondary">ลงทะเบียน</button></a>
                                                    <?php
                                                    }
                                                    ?>
                                                </div>
                                                <!-- PAYMENT -->
                                                <?php
                                                if ($res_class['class_fee'] != 0) {
                                                    ?>
                                                    <div class="btn-group">
                                                        <?php
                                                        $pay_sts = $res_enrol['pay_status'];
                                                        $pstatus = get_pstatus($pay_sts);
                                                        if (($enrol_sts == 1) || ($enrol_sts == 2)) {//From Upper
                                                            if ($pay_sts == 1) {
                                                                ?>
                                                                <a href="pay.php?CID=<?php echo $res_class['class_id'] ?>"><button
                                                                        type="button"
                                                                        class="btn btn-sm btn-outline-secondary">ส่งหลักฐานการชำระเงิน</button></a>
                                                                <?php
                                                            } elseif ($pay_sts == 2) {
                                                                echo "<font color='#FF6600'>"  ."การชำระเงิน: ".$pstatus . "</font>";
                                                            }//orange
                                                        }
                                                        if ($pay_sts == 3) {
                                                            echo "<font color='#009933'>" ."การชำระเงิน: ".$pstatus . "</font>";
                                                        }//green
                                                        if ($pay_sts == 4) {
                                                            echo "<font color='#CC0000'>"  ."การชำระเงิน: ".$pstatus . "</font>";
                                                        }//red
                                                        //}
                                                        //}
                                                        ?>
                                                    </div>
                                                    <?php
                                                }
                                                ?>

                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <!-- END SHOW CLASS -->
                                <?php
                            }
                        }
                        ?>

                    </div>
                </form>
            </div>
        </div>
        </div>
    </main>
    <div class="container">
        <?php include("footer.php"); ?>
    </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
    <script type="text/javascript">
        // window.onload = function () {
        //     OpenPopup();
        // };
        function OpenPopup() {
            var el = document.getElementById('simpleModal');
            if (!el) return;
            var modal = bootstrap.Modal.getOrCreateInstance(el);
            modal.show();
        }
        function ClosePopup() {
            var el = document.getElementById('simpleModal');
            if (!el) return;
            var modal = bootstrap.Modal.getOrCreateInstance(el);
            modal.hide();
        }
    </script>
</body>

</html>