001.<!doctype html>
002.<html lang="en">
003. <head>
004. <!-- Required meta tags -->
005. <meta charset="utf-8">
006. <meta name="viewport" content="width=device-width, initial-scale=1">
007.
008. <!-- Bootstrap CSS -->
010.
011. <title>TSU EVENT</title>
012. </head>
013. <body>
014.
015.
016. <script>
017. var initialGid = '<?php echo $gid; ?>';
018. var initialEid = '<?php echo $eid; ?>';
019. var initialStartDate = '<?php echo $start_date; ?>';
020. var initialEndDate = '<?php echo $end_date; ?>';
021.
022. function submitFormOnChange() {
023. var gid = document.getElementById("gid").value || initialGid;
024. var eid = document.getElementById("eid").value || initialEid;
025. var start_date = document.getElementById("start_date").value || initialStartDate;
026. var end_date = document.getElementById("end_date").value || initialEndDate;
027.
028. var url = "index2.php?gid=" + gid + "&eid=" + eid + "&start_date=" + start_date + "&end_date=" + end_date;
029. window.location.href = url;
030. }
031. </script>
032.
033. <!-- เลือกหน่วยงาน -->
034. <label>เลือกหน่วยงาน:</label>
035. <select name="gid" id="gid" onchange="submitFormOnChange()">
036. <option value="">เลือกหน่วยงาน</option>
037. <?php
038. $sql = "SELECT gid, cat_name FROM event_cat Wheew";
039. $result = $conn->query($sql);
040. if ($result->num_rows > 0) {
041. while($row1 = $result->fetch_assoc()) {
042. echo "<option value='".$row1["gid"]."'>".$row1["cat_name"]."</option>";
043. }
044. } else {
045. echo "<option value=''>ไม่พบหน่วยงาน</option>";
046. }
047. ?>
048. </select>
049.
050. <!-- เลือกประเภทโครงการ -->
051. <label>เลือกประเภท project:</label>
052. <select name="eid" id="eid" onchange="submitFormOnChange()">
053. <option value="">เลือก project</option>
054. <?php
055. $sql = "SELECT ide, eid FROM project";
056. $result = $conn->query($sql);
057. if ($result->num_rows > 0) {
058. while($row1 = $result->fetch_assoc()) {
059. echo "<option value='".$row1["eid"]."'>".$row1["eid"]."</option>";
060. }
061. } else {
062. echo "<option value=''>ไม่พบ project</option>";
063. }
064. ?>
065. </select>
066.
067. <label for="start_date">เริ่มต้น:</label>
068. <input type="date" id="start_date" name="start_date" value="" onchange="submitFormOnChange()">
069.
070. <label for="end_date">สิ้นสุด:</label>
071. <input type="date" id="end_date" name="end_date" value="" onchange="submitFormOnChange()">
072.
073.<?php
074. $gid = isset($_GET['gid']) ? $_GET['gid'] : '';
075. $eid = isset($_GET['eid']) ? $_GET['eid'] : '';
076. $start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
077. $end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
078.
079.
080.
081.$sql = "SELECT * FROM event";
082.$conditions = [];
083.
084.if ($gid != '') {
085. $conditions[] = "gid = '$gid'";
086.}
087.if ($eid != '') {
088. $conditions[] = "eid = '$eid'";
089.}
090.if ($start_date != '' && $end_date != '') {
091. $conditions[] = "start BETWEEN '$start_date' AND '$end_date'";
092.
093.}
094.
095.if (count($conditions) > 0) {
096. $sql .= " WHERE " . implode(' AND ', $conditions);
097.}
098.
099.$result = $conn->query($sql);
100.
101.
102.if ($result->num_rows > 0) {
103. echo '<div class="container">';
104. echo '<div class="row">';
105.
106. while($row = $result->fetch_assoc()) {
107. echo '<div class="col-md-4">';
108. echo ' <div class="card my-3">';
109. echo ' <div class="card-body">';
110. echo ' <h5 class="card-title">' . $row['b_topic'] . '</h5>';
111. echo ' <p class="card-text">' . $row['eid'] . '</p>';
112. echo ' <a href="../detail.php?aNum=' . $row['b_num'] . '&id=' . $row['id'] . '&gid=' . $row['gid'] . '" class="btn btn-primary">ดูรายละเอียด</a>';
113. echo ' </div>';
114. echo ' </div>';
115. echo '</div>';
116. }
117. echo '</div>';
118. echo '</div>';
119.} else {
120. echo "<p>ไม่พบข้อมูล</p>";
121.}
122.?>
123.
124. <!-- Optional JavaScript -->
125. <!-- jQuery first, then Popper.js, then Bootstrap JS -->
129. </body>
130.</html>
