if ($class_id) {
$class_value = $mysql->getLine("select * from class where class_id={$class_id}");
if (!$class_value) {
echo "<script>alert('无此部门');history.back();</Script>";
exit;
}
}
//如果获取到操作标识，进行录入或者修改操作
if ($action == "update") {
//获取表单传入数据
$old_class_id = $_POST["class_id"];
$class_name = $_POST["class_name"];
$class_fid = $_POST["class_fid"];
//传入数据过滤
$old_class_id = intval($old_class_id);
$class_name = string::un_script_code($class_name);
$class_fid = intval($class_fid);
//默认参数
$nowtime = date("Y/m/d H:i:s", time());
//如果是修改
if ($old_class_id) {
//修改部门名称、所属、更新时间
$sql = "update class set class_name='{$class_name}',class_fid='{$class_fid}',edittime='{$nowtime}'\n where class_id={$old_class_id}";
$mysql->runSql($sql);
} else {
//新增
$sql = "insert into class (class_name,class_fid,addtime,edittime,status) values ('{$class_name}',\n '{$class_fid}','{$nowtime}','{$nowtime}',1)";
$mysql->runSql($sql);
}
if ($mysql->errno() != 0) {
echo "<script>alert('" . $mysql->errmsg() . "');history.back();</Script>";
<html>
<HEAD>
<meta charset="utf-8">
<TITLE>部门管理</TITLE>
</HEAD>
<body>
<?php
include "base-class.php";
//新建sae数据库类
$mysql = new SaeMysql();
//获取当前页码
$page = intval($_GET["page"]);
//获取操作标识传入
$action = $_GET["action"];
$action = string::un_script_code($action);
$action = string::un_html($action);
//是否删除
if ($action == "del") {
//获取部门ID号传入
$class_id = intval($_GET["class_id"]);
//获取当前时间
$nowtime = date("Y/m/d H:i:s", time());
$mysql->runSql("update class set status=0,edittime='{$nowtime}' where class_id={$class_id}");
echo "<script>alert('操作成功！');location='class_manager.php?page={$page}';</Script>";
exit;
}
//列表数据获取、分页
//计算总数
$count = $mysql->getVar("select COUNT(*) from class where status=1");
//如果数据表里有数据
//订阅事件
if ($form_Event == "subscribe") {
//欢迎词
$welcome_str = "欢迎来到YYF答题系统\n\n\n已添加由\n“NEUQ ACM俱乐部”\n提供的\n《计算机基础》题库。\n===NEUQ ACM===\n每次问答系统将从题库中随机抽取" . $question_nums . "道题目，都为单选题，输入选项对应字母答题。\n\n准备好了吗？输入“go”进行答题:\n（答案已尽量修正，若还有错误，请谅解）";
//回复欢迎文字消息
$msgType = "text";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, $welcome_str);
echo $resultStr;
exit;
}
}
//用户文字回复进行绑定、查询等操作
if ($form_MsgType == "text") {
//获取用户发送的文字内容并过滤
$form_Content = trim($postObj->Content);
$form_Content = string::un_script_code($form_Content);
//如果发送内容不是空白则执行相应操作
if (!empty($form_Content)) {
//用户帮助提示
if (strtolower($form_Content) == "help") {
//帮助词
$help_str = "感谢使用微信答题系统\n\n每次问答系统将从题库中随机抽取" . $question_nums . "道题目，都为单选题，输入选项对应字母答题\n\n输入“exit”退出当前答题\n\n输入“best”查询最好成绩\n\n输入“history”查询历史答题记录\n\n准备好了吗？输入“go”进行答题：";
//回复文字消息
$msgType = "text";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, $help_str);
echo $resultStr;
exit;
}
//用户跳出操作
if (strtolower($form_Content) == "exit") {
//清空memcache动作
echo "<script>alert('无此题目');history.back();</Script>";
exit;
}
}
//如果获取到操作标识，进行录入或者修改操作
if ($action == "update") {
//获取表单传入数据
$old_question_id = $_POST["question_id"];
$question_subject = $_POST["question_subject"];
$question_options = $_POST["question_options"];
$question_true = $_POST["question_true"];
//传入数据过滤
$old_question_id = intval($old_question_id);
$question_subject = string::un_script_code($question_subject);
$question_options = string::un_script_code($question_options);
$question_true = string::un_script_code($question_true);
//检测必填项
if (!$question_subject) {
echo "<script>alert('请输入问题题目');history.back();</Script>";
exit;
}
if (!$question_options) {
echo "<script>alert('请输入问题选项');history.back();</Script>";
exit;
}
if (!$question_true) {
echo "<script>alert('请输入正确答案');history.back();</Script>";
exit;
}
//默认参数
$nowtime = date("Y/m/d H:i:s", time());
