function bangding($fromUsername, $uid, $pwd, $type)
{
$sql = "INSERT INTO `user_bangding` (`from_user`, `uid`, `pwd`, `type`) values ('{$fromUsername}', '{$uid}', '{$pwd}', '{$type}')";
$res = _insert_data($sql);
if ($res == 1) {
echo "绑定成功 ↖点击此处返回";
} else {
echo "绑定" . $uid . "失败<br/>请重新绑定~";
}
}
function qingjia($fromUsername, $uid, $name, $long, $info)
{
$time = date('Y-m-d', time());
$endtime = date('Y-m-d', time() + $long);
$sql = "INSERT INTO `user_qingjia` (`from_user`, `uid`, `name`, `time`, `endtime`, `info`) values ('{$fromUsername}', '{$uid}', '{$name}', '{$time}', '{$endtime}', '{$info}')";
$res = _insert_data($sql);
if ($res == 1) {
echo "请假成功 ↖点击此处返回";
} else {
echo "请假" . $uid . "失败<br/>请重试~";
}
}
function bangding($no, $name)
{
require_once './sql.php';
//mysql_query("set names utf8");
mysql_query("set names 'utf8'");
$time = date('y-m-d h:i', time());
$sql = "insert into student (no, name,time,flag) values( '{$no}', '{$name}','{$time}','1')";
$a = _insert_data($sql);
if ($a == 1) {
$contentStr = "签到成功";
echo $_SERVER["REMOTE_ADDR"];
} else {
echo "签到失败<br/>请重新签到";
}
}
$result = _select_data($sql);
$rows = mysql_fetch_assoc($result);
$k_num = $rows["k_num"];
$y_num = $rows["y_num"];
if ($k_num > $y_num) {
$y_num++;
$sql = " UPDATE `course` SET `y_num`= '{$y_num}' where course_num = '{$course_num}' ";
_update_data($sql);
$sql = " select course_name, course_time, course_type from course where course_num = '{$course_num}' ";
$result = _select_data($sql);
$rows = mysql_fetch_assoc($result);
$course_name = $rows["course_name"];
$course_time = $rows["course_time"];
$course_type = $rows["course_type"];
$sql = "insert into course_table(course_num, stu_num, course_name, course_time, course_type) values('{$course_num}', '{$stu_num}', '{$course_name}', '{$course_time}', '{$course_type}')";
_insert_data($sql);
} else {
$i = 1;
break;
}
}
if ($i == 0) {
echo '<script>alert("恭喜你，选课成功！");</script>';
} else {
echo '<script>alert("人数已满！");</script>';
}
}
} else {
echo '<script>alert("还未到选课时间！");</script>';
}
}
/**
* Created by PhpStorm.
* User: Fancy
* Date: 15.12.9
* Time: 17:22
*/
require_once '../sql.php';
if (isset($_POST["submit"])) {
$name = $_POST['name'];
$desc = $_POST['desc'];
$uid = $_POST['uid'];
$long = $_POST['long'];
$time = date('Y-m-d', time());
$endtime = date('Y-m-d', time() + $long);
$sql = "INSERT INTO `user_renwu` (`name`, `time`, `endtime`, `desc`, `uid`) values ('{$name}', '{$time}', '{$endtime}', '{$desc}', '{$uid}')";
$res = _insert_data($sql);
if ($res == 1) {
echo "分配任务成功 ↖点击此处返回";
} else {
echo "分配任务" . $uid . "失败<br/>请重新分配~";
}
exit;
}
$sql = "SELECT * FROM `user_info`";
$res = _select_data($sql);
?>
<div class="container">
<form action="http://wglpt.sinaapp.com/rw/rwsz.php" method="post">
<h2 class="form-signin-heading">请分配任务</h2>
<div class="form-group">
public function responseMsg()
{
//get post data, May be due to the different environments
$postStr = $GLOBALS["HTTP_RAW_POST_DATA"];
//extract post data
if (!empty($postStr)) {
/* libxml_disable_entity_loader is to prevent XML eXternal Entity Injection,
the best way is to check the validity of xml by yourself */
libxml_disable_entity_loader(true);
$postObj = simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);
$fromUsername = $postObj->FromUserName;
$toUsername = $postObj->ToUserName;
$keyword = trim($postObj->Content);
$time = time();
$event = $postObj->Event;
$textTpl = "<xml>\n\t\t\t\t\t\t\t<ToUserName><![CDATA[%s]]></ToUserName>\n\t\t\t\t\t\t\t<FromUserName><![CDATA[%s]]></FromUserName>\n\t\t\t\t\t\t\t<CreateTime>%s</CreateTime>\n\t\t\t\t\t\t\t<MsgType><![CDATA[%s]]></MsgType>\n\t\t\t\t\t\t\t<Content><![CDATA[%s]]></Content>\n\t\t\t\t\t\t\t<FuncFlag>0</FuncFlag>\n\t\t\t\t\t\t\t</xml>";
$imageTpl = "<xml>\n\t\t\t\t\t\t\t<ToUserName><![CDATA[%s]]></ToUserName>\n\t\t\t\t\t\t\t<FromUserName><![CDATA[%s]]></FromUserName>\n\t\t\t\t\t\t\t<CreateTime>%s</CreateTime>\n\t\t\t\t\t\t\t<MsgType><![CDATA[news]]></MsgType>//消息类型为news（图文）\n\t\t\t\t\t\t\t<ArticleCount>1</ArticleCount>//图文数量为1（单图文）\n\t\t\t\t\t\t\t<Articles>\n\t\t\t\t\t\t\t<item>//第一张图文消息\n\t\t\t\t\t\t\t<Title><![CDATA[%s]]></Title> //标题\n\t\t\t\t\t\t\t<Description><![CDATA[%s]]></Description>//描述\n\t\t\t\t\t\t\t<PicUrl><![CDATA[%s]]></PicUrl>//打开前的图片链接地址\n\t\t\t\t\t\t\t<Url><![CDATA[%s]]></Url>//点击进入后显示的图片链接地址\n\t\t\t\t\t\t\t</item>\n\t\t\t\t\t\t\t</Articles>\n\t\t\t\t\t\t\t</xml> ";
if (!empty($event)) {
$gz[0] = " 欢迎使用微管理系统^_^";
$gz[1] = " 【绑定】- 输入关键词或数字\n [1]绑定角色 [2]修改角色\n [3]取消绑定";
$gz[2] = " 【签到】- 输入关键词或数字\n [4]进行签到 [5]查看签到";
$gz[3] = " 【信息】- 输入关键词或数字\n [6]查看信息 [7]更改状态";
$gz[4] = " 【请假】- 输入关键词或数字\n [8]申请请假 [9]审核请假\n [10]查看状态";
// $gz[5] = " 【任务】- 输入关键词或数字\n [11]发布任务 [12]查看任务";
$gz[5] = " 》》》》》 Tips 《《《《《\n 输入'0'、'首页'、'功能'、'菜单'\n 查看功能菜单";
$gz[6] = " Powered By Fan(毕设)";
$num = count($gz);
$gzTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[news]]></MsgType>\n <ArticleCount>{$num}</ArticleCount>\n <Articles>";
for ($i = 0; $i <= $num; $i++) {
$gzTpl .= "<item>\n <Title>{$gz[$i]}</Title>\n <Description></Description>\n <PicUrl><![CDATA[]]></PicUrl>\n <Url><![CDATA[]]></Url>\n </item>";
}
$gzTpl .= "</Articles>\n <FuncFlag>1</FunFlag>\n </xml>";
$resultStr = sprintf($gzTpl, $fromUsername, $toUsername, $time);
echo $resultStr;
}
$sql = "SELECT flag_id FROM user_flags WHERE from_user = '******'";
$result = _select_data($sql);
while ($rows = mysql_fetch_array($result)) {
$user_flag = $rows[flag_id];
}
if (trim($keyword) != $user_flag && is_numeric($keyword)) {
$user_flag = '';
$sql = "DELETE FROM user_flags WHERE from_user = '******'";
_delete_data($sql);
}
if (empty($user_flag)) {
// 功能
if ($keyword == '0' || $keyword == '功能' || $keyword == '首页' || $keyword == '菜单') {
$gz[0] = " 欢迎使用微管理系统^_^";
$gz[1] = " 【绑定】- 输入关键词或数字\n [1]绑定角色 [2]修改权限\n [3]取消绑定";
$gz[2] = " 【签到】- 输入关键词或数字\n [4]进行签到 [5]查看签到";
$gz[3] = " 【信息】- 输入关键词或数字\n [6]查看信息 [7]更改信息";
$gz[4] = " 【请假】- 输入关键词或数字\n [8]申请请假 [9]审核请假\n [10]查看状态";
// $gz[5] = " 【任务】- 输入关键词或数字\n [11]发布任务 [12]查看任务";
$gz[5] = " 》》》》》 Tips 《《《《《\n 输入'0'、'首页'、'功能'、'菜单'\n 查看功能菜单";
$gz[6] = " Powered By Fan(毕设)";
$num = count($gz);
$gzTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[news]]></MsgType>\n <ArticleCount>{$num}</ArticleCount>\n <Articles>";
for ($i = 0; $i <= $num; $i++) {
$gzTpl .= "<item>\n <Title>{$gz[$i]}</Title>\n <Description></Description>\n <PicUrl><![CDATA[]]></PicUrl>\n <Url><![CDATA[]]></Url>\n </item>";
}
$gzTpl .= "</Articles>\n <FuncFlag>1</FunFlag>\n </xml>";
$resultStr = sprintf($gzTpl, $fromUsername, $toUsername, $time);
echo $resultStr;
}
// 用户绑定对应角色
if ($keyword == '1' || $keyword == '绑定角色') {
$sql = "SELECT `uid` FROM `user_bangding` WHERE `from_user` = '{$fromUsername}'";
$result = _select_data($sql);
// 查找是否已存在信息
while ($rows = mysql_fetch_array($result)) {
$data = $rows['uid'];
}
if (empty($data)) {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/bd/bangding.php?openid=' . $fromUsername . '">点击绑定角色~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = "用户" . $data . "已存在\n请重新绑定~";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 用户修改权限
if ($keyword == '2' || $keyword == '修改权限') {
$sql = "SELECT * FROM `user_bangding` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
while ($rows = mysql_fetch_array($res)) {
$data = $rows['type'];
}
if ($data == 1) {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/bd/quanxian.php?openid=' . $fromUsername . '">点击进入修改权限~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = "暂无权限！\n请联系管理员";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 用户解除绑定
if ($keyword == '3' || $keyword == '解绑' || $keyword == '取消绑定') {
$sql = "SELECT * FROM `user_bangding` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
while ($rows = mysql_fetch_array($res)) {
$data = $rows['uid'];
}
if (!empty($data)) {
$sql1 = "UPDATE `user_bangding` SET `from_user` = '' WHERE `uid` = '{$data}'";
$res1 = _update_data($sql1);
if ($res1 == 1) {
$msgType = "text";
$contentStr = '解绑工号成功~';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = '解绑工号失败！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
} else {
$msgType = "text";
$contentStr = '未绑定工号！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 用户签到
if ($keyword == '4' || $keyword == '进行签到') {
// 每天定时corn清空表
$sql = "SELECT `from_user` FROM `user_qiandao` WHERE `from_user` = '{$fromUsername}'";
$result = _select_data($sql);
// 查找是否已存在信息
while ($rows = mysql_fetch_array($result)) {
$data = $rows['from_user'];
}
if (empty($data)) {
// 签到时间为9点，8点开始
$time = strtotime("9:00:00") - time();
if ($time > 0 && $time < 3600) {
$sql = "INSERT INTO `user_qiandao` (`from_user`) values ('{$fromUsername}')";
$res = _insert_data($sql);
if ($res == 1) {
$msgType = "text";
$contentStr = "签到成功~";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = "签到失败\n请重新签到！";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
} elseif ($time > 3600) {
$msgType = "text";
$contentStr = "还没到签到时间！";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
// 添加迟到状态
$qtime = date("H:i:s");
$sql = "INSERT INTO `user_qiandao` (`from_user`, `late`, `time`) values ('{$fromUsername}', '1', '{$qtime}')";
$res = _insert_data($sql);
if ($res == 1) {
$msgType = "text";
$contentStr = "签到成功\n已迟到！";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = "签到失败\n请重新签到！";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
} else {
$msgType = "text";
$contentStr = "你已签到！";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 查看签到
if ($keyword == '5' || $keyword == '查看签到') {
$sql = "SELECT q.`late`, q.`time`, q.`from_user`, i.`uid`, i.`name` FROM `user_qiandao` q, `user_info` i WHERE q.`from_user` = i.`from_user`";
$res = _select_data($sql);
$v = '';
while ($rows = mysql_fetch_array($res)) {
if ($rows['late'] == '1') {
$late = '迟到';
} else {
$late = '正常';
}
$v .= $rows['uid'] . ' ---- ' . $rows['name'] . ' ---- ' . $late . ' ---- ' . $rows['time'] . "\n";
$title = "工号---姓名---状态---时间";
$PicUrl = "";
$Description = $v;
$Url = "";
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
}
}
// 用户信息
if ($keyword == '6' || $keyword == '信息' || $keyword == '查看信息') {
// 先检查用户是否在职
$sql = "SELECT `state` FROM `user_info` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
$rows = mysql_fetch_array($res);
if ($rows['state'] == 1) {
// 开始读取用户列表
$sql = "SELECT * FROM `user_info`";
$res = _select_data($sql);
$v = '';
while ($rows = mysql_fetch_array($res)) {
if ($rows['state'] == 1) {
$state = '在职';
} else {
$state = '其他';
}
$v .= $rows['uid'] . ' ---- ' . $rows['name'] . ' ---- ' . $rows['job'] . ' ---- ' . $state . "\n";
}
$title = "工号---姓名---职务---状态";
$PicUrl = "";
$Description = $v;
$Url = "http://wglpt.sinaapp.com/yh/yhlb.php";
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = '对不起，你没有权限！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 用户编辑
if ($keyword == '7' || $keyword == '更改信息' || $keyword == '更新状态' || $keyword == '信息编辑' || $keyword == '编辑信息') {
// 先检查用户是否在职
$sql = "SELECT `state` FROM `user_info` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
$rows = mysql_fetch_array($res);
if ($rows['state'] == 1) {
// 开始读取用户列表
$sql = "SELECT * FROM `user_info`";
$res = _select_data($sql);
$v = '';
while ($rows = mysql_fetch_array($res)) {
if ($rows['state'] == 1) {
$state = '在职';
} else {
$state = '其他';
}
$v .= $rows['uid'] . ' ---- ' . $rows['name'] . ' ---- ' . $state . "\n";
}
$title = "工号---姓名---状态";
$PicUrl = "";
$Description = $v;
$Url = "http://wglpt.sinaapp.com/yh/yhbj.php";
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = '对不起，你没有权限！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 请假申请
if ($keyword == '8' || $keyword == '请假' || $keyword == '申请请假') {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/qj/qingjia.php?openid=' . $fromUsername . '">点击申请请假~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
// 请假审核
if ($keyword == '9' || $keyword == '审核请假' || $keyword == '请假审核') {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/qj/qjlb.php?openid=' . $fromUsername . '">点击进行请假审核~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
// 请假结果
if ($keyword == '10' || $keyword == '查看状态' || $keyword == '请假结果') {
// 先检查用户是否在职
$sql = "SELECT `state` FROM `user_info` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
$rows = mysql_fetch_array($res);
if ($rows['state'] == 1) {
// 开始读取用户列表
$sql = "SELECT * FROM `user_qingjia`";
$res = _select_data($sql);
$v = '';
while ($rows = mysql_fetch_array($res)) {
if ($rows['pass'] == 1) {
$pass = '******';
} else {
$pass = '******';
}
$v .= $rows['id'] . ' ---- ' . $rows['name'] . ' ---- [ ' . $rows['time'] . ' ~ ' . $rows['endtime'] . ' ] ---- ' . $pass . "\n";
}
$title = "请假序号---姓名---[ 开始时间 ~ 结束时间 ]---状态";
$PicUrl = "";
$Description = $v;
$Url = "";
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = '对不起，你没有权限！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 请假审核
if ($keyword == '11' || $keyword == '任务分配' || $keyword == '任务设置') {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/rw/rwsz.php?openid=' . $fromUsername . '">点击进行任务分配~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
// 查看任务
if ($keyword == '12' || $keyword == '我的任务' || $keyword == '查看任务') {
// 先检查用户是否在职
$sql = "SELECT `uid`, `state` FROM `user_info` WHERE `from_user` = '{$fromUsername}'";
$res = _select_data($sql);
$rows = mysql_fetch_array($res);
$uid = $rows['uid'];
if ($rows['state'] == 1) {
// 开始读取用户列表
$sql = "SELECT * FROM `user_renwu` WHERE `uid` = '{$uid}'";
$res = _select_data($sql);
$v = '';
while ($rows = mysql_fetch_array($res)) {
if ($rows['state'] == 1) {
$state = '完成';
} else {
$state = '未完成';
}
$v .= $rows['id'] . ' ---- ' . $rows['name'] . ' ---- ' . $rows['time'] . ' ---- ' . $rows['endtime'] . ' ---- ' . $state . "\n";
}
$title = "任务序号---任务---开始时间---截止时间---状态";
//
$PicUrl = "";
$Description = $v;
$Url = "http://wglpt.sinaapp.com/rw/rwxq.php?uid={$uid}";
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
} else {
$msgType = "text";
$contentStr = '对不起，你没有权限！';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
}
// 用户绑定对应角色
if ($keyword == '管理员登录') {
$msgType = "text";
$contentStr = '<a href="http://wglpt.sinaapp.com/login.php">管理页面~</a>';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
}
} else {
echo "Input something...";
}
} else {
echo "";
exit;
}
}
public function responseMsg()
{
//get post data, May be due to the different environments
$postStr = $GLOBALS["HTTP_RAW_POST_DATA"];
//extract post data
if (!empty($postStr)) {
$postObj = simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);
$fromUsername = $postObj->FromUserName;
$toUsername = $postObj->ToUserName;
$keyword = trim($postObj->Content);
$time = time();
$event = $postObj->Event;
/******************************************* 文字信息模板 ***********************************************************/
$textTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[text]]></MsgType>\n <Content><![CDATA[%s]]></Content>\n </xml>";
/******************************************* 图文信息模板 ***********************************************************/
$imageTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[news]]></MsgType>//消息类型为news（图文）\n <ArticleCount>1</ArticleCount>//图文数量为1（单图文）\n <Articles>\n <item>//第一张图文消息\n <Title><![CDATA[%s]]></Title> //标题\n <Description><![CDATA[%s]]></Description>//描述\n <PicUrl><![CDATA[%s]]></PicUrl>//打开前的图片链接地址\n <Url><![CDATA[%s]]></Url>//点击进入后显示的图片链接地址\n </item>\n </Articles>\n </xml> ";
/********************************************* 关注事件 **************************************************************/
if (!empty($event)) {
/* $sql = "insert into sleep_man (`from_user`,`flag`) VALUES ('$fromUsername',0)";
_insert_data($sql);*/
$contentStr = "发送对应数字或关键词进行使用：\n【1】师大要闻\n【2】最新公告\n【3】查询成绩[需绑定]\n【4】查询四六级成绩\n【5】查询图书馆藏书\n【6】在线翻译\n【7】校园地图\n【8】查询快递单号\n【9】睡觉签到[8~12点]\n【10】玩游戏\n【11】阅览新闻\n【12】微社区[荐]\n【#】取消学号绑定\n【0】返回主界面\n" . '<a href="http://1.shnupartner.sinaapp.com/stu.php?openid=' . $postObj->FromUserName . '">绑定教务使用全部功能</a>' . "\n-----------------------\n此外你还可以尝试发送如：奉贤天气、火车票、飞机票等关键词~\n更多的彩蛋等待着你的发现*^_^* \n[注]:由于手机屏幕、字体大小等因素，小伙伴发送的消息样式无法做到统一，但不影响功能使用，敬请谅解。\n问题反馈及合作请发送邮件至\nff66@vip.qq.com\n<!-- Thanks -->";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
}
/****************************************************** 判断用户状态，若状态与上次不一致，则删除上次状态 **********************************************************/
$sql = "SELECT flag_id FROM user_flags WHERE from_user = '******'";
$result = _select_data($sql);
while (!!($rows = mysql_fetch_array($result))) {
$user_flag = $rows[flag_id];
}
if (trim($keyword) != $user_flag && is_numeric($keyword)) {
$user_flag = '';
$sql = "DELETE FROM user_flags WHERE from_user = '******'";
_delete_data($sql);
}
/*********************************************** flag为空时，选择的路径 **************************************/
if (empty($user_flag)) {
//要闻
if ($keyword == '1' || $keyword == "要闻" || $keyword == "师大要闻") {
$items = sdyw();
$itemTpl = "<item>\n <Title><![CDATA[%s]]></Title>\n <Description><![CDATA[%s]]></Description>\n <PicUrl><![CDATA[%s]]></PicUrl>\n <Url><![CDATA[%s]]></Url>\n </item>";
$articles = '';
foreach ($items as $key) {
$articles .= sprintf($itemTpl, $key['Title'], $key['Description'], $key['PicUrl'], $key['Url']);
}
$newsTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[%s]]></MsgType>\n <ArticleCount><![CDATA[%s]]></ArticleCount>\n <Articles>%s</Articles>\n </xml>";
echo sprintf($newsTpl, $fromUsername, $toUsername, $time, 'news', count($items), $articles);
} else {
if ($keyword == '2' || $keyword == "公告" || $keyword == "最新公告") {
$items = zxgg();
$itemTpl = "<item>\n <Title><![CDATA[%s]]></Title>\n <Description><![CDATA[%s]]></Description>\n <PicUrl><![CDATA[%s]]></PicUrl>\n <Url><![CDATA[%s]]></Url>\n </item>";
$articles = '';
foreach ($items as $key) {
$articles .= sprintf($itemTpl, $key['Title'], $key['Description'], $key['PicUrl'], $key['Url']);
}
$newsTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[%s]]></MsgType>\n <ArticleCount><![CDATA[%s]]></ArticleCount>\n <Articles>%s</Articles>\n </xml>";
echo sprintf($newsTpl, $fromUsername, $toUsername, $time, 'news', count($items), $articles);
} else {
if ($keyword == '8' || $keyword == "地图" || $keyword == "校园" || $keyword == "校园地图") {
$items = trip();
$itemTpl = "<item>\n <Title><![CDATA[%s]]></Title>\n <Description><![CDATA[%s]]></Description>\n <PicUrl><![CDATA[%s]]></PicUrl>\n <Url><![CDATA[%s]]></Url>\n </item>";
$articles = '';
foreach ($items as $key) {
$articles .= sprintf($itemTpl, $key['Title'], $key['Description'], $key['PicUrl'], $key['Url']);
}
$newsTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[%s]]></MsgType>\n <ArticleCount><![CDATA[%s]]></ArticleCount>\n <Articles>%s</Articles>\n </xml>";
echo sprintf($newsTpl, $fromUsername, $toUsername, $time, 'news', count($items), $articles);
} else {
if ($keyword == '3' || $keyword == "成绩" || $keyword == "查成绩" || $keyword == "查询成绩" || $keyword == "考试成绩" || $keyword == "成绩查询") {
$sql = "select stu_no,stu_wd from students where from_user = '******'";
$result = _select_data($sql);
if (!!($rows = mysql_fetch_array($result))) {
$i = post($fromUsername);
$title = "查询";
//标题
$PicUrl = "";
//图片链接
$Description = $i;
//图文描述
$Url = "";
//打开后的图片链接
$resultStr = sprintf($imageTpl, $fromUsername, $toUsername, $time, $title, $Description, $PicUrl, $Url);
echo $resultStr;
} else {
// $msgType = "text";
$contentStr = '<a href="http://shnucs.duapp.com/stu.php?openid=' . $postObj->FromUserName . '">请先点击绑定学号╮(╯_╰)╭</a>
---------------
[输入0返回主页]';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
}
} else {
if ($keyword == '4' || $keyword == "四六级" || $keyword == "四级" || $keyword == "六级") {
$sql = "insert into user_flags(from_user,flag_id) values('{$fromUsername}','4')";
$contentStr = '请输入要您的四级或六级
考号+姓名(无空格)
格式如：12345***123李四
或<a href="http://1.shnuweb.sinaapp.com/siliuji/cet.php">点击此处进入查询~</a>
---------------
[输入0返回主页]';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
} else {
if ($keyword == '19' || $keyword == "最火游戏" || $keyword == "游戏" || $keyword == "玩游戏" || $keyword == "最新游戏") {
$contentStr = '点击【每一行】文字进入游戏~
<a href="http://1.shnugame.sinaapp.com/sjm2/index.html">① 围住神经猫Ⅱ</a>
<a href="http://1.shnupartner.sinaapp.com/2048/2048-master/index.html">② 2048</a>
<a href="http://1.shnupartner.sinaapp.com/games/bcbk.html">③ 别踩白块</a>
<a href="http://1.shnugame.sinaapp.com/onedie/index.htm">④ 一个都不能死</a>
---------------
[输入0返回主页]';
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
} else {
if ($keyword == '#' || $keyword == "取消绑定" || $keyword == "取消绑定学号") {
$sql = "select stu_no from students where from_user = '******'";
$result = _select_data($sql);
$row = mysql_fetch_array($result);
$no = $row[stu_no];
$sql = "delete from students where from_user = '******'";
$result = _delete_data($sql);
if ($result == 1) {
$contentStr = "取消绑定学号" . $no . "成功，重新发送【3】查询成绩进行绑定~~~";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
} else {
$contentStr = "取消绑定失败，请重新尝试";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
}
} else {
if ($keyword == '5' || $keyword == "图书" || $keyword == "图书馆" || $keyword == "图书检索" || $keyword == "图书查询" || $keyword == "查询图书") {
$sql = "insert into user_flags(from_user,flag_id) values('{$fromUsername}','5')";
$contentStr = "请输入要查询图书的关键字：\n---------------\n[输入0返回主页]";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
}
}
}
}
}
}
}
}
/************************************* 插入数据 ****************************************/
if (!empty($sql)) {
_insert_data($sql);
}
} else {
if ($user_flag == '4') {
$b = cet($keyword);
$contentStr = "学校：" . $b[school] . "\n" . "姓名：" . $b[name] . "\n" . "等级：" . $b[cet] . "\n" . "分数：" . $b[score];
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
} else {
if ($user_flag == '5') {
book($keyword, $fromUsername, $toUsername, $time);
/*$url = "http://202.121.55.6:8080/opac/search_rss.php?location=ALL&title={$keyword}&doctype=ALL&lang_code=ALL&match_flag=forward&displaypg=20&showmode=list&orderby=DESC&sort=CATA_DATE&onlylendable=yes&with_ebook=&with_ebook=";
$fa = file_get_contents($url);
$f = simplexml_load_string($fa);
foreach($f->channel->item as $reply)
{
foreach($reply->title as $re)
{
$a[] = $re;
}
}
$no = count($a);
if ($no > 10)
{
$no = 10;
}
$bookTpl =
"<xml>
<ToUserName><![CDATA[%s]]></ToUserName>
<FromUserName><![CDATA[%s]]></FromUserName>
<CreateTime>%s</CreateTime>
<MsgType><![CDATA[news]]></MsgType>
<ArticleCount>$no</ArticleCount>
<Articles>";
foreach($a as $id=>$b)
{
if($id>$no) break;
else null;
$bookTpl.=
"<item>
<Title>$b</Title>
<Description><![CDATA[s]]></Description>
<PicUrl><![CDATA[]]></PicUrl>
<Url><![CDATA[]]></Url>
</item>";
}
$bookTpl.=
"</Articles>
<FuncFlag>1</FunFlag>
</xml>";
$resultStr = sprintf($bookTpl, $fromUsername, $toUsername, $time);
echo $resultStr;*/
}
}
}
} else {
echo "";
exit;
}
}
public function responseMsg()
{
//---------- 接 收 数 据 ---------- //
$postStr = $GLOBALS["HTTP_RAW_POST_DATA"];
//获取POST数据
//用SimpleXML解析POST过来的XML数据
date_default_timezone_set("PRC");
$postObj = simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);
$fromUsername = $postObj->FromUserName;
//获取发送方帐号（OpenID）
$toUsername = $postObj->ToUserName;
//获取接收方账号
$keyword = trim($postObj->Content);
//获取消息内容
$time = date("Y-m-d H:i:s", time());
//date('h:i',time()); //获取当前时间戳
$keywords = explode(" ", $keyword);
//---------- 返 回 数 据 ---------- //
//返回消息模板
$textTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[%s]]></MsgType>\n <Content><![CDATA[%s]]></Content>\n <FuncFlag>0</FuncFlag>\n </xml>";
if ($keywords[0] == '取消') {
$delete_sql = "delete from list where number = ' {$keywords['1']} '";
$res = _delete_data($delete_sql);
if ($res == 1) {
$contentStr = "预订取消完成";
} elseif ($res == 0) {
$contentStr = "取消失败";
} elseif ($res == 2) {
$contentStr = "没有预订，不能取消";
}
} elseif (trim($keywords[0] == '预订')) {
$insert_sql = "INSERT INTO list(name, number,data,star) VALUES('{$keywords['1']}','{$keywords['2']}','{$time}','2')";
$res = _insert_data($insert_sql);
if ($res == 1) {
$contentStr = "Dear " . $keywords[1] . "，你已经成功预订" . $keywords[2] . "号，Good Luck！";
} elseif ($res == 0) {
$contentStr = "不能重复预定";
}
} elseif (trim($keywords[0] == '大神预订')) {
$insert_sql = "INSERT INTO list(name, number,data,star) VALUES('{$keywords['1']}','{$keywords['2']}','{$time}','3')";
$res = _insert_data($insert_sql);
if ($res == 1) {
$contentStr = "Dear " . $keywords[1] . "大神，你已经成功预订" . $keywords[2] . "号，Good Luck！";
} elseif ($res == 0) {
$contentStr = "不能重复预定";
}
} elseif (trim($keywords[0] == '帮忙预订')) {
$insert_sql = "INSERT INTO list(name, number) VALUES('{$keywords['1']}','{$keywords['2']}')";
$res = _insert_data($insert_sql);
if ($res == 1) {
$contentStr = "Dear " . $keywords[1] . "，你已经成功预订" . $keywords[2] . "号，Good Luck！";
} elseif ($res == 0) {
$contentStr = "不能重复预定";
}
} elseif (trim($keywords[0] == '查询')) {
$flag1;
$flag2;
$select_sql1 = "SELECT * FROM list WHERE star=2 ORDER BY number";
$select_res1 = _select_data($select_sql1);
if ($select_res1) {
while ($rows = mysql_fetch_array($select_res1)) {
$contentStr1 = $contentStr1 . $rows[2] . "号 " . date("H:i", strtotime($rows[3])) . " 预订人：" . $rows[1] . "\n";
}
$flag1 = 1;
} else {
$flag1 = 0;
}
$select_sql2 = "SELECT * FROM list WHERE star=3 ORDER BY number";
$select_res2 = _select_data($select_sql2);
if ($select_res2) {
while ($rows = mysql_fetch_array($select_res2)) {
$contentStr2 = $contentStr2 . $rows[2] . "号 " . date("H:i", strtotime($rows[3])) . " 预订人：" . $rows[1] . "\n";
}
$flag2 = 1;
} else {
$flag2 = 0;
}
if ($flag1 + $flag2 > 0) {
$contentStr = " 三星十本名单\n" . $contentStr2 . "\n" . " 普通预定名单" . "\n" . $contentStr1;
} else {
$contentStr = "还没人预定";
}
} elseif (trim($keywords[0] == '我们都是基佬')) {
$select_sql = "TRUNCATE TABLE list";
$select_res = _clear_table($select_sql);
$contentStr = "清空成功";
} else {
$contentStr = "欢迎来到傲寒团战预定平台！\n\n一、查询请输入：查询\n二、预定请输入：预订 游戏昵称 号码，中间有空格，例如：预订 粟米 50，十本三星预定请输入：大神预定 游戏id 号码\n三、取消请输入：取消 号码，例如;取消 12\n注意：预定后请抓紧时间打，普通预定2个小时之后就会自动删除掉，三星十本为5小时！如果忘记格式请输入任意字符查看本消息。如有好的改进建议请@letsdestroy";
}
$msgType = "text";
//消息类型
//格式化消息模板
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);
echo $resultStr;
//输出结果
}
public function responseMsg()
{
//get post data, May be due to the different environments
$postStr = $GLOBALS["HTTP_RAW_POST_DATA"];
//extract post data
if (!empty($postStr)) {
$postObj = simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);
$fromUsername = $postObj->FromUserName;
$toUsername = $postObj->ToUserName;
$keyword = trim($postObj->Content);
$time = time();
$event = $postObj->Event;
$textTpl = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[text]]></MsgType>\n <Content><![CDATA[%s]]></Content>\n </xml>";
$newsTpl1 = "<xml>\n <ToUserName><![CDATA[%s]]></ToUserName>\n <FromUserName><![CDATA[%s]]></FromUserName>\n <CreateTime>%s</CreateTime>\n <MsgType><![CDATA[news]]></MsgType>\n <ArticleCount>1</ArticleCount>\n <Articles>\n <item>\n <Title><![CDATA[xxx]]></Title>\n <Description><![CDATA[xxx]]></Description>\n <PicUrl><![CDATA[http://xxx/images/fm.jpg]]></PicUrl>\n <Url><![CDATA[http://xxx/index.php?openid=" . $postObj->FromUserName . "]]></Url>\n </item>\n </Articles>\n </xml> ";
if (!empty($event)) {
$sql = "insert into score (`id`,`fenshu`,`paiming`) VALUES ('{$fromUsername}',1,0)";
_insert_data($sql);
$resultStr = sprintf($newsTpl1, $fromUsername, $toUsername, $time);
echo $resultStr;
}
if (empty($user_flag)) {
if ($keyword == "xx") {
$sql = "SELECT fenshu FROM score WHERE id = '{$fromUsername}'";
$result = _select_data($sql);
$n = mysql_fetch_array($result);
$q = $n['fenshu'];
if ($q == 100) {
$sql = "SELECT paiming FROM score WHERE id='{$fromUsername}'";
$result = _select_data($sql);
$n = mysql_fetch_array($result);
$p = $n['paiming'];
//$contentStr=$p;
if ($p == 0) {
$sql = "SELECT count(id) as shu FROM score WHERE fenshu = '100'";
$result = _select_data($sql);
$n = mysql_fetch_array($result);
$q = $n['shu'];
// $n=mysql_fetch_array($result);
//$q = $n['fenshu'];
//$contentStr=$q;
$contentStr = 'xxx';
$sql = "UPDATE `score` SET `paiming`= '{$q}' where id = '{$fromUsername}'";
_update_data($sql);
} else {
$contentStr = 'xxx';
}
} else {
if ($q == 0) {
$contentStr = 'xxx';
} else {
$contentStr = 'xxx';
}
}
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $contentStr);
echo $resultStr;
}
if (!empty($sql)) {
_insert_data($sql);
}
} else {
}
} else {
echo "";
exit;
}
}
