--- fenglin/bbs/section_setting.php 2025/04/08 11:23:00 1.2 +++ fenglin/bbs/section_setting.php 2025/04/09 04:10:57 1.3 @@ -24,6 +24,7 @@ exit(json_encode($result_set)); } + // Load section setting $sql = "SELECT * FROM section_config WHERE SID = $sid AND enable"; $rs = mysqli_query($db_conn, $sql); @@ -36,7 +37,7 @@ exit(json_encode($result_set)); } - if($row = mysqli_fetch_array($rs)) + if ($row = mysqli_fetch_array($rs)) { $result_set["data"] = array( "sid" => $sid, @@ -44,6 +45,7 @@ "comment" => $row["comment"], "ex_update" => $row["ex_update"], "section_hierachy" => array(), + "masters" => array(), ); } else @@ -57,6 +59,34 @@ mysqli_free_result($rs); + // Load section master + $sql = "SELECT section_master.UID, username, major, begin_dt, end_dt FROM section_master + INNER JOIN user_list ON section_master.UID = user_list.UID + WHERE SID = $sid AND section_master.enable AND (NOW() BETWEEN begin_dt AND end_dt) + ORDER BY major DESC, begin_dt ASC, end_dt ASC"; + + $rs = mysqli_query($db_conn, $sql); + if ($rs == false) + { + $result_set["return"]["code"] = -2; + $result_set["return"]["message"] = "Query section master error: " . mysqli_error($db_conn); + + mysqli_close($db_conn); + exit(json_encode($result_set)); + } + + while ($row = mysqli_fetch_array($rs)) + { + array_push($result_set["data"]["masters"], array( + "uid" => $row["UID"], + "username" => $row["username"], + "major" => $row["major"], + "begin_dt" => $row["begin_dt"], + "end_dt" => $row["end_dt"], + )); + } + mysqli_free_result($rs); + // Load section list $sql = "SELECT SID, section_config.CID, section_config.title AS s_title, section_class.title AS c_title FROM section_config INNER JOIN section_class ON section_config.CID = section_class.CID