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; } }