} $return_string = $return_string . ">" . "<table id=\"search_table\" class=\"report\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" . "<colgroup>" . "<col class=\"num\"/>" . "<col class=\"ExamName\"/>" . "<col class=\"ExamType\"/>" . "<col class=\"ExamStatus\"/>" . "<col class=\"ExamPassword\"/>" . "<col class=\"CreatedUser\"/>" . "<col class=\"CreatedTime\"/>" . "<col class=\"ExamEnd\"/>" . "<col class=\"ExamsAction\"/>" . "</colgroup>" . "<tr>" . "<th>编号</th>" . "<th>名称</th>" . "<th>类型</th>" . "<th>状态</th>" . "<th>密码</th>" . "<th>创建人</th>" . "<th>创建时间</th>" . "<th>最后截止日期</th>" . "<th>动作</th>" . "</tr>"; } if ($page_count < $page_size) { $row = mysqli_fetch_assoc($result); $ExamId = $row["ExamId"]; $ExamName = $row["ExamName"]; $ExamTypeStr = get_exam_type_name_from_id($row["ExamType"]); $ExamStatus = $row["Status"]; $ExamPassword = $row["ExamPassword"]; $CreatedUserId = $row["CreatedUser"]; $CreatedUserName = get_user_name($CreatedUserId); $CreatedTime = $row["CreatedTime"]; $Duration = $row["Duration"]; $ExamEnd = $row["ExamEnd"]; $ExamEndWithOnlyDate = timestamp_to_datetime_with_only_date(strtotime($ExamEnd)); $StatusStr = $ExamStatus == 0 ? "下架" : "上架"; $StatusAction = $ExamStatus == 1 ? "下架" : "上架"; $page_count_display = $page_count + 1; $return_string = $return_string . "<tr>" . "<td>{$page_count_display}</td>" . "<td><span class=\"ExamName fixWidth\">{$ExamName}</span></td>" . "<td><span class=\"ExamType fixWidth\">{$ExamTypeStr}</span></td>" . "<td><span class=\"ExamStatus fixWidth\">{$StatusStr}</span></td>" . "<td><span class=\"ExamStatus fixWidth\">{$ExamPassword}</span></td>" . "<td><span class=\"CreatedUser fixWidth\">{$CreatedUserName}</span></td>" . "<td><span class=\"CreatedTime fixWidth\">{$CreatedTime}</span></td>" . "<td><span class=\"ExamEnd fixWidth\">{$ExamEndWithOnlyDate}</span></td>" . "<td><A OnClick=\"actionSearchExams({$ExamId},{$ExamStatus});\">{$StatusAction}</A><br/>" . "<A OnClick=\"modifySearchExams({$ExamId});\">修改</A><br/>" . "<A OnClick=\"deleteSearchExams({$ExamId});\">删除</A><br/>" . "<A OnClick=\"uploadUserExams({$ExamId});\">上传考试人员名单</A></td>" . "</tr>"; $i++; $page_count++; if ($page_count == $page_size) { $return_string = $return_string . "</table>" . "</div>\n"; $page_no++; $page_count = 0; } } } if ($page_count > 0) { $return_string = $return_string . "</table>" . "</div>\n";
} } } } $str_query1 = $str_query1 . " ORDER BY CreatedTime DESC"; //***Step16 页面搜索SQl语句 结束 ///////////////////// // prepare the SQL command and query DB ///////////////////// $SelectedProbs = array(); if ($result = mysqli_query($link, $str_query1)) { $row_number = mysqli_num_rows($result); if ($row_number == 0) { echo ERR_NOT_ENOUGH_PROBLEM; return; } for ($i = 0; $i < $row_number; $i++) { $row = mysqli_fetch_assoc($result); array_push($SelectedProbs, new Problem($row["ProblemId"], $row["ProblemDesc"], $row["ProblemType"], $row["ProblemLevel"], timestamp_to_datetime_with_only_date(strtotime($row["CreatedTime"])))); } } else { if ($link) { mysqli_close($link); } sleep(DELAY_SEC); echo -__LINE__; return; } $result = array("problems" => $SelectedProbs); echo json_encode($result); return;